From ef16637d0f6822f326266f50b496f294ecd53cba Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Wed, 30 Apr 2025 01:25:44 +0500
Subject: feat: featured emotes

---
 database.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index a2df999..1340d36 100644
--- a/database.sql
+++ b/database.sql
@@ -23,7 +23,9 @@ CREATE TABLE IF NOT EXISTS emotes (
     ext TEXT NOT NULL,
     uploaded_by INTEGER REFERENCES users(id),
     created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
-    visibility INTEGER NOT NULL
+    updated_at TIMESTAMP NOT NULL,
+    visibility INTEGER NOT NULL,
+    is_featured BOOLEAN NOT NULL DEFAULT false
 );
 
 CREATE TABLE IF NOT EXISTS emote_sets (
-- 
cgit v1.2.3

