 --
 ALTER TABLE `produk`
   ADD PRIMARY KEY (`id_produk`),
-  ADD KEY `id_user` (`id_user`);
+  ADD KEY `id_user` (`id_user`),
+  ADD KEY `id_jenis_produk` (`id_jenis_produk`),
+  ADD KEY `id_kategori_produk` (`id_kategori_produk`);
 
 --
 -- Indexes for table `provinsi`

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

--
-- Table structure for table `konveksi`
--

CREATE TABLE `konveksi` (
  `id_konveksi` smallint(6) NOT NULL,
  `nama_konveksi` varchar(100) NOT NULL,
  `deskripsi konveksi` text NOT NULL,
  `id_user` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

  `id_produk` smallint(6) NOT NULL,
  `id_konveksi` smallint(6) NOT NULL,
  `no_rekening` smallint(6) NOT NULL,
  `id_ukuran` int(100) DEFAULT NULL,
  `status_pembayaran_produk` tinyint(1) NOT NULL,
  `id_jenis_pengiriman` smallint(6) NOT NULL,
  `bukti_pembayaran_transaksi` varchar(100) NOT NULL,
