/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

USE `aitacade_gcma_db`;

-- IMPORTANT: keep FOREIGN_KEY_CHECKS=0
-- Dump inserts alphabetically; BOM/cost/product tables have parent/child + circular FKs.



REPLACE INTO `bom_consumptions`(`id`,`bom_version_id`,`bom_material_id`,`color_id`,`size_id`,`net_consumption`,`wastage_percent`,`gross_consumption`,`notes`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,1,NULL,NULL,2.000000,10.0000,2.200000,NULL,'2026-07-31 09:34:23','2026-07-31 09:34:23',NULL);



REPLACE INTO `bom_details`(`id`,`bom_version_id`,`parent_detail_id`,`line_type`,`description`,`quantity`,`uom_id`,`wastage_percent`,`unit_cost`,`total_cost`,`remarks`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,NULL,'material','Verification detail',2.000000,NULL,10.0000,5.000000,11.0000,NULL,0,'2026-07-31 09:34:23','2026-07-31 09:34:23',NULL);



REPLACE INTO `bom_headers`(`id`,`company_id`,`bom_number`,`title`,`style_id`,`product_id`,`buyer_id`,`base_quantity`,`uom_id`,`current_version_number`,`status`,`notes`,`created_by`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,'BOM-260731-193423-269','Verification BOM',NULL,NULL,NULL,1.0000,NULL,1,'draft',NULL,1,'2026-07-31 09:34:23','2026-07-31 09:34:23','2026-07-31 09:34:23');



REPLACE INTO `bom_materials`(`id`,`bom_version_id`,`bom_detail_id`,`supplier_id`,`material_code`,`material_name`,`material_type`,`uom_id`,`consumption`,`wastage_percent`,`unit_price`,`total_cost`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,NULL,NULL,'T-MAT','Verification material',NULL,NULL,2.000000,10.0000,5.000000,11.0000,0,'2026-07-31 09:34:23','2026-07-31 09:34:23',NULL);



REPLACE INTO `bom_operations`(`id`,`bom_version_id`,`bom_detail_id`,`operation_id`,`sequence_number`,`description`,`smv`,`rate_per_minute`,`total_cost`,`machine_type_id`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,NULL,NULL,1,'Verification operation',3.0000,2.000000,6.0000,NULL,0,'2026-07-31 09:34:23','2026-07-31 09:34:23',NULL);





REPLACE INTO `bom_versions`(`id`,`bom_header_id`,`version_number`,`effective_date`,`change_reason`,`status`,`created_by`,`approved_by`,`approved_at`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,1,'2026-07-31','Initial version','draft',1,NULL,NULL,'2026-07-31 09:34:23','2026-07-31 09:34:23',NULL);



REPLACE INTO `brands`(`id`,`buyer_id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,NULL,'B001','Arong','active',1,'2026-07-31 15:20:14','2026-07-31 15:20:14',NULL);





REPLACE INTO `buyer_categories`(`id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'BR001','Brand','active',1,'2026-07-31 14:52:33','2026-07-31 14:52:33',NULL),
(2,'IM002','Importer','active',2,'2026-07-31 14:52:57','2026-07-31 14:52:57',NULL),
(3,'RT003','Retailer','active',3,'2026-07-31 14:53:23','2026-07-31 14:53:23',NULL),
(4,'TC004','Trading Company','active',4,'2026-07-31 14:53:59','2026-07-31 14:53:59',NULL),
(5,'BH005','Buying House','active',5,'2026-07-31 14:54:28','2026-07-31 14:54:28',NULL),
(6,'BUYER','Buyer','active',1,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(7,'IMPORTER','Importer','active',2,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(8,'TRADER','Trader','active',3,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL);

















REPLACE INTO `colors`(`id`,`code`,`name`,`tcx_code`,`tpx_code`,`hex_code`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'0000','Black Color',NULL,NULL,'#000000','active',1,'2026-07-31 08:48:06','2026-08-03 00:12:33',NULL),
(2,'0001','Aqua',NULL,NULL,'#00FFFF','active',1,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(3,'0002','Aqua Blue',NULL,NULL,'#7FDBFF','active',2,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(4,'0003','Ash',NULL,NULL,'#B2BEB5','active',3,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(5,'0004','Beige',NULL,NULL,'#F5F5DC','active',4,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(6,'0005','Black',NULL,NULL,'#000000','active',5,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(7,'0006','Blue',NULL,NULL,'#0000FF','active',6,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(8,'0007','Bottle Green',NULL,NULL,'#006A4E','active',7,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(9,'0008','Brown',NULL,NULL,'#8B4513','active',8,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(10,'0009','Burgundy',NULL,NULL,'#800020','active',9,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(11,'0010','Camel',NULL,NULL,'#C19A6B','active',10,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(12,'0011','Charcoal',NULL,NULL,'#36454F','active',11,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(13,'0012','Chocolate',NULL,NULL,'#7B3F00','active',12,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(14,'0013','Cobalt Blue',NULL,NULL,'#0047AB','active',13,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(15,'0014','Coffee',NULL,NULL,'#6F4E37','active',14,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(16,'0015','Copper',NULL,NULL,'#B87333','active',15,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(17,'0016','Coral',NULL,NULL,'#FF7F50','active',16,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(18,'0017','Cream',NULL,NULL,'#FFFDD0','active',17,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(19,'0018','Cyan',NULL,NULL,'#00FFFF','active',18,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(20,'0019','Dark Indigo',NULL,NULL,'#1A237E','active',19,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(21,'0020','Dusty Pink',NULL,NULL,'#D8A7B1','active',20,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(22,'0021','Ecru',NULL,NULL,'#C2B280','active',21,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(23,'0022','Emerald',NULL,NULL,'#50C878','active',22,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(24,'0023','Forest Green',NULL,NULL,'#228B22','active',23,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(25,'0024','Gold',NULL,NULL,'#FFD700','active',24,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(26,'0025','Green',NULL,NULL,'#008000','active',25,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(27,'0026','Grey',NULL,NULL,'#808080','active',26,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(28,'0027','Ice Blue',NULL,NULL,'#D6EAF8','active',27,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(29,'0028','Indigo',NULL,NULL,'#4B0082','active',28,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(30,'0029','Ivory',NULL,NULL,'#FFFFF0','active',29,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(31,'0030','Khaki',NULL,NULL,'#C3B091','active',30,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(32,'0031','Lavender',NULL,NULL,'#E6E6FA','active',31,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(33,'0032','Light Blue',NULL,NULL,'#ADD8E6','active',32,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(34,'0033','Light Indigo',NULL,NULL,'#7986CB','active',33,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(35,'0034','Lilac',NULL,NULL,'#C8A2C8','active',34,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(36,'0035','Lime',NULL,NULL,'#32CD32','active',35,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(37,'0036','Maroon',NULL,NULL,'#800000','active',36,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(38,'0037','Mauve',NULL,NULL,'#E0B0FF','active',37,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(39,'0038','Mid Indigo',NULL,NULL,'#3F51B5','active',38,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(40,'0039','Mint',NULL,NULL,'#98FF98','active',39,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(41,'0040','Mocha',NULL,NULL,'#967969','active',40,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(42,'0041','Mustard',NULL,NULL,'#FFDB58','active',41,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(43,'0042','Natural',NULL,NULL,'#E8DCC8','active',42,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(44,'0043','Navy',NULL,NULL,'#000080','active',43,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(45,'0044','Ochre',NULL,NULL,'#CC7722','active',44,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(46,'0045','Off White',NULL,NULL,'#FAF9F6','active',45,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(47,'0046','Olive',NULL,NULL,'#808000','active',46,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(48,'0047','Orange',NULL,NULL,'#FFA500','active',47,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(49,'0048','Peach',NULL,NULL,'#FFE5B4','active',48,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(50,'0049','Petrol Blue',NULL,NULL,'#005F6B','active',49,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(51,'0050','Pink',NULL,NULL,'#FFC0CB','active',50,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(52,'0051','Purple',NULL,NULL,'#800080','active',51,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(53,'0052','Red',NULL,NULL,'#FF0000','active',52,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(54,'0053','Rose',NULL,NULL,'#FF007F','active',53,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(55,'0054','Royal Blue',NULL,NULL,'#4169E1','active',54,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(56,'0055','Rust',NULL,NULL,'#B7410E','active',55,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(57,'0056','Sage',NULL,NULL,'#BCB88A','active',56,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(58,'0057','Sand',NULL,NULL,'#C2B280','active',57,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(59,'0058','Silver',NULL,NULL,'#C0C0C0','active',58,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(60,'0059','Sky Blue',NULL,NULL,'#87CEEB','active',59,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(61,'0060','Stone',NULL,NULL,'#928E85','active',60,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(62,'0061','Tan',NULL,NULL,'#D2B48C','active',61,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(63,'0062','Taupe',NULL,NULL,'#483C32','active',62,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(64,'0063','Teal',NULL,NULL,'#008080','active',63,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(65,'0064','Terracotta',NULL,NULL,'#E2725B','active',64,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(66,'0065','Turquoise',NULL,NULL,'#40E0D0','active',65,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(67,'0066','White',NULL,NULL,'#FFFFFF','active',66,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(68,'0067','Wine',NULL,NULL,'#722F37','active',67,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(69,'0068','Yellow',NULL,NULL,'#FFFF00','active',68,'2026-08-03 00:04:51','2026-08-03 00:04:51',NULL),
(70,'0069','Test Auto Color','19-4052',NULL,NULL,'active',0,'2026-08-03 00:24:26','2026-08-03 00:24:26','2026-08-03 00:24:26');







REPLACE INTO `companies`(`id`,`code`,`name`,`legal_name`,`email`,`phone`,`address`,`tax_number`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'GPCM','GPCM Company','GPCM Company',NULL,NULL,NULL,NULL,'active','2026-07-31 09:03:50','2026-07-31 09:03:50',NULL);







REPLACE INTO `converter_unit_names`(`id`,`code`,`name`,`category`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'PC','Pc','quantity','active',1,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(2,'DOZ','Doz','quantity','active',2,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(3,'HUNDRED','100 Pcs','quantity','active',3,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(4,'GRS','Grs','quantity','active',4,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(5,'K','K','quantity','active',5,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(6,'GG','GG','quantity','active',6,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(7,'MTR','Mtr','length','active',7,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(8,'YDS','Yds','length','active',8,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(9,'FEET','Feet','length','active',9,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(10,'INCH','Inch','length','active',10,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(11,'KG','Kg','weight','active',11,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(12,'LBS','Lbs','weight','active',12,'2026-08-05 01:09:45','2026-08-05 01:09:45',NULL);





REPLACE INTO `cost_components`(`id`,`company_id`,`code`,`name`,`component_type`,`calculation_method`,`default_rate`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,'MAT','Material Cost','material','quantity_rate',0.000000,'active',10,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL),
(2,1,'LAB','Labor Cost','labor','quantity_rate',0.000000,'active',20,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL),
(3,1,'MAC','Machine Cost','machine','quantity_rate',0.000000,'active',30,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL),
(4,1,'UTL','Utility Cost','utility','quantity_rate',0.000000,'active',40,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL),
(5,1,'OVH','Overhead Cost','overhead','percentage',0.000000,'active',50,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL),
(6,1,'COM','Commercial Cost','commercial','percentage',0.000000,'active',60,'2026-07-31 09:18:58','2026-07-31 09:18:58',NULL);



REPLACE INTO `cost_details`(`id`,`cost_header_id`,`cost_component_id`,`description`,`quantity`,`consumption`,`uom_id`,`unit_rate`,`wastage_percent`,`amount`,`remarks`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,1,'Verification Material',1.000000,2.000000,NULL,5.000000,10.0000,11.0000,NULL,0,'2026-07-31 09:19:24','2026-07-31 09:19:24','2026-07-31 09:19:24');



REPLACE INTO `cost_headers`(`id`,`company_id`,`cost_number`,`title`,`style_id`,`product_id`,`buyer_id`,`currency_id`,`order_quantity`,`exchange_rate`,`revision_number`,`effective_date`,`status`,`material_total`,`conversion_total`,`commercial_total`,`overhead_total`,`total_cost`,`cost_per_unit`,`target_price`,`notes`,`created_by`,`approved_by`,`approved_at`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,'CO-260731-191924-976','Verification Cost Sheet',NULL,NULL,NULL,1,100.0000,1.000000,1,'2026-07-31','draft',0.0000,0.0000,0.0000,0.0000,0.0000,0.000000,2.0000,NULL,1,NULL,NULL,'2026-07-31 09:19:24','2026-07-31 09:19:24','2026-07-31 09:19:24');















REPLACE INTO `countries`(`id`,`code`,`alpha_3`,`numeric_code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'BD','BGD','050','Bangladesh','active',19,'2026-07-31 08:33:24','2026-08-02 23:09:38',NULL),
(3,'US002',NULL,NULL,'USA','inactive',2,'2026-07-31 14:58:41','2026-08-02 23:12:49','2026-08-02 23:12:49'),
(4,'AF','AFG','004','Afghanistan','active',1,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(5,'AX','ALA','248','Åland Islands','active',2,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(6,'AL','ALB','008','Albania','active',3,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(7,'DZ','DZA','012','Algeria','active',4,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(8,'AS','ASM','016','American Samoa','active',5,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(9,'AD','AND','020','Andorra','active',6,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(10,'AO','AGO','024','Angola','active',7,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(11,'AI','AIA','660','Anguilla','active',8,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(12,'AQ','ATA','010','Antarctica','active',9,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(13,'AG','ATG','028','Antigua and Barbuda','active',10,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(14,'AR','ARG','032','Argentina','active',11,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(15,'AM','ARM','051','Armenia','active',12,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(16,'AW','ABW','533','Aruba','active',13,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(17,'AU','AUS','036','Australia','active',14,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(18,'AT','AUT','040','Austria','active',15,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(19,'AZ','AZE','031','Azerbaijan','active',16,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(20,'BS','BHS','044','Bahamas','active',17,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(21,'BH','BHR','048','Bahrain','active',18,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(23,'BB','BRB','052','Barbados','active',20,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(24,'BY','BLR','112','Belarus','active',21,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(25,'BE','BEL','056','Belgium','active',22,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(26,'BZ','BLZ','084','Belize','active',23,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(27,'BJ','BEN','204','Benin','active',24,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(28,'BM','BMU','060','Bermuda','active',25,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(29,'BT','BTN','064','Bhutan','active',26,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(30,'BO','BOL','068','Bolivia, Plurinational State of','active',27,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(31,'BQ','BES','535','Bonaire, Sint Eustatius and Saba','active',28,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(32,'BA','BIH','070','Bosnia and Herzegovina','active',29,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(33,'BW','BWA','072','Botswana','active',30,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(34,'BV','BVT','074','Bouvet Island','active',31,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(35,'BR','BRA','076','Brazil','active',32,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(36,'IO','IOT','086','British Indian Ocean Territory','active',33,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(37,'BN','BRN','096','Brunei Darussalam','active',34,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(38,'BG','BGR','100','Bulgaria','active',35,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(39,'BF','BFA','854','Burkina Faso','active',36,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(40,'BI','BDI','108','Burundi','active',37,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(41,'CV','CPV','132','Cabo Verde','active',38,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(42,'KH','KHM','116','Cambodia','active',39,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(43,'CM','CMR','120','Cameroon','active',40,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(44,'CA','CAN','124','Canada','active',41,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(45,'KY','CYM','136','Cayman Islands','active',42,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(46,'CF','CAF','140','Central African Republic','active',43,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(47,'TD','TCD','148','Chad','active',44,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(48,'CL','CHL','152','Chile','active',45,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(49,'CN','CHN','156','China','active',46,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(50,'CX','CXR','162','Christmas Island','active',47,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(51,'CC','CCK','166','Cocos (Keeling) Islands','active',48,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(52,'CO','COL','170','Colombia','active',49,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(53,'KM','COM','174','Comoros','active',50,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(54,'CG','COG','178','Congo','active',51,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(55,'CD','COD','180','Congo, Democratic Republic of the','active',52,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(56,'CK','COK','184','Cook Islands','active',53,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(57,'CR','CRI','188','Costa Rica','active',54,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(58,'CI','CIV','384','Côte d\'Ivoire','active',55,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(59,'HR','HRV','191','Croatia','active',56,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(60,'CU','CUB','192','Cuba','active',57,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(61,'CW','CUW','531','Curaçao','active',58,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(62,'CY','CYP','196','Cyprus','active',59,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(63,'CZ','CZE','203','Czechia','active',60,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(64,'DK','DNK','208','Denmark','active',61,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(65,'DJ','DJI','262','Djibouti','active',62,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(66,'DM','DMA','212','Dominica','active',63,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(67,'DO','DOM','214','Dominican Republic','active',64,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(68,'EC','ECU','218','Ecuador','active',65,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(69,'EG','EGY','818','Egypt','active',66,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(70,'SV','SLV','222','El Salvador','active',67,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(71,'GQ','GNQ','226','Equatorial Guinea','active',68,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(72,'ER','ERI','232','Eritrea','active',69,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(73,'EE','EST','233','Estonia','active',70,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(74,'SZ','SWZ','748','Eswatini','active',71,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(75,'ET','ETH','231','Ethiopia','active',72,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(76,'FK','FLK','238','Falkland Islands (Malvinas)','active',73,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(77,'FO','FRO','234','Faroe Islands','active',74,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(78,'FJ','FJI','242','Fiji','active',75,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(79,'FI','FIN','246','Finland','active',76,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(80,'FR','FRA','250','France','active',77,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(81,'GF','GUF','254','French Guiana','active',78,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(82,'PF','PYF','258','French Polynesia','active',79,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(83,'TF','ATF','260','French Southern Territories','active',80,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(84,'GA','GAB','266','Gabon','active',81,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(85,'GM','GMB','270','Gambia','active',82,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(86,'GE','GEO','268','Georgia','active',83,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(87,'DE','DEU','276','Germany','active',84,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(88,'GH','GHA','288','Ghana','active',85,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(89,'GI','GIB','292','Gibraltar','active',86,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(90,'GR','GRC','300','Greece','active',87,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(91,'GL','GRL','304','Greenland','active',88,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(92,'GD','GRD','308','Grenada','active',89,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(93,'GP','GLP','312','Guadeloupe','active',90,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(94,'GU','GUM','316','Guam','active',91,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(95,'GT','GTM','320','Guatemala','active',92,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(96,'GG','GGY','831','Guernsey','active',93,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(97,'GN','GIN','324','Guinea','active',94,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(98,'GW','GNB','624','Guinea-Bissau','active',95,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(99,'GY','GUY','328','Guyana','active',96,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(100,'HT','HTI','332','Haiti','active',97,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(101,'HM','HMD','334','Heard Island and McDonald Islands','active',98,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(102,'VA','VAT','336','Holy See','active',99,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(103,'HN','HND','340','Honduras','active',100,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(104,'HK','HKG','344','Hong Kong','active',101,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(105,'HU','HUN','348','Hungary','active',102,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(106,'IS','ISL','352','Iceland','active',103,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(107,'IN','IND','356','India','active',104,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(108,'ID','IDN','360','Indonesia','active',105,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(109,'IR','IRN','364','Iran, Islamic Republic of','active',106,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(110,'IQ','IRQ','368','Iraq','active',107,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(111,'IE','IRL','372','Ireland','active',108,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(112,'IM','IMN','833','Isle of Man','active',109,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(113,'IL','ISR','376','Israel','active',110,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(114,'IT','ITA','380','Italy','active',111,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(115,'JM','JAM','388','Jamaica','active',112,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(116,'JP','JPN','392','Japan','active',113,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(117,'JE','JEY','832','Jersey','active',114,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(118,'JO','JOR','400','Jordan','active',115,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(119,'KZ','KAZ','398','Kazakhstan','active',116,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(120,'KE','KEN','404','Kenya','active',117,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(121,'KI','KIR','296','Kiribati','active',118,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(122,'KP','PRK','408','Korea, Democratic People\'s Republic of','active',119,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(123,'KR','KOR','410','Korea, Republic of','active',120,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(124,'KW','KWT','414','Kuwait','active',121,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(125,'KG','KGZ','417','Kyrgyzstan','active',122,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(126,'LA','LAO','418','Lao People\'s Democratic Republic','active',123,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(127,'LV','LVA','428','Latvia','active',124,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(128,'LB','LBN','422','Lebanon','active',125,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(129,'LS','LSO','426','Lesotho','active',126,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(130,'LR','LBR','430','Liberia','active',127,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(131,'LY','LBY','434','Libya','active',128,'2026-08-02 23:09:38','2026-08-02 23:09:38',NULL),
(132,'LI','LIE','438','Liechtenstein','active',129,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(133,'LT','LTU','440','Lithuania','active',130,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(134,'LU','LUX','442','Luxembourg','active',131,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(135,'MO','MAC','446','Macao','active',132,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(136,'MG','MDG','450','Madagascar','active',133,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(137,'MW','MWI','454','Malawi','active',134,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(138,'MY','MYS','458','Malaysia','active',135,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(139,'MV','MDV','462','Maldives','active',136,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(140,'ML','MLI','466','Mali','active',137,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(141,'MT','MLT','470','Malta','active',138,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(142,'MH','MHL','584','Marshall Islands','active',139,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(143,'MQ','MTQ','474','Martinique','active',140,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(144,'MR','MRT','478','Mauritania','active',141,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(145,'MU','MUS','480','Mauritius','active',142,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(146,'YT','MYT','175','Mayotte','active',143,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(147,'MX','MEX','484','Mexico','active',144,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(148,'FM','FSM','583','Micronesia, Federated States of','active',145,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(149,'MD','MDA','498','Moldova, Republic of','active',146,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(150,'MC','MCO','492','Monaco','active',147,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(151,'MN','MNG','496','Mongolia','active',148,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(152,'ME','MNE','499','Montenegro','active',149,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(153,'MS','MSR','500','Montserrat','active',150,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(154,'MA','MAR','504','Morocco','active',151,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(155,'MZ','MOZ','508','Mozambique','active',152,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(156,'MM','MMR','104','Myanmar','active',153,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(157,'NA','NAM','516','Namibia','active',154,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(158,'NR','NRU','520','Nauru','active',155,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(159,'NP','NPL','524','Nepal','active',156,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(160,'NL','NLD','528','Netherlands, Kingdom of the','active',157,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(161,'NC','NCL','540','New Caledonia','active',158,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(162,'NZ','NZL','554','New Zealand','active',159,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(163,'NI','NIC','558','Nicaragua','active',160,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(164,'NE','NER','562','Niger','active',161,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(165,'NG','NGA','566','Nigeria','active',162,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(166,'NU','NIU','570','Niue','active',163,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(167,'NF','NFK','574','Norfolk Island','active',164,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(168,'MK','MKD','807','North Macedonia','active',165,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(169,'MP','MNP','580','Northern Mariana Islands','active',166,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(170,'NO','NOR','578','Norway','active',167,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(171,'OM','OMN','512','Oman','active',168,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(172,'PK','PAK','586','Pakistan','active',169,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(173,'PW','PLW','585','Palau','active',170,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(174,'PS','PSE','275','Palestine, State of','active',171,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(175,'PA','PAN','591','Panama','active',172,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(176,'PG','PNG','598','Papua New Guinea','active',173,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(177,'PY','PRY','600','Paraguay','active',174,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(178,'PE','PER','604','Peru','active',175,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(179,'PH','PHL','608','Philippines','active',176,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(180,'PN','PCN','612','Pitcairn','active',177,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(181,'PL','POL','616','Poland','active',178,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(182,'PT','PRT','620','Portugal','active',179,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(183,'PR','PRI','630','Puerto Rico','active',180,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(184,'QA','QAT','634','Qatar','active',181,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(185,'RE','REU','638','Réunion','active',182,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(186,'RO','ROU','642','Romania','active',183,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(187,'RU','RUS','643','Russian Federation','active',184,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(188,'RW','RWA','646','Rwanda','active',185,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(189,'BL','BLM','652','Saint Barthélemy','active',186,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(190,'SH','SHN','654','Saint Helena, Ascension and Tristan da Cunha','active',187,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(191,'KN','KNA','659','Saint Kitts and Nevis','active',188,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(192,'LC','LCA','662','Saint Lucia','active',189,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(193,'MF','MAF','663','Saint Martin (French part)','active',190,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(194,'PM','SPM','666','Saint Pierre and Miquelon','active',191,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(195,'VC','VCT','670','Saint Vincent and the Grenadines','active',192,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(196,'WS','WSM','882','Samoa','active',193,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(197,'SM','SMR','674','San Marino','active',194,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(198,'ST','STP','678','Sao Tome and Principe','active',195,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(199,'SA','SAU','682','Saudi Arabia','active',196,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(200,'SN','SEN','686','Senegal','active',197,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(201,'RS','SRB','688','Serbia','active',198,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(202,'SC','SYC','690','Seychelles','active',199,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(203,'SL','SLE','694','Sierra Leone','active',200,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(204,'SG','SGP','702','Singapore','active',201,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(205,'SX','SXM','534','Sint Maarten (Dutch part)','active',202,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(206,'SK','SVK','703','Slovakia','active',203,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(207,'SI','SVN','705','Slovenia','active',204,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(208,'SB','SLB','090','Solomon Islands','active',205,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(209,'SO','SOM','706','Somalia','active',206,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(210,'ZA','ZAF','710','South Africa','active',207,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(211,'GS','SGS','239','South Georgia and the South Sandwich Islands','active',208,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(212,'SS','SSD','728','South Sudan','active',209,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(213,'ES','ESP','724','Spain','active',210,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(214,'LK','LKA','144','Sri Lanka','active',211,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(215,'SD','SDN','729','Sudan','active',212,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(216,'SR','SUR','740','Suriname','active',213,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(217,'SJ','SJM','744','Svalbard and Jan Mayen','active',214,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(218,'SE','SWE','752','Sweden','active',215,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(219,'CH','CHE','756','Switzerland','active',216,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(220,'SY','SYR','760','Syrian Arab Republic','active',217,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(221,'TW','TWN','158','Taiwan, Province of China','active',218,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(222,'TJ','TJK','762','Tajikistan','active',219,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(223,'TZ','TZA','834','Tanzania, United Republic of','active',220,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(224,'TH','THA','764','Thailand','active',221,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(225,'TL','TLS','626','Timor-Leste','active',222,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(226,'TG','TGO','768','Togo','active',223,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(227,'TK','TKL','772','Tokelau','active',224,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(228,'TO','TON','776','Tonga','active',225,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(229,'TT','TTO','780','Trinidad and Tobago','active',226,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(230,'TN','TUN','788','Tunisia','active',227,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(231,'TR','TUR','792','Türkiye','active',228,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(232,'TM','TKM','795','Turkmenistan','active',229,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(233,'TC','TCA','796','Turks and Caicos Islands','active',230,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(234,'TV','TUV','798','Tuvalu','active',231,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(235,'UG','UGA','800','Uganda','active',232,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(236,'UA','UKR','804','Ukraine','active',233,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(237,'AE','ARE','784','United Arab Emirates','active',234,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(238,'GB','GBR','826','United Kingdom of Great Britain and Northern Ireland','active',235,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(239,'US','USA','840','United States of America','active',236,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(240,'UM','UMI','581','United States Minor Outlying Islands','active',237,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(241,'UY','URY','858','Uruguay','active',238,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(242,'UZ','UZB','860','Uzbekistan','active',239,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(243,'VU','VUT','548','Vanuatu','active',240,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(244,'VE','VEN','862','Venezuela, Bolivarian Republic of','active',241,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(245,'VN','VNM','704','Viet Nam','active',242,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(246,'VG','VGB','092','Virgin Islands (British)','active',243,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(247,'VI','VIR','850','Virgin Islands (U.S.)','active',244,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(248,'WF','WLF','876','Wallis and Futuna','active',245,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(249,'EH','ESH','732','Western Sahara','active',246,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(250,'YE','YEM','887','Yemen','active',247,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(251,'ZM','ZMB','894','Zambia','active',248,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL),
(252,'ZW','ZWE','716','Zimbabwe','active',249,'2026-08-02 23:09:39','2026-08-02 23:09:39',NULL);



REPLACE INTO `currencies`(`id`,`code`,`name`,`country_id`,`country_region`,`symbol`,`decimal_places`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'BDT','Bangladeshi Taka',1,'Bangladesh','৳',2,'active',16,'2026-07-31 08:33:24','2026-08-02 23:21:46',NULL),
(2,'USD','US Dollar',239,'United States','$',2,'active',1,'2026-07-31 08:33:24','2026-08-02 23:21:46',NULL),
(4,'EUR','Euro',NULL,'Eurozone','€',2,'active',2,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(5,'GBP','Pound Sterling',238,'United Kingdom','£',2,'active',3,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(6,'JPY','Japanese Yen',116,'Japan','¥',0,'active',4,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(7,'CNY','Chinese Yuan Renminbi',49,'China','¥',2,'active',5,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(8,'HKD','Hong Kong Dollar',104,'Hong Kong','HK$',2,'active',6,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(9,'SGD','Singapore Dollar',204,'Singapore','S$',2,'active',7,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(10,'AUD','Australian Dollar',17,'Australia','A$',2,'active',8,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(11,'NZD','New Zealand Dollar',162,'New Zealand','NZ$',2,'active',9,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(12,'CAD','Canadian Dollar',44,'Canada','C$',2,'active',10,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(13,'CHF','Swiss Franc',219,'Switzerland','CHF',2,'active',11,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(14,'SEK','Swedish Krona',218,'Sweden','kr',2,'active',12,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(15,'NOK','Norwegian Krone',170,'Norway','kr',2,'active',13,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(16,'DKK','Danish Krone',64,'Denmark','kr',2,'active',14,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(17,'INR','Indian Rupee',107,'India','₹',2,'active',15,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(19,'PKR','Pakistani Rupee',172,'Pakistan','₨',2,'active',17,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(20,'AED','UAE Dirham',237,'United Arab Emirates','د.إ',2,'active',18,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(21,'SAR','Saudi Riyal',199,'Saudi Arabia','﷼',2,'active',19,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(22,'KRW','South Korean Won',123,'South Korea','₩',0,'active',20,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(23,'THB','Thai Baht',224,'Thailand','฿',2,'active',21,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(24,'MYR','Malaysian Ringgit',138,'Malaysia','RM',2,'active',22,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(25,'IDR','Indonesian Rupiah',108,'Indonesia','Rp',0,'active',23,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(26,'VND','Vietnamese Dong',245,'Vietnam','₫',0,'active',24,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(27,'TWD','New Taiwan Dollar',221,'Taiwan','NT$',2,'active',25,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(28,'ZAR','South African Rand',210,'South Africa','R',2,'active',26,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(29,'BRL','Brazilian Real',35,'Brazil','R$',2,'active',27,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(30,'MXN','Mexican Peso',147,'Mexico','$',2,'active',28,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(31,'TRY','Turkish Lira',231,'Türkiye','₺',2,'active',29,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL),
(32,'PLN','Polish Złoty',181,'Poland','zł',2,'active',30,'2026-08-02 23:21:46','2026-08-02 23:21:46',NULL);



















REPLACE INTO `end_users`(`id`,`code`,`name`,`narration`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'MEN','Men','Adult males','active',1,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(2,'WOMEN','Women','Adult females','active',2,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(3,'UNISEX','Unisex','Suitable for both men and women','active',3,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(4,'BOYS','Boys','Children (typically 4–14 years)','active',4,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(5,'GIRLS','Girls','Children (typically 4–14 years)','active',5,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(6,'BABY_BOYS','Baby Boys','Infant/toddler boys (0–24 months)','active',6,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(7,'BABY_GIRLS','Baby Girls','Infant/toddler girls (0–24 months)','active',7,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(8,'INFANT','Infant','Newborn to 12 months','active',8,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(9,'NEWBORN','Newborn','0–3 months','active',9,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(10,'TODDLER','Toddler','1–3 years','active',10,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(11,'KIDS','Kids','General children\'s category','active',11,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(12,'YOUTH','Youth','Teenagers','active',12,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(13,'JUNIOR','Junior','Teen fashion (mostly girls)','active',13,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(14,'MATERNITY','Maternity','Pregnant women','active',14,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(15,'PLUS_SIZE','Plus Size','Extended-size adults','active',15,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(16,'PET','Pet','Pet apparel','active',16,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(17,'ADULT','Adult','Gender-neutral adult category','active',17,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL);



REPLACE INTO `fabric_contents`(`id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'ACRYLIC','Acrylic','active',1,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(2,'ALPACA','Alpaca','active',2,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(3,'ANGORA','Angora','active',3,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(4,'BAMBOO','Bamboo','active',4,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(5,'BANANA_FIBER','Banana Fiber','active',5,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(6,'BETTER_COTTON_BCI','Better Cotton (BCI)','active',6,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(7,'CAMEL_HAIR','Camel Hair','active',7,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(8,'CARBON_FIBER','Carbon Fiber','active',8,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(9,'CASHMERE','Cashmere','active',9,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(10,'CHLOROFIBER','Chlorofiber','active',10,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(11,'COTTON','Cotton','active',11,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(12,'CUPRO','Cupro','active',12,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(13,'ELASTANE','Elastane','active',13,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(14,'ELASTOMULTIESTER','Elastomultiester','active',14,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(15,'GLASS_FIBER','Glass Fiber','active',15,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(16,'HEMP','Hemp','active',16,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(17,'JUTE','Jute','active',17,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(18,'KAPOK','Kapok','active',18,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(19,'LINEN','Linen','active',19,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(20,'LYCRA','LYCRA','active',20,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(21,'LYOCELL','Lyocell','active',21,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(22,'METALLIC_FIBER','Metallic Fiber','active',22,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(23,'MODAL','Modal','active',23,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(24,'MOHAIR','Mohair','active',24,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(25,'NYLON','Nylon','active',25,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(26,'ORANGE_FIBER','Orange Fiber','active',26,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(27,'ORGANIC_COTTON','Organic Cotton','active',27,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(28,'PINEAPPLE_FIBER','Pineapple Fiber','active',28,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(29,'POLYAMIDE','Polyamide','active',29,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(30,'POLYESTER','Polyester','active',30,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(31,'POLYETHYLENE','Polyethylene','active',31,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(32,'POLYLACTIC_ACID','Polylactic Acid','active',32,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(33,'POLYPROPYLENE','Polypropylene','active',33,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(34,'POLYVINYL_CHLORIDE','Polyvinyl Chloride','active',34,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(35,'RAMIE','Ramie','active',35,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(36,'RAYON','Rayon','active',36,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(37,'RECYCLED_COTTON','Recycled Cotton','active',37,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(38,'RECYCLED_HEMP','Recycled Hemp','active',38,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(39,'RECYCLED_NYLON','Recycled Nylon','active',39,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(40,'RECYCLED_POLYESTER','Recycled Polyester','active',40,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(41,'RECYCLED_SILK','Recycled Silk','active',41,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(42,'RECYCLED_WOOL','Recycled Wool','active',42,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(43,'SILK','Silk','active',43,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(44,'SPANDEX','Spandex','active',44,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(45,'TENCEL','Tencel','active',45,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(46,'TRIACETATE','Triacetate','active',46,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(47,'WOOL','Wool','active',47,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL);













REPLACE INTO `fit_masters`(`id`,`code`,`name`,`description`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'REGULAR_FIT','Regular Fit','Standard fit','active',1,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(2,'SLIM_FIT','Slim Fit','Slightly fitted','active',2,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(3,'SKINNY_FIT','Skinny Fit','Very close-fitting','active',3,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(4,'SUPER_SKINNY_FIT','Super Skinny Fit','Extra tight fit','active',4,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(5,'STRAIGHT_FIT','Straight Fit','Straight through leg/body','active',5,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(6,'RELAXED_FIT','Relaxed Fit','Looser than regular','active',6,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(7,'LOOSE_FIT','Loose Fit','Loose throughout','active',7,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(8,'OVERSIZED_FIT','Oversized Fit','Fashionably oversized','active',8,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(9,'TAPERED_FIT','Tapered Fit','Narrows toward hem','active',9,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(10,'ATHLETIC_FIT','Athletic Fit','Extra room for muscular build','active',10,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(11,'CLASSIC_FIT','Classic Fit','Traditional fit','active',11,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(12,'MODERN_FIT','Modern Fit','Between regular and slim','active',12,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(13,'COMFORT_FIT','Comfort Fit','Comfortable loose fit','active',13,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(14,'EASY_FIT','Easy Fit','Relaxed everyday fit','active',14,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(15,'BOXY_FIT','Boxy Fit','Square silhouette','active',15,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(16,'REGULAR_STRAIGHT_FIT','Regular Straight Fit','Regular body with straight leg','active',16,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(17,'SLIM_TAPER_FIT','Slim Taper Fit','Slim thigh with tapered leg','active',17,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(18,'CARROT_FIT','Carrot Fit','Wide thigh, narrow ankle','active',18,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(19,'WIDE_FIT','Wide Fit','Extra wide leg/body','active',19,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(20,'BAGGY_FIT','Baggy Fit','Very loose fit','active',20,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(21,'FLARED_FIT','Flared Fit','Widens from knee','active',21,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(22,'BOOTCUT_FIT','Bootcut Fit','Slight flare for boots','active',22,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(23,'BELL_BOTTOM_FIT','Bell Bottom Fit','Large flare','active',23,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(24,'BOYFRIEND_FIT','Boyfriend Fit','Relaxed women\'s fit','active',24,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(25,'MOM_FIT','Mom Fit','High-rise relaxed jeans','active',25,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(26,'GIRLFRIEND_FIT','Girlfriend Fit','Slimmer than boyfriend','active',26,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(27,'JOGGER_FIT','Jogger Fit','Elastic cuff style','active',27,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(28,'CIGARETTE_FIT','Cigarette Fit','Slim straight leg','active',28,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(29,'PEG_FIT','Peg Fit','Full thigh, tapered ankle','active',29,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL),
(30,'BALLOON_FIT','Balloon Fit','Wide hip, tapered hem','active',30,'2026-08-05 01:20:19','2026-08-05 01:20:19',NULL);





































REPLACE INTO `metal_finishes`(`id`,`code`,`name`,`description`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'NICKEL','Nickel','Bright silver finish','active',1,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(2,'MATTE_NICKEL','Matte Nickel','Dull silver finish','active',2,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(3,'ANTIQUE_NICKEL','Antique Nickel','Aged silver appearance','active',3,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(4,'BLACK_NICKEL','Black Nickel','Dark gunmetal finish','active',4,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(5,'MATTE_BLACK_NICKEL','Matte Black Nickel','Dull black nickel','active',5,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(6,'GUN_METAL','Gun Metal','Dark metallic gray','active',6,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(7,'MATTE_GUN_METAL','Matte Gun Metal','Dull gunmetal','active',7,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(8,'SILVER','Silver','Bright silver','active',8,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(9,'MATTE_SILVER','Matte Silver','Satin silver','active',9,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(10,'ANTIQUE_SILVER','Antique Silver','Vintage silver','active',10,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(11,'GOLD','Gold','Bright gold','active',11,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(12,'MATTE_GOLD','Matte Gold','Satin gold','active',12,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(13,'LIGHT_GOLD','Light Gold','Pale gold','active',13,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(14,'ANTIQUE_GOLD','Antique Gold','Vintage gold','active',14,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(15,'ROSE_GOLD','Rose Gold','Pink gold','active',15,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(16,'MATTE_ROSE_GOLD','Matte Rose Gold','Satin rose gold','active',16,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(17,'BRASS','Brass','Yellow brass','active',17,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(18,'MATTE_BRASS','Matte Brass','Satin brass','active',18,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(19,'ANTIQUE_BRASS','Antique Brass','Aged brass','active',19,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(20,'COPPER','Copper','Bright copper','active',20,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(21,'MATTE_COPPER','Matte Copper','Satin copper','active',21,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(22,'ANTIQUE_COPPER','Antique Copper','Aged copper','active',22,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(23,'BRONZE','Bronze','Bronze finish','active',23,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(24,'ANTIQUE_BRONZE','Antique Bronze','Vintage bronze','active',24,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(25,'CHROME','Chrome','Mirror chrome','active',25,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(26,'SATIN_CHROME','Satin Chrome','Brushed chrome','active',26,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(27,'PEWTER','Pewter','Soft gray finish','active',27,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(28,'OXIDIZED_SILVER','Oxidized Silver','Dark oxidized silver','active',28,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(29,'OXIDIZED_BRASS','Oxidized Brass','Dark oxidized brass','active',29,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(30,'BLACK_OXIDE','Black Oxide','Deep black finish','active',30,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(31,'WHITE_PAINTED','White Painted','White coating','active',31,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(32,'BLACK_PAINTED','Black Painted','Black coating','active',32,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(33,'COLOR_PAINTED','Color Painted','Any painted color','active',33,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(34,'RUBBER_COATED','Rubber Coated','Soft-touch coating','active',34,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(35,'PLASTIC_COATED','Plastic Coated','Plastic-coated metal','active',35,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(36,'CLEAR_LACQUER','Clear Lacquer','Transparent protective coating','active',36,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(37,'E_COATING','E-Coating','Electrophoretic coating','active',37,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(38,'POWDER_COATED','Powder Coated','Powder paint finish','active',38,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(39,'SAND_BLASTED','Sand Blasted','Textured matte surface','active',39,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(40,'BRUSHED_FINISH','Brushed Finish','Linear brushed texture','active',40,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(41,'POLISHED','Polished','High-gloss polished','active',41,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(42,'VINTAGE_FINISH','Vintage Finish','Distressed look','active',42,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL);



REPLACE INTO `migrations`(`id`,`migration`,`executed_at`) values 
(1,'001_phase_one_foundation.sql','2026-07-31 08:33:24'),
(2,'002_master_and_product_engine.sql','2026-07-31 09:03:52'),
(3,'003_cost_engine.sql','2026-07-31 09:18:58'),
(4,'004_bom_engine.sql','2026-07-31 09:33:48'),
(5,'005_mrp_engine.sql','2026-07-31 09:59:18'),
(6,'006_purchase_engine.sql','2026-07-31 09:59:19'),
(7,'007_inventory_engine.sql','2026-07-31 10:06:37'),
(8,'008_production_engine.sql','2026-07-31 10:12:51'),
(9,'009_quality_engine.sql','2026-07-31 10:18:45'),
(10,'010_hr_engine.sql','2026-07-31 10:24:42'),
(11,'011_accounting_engine.sql','2026-07-31 10:31:30'),
(12,'012_shipment_reports_engine.sql','2026-07-31 10:36:43'),
(13,'013_costing_op_engine.sql','2026-07-31 15:48:55'),
(14,'014_countries_iso_fields.sql','2026-08-02 23:09:35'),
(15,'015_currencies_country_link.sql','2026-08-02 23:21:42'),
(16,'016_colors_tcx_tpx.sql','2026-08-03 00:24:08'),
(17,'017_zipper_tape_colors.sql','2026-08-04 01:24:29'),
(18,'018_unit_masters.sql','2026-08-04 01:32:25'),
(19,'019_buyer_wise_config.sql','2026-08-04 01:38:16'),
(20,'020_prefix_masters.sql','2026-08-04 02:30:46'),
(21,'021_master_menu_stubs.sql','2026-08-05 00:56:51'),
(22,'022_unit_converter.sql','2026-08-05 01:09:42'),
(23,'023_master_data3_alignment.sql','2026-08-05 01:20:16');





















REPLACE INTO `permissions`(`id`,`code`,`name`,`module`,`created_at`) values 
(1,'master.view','View Master Data','master','2026-07-31 09:19:01'),
(2,'master.manage','Manage Master Data','master','2026-07-31 09:19:01'),
(3,'cost.view','View Cost Engine','cost','2026-07-31 09:19:01'),
(4,'cost.manage','Manage Cost Engine','cost','2026-07-31 09:19:01'),
(5,'cost.approve','Approve Cost Sheets','cost','2026-07-31 09:19:01'),
(11,'bom.view','View BOM Management','bom','2026-07-31 09:33:51'),
(12,'bom.manage','Manage BOM Management','bom','2026-07-31 09:33:51'),
(13,'bom.approve','Approve BOM Versions','bom','2026-07-31 09:33:51'),
(22,'mrp.view','View MRP Management','mrp','2026-07-31 09:59:23'),
(23,'mrp.manage','Manage MRP Management','mrp','2026-07-31 09:59:23'),
(24,'purchase.view','View Purchase Management','purchase','2026-07-31 09:59:23'),
(25,'purchase.manage','Manage Purchase Management','purchase','2026-07-31 09:59:23'),
(26,'purchase.approve','Approve Purchase Documents','purchase','2026-07-31 09:59:23'),
(40,'inventory.view','View Inventory Management','inventory','2026-07-31 10:06:40'),
(41,'inventory.manage','Manage Inventory Management','inventory','2026-07-31 10:06:40'),
(57,'production.view','View Production Management','production','2026-07-31 10:12:55'),
(58,'production.manage','Manage Production Management','production','2026-07-31 10:12:55'),
(76,'quality.view','View Quality Management','quality','2026-07-31 10:18:48'),
(77,'quality.manage','Manage Quality Management','quality','2026-07-31 10:18:48'),
(78,'quality.approve','Approve Quality Inspections','quality','2026-07-31 10:18:48'),
(99,'hr.view','View HR Management','hr','2026-07-31 10:24:45'),
(100,'hr.manage','Manage HR Management','hr','2026-07-31 10:24:45'),
(101,'hr.approve','Approve Leave and Payroll','hr','2026-07-31 10:24:45'),
(125,'accounting.view','View Accounting Management','accounting','2026-07-31 10:31:34'),
(126,'accounting.manage','Manage Accounting Transactions','accounting','2026-07-31 10:31:34'),
(127,'accounting.post','Post Journal Entries','accounting','2026-07-31 10:31:34'),
(154,'shipment.view','View Shipment Management','shipment','2026-07-31 10:36:47'),
(155,'shipment.manage','Manage Shipments','shipment','2026-07-31 10:36:47'),
(156,'reports.view','View Reports Management','reports','2026-07-31 10:36:47'),
(157,'reports.manage','Manage Reports and Filters','reports','2026-07-31 10:36:47'),
(163,'costing_op.view','View Costing OP','costing_op','2026-07-31 15:49:04'),
(164,'costing_op.manage','Manage Costing OP','costing_op','2026-07-31 15:49:04');



REPLACE INTO `prefix_masters`(`id`,`code`,`name`,`examples`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'01','Fabric','Denim, Twill, Poplin','active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(2,'02','Knit Fabric',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(3,'03','Pocketing','Sheeting, TC, Twill, TC Twill, Satin','active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(4,'04','Interlining',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(5,'05','Zipper',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(6,'06','Thread',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(7,'07','Metal Item','Button, Rivet, Buckle, Eyelet','active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(8,'08','Badge/Patch',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(9,'09','Paper Item',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(10,'10','Label',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(11,'11','Finishing Item',NULL,'active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(12,'12','Service','Print, Embroidery, Test, Inspection, Wash','active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL),
(13,'13','Lace, Elastic','Lace, Elastic, Drawstring, Cord','active','2026-08-04 02:30:49','2026-08-04 02:30:49',NULL);





REPLACE INTO `product_categories`(`id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'T-PC','Test Product Category','active',999,'2026-07-31 09:04:45','2026-07-31 09:04:45','2026-07-31 09:04:45'),
(2,'FB001','Fiber','active',1,'2026-07-31 15:24:32','2026-07-31 15:24:32',NULL),
(3,'TOP','Top','active',1,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(4,'BOTTOM','Bottom','active',2,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(5,'ALL_OVER','All Over','active',3,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL);









REPLACE INTO `product_subcategories`(`id`,`product_category_id`,`product_type_id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,1,'T-PS','Test Product Subcategory','active',999,'2026-07-31 09:04:45','2026-07-31 09:04:45','2026-07-31 09:04:45'),
(2,2,2,'DM001','Danim','active',1,'2026-07-31 15:25:49','2026-07-31 15:25:49',NULL),
(3,3,NULL,'T_SHIRTS','T-Shirts','active',1,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(4,3,NULL,'SHIRTS','Shirts','active',2,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(5,3,NULL,'SWEATWEAR','Sweatwear','active',3,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(6,3,NULL,'KNITWEAR','Knitwear','active',4,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(7,3,NULL,'JACKETS','Jackets','active',5,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(8,4,NULL,'TROUSERS','Trousers','active',6,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(9,4,NULL,'JEANS','Jeans','active',7,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(10,4,NULL,'SHORTS','Shorts','active',8,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(11,4,NULL,'LEGGINGS','Leggings','active',9,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(12,4,NULL,'DRESSES','Dresses','active',10,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(13,4,NULL,'SKIRTS','Skirts','active',11,'2026-08-05 01:20:20','2026-08-05 01:20:20',NULL),
(25,3,NULL,'BABY_WEAR','Baby Wear','active',12,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(26,3,NULL,'KIDS_WEAR','Kids Wear','active',13,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(27,3,NULL,'SPORTSWEAR','Sportswear','active',14,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(28,3,NULL,'WORKWEAR','Workwear','active',15,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(29,4,NULL,'SLEEPWEAR','Sleepwear','active',16,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(30,4,NULL,'DENIM_SPECIALTIES','Denim Specialties','active',17,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL);



REPLACE INTO `product_types`(`id`,`product_category_id`,`product_subcategory_id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,NULL,'T-PT','Test Product Type','active',999,'2026-07-31 09:04:45','2026-07-31 09:04:45','2026-07-31 09:04:45'),
(2,2,NULL,'FC001','Fabric','active',1,'2026-07-31 15:25:21','2026-07-31 15:25:21',NULL),
(3,3,3,'CREW_NECK_T_SHIRT','Crew Neck T-Shirt','active',1,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(4,3,3,'V_NECK_T_SHIRT','V-Neck T-Shirt','active',2,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(5,3,3,'HENLEY_T_SHIRT','Henley T-Shirt','active',3,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(6,3,3,'POLO_SHIRT','Polo Shirt','active',4,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(7,3,3,'RAGLAN_T_SHIRT','Raglan T-Shirt','active',5,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(8,3,3,'POCKET_T_SHIRT','Pocket T-Shirt','active',6,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(9,3,3,'GRAPHIC_T_SHIRT','Graphic T-Shirt','active',7,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(10,3,3,'LONG_SLEEVE_T_SHIRT','Long Sleeve T-Shirt','active',8,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(11,3,3,'MUSCLE_T_SHIRT','Muscle T-Shirt','active',9,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(12,3,3,'OVERSIZED_T_SHIRT','Oversized T-Shirt','active',10,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(13,3,3,'CROP_T_SHIRT','Crop T-Shirt','active',11,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(14,3,3,'TANK_TOP','Tank Top','active',12,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(15,3,3,'SLEEVELESS_T_SHIRT','Sleeveless T-Shirt','active',13,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(16,3,4,'CASUAL_SHIRT','Casual Shirt','active',14,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(17,3,4,'DRESS_SHIRT','Dress Shirt','active',15,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(18,3,4,'OXFORD_SHIRT','Oxford Shirt','active',16,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(19,3,30,'DENIM_SHIRT','Denim Shirt','active',17,'2026-08-05 01:21:00','2026-08-05 01:21:01',NULL),
(20,3,4,'CHAMBRAY_SHIRT','Chambray Shirt','active',18,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(21,3,4,'FLANNEL_SHIRT','Flannel Shirt','active',19,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(22,3,4,'LINEN_SHIRT','Linen Shirt','active',20,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(23,3,4,'CUBAN_COLLAR_SHIRT','Cuban Collar Shirt','active',21,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(24,3,4,'HAWAIIAN_SHIRT','Hawaiian Shirt','active',22,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(25,3,4,'UTILITY_SHIRT','Utility Shirt','active',23,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(26,3,4,'OVERSHIRT','Overshirt','active',24,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(27,3,5,'SWEATSHIRT','Sweatshirt','active',25,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(28,3,5,'HOODIE','Hoodie','active',26,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(29,3,5,'ZIP_HOODIE','Zip Hoodie','active',27,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(30,3,5,'QUARTER_ZIP_SWEATSHIRT','Quarter Zip Sweatshirt','active',28,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(31,3,5,'PULLOVER_HOODIE','Pullover Hoodie','active',29,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(32,3,6,'SWEATER','Sweater','active',30,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(33,3,6,'CARDIGAN','Cardigan','active',31,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(34,3,6,'PULLOVER','Pullover','active',32,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(35,3,6,'VEST','Vest','active',33,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(36,3,6,'TURTLENECK_SWEATER','Turtleneck Sweater','active',34,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(37,3,30,'DENIM_JACKET','Denim Jacket','active',35,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(38,3,7,'BOMBER_JACKET','Bomber Jacket','active',36,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(39,3,7,'VARSITY_JACKET','Varsity Jacket','active',37,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(40,3,7,'WINDBREAKER','Windbreaker','active',38,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(41,3,7,'PARKA','Parka','active',39,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(42,3,7,'PUFFER_JACKET','Puffer Jacket','active',40,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(43,3,7,'QUILTED_JACKET','Quilted Jacket','active',41,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(44,3,7,'RAIN_JACKET','Rain Jacket','active',42,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(45,3,7,'SOFT_SHELL_JACKET','Soft Shell Jacket','active',43,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(46,3,7,'FLEECE_JACKET','Fleece Jacket','active',44,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(47,3,7,'BLAZER','Blazer','active',45,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(48,4,8,'5_POCKET_LONG_TROUSER','5 Pocket Long Trouser','active',46,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(49,4,8,'5_POCKET_SHORTS','5 Pocket Shorts','active',47,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(50,4,8,'CHINO_TROUSER','Chino Trouser','active',48,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(51,4,8,'FORMAL_TROUSER','Formal Trouser','active',49,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(52,4,8,'CARGO_TROUSER','Cargo Trouser','active',50,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(53,4,8,'JOGGER_PANT','Jogger Pant','active',51,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(54,4,8,'TRACK_PANT','Track Pant','active',52,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(55,4,8,'SLIM_FIT_TROUSER','Slim Fit Trouser','active',53,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(56,4,8,'RELAXED_FIT_TROUSER','Relaxed Fit Trouser','active',54,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(57,4,8,'CARPENTER_PANT','Carpenter Pant','active',55,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(58,4,8,'UTILITY_PANT','Utility Pant','active',56,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(59,4,9,'SKINNY_JEANS','Skinny Jeans','active',57,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(60,4,9,'SLIM_JEANS','Slim Jeans','active',58,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(61,4,9,'STRAIGHT_JEANS','Straight Jeans','active',59,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(62,4,9,'REGULAR_JEANS','Regular Jeans','active',60,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(63,4,9,'RELAXED_JEANS','Relaxed Jeans','active',61,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(64,4,9,'TAPERED_JEANS','Tapered Jeans','active',62,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(65,4,9,'WIDE_LEG_JEANS','Wide Leg Jeans','active',63,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(66,4,9,'BOOTCUT_JEANS','Bootcut Jeans','active',64,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(67,4,9,'FLARE_JEANS','Flare Jeans','active',65,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(68,4,9,'MOM_JEANS','Mom Jeans','active',66,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(69,4,9,'BOYFRIEND_JEANS','Boyfriend Jeans','active',67,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(70,4,10,'CHINO_SHORTS','Chino Shorts','active',68,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(71,4,30,'DENIM_SHORTS','Denim Shorts','active',69,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(72,4,10,'CARGO_SHORTS','Cargo Shorts','active',70,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(73,4,10,'BERMUDA_SHORTS','Bermuda Shorts','active',71,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(74,4,10,'RUNNING_SHORTS','Running Shorts','active',72,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(75,4,10,'ATHLETIC_SHORTS','Athletic Shorts','active',73,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(76,4,10,'SWIM_SHORTS','Swim Shorts','active',74,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(77,4,10,'BOXER_SHORTS','Boxer Shorts','active',75,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(78,4,10,'CYCLING_SHORTS','Cycling Shorts','active',76,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(79,4,11,'LEGGINGS','Leggings','active',77,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(80,4,11,'YOGA_LEGGINGS','Yoga Leggings','active',78,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(81,4,11,'JEGGINGS','Jeggings','active',79,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(82,4,12,'MINI_DRESS','Mini Dress','active',80,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(83,4,12,'MIDI_DRESS','Midi Dress','active',81,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(84,4,12,'MAXI_DRESS','Maxi Dress','active',82,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(85,4,12,'SHIRT_DRESS','Shirt Dress','active',83,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(86,4,12,'WRAP_DRESS','Wrap Dress','active',84,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(87,4,12,'SLIP_DRESS','Slip Dress','active',85,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(88,4,12,'BODYCON_DRESS','Bodycon Dress','active',86,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(89,4,12,'A_LINE_DRESS','A-Line Dress','active',87,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(90,4,12,'TUNIC_DRESS','Tunic Dress','active',88,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(91,4,13,'MINI_SKIRT','Mini Skirt','active',89,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(92,4,13,'MIDI_SKIRT','Midi Skirt','active',90,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(93,4,13,'MAXI_SKIRT','Maxi Skirt','active',91,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(94,4,13,'PENCIL_SKIRT','Pencil Skirt','active',92,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(95,4,13,'PLEATED_SKIRT','Pleated Skirt','active',93,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(96,4,30,'DENIM_SKIRT','Denim Skirt','active',94,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(97,4,13,'WRAP_SKIRT','Wrap Skirt','active',95,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(98,NULL,25,'BABY_ROMPER','Baby Romper','active',96,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(99,NULL,25,'BABY_BODYSUIT','Baby Bodysuit','active',97,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(100,NULL,25,'BABY_SLEEPSUIT','Baby Sleepsuit','active',98,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(101,NULL,25,'BABY_BIB','Baby Bib','active',99,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(102,NULL,25,'BABY_OVERALL','Baby Overall','active',100,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(103,NULL,25,'BABY_SET','Baby Set','active',101,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(104,NULL,25,'BABY_JUMPSUIT','Baby Jumpsuit','active',102,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(105,NULL,25,'BABY_LEGGING','Baby Legging','active',103,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(106,NULL,25,'BABY_DRESS','Baby Dress','active',104,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(107,3,26,'SCHOOL_SHIRT','School Shirt','active',105,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(108,4,26,'SCHOOL_TROUSER','School Trouser','active',106,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(109,4,26,'SCHOOL_SKIRT','School Skirt','active',107,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(110,4,26,'SCHOOL_SHORTS','School Shorts','active',108,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(111,3,26,'KIDS_T_SHIRT','Kids T-Shirt','active',109,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(112,3,26,'KIDS_POLO','Kids Polo','active',110,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(113,4,26,'KIDS_JOGGER','Kids Jogger','active',111,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(114,3,26,'KIDS_HOODIE','Kids Hoodie','active',112,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(115,3,27,'TRAINING_T_SHIRT','Training T-Shirt','active',113,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(116,3,27,'RUNNING_T_SHIRT','Running T-Shirt','active',114,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(117,4,27,'GYM_SHORTS','Gym Shorts','active',115,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(118,3,28,'CHEF_JACKET','Chef Jacket','active',116,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(119,3,29,'NIGHT_SHIRT','Night Shirt','active',117,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(120,4,29,'LOUNGE_PANT','Lounge Pant','active',118,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(122,4,30,'5_POCKET_JEANS','5 Pocket Jeans','active',120,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(123,3,27,'TRACK_JACKET','Track Jacket','active',121,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL);















REPLACE INTO `profit_analysis`(`id`,`cost_header_id`,`total_cost`,`cost_per_unit`,`selling_price`,`profit_amount`,`profit_margin_percent`,`markup_percent`,`break_even_quantity`,`created_at`,`updated_at`) values 
(1,1,0.0000,0.000000,2.0000,200.0000,100.0000,0.0000,0.0000,'2026-07-31 09:19:24','2026-07-31 09:19:24');





















REPLACE INTO `role_permissions`(`role_id`,`permission_id`) values 
(1,1),
(1,2),
(1,3),
(1,4),
(1,5),
(1,11),
(1,12),
(1,13),
(1,22),
(1,23),
(1,24),
(1,25),
(1,26),
(1,40),
(1,41),
(1,57),
(1,58),
(1,76),
(1,77),
(1,78),
(1,99),
(1,100),
(1,101),
(1,125),
(1,126),
(1,127),
(1,154),
(1,155),
(1,156),
(1,157),
(1,163),
(1,164);



REPLACE INTO `roles`(`id`,`company_id`,`code`,`name`,`is_system`,`created_at`) values 
(1,1,'ADMIN','Administrator',1,'2026-07-31 09:19:01');







REPLACE INTO `seasons`(`id`,`code`,`name`,`start_date`,`end_date`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'SE001','Spring','2026-07-01','2026-08-30','active',1,'2026-07-31 15:22:17','2026-07-31 15:22:17',NULL);











REPLACE INTO `sizes`(`id`,`code`,`name`,`size_group`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'S1','Small','S','active',1,'2026-07-31 10:43:37','2026-08-04 01:11:00',NULL);



















REPLACE INTO `supplier_categories`(`id`,`code`,`name`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'CC001','CCT','active',1,'2026-07-31 14:57:41','2026-07-31 14:57:41',NULL);







REPLACE INTO `suppliers`(`id`,`company_id`,`supplier_category_id`,`country_id`,`currency_id`,`code`,`name`,`short_name`,`email`,`cc_email`,`supply_item`,`lead_time_days`,`phone`,`transit_time`,`contact_person`,`cc_person`,`address`,`tax_number`,`payment_terms_days`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(3,1,1,3,2,'SP001','JON',NULL,'job@demo.com',NULL,NULL,NULL,'0699887765434',NULL,'Jon Ass',NULL,'California','3344556',30,'active',1,'2026-07-31 15:00:53','2026-07-31 15:00:53',NULL),
(4,1,1,1,1,'CBL001','Coats Bangladesh Ltd',NULL,'rashed.chowdhury@coats.com',NULL,NULL,NULL,'01812121211',NULL,'Mr. Rashed',NULL,'House 44, Road 11, Uttara Dhaka','223334',NULL,'active',2,'2026-07-31 15:05:38','2026-07-31 15:05:38',NULL),
(5,1,NULL,1,NULL,'COATS','Coats Bangladesh Ltd.','Coats','rashed.chowdhury@coats.com','Giasuddin.NADEEM@coats.com','Thread',4,NULL,NULL,'Mr. Rashed','Mr. Nadeem',NULL,NULL,NULL,'active',1,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(6,1,NULL,1,NULL,'A_E','American & Efird (Bangladesh) Ltd.','A&E','nahid.islam@amefird.com.bd','shiplu.chowdhury@amefird.com.bd','Thread',4,NULL,NULL,'Mr. Nahid','Mr. Shiplu',NULL,NULL,NULL,'active',2,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(7,1,NULL,1,NULL,'AMANN','Amann Bangladesh Ltd.','Amann','Jubayer.Hossen@amann.com','shymum.rahman@amann.com','Thread',4,NULL,NULL,'Mr. Jubayer','Mr. Shymum',NULL,NULL,NULL,'active',3,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(8,1,NULL,1,NULL,'ARGON','Argon Denims Ltd.','Argon','joseph@argondenims.com','kamrul@evincetextiles.com','Fabric',40,NULL,NULL,'Mr. Joseph','Mr. Kamrul',NULL,NULL,NULL,'active',4,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(9,1,NULL,1,NULL,'PARTEX','AMBER DENIM LIMITED','Partex','sazib@amber.com.bd','mamun@amber.com.bd','Fabric',40,NULL,NULL,'Mr. Sazib','Mr. Mamun',NULL,NULL,NULL,'active',5,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(10,1,NULL,224,NULL,'ABSOLUTE','Absolute Denim Co., Ltd','Absolute','barbara@absolutedenim.com',NULL,'Fabric',40,NULL,'30','Barbara',NULL,NULL,NULL,NULL,'active',6,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(11,1,NULL,172,NULL,'ADM','Artistic Denim Mills Ltd.','Adm','admsales@admdenim.com',NULL,'Fabric',30,NULL,'30','Quamar/Shakir',NULL,NULL,NULL,NULL,'active',7,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(12,1,NULL,172,NULL,'AFM','Artistic Fabric Mills (Pvt.) Ltd.','AFM','yasir.ali@artisticfabricmills.com','kashif.saeed@artisticfabricmills.com','Fabric',30,NULL,'30','Mr. Yasir','Mr. Kashif Saeed',NULL,NULL,NULL,'active',8,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(13,1,NULL,107,NULL,'ARVIND','Arvind Limited','Arvind','jafrin.sultana@arvind.in','parita.shah@arvind.in','Fabric',40,NULL,'20','Ms. Jafrin','Ms. Parita',NULL,NULL,NULL,'active',9,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(14,1,NULL,224,NULL,'AMC','Atlantic Mills (Thailand) Co., Ltd.','AMC','amrin@atlanticmills.co.th','somkiat@atlanticmills.co.th','Fabric',40,NULL,'25','Amrin','Somkiat',NULL,NULL,NULL,'active',10,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(15,1,NULL,NULL,NULL,'BOSSA','Bossa Ticaret Ve Sanayi Isletmeleri T.A.S','Bossa','EOzanlar@bossa.com.tr','MCagatay@bossa.com.tr','Fabric',35,NULL,'35','Elmas','Mert Cagatay',NULL,NULL,NULL,'active',11,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(16,1,NULL,104,NULL,'MOUFUNG','Mou Fung Limited','Moufung','janise@moufung.com.hk','raymond@moufung.com.hk','Fabric',40,NULL,'25','Janise Yim','Raymond',NULL,NULL,NULL,'active',12,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(17,1,NULL,1,NULL,'NICE_DENIM','Nice Denim Mills Limited','Nice Denim','sifat@nice-denim.com','masud.nd@znzfab.com','Fabric',40,NULL,NULL,'Mr. Sifat','Mr. Masud',NULL,NULL,NULL,'active',13,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(18,1,NULL,49,NULL,'CONE_DENIM','Cone Denim (Jiaxing) Ltd.','Cone Denim','Jessica.Lv@conedenimjx.com','Johnnie.Yuen@conedenim.com','Fabric',30,NULL,'20','Jessica','Johnnie.Yuen',NULL,NULL,NULL,'active',14,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(19,1,NULL,49,NULL,'FOSHAN','Foshan Lisheng Textile Co., Ltd.','Foshan','shanghai@vitaindigo.com','sales@vitaindigo.com','Fabric',30,NULL,'20','Sunny','Tracy',NULL,NULL,NULL,'active',15,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(20,1,NULL,172,NULL,'HANTEX','Hantex','Hantex','sarkaray@hantex.biz','rahman@hantex.biz','Fabric',30,NULL,'28','Sarkaray','Abdur Rahman',NULL,NULL,NULL,'active',16,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(21,1,NULL,172,NULL,'KASSIM_DENIM','Kassim Textiles','Kassim Denim','umair@kassimdenim.com','agha@kassimdenim.com','Fabric',30,NULL,'28','Mr. Umair','Mr. Agha',NULL,NULL,NULL,'active',17,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(22,1,NULL,1,NULL,'MDL','Mahmud Denims Ltd.','MDL','shakil.mdl@mahmudgroup-bd.com','jalal.mdl@mahmudgroup-bd.com','Fabric',40,NULL,NULL,'Mr. Shakil','Mr. Jalal',NULL,NULL,NULL,'active',18,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(23,1,NULL,NULL,NULL,'ORTA','Orta Anadolu Tic. Ve San. Isl. T.A.S.','Orta','nboni@ortaanadolu.com',NULL,'Fabric',35,NULL,'35','Nezi',NULL,NULL,NULL,NULL,'active',19,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(24,1,NULL,1,NULL,'HA_MEEM','Ha-Meem Denim Limited','Ha-Meem','abhi@hameemdenim.com','monjur@hameemdenim.com','Fabric',40,NULL,NULL,'Mr. Abhi','Mr. Monjur',NULL,NULL,NULL,'active',20,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(25,1,NULL,107,NULL,'RAYMOTEX','Raymotex Corporation','Raymotex','denim2@raymotex.com','kamal@raymotex.com','Fabric',40,NULL,'20','Mr. Palash','Mr. Kamal',NULL,NULL,NULL,'active',21,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(26,1,NULL,NULL,NULL,'SANKO','SANKO Tekstil Isletmeleri San. Ve Tic. A.S.','SANKO','meren@isko.com.tr','tkesmis@isko.com.tr','Fabric',30,NULL,'35','Murat Eren','Tevfik Kesmis',NULL,NULL,NULL,'active',22,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(27,1,NULL,49,NULL,'SHANGDONG','Shandong Daiyin Textile Group Share Co., Ltd.','Shangdong','kingk921@gmail.com','anmin.j@gmail.com','Fabric',30,NULL,'25','Kingk','Anmin',NULL,NULL,NULL,'active',23,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(28,1,NULL,49,NULL,'HUITONG','Shandong Huitong Textile Co. Ltd.','Huitong','julia@sdhttex.com','doris@sdhttex.com','Fabric',30,NULL,'30','Julia','Doris',NULL,NULL,NULL,'active',24,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(29,1,NULL,172,NULL,'US_DENIM','US Denim Mills Ltd.','US Denim','kashif.rasheed@usdenimmills.com','salman.hassan@usdenimmills.com','Fabric',30,NULL,'30','Kashif Rasheed','Salman Hassan',NULL,NULL,NULL,'active',25,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(30,1,NULL,49,NULL,'ZIBO','Zibo Pengfeng Textile Co.Ltd.','Zibo','wing@lanyansh.com','jameslee@lanyansh.com','Fabric',30,NULL,'30','Wing','James Lee',NULL,NULL,NULL,'active',26,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(31,1,NULL,1,NULL,'SHASHA','Shasha Denims Ltd.','Shasha','obaid@shashabd.com','kamruzzaman@shashabd.com','Fabric',40,NULL,NULL,'Mr. Obaid','Mr. Kamruzzaman',NULL,NULL,NULL,'active',27,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(32,1,NULL,172,NULL,'RANA_TEX','Rana Textile Mills Limited','Rana Tex','kashifhanif@rantex.net','adnan@rantex.net','Fabric',30,NULL,'30','Mr. Kashif','Mr. Adnan',NULL,NULL,NULL,'active',28,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(33,1,NULL,1,NULL,'NASSA','Nassa Taipei Denims Ltd.','Nassa','m.nayon@nassadenim.com','arafat@nassadenim.com','Fabric',40,NULL,NULL,'Mr. Nayon','Mr. Arafat',NULL,NULL,NULL,'active',29,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(34,1,NULL,1,NULL,'BOSRA','Bosra Textiles Mills Ltd.','Bosra','emdad@bosratextile.com','azad.bosra@gmail.com','Pocketing',10,NULL,NULL,'Mr. Emdad','Mr. Rafiq/Azad',NULL,NULL,NULL,'active',30,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(35,1,NULL,1,NULL,'MAXIMA','Maxima Textile Mills','Maxima','maximadhk@gmail.com',NULL,'Pocketing',10,NULL,NULL,'Mr. Babu','Mr. Shamaim/Hasan',NULL,NULL,NULL,'active',31,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(36,1,NULL,1,NULL,'ETASIA','Etasia Interlining Ltd.','Etasia','estiake@etasiainterlinings.com','john@etasiainterlinings.com','Interlining',5,NULL,NULL,'Mr. Saiem','Mr. John',NULL,NULL,NULL,'active',32,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(37,1,NULL,1,NULL,'TEX','Tex Zippers (BD) Ltd.','Tex','manu@texzipper.co.in',NULL,'Zipper',15,NULL,NULL,'Mr. Manu',NULL,NULL,NULL,NULL,'active',33,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(38,1,NULL,1,NULL,'YKK_BD','YKK Bangladesh Ltd.','YKK Bd.','farjana@ykk.com.bd','shaily@ykk.com.bd','Zipper',20,NULL,NULL,'Ms. Farjana Sharmin','Ms. Shaily Saha',NULL,NULL,NULL,'active',34,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(39,1,NULL,49,NULL,'WING_SUN','Wing Sun Metal Products Ltd.','Wing Sun','moco@wingsun.com',NULL,'Metal Items',20,NULL,'30','Moco',NULL,NULL,NULL,NULL,'active',35,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(40,1,NULL,1,NULL,'T_S_BD','T&S BUTTONS (BANGLADESH) LTD.','T&S Bd.','customerservice01@tsbuttons.com.bd','PiyashC@tsbuttons.com.bd','Metal Items',20,NULL,NULL,'Mr. Nayeem','Mr. Piash',NULL,NULL,NULL,'active',36,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(41,1,NULL,1,NULL,'DC_BUTTON','DC Button','DC Button','elaine@dcbutton.com','queenie@dcbutton.com','Metal Items',20,NULL,NULL,'Elaine Pan','Queenie Lam',NULL,NULL,NULL,'active',37,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(42,1,NULL,49,NULL,'FINARY','Finery International Company Limited','Finary','lexbice@finerybelt.com','deng198042@finerybelt.com','Badge',20,NULL,'25','Li Xinbing','Deng Bing Hong',NULL,NULL,NULL,'active',38,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(43,1,NULL,NULL,NULL,'DERIDESON','DeriDesen Etiket Dis Ticaret','DeriDeson','esrao@deridesen.com.tr','elifs@deridesen.com.tr','Badge',20,NULL,'35','Esra Ozdemir','Elif Sertkaya',NULL,NULL,NULL,'active',39,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(44,1,NULL,1,NULL,'KAND_BD','KANS (BD) LIMITED','Kand Bd.','arif@kansbd.com',NULL,'Badge',20,NULL,NULL,'Mr. Arif','Mr. Sajib',NULL,NULL,NULL,'active',40,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(45,1,NULL,1,NULL,'NEXT','Next Accessories Ltd.','Next','arafat@nextaccbd.com','sakib@nextaccbd.com','Metal Items',7,NULL,NULL,'Mr. Arafat','Mr. Sakib',NULL,NULL,NULL,'active',41,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(46,1,NULL,1,NULL,'KHAJA','Khaja & Company','Khaja','kkkk@dhaka.net','khandakerkhaza6@gmail.com','Finishing Item',7,NULL,NULL,'Mr. Khaza','Mr. Khasru',NULL,NULL,NULL,'active',42,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(47,1,NULL,1,NULL,'PAXAR','Paxar Bangladesh Ltd.','Paxar','rashed.ahmed@ap.averydennison.com','alimul.hasan@ap.averydennison.com','Label',15,NULL,NULL,'Mr. Rashed','Mr. Alimul',NULL,NULL,NULL,'active',43,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(48,1,NULL,1,NULL,'AL_MUSLIM','Al-Muslim Accessories Ltd.','Al-Muslim','rukon@almuslimgroup.net','sayed@almuslimgroup.net','Paper Items',10,NULL,NULL,'Mr. Rukon','Mr. Sayed',NULL,NULL,NULL,'active',44,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(49,1,NULL,1,NULL,'DEKKO','Dekko Accessories Limited','Dekko','towhid@dalbd.com','ahasan@dalbd.com','Metal Items',10,NULL,NULL,'Mr. Tawhid','Mr. Ahasan',NULL,NULL,NULL,'active',45,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(50,1,NULL,1,NULL,'ALIF','Alif Embroidery Village','Alif','alif@aliflammim-bd.com','rabbani@aliflammim-bd.com','Embroidery',10,NULL,NULL,'Ms. Nusrat','Mr. Rabbani',NULL,NULL,NULL,'active',46,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(53,1,NULL,1,NULL,'ITS','Intertek House Bangladesh','ITS',NULL,NULL,'Inspection',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'active',49,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(54,1,NULL,1,NULL,'SGS','SGS Bangladesh Limited','SGS',NULL,NULL,'Test',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'active',50,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(57,1,NULL,1,NULL,'GWL','Genesis Washing Ltd.','GWL',NULL,NULL,'Wash',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'active',53,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL),
(58,1,NULL,1,NULL,'CWPL','Columbia Washing Plant Ltd.','CWPL',NULL,NULL,'Wash',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'active',54,'2026-08-05 01:21:01','2026-08-05 01:21:01',NULL);







REPLACE INTO `thread_details`(`id`,`brand`,`tex`,`tkt`,`yarn_count`,`length_m`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'Astra Bleach','240','010','20/9','1000','active',1,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(2,'Astra Bleach','150','020','12/3','2000','active',2,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(3,'Astra Bleach','120','024','15/3','2000','active',3,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(4,'Astra Bleach','105','025','20/4','2000','active',4,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(5,'Astra Bleach','80','030','20/3','2000','active',5,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(6,'Astra Bleach','60','050','20/2','3000','active',6,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(7,'Astra Bleach','40','075','40/3','3000','active',7,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(8,'Astra Bleach','27','110','40/2','4000','active',8,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(9,'Astra Bleach','21','150','50/2','4000','active',9,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(10,'Astra Bleach','18','180','60/2','5000','active',10,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(11,'Astra','240','010','20/9','1000','active',11,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(12,'Astra','150','020','12/3','1000','active',12,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(13,'Astra','120','024','16/3','1000','active',13,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(14,'Astra','105','025','20/4','2000','active',14,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(15,'Astra','80','030','20/3','2000','active',15,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(16,'Astra','60','050','20/2','3000','active',16,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(17,'Astra','40','075','40/3','3000','active',17,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(18,'Astra','27','110','40/2','4000','active',18,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(19,'Astra','21','150','50/2','4000','active',19,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(20,'Astra','18','180','60/2','2000','active',20,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(21,'Epic Bleach','150','018','12/3','1000','active',21,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(22,'Epic Bleach','120','025',NULL,'2000','active',22,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(23,'Epic Bleach','105','030','20/4','2000','active',23,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(24,'Epic Bleach','80','040','20/3','3000','active',24,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(25,'Epic Bleach','60','050','20/2','3000','active',25,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(26,'Epic Bleach','40','080','40/3','3000','active',26,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(27,'Epic Bleach','30','100','40/2','4000','active',27,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(28,'Epic Bleach','21','150','50/2','4000','active',28,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(29,'Epic Bleach','18','180','60/2','5000','active',29,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(30,'Epic','210','012','20/9','1000','active',30,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(31,'Epic','150','018','12/3','1000','active',31,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(32,'Epic','120','025',NULL,'2000','active',32,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(33,'Epic','105','030','20/4','2000','active',33,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(34,'Epic','80','040','20/3','3000','active',34,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(35,'Epic','60','050','20/2','3000','active',35,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(36,'Epic','40','080','40/3','3000','active',36,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(37,'Epic','30','100','40/2','4000','active',37,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(38,'Epic','21','150','50/2','4000','active',38,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(39,'Epic','18','180','60/2','5000','active',39,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(40,'Dual Duty','220','012','20/9','500','active',40,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(41,'Dual Duty','150','020','12/3','1500','active',41,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(42,'Dual Duty','120','025',NULL,'2500','active',42,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(43,'Dual Duty','105','030','20/4','2500','active',43,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(44,'Dual Duty','80','036',NULL,'2500','active',44,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(45,'Dual Duty','60','050','20/2','5000','active',45,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(46,'Dual Duty','40','075','40/3','5000','active',46,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(47,'Dual Duty','30','100','40/2','5000','active',47,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(48,'Dual Duty','24','120','60/3','5000','active',48,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(49,'Gramax','18','160','35/1','5000','active',49,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(50,'Gramax','21','140','54/2','5000','active',50,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(51,'Gramax','70','040','35/4','5000','active',51,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(52,'Gramax','35','080','35/2','5000','active',52,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(53,'Gral','12','180','104/3','5000','active',53,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(54,'Gral','45','060','35/3','1500','active',54,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(55,'Gral','10','300',NULL,'5000','active',55,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(56,'Gral','21','120',NULL,'5000','active',56,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(57,'DYMAX','270','008','21/3*3','1500','active',57,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(58,'DYMAX','105','018','18/3','5000','active',58,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(59,'DYMAX','80','024','24/3','5000','active',59,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(60,'DYMAX','60','030','30/3','5000','active',60,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(61,'DYMAX','30','060','60/3','5000','active',61,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(62,'Eloflex','27','120',NULL,'3000','active',62,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(63,'Eloflex','70','50',NULL,'2000','active',63,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(64,'Eloflex','105','30',NULL,'2000','active',64,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(65,'Sylko','27','120','120/2','3000','active',65,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(66,'Water Soluble','30','120',NULL,'5000','active',66,'2026-08-05 01:20:20','2026-08-05 01:21:00','2026-08-05 01:21:00'),
(67,'Astra Bleach','240','010','20/9','1000','active',1,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(68,'Astra Bleach','150','020','12/3','2000','active',2,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(69,'Astra Bleach','120','024','15/3','2000','active',3,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(70,'Astra Bleach','105','025','20/4','2000','active',4,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(71,'Astra Bleach','80','030','20/3','2000','active',5,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(72,'Astra Bleach','60','050','20/2','3000','active',6,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(73,'Astra Bleach','40','075','40/3','3000','active',7,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(74,'Astra Bleach','27','110','40/2','4000','active',8,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(75,'Astra Bleach','21','150','50/2','4000','active',9,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(76,'Astra Bleach','18','180','60/2','5000','active',10,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(77,'Astra','240','010','20/9','1000','active',11,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(78,'Astra','150','020','12/3','1000','active',12,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(79,'Astra','120','024','16/3','1000','active',13,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(80,'Astra','105','025','20/4','2000','active',14,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(81,'Astra','80','030','20/3','2000','active',15,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(82,'Astra','60','050','20/2','3000','active',16,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(83,'Astra','40','075','40/3','3000','active',17,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(84,'Astra','27','110','40/2','4000','active',18,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(85,'Astra','21','150','50/2','4000','active',19,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(86,'Astra','18','180','60/2','2000','active',20,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(87,'Epic Bleach','150','018','12/3','1000','active',21,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(88,'Epic Bleach','120','025',NULL,'2000','active',22,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(89,'Epic Bleach','105','030','20/4','2000','active',23,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(90,'Epic Bleach','80','040','20/3','3000','active',24,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(91,'Epic Bleach','60','050','20/2','3000','active',25,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(92,'Epic Bleach','40','080','40/3','3000','active',26,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(93,'Epic Bleach','30','100','40/2','4000','active',27,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(94,'Epic Bleach','21','150','50/2','4000','active',28,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(95,'Epic Bleach','18','180','60/2','5000','active',29,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(96,'Epic','210','012','20/9','1000','active',30,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(97,'Epic','150','018','12/3','1000','active',31,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(98,'Epic','120','025',NULL,'2000','active',32,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(99,'Epic','105','030','20/4','2000','active',33,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(100,'Epic','80','040','20/3','3000','active',34,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(101,'Epic','60','050','20/2','3000','active',35,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(102,'Epic','40','080','40/3','3000','active',36,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(103,'Epic','30','100','40/2','4000','active',37,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(104,'Epic','21','150','50/2','4000','active',38,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(105,'Epic','18','180','60/2','5000','active',39,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(106,'Dual Duty','220','012','20/9','500','active',40,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(107,'Dual Duty','150','020','12/3','1500','active',41,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(108,'Dual Duty','120','025',NULL,'2500','active',42,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(109,'Dual Duty','105','030','20/4','2500','active',43,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(110,'Dual Duty','80','036',NULL,'2500','active',44,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(111,'Dual Duty','60','050','20/2','5000','active',45,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(112,'Dual Duty','40','075','40/3','5000','active',46,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(113,'Dual Duty','30','100','40/2','5000','active',47,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(114,'Dual Duty','24','120','60/3','5000','active',48,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(115,'Gramax','18','160','35/1','5000','active',49,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(116,'Gramax','21','140','54/2','5000','active',50,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(117,'Gramax','70','040','35/4','5000','active',51,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(118,'Gramax','35','080','35/2','5000','active',52,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(119,'Gral','12','180','104/3','5000','active',53,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(120,'Gral','45','060','35/3','1500','active',54,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(121,'Gral','10','300',NULL,'5000','active',55,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(122,'Gral','21','120',NULL,'5000','active',56,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(123,'DYMAX','270','008','21/3*3','1500','active',57,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(124,'DYMAX','105','018','18/3','5000','active',58,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(125,'DYMAX','80','024','24/3','5000','active',59,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(126,'DYMAX','60','030','30/3','5000','active',60,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(127,'DYMAX','30','060','60/3','5000','active',61,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(128,'Eloflex','27','120',NULL,'3000','active',62,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(129,'Eloflex','70','50',NULL,'2000','active',63,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(130,'Eloflex','105','30',NULL,'2000','active',64,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(131,'Sylko','27','120','120/2','3000','active',65,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL),
(132,'Water Soluble','30','120',NULL,'5000','active',66,'2026-08-05 01:21:00','2026-08-05 01:21:00',NULL);





REPLACE INTO `unit_conversions`(`id`,`from_unit_id`,`to_unit_id`,`factor`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,1,1,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(2,1,2,0.0833333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(3,1,3,0.0100000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(4,1,4,0.0069444444,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(5,1,5,0.0010000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(6,1,6,0.0005787037,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(7,2,1,12.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(8,2,2,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(9,2,3,0.1200000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(10,2,4,0.0833333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(11,2,5,0.0120000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(12,2,6,0.0069444444,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(13,3,1,100.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(14,3,2,8.3333333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(15,3,3,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(16,3,4,0.6944444444,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(17,3,5,0.1000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(18,3,6,0.0578703704,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(19,4,1,144.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(20,4,2,12.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(21,4,3,1.4400000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(22,4,4,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(23,4,5,0.1440000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(24,4,6,0.0833333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(25,5,1,1000.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(26,5,2,83.3333333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(27,5,3,10.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(28,5,4,6.9444444444,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(29,5,5,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(30,5,6,0.5787037037,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(31,6,1,1728.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(32,6,2,144.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(33,6,3,17.2800000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(34,6,4,12.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(35,6,5,1.7280000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(36,6,6,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(37,7,7,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(38,7,8,1.0936132983,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(39,7,9,3.2808398950,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(40,7,10,39.3700787402,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(41,8,7,0.9144000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(42,8,8,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(43,8,9,3.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(44,8,10,36.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(45,9,7,0.3048000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(46,9,8,0.3333333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(47,9,9,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(48,9,10,12.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(49,10,7,0.0254000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(50,10,8,0.0277777778,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(51,10,9,0.0833333333,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(52,10,10,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(53,11,11,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(54,11,12,2.2046200000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(55,12,11,0.4535929094,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL),
(56,12,12,1.0000000000,'active','2026-08-05 01:09:45','2026-08-05 01:09:45',NULL);



REPLACE INTO `unit_masters`(`id`,`item_category`,`unit_code`,`unit_name`,`uom_id`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'Fabric','YDS','Yds',4,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(2,'Fabric','MTR','Mtr',3,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(3,'Knit Fabric','YDS','Yds',4,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(4,'Knit Fabric','MTR','Mtr',3,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(5,'Knit Fabric','KG','Kg',2,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(6,'Pocketing','YDS','Yds',4,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(7,'Pocketing','MTR','Mtr',3,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(8,'Interlining','YDS','Yds',4,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(9,'Interlining','MTR','Mtr',3,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(10,'Zipper','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(11,'Zipper','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(12,'Zipper','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(13,'Zipper','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(14,'Zipper','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(15,'Zipper','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(16,'Zipper','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(17,'Metal Item','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(18,'Metal Item','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(19,'Metal Item','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(20,'Metal Item','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(21,'Metal Item','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(22,'Metal Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(23,'Metal Item','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(24,'Badge/Patch','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(25,'Badge/Patch','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(26,'Badge/Patch','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(27,'Badge/Patch','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(28,'Badge/Patch','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(29,'Badge/Patch','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(30,'Badge/Patch','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(31,'Paper Item','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(32,'Paper Item','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(33,'Paper Item','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(34,'Paper Item','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(35,'Paper Item','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(36,'Paper Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(37,'Paper Item','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(38,'Label','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(39,'Label','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(40,'Label','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(41,'Label','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(42,'Label','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(43,'Label','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(44,'Label','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(45,'Finishing Item','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(46,'Finishing Item','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(47,'Finishing Item','HUNDRED','100 Pcs',8,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(48,'Finishing Item','GRS','Grs',7,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(49,'Finishing Item','K','K',52,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(50,'Finishing Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(51,'Finishing Item','GG','GG',53,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(52,'Thread','CONE','Cone',20,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(53,'Service','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(54,'Service','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(55,'Lace, Elastic','PCS','Pc',1,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(56,'Lace, Elastic','DOZ','Doz',6,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(57,'Lace, Elastic','YDS','Yds',4,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(58,'Lace, Elastic','MTR','Mtr',3,'active','2026-08-04 01:32:28','2026-08-04 01:32:28',NULL);



REPLACE INTO `uoms`(`id`,`code`,`name`,`category`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'PCS','Pieces','quantity','active',1,'2026-07-31 08:33:24','2026-07-31 08:33:24',NULL),
(2,'KG','Kilogram','weight','active',27,'2026-07-31 08:33:24','2026-08-02 23:34:50',NULL),
(3,'MTR','Meter','length','active',21,'2026-07-31 08:33:24','2026-08-02 23:34:50',NULL),
(4,'YDS','Yard','length','active',24,'2026-07-31 08:33:24','2026-08-02 23:34:50',NULL),
(6,'DOZ','Dozen','quantity','active',2,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(7,'GROSS','Gross','quantity','active',3,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(8,'HUNDRED','Hundred','quantity','active',4,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(9,'THOUSAND','Thousand','quantity','active',5,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(10,'PAIR','Pair','quantity','active',6,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(11,'SET','Set','quantity','active',7,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(12,'UNIT','Unit','quantity','active',8,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(13,'PACK','Pack','quantity','active',9,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(14,'BOX','Box','quantity','active',10,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(15,'CTN','Carton','quantity','active',11,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(16,'BAG','Bag','quantity','active',12,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(17,'BDL','Bundle','quantity','active',13,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(18,'LOT','Lot','quantity','active',14,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(19,'ROLL','Roll','quantity','active',15,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(20,'CONE','Cone','quantity','active',16,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(21,'BOBBIN','Bobbin','quantity','active',17,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(22,'SPOOL','Spool','quantity','active',18,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(23,'MM','Millimeter','length','active',19,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(24,'CM','Centimeter','length','active',20,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(26,'IN','Inch','length','active',22,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(27,'FT','Foot','length','active',23,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(29,'MG','Milligram','weight','active',25,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(30,'G','Gram','weight','active',26,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(32,'OZ','Ounce','weight','active',28,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(33,'LB','Pound','weight','active',29,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(34,'MT','Metric Ton','weight','active',30,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(35,'TON','Ton','weight','active',31,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(36,'SQCM','Square Centimeter','area','active',32,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(37,'SQM','Square Meter','area','active',33,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(38,'SQIN','Square Inch','area','active',34,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(39,'SQFT','Square Foot','area','active',35,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(40,'SQY','Square Yard','area','active',36,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(41,'ML','Milliliter','volume','active',37,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(42,'LTR','Liter','volume','active',38,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(43,'GAL','Gallon','volume','active',39,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(44,'CBM','Cubic Meter','volume','active',40,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(45,'SEC','Second','time','active',41,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(46,'MIN','Minute','time','active',42,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(47,'HR','Hour','time','active',43,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(48,'DAY','Day','time','active',44,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(49,'SHIFT','Shift','time','active',45,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(50,'PCT','Percent','ratio','active',46,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(51,'GSM','Grams per Square Meter','density','active',47,'2026-08-02 23:34:50','2026-08-02 23:34:50',NULL),
(52,'K','Thousand (K)','quantity','active',48,'2026-08-04 01:32:28','2026-08-04 01:32:28',NULL),
(53,'GG','Great Gross','quantity','active',49,'2026-08-04 01:32:28','2026-08-04 01:32:28',NULL);




/*Data for the table `users` (bootstrap — missing from source dump) */
REPLACE INTO `users`(`id`,`company_id`,`name`,`email`,`password_hash`,`status`,`last_login_at`,`created_at`,`updated_at`,`deleted_at`) VALUES
(1,1,'System Administrator','admin@gpcm.local','ynfIeVLjvKBQ6h9TdtOjr.RIy5Iuux7PeSsVbZls0FtuCBTxVoYNq','active',NULL,'2026-07-31 09:03:50','2026-07-31 09:03:50',NULL);
REPLACE INTO `user_roles`(`user_id`,`role_id`) values 
(1,1);











REPLACE INTO `zipper_tape_colors`(`id`,`code`,`name`,`tcx_code`,`tpx_code`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'001','YKK-180',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(2,'002','YKK-560',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(3,'003','YKK-580',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(4,'004','YKK-501',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(5,'005','YKK-502',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(6,'006','YKK-030',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(7,'007','YKK-918',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(8,'008','YKK-119',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(9,'009','YKK-577',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(10,'010','YKK-572',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(11,'011','YKK-025',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(12,'012','YKK-568',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(13,'013','YKK-820',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(14,'014','YKK-566',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(15,'015','YKK-864',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(16,'016','YKK-519',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(17,'017','YKK-520',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(18,'018','YKK-523',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL),
(19,'019','YKK-543',NULL,NULL,'active','2026-08-04 01:24:32','2026-08-04 01:24:32',NULL);



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;