--- a/database/schema/logs.sql	Sun May 26 22:13:33 2013 -0400
+++ b/database/schema/logs.sql	Sun May 26 23:24:45 2013 -0400
@@ -4,10 +4,10 @@
 	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
+	posttime timestamp	not null,
+	comment text		not null,
 
 	-- if a message was posted, this is the one
-	msgid bigint		null references messages (id),
+	msgid bigint		null references messages (id)
 )
 WITHOUT OIDS;