-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `u487639776_karsis`
--

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

--
-- Table structure for table `blangko`
--

CREATE TABLE `blangko` (
  `id` int(11) NOT NULL,
  `gambar` varchar(225) NOT NULL,
  `ttd` varchar(225) NOT NULL,
  `kepsek` varchar(225) NOT NULL,
  `nip` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blangko`
--

INSERT INTO `blangko` (`id`, `gambar`, `ttd`, `kepsek`, `nip`) VALUES
(1, 'balangko.png', 'ttd.png', 'Andi Saputro, S.Kom.', '198211132011011005');

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

--
-- Table structure for table `kabupaten`
--

CREATE TABLE `kabupaten` (
  `id_kab` char(25) NOT NULL,
  `id_prov` char(2) NOT NULL,
  `nama_kabupaten` tinytext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kabupaten`
--

INSERT INTO `kabupaten` (`id_kab`, `id_prov`, `nama_kabupaten`) VALUES
('11.01', '11', 'Aceh Selatan'),
('11.02', '11', 'Aceh Tenggara'),
('11.03', '11', 'Aceh Timur'),
('11.04', '11', 'Aceh Tengah'),
('11.05', '11', 'Aceh Barat'),
('11.06', '11', 'Aceh Besar'),
('11.07', '11', 'Pidie'),
('11.08', '11', 'Aceh Utara'),
('11.09', '11', 'Simeulue'),
('11.10', '11', 'Aceh Singkil'),
('11.11', '11', 'Bireuen'),
('11.12', '11', 'Aceh Barat Daya'),
('11.13', '11', 'Gayo Lues'),
('11.14', '11', 'Aceh Jaya'),
('11.15', '11', 'Nagan Raya'),
('11.16', '11', 'Aceh Tamiang'),
('11.17', '11', 'Bener Meriah'),
('11.18', '11', 'Pidie Jaya'),
('11.71', '11', 'Banda Aceh'),
('11.72', '11', 'Sabang'),
('11.73', '11', 'Lhokseumawe'),
('11.74', '11', 'Langsa'),
('11.75', '11', 'Subulussalam'),
('33.01', '33', 'Cilacap'),
('33.02', '33', 'Banyumas'),
('33.03', '33', 'Purbalingga'),
('33.04', '33', 'Banjarnegara'),
('33.05', '33', 'Kebumen'),
('33.06', '33', 'Purworejo'),
('33.07', '33', 'Wonosobo'),
('33.08', '33', 'Magelang'),
('33.09', '33', 'Boyolali'),
('33.10', '33', 'Klaten'),
('33.11', '33', 'Sukoharjo'),
('33.12', '33', 'Wonogiri'),
('33.13', '33', 'Karanganyar'),
('33.14', '33', 'Sragen'),
('33.15', '33', 'Grobogan'),
('33.16', '33', 'Blora'),
('33.17', '33', 'Rembang'),
('33.18', '33', 'Pati'),
('33.19', '33', 'Kudus'),
('33.20', '33', 'Jepara'),
('33.21', '33', 'Demak'),
('33.22', '33', 'Semarang'),
('33.23', '33', 'Temanggung'),
('33.24', '33', 'Kendal'),
('33.25', '33', 'Batang'),
('33.26', '33', 'Pekalongan'),
('33.27', '33', 'Pemalang'),
('33.28', '33', 'Tegal'),
('33.29', '33', 'Brebes'),
('33.71', '33', 'Kota Magelang'),
('33.72', '33', 'Kota Surakarta'),
('33.73', '33', 'Kota Salatiga'),
('33.74', '33', 'Kota Semarang'),
('33.75', '33', 'Pekalongan'),
('33.76', '33', 'Kota Tegal');

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

--
-- Table structure for table `kecamatan`
--

CREATE TABLE `kecamatan` (
  `id_kec` char(30) NOT NULL,
  `id_kab` char(15) NOT NULL,
  `nama_kecamatan` tinytext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kecamatan`
--

INSERT INTO `kecamatan` (`id_kec`, `id_kab`, `nama_kecamatan`) VALUES
('33.25.01', '33.25', 'Wonotunggal'),
('33.25.02', '33.25', 'Bandar'),
('33.25.03', '33.25', 'Blado'),
('33.25.04', '33.25', 'Reban'),
('33.25.05', '33.25', 'Bawang'),
('33.25.06', '33.25', 'Tersono'),
('33.25.07', '33.25', 'Gringsing'),
('33.25.08', '33.25', 'Limpung'),
('33.25.09', '33.25', 'Subah'),
('33.25.10', '33.25', 'Tulis'),
('33.25.11', '33.25', 'Batang'),
('33.25.12', '33.25', 'Warungasem'),
('33.25.13', '33.25', 'Kandeman'),
('33.25.14', '33.25', 'Pecalungan');

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

--
-- Table structure for table `kelurahan`
--

CREATE TABLE `kelurahan` (
  `id_kel` char(50) NOT NULL,
  `id_kec` char(70) DEFAULT NULL,
  `nama_kelurahan` tinytext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kelurahan`
--

INSERT INTO `kelurahan` (`id_kel`, `id_kec`, `nama_kelurahan`) VALUES
('33.25.02.2001', '33.25.02', 'Tombo'),
('33.25.02.2002', '33.25.02', 'Wonomerto'),
('33.25.02.2003', '33.25.02', 'Wonodadi'),
('33.25.02.2004', '33.25.02', 'Pesalakan'),
('33.25.02.2005', '33.25.02', 'Binangun'),
('33.25.02.2006', '33.25.02', 'Sidayu'),
('33.25.02.2007', '33.25.02', 'Toso'),
('33.25.02.2010', '33.25.02', 'Kluwih'),
('33.25.02.2011', '33.25.02', 'Wonokerto'),
('33.25.02.2012', '33.25.02', 'Bandar'),
('33.25.02.2013', '33.25.02', 'Tumbrep'),
('33.25.02.2014', '33.25.02', 'Tambahrejo'),
('33.25.02.2015', '33.25.02', 'Pucanggading'),
('33.25.02.2016', '33.25.02', 'Candi'),
('33.25.02.2018', '33.25.02', 'Wonosegoro'),
('33.25.02.2019', '33.25.02', 'Simpar'),
('33.25.02.2020', '33.25.02', 'Batiombo'),
('33.25.03.2001', '33.25.03', 'Gerlang'),
('33.25.03.2002', '33.25.03', 'Kalitengah'),
('33.25.03.2003', '33.25.03', 'Kembanglangit'),
('33.25.03.2004', '33.25.03', 'Gondang'),
('33.25.03.2005', '33.25.03', 'Bismo'),
('33.25.03.2006', '33.25.03', 'Keteleng'),
('33.25.03.2007', '33.25.03', 'Kalisari'),
('33.25.03.2009', '33.25.03', 'Besani'),
('33.25.03.2010', '33.25.03', 'Wonobodro'),
('33.25.03.2011', '33.25.03', 'Bawang'),
('33.25.03.2012', '33.25.03', 'Pesantren'),
('33.25.03.2013', '33.25.03', 'Kambangan'),
('33.25.03.2014', '33.25.03', 'Keputon'),
('33.25.03.2015', '33.25.03', 'Blado'),
('33.25.03.2016', '33.25.03', 'Cokro'),
('33.25.03.2017', '33.25.03', 'Selopajang Barat'),
('33.25.03.2020', '33.25.03', 'Kalipancur'),
('33.25.03.2021', '33.25.03', 'Selopajang Timur'),
('33.25.04.2001', '33.25.04', 'Pacet'),
('33.25.04.2002', '33.25.04', 'Mojotengah'),
('33.25.04.2003', '33.25.04', 'Cablikan'),
('33.25.04.2004', '33.25.04', 'Ngroto'),
('33.25.04.2005', '33.25.04', 'Ngadirejo'),
('33.25.04.2006', '33.25.04', 'Reban'),
('33.25.04.2007', '33.25.04', 'Tambakboyo'),
('33.25.04.2008', '33.25.04', 'Adinuso'),
('33.25.04.2009', '33.25.04', 'Kumesu'),
('33.25.04.2010', '33.25.04', 'Kepudung'),
('33.25.04.2011', '33.25.04', 'Padomasan'),
('33.25.04.2012', '33.25.04', 'Semampir'),
('33.25.04.2013', '33.25.04', 'Wonosobo'),
('33.25.04.2014', '33.25.04', 'Sojomerto'),
('33.25.04.2015', '33.25.04', 'Karanganyar'),
('33.25.04.2016', '33.25.04', 'Polodoro'),
('33.25.04.2017', '33.25.04', 'Kalisari'),
('33.25.04.2018', '33.25.04', 'Sukomangli'),
('33.25.04.2019', '33.25.04', 'Wonorojo'),
('33.25.14.2001', '33.25.14', 'Pecalungan'),
('33.25.14.2002', '33.25.14', 'Bandung'),
('33.25.14.2003', '33.25.14', 'Gombong'),
('33.25.14.2004', '33.25.14', 'Randu'),
('33.25.14.2005', '33.25.14', 'Siguci'),
('33.25.14.2006', '33.25.14', 'Pretek'),
('33.25.14.2007', '33.25.14', 'Selokarto'),
('33.25.14.2008', '33.25.14', 'Gemuh'),
('33.25.14.2009', '33.25.14', 'Gumawang'),
('33.25.14.2010', '33.25.14', 'Keniten');

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

--
-- Table structure for table `level`
--

CREATE TABLE `level` (
  `id_level` varchar(2) NOT NULL,
  `level` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `level`
--

INSERT INTO `level` (`id_level`, `level`) VALUES
('1', 'Administrator'),
('2', 'Operator'),
('3', 'User');

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

--
-- Table structure for table `provinsi`
--

CREATE TABLE `provinsi` (
  `id_prov` char(2) NOT NULL,
  `nama_provinsi` tinytext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `provinsi`
--

INSERT INTO `provinsi` (`id_prov`, `nama_provinsi`) VALUES
('11', 'Aceh'),
('12', 'Sumatera Utara'),
('13', 'Sumatera Barat'),
('14', 'Riau'),
('15', 'Jambi'),
('16', 'Sumatera Selatan'),
('17', 'Bengkulu'),
('18', 'Lampung'),
('19', 'Bangka Belitung'),
('21', 'Kepulauan Riau'),
('31', 'DKI Jakarta'),
('32', 'Jawa Barat'),
('33', 'Jawa Tengah'),
('34', 'DI Yogyakarta'),
('35', 'Jawa Timur'),
('36', 'Banten'),
('51', 'Bali'),
('52', 'Nusa Tenggara Barat'),
('53', 'Nusa Tenggara Timur'),
('61', 'Kalimantan Barat'),
('62', 'Kalimantan Tengah'),
('63', 'Kalimantan Selatan'),
('64', 'Kalimantan Timur'),
('65', 'Kalimantan Utara'),
('71', 'Sulawesi Utara'),
('72', 'Sulawesi Tengah'),
('73', 'Sulawesi Selatan'),
('74', 'Sulawesi Tenggara'),
('75', 'Gorontalo'),
('76', 'Sulawesi Bara'),
('81', 'Maluku'),
('82', 'Maluku Utara'),
('91', 'Papua'),
('92', 'Papua Barat');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `kabupaten`
--
ALTER TABLE `kabupaten`
  ADD PRIMARY KEY (`id_kab`);

--
-- Indexes for table `kecamatan`
--
ALTER TABLE `kecamatan`
  ADD PRIMARY KEY (`id_kec`);

--
-- Indexes for table `kelurahan`
--
ALTER TABLE `kelurahan`
  ADD PRIMARY KEY (`id_kel`);

--
-- Indexes for table `level`
--
ALTER TABLE `level`
  ADD PRIMARY KEY (`id_level`);

--
-- Indexes for table `provinsi`
--
ALTER TABLE `provinsi`
  ADD PRIMARY KEY (`id_prov`);

--
-- AUTO_INCREMENT for dumped tables
--

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

