feat: add sounds (wip doe)HEADmaster

1 files changed, 8 insertions, 0 deletions

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