summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHaru <haru@dotalux.com>2019-12-15 15:27:01 +0100
committerGitHub <noreply@github.com>2019-12-15 15:27:01 +0100
commitf7dcf124a3115c5398774b80b90d43d650344022 (patch)
treec96df8e17aa9c3f64382b6425b6011ade6e6ee4a /sql-files
parent3c5540b9e9f09943a8cc2fd294035a5ccaf63f5e (diff)
parenta14968850fb2474b29552db21d63d0bb303e73d1 (diff)
downloadhercules-f7dcf124a3115c5398774b80b90d43d650344022.tar.gz
hercules-f7dcf124a3115c5398774b80b90d43d650344022.tar.bz2
hercules-f7dcf124a3115c5398774b80b90d43d650344022.tar.xz
hercules-f7dcf124a3115c5398774b80b90d43d650344022.zip
Merge pull request #2580 from Asheraf/winmariadbconnector
Replace the windows mysql connector with MariaDB C Connector
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/logs.sql90
-rw-r--r--sql-files/main.sql974
2 files changed, 532 insertions, 532 deletions
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 6eb78bb07..ee268a2f7 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;
@@ -941,81 +941,81 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1574463539); -- 2019-11-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`),
@@ -1026,9 +1026,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;