gistfile1.txt

-- Adminer 4.6.2 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `master_district`;
CREATE TABLE `master_district` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `flag` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `master_district` (`id`, `name`, `flag`) VALUES
(9101,	'KABUPATEN FAKFAK',	1),
(9102,	'KABUPATEN KAIMANA',	1),
(9103,	'KABUPATEN TELUK WONDAMA',	1),
(9104,	'KABUPATEN TELUK BINTUNI',	1),
(9105,	'KABUPATEN MANOKWARI',	1),
(9106,	'KABUPATEN SORONG SELATAN',	1),
(9107,	'KABUPATEN SORONG',	1),
(9108,	'KABUPATEN RAJA AMPAT',	1),
(9109,	'KABUPATEN TAMBRAUW',	1),
(9110,	'KABUPATEN MAYBRAT',	1),
(9111,	'KABUPATEN MANOKWARI SELATAN',	1),
(9112,	'KABUPATEN PEGUNUNGAN ARFAK',	1),
(9171,	'KOTA SORONG',	1);

DROP TABLE IF EXISTS `master_geomap`;
CREATE TABLE `master_geomap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `master_district_id` int(11) NOT NULL,
  `master_subdistrict_id` int(11) DEFAULT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `master_district_id` (`master_district_id`),
  KEY `master_subdistrict_id` (`master_subdistrict_id`),
  CONSTRAINT `master_geomap_ibfk_1` FOREIGN KEY (`master_district_id`) REFERENCES `master_district` (`id`),
  CONSTRAINT `master_geomap_ibfk_2` FOREIGN KEY (`master_subdistrict_id`) REFERENCES `master_subdistrict` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `master_subdistrict`;
CREATE TABLE `master_subdistrict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `master_district_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `flag` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `master_district_id` (`master_district_id`),
  CONSTRAINT `master_subdistrict_ibfk_1` FOREIGN KEY (`master_district_id`) REFERENCES `master_district` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `master_subdistrict` (`id`, `master_district_id`, `name`, `flag`) VALUES
(9101050,	9101,	'FAKFAK TIMUR',	1),
(9101051,	9101,	'KARAS',	1),
(9101060,	9101,	'FAKFAK',	1),
(9101061,	9101,	'FAKFAK TENGAH',	1),
(9101070,	9101,	'FAKFAK BARAT',	1),
(9101080,	9101,	'KOKAS',	1),
(9101081,	9101,	'TELUK PATIPI',	1),
(9101082,	9101,	'KRAMONGMONGGA',	1),
(9101083,	9101,	'BOMBERAY',	1),
(9102010,	9102,	'BURUWAY',	1),
(9102020,	9102,	'TELUK ARGUNI',	1),
(9102021,	9102,	'TELUK ARGUNI BAWAH',	1),
(9102030,	9102,	'KAIMANA',	1),
(9102031,	9102,	'KAMBRAU',	1),
(9102040,	9102,	'TELUK ETNA',	1),
(9102041,	9102,	'YAMOR',	1),
(9103010,	9103,	'NAIKERE',	1),
(9103020,	9103,	'WONDIBOY',	1),
(9103021,	9103,	'RASIEY',	1),
(9103022,	9103,	'KURI WAMESA',	1),
(9103030,	9103,	'WASIOR',	1),
(9103040,	9103,	'DUAIRI',	1),
(9103041,	9103,	'ROON',	1),
(9103050,	9103,	'WINDESI',	1),
(9103051,	9103,	'NIKIWAR',	1),
(9103060,	9103,	'WAMESA',	1),
(9103061,	9103,	'ROSWAR',	1),
(9103070,	9103,	'RUMBERPON',	1),
(9103071,	9103,	'SOUG JAYA',	1),
(9104010,	9104,	'FAFURWAR',	1),
(9104020,	9104,	'BABO',	1),
(9104021,	9104,	'SUMURI',	1),
(9104022,	9104,	'AROBA',	1),
(9104023,	9104,	'KAITARO',	1),
(9104030,	9104,	'KURI',	1),
(9104040,	9104,	'WAMESA',	1),
(9104050,	9104,	'BINTUNI',	1),
(9104051,	9104,	'MANIMERI',	1),
(9104052,	9104,	'TUHIBA',	1),
(9104053,	9104,	'DATARAN BEIMES',	1),
(9104060,	9104,	'TEMBUNI',	1),
(9104070,	9104,	'ARANDAY',	1),
(9104071,	9104,	'KAMUNDAN',	1),
(9104072,	9104,	'TOMU',	1),
(9104073,	9104,	'WERIAGAR',	1),
(9104080,	9104,	'MOSKONA SELATAN',	1),
(9104081,	9104,	'MEYADO',	1),
(9104082,	9104,	'MOSKONA BARAT',	1),
(9104090,	9104,	'MERDEY',	1),
(9104091,	9104,	'BISCOOP',	1);

-- 2022-12-01 04:22:01