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