db.sql

CREATE TABLE score(
personality VARCHAR(20) , race VARCHAR(20) , class VARCHAR(20) ,
sex BOOL,
name VARCHAR(255) ,
why VARCHAR(255) , floor SMALLINT,
ver VARCHAR(10),
dumpnum MEDIUMINT UNIQUE,
score INT,
date DATE,
magic1 VARCHAR(10) , magic2 VARCHAR(10) ,
win BOOL,
age SMALLINT,
height SMALLINT, weight SMALLINT,
social TINYINT,
align VARCHAR(10) ,
str SMALLINT, max_str SMALLINT,
inte SMALLINT, max_int SMALLINT,
wis SMALLINT, max_wis SMALLINT,
dex SMALLINT, max_dex SMALLINT,
cha SMALLINT, max_cha SMALLINT,
atk_r TINYINT, dmg_r TINYINT, atk_l TINYINT, dmg_l TINYINT, atk_b TINYINT, dmg_b TINYINT,atk_f TINYINT,dmg_f TINYINT, 
atknum_r TINYINT,atknum_l TINYINT,atknum_s TINYINT,avgdmg_r TINYINT,avgdmg_l SMALLINT,shot_dmg SMALLINT,shot_hit TINYINT,shot_multiply TINYINT,shot_num TINYINT,
ac SMALLINT,
eternal_speed TINYINT,temp_speed TINYINT,
hp SMALLINT,max_hp SMALLINT,
mp SMALLINT,max_mp SMALLINT,
level TINYINT,exp MEDIUMINT,max_exp MEDIUMINT,
money INT,
playdate MEDIUMINT,time SMALLINT,playtime INT,
atk_rank TINYINT,shot_rank TINYINT,def_rank TINYINT,hide_rank TINYINT,rec_rank TINYINT,search_rank TINYINT,untrap_rank TINYINT,mitem_rank TINYINT, red TINYINT,
equ_rh VARCHAR(255) ,equ_lh VARCHAR(255) ,
equ_sh VARCHAR(255) ,
equ_rr VARCHAR(255) ,equ_lr VARCHAR(255) ,
equ_am VARCHAR(255) ,
equ_li VARCHAR(255) ,
equ_ar VARCHAR(255) ,equ_cl VARCHAR(255) ,
equ_he VARCHAR(255) ,equ_gl VARCHAR(255) ,equ_bo VARCHAR(255) );