[Mapbender-commits] r1648 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-08-09 09:15:11 -0400 (Thu, 09 Aug 2007)
New Revision: 1648

Modified:
   trunk/mapbender/resources/db/update/update_mysql_db.sql
Log:
database changes for version 2.5, function has to be translated

Modified: trunk/mapbender/resources/db/update/update_mysql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_mysql_db.sql	2007-08-09 13:14:14 UTC (rev 1647)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql	2007-08-09 13:15:11 UTC (rev 1648)
@@ -1,4 +1,39 @@
 --
 -- no changes in version 2.4.2
 --
+-- notice language plpgsql has to be installed
+-- 
 
+--
+-- 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) NULL;
+
+--
+-- table gui_element: new column for translation
+--
+ ALTER TABLE gui_element ADD COLUMN e_title VARCHAR(255) NULL;
+
+-- 
+-- new table translation: new table for translations
+-- 
+
+ CREATE TABLE translations
+ (
+   trs_id int(11) NOT NULL auto_increment,
+   locale varchar(8),
+   msgid varchar(512),
+   msgstr varchar(512),
+   PRIMARY KEY (trs_id)
+ );
+ 
+ CREATE INDEX msgid_idx ON translations(msgid);
+
+-- 
+-- new function gettext for easy translations
+-- 
+
+-- function has to be translated
+
+
+