[Mapbender-commits] r1657 - trunk/mapbender/resources/db/mysql

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-08-10 06:03:08 -0400 (Fri, 10 Aug 2007)
New Revision: 1657

Modified:
   trunk/mapbender/resources/db/mysql/mysql_schema.sql
Log:
database changes for version 2.5 integrated

Modified: trunk/mapbender/resources/db/mysql/mysql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-08-10 10:01:38 UTC (rev 1656)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-08-10 10:03:08 UTC (rev 1657)
@@ -30,6 +30,7 @@
   e_pos tinyint(4) unsigned zerofill default NULL,
   e_public tinyint(1) unsigned zerofill default NULL,
   e_comment text,
+  e_title varchar(255),
   e_element varchar(255) NOT NULL default '',
   e_src varchar(255) default NULL,
   e_attributes longtext,
@@ -332,6 +333,20 @@
 
 -- --------------------------------------------------------
 
+ -- 
+ -- 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)
+ ) TYPE=InnoDB;
+ 
+ CREATE INDEX msgid_idx ON translations(msgid);
+
 --
 -- Tabellenstruktur für Tabelle `wfs`
 --
@@ -397,6 +412,7 @@
   f_form_element_html TEXT NULL,
   f_edit int4,
   f_mandatory int4,
+  f_auth_varname VARCHAR(50),
   PRIMARY KEY  (wfs_conf_element_id),
   KEY fkey_wfs_conf_id (fkey_wfs_conf_id)
 ) TYPE=InnoDB;