item inventory and equip are gone

[Diss]

i update my svn to the latest i also excute the main.sql in mysql workbench

 

and i got this error and bugged in char.sql when i logged in 

 

 

i hope anyone can help

 

thx

 

before i excute the main.sql its work fine 

 

now i excuted again the main.sql i got this 

 

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`) ) ENGINE=MyISAM

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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',   `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',   `moves` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`char_id`),   UNIQUE KEY `name_key` (`name`),   KEY `account_id` (`account_id`),   KEY `party_id` (`party_id`),   KEY `guild_id` (`guild_id`),   KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000

 

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_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

 

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`) ) ENGINE=MyISAM

 

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',   KEY  `char_id` (`char_id`) ) ENGINE=MyISAM

 

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',  PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM

 

CREATE TABLE IF NOT EXISTS `global_reg_value` (   `char_id` int(11) unsigned NOT NULL default '0',   `str` varchar(255) NOT NULL default '',   `value` varchar(255) NOT NULL default '0',   `type` tinyint(1) NOT NULL default '3',   `account_id` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`char_id`,`str`,`account_id`),   KEY `account_id` (`account_id`) ) ENGINE=MyISAM

 

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',   `emblem_data` blob,   PRIMARY KEY  (`guild_id`,`char_id`),   UNIQUE KEY `guild_id` (`guild_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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`),   KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM

 

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`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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 '',   KEY (`list`) ) ENGINE=MyISAM

 

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 '',   `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`),   KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000

 

INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]')

 

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`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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',   `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',   `moves` int(11) unsigned NOT NULL DEFAULT '0',   PRIMARY KEY  (`char_id`),   UNIQUE KEY `name_key` (`name`),   KEY `account_id` (`account_id`),   KEY `party_id` (`party_id`),   KEY `guild_id` (`guild_id`),   KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000

 

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_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

 

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`) ) ENGINE=MyISAM

 

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',   KEY  `char_id` (`char_id`) ) ENGINE=MyISAM

 

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',  PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM

 

CREATE TABLE IF NOT EXISTS `global_reg_value` (   `char_id` int(11) unsigned NOT NULL default '0',   `str` varchar(255) NOT NULL default '',   `value` varchar(255) NOT NULL default '0',   `type` tinyint(1) NOT NULL default '3',   `account_id` int(11) unsigned NOT NULL default '0',   PRIMARY KEY  (`char_id`,`str`,`account_id`),   KEY `account_id` (`account_id`) ) ENGINE=MyISAM

 

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',   `emblem_data` blob,   PRIMARY KEY  (`guild_id`,`char_id`),   UNIQUE KEY `guild_id` (`guild_id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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`),   KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM

 

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`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM

 

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`) ) ENGINE=MyISAM

 

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

 

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` mediumint(8) 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(3) unsigned NOT NULL default '0',   `unique_id` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`),   KEY `char_id` (`char_id`) ) ENGINE=MyISAM

 

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 '',   KEY (`list`) ) ENGINE=MyISAM

 

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 '',   `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`),   KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000

 

INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]')

 

Edited June 16, 2013 by Diss