From ac5b69edf724d164c2150dfc96129335b9225299 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
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

