diff options
author | Yorhel <git@yorhel.nl> | 2018-02-04 15:47:53 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2018-02-04 15:47:55 +0100 |
commit | b0fbff7169b2d6c7176ae0648f323fd764139bfa (patch) | |
tree | 30d3b536e291aee2116b9ef9ae84734b62665ffc /util | |
parent | cac732abbadc6a76fbe9b73360aa1aef5c1ba272 (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
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/all.sql | 8 |
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); |