From 0b76e5d6a8d33e64e67438c10cd3d12e622d042b Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sun, 26 Oct 2025 18:07:48 +0500
Subject: feat: add sounds (wip doe)

---
 database.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 42a6b50..ee3d285 100644
--- a/database.sql
+++ b/database.sql
@@ -20,4 +20,12 @@ CREATE TABLE IF NOT EXISTS sounds (
     code TEXT NOT NULL,
     uploaded_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
     uploaded_by BIGINT REFERENCES users(id)
+);
+
+CREATE TABLE IF NOT EXISTS added_sounds (
+    id BIGINT PRIMARY KEY AUTO_INCREMENT,
+    sound_id BIGINT NOT NULL REFERENCES sounds(id),
+    emote_id TEXT NOT NULL,
+    added_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
+    UNIQUE (sound_id, emote_id)
 );
\ No newline at end of file
-- 
cgit v1.2.3

