summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2018-02-04 15:47:53 +0100
committerYorhel <git@yorhel.nl>2018-02-04 15:47:55 +0100
commitb0fbff7169b2d6c7176ae0648f323fd764139bfa (patch)
tree30d3b536e291aee2116b9ef9ae84734b62665ffc
parentcac732abbadc6a76fbe9b73360aa1aef5c1ba272 (diff)
SQL: Load permissions after creating sequences
Otherwise the vndb_site/_multi users won't have usage rights on those. Fixes https://vndb.org/t10218.6
-rw-r--r--util/sql/all.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 587f7440..b3a87948 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -45,14 +45,14 @@ CREATE TYPE vn_relation AS ENUM ('seq', 'preq', 'set', 'alt', 'char', 'sid
\i util/sql/triggers.sql
--- permissions
-
-\i util/sql/perms.sql
-
-- Sequences used for ID generation of items not in the DB
CREATE SEQUENCE covers_seq;
CREATE SEQUENCE charimg_seq;
+-- permissions
+
+\i util/sql/perms.sql
+
-- Rows that are assumed to be available
INSERT INTO users (id, username, mail, perm) VALUES (0, 'deleted', 'del@vndb.org', 0);