[Mapbender-commits] r3486 - branches/astroidex_25/resources/db/postgresql/utf8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2009-01-22 17:46:58 -0500 (Thu, 22 Jan 2009)
New Revision: 3486

Modified:
   branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql
Log:
module sql added

Modified: branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql
===================================================================
--- branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql	2009-01-22 22:39:56 UTC (rev 3485)
+++ branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql	2009-01-22 22:46:58 UTC (rev 3486)
@@ -1,3 +1,8 @@
+--
+-- 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
 (
@@ -20,5 +25,11 @@
 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;
 
--- to add category handling to admin gui
-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','createCatefory',2,1,'define categories','Create a new category','a','','href = "../php/mod_createCategory.php?sessionID" target = "AdminFrame" ',8,800,85,20,5,'','Category anlegen','a','','','','AdminFrame','http://www.mapbender.org/index.php/newGUI');
\ No newline at end of file
+-- 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');
+
+-- 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');
+