[Mapbender-commits] r2819 - branches/2.5/resources/db/mysql

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-08-15 07:26:10 -0400 (Fri, 15 Aug 2008)
New Revision: 2819

Modified:
   branches/2.5/resources/db/mysql/mysql_schema.sql
Log:
changed engine to innodb for some tables

added update sqls

Modified: branches/2.5/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/2.5/resources/db/mysql/mysql_schema.sql	2008-08-15 11:22:37 UTC (rev 2818)
+++ branches/2.5/resources/db/mysql/mysql_schema.sql	2008-08-15 11:26:10 UTC (rev 2819)
@@ -121,7 +121,7 @@
   PRIMARY KEY  (kml_id),
   KEY gui_kml_fkey_mb_user_id (fkey_mb_user_id),
   KEY gui_kml_id_fkey_gui_id (fkey_gui_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- 
 -- Daten für Tabelle 'gui_kml'
@@ -249,7 +249,7 @@
   fkey_wfs_conf_id int(11) NOT NULL default '0',
   PRIMARY KEY  (fkey_gui_id,fkey_wfs_conf_id),
   KEY gui_wfs_conf_ibfk_2 (fkey_wfs_conf_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- 
 -- Daten für Tabelle 'gui_wfs_conf'
@@ -377,7 +377,7 @@
 CREATE TABLE IF NOT EXISTS layer_load_count (
   fkey_layer_id int(11) default NULL,
   load_count bigint(20) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- 
 -- Daten für Tabelle 'layer_load_count'
@@ -443,7 +443,7 @@
   request text,
   PRIMARY KEY  (id),
   KEY logindex (id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- 
 -- Daten für Tabelle 'mb_log'
@@ -775,7 +775,7 @@
   fkey_keyword_id int(11) NOT NULL,
   KEY fkey_keyword_id_fkey_featuretype_id (fkey_keyword_id),
   KEY fkey_featuretype_id_fkey_keyword_id (fkey_featuretype_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- 
 -- Daten für Tabelle 'wfs_featuretype_keyword'
@@ -1063,3 +1063,12 @@
 -- 
 ALTER TABLE `wms_srs`
   ADD CONSTRAINT wms_srs_ibfk_1 FOREIGN KEY (fkey_wms_id) REFERENCES wms (wms_id) ON DELETE CASCADE ON UPDATE CASCADE;
+
+  
+  
+  
+  
+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