-- Table structure for table `tweb_wil_clusterdesa`
--

CREATE TABLE `tweb_wil_clusterdesa` (
  `id` int(11) NOT NULL,
  `config_id` int(11) DEFAULT NULL,
  `rt` varchar(10) NOT NULL DEFAULT '0',
  `rw` varchar(10) NOT NULL DEFAULT '0',
  `dusun` varchar(50) NOT NULL DEFAULT '0',
  `id_kepala` int(11) DEFAULT NULL,
  `lat` varchar(20) DEFAULT NULL,
  `lng` varchar(20) DEFAULT NULL,
  `zoom` int(11) DEFAULT NULL,
  `path` mediumtext DEFAULT NULL,
  `map_tipe` varchar(20) DEFAULT NULL,
  `warna` varchar(25) DEFAULT NULL,
  `urut` int(11) DEFAULT NULL,
  `urut_cetak` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tweb_wil_clusterdesa`
--

INSERT INTO `tweb_wil_clusterdesa` (`id`, `config_id`, `rt`, `rw`, `dusun`, `id_kepala`, `lat`, `lng`, `zoom`, `path`, `map_tipe`, `warna`, `urut`, `urut_cetak`) VALUES
(47, 1, '0', '0', '01 JEUNGJING', 334, NULL, NULL, 13, '', NULL, '', 1, 1),
(48, 1, '0', '-', '01 JEUNGJING', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2),
(49, 1, '-', '-', '01 JEUNGJING', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3),
(53, 1, '0', '0', '03 DAYEUHMANGGUNG', 201, NULL, NULL, NULL, NULL, NULL, NULL, 3, 37),
(54, 1, '0', '-', '03 DAYEUHMANGGUNG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 38),
(55, 1, '-', '-', '03 DAYEUHMANGGUNG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 39),
(56, 1, '0', '0', '02 CISANYOH', 337, NULL, NULL, NULL, NULL, NULL, NULL, 2, 17),
(57, 1, '0', '-', '02 CISANYOH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18),
(58, 1, '-', '-', '02 CISANYOH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19),
(77, 1, '0', '01', '01 JEUNGJING', 1758, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4),
(78, 1, '-', '01', '01 JEUNGJING', 311, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5),
(79, 1, '01', '01', '01 JEUNGJING', 245, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6),
(80, 1, '0', '02', '01 JEUNGJING', 134, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11),
(81, 1, '-', '02', '01 JEUNGJING', 134, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12),
(82, 1, '02', '01', '01 JEUNGJING', 321, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7),
(83, 1, '03', '01', '01 JEUNGJING', 322, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8),
(84, 1, '04', '01', '01 JEUNGJING', 1799, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9),
(85, 1, '05', '01', '01 JEUNGJING', 324, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10),
(86, 1, '01', '02', '01 JEUNGJING', 2413, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13),
(87, 1, '02', '02', '01 JEUNGJING', 2282, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14),
(88, 1, '03', '02', '01 JEUNGJING', 3436, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15),
(89, 1, '04', '02', '01 JEUNGJING', 154, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16),
(90, 1, '0', '04', '02 CISANYOH', 336, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20),
(91, 1, '-', '04', '02 CISANYOH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 21),
(92, 1, '0', '05', '02 CISANYOH', 1069, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25),
(93, 1, '-', '05', '02 CISANYOH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 26),
(94, 1, '0', '06', '02 CISANYOH', 340, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 31),
(95, 1, '-', '06', '02 CISANYOH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 32),
(96, 1, '01', '04', '02 CISANYOH', 343, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 22),
(97, 1, '02', '04', '02 CISANYOH', 344, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 23),
(98, 1, '03', '04', '02 CISANYOH', 345, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24),
(99, 1, '01', '05', '02 CISANYOH', 346, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27),
(100, 1, '02', '05', '02 CISANYOH', 424, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 28),
(101, 1, '03', '05', '02 CISANYOH', 3591, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 29),
(102, 1, '04', '05', '02 CISANYOH', 349, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30),
(103, 1, '01', '06', '02 CISANYOH', 619, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 33),
(104, 1, '02', '06', '02 CISANYOH', 486, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 34),
(105, 1, '03', '06', '02 CISANYOH', 352, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35),
(106, 1, '04', '06', '02 CISANYOH', 353, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36),
(107, 1, '0', '03', '03 DAYEUHMANGGUNG', 335, NULL, NULL, NULL, NULL, NULL, NULL, 3, 41),
(108, 1, '-', '03', '03 DAYEUHMANGGUNG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42),
(109, 1, '0', '07', '03 DAYEUHMANGGUNG', 341, NULL, NULL, NULL, NULL, NULL, NULL, 2, 46),
(110, 1, '-', '07', '03 DAYEUHMANGGUNG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 47),
(111, 1, '0', '08', '03 DAYEUHMANGGUNG', 2632, NULL, NULL, NULL, NULL, NULL, NULL, 4, 51),
(112, 1, '-', '08', '03 DAYEUHMANGGUNG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 52),
(113, 1, '01', '03', '03 DAYEUHMANGGUNG', 355, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 43),
(114, 1, '02', '03', '03 DAYEUHMANGGUNG', 356, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 44),
(115, 1, '03', '03', '03 DAYEUHMANGGUNG', 357, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45),
(116, 1, '01', '07', '03 DAYEUHMANGGUNG', 354, NULL, NULL, NULL, NULL, NULL, NULL, 2, 48),
(117, 1, '02', '07', '03 DAYEUHMANGGUNG', 358, NULL, NULL, NULL, NULL, NULL, NULL, 3, 49),
(118, 1, '03', '07', '03 DAYEUHMANGGUNG', 359, NULL, NULL, NULL, NULL, NULL, NULL, 4, 50),
(119, 1, '01', '08', '03 DAYEUHMANGGUNG', 2643, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 53),
(120, 1, '02', '08', '03 DAYEUHMANGGUNG', 361, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 54),
(121, 1, '03', '08', '03 DAYEUHMANGGUNG', 2602, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 55);

-- --------------------------------------------------------

--
-- Table structure for table `urls`
--

CREATE TABLE `urls` (
  `id` int(11) NOT NULL,
  `config_id` int(11) DEFAULT NULL,
  `url` varchar(255) NOT NULL,
  `alias` varchar(100) NOT NULL,
  `created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `config_id` int(11) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `id_grup` int(11) DEFAULT NULL,
  `pamong_id` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `active` tinyint(1) UNSIGNED DEFAULT 0,
  `nama` varchar(50) DEFAULT NULL,
  `id_telegram` varchar(100) NOT NULL,
  `token` varchar(100) DEFAULT NULL,
  `token_exp` datetime DEFAULT NULL,
  `telegram_verified_at` datetime DEFAULT NULL,
  `notif_telegram` tinyint(1) NOT NULL DEFAULT 0,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `foto` varchar(100) DEFAULT 'kuser.png',
  `session` varchar(40) NOT NULL,
  `batasi_wilayah` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `akses_wilayah` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `config_id`, `username`, `password`, `id_grup`, `pamong_id`, `email`, `last_login`, `email_verified_at`, `active`, `nama`, `id_telegram`, `token`, `token_exp`, `telegram_verified_at`, `notif_telegram`, `company`, `phone`, `foto`, `session`, `batasi_wilayah`, `akses_wilayah`) VALUES
(1, 1, 'admin', '$2y$10$vlecY0w.VWVNx9k1xpSVoeZRPBxAYSEgiFmR4Z47BxG/pe4ZCm4ka', 1, NULL, 'segitigaproject07@gmail.com', '2026-06-08 14:05:06', NULL, 1, 'Administrator', '0', NULL, NULL, NULL, 0, 'ADMIN', '088802175324', 'favicon.png', 'a8d4080245664ed2049c1b2ded7cac30', 0, NULL),
(2, 1, 'admin2', '$2y$10$zsrArXd9KJgJ0NiRuJ5xvOaDm6RQ/DL.1VvzlSm1yROtipDRjLSYy', 1, NULL, NULL, '2023-11-16 19:20:12', NULL, 1, 'Admin dua', '0', NULL, NULL, NULL, 0, NULL, '', 'images__1__removebg_preview__sid__nmEOqU4.png', 'b6caabd51c0d30c0990abb7b298982d8', 0, NULL),
(3, 1, 'evisobirin', '$2y$10$GcPFez0v5.Om1UVwuy.qDOiRQm7b4ujkiDBHsYv./cblE0PCHa3hm', 2, 27, 'evi.sobirin89@gmail.com', '2026-04-23 09:49:21', NULL, 1, 'EVI SOBIRIN, S.M', '0', NULL, NULL, NULL, 0, NULL, '085220746038', '17558612443__sid__B8XiIQz.png', '96824f2cb1b84849e679573543d895e1', 0, NULL),
(4, 1, 'widiyawidartika', '$2y$10$FkAPnntYpVo3ahOq.gcBu.Ujs7KkuVYVYRnt9rdStuFGH1CAtOaoW', 2, 29, NULL, '2024-03-06 02:30:19', NULL, 1, 'WIDIYA WIDARTIKA', '0', NULL, NULL, NULL, 0, NULL, '085603552547', '17558613264__sid__2NvpYG1.png', '87207c1791bf10f97bbc79031c652fd6', 0, NULL),
(5, 1, 'tedipratama', '$2y$10$nNmERGzNhF.aUZt21w9.weq70Rv7m.wbWWtOisLsvofpbvTlp/90G', 2, 30, NULL, '2022-08-22 02:34:09', NULL, 1, 'TEDI PRATAMA, S.T', '0', NULL, NULL, NULL, 0, NULL, '', '17558612956__sid__ySfPvmN.png', '983c0ff28eff7edeeae7fffa12e157a5', 0, NULL),
(6, 1, 'dedisupriadi', '$2y$10$/yoS6caIyzP7hlLZy1FvlOYlril5U2NLmCupyQJJIDgxVqZKjquYq', 2, 33, 'supriadidedi066@gmail.com', '2025-08-27 14:24:51', NULL, 1, 'DEDI SUPRIADI, S.Pd', '0', NULL, NULL, NULL, 0, NULL, '082240399777', '17558612162__sid__hqNBxfs.png', '68b139610d10f9414509740023a5d169', 0, NULL),
(7, 1, 'dwilaksmi', '$2y$10$wFoT1212LZ.HapVaox6n/e.6hh6sXAiSm5VdNrLl7lqtKD.3EiTvG', 2, 36, NULL, '2024-03-08 11:20:02', NULL, 1, 'DWI LAKSMI SARASWATI, S.M', '0', NULL, NULL, NULL, 0, NULL, '', '17558612305__sid__OMps2Ez.png', '2166c962f39b40f03cdfa33cadcaeb02', 0, NULL),
(8, 1, 'OPERATOR01', '$2y$10$4y8How1sO3svTxnaeOpHvOlCYsW2giOLTet9z3Wy/YOsm6F.eYTo6', 6, NULL, NULL, '2025-09-29 21:00:10', NULL, 0, 'ASEP MUTAQQIN', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', '692ed7c724245cdda7f2bbb6ccd50594', 0, NULL),
(10, 1, 'OPERATOR03', '$2y$10$sjbkIxbWV4XJvJW3l1xWyOi8A9HrMu10MGsBcuQbWsicqzqMFdGb2', 6, NULL, NULL, '2025-09-29 11:52:53', NULL, 0, 'WULAN HERVINA DESTRIANA', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', '2c59edf55bd8077e1b08cd9963502e23', 0, NULL),
(11, 1, 'OPERATOR04', '$2y$10$5bZPYLEr.W0L./eYxJkJgOBPYkacMIwMBObaVwDgjt4SC5djclexa', 6, NULL, NULL, '2025-09-29 10:00:25', NULL, 0, 'DEDE ROHENDI', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', 'b1044a44961381d5b40f52139e163380', 0, NULL),
(12, 1, 'OPERATOR05', '$2y$10$vwylzbl/zTl4XktsllP1qeJhbV8vWiiHzrXZr6D/H/oI2Hl/Z.C0O', 6, NULL, NULL, '2025-09-30 13:34:34', NULL, 0, 'FINI ANDIANI', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', '26a90e22c2b4cf1a56e53bc629510cf4', 0, NULL),
(14, 1, 'OPERATOR07', '$2y$10$mWsS2PA6k6R6YzVTGFWJPOBeeWXXbQJr6HDk33hs/6IM9bLmxtYKS', 6, NULL, NULL, '2025-10-01 11:06:22', NULL, 0, 'AHMAD MUHIDIN', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', '2c65857d1a9a091f123614babf8192e6', 0, NULL),
(15, 1, 'OPERATOR08', '$2y$10$JW.jNxzeK9PWY2MqiFELQO3bm4Eadks.yq6ming1TvMEAYhvaIgEC', 6, NULL, 'freedhilman9@gmail.com', '2025-09-27 12:57:04', NULL, 0, 'HILMAN HASANUDIN', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', 'bf07ad9b381d62df904059c8c0a49aa5', 0, NULL),
(16, 1, 'OPERATOR09', '$2y$10$RoX.NsgxOEhxGRZIV0vwm.VrI5.Y1UJnPAgunUU7gwC702zVCBxMu', 6, NULL, NULL, '2025-09-30 19:32:11', NULL, 0, 'KUSMIATI', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', 'e83c49da0bb86b87ca862dabe1abcaf0', 0, NULL),
(17, 1, 'tetehaidah', '$2y$10$MN0UjioDo5nJFB3Wldw1e.Afowo/GkNPxULmbe5wKb.4jlW75Gy5e', 2, 26, NULL, '2025-08-27 08:25:22', NULL, 1, 'TETEH AIDAH', '0', NULL, NULL, NULL, 0, NULL, '', '17558613541__sid__OBZLR12.png', 'fee5529e7478b12fd00ce63cba865957', 0, NULL),
(18, 1, 'endi', '$2y$10$v5jv1Fl0aDlJW8NJmImSxeOY4EaGx5tVFd5ufJHtM4K4GK8C914ma', 2, 28, NULL, NULL, NULL, 1, 'ENDI, S.PD.', '0', NULL, NULL, NULL, 0, NULL, '', '17558613817__sid__aQg2EF6.png', '0c50cfb4b53a2d511f690723bbcb876d', 0, NULL),
(19, 1, 'roro', '$2y$10$O9xlwlGb7g2ooNaYMolnwuRxO/yMJn3VpiUA2rKR/hKrOLW9J4JD2', 2, 35, NULL, NULL, NULL, 1, 'RORO', '0', NULL, NULL, NULL, 0, NULL, '', '17558614078__sid__kDeXSqn.png', '05aec312060b58f11a2ddd9ae8479e33', 0, NULL),
(20, 1, 'totosantosa', '$2y$10$qXbXr/GHS.VI4Ya0RZT9zekvx6bNK0JKyelMawqTktoOC1lve21ly', 2, 31, NULL, NULL, NULL, 1, 'TOTO SANTOSA', '0', NULL, NULL, NULL, 0, NULL, '', '175586144311__sid__JMxujTp.png', '95a46bcd4c87ea45f4930587fa978f57', 0, NULL),
(21, 1, 'umar', '$2y$10$E5oLbJ/zXgbL1KQwiavRDOL91Y30eMamHi5kHiOOpBE8RdKwAxvIG', 2, 32, NULL, NULL, NULL, 1, 'UMAR', '0', NULL, NULL, NULL, 0, NULL, '', '17558614879__sid__1KDXk7L.png', '4b3246d3725159559b847ed7ef65adeb', 0, NULL),
(22, 1, 'indasudiawan', '$2y$10$DTCCOKmU8d2q9ftL0dCkkOTXoPDe/4wFbHm.7oBp.rtnW7t/FRIky', 2, 37, NULL, '2025-10-31 08:41:46', NULL, 1, 'INDA SUDIAWAN', '0', NULL, NULL, NULL, 0, NULL, '', '175586152010__sid__rIKMyqo.png', '75a5ffd14ce96d8a0080e3bae07211b0', 0, NULL),
(23, 1, 'OPERATOR02', '$2y$10$yjPnPfNOH2hk2XNNemVZ3ORm4vZvBCssy4ZRLJ7BiEvcABvDrTov.', 6, NULL, NULL, '2025-10-01 08:25:24', NULL, 0, 'EGA SOPIAN', '0', NULL, NULL, NULL, 0, NULL, '', 'kuser.png', 'efe4fe086beabee372f457b6dec2b45e', 0, '[]');

-- --------------------------------------------------------

--
-- Table structure for table `user_grup`
--

CREATE TABLE `user_grup` (
  `id` int(11) NOT NULL,
  `config_id` int(11) DEFAULT NULL,
  `nama` varchar(20) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `jenis` tinyint(2) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `user_grup`
--

INSERT INTO `user_grup` (`id`, `config_id`, `nama`, `slug`, `jenis`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 1, 'Administrator', 'administrator', 1, '2021-05-01 01:45:38', NULL, '2021-05-01 01:45:38', 0),
(2, 1, 'Operator', 'operator', 1, '2021-05-01 01:45:38', NULL, '2021-05-01 01:45:38', 0),
(3, 1, 'Redaksi', 'redaksi', 1, '2021-05-01 01:45:38', NULL, '2021-05-01 01:45:38', 0),
(4, 1, 'Kontributor', 'kontributor', 1, '2021-05-01 01:45:38', NULL, '2021-05-01 01:45:38', 0),
(5, 1, 'Satgas Covid-19', 'satgas-covid-19', 2, '2021-05-01 01:45:38', NULL, '2021-05-01 01:45:38', 0),
(6, 1, 'Enumerator', 'enumerator', 2, '2025-08-22 09:16:54', 1, '2025-08-22 09:16:54', 1);

-- --------------------------------------------------------

--
-- Table structure for table `widget`
--

CREATE TABLE `widget` (
  `id` int(11) NOT NULL,
  `config_id` int(11) DEFAULT NULL,
  `isi` mediumtext DEFAULT NULL,
  `enabled` int(2) DEFAULT NULL,
  `judul` varchar(100) DEFAULT NULL,
  `jenis_widget` tinyint(2) NOT NULL DEFAULT 3,
  `urut` int(5) DEFAULT NULL,
  `form_admin` varchar(100) DEFAULT NULL,
  `setting` mediumtext DEFAULT NULL,
  `foto` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `widget`
--

INSERT INTO `widget` (`id`, `config_id`, `isi`, `enabled`, `judul`, `jenis_widget`, `urut`, `form_admin`, `setting`, `foto`) VALUES
(1, 1, '<iframe src=\n\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3439.4050277381066!2d108.001397114368!3d-6.983995670332376!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e68cd89e1bb6f75:0xf7d9b742976095f6!2skantor%20Desa%20Pelitaasih!5e1!3m2!1sid!2sid!4v1640623792010!5m2!1sid!2sid\"\nwidth=\"270\" height=\"200\" class=\"c1\" allowfullscreen=\n\"allowfullscreen\" loading=\"lazy\"></iframe>', 1, 'Peta Desa Pelitaasih', 3, 11, '', '', NULL),
(3, 1, 'agenda.php', 1, 'Agenda', 1, 5, 'web/tab/1000', '', NULL),
(4, 1, 'galeri.php', 1, 'Galeri', 1, 7, 'gallery', '', NULL),
(5, 1, 'statistik.php', 1, 'Statistik', 1, 2, '', '', NULL),
(6, 1, 'komentar.php', 1, 'Komentar', 1, 9, 'komentar', '', NULL),
(7, 1, 'media_sosial.php', 1, 'Media Sosial', 1, 10, 'sosmed', '', NULL),
(8, 1, 'peta_lokasi_kantor.php', 1, 'Peta Lokasi Kantor', 1, 14, 'identitas_desa/maps/kantor', '', NULL),
(9, 1, 'statistik_pengunjung.php', 1, 'Statistik Pengunjung', 1, 18, '', '', NULL),
(10, 1, 'arsip_artikel.php', 1, 'Arsip Artikel', 1, 4, '', '', NULL),
(11, 1, 'aparatur_desa.php', 1, '[Pemerintah Desa]', 1, 8, 'web_widget/admin/aparatur_desa', '{\"overlay\":\"1\"}', NULL),
(12, 1, 'sinergi_program.php', 1, 'Sinergi Program', 1, 6, 'web_widget/admin/sinergi_program', '[]', NULL),
(13, 1, 'menu_kategori.php', 1, 'Menu Kategori', 1, 1, '', '', NULL),
(14, 1, 'peta_wilayah_desa.php', 1, 'Peta Wilayah Desa', 1, 13, 'identitas_desa/maps/wilayah', '', NULL),
(15, 1, 'keuangan.php', 1, 'Keuangan', 1, 20, 'keuangan/impor_data', '', NULL),
(16, 1, '<iframe src=\n\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d25164.159403133497!2d107.97430038164815!3d-6.978481920348925!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e68cc682682a537:0x9bf0500d44a07550!2sPelitaasih,%20Selaawi,%20Kabupaten%20Garut,%20Jawa%20Barat!5e1!3m2!1sid!2sid!4v1640626370852!5m2!1sid!2sid\"\nwidth=\"270\" height=\"200\" class=\"c1\" allowfullscreen=\n\"allowfullscreen\" loading=\"lazy\"></iframe>', 1, 'Wilayah Desa Pelitaasih', 3, 12, NULL, NULL, NULL),
(17, 1, 'vendor/themes/esensi/widgets/jam_kerja.php', 1, 'Kehadiran', 2, 19, NULL, NULL, NULL),
(19, 1, 'vendor/themes/tema-silir-4.4/widgets/keuangan.php', 2, 'Keuangan Desa', 2, 15, NULL, NULL, NULL),
(22, 1, 'jam_kerja.php', 2, 'Jam Kerja', 1, 21, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agenda`
--
ALTER TABLE `agenda`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_artikel_fk` (`id_artikel`),
  ADD KEY `agenda_config_fk` (`config_id`);

--
-- Indexes for table `alias_kodeisian`
--
ALTER TABLE `alias_kodeisian`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `alias_kodeisian_config_id_judul_alias_unique` (`config_id`,`judul`,`alias`);

--
-- Indexes for table `analisis_indikator`
--
ALTER TABLE `analisis_indikator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`,`id_tipe`),
  ADD KEY `id_tipe` (`id_tipe`),
  ADD KEY `id_kategori` (`id_kategori`),
  ADD KEY `analisis_indikator_config_fk` (`config_id`);

--
-- Indexes for table `analisis_kategori_indikator`
--
ALTER TABLE `analisis_kategori_indikator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `analisis_kategori_indikator_config_fk` (`config_id`);

--
-- Indexes for table `analisis_klasifikasi`
--
ALTER TABLE `analisis_klasifikasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `analisis_klasifikasi_config_fk` (`config_id`);

--
-- Indexes for table `analisis_master`
--
ALTER TABLE `analisis_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analisis_master_config_fk` (`config_id`),
  ADD KEY `analisis_master_subjek_fk` (`subjek_tipe`);

--
-- Indexes for table `analisis_parameter`
--
ALTER TABLE `analisis_parameter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_indikator` (`id_indikator`),
  ADD KEY `analisis_parameter_config_fk` (`config_id`);

--
-- Indexes for table `analisis_partisipasi`
--
ALTER TABLE `analisis_partisipasi`
  ADD KEY `id_subjek` (`id_subjek`,`id_master`,`id_periode`,`id_klassifikasi`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `id_periode` (`id_periode`),
  ADD KEY `id_klassifikasi` (`id_klassifikasi`);

--
-- Indexes for table `analisis_periode`
--
ALTER TABLE `analisis_periode`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `id_state` (`id_state`),
  ADD KEY `analisis_periode_config_fk` (`config_id`);

--
-- Indexes for table `analisis_ref_state`
--
ALTER TABLE `analisis_ref_state`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analisis_ref_subjek`
--
ALTER TABLE `analisis_ref_subjek`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analisis_respon`
--
ALTER TABLE `analisis_respon`
  ADD KEY `id_parameter` (`id_parameter`,`id_subjek`),
  ADD KEY `id_periode` (`id_periode`),
  ADD KEY `id_indikator` (`id_indikator`),
  ADD KEY `analisis_respon_subjek_fk` (`id_subjek`);

--
-- Indexes for table `analisis_respon_bukti`
--
ALTER TABLE `analisis_respon_bukti`
  ADD KEY `analisis_respon_bukti_config_fk` (`config_id`),
  ADD KEY `analisis_respon_bukti_master_fk` (`id_master`),
  ADD KEY `analisis_respon_bukti_periode_fk` (`id_periode`),
  ADD KEY `analisis_respon_bukti_subjek_fk` (`id_subjek`);

--
-- Indexes for table `analisis_respon_hasil`
--
ALTER TABLE `analisis_respon_hasil`
  ADD UNIQUE KEY `id_master` (`id_master`,`id_periode`,`id_subjek`),
  ADD KEY `analisis_respon_hasil_config_fk` (`config_id`),
  ADD KEY `analisis_respon_hasil_subjek_fk` (`id_subjek`),
  ADD KEY `analisis_respon_hasil_periode_fk` (`id_periode`);

--
-- Indexes for table `analisis_tipe_indikator`
--
ALTER TABLE `analisis_tipe_indikator`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  ADD PRIMARY KEY (`id_grup_kontak`),
  ADD KEY `anggota_grup_kontak_ke_kontak` (`id_kontak`),
  ADD KEY `anggota_grup_kontak_ke_kontak_grup` (`id_grup`),
  ADD KEY `id_penduduk` (`id_penduduk`),
  ADD KEY `anggota_grup_kontak_config_fk` (`config_id`);

--
-- Indexes for table `anjungan`
--
ALTER TABLE `anjungan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `anjungan_config_fk` (`config_id`);

--
-- Indexes for table `anjungan_menu`
--
ALTER TABLE `anjungan_menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `anjungan_menu_config_fk` (`config_id`);

--
-- Indexes for table `area`
--
ALTER TABLE `area`
  ADD PRIMARY KEY (`id`),
  ADD KEY `area_config_fk` (`config_id`),
  ADD KEY `area_cluster_fk` (`id_cluster`);

--
-- Indexes for table `artikel`
--
ALTER TABLE `artikel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `artikel_config_fk` (`config_id`),
  ADD KEY `artikel_kategori_fk` (`id_kategori`),
  ADD KEY `artikel_kategori_id_user_fk` (`id_user`);

--
-- Indexes for table `buku_keperluan`
--
ALTER TABLE `buku_keperluan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `buku_keperluan_config_fk` (`config_id`);

--
-- Indexes for table `buku_kepuasan`
--
ALTER TABLE `buku_kepuasan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `buku_kepuasan_config_fk` (`config_id`),
  ADD KEY `buku_kepuasan_nama_fk` (`id_nama`),
  ADD KEY `buku_kepuasan_pertanyaan_fk` (`id_pertanyaan`);

--
-- Indexes for table `buku_pertanyaan`
--
ALTER TABLE `buku_pertanyaan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `buku_pertanyaan_config_fk` (`config_id`);

--
-- Indexes for table `buku_tamu`
--
ALTER TABLE `buku_tamu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `buku_tamu_config_fk` (`config_id`);

--
-- Indexes for table `bulanan_anak`
--
ALTER TABLE `bulanan_anak`
  ADD PRIMARY KEY (`id_bulanan_anak`),
  ADD KEY `bulanan_anak_config_fk` (`config_id`),
  ADD KEY `bulanan_anak_posyandu_fk` (`posyandu_id`),
  ADD KEY `bulanan_anak_kia_fk` (`kia_id`);

--
-- Indexes for table `cdesa`
--
ALTER TABLE `cdesa`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nomor` (`nomor`),
  ADD KEY `cdesa_config_fk` (`config_id`);

--
-- Indexes for table `cdesa_penduduk`
--
ALTER TABLE `cdesa_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_cdesa` (`id_cdesa`),
  ADD KEY `cdesa_penduduk_config_fk` (`config_id`),
  ADD KEY `cdesa_penduduk_pend_fk` (`id_pend`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `app_key` (`app_key`),
  ADD UNIQUE KEY `kode_desa` (`kode_desa`);

--
-- Indexes for table `covid19_pantau`
--
ALTER TABLE `covid19_pantau`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_pantau_pemudik` (`id_pemudik`),
  ADD KEY `covid19_pantau_config_fk` (`config_id`);

--
-- Indexes for table `covid19_pemudik`
--
ALTER TABLE `covid19_pemudik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_pemudik_penduduk` (`id_terdata`),
  ADD KEY `covid19_pemudik_config_fk` (`config_id`);

--
-- Indexes for table `covid19_vaksin`
--
ALTER TABLE `covid19_vaksin`
  ADD PRIMARY KEY (`id_penduduk`),
  ADD KEY `covid19_vaksin_config_fk` (`config_id`);

--
-- Indexes for table `data_persil`
--
ALTER TABLE `data_persil`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_persil_jenis`
--
ALTER TABLE `data_persil_jenis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_persil_peruntukan`
--
ALTER TABLE `data_persil_peruntukan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  ADD PRIMARY KEY (`id_disposisi`),
  ADD KEY `id_surat_fk` (`id_surat_masuk`),
  ADD KEY `desa_pamong_fk` (`id_desa_pamong`),
  ADD KEY `disposisi_surat_masuk_config_fk` (`config_id`);

--
-- Indexes for table `dokumen`
--
ALTER TABLE `dokumen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dokumen_config_fk` (`config_id`);

--
-- Indexes for table `dtks`
--
ALTER TABLE `dtks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_dtks_rtm` (`id_rtm`),
  ADD KEY `FK_kel_dtks` (`id_keluarga`),
  ADD KEY `dtks_config_fk` (`config_id`);

--
-- Indexes for table `dtks_anggota`
--
ALTER TABLE `dtks_anggota`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_dtks_dtks_anggota` (`id_dtks`),
  ADD KEY `FK_pend_dtks_anggota` (`id_penduduk`),
  ADD KEY `FK_kel_dtks_anggota` (`id_keluarga`),
  ADD KEY `dtks_anggota_config_fk` (`config_id`);

--
-- Indexes for table `dtks_lampiran`
--
ALTER TABLE `dtks_lampiran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_dtks_lampiran_rtm` (`id_rtm`),
  ADD KEY `dtks_lampiran_config_fk` (`config_id`);

--
-- Indexes for table `dtks_pengaturan_program`
--
ALTER TABLE `dtks_pengaturan_program`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `config_idversi_kuisionerkode` (`config_id`,`versi_kuisioner`,`kode`),
  ADD KEY `FK_dtks_p_program` (`id_bantuan`);

--
-- Indexes for table `dtks_ref_lampiran`
--
ALTER TABLE `dtks_ref_lampiran`
  ADD KEY `FK_ref_lampiran_dtks` (`id_dtks`),
  ADD KEY `FK_lampiran_dtks` (`id_lampiran`);

--
-- Indexes for table `fcm_token`
--
ALTER TABLE `fcm_token`
  ADD UNIQUE KEY `fcm_token_device_unique` (`device`),
  ADD KEY `fcm_token_dd_user_fk` (`id_user`),
  ADD KEY `fcm_token_config_fk` (`config_id`);

--
-- Indexes for table `fcm_token_mandiri`
--
ALTER TABLE `fcm_token_mandiri`
  ADD UNIQUE KEY `fcm_token_mandiri_device_unique` (`device`),
  ADD KEY `fcm_token_mandiri_config_fk` (`config_id`),
  ADD KEY `fcm_token_mandiri_user_mandiri_fk` (`id_user_mandiri`);

--
-- Indexes for table `gambar_gallery`
--
ALTER TABLE `gambar_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`),
  ADD KEY `gambar_gallery_config_fk` (`config_id`);

--
-- Indexes for table `garis`
--
ALTER TABLE `garis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `garis_config_fk` (`config_id`),
  ADD KEY `garis_cluster_fk` (`id_cluster`);

--
-- Indexes for table `gis_simbol`
--
ALTER TABLE `gis_simbol`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `simbol_config` (`config_id`,`simbol`);

--
-- Indexes for table `grup_akses`
--
ALTER TABLE `grup_akses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_grup` (`id_grup`),
  ADD KEY `id_modul` (`id_modul`),
  ADD KEY `grup_akses_config_fk` (`config_id`);

--
-- Indexes for table `hubung_warga`
--
ALTER TABLE `hubung_warga`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hubung_warga_id_grup_fk` (`id_grup`),
  ADD KEY `hubung_warga_config_fk` (`config_id`);

--
-- Indexes for table `ibu_hamil`
--
ALTER TABLE `ibu_hamil`
  ADD PRIMARY KEY (`id_ibu_hamil`),
  ADD KEY `ibu_hamil_config_fk` (`config_id`),
  ADD KEY `ibu_hamil_posyandu_fk` (`posyandu_id`),
  ADD KEY `ibu_hamil_kia_fk` (`kia_id`);

--
-- Indexes for table `inbox`
--
ALTER TABLE `inbox`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `inbox_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_asset`
--
ALTER TABLE `inventaris_asset`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_asset_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_gedung`
--
ALTER TABLE `inventaris_gedung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_gedung_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_jalan`
--
ALTER TABLE `inventaris_jalan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_jalan_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_kontruksi`
--
ALTER TABLE `inventaris_kontruksi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_kontruksi_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_peralatan`
--
ALTER TABLE `inventaris_peralatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_peralatan_config_fk` (`config_id`);

--
-- Indexes for table `inventaris_tanah`
--
ALTER TABLE `inventaris_tanah`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventaris_tanah_config_fk` (`config_id`);

--
-- Indexes for table `kader_pemberdayaan_masyarakat`
--
ALTER TABLE `kader_pemberdayaan_masyarakat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kader_pemberdayaan_masyarakat_config_fk` (`config_id`),
  ADD KEY `kader_pemberdayaan_masyarakat_penduduk_fk` (`penduduk_id`);

--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kategori_config_fk` (`config_id`);

--
-- Indexes for table `kehadiran_alasan_keluar`
--
ALTER TABLE `kehadiran_alasan_keluar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kehadiran_alasan_keluar_config_fk` (`config_id`);

--
-- Indexes for table `kehadiran_hari_libur`
--
ALTER TABLE `kehadiran_hari_libur`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tanggal_config` (`config_id`,`tanggal`);

--
-- Indexes for table `kehadiran_jam_kerja`
--
ALTER TABLE `kehadiran_jam_kerja`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `jam_kerja_config` (`config_id`,`nama_hari`);

--
-- Indexes for table `kehadiran_pengaduan`
--
ALTER TABLE `kehadiran_pengaduan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kehadiran_pengaduan_config_fk` (`config_id`),
  ADD KEY `kehadiran_pengaduan_penduduk_fk` (`id_penduduk`),
  ADD KEY `kehadiran_pengaduan_pamong_fk` (`id_pamong`);

--
-- Indexes for table `kehadiran_perangkat_desa`
--
ALTER TABLE `kehadiran_perangkat_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kehadiran_perangkat_desa_config_fk` (`config_id`),
  ADD KEY `kehadiran_perangkat_desa_pamong_fk` (`pamong_id`);

--
-- Indexes for table `kelompok`
--
ALTER TABLE `kelompok`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`),
  ADD UNIQUE KEY `config_kode_tipe` (`config_id`,`kode`,`tipe`),
  ADD KEY `id_ketua` (`id_ketua`),
  ADD KEY `id_master` (`id_master`);

--
-- Indexes for table `kelompok_anggota`
--
ALTER TABLE `kelompok_anggota`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_kelompok_config` (`config_id`,`id_kelompok`,`id_penduduk`),
  ADD UNIQUE KEY `no_anggota_config` (`config_id`,`id_kelompok`,`no_anggota`),
  ADD KEY `kelompok_anggota_kelompok_fk` (`id_kelompok`),
  ADD KEY `kelompok_anggota_penduduk_fk` (`id_penduduk`);

--
-- Indexes for table `kelompok_master`
--
ALTER TABLE `kelompok_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kelompok_master_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_manual_ref_bidang`
--
ALTER TABLE `keuangan_manual_ref_bidang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_manual_ref_kegiatan`
--
ALTER TABLE `keuangan_manual_ref_kegiatan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_manual_ref_rek1`
--
ALTER TABLE `keuangan_manual_ref_rek1`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_manual_ref_rek2`
--
ALTER TABLE `keuangan_manual_ref_rek2`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_manual_ref_rek3`
--
ALTER TABLE `keuangan_manual_ref_rek3`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_manual_rinci`
--
ALTER TABLE `keuangan_manual_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `keuangan_manual_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_manual_rinci_tpl`
--
ALTER TABLE `keuangan_manual_rinci_tpl`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `keuangan_master`
--
ALTER TABLE `keuangan_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `keuangan_master_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_bank_desa`
--
ALTER TABLE `keuangan_ref_bank_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_bank_desa_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_bank_desa_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_bel_operasional`
--
ALTER TABLE `keuangan_ref_bel_operasional`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_bel_operasional_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_bel_operasional_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_bidang`
--
ALTER TABLE `keuangan_ref_bidang`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_bidang_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_bidang_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_bunga`
--
ALTER TABLE `keuangan_ref_bunga`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_bunga_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_bunga_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_desa`
--
ALTER TABLE `keuangan_ref_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_desa_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_desa_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_kecamatan`
--
ALTER TABLE `keuangan_ref_kecamatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_kecamatan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_kecamatan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_kegiatan`
--
ALTER TABLE `keuangan_ref_kegiatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_kegiatan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_kegiatan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_korolari`
--
ALTER TABLE `keuangan_ref_korolari`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_korolari_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_korolari_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_neraca_close`
--
ALTER TABLE `keuangan_ref_neraca_close`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_neraca_close_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_neraca_close_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_perangkat`
--
ALTER TABLE `keuangan_ref_perangkat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_perangkat_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_perangkat_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_potongan`
--
ALTER TABLE `keuangan_ref_potongan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_potongan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_potongan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_rek1`
--
ALTER TABLE `keuangan_ref_rek1`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_rek1_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_rek1_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_rek2`
--
ALTER TABLE `keuangan_ref_rek2`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_rek2_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_rek2_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_rek3`
--
ALTER TABLE `keuangan_ref_rek3`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_rek3_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_rek3_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_rek4`
--
ALTER TABLE `keuangan_ref_rek4`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_rek4_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_rek4_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_sbu`
--
ALTER TABLE `keuangan_ref_sbu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_sbu_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_sbu_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ref_sumber`
--
ALTER TABLE `keuangan_ref_sumber`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ref_sumber_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ref_sumber_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_anggaran`
--
ALTER TABLE `keuangan_ta_anggaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_anggaran_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_anggaran_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_anggaran_log`
--
ALTER TABLE `keuangan_ta_anggaran_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_anggaran_log_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_anggaran_log_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_anggaran_rinci`
--
ALTER TABLE `keuangan_ta_anggaran_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_anggaran_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_anggaran_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_bidang`
--
ALTER TABLE `keuangan_ta_bidang`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_bidang_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_bidang_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_desa`
--
ALTER TABLE `keuangan_ta_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_desa_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_desa_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_jurnal_umum`
--
ALTER TABLE `keuangan_ta_jurnal_umum`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_jurnal_umum_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_jurnal_umum_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_jurnal_umum_rinci`
--
ALTER TABLE `keuangan_ta_jurnal_umum_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_jurnal_umum_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_jurnal_umum_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_kegiatan`
--
ALTER TABLE `keuangan_ta_kegiatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_kegiatan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_kegiatan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_mutasi`
--
ALTER TABLE `keuangan_ta_mutasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_mutasi_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_mutasi_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_pajak`
--
ALTER TABLE `keuangan_ta_pajak`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_pajak_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_pajak_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_pajak_rinci`
--
ALTER TABLE `keuangan_ta_pajak_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_pajak_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_pajak_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_pemda`
--
ALTER TABLE `keuangan_ta_pemda`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_pemda_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_pemda_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_pencairan`
--
ALTER TABLE `keuangan_ta_pencairan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_pencairan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_pencairan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_perangkat`
--
ALTER TABLE `keuangan_ta_perangkat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_perangkat_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_perangkat_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rab`
--
ALTER TABLE `keuangan_ta_rab`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rab_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rab_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rab_rinci`
--
ALTER TABLE `keuangan_ta_rab_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rab_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rab_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rab_sub`
--
ALTER TABLE `keuangan_ta_rab_sub`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rab_sub_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rab_sub_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_bidang`
--
ALTER TABLE `keuangan_ta_rpjm_bidang`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_bidang_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_bidang_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_kegiatan`
--
ALTER TABLE `keuangan_ta_rpjm_kegiatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_kegiatan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_kegiatan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_misi`
--
ALTER TABLE `keuangan_ta_rpjm_misi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_misi_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_misi_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_pagu_indikatif`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_indikatif`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_pagu_indikatif_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_pagu_indikatif_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_pagu_tahunan`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_tahunan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_pagu_tahunan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_pagu_tahunan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_sasaran`
--
ALTER TABLE `keuangan_ta_rpjm_sasaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_sasaran_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_sasaran_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_tujuan`
--
ALTER TABLE `keuangan_ta_rpjm_tujuan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_tujuan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_tujuan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_rpjm_visi`
--
ALTER TABLE `keuangan_ta_rpjm_visi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_rpjm_visi_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_rpjm_visi_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_saldo_awal`
--
ALTER TABLE `keuangan_ta_saldo_awal`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_saldo_awal_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_saldo_awal_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spj`
--
ALTER TABLE `keuangan_ta_spj`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spj_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spj_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spjpot`
--
ALTER TABLE `keuangan_ta_spjpot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spjpot_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spjpot_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spj_bukti`
--
ALTER TABLE `keuangan_ta_spj_bukti`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spj_bukti_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spj_bukti_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spj_rinci`
--
ALTER TABLE `keuangan_ta_spj_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spj_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spj_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spj_sisa`
--
ALTER TABLE `keuangan_ta_spj_sisa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spj_sisa_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spj_sisa_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spp`
--
ALTER TABLE `keuangan_ta_spp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spp_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spp_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_sppbukti`
--
ALTER TABLE `keuangan_ta_sppbukti`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_sppbukti_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_sppbukti_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spppot`
--
ALTER TABLE `keuangan_ta_spppot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spppot_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spppot_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_spp_rinci`
--
ALTER TABLE `keuangan_ta_spp_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_spp_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_spp_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_sts`
--
ALTER TABLE `keuangan_ta_sts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_sts_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_sts_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_sts_rinci`
--
ALTER TABLE `keuangan_ta_sts_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_sts_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_sts_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_tbp`
--
ALTER TABLE `keuangan_ta_tbp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_tbp_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_tbp_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_tbp_rinci`
--
ALTER TABLE `keuangan_ta_tbp_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_tbp_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_tbp_rinci_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_triwulan`
--
ALTER TABLE `keuangan_ta_triwulan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_triwulan_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_triwulan_config_fk` (`config_id`);

--
-- Indexes for table `keuangan_ta_triwulan_rinci`
--
ALTER TABLE `keuangan_ta_triwulan_rinci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_keuangan_ta_triwulan_rinci_master_fk` (`id_keuangan_master`),
  ADD KEY `keuangan_ta_triwulan_rinci_config_fk` (`config_id`);

--
-- Indexes for table `kia`
--
ALTER TABLE `kia`
  ADD PRIMARY KEY (`id`),
  ADD KEY `no_kia` (`no_kia`),
  ADD KEY `kia_config_fk` (`config_id`),
  ADD KEY `kia_ibu_fk` (`ibu_id`),
  ADD KEY `kia_anak_fk` (`anak_id`);

--
-- Indexes for table `klasifikasi_surat`
--
ALTER TABLE `klasifikasi_surat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `klasifikasi_surat_config_fk` (`config_id`);

--
-- Indexes for table `komentar`
--
ALTER TABLE `komentar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `komentar_config_fk` (`config_id`),
  ADD KEY `komentar_artikel_fk` (`id_artikel`);

--
-- Indexes for table `kontak`
--
ALTER TABLE `kontak`
  ADD PRIMARY KEY (`id_kontak`),
  ADD UNIQUE KEY `telepon_config` (`config_id`,`telepon`),
  ADD UNIQUE KEY `email_config` (`config_id`,`email`),
  ADD UNIQUE KEY `telegram_config` (`config_id`,`telegram`);

--
-- Indexes for table `kontak_grup`
--
ALTER TABLE `kontak_grup`
  ADD PRIMARY KEY (`id_grup`),
  ADD KEY `kontak_grup_config_fk` (`config_id`);

--
-- Indexes for table `laporan_sinkronisasi`
--
ALTER TABLE `laporan_sinkronisasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `laporan_sinkronisasi_config_fk` (`config_id`);

--
-- Indexes for table `line`
--
ALTER TABLE `line`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`),
  ADD KEY `line_config_fk` (`config_id`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_attempts_config_fk` (`config_id`);

--
-- Indexes for table `log_backup`
--
ALTER TABLE `log_backup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_backup_config_fk` (`config_id`);

--
-- Indexes for table `log_ekspor`
--
ALTER TABLE `log_ekspor`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `log_hapus_penduduk`
--
ALTER TABLE `log_hapus_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_hapus_penduduk_config_fk` (`config_id`),
  ADD KEY `log_hapus_penduduk_pend_fk` (`id_pend`);

--
-- Indexes for table `log_keluarga`
--
ALTER TABLE `log_keluarga`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_kk_config` (`config_id`,`id_kk`,`id_peristiwa`,`tgl_peristiwa`,`id_pend`),
  ADD KEY `log_penduduk_fk` (`id_log_penduduk`),
  ADD KEY `log_keluarga_pend_fk` (`id_pend`),
  ADD KEY `log_keluarga_kk_fk` (`id_kk`);

--
-- Indexes for table `log_login`
--
ALTER TABLE `log_login`
  ADD PRIMARY KEY (`uuid`),
  ADD UNIQUE KEY `log_login_uuid_config_id_unique` (`uuid`,`config_id`),
  ADD KEY `log_login_config_id_foreign` (`config_id`);

--
-- Indexes for table `log_notifikasi_admin`
--
ALTER TABLE `log_notifikasi_admin`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_notifikasi_admin_id_created_at_read_device_config_id_index` (`id`,`created_at`,`read`,`config_id`),
  ADD KEY `log_notifikasi_admin_config_fk` (`config_id`),
  ADD KEY `log_notifikasi_admin_user_fk` (`id_user`);

--
-- Indexes for table `log_notifikasi_mandiri`
--
ALTER TABLE `log_notifikasi_mandiri`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `log_notifikasi_mandiri_device_unique` (`device`),
  ADD KEY `log_notifikasi_mandiri_id_created_at_read_device_config_id_index` (`id`,`created_at`,`read`,`device`,`config_id`),
  ADD KEY `log_notifikasi_mandiri_config_fk` (`config_id`),
  ADD KEY `log_notifikasi_mandiri_user_mandiri_fk` (`id_user_mandiri`);

--
-- Indexes for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_pend_config` (`config_id`,`id_pend`,`kode_peristiwa`,`tgl_peristiwa`),
  ADD KEY `id_ref_pindah` (`ref_pindah`),
  ADD KEY `config_id` (`config_id`),
  ADD KEY `id_pend` (`id_pend`),
  ADD KEY `kode_peristiwa` (`kode_peristiwa`),
  ADD KEY `tgl_peristiwa` (`tgl_peristiwa`);

--
-- Indexes for table `log_perubahan_penduduk`
--
ALTER TABLE `log_perubahan_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_perubahan_penduduk_config_fk` (`config_id`),
  ADD KEY `log_perubahan_penduduk_pend_fk` (`id_pend`),
  ADD KEY `log_perubahan_penduduk_cluster_fk` (`id_cluster`);

--
-- Indexes for table `log_restore_desa`
--
ALTER TABLE `log_restore_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_restore_desa_config_fk` (`config_id`);

--
-- Indexes for table `log_sinkronisasi`
--
ALTER TABLE `log_sinkronisasi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `modul_config` (`config_id`,`modul`);

--
-- Indexes for table `log_surat`
--
ALTER TABLE `log_surat`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `urls_id` (`urls_id`),
  ADD KEY `log_surat_config_fk` (`config_id`),
  ADD KEY `log_surat_format_surat_fk` (`id_format_surat`),
  ADD KEY `log_surat_pend_fk` (`id_pend`),
  ADD KEY `log_surat_user_fk` (`id_user`);

--
-- Indexes for table `log_surat_dinas`
--
ALTER TABLE `log_surat_dinas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `urls_id` (`urls_id`),
  ADD KEY `log_surat_dinas_format_fk` (`id_format_surat`),
  ADD KEY `log_surat_dinas_user_fk` (`id_user`),
  ADD KEY `log_surat_dinas_created_by_fk` (`created_by`),
  ADD KEY `log_surat_dinas_updated_by_fk` (`updated_by`),
  ADD KEY `log_surat_config_fk` (`config_id`);

--
-- Indexes for table `log_tolak`
--
ALTER TABLE `log_tolak`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_tolak_config_fk` (`config_id`),
  ADD KEY `log_tolak_surat_fk` (`id_surat`),
  ADD KEY `log_tolak_surat_dinas_fk` (`id_surat_dinas`);

--
-- Indexes for table `log_tte`
--
ALTER TABLE `log_tte`
  ADD PRIMARY KEY (`id`),
  ADD KEY `log_tte_config_fk` (`config_id`);

--
-- Indexes for table `lokasi`
--
ALTER TABLE `lokasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ref_point` (`ref_point`),
  ADD KEY `lokasi_config_fk` (`config_id`),
  ADD KEY `lokasi_cluster_fk` (`id_cluster`);

--
-- Indexes for table `media_sosial`
--
ALTER TABLE `media_sosial`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_sosial_config` (`config_id`,`nama`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_config_fk` (`config_id`);

--
-- Indexes for table `migrasi`
--
ALTER TABLE `migrasi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mutasi_cdesa`
--
ALTER TABLE `mutasi_cdesa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cdesa_mutasi_fk` (`id_cdesa_masuk`),
  ADD KEY `mutasi_cdesa_config_fk` (`config_id`),
  ADD KEY `mutasi_cdesa_peta_fk` (`id_peta`);

--
-- Indexes for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_asset` (`id_inventaris_asset`),
  ADD KEY `mutasi_inventaris_asset_config_fk` (`config_id`);

--
-- Indexes for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_gedung` (`id_inventaris_gedung`),
  ADD KEY `mutasi_inventaris_gedung_config_fk` (`config_id`);

--
-- Indexes for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_jalan` (`id_inventaris_jalan`),
  ADD KEY `mutasi_inventaris_jalan_config_fk` (`config_id`);

--
-- Indexes for table `mutasi_inventaris_peralatan`
--
ALTER TABLE `mutasi_inventaris_peralatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_peralatan` (`id_inventaris_peralatan`),
  ADD KEY `mutasi_inventaris_peralatan_config_fk` (`config_id`);

--
-- Indexes for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_tanah` (`id_inventaris_tanah`),
  ADD KEY `mutasi_inventaris_tanah_config_fk` (`config_id`);

--
-- Indexes for table `notifikasi`
--
ALTER TABLE `notifikasi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode_config` (`config_id`,`kode`);

--
-- Indexes for table `outbox`
--
ALTER TABLE `outbox`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `outbox_sender_config` (`config_id`,`SenderID`),
  ADD KEY `outbox_date_config` (`SendingDateTime`,`SendingTimeOut`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `pelapak`
--
ALTER TABLE `pelapak`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pelapak_config_fk` (`config_id`),
  ADD KEY `pelapak_pend_fk` (`id_pend`);

--
-- Indexes for table `pembangunan`
--
ALTER TABLE `pembangunan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`),
  ADD KEY `id_lokasi` (`id_lokasi`);

--
-- Indexes for table `pembangunan_ref_dokumentasi`
--
ALTER TABLE `pembangunan_ref_dokumentasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pembangunan` (`id_pembangunan`),
  ADD KEY `pembangunan_ref_dokumentasi_config_fk` (`config_id`);

--
-- Indexes for table `pemilihan`
--
ALTER TABLE `pemilihan`
  ADD PRIMARY KEY (`uuid`),
  ADD UNIQUE KEY `pemilihan_uuid_config_id_unique` (`uuid`,`config_id`),
  ADD KEY `pemilihan_config_id_foreign` (`config_id`);

--
-- Indexes for table `pendapat`
--
ALTER TABLE `pendapat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pendapat_config_fk` (`config_id`);

--
-- Indexes for table `pengaduan`
--
ALTER TABLE `pengaduan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pengaduan_config_fk` (`config_id`);

--
-- Indexes for table `permohonan_surat`
--
ALTER TABLE `permohonan_surat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permohonan_surat_config_fk` (`config_id`),
  ADD KEY `permohonan_surat_pemohon_fk` (`id_pemohon`),
  ADD KEY `permohonan_surat_surat_fk` (`id_surat`);

--
-- Indexes for table `persil`
--
ALTER TABLE `persil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nomor_nomor_urut_bidang` (`nomor`,`nomor_urut_bidang`),
  ADD KEY `persil_config_fk` (`config_id`),
  ADD KEY `persil_wilayah_fk` (`id_wilayah`),
  ADD KEY `persil_peta_fk` (`id_peta`);

--
-- Indexes for table `pesan`
--
ALTER TABLE `pesan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesan_config_fk` (`config_id`);

--
-- Indexes for table `pesan_detail`
--
ALTER TABLE `pesan_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesan_detail_config_fk` (`config_id`),
  ADD KEY `pesan_detail_pesan_fk` (`pesan_id`);

--
-- Indexes for table `pesan_mandiri`
--
ALTER TABLE `pesan_mandiri`
  ADD PRIMARY KEY (`uuid`),
  ADD UNIQUE KEY `pesan_mandiri_uuid_config_id_unique` (`uuid`,`config_id`),
  ADD KEY `pesan_mandiri_config_id_foreign` (`config_id`),
  ADD KEY `pesan_mandiri_penduduk_id_foreign` (`penduduk_id`);

--
-- Indexes for table `point`
--
ALTER TABLE `point`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`),
  ADD KEY `point_config_fk` (`config_id`);

--
-- Indexes for table `polygon`
--
ALTER TABLE `polygon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`),
  ADD KEY `polygon_config_fk` (`config_id`);

--
-- Indexes for table `posyandu`
--
ALTER TABLE `posyandu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `posyandu_config_fk` (`config_id`);

--
-- Indexes for table `produk`
--
ALTER TABLE `produk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lapak_fk` (`id_pelapak`),
  ADD KEY `produk_kategori_fk` (`id_produk_kategori`),
  ADD KEY `produk_config_fk` (`config_id`);

--
-- Indexes for table `produk_kategori`
--
ALTER TABLE `produk_kategori`
  ADD PRIMARY KEY (`id`),
  ADD KEY `produk_kategori_config_fk` (`config_id`);

--
-- Indexes for table `program`
--
ALTER TABLE `program`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`);

--
-- Indexes for table `program_peserta`
--
ALTER TABLE `program_peserta`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `program_peserta_program_id_kartu_id_pend_unique_config` (`config_id`,`program_id`,`kartu_id_pend`),
  ADD KEY `program_peserta_program_fk` (`program_id`),
  ADD KEY `program_peserta_kartu_fk` (`kartu_id_pend`);

--
-- Indexes for table `ref_asal_tanah_kas`
--
ALTER TABLE `ref_asal_tanah_kas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_dokumen`
--
ALTER TABLE `ref_dokumen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_jabatan`
--
ALTER TABLE `ref_jabatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ref_jabatan_config_fk` (`config_id`);

--
-- Indexes for table `ref_penduduk_bahasa`
--
ALTER TABLE `ref_penduduk_bahasa`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_penduduk_bidang`
--
ALTER TABLE `ref_penduduk_bidang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_penduduk_hamil`
--
ALTER TABLE `ref_penduduk_hamil`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_penduduk_kursus`
--
ALTER TABLE `ref_penduduk_kursus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_penduduk_suku`
--
ALTER TABLE `ref_penduduk_suku`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_peristiwa`
--
ALTER TABLE `ref_peristiwa`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_persil_kelas`
--
ALTER TABLE `ref_persil_kelas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_persil_mutasi`
--
ALTER TABLE `ref_persil_mutasi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_peruntukan_tanah_kas`
--
ALTER TABLE `ref_peruntukan_tanah_kas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_pindah`
--
ALTER TABLE `ref_pindah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_sinkronisasi`
--
ALTER TABLE `ref_sinkronisasi`
  ADD PRIMARY KEY (`tabel`);

--
-- Indexes for table `ref_status_covid`
--
ALTER TABLE `ref_status_covid`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ref_syarat_surat`
--
ALTER TABLE `ref_syarat_surat`
  ADD PRIMARY KEY (`ref_syarat_id`),
  ADD KEY `ref_syarat_surat_config_fk` (`config_id`);

--
-- Indexes for table `sasaran_paud`
--
ALTER TABLE `sasaran_paud`
  ADD PRIMARY KEY (`id_sasaran_paud`),
  ADD KEY `sasaran_paud_config_fk` (`config_id`),
  ADD KEY `sasaran_paud_posyandu_fk` (`posyandu_id`),
  ADD KEY `sasaran_paud_kia_fk` (`kia_id`);

--
-- Indexes for table `sentitems`
--
ALTER TABLE `sentitems`
  ADD PRIMARY KEY (`ID`,`SequencePosition`),
  ADD KEY `sentitems_date_config` (`config_id`,`DeliveryDateTime`),
  ADD KEY `sentitems_tpmr_config` (`config_id`,`TPMR`),
  ADD KEY `sentitems_dest_config` (`config_id`,`DestinationNumber`),
  ADD KEY `sentitems_sender_config` (`config_id`,`SenderID`);

--
-- Indexes for table `setting_aplikasi`
--
ALTER TABLE `setting_aplikasi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `key_config` (`config_id`,`key`);

--
-- Indexes for table `setting_modul`
--
ALTER TABLE `setting_modul`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`);

--
-- Indexes for table `shortcut`
--
ALTER TABLE `shortcut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shortcut_config_id_foreign` (`config_id`);

--
-- Indexes for table `statistics`
--
ALTER TABLE `statistics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url_id` (`url_id`),
  ADD KEY `statistics_config_fk` (`config_id`);

--
-- Indexes for table `suplemen`
--
ALTER TABLE `suplemen`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`);

--
-- Indexes for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_suplemen` (`id_suplemen`),
  ADD KEY `suplemen_terdata_config_fk` (`config_id`);

--
-- Indexes for table `surat_dinas`
--
ALTER TABLE `surat_dinas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url_surat_dinas_config` (`config_id`,`url_surat`);

--
-- Indexes for table `surat_keluar`
--
ALTER TABLE `surat_keluar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `surat_keluar_config_fk` (`config_id`);

--
-- Indexes for table `surat_masuk`
--
ALTER TABLE `surat_masuk`
  ADD PRIMARY KEY (`id`),
  ADD KEY `surat_masuk_config_fk` (`config_id`);

--
-- Indexes for table `sys_traffic`
--
ALTER TABLE `sys_traffic`
  ADD UNIQUE KEY `config_idTanggal` (`config_id`,`Tanggal`);

--
-- Indexes for table `tanah_desa`
--
ALTER TABLE `tanah_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_penduduk` (`id_penduduk`),
  ADD KEY `tanah_desa_config_fk` (`config_id`);

--
-- Indexes for table `tanah_kas_desa`
--
ALTER TABLE `tanah_kas_desa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tanah_kas_desa_config_fk` (`config_id`);

--
-- Indexes for table `teks_berjalan`
--
ALTER TABLE `teks_berjalan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teks_berjalan_config_fk` (`config_id`);

--
-- Indexes for table `theme`
--
ALTER TABLE `theme`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `theme_slug_config_id_unique` (`slug`,`config_id`),
  ADD KEY `theme_config_id_foreign` (`config_id`);

--
-- Indexes for table `tweb_aset`
--
ALTER TABLE `tweb_aset`
  ADD PRIMARY KEY (`id_aset`);

--
-- Indexes for table `tweb_cacat`
--
ALTER TABLE `tweb_cacat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_cara_kb`
--
ALTER TABLE `tweb_cara_kb`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_desa_pamong`
--
ALTER TABLE `tweb_desa_pamong`
  ADD PRIMARY KEY (`pamong_id`),
  ADD UNIQUE KEY `pamong_tag_id_card_config` (`config_id`,`pamong_tag_id_card`),
  ADD KEY `tweb_desa_pamong_pend_fk` (`id_pend`),
  ADD KEY `tweb_desa_pamong_jabatan_fk` (`jabatan_id`);

--
-- Indexes for table `tweb_golongan_darah`
--
ALTER TABLE `tweb_golongan_darah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_keluarga`
--
ALTER TABLE `tweb_keluarga`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `no_kk_config` (`config_id`,`no_kk`),
  ADD KEY `nik_kepala` (`nik_kepala`),
  ADD KEY `tweb_keluarga_cluster_fk` (`id_cluster`);

--
-- Indexes for table `tweb_keluarga_sejahtera`
--
ALTER TABLE `tweb_keluarga_sejahtera`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk`
--
ALTER TABLE `tweb_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nik_config` (`config_id`,`nik`),
  ADD UNIQUE KEY `tag_id_card_config` (`config_id`,`tag_id_card`),
  ADD UNIQUE KEY `telegram_config` (`config_id`,`telegram`),
  ADD UNIQUE KEY `telegram_token_config` (`config_id`,`telegram_token`),
  ADD UNIQUE KEY `email_token_config` (`config_id`,`email_token`),
  ADD UNIQUE KEY `email_config` (`config_id`,`email`),
  ADD KEY `id_rtm` (`id_rtm`),
  ADD KEY `hubung_warga` (`hubung_warga`),
  ADD KEY `tweb_penduduk_kk_fk` (`id_kk`),
  ADD KEY `tweb_penduduk_cluster_fk` (`id_cluster`);

--
-- Indexes for table `tweb_penduduk_agama`
--
ALTER TABLE `tweb_penduduk_agama`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_asuransi`
--
ALTER TABLE `tweb_penduduk_asuransi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_hubungan`
--
ALTER TABLE `tweb_penduduk_hubungan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_kawin`
--
ALTER TABLE `tweb_penduduk_kawin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_mandiri`
--
ALTER TABLE `tweb_penduduk_mandiri`
  ADD PRIMARY KEY (`id_pend`),
  ADD KEY `tweb_penduduk_mandiri_config_fk` (`config_id`);

--
-- Indexes for table `tweb_penduduk_map`
--
ALTER TABLE `tweb_penduduk_map`
  ADD KEY `tweb_penduduk_map_pend_fk` (`id`);

--
-- Indexes for table `tweb_penduduk_pekerjaan`
--
ALTER TABLE `tweb_penduduk_pekerjaan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_pendidikan`
--
ALTER TABLE `tweb_penduduk_pendidikan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_pendidikan_kk`
--
ALTER TABLE `tweb_penduduk_pendidikan_kk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_sex`
--
ALTER TABLE `tweb_penduduk_sex`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_status`
--
ALTER TABLE `tweb_penduduk_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_umur`
--
ALTER TABLE `tweb_penduduk_umur`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tweb_penduduk_umur_config_fk` (`config_id`);

--
-- Indexes for table `tweb_penduduk_warganegara`
--
ALTER TABLE `tweb_penduduk_warganegara`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_rtm`
--
ALTER TABLE `tweb_rtm`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `no_kk_config` (`config_id`,`no_kk`),
  ADD KEY `tweb_rtm_kepala_fk` (`nik_kepala`);

--
-- Indexes for table `tweb_rtm_hubungan`
--
ALTER TABLE `tweb_rtm_hubungan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_sakit_menahun`
--
ALTER TABLE `tweb_sakit_menahun`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_status_dasar`
--
ALTER TABLE `tweb_status_dasar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_status_ktp`
--
ALTER TABLE `tweb_status_ktp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_surat_format`
--
ALTER TABLE `tweb_surat_format`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url_surat_config` (`config_id`,`url_surat`);

--
-- Indexes for table `tweb_wil_clusterdesa`
--
ALTER TABLE `tweb_wil_clusterdesa`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rt_config` (`config_id`,`rt`,`rw`,`dusun`),
  ADD KEY `id_kepala` (`id_kepala`);

--
-- Indexes for table `urls`
--
ALTER TABLE `urls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `alias` (`alias`),
  ADD KEY `urls_config_fk` (`config_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username_config` (`config_id`,`username`),
  ADD UNIQUE KEY `email_config` (`config_id`,`email`),
  ADD UNIQUE KEY `pamong_id_config` (`config_id`,`pamong_id`),
  ADD KEY `user_grup_fk` (`id_grup`),
  ADD KEY `user_pamong_fk` (`pamong_id`);

--
-- Indexes for table `user_grup`
--
ALTER TABLE `user_grup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug_config` (`config_id`,`slug`),
  ADD UNIQUE KEY `nama_grup_config` (`config_id`,`nama`);

--
-- Indexes for table `widget`
--
ALTER TABLE `widget`
  ADD PRIMARY KEY (`id`),
  ADD KEY `widget_config_fk` (`config_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agenda`
--
ALTER TABLE `agenda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `alias_kodeisian`
--
ALTER TABLE `alias_kodeisian`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `analisis_indikator`
--
ALTER TABLE `analisis_indikator`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `analisis_kategori_indikator`
--
ALTER TABLE `analisis_kategori_indikator`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `analisis_klasifikasi`
--
ALTER TABLE `analisis_klasifikasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `analisis_master`
--
ALTER TABLE `analisis_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `analisis_parameter`
--
ALTER TABLE `analisis_parameter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1052;

--
-- AUTO_INCREMENT for table `analisis_periode`
--
ALTER TABLE `analisis_periode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `analisis_ref_state`
--
ALTER TABLE `analisis_ref_state`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `analisis_ref_subjek`
--
ALTER TABLE `analisis_ref_subjek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `analisis_tipe_indikator`
--
ALTER TABLE `analisis_tipe_indikator`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  MODIFY `id_grup_kontak` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `anjungan`
--
ALTER TABLE `anjungan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `anjungan_menu`
--
ALTER TABLE `anjungan_menu`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `area`
--
ALTER TABLE `area`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `artikel`
--
ALTER TABLE `artikel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=229;

--
-- AUTO_INCREMENT for table `buku_keperluan`
--
ALTER TABLE `buku_keperluan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `buku_kepuasan`
--
ALTER TABLE `buku_kepuasan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `buku_pertanyaan`
--
ALTER TABLE `buku_pertanyaan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `buku_tamu`
--
ALTER TABLE `buku_tamu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bulanan_anak`
--
ALTER TABLE `bulanan_anak`
  MODIFY `id_bulanan_anak` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdesa`
--
ALTER TABLE `cdesa`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdesa_penduduk`
--
ALTER TABLE `cdesa_penduduk`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `config`
--
ALTER TABLE `config`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `covid19_pantau`
--
ALTER TABLE `covid19_pantau`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `covid19_pemudik`
--
ALTER TABLE `covid19_pemudik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_persil`
--
ALTER TABLE `data_persil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_persil_jenis`
--
ALTER TABLE `data_persil_jenis`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_persil_peruntukan`
--
ALTER TABLE `data_persil_peruntukan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  MODIFY `id_disposisi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=212;

--
-- AUTO_INCREMENT for table `dokumen`
--
ALTER TABLE `dokumen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8950;

--
-- AUTO_INCREMENT for table `dtks`
--
ALTER TABLE `dtks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dtks_anggota`
--
ALTER TABLE `dtks_anggota`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dtks_lampiran`
--
ALTER TABLE `dtks_lampiran`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dtks_pengaturan_program`
--
ALTER TABLE `dtks_pengaturan_program`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gambar_gallery`
--
ALTER TABLE `gambar_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `garis`
--
ALTER TABLE `garis`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `gis_simbol`
--
ALTER TABLE `gis_simbol`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=639;

--
-- AUTO_INCREMENT for table `grup_akses`
--
ALTER TABLE `grup_akses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

--
-- AUTO_INCREMENT for table `hubung_warga`
--
ALTER TABLE `hubung_warga`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ibu_hamil`
--
ALTER TABLE `ibu_hamil`
  MODIFY `id_ibu_hamil` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inbox`
--
ALTER TABLE `inbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_asset`
--
ALTER TABLE `inventaris_asset`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_gedung`
--
ALTER TABLE `inventaris_gedung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `inventaris_jalan`
--
ALTER TABLE `inventaris_jalan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_kontruksi`
--
ALTER TABLE `inventaris_kontruksi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_peralatan`
--
ALTER TABLE `inventaris_peralatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `inventaris_tanah`
--
ALTER TABLE `inventaris_tanah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kader_pemberdayaan_masyarakat`
--
ALTER TABLE `kader_pemberdayaan_masyarakat`
  MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `kehadiran_alasan_keluar`
--
ALTER TABLE `kehadiran_alasan_keluar`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kehadiran_hari_libur`
--
ALTER TABLE `kehadiran_hari_libur`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `kehadiran_jam_kerja`
--
ALTER TABLE `kehadiran_jam_kerja`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `kehadiran_pengaduan`
--
ALTER TABLE `kehadiran_pengaduan`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kehadiran_perangkat_desa`
--
ALTER TABLE `kehadiran_perangkat_desa`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=351;

--
-- AUTO_INCREMENT for table `kelompok`
--
ALTER TABLE `kelompok`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kelompok_anggota`
--
ALTER TABLE `kelompok_anggota`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kelompok_master`
--
ALTER TABLE `kelompok_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `keuangan_manual_ref_bidang`
--
ALTER TABLE `keuangan_manual_ref_bidang`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `keuangan_manual_ref_kegiatan`
--
ALTER TABLE `keuangan_manual_ref_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

--
-- AUTO_INCREMENT for table `keuangan_manual_ref_rek1`
--
ALTER TABLE `keuangan_manual_ref_rek1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `keuangan_manual_ref_rek2`
--
ALTER TABLE `keuangan_manual_ref_rek2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `keuangan_manual_ref_rek3`
--
ALTER TABLE `keuangan_manual_ref_rek3`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `keuangan_manual_rinci`
--
ALTER TABLE `keuangan_manual_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `keuangan_manual_rinci_tpl`
--
ALTER TABLE `keuangan_manual_rinci_tpl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `keuangan_master`
--
ALTER TABLE `keuangan_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_bank_desa`
--
ALTER TABLE `keuangan_ref_bank_desa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_bel_operasional`
--
ALTER TABLE `keuangan_ref_bel_operasional`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_bidang`
--
ALTER TABLE `keuangan_ref_bidang`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_bunga`
--
ALTER TABLE `keuangan_ref_bunga`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_desa`
--
ALTER TABLE `keuangan_ref_desa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_kecamatan`
--
ALTER TABLE `keuangan_ref_kecamatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_kegiatan`
--
ALTER TABLE `keuangan_ref_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_korolari`
--
ALTER TABLE `keuangan_ref_korolari`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_neraca_close`
--
ALTER TABLE `keuangan_ref_neraca_close`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_perangkat`
--
ALTER TABLE `keuangan_ref_perangkat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_potongan`
--
ALTER TABLE `keuangan_ref_potongan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_rek1`
--
ALTER TABLE `keuangan_ref_rek1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_rek2`
--
ALTER TABLE `keuangan_ref_rek2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_rek3`
--
ALTER TABLE `keuangan_ref_rek3`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_rek4`
--
ALTER TABLE `keuangan_ref_rek4`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_sbu`
--
ALTER TABLE `keuangan_ref_sbu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ref_sumber`
--
ALTER TABLE `keuangan_ref_sumber`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_anggaran`
--
ALTER TABLE `keuangan_ta_anggaran`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_anggaran_log`
--
ALTER TABLE `keuangan_ta_anggaran_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_anggaran_rinci`
--
ALTER TABLE `keuangan_ta_anggaran_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_bidang`
--
ALTER TABLE `keuangan_ta_bidang`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_desa`
--
ALTER TABLE `keuangan_ta_desa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_jurnal_umum`
--
ALTER TABLE `keuangan_ta_jurnal_umum`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_jurnal_umum_rinci`
--
ALTER TABLE `keuangan_ta_jurnal_umum_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_kegiatan`
--
ALTER TABLE `keuangan_ta_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_mutasi`
--
ALTER TABLE `keuangan_ta_mutasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_pajak`
--
ALTER TABLE `keuangan_ta_pajak`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_pajak_rinci`
--
ALTER TABLE `keuangan_ta_pajak_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_pemda`
--
ALTER TABLE `keuangan_ta_pemda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_pencairan`
--
ALTER TABLE `keuangan_ta_pencairan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_perangkat`
--
ALTER TABLE `keuangan_ta_perangkat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rab`
--
ALTER TABLE `keuangan_ta_rab`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rab_rinci`
--
ALTER TABLE `keuangan_ta_rab_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rab_sub`
--
ALTER TABLE `keuangan_ta_rab_sub`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_bidang`
--
ALTER TABLE `keuangan_ta_rpjm_bidang`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_kegiatan`
--
ALTER TABLE `keuangan_ta_rpjm_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_misi`
--
ALTER TABLE `keuangan_ta_rpjm_misi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_pagu_indikatif`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_indikatif`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_pagu_tahunan`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_tahunan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_sasaran`
--
ALTER TABLE `keuangan_ta_rpjm_sasaran`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_tujuan`
--
ALTER TABLE `keuangan_ta_rpjm_tujuan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_rpjm_visi`
--
ALTER TABLE `keuangan_ta_rpjm_visi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_saldo_awal`
--
ALTER TABLE `keuangan_ta_saldo_awal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spj`
--
ALTER TABLE `keuangan_ta_spj`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spjpot`
--
ALTER TABLE `keuangan_ta_spjpot`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spj_bukti`
--
ALTER TABLE `keuangan_ta_spj_bukti`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spj_rinci`
--
ALTER TABLE `keuangan_ta_spj_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spj_sisa`
--
ALTER TABLE `keuangan_ta_spj_sisa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spp`
--
ALTER TABLE `keuangan_ta_spp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_sppbukti`
--
ALTER TABLE `keuangan_ta_sppbukti`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spppot`
--
ALTER TABLE `keuangan_ta_spppot`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_spp_rinci`
--
ALTER TABLE `keuangan_ta_spp_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_sts`
--
ALTER TABLE `keuangan_ta_sts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_sts_rinci`
--
ALTER TABLE `keuangan_ta_sts_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_tbp`
--
ALTER TABLE `keuangan_ta_tbp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_tbp_rinci`
--
ALTER TABLE `keuangan_ta_tbp_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_triwulan`
--
ALTER TABLE `keuangan_ta_triwulan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `keuangan_ta_triwulan_rinci`
--
ALTER TABLE `keuangan_ta_triwulan_rinci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kia`
--
ALTER TABLE `kia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `klasifikasi_surat`
--
ALTER TABLE `klasifikasi_surat`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2335;

--
-- AUTO_INCREMENT for table `komentar`
--
ALTER TABLE `komentar`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `kontak`
--
ALTER TABLE `kontak`
  MODIFY `id_kontak` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kontak_grup`
--
ALTER TABLE `kontak_grup`
  MODIFY `id_grup` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `laporan_sinkronisasi`
--
ALTER TABLE `laporan_sinkronisasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `line`
--
ALTER TABLE `line`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `log_backup`
--
ALTER TABLE `log_backup`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `log_ekspor`
--
ALTER TABLE `log_ekspor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_hapus_penduduk`
--
ALTER TABLE `log_hapus_penduduk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `log_keluarga`
--
ALTER TABLE `log_keluarga`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1586;

--
-- AUTO_INCREMENT for table `log_notifikasi_admin`
--
ALTER TABLE `log_notifikasi_admin`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_notifikasi_mandiri`
--
ALTER TABLE `log_notifikasi_mandiri`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5366;

--
-- AUTO_INCREMENT for table `log_perubahan_penduduk`
--
ALTER TABLE `log_perubahan_penduduk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4653;

--
-- AUTO_INCREMENT for table `log_restore_desa`
--
ALTER TABLE `log_restore_desa`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_sinkronisasi`
--
ALTER TABLE `log_sinkronisasi`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_surat`
--
ALTER TABLE `log_surat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `log_surat_dinas`
--
ALTER TABLE `log_surat_dinas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_tolak`
--
ALTER TABLE `log_tolak`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_tte`
--
ALTER TABLE `log_tte`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lokasi`
--
ALTER TABLE `lokasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `media_sosial`
--
ALTER TABLE `media_sosial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;

--
-- AUTO_INCREMENT for table `migrasi`
--
ALTER TABLE `migrasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;

--
-- AUTO_INCREMENT for table `mutasi_cdesa`
--
ALTER TABLE `mutasi_cdesa`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_peralatan`
--
ALTER TABLE `mutasi_inventaris_peralatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifikasi`
--
ALTER TABLE `notifikasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `outbox`
--
ALTER TABLE `outbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pelapak`
--
ALTER TABLE `pelapak`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pembangunan`
--
ALTER TABLE `pembangunan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pembangunan_ref_dokumentasi`
--
ALTER TABLE `pembangunan_ref_dokumentasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pendapat`
--
ALTER TABLE `pendapat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pengaduan`
--
ALTER TABLE `pengaduan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permohonan_surat`
--
ALTER TABLE `permohonan_surat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `persil`
--
ALTER TABLE `persil`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pesan`
--
ALTER TABLE `pesan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `point`
--
ALTER TABLE `point`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `polygon`
--
ALTER TABLE `polygon`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `posyandu`
--
ALTER TABLE `posyandu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `produk`
--
ALTER TABLE `produk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `produk_kategori`
--
ALTER TABLE `produk_kategori`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `program`
--
ALTER TABLE `program`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `program_peserta`
--
ALTER TABLE `program_peserta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `ref_asal_tanah_kas`
--
ALTER TABLE `ref_asal_tanah_kas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ref_dokumen`
--
ALTER TABLE `ref_dokumen`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ref_jabatan`
--
ALTER TABLE `ref_jabatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `ref_penduduk_bahasa`
--
ALTER TABLE `ref_penduduk_bahasa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ref_penduduk_bidang`
--
ALTER TABLE `ref_penduduk_bidang`
  MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `ref_penduduk_hamil`
--
ALTER TABLE `ref_penduduk_hamil`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ref_penduduk_kursus`
--
ALTER TABLE `ref_penduduk_kursus`
  MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `ref_penduduk_suku`
--
ALTER TABLE `ref_penduduk_suku`
  MODIFY `id` int(65) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=164;

--
-- AUTO_INCREMENT for table `ref_peristiwa`
--
ALTER TABLE `ref_peristiwa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ref_persil_kelas`
--
ALTER TABLE `ref_persil_kelas`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `ref_persil_mutasi`
--
ALTER TABLE `ref_persil_mutasi`
  MODIFY `id` tinyint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ref_peruntukan_tanah_kas`
--
ALTER TABLE `ref_peruntukan_tanah_kas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `ref_status_covid`
--
ALTER TABLE `ref_status_covid`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `ref_syarat_surat`
--
ALTER TABLE `ref_syarat_surat`
  MODIFY `ref_syarat_id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `sasaran_paud`
--
ALTER TABLE `sasaran_paud`
  MODIFY `id_sasaran_paud` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `setting_aplikasi`
--
ALTER TABLE `setting_aplikasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126673;

--
-- AUTO_INCREMENT for table `setting_modul`
--
ALTER TABLE `setting_modul`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=369;

--
-- AUTO_INCREMENT for table `shortcut`
--
ALTER TABLE `shortcut`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `statistics`
--
ALTER TABLE `statistics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `suplemen`
--
ALTER TABLE `suplemen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `surat_dinas`
--
ALTER TABLE `surat_dinas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `surat_keluar`
--
ALTER TABLE `surat_keluar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `surat_masuk`
--
ALTER TABLE `surat_masuk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=201;

--
-- AUTO_INCREMENT for table `tanah_desa`
--
ALTER TABLE `tanah_desa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tanah_kas_desa`
--
ALTER TABLE `tanah_kas_desa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `teks_berjalan`
--
ALTER TABLE `teks_berjalan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `theme`
--
ALTER TABLE `theme`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `tweb_cacat`
--
ALTER TABLE `tweb_cacat`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tweb_cara_kb`
--
ALTER TABLE `tweb_cara_kb`
  MODIFY `id` tinyint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT for table `tweb_desa_pamong`
--
ALTER TABLE `tweb_desa_pamong`
  MODIFY `pamong_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `tweb_golongan_darah`
--
ALTER TABLE `tweb_golongan_darah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tweb_keluarga`
--
ALTER TABLE `tweb_keluarga`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1312;

--
-- AUTO_INCREMENT for table `tweb_penduduk`
--
ALTER TABLE `tweb_penduduk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4066;

--
-- AUTO_INCREMENT for table `tweb_penduduk_agama`
--
ALTER TABLE `tweb_penduduk_agama`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tweb_penduduk_asuransi`
--
ALTER TABLE `tweb_penduduk_asuransi`
  MODIFY `id` tinyint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `tweb_penduduk_hubungan`
--
ALTER TABLE `tweb_penduduk_hubungan`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tweb_penduduk_kawin`
--
ALTER TABLE `tweb_penduduk_kawin`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tweb_penduduk_mandiri`
--
ALTER TABLE `tweb_penduduk_mandiri`
  MODIFY `id_pend` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pekerjaan`
--
ALTER TABLE `tweb_penduduk_pekerjaan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pendidikan`
--
ALTER TABLE `tweb_penduduk_pendidikan`
  MODIFY `id` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pendidikan_kk`
--
ALTER TABLE `tweb_penduduk_pendidikan_kk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tweb_penduduk_sex`
--
ALTER TABLE `tweb_penduduk_sex`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_penduduk_status`
--
ALTER TABLE `tweb_penduduk_status`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_penduduk_umur`
--
ALTER TABLE `tweb_penduduk_umur`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `tweb_penduduk_warganegara`
--
ALTER TABLE `tweb_penduduk_warganegara`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tweb_rtm`
--
ALTER TABLE `tweb_rtm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_rtm_hubungan`
--
ALTER TABLE `tweb_rtm_hubungan`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_sakit_menahun`
--
ALTER TABLE `tweb_sakit_menahun`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tweb_status_dasar`
--
ALTER TABLE `tweb_status_dasar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tweb_status_ktp`
--
ALTER TABLE `tweb_status_ktp`
  MODIFY `id` tinyint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tweb_surat_format`
--
ALTER TABLE `tweb_surat_format`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT for table `tweb_wil_clusterdesa`
--
ALTER TABLE `tweb_wil_clusterdesa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;

--
-- AUTO_INCREMENT for table `urls`
--
ALTER TABLE `urls`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `user_grup`
--
ALTER TABLE `user_grup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `widget`
--
ALTER TABLE `widget`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

-- --------------------------------------------------------

--
-- Structure for view `dokumen_hidup`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`segitiga_stc`@`localhost` SQL SECURITY DEFINER VIEW `dokumen_hidup`  AS SELECT `dokumen`.`id` AS `id`, `dokumen`.`config_id` AS `config_id`, `dokumen`.`satuan` AS `satuan`, `dokumen`.`nama` AS `nama`, `dokumen`.`enabled` AS `enabled`, `dokumen`.`tgl_upload` AS `tgl_upload`, `dokumen`.`id_pend` AS `id_pend`, `dokumen`.`kategori` AS `kategori`, `dokumen`.`attr` AS `attr`, `dokumen`.`tipe` AS `tipe`, `dokumen`.`url` AS `url`, `dokumen`.`tahun` AS `tahun`, `dokumen`.`kategori_info_publik` AS `kategori_info_publik`, `dokumen`.`updated_at` AS `updated_at`, `dokumen`.`deleted` AS `deleted`, `dokumen`.`id_syarat` AS `id_syarat`, `dokumen`.`id_parent` AS `id_parent`, `dokumen`.`created_at` AS `created_at`, `dokumen`.`created_by` AS `created_by`, `dokumen`.`updated_by` AS `updated_by`, `dokumen`.`dok_warga` AS `dok_warga`, `dokumen`.`lokasi_arsip` AS `lokasi_arsip` FROM `dokumen` WHERE `dokumen`.`deleted` <> 1 ;

-- --------------------------------------------------------

--
-- Structure for view `keluarga_aktif`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`segitiga_stc`@`localhost` SQL SECURITY DEFINER VIEW `keluarga_aktif`  AS SELECT `k`.`id` AS `id`, `k`.`config_id` AS `config_id`, `k`.`no_kk` AS `no_kk`, `k`.`nik_kepala` AS `nik_kepala`, `k`.`tgl_daftar` AS `tgl_daftar`, `k`.`kelas_sosial` AS `kelas_sosial`, `k`.`tgl_cetak_kk` AS `tgl_cetak_kk`, `k`.`alamat` AS `alamat`, `k`.`id_cluster` AS `id_cluster`, `k`.`updated_at` AS `updated_at`, `k`.`updated_by` AS `updated_by` FROM (`tweb_keluarga` `k` left join `tweb_penduduk` `p` on(`k`.`nik_kepala` = `p`.`id`)) WHERE `p`.`status_dasar` = 1 ;

-- --------------------------------------------------------

--
-- Structure for view `master_inventaris`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`segitiga_stc`@`localhost` SQL SECURITY DEFINER VIEW `master_inventaris`  AS SELECT 'inventaris_asset' AS `asset`, `inventaris_asset`.`config_id` AS `config_id`, `inventaris_asset`.`id` AS `id`, `inventaris_asset`.`nama_barang` AS `nama_barang`, `inventaris_asset`.`kode_barang` AS `kode_barang`, 'Baik' AS `kondisi`, `inventaris_asset`.`keterangan` AS `keterangan`, `inventaris_asset`.`asal` AS `asal`, `inventaris_asset`.`tahun_pengadaan` AS `tahun_pengadaan` FROM `inventaris_asset` WHERE `inventaris_asset`.`visible` = 1 union all select 'inventaris_gedung' AS `asset`,`inventaris_gedung`.`config_id` AS `config_id`,`inventaris_gedung`.`id` AS `id`,`inventaris_gedung`.`nama_barang` AS `nama_barang`,`inventaris_gedung`.`kode_barang` AS `kode_barang`,`inventaris_gedung`.`kondisi_bangunan` AS `kondisi_bangunan`,`inventaris_gedung`.`keterangan` AS `keterangan`,`inventaris_gedung`.`asal` AS `asal`,year(`inventaris_gedung`.`tanggal_dokument`) AS `tahun_pengadaan` from `inventaris_gedung` where `inventaris_gedung`.`visible` = 1 union all select 'inventaris_jalan' AS `asset`,`inventaris_jalan`.`config_id` AS `config_id`,`inventaris_jalan`.`id` AS `id`,`inventaris_jalan`.`nama_barang` AS `nama_barang`,`inventaris_jalan`.`kode_barang` AS `kode_barang`,`inventaris_jalan`.`kondisi` AS `kondisi`,`inventaris_jalan`.`keterangan` AS `keterangan`,`inventaris_jalan`.`asal` AS `asal`,year(`inventaris_jalan`.`tanggal_dokument`) AS `tahun_pengadaan` from `inventaris_jalan` where `inventaris_jalan`.`visible` = 1 union all select 'inventaris_peralatan' AS `asset`,`inventaris_peralatan`.`config_id` AS `config_id`,`inventaris_peralatan`.`id` AS `id`,`inventaris_peralatan`.`nama_barang` AS `nama_barang`,`inventaris_peralatan`.`kode_barang` AS `kode_barang`,'Baik' AS `Baik`,`inventaris_peralatan`.`keterangan` AS `keterangan`,`inventaris_peralatan`.`asal` AS `asal`,`inventaris_peralatan`.`tahun_pengadaan` AS `tahun_pengadaan` from `inventaris_peralatan` where `inventaris_peralatan`.`visible` = 1  ;

-- --------------------------------------------------------

--
-- Structure for view `penduduk_hidup`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`segitiga_stc`@`localhost` SQL SECURITY DEFINER VIEW `penduduk_hidup`  AS SELECT `tweb_penduduk`.`id` AS `id`, `tweb_penduduk`.`config_id` AS `config_id`, `tweb_penduduk`.`nama` AS `nama`, `tweb_penduduk`.`nik` AS `nik`, `tweb_penduduk`.`id_kk` AS `id_kk`, `tweb_penduduk`.`kk_level` AS `kk_level`, `tweb_penduduk`.`id_rtm` AS `id_rtm`, `tweb_penduduk`.`rtm_level` AS `rtm_level`, `tweb_penduduk`.`sex` AS `sex`, `tweb_penduduk`.`tempatlahir` AS `tempatlahir`, `tweb_penduduk`.`tanggallahir` AS `tanggallahir`, `tweb_penduduk`.`agama_id` AS `agama_id`, `tweb_penduduk`.`pendidikan_kk_id` AS `pendidikan_kk_id`, `tweb_penduduk`.`pendidikan_sedang_id` AS `pendidikan_sedang_id`, `tweb_penduduk`.`pekerjaan_id` AS `pekerjaan_id`, `tweb_penduduk`.`status_kawin` AS `status_kawin`, `tweb_penduduk`.`warganegara_id` AS `warganegara_id`, `tweb_penduduk`.`dokumen_pasport` AS `dokumen_pasport`, `tweb_penduduk`.`dokumen_kitas` AS `dokumen_kitas`, `tweb_penduduk`.`ayah_nik` AS `ayah_nik`, `tweb_penduduk`.`ibu_nik` AS `ibu_nik`, `tweb_penduduk`.`nama_ayah` AS `nama_ayah`, `tweb_penduduk`.`nama_ibu` AS `nama_ibu`, `tweb_penduduk`.`foto` AS `foto`, `tweb_penduduk`.`golongan_darah_id` AS `golongan_darah_id`, `tweb_penduduk`.`id_cluster` AS `id_cluster`, `tweb_penduduk`.`status` AS `status`, `tweb_penduduk`.`alamat_sebelumnya` AS `alamat_sebelumnya`, `tweb_penduduk`.`alamat_sekarang` AS `alamat_sekarang`, `tweb_penduduk`.`status_dasar` AS `status_dasar`, `tweb_penduduk`.`hamil` AS `hamil`, `tweb_penduduk`.`cacat_id` AS `cacat_id`, `tweb_penduduk`.`sakit_menahun_id` AS `sakit_menahun_id`, `tweb_penduduk`.`akta_lahir` AS `akta_lahir`, `tweb_penduduk`.`akta_perkawinan` AS `akta_perkawinan`, `tweb_penduduk`.`tanggalperkawinan` AS `tanggalperkawinan`, `tweb_penduduk`.`akta_perceraian` AS `akta_perceraian`, `tweb_penduduk`.`tanggalperceraian` AS `tanggalperceraian`, `tweb_penduduk`.`cara_kb_id` AS `cara_kb_id`, `tweb_penduduk`.`telepon` AS `telepon`, `tweb_penduduk`.`tanggal_akhir_paspor` AS `tanggal_akhir_paspor`, `tweb_penduduk`.`no_kk_sebelumnya` AS `no_kk_sebelumnya`, `tweb_penduduk`.`ktp_el` AS `ktp_el`, `tweb_penduduk`.`status_rekam` AS `status_rekam`, `tweb_penduduk`.`waktu_lahir` AS `waktu_lahir`, `tweb_penduduk`.`tempat_dilahirkan` AS `tempat_dilahirkan`, `tweb_penduduk`.`jenis_kelahiran` AS `jenis_kelahiran`, `tweb_penduduk`.`kelahiran_anak_ke` AS `kelahiran_anak_ke`, `tweb_penduduk`.`penolong_kelahiran` AS `penolong_kelahiran`, `tweb_penduduk`.`berat_lahir` AS `berat_lahir`, `tweb_penduduk`.`panjang_lahir` AS `panjang_lahir`, `tweb_penduduk`.`tag_id_card` AS `tag_id_card`, `tweb_penduduk`.`created_at` AS `created_at`, `tweb_penduduk`.`created_by` AS `created_by`, `tweb_penduduk`.`updated_at` AS `updated_at`, `tweb_penduduk`.`updated_by` AS `updated_by`, `tweb_penduduk`.`id_asuransi` AS `id_asuransi`, `tweb_penduduk`.`no_asuransi` AS `no_asuransi`, `tweb_penduduk`.`email` AS `email`, `tweb_penduduk`.`email_token` AS `email_token`, `tweb_penduduk`.`email_tgl_kadaluarsa` AS `email_tgl_kadaluarsa`, `tweb_penduduk`.`email_tgl_verifikasi` AS `email_tgl_verifikasi`, `tweb_penduduk`.`telegram` AS `telegram`, `tweb_penduduk`.`telegram_token` AS `telegram_token`, `tweb_penduduk`.`telegram_tgl_kadaluarsa` AS `telegram_tgl_kadaluarsa`, `tweb_penduduk`.`telegram_tgl_verifikasi` AS `telegram_tgl_verifikasi`, `tweb_penduduk`.`bahasa_id` AS `bahasa_id`, `tweb_penduduk`.`ket` AS `ket`, `tweb_penduduk`.`negara_asal` AS `negara_asal`, `tweb_penduduk`.`tempat_cetak_ktp` AS `tempat_cetak_ktp`, `tweb_penduduk`.`tanggal_cetak_ktp` AS `tanggal_cetak_ktp`, `tweb_penduduk`.`suku` AS `suku`, `tweb_penduduk`.`bpjs_ketenagakerjaan` AS `bpjs_ketenagakerjaan`, `tweb_penduduk`.`hubung_warga` AS `hubung_warga` FROM `tweb_penduduk` WHERE `tweb_penduduk`.`status_dasar` = 1 ;

-- --------------------------------------------------------

--
-- Structure for view `rekap_mutasi_inventaris`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`segitiga_stc`@`localhost` SQL SECURITY DEFINER VIEW `rekap_mutasi_inventaris`  AS SELECT 'inventaris_asset' AS `asset`, `mutasi_inventaris_asset`.`config_id` AS `config_id`, `mutasi_inventaris_asset`.`id_inventaris_asset` AS `id_inventaris_asset`, `mutasi_inventaris_asset`.`status_mutasi` AS `status_mutasi`, `mutasi_inventaris_asset`.`jenis_mutasi` AS `jenis_mutasi`, `mutasi_inventaris_asset`.`tahun_mutasi` AS `tahun_mutasi`, `mutasi_inventaris_asset`.`keterangan` AS `keterangan` FROM `mutasi_inventaris_asset` WHERE `mutasi_inventaris_asset`.`visible` = 1 union all select 'inventaris_gedung' AS `inventaris_gedung`,`mutasi_inventaris_gedung`.`config_id` AS `config_id`,`mutasi_inventaris_gedung`.`id_inventaris_gedung` AS `id_inventaris_gedung`,`mutasi_inventaris_gedung`.`status_mutasi` AS `status_mutasi`,`mutasi_inventaris_gedung`.`jenis_mutasi` AS `jenis_mutasi`,`mutasi_inventaris_gedung`.`tahun_mutasi` AS `tahun_mutasi`,`mutasi_inventaris_gedung`.`keterangan` AS `keterangan` from `mutasi_inventaris_gedung` where `mutasi_inventaris_gedung`.`visible` = 1 union all select 'inventaris_jalan' AS `inventaris_jalan`,`mutasi_inventaris_jalan`.`config_id` AS `config_id`,`mutasi_inventaris_jalan`.`id_inventaris_jalan` AS `id_inventaris_jalan`,`mutasi_inventaris_jalan`.`status_mutasi` AS `status_mutasi`,`mutasi_inventaris_jalan`.`jenis_mutasi` AS `jenis_mutasi`,`mutasi_inventaris_jalan`.`tahun_mutasi` AS `tahun_mutasi`,`mutasi_inventaris_jalan`.`keterangan` AS `keterangan` from `mutasi_inventaris_jalan` where `mutasi_inventaris_jalan`.`visible` = 1 union all select 'inventaris_peralatan' AS `inventaris_peralatan`,`mutasi_inventaris_peralatan`.`config_id` AS `config_id`,`mutasi_inventaris_peralatan`.`id_inventaris_peralatan` AS `id_inventaris_peralatan`,`mutasi_inventaris_peralatan`.`status_mutasi` AS `status_mutasi`,`mutasi_inventaris_peralatan`.`jenis_mutasi` AS `jenis_mutasi`,`mutasi_inventaris_peralatan`.`tahun_mutasi` AS `tahun_mutasi`,`mutasi_inventaris_peralatan`.`keterangan` AS `keterangan` from `mutasi_inventaris_peralatan` where `mutasi_inventaris_peralatan`.`visible` = 1  ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `agenda`
--
ALTER TABLE `agenda`
  ADD CONSTRAINT `agenda_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_artikel_fk` FOREIGN KEY (`id_artikel`) REFERENCES `artikel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `alias_kodeisian`
--
ALTER TABLE `alias_kodeisian`
  ADD CONSTRAINT `alias_kodeisian_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_indikator`
--
ALTER TABLE `analisis_indikator`
  ADD CONSTRAINT `analisis_indikator_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_indikator_id_kategori_fk` FOREIGN KEY (`id_kategori`) REFERENCES `analisis_kategori_indikator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_indikator_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_indikator_tipe_fk` FOREIGN KEY (`id_tipe`) REFERENCES `analisis_tipe_indikator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_kategori_indikator`
--
ALTER TABLE `analisis_kategori_indikator`
  ADD CONSTRAINT `analisis_kategori_indikator_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_kategori_indikator_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_klasifikasi`
--
ALTER TABLE `analisis_klasifikasi`
  ADD CONSTRAINT `analisis_klasifikasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_klasifikasi_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_master`
--
ALTER TABLE `analisis_master`
  ADD CONSTRAINT `analisis_master_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_master_subjek_fk` FOREIGN KEY (`subjek_tipe`) REFERENCES `analisis_ref_subjek` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_parameter`
--
ALTER TABLE `analisis_parameter`
  ADD CONSTRAINT `analisis_parameter_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_parameter_indikator_fk` FOREIGN KEY (`id_indikator`) REFERENCES `analisis_indikator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_partisipasi`
--
ALTER TABLE `analisis_partisipasi`
  ADD CONSTRAINT `analisis_partisipasi_klasifikasi_fk` FOREIGN KEY (`id_klassifikasi`) REFERENCES `analisis_klasifikasi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_partisipasi_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_partisipasi_periode_fk` FOREIGN KEY (`id_periode`) REFERENCES `analisis_periode` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_partisipasi_subjek_fk` FOREIGN KEY (`id_subjek`) REFERENCES `analisis_parameter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_periode`
--
ALTER TABLE `analisis_periode`
  ADD CONSTRAINT `analisis_periode_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_periode_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `state_fk` FOREIGN KEY (`id_state`) REFERENCES `analisis_ref_state` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_respon`
--
ALTER TABLE `analisis_respon`
  ADD CONSTRAINT `analisis_respon_indikator_fk` FOREIGN KEY (`id_indikator`) REFERENCES `analisis_indikator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_parameter_fk` FOREIGN KEY (`id_parameter`) REFERENCES `analisis_parameter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_periode_fk` FOREIGN KEY (`id_periode`) REFERENCES `analisis_periode` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_subjek_fk` FOREIGN KEY (`id_subjek`) REFERENCES `analisis_parameter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_respon_bukti`
--
ALTER TABLE `analisis_respon_bukti`
  ADD CONSTRAINT `analisis_respon_bukti_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_bukti_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_bukti_periode_fk` FOREIGN KEY (`id_periode`) REFERENCES `analisis_periode` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_bukti_subjek_fk` FOREIGN KEY (`id_subjek`) REFERENCES `analisis_ref_subjek` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `analisis_respon_hasil`
--
ALTER TABLE `analisis_respon_hasil`
  ADD CONSTRAINT `analisis_respon_hasil_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_hasil_master_fk` FOREIGN KEY (`id_master`) REFERENCES `analisis_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_hasil_periode_fk` FOREIGN KEY (`id_periode`) REFERENCES `analisis_periode` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analisis_respon_hasil_subjek_fk` FOREIGN KEY (`id_subjek`) REFERENCES `analisis_parameter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  ADD CONSTRAINT `anggota_grup_kontak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `anggota_grup_kontak_id_penduduk_fk` FOREIGN KEY (`id_penduduk`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `anggota_grup_kontak_ke_kontak` FOREIGN KEY (`id_kontak`) REFERENCES `kontak` (`id_kontak`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `anggota_grup_kontak_ke_kontak_grup` FOREIGN KEY (`id_grup`) REFERENCES `kontak_grup` (`id_grup`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `anjungan`
--
ALTER TABLE `anjungan`
  ADD CONSTRAINT `anjungan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `anjungan_menu`
--
ALTER TABLE `anjungan_menu`
  ADD CONSTRAINT `anjungan_menu_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `area`
--
ALTER TABLE `area`
  ADD CONSTRAINT `area_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `area_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `artikel`
--
ALTER TABLE `artikel`
  ADD CONSTRAINT `artikel_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `artikel_kategori_fk` FOREIGN KEY (`id_kategori`) REFERENCES `kategori` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `artikel_kategori_id_user_fk` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `buku_keperluan`
--
ALTER TABLE `buku_keperluan`
  ADD CONSTRAINT `buku_keperluan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `buku_kepuasan`
--
ALTER TABLE `buku_kepuasan`
  ADD CONSTRAINT `buku_kepuasan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `buku_kepuasan_nama_fk` FOREIGN KEY (`id_nama`) REFERENCES `buku_tamu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `buku_kepuasan_pertanyaan_fk` FOREIGN KEY (`id_pertanyaan`) REFERENCES `buku_pertanyaan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `buku_pertanyaan`
--
ALTER TABLE `buku_pertanyaan`
  ADD CONSTRAINT `buku_pertanyaan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `buku_tamu`
--
ALTER TABLE `buku_tamu`
  ADD CONSTRAINT `buku_tamu_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `bulanan_anak`
--
ALTER TABLE `bulanan_anak`
  ADD CONSTRAINT `bulanan_anak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `bulanan_anak_kia_fk` FOREIGN KEY (`kia_id`) REFERENCES `kia` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `bulanan_anak_posyandu_fk` FOREIGN KEY (`posyandu_id`) REFERENCES `posyandu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cdesa`
--
ALTER TABLE `cdesa`
  ADD CONSTRAINT `cdesa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cdesa_penduduk`
--
ALTER TABLE `cdesa_penduduk`
  ADD CONSTRAINT `cdesa_penduduk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cdesa_penduduk_fk` FOREIGN KEY (`id_cdesa`) REFERENCES `cdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cdesa_penduduk_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `covid19_pantau`
--
ALTER TABLE `covid19_pantau`
  ADD CONSTRAINT `covid19_pantau_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_pantau_pemudik` FOREIGN KEY (`id_pemudik`) REFERENCES `covid19_pemudik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `covid19_pemudik`
--
ALTER TABLE `covid19_pemudik`
  ADD CONSTRAINT `covid19_pemudik_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_pemudik_penduduk` FOREIGN KEY (`id_terdata`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `covid19_vaksin`
--
ALTER TABLE `covid19_vaksin`
  ADD CONSTRAINT `covid19_vaksin_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  ADD CONSTRAINT `desa_pamong_fk` FOREIGN KEY (`id_desa_pamong`) REFERENCES `tweb_desa_pamong` (`pamong_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `disposisi_surat_masuk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_surat_fk` FOREIGN KEY (`id_surat_masuk`) REFERENCES `surat_masuk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dokumen`
--
ALTER TABLE `dokumen`
  ADD CONSTRAINT `dokumen_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtks`
--
ALTER TABLE `dtks`
  ADD CONSTRAINT `FK_dtks_rtm` FOREIGN KEY (`id_rtm`) REFERENCES `tweb_rtm` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_kel_dtks` FOREIGN KEY (`id_keluarga`) REFERENCES `tweb_keluarga` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtks_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtks_anggota`
--
ALTER TABLE `dtks_anggota`
  ADD CONSTRAINT `FK_dtks_dtks_anggota` FOREIGN KEY (`id_dtks`) REFERENCES `dtks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_kel_dtks_anggota` FOREIGN KEY (`id_keluarga`) REFERENCES `tweb_keluarga` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_pend_dtks_anggota` FOREIGN KEY (`id_penduduk`) REFERENCES `tweb_penduduk` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `dtks_anggota_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtks_lampiran`
--
ALTER TABLE `dtks_lampiran`
  ADD CONSTRAINT `FK_dtks_lampiran_rtm` FOREIGN KEY (`id_rtm`) REFERENCES `tweb_rtm` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `dtks_lampiran_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtks_pengaturan_program`
--
ALTER TABLE `dtks_pengaturan_program`
  ADD CONSTRAINT `FK_dtks_p_program` FOREIGN KEY (`id_bantuan`) REFERENCES `program` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtks_pengaturan_program_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtks_ref_lampiran`
--
ALTER TABLE `dtks_ref_lampiran`
  ADD CONSTRAINT `FK_lampiran_dtks` FOREIGN KEY (`id_lampiran`) REFERENCES `dtks_lampiran` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_ref_lampiran_dtks` FOREIGN KEY (`id_dtks`) REFERENCES `dtks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `fcm_token`
--
ALTER TABLE `fcm_token`
  ADD CONSTRAINT `fcm_token_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fcm_token_dd_user_fk` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `fcm_token_mandiri`
--
ALTER TABLE `fcm_token_mandiri`
  ADD CONSTRAINT `fcm_token_mandiri_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fcm_token_mandiri_user_mandiri_fk` FOREIGN KEY (`id_user_mandiri`) REFERENCES `tweb_penduduk_mandiri` (`id_pend`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `gambar_gallery`
--
ALTER TABLE `gambar_gallery`
  ADD CONSTRAINT `gambar_gallery_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `garis`
--
ALTER TABLE `garis`
  ADD CONSTRAINT `garis_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `garis_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `gis_simbol`
--
ALTER TABLE `gis_simbol`
  ADD CONSTRAINT `gis_simbol_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `grup_akses`
--
ALTER TABLE `grup_akses`
  ADD CONSTRAINT `fk_id_grup` FOREIGN KEY (`id_grup`) REFERENCES `user_grup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_id_modul` FOREIGN KEY (`id_modul`) REFERENCES `setting_modul` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `grup_akses_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `hubung_warga`
--
ALTER TABLE `hubung_warga`
  ADD CONSTRAINT `hubung_warga_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `hubung_warga_id_grup_fk` FOREIGN KEY (`id_grup`) REFERENCES `kontak_grup` (`id_grup`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ibu_hamil`
--
ALTER TABLE `ibu_hamil`
  ADD CONSTRAINT `ibu_hamil_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ibu_hamil_kia_fk` FOREIGN KEY (`kia_id`) REFERENCES `kia` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ibu_hamil_posyandu_fk` FOREIGN KEY (`posyandu_id`) REFERENCES `posyandu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inbox`
--
ALTER TABLE `inbox`
  ADD CONSTRAINT `inbox_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_asset`
--
ALTER TABLE `inventaris_asset`
  ADD CONSTRAINT `inventaris_asset_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_gedung`
--
ALTER TABLE `inventaris_gedung`
  ADD CONSTRAINT `inventaris_gedung_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_jalan`
--
ALTER TABLE `inventaris_jalan`
  ADD CONSTRAINT `inventaris_jalan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_kontruksi`
--
ALTER TABLE `inventaris_kontruksi`
  ADD CONSTRAINT `inventaris_kontruksi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_peralatan`
--
ALTER TABLE `inventaris_peralatan`
  ADD CONSTRAINT `inventaris_peralatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventaris_tanah`
--
ALTER TABLE `inventaris_tanah`
  ADD CONSTRAINT `inventaris_tanah_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kader_pemberdayaan_masyarakat`
--
ALTER TABLE `kader_pemberdayaan_masyarakat`
  ADD CONSTRAINT `kader_pemberdayaan_masyarakat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kader_pemberdayaan_masyarakat_penduduk_fk` FOREIGN KEY (`penduduk_id`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kategori`
--
ALTER TABLE `kategori`
  ADD CONSTRAINT `kategori_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kehadiran_alasan_keluar`
--
ALTER TABLE `kehadiran_alasan_keluar`
  ADD CONSTRAINT `kehadiran_alasan_keluar_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kehadiran_hari_libur`
--
ALTER TABLE `kehadiran_hari_libur`
  ADD CONSTRAINT `kehadiran_hari_libur_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kehadiran_jam_kerja`
--
ALTER TABLE `kehadiran_jam_kerja`
  ADD CONSTRAINT `kehadiran_jam_kerja_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kehadiran_pengaduan`
--
ALTER TABLE `kehadiran_pengaduan`
  ADD CONSTRAINT `kehadiran_pengaduan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kehadiran_pengaduan_pamong_fk` FOREIGN KEY (`id_pamong`) REFERENCES `tweb_desa_pamong` (`pamong_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kehadiran_pengaduan_penduduk_fk` FOREIGN KEY (`id_penduduk`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kehadiran_perangkat_desa`
--
ALTER TABLE `kehadiran_perangkat_desa`
  ADD CONSTRAINT `kehadiran_perangkat_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kehadiran_perangkat_desa_pamong_fk` FOREIGN KEY (`pamong_id`) REFERENCES `tweb_desa_pamong` (`pamong_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelompok`
--
ALTER TABLE `kelompok`
  ADD CONSTRAINT `kelompok_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelompok_kelompok_master_fk` FOREIGN KEY (`id_master`) REFERENCES `kelompok_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelompok_ketua_fk` FOREIGN KEY (`id_ketua`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelompok_anggota`
--
ALTER TABLE `kelompok_anggota`
  ADD CONSTRAINT `kelompok_anggota_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelompok_anggota_kelompok_fk` FOREIGN KEY (`id_kelompok`) REFERENCES `kelompok` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelompok_anggota_penduduk_fk` FOREIGN KEY (`id_penduduk`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelompok_master`
--
ALTER TABLE `kelompok_master`
  ADD CONSTRAINT `kelompok_master_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_manual_rinci`
--
ALTER TABLE `keuangan_manual_rinci`
  ADD CONSTRAINT `keuangan_manual_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_master`
--
ALTER TABLE `keuangan_master`
  ADD CONSTRAINT `keuangan_master_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_bank_desa`
--
ALTER TABLE `keuangan_ref_bank_desa`
  ADD CONSTRAINT `id_keuangan_ref_bank_desa_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_bank_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_bel_operasional`
--
ALTER TABLE `keuangan_ref_bel_operasional`
  ADD CONSTRAINT `id_keuangan_ref_bel_operasional_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_bel_operasional_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_bidang`
--
ALTER TABLE `keuangan_ref_bidang`
  ADD CONSTRAINT `id_keuangan_ref_bidang_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_bidang_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_bunga`
--
ALTER TABLE `keuangan_ref_bunga`
  ADD CONSTRAINT `id_keuangan_ref_bunga_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_bunga_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_desa`
--
ALTER TABLE `keuangan_ref_desa`
  ADD CONSTRAINT `id_keuangan_ref_desa_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_kecamatan`
--
ALTER TABLE `keuangan_ref_kecamatan`
  ADD CONSTRAINT `id_keuangan_ref_kecamatan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_kecamatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_kegiatan`
--
ALTER TABLE `keuangan_ref_kegiatan`
  ADD CONSTRAINT `id_keuangan_ref_kegiatan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_kegiatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_korolari`
--
ALTER TABLE `keuangan_ref_korolari`
  ADD CONSTRAINT `id_keuangan_ref_korolari_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_korolari_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_neraca_close`
--
ALTER TABLE `keuangan_ref_neraca_close`
  ADD CONSTRAINT `id_keuangan_ref_neraca_close_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_neraca_close_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_perangkat`
--
ALTER TABLE `keuangan_ref_perangkat`
  ADD CONSTRAINT `id_keuangan_ref_perangkat_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_perangkat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_potongan`
--
ALTER TABLE `keuangan_ref_potongan`
  ADD CONSTRAINT `id_keuangan_ref_potongan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_potongan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_rek1`
--
ALTER TABLE `keuangan_ref_rek1`
  ADD CONSTRAINT `id_keuangan_ref_rek1_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_rek1_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_rek2`
--
ALTER TABLE `keuangan_ref_rek2`
  ADD CONSTRAINT `id_keuangan_ref_rek2_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_rek2_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_rek3`
--
ALTER TABLE `keuangan_ref_rek3`
  ADD CONSTRAINT `id_keuangan_ref_rek3_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_rek3_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_rek4`
--
ALTER TABLE `keuangan_ref_rek4`
  ADD CONSTRAINT `id_keuangan_ref_rek4_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_rek4_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_sbu`
--
ALTER TABLE `keuangan_ref_sbu`
  ADD CONSTRAINT `id_keuangan_ref_sbu_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_sbu_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ref_sumber`
--
ALTER TABLE `keuangan_ref_sumber`
  ADD CONSTRAINT `id_keuangan_ref_sumber_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ref_sumber_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_anggaran`
--
ALTER TABLE `keuangan_ta_anggaran`
  ADD CONSTRAINT `id_keuangan_ta_anggaran_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_anggaran_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_anggaran_log`
--
ALTER TABLE `keuangan_ta_anggaran_log`
  ADD CONSTRAINT `id_keuangan_ta_anggaran_log_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_anggaran_log_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_anggaran_rinci`
--
ALTER TABLE `keuangan_ta_anggaran_rinci`
  ADD CONSTRAINT `id_keuangan_ta_anggaran_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_anggaran_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_bidang`
--
ALTER TABLE `keuangan_ta_bidang`
  ADD CONSTRAINT `id_keuangan_ta_bidang_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_bidang_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_desa`
--
ALTER TABLE `keuangan_ta_desa`
  ADD CONSTRAINT `id_keuangan_ta_desa_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_jurnal_umum`
--
ALTER TABLE `keuangan_ta_jurnal_umum`
  ADD CONSTRAINT `id_keuangan_ta_jurnal_umum_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_jurnal_umum_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_jurnal_umum_rinci`
--
ALTER TABLE `keuangan_ta_jurnal_umum_rinci`
  ADD CONSTRAINT `id_keuangan_ta_jurnal_umum_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_jurnal_umum_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_kegiatan`
--
ALTER TABLE `keuangan_ta_kegiatan`
  ADD CONSTRAINT `id_keuangan_ta_kegiatan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_kegiatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_mutasi`
--
ALTER TABLE `keuangan_ta_mutasi`
  ADD CONSTRAINT `id_keuangan_ta_mutasi_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_mutasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_pajak`
--
ALTER TABLE `keuangan_ta_pajak`
  ADD CONSTRAINT `id_keuangan_ta_pajak_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_pajak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_pajak_rinci`
--
ALTER TABLE `keuangan_ta_pajak_rinci`
  ADD CONSTRAINT `id_keuangan_ta_pajak_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_pajak_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_pemda`
--
ALTER TABLE `keuangan_ta_pemda`
  ADD CONSTRAINT `id_keuangan_ta_pemda_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_pemda_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_pencairan`
--
ALTER TABLE `keuangan_ta_pencairan`
  ADD CONSTRAINT `id_keuangan_ta_pencairan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_pencairan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_perangkat`
--
ALTER TABLE `keuangan_ta_perangkat`
  ADD CONSTRAINT `id_keuangan_ta_perangkat_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_perangkat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rab`
--
ALTER TABLE `keuangan_ta_rab`
  ADD CONSTRAINT `id_keuangan_ta_rab_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rab_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rab_rinci`
--
ALTER TABLE `keuangan_ta_rab_rinci`
  ADD CONSTRAINT `id_keuangan_ta_rab_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rab_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rab_sub`
--
ALTER TABLE `keuangan_ta_rab_sub`
  ADD CONSTRAINT `id_keuangan_ta_rab_sub_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rab_sub_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_bidang`
--
ALTER TABLE `keuangan_ta_rpjm_bidang`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_bidang_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_bidang_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_kegiatan`
--
ALTER TABLE `keuangan_ta_rpjm_kegiatan`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_kegiatan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_kegiatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_misi`
--
ALTER TABLE `keuangan_ta_rpjm_misi`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_misi_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_misi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_pagu_indikatif`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_indikatif`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_pagu_indikatif_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_pagu_indikatif_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_pagu_tahunan`
--
ALTER TABLE `keuangan_ta_rpjm_pagu_tahunan`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_pagu_tahunan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_pagu_tahunan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_sasaran`
--
ALTER TABLE `keuangan_ta_rpjm_sasaran`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_sasaran_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_sasaran_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_tujuan`
--
ALTER TABLE `keuangan_ta_rpjm_tujuan`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_tujuan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_tujuan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_rpjm_visi`
--
ALTER TABLE `keuangan_ta_rpjm_visi`
  ADD CONSTRAINT `id_keuangan_ta_rpjm_visi_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_rpjm_visi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_saldo_awal`
--
ALTER TABLE `keuangan_ta_saldo_awal`
  ADD CONSTRAINT `id_keuangan_ta_saldo_awal_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_saldo_awal_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spj`
--
ALTER TABLE `keuangan_ta_spj`
  ADD CONSTRAINT `id_keuangan_ta_spj_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spj_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spjpot`
--
ALTER TABLE `keuangan_ta_spjpot`
  ADD CONSTRAINT `id_keuangan_ta_spjpot_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spjpot_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spj_bukti`
--
ALTER TABLE `keuangan_ta_spj_bukti`
  ADD CONSTRAINT `id_keuangan_ta_spj_bukti_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spj_bukti_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spj_rinci`
--
ALTER TABLE `keuangan_ta_spj_rinci`
  ADD CONSTRAINT `id_keuangan_ta_spj_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spj_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spj_sisa`
--
ALTER TABLE `keuangan_ta_spj_sisa`
  ADD CONSTRAINT `id_keuangan_ta_spj_sisa_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spj_sisa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spp`
--
ALTER TABLE `keuangan_ta_spp`
  ADD CONSTRAINT `id_keuangan_ta_spp_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spp_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_sppbukti`
--
ALTER TABLE `keuangan_ta_sppbukti`
  ADD CONSTRAINT `id_keuangan_ta_sppbukti_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_sppbukti_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spppot`
--
ALTER TABLE `keuangan_ta_spppot`
  ADD CONSTRAINT `id_keuangan_ta_spppot_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spppot_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_spp_rinci`
--
ALTER TABLE `keuangan_ta_spp_rinci`
  ADD CONSTRAINT `id_keuangan_ta_spp_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_spp_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_sts`
--
ALTER TABLE `keuangan_ta_sts`
  ADD CONSTRAINT `id_keuangan_ta_sts_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_sts_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_sts_rinci`
--
ALTER TABLE `keuangan_ta_sts_rinci`
  ADD CONSTRAINT `id_keuangan_ta_sts_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_sts_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_tbp`
--
ALTER TABLE `keuangan_ta_tbp`
  ADD CONSTRAINT `id_keuangan_ta_tbp_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_tbp_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_tbp_rinci`
--
ALTER TABLE `keuangan_ta_tbp_rinci`
  ADD CONSTRAINT `id_keuangan_ta_tbp_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_tbp_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_triwulan`
--
ALTER TABLE `keuangan_ta_triwulan`
  ADD CONSTRAINT `id_keuangan_ta_triwulan_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_triwulan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `keuangan_ta_triwulan_rinci`
--
ALTER TABLE `keuangan_ta_triwulan_rinci`
  ADD CONSTRAINT `id_keuangan_ta_triwulan_rinci_master_fk` FOREIGN KEY (`id_keuangan_master`) REFERENCES `keuangan_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `keuangan_ta_triwulan_rinci_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kia`
--
ALTER TABLE `kia`
  ADD CONSTRAINT `kia_anak_fk` FOREIGN KEY (`anak_id`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kia_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kia_ibu_fk` FOREIGN KEY (`ibu_id`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `klasifikasi_surat`
--
ALTER TABLE `klasifikasi_surat`
  ADD CONSTRAINT `klasifikasi_surat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `komentar`
--
ALTER TABLE `komentar`
  ADD CONSTRAINT `komentar_artikel_fk` FOREIGN KEY (`id_artikel`) REFERENCES `artikel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `komentar_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kontak`
--
ALTER TABLE `kontak`
  ADD CONSTRAINT `kontak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kontak_grup`
--
ALTER TABLE `kontak_grup`
  ADD CONSTRAINT `kontak_grup_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `laporan_sinkronisasi`
--
ALTER TABLE `laporan_sinkronisasi`
  ADD CONSTRAINT `laporan_sinkronisasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `line`
--
ALTER TABLE `line`
  ADD CONSTRAINT `line_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD CONSTRAINT `login_attempts_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_backup`
--
ALTER TABLE `log_backup`
  ADD CONSTRAINT `log_backup_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_hapus_penduduk`
--
ALTER TABLE `log_hapus_penduduk`
  ADD CONSTRAINT `log_hapus_penduduk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_hapus_penduduk_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_keluarga`
--
ALTER TABLE `log_keluarga`
  ADD CONSTRAINT `log_keluarga_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_keluarga_kk_fk` FOREIGN KEY (`id_kk`) REFERENCES `tweb_keluarga` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_keluarga_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_penduduk_fk` FOREIGN KEY (`id_log_penduduk`) REFERENCES `log_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_login`
--
ALTER TABLE `log_login`
  ADD CONSTRAINT `log_login_config_id_foreign` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_notifikasi_admin`
--
ALTER TABLE `log_notifikasi_admin`
  ADD CONSTRAINT `log_notifikasi_admin_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_notifikasi_admin_user_fk` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_notifikasi_mandiri`
--
ALTER TABLE `log_notifikasi_mandiri`
  ADD CONSTRAINT `log_notifikasi_mandiri_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_notifikasi_mandiri_user_mandiri_fk` FOREIGN KEY (`id_user_mandiri`) REFERENCES `tweb_penduduk_mandiri` (`id_pend`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  ADD CONSTRAINT `fk_tweb_penduduk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_ref_pindah` FOREIGN KEY (`ref_pindah`) REFERENCES `ref_pindah` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_penduduk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_perubahan_penduduk`
--
ALTER TABLE `log_perubahan_penduduk`
  ADD CONSTRAINT `log_perubahan_penduduk_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_perubahan_penduduk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_perubahan_penduduk_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_restore_desa`
--
ALTER TABLE `log_restore_desa`
  ADD CONSTRAINT `log_restore_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_sinkronisasi`
--
ALTER TABLE `log_sinkronisasi`
  ADD CONSTRAINT `log_sinkronisasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_surat`
--
ALTER TABLE `log_surat`
  ADD CONSTRAINT `log_surat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_format_surat_fk` FOREIGN KEY (`id_format_surat`) REFERENCES `tweb_surat_format` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_pamong_urls_fk` FOREIGN KEY (`urls_id`) REFERENCES `urls` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_user_fk` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_surat_dinas`
--
ALTER TABLE `log_surat_dinas`
  ADD CONSTRAINT `log_surat_dinas_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_dinas_created_by_fk` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_dinas_format_fk` FOREIGN KEY (`id_format_surat`) REFERENCES `surat_dinas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_dinas_updated_by_fk` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_surat_dinas_user_fk` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_tolak`
--
ALTER TABLE `log_tolak`
  ADD CONSTRAINT `log_tolak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_tolak_surat_dinas_fk` FOREIGN KEY (`id_surat_dinas`) REFERENCES `log_surat_dinas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `log_tolak_surat_fk` FOREIGN KEY (`id_surat`) REFERENCES `log_surat` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_tte`
--
ALTER TABLE `log_tte`
  ADD CONSTRAINT `log_tte_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `lokasi`
--
ALTER TABLE `lokasi`
  ADD CONSTRAINT `lokasi_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `lokasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `lokasi_point_fk` FOREIGN KEY (`ref_point`) REFERENCES `point` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `media_sosial`
--
ALTER TABLE `media_sosial`
  ADD CONSTRAINT `media_sosial_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `menu`
--
ALTER TABLE `menu`
  ADD CONSTRAINT `menu_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_cdesa`
--
ALTER TABLE `mutasi_cdesa`
  ADD CONSTRAINT `cdesa_mutasi_fk` FOREIGN KEY (`id_cdesa_masuk`) REFERENCES `cdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mutasi_cdesa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mutasi_cdesa_peta_fk` FOREIGN KEY (`id_peta`) REFERENCES `lokasi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  ADD CONSTRAINT `FK_mutasi_inventaris_asset` FOREIGN KEY (`id_inventaris_asset`) REFERENCES `inventaris_asset` (`id`),
  ADD CONSTRAINT `mutasi_inventaris_asset_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  ADD CONSTRAINT `FK_mutasi_inventaris_gedung` FOREIGN KEY (`id_inventaris_gedung`) REFERENCES `inventaris_gedung` (`id`),
  ADD CONSTRAINT `mutasi_inventaris_gedung_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  ADD CONSTRAINT `FK_mutasi_inventaris_jalan` FOREIGN KEY (`id_inventaris_jalan`) REFERENCES `inventaris_jalan` (`id`),
  ADD CONSTRAINT `mutasi_inventaris_jalan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_peralatan`
--
ALTER TABLE `mutasi_inventaris_peralatan`
  ADD CONSTRAINT `FK_mutasi_inventaris_peralatan` FOREIGN KEY (`id_inventaris_peralatan`) REFERENCES `inventaris_peralatan` (`id`),
  ADD CONSTRAINT `mutasi_inventaris_peralatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  ADD CONSTRAINT `mutasi_inventaris_tanah_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mutasi_inventaris_tanah_inventaris_tanah_fk` FOREIGN KEY (`id_inventaris_tanah`) REFERENCES `inventaris_tanah` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `notifikasi`
--
ALTER TABLE `notifikasi`
  ADD CONSTRAINT `notifikasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `outbox`
--
ALTER TABLE `outbox`
  ADD CONSTRAINT `outbox_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pelapak`
--
ALTER TABLE `pelapak`
  ADD CONSTRAINT `pelapak_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pelapak_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pembangunan`
--
ALTER TABLE `pembangunan`
  ADD CONSTRAINT `pembangunan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pembangunan_lokasi_cluster_fk` FOREIGN KEY (`id_lokasi`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pembangunan_ref_dokumentasi`
--
ALTER TABLE `pembangunan_ref_dokumentasi`
  ADD CONSTRAINT `pembangunan_ref_dokumentasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pembangunan_ref_dokumentasi_pembangunan_fk` FOREIGN KEY (`id_pembangunan`) REFERENCES `pembangunan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pemilihan`
--
ALTER TABLE `pemilihan`
  ADD CONSTRAINT `pemilihan_config_id_foreign` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pendapat`
--
ALTER TABLE `pendapat`
  ADD CONSTRAINT `pendapat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pengaduan`
--
ALTER TABLE `pengaduan`
  ADD CONSTRAINT `pengaduan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `permohonan_surat`
--
ALTER TABLE `permohonan_surat`
  ADD CONSTRAINT `permohonan_surat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `permohonan_surat_pemohon_fk` FOREIGN KEY (`id_pemohon`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `permohonan_surat_surat_fk` FOREIGN KEY (`id_surat`) REFERENCES `tweb_surat_format` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `persil`
--
ALTER TABLE `persil`
  ADD CONSTRAINT `persil_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `persil_peta_fk` FOREIGN KEY (`id_peta`) REFERENCES `lokasi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `persil_wilayah_fk` FOREIGN KEY (`id_wilayah`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pesan`
--
ALTER TABLE `pesan`
  ADD CONSTRAINT `pesan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pesan_detail`
--
ALTER TABLE `pesan_detail`
  ADD CONSTRAINT `pesan_detail_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pesan_detail_pesan_fk` FOREIGN KEY (`pesan_id`) REFERENCES `pesan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `pesan_mandiri`
--
ALTER TABLE `pesan_mandiri`
  ADD CONSTRAINT `pesan_mandiri_config_id_foreign` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pesan_mandiri_penduduk_id_foreign` FOREIGN KEY (`penduduk_id`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `point`
--
ALTER TABLE `point`
  ADD CONSTRAINT `point_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `polygon`
--
ALTER TABLE `polygon`
  ADD CONSTRAINT `polygon_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `posyandu`
--
ALTER TABLE `posyandu`
  ADD CONSTRAINT `posyandu_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `produk`
--
ALTER TABLE `produk`
  ADD CONSTRAINT `lapak_fk` FOREIGN KEY (`id_pelapak`) REFERENCES `pelapak` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `produk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `produk_kategori_fk` FOREIGN KEY (`id_produk_kategori`) REFERENCES `produk_kategori` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `produk_kategori`
--
ALTER TABLE `produk_kategori`
  ADD CONSTRAINT `produk_kategori_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `program`
--
ALTER TABLE `program`
  ADD CONSTRAINT `program_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `program_peserta`
--
ALTER TABLE `program_peserta`
  ADD CONSTRAINT `program_peserta_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `program_peserta_kartu_fk` FOREIGN KEY (`kartu_id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `program_peserta_program_fk` FOREIGN KEY (`program_id`) REFERENCES `program` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ref_jabatan`
--
ALTER TABLE `ref_jabatan`
  ADD CONSTRAINT `ref_jabatan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ref_syarat_surat`
--
ALTER TABLE `ref_syarat_surat`
  ADD CONSTRAINT `ref_syarat_surat_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sasaran_paud`
--
ALTER TABLE `sasaran_paud`
  ADD CONSTRAINT `sasaran_paud_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `sasaran_paud_kia_fk` FOREIGN KEY (`kia_id`) REFERENCES `kia` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `sasaran_paud_posyandu_fk` FOREIGN KEY (`posyandu_id`) REFERENCES `posyandu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sentitems`
--
ALTER TABLE `sentitems`
  ADD CONSTRAINT `sentitems_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `setting_aplikasi`
--
ALTER TABLE `setting_aplikasi`
  ADD CONSTRAINT `setting_aplikasi_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `setting_modul`
--
ALTER TABLE `setting_modul`
  ADD CONSTRAINT `setting_modul_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `shortcut`
--
ALTER TABLE `shortcut`
  ADD CONSTRAINT `shortcut_config_id_foreign` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `statistics`
--
ALTER TABLE `statistics`
  ADD CONSTRAINT `statistics_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `suplemen`
--
ALTER TABLE `suplemen`
  ADD CONSTRAINT `suplemen_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  ADD CONSTRAINT `suplemen_terdata_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `suplemen_terdata_suplemen_1` FOREIGN KEY (`id_suplemen`) REFERENCES `suplemen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `suplemen_terdata_suplemen_fk` FOREIGN KEY (`id_suplemen`) REFERENCES `suplemen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `surat_dinas`
--
ALTER TABLE `surat_dinas`
  ADD CONSTRAINT `surat_dinas_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `surat_keluar`
--
ALTER TABLE `surat_keluar`
  ADD CONSTRAINT `surat_keluar_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `surat_masuk`
--
ALTER TABLE `surat_masuk`
  ADD CONSTRAINT `surat_masuk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sys_traffic`
--
ALTER TABLE `sys_traffic`
  ADD CONSTRAINT `sys_traffic_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tanah_desa`
--
ALTER TABLE `tanah_desa`
  ADD CONSTRAINT `tanah_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tanah_desa_penduduk_fk` FOREIGN KEY (`id_penduduk`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tanah_kas_desa`
--
ALTER TABLE `tanah_kas_desa`
  ADD CONSTRAINT `tanah_kas_desa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `teks_berjalan`
--
ALTER TABLE `teks_berjalan`
  ADD CONSTRAINT `teks_berjalan_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `theme`
--
ALTER TABLE `theme`
  ADD CONSTRAINT `theme_config_id_foreign` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_desa_pamong`
--
ALTER TABLE `tweb_desa_pamong`
  ADD CONSTRAINT `tweb_desa_pamong_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_desa_pamong_jabatan_fk` FOREIGN KEY (`jabatan_id`) REFERENCES `ref_jabatan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_desa_pamong_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_keluarga`
--
ALTER TABLE `tweb_keluarga`
  ADD CONSTRAINT `tweb_keluarga_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_keluarga_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_keluarga_kepala_fk` FOREIGN KEY (`nik_kepala`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_penduduk`
--
ALTER TABLE `tweb_penduduk`
  ADD CONSTRAINT `tweb_penduduk_cluster_fk` FOREIGN KEY (`id_cluster`) REFERENCES `tweb_wil_clusterdesa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_penduduk_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_penduduk_kk_fk` FOREIGN KEY (`id_kk`) REFERENCES `tweb_keluarga` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_penduduk_mandiri`
--
ALTER TABLE `tweb_penduduk_mandiri`
  ADD CONSTRAINT `tweb_penduduk_mandiri_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_penduduk_mandiri_penduduk_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_penduduk_map`
--
ALTER TABLE `tweb_penduduk_map`
  ADD CONSTRAINT `tweb_penduduk_map_pend_fk` FOREIGN KEY (`id`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_penduduk_umur`
--
ALTER TABLE `tweb_penduduk_umur`
  ADD CONSTRAINT `tweb_penduduk_umur_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_rtm`
--
ALTER TABLE `tweb_rtm`
  ADD CONSTRAINT `tweb_rtm_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_rtm_kepala_fk` FOREIGN KEY (`nik_kepala`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_surat_format`
--
ALTER TABLE `tweb_surat_format`
  ADD CONSTRAINT `tweb_surat_format_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tweb_wil_clusterdesa`
--
ALTER TABLE `tweb_wil_clusterdesa`
  ADD CONSTRAINT `tweb_wil_clusterdesa_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tweb_wil_clusterdesa_kepala_fk` FOREIGN KEY (`id_kepala`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `urls`
--
ALTER TABLE `urls`
  ADD CONSTRAINT `urls_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `user_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_grup_fk` FOREIGN KEY (`id_grup`) REFERENCES `user_grup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_pamong_fk` FOREIGN KEY (`pamong_id`) REFERENCES `tweb_desa_pamong` (`pamong_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_grup`
--
ALTER TABLE `user_grup`
  ADD CONSTRAINT `user_grup_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `widget`
--
ALTER TABLE `widget`
  ADD CONSTRAINT `widget_config_fk` FOREIGN KEY (`config_id`) REFERENCES `config` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

