[Mapbender-commits] r3619 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2009-03-03 03:19:30 -0500 (Tue, 03 Mar 2009)
New Revision: 3619

Modified:
   trunk/mapbender/resources/db/update/update_2.6.sql
Log:
login.php with categories
2 new tables added to categorize the guis

Modified: trunk/mapbender/resources/db/update/update_2.6.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-02 14:58:45 UTC (rev 3618)
+++ trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-03 08:19:30 UTC (rev 3619)
@@ -270,4 +270,57 @@
 Update translations set msgstr='Referencia' where locale= 'es' and msgid = 'Legend';
 Update translations set msgstr='Mostrar mapa completo' where locale= 'es' and msgid = 'Display complete map';
 
-UPDATE gui_element SET e_mb_mod = 'geometry.js,requestGeometryConstructor.js,popup.js' WHERE e_id = 'setSpatialRequest'; 
\ No newline at end of file
+UPDATE gui_element SET e_mb_mod = 'geometry.js,requestGeometryConstructor.js,popup.js' WHERE e_id = 'setSpatialRequest'; 
+
+--
+-- building categories to sort the guis in the login.php
+-- have a look at http://www.mapbender.org/GUI_Category
+--
+
+-- new tables for category handling 
+CREATE TABLE public.gui_gui_category
+(
+  fkey_gui_id character varying(50),
+  fkey_gui_category_id integer
+);
+
+
+CREATE TABLE public.gui_category
+(
+  category_id serial,
+  category_name character varying(50),
+  category_description character varying(255),
+  CONSTRAINT pk_category_id PRIMARY KEY (category_id)
+);
+
+ALTER TABLE ONLY gui_gui_category
+    ADD CONSTRAINT gui_gui_category_ibfk_2 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+ALTER TABLE ONLY gui_gui_category
+    ADD CONSTRAINT gui_gui_category_ibfk_1 FOREIGN KEY (fkey_gui_category_id) REFERENCES gui_category(category_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+INSERT INTO gui_category (category_id, category_name, category_description) VALUES (1, 'Administration', 'Applications for administration');
+INSERT INTO gui_category (category_id, category_name, category_description) VALUES (3, 'WMS Container', NULL);
+INSERT INTO gui_category (category_id, category_name, category_description) VALUES (2, 'Mapbender Template Applications', 'Template Applications');
+
+INSERT INTO gui_gui_category ('admin1',1);
+INSERT INTO gui_gui_category ('admin2_de',1);
+INSERT INTO gui_gui_category ('admin2_en',1);
+INSERT INTO gui_gui_category ('admin_de_services',1);
+INSERT INTO gui_gui_category ('admin_en_services',1);
+INSERT INTO gui_gui_category ('gui',2);
+INSERT INTO gui_gui_category ('gui1',2);
+INSERT INTO gui_gui_category ('gui2',2);
+INSERT INTO gui_gui_category ('gui_digitize',2);
+INSERT INTO gui_gui_category ('wms_gdi_de',3);
+INSERT INTO gui_gui_category ('wms_germany',3);
+INSERT INTO gui_gui_category ('wms_europe',3);
+
+-- admin2_de - create a new category
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('admin2_de','createCategory',2,1,'create a gui category','Create a new category','a','','href = "../php/mod_createCategory.php?sessionID" target = "AdminFrame" ',8,680,140,20,5,'','create a gui category','a','','','','AdminFrame','http://www.mapbender.org/GUI_Category');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin2_de', 'createCategory', 'cssfile', '../css/administration_alloc.css', '' ,'file/css');
+
+-- admin2_de - add a gui to a category, remove it from a category
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('admin2_de','category_filteredGUI',2,1,'add Gui to Category','Add one user to serveral groups','a','','href = "../php/mod_category_filteredGUI.php?sessionID&e_id_css=filteredUser_filteredGroup" target = "AdminFrame" ',8,710,190,20,10,'','add Gui to Category','a','','','','AdminFrame','http://www.mapbender.org/GUI_Category');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin2_de', 'category_filteredGUI', 'cssfile', '../css/administration_alloc.css', 'css file for admin module' ,'file/css');
+