/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.19-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: pekanbaru_plc -- ------------------------------------------------------ -- Server version 10.11.19-MariaDB-ubu2404 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tbl_coaching` -- DROP TABLE IF EXISTS `tbl_coaching`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_coaching` ( `id_coaching` int(11) NOT NULL AUTO_INCREMENT, `kode` varchar(10) DEFAULT NULL, `nip` varchar(18) NOT NULL, `kode_jabatan` varchar(50) DEFAULT NULL, `atasan` varchar(18) DEFAULT NULL, `kode_jabatan_atasan` varchar(50) DEFAULT NULL, `tahun` year(4) NOT NULL, `gambaran_umum` text DEFAULT NULL, `rencana_6_bulan` text DEFAULT NULL, `rencana_1_tahun` text DEFAULT NULL, `gambaran_singkat` text DEFAULT NULL, `kompetensi` text DEFAULT NULL, `kinerja` text DEFAULT NULL, `cita_cita` text DEFAULT NULL, `pengembangan_1_bulan` text DEFAULT NULL, `pengembangan_3_bulan` text DEFAULT NULL, `pengembangan_6_bulan` text DEFAULT NULL, `pengembangan_1_tahun` text DEFAULT NULL, `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_coaching`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_coaching` -- LOCK TABLES `tbl_coaching` WRITE; /*!40000 ALTER TABLE `tbl_coaching` DISABLE KEYS */; INSERT INTO `tbl_coaching` VALUES (1,'VCVBEVFUMR','198709272014071001','01.01.05.06.','198304252006042008','01.01.05.',2022,NULL,NULL,NULL,'saya seorang yang memiliki rasa tanggungjawab penuh dalam mengerjakan suatu pekerjaan dan saya juga memiliki konsistensi yang tinggi dalam menyelesaikan pekerjaan serta mempunyai semangat belajar yang tinggi','saya memiliki kompetensi di Bidang Kediklatan, saya memahami proses Administrasi Jabatan Fungsional','saya merasa cukup dapat memberikan bimbingan dan memberikan arahan, tapi tidak menutup kemungkinan saya menginginkan tantangan baru dalam pekerjaan.','Menjadi Esselon III yang berkompeten sesuai dengan bidang dan kompetensi yang saya miliki','Mempelajari aturan dan kebijakan tentang kepegawaian','Mengimplementasikan aturan dan kebijakan yang berkaitan dengan kepegawaian dalam hal pelaksanaan tugas.','Melakukan evaluasi hasil pelaksanaan dari kebijakan yang berkaitan dengan kepegawaian dalam pelaksanaan tugas','Meningkatkan kinerja dalam pelaksanaan tugas untuk mencapai hasil yang maksimal','2022-10-12 08:04:21','2022-10-12 08:04:21',NULL), (2,'LYGZYHMUFR','198611162011021001','01.01.05.02.01.','198709272014071001','01.01.05.02.',2022,NULL,NULL,NULL,'123','123','123','123','123','123','123','123','2022-10-18 01:01:54','2022-10-18 01:01:54',NULL), (3,'GSHWADXPNM','198407132010012007','01.01.05.07.','198610272011021001','01.01.05.',2023,NULL,NULL,NULL,'Saya orang yang cepat beradaptasi, mampu menganalisis informasi dengan cepat dan dapat berpikir mandiri namun perlu adanya dorongan untuk mengeluarkan potensi yang saya miliki','mampu mendorong rekan kerja untuk bekerja dengan baik dan sistematis, dapat bekerjasama secara partisipatif dan efektif, dapat berkomunikasi dengan baik, bekerja untuk mencapai hasil yang baik, mampu mengawasi pekerjaan, cepat beradaptasi dengan perubahan, mampu menganalisis permasalahan, mempunyai sikap menghargai dan toleransi','selalu berusaha untuk mencapai hasil yang maksimal','menjadi pegawai yang kompeten dan profesional','mempelajari dan menguasai peraturan dan kebijakan di bidang pengembangan kompetensi aparatur','membantu menyusun rencana kegiatan di bidang pengembangan kompetensi aparatur','mampu bekerjasama dengan seluruh tim dalam kegiatan di bidang pengembangan kompetensi aparatur','mampu mengawasi pelaksanaan kegiatan dengan hasil yang maksimal','2023-03-14 05:43:33','2023-03-14 05:43:33',NULL); /*!40000 ALTER TABLE `tbl_coaching` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_kelas_online` -- DROP TABLE IF EXISTS `tbl_kelas_online`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_kelas_online` ( `id_kelas_online` int(11) NOT NULL AUTO_INCREMENT, `kode_jadwal_diklat` varchar(50) NOT NULL, `kode_kelas_online` varchar(50) NOT NULL, `pemateri` varchar(50) DEFAULT NULL, `title` text NOT NULL, `informasi` text NOT NULL, `materi` varchar(100) DEFAULT NULL, `keterangan` text NOT NULL, `waktu` datetime NOT NULL, `link_zoom` varchar(100) DEFAULT NULL, `selesai` int(11) NOT NULL DEFAULT 0, `created` timestamp NOT NULL DEFAULT current_timestamp(), `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_kelas_online`), UNIQUE KEY `kode_kelas_online` (`kode_kelas_online`), KEY `kode_jadwal_diklat` (`kode_jadwal_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=321 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_kelas_online` -- LOCK TABLES `tbl_kelas_online` WRITE; /*!40000 ALTER TABLE `tbl_kelas_online` DISABLE KEYS */; INSERT INTO `tbl_kelas_online` VALUES (320,'WNZKJSHMOVRHAZYPCJXO','XLHPWIESIE','-','Pre Test','1636359365','MATERI 1','

Link untuk pre test DISINI

','2023-06-10 03:40:43',NULL,0,'2023-06-09 20:40:43','2023-06-10 04:16:23',NULL); /*!40000 ALTER TABLE `tbl_kelas_online` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_kelas_online_tes` -- DROP TABLE IF EXISTS `tbl_kelas_online_tes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_kelas_online_tes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nip` varchar(18) NOT NULL, `id_materi_diklat` int(11) NOT NULL, `jawab` varchar(100) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT current_timestamp(), `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_kelas_online_tes` -- LOCK TABLES `tbl_kelas_online_tes` WRITE; /*!40000 ALTER TABLE `tbl_kelas_online_tes` DISABLE KEYS */; INSERT INTO `tbl_kelas_online_tes` VALUES (1,'198508032009021007',1,',,,,','2023-06-11 13:10:08',NULL,NULL); /*!40000 ALTER TABLE `tbl_kelas_online_tes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_kompetensi_pegawai` -- DROP TABLE IF EXISTS `tbl_kompetensi_pegawai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_kompetensi_pegawai` ( `id_kompetensi_pegawai` int(11) NOT NULL AUTO_INCREMENT, `kode` varchar(20) DEFAULT NULL, `id_jenis_kompetensi` int(11) NOT NULL, `jp` int(11) NOT NULL, `nip` varchar(18) NOT NULL, `kode_jabatan` varchar(250) NOT NULL, `nip_atasan` varchar(18) NOT NULL, `kode_jabatan_atasan` varchar(250) NOT NULL, `tanggal_pelaksanaan` date DEFAULT NULL, `tanggal_selesai` date DEFAULT NULL, `tempat_pelaksanaan` text DEFAULT NULL, `ringkasan_materi` text DEFAULT NULL, `laporan` varchar(20) DEFAULT NULL, `bukti` varchar(20) DEFAULT NULL, `sertifikat` varchar(20) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 0, `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_kompetensi_pegawai`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_kompetensi_pegawai` -- LOCK TABLES `tbl_kompetensi_pegawai` WRITE; /*!40000 ALTER TABLE `tbl_kompetensi_pegawai` DISABLE KEYS */; INSERT INTO `tbl_kompetensi_pegawai` VALUES (1,'OPGZAIJBRGYXUYSOZJUS',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2019-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1664943951','1663124348','1663124348',0,'2022-10-05 04:31:40','2022-10-12 06:49:18','2022-10-12 13:48:39'), (2,'PESDCRIUQJIRLNFXEAJL',7,2,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-05 04:35:05','2022-10-12 06:49:18','2022-10-12 13:48:39'), (3,'DWBNKBDKBWVELICJSWGO',7,2,'198304252006042008','01.01.05.','196303161986031010','01.01.','2022-10-06','2022-10-06','MANDIRI','PP 17 TAHUN 2020 TENTANG MANAJEMEN ASN','1665026075','1665026075','1665026075',0,'2022-10-06 03:17:15','2022-10-06 03:17:15',NULL), (4,'GUPWWAKCHAKNWUPYOFSP',3,0,'198304252006042008','01.01.05.','196303161986031010','01.01.','2022-01-10','2022-01-14','BKN REG 12','PELAKSANAAN MAGANG DI BKN REG XII','1665026075','1665026075','1665026075',0,'2022-10-06 03:32:32','2022-10-06 03:32:32',NULL), (5,'YYTNIVQUXLNHLVDNEEVE',4,3,'198304252006042008','01.01.05.','196303161986031010','01.01.','2022-10-04','2022-10-04','LAN','LAN','1665026075','1665026075','1665026075',0,'2022-10-06 03:35:14','2022-10-06 03:35:14',NULL), (6,'FXERRXQQXYXTGMWRMFSF',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665475377','1665475410','1665475435',0,'2022-10-11 08:04:14','2022-10-12 06:49:18','2022-10-12 13:48:39'), (7,'AILOTDSAIZRSRPEDMRKY',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665476693','1665476722','1665476744',0,'2022-10-11 08:25:58','2022-10-12 06:49:18','2022-10-12 13:48:39'), (8,'YSRBQKJRLPKLTORWUUXG',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665478538','1665478565','1665478586',0,'2022-10-11 08:56:37','2022-10-12 06:49:18','2022-10-12 13:48:39'), (9,'NBAEBYRMYJYMDYFESAHH',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665479226','1665479267','1665479292',0,'2022-10-11 09:08:27','2022-10-12 06:49:18','2022-10-12 13:48:39'), (10,'OHYRWPMUJNGWJAYGKEGG',3,0,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-12 03:06:35','2022-10-12 06:49:18','2022-10-12 13:48:39'), (11,'KLASZLQSDJKRODJVROTV',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665550179','1665550201','1665550222',0,'2022-10-12 04:50:36','2022-10-12 06:48:55','2022-10-12 13:48:39'), (12,'ZJCPTIDZYVYVYGNVADXN',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665551054','1665551078','1665551111',0,'2022-10-12 05:05:33','2022-10-12 06:49:18','2022-10-12 13:48:39'), (13,'LVVZZINKIUDFUYZPNQSA',7,2,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2022-09-10','2022-09-12','INDIVIDU','Isilah Kolom Ini Dengan Ringkasan Materi Belajar Mandiri Yang Telah Dipelajari','1665554130','1665554153',NULL,0,'2022-10-12 05:56:27','2022-10-12 06:49:18','2022-10-12 13:48:39'), (14,'GNHHDNEDVZJLNDIVDNOD',8,2,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2022-10-03','2022-10-07','KELOMPOK BELAJAR','Isilah Kolom Ini Dengan Ringkasan Materi Kelompok Belajar Yang Telah Di Pelajari Bersama-sama.','1665555180','1665555203',NULL,0,'2022-10-12 06:13:48','2022-10-12 06:49:18','2022-10-12 13:48:39'), (15,'UHEJECZVRBTRINHCFETH',4,3,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2021-11-16','2021-11-19','BKPSDM KOTA PEKANBARU','Penilaian Prestasi Kerja PNS Dan Penyusunan Sasaran Kerja Pegawai (SKP)','1665562157','1665562184','1665562201',0,'2022-10-12 08:10:24','2022-10-12 08:10:24',NULL), (16,'OFGHZSNCXYGLRFUMNQKO',7,2,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2022-09-07','2022-09-09','INDIVIDU','Isilah kolom ini dengan ringkasan materi belajar mandiri yang telah dipelajari','1665562368','1665562392',NULL,0,'2022-10-12 08:13:35','2022-10-12 08:13:35',NULL), (17,'GKGKUPNSCLDZQQZSWPHY',8,2,'198709272014071001','01.01.05.06.','198304252006042008','01.01.05.','2022-09-19','2022-09-23','KELOMPOK BELAJAR','Isilah kolom ini dengan ringkasan materi komunitas belajar yang telah dipelajari secara bersama-sama dan berkelompok','1665562708','1665562733',NULL,0,'2022-10-12 08:19:14','2022-10-12 08:19:14',NULL), (18,'USYVITOPNPBZDZEWHFOE',4,3,'198701052011022001','15.01.32.06.','197511142006041001','15.01.32.','2022-09-22','2022-09-22','BKPSDM Kota Pekanbaru','Sosialisasi Surat Edaran Menteri Pendayagunaan Aparatur Negara dan Reformasi Birokrasi No. 28 Tahun 2021 Tentang Pengembangan Kompetensi Bagi Pegawai Negeri Sipil Melalui Jalur Pendidikan',NULL,NULL,'1665973212',0,'2022-10-17 02:20:28','2022-10-17 02:20:28',NULL); /*!40000 ALTER TABLE `tbl_kompetensi_pegawai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_jadwal_diklat` -- DROP TABLE IF EXISTS `tbl_master_jadwal_diklat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_jadwal_diklat` ( `id_jadwal_diklat` int(11) NOT NULL AUTO_INCREMENT, `kode_jadwal_diklat` varchar(20) NOT NULL, `id_materi_diklat` int(11) NOT NULL, `tahun` int(11) NOT NULL, `periode` int(11) NOT NULL, `mulai` date NOT NULL, `berakhir` date NOT NULL, `created` datetime DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_jadwal_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_jadwal_diklat` -- LOCK TABLES `tbl_master_jadwal_diklat` WRITE; /*!40000 ALTER TABLE `tbl_master_jadwal_diklat` DISABLE KEYS */; INSERT INTO `tbl_master_jadwal_diklat` VALUES (1,'WNZKJSHMOVRHAZYPCJXO',1,2022,1,'2023-06-09','2023-06-14','2022-10-05 01:26:49','2023-06-10 02:42:24',NULL); /*!40000 ALTER TABLE `tbl_master_jadwal_diklat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_jenis_diklat` -- DROP TABLE IF EXISTS `tbl_master_jenis_diklat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_jenis_diklat` ( `id_jenis_diklat` int(11) NOT NULL AUTO_INCREMENT, `jenis_diklat` varchar(500) NOT NULL, `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_jenis_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_jenis_diklat` -- LOCK TABLES `tbl_master_jenis_diklat` WRITE; /*!40000 ALTER TABLE `tbl_master_jenis_diklat` DISABLE KEYS */; INSERT INTO `tbl_master_jenis_diklat` VALUES (1,'Diklat Teknis','2021-10-07 11:07:44','2021-10-06 21:07:44',NULL), (2,'Diklat Fungsional','2021-10-07 11:07:44','2021-10-06 21:07:44',NULL), (3,'Diklat Sosial Kultural','2021-10-07 11:08:10','2021-10-06 21:08:10',NULL), (4,'Diklat Kepemimpinan','2021-10-07 11:08:10','2021-10-06 21:08:10',NULL); /*!40000 ALTER TABLE `tbl_master_jenis_diklat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_jenis_kompetensi` -- DROP TABLE IF EXISTS `tbl_master_jenis_kompetensi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_jenis_kompetensi` ( `id_jenis_kompetensi` int(11) NOT NULL AUTO_INCREMENT, `kompetensi` varchar(200) NOT NULL, `jp` int(11) NOT NULL, `created` datetime DEFAULT NULL, `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_jenis_kompetensi`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_jenis_kompetensi` -- LOCK TABLES `tbl_master_jenis_kompetensi` WRITE; /*!40000 ALTER TABLE `tbl_master_jenis_kompetensi` DISABLE KEYS */; INSERT INTO `tbl_master_jenis_kompetensi` VALUES (1,'Diklat Online (pilihan wajib)',0,NULL,NULL,NULL), (2,'Coaching / mentoring (pilihan wajib)',2,NULL,'2022-10-05 02:30:49',NULL), (3,'Praktek Kerja Magang',0,NULL,NULL,NULL), (4,'E-Learning',3,'0000-00-00 00:00:00','2022-10-05 02:29:26',NULL), (5,'Pertukanaran Pegawai',0,NULL,NULL,NULL), (6,'Studi Banding / Benchmark',0,NULL,NULL,NULL), (7,'Belajar mandiri (self development)',2,NULL,'2022-10-05 02:29:35',NULL), (8,'Komunitas Belajar',2,NULL,'2022-10-05 02:30:45',NULL); /*!40000 ALTER TABLE `tbl_master_jenis_kompetensi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_kategori_diklat` -- DROP TABLE IF EXISTS `tbl_master_kategori_diklat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_kategori_diklat` ( `id_kategori_diklat` int(11) NOT NULL AUTO_INCREMENT, `id_jenis_diklat` int(11) NOT NULL, `kategori_diklat` text NOT NULL, `created` datetime DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_kategori_diklat`), KEY `fk_nama_jenis_diklat` (`id_jenis_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_kategori_diklat` -- LOCK TABLES `tbl_master_kategori_diklat` WRITE; /*!40000 ALTER TABLE `tbl_master_kategori_diklat` DISABLE KEYS */; INSERT INTO `tbl_master_kategori_diklat` VALUES (1,1,'Diklat Teknis Manajemen Kepegawaian','2022-10-05 01:17:39','2022-10-05 01:17:39',NULL), (2,2,'Diklat Pranata Komputer','2024-05-08 04:40:10','2024-05-08 04:40:10',NULL), (3,1,'yumkcymkcyvmky,l','2025-08-07 04:24:43','2025-08-07 04:24:43',NULL); /*!40000 ALTER TABLE `tbl_master_kategori_diklat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_kategori_diklat_opd` -- DROP TABLE IF EXISTS `tbl_master_kategori_diklat_opd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_kategori_diklat_opd` ( `id_kategori_diklat_opd` int(11) NOT NULL AUTO_INCREMENT, `id_kategori_diklat` int(11) NOT NULL, `id_opd` int(11) NOT NULL, `created` datetime DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_kategori_diklat_opd`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_kategori_diklat_opd` -- LOCK TABLES `tbl_master_kategori_diklat_opd` WRITE; /*!40000 ALTER TABLE `tbl_master_kategori_diklat_opd` DISABLE KEYS */; INSERT INTO `tbl_master_kategori_diklat_opd` VALUES (1,1,1,'2022-10-05 01:23:52','2023-06-09 04:32:14',NULL), (2,1,2,'2022-10-06 01:43:55','0000-00-00 00:00:00',NULL), (3,1,3,'2022-10-06 01:43:59','0000-00-00 00:00:00',NULL); /*!40000 ALTER TABLE `tbl_master_kategori_diklat_opd` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_materi_diklat` -- DROP TABLE IF EXISTS `tbl_master_materi_diklat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_materi_diklat` ( `id_materi_diklat` int(11) NOT NULL AUTO_INCREMENT, `id_kategori_diklat` int(11) NOT NULL, `materi_diklat` text NOT NULL, `waktu_pre_test` int(11) NOT NULL DEFAULT 60, `created` timestamp NOT NULL DEFAULT current_timestamp(), `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_materi_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_materi_diklat` -- LOCK TABLES `tbl_master_materi_diklat` WRITE; /*!40000 ALTER TABLE `tbl_master_materi_diklat` DISABLE KEYS */; INSERT INTO `tbl_master_materi_diklat` VALUES (1,1,'Pelatihan Teknis Manajemen ASN',60,'2022-10-04 18:26:14',NULL,NULL), (2,2,'analisa pranata komputer',60,'2024-05-07 21:42:05',NULL,NULL), (3,1,'manajemen pppk',60,'2024-05-07 22:09:18',NULL,NULL); /*!40000 ALTER TABLE `tbl_master_materi_diklat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_materi_diklat_jabatan` -- DROP TABLE IF EXISTS `tbl_master_materi_diklat_jabatan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_materi_diklat_jabatan` ( `id_materi_diklat_jabatan` int(11) NOT NULL AUTO_INCREMENT, `id_materi_diklat` int(11) NOT NULL, `id_opd` int(11) NOT NULL, `id_opd_jabatan` varchar(50) NOT NULL, `created` datetime NOT NULL, `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_materi_diklat_jabatan`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_materi_diklat_jabatan` -- LOCK TABLES `tbl_master_materi_diklat_jabatan` WRITE; /*!40000 ALTER TABLE `tbl_master_materi_diklat_jabatan` DISABLE KEYS */; INSERT INTO `tbl_master_materi_diklat_jabatan` VALUES (1,1,1,'2','2023-06-10 02:55:27',NULL,NULL), (2,1,1,'1210338','2023-06-10 02:55:59','2023-06-11 03:15:28',NULL), (3,1,1,'26','2024-05-08 05:05:29',NULL,NULL), (4,1,1,'10263','2024-05-08 05:05:30',NULL,NULL); /*!40000 ALTER TABLE `tbl_master_materi_diklat_jabatan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_master_soal` -- DROP TABLE IF EXISTS `tbl_master_soal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_master_soal` ( `id_soal` int(11) NOT NULL AUTO_INCREMENT, `id_materi_diklat` int(11) NOT NULL, `soal` text NOT NULL, `a` text NOT NULL, `b` text NOT NULL, `c` text NOT NULL, `d` text NOT NULL, `e` text NOT NULL, `kunci_jawaban` varchar(1) NOT NULL, `gambar` varchar(100) DEFAULT NULL, `aktif` int(11) NOT NULL DEFAULT 1, `pre_test` int(11) NOT NULL DEFAULT 1, `created` timestamp NOT NULL DEFAULT current_timestamp(), `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_soal`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_master_soal` -- LOCK TABLES `tbl_master_soal` WRITE; /*!40000 ALTER TABLE `tbl_master_soal` DISABLE KEYS */; INSERT INTO `tbl_master_soal` VALUES (1,1,'VOC Masuk ke Indonesia pada tahun…','1601','1602','1603','1604','1605','a',NULL,1,1,'2023-06-08 20:31:51','2023-06-11 05:31:06',NULL), (2,1,'pada massa Kolonial Belanda yang dipimpin oleh Deandles (1801-1811) mempunyai kebijakan sebagai berikut, KECUALI…','Memberantas Feodalisme','membentuk tantara pribumi','mensejahterahkan rakyat','Membuat jalan-anyer panarukan','mempentuk tiga peradilan','c',NULL,1,1,'2023-06-08 20:32:32','2023-06-11 05:30:59',NULL), (3,1,'Batavia sempat jatuh ke tangan Inggris yang dipimpin oleh Raffles yang mempunyai kebijakan sebagai berikut, KECUALI…','Sewa tanah','Tidak ada kerja Rodi','Menghapus Pajak','Tidak ada monopoli','Membuat jalan Anyer-Panarukan','e',NULL,1,1,'2023-06-08 20:35:14','2023-06-11 05:33:06',NULL), (4,1,'Kebijakan Tanam Paksa yang diterapkan pemerintah kolonial pada abad Ke-19 di Indonesia saat masa kekuasaan…','Max Havelar','Johannes Bosch','Deandles','Jansen','Alexander W F','b',NULL,1,1,'2023-06-10 11:32:35','2023-06-11 05:34:31',NULL), (5,3,'apa itu pppk','pegawai asn dengan perjanjian kerja','pegawai negeri sipil','pegawai honorer','tenaga harian lepas','tenaga ahli','a',NULL,1,1,'2024-05-07 22:13:24',NULL,NULL), (6,3,'bagaimana pengadaan pppk','rekruitmen langsung oleh instansi','rekruitmen yang dilakukan secara nasional','bla bla','bisa','saja','b',NULL,1,1,'2024-05-07 22:14:37',NULL,NULL); /*!40000 ALTER TABLE `tbl_master_soal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_permohonan_diklat` -- DROP TABLE IF EXISTS `tbl_permohonan_diklat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_permohonan_diklat` ( `id_permohonan_diklat` int(11) NOT NULL AUTO_INCREMENT, `id_jadwal_diklat` int(11) DEFAULT NULL, `id_materi_diklat` int(11) DEFAULT NULL, `nip` varchar(18) NOT NULL, `status` enum('pengajuan','aktif','selesai','ditolak') NOT NULL DEFAULT 'pengajuan', `created` datetime DEFAULT NULL, `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_permohonan_diklat`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_permohonan_diklat` -- LOCK TABLES `tbl_permohonan_diklat` WRITE; /*!40000 ALTER TABLE `tbl_permohonan_diklat` DISABLE KEYS */; INSERT INTO `tbl_permohonan_diklat` VALUES (1,1,1,'198508032009021007','aktif','2022-10-05 01:27:29','2023-06-10 02:41:43',NULL), (2,1,1,'198211032012121001','aktif','2022-10-10 02:05:19','2023-06-09 03:41:50',NULL), (3,1,1,'197612142000031004','aktif','2022-12-14 12:30:50','2023-06-09 03:41:48',NULL), (4,1,1,'198909232020121007','aktif','2023-06-09 03:41:07','2023-06-09 03:41:44',NULL), (5,1,1,'199409112020121015','aktif','2024-05-08 05:06:00','2024-05-08 05:10:28',NULL); /*!40000 ALTER TABLE `tbl_permohonan_diklat` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-08-22 11:51:32