From 9d3e1e78bc963ac58b504edb00b428e82e177f68 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
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

