CREATE TABLE IF NOT EXISTS `items` (
  `item_id` int(11) NOT NULL COMMENT 'item ID',
  `item_name` text NOT NULL COMMENT 'Item Name (Appears in chat and used by commands)',
  `sell_price` double NOT NULL COMMENT 'Sell price',
  `buy_price` double NOT NULL COMMENT 'Buy price',
  `buyable` tinyint(1) NOT NULL COMMENT '0 = false, 1 = true',
  `sellable` tinyint(1) NOT NULL COMMENT '0 = false, 1 = true',
  `subdata` text NOT NULL COMMENT 'item:subdata',
  `damage_value` int(11) NOT NULL COMMENT 'Used to decifer subdata better, example: wool:red could be damage_value 6',
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;