diff options
| author | ilotterytea <iltsu@alright.party> | 2025-12-07 23:11:37 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-12-07 23:11:37 +0500 |
| commit | b592185b654d20b540b09b81854183c85c5a5467 (patch) | |
| tree | 5c93864ae0e9c4ce8b55130a62ccb13ebd011ced /migrations/2024-05-11T02-53-05_init | |
| parent | d4e3141dd7c32fdb2c1a1583fbd63079642d1447 (diff) | |
Diffstat (limited to 'migrations/2024-05-11T02-53-05_init')
| -rw-r--r-- | migrations/2024-05-11T02-53-05_init/up.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/2024-05-11T02-53-05_init/up.sql b/migrations/2024-05-11T02-53-05_init/up.sql index b33f1e4..6764a14 100644 --- a/migrations/2024-05-11T02-53-05_init/up.sql +++ b/migrations/2024-05-11T02-53-05_init/up.sql @@ -61,14 +61,14 @@ CREATE TABLE IF NOT EXISTS event_subscriptions ( CREATE TABLE IF NOT EXISTS custom_commands ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, channel_id INTEGER NOT NULL REFERENCES channels(id) ON DELETE CASCADE, - name TEXT NOT NULL, + name TEXT NOT NULL CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, message TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS custom_command_aliases ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, command_id INTEGER NOT NULL REFERENCES custom_commands(id) ON DELETE CASCADE, - name TEXT NOT NULL, + name TEXT NOT NULL CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, CONSTRAINT unique_command_alias UNIQUE (command_id, name) ); |
