l2j itemtable structure

# instead of:#------------------------------#-- Table structure for weapon#------------------------------CREATE TABLE weapon (  item_id decimal(11) ,  name varchar(39) ,  bodypart varchar(6) ,  crystallizable varchar(5) ,  weight decimal(4) ,  soulshots decimal(2) ,  spiritshots decimal(1) ,  material varchar(11) ,  crystal varchar(4) ,  p_dam decimal(5) ,  rnd_dam decimal(2) ,  weaponType varchar(8) ,  critical decimal(2) ,  hit_modify decimal(3,5),  avoid_modify decimal(2) ,  shield_def decimal(3) ,  shield_def_rate decimal(2) ,  atk_speed decimal(3) ,  mp_consume decimal(2) ,  m_dam decimal(3) ,  durability decimal(3) ,  price decimal(11) ,  PRIMARY KEY  (item_id));#------------------------------#-- Table structure for etcitem#------------------------------CREATE TABLE etcitem (  item_id decimal(11) ,  name varchar(38) ,  crystallizable varchar(5) ,  item_type varchar(12) ,  weight decimal(4) ,  consume_type varchar(9) ,  material varchar(11) ,  crystal_type varchar(4) ,  durability decimal(3) ,  price decimal(11) ,  PRIMARY KEY  (item_id)) ;#------------------------------#-- Table structure for armor#------------------------------CREATE TABLE armor (  item_id decimal(11) ,  name varchar(30) ,  bodypart varchar(15) ,  crystallizable varchar(5) ,  armor_type varchar(5) ,  weight decimal(5) ,  material varchar(15) ,  crystal_type varchar(4) ,  avoid_modify decimal(1) ,  durability decimal(3) ,  p_def decimal(3) ,  m_def decimal(2) ,  mp_bonus decimal(3) ,  price decimal(11) ,  PRIMARY KEY  (item_id)) ;# I came out with:#------------------------------#-- Table structure for items   - weapon, etcitem, armor#------------------------------CREATE TABLE items (	item_id INT(11) NOT NULL default '-1',	item_name VARCHAR(39) NOT NULL default 'new item',	item_type ENUM('none','cloth','light','heavy','sword','dualsword','blunt','dagger','pole','fist','dualfist','bow','etc','arrow','potion','scroll','material','recipe') NOT NULL default 'none',	item_material ENUM('','') NOT NULL default 'none',	item_consume_type ENUM('normal','stackable','gold') NOT NULL default 'normal',	item_weight INT(5) NOT NULL default '0',	item_durability INT(3) NOT NULL default '1',	item_placement VARCHAR(6) NOT NULL default '',	item_consume_hp INT(2) NOT NULL default '0',	item_consume_mp INT(2) NOT NULL default '0',	item_soulshots INT(1) NOT NULL default '0',	item_spiritshots INT(1) NOT NULL default '0',	item_bonus_hp INT(3) NOT NULL default '0',	item_bonus_mp INT(3) NOT NULL default '0',	item_pdmg INT(5) NOT NULL default '0',	item_mdmg INT(5) NOT NULL default '0',	item_randomdmg INT(2) NOT NULL default '0',	item_attackspeed INT(3) NOT NULL default '0',	item_criticalrate decimal(2) NOT NULL default '0',	item_pdefense INT(5) NOT NULL default '0',	item_mdefense INT(5) NOT NULL default '0',	item_defenserate INT(2) NOT NULL default '0',	item_modifier_hit DECIMAL(3,5) NOT NULL default '0',	item_modifier_avoid DECIMAL(3,5) NOT NULL default '0',	item_crystallizable TINYINT(1) NOT NULL default '0',	item_crystaltype ENUM('none','d','c','b','a','s') NOT NULL default 'none'	item_price INT(11) NOT NULL default '0',	PRIMARY KEY  (item_id));