CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL auto_increment,
  `item_id` int(11) NOT NULL,
  `item_name` varchar(75) NOT NULL,
  `item_flags` varchar(10) NOT NULL,
  `item_stack` int(10) NOT NULL,
  `item_desc` text NOT NULL,
  `item_cost` int(11) NOT NULL,
  `item_catid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1