MDdbx5XZ

1
2CREATE TABLE IF NOT EXISTS `mahasiswa` (
3  `npm` cahr(10) NOT NULL,
4  `nama` varchar(50) NOT NULL,
5  `tgl_lahir` date NOT NULL,
6  `jk` char(1) NOT NULL,
7  `alamat` varchar(100) NOT NULL,
8  `no_telp` varchar(15) NOT NULL,
9  `foto` varchar(100) NOT NULL
10) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
11
12INSERT INTO `mahasiswa` (`npm`, `nama`, `tgl_lahir`, `jk`, `alamat`, `no_telp`, `foto`) VALUES
13('17.02.0152', 'Bowo', '13-02-1995', 1, 'Sidoarjo', '08765432112', 'foto-0152.jpg');
14
15
16-------------------------------------------------------------------------
17
18
19CREATE TABLE IF NOT EXISTS `presensi` (
20  `npm` char(10) NOT NULL,
21  `tgl` date NOT NULL,
22  `jam_msk` time NOT NULL,
23  `jam_keluar` time NOT NULL
24) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
25
26INSERT INTO `presensi` (`npm`, `tgl`, `jam_msk`, `jam_keluar`) VALUES
27('17.02.0152', '19-07-2018', '15:00:00', '18:00:00');
28
29-------------------------------------------------------------------------
30
31ALTER TABLE `presensi`
32ADD PRIMARY KEY (`npm`);