create table account( idx int primary key auto_increment, account varchar(30), pass varchar(30) )default character set = utf8; create table player( idx int primary key unique auto_increment, account_idx int not null, char_name varchar(50) not null, char_gender boolean default true, char_class int default '1', char_level int default '1', char_exp int default '0', char_cur_area int default '1', char_gold int default '0', char_cur_skill int default '0', stat_point int default '0', stat_hp int default '100', stat_mp int default '50', stat_st int default '10', stat_dx int default '10', stat_iq int default '10', stat_ht int default '10', equip_right int default '0', equip_left int default '0', equip_body int default '0', equip_leg int default '0', equip_head int default '0', equip_etc int default '0', action_order varchar(29) default '1,1,1,1,1,1,1,1,1,1' )default character set = utf8; create table player_class( idx int primary key unique auto_increment, player_idx int unique not null, class_1 int default '0', class_1_exp int default '0', class_2 int default '-1', class_2_exp int default '-1', class_3 int default '-1', class_3_exp int default '-1', class_4 int default '-1', class_4_exp int default '-1', class_5 int default '-1', class_5_exp int default '-1', class_6 int default '-1', class_6_exp int default '-1', class_7 int default '-1', class_7_exp int default '-1', class_8 int default '-1', class_8_exp int default '-1', class_9 int default '-1', class_9_exp int default '-1', class_10 int default '-1', class_10_exp int default '-1', skill_1_1 int default '0', skill_1_1_exp int default '0', skill_1_2 int default '0', skill_1_2_exp int default '0', skill_1_3 int default '0', skill_1_3_exp int default '0', skill_2_1 int default '-1', skill_2_1_exp int default '-1', skill_2_2 int default '-1', skill_2_2_exp int default '-1', skill_2_3 int default '-1', skill_2_3_exp int default '-1', skill_3_1 int default '-1', skill_3_1_exp int default '-1', skill_3_2 int default '-1', skill_3_2_exp int default '-1', skill_3_3 int default '-1', skill_3_3_exp int default '-1', skill_4_1 int default '-1', skill_4_1_exp int default '-1', skill_4_2 int default '-1', skill_4_2_exp int default '-1', skill_4_3 int default '-1', skill_4_3_exp int default '-1', skill_5_1 int default '-1', skill_5_1_exp int default '-1', skill_5_2 int default '-1', skill_5_2_exp int default '-1', skill_5_3 int default '-1', skill_5_3_exp int default '-1', skill_6_1 int default '-1', skill_6_1_exp int default '-1', skill_6_2 int default '-1', skill_6_2_exp int default '-1', skill_6_3 int default '-1', skill_6_3_exp int default '-1', skill_7_1 int default '-1', skill_7_1_exp int default '-1', skill_7_2 int default '-1', skill_7_2_exp int default '-1', skill_7_3 int default '-1', skill_7_3_exp int default '-1', skill_8_1 int default '-1', skill_8_1_exp int default '-1', skill_8_2 int default '-1', skill_8_2_exp int default '-1', skill_8_3 int default '-1', skill_8_3_exp int default '-1', skill_9_1 int default '-1', skill_9_1_exp int default '-1', skill_9_2 int default '-1', skill_9_2_exp int default '-1', skill_9_3 int default '-1', skill_9_3_exp int default '-1', skill_10_1 int default '-1', skill_10_1_exp int default '-1', skill_10_2 int default '-1', skill_10_2_exp int default '-1', skill_10_3 int default '-1', skill_10_3_exp int default '-1', foreign key (player_idx) references player(idx) on delete cascade )default character set = utf8; create table class_list( idx int primary key unique auto_increment, class_name varchar(50) not null, skill_name_1 varchar(50) not null, skill_name_2 varchar(50) not null, skill_name_3 varchar(50) not null )default character set = utf8; create table area_list( idx int primary key unique auto_increment, area_name varchar(30) not null, area_type int not null, area_inn boolean default false, area_weapon_shop boolean default false, area_item_shop boolean default false, area_pub boolean default false, area_guild boolean default false, area_board boolean default false, area_field boolean default false, area_dungeon boolean default false, area_route_1 int, area_route_2 int, area_route_3 int, area_route_4 int, area_route_5 int )default character set = utf8; create table enemy_list( idx int primary key unique auto_increment, enemy_name varchar(30) not null, enemy_type int not null, enemy_hp int not null, enemy_mp int not null, enemy_phy_atk int not null, enemy_phy_def int not null, enemy_mag_atk int not null, enemy_mag_def int not null )default character set = utf8; create table enemy_spawn_list( idx int primary key unique auto_increment, spawn_area int not null, spawn_enemy int not null, spawn_rate int not null )default character set = utf8; create table item_list( idx int primary key unique auto_increment, item_name varchar(30) not null, item_type int default '0', item_price int default '0', item_required_st int default '0', item_required_dx int default '0', item_required_iq int default '0', item_required_ht int default '0', item_increase_hp int default '0', item_increase_mp int default '0', item_increase_st int default '0', item_increase_dx int default '0', item_increase_iq int default '0', item_increase_ht int default '0', item_increase_phy_atk int default '0', item_increase_phy_def int default '0', item_increase_mag_atk int default '0', item_increase_mag_def int default '0', item_increase_exp int default '0', item_increase_gold int default '0', item_consumable boolean default false, item_stackable boolean default false, item_explain varchar(300) )default character set = utf8; create table item_inventory( idx int primary key unique auto_increment, player_idx int not null, item_idx int not null, stack int default '1', equiped boolean default false )default character set = utf8; create table board_main( idx int primary key unique auto_increment, writer varchar(50) not null, title varchar(500), main varchar(500), write_time datetime not null )default character set = utf8; create table board_sub( idx int primary key unique auto_increment, main_idx int not null, writer varchar(50) not null, reply varchar(500), write_time datetime not null )default character set = utf8;