JWQAw849

1
2CREATE TABLE IF NOT EXISTS `jadwal` (
3  `id_jadwal` int(5) NOT NULL AUTO_INCREMENT,
4  `nama` varchar(255) NOT NULL,
5  `hari` varchar(255) NOT NULL,
6  `jam_masuk` time NOT NULL,
7  `jam_keluar` time NOT NULL,
8  PRIMARY KEY (`id_jadwal`)
9) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
10
11--
12-- Dumping data for table `jadwal`
13--
14
15INSERT INTO `jadwal` (`id_jadwal`, `nama`, `hari`, `jam_masuk`, `jam_keluar`) VALUES
16(1, 'Robby', 'Senin', '08:00:00', '16:00:00'),
17(2, 'Robby', 'Selasa', '08:00:00', '16:00:00'),
18(3, 'Tommy', 'Rabu', '07:30:00', '16:00:00'),
19(4, 'Tommy', 'Kamis', '07:30:00', '16:00:00'),
20(5, 'Laura', 'Jumat', '08:00:00', '16:00:00'),
21(6, 'Laura', 'Sabtu', '07:30:00', '16:00:00'),
22(7, 'Robby', 'Rabu', '07:30:00', '16:00:00');
23
24/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
25/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
26/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;