diff options
| author | ilotterytea <iltsu@alright.party> | 2025-04-30 01:25:44 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-04-30 01:25:44 +0500 |
| commit | ef16637d0f6822f326266f50b496f294ecd53cba (patch) | |
| tree | 7e7353e8fab299a53fff0282f8a2f816a728f000 /database.sql | |
| parent | ea85d9383460d1957158b023b3b3647d3026687f (diff) | |
feat: featured emotes
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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 ( |