diff options
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) ); |