DROP TABLE app;

CREATE TABLE `app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama_aplikasi` varchar(255) DEFAULT NULL,
  `nama_perusahaan` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `hp` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `nama_aplikasi` (`nama_aplikasi`),
  KEY `nama_perusahaan` (`nama_perusahaan`),
  KEY `logo` (`logo`),
  KEY `alamat` (`alamat`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO app VALUES("1","Aplikasi SI-SUKI","KPP Pratama Bengkalis","logo.jpg","Komplek Mall Mandau City Kav. 109 Basement Blok B03,Kec. Mandau, Kabupaten Bengkalis, Riau 28784","","(0765) 94531");



DROP TABLE foto;

CREATE TABLE `foto` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nm_foto` varchar(100) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `foto` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `nm_foto` (`nm_foto`),
  KEY `tanggal` (`tanggal`),
  KEY `foto` (`foto`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO foto VALUES("6","Kinerja Maret","2022-03-21","f0321132000.Black Friday Gift Voucher Template (12.3 x 3.9 in) (Dokumen A4) (2).png");



DROP TABLE kegiatan;

CREATE TABLE `kegiatan` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_surat` varchar(30) DEFAULT NULL,
  `no_surat` varchar(30) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `tujuan` varchar(100) DEFAULT NULL,
  `kendaraan` varchar(30) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Belum Transfer',
  `tanggal_pembayaran` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_surat` (`id_surat`),
  KEY `no_surat` (`no_surat`),
  KEY `tanggal` (`tanggal`),
  KEY `tujuan` (`tujuan`),
  KEY `kendaraan` (`kendaraan`),
  KEY `status` (`status`),
  KEY `tanggal_pembayaran` (`tanggal_pembayaran`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO kegiatan VALUES("2","1647438842","ST-001/xxx/xxx/2012","2022-03-04","kantor test 1e","BH123EYD","Sudah Transfer","2022-03-30");
INSERT INTO kegiatan VALUES("4","1647444014","ST-001/xxx/xxx/20122123","2022-03-12","","","Belum Transfer","");



DROP TABLE level;

CREATE TABLE `level` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kd_level` varchar(20) DEFAULT NULL,
  `nm_level` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

INSERT INTO level VALUES("3","administrator","Administrator");
INSERT INTO level VALUES("4","admin","Admin");



DROP TABLE peserta;

CREATE TABLE `peserta` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_surat` varchar(30) DEFAULT NULL,
  `id_user` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_surat` (`id_surat`),
  KEY `id_user` (`id_user`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO peserta VALUES("6","1647438842","1");
INSERT INTO peserta VALUES("7","1647438842","2");
INSERT INTO peserta VALUES("8","1647438842","3");
INSERT INTO peserta VALUES("9","1647438842","4");
INSERT INTO peserta VALUES("10","1647438842","5");
INSERT INTO peserta VALUES("11","1647438842","6");
INSERT INTO peserta VALUES("12","1647438842","7");
INSERT INTO peserta VALUES("13","1647444014","31");
INSERT INTO peserta VALUES("14","1647444014","32");
INSERT INTO peserta VALUES("15","1647444014","33");



DROP TABLE user;

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `nama` varchar(150) DEFAULT NULL,
  `jabatan` varchar(100) DEFAULT NULL,
  `status` varchar(2) DEFAULT NULL,
  `level` varchar(100) DEFAULT NULL,
  `bagian` varchar(25) DEFAULT NULL,
  `perusahaan` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `username` (`username`),
  KEY `password` (`password`),
  KEY `nama` (`nama`),
  KEY `jabatan` (`jabatan`),
  KEY `status` (`status`),
  KEY `level` (`level`),
  KEY `bagian` (`bagian`),
  KEY `perusahaan` (`perusahaan`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4;

INSERT INTO user VALUES("1","001","202cb962ac59075b964b07152d234b70","EKO CAHYO WICAKSONO","","1","staf","","");
INSERT INTO user VALUES("2","002","202cb962ac59075b964b07152d234b70","FITHRI SARRAH LUBIS","","1","staf","","");
INSERT INTO user VALUES("3","003","202cb962ac59075b964b07152d234b70","SOFIA ROSMAYANTI","","1","staf","","");
INSERT INTO user VALUES("4","004","202cb962ac59075b964b07152d234b70","ARIS PRIYANTO","","1","staf","","");
INSERT INTO user VALUES("5","005","202cb962ac59075b964b07152d234b70","TEGUH ARIANTO","","1","staf","","");
INSERT INTO user VALUES("6","006","202cb962ac59075b964b07152d234b70","SEFI UTAMA","","1","staf","","");
INSERT INTO user VALUES("7","007","202cb962ac59075b964b07152d234b70","BRAMANTYO PANCARING TYASTOMO","","1","staf","","");
INSERT INTO user VALUES("8","008","202cb962ac59075b964b07152d234b70","INDRADI","","1","staf","","");
INSERT INTO user VALUES("9","009","202cb962ac59075b964b07152d234b70","PRADANA WIRABADI ROHMAN","","1","staf","","");
INSERT INTO user VALUES("10","010","202cb962ac59075b964b07152d234b70","TRISNA SENA","","1","staf","","");
INSERT INTO user VALUES("11","011","202cb962ac59075b964b07152d234b70","ANNA RIYANTI DEWI","","1","staf","","");
INSERT INTO user VALUES("12","012","202cb962ac59075b964b07152d234b70","HENRY ROTUAHMAN MANIK","","1","staf","","");
INSERT INTO user VALUES("13","013","202cb962ac59075b964b07152d234b70","FRANS JHON SUKSES TARIGAN","","1","staf","","");
INSERT INTO user VALUES("14","014","202cb962ac59075b964b07152d234b70","M. HERMAN","","1","staf","","");
INSERT INTO user VALUES("15","015","202cb962ac59075b964b07152d234b70","RADEN INDRA YOGASWARA","","1","staf","","");
INSERT INTO user VALUES("16","016","202cb962ac59075b964b07152d234b70","M. ALI HASAN","","1","staf","","");
INSERT INTO user VALUES("17","017","202cb962ac59075b964b07152d234b70","BOBBY YANDOKO DWI SAPUTRA","","1","staf","","");
INSERT INTO user VALUES("18","018","202cb962ac59075b964b07152d234b70","FIRMAN","","1","staf","","");
INSERT INTO user VALUES("19","019","202cb962ac59075b964b07152d234b70","HERRU IMANZA","","1","staf","","");
INSERT INTO user VALUES("20","020","202cb962ac59075b964b07152d234b70","ANTONIUS SINABUTAR","","1","staf","","");
INSERT INTO user VALUES("21","021","202cb962ac59075b964b07152d234b70","KATRYN NOVELINA","","1","staf","","");
INSERT INTO user VALUES("22","022","202cb962ac59075b964b07152d234b70","HARVIANDI GUSTIAN","","1","staf","","");
INSERT INTO user VALUES("23","023","202cb962ac59075b964b07152d234b70","SAKTI MUDA MANURUNG","","1","staf","","");
INSERT INTO user VALUES("24","024","202cb962ac59075b964b07152d234b70","ISFAN DWI FEBRIA PUTRA","","1","staf","","");
INSERT INTO user VALUES("25","025","202cb962ac59075b964b07152d234b70","NIZAR WIRATAMA","","1","staf","","");
INSERT INTO user VALUES("26","026","202cb962ac59075b964b07152d234b70","RENDIKA PRADHANA PUTRA","","1","staf","","");
INSERT INTO user VALUES("27","027","202cb962ac59075b964b07152d234b70","ALIF ISLAMIYANA ISKANDAR PUTRA","","1","staf","","");
INSERT INTO user VALUES("28","028","202cb962ac59075b964b07152d234b70","MARTHIN TULUS PRAMONO","","1","staf","","");
INSERT INTO user VALUES("29","029","202cb962ac59075b964b07152d234b70","ANDY ANUGRAH","","1","staf","","");
INSERT INTO user VALUES("30","030","202cb962ac59075b964b07152d234b70","LULUK ARDHINI MUSTAWAVINA","","1","staf","","");
INSERT INTO user VALUES("31","031","202cb962ac59075b964b07152d234b70","AISHA LUTHFIA FIRDAUSI","","1","staf","","");
INSERT INTO user VALUES("32","032","202cb962ac59075b964b07152d234b70","IRLANDIA RANTING","","1","staf","","");
INSERT INTO user VALUES("33","033","202cb962ac59075b964b07152d234b70","DEDE CAHYANTO","","1","staf","","");
INSERT INTO user VALUES("34","034","202cb962ac59075b964b07152d234b70","RAMANDA MAULANA SURI","","1","staf","","");
INSERT INTO user VALUES("35","035","202cb962ac59075b964b07152d234b70","AGUNG HERLAMBANG","","1","staf","","");
INSERT INTO user VALUES("36","036","202cb962ac59075b964b07152d234b70","ADYTIA PANDIA","","1","staf","","");
INSERT INTO user VALUES("37","037","202cb962ac59075b964b07152d234b70","HANAN YOGA PRASETYO","","1","staf","","");
INSERT INTO user VALUES("38","038","202cb962ac59075b964b07152d234b70","SIGIT SUJADMIKO","","1","staf","","");
INSERT INTO user VALUES("39","039","202cb962ac59075b964b07152d234b70","PRADIPTA RIVANDA MUHAMMAD","","1","staf","","");
INSERT INTO user VALUES("40","040","202cb962ac59075b964b07152d234b70","REFO NEGORO ABRARADI","","1","staf","","");
INSERT INTO user VALUES("41","041","202cb962ac59075b964b07152d234b70","LUTFAN ABDULGANI","","1","staf","","");
INSERT INTO user VALUES("42","042","202cb962ac59075b964b07152d234b70","WAHYU RAMADHAN KALOKO","","1","staf","","");
INSERT INTO user VALUES("43","043","202cb962ac59075b964b07152d234b70","MUHAMMAD ICHWAN","","1","staf","","");
INSERT INTO user VALUES("44","044","202cb962ac59075b964b07152d234b70","HASBIUL HASHFI","","1","staf","","");
INSERT INTO user VALUES("45","045","202cb962ac59075b964b07152d234b70","MAMON WIJAYA DAELI","","1","staf","","");
INSERT INTO user VALUES("46","046","202cb962ac59075b964b07152d234b70","ANDIKA SEPTANUS KELIAT","","1","staf","","");
INSERT INTO user VALUES("47","047","202cb962ac59075b964b07152d234b70","HERIANSYAH HARAHAP","","1","staf","","");
INSERT INTO user VALUES("48","048","202cb962ac59075b964b07152d234b70","MUHAMMAD DHIEN LUBIS","","1","staf","","");
INSERT INTO user VALUES("49","049","202cb962ac59075b964b07152d234b70","SAHAT IVANSON SILALAHI","","1","staf","","");
INSERT INTO user VALUES("50","050","202cb962ac59075b964b07152d234b70","RESKY DWI HANDAYANI","","1","staf","","");
INSERT INTO user VALUES("51","051","202cb962ac59075b964b07152d234b70","GRACE YOLANDA RUMINTANG SIMANJUNTAK","","1","staf","","");
INSERT INTO user VALUES("52","052","202cb962ac59075b964b07152d234b70","NOVARIS VALENTINO","","1","staf","","");
INSERT INTO user VALUES("53","053","202cb962ac59075b964b07152d234b70","AHMAD BUKHARI","","1","staf","","");
INSERT INTO user VALUES("54","054","202cb962ac59075b964b07152d234b70","ASRI ANDRIANI","","1","staf","","");
INSERT INTO user VALUES("55","055","202cb962ac59075b964b07152d234b70","MUHAMMAD ARIF PRIBADI","","1","staf","","");
INSERT INTO user VALUES("56","056","202cb962ac59075b964b07152d234b70","DAVID NATAN UTOMO","","1","staf","","");
INSERT INTO user VALUES("57","057","202cb962ac59075b964b07152d234b70","MOCHAMMAD FAISHAL DWIYANTO","","1","staf","","");
INSERT INTO user VALUES("58","058","202cb962ac59075b964b07152d234b70","MUHAMMAD ILHAM","","1","staf","","");
INSERT INTO user VALUES("59","059","202cb962ac59075b964b07152d234b70","BUDI SURYADI","","1","staf","","");
INSERT INTO user VALUES("60","060","202cb962ac59075b964b07152d234b70","DENYBILL ANDREAS SEMBIRING","","1","staf","","");
INSERT INTO user VALUES("61","061","202cb962ac59075b964b07152d234b70","MUHAMMAD LUTHFA","","1","staf","","");
INSERT INTO user VALUES("62","062","202cb962ac59075b964b07152d234b70","YULITA MAROJAHAN MANURUNG","","1","staf","","");
INSERT INTO user VALUES("63","063","202cb962ac59075b964b07152d234b70","HANIF TRIANAPURNA JATMIKO","","1","staf","","");
INSERT INTO user VALUES("64","064","202cb962ac59075b964b07152d234b70","USA CANDRANINGTYAS","","1","staf","","");
INSERT INTO user VALUES("65","065","202cb962ac59075b964b07152d234b70","NADHA RIZQI ADZANI","","1","staf","","");
INSERT INTO user VALUES("66","066","202cb962ac59075b964b07152d234b70","ZAHRA NADYA","","1","staf","","");
INSERT INTO user VALUES("67","067","202cb962ac59075b964b07152d234b70","DICKY PRADANA PUTRA PRASETYA","","1","staf","","");
INSERT INTO user VALUES("68","068","202cb962ac59075b964b07152d234b70","WAHYU ADJIE RIZALDY","","1","staf","","");
INSERT INTO user VALUES("69","069","202cb962ac59075b964b07152d234b70","BOY SATRIA WIBOWO","","1","staf","","");
INSERT INTO user VALUES("70","070","202cb962ac59075b964b07152d234b70","ROY JOHANNES BUDIMAN MARBUN","","1","staf","","");
INSERT INTO user VALUES("71","071","202cb962ac59075b964b07152d234b70","NANANG HERMANA","","1","staf","","");
INSERT INTO user VALUES("72","072","202cb962ac59075b964b07152d234b70","HERISON SIMBOLON","","1","staf","","");
INSERT INTO user VALUES("73","073","202cb962ac59075b964b07152d234b70","HILMAN AFFANDI","","1","staf","","");
INSERT INTO user VALUES("74","074","202cb962ac59075b964b07152d234b70","DEDDY PAHOTAN","","1","staf","","");
INSERT INTO user VALUES("75","075","202cb962ac59075b964b07152d234b70","DWI LAKSONO KUNTORO PUTRA","","1","staf","","");
INSERT INTO user VALUES("76","076","202cb962ac59075b964b07152d234b70","ARIF HIDAYAT ASRI","","1","staf","","");
INSERT INTO user VALUES("77","077","202cb962ac59075b964b07152d234b70","SYAVINA ROSSYA","","1","staf","","");
INSERT INTO user VALUES("78","078","202cb962ac59075b964b07152d234b70","TOGU SITANGGANG","","1","staf","","");
INSERT INTO user VALUES("79","079","202cb962ac59075b964b07152d234b70","ASIDO SIANTURI","","1","staf","","");
INSERT INTO user VALUES("80","080","202cb962ac59075b964b07152d234b70","RAHADYAN ANDRIANTO WIBOWO","","1","staf","","");
INSERT INTO user VALUES("81","081","202cb962ac59075b964b07152d234b70","AGNES TIANI","","1","staf","","");
INSERT INTO user VALUES("82","082","202cb962ac59075b964b07152d234b70","RAMDONI JAYA SASMIKO","","1","staf","","");
INSERT INTO user VALUES("83","083","202cb962ac59075b964b07152d234b70","KHAIRUL HENDRA","","1","staf","","");
INSERT INTO user VALUES("84","084","202cb962ac59075b964b07152d234b70","SURYADI WIJAYA","","1","staf","","");
INSERT INTO user VALUES("85","085","202cb962ac59075b964b07152d234b70","RACHMAT MUSLIM","","1","staf","","");
INSERT INTO user VALUES("86","086","202cb962ac59075b964b07152d234b70","LATIFAH GINA FATMALA","","1","staf","","");
INSERT INTO user VALUES("87","087","202cb962ac59075b964b07152d234b70","RAMA ADI MUKTI","","1","staf","","");
INSERT INTO user VALUES("88","088","202cb962ac59075b964b07152d234b70","HENRY NUR WICAKSONO","","1","staf","","");
INSERT INTO user VALUES("89","089","202cb962ac59075b964b07152d234b70","FREDDY HEBRON SILITONGA","","1","staf","","");
INSERT INTO user VALUES("90","090","202cb962ac59075b964b07152d234b70","BINTANG SION","","1","staf","","");
INSERT INTO user VALUES("91","091","202cb962ac59075b964b07152d234b70","PUTRI T PARHUSIP","","1","staf","","");
INSERT INTO user VALUES("92","092","202cb962ac59075b964b07152d234b70","RATIH FEBRIANTY","","1","staf","","");
INSERT INTO user VALUES("93","093","202cb962ac59075b964b07152d234b70","HERIANTONIUS SILALAHI","","1","staf","","");
INSERT INTO user VALUES("94","094","202cb962ac59075b964b07152d234b70","JOHANNES SIHOTANG","","1","staf","","");
INSERT INTO user VALUES("95","095","202cb962ac59075b964b07152d234b70","DHYANNI ENDHY FAUZA","","1","staf","","");
INSERT INTO user VALUES("96","096","202cb962ac59075b964b07152d234b70","WELLY ANDRATAMA TANDIONO","","1","staf","","");
INSERT INTO user VALUES("97","097","202cb962ac59075b964b07152d234b70","RIZA NUGRAHA","","1","staf","","");
INSERT INTO user VALUES("98","098","202cb962ac59075b964b07152d234b70","DIONISIUS CHRISTIAN HAMDANY BARUS","","1","staf","","");
INSERT INTO user VALUES("99","099","202cb962ac59075b964b07152d234b70","NAZELLA SAM","","1","staf","","");
INSERT INTO user VALUES("100","100","202cb962ac59075b964b07152d234b70","ELFIKA APRIANI","","1","staf","","");
INSERT INTO user VALUES("101","101","202cb962ac59075b964b07152d234b70","YOZI ELMANZA KHAIRI","","1","staf","","");
INSERT INTO user VALUES("102","102","202cb962ac59075b964b07152d234b70","NOVRYADI SIDAURUK","","1","staf","","");
INSERT INTO user VALUES("103","103","202cb962ac59075b964b07152d234b70","JULI HARSONO DANIEL SIMANUNGKALIT","","1","staf","","");
INSERT INTO user VALUES("104","104","202cb962ac59075b964b07152d234b70","RUTH JANE OLIVIA","","1","staf","","");
INSERT INTO user VALUES("105","105","202cb962ac59075b964b07152d234b70","WAHYU SIDDIQ","","1","staf","","");
INSERT INTO user VALUES("106","106","202cb962ac59075b964b07152d234b70","FERI JOHANDI LASE","","1","staf","","");
INSERT INTO user VALUES("107","107","202cb962ac59075b964b07152d234b70","DEVON ARFENDO SIMAMORA","","1","staf","","");
INSERT INTO user VALUES("108","108","202cb962ac59075b964b07152d234b70","ASEP SAEFUL ROHMAN","","1","staf","","");
INSERT INTO user VALUES("109","109","202cb962ac59075b964b07152d234b70","MUHAMMAD ARIF AL GHOZALI","","1","staf","","");
INSERT INTO user VALUES("110","110","202cb962ac59075b964b07152d234b70","SATRIA BANGUN","","1","staf","","");
INSERT INTO user VALUES("111","admin","0192023a7bbd73250516f069df18b500","Administrator","","1","administrator","","");



