gemma: wamos.sql annotate

annotate wamos.sql @ 80:004198a3cbc0

Set correct EPSG code.

author	Tom Gottfried <tom@intevation.de>
date	Thu, 31 May 2018 16:30:20 +0200
parents	c22ddffc2071
children	acaa485c0c1e

rev	line source
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	1 BEGIN;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	2
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	3 CREATE EXTENSION postgis;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	4
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	5 CREATE SCHEMA wamos;
1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	6 SET search_path TO public, wamos;
1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	7
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	8 CREATE FUNCTION update_date_info() RETURNS trigger
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	9 LANGUAGE plpgsql
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	10 AS $$
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	11 BEGIN
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	12 NEW.date_info = CURRENT_TIMESTAMP;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	13 RETURN NEW;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	14 END;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	15 $$;
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	16
37 6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	17 -- Composite type: UN/LOCODE, fairway section, object reference, hectometre.
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	18 -- See RIS-Index Encoding Guide
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	19 CREATE TYPE isrs AS (
37 6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	20 country_code char(2), -- ISO 3166 country code
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	21 -- could be validated against countries table.
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	22 locode char(3), -- without the country code:
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	23 -- http://www.unece.org/cefact/locode/welcome.html
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	24 fairway_section char(5),
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	25 object_reference char(5),
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	26 hectometre int -- should be constrained to five digits
6f273a649f08 Be more specific with ISRS and update some comments. Tom Gottfried <tom@intevation.de> parents: 35 diff changeset	27 );
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	28
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	29 CREATE TYPE isrsrange AS RANGE (
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	30 subtype = isrs
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	31 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	32
53 6e8d571c720e Refer to issue tracker. Tom Gottfried <tom@intevation.de> parents: 52 diff changeset	33 -- Eventually obsolete.
6e8d571c720e Refer to issue tracker. Tom Gottfried <tom@intevation.de> parents: 52 diff changeset	34 -- See https://roundup-intern.intevation.de/wamos/issue5
62 39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	35 -- CREATE TABLE rwdrs (
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	36 -- stretch isrsrange PRIMARY KEY,
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	37 -- -- https://www.postgresql.org/docs/10/static/sql-createindex.html:
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	38 -- -- Only B-tree supports UNIQUE indexes, but we need the GIST index
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	39 -- -- below anyhow.
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	40 -- -- Is it a good idea to build B-tree indexes on relatively large
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	41 -- -- composites of string values or should we use inter PKs?
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	42 -- -- => In case the index is used and cache space becomes a limiting
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	43 -- -- factor, this might be an issue.
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	44 -- rwdr double precision NOT NULL,
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	45 -- EXCLUDE USING GIST (stretch WITH &&)
39e0e3d8dd1b Comment potentially obsolete table out. Tom Gottfried <tom@intevation.de> parents: 60 diff changeset	46 -- );
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	47
69 beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	48 CREATE TABLE wamos.countries (
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	49 country_code char(2) PRIMARY KEY -- ISO 3166 country code
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	50 -- A smallint PK would require even less disk space i.e. on the FK side.
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	51 -- This might be an issue in case cache space becomes a limiting
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	52 -- factor when there are many FKs pointing here.
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	53 );
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	54
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	55 --
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	56 -- General river information
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	57 --
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	58 CREATE TABLE wamos.waterway_area (
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	59 dummy_attrib varchar,
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	60 "..." varchar
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	61 -- TODO: add real waterway area attributes (DRC 2.1.3)
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	62 );
beb1863eefaf Add waterway area. Tom Gottfried <tom@intevation.de> parents: 67 diff changeset	63
70 28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	64 CREATE TABLE wamos.reference_water_levels (
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	65 reference_water_level varchar(20) PRIMARY KEY
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	66 );
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	67
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	68 CREATE TABLE wamos.gauges (
38 529319bc3c5b Mark gauges table as placeholder. Tom Gottfried <tom@intevation.de> parents: 37 diff changeset	69 location isrs PRIMARY KEY,
43 e84ff54eb8e9 Tweak ER diagramm. Tom Gottfried <tom@intevation.de> parents: 42 diff changeset	70 dummy_attrib varchar,
e84ff54eb8e9 Tweak ER diagramm. Tom Gottfried <tom@intevation.de> parents: 42 diff changeset	71 "..." varchar
38 529319bc3c5b Mark gauges table as placeholder. Tom Gottfried <tom@intevation.de> parents: 37 diff changeset	72 -- TODO: add real gauge attributes (DRC 2.1.4)
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	73 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	74
70 28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	75 CREATE TABLE wamos.gauges_reference_water_levels (
71 e9bc0d93bef9 Add missing NOT NULL constraints. Tom Gottfried <tom@intevation.de> parents: 70 diff changeset	76 gauge_id isrs NOT NULL REFERENCES gauges,
e9bc0d93bef9 Add missing NOT NULL constraints. Tom Gottfried <tom@intevation.de> parents: 70 diff changeset	77 reference_water_level varchar(20)
e9bc0d93bef9 Add missing NOT NULL constraints. Tom Gottfried <tom@intevation.de> parents: 70 diff changeset	78 NOT NULL REFERENCES reference_water_levels,
70 28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	79 PRIMARY KEY (gauge_id, reference_water_level),
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	80 value int NOT NULL
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	81 );
28108455ad35 Add reference water levels to gauges. Tom Gottfried <tom@intevation.de> parents: 69 diff changeset	82
72 158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	83 CREATE TABLE wamos.gauge_measurements (
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	84 fk_gauge_id isrs NOT NULL REFERENCES gauges,
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	85 -- XXX: Is country_code really relevant for WAMOS or just NtS?
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	86 -- country_code char(2) NOT NULL REFERENCES countries,
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	87 -- TODO: add relations to stuff provided as enumerations
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	88 dummy_attrib varchar,
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	89 "..." varchar
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	90 -- TODO: add real gauge measurement attributes (DRC 2.1.5)
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	91 );
158f776732c7 Add gauge measurements stub. Tom Gottfried <tom@intevation.de> parents: 71 diff changeset	92
73 65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	93 CREATE TABLE wamos.waterway_axis (
65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	94 dummy_attrib varchar,
65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	95 "..." varchar
65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	96 -- TODO: add real waterway area attributes (DRC 2.1.3)
65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	97 );
65a8aeb9e2b3 Add waterway axis stub. Tom Gottfried <tom@intevation.de> parents: 72 diff changeset	98
78 012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	99 CREATE TABLE wamos.distance_mark_functions (
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	100 -- XXX: Redundant information to object code in isrs code of dist. mark
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	101 distance_mark_function varchar(8) PRIMARY KEY
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	102 );
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	103
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	104 -- This table allows linkage between the 1D ISRS location codes and 2D space
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	105 -- e.g. for cutting bottleneck area out of waterway area based on virtual
012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	106 -- distance marks along waterway axis (see SUC7).
74 8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	107 CREATE TABLE wamos.distance_marks (
8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	108 location_code isrs PRIMARY KEY,
80 004198a3cbc0 Set correct EPSG code. Tom Gottfried <tom@intevation.de> parents: 79 diff changeset	109 geom geometry(POINT, 4326),
78 012948f18faa Distance marks as link between 1D and 2D. Tom Gottfried <tom@intevation.de> parents: 77 diff changeset	110 distance_mark_function varchar(8) REFERENCES distance_mark_functions,
74 8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	111 -- TODO: add relations to stuff provided as enumerations
8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	112 dummy_attrib varchar,
8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	113 "..." varchar
75 ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	114 -- TODO: add real distance mark attributes (DRC 2.1.7)
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	115 );
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	116
77 e5bcd9293d3d Correctly schema-qualify tables. Tom Gottfried <tom@intevation.de> parents: 76 diff changeset	117 CREATE TABLE wamos.sections_stretches (
75 ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	118 id varchar PRIMARY KEY,
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	119 is_section boolean NOT NULL, -- maps 'function' from interface
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	120 stretch isrsrange,
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	121 dummy_attrib varchar,
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	122 "..." varchar
ed7a50cfbc19 Add sections and stretches stub and fix comment. Tom Gottfried <tom@intevation.de> parents: 74 diff changeset	123 -- TODO: add real section/stretch attributes (DRC 2.2.1)
74 8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	124 );
8c0af903a764 Add distance marks stub. Tom Gottfried <tom@intevation.de> parents: 73 diff changeset	125
79 c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	126 CREATE TABLE wamos.waterway_profiles (
c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	127 dummy_attrib varchar,
c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	128 "..." varchar
c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	129 -- TODO: add real profile attributes (DRC 2.2.3)
c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	130 );
c22ddffc2071 Add waterway profiles stub. Tom Gottfried <tom@intevation.de> parents: 78 diff changeset	131
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	132 --
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	133 -- Bottlenecks
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	134 --
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	135 CREATE TABLE wamos.riverbed_materials (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	136 material varchar PRIMARY KEY
39 830287983657 Comment: details to clarify riverbed material. Tom Gottfried <tom@intevation.de> parents: 38 diff changeset	137 -- XXX: Should this table contain choices from DRC 2.2.3 or
830287983657 Comment: details to clarify riverbed material. Tom Gottfried <tom@intevation.de> parents: 38 diff changeset	138 -- from IENC Encoding Guide M.4.3, attribute NATSUR?
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	139 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	140
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	141 CREATE TABLE wamos.survey_types (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	142 survey_type varchar PRIMARY KEY
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	143 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	144
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	145 CREATE TABLE wamos.coverage_types (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	146 coverage_type varchar PRIMARY KEY
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	147 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	148
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	149 CREATE TABLE wamos.limiting_factors (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	150 limiting_factor varchar PRIMARY KEY
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	151 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	152
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	153 CREATE TABLE wamos.depth_references (
40 535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	154 depth_reference varchar(4) PRIMARY KEY
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	155 -- See col. AB and AI RIS-Index Encoding Guide
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	156 -- XXX: We need a way to distinguish between geodetic (eg. col. AP
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	157 -- RIS-Index) and other references (e.g. col. AB and AI):
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	158 -- _ multi-column FK with a boolean column (geodetic/non-geodetic;
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	159 -- i.e. absolut/not absolut) and DEFAULTs and CHECKs at the FK side.
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	160 -- _ Do not mixup things with different meanings in one table at all
535e57373a93 Fix and comments on depth references. Tom Gottfried <tom@intevation.de> parents: 39 diff changeset	161 -- (which would mean a model differing a bit from RIS-Index ideas)
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	162 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	163
55 ecb9bb0591c9 Note on spurious nullability. Tom Gottfried <tom@intevation.de> parents: 54 diff changeset	164 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL
ecb9bb0591c9 Note on spurious nullability. Tom Gottfried <tom@intevation.de> parents: 54 diff changeset	165 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and
ecb9bb0591c9 Note on spurious nullability. Tom Gottfried <tom@intevation.de> parents: 54 diff changeset	166 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL)
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	167 CREATE TABLE wamos.bottlenecks (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	168 bottleneck_id varchar PRIMARY KEY,
54 285146e8c9c5 Align constraints with WSDL (NOT NULL vs. minOccurs). Tom Gottfried <tom@intevation.de> parents: 53 diff changeset	169 fk_g_fid isrs NOT NULL REFERENCES gauges,
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	170 -- XXX: DRC references "ch. 3.1.1", which does not exist in document.
54 285146e8c9c5 Align constraints with WSDL (NOT NULL vs. minOccurs). Tom Gottfried <tom@intevation.de> parents: 53 diff changeset	171 objnam varchar,
285146e8c9c5 Align constraints with WSDL (NOT NULL vs. minOccurs). Tom Gottfried <tom@intevation.de> parents: 53 diff changeset	172 nobjnm varchar,
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	173 stretch isrsrange NOT NULL,
80 004198a3cbc0 Set correct EPSG code. Tom Gottfried <tom@intevation.de> parents: 79 diff changeset	174 area geometry(POLYGON, 4326) NOT NULL,
42 47f1ffdc6ef4 Cleanup rb_lb. Tom Gottfried <tom@intevation.de> parents: 41 diff changeset	175 rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
47f1ffdc6ef4 Cleanup rb_lb. Tom Gottfried <tom@intevation.de> parents: 41 diff changeset	176 lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
41 dd858a74b4e9 Set columns referencing countries next to each other. Tom Gottfried <tom@intevation.de> parents: 40 diff changeset	177 responsible_country char(2) NOT NULL REFERENCES countries,
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	178 revisiting_time smallint NOT NULL,
46 9106e1510244 Tweak ER diagramm. Tom Gottfried <tom@intevation.de> parents: 45 diff changeset	179 limiting varchar NOT NULL REFERENCES limiting_factors,
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	180 surtyp varchar NOT NULL REFERENCES survey_types,
45 cb25ddf16cbf Probably attributes of sounding results Tom Gottfried <tom@intevation.de> parents: 44 diff changeset	181 -- XXX: Also an attribut of sounding result?
54 285146e8c9c5 Align constraints with WSDL (NOT NULL vs. minOccurs). Tom Gottfried <tom@intevation.de> parents: 53 diff changeset	182 coverage varchar REFERENCES coverage_types,
45 cb25ddf16cbf Probably attributes of sounding results Tom Gottfried <tom@intevation.de> parents: 44 diff changeset	183 -- XXX: Also an attribut of sounding result?
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	184 -- CHECK allowed combinations of surtyp and coverage or
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	185 -- different model approach?
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	186 depth_reference char(3) NOT NULL REFERENCES depth_references,
45 cb25ddf16cbf Probably attributes of sounding results Tom Gottfried <tom@intevation.de> parents: 44 diff changeset	187 -- XXX: Also an attribut of sounding result?
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	188 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
60 f0ca64da9446 Add attribute to mark data sets as checked in staging area. Tom Gottfried <tom@intevation.de> parents: 59 diff changeset	189 source_organization varchar NOT NULL,
47 a03ff9076969 Delivered by interface for other uses than WAMOS. Tom Gottfried <tom@intevation.de> parents: 46 diff changeset	190 -- additional_data xml -- Currently not relevant for WAMOS
60 f0ca64da9446 Add attribute to mark data sets as checked in staging area. Tom Gottfried <tom@intevation.de> parents: 59 diff changeset	191 staging_done boolean NOT NULL DEFAULT false
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	192 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	193 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	194 FOR EACH ROW EXECUTE PROCEDURE update_date_info();
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	195
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	196 CREATE TABLE wamos.bottlenecks_riverbed_materials (
44 dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	197 bottleneck_id varchar REFERENCES bottlenecks,
dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	198 riverbed varchar REFERENCES riverbed_materials,
dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	199 -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3
dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	200 PRIMARY KEY (bottleneck_id, riverbed)
dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	201 );
dcc3b1134b24 Multiple riverbed materials per bottleneck possible. Tom Gottfried <tom@intevation.de> parents: 43 diff changeset	202
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	203 CREATE TABLE wamos.sounding_results (
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	204 bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	205 date_info date NOT NULL,
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	206 PRIMARY KEY (bottleneck_id, date_info),
80 004198a3cbc0 Set correct EPSG code. Tom Gottfried <tom@intevation.de> parents: 79 diff changeset	207 area geometry(POLYGON, 4326) NOT NULL,
45 cb25ddf16cbf Probably attributes of sounding results Tom Gottfried <tom@intevation.de> parents: 44 diff changeset	208 surtyp varchar NOT NULL REFERENCES survey_types,
54 285146e8c9c5 Align constraints with WSDL (NOT NULL vs. minOccurs). Tom Gottfried <tom@intevation.de> parents: 53 diff changeset	209 coverage varchar REFERENCES coverage_types,
45 cb25ddf16cbf Probably attributes of sounding results Tom Gottfried <tom@intevation.de> parents: 44 diff changeset	210 depth_reference char(3) NOT NULL REFERENCES depth_references,
60 f0ca64da9446 Add attribute to mark data sets as checked in staging area. Tom Gottfried <tom@intevation.de> parents: 59 diff changeset	211 sounding_data raster NOT NULL,
f0ca64da9446 Add attribute to mark data sets as checked in staging area. Tom Gottfried <tom@intevation.de> parents: 59 diff changeset	212 staging_done boolean NOT NULL DEFAULT false
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	213 );
62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	214
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	215 --
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	216 -- Fairway availability
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	217 --
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	218 CREATE TABLE wamos.spot_marks (
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	219 mark_name varchar PRIMARY KEY
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	220 -- Use smallint because of fairway availability provided on daily basis?
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	221 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	222
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	223 CREATE TABLE wamos.levels_of_service (
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	224 level_of_service smallint PRIMARY KEY
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	225 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	226
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	227 CREATE TABLE wamos.measure_types (
58 30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	228 measure_type varchar PRIMARY KEY
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	229 );
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	230
77 e5bcd9293d3d Correctly schema-qualify tables. Tom Gottfried <tom@intevation.de> parents: 76 diff changeset	231 CREATE TABLE wamos.fairway_dimensions (
76 2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	232 level_of_service smallint REFERENCES levels_of_service,
2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	233 dummy_attrib varchar,
2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	234 "..." varchar
2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	235 -- TODO: add real fairway dimension attributes (DRC 2.2.2)
2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	236 );
2a6e49a7b839 Add fairway dimensions stub. Tom Gottfried <tom@intevation.de> parents: 75 diff changeset	237
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	238 CREATE TABLE wamos.fairway_availability (
66 21df0e95db4a Fix thinkos and syntax errors in previous commit. Tom Gottfried <tom@intevation.de> parents: 65 diff changeset	239 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
67 d218aa96170f Tweak ER-diagramm. Tom Gottfried <tom@intevation.de> parents: 66 diff changeset	240 position varchar REFERENCES spot_marks,
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	241 bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	242 surdat date NOT NULL,
66 21df0e95db4a Fix thinkos and syntax errors in previous commit. Tom Gottfried <tom@intevation.de> parents: 65 diff changeset	243 UNIQUE (bottleneck_id, surdat),
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	244 -- additional_data xml -- Currently not relevant for WAMOS
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	245 critical boolean,
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	246 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	247 source_organization varchar NOT NULL
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	248 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	249 CREATE TRIGGER fairway_availability_date_info
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	250 BEFORE UPDATE ON fairway_availability
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	251 FOR EACH ROW EXECUTE PROCEDURE update_date_info();
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	252
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	253 CREATE TABLE wamos.fa_reference_values (
66 21df0e95db4a Fix thinkos and syntax errors in previous commit. Tom Gottfried <tom@intevation.de> parents: 65 diff changeset	254 fairway_availability_id int NOT NULL REFERENCES fairway_availability,
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	255 level_of_service smallint NOT NULL REFERENCES levels_of_service,
65 cad19acc53b3 Avoid duplicate direct relations in composite primary keys. Tom Gottfried <tom@intevation.de> parents: 64 diff changeset	256 PRIMARY KEY (fairway_availability_id, level_of_service),
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	257 fairway_depth smallint,
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	258 fairway_width smallint,
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	259 fairway_radius int,
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	260 CHECK(COALESCE(fairway_depth, fairway_width, fairway_radius) IS NOT NULL),
80 004198a3cbc0 Set correct EPSG code. Tom Gottfried <tom@intevation.de> parents: 79 diff changeset	261 shallowest_spot geometry(POINT, 4326)
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	262 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	263
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	264 CREATE TABLE wamos.bottleneck_pdfs (
66 21df0e95db4a Fix thinkos and syntax errors in previous commit. Tom Gottfried <tom@intevation.de> parents: 65 diff changeset	265 fairway_availability_id int NOT NULL REFERENCES fairway_availability,
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	266 profile_pdf_filename varchar NOT NULL, -- redundant to last part of URL
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	267 profile_pdf_url varchar NOT NULL, -- prohibit insecure URLs somehow?
65 cad19acc53b3 Avoid duplicate direct relations in composite primary keys. Tom Gottfried <tom@intevation.de> parents: 64 diff changeset	268 PRIMARY KEY (fairway_availability_id, profile_pdf_url),
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	269 pdf_generation_date timestamp with time zone NOT NULL,
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	270 source_organization varchar NOT NULL
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	271 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	272
64 1e9589cf9c00 Create specific wamos schema. Tom Gottfried <tom@intevation.de> parents: 62 diff changeset	273 CREATE TABLE wamos.effective_fairway_availability (
66 21df0e95db4a Fix thinkos and syntax errors in previous commit. Tom Gottfried <tom@intevation.de> parents: 65 diff changeset	274 fairway_availability_id int NOT NULL REFERENCES fairway_availability,
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	275 measure_date timestamp with time zone NOT NULL,
58 30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	276 level_of_service smallint NOT NULL REFERENCES levels_of_service,
65 cad19acc53b3 Avoid duplicate direct relations in composite primary keys. Tom Gottfried <tom@intevation.de> parents: 64 diff changeset	277 PRIMARY KEY (fairway_availability_id, measure_date, level_of_service),
58 30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	278 available_depth_value smallint,
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	279 available_width_value smallint,
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	280 water_level_value smallint,
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	281 CHECK(COALESCE(available_depth_value, available_width_value,
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	282 water_level_value) IS NOT NULL),
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	283 measure_type varchar NOT NULL REFERENCES measure_types,
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	284 source_organization varchar NOT NULL,
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	285 forecast_generation_time timestamp with time zone,
58 30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	286 CHECK(measure_type <> 'forecasted'
30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	287 OR forecast_generation_time IS NOT NULL),
59 37faa7359ea6 Interfaces may provide timestamps with time zone. Tom Gottfried <tom@intevation.de> parents: 58 diff changeset	288 value_lifetime timestamp with time zone,
58 30cb2f87c268 Add effective fairway availability. Tom Gottfried <tom@intevation.de> parents: 56 diff changeset	289 CHECK(measure_type = 'minimum guaranteed' OR value_lifetime IS NOT NULL)
56 f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	290 );
f378959820be Started to draft schema for fairway availability. Tom Gottfried <tom@intevation.de> parents: 55 diff changeset	291
35 62e14b4d25fc First working draft of schema for bottlenecks. Tom Gottfried <tom@intevation.de> parents: diff changeset	292 COMMIT;

Mercurial > gemma

annotate wamos.sql @ 80:004198a3cbc0