convert_engine_myisam.sql 3.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. --
  2. -- rAthena Database Converter ( InnoDB -> MyISAM )
  3. --
  4. ALTER TABLE `acc_reg_num` ENGINE = MyISAM;
  5. ALTER TABLE `acc_reg_str` ENGINE = MyISAM;
  6. ALTER TABLE `achievement` ENGINE = MyISAM;
  7. #ALTER TABLE `atcommandlog` ENGINE = MyISAM;
  8. ALTER TABLE `auction` ENGINE = MyISAM;
  9. ALTER TABLE `bonus_script` ENGINE = MyISAM;
  10. #ALTER TABLE `branchlog` ENGINE = MyISAM;
  11. ALTER TABLE `buyingstore_items` ENGINE = MyISAM;
  12. ALTER TABLE `buyingstores` ENGINE = MyISAM;
  13. ALTER TABLE `cart_inventory` ENGINE = MyISAM;
  14. #ALTER TABLE `cashlog` ENGINE = MyISAM;
  15. ALTER TABLE `char` ENGINE = MyISAM;
  16. ALTER TABLE `char_reg_num` ENGINE = MyISAM;
  17. ALTER TABLE `char_reg_str` ENGINE = MyISAM;
  18. ALTER TABLE `charlog` ENGINE = MyISAM;
  19. #ALTER TABLE `chatlog` ENGINE = MyISAM;
  20. ALTER TABLE `clan` ENGINE = MyISAM;
  21. ALTER TABLE `clan_alliance` ENGINE = MyISAM;
  22. #ALTER TABLE `db_roulette` ENGINE = MyISAM;
  23. ALTER TABLE `elemental` ENGINE = MyISAM;
  24. #ALTER TABLE `feedinglog` ENGINE = MyISAM;
  25. ALTER TABLE `friends` ENGINE = MyISAM;
  26. ALTER TABLE `global_acc_reg_num` ENGINE = MyISAM;
  27. ALTER TABLE `global_acc_reg_str` ENGINE = MyISAM;
  28. ALTER TABLE `guild` ENGINE = MyISAM;
  29. ALTER TABLE `guild_alliance` ENGINE = MyISAM;
  30. ALTER TABLE `guild_castle` ENGINE = MyISAM;
  31. ALTER TABLE `guild_expulsion` ENGINE = MyISAM;
  32. ALTER TABLE `guild_member` ENGINE = MyISAM;
  33. ALTER TABLE `guild_position` ENGINE = MyISAM;
  34. ALTER TABLE `guild_skill` ENGINE = MyISAM;
  35. ALTER TABLE `guild_storage` ENGINE = MyISAM;
  36. ALTER TABLE `guild_storage_log` ENGINE = MyISAM;
  37. ALTER TABLE `homunculus` ENGINE = MyISAM;
  38. ALTER TABLE `hotkey` ENGINE = MyISAM;
  39. ALTER TABLE `interlog` ENGINE = MyISAM;
  40. ALTER TABLE `inventory` ENGINE = MyISAM;
  41. ALTER TABLE `ipbanlist` ENGINE = MyISAM;
  42. #ALTER TABLE `item_cash_db` ENGINE = MyISAM;
  43. #ALTER TABLE `item_cash_db2` ENGINE = MyISAM;
  44. #ALTER TABLE `item_db` ENGINE = MyISAM;
  45. #ALTER TABLE `item_db_re` ENGINE = MyISAM;
  46. #ALTER TABLE `item_db2` ENGINE = MyISAM;
  47. #ALTER TABLE `item_db2_re` ENGINE = MyISAM;
  48. ALTER TABLE `login` ENGINE = MyISAM;
  49. #ALTER TABLE `loginlog` ENGINE = MyISAM;
  50. ALTER TABLE `mail` ENGINE = MyISAM;
  51. ALTER TABLE `mail_attachments` ENGINE = MyISAM;
  52. ALTER TABLE `mapreg` ENGINE = MyISAM;
  53. ALTER TABLE `market` ENGINE = MyISAM;
  54. ALTER TABLE `memo` ENGINE = MyISAM;
  55. ALTER TABLE `mercenary` ENGINE = MyISAM;
  56. ALTER TABLE `mercenary_owner` ENGINE = MyISAM;
  57. #ALTER TABLE `mob_db` ENGINE = MyISAM;
  58. #ALTER TABLE `mob_db_re` ENGINE = MyISAM;
  59. #ALTER TABLE `mob_db2` ENGINE = MyISAM;
  60. #ALTER TABLE `mob_db2_re` ENGINE = MyISAM;
  61. #ALTER TABLE `mob_skill_db` ENGINE = MyISAM;
  62. #ALTER TABLE `mob_skill_db_re` ENGINE = MyISAM;
  63. #ALTER TABLE `mob_skill_db2` ENGINE = MyISAM;
  64. #ALTER TABLE `mob_skill_db2_re` ENGINE = MyISAM;
  65. #ALTER TABLE `mvplog` ENGINE = MyISAM;
  66. #ALTER TABLE `npclog` ENGINE = MyISAM;
  67. ALTER TABLE `party` ENGINE = MyISAM;
  68. ALTER TABLE `pet` ENGINE = MyISAM;
  69. #ALTER TABLE `picklog` ENGINE = MyISAM;
  70. ALTER TABLE `quest` ENGINE = MyISAM;
  71. ALTER TABLE `sales` ENGINE = MyISAM;
  72. ALTER TABLE `sc_data` ENGINE = MyISAM;
  73. ALTER TABLE `skill` ENGINE = MyISAM;
  74. ALTER TABLE `skill_homunculus` ENGINE = MyISAM;
  75. ALTER TABLE `skillcooldown` ENGINE = MyISAM;
  76. ALTER TABLE `storage` ENGINE = MyISAM;
  77. ALTER TABLE `vending_items` ENGINE = MyISAM;
  78. ALTER TABLE `vendings` ENGINE = MyISAM;
  79. #ALTER TABLE `zenylog` ENGINE = MyISAM;