CREATE TABLE IF NOT EXISTS `category` (
  `category_id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


INSERT INTO `category` (`category_id`, `name`) VALUES (1, 'Memory Cards'), (2, 'Televisions'), (3, 'Computers'), (4, 'Clothing'), (5, 'Sports Clothing');

CREATE TABLE IF NOT EXISTS `product` (
  `product_id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `price` double(10,2) NOT NULL,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `product` (`product_id`, `name`, `price`) VALUES (2, '32 GB Memory Card', 55.00), (1, '16 GB Memory Card', 26.50), (3, 'Sony TV', 1150.00), (4, 'Plasma TV', 25000.00), (5, 'High Tech 3D TV', 999.00), (6, 'Super Gaming High End PC', 2645.20), (7, 'Retro tShirt', 35.00), (8, 'Nike Trainers', 90.00), (9, 'Addidas Trainers', 40.00);

CREATE TABLE IF NOT EXISTS `product_category` (
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY  (`product_id`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `product_category` (`product_id`, `category_id`) VALUES (1, 1), (1, 3), (2, 1), (2, 3), (3, 2), (4, 2), (5, 2), (6, 3), (7, 4), (7, 5), (8, 4), (8, 5), (9, 4), (9, 5);