From 9d3e1e78bc963ac58b504edb00b428e82e177f68 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Sat, 8 Aug 2009 16:54:24 +0200 Subject: Converted votes.date to timestamptz and use NOW() as default --- util/dump.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'util/dump.sql') diff --git a/util/dump.sql b/util/dump.sql index 3667c3b5..fa29460f 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -326,7 +326,7 @@ CREATE TABLE votes ( vid integer NOT NULL DEFAULT 0, uid integer NOT NULL DEFAULT 0, vote integer NOT NULL DEFAULT 0, - date bigint NOT NULL DEFAULT 0, + date timestamptz NOT NULL DEFAULT NOW(), PRIMARY KEY(vid, uid) ); -- cgit v1.2.3