 --
 
 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;

--

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

  `id_pengurus` int(128) NOT NULL,
  `id_anggota` int(128) NOT NULL,
  `username` varchar(16) NOT NULL,
  `password` varchar(128) NOT NULL,
  `role` varchar(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `piket`
--

CREATE TABLE `piket` (
  `id_piket` int(32) NOT NULL,
  `id_pengurus` int(32) NOT NULL,
  `tanggal` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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