From a14968850fb2474b29552db21d63d0bb303e73d1 Mon Sep 17 00:00:00 2001
From: Asheraf <acheraf1998@gmail.com>
Date: Sat, 16 Nov 2019 19:03:26 +0100
Subject: Fix some sql warnings with mysql servers v8

---
 sql-files/main.sql | 974 ++++++++++++++++++++++++++---------------------------
 1 file changed, 487 insertions(+), 487 deletions(-)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index c4e5afaf3..1196d36cb 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -22,11 +22,11 @@
 --
 
 CREATE TABLE IF NOT EXISTS `account_data` (
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `bank_vault` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `base_exp` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
-  `base_drop` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
-  `base_death` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `bank_vault` INT UNSIGNED NOT NULL DEFAULT '0',
+  `base_exp` SMALLINT UNSIGNED NOT NULL DEFAULT '100',
+  `base_drop` SMALLINT UNSIGNED NOT NULL DEFAULT '100',
+  `base_death` SMALLINT UNSIGNED NOT NULL DEFAULT '100',
   PRIMARY KEY (`account_id`)
 ) ENGINE=MyISAM;
 
@@ -35,10 +35,10 @@ CREATE TABLE IF NOT EXISTS `account_data` (
 --
 
 CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `value` INT(11) NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
+  `value` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`account_id`,`key`,`index`),
   KEY `account_id` (`account_id`)
 ) ENGINE=MyISAM;
@@ -48,9 +48,9 @@ CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
 --
 
 CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
   `value` VARCHAR(254) NOT NULL DEFAULT '0',
   PRIMARY KEY (`account_id`,`key`,`index`),
   KEY `account_id` (`account_id`)
@@ -61,35 +61,35 @@ CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
 --
 
 CREATE TABLE IF NOT EXISTS `auction` (
-  `auction_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `seller_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `auction_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `seller_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `seller_name` VARCHAR(30) NOT NULL DEFAULT '',
-  `buyer_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `buyer_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `buyer_name` VARCHAR(30) NOT NULL DEFAULT '',
-  `price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `buynow` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `hours` SMALLINT(6) NOT NULL DEFAULT '0',
-  `timestamp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `price` INT UNSIGNED NOT NULL DEFAULT '0',
+  `buynow` INT UNSIGNED NOT NULL DEFAULT '0',
+  `hours` SMALLINT NOT NULL DEFAULT '0',
+  `timestamp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nameid` INT UNSIGNED NOT NULL DEFAULT '0',
   `item_name` VARCHAR(50) NOT NULL DEFAULT '',
-  `type` SMALLINT(6) NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `type` SMALLINT NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`auction_id`)
 ) ENGINE=MyISAM;
 
@@ -98,10 +98,10 @@ CREATE TABLE IF NOT EXISTS `auction` (
 --
 
 CREATE TABLE IF NOT EXISTS `autotrade_data` (
-  `char_id` INT(11) NOT NULL DEFAULT '0',
-  `itemkey` INT(11) NOT NULL DEFAULT '0',
-  `amount` INT(11) NOT NULL DEFAULT '0',
-  `price` INT(11) NOT NULL DEFAULT '0',
+  `char_id` INT NOT NULL DEFAULT '0',
+  `itemkey` INT NOT NULL DEFAULT '0',
+  `amount` INT NOT NULL DEFAULT '0',
+  `price` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`,`itemkey`)
 ) ENGINE=MyISAM;
 
@@ -110,9 +110,9 @@ CREATE TABLE IF NOT EXISTS `autotrade_data` (
 --
 
 CREATE TABLE IF NOT EXISTS `autotrade_merchants` (
-  `account_id` INT(11) NOT NULL DEFAULT '0',
-  `char_id` INT(11) NOT NULL DEFAULT '0',
-  `sex` TINYINT(2) NOT NULL DEFAULT '0',
+  `account_id` INT NOT NULL DEFAULT '0',
+  `char_id` INT NOT NULL DEFAULT '0',
+  `sex` TINYINT NOT NULL DEFAULT '0',
   `title` VARCHAR(80) NOT NULL DEFAULT 'Buy From Me!',
   PRIMARY KEY (`account_id`,`char_id`)
 ) ENGINE=MyISAM;
@@ -122,20 +122,20 @@ CREATE TABLE IF NOT EXISTS `autotrade_merchants` (
 --
 
 CREATE TABLE IF NOT EXISTS `char_achievements` (
-	`char_id` INT(11) UNSIGNED NOT NULL,
-	`ach_id` INT(11) UNSIGNED NOT NULL,
-	`completed_at` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`rewarded_at` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-	`obj_9` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+	`char_id` INT UNSIGNED NOT NULL,
+	`ach_id` INT UNSIGNED NOT NULL,
+	`completed_at` INT UNSIGNED NOT NULL DEFAULT '0',
+	`rewarded_at` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_0` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_1` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_2` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_3` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_4` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_5` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_6` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_7` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_8` INT UNSIGNED NOT NULL DEFAULT '0',
+	`obj_9` INT UNSIGNED NOT NULL DEFAULT '0',
 	PRIMARY KEY (`char_id`, `ach_id`)
 ) ENGINE=MyISAM;
 
@@ -144,31 +144,31 @@ CREATE TABLE IF NOT EXISTS `char_achievements` (
 --
 
 CREATE TABLE IF NOT EXISTS `cart_inventory` (
-  `id` INT(11) NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) NOT NULL DEFAULT '0',
-  `nameid` INT(11) NOT NULL DEFAULT '0',
-  `amount` INT(11) NOT NULL DEFAULT '0',
-  `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `identify` SMALLINT(6) NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `id` INT NOT NULL AUTO_INCREMENT,
+  `char_id` INT NOT NULL DEFAULT '0',
+  `nameid` INT NOT NULL DEFAULT '0',
+  `amount` INT NOT NULL DEFAULT '0',
+  `equip` INT UNSIGNED NOT NULL DEFAULT '0',
+  `identify` SMALLINT NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `expire_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `bound` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
@@ -178,74 +178,74 @@ CREATE TABLE IF NOT EXISTS `cart_inventory` (
 --
 
 CREATE TABLE IF NOT EXISTS `char` (
-  `char_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `char_num` TINYINT(1) NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `char_num` TINYINT NOT NULL DEFAULT '0',
   `name` VARCHAR(30) NOT NULL DEFAULT '',
-  `class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `base_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
-  `job_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
-  `base_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-  `job_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-  `zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `int` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `max_hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `max_sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `status_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `skill_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `option` INT(11) NOT NULL DEFAULT '0',
-  `karma` TINYINT(3) NOT NULL DEFAULT '0',
-  `manner` SMALLINT(6) NOT NULL DEFAULT '0',
-  `party_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `clan_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `pet_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `homun_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `elemental_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `hair` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `hair_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `clothes_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `shield` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `head_top` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `head_mid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `head_bottom` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `last_login` BIGINT(20) NULL DEFAULT '0',
+  `class` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `base_level` SMALLINT UNSIGNED NOT NULL DEFAULT '1',
+  `job_level` SMALLINT UNSIGNED NOT NULL DEFAULT '1',
+  `base_exp` BIGINT UNSIGNED NOT NULL DEFAULT '0',
+  `job_exp` BIGINT UNSIGNED NOT NULL DEFAULT '0',
+  `zeny` INT UNSIGNED NOT NULL DEFAULT '0',
+  `str` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `agi` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `vit` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `int` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `dex` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `luk` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `max_hp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `hp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `max_sp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `sp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `status_point` INT UNSIGNED NOT NULL DEFAULT '0',
+  `skill_point` INT UNSIGNED NOT NULL DEFAULT '0',
+  `option` INT NOT NULL DEFAULT '0',
+  `karma` TINYINT NOT NULL DEFAULT '0',
+  `manner` SMALLINT NOT NULL DEFAULT '0',
+  `party_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `clan_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `pet_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `homun_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `elemental_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `hair` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `hair_color` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `clothes_color` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `body` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `weapon` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `shield` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `head_top` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `head_mid` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `head_bottom` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `robe` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `last_login` BIGINT NULL DEFAULT '0',
   `last_map` VARCHAR(11) NOT NULL DEFAULT '',
-  `last_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53',
-  `last_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111',
+  `last_x` SMALLINT UNSIGNED NOT NULL DEFAULT '53',
+  `last_y` SMALLINT UNSIGNED NOT NULL DEFAULT '111',
   `save_map` VARCHAR(11) NOT NULL DEFAULT '',
-  `save_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53',
-  `save_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111',
-  `partner_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `online` TINYINT(2) NOT NULL DEFAULT '0',
-  `father` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `mother` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `child` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `fame` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `rename` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `slotchange` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `char_opt` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `font` TINYINT(3) UNSIGNED NOT NULL DEFAULT  '0',
-  `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `save_x` SMALLINT UNSIGNED NOT NULL DEFAULT '53',
+  `save_y` SMALLINT UNSIGNED NOT NULL DEFAULT '111',
+  `partner_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `online` TINYINT NOT NULL DEFAULT '0',
+  `father` INT UNSIGNED NOT NULL DEFAULT '0',
+  `mother` INT UNSIGNED NOT NULL DEFAULT '0',
+  `child` INT UNSIGNED NOT NULL DEFAULT '0',
+  `fame` INT UNSIGNED NOT NULL DEFAULT '0',
+  `rename` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `delete_date` INT UNSIGNED NOT NULL DEFAULT '0',
+  `slotchange` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `char_opt` INT UNSIGNED NOT NULL DEFAULT '0',
+  `font` TINYINT UNSIGNED NOT NULL DEFAULT  '0',
+  `unban_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `uniqueitem_counter` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   `sex` ENUM('M','F','U') NOT NULL DEFAULT 'U',
-  `hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `hotkey_rowshift2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attendance_count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attendance_timer` BIGINT(20) NULL DEFAULT '0',
-  `title_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `inventory_size` INT(11) UNSIGNED NOT NULL DEFAULT '100',
+  `hotkey_rowshift` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `hotkey_rowshift2` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attendance_count` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attendance_timer` BIGINT NULL DEFAULT '0',
+  `title_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `inventory_size` INT UNSIGNED NOT NULL DEFAULT '100',
   PRIMARY KEY (`char_id`),
   UNIQUE KEY `name_key` (`name`),
   KEY `account_id` (`account_id`),
@@ -259,10 +259,10 @@ CREATE TABLE IF NOT EXISTS `char` (
 --
 
 CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `value` INT(11) NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
+  `value` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`,`key`,`index`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
@@ -272,9 +272,9 @@ CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
 --
 
 CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
   `value` VARCHAR(254) NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`,`key`,`index`),
   KEY `char_id` (`char_id`)
@@ -287,19 +287,19 @@ CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
 CREATE TABLE IF NOT EXISTS `charlog` (
   `time` DATETIME NULL,
   `char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select',
-  `account_id` INT(11) NOT NULL DEFAULT '0',
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `char_num` TINYINT(4) NOT NULL DEFAULT '0',
-  `class` MEDIUMINT(9) NOT NULL DEFAULT '0',
+  `account_id` INT NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `char_num` TINYINT NOT NULL DEFAULT '0',
+  `class` MEDIUMINT NOT NULL DEFAULT '0',
   `name` VARCHAR(23) NOT NULL DEFAULT '',
-  `str` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `agi` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `vit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `int` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `dex` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `luk` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `hair` TINYINT(4) NOT NULL DEFAULT '0',
-  `hair_color` INT(11) NOT NULL DEFAULT '0'
+  `str` INT UNSIGNED NOT NULL DEFAULT '0',
+  `agi` INT UNSIGNED NOT NULL DEFAULT '0',
+  `vit` INT UNSIGNED NOT NULL DEFAULT '0',
+  `int` INT UNSIGNED NOT NULL DEFAULT '0',
+  `dex` INT UNSIGNED NOT NULL DEFAULT '0',
+  `luk` INT UNSIGNED NOT NULL DEFAULT '0',
+  `hair` TINYINT NOT NULL DEFAULT '0',
+  `hair_color` INT NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM;
 
 --
@@ -307,23 +307,23 @@ CREATE TABLE IF NOT EXISTS `charlog` (
 --
 
 CREATE TABLE IF NOT EXISTS `elemental` (
-  `ele_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) NOT NULL,
-  `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `mode` INT(11) UNSIGNED NOT NULL DEFAULT '1',
-  `hp` INT(12) NOT NULL DEFAULT '1',
-  `sp` INT(12) NOT NULL DEFAULT '1',
-  `max_hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `life_time` INT(11) NOT NULL DEFAULT '0',
+  `ele_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `char_id` INT NOT NULL,
+  `class` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `mode` INT UNSIGNED NOT NULL DEFAULT '1',
+  `hp` INT NOT NULL DEFAULT '1',
+  `sp` INT NOT NULL DEFAULT '1',
+  `max_hp` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `max_sp` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `atk1` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `atk2` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `matk` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `aspd` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `def` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `mdef` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `flee` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `hit` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `life_time` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`ele_id`)
 ) ENGINE=MyISAM;
 
@@ -332,9 +332,9 @@ CREATE TABLE IF NOT EXISTS `elemental` (
 --
 
 CREATE TABLE IF NOT EXISTS `friends` (
-  `char_id` INT(11) NOT NULL DEFAULT '0',
-  `friend_account` INT(11) NOT NULL DEFAULT '0',
-  `friend_id` INT(11) NOT NULL DEFAULT '0',
+  `char_id` INT NOT NULL DEFAULT '0',
+  `friend_account` INT NOT NULL DEFAULT '0',
+  `friend_id` INT NOT NULL DEFAULT '0',
   KEY  `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -343,11 +343,11 @@ CREATE TABLE IF NOT EXISTS `friends` (
 --
 
 CREATE TABLE IF NOT EXISTS `hotkey` (
-  `char_id` INT(11) NOT NULL,
-  `hotkey` TINYINT(2) UNSIGNED NOT NULL,
-  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-  `itemskill_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `skill_lvl` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT NOT NULL,
+  `hotkey` TINYINT UNSIGNED NOT NULL,
+  `type` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `itemskill_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `skill_lvl` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`,`hotkey`)
 ) ENGINE=MyISAM;
 
@@ -356,10 +356,10 @@ CREATE TABLE IF NOT EXISTS `hotkey` (
 --
 
 CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `value` INT(11) NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
+  `value` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`account_id`,`key`,`index`),
   KEY `account_id` (`account_id`)
 ) ENGINE=MyISAM;
@@ -369,9 +369,9 @@ CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
 --
 
 CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
   `value` VARCHAR(254) NOT NULL DEFAULT '0',
   PRIMARY KEY (`account_id`,`key`,`index`),
   KEY `account_id` (`account_id`)
@@ -382,21 +382,21 @@ CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild` (
-  `guild_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `guild_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `master` VARCHAR(24) NOT NULL DEFAULT '',
-  `guild_lv` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `connect_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `max_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `average_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
-  `exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-  `next_exp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `skill_point` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_lv` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `connect_member` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `max_member` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `average_lv` SMALLINT UNSIGNED NOT NULL DEFAULT '1',
+  `exp` BIGINT UNSIGNED NOT NULL DEFAULT '0',
+  `next_exp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `skill_point` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   `mes1` VARCHAR(60) NOT NULL DEFAULT '',
   `mes2` VARCHAR(120) NOT NULL DEFAULT '',
-  `emblem_len` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `emblem_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `emblem_len` INT UNSIGNED NOT NULL DEFAULT '0',
+  `emblem_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `emblem_data` blob,
   PRIMARY KEY (`guild_id`,`char_id`),
   UNIQUE KEY `guild_id` (`guild_id`),
@@ -408,9 +408,9 @@ CREATE TABLE IF NOT EXISTS `guild` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_alliance` (
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `opposition` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `alliance_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `opposition` INT UNSIGNED NOT NULL DEFAULT '0',
+  `alliance_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
   PRIMARY KEY (`guild_id`,`alliance_id`),
   KEY `alliance_id` (`alliance_id`)
@@ -421,24 +421,24 @@ CREATE TABLE IF NOT EXISTS `guild_alliance` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_castle` (
-  `castle_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `economy` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `defense` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `triggerE` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `triggerD` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nextTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `payTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `createTime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleC` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG0` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `visibleG7` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `castle_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `economy` INT UNSIGNED NOT NULL DEFAULT '0',
+  `defense` INT UNSIGNED NOT NULL DEFAULT '0',
+  `triggerE` INT UNSIGNED NOT NULL DEFAULT '0',
+  `triggerD` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nextTime` INT UNSIGNED NOT NULL DEFAULT '0',
+  `payTime` INT UNSIGNED NOT NULL DEFAULT '0',
+  `createTime` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleC` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG0` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG1` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG2` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG3` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG4` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG5` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG6` INT UNSIGNED NOT NULL DEFAULT '0',
+  `visibleG7` INT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`castle_id`),
   KEY `guild_id` (`guild_id`)
 ) ENGINE=MyISAM;
@@ -448,9 +448,9 @@ CREATE TABLE IF NOT EXISTS `guild_castle` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_expulsion` (
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
   `mes` VARCHAR(40) NOT NULL DEFAULT '',
   PRIMARY KEY (`guild_id`,`name`)
@@ -461,18 +461,18 @@ CREATE TABLE IF NOT EXISTS `guild_expulsion` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_member` (
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `hair` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `hair_color` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `gender` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-  `exp_payper` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `online` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `hair` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `hair_color` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `gender` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `class` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `lv` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `exp` BIGINT UNSIGNED NOT NULL DEFAULT '0',
+  `exp_payper` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `online` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `position` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
   PRIMARY KEY (`guild_id`,`char_id`),
   KEY `char_id` (`char_id`)
@@ -483,11 +483,11 @@ CREATE TABLE IF NOT EXISTS `guild_member` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_position` (
-  `guild_id` INT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `position` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `exp_mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `mode` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `exp_mode` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`guild_id`,`position`)
 ) ENGINE=MyISAM;
 
@@ -496,9 +496,9 @@ CREATE TABLE IF NOT EXISTS `guild_position` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_skill` (
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `lv` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `id` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `lv` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`guild_id`,`id`)
 ) ENGINE=MyISAM;
 
@@ -507,31 +507,31 @@ CREATE TABLE IF NOT EXISTS `guild_skill` (
 --
 
 CREATE TABLE IF NOT EXISTS `guild_storage` (
-  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `guild_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nameid` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` INT UNSIGNED NOT NULL DEFAULT '0',
+  `equip` INT UNSIGNED NOT NULL DEFAULT '0',
+  `identify` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `expire_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `bound` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `guild_id` (`guild_id`)
 ) ENGINE=MyISAM;
@@ -541,30 +541,30 @@ CREATE TABLE IF NOT EXISTS `guild_storage` (
 --
 
 CREATE TABLE IF NOT EXISTS `homunculus` (
-  `homun_id` INT(11) NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) NOT NULL,
-  `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `prev_class` MEDIUMINT(9) NOT NULL DEFAULT '0',
+  `homun_id` INT NOT NULL AUTO_INCREMENT,
+  `char_id` INT NOT NULL,
+  `class` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `prev_class` MEDIUMINT NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `level` SMALLINT(4) NOT NULL DEFAULT '0',
-  `exp` INT(12) NOT NULL DEFAULT '0',
-  `intimacy` INT(12) NOT NULL DEFAULT '0',
-  `hunger` SMALLINT(4) NOT NULL DEFAULT '0',
-  `str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `INT` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `hp` INT(12) NOT NULL DEFAULT '1',
-  `max_hp` INT(12) NOT NULL DEFAULT '1',
-  `sp` INT(12) NOT NULL DEFAULT '1',
-  `max_sp` INT(12) NOT NULL DEFAULT '1',
-  `skill_point` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `alive` TINYINT(2) NOT NULL DEFAULT '1',
-  `rename_flag` TINYINT(2) NOT NULL DEFAULT '0',
-  `vaporize` TINYINT(2) NOT NULL DEFAULT '0',
-  `autofeed` TINYINT(2) NOT NULL DEFAULT '0',
+  `level` SMALLINT NOT NULL DEFAULT '0',
+  `exp` INT NOT NULL DEFAULT '0',
+  `intimacy` INT NOT NULL DEFAULT '0',
+  `hunger` SMALLINT NOT NULL DEFAULT '0',
+  `str` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `agi` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `vit` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `INT` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `dex` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `luk` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `hp` INT NOT NULL DEFAULT '1',
+  `max_hp` INT NOT NULL DEFAULT '1',
+  `sp` INT NOT NULL DEFAULT '1',
+  `max_sp` INT NOT NULL DEFAULT '1',
+  `skill_point` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `alive` TINYINT NOT NULL DEFAULT '1',
+  `rename_flag` TINYINT NOT NULL DEFAULT '0',
+  `vaporize` TINYINT NOT NULL DEFAULT '0',
+  `autofeed` TINYINT NOT NULL DEFAULT '0',
   PRIMARY KEY (`homun_id`)
 ) ENGINE=MyISAM;
 
@@ -582,32 +582,32 @@ CREATE TABLE IF NOT EXISTS `interlog` (
 --
 
 CREATE TABLE IF NOT EXISTS `inventory` (
-  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `identify` SMALLINT(6) NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nameid` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` INT UNSIGNED NOT NULL DEFAULT '0',
+  `equip` INT UNSIGNED NOT NULL DEFAULT '0',
+  `identify` SMALLINT NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `expire_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `favorite` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `bound` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
@@ -622,29 +622,29 @@ CREATE TABLE IF NOT EXISTS `ipbanlist` (
   `rtime` DATETIME NULL,
   `reason` VARCHAR(255) NOT NULL DEFAULT '',
   KEY (`list`)
-) ENGINE=MyISAM;
+) ENGINE=InnoDB;
 
 --
 -- Table structure for table `login`
 --
 
 CREATE TABLE IF NOT EXISTS `login` (
-  `account_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `account_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `userid` VARCHAR(23) NOT NULL DEFAULT '',
   `user_pass` VARCHAR(32) NOT NULL DEFAULT '',
   `sex` ENUM('M','F','S') NOT NULL DEFAULT 'M',
   `email` VARCHAR(39) NOT NULL DEFAULT '',
-  `group_id` TINYINT(3) NOT NULL DEFAULT '0',
-  `state` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `expiration_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `logincount` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `group_id` TINYINT NOT NULL DEFAULT '0',
+  `state` INT UNSIGNED NOT NULL DEFAULT '0',
+  `unban_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `expiration_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `logincount` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
   `lastlogin` DATETIME NULL,
   `last_ip` VARCHAR(100) NOT NULL DEFAULT '',
   `birthdate` DATE NULL,
-  `character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `character_slots` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   `pincode` VARCHAR(4) NOT NULL DEFAULT '',
-  `pincode_change` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `pincode_change` INT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`account_id`),
   KEY `name` (`userid`)
 ) ENGINE=MyISAM AUTO_INCREMENT=2000000;
@@ -660,7 +660,7 @@ INSERT IGNORE INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`)
 
 CREATE TABLE IF NOT EXISTS `mapreg` (
   `varname` VARCHAR(32) BINARY NOT NULL,
-  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `index` INT UNSIGNED NOT NULL DEFAULT '0',
   `value` VARCHAR(255) NOT NULL,
   PRIMARY KEY (`varname`,`index`)
 ) ENGINE=MyISAM;
@@ -671,8 +671,8 @@ CREATE TABLE IF NOT EXISTS `mapreg` (
 
 CREATE TABLE IF NOT EXISTS `npc_market_data` (
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `itemid` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` INT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`name`,`itemid`)
 ) ENGINE=MyISAM;
 
@@ -681,15 +681,15 @@ CREATE TABLE IF NOT EXISTS `npc_market_data` (
 --
 
 CREATE TABLE IF NOT EXISTS `sc_data` (
-  `account_id` INT(11) UNSIGNED NOT NULL,
-  `char_id` INT(11) UNSIGNED NOT NULL,
-  `type` SMALLINT(11) UNSIGNED NOT NULL,
-  `tick` INT(11) NOT NULL,
-  `total_tick` INT(11) NOT NULL,
-  `val1` INT(11) NOT NULL DEFAULT '0',
-  `val2` INT(11) NOT NULL DEFAULT '0',
-  `val3` INT(11) NOT NULL DEFAULT '0',
-  `val4` INT(11) NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL,
+  `char_id` INT UNSIGNED NOT NULL,
+  `type` SMALLINT UNSIGNED NOT NULL,
+  `tick` INT NOT NULL,
+  `total_tick` INT NOT NULL,
+  `val1` INT NOT NULL DEFAULT '0',
+  `val2` INT NOT NULL DEFAULT '0',
+  `val3` INT NOT NULL DEFAULT '0',
+  `val4` INT NOT NULL DEFAULT '0',
   KEY (`account_id`),
   KEY (`char_id`),
   PRIMARY KEY (`account_id`,`char_id`,`type`)
@@ -700,36 +700,36 @@ CREATE TABLE IF NOT EXISTS `sc_data` (
 --
 
 CREATE TABLE IF NOT EXISTS `mail` (
-  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
   `send_name` VARCHAR(30) NOT NULL DEFAULT '',
-  `send_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `send_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `dest_name` VARCHAR(30) NOT NULL DEFAULT '',
-  `dest_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `dest_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `title` VARCHAR(45) NOT NULL DEFAULT '',
   `message` VARCHAR(255) NOT NULL DEFAULT '',
-  `time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `status` TINYINT(2) NOT NULL DEFAULT '0',
-  `zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `identify` SMALLINT(6) NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `status` TINYINT NOT NULL DEFAULT '0',
+  `zeny` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nameid` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` INT UNSIGNED NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `identify` SMALLINT NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM;
 
@@ -738,11 +738,11 @@ CREATE TABLE IF NOT EXISTS `mail` (
 --
 
 CREATE TABLE IF NOT EXISTS `memo` (
-  `memo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `memo_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
   `map` VARCHAR(11) NOT NULL DEFAULT '',
-  `x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `x` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `y` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`memo_id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
@@ -752,13 +752,13 @@ CREATE TABLE IF NOT EXISTS `memo` (
 --
 
 CREATE TABLE IF NOT EXISTS `mercenary` (
-  `mer_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `char_id` INT(11) NOT NULL,
-  `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `hp` INT(12) NOT NULL DEFAULT '1',
-  `sp` INT(12) NOT NULL DEFAULT '1',
-  `kill_counter` INT(11) NOT NULL,
-  `life_time` INT(11) NOT NULL DEFAULT '0',
+  `mer_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `char_id` INT NOT NULL,
+  `class` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `hp` INT NOT NULL DEFAULT '1',
+  `sp` INT NOT NULL DEFAULT '1',
+  `kill_counter` INT NOT NULL,
+  `life_time` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`mer_id`)
 ) ENGINE=MyISAM;
 
@@ -767,14 +767,14 @@ CREATE TABLE IF NOT EXISTS `mercenary` (
 --
 
 CREATE TABLE IF NOT EXISTS `mercenary_owner` (
-  `char_id` INT(11) NOT NULL,
-  `merc_id` INT(11) NOT NULL DEFAULT '0',
-  `arch_calls` INT(11) NOT NULL DEFAULT '0',
-  `arch_faith` INT(11) NOT NULL DEFAULT '0',
-  `spear_calls` INT(11) NOT NULL DEFAULT '0',
-  `spear_faith` INT(11) NOT NULL DEFAULT '0',
-  `sword_calls` INT(11) NOT NULL DEFAULT '0',
-  `sword_faith` INT(11) NOT NULL DEFAULT '0',
+  `char_id` INT NOT NULL,
+  `merc_id` INT NOT NULL DEFAULT '0',
+  `arch_calls` INT NOT NULL DEFAULT '0',
+  `arch_faith` INT NOT NULL DEFAULT '0',
+  `spear_calls` INT NOT NULL DEFAULT '0',
+  `spear_faith` INT NOT NULL DEFAULT '0',
+  `sword_calls` INT NOT NULL DEFAULT '0',
+  `sword_faith` INT NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -783,12 +783,12 @@ CREATE TABLE IF NOT EXISTS `mercenary_owner` (
 --
 
 CREATE TABLE IF NOT EXISTS `party` (
-  `party_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `party_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `exp` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `item` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `leader_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `leader_char` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `exp` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `item` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `leader_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `leader_char` INT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`party_id`)
 ) ENGINE=MyISAM;
 
@@ -797,19 +797,19 @@ CREATE TABLE IF NOT EXISTS `party` (
 --
 
 CREATE TABLE IF NOT EXISTS `pet` (
-  `pet_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `pet_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `class` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `level` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `egg_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `equip` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `intimate` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `hungry` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
-  `rename_flag` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `incubate` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `autofeed` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `level` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `egg_id` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `equip` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `intimate` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `hungry` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `rename_flag` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `incubate` INT UNSIGNED NOT NULL DEFAULT '0',
+  `autofeed` TINYINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`pet_id`)
 ) ENGINE=MyISAM;
 
@@ -818,13 +818,13 @@ CREATE TABLE IF NOT EXISTS `pet` (
 --
 
 CREATE TABLE IF NOT EXISTS `quest` (
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `quest_id` INT(10) UNSIGNED NOT NULL,
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `quest_id` INT UNSIGNED NOT NULL,
   `state` ENUM('0','1','2') NOT NULL DEFAULT '0',
-  `time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `count1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `count2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `count3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  `time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `count1` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `count2` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
+  `count3` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`,`quest_id`)
 ) ENGINE=MyISAM;
 
@@ -833,11 +833,11 @@ CREATE TABLE IF NOT EXISTS `quest` (
 --
 
 CREATE TABLE IF NOT EXISTS `ragsrvinfo` (
-  `index` INT(11) NOT NULL DEFAULT '0',
+  `index` INT NOT NULL DEFAULT '0',
   `name` VARCHAR(255) NOT NULL DEFAULT '',
-  `exp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `jexp` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `drop` INT(11) UNSIGNED NOT NULL DEFAULT '0'
+  `exp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `jexp` INT UNSIGNED NOT NULL DEFAULT '0',
+  `drop` INT UNSIGNED NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM;
 
 --
@@ -845,10 +845,10 @@ CREATE TABLE IF NOT EXISTS `ragsrvinfo` (
 --
 
 CREATE TABLE IF NOT EXISTS `skill` (
-  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `lv` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
+  `char_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `id` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `lv` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `flag` TINYINT UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY (`char_id`,`id`)
 ) ENGINE=MyISAM;
 
@@ -857,9 +857,9 @@ CREATE TABLE IF NOT EXISTS `skill` (
 --
 
 CREATE TABLE IF NOT EXISTS `skill_homunculus` (
-  `homun_id` INT(11) NOT NULL,
-  `id` INT(11) NOT NULL,
-  `lv` SMALLINT(6) NOT NULL,
+  `homun_id` INT NOT NULL,
+  `id` INT NOT NULL,
+  `lv` SMALLINT NOT NULL,
   PRIMARY KEY (`homun_id`,`id`)
 ) ENGINE=MyISAM;
 
@@ -868,7 +868,7 @@ CREATE TABLE IF NOT EXISTS `skill_homunculus` (
 --
 
 CREATE TABLE IF NOT EXISTS `sql_updates` (
-  `timestamp` INT(11) UNSIGNED NOT NULL,
+  `timestamp` INT UNSIGNED NOT NULL,
   `ignored` ENUM('Yes','No') NOT NULL DEFAULT 'No',
   PRIMARY KEY (`timestamp`)
 ) ENGINE=MyISAM;
@@ -940,81 +940,81 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1570870260); -- 2019-10-2
 --
 
 CREATE TABLE IF NOT EXISTS `storage` (
-  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `card0` INT(11) NOT NULL DEFAULT '0',
-  `card1` INT(11) NOT NULL DEFAULT '0',
-  `card2` INT(11) NOT NULL DEFAULT '0',
-  `card3` INT(11) NOT NULL DEFAULT '0',
-  `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-  `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-  `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-  `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
+  `account_id` INT UNSIGNED NOT NULL DEFAULT '0',
+  `nameid` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `equip` INT UNSIGNED NOT NULL DEFAULT '0',
+  `identify` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `attribute` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `card0` INT NOT NULL DEFAULT '0',
+  `card1` INT NOT NULL DEFAULT '0',
+  `card2` INT NOT NULL DEFAULT '0',
+  `card3` INT NOT NULL DEFAULT '0',
+  `opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val0` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val1` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val2` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val3` SMALLINT NOT NULL DEFAULT '0',
+  `opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+  `opt_val4` SMALLINT NOT NULL DEFAULT '0',
+  `expire_time` INT UNSIGNED NOT NULL DEFAULT '0',
+  `bound` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+  `unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `account_id` (`account_id`)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `rodex_items` (
-	`id` INT(11) NOT NULL AUTO_INCREMENT,
-	`mail_id` BIGINT(20) NOT NULL DEFAULT '0',
-	`nameid` INT(11) NOT NULL DEFAULT '0',
-	`amount` INT(11) NOT NULL DEFAULT '0',
-	`equip` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-	`identify` SMALLINT(6) NOT NULL DEFAULT '0',
-	`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-	`attribute` TINYINT(4) NOT NULL DEFAULT '0',
-	`card0` INT(11) NOT NULL DEFAULT '0',
-	`card1` INT(11) NOT NULL DEFAULT '0',
-	`card2` INT(11) NOT NULL DEFAULT '0',
-	`card3` INT(11) NOT NULL DEFAULT '0',
-	`opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-	`opt_val0` SMALLINT(5) NOT NULL DEFAULT '0',
-	`opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-	`opt_val1` SMALLINT(5) NOT NULL DEFAULT '0',
-	`opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-	`opt_val2` SMALLINT(5) NOT NULL DEFAULT '0',
-	`opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-	`opt_val3` SMALLINT(5) NOT NULL DEFAULT '0',
-	`opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
-	`opt_val4` SMALLINT(5) NOT NULL DEFAULT '0',
-	`expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-	`bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
-	`unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+	`id` INT NOT NULL AUTO_INCREMENT,
+	`mail_id` BIGINT NOT NULL DEFAULT '0',
+	`nameid` INT NOT NULL DEFAULT '0',
+	`amount` INT NOT NULL DEFAULT '0',
+	`equip` INT UNSIGNED NOT NULL DEFAULT '0',
+	`identify` SMALLINT NOT NULL DEFAULT '0',
+	`refine` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+	`attribute` TINYINT NOT NULL DEFAULT '0',
+	`card0` INT NOT NULL DEFAULT '0',
+	`card1` INT NOT NULL DEFAULT '0',
+	`card2` INT NOT NULL DEFAULT '0',
+	`card3` INT NOT NULL DEFAULT '0',
+	`opt_idx0` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+	`opt_val0` SMALLINT NOT NULL DEFAULT '0',
+	`opt_idx1` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+	`opt_val1` SMALLINT NOT NULL DEFAULT '0',
+	`opt_idx2` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+	`opt_val2` SMALLINT NOT NULL DEFAULT '0',
+	`opt_idx3` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+	`opt_val3` SMALLINT NOT NULL DEFAULT '0',
+	`opt_idx4` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
+	`opt_val4` SMALLINT NOT NULL DEFAULT '0',
+	`expire_time` INT UNSIGNED NOT NULL DEFAULT '0',
+	`bound` TINYINT UNSIGNED NOT NULL DEFAULT '0',
+	`unique_id` BIGINT UNSIGNED NOT NULL DEFAULT '0',
 	PRIMARY KEY (`id`),
   KEY `mail_id` (`mail_id`)
 ) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS `rodex_mail` (
-	`mail_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+	`mail_id` BIGINT NOT NULL AUTO_INCREMENT,
 	`sender_name` VARCHAR(30) NOT NULL,
-	`sender_id` INT(11) NOT NULL,
+	`sender_id` INT NOT NULL,
 	`receiver_name` VARCHAR(30) NOT NULL,
-	`receiver_id` INT(11) NOT NULL,
-	`receiver_accountid` INT(11) NOT NULL,
+	`receiver_id` INT NOT NULL,
+	`receiver_accountid` INT NOT NULL,
 	`title` VARCHAR(50) NOT NULL,
 	`body` VARCHAR(510) NOT NULL,
-	`zeny` BIGINT(20) NOT NULL,
-	`type` TINYINT(8) UNSIGNED NOT NULL,
-	`is_read` TINYINT(8) NOT NULL,
-	`sender_read` TINYINT(2) NOT NULL,
-	`send_date` INT(11) NOT NULL,
-	`expire_date` INT(11) NOT NULL,
-	`weight` INT(11) NOT NULL,
+	`zeny` BIGINT NOT NULL,
+	`type` TINYINT UNSIGNED NOT NULL,
+	`is_read` TINYINT NOT NULL,
+	`sender_read` TINYINT NOT NULL,
+	`send_date` INT NOT NULL,
+	`expire_date` INT NOT NULL,
+	`weight` INT NOT NULL,
 	PRIMARY KEY (`mail_id`),
   KEY `sender_id` (`sender_id`),
   KEY `receiver_id` (`receiver_id`),
@@ -1025,9 +1025,9 @@ CREATE TABLE IF NOT EXISTS `rodex_mail` (
 
 CREATE TABLE IF NOT EXISTS `npc_barter_data` (
   `name` VARCHAR(24) NOT NULL DEFAULT '',
-  `itemId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `priceId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
-  `priceAmount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `itemId` INT UNSIGNED NOT NULL DEFAULT '0',
+  `amount` INT UNSIGNED NOT NULL DEFAULT '0',
+  `priceId` INT UNSIGNED NOT NULL DEFAULT '0',
+  `priceAmount` INT UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`name`, `itemid`, `priceId`, `priceAmount`)
 ) ENGINE=MyISAM;
-- 
cgit v1.2.3-70-g09d2

