   ADD PRIMARY KEY (`id_event`);
 
 --
+-- Indexes for table `keperluan`
+--
+ALTER TABLE `keperluan`
+  ADD PRIMARY KEY (`id_keperluan`);
+
+--
+-- Indexes for table `pemenang`
+--
+ALTER TABLE `pemenang`
+  ADD PRIMARY KEY (`id_pemenang`);
+
+--
 -- Indexes for table `peminjaman`
 --
 ALTER TABLE `peminjaman`
   ADD PRIMARY KEY (`id_peminjaman`);
 
 --
+-- Indexes for table `pengembalian`
+--
+ALTER TABLE `pengembalian`
+  ADD PRIMARY KEY (`id_pengembalian`);
+
+--
 -- Indexes for table `pengunjung`
 --
 ALTER TABLE `pengunjung`
   ADD PRIMARY KEY (`id_pengunjung`);
 
 --
+-- Indexes for table `pengurus`
+--
+ALTER TABLE `pengurus`
+  ADD PRIMARY KEY (`id_pengurus`);
+
+--
+-- Indexes for table `piket`
+--
+ALTER TABLE `piket`
+  ADD PRIMARY KEY (`id_piket`);
+
+--
 -- Indexes for table `siswa`
 --
 ALTER TABLE `siswa`

ALTER TABLE `event`
  MODIFY `id_event` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `peminjaman`
--
ALTER TABLE `peminjaman`
  MODIFY `id_peminjaman` int(128) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `pengunjung`
--
ALTER TABLE `pengunjung`
  MODIFY `id_pengunjung` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `siswa`
--

--

CREATE TABLE `pemenang` (
  `id_pemenang` int(11) NOT NULL,
  `id_event` int(32) NOT NULL,
  `id_anggota` int(32) NOT NULL,
  `juara` int(16) NOT NULL,
