summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql1080
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;