From 8c148952a95ee756038bc0e7afbf52f63249227f Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Wed, 30 Apr 2025 00:49:05 +0500 Subject: feat: emote visibility --- database.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database.sql') diff --git a/database.sql b/database.sql index bc352de..a2df999 100644 --- a/database.sql +++ b/database.sql @@ -22,7 +22,8 @@ CREATE TABLE IF NOT EXISTS emotes ( mime TEXT NOT NULL, ext TEXT NOT NULL, uploaded_by INTEGER REFERENCES users(id), - created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP + created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP, + visibility INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS emote_sets ( -- cgit v1.2.3