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

changeset 12:d4c3bd255653

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"timestamp", not "date". from asau
author David A. Holland
date Thu, 19 Jul 2012 15:00:13 -0400
parents d42c0db81e28
children 5bf0d6f732c1
files database/schema/bugs.sql database/schema/logs.sql database/schema/messages.sql database/schema/users.sql
diffstat 4 files changed, 5 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- 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),
--- 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
--- 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
--- 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;