[Mapbender-commits] r2818 - branches/2.5/resources/db/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-08-15 07:22:37 -0400 (Fri, 15 Aug 2008)
New Revision: 2818

Added:
   branches/2.5/resources/db/update/update_2.5rc6_mysql.sql
   branches/2.5/resources/db/update/update_2.5rc6_pgsql.sql
Log:
update sqls

Added: branches/2.5/resources/db/update/update_2.5rc6_mysql.sql
===================================================================
--- branches/2.5/resources/db/update/update_2.5rc6_mysql.sql	                        (rev 0)
+++ branches/2.5/resources/db/update/update_2.5rc6_mysql.sql	2008-08-15 11:22:37 UTC (rev 2818)
@@ -0,0 +1,7 @@
+UPDATE gui_element SET e_mb_mod = 'mod_addWMSgeneralFunctions.js' WHERE e_id = 'addWMS';
+
+ALTER TABLE gui_element MODIFY e_js_file character varying(255);
+ALTER TABLE gui_element MODIFY e_mb_mod character varying(255);
+ALTER TABLE wms MODIFY fees text;
+ALTER TABLE wms CHANGE COLUMN wms_mb_getcapabilies_doc wms_mb_getcapabilities_doc text;
+

Added: branches/2.5/resources/db/update/update_2.5rc6_pgsql.sql
===================================================================
--- branches/2.5/resources/db/update/update_2.5rc6_pgsql.sql	                        (rev 0)
+++ branches/2.5/resources/db/update/update_2.5rc6_pgsql.sql	2008-08-15 11:22:37 UTC (rev 2818)
@@ -0,0 +1,7 @@
+UPDATE gui_element SET e_mb_mod = 'mod_addWMSgeneralFunctions.js' WHERE e_id = 'addWMS';
+
+ALTER TABLE gui_element ALTER COLUMN e_js_file TYPE character varying(255);
+ALTER TABLE gui_element ALTER COLUMN e_mb_mod TYPE character varying(255);
+ALTER TABLE wms ALTER COLUMN fees TYPE text;
+ALTER TABLE wms RENAME COLUMN wms_mb_getcapabilies_doc TO wms_mb_getcapabilities_doc;
+