summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-05-11 13:04:45 +0200
committerYorhel <git@yorhel.nl>2020-05-11 13:04:45 +0200
commit3c5907b376019b2790813c540ca062a8dff35fdc (patch)
tree3331eb1169102063a2df10854a21201c7132fbee /util
parentb4c0012ff0f2a6c4845879b4a752ff9c399ebb68 (diff)
imgflag: Add sexual/violence user preferences + show/hide character images
Diffstat (limited to 'util')
-rw-r--r--util/updates/2020-05-11-imgflag-preferences.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2020-05-11-imgflag-preferences.sql b/util/updates/2020-05-11-imgflag-preferences.sql
new file mode 100644
index 00000000..98fbc1c5
--- /dev/null
+++ b/util/updates/2020-05-11-imgflag-preferences.sql
@@ -0,0 +1,4 @@
+ALTER TABLE users ADD COLUMN max_sexual smallint NOT NULL DEFAULT 0;
+ALTER TABLE users ADD COLUMN max_violence smallint NOT NULL DEFAULT 0;
+UPDATE users SET max_sexual = 2, max_violence = 2 WHERE show_nsfw;
+\i sql/perms.sql