Mercurial > gemma

comparison schema/updates/1405/02.recreate_fm_indexes.sql @ 4956:7cc79c65a9e5 fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Keep the history of fairway marks ToDo: Set end to validity period when an entry can no longer be found in a data source.
author Tom Gottfried <tom@intevation.de>
date Wed, 26 Feb 2020 12:18:15 +0100
parents
children
comparison
equal deleted inserted replaced
4955:5c43427fc2bf 4956:7cc79c65a9e5
1 CREATE UNIQUE INDEX fairway_marks_bcnlat_distinct_rows
2 ON waterway.fairway_marks_bcnlat
3 ((CAST((validity, last_found, geom,
4 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
5 scamin, picrep, txtdsc, sordat, sorind,
6 0, colour, colpat, condtn, bcnshp, catlam
7 ) AS waterway.fairway_marks_bcnlat)
8 ));
9
10 CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows
11 ON waterway.fairway_marks_boycar
12 ((CAST((validity, last_found, geom,
13 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
14 scamin, picrep, txtdsc, sordat, sorind,
15 0, colour, colpat, conrad, marsys, boyshp, catcam
16 ) AS waterway.fairway_marks_boycar)
17 ));
18
19 CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows
20 ON waterway.fairway_marks_boylat
21 ((CAST((validity, last_found, geom,
22 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
23 scamin, picrep, txtdsc, sordat, sorind,
24 0, colour, colpat, conrad, marsys, boyshp, catlam
25 ) AS waterway.fairway_marks_boylat)
26 ));
27
28
29 CREATE UNIQUE INDEX fairway_marks_boysaw_distinct_rows
30 ON waterway.fairway_marks_boysaw
31 ((CAST((validity, last_found, geom,
32 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
33 scamin, picrep, txtdsc, sordat, sorind,
34 0, colour, colpat, conrad, marsys, boyshp
35 ) AS waterway.fairway_marks_boysaw)
36 ));
37
38 CREATE UNIQUE INDEX fairway_marks_boyspp_distinct_rows
39 ON waterway.fairway_marks_boyspp
40 ((CAST((validity, last_found, geom,
41 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
42 scamin, picrep, txtdsc, sordat, sorind,
43 0, colour, colpat, conrad, marsys, boyshp, catspm
44 ) AS waterway.fairway_marks_boyspp)
45 ));
46
47 CREATE UNIQUE INDEX fairway_marks_daymar_distinct_rows
48 ON waterway.fairway_marks_daymar
49 ((CAST((validity, last_found, geom,
50 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
51 scamin, picrep, txtdsc, sordat, sorind,
52 0, colour, colpat, condtn, topshp, orient
53 ) AS waterway.fairway_marks_daymar)
54 ));
55
56 CREATE UNIQUE INDEX fairway_marks_lights_distinct_rows
57 ON waterway.fairway_marks_lights
58 ((CAST((validity, last_found, geom,
59 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
60 scamin, picrep, txtdsc, sordat, sorind,
61 0, colour, condtn, orient, catlit, exclit, litchr, litvis,
62 mltylt, sectr1, sectr2, siggrp, sigper, sigseq, status
63 ) AS waterway.fairway_marks_lights)
64 ));
65
66 CREATE UNIQUE INDEX fairway_marks_rtpbcn_distinct_rows
67 ON waterway.fairway_marks_rtpbcn
68 ((CAST((validity, last_found, geom,
69 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
70 scamin, picrep, txtdsc, sordat, sorind,
71 0, condtn, siggrp, catrtb, radwal
72 ) AS waterway.fairway_marks_rtpbcn)
73 ));
74
75 CREATE UNIQUE INDEX fairway_marks_topmar_distinct_rows
76 ON waterway.fairway_marks_topmar
77 ((CAST((validity, last_found, geom,
78 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
79 scamin, picrep, txtdsc, sordat, sorind,
80 0, colour, colpat, condtn, topshp
81 ) AS waterway.fairway_marks_topmar)
82 ));
83
84 CREATE UNIQUE INDEX fairway_marks_notmrk_distinct_rows
85 ON waterway.fairway_marks_notmrk
86 ((CAST((validity, last_found, geom,
87 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
88 scamin, picrep, txtdsc, sordat, sorind,
89 0, condtn, marsys, orient, status, addmrk, catnmk,
90 disipd, disipu, disbk1, disbk2, fnctnm, bnkwtw
91 ) AS waterway.fairway_marks_notmrk)
92 ));