CREATE TABLE `t_calon` (
`id_calon` int(5) NOT NULL PRIMARY KEY,
`tgl_register` date NOT NULL,
`nama` varchar(100) NOT NULL,
`tmpt_lahir` varchar(50) NOT NULL,
`tgl_lahir` date NOT NULL,
`jk` enum('Pria','Perempuan') NOT NULL,
`ktp` int(20) NOT NULL,
`foto` varchar(50) NOT NULL,
`level` enum('0','1') NOT NULL,
`visimisi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `t_history` (
`id_history` int(5) NOT NULL PRIMARY KEY,
`time` datetime NOT NULL,
`keterangan` varchar(200) NOT NULL,
`logo` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `t_undangan` (
`id_undangan` int(5) NOT NULL PRIMARY KEY,
`tgl_undangan` datetime NOT NULL,
`isi` text NOT NULL,
`status` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `t_user` (
`id_user` int(5) NOT NULL PRIMARY KEY,
`tgl_register` date NOT NULL,
`nama` varchar(100) NOT NULL,
`tmpt_lahir` varchar(50) NOT NULL,
`tgl_lahir` date NOT NULL,
`jk` enum('Pria','Perempuan') NOT NULL,
`ktp` varchar(20) NOT NULL,
`username` varchar(10) NOT NULL,
`password` varchar(60) NOT NULL,
`foto` varchar(50) NOT NULL,
`level` enum('0','1') NOT NULL,
`status` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `t_user` (`id_user`, `tgl_register`, `nama`, `tmpt_lahir`, `tgl_lahir`, `jk`, `ktp`, `username`, `password`, `foto`, `level`, `status`) VALUES
(10001, '2017-09-05', 'admin E-Voting', 'Lamongan', '2000-01-01', 'Pria', '565656565656', 'admin', '$2y$10$dHUIHWMgR.GmB6he2kbx4O1NrR0pmHv62cHCZieKG1eLh4S0ICr1S', 'no-foto.png', '0', '0');
CREATE TABLE `t_voting` (
`id_voting` int(5) NOT NULL PRIMARY KEY,
`id_calon` varchar(5) NOT NULL,
`jumlah` int(5) NOT NULL,
`status` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Sampai di sini dulunya pastikan kalian selalu stay di blog ini
karna akan ada lanjutan part2 ya yang akan membahas tema yang sama lagi
0 komentar:
Posting Komentar