-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathComponents.sql
More file actions
241 lines (208 loc) · 28.9 KB
/
Copy pathComponents.sql
File metadata and controls
241 lines (208 loc) · 28.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
-- MySQL dump 10.13 Distrib 5.5.62, for Win64 (AMD64)
--
-- Host: localhost Database: components
-- ------------------------------------------------------
-- Server version 5.5.62
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE IF NOT EXISTS components;
USE components;
--
-- Table structure for table `cpus`
--
DROP TABLE IF EXISTS `cpus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cpus` (
`Name` varchar(30) DEFAULT NULL,
`Core` int(11) DEFAULT NULL,
`THREAD` int(11) DEFAULT NULL,
`Speed` varchar(20) DEFAULT NULL,
`Socket` varchar(30) DEFAULT NULL,
`Model` varchar(10) NOT NULL DEFAULT '',
`wattage` int(11) DEFAULT NULL,
`Price` decimal(12,2) DEFAULT '0.00',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cpus`
--
LOCK TABLES `cpus` WRITE;
/*!40000 ALTER TABLE `cpus` DISABLE KEYS */;
INSERT INTO `cpus` VALUES ('Ryzen 5 3600X',6,12,'3.8 - 4.4 Ghz','AM4','AMD-350',95,22000.00),('Ryzen 7 3700X',8,16,'3.6 - 4.4 Ghz','AM4','AMD-370',65,24000.00),('Ryzen 7 3800X',8,16,'3.8 - 4.7 Ghz','AM4','AMD-371',105,30000.00),('Ryzen 9 3900',12,24,'3.1 - 4.3 Ghz','AM4','AMD-390',65,37000.00),('Ryzen 9 3900X',12,24,'3.8 - 4.6 Ghz','AM4','AMD-391',105,40000.00),('Ryzen 5 5500',6,12,'3.6 - 4.2 Ghz','AM4','AMD-550',65,11000.00),('Ryzen 5 5500G',6,12,'3.9 - 4.4 Ghz','AM4','AMD-551',65,20000.00),('Ryzen 5 5600X',6,12,'3.7 - 4.4 Ghz','AM4','AMD-552',65,22500.00),('Ryzen 7 5700',8,16,'3.7 - 4.6 Ghz','AM4','AMD-570',65,24000.00),('Ryzen 7 5700X',8,16,'3.4 - 4.6 Ghz','AM4','AMD-571',65,27000.00),('Ryzen 7 5800',8,16,'3.4 - 4.6 Ghz','AM4','AMD-572',65,18000.00),('Ryzen 7 5800X',8,16,'3.8 - 4.7 Ghz','AM4','AMD-573',105,21000.00),('Ryzen 9 5900',12,24,'3.0 - 4.7 Ghz','AM4','AMD-590',65,28000.00),('Ryzen 9 5900X',12,24,'3.7 - 4.8 Ghz','AM4','AMD-591',105,32000.00),('Ryzen 9 5950X',16,32,'3.4 - 4.9 Ghz','AM4','AMD-592',105,38000.00),('Ryzen 5 7600',6,12,'3.8 - 5.1 Ghz','AM5','AMD-750',65,18500.00),('Ryzen 5 7600X',6,12,'4.7 - 5.3 Ghz','AM5','AMD-751',105,19500.00),('Ryzen 5 7600X3D',6,12,'4.1 - 4.7 Ghz','AM5','AMD-752',65,31000.00),('Ryzen 7 7700',8,16,'3.8 - 5.3 Ghz','AM5','AMD-770',65,29000.00),('Ryzen 7 7700X',8,16,'4.5 - 5.4 Ghz','AM5','AMD-771',105,33000.00),('Ryzen 7 7700X3D',8,16,'4.2 - 5.0 Ghz','AM5','AMD-772',120,41000.00),('Ryzen 9 7900',12,24,'3.7 - 5.4 Ghz','AM5','AMD-790',65,35000.00),('Ryzen 9 7900X',12,24,'4.7 - 5.6 Ghz','AM5','AMD-791',170,37000.00),('Ryzen 9 7950X',16,32,'4.5 - 5.7 Ghz','AM5','AMD-792',170,48000.00),('Ryzen 5 8400F',6,12,'4.2 - 4.7 Ghz','AM5','AMD-850',65,15400.00),('Ryzen 5 8500G',6,12,'3.5 - 5.0 Ghz','AM5','AMD-851',65,13800.00),('Ryzen 5 8600G',6,12,'4.3 - 5.0 Ghz','AM5','AMD-852',65,17000.00),('Ryzen 7 8700G',8,16,'4.2 - 5.1 Ghz','AM5','AMD-870',65,32000.00),('Ryzen 5 9600X',6,12,'3.9 - 5.4 Ghz','AM5','AMD-950',65,25000.00),('Ryzen 7 9700X',8,16,'3.8 - 5.5 Ghz','AM5','AMD-970',65,32000.00),('Ryzen 7 9700X3D',8,16,'4.7 - 5.2 Ghz','AM5','AMD-971',120,30000.00),('Ryzen 9 9900X',12,24,'4.4 - 5.6 Ghz','AM5','AMD-990',120,42000.00),('Ryzen 9 9950X',16,32,'4.3 - 5.7 Ghz','AM5','AMD-991',170,56000.00),('Core i5 10400',6,12,'2.9 - 4.3 Ghz','Socket 1200','INT-500',65,10500.00),('Core i5 10400F',6,12,'2.9 - 4.3 Ghz','Socket 1200','INT-501',65,9200.00),('Core i5 10500',6,12,'3.1 - 4.5 Ghz','Socket 1200','INT-502',65,12000.00),('Core i5 10600',6,12,'3.3 - 4.8 Ghz','Socket 1200','INT-503',65,16000.00),('Core i5 10600K',6,12,'4.1 - 4.8 Ghz','Socket 1200','INT-504',125,21000.00),('Core i5 10600KF',6,12,'4.1 - 4.8 Ghz','Socket 1200','INT-505',95,19000.00),('Core i5 11400',6,12,'2.6 - 4.4 Ghz','Socket 1200','INT-510',65,8500.00),('Core i5 11400F',6,12,'2.6 - 4.4 Ghz','Socket 1200','INT-511',65,10500.00),('Core i5 11500',6,12,'2.7 - 4.6 Ghz','Socket 1200','INT-512',65,13000.00),('Core i5 11600',6,12,'2.8 - 4.8 Ghz','Socket 1200','INT-513',65,15000.00),('Core i5 11600K',6,12,'3.9 - 4.9 Ghz','Socket 1200','INT-514',125,17500.00),('Core i5 11600KF',6,12,'3.9 - 4.9 Ghz','Socket 1200','INT-515',125,21000.00),('Core i5 12400',6,12,'2.5 - 4.4 Ghz','Socket 1700','INT-520',65,11000.00),('Core i5 12400F',6,12,'2.5 - 4.4 Ghz','Socket 1700','INT-521',65,13000.00),('Core i5 12500',6,12,'3.0 - 4.6 Ghz','Socket 1700','INT-522',65,17000.00),('Core i5 12600',6,12,'3.3 - 4.8 Ghz','Socket 1700','INT-523',65,17000.00),('Core i5 12600K',10,16,'3.7 - 4.9 Ghz','Socket 1700','INT-524',125,18500.00),('Core i5 12600KF',10,16,'3.7 - 4.9 Ghz','Socket 1700','INT-525',125,20000.00),('Core i5 13500',14,20,'2.5 - 4.8 Ghz','Socket 1700','INT-532',65,21500.00),('Core i5 13600',14,20,'2.7 - 5.0 Ghz','Socket 1700','INT-533',65,25000.00),('Core i5 13600K',14,20,'3.5 - 5.1 Ghz','Socket 1700','INT-534',125,28000.00),('Core i5 13600KF',14,20,'3.5 - 5.1 Ghz','Socket 1700','INT-535',125,30000.00),('Core i5 14400F',10,16,'2.5 - 4.7 Ghz','Socket 1700','INT-540',65,24000.00),('Core i5 14400T',10,16,'1.5 - 4.5 Ghz','Socket 1700','INT-541',35,30000.00),('Core i5 14600',14,20,'2.7 - 5.2 Ghz','Socket 1700','INT-543',65,20000.00),('Core i5 14600K',14,20,'3.5 - 5.3 Ghz','Socket 1700','INT-544',125,23000.00),('Core i5 14600KF',14,20,'3.5 - 5.3 Ghz','Socket 1700','INT-545',125,25900.00),('Core i7 10700',8,16,'2.9 - 4.8 Ghz','Socket 1200','INT-700',65,24500.00),('Core i7 10700F',8,16,'2.9 - 4.8 Ghz','Socket 1200','INT-701',65,25000.00),('Core i7 10700K',8,16,'3.8 - 5.1 Ghz','Socket 1200','INT-702',125,28500.00),('Core i7 10700KF',8,16,'3.8 - 5.1 Ghz','Socket 1200','INT-703',125,33000.00),('Core i7 11700T',8,16,'1.4 - 4.6 Ghz','Socket 1200','INT-710',35,28000.00),('Core i7 11700',8,16,'2.5 - 4.9 Ghz','Socket 1200','INT-711',65,22500.00),('Core i7 11700F',8,16,'2.5 - 4.9 Ghz','Socket 1200','INT-712',65,24000.00),('Core i7 11700K',8,16,'3.6 - 5.0 Ghz','Socket 1200','INT-713',125,31000.00),('Core i7 11700KF',8,16,'3.6 - 5.0 Ghz','Socket 1200','INT-714',125,36000.00),('Core i7 12700T',12,20,'1.4 - 4.7 Ghz','Socket 1700','INT-720',35,27500.00),('Core i7 12700E',12,20,'2.1 - 4.8 Ghz','Socket 1700','INT-721',65,30000.00),('Core i7 12700',12,20,'2.1 - 4.9 Ghz','Socket 1700','INT-722',65,26000.00),('Core i7 12700F',12,20,'2.1 - 4.9 Ghz','Socket 1700','INT-723',65,28500.00),('Core i7 12700K',12,20,'3.6 - 5.0 Ghz','Socket 1700','INT-724',125,30000.00),('Core i7 12700KF',12,20,'3.6 - 5.0 Ghz','Socket 1700','INT-725',125,31500.00),('Core i7 13700TE',16,24,'1.1 - 4.8 Ghz','Socket 1700','INT-730',35,34000.00),('Core i7 13700T',16,24,'1.4 - 4.9 Ghz','Socket 1700','INT-731',35,36000.00),('Core i7 13700E',16,24,'1.9 - 5.1 Ghz','Socket 1700','INT-732',65,35500.00),('Core i7 13700',16,24,'2.1 - 5.2 Ghz','Socket 1700','INT-733',65,34000.00),('Core i7 13700F',16,24,'2.1 - 5.2 Ghz','Socket 1700','INT-734',65,35000.00),('Core i7 13700K',16,24,'3.4 - 5.4 Ghz','Socket 1700','INT-735',125,40000.00),('Core i7 13700KF',16,24,'3.4 - 5.4 Ghz','Socket 1700','INT-736',125,42000.00),('Core i7 14701E',8,16,'2.6 - 5.4 Ghz','Socket 1700','INT-740',65,28000.00),('Core i7 14700T',20,28,'1.3 - 5.2 Ghz','Socket 1700','INT-741',35,43000.00),('Core i7 14700',20,28,'2.1 - 5.4 Ghz','Socket 1700','INT-742',65,30000.00),('Core i7 14700F',20,28,'2.1 - 5.4 Ghz','Socket 1700','INT-743',65,31200.00),('Core i7 14700K',20,28,'3.4 - 5.6 Ghz','Socket 1700','INT-744',125,39000.00),('Core i7 14700KF',20,28,'3.4 - 5.6 Ghz','Socket 1700','INT-745',125,45000.00),('Core i7 9700',8,8,'3.0 - 4.7 Ghz','Socket 1151','INT-790',65,16000.00),('Core i7 9700F',8,8,'3.0 - 4.7 Ghz','Socket 1151','INT-791',65,19000.00),('Core i7 9700K',8,8,'3.6 - 4.9 Ghz','Socket 1151','INT-792',95,20000.00),('Core i7 9700KF',8,8,'3.6 - 4.9 Ghz','Socket 1151','INT-793',95,24000.00),('Core i7 9800X',8,16,'3.8 - 4.5 Ghz','Socket 2066','INT-798',165,48000.00),('Core i9 10800F',10,20,'2.7 - 5.0 Ghz','Socket 1200','INT-900',65,25000.00),('Core i9 10900',10,20,'2.8 - 5.2 Ghz','Socket 1200','INT-901',65,35000.00),('Core i9 10900F',10,20,'2.8 - 5.2 Ghz','Socket 1200','INT-902',65,37500.00),('Core i9 10900K',10,20,'3.7 - 5.3 Ghz','Socket 1200','INT-903',125,45000.00),('Core i9 10900KF',10,20,'3.7 - 5.3 Ghz','Socket 1200','INT-904',125,48000.00),('Core i9 10900X',10,20,'3.7 - 4.7 Ghz','Socket 2066','INT-905',165,62000.00),('Core i9 11900T',8,16,'1.5 - 4.9 Ghz','SOcket 1200','INT-910',35,34000.00),('Core i9 11900F',8,16,'2.5 - 5.2 Ghz','Socket 1200','INT-911',65,37500.00),('Core i9 11900',8,16,'2.5 - 5.2 Ghz','Socket 1200','INT-912',65,40000.00),('Core i9 11900KF',8,16,'3.5 - 5.3 Ghz','Socket 1200','INT-913',125,45000.00),('Core i9 11900K',8,16,'3.5 - 5.3 Ghz','Socket 1200','INT-914',125,48000.00),('Core i9 12900T',16,24,'1.4 - 4.9 Ghz','Socket 1700','INT-920',35,42000.00),('Core i9 12900',16,24,'2.4 - 5.1 Ghz','Socket 1700','INT-921',65,46000.00),('Core i9 12900F',16,24,'2.4 - 5.1 Ghz','Socket 1700','INT-922',65,47500.00),('Core i9 12900K',16,24,'3.2 - 5.2 Ghz','Socket 1700','INT-923',125,55000.00),('Core i9 12900KF',16,24,'3.2 - 5.2 Ghz','Socket 1700','INT-924',125,57500.00),('Core i9 12900KS',16,24,'3.4 - 5.5 Ghz','Socket 1700','INT-925',150,60000.00),('Core i9 13900TE',24,32,'1.0 - 5.0 Ghz','Socket 1700','INT-930',35,42000.00),('Core i9 13900T',24,32,'1.1 - 5.3 Ghz','Socket 1700','INT-931',35,43500.00),('Core i9 13900E',24,32,'1.8 - 5.2 Ghz','Socket 1700','INT-932',65,41000.00),('Core i9 13900',24,32,'2.0 - 5.6 Ghz','Socket 1700','INT-933',65,51000.00),('Core i9 13900F',24,32,'2.0 - 5.6 GHz','Socket 1700','INT-934',65,49000.00),('Core i9 13900K',24,32,'3.0 - 5.8 Ghz','Socket 1700','INT-935',125,53000.00),('Core i9 13900KF',24,32,'3.0 - 5.8 Ghz','Socket 1700','INT-936',125,54500.00),('Core i9 13900KS',24,32,'3.2 - 6.0 Ghz','Socket 1700','INT-937',125,55000.00),('Core i9 14901TE',8,16,'2.3 - 5.5 Ghz','Socket 1700','INT-940',45,44500.00),('Core i9 14901E',8,16,'2.8 - 5.6 Ghz','Socket 1700','INT-941',65,44000.00),('Core i9 14901KE',8,16,'3.8 - 5.8 Ghz','Socket 1700','INT-942',125,60000.00),('Core i9 14900T',24,32,'1.1 - 5.5 Ghz','Socket 1700','INT-943',35,48000.00),('Core i9 14900',24,32,'2.0 - 5.8 Ghz','Socket 1700','INT-944',65,53000.00),('Core i9 14900F',24,32,'2.0 - 5.8 Ghz','Socket 1700','INT-945',65,55300.00),('Core i9 14900K',24,32,'3.2 - 6.0 Ghz','Socket 1700','INT-946',125,58000.00),('Core i9 14900KF',24,32,'3.2 - 6.0 Ghz','Socket 1700','INT-947',125,58500.00),('Core i9 14900KS',24,32,'3.2 - 6.2 Ghz','Socket 1700','INT-948',125,65000.00),('Core i9 9900',8,16,'3.1 - 5.0 Ghz','Socket 1151','INT-990',65,30000.00),('Core i9 9900K',8,16,'3.6 - 5.0 Ghz','Socket 1151','INT-991',95,35000.00),('Core i9 9900KS',8,16,'4.0 - 5.0 Ghz','Socket 1151','INT-992',127,42000.00);
/*!40000 ALTER TABLE `cpus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gpus`
--
DROP TABLE IF EXISTS `gpus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gpus` (
`Name` varchar(25) NOT NULL,
`Memory` varchar(20) NOT NULL,
`ClockSpeed` varchar(10) NOT NULL,
`Model` varchar(10) NOT NULL,
`Prefix` varchar(20) DEFAULT NULL,
`Wattage` int(11) DEFAULT NULL,
`Price` decimal(12,2) DEFAULT NULL,
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gpus`
--
LOCK TABLES `gpus` WRITE;
/*!40000 ALTER TABLE `gpus` DISABLE KEYS */;
INSERT INTO `gpus` VALUES ('Gtx 1050','3Gb Gddr5','1.75Ghz','GTX-100','GeForce',75,12000.00),('Gtx 1050 Ti','4Gb Gddr5','1.75Ghz','GTX-101','GeForce',75,15000.00),('Gtx 1060','6Gb Gddr5','2Ghz','GTX-102','GeForce',120,18000.00),('Gtx 1060','8Gb Gddr5x','1Ghz','GTX-103','GeForce',120,19000.00),('Gtx 1070','8Gb Gddr5','1Ghz','GTX-104','GeForce',150,10000.00),('Gtx 1070 Ti','8Gb Gddr5','2Ghz','GTX-105','GeForce',180,15000.00),('Gtx 1080','8Gb Gddr5x','1.25Ghz','GTX-106','GeForce',180,16500.00),('Gtx 1080 Ti','12Gb Gddr5x','1.37Ghz','GTX-107','GeForce',250,18000.00),('Gtx 1630','4Gb Gddr5','1.5Ghz','GTX-160','GeForce',75,16500.00),('Gtx 1650','4Gb Gddr5','2Ghz','GTX-161','GeForce',75,17500.00),('Gtx 1650 Super','4Gb Gddr6','1.5Ghz','GTX-162','GeForce',100,18700.00),('Gtx 1660','6Gb Gddr5','2Ghz','GTX-163','GeForce',120,20000.00),('Gtx 1660 Ti','6Gb Gddr6','1.5Ghz','GTX-164','GeForce',120,22000.00),('Gtx 1660 Super','6Gb Gddr6','1.75Ghz','GTX-165','GeForce',125,24000.00),('Rtx 2060','6Gb Gddr6','1.75Ghz','RTX-200','GeForce',160,28000.00),('Rtx 2060','12Gb Gddr6','1.75Ghz','RTX-201','GeForce',160,32000.00),('Rtx 2060 Super','8Gb Gddr6','1.75Ghz','RTX-202','GeForce',175,30000.00),('Rtx 2070','8Gb Gddr6','1.75Ghz','RTX-203','GeForce',175,30000.00),('Rtx 2070 Super','8Gb Gddr6','1.75Ghz','RTX-204','GeForce',215,39000.00),('Rtx 2080','8Gb Gddr6','1.75Ghz','RTX-205','GeForce',215,35000.00),('Rtx 2080 Super','8Gb Gddr6','1.9Ghz','RTX-206','GeForce',250,110000.00),('Rtx 2080 Ti','12Gb Gddr6','2Ghz','RTX-207','GeForce',250,62000.00),('Rtx 3050','4Gb Gddr6','1.5Ghz','RTX-300','GeForce',70,19000.00),('Rtx 3050','6Gb Gddr6','1.75Ghz','RTX-301','GeForce',70,17000.00),('Rtx 3050','8Gb Gddr6','1.75Ghz','RTX-302','GeForce',130,22000.00),('Rtx 3060','8Gb Gddr6','1.87Ghz','RTX-303','GeForce',170,24500.00),('Rtx 3060 Ti','8Gb Gddr6x','1.18Ghz','RTX-304','GeForce',200,28000.00),('Rtx 3060','12Gb Gddr6','1.32Ghz','RTX-305','GeForce',170,30000.00),('Rtx 3070','8Gb Gddr6','1.5Ghz','RTX-306','GeForce',220,45000.00),('Rtx 3070 Ti','8Gb Gddr6x','1.57Ghz','RTX-307','GeForce',290,48000.00),('Rtx 3070 Ti','16Gb Gddr6x','1.57Ghz','RTX-308','GeForce',290,52000.00),('Rtx 3080','10Gb Gddr6x','1.44Ghz','RTX-309','GeForce',320,48000.00),('Rtx 3080','12Gb Gddr6x','1.26Ghz','RTX-310','GeForce',320,50000.00),('Rtx 3080 Ti','20Gb Gddr6x','1.33Ghz','RTX-311','GeForce',320,57000.00),('Rtx 3090','24Gb Gddr6x','1.4Ghz','RTX-312','GeForce',350,68000.00),('Rtx 3090 Ti','24Gb Gddr6x','1.56Ghz','RTX-313','GeForce',350,90000.00),('Rtx 4050','6Gb Gddr6','2.25Ghz','RTX-400','GeForce',115,22000.00),('Rtx 4060','8Gb Gddr6','2.12Ghz','RTX-401','GeForce',115,26000.00),('Rtx 4060 Ti','8Gb Gddr6','2.25Ghz','RTX-402','GeForce',165,35000.00),('Rtx 4060 Ti','16Gb Gddr6','2.25Ghz','RTX-403','GeForce',165,38000.00),('Rtx 4070','12Gb Gddr6x','1.3Ghz','RTX-404','GeForce',200,44000.00),('Rtx 4070 Super','12Gb Gddr6x','1.3Ghz','RTX-405','GeForce',220,48000.00),('Rtx 4070 Ti','12Gb Gddr6x','2.31Ghz','RTX-406','GeForce',285,50000.00),('Rtx 4070 Ti Super','16Gb Gddr6x','2.34Ghz','RTX-407','GeForce',285,51000.00),('Rtx 4080','12Gb Gddr6x','2.31Ghz','RTX-408','GeForce',320,55000.00),('Rtx 4080','16Gb Gddr6x','2.2Ghz','RTX-409','GeForce',320,60000.00),('Rtx 4080 Super','16Gb Gddr6x','2.3Ghz','RTX-410','GeForce',320,65000.00),('Rtx 4080 Ti','16Gb Gddr6x','2.34Ghz','RTX-412','GeForce',400,68000.00),('Rtx 4090','24Gb Gddr6x','2.23Ghz','RTX-413','GeForce',450,90000.00),('Rtx 4090 Ti','24Gb Gddr6x','2.32Ghz','RTX-414','GeForce',600,120000.00),('RTX Titan','24Gb','1.77Ghz','RTX-999','GeForce',350,155000.00),('Rx 5300 Xt','4Gb Gddr5','1.75Ghz','RX-500','Radeon',100,12000.00),('Rx 5500','4Gb Gddr6','1.75Ghz','RX-501','Radeon',130,14500.00),('Rx 5500 Xt','4Gb Gddr6','1.75Ghz','RX-502','Radeon',130,16000.00),('Rx 5600','6Gb Gddr6','1.5Ghz','RX-503','Radeon',150,17000.00),('Rx 5700','8Gb Gddr6','1.75Ghz','RX-504','Radeon',180,18000.00),('Rx 5700 Xt','8Gb Gddr6','1.75Ghz','RX-505','Radeon',225,20000.00),('Rx 6500 Xt','4Gb Gddr6','2.2Ghz','RX-600','Radeon',107,18500.00),('Rx 6600','8Gb Gddr6','1.75Ghz','RX-601','Radeon',132,24000.00),('Rx 6600 Xt','8Gb Gddr6','2Ghz','RX-602','Radeon',160,29000.00),('Rx 6700','10Gb Gddr6','2Ghz','RX-603','Radeon',180,38000.00),('Rx 6700 Xt','12Gb Gddr6','2Ghz','RX-604','Radeon',220,42000.00),('Rx 6800','16Gb Gddr6','2Ghz','RX-605','Radeon',200,45000.00),('Rx 6800 Xt','16Gb Gddr6','2Ghz','RX-606','Radeon',300,52000.00),('Rx 6900 Xt','16Gb Gddr6','2Ghz','RX-607','Radeon',300,78000.00),('Rx 6950 Xt','16Gb Gddr6','2.25Ghz','RX-608','Radeon',305,85000.00),('Rx 7500 Xt','6Gb Gddr6','2.25Ghz','RX-700','Radeon',100,17500.00),('Rx 7900','8Gb Gddr6','2.25Ghz','RX-701','Radeon',165,26000.00),('Rx 7600 Xt','16Gb Gddr6','2.25Ghz','RX-702','Radeon',190,35000.00),('Rx 7700','12Gb Gddr6','2.25Ghz','RX-703','Radeon',180,40000.00),('Rx 7700 Xt','12Gb Gddr6','2.25Ghz','RX-704','Radeon',200,44000.00),('Rx 7800 Xt','16Gb Gddr6','2.4Ghz','RX-705','Radeon',300,57000.00),('Rx 7900 Xt','20Gb Gddr6','2.5Ghz','RX-706','Radeon',315,80000.00),('Rx 7950 Xt','20Gb Gddr6','2.5Ghz','RX-707','Radeon',300,82000.00),('Rx 7950 Xtx','24Gb Gddr6','2.5Ghz','RX-708','Radeon',355,85000.00),('Rx 7990 Xtx','24Gb Gddr6','3Ghz','RX-709','Radeon',405,95000.00);
/*!40000 ALTER TABLE `gpus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `memory`
--
DROP TABLE IF EXISTS `memory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `memory` (
`Name` varchar(50) DEFAULT NULL,
`Type` varchar(20) DEFAULT NULL,
`Speed` varchar(20) DEFAULT NULL,
`Capacity` varchar(20) DEFAULT NULL,
`Model` varchar(20) NOT NULL DEFAULT '',
`Price` decimal(12,2) DEFAULT NULL,
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `memory`
--
LOCK TABLES `memory` WRITE;
/*!40000 ALTER TABLE `memory` DISABLE KEYS */;
INSERT INTO `memory` VALUES ('Corsair Vengeance LPX','ddr4','3200Mhz','8Gb','MEM-430',1900.00),('Corsair Vengeance LPX','ddr4','3200Mhz','16Gb','MEM-431',3200.00),('Adata XPG Gammix','ddr4','3200Mhz','8Gb','MEM-432',1500.00),('Adata XPG Gammix','ddr4','3200Mhz','16Gb','MEM-433',2500.00),('G.Skill Ripjaws V','ddr4','3200Mhz','8Gb','MEM-434',1500.00),('G.Skill Ripjaws V','ddr4','3200Mhz','16Gb','MEM-435',1500.00),('Adata XPG','ddr5','4800Mhz','8Gb','MEM-540',3500.00),('Corsair Vengeance','ddr5','5200Mhz','16Gb','MEM-550',4300.00),('Corsair Vengeance','ddr5','5200Mhz','16Gb','MEM-551',8500.00),('Adata XPG Lancer RGB','ddr5','5200Mhz','16Gb','MEM-552',4200.00),('G.Skill Ripjaws S5','ddr5','5200Mhz','16Gb','MEM-553',4000.00),('Adata XPG Lancer RGB','ddr5','6000Mhz','16Gb','MEM-560',5500.00),('Adata XPG Lancer RGB','ddr5','6000Mhz','32Gb','MEM-561',9000.00),('G.Skill Ripjaws S5','ddr5','6000Mhz','16Gb','MEM-562',4500.00),('G.Skill Trident Z5','ddr5','6000Mhz','16Gb','MEM-563',5000.00),('G.Skill Trident Z5 RGB','ddr5','6000Mhz','32Gb','MEM-564',10000.00),('Acer Predator Pallas II','ddr5','6000Mhz','16Gb','MEM-565',5000.00),('Acer Predator Vesta II','ddr5','6000Mhz','16Gb','MEM-566',6200.00);
/*!40000 ALTER TABLE `memory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `motherboard`
--
DROP TABLE IF EXISTS `motherboard`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `motherboard` (
`Name` varchar(50) DEFAULT NULL,
`Socket` varchar(20) DEFAULT NULL,
`FormFactor` varchar(20) DEFAULT NULL,
`MemType` varchar(20) DEFAULT NULL,
`Model` varchar(20) NOT NULL DEFAULT '',
`Price` decimal(12,2) DEFAULT NULL,
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `motherboard`
--
LOCK TABLES `motherboard` WRITE;
/*!40000 ALTER TABLE `motherboard` DISABLE KEYS */;
INSERT INTO `motherboard` VALUES ('Gigabyte GA H110M','Socket 1151','ATX','ddr4','MB-110',4000.00),('Asus Z170 Pro','Socket 1151','ATX','ddr4','MB-190',6000.00),('Gigabyte Z390 Gaming X','Socket 1151','ATX','ddr4','MB-192',11000.00),('MSI X299 Raider','Socket 2066','ATX','ddr4','MB-290',15000.00),('Asus Prime X299 Delux','Socket 2066','ATX','ddr4','MB-291',28000.00),('Asus Tuf X299 Mark2','Socket 2066','ATX','ddr4','MB-292',32000.00),('Gigabyte B450M WiFi','AM4','mATX','ddr4','MB-450',7500.00),('Gigabyte Z490 Aorus Pro AX','Socket 1200','ATX','ddr4','MB-490',30000.00),('Asus ROG Strix Z490','Socket 1200','ATX','ddr4','MB-491',23000.00),('Gigabyte H510','Socket 1200','mATX','ddr4','MB-510',7000.00),('MSI B550M WiFi','AM4','mATX','ddr4','MB-550',9500.00),('MSI Mag B550M Mortar Max WiFi','AM4','mATX','ddr4','MB-551',15000.00),('Asus Tuf B550M WiFi','AM4','mATX','ddr4','MB-552',17000.00),('Asus Prime H610-E','Socket 1700','mATX','ddr4','MB-610',7000.00),('MSI Pro H610M WiFi','Socket 1700','mATX','ddr5','MB-611',8500.00),('MSI Pro B650M','AM5','mATX','ddr5','MB-650',11000.00),('Asus Prime B650M','AM5','mATX','ddr5','MB-651',13000.00),('MSI B650M Gaming WiFi','AM5','mATX','ddr5','MB-652',16000.00),('MSI Pro B650P WiFi','AM5','mATX','ddr5','MB-653',20000.00),('Asus ROG Strix B650','AM5','ATX','ddr5','MB-654',29000.00),('Asus Tuf Gaming X670E+','AM5','ATX','ddr5','MB-670',32000.00),('Asus ROG Crosshair X670E','AM5','ATX','ddr5','MB-671',64000.00),('Asus ROG Strix X670E-E','AM5','ATX','ddr5','MB-672',50000.00),('Gigabyte B760M','Socket 1700','mATX','ddr5','MB-760',15000.00),('Gigabyte B760M WiFi','Socket 1700','mATX','ddr5','MB-761',17000.00),('Asus Prime B760M WiFi','Socket 1700','mATX','ddr5','MB-762',15500.00),('Asus Prime B760M-AYW WiFi','Socket 1700','mATX','ddr5','MB-763',12000.00),('Asus ROG Strix B760 WiFi','Socket 1700','ATX','ddr5','MB-764',26000.00),('MSI Pro B760M','Socket 1700','mATX','ddr4','MB-765',8500.00),('MSI Pro B760MP','Socket 1700','ATX','ddr4','MB-766',11500.00),('MSI Pro B760M Bomber WiFi','Socket 1700','ATX','ddr5','MB-767',11900.00),('MSI Mag B760M Mortar WiFi','Socket 1700','mATX','ddr5','MB-768',18000.00),('Gigabyte Z790 UD','Socket 1700','mATX','ddr5','MB-790',21000.00),('Asus Prime Z790P','Socket 1700','ATX','ddr5','MB-791',22000.00),('Asus ROG Strix Z790 WiFi','Socket 1700','ATX','ddr5','MB-792',44000.00),('Asus ROG Strix Z790H WiFi','Socket 1700','ATX','ddr5','MB-793',32000.00),('MSI Z790 Gaming Plus WiFi','Socket 1700','ATX','ddr5','MB-794',25000.00),('MSI Mag Z790 Tomahawk WiFi','Socket 1700','ATX','ddr5','MB-795',32000.00),('MSI Mpg Z790 Edge Ti Max WiFi','Socket 1700','ATX','ddr5','MB-796',40000.00),('MSI Mpg Z790 Carbon Max WiFi II','Socket 1700','ATX','ddr5','MB-797',55000.00),('MSI Mag X870','AM5','ATX','ddr5','MB-870',36000.00);
/*!40000 ALTER TABLE `motherboard` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `psu`
--
DROP TABLE IF EXISTS `psu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `psu` (
`Name` varchar(50) DEFAULT NULL,
`Wattage` varchar(20) DEFAULT NULL,
`Type` varchar(20) DEFAULT NULL,
`Model` varchar(20) DEFAULT NULL,
`Certification` varchar(20) DEFAULT NULL,
`Price` decimal(12,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `psu`
--
LOCK TABLES `psu` WRITE;
/*!40000 ALTER TABLE `psu` DISABLE KEYS */;
INSERT INTO `psu` VALUES ('Coller Master MWE V2','450W','Non-Modular','PS-450','80 + B',3200.00),('Cooler Master MWE V3','550W','Non-Modular','PS-550','80 + B',4000.00),('Crosair CX750','750W','Non-Modular','PS-750','80 + B',6200.00),('Ant Esports RX550','550W','Non-Modular','PS-551','80 + B',2900.00),('Ant Esports RX650','650W','Non-Modular','PS-650','80 + B',3500.00),('Ant Esports FP','650W','Non-Modular','PS-651','80 + B',3800.00),('Ant Esports FG','650W','Non-Modular','PS-652','80 + G',4500.00),('Ant Esports FP','750W','Non-Modular','PS-751','80 + B',4600.00),('Ant Esports FG','750W','Non-Modular','PS-752','80 + G',5200.00),('Ant Esports FG','850W','Non-Modular','PS-850','80 + G',6500.00),('Cooler Master MWE V3','650W','Non-Modular','PS-653','80 + B',5500.00),('Cooler Master MWE V3','750W','Non-Modular','PS-753','80 + B',6500.00),('Cooler Master MWE V2','850W','Non-Modular','PS-851','80 + G',10000.00),('Cooler Master MWE V2','1050W','Non-Modular','PS-100','80 + B',16500.00),('Cooler Master MWE V2','1250W','Non-Modular','PS-120','80 + B',20000.00),('DeepCool PK450D','450W','Non-Modular','PS-451','80 + B',3200.00),('MSI Mag A550BN','550W','Non-Modular','PS-552','80 + B',3800.00),('DeepCool PL500D','550W','Non-Modular','PS-553','80 + B',3800.00),('Corsair CX550','550W','Non-Modular','PS-554','80 + B',4000.00),('DeepCool PF650','650W','Non-Modular','PS-654','80 + St',3900.00),('DeepCool PL650','650W','Non-Modular','PS-655','80 + B',4700.00),('MSI Mag A650BN','650W','Non-Modular','PS-656','80 + B',4700.00),('Gigabyte P650','650W','Non-Modular','PS-657','80 + S',4700.00),('Gigabyte P650G','650W','Non-Modular','PS-658','80 + G',5000.00),('Antec G650','650W','Semi-Modular','PS-659','80 + G',5300.00),('Antec CSK','750W','Non-Modular','PS-754','80 + B',5500.00),('DeepCool PL','750W','Non-Modular','PS-755','80 + B',5500.00),('Gigabyte UD','750W','Fully-Modular','PS-756','80 + G',7500.00),('MSI Mag A750GL','750W','Fully-Modular','PS-757','80 + G',7600.00),('Corsair','850W','Fully-Modular','PS-852','80 + G',11000.00),('MSI Mag A850GL','850W','Fully-Modular','PS-853','80 + G',8800.00),('Gigabyte UD','850W','Fully-Modular','PS-854','80 + G',9000.00),('Super Flower Leadex','850W','Fully-Modular','PS-855','80 + P',9100.00);
/*!40000 ALTER TABLE `psu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storages`
--
DROP TABLE IF EXISTS `storages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storages` (
`Name` varchar(50) DEFAULT NULL,
`Capacity` varchar(20) DEFAULT NULL,
`Type` varchar(20) DEFAULT NULL,
`Generation` varchar(20) DEFAULT NULL,
`Model` varchar(20) NOT NULL DEFAULT '',
`Price` decimal(12,2) DEFAULT NULL,
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storages`
--
LOCK TABLES `storages` WRITE;
/*!40000 ALTER TABLE `storages` DISABLE KEYS */;
INSERT INTO `storages` VALUES ('Western Digital Blue 7200RPM','1024GB','HDD','Gen 2','H-100',4500.00),('Western Digital Blue 7200RPM','2048GB','HDD','Gen 2','H-200',5800.00),('Western Digital Blue 5400RPM','4096GB','HDD','Gen 2','H-400',9800.00),('Kingston KC3000','500GB','NVMe M.2','Gen 4','M-350',5000.00),('Kingston KC3000','1024GB','NVMe M.2','Gen 4','M-351',8000.00),('Kingston Fury Renegade','1024GB','NVMe M.2','Gen 4','M-352',9200.00),('Kingston Fury Renegade','2048GB','NVMe M.2','Gen 4','M-353',15000.00),('Kingston Fury Renegade','4096GB','NVMe M.2','Gen 4','M-354',32000.00),('Crucial P3 Plus','500GB','NVMe M.2','Gen 3','M-500',3000.00),('Crucial P3 Plus','1024GB','NVMe M.2','Gen 4','M-501',5500.00),('Adata XPG Gammix S50','1024GB','NVMe M.2','Gen 4','M-700',5000.00),('Adata XPG Gammix S60','500GB','NVMe M.2','Gen 4','M-701',3800.00),('Acer Predator GM7000','1024GB','NVMe M.2','Gen 4','M-709',8200.00),('Samsung 990 Evo','1024GB','NVMe M.2','Gen 4','M-990',9000.00),('Samsung 990 Pro','1024GB','NVMe M.2','Gen 4','M-991',11000.00),('Samsung 990 Pro','2048GB','NVMe M.2','Gen 4','M-992',18000.00),('EVM','128GB','Sata SSD','Gen 3','S-120',1100.00),('Crucial BX500','240GB','Sata SSD','Gen 3','S-502',1500.00),('Crucial BX500','500GB','Sata SSD','Gen 3','S-503',2500.00),('Crucial BX500','1024GB','Sata SSD','Gen 3','S-504',5000.00);
/*!40000 ALTER TABLE `storages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`Name` varchar(30) DEFAULT NULL,
`Username` varchar(30) DEFAULT NULL,
`Password` varchar(30) DEFAULT NULL,
`Email` varchar(30) DEFAULT NULL,
`SignedUpOn` date DEFAULT NULL,
`SignedUpAt` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users_pc`
--
DROP TABLE IF EXISTS `users_pc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_pc` (
`Username` varchar(30) DEFAULT NULL,
`CPU` varchar(50) DEFAULT NULL,
`GPU` varchar(50) DEFAULT NULL,
`MotherBoard` varchar(50) DEFAULT NULL,
`MemModule` varchar(50) DEFAULT NULL,
`NumberOfModule` int(11) DEFAULT NULL,
`StorageCapcity` varchar(30) DEFAULT NULL,
`PSU` varchar(50) DEFAULT NULL,
`TotalPrice` decimal(12,2) DEFAULT NULL,
`Date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_pc`
--
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-01-24 7:43:19