-- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Jan 07, 2007 at 10:22 AM -- Server version: 4.1.12 -- PHP Version: 5.0.5 -- -- Database: `exotic_cars` -- -- -------------------------------------------------------- -- -- Table structure for table `car_category` -- CREATE TABLE `car_category` ( `categoryid` int(200) NOT NULL auto_increment, `full_name` varchar(200) NOT NULL default '', `abbreviation` varchar(200) NOT NULL default '', PRIMARY KEY (`categoryid`) ); -- -- Dumping data for table `car_category` -- INSERT INTO `car_category` VALUES (1, 'CV', ''); INSERT INTO `car_category` VALUES (7, 'EX', ''); INSERT INTO `car_category` VALUES (5, 'SP', ''); -- -------------------------------------------------------- -- -- Table structure for table `car_info` -- CREATE TABLE `car_info` ( `c_carid` int(200) NOT NULL auto_increment, `c_make` varchar(200) NOT NULL default '', `c_model` varchar(200) NOT NULL default '', `c_year` varchar(200) NOT NULL default '', `c_color` varchar(200) NOT NULL default '', `c_transmission` varchar(200) NOT NULL default '', `c_drive` varchar(200) NOT NULL default '', `c_msrp` varchar(200) NOT NULL default '', `c_main_img` text NOT NULL, `c_alt_img_1` text NOT NULL, `c_alt_img_2` text NOT NULL, `c_alt_img_3` text NOT NULL, `c_alt_img_4` text NOT NULL, `c_alt_img_5` text NOT NULL, `c_zero2sixty_time` varchar(200) NOT NULL default '', `c_convertible` varchar(200) NOT NULL default '', `c_horsepower` varchar(200) NOT NULL default '', `c_torque` varchar(200) NOT NULL default '', `c_more_info` text NOT NULL, `c_new_arrival` varchar(200) NOT NULL default '', `c_rent_weekday_rate` varchar(200) NOT NULL default '', `c_rental_weekend_daily_rate` varchar(200) NOT NULL default '', `c_rental_weekend_rate` varchar(200) NOT NULL default '', `c_rental_miles_included_per_day` varchar(200) NOT NULL default '', `c_rental_cost_per_x_mile` varchar(200) NOT NULL default '', `c_rental_sec_deposit` varchar(200) NOT NULL default '', `c_platinum_weekday_rate` varchar(200) NOT NULL default '', `c_platinum_weekend_daily_rate` varchar(200) NOT NULL default '', `c_platinum_weekend_rate` varchar(200) NOT NULL default '', `c_platinum_miles_inc` varchar(200) NOT NULL default '', `c_platinum_cost_per_extra_mile` varchar(200) NOT NULL default '', `c_gold_weekday_rate` varchar(200) NOT NULL default '', `c_gold_weekend_daily_rate` varchar(200) NOT NULL default '', `c_gold_weekend_rate` varchar(200) NOT NULL default '', `c_gold_miles_inc` varchar(200) NOT NULL default '', `c_gold_cost_per_extra_mile` varchar(200) NOT NULL default '', `c_silver_weekday_rate` varchar(200) NOT NULL default '', `c_silver_weekend_daily_rate` varchar(200) NOT NULL default '', `c_silver_weekend_rate` varchar(200) NOT NULL default '', `c_silver_miles_inc` varchar(200) NOT NULL default '', `c_silver_cost_per_extra_mile` varchar(200) NOT NULL default '', `c_bronze_weekday_rate` varchar(200) NOT NULL default '', `c_bronze_weekend_daily_rate` varchar(200) NOT NULL default '', `c_bronze_weekend_rate` varchar(200) NOT NULL default '', `c_bronze_miles_inc` varchar(200) NOT NULL default '', `c_bronze_cost_per_extra_mile` varchar(200) NOT NULL default '', `c_corporate_weekday_rate` varchar(200) NOT NULL default '', `c_corporate_weekend_daily_rate` varchar(200) NOT NULL default '', `c_corporate_weekend_rate` varchar(200) NOT NULL default '', `c_corporate_miles_inc` varchar(200) NOT NULL default '', `c_corporate_cost_per_extra_mile` varchar(200) NOT NULL default '', `c_special_pricing_weekday_rental1` varchar(200) NOT NULL default '', `c_special_pricing_weekend_day_rental1` varchar(200) NOT NULL default '', `c_special_pricing_weekend_rental1` varchar(200) NOT NULL default '', `c_special_pricing_weekday_rental2` varchar(200) NOT NULL default '', `c_special_pricing_weekend_day_rental2` varchar(200) NOT NULL default '', `c_special_pricing_weekend_rental2` varchar(200) NOT NULL default '', `c_tours` varchar(200) NOT NULL default '', `c_category` varchar(200) NOT NULL default '', `c_special_display_rental` varchar(200) NOT NULL default '', `c_special_display_car_club` varchar(200) NOT NULL default '', `c_special_note` text NOT NULL, PRIMARY KEY (`c_carid`) ) ; -- -- Dumping data for table `car_info` -- INSERT INTO `car_info` VALUES (7, 'Mercedes', 'CLS500', '2006', 'Black', 'Auto', '2wd', '65000', '06_mercedes_cls500.jpg', '', '', '', '', '', '', 'No', '302', '339', '', '', '300', '400', '300', '100', '0.5', '', '150', '200', '150', '150', '', '165', '220', '165', '125', '', '180', '240', '180', '100', '', '195', '260', '65', '100', '', '150', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (8, 'Chevrolet', 'Corvette', '2005', 'Red', 'Auto', '2wd', '54000', '06_chevrolet_corvette.jpg', '', '', '', '', '', '4.2', 'No', '400', '400', '', '', '300', '400', '300', '100', '0.5', '', '150', '200', '150', '150', '', '165', '220', '165', '125', '', '180', '240', '180', '100', '', '195', '260', '65', '100', '', '150', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (9, 'Mercedes', 'SL500', '2006', 'White', 'Auto', '2wd', '90000', '06_mercedes_sl500.jpg', '', '', '', '', '', '', 'Yes', '302', '339', '', '', '400', '475', '400', '100', '0.75', '', '200', '238', '200', '150', '', '220', '261', '220', '125', '', '240', '285', '240', '100', '', '260', '309', '65', '100', '', '200', '238', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (10, 'Bentley', 'Continental GT', '2005', 'Black', 'Auto', '4wd', '160000', '05_bentley_continentalgt.jpg', '', '', '', '', '', '4.9', 'No', '552', '479', '', '', '1300', '1450', '1300', '75', '1.5', '', '650', '725', '650', '125', '', '715', '798', '715', '100', '', '780', '870', '780', '75', '', '845', '943', '49', '75', '', '650', '725', '38', '125', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (11, 'Mercedes', 'CLK320', '2005', 'Bronze', 'Auto', '2wd', '54000', '05_mercedes_clk320.jpg', '', '', '', '', '', '4.7', 'Yes', '215', '229', '', '', '275', '350', '275', '100', '0.5', '', '138', '175', '138', '150', '', '151', '193', '151', '125', '', '165', '210', '165', '100', '', '179', '228', '65', '100', '', '138', '175', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (12, 'Mercedes', 'SLK55', '2005', 'Black', 'Auto', '2wd', '61000', '05_mercedes_slk55.jpg', '', '', '', '', '', '', 'Yes', '355', '376', '', '', '275', '350', '275', '100', '0.5', '', '138', '175', '138', '150', '', '151', '193', '151', '125', '', '165', '210', '165', '100', '', '179', '228', '65', '100', '', '138', '175', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (13, 'Mercedes', 'ML430', '2001', 'Black', 'Auto', '2wd', '45000', '01_mercedes_ml430.jpg', '', '', '', '', '', '', 'No', '268', '288', '', '', '100', '120', '100', '100', '0.5', '', '50', '60', '50', '150', '', '55', '66', '55', '125', '', '60', '72', '60', '100', '', '65', '78', '65', '100', '', '50', '60', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (14, 'Aston Martin', 'Vantage', '2003', 'Lt Blue', 'Auto', '2wd', '145000', '03_aston_vantage.jpg', '', '', '', '', '', '', 'No', '420', '400', '', '', '600', '800', '600', '100', '1', '', '300', '400', '300', '150', '', '330', '440', '330', '125', '', '360', '480', '360', '100', '', '390', '520', '65', '100', '', '300', '400', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (15, 'Dodge', 'Viper SRT-10 convertible', '2005', 'Orange', 'Manual', '2wd', '89000', '05_dodge_viper.jpg', '', '', '', '', '', '4', 'Yes', '510', '535', '', '', '325', '450', '325', '100', '1', '', '163', '225', '163', '150', '', '179', '248', '179', '125', '', '195', '270', '195', '100', '', '211', '293', '65', '100', '', '163', '225', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (16, 'Rolls Royce', 'Phantom VI', '2005', 'Black', 'Auto', '2wd', '350000', '05_rolls_phantom.jpg', '', '', '', '', '', '5.7', 'No', '453', '531', '', '', '2200', '2750', '2200', '50', '2', '', '1100', '1375', '1100', '100', '', '1210', '1513', '1210', '75', '', '1320', '1650', '1320', '50', '', '1430', '1788', '33', '50', '', '1100', '1375', '25', '100', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (17, 'Ferrari', '360 Spider', '2004', 'Black', 'Auto', '2wd', '187000', '04_ferrari_360.jpg', '', '', '', '', '', '4.3', 'Yes', '400', '275', '', '', '1475', '1750', '1475', '75', '2', '', '738', '875', '738', '125', '', '811', '963', '811', '100', '', '885', '1050', '885', '75', '', '959', '1138', '49', '75', '', '738', '875', '38', '125', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (18, 'Chevrolet', 'Corvette ZO6', '2006', 'Yellow', 'Manual', '2wd', '72000', '06_chevrolet_z06.jpg', '', '', '', '', '', '3.5', 'No', '505', '470', '', '', '450', '575', '450', '100', '0.75', '', '225', '288', '225', '150', '', '248', '316', '248', '125', '', '270', '345', '270', '100', '', '293', '374', '65', '100', '', '225', '288', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (19, 'BMW', 'Mini Cooper', '2006', 'Red', 'Auto', '2wd', '23000', '06_mini_cooper.jpg', '', '', '', '', '', '', 'No', '115', '111', '', '', '175', '250', '175', '100', '0.5', '', '88', '125', '88', '150', '', '96', '138', '96', '125', '', '105', '150', '105', '100', '', '114', '163', '65', '100', '', '88', '125', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (20, 'Lexus', 'SC430', '2005', 'Red', 'Auto', '2wd', '66000', '05_lexus_sc430.jpg', '', '', '', '', '', '', 'Yes', '288', '317', '', '', '275', '325', '275', '100', '0.5', '', '138', '163', '138', '150', '', '151', '179', '151', '125', '', '165', '195', '165', '100', '', '179', '211', '65', '100', '', '138', '163', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (21, 'Cadillac', 'Escalade', '2007', 'Black', 'Auto', '2wd', '60000', '07_cadilac_escalade.jpg', '', '', '', '', '', '', 'No', '403', '417', '', '', '350', '450', '350', '100', '0.5', '', '175', '225', '175', '150', '', '193', '248', '193', '125', '', '210', '270', '210', '100', '', '228', '293', '65', '100', '', '175', '225', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (22, 'Mercedes', 'S550', '2007', 'Black', 'Auto', '2wd', '90000', '07_mercedes_s550.jpg', '', '', '', '', '', '', 'No', '382', '391', '', '', '425', '625', '425', '100', '0.75', '', '213', '313', '213', '150', '', '234', '344', '234', '125', '', '255', '375', '255', '100', '', '276', '406', '65', '100', '', '213', '313', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (23, 'International', 'RXT PU', '2007', 'Black', 'Auto', '2wd', '90000', '07_international_rxt.jpg', '', '', '', '', '', '', 'No', '230', '540', '', '', '575', '725', '575', '100', '0.75', '', '288', '363', '288', '150', '', '316', '399', '316', '125', '', '345', '435', '345', '100', '', '374', '471', '65', '100', '', '288', '363', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (24, 'International', 'CXT PU', '2006', 'Red', 'Auto', '2wd', '110000', '07_interntational_cxt.jpg', '', '', '', '', '', '', 'No', '300', '860', '', '', '575', '675', '575', '100', '0.75', '', '288', '338', '288', '150', '', '316', '371', '316', '125', '', '345', '405', '345', '100', '', '374', '439', '65', '100', '', '288', '338', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (25, 'Porsche', '911 Cabriolet', '2006', 'Black', 'Auto', '2wd', '82000', '06_porsche_cabriolet.jpg', '', '', '', '', '', '4.7', 'Yes', '325', '273', '', '', '450', '625', '450', '100', '1', '', '225', '313', '225', '150', '', '248', '344', '248', '125', '', '270', '375', '270', '100', '', '293', '406', '65', '100', '', '225', '313', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (26, 'Toyota', 'FJ Series', '2007', 'Silver', 'Auto', '2wd', '28000', '07_toyota_fj.jpg', '', '', '', '', '', '', 'No', '239', '278', '', '', '175', '225', '175', '100', '0.75', '', '88', '113', '88', '150', '', '96', '124', '96', '125', '', '105', '135', '105', '100', '', '114', '146', '65', '100', '', '88', '113', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (27, 'Porsche', 'Boxster Cabriolet', '2005', 'Silver', 'Auto', '2wd', '40000', '05_porsche_boxster.jpg', '', '', '', '', '', '6.2', 'Yes', '240', '199', '', '', '250', '350', '250', '100', '0.5', '', '125', '175', '125', '150', '', '138', '193', '138', '125', '', '150', '210', '150', '100', '', '163', '228', '65', '100', '', '125', '175', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (28, 'Hummer', 'H2', '2005', 'Black', 'Auto', '4wd', '53000', '05_hummer_h2.jpg', '', '', '', '', '', '10.2', 'No', '325', '365', '', '', '250', '300', '250', '100', '0.5', '', '125', '150', '125', '150', '', '138', '165', '138', '125', '', '150', '180', '150', '100', '', '163', '195', '65', '100', '', '125', '150', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (29, 'Lotus', 'Elise', '2005', 'Yellow', 'Auto', '2wd', '44000', '05_lotus_elise.jpg', '', '', '', '', '', '5.1', 'No', '190', '138', '', '', '350', '400', '350', '100', '0.5', '', '175', '200', '175', '150', '', '193', '220', '193', '125', '', '210', '240', '210', '100', '', '228', '260', '65', '100', '', '175', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (30, 'Ferrari', 'F430 Cpe', '2005', 'Red', 'Manual', '2wd', '220000', '05_ferrari_f430.jpg', '', '', '', '', '', '4', 'No', '490', '343', '', '', '1650', '1950', '1650', '50', '2', '', '825', '975', '825', '100', '', '908', '1073', '908', '75', '', '990', '1170', '990', '50', '', '1073', '1268', '33', '50', '', '825', '975', '25', '100', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (31, 'Lamborghini', 'Gallardo Convert', '2006', 'yellow', 'Auto', '4wd', '200000', '06_lamborghini_gallardo_cv.jpg', '', '', '', '', '', '4', 'Yes', '520', '376', '', '', '2100', '2450', '2100', '50', '1.5', '', '1050', '1225', '1050', '100', '', '1155', '1348', '1155', '75', '', '1260', '1470', '1260', '50', '', '1365', '1593', '33', '50', '', '1050', '1225', '25', '100', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (32, 'Porsche', 'Cayenne', '2005', 'White', 'Auto', '2wd', '58000', '05_porsche_cayenne.jpg', '', '', '', '', '', '7', 'No', '340', '310', '', '', '329', '399', '329', '100', '0.5', '', '165', '200', '165', '150', '', '181', '219', '181', '125', '', '197', '239', '197', '100', '', '214', '259', '65', '100', '', '165', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (33, 'Lamborghini', 'Gallardo Cpe', '2006', 'Orange', 'Auto', '4wd', '180000', '06_lamborghini_gallardo.jpg', '', '', '', '', '', '4', 'No', '520', '376', '', '', '1400', '1650', '1400', '75', '1.5', '', '700', '825', '700', '125', '', '770', '908', '770', '100', '', '840', '990', '840', '75', '', '910', '1073', '49', '75', '', '700', '825', '38', '125', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (34, 'Mercedes', 'SL320', '1995', 'White', 'Auto', '2wd', '80000', '95_mercedes_sl320.jpg', '', '', '', '', '', '', 'Yes', '229', '232', '', '', '129', '159', '129', '100', '0.5', '', '65', '80', '65', '150', '', '71', '87', '71', '125', '', '77', '95', '77', '100', '', '84', '103', '65', '100', '', '65', '80', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (35, 'Aston martin', 'V8 Vantage', '2006', 'White', 'Manual', '2wd', '120000', '06_aston_vantage.jpg', '', '', '', '', '', '4.8', 'No', '380', '302', '', '', '1150', '1350', '1150', '75', '2', '', '575', '675', '575', '125', '', '633', '743', '633', '100', '', '690', '810', '690', '75', '', '748', '878', '49', '75', '', '575', '675', '38', '125', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (36, 'GMC', 'Denali', '2005', 'Silver', 'Auto', '4wd', '51000', '05_gmc_denali.jpg', '', '', '', '', '', '', 'No', '335', '375', '', '', '189', '239', '189', '100', '0.5', '', '95', '120', '95', '150', '', '104', '131', '104', '125', '', '113', '143', '113', '100', '', '123', '155', '65', '100', '', '95', '120', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (37, 'Pontiac', 'Solstice', '2007', 'red', 'Auto', '2wd', '24000', '07_pontiac_solstice.jpg', '', '', '', '', '', '7.5', 'Yes', '177', '166', '', '', '225', '289', '225', '100', '0.5', '', '113', '145', '113', '150', '', '124', '159', '124', '125', '', '135', '173', '135', '100', '', '146', '188', '65', '100', '', '113', '145', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (38, 'BMW', '745 LI', '2005', 'White', 'Auto', '2wd', '75000', '05_bmw_745li.jpg', '', '', '', '', '', '', 'No', '325', '330', '', '', '375', '550', '375', '100', '0.5', '', '188', '275', '188', '150', '', '206', '303', '206', '125', '', '225', '330', '225', '100', '', '244', '358', '65', '100', '', '188', '275', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (39, 'BMW', 'M6 Convertible', '2007', 'Black', 'Auto', '2wd', '105000', '07_m6_cv.jpg', '', '', '', '', '', '4.6', 'Yes', '500', '383', '', '', '950', '1250', '950', '100', '1', '', '475', '625', '475', '150', '', '523', '688', '523', '125', '', '570', '750', '570', '100', '', '618', '813', '65', '100', '', '475', '625', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (40, 'Porsche', '911 Turbo', '2007', 'Red', 'Auto', '4wd', '123000', '07_porsche_turbo.jpg', '', '', '', '', '', '3.4', 'No', '480', '460', '', '', '1100', '1400', '1100', '100', '1.5', '', '550', '700', '550', '150', '', '605', '770', '605', '125', '', '660', '840', '660', '100', '', '715', '910', '65', '100', '', '550', '700', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (41, 'Lexus', 'LS460', '2007', 'White', 'Auto', '2wd', '72000', '07_lexus_ls460.jpg', '', '', '', '', '', '', 'No', '380', '367', '', '', '475', '695', '475', '100', '0.5', '', '238', '348', '238', '150', '', '261', '382', '261', '125', '', '285', '417', '285', '100', '', '309', '452', '65', '100', '', '238', '348', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (42, 'BMW', '525i', '2007', 'White', 'Auto', '2wd', '45000', '07_bmw_525i.jpg', '', '', '', '', '', '', 'No', '215', '185', '', '', '325', '399', '325', '100', '0.5', '', '163', '200', '163', '150', '', '179', '219', '179', '125', '', '195', '239', '195', '100', '', '211', '259', '65', '100', '', '163', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (43, 'Range', 'Rover', '2007', 'white', 'Auto', '4wd', '60000', '07_landrover_rangerover.jpg', '', '', '', '', '', '', 'No', '300', '315', '', '', '350', '450', '350', '100', '0.75', '', '175', '225', '175', '150', '', '193', '248', '193', '125', '', '210', '270', '210', '100', '', '228', '293', '65', '100', '', '175', '225', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (44, 'Aston Martin', 'Volante', '1997', 'Red', 'Auto', '2wd', '140000', '97_aston_volante.jpg', '', '', '', '', '', '', 'Yes', '335', '361', '', '', '500', '675', '500', '100', '0.75', '', '250', '338', '250', '150', '', '275', '371', '275', '125', '', '300', '405', '300', '100', '', '325', '439', '65', '100', '', '250', '338', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (45, 'BMW', '3.0cs', '1970', 'Red', 'Auto', '2wd', '', '70_bmw_30cs.jpg', '', '', '', '', '', '', 'No', '180', '', '', '', '225', '275', '225', '100', '1', '', '113', '138', '113', '150', '', '124', '151', '124', '125', '', '135', '165', '135', '100', '', '146', '179', '65', '100', '', '113', '138', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (46, 'Mercedes', '350SL', '1973', 'White', 'Auto', '2wd', '', '73_mercedes_350sl.jpg', '', '', '', '', '', '', 'Yes', '180', '', '', '', '125', '165', '125', '100', '1', '', '63', '83', '63', '150', '', '69', '91', '69', '125', '', '75', '99', '75', '100', '', '81', '107', '65', '100', '', '63', '83', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (47, 'Mercedes', '280SL (red)', '1971', 'Red', 'Auto', '2wd', '', '71_mercedes_280sl.jpg', '', '', '', '', '', '', 'Yes', '180', '', '', '', '275', '375', '275', '100', '1', '', '138', '188', '138', '150', '', '151', '206', '151', '125', '', '165', '225', '165', '100', '', '179', '244', '65', '100', '', '138', '188', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (48, 'Mercedes', '280SE 3.5 conv', '1970', 'Green', 'Auto', '2wd', '', '70_mercedes_280se_cv.jpg', '', '', '', '', '', '', 'Yes', '180', '', '', '', '475', '575', '475', '100', '1', '', '238', '288', '238', '150', '', '261', '316', '261', '125', '', '285', '345', '285', '100', '', '309', '374', '65', '100', '', '238', '288', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (49, 'Mercedes', '280SL (Silv)', '1970', 'Silver', 'Auto', '2wd', '', '70_mercedes_280sl_green.jpg', '', '', '', '', '', '', 'Yes', '180', '', '', '', '225', '275', '225', '100', '1', '', '113', '138', '113', '150', '', '124', '151', '124', '125', '', '135', '165', '135', '100', '', '146', '179', '65', '100', '', '113', '138', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (50, 'VW', 'Beetle', '1959', 'Blue', 'Manual', '2wd', '', '59_vw_beetle.jpg', '', '', '', '', '', '', 'Yes', '38', '', '', '', '210', '250', '210', '100', '1', '', '105', '125', '105', '150', '', '116', '138', '116', '125', '', '126', '150', '126', '100', '', '137', '163', '65', '100', '', '105', '125', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (51, 'BMW', '327 Cabriolet', '1939', 'White', 'Manual', '2wd', '', '39_bmw_327cab.jpg', '', '', '', '', '', '', 'Yes', '300', '', '', '', '675', '850', '675', '100', '1', '', '338', '425', '338', '150', '', '371', '468', '371', '125', '', '405', '510', '405', '100', '', '439', '553', '65', '100', '', '338', '425', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (52, 'Alfa Romeo', 'Spider', '1959', 'Red', 'Manual', '2wd', '', '59_alfa_spider.jpg', '', '', '', '', '', '', 'Yes', '150', '', '', '', '325', '400', '325', '100', '1', '', '163', '200', '163', '150', '', '179', '220', '179', '125', '', '195', '240', '195', '100', '', '211', '260', '65', '100', '', '163', '200', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (53, 'VW', 'Karman Ghia', '1971', 'Black', 'Manual', '2wd', '', '71_vw_ghia.jpg', '', '', '', '', '', '', 'Yes', '36', '', '', '', '150', '175', '150', '100', '1', '', '75', '88', '75', '150', '', '83', '96', '83', '125', '', '90', '105', '90', '100', '', '98', '114', '65', '100', '', '75', '88', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (54, 'BMW', 'Isetta', '1959', 'Red', 'Manual', '2wd', '', '59_bmw_isetta.jpg', '', '', '', '', '', '', 'Yes', '10', '', '', '', '200', '250', '200', '100', '1', '', '100', '125', '100', '150', '', '110', '138', '110', '125', '', '120', '150', '120', '100', '', '130', '163', '65', '100', '', '100', '125', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (55, 'BMW', 'Isetta conv.', '1959', 'White', 'Manual', '2wd', '', '59_bmw_isetta_cv.jpg', '', '', '', '', '', '', 'Yes', '10', '', '', '', '250', '300', '250', '100', '1', '', '125', '150', '125', '150', '', '138', '165', '138', '125', '', '150', '180', '150', '100', '', '163', '195', '65', '100', '', '125', '150', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (56, 'Porsche', '930 Turbo', '1978', 'White', 'Manual', '2wd', '', '78_porsche_930.jpg', '', '', '', '', '', '', 'No', '234', '246', '', '', '250', '275', '250', '100', '1', '', '125', '138', '125', '150', '', '138', '151', '138', '125', '', '150', '165', '150', '100', '', '163', '179', '65', '100', '', '125', '138', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (57, 'VW', 'Bus-Fire truck', '1959', 'Red', 'Manual', '2wd', '', '59_vw_busfire.jpg', '', '', '', '', '', '', 'No', '25', '', '', '', '275', '300', '275', '100', '1', '', '138', '150', '138', '150', '', '151', '165', '151', '125', '', '165', '180', '165', '100', '', '179', '195', '65', '100', '', '138', '150', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (58, 'VW', 'Type 3 Karman Ghia', '1966', 'Red', 'Manual', '2wd', '', '66_vw_type3karman.jpg', '', '', '', '', '', '', 'No', '38', '', '', '', '200', '225', '200', '100', '1', '', '100', '113', '100', '150', '', '110', '124', '110', '125', '', '120', '135', '120', '100', '', '130', '146', '65', '100', '', '100', '113', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (59, 'Mercedes', '190SL', '1959', 'White', 'Manual', '2wd', '', '59_mercedes_190sl.jpg', '', '', '', '', '', '', 'Yes', '180', '', '', '', '425', '475', '425', '100', '1', '', '213', '238', '213', '150', '', '234', '261', '234', '125', '', '255', '285', '255', '100', '', '276', '309', '65', '100', '', '213', '238', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (60, 'Mercedes', '300SC Cabriolet', '1955', 'Red', 'Auto', '2wd', '', '55_mercedes_300sccab.jpg', '', '', '', '', '', '', 'Yes', '240', '', '', '', '975', '1250', '975', '100', '1', '', '488', '625', '488', '150', '', '536', '688', '536', '125', '', '585', '750', '585', '100', '', '634', '813', '65', '100', '', '488', '625', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (61, 'Chevrolet', 'Corvette convertible', '1965', 'Red', 'Manual', '2wd', '', '65_chevrolet_corvette.jpg', '', '', '', '', '', '', 'Yes', '350', '', '', '', '600', '750', '600', '100', '1', '', '300', '375', '300', '150', '', '330', '413', '330', '125', '', '360', '450', '360', '100', '', '390', '488', '65', '100', '', '300', '375', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (62, 'Bentley', 'Brooklands', '1998', 'Black', 'Auto', '2wd', '', '98_bentley_brooklands.jpg', '', '', '', '', '', '', 'No', '350', '', '', '', '450', '525', '450', '100', '0.5', '', '225', '263', '225', '150', '', '248', '289', '248', '125', '', '270', '315', '270', '100', '', '293', '341', '65', '100', '', '225', '263', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `car_info` VALUES (63, 'VW', 'Notchback', '1965', 'Blue', 'Manual', '2wd', '', '65_vw_notchback.jpg', '', '', '', '', '', '', 'No', '25', '', '', '', '175', '225', '175', '100', '1', '', '88', '113', '88', '150', '', '96', '124', '96', '125', '', '105', '135', '105', '100', '', '114', '146', '65', '100', '', '88', '113', '50', '150', '', '', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `car_tours` -- CREATE TABLE `car_tours` ( `tourid` int(200) NOT NULL auto_increment, `full_name` varchar(200) NOT NULL default '', PRIMARY KEY (`tourid`) ) ; -- -- Dumping data for table `car_tours` -- INSERT INTO `car_tours` VALUES (1, '2K'); INSERT INTO `car_tours` VALUES (2, 'RD'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `userid` varchar(200) NOT NULL default '', `name` varchar(200) NOT NULL default '', `email` varchar(200) NOT NULL default '', `username` varchar(200) NOT NULL default '', `password` varchar(200) NOT NULL default '', `accesslevel` varchar(200) NOT NULL default '', PRIMARY KEY (`userid`) ); -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES ('1sd521e3', 'Stephen Edmondson', 'stephene@dfweliteautorental.com', 'stephen', 'ae2b1fca515949e5d54fb22b8ed95575', 'Admin'); INSERT INTO `users` VALUES ('rrojrmq3y', 'Jason Le', 'tri@9xsolutions.com', 'lmtzila', '3088e08f391e8ed61f58003d47a6d672', 'Admin');