view database/schema/logs.sql @ 44:812c956dd0e9

Add another admin queue type for comments on nonexistent PRs. Also, correct stupid spelling mistake. Need to get the test harness running again.
author David A. Holland
date Mon, 16 Jun 2014 01:27:45 -0400
parents cd36b49f4437
children 40f64a96481f
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;