feat: tags

1 files changed, 11 insertions, 0 deletions

diff --git a/database.sql b/database.sql
index 6ce0c96..5f3bfbc 100644
--- a/database.sql
+++ b/database.sql
@@ -30,6 +30,17 @@ CREATE TABLE IF NOT EXISTS emotes (
     visibility INTEGER NOT NULL
 );
 
+CREATE TABLE IF NOT EXISTS tags (
+    id CHAR(32) NOT NULL PRIMARY KEY DEFAULT REPLACE(UUID(),'-',''),
+    code TEXT NOT NULL UNIQUE
+);
+
+CREATE TABLE IF NOT EXISTS tag_assigns (
+    id CHAR(32) NOT NULL PRIMARY KEY DEFAULT REPLACE(UUID(),'-',''),
+    tag_id CHAR(32) NOT NULL REFERENCES tags(id) ON DELETE CASCADE,
+    emote_id CHAR(32) NOT NULL REFERENCES emote(id) ON DELETE CASCADE
+);
+
 CREATE TABLE IF NOT EXISTS emote_sets (
     id CHAR(32) NOT NULL PRIMARY KEY DEFAULT REPLACE(UUID(),'-',''),
     owner_id CHAR(32) NOT NULL REFERENCES users(id) ON DELETE CASCADE,