(1628,'GPU','AMD Radeon RX 580 8GB',104.09,NULL,NULL,'3.0',500,'Used','eBay','SRC1628','https://vendor.com/images/1628.jpg','https://vendor.com/product/1628','2025-12-09 18:03:28'),(1629,'GPU','AMD Radeon RX 5500 XT 8GB',131.61,NULL,NULL,'4.0',450,'Refurbished','Microsoft','SRC1629','https://vendor.com/images/1629.jpg','https://vendor.com/product/1629','2025-12-09 18:03:28'),(1630,'GPU','AMD Radeon RX 580 8GB',182.65,NULL,NULL,'3.0',500,'Refurbished','Amazon','SRC1630','https://vendor.com/images/1630.jpg','https://vendor.com/product/1630','2025-12-09 18:03:28'),(1631,'GPU','NVIDIA GTX 1650 4GB',109.42,NULL,NULL,'3.0',300,'New','Newegg','SRC1631','https://vendor.com/images/1631.jpg','https://vendor.com/product/1631','2025-12-09 18:03:28'),(1632,'GPU','AMD Radeon RX 5500 XT 8GB',80.48,NULL,NULL,'4.0',450,'Refurbished','Microsoft','SRC1632','https://vendor.com/images/1632.jpg','https://vendor.com/product/1632','2025-12-09 18:03:28'),(1633,'GPU','NVIDIA GTX 1660 Super 6GB',186.87,NULL,NULL,'3.0',450,'Refurbished','Microsoft','SRC1633','https://vendor.com/images/1633.jpg','https://vendor.com/product/1633','2025-12-09 18:03:28'),(1634,'GPU','NVIDIA GTX 1660 Super 6GB',98.90,NULL,NULL,'3.0',450,'Refurbished','Newegg','SRC1634','https://vendor.com/images/1634.jpg','https://vendor.com/product/1634','2025-12-09 18:03:28'),(1635,'GPU','AMD Radeon RX 580 8GB',196.14,NULL,NULL,'3.0',500,'Refurbished','eBay','SRC1635','https://vendor.com/images/1635.jpg','https://vendor.com/product/1635','2025-12-09 18:03:28'),(1636,'GPU','NVIDIA GTX 1660 Super 6GB',176.31,NULL,NULL,'3.0',450,'New','Newegg','SRC1636','https://vendor.com/images/1636.jpg','https://vendor.com/product/1636','2025-12-09 18:03:28'),(1637,'GPU','NVIDIA GTX 1660 Super 6GB',114.12,NULL,NULL,'3.0',450,'Refurbished','Amazon','SRC1637','https://vendor.com/images/1637.jpg','https://vendor.com/product/1637','2025-12-09 18:03:28'),(1638,'GPU','AMD Radeon RX 5500 XT 8GB',135.82,NULL,NULL,'4.0',450,'Used','Amazon','SRC1638','https://vendor.com/images/1638.jpg','https://vendor.com/product/1638','2025-12-09 18:03:28'),(1639,'GPU','AMD Radeon RX 5500 XT 8GB',97.95,NULL,NULL,'4.0',450,'Refurbished','Amazon','SRC1639','https://vendor.com/images/1639.jpg','https://vendor.com/product/1639','2025-12-09 18:03:28'),(1640,'GPU','AMD Radeon RX 580 8GB',147.38,NULL,NULL,'3.0',500,'New','eBay','SRC1640','https://vendor.com/images/1640.jpg','https://vendor.com/product/1640','2025-12-09 18:03:28'),(1641,'GPU','NVIDIA GTX 1650 4GB',146.43,NULL,NULL,'3.0',300,'New','Microsoft','SRC1641','https://vendor.com/images/1641.jpg','https://vendor.com/product/1641','2025-12-09 18:03:28'),(1642,'GPU','AMD Radeon RX 5500 XT 8GB',151.21,NULL,NULL,'4.0',450,'Used','Microsoft','SRC1642','https://vendor.com/images/1642.jpg','https://vendor.com/product/1642','2025-12-09 18:03:28'),(1643,'GPU','AMD Radeon RX 580 8GB',199.33,NULL,NULL,'3.0',500,'Refurbished','eBay','SRC1643','https://vendor.com/images/1643.jpg','https://vendor.com/product/1643','2025-12-09 18:03:28'),(1644,'GPU','NVIDIA GTX 1650 4GB',140.95,NULL,NULL,'3.0',300,'Refurbished','Newegg','SRC1644','https://vendor.com/images/1644.jpg','https://vendor.com/product/1644','2025-12-09 18:03:29'),(1645,'GPU','NVIDIA GTX 1650 4GB',137.57,NULL,NULL,'3.0',300,'Used','Newegg','SRC1645','https://vendor.com/images/1645.jpg','https://vendor.com/product/1645','2025-12-09 18:03:29'),(1646,'GPU','AMD Radeon RX 580 8GB',198.58,NULL,NULL,'3.0',500,'New','eBay','SRC1646','https://vendor.com/images/1646.jpg','https://vendor.com/product/1646','2025-12-09 18:03:29'),(1647,'GPU','NVIDIA GTX 1660 Super 6GB',132.69,NULL,NULL,'3.0',450,'New','Newegg','SRC1647','https://vendor.com/images/1647.jpg','https://vendor.com/product/1647','2025-12-09 18:03:29'),(1648,'GPU','AMD Radeon RX 5500 XT 8GB',192.59,NULL,NULL,'4.0',450,'New','Newegg','SRC1648','https://vendor.com/images/1648.jpg','https://vendor.com/product/1648','2025-12-09 18:03:29'),(1649,'GPU','NVIDIA GTX 1660 Super 6GB',84.78,NULL,NULL,'3.0',450,'Refurbished','Amazon','SRC1649','https://vendor.com/images/1649.jpg','https://vendor.com/product/1649','2025-12-09 18:03:29'),(1650,'GPU','NVIDIA GTX 1650 4GB',102.18,NULL,NULL,'3.0',300,'New','Amazon','SRC1650','https://vendor.com/images/1650.jpg','https://vendor.com/product/1650','2025-12-09 18:03:29'),(1651,'GPU','AMD Radeon RX 5500 XT 8GB',116.11,NULL,NULL,'4.0',450,'Used','Newegg','SRC1651','https://vendor.com/images/1651.jpg','https://vendor.com/product/1651','2025-12-09 18:03:29'),(1652,'GPU','AMD Radeon RX 5500 XT 8GB',146.77,NULL,NULL,'4.0',450,'Refurbished','Amazon','SRC1652','https://vendor.com/images/1652.jpg','https://vendor.com/product/1652','2025-12-09 18:03:29'),(1653,'GPU','NVIDIA GTX 1650 4GB',132.47,NULL,NULL,'3.0',300,'Used','Amazon','SRC1653','https://vendor.com/images/1653.jpg','https://vendor.com/product/1653','2025-12-09 18:03:29'),(1654,'GPU','NVIDIA GTX 1650 4GB',94.45,NULL,NULL,'3.0',300,'Used','eBay','SRC1654','https://vendor.com/images/1654.jpg','https://vendor.com/product/1654','2025-12-09 18:03:29'),(1655,'GPU','NVIDIA GTX 1650 4GB',170.42,NULL,NULL,'3.0',300,'Refurbished','Microsoft','SRC1655','https://vendor.com/images/1655.jpg','https://vendor.com/product/1655','2025-12-09 18:03:29'),(1656,'GPU','NVIDIA GTX 1660 Super 6GB',99.19,NULL,NULL,'3.0',450,'Used','Amazon','SRC1656','https://vendor.com/images/1656.jpg','https://vendor.com/product/1656','2025-12-09 18:03:29'),(1657,'GPU','NVIDIA GTX 1660 Super 6GB',167.81,NULL,NULL,'3.0',450,'Used','eBay','SRC1657','https://vendor.com/images/1657.jpg','https://vendor.com/product/1657','2025-12-09 18:03:29'),(1658,'GPU','NVIDIA GTX 1650 4GB',167.55,NULL,NULL,'3.0',300,'New','eBay','SRC1658','https://vendor.com/images/1658.jpg','https://vendor.com/product/1658','2025-12-09 18:03:29'),(1659,'GPU','AMD Radeon RX 580 8GB',86.50,NULL,NULL,'3.0',500,'Used','Newegg','SRC1659','https://vendor.com/images/1659.jpg','https://vendor.com/product/1659','2025-12-09 18:03:29'),(1660,'GPU','AMD Radeon RX 5500 XT 8GB',164.06,NULL,NULL,'4.0',450,'New','Amazon','SRC1660','https://vendor.com/images/1660.jpg','https://vendor.com/product/1660','2025-12-09 18:03:29'),(1661,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',25.38,NULL,'DDR4',NULL,NULL,'New','Microsoft','SRC1661','https://vendor.com/images/1661.jpg','https://vendor.com/product/1661','2025-12-09 18:03:30'),(1662,'RAM','TeamGroup Elite 16GB DDR4-3200',29.60,NULL,'DDR4',NULL,NULL,'Used','Newegg','SRC1662','https://vendor.com/images/1662.jpg','https://vendor.com/product/1662','2025-12-09 18:03:30'),(1663,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',59.08,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1663','https://vendor.com/images/1663.jpg','https://vendor.com/product/1663','2025-12-09 18:03:30'),(1664,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',33.70,NULL,'DDR4',NULL,NULL,'Used','Newegg','SRC1664','https://vendor.com/images/1664.jpg','https://vendor.com/product/1664','2025-12-09 18:03:30'),(1665,'RAM','TeamGroup Elite 16GB DDR4-3200',55.71,NULL,'DDR4',NULL,NULL,'Used','Microsoft','SRC1665','https://vendor.com/images/1665.jpg','https://vendor.com/product/1665','2025-12-09 18:03:30'),(1666,'RAM','TeamGroup Elite 16GB DDR4-3200',47.84,NULL,'DDR4',NULL,NULL,'New','Microsoft','SRC1666','https://vendor.com/images/1666.jpg','https://vendor.com/product/1666','2025-12-09 18:03:30'),(1667,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',54.99,NULL,'DDR4',NULL,NULL,'New','Newegg','SRC1667','https://vendor.com/images/1667.jpg','https://vendor.com/product/1667','2025-12-09 18:03:30'),(1668,'RAM','TeamGroup Elite 16GB DDR4-3200',44.94,NULL,'DDR4',NULL,NULL,'New','Amazon','SRC1668','https://vendor.com/images/1668.jpg','https://vendor.com/product/1668','2025-12-09 18:03:30'),(1669,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',53.79,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1669','https://vendor.com/images/1669.jpg','https://vendor.com/product/1669','2025-12-09 18:03:30'),(1670,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',51.74,NULL,'DDR4',NULL,NULL,'Used','Microsoft','SRC1670','https://vendor.com/images/1670.jpg','https://vendor.com/product/1670','2025-12-09 18:03:30'),(1671,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',46.75,NULL,'DDR4',NULL,NULL,'Refurbished','Newegg','SRC1671','https://vendor.com/images/1671.jpg','https://vendor.com/product/1671','2025-12-09 18:03:30'),(1672,'RAM','TeamGroup Elite 16GB DDR4-3200',21.83,NULL,'DDR4',NULL,NULL,'Refurbished','eBay','SRC1672','https://vendor.com/images/1672.jpg','https://vendor.com/product/1672','2025-12-09 18:03:30'),(1673,'RAM','TeamGroup Elite 16GB DDR4-3200',40.94,NULL,'DDR4',NULL,NULL,'Used','Newegg','SRC1673','https://vendor.com/images/1673.jpg','https://vendor.com/product/1673','2025-12-09 18:03:30'),(1674,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',22.94,NULL,'DDR4',NULL,NULL,'New','Amazon','SRC1674','https://vendor.com/images/1674.jpg','https://vendor.com/product/1674','2025-12-09 18:03:30'),(1675,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',35.68,NULL,'DDR4',NULL,NULL,'Used','eBay','SRC1675','https://vendor.com/images/1675.jpg','https://vendor.com/product/1675','2025-12-09 18:03:30'),(1676,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',23.69,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1676','https://vendor.com/images/1676.jpg','https://vendor.com/product/1676','2025-12-09 18:03:31'),(1677,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',44.95,NULL,'DDR4',NULL,NULL,'Refurbished','Newegg','SRC1677','https://vendor.com/images/1677.jpg','https://vendor.com/product/1677','2025-12-09 18:03:31'),(1678,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',31.93,NULL,'DDR4',NULL,NULL,'Used','eBay','SRC1678','https://vendor.com/images/1678.jpg','https://vendor.com/product/1678','2025-12-09 18:03:31'),(1679,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',57.91,NULL,'DDR4',NULL,NULL,'Refurbished','Amazon','SRC1679','https://vendor.com/images/1679.jpg','https://vendor.com/product/1679','2025-12-09 18:03:31'),(1680,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',59.25,NULL,'DDR4',NULL,NULL,'New','Newegg','SRC1680','https://vendor.com/images/1680.jpg','https://vendor.com/product/1680','2025-12-09 18:03:31'),(1681,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',20.91,NULL,'DDR4',NULL,NULL,'Refurbished','Amazon','SRC1681','https://vendor.com/images/1681.jpg','https://vendor.com/product/1681','2025-12-09 18:03:31'),(1682,'RAM','TeamGroup Elite 16GB DDR4-3200',54.68,NULL,'DDR4',NULL,NULL,'New','Amazon','SRC1682','https://vendor.com/images/1682.jpg','https://vendor.com/product/1682','2025-12-09 18:03:31'),(1683,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',31.03,NULL,'DDR4',NULL,NULL,'Refurbished','eBay','SRC1683','https://vendor.com/images/1683.jpg','https://vendor.com/product/1683','2025-12-09 18:03:31'),(1684,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',20.49,NULL,'DDR4',NULL,NULL,'Used','Amazon','SRC1684','https://vendor.com/images/1684.jpg','https://vendor.com/product/1684','2025-12-09 18:03:31'),(1685,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',58.70,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1685','https://vendor.com/images/1685.jpg','https://vendor.com/product/1685','2025-12-09 18:03:31'),(1686,'RAM','TeamGroup Elite 16GB DDR4-3200',50.91,NULL,'DDR4',NULL,NULL,'Used','Microsoft','SRC1686','https://vendor.com/images/1686.jpg','https://vendor.com/product/1686','2025-12-09 18:03:31'),(1687,'RAM','TeamGroup Elite 16GB DDR4-3200',23.76,NULL,'DDR4',NULL,NULL,'Refurbished','eBay','SRC1687','https://vendor.com/images/1687.jpg','https://vendor.com/product/1687','2025-12-09 18:03:31'),(1688,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',24.15,NULL,'DDR4',NULL,NULL,'Refurbished','eBay','SRC1688','https://vendor.com/images/1688.jpg','https://vendor.com/product/1688','2025-12-09 18:03:31'),(1689,'RAM','TeamGroup Elite 16GB DDR4-3200',53.03,NULL,'DDR4',NULL,NULL,'Used','Amazon','SRC1689','https://vendor.com/images/1689.jpg','https://vendor.com/product/1689','2025-12-09 18:03:31'),(1690,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',24.77,NULL,'DDR4',NULL,NULL,'Used','eBay','SRC1690','https://vendor.com/images/1690.jpg','https://vendor.com/product/1690','2025-12-09 18:03:31'),(1691,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',30.86,NULL,'DDR4',NULL,NULL,'Used','eBay','SRC1691','https://vendor.com/images/1691.jpg','https://vendor.com/product/1691','2025-12-09 18:03:31'),(1692,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',36.33,NULL,'DDR4',NULL,NULL,'New','Microsoft','SRC1692','https://vendor.com/images/1692.jpg','https://vendor.com/product/1692','2025-12-09 18:03:32'),(1693,'RAM','TeamGroup Elite 16GB DDR4-3200',55.46,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1693','https://vendor.com/images/1693.jpg','https://vendor.com/product/1693','2025-12-09 18:03:32'),(1694,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',34.07,NULL,'DDR4',NULL,NULL,'Refurbished','Newegg','SRC1694','https://vendor.com/images/1694.jpg','https://vendor.com/product/1694','2025-12-09 18:03:32'),(1695,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',20.97,NULL,'DDR4',NULL,NULL,'Used','Microsoft','SRC1695','https://vendor.com/images/1695.jpg','https://vendor.com/product/1695','2025-12-09 18:03:32'),(1696,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',30.30,NULL,'DDR4',NULL,NULL,'Refurbished','Amazon','SRC1696','https://vendor.com/images/1696.jpg','https://vendor.com/product/1696','2025-12-09 18:03:32'),(1697,'RAM','TeamGroup Elite 16GB DDR4-3200',44.34,NULL,'DDR4',NULL,NULL,'New','eBay','SRC1697','https://vendor.com/images/1697.jpg','https://vendor.com/product/1697','2025-12-09 18:03:32'),(1698,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',30.47,NULL,'DDR4',NULL,NULL,'New','Microsoft','SRC1698','https://vendor.com/images/1698.jpg','https://vendor.com/product/1698','2025-12-09 18:03:32'),(1699,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',58.75,NULL,'DDR4',NULL,NULL,'Refurbished','Newegg','SRC1699','https://vendor.com/images/1699.jpg','https://vendor.com/product/1699','2025-12-09 18:03:32'),(1700,'RAM','TeamGroup Elite 16GB DDR4-3200',54.63,NULL,'DDR4',NULL,NULL,'Refurbished','Amazon','SRC1700','https://vendor.com/images/1700.jpg','https://vendor.com/product/1700','2025-12-09 18:03:32'),(1701,'RAM','G.SKILL Ripjaws V 16GB DDR4-3200',28.46,NULL,'DDR4',NULL,NULL,'Used','Newegg','SRC1701','https://vendor.com/images/1701.jpg','https://vendor.com/product/1701','2025-12-09 18:03:32'),(1702,'RAM','TeamGroup Elite 16GB DDR4-3200',50.85,NULL,'DDR4',NULL,NULL,'Refurbished','Amazon','SRC1702','https://vendor.com/images/1702.jpg','https://vendor.com/product/1702','2025-12-09 18:03:32'),(1703,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',41.38,NULL,'DDR4',NULL,NULL,'Refurbished','Microsoft','SRC1703','https://vendor.com/images/1703.jpg','https://vendor.com/product/1703','2025-12-09 18:03:32'),(1704,'RAM','TeamGroup Elite 16GB DDR4-3200',31.77,NULL,'DDR4',NULL,NULL,'Refurbished','eBay','SRC1704','https://vendor.com/images/1704.jpg','https://vendor.com/product/1704','2025-12-09 18:03:32'),(1705,'RAM','Corsair Vengeance LPX 8GB DDR4-3200',28.97,NULL,'DDR4',NULL,NULL,'Used','Microsoft','SRC1705','https://vendor.com/images/1705.jpg','https://vendor.com/product/1705','2025-12-09 18:03:32'),(1706,'Storage','TeamGroup MP33 512GB NVMe SSD',33.30,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1706','https://vendor.com/images/1706.jpg','https://vendor.com/product/1706','2025-12-09 18:03:32'),(1707,'Storage','Kingston A400 480GB SATA SSD',49.88,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1707','https://vendor.com/images/1707.jpg','https://vendor.com/product/1707','2025-12-09 18:03:33'),(1708,'Storage','Kingston A400 480GB SATA SSD',29.93,NULL,NULL,NULL,NULL,'New','Amazon','SRC1708','https://vendor.com/images/1708.jpg','https://vendor.com/product/1708','2025-12-09 18:03:33'),(1709,'Storage','Crucial BX500 480GB SATA SSD',49.56,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1709','https://vendor.com/images/1709.jpg','https://vendor.com/product/1709','2025-12-09 18:03:33'),(1710,'Storage','Crucial BX500 480GB SATA SSD',37.72,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1710','https://vendor.com/images/1710.jpg','https://vendor.com/product/1710','2025-12-09 18:03:33'),(1711,'Storage','TeamGroup MP33 512GB NVMe SSD',21.06,NULL,NULL,NULL,NULL,'New','Newegg','SRC1711','https://vendor.com/images/1711.jpg','https://vendor.com/product/1711','2025-12-09 18:03:33'),(1712,'Storage','Crucial BX500 480GB SATA SSD',43.62,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1712','https://vendor.com/images/1712.jpg','https://vendor.com/product/1712','2025-12-09 18:03:33'),(1713,'Storage','TeamGroup MP33 512GB NVMe SSD',49.70,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1713','https://vendor.com/images/1713.jpg','https://vendor.com/product/1713','2025-12-09 18:03:33'),(1714,'Storage','TeamGroup MP33 512GB NVMe SSD',22.85,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1714','https://vendor.com/images/1714.jpg','https://vendor.com/product/1714','2025-12-09 18:03:33'),(1715,'Storage','Kingston A400 480GB SATA SSD',46.76,NULL,NULL,NULL,NULL,'New','eBay','SRC1715','https://vendor.com/images/1715.jpg','https://vendor.com/product/1715','2025-12-09 18:03:33'),(1716,'Storage','TeamGroup MP33 512GB NVMe SSD',20.26,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1716','https://vendor.com/images/1716.jpg','https://vendor.com/product/1716','2025-12-09 18:03:33'),(1717,'Storage','Crucial BX500 480GB SATA SSD',47.74,NULL,NULL,NULL,NULL,'Used','eBay','SRC1717','https://vendor.com/images/1717.jpg','https://vendor.com/product/1717','2025-12-09 18:03:33'),(1718,'Storage','Crucial BX500 480GB SATA SSD',25.91,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1718','https://vendor.com/images/1718.jpg','https://vendor.com/product/1718','2025-12-09 18:03:33'),(1719,'Storage','TeamGroup MP33 512GB NVMe SSD',48.75,NULL,NULL,NULL,NULL,'Used','eBay','SRC1719','https://vendor.com/images/1719.jpg','https://vendor.com/product/1719','2025-12-09 18:03:33'),(1720,'Storage','Kingston A400 480GB SATA SSD',35.04,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1720','https://vendor.com/images/1720.jpg','https://vendor.com/product/1720','2025-12-09 18:03:33'),(1721,'Storage','Crucial BX500 480GB SATA SSD',25.66,NULL,NULL,NULL,NULL,'New','Newegg','SRC1721','https://vendor.com/images/1721.jpg','https://vendor.com/product/1721','2025-12-09 18:03:33'),(1722,'Storage','TeamGroup MP33 512GB NVMe SSD',46.69,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1722','https://vendor.com/images/1722.jpg','https://vendor.com/product/1722','2025-12-09 18:03:34'),(1723,'Storage','Kingston A400 480GB SATA SSD',49.31,NULL,NULL,NULL,NULL,'New','Amazon','SRC1723','https://vendor.com/images/1723.jpg','https://vendor.com/product/1723','2025-12-09 18:03:34'),(1724,'Storage','TeamGroup MP33 512GB NVMe SSD',25.19,NULL,NULL,NULL,NULL,'New','Newegg','SRC1724','https://vendor.com/images/1724.jpg','https://vendor.com/product/1724','2025-12-09 18:03:34'),(1725,'Storage','Kingston A400 480GB SATA SSD',23.82,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1725','https://vendor.com/images/1725.jpg','https://vendor.com/product/1725','2025-12-09 18:03:34'),(1726,'Storage','Kingston A400 480GB SATA SSD',42.99,NULL,NULL,NULL,NULL,'New','Newegg','SRC1726','https://vendor.com/images/1726.jpg','https://vendor.com/product/1726','2025-12-09 18:03:34'),(1727,'Storage','Kingston A400 480GB SATA SSD',30.04,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1727','https://vendor.com/images/1727.jpg','https://vendor.com/product/1727','2025-12-09 18:03:34'),(1728,'Storage','Kingston A400 480GB SATA SSD',25.03,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1728','https://vendor.com/images/1728.jpg','https://vendor.com/product/1728','2025-12-09 18:03:34'),(1729,'Storage','TeamGroup MP33 512GB NVMe SSD',20.39,NULL,NULL,NULL,NULL,'New','Amazon','SRC1729','https://vendor.com/images/1729.jpg','https://vendor.com/product/1729','2025-12-09 18:03:34'),(1730,'Storage','Kingston A400 480GB SATA SSD',31.67,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1730','https://vendor.com/images/1730.jpg','https://vendor.com/product/1730','2025-12-09 18:03:34'),(1731,'Storage','Crucial BX500 480GB SATA SSD',30.29,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1731','https://vendor.com/images/1731.jpg','https://vendor.com/product/1731','2025-12-09 18:03:34'),(1732,'Storage','TeamGroup MP33 512GB NVMe SSD',33.01,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1732','https://vendor.com/images/1732.jpg','https://vendor.com/product/1732','2025-12-09 18:03:34'),(1733,'Storage','Crucial BX500 480GB SATA SSD',30.32,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1733','https://vendor.com/images/1733.jpg','https://vendor.com/product/1733','2025-12-09 18:03:34'),(1734,'Storage','Kingston A400 480GB SATA SSD',34.10,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1734','https://vendor.com/images/1734.jpg','https://vendor.com/product/1734','2025-12-09 18:03:34'),(1735,'Storage','Crucial BX500 480GB SATA SSD',48.22,NULL,NULL,NULL,NULL,'New','eBay','SRC1735','https://vendor.com/images/1735.jpg','https://vendor.com/product/1735','2025-12-09 18:03:34'),(1736,'Storage','Crucial BX500 480GB SATA SSD',20.87,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1736','https://vendor.com/images/1736.jpg','https://vendor.com/product/1736','2025-12-09 18:03:34'),(1737,'Storage','TeamGroup MP33 512GB NVMe SSD',42.02,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1737','https://vendor.com/images/1737.jpg','https://vendor.com/product/1737','2025-12-09 18:03:34'),(1738,'Storage','Crucial BX500 480GB SATA SSD',21.82,NULL,NULL,NULL,NULL,'Used','eBay','SRC1738','https://vendor.com/images/1738.jpg','https://vendor.com/product/1738','2025-12-09 18:03:34'),(1739,'Storage','Crucial BX500 480GB SATA SSD',20.67,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1739','https://vendor.com/images/1739.jpg','https://vendor.com/product/1739','2025-12-09 18:03:35'),(1740,'Storage','Kingston A400 480GB SATA SSD',34.36,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1740','https://vendor.com/images/1740.jpg','https://vendor.com/product/1740','2025-12-09 18:03:35'),(1741,'Storage','TeamGroup MP33 512GB NVMe SSD',44.91,NULL,NULL,NULL,NULL,'New','Amazon','SRC1741','https://vendor.com/images/1741.jpg','https://vendor.com/product/1741','2025-12-09 18:03:35'),(1742,'Storage','TeamGroup MP33 512GB NVMe SSD',23.71,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1742','https://vendor.com/images/1742.jpg','https://vendor.com/product/1742','2025-12-09 18:03:35'),(1743,'Storage','Kingston A400 480GB SATA SSD',48.91,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1743','https://vendor.com/images/1743.jpg','https://vendor.com/product/1743','2025-12-09 18:03:35'),(1744,'Storage','Crucial BX500 480GB SATA SSD',32.33,NULL,NULL,NULL,NULL,'New','eBay','SRC1744','https://vendor.com/images/1744.jpg','https://vendor.com/product/1744','2025-12-09 18:03:35'),(1745,'Storage','Crucial BX500 480GB SATA SSD',33.88,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1745','https://vendor.com/images/1745.jpg','https://vendor.com/product/1745','2025-12-09 18:03:35'),(1746,'Storage','TeamGroup MP33 512GB NVMe SSD',33.12,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1746','https://vendor.com/images/1746.jpg','https://vendor.com/product/1746','2025-12-09 18:03:35'),(1747,'Storage','Kingston A400 480GB SATA SSD',36.41,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1747','https://vendor.com/images/1747.jpg','https://vendor.com/product/1747','2025-12-09 18:03:35'),(1748,'Storage','TeamGroup MP33 512GB NVMe SSD',45.86,NULL,NULL,NULL,NULL,'Used','eBay','SRC1748','https://vendor.com/images/1748.jpg','https://vendor.com/product/1748','2025-12-09 18:03:35'),(1749,'Storage','Crucial BX500 480GB SATA SSD',43.88,NULL,NULL,NULL,NULL,'New','Amazon','SRC1749','https://vendor.com/images/1749.jpg','https://vendor.com/product/1749','2025-12-09 18:03:35'),(1750,'Storage','Kingston A400 480GB SATA SSD',21.33,NULL,NULL,NULL,NULL,'New','Newegg','SRC1750','https://vendor.com/images/1750.jpg','https://vendor.com/product/1750','2025-12-09 18:03:35'),(1751,'PSU','Thermaltake Smart 500W',46.34,NULL,NULL,NULL,500,'New','Amazon','SRC1751','https://vendor.com/images/1751.jpg','https://vendor.com/product/1751','2025-12-09 18:03:35'),(1752,'PSU','EVGA 500 W1 500W',49.97,NULL,NULL,NULL,500,'Refurbished','Newegg','SRC1752','https://vendor.com/images/1752.jpg','https://vendor.com/product/1752','2025-12-09 18:03:35'),(1753,'PSU','Thermaltake Smart 500W',58.07,NULL,NULL,NULL,500,'Refurbished','Amazon','SRC1753','https://vendor.com/images/1753.jpg','https://vendor.com/product/1753','2025-12-09 18:03:35'),(1754,'PSU','Corsair CV550 550W 80+ Bronze',44.49,NULL,NULL,NULL,550,'New','eBay','SRC1754','https://vendor.com/images/1754.jpg','https://vendor.com/product/1754','2025-12-09 18:03:35'),(1755,'PSU','Corsair CV550 550W 80+ Bronze',38.21,NULL,NULL,NULL,550,'Used','Amazon','SRC1755','https://vendor.com/images/1755.jpg','https://vendor.com/product/1755','2025-12-09 18:03:35'),(1756,'PSU','Thermaltake Smart 500W',49.07,NULL,NULL,NULL,500,'New','Microsoft','SRC1756','https://vendor.com/images/1756.jpg','https://vendor.com/product/1756','2025-12-09 18:03:36'),(1757,'PSU','Corsair CV550 550W 80+ Bronze',42.54,NULL,NULL,NULL,550,'Used','eBay','SRC1757','https://vendor.com/images/1757.jpg','https://vendor.com/product/1757','2025-12-09 18:03:36'),(1758,'PSU','EVGA 500 W1 500W',31.06,NULL,NULL,NULL,500,'Refurbished','eBay','SRC1758','https://vendor.com/images/1758.jpg','https://vendor.com/product/1758','2025-12-09 18:03:36'),(1759,'PSU','EVGA 500 W1 500W',45.91,NULL,NULL,NULL,500,'New','Microsoft','SRC1759','https://vendor.com/images/1759.jpg','https://vendor.com/product/1759','2025-12-09 18:03:36'),(1760,'PSU','EVGA 500 W1 500W',58.52,NULL,NULL,NULL,500,'New','Amazon','SRC1760','https://vendor.com/images/1760.jpg','https://vendor.com/product/1760','2025-12-09 18:03:36'),(1761,'PSU','Thermaltake Smart 500W',54.78,NULL,NULL,NULL,500,'Used','Newegg','SRC1761','https://vendor.com/images/1761.jpg','https://vendor.com/product/1761','2025-12-09 18:03:36'),(1762,'PSU','EVGA 500 W1 500W',45.23,NULL,NULL,NULL,500,'Used','Microsoft','SRC1762','https://vendor.com/images/1762.jpg','https://vendor.com/product/1762','2025-12-09 18:03:36'),(1763,'PSU','Thermaltake Smart 500W',32.64,NULL,NULL,NULL,500,'Refurbished','Amazon','SRC1763','https://vendor.com/images/1763.jpg','https://vendor.com/product/1763','2025-12-09 18:03:36'),(1764,'PSU','EVGA 500 W1 500W',51.09,NULL,NULL,NULL,500,'Refurbished','Microsoft','SRC1764','https://vendor.com/images/1764.jpg','https://vendor.com/product/1764','2025-12-09 18:03:36'),(1765,'PSU','Corsair CV550 550W 80+ Bronze',52.56,NULL,NULL,NULL,550,'New','eBay','SRC1765','https://vendor.com/images/1765.jpg','https://vendor.com/product/1765','2025-12-09 18:03:36'),(1766,'PSU','Corsair CV550 550W 80+ Bronze',41.73,NULL,NULL,NULL,550,'New','Amazon','SRC1766','https://vendor.com/images/1766.jpg','https://vendor.com/product/1766','2025-12-09 18:03:36'),(1767,'PSU','EVGA 500 W1 500W',57.02,NULL,NULL,NULL,500,'Used','eBay','SRC1767','https://vendor.com/images/1767.jpg','https://vendor.com/product/1767','2025-12-09 18:03:36'),(1768,'PSU','EVGA 500 W1 500W',53.01,NULL,NULL,NULL,500,'Refurbished','eBay','SRC1768','https://vendor.com/images/1768.jpg','https://vendor.com/product/1768','2025-12-09 18:03:36'),(1769,'PSU','EVGA 500 W1 500W',38.99,NULL,NULL,NULL,500,'New','Newegg','SRC1769','https://vendor.com/images/1769.jpg','https://vendor.com/product/1769','2025-12-09 18:03:36'),(1770,'PSU','Thermaltake Smart 500W',45.95,NULL,NULL,NULL,500,'Used','Amazon','SRC1770','https://vendor.com/images/1770.jpg','https://vendor.com/product/1770','2025-12-09 18:03:36'),(1771,'PSU','EVGA 500 W1 500W',44.02,NULL,NULL,NULL,500,'Used','Newegg','SRC1771','https://vendor.com/images/1771.jpg','https://vendor.com/product/1771','2025-12-09 18:03:36'),(1772,'PSU','Corsair CV550 550W 80+ Bronze',31.21,NULL,NULL,NULL,550,'New','eBay','SRC1772','https://vendor.com/images/1772.jpg','https://vendor.com/product/1772','2025-12-09 18:03:36'),(1773,'PSU','Corsair CV550 550W 80+ Bronze',47.78,NULL,NULL,NULL,550,'New','Amazon','SRC1773','https://vendor.com/images/1773.jpg','https://vendor.com/product/1773','2025-12-09 18:03:37'),(1774,'PSU','Corsair CV550 550W 80+ Bronze',54.75,NULL,NULL,NULL,550,'Refurbished','Microsoft','SRC1774','https://vendor.com/images/1774.jpg','https://vendor.com/product/1774','2025-12-09 18:03:37'),(1775,'PSU','Thermaltake Smart 500W',42.94,NULL,NULL,NULL,500,'New','eBay','SRC1775','https://vendor.com/images/1775.jpg','https://vendor.com/product/1775','2025-12-09 18:03:37'),(1776,'PSU','Corsair CV550 550W 80+ Bronze',48.13,NULL,NULL,NULL,550,'Used','Microsoft','SRC1776','https://vendor.com/images/1776.jpg','https://vendor.com/product/1776','2025-12-09 18:03:37'),(1777,'PSU','Thermaltake Smart 500W',55.21,NULL,NULL,NULL,500,'Refurbished','eBay','SRC1777','https://vendor.com/images/1777.jpg','https://vendor.com/product/1777','2025-12-09 18:03:37'),(1778,'PSU','Corsair CV550 550W 80+ Bronze',33.97,NULL,NULL,NULL,550,'Used','Amazon','SRC1778','https://vendor.com/images/1778.jpg','https://vendor.com/product/1778','2025-12-09 18:03:37'),(1779,'PSU','Corsair CV550 550W 80+ Bronze',55.69,NULL,NULL,NULL,550,'Refurbished','Microsoft','SRC1779','https://vendor.com/images/1779.jpg','https://vendor.com/product/1779','2025-12-09 18:03:37'),(1780,'PSU','Corsair CV550 550W 80+ Bronze',51.06,NULL,NULL,NULL,550,'Refurbished','Amazon','SRC1780','https://vendor.com/images/1780.jpg','https://vendor.com/product/1780','2025-12-09 18:03:37'),(1781,'PSU','Thermaltake Smart 500W',33.99,NULL,NULL,NULL,500,'Refurbished','Amazon','SRC1781','https://vendor.com/images/1781.jpg','https://vendor.com/product/1781','2025-12-09 18:03:37'),(1782,'PSU','Thermaltake Smart 500W',58.67,NULL,NULL,NULL,500,'New','Newegg','SRC1782','https://vendor.com/images/1782.jpg','https://vendor.com/product/1782','2025-12-09 18:03:37'),(1783,'PSU','Corsair CV550 550W 80+ Bronze',47.56,NULL,NULL,NULL,550,'Refurbished','Amazon','SRC1783','https://vendor.com/images/1783.jpg','https://vendor.com/product/1783','2025-12-09 18:03:37'),(1784,'PSU','Corsair CV550 550W 80+ Bronze',32.84,NULL,NULL,NULL,550,'Used','Newegg','SRC1784','https://vendor.com/images/1784.jpg','https://vendor.com/product/1784','2025-12-09 18:03:37'),(1785,'PSU','Thermaltake Smart 500W',58.63,NULL,NULL,NULL,500,'New','Amazon','SRC1785','https://vendor.com/images/1785.jpg','https://vendor.com/product/1785','2025-12-09 18:03:37'),(1786,'PSU','EVGA 500 W1 500W',58.04,NULL,NULL,NULL,500,'Refurbished','eBay','SRC1786','https://vendor.com/images/1786.jpg','https://vendor.com/product/1786','2025-12-09 18:03:37'),(1787,'PSU','EVGA 500 W1 500W',51.03,NULL,NULL,NULL,500,'Used','Amazon','SRC1787','https://vendor.com/images/1787.jpg','https://vendor.com/product/1787','2025-12-09 18:03:37'),(1788,'PSU','Thermaltake Smart 500W',52.51,NULL,NULL,NULL,500,'Used','Amazon','SRC1788','https://vendor.com/images/1788.jpg','https://vendor.com/product/1788','2025-12-09 18:03:37'),(1789,'PSU','EVGA 500 W1 500W',49.89,NULL,NULL,NULL,500,'Used','Newegg','SRC1789','https://vendor.com/images/1789.jpg','https://vendor.com/product/1789','2025-12-09 18:03:37'),(1790,'PSU','Corsair CV550 550W 80+ Bronze',30.69,NULL,NULL,NULL,550,'Refurbished','Newegg','SRC1790','https://vendor.com/images/1790.jpg','https://vendor.com/product/1790','2025-12-09 18:03:38'),(1791,'PSU','Thermaltake Smart 500W',56.90,NULL,NULL,NULL,500,'Refurbished','eBay','SRC1791','https://vendor.com/images/1791.jpg','https://vendor.com/product/1791','2025-12-09 18:03:38'),(1792,'PSU','EVGA 500 W1 500W',37.68,NULL,NULL,NULL,500,'New','eBay','SRC1792','https://vendor.com/images/1792.jpg','https://vendor.com/product/1792','2025-12-09 18:03:38'),(1793,'PSU','Thermaltake Smart 500W',32.00,NULL,NULL,NULL,500,'Used','eBay','SRC1793','https://vendor.com/images/1793.jpg','https://vendor.com/product/1793','2025-12-09 18:03:38'),(1794,'PSU','EVGA 500 W1 500W',37.17,NULL,NULL,NULL,500,'New','Microsoft','SRC1794','https://vendor.com/images/1794.jpg','https://vendor.com/product/1794','2025-12-09 18:03:38'),(1795,'PSU','Thermaltake Smart 500W',35.72,NULL,NULL,NULL,500,'Used','Newegg','SRC1795','https://vendor.com/images/1795.jpg','https://vendor.com/product/1795','2025-12-09 18:03:38'),(1796,'Case','Thermaltake Versa H18',53.86,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1796','https://vendor.com/images/1796.jpg','https://vendor.com/product/1796','2025-12-09 18:03:38'),(1797,'Case','Thermaltake Versa H18',30.01,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1797','https://vendor.com/images/1797.jpg','https://vendor.com/product/1797','2025-12-09 18:03:38'),(1798,'Case','Cooler Master MasterBox Q300L',54.62,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1798','https://vendor.com/images/1798.jpg','https://vendor.com/product/1798','2025-12-09 18:03:38'),(1799,'Case','AeroCool Bolt Mini',54.90,NULL,NULL,NULL,NULL,'New','Newegg','SRC1799','https://vendor.com/images/1799.jpg','https://vendor.com/product/1799','2025-12-09 18:03:38'),(1800,'Case','Thermaltake Versa H18',63.61,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1800','https://vendor.com/images/1800.jpg','https://vendor.com/product/1800','2025-12-09 18:03:38'),(1801,'Case','Thermaltake Versa H18',65.61,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1801','https://vendor.com/images/1801.jpg','https://vendor.com/product/1801','2025-12-09 18:03:38'),(1802,'Case','AeroCool Bolt Mini',37.72,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1802','https://vendor.com/images/1802.jpg','https://vendor.com/product/1802','2025-12-09 18:03:38'),(1803,'Case','Thermaltake Versa H18',66.76,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1803','https://vendor.com/images/1803.jpg','https://vendor.com/product/1803','2025-12-09 18:03:38'),(1804,'Case','Cooler Master MasterBox Q300L',50.77,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1804','https://vendor.com/images/1804.jpg','https://vendor.com/product/1804','2025-12-09 18:03:38'),(1805,'Case','Cooler Master MasterBox Q300L',59.71,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1805','https://vendor.com/images/1805.jpg','https://vendor.com/product/1805','2025-12-09 18:03:38'),(1806,'Case','Cooler Master MasterBox Q300L',41.28,NULL,NULL,NULL,NULL,'Used','eBay','SRC1806','https://vendor.com/images/1806.jpg','https://vendor.com/product/1806','2025-12-09 18:03:39'),(1807,'Case','AeroCool Bolt Mini',57.60,NULL,NULL,NULL,NULL,'New','Amazon','SRC1807','https://vendor.com/images/1807.jpg','https://vendor.com/product/1807','2025-12-09 18:03:39'),(1808,'Case','Thermaltake Versa H18',54.42,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1808','https://vendor.com/images/1808.jpg','https://vendor.com/product/1808','2025-12-09 18:03:39'),(1809,'Case','AeroCool Bolt Mini',44.34,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1809','https://vendor.com/images/1809.jpg','https://vendor.com/product/1809','2025-12-09 18:03:39'),(1810,'Case','Thermaltake Versa H18',30.05,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1810','https://vendor.com/images/1810.jpg','https://vendor.com/product/1810','2025-12-09 18:03:39'),(1811,'Case','Cooler Master MasterBox Q300L',31.71,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1811','https://vendor.com/images/1811.jpg','https://vendor.com/product/1811','2025-12-09 18:03:39'),(1812,'Case','Cooler Master MasterBox Q300L',55.73,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1812','https://vendor.com/images/1812.jpg','https://vendor.com/product/1812','2025-12-09 18:03:39'),(1813,'Case','Cooler Master MasterBox Q300L',45.07,NULL,NULL,NULL,NULL,'Used','eBay','SRC1813','https://vendor.com/images/1813.jpg','https://vendor.com/product/1813','2025-12-09 18:03:39'),(1814,'Case','AeroCool Bolt Mini',36.26,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1814','https://vendor.com/images/1814.jpg','https://vendor.com/product/1814','2025-12-09 18:03:39'),(1815,'Case','AeroCool Bolt Mini',40.99,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1815','https://vendor.com/images/1815.jpg','https://vendor.com/product/1815','2025-12-09 18:03:39'),(1816,'Case','Thermaltake Versa H18',44.51,NULL,NULL,NULL,NULL,'New','Amazon','SRC1816','https://vendor.com/images/1816.jpg','https://vendor.com/product/1816','2025-12-09 18:03:39'),(1817,'Case','Thermaltake Versa H18',38.89,NULL,NULL,NULL,NULL,'New','Amazon','SRC1817','https://vendor.com/images/1817.jpg','https://vendor.com/product/1817','2025-12-09 18:03:39'),(1818,'Case','AeroCool Bolt Mini',37.18,NULL,NULL,NULL,NULL,'New','Amazon','SRC1818','https://vendor.com/images/1818.jpg','https://vendor.com/product/1818','2025-12-09 18:03:39'),(1819,'Case','Thermaltake Versa H18',34.89,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1819','https://vendor.com/images/1819.jpg','https://vendor.com/product/1819','2025-12-09 18:03:39'),(1820,'Case','AeroCool Bolt Mini',36.35,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1820','https://vendor.com/images/1820.jpg','https://vendor.com/product/1820','2025-12-09 18:03:39'),(1821,'Case','Cooler Master MasterBox Q300L',66.41,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1821','https://vendor.com/images/1821.jpg','https://vendor.com/product/1821','2025-12-09 18:03:39'),(1822,'Case','AeroCool Bolt Mini',43.10,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1822','https://vendor.com/images/1822.jpg','https://vendor.com/product/1822','2025-12-09 18:03:40'),(1823,'Case','Cooler Master MasterBox Q300L',34.20,NULL,NULL,NULL,NULL,'New','eBay','SRC1823','https://vendor.com/images/1823.jpg','https://vendor.com/product/1823','2025-12-09 18:03:40'),(1824,'Case','Cooler Master MasterBox Q300L',45.75,NULL,NULL,NULL,NULL,'Used','eBay','SRC1824','https://vendor.com/images/1824.jpg','https://vendor.com/product/1824','2025-12-09 18:03:40'),(1825,'Case','Cooler Master MasterBox Q300L',60.97,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1825','https://vendor.com/images/1825.jpg','https://vendor.com/product/1825','2025-12-09 18:03:40'),(1826,'Case','Thermaltake Versa H18',52.38,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1826','https://vendor.com/images/1826.jpg','https://vendor.com/product/1826','2025-12-09 18:03:40'),(1827,'Case','Thermaltake Versa H18',52.64,NULL,NULL,NULL,NULL,'Used','eBay','SRC1827','https://vendor.com/images/1827.jpg','https://vendor.com/product/1827','2025-12-09 18:03:40'),(1828,'Case','Thermaltake Versa H18',45.16,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1828','https://vendor.com/images/1828.jpg','https://vendor.com/product/1828','2025-12-09 18:03:40'),(1829,'Case','AeroCool Bolt Mini',54.31,NULL,NULL,NULL,NULL,'New','Newegg','SRC1829','https://vendor.com/images/1829.jpg','https://vendor.com/product/1829','2025-12-09 18:03:40'),(1830,'Case','Cooler Master MasterBox Q300L',49.07,NULL,NULL,NULL,NULL,'New','Amazon','SRC1830','https://vendor.com/images/1830.jpg','https://vendor.com/product/1830','2025-12-09 18:03:40'),(1831,'Case','Cooler Master MasterBox Q300L',67.25,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1831','https://vendor.com/images/1831.jpg','https://vendor.com/product/1831','2025-12-09 18:03:40'),(1832,'Case','AeroCool Bolt Mini',58.59,NULL,NULL,NULL,NULL,'Used','eBay','SRC1832','https://vendor.com/images/1832.jpg','https://vendor.com/product/1832','2025-12-09 18:03:40'),(1833,'Case','AeroCool Bolt Mini',60.41,NULL,NULL,NULL,NULL,'Used','eBay','SRC1833','https://vendor.com/images/1833.jpg','https://vendor.com/product/1833','2025-12-09 18:03:40'),(1834,'Case','AeroCool Bolt Mini',42.49,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1834','https://vendor.com/images/1834.jpg','https://vendor.com/product/1834','2025-12-09 18:03:40'),(1835,'Case','AeroCool Bolt Mini',42.58,NULL,NULL,NULL,NULL,'Used','eBay','SRC1835','https://vendor.com/images/1835.jpg','https://vendor.com/product/1835','2025-12-09 18:03:40'),(1836,'Case','Thermaltake Versa H18',67.41,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1836','https://vendor.com/images/1836.jpg','https://vendor.com/product/1836','2025-12-09 18:03:40'),(1837,'Case','AeroCool Bolt Mini',39.02,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1837','https://vendor.com/images/1837.jpg','https://vendor.com/product/1837','2025-12-09 18:03:40'),(1838,'Case','Thermaltake Versa H18',30.50,NULL,NULL,NULL,NULL,'New','Newegg','SRC1838','https://vendor.com/images/1838.jpg','https://vendor.com/product/1838','2025-12-09 18:03:41'),(1839,'Case','Cooler Master MasterBox Q300L',31.82,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1839','https://vendor.com/images/1839.jpg','https://vendor.com/product/1839','2025-12-09 18:03:41'),(1840,'Case','Cooler Master MasterBox Q300L',33.29,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1840','https://vendor.com/images/1840.jpg','https://vendor.com/product/1840','2025-12-09 18:03:41'),(1841,'Cooler','Vetroo V5 Air Cooler',39.71,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1841','https://vendor.com/images/1841.jpg','https://vendor.com/product/1841','2025-12-09 18:03:41'),(1842,'Cooler','DeepCool GAMMAXX 400',38.37,NULL,NULL,NULL,NULL,'New','Newegg','SRC1842','https://vendor.com/images/1842.jpg','https://vendor.com/product/1842','2025-12-09 18:03:41'),(1843,'Cooler','Vetroo V5 Air Cooler',26.24,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1843','https://vendor.com/images/1843.jpg','https://vendor.com/product/1843','2025-12-09 18:03:41'),(1844,'Cooler','DeepCool GAMMAXX 400',22.59,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1844','https://vendor.com/images/1844.jpg','https://vendor.com/product/1844','2025-12-09 18:03:41'),(1845,'Cooler','Cooler Master Hyper 212 EVO',24.03,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1845','https://vendor.com/images/1845.jpg','https://vendor.com/product/1845','2025-12-09 18:03:41'),(1846,'Cooler','Cooler Master Hyper 212 EVO',34.95,NULL,NULL,NULL,NULL,'New','Newegg','SRC1846','https://vendor.com/images/1846.jpg','https://vendor.com/product/1846','2025-12-09 18:03:41'),(1847,'Cooler','Cooler Master Hyper 212 EVO',29.20,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1847','https://vendor.com/images/1847.jpg','https://vendor.com/product/1847','2025-12-09 18:03:41'),(1848,'Cooler','Cooler Master Hyper 212 EVO',33.88,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1848','https://vendor.com/images/1848.jpg','https://vendor.com/product/1848','2025-12-09 18:03:41'),(1849,'Cooler','Cooler Master Hyper 212 EVO',15.84,NULL,NULL,NULL,NULL,'New','eBay','SRC1849','https://vendor.com/images/1849.jpg','https://vendor.com/product/1849','2025-12-09 18:03:41'),(1850,'Cooler','Cooler Master Hyper 212 EVO',31.93,NULL,NULL,NULL,NULL,'New','Newegg','SRC1850','https://vendor.com/images/1850.jpg','https://vendor.com/product/1850','2025-12-09 18:03:41'),(1851,'Cooler','Vetroo V5 Air Cooler',22.55,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1851','https://vendor.com/images/1851.jpg','https://vendor.com/product/1851','2025-12-09 18:03:41'),(1852,'Cooler','Vetroo V5 Air Cooler',34.38,NULL,NULL,NULL,NULL,'Used','eBay','SRC1852','https://vendor.com/images/1852.jpg','https://vendor.com/product/1852','2025-12-09 18:03:41'),(1853,'Cooler','DeepCool GAMMAXX 400',22.68,NULL,NULL,NULL,NULL,'Used','eBay','SRC1853','https://vendor.com/images/1853.jpg','https://vendor.com/product/1853','2025-12-09 18:03:41'),(1854,'Cooler','DeepCool GAMMAXX 400',19.33,NULL,NULL,NULL,NULL,'New','eBay','SRC1854','https://vendor.com/images/1854.jpg','https://vendor.com/product/1854','2025-12-09 18:03:42'),(1855,'Cooler','DeepCool GAMMAXX 400',24.39,NULL,NULL,NULL,NULL,'New','eBay','SRC1855','https://vendor.com/images/1855.jpg','https://vendor.com/product/1855','2025-12-09 18:03:42'),(1856,'Cooler','Cooler Master Hyper 212 EVO',28.15,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1856','https://vendor.com/images/1856.jpg','https://vendor.com/product/1856','2025-12-09 18:03:42'),(1857,'Cooler','DeepCool GAMMAXX 400',24.72,NULL,NULL,NULL,NULL,'Used','eBay','SRC1857','https://vendor.com/images/1857.jpg','https://vendor.com/product/1857','2025-12-09 18:03:42'),(1858,'Cooler','Vetroo V5 Air Cooler',34.40,NULL,NULL,NULL,NULL,'New','Newegg','SRC1858','https://vendor.com/images/1858.jpg','https://vendor.com/product/1858','2025-12-09 18:03:42'),(1859,'Cooler','Cooler Master Hyper 212 EVO',34.44,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1859','https://vendor.com/images/1859.jpg','https://vendor.com/product/1859','2025-12-09 18:03:42'),(1860,'Cooler','DeepCool GAMMAXX 400',29.88,NULL,NULL,NULL,NULL,'Used','eBay','SRC1860','https://vendor.com/images/1860.jpg','https://vendor.com/product/1860','2025-12-09 18:03:42'),(1861,'Cooler','Vetroo V5 Air Cooler',28.21,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1861','https://vendor.com/images/1861.jpg','https://vendor.com/product/1861','2025-12-09 18:03:42'),(1862,'Cooler','Cooler Master Hyper 212 EVO',22.14,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1862','https://vendor.com/images/1862.jpg','https://vendor.com/product/1862','2025-12-09 18:03:42'),(1863,'Cooler','Vetroo V5 Air Cooler',38.13,NULL,NULL,NULL,NULL,'New','Amazon','SRC1863','https://vendor.com/images/1863.jpg','https://vendor.com/product/1863','2025-12-09 18:03:42'),(1864,'Cooler','DeepCool GAMMAXX 400',15.94,NULL,NULL,NULL,NULL,'New','Newegg','SRC1864','https://vendor.com/images/1864.jpg','https://vendor.com/product/1864','2025-12-09 18:03:42'),(1865,'Cooler','Vetroo V5 Air Cooler',17.37,NULL,NULL,NULL,NULL,'New','Amazon','SRC1865','https://vendor.com/images/1865.jpg','https://vendor.com/product/1865','2025-12-09 18:03:42'),(1866,'Cooler','DeepCool GAMMAXX 400',22.43,NULL,NULL,NULL,NULL,'Used','eBay','SRC1866','https://vendor.com/images/1866.jpg','https://vendor.com/product/1866','2025-12-09 18:03:42'),(1867,'Cooler','DeepCool GAMMAXX 400',17.22,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1867','https://vendor.com/images/1867.jpg','https://vendor.com/product/1867','2025-12-09 18:03:42'),(1868,'Cooler','Vetroo V5 Air Cooler',31.46,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1868','https://vendor.com/images/1868.jpg','https://vendor.com/product/1868','2025-12-09 18:03:42'),(1869,'Cooler','Cooler Master Hyper 212 EVO',36.69,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1869','https://vendor.com/images/1869.jpg','https://vendor.com/product/1869','2025-12-09 18:03:42'),(1870,'Cooler','Cooler Master Hyper 212 EVO',25.82,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1870','https://vendor.com/images/1870.jpg','https://vendor.com/product/1870','2025-12-09 18:03:42'),(1871,'Cooler','Vetroo V5 Air Cooler',23.51,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1871','https://vendor.com/images/1871.jpg','https://vendor.com/product/1871','2025-12-09 18:03:43'),(1872,'Cooler','DeepCool GAMMAXX 400',20.41,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1872','https://vendor.com/images/1872.jpg','https://vendor.com/product/1872','2025-12-09 18:03:43'),(1873,'Cooler','Cooler Master Hyper 212 EVO',30.75,NULL,NULL,NULL,NULL,'Used','eBay','SRC1873','https://vendor.com/images/1873.jpg','https://vendor.com/product/1873','2025-12-09 18:03:43'),(1874,'Cooler','DeepCool GAMMAXX 400',39.96,NULL,NULL,NULL,NULL,'Used','eBay','SRC1874','https://vendor.com/images/1874.jpg','https://vendor.com/product/1874','2025-12-09 18:03:43'),(1875,'Cooler','DeepCool GAMMAXX 400',39.77,NULL,NULL,NULL,NULL,'New','Amazon','SRC1875','https://vendor.com/images/1875.jpg','https://vendor.com/product/1875','2025-12-09 18:03:43'),(1876,'Cooler','DeepCool GAMMAXX 400',24.88,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1876','https://vendor.com/images/1876.jpg','https://vendor.com/product/1876','2025-12-09 18:03:43'),(1877,'Cooler','Vetroo V5 Air Cooler',39.85,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1877','https://vendor.com/images/1877.jpg','https://vendor.com/product/1877','2025-12-09 18:03:43'),(1878,'Cooler','Vetroo V5 Air Cooler',37.80,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1878','https://vendor.com/images/1878.jpg','https://vendor.com/product/1878','2025-12-09 18:03:43'),(1879,'Cooler','Cooler Master Hyper 212 EVO',16.87,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1879','https://vendor.com/images/1879.jpg','https://vendor.com/product/1879','2025-12-09 18:03:43'),(1880,'Cooler','Vetroo V5 Air Cooler',32.06,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1880','https://vendor.com/images/1880.jpg','https://vendor.com/product/1880','2025-12-09 18:03:43'),(1881,'Cooler','Vetroo V5 Air Cooler',26.88,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1881','https://vendor.com/images/1881.jpg','https://vendor.com/product/1881','2025-12-09 18:03:43'),(1882,'Cooler','DeepCool GAMMAXX 400',23.76,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1882','https://vendor.com/images/1882.jpg','https://vendor.com/product/1882','2025-12-09 18:03:43'),(1883,'Cooler','Cooler Master Hyper 212 EVO',33.31,NULL,NULL,NULL,NULL,'New','Newegg','SRC1883','https://vendor.com/images/1883.jpg','https://vendor.com/product/1883','2025-12-09 18:03:43'),(1884,'Cooler','Vetroo V5 Air Cooler',36.90,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1884','https://vendor.com/images/1884.jpg','https://vendor.com/product/1884','2025-12-09 18:03:43'),(1885,'Cooler','Cooler Master Hyper 212 EVO',35.04,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1885','https://vendor.com/images/1885.jpg','https://vendor.com/product/1885','2025-12-09 18:03:43'),(1886,'Fan','Arctic F12 120mm Fan',8.13,NULL,NULL,NULL,NULL,'New','eBay','SRC1886','https://vendor.com/images/1886.jpg','https://vendor.com/product/1886','2025-12-09 18:03:43'),(1887,'Fan','PCCOOLER 120mm RGB Fan',14.43,NULL,NULL,NULL,NULL,'New','Amazon','SRC1887','https://vendor.com/images/1887.jpg','https://vendor.com/product/1887','2025-12-09 18:03:44'),(1888,'Fan','PCCOOLER 120mm RGB Fan',11.89,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1888','https://vendor.com/images/1888.jpg','https://vendor.com/product/1888','2025-12-09 18:03:44'),(1889,'Fan','Arctic F12 120mm Fan',16.16,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1889','https://vendor.com/images/1889.jpg','https://vendor.com/product/1889','2025-12-09 18:03:44'),(1890,'Fan','PCCOOLER 120mm RGB Fan',10.87,NULL,NULL,NULL,NULL,'New','Newegg','SRC1890','https://vendor.com/images/1890.jpg','https://vendor.com/product/1890','2025-12-09 18:03:44'),(1891,'Fan','Cooler Master SickleFlow 120mm',19.07,NULL,NULL,NULL,NULL,'New','eBay','SRC1891','https://vendor.com/images/1891.jpg','https://vendor.com/product/1891','2025-12-09 18:03:44'),(1892,'Fan','Arctic F12 120mm Fan',19.42,NULL,NULL,NULL,NULL,'Used','eBay','SRC1892','https://vendor.com/images/1892.jpg','https://vendor.com/product/1892','2025-12-09 18:03:44'),(1893,'Fan','Cooler Master SickleFlow 120mm',12.97,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1893','https://vendor.com/images/1893.jpg','https://vendor.com/product/1893','2025-12-09 18:03:44'),(1894,'Fan','Cooler Master SickleFlow 120mm',14.11,NULL,NULL,NULL,NULL,'New','Amazon','SRC1894','https://vendor.com/images/1894.jpg','https://vendor.com/product/1894','2025-12-09 18:03:44'),(1895,'Fan','Cooler Master SickleFlow 120mm',7.66,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1895','https://vendor.com/images/1895.jpg','https://vendor.com/product/1895','2025-12-09 18:03:44'),(1896,'Fan','Arctic F12 120mm Fan',19.48,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1896','https://vendor.com/images/1896.jpg','https://vendor.com/product/1896','2025-12-09 18:03:44'),(1897,'Fan','PCCOOLER 120mm RGB Fan',7.08,NULL,NULL,NULL,NULL,'New','eBay','SRC1897','https://vendor.com/images/1897.jpg','https://vendor.com/product/1897','2025-12-09 18:03:44'),(1898,'Fan','Arctic F12 120mm Fan',7.67,NULL,NULL,NULL,NULL,'New','Newegg','SRC1898','https://vendor.com/images/1898.jpg','https://vendor.com/product/1898','2025-12-09 18:03:44'),(1899,'Fan','Arctic F12 120mm Fan',14.45,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1899','https://vendor.com/images/1899.jpg','https://vendor.com/product/1899','2025-12-09 18:03:44'),(1900,'Fan','PCCOOLER 120mm RGB Fan',14.30,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1900','https://vendor.com/images/1900.jpg','https://vendor.com/product/1900','2025-12-09 18:03:44'),(1901,'Fan','Cooler Master SickleFlow 120mm',8.48,NULL,NULL,NULL,NULL,'Used','eBay','SRC1901','https://vendor.com/images/1901.jpg','https://vendor.com/product/1901','2025-12-09 18:03:44'),(1902,'Fan','Cooler Master SickleFlow 120mm',12.77,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1902','https://vendor.com/images/1902.jpg','https://vendor.com/product/1902','2025-12-09 18:03:44'),(1903,'Fan','PCCOOLER 120mm RGB Fan',5.04,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1903','https://vendor.com/images/1903.jpg','https://vendor.com/product/1903','2025-12-09 18:03:45'),(1904,'Fan','PCCOOLER 120mm RGB Fan',16.99,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1904','https://vendor.com/images/1904.jpg','https://vendor.com/product/1904','2025-12-09 18:03:45'),(1905,'Fan','Cooler Master SickleFlow 120mm',17.25,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1905','https://vendor.com/images/1905.jpg','https://vendor.com/product/1905','2025-12-09 18:03:45'),(1906,'Fan','PCCOOLER 120mm RGB Fan',19.34,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1906','https://vendor.com/images/1906.jpg','https://vendor.com/product/1906','2025-12-09 18:03:45'),(1907,'Fan','Arctic F12 120mm Fan',8.99,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1907','https://vendor.com/images/1907.jpg','https://vendor.com/product/1907','2025-12-09 18:03:45'),(1908,'Fan','Cooler Master SickleFlow 120mm',6.90,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1908','https://vendor.com/images/1908.jpg','https://vendor.com/product/1908','2025-12-09 18:03:45'),(1909,'Fan','Cooler Master SickleFlow 120mm',11.28,NULL,NULL,NULL,NULL,'New','Amazon','SRC1909','https://vendor.com/images/1909.jpg','https://vendor.com/product/1909','2025-12-09 18:03:45'),(1910,'Fan','PCCOOLER 120mm RGB Fan',18.06,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1910','https://vendor.com/images/1910.jpg','https://vendor.com/product/1910','2025-12-09 18:03:45'),(1911,'Fan','PCCOOLER 120mm RGB Fan',13.24,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1911','https://vendor.com/images/1911.jpg','https://vendor.com/product/1911','2025-12-09 18:03:45'),(1912,'Fan','PCCOOLER 120mm RGB Fan',18.49,NULL,NULL,NULL,NULL,'Used','eBay','SRC1912','https://vendor.com/images/1912.jpg','https://vendor.com/product/1912','2025-12-09 18:03:45'),(1913,'Fan','Arctic F12 120mm Fan',9.61,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1913','https://vendor.com/images/1913.jpg','https://vendor.com/product/1913','2025-12-09 18:03:45'),(1914,'Fan','Arctic F12 120mm Fan',14.62,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1914','https://vendor.com/images/1914.jpg','https://vendor.com/product/1914','2025-12-09 18:03:45'),(1915,'Fan','Cooler Master SickleFlow 120mm',13.41,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1915','https://vendor.com/images/1915.jpg','https://vendor.com/product/1915','2025-12-09 18:03:45'),(1916,'Fan','Cooler Master SickleFlow 120mm',8.10,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1916','https://vendor.com/images/1916.jpg','https://vendor.com/product/1916','2025-12-09 18:03:45'),(1917,'Fan','Cooler Master SickleFlow 120mm',16.46,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1917','https://vendor.com/images/1917.jpg','https://vendor.com/product/1917','2025-12-09 18:03:45'),(1918,'Fan','Arctic F12 120mm Fan',14.14,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1918','https://vendor.com/images/1918.jpg','https://vendor.com/product/1918','2025-12-09 18:03:45'),(1919,'Fan','Arctic F12 120mm Fan',14.00,NULL,NULL,NULL,NULL,'New','eBay','SRC1919','https://vendor.com/images/1919.jpg','https://vendor.com/product/1919','2025-12-09 18:03:45'),(1920,'Fan','Cooler Master SickleFlow 120mm',6.88,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1920','https://vendor.com/images/1920.jpg','https://vendor.com/product/1920','2025-12-09 18:03:45'),(1921,'Fan','PCCOOLER 120mm RGB Fan',13.75,NULL,NULL,NULL,NULL,'Used','eBay','SRC1921','https://vendor.com/images/1921.jpg','https://vendor.com/product/1921','2025-12-09 18:03:46'),(1922,'Fan','Arctic F12 120mm Fan',13.83,NULL,NULL,NULL,NULL,'New','Newegg','SRC1922','https://vendor.com/images/1922.jpg','https://vendor.com/product/1922','2025-12-09 18:03:46'),(1923,'Fan','Cooler Master SickleFlow 120mm',5.51,NULL,NULL,NULL,NULL,'New','Newegg','SRC1923','https://vendor.com/images/1923.jpg','https://vendor.com/product/1923','2025-12-09 18:03:46'),(1924,'Fan','Arctic F12 120mm Fan',11.80,NULL,NULL,NULL,NULL,'New','Newegg','SRC1924','https://vendor.com/images/1924.jpg','https://vendor.com/product/1924','2025-12-09 18:03:46'),(1925,'Fan','Arctic F12 120mm Fan',11.28,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1925','https://vendor.com/images/1925.jpg','https://vendor.com/product/1925','2025-12-09 18:03:46'),(1926,'Fan','PCCOOLER 120mm RGB Fan',7.29,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1926','https://vendor.com/images/1926.jpg','https://vendor.com/product/1926','2025-12-09 18:03:46'),(1927,'Fan','PCCOOLER 120mm RGB Fan',19.68,NULL,NULL,NULL,NULL,'Used','Microsoft','SRC1927','https://vendor.com/images/1927.jpg','https://vendor.com/product/1927','2025-12-09 18:03:46'),(1928,'Fan','Cooler Master SickleFlow 120mm',7.70,NULL,NULL,NULL,NULL,'New','Amazon','SRC1928','https://vendor.com/images/1928.jpg','https://vendor.com/product/1928','2025-12-09 18:03:46'),(1929,'Fan','Arctic F12 120mm Fan',10.25,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1929','https://vendor.com/images/1929.jpg','https://vendor.com/product/1929','2025-12-09 18:03:46'),(1930,'Fan','PCCOOLER 120mm RGB Fan',11.69,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1930','https://vendor.com/images/1930.jpg','https://vendor.com/product/1930','2025-12-09 18:03:46'),(1931,'OS','Proxmox VE 8',186.97,NULL,NULL,NULL,NULL,'Used','eBay','SRC1931','https://vendor.com/images/1931.jpg','https://vendor.com/product/1931','2025-12-09 18:03:46'),(1932,'OS','Windows Server 2022 Standard',52.58,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1932','https://vendor.com/images/1932.jpg','https://vendor.com/product/1932','2025-12-09 18:03:46'),(1933,'OS','Windows Server 2019 Standard',41.77,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1933','https://vendor.com/images/1933.jpg','https://vendor.com/product/1933','2025-12-09 18:03:46'),(1934,'OS','Arch Linux',97.60,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1934','https://vendor.com/images/1934.jpg','https://vendor.com/product/1934','2025-12-09 18:03:46'),(1935,'OS','EndeavourOS',166.90,NULL,NULL,NULL,NULL,'New','Amazon','SRC1935','https://vendor.com/images/1935.jpg','https://vendor.com/product/1935','2025-12-09 18:03:46'),(1936,'OS','Red Hat Enterprise Linux 9',98.82,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1936','https://vendor.com/images/1936.jpg','https://vendor.com/product/1936','2025-12-09 18:03:46'),(1937,'OS','Debian 12',84.75,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1937','https://vendor.com/images/1937.jpg','https://vendor.com/product/1937','2025-12-09 18:03:47'),(1938,'OS','Kali Linux',119.17,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1938','https://vendor.com/images/1938.jpg','https://vendor.com/product/1938','2025-12-09 18:03:47'),(1939,'OS','Qubes OS',164.55,NULL,NULL,NULL,NULL,'New','eBay','SRC1939','https://vendor.com/images/1939.jpg','https://vendor.com/product/1939','2025-12-09 18:03:47'),(1940,'OS','Android x86',41.12,NULL,NULL,NULL,NULL,'Used','eBay','SRC1940','https://vendor.com/images/1940.jpg','https://vendor.com/product/1940','2025-12-09 18:03:47'),(1941,'OS','Android x86',135.67,NULL,NULL,NULL,NULL,'New','eBay','SRC1941','https://vendor.com/images/1941.jpg','https://vendor.com/product/1941','2025-12-09 18:03:47'),(1942,'OS','TrueNAS SCALE',24.06,NULL,NULL,NULL,NULL,'Refurbished','Newegg','SRC1942','https://vendor.com/images/1942.jpg','https://vendor.com/product/1942','2025-12-09 18:03:47'),(1943,'OS','Pop!_OS 22.04',41.03,NULL,NULL,NULL,NULL,'New','Amazon','SRC1943','https://vendor.com/images/1943.jpg','https://vendor.com/product/1943','2025-12-09 18:03:47'),(1944,'OS','Red Hat Enterprise Linux 9',11.48,NULL,NULL,NULL,NULL,'Used','eBay','SRC1944','https://vendor.com/images/1944.jpg','https://vendor.com/product/1944','2025-12-09 18:03:47'),(1945,'OS','Windows Server 2019 Standard',3.19,NULL,NULL,NULL,NULL,'Used','eBay','SRC1945','https://vendor.com/images/1945.jpg','https://vendor.com/product/1945','2025-12-09 18:03:47'),(1946,'OS','Rocky Linux 9',91.44,NULL,NULL,NULL,NULL,'New','Amazon','SRC1946','https://vendor.com/images/1946.jpg','https://vendor.com/product/1946','2025-12-09 18:03:47'),(1947,'OS','EndeavourOS',176.89,NULL,NULL,NULL,NULL,'New','Newegg','SRC1947','https://vendor.com/images/1947.jpg','https://vendor.com/product/1947','2025-12-09 18:03:47'),(1948,'OS','Red Hat Enterprise Linux 9',198.20,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1948','https://vendor.com/images/1948.jpg','https://vendor.com/product/1948','2025-12-09 18:03:47'),(1949,'OS','Qubes OS',64.56,NULL,NULL,NULL,NULL,'Refurbished','eBay','SRC1949','https://vendor.com/images/1949.jpg','https://vendor.com/product/1949','2025-12-09 18:03:47'),(1950,'OS','Chrome OS Flex',84.71,NULL,NULL,NULL,NULL,'Used','eBay','SRC1950','https://vendor.com/images/1950.jpg','https://vendor.com/product/1950','2025-12-09 18:03:47'),(1951,'OS','Arch Linux',187.03,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1951','https://vendor.com/images/1951.jpg','https://vendor.com/product/1951','2025-12-09 18:03:47'),(1952,'OS','Qubes OS',145.25,NULL,NULL,NULL,NULL,'Used','Amazon','SRC1952','https://vendor.com/images/1952.jpg','https://vendor.com/product/1952','2025-12-09 18:03:47'),(1953,'OS','EndeavourOS',188.26,NULL,NULL,NULL,NULL,'Used','eBay','SRC1953','https://vendor.com/images/1953.jpg','https://vendor.com/product/1953','2025-12-09 18:03:48'),(1954,'OS','Windows Server 2022 Standard',183.53,NULL,NULL,NULL,NULL,'New','Microsoft','SRC1954','https://vendor.com/images/1954.jpg','https://vendor.com/product/1954','2025-12-09 18:03:48'),(1955,'OS','Rocky Linux 9',81.54,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1955','https://vendor.com/images/1955.jpg','https://vendor.com/product/1955','2025-12-09 18:03:48'),(1956,'OS','Arch Linux',16.36,NULL,NULL,NULL,NULL,'Used','Newegg','SRC1956','https://vendor.com/images/1956.jpg','https://vendor.com/product/1956','2025-12-09 18:03:48'),(1957,'OS','VMware ESXi 8',20.51,NULL,NULL,NULL,NULL,'New','Newegg','SRC1957','https://vendor.com/images/1957.jpg','https://vendor.com/product/1957','2025-12-09 18:03:48'),(1958,'OS','Windows Server 2019 Standard',150.63,NULL,NULL,NULL,NULL,'Refurbished','Microsoft','SRC1958','https://vendor.com/images/1958.jpg','https://vendor.com/product/1958','2025-12-09 18:03:48'),(1959,'OS','Ubuntu 24.04 LTS',187.56,NULL,NULL,NULL,NULL,'Used','eBay','SRC1959','https://vendor.com/images/1959.jpg','https://vendor.com/product/1959','2025-12-09 18:03:48'),(1960,'OS','Linux Mint 21.3',52.14,NULL,NULL,NULL,NULL,'Refurbished','Amazon','SRC1960','https://vendor.com/images/1960.jpg','https://vendor.com/product/1960','2025-12-09 18:03:48'),(1961,'OS','Windows 11 pro',40.00,NULL,NULL,NULL,NULL,'New','eBay','SRC1945','https://vendor.com/images/1945.jpg','https://vendor.com/product/1945','2025-12-09 18:03:47');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `bio` text,
  `avatar_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `profiles`
--


--
-- Table structure for table `project_members`
--

CREATE TABLE `project_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `user_id` int NOT NULL,
  `role` enum('owner','collaborator','viewer') NOT NULL DEFAULT 'collaborator',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_project_user` (`project_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `project_members`
--

INSERT INTO `project_members` VALUES (1,1,1,'owner');

--
-- Table structure for table `project_parts`
--

CREATE TABLE `project_parts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `progress` int NOT NULL DEFAULT '0',
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  CONSTRAINT `project_parts_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `project_parts`
--

INSERT INTO `project_parts` VALUES (1,1,'LivingWorld','the games world lives and changes towns  can be built along with economies that effect the actual players world.',0,1,'2026-01-12 00:01:06','2026-01-12 00:01:19'),(2,1,'RecruitableCastNpcs','random npc generation for side cast recruitable characters that age and evoloved if they die their child takes over or their student.',0,2,'2026-01-12 00:03:33',NULL),(3,1,'ABS sprites','sprites for the active battle system secret of mana style',0,3,'2026-01-13 05:40:12',NULL),(4,1,'Live title screen','the title screen is actually a previous experienced event scenario replay loop...',0,4,'2026-01-13 05:41:55',NULL),(5,1,'OnlineCo-op','ability to have friends join you online with cross character progression',0,5,'2026-01-13 05:42:53',NULL),(6,1,'Split Screen','allows for couch coop split screen ????',0,6,'2026-01-13 05:43:44',NULL);

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `status` enum('planned','active','on_hold','completed','cancelled') NOT NULL DEFAULT 'planned',
  `priority` enum('low','normal','high','critical') NOT NULL DEFAULT 'normal',
  `owner_id` int NOT NULL,
  `client_user_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `progress` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (1,'RpgGame 1','based off in progress nameless book','planned','normal',1,NULL,'2026-01-11 23:14:26','2026-01-13 05:43:44','2022-12-04',NULL,0);

--
-- Table structure for table `remote_audit_logs`
--

CREATE TABLE `remote_audit_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `session_id` int DEFAULT NULL,
  `connection_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `action` varchar(80) NOT NULL,
  `ip_address` varchar(64) DEFAULT NULL,
  `user_agent` text,
  `details` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_remote_audit_session` (`session_id`),
  KEY `idx_remote_audit_action` (`action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_audit_logs`
--


--
-- Table structure for table `remote_connections`
--

CREATE TABLE `remote_connections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `protocol` enum('rdp','vnc','ssh') NOT NULL DEFAULT 'rdp',
  `hostname` varchar(255) NOT NULL,
  `port` int NOT NULL DEFAULT '3389',
  `username` varchar(255) DEFAULT NULL,
  `password_encrypted` text,
  `domain_name` varchar(255) DEFAULT NULL,
  `security_mode` varchar(50) DEFAULT NULL,
  `ignore_cert` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_connections`
--


--
-- Table structure for table `remote_screenshare_sessions`
--

CREATE TABLE `remote_screenshare_sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `remote_session_id` int DEFAULT NULL,
  `ticket_id` int DEFAULT NULL,
  `customer_user_id` int DEFAULT NULL,
  `technician_user_id` int DEFAULT NULL,
  `requested_by` int DEFAULT NULL,
  `share_token` varchar(128) NOT NULL,
  `technician_token` varchar(128) NOT NULL,
  `status` enum('pending','waiting','active','ended','expired','revoked','denied') NOT NULL DEFAULT 'pending',
  `customer_started_at` datetime DEFAULT NULL,
  `technician_joined_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `expires_at` datetime NOT NULL,
  `customer_note` text,
  `internal_note` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `share_token` (`share_token`),
  UNIQUE KEY `technician_token` (`technician_token`),
  KEY `idx_screenshare_status` (`status`),
  KEY `idx_screenshare_expires` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_screenshare_sessions`
--


--
-- Table structure for table `remote_screenshare_signals`
--

CREATE TABLE `remote_screenshare_signals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `screenshare_id` int NOT NULL,
  `sender` enum('customer','technician') NOT NULL,
  `receiver` enum('customer','technician') NOT NULL,
  `signal_type` varchar(50) NOT NULL,
  `payload` longtext NOT NULL,
  `consumed` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_signal_session_receiver` (`screenshare_id`,`receiver`,`consumed`),
  CONSTRAINT `fk_screenshare_signals_session` FOREIGN KEY (`screenshare_id`) REFERENCES `remote_screenshare_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_screenshare_signals`
--


--
-- Table structure for table `remote_sessions`
--

CREATE TABLE `remote_sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `connection_id` int NOT NULL,
  `ticket_id` int DEFAULT NULL,
  `customer_user_id` int DEFAULT NULL,
  `technician_user_id` int DEFAULT NULL,
  `requested_by` int DEFAULT NULL,
  `approval_token` varchar(128) NOT NULL,
  `launch_token` varchar(128) DEFAULT NULL,
  `status` enum('pending','approved','active','ended','expired','revoked','denied') NOT NULL DEFAULT 'pending',
  `customer_approved_at` datetime DEFAULT NULL,
  `technician_started_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `expires_at` datetime NOT NULL,
  `customer_note` text,
  `internal_note` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `approval_token` (`approval_token`),
  UNIQUE KEY `launch_token` (`launch_token`),
  KEY `idx_remote_sessions_status` (`status`),
  KEY `idx_remote_sessions_expires` (`expires_at`),
  KEY `fk_remote_sessions_connection` (`connection_id`),
  CONSTRAINT `fk_remote_sessions_connection` FOREIGN KEY (`connection_id`) REFERENCES `remote_connections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `remote_sessions`
--


--
-- Table structure for table `room_members`
--

CREATE TABLE `room_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `room_id` int NOT NULL,
  `user_id` int NOT NULL,
  `joined_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_membership` (`room_id`,`user_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `room_members_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `chat_rooms` (`id`),
  CONSTRAINT `room_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `room_members`
--


--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `visibility` enum('public','sales','staff','admin','private') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'public',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES (1,'General','2025-11-30 09:00:42','public'),(2,'TechSupport','2025-11-30 09:06:01','public'),(3,'Investment Project','2025-12-23 12:49:22','public'),(4,'Sales Questions','2026-01-07 00:26:22','public');

--
-- Table structure for table `sales_activity`
--

CREATE TABLE `sales_activity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sales_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `detail` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_activity`
--


--
-- Table structure for table `sales_inquiries`
--

CREATE TABLE `sales_inquiries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `build_id` int NOT NULL,
  `room` varchar(100) NOT NULL,
  `initial_message` text NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_inquiries`
--

INSERT INTO `sales_inquiries` VALUES (1,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 00:44:30'),(2,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 00:46:26'),(3,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:18:40'),(4,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:21:30'),(5,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:23:07'),(6,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:24:18'),(7,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:29:46'),(8,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:43:03'),(9,1,9,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 9).','2026-01-07 01:43:26'),(10,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:32:00'),(11,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:47:17'),(12,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 05:56:44'),(13,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 06:02:25'),(14,1,10,'Sales Questions','Hello, I have a question about the build: StudioExcelia-OnyxG1 (ID: 10).','2026-01-08 06:08:59');

--
-- Table structure for table `sales_notes`
--

CREATE TABLE `sales_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sales_id` int NOT NULL,
  `user_id` int NOT NULL,
  `note` text NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_notes`
--


--
-- Table structure for table `sales_queue`
--

CREATE TABLE `sales_queue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `build_id` int DEFAULT NULL,
  `message` text,
  `status` enum('lead','qualified','quote_sent','negotiation','closed_won','closed_lost') DEFAULT 'lead',
  `assigned_to` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sales_queue`
--

INSERT INTO `sales_queue` VALUES (3,3,'Henrietta Williams','henrietta.williams@testemail.com','18035651866',NULL,'New sales lead created. $350 dollar laptop package refurbished with 2 year warranty','lead',NULL,'2026-01-23 00:06:36','2026-01-23 00:08:54');

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `price` decimal(10,2) NOT NULL,
  `active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'Virus Removal Tier 1','We will scan your computer for viruses with a deeper scanner and attempt to remove the virus. This is the non intrusive method.',50.00,1),(2,'Wireless Security Camera Install','<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>ieGeek Wireless Security Camera Breakdown</title>\r\n\r\n<style>\r\nbody{\r\n    font-family: Arial, sans-serif;\r\n    background:#f4f6f9;\r\n    color:#222;\r\n    margin:0;\r\n    padding:0;\r\n    line-height:1.6;\r\n}\r\n\r\n.container{\r\n    width:90%;\r\n    max-width:1200px;\r\n    margin:auto;\r\n    padding:40px 20px;\r\n}\r\n\r\n.hero{\r\n    text-align:center;\r\n    padding:60px 20px;\r\n    background:linear-gradient(135deg,#0d1b2a,#1b263b);\r\n    color:white;\r\n    border-radius:12px;\r\n    margin-bottom:40px;\r\n}\r\n\r\n.hero h1{\r\n    font-size:48px;\r\n    margin-bottom:15px;\r\n}\r\n\r\n.hero p{\r\n    font-size:18px;\r\n    max-width:800px;\r\n    margin:auto;\r\n}\r\n\r\n.section-title{\r\n    font-size:32px;\r\n    margin-bottom:20px;\r\n    color:#0d1b2a;\r\n}\r\n\r\n.features{\r\n    display:grid;\r\n    grid-template-columns:repeat(auto-fit,minmax(250px,1fr));\r\n    gap:25px;\r\n    margin-bottom:50px;\r\n}\r\n\r\n.card{\r\n    background:white;\r\n    border-radius:12px;\r\n    overflow:hidden;\r\n    box-shadow:0 4px 12px rgba(0,0,0,0.1);\r\n    transition:0.3s;\r\n}\r\n\r\n.card:hover{\r\n    transform:translateY(-5px);\r\n}\r\n\r\n.card img{\r\n    width:100%;\r\n    height:220px;\r\n    object-fit:cover;\r\n}\r\n\r\n.card-content{\r\n    padding:20px;\r\n}\r\n\r\n.card h3{\r\n    margin-top:0;\r\n    color:#1b263b;\r\n}\r\n\r\n.pros-cons{\r\n    display:grid;\r\n    grid-template-columns:1fr 1fr;\r\n    gap:30px;\r\n    margin-top:40px;\r\n}\r\n\r\n.box{\r\n    background:white;\r\n    padding:25px;\r\n    border-radius:12px;\r\n    box-shadow:0 4px 10px rgba(0,0,0,0.08);\r\n}\r\n\r\n.box h3{\r\n    margin-top:0;\r\n}\r\n\r\nul{\r\n    padding-left:20px;\r\n}\r\n\r\ntable{\r\n    width:100%;\r\n    border-collapse:collapse;\r\n    background:white;\r\n    margin-top:40px;\r\n    border-radius:12px;\r\n    overflow:hidden;\r\n    box-shadow:0 4px 12px rgba(0,0,0,0.08);\r\n}\r\n\r\ntable th, table td{\r\n    padding:15px;\r\n    border-bottom:1px solid #ddd;\r\n    text-align:left;\r\n}\r\n\r\ntable th{\r\n    background:#1b263b;\r\n    color:white;\r\n}\r\n\r\n.footer{\r\n    text-align:center;\r\n    padding:40px 20px;\r\n    color:#777;\r\n}\r\n</style>\r\n</head>\r\n\r\n<body>\r\n\r\n<div class=\"container\">\r\n\r\n    <div class=\"hero\">\r\n        <h1>ieGeek Wireless Security Cameras</h1>\r\n        <p>\r\n            Affordable smart home surveillance featuring wireless installation,\r\n            solar-powered operation, AI motion detection, and HD night vision monitoring.\r\n        </p>\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Top Features</h2>\r\n\r\n    <div class=\"features\">\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1558002038-1055907df827?q=80&w=1200&auto=format&fit=crop\" alt=\"Outdoor Security Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>2K HD Video</h3>\r\n                <p>\r\n                    Crystal-clear video quality with enhanced color night vision\r\n                    for detailed monitoring day and night.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1509395176047-4a66953fd231?q=80&w=1200&auto=format&fit=crop\" alt=\"Solar Powered Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>Solar Powered</h3>\r\n                <p>\r\n                    Long-lasting rechargeable battery systems with optional solar charging\r\n                    reduce maintenance and downtime.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop\" alt=\"Mobile App Monitoring\">\r\n            <div class=\"card-content\">\r\n                <h3>Smart App Control</h3>\r\n                <p>\r\n                    Monitor your property remotely through mobile apps with instant\r\n                    push notifications and live video access.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1520607162513-77705c0f0d4a?q=80&w=1200&auto=format&fit=crop\" alt=\"AI Motion Detection\">\r\n            <div class=\"card-content\">\r\n                <h3>AI Motion Detection</h3>\r\n                <p>\r\n                    Intelligent motion tracking helps detect people, vehicles,\r\n                    and suspicious activity while reducing false alerts.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Popular ieGeek Models</h2>\r\n\r\n    <div class=\"features\">\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1557324232-b8917d3c3dcb?q=80&w=1200&auto=format&fit=crop\" alt=\"Outdoor Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek Solar Camera Q11</h3>\r\n                <p>\r\n                    Wireless outdoor security camera with solar charging,\r\n                    360° PTZ rotation, and 2K HD video recording.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1495435229349-e86db7bfa013?q=80&w=1200&auto=format&fit=crop\" alt=\"4G LTE Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek 4G LTE Camera</h3>\r\n                <p>\r\n                    Perfect for farms, cabins, RVs, and remote areas without Wi-Fi\r\n                    using built-in cellular connectivity.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n        <div class=\"card\">\r\n            <img src=\"https://images.unsplash.com/photo-1516321497487-e288fb19713f?q=80&w=1200&auto=format&fit=crop\" alt=\"Indoor Camera\">\r\n            <div class=\"card-content\">\r\n                <h3>ieGeek Indoor PTZ Camera</h3>\r\n                <p>\r\n                    Compact indoor monitoring system with smart tracking,\r\n                    pet monitoring, and two-way audio support.\r\n                </p>\r\n            </div>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <div class=\"pros-cons\">\r\n\r\n        <div class=\"box\">\r\n            <h3>Pros</h3>\r\n            <ul>\r\n                <li>Easy wireless installation</li>\r\n                <li>Affordable pricing</li>\r\n                <li>Solar charging options</li>\r\n                <li>AI smart motion detection</li>\r\n                <li>Color night vision support</li>\r\n                <li>Mobile app monitoring</li>\r\n            </ul>\r\n        </div>\r\n\r\n        <div class=\"box\">\r\n            <h3>Considerations</h3>\r\n            <ul>\r\n                <li>Requires stable Wi-Fi for most models</li>\r\n                <li>Cloud storage may require subscription</li>\r\n                <li>Battery life varies with activity</li>\r\n                <li>Some advanced features depend on app updates</li>\r\n            </ul>\r\n        </div>\r\n\r\n    </div>\r\n\r\n    <h2 class=\"section-title\">Feature Comparison</h2>\r\n\r\n    <table>\r\n        <tr>\r\n            <th>Feature</th>\r\n            <th>Q11 Solar</th>\r\n            <th>4G LTE</th>\r\n            <th>Indoor PTZ</th>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Resolution</td>\r\n            <td>2K HD</td>\r\n            <td>2K HD</td>\r\n            <td>2.5K HD</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Connectivity</td>\r\n            <td>Wi-Fi</td>\r\n            <td>4G LTE</td>\r\n            <td>Wi-Fi</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Solar Powered</td>\r\n            <td>Yes</td>\r\n            <td>Yes</td>\r\n            <td>No</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>PTZ Rotation</td>\r\n            <td>360°</td>\r\n            <td>360°</td>\r\n            <td>360°</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Night Vision</td>\r\n            <td>Color</td>\r\n            <td>Color</td>\r\n            <td>Infrared</td>\r\n        </tr>\r\n\r\n        <tr>\r\n            <td>Best Use</td>\r\n            <td>Home Security</td>\r\n            <td>Remote Locations</td>\r\n            <td>Indoor Monitoring</td>\r\n        </tr>\r\n    </table>\r\n\r\n    <div class=\"footer\">\r\n        © 2026 ieGeek Camera Breakdown — Smart Wireless Home Security\r\n    </div>\r\n\r\n</div>\r\n\r\n</body>\r\n</html>requires a onsite review first to see where camera can be mounted and what will be needed for full install.',130.00,1);

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

CREATE TABLE `settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  `site_name` varchar(255) NOT NULL DEFAULT 'ZPanel Omega',
  `maintenance` tinyint(1) NOT NULL DEFAULT '0',
  `current_version` varchar(50) NOT NULL DEFAULT '1.0.0',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `settings` VALUES (1,'','','ZPanel Omega',0,'1.0.0',NULL);

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int NOT NULL,
  `site_name` varchar(255) NOT NULL DEFAULT 'ZPanel Omega',
  `maintenance` tinyint(1) NOT NULL DEFAULT '0',
  `current_version` varchar(50) NOT NULL DEFAULT '1.0.0',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` VALUES (1,'StudioExceliaZeroLLC',0,'1.0.0','2026-06-02 23:37:41');

--
-- Table structure for table `subscription_billing`
--

CREATE TABLE `subscription_billing` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subscription_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `billing_status` varchar(30) NOT NULL DEFAULT 'pending',
  `paid_at` datetime DEFAULT NULL,
  `gateway` varchar(50) DEFAULT 'manual',
  `transaction_ref` varchar(150) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_subscription_billing_subscription` (`subscription_id`),
  CONSTRAINT `fk_subscription_billing_subscription` FOREIGN KEY (`subscription_id`) REFERENCES `customer_subscriptions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_billing`
--


--
-- Table structure for table `subscription_features`
--

CREATE TABLE `subscription_features` (
  `id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `feature_name` varchar(150) NOT NULL,
  `feature_value` varchar(150) DEFAULT '',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_subscription_features_plan` (`plan_id`),
  CONSTRAINT `fk_subscription_features_plan` FOREIGN KEY (`plan_id`) REFERENCES `subscription_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_features`
--

INSERT INTO `subscription_features` VALUES (1,1,'Priority Support','Included','2026-04-01 00:41:22'),(2,1,'Malware Cleanup','Included','2026-04-01 00:41:22'),(3,2,'Performance Tuning','Included','2026-04-01 00:41:22'),(4,2,'Upgrade Guidance','Included','2026-04-01 00:41:22'),(5,3,'Managed Device Support','Included','2026-04-01 00:41:22'),(6,3,'Priority Ticket Queue','Included','2026-04-01 00:41:22');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `tagline` varchar(150) DEFAULT NULL,
  `description` text,
  `monthly_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `yearly_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'Home Care','Best for home users','Routine care, security cleanup, and faster support response.',10.99,100.99,1,1,'2026-04-01 00:41:22'),(2,'Power User','For gamers and creators','Performance tuning, upgrade guidance, and priority support.',39.99,399.99,2,1,'2026-04-01 00:41:22'),(3,'Small Business IT','Managed support for business devices','Workstation support, maintenance coverage, and ticket priority.',99.99,999.99,3,1,'2026-04-01 00:41:22');

--
-- Table structure for table `system_versions`
--

CREATE TABLE `system_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(50) NOT NULL,
  `description` text,
  `backup_path` varchar(255) DEFAULT NULL,
  `applied_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `status` enum('applied','rolled_back') DEFAULT 'applied',
  `folders` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `system_versions`
--


--
-- Table structure for table `task_comments`
--

CREATE TABLE `task_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` int NOT NULL,
  `user_id` int NOT NULL,
  `comment` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `task_comments`
--


--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `status` enum('backlog','in_progress','in_review','done') NOT NULL DEFAULT 'backlog',
  `priority` enum('low','normal','high','critical') NOT NULL DEFAULT 'normal',
  `assignee_id` int DEFAULT NULL,
  `created_by` int NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `related_ticket_id` int DEFAULT NULL,
  `related_build_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tasks`
--


--
-- Table structure for table `technician_certificates`
--

CREATE TABLE `technician_certificates` (
  `technician_id` int NOT NULL,
  `certificate_id` int NOT NULL,
  PRIMARY KEY (`technician_id`,`certificate_id`),
  KEY `certificate_id` (`certificate_id`),
  CONSTRAINT `technician_certificates_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  CONSTRAINT `technician_certificates_ibfk_2` FOREIGN KEY (`certificate_id`) REFERENCES `certificates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_certificates`
--


--
-- Table structure for table `technician_certifications`
--

CREATE TABLE `technician_certifications` (
  `technician_id` int NOT NULL,
  `certification_id` int NOT NULL,
  PRIMARY KEY (`technician_id`,`certification_id`),
  KEY `certification_id` (`certification_id`),
  CONSTRAINT `technician_certifications_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE,
  CONSTRAINT `technician_certifications_ibfk_2` FOREIGN KEY (`certification_id`) REFERENCES `certifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_certifications`
--


--
-- Table structure for table `technician_events`
--

CREATE TABLE `technician_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `technician_id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `technician_id` (`technician_id`),
  CONSTRAINT `technician_events_ibfk_1` FOREIGN KEY (`technician_id`) REFERENCES `technicians` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technician_events`
--


--
-- Table structure for table `technicians`
--

CREATE TABLE `technicians` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `specialty` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `fk_technician_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `technicians`
--

INSERT INTO `technicians` VALUES (1,'Jarvis Jones','bluecometspt@gmail.com','8037201716','repair','2025-11-24 04:45:26',1);

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `dir` varchar(255) DEFAULT NULL,
  `css` text,
  `layout_config` json DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `image_url` varchar(255) DEFAULT NULL,
  `primary_color` varchar(50) DEFAULT 'dark',
  `banner_image` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT '0',
  `color` varchar(20) NOT NULL DEFAULT '#333',
  `banner` varchar(255) NOT NULL DEFAULT '/assets/images/default-banner.jpg',
  `is_default` tinyint(1) DEFAULT '0',
  `layout_style` enum('vertical_nav','horizontal_nav') NOT NULL DEFAULT 'vertical_nav',
  `debug_mode` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `themes_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` VALUES (20,'ZPanelOmega Default',NULL,NULL,NULL,NULL,'2025-11-25 10:23:03',NULL,'dark',NULL,0,'#333','/assets/images/zpobanner2.png',1,'vertical_nav',0),(21,'Default Theme',NULL,NULL,NULL,NULL,'2025-11-25 10:45:22',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',NULL,'vertical_nav',0),(22,'ZPanelOmega Blue',NULL,NULL,NULL,NULL,'2025-11-25 10:45:58',NULL,'dark',NULL,0,'#0066cc','/assets/images/zpobanner2.png',0,'vertical_nav',0),(26,'Random Theme',NULL,NULL,NULL,NULL,'2025-11-27 14:55:55',NULL,'danger','https://source.unsplash.com/1200x300/?network',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(29,'DIY PC Build',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'info','/assets/images/pc_build.jpg',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(30,'ZPanel Classic',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'primary','/assets/images/zpanel.jpg',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(31,'gamer-neon',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'danger','themes/gamer-neon/assets/images/gamer_neon.png',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(32,'Coding Matrix',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'success','https://source.unsplash.com/1200x300/?coding',0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(33,'Server Rack',NULL,NULL,NULL,NULL,'2025-11-27 15:11:18',NULL,'secondary','https://source.unsplash.com/1200x300/?server',0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(34,'Mahan',NULL,NULL,NULL,NULL,'2025-11-29 13:27:37',NULL,'dark','https://zpanelomega.exodusblue.com/themes/Mahan/assets/images/banner1Solomon.png',0,'#333','https://zpanelomega.exodusblue.com/themes/Mahan/assets/images/banner1Solomon.png',0,'vertical_nav',0),(35,'MidnightGlass',NULL,NULL,NULL,NULL,'2026-01-11 12:23:03',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(36,'AdminDash_default',NULL,NULL,NULL,NULL,'2026-01-11 12:51:32',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(37,'xenogearsgodandmind',NULL,NULL,NULL,NULL,'2026-01-20 02:08:37',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0),(41,'MidnightRepairPro',NULL,NULL,NULL,NULL,'2026-03-28 16:04:53',NULL,'dark',NULL,1,'#333','/assets/images/default-banner.jpg',0,'horizontal_nav',0),(42,'RepairMidnightPro',NULL,NULL,NULL,NULL,'2026-03-28 16:15:19',NULL,'dark',NULL,0,'#333','/assets/images/default-banner.jpg',0,'vertical_nav',0);

--
-- Table structure for table `ticket_comments`
--

CREATE TABLE `ticket_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticket_id` int NOT NULL,
  `user_id` int NOT NULL,
  `username` varchar(100) NOT NULL,
  `comment` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `ticket_comments_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ticket_comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ticket_comments`
--

INSERT INTO `ticket_comments` VALUES (1,1,1,'admin','test','2025-12-01 00:49:52');

--
-- Table structure for table `ticket_replies`
--

CREATE TABLE `ticket_replies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticket_id` int NOT NULL,
  `user_id` int NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `ticket_replies_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ticket_replies_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ticket_replies`
--


--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int DEFAULT NULL,
  `sales_id` int DEFAULT NULL,
  `build_id` int DEFAULT NULL,
  `submitted_by` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `problem_description` text,
  `notes` text,
  `priority` enum('Low','Medium','High','Critical') DEFAULT 'Low',
  `status` enum('Open','Closed') DEFAULT 'Open',
  `user_id` int NOT NULL,
  `technician_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `assigned_to` int DEFAULT NULL,
  `ticket_type` varchar(50) DEFAULT 'General Support',
  `subscription_id` int DEFAULT NULL,
  `service_level` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `technician_id` (`technician_id`),
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`technician_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` VALUES (1,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,NULL,'2025-11-25 03:50:20',NULL,NULL,'General Support',NULL,NULL),(2,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,NULL,'2025-11-25 03:51:10',NULL,NULL,'General Support',NULL,NULL),(3,NULL,NULL,NULL,'','test ticket','test ticket is a ticket test',NULL,NULL,'Low','Closed',1,2,'2025-11-25 03:51:17','2026-01-17 22:38:28',NULL,'General Support',NULL,NULL),(4,9,NULL,NULL,'admin','Laptop Purchase','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Laptop Purchase compeleted for henrietta williams usb wireless used for internet adaptation. Purchase of firestick and antenna will complete order and those will be payed for.','Low','Open',1,1,'2026-01-20 01:43:26','2026-03-29 21:12:57',1,'General Support',NULL,NULL),(5,10,NULL,NULL,'damedash666','Computer Ransomware atempt','Hey J I made a mistake and let some people into my pc and need you to help me get it fixed thanks so much!','Hey J I made a mistake and let some people into my pc and need you to help me get it fixed thanks so much!','system reimaged updated to windows 11 and 12gb of ram. antivirus installed and user personal files restored from one drive. Remote assistances apps also installed incase customer needs further remote assistance. Completed and Installed on site Malbytes antimalware added to system $100','High','Closed',10,1,'2026-03-22 00:50:37','2026-03-29 18:13:02',1,'General Support',NULL,NULL),(19,NULL,NULL,NULL,'admin','Wireless Security Camera Install - test','test','test','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: bluecometspt@gmail.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-25 20:54:00','2026-05-25 20:54:00',NULL,'General Support',NULL,'Standard'),(20,NULL,NULL,NULL,'admin','Wireless Security Camera Install - test','test','test','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: bluecometspt@gmail.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-25 21:06:13','2026-05-25 21:06:13',NULL,'General Support',NULL,'Standard'),(21,NULL,NULL,NULL,'admin','Wireless Security Camera Install - wireless set','I am inquiring about the wireless security setup','I am inquiring about the wireless security setup','Service Type: Wireless Security Camera Install\nCustomer: test\nEmail: temoneyn@yahoo.com\nPhone: 8037201716\nDevice: ','Medium','Open',1,NULL,'2026-05-30 22:20:05','2026-05-30 22:20:05',NULL,'General Support',NULL,'Standard');

--
-- Table structure for table `tos_acceptance`
--

CREATE TABLE `tos_acceptance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `tos_version` varchar(20) NOT NULL,
  `accepted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `tos_acceptance_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tos_acceptance`
--


--
-- Table structure for table `tos_versions`
--

CREATE TABLE `tos_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(20) NOT NULL,
  `content` longtext NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tos_versions`
--


--
-- Table structure for table `twitch_settings`
--

CREATE TABLE `twitch_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `channel_name` varchar(255) DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `client_secret` varchar(255) DEFAULT NULL,
  `access_token` varchar(255) DEFAULT NULL,
  `rotation_streams` text,
  `token_expires_at` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `twitch_settings`
--

INSERT INTO `twitch_settings` VALUES (1,'xowilough','c40ga904vv7xjhau98lclt3p9qsb8c','u18659uiw25azhh4cdbd9kbb7wmhvv','8rjdjx39f93i17t1s7bd25csr16kf1','nekrotechie,babybaby1111,xowilough',1778993625);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `avatar_url` varchar(255) DEFAULT NULL,
  `role` enum('admin','editor','technician','user') DEFAULT 'user',
  `status` enum('online','offline') DEFAULT 'offline',
  `last_seen` timestamp NULL DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `bio` text,
  `skills` varchar(255) DEFAULT NULL,
  `online` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin','$2y$10$Qc5tMVu7kGj/.6SPuO6wf.BnwFMZsgDgDhUgc/vGEy3uBauCusXRi','bluecometspt@gmail.com','https://preview.redd.it/48ptt9a8r3g41.jpg?width=640&crop=smart&auto=webp&s=ba84923ca410f172ffd4d7b2c23340468a7945c8','admin','online','2026-06-13 21:41:58','2025-11-24 02:36:31','',NULL,0),(2,'nekrotechie','$2y$10$LyrQdLkIblE4TD8J7JjSeeYvXzAywHdrxoPXDVmQeG5aYXh5UBnQy','jphgfx@gmail.com','','technician','offline','2026-01-19 11:46:39','2025-11-24 03:01:49','','[]',0),(3,'testsuer','$2y$10$aO.Ets9cJy5Z.k1hXHdxre0/Sc6cqCH.OWCHYh646ejrTLCzcT.1y','teseruser@email.com',NULL,'user','online','2026-01-11 21:34:49','2025-12-01 01:30:01',NULL,NULL,0),(4,'nightmare5575','$2y$10$jrSX9QASf3QsP0SpM2oSPe.Em4WX6pJnUBKFNcQE2.JDYJgwM7J46','kimgillie14@gmail.com',NULL,'user','online','2025-12-06 16:01:52','2025-12-06 14:10:29',NULL,NULL,0),(5,'test2','$2y$10$DvBaBnazIhMNMyX38D74n.btMBbYbDkTPHHhbl/bh55pJHyBblqyu','teseruser@email.com',NULL,'user','offline','2026-01-11 13:26:34','2026-01-11 13:26:34',NULL,NULL,0),(6,'theroninweb','$2y$10$GXHPQEU8O.WK6vtfWl6RJenrJodoC7ZLOKgCxNAnwD.KkcZKt2MfO','bluecometspt@gmail.com','https://preview.redd.it/48ptt9a8r3g41.jpg?width=640&crop=smart&auto=webp&s=ba84923ca410f172ffd4d7b2c23340468a7945c8','technician','offline','2026-01-18 13:26:27','2026-01-18 05:54:41','',NULL,0),(7,'ninamarie78','$2y$10$j0s81S7vOxWJp3FprU5fKuC.sbTCDzFgHMpYrkCMXClFGtljuqrpW','mrsprodigyiloveu143@gmail.com',NULL,'user','offline','2026-01-20 03:50:30','2026-01-20 03:49:57',NULL,NULL,0),(8,'henrietta','$2y$10$eR3olVNBtnALuqkF.cbPuuZTpfbOgkhGngv87p8le/qFdkhTg/OdO','henrietta.williams@testemail.com',NULL,'user','offline','2026-01-22 23:21:48','2026-01-22 23:21:48',NULL,NULL,0),(9,'Hentietta','$2y$10$1y/S.nOHEXdtsoKw5MCoreNsG3FZj7PpMIisVqAIQiddkH6fxYzk2','meshennie60@yahoo.com',NULL,'user','offline','2026-02-26 21:24:56','2026-02-26 21:22:29',NULL,NULL,0),(10,'damedash666','$2y$10$gMyD0BzqCPuie8cMkruTtebDMFZVVQZPHE.tuB8fo0lBs1bUMAI32','damedash666@yahoo.com',NULL,'user','online','2026-05-28 03:45:51','2026-03-22 00:35:57',NULL,NULL,0);

--
-- Table structure for table `vendor_sources`
--

CREATE TABLE `vendor_sources` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vendor` varchar(50) NOT NULL,
  `category` enum('CPU','Motherboard','RAM','GPU','PSU','OS') NOT NULL,
  `endpoint` varchar(500) NOT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vendor_sources`
--


--
-- Dumping events for database 'zpanelomega_db'
--

--
-- Dumping routines for database 'zpanelomega_db'
--


