Mercurial > ~dholland > hg > swallowtail > index.cgi

comparison database/schema/admin.sql @ 55:40f64a96481f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjust database user arrangements and grant schema privs.
author David A. Holland
date Sun, 10 Apr 2022 19:36:29 -0400
parents 36d91dfe017f
children
comparison
equal deleted inserted replaced
54:36d91dfe017f 55:40f64a96481f
31 type text not null references adminmailtypes, 31 type text not null references adminmailtypes,
32 pr bigint null references PRs, 32 pr bigint null references PRs,
33 userid bigint null references users 33 userid bigint null references users
34 ) 34 )
35 WITHOUT OIDS; 35 WITHOUT OIDS;
36
37 -- adminmailtypes is fixed
38 -- adminmailqueue is append-only except to admins
39 GRANT SELECT, INSERT, UPDATE, DELETE ON adminmailqueue TO swallowtail_admin;
40 GRANT INSERT ON attachments TO swallowtail_writer;