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