API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 25th, 2018
290
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 32.15 KB | None | 0 0
raw download clone embed print report
  1. CREATE SEQUENCE seq_id START WITH 1;
  2.  
  3. INSERT INTO cpu (id, brand, model, price, num_of_cores, base_frequency, turbo_frequency, socket, cache)
  4.           SELECT seq_id.NEXTVAL, tab.* FROM
  5.           (SELECT 'Intel', 'Core i3-100', 500, 2, 2.8, 3.0, '775', 35 FROM dual
  6. UNION ALL SELECT 'Intel', 'Core i3-200', 550, 2, 3.0, 3.2, '775', 35 FROM dual
  7. UNION ALL SELECT 'Intel', 'Core i5-400', 650, 2, 3.1, 3.2, '775', 35 FROM dual
  8. UNION ALL SELECT 'Intel', 'Core i5-500', 700, 2, 3.2, 3.4, '775', 35 FROM dual
  9. UNION ALL SELECT 'Intel', 'Core i5-600', 750, 4, 3.3, 3.5, '775', 35 FROM dual
  10. UNION ALL SELECT 'Intel', 'Core i5-600K', 800, 4, 3.4, 3.6, '775', 35 FROM dual
  11. UNION ALL SELECT 'Intel', 'Core i7-700', 850, 4, 3.5, 3.7, '775', 35 FROM dual
  12. UNION ALL SELECT 'Intel', 'Core i7-700K', 950, 4, 3.6, 3.8, '775', 35 FROM dual
  13. UNION ALL SELECT 'Intel', 'Core 2 Duo 100', 150, 2, 2.7, 4.2, '775', 35 FROM dual
  14. UNION ALL SELECT 'Intel', 'Core 2 Duo 200', 175, 2, 2.7, 4.2, '775', 35 FROM dual
  15. UNION ALL SELECT 'Intel', 'Pentium 110', 175, 2, 2.8, 2.9, '775', 35 FROM dual
  16. UNION ALL SELECT 'Intel', 'Pentium 120', 220, 2, 2.9, 3.2, '775', 35 FROM dual
  17. UNION ALL SELECT 'Intel', 'Celeron 101', 210, 1, 2.7, 3.1, '775', 35 FROM dual
  18. UNION ALL SELECT 'Intel', 'Celeron 102', 225, 2, 2.8, 3.2, '775', 35 FROM dual
  19. UNION ALL SELECT 'Intel', 'Core i3-2100', 500, 2, 2.8, 3.0, '775', 35 FROM dual
  20. UNION ALL SELECT 'Intel', 'Core i3-2200', 550, 2, 3.0, 3.2, '775', 35 FROM dual
  21. UNION ALL SELECT 'Intel', 'Core i5-2400', 650, 2, 3.1, 3.2, '775', 35 FROM dual
  22. UNION ALL SELECT 'Intel', 'Core i5-2500', 700, 2, 3.2, 3.4, '775', 35 FROM dual
  23. UNION ALL SELECT 'Intel', 'Core i5-2600', 750, 4, 3.3, 3.5, '775', 35 FROM dual
  24. UNION ALL SELECT 'Intel', 'Core i5-2600K', 800, 4, 3.4, 3.6, '775', 35 FROM dual
  25. UNION ALL SELECT 'Intel', 'Core i7-2700', 850, 4, 3.5, 3.7, '775', 35 FROM dual
  26. UNION ALL SELECT 'Intel', 'Core i7-2700K', 950, 4, 3.6, 3.8, '775', 35 FROM dual
  27. UNION ALL SELECT 'Intel', 'Core 2 Duo 2100', 150, 2, 2.7, 4.2, '775', 35 FROM dual
  28. UNION ALL SELECT 'Intel', 'Core 2 Duo 2200', 175, 2, 2.7, 4.2, '775', 35 FROM dual
  29. UNION ALL SELECT 'Intel', 'Pentium 2110', 175, 2, 2.8, 2.9, '775', 35 FROM dual
  30. UNION ALL SELECT 'Intel', 'Pentium 2120', 220, 2, 2.9, 3.2, '775', 35 FROM dual
  31. UNION ALL SELECT 'Intel', 'Celeron 2101', 210, 1, 2.7, 3.1, '775', 35 FROM dual
  32. UNION ALL SELECT 'Intel', 'Celeron 2102', 225, 2, 2.8, 3.2, '775', 35 FROM dual
  33. UNION ALL SELECT 'Intel', 'Core i3-3100', 500, 2, 2.8, 3.0, '775', 35 FROM dual
  34. UNION ALL SELECT 'Intel', 'Core i3-3200', 550, 2, 3.0, 3.2, '775', 35 FROM dual
  35. UNION ALL SELECT 'Intel', 'Core i5-3400', 650, 2, 3.1, 3.2, '775', 35 FROM dual
  36. UNION ALL SELECT 'Intel', 'Core i5-3500', 700, 2, 3.2, 3.4, '775', 35 FROM dual
  37. UNION ALL SELECT 'Intel', 'Core i5-3600', 750, 4, 3.3, 3.5, '775', 35 FROM dual
  38. UNION ALL SELECT 'Intel', 'Core i5-3600K', 800, 4, 3.4, 3.6, '775', 35 FROM dual
  39. UNION ALL SELECT 'Intel', 'Core i7-3700', 850, 4, 3.5, 3.7, '775', 35 FROM dual
  40. UNION ALL SELECT 'Intel', 'Core i7-3700K', 950, 4, 3.6, 3.8, '775', 35 FROM dual
  41. UNION ALL SELECT 'Intel', 'Pentium 3110', 175, 2, 2.8, 2.9, '775', 35 FROM dual
  42. UNION ALL SELECT 'Intel', 'Pentium 3120', 220, 2, 2.9, 3.2, '775', 35 FROM dual
  43. UNION ALL SELECT 'Intel', 'Core i3-4100', 500, 2, 2.8, 3.0, '1050', 35 FROM dual
  44. UNION ALL SELECT 'Intel', 'Core i3-4200', 550, 2, 3.0, 3.2, '1050', 35 FROM dual
  45. UNION ALL SELECT 'Intel', 'Core i5-4400', 650, 2, 3.1, 3.2, '1050', 35 FROM dual
  46. UNION ALL SELECT 'Intel', 'Core i5-4500', 700, 2, 3.2, 3.4, '1050', 35 FROM dual
  47. UNION ALL SELECT 'Intel', 'Core i5-4600', 750, 4, 3.3, 3.5, '1050', 35 FROM dual
  48. UNION ALL SELECT 'Intel', 'Core i5-4600K', 800, 4, 3.4, 3.6, '1050', 35 FROM dual
  49. UNION ALL SELECT 'Intel', 'Core i7-4700', 850, 4, 3.5, 3.7, '1050', 35 FROM dual
  50. UNION ALL SELECT 'Intel', 'Core i7-4700K', 950, 4, 3.6, 3.8, '1050', 35 FROM dual
  51. UNION ALL SELECT 'Intel', 'Core i3-5100', 500, 2, 2.9, 3.2, '1150', 35 FROM dual
  52. UNION ALL SELECT 'Intel', 'Core i3-5200', 550, 2, 3.1, 3.3, '1150', 35 FROM dual
  53. UNION ALL SELECT 'Intel', 'Core i5-5400', 650, 2, 3.2, 3.5, '1150', 35 FROM dual
  54. UNION ALL SELECT 'Intel', 'Core i5-5500', 700, 2, 3.3, 3.7, '1150', 35 FROM dual
  55. UNION ALL SELECT 'Intel', 'Core i5-5600', 750, 4, 3.4, 3.8, '1150', 35 FROM dual
  56. UNION ALL SELECT 'Intel', 'Core i5-5600K', 800, 4, 3.5, 3.9, '1150', 35 FROM dual
  57. UNION ALL SELECT 'Intel', 'Core i7-5700', 850, 4, 3.6, 4.0, '1150', 35 FROM dual
  58. UNION ALL SELECT 'Intel', 'Core i7-5700K', 950, 4, 3.7, 4.2, '1150', 35 FROM dual
  59. UNION ALL SELECT 'Intel', 'Pentium 5110', 175, 2, 2.8, 2.9, '1150', 35 FROM dual
  60. UNION ALL SELECT 'Intel', 'Pentium 5120', 220, 2, 2.9, 3.2, '1150', 35 FROM dual
  61. UNION ALL SELECT 'Intel', 'Core i3-6100', 500, 2, 2.8, 3.0, '1151', 35 FROM dual
  62. UNION ALL SELECT 'Intel', 'Core i3-6200', 550, 2, 3.0, 3.2, '1151', 35 FROM dual
  63. UNION ALL SELECT 'Intel', 'Core i5-6400', 650, 2, 3.1, 3.2, '1151', 35 FROM dual
  64. UNION ALL SELECT 'Intel', 'Core i5-6500', 700, 2, 3.2, 3.4, '1151', 35 FROM dual
  65. UNION ALL SELECT 'Intel', 'Core i5-6600', 750, 4, 3.3, 3.5, '1151', 35 FROM dual
  66. UNION ALL SELECT 'Intel', 'Core i5-6600K', 800, 4, 3.4, 3.6, '1151', 35 FROM dual
  67. UNION ALL SELECT 'Intel', 'Core i7-6700', 850, 4, 3.5, 3.7, '1151', 35 FROM dual
  68. UNION ALL SELECT 'Intel', 'Core i7-6700K', 950, 4, 3.6, 3.8, '1151', 35 FROM dual
  69. UNION ALL SELECT 'Intel', 'Core i3-7100', 500, 2, 2.8, 3.0, '1151', 35 FROM dual
  70. UNION ALL SELECT 'Intel', 'Core i3-7200', 550, 2, 3.0, 3.2, '1151', 35 FROM dual
  71. UNION ALL SELECT 'Intel', 'Core i5-7400', 650, 2, 3.1, 3.2, '1151', 35 FROM dual
  72. UNION ALL SELECT 'Intel', 'Core i5-7500', 700, 2, 3.2, 3.4, '1151', 35 FROM dual
  73. UNION ALL SELECT 'Intel', 'Core i5-7600', 750, 4, 3.3, 3.5, '1151', 35 FROM dual
  74. UNION ALL SELECT 'Intel', 'Core i5-7600K', 800, 4, 3.4, 3.6, '1151', 35 FROM dual
  75. UNION ALL SELECT 'Intel', 'Core i7-7700', 850, 4, 3.5, 3.7, '1151', 35 FROM dual
  76. UNION ALL SELECT 'Intel', 'Core i7-7700K', 950, 4, 3.6, 3.8, '1151', 35 FROM dual
  77. UNION ALL SELECT 'Intel', 'Core i3-8100', 500, 4, 3.5, 3.7, '1151', 35 FROM dual
  78. UNION ALL SELECT 'Intel', 'Core i3-8200', 550, 4, 3.6, 3.8, '1151', 35 FROM dual
  79. UNION ALL SELECT 'Intel', 'Core i5-8400', 850, 6, 3.7, 4.2, '1151', 35 FROM dual
  80. UNION ALL SELECT 'Intel', 'Core i5-8500', 900, 6, 3.7, 4.3, '1151', 35 FROM dual
  81. UNION ALL SELECT 'Intel', 'Core i5-8600', 950, 6, 3.8, 4.4, '1151', 35 FROM dual
  82. UNION ALL SELECT 'Intel', 'Core i5-8600K', 1100, 8, 3.9, 4.5, '1151', 35 FROM dual
  83. UNION ALL SELECT 'Intel', 'Core i7-8700', 1300, 8, 3.9, 4.5, '1151', 35 FROM dual
  84. UNION ALL SELECT 'Intel', 'Core i7-8700K', 1500, 8, 3.9, 4.6, '1151', 35 FROM dual
  85. UNION ALL SELECT 'Intel', 'Pentium 6110', 175, 2, 3.4, 3.7, '1151', 35 FROM dual
  86. UNION ALL SELECT 'Intel', 'Pentium 6120', 220, 2, 3.5, 3.8, '1151', 35 FROM dual
  87. UNION ALL SELECT 'AMD', 'Athlon 1', 220, 2, 3.1, 3.3, 'AM2', 35 FROM dual
  88. UNION ALL SELECT 'AMD', 'Athlon 2', 320, 2, 3.2, 3.4, 'AM2', 35 FROM dual
  89. UNION ALL SELECT 'AMD', 'Athlon X4', 420, 2, 3.3, 3.5, 'AM2', 35 FROM dual
  90. UNION ALL SELECT 'AMD', 'Phenom 1', 230, 2, 3.0, 3.2, 'AM2', 35 FROM dual
  91. UNION ALL SELECT 'AMD', 'Phenom 2', 250, 2, 3.1, 3.4, 'AM2', 35 FROM dual
  92. UNION ALL SELECT 'AMD', 'FX-6100', 420, 4, 3.3, 3.5, 'AM3', 35 FROM dual
  93. UNION ALL SELECT 'AMD', 'FX-6200', 520, 4, 3.4, 3.6, 'AM3', 35 FROM dual
  94. UNION ALL SELECT 'AMD', 'FX-8100', 600, 4, 3.5, 3.7, 'AM3', 35 FROM dual
  95. UNION ALL SELECT 'AMD', 'FX-8350', 700, 4, 3.6, 3.8, 'AM3', 35 FROM dual
  96. UNION ALL SELECT 'AMD', 'Ryzen 3 1200', 220, 4, 3.2, 3.6, 'AM4', 35 FROM dual
  97. UNION ALL SELECT 'AMD', 'Ryzen 3 1300X', 220, 4, 3.3, 3.7, 'AM4', 35 FROM dual
  98. UNION ALL SELECT 'AMD', 'Ryzen 5 1400', 220, 4, 3.4, 3.8, 'AM4', 35 FROM dual
  99. UNION ALL SELECT 'AMD', 'Ryzen 5 1500', 220, 4, 3.5, 3.9, 'AM4', 35 FROM dual
  100. UNION ALL SELECT 'AMD', 'Ryzen 5 1600', 220, 6, 3.6, 4.0, 'AM4', 35 FROM dual
  101. UNION ALL SELECT 'AMD', 'Ryzen 5 1600X', 220, 6, 3.7, 4.2, 'AM4', 35 FROM dual
  102. UNION ALL SELECT 'AMD', 'Ryzen 7 1700', 220, 8, 3.7, 4.4, 'AM4', 35 FROM dual
  103. UNION ALL SELECT 'AMD', 'Ryzen 7 1700X', 220, 8, 3.8, 4.6, 'AM4', 35 FROM dual
  104. UNION ALL SELECT 'AMD', 'Ryzen 3 2200G', 220, 4, 3.2, 3.6, 'AM4', 35 FROM dual
  105. UNION ALL SELECT 'AMD', 'Ryzen 5 2400G', 220, 4, 3.4, 3.8, 'AM4', 35 FROM dual
  106. UNION ALL SELECT 'AMD', 'Ryzen 5 2600', 220, 6, 3.6, 4.0, 'AM4', 35 FROM dual
  107. UNION ALL SELECT 'AMD', 'Ryzen 5 2600X', 220, 6, 3.7, 4.2, 'AM4', 35 FROM dual
  108. UNION ALL SELECT 'AMD', 'Ryzen 7 2700', 220, 8, 3.7, 4.4, 'AM4', 35 FROM dual
  109. UNION ALL SELECT 'AMD', 'Ryzen 7 2700X', 220, 8, 3.8, 4.6, 'AM4', 35 FROM dual) tab;
  110.  
  111. INSERT INTO motherboard (id, brand, model, price, socket, chipset, type_of_ram, num_of_ram_slots, max_amount_of_ram,
  112. num_of_usb_ports, num_of_pcie_ports, num_of_sata_ports, atx_format)
  113.           SELECT seq_id.NEXTVAL, tab.* FROM
  114.           (SELECT 'ASUS', 'ROG 123', 300, '775', 'B150', 'DDR2', 2, 8, 4, 1, 3, 'ATX' FROM dual
  115. UNION ALL SELECT 'ASUS', 'ROG 456', 300, '775', 'Z170', 'DDR2', 2, 8, 4, 1, 3, 'ATX' FROM dual
  116. UNION ALL SELECT 'ASUS', 'ROG DDFR', 300, '1050', 'Z170', 'DDR3', 4, 8, 4, 1, 3, 'ATX' FROM dual
  117. UNION ALL SELECT 'MSI', 'CARBON', 300, '1050', 'Z170', 'DDR3', 4, 8, 4, 1, 3, 'ATX' FROM dual
  118. UNION ALL SELECT 'MSI', 'CARBON 456', 350, '1150', 'Z170', 'DDR3', 4, 8, 4, 2, 3, 'ATX' FROM dual
  119. UNION ALL SELECT 'MSI', 'CARBON RFV', 400, '1150', 'Z170', 'DDR3', 4, 8, 4, 1, 4, 'ATX' FROM dual
  120. UNION ALL SELECT 'Gigabyte', 'GA-34-56', 350, '1151', 'Z170', 'DDR4', 4, 8, 4, 2, 3, 'ATX' FROM dual
  121. UNION ALL SELECT 'Gigabyte', 'GA-37-567', 500, '1151', 'Z170', 'DDR4', 4, 8, 4, 1, 6, 'ATX' FROM dual
  122. UNION ALL SELECT 'Gigabyte', 'GA-33-5347', 380, '1151', 'Z170', 'DDR4', 4, 8, 4, 1, 3, 'ATX' FROM dual
  123. UNION ALL SELECT 'Gigabyte', 'GA-37-235', 390, 'AM2', 'Z170', 'DDR2', 4, 8, 4, 1, 3, 'ATX' FROM dual
  124. UNION ALL SELECT 'MSI', 'TURBO GAMING', 420, 'AM2', 'Z170', 'DDR2', 4, 8, 4, 1, 3, 'ATX' FROM dual
  125. UNION ALL SELECT 'MSI', 'GAMING PLUS', 500, 'AM3', 'Z170', 'DDR4', 4, 16, 4, 2, 4, 'ATX' FROM dual
  126. UNION ALL SELECT 'MSI', 'COBRA ASD', 600, 'AM3', 'Z170', 'DDR4', 4, 16, 4, 2, 6, 'ATX' FROM dual
  127. UNION ALL SELECT 'ASUS', 'GAMING PRO PLUS', 700, '1151', 'Z170', 'DDR4', 2, 32, 4, 2, 4, 'ATX' FROM dual
  128. UNION ALL SELECT 'ASUS', 'SUPER GAMING', 800, '1151', 'Z170', 'DDR4', 4, 16, 4, 2, 3, 'ATX' FROM dual
  129. UNION ALL SELECT 'ASUS', 'GAMING PRO PLUS', 700, 'AM4', 'Z170', 'DDR4', 4, 16, 4, 2, 4, 'ATX' FROM dual
  130. UNION ALL SELECT 'ASUS', 'SUPER GAMING', 800, 'AM4', 'Z170', 'DDR4', 4, 32, 4, 2, 6, 'ATX' FROM dual) tab;
  131.  
  132. INSERT INTO memory (id, brand, model, price, amount_of_memory, type_of_ram, num_of_items, frequency, latency)
  133.           SELECT seq_id.NEXTVAL, tab.* FROM
  134.           (SELECT 'GOODRAM', 'GHT-485', 100, 2, 'DDR2', 1, 800, 9 FROM dual
  135. UNION ALL SELECT 'GOODRAM', 'UTJ-58', 120, 4, 'DDR2', 1, 1000, 8 FROM dual
  136. UNION ALL SELECT 'KINGSTON', 'URNF-858', 130, 4, 'DDR3', 1, 1300, 10 FROM dual
  137. UNION ALL SELECT 'KINGSTON', 'HFJJR-94', 200, 8, 'DDR3', 1, 1500, 11 FROM dual
  138. UNION ALL SELECT 'KINGSTON', 'YER-098', 350, 8, 'DDR3', 1, 1600, 13 FROM dual
  139. UNION ALL SELECT 'ADATA', 'THR-537', 100, 4, 'DDR4', 1, 2200, 17 FROM dual
  140. UNION ALL SELECT 'ADATA', 'FHHR-493', 200, 8, 'DDR4', 1, 2400, 16 FROM dual
  141. UNION ALL SELECT 'ADATA', 'FJJE-743', 300, 8, 'DDR4', 1, 2666, 16 FROM dual
  142. UNION ALL SELECT 'ADATA', 'HRHJ-842', 700, 16, 'DDR4', 1, 3000, 15 FROM dual
  143. UNION ALL SELECT 'ADATA', 'FEND-345', 800, 16, 'DDR4', 1, 3200, 14 FROM dual) tab;
  144.  
  145. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  146. VALUES (1, 'TOSHIBA', 'GHT-485', 150, 'HDD', 1024, 120, 150);
  147. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  148. VALUES (2, 'GOODRAM', 'SDE-43', 220, 'SSD', 128, 450, 520);
  149. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  150. VALUES (3, 'ADATA', 'FDF-78', 320, 'SSD', 250, 450, 520);
  151. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  152. VALUES (4, 'PLEXTOR', 'DFGFD-90', 320, 'SSD', 256, 450, 520);
  153. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  154. VALUES (5, 'CRUCIAL', 'ERT-435', 310, 'SSD', 480, 450, 520);
  155. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  156. VALUES (6, 'WD', 'FG-57', 240, 'HDD', 2048, 120, 150);
  157. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  158. VALUES (7, 'HGST', 'FG-58', 370, 'HDD', 4096, 120, 150);
  159. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  160. VALUES (8, 'KINGSTON', 'EWER-58', 560, 'SSD', 500, 450, 520);
  161. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  162. VALUES (9, 'GOODRAM', 'WER-58', 320, 'SSD', 512, 450, 520);
  163. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  164. VALUES (10, 'CRUCIAL', 'HGFF-58', 1260, 'SSD', 1024, 450, 520);
  165. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  166. VALUES (11, 'GOODRAM', 'JHY-58', 278, 'SSD', 120, 450, 520);
  167. INSERT INTO storage (id, brand, model, price, storage_type, storage_size, write_speed, read_speed)
  168. VALUES (12, 'ADATA', 'RTY-58', 220, 'SSD', 175, 450, 520);
  169.  
  170. INSERT INTO power_supply (id, brand, model, price, POWER, atx_format, efficiency)
  171.           SELECT seq_id.NEXTVAL, tab.* FROM
  172.           (SELECT 'SilentiumPC', 'GHT-485', 150, 450, 'ATX', 70 FROM dual
  173. UNION ALL SELECT 'Antec', 'HT-8789', 250, 550, 'ATX', 80 FROM dual
  174. UNION ALL SELECT 'Corsair', 'UR-8768', 260, 650, 'ATX', 80 FROM dual
  175. UNION ALL SELECT 'Chieftec', 'ERT-909', 350, 500, 'ATX', 90 FROM dual
  176. UNION ALL SELECT 'beQuiet', 'DF-87', 420, 550, 'ATX', 90 FROM dual
  177. UNION ALL SELECT 'MODECOM', 'HJR-768', 550, 750, 'ATX', 90 FROM dual) tab;
  178.  
  179. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (1, 'ASUS', 'GT 1030', 250, 1, 800, 'GDDR5', 128, 1, 1, 0, 0 );
  180. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (2, 'ASUS', 'GTX 1050', 550, 2, 2200, 'GDDR5', 128, 1, 1, 0, 0 );
  181. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (3, 'ASUS', 'GTX 1050Ti', 750, 4, 2400, 'GDDR5', 256, 1, 1, 1, 0 );
  182. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (4, 'ASUS', 'GTX 1060', 1250, 6, 2600, 'GDDR5', 256, 1, 1, 1, 0 );
  183. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (5, 'ASUS', 'GTX 1070', 2250, 6, 2800, 'GDDR5', 256, 1, 1, 1, 0 );
  184. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (6, 'ASUS', 'GTX 1070Ti', 2550, 8, 3800, 'GDDR5', 256, 1, 1, 1, 0 );
  185. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (7, 'ASUS', 'GTX 1080Ti', 3250, 11, 3800, 'GDDR5', 256, 1, 1, 2, 0 );
  186. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (8, 'ASUS', 'RTX 2070', 3250, 8, 4800, 'GDDR6', 256, 1, 0, 3, 0 );
  187. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (9, 'MSI', 'GTX 1050', 550, 2, 2200, 'GDDR5', 128, 1, 1, 0, 0 );
  188. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (10, 'MSI', 'GTX 1050Ti', 750, 4, 2400, 'GDDR5', 256, 1, 1, 1, 0 );
  189. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (11, 'MSI', 'GTX 1060', 1250, 6, 2600, 'GDDR5', 256, 1, 1, 1, 0 );
  190. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (12, 'MSI', 'GTX 1070', 2250, 6, 2800, 'GDDR5', 256, 1, 1, 1, 0 );
  191. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (13, 'MSI', 'GTX 1070Ti', 2550, 8, 3800, 'GDDR5', 256, 1, 1, 1, 0 );
  192. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (14, 'MSI', 'GTX 1080Ti', 3250, 11, 3800, 'GDDR5', 256, 1, 1, 2, 0 );
  193. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (15, 'MSI', 'RTX 2070', 3250, 8, 4800, 'GDDR6', 256, 1, 0, 3, 0 );
  194. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (16, 'Gigabyte', 'GTX 1050', 550, 2, 2200, 'GDDR5', 128, 1, 1, 0, 0 );
  195. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (17, 'Gigabyte', 'GTX 1050Ti', 750, 4, 2400, 'GDDR5', 256, 1, 1, 1, 0 );
  196. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (18, 'Gigabyte', 'GTX 1060', 1250, 6, 2600, 'GDDR5', 256, 1, 1, 1, 0 );
  197. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (19, 'Gigabyte', 'GTX 1070', 2250, 6, 2800, 'GDDR5', 256, 1, 1, 1, 0 );
  198. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (20, 'Gigabyte', 'GTX 1070Ti', 2550, 8, 3800, 'GDDR5', 256, 1, 1, 1, 0 );
  199. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (21, 'Gigabyte', 'GTX 1080Ti', 3250, 11, 3800, 'GDDR5', 256, 1, 1, 2, 0 );
  200. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (22, 'Gigabyte', 'RTX 2070', 3250, 8, 4800, 'GDDR6', 256, 1, 0, 3, 0 );
  201. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (23, 'ENVY', 'GTX 1050', 550, 2, 2200, 'GDDR5', 128, 1, 1, 0, 0 );
  202. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (24, 'ENVY', 'GTX 1050Ti', 750, 4, 2400, 'GDDR5', 256, 1, 1, 1, 0 );
  203. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (25, 'ENVY', 'GTX 1060', 1250, 6, 2600, 'GDDR5', 256, 1, 1, 1, 0 );
  204. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (26, 'ENVY', 'GTX 1070', 2250, 6, 2800, 'GDDR5', 256, 1, 1, 1, 0 );
  205. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (27, 'ENVY', 'GTX 1070Ti', 2550, 8, 3800, 'GDDR5', 256, 1, 1, 1, 0 );
  206. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (28, 'ENVY', 'GTX 1080Ti', 3250, 11, 3800, 'GDDR5', 256, 1, 1, 2, 0 );
  207. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (29, 'ENVY', 'RTX 2070', 3250, 8, 4800, 'GDDR6', 256, 1, 0, 3, 0 );
  208. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (30, 'Zotac', 'GTX 1050', 550, 2, 2200, 'GDDR5', 128, 1, 1, 0, 0 );
  209. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (31, 'Zotac', 'GTX 1050Ti', 750, 4, 2400, 'GDDR5', 256, 1, 1, 1, 0 );
  210. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (32, 'Zotac', 'GTX 1060', 1250, 6, 2600, 'GDDR5', 256, 1, 1, 1, 0 );
  211. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (33, 'Zotac', 'GTX 1070', 2250, 6, 2800, 'GDDR5', 256, 1, 1, 1, 0 );
  212. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (34, 'Zotac', 'GTX 1070Ti', 2550, 8, 3800, 'GDDR5', 256, 1, 1, 1, 0 );
  213. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (35, 'Zotac', 'GTX 1080Ti', 3250, 11, 3800, 'GDDR5', 256, 1, 1, 2, 0 );
  214. INSERT INTO graphic_card (id, brand, model, price, amount_of_memory, memory_frequency, memory_type, width_of_bus, num_of_hdmi_ports, num_of_dvi_ports, num_of_dp_ports, num_of_vga_ports) VALUES (36, 'Zotac', 'RTX 2070', 3250, 8, 4800, 'GDDR6', 256, 1, 0, 3, 0 );
  215.  
  216. INSERT INTO pc_case (id, brand, model, price, atx_formats, num_of_usb_front, max_length_of_gpu, storage_bays)
  217. VALUES (1, 'SilentiumPC', 'Regnum 1', 100, 'ATX', 3, 300, 3);
  218. INSERT INTO pc_case (id, brand, model, price, atx_formats, num_of_usb_front, max_length_of_gpu, storage_bays)
  219. VALUES (2, 'SilentiumPC', 'Regnum 4', 150, 'ATX', 3, 330, 4);
  220. INSERT INTO pc_case (id, brand, model, price, atx_formats, num_of_usb_front, max_length_of_gpu, storage_bays)
  221. VALUES (3, 'iBOX', 'HTU 1', 130, 'ATX', 3, 300, 2);
  222. INSERT INTO pc_case (id, brand, model, price, atx_formats, num_of_usb_front, max_length_of_gpu, storage_bays)
  223. VALUES (4, 'MODECOM', 'URJK-31', 170, 'ATX', 3, 300, 1);
  224. INSERT INTO pc_case (id, brand, model, price, atx_formats, num_of_usb_front, max_length_of_gpu, storage_bays)
  225. VALUES (5, 'LianLi', 'URIODK 1', 100, 'ATX', 3, 300, 4);
  226.  
  227. INSERT INTO disc_drive (id, brand, model, price, formats, write_speed, read_speed)
  228. VALUES (1, 'LiteOn', 'TKF-1', 50, 'CD DVD', 24, 32);
  229. INSERT INTO disc_drive (id, brand, model, price, formats, write_speed, read_speed)
  230. VALUES (2, 'LG', 'REF-1', 100, 'CD DVD', 24, 32);
  231. INSERT INTO disc_drive (id, brand, model, price, formats, write_speed, read_speed)
  232. VALUES (3, 'LiteOn', 'ETW-143', 150, 'CD DVD', 24, 32);
  233. INSERT INTO disc_drive (id, brand, model, price, formats, write_speed, read_speed)
  234. VALUES (4, 'ASUS', 'GTH-134', 170, 'CD DVD', 24, 32);
  235. INSERT INTO disc_drive (id, brand, model, price, formats, write_speed, read_speed)
  236. VALUES (5, 'LG', 'BNH-167', 300, 'CD DVD BD', 24, 32);
  237.  
  238. INSERT INTO network_card (id, brand, model, price, network_speed, network_standards)
  239. VALUES (1, 'TP-Link', 'TKF-1', 50, 100, 'a,b');
  240. INSERT INTO network_card (id, brand, model, price, network_speed, network_standards)
  241. VALUES (2, 'Edimax', 'GG-1', 150, 100, 'a,b,g');
  242. INSERT INTO network_card (id, brand, model, price, network_speed, network_standards)
  243. VALUES (3, 'TP-Link', 'GEGW-1', 50, 100, 'a,b,n');
  244. INSERT INTO network_card (id, brand, model, price, network_speed, network_standards)
  245. VALUES (4, 'ASUS', 'EG-1', 150, 100, 'a,b,g,n');
  246. INSERT INTO network_card (id, brand, model, price, network_speed, network_standards)
  247. VALUES (5, 'Edimax', 'EWEGG-1', 50, 100, 'a,b');
  248.  
  249. INSERT INTO sound_card (id, brand, model, price, audio_inputs, audio_outputs)
  250. VALUES (1, 'TP-Link', 'FRG-1', 50, 1, 1);
  251. INSERT INTO sound_card (id, brand, model, price, audio_inputs, audio_outputs)
  252. VALUES (2, 'Logitech', 'EWR-1', 150, 1, 1);
  253. INSERT INTO sound_card (id, brand, model, price, audio_inputs, audio_outputs)
  254. VALUES (3, 'Creative', 'WEFG-1', 50, 1, 1);
  255. INSERT INTO sound_card (id, brand, model, price, audio_inputs, audio_outputs)
  256. VALUES (4, 'Samsung', 'EEG-1', 150, 1, 1);
  257. INSERT INTO sound_card (id, brand, model, price, audio_inputs, audio_outputs)
  258. VALUES (5, 'LG', 'EWG-1', 50, 1, 1);
  259.  
  260. INSERT INTO monitor (id, brand, model, price, screen_size, screen_resolution, screen_type, hdmi_ports, vga_ports, dvi_ports,
  261. dp_ports, audio_in, audio_out, speakers, touchscreen) VALUES
  262. (1, 'LG', 'WT-949594', 450, 22, '1920x1080', 'IPS', 1, 1, 0, 0, 0, 1, 0, 0);
  263. INSERT INTO monitor (id, brand, model, price, screen_size, screen_resolution, screen_type, hdmi_ports, vga_ports, dvi_ports,
  264. dp_ports, audio_in, audio_out, speakers, touchscreen) VALUES
  265. (2, 'ASUS', 'TY-5456', 350, 22, '1920x1080', 'TN', 1, 1, 0, 0, 0, 1, 1, 0);
  266. INSERT INTO monitor (id, brand, model, price, screen_size, screen_resolution, screen_type, hdmi_ports, vga_ports, dvi_ports,
  267. dp_ports, audio_in, audio_out, speakers, touchscreen) VALUES
  268. (3, 'SAMSUNG', 'GHB-32455', 650, 24, '1920x1080', 'SVA', 1, 1, 0, 1, 0, 1, 0, 0);
  269. INSERT INTO monitor (id, brand, model, price, screen_size, screen_resolution, screen_type, hdmi_ports, vga_ports, dvi_ports,
  270. dp_ports, audio_in, audio_out, speakers, touchscreen) VALUES
  271. (4, 'iiyama', 'SHB-48085', 550, 27, '1920x1080', 'AMVA+', 1, 1, 0, 0, 0, 1, 0, 0);
  272. INSERT INTO monitor (id, brand, model, price, screen_size, screen_resolution, screen_type, hdmi_ports, vga_ports, dvi_ports,
  273. dp_ports, audio_in, audio_out, speakers, touchscreen) VALUES
  274. (5, 'SAMSUNG', 'RTY-2456', 570, 24, '1920x1080', 'PLS', 1, 1, 0, 0, 0, 1, 0, 0);
  275.  
  276. INSERT INTO desktop_pc (id, cpu_id, motherboard_id, storage_id) VALUES (1, 2, 129, 4);
  277. INSERT INTO desktop_pc (id, cpu_id, motherboard_id, storage_id) VALUES (2, 89, 128, 4);
  278. INSERT INTO desktop_pc (id, cpu_id, motherboard_id, storage_id) VALUES (3, 54, 131, 6);
  279. INSERT INTO desktop_pc (id, cpu_id, motherboard_id, storage_id) VALUES (4, 23, 129, 7);
  280. INSERT INTO desktop_pc (id, cpu_id, motherboard_id) VALUES (5, 23, 132);
  281. INSERT INTO desktop_pc (id, cpu_id, motherboard_id) VALUES (6, 26, 134);
  282. INSERT INTO desktop_pc (id, cpu_id, motherboard_id) VALUES (7, 28, 132);
  283. INSERT INTO desktop_pc (id, cpu_id, motherboard_id) VALUES (8, 56, 127);
  284.  
  285. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (1, 1, 2);
  286. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (2, 3, 1);
  287. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (3, 5, 5);
  288. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (4, 6, 4);
  289. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (5, 3, 2);
  290. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (6, 3, 1);
  291. INSERT INTO pc_set(id, desktop_pc_id, monitor_id) VALUES (7, 7, 4);
  292.  
  293. INSERT INTO laptop (id, model, brand, price, screen_size, screen_type, screen_resolution, cpu, cpu_cores, memory_amount,
  294. memory_frequency, storage_amount, storage_type, gpu, gpu_memory_type, gpu_memory, dimensions, weight, num_of_usb,
  295. video_outputs, keyboard_backlight) VALUES
  296. (1, 'MSI', 'GE60', 3500, 15.6, 'PLS', '1920x1080', 'i7-4700HQ', 4, 16, 1333, 250, 'SSD', 'GTX 860M', 'GDDR5',
  297. 2, '33x20x10', 2.4, 4, 2, 1);
  298. INSERT INTO laptop (id, model, brand, price, screen_size, screen_type, screen_resolution, cpu, cpu_cores, memory_amount,
  299. memory_frequency, storage_amount, storage_type, gpu, gpu_memory_type, gpu_memory, dimensions, weight, num_of_usb,
  300. video_outputs, keyboard_backlight) VALUES
  301. (2, 'ASUS', 'ROG 123', 4500, 15.6, 'EWV', '1920x1080', 'i7-7100HQ', 4, 16, 2400, 512, 'SSD', 'GTX 1050', 'GDDR5',
  302. 2, '33x20x10', 2.4, 4, 2, 1);
  303. INSERT INTO laptop (id, model, brand, price, screen_size, screen_type, screen_resolution, cpu, cpu_cores, memory_amount,
  304. memory_frequency, storage_amount, storage_type, gpu, gpu_memory_type, gpu_memory, dimensions, weight, num_of_usb,
  305. video_outputs, keyboard_backlight) VALUES
  306. (3, 'Lenovo', 'Legion Y520', 3500, 15.6, 'IPS', '1920x1080', 'i7-8100HQ', 4, 16, 1333, 250, 'SSD', 'GTX 1050Ti', 'GDDR5',
  307. 2, '33x20x10', 2.4, 4, 2, 1);
  308.  
  309. INSERT INTO keyboard (id, brand, model, price, backlight, additional_buttons, connection_type, keyboard_type)
  310. VALUES (1, 'Logitech', 'B150', 100, 0, 0, 'USB', 'Wired');
  311. INSERT INTO keyboard (id, brand, model, price, backlight, additional_buttons, connection_type, keyboard_type)
  312. VALUES (2, 'Microsoft', 'Wired 600', 100, 0, 0, 'USB', 'Wired');
  313. INSERT INTO keyboard (id, brand, model, price, backlight, additional_buttons, connection_type, keyboard_type)
  314. VALUES (3, 'Lenovo', 'Y560', 200, 1, 6, 'Bluetooth', 'Wireless');
  315.  
  316. INSERT INTO mouse (id, brand, model, price, mouse_type, connection_type, dpi, additional_buttons)
  317. VALUES (1, 'Logitech', 'B100', 100, 'Laser', 'USB', 1200, 0);
  318. INSERT INTO mouse (id, brand, model, price, mouse_type, connection_type, dpi, additional_buttons)
  319. VALUES (2, 'Modecom', 'YTH-35', 34, 'Light', 'USB', 800, 0);
  320. INSERT INTO mouse (id, brand, model, price, mouse_type, connection_type, dpi, additional_buttons)
  321. VALUES (3, 'Razer', 'Makumba', 450, 'Laser', 'Bluetooth', 2500, 7);
  322.  
  323. INSERT INTO customer(id, name, email, address, age) VALUES (1, 'John Doe', 'jdoe@mail.com', 'UK', 33);
  324. INSERT INTO customer(id, name, email, address, age) VALUES (2, 'Jane Doe', 'rgor@mail.com', 'UK', 45);
  325. INSERT INTO customer(id, name, email, address, age) VALUES (3, 'Mike Git', 'mg@mail.com', 'USA', 23);
  326. INSERT INTO customer(id, name, email, address, age) VALUES (4, 'Alien Mojito', 'almoh@mail.com', 'Australia', 67);
  327. INSERT INTO customer(id, name, email, address, age) VALUES (5, 'Olga Gaborova', 'olrus@mail.com', 'Russia', 34);
  328.  
  329. INSERT INTO orders (id, customer_id, order_date) VALUES (1, 1, (SELECT CURRENT_DATE FROM dual));
  330. INSERT INTO orders (id, customer_id, order_date) VALUES (2, 5, (SELECT CURRENT_DATE FROM dual));
  331. INSERT INTO orders (id, customer_id, order_date) VALUES (3, 3, (SELECT CURRENT_DATE FROM dual));
  332. INSERT INTO orders (id, customer_id, order_date) VALUES (4, 4, (SELECT CURRENT_DATE FROM dual));
  333. INSERT INTO orders (id, customer_id, order_date) VALUES (5, 2, (SELECT CURRENT_DATE FROM dual));
  334.  
  335. INSERT INTO order_product(id, order_id, cpu_id) VALUES (1, 2, 35);
  336. INSERT INTO order_product(id, order_id, cpu_id) VALUES (2, 2, 35);
  337. INSERT INTO order_product(id, order_id, cpu_id) VALUES (3, 3, 67);
  338. INSERT INTO order_product(id, order_id, gpu_id) VALUES (4, 3, 12);
  339. INSERT INTO order_product(id, order_id, gpu_id) VALUES (5, 1, 21);
  340. INSERT INTO order_product(id, order_id, gpu_id) VALUES (6, 5, 18);
  341. INSERT INTO order_product(id, order_id, monitor_id) VALUES (7, 3, 3);
  342. INSERT INTO order_product(id, order_id, monitor_id) VALUES (8, 2, 1);
  343. INSERT INTO order_product(id, order_id, power_supply_id) VALUES (9, 1, 150);
  344. INSERT INTO order_product(id, order_id, power_supply_id) VALUES (10, 4, 151);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!