Mercurial > gemma

annotate schema/updates/1403/02.add_fairway_mark_types.sql @ 5736:55892008ec96 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed a bunch of corner cases in WG import.
author Sascha Wilde <wilde@sha-bang.de>
date Wed, 29 May 2024 19:02:42 +0200
parents b3b2ba09a450
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4940
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 CREATE TABLE waterway.fairway_marks_boysaw (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 colour varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 colpat varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 conrad int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 marsys int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 boyshp int
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 CREATE UNIQUE INDEX fairway_marks_boysaw_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 ON waterway.fairway_marks_boysaw
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 0, colour, colpat, conrad, marsys, boyshp
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 ) AS waterway.fairway_marks_boysaw)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
17
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
18 CREATE TABLE waterway.fairway_marks_boyspp (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
19 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
20 colour varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
21 colpat varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
22 conrad int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
23 marsys int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
24 boyshp int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
25 catspm varchar
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
26 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
27 CREATE UNIQUE INDEX fairway_marks_boyspp_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
28 ON waterway.fairway_marks_boyspp
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
29 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
30 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
31 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
32 0, colour, colpat, conrad, marsys, boyshp, catspm
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
33 ) AS waterway.fairway_marks_boyspp)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
34 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
35
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
36 CREATE TABLE waterway.fairway_marks_daymar (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
37 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
38 colour varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
39 colpat varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
40 condtn int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
41 topshp int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
42 orient double precision
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
43 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
44 CREATE UNIQUE INDEX fairway_marks_daymar_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
45 ON waterway.fairway_marks_daymar
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
46 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
47 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
48 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
49 0, colour, colpat, condtn, topshp, orient
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
50 ) AS waterway.fairway_marks_daymar)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
51 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
52
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
53 CREATE TABLE waterway.fairway_marks_daymar_dirimps (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
54 fm_daymar_id int REFERENCES waterway.fairway_marks_daymar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
55 dirimp smallint REFERENCES dirimps,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
56 PRIMARY KEY (fm_daymar_id, dirimp)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
57 );
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
58
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
59 CREATE TABLE waterway.fairway_marks_lights (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
60 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
61 colour varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
62 condtn int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
63 orient double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
64 catlit varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
65 exclit int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
66 litchr int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
67 litvis varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
68 mltylt int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
69 sectr1 double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
70 sectr2 double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
71 siggrp varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
72 sigper double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
73 sigseq varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
74 status varchar
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
75 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
76 CREATE UNIQUE INDEX fairway_marks_lights_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
77 ON waterway.fairway_marks_lights
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
78 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
79 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
80 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
81 0, colour, condtn, orient, catlit, exclit, litchr, litvis,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
82 mltylt, sectr1, sectr2, siggrp, sigper, sigseq, status
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
83 ) AS waterway.fairway_marks_lights)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
84 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
85
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
86 CREATE TABLE waterway.fairway_marks_rtpbcn (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
87 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
88 condtn int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
89 siggrp varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
90 catrtb int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
91 radwal varchar
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
92 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
93 CREATE UNIQUE INDEX fairway_marks_rtpbcn_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
94 ON waterway.fairway_marks_rtpbcn
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
95 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
96 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
97 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
98 0, condtn, siggrp, catrtb, radwal
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
99 ) AS waterway.fairway_marks_rtpbcn)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
100 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
101
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
102 CREATE TABLE waterway.fairway_marks_topmar (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
103 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
104 colour varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
105 colpat varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
106 condtn int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
107 topshp int
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
108 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
109 CREATE UNIQUE INDEX fairway_marks_topmar_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
110 ON waterway.fairway_marks_topmar
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
111 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
112 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
113 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
114 0, colour, colpat, condtn, topshp
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
115 ) AS waterway.fairway_marks_topmar)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
116 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
117
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
118 CREATE TABLE waterway.fairway_marks_notmrk (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
119 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
120 condtn int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
121 marsys int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
122 orient double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
123 status varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
124 addmrk varchar,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
125 catnmk int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
126 disipd double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
127 disipu double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
128 disbk1 double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
129 disbk2 double precision,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
130 fnctnm int,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
131 bnkwtw int
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
132 ) INHERITS (waterway.fairway_marks);
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
133 CREATE UNIQUE INDEX fairway_marks_notmrk_distinct_rows
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
134 ON waterway.fairway_marks_notmrk
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
135 ((CAST((geom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
136 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
137 scamin, picrep, txtdsc, sordat, sorind,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
138 0, condtn, marsys, orient, status, addmrk, catnmk,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
139 disipd, disipu, disbk1, disbk2, fnctnm, bnkwtw
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
140 ) AS waterway.fairway_marks_notmrk)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
141 ));
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
142
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
143 CREATE TABLE waterway.fairway_marks_notmrk_dirimps (
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
144 fm_notmrk_id int REFERENCES waterway.fairway_marks_notmrk,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
145 dirimp smallint REFERENCES dirimps,
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
146 PRIMARY KEY (fm_notmrk_id, dirimp)
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
147 );
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
148
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
149 GRANT SELECT on ALL tables in schema waterway TO waterway_user ;
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
150 GRANT INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA waterway
b3b2ba09a450 Add missing fairway mark types
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
151 TO waterway_admin;