convert_engine.sql 1.1 KB

12345678910111213141516171819202122
  1. --
  2. -- eAthena Database Converter ( InnoDB -> MyISAM ) by Jaguar
  3. --
  4. ALTER TABLE `sc_data` DROP FOREIGN KEY `scdata_ibfk_1`, DROP FOREIGN KEY `scdata_ibfk_2`;
  5. ALTER TABLE `guild` DROP FOREIGN KEY `guild_ibfk_1`;
  6. ALTER TABLE `guild_alliance` DROP FOREIGN KEY `guild_alliance_ibfk_1`, DROP FOREIGN KEY `guild_alliance_ibfk_2`;
  7. ALTER TABLE `guild_expulsion` DROP FOREIGN KEY `guild_expulsion_ibfk_1`;
  8. ALTER TABLE `guild_member` DROP FOREIGN KEY `guild_member_ibfk_1`, DROP FOREIGN KEY `guild_member_ibfk_2`;
  9. ALTER TABLE `guild_position` DROP FOREIGN KEY `guild_position_ibfk_1`;
  10. ALTER TABLE `guild_skill` DROP FOREIGN KEY `guild_skill_ibfk_1`;
  11. ALTER TABLE `guild_storage` DROP FOREIGN KEY `guild_storage_ibfk_1`;
  12. ALTER TABLE `sc_data` TYPE = MYISAM;
  13. ALTER TABLE `login` TYPE = MYISAM;
  14. ALTER TABLE `char` TYPE = MYISAM;
  15. ALTER TABLE `guild` TYPE = MYISAM;
  16. ALTER TABLE `guild_alliance` TYPE = MYISAM;
  17. ALTER TABLE `guild_expulsion` TYPE = MYISAM;
  18. ALTER TABLE `guild_member` TYPE = MYISAM;
  19. ALTER TABLE `guild_position` TYPE = MYISAM;
  20. ALTER TABLE `guild_skill` TYPE = MYISAM;
  21. ALTER TABLE `guild_storage` TYPE = MYISAM;