text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               5.7.26 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             11.0.0.5919
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  
  -- Dumping database structure for thepinrealestate_social_login
  DROP DATABASE IF EXISTS `thepinrealestate_social_login`;
  CREATE DATABASE IF NOT EXISTS `thepinrealestate_social_login` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `thepinrealestate_social_login`;
  
  -- Dumping structure for table thepinrealestate_social_login.admins
  DROP TABLE IF EXISTS `admins`;
  CREATE TABLE IF NOT EXISTS `admins` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` int(10) unsigned NOT NULL DEFAULT '0',
    `firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lastname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admins_email_unique` (`email`),
    UNIQUE KEY `phone` (`phone`),
    UNIQUE KEY `admins_usernamme_unique` (`username`) USING BTREE
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.admins: 1 rows
  /*!40000 ALTER TABLE `admins` DISABLE KEYS */;
  INSERT INTO `admins` (`id`, `role_id`, `firstname`, `lastname`, `username`, `phone`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  	(1, 1, 'Administrator', 'Administrator', 'admin', '012888999', 'admin@gmail.com', '2020-06-10 17:52:56', '$2y$10$GJnXqe6/2uPZlKgkfGnTaOaoPzZMCJw6oyr7eHnmZlbo7fs2/WLDq', 'LeMAl3D6Lb8FQ9rO435NnPfSX5A4ju9RwUnWDdzKrTW57aft9t8u0D9exky7', '2020-06-10 17:53:09', '2020-06-10 17:53:11');
  /*!40000 ALTER TABLE `admins` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.agents
  DROP TABLE IF EXISTS `agents`;
  CREATE TABLE IF NOT EXISTS `agents` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `agent_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `firstname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `lastname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `firstname_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `lastname_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `job_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `facebook` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
    `twitter` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pinterest` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
    `linkedin` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `photo` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.agents: 4 rows
  /*!40000 ALTER TABLE `agents` DISABLE KEYS */;
  INSERT INTO `agents` (`id`, `role_id`, `agent_type_id`, `firstname`, `lastname`, `firstname_kh`, `lastname_kh`, `job_title`, `phone`, `phone1`, `phone2`, `phone3`, `phone4`, `email`, `facebook`, `twitter`, `pinterest`, `linkedin`, `address`, `photo`, `description`, `created_at`, `updated_at`) VALUES
  	(1, 1, 1, 'Administrator', 'Administrator', 'គ្រប់គ្រងរដ្ឋបាល', 'គ្រប់គ្រងរដ្ឋបាល', NULL, '012888999', NULL, NULL, NULL, NULL, 'admin@gmail.com', '', '', '', '', '', NULL, NULL, '2020-06-10 10:47:43', '2020-06-10 10:47:43'),
  	(2, 3, 1, 'agent', 'agent', 'អេចិន', 'អេចិន', NULL, '01211112222', NULL, NULL, NULL, NULL, 'agen@gmail.com', '', '', '', '', '', NULL, NULL, '2020-06-11 08:09:52', '2020-06-11 08:09:52'),
  	(3, 3, 1, 'User', 'User', 'យូសសឺ', 'យូសសឺ', NULL, '012123456', NULL, NULL, NULL, NULL, 'user@gmail.com', '', '', '', '', '', NULL, NULL, '2020-06-14 08:21:31', '2020-06-14 08:21:31'),
  	(4, 3, 1, 'kaka', 'kaka', 'kaka', 'kaka', NULL, '012666777', NULL, NULL, NULL, NULL, 'kaka@gmail.com', '', '', '', '', '', NULL, NULL, '2020-06-15 07:59:19', '2020-06-15 07:59:19');
  /*!40000 ALTER TABLE `agents` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.attributes
  DROP TABLE IF EXISTS `attributes`;
  CREATE TABLE IF NOT EXISTS `attributes` (
    `id` bigint(20) NOT NULL,
    `name_kh` varchar(150) DEFAULT NULL,
    `name_en` varchar(150) DEFAULT NULL,
    `value` varchar(150) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- Dumping data for table thepinrealestate_social_login.attributes: 0 rows
  /*!40000 ALTER TABLE `attributes` DISABLE KEYS */;
  /*!40000 ALTER TABLE `attributes` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.bathrooms
  DROP TABLE IF EXISTS `bathrooms`;
  CREATE TABLE IF NOT EXISTS `bathrooms` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.bathrooms: 9 rows
  /*!40000 ALTER TABLE `bathrooms` DISABLE KEYS */;
  INSERT INTO `bathrooms` (`id`, `room`, `created_at`, `updated_at`) VALUES
  	(1, '1', '2020-06-20 12:58:51', '2020-06-20 12:58:53'),
  	(2, '2', '2020-06-20 12:58:52', '2020-06-20 12:58:51'),
  	(3, '3', '2020-06-20 12:58:54', '2020-06-20 12:58:54'),
  	(4, '4', '2020-06-20 12:58:55', '2020-06-20 12:58:55'),
  	(5, '5', '2020-06-20 12:58:56', '2020-06-20 12:58:56'),
  	(6, '6', '2020-06-20 12:58:57', '2020-06-20 12:58:57'),
  	(7, '7', '2020-06-20 12:58:58', '2020-06-20 12:58:59'),
  	(8, '8', '2020-06-20 12:58:59', '2020-06-20 12:59:02'),
  	(9, 'More+', '2020-06-20 12:59:00', '2020-06-20 12:59:00');
  /*!40000 ALTER TABLE `bathrooms` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.bedrooms
  DROP TABLE IF EXISTS `bedrooms`;
  CREATE TABLE IF NOT EXISTS `bedrooms` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.bedrooms: 9 rows
  /*!40000 ALTER TABLE `bedrooms` DISABLE KEYS */;
  INSERT INTO `bedrooms` (`id`, `room`, `created_at`, `updated_at`) VALUES
  	(1, '1', '2020-06-20 12:55:45', '2020-06-20 12:55:46'),
  	(2, '2', '2020-06-20 12:55:46', '2020-06-20 12:55:48'),
  	(3, '3', '2020-06-20 12:55:47', '2020-06-20 12:55:47'),
  	(4, '4', '2020-06-20 12:55:55', '2020-06-20 12:55:54'),
  	(5, '5', '2020-06-20 12:56:01', '2020-06-20 12:56:02'),
  	(6, '6', '2020-06-20 12:56:08', '2020-06-20 12:56:09'),
  	(7, '7', '2020-06-20 12:56:15', '2020-06-20 12:56:16'),
  	(8, '8', '2020-06-20 12:56:24', '2020-06-20 12:56:24'),
  	(9, 'More+', '2020-06-20 12:58:03', '2020-06-20 12:58:03');
  /*!40000 ALTER TABLE `bedrooms` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.categories
  DROP TABLE IF EXISTS `categories`;
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` int(10) unsigned NOT NULL,
    `type_id` tinyint(4) DEFAULT '0',
    `sub_type_id` tinyint(4) DEFAULT NULL,
    `category_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `category_name_kh` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `form_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `form_header` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `form_footer` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(4) NOT NULL DEFAULT '0',
    `deleted_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.categories: 132 rows
  /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
  INSERT INTO `categories` (`id`, `parent_id`, `type_id`, `sub_type_id`, `category_name`, `category_name_kh`, `slug`, `description`, `form_name`, `form_header`, `form_footer`, `icon`, `url`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
  	(1, 0, 0, 0, 'Phones & Tablets', NULL, 'phones-and-tablets', NULL, NULL, NULL, NULL, 'mobile-phones-tablets.png', NULL, 0, NULL, NULL, NULL),
  	(2, 0, 0, 0, 'Computers & Accessories', NULL, 'computers-and-accessories', NULL, NULL, NULL, NULL, 'computer-and-accessories.png', NULL, 0, NULL, NULL, NULL),
  	(3, 0, 0, 0, 'Electronics & Appliances', NULL, 'electronics-and-appliances', NULL, NULL, NULL, NULL, 'electronics-appliances.png', NULL, 0, NULL, NULL, NULL),
  	(4, 0, 0, 0, 'Cars and Vehicles', NULL, 'cars-and-vehicles', NULL, NULL, NULL, NULL, 'cars-and-vehicles.png', NULL, 0, NULL, NULL, NULL),
  	(5, 0, 0, 0, ' House & Lands', NULL, 'house-and-land', NULL, NULL, NULL, NULL, 'property-housing-rentals.png', NULL, 1, NULL, NULL, NULL),
  	(6, 0, 0, 0, 'Jobs', NULL, 'jobs', NULL, NULL, NULL, NULL, 'jobs.png', NULL, 0, NULL, NULL, NULL),
  	(7, 0, 0, 0, 'Services', NULL, 'services', NULL, NULL, NULL, NULL, 'services.png', NULL, 1, NULL, NULL, NULL),
  	(8, 0, 0, 0, 'Fashion & Beauty', NULL, 'fashion-and-beauty', NULL, NULL, NULL, NULL, 'fashion-beauty.png', NULL, 0, NULL, NULL, NULL),
  	(9, 0, 0, 0, 'Books, Sports & Hobbies', NULL, 'books-sports-hobbies', NULL, NULL, NULL, NULL, 'books-sports-hobbies.png', NULL, 0, NULL, NULL, NULL),
  	(10, 0, 0, 0, 'Furniture & Decor', NULL, 'furniture-decor', NULL, NULL, NULL, NULL, 'furniture-decor.png', NULL, 0, NULL, NULL, NULL),
  	(11, 0, 0, 0, 'Pets', NULL, 'pets', NULL, NULL, NULL, NULL, 'pets.png', NULL, 0, NULL, NULL, NULL),
  	(12, 0, 0, 0, 'foods', NULL, 'foods', NULL, NULL, NULL, NULL, 'foods.png', NULL, 0, NULL, NULL, NULL),
  	(13, 1, 0, 0, 'Phones, Tablets', NULL, 'phone-and-tablets', NULL, 'phone_tablets.phone', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(14, 1, 0, 0, 'Smart Watches', NULL, 'smart-watches', NULL, 'phone_tablets.watch', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(15, 1, 0, 0, 'Phone Accessories', NULL, 'phone-and-ccessories', NULL, 'phone_tablets.accessories', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(16, 1, 0, 0, 'Phone Numbers', NULL, 'phone-and-numbers', NULL, 'phone_tablets.number', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(17, 2, 0, 0, 'Computers', NULL, 'computers', NULL, 'computer_accessories.computer', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(18, 2, 0, 0, 'Computer accessories', NULL, 'computer-accessories', NULL, 'computer_accessories.accessories', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(19, 2, 0, 0, 'Softwares', NULL, 'softwares', NULL, 'computer_accessories.software', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(20, 3, 0, 0, 'Consumer Electronics', NULL, 'consumer-electronics', NULL, 'electronic_appliances.electronic', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(21, 3, 0, 0, 'Security Camera', NULL, 'security-camera', NULL, 'electronic_appliances.camera', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(22, 3, 0, 0, 'Cameras, camcorders', NULL, 'cameras-and-camcorders', NULL, 'electronic_appliances.camcorder', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(23, 3, 0, 0, 'TVs, Videos and Audios', NULL, 'tv-videos-and-audios', NULL, 'electronic_appliances.appliance_game_tv_video_audio', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(24, 3, 0, 0, 'Home appliances', NULL, 'home-appliances', NULL, 'electronic_appliances.appliance_game_tv_video_audio', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(25, 3, 0, 0, 'Video games, consoles, toys', NULL, 'video-games-consoles-toys', NULL, 'electronic_appliances.appliance_game_tv_video_audio', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(26, 4, 0, 0, 'Cars for Sale', NULL, 'cars-for-sale', NULL, 'car_vehicles.car_sale', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(27, 4, 0, 0, 'Bicycles', NULL, 'bicycles', NULL, 'car_vehicles.bicycle', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(28, 4, 0, 0, 'Motorcycles for Sale', NULL, 'motorcycles-for-sale', NULL, 'car_vehicles.motocycle', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(29, 4, 0, 0, 'Vehicles for Rent', NULL, 'vehicles-for-ent', NULL, 'car_vehicles.vehicle_rent', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(30, 4, 0, 0, 'Car Maintenance & Repair', NULL, 'car-maintenance-and-repair', NULL, 'car_vehicles.repaire_insurance', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(31, 4, 0, 0, 'Lorries & Vans', NULL, 'lorries-and-vans', NULL, 'car_vehicles.accessories_lorries_vans', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(32, 4, 0, 0, 'Financing & Insurance', NULL, 'financing-and-insurance', NULL, 'car_vehicles.repaire_insurance', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(33, 4, 0, 0, 'Car Parts & Accessories', NULL, 'car-parts-and-accessories', NULL, 'car_vehicles.accessories_lorries_vans', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(34, 4, 0, 0, 'Others', NULL, 'others', NULL, 'car_vehicles.others', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(35, 5, 1, 1, 'House for Sale', NULL, 'house-for-sale', NULL, 'house_lands.house', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(36, 5, 1, 2, 'House for Rent', NULL, 'house-for-rent', NULL, 'house_lands.house', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(37, 5, 3, 1, 'Apartment for Sale', NULL, 'apartment-for-sale', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(38, 5, 3, 2, 'Apartment for Rent', NULL, 'apartment-for-rent', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(39, 5, 2, 1, 'Land for Sale', NULL, 'land-for-sale', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(40, 5, 2, 2, 'Land for Rent', NULL, 'land-for-rent', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(41, 5, 4, 1, 'Commercial for Sale', NULL, 'commercial-for-sale', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(42, 5, 4, 2, 'Commercial for Rent', NULL, 'commercial-for-rent', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(43, 5, 5, 2, 'Room for Rent', NULL, 'room-for-rent', NULL, 'house_lands.land_commercial_apartment_room', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(44, 5, 6, 3, 'Properties Wanted', NULL, 'properties-wanted', NULL, 'house_lands.properties_wanted_agent_other', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(45, 5, 7, 4, 'Agent Services', NULL, 'agent-services', NULL, 'house_lands.properties_wanted_agent_other', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(46, 5, 8, 5, 'Others', NULL, 'others', NULL, 'house_lands.properties_wanted_agent_other', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(47, 6, 0, 0, 'Accounting', NULL, 'accounting', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(48, 6, 0, 0, 'Administration', NULL, 'administration', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(49, 6, 0, 0, 'Assistant/Secretary', NULL, 'assistant-secretary', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(50, 6, 0, 0, 'Audit/Taxation', NULL, 'audit-taxation', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(51, 6, 0, 0, 'Banking/Insurance', NULL, 'banking-insurance', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(52, 6, 0, 0, 'Cashier/Receptionist', NULL, 'cashier-receptionist', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(53, 6, 0, 0, 'Catering/Restaurant', NULL, 'catering-restaurant', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(54, 6, 0, 0, 'Cleaner/Maid', NULL, 'cleaner-maid', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(55, 6, 0, 0, 'Consultancy', NULL, 'consultancy', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(56, 6, 0, 0, 'Customer Service', NULL, 'customer-service', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(57, 6, 0, 0, 'Design', NULL, 'design', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(58, 6, 0, 0, 'Education/Training', NULL, 'education-training', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(59, 6, 0, 0, 'Finance', NULL, 'finance', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(60, 6, 0, 0, 'Freight/Shipping /Delivery/Warehouse', NULL, 'freight-shipping-delivery-warehouse', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(61, 6, 0, 0, 'Hotel/Hospitality', NULL, 'hotel-hospitality', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(62, 6, 0, 0, 'Human Resource', NULL, 'human-resource', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(63, 6, 0, 0, 'Information Technology', NULL, 'information-technology', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(64, 6, 0, 0, 'Lawyer/Legal Service', NULL, 'lawyer-legal-service', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(65, 6, 0, 0, 'Management', NULL, 'management', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(66, 6, 0, 0, 'Manufacturing', NULL, 'manufacturing', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(67, 6, 0, 0, 'Marketing', NULL, 'marketing', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(68, 6, 0, 0, 'Media/Advertising', NULL, 'media-advertising', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(69, 6, 0, 0, 'Medical/Health/Nursing', NULL, 'medical-health-nursing', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(70, 6, 0, 0, 'Merchandising/Purchasing', NULL, 'merchandising-purchasing', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(71, 6, 0, 0, 'Operations', NULL, 'operations', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(72, 6, 0, 0, 'Project Management', NULL, 'project-management', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(73, 6, 0, 0, 'Quality Control', NULL, 'quality-control', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(74, 6, 0, 0, 'Resort/Casino', NULL, 'resort-casino', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(75, 6, 0, 0, 'Sales', NULL, 'sales', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(76, 6, 0, 0, 'Security/Driver', NULL, 'security-driver', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(77, 6, 0, 0, 'Technician', NULL, 'technician', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(78, 6, 0, 0, 'Telecommunication', NULL, 'telecommunication', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(79, 6, 0, 0, 'Translation/Interpretation', NULL, 'translation-interpretation', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(80, 6, 0, 0, 'Travel Agent/Ticket Sales', NULL, 'travel-agent-and-ticket-sales', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(81, 6, 0, 0, 'Others', NULL, 'others', NULL, 'jobs', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(82, 7, 0, 0, 'Accounting', NULL, 'accounting', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(83, 7, 0, 0, 'Automotive', NULL, 'automotive', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(84, 7, 0, 0, 'Advertising & Media', NULL, 'advertising-and-media', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(85, 7, 0, 0, 'Bridal Services', NULL, 'bridal-services', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(86, 7, 0, 0, 'Cleaning & Maid Services', NULL, 'cleaning-and-maid-services', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(87, 7, 0, 0, 'Construction, Arch. & Interiors', NULL, 'construction', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(88, 7, 0, 0, 'Education & Training', NULL, 'education-and-training', NULL, 'services', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(89, 7, 0, 0, 'Engineering', NULL, 'engineering', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(90, 7, 0, 0, 'Insurance', NULL, 'insurance', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(91, 7, 0, 0, 'Massage & Spa', NULL, 'massage-and-spa', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(92, 7, 0, 0, 'Hospitality, Travel & Tourism', NULL, 'hospitality-travel-and-tourism', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(93, 7, 0, 0, 'Health, Medical & Pharma', NULL, 'health-medical-and-pharma', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(94, 7, 0, 0, 'IT & Telecom', NULL, 'it-and-telecom', NULL, 'services', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
  	(95, 7, 0, 0, 'Interior Design & Renovation', NULL, 'interior-design-and-renovation', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(96, 7, 0, 0, 'Legal', NULL, 'legal', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(97, 7, 0, 0, 'Movers & Logistics', NULL, 'movers-and-logistics', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(98, 7, 0, 0, 'Plumbing & Electrical', NULL, 'plumbing-and-electrical', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(99, 7, 0, 0, 'Property & Real Estate', NULL, 'property-and-real-estate', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(100, 7, 0, 0, 'Science', NULL, 'science', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(101, 7, 0, 0, 'Supply Chain & Logistics', NULL, 'supply-chain-and-logistics', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(102, 7, 0, 0, 'Printing & Publishing', NULL, 'printing-and-publishing', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(103, 7, 0, 0, 'Other Services', NULL, 'other-services', NULL, 'services', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(104, 8, 0, 0, 'Jewelry, watches', NULL, 'jewelry-watches', NULL, 'fashion_beauty.jewelry_watches', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(105, 8, 0, 0, 'Clothing, accessories', NULL, 'clothing-accessories', NULL, 'fashion_beauty.clothing_accessories', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(106, 8, 0, 0, 'Beauty & Healthcare', NULL, 'beauty-and-healthcare', NULL, 'fashion_beauty.beauty_healthcare', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(107, 9, 0, 0, 'CDS, DVDS, VHS', NULL, 'cds-dvds-vhs', NULL, 'book_sport_hobbies', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(108, 9, 0, 0, 'Books', NULL, 'books', NULL, 'book_sport_hobbies', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(109, 9, 0, 0, 'Sports Equipment', NULL, 'sports-equipment', NULL, 'book_sport_hobbies', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(110, 9, 0, 0, 'Others', NULL, 'others', NULL, 'book_sport_hobbies', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(111, 10, 0, 0, 'Household Items', NULL, 'household-items', NULL, 'furniture_decos', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(112, 10, 0, 0, 'Office Furniture', NULL, 'office-furniture', NULL, 'furniture_decos', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(113, 10, 0, 0, 'Home Furniture', NULL, 'home-furniture', NULL, 'furniture_decos', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(114, 10, 0, 0, 'Kitchenware', NULL, 'kitchenware', NULL, 'furniture_decos', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(115, 10, 0, 0, 'Handicrafts Paintings', NULL, 'handicrafts-paintings', NULL, 'furniture_decos', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(116, 11, 0, 0, 'Dogs', NULL, 'dogs', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(117, 11, 0, 0, 'Cats', NULL, 'cats', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(118, 11, 0, 0, 'Birds', NULL, 'birds', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(119, 11, 0, 0, 'Fish', NULL, 'fish', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(120, 11, 0, 0, 'Pet Food', NULL, 'pet-food', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(121, 11, 0, 0, 'Pet Accessories', NULL, 'pet-accessories', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(122, 11, 0, 0, 'Other', NULL, 'other', NULL, 'pets', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(123, 12, 0, 0, 'Meat', NULL, 'meat', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(124, 12, 0, 0, 'Seafood', NULL, 'seafood', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(125, 12, 0, 0, 'Fruits', NULL, 'fruits', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(126, 12, 0, 0, 'Vegetables', NULL, 'vegetables', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(127, 12, 0, 0, 'Beverages', NULL, 'beverages', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(128, 12, 0, 0, 'Grocery', NULL, 'grocery', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(129, 12, 0, 0, 'Bread & Bakery', NULL, 'bread-and-bakery', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(130, 12, 0, 0, 'Beer & Wine', NULL, 'beer-and-wine', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(131, 12, 0, 0, 'Rice & Cereal', NULL, 'rice-and-cereal', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
  	(132, 12, 0, 0, 'Other', NULL, 'others', NULL, 'foods', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL);
  /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.communes
  DROP TABLE IF EXISTS `communes`;
  CREATE TABLE IF NOT EXISTS `communes` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `district_id` int(11) DEFAULT NULL,
    `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=912 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.communes: 911 rows
  /*!40000 ALTER TABLE `communes` DISABLE KEYS */;
  INSERT INTO `communes` (`id`, `district_id`, `name_en`, `name_kh`, `created_at`, `updated_at`) VALUES
  	(1, 1, 'Svay Pak', '', NULL, NULL),
  	(2, 1, 'Russey Keo', '', NULL, NULL),
  	(3, 1, 'Toul Sangke', '', NULL, NULL),
  	(4, 1, 'Kilometr Lek 6', '', NULL, NULL),
  	(5, 1, 'Chrang Chamreh 1', '', NULL, NULL),
  	(6, 1, 'Chrang Chamreh 2', '', NULL, NULL),
  	(7, 2, 'Krang Thnong', '', NULL, NULL),
  	(8, 2, 'Khmuonh', '', NULL, NULL),
  	(9, 2, 'Phnom Penh Thmei', '', NULL, NULL),
  	(10, 2, 'Tuek Thla', '', NULL, NULL),
  	(11, 2, 'Obek Kaom', '', NULL, NULL),
  	(12, 3, 'Ovlaok', '', NULL, NULL),
  	(13, 3, 'Kamboul', '', NULL, NULL),
  	(14, 3, 'Kantaok', '', NULL, NULL),
  	(15, 3, 'Boeng Thum', '', NULL, NULL),
  	(16, 3, 'Phleung Chheh Roteh', '', NULL, NULL),
  	(17, 3, 'Chaom Chau', '', NULL, NULL),
  	(18, 3, 'Trapeang Krasang', '', NULL, NULL),
  	(19, 3, 'Kakab', '', NULL, NULL),
  	(20, 3, 'Samraong Kraom', '', NULL, NULL),
  	(21, 3, 'Snaor', '', NULL, NULL),
  	(22, 4, 'Bak Kheng', '', NULL, NULL),
  	(23, 4, 'Praek Leab', '', NULL, NULL),
  	(24, 4, 'Praek Ta Sek', '', NULL, NULL),
  	(25, 4, 'Chrouy Changvar', '', NULL, NULL),
  	(26, 4, 'Kaoh Dach', '', NULL, NULL),
  	(27, 5, 'Ponsang', '', NULL, NULL),
  	(28, 5, 'Kouk Roka', '', NULL, NULL),
  	(29, 5, 'Ponhea Pon', '', NULL, NULL),
  	(30, 5, 'Samraong', '', NULL, NULL),
  	(31, 5, 'Praek Phnov', '', NULL, NULL),
  	(32, 6, 'Veal Sbov', '', NULL, NULL),
  	(33, 6, 'Praek Aeng', '', NULL, NULL),
  	(34, 6, 'Chbar Ampov 1', '', NULL, NULL),
  	(35, 6, 'Chbar Ampov 2', '', NULL, NULL),
  	(36, 6, 'Nirouth', '', NULL, NULL),
  	(37, 6, 'Praek Pra', '', NULL, NULL),
  	(38, 6, 'Praek Thmei', '', NULL, NULL),
  	(39, 6, 'Kbal Kaoh', '', NULL, NULL),
  	(40, 7, 'Psar Thmei1', '', NULL, NULL),
  	(41, 7, 'Psar Thmei2', '', NULL, NULL),
  	(42, 7, 'Psar Thmei3', '', NULL, NULL),
  	(43, 7, 'Boeung Reang', '', NULL, NULL),
  	(44, 7, 'Psar Kandal1', '', NULL, NULL),
  	(45, 7, 'Psar Kandal2', '', NULL, NULL),
  	(46, 7, 'Chaktomukh', '', NULL, NULL),
  	(47, 7, 'Chey Chumneah', '', NULL, NULL),
  	(48, 7, 'Psar Chas', '', NULL, NULL),
  	(49, 7, 'Srah Chork', '', NULL, NULL),
  	(50, 7, 'Vat Phnum', '', NULL, NULL),
  	(51, 8, 'O Reussei 1', '', NULL, NULL),
  	(52, 8, 'O Reussei 2', '', NULL, NULL),
  	(53, 8, 'O Reussei 3', '', NULL, NULL),
  	(54, 8, 'O Reussei 4', '', NULL, NULL),
  	(55, 8, 'Monorom', '', NULL, NULL),
  	(56, 8, 'Mittapheap', '', NULL, NULL),
  	(57, 8, 'Vealvong', '', NULL, NULL),
  	(58, 8, 'Beung Prolit', '', NULL, NULL),
  	(59, 9, 'Psar Depot1', '', NULL, NULL),
  	(60, 9, 'Psar Depot2', '', NULL, NULL),
  	(61, 9, 'Psar Depot3', '', NULL, NULL),
  	(62, 9, 'Teuk Laork1', '', NULL, NULL),
  	(63, 9, 'Teuk Laork2', '', NULL, NULL),
  	(64, 9, 'Teuk Laork3', '', NULL, NULL),
  	(65, 9, 'Beung Kok1', '', NULL, NULL),
  	(66, 9, 'Beung Kok2', '', NULL, NULL),
  	(67, 9, 'Psar Deumkor', '', NULL, NULL),
  	(68, 9, 'Beung Salang', '', NULL, NULL),
  	(69, 10, 'Dangkor', '', NULL, NULL),
  	(70, 10, 'Prey Sa', '', NULL, NULL),
  	(71, 10, 'Cheung Aek', '', NULL, NULL),
  	(72, 10, 'Spean Thma', '', NULL, NULL),
  	(73, 10, 'Prey Vaeng', '', NULL, NULL),
  	(74, 10, 'Pong Tuek', '', NULL, NULL),
  	(75, 10, 'Prateah Lang', '', NULL, NULL),
  	(76, 10, 'Sak Sampov', '', NULL, NULL),
  	(77, 10, 'Krang Pongro', '', NULL, NULL),
  	(78, 10, 'Kong Noy', '', NULL, NULL),
  	(79, 10, 'Tien', '', NULL, NULL),
  	(80, 10, 'Praek Kampues', '', NULL, NULL),
  	(81, 11, 'Stung Meanchey', '', NULL, NULL),
  	(82, 11, 'Boeng Tompun', '', NULL, NULL),
  	(83, 11, 'Chak Angrae Leu', '', NULL, NULL),
  	(84, 11, 'Chak Angrae Kroam', '', NULL, NULL),
  	(85, 12, 'Tonle Bassac', '', NULL, NULL),
  	(86, 12, 'Beung Kengkang1', '', NULL, NULL),
  	(87, 12, 'Beung Kengkang2', '', NULL, NULL),
  	(88, 12, 'Beung Kengkang3', '', NULL, NULL),
  	(89, 12, 'Olympic', '', NULL, NULL),
  	(90, 12, 'Toul Svayprey1', '', NULL, NULL),
  	(91, 12, 'Toul Svayprey2', '', NULL, NULL),
  	(92, 12, 'Tomnub Teuk', '', NULL, NULL),
  	(93, 12, 'Toul Tompung1', '', NULL, NULL),
  	(94, 12, 'Toul Tompung2', '', NULL, NULL),
  	(95, 12, 'Beung Trabaek', '', NULL, NULL),
  	(96, 12, 'Psar Deumtkov', '', NULL, NULL),
  	(97, 13, 'Sangkat 1', '', NULL, NULL),
  	(98, 13, 'Sangkat 2', '', NULL, NULL),
  	(99, 13, 'Sangkat 3', '', NULL, NULL),
  	(100, 13, 'Sangkat 4', '', NULL, NULL),
  	(101, 13, 'Koh Rong', '', NULL, NULL),
  	(102, 14, 'Andong Thmar', '', NULL, NULL),
  	(103, 14, 'Beung Taprum', '', NULL, NULL),
  	(104, 14, 'Bet Trang', '', NULL, NULL),
  	(105, 14, 'Cheung Koar', '', NULL, NULL),
  	(106, 14, 'Ou Chrov', '', NULL, NULL),
  	(107, 14, 'Ou Oknha Heng', '', NULL, NULL),
  	(108, 14, 'Prey Nob', '', NULL, NULL),
  	(109, 14, 'Ream', '', NULL, NULL),
  	(110, 14, 'Sammaki', '', NULL, NULL),
  	(111, 14, 'Somrong', '', NULL, NULL),
  	(112, 14, 'Teuk Laork', '', NULL, NULL),
  	(113, 14, 'Teuk Tla', '', NULL, NULL),
  	(114, 14, 'Toul Toteung', '', NULL, NULL),
  	(115, 14, 'Veal Rinh', '', NULL, NULL),
  	(116, 15, 'Kompenh', '', NULL, NULL),
  	(117, 15, 'Ou Treh', '', NULL, NULL),
  	(118, 15, 'Tomnob Rolork', '', NULL, NULL),
  	(119, 15, 'Keo Phos', '', NULL, NULL),
  	(120, 16, 'Chomkar Loung', '', NULL, NULL),
  	(121, 16, 'Kampong Seila', '', NULL, NULL),
  	(122, 16, 'Ou Bak Roteh', '', NULL, NULL),
  	(123, 16, 'Steung Chhay', '', NULL, NULL),
  	(124, 17, 'Boeng Kok', '', NULL, NULL),
  	(125, 17, 'Kampong Cham', '', NULL, NULL),
  	(126, 17, 'Sambuor Meas', '', NULL, NULL),
  	(127, 17, 'Veal Vong', '', NULL, NULL),
  	(128, 18, 'Ampil', '', NULL, NULL),
  	(129, 18, 'Hann Chey', '', NULL, NULL),
  	(130, 18, 'Kien Chrey', '', NULL, NULL),
  	(131, 18, 'Kokor', '', NULL, NULL),
  	(132, 18, 'Kaoh Mitt', '', NULL, NULL),
  	(133, 18, 'Kaoh Roka', '', NULL, NULL),
  	(134, 18, 'Kaoh Samraong', '', NULL, NULL),
  	(135, 18, 'Kaoh Tontuem', '', NULL, NULL),
  	(136, 18, 'Krala', '', NULL, NULL),
  	(137, 18, 'Ou Svay', '', NULL, NULL),
  	(138, 18, 'Ro any', '', NULL, NULL),
  	(139, 18, 'Rumchek', '', NULL, NULL),
  	(140, 18, 'Srak', '', NULL, NULL),
  	(141, 18, 'Trean', '', NULL, NULL),
  	(142, 18, 'Vihear Thum', '', NULL, NULL),
  	(143, 19, 'Angkor Ban', '', NULL, NULL),
  	(144, 19, 'Kong Taneung', '', NULL, NULL),
  	(145, 19, 'Khchau', '', NULL, NULL),
  	(146, 19, 'Peam Chikong', '', NULL, NULL),
  	(147, 19, 'Prek Koy', '', NULL, NULL),
  	(148, 19, 'Prek Krabau', '', NULL, NULL),
  	(149, 19, 'Reay Pay', '', NULL, NULL),
  	(150, 19, 'Roka-a', '', NULL, NULL),
  	(151, 19, 'Roka-koy', '', NULL, NULL),
  	(152, 19, 'Sdau', '', NULL, NULL),
  	(153, 19, 'Sor Korng', '', NULL, NULL),
  	(154, 20, 'Kampong Reab', '', NULL, NULL),
  	(155, 20, 'Koh Sotin', '', NULL, NULL),
  	(156, 20, 'Tve', '', NULL, NULL),
  	(157, 20, 'Mohaleap', '', NULL, NULL),
  	(158, 20, 'Moha Knhoung', '', NULL, NULL),
  	(159, 20, 'Peam Brothnous', '', NULL, NULL),
  	(160, 20, 'Pongro', '', NULL, NULL),
  	(161, 20, 'Prek Tanung', '', NULL, NULL),
  	(162, 21, 'Baray', '', NULL, NULL),
  	(163, 21, 'Beung Nay', '', NULL, NULL),
  	(164, 21, 'Chrey Vean', '', NULL, NULL),
  	(165, 21, 'Mean', '', NULL, NULL),
  	(166, 21, 'Trapeang Preah', '', NULL, NULL),
  	(167, 21, 'Khvet Thum', '', NULL, NULL),
  	(168, 21, 'Kor', '', NULL, NULL),
  	(169, 21, 'Krouch', '', NULL, NULL),
  	(170, 21, 'Lvea', '', NULL, NULL),
  	(171, 21, 'Prey Chor', '', NULL, NULL),
  	(172, 21, 'Sor Sen', '', NULL, NULL),
  	(173, 21, 'Somrorng', '', NULL, NULL),
  	(174, 21, 'Sro Ngae', '', NULL, NULL),
  	(175, 21, 'Thma Poun', '', NULL, NULL),
  	(176, 21, 'Tong Rong', '', NULL, NULL),
  	(177, 22, 'Baray', '', NULL, NULL),
  	(178, 22, 'Chibal', '', NULL, NULL),
  	(179, 22, 'Khnar Sor', '', NULL, NULL),
  	(180, 22, 'Koh Andet', '', NULL, NULL),
  	(181, 22, 'Mean Chey', '', NULL, NULL),
  	(182, 22, 'Phteas Kandal', '', NULL, NULL),
  	(183, 22, 'Bram Yam', '', NULL, NULL),
  	(184, 22, 'Prek Dombok', '', NULL, NULL),
  	(185, 22, 'Prek Por', '', NULL, NULL),
  	(186, 22, 'Prek Romdeng', '', NULL, NULL),
  	(187, 22, 'Russey Srok', '', NULL, NULL),
  	(188, 22, 'Svay Por', '', NULL, NULL),
  	(189, 22, 'Svay Ksach Phnom', '', NULL, NULL),
  	(190, 22, 'Torng Trolach', '', NULL, NULL),
  	(191, 23, 'Areak Tnort', '', NULL, NULL),
  	(192, 23, 'Dorng Kdar', '', NULL, NULL),
  	(193, 23, 'Kpob Tangoun', '', NULL, NULL),
  	(194, 23, 'Mesar Chrey', '', NULL, NULL),
  	(195, 23, 'Or Mlou', '', NULL, NULL),
  	(196, 23, 'Peam Koh Sna', '', NULL, NULL),
  	(197, 23, 'Preah Andong', '', NULL, NULL),
  	(198, 23, 'Prek Kork', '', NULL, NULL),
  	(199, 23, 'Sopheas', '', NULL, NULL),
  	(200, 23, 'Toul Preahkhleang', '', NULL, NULL),
  	(201, 23, 'Toul Sombor', '', NULL, NULL),
  	(202, 24, 'Batheay', '', NULL, NULL),
  	(203, 24, 'Chbar Ampov', '', NULL, NULL),
  	(204, 24, 'Chealea', '', NULL, NULL),
  	(205, 24, 'Cheung Prey', '', NULL, NULL),
  	(206, 24, 'Me Pring', '', NULL, NULL),
  	(207, 24, 'Phav', '', NULL, NULL),
  	(208, 24, 'Sambour', '', NULL, NULL),
  	(209, 24, 'Sandaek', '', NULL, NULL),
  	(210, 24, 'Tang Krang', '', NULL, NULL),
  	(211, 24, 'Prasat', '', NULL, NULL),
  	(212, 24, 'Tang Krasang', '', NULL, NULL),
  	(213, 24, 'Trab Roung', '', NULL, NULL),
  	(214, 24, 'Tumnob', '', NULL, NULL),
  	(215, 25, 'Bos Khnaor', '', NULL, NULL),
  	(216, 25, 'Chamkar Andoung', '', NULL, NULL),
  	(217, 25, 'Cheyyou', '', NULL, NULL),
  	(218, 25, 'Lvea Leu', '', NULL, NULL),
  	(219, 25, 'Spueu', '', NULL, NULL),
  	(220, 25, 'Svay Teab', '', NULL, NULL),
  	(221, 25, 'Ta Ong', '', NULL, NULL),
  	(222, 25, 'Ta Prok', '', NULL, NULL),
  	(223, 26, 'Khnaor Dambang', '', NULL, NULL),
  	(224, 26, 'Kouk Rovieng', '', NULL, NULL),
  	(225, 26, 'Phdau Chum', '', NULL, NULL),
  	(226, 26, 'Prey Char', '', NULL, NULL),
  	(227, 26, 'Pring Chrum', '', NULL, NULL),
  	(228, 26, 'Sampong Chey', '', NULL, NULL),
  	(229, 26, 'Sdaeung Chey', '', NULL, NULL),
  	(230, 26, 'Soutip', '', NULL, NULL),
  	(231, 26, 'Srama', '', NULL, NULL),
  	(232, 26, 'Trapeang Kor', '', NULL, NULL),
  	(233, 27, 'Char Chhouk', 'ចារឈូក', NULL, NULL),
  	(234, 27, 'Daun Peng', 'ដូនពេង', NULL, NULL),
  	(235, 27, 'Koak Daung', 'គោកដូង', NULL, NULL),
  	(236, 27, 'Koal', 'គោល', NULL, NULL),
  	(237, 27, 'Nokor Pheas', 'នគរភាស', NULL, NULL),
  	(238, 27, 'Srae Khvav', 'ស្រែខ្វាវ', NULL, NULL),
  	(239, 27, 'Tasoam', 'តាសោម', NULL, NULL),
  	(240, 28, 'Chub Tatrav', 'ជប់តាត្រាវ', NULL, NULL),
  	(241, 28, 'Leang Dai', 'លាងដៃ', NULL, NULL),
  	(242, 28, 'Peak Snaeng', 'ពាក់ស្នែង', NULL, NULL),
  	(243, 28, 'Svay Chek', 'ស្វាយចេក', NULL, NULL),
  	(244, 29, 'Khnar Sanday', 'ខ្នារសណ្តាយ', NULL, NULL),
  	(245, 29, 'Khun Ream', 'ឃុនរាម', NULL, NULL),
  	(246, 29, 'Preak Dak', 'ព្រះដាក់', NULL, NULL),
  	(247, 29, 'Romchek', 'រំចេក', NULL, NULL),
  	(248, 29, 'Run Ta Aek', 'រុនតាឯក', NULL, NULL),
  	(249, 29, 'Tbaeng', 'ត្បែង', NULL, NULL),
  	(250, 30, 'Anlong Samnor', 'អន្លង់សំណរ', NULL, NULL),
  	(251, 30, 'Chi Kraeng', 'ជីក្រែង', NULL, NULL),
  	(252, 30, 'Kampong Kdei', 'កំពង់ក្តី', NULL, NULL),
  	(253, 30, 'Khvav', 'ខ្វាវ', NULL, NULL),
  	(254, 30, 'Koak Thlok Krom', 'គោកធ្លកក្រោម', NULL, NULL),
  	(255, 30, 'Koak Thlok Leu', 'គោកធ្លកលើ', NULL, NULL),
  	(256, 30, 'Lveng Russei', 'ល្វែងឫស្សី', NULL, NULL),
  	(257, 30, 'Pongro Krom', 'ពង្រក្រោម', NULL, NULL),
  	(258, 30, 'Pongro Leu', 'ពង្រលើ', NULL, NULL),
  	(259, 30, 'Russei Lok', 'ឫស្សីលក', NULL, NULL),
  	(260, 30, 'Songveuy', 'សង្វើយ', NULL, NULL),
  	(261, 30, 'Spean Tnoat', 'ស្ពានត្នោត', NULL, NULL),
  	(262, 31, 'Chonleas Dai', 'ជន្លាស់ដៃ', NULL, NULL),
  	(263, 31, 'Kampong Thkov', 'កំពង់ថ្កូវ', NULL, NULL),
  	(264, 31, 'Kralanh', 'ក្រឡាញ់', NULL, NULL),
  	(265, 31, 'Krouch Kor', 'ក្រូចគរ', NULL, NULL),
  	(266, 31, 'Roang Koar', 'រោងគោ', NULL, NULL),
  	(267, 31, 'Sambour', 'សំបួរ', NULL, NULL),
  	(268, 31, 'Sen Sok', 'សែនសុខ', NULL, NULL),
  	(269, 31, 'Snoul', 'ស្នួល', NULL, NULL),
  	(270, 31, 'Sronal', 'ស្រណាល', NULL, NULL),
  	(271, 31, 'Ta An', 'តាអាន', NULL, NULL),
  	(272, 32, 'Sosor Sdom', 'សសរស្តម្', NULL, NULL),
  	(273, 32, 'Daun Keo', 'ដូនកែវ', NULL, NULL),
  	(274, 32, 'Kdei Run', 'ក្តីរុន', NULL, NULL),
  	(275, 32, 'Keo Por', 'កែវពណ៌', NULL, NULL),
  	(276, 32, 'Khnat', 'ខ្នាត', NULL, NULL),
  	(277, 32, 'Lvea', 'ល្វា', NULL, NULL),
  	(278, 32, 'Mukh Paen', 'មុខប៉ែន', NULL, NULL),
  	(279, 32, 'Pou Treay', 'ពោធិទ្រាយ', NULL, NULL),
  	(280, 32, 'Pouk', 'ពួក', NULL, NULL),
  	(281, 32, 'Prey Chrouk', 'ព្រៃជ្រូក', NULL, NULL),
  	(282, 32, 'Reul', 'រើស', NULL, NULL),
  	(283, 32, 'Somroang Yea', 'សំរោងយា', NULL, NULL),
  	(284, 32, 'Treu Nhoar', 'ត្រីញ័រ', NULL, NULL),
  	(285, 32, 'Yeang', 'យាង', NULL, NULL),
  	(286, 32, 'Tuek Vil', 'ទឹកវិល', NULL, NULL),
  	(287, 32, 'Krabei Riel', 'ក្របីរៀល', NULL, NULL),
  	(288, 33, 'Bakong', 'បាគង', NULL, NULL),
  	(289, 33, 'Balangk', 'បល្ល័ង្គ', NULL, NULL),
  	(290, 33, 'Kampong Phluk', 'កំពង់ភ្លុក', NULL, NULL),
  	(291, 33, 'Kantreang', 'កន្ទ្រាំង', NULL, NULL),
  	(292, 33, 'Kandaek', 'កណ្តែក', NULL, NULL),
  	(293, 33, 'Meanchey', 'មានជ័យ', NULL, NULL),
  	(294, 33, 'Rolous', 'រលួស', NULL, NULL),
  	(295, 33, 'Trapeang Thom', 'ត្រពាំងធំ', NULL, NULL),
  	(296, 33, 'Ampil', 'អំពិល', NULL, NULL),
  	(297, 34, 'Slor Kram', 'ស្លក្រាម', NULL, NULL),
  	(298, 34, 'Svay Dongkum', 'ស្វាយដង្គំ', NULL, NULL),
  	(299, 34, 'Koak Chork', 'គោកចក', NULL, NULL),
  	(300, 34, 'Sala Komreuk', 'សាលាកំរើក', NULL, NULL),
  	(301, 34, 'Nokor Thom', 'នគរធំ', NULL, NULL),
  	(302, 34, 'Chreav', 'ជ្រាវ', NULL, NULL),
  	(303, 34, 'Chong Khneas', 'ចុងឃ្នៀស', NULL, NULL),
  	(304, 34, 'Sambour', 'សំបួរ', NULL, NULL),
  	(305, 34, 'Seam Reap', 'សៀមរាប', NULL, NULL),
  	(306, 34, 'Sragnae', 'ស្រង៉ែ', NULL, NULL),
  	(307, 34, 'Ampil', 'អំពិល', NULL, NULL),
  	(308, 34, 'Krabei Real', 'ក្របីរៀល', NULL, NULL),
  	(309, 34, 'Teuk Vil', 'ទឹកវិល', NULL, NULL),
  	(310, 35, 'Chan Sor', 'ចាន់ស', NULL, NULL),
  	(311, 35, 'Dom Daek', 'ដំដែក', NULL, NULL),
  	(312, 35, 'Danrun', 'ដានរុន', NULL, NULL),
  	(313, 35, 'Kampong Khleang', 'កំពង់ឃ្លាំង', NULL, NULL),
  	(314, 35, 'Kean Sangke', 'កៀនសង្កែ', NULL, NULL),
  	(315, 35, 'Khchas', 'ខ្ចាស់', NULL, NULL),
  	(316, 35, 'Khnar Pou', 'ខ្នារពោធិ៍', NULL, NULL),
  	(317, 35, 'Popel', 'ពពេល', NULL, NULL),
  	(318, 35, 'Samroang', 'សំរោង', NULL, NULL),
  	(319, 35, 'Ta Yaek', 'តាយ៉ែក', NULL, NULL),
  	(320, 36, 'Chroy Neang Ngoun', 'ជ្រោយនាងងួន', NULL, NULL),
  	(321, 36, 'Klang Hay', 'ក្លាំងហាយ', NULL, NULL),
  	(322, 36, 'Tram Sosor', 'ត្រាំសសរ', NULL, NULL),
  	(323, 36, 'Moang', 'មោង', NULL, NULL),
  	(324, 36, 'Brey', 'ប្រីយ៍', NULL, NULL),
  	(325, 36, 'Slaeng Spean', 'ស្លែងស្ពាន', NULL, NULL),
  	(326, 37, 'Beung Mealea', 'បឹងមាលា', NULL, NULL),
  	(327, 37, 'Kantout', 'កន្ទួត', NULL, NULL),
  	(328, 37, 'Khnorng Phnum', 'ខ្នងភ្នំ', NULL, NULL),
  	(329, 37, 'Svay Leu', 'ស្វាយលើ', NULL, NULL),
  	(330, 37, 'Ta Seam', 'តាសៀម', NULL, NULL),
  	(331, 38, 'Brasat', 'ប្រាសាទ', NULL, NULL),
  	(332, 38, 'Lvea Krang', 'ល្វាក្រាំង', NULL, NULL),
  	(333, 38, 'Srae Noy', 'ស្រែណូយ', NULL, NULL),
  	(334, 38, 'Svay Sor', 'ស្វាយស', NULL, NULL),
  	(335, 38, 'Varin', 'វ៉ារិន', NULL, NULL),
  	(336, 39, 'Kantueu Muoy', 'កន្ទឺ ១', NULL, NULL),
  	(337, 39, 'Kantueu Pir', 'កន្ទឺ ២', NULL, NULL),
  	(338, 39, 'Bay Damram', 'បាយដំរាំ', NULL, NULL),
  	(339, 39, 'Chheu Teal', '	ឈើទាល', NULL, NULL),
  	(340, 39, 'Chaeng Mean Chey', 'ចែងមានជ័យ', NULL, NULL),
  	(341, 39, 'Phnum Sampov', 'ភ្នំសំពៅ', NULL, NULL),
  	(342, 39, 'Snoeng', 'ស្នឹង', NULL, NULL),
  	(343, 39, 'Ta Kream', 'តាគ្រាម', NULL, NULL),
  	(344, 40, 'Ta Pung', 'តាពូង', NULL, NULL),
  	(345, 40, 'តាម៉ឺន', 'Ta Meun', NULL, NULL),
  	(346, 40, 'Ou Ta Ki', 'អូរតាគី', NULL, NULL),
  	(347, 40, 'Chrey', 'ជ្រៃ', NULL, NULL),
  	(348, 40, 'Anlong Run', 'អន្លង់រុន', NULL, NULL),
  	(349, 40, 'Chrouy Sdau', 'ជ្រោយស្តៅ', NULL, NULL),
  	(350, 40, 'Boeng Pring', 'បឹងព្រីង', NULL, NULL),
  	(351, 40, 'Kouk Khmum', 'គោកឃ្មុំ', NULL, NULL),
  	(352, 40, 'Bansay Traeng', 'បន្សាយត្រែង', NULL, NULL),
  	(353, 40, 'Rung Chrey', 'រូងជ្រៃ', NULL, NULL),
  	(354, 41, 'Tuol Ta Aek', 'ទួលតាឯក', NULL, NULL),
  	(355, 41, 'Preaek Preah Sdach', 'ព្រែកព្រះស្តេច', NULL, NULL),
  	(356, 41, 'Rotanak', 'រតនៈ', NULL, NULL),
  	(357, 41, 'Chamkar Samraong', 'ចំការសំរោង', NULL, NULL),
  	(358, 41, 'Sla Kaet', 'ស្លាកែត', NULL, NULL),
  	(359, 41, 'Kdol Doun Teav', 'ក្តុលដូនទាវ', NULL, NULL),
  	(360, 41, 'Ou Mal', 'អូរម៉ាល់', NULL, NULL),
  	(361, 41, 'Voat Kor', 'វត្តគរ', NULL, NULL),
  	(362, 41, 'Ou Char', 'អូរចារ', NULL, NULL),
  	(363, 41, 'Svay Pao', 'ស្វាយប៉ោ', NULL, NULL),
  	(364, 42, 'Bavel', 'បវេល', NULL, NULL),
  	(365, 42, 'Khnach Romeas', 'ខ្នាចរមាស', NULL, NULL),
  	(366, 42, 'Lvea', 'ល្វា', NULL, NULL),
  	(367, 42, 'Prey Khpos', 'ព្រៃខ្ពស់', NULL, NULL),
  	(368, 42, 'Ampil Pram Daeum', 'អំពិលប្រាំដើម', NULL, NULL),
  	(369, 42, 'Kdol Tahen', 'ក្តុលតាហែន', NULL, NULL),
  	(370, 42, 'Khlang meas', 'ខ្លាំងមាស', NULL, NULL),
  	(371, 42, 'Boeng pram', 'បឹងប្រាំ', NULL, NULL),
  	(372, 43, 'Preaek Norint', 'ព្រែកនរិន្ទ', NULL, NULL),
  	(373, 43, 'Samraong Knong', 'សំរោងក្នុង', NULL, NULL),
  	(374, 43, 'Preaek Khpob', 'ព្រែកខ្ពប', NULL, NULL),
  	(375, 43, 'Preaek Luong', 'ព្រែកហ្លួង', NULL, NULL),
  	(376, 43, 'Peam Aek', 'ពាមឯក', NULL, NULL),
  	(377, 43, 'Prey Chas', 'ព្រៃចាស់', NULL, NULL),
  	(378, 43, 'Kaoh Chiveang Thvang', 'កោះជីវាំង', NULL, NULL),
  	(379, 44, 'Moung', 'មោង', NULL, NULL),
  	(380, 44, 'Kear', 'គារ', NULL, NULL),
  	(381, 44, 'Prey Svay', 'ព្រៃស្វាយ', NULL, NULL),
  	(382, 44, 'Ruessei Krang', 'ឫស្សីក្រាំង', NULL, NULL),
  	(383, 44, 'Chrey', 'ជ្រៃ', NULL, NULL),
  	(384, 44, 'Ta Loas', 'តាលាស់', NULL, NULL),
  	(385, 44, 'Kakaoh', 'កកោះ', NULL, NULL),
  	(386, 44, 'Prey Touch', 'ព្រៃតូច', NULL, NULL),
  	(387, 44, 'Robas Mongkol', 'របស់មង្គល', NULL, NULL),
  	(388, 44, 'Break Chek', 'ព្រែកជីក', NULL, NULL),
  	(389, 44, 'Prey Trolach', 'ព្រៃត្រឡាច', NULL, NULL),
  	(390, 45, 'Sdau', 'ស្តៅ', NULL, NULL),
  	(391, 45, 'Andaeuk Haeb', 'អណ្តើកហែប', NULL, NULL),
  	(392, 45, 'Phlov Meas', 'ផ្លូវមាស', NULL, NULL),
  	(393, 45, 'Traeng', 'ត្រែង', NULL, NULL),
  	(394, 45, 'Reaksmey Sangha', 'រស្មីសង្ហារ', NULL, NULL),
  	(395, 46, 'Anlong Vil', 'អន្លង់វិល', NULL, NULL),
  	(396, 46, 'Norea', 'នរា', NULL, NULL),
  	(397, 46, 'Ta Pon', 'តាប៉ុន', NULL, NULL),
  	(398, 46, 'Roka', 'រកា', NULL, NULL),
  	(399, 46, 'Kampong Preah', 'កំពង់ព្រះ', NULL, NULL),
  	(400, 46, 'Kampong Prieng', 'កំពង់ព្រៀង', NULL, NULL),
  	(401, 46, 'Reang Kesei', 'រាំងកេសី', NULL, NULL),
  	(402, 46, 'Ou Dambang Muoy', 'អូរដំបង ១', NULL, NULL),
  	(403, 46, 'Ou Dambang Pir', 'អូរដំបង ២', NULL, NULL),
  	(404, 46, 'Vaot Ta Muem', 'វត្តតាមិម', NULL, NULL),
  	(405, 47, 'Ta Taok', 'តាតោក', NULL, NULL),
  	(406, 47, 'Kampong Lpou', 'កំពង់ល្ពៅ', NULL, NULL),
  	(407, 47, 'Ou Samrel', 'អូរសំរិល', NULL, NULL),
  	(408, 47, 'Sung', 'ស៊ុង', NULL, NULL),
  	(409, 47, 'Samlout', 'សំឡូត', NULL, NULL),
  	(410, 47, 'Mean Cheay', 'មានជ័យ', NULL, NULL),
  	(411, 47, 'Ta Sanh', 'តាសាញ', NULL, NULL),
  	(412, 48, 'Sampou Lun', 'សំពៅលូន', NULL, NULL),
  	(413, 48, 'Angkor Ban', 'អង្គរបាន', NULL, NULL),
  	(414, 48, 'Ta Sda', 'តាសា្ត', NULL, NULL),
  	(415, 48, 'Santepheap', 'សន្តិភាព', NULL, NULL),
  	(416, 48, 'Serei Maen Cheay', 'សិរីមានជ័យ', NULL, NULL),
  	(417, 48, 'Chrey Sema', 'ជ្រៃសីមា', NULL, NULL),
  	(418, 49, 'Phnum Proek', 'ភ្នំព្រឹក', NULL, NULL),
  	(419, 49, 'Pech Chenda', 'ពេជ្រចិន្តា', NULL, NULL),
  	(420, 49, 'Bou', 'បួរ', NULL, NULL),
  	(421, 49, 'Barang Thleak', 'បារាំងធ្លាក់', NULL, NULL),
  	(422, 49, 'Ou Rumduol', 'អូររំដួល', NULL, NULL),
  	(423, 50, 'Kamrieng', 'កំរៀង', NULL, NULL),
  	(424, 50, 'Boeng Reang', 'បឹងរាំង', NULL, NULL),
  	(425, 50, 'Ou Da', 'អូរដា', NULL, NULL),
  	(426, 50, 'Trang', 'ត្រាង', NULL, NULL),
  	(427, 50, 'Ta Saen', 'តាសែន', NULL, NULL),
  	(428, 50, 'Ta Krai', 'តាក្រី', NULL, NULL),
  	(429, 51, 'Thipakdei', 'ធិបតី', NULL, NULL),
  	(430, 51, 'Koas Krala', 'គាស់ក្រឡ', NULL, NULL),
  	(431, 51, 'Hab', 'ហប់', NULL, NULL),
  	(432, 51, 'Preah Phos', 'ព្រះផុស', NULL, NULL),
  	(433, 51, 'Doun Ba', 'ដូនបា', NULL, NULL),
  	(434, 51, 'Chhnal Moan', 'ឆ្នាល់មាន់', NULL, NULL),
  	(435, 52, 'Prek chik', 'ព្រែកជីក', NULL, NULL),
  	(436, 52, 'prey trolach', 'ព្រៃត្រឡាច', NULL, NULL),
  	(437, 52, 'Basak', 'បាសាក', NULL, NULL),
  	(438, 52, 'Mukrea', 'មុគគ្រា', NULL, NULL),
  	(439, 52, 'Sduk Provek', 'ស្តុកផ្រូវិក', NULL, NULL),
  	(440, 53, 'Ampov Prey', 'អំពៅព្រៃ', NULL, NULL),
  	(441, 53, 'Anlong Romiet', 'អន្លង់រមៀត', NULL, NULL),
  	(442, 53, 'Barku', 'បាគូ', NULL, NULL),
  	(443, 53, 'Boeng Khyang', 'បឹងខ្យាង', NULL, NULL),
  	(444, 53, 'Cheung Kaeub', 'ជើងកើប', NULL, NULL),
  	(445, 53, 'Daeum Rues', 'ដើមឫស', NULL, NULL),
  	(446, 53, 'Kandaok', 'កណ្តោក', NULL, NULL),
  	(447, 53, 'Thmei', 'ថ្មី', NULL, NULL),
  	(448, 53, 'Kouk Trab', 'គោកត្រប់', NULL, NULL),
  	(449, 53, 'Preah Putth', 'ព្រះពុទ្ធ', NULL, NULL),
  	(450, 53, 'Preaek Roka', 'ព្រែករកា', NULL, NULL),
  	(451, 53, 'Preaek Slaeng', 'ព្រែកស្លែង', NULL, NULL),
  	(452, 53, 'Roka', 'រកា', NULL, NULL),
  	(453, 53, 'Roleang Kaen', 'រលាំងកែន', NULL, NULL),
  	(454, 53, 'Siem Reab', 'សៀមរាប', NULL, NULL),
  	(455, 53, 'Tbaeng', 'ត្បែងទៀន', NULL, NULL),
  	(456, 53, 'Trapeang Veaeng', 'ត្រពាំងវែង', NULL, NULL),
  	(457, 53, 'Trea', 'ទ្រា', NULL, NULL),
  	(458, 54, 'Chheu Kmau', 'ឈើខ្មៅ', NULL, NULL),
  	(459, 54, 'Chrouy Ta Kae', 'ជ្រោយតាកែវ', NULL, NULL),
  	(460, 54, 'Kampong Kong', 'កំពង់កុង', NULL, NULL),
  	(461, 54, 'Kaoh Thum Ka', 'កោះធំ ក', NULL, NULL),
  	(462, 54, 'Kaoh Thum Kha', 'កោះធំ ខ', NULL, NULL),
  	(463, 54, 'Leuk Daek', 'លើកដែក', NULL, NULL),
  	(464, 54, 'Pouthi Ban', 'ពោធិ៍បាន', NULL, NULL),
  	(465, 54, 'Prea​ek Chrey', 'ព្រែកជ្រៃ', NULL, NULL),
  	(466, 54, 'Preaek Sdei', 'ព្រែកស្ដី', NULL, NULL),
  	(467, 54, 'Preaek Thmei', 'ព្រែកថ្មី', NULL, NULL),
  	(468, 54, 'Sampeou Poun', 'សំពៅពូន', NULL, NULL),
  	(469, 55, 'Praek Anchanh', 'ព្រែកអញ្ចាញ', NULL, NULL),
  	(470, 55, 'Praek Dombong', 'ព្រែកដំបង', NULL, NULL),
  	(471, 55, 'Rokakoang Ti Mouy', 'រកាកោងទី១', NULL, NULL),
  	(472, 55, 'Rokakoang Ti Pir', 'រកាកោងទី២', NULL, NULL),
  	(473, 55, 'Russei Chroay', 'ឫស្សីជ្រោយ', NULL, NULL),
  	(474, 55, 'Sambour Meas', 'សំបួរមាស', NULL, NULL),
  	(475, 55, 'Svay Ampear', 'ស្វាយអំពារ', NULL, NULL),
  	(476, 56, 'Khpob', 'ខ្ពប', NULL, NULL),
  	(477, 56, 'Kaoh Anlong Chen', 'កោះអន្លង់ចិន', NULL, NULL),
  	(478, 56, 'Kaoh Khael', 'កោះខែល', NULL, NULL),
  	(479, 56, 'Kaoh Khsach Tonlea', 'កោះខ្សាច់ទន្លា', NULL, NULL),
  	(480, 56, 'Krang Yov', 'ក្រាំងយ៉ូវ', NULL, NULL),
  	(481, 56, 'Prasat', 'ប្រាសាទ', NULL, NULL),
  	(482, 56, 'Preaek Ambel', 'ព្រែអំបិល', NULL, NULL),
  	(483, 56, 'Preaek Koy', 'ព្រែកគយ', NULL, NULL),
  	(484, 56, 'Roka Khpos', 'រកាខ្ពស់', NULL, NULL),
  	(485, 56, 'Sa ang Phnum', 'ស្អាងភ្នំ', NULL, NULL),
  	(486, 56, 'Setbou', 'សិត្បូ', NULL, NULL),
  	(487, 56, 'Svay Prateal', 'ស្វាយប្រទាល', NULL, NULL),
  	(488, 56, 'Svay Rolum', 'ស្វាយរលំ', NULL, NULL),
  	(489, 56, 'Ta Lon', 'តាលន់', NULL, NULL),
  	(490, 56, 'Traeuy Sla', 'ត្រើយស្លា', NULL, NULL),
  	(491, 56, 'Tuek Vil', 'ទឹកវិល', NULL, NULL),
  	(492, 57, 'Kampong Phnum', 'កំពង់ភ្នំ', NULL, NULL),
  	(493, 57, 'K am Samnar', 'ក្អមសំណ', NULL, NULL),
  	(494, 57, 'Khpob Ateav', 'ខ្ពបអាទាវ', NULL, NULL),
  	(495, 57, 'Peam Reang ', 'ពាមរាំង', NULL, NULL),
  	(496, 57, 'Preaek Dach', 'ព្រែកដាច់', NULL, NULL),
  	(497, 57, 'Preaek Tonloab', 'ព្រែកទន្លាប់', NULL, NULL),
  	(498, 57, 'Sandar', 'សណ្ដារ', NULL, NULL),
  	(499, 58, 'Ta Kdol', 'តាក្ដុល', NULL, NULL),
  	(500, 58, 'Prek Ruessey', 'ព្រែកឫស្សី', NULL, NULL),
  	(501, 58, 'Doeum Mien', 'ដើមមៀន', NULL, NULL),
  	(502, 58, 'Ta Khmao', 'តាខ្មៅ', NULL, NULL),
  	(503, 58, 'Prek Ho', 'ព្រែកហូរ', NULL, NULL),
  	(504, 58, 'Kampong Samnanh', 'កំពង់សំណាញ់', NULL, NULL),
  	(505, 58, 'Svay Rolum', 'ស្វាយរលំ', NULL, NULL),
  	(506, 58, 'Setbou', 'សិត្បូ', NULL, NULL),
  	(507, 58, 'Roka Kpos', 'រកាខ្ពស់', NULL, NULL),
  	(508, 58, 'Khosh Anlong Chien', 'កោះអន្លង់ចិន', NULL, NULL),
  	(509, 59, 'Banteay Daek', 'បន្ទាយដែក', NULL, NULL),
  	(510, 59, 'Chheu Teal', 'ឈើទាល', NULL, NULL),
  	(511, 59, 'Dei Edth', 'ដីឥដ្ឋ', NULL, NULL),
  	(512, 59, 'Kampong Svay', 'កំពង់ស្វាយ', NULL, NULL),
  	(513, 59, 'Kokir', 'គគីរ', NULL, NULL),
  	(514, 59, 'Kokir Thum', 'គគីរធំ', NULL, NULL),
  	(515, 59, 'Phum Thum', 'ភូមិធំ', NULL, NULL),
  	(516, 59, 'Samraong Thum', 'សំរោងធំ', NULL, NULL),
  	(517, 60, 'Chhveang', 'ឈ្វាំង', NULL, NULL),
  	(518, 60, 'Chrey Loas', 'ជ្រៃលាស់', NULL, NULL),
  	(519, 60, 'Kampong Luong', 'កំពង់ហ្លួង', NULL, NULL),
  	(520, 60, 'Kampong Os', 'កំពង់អុស', NULL, NULL),
  	(521, 60, 'Kaoh Chen', 'កោះចិន', NULL, NULL),
  	(522, 60, 'Phnum Bat', 'ភ្នំបាត', NULL, NULL),
  	(523, 60, 'Ponhea Lueu', 'ពញាឮ', NULL, NULL),
  	(524, 60, 'Preaek Ta Teaen', 'ព្រែកតាទែន', NULL, NULL),
  	(525, 60, 'Vihear Luong', 'ផ្សារដែក', NULL, NULL),
  	(526, 60, 'Tumnob Thum', 'ទំនប់ធំ', NULL, NULL),
  	(527, 60, 'Vihear Luong', 'វិហារហ្លួង', NULL, NULL),
  	(528, 61, 'Ariyaksatr', 'អរិយក្សត្រ', NULL, NULL),
  	(529, 61, 'Barong', 'បារុង', NULL, NULL),
  	(530, 61, 'Beung Krum', 'បឹងគ្រំ', NULL, NULL),
  	(531, 61, 'Koh Keo', 'កោះកែវ', NULL, NULL),
  	(532, 61, 'Koh Reah', 'កោះរះ', NULL, NULL),
  	(533, 61, 'Lvea Sor', 'ល្វាសរ', NULL, NULL),
  	(534, 61, 'Peam Okhna Ong', 'ពាមឧកញ៉ាអុង', NULL, NULL),
  	(535, 61, 'Phum Thom', 'ភូមិធំ', NULL, NULL),
  	(536, 61, 'Praek Kmeng', 'ព្រែកក្មេង', NULL, NULL),
  	(537, 61, 'Praek Rey', 'ព្រែករៃ', NULL, NULL),
  	(538, 61, 'Praek Russei', 'ព្រែកឫស្សី', NULL, NULL),
  	(539, 61, 'Sombour', 'សំបួរ', NULL, NULL),
  	(540, 61, 'Sarikakeo', 'សារិកាកែវ', NULL, NULL),
  	(541, 61, 'Thma Kor', 'ថ្មគរ', NULL, NULL),
  	(542, 61, 'Teuk Khleang', 'ទឹកឃ្លាំង', NULL, NULL),
  	(543, 62, 'Bak Dav', 'បាក់ដាវ', NULL, NULL),
  	(544, 62, 'Chey Thum', 'ជ័យធំ', NULL, NULL),
  	(545, 62, 'Kampong Chamlang', 'កំពង់ចំលង', NULL, NULL),
  	(546, 62, 'Kaoh Chouram', 'កោះចូរ៉ាម', NULL, NULL),
  	(547, 62, 'Kaoh Oknha Tei', 'កោះឧកញ៉ាតី', NULL, NULL),
  	(548, 62, 'Preah Prasab', 'ព្រះប្រសប់', NULL, NULL),
  	(549, 62, 'Preaek Ampil', 'ព្រែកអំពិល', NULL, NULL),
  	(550, 62, '	Preaek Luong', 'ព្រែកលួង', NULL, NULL),
  	(551, 62, 'Preaek Ta Kov', 'ព្រែកតាកូវ', NULL, NULL),
  	(552, 62, 'Preaek Ta Meak', 'ព្រែកតាមាក់', NULL, NULL),
  	(553, 62, 'Puk Ruessei', 'ពុកឫស្សី', NULL, NULL),
  	(554, 62, 'Roka Chonlueng', 'រកាជន្លឹង', NULL, NULL),
  	(555, 62, 'Sanlung', 'សន្លុង', NULL, NULL),
  	(556, 62, 'Sithor', 'ស៊ីធរ', NULL, NULL),
  	(557, 62, 'Svay Chrum', 'ស្វាយជ្រុំ', NULL, NULL),
  	(558, 62, 'Svay Romiet', 'ស្វាយរមៀត', NULL, NULL),
  	(559, 62, 'Ta Aek', 'តាឯក', NULL, NULL),
  	(560, 62, 'Vihear Suork', 'វិហារសួគ៌', NULL, NULL),
  	(561, 88, 'Bak Sna', 'បាក់ស្នា', NULL, NULL),
  	(562, 88, 'Ballangk', 'បល្ល័ង្ក', NULL, NULL),
  	(563, 88, 'Baray', 'បារាយណ៍', NULL, NULL),
  	(564, 88, 'Boeng', 'បឹង', NULL, NULL),
  	(565, 88, 'Chaeung Daeung', 'ចើងដើង', NULL, NULL),
  	(566, 88, 'Chraneang', 'ច្រនាង', NULL, NULL),
  	(567, 88, 'Chhuk Khsach', 'ឈូកខ្សាច់', NULL, NULL),
  	(568, 88, 'Chong Doung', 'ចុងដូង', NULL, NULL),
  	(569, 88, 'Chrolong', 'ជ្រលង', NULL, NULL),
  	(570, 88, 'Kokir Thum ', 'គគីធំ', NULL, NULL),
  	(571, 88, 'Krava', 'ក្រវ៉ា', NULL, NULL),
  	(572, 88, 'Andoung Pou', 'អណ្ដូងពោធិ៍', NULL, NULL),
  	(573, 88, 'Pongro', 'ពង្រ', NULL, NULL),
  	(574, 88, 'Sou Young', 'សូយោង', NULL, NULL),
  	(575, 88, 'Sralau', 'ស្រឡៅ', NULL, NULL),
  	(576, 88, 'Svay Phleung', 'ស្វាយភ្លើង', NULL, NULL),
  	(577, 88, 'Tnaot Chum', 'ត្នោតជុំ', NULL, NULL),
  	(578, 88, 'Triel', 'ទ្រៀល', NULL, NULL),
  	(579, 89, 'Damrei Choan Khla', 'ដំរីជាន់ខ្លា', NULL, NULL),
  	(580, 89, 'Kampong Thum', 'កំពង់ធំ', NULL, NULL),
  	(581, 89, 'Kampong Roteh', 'កំពង់រទេះ', NULL, NULL),
  	(582, 89, 'Ou Kanthor', 'អូរកន្ធរ', NULL, NULL),
  	(583, 89, 'Kampong', 'កំពង់ក្របៅ', NULL, NULL),
  	(584, 89, 'Prey Ta Hu', 'ព្រៃតាហ៊ូ', NULL, NULL),
  	(585, 89, 'Achar Leak', 'អាចារ្យលាក់', NULL, NULL),
  	(586, 89, 'Srayov', 'ស្រយ៉ូវ', NULL, NULL),
  	(587, 90, 'Chheu Teal ', 'ឈើទាល', NULL, NULL),
  	(588, 90, 'Dang Kambet', 'ដងកាំបិត', NULL, NULL),
  	(589, 90, 'Klaeng ', 'ក្លែង', NULL, NULL),
  	(590, 90, 'Mean Rith', 'មានរិទ្ធ', NULL, NULL),
  	(591, 90, 'Mean Chey', 'មានជ័យ', NULL, NULL),
  	(592, 90, 'Ngan ', 'ងន', NULL, NULL),
  	(593, 90, 'Sandan', 'សណ្ដាន់', NULL, NULL),
  	(594, 90, 'Sochet', 'សុចិត្រ', NULL, NULL),
  	(595, 90, 'Tum Ring', 'ទំរីង', NULL, NULL),
  	(596, 91, 'Banteay Stoung', 'បន្ទាយស្ទោង', NULL, NULL),
  	(597, 91, 'Chamna Kraom', 'ចំណាក្រោម', NULL, NULL),
  	(598, 91, 'Chamna Leu', 'ចំណាលើ', NULL, NULL),
  	(599, 91, 'Kampong Chen Cheung', 'កំពង់ចិនជើង', NULL, NULL),
  	(600, 91, 'Msa Krang', 'ម្សាក្រង', NULL, NULL),
  	(601, 91, 'Peam Bang', 'ពាមបាង', NULL, NULL),
  	(602, 91, 'Pralay', 'ប្រឡាយ', NULL, NULL),
  	(603, 91, 'Preah Damrei', 'ព្រះដំរី', NULL, NULL),
  	(604, 91, 'Rung Roeang', 'រុងរឿង', NULL, NULL),
  	(605, 91, 'Samprouch', 'សំព្រោជ', NULL, NULL),
  	(606, 91, 'Trea', 'ទ្រា', NULL, NULL),
  	(607, 92, 'Doung ', 'ដូង', NULL, NULL),
  	(608, 92, 'Kraya ', 'ក្រយា', NULL, NULL),
  	(609, 92, 'Phan Nheum', 'ផាន់ញើម', NULL, NULL),
  	(610, 92, 'Sakream ', 'សាគ្រាម', NULL, NULL),
  	(611, 92, 'Sala Visai', 'សាលាវិស័យ', NULL, NULL),
  	(612, 92, 'Sameakki', 'សាមគ្គី', NULL, NULL),
  	(613, 92, 'Tuol Kreul', 'ទួលគ្រើល', NULL, NULL),
  	(614, 93, 'Boeng Lvea', 'បឹងល្វា', NULL, NULL),
  	(615, 93, 'Chroab ', 'ជ្រាប់', NULL, NULL),
  	(616, 93, 'Kampong Thma ', 'កំពង់ថ្ម', NULL, NULL),
  	(617, 93, '	Kakaoh ', 'កកោះ', NULL, NULL),
  	(618, 93, 'Kraya ', 'ក្រយា', NULL, NULL),
  	(619, 93, 'Pnov ', 'ព្នៅ', NULL, NULL),
  	(620, 93, 'Prasat ', 'ប្រាសាទ', NULL, NULL),
  	(621, 93, 'Tang Krasang', 'តាំងក្រសាំង', NULL, NULL),
  	(622, 93, 'Ti Pou', 'ទីពោ', NULL, NULL),
  	(623, 93, 'Tboung Krapeu', 'ត្បូងក្រពើ', NULL, NULL),
  	(624, 94, 'Chhuk', 'ឈូក', NULL, NULL),
  	(625, 94, 'Koul', 'គោល', NULL, NULL),
  	(626, 94, 'Sambour', 'សំបូរណ៍', NULL, NULL),
  	(627, 94, 'Sraeung', 'ស្រើង', NULL, NULL),
  	(628, 94, 'Tang Krasau', 'តាំងក្រសៅ', NULL, NULL),
  	(629, 95, 'Chey', 'ជ័យ', NULL, NULL),
  	(630, 95, 'Damrei Slab', 'ដំរីស្លាប់', NULL, NULL),
  	(631, 95, 'Kampong Kou', 'កំពង់គោ', NULL, NULL),
  	(632, 95, 'Kampong Svay', 'កំពង់ស្វាយ', NULL, NULL),
  	(633, 95, 'Nipech', 'នីពេជ', NULL, NULL),
  	(634, 95, 'Phat Sanday', 'ផាត់សណ្ដាយ', NULL, NULL),
  	(635, 95, 'San Kor', 'សាន់គ', NULL, NULL),
  	(636, 95, 'Tbaeng', 'ត្បែង', NULL, NULL),
  	(637, 95, 'Trapeang', 'ត្រពាំងឫស្សី', NULL, NULL),
  	(638, 95, 'Kdei Doung', 'ក្ដីដូង', NULL, NULL),
  	(639, 95, 'Prey Kuy', 'ព្រៃគុយ', NULL, NULL),
  	(640, 114, 'Chhlong', 'ឆ្លូង', NULL, NULL),
  	(641, 114, 'Domrei Phong', 'ដំរីផុង', NULL, NULL),
  	(642, 114, 'Han Chey', 'ហាន់ជ័យ', NULL, NULL),
  	(643, 114, 'Kampong Domrei', 'កំពង់ដំរី', NULL, NULL),
  	(644, 114, 'Kanhchor', 'កញ្ជរ', NULL, NULL),
  	(645, 114, 'Ksach Andaet', 'ខ្សាច់អណ្ដែត', NULL, NULL),
  	(646, 114, 'Pongro', 'ពង្រ', NULL, NULL),
  	(647, 114, 'Praek Samann', 'ព្រែកសាម៉ាន់', NULL, NULL),
  	(648, 115, 'Kantout', 'កន្ទួត', NULL, NULL),
  	(649, 115, 'Thma Andeuk', 'ថ្មអណ្តើក', NULL, NULL),
  	(650, 115, 'Koh Chraeng', 'កោះច្រែង', NULL, NULL),
  	(651, 115, 'Sambok', 'សំបុក', NULL, NULL),
  	(652, 115, 'Kou Lorb', 'គោលាប់', NULL, NULL),
  	(653, 115, 'Thmei', 'ថ្មី', NULL, NULL),
  	(654, 115, 'Dar', 'ដា', NULL, NULL),
  	(655, 115, 'Bos Leav', 'បុសលាវ', NULL, NULL),
  	(656, 115, 'Changkrorng', 'ចង្ក្រង់', NULL, NULL),
  	(657, 115, 'Thma Krae', 'ថ្មគ្រែ', NULL, NULL),
  	(658, 116, 'Koh Trorng', 'កោះត្រង់', NULL, NULL),
  	(659, 116, 'Krokor', 'ក្រកូរ', NULL, NULL),
  	(660, 116, 'Kratie', 'ក្រចេះ', NULL, NULL),
  	(661, 116, 'Ou Russei', 'អូរឬស្សី', NULL, NULL),
  	(662, 116, 'Roka Kandal', 'រកាកណ្តាល', NULL, NULL),
  	(663, 117, 'Kbal Domrei', 'ក្បាលដំរី', NULL, NULL),
  	(664, 117, 'Koh Knhae', 'កោះខ្ញែរ', NULL, NULL),
  	(665, 117, 'Ou Kreang', 'អូរគ្រៀង', NULL, NULL),
  	(666, 117, 'Rolous Meanchey', 'រលួសមានជ័យ', NULL, NULL),
  	(667, 117, 'Kampong Cham', 'កំពង់ចាម', NULL, NULL),
  	(668, 117, 'Beung Char', 'បឹងចារ', NULL, NULL),
  	(669, 117, 'Sombo', 'សំបូរ', NULL, NULL),
  	(670, 117, 'Sandann', 'សណ្តាន់', NULL, NULL),
  	(671, 117, 'Srae Chis', 'ស្រែជិះ', NULL, NULL),
  	(672, 117, 'Vadhnak', 'វឌ្ឍនៈ', NULL, NULL),
  	(673, 118, 'Chambok', 'ចំបក់', NULL, NULL),
  	(674, 118, 'Chroy Banteay', 'ជ្រោយបន្ទាយ', NULL, NULL),
  	(675, 118, 'Kampong Kor', 'កំពង់គរ', NULL, NULL),
  	(676, 118, 'Praek Brosop', 'ព្រែកប្រសព្', NULL, NULL),
  	(677, 118, 'Russei Keo', 'ឫស្សីកែវ', NULL, NULL),
  	(678, 118, 'Soab', 'សោប', NULL, NULL),
  	(679, 118, 'Tamao', 'តាម៉ៅ', NULL, NULL),
  	(680, 119, 'Khseum', 'ឃ្សឹម', NULL, NULL),
  	(681, 119, 'Pir Thnou', 'ពីរធ្នូ', NULL, NULL),
  	(682, 119, 'Snoul', 'ស្នួល', NULL, NULL),
  	(683, 119, 'Srae Char', 'ស្រែចារ', NULL, NULL),
  	(684, 119, 'Svay Chreas', 'ស្វាយជ្រះ', NULL, NULL),
  	(685, 133, 'Sa ang', 'ស្អាង', NULL, NULL),
  	(686, 133, 'Tor Sou', 'តស៊ូ', NULL, NULL),
  	(687, 133, 'Kchorng', 'ខ្យង', NULL, NULL),
  	(688, 133, 'Chrach', 'ច្រាច់', NULL, NULL),
  	(689, 133, 'Thmea', 'ធ្មា', NULL, NULL),
  	(690, 133, 'Putrea', 'ពុទ្រា', NULL, NULL),
  	(691, 134, 'ស្រអែម', 'ជាំក្សាន្ត', NULL, NULL),
  	(692, 134, 'Teuk Krahorm', 'ទឹកក្រហម', NULL, NULL),
  	(693, 134, 'Pring Thom', 'ព្រីងធំ', NULL, NULL),
  	(694, 134, 'Romdoh Srae', 'រំដោះស្រែ', NULL, NULL),
  	(695, 134, 'Yeang', 'យាង', NULL, NULL),
  	(696, 134, 'Kantout', 'កន្ទួត', NULL, NULL),
  	(697, 134, 'Sraem', 'ស្រអែម', NULL, NULL),
  	(698, 134, 'Morodok', 'មរតក', NULL, NULL),
  	(699, 135, 'Robeab', 'របៀប', NULL, NULL),
  	(700, 135, 'Reaksmey', 'រស្មី', NULL, NULL),
  	(701, 135, 'Rohas', 'រហ័ស', NULL, NULL),
  	(702, 135, 'Rong Reung', 'រុងរឿង', NULL, NULL),
  	(703, 135, 'Rik Reay', 'រីករាយ', NULL, NULL),
  	(704, 135, 'Rous Roan', 'រួសរាន់', NULL, NULL),
  	(705, 135, 'Ratanak', 'រតនៈ', NULL, NULL),
  	(706, 135, 'Reab Roay', 'រៀបរយ', NULL, NULL),
  	(707, 135, 'Reaksa', 'រក្សា', NULL, NULL),
  	(708, 135, 'Romdors', 'រំដោះ', NULL, NULL),
  	(709, 135, 'Rumtum', 'រមទម', NULL, NULL),
  	(710, 135, 'Romniy', 'រម្មណីយ', NULL, NULL),
  	(711, 136, 'Ro ang', 'រអាង', NULL, NULL),
  	(712, 136, 'Phnom Tbeng Mouy', 'ភ្នំត្បែងមួយ', NULL, NULL),
  	(713, 136, 'Sdao', 'ស្តៅ', NULL, NULL),
  	(714, 136, 'Ranakseh', 'រណសិរ្ស', NULL, NULL),
  	(715, 136, 'Chomreun', 'ចំរើន', NULL, NULL),
  	(716, 137, 'Chhaeb Mouy', 'ឆែបមួយ', NULL, NULL),
  	(717, 137, 'Chhaeb Pir', 'ឆែបពីរ', NULL, NULL),
  	(718, 137, 'Sangke Mouy', 'សង្កែមួយ', NULL, NULL),
  	(719, 137, 'Sangke Pir', 'សង្កែពីរ', NULL, NULL),
  	(720, 137, 'Mlouprey Mouy', 'ម្លូព្រៃមួយ', NULL, NULL),
  	(721, 137, 'Mlouprey Pir', 'ម្លូព្រៃពីរ', NULL, NULL),
  	(722, 137, 'Kampong Sralao Mouy', 'កំពង់ស្រឡៅមួយ', NULL, NULL),
  	(723, 137, 'Kampong Sralao Pir', 'កំពង់ស្រឡៅពីរ', NULL, NULL),
  	(724, 138, 'Kulen Tbong', 'គូលែនត្បូង', NULL, NULL),
  	(725, 138, 'Kulen Cheung', 'គូលែនជើង', NULL, NULL),
  	(726, 138, 'Thmei', 'ថ្មី', NULL, NULL),
  	(727, 138, 'Phnom Penh', 'ភ្នំពេញ', NULL, NULL),
  	(728, 138, 'Phnom Tbeng Pir', 'ភ្នំត្បែងពីរ', NULL, NULL),
  	(729, 138, 'Sroyong', 'ស្រយង់', NULL, NULL),
  	(730, 139, 'Kompong bronouk', 'កំពង់ប្រណោក', NULL, NULL),
  	(731, 139, 'Bal Hal', 'ប៉ាលហាល', NULL, NULL),
  	(732, 139, 'Chhean Mukh', 'ឈានមុខ', NULL, NULL),
  	(733, 139, 'Pou', 'ពោធិ៍', NULL, NULL),
  	(734, 139, 'Bromeru', 'ប្រមេរុ', NULL, NULL),
  	(735, 139, 'Preah Khleang', 'ព្រះឃ្លាំង', NULL, NULL),
  	(736, 177, 'Komphun', 'កំភុន', NULL, NULL),
  	(737, 177, 'Kbal Romeas', 'ក្បាលរមាស', NULL, NULL),
  	(738, 177, 'Phluk', 'ភ្លុក', NULL, NULL),
  	(739, 177, 'Sam Khouy', 'សាមឃួយ', NULL, NULL),
  	(740, 177, 'Sdau', 'ស្ដៅ', NULL, NULL),
  	(741, 177, 'Srae Kor', 'ស្រែគរ', NULL, NULL),
  	(742, 177, 'Ta Lat', 'តាឡាត', NULL, NULL),
  	(743, 178, 'Koh Preah', 'កោះព្រះ', NULL, NULL),
  	(744, 178, 'Koh Sompeay', 'កោះសំពាយ', NULL, NULL),
  	(745, 178, 'Koh Srolay', 'កោះស្រឡាយ', NULL, NULL),
  	(746, 178, 'Ou Mreah', 'អូរម្រះ', NULL, NULL),
  	(747, 178, 'Ou Russei Kandal', 'អូរឫស្សីកណ្តាល', NULL, NULL),
  	(748, 178, 'Siem Bouk', 'សៀមបូក', NULL, NULL),
  	(749, 178, 'Srae Krasang', 'ស្រែក្រសាំង', NULL, NULL),
  	(750, 178, 'Praek Meas', 'ព្រែកមាស', NULL, NULL),
  	(751, 178, 'Sekong', 'សេកុង', NULL, NULL),
  	(752, 178, 'Santipheap', 'សន្តិភាព', NULL, NULL),
  	(753, 178, 'Srae Sombo', 'ស្រែសំបូរ', NULL, NULL),
  	(754, 178, 'Thma Keo', 'ថ្មកែវ', NULL, NULL),
  	(755, 179, 'Anlong Phe', 'អន្លង់ភេ', NULL, NULL),
  	(756, 179, 'Chomkar Leu', 'ចំការលើ', NULL, NULL),
  	(757, 179, 'Kang Cham', 'កាំងចាម', NULL, NULL),
  	(758, 179, 'Koh Snaeng', 'កោះស្នែង', NULL, NULL),
  	(759, 179, 'Ou Rai', 'អូររៃ', NULL, NULL),
  	(760, 179, 'Ou Svay', 'អូរស្វាយ', NULL, NULL),
  	(761, 179, 'Preah Romkel', 'ព្រះរំកិល', NULL, NULL),
  	(762, 179, 'Som Ang', 'សំអាង', NULL, NULL),
  	(763, 179, 'Srae Russei', 'ស្រែឫស្សី', NULL, NULL),
  	(764, 179, 'Thala Borivat', 'ថាឡាបរិវ៉ាត់', NULL, NULL),
  	(765, 179, 'Anlong Chrey', 'អន្លង់ជ្រៃ', NULL, NULL),
  	(766, 180, 'Stung Trang', 'ស្ទឹងត្រែង', NULL, NULL),
  	(767, 180, 'Srah Russei', 'ស្រះឫស្សី', NULL, NULL),
  	(768, 180, 'Preah Bat', 'ព្រះបាទ', NULL, NULL),
  	(769, 180, 'Sammaki', 'សាមគ្គី', NULL, NULL),
  	(770, 63, 'Banteay Neang', 'បន្ទាយនាង', NULL, NULL),
  	(771, 63, 'Bat Trang', 'បត់ត្រង់', NULL, NULL),
  	(772, 63, 'Chamnaom', 'ចំណោម', NULL, NULL),
  	(773, 63, 'Kouk Ballangk', 'គោកបល្ល័ង្គ', NULL, NULL),
  	(774, 63, 'Koy Maeng', 'គយម៉ែង', NULL, NULL),
  	(775, 63, 'Ou Prasat', 'អូរប្រាសាទ', NULL, NULL),
  	(776, 63, 'Phnum Touch', 'ភ្នំតូច', NULL, NULL),
  	(777, 63, 'Rohat Tuek', 'រហាត់ទឹក', NULL, NULL),
  	(778, 63, 'Ruessei Kraok', 'ឫស្សីក្រោក', NULL, NULL),
  	(779, 63, 'Sambuor', 'សំបួរ', NULL, NULL),
  	(780, 63, 'Soea', 'សឿ', NULL, NULL),
  	(781, 63, 'Srah Reang ', 'ស្រះរាំង', NULL, NULL),
  	(782, 63, 'Ta Lam', 'តាឡំ', NULL, NULL),
  	(783, 64, 'Chhnuor Mean Chey', 'ឈ្នួរមានជ័យ', NULL, NULL),
  	(784, 64, 'Chob Veari', 'ជប់វារី', NULL, NULL),
  	(785, 64, 'Phnum Lieb', 'ភ្នំលៀប', NULL, NULL),
  	(786, 64, 'Prasat', 'ប្រាសាទ', NULL, NULL),
  	(787, 64, 'Preah Netr Preah', 'ព្រះនេត្រព្រះ', NULL, NULL),
  	(788, 64, 'Rohal', 'រហាល', NULL, NULL),
  	(789, 64, 'Tean Kam', 'ទានកាំ', NULL, NULL),
  	(790, 64, 'Tuek Chour', 'ទឹកជោរ', NULL, NULL),
  	(791, 65, 'Bos Sbov', 'បុស្បូវ', NULL, NULL),
  	(792, 65, 'Kampong Svay', 'កំពង់ស្វាយ', NULL, NULL),
  	(793, 65, 'Kaoh Pong Satv', 'កោះពងសត្វ', NULL, NULL),
  	(794, 65, 'Mkak', 'ម្កាក់', NULL, NULL),
  	(795, 65, 'Ou Ambel', 'អូរអំបិល', NULL, NULL),
  	(796, 65, 'Phniet', 'ភ្នៀត', NULL, NULL),
  	(797, 65, 'Preah Ponlea', 'ព្រះពន្លា', NULL, NULL),
  	(798, 65, 'Tuek Thla', 'ទឹកថ្លា', NULL, NULL),
  	(799, 66, 'Phkoam', 'ផ្គាំ', NULL, NULL),
  	(800, 66, 'Sarongk', 'សារង្គ', NULL, NULL),
  	(801, 66, 'Sla Kram', 'ស្លក្រាម', NULL, NULL),
  	(802, 66, 'Svay Chek', 'ស្វាយចេក', NULL, NULL),
  	(803, 66, 'Ta Baen', 'តាបែន', NULL, NULL),
  	(804, 66, 'Ta Phou', 'តាផូ', NULL, NULL),
  	(805, 66, 'Treas', 'ទ្រាស', NULL, NULL),
  	(806, 66, 'Roluos', 'រលួស', NULL, NULL),
  	(807, 67, 'Changha', 'ចង្ហា', NULL, NULL),
  	(808, 67, 'Koub', 'កូប', NULL, NULL),
  	(809, 67, 'Kuttasat', 'គុត្តសត', NULL, NULL),
  	(810, 67, 'Nimitt', 'និមិត្ត', NULL, NULL),
  	(811, 67, 'Samraong', 'សំរោង', NULL, NULL),
  	(812, 67, 'Souphi', 'សូភី', NULL, NULL),
  	(813, 67, 'Soengh', 'សឹង្ហ', NULL, NULL),
  	(814, 67, 'Paoy Paet', 'ប៉ោយប៉ែត', NULL, NULL),
  	(815, 67, 'Ou Bei Choan', 'អូរបីជាន់', NULL, NULL),
  	(816, 68, 'Banteay Chhmar', 'បន្ទាយឆ្មារ', NULL, NULL),
  	(817, 68, 'Kouk Romiet', 'គោករមៀត', NULL, NULL),
  	(818, 68, 'Phum Thmei', 'ថ្មពួក', NULL, NULL),
  	(819, 68, 'Thma Puok', 'គោកកឋិន', NULL, NULL),
  	(820, 68, 'Kouk Kakthen', 'គំរូ', NULL, NULL),
  	(821, 68, 'Kumru', 'ភូមិថ្មី', NULL, NULL),
  	(822, 69, 'Boeng Beng', 'បឹងបេង', NULL, NULL),
  	(823, 69, 'Malai', 'ម៉ាឡៃ', NULL, NULL),
  	(824, 69, 'Ou Sampor', 'អូរសំព័រ', NULL, NULL),
  	(825, 69, 'Ou Sralau', 'អូរស្រឡៅ', NULL, NULL),
  	(826, 69, 'Tuol Pongro', 'ទួលពង្រ', NULL, NULL),
  	(827, 69, 'Ta Kong', 'តាគង់', NULL, NULL),
  	(828, 70, 'Changha', 'ចង្ហា', NULL, NULL),
  	(829, 70, 'Koub', 'កូប', NULL, NULL),
  	(830, 70, 'Kuttasat', 'គុត្តសត', NULL, NULL),
  	(831, 70, 'Nimitt', 'និមិត្ត', NULL, NULL),
  	(832, 70, 'Samraong', 'សំរោង', NULL, NULL),
  	(833, 70, 'Souphi', 'សូភី', NULL, NULL),
  	(834, 70, 'Soengh', 'សឹង្ហ', NULL, NULL),
  	(835, 70, 'Paoy Paet', 'ប៉ោយប៉ែត', NULL, NULL),
  	(836, 70, 'Ou Bei Choan', 'អូរបីជាន់', NULL, NULL),
  	(837, 71, 'Nam Tau', 'ណាំតៅ', NULL, NULL),
  	(838, 71, 'Paoy Char', 'ប៉ោយចារ', NULL, NULL),
  	(839, 71, 'Ponley', 'ពន្លៃ', NULL, NULL),
  	(840, 71, 'Spean Sraeng', 'ស្ពានស្រែង', NULL, NULL),
  	(841, 71, 'Srah Chik', 'ស្រះជីក', NULL, NULL),
  	(842, 71, 'Phnum Dei', 'ភ្នំដី', NULL, NULL),
  	(843, 72, 'Anhchanh Rung', 'អញ្ចាញរូង', NULL, NULL),
  	(844, 72, 'Chhnok Tru', 'ឆ្នុកទ្រូ', NULL, NULL),
  	(845, 72, 'Chak', 'ចក', NULL, NULL),
  	(846, 72, 'Khon Rang', 'ខុនរ៉ង', NULL, NULL),
  	(847, 72, 'Kampong Preah Kokir', 'កំពង់ព្រះគគីរ', NULL, NULL),
  	(848, 72, 'Melum', 'មេលំ', NULL, NULL),
  	(849, 72, 'Phsar', 'ផ្សារ', NULL, NULL),
  	(850, 72, 'Pech Changvar', 'ពេជ្រចង្វារ', NULL, NULL),
  	(851, 72, 'Popel', 'ពពេល', NULL, NULL),
  	(852, 72, 'Ponley', 'ពន្លៃ', NULL, NULL),
  	(853, 72, 'Trapeang Chan', 'ត្រពាំងចាន់', NULL, NULL),
  	(854, 73, 'Phsar Chhnang', 'ផ្សារឆ្នាំង', NULL, NULL),
  	(855, 73, 'Kampong Chhnang', 'កំពង់ឆ្នាំង', NULL, NULL),
  	(856, 73, 'Pha er', 'ប្អេរ', NULL, NULL),
  	(857, 73, 'Khsam', 'ខ្សាម', NULL, NULL),
  	(858, 74, 'Ampil Tuek', 'អំពិលទឹក', NULL, NULL),
  	(859, 74, 'Chhuk Sa', 'ឈូកស', NULL, NULL),
  	(860, 74, 'Chres', 'ច្រេស', NULL, NULL),
  	(861, 74, 'Kampong Tralach', 'កំពង់ត្រឡាច', NULL, NULL),
  	(862, 74, 'Longveaek', 'លង្វែក', NULL, NULL),
  	(863, 74, 'Ou Ruessei', 'អូរឬស្សី', NULL, NULL),
  	(864, 74, 'Peani', 'ពានី', NULL, NULL),
  	(865, 74, 'Saeb', 'សែប', NULL, NULL),
  	(866, 74, 'Ta Ches', 'តាជេស', NULL, NULL),
  	(867, 74, 'Thma Edth', 'ថ្មឥដ្ឋ', NULL, NULL),
  	(868, 75, 'Chhean Laeung', 'ឈានឡើង', NULL, NULL),
  	(869, 75, 'Khnar Chhmar', 'ខ្នាឆ្មារ', NULL, NULL),
  	(870, 75, 'Krang Lvea', 'រាំល្វា', NULL, NULL),
  	(871, 75, 'Peam', 'ពាម', NULL, NULL),
  	(872, 75, 'Sedthei', 'សេដ្ឋី', NULL, NULL),
  	(873, 75, 'Svay', 'ស្វាយ', NULL, NULL),
  	(874, 75, 'Svay Chuk', 'ស្វាយជុក', NULL, NULL),
  	(875, 75, 'Tbaeng Khpos', 'ត្បែងខ្ពស់', NULL, NULL),
  	(876, 75, 'Thlok Vien', 'ធ្លកវៀន', NULL, NULL),
  	(877, 76, 'Chranouk', 'ច្រណូក', NULL, NULL),
  	(878, 76, 'Dar', 'ដារ', NULL, NULL),
  	(879, 76, 'Kampong hau', 'កំពង់ហៅ', NULL, NULL),
  	(880, 76, 'Phlov Tuk', 'ផ្លូវទូក', NULL, NULL),
  	(881, 76, 'Pou', 'ពោធិ៍', NULL, NULL),
  	(882, 76, 'Pralay Meas', 'ប្រឡាយមាស', NULL, NULL),
  	(883, 76, 'Samraong Saen', 'សំរោងសែន', NULL, NULL),
  	(884, 76, 'Svay Rumpear', 'ស្វាយរំពារ', NULL, NULL),
  	(885, 76, 'Trangel', 'ត្រងិល', NULL, NULL),
  	(886, 77, 'Chol Sarg', 'ជលសា', NULL, NULL),
  	(887, 77, 'Kaoh Thkov', 'កោះថ្កូវ', NULL, NULL),
  	(888, 77, 'Kampong Os', 'កំពង់អុស', NULL, NULL),
  	(889, 77, 'Peam Chhkaok', 'ពាមឆ្កោក', NULL, NULL),
  	(890, 77, 'Prey Kri', 'ព្រៃគ្រី', NULL, NULL),
  	(891, 78, 'Andoung Snay', 'អណ្តូងស្នាយ', NULL, NULL),
  	(892, 78, 'Banteay Preal', 'បន្ទាយព្រាល', NULL, NULL),
  	(893, 78, 'Cheung Kreav', 'ជើងគ្រាវ', NULL, NULL),
  	(894, 78, 'Chrey Bak', 'ជ្រៃបាក់', NULL, NULL),
  	(895, 78, 'Kouk Banteay', 'គោកបន្ទាយ', NULL, NULL),
  	(896, 78, 'Krang Leav', 'ក្រាំងលាវ', NULL, NULL),
  	(897, 78, 'Pongro', 'ពង្រ', NULL, NULL),
  	(898, 78, 'Prasneb', 'ប្រស្នឹប', NULL, NULL),
  	(899, 78, 'Prey Mul', 'ព្រៃមូល', NULL, NULL),
  	(900, 78, 'Rolea Ba ier', 'រលាប្អៀរ', NULL, NULL),
  	(901, 78, 'Srae Thmei', 'ស្រែថ្មី', NULL, NULL),
  	(902, 78, 'Svay Chrum', 'ស្វាយជ្រុំ', NULL, NULL),
  	(903, 78, 'Tuek Hout', 'ទឹកហូត', NULL, NULL),
  	(904, 79, 'Akphivoadth ', 'អភិវឌ្ឍន៍', NULL, NULL),
  	(905, 79, 'Chieb ', 'ជៀប', NULL, NULL),
  	(906, 79, 'Chaong Maong', 'ចោងម៉ោង', NULL, NULL),
  	(907, 79, 'Kbal Tuek', 'ក្បាលទឹក', NULL, NULL),
  	(908, 79, 'Khlong Popok', 'ខ្លុងពពក', NULL, NULL),
  	(909, 79, 'Krang Skear', 'រាំងស្គារ', NULL, NULL),
  	(910, 79, 'Tang Krasang', 'តាំងក្រសាំង', NULL, NULL),
  	(911, 79, 'Tuol Khpos', 'ទួលខ្ពស់', NULL, NULL);
  /*!40000 ALTER TABLE `communes` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.districts
  DROP TABLE IF EXISTS `districts`;
  CREATE TABLE IF NOT EXISTS `districts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `province_id` int(11) DEFAULT NULL,
    `name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.districts: 197 rows
  /*!40000 ALTER TABLE `districts` DISABLE KEYS */;
  INSERT INTO `districts` (`id`, `province_id`, `name_en`, `name_kh`, `created_at`, `updated_at`) VALUES
  	(1, 1, 'Ruessei Kaev', 'ឫស្សីកែវ', NULL, NULL),
  	(2, 1, 'Saensokh', 'សែនសុខ', NULL, NULL),
  	(3, 1, 'Por Senchey', 'ពោធិសែនជ័យ', NULL, NULL),
  	(4, 1, 'Chrouy Changva', 'ជ្រោយចង្វារ', NULL, NULL),
  	(5, 1, 'Preaek Pnov', 'ព្រែកភ្នៅ', NULL, NULL),
  	(6, 1, 'Chbar Ampov', 'ច្បារអំពៅ', NULL, NULL),
  	(7, 1, 'Doun Penh', 'ដូនពេញ', NULL, NULL),
  	(8, 1, 'Prampir Meakkara', '៧មករា', NULL, NULL),
  	(9, 1, 'Toul Kouk', 'ទួលគោក', NULL, NULL),
  	(10, 1, 'Dangkao', 'ដង្កោ', NULL, NULL),
  	(11, 1, 'Mean Chey', 'មានជ័យ', NULL, NULL),
  	(12, 1, 'Chamkar Mon', 'ចំការមន', NULL, NULL),
  	(13, 2, 'Krong Preah Sihanouk', 'ព្រះសីហនុ', NULL, NULL),
  	(14, 2, 'Prey Nob', 'ព្រៃនប់', NULL, NULL),
  	(15, 2, 'Stueng Hav Chey', 'ស្ទឹងហាវ', NULL, NULL),
  	(16, 2, 'Kompong Seila', 'កំពង់សីលា', NULL, NULL),
  	(17, 3, 'Krong Kampong Cham', 'កំពង់ចាម', NULL, NULL),
  	(18, 3, 'Kampong Siem', 'កំពង់សៀម', NULL, NULL),
  	(19, 3, 'KangMeas', 'កងមាស', NULL, NULL),
  	(20, 3, 'Kaoh Soutin', 'កោះសុទិន', NULL, NULL),
  	(21, 3, 'Prey Chhor', 'ព្រៃឈរ', NULL, NULL),
  	(22, 3, 'Srei Santhor', 'ស្រីសន្ធរ', NULL, NULL),
  	(23, 3, 'Stueng Trang', 'ស្ទឹងត្រង់', NULL, NULL),
  	(24, 3, 'Batheay', 'បាធាយ', NULL, NULL),
  	(25, 3, 'Chamkar Leu', 'ចំការលើ', NULL, NULL),
  	(26, 3, 'Cheung Prey', 'ជើងព្រៃ', NULL, NULL),
  	(27, 4, 'Angkor Chum', 'អង្គរជុំ', NULL, NULL),
  	(28, 4, 'Angkor Thom', 'អង្គរធំ', NULL, NULL),
  	(29, 4, 'Banteay Srey', 'បន្ទាយស្រី', NULL, NULL),
  	(30, 4, 'Chi Kraeng', 'ជីក្រែង', NULL, NULL),
  	(31, 4, 'Kralanh', 'ក្រឡាញ់', NULL, NULL),
  	(32, 4, 'Pouk', 'ពួក', NULL, NULL),
  	(33, 4, 'Prasat Bakong', 'ប្រាសាទបាគង', NULL, NULL),
  	(34, 4, 'Krong Siem Reap', 'ក្រុងសៀមរាប', NULL, NULL),
  	(35, 4, 'Soutr Nikum', 'សុទ្រនិគមន៍', NULL, NULL),
  	(36, 4, 'Srei Snam', 'ស្រីស្នំ', NULL, NULL),
  	(37, 4, 'Svay Leu', 'ស្វាយលើ', NULL, NULL),
  	(38, 4, 'Varin', 'វ៉ារិន', NULL, NULL),
  	(39, 5, 'Banan', 'បាណន់', NULL, NULL),
  	(40, 5, 'Thma Koul', 'ថ្មរគោល', NULL, NULL),
  	(41, 5, 'Krong Battambang', 'ក្រុងបាត់ដំបង', NULL, NULL),
  	(42, 5, 'Bavel', 'បវេល', NULL, NULL),
  	(43, 5, 'Aek Phnum', 'ឯកភ្នំ', NULL, NULL),
  	(44, 5, 'Moung Ruessei', 'មោង រស្សី', NULL, NULL),
  	(45, 5, 'Rotonak Mondol', 'រតនាមណ្ឌល', NULL, NULL),
  	(46, 5, 'Sangkae', 'សង្កៃរ', NULL, NULL),
  	(47, 5, 'Samlout', 'សំឡូត', NULL, NULL),
  	(48, 5, 'Sampov Lun', 'សំពៅលូន', NULL, NULL),
  	(49, 5, 'Phnom Proek', 'ភ្នំព្រឹក', NULL, NULL),
  	(50, 5, 'Kamrieng', 'កំរៀង', NULL, NULL),
  	(51, 5, 'Koas Krala', 'គាស់ក្រឡ', NULL, NULL),
  	(52, 5, 'Rukhak Kiri', 'រុក្ខគីរី', NULL, NULL),
  	(53, 6, 'Kandal Stueng', '', NULL, NULL),
  	(54, 6, 'Koh Thum', '', NULL, NULL),
  	(55, 6, 'Mukh Kamphool', '', NULL, NULL),
  	(56, 6, 'Sa Ang', '', NULL, NULL),
  	(57, 6, 'Leuk Daek', '', NULL, NULL),
  	(58, 6, 'Krong Ta Khmau', '', NULL, NULL),
  	(59, 6, 'Kien Svay', '', NULL, NULL),
  	(60, 6, 'Ponhea Leu', '', NULL, NULL),
  	(61, 6, 'Lvea Aem', '', NULL, NULL),
  	(62, 6, 'Khsach Kandal', '', NULL, NULL),
  	(63, 7, 'Mongkol Borei', '', NULL, NULL),
  	(64, 7, 'Preah Netr Preah', '', NULL, NULL),
  	(65, 7, 'Serei Saophoan', '', NULL, NULL),
  	(66, 7, 'Svay Chek', '', NULL, NULL),
  	(67, 7, 'Ou Chrov', '', NULL, NULL),
  	(68, 7, 'Thma Puok', '', NULL, NULL),
  	(69, 7, 'Malai', '', NULL, NULL),
  	(70, 7, 'Ou Chrov', '', NULL, NULL),
  	(71, 7, 'Phnum Srok', '', NULL, NULL),
  	(72, 8, 'Baribour', '', NULL, NULL),
  	(73, 8, 'Kampong Chhnang', '', NULL, NULL),
  	(74, 8, 'Kampong Tralach', '', NULL, NULL),
  	(75, 8, 'Sameakki', '', NULL, NULL),
  	(76, 8, 'Kampong Leaeng', '', NULL, NULL),
  	(77, 8, 'Chol Kiri', '', NULL, NULL),
  	(78, 8, 'Rolea B\'ier', '', NULL, NULL),
  	(79, 8, 'Tuek Phos', '', NULL, NULL),
  	(80, 9, 'Basedth', '', NULL, NULL),
  	(81, 9, 'Kong Pisei', '', NULL, NULL),
  	(82, 9, 'Odongk', '', NULL, NULL),
  	(83, 9, 'Samraong Tong', '', NULL, NULL),
  	(84, 9, 'Aoral', '', NULL, NULL),
  	(85, 9, 'Phnom Sruoch', '', NULL, NULL),
  	(86, 9, 'Chbar Mon', '', NULL, NULL),
  	(87, 9, 'Thpong', '', NULL, NULL),
  	(88, 10, 'Baray', '', NULL, NULL),
  	(89, 10, 'Stueng Saen', '', NULL, NULL),
  	(90, 10, 'Sandaan', '', NULL, NULL),
  	(91, 10, 'Stoung', '', NULL, NULL),
  	(92, 10, 'Prasat Balangk', '', NULL, NULL),
  	(93, 10, 'Santuk', '', NULL, NULL),
  	(94, 10, 'Prasat Sambour', '', NULL, NULL),
  	(95, 10, 'Kampong Svay', '', NULL, NULL),
  	(96, 11, 'Angkor Chey', '', NULL, NULL),
  	(97, 11, 'Chhuk', '', NULL, NULL),
  	(98, 11, 'Dorng Tong', '', NULL, NULL),
  	(99, 11, 'Teouk Chhou', '', NULL, NULL),
  	(100, 11, 'Banteay Meas', '', NULL, NULL),
  	(101, 11, 'Kampong Trach', '', NULL, NULL),
  	(102, 11, 'Chum Kiri', '', NULL, NULL),
  	(103, 11, 'Kampot', '', NULL, NULL),
  	(104, 12, 'Krong Kep', '', NULL, NULL),
  	(105, 12, 'Damnak Chang aeur', '', NULL, NULL),
  	(106, 12, 'Krong Kep', '', NULL, NULL),
  	(107, 13, 'Botum Sakor', '', NULL, NULL),
  	(108, 13, 'Koh Kong', '', NULL, NULL),
  	(109, 13, 'Mondol Seima', '', NULL, NULL),
  	(110, 13, 'Thma Bang', '', NULL, NULL),
  	(111, 13, 'Kiri Sakor', '', NULL, NULL),
  	(112, 13, 'Khemara Phoumin', '', NULL, NULL),
  	(113, 13, 'Srae Ambel', '', NULL, NULL),
  	(114, 14, 'Chhlong', '', NULL, NULL),
  	(115, 14, 'Chitr Borei', '', NULL, NULL),
  	(116, 14, 'Krong Kratie', '', NULL, NULL),
  	(117, 14, 'Sombo', '', NULL, NULL),
  	(118, 14, 'Preaek Prasob', '', NULL, NULL),
  	(119, 14, 'Snoul', '', NULL, NULL),
  	(120, 15, 'Kaev Seima', '', NULL, NULL),
  	(121, 15, 'Ou Reang', '', NULL, NULL),
  	(122, 15, 'Krong Saen', '', NULL, NULL),
  	(123, 15, 'Pech Chreada', '', NULL, NULL),
  	(124, 15, 'Kaoh Nheaek', '', NULL, NULL),
  	(125, 16, 'Anlong Veaeng', '', NULL, NULL),
  	(126, 16, 'Banteay Ampil', '', NULL, NULL),
  	(127, 16, 'Chong Kal', '', NULL, NULL),
  	(128, 16, 'Krong Samraong', '', NULL, NULL),
  	(129, 16, 'Trapeang Prasat', '', NULL, NULL),
  	(130, 17, 'Krong Pailin', '', NULL, NULL),
  	(131, 17, 'Sala Krau', '', NULL, NULL),
  	(132, 17, 'Chong Kal', '', NULL, NULL),
  	(133, 18, 'Chey Saen', '', NULL, NULL),
  	(134, 18, 'Choam Khsant', '', NULL, NULL),
  	(135, 18, 'Rovieng', '', NULL, NULL),
  	(136, 18, 'Sangkom Thmei', '', NULL, NULL),
  	(137, 18, 'Chhaeb', '', NULL, NULL),
  	(138, 18, 'Kulen', '', NULL, NULL),
  	(139, 18, 'Tbaeng Mean Chey', '', NULL, NULL),
  	(140, 18, 'Krong Preah Vihear', '', NULL, NULL),
  	(141, 19, 'Ba Phnum', '', NULL, NULL),
  	(142, 19, 'Kanhchriech', '', NULL, NULL),
  	(143, 19, 'Peam Ro', '', NULL, NULL),
  	(144, 19, 'Preah Sdach', '', NULL, NULL),
  	(145, 19, 'Me Sang', '', NULL, NULL),
  	(146, 19, 'Pea Reang', '', NULL, NULL),
  	(147, 19, 'Kamchay Mear', '', NULL, NULL),
  	(148, 19, 'Prey Veaeng', '', NULL, NULL),
  	(149, 19, 'Peam Chor', '', NULL, NULL),
  	(150, 19, 'Kampong Trabaek', '', NULL, NULL),
  	(151, 19, 'Por Reang', '', NULL, NULL),
  	(152, 19, 'Svay Ontor', '', NULL, NULL),
  	(153, 20, 'Bakan', '', NULL, NULL),
  	(154, 20, 'Krakor', '', NULL, NULL),
  	(155, 20, 'Krong Pursat', '', NULL, NULL),
  	(156, 20, 'Kandieng', '', NULL, NULL),
  	(157, 20, 'Phnum Kravanh', '', NULL, NULL),
  	(158, 20, 'Veal Veaeng', '', NULL, NULL),
  	(159, 21, 'Andoung Meas', '', NULL, NULL),
  	(160, 21, 'Koun Mom', '', NULL, NULL),
  	(161, 21, 'Ou Chum', '', NULL, NULL),
  	(162, 21, 'Ta Veaeng', '', NULL, NULL),
  	(163, 21, 'Krong Banlung', '', NULL, NULL),
  	(164, 21, 'Lumphat', '', NULL, NULL),
  	(165, 21, 'Ou Ya Dav', '', NULL, NULL),
  	(166, 21, 'Bar Kaev', '', NULL, NULL),
  	(167, 22, 'Sesan', '', NULL, NULL),
  	(168, 22, 'Siem Bouk', '', NULL, NULL),
  	(169, 22, 'Siem Pang', '', NULL, NULL),
  	(170, 22, 'Thala Barivat', '', NULL, NULL),
  	(171, 22, 'Krong Stung Treng', '', NULL, NULL),
  	(172, 23, 'Chantrea', '', NULL, NULL),
  	(173, 23, 'Rumduol', '', NULL, NULL),
  	(174, 23, 'Svay Chrum', '', NULL, NULL),
  	(175, 23, 'Svay Teab', '', NULL, NULL),
  	(176, 23, 'Kampong Rou', '', NULL, NULL),
  	(177, 23, 'Romeas Haek', '', NULL, NULL),
  	(178, 23, 'Krong Bavet', '', NULL, NULL),
  	(179, 23, 'Krong Svay Rieng', '', NULL, NULL),
  	(180, 24, 'Angkor Borei', '', NULL, NULL),
  	(181, 24, 'Kiri Vong', '', NULL, NULL),
  	(182, 24, 'Samraong', '', NULL, NULL),
  	(183, 24, 'Treang', '', NULL, NULL),
  	(184, 24, 'Bati', '', NULL, NULL),
  	(185, 24, 'Krong Doun Kaev', '', NULL, NULL),
  	(186, 24, 'Kaoh Andaet', '', NULL, NULL),
  	(187, 24, 'Krong Doun Kaev', '', NULL, NULL),
  	(188, 24, 'Tram Kak', '', NULL, NULL),
  	(189, 24, 'Prey Kabbas', '', NULL, NULL),
  	(190, 24, 'Bourei Cholsar', '', NULL, NULL),
  	(191, 25, 'Dombae', '', NULL, NULL),
  	(192, 25, 'Memot', '', NULL, NULL),
  	(193, 25, 'Ponhea Kraek', '', NULL, NULL),
  	(194, 25, 'Krouch Chhma', '', NULL, NULL),
  	(195, 25, 'Tboung Khmum', '', NULL, NULL),
  	(196, 25, 'Ou Reang Ov', '', NULL, NULL),
  	(197, 25, 'Krong Suong', '', NULL, NULL);
  /*!40000 ALTER TABLE `districts` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.facings
  DROP TABLE IF EXISTS `facings`;
  CREATE TABLE IF NOT EXISTS `facings` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `facing` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.facings: 8 rows
  /*!40000 ALTER TABLE `facings` DISABLE KEYS */;
  INSERT INTO `facings` (`id`, `facing`, `created_at`, `updated_at`) VALUES
  	(1, 'East', '2020-06-20 13:01:27', '2020-06-20 13:01:31'),
  	(2, 'North', '2020-06-20 13:01:27', '2020-06-20 13:01:32'),
  	(3, 'Northeast', '2020-06-20 13:01:28', '2020-06-20 13:01:32'),
  	(4, 'Northwest', '2020-06-20 13:01:28', '2020-06-20 13:01:33'),
  	(5, 'South', '2020-06-20 13:01:29', '2020-06-20 13:01:33'),
  	(6, 'Southeast', '2020-06-20 13:01:30', '2020-06-20 13:01:34'),
  	(7, 'Southwest', '2020-06-20 13:01:30', '2020-06-20 13:01:34'),
  	(8, 'West', '2020-06-20 13:01:31', '2020-06-20 13:01:35');
  /*!40000 ALTER TABLE `facings` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.migrations
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.migrations: 12 rows
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  	(1, '2014_10_12_000000_create_users_table', 1),
  	(2, '2014_10_12_100000_create_password_resets_table', 1),
  	(3, '2019_04_10_023959_create_properties_table', 1),
  	(4, '2019_04_10_024114_create_property_galleries_table', 1),
  	(5, '2019_04_10_042644_create_province_district_commune_tables', 1),
  	(6, '2019_05_02_110924_create_admins_table', 1),
  	(7, '2019_05_08_120215_create_phone_operators_table', 1),
  	(8, '2019_05_10_020522_create_categories_table', 1),
  	(9, '2019_05_25_012319_create_property_type_table', 2),
  	(10, '2020_06_20_055247_create_bedrooms_table', 3),
  	(11, '2020_06_20_055307_create_bathrooms_table', 3),
  	(12, '2020_06_20_055322_create_facings_table', 3);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.password_resets
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.password_resets: 0 rows
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.phone_operators
  DROP TABLE IF EXISTS `phone_operators`;
  CREATE TABLE IF NOT EXISTS `phone_operators` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `cellcard` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `smart` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `metfone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `qb` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.phone_operators: 13 rows
  /*!40000 ALTER TABLE `phone_operators` DISABLE KEYS */;
  INSERT INTO `phone_operators` (`id`, `cellcard`, `smart`, `metfone`, `qb`, `created_at`, `updated_at`) VALUES
  	(1, '011', '010', '031', '013', NULL, NULL),
  	(2, '012', '015', '060', '080', NULL, NULL),
  	(3, '014', '016', '066', '083', NULL, NULL),
  	(4, '017', '069', '067', '084', NULL, NULL),
  	(5, '061', '070', '068', '', NULL, NULL),
  	(6, '077', '081', '071', '', NULL, NULL),
  	(7, '078', '086', '088', '', NULL, NULL),
  	(8, '079', '087', '090', '', NULL, NULL),
  	(9, '085', '093', '097', '', NULL, NULL),
  	(10, '089', '096', '', '', NULL, NULL),
  	(11, '092', '098', '', '', NULL, NULL),
  	(12, '095', '', '', '', NULL, NULL),
  	(13, '099', '', '', '', NULL, NULL);
  /*!40000 ALTER TABLE `phone_operators` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.properties
  DROP TABLE IF EXISTS `properties`;
  CREATE TABLE IF NOT EXISTS `properties` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `category_id` int(10) unsigned DEFAULT NULL,
    `parent_id` int(10) unsigned DEFAULT NULL,
    `title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `bedroom` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `bathroom` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `facing` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `price` double(8,2) DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `province_id` int(11) DEFAULT NULL,
    `district_id` int(11) DEFAULT NULL,
    `commune_id` int(11) DEFAULT NULL,
    `location` text COLLATE utf8mb4_unicode_ci,
    `save_contact` tinyint(4) DEFAULT '1',
    `view_count` int(11) DEFAULT '0',
    `updated_by` int(11) DEFAULT NULL,
    `expired_day` int(11) DEFAULT '60',
    `is_expired` tinyint(4) DEFAULT '0',
    `is_premium` tinyint(4) DEFAULT '1',
    `renew_date` datetime DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.properties: 1 rows
  /*!40000 ALTER TABLE `properties` DISABLE KEYS */;
  INSERT INTO `properties` (`id`, `user_id`, `category_id`, `parent_id`, `title`, `slug`, `bedroom`, `bathroom`, `facing`, `size`, `price`, `description`, `name`, `phone1`, `phone2`, `phone3`, `email`, `province_id`, `district_id`, `commune_id`, `location`, `save_contact`, `view_count`, `updated_by`, `expired_day`, `is_expired`, `is_premium`, `renew_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
  	(1, 2, 5, 46, '2 Bedrooms Apartment for Sale', '2-Bedrooms-Apartment-for-Sale', NULL, NULL, NULL, NULL, NULL, '2 Bedrooms Apartment for Sale', 'Applephagna', '095 267 77', '0319999926', '0883565895', 'user@gmail.com', 1, 0, 233, '2 Bedrooms Apartment for Sale Update', 1, 0, 2, 60, 0, 1, NULL, '2020-06-26 05:18:48', '2020-06-26 06:10:19', NULL);
  /*!40000 ALTER TABLE `properties` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.property_galleries
  DROP TABLE IF EXISTS `property_galleries`;
  CREATE TABLE IF NOT EXISTS `property_galleries` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `property_id` int(10) unsigned NOT NULL,
    `gallery_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.property_galleries: 4 rows
  /*!40000 ALTER TABLE `property_galleries` DISABLE KEYS */;
  INSERT INTO `property_galleries` (`id`, `property_id`, `gallery_image`, `created_at`, `updated_at`) VALUES
  	(1, 1, '91811151_434191283770111_1140115001211291454_n.jpeg', '2020-06-26 05:18:48', '2020-06-26 05:18:48'),
  	(2, 1, '57661743_578311615193195_6064101915421012139_n.png', '2020-06-26 05:18:48', '2020-06-26 05:18:48'),
  	(3, 1, '71367071_679111111512821_1767625701211744121_n.png', '2020-06-26 05:18:48', '2020-06-26 05:18:48'),
  	(4, 1, '72381141_715321016076661_1712119171212141137_n.jpeg', '2020-06-26 05:18:48', '2020-06-26 05:18:48');
  /*!40000 ALTER TABLE `property_galleries` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.property_type
  DROP TABLE IF EXISTS `property_type`;
  CREATE TABLE IF NOT EXISTS `property_type` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
    `type_id` int(10) unsigned DEFAULT '1',
    `name_en` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name_kh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.property_type: 20 rows
  /*!40000 ALTER TABLE `property_type` DISABLE KEYS */;
  INSERT INTO `property_type` (`id`, `parent_id`, `type_id`, `name_en`, `name_kh`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
  	(1, 0, 0, 'House', 'ផ្ទះ', 'photo-house.jpg', 1, '2019-05-31 11:27:59', '2019-05-31 11:28:00'),
  	(2, 0, 0, 'Lands', 'ដី', 'photo-land.jpg', 1, '2019-05-31 11:28:26', '2019-05-31 11:28:26'),
  	(3, 0, 0, 'Apartment', 'អាផាតមិន', 'photo-apartment.jpg', 1, '2019-05-31 17:10:38', '2019-05-31 17:10:39'),
  	(4, 0, 0, 'Commercial Properties', 'ទ្រព្យសម្បត្តិ ពាណិជ្ជកម្ម', 'photo-commercial-properties.jpg', 1, '2019-05-31 17:11:11', '2019-05-31 17:11:12'),
  	(5, 0, 0, 'Room', 'បន្ទប់', 'photo-room.jpg', 1, '2019-05-31 17:17:25', '2019-05-31 17:17:26'),
  	(9, 1, 1, 'Buy', 'ទិញ', NULL, 1, '2019-05-31 17:13:59', '2019-05-31 17:13:59'),
  	(10, 1, 2, 'Rent', 'ជួល', NULL, 1, '2019-05-31 17:14:14', '2019-05-31 17:14:15'),
  	(11, 2, 1, 'Buy', 'ទិញ', NULL, 1, '2019-05-31 17:14:33', '2019-05-31 17:14:34'),
  	(12, 2, 2, 'Rent', 'ជួល', NULL, 1, '2019-05-31 17:14:49', '2019-05-31 17:14:49'),
  	(13, 3, 1, 'Buy', 'ទិញ', NULL, 1, '2019-05-31 17:15:07', '2019-05-31 17:15:07'),
  	(14, 3, 2, 'Rent', 'ជួល', NULL, 1, '2019-05-31 17:15:17', '2019-05-31 17:15:17'),
  	(15, 4, 1, 'Buy', 'ទិញ', NULL, 1, '2019-05-31 17:15:27', '2019-05-31 17:15:27'),
  	(16, 4, 2, 'Rent', 'ជួល', NULL, 1, '2019-05-31 17:15:35', '2019-05-31 17:15:36'),
  	(17, 5, 2, 'Rent', 'ជួល', NULL, 1, '2019-05-31 17:15:57', '2019-05-31 17:15:57'),
  	(6, 0, 0, 'Properties Wanted', NULL, NULL, 1, NULL, NULL),
  	(7, 0, 0, 'Agent Services', NULL, NULL, 1, NULL, NULL),
  	(8, 0, 0, 'Other Categories', NULL, NULL, 1, NULL, NULL),
  	(18, 6, 3, 'Properties Wanted', NULL, NULL, 1, NULL, NULL),
  	(19, 7, 4, 'Agent Services', NULL, NULL, 1, NULL, NULL),
  	(20, 8, 5, 'Other Categories', NULL, NULL, 1, NULL, NULL);
  /*!40000 ALTER TABLE `property_type` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.provinces
  DROP TABLE IF EXISTS `provinces`;
  CREATE TABLE IF NOT EXISTS `provinces` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug_kh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.provinces: 25 rows
  /*!40000 ALTER TABLE `provinces` DISABLE KEYS */;
  INSERT INTO `provinces` (`id`, `name_en`, `name_kh`, `slug_en`, `slug_kh`, `created_at`, `updated_at`) VALUES
  	(1, 'Phnom Penh', 'ភ្នំពេញ', 'phnom-penh', '', NULL, NULL),
  	(2, 'Preah Sihanouk', 'ព្រះសីហនុ', 'preah-sihanouk', '', NULL, NULL),
  	(3, 'Kampong Cham', 'កំពង់ចាម', 'kampong-cham', '', NULL, NULL),
  	(4, 'Siem Reap', 'សៀមរាប', 'siem-reap', '', NULL, NULL),
  	(5, 'Battambang', 'បាត់ដំបង', 'Battambang', '', NULL, NULL),
  	(6, 'Kandal', 'កណ្តាល', 'Kandal', '', NULL, NULL),
  	(7, 'Banteay Meanchey', 'បន្ទាយមានជ័យ', 'Banteay-Meanchey', '', NULL, NULL),
  	(8, 'Kampong Chhnang', 'កំពង់ឆ្នាំង', 'Kampong-Chhnang', '', NULL, NULL),
  	(9, 'Kampong Speu', 'កំពង់ស្ពឺ', 'Kampong-Speu', '', NULL, NULL),
  	(10, 'Kampong Thom', 'កំពង់ធំ', 'Kampong-Thom', '', NULL, NULL),
  	(11, 'Kampot', 'កំពត', 'Kampot', '', NULL, NULL),
  	(12, 'Kep', 'កែប', 'Kep', '', NULL, NULL),
  	(13, 'Koh Kong', 'កោះកុង', 'Koh-Kong', '', NULL, NULL),
  	(14, 'Kratie', 'ក្រចេះ', 'Kratie', '', NULL, NULL),
  	(15, 'Mondulkiri', 'មណ្ឌលគិរី', 'Mondulkiri', '', NULL, NULL),
  	(16, 'Oddar Meanchey', 'ឧត្តរមានជ័យ', 'Oddar-Meanchey', '', NULL, NULL),
  	(17, 'Pailin', 'ប៉ៃលិន', 'Pailin', '', NULL, NULL),
  	(18, 'Preah Vihear', 'ព្រះវិហារ', 'Preah-Vihear', '', NULL, NULL),
  	(19, 'Prey Veng', 'ព្រៃវែង', 'Prey-Veng', '', NULL, NULL),
  	(20, 'Pursat', 'ពោធ៌សាត់', 'Pursat', '', NULL, NULL),
  	(21, 'Ratanakiri', 'រតនគីរី', 'Ratanakiri', '', NULL, NULL),
  	(22, 'Stung Treng', 'ស្ទឹងត្រែង', 'Stung-Treng', '', NULL, NULL),
  	(23, 'Svay Rieng', 'ស្វាយរៀង', 'Svay-Rieng', '', NULL, NULL),
  	(24, 'Takeo', 'តាកែវ', 'Takeo', '', NULL, NULL),
  	(25, 'Tboung Khmum', 'ត្បូងឃ្មុំ', 'Tboung-Khmum', '', NULL, NULL);
  /*!40000 ALTER TABLE `provinces` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.roles
  DROP TABLE IF EXISTS `roles`;
  CREATE TABLE IF NOT EXISTS `roles` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name_kh` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `view_path` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `roles_name_unique` (`name_kh`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.roles: ~4 rows (approximately)
  /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  INSERT INTO `roles` (`id`, `name_kh`, `name_en`, `description`, `view_path`, `created_at`, `updated_at`) VALUES
  	(1, 'superadmin', 'superadmin', NULL, NULL, '2020-06-10 18:21:21', '2020-06-10 18:21:22'),
  	(2, 'admin', 'admin', NULL, NULL, '2020-06-10 18:22:12', '2020-06-10 18:22:28'),
  	(3, 'agent', 'agent', NULL, NULL, '2020-06-10 18:22:35', '2020-06-10 18:22:34'),
  	(4, 'user', 'user', NULL, NULL, '2020-06-10 18:23:02', '2020-06-10 18:23:06');
  /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.social
  DROP TABLE IF EXISTS `social`;
  CREATE TABLE IF NOT EXISTS `social` (
    `id` bigint(20) NOT NULL,
    `agency_id` bigint(20) DEFAULT NULL,
    `name_kh` varchar(150) DEFAULT NULL,
    `name_en` varchar(150) DEFAULT NULL,
    `link` varchar(250) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- Dumping data for table thepinrealestate_social_login.social: 0 rows
  /*!40000 ALTER TABLE `social` DISABLE KEYS */;
  /*!40000 ALTER TABLE `social` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.social_auths
  DROP TABLE IF EXISTS `social_auths`;
  CREATE TABLE IF NOT EXISTS `social_auths` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL,
    `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `_avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.social_auths: ~0 rows (approximately)
  /*!40000 ALTER TABLE `social_auths` DISABLE KEYS */;
  /*!40000 ALTER TABLE `social_auths` ENABLE KEYS */;
  
  -- Dumping structure for table thepinrealestate_social_login.users
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `firstname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `lastname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `profile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`),
    UNIQUE KEY `users_username_unique` (`username`),
    UNIQUE KEY `users_phone_unique` (`phone`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Dumping data for table thepinrealestate_social_login.users: 4 rows
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` (`id`, `role_id`, `firstname`, `lastname`, `username`, `phone`, `email`, `address`, `location`, `profile`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  	(1, 1, 'Administrator', 'Administrator', 'admin', '012888999', 'admin@gmail.com', NULL, NULL, NULL, NULL, '$2y$10$GJnXqe6/2uPZlKgkfGnTaOaoPzZMCJw6oyr7eHnmZlbo7fs2/WLDq', 'N8RkNPIf1T2PuwR4jA0YoEuWtx74XEe0eja2Dy9Zeoso2tubeurSxxBAs2a0', '2020-06-10 10:47:43', '2020-06-10 10:47:43'),
  	(2, 3, 'agent', 'agent', 'agent@gmail.com', '01211112222', 'agent@gmail.com', NULL, NULL, NULL, NULL, '$2y$10$zx3FmvBUvcrQtPz17hbauOCHKCpBj3lVWKj2CMeGBO/FGtgNBbTTi', '3tqU1PS1aaGKJN2dS9Pnq6YABFh4XqSzLTPjx0WcHBcgcQ5Cy3MloOCDFmmq', '2020-06-11 08:09:52', '2020-06-11 08:09:52'),
  	(3, 3, 'User', 'User', 'user', '012123456', 'user@gmail.com', NULL, NULL, NULL, NULL, '$2y$10$A8dRLlELkfue8V8XOWPOCeMYsO7Mo4VMTLkUZebV9qmDqf8vrzrUO', 'j5XEfQV0SAMd8e1IbDboU3ICNGwylL1SkQdU42kBUqYi1OxpMGvpyVAzdf1v', '2020-06-14 08:21:31', '2020-06-14 08:21:31'),
  	(4, 3, 'kaka', 'kaka', 'kaka@gmail.com', '012666777', 'kaka@gmail.com', NULL, NULL, NULL, NULL, '$2y$10$rBTRVmPBAPgrpeYG85FyGOwqqmNYDuRs9MnkSMUwVLv9XQ7EMrAAu', 'psYkWA0V4lUifcu6Ak63ASwgeO9gIKcxCXcVOjFbp6lk8pewNimr0c29oL0c', '2020-06-15 07:59:19', '2020-06-15 07:59:19');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  