aboutsummaryrefslogtreecommitdiff
path: root/databaseschema.psql
diff options
context:
space:
mode:
authorFChannel <>2021-07-22 19:03:28 -0700
committerFChannel <>2021-07-22 19:03:28 -0700
commit16b4165e5102fc9b4766e1bd1204ca9cf23199aa (patch)
tree0a491330799a37558a4d85648f29c45b5311ef59 /databaseschema.psql
parent213683bf7245a05aa734ac2bb26fba60705ba5ee (diff)
added banning media by saving hash in database
Diffstat (limited to 'databaseschema.psql')
-rw-r--r--databaseschema.psql7
1 files changed, 6 insertions, 1 deletions
diff --git a/databaseschema.psql b/databaseschema.psql
index 954aa2e..67681cd 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -232,4 +232,9 @@ id serial primary key,
regex varchar(200)
);
-ALTER TABLE actor ADD COLUMN IF NOT EXISTS autosubscribe boolean default false; \ No newline at end of file
+ALTER TABLE actor ADD COLUMN IF NOT EXISTS autosubscribe boolean default false;
+
+CREATE TABLE IF NOT EXISTS bannedmedia(
+id serial primary key,
+hash varchar(200)
+); \ No newline at end of file