CREATE TABLE IF NOT EXISTS `product_sale` ( `sale_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `dt` date NOT NULL, PRIMARY KEY (`sale_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `product_sale` -- INSERT INTO `product_sale` (`sale_id`, `product_id`, `dt`) VALUES (1, 1, '2015-11-03'), (2, 1, '2015-11-02'), (3, 2, '2015-11-02'), (4, 1, '2015-11-02'); CREATE TABLE IF NOT EXISTS `product` ( `product_id` int(3) NOT NULL AUTO_INCREMENT, `product` varchar(25) NOT NULL, PRIMARY KEY (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `product` -- INSERT INTO `product` (`product_id`, `product`) VALUES (1, 'Monitor '), (2, 'CPU'), (3, 'Keyboard'), (4, 'Mouse');