CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

INSERT INTO `tags` (`id`, `item_id`, `name`, `type`) VALUES
(1, 1, 'cookies', 'food'),
(6, 4, 'soda', 'drinks'),
(3, 1, 'soda', 'drinks'),
(4, 2, 'lemonade', 'drinks'),
(5, 3, 'beer', 'drinks'),
(7, 2, 'pizza', 'food');

-------------------------------------

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `pay` int(11) NOT NULL,
  `desc` text NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`,`desc`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

INSERT INTO `items` (`id`, `name`, `pay`, `desc`) VALUES
(0, 'Fusce in consequa', 6815, '<p>MORE LIPSUM HERE, STRIPPED FOR CONVENIENCE</p>'),
(1, 'Bla bla bla', 2344, '<p>MORE LIPSUM HERE, STRIPPED FOR CONVENIENCE</p>')
--More random items here