DROP TABLE IF EXISTS `carsbcolor`;
CREATE TABLE `carsbcolor`(`color` VARCHAR(50) ,`id` INT AUTO_INCREMENT,`picture` LONGBLOB ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carscars`;
CREATE TABLE `carscars`(`category` VARCHAR(50) ,`color` VARCHAR(50) ,`Date Listed` DATE ,`descr` LONGTEXT ,`EPACity` VARCHAR(50) ,`EPAHighway` VARCHAR(50) ,`features` LONGTEXT ,`Horsepower` INT ,`id` INT AUTO_INCREMENT,`Make` VARCHAR(50) ,`Model` VARCHAR(50) ,`Phone #` VARCHAR(50) ,`Picture` LONGBLOB ,`Price` INT ,`UserID` VARCHAR(50) ,`YearOfMake` INT ,`zipcode` INT ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carsform`;
CREATE TABLE `carsform`(`car` VARCHAR(50) ,`city` VARCHAR(50) ,`comments` LONGTEXT ,`email` VARCHAR(50) ,`extension` VARCHAR(50) ,`firstname` VARCHAR(50) ,`id` INT AUTO_INCREMENT,`lastname` VARCHAR(50) ,`phone` VARCHAR(50) ,`state` VARCHAR(50) ,`tradein` VARCHAR(50) ,`zip` VARCHAR(50) ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carslogotypes`;
CREATE TABLE `carslogotypes`(`id` INT AUTO_INCREMENT,`name` VARCHAR(50) ,`picture` LONGBLOB ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carsmake`;
CREATE TABLE `carsmake`(`id` INT AUTO_INCREMENT,`make` VARCHAR(50) ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carsmodels`;
CREATE TABLE `carsmodels`(`id` INT AUTO_INCREMENT,`make` VARCHAR(50) ,`model` VARCHAR(50) ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carspictures`;
CREATE TABLE `carspictures`(`CarID` INT ,`id` INT AUTO_INCREMENT,`pic0` VARCHAR(250) ,`pic1` VARCHAR(250) ,`pic2` VARCHAR(250) ,`pic3` VARCHAR(250) ,`pic4` VARCHAR(250) ,`pic5` VARCHAR(250) ,`pic6` VARCHAR(250) ,`pic7` VARCHAR(250) ,`pic8` VARCHAR(250) ,`pic9` VARCHAR(250) ,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS `carsusers`;
CREATE TABLE `carsusers`(`id` INT AUTO_INCREMENT,`password` VARCHAR(50) ,`username` VARCHAR(50) ,PRIMARY KEY (`id`));
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(1,'Taffeta White',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(2,'Opal Silver Blue Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(3,'Magnetic Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(4,'Galaxy Gray Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(5,'Alabaster Silver Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(6,'Royal Blue Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(7,'Premium White Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(8,'Nighthawk Black Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(9,'Milano Red',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(10,'Glacier Blue Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(11,'Deep Green Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(12,'Arctic Blue Pearl',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(13,'Titanium Silver Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(14,'Sparkling Graphite Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(15,'Sonora Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(16,'Monaco Blue Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(17,'Mystic Blue Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(18,'Imola Red',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(19,'Electric Red',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(20,'Black Sapphire Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(21,'Barrique Red Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(22,'Arctic Metallic',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(23,'Alpine White',NULL);
INSERT INTO `carsbcolor`(`id`,`color`,`picture`) VALUES(24,'Orange',NULL);
INSERT INTO `carscars` (`category`, `color`, `Date Listed`, `descr`, `EPACity`, `EPAHighway`, `features`, `Horsepower`, `id`, `Make`, `Model`, `Phone #`, `Picture`, `Price`, `UserID`, `YearOfMake`, `zipcode`) VALUES 
('Passenger Cars', 'Galaxy Gray Metallic', '2007-04-05', 'Concept and name\r\rThe TT was first shown as a concept car at the 1995 Frankfurt Motor Show. The design is credited to J Mays and Freeman Thomas of Volkswagen\'s California design studio, with Martin Smith contributing to the award winning interior design. The TT name does not indicate "twin turbo" as is sometimes assumed. The car is named for the NSU TT, a small rear-engine model with a formidable racing pedigree that NSU produced in the 1960s and was based on the NSU Prinz, although the modern TT shares next to nothing with that model\'s design concepts. The NSU TT was, in turn, named for the famous Isle of Man TT (Tourist Trophy) motorcycle races.\r\rDesign\r\rThe TT\'s styling is regarded by many as a watershed moment in automobile design. From its introduction as a concept car in 1995, and as a production car in 1998, the design was regarded by many as bold, innovative, and revolutionary. While the car borrowed a few design elements from earlier vehicles, the overall design was considered by many to be truly unique. Despite its smooth-curved appeal, the design does not lead to revolutionary aerodynamics — the drag coefficient of the body is actually a relatively high 0.35 [1]. But with its distinctive, rounded bodywork, bold use of bare anodized aluminum, and a lack of defined bumpers, the TT represented a departure from much of the styling that dominated the car market at that time.\r\rThe success and popularity of the TT\'s iconic design gave many automotive designers (and manufacturers) greater latitude to experiment with bold, distinctive design. The TT\'s influence can be seen in the design elements of many vehicles released after the TT.\r\rThe TT is often regarded as the vehicle that made people take a second look at Audi. No longer just a second-tier European maker, Audi emerged as a serious competitor for the likes of BMW and Mercedes-Benz. The then-new B5-platform A4 model was a substantial improvement on its Audi 80 predecessor; these two models firmly secured Audi\'s position as a prestige marque.\r\rPerformance Models\r\rIn the 2008 Detroit Motor Show, Audi released the TTS with a 2.0TFSI engine tuned to 268 hp (200 kW). It is also rumoured that a higher end TT-RS is under development, using an all-new turbocharged 2.5L 5-cylinder engine capable of up to 350 PS (345 hp/257 kW).\r\rAwards\r\rThe TT was nominated for the North American Car of the Year award for 2000. It was also on Car and Driver magazine\'s Ten Best list for 2000 and 2001.\r\rThe second generation TT has been honored with many awards including the inaugural Drive Car of the Year, Top Gear Coupe of the Year 2006, Fifth Gear Car of the Year 2006, Autobild \'Most Beautiful Car\' and World Design Car of the Year 2007, as well as being a finalist for World Car of the Year..', '', '', '', 197, 2, 'Audi', 'TT', '555-12-34', [encoded data, 40918 characters], 57900, 'admin', 2000, 12345);
INSERT INTO `carscars` (`category`, `color`, `Date Listed`, `descr`, `EPACity`, `EPAHighway`, `features`, `Horsepower`, `id`, `Make`, `Model`, `Phone #`, `Picture`, `Price`, `UserID`, `YearOfMake`, `zipcode`) VALUES 
('Sports Cars', 'Nighthawk Black Pearl', '2007-04-24', 'The 5 Series got its name by being the fifth of the "new series" cars after the V-8 and Isetta era. The preceding models were the 700, the "New Class", the "New Six" 2500/2800/Bavaria and the CS. The 5 Series was intended to replace the smaller New Class sedans, leaving the coupes as the company\'s low-end model.\r\rThe body was styled by Marcello Gandini, based on the Bertone 1970 BMW Garmisch 2002ti Geneva show car. Gandini also did the Fiat 132 and Alfa Romeo Alfetta, two other cars that have a similar design.\r\rThere have been five generations of the 5 Series to date. To differentiate between them, they are referred to by their unique chassis numbers (EXX).\r\rThe 5 Series began the BMW tradition of being named with a three-digit number. The first digit (5 in this case) represents the model, and the following two digits (usually) represent the size of the engine in decilitres, which is the main distinguishing difference. Additional letters or words may be added to the end of the three-digit number to define the fuel type (petrol or diesel), engine or transmission details, and the body style. The \'i\' originally stood for (fuel) \'injection\'.\rThe BMW E28 was the second BMW 5 Series, a stylistic evolution of the E12.\r\rThe following models were sold in Europe:\r    * 518/518i- 1.8 L M10B18\r    * 520i - 2.0 L M20B20 I6\r    524d - 2.4 L M21 diesel I6\r    * 524td - 2.4 L M21 turbodiesel I6\r    * 525i - 2.5 L M30B25 I6\r    * 525e - 2.7 L M20B27 I6\rHigh performance 5 Series - 24-valve DOHC, I6, six throttle bodies, Bosch Motronic integrated fuel injection. At its launch in 1984, the European specification E28 M5 was the fastest production sedan in the world.\r\rVisible changes to this model included revised headlights, Thicker rubber bumper surrounds and large rectangular taillights. The shape was more box shaped than rounded at the rear.\r\rAwards\r\rThe E39 5 Series was on Car and Driver magazine\'s annual Ten Best list for six years straight, from its introduction in 1997 through 2002. It was also Motor Trend\'s Import Car of the Year for 1997 and What Car? Executive Car of the Year 1997 through 2002. The E60 was named "Best New Luxury / Prestige Car" in the 2006 Canadian Car of the Year awards. Active Seat [3] continuous passive motion seating comfort technology recognized as one of the Best Inventions of 1998 by Popular Science magazine. Consumer Reports found the E39 5 series their best car tested in 2001-2002.', '', '', '', 215, 3, 'BMW', '525i', '1234567', [encoded data, 16170 characters], 41000, 'admin', 2004, 1234567);
INSERT INTO `carsmake`(`id`,`make`) VALUES(1,'Volvo');
INSERT INTO `carsmake`(`id`,`make`) VALUES(2,'Honda');
INSERT INTO `carsmake`(`id`,`make`) VALUES(3,'Mersedes');
INSERT INTO `carsmake`(`id`,`make`) VALUES(4,'Toyota');
INSERT INTO `carsmake`(`id`,`make`) VALUES(5,'Subaru');
INSERT INTO `carsmake`(`id`,`make`) VALUES(6,'Saab');
INSERT INTO `carsmake`(`id`,`make`) VALUES(7,'Volkswagen');
INSERT INTO `carsmake`(`id`,`make`) VALUES(8,'Jaguar');
INSERT INTO `carsmake`(`id`,`make`) VALUES(9,'Audi');
INSERT INTO `carsmake`(`id`,`make`) VALUES(10,'BMW');
INSERT INTO `carsmake`(`id`,`make`) VALUES(11,'Hyundai');
INSERT INTO `carsmake`(`id`,`make`) VALUES(12,'Nissan');
INSERT INTO `carsmake`(`id`,`make`) VALUES(13,'Porsche');
INSERT INTO `carsmake`(`id`,`make`) VALUES(14,'Mazda');
INSERT INTO `carsmake`(`id`,`make`) VALUES(15,'Lexus');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(1,'850','Volvo');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(2,'S40','Volvo');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(3,'S80T6','Volvo');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(4,'Accord','Honda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(5,'Civic','Honda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(6,'HR-V','Honda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(7,'Pilot','Honda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(8,'Cords','Mersedes');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(9,'Corona','Toyota');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(10,'RAV4','Toyota');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(11,'Vitz','Toyota');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(12,'Forester','Subaru');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(13,'Impreza','Subaru');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(14,'Legacy','Subaru');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(15,'9000','Saab');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(16,'Golf','Volkswagen');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(17,'Passat 1.8 Turbo Sedan','Volkswagen');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(18,'XJ 3.0 i V6 24V','Jaguar');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(19,'A3 2.0','Audi');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(20,'A4 1.8T Quattro','Audi');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(21,'A4 3.0 Cabrio','Audi');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(22,'A6 2.4','Audi');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(23,'TT','Audi');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(24,'520i','BMW');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(25,'525i','BMW');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(26,'Z4','BMW');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(27,'Accent','Hyundai');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(28,'Elantra','Hyundai');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(29,'Getz','Hyundai');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(30,'Sonata','Hyundai');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(31,'Tucson','Hyundai');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(32,'Maxima','Nissan');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(33,'Primera','Nissan');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(34,'Terrano','Nissan');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(35,'Cayenne','Porsche');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(36,'3','Mazda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(37,'6 2.3','Mazda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(38,'626','Mazda');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(39,'RX 300','Lexus');
INSERT INTO `carsmodels`(`id`,`model`,`make`) VALUES(40,'Civic Hybrid','Honda');
INSERT INTO `carspictures`(`id`,`CarID`,`pic0`,`pic1`,`pic2`,`pic3`,`pic4`,`pic5`,`pic6`,`pic7`,`pic8`,`pic9`) VALUES(2,2,NULL,'241100.jpg','241102.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `carspictures`(`id`,`CarID`,`pic0`,`pic1`,`pic2`,`pic3`,`pic4`,`pic5`,`pic6`,`pic7`,`pic8`,`pic9`) VALUES(3,3,NULL,'bmw1.gif','bmw2.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `carsusers`(`id`,`username`,`password`) VALUES(1,'admin','admin');