Mercurial > gemma
changeset 4129:24c5eec22c2d request_hist_bns
Moved bn schema changes rto version 1102, as 1101 is used.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Thu, 01 Aug 2019 17:28:35 +0200 |
parents | 14706384a464 |
children | 980f12d3c766 |
files | schema/updates/1101/01.bn_constraint.sql schema/updates/1102/01.bn_constraint.sql schema/version.sql |
diffstat | 3 files changed, 15 insertions(+), 15 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/updates/1101/01.bn_constraint.sql Thu Aug 01 17:27:40 2019 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -ALTER TABLE waterway.bottlenecks - DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_key, - DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_excl, - DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_key, - DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_excl; - -ALTER TABLE waterway.bottlenecks - ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_key - UNIQUE (bottleneck_id, validity, staging_done), - ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_excl - EXCLUDE USING GiST (bottleneck_id WITH =, - validity WITH &&, - CAST(staging_done AS int) WITH =) - DEFERRABLE INITIALLY DEFERRED;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1102/01.bn_constraint.sql Thu Aug 01 17:28:35 2019 +0200 @@ -0,0 +1,14 @@ +ALTER TABLE waterway.bottlenecks + DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_key, + DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_excl, + DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_key, + DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_excl; + +ALTER TABLE waterway.bottlenecks + ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_key + UNIQUE (bottleneck_id, validity, staging_done), + ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_excl + EXCLUDE USING GiST (bottleneck_id WITH =, + validity WITH &&, + CAST(staging_done AS int) WITH =) + DEFERRABLE INITIALLY DEFERRED;