diff options
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 ( |