RelationalDesign: data_load.sql

File data_load.sql, 23.8 KB (added by 233194, 4 days ago)
Line 
1SET search_path TO pcforge;
2TRUNCATE TABLE
3 suggestions,
4 cooler_cpu_sockets,
5 case_mobo_form_factors,
6 case_ps_form_factors,
7 case_storage_form_factors,
8 build_component,
9 favorite_build,
10 rating_build,
11 review,
12 build,
13 admins,
14 users,
15 network_card,
16 network_adapter,
17 cables,
18 sound_card,
19 optical_drive,
20 memory_card,
21 storage,
22 motherboard,
23 cooler,
24 pc_case,
25 power_supply,
26 memory,
27 gpu,
28 cpu,
29 components
30RESTART IDENTITY CASCADE;
31
32INSERT INTO users (username, password, email) VALUES
33('tome', 'tg', 'tome.gjorgiev@gmail.com'),
34('mihail', 'mn', 'mihail.naumov@gmail.com'),
35('stefan', 'sv', 'stefan.velkovski@gmail.com'),
36('admin', 'admin', 'admin@gmail.com'),
37('pc_wizard', 'pw', 'wizard@gmail.com'),
38('budget_king', 'bk', 'budget@gmail.com'),
39('rgb_lover', 'rgb', 'rgblover@gmail.com'),
40('streamer_pro', 'sp', 'streamer@gmail.com'),
41('office_guy', 'og', 'office@gmail.com'),
42('linux_fan', 'lf', 'linux@gmail.com'),
43('first_timer', 'ft', 'noob@gmail.com');
44
45INSERT INTO admins (user_id) VALUES (4);
46
47INSERT INTO components (name, brand, price, type, img_url) VALUES
48('Ryzen 5 5600X', 'AMD', 199.99, 'cpu', NULL),
49('RTX 3060', 'NVIDIA', 329.99, 'gpu', NULL),
50('16GB DDR4 Kit', 'Corsair', 79.99, 'memory', NULL),
51('650W PSU', 'EVGA', 89.99, 'power_supply', NULL),
52('Mid Tower Case', 'NZXT', 119.99, 'case', NULL),
53('Air Cooler', 'Noctua', 69.99, 'cooler', NULL),
54('B550 Motherboard', 'ASUS', 149.99, 'motherboard', NULL),
55('1TB NVMe SSD', 'Samsung', 129.99, 'storage', NULL),
56('Sound Card', 'Creative', 59.99, 'sound_card', NULL),
57('Network Card', 'Intel', 39.99, 'network_card',NULL),
58('Network Adapter', 'TP-Link', 29.99, 'network_adapter', NULL),
59('Optical Drive', 'LG', 19.99, 'optical_drive', NULL),
60('Memory Card', 'SanDisk', 15.99, 'memory_card', NULL),
61('Cables Pack', 'Corsair', 9.99, 'cables', NULL),
62('Ryzen 5 7600', 'AMD', 229.00, 'cpu', 'https://placehold.co/400x400?text=GPU'),
63('Ryzen 7 7800X3D', 'AMD', 399.00, 'cpu', 'https://placehold.co/400x400?text=GPU'),
64('Ryzen 9 7950X', 'AMD', 599.00, 'cpu', 'https://placehold.co/400x400?text=GPU'),
65('Core i3-13100F', 'Intel', 119.99, 'cpu', 'https://placehold.co/400x400?text=GPU'),
66('Core i5-13600K', 'Intel', 319.99, 'cpu', 'https://placehold.co/400x400?text=GPU'),
67('Core i7-14700K', 'Intel', 409.99, 'cpu', 'https://placehold.co/400x400?text=GPU'),
68('Core i9-14900KS', 'Intel', 689.99, 'cpu', 'https://placehold.co/400x400?text=GPU'),
69('Radeon RX 6600', 'PowerColor', 199.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
70('Radeon RX 7600', 'Sapphire', 269.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
71('Radeon RX 7800 XT', 'XFX', 499.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
72('Radeon RX 7900 XTX', 'Sapphire', 999.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
73('GeForce RTX 3050', 'MSI', 229.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
74('GeForce RTX 4060', 'Zotac', 299.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
75('GeForce RTX 4070 Super', 'ASUS', 599.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
76('GeForce RTX 4080 Super', 'Gigabyte', 999.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
77('GeForce RTX 4090', 'NVIDIA', 1599.99, 'gpu', 'https://placehold.co/400x400?text=GPU'),
78('B650M DS3H', 'Gigabyte', 149.99, 'motherboard', 'https://placehold.co/400x400?text=GPU'),
79('X670E AORUS Master', 'Gigabyte', 459.99, 'motherboard', 'https://placehold.co/400x400?text=GPU'),
80('B760M Bomber WiFi', 'MSI', 129.99, 'motherboard', 'https://placehold.co/400x400?text=GPU'),
81('Z790 Maximus Hero', 'ASUS', 599.99, 'motherboard', 'https://placehold.co/400x400?text=GPU'),
82('Vengeance LPX 16GB', 'Corsair', 39.99, 'memory', NULL),
83('Ripjaws V 32GB', 'G.Skill', 69.99, 'memory', NULL),
84('Trident Z5 RGB 32GB', 'G.Skill', 114.99, 'memory', NULL),
85('Dominator Platinum 64GB', 'Corsair', 289.99, 'memory', NULL),
86('Crucial P3 1TB', 'Crucial', 64.99, 'storage', NULL),
87('WD Black SN850X 2TB', 'Western Digital', 159.99, 'storage', NULL),
88('Samsung 990 Pro 4TB', 'Samsung', 349.99, 'storage', NULL),
89('H5 Flow', 'NZXT', 94.99, 'case', NULL),
90('4000D Airflow', 'Corsair', 104.99, 'case', NULL),
91('O11 Dynamic Evo', 'Lian Li', 159.99, 'case', NULL),
92('Versa H18', 'Thermaltake', 49.99, 'case', NULL),
93('Smart 500W', 'Thermaltake', 39.99, 'power_supply', NULL),
94('RM750e', 'Corsair', 99.99, 'power_supply', NULL),
95('SuperNOVA 1000 GT', 'EVGA', 169.99, 'power_supply', NULL),
96('Peerless Assassin 120 SE', 'Thermalright', 33.90, 'cooler', NULL),
97('Kraken Elite 360', 'NZXT', 279.99, 'cooler', NULL);
98
99INSERT INTO cpu (component_id, socket, cores, threads, base_clock, boost_clock, tdp) VALUES
100(1, 'AM4', 6, 12, 3.7, 4.6, 65),
101((SELECT id FROM components WHERE name='Ryzen 5 7600'), 'AM5', 6, 12, 3.8, 5.1, 65),
102((SELECT id FROM components WHERE name='Ryzen 7 7800X3D'), 'AM5', 8, 16, 4.2, 5.0, 120),
103((SELECT id FROM components WHERE name='Ryzen 9 7950X'), 'AM5', 16, 32, 4.5, 5.7, 170),
104((SELECT id FROM components WHERE name='Core i3-13100F'), 'LGA1700', 4, 8, 3.4, 4.5, 58),
105((SELECT id FROM components WHERE name='Core i5-13600K'), 'LGA1700', 14, 20, 3.5, 5.1, 125),
106((SELECT id FROM components WHERE name='Core i7-14700K'), 'LGA1700', 20, 28, 3.4, 5.6, 125),
107((SELECT id FROM components WHERE name='Core i9-14900KS'), 'LGA1700', 24, 32, 3.2, 6.2, 150);
108
109INSERT INTO gpu (component_id, vram, tdp, base_clock, boost_clock, chipset, length) VALUES
110(2, 12, 170, 1.32, 1.78, 'RTX 3060', 242),
111((SELECT id FROM components WHERE name='Radeon RX 6600'), 8, 132, 2.0, 2.4, 'RX 6600', 200),
112((SELECT id FROM components WHERE name='Radeon RX 7600'), 8, 165, 2.2, 2.6, 'RX 7600', 240),
113((SELECT id FROM components WHERE name='Radeon RX 7800 XT'), 16, 263, 2.1, 2.4, 'RX 7800 XT', 280),
114((SELECT id FROM components WHERE name='Radeon RX 7900 XTX'), 24, 355, 2.3, 2.5, 'RX 7900 XTX', 320),
115((SELECT id FROM components WHERE name='GeForce RTX 3050'), 8, 130, 1.5, 1.7, 'RTX 3050', 200),
116((SELECT id FROM components WHERE name='GeForce RTX 4060'), 8, 115, 1.8, 2.4, 'RTX 4060', 220),
117((SELECT id FROM components WHERE name='GeForce RTX 4070 Super'), 12, 220, 1.9, 2.5, 'RTX 4070 S', 260),
118((SELECT id FROM components WHERE name='GeForce RTX 4080 Super'), 16, 320, 2.2, 2.5, 'RTX 4080 S', 300),
119((SELECT id FROM components WHERE name='GeForce RTX 4090'), 24, 450, 2.2, 2.5, 'RTX 4090', 340);
120
121INSERT INTO motherboard (component_id, socket, chipset, form_factor, ram_type, num_ram_slots, max_ram_capacity, pci_express_slots) VALUES
122(7, 'AM4', 'B550', 'ATX', 'DDR4', 4, 128, 3),
123((SELECT id FROM components WHERE name='B650M DS3H'), 'AM5', 'B650', 'Micro-ATX', 'DDR5', 4, 128, 2),
124((SELECT id FROM components WHERE name='X670E AORUS Master'), 'AM5', 'X670E', 'ATX', 'DDR5', 4, 192, 3),
125((SELECT id FROM components WHERE name='B760M Bomber WiFi'), 'LGA1700', 'B760', 'Micro-ATX', 'DDR4', 2, 64, 1),
126((SELECT id FROM components WHERE name='Z790 Maximus Hero'), 'LGA1700', 'Z790', 'ATX', 'DDR5', 4, 192, 3);
127
128INSERT INTO memory (component_id, type, speed, capacity, modules) VALUES
129(3, 'DDR4', 3200, 16, 2),
130((SELECT id FROM components WHERE name='Vengeance LPX 16GB'), 'DDR4', 3200, 16, 2),
131((SELECT id FROM components WHERE name='Ripjaws V 32GB'), 'DDR4', 3600, 32, 2),
132((SELECT id FROM components WHERE name='Trident Z5 RGB 32GB'), 'DDR5', 6000, 32, 2),
133((SELECT id FROM components WHERE name='Dominator Platinum 64GB'), 'DDR5', 6400, 64, 2);
134
135INSERT INTO storage (component_id, type, capacity, form_factor) VALUES
136(8, 'NVMe', 1000, 'M.2'),
137((SELECT id FROM components WHERE name='Crucial P3 1TB'), 'NVMe', 1000, 'M.2'),
138((SELECT id FROM components WHERE name='WD Black SN850X 2TB'), 'NVMe', 2000, 'M.2'),
139((SELECT id FROM components WHERE name='Samsung 990 Pro 4TB'), 'NVMe', 4000, 'M.2');
140
141INSERT INTO pc_case (component_id, cooler_max_height, gpu_max_length) VALUES
142(5, 165, 300),
143((SELECT id FROM components WHERE name='H5 Flow'), 165, 365),
144((SELECT id FROM components WHERE name='4000D Airflow'), 170, 360),
145((SELECT id FROM components WHERE name='O11 Dynamic Evo'), 167, 422),
146((SELECT id FROM components WHERE name='Versa H18'), 155, 350);
147
148INSERT INTO case_mobo_form_factors (case_id, form_factor) VALUES
149(5, 'ATX'), (5, 'Micro-ATX');
150
151INSERT INTO power_supply (component_id, type, wattage, form_factor) VALUES
152(4, 'Modular', 650, 'ATX'),
153((SELECT id FROM components WHERE name='Smart 500W'), 'Non-Modular', 500, 'ATX'),
154((SELECT id FROM components WHERE name='RM750e'), 'Fully Modular', 750, 'ATX'),
155((SELECT id FROM components WHERE name='SuperNOVA 1000 GT'), 'Fully Modular', 1000, 'ATX');
156
157INSERT INTO cooler (component_id, type, height, max_tdp_supported) VALUES
158(6, 'Air', 158, 150),
159((SELECT id FROM components WHERE name='Peerless Assassin 120 SE'), 'Air', 155, 245),
160((SELECT id FROM components WHERE name='Kraken Elite 360'), 'Liquid', 55, 300);
161
162INSERT INTO cooler_cpu_sockets (cooler_id, socket) VALUES
163(6, 'AM4'), (6, 'AM5');
164
165INSERT INTO sound_card (component_id, sample_rate, bit_depth, chipset, interface, channel) VALUES (9, 192000, 24, 'SoundCore', 'PCIe', '7.1');
166INSERT INTO network_card (component_id, num_ports, speed, interface) VALUES (10, 2, 1000, 'PCIe');
167INSERT INTO network_adapter (component_id, wifi_version, interface, num_antennas) VALUES (11, 'WiFi 6', 'PCIe', 3);
168INSERT INTO optical_drive (component_id, form_factor, type, interface, write_speed, read_speed) VALUES (12, '5.25"', 'DVD-RW', 'SATA', 16, 16);
169INSERT INTO memory_card (component_id, num_slots, interface) VALUES (13, 1, 'SD');
170INSERT INTO cables (component_id, length_cm, type) VALUES (14, 50, 'SATA');
171
172INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
173(1, 'Gaming Build', CURRENT_DATE, 'Mid-range gaming PC', 1139.92, TRUE);
174INSERT INTO build_component (build_id, component_id) VALUES
175(1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8);
176
177INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
178((SELECT id FROM users WHERE username='budget_king'), 'Console Killer 2025', '2024-12-01', 'Cheap entry level gaming PC', 580.00, TRUE);
179INSERT INTO build_component (build_id, component_id) VALUES
180((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Core i3-13100F')),
181((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Radeon RX 6600')),
182((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='B760M Bomber WiFi')),
183((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Vengeance LPX 16GB')),
184((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Crucial P3 1TB')),
185((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Smart 500W')),
186((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM components WHERE name='Versa H18'));
187
188INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
189((SELECT id FROM users WHERE username='streamer_pro'), 'Pro Streaming Rig', '2025-01-15', 'Handles OBS and 1440p gaming flawlessly', 2150.00, TRUE);
190INSERT INTO build_component (build_id, component_id) VALUES
191((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='Core i7-14700K')),
192((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='GeForce RTX 4080 Super')),
193((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='Z790 Maximus Hero')),
194((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='Trident Z5 RGB 32GB')),
195((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='WD Black SN850X 2TB')),
196((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='SuperNOVA 1000 GT')),
197((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='H5 Flow')),
198((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM components WHERE name='Kraken Elite 360'));
199
200INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
201((SELECT id FROM users WHERE username='pc_wizard'), 'Team Red Value King', '2025-02-10', 'Pure rasterization performance', 1450.00, TRUE);
202INSERT INTO build_component (build_id, component_id) VALUES
203((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Ryzen 7 7800X3D')),
204((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Radeon RX 7800 XT')),
205((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='B650M DS3H')),
206((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Trident Z5 RGB 32GB')),
207((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Crucial P3 1TB')),
208((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='RM750e')),
209((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='4000D Airflow')),
210((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM components WHERE name='Peerless Assassin 120 SE'));
211
212INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
213((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);
214INSERT INTO build_component (build_id, component_id) VALUES
215((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Core i9-14900KS')),
216((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='GeForce RTX 4090')),
217((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Z790 Maximus Hero')),
218((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Dominator Platinum 64GB')),
219((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Samsung 990 Pro 4TB')),
220((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='SuperNOVA 1000 GT')),
221((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='O11 Dynamic Evo')),
222((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM components WHERE name='Kraken Elite 360'));
223
224INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
225((SELECT id FROM users WHERE username='first_timer'), 'Snow White Build', '2024-11-20', 'First time building, went for looks', 1199.00, TRUE);
226INSERT INTO build_component (build_id, component_id) VALUES
227((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='Ryzen 5 7600')),
228((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='GeForce RTX 4070 Super')),
229((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='B650M DS3H')),
230((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='Trident Z5 RGB 32GB')),
231((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='Crucial P3 1TB')),
232((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='RM750e')),
233((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM components WHERE name='H5 Flow'));
234
235INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
236((SELECT id FROM users WHERE username='linux_fan'), 'Arch Linux Dev Box', '2024-10-15', 'Compilation beast, no Nvidia drivers needed', 920.00, TRUE);
237INSERT INTO build_component (build_id, component_id) VALUES
238((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Core i5-13600K')),
239((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Radeon RX 7600')),
240((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='B760M Bomber WiFi')),
241((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Ripjaws V 32GB')),
242((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Crucial P3 1TB')),
243((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='RM750e')),
244((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM components WHERE name='Versa H18'));
245
246INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
247((SELECT id FROM users WHERE username='office_guy'), '1080p Gamer', '2025-01-05', 'Just for Fortnite and Apex', 810.00, TRUE);
248INSERT INTO build_component (build_id, component_id) VALUES
249((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Core i3-13100F')),
250((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='GeForce RTX 4060')),
251((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='B760M Bomber WiFi')),
252((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Vengeance LPX 16GB')),
253((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Crucial P3 1TB')),
254((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Smart 500W')),
255((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM components WHERE name='Versa H18'));
256
257INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
258((SELECT id FROM users WHERE username='pc_wizard'), 'Silent Night', '2024-12-25', 'Zero RPM fan mode build', 2450.00, TRUE);
259INSERT INTO build_component (build_id, component_id) VALUES
260((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='Core i7-14700K')),
261((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='GeForce RTX 4080 Super')),
262((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='Z790 Maximus Hero')),
263((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='Trident Z5 RGB 32GB')),
264((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='WD Black SN850X 2TB')),
265((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='SuperNOVA 1000 GT')),
266((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='4000D Airflow')),
267((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM components WHERE name='Peerless Assassin 120 SE'));
268
269INSERT INTO build (user_id, name, created_at, description, total_price, is_approved) VALUES
270((SELECT id FROM users WHERE username='rgb_lover'), 'Radeon Ultimate', '2025-03-10', '4K Gaming without Nvidia tax', 2850.00, TRUE);
271INSERT INTO build_component (build_id, component_id) VALUES
272((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Ryzen 9 7950X')),
273((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Radeon RX 7900 XTX')),
274((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='X670E AORUS Master')),
275((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Dominator Platinum 64GB')),
276((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Samsung 990 Pro 4TB')),
277((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='SuperNOVA 1000 GT')),
278((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='O11 Dynamic Evo')),
279((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM components WHERE name='Kraken Elite 360'));
280
281INSERT INTO rating_build (build_id, user_id, value) VALUES (1, 2, 5);
282INSERT INTO review (build_id, user_id, content, created_at) VALUES (1, 2, 'Still runs everything in 2025!', CURRENT_DATE);
283
284INSERT INTO rating_build (build_id, user_id, value) VALUES
285((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='rgb_lover'), 3),
286((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='pc_wizard'), 4);
287INSERT INTO review (build_id, user_id, content, created_at) VALUES
288((SELECT id FROM build WHERE name='Console Killer 2025'), (SELECT id FROM users WHERE username='rgb_lover'), 'No RGB, 3 stars.', '2024-12-05');
289
290INSERT INTO rating_build (build_id, user_id, value) VALUES
291((SELECT id FROM build WHERE name='Pro Streaming Rig'), (SELECT id FROM users WHERE username='pc_wizard'), 5);
292
293INSERT INTO rating_build (build_id, user_id, value) VALUES
294((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='budget_king'), 5),
295((SELECT id FROM build WHERE name='Team Red Value King'), (SELECT id FROM users WHERE username='first_timer'), 4);
296INSERT INTO review (build_id, user_id, content, created_at) VALUES
297((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');
298
299INSERT INTO rating_build (build_id, user_id, value) VALUES
300((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='streamer_pro'), 5),
301((SELECT id FROM build WHERE name='God Tier 4090 Build'), (SELECT id FROM users WHERE username='budget_king'), 2);
302INSERT INTO review (build_id, user_id, content, created_at) VALUES
303((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');
304
305INSERT INTO rating_build (build_id, user_id, value) VALUES
306((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='rgb_lover'), 5),
307((SELECT id FROM build WHERE name='Snow White Build'), (SELECT id FROM users WHERE username='office_guy'), 4);
308
309INSERT INTO rating_build (build_id, user_id, value) VALUES
310((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='linux_fan'), 5),
311((SELECT id FROM build WHERE name='Arch Linux Dev Box'), (SELECT id FROM users WHERE username='first_timer'), 1);
312INSERT INTO review (build_id, user_id, content, created_at) VALUES
313((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');
314
315INSERT INTO rating_build (build_id, user_id, value) VALUES
316((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='streamer_pro'), 2),
317((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='budget_king'), 3);
318INSERT INTO review (build_id, user_id, content, created_at) VALUES
319((SELECT id FROM build WHERE name='1080p Gamer'), (SELECT id FROM users WHERE username='streamer_pro'), 'Stutters in Warzone.', '2025-01-10');
320
321INSERT INTO rating_build (build_id, user_id, value) VALUES
322((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='rgb_lover'), 2),
323((SELECT id FROM build WHERE name='Silent Night'), (SELECT id FROM users WHERE username='office_guy'), 5);
324
325INSERT INTO rating_build (build_id, user_id, value) VALUES
326((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='pc_wizard'), 5),
327((SELECT id FROM build WHERE name='Radeon Ultimate'), (SELECT id FROM users WHERE username='linux_fan'), 5);
328
329INSERT INTO suggestions (user_id, admin_id, link, admin_comment, description, status, component_type) VALUES
330(1, 4, 'https://www.nvidia.com/en-us/geforce/graphics-cards/40-series/rtx-4070-family/', NULL, 'Consider adding RTX 4070', 'pending', 'gpu');