[Mapbender-commits] r3044 - in branches/2.5/resources/db/postgresql: iso/update utf8/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-09-30 04:05:29 -0400 (Tue, 30 Sep 2008)
New Revision: 3044

Modified:
   branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql
   branches/2.5/resources/db/postgresql/utf8/update/update_2.4.5_to_2.5_pgsql_UTF-8.sql
Log:
* removed obsolete sql "f_auth_varname"
* changed syntax from "MODIFY"

Modified: branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql	2008-09-29 14:42:34 UTC (rev 3043)
+++ branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql	2008-09-30 08:05:29 UTC (rev 3044)
@@ -115,7 +115,6 @@
 --
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
-ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
 ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
 ALTER TABLE wfs_conf_element ADD COLUMN f_operator VARCHAR(50);
 
@@ -531,10 +530,10 @@
 --
 ALTER TABLE gui_wms ADD COLUMN gui_wms_opacity INT DEFAULT 100;
 
-
 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;
\ No newline at end of file
+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;
+

Modified: branches/2.5/resources/db/postgresql/utf8/update/update_2.4.5_to_2.5_pgsql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/postgresql/utf8/update/update_2.4.5_to_2.5_pgsql_UTF-8.sql	2008-09-29 14:42:34 UTC (rev 3043)
+++ branches/2.5/resources/db/postgresql/utf8/update/update_2.4.5_to_2.5_pgsql_UTF-8.sql	2008-09-30 08:05:29 UTC (rev 3044)
@@ -115,7 +115,6 @@
 --
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
-ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
 ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
 ALTER TABLE wfs_conf_element ADD COLUMN f_operator VARCHAR(50);
 
@@ -533,8 +532,9 @@
 
 
 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;
\ No newline at end of file
+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;
+