diff schema/gemma.sql @ 4094:15ab4e474f11

Reverted 4160:419f28898db0 in default.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 25 Jul 2019 18:12:14 +0200
parents 419f28898db0
children b65837b65479 cfa0a5775d70 5af72130b61f
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jul 25 17:15:00 2019 +0200
+++ b/schema/gemma.sql	Thu Jul 25 18:12:14 2019 +0200
@@ -826,8 +826,8 @@
         id         int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
         state      import_state NOT NULL DEFAULT 'queued',
         kind       varchar   NOT NULL,
-        enqueued   timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
-        due        timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        enqueued   timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        due        timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
         retry_wait interval
             CHECK(retry_wait IS NULL
                 OR retry_wait >= interval '0 microseconds'),
@@ -850,7 +850,7 @@
     CREATE TABLE import_logs (
         import_id int NOT NULL REFERENCES imports(id)
             ON DELETE CASCADE,
-        time timestamp with time zone NOT NULL DEFAULT now(),
+        time timestamp zone NOT NULL DEFAULT now(),
         kind log_type NOT NULL DEFAULT 'info',
         msg TEXT NOT NULL
     )