 
 CREATE TABLE `product_has_category` (
   `product_id` int(11) NOT NULL,
-  `category_category_id` int(11) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  `category_id` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Gegevens worden geëxporteerd voor tabel `product_has_category`
+--
+
+INSERT INTO `product_has_category` (`product_id`, `category_id`) VALUES
+(14, 1),
+(19, 1),
+(21, 4),
+(22, 1),
+(23, 1),
+(24, 2);
 
 -- --------------------------------------------------------
 

-- Indexen voor tabel `product_has_category`
--
ALTER TABLE `product_has_category`
  ADD PRIMARY KEY (`product_id`,`category_category_id`),
  ADD KEY `fk_product_has_category_category1_idx` (`category_category_id`),
  ADD KEY `fk_product_has_category_product1_idx` (`product_id`);

--

--

INSERT INTO `category` (`category_id`, `category_name`) VALUES
(1, 'Informatico'),
(2, 'Computers'),
(3, 'Hardware'),
(4, 'Computer Networks');

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

