DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`account_id` int(11) NOT NULL,
`level` int(11) NOT NULL default 1,
`exp` bigint(20) NOT NULL default 0,
`hp` bigint(20) NOT NULL default 0,
`mp` bigint(20) NOT NULL default 0,
`bind_point` int(11) NOT NULL DEFAULT 0,
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`heading` int(11) NOT NULL,
`world_id` int(11) NOT NULL,
`gender` int(11) NOT NULL,
`race` int(11) NOT NULL,
`player_class` int(11) NOT NULL,
`face` int(11) NOT NULL,
`hair` int(11) NOT NULL,
`deco` int(11) NOT NULL,
`tattoo` int(11) NOT NULL,
`skin_rgb` int(11) NOT NULL,
`hair_rgb` int(11) NOT NULL,
`lip_rgb` int(11) NOT NULL,
`eye_rgb` int(11) NOT NULL,
`face_shape` int(11) NOT NULL,
`forehead` int(11) NOT NULL,
`eye_height` int(11) NOT NULL,
`eye_space` int(11) NOT NULL,
`eye_width` int(11) NOT NULL,
`eye_size` int(11) NOT NULL,
`eye_shape` int(11) NOT NULL,
`eye_angle` int(11) NOT NULL,
`brow_height` int(11) NOT NULL,
`brow_angle` int(11) NOT NULL,
`brow_shape` int(11) NOT NULL,
`nose` int(11) NOT NULL,
`nose_bridge` int(11) NOT NULL,
`nose_width` int(11) NOT NULL,
`nose_tip` int(11) NOT NULL,
`cheek` int(11) NOT NULL,
`lip_height` int(11) NOT NULL,
`mouth_size` int(11) NOT NULL,
`lip_size` int(11) NOT NULL,
`smile` int(11) NOT NULL,
`lip_shape` int(11) NOT NULL,
`jaw_height` int(11) NOT NULL,
`chin_jut` int(11) NOT NULL,
`ear_shape` int(11) NOT NULL,
`head_size` int(11) NOT NULL,
`neck` int(11) NOT NULL,
`neck_length` int(11) NOT NULL,
`shoulders` int(11) NOT NULL,
`shoulder_size` int(11) NOT NULL,
`torso` int(11) NOT NULL,
`chest` int(11) NOT NULL,
`waist` int(11) NOT NULL,
`hips` int(11) NOT NULL,
`arm_thickness` int(11) NOT NULL,
`arm_length` int(11) NOT NULL,
`hand_size` int(11) NOT NULL,
`leg_thickness` int(11) NOT NULL,
`leg_length` int(11) NOT NULL,
`foot_size` int(11) NOT NULL,
`facial_rate` int(11) NOT NULL,
`voice` int(11) NOT NULL,
`height` float NOT NULL,
`creation_date` timestamp NOT NULL default '0000-00-00 00:00:00',
`deletion_date` timestamp NULL DEFAULT NULL,
`last_online` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`admin` boolean NOT NULL DEFAULT FALSE,
`money` int(11) NOT NULL,
`ap` int(11) NOT NULL default 0,
`legionid` int(11) NOT NULL DEFAULT 0,
`online` boolean NOT NULL DEFAULT FALSE,
PRIMARY KEY (`id`),
UNIQUE KEY `name_unique` (`name`),
INDEX (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;