Mercurial > gemma
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 )