-- 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;