feat(config): preload role reactfeat/leave-gorm

1 files changed, 4 insertions, 5 deletions

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