From ac5b69edf724d164c2150dfc96129335b9225299 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Sun, 20 Apr 2025 18:02:53 +0500 Subject: feat: emote addition --- database.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 3436b2c..cff3e93 100644 --- a/database.sql +++ b/database.sql @@ -22,4 +22,28 @@ CREATE TABLE IF NOT EXISTS emotes ( ext TEXT NOT NULL, uploaded_by INTEGER REFERENCES users(id), created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP +); + +CREATE TABLE IF NOT EXISTS emote_sets ( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + owner_id INTEGER NOT NULL REFERENCES users(id), + linked_to INTEGER REFERENCES emote_sets(id), + name TEXT NOT NULL, + size INTEGER +); + +CREATE TABLE IF NOT EXISTS emote_set_contents ( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + emote_set_id INTEGER NOT NULL REFERENCES emote_sets(id), + emote_id INTEGER NOT NULL REFERENCES emotes(id), + name TEXT, + added_by INTEGER NOT NULL REFERENCES users(id), + created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP +); + +CREATE TABLE IF NOT EXISTS acquired_emote_sets ( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + user_id INTEGER NOT NULL, + emote_set_id INTEGER NOT NULL, + is_default BOOLEAN NOT NULL DEFAULT false ); \ No newline at end of file -- cgit v1.2.3