forked from klinquist/GGCAutocross
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathggc_autocross.sql
executable file
·297 lines (267 loc) · 117 KB
/
ggc_autocross.sql
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
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `autox_cars`
-- ----------------------------
DROP TABLE IF EXISTS `autox_cars`;
CREATE TABLE `autox_cars` (
`car_id` int(11) NOT NULL DEFAULT '0',
`car` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`year_start` smallint(5) unsigned NOT NULL DEFAULT '0',
`year_end` smallint(5) unsigned NOT NULL DEFAULT '0',
`chassis` varchar(25) COLLATE latin1_general_ci DEFAULT NULL,
`points` smallint(5) unsigned NOT NULL DEFAULT '0',
`rear_wheel_diameter` decimal(3,1) DEFAULT NULL,
`rear_wheel_width` decimal(3,1) DEFAULT NULL,
`rear_tire_width` smallint(5) unsigned DEFAULT NULL,
`rear_tire_profile` smallint(5) unsigned DEFAULT NULL,
`front_wheel_diameter` decimal(3,1) DEFAULT NULL,
`front_wheel_width` decimal(3,1) DEFAULT NULL,
`LSD_standard` char(1) COLLATE latin1_general_ci DEFAULT NULL,
`weight` smallint(5) unsigned DEFAULT NULL,
`weight_pct` decimal(3,2) DEFAULT NULL,
`engine_type` varchar(1) COLLATE latin1_general_ci DEFAULT NULL,
`engine_code` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
`engine_displacement` smallint(5) unsigned DEFAULT NULL,
`engine_no_cylinders` smallint(5) unsigned DEFAULT NULL,
`BHP` smallint(5) unsigned DEFAULT NULL,
`BHP_at_RPM` smallint(5) unsigned DEFAULT NULL,
`torque` smallint(5) unsigned DEFAULT NULL,
`torque_at_RPM` smallint(5) unsigned DEFAULT NULL,
`wheel_base` decimal(4,1) DEFAULT NULL,
`final_drive` decimal(3,2) DEFAULT NULL,
`lsd_points` smallint(2) unsigned DEFAULT NULL,
`engine_level` smallint(2) unsigned DEFAULT NULL,
`suspension_code` varchar(1) COLLATE latin1_general_ci DEFAULT NULL,
`2nd_gear_ratio` decimal(3,2) DEFAULT NULL,
`drive_type` varchar(3) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`car_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of `autox_cars`
-- ----------------------------
BEGIN;
INSERT INTO `autox_cars` VALUES ('1', '1600-2', '1966', '1971', 'Type 114', '30', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2072', '0.55', 'G', 'M10', '1573', '4', '85', '5700', '91', '3000', '98.0', '4.11', '0', '0', 'B', '2.06', 'RWD'), ('2', '2002 Alpina', '1967', '1967', 'Type 114', '53', '13.0', '5.5', '165', '80', '13.0', '5.5', 'Y', '2135', '0.52', 'G', 'M10', '1990', '4', '160', '6900', '135', '5250', '98.0', '3.89', '7', '7', 'B', '2.15', 'RWD'), ('3', '1600TI', '1967', '1968', 'Type 114', '31', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2116', '0.55', 'G', 'M10', '1573', '4', '105', '6000', '97', '4500', '98.0', '3.90', '2', '2', 'B', '2.06', 'RWD'), ('4', '2002', '1968', '1973', 'Type 114', '31', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2210', '0.55', 'G', 'M10', '1990', '4', '106', '5500', '116', '3500', '98.0', '3.64', '3', '3', 'B', '2.05', 'RWD'), ('5', '1602', '1971', '1975', 'Type 114', '28', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2161', '0.55', 'G', 'M10', '1573', '4', '85', '5700', '91', '3000', '98.0', '4.11', '0', '0', 'B', '2.06', 'RWD'), ('6', '1500 4 Dr', '1962', '1964', 'Type 118', '22', '14.0', '4.0', '155', '80', '14.0', '4.0', 'N', '2370', '0.53', 'G', 'M10', '1499', '4', '90', '5900', '87', '3200', '100.0', '4.38', '0', '0', 'B', '2.17', 'RWD'), ('7', '1800 4 Dr', '1963', '1971', 'Type 118', '23', '14.0', '4.5', '155', '80', '14.0', '4.5', 'N', '2403', '0.55', 'G', 'M10', '1773', '4', '90', '5250', '106', '3000', '100.0', '4.11', '0', '0', 'B', '2.07', 'RWD'), ('8', '1600 4 Dr', '1964', '1966', 'Type 118', '20', '13.0', '4.0', '165', '80', '13.0', '4.0', 'N', '2359', '0.55', 'G', 'M10', '1573', '4', '83', '5800', '91', '3000', '100.0', '4.11', '0', '0', 'B', '2.07', 'RWD'), ('9', '1800TI 4 Dr', '1964', '1966', 'Type 118', '32', '14.0', '5.0', '155', '80', '14.0', '5.0', 'N', '2400', '0.55', 'G', 'M10', '1773', '4', '124', '5800', '109', '4000', '100.0', '4.11', '4', '4', 'B', '2.07', 'RWD'), ('10', '2000cA', '1965', '1967', 'Type 121', '27', '14.0', '5.0', '175', '80', '14.0', '5.0', 'N', '2646', '0.53', 'G', 'M10', '1990', '4', '113', '5800', '116', '3600', '100.0', '3.90', '1', '1', 'B', '2.05', 'RWD'), ('11', '2000cs', '1965', '1970', 'Type 121', '28', '14.0', '5.0', '175', '80', '14.0', '5.0', 'N', '2646', '0.53', 'G', 'M10', '1990', '4', '121', '5800', '123', '3600', '100.0', '3.90', '2', '2', 'B', '2.05', 'RWD'), ('12', '2000TI 4 Dr', '1966', '1970', 'Type 121', '34', '14.0', '5.5', '175', '80', '14.0', '5.5', 'N', '2535', '0.53', 'G', 'M10', '1990', '4', '135', '5500', '123', '3600', '100.0', '3.90', '4', '4', 'B', '2.05', 'RWD'), ('13', '2000tii', '1969', '1972', 'Type 121', '31', '14.0', '5.5', '175', '80', '14.0', '5.5', 'N', '2579', '0.53', 'G', 'M10', '1990', '4', '130', '5800', '130', '4500', '100.0', '3.90', '1', '1', 'B', '2.05', 'RWD'), ('14', '2800', '1968', '1971', 'E3', '29', '14.0', '6.0', '175', '80', '14.0', '6.0', 'N', '2998', '0.55', 'G', 'M20', '2788', '6', '170', '6000', '174', '3700', '106.0', '3.45', '5', '5', 'B', '2.08', 'RWD'), ('15', '2500', '1968', '1976', 'E3', '30', '14.0', '6.0', '175', '80', '14.0', '6.0', 'N', '3005', '0.55', 'G', 'M20', '2494', '6', '170', '6000', '155', '3700', '106.0', '3.64', '6', '6', 'B', '2.42', 'RWD'), ('16', 'Bavaria', '1971', '1972', 'E3', '29', '14.0', '6.0', '175', '80', '14.0', '6.0', 'N', '2954', '0.56', 'G', 'M20', '2788', '6', '170', '6000', '174', '3700', '106.0', '3.45', '5', '5', 'B', '2.08', 'RWD'), ('17', 'Bavaria', '1973', '1974', 'E3', '26', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3235', '0.56', 'G', 'M20', '2985', '6', '180', '5800', '185', '3500', '106.0', '3.64', '6', '6', 'B', '2.08', 'RWD'), ('18', '3.0s', '1973', '1976', 'E3', '22', '14.0', '6.0', '175', '80', '14.0', '6.0', 'N', '3320', '0.57', 'G', 'M20', '2985', '6', '170', '5800', '185', '3500', '106.0', '3.45', '4', '4', 'B', '2.08', 'RWD'), ('19', '3.0si', '1975', '1976', 'E3', '17', '14.0', '6.0', '175', '80', '14.0', '6.0', 'N', '3420', '0.57', 'G', 'M20', '2985', '6', '176', '5500', '185', '4500', '106.0', '3.45', '2', '2', 'B', '2.08', 'RWD'), ('20', 'Bavaria Euro 2.8L', '1976', '1976', 'E3', '26', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3420', '0.00', 'G', 'M20', '2788', '6', '170', '5800', '174', '3500', '110.0', '3.45', '2', '2', 'B', '2.08', 'RWD'), ('21', '2002tii', '1971', '1973', 'E6', '33', '13.0', '5.0', '165', '80', '13.0', '5.0', 'N', '2310', '0.54', 'G', 'M10', '1990', '4', '130', '5500', '130', '4500', '98.0', '3.64', '3', '3', 'B', '2.05', 'RWD'), ('22', '2002 Touring', '1971', '1974', 'E6', '32', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2271', '0.52', 'G', 'M10', '1990', '4', '106', '5500', '116', '3500', '98.0', '3.64', '2', '2', 'B', '2.05', 'RWD'), ('23', '2002tii', '1974', '1974', 'E6', '31', '13.0', '5.0', '165', '80', '13.0', '5.0', 'N', '2420', '0.54', 'G', 'M10', '1990', '4', '125', '5500', '127', '4000', '98.0', '3.64', '3', '3', 'B', '2.05', 'RWD'), ('24', '2002', '1974', '1976', 'E6', '28', '13.0', '4.5', '165', '80', '13.0', '4.5', 'N', '2370', '0.55', 'G', 'M10', '1990', '4', '106', '5500', '116', '3500', '98.0', '3.64', '2', '2', 'B', '2.05', 'RWD'), ('25', '2800cs', '1968', '1971', 'E9', '31', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3025', '0.53', 'G', 'M20', '2788', '6', '170', '6000', '174', '3700', '103.0', '3.45', '4', '4', 'B', '2.08', 'RWD'), ('26', '3.0cs', '1971', '1975', 'E9', '26', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3175', '0.57', 'G', 'M20', '2985', '6', '180', '5800', '185', '3500', '103.0', '3.64', '7', '7', 'B', '2.08', 'RWD'), ('27', '3.0csi', '1971', '1975', 'E9', '24', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3086', '0.57', 'G', 'M20', '2985', '6', '176', '5500', '185', '4500', '103.0', '3.64', '3', '3', 'B', '2.08', 'RWD'), ('28', '3.0csL', '1973', '1975', 'E9', '48', '14.0', '7.0', '195', '70', '14.0', '7.0', 'Y', '2800', '0.57', 'G', 'M20', '3153', '6', '206', '5600', '0', '0', '103.0', '3.25', '8', '8', 'B', '2.20', 'RWD'), ('29', '2002 Turbo', '1973', '1974', 'E10', '46', '13.0', '6.0', '185', '70', '13.0', '6.0', 'N', '2290', '0.52', 'G', 'M10', '1990', '4', '170', '5800', '179', '4000', '98.0', '3.36', '7', '7', 'B', '1.86', 'RWD'), ('30', '530i', '1975', '1976', 'E12/6', '22', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3300', '0.56', 'G', 'M30', '2985', '6', '176', '5500', '185', '4500', '104.0', '3.64', '3', '3', 'B', '2.20', 'RWD'), ('31', '530i', '1977', '1978', 'E12/6', '21', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3300', '0.56', 'G', 'M30', '2985', '6', '176', '5500', '185', '4500', '104.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('32', '528i', '1979', '1979', 'E12/6', '20', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3320', '0.56', 'G', 'M30', '2788', '6', '169', '5500', '170', '4500', '104.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('33', '528i', '1980', '1981', 'E12/6', '22', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3180', '0.57', 'G', 'M30', '2788', '6', '169', '5500', '170', '4500', '104.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('34', '528e', '1982', '1988', 'E12/6', '22', '14.0', '6.5', '195', '70', '14.0', '6.5', 'N', '3100', '0.55', 'G', 'M30', '2693', '6', '121', '4250', '170', '3250', '103.4', '2.93', '0', '0', 'B', '2.20', 'RWD'), ('35', '316 Euro', '1975', '1983', 'E21', '28', '13.0', '5.0', '165', '80', '13.0', '5.0', 'N', '2293', '0.55', 'G', 'M10', '1573', '4', '90', '6000', '102', '3800', '101.0', '3.91', '0', '0', 'B', '2.04', 'RWD'), ('36', '320i', '1977', '1977', 'E21', '30', '13.0', '5.5', '185', '70', '13.0', '5.5', 'N', '2601', '0.52', 'G', 'M10', '1990', '4', '110', '5800', '112', '3750', '101.0', '3.64', '0', '0', 'B', '2.02', 'RWD'), ('37', '320i', '1978', '1979', 'E21', '28', '13.0', '5.5', '185', '70', '13.0', '5.5', 'N', '2601', '0.55', 'G', 'M10', '1990', '4', '110', '5800', '112', '3750', '101.0', '3.64', '0', '0', 'B', '2.02', 'RWD'), ('38', '320is', '1978', '1979', 'E21', '29', '13.0', '5.5', '185', '70', '13.0', '5.5', 'Y', '2601', '0.54', 'G', 'M10', '1990', '4', '110', '5800', '112', '3750', '101.0', '3.64', '0', '0', 'S', '2.02', 'RWD'), ('39', '320i', '1980', '1983', 'E21', '29', '13.0', '5.5', '185', '70', '13.0', '5.5', 'N', '2396', '0.54', 'G', 'M10', '1766', '4', '101', '5800', '100', '4500', '101.0', '3.91', '0', '0', 'B', '2.02', 'RWD'), ('40', '320is', '1980', '1983', 'E21', '29', '13.0', '5.5', '185', '70', '13.0', '5.5', 'Y', '2396', '0.54', 'G', 'M10', '1766', '4', '101', '5800', '100', '4500', '101.0', '3.91', '0', '0', 'S', '2.02', 'RWD'), ('41', '320/6 Euro', '1977', '1983', 'E21/5', '33', '13.0', '5.5', '185', '70', '13.0', '5.5', 'N', '2601', '0.50', 'G', 'M20', '1990', '6', '122', '6000', '118', '4000', '101.0', '3.64', '1', '1', 'B', '2.04', 'RWD'), ('42', '323i Euro', '1977', '1983', 'E21/5', '38', '13.0', '5.5', '185', '70', '13.0', '5.5', 'N', '2503', '0.50', 'G', 'M20', '2315', '6', '143', '6000', '140', '4300', '101.0', '3.45', '4', '4', 'B', '2.33', 'RWD'), ('43', '733i', '1978', '1979', 'E23', '24', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3530', '0.52', 'G', 'M30', '3210', '6', '177', '5500', '196', '4000', '110.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('44', '735i Euro', '1978', '1987', 'E23', '32', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3307', '0.52', 'G', 'M30', '3430', '6', '220', '5700', '228', '4000', '110.0', '3.25', '6', '6', 'B', '2.20', 'RWD'), ('45', '733i', '1980', '1981', 'E23', '21', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3610', '0.52', 'G', 'M30', '3210', '6', '174', '5200', '188', '4200', '110.0', '3.45', '1', '1', 'B', '2.20', 'RWD'), ('46', '733i', '1982', '1983', 'E23', '24', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3610', '0.52', 'G', 'M30', '3210', '6', '181', '6000', '195', '4000', '110.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('47', '733i', '1984', '1984', 'E23', '24', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3610', '0.52', 'G', 'M30', '3210', '6', '181', '6000', '195', '4000', '110.0', '3.45', '2', '2', 'B', '2.20', 'RWD'), ('48', '735i', '1985', '1987', 'E23', '26', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3440', '0.52', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '110.0', '3.45', '3', '3', 'B', '2.20', 'RWD'), ('49', 'L7', '1986', '1987', 'E23', '26', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3440', '0.52', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '110.0', '3.45', '3', '3', 'B', '2.20', 'RWD'), ('50', '630csi', '1977', '1977', 'E24', '19', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '3420', '0.56', 'G', 'M30', '2985', '6', '176', '5500', '185', '4500', '103.4', '3.45', '2', '2', 'S', '2.20', 'RWD'), ('51', '633csi', '1978', '1982', 'E24', '22', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3500', '0.55', 'G', 'M30', '3210', '6', '177', '5500', '196', '4000', '103.4', '3.25', '2', '2', 'S', '2.20', 'RWD'), ('52', '635csi Euro', '1978', '1984', 'E24', '31', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3153', '0.55', 'G', 'M30', '3430', '6', '218', '5200', '228', '4000', '103.4', '3.25', '7', '7', 'S', '2.40', 'RWD'), ('53', '633csi', '1983', '1984', 'E24', '27', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3280', '0.55', 'G', 'M30', '3210', '6', '181', '6000', '195', '4000', '103.4', '3.25', '3', '3', 'S', '2.20', 'RWD'), ('54', 'M6 Euro', '1983', '1989', 'E24', '45', '16.0', '7.5', '245', '45', '16.0', '7.5', 'Y', '3308', '0.55', 'G', 'M88', '3453', '6', '286', '6500', '250', '4500', '103.5', '3.73', '8', '8', 'M', '2.08', 'RWD'), ('55', '635csi', '1985', '1986', 'E24', '25', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3375', '0.55', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '103.5', '3.45', '4', '4', 'S', '2.20', 'RWD'), ('56', 'L6', '1987', '1987', 'E24', '26', '15.0', '6.5', '225', '55', '15.0', '6.5', 'Y', '3490', '0.55', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '103.5', '3.45', '3', '3', 'B', '2.20', 'RWD'), ('57', 'M6', '1987', '1989', 'E24', '38', '16.0', '7.5', '245', '45', '16.0', '7.5', 'Y', '3570', '0.55', 'G', 'M88', '3453', '6', '256', '6500', '243', '4500', '103.5', '3.91', '7', '7', 'M', '2.08', 'RWD'), ('58', '635csi', '1988', '1989', 'E24', '25', '15.0', '6.5', '225', '55', '15.0', '6.5', 'N', '3550', '0.55', 'G', 'M30', '3430', '6', '208', '5700', '225', '4000', '103.5', '3.64', '6', '6', 'S', '2.20', 'RWD'), ('59', '533i', '1982', '1982', 'E28', '31', '14.0', '6.5', '205', '70', '14.0', '6.5', 'N', '3120', '0.53', 'G', 'M30', '3210', '6', '181', '6000', '195', '4000', '103.4', '3.25', '4', '4', 'B', '2.20', 'RWD'), ('60', '533i', '1983', '1984', 'E28', '31', '15.0', '6.5', '205', '60', '15.0', '6.5', 'N', '3120', '0.53', 'G', 'M30', '3210', '6', '181', '6000', '195', '4000', '103.4', '3.25', '4', '4', 'B', '2.20', 'RWD'), ('61', '524td', '1985', '1986', 'E28', '26', '14.0', '6.0', '195', '70', '14.0', '6.0', 'N', '2900', '0.55', 'D', 'M21', '2443', '6', '115', '4800', '155', '2400', '103.4', '3.15', '0', '0', 'B', '2.33', 'RWD'), ('62', '535i', '1985', '1988', 'E28', '28', '15.0', '6.5', '205', '60', '15.0', '6.5', 'N', '3270', '0.53', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '103.4', '3.25', '3', '3', 'B', '2.20', 'RWD'), ('63', 'M535i Euro', '1986', '1986', 'E28', '44', '15.0', '6.5', '225', '55', '15.0', '6.5', 'Y', '3058', '0.00', 'G', 'M30', '3430', '6', '218', '5200', '229', '4000', '103.4', '3.73', '7', '7', 'S', '2.08', 'RWD'), ('64', '535is', '1987', '1988', 'E28', '31', '15.0', '6.5', '205', '60', '15.0', '6.5', 'Y', '3270', '0.53', 'G', 'M30', '3430', '6', '182', '5400', '214', '4000', '103.4', '3.25', '3', '3', 'S', '2.20', 'RWD'), ('65', 'M5', '1987', '1988', 'E28', '45', '16.0', '7.5', '225', '50', '16.0', '7.5', 'Y', '3420', '0.50', 'G', 'M88', '3453', '6', '256', '6500', '243', '4500', '103.4', '3.91', '7', '7', 'M', '2.08', 'RWD'), ('66', 'M5 Euro', '1987', '1988', 'E28', '48', '15.0', '6.5', '225', '55', '15.0', '6.5', 'Y', '3155', '0.00', 'G', 'M88', '3453', '6', '286', '6500', '251', '4500', '103.4', '3.73', '8', '8', 'M', '2.08', 'RWD'), ('67', 'Alpina B11-3.5', '1987', '1990', 'E28', '48', '17.0', '10.0', '255', '45', '17.0', '10.0', 'Y', '3568', '0.00', 'G', 'M30', '3430', '6', '250', '5700', '243', '4500', '110.0', '3.73', '5', '5', 'S', '2.20', 'RWD'), ('68', 'H & B 327s', '1984', '1984', 'E30', '52', '16.0', '7.0', '205', '50', '16.0', '7.0', 'Y', '2660', '0.00', 'G', 'M20', '2693', '6', '180', '6000', '175', '4000', '101.0', '3.45', '6', '6', 'S', '2.20', 'RWD'), ('69', '318i', '1984', '1985', 'E30', '33', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2361', '0.50', 'G', 'M10', '1767', '4', '102', '5800', '103', '4500', '101.0', '3.64', '0', '0', 'B', '2.02', 'RWD'), ('70', '325/325e', '1984', '1985', 'E30', '28', '14.0', '6.0', '195', '60', '14.0', '6.0', 'N', '2770', '0.54', 'G', 'M20', '2693', '6', '121', '4250', '170', '3250', '101.0', '2.79', '0', '0', 'B', '2.20', 'RWD'), ('71', '323i Euro', '1984', '1986', 'E30', '41', '14.0', '6.0', '195', '60', '14.0', '5.5', 'N', '2403', '0.00', 'G', 'M20', '2315', '6', '139', '6000', '151', '4000', '101.0', '3.45', '4', '4', 'B', '2.33', 'RWD'), ('72', 'Alpina B6-2.7', '1984', '1988', 'E30', '56', '16.0', '8.0', '225', '45', '16.0', '8.0', 'Y', '2636', '0.00', 'G', 'M20', '2693', '6', '210', '5800', '197', '5000', '101.0', '3.73', '6', '6', 'S', '2.20', 'RWD'), ('73', '316 Euro', '1984', '1990', 'E30', '33', '14.0', '5.5', '175', '70', '14.0', '5.5', 'N', '2183', '0.55', 'G', 'M10', '1767', '4', '90', '6000', '103', '4000', '101.0', '3.91', '0', '0', 'B', '2.04', 'RWD'), ('74', '320/6 Euro', '1984', '1990', 'E30', '38', '14.0', '5.5', '195', '60', '14.0', '6.0', 'N', '2491', '0.50', 'G', 'M20', '1990', '6', '122', '6000', '118', '4000', '101.0', '3.64', '1', '1', 'B', '2.04', 'RWD'), ('75', 'Hartge H26', '1984', '1991', 'E30', '52', '15.0', '7.0', '225', '55', '15.0', '7.0', 'Y', '2690', '0.00', 'G', 'M20', '2560', '6', '187', '6000', '190', '4100', '101.0', '3.45', '7', '7', 'S', '2.33', 'RWD'), ('76', '325/325e', '1986', '1986', 'E30', '27', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2770', '0.54', 'G', 'M20', '2693', '6', '121', '4250', '170', '3250', '101.0', '2.93', '0', '0', 'B', '2.20', 'RWD'), ('77', '325es', '1986', '1988', 'E30', '27', '14.0', '6.0', '195', '65', '14.0', '6.0', 'Y', '2785', '0.54', 'G', 'M20', '2693', '6', '121', '4250', '170', '3250', '101.0', '2.93', '0', '0', 'S', '2.20', 'RWD'), ('78', '325(e)', '1987', '1988', 'E30', '27', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2765', '0.54', 'G', 'M20', '2693', '6', '121', '4250', '170', '3250', '101.0', '2.93', '0', '0', 'B', '2.20', 'RWD'), ('79', '325i', '1987', '1988', 'E30', '32', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2850', '0.54', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '5', '5', 'B', '2.20', 'RWD'), ('80', '325is', '1987', '1988', 'E30', '41', '14.0', '6.5', '195', '65', '14.0', '6.5', 'Y', '2815', '0.53', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '5', '5', 'S', '2.20', 'RWD'), ('81', '325i Convertible', '1987', '1990', 'E30', '29', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '3015', '0.54', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '4', '4', 'B', '2.20', 'RWD'), ('82', 'Alpina C1-2.5', '1987', '1990', 'E30', '53', '16.0', '8.0', '225', '45', '16.0', '8.0', 'Y', '2580', '0.00', 'G', 'M20', '2560', '4', '185', '5800', '173', '5000', '101.0', '3.64', '5', '5', 'S', '2.20', 'RWD'), ('83', 'Alpina C2-2.7', '1987', '1990', 'E30', '43', '16.0', '8.0', '225', '45', '16.0', '8.0', 'Y', '2897', '0.00', 'G', 'M20', '2770', '4', '210', '5800', '213', '5800', '101.0', '3.64', '2', '2', 'S', '2.20', 'RWD'), ('84', '325i Euro', '1987', '1991', 'E30', '41', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2485', '0.54', 'G', 'M20', '2494', '6', '171', '5800', '170', '3250', '101.0', '3.64', '8', '8', 'B', '2.20', 'RWD'), ('85', 'M3 Euro', '1987', '1991', 'E30', '54', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '2568', '0.52', 'G', 'S14', '2302', '4', '200', '6750', '177', '4750', '101.0', '3.25', '7', '7', 'M', '2.40', 'RWD'), ('86', '325ix', '1988', '1990', 'E30', '36', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '3010', '0.55', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.91', '0', '0', 'B', '2.20', 'AWD'), ('87', 'M3', '1988', '1991', 'E30', '47', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '2865', '0.52', 'G', 'S14', '2302', '4', '192', '6750', '170', '4750', '101.0', '4.10', '7', '7', 'M', '2.20', 'RWD'), ('88', 'M3 Dinan Stroker', '1988', '1991', 'E30', '50', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '2865', '0.52', 'G', 'S14', '2430', '4', '220', '6250', '223', '4000', '101.0', '4.10', '8', '8', 'M', '2.20', 'RWD'), ('89', 'M3 Dinan Turbo', '1988', '1991', 'E30', '54', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '2865', '0.52', 'G', 'S14', '2302', '4', '323', '5500', '324', '4500', '101.0', '4.10', '8', '8', 'M', '2.20', 'RWD'), ('90', '325i', '1989', '1989', 'E30', '31', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2895', '0.54', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '5', '5', 'B', '2.20', 'RWD'), ('91', '325is', '1989', '1991', 'E30', '39', '14.0', '6.5', '195', '65', '14.0', '6.5', 'Y', '2865', '0.53', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '4', '4', 'S', '2.20', 'RWD'), ('92', '318i 4 Dr', '1990', '1991', 'E30', '35', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2657', '0.50', 'G', 'M40', '1796', '4', '134', '6000', '127', '4600', '101.2', '4.10', '1', '1', 'B', '2.02', 'RWD'), ('93', '318i Convertible', '1990', '1991', 'E30', '30', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2867', '0.50', 'G', 'M10', '1796', '4', '134', '6000', '127', '4600', '101.2', '4.27', '1', '1', 'B', '2.02', 'RWD'), ('94', '318is', '1990', '1991', 'E30', '39', '14.0', '6.5', '195', '65', '14.0', '6.5', 'N', '2602', '0.50', 'G', 'M40', '1796', '4', '134', '6000', '127', '4600', '101.2', '4.10', '1', '1', 'S', '2.02', 'RWD'), ('95', '325i', '1990', '1991', 'E30', '33', '14.0', '6.0', '195', '65', '14.0', '6.0', 'N', '2811', '0.54', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.2', '3.73', '5', '5', 'B', '2.20', 'RWD'), ('96', '325ix', '1991', '1991', 'E30', '37', '15.0', '7.0', '205', '55', '15.0', '7.0', 'Y', '2955', '0.55', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.91', '0', '0', 'B', '2.20', 'AWD'), ('97', '325i Convertible', '1991', '1992', 'E30', '32', '14.0', '6.5', '195', '65', '14.0', '6.5', 'N', '2988', '0.54', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '101.0', '3.73', '4', '4', 'B', '2.20', 'RWD'), ('98', '850i', '1991', '1993', 'E31', '30', '16.0', '7.5', '235', '60', '16.0', '7.5', 'Y', '4123', '0.51', 'G', 'M70', '4988', '12', '296', '5200', '332', '4100', '105.7', '2.65', '4', '4', 'B', '2.53', 'RWD'), ('99', '850csi', '1994', '1994', 'E31', '43', '17.0', '9.0', '265', '40', '17.0', '9.0', 'Y', '4240', '0.51', 'G', 'S70', '5576', '12', '372', '5300', '402', '4000', '105.7', '4.27', '8', '8', 'S', '1.85', 'RWD'), ('100', '840ci', '1994', '1997', 'E31', '30', '16.0', '7.5', '235', '50', '16.0', '7.5', 'Y', '4123', '0.51', 'G', 'M60', '3982', '8', '282', '5800', '295', '4500', '105.7', '3.64', '4', '4', 'B', '1.98', 'RWD'), ('101', '850ci', '1994', '1997', 'E31', '33', '16.0', '7.5', '235', '50', '16.0', '7.5', 'Y', '4123', '0.51', 'G', 'M70', '4988', '12', '296', '5200', '332', '4100', '105.7', '3.64', '6', '6', 'B', '1.98', 'RWD'), ('102', '850csi', '1995', '1997', 'E31', '40', '17.0', '9.0', '265', '40', '17.0', '8.0', 'Y', '4240', '0.51', 'G', 'S70', '5576', '12', '372', '5300', '402', '4000', '105.7', '2.93', '8', '8', 'S', '2.53', 'RWD'), ('103', '735i', '1988', '1992', 'E32', '30', '15.0', '7.0', '225', '60', '15.0', '7.0', 'Y', '3835', '0.49', 'G', 'M30', '3430', '6', '208', '5700', '225', '4000', '111.5', '3.64', '3', '3', 'B', '2.20', 'RWD'), ('104', '735iL', '1988', '1992', 'E32', '26', '15.0', '7.0', '225', '60', '15.0', '7.0', 'Y', '4015', '0.49', 'G', 'M30', '3430', '6', '208', '5700', '225', '4000', '116.0', '4.27', '2', '2', 'B', '1.80', 'RWD'), ('105', '750iL', '1988', '1994', 'E32', '25', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '4167', '0.49', 'G', 'M70', '4988', '12', '296', '5200', '332', '4100', '116.0', '3.64', '4', '4', 'B', '1.80', 'RWD'), ('106', '740i', '1993', '1994', 'E32', '27', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '4002', '0.49', 'G', 'M60 B40', '3982', '8', '282', '5800', '295', '4500', '111.5', '2.93', '5', '5', 'B', '2.50', 'RWD'), ('107', '740iL', '1993', '1994', 'E32', '26', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '4090', '0.49', 'G', 'M60 B40', '3982', '8', '282', '5800', '295', '4500', '116.0', '2.93', '4', '4', 'B', '2.50', 'RWD'), ('108', '740i', '1995', '1995', 'E32', '29', '16.0', '8.0', '235', '60', '16.0', '8.0', 'N', '4145', '0.49', 'G', 'M60 B40', '3982', '8', '282', '5800', '295', '4500', '115.4', '3.15', '4', '4', 'B', '2.50', 'RWD'), ('109', '525i', '1989', '1990', 'E34', '29', '15.0', '7.0', '205', '65', '15.0', '7.0', 'N', '3395', '0.50', 'G', 'M20', '2494', '6', '168', '5800', '164', '4300', '105.2', '3.73', '1', '1', 'B', '2.20', 'RWD'), ('110', '535i', '1989', '1993', 'E34', '30', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3570', '0.50', 'G', 'M30', '3430', '6', '208', '5700', '225', '4000', '108.7', '3.46', '4', '4', 'B', '2.20', 'RWD'), ('111', '525i', '1991', '1992', 'E34', '30', '15.0', '7.0', '205', '65', '15.0', '7.0', 'N', '3484', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '188', '4200', '105.2', '3.23', '2', '2', 'B', '2.49', 'RWD'), ('112', 'M5', '1991', '1993', 'E34', '43', '17.0', '8.0', '235', '45', '17.0', '8.0', 'Y', '3805', '0.50', 'G', 'S38', '3534', '6', '310', '6900', '265', '4750', '105.2', '3.91', '7', '7', 'M', '2.08', 'RWD'), ('113', '525i Touring', '1992', '1992', 'E34', '25', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3760', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '188', '4200', '105.2', '4.10', '2', '2', 'B', '1.98', 'RWD'), ('114', '525i', '1993', '1995', 'E34', '30', '15.0', '7.0', '205', '65', '15.0', '7.0', 'N', '3484', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '193', '4200', '105.2', '3.23', '2', '2', 'B', '2.49', 'RWD'), ('115', '525i Touring', '1993', '1995', 'E34', '25', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3760', '0.50', 'G', 'M20', '2500', '6', '189', '5900', '193', '4200', '105.2', '4.10', '2', '2', 'B', '1.98', 'RWD'), ('116', '530i', '1993', '1995', 'E34', '28', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3627', '0.50', 'G', 'M60', '2997', '8', '215', '5800', '214', '4500', '105.2', '3.07', '3', '3', 'B', '2.49', 'RWD'), ('117', '530i Touring', '1993', '1995', 'E34', '24', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3881', '0.50', 'G', 'M60', '2997', '8', '215', '5800', '214', '4500', '105.2', '3.23', '2', '2', 'B', '2.42', 'RWD'), ('118', '540i', '1995', '1995', 'E34', '31', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3693', '0.50', 'G', 'M60 B40', '3982', '8', '282', '5800', '295', '4500', '105.2', '2.93', '6', '6', 'B', '2.51', 'RWD'), ('119', '540i Sport', '1995', '1995', 'E34', '32', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3645', '0.50', 'G', 'M60 B40', '3982', '8', '282', '5800', '295', '4500', '105.2', '2.93', '6', '6', 'S', '2.51', 'RWD'), ('120', '325i 4 Dr', '1992', '1992', 'E36', '37', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3087', '0.50', 'G', 'M50', '2500', '6', '189', '5500', '188', '3950', '106.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('121', '325is', '1992', '1992', 'E36', '39', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3021', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '188', '4200', '106.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('122', '318i 4 Dr', '1992', '1994', 'E36', '31', '15.0', '6.0', '185', '65', '15.0', '6.0', 'N', '2867', '0.50', 'G', 'M40', '1796', '4', '138', '6000', '129', '4600', '106.3', '3.45', '1', '1', 'B', '2.52', 'RWD'), ('123', '318is', '1992', '1994', 'E36', '36', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '2867', '0.50', 'G', 'M40', '1796', '4', '138', '6000', '129', '4500', '106.3', '3.45', '0', '0', 'B', '2.52', 'RWD'), ('124', '318i Convertible', '1993', '1995', 'E36', '30', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3120', '0.50', 'G', 'M40', '1796', '4', '138', '6000', '129', '4500', '106.3', '3.45', '0', '0', 'B', '2.52', 'RWD'), ('125', '325i 4 Dr', '1993', '1995', 'E36', '37', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3087', '0.50', 'G', 'M50', '2500', '6', '189', '5500', '193', '3950', '106.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('126', '325is', '1993', '1995', 'E36', '38', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3087', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '193', '4200', '106.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('127', '325is M Technik', '1994', '1994', 'E36', '38', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3087', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '193', '4200', '106.3', '3.15', '5', '5', 'M', '2.52', 'RWD'), ('128', '325i Convertible', '1994', '1995', 'E36', '33', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3352', '0.50', 'G', 'M50', '2500', '6', '189', '5900', '193', '4200', '106.3', '3.15', '3', '3', 'B', '2.52', 'RWD'), ('129', '318i 4 Dr', '1995', '1995', 'E36', '30', '15.0', '6.0', '185', '65', '15.0', '6.0', 'N', '2933', '0.50', 'G', 'M40', '1796', '4', '138', '6000', '129', '4500', '106.3', '3.45', '1', '1', 'B', '2.52', 'RWD'), ('130', '318is', '1995', '1995', 'E36', '34', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '2933', '0.50', 'G', 'M40', '1796', '4', '138', '6000', '129', '4500', '106.3', '3.45', '0', '0', 'B', '2.52', 'RWD'), ('131', 'M3', '1995', '1995', 'E36', '49', '17.0', '7.5', '235', '40', '17.0', '7.5', 'Y', '3175', '0.50', 'G', 'S50', '2990', '6', '240', '6000', '225', '4250', '106.7', '3.15', '8', '8', 'M', '2.49', 'RWD'), ('132', 'M3 Lightweight', '1995', '1995', 'E36', '58', '17.0', '8.5', '235', '40', '17.0', '8.5', 'Y', '2950', '0.50', 'G', 'S50', '2990', '6', '240', '6000', '225', '4250', '106.7', '3.23', '8', '8', 'M', '2.49', 'RWD'), ('133', '318i 4 Dr', '1996', '1997', 'E36', '30', '15.0', '6.0', '185', '65', '15.0', '6.0', 'N', '2976', '0.50', 'G', 'M44', '1900', '4', '138', '6000', '133', '4300', '106.3', '3.45', '1', '1', 'B', '2.52', 'RWD'), ('134', '318i Convertible', '1996', '1997', 'E36', '31', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3131', '0.50', 'G', 'M44', '1900', '4', '138', '6000', '133', '4300', '106.3', '3.45', '0', '0', 'B', '2.52', 'RWD'), ('135', '318is', '1996', '1997', 'E36', '34', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '2976', '0.50', 'G', 'M44', '1900', '4', '138', '6000', '133', '4300', '106.3', '3.45', '0', '0', 'B', '2.52', 'RWD'), ('136', '328i Convertible', '1996', '1997', 'E36', '32', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3362', '0.50', 'G', 'M52', '2800', '6', '190', '5300', '206', '3950', '106.3', '2.93', '3', '3', 'B', '2.49', 'RWD'), ('137', '328i 4 Dr', '1996', '1998', 'E36', '36', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3120', '0.50', 'G', 'M52', '2800', '6', '190', '5300', '206', '3950', '106.3', '2.93', '4', '4', 'B', '2.49', 'RWD'), ('138', '328is', '1996', '1999', 'E36', '36', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3120', '0.50', 'G', 'M52', '2800', '6', '190', '5300', '206', '3950', '106.3', '2.93', '4', '4', 'B', '2.49', 'RWD'), ('139', 'M3 4 Dr', '1996', '1998', 'E36', '52', '17.0', '8.5', '245', '40', '17.0', '7.5', 'Y', '3175', '0.50', 'G', 'S52', '3200', '6', '240', '6000', '236', '3800', '106.7', '3.23', '8', '8', 'M', '2.49', 'RWD'), ('140', 'M3', '1996', '1999', 'E36', '52', '17.0', '8.5', '245', '40', '17.0', '7.5', 'Y', '3175', '0.50', 'G', 'S52', '3200', '6', '240', '6000', '236', '3800', '106.7', '3.23', '8', '8', 'M', '2.49', 'RWD'), ('141', 'M3 Convertible', '1997', '1999', 'E36', '45', '17.0', '8.5', '245', '40', '17.0', '7.5', 'Y', '3494', '0.50', 'G', 'S52', '3200', '6', '240', '6000', '236', '3800', '106.7', '3.23', '7', '7', 'M', '2.49', 'RWD'), ('142', '323i Convertible', '1998', '1998', 'E36', '31', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3296', '0.50', 'G', 'M52', '2500', '6', '168', '5500', '181', '3950', '106.3', '2.93', '1', '1', 'B', '2.52', 'RWD'), ('143', '323is', '1998', '1999', 'E36', '36', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3075', '0.50', 'G', 'M52', '2500', '6', '168', '5500', '181', '3950', '106.3', '2.93', '2', '2', 'B', '2.52', 'RWD'), ('144', '328i Convertible', '1998', '1999', 'E36', '32', '15.0', '7.0', '205', '60', '15.0', '7.0', 'N', '3395', '0.50', 'G', 'M52', '2800', '6', '190', '5300', '206', '3950', '106.3', '2.93', '3', '3', 'B', '2.49', 'RWD'), ('145', '318ti', '1995', '1995', 'E36/5', '34', '15.0', '6.0', '185', '65', '15.0', '6.0', 'N', '2745', '0.50', 'G', 'M42', '1796', '4', '138', '6000', '129', '4500', '106.3', '3.45', '1', '1', 'B', '2.52', 'RWD'), ('146', '318ti', '1996', '1999', 'E36/5', '35', '15.0', '6.0', '185', '65', '15.0', '6.0', 'N', '2745', '0.50', 'G', 'M44', '1900', '4', '138', '6000', '133', '4300', '106.3', '3.45', '2', '2', 'B', '2.52', 'RWD'), ('147', 'Z3 1.9', '1997', '1998', 'E36/7', '39', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2701', '0.51', 'G', 'M44', '1900', '4', '138', '6000', '133', '4300', '96.3', '3.45', '1', '1', 'B', '2.52', 'RWD'), ('148', 'Z3 2.8', '1997', '1998', 'E36/7', '40', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2844', '0.51', 'G', 'M52', '2793', '6', '189', '5300', '203', '3950', '96.3', '3.15', '6', '6', 'B', '2.49', 'RWD'), ('149', 'Z3 2.3', '1999', '2000', 'E36/7', '39', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2899', '0.51', 'G', 'M52', '0', '6', '170', '5500', '181', '3500', '96.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('150', 'Z3 2.8', '1999', '2000', 'E36/7', '41', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2910', '0.51', 'G', 'M52', '2793', '6', '193', '5500', '206', '3500', '96.3', '3.15', '7', '7', 'B', '2.49', 'RWD'), ('151', 'Z3 Roadster 2.5i', '2001', '2002', 'E36/7', '41', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2899', '0.51', 'G', 'M54', '2979', '6', '184', '6000', '175', '3500', '96.0', '3.46', '7', '7', 'B', '2.52', 'RWD'), ('152', 'Z3 Roadster 3.0i', '2001', '2002', 'E36/7', '49', '17.0', '8.5', '245', '40', '17.0', '8.5', 'N', '2910', '0.51', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '96.0', '3.07', '8', '8', 'B', '2.49', 'RWD'), ('153', 'M Roadster', '1998', '2000', 'E36/7S', '53', '17.0', '9.0', '245', '40', '17.0', '7.5', 'Y', '3086', '0.51', 'G', 'S52', '3152', '6', '240', '6000', '236', '3800', '96.8', '3.23', '8', '8', 'M', '2.49', 'RWD'), ('154', 'M Roadster', '2001', '2002', 'E36/7S', '55', '17.0', '9.0', '245', '40', '17.0', '7.5', 'Y', '3086', '0.51', 'G', 'S52', '3246', '6', '315', '7400', '251', '4900', '96.8', '3.23', '9', '9', 'M', '2.49', 'RWD'), ('155', 'Z3 Coupe 2.8', '1999', '2000', 'E36/8', '48', '16.0', '7.0', '225', '50', '16.0', '7.0', 'Y', '2943', '0.51', 'G', 'M52', '2793', '6', '193', '5500', '206', '3500', '96.3', '3.15', '7', '7', 'B', '2.49', 'RWD'), ('156', 'Z3 Coupe 3.0i', '2001', '2002', 'E36/8', '49', '17.0', '8.5', '245', '40', '17.0', '8.5', 'N', '2943', '0.51', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '96.0', '3.07', '8', '8', 'B', '2.49', 'RWD'), ('157', 'M Coupe', '1998', '2000', 'E36/8S', '52', '17.0', '9.0', '245', '40', '17.0', '7.5', 'Y', '3131', '0.51', 'G', 'S52', '3152', '6', '240', '6000', '236', '3800', '96.8', '3.23', '8', '8', 'M', '2.49', 'RWD'), ('158', 'M Coupe', '2001', '2002', 'E36/8S', '54', '17.0', '9.0', '245', '40', '17.0', '7.5', 'Y', '3131', '0.51', 'G', 'S52', '3246', '6', '315', '7400', '251', '4900', '96.8', '3.23', '9', '9', 'M', '2.49', 'RWD'), ('159', '740i', '1998', '2001', 'E38', '29', '16.0', '8.0', '235', '60', '16.0', '8.0', 'N', '4255', '0.50', 'G', 'M60?', '4400', '8', '282', '5400', '324', '3700', '117.7', '2.93', '7', '7', 'B', '2.89', 'RWD'), ('160', '528i', '1997', '1998', 'E39', '29', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3450', '0.51', 'G', 'M52', '2800', '6', '190', '5300', '206', '3950', '111.4', '2.93', '2', '2', 'B', '2.49', 'RWD'), ('161', '540i', '1997', '1998', 'E39', '34', '17.0', '8.0', '235', '45', '17.0', '8.0', 'N', '3748', '0.52', 'G', 'M62', '4398', '8', '282', '5700', '310', '3900', '111.4', '2.81', '7', '7', 'B', '2.51', 'RWD'), ('162', 'M5', '1998', '2003', 'E39', '46', '18.0', '9.5', '275', '35', '18.0', '8.0', 'Y', '4024', '0.52', 'G', '', '4941', '8', '394', '6600', '368', '3800', '111.4', '3.15', '9', '9', 'M', '2.53', 'RWD'), ('163', '528i Sports Wagon', '1999', '1999', 'E39', '25', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3726', '0.51', 'G', 'M52', '2800', '6', '193', '5500', '206', '3500', '111.4', '4.10', '4', '4', 'B', '2.49', 'RWD'), ('164', '528i', '1999', '2000', 'E39', '31', '15.0', '7.0', '225', '60', '15.0', '7.0', 'N', '3495', '0.51', 'G', 'M52', '2800', '6', '193', '5500', '206', '3500', '111.4', '2.93', '4', '4', 'B', '2.49', 'RWD'), ('165', '540i', '1999', '2003', 'E39', '28', '16.0', '7.0', '225', '55', '16.0', '7.0', 'N', '3803', '0.53', 'G', 'M62', '4398', '8', '282', '5400', '324', '3600', '111.4', '2.81', '7', '7', 'B', '2.27', 'RWD'), ('166', '540i Sports Wagon', '1999', '2003', 'E39', '28', '16.0', '7.0', '225', '45', '16.0', '7.0', 'N', '4056', '0.50', 'G', 'M62', '4398', '8', '282', '5400', '324', '3600', '111.4', '3.15', '7', '7', 'B', '2.27', 'RWD'), ('167', '525i', '2001', '2003', 'E39', '32', '16.0', '7.0', '225', '55', '16.0', '7.0', 'N', '3450', '0.50', 'G', 'M54', '2979', '6', '184', '6000', '175', '3500', '111.0', '3.15', '4', '4', 'B', '2.52', 'RWD'), ('168', '525i Sports Wagon', '2001', '2003', 'E39', '30', '16.0', '7.0', '225', '55', '16.0', '7.0', 'N', '3682', '0.47', 'G', 'M54', '2979', '6', '184', '6000', '175', '3500', '111.0', '2.93', '1', '1', 'B', '2.49', 'RWD'), ('169', '530i', '2001', '2003', 'E39', '33', '16.0', '7.0', '225', '55', '16.0', '7.0', 'N', '3494', '0.51', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '113.7', '2.93', '7', '7', 'B', '2.50', 'RWD'), ('170', '323i', '1999', '2000', 'E46', '31', '15.0', '6.5', '195', '65', '15.0', '6.5', 'N', '3153', '0.53', 'G', 'M52', '2500', '6', '170', '5500', '181', '3500', '107.3', '3.07', '4', '4', 'B', '2.52', 'RWD'), ('171', '328i', '1999', '2000', 'E46', '37', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3197', '0.50', 'G', 'M52', '0', '6', '193', '5500', '206', '3500', '107.3', '2.93', '5', '5', 'B', '2.52', 'RWD'), ('172', '328Ci', '2000', '2000', 'E46', '36', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3197', '0.50', 'G', 'M52', '0', '6', '193', '5500', '206', '3500', '107.3', '3.07', '6', '6', 'B', '2.52', 'RWD'), ('173', '323Ci Convertible Sport', '1999', '2000', 'E46', '28', '16.0', '7.0', '205', '55', '16.0', '8.0', 'N', '3560', '0.53', 'G', 'M52', '2500', '6', '170', '5500', '181', '3500', '107.3', '3.46', '3', '3', 'S', '2.52', 'RWD'), ('174', '325i Sedan', '2001', '2005', 'E46', '36', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3241', '0.50', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.15', '5', '5', 'B', '2.52', 'RWD'), ('175', '325Ci Coupe', '2001', '2005', 'E46', '36', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3252', '0.50', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.15', '5', '5', 'S', '2.52', 'RWD'), ('176', '325xi Sedan', '2001', '2005', 'E46', '33', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3494', '0.53', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.23', '0', '0', 'B', '2.49', 'AWD'), ('177', '325i Wagon', '2001', '2005', 'E46', '35', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3384', '0.48', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.15', '4', '4', 'B', '2.52', 'RWD'), ('178', '325xi Wagon', '2001', '2005', 'E46', '32', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3627', '0.50', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.23', '0', '0', 'B', '2.49', 'AWD'), ('179', '330i Sedan', '2001', '2005', 'E46', '37', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3318', '0.50', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '107.3', '2.93', '8', '8', 'B', '2.49', 'RWD'), ('180', '330xi Sedan', '2001', '2005', 'E46', '39', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3527', '0.53', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '107.3', '3.07', '0', '0', 'B', '2.49', 'AWD'), ('181', '330xi Wagon', '2001', '2005', 'E46', '39', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3666', '0.50', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '107.3', '3.23', '0', '0', 'B', '2.49', 'AWD'), ('182', '325Ci Convertible', '2001', '2006', 'E46', '30', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3560', '0.50', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.46', '3', '3', 'B', '2.52', 'RWD'), ('183', '330Ci Convertible', '2001', '2006', 'E46', '32', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3616', '0.50', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '107.3', '2.93', '6', '6', 'B', '2.49', 'RWD'), ('184', '330Ci Coupe', '2001', '2006', 'E46', '36', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3351', '0.50', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '107.3', '2.93', '7', '7', 'S', '2.49', 'RWD'), ('185', 'M3', '2001', '2007', 'E46', '54', '18.0', '9.0', '255', '40', '18.0', '8.0', 'Y', '3415', '0.50', 'G', 'S54', '3246', '6', '333', '7900', '262', '4900', '107.5', '3.64', '9', '9', 'M', '2.53', 'RWD'), ('186', 'M3 Convertible', '2001', '2007', 'E46', '47', '18.0', '9.0', '255', '40', '18.0', '8.0', 'Y', '3781', '0.50', 'G', 'S54', '3246', '6', '333', '7900', '262', '4900', '107.5', '3.64', '8', '8', 'M', '2.53', 'RWD'), ('187', '330i Sedan Performance Package', '2003', '2005', 'E46', '41', '18.0', '8.5', '255', '35', '18.0', '8.0', 'N', '3370', '0.50', 'G', 'M54', '2979', '6', '235', '5900', '222', '3500', '107.3', '3.07', '8', '8', 'S', '2.49', 'RWD'), ('188', '330Ci Convertible Performance Package', '2004', '2006', 'E46', '37', '18.0', '8.5', '255', '35', '18.0', '8.0', 'N', '3616', '0.50', 'G', 'M54', '2979', '6', '235', '5900', '222', '3500', '107.3', '3.07', '7', '7', 'S', '2.49', 'RWD'), ('189', '330Ci Coupe Performance Package', '2004', '2006', 'E46', '43', '18.0', '8.5', '255', '35', '18.0', '8.0', 'N', '3285', '0.50', 'G', 'M54', '2979', '6', '235', '5900', '222', '3500', '107.3', '3.07', '8', '8', 'S', '2.50', 'RWD'), ('190', '325Ci Coupe', '2006', '2006', 'E46', '36', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3197', '0.50', 'G', 'M54', '0', '6', '184', '6000', '175', '3500', '107.3', '3.15', '5', '5', 'S', '2.52', 'RWD'), ('191', 'Z8', '2001', '2001', 'E52', '56', '18.0', '9.5', '275', '40', '18.0', '8.0', 'Y', '3494', '0.50', 'G', 'S62', '4941', '8', '394', '6600', '368', '3800', '98.6', '3.15', '9', '9', 'S', '2.53', 'RWD'), ('192', '525i', '2004', '2005', 'E60', '35', '16.0', '7.0', '225', '55', '16.0', '7.0', 'N', '3267', '0.50', 'G', '', '2500', '6', '184', '6000', '175', '3500', '113.7', '3.15', '4', '4', 'B', '2.50', 'RWD'), ('193', '530i', '2001', '2005', 'E60', '39', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3311', '0.50', 'G', '', '3000', '6', '225', '5900', '214', '3500', '113.7', '2.93', '7', '7', 'B', '2.50', 'RWD'), ('194', '545i', '2004', '2005', 'E60', '42', '18.0', '9.0', '275', '35', '18.0', '8.0', 'N', '3587', '0.50', 'G', '', '4400', '8', '325', '6100', '330', '3600', '113.7', '2.93', '9', '9', 'S', '2.40', 'RWD'), ('195', '525i', '2006', '2007', 'E60', '40', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3278', '0.50', 'G', 'N52', '3000', '6', '215', '6250', '185', '2750', '113.7', '3.38', '8', '8', 'B', '2.46', 'RWD'), ('196', '525xi', '2006', '2007', 'E60', '44', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3477', '0.50', 'G', 'N52', '3000', '6', '215', '6250', '185', '2750', '113.7', '3.46', '0', '0', 'B', '2.50', 'AWD'), ('197', '530i', '2006', '2007', 'E60', '42', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3322', '0.50', 'G', 'N52', '3000', '6', '255', '6600', '220', '2750', '113.7', '3.23', '9', '9', 'B', '2.50', 'RWD'), ('198', '530xi', '2006', '2007', 'E60', '51', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3488', '0.50', 'G', 'N52', '3000', '6', '255', '6600', '220', '2750', '113.7', '3.23', '0', '0', 'B', '2.50', 'AWD'), ('199', '530xi Sports Wagon', '2006', '2007', 'E60', '46', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3708', '0.50', 'G', 'N52', '3000', '6', '255', '6600', '220', '2750', '113.6', '3.38', '0', '0', 'B', '2.50', 'AWD'), ('200', '550i', '2006', '2010', 'E60', '40', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3653', '0.50', 'G', '', '4800', '8', '360', '6300', '360', '3400', '113.7', '2.93', '9', '9', 'B', '2.40', 'RWD'), ('201', 'M5', '2006', '2010', 'E60', '51', '19.0', '9.5', '285', '35', '19.0', '8.5', 'Y', '3862', '0.50', 'G', '', '4999', '10', '500', '7750', '383', '6100', '113.7', '3.62', '9', '9', 'M', '2.65', 'RWD'), ('202', '528I', '2008', '2010', 'E60', '40', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3355', '0.50', 'G', '', '2996', '6', '230', '6500', '200', '2750', '113.7', '3.38', '8', '8', 'B', '2.46', 'RWD'), ('203', '528XI', '2008', '2010', 'E60', '43', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3620', '0.51', 'G', '', '2996', '6', '230', '6500', '200', '2750', '113.7', '3.46', '0', '0', 'B', '2.50', 'AWD'), ('204', '535I', '2008', '2010', 'E60', '40', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3510', '0.51', 'G', 'N54', '3000', '6', '300', '5800', '300', '1400', '113.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('205', '535XI', '2008', '2010', 'E60', '50', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3796', '0.52', 'G', 'N54', '3000', '6', '300', '5800', '300', '1400', '113.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('206', '535XI Sports Wagon', '2008', '2010', 'E60', '47', '17.0', '7.5', '225', '50', '17.0', '7.5', 'Y', '3995', '0.49', 'G', 'N54', '3000', '6', '300', '5800', '300', '1400', '113.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('207', '645Ci', '2004', '2005', 'E63', '40', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '3631', '0.51', 'G', 'M62', '4398', '8', '325', '6100', '330', '3600', '109.0', '3.46', '9', '9', 'B', '2.40', 'RWD'), ('208', '645Ci Convertible', '2004', '2005', 'E63', '37', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4028', '0.48', 'G', 'M62', '4398', '8', '325', '6100', '330', '3600', '109.0', '3.46', '9', '9', 'B', '2.40', 'RWD'), ('209', 'M6', '2006', '2010', 'E63', '50', '19.0', '9.5', '255', '40', '19.0', '8.5', 'Y', '3759', '0.53', 'G', '', '4999', '10', '500', '7750', '383', '6100', '109.5', '3.62', '9', '9', 'M', '2.65', 'RWD'), ('210', '650i Coupe', '2006', '2011', 'E63', '42', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '3664', '0.51', 'G', '', '4800', '8', '360', '6300', '360', '3400', '109.4', '3.46', '9', '9', 'B', '2.40', 'RWD'), ('211', 'M6 convertible', '2006', '2010', 'E64', '45', '19.0', '9.5', '255', '40', '19.0', '8.5', 'Y', '4248', '0.50', 'G', '', '4999', '10', '500', '7750', '383', '6100', '109.5', '3.62', '9', '9', 'M', '2.65', 'RWD'), ('212', '650i Convertible', '2006', '2011', 'E64', '37', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4127', '0.48', 'G', '', '4800', '8', '360', '6300', '360', '3400', '109.4', '3.46', '9', '9', 'B', '2.40', 'RWD'), ('213', '745i', '2002', '2004', 'E65', '32', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4226', '0.50', 'G', '', '4398', '8', '325', '6100', '330', '3600', '117.7', '3.38', '8', '8', 'B', '2.34', 'RWD'), ('214', '745Li', '2002', '2004', 'E66', '29', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4314', '0.51', 'G', '', '4398', '8', '325', '6100', '330', '3600', '123.2', '3.38', '8', '8', 'B', '2.34', 'RWD'), ('215', '760i', '2002', '2004', 'E66', '34', '20.0', '10.0', '275', '40', '20.0', '9.0', 'N', '4612', '0.51', 'G', '', '5972', '12', '438', '6000', '444', '3950', '118.0', '4.17', '9', '9', 'B', '2.34', 'RWD'), ('216', '750i', '2006', '2009', 'E66', '32', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4336', '0.50', 'G', '', '4800', '8', '360', '6300', '360', '3400', '117.7', '3.38', '9', '9', 'B', '2.34', 'RWD'), ('217', '750Li', '2006', '2008', 'E67', '31', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4402', '0.50', 'G', '', '4800', '8', '360', '6300', '360', '3400', '123.2', '3.38', '8', '8', 'B', '2.34', 'RWD'), ('218', '760i', '2006', '2009', 'E68', '32', '20.0', '10.0', '275', '35', '20.0', '9.0', 'N', '4612', '0.51', 'G', '', '6000', '12', '438', '6000', '444', '3950', '117.7', '3.15', '8', '8', 'B', '2.34', 'RWD'), ('219', '760Li', '2006', '2009', 'E69', '30', '19.0', '10.0', '275', '40', '19.0', '9.0', 'N', '4755', '0.51', 'G', '', '6000', '12', '438', '6000', '444', '3950', '123.2', '3.15', '8', '8', 'B', '2.34', 'RWD'), ('220', '135i Coupe', '2008', '2010', 'E82', '46', '18.0', '8.5', '245', '35', '18.0', '7.5', 'N', '3182', '0.52', 'G', 'N54', '2979', '6', '300', '5800', '300', '1400', '104.7', '3.08', '9', '9', 'S', '2.40', 'RWD'), ('221', '128i Coupe', '2008', '2013', 'E82', '41', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3102', '0.51', 'G', 'NULL', '2996', '6', '230', '6500', '200', '2750', '104.7', '3.23', '9', '9', 'B', '2.46', 'RWD'), ('222', '135i Coupe', '2011', '2013', 'E82', '46', '18.0', '8.5', '245', '35', '18.0', '7.5', 'N', '3182', '0.52', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '104.7', '3.08', '9', '9', 'S', '2.32', 'RWD'), ('223', '1M Coupe', '2011', '2012', 'E82', '63', '19.0', '10.0', '265', '35', '19.0', '9.0', 'Y', '3131', '0.52', 'G', '', '0', '6', '335', '5800', '370', '1500', '104.7', '3.15', '9', '9', 'M', '2.32', 'RWD'), ('224', 'Z4 2.5i', '2003', '2005', 'E85', '44', '16.0', '7.0', '225', '50', '16.0', '7.0', 'N', '2782', '0.50', 'G', 'M54', '2979', '6', '184', '6000', '175', '3500', '98.2', '3.46', '8', '8', 'B', '2.50', 'RWD'), ('225', 'Z4 3.0i', '2003', '2005', 'E85', '50', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '2848', '0.50', 'G', 'M54', '2979', '6', '225', '5900', '214', '3500', '98.2', '3.07', '8', '8', 'B', '2.50', 'RWD'), ('226', 'Z4 3.0i', '2006', '2008', 'E85', '49', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '2870', '0.50', 'G', 'N52', null, '6', '215', '6250', '185', '2750', '98.2', '3.07', '9', '9', 'B', '2.50', 'RWD'), ('227', 'Z4 3.0is', '2006', '2008', 'E85', '51', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '2936', '0.50', 'G', 'M54', null, '6', '255', '6600', '220', '2750', '98.2', '3.07', '9', '9', 'B', '2.50', 'RWD'), ('228', 'Z4 M', '2006', '2008', 'E85', '62', '18.0', '9.0', '255', '35', '18.0', '8.0', 'Y', '2930', '0.50', 'G', 'M54', '2979', '6', '330', '7900', '262', '4900', '98.2', '3.07', '9', '9', 'M', '2.50', 'RWD'), ('229', 'Z4 3.0is Coupe', '2006', '2008', 'E86', '50', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '2958', '0.50', 'G', 'M54', null, '6', '255', '6600', '220', '2750', '98.2', '3.07', '9', '9', 'B', '2.50', 'RWD'), ('230', 'Z4 M Coupe', '2006', '2008', 'E86', '58', '18.0', '9.0', '255', '35', '18.0', '8.0', 'Y', '3080', '0.50', 'G', 'M54', '2979', '6', '330', '7900', '262', '4900', '98.2', '3.07', '9', '9', 'M', '2.50', 'RWD'), ('231', '135i Convertible', '2008', '2010', 'E88', '39', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3510', '0.50', 'G', 'N54', '2979', '6', '300', '5800', '300', '1400', '104.7', '3.08', '9', '9', 'S', '2.40', 'RWD'), ('232', '128i Convertible', '2008', '2013', 'E88', '38', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3407', '0.49', 'G', 'NULL', '2996', '6', '230', '6500', '200', '2750', '104.7', '3.23', '8', '8', 'B', '2.46', 'RWD'), ('233', '135i Convertible', '2011', '2013', 'E88', '40', '17.0', '7.0', '205', '50', '17.0', '7.0', 'N', '3510', '0.49', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '104.7', '3.08', '9', '9', 'B', '2.32', 'RWD'), ('234', 'Z430i', '2009', '2010', 'E89', '50', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3076', '0.48', 'G', 'N52', null, '6', '255', '6600', '220', '2600', '98.3', '4.27', '9', '9', 'B', '2.01', 'RWD'), ('235', 'Z435i', '2009', '2010', 'E89', '48', '17.0', '8.5', '255', '40', '17.0', '8.0', 'N', '3285', '0.49', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '98.3', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('236', 'Z430i', '2011', '2011', 'E89', '49', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3102', '0.48', 'G', 'N52', '0', '6', '255', '6600', '220', '2600', '98.3', '4.27', '9', '9', 'B', '2.01', 'RWD'), ('237', 'Z435i', '2011', '2013', 'E89', '47', '17.0', '8.5', '255', '40', '17.0', '8.0', 'N', '3355', '0.49', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '98.3', '3.08', '9', '9', 'B', '2.46', 'RWD'), ('238', 'Z435is', '2011', '2013', 'E89', '47', '17.0', '8.5', '255', '40', '17.0', '8.0', 'N', '3399', '0.49', 'G', 'N54', '0', '6', '335', '5900', '370', '1300', '98.3', '3.08', '9', '9', 'S', '2.40', 'RWD'), ('239', 'Z428i', '2012', '2013', 'E89', '49', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3098', '0.47', 'G', 'N20', '0', '4', '240', '5000', '260', '1250', '96.3', '3.08', '9', '9', 'B', '2.06', 'RWD'), ('240', '325i', '2006', '2006', 'E90', '40', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3135', '0.50', 'G', 'N52', '0', '6', '215', '6250', '185', '2750', '108.7', '3.23', '8', '8', 'B', '2.46', 'RWD'), ('241', '325xi 4 Dr', '2006', '2006', 'E90', '43', '16.0', '7.0', '205', '55', '16.0', '7.0', 'Y', '3410', '0.52', 'G', 'M54', '0', '6', '215', '6250', '185', '2750', '108.7', '3.23', '0', '0', 'B', '2.46', 'AWD'), ('242', '330i', '2006', '2006', 'E90', '44', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3267', '0.51', 'G', 'N52', '0', '6', '255', '6600', '220', '2750', '108.7', '3.15', '9', '9', 'B', '2.50', 'RWD'), ('243', '330xi 4 Dr', '2006', '2006', 'E90', '51', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3477', '0.52', 'G', 'M54', '2979', '6', '255', '6600', '220', '2750', '108.7', '3.15', '0', '0', 'B', '2.50', 'AWD'), ('244', '335i Sedan', '2007', '2010', 'E90', '43', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3443', '0.51', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('245', '328i Sedan', '2007', '2011', 'E90', '40', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3190', '0.51', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.23', '9', '9', 'B', '2.50', 'RWD'), ('246', '328xi Sedan', '2007', '2011', 'E90', '46', '16.0', '7.0', '205', '55', '16.0', '7.0', 'Y', '3432', '0.50', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.38', '0', '0', 'B', '2.50', 'AWD'), ('247', '335xi Sedan', '2008', '2010', 'E90', '51', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3764', '0.53', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '108.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('248', 'M3 sedan', '2008', '2011', 'E90', '55', '18.0', '9.5', '265', '35', '18.0', '8.5', 'Y', '3576', '0.51', 'G', 'N52', null, '8', '414', '8300', '295', '3950', '108.7', '3.15', '9', '9', 'M', '2.40', 'RWD'), ('249', '335d Sedan', '2009', '2011', 'E90', '38', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3575', '0.51', 'D', 'N54', null, '6', '265', '4200', '425', '1750', '108.7', '2.81', '7', '7', 'B', '2.34', 'RWD'), ('250', '335i Sedan', '2011', '2011', 'E90', '43', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3443', '0.51', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('251', '335xi Sedan', '2011', '2011', 'E90', '51', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3764', '0.53', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '108.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('252', '325xi Sports Wagon', '2006', '2006', 'E91', '40', '16.0', '7.0', '205', '55', '16.0', '7.0', 'Y', '3587', '0.50', 'G', 'N52', '0', '6', '215', '6250', '185', '2750', '108.7', '3.38', '0', '0', 'B', '2.50', 'AWD'), ('253', '328i Wagon', '2007', '2012', 'E91', '36', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3377', '0.51', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.15', '8', '8', 'B', '2.50', 'RWD'), ('254', '328xi Wagon', '2007', '2012', 'E91', '42', '16.0', '7.0', '205', '55', '16.0', '7.0', 'Y', '3620', '0.50', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.38', '0', '0', 'B', '2.50', 'AWD'), ('255', '335i Coupe', '2007', '2010', 'E92', '43', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3421', '0.51', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('256', '328i Coupe', '2007', '2013', 'E92', '43', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3201', '0.51', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.23', '8', '8', 'B', '2.50', 'RWD'), ('257', '328xi Coupe', '2007', '2013', 'E92', '49', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3432', '0.50', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.38', '0', '0', 'B', '2.50', 'AWD'), ('258', '335xi Coupe', '2008', '2010', 'E92', '54', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3609', '0.53', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '108.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('259', 'M3 coupe', '2008', '2013', 'E92', '56', '18.0', '9.5', '265', '35', '18.0', '8.5', 'Y', '3554', '0.51', 'G', 'N52', null, '8', '414', '8300', '295', '3950', '108.7', '3.15', '9', '9', 'M', '2.40', 'RWD'), ('260', '335i Coupe', '2011', '2013', 'E92', '43', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3421', '0.51', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('261', '335is Coupe', '2011', '2013', 'E92', '45', '18.0', '8.5', '255', '35', '18.0', '8.0', 'N', '3421', '0.51', 'G', 'N54', '0', '6', '320', '5900', '370', '1300', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('262', '335xi Coupe', '2011', '2013', 'E92', '54', '17.0', '8.0', '225', '45', '17.0', '8.0', 'Y', '3609', '0.53', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '108.7', '3.08', '0', '0', 'B', '2.40', 'AWD'), ('263', '335i Convertible', '2007', '2010', 'E93', '41', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3796', '0.47', 'G', 'N54', null, '6', '300', '5800', '300', '1400', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('264', '328i Convertible', '2007', '2013', 'E93', '38', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3642', '0.49', 'G', 'N52', null, '6', '230', '6500', '200', '2750', '108.7', '3.23', '8', '8', 'B', '2.50', 'RWD'), ('265', 'M3 convertible', '2008', '2013', 'E93', '52', '18.0', '9.5', '265', '35', '18.0', '8.5', 'Y', '3995', '0.47', 'G', 'N52', null, '8', '414', '8300', '295', '3950', '108.7', '3.15', '9', '9', 'M', '2.40', 'RWD'), ('266', '335i Convertible', '2011', '2013', 'E93', '41', '17.0', '8.0', '225', '45', '17.0', '8.0', 'N', '3796', '0.47', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('267', '335is Convertible', '2011', '2013', 'E93', '41', '18.0', '8.5', '255', '35', '18.0', '8.0', 'N', '3851', '0.47', 'G', 'N54', '0', '6', '320', '5900', '370', '1300', '108.7', '3.08', '9', '9', 'B', '2.40', 'RWD'), ('268', '750i', '2010', '2012', 'F01', '33', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4399', '0.51', 'G', 'NULL', null, '8', '400', '5500', '450', '1800', '120.9', '3.38', '9', '9', 'B', '2.34', 'RWD'), ('269', '750i xDrive', '2010', '2012', 'F01', '48', '18.0', '8.0', '245', '50', '18.0', '8.0', 'Y', '4553', '0.53', 'G', 'NULL', null, '8', '400', '5500', '450', '1800', '120.9', '3.46', '0', '0', 'B', '2.34', 'AWD'), ('270', '740i', '2011', '2013', 'F01', '33', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4194', '0.50', 'G', 'N55', '0', '6', '315', '5800', '330', '1600', '120.9', '3.46', '9', '9', 'B', '2.34', 'RWD'), ('271', 'ActiveHybrid 7', '2011', '2013', 'F01', '35', '19.0', '8.5', '245', '50', '19.0', '8.5', 'N', '4645', '0.51', 'H', '', '0', '8', '455', '5500', '515', '2000', '120.9', '2.81', '9', '9', 'B', '3.14', 'RWD'), ('272', '750Li', '2010', '2012', 'F02', '32', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4476', '0.51', 'G', 'NULL', null, '8', '400', '5500', '450', '1800', '126.4', '3.38', '9', '9', 'B', '2.34', 'RWD'), ('273', '750Li xDrive', '2010', '2012', 'F02', '46', '18.0', '8.0', '245', '50', '18.0', '8.0', 'Y', '4696', '0.53', 'G', 'NULL', null, '8', '400', '5500', '450', '1800', '126.4', '3.46', '0', '0', 'B', '2.34', 'AWD'), ('274', '760Li', '2010', '2013', 'F02', '31', '19.0', '8.5', '245', '45', '19.0', '8.5', 'N', '4860', '0.52', 'G', 'NULL', null, '12', '535', '5250', '550', '1500', '126.4', '2.81', '9', '9', 'S', '3.14', 'RWD'), ('275', '740Li', '2011', '2013', 'F02', '32', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4282', '0.50', 'G', 'N55', '0', '6', '315', '5800', '330', '1600', '126.4', '3.46', '8', '8', 'B', '2.34', 'RWD'), ('276', 'ActiveHybrid 7', '2011', '2013', 'F02', '35', '19.0', '8.5', '245', '50', '19.0', '8.5', 'N', '4689', '0.51', 'H', '', '0', '8', '455', '5500', '515', '2000', '126.4', '2.81', '9', '9', 'B', '3.14', 'RWD'), ('277', '535i Gran Turismo', '2011', '2013', 'F07', '30', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4491', '0.47', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '120.9', '3.08', '8', '8', 'B', '3.14', 'RWD'), ('278', '535i xDrive Gran Turismo', '2011', '2013', 'F07', '37', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4557', '0.49', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '120.9', '3.08', '0', '0', 'B', '3.14', 'AWD'), ('279', '550i Gran Turismo', '2011', '2013', 'F07', '30', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4744', '0.49', 'G', 'N63', '0', '8', '400', '5500', '450', '1750', '120.9', '3.08', '8', '8', 'B', '3.14', 'RWD'), ('280', '550i xDrive Gran Turismo', '2011', '2013', 'F07', '42', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4910', '0.50', 'G', 'N63', '0', '8', '400', '5500', '450', '1750', '120.9', '3.08', '0', '0', 'B', '3.14', 'AWD'), ('281', '528i', '2011', '2011', 'F10', '36', '17.0', '8.0', '225', '55', '17.0', '8.0', 'N', '3664', '0.50', 'G', 'N52', '0', '6', '240', '6600', '230', '2600', '116.9', '3.39', '8', '8', 'B', '3.14', 'RWD'), ('282', '535i ', '2011', '2013', 'F10', '35', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '3906', '0.51', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '116.9', '3.08', '8', '8', 'B', '3.14', 'RWD'), ('283', '535i xDrive', '2011', '2013', 'F10', '43', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4083', '0.53', 'G', 'N55', '0', '6', '300', '5800', '300', '1200', '116.9', '3.08', '0', '0', 'B', '3.14', 'AWD'), ('284', '550i', '2011', '2013', 'F10', '34', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4193', '0.52', 'G', 'N63', '0', '8', '400', '5500', '450', '1750', '116.9', '3.08', '8', '8', 'B', '3.14', 'RWD'), ('285', '550i xDrive', '2011', '2013', 'F10', '50', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4369', '0.54', 'G', 'N63', '0', '8', '400', '5500', '450', '1750', '116.9', '3.08', '0', '0', 'B', '3.14', 'AWD'), ('286', 'ActiveE', '2011', '2012', 'E82', '33', '16.0', '7.0', '205', '55', '16.0', '7.0', 'N', '3836', '0.50', 'E', '', null, '0', '168', '4475', '184', '0', '104.7', '3.23', '1', '1', 'B', '2.50', 'RWD'), ('287', '528i', '2012', '2013', 'F10', '35', '17.0', '8.0', '225', '55', '17.0', '8.0', 'N', '3649', '0.49', 'G', 'N20', '0', '4', '240', '5000', '260', '1250', '116.9', '3.23', '6', '6', 'B', '3.14', 'RWD'), ('288', '528i xDrive', '2012', '2013', 'F10', '37', '17.0', '8.0', '225', '55', '17.0', '8.0', 'N', '3836', '0.50', 'G', 'N20', '0', '4', '240', '5000', '260', '1250', '116.9', '3.23', '0', '0', 'B', '3.14', 'AWD'), ('289', '640i convertible', '2012', '2013', 'F12', '34', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4090', '0.49', 'G', '', '0', '6', '315', '5800', '330', '1400', '112.4', '3.23', '7', '7', 'S', '3.14', 'RWD'), ('290', '650i convertible', '2012', '2012', 'F12', '35', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4366', '0.50', 'G', '', '0', '8', '400', '5500', '450', '1750', '112.4', '3.08', '8', '8', 'S', '3.14', 'RWD'), ('291', '650i convertible xDrive', '2012', '2012', 'F12', '49', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4443', '0.52', 'G', '', '0', '8', '400', '5500', '450', '1750', '112.4', '3.08', '0', '0', 'S', '3.14', 'AWD'), ('292', '640i', '2012', '2013', 'F13', '36', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '3836', '0.51', 'G', '', '0', '6', '315', '5800', '30', '1400', '112.4', '3.23', '8', '8', 'S', '3.14', 'RWD'), ('293', '650i', '2012', '2012', 'F13', '37', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4058', '0.53', 'G', '', '0', '8', '400', '5500', '450', '1750', '112.4', '3.08', '8', '8', 'S', '3.14', 'RWD'), ('294', '650i xDrive', '2012', '2012', 'F13', '52', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4222', '0.54', 'G', '', '0', '8', '400', '5500', '450', '1750', '112.4', '3.08', '0', '0', 'S', '3.14', 'AWD'), ('295', '328i sedan', '2012', '2013', 'F30', '40', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3241', '0.51', 'G', '', '0', '4', '240', '5000', '260', '1250', '110.6', '3.91', '7', '7', 'B', '2.06', 'RWD'), ('296', '335i sedan', '2012', '2013', 'F30', '44', '18.0', '8.0', '225', '45', '18.0', '8.0', 'N', '3406', '0.51', 'G', 'N55', '2979', '6', '300', '5800', '300', '1200', '110.6', '3.23', '9', '9', 'B', '2.32', 'RWD'), ('297', 'MINI Convertible', '2005', '2008', 'R52', '20', '15.0', '5.5', '175', '65', '15.0', '5.5', 'N', '2700', '0.61', 'G', '', '1600', '4', '115', '6000', '110', '4500', '97.0', '3.94', '1', '1', 'B', '1.95', 'FWD'), ('298', 'MINI Convertible S', '2005', '2008', 'R52', '30', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2844', '0.61', 'G', '', '1600', '4', '168', '6000', '162', '4000', '97.0', '2.87', '7', '7', 'B', '2.71', 'FWD'), ('299', 'MINI Cooper S', '2002', '2004', 'R53', '35', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2513', '0.63', 'G', '', '1598', '4', '163', '6000', '155', '4000', '97.0', '2.74', '7', '7', 'S', '2.62', 'FWD'), ('300', 'MINI Cooper John Cooper Works', '2002', '2005', 'R53', '47', '17.0', '7.0', '205', '45', '17.0', '7.0', 'Y', '2513', '0.63', 'G', '', '1598', '4', '200', '6000', '177', '4000', '97.0', '2.74', '9', '9', 'M', '2.62', 'FWD'), ('301', 'MINI Cooper', '2002', '2006', 'R53', '28', '15.0', '5.5', '175', '65', '15.0', '5.5', 'N', '2315', '0.63', 'G', '', '1598', '4', '115', '6000', '110', '4500', '97.0', '3.94', '2', '2', 'B', '1.95', 'FWD'), ('302', 'MINI Cooper S', '2005', '2006', 'R53', '36', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2513', '0.63', 'G', '', '1600', '4', '168', '6000', '162', '4000', '97.0', '2.87', '8', '8', 'S', '2.71', 'FWD'), ('303', 'MINI Cooper JCW GP', '2006', '2006', 'R53', '45', '18.0', '7.0', '205', '40', '18.0', '7.0', 'Y', '2578', '0.63', 'G', '', '1598', '4', '214', '7100', '184', '4600', '97.0', '2.74', '8', '8', 'M', '2.62', 'FWD'), ('304', 'MINI Cooper Clubman', '2008', '2013', 'R55', '24', '15.0', '5.5', '175', '65', '15.0', '5.5', 'N', '2573', '0.60', 'G', '', '1598', '4', '118', '6000', '114', '4250', '100.3', '4.10', '2', '2', 'B', '1.79', 'FWD'), ('305', 'MINI Cooper Clubman S', '2008', '2013', 'R55', '33', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2705', '0.60', 'G', 'NULL', '1600', '4', '181', '5500', '177', '1600', '100.3', '3.65', '8', '8', 'B', '2.13', 'FWD');
INSERT INTO `autox_cars` VALUES ('306', 'MINI Cooper Clubman John Cooper Works', '2009', '2013', 'R55', '36', '17.0', '7.0', '205', '45', '17.0', '7.0', 'N', '2738', '0.60', 'G', 'NULL', '1600', '4', '208', '6000', '207', '1900', '100.3', '3.65', '9', '9', 'M', '2.13', 'FWD'), ('307', 'MINI Cooper', '2007', '2013', 'R56', '28', '15.0', '5.5', '175', '65', '15.0', '5.5', 'N', '2396', '0.63', 'G', '', '1598', '4', '118', '6000', '114', '4250', '97.1', '4.35', '2', '2', 'B', '1.79', 'FWD'), ('308', 'MINI Cooper S', '2007', '2013', 'R56', '37', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2513', '0.63', 'G', '', '1600', '4', '181', '5500', '177', '1600', '97.1', '3.65', '8', '8', 'B', '2.13', 'FWD'), ('309', 'MINI Cooper John Cooper Works', '2009', '2013', 'R56', '39', '17.0', '7.0', '205', '45', '17.0', '7.0', 'N', '2551', '0.63', 'G', 'NULL', '1600', '4', '208', '6000', '207', '1900', '97.1', '3.65', '9', '9', 'M', '2.13', 'FWD'), ('310', 'MINI Convertible', '2009', '2013', 'R57', '29', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2580', '0.61', 'G', 'NULL', '1600', '4', '118', '6000', '114', '4250', '97.1', '4.35', '1', '1', 'B', '1.79', 'FWD'), ('311', 'MINI Convertible John Cooper Works', '2009', '2013', 'R57', '36', '17.0', '7.0', '205', '45', '17.0', '7.0', 'N', '2712', '0.61', 'G', 'NULL', '1600', '4', '208', '6000', '207', '1900', '97.1', '3.65', '9', '9', 'M', '2.13', 'FWD'), ('312', 'MINI Convertible S', '2009', '2013', 'R57', '34', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2690', '0.61', 'G', 'NULL', '1600', '4', '181', '5500', '177', '1600', '97.1', '3.65', '8', '8', 'S', '2.13', 'FWD'), ('313', 'Mini Cooper Coupe', '2012', '2013', 'R58', '29', '15.0', '5.5', '175', '65', '15.0', '5.5', 'N', '2392', '0.62', 'G', '', '0', '4', '121', '6000', '118', '4250', '97.1', '4.35', '3', '3', 'B', '1.79', 'FWD'), ('314', 'Mini Cooper Coupe John Cooper Works', '2012', '2013', 'R58', '39', '17.0', '7.0', '205', '45', '17.0', '7.0', 'N', '2536', '0.63', 'G', '', '0', '4', '208', '6000', '207', '1900', '97.1', '3.71', '9', '9', 'M', '2.13', 'FWD'), ('315', 'Mini Cooper Coupe S', '2012', '2013', 'R58', '35', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2514', '0.63', 'G', '', '0', '4', '181', '5500', '177', '1600', '97.1', '4.35', '7', '7', 'S', '2.13', 'FWD'), ('316', 'Mini Cooper Roadster', '2012', '2013', 'R59', '32', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2470', '0.60', 'G', '', '0', '4', '121', '6000', '118', '4250', '97.1', '4.35', '3', '3', 'B', '1.79', 'FWD'), ('317', 'Mini Cooper Roadster John Cooper Works', '2012', '2013', 'R59', '38', '17.0', '7.0', '205', '45', '17.0', '7.0', 'N', '2602', '0.62', 'G', '', '0', '4', '208', '6000', '207', '1900', '97.1', '3.71', '9', '9', 'M', '2.13', 'FWD'), ('318', 'Mini Cooper Roadster S', '2012', '2013', 'R59', '35', '16.0', '6.5', '195', '55', '16.0', '6.5', 'N', '2580', '0.62', 'G', '', '0', '4', '181', '5500', '177', '1600', '97.1', '4.35', '8', '8', 'S', '2.13', 'FWD'), ('319', 'Mini Cooper Countryman S ALL4', '2011', '2013', 'R60', '53', '17.0', '7.0', '205', '55', '7.0', '17.0', 'N', '3048', '0.58', 'G', 'NULL', '1598', '4', '181', '5500', '177', '1600', '102.2', '3.71', '0', '0', 'S', '2.13', 'AWD'), ('320', 'Mini Cooper Countryman S', '2011', '2013', 'R60', '52', '17.0', '7.0', '205', '55', '7.0', '17.0', 'N', '2894', '0.60', 'G', 'NULL', '1598', '4', '181', '5500', '177', '1600', '102.2', '3.71', '6', '6', 'S', '2.13', 'FWD'), ('321', 'Mini Cooper Countryman', '2011', '2013', 'R60', '44', '17.0', '7.0', '205', '55', '7.0', '17.0', 'N', '2794', '0.58', 'G', 'NULL', '1598', '4', '121', '6000', '114', '4250', '102.2', '4.72', '0', '0', 'B', '1.79', 'FWD'), ('322', '740iL', '1998', '2001', 'E38', '29', '16.0', '8.0', '235', '60', '16.0', '8.0', 'N', '4288', '0.50', 'G', 'M60?', '4400', '8', '282', '5400', '324', '3700', '123.3', '2.93', '7', '7', 'B', '2.89', 'RWD'), ('323', '750iL', '1998', '2001', 'E38', '24', '16.0', '7.5', '235', '60', '16.0', '7.5', 'N', '4597', '0.50', 'G', 'M70', '5400', '12', '326', '5000', '361', '3900', '123.3', '2.81', '7', '7', 'B', '2.90', 'RWD'), ('324', '760Li', '2002', '2004', 'E66', '31', '19.0', '10.0', '275', '40', '19.0', '9.0', 'N', '4722', '0.51', 'G', '', '5972', '12', '438', '6000', '444', '3950', '123.2', '3.38', '8', '8', 'B', '2.34', 'RWD'), ('325', '135is coupe', '2013', '2013', 'E82', '48', '18.0', '8.5', '245', '35', '18.0', '7.5', 'N', '3108', '0.52', 'G', 'N54', '2979', '6', '320', '5800', '317', '1300', '104.7', '3.08', '9', '9', 'S', '2.32', 'RWD'), ('326', '135is Convertible', '2013', '2013', 'E88', '44', '18.0', '8.5', '245', '35', '18.0', '7.5', 'N', '3510', '0.49', 'G', 'N55', '0', '6', '320', '5800', '317', '1500', '104.7', '3.08', '9', '9', 'B', '2.32', 'RWD'), ('327', '328xi sedan', '2013', '2013', 'F30', '44', '17.0', '7.5', '225', '50', '17.0', '7.5', 'N', '3430', '0.51', 'G', 'N20', '1997', '4', '240', '5000', '260', '1250', '110.6', '3.15', '0', '0', 'B', '3.14', 'AWD'), ('328', '335xi sedan', '2013', '2013', 'F30', '57', '18.0', '8.0', '225', '45', '18.0', '8.0', 'N', '3530', '0.52', 'G', 'N55', '2979', '6', '300', '5800', '300', '1200', '110.6', '3.23', '0', '0', 'B', '2.32', 'AWD'), ('329', 'ActiveHybrid 3', '2013', '2013', 'F30', '43', '18.0', '8.0', '225', '45', '18.0', '8.0', 'N', '3695', '0.50', 'H', null, null, null, '335', '5800', '330', '1200', null, '2.81', '8', '8', 'B', '3.14', 'RWD'), ('330', 'ActiveHybrid 5', '2013', '2013', 'F10', '36', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4233', '0.49', 'H', '', '0', '6', '335', '5800', '330', '1300', '116.9', '2.99', '8', '8', 'B', '3.14', 'RWD'), ('331', '640i Gran Coupe', '2013', '2013', 'F06', '34', '18.0', '8.0', '245', '45', '18.0', '8.0', 'N', '4026', '0.50', 'G', '', '0', '6', '315', '5800', '330', '1300', '116.9', '3.23', '7', '7', 'S', '3.14', 'RWD'), ('332', '650i Gran Coupe', '2013', '2013', 'F06', '38', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4165', '0.52', 'G', '', '0', '8', '445', '5500', '480', '2000', '116.9', '2.81', '9', '9', 'S', '3.14', 'RWD'), ('333', '650i xDrive Gran Coupe', '2013', '2013', 'F06', '55', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4440', '0.53', 'G', '', '0', '8', '445', '5500', '480', '2000', '116.9', '2.81', '0', '0', 'S', '3.14', 'AWD'), ('334', '650i convertible', '2013', '2013', 'F12', '36', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4366', '0.50', 'G', '', '0', '8', '445', '5500', '480', '2000', '112.4', '3.08', '8', '8', 'S', '3.14', 'RWD'), ('335', '650i convertible xDrive', '2013', '2013', 'F12', '53', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4443', '0.52', 'G', '', '0', '8', '445', '5500', '480', '2000', '112.4', '3.08', '0', '0', 'S', '3.14', 'AWD'), ('336', '650i', '2013', '2013', 'F13', '37', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4058', '0.53', 'G', '', '0', '8', '445', '5500', '480', '2000', '112.4', '3.08', '9', '9', 'S', '3.14', 'RWD'), ('337', '650i xDrive', '2013', '2013', 'F13', '57', '19.0', '8.5', '245', '40', '19.0', '8.5', 'N', '4222', '0.54', 'G', '', '0', '8', '445', '5500', '480', '2000', '112.4', '3.08', '0', '0', 'S', '3.14', 'AWD'), ('338', '740Li', '2013', '2013', 'F02', '29', '18.0', '8.0', '245', '50', '18.0', '8.0', 'N', '4360', '0.52', 'G', 'N55', '0', '6', '315', '5800', '330', '1600', '126.4', '3.08', '8', '8', 'B', '3.14', 'RWD'), ('339', '750i', '2013', '2013', 'F01', '36', '19.0', '8.5', '245', '45', '19.0', '8.5', 'N', '4399', '0.51', 'G', 'NULL', '4395', '8', '445', '5500', '480', '2000', '120.9', '2.81', '9', '9', 'B', '3.14', 'RWD'), ('340', '750i xDrive', '2013', '2013', 'F01', '54', '19.0', '8.5', '245', '45', '19.0', '8.5', 'Y', '4553', '0.53', 'G', 'NULL', null, '8', '445', '5500', '480', '2000', '120.9', '2.81', '0', '0', 'B', '3.14', 'AWD'), ('341', '750Li', '2013', '2013', 'F02', '35', '19.0', '8.5', '245', '45', '19.0', '8.5', 'N', '4476', '0.51', 'G', 'NULL', null, '8', '445', '5500', '480', '2000', '126.4', '2.81', '9', '9', 'B', '3.14', 'RWD'), ('342', '750Li xDrive', '2013', '2013', 'F02', '51', '19.0', '8.5', '245', '45', '19.0', '8.5', 'Y', '4696', '0.53', 'G', 'NULL', null, '8', '445', '5500', '480', '2000', '126.4', '2.81', '0', '0', 'B', '3.14', 'AWD'), ('343', 'Mini Cooper Countryman S ALL4 John Cooper Works', '2013', '2013', 'R60', '60', '17.0', '7.0', '205', '55', '7.0', '17.0', 'N', '3043', '0.58', 'G', 'NULL', '1598', '4', '208', '6000', '207', '1900', '102.2', '3.71', '0', '0', 'M', '2.13', 'AWD');
COMMIT;
-- ----------------------------
-- Table structure for `autox_classes`
-- ----------------------------
DROP TABLE IF EXISTS `autox_classes`;
CREATE TABLE `autox_classes` (
`class` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`start_points` int(3) NOT NULL,
`end_points` int(3) NOT NULL,
`adjusted_class` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`adjusting_formula` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_classes`
-- ----------------------------
BEGIN;
INSERT INTO `autox_classes` VALUES ('C', '0', '39', 'N', null), ('B', '40', '49', 'N', null), ('A', '50', '59', 'N', null), ('AA', '60', '69', 'N', null), ('AAA', '70', '79', 'N', null), ('Gonzo', '80', '999', 'Y', '((60/59.901) ^points) * time * 0.85');
COMMIT;
-- ----------------------------
-- Table structure for `autox_classifications`
-- ----------------------------
DROP TABLE IF EXISTS `autox_classifications`;
CREATE TABLE `autox_classifications` (
`pk` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`class` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`points` int(5) NOT NULL DEFAULT '0',
`car_year` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`car_model` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`serializedcar` varchar(2048) DEFAULT NULL,
`serializedmods` varchar(2048) DEFAULT NULL,
`serializedengine` varchar(2048) DEFAULT NULL,
`BHP` varchar(4) DEFAULT NULL,
`date` datetime NOT NULL,
`active` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`hpclaim` text NOT NULL,
PRIMARY KEY (`pk`)
) ENGINE=MyISAM AUTO_INCREMENT=232 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `autox_close`
-- ----------------------------
DROP TABLE IF EXISTS `autox_close`;
CREATE TABLE `autox_close` (
`pk` int(11) NOT NULL AUTO_INCREMENT,
`close` varchar(128) DEFAULT NULL,
`open` varchar(128) DEFAULT NULL,
`message` varchar(2048) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_close`
-- ----------------------------
BEGIN;
INSERT INTO `autox_close` VALUES ('1', 'Last Wednesday 12:00PM PST', 'Next Monday 12:01AM PST', 'The autocross system is currently not allowing changes until after the next autocross.');
COMMIT;
-- ----------------------------
-- Table structure for `autox_closeoverride`
-- ----------------------------
DROP TABLE IF EXISTS `autox_closeoverride`;
CREATE TABLE `autox_closeoverride` (
`override` varchar(10) DEFAULT NULL,
`message` varchar(2048) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `autox_dates`
-- ----------------------------
DROP TABLE IF EXISTS `autox_dates`;
CREATE TABLE `autox_dates` (
`pk` int(11) NOT NULL AUTO_INCREMENT,
`autoxdate` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`location` varchar(256) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_dates`
-- ----------------------------
BEGIN;
INSERT INTO `autox_dates` VALUES ('6', '2013-05-25', 'Marina Airport'), ('3', '2013-04-20', 'Marina Airport'), ('8', '2013-06-15', 'Marina Airport'), ('9', '2013-07-13', 'Marina Airport'), ('10', '2013-08-10', 'Marina Airport'), ('11', '2013-09-14', 'Marina Airport'), ('12', '2013-10-12', 'Marina Airport'), ('13', '2013-11-02', 'Marina Airport');
COMMIT;
-- ----------------------------
-- Table structure for `autox_engine_levels`
-- ----------------------------
DROP TABLE IF EXISTS `autox_engine_levels`;
CREATE TABLE `autox_engine_levels` (
`lsd` char(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`engine_level` smallint(2) NOT NULL DEFAULT '0',
`class_points` smallint(2) NOT NULL DEFAULT '0',
`percent_from` smallint(3) NOT NULL DEFAULT '0',
`percent_to` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_engine_levels`
-- ----------------------------
BEGIN;
INSERT INTO `autox_engine_levels` VALUES ('N', '1', '1', '1', '3'), ('N', '0', '2', '4', '8'), ('N', '0', '3', '9', '13'), ('N', '0', '4', '14', '20'), ('N', '0', '5', '21', '27'), ('N', '0', '6', '28', '35'), ('N', '0', '7', '36', '44'), ('N', '0', '8', '45', '53'), ('N', '0', '9', '54', '63'), ('N', '0', '10', '64', '74'), ('N', '0', '11', '75', '85'), ('N', '0', '12', '86', '98'), ('N', '0', '13', '99', '111'), ('N', '0', '14', '112', '127'), ('N', '0', '15', '128', '170'), ('N', '0', '16', '171', '288'), ('N', '0', '17', '289', '479'), ('N', '0', '18', '480', '999'), ('N', '1', '1', '1', '4'), ('N', '1', '2', '5', '10'), ('N', '1', '3', '11', '16'), ('N', '1', '4', '17', '23'), ('N', '1', '5', '24', '32'), ('N', '1', '6', '33', '41'), ('N', '1', '7', '42', '51'), ('N', '1', '8', '52', '61'), ('N', '1', '9', '62', '73'), ('N', '1', '10', '74', '85'), ('N', '1', '11', '86', '98'), ('N', '1', '12', '99', '112'), ('N', '1', '13', '113', '167'), ('N', '1', '14', '168', '279'), ('N', '1', '15', '280', '517'), ('N', '1', '16', '518', '627'), ('N', '1', '17', '628', '999'), ('N', '2', '1', '1', '5'), ('N', '2', '2', '6', '11'), ('N', '2', '3', '12', '18'), ('N', '2', '4', '19', '26'), ('N', '2', '5', '27', '35'), ('N', '2', '6', '36', '45'), ('N', '2', '7', '46', '56'), ('N', '2', '8', '57', '65'), ('N', '2', '9', '66', '78'), ('N', '2', '10', '79', '91'), ('N', '2', '11', '92', '107'), ('N', '2', '12', '108', '163'), ('N', '2', '13', '164', '356'), ('N', '2', '14', '357', '569'), ('N', '2', '15', '570', '999'), ('N', '3', '1', '1', '6'), ('N', '3', '2', '7', '12'), ('N', '3', '3', '13', '21'), ('N', '3', '4', '22', '29'), ('N', '3', '5', '30', '38'), ('N', '3', '6', '39', '48'), ('N', '3', '7', '49', '56'), ('N', '3', '8', '57', '69'), ('N', '3', '9', '70', '81'), ('N', '3', '10', '82', '96'), ('N', '3', '11', '97', '134'), ('N', '3', '12', '135', '435'), ('N', '3', '13', '436', '558'), ('N', '3', '14', '559', '999'), ('N', '4', '1', '1', '6'), ('N', '4', '2', '7', '13'), ('N', '4', '3', '14', '22'), ('N', '4', '4', '23', '30'), ('N', '4', '5', '31', '40'), ('N', '4', '6', '41', '50'), ('N', '4', '7', '51', '58'), ('N', '4', '8', '59', '72'), ('N', '4', '9', '73', '86'), ('N', '4', '10', '87', '125'), ('N', '4', '11', '126', '394'), ('N', '4', '12', '395', '520'), ('N', '4', '13', '521', '999'), ('N', '5', '1', '1', '6'), ('N', '5', '2', '7', '14'), ('N', '5', '3', '15', '22'), ('N', '5', '4', '23', '22'), ('N', '5', '5', '23', '30'), ('N', '5', '6', '31', '42'), ('N', '5', '7', '43', '51'), ('N', '5', '8', '52', '60'), ('N', '5', '9', '61', '76'), ('N', '5', '10', '77', '100'), ('N', '5', '11', '101', '286'), ('N', '5', '12', '287', '490'), ('N', '5', '13', '491', '999'), ('N', '6', '1', '1', '6'), ('N', '6', '2', '7', '14'), ('N', '6', '3', '15', '23'), ('N', '6', '4', '24', '32'), ('N', '6', '5', '33', '43'), ('N', '6', '6', '44', '52'), ('N', '6', '7', '53', '65'), ('N', '6', '8', '66', '80'), ('N', '6', '9', '81', '177'), ('N', '6', '10', '178', '400'), ('N', '6', '11', '401', '439'), ('N', '6', '12', '440', '999'), ('N', '7', '1', '1', '6'), ('N', '7', '2', '7', '14'), ('N', '7', '3', '15', '24'), ('N', '7', '4', '25', '34'), ('N', '7', '5', '35', '44'), ('N', '7', '6', '45', '54'), ('N', '7', '7', '55', '70'), ('N', '7', '8', '71', '110'), ('N', '7', '9', '111', '342'), ('N', '7', '10', '343', '416'), ('N', '7', '11', '417', '999'), ('N', '8', '1', '1', '7'), ('N', '8', '2', '8', '21'), ('N', '8', '3', '22', '40'), ('N', '8', '4', '41', '67'), ('N', '8', '5', '68', '111'), ('N', '8', '6', '112', '134'), ('N', '8', '7', '135', '190'), ('N', '8', '8', '191', '268'), ('N', '8', '9', '269', '337'), ('N', '8', '10', '338', '999'), ('N', '9', '1', '1', '8'), ('N', '9', '2', '9', '31'), ('N', '9', '3', '32', '93'), ('N', '9', '4', '94', '157'), ('N', '9', '5', '158', '203'), ('N', '9', '6', '204', '241'), ('N', '9', '7', '242', '281'), ('N', '9', '8', '282', '317'), ('N', '9', '9', '318', '999'), ('Y', '0', '1', '1', '2'), ('Y', '0', '2', '3', '5'), ('Y', '0', '3', '6', '5'), ('Y', '0', '4', '6', '9'), ('Y', '0', '5', '10', '12'), ('Y', '0', '6', '13', '15'), ('Y', '0', '7', '16', '19'), ('Y', '0', '8', '20', '22'), ('Y', '0', '9', '23', '25'), ('Y', '0', '10', '26', '29'), ('Y', '0', '11', '30', '33'), ('Y', '0', '12', '34', '37'), ('Y', '0', '13', '38', '41'), ('Y', '0', '14', '42', '46'), ('Y', '0', '15', '47', '51'), ('Y', '0', '16', '52', '56'), ('Y', '0', '17', '57', '63'), ('Y', '0', '18', '64', '70'), ('Y', '0', '19', '71', '79'), ('Y', '0', '20', '80', '88'), ('Y', '0', '21', '89', '99'), ('Y', '0', '22', '100', '111'), ('Y', '0', '23', '112', '123'), ('Y', '0', '24', '124', '138'), ('Y', '0', '25', '139', '180'), ('Y', '0', '26', '181', '324'), ('Y', '0', '27', '325', '523'), ('Y', '0', '28', '524', '999'), ('Y', '1', '1', '1', '2'), ('Y', '1', '2', '3', '5'), ('Y', '1', '3', '6', '9'), ('Y', '1', '4', '10', '12'), ('Y', '1', '5', '13', '15'), ('Y', '1', '6', '16', '19'), ('Y', '1', '7', '20', '22'), ('Y', '1', '8', '23', '25'), ('Y', '1', '9', '26', '29'), ('Y', '1', '10', '30', '33'), ('Y', '1', '11', '34', '38'), ('Y', '1', '12', '39', '43'), ('Y', '1', '13', '44', '49'), ('Y', '1', '14', '50', '56'), ('Y', '1', '15', '57', '64'), ('Y', '1', '16', '65', '72'), ('Y', '1', '17', '73', '82'), ('Y', '1', '18', '83', '92'), ('Y', '1', '19', '93', '105'), ('Y', '1', '20', '106', '121'), ('Y', '1', '21', '122', '203'), ('Y', '1', '22', '204', '350'), ('Y', '1', '23', '351', '493'), ('Y', '1', '24', '494', '609'), ('Y', '1', '25', '610', '999'), ('Y', '2', '1', '1', '2'), ('Y', '2', '2', '3', '5'), ('Y', '2', '3', '6', '9'), ('Y', '2', '4', '10', '15'), ('Y', '2', '5', '16', '19'), ('Y', '2', '6', '20', '22'), ('Y', '2', '7', '23', '27'), ('Y', '2', '8', '28', '31'), ('Y', '2', '9', '32', '36'), ('Y', '2', '10', '37', '42'), ('Y', '2', '11', '43', '49'), ('Y', '2', '12', '50', '56'), ('Y', '2', '13', '57', '65'), ('Y', '2', '14', '66', '74'), ('Y', '2', '15', '75', '85'), ('Y', '2', '16', '86', '98'), ('Y', '2', '17', '99', '115'), ('Y', '2', '18', '116', '197'), ('Y', '2', '19', '198', '380'), ('Y', '2', '20', '381', '550'), ('Y', '2', '21', '551', '999'), ('Y', '3', '1', '1', '2'), ('Y', '3', '2', '3', '5'), ('Y', '3', '3', '6', '9'), ('Y', '3', '4', '10', '12'), ('Y', '3', '5', '13', '15'), ('Y', '3', '6', '16', '19'), ('Y', '3', '7', '20', '23'), ('Y', '3', '8', '24', '23'), ('Y', '3', '9', '24', '28'), ('Y', '3', '10', '29', '40'), ('Y', '3', '11', '41', '47'), ('Y', '3', '12', '48', '55'), ('Y', '3', '13', '56', '64'), ('Y', '3', '14', '65', '74'), ('Y', '3', '15', '75', '86'), ('Y', '3', '16', '87', '114'), ('Y', '3', '17', '115', '138'), ('Y', '3', '18', '139', '382'), ('Y', '3', '19', '383', '523'), ('Y', '3', '20', '524', '999'), ('Y', '4', '1', '1', '2'), ('Y', '4', '2', '3', '5'), ('Y', '4', '3', '6', '9'), ('Y', '4', '4', '10', '12'), ('Y', '4', '5', '13', '16'), ('Y', '4', '6', '17', '20'), ('Y', '4', '7', '21', '25'), ('Y', '4', '8', '26', '31'), ('Y', '4', '9', '32', '38'), ('Y', '4', '10', '39', '45'), ('Y', '4', '11', '46', '54'), ('Y', '4', '12', '55', '64'), ('Y', '4', '13', '65', '75'), ('Y', '4', '14', '76', '89'), ('Y', '4', '15', '90', '123'), ('Y', '4', '16', '124', '285'), ('Y', '4', '17', '286', '493'), ('Y', '4', '18', '494', '999'), ('Y', '5', '1', '1', '2'), ('Y', '5', '2', '3', '5'), ('Y', '5', '3', '6', '9'), ('Y', '5', '4', '10', '13'), ('Y', '5', '5', '14', '18'), ('Y', '5', '6', '19', '23'), ('Y', '5', '7', '24', '30'), ('Y', '5', '8', '31', '37'), ('Y', '5', '9', '38', '46'), ('Y', '5', '10', '47', '55'), ('Y', '5', '11', '56', '66'), ('Y', '5', '12', '67', '81'), ('Y', '5', '13', '82', '211'), ('Y', '5', '14', '212', '265'), ('Y', '5', '15', '266', '408'), ('Y', '5', '16', '409', '999'), ('Y', '6', '1', '1', '2'), ('Y', '6', '2', '3', '6'), ('Y', '6', '3', '7', '10'), ('Y', '6', '4', '11', '15'), ('Y', '6', '5', '16', '21'), ('Y', '6', '6', '22', '27'), ('Y', '6', '7', '28', '34'), ('Y', '6', '8', '35', '43'), ('Y', '6', '9', '44', '52'), ('Y', '6', '10', '53', '63'), ('Y', '6', '11', '64', '86'), ('Y', '6', '12', '87', '169'), ('Y', '6', '13', '170', '335'), ('Y', '6', '14', '336', '427'), ('Y', '6', '15', '428', '999'), ('Y', '7', '1', '1', '3'), ('Y', '7', '2', '4', '7'), ('Y', '7', '3', '8', '12'), ('Y', '7', '4', '13', '27'), ('Y', '7', '5', '28', '41'), ('Y', '7', '6', '42', '49'), ('Y', '7', '7', '50', '58'), ('Y', '7', '8', '59', '69'), ('Y', '7', '9', '70', '131'), ('Y', '7', '10', '132', '272'), ('Y', '7', '11', '273', '400'), ('Y', '7', '12', '401', '999'), ('Y', '8', '1', '1', '4'), ('Y', '8', '2', '5', '11'), ('Y', '8', '3', '12', '25'), ('Y', '8', '4', '26', '58'), ('Y', '8', '5', '59', '89'), ('Y', '8', '6', '90', '129'), ('Y', '8', '7', '130', '176'), ('Y', '8', '8', '177', '236'), ('Y', '8', '9', '237', '318'), ('Y', '8', '10', '319', '999'), ('Y', '9', '1', '1', '7'), ('Y', '9', '2', '8', '19'), ('Y', '9', '3', '20', '67'), ('Y', '9', '4', '68', '147'), ('Y', '9', '5', '148', '186'), ('Y', '9', '6', '187', '219'), ('Y', '9', '7', '220', '264'), ('Y', '9', '8', '265', '290'), ('Y', '9', '9', '291', '999'), ('N', '0', '0', '0', '0'), ('Y', '0', '0', '0', '0'), ('N', '1', '0', '0', '0'), ('Y', '1', '0', '0', '0'), ('N', '2', '0', '0', '0'), ('Y', '2', '0', '0', '0'), ('N', '3', '0', '0', '0'), ('Y', '3', '0', '0', '0'), ('N', '4', '0', '0', '0'), ('Y', '4', '0', '0', '0'), ('N', '5', '0', '0', '0'), ('Y', '5', '0', '0', '0'), ('N', '6', '0', '0', '0'), ('Y', '6', '0', '0', '0'), ('N', '7', '0', '0', '0'), ('Y', '7', '0', '0', '0'), ('N', '8', '0', '0', '0'), ('Y', '8', '0', '0', '0'), ('N', '9', '0', '0', '0'), ('Y', '9', '0', '0', '0');
COMMIT;
-- ----------------------------
-- Table structure for `autox_mod_categories`
-- ----------------------------
DROP TABLE IF EXISTS `autox_mod_categories`;
CREATE TABLE `autox_mod_categories` (
`category_id` int(11) NOT NULL,
`category_name` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`mandatory_selection` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`default_mod_id` int(11) DEFAULT NULL,
`increase_amount_for mod_points` decimal(4,2) DEFAULT NULL,
`description` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`notes` varchar(1000) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`multiselect` varchar(1) DEFAULT NULL,
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_mod_categories`
-- ----------------------------
BEGIN;
INSERT INTO `autox_mod_categories` VALUES ('1', 'Tires', 'Y', '4', null, 'Tires selection', '<p>Note that r-comps are defined as having tread wear less than 110. Don\'t know which?</p>\n<ul>\n<li>All-season tires come standard on most non-M cars without the sports or performance package. They\'ll clearly say \'M+S\' on the sidewall\n<li>Summer tires come standard on most M cars and cars with the sports or performance package\n<li>Examples of cross-tread R comp tires: Michelin Pilot Sport Cup (not Pilot Sport or Pilot Sport PS2), Kumho Victoracer V700/Ecsta V700, Toyo RA-1\n<li>Examples of a grooved R comp tires: Kumho V710, Hoosier A6/R6, Hoosier AxS0x/SxSOx (A3S04, etc) line\n<li>Examples of non-DOT R comp tires: Hoosier R35/R45/R55/R60\n</ul>\n', null), ('2', 'Gears', 'N', null, null, 'Differential gearing modifications', null, null), ('3', 'Drivetrain', 'N', null, null, 'Drivetrain modifications', null, null), ('4', 'Transmisson', 'Y', '8', null, 'Transmission selection', null, null), ('5', 'Weight Reduction', 'N', null, null, 'Weight reduction modifications', null, 'Y'), ('6', 'Front Camber', 'N', '19', null, 'Front camber modifications', 'Note that this applies to things ADDED to the car that increase camber (camber plates, shimming the struts, swap strut hats, etc) and does not include the additional camber gained from alignments or lowering the car', null), ('7', 'Rear Camber', 'N', null, null, 'Rear camber modifications', null, null), ('8', 'Sway Bars', 'N', null, null, 'Sway bar modifications', 'BMW active rollbars option is treated the same as having aftermarket sway bars.', 'Y'), ('9', 'Shocks', 'Y', '25', null, 'Shocks selection', 'Note that a stock BMW suspension means having BMW shocks and/or BMW springs <p>If you have a sport pkg, M or JCW car, we have selected your default suspension type</p>', null), ('10', 'Springs', 'Y', '30', null, 'Springs selection', 'Note that a stock BMW suspension means having BMW shocks and/or BMW springs <p>If you have a sport pkg, M or JCW car, we have selected your default suspension type</p>', null), ('11', 'Front Wheels', 'N', null, '0.50', 'Front wheel change in width', '', null), ('12', 'Rear Wheels', 'N', null, '0.50', 'Rear wheel change in width', '', null), ('13', 'LSD', 'N', null, null, 'LSD modification', 'If you car does not come standard with a LSD, LSD points will be assigned based on your car. <p>If your car came with an LSD from the factory, do not select this.</p>', null);
COMMIT;
-- ----------------------------
-- Table structure for `autox_modifications`
-- ----------------------------
DROP TABLE IF EXISTS `autox_modifications`;
CREATE TABLE `autox_modifications` (
`mod_id` int(11) NOT NULL,
`default` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
`category_id` int(11) NOT NULL,
`mod_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`mod_points` int(11) DEFAULT NULL,
`suspension_code` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_modifications`
-- ----------------------------
BEGIN;
INSERT INTO `autox_modifications` VALUES ('1', 'N', '1', 'non-DOT legal tires', '30', null), ('2', 'N', '1', 'grooved R-comps', '22', null), ('3', 'N', '1', 'cross-tread R-comps', '10', null), ('4', 'Y', '1', 'summer tires', '0', null), ('5', 'N', '1', 'all-season (M+S)', '-10', null), ('6', 'N', '2', 'differential gear change', '2', null), ('7', 'N', '3', 'lightweight flywheel', '1', null), ('8', 'Y', '4', 'manual, SMG, or DCT', '0', null), ('9', 'N', '4', 'steptronic or CVT', '-1', null), ('10', 'N', '4', 'fully automatic (no steptronic)', '-3', null), ('11', 'N', '5', 'aftermarket sport seats ', '1', null), ('12', 'N', '5', 'rear seat removal and/or removing trunk lining ', '1', null), ('13', 'N', '5', 'stripping of interior (dash, glove box, etc) ', '1', null), ('14', 'N', '5', 'lightweight hood and/or body panels ', '1', null), ('15', 'N', '5', 'AC removal ', '1', null), ('16', 'N', '5', 'airbag removal (other than steering wheel airbag) ', '1', null), ('17', 'N', '5', 'interior carpeting and/or sound deadening removal ', '2', null), ('18', 'N', '5', 'additional unclassified weight reduction ', '2', null), ('20', 'N', '6', 'increased front camber (3 series e30 and prior, 5 series e28 and prior)', '4', null), ('21', 'N', '6', 'increased front camber (all other)', '5', null), ('22', 'N', '7', 'increased rear camber (3 series e30 and prior, 5 series e28 and prior)', '1', null), ('23', 'N', '8', 'front sway bar', '2', null), ('24', 'N', '8', 'rear sway bar (without adjustable perch springs)', '2', null), ('25', 'N', '9', 'BMW base shocks', '0', 'B'), ('26', 'N', '9', 'BMW sport or performance package shocks', '1', 'S'), ('27', 'N', '9', 'BMW M suspension (includes competition package) shocks', '2', 'M'), ('28', 'N', '9', 'non-adjustable or single-adjustable shocks', '3', null), ('29', 'N', '9', 'double-adjustable or triple-adjustable shocks', '5', null), ('30', 'N', '10', 'BMW base springs', '0', 'B'), ('31', 'N', '10', 'BMW sport or performance package springs', '1', 'S'), ('32', 'N', '10', 'BMW M suspension (includes competition package) springs', '2', 'M'), ('33', 'N', '10', 'springs (without adjustable perches)', '4', null), ('34', 'N', '10', 'springs (with adjustable perches)', '9', null), ('35', 'N', '10', 'springs along with major suspension changes (relocate mounting points, custom control arms, etc)', '20', null), ('36', 'N', '11', 'Increased front wheel width .5\"', '1', null), ('37', 'N', '12', 'Increased rear wheel width .5\"', '1', null), ('38', 'N', '13', 'installed a LSD in a car model that does not have a LSD as standard', '0', null), ('39', 'N', '11', 'Increased front wheel width 1\"', '2', null), ('40', 'N', '11', 'Increased front wheel width 1.5\"', '3', null), ('41', 'N', '11', 'Increased front wheel width 2.0\"', '4', null), ('42', 'N', '12', 'Increased rear wheel width 1\"', '2', null), ('43', 'N', '12', 'Increased rear wheel width 1.5\"', '3', null), ('44', 'N', '12', 'Increased rear wheel width 2.0\"', '4', null);
COMMIT;
-- ----------------------------
-- Table structure for `autox_modlist`
-- ----------------------------
DROP TABLE IF EXISTS `autox_modlist`;
CREATE TABLE `autox_modlist` (
`modnumber` int(3) NOT NULL DEFAULT '0',
`modname` varchar(128) NOT NULL DEFAULT '',
`percent` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_modlist`
-- ----------------------------
BEGIN;
INSERT INTO `autox_modlist` VALUES ('0', 'Big bore throttle body', '1'), ('2', 'Exhaust', '2'), ('3', 'Headers', '2'), ('4', 'Manifold', '2'), ('5', 'Removed cats', '2'), ('6', 'Underdrive crank pulley', '2'), ('7', 'Injectors', '3'), ('8', 'Air Intake', '4'), ('9', 'Underdrive pullies', '5'), ('10', 'Valves/Head work', '6'), ('11', 'Distributor', '6'), ('12', 'Software (ODB2 naturally aspirated)', '7'), ('13', 'Chip (ODB1 naturally aspirated)', '9'), ('14', 'Carbs', '10'), ('15', 'Fuel injection in place of carbs', '10'), ('16', 'Cams', '11'), ('17', 'Supercharger pulley reduction', '15'), ('18', 'Piston/bore or stroke or compression increase', '20'), ('19', 'Chip/Software (turbo engine)', '30'), ('20', 'Supercharger (not twinscrew)', '40'), ('1', 'Turbo or twin-screw supercharger', '50');
COMMIT;
-- ----------------------------
-- Table structure for `autox_mods_engine`
-- ----------------------------
DROP TABLE IF EXISTS `autox_mods_engine`;
CREATE TABLE `autox_mods_engine` (
`engine_mod_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
`engine_mod_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`percent` int(2) NOT NULL,
PRIMARY KEY (`engine_mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_mods_engine`
-- ----------------------------
BEGIN;
INSERT INTO `autox_mods_engine` VALUES ('1', '14', 'Big bore throttle body', '1'), ('2', '14', 'Exhaust ', '2'), ('3', '14', 'Headers ', '2'), ('4', '14', 'Manifold ', '2'), ('5', '14', 'Removed cats ', '2'), ('6', '14', 'Underdrive crank pulley ', '2'), ('7', '14', 'Injectors ', '3'), ('8', '14', 'Air Intake ', '4'), ('9', '14', 'Underdrive pullies ', '5'), ('10', '14', 'Valves/Head work ', '6'), ('11', '14', 'Distributor ', '6'), ('12', '14', 'Software (ODB2 naturally aspirated) ', '7'), ('13', '14', 'Chip (ODB1 naturally aspirated) ', '9'), ('14', '14', 'Carbs ', '10'), ('15', '14', 'Fuel injection in place of carbs ', '10'), ('16', '14', 'Cams', '11'), ('17', '14', 'Supercharger pulley reduction ', '15'), ('18', '14', 'Piston/bore or stroke or compression increase ', '20'), ('19', '14', 'Chip/Software (turbo engine) ', '30'), ('20', '14', 'Supercharger (not twinscrew) ', '40'), ('21', '14', 'Turbo or twin-screw supercharger ', '50');
COMMIT;
-- ----------------------------
-- Table structure for `autox_numbers`
-- ----------------------------
DROP TABLE IF EXISTS `autox_numbers`;
CREATE TABLE `autox_numbers` (
`pk` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(64) DEFAULT NULL,
`drivernumber` int(4) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_numbers`
-- ----------------------------
-- ----------------------------
-- Table structure for `autox_optional_car_wheels`
-- ----------------------------
DROP TABLE IF EXISTS `autox_optional_car_wheels`;
CREATE TABLE `autox_optional_car_wheels` (
`wheel_id` int(11) NOT NULL,
`car_id` int(11) NOT NULL,
`wheel_description` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`package_code` varchar(3) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`rear_wheel_diameter` decimal(3,1) NOT NULL,
`rear_wheel_width` decimal(3,1) NOT NULL,
`rear_tire_width` smallint(5) NOT NULL,
`rear_tire_profile` smallint(5) NOT NULL,
`front_wheel_diameter` decimal(3,1) NOT NULL,
`front_wheel_width` decimal(2,1) NOT NULL,
PRIMARY KEY (`wheel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_optional_car_wheels`
-- ----------------------------
BEGIN;
INSERT INTO `autox_optional_car_wheels` VALUES ('1', '137', 'Sport package', 'ZSP', '15.0', '7.0', '205', '60', '15.0', '7.0'), ('2', '138', 'Sport package', 'ZSP', '16.0', '7.0', '225', '50', '16.0', '7.0'), ('3', '145', 'Sport package', 'ZSP', '15.0', '7.0', '205', '60', '15.0', '7.0'), ('4', '146', 'Active', 'ZSP', '15.0', '7.0', '205', '60', '15.0', '7.0'), ('5', '146', 'Sport', 'ZSP', '16.0', '7.0', '225', '50', '16.0', '7.0'), ('6', '159', 'Sport', '', '18.0', '9.5', '255', '45', '18.0', '8.0'), ('7', '164', 'Sport package', 'ZSP', '17.0', '8.0', '235', '45', '17.0', '8.0'), ('8', '165', 'Sport package', 'ZSP', '17.0', '9.0', '255', '40', '17.0', '9.0'), ('9', '166', 'Sport package', 'ZSP', '17.0', '9.0', '255', '40', '17.0', '9.0'), ('10', '167', 'Sport package', 'ZSP', '17.0', '8.0', '235', '45', '17.0', '8.0'), ('11', '168', 'Sport package', 'ZSP', '17.0', '8.0', '235', '45', '17.0', '8.0'), ('12', '169', 'Sport package', 'ZSP', '17.0', '8.0', '235', '45', '17.0', '8.0'), ('13', '170', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('14', '171', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('15', '172', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('16', '173', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('17', '174', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('18', '175', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('19', '176', 'Sport', '', '17.0', '7.0', '205', '50', '17.0', '7.0'), ('20', '177', 'Sport wheels', '', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('21', '178', 'Sport wheels', '', '17.0', '7.0', '225', '45', '17.0', '7.0'), ('22', '179', 'Sport package', 'ZSP', '17.0', '8.5', '245', '40', '17.0', '7.5'), ('23', '180', 'Sport package', 'ZSP', '17.0', '7.0', '225', '45', '17.0', '7.0'), ('24', '181', 'Sport', '', '17.0', '7.0', '225', '45', '17.0', '7.0'), ('25', '183', 'Sport package', 'ZSP', '17.0', '8.5', '245', '40', '17.0', '7.5'), ('26', '184', 'Sport package', 'ZSP', '17.0', '8.5', '245', '40', '17.0', '7.5'), ('27', '185', '19in wheels', '', '19.0', '9.5', '255', '35', '19.0', '8.0'), ('28', '185', 'Competition Package', 'ZCP', '19.0', '9.5', '255', '35', '19.0', '8.0'), ('29', '186', '19in wheels', '', '19.0', '9.5', '255', '35', '19.0', '8.0'), ('30', '190', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('31', '192', 'Sport package', 'ZSP', '17.0', '8.0', '245', '45', '17.0', '8.0'), ('32', '193', 'Sport package', 'ZSP', '18.0', '8.0', '245', '40', '18.0', '8.0'), ('33', '198', 'Sport package', 'ZSP', '18.0', '8.0', '245', '40', '18.0', '8.0'), ('34', '199', 'Sport package', 'ZSP', '18.0', '8.0', '245', '40', '18.0', '8.0'), ('35', '202', 'Sport package', 'ZSP', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('36', '203', 'Sport package', 'ZSP', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('37', '204', 'Sport package', 'ZSP', '18.0', '9.0', '275', '35', '18.0', '8.0'), ('38', '205', 'Sport package', 'ZSP', '18.0', '9.0', '275', '35', '18.0', '8.0'), ('39', '206', 'Sport package', 'ZSP', '18.0', '8.0', '245', '35', '18.0', '8.0'), ('40', '207', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('41', '208', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('42', '210', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('43', '212', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('44', '213', 'Sport package', 'ZSP', '19.0', '10.0', '275', '40', '19.0', '9.0'), ('45', '214', 'Sport package', 'ZSP', '19.0', '10.0', '275', '40', '19.0', '9.0'), ('46', '216', 'Sport package', 'ZSP', '19.0', '10.0', '275', '40', '19.0', '9.0'), ('47', '217', 'Sport package', 'ZSP', '19.0', '10.0', '275', '40', '19.0', '9.0'), ('48', '221', 'Sport package', 'ZSP', '17.0', '7.5', '225', '45', '17.0', '7.0'), ('49', '224', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('50', '225', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('51', '226', 'Sport package', 'ZSP', '17.0', '8.5', '245', '40', '17.0', '8.0'), ('52', '227', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('53', '229', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('54', '231', 'Sport package', 'ZSP', '18.0', '8.5', '245', '35', '18.0', '7.5'), ('55', '232', 'Sport package', 'ZSP', '17.0', '7.5', '225', '45', '17.0', '7.0'), ('56', '233', 'Sport package', 'ZSP', '18.0', '8.5', '245', '35', '18.0', '7.5'), ('57', '234', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('58', '235', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('59', '236', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('60', '237', 'Sport Package w/18in. Wheels', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('61', '237', 'Sport Package w/19in. Wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('62', '237', '18in. Wheels', '', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('63', '237', '19in. Wheels', '', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('64', '238', '19in. Wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('65', '239', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('66', '240', 'Sport package', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('67', '241', 'Sport package', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('68', '242', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('69', '243', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('70', '244', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('71', '244', 'Sport Package w/19in. wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('72', '245', 'Sport package', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('73', '246', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('74', '246', 'Sport package w/Tire Upgrade', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('75', '247', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('76', '249', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('77', '250', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('78', '250', 'Sport package w/19in. wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('79', '251', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('80', '252', 'Sport package', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('81', '253', 'Sport package', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('82', '254', 'Sport package', 'ZSP', '17.0', '8.0', '225', '45', '17.0', '8.0'), ('83', '254', 'Sport package w/Tire Upgrade', 'ZSP', '17.0', '8.5', '255', '40', '17.0', '8.0'), ('84', '255', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('85', '255', 'Sport package w/19in. wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('86', '256', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('87', '257', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('88', '258', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('89', '260', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('90', '260', 'Sport package w/19in. wheels', 'ZSP', '19.0', '9.0', '255', '30', '19.0', '8.0'), ('91', '262', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('92', '263', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('93', '264', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('94', '266', 'Sport package', 'ZSP', '18.0', '8.5', '255', '35', '18.0', '8.0'), ('95', '268', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('96', '269', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.0'), ('97', '270', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('98', '270', '19in. wheels', '', '19.0', '8.5', '245', '45', '19.0', '8.5'), ('99', '271', '20in. Wheels', '', '20.0', '10.0', '275', '40', '20.0', '8.5'), ('100', '272', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.0'), ('101', '273', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.0'), ('102', '275', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('103', '275', '19in. wheels', '', '19.0', '8.5', '245', '45', '19.0', '8.5'), ('104', '276', '20in. Wheels', '', '20.0', '10.0', '275', '40', '20.0', '8.5'), ('105', '277', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('106', '278', 'Sport package', 'ZSP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('107', '279', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '18.0', '9.0'), ('108', '280', 'Sport package', 'ZSP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('109', '281', 'M-Sport Package', 'ZMP', '18.0', '9.0', '275', '35', '18.0', '8.0'), ('110', '281', 'Sport package', 'ZSP', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('111', '282', 'M-Sport Package', 'ZMP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('112', '282', 'Sport package', 'ZSP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('113', '283', 'Sport package', 'ZSP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('114', '284', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('115', '285', 'Sport package', 'ZSP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('116', '287', 'M-Sport Package', 'ZMP', '18.0', '9.0', '275', '40', '18.0', '8.0'), ('117', '287', 'Sport package', 'ZSP', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('118', '288', 'Sport package', 'ZSP', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('119', '289', '19in. wheels', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('120', '289', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('121', '290', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('122', '290', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('123', '291', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('124', '292', '19in. wheels', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('125', '292', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('126', '293', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('127', '293', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('128', '294', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('129', '295', '18in wheels', '', '18.0', '8.0', '225', '45', '18.0', '8.0'), ('130', '296', '19in wheels', '', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('131', '297', 'Sport wheels', '', '16.0', '6.5', '195', '55', '16.0', '6.5'), ('132', '298', 'Sport wheels', '', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('133', '299', 'Sport wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('134', '301', 'Sport package', 'ZSP', '16.0', '6.5', '195', '55', '16.0', '6.5'), ('135', '302', 'Sport wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('136', '304', 'Sport wheels', '', '16.0', '6.5', '195', '55', '16.0', '6.5'), ('137', '305', 'Sport wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('138', '307', 'Sport wheels', '', '16.0', '6.5', '195', '55', '16.0', '6.5'), ('139', '308', 'Sport wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('140', '310', 'Sport wheels', '', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('141', '312', 'Sport wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('142', '313', '16in wheels', '', '16.0', '6.5', '195', '55', '16.0', '6.5'), ('143', '313', '17in wheels', '', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('144', '315', '17in wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('145', '316', '17in wheels', '', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('146', '318', '17in wheels', 'ZSP', '17.0', '7.0', '205', '45', '17.0', '7.0'), ('147', '319', '18in. wheels', 'ZSP', '18.0', '7.5', '225', '45', '7.5', '7.5'), ('148', '320', '18in. wheels', 'ZSP', '18.0', '7.5', '225', '45', '7.5', '7.5'), ('149', '321', '18in. wheels', '', '18.0', '7.5', '225', '45', '7.5', '7.5'), ('150', '232', 'Base 17in wheels', null, '17.0', '7.0', '205', '50', '17.0', '7.0'), ('151', '327', '18in wheels', '', '18.0', '8.0', '225', '45', '18.0', '8.0'), ('152', '328', '19in wheels', '', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('153', '296', 'M Sport 19in wheels', 'S', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('154', '328', 'M Sport 19in wheels', 'S', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('155', '296', 'M Sport 18in wheels', 'S', '18.0', '8.5', '255', '40', '18.0', '8.0'), ('156', '328', 'M Sport 18in wheels', 'S', '18.0', '8.5', '255', '40', '18.0', '8.0'), ('157', '329', '19in wheels', '', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('158', '329', 'M Sport 19in wheels', 'S', '19.0', '8.5', '255', '35', '19.0', '8.0'), ('159', '329', 'M Sport 18in wheels', 'S', '18.0', '8.5', '255', '40', '18.0', '8.0'), ('160', '282', '19in wheels', '', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('161', '283', '19in wheels', '', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('162', '284', '19in wheels', '', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('163', '285', '19in wheels', '', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('164', '330', '18in wheels', '', '18.0', '8.0', '245', '45', '18.0', '8.0'), ('165', '277', '19in wheels', '', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('166', '277', '20in M Sport package', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('167', '278', '20in M Sport package', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('168', '279', '20in M Sport package', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('169', '280', '20in M Sport package', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('170', '278', '19in wheels', '', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('171', '279', '19in wheels', '', '19.0', '9.5', '275', '40', '18.0', '9.0'), ('172', '280', '19in wheels', '', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('173', '291', '19in M Sport', 'ZMP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('174', '294', '19in M Sport', 'ZMP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('175', '334', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('176', '334', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('177', '335', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('178', '335', '19in M Sport', 'ZMP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('179', '336', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('180', '336', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('181', '337', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('182', '337', '19in M Sport', 'ZMP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('183', '331', '19in. wheels', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('184', '331', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('185', '332', 'Sport package', 'ZSP', '19.0', '9.0', '275', '35', '19.0', '8.5'), ('186', '332', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('187', '333', '20in. wheels', 'ZSP', '20.0', '9.0', '275', '30', '19.0', '8.5'), ('188', '333', '19in M Sport', 'ZMP', '19.0', '8.5', '245', '40', '19.0', '8.5'), ('189', '275', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('190', '338', '19in. wheels', '', '19.0', '8.5', '245', '45', '19.0', '8.5'), ('191', '338', 'Sport package', 'ZSP', '19.0', '8.5', '245', '45', '19.0', '8.5'), ('192', '338', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('193', '270', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('194', '274', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('195', '274', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('196', '339', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('197', '340', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('198', '341', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('199', '342', 'Sport package', 'ZSP', '19.0', '9.5', '275', '40', '19.0', '8.5'), ('200', '339', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('201', '340', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('202', '341', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('203', '342', '20in M Sport', 'ZMP', '20.0', '10.0', '275', '35', '20.0', '8.5'), ('204', '343', '18in wheels', null, '18.0', '7.0', '225', '45', '18.0', '7.5'), ('205', '343', '19in wheels', null, '19.0', '7.5', '245', '40', '19.0', '7.5'), ('206', '286', '17in wheels', null, '17.0', '7.0', '205', '50', '17.0', '7.0');
COMMIT;
-- ----------------------------
-- Table structure for `autox_packages`
-- ----------------------------
DROP TABLE IF EXISTS `autox_packages`;
CREATE TABLE `autox_packages` (
`package_id` int(11) NOT NULL,
`package_name` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`package_code` varchar(3) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`suspension_code` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `autox_packages`
-- ----------------------------
BEGIN;
INSERT INTO `autox_packages` VALUES ('1', 'Sport', 'ZSP', 'S'), ('2', 'M-Sport', 'ZMP', 'S'), ('3', 'Performance', 'ZHP', 'S'), ('4', 'Competition (M-car only)', 'ZCP', 'M'), ('5', 'John Cooper Works (MINI)', 'JCW', 'M');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;