
--
-- Table structure for table `products_readies`
--

CREATE TABLE `products_readies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(16,2) NOT NULL DEFAULT '0.00',
  `cost` double(16,2) NOT NULL DEFAULT '0.00',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(16,4) NOT NULL,
  `product_category_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `grn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL DEFAULT '0',
  `diamond_size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` bigint DEFAULT NULL,
  `wages` double NOT NULL,
  `for_sale` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products_readies`
--


--
-- Table structure for table `qty_histories`
--

CREATE TABLE `qty_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `qty` int NOT NULL DEFAULT '0',
  `qty_before_transaction` int NOT NULL DEFAULT '0',
  `qty_after_transaction` int NOT NULL DEFAULT '0',
  `product_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `grn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_category_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qty_histories`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(17,3);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','web','2024-04-10 10:45:40','2024-04-10 10:45:40'),(2,'Supervisor','web','2024-04-10 10:45:40','2024-04-10 10:45:40'),(3,'Staff','web','2024-04-10 10:45:40','2024-04-10 10:45:40');

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned DEFAULT NULL,
  `part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost` double(16,2) NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(16,4) NOT NULL,
  `product_category_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `wages` double NOT NULL,
  `invoice_no` int NOT NULL,
  `grn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL DEFAULT '1',
  `diamond_size` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `usd_amount` double DEFAULT NULL,
  `khr_amount` double DEFAULT NULL,
  `thb_amount` double DEFAULT NULL,
  `sales_price` double DEFAULT NULL,
  `member_id` bigint unsigned DEFAULT NULL,
  `discount` double(16,2) NOT NULL DEFAULT '0.00',
  `already_buy_back` tinyint(1) NOT NULL DEFAULT '0',
  `date_buy_back` timestamp NULL DEFAULT NULL,
  `buy_back_price` double(16,2) DEFAULT NULL,
  `buy_back_note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buy_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_usd_exchange_rate` double(16,2) DEFAULT NULL,
  `original_wages` double(16,2) DEFAULT NULL,
  `weight_description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `selling_cost` double(16,2) NOT NULL DEFAULT '0.00',
  `selling_rate` double(16,4) NOT NULL DEFAULT '0.0000',
  `fixed_price` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sales`
--


--
-- Table structure for table `sell_product_attributes`
--

CREATE TABLE `sell_product_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qty` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `cost` double(16,2) NOT NULL DEFAULT '0.00',
  `price` double(16,2) NOT NULL DEFAULT '0.00',
  `sell_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sell_product_attributes`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `shop_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fav_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'Crown Jewelry','អគារស៊ីសាន់ម៉ល ភូមិក្បាលស្ពាន១ សង្កាត់ប៉ោយប៉ែត ក្រុងប៉ោយប៉ែត, ខេត្តបន្ទាយមានជ័យ','031​ 555 5​02 2 / ​071 ​555 598 6 / 067 779 696','logo.png','fav.ico',1,NULL,'2024-04-10 10:45:35','2024-08-18 10:58:31');

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` VALUES (1,'MOM','','',NULL,'2024-08-26 06:30:04','2024-08-26 06:30:04'),(2,'KDD5','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(3,'KDD6','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(4,'KDD3','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(5,'KDD4','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(6,'KDD2','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(7,'KDD1','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(8,'KIM','','',NULL,'2024-08-26 06:30:09','2024-08-26 06:30:09'),(9,'KGG1','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(10,'KGG2','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(11,'KGG3','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(12,'KGG20','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(13,'KGG21','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(14,'KGG22','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(15,'KGG23','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(16,'KGG24','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(17,'KGG25','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(18,'KGG26','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(19,'KGG27','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(20,'KGG28','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(21,'KGG29','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(22,'KGG30','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(23,'KGG33','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(24,'KGG32','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(25,'KGG31','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(26,'KGG34','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(27,'KGG35','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(28,'KGG36','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(29,'KGG4','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(30,'KGG5','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(31,'KGG6','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(32,'KGG7','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(33,'KGG8','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(34,'KGG9','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(35,'KGG10','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(36,'KGG11','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(37,'KGG41','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(38,'KGG42','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(39,'KGG43','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(40,'KGG44','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(41,'KGG18','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(42,'KGG19','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(43,'KGG37','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(44,'KGG38','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(45,'KGG39','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(46,'KGG40','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(47,'KGG12','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(48,'KGG13','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(49,'KGG14','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(50,'KGG15','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(51,'KGG16','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(52,'KGG17','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(53,'KGG45','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(54,'KGG46','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(55,'KGG47','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(56,'KGG48','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(57,'KGG49','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(58,'KGG50','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(59,'KGG51','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(60,'KGG52','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(61,'KGG53','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(62,'KGG54','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(63,'KGG55','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(64,'KGG56','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(65,'KGG57','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(66,'KGG58','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(67,'KGG59','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(68,'KGG60','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(69,'KGG61','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(70,'KGG62','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(71,'KGG63','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(72,'KGG64','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(73,'KGG65','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(74,'KGG66','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(75,'KGG67','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(76,'KGG68','','',NULL,'2024-08-26 06:30:34','2024-08-26 06:30:34'),(77,'KGG69','','',NULL,'2024-08-26 06:30:35','2024-08-26 06:30:35'),(78,'KGG70','','',NULL,'2024-08-26 06:30:35','2024-08-26 06:30:35'),(79,'KGG71','','',NULL,'2024-08-26 06:30:35','2024-08-26 06:30:35'),(80,'KGG72','','',NULL,'2024-08-26 06:30:35','2024-08-26 06:30:35'),(81,'KGG73','','',NULL,'2024-08-26 06:30:35','2024-08-26 06:30:35'),(82,'Somen','','',NULL,'2024-08-26 06:30:52','2024-08-26 06:30:52'),(83,'KP158','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(84,'KP159','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(85,'K31.1','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(86,'K31','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(87,'KP55','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(88,'KP56','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(89,'KP162','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(90,'KP163','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(91,'KP164','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(92,'KP161','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(93,'KP160','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(94,'KP3','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(95,'KP4','','',NULL,'2024-08-26 06:31:24','2024-08-26 06:31:24'),(96,'KP30','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(97,'KP31','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(98,'KP5','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(99,'KP6','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(100,'KP7','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(101,'KP8','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(102,'KP9','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(103,'KP10','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(104,'KP165','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(105,'KP166','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(106,'KP167','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(107,'KP57','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(108,'KP58','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(109,'KP1','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(110,'KP2','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(111,'KP168','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(112,'KP169','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(113,'KP170','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(114,'KP171','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(115,'KP172','','',NULL,'2024-08-26 06:31:25','2024-08-26 06:31:25'),(116,'KP150','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(117,'KP153','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(118,'KP154','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(119,'KP149','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(120,'KP155','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(121,'KP157','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(122,'KP151','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(123,'KP152','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(124,'KP156','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(125,'KP97','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(126,'KP94','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(127,'KP92','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(128,'KP93','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(129,'KP95','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(130,'KP91','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(131,'KP98','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(132,'KP96','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(133,'KP68','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(134,'KP59','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(135,'KP62','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(136,'KP60','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(137,'KP66','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(138,'KP65','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(139,'KP61','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(140,'KP67','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(141,'KP64','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(142,'KP63','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(143,'KP79','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(144,'KP86','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(145,'KP89','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(146,'KP87','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(147,'KP90','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(148,'KP80','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(149,'KP81','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(150,'KP82','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(151,'KP83','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(152,'KP84','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(153,'KP88','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(154,'KP85','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(155,'KP78','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(156,'KP74','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(157,'KP70','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(158,'KP71','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(159,'KP77','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(160,'KP72','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(161,'KP73','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(162,'KP76','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(163,'KP75','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(164,'KP69','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(165,'KP128','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(166,'KP147','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(167,'KP101','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(168,'KP127','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(169,'KP145','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(170,'KP143','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(171,'KP103','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(172,'KP112','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(173,'KP99','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(174,'KP131','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(175,'KP134','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(176,'KP100','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(177,'KP104','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(178,'KP113','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(179,'KP108','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(180,'KP129','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(181,'KP133','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(182,'KP124','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(183,'KP123','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(184,'KP120','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(185,'KP102','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(186,'KP135','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(187,'KP139','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(188,'KP110','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(189,'KP115','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(190,'KP106','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(191,'KP105','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(192,'KP107','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(193,'KP140','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(194,'KP146','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(195,'KP118','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(196,'KP138','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(197,'KP109','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(198,'KP148','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(199,'KP121','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(200,'KP116','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(201,'KP126','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(202,'KP114','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(203,'KP132','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(204,'KP144','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(205,'KP125','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(206,'KP141','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(207,'KP136','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(208,'KP130','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(209,'KP122','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(210,'KP111','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(211,'KP142','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(212,'KP117','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(213,'KP119','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(214,'KP137','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(215,'KP37','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(216,'KP54','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(217,'KP52','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(218,'KP50','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(219,'KP42','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(220,'KP51','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(221,'KP41','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(222,'KP49','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(223,'KP47','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(224,'KP35','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(225,'KP48','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(226,'KP40','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(227,'KP34','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(228,'KP39','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(229,'KP38','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(230,'KP44','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(231,'KP45','','',NULL,'2024-08-26 06:31:39','2024-08-26 06:31:39'),(232,'KP32','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(233,'KP33','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(234,'KP53','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(235,'KP43','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(236,'KP36','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(237,'KP46','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(238,'KP23','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(239,'KP11','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(240,'KP28','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(241,'KP22','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(242,'KP13','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(243,'KP29','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(244,'KP15','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(245,'KP27','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(246,'KP16','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(247,'KP26','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(248,'KP18','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(249,'KP17','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(250,'KP21','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(251,'KP24','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(252,'KP12','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(253,'KP25','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(254,'KP14','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(255,'KP19','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(256,'KP20','','',NULL,'2024-08-26 06:31:40','2024-08-26 06:31:40'),(257,'KDD7','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(258,'KDD8','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(259,'KDD9','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(260,'KDD10','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(261,'KDD11','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(262,'KDD12','','',NULL,'2024-08-26 06:40:27','2024-08-26 06:40:27'),(263,'KDD13','','',NULL,'2024-08-26 06:46:31','2024-08-26 06:46:31'),(264,'KDD14','','',NULL,'2024-08-26 06:46:31','2024-08-26 06:46:31'),(265,'ISC','','',NULL,'2024-08-29 12:10:05','2024-08-29 12:10:05');


