Mercurial > gemma
view schema/updates/1405/02.recreate_fm_indexes.sql @ 5132:8d5e3ce27d20
client: Time based search
* Add Time parameter to the search request when Time slider is active
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Fri, 27 Mar 2020 15:30:15 +0100 |
parents | 7cc79c65a9e5 |
children |
line wrap: on
line source
CREATE UNIQUE INDEX fairway_marks_bcnlat_distinct_rows ON waterway.fairway_marks_bcnlat ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, condtn, bcnshp, catlam ) AS waterway.fairway_marks_bcnlat) )); CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows ON waterway.fairway_marks_boycar ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, conrad, marsys, boyshp, catcam ) AS waterway.fairway_marks_boycar) )); CREATE UNIQUE INDEX fairway_marks_boylat_distinct_rows ON waterway.fairway_marks_boylat ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, conrad, marsys, boyshp, catlam ) AS waterway.fairway_marks_boylat) )); CREATE UNIQUE INDEX fairway_marks_boysaw_distinct_rows ON waterway.fairway_marks_boysaw ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, conrad, marsys, boyshp ) AS waterway.fairway_marks_boysaw) )); CREATE UNIQUE INDEX fairway_marks_boyspp_distinct_rows ON waterway.fairway_marks_boyspp ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, conrad, marsys, boyshp, catspm ) AS waterway.fairway_marks_boyspp) )); CREATE UNIQUE INDEX fairway_marks_daymar_distinct_rows ON waterway.fairway_marks_daymar ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, condtn, topshp, orient ) AS waterway.fairway_marks_daymar) )); CREATE UNIQUE INDEX fairway_marks_lights_distinct_rows ON waterway.fairway_marks_lights ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, condtn, orient, catlit, exclit, litchr, litvis, mltylt, sectr1, sectr2, siggrp, sigper, sigseq, status ) AS waterway.fairway_marks_lights) )); CREATE UNIQUE INDEX fairway_marks_rtpbcn_distinct_rows ON waterway.fairway_marks_rtpbcn ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, condtn, siggrp, catrtb, radwal ) AS waterway.fairway_marks_rtpbcn) )); CREATE UNIQUE INDEX fairway_marks_topmar_distinct_rows ON waterway.fairway_marks_topmar ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, colour, colpat, condtn, topshp ) AS waterway.fairway_marks_topmar) )); CREATE UNIQUE INDEX fairway_marks_notmrk_distinct_rows ON waterway.fairway_marks_notmrk ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, 0, condtn, marsys, orient, status, addmrk, catnmk, disipd, disipu, disbk1, disbk2, fnctnm, bnkwtw ) AS waterway.fairway_marks_notmrk) ));