From 43cd16d6223038e798e151df8038c81d18414353 Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Fri, 4 Apr 2008 21:04:47 +0000
Subject: Replaced the TYPE keyword with ENGINE in all sql files, because this
 is the preferred alternative.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/convert_engine_innodb.sql | 70 +++++++++++++++++++------------------
 sql-files/convert_engine_myisam.sql | 70 +++++++++++++++++++------------------
 sql-files/item_db.sql               |  2 +-
 sql-files/item_db2.sql              |  2 +-
 sql-files/logs.sql                  | 14 ++++----
 sql-files/main.sql                  | 56 ++++++++++++++---------------
 sql-files/mob_db.sql                |  2 +-
 sql-files/mob_db2.sql               |  2 +-
 sql-files/upgrade_svn11018.sql      |  2 +-
 9 files changed, 112 insertions(+), 108 deletions(-)

(limited to 'sql-files')

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;
-- 
cgit v1.2.3-70-g09d2