SQLS/Creation: Fix default engine for tables in world and characters

--HG--
branch : trunk

4 files changed, 15 insertions, 6 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 52adfc53436..d0e9503b701 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -301,7 +301,7 @@ CREATE TABLE `bugreport` (
   `type` longtext NOT NULL default '',
   `content` longtext NOT NULL default '',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -329,7 +329,7 @@ CREATE TABLE `channels` (
   `m_password` text,
   `BannedList` longtext,
   PRIMARY KEY  (`m_name`(10),`m_team`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 4bd384ef15a..3245fd5bb44 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -941,7 +941,7 @@ CREATE TABLE `creature_classlevelstats` (
   `basehp2` smallint(2) NOT NULL,  
   `basemana` smallint(2) NOT NULL,
   `basearmor` smallint(2) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -4880,7 +4880,7 @@ CREATE TABLE `season_linked_event` (
  `event` int(8) UNSIGNED NOT NULL default '0',
  PRIMARY KEY (`season`),
  UNIQUE (`season`,`event`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -7577,7 +7577,7 @@ CREATE TABLE `spell_group_stack_rules` (
   `group_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
   `stack_rule` TINYINT(3) NOT NULL DEFAULT 0,
   PRIMARY KEY (`group_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -7647,7 +7647,7 @@ CREATE TABLE `spell_ranks` (
   `rank` TINYINT UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY  (`first_spell_id`, `rank`),
   UNIQUE (`spell_id`)
-) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Rank Data';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Rank Data';
 
 --
 -- Dumping data for table `spell_ranks`
diff --git a/sql/updates/9708_characters_database.sql b/sql/updates/9708_characters_database.sql
new file mode 100644
index 00000000000..ae461a8dfe0
--- /dev/null
+++ b/sql/updates/9708_characters_database.sql
@@ -0,0 +1,4 @@
+-- Set the correct engine
+ALTER TABLE `bugreport` ENGINE=InnoDB;
+ALTER TABLE `channels` ENGINE=InnoDB;
+
diff --git a/sql/updates/9708_world_database.sql b/sql/updates/9708_world_database.sql
new file mode 100644
index 00000000000..87cf83da242
--- /dev/null
+++ b/sql/updates/9708_world_database.sql
@@ -0,0 +1,5 @@
+-- Set the correct engine
+ALTER TABLE `spell_group_stack_rules` ENGINE=MyISAM;
+ALTER TABLE `creature_classlevelstats` ENGINE=MyISAM;
+ALTER TABLE `season_linked_event` ENGINE=MyISAM;
+