   ADD KEY `index_brand_id` (`brand_id`);
 
 --
+-- Indexes for table `product_photos`
+--
+ALTER TABLE `product_photos`
+  ADD PRIMARY KEY (`photo_id`),
+  ADD KEY `product_id` (`product_id`);
+
+--
+-- Indexes for table `users`
+--
+ALTER TABLE `users`
+  ADD PRIMARY KEY (`user_id`),
+  ADD UNIQUE KEY `unique_user_id` (`user_id`),
+  ADD UNIQUE KEY `unique_user_name` (`user_name`),
+  ADD UNIQUE KEY `unique_user_email` (`user_email`);
+
+--
 -- AUTO_INCREMENT for dumped tables
 --
 

(1, 'Sepatu', 'data sepatu', 'sepatu'),
(2, 'Tas', 'data tas', 'tas'),
(3, 'Pakaian Pria', 'Macam macam pakaian pria', 'pakaian-pria');

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


  ADD PRIMARY KEY (`category_id`),
  ADD UNIQUE KEY `unique_category_slug` (`category_slug`),
  ADD UNIQUE KEY `unique_cateogry_id` (`category_id`);

--
-- Indexes for table `preferences`
--
ALTER TABLE `preferences`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_id` (`id`);

--
-- Indexes for table `products`
