Mercurial > gemma

changeset 4129:24c5eec22c2d request_hist_bns

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;
--- a/schema/version.sql	Thu Aug 01 17:27:40 2019 +0200
+++ b/schema/version.sql	Thu Aug 01 17:28:35 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1101);
+INSERT INTO gemma_schema_version(version) VALUES (1102);