 -- Beperkingen voor tabel `product_has_category`
 --
 ALTER TABLE `product_has_category`
-  ADD CONSTRAINT `fk_product_has_category_category1` FOREIGN KEY (`category_category_id`) REFERENCES `category` (`category_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  ADD CONSTRAINT `fk_product_has_category_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
   ADD CONSTRAINT `fk_product_has_category_product1` FOREIGN KEY (`product_id`) REFERENCES `product` (`product_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
 --


INSERT INTO `publisher` (`publisher_id`, `publisher`) VALUES
(1, 'O'' Reilly'),
(2, 'Apress');

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


--

INSERT INTO `product` (`product_id`, `isbn`, `title`, `author`, `edition`, `release_date`, `product_img`, `stock`, `publisher_id`, `price`) VALUES
(14, 134291255, 'PHP', 'Larry Ullman', 2, '2017-05-09', 'product.jpg', 20, 1, 32),
(18, 2147483647, 'Murach''s PHP & MySQL', ' Joel Murach', 2, '2014-02-05', NULL, 7, 1, 49.5),
(19, 2147483647, 'Test', 'test', 2, '2017-06-02', NULL, 5, 2, 50),
(21, 2147483647, 'Computer Networks', ' Andrew Tanenbaum', 4, '2002-06-25', NULL, 2, 3, 14),
(22, 2147483647, 'PHP for Absolute Beginner', 'Jason Lengstorf', 2, '2014-08-03', 'php-absolute.jpg', 3, 2, 31.99),
(23, 2147483647, 'Learning PHP, MySQL & JavaScript', 'Robin Nixon', 3, '2014-03-02', 'robinson.jpg', 8, 1, 34.99),
(24, 2147483647, 'Learning PHP', 'David Sklar', 2, '2015-01-01', 'learnphp.jpg', 14, 1, 29.99);

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

