Mercurial > ~dholland > hg > swallowtail > index.cgi

diff database/schema/logs.sql @ 29:cd36b49f4437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix. now loads into postgresql92
author David A. Holland
date Sun, 26 May 2013 23:24:45 -0400 (2013-05-27)
parents d4c3bd255653
children 40f64a96481f
line wrap: on
line diff
--- 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;