   ADD KEY `id_product_idx` (`id_product`);
 
 --
--- Indexes for table `product_promo`
---
-ALTER TABLE `product_promo`
+-- Indexes for table `setting`
+--
+ALTER TABLE `setting`
+  ADD PRIMARY KEY (`id`);
+
+--
+-- Indexes for table `site_socmed`
+--
+ALTER TABLE `site_socmed`
   ADD PRIMARY KEY (`id`),
-  ADD KEY `id_product` (`id_product`);
-
---
--- Indexes for table `setting`
---
-ALTER TABLE `setting`
+  ADD KEY `socmend_id` (`socmed_id`),
+  ADD KEY `socmed_id` (`socmed_id`);
+
+--
+-- Indexes for table `slider`
+--
+ALTER TABLE `slider`
+  ADD PRIMARY KEY (`id`);
+
+--
+-- Indexes for table `socmed`
+--
+ALTER TABLE `socmed`
+  ADD PRIMARY KEY (`id`);
+
+--
+-- Indexes for table `testimoni`
+--
+ALTER TABLE `testimoni`
   ADD PRIMARY KEY (`id`);
 
 --

  `site_name` varchar(200) DEFAULT NULL,
  `site_moto` varchar(200) DEFAULT NULL,
  `site_description` text,
  `site_logo` text,
  `update_at` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--

INSERT INTO `user` (`id`, `username`, `password`, `email`, `name`, `role`) VALUES
(1, 'admin123', '0192023a7bbd73250516f069df18b500', 'admin@gmail.com', 'administrator', 'A');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery_images`
--
ALTER TABLE `gallery_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gallery_id` (`gallery_id`);

--
-- Indexes for table `merchant`
--
ALTER TABLE `merchant`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `merchant_promo`
--
ALTER TABLE `merchant_promo`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_product` (`merchant_id`);

--
-- Indexes for table `merchant_socmed`
--
ALTER TABLE `merchant_socmed`
  ADD PRIMARY KEY (`id`),
  ADD KEY `socmend_id` (`socmed_id`),
  ADD KEY `socmed_id` (`socmed_id`),
  ADD KEY `merchant` (`merchant_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_product_id` (`product_category_id`),
  ADD KEY `merchant_id` (`merchant_id`),
  ADD KEY `merchant_id_2` (`merchant_id`);

--
-- Indexes for table `product_category`
