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

fix. now loads into postgresql92
author David A. Holland
date Sun, 26 May 2013 23:24:45 -0400
parents 5bf0d6f732c1
children edf081d0b282
line wrap: on
line diff
--- a/database/schema/messages.sql	Sun May 26 22:13:33 2013 -0400
+++ b/database/schema/messages.sql	Sun May 26 23:24:45 2013 -0400
@@ -20,7 +20,7 @@
 	pr bigint		not null references prs (id),
 	who bigint		not null references users (id),
 	parent_id bigint	null references messages (id),
-	when timestamp		not null,
+	posttime timestamp	not null,
 	body text		not null,
 
 	-- we don't keep these directly, they go into an admin log entry