CREATE TABLE IF NOT EXISTS `player` (
  `player_id` int NOT NULL AUTO_INCREMENT,
  `session_id` text NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `email_register` text NOT NULL,
  `password` text NOT NULL,
  `password_code` tinytext NOT NULL,
  `ip` int NOT NULL,
  `ip_register` int NOT NULL,
  `register` enum ('false', 'true') DEFAULT 'false',
  `register_date` datetime NOT NULL,
  `action_date` datetime NOT NULL,
  `online` enum ('false', 'true') DEFAULT 'false',
  `ban` enum ('false', 'true') DEFAULT 'false',
  `ban_ip` enum ('false', 'true') DEFAULT 'false',
  `ban_date` datetime NOT NULL,
  `ban_ip_date` datetime NOT NULL,
  `description` text NOT NULL,
  `note` text NOT NULL,
  `gender` enum ('m', 'f') DEFAULT 'm',
  `look_1` int NOT NULL DEFAULT '0',
  `look_2` int NOT NULL DEFAULT '0',
  `look_3` int NOT NULL DEFAULT '0',
  `look_4` int NOT NULL DEFAULT '0',
  `look_5` int NOT NULL DEFAULT '0',
  `look_6` int NOT NULL DEFAULT '0',
  `look_7` int NOT NULL DEFAULT '0',
  `look_8` int NOT NULL DEFAULT '0',
  `look_9` int NOT NULL DEFAULT '0',
  `look_10` int NOT NULL DEFAULT '0',
  `honor` int NOT NULL DEFAULT '0',
  `level` int NOT NULL DEFAULT '0',
  `statistic_point` int NOT NULL DEFAULT '0',
  `statistic_stamina` int NOT NULL DEFAULT '0',
  `statistic_strength` int NOT NULL DEFAULT '0',
  `statistic_intelligence` int NOT NULL DEFAULT '0',
  `statistic_intuition` int NOT NULL DEFAULT '0',
  `statistic_stamina_buy` int NOT NULL DEFAULT '0',
  `statistic_strength_buy` int NOT NULL DEFAULT '0',
  `statistic_intelligence_buy` int NOT NULL DEFAULT '0',
  `statistic_intuition_buy` int NOT NULL DEFAULT '0',
  `statistic_stamina_base` int NOT NULL DEFAULT '0',
  `statistic_strength_base` int NOT NULL DEFAULT '0',
  `statistic_intelligence_base` int NOT NULL DEFAULT '0',
  `statistic_intuition_base` int NOT NULL DEFAULT '0',
  `experience` int NOT NULL DEFAULT '0', 
  `gold` int NOT NULL DEFAULT '0',
  `donut` int NOT NULL DEFAULT '0',
  `quest_energy` int NOT NULL DEFAULT '0',
  `quest_energy_maximum` int NOT NULL DEFAULT '0',
  `quest` int NOT NULL DEFAULT '0',
  `quest_stage` int NOT NULL DEFAULT '0',
  `quest_date` datetime NOT NULL,
  `quest_refresh_date` datetime NOT NULL,
  `quest_boost` smallint NOT NULL DEFAULT '0',
  `quest_boost_date` datetime NOT NULL,
  `statistic_boost` smallint NOT NULL DEFAULT '0',
  `statistic_boost_date` datetime NOT NULL,
  `work_boost` smallint NOT NULL DEFAULT '0',
  `work_boost_date` datetime NOT NULL,
  `sense_boost` smallint NOT NULL DEFAULT '0',
  `sense_boost_date` datetime NOT NULL,
  `league_boost` smallint NOT NULL DEFAULT '0',
  `league_boost_date` datetime NOT NULL,
  `multitasking_boost` smallint NOT NULL DEFAULT '0',
  `multitasking_boost_date` datetime NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `quest` (
  `quest_id` int NOT NULL AUTO_INCREMENT,
  `player_id` int NOT NULL DEFAULT '0',
  `name` tinytext NOT NULL,
  `type` int NOT NULL DEFAULT '0',
  `level` int NOT NULL DEFAULT '0',
  `stage` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `duration` int NOT NULL DEFAULT '0',
  `energy` int NOT NULL DEFAULT '0',
  `gold` int NOT NULL DEFAULT '0',
  `donut` int NOT NULL DEFAULT '0',
  `experience` int NOT NULL DEFAULT '0',
  `honor` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`quest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;