/* SQLyog Ultimate MySQL - 11.0.2-MariaDB : Database - tddsr_db ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `auth_menu` */ CREATE TABLE `auth_menu` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `menu_code` varchar(255) DEFAULT NULL, `menu_name` varchar(255) DEFAULT NULL, `menu_url` varchar(255) DEFAULT NULL, `menu_icon` varchar(255) DEFAULT NULL, `menu_image` varchar(255) DEFAULT NULL, `menu_parent` int(11) DEFAULT NULL, `menu_level` int(11) DEFAULT NULL, `menu_group` int(11) DEFAULT NULL, `menu_order` int(11) DEFAULT NULL, `menu_status` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `auth_menu` */ insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (1,NULL,'ໜ້າທຳອິດ','index','mdi mdi-laptop',NULL,1,0,1,1,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (2,NULL,'ເພີ່ມຂໍ້ມູນສະຖິຕິ',NULL,'mdi mdi-square-edit-outline',NULL,2,1,2,2,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (3,NULL,'ນັກທ່ອງທ່ຽວເຂົ້າດ່ານ','touristin','mdi mdi-chevron-right',NULL,2,2,2,2001,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (4,NULL,'ນັກທ່ອງທ່ຽວເຂົ້າແຂວງ','touristinprovince','mdi mdi-chevron-right',NULL,2,2,2,2002,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (5,NULL,'ນັກທ່ອງທ່ຽວພາຍໃນ','touristdomestict','mdi mdi-chevron-right',NULL,2,2,2,2003,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (6,NULL,'ນັກທ່ອງທ່ຽວລາວອອກດ່ານ','touristout','mdi mdi-chevron-right',NULL,2,2,2,2004,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (7,NULL,'ລາຍງານ',NULL,'mdi mdi-file-document-edit-outline',NULL,3,1,7,7,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (8,NULL,'ນັກທ່ອງທ່ຽວເຂົ້າດ່ານ',NULL,'mdi mdi-chevron-right',NULL,3,2,7,7001,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (9,NULL,'ນັກທ່ອງທ່ຽວເຂົ້າແຂວງ',NULL,'mdi mdi-chevron-right',NULL,3,2,7,7002,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (10,NULL,'ນັກທ່ອງທ່ຽວພາຍໃນ',NULL,'mdi mdi-chevron-right',NULL,3,2,7,7003,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (11,NULL,'ນັກທ່ອງທ່ຽວລາວອອກດ່ານ',NULL,'mdi mdi-chevron-right',NULL,3,2,7,7004,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (12,NULL,'ຈັດການຂໍ້ມູນລະບົບ',NULL,'mdi mdi-cog',NULL,4,1,12,12,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (13,NULL,'ຈັດການຂໍ້ມູນພະນັກງານ','employee','mdi mdi-chevron-right',NULL,4,2,12,12001,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (14,NULL,'ຈັດການຂໍ້ມູນດ່ານ',NULL,'mdi mdi-chevron-right',NULL,4,2,12,12002,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (15,NULL,'ຈັດການຂໍ້ມູນປະເທດ',NULL,'mdi mdi-chevron-right',NULL,4,2,12,12003,'Y',NULL,NULL,NULL); insert into `auth_menu`(`id`,`menu_code`,`menu_name`,`menu_url`,`menu_icon`,`menu_image`,`menu_parent`,`menu_level`,`menu_group`,`menu_order`,`menu_status`,`created_at`,`updated_at`,`deleted_at`) values (16,NULL,'ຈັດການຂໍ້ມູນຮູບແບບການເດີນທາງ',NULL,'mdi mdi-chevron-right',NULL,4,2,12,12004,'Y',NULL,NULL,NULL); /*Table structure for table `auth_permision` */ CREATE TABLE `auth_permision` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `permistion_code` varchar(255) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `auth_permision` */ /*Table structure for table `auth_permision_role` */ CREATE TABLE `auth_permision_role` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `permision_role_code` varchar(255) DEFAULT NULL, `permision_role_name` varchar(255) DEFAULT NULL, `permision_role_desc` varchar(255) DEFAULT NULL, `permision_role_status` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `auth_permision_role` */ /*Table structure for table `auth_role` */ CREATE TABLE `auth_role` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_name` varchar(255) DEFAULT NULL, `role_desc` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `auth_role` */ insert into `auth_role`(`id`,`role_name`,`role_desc`,`created_at`,`updated_at`,`deleted_at`) values (1,'ຜູ້ດູແລລະບົບ',NULL,NULL,NULL,NULL); insert into `auth_role`(`id`,`role_name`,`role_desc`,`created_at`,`updated_at`,`deleted_at`) values (2,'ແອັດມິນລະບົບ',NULL,NULL,NULL,NULL); insert into `auth_role`(`id`,`role_name`,`role_desc`,`created_at`,`updated_at`,`deleted_at`) values (3,'ພະນັກງານທົ່ວໄປ',NULL,NULL,NULL,NULL); /*Table structure for table `auth_role_users` */ CREATE TABLE `auth_role_users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, `role_users_status` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `auth_role_users` */ /*Table structure for table `cache` */ CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `cache` */ /*Table structure for table `cache_locks` */ CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `cache_locks` */ /*Table structure for table `failed_jobs` */ CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `failed_jobs` */ /*Table structure for table `job_batches` */ CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `job_batches` */ /*Table structure for table `jobs` */ CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `jobs` */ /*Table structure for table `migrations` */ CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `migrations` */ insert into `migrations`(`id`,`migration`,`batch`) values (5,'0001_01_01_000000_create_users_table',1); insert into `migrations`(`id`,`migration`,`batch`) values (6,'0001_01_01_000001_create_cache_table',1); insert into `migrations`(`id`,`migration`,`batch`) values (7,'0001_01_01_000002_create_jobs_table',1); insert into `migrations`(`id`,`migration`,`batch`) values (8,'2024_03_30_084752_create_personal_access_tokens_table',1); /*Table structure for table `params_border` */ CREATE TABLE `params_border` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bt_id` varchar(255) DEFAULT NULL, `border_name_la` varchar(255) DEFAULT NULL, `border_name_en` varchar(255) DEFAULT NULL, `province_code` varchar(255) DEFAULT NULL, `nearmiss` int(11) DEFAULT NULL COMMENT 'ຕິດກັບປະເທດ', `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `params_border` */ insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (1,'1','ສະໜາມບີນວັດໄຕ','Wattay Airport','01',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (2,'1','ສະໜາມບີນສະຫວັນນະເຂດ','Savanh Airport','13',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (3,'1','ສະໜາມບີນປາກເຊ','Pakse Airport','16',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (4,'1','ສະໜາມບີນຫຼວງພະບາງ','Luangprabang Airport','06',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (5,'1','ຂົວມິດຕະພາບ I','Mitthaphab Bridge I','01',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (6,'1','ສະຖານີລົດໄຟທ່ານາແລ້ງ','Thanaleng Railway Station','01',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (7,'1','ບໍ່ເຕັນ','Boten','03',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (8,'1','ຫ້ວຍຊາຍ',NULL,'05',NULL,NULL,NULL,NULL,NULL,1,'2024-06-03 22:25:41'); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (9,'1','ຂົວມິດຕະພາບ II','Mitthaphab Bridge II','13',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (10,'1','ແດນສະຫວັນ','Dane Savanh','13',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (11,'1','ວັງເຕົ່າ','Vang Tao','16',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (12,'1','ໜອງນົກຂຽນ','Nong Nok Khian','16',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (13,'1','ນ້ຳພາວ','Namphao','11',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (14,'1','ທ່າເຮືອປາກຊັນ','Pakxan Port','11',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (15,'1','ຂົວມິດຕະພາບ III','Mitthaphab Bridge III','12',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (16,'1','ທ່າແຂກ',NULL,'12',NULL,NULL,NULL,NULL,NULL,1,'2024-06-03 22:25:41'); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (17,'1','ນາເພົ້າ','Naphao','12',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (18,'1','ຂົວມິດຕະພາບນ້ຳເຫືອງ','Nam Heuang Bridge','08',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (19,'1','ນ້ຳເງີນ','Nam Ngeun','08',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (20,'1','ພູດູ່','Phou dou','08',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (21,'1','ນ້ຳກັ່ນ','Nam Kanh','09',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (22,'1','ນ້ຳໂສຍ','Nam Souy','07',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (23,'1','ປາງຫົກ','Pang Hok','02',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (24,'1','ລານຕຸ້ຍ','Larn Tuai','02',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (25,'1','ພູເກືອ','Phou Keua','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (26,'1','ຂົວມິດຕະພາບ IV','Mitthaphab Bridge IV','05',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (27,'1','ສາມຫລ່ຽມຄຳ','Golden Triangles','05',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (28,'1','ບ້ານເມືອງມອນ','Ban Mueang Mone','05',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (29,'1','ລະໄລ','Lalai','14',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (33,'1','ບໍ່ເຕັ່ນ (ທາງລົດໄຟ-ບໍ່ເຕັນ) (ຢູນາ)','Boten (Railway)','03',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (34,'1','ດົງໂພສີ (ທ່າບົກ - ທ່ານາແລ້ງ) (ໜອງຄາຍ)','Dong pho see (thabok - Thanalaeng)','01',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (35,'1','ວັງເຕົ່າ (ທ່າບົກ - ວັງເຕົ່າ) (ອຸບົນ)','Vang Tao (Thabok - VangTao)','16',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (36,'1','ດາກຕະອ໋ອກ (ກວາງນາມ)','Dak Ta Ork','15',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (37,'1','ປາງມອນ (ພະເຍົາ)','Pang Mon','08',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (38,'2','ດ່ານປ່າຮ່າງ','Pa Hang','07',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (39,'2','ດ່ານບ້ານດ່ານ','Ban Dan','07',NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_border`(`id`,`bt_id`,`border_name_la`,`border_name_en`,`province_code`,`nearmiss`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (40,'2','ດ່ານສົມຫວັງ','Som Wang','07',NULL,NULL,NULL,NULL,NULL,NULL,NULL); /*Table structure for table `params_continents` */ CREATE TABLE `params_continents` ( `id` int(2) unsigned NOT NULL AUTO_INCREMENT, `c_name_la` varchar(150) DEFAULT NULL, `c_name_en` varchar(150) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `params_continents` */ insert into `params_continents`(`id`,`c_name_la`,`c_name_en`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (0,'ກຸ່ມປະເທດອາຊຽນ','Asean',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_continents`(`id`,`c_name_la`,`c_name_en`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (1,'ອາຊີ ແລະ ປາຊີຟິກ','Asia and Pacific',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_continents`(`id`,`c_name_la`,`c_name_en`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (2,'ເອີລົບ','Europe',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_continents`(`id`,`c_name_la`,`c_name_en`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (3,'ອາເມລິກາ','The Americas',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_continents`(`id`,`c_name_la`,`c_name_en`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (4,'ອາຟຣິກາ ແລະ ຕາເວັນອອກກາງ\r\n','Africa and Middle East',NULL,NULL,NULL,NULL,NULL,NULL); /*Table structure for table `params_country` */ CREATE TABLE `params_country` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ct_code` varchar(3) DEFAULT NULL, `ct_name_la` varchar(200) DEFAULT NULL, `ct_name_en` varchar(200) DEFAULT NULL, `ctg_id` int(11) DEFAULT NULL, `c_id` varchar(2) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=516 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `params_country` */ insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (1,'AFG','ສາທາລະນະລັດອິດສະລາມຂອງອັຟການິສະຖານ','the Islamic Republic of Afghanistan ',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (2,'ARE','ສະຫະລັດອາຣັບເອມີເຣດ','United Arab Emirates',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (3,'ARM','ອາເມເນຍ','Armenia',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (4,'AUS','ອອສເຕຣເລຍ','Australia',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (5,'BGD','ບັງກະລາເທດ','Bangladesh',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (6,'BHR','ບາເຣນ','Bahrain',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (7,'BRN','ບຣູໄນ ດາຣູຊາລາມ ','Brunei Darussalam',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (8,'BTN','ພູຖານ','Bhutan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (9,'CHN','ຈີນ','China',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (10,'CYP','ໄຊປຣັສ','Cyprus',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (11,'DNK','ເດນມາກ','Denmark',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (12,'FJI','ຟິຈິ','Fiji',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (13,'GEO','ຈໍເຈຍ','Georgia',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (14,'HKG','ຮົງ​ກົງ','Hong Kong',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (15,'IDN','ອິນໂດເນເຊຍ','Indonesia',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (16,'IND','ອິນເດຍ','India',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (17,'IRN','ອີຣ່ານ (ສາທາລະນະລັດອິສລາມ)','Iran (Islamic Republic of)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (18,'IRQ','ອີຣັກ','Iraq',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (19,'ISR','ອິດສະຣາເອນ','Israel',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (20,'JOR','ຈໍແດນ','Jordan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (21,'JPN','ຍີ່ປຸ່ນ','Japan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (22,'KAZ','ຄາຊັກສະຖານ','Kazakhstan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (23,'KGZ','ກີກີສະຖານ','Kyrgyzstan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (24,'KHM','ກຳປູເຈຍ','Cambodia',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (25,'KOR','ເກົາຫຼີ (ສາທາລະນະລັດ)','Korea (the Republic of)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (26,'KWT','ຄູເວດ','Kuwait',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (27,'KIR','ຄິລິບາດ','Kiribati',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (28,'LAO','ສາທາລະນະລັດ ປະຊາທິປະໄຕ ປະຊາຊົນລາວ','Lao People\'s Democratic Republic (the)',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (29,'LBN','ເລບານອນ','Lebanon',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (30,'LKA','ສີ​ລັງ​ກາ.','Sri Lanka',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (31,'MMR','ມຽນມາ.','Myanmar',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (32,'MHL','ຫມູ່​ເກາະ​ມາ​ແຊ​ລ','Marshall Islands (the)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (33,'MNG','ມົງໂກເລຍ','Mongolia',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (34,'MYS','ມາເລເຊຍ','Malaysia',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (35,'MDV','ມັສດີຟສ','Maldives',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (36,'MAC','ມາເກົ້າ','Macao',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (37,'NRU','ນາອູຣູ','Nauru',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (38,'NPL','ເນປານ','Nepal',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (39,'NZL','ນິວ​ຊີ​ແລນ','New Zealand',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (40,'OMN','ໂອມານ','Oman',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (41,'PAK','ປາກິສຖານ','Pakistan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (42,'PHL','ຟີ​ລິບ​ປິນ','Philippines (the)',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (43,'PNG','ປາປົວນິວກີນີ','Papua New Guinea',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (44,'PRK','ເກົາ​ຫຼີ​ເຫນືອ','North Korea',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (45,'PSE','ລັດປາເລສໄຕ','the State of Palestine ',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (46,'PLW','ປາເລຼົາ','Palau.',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (47,'QAT','ກາຕາ','Qatar',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (48,'SAU','ຊາ​ອຸ​ດິ​ອາ​ຣາ​ເບຍ','Saudi Arabia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (49,'SGP','ສິງກະໂປ','Singapore',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (50,'SYR','ຊີ​ເຣຍ','Syria',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (51,'SLB','ໝູ່ເກາະໂຊໂລມອນ','Solomon Islands',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (52,'THA','ໄທ','Thailand',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (53,'TMP','ຕີມໍຕາເວັນອອກ','East Timor',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (54,'TUV','ຕູວາລູ','Tuvalu',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (55,'TUR','ຕຸລະກີ','Turkey',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (56,'TWN','ໄຕ້ຫວັນ (ແຂວງຂອງຈີນ)','Taiwan (Province of China)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (57,'TJK','ທາຈິກິດສະຖານ','Tajikistan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (58,'TKM','ເຕີກເມນິສະຖານ','Turkmenistan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (59,'TON','ຕອງກາ','Tonga',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (60,'UZB','ອຸສເບກິສຖານ','Uzbekistan',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (61,'VNM','ຫວຽດນາມ','Viet Nam',1,'00',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (62,'VUT','ວານູອາຕູ','Vanuatu',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (63,'YEM','ເຢເມນ','Yemen',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (64,'WSM','ຊາມົວ','Samoa',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (65,'CCK','ໂຄໂຄ','Cocos (Keeling) Islands (the)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (66,'COK','ໝູ່ເກາະ ຄຸກໄອເລີນ','Cook Islands (the)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (67,'FSM','ໄມໂຄຣນີເຊຍ','Micronesia',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (68,'GUM','ກວມ','Guam',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (69,'HMD','ເກາະເອີສດ ແລະ ໝູ່ເກາະແມັກໂຄນັສ ','Heard Island and McDonald Islands',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (70,'IOT','ດິນແດນມະຫາສະໝຸດອິນເດຍຂອງອັງກິດ','British Indian Ocean Territory',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (71,'MNP','ມາເຣຍນາ','Northern Mariana Islands (the)',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (72,'NIU','ນີອູເອ','Niue',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (73,'NFK','ເກາະນໍໂຟກາລັນຄໍ','Norfolk Island',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (74,'PCN','ພິດເຄນ','Pitcairn',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (75,'SHN','ເຊນເຮເລນ່າ','Saint Helena, Ascension and Tristan da Cunha',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (76,'TKL','ໂຕເກເລົາ','Tokelau',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (77,'ALB','ອານບານີ','Albania',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (78,'AUT','ອອສເຕຣຍ','Austria',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (79,'AND','ອັນດໍຣາ','Andorra',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (80,'BEL','ປະເທດແບນຊິກ','Belgium',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (81,'BGR','ບຸນກາຣີ','Bulgaria',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (82,'BIH','ບອສເນີຍ ແລະ ເຣີເຊໂກ','Bosnia and Herzegovina',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (83,'BLR','ເບລາຣຸດ','Belarus',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (84,'CHE','ສະວີດເຊີແລນ','Switzerland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (85,'CSK','ເຊັກໂກສະໂລວາເກຍ','Czechoslovakia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (86,'CZE','ເຊັກໂກ ','Czechia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (87,'DEU','ເຢຍລະມັນ','Germany',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (88,'DDR','ສາທາລະນະລັດເຢຍລະມັນ','East Germany',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (89,'ESP','ສະເປນ','Spain',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (90,'EST','ເອສໂຕເນຍ','Estonia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (91,'FIN','ຟິນແລນ','Finland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (92,'FRA','ຝຮັ່ງ','France',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (93,'GBR','ສະຫະລາຊະອານາຈັກ ','United Kingdom',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (94,'GRC','ເກຣັກ','Greece',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (95,'HRV','ໂຄຣເອເຊຍ.','Croatia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (96,'HUN','ຮັງກາຣີ','Hungary',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (97,'IRL','ໄອແລນ','Ireland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (98,'ISL','ໄອສແລນ','Iceland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (99,'ITA','​ອີ​ຕາ​ລີ','Italy',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (100,'LIE','ລີກເຕນສະໄຕ','Liechtenstein',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (101,'LTU','ລິທົວເນຍ','Lithuania',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (102,'LUX','ລັກເຊມເບີກ','Luxembourg',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (103,'LVA','ລັດເວຍ','Latvia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (104,'MCO','ໂມນາໂກ','Monaco',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (105,'MDA','ມອນໂດວາ (ສາທາລະນະລັດ)','Moldova (the Republic of)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (106,'MLT','ມາລຕາ','Malta',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (107,'MKD','ມາເຊໂດເນຍ','Macedonia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (108,'MNE','ມອນເຕເນໂກ','Montenegro',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (109,'NLD','ເນເທີແລນ','Netherlands (the)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (110,'NOR','ນໍເວ','Norway',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (111,'POL','ໂປແລນ','Poland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (112,'PRT','ປອກຕຸຍການ','Portugal',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (113,'ROM','ໂຣມາເນຍ','Romania',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (114,'RUS','ສະຫະພັນລັດເຊຍ','Russian Federation (the)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (115,'SMR','ຊານມາຣິໂນ','San Marino',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (116,'SVK','ສະໂລວາເກຍ','Slovakia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (117,'SVN','ສະໂລເວເນຍ','Slovenia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (118,'SWE','ສວີເດນ','Sweden',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (119,'SRB','ເຊີເບຍ','Serbia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (120,'UKR','ຢູເຄຣນ','Ukraine',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (121,'XXX','ບໍ່ໄດ້ກຳນົດສັນຊາດ','',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (122,'VAT','ວາຕິກັນ','Vatican',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (123,'ABW','ອາຣູບາ','Aruba',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (124,'AZE','ອາເຊີໄບຈັນ','Azerbaijan',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (125,'ATF','ອານາເຂດພາກໃຕ້ຊອງຝຣັ່ງ','French Southern Territories',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (126,'ANT','ເນເທີແລນແອນທີວ','Netherlands Antilles',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (127,'BMU','ເບີມູດາ','Bermuda',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (128,'BVT','ບູເວດ','Bouvet Island',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (129,'CYM','ໝູ່ເກາະເຄແມນ','Cayman Islands (the)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (130,'CXR','ເກາະຄິຣສຕໍມາສ','Christmas Island',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (131,'FLK','ໝູ່ເກາະຟອກແລນ','Falkland Islands',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (132,'FRO','ໝູ່ເກາະແຟໂຣ','Faroe Islands (the)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (133,'FXX','ຝຣັ່ງ,ເມໂທຣໂພລິຕັນ','FRANCE, METROPOLITAN',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (134,'GRL','ກຣີນແລນ','Greenland',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (135,'GUF','ເຟຣນເກຍ','French Guiana',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (136,'GIB','ຍິບບໍຣຕາ','Gibraltar',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (137,'GLP','ກົວດີລຸບ','Guadeloupe',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (138,'GBN','ສະຫະລາຊະອານາຈັກ GB ແລະໄອແລນເໜືອແຫ່ງຊາດ (ຢູ່ຕ່າງປະເທດ)','United Kingdom of GB and Northern Ireland National (overseas)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (139,'GBO','ສະຫະລາດຊະອານາຈັກ GB ແລະໄອແລນເໜືອ ພົນລະເມືອງຕ່າງປະເທດ','United Kingdom of GB and Northern Ireland Overseas citizen',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (140,'GBP','ສະຫະລັດອານາຈັກ GB ແລະ ບຸກຄົນທີ່ໄດ້ຮັບການຄຸ້ມຄອງໃນໄອສແລນເໜືອ','United Kingdom of GB and Northern Ireland Protected Person',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (141,'GBS','ສະຫະລັດອານາຈັກGB ແລະ ໄອສແລນເໜືອ ','United Kingdom of GB and Northern Ireland Subject ',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (142,'GBD','ສະຫະລັດອານາຈັກGB ແລະ ພາກເໜືອຂອງອານາເຂດທີ່ຂຶ້ນກັບພົນລະເມືອງ ','United Kingdom of GB and Northern Ireland Dependent territories citizen',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (143,'HVO','ບູຣກິນາຟັດໂສ','Upper Volta',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (144,'MTQ','ມາກາຣົດຕໍນີ','Martinique',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (145,'MYT','ມາຢອດ','Mayotte',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (146,'MSR','ມອນເຊີເຣນ','Montserrat',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (147,'NCL','ນິວຄາລິໂດເນຍ','New Caledonia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (148,'PYF','ເຟຣນໂຟລີນີເຊຍ','French Polynesia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (149,'REU','ຣີຢູນຽນ','Réunion',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (150,'SGS','ເກາະເຊົາຈໍເຈຍແລະແຊນວິດ','South Georgia and the South Sandwich Islands',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (151,'SJM','ສຟາລບາຣ','Svalbard and Jan Mayen',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (152,'SUN','ສະຫະພາບໂຊຫວຽດ','Sun Country Airlines',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (153,'TCA','ເຕີຣັກແລະໝູ່ເກາະເຄດອສ','Turks and Caicos Islands (the)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (154,'UNA','ໜວ່ຍງານສະຫະປະຊາຊາດ','United Nations Organization',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (155,'UNO','ອົງການສະຫະປະຊາຊາດ','UN/LOCODE Code List by Country and Territory',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (157,'VGB','ເກາະເວີກິນ(ອັງກິດ)','Virgin Islands (British)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (158,'YUG','ຢູໂກສະລາເວຍ','Yugoslavia',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (159,'WLF','ເກາະວາລິສແລະຟຸຕູນາ','Wallis and Futuna',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (160,'ARG','ອາເຈນຕິນາ','Argentina ',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (161,'ATG','ແອນຕີກາ ບາຣບູດາ','Antigua and Barbuda',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (162,'BOL','ໂບລິເວຍ ','Bolivia (Plurinational State of)',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (163,'BRA','ບຣາຊິນ','Brazil',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (164,'BHS','ບາຮາມາດ','Bahamas (the)',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (165,'BRB','ບາບາໂດສ','Barbados',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (166,'BLZ','ເບລີສ','Belize',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (167,'CAN','ການາດາ','Canada',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (168,'CHL','ຊີລີ','Chile',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (169,'COL','ໂຄລຳເບຍ','Colombia',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (170,'CRI','ຄອສຕາຣິກາ','Costa Rica',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (171,'CUB','ຄິວບາ','Cuba',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (172,'DOM','ສາທາລະນະລັດໂດມິນິກັນ','Dominican Republic',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (173,'DMA','ໂດມີນີກາ','Dominica',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (174,'ECU','ເອກົວດໍ','Ecuador',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (175,'GUY','ກູຢານາ','Guyana',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (176,'GTM','ກົວແຕມາລາ','Guatemala',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (177,'GRD','ເກຣເນດາ','Grenada',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (178,'HND','ຮອນດູຣັສ','Honduras',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (179,'HTI','ເຮຕີ','Haiti',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (180,'JAM','ຈາໄມກາ','Jamaica',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (181,'KNA','ແຊນຄິດສແລະເນວິດ','Saint Kitts and Nevis',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (182,'LCA','ເຊນຕໍລູເຊຍ','Saint Lucia',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (183,'MEX','ເມັກຊິໂກ','Mexico',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (184,'NIC','ນິກາຣາກົວ','Nicaragua',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (185,'PAN','ປານາມາ','Panama',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (186,'PER','ເປຣູ','Peru',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (187,'PRY','ປາຣາກວາຍ','Paraguay',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (188,'SLV','ເອສຊົວວາດໍຣ','El Salvador',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (189,'SUR','ສຸລິແນມ','Suriname',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (190,'TTO','ສາທາລະນະລັດຕຣິນິແດດແລະໂຕເບໂກ ','the Republic of Trinidad and Tobago',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (191,'URY','ອູຣູກວາຍ','Uruguay',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (192,'USA','ສະ​ຫະ​ລັດ','United States',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (193,'VEN','ເວເນຊູເອລາ (ສາທາລະນະລັດໂບລິວາຣີ)','Venezuela (Bolivarian Republic of)',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (194,'VCT','ເຊັນວິນເຊັນແລະເກຣນາດີນສ','Saint Vincent and the Grenadines',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (195,'AIA','ແອງກວິລລາ','Anguilla',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (196,'ATA','ແອນຕາກຕິກ','Antarctica',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (197,'ASM','ອາເມລິກັນ ຊາມົວ','American Samoa',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (198,'PRI','ເບີໂຕລິໂກ','Puerto Rico',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (199,'SPM','ແຊງປີແຍຣ ແລະ ມີເກີລົງ','Saint Pierre and Miquelon',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (200,'UMI','ເກາະນ້ອຍຮອບນອກຂອງສະຫະລັດອາເມຣິກາ','United States Minor Outlying Islands',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (202,'VIR','ເກາະເວີກິນ(ອາເມລິກາ)','U.S. Virgin Islands',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (203,'AGO','ອັງໂກລາ','Angola',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (204,'BDI','ບູຣຸນດີ','Burundi',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (205,'BWA','ບອດສະວານາ','Botswana',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (206,'BEN','ເບນິນ','Benin',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (207,'BFA','ເບີມາ','Burkina Faso',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (208,'CMR','ແຄເມີຣູນ','Cameroon',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (209,'CIV','ກົດດີວົວ','Côte d\'Ivoire',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (210,'COG','ຄອງໂກ','Congo (the)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (211,'CAF','ອັຟຣິກາກາງ','Central African Republic (the)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (212,'COM','ຄໍໂມໂຣສ','Comoros (the)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (213,'CPV','ເຄັບເວີຣດ','Cabo Verde',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (214,'DZA','ແອສຈີເລຍ','Algeria',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (215,'DJI','ຈິບູຕິ','Djibouti',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (216,'EGY','ເອຢິບ','Egypt',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (217,'ETH','ເອທີໂອເປຍ','Ethiopia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (218,'ERI','ເອຣິເທຣຍ','Eritrea',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (219,'GHA','ການາ ','Ghana',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (220,'GAB','ກາບອນ','Gabon',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (221,'GNB','ກິນີ-ບິສເຊົາ','Guinea-Bissau',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (222,'GIN','ກີນີ ','Guinea',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (223,'GNQ','ອີກົວໂຕລຽວ ກິວເນຍ','Equatorial Guinea',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (224,'GMB','ແກມເບຍ','Gambia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (225,'KEN','ເຄນຢາ','Kenya',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (226,'LSO','ເລໂຊໂທ','Lesotho',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (227,'LBR','ໄລບີເລຍ','Liberia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (228,'LBY','ລິເບຍ','Libya',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (229,'MAR','ໂມຣັອກໂຄ','Morocco',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (230,'MDG','ມາດາກັສກາ','Madagascar',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (231,'MLI','ມາລີ','Mali',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (232,'MRT','ມໍຣິຕາເນຍ','Mauritania',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (233,'MWI','ມາລາວີ','Malawi',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (234,'MOZ','ໂມຊຳບິກ','Mozambique',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (235,'MUS','ມໍເຊຍ','Mauritius',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (236,'NAM','ນາມິເບຍ','Namibia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (237,'NGA','ໄນຈີເຣຍ','Nigeria',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (238,'NER','ນີເກີ','Niger (the)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (239,'RWA','ຣວັນດາ','Rwanda',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (240,'SEN','ເຊເນການ','Senegal',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (241,'SWZ','ສະວາຊິແລນ.','Swaziland',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (242,'SDN','ຊູດານ','Sudan (the)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (243,'SLE','ເຊຍຣາລີໂອນ','Sierra Leone',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (244,'SOM','ໂຊມາເລຍ','Somalia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (245,'SYC','ເຊເຊວສ','Seychelles',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (246,'STP','ເຊົາຕູເມແລະປຣິນຊີປີ','Sao Tome and Principe',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (247,'TUN','ຕູນິເຊຍ','Tunisia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (248,'TCD','ຊາດ','Chad',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (249,'TZA','ແທນຊາເນຍ','Tanzania',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (250,'TGO','ໂຕໂກ ','Togo',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (251,'UGA','ອູກັນດາ','Uganda',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (252,'ZAF','ອາຟຣິກາໃຕ້','South Africa',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (253,'ZMB','ແຊມເບຍ','Zambia',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (254,'ZWE','ຊິມບັບເວ','Zimbabwe',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (255,'ESH','ເວດສເທີນສະຮາລາ','Western Sahara',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (257,'YMD','ສາທາລະນະລັດເຢເມນ','YEMEN, DEMOCRATIC',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (258,'ZAR','ຊາອີຣ','Zaire ',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (259,'NTZ','ນີວໂທໂຊນ','',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (512,'Ot4','ອື່ນໆ (ທະວີບອາຟິກາ)','Other (Africa)',2,'04',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (513,'Ot1','ອື່ນໆ (ທະວີບອາຊີ)','Other (Asia & Pacific))',2,'01',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (514,'Ot2','ອື່ນໆ (ທະວີບເອີລົບ)','Other (Europe)',2,'02',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_country`(`id`,`ct_code`,`ct_name_la`,`ct_name_en`,`ctg_id`,`c_id`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (515,'Ot3','ອື່ນໆ (ທະວີບອາເມລິກາ)','Other (Americas)',2,'03',NULL,NULL,NULL,NULL,NULL,NULL); /*Table structure for table `params_province` */ CREATE TABLE `params_province` ( `id` int(11) NOT NULL AUTO_INCREMENT, `provinceCode` varchar(10) DEFAULT NULL, `provinceLa` text DEFAULT NULL, `provinceEn` text DEFAULT NULL, `provinceAbbreviationLa` varchar(20) DEFAULT '', `provinceAbbreviationEn` varchar(20) DEFAULT '', `countryCode` varchar(10) DEFAULT '', `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `params_province` */ insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (1,'01','ນະຄອນຫຼວງວຽງຈັນ','Vientiane Capital','ນວຈ','VTC','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (2,'02','ຂ. ຜົ້ງສາລີ','Phongsaly Province','ຜສລ','PSL','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (3,'03','ຂ. ຫຼວງນ້ຳທາ','Luangnamtha Province','ຫນທ','LNT','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (4,'04','ຂ. ອຸດົມໄຊ','Oudomxay Province','ອດຊ','ODX','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (5,'05','ຂ. ບໍແກ້ວ','Bokeo Province','ບກວ','BOK','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (6,'06','ຂ. ຫຼວງພະບາງ','Luangprabang Province','ຫພບ','LPB','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (7,'07','ຂ. ຫົວພັນ','Houaphan Province','ຫວພ','HPH','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (8,'08','ຂ. ໄຊຍະບູລີ','Xayabouly Province','ຊຍລ','XYL','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (9,'09','ຂ. ຊຽງຂວາງ','Xiengkhuang Province','ຊຂວ','XKH','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (10,'10','ຂ. ວຽງຈັນ','Vientiane Province','ວຈນ','VTE','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (11,'11','ຂ. ບໍລິຄຳໄຊ','Bolikhamxay Province','ບຄຊ','BKX','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (12,'12','ຂ. ຄຳມ່ວນ','Khammouane Province','ຄມນ','KHM','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (13,'13','ຂ. ສະຫວັນນະເຂດ','Savannakhet Province','ສວຂ','SVK','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (14,'14','ຂ. ສາລະວັນ','Saravan Province','ສລວ','SLV','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (15,'15','ຂ. ເຊກອງ','Sekong Province','ຊກງ','SKG','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (16,'16','ຂ. ຈຳປາສັກ','Champasak Province','ຈປສ','CPS','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (17,'17','ຂ. ອັດຕະປື','Attapue Province','ອຕປ','ATP','LA',NULL,NULL,NULL,NULL,NULL,NULL); insert into `params_province`(`id`,`provinceCode`,`provinceLa`,`provinceEn`,`provinceAbbreviationLa`,`provinceAbbreviationEn`,`countryCode`,`created_by`,`created_at`,`updated_by`,`updated_at`,`deleted_by`,`deleted_at`) values (18,'18','ຂ. ໄຊສົມບູນ','Xaysomboun Province','ຊສບ','XSB','LA',NULL,NULL,NULL,NULL,NULL,NULL); /*Table structure for table `password_reset_tokens` */ CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `password_reset_tokens` */ /*Table structure for table `personal_access_tokens` */ CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `personal_access_tokens` */ insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (1,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','7defd0493bf2fd32901a3b40650d51eb2070d752fa6debe2206bda4b1e4cf7e5','[\"*\"]',NULL,'2024-04-10 21:58:39','2024-04-10 09:58:39','2024-04-10 09:58:39'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (2,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','104c576f23f0964b616850ff3787e35a0aa9be8c002c3571e7b5be1f7500f5e3','[\"*\"]',NULL,'2024-04-10 21:59:36','2024-04-10 09:59:36','2024-04-10 09:59:36'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (3,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','ad0b21497ab95f48b1d3af2856301fc06aa7e49d1d11b513ea7cf9e986fa0e7c','[\"*\"]',NULL,'2024-04-10 22:05:22','2024-04-10 10:05:22','2024-04-10 10:05:22'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (4,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','8ec2645b9b664e5ae818fbbdcabae7debe9a25f6486f882b837c27bf06dba000','[\"*\"]',NULL,'2024-04-10 22:05:35','2024-04-10 10:05:35','2024-04-10 10:05:35'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (5,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','78b9a6b1a3e6e5952c73917fe95d5ba9fa57206b81e250fbef4bdbc1efae4989','[\"*\"]','2024-04-10 10:10:38','2024-04-10 22:06:01','2024-04-10 10:06:01','2024-04-10 10:10:38'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (6,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','43eead1216c15a48feda63fec0a8dbea3d0d2d7f38b77ea2f3d55452200a979d','[\"*\"]','2024-04-10 15:18:58','2024-04-10 22:10:50','2024-04-10 10:10:50','2024-04-10 15:18:58'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (7,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','c42fd97299d22574fbe38fde952b097fe192e88bc7ca274d6620247a72b19bad','[\"*\"]','2024-04-10 17:23:34','2024-04-11 03:22:20','2024-04-10 15:22:20','2024-04-10 17:23:34'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (8,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','97b7ac536c6570df41b5339abc6b6e401fbe9d314d1f4b06d970cccd983713bb','[\"*\"]','2024-04-10 20:49:42','2024-04-11 05:23:53','2024-04-10 17:23:53','2024-04-10 20:49:42'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (9,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','9fcffd818aae341413d5b5d518cfb95f8542a72c807ffa15d512627ca3e8fa27','[\"*\"]','2024-04-10 20:56:03','2024-04-11 08:56:01','2024-04-10 20:56:01','2024-04-10 20:56:03'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (10,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','9aeb1bf71707e6a77fc51ac2fe43cbdbe38cdcbf6fb71e39609be8882afa9985','[\"*\"]','2024-04-10 20:57:46','2024-04-11 08:56:40','2024-04-10 20:56:40','2024-04-10 20:57:46'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (11,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','eb6838e2def53e9c5e509d3fb22847a33df3a71179e7bbeb5a2642d14dba59f1','[\"*\"]','2024-04-10 20:58:42','2024-04-11 08:58:41','2024-04-10 20:58:41','2024-04-10 20:58:42'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (12,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','bd3b85f38c69a891103a6afead3432e26bec546abcb7724573c3e760d9e707ce','[\"*\"]','2024-04-10 21:00:07','2024-04-11 08:59:06','2024-04-10 20:59:06','2024-04-10 21:00:07'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (13,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','e6f70720c5bcc12e51cfd10a98fe4fcf34905bb4c077ca4bb6c05682597e747e','[\"*\"]','2024-04-10 21:01:06','2024-04-11 09:01:06','2024-04-10 21:01:06','2024-04-10 21:01:06'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (14,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','55d841e8900a17347744ba63e741fe3ea350457eaefb6a1f24d3b81cffac2fd4','[\"*\"]','2024-04-10 21:02:34','2024-04-11 09:01:47','2024-04-10 21:01:47','2024-04-10 21:02:34'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (15,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','ea490b0b42e079cc9f679f7221a8ade6e553bb712cc14fa0fbddbb56b4241f39','[\"*\"]','2024-04-10 21:06:13','2024-04-11 09:03:55','2024-04-10 21:03:55','2024-04-10 21:06:13'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (16,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','e0d231258c8123af4a8f80ab18baf622d2afeb4a49313e8418b858de3a17729c','[\"*\"]','2024-04-10 21:06:22','2024-04-11 09:06:20','2024-04-10 21:06:20','2024-04-10 21:06:22'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (17,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','9edcce6f8e9953ffd2dd330683342005c853d3c5a158f73f0e0762d7f05e20bf','[\"*\"]','2024-04-10 21:07:16','2024-04-11 09:07:16','2024-04-10 21:07:16','2024-04-10 21:07:16'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (18,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','8f3c94e43595bb94f02a1631589cc424d6ba9f610adaf76edec1d0c8798509d7','[\"*\"]','2024-04-10 21:07:42','2024-04-11 09:07:42','2024-04-10 21:07:42','2024-04-10 21:07:42'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (19,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','0dc66fc62723b2162e69b75d970d8a8a82afbcaed5481d90ab6ccd17faaa6344','[\"*\"]','2024-04-10 21:08:03','2024-04-11 09:08:03','2024-04-10 21:08:03','2024-04-10 21:08:03'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (20,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','d02db14c7d2bffc433d123c72953442bf0cb5744f09f7e8045b8f565fceab647','[\"*\"]','2024-04-10 21:11:29','2024-04-11 09:11:22','2024-04-10 21:11:22','2024-04-10 21:11:29'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (21,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','196ca662e761c9b3c89614222187ccb06b4778a36d2333bcfd904afca41aed81','[\"*\"]','2024-04-10 21:14:17','2024-04-11 09:14:17','2024-04-10 21:14:17','2024-04-10 21:14:17'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (22,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','a4b9d0b7c92c8d10f4b46202c9bbd930984c2608939391a779fd65d027a2863f','[\"*\"]','2024-04-10 21:14:53','2024-04-11 09:14:52','2024-04-10 21:14:52','2024-04-10 21:14:53'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (23,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','a1634821583ee8f3921e8a5ecc81c910764040feaaf898fa41fb68b5920cb0d7','[\"*\"]','2024-04-10 21:14:55','2024-04-11 09:14:55','2024-04-10 21:14:55','2024-04-10 21:14:55'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (24,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','17228ca0899595d2ca5060c50fbb3a8e57e5a35d7a48558cb6e6d4888fc21d67','[\"*\"]','2024-04-10 21:15:18','2024-04-11 09:15:17','2024-04-10 21:15:17','2024-04-10 21:15:18'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (25,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','fd323c480140bb1e3c10005c4c89419ba5c15f717128b056eeb5ef1e0ed445b0','[\"*\"]','2024-04-10 21:23:42','2024-04-11 09:21:02','2024-04-10 21:21:02','2024-04-10 21:23:42'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (26,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','ac202c5407b35716f430c89e4f976ddbe98ceac116594ce171b89d5e195bdd5f','[\"*\"]','2024-04-10 21:56:28','2024-04-11 09:26:45','2024-04-10 21:26:45','2024-04-10 21:56:28'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (27,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','b647ecccc83fe073beabb32b4291f5c3f18b6325b4fbbb488aab2ed01e945e6d','[\"*\"]','2024-04-10 22:11:02','2024-04-11 09:57:16','2024-04-10 21:57:16','2024-04-10 22:11:02'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (28,'App\\Models\\User',2,'administrator','26549c41b1ab996e65aa52cc2cd2a9b00a6c82e5536e36dcb321d731773b0b86','[\"*\"]','2024-04-10 22:20:30','2024-04-11 10:11:50','2024-04-10 22:11:50','2024-04-10 22:20:30'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (29,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','1cbc9d20b8660233b842ca8f91b06bec473dd323614ada4606b894e7e1824a24','[\"*\"]','2024-04-10 22:39:00','2024-04-11 10:21:31','2024-04-10 22:21:31','2024-04-10 22:39:00'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (30,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','113b6c8d3baf3715fcc0b394cb8b8bd09c1fd6bb4016248062330a9960a04295','[\"*\"]','2024-04-10 22:41:55','2024-04-11 10:41:53','2024-04-10 22:41:53','2024-04-10 22:41:55'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (31,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','51937024bf285c0eb5dcfb2071f855333f4bc40cbe3d90d02a3806cc0f54be6c','[\"*\"]','2024-04-10 22:42:51','2024-04-11 10:42:48','2024-04-10 22:42:48','2024-04-10 22:42:51'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (32,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','f628e1df2b3ab04faa7dc9d0043603390023fb3ad69c0b39463809a4fb618891','[\"*\"]','2024-04-10 22:45:49','2024-04-11 10:45:46','2024-04-10 22:45:46','2024-04-10 22:45:49'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (33,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','d6fb7f2609f98fd748f87f67012243f36f9c9d9ed99ca08df22d920eabf25db8','[\"*\"]','2024-04-10 22:46:25','2024-04-11 10:46:20','2024-04-10 22:46:20','2024-04-10 22:46:25'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (34,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','6851518fc193ef21b8bb1856932b57b92a351b878f8be7978decc6ed50e92616','[\"*\"]','2024-04-10 22:47:48','2024-04-11 10:46:48','2024-04-10 22:46:48','2024-04-10 22:47:48'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (35,'App\\Models\\User',2,'administrator','022627754f48c6c803a890316f9ffaba47d93579e4efecf530bd149a58d79660','[\"*\"]','2024-04-10 22:48:36','2024-04-11 10:48:05','2024-04-10 22:48:05','2024-04-10 22:48:36'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (36,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','57ef04df3c42ffaa48574380048e4d20905128f8b1d4156becc73c66942f34e7','[\"*\"]','2024-04-11 10:03:34','2024-04-11 10:48:47','2024-04-10 22:48:47','2024-04-11 10:03:34'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (37,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','f0015afc0995a3b534434cc9d8d3b6591164768c4bcf1b70a595c6f8daf637a4','[\"*\"]','2024-04-11 23:13:40','2024-04-12 10:56:19','2024-04-11 22:56:19','2024-04-11 23:13:40'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (38,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','ce78b011a930147287e45c4a3cec5cfd2d23d2f44fdee86926cd3f9dd8cdba7f','[\"*\"]','2024-04-12 21:39:00','2024-04-13 09:29:31','2024-04-12 21:29:31','2024-04-12 21:39:00'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (39,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','ab8faba67202374710b496be54aae3409a6a9565c21a49224968a9421e015e3d','[\"*\"]','2024-06-03 22:45:19','2024-06-04 10:03:24','2024-06-03 22:03:24','2024-06-03 22:45:19'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (40,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','5397a4783c9f47b37f7f4de722c34fee24a4815d72c4d41868bc78547c382644','[\"*\"]','2024-06-03 22:57:03','2024-06-04 10:47:33','2024-06-03 22:47:33','2024-06-03 22:57:03'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (41,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','7d5d91c0310eea7a71790fd5d72a70c183934822bd30eb285a018afb17d2eeeb','[\"*\"]','2024-06-03 23:30:57','2024-06-04 10:57:25','2024-06-03 22:57:25','2024-06-03 23:30:57'); insert into `personal_access_tokens`(`id`,`tokenable_type`,`tokenable_id`,`name`,`token`,`abilities`,`last_used_at`,`expires_at`,`created_at`,`updated_at`) values (42,'App\\Models\\User',1,'ວິສາຄອນ ຊະນະມົງຄຸນ','0b5823b551c4b7dd32f67ebe0803314278da06721098c27ea1bfb67fc58875e7','[\"*\"]','2024-06-03 23:32:21','2024-06-04 11:31:07','2024-06-03 23:31:07','2024-06-03 23:32:21'); /*Table structure for table `sessions` */ CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `sessions` */ /*Table structure for table `tourist_in_statistic` */ CREATE TABLE `tourist_in_statistic` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ts_year` varchar(255) DEFAULT NULL, `ts_month` varchar(255) DEFAULT NULL, `ts_boder` varchar(255) DEFAULT NULL, `ts_continents` varchar(255) DEFAULT NULL, `ts_country` varchar(255) DEFAULT NULL, `ts_travel_doc` varchar(255) DEFAULT NULL, `male` decimal(18,0) DEFAULT NULL COMMENT 'ຊາຍ', `female` decimal(18,0) DEFAULT NULL COMMENT 'ຍິງ', `child` decimal(18,0) DEFAULT NULL COMMENT 'ເດັກ', `through` decimal(18,0) DEFAULT NULL COMMENT 'ຜ່ານ', `total1` decimal(18,0) DEFAULT NULL COMMENT 'ທັງໝົດ', `diplomacy` decimal(18,0) DEFAULT NULL COMMENT 'ການທູດ', `government` decimal(18,0) DEFAULT NULL COMMENT 'ລັດຖະການ', `visit` decimal(18,0) DEFAULT NULL COMMENT 'ຢ້ຽມຍາມ', `tourism` decimal(18,0) DEFAULT NULL COMMENT 'ທ່ອງທ່ຽວ', `business` decimal(18,0) DEFAULT NULL COMMENT 'ທຸລະກິດ', `others` decimal(18,0) DEFAULT NULL COMMENT 'ອື່ນໆ', `total2` decimal(18,0) DEFAULT NULL COMMENT 'ທັງໝົດ', `ts_status` varchar(255) DEFAULT 'Active', `ts_province` varchar(255) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_month` (`ts_month`), KEY `idx_year` (`ts_year`), KEY `idx_province` (`ts_province`), KEY `idx_status` (`ts_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `tourist_in_statistic` */ /*Table structure for table `users` */ CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `fullname_la` varchar(255) NOT NULL, `fullname_en` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `username` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role_id` int(11) DEFAULT NULL, `province_id` varchar(255) DEFAULT NULL, `is_active` varchar(255) DEFAULT NULL, `is_change_password` varchar(255) DEFAULT NULL, `last_login` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_username_unique` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*Data for the table `users` */ insert into `users`(`id`,`fullname_la`,`fullname_en`,`address`,`username`,`email_verified_at`,`password`,`role_id`,`province_id`,`is_active`,`is_change_password`,`last_login`,`remember_token`,`created_at`,`updated_at`,`deleted_at`) values (1,'ວິສາຄອນ ຊະນະມົງຄຸນ','visakhone sanamongkhoun','address','visakhone',NULL,'$2y$12$t3MGu.lbokDfwWeaGytdEudlq2gHXF199BaeBjGL7R7/TEPvIREl.',1,'01','Y','N','2024-06-03 23:31:07',NULL,'2024-04-10 09:57:41','2024-06-03 23:31:07',NULL); insert into `users`(`id`,`fullname_la`,`fullname_en`,`address`,`username`,`email_verified_at`,`password`,`role_id`,`province_id`,`is_active`,`is_change_password`,`last_login`,`remember_token`,`created_at`,`updated_at`,`deleted_at`) values (2,'administrator',NULL,NULL,'admin',NULL,'$2y$12$RY7MS/eNwT9.2OoPNSomK.kA0DOiS.xO4ndiAo3dACiMssjgimw.S',2,'01','Y','N','2024-04-10 22:48:05',NULL,'2024-04-10 21:57:31','2024-04-10 22:48:05',NULL); insert into `users`(`id`,`fullname_la`,`fullname_en`,`address`,`username`,`email_verified_at`,`password`,`role_id`,`province_id`,`is_active`,`is_change_password`,`last_login`,`remember_token`,`created_at`,`updated_at`,`deleted_at`) values (3,'administrator',NULL,NULL,'admin2',NULL,'$2y$12$9W.OxsWB6C/DV86eLVMyoOwXJ6sb9bL.Eu40x39sBWxIOKwMsQdPO',3,'01','Y','N',NULL,NULL,'2024-04-10 21:58:42','2024-04-10 22:48:28',NULL); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;