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/updates/update_2.6.sql | |
parent | f95031507420e14ab95512b3bfbbbfab8fe5ce9f (diff) |
Converted tags.added to timestamptz
Diffstat (limited to 'util/updates/update_2.6.sql')
-rw-r--r-- | util/updates/update_2.6.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql index 7f0242f7..3a1f1482 100644 --- a/util/updates/update_2.6.sql +++ b/util/updates/update_2.6.sql @@ -82,6 +82,12 @@ ALTER TABLE users ALTER COLUMN registered TYPE timestamptz USING to_timestamp(re ALTER TABLE users ALTER COLUMN registered SET DEFAULT NOW(); +-- tags.added -> timestamptz +ALTER TABLE tags ALTER COLUMN added DROP DEFAULT; +ALTER TABLE tags ALTER COLUMN added TYPE timestamptz USING to_timestamp(added); +ALTER TABLE tags ALTER COLUMN added SET DEFAULT NOW(); + + -- screenshots.status (smallint) -> screenshots.processed (boolean) ALTER TABLE screenshots RENAME COLUMN status TO processed; ALTER TABLE screenshots ALTER COLUMN processed DROP DEFAULT; |