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` INT(9) UNSIGNED NOT NULL DEFAULT '0',
  `hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
  `max_sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
  `sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
  `status_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `skill_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `option` INT(11) NOT NULL DEFAULT '0',
  `karma` TINYINT(3) NOT NULL DEFAULT '0',
  `manner` SMALLINT(6) NOT NULL DEFAULT '0',
  `party_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `pet_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `homun_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `elemental_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `hair` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `hair_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `clothes_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `body` SMALLINT(5) unsigned NOT NULL default '0',
  `weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `shield` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `head_top` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `head_mid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `head_bottom` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `last_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',
  `hotkey_rowshift` TINYINT(3) 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=InnoDB AUTO_INCREMENT=150000;