Mercurial > gemma
annotate schema/updates/1405/02.recreate_fm_indexes.sql @ 5099:3cd736acbad3 queued-stage-done
First version of a reviewed job. I bet it does not work.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 24 Mar 2020 15:46:37 +0100 |
parents | 7cc79c65a9e5 |
children |
rev | line source |
---|---|
4956
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 CREATE UNIQUE INDEX fairway_marks_bcnlat_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
2 ON waterway.fairway_marks_bcnlat |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
3 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
4 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
5 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
6 0, colour, colpat, condtn, bcnshp, catlam |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
7 ) AS waterway.fairway_marks_bcnlat) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
8 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
9 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
10 CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
11 ON waterway.fairway_marks_boycar |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
12 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
13 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
14 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
15 0, colour, colpat, conrad, marsys, boyshp, catcam |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
16 ) AS waterway.fairway_marks_boycar) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
17 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
18 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
19 CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
20 ON waterway.fairway_marks_boylat |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
21 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
22 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
23 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
24 0, colour, colpat, conrad, marsys, boyshp, catlam |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
25 ) AS waterway.fairway_marks_boylat) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
26 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
27 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
28 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
29 CREATE UNIQUE INDEX fairway_marks_boysaw_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
30 ON waterway.fairway_marks_boysaw |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
31 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
32 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
33 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
34 0, colour, colpat, conrad, marsys, boyshp |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
35 ) AS waterway.fairway_marks_boysaw) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
36 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
37 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
38 CREATE UNIQUE INDEX fairway_marks_boyspp_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
39 ON waterway.fairway_marks_boyspp |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
40 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
41 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
42 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
43 0, colour, colpat, conrad, marsys, boyshp, catspm |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
44 ) AS waterway.fairway_marks_boyspp) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
45 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
46 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
47 CREATE UNIQUE INDEX fairway_marks_daymar_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
48 ON waterway.fairway_marks_daymar |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
49 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
50 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
51 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
52 0, colour, colpat, condtn, topshp, orient |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
53 ) AS waterway.fairway_marks_daymar) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
54 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
55 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
56 CREATE UNIQUE INDEX fairway_marks_lights_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
57 ON waterway.fairway_marks_lights |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
58 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
59 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
60 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
61 0, colour, condtn, orient, catlit, exclit, litchr, litvis, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
62 mltylt, sectr1, sectr2, siggrp, sigper, sigseq, status |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
63 ) AS waterway.fairway_marks_lights) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
64 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
65 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
66 CREATE UNIQUE INDEX fairway_marks_rtpbcn_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
67 ON waterway.fairway_marks_rtpbcn |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
68 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
69 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
70 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
71 0, condtn, siggrp, catrtb, radwal |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
72 ) AS waterway.fairway_marks_rtpbcn) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
73 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
74 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
75 CREATE UNIQUE INDEX fairway_marks_topmar_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
76 ON waterway.fairway_marks_topmar |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
77 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
78 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
79 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
80 0, colour, colpat, condtn, topshp |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
81 ) AS waterway.fairway_marks_topmar) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
82 )); |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
83 |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
84 CREATE UNIQUE INDEX fairway_marks_notmrk_distinct_rows |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
85 ON waterway.fairway_marks_notmrk |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
86 ((CAST((validity, last_found, geom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
87 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
88 scamin, picrep, txtdsc, sordat, sorind, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
89 0, condtn, marsys, orient, status, addmrk, catnmk, |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
90 disipd, disipu, disbk1, disbk2, fnctnm, bnkwtw |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
91 ) AS waterway.fairway_marks_notmrk) |
7cc79c65a9e5
Keep the history of fairway marks
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
92 )); |