diff options
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/base/world_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9708_characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/9708_world_database.sql | 5 |
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; + |