· 4 years ago · May 09, 2021, 07:32 AM
1--
2--
3-- Leaked By Mr.MF33
4-- 09 mei 2021
5--
6--
7
8
9SET NAMES utf8;
10SET time_zone = '+00:00';
11SET foreign_key_checks = 0;
12SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
13
14DROP TABLE IF EXISTS `tabel_pegawai`;
15CREATE TABLE `tabel_pegawai` (
16 `id_pegawai` int(4) NOT NULL AUTO_INCREMENT,
17 `nama_pegawai` varchar(100) NOT NULL,
18 `jabatan_pegawai` enum('Kepala Stasiun','Kasubag Tata Usaha','Kasie Data dan Informasi','Kasie Observasi','Staff Fungsional','Staff') NOT NULL,
19 `foto_pegawai` varchar(100) NOT NULL,
20 PRIMARY KEY (`id_pegawai`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23TRUNCATE `tabel_pegawai`;
24INSERT INTO `tabel_pegawai` (`id_pegawai`, `nama_pegawai`, `jabatan_pegawai`, `foto_pegawai`) VALUES
25(2, 'Budi Satria, S.Si', 'Kepala Stasiun', 'pak budi.png'),
26(3, 'Elisabeth Elwarin, S.Si', 'Kasubag Tata Usaha', 'WhatsApp Image 2018-05-25 at 07.24.59(2).jpeg'),
27(5, 'Merpati T. Nalle', 'Kasie Observasi', 'WhatsApp Image 2018-05-25 at 07.19.26(1).jpeg'),
28(6, 'Nelce Sesa', 'Staff', 'WhatsApp Image 2018-05-25 at 07.24.59(12).jpeg'),
29(8, 'Akhmad Fatony, S.Tr', 'Staff Fungsional', 'IMG-20180423-WA0050.jpg'),
30(9, 'Khanifan Setiawan, S.Tr', 'Staff Fungsional', 'WhatsApp Image 2018-05-25 at 07.24.59(11).jpeg'),
31(10, 'Rizka Agathy Putri, S.Tr', 'Staff Fungsional', 'WhatsApp Image 2018-05-25 at 07.24.59(8).jpeg'),
32(11, 'Nuryanto, S.Tr', 'Staff Fungsional', 'IMG-20180423-WA0048.jpg'),
33(12, 'Ayu Diah Syafaati, S.Si', 'Staff Fungsional', 'WhatsApp Image 2018-05-25 at 07.24.59(1).jpeg'),
34(13, 'Agatha Beny Himawan, S.Kom', 'Staff Fungsional', 'WhatsApp Image 2018-05-25 at 07.20.56.jpg'),
35(14, 'Yuristi Firanozi', 'Staff', '123.jpeg'),
36(15, 'Siti Najma Nindya Utami', 'Staff', 'IMG-20181022-WA0003.jpg');
37
38-- 2021-05-09 07:23:12
39