--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/database/schema/logs.sql	Sun Feb 19 19:54:48 2012 -0500
@@ -0,0 +1,13 @@
+-- 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;