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