summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-08 19:45:05 +0200
committerYorhel <git@yorhel.nl>2009-08-08 19:45:05 +0200
commit763cffca97e49d9908ff4d499cdca150bcad5670 (patch)
tree777b8343a6832a539607f0f9f07737cee26c6a88 /util/dump.sql
parentf95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff)
Converted tags.added to timestamptz
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index a89a5e7e..f8c7564c 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -181,7 +181,7 @@ CREATE TABLE tags (
name varchar(250) NOT NULL UNIQUE,
description text NOT NULL DEFAULT '',
meta boolean NOT NULL DEFAULT FALSE,
- added bigint NOT NULL DEFAULT DATE_PART('epoch'::text, NOW()),
+ added timestamptz NOT NULL DEFAULT NOW(),
state smallint NOT NULL DEFAULT 0,
c_vns integer NOT NULL DEFAULT 0,
addedby integer NOT NULL DEFAULT 1