Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema.sql @ 55:40f64a96481f
Adjust database user arrangements and grant schema privs.
author | David A. Holland |
---|---|
date | Sun, 10 Apr 2022 19:36:29 -0400 |
parents | debc55088b4f |
children |
comparison
equal
deleted
inserted
replaced
54:36d91dfe017f | 55:40f64a96481f |
---|---|
1 -- Load the database schema. | 1 -- Load the database schema. |
2 -- Should be done as the swallowtail_admin user. | 2 -- Should be done as the swallowtail_owner user. |
3 | 3 |
4 begin; | 4 BEGIN; |
5 | 5 |
6 \ir schema/version.sql | 6 \ir schema/version.sql |
7 \ir schema/config.sql | 7 \ir schema/config.sql |
8 | 8 |
9 \ir schema/users.sql | 9 \ir schema/users.sql |
16 | 16 |
17 \ir schema/logs.sql | 17 \ir schema/logs.sql |
18 | 18 |
19 \ir schema/admin.sql | 19 \ir schema/admin.sql |
20 | 20 |
21 commit; | 21 COMMIT; |
22 | |
23 | |
24 |