diff options
author | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-08-08 19:45:05 +0200 |
commit | 763cffca97e49d9908ff4d499cdca150bcad5670 (patch) | |
tree | 777b8343a6832a539607f0f9f07737cee26c6a88 /util/dump.sql | |
parent | f95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff) |
Converted tags.added to timestamptz
Diffstat (limited to 'util/dump.sql')
-rw-r--r-- | util/dump.sql | 2 |
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 |