 ALTER TABLE `event`
   MODIFY `id_event` int(11) NOT NULL AUTO_INCREMENT;
 --
+-- AUTO_INCREMENT for table `keperluan`
+--
+ALTER TABLE `keperluan`
+  MODIFY `id_keperluan` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `pemenang`
+--
+ALTER TABLE `pemenang`
+  MODIFY `id_pemenang` 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 `pengembalian`
+--
+ALTER TABLE `pengembalian`
+  MODIFY `id_pengembalian` int(64) NOT NULL AUTO_INCREMENT;
+--
 -- AUTO_INCREMENT for table `pengunjung`
 --
 ALTER TABLE `pengunjung`
   MODIFY `id_pengunjung` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `pengurus`
+--
+ALTER TABLE `pengurus`
+  MODIFY `id_pengurus` int(128) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `piket`
+--
+ALTER TABLE `piket`
+  MODIFY `id_piket` int(32) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `siswa`
 --

  ADD PRIMARY KEY (`id_event`);

--
-- Indexes for table `peminjaman`
--
ALTER TABLE `peminjaman`
  ADD PRIMARY KEY (`id_peminjaman`);

--
-- Indexes for table `pengunjung`
--
ALTER TABLE `pengunjung`
  ADD PRIMARY KEY (`id_pengunjung`);

--
-- Indexes for table `siswa`
--
ALTER TABLE `siswa`

--

CREATE TABLE `keperluan` (
  `id_keperluan` int(11) NOT NULL,
  `id_pengunjung` int(32) NOT NULL,
  `keperluan` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
