view database/schema/logs.sql @ 17:f155c6af2c6b

Store the pdf in Mercurial. (this wastes some space but makes it easier to cut releases)
author David A. Holland
date Mon, 03 Sep 2012 13:57:47 -0400
parents d4c3bd255653
children cd36b49f4437
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 timestamp		not null,
	comment text		not null

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