# HG changeset patch
# User David A. Holland
# Date 1342724413 14400
# Node ID d4c3bd255653a6b614bc3b9760192e89f49e8da7
# Parent  d42c0db81e28d519ae18c50f3036f78c59b5e249
"timestamp", not "date". from asau

diff -r d42c0db81e28 -r d4c3bd255653 database/schema/bugs.sql
--- a/database/schema/bugs.sql	Thu Mar 15 04:21:20 2012 -0400
+++ b/database/schema/bugs.sql	Thu Jul 19 15:00:13 2012 -0400
@@ -26,8 +26,8 @@
 
 	-- fixed-size history
 	arrival_schemaversion int  not null,
-	arrival_date date	not null,
-	closed_date date	,
+	arrival_date timestamp	not null,
+	closed_date timestamp	,
 
 	-- original submitter
 	originator bigint	references users (id),
diff -r d42c0db81e28 -r d4c3bd255653 database/schema/logs.sql
--- a/database/schema/logs.sql	Thu Mar 15 04:21:20 2012 -0400
+++ b/database/schema/logs.sql	Thu Jul 19 15:00:13 2012 -0400
@@ -4,7 +4,7 @@
 	who bigint		null references users (id),
 	pr bigint		not null references PRs (id),
 	change text		not null,       
-	when date		not null,
+	when timestamp		not null,
 	comment text		not null
 
 	-- if a message was posted, this is the one
diff -r d42c0db81e28 -r d4c3bd255653 database/schema/messages.sql
--- a/database/schema/messages.sql	Thu Mar 15 04:21:20 2012 -0400
+++ b/database/schema/messages.sql	Thu Jul 19 15:00:13 2012 -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 date		not null,
+	when timestamp		not null,
 	body text		not null,
 
 	-- we don't keep these directly, they go into an admin log entry
diff -r d42c0db81e28 -r d4c3bd255653 database/schema/users.sql
--- a/database/schema/users.sql	Thu Mar 15 04:21:20 2012 -0400
+++ b/database/schema/users.sql	Thu Jul 19 15:00:13 2012 -0400
@@ -58,7 +58,7 @@
 	email text		not null,
 	organization text	,
 	webpassword text	,
-	lastheardfrom date
+	lastheardfrom timestamp
 )
 WITHOUT OIDS;