summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/convert_engine_innodb.sql70
-rw-r--r--sql-files/convert_engine_myisam.sql70
-rw-r--r--sql-files/item_db.sql2
-rw-r--r--sql-files/item_db2.sql2
-rw-r--r--sql-files/logs.sql14
-rw-r--r--sql-files/main.sql56
-rw-r--r--sql-files/mob_db.sql2
-rw-r--r--sql-files/mob_db2.sql2
-rw-r--r--sql-files/upgrade_svn11018.sql2
9 files changed, 112 insertions, 108 deletions
diff --git a/sql-files/convert_engine_innodb.sql b/sql-files/convert_engine_innodb.sql
index f2610a775..bc926373c 100644
--- a/sql-files/convert_engine_innodb.sql
+++ b/sql-files/convert_engine_innodb.sql
@@ -2,37 +2,39 @@
-- eAthena Database Converter ( MyISAM -> InnoDB )
--
-ALTER TABLE `cart_inventory` TYPE = InnoDB;
-ALTER TABLE `char` TYPE = InnoDB;
-ALTER TABLE `charlog` TYPE = InnoDB;
-ALTER TABLE `friends` TYPE = InnoDB;
-ALTER TABLE `global_reg_value` TYPE = InnoDB;
-ALTER TABLE `guild` TYPE = InnoDB;
-ALTER TABLE `guild_alliance` TYPE = InnoDB;
-ALTER TABLE `guild_castle` TYPE = InnoDB;
-ALTER TABLE `guild_expulsion` TYPE = InnoDB;
-ALTER TABLE `guild_member` TYPE = InnoDB;
-ALTER TABLE `guild_position` TYPE = InnoDB;
-ALTER TABLE `guild_skill` TYPE = InnoDB;
-ALTER TABLE `guild_storage` TYPE = InnoDB;
-ALTER TABLE `homunculus` TYPE = InnoDB;
-ALTER TABLE `interlog` TYPE = InnoDB;
-ALTER TABLE `inventory` TYPE = InnoDB;
-ALTER TABLE `ipbanlist` TYPE = InnoDB;
-ALTER TABLE `item_db` TYPE = InnoDB;
-ALTER TABLE `item_db2` TYPE = InnoDB;
-ALTER TABLE `login` TYPE = InnoDB;
-#ALTER TABLE `loginlog` TYPE = InnoDB;
-#ALTER TABLE `mail` TYPE = InnoDB;
-ALTER TABLE `mapreg` TYPE = InnoDB;
-ALTER TABLE `memo` TYPE = InnoDB;
-ALTER TABLE `mob_db` TYPE = InnoDB;
-ALTER TABLE `mob_db2` TYPE = InnoDB;
-ALTER TABLE `party` TYPE = InnoDB;
-ALTER TABLE `pet` TYPE = InnoDB;
-ALTER TABLE `ragsrvinfo` TYPE = InnoDB;
-ALTER TABLE `sc_data` TYPE = InnoDB;
-ALTER TABLE `skill` TYPE = InnoDB;
-ALTER TABLE `skill_homunculus` TYPE = InnoDB;
-ALTER TABLE `sstatus` TYPE = InnoDB;
-ALTER TABLE `storage` TYPE = InnoDB;
+ALTER TABLE `auction` ENGINE = InnoDB;
+ALTER TABLE `cart_inventory` ENGINE = InnoDB;
+ALTER TABLE `char` ENGINE = InnoDB;
+ALTER TABLE `charlog` ENGINE = InnoDB;
+ALTER TABLE `friends` ENGINE = InnoDB;
+ALTER TABLE `global_reg_value` ENGINE = InnoDB;
+ALTER TABLE `guild` ENGINE = InnoDB;
+ALTER TABLE `guild_alliance` ENGINE = InnoDB;
+ALTER TABLE `guild_castle` ENGINE = InnoDB;
+ALTER TABLE `guild_expulsion` ENGINE = InnoDB;
+ALTER TABLE `guild_member` ENGINE = InnoDB;
+ALTER TABLE `guild_position` ENGINE = InnoDB;
+ALTER TABLE `guild_skill` ENGINE = InnoDB;
+ALTER TABLE `guild_storage` ENGINE = InnoDB;
+ALTER TABLE `homunculus` ENGINE = InnoDB;
+ALTER TABLE `hotkey` ENGINE = InnoDB;
+ALTER TABLE `interlog` ENGINE = InnoDB;
+ALTER TABLE `inventory` ENGINE = InnoDB;
+ALTER TABLE `ipbanlist` ENGINE = InnoDB;
+#ALTER TABLE `item_db` ENGINE = InnoDB;
+#ALTER TABLE `item_db2` ENGINE = InnoDB;
+ALTER TABLE `login` ENGINE = InnoDB;
+ALTER TABLE `loginlog` ENGINE = InnoDB;
+ALTER TABLE `mail` ENGINE = InnoDB;
+ALTER TABLE `mapreg` ENGINE = InnoDB;
+ALTER TABLE `memo` ENGINE = InnoDB;
+#ALTER TABLE `mob_db` ENGINE = InnoDB;
+#ALTER TABLE `mob_db2` ENGINE = InnoDB;
+ALTER TABLE `party` ENGINE = InnoDB;
+ALTER TABLE `pet` ENGINE = InnoDB;
+ALTER TABLE `ragsrvinfo` ENGINE = InnoDB;
+ALTER TABLE `sc_data` ENGINE = InnoDB;
+ALTER TABLE `skill` ENGINE = InnoDB;
+ALTER TABLE `skill_homunculus` ENGINE = InnoDB;
+ALTER TABLE `sstatus` ENGINE = InnoDB;
+ALTER TABLE `storage` ENGINE = InnoDB;
diff --git a/sql-files/convert_engine_myisam.sql b/sql-files/convert_engine_myisam.sql
index aec1d38dc..35414c083 100644
--- a/sql-files/convert_engine_myisam.sql
+++ b/sql-files/convert_engine_myisam.sql
@@ -2,37 +2,39 @@
-- eAthena Database Converter ( InnoDB -> MyISAM )
--
-ALTER TABLE `cart_inventory` TYPE = MYISAM;
-ALTER TABLE `char` TYPE = MYISAM;
-ALTER TABLE `charlog` TYPE = MYISAM;
-ALTER TABLE `friends` TYPE = MYISAM;
-ALTER TABLE `global_reg_value` TYPE = MYISAM;
-ALTER TABLE `guild` TYPE = MYISAM;
-ALTER TABLE `guild_alliance` TYPE = MYISAM;
-ALTER TABLE `guild_castle` 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;
-ALTER TABLE `homunculus` TYPE = MYISAM;
-ALTER TABLE `interlog` TYPE = MYISAM;
-ALTER TABLE `inventory` TYPE = MYISAM;
-ALTER TABLE `ipbanlist` TYPE = MYISAM;
-ALTER TABLE `item_db` TYPE = MYISAM;
-ALTER TABLE `item_db2` TYPE = MYISAM;
-ALTER TABLE `login` TYPE = MYISAM;
-#ALTER TABLE `loginlog` TYPE = MYISAM;
-#ALTER TABLE `mail` TYPE = MYISAM;
-ALTER TABLE `mapreg` TYPE = MYISAM;
-ALTER TABLE `memo` TYPE = MYISAM;
-ALTER TABLE `mob_db` TYPE = MYISAM;
-ALTER TABLE `mob_db2` TYPE = MYISAM;
-ALTER TABLE `party` TYPE = MYISAM;
-ALTER TABLE `pet` TYPE = MYISAM;
-ALTER TABLE `ragsrvinfo` TYPE = MYISAM;
-ALTER TABLE `sc_data` TYPE = MYISAM;
-ALTER TABLE `skill` TYPE = MYISAM;
-ALTER TABLE `skill_homunculus` TYPE = MYISAM;
-ALTER TABLE `sstatus` TYPE = MYISAM;
-ALTER TABLE `storage` TYPE = MYISAM;
+ALTER TABLE `auction` ENGINE = MyISAM;
+ALTER TABLE `cart_inventory` ENGINE = MyISAM;
+ALTER TABLE `char` ENGINE = MyISAM;
+ALTER TABLE `charlog` ENGINE = MyISAM;
+ALTER TABLE `friends` ENGINE = MyISAM;
+ALTER TABLE `global_reg_value` ENGINE = MyISAM;
+ALTER TABLE `guild` ENGINE = MyISAM;
+ALTER TABLE `guild_alliance` ENGINE = MyISAM;
+ALTER TABLE `guild_castle` ENGINE = MyISAM;
+ALTER TABLE `guild_expulsion` ENGINE = MyISAM;
+ALTER TABLE `guild_member` ENGINE = MyISAM;
+ALTER TABLE `guild_position` ENGINE = MyISAM;
+ALTER TABLE `guild_skill` ENGINE = MyISAM;
+ALTER TABLE `guild_storage` ENGINE = MyISAM;
+ALTER TABLE `homunculus` ENGINE = MyISAM;
+ALTER TABLE `hotkey` ENGINE = MyISAM;
+ALTER TABLE `interlog` ENGINE = MyISAM;
+ALTER TABLE `inventory` ENGINE = MyISAM;
+ALTER TABLE `ipbanlist` ENGINE = MyISAM;
+#ALTER TABLE `item_db` ENGINE = MyISAM;
+#ALTER TABLE `item_db2` ENGINE = MyISAM;
+ALTER TABLE `login` ENGINE = MyISAM;
+ALTER TABLE `loginlog` ENGINE = MyISAM;
+ALTER TABLE `mail` ENGINE = MyISAM;
+ALTER TABLE `mapreg` ENGINE = MyISAM;
+ALTER TABLE `memo` ENGINE = MyISAM;
+#ALTER TABLE `mob_db` ENGINE = MyISAM;
+#ALTER TABLE `mob_db2` ENGINE = MyISAM;
+ALTER TABLE `party` ENGINE = MyISAM;
+ALTER TABLE `pet` ENGINE = MyISAM;
+ALTER TABLE `ragsrvinfo` ENGINE = MyISAM;
+ALTER TABLE `sc_data` ENGINE = MyISAM;
+ALTER TABLE `skill` ENGINE = MyISAM;
+ALTER TABLE `skill_homunculus` ENGINE = MyISAM;
+ALTER TABLE `sstatus` ENGINE = MyISAM;
+ALTER TABLE `storage` ENGINE = MyISAM;
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index d6d3d98d3..e10ee847a 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -27,7 +27,7 @@ CREATE TABLE `item_db` (
`equip_script` text,
`unequip_script` text,
PRIMARY KEY (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
# Items Database
#
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql
index 0216148d0..e4cb333b7 100644
--- a/sql-files/item_db2.sql
+++ b/sql-files/item_db2.sql
@@ -27,7 +27,7 @@ CREATE TABLE `item_db2` (
`equip_script` text,
`unequip_script` text,
PRIMARY KEY (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
# Items Additional Database - Custom Items go here
#
diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index 0217c4fea..3f48685f8 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -19,7 +19,7 @@ CREATE TABLE `picklog` (
`map` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`type`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators
#Database: log
@@ -34,7 +34,7 @@ CREATE TABLE `zenylog` (
`map` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`type`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
#Table: branchlog
@@ -48,7 +48,7 @@ CREATE TABLE `branchlog` (
PRIMARY KEY (`branch_id`),
INDEX (`account_id`),
INDEX (`char_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
#Table: mvplog
@@ -61,7 +61,7 @@ CREATE TABLE `mvplog` (
`mvpexp` mediumint(9) NOT NULL default '0',
`map` varchar(11) NOT NULL default '',
PRIMARY KEY (`mvp_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
#Table: atcommandlog
@@ -76,7 +76,7 @@ CREATE TABLE `atcommandlog` (
PRIMARY KEY (`atcommand_id`),
INDEX (`account_id`),
INDEX (`char_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
#Table: npclog
@@ -91,7 +91,7 @@ CREATE TABLE `npclog` (
PRIMARY KEY (`npc_id`),
INDEX (`account_id`),
INDEX (`char_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat
#Database: log
@@ -111,4 +111,4 @@ CREATE TABLE `chatlog` (
PRIMARY KEY (`id`),
INDEX (`src_accountid`),
INDEX (`src_charid`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 5ea065677..0b8c9b32c 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -45,7 +45,7 @@ CREATE TABLE `cart_inventory` (
`card3` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `char`
@@ -129,7 +129,7 @@ CREATE TABLE `charlog` (
`luk` int(11) unsigned NOT NULL default '0',
`hair` tinyint(4) NOT NULL default '0',
`hair_color` int(11) NOT NULL default '0'
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `friends`
@@ -141,7 +141,7 @@ CREATE TABLE `friends` (
`friend_account` int(11) NOT NULL default '0',
`friend_id` int(11) NOT NULL default '0',
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `hotkey`
@@ -156,7 +156,7 @@ CREATE TABLE `hotkey` (
`skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`,`hotkey`),
INDEX (`char_id`)
-) TYPE=MYISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `global_reg_value`
@@ -172,7 +172,7 @@ CREATE TABLE `global_reg_value` (
PRIMARY KEY (`char_id`,`str`,`account_id`),
KEY `account_id` (`account_id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild`
@@ -199,7 +199,7 @@ CREATE TABLE `guild` (
PRIMARY KEY (`guild_id`,`char_id`),
UNIQUE KEY `guild_id` (`guild_id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_alliance`
@@ -213,7 +213,7 @@ CREATE TABLE `guild_alliance` (
`name` varchar(24) NOT NULL default '',
PRIMARY KEY (`guild_id`,`alliance_id`),
KEY `alliance_id` (`alliance_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_castle`
@@ -249,7 +249,7 @@ CREATE TABLE `guild_castle` (
`gHP7` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`castle_id`),
KEY `guild_id` (`guild_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_expulsion`
@@ -262,7 +262,7 @@ CREATE TABLE `guild_expulsion` (
`name` varchar(24) NOT NULL default '',
`mes` varchar(40) NOT NULL default '',
PRIMARY KEY (`guild_id`,`name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_member`
@@ -285,7 +285,7 @@ CREATE TABLE `guild_member` (
`name` varchar(24) NOT NULL default '',
PRIMARY KEY (`guild_id`,`char_id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_position`
@@ -300,7 +300,7 @@ CREATE TABLE `guild_position` (
`exp_mode` tinyint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guild_id`,`position`),
KEY `guild_id` (`guild_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_skill`
@@ -312,7 +312,7 @@ CREATE TABLE `guild_skill` (
`id` smallint(11) unsigned NOT NULL default '0',
`lv` tinyint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guild_id`,`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `guild_storage`
@@ -334,7 +334,7 @@ CREATE TABLE `guild_storage` (
`card3` smallint(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `guild_id` (`guild_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `homunculus`
@@ -365,7 +365,7 @@ CREATE TABLE `homunculus` (
`rename_flag` tinyint(2) NOT NULL default '0',
`vaporize` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`homun_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `interlog`
@@ -375,7 +375,7 @@ DROP TABLE IF EXISTS `interlog`;
CREATE TABLE `interlog` (
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`log` varchar(255) NOT NULL default ''
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `inventory`
@@ -397,7 +397,7 @@ CREATE TABLE `inventory` (
`card3` smallint(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `ipbanlist`
@@ -410,7 +410,7 @@ CREATE TABLE `ipbanlist` (
`rtime` datetime NOT NULL default '0000-00-00 00:00:00',
`reason` varchar(255) NOT NULL default '',
KEY (`list`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `login`
@@ -452,7 +452,7 @@ CREATE TABLE `mapreg` (
`value` varchar(255) NOT NULL,
KEY `varname` (`varname`),
KEY `index` (`index`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `sc_data`
@@ -470,7 +470,7 @@ CREATE TABLE `sc_data` (
`val4` int(11) NOT NULL default '0',
KEY (`account_id`),
KEY (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `loginlog`
@@ -484,7 +484,7 @@ CREATE TABLE `loginlog` (
`rcode` tinyint(4) NOT NULL default '0',
`log` varchar(255) NOT NULL default '',
INDEX (`ip`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `mail`
@@ -527,7 +527,7 @@ CREATE TABLE `memo` (
`y` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`memo_id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `party`
@@ -542,7 +542,7 @@ CREATE TABLE `party` (
`leader_id` int(11) unsigned NOT NULL default '0',
`leader_char` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`party_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `pet`
@@ -563,7 +563,7 @@ CREATE TABLE `pet` (
`rename_flag` tinyint(4) unsigned NOT NULL default '0',
`incuvate` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`pet_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `ragsrvinfo`
@@ -577,7 +577,7 @@ CREATE TABLE `ragsrvinfo` (
`jexp` int(11) unsigned NOT NULL default '0',
`drop` int(11) unsigned NOT NULL default '0',
`motd` varchar(255) NOT NULL default ''
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `skill`
@@ -590,7 +590,7 @@ CREATE TABLE `skill` (
`lv` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`,`id`),
KEY `char_id` (`char_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `skill_homunculus`
@@ -603,7 +603,7 @@ CREATE TABLE `skill_homunculus` (
`lv` smallint(6) NOT NULL,
PRIMARY KEY (`homun_id`,`id`),
KEY `homun_id` (`homun_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `sstatus`
@@ -614,7 +614,7 @@ CREATE TABLE `sstatus` (
`index` tinyint(4) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`user` int(11) unsigned NOT NULL default '0'
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Table structure for table `storage`
@@ -636,4 +636,4 @@ CREATE TABLE `storage` (
`card3` smallint(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
diff --git a/sql-files/mob_db.sql b/sql-files/mob_db.sql
index 397a684d5..c9cab41d1 100644
--- a/sql-files/mob_db.sql
+++ b/sql-files/mob_db.sql
@@ -63,7 +63,7 @@ CREATE TABLE `mob_db` (
`DropCardid` smallint(9) unsigned NOT NULL default '0',
`DropCardper` smallint(9) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
# Monster Database
#
diff --git a/sql-files/mob_db2.sql b/sql-files/mob_db2.sql
index 76302ff9b..f81a8e7b0 100644
--- a/sql-files/mob_db2.sql
+++ b/sql-files/mob_db2.sql
@@ -63,7 +63,7 @@ CREATE TABLE `mob_db2` (
`DropCardid` smallint(9) unsigned NOT NULL default '0',
`DropCardper` smallint(9) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
# Monsters Additional Database
#
diff --git a/sql-files/upgrade_svn11018.sql b/sql-files/upgrade_svn11018.sql
index 176d7e12d..8c2a4c2d9 100644
--- a/sql-files/upgrade_svn11018.sql
+++ b/sql-files/upgrade_svn11018.sql
@@ -7,4 +7,4 @@ CREATE TABLE `hotkey` (
`skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`,`hotkey`),
INDEX (`char_id`)
-) TYPE=MYISAM;
+) ENGINE=MYISAM;