Mercurial > ~dholland > hg > swallowtail > index.cgi
view database/schema/logs.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 | cd36b49f4437 |
children |
line wrap: on
line source
-- log of administrative changes over time CREATE TABLE adminlog ( -- who (null means "swallowtail"), where, when, what, why who bigint null references users (id), pr bigint not null references PRs (id), change text not null, posttime timestamp not null, comment text not null, -- if a message was posted, this is the one msgid bigint null references messages (id) ) WITHOUT OIDS; -- We don't ordinarily edit or delete log entries. If you really need -- to do that for some reason (e.g. mispasted passwords) log in as -- swallowtail_owner. GRANT SELECT, INSERT ON adminlog TO swallowtail_admin; GRANT SELECT, INSERT ON adminlog TO swallowtail_writer; GRANT SELECT ON adminlog TO swallowtail_reader; GRANT SELECT ON adminlog TO swallowtail_public;