Mercurial > gemma

diff schema/updates/1010/01.timezones-imports.sql @ 4082:419f28898db0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added time zones to import queue tables.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 25 Jul 2019 16:45:07 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1010/01.timezones-imports.sql	Thu Jul 25 16:45:07 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;