From 9c3f1ea5ffe9ad70caf306faff7a3e3948cef6ab Mon Sep 17 00:00:00 2001 From: Anhgelus Morhtuuzh Date: Mon, 9 Mar 2026 18:47:40 +0100 Subject: feat(config): preload role react --- migrations/000-leave-gorm.sql | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'migrations/000-leave-gorm.sql') diff --git a/migrations/000-leave-gorm.sql b/migrations/000-leave-gorm.sql index e3aa71a..a6391a4 100644 --- a/migrations/000-leave-gorm.sql +++ b/migrations/000-leave-gorm.sql @@ -30,16 +30,15 @@ CREATE TABLE IF NOT EXISTS xp_roles ( ); CREATE TABLE IF NOT EXISTS role_react_messages ( - id SERIAL PRIMARY KEY, - message_id snowflake UNIQUE, + message_id snowflake PRIMARY KEY, channel_id snowflake, guild_id snowflake REFERENCES guilds(id) ON DELETE CASCADE, note TEXT ); CREATE TABLE IF NOT EXISTS role_reacts ( + id SERIAL PRIMARY KEY, role snowflake, - message_id INTEGER REFERENCES role_react_messages(id) ON DELETE CASCADE, - reaction TEXT, - PRIMARY KEY(role, message_id, reaction) + message_id INTEGER REFERENCES role_react_messages(message_id) ON DELETE CASCADE, + reaction TEXT ); -- cgit v1.2.3