Mercurial > gemma
view schema/updates/1407/01.distinguish_boylat_hydro_ienc.sql @ 5508:29af073c824d deactivate-users
Client: Implement reactivating of user
* Add HTTP request to reactivate a deactivated user
* This is done from the user's edit-dialog while typing an email for this user is necessary to complete this process.
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Thu, 23 Sep 2021 17:33:07 +0200 |
parents | 58dc06e91c39 |
children |
line wrap: on
line source
CREATE TABLE waterway.fairway_marks_boylat_new ( colour varchar, colpat varchar, conrad int, marsys int, boyshp int, catlam int ) INHERITS (waterway.fairway_marks); CREATE TABLE waterway.fairway_marks_boylat_hydro ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ) INHERITS (waterway.fairway_marks_boylat_new); CREATE UNIQUE INDEX fairway_marks_boylat_hydro_distinct_rows ON waterway.fairway_marks_boylat_hydro ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, colour, colpat, conrad, marsys, boyshp, catlam, 0 ) AS waterway.fairway_marks_boylat_hydro) )); CREATE TABLE waterway.fairway_marks_boylat_ienc ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ) INHERITS (waterway.fairway_marks_boylat_new); CREATE UNIQUE INDEX fairway_marks_boylat_ienc_distinct_rows ON waterway.fairway_marks_boylat_ienc ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, colour, colpat, conrad, marsys, boyshp, catlam, 0 ) AS waterway.fairway_marks_boylat_ienc) )); -- Assume all features are IENC features, since there are currently only -- very few features in the data source for HYDRO features INSERT INTO waterway.fairway_marks_boylat_ienc OVERRIDING USER VALUE SELECT validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, colour, colpat, conrad, marsys, boyshp, catlam, id FROM waterway.fairway_marks_boylat; -- Finally DROP TABLE waterway.fairway_marks_boylat; ALTER TABLE waterway.fairway_marks_boylat_new RENAME TO fairway_marks_boylat; GRANT SELECT on ALL tables in schema waterway TO waterway_user; GRANT INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA waterway TO waterway_admin;