Mercurial > gemma

diff schema/updates/1010/01.timezones-imports.sql @ 4098:cfa0a5775d70 timezone

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Reapplied timezone patch to database schema.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 26 Jul 2019 09:57:29 +0200
parents 419f28898db0
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1010/01.timezones-imports.sql	Fri Jul 26 09:57:29 2019 +0200
@@ -0,0 +1,3 @@
+ALTER TABLE import.imports     ALTER COLUMN enqueued TYPE timestamp with time zone;
+ALTER TABLE import.imports     ALTER COLUMN due      TYPE timestamp with time zone;
+ALTER TABLE import.import_logs ALTER COLUMN time     TYPE timestamp with time zone;