Mercurial > gemma

diff schema/gemma.sql @ 4964:58dc06e91c39 fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Follow-up of rev. 1b309a8e7673 for BOYLAT
author Tom Gottfried <tom@intevation.de>
date Fri, 28 Feb 2020 13:43:52 +0100
parents 1b309a8e7673
children be713316b47a
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Feb 28 12:01:03 2020 +0100
+++ b/schema/gemma.sql	Fri Feb 28 13:43:52 2020 +0100
@@ -943,7 +943,6 @@
 
     -- Additional attributes for IENC feature BOYLAT
     CREATE TABLE fairway_marks_boylat (
-        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
         colour varchar,
         colpat varchar,
         conrad int,
@@ -951,15 +950,33 @@
         boyshp int,
         catlam int
     ) INHERITS (fairway_marks)
+
+    CREATE TABLE fairway_marks_boylat_hydro (
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
+    ) INHERITS (fairway_marks_boylat)
     -- Prevent identical entries using composite type comparison
     -- (i.e. considering two NULL values in a field equal):
-    CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows
-        ON fairway_marks_boylat
+    CREATE UNIQUE INDEX fairway_marks_boylat_hydro_distinct_rows
+        ON fairway_marks_boylat_hydro
         ((CAST((validity, last_found, geom,
                 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
                 scamin, picrep, txtdsc, sordat, sorind,
-                0, colour, colpat, conrad, marsys, boyshp, catlam
-            ) AS fairway_marks_boylat)
+                colour, colpat, conrad, marsys, boyshp, catlam, 0
+            ) AS fairway_marks_boylat_hydro)
+        ))
+
+    CREATE TABLE fairway_marks_boylat_ienc (
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
+    ) INHERITS (fairway_marks_boylat)
+    -- Prevent identical entries using composite type comparison
+    -- (i.e. considering two NULL values in a field equal):
+    CREATE UNIQUE INDEX fairway_marks_boylat_ienc_distinct_rows
+        ON fairway_marks_boylat_ienc
+        ((CAST((validity, last_found, geom,
+                datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
+                scamin, picrep, txtdsc, sordat, sorind,
+                colour, colpat, conrad, marsys, boyshp, catlam, 0
+            ) AS fairway_marks_boylat_ienc)
         ))
 
     -- Additional attributes for IENC feature BOYSAW