16.RatanakKiri.sql

CREATE TABLE IF NOT EXISTS `op_communes` (
  `id` int(20) NOT NULL,
  `name` text,
  `district_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_tcommune` (`district_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `op_communes`
--

INSERT INTO `op_communes` (`id`, `name`, `district_id`) VALUES
(160101, 'Malik', 1601),
(160103, 'Nhang', 1601),
(160104, 'Ta Lav', 1601),
(160201, 'Kachanh', 1602),
(160202, 'Labansiek', 1602),
(160203, 'Yeak Laom', 1602),
(160204, 'Boeng Kansaeng', 1602),
(160301, 'Kak', 1603),
(160302, 'Keh Chong', 1603),
(160303, 'La Minh', 1603),
(160304, 'Lung Khung', 1603),
(160305, 'Saeung', 1603),
(160306, 'Ting Chak', 1603),
(160401, 'Serei Mongkol', 1604),
(160402, 'Srae Angkrorng', 1604),
(160403, 'Ta Ang', 1604),
(160404, 'Teun', 1604),
(160405, 'Trapeang Chres', 1604),
(160406, 'Trapeang Kraham', 1604),
(160501, 'Chey Otdam', 1605),
(160502, 'Ka Laeng', 1605),
(160503, 'Lbang Muoy', 1605),
(160504, 'Lbang Pir', 1605),
(160505, 'Ba Tang', 1605),
(160506, 'Seda', 1605),
(160601, 'Cha Ung', 1606),
(160602, 'Pouy', 1606),
(160603, 'Aekakpheap', 1606),
(160604, 'Kalai', 1606),
(160605, 'Ou Chum', 1606),
(160606, 'Sameakki', 1606),
(160607, 'Lak', 1606),
(160701, 'Bar Kham', 1607),
(160702, 'Lum Choar', 1607),
(160703, 'Pak Nhai', 1607),
(160704, 'Pa Te', 1607),
(160705, 'Sesan', 1607),
(160706, 'Saom Thum', 1607),
(160707, 'Ya Tung', 1607),
(160801, 'Ta Veaeng Leu', 1608),
(160802, 'Ta Veaeng Kraom', 1608),
(160901, 'Pong', 1609),
(160903, 'Hat Pak', 1609),
(160904, 'Ka Choun', 1609),
(160905, 'Kaoh Pang', 1609),
(160906, 'Kaoh Peak', 1609),
(160907, 'Kok Lak', 1609),
(160908, 'Pa Kalan', 1609),
(160909, 'Phnum Kok', 1609),
(160910, 'Veun Sai', 1609);

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

--
-- Table structure for table `op_districts`
--

CREATE TABLE IF NOT EXISTS `op_districts` (
  `id` int(20) NOT NULL,
  `name` text,
  `provinces_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_tdistrict` (`provinces_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `op_districts`
--

INSERT INTO `op_districts` (`id`, `name`, `provinces_id`) VALUES
(1601, 'Andoung Meas', 16),
(1602, 'Ban Lung', 16),
(1603, 'Bar Kaev', 16),
(1604, 'Koun Mom', 16),
(1605, 'Lumphat', 16),
(1606, 'Ou Chum', 16),
(1607, 'Ou Ya Dav', 16),
(1608, 'Ta Veaeng', 16),
(1609, 'Veun Sai', 16);

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

--
-- Table structure for table `op_provinces`
--

CREATE TABLE IF NOT EXISTS `op_provinces` (
  `id` varchar(20) NOT NULL,
  `name` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `op_provinces`
--

INSERT INTO `op_provinces` (`id`, `name`) VALUES
('16', 'Ratanak Kiri');

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

--
-- Table structure for table `op_villages`
--

CREATE TABLE IF NOT EXISTS `op_villages` (
  `id` int(20) NOT NULL,
  `name` text NOT NULL,
  `commune_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_villages`
--

INSERT INTO `op_villages` (`id`, `name`, `commune_id`) VALUES
(16010101, 'Malik', 160101),
(16010102, 'Katae', 160101),
(16010103, 'Ka Hal', 160101),
(16010104, 'Laom', 160101),
(16010301, 'Ka Chut', 160103),
(16010302, 'Nay', 160103),
(16010303, 'Muy', 160103),
(16010304, 'Peaeng', 160103),
(16010305, 'Chang', 160103),
(16010306, 'Ta Nga', 160103),
(16010307, 'Chay', 160103),
(16010308, 'Kaet', 160103),
(16010309, 'Tang Chea', 160103),
(16010310, 'Dal', 160103),
(16010311, 'Tang Se', 160103),
(16010312, 'Nhang', 160103),
(16010401, 'Ta Lav', 160104),
(16010402, 'Inn', 160104),
(16010403, 'Ka Nat', 160104),
(16010404, 'Kak', 160104),
(16010405, 'Ta Nang', 160104),
(16020101, 'Phum Muoy', 160201),
(16020102, 'Phum Pir', 160201),
(16020103, 'Phum Bei', 160201),
(16020104, 'Phum Buon', 160201),
(16020201, 'Chey Chumnas', 160202),
(16020203, '7 Makara', 160202),
(16020208, 'Thmei', 160202),
(16020209, 'Akpiwat', 160202),
(16020210, 'Ou Romeat', 160202),
(16020301, 'Loun', 160203),
(16020302, 'Phnum', 160203),
(16020303, 'Sel', 160203),
(16020304, 'La Pou', 160203),
(16020305, 'Chri', 160203),
(16020401, 'Tes Anlung', 160204),
(16020402, 'Ou Konsaeng', 160204),
(16020403, 'Phnom Svay', 160204),
(16020404, 'Ou Kontil', 160204),
(16020405, 'Tmar Da', 160204),
(16030101, 'Leu Touch', 160301),
(16030102, 'Sala', 160301),
(16030103, 'Ka Chak', 160301),
(16030104, 'Kak', 160301),
(16030105, 'Yeun', 160301),
(16030106, 'Chrung', 160301),
(16030201, 'Leu Han', 160302),
(16030202, 'Leu Kuon', 160302),
(16030203, 'Krieng', 160302),
(16030204, 'Tien', 160302),
(16030205, 'Pa Ar', 160302),
(16030206, 'Pa Lae', 160302),
(16030207, 'Ray', 160302),
(16030208, 'Chrung', 160302),
(16030209, 'Sa Leav', 160302),
(16030301, 'Trom', 160303),
(16030302, 'Su', 160303),
(16030303, 'Nhol', 160303),
(16030304, 'Khmang', 160303),
(16030305, 'Phum Muoy', 160303),
(16030401, 'Lung Khung', 160304),
(16030402, 'Pa Ar', 160304),
(16030403, 'Pa Yang', 160304),
(16030404, 'Chreak', 160304),
(16030501, 'Ya Som', 160305),
(16030502, 'Saeung', 160305),
(16030503, 'Chaet', 160305),
(16030504, 'Kli', 160305),
(16030505, 'Yaem', 160305),
(16030506, 'Smach', 160305),
(16030601, 'Tuy', 160306),
(16030602, 'Kab', 160306),
(16030603, 'Lut', 160306),
(16030604, 'Pa Nal', 160306),
(16040101, 'Srae Pok Thum', 160401),
(16040102, 'Srae Pok Touch', 160401),
(16040103, 'Neang Dei', 160401),
(16040201, 'Phum Muoy', 160402),
(16040202, 'Phum Pir', 160402),
(16040203, 'Phum Bei', 160402),
(16040301, 'Ta Ang Ka Te', 160403),
(16040302, 'Ta Ang Pok', 160403),
(16040303, 'Tus', 160403),
(16040304, 'Sec', 160403),
(16040305, 'Ta Kab', 160403),
(16040401, 'Teun', 160404),
(16040402, 'La En', 160404),
(16040403, 'Ta Heuy', 160404),
(16040404, 'Kam Bak', 160404),
(16040501, 'Phum Muoy', 160405),
(16040502, 'Phum Pir', 160405),
(16040503, 'Phum Bei', 160405),
(16040504, 'Phum Buon', 160405),
(16040505, 'Phum Pram', 160405),
(16040601, 'Phum Muoy', 160406),
(16040602, 'Phum Pir', 160406),
(16040603, 'Phum Bei', 160406),
(16050101, 'Ou Kan', 160501),
(16050102, 'Srae Chhuk', 160501),
(16050103, 'Sam Kha', 160501),
(16050104, 'Dei Lou', 160501),
(16050105, 'Thmei', 160501),
(16050106, 'Lumphat', 160501),
(16050201, 'Sayas', 160502),
(16050202, 'Ka Laeng', 160502),
(16050203, 'Ka Nang Ket', 160502),
(16050301, 'Kam Phlenh', 160503),
(16050302, 'Ka Tueng', 160503),
(16050303, 'Ka Tieng', 160503),
(16050304, 'Ka Lorng', 160503),
(16050401, 'Ka Tieng', 160504),
(16050402, 'Ka Chanh', 160504),
(16050501, 'Ul', 160505),
(16050502, 'Pruok', 160505),
(16050503, 'Ba Tang', 160505),
(16050504, 'Chang Ra', 160505),
(16050601, 'Thmei', 160506),
(16050602, 'Pa Tat', 160506),
(16050603, 'Kaeng Sann', 160506),
(16050604, 'Samot Leu', 160506),
(16050605, 'Pom', 160506),
(16050606, 'Nang Hai', 160506),
(16050607, 'Samot Kraom', 160506),
(16060101, 'Cha Ung Ket', 160601),
(16060102, 'Char Ung Chan', 160601),
(16060103, 'Thuoy Ampil', 160601),
(16060104, 'Thuoy Tum', 160601),
(16060105, 'Cha Ung Kau', 160601),
(16060201, 'Mas', 160602),
(16060202, 'Kan Chheung', 160602),
(16060203, 'Kreh', 160602),
(16060204, 'Ta Ngeach', 160602),
(16060205, 'Svay', 160602),
(16060206, 'Khmaeng', 160602),
(16060207, 'Krala', 160602),
(16060208, 'Kang Koy', 160602),
(16060301, 'Pa Chon Thum', 160603),
(16060302, 'Pa Ar', 160603),
(16060303, 'Oum', 160603),
(16060304, 'Krouch', 160603),
(16060401, 'Kalai Muoy', 160604),
(16060402, 'Kalai Pir', 160604),
(16060403, 'Kalai Bei', 160604),
(16060501, 'Ou Chum', 160605),
(16060502, 'Tharang Chong', 160605),
(16060503, 'Tharang Svay', 160605),
(16060504, 'Leun Kraen', 160605),
(16060505, 'Leun Chong', 160605),
(16060506, 'Tang Pleng', 160605),
(16060507, 'Ta Kamal', 160605),
(16060508, 'Leun Kang Mis', 160605),
(16060601, 'Ka Meaen', 160606),
(16060603, 'Prak', 160606),
(16060604, 'Bar Nhu', 160606),
(16060605, 'Ping', 160606),
(16060701, 'Lak', 160607),
(16060702, 'Kralong', 160607),
(16060703, 'Kouk', 160607),
(16060704, 'Kam', 160607),
(16060705, 'Phum Pir', 160607),
(16070101, 'Tung', 160701),
(16070102, 'Des', 160701),
(16070103, 'Plor', 160701),
(16070104, 'Ta Kok Pnong', 160701),
(16070105, 'Ta Kok Chray', 160701),
(16070106, 'Pril', 160701),
(16070201, 'Le', 160702),
(16070202, 'Ka Te', 160702),
(16070203, 'Trang', 160702),
(16070204, 'Un', 160702),
(16070301, 'Pak Thum', 160703),
(16070302, 'Pak Touch', 160703),
(16070303, 'Pak Por', 160703),
(16070304, 'Lom', 160703),
(16070401, 'Plang', 160704),
(16070402, 'Kong Thum', 160704),
(16070403, 'Pa Ar', 160704),
(16070404, 'Kong Yu', 160704),
(16070501, 'Pa Tang', 160705),
(16070502, 'Phi', 160705),
(16070503, 'Pa Dal', 160705),
(16070601, 'Saom Ka nihn', 160706),
(16070602, 'Saom Trak', 160706),
(16070603, 'Saom Kol', 160706),
(16070701, 'Ten Ngol', 160707),
(16070702, 'Peak', 160707),
(16070703, 'Ten Soh', 160707),
(16070704, 'Dar', 160707),
(16070705, 'Sam', 160707),
(16080102, 'Chan', 160801),
(16080103, 'Chuoy', 160801),
(16080104, 'Ta Bouk', 160801),
(16080105, 'Pangkit', 160801),
(16080106, 'Sanh', 160801),
(16080107, 'Ki Kuong', 160801),
(16080108, 'Rieng Vinh', 160801),
(16080109, 'Phlueu Thum', 160801),
(16080110, 'Phlueu Touch', 160801),
(16080111, 'Ta Veaeng', 160801),
(16080201, 'Tumpuon Reung Thum', 160802),
(16080202, 'Tun', 160802),
(16080203, 'Kaoh Pong', 160802),
(16080204, 'Sieng Say', 160802),
(16080205, 'Phyang', 160802),
(16080206, 'Ke Kuong', 160802),
(16080207, 'Ta Ngach', 160802),
(16080208, 'Phav', 160802),
(16080209, 'Tumpuon Reung Touch', 160802),
(16080210, 'Vieng Chan', 160802),
(16090101, 'Ban Pong', 160901),
(16090102, 'Ban Phang', 160901),
(16090301, 'Hat Pak', 160903),
(16090302, 'Veun Hay', 160903),
(16090303, 'Lam Pat', 160903),
(16090401, 'Ka Choun Leu', 160904),
(16090402, 'Ka Choun Kraom', 160904),
(16090403, 'Vorng', 160904),
(16090404, 'Vay', 160904),
(16090405, 'Tiem Leu', 160904),
(16090406, 'Ka Loem', 160904),
(16090501, 'Pa Toeng', 160905),
(16090502, 'Lang Av', 160905),
(16090503, 'Pa Hay', 160905),
(16090601, 'Kaoh Peak', 160906),
(16090602, 'Phak Nam', 160906),
(16090603, 'Khuon', 160906),
(16090701, 'La Lai', 160907),
(16090702, 'Rak', 160907),
(16090703, 'La Meuy', 160907),
(16090704, 'Trak', 160907),
(16090801, 'Pa Kalan', 160908),
(16090802, 'Kampong Cham', 160908),
(16090901, 'Phnum Kok Lav', 160909),
(16090902, 'Phnum Kok Prov', 160909),
(16090903, 'Kalai Ta Vorng', 160909),
(16090904, 'Kalai Sapun', 160909),
(16090905, 'Tiem Kraom', 160909),
(16091001, 'Veun Sai', 160910),
(16091002, 'Bak Kae', 160910),
(16091003, 'I Tub', 160910),
(16091004, 'Thmei', 160910),
(16091005, 'Ka Lan', 160910),
(16091006, 'Kang Nak', 160910);