summaryrefslogtreecommitdiff
path: root/sql-files/convert_engine.sql
blob: 9db50748e8dba491c35954cc719c1cf90bafcd87 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
--
-- eAthena Database Converter ( InnoDB -> MyISAM ) by Jaguar
--

ALTER TABLE `sc_data` DROP FOREIGN KEY `scdata_ibfk_1`, DROP FOREIGN KEY `scdata_ibfk_2`;
ALTER TABLE `guild` DROP FOREIGN KEY `guild_ibfk_1`;
ALTER TABLE `guild_alliance` DROP FOREIGN KEY `guild_alliance_ibfk_1`, DROP FOREIGN KEY `guild_alliance_ibfk_2`;
ALTER TABLE `guild_expulsion` DROP FOREIGN KEY `guild_expulsion_ibfk_1`;
ALTER TABLE `guild_member` DROP FOREIGN KEY `guild_member_ibfk_1`, DROP FOREIGN KEY `guild_member_ibfk_2`;
ALTER TABLE `guild_position` DROP FOREIGN KEY `guild_position_ibfk_1`;
ALTER TABLE `guild_skill` DROP FOREIGN KEY `guild_skill_ibfk_1`;
ALTER TABLE `guild_storage` DROP FOREIGN KEY `guild_storage_ibfk_1`;
ALTER TABLE `sc_data` TYPE = MYISAM;
ALTER TABLE `login` TYPE = MYISAM;
ALTER TABLE `char` TYPE = MYISAM;
ALTER TABLE `guild` TYPE = MYISAM;
ALTER TABLE `guild_alliance` TYPE = MYISAM;
ALTER TABLE `guild_expulsion` TYPE = MYISAM;
ALTER TABLE `guild_member` TYPE = MYISAM;
ALTER TABLE `guild_position` TYPE = MYISAM;
ALTER TABLE `guild_skill` TYPE = MYISAM;
ALTER TABLE `guild_storage` TYPE = MYISAM;