/*
SQLyog Ultimate
MySQL - 11.0.2-MariaDB : Database - tddsr_db
*********************************************************************
*/



/*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 `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 `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;

