
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `name` varchar(150) NOT NULL,
  `legal_name` varchar(200) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `tax_number` varchar(80) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
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 13:03:50','2026-07-31 13:03:50',NULL);
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `alpha_3` varchar(3) DEFAULT NULL,
  `numeric_code` varchar(3) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
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 12:33:24','2026-08-03 03:21:46',NULL),(2,'USD','US Dollar',239,'United States','$',2,'active',1,'2026-07-31 12:33:24','2026-08-03 03:21:46',NULL),(4,'EUR','Euro',NULL,'Eurozone','Γé¼',2,'active',2,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(5,'GBP','Pound Sterling',238,'United Kingdom','┬ú',2,'active',3,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(6,'JPY','Japanese Yen',116,'Japan','┬Ñ',0,'active',4,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(7,'CNY','Chinese Yuan Renminbi',49,'China','┬Ñ',2,'active',5,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(8,'HKD','Hong Kong Dollar',104,'Hong Kong','HK$',2,'active',6,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(9,'SGD','Singapore Dollar',204,'Singapore','S$',2,'active',7,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(10,'AUD','Australian Dollar',17,'Australia','A$',2,'active',8,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(11,'NZD','New Zealand Dollar',162,'New Zealand','NZ$',2,'active',9,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(12,'CAD','Canadian Dollar',44,'Canada','C$',2,'active',10,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(13,'CHF','Swiss Franc',219,'Switzerland','CHF',2,'active',11,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(14,'SEK','Swedish Krona',218,'Sweden','kr',2,'active',12,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(15,'NOK','Norwegian Krone',170,'Norway','kr',2,'active',13,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(16,'DKK','Danish Krone',64,'Denmark','kr',2,'active',14,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(17,'INR','Indian Rupee',107,'India','Γé╣',2,'active',15,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(19,'PKR','Pakistani Rupee',172,'Pakistan','Γé¿',2,'active',17,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(20,'AED','UAE Dirham',237,'United Arab Emirates','╪».╪Ñ',2,'active',18,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(21,'SAR','Saudi Riyal',199,'Saudi Arabia','∩╖╝',2,'active',19,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(22,'KRW','South Korean Won',123,'South Korea','Γé⌐',0,'active',20,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(23,'THB','Thai Baht',224,'Thailand','α╕┐',2,'active',21,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(24,'MYR','Malaysian Ringgit',138,'Malaysia','RM',2,'active',22,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(25,'IDR','Indonesian Rupiah',108,'Indonesia','Rp',0,'active',23,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(26,'VND','Vietnamese Dong',245,'Vietnam','Γé½',0,'active',24,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(27,'TWD','New Taiwan Dollar',221,'Taiwan','NT$',2,'active',25,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(28,'ZAR','South African Rand',210,'South Africa','R',2,'active',26,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(29,'BRL','Brazilian Real',35,'Brazil','R$',2,'active',27,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(30,'MXN','Mexican Peso',147,'Mexico','$',2,'active',28,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(31,'TRY','Turkish Lira',231,'T├╝rkiye','Γé║',2,'active',29,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL),(32,'PLN','Polish Z┼éoty',181,'Poland','z┼é',2,'active',30,'2026-08-03 03:21:46','2026-08-03 03:21:46',NULL);
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `uoms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uoms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `uoms` WRITE;
/*!40000 ALTER TABLE `uoms` DISABLE KEYS */;
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 12:33:24','2026-07-31 12:33:24',NULL),(2,'KG','Kilogram','weight','active',27,'2026-07-31 12:33:24','2026-08-03 03:34:50',NULL),(3,'MTR','Meter','length','active',21,'2026-07-31 12:33:24','2026-08-03 03:34:50',NULL),(4,'YDS','Yard','length','active',24,'2026-07-31 12:33:24','2026-08-03 03:34:50',NULL),(6,'DOZ','Dozen','quantity','active',2,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(7,'GROSS','Gross','quantity','active',3,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(8,'HUNDRED','Hundred','quantity','active',4,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(9,'THOUSAND','Thousand','quantity','active',5,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(10,'PAIR','Pair','quantity','active',6,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(11,'SET','Set','quantity','active',7,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(12,'UNIT','Unit','quantity','active',8,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(13,'PACK','Pack','quantity','active',9,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(14,'BOX','Box','quantity','active',10,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(15,'CTN','Carton','quantity','active',11,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(16,'BAG','Bag','quantity','active',12,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(17,'BDL','Bundle','quantity','active',13,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(18,'LOT','Lot','quantity','active',14,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(19,'ROLL','Roll','quantity','active',15,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(20,'CONE','Cone','quantity','active',16,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(21,'BOBBIN','Bobbin','quantity','active',17,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(22,'SPOOL','Spool','quantity','active',18,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(23,'MM','Millimeter','length','active',19,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(24,'CM','Centimeter','length','active',20,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(26,'IN','Inch','length','active',22,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(27,'FT','Foot','length','active',23,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(29,'MG','Milligram','weight','active',25,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(30,'G','Gram','weight','active',26,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(32,'OZ','Ounce','weight','active',28,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(33,'LB','Pound','weight','active',29,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(34,'MT','Metric Ton','weight','active',30,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(35,'TON','Ton','weight','active',31,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(36,'SQCM','Square Centimeter','area','active',32,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(37,'SQM','Square Meter','area','active',33,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(38,'SQIN','Square Inch','area','active',34,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(39,'SQFT','Square Foot','area','active',35,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(40,'SQY','Square Yard','area','active',36,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(41,'ML','Milliliter','volume','active',37,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(42,'LTR','Liter','volume','active',38,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(43,'GAL','Gallon','volume','active',39,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(44,'CBM','Cubic Meter','volume','active',40,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(45,'SEC','Second','time','active',41,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(46,'MIN','Minute','time','active',42,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(47,'HR','Hour','time','active',43,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(48,'DAY','Day','time','active',44,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(49,'SHIFT','Shift','time','active',45,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(50,'PCT','Percent','ratio','active',46,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(51,'GSM','Grams per Square Meter','density','active',47,'2026-08-03 03:34:50','2026-08-03 03:34:50',NULL),(52,'K','Thousand (K)','quantity','active',48,'2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(53,'GG','Great Gross','quantity','active',49,'2026-08-04 05:32:28','2026-08-04 05:32:28',NULL);
/*!40000 ALTER TABLE `uoms` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `unit_masters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_masters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_category` varchar(80) NOT NULL,
  `unit_code` varchar(30) NOT NULL,
  `unit_name` varchar(50) NOT NULL,
  `uom_id` bigint(20) unsigned DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_unit_master_item_unit` (`item_category`,`unit_code`),
  KEY `fk_unit_master_uom` (`uom_id`),
  CONSTRAINT `fk_unit_master_uom` FOREIGN KEY (`uom_id`) REFERENCES `uoms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `unit_masters` WRITE;
/*!40000 ALTER TABLE `unit_masters` DISABLE KEYS */;
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 05:32:28','2026-08-04 05:32:28',NULL),(2,'Fabric','MTR','Mtr',3,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(3,'Knit Fabric','YDS','Yds',4,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(4,'Knit Fabric','MTR','Mtr',3,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(5,'Knit Fabric','KG','Kg',2,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(6,'Pocketing','YDS','Yds',4,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(7,'Pocketing','MTR','Mtr',3,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(8,'Interlining','YDS','Yds',4,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(9,'Interlining','MTR','Mtr',3,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(10,'Zipper','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(11,'Zipper','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(12,'Zipper','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(13,'Zipper','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(14,'Zipper','K','K',52,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(15,'Zipper','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(16,'Zipper','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(17,'Metal Item','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(18,'Metal Item','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(19,'Metal Item','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(20,'Metal Item','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(21,'Metal Item','K','K',52,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(22,'Metal Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(23,'Metal Item','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(24,'Badge-Patch','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(25,'Badge-Patch','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(26,'Badge-Patch','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(27,'Badge-Patch','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(28,'Badge-Patch','K','K',52,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(29,'Badge-Patch','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(30,'Badge-Patch','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(31,'Paper Item','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(32,'Paper Item','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(33,'Paper Item','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(34,'Paper Item','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(35,'Paper Item','K','K',52,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(36,'Paper Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(37,'Paper Item','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(38,'Label','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(39,'Label','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(40,'Label','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(41,'Label','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(42,'Label','K','K',52,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(43,'Label','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(44,'Label','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(45,'Finishing Item','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(46,'Finishing Item','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(47,'Finishing Item','HUNDRED','100 Pcs',8,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(48,'Finishing Item','GRS','Grs',7,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(49,'Finishing Item','K','K',52,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(50,'Finishing Item','THOUSAND','1000 Pcs',9,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(51,'Finishing Item','GG','GG',53,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(52,'Thread','CONE','Con',20,'active','2026-08-04 05:32:28','2026-08-08 03:45:09',NULL),(53,'Service','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(54,'Service','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-04 05:32:28',NULL),(55,'Lace-Elastic','PCS','Pc',1,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(56,'Lace-Elastic','DOZ','Doz',6,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(57,'Lace-Elastic','YDS','Yds',4,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL),(58,'Lace-Elastic','MTR','Mtr',3,'active','2026-08-04 05:32:28','2026-08-07 14:43:39',NULL);
/*!40000 ALTER TABLE `unit_masters` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `unit_conversions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_conversions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_unit_id` bigint(20) unsigned NOT NULL,
  `to_unit_id` bigint(20) unsigned NOT NULL,
  `factor` decimal(24,10) NOT NULL DEFAULT 1.0000000000,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_unit_conversion_pair` (`from_unit_id`,`to_unit_id`),
  KEY `fk_unit_conversion_to` (`to_unit_id`),
  CONSTRAINT `fk_unit_conversion_from` FOREIGN KEY (`from_unit_id`) REFERENCES `converter_unit_names` (`id`),
  CONSTRAINT `fk_unit_conversion_to` FOREIGN KEY (`to_unit_id`) REFERENCES `converter_unit_names` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `unit_conversions` WRITE;
/*!40000 ALTER TABLE `unit_conversions` DISABLE KEYS */;
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 05:09:45','2026-08-05 05:09:45',NULL),(2,1,2,0.0833333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(3,1,3,0.0100000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(4,1,4,0.0069444444,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(5,1,5,0.0010000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(6,1,6,0.0005787037,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(7,2,1,12.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(8,2,2,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(9,2,3,0.1200000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(10,2,4,0.0833333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(11,2,5,0.0120000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(12,2,6,0.0069444444,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(13,3,1,100.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(14,3,2,8.3333333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(15,3,3,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(16,3,4,0.6944444444,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(17,3,5,0.1000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(18,3,6,0.0578703704,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(19,4,1,144.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(20,4,2,12.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(21,4,3,1.4400000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(22,4,4,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(23,4,5,0.1440000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(24,4,6,0.0833333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(25,5,1,1000.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(26,5,2,83.3333333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(27,5,3,10.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(28,5,4,6.9444444444,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(29,5,5,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(30,5,6,0.5787037037,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(31,6,1,1728.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(32,6,2,144.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(33,6,3,17.2800000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(34,6,4,12.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(35,6,5,1.7280000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(36,6,6,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(37,7,7,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(38,7,8,1.0936132983,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(39,7,9,3.2808398950,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(40,7,10,39.3700787402,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(41,8,7,0.9144000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(42,8,8,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(43,8,9,3.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(44,8,10,36.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(45,9,7,0.3048000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(46,9,8,0.3333333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(47,9,9,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(48,9,10,12.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(49,10,7,0.0254000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(50,10,8,0.0277777778,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(51,10,9,0.0833333333,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(52,10,10,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(53,11,11,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(54,11,12,2.2046200000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(55,12,11,0.4535929094,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL),(56,12,12,1.0000000000,'active','2026-08-05 05:09:45','2026-08-05 05:09:45',NULL);
/*!40000 ALTER TABLE `unit_conversions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `prefix_masters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prefix_masters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `examples` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `prefix_masters` WRITE;
/*!40000 ALTER TABLE `prefix_masters` DISABLE KEYS */;
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 06:30:49','2026-08-04 06:30:49',NULL),(2,'02','Knit Fabric','Single Jersey, Double Jersey, Rib, Interlock, Pique, Fleece','active','2026-08-04 06:30:49','2026-08-08 03:52:07',NULL),(3,'03','Pocketing','TC Sheeting, Sheeting, TC, Twill, TC Twill, Satin','active','2026-08-04 06:30:49','2026-08-08 03:15:16',NULL),(4,'04','Interlining','Dot Fused, Micro Dot, Non Woven, Woven','active','2026-08-04 06:30:49','2026-08-08 03:24:50',NULL),(5,'05','Zipper','Metal, Plastic, Nylon, Coil, Invisible','active','2026-08-04 06:30:49','2026-08-08 03:30:26',NULL),(6,'06','Thread',NULL,'active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(7,'07','Metal Item','Button, Rivet, Buckle, Eyelet','active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(8,'08','Badge-Patch','Leather, Fabric, PVC, Embroidery, Metal, Rubber','active','2026-08-04 06:30:49','2026-08-09 04:06:36',NULL),(9,'09','Paper Item',NULL,'active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(10,'10','Label',NULL,'active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(11,'11','Finishing Item',NULL,'active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(12,'12','Service','Print, Embroidery, Test, Inspection, Wash','active','2026-08-04 06:30:49','2026-08-04 06:30:49',NULL),(13,'13','Lace-Elastic','Lace, Elastic, Drawstring, Cord','active','2026-08-04 06:30:49','2026-08-07 14:43:39',NULL);
/*!40000 ALTER TABLE `prefix_masters` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `colors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `name` varchar(100) NOT NULL,
  `tcx_code` varchar(50) DEFAULT NULL,
  `tpx_code` varchar(50) DEFAULT NULL,
  `hex_code` char(7) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `fabric_contents` WRITE;
/*!40000 ALTER TABLE `fabric_contents` DISABLE KEYS */;
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 05:20:19','2026-08-05 05:20:19',NULL),(2,'ALPACA','Alpaca','active',2,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(3,'ANGORA','Angora','active',3,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(4,'BAMBOO','Bamboo','active',4,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(5,'BANANA_FIBER','Banana Fiber','active',5,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(6,'BETTER_COTTON_BCI','Better Cotton (BCI)','active',6,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(7,'CAMEL_HAIR','Camel Hair','active',7,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(8,'CARBON_FIBER','Carbon Fiber','active',8,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(9,'CASHMERE','Cashmere','active',9,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(10,'CHLOROFIBER','Chlorofiber','active',10,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(11,'COTTON','Cotton','active',11,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(12,'CUPRO','Cupro','active',12,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(13,'ELASTANE','Elastane','active',13,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(14,'ELASTOMULTIESTER','Elastomultiester','active',14,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(15,'GLASS_FIBER','Glass Fiber','active',15,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(16,'HEMP','Hemp','active',16,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(17,'JUTE','Jute','active',17,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(18,'KAPOK','Kapok','active',18,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(19,'LINEN','Linen','active',19,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(20,'LYCRA','LYCRA','active',20,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(21,'LYOCELL','Lyocell','active',21,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(22,'METALLIC_FIBER','Metallic Fiber','active',22,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(23,'MODAL','Modal','active',23,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(24,'MOHAIR','Mohair','active',24,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(25,'NYLON','Nylon','active',25,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(26,'ORANGE_FIBER','Orange Fiber','active',26,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(27,'ORGANIC_COTTON','Organic Cotton','active',27,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(28,'PINEAPPLE_FIBER','Pineapple Fiber','active',28,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(29,'POLYAMIDE','Polyamide','active',29,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(30,'POLYESTER','Polyester','active',30,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(31,'POLYETHYLENE','Polyethylene','active',31,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(32,'POLYLACTIC_ACID','Polylactic Acid','active',32,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(33,'POLYPROPYLENE','Polypropylene','active',33,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(34,'POLYVINYL_CHLORIDE','Polyvinyl Chloride','active',34,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(35,'RAMIE','Ramie','active',35,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(36,'RAYON','Rayon','active',36,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(37,'RECYCLED_COTTON','Recycled Cotton','active',37,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(38,'RECYCLED_HEMP','Recycled Hemp','active',38,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(39,'RECYCLED_NYLON','Recycled Nylon','active',39,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(40,'RECYCLED_POLYESTER','Recycled Polyester','active',40,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(41,'RECYCLED_SILK','Recycled Silk','active',41,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(42,'RECYCLED_WOOL','Recycled Wool','active',42,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(43,'SILK','Silk','active',43,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(44,'SPANDEX','Spandex','active',44,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(45,'TENCEL','Tencel','active',45,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(46,'TRIACETATE','Triacetate','active',46,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL),(47,'WOOL','Wool','active',47,'2026-08-05 05:20:19','2026-08-05 05:20:19',NULL);
/*!40000 ALTER TABLE `fabric_contents` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `metal_finishes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metal_finishes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `name` varchar(120) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `metal_finishes` WRITE;
/*!40000 ALTER TABLE `metal_finishes` DISABLE KEYS */;
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 05:20:20','2026-08-05 05:20:20',NULL),(2,'MATTE_NICKEL','Matte Nickel','Dull silver finish','active',2,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(3,'ANTIQUE_NICKEL','Antique Nickel','Aged silver appearance','active',3,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(4,'BLACK_NICKEL','Black Nickel','Dark gunmetal finish','active',4,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(5,'MATTE_BLACK_NICKEL','Matte Black Nickel','Dull black nickel','active',5,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(6,'GUN_METAL','Gun Metal','Dark metallic gray','active',6,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(7,'MATTE_GUN_METAL','Matte Gun Metal','Dull gunmetal','active',7,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(8,'SILVER','Silver','Bright silver','active',8,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(9,'MATTE_SILVER','Matte Silver','Satin silver','active',9,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(10,'ANTIQUE_SILVER','Antique Silver','Vintage silver','active',10,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(11,'GOLD','Gold','Bright gold','active',11,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(12,'MATTE_GOLD','Matte Gold','Satin gold','active',12,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(13,'LIGHT_GOLD','Light Gold','Pale gold','active',13,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(14,'ANTIQUE_GOLD','Antique Gold','Vintage gold','active',14,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(15,'ROSE_GOLD','Rose Gold','Pink gold','active',15,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(16,'MATTE_ROSE_GOLD','Matte Rose Gold','Satin rose gold','active',16,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(17,'BRASS','Brass','Yellow brass','active',17,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(18,'MATTE_BRASS','Matte Brass','Satin brass','active',18,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(19,'ANTIQUE_BRASS','Antique Brass','Aged brass','active',19,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(20,'COPPER','Copper','Bright copper','active',20,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(21,'MATTE_COPPER','Matte Copper','Satin copper','active',21,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(22,'ANTIQUE_COPPER','Antique Copper','Aged copper','active',22,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(23,'BRONZE','Bronze','Bronze finish','active',23,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(24,'ANTIQUE_BRONZE','Antique Bronze','Vintage bronze','active',24,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(25,'CHROME','Chrome','Mirror chrome','active',25,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(26,'SATIN_CHROME','Satin Chrome','Brushed chrome','active',26,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(27,'PEWTER','Pewter','Soft gray finish','active',27,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(28,'OXIDIZED_SILVER','Oxidized Silver','Dark oxidized silver','active',28,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(29,'OXIDIZED_BRASS','Oxidized Brass','Dark oxidized brass','active',29,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(30,'BLACK_OXIDE','Black Oxide','Deep black finish','active',30,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(31,'WHITE_PAINTED','White Painted','White coating','active',31,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(32,'BLACK_PAINTED','Black Painted','Black coating','active',32,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(33,'COLOR_PAINTED','Color Painted','Any painted color','active',33,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(34,'RUBBER_COATED','Rubber Coated','Soft-touch coating','active',34,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(35,'PLASTIC_COATED','Plastic Coated','Plastic-coated metal','active',35,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(36,'CLEAR_LACQUER','Clear Lacquer','Transparent protective coating','active',36,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(37,'E_COATING','E-Coating','Electrophoretic coating','active',37,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(38,'POWDER_COATED','Powder Coated','Powder paint finish','active',38,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(39,'SAND_BLASTED','Sand Blasted','Textured matte surface','active',39,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(40,'BRUSHED_FINISH','Brushed Finish','Linear brushed texture','active',40,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(41,'POLISHED','Polished','High-gloss polished','active',41,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL),(42,'VINTAGE_FINISH','Vintage Finish','Distressed look','active',42,'2026-08-05 05:20:20','2026-08-05 05:20:20',NULL);
/*!40000 ALTER TABLE `metal_finishes` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `zipper_tape_colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zipper_tape_colors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `tcx_code` varchar(50) DEFAULT NULL,
  `tpx_code` varchar(50) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `zipper_tape_colors` WRITE;
/*!40000 ALTER TABLE `zipper_tape_colors` DISABLE KEYS */;
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 05:24:32','2026-08-04 05:24:32',NULL),(2,'002','YKK-560',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(3,'003','YKK-580',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(4,'004','YKK-501',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(5,'005','YKK-502',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(6,'006','YKK-030',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(7,'007','YKK-918',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(8,'008','YKK-119',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(9,'009','YKK-577',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(10,'010','YKK-572',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(11,'011','YKK-025',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(12,'012','YKK-568',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(13,'013','YKK-820',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(14,'014','YKK-566',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(15,'015','YKK-864',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(16,'016','YKK-519',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(17,'017','YKK-520',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(18,'018','YKK-523',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL),(19,'019','YKK-543',NULL,NULL,'active','2026-08-04 05:24:32','2026-08-04 05:24:32',NULL);
/*!40000 ALTER TABLE `zipper_tape_colors` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `thread_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `thread_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `brand` varchar(120) NOT NULL,
  `tex` varchar(50) DEFAULT NULL,
  `tkt` varchar(50) DEFAULT NULL,
  `yarn_count` varchar(50) DEFAULT NULL,
  `length_m` varchar(50) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `thread_details` WRITE;
/*!40000 ALTER TABLE `thread_details` DISABLE KEYS */;
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 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(2,'Astra Bleach','150','020','12/3','2000','active',2,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(3,'Astra Bleach','120','024','15/3','2000','active',3,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(4,'Astra Bleach','105','025','20/4','2000','active',4,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(5,'Astra Bleach','80','030','20/3','2000','active',5,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(6,'Astra Bleach','60','050','20/2','3000','active',6,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(7,'Astra Bleach','40','075','40/3','3000','active',7,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(8,'Astra Bleach','27','110','40/2','4000','active',8,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(9,'Astra Bleach','21','150','50/2','4000','active',9,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(10,'Astra Bleach','18','180','60/2','5000','active',10,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(11,'Astra','240','010','20/9','1000','active',11,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(12,'Astra','150','020','12/3','1000','active',12,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(13,'Astra','120','024','16/3','1000','active',13,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(14,'Astra','105','025','20/4','2000','active',14,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(15,'Astra','80','030','20/3','2000','active',15,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(16,'Astra','60','050','20/2','3000','active',16,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(17,'Astra','40','075','40/3','3000','active',17,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(18,'Astra','27','110','40/2','4000','active',18,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(19,'Astra','21','150','50/2','4000','active',19,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(20,'Astra','18','180','60/2','2000','active',20,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(21,'Epic Bleach','150','018','12/3','1000','active',21,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(22,'Epic Bleach','120','025',NULL,'2000','active',22,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(23,'Epic Bleach','105','030','20/4','2000','active',23,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(24,'Epic Bleach','80','040','20/3','3000','active',24,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(25,'Epic Bleach','60','050','20/2','3000','active',25,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(26,'Epic Bleach','40','080','40/3','3000','active',26,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(27,'Epic Bleach','30','100','40/2','4000','active',27,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(28,'Epic Bleach','21','150','50/2','4000','active',28,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(29,'Epic Bleach','18','180','60/2','5000','active',29,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(30,'Epic','210','012','20/9','1000','active',30,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(31,'Epic','150','018','12/3','1000','active',31,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(32,'Epic','120','025',NULL,'2000','active',32,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(33,'Epic','105','030','20/4','2000','active',33,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(34,'Epic','80','040','20/3','3000','active',34,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(35,'Epic','60','050','20/2','3000','active',35,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(36,'Epic','40','080','40/3','3000','active',36,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(37,'Epic','30','100','40/2','4000','active',37,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(38,'Epic','21','150','50/2','4000','active',38,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(39,'Epic','18','180','60/2','5000','active',39,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(40,'Dual Duty','220','012','20/9','500','active',40,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(41,'Dual Duty','150','020','12/3','1500','active',41,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(42,'Dual Duty','120','025',NULL,'2500','active',42,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(43,'Dual Duty','105','030','20/4','2500','active',43,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(44,'Dual Duty','80','036',NULL,'2500','active',44,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(45,'Dual Duty','60','050','20/2','5000','active',45,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(46,'Dual Duty','40','075','40/3','5000','active',46,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(47,'Dual Duty','30','100','40/2','5000','active',47,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(48,'Dual Duty','24','120','60/3','5000','active',48,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(49,'Gramax','18','160','35/1','5000','active',49,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(50,'Gramax','21','140','54/2','5000','active',50,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(51,'Gramax','70','040','35/4','5000','active',51,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(52,'Gramax','35','080','35/2','5000','active',52,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(53,'Gral','12','180','104/3','5000','active',53,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(54,'Gral','45','060','35/3','1500','active',54,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(55,'Gral','10','300',NULL,'5000','active',55,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(56,'Gral','21','120',NULL,'5000','active',56,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(57,'DYMAX','270','008','21/3*3','1500','active',57,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(58,'DYMAX','105','018','18/3','5000','active',58,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(59,'DYMAX','80','024','24/3','5000','active',59,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(60,'DYMAX','60','030','30/3','5000','active',60,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(61,'DYMAX','30','060','60/3','5000','active',61,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(62,'Eloflex','27','120',NULL,'3000','active',62,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(63,'Eloflex','70','50',NULL,'2000','active',63,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(64,'Eloflex','105','30',NULL,'2000','active',64,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(65,'Sylko','27','120','120/2','3000','active',65,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(66,'Water Soluble','30','120',NULL,'5000','active',66,'2026-08-05 05:20:20','2026-08-05 05:21:00','2026-08-05 05:21:00'),(67,'Astra Bleach','240','010','20/9','1000','active',1,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(68,'Astra Bleach','150','020','12/3','2000','active',2,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(69,'Astra Bleach','120','024','15/3','2000','active',3,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(70,'Astra Bleach','105','025','20/4','2000','active',4,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(71,'Astra Bleach','80','030','20/3','2000','active',5,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(72,'Astra Bleach','60','050','20/2','3000','active',6,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(73,'Astra Bleach','40','075','40/3','3000','active',7,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(74,'Astra Bleach','27','110','40/2','4000','active',8,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(75,'Astra Bleach','21','150','50/2','4000','active',9,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(76,'Astra Bleach','18','180','60/2','5000','active',10,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(77,'Astra','240','010','20/9','1000','active',11,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(78,'Astra','150','020','12/3','1000','active',12,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(79,'Astra','120','024','16/3','1000','active',13,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(80,'Astra','105','025','20/4','2000','active',14,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(81,'Astra','80','030','20/3','2000','active',15,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(82,'Astra','60','050','20/2','3000','active',16,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(83,'Astra','40','075','40/3','3000','active',17,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(84,'Astra','27','110','40/2','4000','active',18,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(85,'Astra','21','150','50/2','4000','active',19,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(86,'Astra','18','180','60/2','2000','active',20,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(87,'Epic Bleach','150','018','12/3','1000','active',21,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(88,'Epic Bleach','120','025',NULL,'2000','active',22,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(89,'Epic Bleach','105','030','20/4','2000','active',23,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(90,'Epic Bleach','80','040','20/3','3000','active',24,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(91,'Epic Bleach','60','050','20/2','3000','active',25,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(92,'Epic Bleach','40','080','40/3','3000','active',26,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(93,'Epic Bleach','30','100','40/2','4000','active',27,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(94,'Epic Bleach','21','150','50/2','4000','active',28,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(95,'Epic Bleach','18','180','60/2','5000','active',29,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(96,'Epic','210','012','20/9','1000','active',30,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(97,'Epic','150','018','12/3','1000','active',31,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(98,'Epic','120','025',NULL,'2000','active',32,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(99,'Epic','105','030','20/4','2000','active',33,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(100,'Epic','80','040','20/3','3000','active',34,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(101,'Epic','60','050','20/2','3000','active',35,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(102,'Epic','40','080','40/3','3000','active',36,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(103,'Epic','30','100','40/2','4000','active',37,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(104,'Epic','21','150','50/2','4000','active',38,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(105,'Epic','18','180','60/2','5000','active',39,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(106,'Dual Duty','220','012','20/9','500','active',40,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(107,'Dual Duty','150','020','12/3','1500','active',41,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(108,'Dual Duty','120','025',NULL,'2500','active',42,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(109,'Dual Duty','105','030','20/4','2500','active',43,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(110,'Dual Duty','80','036',NULL,'2500','active',44,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(111,'Dual Duty','60','050','20/2','5000','active',45,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(112,'Dual Duty','40','075','40/3','5000','active',46,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(113,'Dual Duty','30','100','40/2','5000','active',47,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(114,'Dual Duty','24','120','60/3','5000','active',48,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(115,'Gramax','18','160','35/1','5000','active',49,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(116,'Gramax','21','140','54/2','5000','active',50,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(117,'Gramax','70','040','35/4','5000','active',51,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(118,'Gramax','35','080','35/2','5000','active',52,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(119,'Gral','12','180','104/3','5000','active',53,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(120,'Gral','45','060','35/3','1500','active',54,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(121,'Gral','10','300',NULL,'5000','active',55,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(122,'Gral','21','120',NULL,'5000','active',56,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(123,'DYMAX','270','008','21/3*3','1500','active',57,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(124,'DYMAX','105','018','18/3','5000','active',58,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(125,'DYMAX','80','024','24/3','5000','active',59,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(126,'DYMAX','60','030','30/3','5000','active',60,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(127,'DYMAX','30','060','60/3','5000','active',61,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(128,'Eloflex','27','120',NULL,'3000','active',62,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(129,'Eloflex','70','50',NULL,'2000','active',63,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(130,'Eloflex','105','30',NULL,'2000','active',64,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(131,'Sylko','27','120','120/2','3000','active',65,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL),(132,'Water Soluble','30','120',NULL,'5000','active',66,'2026-08-05 05:21:00','2026-08-05 05:21:00',NULL);
/*!40000 ALTER TABLE `thread_details` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `name` varchar(120) NOT NULL,
  `module` varchar(80) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=237 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
REPLACE INTO `permissions` (`id`, `code`, `name`, `module`, `created_at`) VALUES (1,'master.view','View Master Data','master','2026-07-31 13:19:01'),(2,'master.manage','Manage Master Data','master','2026-07-31 13:19:01'),(3,'cost.view','View Cost Engine','cost','2026-07-31 13:19:01'),(4,'cost.manage','Manage Cost Engine','cost','2026-07-31 13:19:01'),(5,'cost.approve','Approve Cost Sheets','cost','2026-07-31 13:19:01'),(11,'bom.view','View BOM Management','bom','2026-07-31 13:33:51'),(12,'bom.manage','Manage BOM Management','bom','2026-07-31 13:33:51'),(13,'bom.approve','Approve BOM Versions','bom','2026-07-31 13:33:51'),(22,'mrp.view','View MRP Management','mrp','2026-07-31 13:59:23'),(23,'mrp.manage','Manage MRP Management','mrp','2026-07-31 13:59:23'),(24,'purchase.view','View Purchase Management','purchase','2026-07-31 13:59:23'),(25,'purchase.manage','Manage Purchase Management','purchase','2026-07-31 13:59:23'),(26,'purchase.approve','Approve Purchase Documents','purchase','2026-07-31 13:59:23'),(40,'inventory.view','View Inventory Management','inventory','2026-07-31 14:06:40'),(41,'inventory.manage','Manage Inventory Management','inventory','2026-07-31 14:06:40'),(57,'production.view','View Production Management','production','2026-07-31 14:12:55'),(58,'production.manage','Manage Production Management','production','2026-07-31 14:12:55'),(76,'quality.view','View Quality Management','quality','2026-07-31 14:18:48'),(77,'quality.manage','Manage Quality Management','quality','2026-07-31 14:18:48'),(78,'quality.approve','Approve Quality Inspections','quality','2026-07-31 14:18:48'),(99,'hr.view','View HR Management','hr','2026-07-31 14:24:45'),(100,'hr.manage','Manage HR Management','hr','2026-07-31 14:24:45'),(101,'hr.approve','Approve Leave and Payroll','hr','2026-07-31 14:24:45'),(125,'accounting.view','View Accounting Management','accounting','2026-07-31 14:31:34'),(126,'accounting.manage','Manage Accounting Transactions','accounting','2026-07-31 14:31:34'),(127,'accounting.post','Post Journal Entries','accounting','2026-07-31 14:31:34'),(154,'shipment.view','View Shipment Management','shipment','2026-07-31 14:36:47'),(155,'shipment.manage','Manage Shipments','shipment','2026-07-31 14:36:47'),(156,'reports.view','View Reports Management','reports','2026-07-31 14:36:47'),(157,'reports.manage','Manage Reports and Filters','reports','2026-07-31 14:36:47'),(163,'costing_op.view','View Costing OP','costing_op','2026-07-31 19:49:04'),(164,'costing_op.manage','Manage Costing OP','costing_op','2026-07-31 19:49:04'),(190,'master.add','Add Master Data','master','2026-08-06 18:46:33'),(191,'master.edit','Edit Master Data','master','2026-08-06 18:46:33'),(192,'master.delete','Delete Master Data','master','2026-08-06 18:46:33'),(193,'cost.add','Add Cost Engine','cost','2026-08-06 18:46:33'),(194,'cost.edit','Edit Cost Engine','cost','2026-08-06 18:46:33'),(195,'cost.delete','Delete Cost Engine','cost','2026-08-06 18:46:33'),(196,'costing_op.add','Add Costing OP','costing_op','2026-08-06 18:46:33'),(197,'costing_op.edit','Edit Costing OP','costing_op','2026-08-06 18:46:33'),(198,'costing_op.delete','Delete Costing OP','costing_op','2026-08-06 18:46:33'),(199,'bom.add','Add BOM Management','bom','2026-08-06 18:46:33'),(200,'bom.edit','Edit BOM Management','bom','2026-08-06 18:46:33'),(201,'bom.delete','Delete BOM Management','bom','2026-08-06 18:46:33'),(202,'mrp.add','Add MRP Management','mrp','2026-08-06 18:46:33'),(203,'mrp.edit','Edit MRP Management','mrp','2026-08-06 18:46:33'),(204,'mrp.delete','Delete MRP Management','mrp','2026-08-06 18:46:33'),(205,'purchase.add','Add Purchase Management','purchase','2026-08-06 18:46:33'),(206,'purchase.edit','Edit Purchase Management','purchase','2026-08-06 18:46:33'),(207,'purchase.delete','Delete Purchase Management','purchase','2026-08-06 18:46:33'),(208,'inventory.add','Add Inventory Management','inventory','2026-08-06 18:46:33'),(209,'inventory.edit','Edit Inventory Management','inventory','2026-08-06 18:46:33'),(210,'inventory.delete','Delete Inventory Management','inventory','2026-08-06 18:46:33'),(211,'production.add','Add Production Management','production','2026-08-06 18:46:33'),(212,'production.edit','Edit Production Management','production','2026-08-06 18:46:33'),(213,'production.delete','Delete Production Management','production','2026-08-06 18:46:33'),(214,'quality.add','Add Quality Management','quality','2026-08-06 18:46:33'),(215,'quality.edit','Edit Quality Management','quality','2026-08-06 18:46:33'),(216,'quality.delete','Delete Quality Management','quality','2026-08-06 18:46:33'),(217,'hr.add','Add HR Management','hr','2026-08-06 18:46:33'),(218,'hr.edit','Edit HR Management','hr','2026-08-06 18:46:33'),(219,'hr.delete','Delete HR Management','hr','2026-08-06 18:46:33'),(220,'accounting.add','Add Accounting Management','accounting','2026-08-06 18:46:33'),(221,'accounting.edit','Edit Accounting Management','accounting','2026-08-06 18:46:33'),(222,'accounting.delete','Delete Accounting Management','accounting','2026-08-06 18:46:33'),(223,'shipment.add','Add Shipment Management','shipment','2026-08-06 18:46:33'),(224,'shipment.edit','Edit Shipment Management','shipment','2026-08-06 18:46:33'),(225,'shipment.delete','Delete Shipment Management','shipment','2026-08-06 18:46:33'),(226,'reports.add','Add Reports Management','reports','2026-08-06 18:46:33'),(227,'reports.edit','Edit Reports Management','reports','2026-08-06 18:46:33'),(228,'reports.delete','Delete Reports Management','reports','2026-08-06 18:46:33'),(229,'users.view','View User Permissions','users','2026-08-06 18:46:33'),(230,'users.add','Add User Permissions','users','2026-08-06 18:46:33'),(231,'users.edit','Edit User Permissions','users','2026-08-06 18:46:33'),(232,'users.delete','Delete User Permissions','users','2026-08-06 18:46:33'),(233,'item_code.view','View Item Code','item_code','2026-08-07 14:33:58'),(234,'item_code.add','Add Item Code','item_code','2026-08-07 14:33:58'),(235,'item_code.edit','Edit Item Code','item_code','2026-08-07 14:33:58'),(236,'item_code.delete','Delete Item Code','item_code','2026-08-07 14:33:58');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) unsigned DEFAULT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_role_scope_code` (`company_id`,`code`),
  CONSTRAINT `fk_role_company` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
REPLACE INTO `roles` (`id`, `company_id`, `code`, `name`, `is_system`, `created_at`) VALUES (1,1,'ADMIN','Administrator',1,'2026-07-31 13:19:01'),(2,1,'COST_MANAGER','Cost Manager',0,'2026-08-06 18:49:05');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `role_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_permissions` (
  `role_id` bigint(20) unsigned NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`),
  KEY `fk_role_permission_permission` (`permission_id`),
  CONSTRAINT `fk_role_permission_permission` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_role_permission_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `role_permissions` WRITE;
/*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */;
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),(1,190),(1,191),(1,192),(1,193),(1,194),(1,195),(1,196),(1,197),(1,198),(1,199),(1,200),(1,201),(1,202),(1,203),(1,204),(1,205),(1,206),(1,207),(1,208),(1,209),(1,210),(1,211),(1,212),(1,213),(1,214),(1,215),(1,216),(1,217),(1,218),(1,219),(1,220),(1,221),(1,222),(1,223),(1,224),(1,225),(1,226),(1,227),(1,228),(1,229),(1,230),(1,231),(1,232),(1,233),(1,234),(1,235),(1,236),(2,1),(2,3),(2,163),(2,190),(2,191),(2,192),(2,193),(2,194),(2,195),(2,196),(2,197),(2,198);
/*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `factories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) unsigned NOT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `code` varchar(30) NOT NULL,
  `name` varchar(150) NOT NULL,
  `address` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_company_factory_code` (`company_id`,`code`),
  KEY `fk_factory_branch` (`branch_id`),
  CONSTRAINT `fk_factory_branch` FOREIGN KEY (`branch_id`) REFERENCES `company_branches` (`id`),
  CONSTRAINT `fk_factory_company` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `factories` WRITE;
/*!40000 ALTER TABLE `factories` DISABLE KEYS */;
REPLACE INTO `factories` (`id`, `company_id`, `branch_id`, `code`, `name`, `address`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,1,NULL,'CC001','SOLID FEB','Savar Dhaka','active','2026-08-06 17:54:51','2026-08-06 17:54:51',NULL);
/*!40000 ALTER TABLE `factories` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

