From 0b76e5d6a8d33e64e67438c10cd3d12e622d042b Mon Sep 17 00:00:00 2001 From: ilotterytea 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