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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-02-16 06:35:22 -0500 (Tue, 16 Feb 2010)
New Revision: 5509

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
* added PRIMARYKEy for Table gui_gui_category

* add Application toolbox_jquery to category 

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-02-16 11:27:03 UTC (rev 5508)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-02-16 11:35:22 UTC (rev 5509)
@@ -1231,7 +1231,8 @@
 --
 -- add jq_datatables to applications with element gazetteerWFS
 --
-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) 
+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) 
 Select gui_element.fkey_gui_id ,
 'jq_datatables',1,1,'Includes the jQuery plugin datatables, use like this
 $(selector).datatables(options)','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/jq_datatables.js','../extensions/dataTables-1.5/media/js/jquery.dataTables.min.js','','','http://www.datatables.net/' 
@@ -1248,4 +1249,15 @@
 gui_element.fkey_gui_id 
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'jq_datatables' AND var_name = 'defaultCss');
 
+--
+-- added PRIMARYKEy for Table gui_gui_category
+--
+Alter Table gui_gui_category ADD
+  CONSTRAINT pk_gui_gui_category PRIMARY KEY (fkey_gui_id, fkey_gui_category_id);
 
+--
+-- add Application toolbox_jquery to category 
+--
+INSERT INTO gui_gui_category (fkey_gui_id, fkey_gui_category_id)
+VALUES('toolbox_jquery',2);
+