SQL Re-Organization.

Signed-off-by: KeiKun <the.keikun@gmail.com>

8 files changed, 1080 insertions, 1051 deletions

diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index a281d632e..3d5f56710 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -1,128 +1,157 @@
-#PickLog types (M)onsters Drop, (P)layers Drop/Take, Mobs Drop (L)oot Drop/Take,
-# Players (T)rade Give/Take, Players (V)ending Sell/Take, (S)hop Sell/Take, (N)PC Give/Take,
-# (C)onsumable Items, (A)dministrators Create/Delete, Sto(R)age, (G)uild Storage,
-# (E)mail attachment,(B)uying Store, Pr(O)duced Items/Ingredients, Auct(I)oned Items,
-# (X) Other, (D) Stolen from mobs, (U) MVP Prizes
-
-#Database: ragnarok
-#Table: picklog
-CREATE TABLE `picklog` (
-  `id` int(11) NOT NULL auto_increment,
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `char_id` int(11) NOT NULL default '0',
-  `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P',
-  `nameid` int(11) NOT NULL default '0',
-  `amount` int(11) NOT NULL default '1',
-  `refine` tinyint(3) 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',
-  `unique_id` bigint(20) unsigned NOT NULL default '0',
-  `map` varchar(11) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  INDEX (`type`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+-- PickLog Types
+--	(M)onsters Drop
+--	(P)layers Drop/Take
+--	Mobs Drop (L)oot Drop/Take
+--	Players (T)rade Give/Take
+--	Players (V)ending Sell/Take
+--	(S)hop Sell/Take
+--	(N)PC Give/Take
+--	(C)onsumable Items
+--	(A)dministrators Create/Delete
+--	Sto(R)age
+--	(G)uild Storage
+--	(E)mail attachment
+--	(B)uying Store
+--	Pr(O)duced Items/Ingredients
+--	Auct(I)oned Items
+--	(X) Other
+--	(D) Stolen from mobs
+--	(U) MVP Prizes
 
-#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators,(E)Mail,(B)uying Store
-#Database: ragnarok
-#Table: zenylog
-CREATE TABLE `zenylog` (
-  `id` int(11) NOT NULL auto_increment,
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `char_id` int(11) NOT NULL default '0',
-  `src_id` int(11) NOT NULL default '0',
-  `type` enum('T','V','P','M','S','N','D','C','A','E','I','B') NOT NULL default 'S',
-  `amount` int(11) NOT NULL default '0',
-  `map` varchar(11) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  INDEX (`type`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+--
+-- Table structure for table `atcommandlog`
+--
 
-#Database: ragnarok
-#Table: branchlog
-CREATE TABLE `branchlog` (
-  `branch_id` mediumint(9) unsigned NOT NULL auto_increment,
-  `branch_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `account_id` int(11) NOT NULL default '0',
-  `char_id` int(11) NOT NULL default '0',
-  `char_name` varchar(25) NOT NULL default '',
-  `map` varchar(11) NOT NULL default '',
-  PRIMARY KEY  (`branch_id`),
+CREATE TABLE IF NOT EXISTS `atcommandlog` (
+  `atcommand_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `atcommand_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_name` VARCHAR(25) NOT NULL DEFAULT '',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  `command` VARCHAR(255) NOT NULL DEFAULT '',
+  PRIMARY KEY (`atcommand_id`),
   INDEX (`account_id`),
   INDEX (`char_id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
 
-#Database: ragnarok
-#Table: mvplog
-CREATE TABLE `mvplog` (
-  `mvp_id` mediumint(9) unsigned NOT NULL auto_increment,
-  `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `kill_char_id` int(11) NOT NULL default '0',
-  `monster_id` smallint(6) NOT NULL default '0',
-  `prize` int(11) NOT NULL default '0',
-  `mvpexp` mediumint(9) NOT NULL default '0',
-  `map` varchar(11) NOT NULL default '',
-  PRIMARY KEY  (`mvp_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+--
+-- Table structure for table `branchlog`
+--
 
-#Database: ragnarok
-#Table: atcommandlog
-CREATE TABLE `atcommandlog` (
-  `atcommand_id` mediumint(9) unsigned NOT NULL auto_increment,
-  `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `account_id` int(11) unsigned NOT NULL default '0',
-  `char_id` int(11) unsigned NOT NULL default '0',
-  `char_name` varchar(25) NOT NULL default '',
-  `map` varchar(11) NOT NULL default '',
-  `command` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`atcommand_id`),
+CREATE TABLE IF NOT EXISTS `branchlog` (
+  `branch_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `branch_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `account_id` INT(11) NOT NULL DEFAULT '0',
+  `char_id` INT(11) NOT NULL DEFAULT '0',
+  `char_name` VARCHAR(25) NOT NULL DEFAULT '',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  PRIMARY KEY(`branch_id`),
   INDEX (`account_id`),
   INDEX (`char_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1;
 
-#Database: ragnarok
-#Table: npclog
-CREATE TABLE `npclog` (
-  `npc_id` mediumint(9) unsigned NOT NULL auto_increment,
-  `npc_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `account_id` int(11) unsigned NOT NULL default '0',
-  `char_id` int(11) unsigned NOT NULL default '0',
-  `char_name` varchar(25) NOT NULL default '',
-  `map` varchar(11) NOT NULL default '',
-  `mes` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`npc_id`),
-  INDEX (`account_id`),
-  INDEX (`char_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+--
+-- Table structure for table `chatlog`
+--
 
-#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat
-#Database: ragnarok
-#Table: chatlog
-CREATE TABLE `chatlog` (
-  `id` bigint(20) NOT NULL auto_increment,
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `type` enum('O','W','P','G','M') NOT NULL default 'O',
-  `type_id` int(11) NOT NULL default '0',
-  `src_charid` int(11) NOT NULL default '0',
-  `src_accountid` int(11) NOT NULL default '0',
-  `src_map` varchar(11) NOT NULL default '',
-  `src_map_x` smallint(4) NOT NULL default '0',
-  `src_map_y` smallint(4) NOT NULL default '0',
-  `dst_charname` varchar(25) NOT NULL default '',
-  `message` varchar(150) NOT NULL default '',
-  PRIMARY KEY  (`id`),
+CREATE TABLE IF NOT EXISTS `chatlog` (
+  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `type` ENUM('O','W','P','G','M') NOT NULL DEFAULT 'O',
+  `type_id` INT(11) NOT NULL DEFAULT '0',
+  `src_charid` INT(11) NOT NULL DEFAULT '0',
+  `src_accountid` INT(11) NOT NULL DEFAULT '0',
+  `src_map` VARCHAR(11) NOT NULL DEFAULT '',
+  `src_map_x` SMALLINT(4) NOT NULL DEFAULT '0',
+  `src_map_y` SMALLINT(4) NOT NULL DEFAULT '0',
+  `dst_charname` VARCHAR(25) NOT NULL DEFAULT '',
+  `message` VARCHAR(150) NOT NULL DEFAULT '',
+  PRIMARY KEY (`id`),
   INDEX (`src_accountid`),
   INDEX (`src_charid`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM AUTO_INCREMENT=1;
+
+--
+-- Table structure for table `loginlog`
+--
 
-#Database: ragnarok
-#Table: loginlog
-CREATE TABLE `loginlog` (
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `ip` varchar(15) NOT NULL default '',
-  `user` varchar(23) NOT NULL default '',
-  `rcode` tinyint(4) NOT NULL default '0',
-  `log` varchar(255) NOT NULL default '',
+CREATE TABLE IF NOT EXISTS `loginlog` (
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `ip` VARCHAR(15) NOT NULL DEFAULT '',
+  `user` VARCHAR(23) NOT NULL DEFAULT '',
+  `rcode` TINYINT(4) NOT NULL DEFAULT '0',
+  `log` VARCHAR(255) NOT NULL DEFAULT '',
   INDEX (`ip`)
-) ENGINE=MyISAM ;
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `mvplog`
+--
+
+CREATE TABLE IF NOT EXISTS `mvplog` (
+  `mvp_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `mvp_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `kill_char_id` INT(11) NOT NULL DEFAULT '0',
+  `monster_id` SMALLINT(6) NOT NULL DEFAULT '0',
+  `prize` INT(11) NOT NULL DEFAULT '0',
+  `mvpexp` MEDIUMINT(9) NOT NULL DEFAULT '0',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  PRIMARY KEY (`mvp_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1;
+
+--
+-- Table structure for table `npclog`
+--
+
+CREATE TABLE IF NOT EXISTS `npclog` (
+  `npc_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `npc_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `char_name` VARCHAR(25) NOT NULL DEFAULT '',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  `mes` VARCHAR(255) NOT NULL DEFAULT '',
+  PRIMARY KEY (`npc_id`),
+  INDEX (`account_id`),
+  INDEX (`char_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1;
+
+--
+-- Table structure for table `picklog`
+--
+
+CREATE TABLE IF NOT EXISTS `picklog` (
+  `id` INT(11) NOT NULL AUTO_INCREMENT,
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `char_id` INT(11) NOT NULL DEFAULT '0',
+  `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL DEFAULT 'P',
+  `nameid` INT(11) NOT NULL DEFAULT '0',
+  `amount` INT(11) NOT NULL DEFAULT '1',
+  `refine` TINYINT(3) 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',
+  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  PRIMARY KEY (`id`),
+  INDEX (`type`)
+) ENGINE=MyISAM AUTO_INCREMENT=1;
+
+--
+-- Table structure for table `zenylog`
+--
+
+CREATE TABLE IF NOT EXISTS `zenylog` (
+  `id` INT(11) NOT NULL AUTO_INCREMENT,
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `char_id` INT(11) NOT NULL DEFAULT '0',
+  `src_id` INT(11) NOT NULL DEFAULT '0',
+  `type` ENUM('T','V','P','M','S','N','D','C','A','E','I','B') NOT NULL DEFAULT 'S',
+  `amount` INT(11) NOT NULL DEFAULT '0',
+  `map` VARCHAR(11) NOT NULL DEFAULT '',
+  PRIMARY KEY (`id`),
+  INDEX (`type`)
+) ENGINE=MyISAM AUTO_INCREMENT=1;
+
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 9c2c1ca43..22cba1660 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -1,51 +1,114 @@
 --
+--
+-- Table structure for table `account_data`
+
+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` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+  `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+  `base_death` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+  PRIMARY KEY (`account_id`)
+) ENGINE=MyISAM; 
+
+--
+-- Table structure for table `acc_reg_num_db`
+--
+
+CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
+  `account_id` INT(11) 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',
+  PRIMARY KEY (`account_id`,`key`,`index`),
+  KEY `account_id` (`account_id`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `acc_reg_str_db`
+--
+
+CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
+  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `value` VARCHAR(254) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`account_id`,`key`,`index`),
+  KEY `account_id` (`account_id`)
+) ENGINE=MyISAM;
+
+--
 -- Table structure for table `auction`
 --
 
 CREATE TABLE IF NOT EXISTS `auction` (
-  `auction_id` bigint(20) unsigned NOT NULL auto_increment,
-  `seller_id` int(11) unsigned NOT NULL default '0',
-  `seller_name` varchar(30) NOT NULL default '',
-  `buyer_id` int(11) 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',
-  `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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) NOT NULL default '0',
-  `unique_id` bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`auction_id`)
+  `auction_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `seller_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `seller_name` VARCHAR(30) NOT NULL DEFAULT '',
+  `buyer_id` INT(11) 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',
+  `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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`auction_id`)
 ) ENGINE=MyISAM;
 
 --
+-- Table structure for table `autotrade_data`
+--
+
+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',
+  PRIMARY KEY (`char_id`,`itemkey`)
+) ENGINE=MyISAM; 
+
+--
+-- Table structure for table `autotrade_merchants`
+--
+
+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',
+  `title` VARCHAR(80) NOT NULL DEFAULT 'Buy From Me!',
+  PRIMARY KEY (`account_id`,`char_id`)
+) ENGINE=MyISAM; 
+
+--
 -- Table structure for table `cart_inventory`
 --
 
 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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) 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',
-  PRIMARY KEY  (`id`),
+  `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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) 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',
+  PRIMARY KEY (`id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -54,65 +117,65 @@ 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',
-  `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` mediumint(8) unsigned NOT NULL default '0',
-  `hp` mediumint(8) unsigned NOT NULL default '0',
-  `max_sp` mediumint(6) unsigned NOT NULL default '0',
-  `sp` mediumint(6) 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',
-  `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',
-  `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',
+  `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',
+  `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` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  `hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  `max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `sp` MEDIUMINT(6) 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',
+  `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',
+  `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_map` varchar(11) NOT NULL default '',
-  `last_x` smallint(4) unsigned NOT NULL default '53',
-  `last_y` smallint(4) 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',
-  PRIMARY KEY  (`char_id`),
+  `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',
+  `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',
+  PRIMARY KEY (`char_id`),
   UNIQUE KEY `name_key` (`name`),
   KEY `account_id` (`account_id`),
   KEY `party_id` (`party_id`),
@@ -121,24 +184,50 @@ CREATE TABLE IF NOT EXISTS `char` (
 ) ENGINE=MyISAM AUTO_INCREMENT=150000; 
 
 --
+-- Table structure for table `char_reg_num_db`
+--
+
+CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
+  `char_id` INT(11) 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',
+  PRIMARY KEY (`char_id`,`key`,`index`),
+  KEY `char_id` (`char_id`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `char_reg_str_db`
+--
+
+CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
+  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `value` VARCHAR(254) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`char_id`,`key`,`index`),
+  KEY `char_id` (`char_id`)
+) ENGINE=MyISAM;
+
+--
 -- Table structure for table `charlog`
 --
 
 CREATE TABLE IF NOT EXISTS `charlog` (
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `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',
-  `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'
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `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',
+  `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'
 ) ENGINE=MyISAM; 
 
 --
@@ -146,24 +235,24 @@ 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',
-  PRIMARY KEY  (`ele_id`)
+  `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',
+  PRIMARY KEY (`ele_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -171,9 +260,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(11) NOT NULL DEFAULT '0',
+  `friend_account` INT(11) NOT NULL DEFAULT '0',
+  `friend_id` INT(11) NOT NULL DEFAULT '0',
   KEY  `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -183,35 +272,61 @@ 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',
+	`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',
 	PRIMARY KEY (`char_id`,`hotkey`)
 ) ENGINE=MyISAM;
 
 --
+-- Table structure for table `global_acc_reg_num_db`
+--
+
+CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
+  `account_id` INT(11) 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',
+  PRIMARY KEY (`account_id`,`key`,`index`),
+  KEY `account_id` (`account_id`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `global_acc_reg_str_db`
+--
+
+CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
+  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `value` VARCHAR(254) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`account_id`,`key`,`index`),
+  KEY `account_id` (`account_id`)
+) ENGINE=MyISAM;
+
+--
 -- Table structure for table `guild`
 --
 
 CREATE TABLE IF NOT EXISTS `guild` (
-  `guild_id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(24) NOT NULL default '',
-  `char_id` int(11) 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',
-  `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',
+  `guild_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `name` VARCHAR(24) NOT NULL DEFAULT '',
+  `char_id` INT(11) 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',
+  `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_data` blob,
-  PRIMARY KEY  (`guild_id`,`char_id`),
+  PRIMARY KEY (`guild_id`,`char_id`),
   UNIQUE KEY `guild_id` (`guild_id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
@@ -221,11 +336,11 @@ 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',
-  `name` varchar(24) NOT NULL default '',
-  PRIMARY KEY  (`guild_id`,`alliance_id`),
+  `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',
+  `name` VARCHAR(24) NOT NULL DEFAULT '',
+  PRIMARY KEY (`guild_id`,`alliance_id`),
   KEY `alliance_id` (`alliance_id`)
 ) ENGINE=MyISAM;
 
@@ -234,25 +349,25 @@ 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',
-  PRIMARY KEY  (`castle_id`),
+  `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',
+  PRIMARY KEY (`castle_id`),
   KEY `guild_id` (`guild_id`)
 ) ENGINE=MyISAM;
 
@@ -261,11 +376,11 @@ 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',
-  `name` varchar(24) NOT NULL default '',
-  `mes` varchar(40) NOT NULL default '',
-  PRIMARY KEY  (`guild_id`,`name`)
+  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `name` VARCHAR(24) NOT NULL DEFAULT '',
+  `mes` VARCHAR(40) NOT NULL DEFAULT '',
+  PRIMARY KEY (`guild_id`,`name`)
 ) ENGINE=MyISAM;
 
 --
@@ -273,20 +388,20 @@ 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',
-  `name` varchar(24) NOT NULL default '',
-  PRIMARY KEY  (`guild_id`,`char_id`),
+  `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',
+  `name` VARCHAR(24) NOT NULL DEFAULT '',
+  PRIMARY KEY (`guild_id`,`char_id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -295,12 +410,12 @@ 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',
-  `name` varchar(24) NOT NULL default '',
-  `mode` tinyint(11) unsigned NOT NULL default '0',
-  `exp_mode` tinyint(11) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`guild_id`,`position`)
+  `guild_id` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `position` TINYINT(6) 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',
+  PRIMARY KEY (`guild_id`,`position`)
 ) ENGINE=MyISAM;
 
 --
@@ -308,10 +423,10 @@ 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',
-  PRIMARY KEY  (`guild_id`,`id`)
+  `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',
+  PRIMARY KEY (`guild_id`,`id`)
 ) ENGINE=MyISAM;
 
 --
@@ -319,22 +434,22 @@ 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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) 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',
-  PRIMARY KEY  (`id`),
+  `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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) 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',
+  PRIMARY KEY (`id`),
   KEY `guild_id` (`guild_id`)
 ) ENGINE=MyISAM;
 
@@ -343,63 +458,73 @@ 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',
-  `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',
-  PRIMARY KEY  (`homun_id`)
+  `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',
+  `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',
+  PRIMARY KEY (`homun_id`)
 ) ENGINE=MyISAM;
 
 -- 
--- Table structure for table `interlog`
+-- Table structure for table `INTerlog`
 --
 
-CREATE TABLE IF NOT EXISTS `interlog` (
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `log` varchar(255) NOT NULL default ''
+CREATE TABLE IF NOT EXISTS `INTerlog` (
+  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `log` VARCHAR(255) NOT NULL DEFAULT ''
 ) ENGINE=MyISAM; 
 
 --
+-- Table structure for table `INTerreg`
+--
+
+CREATE TABLE IF NOT EXISTS `interreg` (
+  `varname` VARCHAR(11) NOT NULL,
+  `value` VARCHAR(20) NOT NULL,
+   PRIMARY KEY (`varname`)
+) ENGINE=InnoDB;
+
+--
 -- Table structure for table `inventory`
 --
 
 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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) 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',
-  PRIMARY KEY  (`id`),
+  `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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) 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',
+  PRIMARY KEY (`id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -408,10 +533,10 @@ CREATE TABLE IF NOT EXISTS `inventory` (
 --
 
 CREATE TABLE IF NOT EXISTS `ipbanlist` (
-  `list` varchar(255) NOT NULL default '',
-  `btime` datetime NOT NULL default '0000-00-00 00:00:00',
-  `rtime` datetime NOT NULL default '0000-00-00 00:00:00',
-  `reason` varchar(255) NOT NULL default '',
+  `list` VARCHAR(255) NOT NULL DEFAULT '',
+  `btime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `rtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `reason` VARCHAR(255) NOT NULL DEFAULT '',
   KEY (`list`)
 ) ENGINE=MyISAM;
 
@@ -420,28 +545,28 @@ CREATE TABLE IF NOT EXISTS `ipbanlist` (
 --
 
 CREATE TABLE IF NOT EXISTS `login` (
-  `account_id` int(11) 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',
-  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
-  `last_ip` varchar(100) NOT NULL default '',
+  `account_id` INT(11) 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',
+  `lastlogin` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `last_ip` VARCHAR(100) NOT NULL DEFAULT '',
   `birthdate` DATE NOT NULL DEFAULT '0000-00-00',
-  `character_slots` TINYINT( 3 ) unsigned NOT NULL default '0',
-  `pincode` varchar(4) NOT NULL default '',
-  `pincode_change` int(11) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`account_id`),
+  `character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `pincode` VARCHAR(4) NOT NULL DEFAULT '',
+  `pincode_change` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`account_id`),
   KEY `name` (`userid`)
 ) ENGINE=MyISAM AUTO_INCREMENT=2000000; 
 
 -- added standard accounts for servers, VERY INSECURE!!!
--- inserted into the table called login which is above
+-- inserted INTo the table called login which is above
 
 INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','athena@athena.com');
 
@@ -450,10 +575,21 @@ INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES
 --
 
 CREATE TABLE IF NOT EXISTS `mapreg` (
-  `varname` varchar(32) BINARY NOT NULL,
-  `index` int(11) unsigned NOT NULL default '0',
-  `value` varchar(255) NOT NULL,
-  PRIMARY KEY  (`varname`,`index`)
+  `varname` VARCHAR(32) BINARY NOT NULL,
+  `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `value` VARCHAR(255) NOT NULL,
+  PRIMARY KEY (`varname`,`index`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `npc_market_data`
+--
+
+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',
+  PRIMARY KEY (`name`,`itemid`)
 ) ENGINE=MyISAM;
 
 --
@@ -461,17 +597,17 @@ CREATE TABLE IF NOT EXISTS `mapreg` (
 --
 
 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,
-  `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(11) UNSIGNED NOT NULL,
+  `char_id` INT(11) UNSIGNED NOT NULL,
+  `type` SMALLINT(11) UNSIGNED NOT NULL,
+  `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',
   KEY (`account_id`),
   KEY (`char_id`),
-  PRIMARY KEY  (`account_id`,`char_id`,`type`)
+  PRIMARY KEY (`account_id`,`char_id`,`type`)
 ) ENGINE=MyISAM;
 
 --
@@ -479,27 +615,27 @@ CREATE TABLE IF NOT EXISTS `sc_data` (
 --
 
 CREATE TABLE IF NOT EXISTS `mail` (
-  `id` bigint(20) unsigned NOT NULL auto_increment,
-  `send_name` varchar(30) NOT NULL default '',
-  `send_id` int(11) unsigned NOT NULL default '0',
-  `dest_name` varchar(30) NOT NULL default '',
-  `dest_id` int(11) 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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) NOT NULL default '0',
-  `unique_id` bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`id`)
+  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `send_name` VARCHAR(30) NOT NULL DEFAULT '',
+  `send_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `dest_name` VARCHAR(30) NOT NULL DEFAULT '',
+  `dest_id` INT(11) 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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+  `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
 ) ENGINE=MyISAM;
 
 --
@@ -507,12 +643,12 @@ 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',
-  `map` varchar(11) NOT NULL default '',
-  `x` smallint(4) unsigned NOT NULL default '0',
-  `y` smallint(4) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`memo_id`),
+  `memo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `char_id` INT(11) 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',
+  PRIMARY KEY (`memo_id`),
   KEY `char_id` (`char_id`)
 ) ENGINE=MyISAM;
 
@@ -521,14 +657,14 @@ 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',
-  PRIMARY KEY  (`mer_id`)
+  `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',
+  PRIMARY KEY (`mer_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -536,15 +672,15 @@ 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',
-  PRIMARY KEY  (`char_id`)
+  `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',
+  PRIMARY KEY (`char_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -552,13 +688,13 @@ CREATE TABLE IF NOT EXISTS `mercenary_owner` (
 --
 
 CREATE TABLE IF NOT EXISTS `party` (
-  `party_id` int(11) 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',
-  PRIMARY KEY  (`party_id`)
+  `party_id` INT(11) 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',
+  PRIMARY KEY (`party_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -566,19 +702,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',
-  `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',
-  PRIMARY KEY  (`pet_id`)
+  `pet_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `class` MEDIUMINT(9) 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',
+  PRIMARY KEY (`pet_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -586,14 +722,14 @@ 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,
-  `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',
-  PRIMARY KEY  (`char_id`,`quest_id`)
+  `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+  `quest_id` INT(10) 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',
+  PRIMARY KEY (`char_id`,`quest_id`)
 ) ENGINE=MyISAM;
 
 --
@@ -601,11 +737,11 @@ CREATE TABLE IF NOT EXISTS `quest` (
 --
 
 CREATE TABLE IF NOT EXISTS `ragsrvinfo` (
-  `index` int(11) 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'
+  `index` INT(11) 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'
 ) ENGINE=MyISAM;
 
 --
@@ -613,11 +749,11 @@ 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,
-  PRIMARY KEY  (`char_id`,`id`)
+  `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,
+  PRIMARY KEY (`char_id`,`id`)
 ) ENGINE=MyISAM;
 
 --
@@ -625,10 +761,10 @@ 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,
-  PRIMARY KEY  (`homun_id`,`id`)
+  `homun_id` INT(11) NOT NULL,
+  `id` INT(11) NOT NULL,
+  `lv` SMALLINT(6) NOT NULL,
+  PRIMARY KEY (`homun_id`,`id`)
 ) ENGINE=MyISAM;
 
 --
@@ -636,8 +772,8 @@ CREATE TABLE IF NOT EXISTS `skill_homunculus` (
 --
 
 CREATE TABLE IF NOT EXISTS `sql_updates` (
-  `timestamp` int(11) unsigned NOT NULL,
-  `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',
+  `timestamp` INT(11) UNSIGNED NOT NULL,
+  `ignored` ENUM('Yes','No') NOT NULL DEFAULT 'No',
   PRIMARY KEY (`timestamp`)
 ) ENGINE=MyISAM;
 
@@ -675,9 +811,9 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-0
 --
 
 CREATE TABLE IF NOT EXISTS `sstatus` (
-  `index` tinyint(4) unsigned NOT NULL default '0',
-  `name` varchar(255) NOT NULL default '',
-  `user` int(11) unsigned NOT NULL default '0'
+  `index` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `name` VARCHAR(255) NOT NULL DEFAULT '',
+  `user` INT(11) UNSIGNED NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM;
 
 --
@@ -685,158 +821,22 @@ CREATE TABLE IF NOT EXISTS `sstatus` (
 --
 
 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` smallint(11) NOT NULL default '0',
-  `card1` smallint(11) NOT NULL default '0',
-  `card2` smallint(11) NOT NULL default '0',
-  `card3` smallint(11) 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',
-  PRIMARY KEY  (`id`),
+  `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` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+  `card3` SMALLINT(11) 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',
+  PRIMARY KEY (`id`),
   KEY `account_id` (`account_id`)
 ) ENGINE=MyISAM;
 
---
--- Table structure for table `interreg`
---
-
-CREATE TABLE IF NOT EXISTS `interreg` (
-  `varname` varchar(11) NOT NULL,
-  `value` varchar(20) NOT NULL,
-   PRIMARY KEY (`varname`)
-) ENGINE=InnoDB;
-
---
--- Table structure for table `account_data`
---
-
-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` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
-  `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
-  `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
-  PRIMARY KEY  (`account_id`)
-) ENGINE=MyISAM; 
-
---
--- Table structure for table `npc_market_data`
---
-
-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',
-  PRIMARY KEY  (`name`,`itemid`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `acc_reg_num_db`
---
-
-CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
-  `account_id` int(11) 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',
-  PRIMARY KEY  (`account_id`,`key`,`index`),
-  KEY `account_id` (`account_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `acc_reg_str_db`
---
-
-CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
-  `account_id` int(11) unsigned NOT NULL default '0',
-  `key` varchar(32) BINARY NOT NULL default '',
-  `index` int(11) unsigned NOT NULL default '0',
-  `value` varchar(254) NOT NULL default '0',
-  PRIMARY KEY  (`account_id`,`key`,`index`),
-  KEY `account_id` (`account_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `char_reg_num_db`
---
-
-CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
-  `char_id` int(11) 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',
-  PRIMARY KEY  (`char_id`,`key`,`index`),
-  KEY `char_id` (`char_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `char_reg_str_db`
---
-
-CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
-  `char_id` int(11) unsigned NOT NULL default '0',
-  `key` varchar(32) BINARY NOT NULL default '',
-  `index` int(11) unsigned NOT NULL default '0',
-  `value` varchar(254) NOT NULL default '0',
-  PRIMARY KEY  (`char_id`,`key`,`index`),
-  KEY `char_id` (`char_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `global_acc_reg_num_db`
---
-
-CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
-  `account_id` int(11) 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',
-  PRIMARY KEY  (`account_id`,`key`,`index`),
-  KEY `account_id` (`account_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `global_acc_reg_str_db`
---
-
-
-CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
-  `account_id` int(11) unsigned NOT NULL default '0',
-  `key` varchar(32) BINARY NOT NULL default '',
-  `index` int(11) unsigned NOT NULL default '0',
-  `value` varchar(254) NOT NULL default '0',
-  PRIMARY KEY  (`account_id`,`key`,`index`),
-  KEY `account_id` (`account_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `autotrade_merchants`
---
-
-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',
-  `title` varchar(80) NOT NULL default 'Buy From Me!',
-  PRIMARY KEY  (`account_id`,`char_id`)
-) ENGINE=MyISAM; 
-
---
--- Table structure for table `autotrade_data`
---
-
-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',
-  PRIMARY KEY  (`char_id`,`itemkey`)
-) ENGINE=MyISAM; 
diff --git a/sql-files/mob_db.sql b/sql-files/mob_db.sql
index 894c34650..89674e1de 100644
--- a/sql-files/mob_db.sql
+++ b/sql-files/mob_db.sql
@@ -1,74 +1,74 @@
-#
-# Table structure for table `mob_db`
-#
+--
+-- Table structure for table `mob_db`
+--
 
 DROP TABLE IF EXISTS `mob_db`;
 CREATE TABLE `mob_db` (
-  `ID` mediumint(9) unsigned NOT NULL default '0',
-  `Sprite` text NOT NULL,
-  `kName` text NOT NULL,
-  `iName` text NOT NULL,
-  `LV` tinyint(6) unsigned NOT NULL default '0',
-  `HP` int(9) unsigned NOT NULL default '0',
-  `SP` mediumint(9) unsigned NOT NULL default '0',
-  `EXP` mediumint(9) unsigned NOT NULL default '0',
-  `JEXP` mediumint(9) unsigned NOT NULL default '0',
-  `Range1` tinyint(4) unsigned NOT NULL default '0',
-  `ATK1` smallint(6) unsigned NOT NULL default '0',
-  `ATK2` smallint(6) unsigned NOT NULL default '0',
-  `DEF` smallint(6) unsigned NOT NULL default '0',
-  `MDEF` smallint(6) unsigned NOT NULL default '0',
-  `STR` smallint(6) unsigned NOT NULL default '0',
-  `AGI` smallint(6) unsigned NOT NULL default '0',
-  `VIT` smallint(6) unsigned NOT NULL default '0',
-  `INT` smallint(6) unsigned NOT NULL default '0',
-  `DEX` smallint(6) unsigned NOT NULL default '0',
-  `LUK` smallint(6) unsigned NOT NULL default '0',
-  `Range2` tinyint(4) unsigned NOT NULL default '0',
-  `Range3` tinyint(4) unsigned NOT NULL default '0',
-  `Scale` tinyint(4) unsigned NOT NULL default '0',
-  `Race` tinyint(4) unsigned NOT NULL default '0',
-  `Element` tinyint(4) unsigned NOT NULL default '0',
-  `Mode` smallint(6) unsigned NOT NULL default '0',
-  `Speed` smallint(6) unsigned NOT NULL default '0',
-  `aDelay` smallint(6) unsigned NOT NULL default '0',
-  `aMotion` smallint(6) unsigned NOT NULL default '0',
-  `dMotion` smallint(6) unsigned NOT NULL default '0',
-  `MEXP` mediumint(9) unsigned NOT NULL default '0',
-  `MVP1id` smallint(9) unsigned NOT NULL default '0',
-  `MVP1per` smallint(9) unsigned NOT NULL default '0',
-  `MVP2id` smallint(9) unsigned NOT NULL default '0',
-  `MVP2per` smallint(9) unsigned NOT NULL default '0',
-  `MVP3id` smallint(9) unsigned NOT NULL default '0',
-  `MVP3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop1id` smallint(9) unsigned NOT NULL default '0',
-  `Drop1per` smallint(9) unsigned NOT NULL default '0',
-  `Drop2id` smallint(9) unsigned NOT NULL default '0',
-  `Drop2per` smallint(9) unsigned NOT NULL default '0',
-  `Drop3id` smallint(9) unsigned NOT NULL default '0',
-  `Drop3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop4id` smallint(9) unsigned NOT NULL default '0',
-  `Drop4per` smallint(9) unsigned NOT NULL default '0',
-  `Drop5id` smallint(9) unsigned NOT NULL default '0',
-  `Drop5per` smallint(9) unsigned NOT NULL default '0',
-  `Drop6id` smallint(9) unsigned NOT NULL default '0',
-  `Drop6per` smallint(9) unsigned NOT NULL default '0',
-  `Drop7id` smallint(9) unsigned NOT NULL default '0',
-  `Drop7per` smallint(9) unsigned NOT NULL default '0',
-  `Drop8id` smallint(9) unsigned NOT NULL default '0',
-  `Drop8per` smallint(9) unsigned NOT NULL default '0',
-  `Drop9id` smallint(9) unsigned NOT NULL default '0',
-  `Drop9per` smallint(9) unsigned NOT NULL default '0',
-  `DropCardid` smallint(9) unsigned NOT NULL default '0',
-  `DropCardper` smallint(9) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`ID`)
+  `ID` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Sprite` TEXT NOT NULL,
+  `kName` TEXT NOT NULL,
+  `iName` TEXT NOT NULL,
+  `LV` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `HP` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `SP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `EXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `JEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Range1` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK1` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK2` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MDEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `STR` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `AGI` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `VIT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `INT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEX` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `LUK` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Range2` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Range3` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `dMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardid` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardper` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM;
 
-#  Monster Database
-# 
-#  Structure of Database :
-# REPLACE INTO `mob_db` VALUES ( ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
-#  Note: Keep the Sprite_Name field as it is in the game client.
+-- Monster Database
+--
+-- Structure of Database :
+-- REPLACE INTO `mob_db` VALUES (ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
+-- Note: Keep the Sprite_Name field as it is in the game client.
 REPLACE INTO `mob_db` VALUES (1001,'SCORPION','Scorpion','Scorpion',24,1109,0,287,176,1,80,135,30,0,1,24,24,5,52,5,10,12,0,4,23,0x3195,200,1564,864,576,0,0,0,0,0,0,0,990,70,904,5500,757,57,943,210,7041,100,508,200,625,20,0,0,0,0,4068,1);
 REPLACE INTO `mob_db` VALUES (1002,'PORING','Poring','Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,0,6,30,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,1);
 # REPLACE INTO `mob_db` VALUES (1003,'TESTEGG','Test Egg','Test Egg',2,100000,0,10,10,0,3,9,99,0,1,99,1,1,1,1,10,12,0,4,22,0x0,512,0,512,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
diff --git a/sql-files/mob_db2.sql b/sql-files/mob_db2.sql
index a370e0f58..2367c634a 100644
--- a/sql-files/mob_db2.sql
+++ b/sql-files/mob_db2.sql
@@ -1,88 +1,88 @@
-#
-# Table structure for table `mob_db2`
-#
+--
+-- Table structure for table `mob_db2`
+--
 
 DROP TABLE IF EXISTS `mob_db2`;
 CREATE TABLE `mob_db2` (
-  `ID` mediumint(9) unsigned NOT NULL default '0',
-  `Sprite` text NOT NULL,
-  `kName` text NOT NULL,
-  `iName` text NOT NULL,
-  `LV` tinyint(6) unsigned NOT NULL default '0',
-  `HP` int(9) unsigned NOT NULL default '0',
-  `SP` mediumint(9) unsigned NOT NULL default '0',
-  `EXP` mediumint(9) unsigned NOT NULL default '0',
-  `JEXP` mediumint(9) unsigned NOT NULL default '0',
-  `Range1` tinyint(4) unsigned NOT NULL default '0',
-  `ATK1` smallint(6) unsigned NOT NULL default '0',
-  `ATK2` smallint(6) unsigned NOT NULL default '0',
-  `DEF` smallint(6) unsigned NOT NULL default '0',
-  `MDEF` smallint(6) unsigned NOT NULL default '0',
-  `STR` smallint(6) unsigned NOT NULL default '0',
-  `AGI` smallint(6) unsigned NOT NULL default '0',
-  `VIT` smallint(6) unsigned NOT NULL default '0',
-  `INT` smallint(6) unsigned NOT NULL default '0',
-  `DEX` smallint(6) unsigned NOT NULL default '0',
-  `LUK` smallint(6) unsigned NOT NULL default '0',
-  `Range2` tinyint(4) unsigned NOT NULL default '0',
-  `Range3` tinyint(4) unsigned NOT NULL default '0',
-  `Scale` tinyint(4) unsigned NOT NULL default '0',
-  `Race` tinyint(4) unsigned NOT NULL default '0',
-  `Element` tinyint(4) unsigned NOT NULL default '0',
-  `Mode` smallint(6) unsigned NOT NULL default '0',
-  `Speed` smallint(6) unsigned NOT NULL default '0',
-  `aDelay` smallint(6) unsigned NOT NULL default '0',
-  `aMotion` smallint(6) unsigned NOT NULL default '0',
-  `dMotion` smallint(6) unsigned NOT NULL default '0',
-  `MEXP` mediumint(9) unsigned NOT NULL default '0',
-  `MVP1id` smallint(9) unsigned NOT NULL default '0',
-  `MVP1per` smallint(9) unsigned NOT NULL default '0',
-  `MVP2id` smallint(9) unsigned NOT NULL default '0',
-  `MVP2per` smallint(9) unsigned NOT NULL default '0',
-  `MVP3id` smallint(9) unsigned NOT NULL default '0',
-  `MVP3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop1id` smallint(9) unsigned NOT NULL default '0',
-  `Drop1per` smallint(9) unsigned NOT NULL default '0',
-  `Drop2id` smallint(9) unsigned NOT NULL default '0',
-  `Drop2per` smallint(9) unsigned NOT NULL default '0',
-  `Drop3id` smallint(9) unsigned NOT NULL default '0',
-  `Drop3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop4id` smallint(9) unsigned NOT NULL default '0',
-  `Drop4per` smallint(9) unsigned NOT NULL default '0',
-  `Drop5id` smallint(9) unsigned NOT NULL default '0',
-  `Drop5per` smallint(9) unsigned NOT NULL default '0',
-  `Drop6id` smallint(9) unsigned NOT NULL default '0',
-  `Drop6per` smallint(9) unsigned NOT NULL default '0',
-  `Drop7id` smallint(9) unsigned NOT NULL default '0',
-  `Drop7per` smallint(9) unsigned NOT NULL default '0',
-  `Drop8id` smallint(9) unsigned NOT NULL default '0',
-  `Drop8per` smallint(9) unsigned NOT NULL default '0',
-  `Drop9id` smallint(9) unsigned NOT NULL default '0',
-  `Drop9per` smallint(9) unsigned NOT NULL default '0',
-  `DropCardid` smallint(9) unsigned NOT NULL default '0',
-  `DropCardper` smallint(9) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`ID`)
+  `ID` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Sprite` TEXT NOT NULL,
+  `kName` TEXT NOT NULL,
+  `iName` TEXT NOT NULL,
+  `LV` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `HP` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `SP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `EXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `JEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Range1` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK1` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK2` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MDEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `STR` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `AGI` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `VIT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `INT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEX` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `LUK` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Range2` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Range3` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `dMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardid` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardper` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM;
 
-#  Monsters Additional Database
-# 
-#  Structure of Database :
-# REPLACE INTO `mob_db2` VALUES ( ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
+-- Monsters Additional Database
+--
+-- Structure of Database :
+-- REPLACE INTO `mob_db2` VALUES (ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
 
-# rAthena Dev Team
+-- rAthena Dev Team
 #REPLACE INTO `mob_db2` VALUES (1900,'VALARIS','Valaris','Valaris',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);
 #REPLACE INTO `mob_db2` VALUES (1901,'VALARIS_WORSHIPPER','Valaris\'s Worshipper','Valaris\'s Worshipper',50,8578,0,2706,1480,1,487,590,15,25,1,75,55,1,93,45,10,12,0,6,27,0x1685,100,868,480,120,0,0,0,0,0,0,0,923,500,984,63,1464,2,607,50,610,100,503,300,2405,50,0,0,0,0,4129,1);
 #REPLACE INTO `mob_db2` VALUES (1902,'MC_CAMERI','MC Cameri','MC Cameri',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);
 #REPLACE INTO `mob_db2` VALUES (1903,'POKI','Poki#3','Poki#3',99,1349000,0,4093000,1526000,9,4892,9113,22,35,1,180,39,67,193,130,10,12,1,7,64,0x1973,120,500,672,480,92100,603,5500,617,3000,1723,1000,1228,100,1236,500,617,2500,1234,75,1237,125,1722,250,1724,100,1720,50,0,0,0,0);
 #REPLACE INTO `mob_db2` VALUES (1904,'SENTRY','Sentry','Sentry',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);
 
-# Custom Hollow Poring (overrrides/collides with META_ANDRE)
+-- Custom Hollow Poring (overrrides/collides with META_ANDRE)
 #REPLACE INTO `mob_db2` VALUES (1237,'HOLLOW_PORING','Hollow Poring','Hollow Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,0,6,30,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,10);
-# Custom Fire Poring. Warning, Colides with META_DENIRO
+-- Custom Fire Poring. Warning, Colides with META_DENIRO
 #REPLACE INTO `mob_db2` VALUES (1239,'FIRE_PORING','Fire Poring','Fire Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,1,6,30,10,12,1,3,21,0x131,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,741,5,619,20,0,0,0,0,4001,20);
 
-# Lunar New Year 2008 Event Monster overrides
-# Uncomment if event is enabled, as these drops modifications are nessecary.
+-- Lunar New Year 2008 Event Monster overrides
+-- Uncomment if event is enabled, as these drops modifications are nessecary.
 #REPLACE INTO `mob_db2` VALUES (1145,'MARTIN','Martin','Martin',18,1109,0,134,86,1,52,63,0,5,12,18,30,15,15,5,10,12,0,2,42,0x81,300,1480,480,480,0,0,0,0,0,0,0,1017,9000,1018,500,1251,10,2225,5,5009,1,10010,10,2224,15,7869,1500,0,0,4046,1);
 #REPLACE INTO `mob_db2` VALUES (1175,'TAROU','Tarou','Tarou',11,284,0,57,28,1,34,45,0,0,1,20,11,10,24,5,10,12,0,2,27,0x91,150,1744,1044,684,0,0,0,0,0,0,0,1016,9000,919,3000,949,800,528,1000,701,2,7869,2500,0,0,0,0,0,0,4028,1);
 #REPLACE INTO `mob_db2` VALUES (1209,'CRAMP','Cramp','Cramp',56,4720,0,2300,1513,1,395,465,0,5,1,85,35,5,65,60,10,12,0,2,45,0x3095,100,1000,500,1000,0,0,0,0,0,0,0,7007,4656,528,1000,726,80,746,110,568,250,510,70,984,95,7869,1500,0,0,4296,1);
diff --git a/sql-files/mob_db_re.sql b/sql-files/mob_db_re.sql
index bd2ab084f..8a2863b80 100644
--- a/sql-files/mob_db_re.sql
+++ b/sql-files/mob_db_re.sql
@@ -1,74 +1,74 @@
-#
-# Table structure for table `mob_db`
-#
+--
+-- Table structure for table `mob_db`
+-- 
 
 DROP TABLE IF EXISTS `mob_db`;
 CREATE TABLE `mob_db` (
-  `ID` mediumint(9) unsigned NOT NULL default '0',
-  `Sprite` text NOT NULL,
-  `kName` text NOT NULL,
-  `iName` text NOT NULL,
-  `LV` tinyint(6) unsigned NOT NULL default '0',
-  `HP` int(9) unsigned NOT NULL default '0',
-  `SP` mediumint(9) unsigned NOT NULL default '0',
-  `EXP` mediumint(9) unsigned NOT NULL default '0',
-  `JEXP` mediumint(9) unsigned NOT NULL default '0',
-  `Range1` tinyint(4) unsigned NOT NULL default '0',
-  `ATK1` smallint(6) unsigned NOT NULL default '0',
-  `ATK2` smallint(6) unsigned NOT NULL default '0',
-  `DEF` smallint(6) unsigned NOT NULL default '0',
-  `MDEF` smallint(6) unsigned NOT NULL default '0',
-  `STR` smallint(6) unsigned NOT NULL default '0',
-  `AGI` smallint(6) unsigned NOT NULL default '0',
-  `VIT` smallint(6) unsigned NOT NULL default '0',
-  `INT` smallint(6) unsigned NOT NULL default '0',
-  `DEX` smallint(6) unsigned NOT NULL default '0',
-  `LUK` smallint(6) unsigned NOT NULL default '0',
-  `Range2` tinyint(4) unsigned NOT NULL default '0',
-  `Range3` tinyint(4) unsigned NOT NULL default '0',
-  `Scale` tinyint(4) unsigned NOT NULL default '0',
-  `Race` tinyint(4) unsigned NOT NULL default '0',
-  `Element` tinyint(4) unsigned NOT NULL default '0',
-  `Mode` smallint(6) unsigned NOT NULL default '0',
-  `Speed` smallint(6) unsigned NOT NULL default '0',
-  `aDelay` smallint(6) unsigned NOT NULL default '0',
-  `aMotion` smallint(6) unsigned NOT NULL default '0',
-  `dMotion` smallint(6) unsigned NOT NULL default '0',
-  `MEXP` mediumint(9) unsigned NOT NULL default '0',
-  `MVP1id` smallint(9) unsigned NOT NULL default '0',
-  `MVP1per` smallint(9) unsigned NOT NULL default '0',
-  `MVP2id` smallint(9) unsigned NOT NULL default '0',
-  `MVP2per` smallint(9) unsigned NOT NULL default '0',
-  `MVP3id` smallint(9) unsigned NOT NULL default '0',
-  `MVP3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop1id` smallint(9) unsigned NOT NULL default '0',
-  `Drop1per` smallint(9) unsigned NOT NULL default '0',
-  `Drop2id` smallint(9) unsigned NOT NULL default '0',
-  `Drop2per` smallint(9) unsigned NOT NULL default '0',
-  `Drop3id` smallint(9) unsigned NOT NULL default '0',
-  `Drop3per` smallint(9) unsigned NOT NULL default '0',
-  `Drop4id` smallint(9) unsigned NOT NULL default '0',
-  `Drop4per` smallint(9) unsigned NOT NULL default '0',
-  `Drop5id` smallint(9) unsigned NOT NULL default '0',
-  `Drop5per` smallint(9) unsigned NOT NULL default '0',
-  `Drop6id` smallint(9) unsigned NOT NULL default '0',
-  `Drop6per` smallint(9) unsigned NOT NULL default '0',
-  `Drop7id` smallint(9) unsigned NOT NULL default '0',
-  `Drop7per` smallint(9) unsigned NOT NULL default '0',
-  `Drop8id` smallint(9) unsigned NOT NULL default '0',
-  `Drop8per` smallint(9) unsigned NOT NULL default '0',
-  `Drop9id` smallint(9) unsigned NOT NULL default '0',
-  `Drop9per` smallint(9) unsigned NOT NULL default '0',
-  `DropCardid` smallint(9) unsigned NOT NULL default '0',
-  `DropCardper` smallint(9) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`ID`)
+  `ID` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Sprite` TEXT NOT NULL,
+  `kName` TEXT NOT NULL,
+  `iName` TEXT NOT NULL,
+  `LV` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `HP` int(9) UNSIGNED NOT NULL DEFAULT '0',
+  `SP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `EXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `JEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Range1` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK1` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `ATK2` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MDEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `STR` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `AGI` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `VIT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `INT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `DEX` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `LUK` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Range2` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Range3` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `dMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `MEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `MVP3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop4per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop5per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop6per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop7per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop8per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `Drop9per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardid` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `DropCardper` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM;
 
-#  Monster Database
-# 
-#  Structure of Database :
-# REPLACE INTO `mob_db` VALUES ( ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
-#  Note: Keep the Sprite_Name field as it is in the game client.
+-- Monster Database
+--
+-- Structure of Database :
+-- REPLACE INTO `mob_db` VALUES (ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
+-- Note: Keep the Sprite_Name field as it is in the game client.
 REPLACE INTO `mob_db` VALUES (1001,'SCORPION','Scorpion','Scorpion',16,153,1,108,81,1,33,40,16,5,12,15,10,5,19,5,10,12,0,4,23,0x3191,200,1564,864,576,0,0,0,0,0,0,0,990,70,904,5500,757,57,943,210,7041,100,508,200,625,20,0,0,0,0,4068,1);
 REPLACE INTO `mob_db` VALUES (1002,'PORING','Poring','Poring',1,60,1,27,20,1,8,9,2,5,6,1,1,0,6,5,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,1);
 # REPLACE INTO `mob_db` VALUES (1003,'TESTEGG','Test Egg','Test Egg',2,100000,0,10,10,0,3,9,99,0,1,99,1,1,1,1,10,12,0,4,22,0x0,512,0,512,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
diff --git a/sql-files/mob_skill_db.sql b/sql-files/mob_skill_db.sql
index 30e845d83..b240711cb 100644
--- a/sql-files/mob_skill_db.sql
+++ b/sql-files/mob_skill_db.sql
@@ -1,93 +1,93 @@
-#
-# Table structure for table `mob_skill_db`
-#
+--
+-- Table structure for table `mob_skill_db`
+--
 
 DROP TABLE IF EXISTS `mob_skill_db`;
 CREATE TABLE IF NOT EXISTS `mob_skill_db` (
-  `MOB_ID` smallint(6) NOT NULL,
-  `INFO` text NOT NULL,
-  `STATE` text NOT NULL,
-  `SKILL_ID` smallint(6) NOT NULL,
-  `SKILL_LV` tinyint(4) NOT NULL,
-  `RATE` smallint(4) NOT NULL,
-  `CASTTIME` mediumint(9) NOT NULL,
-  `DELAY` int(9) NOT NULL,
-  `CANCELABLE` text NOT NULL,
-  `TARGET` text NOT NULL,
-  `CONDITION` text NOT NULL,
-  `CONDITION_VALUE` text,
-  `VAL1` mediumint(9) DEFAULT NULL,
-  `VAL2` mediumint(9) DEFAULT NULL,
-  `VAL3` mediumint(9) DEFAULT NULL,
-  `VAL4` mediumint(9) DEFAULT NULL,
-  `VAL5` mediumint(9) DEFAULT NULL,
-  `EMOTION` text,
-  `CHAT` text
+  `MOB_ID` SMALLINT(6) NOT NULL,
+  `INFO` TEXT NOT NULL,
+  `STATE` TEXT NOT NULL,
+  `SKILL_ID` SMALLINT(6) NOT NULL,
+  `SKILL_LV` TINYINT(4) NOT NULL,
+  `RATE` SMALLINT(4) NOT NULL,
+  `CASTTIME` MEDIUMINT(9) NOT NULL,
+  `DELAY` INT(9) NOT NULL,
+  `CANCELABLE` TEXT NOT NULL,
+  `TARGET` TEXT NOT NULL,
+  `CONDITION` TEXT NOT NULL,
+  `CONDITION_VALUE` TEXT,
+  `VAL1` MEDIUMINT(9) DEFAULT NULL,
+  `VAL2` MEDIUMINT(9) DEFAULT NULL,
+  `VAL3` MEDIUMINT(9) DEFAULT NULL,
+  `VAL4` MEDIUMINT(9) DEFAULT NULL,
+  `VAL5` MEDIUMINT(9) DEFAULT NULL,
+  `EMOTION` TEXT,
+  `CHAT` TEXT
 ) ENGINE=MyISAM;
 
-# Based on Aegis Episode 11.3
-#
-# REPLACE INTO `mob_skill_db` VALUES (MOB_ID,'dummy value (info only)','STATE',SKILL_ID,SKILL_LV,rate (10000 = 100%),casttime,delay,'cancelable','target','condition type','condition value',val1,val2,val3,val4,val5,'emotion','chat');
-#Example
-#1001,Poring@TF_POISON,attack,52,3,100,1500,10000,no,target,always,0,,,,,7,
-#
-#rate refers to the chance of the skill being casted when the condition is fulfilled.
-#delay is the time in milliseconds that has to be pass before recasting the same skill.
-#
-#STATE:
-# any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
-# loot /attack / angry (like attack, except player has not attacked mob yet) /
-# chase (following target, after being attacked) / follow (following
-# target, without being attacked)
-# anytarget (attack+angry+chase+follow)
-#
-#target: The target of the skill can be: target (current target) / self / friend /
-# master / randomtarget (any enemy within skill's range)
-# (the following are for ground-skills, a random target tile is selected from
-# the specified area):
-# around1 (3x3 area around self) / around2 (5x5 area around self) /
-# around3 (7x7 area around self) / around4 (9x9 area around self) /
-# around5 (3x3 area around target) / around6 (5x5 area around target) /
-# around7 (7x7 area around target) / around8 (9x9 area around target) /
-# around = around4
-#
-#conditions: (condition type) (value which specifies a condition value)
-#	always			unconditional
-#	onspawn			when the mob spawns/respawns.
-#	myhpltmaxrate		when the mob's hp drops to a certain %
-#	myhpinrate		when the mob's hp is in a certain % range ('a condition value'
-#                is the lower cap, while 'a value 1' is the upper cap).
-#	mystatuson		If the mob has any abnormalities in status (condition value)
-#	mystatusoff		If the mob has ended any abnormalities in status (condition value)
-#	friendhpltmaxrate	when the mob's friend's hp drops to a certain %
-#	friendhpinrate		when the mob's friend's hp is in a certain % range (range
-#                   defined the same way as in myhpinrate)
-#	friendstatuson		If the friend has any abnormalities in status (condition value)
-#	friendstatusoff		If the friend has ended any abnormalities in status (condition value)
-#	attackpcgt		Attack PC becomes more than the  number of specification
-#	attackpcge		Attack PC becomes equal or more than the number of specification.
-#	slavelt			when the number of slaves is lower than the original number of specification.
-#	slavele			when the number of slaves is lower or equal than the original number of specification.
-#	closedattacked		when melee attacked (close range attack)
-#	longrangeattacked	when long ranged attacked (like bows and far range weapons)
-#	skillused		when a skill is used on the mob
-#	afterskill		after the mob used certain skill.
-#	casttargeted		when a target is in cast range.
-#	rudeattacked		when a target is rude attacked
-#
-# The character's state which can be specified to be a condition value by the statuson/statusoff system
-#	anybad		any type of state change
-#	stone		condition of being in stone state
-#	freeze		condition of being in frozen state
-#	stun		condition of being in stunned state
-#	sleep		condition of being in sleep state
-#	poison		condition of being in poisoned state
-#	curse		condition of being in cursed state
-#	silence		condition of being in silenced state
-#	confusion	condition of being in confusion state
-#	blind		condition of being in blind state
-#	hiding		condition of being in hidden state
-#	sight		condition of being in unhidden state
+-- Based on Aegis Episode 11.3
+--
+-- REPLACE INTO `mob_skill_db` VALUES (MOB_ID,'dummy value (info only)','STATE',SKILL_ID,SKILL_LV,rate (10000 = 100%),casttime,delay,'cancelable','target','condition type','condition value',val1,val2,val3,val4,val5,'emotion','chat');
+-- Example
+-- 1001,Poring@TF_POISON,attack,52,3,100,1500,10000,no,target,always,0,,,,,7,
+--
+-- rate refers to the chance of the skill being casted when the condition is fulfilled.
+-- delay is the time in milliseconds that has to be pass before recasting the same skill.
+-- 
+-- STATE:
+--  any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
+--  loot /attack / angry (like attack, except player has not attacked mob yet) /
+--  chase (following target, after being attacked) / follow (following
+--  target, without being attacked)
+--  anytarget (attack+angry+chase+follow)
+-- 
+-- target: The target of the skill can be: target (current target) / self / friend /
+--  master / randomtarget (any enemy within skill's range)
+--  (the following are for ground-skills, a random target tile is selected from
+--  the specified area):
+--  around1 (3x3 area around self) / around2 (5x5 area around self) /
+--  around3 (7x7 area around self) / around4 (9x9 area around self) /
+--  around5 (3x3 area around target) / around6 (5x5 area around target) /
+--  around7 (7x7 area around target) / around8 (9x9 area around target) /
+--  around = around4
+-- 
+-- conditions: (condition type) (value which specifies a condition value)
+-- 	always			unconditional
+-- 	onspawn			when the mob spawns/respawns.
+-- 	myhpltmaxrate		when the mob's hp drops to a certain %
+-- 	myhpinrate		when the mob's hp is in a certain % range ('a condition value'
+--                 is the lower cap, while 'a value 1' is the upper cap).
+-- 	mystatuson		If the mob has any abnormalities in status (condition value)
+-- 	mystatusoff		If the mob has ended any abnormalities in status (condition value)
+-- 	friendhpltmaxrate	when the mob's friend's hp drops to a certain %
+-- 	friendhpinrate		when the mob's friend's hp is in a certain % range (range
+--                    defined the same way as in myhpinrate)
+-- 	friendstatuson		If the friend has any abnormalities in status (condition value)
+-- 	friendstatusoff		If the friend has ended any abnormalities in status (condition value)
+-- 	attackpcgt		Attack PC becomes more than the  number of specification
+-- 	attackpcge		Attack PC becomes equal or more than the number of specification.
+-- 	slavelt			when the number of slaves is lower than the original number of specification.
+-- 	slavele			when the number of slaves is lower or equal than the original number of specification.
+-- 	closedattacked		when melee attacked (close range attack)
+-- 	longrangeattacked	when long ranged attacked (like bows and far range weapons)
+-- 	skillused		when a skill is used on the mob
+-- 	afterskill		after the mob used certain skill.
+-- 	casttargeted		when a target is in cast range.
+-- 	rudeattacked		when a target is rude attacked
+-- 
+--  The character's state which can be specified to be a condition value by the statuson/statusoff system
+-- 	anybad		any type of state change
+-- 	stone		condition of being in stone state
+-- 	freeze		condition of being in frozen state
+-- 	stun		condition of being in stunned state
+-- 	sleep		condition of being in sleep state
+-- 	poison		condition of being in poisoned state
+-- 	curse		condition of being in cursed state
+-- 	silence		condition of being in silenced state
+-- 	confusion	condition of being in confusion state
+-- 	blind		condition of being in blind state
+-- 	hiding		condition of being in hidden state
+-- 	sight		condition of being in unhidden state
 
 REPLACE INTO `mob_skill_db` VALUES (1001,'Scorpion@NPC_FIREATTACK','attack',186,1,2000,0,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 REPLACE INTO `mob_skill_db` VALUES (1001,'Scorpion@NPC_POISON','attack',176,3,500,800,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql-files/mob_skill_db2.sql b/sql-files/mob_skill_db2.sql
index b44ad3225..0df6e8de5 100644
--- a/sql-files/mob_skill_db2.sql
+++ b/sql-files/mob_skill_db2.sql
@@ -1,35 +1,35 @@
-#
-#  Table structure for table `mob_skill_db2`
-#
+--
+-- Table structure for table `mob_skill_db2`
+--
 
 DROP TABLE IF EXISTS `mob_skill_db2`;
 CREATE TABLE IF NOT EXISTS `mob_skill_db2` (
-  `MOB_ID` smallint(6) NOT NULL,
-  `INFO` text NOT NULL,
-  `STATE` text NOT NULL,
-  `SKILL_ID` smallint(6) NOT NULL,
+  `MOB_ID` SMALLINT(6) NOT NULL,
+  `INFO` TEXT NOT NULL,
+  `STATE` TEXT NOT NULL,
+  `SKILL_ID` SMALLINT(6) NOT NULL,
   `SKILL_LV` tinyint(4) NOT NULL,
-  `RATE` smallint(4) NOT NULL,
-  `CASTTIME` mediumint(9) NOT NULL,
-  `DELAY` int(9) NOT NULL,
-  `CANCELABLE` text NOT NULL,
-  `TARGET` text NOT NULL,
-  `CONDITION` text NOT NULL,
-  `CONDITION_VALUE` text,
-  `VAL1` mediumint(9) DEFAULT NULL,
-  `VAL2` mediumint(9) DEFAULT NULL,
-  `VAL3` mediumint(9) DEFAULT NULL,
-  `VAL4` mediumint(9) DEFAULT NULL,
-  `VAL5` mediumint(9) DEFAULT NULL,
-  `EMOTION` text,
-  `CHAT` text
+  `RATE` SMALLINT(4) NOT NULL,
+  `CASTTIME` MEDIUMINT(9) NOT NULL,
+  `DELAY` INT(9) NOT NULL,
+  `CANCELABLE` TEXT NOT NULL,
+  `TARGET` TEXT NOT NULL,
+  `CONDITION` TEXT NOT NULL,
+  `CONDITION_VALUE` TEXT,
+  `VAL1` MEDIUMINT(9) DEFAULT NULL,
+  `VAL2` MEDIUMINT(9) DEFAULT NULL,
+  `VAL3` MEDIUMINT(9) DEFAULT NULL,
+  `VAL4` MEDIUMINT(9) DEFAULT NULL,
+  `VAL5` MEDIUMINT(9) DEFAULT NULL,
+  `EMOTION` TEXT,
+  `CHAT` TEXT
 ) ENGINE=MyISAM;
 
-#  Mob Skill Database
-# 
-#  Structure of Database:
-#  INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`);
-#
+-- Mob Skill Database
+-- 
+-- Structure of Database:
+-- INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`);
+
 # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "walk", 26, 1, 500, 0, 5000, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@KN_BRANDISHSPEAR", "attack", 57, 10, 2000, 500, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
diff --git a/sql-files/mob_skill_db_re.sql b/sql-files/mob_skill_db_re.sql
index 41d690503..8810ef1e5 100644
--- a/sql-files/mob_skill_db_re.sql
+++ b/sql-files/mob_skill_db_re.sql
@@ -1,93 +1,93 @@
-#
-# Table structure for table `mob_skill_db`
-#
+--
+-- Table structure for table `mob_skill_db`
+--
 
 DROP TABLE IF EXISTS `mob_skill_db`;
 CREATE TABLE IF NOT EXISTS `mob_skill_db` (
-  `MOB_ID` smallint(6) NOT NULL,
-  `INFO` text NOT NULL,
-  `STATE` text NOT NULL,
-  `SKILL_ID` smallint(6) NOT NULL,
-  `SKILL_LV` tinyint(4) NOT NULL,
-  `RATE` smallint(4) NOT NULL,
-  `CASTTIME` mediumint(9) NOT NULL,
-  `DELAY` int(9) NOT NULL,
-  `CANCELABLE` text NOT NULL,
-  `TARGET` text NOT NULL,
-  `CONDITION` text NOT NULL,
-  `CONDITION_VALUE` text,
-  `VAL1` mediumint(9) DEFAULT NULL,
-  `VAL2` mediumint(9) DEFAULT NULL,
-  `VAL3` mediumint(9) DEFAULT NULL,
-  `VAL4` mediumint(9) DEFAULT NULL,
-  `VAL5` mediumint(9) DEFAULT NULL,
-  `EMOTION` text,
-  `CHAT` text
+  `MOB_ID` SMALLINT(6) NOT NULL,
+  `INFO` TEXT NOT NULL,
+  `STATE` TEXT NOT NULL,
+  `SKILL_ID` SMALLINT(6) NOT NULL,
+  `SKILL_LV` TINYINT(4) NOT NULL,
+  `RATE` SMALLINT(4) NOT NULL,
+  `CASTTIME` MEDIUMINT(9) NOT NULL,
+  `DELAY` INT(9) NOT NULL,
+  `CANCELABLE` TEXT NOT NULL,
+  `TARGET` TEXT NOT NULL,
+  `CONDITION` TEXT NOT NULL,
+  `CONDITION_VALUE` TEXT,
+  `VAL1` MEDIUMINT(9) DEFAULT NULL,
+  `VAL2` MEDIUMINT(9) DEFAULT NULL,
+  `VAL3` MEDIUMINT(9) DEFAULT NULL,
+  `VAL4` MEDIUMINT(9) DEFAULT NULL,
+  `VAL5` MEDIUMINT(9) DEFAULT NULL,
+  `EMOTION` TEXT,
+  `CHAT` TEXT
 ) ENGINE=MyISAM;
 
-# Based on Aegis Episode 11.3
-#
-# REPLACE INTO `mob_skill_db` VALUES (MOB_ID,'dummy value (info only)','STATE',SKILL_ID,SKILL_LV,rate (10000 = 100%),casttime,delay,'cancelable','target','condition type','condition value',val1,val2,val3,val4,val5,'emotion','chat');
-#Example
-#1001,Poring@TF_POISON,attack,52,3,100,1500,10000,no,target,always,0,,,,,7,
-#
-#rate refers to the chance of the skill being casted when the condition is fulfilled.
-#delay is the time in milliseconds that has to be pass before recasting the same skill.
-#
-#STATE:
-# any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
-# loot /attack / angry (like attack, except player has not attacked mob yet) /
-# chase (following target, after being attacked) / follow (following
-# target, without being attacked)
-# anytarget (attack+angry+chase+follow)
-#
-#target: The target of the skill can be: target (current target) / self / friend /
-# master / randomtarget (any enemy within skill's range)
-# (the following are for ground-skills, a random target tile is selected from
-# the specified area):
-# around1 (3x3 area around self) / around2 (5x5 area around self) /
-# around3 (7x7 area around self) / around4 (9x9 area around self) /
-# around5 (3x3 area around target) / around6 (5x5 area around target) /
-# around7 (7x7 area around target) / around8 (9x9 area around target) /
-# around = around4
-#
-#conditions: (condition type) (value which specifies a condition value)
-#	always			unconditional
-#	onspawn			when the mob spawns/respawns.
-#	myhpltmaxrate		when the mob's hp drops to a certain %
-#	myhpinrate		when the mob's hp is in a certain % range ('a condition value'
-#                is the lower cap, while 'a value 1' is the upper cap).
-#	mystatuson		If the mob has any abnormalities in status (condition value)
-#	mystatusoff		If the mob has ended any abnormalities in status (condition value)
-#	friendhpltmaxrate	when the mob's friend's hp drops to a certain %
-#	friendhpinrate		when the mob's friend's hp is in a certain % range (range
-#                   defined the same way as in myhpinrate)
-#	friendstatuson		If the friend has any abnormalities in status (condition value)
-#	friendstatusoff		If the friend has ended any abnormalities in status (condition value)
-#	attackpcgt		Attack PC becomes more than the  number of specification
-#	attackpcge		Attack PC becomes equal or more than the number of specification.
-#	slavelt			when the number of slaves is lower than the original number of specification.
-#	slavele			when the number of slaves is lower or equal than the original number of specification.
-#	closedattacked		when melee attacked (close range attack)
-#	longrangeattacked	when long ranged attacked (like bows and far range weapons)
-#	skillused		when a skill is used on the mob
-#	afterskill		after the mob used certain skill.
-#	casttargeted		when a target is in cast range.
-#	rudeattacked		when a target is rude attacked
-#
-# The character's state which can be specified to be a condition value by the statuson/statusoff system
-#	anybad		any type of state change
-#	stone		condition of being in stone state
-#	freeze		condition of being in frozen state
-#	stun		condition of being in stunned state
-#	sleep		condition of being in sleep state
-#	poison		condition of being in poisoned state
-#	curse		condition of being in cursed state
-#	silence		condition of being in silenced state
-#	confusion	condition of being in confusion state
-#	blind		condition of being in blind state
-#	hiding		condition of being in hidden state
-#	sight		condition of being in unhidden state
+-- Based on Aegis Episode 11.3
+--
+-- REPLACE INTO `mob_skill_db` VALUES (MOB_ID,'dummy value (info only)','STATE',SKILL_ID,SKILL_LV,rate (10000 = 100%),casttime,delay,'cancelable','target','condition type','condition value',val1,val2,val3,val4,val5,'emotion','chat');
+-- Example
+-- 1001,Poring@TF_POISON,attack,52,3,100,1500,10000,no,target,always,0,,,,,7,
+-- 
+-- rate refers to the chance of the skill being casted when the condition is fulfilled.
+-- delay is the time in milliseconds that has to be pass before recasting the same skill.
+-- 
+-- STATE:
+--  any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
+--  loot /attack / angry (like attack, except player has not attacked mob yet) /
+--  chase (following target, after being attacked) / follow (following
+--  target, without being attacked)
+--  anytarget (attack+angry+chase+follow)
+-- 
+-- target: The target of the skill can be: target (current target) / self / friend /
+--  master / randomtarget (any enemy within skill's range)
+--  (the following are for ground-skills, a random target tile is selected from
+--  the specified area):
+--  around1 (3x3 area around self) / around2 (5x5 area around self) /
+--  around3 (7x7 area around self) / around4 (9x9 area around self) /
+--  around5 (3x3 area around target) / around6 (5x5 area around target) /
+--  around7 (7x7 area around target) / around8 (9x9 area around target) /
+--  around = around4
+-- 
+-- conditions: (condition type) (value which specifies a condition value)
+-- 	always			unconditional
+-- 	onspawn			when the mob spawns/respawns.
+-- 	myhpltmaxrate		when the mob's hp drops to a certain %
+-- 	myhpinrate		when the mob's hp is in a certain % range ('a condition value'
+--                 is the lower cap, while 'a value 1' is the upper cap).
+-- 	mystatuson		If the mob has any abnormalities in status (condition value)
+-- 	mystatusoff		If the mob has ended any abnormalities in status (condition value)
+-- 	friendhpltmaxrate	when the mob's friend's hp drops to a certain %
+-- 	friendhpinrate		when the mob's friend's hp is in a certain % range (range
+--                    defined the same way as in myhpinrate)
+-- 	friendstatuson		If the friend has any abnormalities in status (condition value)
+-- 	friendstatusoff		If the friend has ended any abnormalities in status (condition value)
+-- 	attackpcgt		Attack PC becomes more than the  number of specification
+-- 	attackpcge		Attack PC becomes equal or more than the number of specification.
+-- 	slavelt			when the number of slaves is lower than the original number of specification.
+-- 	slavele			when the number of slaves is lower or equal than the original number of specification.
+-- 	closedattacked		when melee attacked (close range attack)
+-- 	longrangeattacked	when long ranged attacked (like bows and far range weapons)
+-- 	skillused		when a skill is used on the mob
+-- 	afterskill		after the mob used certain skill.
+-- 	casttargeted		when a target is in cast range.
+-- 	rudeattacked		when a target is rude attacked
+-- 
+--  The character's state which can be specified to be a condition value by the statuson/statusoff system
+-- 	anybad		any type of state change
+-- 	stone		condition of being in stone state
+-- 	freeze		condition of being in frozen state
+-- 	stun		condition of being in stunned state
+-- 	sleep		condition of being in sleep state
+-- 	poison		condition of being in poisoned state
+-- 	curse		condition of being in cursed state
+-- 	silence		condition of being in silenced state
+-- 	confusion	condition of being in confusion state
+-- 	blind		condition of being in blind state
+-- 	hiding		condition of being in hidden state
+--	sight		condition of being in unhidden state
 
 REPLACE INTO `mob_skill_db` VALUES (1001,'Scorpion@NPC_FIREATTACK','attack',186,1,2000,0,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 REPLACE INTO `mob_skill_db` VALUES (1001,'Scorpion@NPC_POISON','attack',176,3,500,800,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);