summaryrefslogtreecommitdiff
path: root/database.sql
diff options
context:
space:
mode:
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 (