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

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Wed Feb 11 08:20:23 EST 2009


Author: christoph
Date: 2009-02-11 08:20:23 -0500 (Wed, 11 Feb 2009)
New Revision: 3530

Modified:
   branches/2.5/resources/db/mysql/iso/update/update_2.5_to_2.5.1rc1_mysql_ISO-8859-1.sql
   branches/2.5/resources/db/mysql/utf8/update/update_2.5_to_2.5.1rc1_mysql_UTF-8.sql
   branches/2.5/resources/db/postgresql/iso/update/update_2.5_to_2.5.1rc1_pgsql_ISO-8859-1.sql
   branches/2.5/resources/db/postgresql/utf8/update/update_2.5_to_2.5.1rc1_pgsql_UTF-8.sql
Log:
http://trac.osgeo.org/mapbender/ticket/374

Modified: branches/2.5/resources/db/mysql/iso/update/update_2.5_to_2.5.1rc1_mysql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/mysql/iso/update/update_2.5_to_2.5.1rc1_mysql_ISO-8859-1.sql	2009-02-11 13:19:02 UTC (rev 3529)
+++ branches/2.5/resources/db/mysql/iso/update/update_2.5_to_2.5.1rc1_mysql_ISO-8859-1.sql	2009-02-11 13:20:23 UTC (rev 3530)
@@ -2,10 +2,18 @@
 -- database changes in version 2.5.1
 --
 
-UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img'
+UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img';
 
 -- translations missing for bg,gr,nl
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set language', 'Sprache auswählen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Set language', 'Seleccion del idioma');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set language', 'Lingua');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('fr', 'Set language', 'Choisir une langue');
+
+
+-- enlarge WFS metadata columns
+ALTER TABLE wfs_featuretype MODIFY featuretype_abstract text;
+ALTER TABLE wfs_featuretype MODIFY featuretype_title varchar(255);
+ALTER TABLE wfs_featuretype MODIFY featuretype_name varchar(255) NOT NULL DEFAULT '';
+ALTER TABLE wfs_element MODIFY element_name varchar(255);
+ALTER TABLE wfs_element MODIFY element_type varchar(255);

Modified: branches/2.5/resources/db/mysql/utf8/update/update_2.5_to_2.5.1rc1_mysql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/mysql/utf8/update/update_2.5_to_2.5.1rc1_mysql_UTF-8.sql	2009-02-11 13:19:02 UTC (rev 3529)
+++ branches/2.5/resources/db/mysql/utf8/update/update_2.5_to_2.5.1rc1_mysql_UTF-8.sql	2009-02-11 13:20:23 UTC (rev 3530)
@@ -2,10 +2,18 @@
 -- database changes in version 2.5.1
 --
 
-UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img'
+UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img';
 
 -- translations missing for bg,gr,nl
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set language', 'Sprache auswählen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Set language', 'Selección del idioma');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set language', 'Lingua');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('fr', 'Set language', 'Choisir une langue');
+
+
+-- enlarge WFS metadata columns
+ALTER TABLE wfs_featuretype MODIFY featuretype_abstract text;
+ALTER TABLE wfs_featuretype MODIFY featuretype_title varchar(255);
+ALTER TABLE wfs_featuretype MODIFY featuretype_name varchar(255) NOT NULL DEFAULT '';
+ALTER TABLE wfs_element MODIFY element_name varchar(255);
+ALTER TABLE wfs_element MODIFY element_type varchar(255);

Modified: branches/2.5/resources/db/postgresql/iso/update/update_2.5_to_2.5.1rc1_pgsql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/postgresql/iso/update/update_2.5_to_2.5.1rc1_pgsql_ISO-8859-1.sql	2009-02-11 13:19:02 UTC (rev 3529)
+++ branches/2.5/resources/db/postgresql/iso/update/update_2.5_to_2.5.1rc1_pgsql_ISO-8859-1.sql	2009-02-11 13:20:23 UTC (rev 3530)
@@ -2,7 +2,7 @@
 -- database changes in version 2.5.1
 --
 
-UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img'
+UPDATE gui_element SET e_closetag = '' WHERE e_element = 'img';
 
 -- translations missing for bg,gr,nl
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set language', 'Sprache auswählen');
@@ -10,3 +10,9 @@
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set language', 'Lingua');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('fr', 'Set language', 'Choisir une langue');
 
+-- enlarge WFS metadata columns
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_abstract TYPE text;
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_title TYPE varchar(255);
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_name TYPE varchar(255);
+ALTER TABLE wfs_element ALTER COLUMN element_name TYPE varchar(255);
+ALTER TABLE wfs_element ALTER COLUMN element_type TYPE varchar(255);

Modified: branches/2.5/resources/db/postgresql/utf8/update/update_2.5_to_2.5.1rc1_pgsql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/postgresql/utf8/update/update_2.5_to_2.5.1rc1_pgsql_UTF-8.sql	2009-02-11 13:19:02 UTC (rev 3529)
+++ branches/2.5/resources/db/postgresql/utf8/update/update_2.5_to_2.5.1rc1_pgsql_UTF-8.sql	2009-02-11 13:20:23 UTC (rev 3530)
@@ -9,3 +9,11 @@
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Set language', 'Selección del idioma');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set language', 'Lingua');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('fr', 'Set language', 'Choisir une langue');
+
+
+-- enlarge WFS metadata columns
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_abstract TYPE text;
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_title TYPE varchar(255);
+ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_name TYPE varchar(255);
+ALTER TABLE wfs_element ALTER COLUMN element_name TYPE varchar(255);
+ALTER TABLE wfs_element ALTER COLUMN element_type TYPE varchar(255);



More information about the Mapbender_commits mailing list