summaryrefslogtreecommitdiff
path: root/migrations/2024-05-11T02-53-05_init/up.sql
diff options
context:
space:
mode:
authorilotterytea <iltsu@alright.party>2025-12-07 23:11:37 +0500
committerilotterytea <iltsu@alright.party>2025-12-07 23:11:37 +0500
commitb592185b654d20b540b09b81854183c85c5a5467 (patch)
tree5c93864ae0e9c4ce8b55130a62ccb13ebd011ced /migrations/2024-05-11T02-53-05_init/up.sql
parentd4e3141dd7c32fdb2c1a1583fbd63079642d1447 (diff)
fix: emojis were not supported in custom commandsHEADmaster
Diffstat (limited to 'migrations/2024-05-11T02-53-05_init/up.sql')
-rw-r--r--migrations/2024-05-11T02-53-05_init/up.sql4
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)
);