-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 07, 2021 at 11:18 PM
-- Server version: 10.5.8-MariaDB
-- PHP Version: 8.0.1

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `wilayah_bps_ori`
--

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

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

DROP TABLE IF EXISTS `provinsi`;
CREATE TABLE IF NOT EXISTS `provinsi` (
  `kode_provinsi` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_provinsi` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hc_key` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_negara` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '360',
  PRIMARY KEY (`kode_provinsi`),
  KEY `provinsi_nama_provinsi_index` (`nama_provinsi`),
  KEY `provinsi_hc_key_index` (`hc_key`),
  KEY `provinsi_kode_negara_index` (`kode_negara`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `provinsi` (`kode_provinsi`, `nama_provinsi`, `hc_key`, `kode_negara`) VALUES
('11', 'ACEH', 'id-ac', '360'),
('12', 'SUMATERA UTARA', 'id-su', '360'),
('13', 'SUMATERA BARAT', 'id-sb', '360'),
('14', 'RIAU', 'id-ri', '360'),
('15', 'JAMBI', 'id-ja', '360'),
('16', 'SUMATERA SELATAN', 'id-sl', '360'),
('17', 'BENGKULU', 'id-be', '360'),
('18', 'LAMPUNG', 'id-1024', '360'),
('19', 'BABEL', 'id-bb', '360'),
('21', 'KEPULAUAN RIAU', 'id-kr', '360'),
('31', 'DKI JAKARTA', 'id-jk', '360'),
('32', 'JAWA BARAT', 'id-jr', '360'),
('33', 'JAWA TENGAH', 'id-jt', '360'),
('34', 'DAERAH ISTIMEWA YOGYAKARTA', 'id-yo', '360'),
('35', 'JAWA TIMUR', 'id-ji', '360'),
('36', 'BANTEN', 'id-bt', '360'),
('51', 'BALI', 'id-ba', '360'),
('52', 'NUSA TENGGARA BARAT', 'id-nb', '360'),
('53', 'NUSA TENGGARA TIMUR', 'id-nt', '360'),
('61', 'KALIMANTAN BARAT', 'id-kb', '360'),
('62', 'KALIMANTAN TENGAH', 'id-kt', '360'),
('63', 'KALIMANTAN SELATAN', 'id-ks', '360'),
('64', 'KALIMANTAN TIMUR', 'id-ki', '360'),
('65', 'KALIMANTAN UTARA', 'id-ku', '360'),
('71', 'SULAWESI UTARA', 'id-sw', '360'),
('72', 'SULAWESI TENGAH', 'id-st', '360'),
('73', 'SULAWESI SELATAN', 'id-se', '360'),
('74', 'SULAWESI TENGGARA', 'id-sg', '360'),
('75', 'GORONTALO', 'id-go', '360'),
('76', 'SULAWESI BARAT', 'id-sr', '360'),
('81', 'MALUKU', 'id-ma', '360'),
('82', 'MALUKU UTARA', 'id-la', '360'),
('91', 'PAPUA BARAT', 'id-ib', '360'),
('94', 'PAPUA', 'id-pa', '360');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `provinsi`
--
ALTER TABLE `provinsi`
  ADD CONSTRAINT `provinsi_kode_negara_foreign` FOREIGN KEY (`kode_negara`) REFERENCES `negara` (`kode_negara`) ON DELETE CASCADE;
SET FOREIGN_KEY_CHECKS=1;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
