Index: database/drizzle/util/seed.ts =================================================================== --- database/drizzle/util/seed.ts (revision 3a9c59cba2839f8be6bd0a5327349ee3883c2ee4) +++ database/drizzle/util/seed.ts (revision a5084806a09c4abfab269ed52d3659d37394a106) @@ -3,31 +3,31 @@ const dataSQL = ` TRUNCATE TABLE - suggestions, - cooler_cpu_sockets, - case_mobo_form_factors, - case_ps_form_factors, - case_storage_form_factors, - build_component, - favorite_build, - rating_build, - review, - build, - admins, - users, - network_card, - network_adapter, - cables, - sound_card, - optical_drive, - memory_card, - storage, - motherboard, - cooler, - pc_case, - power_supply, - memory, - gpu, - cpu, - components +suggestions, +cooler_cpu_sockets, +case_mobo_form_factors, +case_ps_form_factors, +case_storage_form_factors, +build_component, +favorite_build, +rating_build, +review, +build, +admins, +users, +network_card, +network_adapter, +cables, +sound_card, +optical_drive, +memory_card, +storage, +motherboard, +cooler, +pc_case, +power_supply, +memory, +gpu, +cpu, +components RESTART IDENTITY CASCADE; @@ -48,18 +48,16 @@ INSERT INTO components (name, brand, price, type, img_url) VALUES -('Ryzen 5 5600X', 'AMD', 199.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-5600.png'), -('RTX 3060', 'NVIDIA', 329.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3060.png'), -('16GB DDR4 Kit', 'Corsair', 79.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), -('650W PSU', 'EVGA', 89.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), -('Mid Tower Case', 'NZXT', 119.99, 'case', 'https://nzxt.com/cdn/shop/files/h5-elite-hero-black.png?v=1744789660&width=2000'), -('Air Cooler', 'Noctua', 69.99, 'cooler', 'https://cdn.brandfetch.io/idSeoCDyH9/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), -('B550 Motherboard', 'ASUS', 149.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), -('1TB NVMe SSD', 'Samsung', 129.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), -('Sound Card', 'Creative', 59.99, 'sound_card', NULL), -('Network Card', 'Intel', 39.99, 'network_card', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), -('Network Adapter', 'TP-Link', 29.99, 'network_adapter', 'https://cdn.brandfetch.io/idfUqCiOVX/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), -('Optical Drive', 'LG', 19.99, 'optical_drive', 'https://cdn.brandfetch.io/idEI6u48uh/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), -('Memory Card', 'SanDisk', 15.99, 'memory_card', 'https://cdn.brandfetch.io/idM3tf3Iq8/w/800/h/800/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Air Cooler', 'Noctua', 69.99, 'cooler', 'https://cdn.brandfetch.io/idSeoCDyH9/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('B550 Motherboard', 'ASUS', 149.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('1TB NVMe SSD', 'Samsung', 129.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Sound Card', 'Creative', 59.99, 'sound_card', 'https://cdn.brandfetch.io/idkZSfybrG/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Network Card', 'Intel', 39.99, 'network_card', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Network Adapter', 'TP-Link', 29.99, 'network_adapter', 'https://cdn.brandfetch.io/idfUqCiOVX/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Optical Drive', 'LG', 19.99, 'optical_drive', 'https://cdn.brandfetch.io/idEI6u48uh/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Storage Card', 'SanDisk', 15.99, 'memory_card', 'https://cdn.brandfetch.io/idM3tf3Iq8/w/800/h/800/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Cables Pack', 'Corsair', 9.99, 'cables', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), + +-- CPUS +('Ryzen 5 5600X', 'AMD', 199.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-5600.png'), ('Ryzen 5 7600', 'AMD', 229.00, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-7600.png'), ('Ryzen 7 7800X3D', 'AMD', 399.00, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-7-7800x3d.png'), @@ -69,4 +67,27 @@ ('Core i7-14700K', 'Intel', 409.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i7-14700k.png'), ('Core i9-14900KS', 'Intel', 689.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i9-14900ks.png'), +('Ryzen 5 3600', 'AMD', 149.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-3600.png'), +('Ryzen 7 3700X', 'AMD', 189.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-7-3700x.png'), +('Ryzen 5 5600', 'AMD', 179.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-5600.png'), +('Ryzen 7 5700X', 'AMD', 219.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-7-5700x.png'), +('Ryzen 9 5900X', 'AMD', 349.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-9-5900x.png'), +('Core i5-12400F', 'Intel', 159.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i5-12400.png'), +('Core i7-12700K', 'Intel', 299.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i7-12700k.png'), +('Core i5-10400F', 'Intel', 129.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i5-10400.png'), +('Core i7-11700K', 'Intel', 249.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i7-11700k.png'), +('Core i9-12900K', 'Intel', 449.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i9-12900k.png'), +('Ryzen 3 3200G', 'AMD', 99.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-3-3200g.png'), +('Ryzen 5 3600X', 'AMD', 199.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-3600x.png'), +('Ryzen 9 3900X', 'AMD', 399.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-9-3900x.png'), +('Ryzen 5 5600G', 'AMD', 159.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-5-5600g.png'), +('Ryzen 7 5800X', 'AMD', 299.99, 'cpu', 'https://static.hardwaredb.net/badges/ryzen-7-5800x.png'), +('Core i3-10100F', 'Intel', 89.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i3-10100.png'), +('Core i3-12100F', 'Intel', 109.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i3-12100.png'), +('Core i5-11400F', 'Intel', 139.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i5-11400.png'), +('Core i9-10900K', 'Intel', 399.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i9-10900k.png'), +('Core i5-13400F', 'Intel', 199.99, 'cpu', 'https://static.hardwaredb.net/badges/core-i5-13400.png'), + +-- GPUS +('RTX 3060', 'NVIDIA', 329.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3060.png'), ('Radeon RX 6600', 'PowerColor', 199.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6600.png'), ('Radeon RX 7600', 'Sapphire', 269.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-7600.png'), @@ -78,24 +99,221 @@ ('GeForce RTX 4080 Super', 'Gigabyte', 999.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4080-super.png'), ('GeForce RTX 4090', 'NVIDIA', 1599.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4090.png'), +('GeForce RTX 3060 Ti', 'EVGA', 399.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3060-ti.png'), +('GeForce RTX 3070', 'MSI', 499.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3070.png'), +('GeForce RTX 3070 Ti', 'Gigabyte', 549.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3070-ti.png'), +('GeForce RTX 3080', 'ASUS', 699.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3080.png'), +('GeForce RTX 3090', 'NVIDIA', 1499.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-3090.png'), +('GeForce RTX 4060 Ti', 'Zotac', 399.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4060-ti.png'), +('GeForce RTX 4070', 'MSI', 549.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4070.png'), +('GeForce RTX 4070 Ti', 'Gigabyte', 749.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4070-ti.png'), +('GeForce RTX 4080', 'ASUS', 1199.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-4080.png'), +('GeForce RTX 2060', 'EVGA', 299.99, 'gpu', 'https://static.hardwaredb.net/badges/geforce-rtx-2060.png'), +('Radeon RX 6700 XT', 'Sapphire', 379.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6700-xt.png'), +('Radeon RX 6800', 'PowerColor', 479.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6800.png'), +('Radeon RX 6800 XT', 'XFX', 579.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6800-xt.png'), +('Radeon RX 6900 XT', 'Sapphire', 699.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6900-xt.png'), +('Radeon RX 7700 XT', 'XFX', 449.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-7700-xt.png'), +('Radeon RX 7900 XT', 'Sapphire', 849.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-7900-xt.png'), +('Radeon RX 6650 XT', 'PowerColor', 279.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6650-xt.png'), +('Radeon RX 6750 XT', 'XFX', 329.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-6750-xt.png'), +('Radeon RX 5700 XT', 'Sapphire', 349.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-5700-xt.png'), +('Radeon RX 5600 XT', 'PowerColor', 259.99, 'gpu', 'https://static.hardwaredb.net/badges/radeon-rx-5600-xt.png'), +('Arc A770', 'Intel', 349.99, 'gpu', 'https://static.hardwaredb.net/badges/arc-a770.png'), +('Arc A750', 'Intel', 289.99, 'gpu', 'https://static.hardwaredb.net/badges/arc-a750.png'), +('Arc A580', 'Intel', 179.99, 'gpu', 'https://static.hardwaredb.net/badges/arc-a580.png'), +('Arc A380', 'Intel', 139.99, 'gpu', 'https://static.hardwaredb.net/badges/arc-a380.png'), +('Arc A310', 'Intel', 99.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Arc B580', 'Intel', 249.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Arc B570', 'Intel', 219.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Arc A350M', 'Intel', 199.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Arc Pro A60', 'Intel', 449.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Arc Pro A40', 'Intel', 299.99, 'gpu', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- MOTHERBOARDS +('B450 Tomahawk Max', 'MSI', 109.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('B550-A Pro', 'MSI', 139.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('X570 AORUS Elite', 'Gigabyte', 189.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('B550M TUF Gaming', 'ASUS', 119.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('X570 Unify', 'MSI', 279.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('B650 AORUS Elite AX', 'Gigabyte', 199.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('X670 Gaming Plus WiFi', 'MSI', 249.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('B650E TUF Gaming', 'ASUS', 229.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('X670E Taichi', 'ASRock', 399.99, 'motherboard', 'https://d1yjjnpx0p53s8.cloudfront.net/styles/logo-thumbnail/s3/0013/7800/brand.gif?itok=5s1HB6L_'), +('B550 Phantom Gaming', 'ASRock', 129.99, 'motherboard', 'https://d1yjjnpx0p53s8.cloudfront.net/styles/logo-thumbnail/s3/0013/7800/brand.gif?itok=5s1HB6L_'), +('B660M Pro RS', 'ASRock', 109.99, 'motherboard', 'https://d1yjjnpx0p53s8.cloudfront.net/styles/logo-thumbnail/s3/0013/7800/brand.gif?itok=5s1HB6L_'), +('B660 Gaming X DDR4', 'Gigabyte', 139.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('H610M-E', 'ASUS', 89.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Z690 AORUS Pro', 'Gigabyte', 299.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('Z690 Edge WiFi DDR4', 'MSI', 259.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('B760M DS3H DDR4', 'Gigabyte', 119.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('Z790 TUF Gaming', 'ASUS', 349.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('B760 Tomahawk WiFi', 'MSI', 189.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), +('Z790 AORUS Elite', 'Gigabyte', 269.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), +('H670 Steel Legend', 'ASRock', 159.99, 'motherboard', 'https://d1yjjnpx0p53s8.cloudfront.net/styles/logo-thumbnail/s3/0013/7800/brand.gif?itok=5s1HB6L_'), ('B650M DS3H', 'Gigabyte', 149.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), ('X670E AORUS Master', 'Gigabyte', 459.99, 'motherboard', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), ('B760M Bomber WiFi', 'MSI', 129.99, 'motherboard', 'https://images.seeklogo.com/logo-png/30/1/msi-logo-png_seeklogo-304877.png'), ('Z790 Maximus Hero', 'ASUS', 599.99, 'motherboard', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- RAM MODULES +('16GB DDR4 Kit', 'Corsair', 79.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Vengeance LPX 8GB', 'Corsair', 24.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Ripjaws V 16GB', 'G.Skill', 34.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Fury Beast 16GB', 'Kingston', 39.99, 'memory', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Elite 32GB Kit', 'TeamGroup', 59.99, 'memory', 'https://cdn.brandfetch.io/id8A5bRNKu/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Vengeance RGB Pro 32GB', 'Corsair', 79.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Trident Z RGB 16GB', 'G.Skill', 49.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Aegis 16GB Kit', 'G.Skill', 29.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('HyperX Fury 32GB', 'Kingston', 69.99, 'memory', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Ballistix 16GB', 'Crucial', 39.99, 'memory', 'https://cdn.brandfetch.io/idcQwroMOv/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Value RAM 8GB', 'Corsair', 19.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Trident Z5 16GB', 'G.Skill', 64.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Dominator Platinum 32GB', 'Corsair', 159.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Fury Beast DDR5 16GB', 'Kingston', 69.99, 'memory', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Vengeance DDR5 32GB', 'Corsair', 119.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Trident Z5 RGB 64GB', 'G.Skill', 249.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Elite DDR5 32GB', 'TeamGroup', 109.99, 'memory', 'https://cdn.brandfetch.io/id8A5bRNKu/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Fury Beast DDR5 32GB', 'Kingston', 129.99, 'memory', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Vengeance RGB DDR5 64GB', 'Corsair', 249.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('T-Force Delta RGB 32GB', 'TeamGroup', 99.99, 'memory', 'https://cdn.brandfetch.io/id8A5bRNKu/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Flare X5 32GB', 'G.Skill', 134.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Vengeance LPX 16GB', 'Corsair', 39.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), ('Ripjaws V 32GB', 'G.Skill', 69.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Trident Z5 RGB 32GB', 'G.Skill', 114.99, 'memory', 'https://cdn.brandfetch.io/id8HgeVn1l/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Dominator Platinum 64GB', 'Corsair', 289.99, 'memory', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), + +-- STORAGE DEVICES +('Samsung 870 EVO 500GB', 'Samsung', 54.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Samsung 870 QVO 1TB', 'Samsung', 89.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WD Blue 1TB', 'Western Digital', 49.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Crucial MX500 2TB', 'Crucial', 149.99, 'storage', 'https://cdn.brandfetch.io/idcQwroMOv/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Kingston A400 480GB', 'Kingston', 34.99, 'storage', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Samsung 980 Pro 1TB', 'Samsung', 119.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WD Black SN770 1TB', 'Western Digital', 89.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Crucial P5 Plus 2TB', 'Crucial', 159.99, 'storage', 'https://cdn.brandfetch.io/idcQwroMOv/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Samsung 980 500GB', 'Samsung', 49.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WD Blue SN580 1TB', 'Western Digital', 69.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Kingston KC3000 1TB', 'Kingston', 99.99, 'storage', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Seagate Barracuda 2TB', 'Seagate', 54.99, 'storage', 'https://cdn.brandfetch.io/id5NUik-_s/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WD Blue 4TB HDD', 'Western Digital', 79.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Seagate IronWolf 4TB', 'Seagate', 99.99, 'storage', 'https://cdn.brandfetch.io/id5NUik-_s/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Toshiba X300 6TB', 'Toshiba', 139.99, 'storage', 'https://cdn.brandfetch.io/idC7lwdfzx/w/200/h/200/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WD Black 6TB HDD', 'Western Digital', 179.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Seagate Barracuda 8TB', 'Seagate', 149.99, 'storage', 'https://cdn.brandfetch.io/id5NUik-_s/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Crucial BX500 1TB', 'Crucial', 59.99, 'storage', 'https://cdn.brandfetch.io/idcQwroMOv/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Samsung 870 EVO 2TB', 'Samsung', 179.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Kingston NV2 2TB', 'Kingston', 109.99, 'storage', 'https://cdn.brandfetch.io/idQrDf3A8-/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Crucial P3 1TB', 'Crucial', 64.99, 'storage', 'https://cdn.brandfetch.io/idcQwroMOv/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('WD Black SN850X 2TB', 'Western Digital', 159.99, 'storage', 'https://cdn.brandfetch.io/id6bAnMJ1y/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Samsung 990 Pro 4TB', 'Samsung', 349.99, 'storage', 'https://cdn.brandfetch.io/iduaw_nOnR/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- CASES +('H5 Elite Hero', 'NZXT', 119.99, 'case', 'https://nzxt.com/cdn/shop/files/h5-elite-hero-black.png?v=1744789660&width=2000'), +('H510 Elite', 'NZXT', 149.99, 'case', 'https://nzxt.com/cdn/shop/files/h5-elite-hero-white.png?crop=center&height=1200&v=1762528056&width=1200'), +('H7 Flow', 'NZXT', 129.99, 'case', 'https://nzxt.com/cdn/shop/files/h7-flow-hero-white.png?v=1762528078&width=1000'), +('5000D Airflow', 'Corsair', 164.99, 'case', 'https://assets.corsair.com/image/upload/c_pad,q_auto,h_1024,w_1024,f_auto/products/Cases/base-5000d-airflow/Gallery/5000D_AF_WHITE_001.webp'), +('4000D RGB', 'Corsair', 134.99, 'case', 'https://assets.corsair.com/image/upload/c_pad,q_auto,h_1024,w_1024,f_auto/products/Cases/CC-9011240-WW/iCUE-4000D-RGB-AIRFLOW-Mid-Tower-Case_-Black---3x-AF120-RGB-ELITE-Fans---iCUE-Lighting-Node-PRO-Controller---High-airflow-Design-_CN_-0.webp'), +('iCUE 5000X RGB', 'Corsair', 179.99, 'case', 'https://assets.corsair.com/image/upload/c_pad,q_auto,h_1024,w_1024,f_auto/products/Cases/base-5000x/Gallery/5000X_RGB_BLACK_27.webp?width=1080&quality=85&auto=webp&format=pjpg'), +('O11 Dynamic XL', 'Lian Li', 199.99, 'case', 'https://ddstore.mk/media/catalog/product/cache/0ee050c3ffc3555709b9bb6062f4d7e9/1/0/1005459-product_11887_0.png'), +('Lancool 216', 'Lian Li', 109.99, 'case', 'https://lian-li.com/wp-content/uploads/2022/11/1007_136-b.jpg'), +('Meshify 2 Compact', 'Fractal Design', 119.99, 'case', 'https://www.fractal-design.com/app/uploads/2021/01/Standard-Studio_Meshify2Compact_Black_TGD_Standard_6.-Left-Front.jpg'), +('Define 7', 'Fractal Design', 169.99, 'case', 'https://www.fractal-design.com/app/uploads/2020/10/Define_7_TGD_Black_Left_Front-810x810.jpg'), +('Torrent Compact', 'Fractal Design', 179.99, 'case', 'https://www.fractal-design.com/app/uploads/2022/01/Torrent_Compact_Black_RGB_TGL_1-Left-Front.jpg'), +('View 51 TG', 'Thermaltake', 139.99, 'case', 'https://www.thermaltake.com/media/catalog/product/cache/cc8b24283b13da6bc2ff91682c03b54b/v/i/view51tg_1.jpg'), +('Core P3 TG', 'Thermaltake', 149.99, 'case', 'https://www.thermaltake.com/media/catalog/product/cache/6af153fd0a0c509bdfcdfb60a394dd9c/c/o/core_p3_new_5.jpg'), +('H440', 'NZXT', 109.99, 'case', 'https://static.bhphoto.com/images/images500x500/1449769831_1204996.jpg'), +('P500A', 'Phanteks', 149.99, 'case', 'https://files.pccasegear.com/images/1594876098-PH-EC500ATG_DBK01-thb3.jpg'), +('Pure Base 500DX', 'Be Quiet', 109.99, 'case', 'https://www.techpowerup.com/review/be-quiet-pure-base-500dx-rgb-atx-chassis/images/small.png'), +('H500', 'Cooler Master', 119.99, 'case', 'https://a.storyblok.com/f/281110/819c3bb0a3/mch500_g2.png/m/1440x0/smart'), +('RL08', 'Silverstone', 89.99, 'case', 'https://www.silverstonetek.com/upload/detail/pro_20220426123228_1.jpg'), +('Air 100 ARGB', 'Montech', 69.99, 'case', 'https://www.montechpc.com/images/375613?stamp=1734689091'), +('CC560', 'Deepcool', 59.99, 'case', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTL4Zf68opHbG86D31NTVI3Y4AQhXE1PBYPjw&s'), +('DF700 Flux', 'Antec', 159.99, 'case', 'https://www.antec.com/product/case/images/gallery-df700-flux-01.jpg'), ('H5 Flow', 'NZXT', 94.99, 'case', 'https://nzxt.com/cdn/shop/files/h5-flow-rgb-h5-flow-rgb-primary-lg.png?v=1744863470&width=2000'), ('4000D Airflow', 'Corsair', 104.99, 'case', 'https://assets.corsair.com/image/upload/c_pad,q_auto,h_1024,w_1024,f_auto/products/Cases/base-4000d-airflow-config/Gallery/4000D_AF_BLACK_01.webp'), ('O11 Dynamic Evo', 'Lian Li', 159.99, 'case', 'https://www.pbtech.co.nz/imgprod/C/H/CHALAN2074__1.jpg?h=2971221114'), ('Versa H18', 'Thermaltake', 49.99, 'case', 'https://cdn.mwave.com.au/images/400/AC11503_2.jpg'), + +-- PSUs +('650W PSU', 'EVGA', 89.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Smart 450W', 'Thermaltake', 34.99, 'power_supply', 'https://cdn.brandfetch.io/idkwuFYTlH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('CV550', 'Corsair', 49.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('BR600W', 'EVGA', 59.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('CX650M', 'Corsair', 79.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('SuperNOVA 750 G6', 'EVGA', 109.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('RM850x', 'Corsair', 134.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Toughpower GF1 850W', 'Thermaltake', 119.99, 'power_supply', 'https://cdn.brandfetch.io/idkwuFYTlH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('HX1000i', 'Corsair', 199.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('SuperNOVA 1200 P2', 'EVGA', 229.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('RM1000x Shift', 'Corsair', 219.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), ('Smart 500W', 'Thermaltake', 39.99, 'power_supply', 'https://cdn.brandfetch.io/idkwuFYTlH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('RM750e', 'Corsair', 99.99, 'power_supply', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), ('SuperNOVA 1000 GT', 'EVGA', 169.99, 'power_supply', 'https://cdn.brandfetch.io/iddPf9bbl3/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- COOLERS +('Hyper 212 RGB Black', 'Cooler Master', 44.99, 'cooler', 'https://cdn.brandfetch.io/idestV9Dp7/theme/dark/logo.svg?c=1dxbfHSJFAPEGdCLU4o5B'), +('NH-D15', 'Noctua', 109.99, 'cooler', 'https://cdn.brandfetch.io/idSeoCDyH9/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Dark Rock Pro 4', 'Be Quiet', 89.99, 'cooler', 'https://cdn.brandfetch.io/idl3sdUGQK/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('NH-U12S', 'Noctua', 69.99, 'cooler', 'https://cdn.brandfetch.io/idSeoCDyH9/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Vetroo V5', 'Vetroo', 29.99, 'cooler', 'https://cdn.brandfetch.io/idTMdoBX11/w/500/h/500/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Assassin X 120 Refined', 'Thermalright', 19.99, 'cooler', 'https://cdn.brandfetch.io/id2Wov4r9a/w/339/h/339/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Pure Rock 2', 'Be Quiet', 49.99, 'cooler', 'https://cdn.brandfetch.io/idl3sdUGQK/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Fuma 3', 'Scythe', 64.99, 'cooler', 'https://cdn.brandfetch.io/ide9kDI3oQ/w/200/h/166/theme/light/logo.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('Kraken X63', 'NZXT', 149.99, 'cooler', 'https://cdn.brandfetch.io/id6LxRitGO/w/1080/h/1080/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('iCUE H100i Elite', 'Corsair', 149.99, 'cooler', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('iCUE H150i Elite LCD', 'Corsair', 289.99, 'cooler', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('Castle 280 RGB', 'Deepcool', 119.99, 'cooler', 'https://cdn.brandfetch.io/iddrVAMC1d/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('MasterLiquid ML240L', 'Cooler Master', 79.99, 'cooler', 'https://cdn.brandfetch.io/idestV9Dp7/theme/dark/logo.svg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Liquid Freezer II 360', 'Arctic', 119.99, 'cooler', 'https://cdn.brandfetch.io/idPggLGOPA/w/2007/h/2195/theme/dark/logo.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('EK-AIO 240 D-RGB', 'EK Water Blocks', 109.99, 'cooler', 'https://cdn.brandfetch.io/idEOY10s6I/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), ('Peerless Assassin 120 SE', 'Thermalright', 33.90, 'cooler', 'https://cdn.brandfetch.io/id2Wov4r9a/w/339/h/339/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), -('Kraken Elite 360', 'NZXT', 279.99, 'cooler', 'https://cdn.brandfetch.io/id6LxRitGO/w/1080/h/1080/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'); +('Kraken Elite 360', 'NZXT', 279.99, 'cooler', 'https://cdn.brandfetch.io/id6LxRitGO/w/1080/h/1080/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- SOUND CARDS +('Sound BlasterX AE-5 Plus', 'Creative', 149.99, 'sound_card', 'https://cdn.brandfetch.io/idkZSfybrG/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Xonar SE', 'ASUS', 44.99, 'sound_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Sound Blaster Z', 'Creative', 89.99, 'sound_card', 'https://cdn.brandfetch.io/idkZSfybrG/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Audigy FX', 'Creative', 39.99, 'sound_card', 'https://cdn.brandfetch.io/idkZSfybrG/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Xonar U7', 'ASUS', 79.99, 'sound_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- NETWORK CARDS +('PRO/1000 PT', 'Intel', 49.99, 'network_card', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('TG-3468', 'TP-Link', 24.99, 'network_card', 'https://cdn.brandfetch.io/idfUqCiOVX/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('PCE-AC68', 'ASUS', 69.99, 'network_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('XG-C100C', 'ASUS', 99.99, 'network_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Killer E3100G', 'Intel', 54.99, 'network_card', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- NETWORK ADAPTERS +('Archer TX3000E', 'TP-Link', 49.99, 'network_adapter', 'https://cdn.brandfetch.io/idfUqCiOVX/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('AX200', 'Intel', 34.99, 'network_adapter', 'https://cdn.brandfetch.io/idTGhLyv09/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('PCE-AXE5400', 'ASUS', 89.99, 'network_adapter', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Archer T6E', 'TP-Link', 39.99, 'network_adapter', 'https://cdn.brandfetch.io/idfUqCiOVX/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('WN7200ND', 'Rosewill', 19.99, 'network_adapter', 'https://cdn.brandfetch.io/idyFoDrbp8/w/1298/h/471/theme/dark/logo.png?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- MEMORY CARDS +('M.2 NVMe Adapter Card', 'ASUS', 24.99, 'memory_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Dual M.2 PCIe Card', 'Silverstone', 29.99, 'memory_card', 'https://cdn.brandfetch.io/idV16xgPJT/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Quad M.2 RAID Card', 'ASUS', 89.99, 'memory_card', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('U.2 NVMe Adapter', 'StarTech', 49.99, 'memory_card', 'https://cdn.brandfetch.io/idXnrkx-Wc/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Triple M.2 Expansion', 'Gigabyte', 44.99, 'memory_card', 'https://images.seeklogo.com/logo-png/39/1/gigabyte-logo-png_seeklogo-398170.png'), + +-- OPTICAL DRIVE +('DVD-RW Drive', 'ASUS', 21.99, 'optical_drive', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Slim DVD Writer', 'LG', 24.99, 'optical_drive', 'https://cdn.brandfetch.io/idEI6u48uh/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('BDR-XD07B', 'Pioneer', 89.99, 'optical_drive', 'https://cdn.brandfetch.io/idWn73vTFp/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('BP60NB10', 'LG', 69.99, 'optical_drive', 'https://cdn.brandfetch.io/idEI6u48uh/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Blu-ray Writer', 'ASUS', 79.99, 'optical_drive', 'https://cdn.brandfetch.io/idGnlhbTXH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), + +-- CABLES +('USB 3.0 Extension 6ft', 'Cable Matters', 8.99, 'cables', 'https://cdn.brandfetch.io/idvRXtmRRE/w/350/h/350/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('SATA III Cable 3-Pack', 'Monoprice', 6.99, 'cables', 'https://cdn.brandfetch.io/id7CYiuB0p/theme/dark/logo.svg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Premium Sleeved Cables', 'Corsair', 79.99, 'cables', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('DisplayPort 1.4 Cable', 'Cable Matters', 12.99, 'cables', 'https://cdn.brandfetch.io/idvRXtmRRE/w/350/h/350/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('USB-C to USB-A Cable', 'Anker', 9.99, 'cables', 'https://cdn.brandfetch.io/idZx11xCTE/theme/dark/logo.svg?c=1dxbfHSJFAPEGdCLU4o5B'), +('HDMI 2.1 Cable 10ft', 'Cable Matters', 15.99, 'cables', 'https://cdn.brandfetch.io/idvRXtmRRE/w/350/h/350/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('PWM Fan Splitter Cable', 'Noctua', 7.99, 'cables', 'https://cdn.brandfetch.io/idSeoCDyH9/w/400/h/400/theme/dark/icon.png?c=1dxbfHSJFAPEGdCLU4o5B'), +('RGB LED Strip Extension', 'Corsair', 14.99, 'cables', 'https://cwsmgmt.corsair.com/press/CORSAIRLogo2020_stack_W.png'), +('PCIe 4.0 Riser Cable', 'Thermaltake', 49.99, 'cables', 'https://cdn.brandfetch.io/idkwuFYTlH/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'), +('Molex to SATA Power', 'StarTech', 5.99, 'cables', 'https://cdn.brandfetch.io/idXnrkx-Wc/w/400/h/400/theme/dark/icon.jpeg?c=1dxbfHSJFAPEGdCLU4o5B'); INSERT INTO cpu (component_id, socket, cores, threads, base_clock, boost_clock, tdp) VALUES @@ -107,5 +325,25 @@ ((SELECT id FROM components WHERE name='Core i5-13600K'), 'LGA1700', 14, 20, 3.5, 5.1, 125), ((SELECT id FROM components WHERE name='Core i7-14700K'), 'LGA1700', 20, 28, 3.4, 5.6, 125), -((SELECT id FROM components WHERE name='Core i9-14900KS'), 'LGA1700', 24, 32, 3.2, 6.2, 150); +((SELECT id FROM components WHERE name='Core i9-14900KS'), 'LGA1700', 24, 32, 3.2, 6.2, 150), +((SELECT id FROM components WHERE name='Ryzen 5 3600'), 'AM4', 6, 12, 3.6, 4.2, 65), +((SELECT id FROM components WHERE name='Ryzen 7 3700X'), 'AM4', 8, 16, 3.6, 4.4, 65), +((SELECT id FROM components WHERE name='Ryzen 5 5600'), 'AM4', 6, 12, 3.5, 4.4, 65), +((SELECT id FROM components WHERE name='Ryzen 7 5700X'), 'AM4', 8, 16, 3.4, 4.6, 65), +((SELECT id FROM components WHERE name='Ryzen 9 5900X'), 'AM4', 12, 24, 3.7, 4.8, 105), +((SELECT id FROM components WHERE name='Core i5-12400F'), 'LGA1700', 6, 12, 2.5, 4.4, 65), +((SELECT id FROM components WHERE name='Core i7-12700K'), 'LGA1700', 12, 20, 3.6, 5.0, 125), +((SELECT id FROM components WHERE name='Core i5-10400F'), 'LGA1200', 6, 12, 2.9, 4.3, 65), +((SELECT id FROM components WHERE name='Core i7-11700K'), 'LGA1200', 8, 16, 3.6, 5.0, 125), +((SELECT id FROM components WHERE name='Core i9-12900K'), 'LGA1700', 16, 24, 3.2, 5.2, 125), +((SELECT id FROM components WHERE name='Ryzen 3 3200G'), 'AM4', 4, 4, 3.6, 4.0, 65), +((SELECT id FROM components WHERE name='Ryzen 5 3600X'), 'AM4', 6, 12, 3.8, 4.4, 95), +((SELECT id FROM components WHERE name='Ryzen 9 3900X'), 'AM4', 12, 24, 3.8, 4.6, 105), +((SELECT id FROM components WHERE name='Ryzen 5 5600G'), 'AM4', 6, 12, 3.9, 4.4, 65), +((SELECT id FROM components WHERE name='Ryzen 7 5800X'), 'AM4', 8, 16, 3.8, 4.7, 105), +((SELECT id FROM components WHERE name='Core i3-10100F'), 'LGA1200', 4, 8, 3.6, 4.3, 65), +((SELECT id FROM components WHERE name='Core i3-12100F'), 'LGA1700', 4, 8, 3.3, 4.3, 58), +((SELECT id FROM components WHERE name='Core i5-11400F'), 'LGA1200', 6, 12, 2.6, 4.4, 65), +((SELECT id FROM components WHERE name='Core i9-10900K'), 'LGA1200', 10, 20, 3.7, 5.3, 125), +((SELECT id FROM components WHERE name='Core i5-13400F'), 'LGA1700', 10, 16, 2.5, 4.6, 65); INSERT INTO gpu (component_id, vram, tdp, base_clock, boost_clock, chipset, length) VALUES @@ -119,12 +357,62 @@ ((SELECT id FROM components WHERE name='GeForce RTX 4070 Super'), 12, 220, 1.9, 2.5, 'RTX 4070 S', 260), ((SELECT id FROM components WHERE name='GeForce RTX 4080 Super'), 16, 320, 2.2, 2.5, 'RTX 4080 S', 300), -((SELECT id FROM components WHERE name='GeForce RTX 4090'), 24, 450, 2.2, 2.5, 'RTX 4090', 340); +((SELECT id FROM components WHERE name='GeForce RTX 4090'), 24, 450, 2.2, 2.5, 'RTX 4090', 340), +((SELECT id FROM components WHERE name='GeForce RTX 3060 Ti'), 8, 200, 1.41, 1.67, 'RTX 3060 Ti', 242), +((SELECT id FROM components WHERE name='GeForce RTX 3070'), 8, 220, 1.5, 1.73, 'RTX 3070', 242), +((SELECT id FROM components WHERE name='GeForce RTX 3070 Ti'), 8, 290, 1.58, 1.77, 'RTX 3070 Ti', 267), +((SELECT id FROM components WHERE name='GeForce RTX 3080'), 10, 320, 1.44, 1.71, 'RTX 3080', 285), +((SELECT id FROM components WHERE name='GeForce RTX 3090'), 24, 350, 1.4, 1.7, 'RTX 3090', 313), +((SELECT id FROM components WHERE name='GeForce RTX 4060 Ti'), 8, 160, 2.3, 2.5, 'RTX 4060 Ti', 244), +((SELECT id FROM components WHERE name='GeForce RTX 4070'), 12, 200, 1.9, 2.48, 'RTX 4070', 242), +((SELECT id FROM components WHERE name='GeForce RTX 4070 Ti'), 12, 285, 2.3, 2.6, 'RTX 4070 Ti', 267), +((SELECT id FROM components WHERE name='GeForce RTX 4080'), 16, 320, 2.2, 2.51, 'RTX 4080', 304), +((SELECT id FROM components WHERE name='GeForce RTX 2060'), 6, 160, 1.37, 1.68, 'RTX 2060', 229), +((SELECT id FROM components WHERE name='Radeon RX 6700 XT'), 12, 230, 2.3, 2.58, 'RX 6700 XT', 267), +((SELECT id FROM components WHERE name='Radeon RX 6800'), 16, 250, 1.7, 2.1, 'RX 6800', 267), +((SELECT id FROM components WHERE name='Radeon RX 6800 XT'), 16, 300, 1.82, 2.25, 'RX 6800 XT', 267), +((SELECT id FROM components WHERE name='Radeon RX 6900 XT'), 16, 300, 1.83, 2.25, 'RX 6900 XT', 267), +((SELECT id FROM components WHERE name='Radeon RX 7700 XT'), 12, 245, 2.2, 2.54, 'RX 7700 XT', 260), +((SELECT id FROM components WHERE name='Radeon RX 7900 XT'), 20, 315, 2.0, 2.4, 'RX 7900 XT', 287), +((SELECT id FROM components WHERE name='Radeon RX 6650 XT'), 8, 180, 2.06, 2.64, 'RX 6650 XT', 240), +((SELECT id FROM components WHERE name='Radeon RX 6750 XT'), 12, 250, 2.15, 2.6, 'RX 6750 XT', 267), +((SELECT id FROM components WHERE name='Radeon RX 5700 XT'), 8, 225, 1.61, 1.91, 'RX 5700 XT', 267), +((SELECT id FROM components WHERE name='Radeon RX 5600 XT'), 6, 150, 1.38, 1.62, 'RX 5600 XT', 240), +((SELECT id FROM components WHERE name='Arc A770'), 16, 225, 2.1, 2.4, 'Arc A770', 267), +((SELECT id FROM components WHERE name='Arc A750'), 8, 225, 2.05, 2.4, 'Arc A750', 267), +((SELECT id FROM components WHERE name='Arc A580'), 8, 185, 1.7, 2.0, 'Arc A580', 229), +((SELECT id FROM components WHERE name='Arc A380'), 6, 75, 2.0, 2.45, 'Arc A380', 167), +((SELECT id FROM components WHERE name='Arc A310'), 4, 75, 2.0, 2.0, 'Arc A310', 150), +((SELECT id FROM components WHERE name='Arc B580'), 12, 190, 2.0, 2.67, 'Arc B580', 267), +((SELECT id FROM components WHERE name='Arc B570'), 10, 150, 1.9, 2.5, 'Arc B570', 242), +((SELECT id FROM components WHERE name='Arc A350M'), 4, 50, 1.15, 1.8, 'Arc A350M', 180), +((SELECT id FROM components WHERE name='Arc Pro A60'), 12, 130, 2.0, 2.45, 'Arc Pro A60', 229), +((SELECT id FROM components WHERE name='Arc Pro A40'), 6, 50, 1.65, 2.05, 'Arc Pro A40', 167); INSERT INTO motherboard (component_id, socket, chipset, form_factor, ram_type, num_ram_slots, max_ram_capacity, pci_express_slots) VALUES -(7, 'AM4', 'B550', 'ATX', 'DDR4', 4, 128, 3), +(7, 'AM4', 'B550', 'ATX', 'DDR4', 4, 128, 3), ((SELECT id FROM components WHERE name='B650M DS3H'), 'AM5', 'B650', 'Micro-ATX', 'DDR5', 4, 128, 2), ((SELECT id FROM components WHERE name='X670E AORUS Master'), 'AM5', 'X670E', 'ATX', 'DDR5', 4, 192, 3), ((SELECT id FROM components WHERE name='B760M Bomber WiFi'), 'LGA1700', 'B760', 'Micro-ATX', 'DDR4', 2, 64, 1), -((SELECT id FROM components WHERE name='Z790 Maximus Hero'), 'LGA1700', 'Z790', 'ATX', 'DDR5', 4, 192, 3); +((SELECT id FROM components WHERE name='Z790 Maximus Hero'), 'LGA1700', 'Z790', 'ATX', 'DDR5', 4, 192, 3), +((SELECT id FROM components WHERE name='B450 Tomahawk Max'), 'AM4', 'B450', 'ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='B550-A Pro'), 'AM4', 'B550', 'ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='X570 AORUS Elite'), 'AM4', 'X570', 'ATX', 'DDR4', 4, 128, 3), +((SELECT id FROM components WHERE name='B550M TUF Gaming'), 'AM4', 'B550', 'Micro-ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='X570 Unify'), 'AM4', 'X570', 'ATX', 'DDR4', 4, 128, 3), +((SELECT id FROM components WHERE name='B650 AORUS Elite AX'), 'AM5', 'B650', 'ATX', 'DDR5', 4, 128, 3), +((SELECT id FROM components WHERE name='X670 Gaming Plus WiFi'), 'AM5', 'X670', 'ATX', 'DDR5', 4, 192, 3), +((SELECT id FROM components WHERE name='B650E TUF Gaming'), 'AM5', 'B650E', 'ATX', 'DDR5', 4, 128, 3), +((SELECT id FROM components WHERE name='X670E Taichi'), 'AM5', 'X670E', 'ATX', 'DDR5', 4, 256, 4), +((SELECT id FROM components WHERE name='B550 Phantom Gaming'), 'AM4', 'B550', 'ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='B660M Pro RS'), 'LGA1700', 'B660', 'Micro-ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='B660 Gaming X DDR4'), 'LGA1700', 'B660', 'ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='H610M-E'), 'LGA1700', 'H610', 'Micro-ATX', 'DDR4', 2, 64, 1), +((SELECT id FROM components WHERE name='Z690 AORUS Pro'), 'LGA1700', 'Z690', 'ATX', 'DDR5', 4, 128, 3), +((SELECT id FROM components WHERE name='Z690 Edge WiFi DDR4'), 'LGA1700', 'Z690', 'ATX', 'DDR4', 4, 128, 3), +((SELECT id FROM components WHERE name='B760M DS3H DDR4'), 'LGA1700', 'B760', 'Micro-ATX', 'DDR4', 4, 128, 2), +((SELECT id FROM components WHERE name='Z790 TUF Gaming'), 'LGA1700', 'Z790', 'ATX', 'DDR5', 4, 192, 3), +((SELECT id FROM components WHERE name='B760 Tomahawk WiFi'), 'LGA1700', 'B760', 'ATX', 'DDR4', 4, 128, 3), +((SELECT id FROM components WHERE name='Z790 AORUS Elite'), 'LGA1700', 'Z790', 'ATX', 'DDR5', 4, 192, 3), +((SELECT id FROM components WHERE name='H670 Steel Legend'), 'LGA1700', 'H670', 'ATX', 'DDR4', 4, 128, 2); INSERT INTO memory (component_id, type, speed, capacity, modules) VALUES @@ -133,5 +421,25 @@ ((SELECT id FROM components WHERE name='Ripjaws V 32GB'), 'DDR4', 3600, 32, 2), ((SELECT id FROM components WHERE name='Trident Z5 RGB 32GB'), 'DDR5', 6000, 32, 2), -((SELECT id FROM components WHERE name='Dominator Platinum 64GB'), 'DDR5', 6400, 64, 2); +((SELECT id FROM components WHERE name='Dominator Platinum 64GB'), 'DDR5', 6400, 64, 2), +((SELECT id FROM components WHERE name='Vengeance LPX 8GB'), 'DDR4', 3200, 8, 1), +((SELECT id FROM components WHERE name='Ripjaws V 16GB'), 'DDR4', 3600, 16, 2), +((SELECT id FROM components WHERE name='Fury Beast 16GB'), 'DDR4', 3200, 16, 2), +((SELECT id FROM components WHERE name='Elite 32GB Kit'), 'DDR4', 3200, 32, 2), +((SELECT id FROM components WHERE name='Vengeance RGB Pro 32GB'), 'DDR4', 3600, 32, 2), +((SELECT id FROM components WHERE name='Trident Z RGB 16GB'), 'DDR4', 3600, 16, 2), +((SELECT id FROM components WHERE name='Aegis 16GB Kit'), 'DDR4', 3000, 16, 2), +((SELECT id FROM components WHERE name='HyperX Fury 32GB'), 'DDR4', 3200, 32, 4), +((SELECT id FROM components WHERE name='Ballistix 16GB'), 'DDR4', 3200, 16, 1), +((SELECT id FROM components WHERE name='Value RAM 8GB'), 'DDR4', 2666, 8, 1), +((SELECT id FROM components WHERE name='Trident Z5 16GB'), 'DDR5', 6000, 16, 2), +((SELECT id FROM components WHERE name='Dominator Platinum 32GB'), 'DDR5', 6400, 32, 2), +((SELECT id FROM components WHERE name='Fury Beast DDR5 16GB'), 'DDR5', 5600, 16, 1), +((SELECT id FROM components WHERE name='Vengeance DDR5 32GB'), 'DDR5', 5600, 32, 2), +((SELECT id FROM components WHERE name='Trident Z5 RGB 64GB'), 'DDR5', 6000, 64, 2), +((SELECT id FROM components WHERE name='Elite DDR5 32GB'), 'DDR5', 5200, 32, 2), +((SELECT id FROM components WHERE name='Fury Beast DDR5 32GB'), 'DDR5', 6000, 32, 2), +((SELECT id FROM components WHERE name='Vengeance RGB DDR5 64GB'), 'DDR5', 6400, 64, 2), +((SELECT id FROM components WHERE name='T-Force Delta RGB 32GB'), 'DDR5', 6000, 32, 2), +((SELECT id FROM components WHERE name='Flare X5 32GB'), 'DDR5', 6000, 32, 2); INSERT INTO storage (component_id, type, capacity, form_factor) VALUES @@ -139,5 +447,25 @@ ((SELECT id FROM components WHERE name='Crucial P3 1TB'), 'NVMe', 1000, 'M.2'), ((SELECT id FROM components WHERE name='WD Black SN850X 2TB'), 'NVMe', 2000, 'M.2'), -((SELECT id FROM components WHERE name='Samsung 990 Pro 4TB'), 'NVMe', 4000, 'M.2'); +((SELECT id FROM components WHERE name='Samsung 990 Pro 4TB'), 'NVMe', 4000, 'M.2'), +((SELECT id FROM components WHERE name='Samsung 870 EVO 500GB'), 'SATA', 500, '2.5'), +((SELECT id FROM components WHERE name='Samsung 870 QVO 1TB'), 'SATA', 1000, '2.5'), +((SELECT id FROM components WHERE name='WD Blue 1TB'), 'SATA', 1000, '2.5'), +((SELECT id FROM components WHERE name='Crucial MX500 2TB'), 'SATA', 2000, '2.5'), +((SELECT id FROM components WHERE name='Kingston A400 480GB'), 'SATA', 480, '2.5'), +((SELECT id FROM components WHERE name='Samsung 980 Pro 1TB'), 'NVMe', 1000, 'M.2'), +((SELECT id FROM components WHERE name='WD Black SN770 1TB'), 'NVMe', 1000, 'M.2'), +((SELECT id FROM components WHERE name='Crucial P5 Plus 2TB'), 'NVMe', 2000, 'M.2'), +((SELECT id FROM components WHERE name='Samsung 980 500GB'), 'NVMe', 500, 'M.2'), +((SELECT id FROM components WHERE name='WD Blue SN580 1TB'), 'NVMe', 1000, 'M.2'), +((SELECT id FROM components WHERE name='Kingston KC3000 1TB'), 'NVMe', 1000, 'M.2'), +((SELECT id FROM components WHERE name='Seagate Barracuda 2TB'), 'HDD', 2000, '3.5'), +((SELECT id FROM components WHERE name='WD Blue 4TB HDD'), 'HDD', 4000, '3.5'), +((SELECT id FROM components WHERE name='Seagate IronWolf 4TB'), 'HDD', 4000, '3.5'), +((SELECT id FROM components WHERE name='Toshiba X300 6TB'), 'HDD', 6000, '3.5'), +((SELECT id FROM components WHERE name='WD Black 6TB HDD'), 'HDD', 6000, '3.5'), +((SELECT id FROM components WHERE name='Seagate Barracuda 8TB'), 'HDD', 8000, '3.5'), +((SELECT id FROM components WHERE name='Crucial BX500 1TB'), 'SATA', 1000, '2.5'), +((SELECT id FROM components WHERE name='Samsung 870 EVO 2TB'), 'SATA', 2000, '2.5'), +((SELECT id FROM components WHERE name='Kingston NV2 2TB'), 'NVMe', 2000, 'M.2'); INSERT INTO pc_case (component_id, cooler_max_height, gpu_max_length) VALUES @@ -146,24 +474,101 @@ ((SELECT id FROM components WHERE name='4000D Airflow'), 170, 360), ((SELECT id FROM components WHERE name='O11 Dynamic Evo'), 167, 422), -((SELECT id FROM components WHERE name='Versa H18'), 155, 350); +((SELECT id FROM components WHERE name='Versa H18'), 155, 350), +((SELECT id FROM components WHERE name='H510 Elite'), 165, 381), +((SELECT id FROM components WHERE name='H7 Flow'), 185, 400), +((SELECT id FROM components WHERE name='5000D Airflow'), 170, 420), +((SELECT id FROM components WHERE name='4000D RGB'), 170, 360), +((SELECT id FROM components WHERE name='iCUE 5000X RGB'), 170, 420), +((SELECT id FROM components WHERE name='O11 Dynamic XL'), 167, 420), +((SELECT id FROM components WHERE name='Lancool 216'), 176, 384), +((SELECT id FROM components WHERE name='Meshify 2 Compact'), 169, 360), +((SELECT id FROM components WHERE name='Define 7'), 185, 491), +((SELECT id FROM components WHERE name='Torrent Compact'), 188, 360), +((SELECT id FROM components WHERE name='View 51 TG'), 180, 420), +((SELECT id FROM components WHERE name='Core P3 TG'), 185, 420), +((SELECT id FROM components WHERE name='H440'), 165, 400), +((SELECT id FROM components WHERE name='P500A'), 160, 435), +((SELECT id FROM components WHERE name='Pure Base 500DX'), 190, 369), +((SELECT id FROM components WHERE name='H500'), 167, 410), +((SELECT id FROM components WHERE name='RL08'), 158, 400), +((SELECT id FROM components WHERE name='Air 100 ARGB'), 155, 330), +((SELECT id FROM components WHERE name='CC560'), 165, 370), +((SELECT id FROM components WHERE name='DF700 Flux'), 180, 405); INSERT INTO case_mobo_form_factors (case_id, form_factor) VALUES -(5, 'ATX'), (5, 'Micro-ATX'); - -INSERT INTO case_mobo_form_factors (case_id, form_factor) VALUES - ((SELECT id FROM components WHERE name = 'H5 Flow'), 'ATX'), - ((SELECT id FROM components WHERE name = 'H5 Flow'), 'Micro-ATX'), - ((SELECT id FROM components WHERE name = '4000D Airflow'), 'ATX'), - ((SELECT id FROM components WHERE name = '4000D Airflow'), 'Micro-ATX'), - ((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'ATX'), - ((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'Micro-ATX'), - ((SELECT id FROM components WHERE name = 'Versa H18'), 'Micro-ATX'); +(5, 'ATX'), (5, 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'H5 Flow'), 'ATX'), +((SELECT id FROM components WHERE name = 'H5 Flow'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = '4000D Airflow'), 'ATX'), +((SELECT id FROM components WHERE name = '4000D Airflow'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Versa H18'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'H510 Elite'), 'ATX'), +((SELECT id FROM components WHERE name = 'H510 Elite'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'H7 Flow'), 'ATX'), +((SELECT id FROM components WHERE name = 'H7 Flow'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = '5000D Airflow'), 'ATX'), +((SELECT id FROM components WHERE name = '5000D Airflow'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = '4000D RGB'), 'ATX'), +((SELECT id FROM components WHERE name = '4000D RGB'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'iCUE 5000X RGB'), 'ATX'), +((SELECT id FROM components WHERE name = 'iCUE 5000X RGB'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic XL'), 'ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic XL'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Lancool 216'), 'ATX'), +((SELECT id FROM components WHERE name = 'Lancool 216'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Meshify 2 Compact'), 'ATX'), +((SELECT id FROM components WHERE name = 'Meshify 2 Compact'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Define 7'), 'ATX'), +((SELECT id FROM components WHERE name = 'Define 7'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Torrent Compact'), 'ATX'), +((SELECT id FROM components WHERE name = 'Torrent Compact'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'View 51 TG'), 'ATX'), +((SELECT id FROM components WHERE name = 'View 51 TG'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Core P3 TG'), 'ATX'), +((SELECT id FROM components WHERE name = 'Core P3 TG'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'H440'), 'ATX'), +((SELECT id FROM components WHERE name = 'H440'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'P500A'), 'ATX'), +((SELECT id FROM components WHERE name = 'P500A'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Pure Base 500DX'), 'ATX'), +((SELECT id FROM components WHERE name = 'Pure Base 500DX'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'H500'), 'ATX'), +((SELECT id FROM components WHERE name = 'H500'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'RL08'), 'ATX'), +((SELECT id FROM components WHERE name = 'RL08'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'Air 100 ARGB'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'CC560'), 'ATX'), +((SELECT id FROM components WHERE name = 'CC560'), 'Micro-ATX'), +((SELECT id FROM components WHERE name = 'DF700 Flux'), 'ATX'), +((SELECT id FROM components WHERE name = 'DF700 Flux'), 'Micro-ATX'); INSERT INTO case_storage_form_factors (case_id, form_factor, num_slots) VALUES - (5, 'M.2', 2), - ((SELECT id FROM components WHERE name = 'H5 Flow'), 'M.2', 3), - ((SELECT id FROM components WHERE name = '4000D Airflow'), 'M.2', 3), - ((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'M.2', 4), - ((SELECT id FROM components WHERE name = 'Versa H18'), 'M.2', 2); +(5, 'M.2', 2), +((SELECT id FROM components WHERE name = 'H5 Flow'), 'M.2', 3), +((SELECT id FROM components WHERE name = '4000D Airflow'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'M.2', 4), +((SELECT id FROM components WHERE name = 'Versa H18'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'H510 Elite'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'H7 Flow'), 'M.2', 4), +((SELECT id FROM components WHERE name = '5000D Airflow'), 'M.2', 4), +((SELECT id FROM components WHERE name = '4000D RGB'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'iCUE 5000X RGB'), 'M.2', 4), +((SELECT id FROM components WHERE name = 'O11 Dynamic XL'), 'M.2', 4), +((SELECT id FROM components WHERE name = 'Lancool 216'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'Meshify 2 Compact'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'Define 7'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'Torrent Compact'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'View 51 TG'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'Core P3 TG'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'H440'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'P500A'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'Pure Base 500DX'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'H500'), 'M.2', 3), +((SELECT id FROM components WHERE name = 'RL08'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'Air 100 ARGB'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'CC560'), 'M.2', 2), +((SELECT id FROM components WHERE name = 'DF700 Flux'), 'M.2', 3); INSERT INTO power_supply (component_id, type, wattage, form_factor) VALUES @@ -171,45 +576,187 @@ ((SELECT id FROM components WHERE name='Smart 500W'), 'Non-Modular', 500, 'ATX'), ((SELECT id FROM components WHERE name='RM750e'), 'Fully Modular', 750, 'ATX'), -((SELECT id FROM components WHERE name='SuperNOVA 1000 GT'), 'Fully Modular', 1000, 'ATX'); +((SELECT id FROM components WHERE name='SuperNOVA 1000 GT'), 'Fully Modular', 1000, 'ATX'), +((SELECT id FROM components WHERE name='Smart 450W'), 'Non-Modular', 450, 'ATX'), +((SELECT id FROM components WHERE name='CV550'), 'Non-Modular', 550, 'ATX'), +((SELECT id FROM components WHERE name='BR600W'), 'Non-Modular', 600, 'ATX'), +((SELECT id FROM components WHERE name='CX650M'), 'Semi-Modular', 650, 'ATX'), +((SELECT id FROM components WHERE name='SuperNOVA 750 G6'), 'Fully Modular', 750, 'ATX'), +((SELECT id FROM components WHERE name='RM850x'), 'Fully Modular', 850, 'ATX'), +((SELECT id FROM components WHERE name='Toughpower GF1 850W'), 'Fully Modular', 850, 'ATX'), +((SELECT id FROM components WHERE name='HX1000i'), 'Fully Modular', 1000, 'ATX'), +((SELECT id FROM components WHERE name='SuperNOVA 1200 P2'), 'Fully Modular', 1200, 'ATX'), +((SELECT id FROM components WHERE name='RM1000x Shift'), 'Fully Modular', 1000, 'ATX'); INSERT INTO cooler (component_id, type, height, max_tdp_supported) VALUES (6, 'Air', 158, 150), ((SELECT id FROM components WHERE name='Peerless Assassin 120 SE'), 'Air', 155, 245), -((SELECT id FROM components WHERE name='Kraken Elite 360'), 'Liquid', 55, 300); +((SELECT id FROM components WHERE name='Kraken Elite 360'), 'Liquid', 55, 300), +((SELECT id FROM components WHERE name='Hyper 212 RGB Black'), 'Air', 159, 180), +((SELECT id FROM components WHERE name='NH-D15'), 'Air', 165, 220), +((SELECT id FROM components WHERE name='Dark Rock Pro 4'), 'Air', 163, 250), +((SELECT id FROM components WHERE name='NH-U12S'), 'Air', 158, 165), +((SELECT id FROM components WHERE name='Vetroo V5'), 'Air', 155, 180), +((SELECT id FROM components WHERE name='Assassin X 120 Refined'), 'Air', 157, 150), +((SELECT id FROM components WHERE name='Pure Rock 2'), 'Air', 155, 150), +((SELECT id FROM components WHERE name='Fuma 3'), 'Air', 154, 220), +((SELECT id FROM components WHERE name='Kraken X63'), 'Liquid', 55, 250), +((SELECT id FROM components WHERE name='iCUE H100i Elite'), 'Liquid', 55, 250), +((SELECT id FROM components WHERE name='iCUE H150i Elite LCD'), 'Liquid', 55, 300), +((SELECT id FROM components WHERE name='Castle 280 RGB'), 'Liquid', 55, 250), +((SELECT id FROM components WHERE name='MasterLiquid ML240L'), 'Liquid', 55, 200), +((SELECT id FROM components WHERE name='Liquid Freezer II 360'), 'Liquid', 55, 320), +((SELECT id FROM components WHERE name='EK-AIO 240 D-RGB'), 'Liquid', 55, 240); INSERT INTO cooler_cpu_sockets (cooler_id, socket) VALUES -(6, 'AM4'), (6, 'AM5'); - -INSERT INTO cooler_cpu_sockets (cooler_id, socket) VALUES - ((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'AM4'), - ((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'AM5'), - ((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'LGA1700'); - -INSERT INTO cooler_cpu_sockets (cooler_id, socket) VALUES - ((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'AM4'), - ((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'AM5'), - ((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'LGA1700'); +(6, 'AM4'), (6, 'AM5'), +((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'AM4'), +((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'AM5'), +((SELECT id FROM components WHERE name = 'Peerless Assassin 120 SE'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'AM4'), +((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'AM5'), +((SELECT id FROM components WHERE name = 'Kraken Elite 360'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Hyper 212 RGB Black'), 'AM4'), +((SELECT id FROM components WHERE name = 'Hyper 212 RGB Black'), 'AM5'), +((SELECT id FROM components WHERE name = 'Hyper 212 RGB Black'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Hyper 212 RGB Black'), 'LGA1200'), +((SELECT id FROM components WHERE name = 'NH-D15'), 'AM4'), +((SELECT id FROM components WHERE name = 'NH-D15'), 'AM5'), +((SELECT id FROM components WHERE name = 'NH-D15'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'NH-D15'), 'LGA1200'), +((SELECT id FROM components WHERE name = 'Dark Rock Pro 4'), 'AM4'), +((SELECT id FROM components WHERE name = 'Dark Rock Pro 4'), 'AM5'), +((SELECT id FROM components WHERE name = 'Dark Rock Pro 4'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Dark Rock Pro 4'), 'LGA1200'), +((SELECT id FROM components WHERE name = 'NH-U12S'), 'AM4'), +((SELECT id FROM components WHERE name = 'NH-U12S'), 'AM5'), +((SELECT id FROM components WHERE name = 'NH-U12S'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'NH-U12S'), 'LGA1200'), +((SELECT id FROM components WHERE name = 'Vetroo V5'), 'AM4'), +((SELECT id FROM components WHERE name = 'Vetroo V5'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Assassin X 120 Refined'), 'AM4'), +((SELECT id FROM components WHERE name = 'Assassin X 120 Refined'), 'AM5'), +((SELECT id FROM components WHERE name = 'Assassin X 120 Refined'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Pure Rock 2'), 'AM4'), +((SELECT id FROM components WHERE name = 'Pure Rock 2'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Fuma 3'), 'AM4'), +((SELECT id FROM components WHERE name = 'Fuma 3'), 'AM5'), +((SELECT id FROM components WHERE name = 'Fuma 3'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Kraken X63'), 'AM4'), +((SELECT id FROM components WHERE name = 'Kraken X63'), 'AM5'), +((SELECT id FROM components WHERE name = 'Kraken X63'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'iCUE H100i Elite'), 'AM4'), +((SELECT id FROM components WHERE name = 'iCUE H100i Elite'), 'AM5'), +((SELECT id FROM components WHERE name = 'iCUE H100i Elite'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'iCUE H150i Elite LCD'), 'AM4'), +((SELECT id FROM components WHERE name = 'iCUE H150i Elite LCD'), 'AM5'), +((SELECT id FROM components WHERE name = 'iCUE H150i Elite LCD'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Castle 280 RGB'), 'AM4'), +((SELECT id FROM components WHERE name = 'Castle 280 RGB'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'MasterLiquid ML240L'), 'AM4'), +((SELECT id FROM components WHERE name = 'MasterLiquid ML240L'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'Liquid Freezer II 360'), 'AM4'), +((SELECT id FROM components WHERE name = 'Liquid Freezer II 360'), 'AM5'), +((SELECT id FROM components WHERE name = 'Liquid Freezer II 360'), 'LGA1700'), +((SELECT id FROM components WHERE name = 'EK-AIO 240 D-RGB'), 'AM4'), +((SELECT id FROM components WHERE name = 'EK-AIO 240 D-RGB'), 'AM5'), +((SELECT id FROM components WHERE name = 'EK-AIO 240 D-RGB'), 'LGA1700'); INSERT INTO case_ps_form_factors (case_id, form_factor) VALUES - (5, 'ATX'), - ((SELECT id FROM components WHERE name = 'H5 Flow'), 'ATX'), - ((SELECT id FROM components WHERE name = '4000D Airflow'), 'ATX'), - ((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'ATX'), - ((SELECT id FROM components WHERE name = 'Versa H18'), 'ATX'); - -INSERT INTO sound_card (component_id, sample_rate, bit_depth, chipset, interface, channel) VALUES (9, 192000, 24, 'SoundCore', 'PCIe', '7.1'); -INSERT INTO network_card (component_id, num_ports, speed, interface) VALUES (10, 2, 1000, 'PCIe'); -INSERT INTO network_adapter (component_id, wifi_version, interface, num_antennas) VALUES (11, 'WiFi 6', 'PCIe', 3); -INSERT INTO optical_drive (component_id, form_factor, type, interface, write_speed, read_speed) VALUES (12, '5.25"', 'DVD-RW', 'SATA', 16, 16); -INSERT INTO memory_card (component_id, num_slots, interface) VALUES (13, 1, '2.5'); -INSERT INTO cables (component_id, length_cm, type) VALUES (14, 50, 'SATA'); +(5, 'ATX'), +((SELECT id FROM components WHERE name = 'H5 Flow'), 'ATX'), +((SELECT id FROM components WHERE name = '4000D Airflow'), 'ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic Evo'), 'ATX'), +((SELECT id FROM components WHERE name = 'Versa H18'), 'ATX'), +((SELECT id FROM components WHERE name = 'H510 Elite'), 'ATX'), +((SELECT id FROM components WHERE name = 'H7 Flow'), 'ATX'), +((SELECT id FROM components WHERE name = '5000D Airflow'), 'ATX'), +((SELECT id FROM components WHERE name = '4000D RGB'), 'ATX'), +((SELECT id FROM components WHERE name = 'iCUE 5000X RGB'), 'ATX'), +((SELECT id FROM components WHERE name = 'O11 Dynamic XL'), 'ATX'), +((SELECT id FROM components WHERE name = 'Lancool 216'), 'ATX'), +((SELECT id FROM components WHERE name = 'Meshify 2 Compact'), 'ATX'), +((SELECT id FROM components WHERE name = 'Define 7'), 'ATX'), +((SELECT id FROM components WHERE name = 'Torrent Compact'), 'ATX'), +((SELECT id FROM components WHERE name = 'View 51 TG'), 'ATX'), +((SELECT id FROM components WHERE name = 'Core P3 TG'), 'ATX'), +((SELECT id FROM components WHERE name = 'H440'), 'ATX'), +((SELECT id FROM components WHERE name = 'P500A'), 'ATX'), +((SELECT id FROM components WHERE name = 'Pure Base 500DX'), 'ATX'), +((SELECT id FROM components WHERE name = 'H500'), 'ATX'), +((SELECT id FROM components WHERE name = 'RL08'), 'ATX'), +((SELECT id FROM components WHERE name = 'Air 100 ARGB'), 'ATX'), +((SELECT id FROM components WHERE name = 'CC560'), 'ATX'), +((SELECT id FROM components WHERE name = 'DF700 Flux'), 'ATX'); + +INSERT INTO sound_card (component_id, sample_rate, bit_depth, chipset, interface, channel) VALUES +(9, 192000, 24, 'SoundCore', 'PCIe', '7.1'), +((SELECT id FROM components WHERE name='Sound BlasterX AE-5 Plus'), 192000, 32, 'SB1508', 'PCIe', '7.1'), +((SELECT id FROM components WHERE name='Xonar SE'), 192000, 24, 'CM6620', 'PCIe', '5.1'), +((SELECT id FROM components WHERE name='Sound Blaster Z'), 192000, 24, 'SB1502', 'PCIe', '5.1'), +((SELECT id FROM components WHERE name='Audigy FX'), 192000, 24, 'CA20K2', 'PCIe', '5.1'), +((SELECT id FROM components WHERE name='Xonar U7'), 192000, 24, 'CM6632AX', 'USB', '7.1'); + +INSERT INTO network_card (component_id, num_ports, speed, interface) VALUES +(10, 2, 1000, 'PCIe'), +((SELECT id FROM components WHERE name='PRO/1000 PT'), 2, 1000, 'PCIe'), +((SELECT id FROM components WHERE name='TG-3468'), 1, 1000, 'PCIe'), +((SELECT id FROM components WHERE name='PCE-AC68'), 1, 1300, 'PCIe'), +((SELECT id FROM components WHERE name='XG-C100C'), 1, 10000, 'PCIe'), +((SELECT id FROM components WHERE name='Killer E3100G'), 1, 2500, 'PCIe'); + +INSERT INTO network_adapter (component_id, wifi_version, interface, num_antennas) VALUES +(11, 'WiFi 6', 'PCIe', 3), +((SELECT id FROM components WHERE name='Archer TX3000E'), 'WiFi 6', 'PCIe', 2), +((SELECT id FROM components WHERE name='AX200'), 'WiFi 6', 'M.2', 2), +((SELECT id FROM components WHERE name='PCE-AXE5400'), 'WiFi 6E', 'PCIe', 4), +((SELECT id FROM components WHERE name='Archer T6E'), 'WiFi 5', 'PCIe', 2), +((SELECT id FROM components WHERE name='WN7200ND'), 'WiFi 4', 'PCIe', 2); + +INSERT INTO optical_drive (component_id, form_factor, type, interface, write_speed, read_speed) VALUES +(12, '5.25"', 'DVD-RW', 'SATA', 16, 16), +((SELECT id FROM components WHERE name='DVD-RW Drive'), '5.25"', 'DVD-RW', 'SATA', 24, 24), +((SELECT id FROM components WHERE name='Slim DVD Writer'), 'Slim', 'DVD-RW', 'SATA', 8, 8), +((SELECT id FROM components WHERE name='BDR-XD07B'), 'Slim', 'BD-RE', 'USB', 6, 6), +((SELECT id FROM components WHERE name='BP60NB10'), 'Slim', 'BD-RE', 'USB', 6, 6), +((SELECT id FROM components WHERE name='Blu-ray Writer'), '5.25"', 'BD-RE', 'SATA', 16, 16); + +INSERT INTO memory_card (component_id, num_slots, interface) VALUES +(13, 1, 'PCIe'), +((SELECT id FROM components WHERE name='M.2 NVMe Adapter Card'), 1, 'PCIe x4'), +((SELECT id FROM components WHERE name='Dual M.2 PCIe Card'), 2, 'PCIe x8'), +((SELECT id FROM components WHERE name='Quad M.2 RAID Card'), 4, 'PCIe x16'), +((SELECT id FROM components WHERE name='U.2 NVMe Adapter'), 1, 'PCIe x4'), +((SELECT id FROM components WHERE name='Triple M.2 Expansion'), 3, 'PCIe x16'); + +INSERT INTO cables (component_id, length_cm, type) VALUES +(14, 50, 'SATA'), +((SELECT id FROM components WHERE name='USB 3.0 Extension 6ft'), 180, 'USB'), +((SELECT id FROM components WHERE name='SATA III Cable 3-Pack'), 50, 'SATA'), +((SELECT id FROM components WHERE name='Premium Sleeved Cables'), 60, 'PSU'), +((SELECT id FROM components WHERE name='DisplayPort 1.4 Cable'), 180, 'DisplayPort'), +((SELECT id FROM components WHERE name='USB-C to USB-A Cable'), 100, 'USB'), +((SELECT id FROM components WHERE name='HDMI 2.1 Cable 10ft'), 300, 'HDMI'), +((SELECT id FROM components WHERE name='PWM Fan Splitter Cable'), 30, 'Fan'), +((SELECT id FROM components WHERE name='RGB LED Strip Extension'), 50, 'RGB'), +((SELECT id FROM components WHERE name='PCIe 4.0 Riser Cable'), 30, 'PCIe'), +((SELECT id FROM components WHERE name='Molex to SATA Power'), 20, 'Power'); INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES -(1, 'Gaming Build', CURRENT_DATE, 'Mid-range gaming PC', 1139.92, TRUE); +((SELECT id FROM users WHERE username='tome'), 'Gaming Build', '2025-09-18', 'Mid-range gaming PC', 1154.92, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES -(1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8); +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='Ryzen 7 5800X')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='RTX 3060')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='B550 Motherboard')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='16GB DDR4 Kit')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='1TB NVMe SSD')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='650W PSU')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='4000D Airflow')), +((SELECT id FROM build WHERE name='Gaming Build'), (SELECT id FROM components WHERE name='Air Cooler')); + INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='budget_king'), 'Console Killer 2025', '2024-12-01', 'Cheap entry level gaming PC', 580.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Core i3-13100F')), @@ -223,4 +770,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='streamer_pro'), 'Pro Streaming Rig', '2025-01-15', 'Handles OBS and 1440p gaming flawlessly', 2150.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='Core i7-14700K')), @@ -235,4 +783,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='pc_wizard'), 'Team Red Value King', '2025-02-10', 'Pure rasterization performance', 1450.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Ryzen 7 7800X3D')), @@ -247,4 +796,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='rgb_lover'), 'God Tier 4090 Build', '2025-03-01', 'Money is no object. 4K 144Hz Ultra.', 4200.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Core i9-14900KS')), @@ -259,4 +809,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='first_timer'), 'Snow White Build', '2024-11-20', 'First time building, went for looks', 1199.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='Ryzen 5 7600')), @@ -270,4 +821,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='linux_fan'), 'Arch Linux Dev Box', '2024-10-15', 'Compilation beast, no Nvidia drivers needed', 920.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Core i5-13600K')), @@ -281,4 +833,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='office_guy'), '1080p Gamer', '2025-01-05', 'Just for Fortnite and Apex', 810.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Core i3-13100F')), @@ -292,4 +845,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='pc_wizard'), 'Silent Night', '2024-12-25', 'Zero RPM fan mode build', 2450.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='Core i7-14700K')), @@ -304,4 +858,5 @@ INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES ((SELECT id FROM users WHERE username='rgb_lover'), 'Radeon Ultimate', '2025-03-10', '4K Gaming without Nvidia tax', 2850.00, TRUE); + INSERT INTO build_component (build_id, component_id) VALUES ((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Ryzen 9 7950X')), @@ -314,4 +869,5 @@ ((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Kraken Elite 360')); +-- Ratings & Reviews INSERT INTO rating_build (build_id, user_id, value) VALUES (1, 2, 5); INSERT INTO review (build_id, user_id, content, created_at) VALUES (1, 2, 'Still runs everything in 2025!', CURRENT_DATE); @@ -321,8 +877,11 @@ ((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='pc_wizard'), 4); INSERT INTO review (build_id, user_id, content, created_at) VALUES -((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='rgb_lover'), 'No RGB, 3 stars.', '2024-12-05'); +((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='rgb_lover'), 'No RGB, 3 stars.', '2024-12-05'), +((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='pc_wizard'), 'Solid entry-level build. Beats PS5 performance per dollar.', '2024-12-02'); -- ADDED INSERT INTO rating_build (build_id, user_id, value) VALUES ((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM users WHERE username='pc_wizard'), 5); +INSERT INTO review (build_id, user_id, content, created_at) VALUES +((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM users WHERE username='pc_wizard'), 'Zero dropped frames at 1440p/144Hz. Encoder handles everything.', '2025-01-16'); INSERT INTO rating_build (build_id, user_id, value) VALUES @@ -330,5 +889,6 @@ ((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='first_timer'), 4); INSERT INTO review (build_id, user_id, content, created_at) VALUES -((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='budget_king'), 'Best FPS per dollar.', '2025-02-12'); +((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='budget_king'), 'Best FPS per dollar.', '2025-02-12'), +((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='first_timer'), 'Great build guide for beginners. Assembly was straightforward.', '2025-02-14'); -- ADDED INSERT INTO rating_build (build_id, user_id, value) VALUES @@ -336,9 +896,13 @@ ((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='budget_king'), 2); INSERT INTO review (build_id, user_id, content, created_at) VALUES -((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='budget_king'), 'Waaaaay too much money.', '2025-03-05'); +((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='budget_king'), 'Waaaaay too much money.', '2025-03-05'), +((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='streamer_pro'), 'Streams in 4K while gaming at max settings. Insane power!', '2025-03-06'); -- ADDED INSERT INTO rating_build (build_id, user_id, value) VALUES ((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='rgb_lover'), 5), ((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='office_guy'), 4); +INSERT INTO review (build_id, user_id, content, created_at) VALUES +((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='rgb_lover'), 'Beautiful RGB setup with white theme. Looks amazing!', '2024-11-21'), +((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='office_guy'), 'Clean aesthetic but a bit pricey for the performance.', '2024-11-22'); INSERT INTO rating_build (build_id, user_id, value) VALUES @@ -346,5 +910,6 @@ ((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='first_timer'), 1); INSERT INTO review (build_id, user_id, content, created_at) VALUES -((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='first_timer'), 'Could not install Windows easily.', '2024-10-20'); +((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='first_timer'), 'Could not install Windows easily.', '2024-10-20'), +((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='linux_fan'), 'Compiles kernels like a beast. Perfect Linux workstation.', '2024-10-16'); -- ADDED INSERT INTO rating_build (build_id, user_id, value) VALUES @@ -352,16 +917,25 @@ ((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='budget_king'), 3); INSERT INTO review (build_id, user_id, content, created_at) VALUES -((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='streamer_pro'), 'Stutters in Warzone.', '2025-01-10'); +((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='streamer_pro'), 'Stutters in Warzone.', '2025-01-10'), +((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='budget_king'), 'Decent 1080p performance but could use more GPU power.', '2025-01-12'); -- ADDED INSERT INTO rating_build (build_id, user_id, value) VALUES ((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='rgb_lover'), 2), ((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='office_guy'), 5); +INSERT INTO review (build_id, user_id, content, created_at) VALUES +((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='rgb_lover'), 'Not enough RGB! Boring aesthetics.', '2024-12-26'), +((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='office_guy'), 'Whisper quiet even under full load. Perfect for my office!', '2024-12-27'); INSERT INTO rating_build (build_id, user_id, value) VALUES ((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='pc_wizard'), 5), ((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='linux_fan'), 5); +INSERT INTO review (build_id, user_id, content, created_at) VALUES +((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='pc_wizard'), 'Red team absolutely crushes 4K gaming. No regrets.', '2025-03-11'), +((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='linux_fan'), 'AMD drivers work flawlessly on Linux. Peak gaming experience.', '2025-03-12'); INSERT INTO suggestions (user_id, admin_id, link, admin_comment, description, status, component_type) VALUES -(1, 4, 'https://www.nvidia.com/en-us/geforce/graphics-cards/40-series/rtx-4070-family/', NULL, 'Consider adding RTX 4070', 'pending', 'gpu'); +(1, 4, 'https://www.gigabyte.com/Graphics-Card/GV-N4070WF3OC-12GD-rev-10', NULL, 'Consider adding the NVIDIA RTX 4070', 'pending', 'gpu'), +(5, 4, 'https://www.amd.com/en/support/downloads/drivers.html/processors/ryzen/ryzen-7000-series/amd-ryzen-5-7600x.html#amd_support_product_spec', NULL, 'Consider adding the Ryzen 5 7600x', 'pending', 'cpu'), +(11, NULL, 'https://www.corsair.com/us/en/p/pc-cases/cc-9011251-ww/3000d-tempered-glass-mid-tower-black-cc-9011251-ww', NULL, 'Please add the Corsair 3000D Airflow case', 'pending', 'case'); ` Index: database/migrations/0000_colorful_scream.sql =================================================================== --- database/migrations/0000_colorful_scream.sql (revision a5084806a09c4abfab269ed52d3659d37394a106) +++ database/migrations/0000_colorful_scream.sql (revision a5084806a09c4abfab269ed52d3659d37394a106) @@ -0,0 +1,243 @@ +CREATE TABLE "build_component" ( + "build_id" integer NOT NULL, + "component_id" integer NOT NULL, + "num_components" integer DEFAULT 1 NOT NULL, + CONSTRAINT "build_component_build_id_component_id_pk" PRIMARY KEY("build_id","component_id") +); +--> statement-breakpoint +CREATE TABLE "build" ( + "id" serial PRIMARY KEY NOT NULL, + "user_id" integer NOT NULL, + "name" text NOT NULL, + "created_at" date NOT NULL, + "description" text, + "total_price" numeric NOT NULL, + "is_approved" boolean NOT NULL +); +--> statement-breakpoint +CREATE TABLE "favorite_build" ( + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + CONSTRAINT "favorite_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id") +); +--> statement-breakpoint +CREATE TABLE "rating_build" ( + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + "value" numeric NOT NULL, + CONSTRAINT "rating_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id"), + CONSTRAINT "check_value" CHECK ("rating_build"."value" BETWEEN 1 AND 5) +); +--> statement-breakpoint +CREATE TABLE "review" ( + "id" serial PRIMARY KEY NOT NULL, + "build_id" integer NOT NULL, + "user_id" integer NOT NULL, + "content" text NOT NULL, + "created_at" date NOT NULL, + CONSTRAINT "review_build_id_user_id_unique" UNIQUE("build_id","user_id") +); +--> statement-breakpoint +CREATE TABLE "cpu" ( + "component_id" integer PRIMARY KEY NOT NULL, + "socket" text NOT NULL, + "cores" integer NOT NULL, + "threads" integer NOT NULL, + "base_clock" numeric NOT NULL, + "boost_clock" numeric, + "tdp" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "gpu" ( + "component_id" integer PRIMARY KEY NOT NULL, + "vram" numeric NOT NULL, + "tdp" numeric NOT NULL, + "base_clock" numeric, + "boost_clock" numeric, + "chipset" text NOT NULL, + "length" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "cables" ( + "component_id" integer PRIMARY KEY NOT NULL, + "length_cm" numeric NOT NULL, + "type" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "case_mobo_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + CONSTRAINT "case_mobo_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "case_ps_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + CONSTRAINT "case_ps_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "case_storage_form_factors" ( + "case_id" integer NOT NULL, + "form_factor" text NOT NULL, + "num_slots" integer NOT NULL, + CONSTRAINT "case_storage_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") +); +--> statement-breakpoint +CREATE TABLE "components" ( + "id" serial PRIMARY KEY NOT NULL, + "name" text NOT NULL, + "brand" text NOT NULL, + "price" numeric NOT NULL, + "img_url" text, + "type" text NOT NULL, + CONSTRAINT "check_type" CHECK ("components"."type" in + ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) +); +--> statement-breakpoint +CREATE TABLE "cooler_cpu_sockets" ( + "cooler_id" integer NOT NULL, + "socket" text NOT NULL, + CONSTRAINT "cooler_cpu_sockets_cooler_id_socket_pk" PRIMARY KEY("cooler_id","socket") +); +--> statement-breakpoint +CREATE TABLE "cooler" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "height" numeric NOT NULL, + "max_tdp_supported" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "memory_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "num_slots" integer NOT NULL, + "interface" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "memory" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "speed" numeric NOT NULL, + "capacity" numeric NOT NULL, + "modules" integer NOT NULL +); +--> statement-breakpoint +CREATE TABLE "motherboard" ( + "component_id" integer PRIMARY KEY NOT NULL, + "socket" text NOT NULL, + "chipset" text NOT NULL, + "form_factor" text NOT NULL, + "ram_type" text NOT NULL, + "num_ram_slots" integer NOT NULL, + "max_ram_capacity" numeric NOT NULL, + "pci_express_slots" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "network_adapter" ( + "component_id" integer PRIMARY KEY NOT NULL, + "wifi_version" text NOT NULL, + "interface" text NOT NULL, + "num_antennas" integer NOT NULL +); +--> statement-breakpoint +CREATE TABLE "network_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "num_ports" integer NOT NULL, + "speed" numeric NOT NULL, + "interface" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "optical_drive" ( + "component_id" integer PRIMARY KEY NOT NULL, + "form_factor" text NOT NULL, + "type" text NOT NULL, + "interface" text NOT NULL, + "write_speed" numeric NOT NULL, + "read_speed" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "pc_case" ( + "component_id" integer PRIMARY KEY NOT NULL, + "cooler_max_height" numeric NOT NULL, + "gpu_max_length" numeric NOT NULL +); +--> statement-breakpoint +CREATE TABLE "power_supply" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "wattage" numeric NOT NULL, + "form_factor" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "sound_card" ( + "component_id" integer PRIMARY KEY NOT NULL, + "sample_rate" numeric NOT NULL, + "bit_depth" numeric NOT NULL, + "chipset" text NOT NULL, + "interface" text NOT NULL, + "channel" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "storage" ( + "component_id" integer PRIMARY KEY NOT NULL, + "type" text NOT NULL, + "capacity" numeric NOT NULL, + "form_factor" text NOT NULL +); +--> statement-breakpoint +CREATE TABLE "admins" ( + "user_id" integer PRIMARY KEY NOT NULL +); +--> statement-breakpoint +CREATE TABLE "suggestions" ( + "id" serial PRIMARY KEY NOT NULL, + "user_id" integer NOT NULL, + "admin_id" integer, + "link" text NOT NULL, + "admin_comment" text, + "description" text, + "status" text DEFAULT 'pending' NOT NULL, + "component_type" text NOT NULL, + CONSTRAINT "check_status" CHECK ("suggestions"."status" in ('pending', 'approved', 'rejected')), + CONSTRAINT "check_type" CHECK ("suggestions"."component_type" in + ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) +); +--> statement-breakpoint +CREATE TABLE "users" ( + "id" serial PRIMARY KEY NOT NULL, + "username" text NOT NULL, + "password" text NOT NULL, + "email" text NOT NULL, + CONSTRAINT "users_username_unique" UNIQUE("username"), + CONSTRAINT "users_email_unique" UNIQUE("email") +); +--> statement-breakpoint +ALTER TABLE "build_component" ADD CONSTRAINT "build_component_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "build_component" ADD CONSTRAINT "build_component_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "build" ADD CONSTRAINT "build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "review" ADD CONSTRAINT "review_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "review" ADD CONSTRAINT "review_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cpu" ADD CONSTRAINT "cpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "gpu" ADD CONSTRAINT "gpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cables" ADD CONSTRAINT "cables_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_mobo_form_factors" ADD CONSTRAINT "case_mobo_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_ps_form_factors" ADD CONSTRAINT "case_ps_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "case_storage_form_factors" ADD CONSTRAINT "case_storage_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cooler_cpu_sockets" ADD CONSTRAINT "cooler_cpu_sockets_cooler_id_cooler_component_id_fk" FOREIGN KEY ("cooler_id") REFERENCES "public"."cooler"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "cooler" ADD CONSTRAINT "cooler_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "memory_card" ADD CONSTRAINT "memory_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "memory" ADD CONSTRAINT "memory_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "motherboard" ADD CONSTRAINT "motherboard_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "network_adapter" ADD CONSTRAINT "network_adapter_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "network_card" ADD CONSTRAINT "network_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "optical_drive" ADD CONSTRAINT "optical_drive_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "pc_case" ADD CONSTRAINT "pc_case_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "power_supply" ADD CONSTRAINT "power_supply_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "sound_card" ADD CONSTRAINT "sound_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "storage" ADD CONSTRAINT "storage_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "admins" ADD CONSTRAINT "admins_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint +ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_admin_id_admins_user_id_fk" FOREIGN KEY ("admin_id") REFERENCES "public"."admins"("user_id") ON DELETE set null ON UPDATE cascade; Index: tabase/migrations/0000_shallow_darkhawk.sql =================================================================== --- database/migrations/0000_shallow_darkhawk.sql (revision 3a9c59cba2839f8be6bd0a5327349ee3883c2ee4) +++ (revision ) @@ -1,243 +1,0 @@ -CREATE TABLE "build_component" ( - "build_id" integer NOT NULL, - "component_id" integer NOT NULL, - "num_components" integer DEFAULT 1 NOT NULL, - CONSTRAINT "build_component_build_id_component_id_pk" PRIMARY KEY("build_id","component_id") -); ---> statement-breakpoint -CREATE TABLE "build" ( - "id" serial PRIMARY KEY NOT NULL, - "user_id" integer NOT NULL, - "name" text NOT NULL, - "created_at" date NOT NULL, - "description" text, - "total_price" numeric NOT NULL, - "is_approved" boolean NOT NULL -); ---> statement-breakpoint -CREATE TABLE "favorite_build" ( - "build_id" integer NOT NULL, - "user_id" integer NOT NULL, - CONSTRAINT "favorite_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id") -); ---> statement-breakpoint -CREATE TABLE "rating_build" ( - "build_id" integer NOT NULL, - "user_id" integer NOT NULL, - "value" numeric NOT NULL, - CONSTRAINT "rating_build_build_id_user_id_pk" PRIMARY KEY("build_id","user_id"), - CONSTRAINT "check_value" CHECK ("rating_build"."value" BETWEEN 1 AND 5) -); ---> statement-breakpoint -CREATE TABLE "review" ( - "id" serial PRIMARY KEY NOT NULL, - "build_id" integer NOT NULL, - "user_id" integer NOT NULL, - "content" text NOT NULL, - "created_at" date NOT NULL, - CONSTRAINT "review_build_id_user_id_unique" UNIQUE("build_id","user_id") -); ---> statement-breakpoint -CREATE TABLE "cpu" ( - "component_id" integer PRIMARY KEY NOT NULL, - "socket" text NOT NULL, - "cores" integer NOT NULL, - "threads" integer NOT NULL, - "base_clock" numeric NOT NULL, - "boost_clock" numeric, - "tdp" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "gpu" ( - "component_id" integer PRIMARY KEY NOT NULL, - "vram" numeric NOT NULL, - "tdp" numeric NOT NULL, - "base_clock" numeric, - "boost_clock" numeric, - "chipset" text NOT NULL, - "length" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "cables" ( - "component_id" integer PRIMARY KEY NOT NULL, - "length_cm" numeric NOT NULL, - "type" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "case_mobo_form_factors" ( - "case_id" integer NOT NULL, - "form_factor" text NOT NULL, - CONSTRAINT "case_mobo_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") -); ---> statement-breakpoint -CREATE TABLE "case_ps_form_factors" ( - "case_id" integer NOT NULL, - "form_factor" text NOT NULL, - CONSTRAINT "case_ps_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") -); ---> statement-breakpoint -CREATE TABLE "case_storage_form_factors" ( - "case_id" integer NOT NULL, - "form_factor" text NOT NULL, - "num_slots" integer NOT NULL, - CONSTRAINT "case_storage_form_factors_case_id_form_factor_pk" PRIMARY KEY("case_id","form_factor") -); ---> statement-breakpoint -CREATE TABLE "components" ( - "id" serial PRIMARY KEY NOT NULL, - "name" text NOT NULL, - "brand" text NOT NULL, - "price" numeric NOT NULL, - "img_url" text, - "type" text NOT NULL, - CONSTRAINT "check_type" CHECK ("components"."type" in - ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) -); ---> statement-breakpoint -CREATE TABLE "cooler_cpu_sockets" ( - "cooler_id" integer NOT NULL, - "socket" text NOT NULL, - CONSTRAINT "cooler_cpu_sockets_cooler_id_socket_pk" PRIMARY KEY("cooler_id","socket") -); ---> statement-breakpoint -CREATE TABLE "cooler" ( - "component_id" integer PRIMARY KEY NOT NULL, - "type" text NOT NULL, - "height" numeric NOT NULL, - "max_tdp_supported" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "memory_card" ( - "component_id" integer PRIMARY KEY NOT NULL, - "num_slots" integer NOT NULL, - "interface" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "memory" ( - "component_id" integer PRIMARY KEY NOT NULL, - "type" text NOT NULL, - "speed" numeric NOT NULL, - "capacity" numeric NOT NULL, - "modules" integer NOT NULL -); ---> statement-breakpoint -CREATE TABLE "motherboard" ( - "component_id" integer PRIMARY KEY NOT NULL, - "socket" text NOT NULL, - "chipset" text NOT NULL, - "form_factor" text NOT NULL, - "ram_type" text NOT NULL, - "num_ram_slots" integer NOT NULL, - "max_ram_capacity" numeric NOT NULL, - "pci_express_slots" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "network_adapter" ( - "component_id" integer PRIMARY KEY NOT NULL, - "wifi_version" text NOT NULL, - "interface" text NOT NULL, - "num_antennas" integer NOT NULL -); ---> statement-breakpoint -CREATE TABLE "network_card" ( - "component_id" integer PRIMARY KEY NOT NULL, - "num_ports" integer NOT NULL, - "speed" numeric NOT NULL, - "interface" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "optical_drive" ( - "component_id" integer PRIMARY KEY NOT NULL, - "form_factor" text NOT NULL, - "type" text NOT NULL, - "interface" text NOT NULL, - "write_speed" numeric NOT NULL, - "read_speed" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "pc_case" ( - "component_id" integer PRIMARY KEY NOT NULL, - "cooler_max_height" numeric NOT NULL, - "gpu_max_length" numeric NOT NULL -); ---> statement-breakpoint -CREATE TABLE "power_supply" ( - "component_id" integer PRIMARY KEY NOT NULL, - "type" text NOT NULL, - "wattage" numeric NOT NULL, - "form_factor" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "sound_card" ( - "component_id" integer PRIMARY KEY NOT NULL, - "sample_rate" numeric NOT NULL, - "bit_depth" numeric NOT NULL, - "chipset" text NOT NULL, - "interface" text NOT NULL, - "channel" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "storage" ( - "component_id" integer PRIMARY KEY NOT NULL, - "type" text NOT NULL, - "capacity" numeric NOT NULL, - "form_factor" text NOT NULL -); ---> statement-breakpoint -CREATE TABLE "admins" ( - "user_id" integer PRIMARY KEY NOT NULL -); ---> statement-breakpoint -CREATE TABLE "suggestions" ( - "id" serial PRIMARY KEY NOT NULL, - "user_id" integer NOT NULL, - "admin_id" integer, - "link" text NOT NULL, - "admin_comment" text, - "description" text, - "status" text DEFAULT 'pending' NOT NULL, - "component_type" text NOT NULL, - CONSTRAINT "check_status" CHECK ("suggestions"."status" in ('pending', 'approved', 'rejected')), - CONSTRAINT "check_type" CHECK ("suggestions"."component_type" in - ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')) -); ---> statement-breakpoint -CREATE TABLE "users" ( - "id" serial PRIMARY KEY NOT NULL, - "username" text NOT NULL, - "password" text NOT NULL, - "email" text NOT NULL, - CONSTRAINT "users_username_unique" UNIQUE("username"), - CONSTRAINT "users_email_unique" UNIQUE("email") -); ---> statement-breakpoint -ALTER TABLE "build_component" ADD CONSTRAINT "build_component_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "build_component" ADD CONSTRAINT "build_component_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "build" ADD CONSTRAINT "build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "favorite_build" ADD CONSTRAINT "favorite_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "rating_build" ADD CONSTRAINT "rating_build_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "review" ADD CONSTRAINT "review_build_id_build_id_fk" FOREIGN KEY ("build_id") REFERENCES "public"."build"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "review" ADD CONSTRAINT "review_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "cpu" ADD CONSTRAINT "cpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "gpu" ADD CONSTRAINT "gpu_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "cables" ADD CONSTRAINT "cables_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "case_mobo_form_factors" ADD CONSTRAINT "case_mobo_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "case_ps_form_factors" ADD CONSTRAINT "case_ps_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "case_storage_form_factors" ADD CONSTRAINT "case_storage_form_factors_case_id_pc_case_component_id_fk" FOREIGN KEY ("case_id") REFERENCES "public"."pc_case"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "cooler_cpu_sockets" ADD CONSTRAINT "cooler_cpu_sockets_cooler_id_cooler_component_id_fk" FOREIGN KEY ("cooler_id") REFERENCES "public"."cooler"("component_id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "cooler" ADD CONSTRAINT "cooler_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "memory_card" ADD CONSTRAINT "memory_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "memory" ADD CONSTRAINT "memory_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "motherboard" ADD CONSTRAINT "motherboard_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "network_adapter" ADD CONSTRAINT "network_adapter_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "network_card" ADD CONSTRAINT "network_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "optical_drive" ADD CONSTRAINT "optical_drive_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "pc_case" ADD CONSTRAINT "pc_case_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "power_supply" ADD CONSTRAINT "power_supply_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "sound_card" ADD CONSTRAINT "sound_card_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "storage" ADD CONSTRAINT "storage_component_id_components_id_fk" FOREIGN KEY ("component_id") REFERENCES "public"."components"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "admins" ADD CONSTRAINT "admins_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint -ALTER TABLE "suggestions" ADD CONSTRAINT "suggestions_admin_id_admins_user_id_fk" FOREIGN KEY ("admin_id") REFERENCES "public"."admins"("user_id") ON DELETE set null ON UPDATE cascade; Index: database/migrations/meta/0000_snapshot.json =================================================================== --- database/migrations/meta/0000_snapshot.json (revision 3a9c59cba2839f8be6bd0a5327349ee3883c2ee4) +++ database/migrations/meta/0000_snapshot.json (revision a5084806a09c4abfab269ed52d3659d37394a106) @@ -1,4 +1,4 @@ { - "id": "d1ab4ce8-e387-4d74-8d5b-511fdbe0a032", + "id": "57cce218-a083-4ce5-a7f6-734995e78d37", "prevId": "00000000-0000-0000-0000-000000000000", "version": "7", Index: database/migrations/meta/_journal.json =================================================================== --- database/migrations/meta/_journal.json (revision 3a9c59cba2839f8be6bd0a5327349ee3883c2ee4) +++ database/migrations/meta/_journal.json (revision a5084806a09c4abfab269ed52d3659d37394a106) @@ -6,6 +6,6 @@ "idx": 0, "version": "7", - "when": 1769598141213, - "tag": "0000_shallow_darkhawk", + "when": 1771530903611, + "tag": "0000_colorful_scream", "breakpoints": true }