summaryrefslogtreecommitdiff
path: root/database.sql
diff options
context:
space:
mode:
authorilotterytea <iltsu@alright.party>2025-04-30 00:49:05 +0500
committerilotterytea <iltsu@alright.party>2025-04-30 00:49:05 +0500
commit8c148952a95ee756038bc0e7afbf52f63249227f (patch)
treec1dd07ee6c7fbd40437a9c754831968ada6004e8 /database.sql
parent6e27fb9de11843b7bb605fe85cb628b6e4882787 (diff)
feat: emote visibility
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql3
1 files changed, 2 insertions, 1 deletions
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 (