From 9c3f1ea5ffe9ad70caf306faff7a3e3948cef6ab Mon Sep 17 00:00:00 2001
From: Anhgelus Morhtuuzh <william@herges.fr>
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

