CREATE TABLE character_info (
guid INT NOT NULL,
account_id int unsigned NOT NULL,
authority tinyint unsigned NOT NULL DEFAULT '0',
race tinyint unsigned NOT NULL,
name varchar(255) DEFAULT NULL,
slot tinyint NOT NULL,
level smallint NOT NULL,
level_master smallint NOT NULL DEFAULT '0',
level_majestic smallint NOT NULL DEFAULT '0',
experience bigint NOT NULL DEFAULT '0',
experience_master bigint NOT NULL DEFAULT '0',
experience_majestic bigint NOT NULL DEFAULT '0',
points int NOT NULL,
points_master int NOT NULL DEFAULT '0',
points_majestic int NOT NULL DEFAULT '0',
strength int unsigned NOT NULL,
agility int unsigned NOT NULL,
vitality int unsigned NOT NULL,
energy int unsigned NOT NULL,
leadership int unsigned NOT NULL,
world smallint unsigned NOT NULL,
world_x smallint NOT NULL,
world_y smallint NOT NULL,
direction tinyint unsigned NOT NULL DEFAULT '1',
money int unsigned NOT NULL DEFAULT '0',
life int NOT NULL,
mana int NOT NULL,
shield int NOT NULL DEFAULT '0',
stamina int NOT NULL DEFAULT '0',
add_fruit_points int NOT NULL DEFAULT '0',
dec_fruit_points int NOT NULL DEFAULT '0',
expanded_inventory tinyint unsigned NOT NULL DEFAULT '0',
mute_time bigint NOT NULL DEFAULT '0',
admin_flags int unsigned NOT NULL DEFAULT '0',
pk_level tinyint unsigned NOT NULL DEFAULT '0',
pk_count int NOT NULL DEFAULT '0',
pk_points int NOT NULL DEFAULT '0',
first_time tinyint unsigned NOT NULL DEFAULT '0',
santa_claus_gift bigint NOT NULL DEFAULT '0',
personal_store_name varchar(255) DEFAULT NULL,
personal_store_open tinyint NOT NULL DEFAULT '0',
goblin_points int unsigned NOT NULL DEFAULT '0',
last_use bigint NOT NULL DEFAULT '0',
kick_time bigint NOT NULL DEFAULT '0',
post_count int NOT NULL DEFAULT '0',
post_day tinyint unsigned NOT NULL DEFAULT '0',
post_month tinyint unsigned NOT NULL DEFAULT '0',
ruud_money int unsigned NOT NULL DEFAULT '0',
hunting_log_visible tinyint unsigned NOT NULL DEFAULT '1',
create_date bigint NOT NULL DEFAULT '0',
`online` tinyint unsigned NOT NULL DEFAULT '0',
server_code smallint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (guid),
UNIQUE KEY name_UNIQUE (name)
)