-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 24 Jun 2024 pada 18.49
-- Versi server: 10.6.18-MariaDB-cll-lve
-- Versi PHP: 8.1.28

START TRANSACTION;



--
-- Database: `mbek1154_simon`
--

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

--
-- Struktur dari tabel `keys`
--

CREATE TABLE `keys` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `key` varchar(40) NOT NULL,
  `level` int(2) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT 0,
  `is_private_key` tinyint(1) NOT NULL DEFAULT 0,
  `ip_addresses` text DEFAULT NULL,
  `date_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data untuk tabel `keys`
--

INSERT INTO `keys` (`id`, `user_id`, `key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
(1, 1, 'wpu123', 1, 0, 0, NULL, 1),
(2, 3, 'rahasia', 1, 0, 0, NULL, 1);

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

--
-- Struktur dari tabel `limits`
--

CREATE TABLE `limits` (
  `id` int(11) NOT NULL,
  `uri` varchar(255) NOT NULL,
  `count` int(10) NOT NULL,
  `hour_started` int(11) NOT NULL,
  `api_key` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data untuk tabel `limits`
--

INSERT INTO `limits` (`id`, `uri`, `count`, `hour_started`, `api_key`) VALUES
(1, 'uri:mahasiswa/index:get', 4, 1661652477, 'wpu123'),
(2, 'uri:mahasiswa/index:get', 7, 1661648125, 'rahasia');

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

--
-- Struktur dari tabel `ref_desa`
--

CREATE TABLE `ref_desa` (
  `Kd_Kec` varchar(30) NOT NULL,
  `Kd_Desa` varchar(30) NOT NULL,
  `Nama_Desa` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `ref_desa`
--

INSERT INTO `ref_desa` (`Kd_Kec`, `Kd_Desa`, `Nama_Desa`) VALUES
('01', '01.2001', 'PEMERINTAH DESA BANGKLEYAN'),
('01', '01.2002', 'PEMERINTAH DESA GEMPOL'),
('01', '01.2003', 'PEMERINTAH DESA KEPOH'),
('01', '01.2004', 'PEMERINTAH DESA PELEM'),
('01', '01.2005', 'PEMERINTAH DESA JEGONG'),
('01', '01.2006', 'PEMERINTAH DESA JATI'),
('01', '01.2007', 'PEMERINTAH DESA SINGGET'),
('01', '01.2008', 'PEMERINTAH DESA GABUSAN'),
('01', '01.2009', 'PEMERINTAH DESA DOPLANG'),
('01', '01.2010', 'PEMERINTAH DESA RANDULAWANG'),
('01', '01.2011', 'PEMERINTAH DESA TOBO'),
('01', '01.2012', 'PEMERINTAH DESA PENGKOL JAGONG'),
('02', '02.2001', 'PEMERINTAH DESA TLOGOTUWUNG'),
('02', '02.2002', 'PEMERINTAH DESA BODEH'),
('02', '02.2003', 'PEMERINTAH DESA GEMBYUNGAN'),
('02', '02.2004', 'PEMERINTAH DESA SAMBONGWANGAN'),
('02', '02.2006', 'PEMERINTAH DESA PILANG'),
('02', '02.2007', 'PEMERINTAH DESA TEMULUS'),
('02', '02.2008', 'PEMERINTAH DESA SUMBEREJO'),
('02', '02.2009', 'PEMERINTAH DESA KUTUKAN'),
('02', '02.2010', 'PEMERINTAH DESA KEDIREN'),
('02', '02.2012', 'PEMERINTAH DESA KADENGAN'),
('02', '02.2013', 'PEMERINTAH DESA BEKUTUK'),
('02', '02.2014', 'PEMERINTAH DESA PLOSOREJO'),
('02', '02.2015', 'PEMERINTAH DESA JERUK'),
('02', '02.2016', 'PEMERINTAH DESA TANGGEL'),
('02', '02.2017', 'PEMERINTAH DESA KALISARI'),
('02', '02.2018', 'PEMERINTAH DESA NGLIRON'),
('03', '03.2001', 'PEMERINTAH DESA MEGERI'),
('03', '03.2002', 'PEMERINTAH DESA NGLEBAK'),
('03', '03.2003', 'PEMERINTAH DESA GETAS'),
('03', '03.2004', 'PEMERINTAH DESA NGINGGIL'),
('03', '03.2005', 'PEMERINTAH DESA NGRAWOH'),
('03', '03.2006', 'PEMERINTAH DESA MENDENREJO'),
('03', '03.2007', 'PEMERINTAH DESA SUMBER'),
('03', '03.2008', 'PEMERINTAH DESA MOJOREMBUN'),
('03', '03.2009', 'PEMERINTAH DESA NGLUNGGER'),
('03', '03.2010', 'PEMERINTAH DESA MEDALEM'),
('04', '04.2001', 'PEMERINTAH DESA GONDEL'),
('04', '04.2002', 'PEMERINTAH DESA KETUWAN'),
('04', '04.2003', 'PEMERINTAH DESA JIMBUNG'),
('04', '04.2004', 'PEMERINTAH DESA PANOLAN'),
('04', '04.2005', 'PEMERINTAH DESA KLAGEN'),
('04', '04.2006', 'PEMERINTAH DESA KEMANTREN'),
('04', '04.2007', 'PEMERINTAH DESA SIDOREJO'),
('04', '04.2008', 'PEMERINTAH DESA WADO'),
('04', '04.2009', 'PEMERINTAH DESA PULO'),
('04', '04.2010', 'PEMERINTAH DESA TANJUNG'),
('04', '04.2011', 'PEMERINTAH DESA SOGO'),
('04', '04.2012', 'PEMERINTAH DESA BAJO'),
('04', '04.2013', 'PEMERINTAH DESA NGLANDEYAN'),
('04', '04.2014', 'PEMERINTAH DESA KALEN'),
('04', '04.2015', 'PEMERINTAH DESA NGRAHO'),
('04', '04.2016', 'PEMERINTAH DESA KEDUNGTUBAN'),
('04', '04.2017', 'PEMERINTAH DESA GALUK'),
('05', '05.2001', 'PEMERINTAH DESA GADON'),
('05', '05.2002', 'PEMERINTAH DESA NGLORAM'),
('05', '05.2003', 'PEMERINTAH DESA CABEAN'),
('05', '05.2004', 'PEMERINTAH DESA KAPUAN'),
('05', '05.2005', 'PEMERINTAH DESA JIPANG'),
('05', '05.2006', 'PEMERINTAH DESA GETAS'),
('05', '05.2007', 'PEMERINTAH DESA SUMBERPITU'),
('05', '05.2008', 'PEMERINTAH DESA KENTONG'),
('05', '05.2009', 'PEMERINTAH DESA MERNUNG'),
('05', '05.2010', 'PEMERINTAH DESA MULYOREJO'),
('05', '05.2012', 'PEMERINTAH DESA NGLANJUK'),
('06', '06.2001', 'PEMERINTAH DESA TEMENGENG'),
('06', '06.2002', 'PEMERINTAH DESA SAMBONGREJO'),
('06', '06.2003', 'PEMERINTAH DESA GADU'),
('06', '06.2004', 'PEMERINTAH DESA SAMBONG'),
('06', '06.2005', 'PEMERINTAH DESA POJOKWATU'),
('06', '06.2006', 'PEMERINTAH DESA GAGAKAN'),
('06', '06.2007', 'PEMERINTAH DESA BITING'),
('06', '06.2008', 'PEMERINTAH DESA BRABOWAN'),
('06', '06.2009', 'PEMERINTAH DESA LEDOK'),
('06', '06.2010', 'PEMERINTAH DESA GIYANTI'),
('07', '07.2001', 'PEMERINTAH DESA NGLOBO'),
('07', '07.2002', 'PEMERINTAH DESA CABAK'),
('07', '07.2003', 'PEMERINTAH DESA NGLEBUR'),
('07', '07.2004', 'PEMERINTAH DESA JANJANG'),
('07', '07.2005', 'PEMERINTAH DESA BLEBOH'),
('07', '07.2006', 'PEMERINTAH DESA KETRINGAN'),
('07', '07.2007', 'PEMERINTAH DESA SINGONEGORO'),
('07', '07.2008', 'PEMERINTAH DESA JIKEN'),
('07', '07.2009', 'PEMERINTAH DESA GENJAHAN'),
('07', '07.2010', 'PEMERINTAH DESA JIWOREJO'),
('07', '07.2011', 'PEMERINTAH DESA BANGKLEYAN'),
('07', '07.2012', 'PEMERINTAH DESA  BANGOWAN'),
('08', '08.2001', 'PEMERINTAH DESA BLUNGUN'),
('08', '08.2002', 'PEMERINTAH DESA SEMANGGI'),
('08', '08.2003', 'PEMERINTAH DESA NGAMPON'),
('08', '08.2004', 'PEMERINTAH DESA JOMBLANG'),
('08', '08.2005', 'PEMERINTAH DESA PALON'),
('08', '08.2006', 'PEMERINTAH DESA BANGSRI'),
('08', '08.2007', 'PEMERINTAH DESA SUMURBOTO'),
('08', '08.2008', 'PEMERINTAH DESA BRUMBUNG'),
('08', '08.2009', 'PEMERINTAH DESA TURIREJO'),
('08', '08.2010', 'PEMERINTAH DESA SEMAMPIR'),
('08', '08.2011', 'PEMERINTAH DESA KEMIRI'),
('08', '08.2012', 'PEMERINTAH DESA TEMPELLEMAHBANG'),
('08', '08.2014', 'PEMERINTAH DESA SESO'),
('08', '08.2015', 'PEMERINTAH DESA BALONG'),
('08', '08.2016', 'PEMERINTAH DESA GENENG'),
('08', '08.2017', 'PEMERINTAH DESA NGLAROHGUNUNG'),
('08', '08.2018', 'PEMERINTAH DESA KAWENGA'),
('08', '08.2019', 'PEMERINTAH DESA GERSI'),
('08', '08.2020', 'PEMERINTAH DESA GEDANGDOWO'),
('08', '08.2021', 'PEMERINTAH DESA PULEDAGEL'),
('08', '08.2022', 'PEMERINTAH DESA BACEM'),
('08', '08.2023', 'PEMERINTAH DESA JATIREJO'),
('08', '08.2024', 'PEMERINTAH DESA SOKO'),
('08', '08.2025', 'PEMERINTAH DESA WARU'),
('09', '09.2001', 'PEMERINTAH DESA JEPANGREJO'),
('09', '09.2002', 'PEMERINTAH DESA KAMOLAN'),
('09', '09.2003', 'PEMERINTAH DESA PELEM'),
('09', '09.2004', 'PEMERINTAH DESA PURWOREJO'),
('09', '09.2005', 'PEMERINTAH DESA ANDONGREJO'),
('09', '09.2007', 'PEMERINTAH DESA JEJERUK'),
('09', '09.2019', 'PEMERINTAH DESA TEMUREJO'),
('09', '09.2020', 'PEMERINTAH DESA TEMPUREJO'),
('09', '09.2021', 'PEMERINTAH DESA PATALAN'),
('09', '09.2022', 'PEMERINTAH DESA TAMBAKSARI'),
('09', '09.2023', 'PEMERINTAH DESA PURWOSARI'),
('09', '09.2024', 'PEMERINTAH DESA NGADIPURWO'),
('09', '09.2025', 'PEMERINTAH DESA SENDANGHARJO'),
('09', '09.2026', 'PEMERINTAH DESA TEMPURAN'),
('09', '09.2027', 'PEMERINTAH DESA PLANTUNGAN'),
('09', '09.2028', 'PEMERINTAH DESA NGAMPEL'),
('10', '10.2001', 'PEMERINTAH DESA TAWANGREJO'),
('10', '10.2002', 'PEMERINTAH DESA KEDUNGRINGIN'),
('10', '10.2003', 'PEMERINTAH DESA ADIREJO'),
('10', '10.2004', 'PEMERINTAH DESA TAMANREJO'),
('10', '10.2005', 'PEMERINTAH DESA TUTUP'),
('10', '10.2006', 'PEMERINTAH DESA SUKOREJO'),
('10', '10.2007', 'PEMERINTAH DESA TAMBAHREJO'),
('10', '10.2008', 'PEMERINTAH DESA KALANGAN'),
('10', '10.2009', 'PEMERINTAH DESA SAMBONGREJO'),
('10', '10.2010', 'PEMERINTAH DESA TUNJUNGAN'),
('10', '10.2011', 'PEMERINTAH DESA KEDUNGREJO'),
('10', '10.2012', 'PEMERINTAH DESA GEMPOLREJO'),
('10', '10.2013', 'PEMERINTAH DESA NGLANGITAN'),
('10', '10.2014', 'PEMERINTAH DESA KESER'),
('10', '10.2015', 'PEMERINTAH DESA SITIREJO'),
('11', '11.2001', 'PEMERINTAH DESA JATISARI'),
('11', '11.2002', 'PEMERINTAH DESA JATIKLAMPOK'),
('11', '11.2003', 'PEMERINTAH DESA KLOPODUWUR'),
('11', '11.2004', 'PEMERINTAH DESA SIDOMULYO'),
('11', '11.2005', 'PEMERINTAH DESA BALONGSARI'),
('11', '11.2006', 'PEMERINTAH DESA BACEM'),
('11', '11.2007', 'PEMERINTAH DESA WONOSEMI'),
('11', '11.2008', 'PEMERINTAH DESA SENDANGGAYAM'),
('11', '11.2009', 'PEMERINTAH DESA BANJAREJO'),
('11', '11.2010', 'PEMERINTAH DESA MOJOWETAN'),
('11', '11.2011', 'PEMERINTAH DESA SUMBERAGUNG'),
('11', '11.2012', 'PEMERINTAH DESA GEDONGSARI'),
('11', '11.2013', 'PEMERINTAH DESA SENDANGWUNGU'),
('11', '11.2014', 'PEMERINTAH DESA BALONGREJO'),
('11', '11.2015', 'PEMERINTAH DESA KARANGTALUN'),
('11', '11.2016', 'PEMERINTAH DESA KEBONREJO'),
('11', '11.2017', 'PEMERINTAH DESA KEMBANG'),
('11', '11.2018', 'PEMERINTAH DESA SEMBONGIN'),
('11', '11.2019', 'PEMERINTAH DESA PLOSOREJO'),
('11', '11.2020', 'PEMERINTAH DESA BULUROTO'),
('12', '12.2001', 'PEMERINTAH DESA ROWOBUNGKUL'),
('12', '12.2002', 'PEMERINTAH DESA GEDEBEG'),
('12', '12.2003', 'PEMERINTAH DESA SAMBONGANYAR'),
('12', '12.2004', 'PEMERINTAH DESA KENDAYAAN'),
('12', '12.2005', 'PEMERINTAH DESA PLUMBON'),
('12', '12.2006', 'PEMERINTAH DESA BERGOLO'),
('12', '12.2007', 'PEMERINTAH DESA BANDUNGROJO'),
('12', '12.2008', 'PEMERINTAH DESA KEDUNGSATRIYAN'),
('12', '12.2009', 'PEMERINTAH DESA KARANGTENGAH'),
('12', '12.2010', 'PEMERINTAH DESA JETAKWANGER'),
('12', '12.2011', 'PEMERINTAH DESA SUMBEREJO'),
('12', '12.2012', 'PEMERINTAH DESA SENDANGAGUNG'),
('12', '12.2013', 'PEMERINTAH DESA TALOKWOHMOJO'),
('12', '12.2014', 'PEMERINTAH DESA TREMBULREJO'),
('12', '12.2016', 'PEMERINTAH DESA GONDANG'),
('12', '12.2017', 'PEMERINTAH DESA SENDANGREJO'),
('12', '12.2019', 'PEMERINTAH DESA SEMAWUR'),
('12', '12.2020', 'PEMERINTAH DESA BRADAG'),
('12', '12.2021', 'PEMERINTAH DESA GOTPUTUK'),
('12', '12.2022', 'PEMERINTAH DESA BERBAK'),
('12', '12.2023', 'PEMERINTAH DESA SARIMULYO'),
('12', '12.2024', 'PEMERINTAH DESA SENDANGMULYO'),
('12', '12.2025', 'PEMERINTAH DESA WANTILGUNG'),
('12', '12.2026', 'PEMERINTAH DESA BOGOWANTI'),
('12', '12.2027', 'PEMERINTAH DESA SAMBONGREJO'),
('12', '12.2028', 'PEMERINTAH DESA SRIGADING'),
('12', '12.2029', 'PEMERINTAH DESA KARANGJONG'),
('13', '13.2001', 'PEMERINTAH DESA BOTORECO'),
('13', '13.2002', 'PEMERINTAH DESA BULOH'),
('13', '13.2003', 'PEMERINTAH DESA KEMIRI'),
('13', '13.2004', 'PEMERINTAH DESA KODOKAN'),
('13', '13.2005', 'PEMERINTAH DESA SONOKIDUL'),
('13', '13.2006', 'PEMERINTAH DESA SEMPU'),
('13', '13.2007', 'PEMERINTAH DESA CUNGKUP'),
('13', '13.2008', 'PEMERINTAH DESA PLOSOREJO'),
('13', '13.2009', 'PEMERINTAH DESA NGILEN'),
('13', '13.2010', 'PEMERINTAH DESA BAKAH'),
('13', '13.2011', 'PEMERINTAH DESA KALANGREJO'),
('13', '13.2012', 'PEMERINTAH DESA BLUMBANGREJO'),
('13', '13.2013', 'PEMERINTAH DESA TAWANGREJO'),
('13', '13.2014', 'PEMERINTAH DESA KLOKAH'),
('13', '13.2015', 'PEMERINTAH DESA MURAHARJO'),
('13', '13.2016', 'PEMERINTAH DESA JAGONG'),
('13', '13.2018', 'PEMERINTAH DESA GAGAAN'),
('13', '13.2019', 'PEMERINTAH DESA SAMBIROTO'),
('13', '13.2020', 'PEMERINTAH DESA BEJIREJO'),
('13', '13.2021', 'PEMERINTAH DESA JETAK'),
('13', '13.2022', 'PEMERINTAH DESA KARANGGENENG'),
('13', '13.2023', 'PEMERINTAH DESA BALONG'),
('13', '13.2024', 'PEMERINTAH DESA NGAWENOMBO'),
('13', '13.2025', 'PEMERINTAH DESA SENDANGWATES'),
('13', '13.2026', 'PEMERINTAH DESA KEDUNGWARU'),
('14', '14.2001', 'PEMERINTAH DESA TINAPAN'),
('14', '14.2002', 'PEMERINTAH DESA SAMBENG'),
('14', '14.2003', 'PEMERINTAH DESA PRIGI'),
('14', '14.2004', 'PEMERINTAH DESA PELEMSENGIR'),
('14', '14.2005', 'PEMERINTAH DESA KACANGAN'),
('14', '14.2006', 'PEMERINTAH DESA SONOKULON'),
('14', '14.2007', 'PEMERINTAH DESA KEDUNGWUNGU'),
('14', '14.2008', 'PEMERINTAH DESA GUNUNGAN'),
('14', '14.2009', 'PEMERINTAH DESA KAJENGAN'),
('14', '14.2010', 'PEMERINTAH DESA DRINGO'),
('14', '14.2011', 'PEMERINTAH DESA COKROWATI'),
('14', '14.2012', 'PEMERINTAH DESA KETILENG'),
('14', '14.2013', 'PEMERINTAH DESA TODANAN'),
('14', '14.2014', 'PEMERINTAH DESA NGUMBUL'),
('14', '14.2015', 'PEMERINTAH DESA WUKIRSARI'),
('14', '14.2016', 'PEMERINTAH DESA BICAK'),
('14', '14.2017', 'PEMERINTAH DESA SENDANG'),
('14', '14.2018', 'PEMERINTAH DESA KARANGANYAR'),
('14', '14.2019', 'PEMERINTAH DESA DALANGAN'),
('14', '14.2020', 'PEMERINTAH DESA CANDI'),
('14', '14.2021', 'PEMERINTAH DESA NDORIYO'),
('14', '14.2022', 'PEMERINTAH DESA KEMBANG'),
('14', '14.2023', 'PEMERINTAH DESA BEDINGIN'),
('14', '14.2024', 'PEMERINTAH DESA LEDOK'),
('14', '14.2025', 'PEMERINTAH DESA KEDUNGBACI'),
('15', '15.2001', 'PEMERINTAH DESA BOGOREJO'),
('15', '15.2002', 'PEMERINTAH DESA SARIREJO'),
('15', '15.2003', 'PEMERINTAH DESA KARANGANYAR'),
('15', '15.2004', 'PEMERINTAH DESA KARANG'),
('15', '15.2005', 'PEMERINTAH DESA PRANTAAN'),
('15', '15.2006', 'PEMERINTAH DESA JERUK'),
('15', '15.2007', 'PEMERINTAH DESA GOMBANG'),
('15', '15.2008', 'PEMERINTAH DESA GEMBOL'),
('15', '15.2009', 'PEMERINTAH DESA TEMPUREJO'),
('15', '15.2010', 'PEMERINTAH DESA GAYAM'),
('15', '15.2011', 'PEMERINTAH DESA SENDANGREJO'),
('15', '15.2012', 'PEMERINTAH DESA GANDU'),
('15', '15.2013', 'PEMERINTAH DESA NGLENGKIR'),
('15', '15.2014', 'PEMERINTAH DESA JURANGJERO'),
('16', '16.2001', 'PEMERINTAH DESA HARJOWINANGUN'),
('16', '16.2002', 'PEMERINTAH DESA TENGGER'),
('16', '16.2003', 'PEMERINTAH DESA KROCOK'),
('16', '16.2004', 'PEMERINTAH DESA NGAPUS'),
('16', '16.2005', 'PEMERINTAH DESA DOLOGAN'),
('16', '16.2006', 'PEMERINTAH DESA TLOGOWUNGU'),
('16', '16.2007', 'PEMERINTAH DESA JAPAH'),
('16', '16.2008', 'PEMERINTAH DESA BEGANJING'),
('16', '16.2009', 'PEMERINTAH DESA NGRAMBITAN'),
('16', '16.2010', 'PEMERINTAH DESA PENGKOLREJO'),
('16', '16.2011', 'PEMERINTAH DESA BOGOREJO'),
('16', '16.2012', 'PEMERINTAH DESA WOTBAKAH'),
('16', '16.2013', 'PEMERINTAH DESA PADAAN'),
('16', '16.2014', 'PEMERINTAH DESA BOGEM'),
('16', '16.2015', 'PEMERINTAH DESA SUMBEREJO'),
('16', '16.2016', 'PEMERINTAH DESA NGIYONO'),
('16', '16.2017', 'PEMERINTAH DESA GAPLOKAN'),
('16', '16.2018', 'PEMERINTAH DESA KALINANAS');

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

--
-- Struktur dari tabel `ref_kecamatan`
--

CREATE TABLE `ref_kecamatan` (
  `Kd_Kec` varchar(20) NOT NULL,
  `Nama_Kecamatan` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `ref_kecamatan`
--

INSERT INTO `ref_kecamatan` (`Kd_Kec`, `Nama_Kecamatan`) VALUES
('01', 'KECAMATAN JATI'),
('02', 'KECAMATAN RANDUBLATUNG'),
('03', 'KECAMATAN KRADENAN'),
('04', 'KECAMATAN KEDUNGTUBAN'),
('05', 'KECAMATAN CEPU'),
('06', 'KECAMATAN SAMBONG'),
('07', 'KECAMATAN JIKEN'),
('08', 'KECAMATAN JEPON'),
('09', 'KECAMATAN BLORA'),
('10', 'KECAMATAN TUNJUNGAN'),
('11', 'KECAMATAN BANJAREJO'),
('12', 'KECAMATAN NGAWEN'),
('13', 'KECAMATAN KUNDURAN'),
('14', 'KECAMATAN TODANAN'),
('15', 'KECAMATAN BOGOREJO'),
('16', 'KECAMATAN JAPAH');

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

--
-- Struktur dari tabel `tb_alasan_penolakan`
--

CREATE TABLE `tb_alasan_penolakan` (
  `id_alasan` int(11) NOT NULL,
  `id_ormas` int(11) NOT NULL,
  `alasan` text NOT NULL,
  `is_validasi` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_alasan_penolakan`
--

INSERT INTO `tb_alasan_penolakan` (`id_alasan`, `id_ormas`, `alasan`, `is_validasi`) VALUES
(1, 11, '12', 0);

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

--
-- Struktur dari tabel `tb_bidang_ormas`
--

CREATE TABLE `tb_bidang_ormas` (
  `id_bidang` int(12) NOT NULL,
  `nama_bidang` text NOT NULL,
  `id_user` int(11) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_bidang_ormas`
--

INSERT INTO `tb_bidang_ormas` (`id_bidang`, `nama_bidang`, `id_user`, `inserted`, `deleted`) VALUES
(1, 'Sosial Kemasyarakatan', 3, '2024-04-23 03:05:54', 0),
(2, 'Pekumpulan', 3, '2024-04-24 06:16:59', 0);

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

--
-- Struktur dari tabel `tb_jabatan_kepengurusan`
--

CREATE TABLE `tb_jabatan_kepengurusan` (
  `id_jabatan` int(11) NOT NULL,
  `nama_jabatan` varchar(100) NOT NULL,
  `id_user` int(11) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_jabatan_kepengurusan`
--

INSERT INTO `tb_jabatan_kepengurusan` (`id_jabatan`, `nama_jabatan`, `id_user`, `inserted`, `deleted`) VALUES
(1, 'Bendahara', 3, '2024-04-23 03:23:29', 1),
(2, 'Bendahara', 3, '2024-04-23 03:23:42', 0),
(3, 'Sekretaris', 3, '2024-04-24 00:37:18', 0),
(4, 'Ketua', 3, '2024-04-24 00:37:28', 0);

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

--
-- Struktur dari tabel `tb_kategori_bantuan`
--

CREATE TABLE `tb_kategori_bantuan` (
  `id_kategori_bantuan` int(11) NOT NULL,
  `nama_kategori` varchar(100) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_kategori_bantuan`
--

INSERT INTO `tb_kategori_bantuan` (`id_kategori_bantuan`, `nama_kategori`, `inserted`, `deleted`) VALUES
(1, 'Hibah', '2024-05-10 07:53:13', 0),
(2, 'Fasilitas Kegiatan', '2024-05-10 07:53:40', 0);

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

--
-- Struktur dari tabel `tb_kategori_ormas`
--

CREATE TABLE `tb_kategori_ormas` (
  `id_kategori` int(12) NOT NULL,
  `nama_kategori` varchar(100) NOT NULL,
  `id_user` int(11) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_kategori_ormas`
--

INSERT INTO `tb_kategori_ormas` (`id_kategori`, `nama_kategori`, `id_user`, `inserted`, `deleted`) VALUES
(1, 'ORMAS', 3, '2024-04-23 01:28:50', 0),
(2, 'YAYASAN', 3, '2024-04-23 01:29:08', 0),
(3, 'LSM', 3, '2024-04-23 01:40:08', 0);

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

--
-- Struktur dari tabel `tb_master_agama`
--

CREATE TABLE `tb_master_agama` (
  `id_agama` int(12) NOT NULL,
  `agama` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `tb_master_agama`
--

INSERT INTO `tb_master_agama` (`id_agama`, `agama`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Katholik'),
(4, 'Hindu'),
(5, 'Buddha'),
(6, 'Konghucu');

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

--
-- Struktur dari tabel `tb_master_dukuh`
--

CREATE TABLE `tb_master_dukuh` (
  `id_dukuh` int(12) NOT NULL,
  `nama_dukuh` varchar(50) NOT NULL,
  `id_desa` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `tb_master_dukuh`
--

INSERT INTO `tb_master_dukuh` (`id_dukuh`, `nama_dukuh`, `id_desa`, `id_user`, `deleted`) VALUES
(1, 'Dukuh Sampel 2', '01.2002', 3, 0),
(2, 'DUKUH CANDI', '14.2020', 153, 0),
(3, 'DUKUH NGAMPEL', '14.2020', 153, 0),
(4, 'PECAREN', '12.2019', 310, 0),
(5, 'BORAK', '12.2019', 310, 0),
(6, 'KEDAWUNG', '12.2019', 310, 0),
(7, 'SEMAWUR', '12.2019', 310, 0),
(8, 'Sonokidul', '13.2005', 113, 1),
(9, 'Gadon', '05.2001', 262, 1),
(10, 'Gadon', '05.2001', 262, 0),
(11, 'Dukuh xyyy', '01.2002', 63, 1),
(12, 'DUKUH COKROWATI', '14.2011', 144, 0),
(13, 'DUKUH SURUHAN', '14.2011', 144, 0),
(14, 'DUKUH DOGLIG', '14.2011', 144, 0),
(15, 'BOGOWANTI', '12.2026', 317, 0),
(16, 'NGLEBUR', '07.2003', 172, 0),
(17, 'PENGKOK', '07.2003', 172, 0),
(18, 'GUWO', '07.2003', 172, 0),
(19, 'TAMBI', '07.2003', 172, 0),
(20, 'KETILENG', '14.2012', 145, 0),
(21, 'PATIHAN', '14.2012', 145, 0),
(22, 'GENDANG', '14.2012', 145, 0),
(23, 'JAMBANGAN', '14.2012', 145, 0),
(24, 'KUTUKAN', '14.2012', 145, 0),
(25, 'GONDORIYO', '14.2021', 154, 0),
(26, 'JATISEMI', '14.2021', 154, 0),
(27, 'JAMBE', '14.2021', 154, 0),
(28, 'Dusun Brumbung', '08.2008', 188, 0),
(29, 'Dusun Cangkringan', '08.2008', 188, 0),
(30, 'Dusun Ngrayung', '08.2008', 188, 0),
(31, 'Dukuh Nglego', '09.2004', 210, 0),
(32, 'Dukuh Betet', '09.2004', 210, 0),
(33, 'Dukuh Korowulung', '09.2004', 210, 0),
(34, 'Dukuh Ngampel', '09.2028', 222, 0),
(35, 'Dukuh Tambakselo', '09.2028', 222, 0),
(36, 'Dukuh Plosorjo', '09.2028', 222, 0),
(37, 'DUKUH GENDO', '08.2005', 185, 0),
(38, 'Dukuh Tempel', '08.2012', 192, 0),
(39, 'TURIREJO', '08.2009', 189, 0),
(40, 'JATIREJO', '08.2023', 204, 0),
(41, 'DUKUH NGAMPON', '08.2003', 183, 0),
(42, 'MLAHAR', '08.2009', 189, 0),
(43, 'KEDALON', '08.2023', 204, 0),
(44, 'Dukuh Tengger', '08.2012', 192, 0),
(45, 'DUKUH JLUBANG', '08.2003', 183, 0),
(46, 'KALIREJO', '08.2009', 189, 0),
(47, 'Dukuh Lemahbang', '08.2012', 192, 0),
(48, 'SAMBONGANYAR', '08.2009', 189, 0),
(49, 'Dukuh Jegong', '08.2012', 192, 0),
(50, 'Lemahbang', '11.2018', 290, 0),
(51, 'Pesantren', '11.2018', 290, 0),
(52, 'Sembongin', '11.2018', 290, 0),
(53, 'GENJAHAN', '07.2009', 178, 0),
(54, 'KLAMPOK', '07.2009', 178, 0),
(55, 'DUKUH BADONG', '11.2012', 284, 0),
(56, 'DUKUH KENDURUHAN', '11.2012', 284, 0),
(57, 'Pruntusan', '11.2016', 288, 0),
(58, 'Kebonrejo', '11.2016', 288, 0),
(59, 'Nglempung', '11.2016', 288, 0),
(60, 'Blungun', '08.2001', 181, 0),
(61, 'Botoh', '08.2001', 181, 0),
(62, 'Kalimiri', '08.2001', 181, 0),
(63, 'Sampung', '08.2001', 181, 0),
(64, 'Dukuh Kembang', '11.2017', 289, 0),
(65, 'Dukuh Boto', '11.2013', 285, 0),
(66, 'Dukuh Cerebek', '11.2017', 289, 0),
(67, 'Dukuh Genen', '11.2013', 285, 0),
(68, 'Dukuh Seren', '11.2013', 285, 0),
(69, 'KARANGTALUN', '11.2015', 287, 1),
(70, 'WIJANG', '11.2015', 287, 0),
(71, 'BANJARASEM', '11.2015', 287, 0),
(72, 'KEPOH', '09.2026', 220, 0),
(73, 'JUWET', '09.2026', 220, 0),
(74, 'KRAJAN', '09.2026', 220, 0),
(75, 'JIKEN', '07.2008', 177, 0),
(76, 'SURUHAN', '07.2008', 177, 0),
(77, 'WATULUMBUNG', '07.2008', 177, 0),
(78, 'BOLERAN', '07.2008', 177, 0),
(79, 'SEMANGGI', '08.2002', 182, 0),
(80, 'NGODO', '08.2002', 182, 0),
(81, 'BANYUASIN', '08.2002', 182, 0),
(82, 'BALONGAN', '07.2008', 177, 0),
(83, 'KALITENGAH', '07.2008', 177, 0),
(84, 'SINGONEGORO', '07.2007', 176, 0),
(85, 'KIDANG ULET', '07.2007', 176, 0),
(86, 'KEDUNGPRAHU', '07.2007', 176, 0),
(87, 'DUKUH MEDANG', '09.2025', 219, 0),
(88, 'DUKUH SENDANG', '09.2025', 219, 0),
(89, 'DUKUH POLAMAN', '09.2025', 219, 0),
(90, 'DUKUH KEDAWUNG', '09.2025', 219, 0),
(91, 'DUKUH PILANGREJO', '09.2025', 219, 0),
(92, 'NGAPUS', '07.2006', 175, 0),
(93, 'NGAGLIK', '07.2006', 175, 0),
(94, 'KETRINGAN', '07.2006', 175, 0),
(95, 'GEMPOL', '07.2006', 175, 0),
(96, 'TALUN', '07.2006', 175, 0),
(97, 'Dukuh Denguk', '09.2005', 211, 0),
(98, 'Dukuh Bakal', '09.2005', 211, 0),
(99, 'Dukuh Pakis', '09.2005', 211, 0),
(100, 'DUKUH BULAK RT 01,02,03 RW 02 KEC JIKEN KAB BLORA', '07.2004', 173, 1),
(101, 'KADENGAN', '02.2012', 83, 0),
(102, 'KEDUNGBANTENG', '02.2012', 83, 0),
(103, 'BACEK', '02.2012', 83, 0),
(104, 'NGUMBLUK', '02.2012', 83, 0),
(105, 'KEDUNGTALANG', '02.2012', 83, 0),
(106, 'TINDIK', '02.2012', 83, 0),
(107, 'TIMBUN', '02.2012', 83, 0),
(108, 'TAMAN', '02.2012', 83, 0),
(109, 'KALISARI', '02.2017', 88, 0),
(110, 'SOKO', '02.2017', 88, 0),
(111, 'MAPRING', '02.2017', 88, 0),
(112, 'KEDUNGMALING', '02.2017', 88, 0),
(113, 'DUKUH TLOGO', '02.2014', 85, 0),
(114, 'DUKUH WANGON', '02.2014', 85, 0),
(115, 'DUKUH NGRAWUT', '02.2014', 85, 0),
(116, 'DUKUH NGRAPAH', '02.2014', 85, 0),
(117, 'DUKUH BARU', '02.2014', 85, 0),
(118, 'DUKUH NGAMPEL', '02.2014', 85, 0),
(119, 'DUKUH GEDONG', '02.2014', 85, 0),
(120, 'Kajengan', '14.2009', 142, 0),
(121, 'Margolelo', '14.2009', 142, 0),
(122, 'PELEM', '01.2004', 65, 0),
(123, 'Doplang', '01.2009', 70, 0),
(124, 'BANTENGAN', '01.2006', 67, 0),
(125, 'DUKUH DRINGO', '14.2010', 143, 0),
(126, 'SERUT', '01.2004', 65, 0),
(127, 'BEBEGAN', '01.2006', 67, 0),
(128, 'Dukuhan', '01.2009', 70, 0),
(129, 'Temuireng', '01.2012', 73, 0),
(130, 'DUKUH SERUT', '14.2010', 143, 0),
(131, 'Klatak', '01.2009', 70, 0),
(132, 'KLANDING', '01.2006', 67, 0),
(133, 'Pengkol ', '01.2012', 73, 0),
(134, 'Ngasem', '01.2009', 70, 0),
(135, 'TlogoTuwung', '02.2001', 74, 0),
(136, 'Banaran', '01.2012', 73, 0),
(137, 'Glonggong', '01.2009', 70, 0),
(138, 'KARANG', '01.2006', 67, 0),
(139, 'Belikan', '01.2012', 73, 0),
(140, 'Jagong', '01.2012', 73, 0),
(141, 'Bulakgading', '01.2009', 70, 0),
(142, 'KARANG REJO', '01.2006', 67, 0),
(143, 'Bulurejo', '01.2012', 73, 0),
(144, 'Rejosari', '01.2012', 73, 0),
(145, 'Grogol', '01.2009', 70, 0),
(146, 'KAYEN', '01.2006', 67, 0),
(147, 'Trembes', '01.2009', 70, 0),
(148, 'JATI', '01.2006', 67, 0),
(149, 'Kluweh', '01.2012', 73, 0),
(150, 'Alasmalang', '01.2012', 73, 0),
(151, 'BANYU URIP', '01.2006', 67, 0),
(152, 'NGLUNGGER', '03.2009', 99, 0),
(153, 'PATALAN', '03.2009', 99, 0),
(154, 'WENI', '03.2009', 99, 0),
(155, 'BANGKLEYAN', '01.2001', 62, 0),
(156, 'PLOSOREJO', '01.2001', 62, 0),
(157, 'MUNDU', '01.2001', 62, 0),
(158, 'KEDUNGRINGIN', '01.2001', 62, 0),
(159, 'BEDEGAN', '01.2001', 62, 0),
(160, 'JERUK', '02.2015', 86, 0),
(161, 'NGROMBO', '01.2010', 71, 0),
(162, 'KALIGAWAN', '02.2015', 86, 0),
(163, 'PENTUK', '01.2001', 62, 0),
(164, 'SEMPU', '01.2010', 71, 0),
(165, 'KARANG GENENG', '01.2010', 71, 0),
(166, 'SAMBIREJO', '01.2001', 62, 0),
(167, 'GROWONG', '01.2001', 62, 0),
(168, 'KARANG MOJO', '01.2010', 71, 0),
(169, 'LEDOK', '01.2001', 62, 0),
(170, 'SENGON', '01.2001', 62, 0),
(171, 'GRASAK', '01.2010', 71, 0),
(172, 'BENDO', '01.2001', 62, 0),
(173, 'KRANGKONG', '02.2015', 86, 0),
(174, 'NGASEM TANGGUNG', '01.2010', 71, 0),
(175, 'PUCUNG', '01.2001', 62, 0),
(176, 'NGROWO', '01.2010', 71, 0),
(177, 'GETAS', '03.2003', 92, 0),
(178, 'weru', '09.2019', 213, 0),
(179, 'tegal giling', '09.2019', 213, 0),
(180, 'Punggur', '09.2019', 213, 0),
(181, 'Temon', '09.2019', 213, 0),
(182, 'Krabyakan', '09.2019', 213, 0),
(183, 'Belik', '09.2019', 213, 0),
(184, 'Kaliweden', '09.2019', 213, 0),
(185, 'MOjosari', '09.2019', 213, 0),
(186, 'Dukuh Klompok Tanjung', '04.2010', 254, 0),
(187, 'BANJAREJO', '03.2008', 98, 0),
(188, 'MOJOREMBUN', '03.2008', 98, 0),
(189, 'SONOREJO', '03.2008', 98, 0),
(190, 'SENDANGTLIKO', '03.2008', 98, 0),
(191, 'Bangeran', '08.2019', 200, 1),
(192, 'KALIKANGKUNG', '03.2002', 91, 0),
(193, 'PLUMBON', '03.2002', 91, 0),
(194, 'NGLEBAK', '03.2002', 91, 0),
(195, 'NGANDONG', '03.2002', 91, 0),
(196, 'KALIKLAMPOK', '08.2004', 184, 0),
(197, 'Dukuh Pandan', '12.2010', 302, 0),
(198, 'Dukuh Pojok', '12.2010', 302, 0),
(199, 'Dukuh Talok', '12.2013', 305, 0),
(200, 'DK. GENENG', '12.2010', 302, 0),
(201, 'Dukuh Temuwoh', '12.2013', 305, 0),
(202, 'Dukuh Canggah ', '12.2013', 305, 0),
(203, 'Dukuh Karangmojo ', '12.2013', 305, 0),
(204, 'Ds. Jetakwanger', '12.2010', 302, 0),
(205, 'PUDAK', '12.2023', 314, 0),
(206, 'PUDAK', '12.2023', 314, 1),
(207, 'BANJARWARU', '12.2023', 314, 0),
(208, 'PLOSO', '12.2023', 314, 0),
(209, '9 dukuh', '10.2012', 234, 0),
(210, 'DUKUH SAMBONG', '06.2004', 163, 0),
(211, 'DUKUH KEJALEN', '06.2004', 163, 0),
(212, 'DUKUH KALIREJO', '06.2004', 163, 0),
(213, 'jenu', '06.2003', 162, 0),
(214, 'gadu', '06.2003', 162, 0),
(215, 'Kendilan', '06.2003', 162, 0),
(216, 'Dukuh Gombang', '15.2007', 238, 0),
(217, 'Dukuh Blimbing', '15.2007', 238, 0),
(218, 'BERU', '12.2009', 301, 0),
(219, 'Maguan', '10.2004', 226, 0),
(220, 'Dk. Karangtawang', '13.2013', 121, 0),
(221, 'BANYUURIP', '12.2009', 301, 0),
(222, 'dukuh Gapuk', '12.2012', 304, 0),
(223, 'Pohrendeng', '10.2004', 226, 0),
(224, 'Berbak', '12.2022', 313, 0),
(225, 'Gagakan', '06.2006', 165, 0),
(226, 'tritek', '10.2007', 229, 0),
(227, 'sembungsss', '10.2003', 225, 1),
(228, 'PIDODO', '12.2009', 301, 0),
(229, 'Dk. Ngledok', '13.2013', 121, 0),
(230, 'Sambiroto', '12.2022', 313, 0),
(231, 'pendem', '10.2007', 229, 0),
(232, 'dukuh sendangagung', '12.2012', 304, 0),
(233, 'KARANGANYAR', '10.2013', 235, 0),
(234, 'Tunjungan', '10.2010', 232, 0),
(235, 'Secang', '06.2006', 165, 0),
(236, 'Kayen', '10.2009', 231, 0),
(237, 'Setro Taman', '10.2004', 226, 0),
(238, 'DUKUH GADE', '12.2017', 309, 0),
(239, 'seren', '12.2024', 315, 1),
(240, 'Karangrejo', '10.2006', 228, 0),
(241, 'busalah', '10.2003', 225, 0),
(242, 'KESER', '10.2014', 236, 0),
(243, 'Dk. Gagakan', '13.2013', 121, 0),
(244, 'Gunungrowo', '10.2009', 231, 0),
(245, 'tambak amper', '10.2007', 229, 0),
(246, 'GENENG', '10.2013', 235, 0),
(247, 'Karang Kembang', '10.2010', 232, 0),
(248, 'dangsari', '12.2024', 315, 1),
(249, 'Plumbon', '12.2005', 297, 0),
(250, 'Sukorejo', '10.2006', 228, 0),
(251, 'Putat', '10.2009', 231, 0),
(252, 'Dk. Brumbung', '13.2013', 121, 0),
(253, 'KALIREJO', '10.2014', 236, 0),
(254, 'nglencong', '10.2003', 225, 0),
(255, 'DUKUH KETANGGI', '12.2017', 309, 0),
(256, 'Greneng', '10.2010', 232, 0),
(257, 'DUKOH', '10.2014', 236, 0),
(258, 'Nglojok', '10.2009', 231, 0),
(259, 'catak', '10.2003', 225, 0),
(260, 'Gersapi', '10.2006', 228, 0),
(261, 'Baengan', '12.2005', 297, 0),
(262, 'Dk. Pohgesik', '13.2013', 121, 0),
(263, 'NGLANGITAN', '10.2013', 235, 0),
(264, 'Kawengan', '08.2018', 199, 0),
(265, 'Nglawungan', '10.2010', 232, 0),
(266, 'Blingi', '10.2006', 228, 0),
(267, 'Ngasinan', '12.2005', 297, 0),
(268, 'GENENG', '10.2014', 236, 0),
(269, 'Sambong', '08.2018', 199, 0),
(270, 'BENGIR', '10.2014', 236, 0),
(271, 'Banjar', '12.2005', 297, 0),
(272, 'Kolutan', '08.2018', 199, 0),
(273, 'NGANTULAN', '10.2013', 235, 0),
(274, 'beran', '12.2016', 307, 0),
(275, 'Dukuh Mawu', '06.2007', 166, 0),
(276, 'Sumurwatu', '08.2018', 199, 0),
(277, 'PLOSOREJO', '10.2013', 235, 0),
(278, 'Dk. Karangjong', '12.2029', 320, 0),
(279, 'Gondang', '12.2016', 307, 0),
(280, 'DK. Pelem', '12.2029', 320, 0),
(281, 'Dk. Pule', '12.2029', 320, 0),
(282, 'Dukuh Kalangan', '10.2008', 230, 0),
(283, 'Dukuh Ngudi', '10.2008', 230, 0),
(284, 'Dukuh Jamur', '10.2008', 230, 0),
(285, 'SITIREJO', '10.2015', 237, 0),
(286, 'Dukuh Bogorejo', '15.2001', 244, 0),
(287, 'KULUR', '10.2015', 237, 0),
(288, 'Dukuh Nglamping', '15.2001', 244, 0),
(289, 'Dukuh Tegalombo', '15.2001', 244, 0),
(290, 'Suwareh', '06.2008', 167, 1),
(291, 'Brabowan', '06.2008', 167, 0),
(292, 'Suwareh', '06.2008', 167, 0),
(293, 'Kaliareng', '06.2008', 167, 0),
(294, 'POJOK', '06.2005', 164, 0),
(295, 'WATUBREM', '06.2005', 164, 0),
(296, 'DELOK', '06.2005', 164, 0),
(297, 'BLIMBING', '06.2002', 161, 0),
(298, 'MEJURANG', '06.2002', 161, 0),
(299, 'KALIMIRI', '06.2002', 161, 0),
(300, 'SAWUR', '06.2002', 161, 0),
(301, 'NGAWENAN', '06.2002', 161, 0),
(302, 'KENDAYAAN', '12.2004', 296, 0),
(303, 'DK. KEDUNGSATRIYAN', '12.2008', 300, 0),
(304, 'DK. WATUR-KEDUNGPOH', '12.2008', 300, 0),
(305, 'CANCANGAN', '06.2010', 169, 0),
(306, 'TRISINAN', '06.2010', 169, 0),
(307, 'Gayam', '15.2010', 247, 0),
(308, 'DUKUH GENENG', '08.2016', 197, 0),
(309, 'DUKUH TANJUNG', '08.2016', 197, 0),
(310, 'DUKUH KEMLOKO', '08.2016', 197, 0),
(311, 'DUKUH KAMPUNG BARU', '08.2016', 197, 0),
(312, 'BRANGKAL', '13.2025', 132, 0),
(313, 'BRANGKAL', '13.2025', 132, 1),
(314, 'Dukuh Banyurip', '16.2007', 327, 0),
(315, 'Dukuh Ngrowo', '16.2007', 327, 0),
(316, 'BRANGKAL', '13.2025', 132, 1),
(317, 'Dukuh Japah', '16.2007', 327, 0),
(318, 'MUNGGUR', '13.2025', 132, 0),
(319, 'POHAWE', '13.2025', 132, 0),
(320, 'pentil', '13.2022', 129, 0),
(321, 'Guyung', '04.2005', 105, 0),
(322, 'BLAO', '16.2005', 325, 0),
(323, 'Klangkrang', '04.2017', 261, 0),
(324, 'Kejiwan', '04.2005', 105, 0),
(325, 'KENONGOGONG', '04.2004', 104, 0),
(326, 'NGASAHAN', '04.2015', 259, 0),
(327, 'Bungur', '05.2001', 262, 0),
(328, 'karanggeneng', '13.2022', 129, 0),
(329, 'Balong', '13.2023', 130, 0),
(330, 'GENENG', '16.2004', 324, 0),
(331, 'klompok', '04.2011', 255, 0),
(332, 'DUKUH NGEPUNG', '05.2008', 269, 0),
(333, 'NGAGLIK', '16.2005', 325, 0),
(334, 'KRAJAN', '16.2008', 328, 0),
(335, 'BETEKAN', '04.2015', 259, 0),
(336, 'Ngablak', '16.2013', 333, 1),
(337, 'Ngablak', '16.2013', 333, 0),
(338, 'Kemantren', '04.2006', 106, 0),
(339, 'wantah', '04.2003', 103, 0),
(340, 'COWEKAN', '13.2002', 110, 0),
(341, 'Bangkerep', '13.2023', 130, 0),
(342, 'JUDAN', '05.2005', 266, 0),
(343, 'CALANGAN', '16.2004', 324, 0),
(344, 'BERAN', '16.2008', 328, 0),
(345, 'KEDINDINDING', '04.2015', 259, 0),
(346, 'Ngampel', '13.2019', 126, 0),
(347, 'DUKUH KENTONG', '05.2008', 269, 0),
(348, 'Tanduran', '04.2006', 106, 0),
(349, 'Kalirejo', '04.2014', 258, 0),
(350, 'Karangori', '16.2014', 334, 0),
(351, 'Dukuh Ketukan', '05.2006', 267, 0),
(352, 'NGRAHO', '04.2015', 259, 0),
(353, 'JIPANG', '05.2005', 266, 0),
(354, 'TEMBELANGAN', '16.2004', 324, 0),
(355, 'Dukuh Balong', '13.2001', 109, 0),
(356, 'GROGOLAN', '13.2002', 110, 0),
(357, 'Mbaran', '13.2019', 126, 0),
(358, 'ngiyono', '16.2016', 336, 1),
(359, 'WADUNG', '04.2015', 259, 0),
(360, 'BAKAH', '13.2010', 118, 0),
(361, 'Dukuh Mulyorejo', '05.2010', 271, 0),
(362, 'DAWUNG', '13.2002', 110, 0),
(363, 'suren', '16.2001', 321, 0),
(364, 'Dukuh Getas', '05.2006', 267, 0),
(365, 'Dukuh Kawisan', '13.2001', 109, 0),
(366, 'Dukuh Sonokidul', '13.2005', 113, 0),
(367, 'NINGALAN', '04.2015', 259, 0),
(368, 'BULOH', '13.2002', 110, 0),
(369, 'banyu urip', '16.2001', 321, 0),
(370, 'Dukuh Ngegot', '05.2006', 267, 0),
(371, 'Dukuh Joho Sawahan', '05.2010', 271, 0),
(372, 'BRENGUS', '13.2015', 123, 0),
(373, 'KALIMONGO', '13.2002', 110, 0),
(374, 'Dukuh Joho', '05.2010', 271, 0),
(375, 'GAPUK', '13.2015', 123, 0),
(376, 'Kodokan', '13.2004', 112, 0),
(377, 'Bojeng', '13.2004', 112, 0),
(378, 'BLONGOH', '13.2015', 123, 0),
(379, 'KERDUAN', '13.2011', 119, 0),
(380, 'NGEPUNG', '13.2015', 123, 0),
(381, 'KAPUAN', '05.2004', 265, 0),
(382, 'CANGAAN', '13.2011', 119, 0),
(383, 'WANGKOT', '05.2004', 265, 0),
(384, 'KALANGAN', '13.2011', 119, 0),
(385, 'BEJIREJO', '13.2020', 127, 0),
(386, 'KETITANG', '13.2020', 127, 0),
(387, 'NGLINGGO', '05.2002', 263, 0),
(388, 'NGLORAM', '05.2002', 263, 0),
(389, 'PUTUK', '05.2002', 263, 0),
(390, 'Kedungpereng', '04.2001', 101, 0),
(391, 'DUKUH KARANGJOHO', '16.2010', 330, 0),
(392, 'DUKUH PENGKOLREJO', '16.2010', 330, 0),
(393, 'DUKUH JAJAR', '16.2010', 330, 0),
(394, 'DUKUH GABENG', '16.2010', 330, 0),
(395, 'wotbakah', '16.2012', 332, 0),
(396, 'POJOK', '10.2001', 338, 0),
(397, 'BULU', '10.2001', 338, 0),
(398, 'KALORAN', '10.2001', 338, 0),
(399, 'BENJID', '10.2001', 338, 0),
(400, 'SINGGAHAN', '10.2001', 338, 0),
(401, 'SINGGAHAN', '10.2001', 338, 1),
(402, 'TAPELAN', '10.2001', 338, 0),
(403, 'BRINGIN', '10.2001', 338, 0),
(404, 'NGLENCONG', '10.2001', 338, 0),
(405, 'NGRANCAAN', '10.2001', 338, 0),
(406, 'KEMIRI', '13.2003', 111, 0),
(407, 'NGREJENG', '13.2003', 111, 0),
(408, 'NGLAHAR', '13.2003', 111, 0),
(409, 'TEMPLEK', '13.2003', 111, 0),
(410, 'NGRIKING', '13.2003', 111, 0),
(411, 'DOYOK', '13.2003', 111, 0),
(412, 'prantaan', '15.2005', 242, 0),
(413, 'Kesambi', '15.2005', 242, 0),
(414, 'Kaligandu', '15.2005', 242, 0),
(415, 'DUKUH GEDANGDOWO', '08.2020', 201, 0),
(416, 'DUKUH KEDUWANG', '08.2020', 201, 0),
(417, 'DUKUH BANJARDOWO', '08.2020', 201, 0),
(418, 'Kalen Krajan', '04.2014', 258, 0),
(419, 'Babatan', '04.2014', 258, 0),
(420, 'Mundu', '04.2014', 258, 0),
(421, 'Selorejo', '04.2014', 258, 0),
(422, 'Banyuasin', '04.2014', 258, 0),
(423, 'GEDEBEG', '12.2002', 294, 0),
(424, 'DUWET', '12.2002', 294, 0),
(425, 'KEPITU', '12.2002', 294, 0),
(426, 'GANDU', '12.2002', 294, 0),
(427, 'PUCUNG', '12.2002', 294, 0),
(428, 'DUKUH PAYAMAN', '07.2001', 170, 0),
(429, 'DESA JANJANG RT 01,02,03,04,05,06 RW 01 KECAMATAN ', '07.2004', 173, 1),
(430, 'DESA JANJANG RT 01,02,03 RW 02 DUKUH BULAK KECAMAT', '07.2004', 173, 1),
(431, 'DESA JANJANG RT', '07.2004', 173, 1),
(432, 'DESA JANJANG RT 01,02,03,04,05,06 RW 01', '07.2004', 173, 0),
(433, 'DUKUH BULAK RT 01,02,03 RW 02', '07.2004', 173, 0),
(434, 'DUKUH SAMBONG RT 01,02 RW 03', '07.2004', 173, 0),
(435, 'DUKUH JOMBLANG RT 01,02 RW 04', '07.2004', 173, 0),
(436, 'DUKUH KATESAN RT 01,02 RW 05', '07.2004', 173, 0),
(437, 'Manggir', '14.2014', 147, 0),
(438, 'Ngumbul', '14.2014', 147, 0),
(439, 'Nglebur', '14.2014', 147, 0),
(440, 'Kopen', '14.2014', 147, 0),
(441, 'Watuondo', '14.2014', 147, 0),
(442, 'KARANGGENG', '16.2015', 335, 0),
(443, 'Bangsan', '04.2012', 256, 0),
(444, 'Dukuh Nguter', '13.2001', 109, 0),
(445, 'Dukuh Ngreco', '13.2001', 109, 0),
(446, 'Dukuh Tanduran', '13.2001', 109, 0),
(447, 'Dukuh Pungkruk', '13.2001', 109, 0),
(448, 'Dukuh Ngrapoh', '13.2001', 109, 0),
(449, 'Dukuh Gabluk', '13.2001', 109, 0),
(450, 'Dukuh Nglencong', '13.2001', 109, 0),
(451, '1. TELAPAK', '15.2009', 246, 0),
(452, '2. WANUTENGAH', '15.2009', 246, 0),
(453, 'Kalinanas', '16.2018', 159, 0),
(454, 'Sendangrejo', '16.2018', 159, 0),
(455, 'Sumberjo', '16.2018', 159, 0),
(456, 'DUKUH SENTONOREJO', '07.2010', 179, 0),
(457, 'KARANGGENG', '16.2015', 335, 1),
(458, 'DUKUH NDAWE', '14.2017', 150, 0),
(459, 'DUKUH SENDANG', '14.2017', 150, 0),
(460, 'TROJIWO', '01.2010', 71, 0),
(461, 'RANDULAWANG', '01.2010', 71, 0),
(462, 'MUNGKUNG', '01.2010', 71, 0),
(463, 'WONOSARI', '09.2020', 214, 0),
(464, 'BULAK', '09.2020', 214, 1),
(465, 'BULAK', '09.2020', 214, 0),
(466, 'SENDANGKLAMPOK', '09.2020', 214, 0),
(467, 'GULINGAN', '09.2020', 214, 0),
(468, 'BAKALAN', '09.2020', 214, 0),
(469, 'NGELO', '01.2004', 65, 0),
(470, 'KEDUNG GLAGAH', '01.2004', 65, 0),
(471, 'MINDI', '01.2004', 65, 0),
(472, 'PELANG', '01.2004', 65, 0),
(473, 'TEMULAWAK', '01.2004', 65, 0),
(474, 'SODO', '05.2007', 268, 0),
(475, 'SUMBERPITU', '05.2007', 268, 0),
(476, 'DUSUN TUTUP', '10.2005', 227, 0),
(477, 'DUSUN SUKORAME', '10.2005', 227, 0),
(478, 'DUSUN NGETREP', '10.2005', 227, 0),
(479, 'TROJIWO', '12.2024', 315, 1),
(480, 'DANGSARI', '12.2024', 315, 0),
(481, 'DUKOH', '12.2024', 315, 0),
(482, 'KARANGTALUN', '11.2015', 287, 0),
(483, 'BESI', '01.2005', 66, 0),
(484, 'BUMIREJO', '01.2005', 66, 0),
(485, 'JEGONG', '01.2005', 66, 0),
(486, 'KEMADOH', '01.2005', 66, 0),
(487, 'DESA BALONGREJO', '11.2014', 286, 0),
(488, 'DUKUH KEDUNGKRIKIL', '11.2014', 286, 0),
(489, 'Dukuh Banyakijo', '13.2005', 113, 0),
(490, 'Dukuh Jomblang', '13.2005', 113, 0),
(491, 'Dukuh Karangpung', '13.2005', 113, 0),
(492, 'Dukuh Trowolu', '13.2005', 113, 0),
(493, 'Dukuh Temas', '13.2005', 113, 0),
(494, 'DUKUH KARANGGENENG', '09.2023', 217, 0),
(495, 'DUKUH PANGKAT', '09.2023', 217, 0),
(496, 'DUKUH BUBAK', '09.2023', 217, 0),
(497, 'DUKUH MOGO PLOSO', '09.2023', 217, 0),
(498, 'ROWOREJO', '13.2008', 116, 0),
(499, 'KARANGPUNG', '13.2008', 116, 0),
(500, 'PLOSOREJO', '13.2008', 116, 0),
(501, 'GEBANGAN', '13.2008', 116, 0),
(502, 'TEGALREJO', '13.2008', 116, 0),
(503, 'BACEM', '08.2022', 203, 0),
(504, 'MANYARAN', '08.2022', 203, 0),
(505, 'BULU', '08.2022', 203, 0),
(506, 'Ngilen', '13.2009', 117, 0),
(507, 'Jatal ', '13.2009', 117, 0),
(508, 'WADO', '04.2008', 108, 0),
(509, 'GEMPOL', '04.2008', 108, 0),
(510, 'SUDUNG', '04.2008', 108, 0),
(511, 'GOSTEN LOR', '09.2002', 208, 0),
(512, 'Trembul wetan', '12.2014', 306, 0),
(513, 'Trembul kulon', '12.2014', 306, 0),
(514, 'ngrenak', '14.2006', 139, 0),
(515, 'glagahan', '09.2001', 207, 0),
(516, 'jasem', '09.2001', 207, 0),
(517, 'gusten', '09.2001', 207, 0),
(518, 'jepangrejo', '09.2001', 207, 0),
(519, 'PULE', '08.2021', 202, 0),
(520, 'DAGEL', '08.2021', 202, 0),
(521, 'LUKBANG', '08.2021', 202, 0),
(522, 'TLOGO', '14.2019', 152, 0),
(523, 'DALANGAN', '14.2019', 152, 0),
(524, 'SURWATU', '14.2019', 152, 0),
(525, 'PUCUNG + PUNGGUR', '06.2001', 160, 0),
(526, 'TEMENGENG', '06.2001', 160, 0),
(527, 'PASAR SORE', '06.2001', 160, 0),
(528, 'xxxx', '01.2001', 3, 0);

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

--
-- Struktur dari tabel `tb_ormas`
--

CREATE TABLE `tb_ormas` (
  `id_ormas` int(11) NOT NULL,
  `nomor_surat_pengesahan` varchar(100) DEFAULT NULL,
  `tanggal_terdaftar` date NOT NULL,
  `nama_organisasi` varchar(100) DEFAULT NULL,
  `ruang_lingkup` varchar(100) DEFAULT NULL,
  `id_kategori_ormas` int(11) NOT NULL DEFAULT 0,
  `masa_periode_tahun_1` varchar(100) DEFAULT NULL,
  `masa_periode_tahun_2` varchar(100) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `id_kecamatan` varchar(100) DEFAULT NULL,
  `id_desa` varchar(100) DEFAULT NULL,
  `tempat_pendirian` varchar(100) DEFAULT NULL,
  `tanggal_berdiri` date DEFAULT NULL,
  `asas_ciri_organisasi` text DEFAULT NULL,
  `tujuan_organisasi` text DEFAULT NULL,
  `nama_pendiri` varchar(100) DEFAULT NULL,
  `nama_pembina` varchar(100) DEFAULT NULL,
  `nama_penasehat` varchar(100) DEFAULT NULL,
  `masa_bakti_kepengurusan` varchar(100) DEFAULT NULL,
  `keputusan_tertinggi` varchar(100) DEFAULT NULL,
  `unit` varchar(100) DEFAULT NULL,
  `usaha_organisasi` varchar(100) DEFAULT NULL,
  `sumber_keuangan` varchar(100) DEFAULT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `bendera` varchar(100) DEFAULT NULL,
  `akte_notaris` varchar(100) DEFAULT NULL,
  `file_npwp` varchar(100) DEFAULT NULL,
  `id_user` int(11) NOT NULL,
  `is_validasi` int(11) NOT NULL DEFAULT 0,
  `is_tte` int(11) NOT NULL DEFAULT 0,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `id_user_ormas` int(11) NOT NULL DEFAULT 0,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_ormas`
--

INSERT INTO `tb_ormas` (`id_ormas`, `nomor_surat_pengesahan`, `tanggal_terdaftar`, `nama_organisasi`, `ruang_lingkup`, `id_kategori_ormas`, `masa_periode_tahun_1`, `masa_periode_tahun_2`, `alamat`, `id_kecamatan`, `id_desa`, `tempat_pendirian`, `tanggal_berdiri`, `asas_ciri_organisasi`, `tujuan_organisasi`, `nama_pendiri`, `nama_pembina`, `nama_penasehat`, `masa_bakti_kepengurusan`, `keputusan_tertinggi`, `unit`, `usaha_organisasi`, `sumber_keuangan`, `logo`, `bendera`, `akte_notaris`, `file_npwp`, `id_user`, `is_validasi`, `is_tte`, `username`, `password`, `id_user_ormas`, `inserted`, `deleted`) VALUES
(1, '123123123123', '2024-05-10', '34', '34', 1, '2024', '2025', '34', '02', '01.2003', '34', '2024-05-06', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', 'd5aaeb9ebc46d0de234faeaaf8a44af9.png', 'c3735a9e6c8d24be0f260430fc202bb0.png', 'b030e0bac9f98207e41381b7e7af1808.png', 'b4e72e69f6aef32e1ceb7b6995c5675c.png', 0, 3, 3, NULL, NULL, 1, '2024-05-10 07:50:31', 0);

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

--
-- Struktur dari tabel `tb_ormas_bantuan`
--

CREATE TABLE `tb_ormas_bantuan` (
  `id_bantuan` int(11) NOT NULL,
  `id_ormas` int(11) NOT NULL,
  `id_kategori_bantuan` int(11) NOT NULL DEFAULT 0,
  `nama_bantuan` varchar(100) NOT NULL,
  `asal_bantuan` varchar(100) NOT NULL,
  `tanggal_bantuan` date NOT NULL,
  `jumlah` varchar(100) NOT NULL,
  `foto` varchar(100) DEFAULT NULL,
  `id_user` int(11) NOT NULL,
  `status_validasi` int(11) NOT NULL DEFAULT 0 COMMENT '0 = pengajuan,1=dikasi,2=ditolak,3=disetujui',
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_ormas_bantuan`
--

INSERT INTO `tb_ormas_bantuan` (`id_bantuan`, `id_ormas`, `id_kategori_bantuan`, `nama_bantuan`, `asal_bantuan`, `tanggal_bantuan`, `jumlah`, `foto`, `id_user`, `status_validasi`, `inserted`, `deleted`) VALUES
(1, 1, 2, '2222', '2222', '2024-05-10', '2222', '86caec72a0b60d1321026ed1502925af.png', 0, 0, '2024-05-10 08:37:01', 0);

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

--
-- Struktur dari tabel `tb_ormas_bidang`
--

CREATE TABLE `tb_ormas_bidang` (
  `id_ormas_bidang` int(12) NOT NULL,
  `id_ormas` int(12) NOT NULL,
  `id_ormas_user` int(11) NOT NULL DEFAULT 0,
  `id_bidang` int(12) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_ormas_bidang`
--

INSERT INTO `tb_ormas_bidang` (`id_ormas_bidang`, `id_ormas`, `id_ormas_user`, `id_bidang`, `inserted`, `deleted`) VALUES
(1, 1, 1, 1, '2024-05-06 06:19:42', 0),
(2, 1, 1, 2, '2024-05-06 06:19:42', 0);

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

--
-- Struktur dari tabel `tb_ormas_kegiatan`
--

CREATE TABLE `tb_ormas_kegiatan` (
  `id_kegiatan` int(11) NOT NULL,
  `id_ormas` int(11) NOT NULL,
  `id_user_ormas` int(11) NOT NULL DEFAULT 0,
  `nama_kegiatan` varchar(100) NOT NULL,
  `id_bidang` int(11) NOT NULL,
  `resume_kegiatan` text NOT NULL,
  `dari_tanggal` date NOT NULL,
  `sampai_tanggal` date NOT NULL,
  `foto_1` varchar(100) NOT NULL,
  `foto_2` varchar(100) NOT NULL,
  `foto_3` varchar(100) NOT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_ormas_kegiatan`
--

INSERT INTO `tb_ormas_kegiatan` (`id_kegiatan`, `id_ormas`, `id_user_ormas`, `nama_kegiatan`, `id_bidang`, `resume_kegiatan`, `dari_tanggal`, `sampai_tanggal`, `foto_1`, `foto_2`, `foto_3`, `inserted`, `deleted`) VALUES
(1, 1, 1, 'Ormas', 1, '09', '2024-05-08', '2024-05-08', 'b4e72e69f6aef32e1ceb7b6995c5675c.png', '0f22daf53690c1cc5f5ae962b9ce2695.png', 'b4e72e69f6aef32e1ceb7b6995c5675c.png', '2024-05-08 12:55:35', 0);

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

--
-- Struktur dari tabel `tb_ormas_pengurus`
--

CREATE TABLE `tb_ormas_pengurus` (
  `id_ormas_pengurus` int(11) NOT NULL,
  `id_ormas` int(11) NOT NULL,
  `id_ormas_user` int(11) NOT NULL DEFAULT 0,
  `id_jabatan` int(11) NOT NULL DEFAULT 0,
  `nama_pengurus` varchar(100) DEFAULT NULL,
  `alamat_pengurus` text DEFAULT NULL,
  `nomor_telepon_pengurus` text DEFAULT NULL,
  `tempat_lahir_pengurus` varchar(100) DEFAULT NULL,
  `tanggal_lahir_pengurus` date DEFAULT NULL,
  `pekerjaan_pengurus` varchar(100) DEFAULT NULL,
  `jabatan_pekerjaan_pengurus` varchar(100) DEFAULT NULL,
  `agama_pengurus` int(11) DEFAULT NULL,
  `status_perkawinan_pengurus` varchar(100) DEFAULT NULL,
  `nama_pasangan` varchar(100) DEFAULT NULL,
  `jumlah_anak` varchar(100) DEFAULT NULL,
  `file_ktp` varchar(100) DEFAULT NULL,
  `file_surat_pernyataan` varchar(100) DEFAULT NULL,
  `file_foto` varchar(100) DEFAULT NULL,
  `inserted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_ormas_pengurus`
--

INSERT INTO `tb_ormas_pengurus` (`id_ormas_pengurus`, `id_ormas`, `id_ormas_user`, `id_jabatan`, `nama_pengurus`, `alamat_pengurus`, `nomor_telepon_pengurus`, `tempat_lahir_pengurus`, `tanggal_lahir_pengurus`, `pekerjaan_pengurus`, `jabatan_pekerjaan_pengurus`, `agama_pengurus`, `status_perkawinan_pengurus`, `nama_pasangan`, `jumlah_anak`, `file_ktp`, `file_surat_pernyataan`, `file_foto`, `inserted`, `deleted`) VALUES
(1, 1, 1, 2, '2', '2', '2', '2', '2024-05-14', '2', '2', 4, 'Kawin', '2', '2', 'b030e0bac9f98207e41381b7e7af1808.png', '86caec72a0b60d1321026ed1502925af.png', 'b030e0bac9f98207e41381b7e7af1808.png', '2024-05-06 06:19:42', 0);

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

--
-- Struktur dari tabel `tb_users`
--

CREATE TABLE `tb_users` (
  `id` int(11) NOT NULL,
  `id_pegawai` int(11) NOT NULL DEFAULT 0,
  `nip` varchar(50) NOT NULL,
  `nik` varchar(100) DEFAULT NULL,
  `nama_pegawai` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `profile_image` text NOT NULL,
  `deleted` int(11) DEFAULT 0,
  `status_user` varchar(20) NOT NULL,
  `id_desa` varchar(10) NOT NULL,
  `passphrase` varchar(100) NOT NULL,
  `jabatan` varchar(100) DEFAULT NULL,
  `status_perwakilan_tte` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_users`
--

INSERT INTO `tb_users` (`id`, `id_pegawai`, `nip`, `nik`, `nama_pegawai`, `username`, `password`, `profile_image`, `deleted`, `status_user`, `id_desa`, `passphrase`, `jabatan`, `status_perwakilan_tte`) VALUES
(3, 0, '23', '23', 'Adit', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 0, 'admin', '01.2002', '', 'Pembina Tk 1', ''),
(14, 0, 'mimin', NULL, '', 'mimin', '03f7f7198958ffbda01db956d15f134a', '', 1, 'TPK', '', '', NULL, ''),
(15, 0, 'mimin', NULL, '', 'mimin', '03f7f7198958ffbda01db956d15f134a', '', 1, 'Bendahara', '', '', NULL, ''),
(16, 0, '1', NULL, '', '1', '1', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'admin', '01.2002', '', NULL, ''),
(17, 0, '8', NULL, '', '8', '8', '', 1, 'Kepala Desa', '01.2005', '', NULL, ''),
(18, 0, 'nip2', NULL, '', 'nip', 'nip', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'Sekretaris', '01.2007', '', NULL, ''),
(24, 0, 'admin', NULL, 'Aditya Eka', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'admin', '01.2002', '', NULL, ''),
(22, 0, 'dinas2', NULL, 'Dinas Pemberdayaan Masyarakat dan Desa', 'dinas', '097dad4a551e3cb88ed7afc7a6c0de40', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'dinas', '-', '', NULL, ''),
(25, 0, '010102', NULL, '', '010102', 'df08031b4a7f92e2b8035b54e994042d', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'admin', '01.2004', '', NULL, ''),
(26, 1, 'set', NULL, '', 'set', 'cdaeeeba9b4a4c5ebf042c0215a7bb0e', '9a132499b8825bacaa92d29cbbc2c67e.jpeg', 1, 'admin', '01.2002', '', NULL, ''),
(27, 0, 'jatisari', NULL, '', 'jatisari', '0977ddc8c14519ae09ec21ff707094a7', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'admin', '11.2001', '', NULL, ''),
(29, 0, '196704122002121006', NULL, '', 'kades', '0cfa66469d25bd0d9e55d7ba583f9f2f', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'Kepala Desa', '01.2002', '', NULL, ''),
(30, 0, 'kades', NULL, 'Nur Sa\'an', 'kades', '0cfa66469d25bd0d9e55d7ba583f9f2f', '02e1d965a61459123a642f82b89e67dc.jpeg', 1, 'Kepala Desa', '01.2002', '', NULL, ''),
(31, 0, '01012', NULL, 'test', 'ICIKIWIR', '2312d1980c734e0f9da6e67c6035c433', '2d7ddf50c2840f69f7271e98cb92b32b.jpeg', 1, 'kecamatan', '04', '', NULL, ''),
(32, 0, '01ww', NULL, 'Sutarso. S.Sos,M.si', 'adit', '486b6c6b267bc61677367eb6b6458764', 'd77c560d3619f54717d61eb1909bdae2.jpg', 0, '', '01', '', NULL, ''),
(33, 0, 'kepoh', NULL, 'kepoh', 'kepoh', '39d1c50bb3aeb2a9c311fc8e3b6d0dcd', '9a132499b8825bacaa92d29cbbc2c67e.jpeg', 1, 'admin', '01.2003', '', NULL, ''),
(34, 0, '12121', NULL, 'test', 'test', '098f6bcd4621d373cade4e832627b4f6', 'aa55a198d7e3cf22f5eefd480fc62fb6.JPG', 1, 'admin', '08.2011', '', NULL, ''),
(35, 0, '01', NULL, 'Kecamatan Jati', 'kec_jati', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '01', '', NULL, ''),
(36, 0, 'FOTO', NULL, 'FOTO', 'FOTO', '8844bb893d3b16fa3365a5cfcde4edca', '6e348bbbc7cd0c2bf3239bf0a0ea9dcb.png', 1, 'kecamatan', '02', '', NULL, ''),
(37, 0, 'm', NULL, 'm', 'mimin', '6f8f57715090da2632453988d9a1501b', '6e348bbbc7cd0c2bf3239bf0a0ea9dcb.png', 1, 'kecamatan', '09', '', NULL, ''),
(38, 0, 'jeng', NULL, 'jeng', 'jeng', '8f0a8258d0a0bb552b99cfd56a12965c', '6e348bbbc7cd0c2bf3239bf0a0ea9dcb.png', 1, '', '01.2005', '', NULL, ''),
(39, 0, 'jeng', NULL, 'jeng', 'jeng', '8f0a8258d0a0bb552b99cfd56a12965c', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'admin', '01.2005', '', NULL, ''),
(40, 0, '03', NULL, '03', '03', 'e45ee7ce7e88149af8dd32b27f9512ce', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'kecamatan', '07', '', NULL, ''),
(41, 0, '04', NULL, '04', '04', '7d0665438e81d8eceb98c1e31fca80c1', '9a132499b8825bacaa92d29cbbc2c67e.jpeg', 1, 'kecamatan', '11', '', NULL, ''),
(42, 0, '03', NULL, '03', '03', 'e45ee7ce7e88149af8dd32b27f9512ce', '9a132499b8825bacaa92d29cbbc2c67e.jpeg', 1, 'kecamatan', '03', '', NULL, ''),
(43, 0, '03', NULL, '03', '03', 'e45ee7ce7e88149af8dd32b27f9512ce', '739ec66e00fc1bde00634d331d26eba8.43', 1, 'kecamatan', '06', '', NULL, ''),
(44, 0, '05', NULL, '05', '05', '751d31dd6b56b26b29dac2c0e1839e34', 'a9426c502ac8c4f42222874a4bccc150.jpg', 1, 'kecamatan', '08', '', NULL, ''),
(45, 0, '3', NULL, '3', '3', 'eccbc87e4b5ce2fe28308fd9f2a7baf3', '1d02b5cd03f93a80c4f6f10011d467b9.jpg', 1, 'dinas', '-', '', NULL, ''),
(46, 0, '02', NULL, ' Kecamatan Randublatung', 'kec_randublatung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '02', '', NULL, ''),
(47, 0, '03', NULL, 'Kecamatan Kradenan', 'kec_kradenan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '03', '', NULL, ''),
(48, 0, '04', NULL, 'Kecamatan Kedungtuban', 'kec_kedungtuban', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '04', '', NULL, ''),
(49, 0, '05', NULL, 'Kecamatan Cepu', 'kec_cepu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '05', '', NULL, ''),
(50, 0, '06', NULL, 'Kecamatan Sambong', 'kec_sambong', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '06', '', NULL, ''),
(51, 0, '07', NULL, 'Kecamatan Jiken', 'kec_jiken', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '07', '', NULL, ''),
(52, 0, '08', NULL, 'Jepon', 'kec_jepon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '08', '', NULL, ''),
(53, 0, '3316091907750002', NULL, 'SUISWARI', 'kec_blora', '827ccb0eea8a706c4c34a16891f84e7b', '895afa26d4f4342874c2b6b80051418e.jpeg', 0, 'kecamatan', '09', '', NULL, ''),
(54, 0, '10', NULL, 'Kecamatan  Tunjungan', 'kec_tunjungan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '10', '', NULL, ''),
(55, 0, '11', NULL, 'Kecamatan Banjarejo', 'kec_banjarejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '11', '', NULL, ''),
(56, 0, 'dinas2', NULL, 'dinas2', 'dinas2', '4cec301b9cb0a32f1541af234254674e', '9a132499b8825bacaa92d29cbbc2c67e.jpeg', 1, 'dinas', '-', '', NULL, ''),
(57, 0, '12', NULL, 'Kecamatan Ngawen', 'kec_ngawen', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '12', '', NULL, ''),
(58, 0, '13', NULL, 'Kecamatan Kunduran', 'kec_kunduran', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '13', '', NULL, ''),
(59, 0, '14', NULL, 'Kecamatan Todanan', 'kec_todanan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '14', '', NULL, ''),
(60, 0, '15', NULL, 'Kecamatan Bogorejo', 'kec_bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '15', '', NULL, ''),
(61, 0, '16', NULL, 'Kecamatan Japah', 'kec_japah', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'kecamatan', '16', '', NULL, ''),
(62, 0, '01.2001', NULL, 'Desa Bangkleyan', 'bangkleyan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2001', '', NULL, ''),
(63, 0, '01.2002', NULL, 'Desa Gempol', 'gempol', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2002', '', NULL, ''),
(64, 0, '01.2003', NULL, 'Desa Kepoh', 'kepoh', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2003', '', NULL, ''),
(65, 0, '01.2004', NULL, 'Desa Pelem ', 'pelem_jati', '827ccb0eea8a706c4c34a16891f84e7b', 'd947a6db07c566efcc59e007bd24c6f2.jpg', 0, 'admin', '01.2004', '', NULL, ''),
(66, 0, '01.2005', NULL, 'Desa Jegong', 'jegong', '827ccb0eea8a706c4c34a16891f84e7b', '3b330292ba2c21cbbda2480e4d69433d.jpg', 0, 'admin', '01.2005', '', NULL, ''),
(67, 0, '01.2006', NULL, 'Desa Jati', 'jati', '04bb1284c3b89f194a96848a07777fe5', '582ddf5ee5bcbe1ed5a2258c63649798.jpg', 0, 'admin', '01.2006', '', NULL, ''),
(68, 0, '01.2007', NULL, 'Desa Singget', 'singget', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2007', '', NULL, ''),
(69, 0, '01.2008', NULL, 'Desa Gabusan', 'gabusan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2008', '', NULL, ''),
(70, 0, '01.2009', NULL, 'Desa Doplang', 'doplang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2009', '', NULL, ''),
(71, 0, '01.2010', NULL, 'Desa Randulawang', 'randulawang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2010', '', NULL, ''),
(72, 0, '01.2011', NULL, 'Desa Tobo', 'tobo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2011', '', NULL, ''),
(73, 0, '01.2012', NULL, 'Desa Pengkoljagong', 'pengkoljagong', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '01.2012', '', NULL, ''),
(74, 0, '02.2001', NULL, 'Desa Tlogotuwung', 'tlogotuwung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2001', '', NULL, ''),
(75, 0, '02.2002', NULL, 'Desa Bodeh', 'bodeh', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2002', '', NULL, ''),
(76, 0, '02.2003', NULL, 'Desa Gembyungan', 'gembyungan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2003', '', NULL, ''),
(77, 0, '02.2004', NULL, 'Desa Sambongwangan', 'sambongwangan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2004', '', NULL, ''),
(78, 0, '02.2005', NULL, 'Desa Pilang', 'pilang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2006', '', NULL, ''),
(79, 0, '02.2006', NULL, 'Desa Temulus', 'temulus', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2007', '', NULL, ''),
(80, 0, '02.2007', NULL, 'Desa Sumberejo', 'sumberejo_randublatung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2008', '', NULL, ''),
(81, 0, '02.2008', NULL, 'Desa Kutukan', 'kutukan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2009', '', NULL, ''),
(82, 0, '02.2009', NULL, 'Desa Kediren', 'kediren', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2010', '', NULL, ''),
(83, 0, '02.2010', NULL, 'Desa Kadengan', 'kadengan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2012', '', NULL, ''),
(84, 0, '02.2011', NULL, 'Desa Bekutuk', 'bekutuk', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2013', '', NULL, ''),
(85, 0, '02.2012', NULL, 'Desa Plosorejo', 'plosorejo_randublatung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2014', '', NULL, ''),
(86, 0, '02.2013', NULL, 'Desa Jeruk', 'jeruk_randublatung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2015', '', NULL, ''),
(87, 0, '02.2014', NULL, 'Desa Tanggel', 'tanggel', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2016', '', NULL, ''),
(88, 0, '02.2015', NULL, 'Desa Kalisari', 'kalisari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2017', '', NULL, ''),
(89, 0, '02.2016', NULL, 'Desa Ngeliron', 'ngliron', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '02.2018', '', NULL, ''),
(90, 0, '3316030805760003', NULL, 'MULYADI NURKASAN', 'megeri', '3d73783b1c5a3560b3cd1bb4c67ceb36', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2001', '', NULL, ''),
(91, 0, '03.2002', NULL, 'Desa Nglebak', 'nglebak', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2002', '', NULL, ''),
(92, 0, '03.2003', NULL, 'Desa Getas', 'getas_kradenan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2003', '', NULL, ''),
(93, 0, '03.2004', NULL, 'Desa Nginggil', 'nginggil', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2004', '', NULL, ''),
(94, 0, '03.2004', NULL, 'Desa Nginggil', 'nginggil', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 1, 'admin', '03.2004', '', NULL, ''),
(95, 0, '03.2005', NULL, 'Desa Ngrawoh', 'ngrawoh', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2005', '', NULL, ''),
(96, 0, '03.2006', NULL, 'Desa Mendenrejo', 'mendenrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2006', '', NULL, ''),
(97, 0, '03.2007', NULL, 'Desa Sumber', 'sumber', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2007', '', NULL, ''),
(98, 0, '03.2008', NULL, 'Desa Mojorembun', 'mojorembun', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2008', '', NULL, ''),
(99, 0, '03.2009', NULL, 'Desa Nglungger', 'nglungger', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2009', '', NULL, ''),
(100, 0, '03.2010', NULL, 'Desa Medalem', 'medalem', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '03.2010', '', NULL, ''),
(101, 0, '04.2001', NULL, 'Desa Gondel', 'gondel', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2001', '', NULL, ''),
(102, 0, '04.2002', NULL, 'Desa Ketuwan', 'ketuwan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2002', '', NULL, ''),
(103, 0, '04.2003', NULL, 'Desa Jimbung', 'jimbung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2003', '', NULL, ''),
(104, 0, '04.2004', NULL, 'Desa Panolan', 'panolan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2004', '', NULL, ''),
(105, 0, '04.2005', NULL, 'Desa Klagen', 'klagen', '827ccb0eea8a706c4c34a16891f84e7b', 'f5983b5d241dc3ebf752141d7835b37b.jpg', 0, 'admin', '04.2005', '', NULL, ''),
(106, 0, '04.2006', NULL, 'Desa Kemantren', 'kemantren', '827ccb0eea8a706c4c34a16891f84e7b', 'a8f95aa0955a99e422e97d6f7fa4c57b.jpg', 0, 'admin', '04.2006', '', NULL, ''),
(107, 0, '04.2007', NULL, 'Desa Sidorejo', 'sidorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2007', '', NULL, ''),
(108, 0, '04.2008', NULL, 'Desa Wado', 'wado', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2008', '', NULL, ''),
(109, 0, '13.2001', NULL, 'Desa Botoreco', 'botoreco', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2001', '', NULL, ''),
(110, 0, '13.2002', NULL, 'Desa Buloh', 'buloh', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2002', '', NULL, ''),
(111, 0, '13.2003', NULL, 'Desa Kemiri', 'kemiri_kunduran', '827ccb0eea8a706c4c34a16891f84e7b', 'c86d5df25b9ad687163f681bb054a6e7.php', 0, 'admin', '13.2003', '', NULL, ''),
(112, 0, '13.2004', NULL, 'Desa Kodokan', 'kodokan', '827ccb0eea8a706c4c34a16891f84e7b', '1e40f4614ac2c6b9a726c01bd77ad656.jpg', 0, 'admin', '13.2004', '', NULL, ''),
(113, 0, '13.2005', NULL, 'Desa Sonokidul', 'sonokidul', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2005', '', NULL, ''),
(114, 0, '13.2006', NULL, 'Desa Sempu', 'sempu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2006', '', NULL, ''),
(115, 0, '13.2007', NULL, 'Desa Cungkup', 'cungkup', 'c0bc21eee621311ceed5c908674eaabb', 'a17530c3e7b5d404441453a49c0958e6.jpg', 0, 'admin', '13.2007', '', NULL, ''),
(116, 0, '3316131005770003', NULL, 'SUWIKNYO', 'plosorejo_kunduran', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2008', '', NULL, ''),
(117, 0, '13.2009', NULL, 'Desa Ngilen', 'ngilen', '827ccb0eea8a706c4c34a16891f84e7b', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '13.2009', '', NULL, ''),
(118, 0, '13.2010', NULL, 'Desa  Bakah', 'bakah', '827ccb0eea8a706c4c34a16891f84e7b', '0899decea67a3901a1d95a00a8cd09ff.23', 0, 'admin', '13.2010', '', NULL, ''),
(119, 0, '13.2011', NULL, 'Desa Kalangrejo', 'kalangrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2011', '', NULL, ''),
(120, 0, '13.2012', NULL, 'Desa Blumbangrejo', 'blumbangrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2012', '', NULL, ''),
(121, 0, '13.2013', NULL, 'Desa Tawangrejo Kec Tunjungan', 'tawangrejo_Tunjungan', '827ccb0eea8a706c4c34a16891f84e7b', '7d5acc27bbecb84a63e42ae7f34d0640.14', 0, 'admin', '13.2013', '', NULL, ''),
(122, 0, '13.2014', NULL, 'Desa Klokah', 'klokah', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2014', '', NULL, ''),
(123, 0, '13.2015', NULL, 'Desa Muraharjo', 'muraharjo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2015', '', NULL, ''),
(124, 0, '13.2016', NULL, 'Desa Jagong ', 'jagong ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2016', '', NULL, ''),
(125, 0, '13.2017', NULL, 'Desa Gagaan', 'gagaan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2018', '', NULL, ''),
(126, 0, '13.2018', NULL, 'Desa Sambiroto', 'sambiroto', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2019', '', NULL, ''),
(127, 0, '13.2019', NULL, 'Desa Bejirejo', 'bejirejo', '827ccb0eea8a706c4c34a16891f84e7b', '4bdbd31e8e54933c9e8c6d04afc6d87d.jpg', 0, 'admin', '13.2020', '', NULL, ''),
(128, 0, '13.2020', NULL, 'Desa Jetak', 'jetak', '827ccb0eea8a706c4c34a16891f84e7b', '39068601c2e8f4b9f006e70aa25db593.jpg', 0, 'admin', '13.2021', '', NULL, ''),
(129, 0, '13.2021', NULL, 'Desa Karanggeneng', 'karanggeneng', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2022', '', NULL, ''),
(130, 0, '13.2022', NULL, 'Desa Balong', 'balong_kunduran', '827ccb0eea8a706c4c34a16891f84e7b', '310a2888f7997bc92170f12b9d4cbdce.jpg', 0, 'admin', '13.2023', '', NULL, ''),
(131, 0, '13.2023', NULL, 'Desa Ngawenombo', 'ngawenombo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2024', '', NULL, ''),
(132, 0, '13.2024', NULL, 'Desa Sendangwates ', 'sendangwates ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2025', '', NULL, ''),
(133, 0, '13.2025', NULL, 'Desa Kedungwaru', 'kedungwaru', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '13.2026', '', NULL, ''),
(134, 0, '14.2001', NULL, 'Desa Tinapan', 'tinapan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2001', '', NULL, ''),
(135, 0, '14.2002', NULL, 'Desa Sambeng', 'sambeng', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2002', '', NULL, ''),
(136, 0, '14.2003', NULL, 'Desa Prigi', 'prigi', '827ccb0eea8a706c4c34a16891f84e7b', '879be75d480a13d8b05f3844a2bd3169.jpg', 0, 'admin', '14.2003', '', NULL, ''),
(137, 0, '14.2004', NULL, 'Desa Pelemsengir', 'pelemsengir', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2004', '', NULL, ''),
(138, 0, '14.2005', NULL, 'Desa Kacangan', 'kacangan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2005', '', NULL, ''),
(139, 0, '14.2006', NULL, 'Desa Sonokulon', 'sonokulon', '827ccb0eea8a706c4c34a16891f84e7b', '1b13990cde5112a149b167c4eb2685da.jpg', 0, 'admin', '14.2006', '', NULL, ''),
(140, 0, '14.2007', NULL, 'Desa Kedungwungu', 'kedungwungu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2007', '', NULL, ''),
(141, 0, '14.2008', NULL, 'Desa Gunungan', 'gunungan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2008', '', NULL, ''),
(142, 0, '33.16.14.2009', NULL, 'Desa Kajengan', 'kajengan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2009', '', NULL, ''),
(143, 0, '14.2010', NULL, 'Desa Dringo', 'dringo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2010', '', NULL, ''),
(144, 0, '14.2011', NULL, 'Desa Cokrowati ', 'cokrowati ', '827ccb0eea8a706c4c34a16891f84e7b', 'b70bfc9f46cb370f6c7ef49af730d6fb.jpg', 0, 'admin', '14.2011', '', NULL, ''),
(145, 0, '14.2012', NULL, 'Desa Ketileng', 'ketileng', '5350d61a5402c9cdb23c47106de5a92f', '55d391114f36b19aef356a348561af29.jpeg', 0, 'admin', '14.2012', '', NULL, ''),
(146, 0, '14.2013', NULL, 'Desa Todanan', 'todanan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '', '', NULL, ''),
(147, 0, '14.2014', NULL, 'Desa Ngumbul', 'ngumbul', '827ccb0eea8a706c4c34a16891f84e7b', '6bde00aefe36e4e4d16572e49e35ec93.docx', 0, 'admin', '14.2014', '', NULL, ''),
(148, 0, '14.2015', NULL, 'Desa Wukirsari', 'wukirsari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2015', '', NULL, ''),
(149, 0, '14.2016', NULL, 'Desa Bicak', 'bicak', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2016', '', NULL, ''),
(150, 0, '14.2017', NULL, 'Desa Sendang', 'sendang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2017', '', NULL, ''),
(151, 0, '14.2018', NULL, 'Desa Karanganyar', 'karanganyar_todanan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2018', '', NULL, ''),
(152, 0, '14.2019', NULL, 'Desa  Dalangan', 'dalangan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2019', '', NULL, ''),
(153, 0, '14.2020', NULL, 'Desa Candi', 'candi', '827ccb0eea8a706c4c34a16891f84e7b', '995ea3a7f32128c87dbc0f94ba4f4d60.15', 0, 'admin', '14.2020', '', NULL, ''),
(154, 0, '14.2021', NULL, 'Desa Gondoriyo', 'gondoriyo', '827ccb0eea8a706c4c34a16891f84e7b', '0bf0b1d29ace7dbe010a956ecf672778.jpg', 0, 'admin', '14.2021', '', NULL, ''),
(155, 0, '14.2022', NULL, 'Desa Kembang', 'kembang_todanan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2022', '', NULL, ''),
(156, 0, '14.2023', NULL, 'Desa Bedingin', 'bedingin', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2023', '', NULL, ''),
(157, 0, '14.2024', NULL, 'Desa Ledok', 'ledok_todanan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '14.2024', '', NULL, ''),
(158, 0, '3316142507880004', NULL, 'BUDI SANTOSO', 'kedungbacin', '827ccb0eea8a706c4c34a16891f84e7b', '3b20a9264f573f33ffd47cba9b3e6ff5.jpg', 0, 'admin', '14.2025', '', NULL, ''),
(159, 0, '16.2018', NULL, 'Desa Kalinanas', 'kalinanas', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2018', '', NULL, ''),
(160, 0, '06.2001', NULL, 'Desa Temengeng', 'temengeng', '827ccb0eea8a706c4c34a16891f84e7b', '7a3dcd6784a47d105d57274f3e785bfa. Blora', 0, 'admin', '06.2001', '', NULL, ''),
(161, 0, '06.2002', NULL, 'Desa Sambongrejo', 'sambongrejo_sambong', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '06.2002', '', NULL, ''),
(162, 0, '06.2003', NULL, 'Desa Gadu', 'gadu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '06.2003', '', NULL, ''),
(163, 0, '06.2004', NULL, 'Desa Sambong', 'sambong', '827ccb0eea8a706c4c34a16891f84e7b', '68ea1376827fddc91b159f2314dad171.jpg', 0, 'admin', '06.2004', '', NULL, ''),
(164, 0, '06.2005', NULL, 'Desa Pojokwatu', 'pojokwatu', '827ccb0eea8a706c4c34a16891f84e7b', '57f21bf09d3b2acb78072914bc6ff8d3.jpeg', 0, 'admin', '06.2005', '', NULL, ''),
(165, 0, '3316065712840003', NULL, 'SRI UTAMI', 'gagakan', '827ccb0eea8a706c4c34a16891f84e7b', '7701da638efa2947668fe312a3a06a0c.jpg', 0, 'admin', '06.2006', '', NULL, ''),
(166, 0, '06.2007', NULL, 'Desa Biting', 'biting', '827ccb0eea8a706c4c34a16891f84e7b', 'c723511a54529017443a5fab45720f6b.docx', 0, 'admin', '06.2007', '', NULL, ''),
(167, 0, '06.2008', NULL, 'Desa Brabowan', 'brabowan', '827ccb0eea8a706c4c34a16891f84e7b', '04a07af1572d46d8d1f4837579ca2e95.jpg', 0, 'admin', '06.2008', '', NULL, ''),
(168, 0, '06.2009', NULL, 'Desa Ledok', 'ledok_sambong', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '06.2009', '', NULL, ''),
(169, 0, '06.2010', NULL, 'Desa Giyanti', 'giyanti', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '06.2010', '', NULL, ''),
(170, 0, '07.2001', NULL, 'Desa Nglobo', 'nglobo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '07.2001', '', NULL, ''),
(171, 0, '07.2002', NULL, 'Desa Cabak', 'cabak', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '07.2002', '', NULL, ''),
(172, 0, '07.2003', NULL, 'Desa Nglebur', 'nglebur', '827ccb0eea8a706c4c34a16891f84e7b', '4c9033015f22d776bb5ac1d47aab6437.jpg', 0, 'admin', '07.2003', '', NULL, ''),
(173, 0, '07.2004', NULL, 'Desa Janjang Kecamatan Jiken Kabupaten Blora', 'janjang', '827ccb0eea8a706c4c34a16891f84e7b', '7cb833a10fa58312b993d660c6e3a2fb.jpeg', 0, 'admin', '07.2004', '', NULL, ''),
(174, 0, '07.2005', NULL, 'Desa Bleboh', 'bleboh', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '07.2005', '', NULL, ''),
(175, 0, '07.2006', NULL, 'Desa Ketringan', 'ketringan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '07.2006', '', NULL, ''),
(176, 0, '07.2007', NULL, 'Desa Singonegoro', 'singonegoro', '827ccb0eea8a706c4c34a16891f84e7b', 'dee0f838bc48fe7258e06feab0d052ce. Lurah', 0, 'admin', '07.2007', '', NULL, ''),
(177, 0, '07.2008', NULL, 'Desa Jiken', 'jiken', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '07.2008', '', NULL, ''),
(178, 0, '07.2009', NULL, 'Desa Genjahan', 'genjahan', '827ccb0eea8a706c4c34a16891f84e7b', '5f629453822f6d5284028671f7a71094.18', 0, 'admin', '07.2009', '', NULL, ''),
(179, 0, '07.2010', NULL, 'Desa Jiworejo', 'Jiworejo', '827ccb0eea8a706c4c34a16891f84e7b', '98db31b80cf3daa3e812f504a00a0af4.jpg', 0, 'admin', '07.2010', '', NULL, ''),
(180, 0, '07.2011', NULL, 'Desa Bangowan', 'bangowan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 1, 'admin', '', '', NULL, ''),
(181, 0, '3316161412800001', NULL, 'Heru Dwi Purnomo', 'blungun', '827ccb0eea8a706c4c34a16891f84e7b', '81bf31815e943f7fe8b7c72983adc274.jpg', 0, 'admin', '08.2001', '', NULL, ''),
(182, 0, '08.2002', NULL, 'Desa Semanggi', 'semanggi', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2002', '', NULL, ''),
(183, 0, '08.2003', NULL, 'Desa Ngampon', 'ngampon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2003', '', NULL, ''),
(184, 0, '08.2004', NULL, 'Desa Jomblang', 'jomblang', '827ccb0eea8a706c4c34a16891f84e7b', '1833ae9d29deef5cfb3162905b2874a1.30', 0, 'admin', '08.2004', '', NULL, ''),
(185, 0, '08.2005', NULL, 'Desa Palon', 'palon', '827ccb0eea8a706c4c34a16891f84e7b', '48d56e343e01146bb53eae3cda9e9b44.jfif', 0, 'admin', '08.2005', '', NULL, ''),
(186, 0, '08.2006', NULL, 'Desa Bangsri ', 'bangsri ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2006', '', NULL, ''),
(187, 0, '08.2007', NULL, 'Desa Sumurboto', 'sumurboto', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2007', '', NULL, ''),
(188, 0, '08.2008', NULL, 'Desa Brumbung', 'brumbung', '827ccb0eea8a706c4c34a16891f84e7b', '5bff059b57cdf9f66b154c6154f28f05.png', 0, 'admin', '08.2008', '', NULL, ''),
(189, 0, '08.2009', NULL, 'Desa Turirejo', 'turirejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2009', '', NULL, ''),
(190, 0, '08.2010', NULL, 'Desa Semampir ', 'semampir ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2010', '', NULL, ''),
(191, 0, '08.2011', NULL, 'Desa Kemiri', 'kemiri_jepon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2011', '', NULL, ''),
(192, 0, '08.2012', NULL, 'Desa Tempellemahbang ', 'tempellemahbang ', '20ff8fda67ddc95d61d0d6071900537d', '33d6910677dc3d93d157378ffb8dc1be.31', 0, 'admin', '08.2012', '', NULL, ''),
(193, 0, '08.2013', NULL, 'Desa Seso', 'seso', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2014', '', NULL, ''),
(194, 0, '08.2014', NULL, 'Desa Seso', 'seso', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 1, 'admin', '', '', NULL, ''),
(195, 0, '08.2015', NULL, 'Desa Balong ', 'balong_jepon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 1, 'admin', '', '', NULL, ''),
(196, 0, '08.2014', NULL, 'Desa Balong', 'balong_jepon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2015', '', NULL, ''),
(197, 0, '08.2015', NULL, 'Desa Geneng', 'geneng', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2016', '', NULL, ''),
(198, 0, '08.2016', NULL, 'Desa Nglarohgunung', 'nglarohgunung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2017', '', NULL, ''),
(199, 0, '08.2017', NULL, 'Desa Kawengan', 'kawengan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2018', '', NULL, ''),
(200, 0, '08.2018', NULL, 'Desa Gersi', 'gersi', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2019', '', NULL, ''),
(201, 0, '3316082502900002', NULL, 'IRVAN DWI SANTIKO', 'gedangdowo', '2b1a381ee1532974601b40c686490ca1', '5192005d9a84c4cae9a2b0001a9898c8.png', 0, 'admin', '08.2020', '', NULL, ''),
(202, 0, '08.2020', NULL, 'Desa Puledagel', 'puledagel', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2021', '', NULL, ''),
(203, 0, '08.2021', NULL, 'Desa Bacem ', 'bacem_jepon', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2022', '', NULL, ''),
(204, 0, '08.2022', NULL, 'Desa Jatirejo', 'jatirejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2023', '', NULL, ''),
(205, 0, '08.2023', NULL, 'Desa Soko', 'soko', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2024', '', NULL, ''),
(206, 0, '08.2024', NULL, 'Desa Waru', 'waru', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '08.2025', '', NULL, ''),
(207, 0, '09.2001', NULL, 'Desa Jepangrejo', 'jepangrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2001', '', NULL, ''),
(208, 0, '09.2002', NULL, 'Desa Kamolan', 'kamolan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2002', '', NULL, ''),
(209, 0, '09.2003', NULL, 'Desa Pelem ', 'pelem_blora ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2003', '', NULL, ''),
(210, 0, '09.2004', NULL, 'Desa Purworejo ', 'purworejo ', '827ccb0eea8a706c4c34a16891f84e7b', '9c76b983cb60a2f4ea1e62703c7b8b8d.png', 0, 'admin', '09.2004', '', NULL, ''),
(211, 0, '09.2005', NULL, 'Desa Andongrejo ', 'andongrejo ', '827ccb0eea8a706c4c34a16891f84e7b', 'd6dd08776bbc882c139b60e0402a84dc.jpeg', 0, 'admin', '09.2005', '', NULL, ''),
(212, 0, '09.2006', NULL, 'Desa Jejeruk ', 'jejeruk ', '4017339a36140381a72ee3e4127d354f', '85d6a13c21a77e4c91476a4ef0340364.20', 0, 'admin', '09.2007', '', NULL, ''),
(213, 0, '09.2007', NULL, 'Desa Temurejo', 'temurejo', 'cd2278c362ed0cb85d5fcc0704f5327b', 'ccccd8741a4aa814fc370b4eb5f5b276.24', 0, 'admin', '09.2019', '', NULL, ''),
(214, 0, '09.2008', NULL, 'Desa Tempurejo', 'tempurejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2020', '', NULL, ''),
(215, 0, '09.2009', NULL, 'Desa Patalan', 'patalan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2021', '', NULL, ''),
(216, 0, '09.2010', NULL, 'Desa Tambaksari', 'tambaksari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2022', '', NULL, ''),
(217, 0, '09.2011', NULL, 'Desa Purwosari', 'purwosari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2023', '', NULL, ''),
(218, 0, '09.2012', NULL, 'Desa Ngadipurwo ', 'ngadipurwo ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2024', '', NULL, ''),
(219, 0, '09.2013', NULL, 'Desa Sendangharjo', 'sendangharjo', '827ccb0eea8a706c4c34a16891f84e7b', '739868ec69c6b5fa773f2166fd189e76.jpeg', 0, 'admin', '09.2025', '', NULL, ''),
(220, 0, '09.2014', NULL, 'Desa Tempuran', 'tempuran', '432f45b44c432414d2f97df0e5743818', '4348cf24928be296dbb25872f53cb914.jpg', 0, 'admin', '09.2026', '', NULL, ''),
(221, 0, '09.2015', NULL, 'Desa Plantungan ', 'plantungan ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2027', '', NULL, ''),
(222, 0, '09.2016', NULL, 'Desa Ngampel', 'ngampel', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '09.2028', '', NULL, ''),
(223, 0, '10.2001', NULL, 'Desa Tawangrejo', 'tawangrejo_kunduran', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2001', '', NULL, ''),
(224, 0, '10.2002', NULL, 'Desa Kedungringin', 'kedungringin', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2002', '', NULL, ''),
(225, 0, '10.2003', NULL, 'Desa Adirejo', 'adirejo', '827ccb0eea8a706c4c34a16891f84e7b', 'a2f58149ce51518540bca7fc553075be.jpg', 0, 'admin', '10.2003', '', NULL, ''),
(226, 0, '10.2004', NULL, 'Desa Tamanrejo', 'tamanrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2004', '', NULL, ''),
(227, 0, '10.2005', NULL, 'Desa Tutup', 'tutup', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2005', '', NULL, ''),
(228, 0, '10.2006', NULL, 'Desa Sukorejo', 'sukorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2006', '', NULL, ''),
(229, 0, '10.2007', NULL, 'Desa Tambahrejo', 'tambahrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2007', '', NULL, ''),
(230, 0, '10.2008', NULL, 'Desa Kalangan', 'kalangan', '827ccb0eea8a706c4c34a16891f84e7b', '254427df83e8313337d450c0b14cafc2.jpg', 0, 'admin', '10.2008', '', NULL, ''),
(231, 0, '10.2009', NULL, 'Desa Sambongrejo', 'sambongrejo_tunjungan', '827ccb0eea8a706c4c34a16891f84e7b', '6841746a433f611076825877bfc7ec80.jpg', 0, 'admin', '10.2009', '', NULL, ''),
(232, 0, '10.2010', NULL, 'Desa Tunjungan', 'tunjungan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2010', '', NULL, ''),
(233, 0, '10.2011', NULL, 'Desa Kedungrejo', 'kedungrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2011', '', NULL, ''),
(234, 0, '10.2012', NULL, 'Desa Gempolrejo ', 'gempolrejo ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2012', '', NULL, ''),
(235, 0, '10.2013', NULL, 'Desa Nglangitan', 'nglangitan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2013', '', NULL, ''),
(236, 0, '10.2014', NULL, 'Desa Keser ', 'bella_berliza', 'fdc079ec59651ffdb159a3e9d52e674a', '8e04755d47a2cdd7acba2b7da3598cc5.jpg', 0, 'admin', '10.2014', '', NULL, ''),
(237, 0, '10.2015', NULL, 'Desa Sitirejo', 'sitirejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '10.2015', '', NULL, ''),
(238, 0, '15.2001', NULL, 'Desa Gombang', 'gombang', '827ccb0eea8a706c4c34a16891f84e7b', '217c1c45beed9e39690519f1344074b3.jpg', 0, 'admin', '15.2007', '', NULL, ''),
(239, 0, '15.2002', NULL, 'Desa Sarirejo', 'sarirejo', 'c91c2e800b1e7532413a3987d5070228', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '15.2002', '', NULL, ''),
(240, 0, '15.2003', NULL, 'Desa Karanganyar', 'karanganyar_bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2003', '', NULL, ''),
(241, 0, '15.2004', NULL, 'Desa Karang', 'karang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2004', '', NULL, ''),
(242, 0, '15.2005', NULL, 'Desa Prantaan', 'prantaan', '827ccb0eea8a706c4c34a16891f84e7b', '363956d290d7800bf77529b725ec2616.jpg', 0, 'admin', '15.2005', 'prantaan', NULL, ''),
(243, 0, '15.2006', NULL, 'Desa Jeruk', 'jeruk_bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2006', '', NULL, ''),
(244, 0, '15.2007', NULL, 'Desa Bogorejo', 'bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2001', '', NULL, ''),
(245, 0, '15.2008', NULL, 'Desa Gembol', 'gembol', '827ccb0eea8a706c4c34a16891f84e7b', 'cff1e1028ebd96d0cfe4b8f00a439a64.jpg', 0, 'admin', '15.2008', '', NULL, ''),
(246, 0, '15.2009', NULL, 'Desa Tempurejo', 'tempurejo_bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c250c2d884a273dde55dff284c2a65cc.jpg', 0, 'admin', '15.2009', '', NULL, ''),
(247, 0, '15.2010', NULL, 'Desa Gayam', 'gayam', '827ccb0eea8a706c4c34a16891f84e7b', '8c7d2bc3ea9daeea5c2fd371b9e26ac5.jpg', 0, 'admin', '15.2010', '', NULL, ''),
(248, 0, '15.2011', NULL, 'Desa Sendangrejo', 'sendangrejo_bogorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2011', '', NULL, ''),
(249, 0, '15.2012', NULL, 'Desa Gandu', 'gandu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2012', '', NULL, ''),
(250, 0, '15.2013', NULL, 'Desa Nglengkir', 'nglengkir', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2013', '', NULL, ''),
(251, 0, '15.2014', NULL, 'Desa Jurangjero', 'jurangjero', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '15.2014', '', NULL, ''),
(252, 0, '07.2011', NULL, 'Desa Bangowan', 'bangowan', '827ccb0eea8a706c4c34a16891f84e7b', '37393608ccbf56b8105116bf62cc7d9a.jpg', 0, 'admin', '07.2012', '', NULL, ''),
(253, 0, '04.2009', NULL, 'Desa Pulo', 'pulo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2009', '', NULL, ''),
(254, 0, '3316040806750002', NULL, 'SANUSI', 'tanjung', '827ccb0eea8a706c4c34a16891f84e7b', '9609060aa245364317b54ac5041d4702.jpg', 0, 'admin', '04.2010', '', NULL, ''),
(255, 0, '04.2011', NULL, 'Desa  Sogo', 'sogo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2011', '', NULL, ''),
(256, 0, '04.2012', NULL, 'Desa Bajo ', 'bajo ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2012', '', NULL, ''),
(257, 0, '04.2013', NULL, 'Desa Nglandeyan ', 'nglandeyan ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2013', '', NULL, ''),
(258, 0, '04.2014', NULL, 'Desa Kalen', 'kalen', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2014', '', NULL, ''),
(259, 0, '04.2015', NULL, 'Desa Ngraho', 'ngraho', '827ccb0eea8a706c4c34a16891f84e7b', '9ce8a405e35750c96fcba08e09a115f4.png', 0, 'admin', '04.2015', '', NULL, ''),
(260, 0, '04.2016', NULL, 'Desa Kedungtuban', 'kedungtuban', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '04.2016', '', NULL, ''),
(261, 0, '04.2017', NULL, 'Desa Galuk', 'galuk', '827ccb0eea8a706c4c34a16891f84e7b', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '04.2017', '', NULL, ''),
(262, 0, '05.2001', NULL, 'Desa Gadon', 'gadon', '827ccb0eea8a706c4c34a16891f84e7b', '9a469030d5b71ecf82a717b417b1edf4.jpg', 0, 'admin', '05.2001', '', NULL, ''),
(263, 0, '05.2002', NULL, 'Desa Ngloram ', 'ngloram ', '827ccb0eea8a706c4c34a16891f84e7b', 'bb6f3d72735c2bf66ed2686204e06c70.jpg', 0, 'admin', '05.2002', '', NULL, ''),
(264, 0, '05.2003', NULL, 'Desa Cabean', 'cabean', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '05.2003', '', NULL, ''),
(265, 0, '05.2004', NULL, 'Desa Kapuan', 'kapuan', '827ccb0eea8a706c4c34a16891f84e7b', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '05.2004', '', NULL, ''),
(266, 0, '05.2005', NULL, 'Desa Jipang ', 'jipang ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '05.2005', '', NULL, ''),
(267, 0, '05.2006', NULL, 'Desa Getas', 'getas_cepu', '827ccb0eea8a706c4c34a16891f84e7b', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '05.2006', '', NULL, ''),
(268, 0, '05.2007', NULL, 'Desa Sumberpitu', 'sumberpitu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '05.2007', '', NULL, ''),
(269, 0, '3316052802680001', NULL, 'MUNTAHAR', 'kentong', '827ccb0eea8a706c4c34a16891f84e7b', 'a9bc18b43bd133fc25e2ca4707a676e7.jpg', 0, 'admin', '05.2008', '', NULL, ''),
(270, 0, '05.2009', NULL, 'Desa Mernung', 'mernung', '827ccb0eea8a706c4c34a16891f84e7b', '5c872031bdbd9e01ba07430b0291e9c3.jpeg', 0, 'admin', '05.2009', '', NULL, ''),
(271, 0, '05.2010', NULL, 'Desa Mulyorejo', 'mulyorejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '05.2010', '', NULL, ''),
(272, 0, '05.2011', NULL, 'Desa Nglanjuk', 'nglanjuk', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '05.2012', '', NULL, ''),
(273, 0, '11.2001', NULL, 'Desa Jatisari', 'jatisari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2001', '', NULL, ''),
(274, 0, '11.2002', NULL, 'Desa Jatiklampok ', 'jatiklampok ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2002', '', NULL, ''),
(275, 0, '11.2003', NULL, 'Desa Klopoduwur', 'klopoduwur', 'b95f134811970b09e008c0c31fbc183b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2003', '', NULL, ''),
(276, 0, '11.2004', NULL, 'Desa Sidomulyo', 'sidomulyo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2004', '', NULL, ''),
(277, 0, '11.2005', NULL, 'Desa Balongsari', 'balongsari', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2005', '', NULL, ''),
(278, 0, '11.2006', NULL, 'Desa Bacem', 'bacem_banjarejo', '827ccb0eea8a706c4c34a16891f84e7b', '05307ddf82d0fe17ec9453a4845501a1.jpg', 0, 'admin', '11.2006', '', NULL, ''),
(279, 0, '11.2007', NULL, 'Desa Wonosemi', 'wonosemi', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2007', '', NULL, ''),
(280, 0, '11.2008', NULL, 'Desa Sendanggayam', 'sendanggayam', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2008', '', NULL, ''),
(281, 0, '11.2009', NULL, 'Desa Banjarejo', 'banjarejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2009', '', NULL, ''),
(282, 0, '11.2010', NULL, 'Desa Mojowetan', 'mojowetan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2010', '', NULL, ''),
(283, 0, '11.2011', NULL, 'Desa Sumberagung', 'sumberagung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2011', '', NULL, ''),
(284, 0, '11.2012', NULL, 'Desa Gedongsari ', 'gedongsari ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2012', '', NULL, ''),
(285, 0, '11.2013', NULL, 'Desa Sendangwungu', 'sendangwungu', '827ccb0eea8a706c4c34a16891f84e7b', 'cf0e56c9944de27eb70b2b263ceac3e1.jpg', 0, 'admin', '11.2013', '', NULL, ''),
(286, 0, '11.2014', NULL, 'Desa Balongrejo', 'balongrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2014', '', NULL, ''),
(287, 0, '11.2015', NULL, 'Desa Karangtalun', 'karangtalun', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2015', '', NULL, ''),
(288, 0, '11.2016', NULL, 'Desa Kebonrejo', 'kebonrejo', '827ccb0eea8a706c4c34a16891f84e7b', '7de849e4bad405e96367ee534726c9a1.jpg', 0, 'admin', '11.2016', '', NULL, ''),
(289, 0, '11.2017', NULL, 'Desa Kembang', 'kembang_banjarejo', '827ccb0eea8a706c4c34a16891f84e7b', 'b5bb2b16f9461d87ec7a92316090878f.13', 0, 'admin', '11.2017', '', NULL, ''),
(290, 0, '3316110401890001', NULL, 'Desa Sembongin', 'sembongin', '827ccb0eea8a706c4c34a16891f84e7b', '4fc926c3e237f125e48ec9be39990129.jpg', 0, 'admin', '11.2018', '', NULL, ''),
(291, 0, '11.2019', NULL, 'Desa Plosorejo', 'plosorejo_banjarejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2019', '', NULL, ''),
(292, 0, '11.2020', NULL, 'Desa Buluroto', 'buluroto', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '11.2020', '', NULL, ''),
(293, 0, '12.2001', NULL, 'Desa Rowobungkul ', 'rowobungkul ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2001', '', NULL, ''),
(294, 0, '12.2002', NULL, 'Desa Gedebeg', 'gedebeg', '827ccb0eea8a706c4c34a16891f84e7b', 'f85cbc511670a70ef40636502a6c73ae.jpg', 0, 'admin', '12.2002', '', NULL, ''),
(295, 0, '12.2003', NULL, 'Desa Sambonganyar', 'sambonganyar', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2003', '', NULL, ''),
(296, 0, '12.2004', NULL, 'Desa Kendayaan', 'kendayaan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2004', '', NULL, ''),
(297, 0, '12.2005', NULL, 'Desa Plumbon', 'plumbon ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2005', '', NULL, ''),
(298, 0, '12.2006', NULL, 'Desa Bergolo', 'bergolo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2006', '', NULL, ''),
(299, 0, '12.2007', NULL, 'Desa Bandungrojo', 'bandungrojo', '827ccb0eea8a706c4c34a16891f84e7b', 'a3c52b3a1100784d1852794972bb73e9.JPG', 0, 'admin', '12.2007', '', NULL, ''),
(300, 0, '12.2008', NULL, 'Desa Kedungsatriyan', 'kedungsatriyan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2008', '', NULL, ''),
(301, 0, '12.2009', NULL, 'Desa Karangtengah', 'karangtengah', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2009', '', NULL, ''),
(302, 0, '12.2010', NULL, 'Desa Jetakwanger', 'jetakwanger', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2010', '', NULL, ''),
(303, 0, '12.2011', NULL, 'Desa Sumberejo', 'sumberejo_ngawen', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2011', '', NULL, ''),
(304, 0, '12.2012', NULL, 'Desa Sendangagung', 'sendangagung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2012', '', NULL, ''),
(305, 0, '12.2013', NULL, 'Desa Talokwohmojo ', 'talokwohmojo ', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2013', '', NULL, ''),
(306, 0, '12.2014', NULL, 'Desa Trembulrejo', 'trembulrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2014', '', NULL, ''),
(307, 0, '12.2015', NULL, 'Desa Gondang', 'gondang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2016', '', NULL, ''),
(308, 0, '12.2016', NULL, 'Desa Gondang', 'gondang', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 1, 'admin', '12.2016', '', NULL, ''),
(309, 0, '12.2016', NULL, 'Desa Sendangrejo', 'sendangrejo_ngawen', '827ccb0eea8a706c4c34a16891f84e7b', 'a16a03f560ac856cfe4b15d6302fbd2c.docx', 0, 'admin', '12.2017', '', NULL, ''),
(310, 0, '12.2019', NULL, 'Desa Semawur', 'semawur', '827ccb0eea8a706c4c34a16891f84e7b', '6bfaad8b7055a49e16e20f0bc61d932c.jpg', 0, 'admin', '12.2019', '', NULL, ''),
(311, 0, '3316120904960002', NULL, 'AHMAD KHUSRIN', 'bradag', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2020', '', NULL, ''),
(312, 0, '12.2019', NULL, 'Desa Gotputuk', 'gotputuk', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2021', '', NULL, ''),
(313, 0, '12.2020', NULL, 'Desa Berbak', 'berbak', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2022', '', NULL, ''),
(314, 0, '12.2021', NULL, 'Desa Sarimulyo', 'sarimulyo', '827ccb0eea8a706c4c34a16891f84e7b', '4d44dc2c9c688ecebaf730d70e394327.png', 0, 'admin', '12.2023', '', NULL, ''),
(315, 0, '12.2022', NULL, 'Desa Sendangmulyo', 'sendangmulyo', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2024', '', NULL, ''),
(316, 0, '12.2023', NULL, 'Desa Wantilgung', 'wantilgung', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2025', '', NULL, ''),
(317, 0, '3316120306960002', NULL, 'AHMAD SUPENDI', 'bogowanti', '827ccb0eea8a706c4c34a16891f84e7b', '1a2a6de97137f92f33d6e74d029d11f7.jpeg', 0, 'admin', '12.2026', '', NULL, '');
INSERT INTO `tb_users` (`id`, `id_pegawai`, `nip`, `nik`, `nama_pegawai`, `username`, `password`, `profile_image`, `deleted`, `status_user`, `id_desa`, `passphrase`, `jabatan`, `status_perwakilan_tte`) VALUES
(318, 0, '12.2025', NULL, 'Desa Sambongrejo ', 'sambongrejo_ngawen', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '12.2027', '', NULL, ''),
(319, 0, '12.2026', NULL, 'Desa Srigading', 'srigading', '827ccb0eea8a706c4c34a16891f84e7b', '7ae8bf4c46d6a93c073fb91dde3e5c2d.jpg', 0, 'admin', '12.2028', '', NULL, ''),
(320, 0, '12.2027', NULL, 'Desa Karangjong', 'karangjong', '827ccb0eea8a706c4c34a16891f84e7b', 'cafa9f7eaa8da92bc42ac6ebbb3da576.jpeg', 0, 'admin', '12.2029', '', NULL, ''),
(321, 0, '16.2001', NULL, 'Desa Harjowinangun', 'harjowinangun', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2001', '', NULL, ''),
(322, 0, '16.2002', NULL, 'Desa Tengger', 'tengger', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2002', '', NULL, ''),
(323, 0, '3316161404960001', NULL, 'Arief WIBOWO', 'krocok', '827ccb0eea8a706c4c34a16891f84e7b', 'fe6f189b89db708fe874e03f5f3964d0.jpeg', 0, 'admin', '16.2003', '', NULL, ''),
(324, 0, '16.2004', NULL, 'Desa Ngapus', 'ngapus', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2004', '', NULL, ''),
(325, 0, '16.2005', NULL, 'Dologan', 'dologan', '827ccb0eea8a706c4c34a16891f84e7b', '2bc8e81116c30f056d0040f6f18a439c.jpeg', 0, 'admin', '16.2005', '', NULL, ''),
(326, 0, '16.2006', NULL, 'Desa Tlogowungu', 'tlogowungu', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2006', '', NULL, ''),
(327, 0, '16.2007', NULL, 'Desa Japah', 'japah', '171d8479bbd4ce2e222203ecce92935b', 'b9fb9d37bdf15a699bc071ce49baea53.jpg', 0, 'admin', '16.2007', '', NULL, ''),
(328, 0, '16.2008', NULL, 'Desa Beganjing', 'beganjing', '827ccb0eea8a706c4c34a16891f84e7b', 'e11af8e8c55207a4d9e257187a12e4f4.jpg', 0, 'admin', '16.2008', '', NULL, ''),
(329, 0, '16.2009', NULL, 'Desa Ngrambitan', 'ngrambitan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2009', '', NULL, ''),
(330, 0, '16.2010', NULL, 'Desa Pengkolrejo', 'pengkolrejo', '827ccb0eea8a706c4c34a16891f84e7b', 'bf529414100c219b97d2b7ae47b592f5.jpg', 0, 'admin', '16.2010', '', NULL, ''),
(331, 0, '16.2011', NULL, 'Desa Bogorejo', 'bogorejo_japah', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2011', '', NULL, ''),
(332, 0, '16.2012', NULL, 'Desa Wotbakah', 'wotbakah', '827ccb0eea8a706c4c34a16891f84e7b', '8d21b54000d93e116f0e2e5574291123.jpg', 0, 'admin', '16.2012', '', NULL, ''),
(333, 0, '16.2013', NULL, 'Desa Padaan', 'padaan', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2013', '', NULL, ''),
(334, 0, '16.2014', NULL, 'Desa Bogem', 'bogem', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2014', '', NULL, ''),
(335, 0, '3316160910880001', NULL, 'Sujito', 'sumberejo_japah', '827ccb0eea8a706c4c34a16891f84e7b', 'c26be60cfd1ba40772b5ac48b95ab19b.png', 0, 'admin', '16.2015', '', NULL, ''),
(336, 0, '16.2016', NULL, 'Desa Ngiyono', 'ngiyono', '827ccb0eea8a706c4c34a16891f84e7b', 'c986004dc567cd3e086c88ee017d3a17.jpg', 0, 'admin', '16.2016', '', NULL, ''),
(337, 0, '3316074406960003', NULL, 'AYUK IRAWATI', 'gaplokan', '827ccb0eea8a706c4c34a16891f84e7b', '8d542ce3d8b15e9f7f2caf8d70475500. Lurah_LI', 0, 'admin', '16.2017', 'gaplokan', NULL, ''),
(338, 0, '3316132907630001', NULL, 'syamsudin', 'cungkup', '827ccb0eea8a706c4c34a16891f84e7b', '', 0, 'admin', '10.2001', 'kunduran', NULL, 'Tidak'),
(340, 0, '2', NULL, '222', '2', 'c81e728d9d4c2f636f067f89cc14862c', '123', 1, 'dinas', '', '', NULL, ''),
(341, 0, '1', NULL, '1', '1', 'c4ca4238a0b923820dcc509a6f75849b', '123', 0, 'kecamatan', '', '', NULL, ''),
(342, 0, 'jati', NULL, 'jati', 'jati', 'c9507ca09facaf7bd5d9ab1937bbdeb2', '123', 0, 'kecamatan', '01', '', NULL, ''),
(343, 0, 'dinas', NULL, 'dinas', 'dinas', '097dad4a551e3cb88ed7afc7a6c0de40', '123', 0, 'dinas', '', '', NULL, ''),
(344, 0, '1', NULL, '1', '1', 'c4ca4238a0b923820dcc509a6f75849b', '123', 0, 'admin', '', '', NULL, ''),
(345, 0, 'tte', 'tte', 'tte', 'tte', '0e3efaaad6de051028e5e4dda3e7927d', '123', 0, 'TTE', '', '', 'tte', '');

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

--
-- Struktur dari tabel `tb_user_ormas`
--

CREATE TABLE `tb_user_ormas` (
  `id_user_ormas` int(11) NOT NULL,
  `nama_organisasi` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `id_ormas` int(11) NOT NULL DEFAULT 0,
  `deleted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `tb_user_ormas`
--

INSERT INTO `tb_user_ormas` (`id_user_ormas`, `nama_organisasi`, `username`, `email`, `password`, `id_ormas`, `deleted`) VALUES
(1, '34', '34', NULL, 'e369853df766fa44e1ed0ff613f563bd', 1, 0),
(2, NULL, NULL, NULL, 'd41d8cd98f00b204e9800998ecf8427e', 0, 0),
(3, NULL, NULL, NULL, 'd41d8cd98f00b204e9800998ecf8427e', 0, 0),
(4, NULL, NULL, NULL, 'd41d8cd98f00b204e9800998ecf8427e', 0, 0),
(5, NULL, NULL, NULL, 'd41d8cd98f00b204e9800998ecf8427e', 0, 0),
(6, '90', '0', NULL, '8613985ec49eb8f757ae6439e879bb2a', 1, 0),
(7, '-', '0000', NULL, '4a7d1ed414474e4033ac29ccb8653d9b', 1, 1);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `keys`
--
ALTER TABLE `keys`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `limits`
--
ALTER TABLE `limits`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ref_desa`
--
ALTER TABLE `ref_desa`
  ADD PRIMARY KEY (`Kd_Desa`);

--
-- Indeks untuk tabel `ref_kecamatan`
--
ALTER TABLE `ref_kecamatan`
  ADD PRIMARY KEY (`Kd_Kec`);

--
-- Indeks untuk tabel `tb_alasan_penolakan`
--
ALTER TABLE `tb_alasan_penolakan`
  ADD PRIMARY KEY (`id_alasan`);

--
-- Indeks untuk tabel `tb_bidang_ormas`
--
ALTER TABLE `tb_bidang_ormas`
  ADD PRIMARY KEY (`id_bidang`);

--
-- Indeks untuk tabel `tb_jabatan_kepengurusan`
--
ALTER TABLE `tb_jabatan_kepengurusan`
  ADD PRIMARY KEY (`id_jabatan`);

--
-- Indeks untuk tabel `tb_kategori_bantuan`
--
ALTER TABLE `tb_kategori_bantuan`
  ADD PRIMARY KEY (`id_kategori_bantuan`);

--
-- Indeks untuk tabel `tb_kategori_ormas`
--
ALTER TABLE `tb_kategori_ormas`
  ADD PRIMARY KEY (`id_kategori`);

--
-- Indeks untuk tabel `tb_master_agama`
--
ALTER TABLE `tb_master_agama`
  ADD PRIMARY KEY (`id_agama`);

--
-- Indeks untuk tabel `tb_master_dukuh`
--
ALTER TABLE `tb_master_dukuh`
  ADD PRIMARY KEY (`id_dukuh`);

--
-- Indeks untuk tabel `tb_ormas`
--
ALTER TABLE `tb_ormas`
  ADD PRIMARY KEY (`id_ormas`),
  ADD KEY `id_so` (`id_ormas`);

--
-- Indeks untuk tabel `tb_ormas_bantuan`
--
ALTER TABLE `tb_ormas_bantuan`
  ADD PRIMARY KEY (`id_bantuan`);

--
-- Indeks untuk tabel `tb_ormas_bidang`
--
ALTER TABLE `tb_ormas_bidang`
  ADD PRIMARY KEY (`id_ormas_bidang`);

--
-- Indeks untuk tabel `tb_ormas_kegiatan`
--
ALTER TABLE `tb_ormas_kegiatan`
  ADD PRIMARY KEY (`id_kegiatan`);

--
-- Indeks untuk tabel `tb_ormas_pengurus`
--
ALTER TABLE `tb_ormas_pengurus`
  ADD PRIMARY KEY (`id_ormas_pengurus`);

--
-- Indeks untuk tabel `tb_users`
--
ALTER TABLE `tb_users`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `tb_user_ormas`
--
ALTER TABLE `tb_user_ormas`
  ADD PRIMARY KEY (`id_user_ormas`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `keys`
--
ALTER TABLE `keys`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `limits`
--
ALTER TABLE `limits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `tb_alasan_penolakan`
--
ALTER TABLE `tb_alasan_penolakan`
  MODIFY `id_alasan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_bidang_ormas`
--
ALTER TABLE `tb_bidang_ormas`
  MODIFY `id_bidang` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `tb_jabatan_kepengurusan`
--
ALTER TABLE `tb_jabatan_kepengurusan`
  MODIFY `id_jabatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `tb_kategori_bantuan`
--
ALTER TABLE `tb_kategori_bantuan`
  MODIFY `id_kategori_bantuan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `tb_kategori_ormas`
--
ALTER TABLE `tb_kategori_ormas`
  MODIFY `id_kategori` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `tb_master_agama`
--
ALTER TABLE `tb_master_agama`
  MODIFY `id_agama` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `tb_master_dukuh`
--
ALTER TABLE `tb_master_dukuh`
  MODIFY `id_dukuh` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=529;

--
-- AUTO_INCREMENT untuk tabel `tb_ormas`
--
ALTER TABLE `tb_ormas`
  MODIFY `id_ormas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_ormas_bantuan`
--
ALTER TABLE `tb_ormas_bantuan`
  MODIFY `id_bantuan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_ormas_bidang`
--
ALTER TABLE `tb_ormas_bidang`
  MODIFY `id_ormas_bidang` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `tb_ormas_kegiatan`
--
ALTER TABLE `tb_ormas_kegiatan`
  MODIFY `id_kegiatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_ormas_pengurus`
--
ALTER TABLE `tb_ormas_pengurus`
  MODIFY `id_ormas_pengurus` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `tb_users`
--
ALTER TABLE `tb_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=346;

--
-- AUTO_INCREMENT untuk tabel `tb_user_ormas`
--
ALTER TABLE `tb_user_ormas`
  MODIFY `id_user_ormas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

