[Mapbender-commits] r10372 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-12-17 02:07:08 -0800 (Tue, 17 Dec 2019)
New Revision: 10372

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.8_pgsql_UTF-8.sql
Log:
alter user table (add preferred gui option) in 2.7.4 to 2.8 not in 2.8+

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2019-12-17 09:58:57 UTC (rev 10371)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2019-12-17 10:07:08 UTC (rev 10372)
@@ -3835,5 +3835,19 @@
   USING btree
   (dataset_timestamp);
 
+-- 2019-0-17 - add option to have a preferred gui defined for a user account
+-- Column: fkey_preferred_gui_id
 
+-- ALTER TABLE mb_user DROP COLUMN fkey_preferred_gui_id;
 
+ALTER TABLE mb_user ADD COLUMN fkey_preferred_gui_id character varying(50);
+
+-- Foreign Key: fkey_preferred_gui_id_fkey
+
+-- ALTER TABLE mb_user DROP CONSTRAINT fkey_preferred_gui_id_fkey;
+
+ALTER TABLE mb_user
+  ADD CONSTRAINT fkey_preferred_gui_id_fkey FOREIGN KEY (fkey_preferred_gui_id)
+      REFERENCES gui (gui_id) MATCH SIMPLE
+      ON UPDATE CASCADE;
+

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.8_pgsql_UTF-8.sql	2019-12-17 09:58:57 UTC (rev 10371)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.8_pgsql_UTF-8.sql	2019-12-17 10:07:08 UTC (rev 10372)
@@ -135,22 +135,7 @@
 -- 2019-09-13 - update css to have a nicer default gui!
 update gui_element set e_width=null, e_height=null where e_id = 'body' AND fkey_gui_id IN ( 'Administration_DE', 'PortalAdmin_DE', 'admin1');
 --update gui_element set e_width=null, e_height=null where e_id = 'body' AND fkey_gui_id IN ( 'BPlan-ID-Vergabe-Verbände','FPlan-ID-Vergabe');
---TODO: admin_wmc_metadata, admin_dataset_metadata, admin_wms_metadata, ...
--- 2019-0-17 - add option to have a preferred gui defined for a user account
--- Column: fkey_preferred_gui_id
 
--- ALTER TABLE mb_user DROP COLUMN fkey_preferred_gui_id;
-
-ALTER TABLE mb_user ADD COLUMN fkey_preferred_gui_id character varying(50);
-
--- Foreign Key: fkey_preferred_gui_id_fkey
-
--- ALTER TABLE mb_user DROP CONSTRAINT fkey_preferred_gui_id_fkey;
-
-ALTER TABLE mb_user
-  ADD CONSTRAINT fkey_preferred_gui_id_fkey FOREIGN KEY (fkey_preferred_gui_id)
-      REFERENCES gui (gui_id) MATCH SIMPLE
-      ON UPDATE CASCADE;
 --todo sql body element e_width=null ... e_styles: overflow:scroll; ....
 
 -- new for search for applications - materialized view: