- use innodb

[packages/cacti.git] / cacti-pa.sql

diff --git a/cacti-pa.sql b/cacti-pa.sql
index d770696434b9866e27cc38a5f0d1e3920d98880f..582f6b70152a4ddaadc84f04dc753b62f9295c41 100644 (file)
--- a/cacti-pa.sql
+++ b/cacti-pa.sql
@@ -13,7 +13,7 @@ CREATE TABLE `plugin_config` (
   PRIMARY KEY  (`id`),
   KEY `status` (`status`),
   KEY `directory` (`directory`)
-) TYPE=MyISAM;
+) TYPE=InnoDB;
 
 -- --------------------------------------------------------
 
@@ -31,7 +31,7 @@ CREATE TABLE `plugin_hooks` (
   PRIMARY KEY  (`id`),
   KEY `hook` (`hook`),
   KEY `status` (`status`)
-) TYPE=MyISAM;
+) TYPE=InnoDB;
 
 -- --------------------------------------------------------
 
@@ -46,7 +46,7 @@ CREATE TABLE `plugin_realms` (
   `display` varchar(64) NOT NULL default '',
   PRIMARY KEY  (`id`),
   KEY `plugin` (`plugin`)
-) TYPE=MyISAM;
+) TYPE=InnoDB;
 
 
 CREATE TABLE `plugin_db_changes` (
@@ -58,7 +58,7 @@ CREATE TABLE `plugin_db_changes` (
   PRIMARY KEY  (`id`),
   KEY `plugin` (`plugin`),
   KEY `method` (`method`)
-) TYPE=MyISAM;
+) TYPE=InnoDB;
 
 
 REPLACE INTO `plugin_realms` VALUES (1, 'internal', 'plugins.php', 'Plugin Management');