· 8 years ago · Mar 08, 2018, 10:42 PM
1
2DROP TABLE IF EXISTS `userlogin`;
3CREATE TABLE IF NOT EXISTS `userlogin` (
4 `Id` bigint(11) NOT NULL AUTO_INCREMENT,
5 `username` varchar(100) DEFAULT NULL,
6 `password` varchar(100) DEFAULT NULL,
7 `role` enum('phasis','dosen','operator','admin') DEFAULT NULL,
8 `nipd` varchar(20) DEFAULT NULL,
9 `kode` varchar(25) DEFAULT NULL COMMENT 'kode pengajar',
10 PRIMARY KEY (`Id`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
12
13--
14-- Dumping data for table `userlogin`
15--
16
17INSERT INTO `userlogin` (`Id`, `username`, `password`, `role`, `nipd`, `kode`) VALUES
18(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', NULL, NULL),
19(2, 'mush', '071d4c6be7112fc847d2167ef4ac63f4', 'dosen', NULL, 'mush'),
20(3, 'rendy', '88ad32a14f7f7964d03dad411ffcc59b', 'phasis', '201103110', NULL),
21(4, 'dicky', 'ee0b6db238b075d0da86340048fb147a', 'operator', NULL, NULL);