DROP TABLE IF EXISTS `char`;
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',
`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',
`sex` ENUM('M','F','U') NOT NULL DEFAULT 'U',
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=InnoDB AUTO_INCREMENT=150000;
