Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
4963:1e47ba2a58f2 4964:58dc06e91c39
941 ) AS fairway_marks_boycar) 941 ) AS fairway_marks_boycar)
942 )) 942 ))
943 943
944 -- Additional attributes for IENC feature BOYLAT 944 -- Additional attributes for IENC feature BOYLAT
945 CREATE TABLE fairway_marks_boylat ( 945 CREATE TABLE fairway_marks_boylat (
946 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
947 colour varchar, 946 colour varchar,
948 colpat varchar, 947 colpat varchar,
949 conrad int, 948 conrad int,
950 marsys int, 949 marsys int,
951 boyshp int, 950 boyshp int,
952 catlam int 951 catlam int
953 ) INHERITS (fairway_marks) 952 ) INHERITS (fairway_marks)
953
954 CREATE TABLE fairway_marks_boylat_hydro (
955 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
956 ) INHERITS (fairway_marks_boylat)
954 -- Prevent identical entries using composite type comparison 957 -- Prevent identical entries using composite type comparison
955 -- (i.e. considering two NULL values in a field equal): 958 -- (i.e. considering two NULL values in a field equal):
956 CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows 959 CREATE UNIQUE INDEX fairway_marks_boylat_hydro_distinct_rows
957 ON fairway_marks_boylat 960 ON fairway_marks_boylat_hydro
958 ((CAST((validity, last_found, geom, 961 ((CAST((validity, last_found, geom,
959 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, 962 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
960 scamin, picrep, txtdsc, sordat, sorind, 963 scamin, picrep, txtdsc, sordat, sorind,
961 0, colour, colpat, conrad, marsys, boyshp, catlam 964 colour, colpat, conrad, marsys, boyshp, catlam, 0
962 ) AS fairway_marks_boylat) 965 ) AS fairway_marks_boylat_hydro)
966 ))
967
968 CREATE TABLE fairway_marks_boylat_ienc (
969 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
970 ) INHERITS (fairway_marks_boylat)
971 -- Prevent identical entries using composite type comparison
972 -- (i.e. considering two NULL values in a field equal):
973 CREATE UNIQUE INDEX fairway_marks_boylat_ienc_distinct_rows
974 ON fairway_marks_boylat_ienc
975 ((CAST((validity, last_found, geom,
976 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
977 scamin, picrep, txtdsc, sordat, sorind,
978 colour, colpat, conrad, marsys, boyshp, catlam, 0
979 ) AS fairway_marks_boylat_ienc)
963 )) 980 ))
964 981
965 -- Additional attributes for IENC feature BOYSAW 982 -- Additional attributes for IENC feature BOYSAW
966 CREATE TABLE fairway_marks_boysaw ( 983 CREATE TABLE fairway_marks_boysaw (
967 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 984 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,