creature_respawn should be InnoDB since it's prone to continuous writes

--HG--
branch : trunk

2 files changed, 2 insertions, 1 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 3245fd5bb44..0cde2c20516 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1575,7 +1575,7 @@ CREATE TABLE `creature_respawn` (
   `instance` mediumint(8) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`instance`),
   KEY `instance` (`instance`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
diff --git a/sql/updates/9709_world_creature_respawn.sql b/sql/updates/9709_world_creature_respawn.sql
new file mode 100644
index 00000000000..00cd83b51c2
--- /dev/null
+++ b/sql/updates/9709_world_creature_respawn.sql
@@ -0,0 +1 @@
+ALTER TABLE `creature_respawn` ENGINE = InnoDB;