BEGIN TRANSACTION; CREATE TABLE `vehicle_model_parts` ( `modelid` INTEGER NOT NULL, `parts` INTEGER NOT NULL, PRIMARY KEY(modelid) ); INSERT INTO `vehicle_model_parts` (modelid,parts) VALUES (400,269), (401,511), (402,260), (403,260), (404,365), (405,325), (407,256), (408,260), (409,260), (410,381), (411,260), (412,260), (413,260), (414,261), (415,357), (416,261), (418,341), (419,261), (420,327), (421,325), (422,301), (423,261), (424,260), (426,343), (427,261), (428,261), (429,260), (431,260), (432,256), (433,260), (434,260), (436,381), (437,260), (438,261), (439,492), (440,261), (441,260), (442,260), (443,256), (445,261), (451,260), (455,260), (456,261), (457,260), (458,493), (459,260), (466,261), (467,261), (470,260), (474,261), (475,261), (477,309), (478,271), (479,261), (480,261), (482,261), (483,261), (485,260), (486,256), (489,351), (490,343), (491,485), (492,343), (494,260), (495,261), (496,511), (498,261), (499,261), (500,269), (502,260), (503,260), (504,261), (505,351), (506,261), (507,261), (508,261), (514,260), (515,260), (516,359), (517,485), (518,511), (524,256), (525,256), (526,261), (527,373), (528,260), (529,375), (530,256), (531,256), (532,260), (533,260), (540,511), (541,260), (542,453), (543,372), (544,260), (545,260), (546,495), (547,453), (549,487), (550,479), (551,343), (552,261), (554,261), (555,260), (566,261), (568,260), (571,260), (572,260), (574,260), (578,260), (579,341), (580,373), (582,261), (583,260), (585,509), (587,327), (588,260), (589,511), (594,260), (596,261), (597,261), (598,261), (599,343), (600,319), (601,256), (602,260), (603,509), (604,261), (605,373), (609,261); CREATE TABLE `vehicle_components` ( `componentid` INTEGER NOT NULL, `part` TEXT NOT NULL, `type` TEXT NOT NULL, `cars` INTEGER NOT NULL, PRIMARY KEY(componentid) ); INSERT INTO `vehicle_components` (componentid,part,type,cars) VALUES (1000,'Spoilers','Pro',0), (1001,'Spoilers','Win',0), (1002,'Spoilers','Drag',0), (1003,'Spoilers','Alpha',0), (1004,'Hood','Champ Scoop',0), (1005,'Hood','Fury Scoop',0), (1006,'Roof','Roof Scoop',0), (1007,'Side Skirts','Sideskirt',0), (1011,'Hood','Race Scoop',0), (1012,'Hood','Worx Scoop',0), (1013,'Lights','Round Fog',0), (1014,'Spoilers','Champ',0), (1015,'Spoilers','Race',0), (1016,'Spoilers','Worx',0), (1018,'Exhausts','Upswept',0), (1019,'Exhausts','Twin',0), (1020,'Exhausts','Large',0), (1021,'Exhausts','Medium',0), (1022,'Exhausts','Small',0), (1023,'Spoilers','Fury',0), (1024,'Lights','Square Fog',0), (1025,'Wheels','Offroad',0), (1027,'Side Skirts','Alien',560), (1028,'Exhausts','Alien',560), (1029,'Exhausts','X-Flow',560), (1030,'Side Skirts','X-Flow',560), (1032,'Roof','Alien Roof Vent',560), (1033,'Roof','X-Flow Roof Vent',560), (1034,'Exhausts','Alien',562), (1035,'Roof','X-Flow Roof Vent',562), (1037,'Exhausts','X-Flow',562), (1038,'Roof','Alien Roof Vent',562), (1039,'Side Skirts','X-Flow',562), (1040,'Side Skirts','Alien',562), (1043,'Exhausts','Slamin',575), (1044,'Exhausts','Chrome',575), (1045,'Exhausts','X-Flow',565), (1046,'Exhausts','Alien',565), (1049,'Spoilers','Alien',565), (1050,'Spoilers','X-Flow',565), (1051,'Side Skirts','Alien',565), (1052,'Side Skirts','X-Flow',565), (1053,'Roof','X-Flow',565), (1054,'Roof','Alien',565), (1055,'Roof','Alien',561), (1058,'Spoilers','Alien',561), (1059,'Exhausts','X-Flow',561), (1060,'Spoilers','X-Flow',561), (1061,'Roof','X-Flow',561), (1062,'Side Skirts','Alien',561), (1063,'Side Skirts','X-Flow',561), (1064,'Exhausts','Alien',561), (1065,'Exhausts','Alien',559), (1066,'Exhausts','X-Flow',559), (1067,'Roof','Alien',559), (1068,'Roof','X-Flow',559), (1071,'Side Skirts','Alien',559), (1072,'Side Skirts','X-Flow',559), (1073,'Wheels','Shadow',-1), (1074,'Wheels','Mega',-1), (1075,'Wheels','Rimshine',-1), (1076,'Wheels','Wires',-1), (1077,'Wheels','Classic',-1), (1078,'Wheels','Twist',-1), (1079,'Wheels','Cutter',-1), (1080,'Wheels','Switch',-1), (1081,'Wheels','Grove',-1), (1082,'Wheels','Import',-1), (1083,'Wheels','Dollar',-1), (1084,'Wheels','Trance',-1), (1085,'Wheels','Atomic',-1), (1087,'Hydraulics','Hydraulics',-1), (1088,'Roof','Alien',558), (1089,'Exhausts','X-Flow',558), (1091,'Roof','X-Flow',558), (1092,'Exhausts','Alien',558), (1094,'Side Skirts','Alien',558), (1096,'Wheels','Ahab',-1), (1097,'Wheels','Virtual',-1), (1098,'Wheels','Access',-1), (1099,'Side Skirts','Chrome',575), (1100,'Misc','Chrome Grill',534), (1101,'Side Skirts','Chrome Flames',534), (1102,'Side Skirts','Chrome Strip',567), (1103,'Roof','Covertible',536), (1104,'Exhausts','Chrome',536), (1105,'Exhausts','Slamin',536), (1107,'Side Skirts','Chrome Strip',536), (1109,'Rear Bullbars','Chrome',535), (1110,'Rear Bullbars','Slamin',535), (1113,'Exhausts','Chrome',535), (1114,'Exhausts','Slamin',535), (1115,'Front Bullbars','Chrome',535), (1116,'Front Bullbars','Slamin',535), (1117,'Front Bumper','Chrome',535), (1120,'Side Skirts','Chrome Trim',535), (1121,'Side Skirts','Wheelcovers',535), (1123,'Misc','Bullbar Chrome Bars',534), (1124,'Side Skirts','Chrome Arches',534), (1125,'Misc','Bullbar Chrome Lights',534), (1126,'Exhausts','Chrome',534), (1127,'Exhausts','Slamin',534), (1128,'Roof','Vinyl Hardtop',536), (1129,'Exhausts','Chrome',567), (1130,'Roof','Hardtop',567), (1131,'Roof','Softtop',567), (1132,'Exhausts','Slamin',567), (1135,'Exhausts','Slamin',576), (1136,'Exhausts','Chrome',576), (1137,'Side Skirts','Chrome Strip',576), (1138,'Spoilers','Alien',560), (1139,'Spoilers','X-Flow',560), (1140,'Rear Bumper','X-Flow',560), (1141,'Rear Bumper','Alien',560), (1143,'Vents','Oval Vents',0), (1145,'Vents','Square Vents',0), (1146,'Spoilers','X-Flow',562), (1147,'Spoilers','Alien',562), (1148,'Rear Bumper','X-Flow',562), (1149,'Rear Bumper','Alien',562), (1150,'Rear Bumper','Alien',565), (1151,'Rear Bumper','X-Flow',565), (1152,'Front Bumper','X-Flow',565), (1153,'Front Bumper','Alien',565), (1154,'Rear Bumper','Alien',561), (1155,'Front Bumper','Alien',561), (1156,'Rear Bumper','X-Flow',561), (1157,'Front Bumper','X-Flow',561), (1158,'Spoilers','X-Flow',559), (1159,'Rear Bumper','Alien',559), (1160,'Front Bumper','Alien',559), (1161,'Rear Bumper','X-Flow',559), (1162,'Spoilers','Alien',559), (1163,'Spoilers','X-Flow',558), (1164,'Spoilers','Alien',558), (1165,'Front Bumper','X-Flow',558), (1166,'Front Bumper','Alien',558), (1167,'Rear Bumper','X-Flow',558), (1168,'Rear Bumper','Alien',558), (1169,'Front Bumper','Alien',560), (1170,'Front Bumper','X-Flow',560), (1171,'Front Bumper','Alien',562), (1172,'Front Bumper','X-Flow',562), (1173,'Front Bumper','X-Flow',559), (1174,'Front Bumper','Chrome',575), (1175,'Rear Bumper','Slamin',575), (1176,'Front Bumper','Chrome',575), (1177,'Rear Bumper','Slamin',575), (1178,'Rear Bumper','Slamin',534), (1179,'Front Bumper','Chrome',534), (1180,'Rear Bumper','Chrome',534), (1181,'Front Bumper','Slamin',536), (1182,'Front Bumper','Chrome',536), (1183,'Rear Bumper','Slamin',536), (1184,'Rear Bumper','Chrome',536), (1185,'Front Bumper','Slamin',534), (1186,'Rear Bumper','Slamin',567), (1187,'Rear Bumper','Chrome',567), (1188,'Front Bumper','Slamin',567), (1189,'Front Bumper','Chrome',567), (1190,'Front Bumper','Slamin',576), (1191,'Front Bumper','Chrome',576), (1192,'Rear Bumper','Chrome',576), (1193,'Rear Bumper','Slamin',576); CREATE INDEX type ON vehicle_components (type); CREATE INDEX part ON vehicle_components (part); CREATE INDEX cars ON vehicle_components (cars); COMMIT;