diff options
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 1080 |
1 files changed, 540 insertions, 540 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 9c2c1ca43..22cba1660 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -1,51 +1,114 @@ -- +-- +-- Table structure for table `account_data` + +CREATE TABLE IF NOT EXISTS `account_data` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `bank_vault` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100', + `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100', + `base_death` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100', + PRIMARY KEY (`account_id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `acc_reg_num_db` +-- + +CREATE TABLE IF NOT EXISTS `acc_reg_num_db` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`account_id`,`key`,`index`), + KEY `account_id` (`account_id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `acc_reg_str_db` +-- + +CREATE TABLE IF NOT EXISTS `acc_reg_str_db` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` VARCHAR(254) NOT NULL DEFAULT '0', + PRIMARY KEY (`account_id`,`key`,`index`), + KEY `account_id` (`account_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `auction` -- CREATE TABLE IF NOT EXISTS `auction` ( - `auction_id` bigint(20) unsigned NOT NULL auto_increment, - `seller_id` int(11) unsigned NOT NULL default '0', - `seller_name` varchar(30) NOT NULL default '', - `buyer_id` int(11) unsigned NOT NULL default '0', - `buyer_name` varchar(30) NOT NULL default '', - `price` int(11) unsigned NOT NULL default '0', - `buynow` int(11) unsigned NOT NULL default '0', - `hours` smallint(6) NOT NULL default '0', - `timestamp` int(11) unsigned NOT NULL default '0', - `nameid` int(11) unsigned NOT NULL default '0', - `item_name` varchar(50) NOT NULL default '', - `type` smallint(6) NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) unsigned NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`auction_id`) + `auction_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + `seller_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `seller_name` VARCHAR(30) NOT NULL DEFAULT '', + `buyer_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `buyer_name` VARCHAR(30) NOT NULL DEFAULT '', + `price` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `buynow` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `hours` SMALLINT(6) NOT NULL DEFAULT '0', + `timestamp` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `item_name` VARCHAR(50) NOT NULL DEFAULT '', + `type` SMALLINT(6) NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; -- +-- Table structure for table `autotrade_data` +-- + +CREATE TABLE IF NOT EXISTS `autotrade_data` ( + `char_id` INT(11) NOT NULL DEFAULT '0', + `itemkey` INT(11) NOT NULL DEFAULT '0', + `amount` INT(11) NOT NULL DEFAULT '0', + `price` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`itemkey`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `autotrade_merchants` +-- + +CREATE TABLE IF NOT EXISTS `autotrade_merchants` ( + `account_id` INT(11) NOT NULL DEFAULT '0', + `char_id` INT(11) NOT NULL DEFAULT '0', + `sex` TINYINT(2) NOT NULL DEFAULT '0', + `title` VARCHAR(80) NOT NULL DEFAULT 'Buy From Me!', + PRIMARY KEY (`account_id`,`char_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `cart_inventory` -- CREATE TABLE IF NOT EXISTS `cart_inventory` ( - `id` int(11) NOT NULL auto_increment, - `char_id` int(11) NOT NULL default '0', - `nameid` int(11) NOT NULL default '0', - `amount` int(11) NOT NULL default '0', - `equip` int(11) unsigned NOT NULL default '0', - `identify` smallint(6) NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `expire_time` int(11) unsigned NOT NULL default '0', - `bound` tinyint(1) unsigned NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), + `id` INT(11) NOT NULL AUTO_INCREMENT, + `char_id` INT(11) NOT NULL DEFAULT '0', + `nameid` INT(11) NOT NULL DEFAULT '0', + `amount` INT(11) NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -54,65 +117,65 @@ CREATE TABLE IF NOT EXISTS `cart_inventory` ( -- CREATE TABLE IF NOT EXISTS `char` ( - `char_id` int(11) unsigned NOT NULL auto_increment, - `account_id` int(11) unsigned NOT NULL default '0', - `char_num` tinyint(1) NOT NULL default '0', - `name` varchar(30) NOT NULL DEFAULT '', - `class` smallint(6) unsigned NOT NULL default '0', - `base_level` smallint(6) unsigned NOT NULL default '1', - `job_level` smallint(6) unsigned NOT NULL default '1', - `base_exp` bigint(20) unsigned NOT NULL default '0', - `job_exp` bigint(20) unsigned NOT NULL default '0', - `zeny` int(11) unsigned NOT NULL default '0', - `str` smallint(4) unsigned NOT NULL default '0', - `agi` smallint(4) unsigned NOT NULL default '0', - `vit` smallint(4) unsigned NOT NULL default '0', - `int` smallint(4) unsigned NOT NULL default '0', - `dex` smallint(4) unsigned NOT NULL default '0', - `luk` smallint(4) unsigned NOT NULL default '0', - `max_hp` mediumint(8) unsigned NOT NULL default '0', - `hp` mediumint(8) unsigned NOT NULL default '0', - `max_sp` mediumint(6) unsigned NOT NULL default '0', - `sp` mediumint(6) unsigned NOT NULL default '0', - `status_point` int(11) unsigned NOT NULL default '0', - `skill_point` int(11) unsigned NOT NULL default '0', - `option` int(11) NOT NULL default '0', - `karma` tinyint(3) NOT NULL default '0', - `manner` smallint(6) NOT NULL default '0', - `party_id` int(11) unsigned NOT NULL default '0', - `guild_id` int(11) unsigned NOT NULL default '0', - `pet_id` int(11) unsigned NOT NULL default '0', - `homun_id` int(11) unsigned NOT NULL default '0', - `elemental_id` int(11) unsigned NOT NULL default '0', - `hair` tinyint(4) unsigned NOT NULL default '0', - `hair_color` smallint(5) unsigned NOT NULL default '0', - `clothes_color` smallint(5) unsigned NOT NULL default '0', - `weapon` smallint(6) unsigned NOT NULL default '0', - `shield` smallint(6) unsigned NOT NULL default '0', - `head_top` smallint(6) unsigned NOT NULL default '0', - `head_mid` smallint(6) unsigned NOT NULL default '0', - `head_bottom` smallint(6) unsigned NOT NULL default '0', + `char_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_num` TINYINT(1) NOT NULL DEFAULT '0', + `name` VARCHAR(30) NOT NULL DEFAULT '', + `class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `base_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1', + `job_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1', + `base_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `job_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `INT` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `max_hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `status_point` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `skill_point` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `option` INT(11) NOT NULL DEFAULT '0', + `karma` TINYINT(3) NOT NULL DEFAULT '0', + `manner` SMALLINT(6) NOT NULL DEFAULT '0', + `party_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `pet_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `homun_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `elemental_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `hair` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `hair_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `clothes_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `shield` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `head_top` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `head_mid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `head_bottom` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', - `last_map` varchar(11) NOT NULL default '', - `last_x` smallint(4) unsigned NOT NULL default '53', - `last_y` smallint(4) unsigned NOT NULL default '111', - `save_map` varchar(11) NOT NULL default '', - `save_x` smallint(4) unsigned NOT NULL default '53', - `save_y` smallint(4) unsigned NOT NULL default '111', - `partner_id` int(11) unsigned NOT NULL default '0', - `online` tinyint(2) NOT NULL default '0', - `father` int(11) unsigned NOT NULL default '0', - `mother` int(11) unsigned NOT NULL default '0', - `child` int(11) unsigned NOT NULL default '0', - `fame` int(11) unsigned NOT NULL default '0', - `rename` SMALLINT(3) unsigned NOT NULL default '0', - `delete_date` INT(11) unsigned NOT NULL DEFAULT '0', - `slotchange` SMALLINT(3) unsigned NOT NULL default '0', - `char_opt` INT( 11 ) unsigned NOT NULL default '0', - `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0', - `unban_time` int(11) unsigned NOT NULL default '0', - `uniqueitem_counter` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`char_id`), + `last_map` VARCHAR(11) NOT NULL DEFAULT '', + `last_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53', + `last_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111', + `save_map` VARCHAR(11) NOT NULL DEFAULT '', + `save_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53', + `save_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111', + `partner_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `online` TINYINT(2) NOT NULL DEFAULT '0', + `father` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `mother` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `child` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `fame` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `rename` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0', + `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `slotchange` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0', + `char_opt` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`), UNIQUE KEY `name_key` (`name`), KEY `account_id` (`account_id`), KEY `party_id` (`party_id`), @@ -121,24 +184,50 @@ CREATE TABLE IF NOT EXISTS `char` ( ) ENGINE=MyISAM AUTO_INCREMENT=150000; -- +-- Table structure for table `char_reg_num_db` +-- + +CREATE TABLE IF NOT EXISTS `char_reg_num_db` ( + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`key`,`index`), + KEY `char_id` (`char_id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `char_reg_str_db` +-- + +CREATE TABLE IF NOT EXISTS `char_reg_str_db` ( + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` VARCHAR(254) NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`key`,`index`), + KEY `char_id` (`char_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `charlog` -- CREATE TABLE IF NOT EXISTS `charlog` ( - `time` datetime NOT NULL default '0000-00-00 00:00:00', - `char_msg` varchar(255) NOT NULL default 'char select', - `account_id` int(11) NOT NULL default '0', - `char_id` int(11) unsigned NOT NULL default '0', - `char_num` tinyint(4) NOT NULL default '0', - `name` varchar(23) NOT NULL default '', - `str` int(11) unsigned NOT NULL default '0', - `agi` int(11) unsigned NOT NULL default '0', - `vit` int(11) unsigned NOT NULL default '0', - `int` int(11) unsigned NOT NULL default '0', - `dex` int(11) unsigned NOT NULL default '0', - `luk` int(11) unsigned NOT NULL default '0', - `hair` tinyint(4) NOT NULL default '0', - `hair_color` int(11) NOT NULL default '0' + `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select', + `account_id` INT(11) NOT NULL DEFAULT '0', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_num` TINYINT(4) NOT NULL DEFAULT '0', + `name` VARCHAR(23) NOT NULL DEFAULT '', + `str` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `agi` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `vit` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `INT` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `dex` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `luk` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `hair` TINYINT(4) NOT NULL DEFAULT '0', + `hair_color` INT(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM; -- @@ -146,24 +235,24 @@ CREATE TABLE IF NOT EXISTS `charlog` ( -- CREATE TABLE IF NOT EXISTS `elemental` ( - `ele_id` int(11) unsigned NOT NULL auto_increment, - `char_id` int(11) NOT NULL, - `class` mediumint(9) unsigned NOT NULL default '0', - `mode` int(11) unsigned NOT NULL default '1', - `hp` int(12) NOT NULL default '1', - `sp` int(12) NOT NULL default '1', - `max_hp` mediumint(8) unsigned NOT NULL default '0', - `max_sp` mediumint(6) unsigned NOT NULL default '0', - `atk1` MEDIUMINT(6) unsigned NOT NULL default '0', - `atk2` MEDIUMINT(6) unsigned NOT NULL default '0', - `matk` MEDIUMINT(6) unsigned NOT NULL default '0', - `aspd` smallint(4) unsigned NOT NULL default '0', - `def` smallint(4) unsigned NOT NULL default '0', - `mdef` smallint(4) unsigned NOT NULL default '0', - `flee` smallint(4) unsigned NOT NULL default '0', - `hit` smallint(4) unsigned NOT NULL default '0', - `life_time` int(11) NOT NULL default '0', - PRIMARY KEY (`ele_id`) + `ele_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `char_id` INT(11) NOT NULL, + `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `mode` INT(11) UNSIGNED NOT NULL DEFAULT '1', + `hp` INT(12) NOT NULL DEFAULT '1', + `sp` INT(12) NOT NULL DEFAULT '1', + `max_hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0', + `aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `life_time` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ele_id`) ) ENGINE=MyISAM; -- @@ -171,9 +260,9 @@ CREATE TABLE IF NOT EXISTS `elemental` ( -- CREATE TABLE IF NOT EXISTS `friends` ( - `char_id` int(11) NOT NULL default '0', - `friend_account` int(11) NOT NULL default '0', - `friend_id` int(11) NOT NULL default '0', + `char_id` INT(11) NOT NULL DEFAULT '0', + `friend_account` INT(11) NOT NULL DEFAULT '0', + `friend_id` INT(11) NOT NULL DEFAULT '0', KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -183,35 +272,61 @@ CREATE TABLE IF NOT EXISTS `friends` ( CREATE TABLE IF NOT EXISTS `hotkey` ( `char_id` INT(11) NOT NULL, - `hotkey` TINYINT(2) unsigned NOT NULL, - `type` TINYINT(1) unsigned NOT NULL default '0', - `itemskill_id` INT(11) unsigned NOT NULL default '0', - `skill_lvl` TINYINT(4) unsigned NOT NULL default '0', + `hotkey` TINYINT(2) UNSIGNED NOT NULL, + `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `itemskill_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `skill_lvl` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM; -- +-- Table structure for table `global_acc_reg_num_db` +-- + +CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`account_id`,`key`,`index`), + KEY `account_id` (`account_id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `global_acc_reg_str_db` +-- + +CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` VARCHAR(254) NOT NULL DEFAULT '0', + PRIMARY KEY (`account_id`,`key`,`index`), + KEY `account_id` (`account_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `guild` -- CREATE TABLE IF NOT EXISTS `guild` ( - `guild_id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(24) NOT NULL default '', - `char_id` int(11) unsigned NOT NULL default '0', - `master` varchar(24) NOT NULL default '', - `guild_lv` tinyint(6) unsigned NOT NULL default '0', - `connect_member` tinyint(6) unsigned NOT NULL default '0', - `max_member` tinyint(6) unsigned NOT NULL default '0', - `average_lv` smallint(6) unsigned NOT NULL default '1', - `exp` bigint(20) unsigned NOT NULL default '0', - `next_exp` int(11) unsigned NOT NULL default '0', - `skill_point` tinyint(11) unsigned NOT NULL default '0', - `mes1` varchar(60) NOT NULL default '', - `mes2` varchar(120) NOT NULL default '', - `emblem_len` int(11) unsigned NOT NULL default '0', - `emblem_id` int(11) unsigned NOT NULL default '0', + `guild_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `name` VARCHAR(24) NOT NULL DEFAULT '', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `master` VARCHAR(24) NOT NULL DEFAULT '', + `guild_lv` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `connect_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `max_member` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `average_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1', + `exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `next_exp` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `skill_point` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + `mes1` VARCHAR(60) NOT NULL DEFAULT '', + `mes2` VARCHAR(120) NOT NULL DEFAULT '', + `emblem_len` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `emblem_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `emblem_data` blob, - PRIMARY KEY (`guild_id`,`char_id`), + PRIMARY KEY (`guild_id`,`char_id`), UNIQUE KEY `guild_id` (`guild_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -221,11 +336,11 @@ CREATE TABLE IF NOT EXISTS `guild` ( -- CREATE TABLE IF NOT EXISTS `guild_alliance` ( - `guild_id` int(11) unsigned NOT NULL default '0', - `opposition` int(11) unsigned NOT NULL default '0', - `alliance_id` int(11) unsigned NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - PRIMARY KEY (`guild_id`,`alliance_id`), + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `opposition` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `alliance_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + PRIMARY KEY (`guild_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; @@ -234,25 +349,25 @@ CREATE TABLE IF NOT EXISTS `guild_alliance` ( -- CREATE TABLE IF NOT EXISTS `guild_castle` ( - `castle_id` int(11) unsigned NOT NULL default '0', - `guild_id` int(11) unsigned NOT NULL default '0', - `economy` int(11) unsigned NOT NULL default '0', - `defense` int(11) unsigned NOT NULL default '0', - `triggerE` int(11) unsigned NOT NULL default '0', - `triggerD` int(11) unsigned NOT NULL default '0', - `nextTime` int(11) unsigned NOT NULL default '0', - `payTime` int(11) unsigned NOT NULL default '0', - `createTime` int(11) unsigned NOT NULL default '0', - `visibleC` int(11) unsigned NOT NULL default '0', - `visibleG0` int(11) unsigned NOT NULL default '0', - `visibleG1` int(11) unsigned NOT NULL default '0', - `visibleG2` int(11) unsigned NOT NULL default '0', - `visibleG3` int(11) unsigned NOT NULL default '0', - `visibleG4` int(11) unsigned NOT NULL default '0', - `visibleG5` int(11) unsigned NOT NULL default '0', - `visibleG6` int(11) unsigned NOT NULL default '0', - `visibleG7` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`castle_id`), + `castle_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `economy` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `defense` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `triggerE` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `triggerD` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nextTime` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `payTime` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `createTime` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleC` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG0` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG1` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG2` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG3` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG4` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG5` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG6` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `visibleG7` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`castle_id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; @@ -261,11 +376,11 @@ CREATE TABLE IF NOT EXISTS `guild_castle` ( -- CREATE TABLE IF NOT EXISTS `guild_expulsion` ( - `guild_id` int(11) unsigned NOT NULL default '0', - `account_id` int(11) unsigned NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - `mes` varchar(40) NOT NULL default '', - PRIMARY KEY (`guild_id`,`name`) + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + `mes` VARCHAR(40) NOT NULL DEFAULT '', + PRIMARY KEY (`guild_id`,`name`) ) ENGINE=MyISAM; -- @@ -273,20 +388,20 @@ CREATE TABLE IF NOT EXISTS `guild_expulsion` ( -- CREATE TABLE IF NOT EXISTS `guild_member` ( - `guild_id` int(11) unsigned NOT NULL default '0', - `account_id` int(11) unsigned NOT NULL default '0', - `char_id` int(11) unsigned NOT NULL default '0', - `hair` tinyint(6) unsigned NOT NULL default '0', - `hair_color` smallint(6) unsigned NOT NULL default '0', - `gender` tinyint(6) unsigned NOT NULL default '0', - `class` smallint(6) unsigned NOT NULL default '0', - `lv` smallint(6) unsigned NOT NULL default '0', - `exp` bigint(20) unsigned NOT NULL default '0', - `exp_payper` tinyint(11) unsigned NOT NULL default '0', - `online` tinyint(4) unsigned NOT NULL default '0', - `position` tinyint(6) unsigned NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - PRIMARY KEY (`guild_id`,`char_id`), + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `hair` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `hair_color` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `gender` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `exp_payper` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + `online` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + PRIMARY KEY (`guild_id`,`char_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -295,12 +410,12 @@ CREATE TABLE IF NOT EXISTS `guild_member` ( -- CREATE TABLE IF NOT EXISTS `guild_position` ( - `guild_id` int(9) unsigned NOT NULL default '0', - `position` tinyint(6) unsigned NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - `mode` tinyint(11) unsigned NOT NULL default '0', - `exp_mode` tinyint(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guild_id`,`position`) + `guild_id` INT(9) UNSIGNED NOT NULL DEFAULT '0', + `position` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + `mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + `exp_mode` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`guild_id`,`position`) ) ENGINE=MyISAM; -- @@ -308,10 +423,10 @@ CREATE TABLE IF NOT EXISTS `guild_position` ( -- CREATE TABLE IF NOT EXISTS `guild_skill` ( - `guild_id` int(11) unsigned NOT NULL default '0', - `id` smallint(11) unsigned NOT NULL default '0', - `lv` tinyint(11) unsigned NOT NULL default '0', - PRIMARY KEY (`guild_id`,`id`) + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `lv` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`guild_id`,`id`) ) ENGINE=MyISAM; -- @@ -319,22 +434,22 @@ CREATE TABLE IF NOT EXISTS `guild_skill` ( -- CREATE TABLE IF NOT EXISTS `guild_storage` ( - `id` int(10) unsigned NOT NULL auto_increment, - `guild_id` int(11) unsigned NOT NULL default '0', - `nameid` int(11) unsigned NOT NULL default '0', - `amount` int(11) unsigned NOT NULL default '0', - `equip` int(11) unsigned NOT NULL default '0', - `identify` smallint(6) unsigned NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) unsigned NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `expire_time` int(11) unsigned NOT NULL default '0', - `bound` tinyint(1) unsigned NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), + `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; @@ -343,63 +458,73 @@ CREATE TABLE IF NOT EXISTS `guild_storage` ( -- CREATE TABLE IF NOT EXISTS `homunculus` ( - `homun_id` int(11) NOT NULL auto_increment, - `char_id` int(11) NOT NULL, - `class` mediumint(9) unsigned NOT NULL default '0', - `prev_class` mediumint(9) NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - `level` smallint(4) NOT NULL default '0', - `exp` int(12) NOT NULL default '0', - `intimacy` int(12) NOT NULL default '0', - `hunger` smallint(4) NOT NULL default '0', - `str` smallint(4) unsigned NOT NULL default '0', - `agi` smallint(4) unsigned NOT NULL default '0', - `vit` smallint(4) unsigned NOT NULL default '0', - `int` smallint(4) unsigned NOT NULL default '0', - `dex` smallint(4) unsigned NOT NULL default '0', - `luk` smallint(4) unsigned NOT NULL default '0', - `hp` int(12) NOT NULL default '1', - `max_hp` int(12) NOT NULL default '1', - `sp` int(12) NOT NULL default '1', - `max_sp` int(12) NOT NULL default '1', - `skill_point` smallint(4) unsigned NOT NULL default '0', - `alive` tinyint(2) NOT NULL default '1', - `rename_flag` tinyint(2) NOT NULL default '0', - `vaporize` tinyint(2) NOT NULL default '0', - PRIMARY KEY (`homun_id`) + `homun_id` INT(11) NOT NULL AUTO_INCREMENT, + `char_id` INT(11) NOT NULL, + `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `prev_class` MEDIUMINT(9) NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + `level` SMALLINT(4) NOT NULL DEFAULT '0', + `exp` INT(12) NOT NULL DEFAULT '0', + `intimacy` INT(12) NOT NULL DEFAULT '0', + `hunger` SMALLINT(4) NOT NULL DEFAULT '0', + `str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `INT` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `hp` INT(12) NOT NULL DEFAULT '1', + `max_hp` INT(12) NOT NULL DEFAULT '1', + `sp` INT(12) NOT NULL DEFAULT '1', + `max_sp` INT(12) NOT NULL DEFAULT '1', + `skill_point` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `alive` TINYINT(2) NOT NULL DEFAULT '1', + `rename_flag` TINYINT(2) NOT NULL DEFAULT '0', + `vaporize` TINYINT(2) NOT NULL DEFAULT '0', + PRIMARY KEY (`homun_id`) ) ENGINE=MyISAM; -- --- Table structure for table `interlog` +-- Table structure for table `INTerlog` -- -CREATE TABLE IF NOT EXISTS `interlog` ( - `time` datetime NOT NULL default '0000-00-00 00:00:00', - `log` varchar(255) NOT NULL default '' +CREATE TABLE IF NOT EXISTS `INTerlog` ( + `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `log` VARCHAR(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM; -- +-- Table structure for table `INTerreg` +-- + +CREATE TABLE IF NOT EXISTS `interreg` ( + `varname` VARCHAR(11) NOT NULL, + `value` VARCHAR(20) NOT NULL, + PRIMARY KEY (`varname`) +) ENGINE=InnoDB; + +-- -- Table structure for table `inventory` -- CREATE TABLE IF NOT EXISTS `inventory` ( - `id` int(11) unsigned NOT NULL auto_increment, - `char_id` int(11) unsigned NOT NULL default '0', - `nameid` int(11) unsigned NOT NULL default '0', - `amount` int(11) unsigned NOT NULL default '0', - `equip` int(11) unsigned NOT NULL default '0', - `identify` smallint(6) NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) unsigned NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `expire_time` int(11) unsigned NOT NULL default '0', - `favorite` tinyint(3) unsigned NOT NULL default '0', - `bound` tinyint(1) unsigned NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -408,10 +533,10 @@ CREATE TABLE IF NOT EXISTS `inventory` ( -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( - `list` varchar(255) NOT NULL default '', - `btime` datetime NOT NULL default '0000-00-00 00:00:00', - `rtime` datetime NOT NULL default '0000-00-00 00:00:00', - `reason` varchar(255) NOT NULL default '', + `list` VARCHAR(255) NOT NULL DEFAULT '', + `btime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `rtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `reason` VARCHAR(255) NOT NULL DEFAULT '', KEY (`list`) ) ENGINE=MyISAM; @@ -420,28 +545,28 @@ CREATE TABLE IF NOT EXISTS `ipbanlist` ( -- CREATE TABLE IF NOT EXISTS `login` ( - `account_id` int(11) unsigned NOT NULL auto_increment, - `userid` varchar(23) NOT NULL default '', - `user_pass` varchar(32) NOT NULL default '', - `sex` enum('M','F','S') NOT NULL default 'M', - `email` varchar(39) NOT NULL default '', - `group_id` tinyint(3) NOT NULL default '0', - `state` int(11) unsigned NOT NULL default '0', - `unban_time` int(11) unsigned NOT NULL default '0', - `expiration_time` int(11) unsigned NOT NULL default '0', - `logincount` mediumint(9) unsigned NOT NULL default '0', - `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', - `last_ip` varchar(100) NOT NULL default '', + `account_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `userid` VARCHAR(23) NOT NULL DEFAULT '', + `user_pass` VARCHAR(32) NOT NULL DEFAULT '', + `sex` ENUM('M','F','S') NOT NULL DEFAULT 'M', + `email` VARCHAR(39) NOT NULL DEFAULT '', + `group_id` TINYINT(3) NOT NULL DEFAULT '0', + `state` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `expiration_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `logincount` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `lastlogin` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `last_ip` VARCHAR(100) NOT NULL DEFAULT '', `birthdate` DATE NOT NULL DEFAULT '0000-00-00', - `character_slots` TINYINT( 3 ) unsigned NOT NULL default '0', - `pincode` varchar(4) NOT NULL default '', - `pincode_change` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`account_id`), + `character_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `pincode` VARCHAR(4) NOT NULL DEFAULT '', + `pincode_change` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`account_id`), KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; -- added standard accounts for servers, VERY INSECURE!!! --- inserted into the table called login which is above +-- inserted INTo the table called login which is above INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','athena@athena.com'); @@ -450,10 +575,21 @@ INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES -- CREATE TABLE IF NOT EXISTS `mapreg` ( - `varname` varchar(32) BINARY NOT NULL, - `index` int(11) unsigned NOT NULL default '0', - `value` varchar(255) NOT NULL, - PRIMARY KEY (`varname`,`index`) + `varname` VARCHAR(32) BINARY NOT NULL, + `index` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `value` VARCHAR(255) NOT NULL, + PRIMARY KEY (`varname`,`index`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `npc_market_data` +-- + +CREATE TABLE IF NOT EXISTS `npc_market_data` ( + `name` VARCHAR(24) NOT NULL DEFAULT '', + `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`name`,`itemid`) ) ENGINE=MyISAM; -- @@ -461,17 +597,17 @@ CREATE TABLE IF NOT EXISTS `mapreg` ( -- CREATE TABLE IF NOT EXISTS `sc_data` ( - `account_id` int(11) unsigned NOT NULL, - `char_id` int(11) unsigned NOT NULL, - `type` smallint(11) unsigned NOT NULL, - `tick` int(11) NOT NULL, - `val1` int(11) NOT NULL default '0', - `val2` int(11) NOT NULL default '0', - `val3` int(11) NOT NULL default '0', - `val4` int(11) NOT NULL default '0', + `account_id` INT(11) UNSIGNED NOT NULL, + `char_id` INT(11) UNSIGNED NOT NULL, + `type` SMALLINT(11) UNSIGNED NOT NULL, + `tick` INT(11) NOT NULL, + `val1` INT(11) NOT NULL DEFAULT '0', + `val2` INT(11) NOT NULL DEFAULT '0', + `val3` INT(11) NOT NULL DEFAULT '0', + `val4` INT(11) NOT NULL DEFAULT '0', KEY (`account_id`), KEY (`char_id`), - PRIMARY KEY (`account_id`,`char_id`,`type`) + PRIMARY KEY (`account_id`,`char_id`,`type`) ) ENGINE=MyISAM; -- @@ -479,27 +615,27 @@ CREATE TABLE IF NOT EXISTS `sc_data` ( -- CREATE TABLE IF NOT EXISTS `mail` ( - `id` bigint(20) unsigned NOT NULL auto_increment, - `send_name` varchar(30) NOT NULL default '', - `send_id` int(11) unsigned NOT NULL default '0', - `dest_name` varchar(30) NOT NULL default '', - `dest_id` int(11) unsigned NOT NULL default '0', - `title` varchar(45) NOT NULL default '', - `message` varchar(255) NOT NULL default '', - `time` int(11) unsigned NOT NULL default '0', - `status` tinyint(2) NOT NULL default '0', - `zeny` int(11) unsigned NOT NULL default '0', - `nameid` int(11) unsigned NOT NULL default '0', - `amount` int(11) unsigned NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) unsigned NOT NULL default '0', - `identify` smallint(6) NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`id`) + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + `send_name` VARCHAR(30) NOT NULL DEFAULT '', + `send_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `dest_name` VARCHAR(30) NOT NULL DEFAULT '', + `dest_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `title` VARCHAR(45) NOT NULL DEFAULT '', + `message` VARCHAR(255) NOT NULL DEFAULT '', + `time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `status` TINYINT(2) NOT NULL DEFAULT '0', + `zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- @@ -507,12 +643,12 @@ CREATE TABLE IF NOT EXISTS `mail` ( -- CREATE TABLE IF NOT EXISTS `memo` ( - `memo_id` int(11) unsigned NOT NULL auto_increment, - `char_id` int(11) unsigned NOT NULL default '0', - `map` varchar(11) NOT NULL default '', - `x` smallint(4) unsigned NOT NULL default '0', - `y` smallint(4) unsigned NOT NULL default '0', - PRIMARY KEY (`memo_id`), + `memo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `map` VARCHAR(11) NOT NULL DEFAULT '', + `x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`memo_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -521,14 +657,14 @@ CREATE TABLE IF NOT EXISTS `memo` ( -- CREATE TABLE IF NOT EXISTS `mercenary` ( - `mer_id` int(11) unsigned NOT NULL auto_increment, - `char_id` int(11) NOT NULL, - `class` mediumint(9) unsigned NOT NULL default '0', - `hp` int(12) NOT NULL default '1', - `sp` int(12) NOT NULL default '1', - `kill_counter` int(11) NOT NULL, - `life_time` int(11) NOT NULL default '0', - PRIMARY KEY (`mer_id`) + `mer_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `char_id` INT(11) NOT NULL, + `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `hp` INT(12) NOT NULL DEFAULT '1', + `sp` INT(12) NOT NULL DEFAULT '1', + `kill_counter` INT(11) NOT NULL, + `life_time` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`mer_id`) ) ENGINE=MyISAM; -- @@ -536,15 +672,15 @@ CREATE TABLE IF NOT EXISTS `mercenary` ( -- CREATE TABLE IF NOT EXISTS `mercenary_owner` ( - `char_id` int(11) NOT NULL, - `merc_id` int(11) NOT NULL default '0', - `arch_calls` int(11) NOT NULL default '0', - `arch_faith` int(11) NOT NULL default '0', - `spear_calls` int(11) NOT NULL default '0', - `spear_faith` int(11) NOT NULL default '0', - `sword_calls` int(11) NOT NULL default '0', - `sword_faith` int(11) NOT NULL default '0', - PRIMARY KEY (`char_id`) + `char_id` INT(11) NOT NULL, + `merc_id` INT(11) NOT NULL DEFAULT '0', + `arch_calls` INT(11) NOT NULL DEFAULT '0', + `arch_faith` INT(11) NOT NULL DEFAULT '0', + `spear_calls` INT(11) NOT NULL DEFAULT '0', + `spear_faith` INT(11) NOT NULL DEFAULT '0', + `sword_calls` INT(11) NOT NULL DEFAULT '0', + `sword_faith` INT(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`) ) ENGINE=MyISAM; -- @@ -552,13 +688,13 @@ CREATE TABLE IF NOT EXISTS `mercenary_owner` ( -- CREATE TABLE IF NOT EXISTS `party` ( - `party_id` int(11) unsigned NOT NULL auto_increment, - `name` varchar(24) NOT NULL default '', - `exp` tinyint(11) unsigned NOT NULL default '0', - `item` tinyint(11) unsigned NOT NULL default '0', - `leader_id` int(11) unsigned NOT NULL default '0', - `leader_char` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`party_id`) + `party_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `name` VARCHAR(24) NOT NULL DEFAULT '', + `exp` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + `item` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0', + `leader_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `leader_char` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`party_id`) ) ENGINE=MyISAM; -- @@ -566,19 +702,19 @@ CREATE TABLE IF NOT EXISTS `party` ( -- CREATE TABLE IF NOT EXISTS `pet` ( - `pet_id` int(11) unsigned NOT NULL auto_increment, - `class` mediumint(9) unsigned NOT NULL default '0', - `name` varchar(24) NOT NULL default '', - `account_id` int(11) unsigned NOT NULL default '0', - `char_id` int(11) unsigned NOT NULL default '0', - `level` smallint(4) unsigned NOT NULL default '0', - `egg_id` smallint(11) unsigned NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', - `intimate` smallint(9) unsigned NOT NULL default '0', - `hungry` smallint(9) unsigned NOT NULL default '0', - `rename_flag` tinyint(4) unsigned NOT NULL default '0', - `incubate` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`pet_id`) + `pet_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `class` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(24) NOT NULL DEFAULT '', + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `level` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', + `egg_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `INTimate` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0', + `hungry` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0', + `rename_flag` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `incubate` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`pet_id`) ) ENGINE=MyISAM; -- @@ -586,14 +722,14 @@ CREATE TABLE IF NOT EXISTS `pet` ( -- CREATE TABLE IF NOT EXISTS `quest` ( - `char_id` int(11) unsigned NOT NULL default '0', - `quest_id` int(10) unsigned NOT NULL, - `state` enum('0','1','2') NOT NULL default '0', - `time` int(11) unsigned NOT NULL default '0', - `count1` mediumint(8) unsigned NOT NULL default '0', - `count2` mediumint(8) unsigned NOT NULL default '0', - `count3` mediumint(8) unsigned NOT NULL default '0', - PRIMARY KEY (`char_id`,`quest_id`) + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `quest_id` INT(10) UNSIGNED NOT NULL, + `state` ENUM('0','1','2') NOT NULL DEFAULT '0', + `time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `count1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `count2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `count3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`quest_id`) ) ENGINE=MyISAM; -- @@ -601,11 +737,11 @@ CREATE TABLE IF NOT EXISTS `quest` ( -- CREATE TABLE IF NOT EXISTS `ragsrvinfo` ( - `index` int(11) NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `exp` int(11) unsigned NOT NULL default '0', - `jexp` int(11) unsigned NOT NULL default '0', - `drop` int(11) unsigned NOT NULL default '0' + `index` INT(11) NOT NULL DEFAULT '0', + `name` VARCHAR(255) NOT NULL DEFAULT '', + `exp` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `jexp` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `drop` INT(11) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM; -- @@ -613,11 +749,11 @@ CREATE TABLE IF NOT EXISTS `ragsrvinfo` ( -- CREATE TABLE IF NOT EXISTS `skill` ( - `char_id` int(11) unsigned NOT NULL default '0', - `id` smallint(11) unsigned NOT NULL default '0', - `lv` tinyint(4) unsigned NOT NULL default '0', - `flag` TINYINT(1) UNSIGNED NOT NULL default 0, - PRIMARY KEY (`char_id`,`id`) + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `lv` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (`char_id`,`id`) ) ENGINE=MyISAM; -- @@ -625,10 +761,10 @@ CREATE TABLE IF NOT EXISTS `skill` ( -- CREATE TABLE IF NOT EXISTS `skill_homunculus` ( - `homun_id` int(11) NOT NULL, - `id` int(11) NOT NULL, - `lv` smallint(6) NOT NULL, - PRIMARY KEY (`homun_id`,`id`) + `homun_id` INT(11) NOT NULL, + `id` INT(11) NOT NULL, + `lv` SMALLINT(6) NOT NULL, + PRIMARY KEY (`homun_id`,`id`) ) ENGINE=MyISAM; -- @@ -636,8 +772,8 @@ CREATE TABLE IF NOT EXISTS `skill_homunculus` ( -- CREATE TABLE IF NOT EXISTS `sql_updates` ( - `timestamp` int(11) unsigned NOT NULL, - `ignored` enum('Yes','No') NOT NULL DEFAULT 'No', + `timestamp` INT(11) UNSIGNED NOT NULL, + `ignored` ENUM('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`timestamp`) ) ENGINE=MyISAM; @@ -675,9 +811,9 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-0 -- CREATE TABLE IF NOT EXISTS `sstatus` ( - `index` tinyint(4) unsigned NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `user` int(11) unsigned NOT NULL default '0' + `index` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `name` VARCHAR(255) NOT NULL DEFAULT '', + `user` INT(11) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM; -- @@ -685,158 +821,22 @@ CREATE TABLE IF NOT EXISTS `sstatus` ( -- CREATE TABLE IF NOT EXISTS `storage` ( - `id` int(11) unsigned NOT NULL auto_increment, - `account_id` int(11) unsigned NOT NULL default '0', - `nameid` int(11) unsigned NOT NULL default '0', - `amount` smallint(11) unsigned NOT NULL default '0', - `equip` int(11) unsigned NOT NULL default '0', - `identify` smallint(6) unsigned NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) unsigned NOT NULL default '0', - `card0` smallint(11) NOT NULL default '0', - `card1` smallint(11) NOT NULL default '0', - `card2` smallint(11) NOT NULL default '0', - `card3` smallint(11) NOT NULL default '0', - `expire_time` int(11) unsigned NOT NULL default '0', - `bound` tinyint(1) unsigned NOT NULL default '0', - `unique_id` bigint(20) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` SMALLINT(11) NOT NULL DEFAULT '0', + `card1` SMALLINT(11) NOT NULL DEFAULT '0', + `card2` SMALLINT(11) NOT NULL DEFAULT '0', + `card3` SMALLINT(11) NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; --- --- Table structure for table `interreg` --- - -CREATE TABLE IF NOT EXISTS `interreg` ( - `varname` varchar(11) NOT NULL, - `value` varchar(20) NOT NULL, - PRIMARY KEY (`varname`) -) ENGINE=InnoDB; - --- --- Table structure for table `account_data` --- - -CREATE TABLE IF NOT EXISTS `account_data` ( - `account_id` int(11) unsigned NOT NULL default '0', - `bank_vault` int(11) unsigned NOT NULL default '0', - `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100', - `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100', - `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100', - PRIMARY KEY (`account_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `npc_market_data` --- - -CREATE TABLE IF NOT EXISTS `npc_market_data` ( - `name` varchar(24) NOT NULL default '', - `itemid` int(11) unsigned NOT NULL default '0', - `amount` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`name`,`itemid`) -) ENGINE=MyISAM; - --- --- Table structure for table `acc_reg_num_db` --- - -CREATE TABLE IF NOT EXISTS `acc_reg_num_db` ( - `account_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` int(11) NOT NULL default '0', - PRIMARY KEY (`account_id`,`key`,`index`), - KEY `account_id` (`account_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `acc_reg_str_db` --- - -CREATE TABLE IF NOT EXISTS `acc_reg_str_db` ( - `account_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` varchar(254) NOT NULL default '0', - PRIMARY KEY (`account_id`,`key`,`index`), - KEY `account_id` (`account_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `char_reg_num_db` --- - -CREATE TABLE IF NOT EXISTS `char_reg_num_db` ( - `char_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` int(11) NOT NULL default '0', - PRIMARY KEY (`char_id`,`key`,`index`), - KEY `char_id` (`char_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `char_reg_str_db` --- - -CREATE TABLE IF NOT EXISTS `char_reg_str_db` ( - `char_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` varchar(254) NOT NULL default '0', - PRIMARY KEY (`char_id`,`key`,`index`), - KEY `char_id` (`char_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `global_acc_reg_num_db` --- - -CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` ( - `account_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` int(11) NOT NULL default '0', - PRIMARY KEY (`account_id`,`key`,`index`), - KEY `account_id` (`account_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `global_acc_reg_str_db` --- - - -CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` ( - `account_id` int(11) unsigned NOT NULL default '0', - `key` varchar(32) BINARY NOT NULL default '', - `index` int(11) unsigned NOT NULL default '0', - `value` varchar(254) NOT NULL default '0', - PRIMARY KEY (`account_id`,`key`,`index`), - KEY `account_id` (`account_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `autotrade_merchants` --- - -CREATE TABLE IF NOT EXISTS `autotrade_merchants` ( - `account_id` int(11) NOT NULL default '0', - `char_id` int(11) NOT NULL default '0', - `sex` tinyint(2) NOT NULL default '0', - `title` varchar(80) NOT NULL default 'Buy From Me!', - PRIMARY KEY (`account_id`,`char_id`) -) ENGINE=MyISAM; - --- --- Table structure for table `autotrade_data` --- - -CREATE TABLE IF NOT EXISTS `autotrade_data` ( - `char_id` int(11) NOT NULL default '0', - `itemkey` int(11) NOT NULL default '0', - `amount` int(11) NOT NULL default '0', - `price` int(11) NOT NULL default '0', - PRIMARY KEY (`char_id`,`itemkey`) -) ENGINE=MyISAM; |