# NOTE: Material is not done as of yet, also additional keys will be added later.
# I also realize this type of table would require alot of code rework but in the end would work out alot better.
# 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)
);