--
-- Host: localhost    Database: pixlogix_tarpsnow
-- ------------------------------------------------------


--
-- Table structure for table `additional_hardware`
--

CREATE TABLE `additional_hardware` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `info_popup_description` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sku` varchar(255) NOT NULL,
  `unit` enum('EACH') NOT NULL,
  `cost` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `min_charge` int(11) NOT NULL,
  `status` enum('enabled','disabled') NOT NULL,
  `weight` decimal(10,4) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `curtain_selection` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`curtain_selection`)),
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `additional_hardware`
--


--
-- Table structure for table `additional_options`
--

CREATE TABLE `additional_options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `info_popup_description` text NOT NULL,
  `vendor_layout_info` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sku` varchar(255) NOT NULL,
  `unit` enum('SQ','PR','LN','EA') NOT NULL,
  `cost` decimal(10,4) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `min_charge` decimal(10,4) NOT NULL,
  `status` enum('enabled','disabled') NOT NULL,
  `weight` decimal(10,4) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `curtain_selection` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`curtain_selection`)),
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `additional_options`
--

INSERT INTO `additional_options` VALUES (1,'CHAIN BOTTOM','The weighted galvanized steel chain sewn in a pocket along the bottom edge of the curtain and is added as an additional weight to help keep the curtain more stable and reduce movement. This weighted chain option is typically used for our wash bay curtains. The curtain cannot have both a chain bottom and the 4\" open pocket. If you choose the chain bottom option, then there will be no 4\" tall open pocket.','CHAIN BOTTOM - SEWN IN CHAIN IN BOTTOM HEM - NO 4\" POCKET','uploads/CurtainImag/1746685781_Chain-Bottom.jpg','CHAIN','LN',2.0000,4.0000,20.0000,'enabled',15.0000,1,'10730724196545',0,'2025-05-08 16:29:41','2025-05-20 21:50:30'),(2,'FLOOR SWEEPS','The floor sweep will help seal the bottom of the curtain to the floor. It hang below the bottom of the curtain by 4\" and is attached with 1\" black velcro. Since velcro is used to attach this flap of material, they are able to easily be replaced, if they wear out. Sweep flap will be made from our 28 Mil Black Super Duty Vinyl.','FLOOR SWEEP -  8\" TALL SWEEP, ATTACHED WITH 1\" BLACK VELCRO TO BOTTOM OF CURTAIN- USE 22 OZ BLACK VINYL','uploads/CurtainImag/1746686176_Floor-Sweeps.png','SWEEP','LN',1.5000,3.5000,25.0000,'enabled',8.0000,2,'10730724196545',0,'2025-05-08 16:36:16','2025-05-08 16:36:16'),(3,'ANCHOR STRAPS','These floor anchor straps are used to help secure the bottom of the curtain and keep the curtain from blowing and moving. The straps are made with velcro straps and come with a mountable D-Ring base. Spaced approximately every 4-6 feet.','ANCHOR STRAPS - VELCRO TABS SEWN TO BOTTOM OF CURTAIN APPROX EVERY 4-6 FEET EVENLY SPACED, INCLUDES D-RING FLOOR PLATES','uploads/CurtainImag/1746686260_Anchor-Straps-and-Rings.png','ANCHOR-STRAPS-PLATES','LN',3.7500,6.5000,50.0000,'enabled',15.0000,3,'10730724196545',0,'2025-05-08 16:37:40','2025-05-08 16:37:40'),(4,'4\" OPEN POCKET','This is an open pocket / sleeve that is 4\" tall that runs along the entire bottom of the curtain. This is the default option for the bottom of the curtain. If you also choose the chain bottom option, then the 4\" open pocket will be removed from the curtain.','4\" OPEN POCKET ALONG BOTTOM','uploads/CurtainImag/1746686340_4inchOpenPocket1.png','POCKET','LN',1.1000,2.2000,20.0000,'enabled',4.0000,4,'10730724196545',0,'2025-05-08 16:39:00','2025-05-08 16:39:00'),(5,'VELCRO WALL SEAL','Velcro is added to both vertical ends of the curtain to allow the curtains to be sealed to a wall. The 1 1/2\" wide Black loop velcro is sewn to the back side of the ends. The 1 1/2\" Black velcro hook is included and has an adhesive back, so it can be applied to most surfaces. No grommets will be included along these velcro sides.','VELCRO WALL SEAL - 1 1/2\" LOOP BLACK VELCRO SEWN TO THE BACKSIDE OF THE ENDS (INCLUDE ADHESIVE HOOK VELCRO FOR WALL)','uploads/CurtainImag/1746686409_Velcro-Wall-Seal.png','VELCRO-ENDS','PR',1.0000,3.0000,25.0000,'enabled',2.0000,5,'10730724196545',0,'2025-05-08 16:40:09','2025-05-08 16:40:09');

--
-- Table structure for table `color_list`
--

CREATE TABLE `color_list` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `color_list`
--

INSERT INTO `color_list` VALUES (3,'OLIVE DRAB','Olive Drab','uploads/customproduct/color/OliveDrabCanvasTarp.gif',30,0,NULL,NULL),(4,'GOLDEN TAN','Golden Tan','uploads/customproduct/color/GoldenTanCanvasTarpColor.jpg',31,0,NULL,NULL),(5,'GREEN','Green Canvas','uploads/customproduct/color/GreenCanvasTarpColor.jpg',32,0,NULL,NULL),(6,'BROWN','Brown Canvas','uploads/customproduct/color/BrownCanvasTarpColor.jpg',33,0,NULL,NULL),(7,'WHITE','White Canvas','uploads/customproduct/color/WhiteCanvasTarpColor.jpg',34,0,NULL,NULL),(8,'NATURAL','Natural Canvas','uploads/customproduct/color/NaturalCanvasTarpColor.jpg',35,0,NULL,NULL),(9,'OLIVE','Olive Poly-Canvas','uploads/customproduct/color/OliveCanvasTarpColor.jpg',36,0,NULL,NULL),(10,'ROYAL BLUE','Royal Blue','uploads/customproduct/color/RoyalBlueTarpColor.jpg',5,0,NULL,NULL),(11,'BLACK','Black','uploads/customproduct/color/BlackTarpColor.jpg',1,0,NULL,NULL),(12,'GRAY','Gray','uploads/customproduct/color/GrayTarpColor.jpg',7,0,NULL,NULL),(13,'LT GRAY','Lt Gray','uploads/customproduct/color/LtGrayTarpColor.jpg',8,0,NULL,NULL),(14,'CHARCOAL','Charcoal','uploads/customproduct/color/CHARCOAL.jpeg',9,0,NULL,NULL),(15,'WHITE','White','uploads/customproduct/color/WhiteTarpColor.jpg',2,0,NULL,NULL),(16,'TAN','Tan','uploads/customproduct/color/TanTarpColor.jpg',10,0,NULL,NULL),(17,'RED','Red','uploads/customproduct/color/RedTarpColor.jpg',3,0,NULL,NULL),(18,'KELLY GREEN','Kelly Green','uploads/customproduct/color/KellyGreenTarpColor.jpg',4,0,NULL,NULL),(19,'YELLOW','Yellow','uploads/customproduct/color/YellowTarpColor.jpg',6,0,NULL,NULL),(20,'FOREST GREEN','Forest Green','uploads/customproduct/color/ForestGreenTarpColor.jpg',11,0,NULL,NULL),(21,'BROWN','Brown','uploads/customproduct/color/BrownTarpColor.jpg',12,0,NULL,NULL),(22,'NAVY','Navy','uploads/customproduct/color/NavyTarpColor.jpg',13,0,NULL,NULL),(23,'BURGUNDY','Burgundy','uploads/customproduct/color/BurgundyTarpColor.jpg',14,0,NULL,NULL),(24,'ORANGE','Orange','uploads/customproduct/color/OrangeTarpColor.jpg',15,0,NULL,NULL),(25,'CLEAR VINYL','Clear Vinyl','uploads/customproduct/color/ClearVinylColor.jpg',20,0,NULL,NULL),(26,'SMOKE GRAY','Smoke Gray','uploads/customproduct/color/WeldingScreenSmokeGrayVinylColor.jpg',21,0,NULL,NULL),(27,'GREEN','Green','uploads/customproduct/color/WeldingCurtainGreenVinylColor.jpg',22,0,NULL,NULL),(28,'BLUE','Blue','uploads/customproduct/color/WeldingScreenBlueVinylColor.jpg',23,0,NULL,NULL),(29,'RED','Red','uploads/customproduct/color/WeldingScreenRedVinylColor.jpg',24,0,NULL,NULL),(30,'YELLOW','Yellow','uploads/customproduct/color/WeldingCurtainYellowVinylColor.jpg',25,0,NULL,NULL),(31,'SILVER/BLACK','Silver/Black','uploads/customproduct/color/SilverBlackTarpColor.jpg',40,0,NULL,NULL),(32,'SILVER/WHITE','Silver/White','uploads/customproduct/color/SilverWhiteTarpColor.jpg',41,0,NULL,NULL),(33,'SALMON','Salmon','uploads/customproduct/color/SalmonAcrylicCoated_FiberglassColor.jpg',100,0,NULL,NULL),(34,'CAMO','Camouflage','uploads/customproduct/color/CamouflageVinylTarpColor.jpg',16,0,NULL,NULL),(35,'BLACK/GRAY','Black/Gray','uploads/customproduct/color/GrayBlackTarpColor.jpg',17,0,NULL,NULL),(36,'TRANSLUCENT','Translucent','uploads/customproduct/color/TranslucentTarpColor.jpg',18,0,NULL,NULL),(37,'OFF WHITE','Off White','uploads/customproduct/color/OffWhiteTarpColor.jpg',26,0,NULL,NULL),(38,'MULTI-COLOR','Multi-Color','uploads/customproduct/color/MultiColorMeshTarpColor.jpg',101,0,NULL,NULL),(39,'CHARCOAL GREY','Charcoal Grey','uploads/customproduct/color/CharcoalGreyTarp.jpg',90,0,NULL,NULL),(40,'WHITE/SILVER','White (topside) / Silver (underside)',NULL,100,0,NULL,NULL),(41,'BEIGE','Beige','uploads/customproduct/color/TanTarpColor.jpg',10,0,NULL,NULL),(42,'MOCHA SAND','Mocha Sand','uploads/customproduct/color/TanTarpColor.jpg',200,0,NULL,NULL),(43,'BLUE','Blue','uploads/customproduct/color/RoyalBlueTarpColor.jpg',10,0,NULL,NULL),(44,'LT BLUE','POOL BLUE','uploads/customproduct/color/LtBlueTarpColor1.jpg',27,0,NULL,NULL),(45,'LIME GREEN','LIME GREEN','uploads/customproduct/color/LimeGreenTarpColor1.jpg',28,0,NULL,NULL),(46,'PINK','PINK','uploads/customproduct/color/PinkTarpColor.jpeg',29,0,NULL,NULL),(47,'PURPLE','PURPLE','uploads/customproduct/color/PurpleTarpColor2.jpg',30,0,NULL,NULL),(48,'OYSTER TAN','Oyster White','uploads/customproduct/color/OffWhiteTarpColor.jpg',10,0,NULL,NULL),(49,'GREEN/BLACK','Green / Black','uploads/customproduct/color/PoolGreenMesh.jpg',45,0,NULL,NULL);

--
-- Table structure for table `colors_types`
--

CREATE TABLE `colors_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `colors_types`
--

INSERT INTO `colors_types` VALUES (1,'test123','dsd',NULL,2,1,'2025-05-07 07:08:43','2025-05-07 07:09:00'),(2,'test','sdsd','uploads/CurtainImag/1746598021_discount-list.png',3,1,'2025-05-07 15:57:13','2025-05-07 19:44:10'),(3,'TRANSLUCENT','TRANSLUCENT','uploads/CurtainImag/1hVyJx2RqyTGvPGonnkHCewO5nIYzmPy2rB3osuP.jpg',101,0,'2025-05-07 19:44:05','2025-05-07 19:44:05'),(4,'CLEAR','CLEAR','uploads/CurtainImag/OlFFmeKFB3Uzk5aeTmtnrdBH5HthzHx04bH6z85e.jpg',100,0,'2025-05-07 19:44:54','2025-05-07 19:44:54'),(5,'ORANGE','ORANGE','uploads/CurtainImag/cPq0AcxznVi6kGCQwVfXaziVEllhpk9fWJhFx41a.jpg',15,0,'2025-05-07 19:45:43','2025-05-07 19:45:43'),(6,'BURGUNDY','BURGUNDY','uploads/CurtainImag/CK1gmBiS2WjMZ2gVKx9UdSaoJh0rLohQp4phr2o1.jpg',14,0,'2025-05-07 19:46:38','2025-05-07 19:46:38'),(7,'NAVY','NAVY','uploads/CurtainImag/1746612228_NavyTarpColor.jpg',13,0,'2025-05-07 19:46:56','2025-05-07 20:03:48'),(8,'BROWN','BROWN','uploads/CurtainImag/1746612237_BrownTarpColor.jpg',12,0,'2025-05-07 19:47:02','2025-05-07 20:03:57'),(9,'FOREST GREEN','FOREST GREEN','uploads/CurtainImag/1746612246_ForestGreenTarpColor.jpg',11,0,'2025-05-07 19:47:22','2025-05-07 20:04:06'),(10,'TAN','TAN','uploads/CurtainImag/1746612257_TanTarpColor.jpg',10,0,'2025-05-07 19:47:37','2025-05-07 20:04:17'),(11,'BEIGE','BEIGE',NULL,10,0,'2025-05-07 19:47:56','2025-05-07 19:47:56'),(12,'BLUE','BLUE',NULL,10,0,'2025-05-07 19:48:18','2025-05-07 19:48:18'),(13,'TAN','TAN','uploads/CurtainImag/1746612398_OffWhiteTarpColor.jpg',10,0,'2025-05-07 19:48:44','2025-05-07 20:06:38'),(14,'CHARCOAL','CHARCOAL','uploads/CurtainImag/1746612384_CHARCOAL.jpeg',9,0,'2025-05-07 19:48:58','2025-05-07 20:06:24'),(15,'LT GRAY','LT GRAY','uploads/CurtainImag/1746612410_LtGrayTarpColor.jpg',8,0,'2025-05-07 19:49:12','2025-05-07 20:06:50'),(16,'GRAY','GRAY','uploads/CurtainImag/1746612460_GrayTarpColor.jpg',7,0,'2025-05-07 19:49:26','2025-05-07 20:07:40'),(17,'YELLOW','YELLOW','uploads/CurtainImag/1746612421_YellowTarpColor.jpg',6,0,'2025-05-07 19:49:36','2025-05-07 20:07:01'),(18,'ROYAL BLUE','ROYAL BLUE','uploads/CurtainImag/1746612472_RoyalBlueTarpColor.jpg',5,0,'2025-05-07 19:49:50','2025-05-07 20:07:52'),(19,'KELLY GREEN','KELLY GREEN','uploads/CurtainImag/1746612530_KellyGreenTarpColor.jpg',4,0,'2025-05-07 19:50:06','2025-05-07 20:08:50'),(20,'RED','RED','uploads/CurtainImag/1746612542_RedTarpColor.jpg',3,0,'2025-05-07 19:50:19','2025-05-07 20:09:02'),(21,'WHITE','WHITE','uploads/CurtainImag/1746612555_WhiteTarpColor.jpg',2,0,'2025-05-07 19:50:30','2025-05-07 20:09:15'),(22,'BLACK','BLACK','uploads/CurtainImag/1746612566_BlackTarpColor.jpg',1,0,'2025-05-07 19:50:39','2025-05-07 20:09:26');

--
-- Table structure for table `custom_notes`
--

CREATE TABLE `custom_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `tarp_selection` text DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_notes`
--

INSERT INTO `custom_notes` VALUES (1,'Made In USA.','10711373381825,10728396914881',0,0,NULL,'2025-05-18 02:52:15'),(2,'These Tarps and Covers are custom made and typically ship within 2-3 weeks.','10711373381825,10728396914881',1,0,NULL,'2025-05-19 14:18:28'),(3,'If you do not see the size you want, please email us for a quote.',NULL,2,0,NULL,'2025-05-18 03:14:41'),(4,'All of our Crystal Clear View Vinyl tarps and curtains are waterproof / UV resistant and are manufactured with 1 1/2” white polypropylene webbing reinforced hems.',NULL,3,0,NULL,'2025-05-18 03:09:20'),(5,'These custom and special orders are not returnable or refundable, but any defective parts will be repaired or replaced.','10711373381825,10728396914881',0,0,NULL,'2025-05-19 14:23:47'),(6,'All custom tarps, curtains and covers have a tolerance of (+/-) 2\" for all dimensions.',NULL,5,0,NULL,NULL),(7,'Vinyl laminated polyester, poly and canvas, should not be used as over the road truck tarps. Use our Vinyl Coated Polyester tarps.',NULL,6,0,NULL,NULL),(8,'Canvas tarps are non-trailerable. For trailer tarps, please use our Vinyl Tarps.',NULL,7,0,NULL,NULL),(9,'Canvas tarps are not recommended for indoor use because canvas tarps may leave stains and initially have an odor.',NULL,8,0,NULL,NULL),(10,'Water Resistant and Fire Resistant Canvas tarps are not recommended for indoors or used on cars, boats or other delicate surfaces. These canvas tarps may leave stains and initially have an odor.',NULL,9,0,NULL,NULL),(11,'Canvas tarps are not recommended for hanging as walls, room or space dividers, replacement canopy tops, canopy sidewalls, tent roofs or tent sidewalls, building structure roofs, sidewalls or curtains. Please use our vinyl tarps for these applications.',NULL,10,0,NULL,NULL),(12,'All cotton canvas tarps and covers (treated and untreated) shrink approx 5-12%. The exact amount of shrinkage is impossible to predict.',NULL,11,0,NULL,NULL),(13,'Flame retardant and canvas tarps will not support combustion.',NULL,12,0,NULL,NULL),(14,'Water-resistant canvas tarps are not waterproof. For waterproof tarps, please check out our waterproof vinyl tarps or waterproof poly-canvas tarps.',NULL,13,0,NULL,NULL),(15,'Due to different dye lots, colors may not match from tarp to tarp or curtain to curtain.',NULL,14,0,NULL,NULL),(16,'All Tarps, Curtains and Covers will have heat welded or sewn seams, depending on which type of fabric is used. Seams may be vertical / horizontal or both. Seams will range from every 36\" to 72\" depending upon the actual width of the fabric.',NULL,15,0,NULL,NULL),(17,'Clear Vinyl tarps, curtains and covers do shrink in cold weather.',NULL,16,0,NULL,NULL),(18,'These custom covers are not 100% water proof, some water may come in through the seams.',NULL,17,0,NULL,NULL),(19,'Make deductions in curtain for track and rollers.',NULL,18,0,NULL,NULL),(20,'For proper drape of divider curtains, add 10% to curtain width.',NULL,19,0,NULL,NULL),(21,'The canvas, poly-canvas, nylon and polyester materials all have sewn seams. If water pools on the material it will eventually drip through the stitching.',NULL,22,0,NULL,NULL),(23,'Most all materials are stitched with white colored thread.',NULL,12,0,NULL,NULL),(24,'The actual product color may vary from the color shown on the screen.',NULL,15,0,NULL,NULL),(25,'These clear vinyl tarps have a raw cut edge around the perimeter. The 1 1/2\" wide Black webbing is sewn to the underside of the perimeter edge with 2 rows of heavy duty polyester black thread.',NULL,20,0,NULL,NULL),(26,'Graphics / Logos are available, please contact us for a quote.',NULL,999,0,NULL,NULL),(27,'test','\"[\\\"Custom Curtain and Track Builder\\\"]\"',4,1,'2025-05-13 19:39:08','2025-05-13 19:39:24');

--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_type` enum('1','2') NOT NULL,
  `display_text` varchar(255) NOT NULL,
  `qty_start` int(10) unsigned DEFAULT NULL,
  `qty_end` int(10) unsigned DEFAULT NULL,
  `sqft_from` decimal(10,2) DEFAULT NULL,
  `sqft_to` decimal(10,2) DEFAULT NULL,
  `cost_discount` decimal(10,2) DEFAULT NULL,
  `price_discount` decimal(10,2) DEFAULT NULL,
  `type` enum('1','2') NOT NULL,
  `discount_type` enum('1','2') NOT NULL,
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `discounts`
--

INSERT INTO `discounts` VALUES (1,'1','QTY (5-10)',5,10,NULL,NULL,0.00,5.00,'1','1',1,0,NULL,'2025-05-15 20:08:53'),(2,'1','QTY (11-20)',11,2000,NULL,NULL,0.00,10.00,'1','1',2,0,NULL,NULL),(3,'1','QTY (1000-2000)	',NULL,NULL,1000.00,2000.00,0.00,10.00,'1','2',20,0,NULL,NULL),(4,'1','QTY (2001-10000)	',NULL,NULL,2001.00,100000.00,0.00,20.00,'1','2',21,0,NULL,NULL),(5,'1','DISCOUNT AF1',NULL,NULL,401.00,3000.00,35.00,20.00,'1','2',10,0,NULL,NULL),(6,'1','DISCOUNT AF2',NULL,NULL,196.00,460.00,30.00,15.00,'1','2',11,0,NULL,NULL),(7,'1','QTY (200+ SQFT)',NULL,NULL,200.00,2000.00,0.00,12.00,'1','2',7,0,NULL,NULL),(8,'1','QTY (2001+ SQFT)',NULL,NULL,2001.00,10000.00,0.00,20.00,'1','2',8,0,NULL,NULL),(9,'1','DISCOUNT AF3',NULL,NULL,461.00,2500.00,40.00,25.00,'1','2',12,0,NULL,NULL),(10,'1','DISCOUNT AF3 (215+)',NULL,NULL,215.00,479.00,28.00,25.00,'1','2',15,0,NULL,NULL),(11,'1','DISCOUNT AF4 (480+)',NULL,NULL,480.00,3000.00,42.00,40.00,'1','2',16,0,NULL,NULL),(12,'1','DISCOUNT AF5 (400+)',NULL,NULL,400.00,3000.00,35.80,20.00,'1','2',17,0,NULL,NULL);

--
-- Table structure for table `fabric_types`
--

CREATE TABLE `fabric_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `fabric_cost_sqft` decimal(10,4) NOT NULL,
  `weight_in_ounces` decimal(10,4) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `material_category` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `info_popup_description` text NOT NULL,
  `curtain_selection` text DEFAULT NULL,
  `top_panel_colors` text DEFAULT NULL,
  `middle_panel_colors` longtext NOT NULL,
  `bottom_panel_colors` longtext DEFAULT NULL,
  `label_top_panel` varchar(255) NOT NULL,
  `label_middle_panel` varchar(255) NOT NULL,
  `label_bottom_panel` varchar(255) NOT NULL,
  `color_info_popup` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fabric_types`
--

INSERT INTO `fabric_types` VALUES (3,'18 OZ VINYL COATED PVC',0.6670,0.1800,'18VCP','solid',1,'Our best selling reinforced vinyl coated polyester tarp material. Great for truck tarps, equipment covers and most applications. UV and tear / abrasion resistant. Waterproof.','10730724196545','22,21,20,19,18,17,15,14,10,9,8,7,6,5','NONE','22','PANEL COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 19:56:26','2025-05-20 20:11:34'),(4,'13 OZ VINYL - LAMINATED PVC - FR',0.5000,0.1300,'13VLP','solid',12,'Perfect light weight fire resistant curtain material.  Meets NFPA-701 and California State Fire Marshal F-121.2 requirements. Vinyl laminated polyester.','10730724196545','22,21,20,17,14,10,9,7,3','NONE','22','COLOR','MIDDLE PANEL COLOR','BOTTOM PANEL COLOR','COLOR',1,0,'2025-05-08 19:58:26','2025-05-20 20:12:36'),(5,'20 MIL CLEAR PVC VINYL',0.9000,0.2400,'PVC20','solid',100,'20mil / 18oz Clear View PVC Vinyl. Perfect for clear tarps, curtains and covers. For cold weather use our 30 Mil Clear vinyl. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.','10730724196545','4','NONE','4','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:09:57','2025-05-20 20:14:02'),(6,'20 MIL CLEAR PVC VINYL - FR',0.9800,0.2400,'PVC20-FR','solid',101,'Fire resistant 20mil / 18oz Clear View Vinyl PVC. Great for clear curtains, tarps and equipment covers.  For cold weather use or 30 Mil Clear vinyl. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.','10730724196545','4','NONE','4','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:11:19','2025-05-20 20:14:40'),(7,'30 MIL CLEAR PVC VINYL',1.5400,0.3200,'PVC30','solid',103,'Thicker Clear View 30mil / 27oz PVC Vinyl. For all your heavy-duty needs. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.','10730724196545','4','NONE','4','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:28:43','2025-05-20 20:15:29'),(8,'22 OZ VINYL COATED PVC',0.7900,0.2400,'VCP22','solid',0,'22 oz Vinyl Coated Polyester - Heavy-Duty reinforced vinyl, UV, tear and abrasion resistant. Waterproof. Perfect for heavy duty curtain applications.','10730724196545','22,21,20,18,17,16,9,5','NONE','22','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:30:55','2025-05-20 20:16:29'),(9,'14 OZ VINYL COATED PVC',0.6500,0.1600,'VCP14','solid',3,'Great medium weight reinforced vinyl coated polyester material. UV and tear / abrasion resistant. Waterproof.','10730724196545','22,21,20,18,16,9','NONE','22','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:32:23','2025-05-21 19:52:10'),(10,'10 OZ VINYL COATED PVC',0.5865,0.1200,'VCP10','solid',4,'The lightest weight reinforced vinyl coated polyester material that we offer. Durable, Waterproof, UV and tear / abrasion resistant','10730724196545','22,21,20,18,16,9','NONE','22','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:39:13','2025-05-20 20:18:11'),(11,'22 OZ VINYL - LAMINATED PVC - FR',0.8200,0.2400,'VLP22','solid',10,'Heavy duty vinyl laminated polyester, flame retardant, UV, waterproof and\r\ntear resistant material.','10730724196545','14,10,9,7','NONE','22','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:40:38','2025-05-20 20:21:38'),(12,'18 OZ VINYL - LAMINATED PVC - FR',0.6300,0.2000,'VLP18','solid',11,'18oz Vinyl Laminated Polyester. Flame retardant, UV, waterproof and tear resistant.','10730724196545','22,21,20,17,14,10,9,7','NONE','22,21,20,17,14,10,9,7','COLOR','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:42:37','2025-05-20 20:22:46'),(13,'18 OZ VCP WITH 20 MIL CLEAR PANEL (52” TALL), STARTING 28” UP FROM BOTTOM',1.0000,0.2400,'VCP18-20MIL-CLEAR','3panel',20,'This 18oz Vinyl Coated Polyester curtain has a 52\" tall clear vinyl horizontal panel.  The panel starts 28\" up from the bottom and is made from our 20 Mil Clear Vinyl. The remaining curtain above the clear vinyl is made from the same 18oz Vinyl Coated Polyester and is the same color as the 28\" strip below the clear panel.','10730724196545','22,21,20,19,18,17,15,14,10,9,8,7,5','CLEAR','22,21,20,19,18,17,15,14,10,9,8,7,5','TOP PANEL','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:45:02','2025-05-20 20:24:29'),(14,'18 OZ VLP-FR WITH 20 MIL FR CLEAR PANEL (52” TALL), STARTING 28” UP FROM BOTTOM',1.0400,0.2400,'VLP18-20MIL-CLEAR-FR','3panel',21,'This fire retardant combo curtain is made from our 18oz Vinyl Laminate PVC curtain has a 52\" tall clear vinyl horizontal panel.  The panel starts 28\" up from the bottom and is made from our 20 Mil Clear FR Vinyl. The remaining curtain above the clear vinyl is made from the same 18oz fire resistant vinyl and is the same color as the 28\" strip below the clear panel.','10730724196545','22,21,20,17,14,10,9,7','CLEAR','22,21,20,17,14,10,9,7','TOP PANEL','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:50:12','2025-05-20 20:25:41'),(15,'22 OZ VLP WITH 30 MIL CLEAR PANEL (52” TALL), STARTING 28” UP FROM BOTTOM',1.4000,0.3000,'VLP22-30MIL-CLEAR','3panel',22,'This 22oz Vinyl Laminated Polyester curtain has a 52\" tall clear vinyl horizontal panel.  The panel starts 28\" up from the bottom and is made from our 30 Mil Clear Vinyl. The remaining curtain above the clear vinyl is made from the same 22oz Vinyl PVC and is the same color as the 28\" strip below the clear panel.','10730724196545','16,10,9,7','CLEAR','16,10,9,7','TOP PANEL','52\" TALL HORIZONTAL MIDDLE PANEL','28\" BOTTOM PANEL','COLOR',1,0,'2025-05-08 20:52:16','2025-05-20 20:26:42');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `fastener`
--

CREATE TABLE `fastener` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `information` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `unit` enum('SQ','PR','LN','EA') NOT NULL,
  `cost` decimal(10,4) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `min_charge` decimal(10,4) NOT NULL,
  `weight` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `tarp_selection` text DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fastener`
--

INSERT INTO `fastener` VALUES (1,'No grommets or fasteners.',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',0,'10711373381825,10728396914881',0,NULL,'2025-05-18 02:08:32'),(2,'Grommets only in the (4) corners',NULL,NULL,'SQ',0.0000,0.0200,2.0000,0.0000,'1',1,'10711373381825,10728396914881',0,NULL,'2025-05-18 02:08:39'),(3,'Grommets spaced approximately @ 24\" on center around perimeter','Features grommets in all four corners only for simple, minimal tie-down points. Ideal for light to moderate coverage needs perfect for short-term outdoor use, equipment cover, or DIY projects where full edge grommets aren\'t necessary.','uploads/fastener_images/683448e192920.webp,uploads/fastener_images/683448e1929a8.webp,uploads/fastener_images/683448e1929e9.webp','SQ',0.0000,0.0400,4.0000,1.0000,'1',2,'10711373381825,10728396914881',0,NULL,'2025-05-26 20:56:33'),(4,'Grommets spaced approximately @ 18\" on center around perimeter',NULL,NULL,'SQ',0.0000,0.0600,5.0000,1.0000,'0',3,'28,139,155,568',0,NULL,NULL),(5,'Grommets spaced approximately @ 12\" on center around perimeter',NULL,NULL,'SQ',0.0300,0.1200,5.0000,1.0000,'1',4,'28,139,155,568',0,NULL,NULL),(7,'Reinforced webbing perimeter and grommets spaced approx 12\"',NULL,NULL,'SQ',0.0400,0.2300,18.0000,2.0000,'0',6,'28,139',0,NULL,NULL),(8,'Reinforced webbing perimeter and grommets spaced approx 6\"',NULL,NULL,'SQ',0.0500,0.2500,20.0000,3.0000,'0',7,'28,139',0,NULL,NULL),(9,'Grommets spaced approximately @ 24\" on center along bottom',NULL,NULL,'SQ',0.0000,0.0200,5.0000,0.0000,'1',2,'30,31,548',0,NULL,NULL),(10,'Grommets spaced approximately @ 12\" on center along bottom',NULL,NULL,'SQ',0.0000,0.0500,7.0000,0.0000,'1',2,'30,31,548',0,NULL,NULL),(11,'Grommets spaced approximately @ 6\" on center along bottom',NULL,NULL,'SQ',0.0300,0.2000,7.5000,2.0000,'1',4,'30,31,548',0,NULL,NULL),(12,'Drawstring cord along bottom',NULL,NULL,'SQ',0.0000,0.0000,7.5000,1.0000,'1',10,'30,31',0,NULL,NULL),(13,'No grommets along top or sides and 4\" pocket along bottom',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'0',8,'29,140,362,462',0,NULL,NULL),(14,'Grommets approx @ 12\" along top, none along sides and a 4\" pocket along bottom',NULL,NULL,'SQ',0.0000,0.0500,5.0000,0.0000,'0',9,'29,140,258,362,462,486',0,NULL,NULL),(15,'Grommets approx @ 12\" along top, and 24\" along sides (match side grommets curtain to curtain) and a 4\" pocket along bottom',NULL,NULL,'SQ',0.0000,0.0700,7.0000,2.0000,'0',10,'29,140,258,362,462,486',0,NULL,NULL),(16,'Grommets approx @ 12\" along top, and 18\" along sides (match side grommets curtain to curtain) and a 4\" pocket along bottom',NULL,NULL,'SQ',0.0000,0.0900,9.0000,2.0000,'0',11,'29,140,258,362,462,486',0,NULL,NULL),(17,'Grommets approx @ 12\" along top, and 12\" along sides (match side grommets curtain to curtain) and a 4\" pocket along bottom',NULL,NULL,'SQ',0.0000,0.1100,11.0000,3.0000,'0',12,'29,140,258,362,462,486',0,NULL,NULL),(18,'Grommets spaced approximately @ 6\" on center around perimeter',NULL,NULL,'SQ',0.0500,0.2000,7.5000,2.0000,'1',5,'28,139',0,NULL,NULL),(19,'Grommets approx @ 12\" apart along top and a 4\" pocket along bottom, the sides have 2\" Black Loop Velcro down back sides of curtain (adhesive Hook velcro is included) ',NULL,NULL,'PR',0.2500,2.0000,20.0000,3.0000,'0',10,'29,258,362,462,486',0,NULL,NULL),(20,'2\" Black Loop Velcro around perimeter (no grommets)(adhesive Black Hook velcro included)',NULL,NULL,'PR',1.7500,4.0000,20.0000,3.0000,'1',10,'28,139',0,NULL,NULL),(21,'\"D\" Rings at approx 24\" around perimeter',NULL,NULL,'PR',0.3500,1.0000,20.0000,3.0000,'1',8,'28,139',0,NULL,NULL),(22,'\"D\" Rings at approx 12\" around perimeter',NULL,NULL,'PR',0.4500,1.5000,20.0000,3.0000,'1',9,'28,139',0,NULL,NULL),(23,'Elastic shock cord drawstring along bottom',NULL,NULL,'SQ',0.0000,0.0000,9.0000,1.0000,'1',11,'30,31',0,NULL,NULL),(24,'Reinforced webbing sewn in perimeter hem for Grommets spaced approx @ 12\" around perimeter',NULL,NULL,'PR',0.1000,1.0000,5.0000,0.1000,'1',10,'30,31,139',0,NULL,NULL),(25,'Reinforced webbing sewn in perimeter hem for Grommets spaced approx @ 6\" around perimeter',NULL,NULL,'PR',0.1200,1.5000,10.0000,0.1000,'1',11,'30,31,139',0,NULL,NULL),(26,'Grommets approx @ 12\" apart along top and a 4\" pocket along bottom, the sides have 2\" White Loop Velcro down back sides of curtain (adhesive Hook velcro is included) ',NULL,NULL,'PR',0.2500,2.0000,20.0000,3.0000,'0',11,'29,258,362,462,486',0,NULL,NULL),(27,'Raw cut edge, no hem, no grommets or no velcro',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',200,'412',0,NULL,NULL),(28,'Finished hemmed edge, no grommets, no velcro',NULL,NULL,'SQ',0.0200,0.0500,15.0000,0.0000,'1',201,'412',0,NULL,NULL),(29,'Reinforced perimeter with 12\" spur grommet spacing',NULL,NULL,'SQ',0.0500,0.0850,15.0000,0.0000,'1',202,'412',0,NULL,NULL),(30,'Reinforced perimeter with sewn 4\" Loop Velcro ',NULL,NULL,'PR',1.2500,2.5000,40.0000,0.0000,'1',203,'412',0,NULL,NULL),(31,'WIND WEIGHTED PERIMETER',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',400,'416,471,481',0,NULL,NULL),(32,'NO MOUNTING TRACK',NULL,NULL,'LN',0.0000,0.0000,0.0000,0.0000,'1',500,'418',0,NULL,NULL),(33,'UNIVERSAL STRIP DOOR HARDWARE (CEILING OR WALL MOUNT)',NULL,NULL,'LN',0.0000,8.0000,30.0000,22.0000,'1',501,'418',0,NULL,NULL),(34,'Grommets spaced 24\" apart around perimeter and at all seams along the length.',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',410,'444',0,NULL,NULL),(35,'Reinforced perimeter with sewn 4\" Loop Velcro (adhesive hook velcro included)',NULL,NULL,'PR',1.7500,4.0000,80.0000,0.1000,'1',204,'412',0,NULL,NULL),(36,'No grommets along top or sides',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',100,'29,140,258,362,462,486',0,NULL,NULL),(37,'Grommets approx @ 12\" along top, none along sides',NULL,NULL,'SQ',0.0000,0.0500,5.0000,0.0000,'1',101,'29,140,258,362,462,486',0,NULL,NULL),(38,'Grommets approx @ 12\" along top, and 24\" along sides (match side grommets curtain to curtain)',NULL,NULL,'SQ',0.0000,0.0700,7.0000,2.0000,'1',102,'29,140,258,362,462,486',0,NULL,NULL),(39,'Grommets approx @ 12\" along top, and 18\" along sides (match side grommets curtain to curtain)',NULL,NULL,'SQ',0.0000,0.0900,9.0000,2.0000,'0',103,'29,140,258,362,462,486',0,NULL,NULL),(40,'Grommets approx @ 12\" along top, and 12\" along sides (match side grommets curtain to curtain)',NULL,NULL,'SQ',0.0000,0.1100,11.0000,3.0000,'1',104,'29,140,258,362,462,486',0,NULL,NULL),(41,'Grommets approx @ 12\" apart along top and the sides have 2\" Black Loop Velcro down back sides of curtain (adhesive Hook velcro is included) ',NULL,NULL,'PR',0.6000,2.0000,20.0000,3.0000,'1',105,'29,140,258,362,462,486',0,NULL,NULL),(42,'Grommets approx @ 12\" apart along top and the sides have 2\" White Loop Velcro down back sides of curtain (adhesive White Hook velcro is included) ',NULL,NULL,'PR',0.2500,2.0000,20.0000,3.0000,'0',106,'29,140,258,362,462,486',0,NULL,NULL),(43,'Brass #4 grommets spaced approx 24\" apart.',NULL,NULL,'SQ',0.0000,0.0500,5.0000,1.0000,'1',600,'678',0,NULL,NULL),(44,'Stainless steel #4 grommets spaced approx 18\" apart.',NULL,NULL,'SQ',0.0300,0.0800,10.0000,1.0000,'0',601,'678',0,NULL,NULL),(45,'Brass #4 grommets spaced approx 12\" apart.',NULL,NULL,'SQ',0.0400,0.1500,15.0000,1.0000,'1',602,'678',0,NULL,NULL),(46,'Brass #4 grommets spaced approx 6\" apart.',NULL,NULL,'SQ',0.0600,0.2500,20.0000,2.0000,'1',603,'678',0,NULL,NULL),(47,'2\" Loop Velcro (Black) around perimeter underside (adhesive hook velcro included)',NULL,NULL,'PR',0.8000,2.0000,20.0000,3.0000,'0',215,'493',0,NULL,NULL),(48,'\"D\" Rings at approx 24\" around perimeter',NULL,NULL,'SQ',0.1000,0.2200,20.0000,3.0000,'0',213,'493',0,NULL,NULL),(49,'\"D\" Rings at approx 12\" around perimeter',NULL,NULL,'SQ',0.1400,0.3000,20.0000,3.0000,'0',214,'493',0,NULL,NULL),(50,'Stainless steel grommets spaced approx 24\" apart around bottom with reinforced webbing.',NULL,NULL,'SQ',0.0000,0.0200,5.0000,0.0000,'0',220,'492',0,NULL,NULL),(51,'Stainless steel grommets spaced approx 12\" apart around bottom with reinforced webbing.',NULL,NULL,'SQ',0.0000,0.0500,7.0000,0.0000,'0',221,'492',0,NULL,NULL),(52,'Stainless steel grommets spaced approx 6\" apart around bottom with reinforced webbing.',NULL,NULL,'SQ',0.0300,0.2000,15.0000,2.0000,'0',222,'492',0,NULL,NULL),(53,'Drawstring cord along bottom',NULL,NULL,'SQ',0.0000,0.0000,7.5000,1.0000,'1',223,'492',0,NULL,NULL),(54,'Elastic shock cord drawstring along bottom',NULL,NULL,'SQ',0.0000,0.0000,10.0000,1.0000,'1',224,'492',0,NULL,NULL),(55,'Grommets approx @ 12\" apart along top and the sides have 2\" Black Loop Velcro on back of right side of curtain and 2\" Black Hook Velcro on front of left side of curtain (allows multiple curtains to join together).',NULL,NULL,'PR',1.6600,3.3200,20.0000,3.0000,'1',107,'29,140,258,362,462,486',0,NULL,NULL),(56,'Grommets spaced approximately @ 24\" on center around perimeter',NULL,NULL,'SQ',0.0000,0.0400,5.0000,1.0000,'1',210,'493,624',0,NULL,NULL),(57,'Grommets spaced approximately @ 18\" on center around perimeter',NULL,NULL,'SQ',0.0300,0.0700,5.0000,1.0000,'0',211,'493,624',0,NULL,NULL),(58,'Grommets spaced approximately @ 12\" on center around perimeter',NULL,NULL,'SQ',0.0400,0.0900,10.0000,1.0000,'1',212,'493,624',0,NULL,NULL),(59,'Grommets spaced approximately @ 6\" on center around perimeter',NULL,NULL,'SQ',0.0600,0.1800,15.0000,1.0000,'1',213,'155,493,624',0,NULL,NULL),(60,'\"D\" Rings at approx 24\" around perimeter',NULL,NULL,'SQ',0.1000,0.2200,20.0000,3.0000,'1',214,'493',0,NULL,NULL),(61,'\"D\" Rings at approx 12\" around perimeter',NULL,NULL,'SQ',0.1400,0.3000,20.0000,3.0000,'1',215,'493',0,NULL,NULL),(62,'2\" Loop Velcro (White) around perimeter underside (adhesive hook velcro included)',NULL,NULL,'PR',1.5000,4.0000,20.0000,3.0000,'1',217,'619',0,NULL,NULL),(63,'No grommets or fasteners. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0000,0.0000,0.0000,0.0000,'1',100,'622',0,NULL,NULL),(64,'Grommets only in the (4) corners. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0000,0.0200,2.0000,0.0000,'1',101,'622',0,NULL,NULL),(65,'Grommets spaced approximately @ 24\" on center around perimeter. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0000,0.0400,4.0000,1.0000,'1',102,'622',0,NULL,NULL),(66,'Grommets spaced approximately @ 18\" on center around perimeter. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0000,0.0600,5.0000,1.0000,'0',103,'622',0,NULL,NULL),(67,'Grommets spaced approximately @ 12\" on center around perimeter. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0100,0.1000,5.0000,1.0000,'1',104,'622',0,NULL,NULL),(68,'Grommets spaced approximately @ 6\" on center around perimeter. Reinforced 1 1/2\" wide Black webbing sewn around the entire perimeter to the underside of the tarp,',NULL,NULL,'SQ',0.0500,0.2500,18.0000,3.0000,'1',105,'622',0,NULL,NULL),(69,'2\" Wide Black Loop Velcro sewn to the underside perimeter of the tarp (adhesive hook velcro included)',NULL,NULL,'SQ',0.0000,2.5000,20.0000,0.0000,'1',106,'622',0,NULL,NULL),(70,'Weighted Chain (galv) sewn in perimeter',NULL,NULL,'PR',1.0000,10.0100,200.0000,25.0000,'1',105,'28,30,31,139',0,NULL,NULL),(71,'test',NULL,NULL,'PR',3.4400,4.4400,5.4400,6.4400,'1',4,'1,2',1,'2025-05-13 16:32:55','2025-05-13 16:36:44');

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `layout_list`
--

CREATE TABLE `layout_list` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `layout_img` varchar(255) DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `info_popup_description` text DEFAULT NULL,
  `vendor_layout_info` text DEFAULT NULL,
  `curtain_selection` text DEFAULT NULL,
  `sides` enum('1 Side','2 Side','3 Side','4 Side','5 Side','6 Side') NOT NULL DEFAULT '1 Side',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `add_corner` tinyint(1) NOT NULL DEFAULT 0,
  `corner_qty` int(11) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `layout_list`
--

INSERT INTO `layout_list` VALUES (9,'Straight Curtain','uploads/CurtainImag/1746609748_Straight_1.png','STRAIGHT',0,'STRAIGHT CURTAIN - These curtains are sewn to the sizes shown and will be manufactured as one continuous curtain, as per the sketch. The grommets are spaced approximately 12\" apart along the top and 24\" apart down both sides.','12\" GROMMETS ALONG THE TOP AND 24\" ON SIDES | 4\" POCKET ALONG BOTTOM - IF CHAIN IN BOTTOM, NO 4\" POCKET, IF VELCRO WALL SEAL, NO SIDE GROMMETS','10730724196545','1 Side',1,0,0,0,'2025-05-07 19:22:16','2025-06-13 22:00:07'),(10,'L-Shape Curtain','uploads/CurtainImag/1746609834_L_1.png','L-SHAPE',1,'L-SHAPE CURTAIN - These (2) curtains are fabricated to the sizes shown and will be made as two (2) separate curtains that will join together with velcro. These curtains will be connected using velcro along only the vertical curtain sides that meet in the corner as per the sketch. Grommets approximately spaced 12\" apart along the tops and 24\" on the left side of Curtain A and the right side of Curtain B.','12\" GROMMETS ALONG THE TOP, 24\" ON LEFT SIDE OF CURTAIN-A AND RIGHT SIDE OF CURTAIN-B | 2\" BLACK LOOP VELCRO ON BACK OF RIGHT SIDE OF CURTAIN-A AND HOOK ON FRONT LEFT SIDE OF CURTAIN-B | 4\" POCKET ALONG BOTTOM - IF CHAIN IN BOTTOM, NO 4\" POCKET, IF VELCRO WALL SEAL, NO SIDE GROMMETS','10730724196545','2 Side',1,1,1,0,'2025-05-07 19:23:20','2025-06-13 22:02:35'),(11,'T Shape Curtain','uploads/CurtainImag/Er2k88GeHSSf36yBhCKMaB6vQ0GLRmnUKTd3bUZ2.png','T-SHAPE',2,'T-SHAPE CURTAIN - These (2) curtains are fabricated to the sizes shown and will be made as two (2) separate curtains that will not join together. Grommets approximately spaced 12\" apart along the tops and 24\" on both sides of Curtain A and Curtain B.','12\" GROMMETS ALONG THE TOP AND 24\" ON SIDES OF BOTH CURTAINS | 4\" POCKET ALONG BOTTOM - IF CHAIN IN BOTTOM, NO 4\" POCKET, IF VELCRO WALL SEAL, NO SIDE GROMMETS','10730724196545','2 Side',1,0,0,0,'2025-05-07 19:25:04','2025-06-13 22:03:05'),(12,'C Shape Curtain','uploads/CurtainImag/1746622629_C_1.png','C-SHAPE',3,'C-SHAPE CURTAIN - These (3) curtains are fabricated to the sizes shown and will be made as three (3) separate curtains that will join together Curtain A to Curtain B and Curtain B to Curtain C as per the sketch. These curtains will be connected using velcro along only the vertical curtain sides that meet in the corners. Grommets approximately spaced 12\" apart along the tops and 24\" on the left side of Curtain A and the right side of Curtain C.','12\" GROMMETS ALONG THE TOP, 24\" AND ON LEFT SIDE OF CURTAIN-A AND RIGHT SIDE OF CURTAIN-C | 2\" BLACK LOOP VELCRO ON BACK OF RIGHT SIDE OF CURTAIN-A AND CURTAIN-B, HOOK ON FRONT LEFT SIDE OF CURTAIN-B AND CURTAIN-C | 4\" POCKET ALONG BOTTOM - IF CHAIN IN BOTTOM, NO 4\" POCKET, IF VELCRO WALL SEAL, NO SIDE GROMMETS','10730724196545','3 Side',1,1,2,0,'2025-05-07 19:26:42','2025-06-13 22:05:27'),(13,'Enclosure Curtain','uploads/CurtainImag/1746622689_Enc_1.png','ENCLOSURE',4,'ENCLOSURE CURTAINS - These (4) curtains are fabricated to the sizes you specify and will be made as four (4) separate curtains that will all join together. Curtain A to Curtain B, Curtain B to Curtain C, Curtain C to Curtain D and Curtain D to Curtain A as per the sketch. These curtains will be connected using velcro along only the vertical curtain sides that meet in the corners. Grommets approximately spaced 12\" apart along the tops and none on the sides..','12\" GROMMETS ALONG THE TOP ONLY | 2\" BLACK LOOP VELCRO ON BACK OF RIGHT SIDE OF CURTAIN A, B, C AND D, 2\" BLACK HOOK ON FRONT LEFT SIDE OF CURTAIN A, B, C AND CURTAIN D | 4\" POCKET ALONG BOTTOM - IF CHAIN IN BOTTOM, NO 4\" POCKET, IF VELCRO WALL SEAL, NO SIDE GROMMETS','10730724196545','4 Side',1,1,4,0,'2025-05-07 19:27:37','2025-06-13 22:05:56');

--
-- Table structure for table `layout_type_additional_images`
--

CREATE TABLE `layout_type_additional_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `layout_id` bigint(20) unsigned NOT NULL,
  `image` varchar(255) NOT NULL,
  `short_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `layout_type_additional_images`
--

INSERT INTO `layout_type_additional_images` VALUES (1,9,'uploads/AdditionalLayoutImages/5ogc0MCgxWXmMrXOX8ezUB9aS0lBq6XOTZZ7ZN3A.png',0,'2025-06-13 22:00:07','2025-06-13 22:00:07'),(2,10,'uploads/AdditionalLayoutImages/mGXvBRMecLcwzklVn7WnklHiLd63rZuPdUlgYjeT.png',0,'2025-06-13 22:02:35','2025-06-13 22:02:35'),(3,10,'uploads/AdditionalLayoutImages/GGUCtgc6fzPOeIiRQ9AAvzBNnhl1fGzgvXjDu6A6.png',1,'2025-06-13 22:02:35','2025-06-13 22:02:35'),(4,11,'uploads/AdditionalLayoutImages/EcSRHIqExbAe7uCUlDCFt016qshu6HHaUujw4C7L.png',0,'2025-06-13 22:03:05','2025-06-13 22:03:05'),(5,11,'uploads/AdditionalLayoutImages/enT7HfNPnDZYwQdlehl4XgA0D7813pIyCAgMGeVu.png',1,'2025-06-13 22:03:05','2025-06-13 22:03:05'),(6,12,'uploads/AdditionalLayoutImages/iWm67ntkxiRbBYWlag52HL6WUi8zRVi2aNQw6oZd.png',0,'2025-06-13 22:05:27','2025-06-13 22:05:27'),(7,12,'uploads/AdditionalLayoutImages/6z9ahmBWaqrrhg5pbAngB9Q6SZxIJqUBG4iFpq0p.png',1,'2025-06-13 22:05:27','2025-06-13 22:05:27'),(8,12,'uploads/AdditionalLayoutImages/Ll2Vm5kjLsn56yrkwY04iFVmCm40C8KWbyfiL3JV.png',2,'2025-06-13 22:05:27','2025-06-13 22:05:27'),(9,13,'uploads/AdditionalLayoutImages/ElRbo2SSo8OpehJ2Q2YA50XnwqEdm81AdbH13eFE.png',0,'2025-06-13 22:05:56','2025-06-13 22:05:56'),(10,13,'uploads/AdditionalLayoutImages/dD5NdugtMvolf2G508dGMwh0mB7f1Gj9AHbLkamZ.png',1,'2025-06-13 22:05:56','2025-06-13 22:05:56'),(11,13,'uploads/AdditionalLayoutImages/BQP3iFPrleNzgsqSV221iys7SIbciic7bOM1uJE1.png',2,'2025-06-13 22:05:56','2025-06-13 22:05:56'),(12,13,'uploads/AdditionalLayoutImages/0iqsFNsL3RWBQ33N2NSw3VpgkYYNkHAJ3anZ0Jm7.png',3,'2025-06-13 22:05:56','2025-06-13 22:05:56');

--
-- Table structure for table `mapping_screen`
--

CREATE TABLE `mapping_screen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  `fabric_type_id` varchar(100) NOT NULL,
  `cost_sqft` decimal(10,4) DEFAULT NULL,
  `price_sqft` decimal(10,4) DEFAULT NULL,
  `free_shipping` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mapping_screen`
--

INSERT INTO `mapping_screen` VALUES (1,'10730724196545','8',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:13:24'),(2,'10730724196545','3',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(3,'10730724196545','9',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(4,'10730724196545','10',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(5,'10730724196545','11',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(6,'10730724196545','12',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(7,'10730724196545','4',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(8,'10730724196545','13',1.1250,2.0000,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(9,'10730724196545','14',1.1250,2.3500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(10,'10730724196545','15',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(11,'10730724196545','5',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(12,'10730724196545','6',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34'),(13,'10730724196545','7',1.1250,2.2500,0,'2025-05-21 22:13:24','2025-05-21 22:14:34');

--
-- Table structure for table `material_category`
--

CREATE TABLE `material_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `material_category`
--

INSERT INTO `material_category` VALUES (1,'CANVAS',NULL,'- Canvas is great for areas that require water resistant and breathability and long lasting.',1,0,NULL,NULL),(13,'VINYL','uploads/material/1748264713_material-img.webp','- Our Vinyl choices are numerous and with many different colors and sizes available you will find the right one.',0,0,NULL,'2025-05-26 23:05:13'),(14,'POLY',NULL,'- These Poly materials are strong and waterproof with many different colors to choose from.',2,0,NULL,NULL),(15,'HIGH TEMPERATURE FABRIC',NULL,' - These types of fabrics are used for those applications that require heat resistance.',8,0,NULL,NULL),(16,'NYLON',NULL,'- This material is lightweight, strong, durable and made of synthetic fabric.',6,0,NULL,NULL),(17,'CLEAR VINYL',NULL,'- Weather resistant Clear PVC Vinyl Material for tarps curtains and covers.',4,0,NULL,NULL),(18,'MESH / SHADE',NULL,'- Multiple mesh and shade materials for all your industrial needs.',3,0,NULL,NULL),(19,'POLYESTER',NULL,'- Large selection of different denier polyester fabrics, including with vinyl and urethane coatings.',7,0,NULL,NULL),(20,'tes',NULL,'test',3,1,'2025-05-12 22:05:32','2025-05-12 22:05:38');

--
-- Table structure for table `materialstype`
--

CREATE TABLE `materialstype` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `image` varchar(255) DEFAULT NULL,
  `fabric_cost` decimal(12,4) DEFAULT NULL COMMENT 'Fabric Cost',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `sku` varchar(155) DEFAULT NULL COMMENT 'Sku',
  `sort_order` smallint(5) unsigned DEFAULT NULL COMMENT 'Sort Order',
  `color_options` text DEFAULT NULL COMMENT 'Color Options',
  `material_type` text DEFAULT NULL COMMENT 'Material Type',
  `material_description` text DEFAULT NULL COMMENT 'Material Description',
  `tooltip_info` text DEFAULT NULL,
  `selected_disocunt` text DEFAULT NULL COMMENT 'Selected Disocunt',
  `tarps_selected` text DEFAULT NULL COMMENT 'Tarps Selected',
  `material_features` text DEFAULT NULL,
  `status` smallint(6) DEFAULT 1 COMMENT 'Status',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='materialstype';

--
-- Dumping data for table `materialstype`
--

INSERT INTO `materialstype` VALUES (1,'15 OZ HEAVY DUTY RHINO-TEX CANVAS',NULL,0.7500,15.0000,'RHINO-TEX',1,'[\"11\",\"15\",\"17\",\"18\",\"22\",\"23\",\"24\"]','1','Our Most Popular Canvas Material. 15oz / 20mil - Rhino-Tex Canvas - Breathable, Water Resistant, Twice as Strong as Standard Canvas. Silicone treated polyester canvas yarns. Does not shrink. The sewn seams are not waterproof.',NULL,NULL,'[\"10711373381825\",\"10728396914881\"]',NULL,1,0,NULL,'2025-05-18 02:25:18'),(2,'16 OZ WATER RESISTANT CANVAS',NULL,0.4900,16.0000,'CWR16',2,'3,4,5,6','1','16oz Cotton Canvas is great for areas that require water resistance and breathability. Weight is after treatment. (Note:  canvas can shrink 2-7%)(Wax and dye may rub off)',NULL,NULL,'10711373381825,10728396914881',NULL,0,0,NULL,NULL),(3,'18 OZ WATER RESISTANT CANVAS',NULL,0.5100,18.0000,'CWR18',3,'3,4','1','18oz Cotton Canvas, water resistant and breathable. Weight is after treatment. (Note:  canvas can shrink 2-7%)(Wax and dye may rub off)',NULL,NULL,'28',NULL,0,0,NULL,NULL),(4,'21 OZ WATER RESISTANT CANVAS',NULL,0.6480,21.0000,'CWR21',4,'3','1','The canvas 21oz material is our heaviest weight water resistant canvas, which also breaths. Weight is after the treatment. (Note:  canvas can shrink 2-7%) (Wax and dye may rub off)',NULL,NULL,'28',NULL,0,0,NULL,NULL),(5,'16 OZ FIRE RESISTANT CANVAS',NULL,0.6100,16.0000,'CFR16',32,'3','1','16oz Cotton Canvas, flame retardant, water resistant and breathable. Weight is after treatment. (Note:  canvas can shrink 2-7%)(Wax and dye may rub off, not for indoor use)',NULL,NULL,'10711373381825,10728396914881',NULL,1,0,NULL,NULL),(6,'18 OZ FIRE RESISTANT CANVAS',NULL,0.6300,18.0000,'CFR18',31,'3','1','18oz Cotton Canvas, flame retardant, water resistant and breathable. Weight is after treatment. (Note:  canvas can shrink 2-7%)(Wax and dye may rub off, not for indoor use)',NULL,NULL,'28,140',NULL,1,0,NULL,NULL),(7,'22 OZ FIRE RESISTANT CANVAS',NULL,0.7665,22.0000,'CFR22',30,'3','1','22oz Cotton Canvas, fire resistant, water resistant and breathable. Weight is after treatment. (Note:  canvas can shrink 2-7%)(Wax and dye may rub off)',NULL,NULL,'28,30,31,140',NULL,1,0,NULL,NULL),(8,'10 OZ NATURAL CANVAS (UNTREATED)',NULL,0.2600,10.0000,'CNU10',8,'8','1','Single Filled, Tarp Grade, Untreated Natural Canvas 10 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(9,'#8 NATURAL COTTON CANVAS DUCK',NULL,0.7100,18.0000,'CDN8',4,'8','1','100% Natural Cotton Canvas Duck material. #8 Double Filled Cotton Duck Canvas - Weight 18 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(10,'#12 NATURAL COTTON CANVAS DUCK',NULL,0.4500,12.0000,'CDN12',9,'8','1','100% Natural Cotton Canvas Duck material. #12 Double Filled Cotton Duck Canvas - Weight 12 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(11,'#4 NATURAL COTTON CANVAS DUCK',NULL,1.2300,25.0000,'CDN4',11,'8','1','100% Natural Cotton Canvas Duck material. #4 Double Filled Cotton Duck Canvas - Weight 25 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(12,'#8 DYED COTTON CANVAS DUCK',NULL,1.2100,18.0000,'CDD8',5,'11','1','100% Dyed Cotton Canvas Duck material. #8 Double Filled Cotton Duck Canvas - Weight 18 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(13,'40 OZ  VINYL - REINFORCED PVC','uploads/material_types/1748256874_vinyl-material.webp',1.3450,40.0000,'VCP40',21,'11,15,17','13','Our thickest vinyl coated polyester material for those high abrasion applications. Waterproof. 40oz Vinyl Coated Polyester','Our thickest vinyl coated polyester material for those high abrasion applications',NULL,'10711373381825,10728396914881','1,2,3,4',1,0,NULL,'2025-06-13 20:59:24'),(14,'22 OZ VINYL COATED PVC',NULL,0.7900,22.0000,'VCP22',22,'11,15,17,10,19,12,20,24','13','22oz Vinyl Coated Polyester - Heavy-Duty reinforced vinyl tarps, UV, tear and abrasion resistant. Waterproof. Great for truck tarps.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(15,'22 OZ VINYL - LAMINATED PVC - FR',NULL,0.8000,22.0000,'VLP22',31,'14,16,20,22','13','Vinyl laminated polyester, flame retardant, UV and\r\ntear resistant. Waterproof.  Not to be used as truck tarps.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(16,'18 OZ VINYL COATED PVC',NULL,0.6667,18.0000,'VCP18',24,'11,15,17,18,10,19,13,14,16,20,21,22,23,24','13','Our best selling reinforced vinyl coated polyester tarp material. Great for truck tarps, equipment covers and most applications. UV and tear / abrasion resistant. Waterproof.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(17,'18 OZ VINYL COATED PVC - FR',NULL,0.3100,18.0000,'VCP18FR-TN',25,'12','13','18oz  Fire Resistant Reinforced Vinyl Coated Polyester. Great UV, Tear and Abrasion Resistance. Perfect for tarps curtains and Waterproof Covers.',NULL,NULL,'362',NULL,1,0,NULL,NULL),(18,'18 OZ VINYL COATED PVC - CAMO',NULL,0.8200,18.0000,'VCP18-CAMO',120,'34','13','Camouflage Heavy-duty vinyl coated polyester, UV and tear / abrasion resistant. ',NULL,NULL,'28,30,31',NULL,1,0,NULL,NULL),(19,'18 OZ VINYL - LAMINATED PVC - FR',NULL,0.6400,18.0000,'VLP18',32,'11,15,17,19,14,16,20,22','13','18oz Vinyl Laminated Polyester. Flame retardant, UV and tear resistant. Waterproof. Not to be used as truck tarps.',NULL,NULL,'28,29,30,31,140,362',NULL,1,0,NULL,NULL),(20,'15 OZ VINYL - REINFORCED PVC (GRADE B) - FR',NULL,0.5300,15.0000,'VCP15TT',30,'11','13','Our best priced vinyl coated polyester material. Grade \'B\" material has slight flaws in fabric and color may not match exactly. Great for truck tarps. Waterproof. Military Grade.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(21,'14 OZ VINYL COATED PVC',NULL,0.6400,14.0000,'VCP14',27,'11,15,17,10,12,20','13','Great medium weight reinforced vinyl coated polyester tarp material. UV and tear / abrasion resistant. Waterproof.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(22,'13 OZ VINYL - LAMINATED PVC - FR',NULL,0.5000,13.0000,'VLP13',33,'11,15,17,19,14,16,20,22,36','13','Perfect light weight fire resistant tarp, curtain or cover. UV and tear resistant. Waterproof. Not to be used as truck tarps. 13oz Vinyl Laminated Polyester',NULL,NULL,'28,29,30,31,139,140,155,362',NULL,1,0,NULL,NULL),(23,'12 OZ VINYL LAMINATED POLYESTER - ANTI-STATIC - FR',NULL,0.6300,12.0000,'VLP12-AS',130,'15','13','Our 11.8 oz only anti-static vinyl material. Used for tarps, covers and curtains that require anti-static and fire resistance.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(24,'10 OZ VINYL COATED PVC',NULL,0.5800,10.0000,'VCP10',28,'11,15,17,10,12,20','13','The lightest weight reinforced vinyl coated polyester tarp material. Durable, Waterproof, UV and tear / abrasion resistant.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(25,'20 MIL CLEAR PVC VINYL',NULL,0.9000,54.0000,'PVC20',40,'25','17','20mil / 18oz Clear View PVC Vinyl. Perfect for clear tarps, curtains and covers. For cold weather use our 30 Mil Clear vinyl. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.',NULL,NULL,'28,29,30,31,139,258,362',NULL,1,0,NULL,NULL),(26,'20 MIL CLEAR PVC VINYL - FR',NULL,0.9800,54.0000,'PVC20-FR',41,'25','17','Fire resistant 20mil / 18oz Clear View Vinyl PVC. Great for clear curtains, tarps and equipment covers.  For cold weather use or 30 Mil Clear vinyl. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.',NULL,NULL,'28,29,30,31,139,258,362',NULL,1,0,NULL,NULL),(27,'30 MIL CLEAR PVC VINYL',NULL,1.5400,65.0000,'PVC30',42,'25','17','Thicker Clear View 30mil / 27oz PVC Vinyl. For all your heavy-duty needs. Do not store when wet. The hems are reinforced with 1 1/2\" wide White webbing.',NULL,NULL,'28,29,30,31,139,258,362',NULL,1,0,NULL,NULL),(28,'14 MIL WELDVIEW TINTED VINYL - FR',NULL,0.7900,19.0000,'WELDPVC14',45,'26,27,28,29,30','17','Transparent Weld View 14mil vinyl for\r\nWelding Curtains. Fire Resistant.',NULL,NULL,'28,29,140',NULL,1,0,NULL,NULL),(29,'20 MIL SUPER DUTY REINFORCED POLY',NULL,0.7600,12.0000,'POLY20',51,'15,36','14','20mil / 12oz  Reinforced Polyethylene. Highly UV resistant. Excellent for carports, windbreaks and small structures. Not to be used as a truck tarps',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(30,'24 MIL SUPER DUTY REINFORCED POLY - FR',NULL,0.9200,16.0000,'POLY24-FR',50,'15','14','24mil / 16oz  Fire Retardant super strong reinforced poly. Meets NFPA 701 & CSFM fire ratings. Perfect for outdoors.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(31,'12 MIL WOVEN REINFORCED POLY',NULL,0.2500,7.0000,'POLY12',52,'31,32','14','Our most popular poly material. 12mil / 7oz Heavy-duty reinforced woven poly, highly UV resistant, treated reinforced yarns.',NULL,NULL,'28,29,30,31,139,362',NULL,1,0,NULL,NULL),(32,'12 MIL WOVEN REINFORCED POLY - FR',NULL,0.4000,7.0000,'POLY12-FR',53,'37','14','12mil / 7oz - Heavy-duty reinforced poly, flame retardant, great for indoor applications where fire resistance is needed. Not recommended for long\r\nterm outdoor use.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(33,'10 MIL WOVEN REINFORCED POLY',NULL,0.2500,6.0000,'POLY10',54,'15,10','14','Reinforced polyethylene is lightweight and strong.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(34,'10 MIL CLEAR STRING POLY',NULL,0.4000,7.0000,'POLY10HUV',55,'36','14','10mil Reinforced Clear String Poly. UV resistant. Great for temporary covers, asbestos Abatement and construction enclosures. ',NULL,NULL,'28,29',NULL,1,0,NULL,NULL),(35,'10 OZ VINYL COATED MESH - 60% SHADE',NULL,0.5000,10.0000,'VCPM10',10,'11,15,17,10,19,12,16,20,23,24','18','10oz Heavy-Duty Vinyl Coated Polyester Mesh. 11x11 Weave. 60% Shade. Great for tarps, shade and privacy screens.',NULL,NULL,'28,29,30,31,139,155,362,486',NULL,1,0,NULL,NULL),(36,'10 OZ VINYL COATED MESH - FR',NULL,0.5100,10.0000,'VCPM10-FR',61,'15','18','Fire Resistant Vinyl Coated Mesh. 10oz per sq. yd.  55% shade factor. 11x11 weave count open mesh.',NULL,NULL,'28,29,30,31,139,155,362,486',NULL,1,0,NULL,NULL),(37,'10 OZ VINYL COATED MESH - MULTI-COLOR',NULL,0.3500,10.0000,'VCPM10-MC',63,'38','18','This material is great for truck tarps. With a 13x12 Weave, this material very strong and durable. Variances in colors, patterns and shades will occur within the tarp and from tarp to tarp. Not recommended for decorative purposes.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(38,'95% PREMIUM WOVEN POLYPRO MESH',NULL,0.5700,6.0000,'PPM95',20,'11','18','5.9oz Woven polypropylene mesh. Extremely durable witha 30x20 weave. Made for fence screens and truck tarps.',NULL,NULL,'28,29,30,31,155,486',NULL,1,0,NULL,NULL),(39,'92% WOVEN POLYPRO MESH',NULL,0.8400,6.0000,'PPM92',20,'11,20','18','5.6oz Woven polypropylene mesh. Specifically made for tennis court fence screens and privacy control fences..',NULL,NULL,'155',NULL,1,0,NULL,NULL),(40,'LATHE-LENO TENNIS SCREEN MESH - 85% SHADE',NULL,0.8400,5.0000,'LLM48',66,'11,20','18','4.8oz Open mesh polypropylene material. 85% shade factor. Produced for tennis court and privacy fencing applications.',NULL,NULL,'155',NULL,1,0,NULL,NULL),(41,'87% SHADE KNITTED POLY MESH',NULL,0.3500,5.0000,'MKPE87',67,'11,15,10,20,21','18','5oz Knitted polyethylene mesh. Our most economical privacy fence mesh.',NULL,NULL,'155',NULL,1,0,NULL,NULL),(42,'CONTAINMENT MESH - FR',NULL,0.5800,6.0000,'MCC',68,'15','18','Used for containment of sandblasting, painting and construction debris and particles. Also allows for ventilation.',NULL,NULL,'619',NULL,1,0,NULL,NULL),(43,'200 DENIER POLYESTER',NULL,0.5000,4.0000,'P200D',350,'11','19','4oz / 200 Denier Polyester Oxford fabric with Urethane coating is water resistant. Great for light weight bags and equipment covers.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(44,'600 X 300 DENIER POLYESTER',NULL,0.8000,11.0000,'P6X3D',351,'11,15,17,10','19','11oz / 600 x 300 Denier Polyester with a vinyl backing for waterproofing. Use this durable material for all your inexpensive covers.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(45,'NEOPRENE COATED NYLON',NULL,2.4300,16.0000,'NCN16',90,'11','16','16oz Neoprene, waterproof, UV resistant, highly abrasion resistant and Oil and Chemical resistant.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(46,'HYPALON - CSM COATED NYLON',NULL,4.0400,16.0000,'HYP16',82,'11','16','16oz CSM coated Nylon - Hypalon. Chemical, UV, Abrasion, High Temperature resistance.  ',NULL,NULL,'28,29,30,31,139,140',NULL,1,0,NULL,NULL),(48,'SILICONE COATED FIBERGLASS 17 OZ',NULL,1.6100,17.0000,'HTF-SCF17',92,'12,29','15','Silicone Coated Fiberglass (500° F)\r\nThis consists of fiberglass material coated with silicone rubber, making it extremely flexible. It meets military specifications Mil-Y-1140C and provides superior insulation in terms of heat and electricity. It also resists oil, puncturing, and water. This material comes in grey and either 17oz or 32oz weight. It is also available for welding curtains, heat shields, and custom equipment covers. It is often used for fire blankets, removable insulation covers, expansion joints, and insulation at high temperatures.',NULL,NULL,'140',NULL,1,0,NULL,NULL),(49,'HEAT TREATED FIBERGLASS 18 OZ',NULL,0.9100,18.0000,'HTF-HTF18',93,'16','15','Heat Treated Fiberglass (1100° F)\r\nAn economical option for welding blankets, curtains, and heat shields, this material can withstand consistent temperatures that go up to 1100° F. It is often used for applications involving heat treating and as a high temperature safety barrier. It is also used as an egress blanket, welding curtains, and light duty applications. It offers excellent protection from both vertical splatter and sparks, and resists most solvents and acids. This material comes in weights of 18oz (tan) ',NULL,NULL,'140',NULL,0,0,NULL,NULL),(50,'BLACK SLAG FIBERGLASS 23 OZ',NULL,1.6100,23.0000,'HTF-BSF23',94,'11','15','Black Slag Fiberglass (1100° F)\r\nThis fabric is superior for use in tough welding applications. When it lies at a 25° or larger angle, it can shed molten splatter that reaches temperatures up to 3000° F. It also provides protection from sparks and grinding, and it is highly resistant to abrasion. As a curtain, it can be used for light to medium sparks; as a blanket, it can be used for medium sparks. This material comes in 40 mil thickness and 21oz weight. The color is black, and it can be used for welding curtains, blankets, and screens. This blanket should not be used for stress relief or heat treating.',NULL,NULL,'140',NULL,1,0,NULL,NULL),(51,'GOLD SLAG ACRYLIC COATED FIBERGLASS 24 OZ',NULL,1.4500,24.0000,'HTF-GSF24',95,'4','15','Gold Slag Acrylic Fiberglass (600° F)\r\nThis material provides superior resistance to abrasion compared to Black Slag, and it is one of our most popular welding blanket materials. At a 45° angle, it will protect you from molten splatter as well as grinding, sparks, and abrasion. It is excellent for the majority of welding applications, but it is not suggested for horizontal use. This material is gold and comes in 35 mil thickness and 24oz weight.',NULL,NULL,'140',NULL,1,0,NULL,NULL),(52,'SILICA FABRIC 18 OZ',NULL,2.8900,18.0000,'HTF-SIL18',96,'16','15','Silica Fabric (1800° F)\r\nCommonly used for applications necessitating the highest resistance to heat and chemicals, this high temperature material meets military specifications MIL-C-24576A and MIL-I-24244C. It is utilized for welding blankets, curtains, and screens as well as furnace curtains and other applications requiring resistance to extremely high temperatures. It protects against slag and molten splatter and has a melting point of 3000° F. It can also be used for stress relief. The color is tan, and it comes in 18oz ',NULL,NULL,'140',NULL,1,0,NULL,NULL),(53,'18 OZ VCP WITH 20 MIL CLEAR PANEL (52” TALL), STARTING 30” UP FROM BOTTOM',NULL,1.0000,22.0000,'VCP18-20MIL-CLEAR',100,'11,15,17,18,10,19,13,14,16,20,21,22,24','13','This 18oz Vinyl Coated Polyester curtain has a 52\" tall clear vinyl horizontal panel.  The panel starts 30\" up from the bottom and is made from our 20 Mil Clear Vinyl. The remaining curtain above the clear vinyl is made from the same 18oz Vinyl Coated Polyester and is the same color as the 30\" strip below the clear panel.',NULL,NULL,'29,258,362,462',NULL,1,0,NULL,NULL),(54,'86% SUN SHADE KNITTED POLY MESH',NULL,0.7200,11.0000,'MKPE86SS',15,'11,15,10,13,16,20','18','10oz Shade Knitted Polyethylene Mesh. Our most popular sun shade mesh. The material is dimensionally stable and perfect for shade structures.',NULL,NULL,'28,29,139,155,486',NULL,1,0,NULL,NULL),(55,'AWNING / CANOPY VINYL',NULL,2.2000,19.0000,'SAT745',29,'11,15,17,10,12,48,20,21,42','13','Our best vinyl for awnings, tents and canopies. This 10 year warranty fabric is 22 Mils thick and 19 oz per square yard.  The fabric is fire resistant, mildew resistant and highly UV resistant. Great for those areas with high sun exposure.',NULL,NULL,'28,29,30,139',NULL,1,0,NULL,NULL),(56,'AWNING / MARINE CANVAS',NULL,1.8260,9.0000,'RECACRIL',0,'11,15,17','1','Our best canvas for awnings, marine and outdoor projects. This 10 year warranty fabric is 9 oz per square yard. The fabric is a solution dyed acrylic, just like Sunbrella. It is water resistant, mildew resistant and highly UV resistant and the seams are sewn.  Great for those outdoor areas with high sun exposure.',NULL,NULL,'10711373381825,10728396914881',NULL,1,0,NULL,'2025-05-18 02:42:21'),(57,'1680 DENIER BALLISTIC NYLON',NULL,2.2500,12.0000,'N1680D-BALLISTIC',364,'11','16','Ballistic Nylon - 1680 Denier, with urethane coating and water resistant, This material has great abrasion resistance and is very strong. Used for bags, tarps and heavy duty covers.',NULL,NULL,'28,30,31',NULL,1,0,NULL,NULL),(58,'PROFESSIONAL GRADE CANVAS',NULL,1.5300,20.0000,'CANVAS',200,'11,17,10,8','1','This 18oz Heavy-Duty, Boxing Ring Canvas has reinforced Flat Double French Seams, for the smoothest seam possible.  Our cotton canvas duck material is stronger than other canvas type mat covers, being sold online. These covers are Made in the USA.',NULL,NULL,'412',NULL,1,0,NULL,NULL),(59,'PROFESSIONAL GRADE VINYL',NULL,0.7900,20.0000,'VINYL',201,'11,15,17,10,19,12,21,22,23,24','13','Our Heavy-Duty, 18oz Vinyl Boxing Ring Mat has reinforced heat welded flat seams, for the strongest, smoothest seams possible.  This thick PVC Vinyl material is stronger than other vinyl mat covers. Our covers are Made in the USA.',NULL,NULL,'412',NULL,1,0,NULL,NULL),(60,'6.3 OZ REINFORCED POLY',NULL,1.6000,45.0000,'POLY6OZ',300,'32','14','Our heavy-duty 6.3oz / 12 mil reinforced woven poly, highly UV resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'416',NULL,1,0,NULL,NULL),(61,'18 OZ REINFORCED VINYL PVC',NULL,1.7500,49.0000,'VINYL18-AF',301,'11,15,17,18,10,19,12,16,20,21,22,23,24','13','Our extreme-duty, 18oz reinforced PVC Vinyl is our longest lasting weighted tarp material. The material is highly UV resistant, abrasion resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,NULL,NULL,0,0,NULL,NULL),(62,'8\" X 80 MIL - CLEAR SMOOTH',NULL,3.1200,80.0000,'8-80-CLEAR-S-50',500,'25','17','8\" Wide x 0.080\" Thick, Clear PVC Vinyl. Smooth finish PVC strips. Recommended for doors openings up to 8\' Tall. 50% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(63,'8\" X 80 MIL - CLEAR RIBBED',NULL,3.9040,80.0000,'8-80-CLEAR-R-50',501,'25','17','8\" Wide x 0.080\" Thick, Clear PVC Vinyl. Ribbed finish PVC strips. Recommended for doors openings up to 8\' Tall. 50% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(64,'12\" X 120 MIL - CLEAR SMOOTH',NULL,4.0800,90.0000,'12-120-CLEAR-S-66',503,'25','17','12\" Wide x 0.120\" Thick, Clear PVC Vinyl. Smooth finish PVC strips. Recommended for doors openings up to 14\' Tall. 66% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(65,'12\" X 120 MIL - CLEAR RIBBED',NULL,5.7120,90.0000,'12-120-CLEAR-R-66',504,'25','17','12\" Wide x 0.120\" Thick, Clear PVC Vinyl. Ribbed finish PVC strips. Recommended for doors openings up to 14\' Tall. 66% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(66,'8\" X 80 MIL - CLEAR - LOW TEMPERATURE',NULL,3.5920,80.0000,'8-80-CLEAR-LT-50',502,'25','17','8\" Wide x 0.080\" Thick, Clear PVC Vinyl, Low Temperature. Suitable for use in freezers (down to -30 Deg F). Smooth finish PVC strips. Recommended for doors openings up to 8\' Tall. 50% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(67,'12\" X 120 MIL - CLEAR - LOW TEMPERATURE',NULL,4.6960,90.0000,'12-120-CLEAR-LT-66',505,'25','17','12\" Wide x 0.120\" Thick, Clear PVC Vinyl, Low Temperature. Suitable for use in freezers (down to -30 Deg F). Smooth finish PVC strips. Recommended for doors openings up to 14\' Tall. 66% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(68,'16\" X 160 MIL - CLEAR SMOOTH',NULL,4.4000,100.0000,'16-160-CLEAR-S-50',506,'25','17','16\" Wide x 0.160\" Thick, Clear PVC Vinyl. Smooth finish PVC strips. Recommended for doors openings over 14\' Tall. 50% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(69,'16\" X 160 MIL - CLEAR RIBBED',NULL,6.4000,100.0000,'16-160-CLEAR-R-50',507,'25','17','16\" Wide x 0.160\" Thick, Clear PVC Vinyl. Ribbed finish PVC strips. Recommended for doors openings over 14\' Tall. 50% Overlap.',NULL,NULL,'418',NULL,1,0,NULL,NULL),(70,'210 DENIER OXFORD NYLON',NULL,0.4500,4.0000,'N210D',360,'11','16','4oz / 210 Denier Nylon Oxford fabric with Urethane coating is water resistant. Great for light weight indoor, bags and equipment covers.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(71,'420 DENIER NYLON PACK CLOTH',NULL,0.5800,7.0000,'N420D',361,'11','16','7oz / 420 Denier Nylon Pack Cloth fabric with Urethane coating is light weight, very durable and water resistant. Great for bags and equipment covers.',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(72,'1000 DENIER NYLON',NULL,1.2500,10.0000,'N1000D',363,'11','16','1000 Denier Nylon',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(73,'GEO SCREEN MESH - FR',NULL,0.6000,7.0000,'MGSFR',400,'15','18','Used for containment of sandblasting, painting and construction debris and particles. Also allows for ventilation. Fire resistant. Heavy duty webbing around perimeter and at sewn seams (approx 10\'). #4 brass grommets spaced 24\" apart around perimeter and at seams. The seams run in the length dimension.',NULL,NULL,'444',NULL,1,0,NULL,NULL),(74,'GEO SCREEN MESH',NULL,0.4900,7.0000,'MGS',401,'11','18','Used for containment of sandblasting, painting and construction debris and particles. Also allows for ventilation. Heavy duty webbing around perimeter and at sewn seams (approx 10\'). #4 brass grommets spaced 24\" apart around perimeter and at seams. The seams run in the length dimension.',NULL,NULL,'444',NULL,1,0,NULL,NULL),(75,'AIRBAG CONTAINMENT TARPS - FR',NULL,0.4380,7.0000,'NACFR',410,'15','16','Used for containment of sandblasting, painting and construction debris and fine particles. Fire resistant. Heavy duty webbing sewn around perimeter and at sewn seams (approx 5\'-7\'). #4 brass grommets spaced 24\" apart around perimeter and at seams.\r\nThe color is White with a shade of Blue, Yellow or Pink. Seams run in the length dimension. Passes NFPA 701 fire retardant standards.',NULL,NULL,'444',NULL,1,0,NULL,NULL),(76,'22 OZ VLP WITH 30 MIL CLEAR PANEL (52” TALL), STARTING 30” UP FROM BOTTOM',NULL,1.5300,30.0000,'VLP22-30MIL-CLEAR',101,'12,16,20,22','13','This 22oz Vinyl Laminated Polyester curtain has a 52\" tall clear vinyl horizontal panel.  The panel starts 30\" up from the bottom and is made from our 30 Mil Clear Vinyl. The remaining curtain above the clear vinyl is made from the same 22oz Vinyl PVC and is the same color as the 30\" strip below the clear panel.',NULL,NULL,'29,258,362,462',NULL,1,0,NULL,NULL),(77,'16 OZ VINYL LAMINATED PVC - BLOCK OUT - FR',NULL,0.6700,16.0000,'VLP16-BLOCKOUT',140,'15','13','This reinforced vinyl pvc material is fire retardant, has high UV resistance, it is opaque and has a high gloss look. Great for tent walls, canopies, divider curtains, outdoor movie screens. Meets California Fire marshal F-121.2, NFPA-701 and ASTM-E-84, Class A.',NULL,NULL,'28,29',NULL,1,0,NULL,NULL),(78,'TOP GUN - ACRYLIC COATED POLYESTER',NULL,1.3400,11.5000,'TOPGUN',2,'11,15,10,12,16,20,21,23','1','Used for awnings, marine and outdoor projects. This 5 year warranty fabric is 11.5 oz per square yard. The fabric is a acrylic coated polyester. It is water resistant, mildew resistant and UV resistant and the seams are sewn.  Many colors available.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(79,'PERFORATED MESH - REINFORCED  PVC',NULL,2.6600,49.0000,'MESH10-AF',301,'11,15,17,18,10,19,13,41,20,21,22,23,24','18','Our perforated mesh is a heavy duty reinforced PVC Vinyl. This mesh material allows water to filter through, while keeping the pit clear from debris. The material is highly UV resistant, abrasion resistant and long lasting. These weighted covers have galvanized steel chain sewn in the perimeter.',NULL,NULL,'481',NULL,0,0,NULL,NULL),(80,'18 OZ REINFORCED VINYL COATED  PVC',NULL,2.5000,49.0000,'VINYL18PC-AF',302,'11,15,17,18,10,19,12,16,20,21,22,23,24','13','Our extreme-duty, 18oz reinforced PVC Vinyl is our longest lasting weighted tarp material. The material is highly UV resistant, abrasion resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'481',NULL,0,0,NULL,NULL),(81,'18 OZ REINFORCED VINYL PVC',NULL,0.6000,18.0000,'18VCP',602,'11,17,43','13','This is a perfect heavy duty vinyl choice for truck covers, equipment covers and most applications. UV resistant, waterproof, tear and abrasion resistant. ',NULL,NULL,'492',NULL,1,0,NULL,NULL),(82,'16 OZ REINFORCED VINYL PVC',NULL,0.5300,16.0000,'16VCP',603,'11,15,17,19,12,16,43,21,24,44,45,46,47','13','Great heavy duty PVC vinyl for machine covers, truck tarps and most applications. This gloss finish heavy duty vinyl comes in (14) colors. Perfect for the outdoors and is UV resistant.',NULL,NULL,'492',NULL,1,0,NULL,NULL),(83,'40 OZ REINFORCED VINYL PVC',NULL,0.3200,40.0000,'40VCP-JM',600,'11','13','This is our thickest and heaviest weight vinyl coated polyester material we offer. This vinyl is not as flexible as our thinner vinyls, but it is made for those high abrasion applications. Waterproof and UV resistant.',NULL,NULL,'678',NULL,1,0,NULL,NULL),(84,'14 OZ REINFORCED VINYL PVC',NULL,0.5600,14.0000,'14VLP-G',604,'11,17,10,19,12','13','This PVC vinyl is lighter than the other heavy duty vinyl\'s. Used for many outdoor tarps and covers. Waterproof, UV resistant, Fire Retardant, tear and abrasion resistant..',NULL,NULL,'493',NULL,1,0,NULL,NULL),(85,'10 OZ REINFORCED VINYL PVC',NULL,0.5100,10.0000,'10VCP',605,'11,15','13','This medium duty vinyl tarp is used for light weight truck tarps and other equipment covers. It is waterproof, UV resistant, tear and abrasion resistant.',NULL,NULL,'492',NULL,1,0,NULL,NULL),(86,'60% BLACK KNITTED POLYPRO SHADE MESH',NULL,0.3600,6.0000,'MKPP60',100,'11','18','Great for windscreens, fence screens, shade covers and truck covers. This 60% knitted polypropylene shade material is designed to allow airflow. This mesh fabric will finish approximate size, due to the directional instability of the fabric.',NULL,NULL,NULL,NULL,1,0,NULL,NULL),(87,'95% HURRICANE / TRAMPOLINE MESH',NULL,0.8000,9.0000,'PPM95H',25,'11','18','7.9 oz Woven polypropylene mesh. Used for barriers during hurricanes, trampoline mat covers and truck tarps. 20 Mils thickness.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(88,'18 OZ VINYL COATED PVC',NULL,1.2000,18.0000,'18VCPAF',700,'11,15,17,10,19,12,16,20,21,22,23,24','13','Our best selling reinforced vinyl coated polyester tarp material. Great for truck tarps, equipment covers and most applications. UV and tear / abrasion resistant. Waterproof.',NULL,NULL,'548,563',NULL,1,0,NULL,NULL),(89,'18 OZ REINFORCED VINYL PVC',NULL,0.5900,18.0000,'18VCP-G',805,'11,15,17,10,19,12,16,20,21','13','Our best selling (21 Mil) reinforced vinyl coated polyester tarp material. Great for truck tarps, equipment covers and most applications. UV and tear / abrasion resistant. Waterproof. (#4 grommets) Great heavy duty PVC vinyl for machine covers, truck tarps and most applications. This heavy duty vinyl comes in (9) colors. Perfect for the outdoors and is UV resistant.',NULL,NULL,'493,568,624',NULL,1,0,NULL,NULL),(90,'22 OZ REINFORCED VINYL PVC',NULL,0.7000,22.0000,'22VCP-G',806,'11,15,17,18,10,19,12','13','Most popular heavy duty vinyl material. 22oz Vinyl Coated Polyester - Heavy-Duty reinforced vinyl tarps, UV, tear and abrasion resistant. Waterproof. Great for truck tarps.',NULL,NULL,'493',NULL,1,0,NULL,NULL),(91,'18 OZ VINYL COATED PVC',NULL,0.7750,18.0000,'18VCP-JM',1100,'11,15,17,10,13,16,20,21,39','13','Our best selling (21 Mil) reinforced vinyl coated polyester tarp material. Great for truck tarps, equipment covers and most applications. UV and tear / abrasion resistant. Waterproof. (#4 SS grommets)',NULL,NULL,NULL,NULL,1,0,NULL,NULL),(92,'70% BLACK KNITTED POLYPRO SHADE MESH',NULL,0.4200,7.0000,'MKPP70',29,'11','18','Great for insect screen, windscreens, fence screening, shade covers, agriculture shade tarps and truck covers. This 70% knitted polypropylene material is designed to allow airflow and shading. This mesh fabric will finish approximate size, due to the directional instability of the fabric.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(93,'20 MIL CLEAR PVC VINYL - FR',NULL,0.9800,54.0000,'PVC20-FRB',180,'25','17','20 Mil thick Clear Fire Retardant Vinyl PVC. Great for clear curtains and tarps for porch enclosures.  For extreme cold weather use our 30 Mil Clear vinyl. Do not store when wet. The perimeter edge is cut and reinforced with 1 1/2\" wide Black webbing. ',NULL,NULL,'622',NULL,1,0,NULL,NULL),(94,'30 MIL CLEAR PVC VINYL - FR',NULL,1.5400,70.0000,'PVC30-FRB',181,'25','17','30 Mil thick Clear Fire Retardant Vinyl PVC. Great for clear curtains and tarps for porch enclosures. Do not store when wet. The perimeter is cut and reinforced with 1 1/2\" wide Black webbing. ',NULL,NULL,'622',NULL,1,0,NULL,NULL),(95,'#10 NATURAL COTTON CANVAS DUCK',NULL,0.5500,17.0000,'CDN10',9,'8','1','100% Natural Cotton Canvas Duck material. #10 Double Filled Cotton Duck Canvas - Weight 16 oz.',NULL,NULL,'28,30,31,139',NULL,1,0,NULL,NULL),(96,'SWIMMING POOL COVER POLYPROPYLENE MESH',NULL,0.5400,8.0000,'PPMSPC',28,'49','18','34x20 Woven polypropylene mesh construction. 4 oz mesh with a high tensile tear strength. Use for swimming pool covers, filter bags, truck covers. The fabric is heat set, stable and has a calendared finish. This fabric only comes with a Green / Black color pinstripe pattern.',NULL,NULL,'28',NULL,1,0,NULL,NULL),(97,'PERFORATED WEIGHTED MESH - REINFORCED  PVC',NULL,1.3700,49.0000,'MESH-CS',301,'11,15,17,18,10,19,13,41,20,21,22,23,24','18','Our perforated mesh is a heavy duty reinforced PVC Vinyl. This mesh material allows water to filter through, while keeping the pit clear from debris. The material is highly UV resistant, abrasion resistant and long lasting. These weighted covers have galvanized steel chain sewn in the perimeter.',NULL,NULL,'481',NULL,1,0,NULL,NULL),(98,'18 OZ REINFORCED VINYL PVC - WEIGHTED',NULL,1.9250,49.0000,'VINYL18-CS',301,'11,15,17,18,10,19,12,16,20,21,22,23,24','13','Our extreme-duty, 18oz reinforced PVC Vinyl is our longest lasting weighted tarp material. The material is highly UV resistant, abrasion resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'416',NULL,1,0,NULL,NULL),(99,'18 OZ REINFORCED VINYL COATED  PVC - WEIGHTED',NULL,1.7500,49.0000,'VINYL18PC-CS',302,'11,15,17,18,10,19,12,16,20,21,22,23,24','13','Our extreme-duty, 18oz reinforced PVC Vinyl is our longest lasting weighted tarp material. The material is highly UV resistant, abrasion resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'481',NULL,1,0,NULL,NULL),(100,'AIRBAG CONTAINMENT TARPS',NULL,0.4230,7.0000,'NAC',409,'15','16','Used for containment of sandblasting, painting and construction debris and fine particles. Heavy duty webbing sewn around perimeter and at sewn seams (approx 5\'-7\'). #4 brass grommets spaced 24\" apart around perimeter and at seams.\r\nThe color is White with a shade of Blue, Yellow or Pink. Seams run in the length dimension.',NULL,NULL,'444',NULL,1,0,NULL,NULL),(101,'NEOPRENE COATED NYLON - 40 OZ',NULL,3.9500,40.0000,'NCN40',91,'11','16','40oz Neoprene, waterproof, UV resistant, highly abrasion resistant and Oil and Chemical resistan',NULL,NULL,'28,29,30,31,139',NULL,1,0,NULL,NULL),(102,'18 OZ REINFORCED VINYL PVC - WEIGHTED',NULL,0.9160,49.0000,'VINYL18-M',301,'11,15,17,18,10,19,12,16,20,21,22,23,24','13','Our extreme-duty, 18oz reinforced PVC Vinyl is our longest lasting weighted tarp material. The material is highly UV resistant, abrasion resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'471',NULL,1,0,NULL,NULL),(103,'6.3 OZ REINFORCED POLY',NULL,0.4470,45.0000,'POLY6OZ-M',300,'32','14','Our heavy-duty 6.3oz / 12 mil reinforced woven poly, highly UV resistant and waterproof. These weighted tarps have galvanized steel chain sewn in the perimeter.',NULL,NULL,'471',NULL,1,0,NULL,NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2024_07_16_092533_create_permission_tables',1),(6,'2024_08_13_063420_create_pages_table',1),(7,'2024_09_13_122800_create_settings_table',1);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(3,'App\\Models\\User',3);

--
-- Table structure for table `mount_kit_types`
--

CREATE TABLE `mount_kit_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `mountkit_image` varchar(255) NOT NULL,
  `formula` text NOT NULL,
  `curtain_selection` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`curtain_selection`)),
  `sort_order` int(11) NOT NULL,
  `track_sku_8` varchar(255) DEFAULT NULL,
  `track_sku_6` varchar(255) DEFAULT NULL,
  `track_sku_4` varchar(255) DEFAULT NULL,
  `connector_sku` varchar(255) DEFAULT NULL,
  `endtop_sku` varchar(255) DEFAULT NULL,
  `nylon_trolley_sku` varchar(255) DEFAULT NULL,
  `steel_trolley_sku` varchar(255) DEFAULT NULL,
  `track_support_sku` varchar(255) DEFAULT NULL,
  `t_support_sku` varchar(255) DEFAULT NULL,
  `radius_corner` enum('enable','disable') NOT NULL DEFAULT 'disable',
  `radius_corner_sku` varchar(255) DEFAULT NULL,
  `radius_corner_label` varchar(255) DEFAULT NULL,
  `radius_corner_image` varchar(255) DEFAULT NULL,
  `hard_corner` enum('enable','disable') NOT NULL DEFAULT 'disable',
  `hard_corner_sku` varchar(255) DEFAULT NULL,
  `hard_corner_label` varchar(255) DEFAULT NULL,
  `hard_corner_image` varchar(255) DEFAULT NULL,
  `no_corner` enum('enable','disable') NOT NULL DEFAULT 'disable',
  `no_corner_sku` varchar(255) DEFAULT NULL,
  `no_corner_label` varchar(255) DEFAULT NULL,
  `no_corner_image` varchar(255) DEFAULT NULL,
  `additional_hardware` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_hardware`)),
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mount_kit_types`
--

INSERT INTO `mount_kit_types` VALUES (5,'Wall Mount Kit','uploads/CurtainImag/fa37yFPKjRFQ8EJPGkyFMc7fyMPZza1iSMHjcCk8.png','Wall Mounting Kit','10730724196545',3,'TRACK-K8','TRACK-K6','TRACK-K4','TRACK-K38','TRACK-K31A','TRACK-NR1','TRACK-SR1','TRACK-WM1U','TRACK-TM2','enable','TRACK-TM4','RADIUS CORNER','uploads/CurtainImag/5q9PFYTzXCMUYMiWBgRomj8h5zwvVqP64kYlrM7n.png','enable','TRACK-TM3','HARD CORNER','uploads/CurtainImag/Jmz0OnOD2K4rxlRtph6E4Sd8hd6DnayKYGUVGlXM.png','enable','NONE','NO CORNER','uploads/CurtainImag/vRbuCM1tSk5H12MpwmgZjooFF1MI8SBH78YNWOJV.png','10730812080321',0,1,'2025-05-07 20:01:55','2025-05-07 20:01:55'),(6,'Threaded Rod Kit','uploads/CurtainImag/ZI5fcwpmUKgTgJP3YZzSjT81yhj5AW1b5SAkMjer.png','Threaded-Rod-Kit','10730724196545',2,'TRACK-K8','TRACK-K6','TRACK-K4','TRACK-K38','TRACK-K31A','TRACK-NR1','TRACK-SR1','TRACK-TM1','TRACK-TM2','enable','TRACK-TM4','RADIUS CORNER','uploads/CurtainImag/kuBsrTHbNnkWCv7eIJxqW89aHQjYRvn75w2PsREa.png','enable','TRACK-TM3','HARD CORNER','uploads/CurtainImag/bUGGM4XITY2BGxMAuo8rM4AlzSzjgUipq3dMqzPz.png','enable','NONE','NO CORNER','uploads/CurtainImag/k3O2vDRJDoK5dO50ODML2K7aW0eCyc0B1OqHNoxU.png','10730812080321',0,1,'2025-05-08 21:09:37','2025-05-08 21:09:37'),(7,'Ceiling Mount Kit','uploads/CurtainImag/ilGn3ywX6Lmha26DLWTdxNScZAewRa8ubNeBLWVi.png','Ceiling Mount Kit','10730724196545',1,'TRACK-K8','TRACK-K6','TRACK-K4','TRACK-K38','TRACK-K31A','TRACK-NR1','TRACK-SR1','TRACK-CM1','TRACK-CM3','enable','TRACK-CM4','RADIUS CORNER','uploads/CurtainImag/dHKyrwm1SMfIAmzxfAc0qXTZchnuJ7RuUhXnggql.png','enable','TRACK-CM2','HARD CORNER','uploads/CurtainImag/gfdTcYDPdJqJvUCm04LrFWx09fg1ZzgLUnPU3OW6.png','enable','NONE','NO CORNER','uploads/CurtainImag/UUdMiaKnUMalmYfxMc7O0LjqCNPTIh2pEIWpelq1.png','10730812080321',0,1,'2025-05-08 21:12:51','2025-05-20 22:27:03'),(8,'Beam Mounting Kit','uploads/CurtainImag/6torJOTtpyF7Bw4AcWF41BkzjJsLUUP9xWhB6DOr.jpg','Beam Mounting Kit','10730724196545',5,'TRACK-K8','TRACK-K6','TRACK-K4','TRACK-K38','TRACK-K31A','TRACK-NR1','TRACK-SR1','TRACK-BM1','TRACK-CM3','enable','TRACK-CM4','RADIUS CORNER','uploads/CurtainImag/ptnNj6WAd283xTvpqIT5ZtratXlEcRLC6Uo3dSv2.png','enable','TRACK-CM2','HARD CORNER','uploads/CurtainImag/ZYN3f0srjSbX8TWAcchfGCh0ifBxnCdMJgrwrCl9.png','enable','NONE','NO CORNER','uploads/CurtainImag/qPgEetBNs9QvWnMdujba2p1HpVB9NQDiqVG4YN7V.png','10730812080321',0,1,'2025-05-08 21:15:44','2025-05-08 21:15:44'),(9,'Chain Mounting Kit','uploads/CurtainImag/ZqRyd1Bjk2diyFN1e5NHvgEdla5Fd5pAgD4E8Kzb.png','Chain Mounting Kit','10730724196545',4,'TRACK-K8','TRACK-K6','TRACK-K4','TRACK-K38','TRACK-K31A','TRACK-NR1','TRACK-SR1','TRACK-CHM1','TRACK-TM2','enable','TRACK-CHM4','RADIUS CORNER','uploads/CurtainImag/U1wlO7zqkMesgimHbmXKEDIO7PdFKJqT3FkiURV8.png','enable','TRACK-CHM3','HARD CORNER','uploads/CurtainImag/wduzTFS8pNkepbJJWR4ZMQMqIqGxibsUyvqYRFTw.png','enable','NONE','NO CORNER','uploads/CurtainImag/KKXv8wU9Q2ALXrb0D5Er3Cyg4Q4MbARxil9lHgaQ.png','10730812080321',0,1,'2025-05-08 21:18:47','2025-05-08 21:18:47');

--
-- Table structure for table `note`
--

CREATE TABLE `note` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `tarp_selection` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tarp_selection`)),
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `note`
--

INSERT INTO `note` VALUES (1,'Made In USA','10730724196545',0,0,'2025-05-07 23:19:14','2025-05-20 21:48:12'),(2,'These Curtains are custom made and typically ship within 2-3 weeks.','10730724196545',2,0,'2025-05-07 23:19:28','2025-05-07 23:19:28'),(3,'If you do not see the option you want, please email us for a quote.','10730724196545',4,0,'2025-05-07 23:19:35','2025-05-07 23:19:35'),(4,'These custom and special orders are not returnable, but any defective parts will be repaired or replaced.','10730724196545',6,0,'2025-05-07 23:19:46','2025-05-07 23:19:46'),(5,'All custom curtains have a tolerance of (+/-) 2\" for all dimensions.','10730724196545',8,0,'2025-05-07 23:19:57','2025-05-07 23:19:57'),(6,'Due to different dye lots, colors may not match from tarp to tarp or curtain to curtain.','10730724196545',10,0,'2025-05-07 23:20:13','2025-05-07 23:20:13'),(7,'All Tarps, Curtains and Covers will have heat welded or sewn seams, depending on which type of fabric is used. Seams may be vertical / horizontal or both. Seams will range from every 36\" to 72\" depending upon the actual width of the fabric.','10730724196545',12,0,'2025-05-07 23:20:23','2025-05-07 23:20:23'),(8,'Clear Vinyl tarps, curtains and covers do shrink in cold weather.','10730724196545',14,0,'2025-05-07 23:21:15','2025-05-07 23:21:15'),(9,'The curtain builder, will automatically deduct 3\" in the curtain height, to accommodate for the track and rollers.','10730724196545',16,0,'2025-05-07 23:21:26','2025-05-07 23:21:26'),(10,'For proper drape of the curtains, 5-7% has been automatically added to the width of each curtain.','10730724196545',18,0,'2025-05-07 23:21:37','2025-05-07 23:21:37'),(11,'The actual product color may vary from the color shown on the screen.','10730724196545',20,0,'2025-05-07 23:21:46','2025-05-07 23:21:46'),(12,'The default option for the bottom hem of the curtain is the 4\" open pocket.','10730724196545',22,0,'2025-05-07 23:21:56','2025-05-07 23:21:56'),(13,'The top of the curtain will have grommets spaced approx. 12\" apart.','10730724196545',24,0,'2025-05-07 23:22:05','2025-05-07 23:22:05'),(14,'For the \"L-Shape\", \"C-Shape\" and \"Enclosure\" curtains, the curtains will be joined together in the corners with velcro. The non-joining side of the curtains will have 24\" approx. spacing as the default option.','10730724196545',26,0,'2025-05-07 23:22:14','2025-05-07 23:22:14'),(15,'For the \"Straight\" and \"T-Shape\" curtains, both edges will have grommets spaced approx. 24\" apart as the default option.','10730724196545',28,0,'2025-05-07 23:22:28','2025-05-07 23:22:28'),(16,'If the chain bottom is chosen, the default 4\" open pocket will be removed from the curtain.','10730724196545',30,0,'2025-05-07 23:22:40','2025-05-07 23:22:40');

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `information` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `unit` enum('SQ','PR','LN','EA') NOT NULL,
  `cost` decimal(10,4) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `min_charge` decimal(10,4) NOT NULL,
  `weight` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `tarp_selection` text DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` VALUES (1,'2\" Male Velcro (Black) around perimeter (no grommets)',NULL,NULL,'PR',0.4000,1.0000,15.0000,5.0000,2,'0','28,139',0,NULL,NULL),(2,'Chain in bottom pocket for weight (the 4\" pocket is removed and a chain is sewn in bottom hem)',NULL,NULL,'LN',1.5000,3.5000,15.0000,16.0000,5,'0','140,362,462,486',0,NULL,NULL),(3,'Nickel turn fasteners',NULL,NULL,'EA',1.0000,2.5000,15.0000,6.0000,6,'0','28,29',0,NULL,NULL),(4,'Reinforced webbing sewn in perimeter hem for grommets',NULL,NULL,'SQ',0.0000,0.2000,5.0000,1.0000,1,'1','10711373381825,10728396914881',0,NULL,'2025-05-19 16:03:11'),(5,'\"D\" Rings at approx 24\" around perimeter',NULL,NULL,'PR',0.3500,1.0000,15.0000,11.0000,8,'0','28',0,NULL,NULL),(6,'\"D\" Rings at approx 12\" around perimeter',NULL,NULL,'PR',0.4500,1.5000,15.0000,22.0000,9,'0','28',0,NULL,NULL),(7,'2\" Female Velcro (Black) down back sides of curtain (adhesive mate velcro included) (no grommets)',NULL,NULL,'PR',0.2000,1.5000,15.0000,2.0000,10,'0','29,258',0,NULL,NULL),(9,'2\" Female Velcro (Black) around perimeter (no grommets)(adhesive mate velcro included)',NULL,NULL,'PR',0.4000,1.0000,15.0000,2.0000,2,'0','28,139',0,NULL,NULL),(10,'6\" Dust Flap Along Bottom',NULL,NULL,'LN',0.5000,2.0000,10.0000,2.0000,11,'0','29',0,NULL,NULL),(11,'Handle - 2\" Seat belt webbing, 6\" wide opening with a 3\" tall loop, centered in top of cover.','Handle - 2\" Seat belt webbing, 6\" wide opening with a 3\" tall loop, centered in top of cover.',NULL,'EA',5.0000,0.0000,25.0000,0.0000,15,'1','10711373381825,10728396914881',0,NULL,'2025-06-05 18:43:02'),(12,'UNIVERSAL STRIP DOOR HARDWARE (CEILING OR WALL MOUNT)',NULL,NULL,'LN',5.2500,9.2500,30.0000,25.0000,501,'0','10711373381825,10728396914881',0,NULL,'2025-06-05 16:00:25'),(13,'NO MOUNTING TRACK',NULL,NULL,'LN',0.0000,0.0000,0.0000,0.0000,500,'0','10711373381825,10728396914881',0,NULL,'2025-06-05 16:00:45'),(14,'12\" overlaps on all (4) sides with grommets spaced @ 24\" apart to join tarps together.',NULL,NULL,'SQ',0.0000,0.1000,25.0000,0.0000,401,'1','10711373381825,10728396914881',0,NULL,'2025-05-18 02:16:42'),(15,'Grommets spaced approximately 12\" along bottom','Features grommets in all four corners only for simple, minimal tie-down points. Ideal for light to moderate coverage needs perfect for short-term outdoor use, equipment cover, or DIY projects where full edge grommets aren\'t necessary.','uploads/option_images/68345745bc60e.webp,uploads/option_images/68345745bc697.webp','LN',0.0000,0.0000,0.0000,0.0000,101,'1','10711373381825,10728396914881',0,NULL,'2025-05-26 21:57:57'),(16,'4\" Pocket along bottom (open at both ends)',NULL,NULL,'LN',1.1000,2.2000,0.0000,0.0000,102,'1','29,140,258,362,462,486',0,NULL,NULL),(17,'Weighted chain sewn in bottom of curtain',NULL,NULL,'LN',2.0000,4.0000,20.0000,16.0000,103,'1','29,140,258,362,462,486',0,NULL,NULL),(18,'test',NULL,NULL,'PR',3.4400,4.4400,5.4400,6.4400,4,'1','2,3',1,'2025-05-13 17:12:35','2025-05-13 17:13:58');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` text DEFAULT NULL,
  `page_title` text DEFAULT NULL,
  `page_url` text DEFAULT NULL,
  `page_description` text DEFAULT NULL,
  `meta_title` text DEFAULT NULL,
  `meta_keys` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `is_deletable` tinyint(1) NOT NULL DEFAULT 1,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `updated_by` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Home','Welcome to Our Website','/','This is the homepage of our website. Welcome!','Home | My Website','home, welcome, homepage','Welcome to the homepage of My Website, where you can find all the latest updates and information.',0,'Active',1,'2024-09-25 23:10:04','2024-09-25 23:10:04'),(6,NULL,'Test','test','<p>test</p>',NULL,NULL,NULL,1,'Active',8,'2025-03-19 02:34:21','2025-03-19 02:34:21');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `group` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'Create Page','web','Page','2024-09-25 23:09:56','2024-09-25 23:09:56'),(2,'Edit Page','web','Page','2024-09-25 23:09:56','2024-09-25 23:09:56'),(3,'View Page','web','Page','2024-09-25 23:09:56','2024-09-25 23:09:56'),(4,'Delete Page','web','Page','2024-09-25 23:09:56','2024-09-25 23:09:56'),(5,'Edit Setting','web','Setting','2024-09-25 23:09:56','2024-09-25 23:09:56'),(6,'View Setting','web','Setting','2024-09-25 23:09:56','2024-09-25 23:09:56');

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

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

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

INSERT INTO `role_has_permissions` VALUES (1,1),(1,2),(1,3),(2,1),(2,3),(3,1),(3,2),(3,3),(4,1),(5,1),(5,2),(6,1);

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

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

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

INSERT INTO `roles` VALUES (1,'Super Admin',NULL,'web','2024-09-25 23:09:56','2024-09-25 23:09:56'),(2,'Page','Testing','web','2024-09-25 23:13:41','2025-03-19 04:28:56'),(3,'QA_Test',NULL,'web','2024-09-26 17:04:31','2024-09-26 17:04:31');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `tarpsmapping`
--

CREATE TABLE `tarpsmapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tarps_id` bigint(20) NOT NULL COMMENT 'Tarps id',
  `material_id` int(20) NOT NULL COMMENT 'Material Id',
  `cost_sqrt` decimal(12,4) DEFAULT NULL COMMENT 'Cost sqrt',
  `price_sqrt` decimal(12,4) DEFAULT NULL COMMENT 'Price sqrt',
  `free_shipping_status` smallint(6) DEFAULT 0 COMMENT 'Free Shipping Status	',
  `selected_discount` text DEFAULT NULL COMMENT 'Selected Discount',
  `sort_order` smallint(6) DEFAULT NULL COMMENT 'Sort Order',
  `sku_prefix` varchar(255) DEFAULT NULL COMMENT 'Sku Prefix',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='tarpsmapping';

--
-- Dumping data for table `tarpsmapping`
--

INSERT INTO `tarpsmapping` VALUES (1,10728396914881,56,2.0000,1.8000,0,NULL,0,NULL,'2025-06-12 20:26:58','2025-06-05 15:20:07'),(2,10728396914881,13,2.0000,2.1700,0,'1,2,3,4',21,NULL,'2025-06-10 20:25:48','2025-06-05 15:20:07'),(3,10728396914881,5,NULL,NULL,0,NULL,32,NULL,'2025-06-05 15:20:07','2025-06-05 15:20:07');


