view database/schema/logs.sql @ 11:d42c0db81e28

Update the classification stuff. There are still some rough edges but it should be mostly workable now.
author David A. Holland
date Thu, 15 Mar 2012 04:21:20 -0400
parents 68cc276ac118
children d4c3bd255653
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,       
	when date		not null,
	comment text		not null

	-- if a message was posted, this is the one
	msgid bigint		null references messages (id),
)
WITHOUT OIDS;