-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 12, 2011 at 08:06 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `nissan_new`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `administrator`
-- 

CREATE TABLE `administrator` (
  `admin_id` int(5) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(150) NOT NULL,
  `status` tinyint(1) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `administrator`
-- 

INSERT INTO `administrator` (`admin_id`, `username`, `password`, `status`) VALUES 
(0, 'admin', '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C', 1),
(1, 'subadmin', '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `cbodystyle`
-- 

CREATE TABLE `cbodystyle` (
  `int_id` int(11) NOT NULL auto_increment,
  `int_title` varchar(500) NOT NULL,
  `int_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`int_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `cbodystyle`
-- 

INSERT INTO `cbodystyle` (`int_id`, `int_title`, `int_sort`) VALUES 
(1, '4dr Car', 1),
(4, 'Sport Utility', 0),
(5, '2dr Car', 0),
(6, 'Crew Cab Pickup', 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `ccolor`
-- 

CREATE TABLE `ccolor` (
  `int_id` int(11) NOT NULL auto_increment,
  `int_title` varchar(500) NOT NULL,
  `int_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`int_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

-- 
-- Dumping data for table `ccolor`
-- 

INSERT INTO `ccolor` (`int_id`, `int_title`, `int_sort`) VALUES 
(6, 'Dark Slate Metallic', 1),
(7, 'Mystic Jade Metallic', 2),
(8, 'Navy Blue Metallic', 3),
(9, 'Precision Gray Metallic', 4),
(10, 'Radiant Silver Metallic', 5),
(11, 'Red Brick Metallic', 6),
(12, 'Sonoran Sand Metallic', 7),
(13, 'Super Black', 8),
(14, 'Winter Frost Pearl', 9),
(15, 'Merlot', 0),
(17, 'Deep Sapphire', 0),
(18, 'Glacier Pearl', 0),
(19, 'Platinum Graphite', 0),
(20, 'Saharan Stone', 0),
(22, 'Tinted Bronze', 0),
(23, 'Black', 0),
(24, 'Beige', 0),
(25, 'Silver', 0),
(26, 'Generic Colors', 10),
(27, 'N/A', 11),
(28, 'Blonde', 12),
(29, 'Charcoal', 13),
(30, 'Frost', 14),
(31, 'Blue ', 15),
(32, 'Brown', 16),
(33, 'Copper', 17),
(34, 'Gold', 18),
(35, 'Gray ', 19),
(36, 'Green', 20),
(37, 'Maroon', 21),
(38, 'Non Color', 22),
(39, 'Orange ', 23),
(40, 'Purple', 24),
(41, 'Red', 25),
(42, 'Tan', 26),
(43, 'Teal', 27),
(44, 'White', 28),
(45, 'Yellow', 29),
(46, 'Metallic Slate', 30),
(47, 'Radiant Silver', 31),
(48, 'Steel', 32);

-- --------------------------------------------------------

-- 
-- Table structure for table `cmaterial`
-- 

CREATE TABLE `cmaterial` (
  `int_id` int(11) NOT NULL auto_increment,
  `int_title` varchar(500) NOT NULL,
  `int_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`int_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `cmaterial`
-- 

INSERT INTO `cmaterial` (`int_id`, `int_title`, `int_sort`) VALUES 
(2, 'Leather', 1),
(3, 'American Leather', 2),
(4, 'Cloth', 0),
(5, 'Vinyl', 0),
(6, 'Leatherette', 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `cwheelsize`
-- 

CREATE TABLE `cwheelsize` (
  `int_id` int(11) NOT NULL auto_increment,
  `int_title` varchar(500) NOT NULL,
  `int_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`int_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `cwheelsize`
-- 

INSERT INTO `cwheelsize` (`int_id`, `int_title`, `int_sort`) VALUES 
(1, '14', 1),
(2, '16', 2),
(3, '17', 0),
(5, '15', 0),
(7, '18', 0),
(8, '19', 0),
(9, '20', 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `equip_options`
-- 

CREATE TABLE `equip_options` (
  `equip_id` int(11) NOT NULL auto_increment,
  `equip_title` varchar(500) NOT NULL,
  `equip_sort` int(11) NOT NULL default '0',
  `equip_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`equip_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;

-- 
-- Dumping data for table `equip_options`
-- 

INSERT INTO `equip_options` (`equip_id`, `equip_title`, `equip_sort`, `equip_status`) VALUES 
(16, '4-Wheel ABS', 1, 0),
(18, 'A/C', 2, 0),
(19, 'Adjustable Steering Wheel', 3, 0),
(20, 'Aluminum Wheels', 4, 0),
(21, 'AM/FM Stereo', 5, 0),
(22, 'Auxiliary Audio Input', 6, 0),
(23, 'Bucket Seats', 7, 0),
(24, 'CD Player', 8, 0),
(25, 'Climate Control', 9, 0),
(26, 'Cloth Seats', 10, 0),
(27, 'Cruise Control', 11, 0),
(28, 'Driver Air Bag', 12, 0),
(29, 'Front Head Air Bag', 13, 0),
(30, 'Front Side Air Bag', 14, 0),
(31, 'Front Wheel Drive', 15, 0),
(32, 'Gas/Electric Hybrid', 16, 0),
(33, 'Multi-Zone A/C', 17, 0),
(34, 'Passenger Air Bag', 18, 0),
(35, 'Passenger Air Bag Sensor', 19, 0),
(36, 'Power Door Locks', 20, 0),
(37, 'Power Steering', 21, 0),
(38, 'Power Windows', 22, 0),
(39, 'Rear Bench Seat', 23, 0),
(40, 'Rear Head Air Bag', 24, 0),
(41, 'Tires - Front All-Season', 25, 0),
(42, 'Tires - Rear All-Season', 26, 0),
(43, 'Traction Control', 27, 0),
(44, 'Vehicle Anti-Theft System', 28, 0),
(45, 'Gasoline Fuel', 29, 0),
(46, 'Steel Wheels', 30, 0),
(47, 'CD Changer', 0, 0),
(48, 'Front Tow Hooks', 31, 0),
(49, 'All Wheel Drive', 32, 0),
(50, 'MP3 Player', 33, 0),
(51, 'Rear A/C', 34, 0),
(52, 'Power Driver Seat', 35, 0),
(53, 'Power Passenger Seat', 36, 0),
(54, 'Power Tilt/Sliding Sunroof', 37, 0),
(55, 'Tires - Front Performance', 38, 0),
(56, 'Tires - Rear Performance', 39, 0),
(57, 'Fourth Passenger Door', 40, 0),
(58, 'Privacy Glass', 41, 0),
(59, 'Rear Wheel Drive', 42, 0),
(60, 'Sliding Rear Window', 43, 0),
(61, 'Driven Wheels', 44, 1),
(62, 'Seating', 45, 1),
(63, 'Fuel Storage', 46, 1),
(64, 'Air Conditioning', 47, 1),
(65, 'Air filtration', 48, 1),
(66, 'Front air conditioning', 49, 1),
(67, 'Airbags', 50, 1),
(68, 'Front airbags', 51, 1),
(69, 'Passenger airbag deactivation', 52, 1),
(70, 'Side airbags', 53, 1),
(71, 'Side curtain airbags', 54, 1),
(72, 'In-Dash CD', 55, 1),
(73, 'Radio', 56, 1),
(74, 'Cruise control', 57, 1),
(75, 'Multi-function remotE', 58, 1),
(76, 'Keyless ignition', 59, 1),
(77, 'Remote trunk release', 60, 1),
(78, 'Steering wheel', 61, 1),
(79, 'Steering wheel mounted controls', 62, 1),
(80, 'Anti-theft alarm system', 63, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `exterior`
-- 

CREATE TABLE `exterior` (
  `ext_id` int(11) NOT NULL auto_increment,
  `ext_title` varchar(500) NOT NULL,
  `ext_sort` int(11) NOT NULL default '0',
  `ext_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ext_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ;

-- 
-- Dumping data for table `exterior`
-- 

INSERT INTO `exterior` (`ext_id`, `ext_title`, `ext_sort`, `ext_status`) VALUES 
(11, 'Body color door handles', 1, 0),
(12, 'Speed-sensitive variable intermittent windshield wipers w/mist function', 2, 0),
(13, 'UV reducing glass w/dark upper windshield band', 3, 0),
(14, 'Body color pwr mirrors', 4, 0),
(15, 'Halogen headlights', 5, 0),
(16, 'Body-color front/rear splash guards', 6, 0),
(17, 'Body color side molding', 7, 0),
(19, 'Compact spare tire', 9, 0),
(20, '16" x 7.0" alloy wheels', 10, 0),
(21, 'Aftermarket Grille', 11, 0),
(22, 'Alloy Wheels', 12, 0),
(23, 'Bug Deflector', 13, 0),
(24, 'Chrome Wheels', 14, 0),
(25, 'Fog Lights', 15, 0),
(26, 'Keyless Entry', 16, 0),
(27, 'Ground Effects', 17, 0),
(28, 'Hand Painted Pin Striping', 18, 0),
(29, 'Luggage Rack', 19, 0),
(30, 'Official Pace Car/Truck', 20, 0),
(31, 'Plow', 21, 0),
(32, 'Power Antenna', 22, 0),
(33, 'Rain Guard', 23, 0),
(34, 'Rear Spoiler', 24, 0),
(35, 'Simulated Convertible', 25, 0),
(36, 'Spinning Rims', 26, 0),
(37, 'Sunroof', 27, 0),
(38, 'Tinted Glass', 28, 0),
(39, 'T-Tops', 29, 0),
(40, 'Tool box', 30, 0),
(41, 'Black deck lid finisher', 31, 0),
(42, 'Black door handles', 32, 0),
(43, 'Variable intermittent windshield wipers w/mist function', 33, 0),
(44, 'Black manual folding mirrors', 34, 0),
(45, 'Multi-reflector halogen headlamps', 35, 0),
(46, 'Black grille', 36, 0),
(47, 'Body-color front/rear fascia', 37, 0),
(48, 'Body color front/rear bumpers', 38, 0),
(49, '14" x 5.0" steel wheels w/full wheel covers', 39, 0),
(50, 'Chrome door handles', 0, 0),
(51, 'Intermittent rear window wiper w/washer', 0, 0),
(52, 'Folding body-color pwr mirrors', 0, 0),
(53, 'LED rear lights', 0, 0),
(54, 'Brushed aluminum rear bumper protector', 0, 0),
(55, 'Body-color front/rear bumpers', 0, 0),
(56, 'T165/90D18 temporary spare tire located under cargo area floor', 0, 0),
(57, '18" 5-spoke alloy wheels w/center caps', 0, 0),
(58, 'Speed-sensitive variable intermittent windshield wipers', 40, 0),
(59, 'Variable intermittent speed-sensitive flat-blade windshield wipers w/mist function', 41, 0),
(60, 'UV reducing solar glass w/dark upper windshield band', 42, 0),
(61, 'Body color folding pwr mirrors', 43, 0),
(62, 'Auto on/off headlights', 44, 0),
(63, 'Body color bumpers', 45, 0),
(64, 'Front tow hooks', 46, 0),
(65, 'Pwr tilt/sliding moonroof w/sliding sunshade', 47, 0),
(68, '18" x 8.0" fine silver alloy wheels', 48, 0),
(69, 'Halogen headlights w/ambient light sensor', 49, 0),
(70, 'Body side moldings', 50, 1),
(71, 'Bumper color', 51, 1),
(72, 'Door handle color', 52, 1),
(73, 'Exhaust', 53, 1),
(74, 'Exhaust tip color', 54, 1),
(75, 'Grille color', 55, 1),
(76, 'body-color', 56, 1),
(77, 'Mudguards', 57, 1),
(78, 'Headlights', 58, 1),
(79, '2-stage unlocking', 59, 1),
(80, 'Auto-lock', 60, 1),
(81, 'Power door locks', 61, 1),
(82, 'Exterior mirrors', 62, 1),
(83, 'Vanity mirrors', 63, 1),
(84, 'Moonroof Wind Deflecto', 64, 1),
(85, 'Power Sliding Glass Moonroof', 65, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `header_tags`
-- 

CREATE TABLE `header_tags` (
  `head_id` int(11) NOT NULL auto_increment,
  `page_name` varchar(500) NOT NULL,
  `head_title` varchar(1000) NOT NULL,
  `head_desc` varchar(5000) NOT NULL,
  `head_keyword` varchar(2000) NOT NULL,
  `head_subj` varchar(200) NOT NULL,
  `file_banner` varchar(500) NOT NULL,
  PRIMARY KEY  (`head_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `header_tags`
-- 

INSERT INTO `header_tags` (`head_id`, `page_name`, `head_title`, `head_desc`, `head_keyword`, `head_subj`, `file_banner`) VALUES 
(1, 'Partners', 'Partners', 'Partners', 'Partners', 'Partners', ''),
(2, 'FAQ''s', 'FAQs', 'FAQs', 'FAQs', 'FAQs', ''),
(3, 'Photo gallery', 'Photo gallery', 'Photo gallery', 'Photo gallery', 'Photo gallery', ''),
(4, 'Sponsored Racers', 'Sponsored Racers', 'Sponsored Racers', 'Sponsored Racers', 'Sponsored Racers', ''),
(5, 'News', 'News', 'News', 'News', 'News', ''),
(6, 'Testimonials', 'Testimonials', 'Testimonials', 'Testimonials', 'Testimonials', ''),
(7, 'Videos', 'Videos', 'Videos', 'Videos', 'Videos', ''),
(8, 'Callback Request', 'Callback Request', 'Callback Request', 'Callback Request', 'Callback Request', ''),
(9, 'Sitemap', '', '', '', '', ''),
(10, 'Dealer Application', '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `interior`
-- 

CREATE TABLE `interior` (
  `int_id` int(11) NOT NULL auto_increment,
  `int_title` varchar(500) NOT NULL,
  `int_sort` int(11) NOT NULL default '0',
  `int_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`int_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=207 ;

-- 
-- Dumping data for table `interior`
-- 

INSERT INTO `interior` (`int_id`, `int_title`, `int_sort`, `int_status`) VALUES 
(13, 'Rear coat hook', 1, 0),
(14, 'Front/rear assist grips', 2, 0),
(15, 'Chrome-color door handles', 3, 0),
(16, 'Front map lights', 4, 0),
(17, 'Overhead console w/sunglass holder', 5, 0),
(18, 'Interior courtesy lamps-inc: glove box, trunk', 6, 0),
(19, 'Dual sunvisors w/vanity mirrors', 7, 0),
(20, 'Dual 12V DC pwr points', 8, 0),
(21, 'Dual cup holders in rear center armrest', 9, 0),
(22, 'Rear window defroster w/timer', 10, 0),
(23, 'Dual zone auto temp control w/rear-passenger floor vents', 11, 0),
(24, 'Pwr remote trunk release w/cancel switch', 12, 0),
(25, 'Remote hood & fuel-filler door releases', 13, 0),
(26, 'Pwr door locks w/driver & passenger door lock switches, auto-lock feature', 14, 0),
(27, 'Retained accessory pwr', 15, 0),
(28, 'Pwr windows w/driver side auto up/down & auto-reverse w/driver side auto up/down & auto-reverse', 16, 0),
(29, 'Warning lights -inc: door ajar, low fuel, low washer fluid', 17, 0),
(30, 'Trip computer w/outside temp gauge', 18, 0),
(31, 'Instrumentation -inc: hybrid power/charge display, battery state-of-charge, fuel gauges', 19, 0),
(33, 'Vehicle security system', 20, 0),
(34, 'Vehicle immobilizer system', 21, 0),
(35, 'Intelligent Key system', 22, 0),
(36, 'Push-button ignition', 23, 0),
(37, 'Tilt & telescopic steering column w/mounted cruise controls', 24, 0),
(38, 'Floor & trunk carpeting', 25, 0),
(39, 'Coin holder', 26, 0),
(40, 'Triple bottle holders in center console', 27, 0),
(41, 'Front door map pockets', 28, 0),
(42, 'Front console w/integral armrest, storage compartments', 29, 0),
(43, 'Fixed rear bench seat', 30, 0),
(44, '6-way driver/4-way passenger manual seat adjusters', 31, 0),
(45, 'Contoured reclining front bucket seats w/adjustable head restraints', 32, 0),
(46, 'Velour seat trim', 33, 0),
(47, 'Air Conditioning', 34, 0),
(48, 'AM/FM', 35, 0),
(49, 'Carpeting', 36, 0),
(50, 'Cassette', 37, 0),
(51, 'CD', 38, 0),
(52, 'CD Changer', 39, 0),
(53, 'Cigarette Lighter', 40, 0),
(54, 'Climate Control', 41, 0),
(55, 'Clock', 42, 0),
(56, 'Cruise Control', 43, 0),
(57, 'Cup Holders', 44, 0),
(58, 'DVD', 45, 0),
(59, 'Front Bucket Seats', 46, 0),
(60, 'Gauge Cluster', 47, 0),
(61, 'Heated Mirrors', 48, 0),
(62, 'Heated Seats', 49, 0),
(63, 'iPod Compatible', 50, 0),
(64, 'MP3 Player', 51, 0),
(66, 'Navigation System', 52, 0),
(67, 'Power Door Locks', 53, 0),
(68, 'Power Driver Seat', 54, 0),
(69, 'Power Memory Seat', 55, 0),
(70, 'Power Mirrors', 56, 0),
(71, 'Power Passenger Seat', 57, 0),
(72, 'Power Windows', 58, 0),
(73, 'Rear Air', 59, 0),
(74, 'Rear Defrost', 60, 0),
(75, 'Sirius Satellite Radio', 61, 0),
(76, 'Suede', 62, 0),
(77, 'Telescope Steering Column', 63, 0),
(78, 'Television', 64, 0),
(79, 'Tilt Steering', 65, 0),
(80, 'Vanity Mirror', 66, 0),
(81, 'VCR', 67, 0),
(82, 'Wood Dash', 68, 0),
(83, 'XM Satellite Radio', 69, 0),
(84, 'Rear parcel shelf', 70, 0),
(85, '"Reddish orange" interior illumination', 71, 0),
(86, 'Carpeted floor & cargo area', 72, 0),
(87, 'Front & rear passenger folding assist grips', 73, 0),
(88, 'Driver & front passenger map pockets', 74, 0),
(89, 'Door armrests', 75, 0),
(90, '12V pwr outlet', 76, 0),
(91, '12V pwr outlet', 76, 0),
(92, 'Immobilizer system', 77, 0),
(93, 'Remote fuel lid release', 78, 0),
(94, 'Pwr windows', 79, 0),
(95, 'Pwr door locks -inc: auto-lock', 80, 0),
(96, 'Fasten seat belt warning light/chime', 81, 0),
(97, 'Tachometer', 82, 0),
(98, 'Black IP trim finisher', 83, 0),
(99, 'Tilt steering column', 84, 0),
(100, 'Dual front & rear cup holders', 85, 0),
(101, 'Suede-tricot seat trim', 86, 0),
(102, 'Rear bench seat', 87, 0),
(103, '4-way manual adjustable passenger seat', 88, 0),
(104, '4-way manual driver seat', 89, 0),
(105, 'Reclining front bucket seats w/active adjustable headrests', 90, 0),
(106, 'Manual rear trunk release', 91, 0),
(107, 'Front seatback pockets', 0, 0),
(108, 'shift knob', 0, 0),
(110, 'Mood lighting', 0, 0),
(111, '2nd row reading lights', 0, 0),
(112, '1st row map lights', 0, 0),
(113, '(2) coat hooks', 0, 0),
(114, '(4) assist grips', 0, 0),
(115, 'Driver/front passenger visors w/extenders & illuminated vanity mirrors', 0, 0),
(116, 'Manual day/night rearview mirror', 0, 0),
(117, 'Metallic trim accents', 0, 0),
(118, '(3) 12-volt pwr outlets', 0, 0),
(119, '(4) cup holders', 0, 0),
(120, 'Front door map pockets', 0, 0),
(121, 'Rear window defroster', 0, 0),
(122, 'Rear HVAC vents', 0, 0),
(123, 'Air conditioning w/dual zone automatic temperature control & microfilter', 0, 0),
(124, 'Cruise control w/steering wheel controls', 0, 0),
(125, 'Remote keyless entry', 0, 0),
(126, 'Pwr fuel door release', 0, 0),
(127, 'Pwr door locks w/speed-sensitive auto lock, selective unlock feature', 0, 0),
(128, 'Pwr windows w/front one-touch up/down & safety reverse feature', 0, 0),
(129, 'Trip computer', 0, 0),
(130, 'Immobilizer system', 0, 0),
(131, 'Steering wheel cruise controls', 0, 0),
(132, 'Manual tilt/telescopic steering column', 0, 0),
(133, 'Full carpeting', 0, 0),
(134, 'Seat trim', 0, 0),
(135, '60/40 flat-fold reclining rear bench seat w/adjustable head restraints', 0, 0),
(136, '4-way manual passenger seat', 0, 0),
(137, '6-way manual driver seat w/manual lumbar support', 0, 0),
(138, 'Front bucket seats w/adjustable active head restraints', 0, 0),
(139, 'Rear seat coat hanger', 92, 0),
(140, 'Front/rear passenger assist grips', 93, 0),
(141, 'Driver/front passenger seatback pockets', 94, 0),
(142, 'wrapped shift knob', 95, 0),
(143, 'Rear reading lights', 96, 0),
(144, 'Front map lights', 97, 0),
(145, 'Lighting -inc: front/rear step lamps, foot well lamps, front floor lamp, trunk, mood light', 98, 0),
(146, 'Illuminated entry system w/fade-out', 99, 0),
(147, 'Sun visor extensions', 100, 0),
(148, 'Dual illuminated visor vanity mirrors', 101, 0),
(149, 'Overhead console -inc: sunglass holder', 102, 0),
(150, 'Auto-dimming rearview mirror', 103, 0),
(151, 'Front door map pockets/bottle holders', 104, 0),
(152, 'Chrome interior door handles', 105, 0),
(153, 'Piano dot interior trim', 106, 0),
(154, 'door trim inserts', 107, 0),
(155, '(2) 12V pwr outlets', 108, 0),
(156, 'Front & rear dual cup holders', 109, 0),
(157, 'Lockable illuminated glove box w/damper & pen holder', 110, 0),
(158, 'Rear window defroster w/timer', 111, 0),
(159, 'Rear air conditioning vents', 112, 0),
(160, 'Dual zone automatic temp control w/in-cabin microfilter', 113, 0),
(161, 'Remote hood/trunk/fuel-filler door releases', 114, 0),
(162, 'Cruise control w/steering wheel mounted illuminated controls', 115, 0),
(163, 'Illuminated ignition keyhole', 116, 0),
(164, 'Intelligent Key push-button ignition', 117, 0),
(165, 'Vehicle security system', 118, 0),
(166, 'Remote keyless entry w/trunk release & window down', 119, 0),
(167, 'Illuminated pwr accessory switches', 120, 0),
(168, 'Pwr door locks w/auto-lock', 121, 0),
(169, 'Retained accessory pwr', 122, 0),
(170, 'Pwr windows -inc: driver & passenger auto up/down feature, key cylinder up/down, anti-pinch', 123, 0),
(171, 'Vehicle information system', 124, 0),
(172, 'Dual LCD trip odometers', 125, 0),
(173, 'Multi function trip computer -inc: 2.7" dot matrix display, digital clock, outside temp display, distance to empty, average fuel consumption/speed, driving time, maintenance intervals, warning indicator, illumination control, instantaneous fuel consumption', 126, 0),
(174, 'Warning lights -inc: fuel level, door ajar, oil pressure, windshield washer fluid', 127, 0),
(175, 'Daytime illumination meters -inc: speedometer, tachometer, water temp', 128, 0),
(176, 'wrapped steering wheel', 129, 0),
(177, 'Tilt/telescopic steering column', 130, 0),
(178, 'Full floor & trunk carpeting', 131, 0),
(179, 'Center console w/coin holder, cellular phone compartment', 132, 0),
(180, 'Front/rear adjustable head restraints', 133, 0),
(181, '60/40 split fold-down rear bench seat -inc: center armrest', 134, 0),
(183, 'Front bucket seats', 135, 0),
(184, '4-way pwr passenger seat', 136, 0),
(185, '8-way pwr driver seat -inc: manual lumbar support', 137, 0),
(186, 'seat trim', 138, 0),
(187, 'Reading lights', 139, 1),
(188, 'Center console', 140, 1),
(189, 'Cupholders', 141, 1),
(190, 'Door pockets', 142, 1),
(191, 'Front power outlet', 143, 1),
(192, 'Power outlet(s)', 144, 1),
(193, 'Overhead console', 145, 1),
(194, 'Driver Seat', 146, 1),
(195, 'Adjustable lumbar support', 147, 1),
(196, 'Height adjustable', 148, 1),
(197, 'Manual adjustments', 149, 1),
(198, 'Adjustable rear headrests', 150, 1),
(199, 'Front headrests', 151, 1),
(200, 'Number of front headrests', 152, 1),
(201, 'Center armrest', 153, 1),
(202, 'Folding', 154, 1),
(203, 'Rear heat', 155, 1),
(204, 'Rear center seatbelt', 156, 1),
(205, 'Front Suspension Type', 157, 1),
(206, 'Front Suspension Type', 157, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `inventory_date`
-- 

CREATE TABLE `inventory_date` (
  `inv_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `inv_date` varchar(200) NOT NULL,
  PRIMARY KEY  (`inv_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `inventory_date`
-- 

INSERT INTO `inventory_date` (`inv_id`, `vehicle_id`, `inv_date`) VALUES 
(1, 3, '10-25-2011'),
(2, 2, '10-25-2011');

-- --------------------------------------------------------

-- 
-- Table structure for table `mechanical`
-- 

CREATE TABLE `mechanical` (
  `mech_id` int(11) NOT NULL auto_increment,
  `mech_title` varchar(500) NOT NULL,
  `mech_sort` int(11) NOT NULL default '0',
  `mech_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`mech_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

-- 
-- Dumping data for table `mechanical`
-- 

INSERT INTO `mechanical` (`mech_id`, `mech_title`, `mech_sort`, `mech_status`) VALUES 
(4, 'Dual chrome-tipped exhaust finishers', 1, 0),
(5, 'Integrated regenerative braking', 2, 0),
(6, 'Pwr front vented & rear solid disc brakes', 3, 0),
(7, 'Electric pwr vehicle speed-sensitive rack & pinion steering', 4, 0),
(8, 'Independent multi-link rear suspension w/stabilizer bar', 5, 0),
(9, 'Independent front strut suspension w/stabilizer bar', 6, 0),
(10, 'Battery-saver timing device', 7, 0),
(11, 'Front wheel drive', 8, 0),
(12, '244.8V nickel metal hydride (NiMH) hybrid battery', 9, 0),
(13, 'Hybrid system power', 10, 0),
(14, 'Dual Exhaust', 11, 0),
(15, 'Remote Start', 12, 0),
(16, 'Turbocharged', 13, 0),
(17, 'Pwr front vented disc/rear drum brakes', 14, 0),
(18, 'Electric speed-sensitive variable-assist pwr steering', 15, 0),
(19, 'Torsion beam rear suspension w/stabilizer bar', 16, 0),
(20, 'Independent strut front suspension w/stabilizer bar', 17, 0),
(21, 'Battery saver', 18, 0),
(22, 'Stainless steel dual exhaust system w/chrome finishers', 0, 0),
(23, '4-wheel vented disc brakes', 0, 0),
(24, 'Speed-sensitive pwr rack & pinion steering', 0, 0),
(25, 'Front/rear stabilizer bars', 0, 0),
(26, 'Front tow hook', 0, 0),
(27, 'All-wheel drive', 0, 0),
(28, 'Push button ignition', 0, 0),
(29, 'Double-tipped platinum spark plugs', 0, 0),
(30, 'Variable valve timing (CVTCS)', 0, 0),
(31, 'Dual chrome exhaust finishers', 19, 0),
(32, 'Pwr 4-wheel vented disc brakes', 20, 0),
(33, 'Speed-sensitive variable-assist pwr rack & pinion steering', 21, 0),
(34, 'Front & rear stabilizer bars', 22, 0),
(35, 'Independent multi-link rear suspension w/coil springs', 23, 0),
(36, 'Independent strut front suspension w/coil springs', 24, 0),
(37, 'Electronically controlled "drive-by-wire" throttle', 25, 0),
(38, 'Continuous Variable Valve Timing Control (CVVTS)', 26, 0),
(39, 'Vehicle-speed-sensitive pwr rack-and-pinion steering', 27, 0),
(40, 'Multi-leaf rear suspension', 28, 0),
(41, 'Front independent suspension', 29, 0),
(42, 'Rear wheel drive', 30, 0),
(43, 'engine brand', 31, 1),
(44, 'aspiration', 32, 1),
(45, 'Block Type', 33, 1),
(46, 'bore', 34, 1),
(47, 'Cam Type', 35, 1),
(48, 'compression', 36, 1),
(49, 'displacement', 37, 1),
(50, 'Fuel Induction', 38, 1),
(51, 'Fuel Quality', 39, 1),
(52, 'Fuel Type', 40, 1),
(53, 'Max HP', 41, 1),
(54, 'Max hp at', 42, 1),
(55, 'Max Payload', 43, 1),
(56, 'Max Torque', 44, 1),
(57, 'Max torque at', 45, 1),
(58, 'Oil Capacity', 46, 1),
(59, 'Redline', 47, 1),
(60, 'Stroke', 48, 1),
(61, 'Valve Timing', 49, 1),
(62, 'Valves', 50, 1),
(63, 'Battery saver', 51, 1),
(64, 'Direct Ignition System', 52, 1),
(65, 'Electric Motor Battery Type', 53, 1),
(66, 'Electric Motor HP', 54, 1),
(67, 'Electric Motor HP @ RPM', 55, 1),
(68, 'Electric Motor Power Output (Kilowatts)', 56, 1),
(69, 'Electric Motor Torque', 57, 1),
(70, 'Electric Motor Type', 58, 1),
(71, 'Hybrid Gas Engine HP', 59, 1),
(72, 'Spark Plugs', 60, 1),
(73, 'Warnings and reminder', 61, 1),
(74, 'Front Spring Type', 62, 1),
(75, 'Front Suspension Classification', 63, 1),
(76, 'Front Suspension Type', 64, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `models`
-- 

CREATE TABLE `models` (
  `model_id` int(11) NOT NULL auto_increment,
  `model_title` varchar(500) NOT NULL,
  `model_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`model_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

-- 
-- Dumping data for table `models`
-- 

INSERT INTO `models` (`model_id`, `model_title`, `model_sort`) VALUES 
(19, '200SX', 1),
(20, '240SX', 2),
(21, '300ZX', 3),
(22, '350Z', 4),
(23, '370Z', 5),
(24, 'Altima', 6),
(25, 'Armada', 7),
(26, 'Axxess', 8),
(27, 'Cab & Chassis', 9),
(28, 'Cube', 10),
(29, 'Frontier', 11),
(30, 'Frontier 2WD', 12),
(31, 'Frontier 4WD', 13),
(32, 'GT-R', 14),
(33, 'Hardbody', 15),
(34, 'Hardbody 2WD', 16),
(35, 'Hardbody 4WD', 17),
(36, 'Hardbody King Cab', 18),
(37, 'Hardbody King Cab 2WD', 19),
(38, 'Hardbody King Cab 4WD', 20),
(39, 'Heavy Duty', 21),
(40, 'JUKE', 22),
(41, 'King Cab 2WD', 23),
(42, 'King Cab 4WD', 24),
(43, 'Long Bed', 25),
(44, 'Long Bed 2WD', 26),
(45, 'Long Bed 4WD', 27),
(46, 'Maxima', 28),
(47, 'Murano', 29),
(48, 'Murano Cross Cabriolet', 30),
(49, 'NV', 31),
(50, 'NX', 32),
(51, 'Pathfinder', 33),
(52, 'Pathfinder Armada', 34),
(53, 'Pulsar Nx', 35),
(54, 'Quest', 36),
(55, 'Regular Bed', 37),
(56, 'Regular Bed 2WD', 38),
(57, 'Regular Bed 4WD', 39),
(58, 'Rouge', 40),
(59, 'Sentra', 41),
(60, 'Stanza', 42),
(61, 'Titan', 43),
(62, 'Trucks 2WD', 44),
(63, 'Trucks 4WD', 45),
(64, 'Van ', 46),
(65, 'Versa', 47),
(66, 'Xterra', 48);

-- --------------------------------------------------------

-- 
-- Table structure for table `pages`
-- 

CREATE TABLE `pages` (
  `page_id` int(5) NOT NULL auto_increment,
  `page_title` varchar(255) NOT NULL,
  `page_heading` varchar(255) NOT NULL,
  `page_desc` mediumblob NOT NULL,
  `page_image` varchar(500) NOT NULL,
  `seo_title` varchar(1000) NOT NULL,
  `seo_keywords` varchar(2000) NOT NULL,
  `seo_desc` varchar(5000) NOT NULL,
  `seo_subject` varchar(200) NOT NULL,
  PRIMARY KEY  (`page_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

-- 
-- Dumping data for table `pages`
-- 

INSERT INTO `pages` (`page_id`, `page_title`, `page_heading`, `page_desc`, `page_image`, `seo_title`, `seo_keywords`, `seo_desc`, `seo_subject`) VALUES 
(36, 'Contact Us (Left)', 'Contact Us', 0x3c6469762069643d226c6f636174657232223e0d0a3c68323e3c7370616e207374796c653d22636f6c6f723a20236265323032663b223e4e697373616e206f662047617264656e20436974793c2f7370616e3e3c2f68323e0d0a333136204e2e204672616e6b6c696e205374726565743c6272202f3e2048656d7073746561642c204e657720596f726b2031313535303c6272202f3e202838383829203433332d3437383020203c6272202f3e3c6272202f3e3c2f6469763e0d0a3c6469762069643d226c6f636174657232223e0d0a3c68333e4f7572204465706172746d656e74733c2f68333e0d0a3c2f6469763e0d0a3c6469762069643d226c6f636174657232223e0d0a3c6469762069643d22636e7463745f6e756d626572223e3c7374726f6e673e4e65772053616c65733c2f7374726f6e673e3c6272202f3e202838383829203433332d343738303c2f6469763e0d0a3c6469762069643d22636e7463745f6e756d626572223e3c7374726f6e673e5072652d6f776e65642073616c65733c2f7374726f6e673e3c6272202f3e202838383829203433332d343738303c2f6469763e0d0a3c6469762069643d22636e7463745f6e756d626572223e3c7374726f6e673e536572766963653c2f7374726f6e673e3c6272202f3e202838383829203232392d333635333c2f6469763e0d0a3c6469762069643d22636e7463745f6e756d626572223e3c7374726f6e673e50617274733c2f7374726f6e673e3c6272202f3e202838383829203232392d333730313c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d226c6f636174657232223e0d0a3c68343e496620796f752070726566657220746f20652d6d61696c2075732c20706c6561736520636f6d706c6574652074686520666f6c6c6f77696e6720666f726d20616e64206120726570726573656e7461746976652077696c6c20636f6e7461637420796f7520617320736f6f6e20617320706f737369626c652e20496620796f75206e65656420696d6d65646961746520617373697374616e63652c20706c656173652063616c6c203c7370616e20636c6173733d22626f6c64223e3838382d3433332d343738302e3c2f7370616e3e3c2f68343e0d0a3c2f6469763e, '', '', '', '', ''),
(37, 'Contact Us (Right)', 'Promotions', 0x3c6469762069643d2273686f77726f6f6d5f61726561223e0d0a3c6469762069643d22677265795f68656164696e67223e3c7374726f6e673e53686f77726f6f6d3c2f7374726f6e673e3c6272202f3e203838382e3433332e343738303c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4d6f6e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5475653a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5765643a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5468753a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4672693a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5361743a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e53756e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e31313a303061202d20363a3030703c2f6469763e0d0a3c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22736572766963655f61726561223e0d0a3c6469762069643d22677265795f68656164696e67223e3c7374726f6e673e536572766963653c2f7374726f6e673e3c6272202f3e203838382e3232392e333635333c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4d6f6e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5475653a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5765643a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5468753a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4672693a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5361743a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e53756e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e436c6f7365643c2f6469763e0d0a3c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d2270617274735f61726561223e0d0a3c6469762069643d22677265795f68656164696e67223e3c7374726f6e673e50617274733c2f7374726f6e673e3c6272202f3e203838382e3433332e333730313c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4d6f6e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5475653a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5765643a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5468753a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e4672693a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e5361743a3c2f6469763e0d0a3c6469762069643d2274696d65223e393a303061202d20393a3030703c2f6469763e0d0a3c2f6469763e0d0a3c6469762069643d22646179735f6d656e75223e0d0a3c6469762069643d2264617973223e53756e3a3c2f6469763e0d0a3c6469762069643d2274696d65223e436c6f7365643c2f6469763e0d0a3c2f6469763e0d0a3c2f6469763e, '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `safety`
-- 

CREATE TABLE `safety` (
  `safe_id` int(11) NOT NULL auto_increment,
  `safe_title` varchar(500) NOT NULL,
  `safe_sort` int(11) NOT NULL default '0',
  `safe_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`safe_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;

-- 
-- Dumping data for table `safety`
-- 

INSERT INTO `safety` (`safe_id`, `safe_title`, `safe_sort`, `safe_status`) VALUES 
(12, 'Tire pressure monitoring system (TPMS)', 1, 0),
(13, 'Emergency inside trunk release', 2, 0),
(14, 'Energy absorbing steering column', 3, 0),
(15, 'Child restraint upper anchors', 4, 0),
(16, 'Lower anchors & tethers for children (LATCH)', 5, 0),
(17, 'Child safety rear door locks', 6, 0),
(18, 'Front seat active head restraints', 7, 0),
(19, 'ALR/ELR seat belt system for passenger seating positions', 8, 0),
(20, 'ELR seat belt system for driver seating position', 9, 0),
(21, '3-point seat belts in all seating positions', 10, 0),
(22, 'Front seat belts w/pretensioners, load limiters, adjustable upper anchors, seat belt sensors', 11, 0),
(23, 'Front/rear roof mounted side curtain airbags', 12, 0),
(24, 'Front side-impact airbags', 13, 0),
(26, 'Driver & passenger supplemental dual-stage front airbags w/occupant classification sensor', 14, 0),
(27, 'Zone body construction', 15, 0),
(28, 'Side-door guard beams', 16, 0),
(29, 'Front & rear crumple zones', 17, 0),
(30, '2.5 mph energy absorbing front/rear bumpers', 18, 0),
(31, 'Vehicle dynamic control', 19, 0),
(32, 'Traction control system (TCS)', 20, 0),
(33, 'Electronic brake force distribution', 21, 0),
(34, 'Anti-lock braking system', 22, 0),
(35, 'Shift interlock', 23, 0),
(36, 'Brake assist', 24, 0),
(37, 'Alarm System', 25, 0),
(38, 'Drivers Side Airbag', 26, 0),
(39, 'OnStar', 27, 0),
(40, 'Passenger Side Airbag', 28, 0),
(41, 'Rear Passenger Airbag', 29, 0),
(42, 'Roll Bar', 30, 0),
(43, 'Side Impact Airbag', 31, 0),
(44, 'Traction Control', 32, 0),
(45, 'Rear child seat tether anchors (LATCH)', 33, 0),
(46, '3-point ELR/ALR rear seat belts at all positions', 34, 0),
(47, '3-point ELR/ALR front passenger seat belt w/pretensioner & load limiter', 35, 0),
(48, '3-point ELR driver seat belt w/pretensioner & load limiter', 36, 0),
(49, 'Front & rear side curtain airbags', 37, 0),
(50, 'Dual-stage front airbags w/occupant classification system', 38, 0),
(51, 'Zone body construction -inc: front/rear crumple zones, hood deformation point', 39, 0),
(52, 'Steel side-door impact beams', 40, 0),
(53, 'Energy absorbing front/rear bumpers', 41, 0),
(54, 'Clutch interlock', 42, 0),
(55, 'Active head restraints', 0, 0),
(56, 'Tire pressure monitor', 43, 0),
(58, '(2) child seat anchors', 44, 0),
(59, 'Front seat belt pretensioners & load limiters', 45, 0),
(60, '3-point ELR seat belts all seating positions', 46, 0),
(61, 'Active head restraints', 47, 0),
(62, 'Roof-mounted side curtain airbags for all rows w/rollover sensor', 48, 0),
(63, 'Front seat-mounted side-impact airbags', 49, 0),
(64, 'Driver & front passenger dual stage airbags w/occupancy sensor', 50, 0),
(65, 'Vehicle dynamic control system (VDC) -inc: 4-wheel limited slip (ABLS)', 51, 0),
(66, 'Electronic brake force distribution (EBD) & brake assist (BA)', 52, 0),
(68, 'Active front head restraints', 54, 0),
(69, 'Lower anchor & tethers for children (LATCH)', 55, 0),
(70, 'Passenger window lockout', 56, 0),
(71, 'All position 3-point seat belts', 57, 0),
(73, 'ALR/ELR seat belt system for all passengers', 58, 0),
(74, 'ELR seat belt system for driver', 59, 0),
(75, 'Front seat belts w/pretensioners/load limiters/adjustable anchors', 60, 0),
(76, 'Front & rear roof mounted curtain side-impact airbags', 61, 0),
(77, 'Driver & front passenger side-impact airbags', 62, 0),
(78, 'Driver & front passenger dual-stage airbags w/seat belt sensors', 63, 0),
(79, 'Steel side-door guard beams', 64, 0),
(80, 'Vehicle dynamic control', 65, 0),
(81, 'Brake assist & electronic brake force distribution (EBD)', 66, 0),
(82, '4-wheel anti-lock braking system (ABS)', 67, 0),
(83, 'Brakes', 68, 1),
(84, 'ABS', 69, 1),
(85, 'Electronic brakeforce distribution', 70, 1),
(86, 'Braking assist', 71, 1),
(87, 'Front brake diamete', 72, 1),
(88, 'Front brake width', 73, 1),
(89, 'Front brake', 74, 1),
(90, 'Rear brake diameter', 75, 1),
(91, 'Rear brake width', 76, 1),
(92, 'Rear brakes', 77, 1),
(93, 'Child safety locks', 78, 1),
(94, 'Child seat anchors', 79, 1),
(95, 'Emergency interior trunk release', 80, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_gallery`
-- 

CREATE TABLE `tbl_gallery` (
  `recid` int(11) NOT NULL auto_increment,
  `image` varchar(255) default NULL,
  `link` varchar(255) default NULL,
  PRIMARY KEY  (`recid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `tbl_gallery`
-- 

INSERT INTO `tbl_gallery` (`recid`, `image`, `link`) VALUES 
(12, 'gal_1.jpg', 'www.nissanofgardencity.com/value-trade.php');

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicles`
-- 

CREATE TABLE `vehicles` (
  `vehicle_id` int(11) NOT NULL auto_increment,
  `vin` varchar(200) NOT NULL,
  `year` varchar(200) NOT NULL,
  `make` int(11) NOT NULL,
  `models` varchar(200) NOT NULL,
  `v_style` varchar(200) NOT NULL,
  `stock_no` varchar(200) NOT NULL,
  `status` int(11) NOT NULL default '0',
  `new_pre` varchar(200) NOT NULL,
  `v_engine` varchar(255) NOT NULL,
  `v_trans` varchar(255) NOT NULL,
  `v_drive` varchar(255) NOT NULL,
  `tagline` varchar(255) NOT NULL,
  `tagline_price` varchar(255) NOT NULL,
  `option_class1` int(11) NOT NULL,
  `option_class2` varchar(255) NOT NULL,
  `option_class3` varchar(255) NOT NULL,
  `option_class4` varchar(255) NOT NULL,
  `option_class5` varchar(255) NOT NULL,
  `lock_vehicle` int(11) NOT NULL,
  `ext_color1` varchar(255) NOT NULL,
  `int_color` varchar(255) NOT NULL,
  `int_material` varchar(255) NOT NULL,
  `body_style` varchar(255) NOT NULL,
  `milage` varchar(255) NOT NULL,
  `retail_price` varchar(255) NOT NULL,
  `special_price` varchar(255) NOT NULL,
  `certified` varchar(255) NOT NULL,
  `is_special` varchar(255) NOT NULL,
  `l_o_s` varchar(255) NOT NULL,
  `disclaimer` varchar(4000) NOT NULL,
  `gm_cert` varchar(255) NOT NULL,
  `internal_price` varchar(255) NOT NULL,
  `int_notes` varchar(255) NOT NULL,
  `comments` varchar(4000) NOT NULL,
  `autotrader` int(11) NOT NULL,
  `cars` int(11) NOT NULL,
  `featured` enum('No','Yes') default 'No',
  `wsize` varchar(255) NOT NULL,
  `bsize` varchar(255) NOT NULL,
  `vin_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vehicle_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

-- 
-- Dumping data for table `vehicles`
-- 

INSERT INTO `vehicles` (`vehicle_id`, `vin`, `year`, `make`, `models`, `v_style`, `stock_no`, `status`, `new_pre`, `v_engine`, `v_trans`, `v_drive`, `tagline`, `tagline_price`, `option_class1`, `option_class2`, `option_class3`, `option_class4`, `option_class5`, `lock_vehicle`, `ext_color1`, `int_color`, `int_material`, `body_style`, `milage`, `retail_price`, `special_price`, `certified`, `is_special`, `l_o_s`, `disclaimer`, `gm_cert`, `internal_price`, `int_notes`, `comments`, `autotrader`, `cars`, `featured`, `wsize`, `bsize`, `vin_status`) VALUES 
(5, '1N4CL21E69C181956', '2009', 0, '24', '4dr Sdn I4 eCVT Hybrid', 'UN19447', 0, 'Pre-Owned', '2.5L', '0', '0', '', '', 0, '', '', '', '', 0, 'Dark Slate Metallic', 'Charcoal', 'Cloth', '4dr Car', '45073', '0.00', '0.00', 'no', 'no', 'no', '', '', '', '', '', 0, 0, 'No', '', '', 0),
(6, '3N1CC1AP5BL450659', '2011', 1, '65', '4dr Sdn I4 Manual 1.6 Base', 'UN19845', 0, 'Pre-Owned', '1.6L', '3', '0', '', '', 0, '', '', '', '', 0, 'Super Black', 'Deep Sapphire', 'Cloth', '4dr Car', '18423', '152687.00', '0.00', 'no', 'no', 'no', '', '', '', '', '', 0, 0, 'Yes', '', '', 0),
(8, 'JN8AZ18W19W128125', '2009', 2, '47', 'AWD 4dr S', 'UN19883', 0, 'Pre-Owned', '3.5L', '0', '2', '', '', 0, '', '', '', '', 0, 'Merlot', 'Deep Sapphire', 'Leather', 'Sport Utility', '33480', '45632.00', '0.00', 'no', 'no', 'no', 'dfdsfsdfsfsdf', '', '', '', 'ASDASDASDASDASDASDASDAS', 0, 0, 'No', '18', '14', 0),
(9, '1N4AA5AP9BC818053', '2011', 1, '46', '4dr Sdn V6 CVT 3.5 S', 'UN19860', 0, 'Pre-Owned', '3.5L', '0', '0', '', '', 0, '', '', '', '', 0, 'Metallic Slate', 'Deep Sapphire', 'Cloth', '4dr Car', '31629', '123456.00', '123000.00', 'no', 'no', 'no', '', '', '', '', '', 0, 0, 'No', '17', '17', 0),
(10, '1N6AD0ER0BC401207', '2011', 1, '29', '2WD Crew Cab SWB Auto SV', 'UN19860', 0, 'Pre-Owned', '4.0L', '0', '1', '', '', 0, '', '', '', '', 0, 'Radiant Silver', 'Deep Sapphire', 'Cloth', 'Crew Cab Pickup', '20982', '23456.00', '0.00', 'no', 'no', 'no', '', '', '', '', '', 0, 0, 'No', '17', '17', 0),
(32, '1N4AA5AP9BC818053', '2011', 1, '46', 'AWD 4dr SL', 'UN19645', 0, 'Pre-Owned', ' 3.5L V6 290hp 261ft. lbs.', '2', '3', 'ASDFDASF', '', 0, '', '', '', '', 0, 'Deep Sapphire', 'Deep Sapphire', 'Vinyl', '4dr Car', '10558', '321456.00', '321000.00', 'yes', 'no', 'no', 'SDGDFGDFGDFGDFGFDG', 'DFGDF', '445485', 'SDGDFGDFGDFGDFGFDGSDGDFGDFGDFGDFGFDG', 'SDGDFGDFGDFGDFGFDGSDGDFGDFG\r\nDFGDFGFDGSDGDFGDFGDFGDFGFDG\r\nSDGDFGDFGDFGDFGFDGSDGDFGDFG\r\nDFGDFGFDGSDGDFGDFGDFGDFGFDG\r\nSDGDFGDFGDFGDFGFDG', 0, 0, 'No', '', '', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_equip`
-- 

CREATE TABLE `vehicle_2_equip` (
  `v2e_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `equip_id` int(11) NOT NULL,
  PRIMARY KEY  (`v2e_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=835 ;

-- 
-- Dumping data for table `vehicle_2_equip`
-- 

INSERT INTO `vehicle_2_equip` (`v2e_id`, `vehicle_id`, `equip_id`) VALUES 
(21, 0, 1),
(22, 0, 11),
(295, 5, 16),
(296, 5, 18),
(297, 5, 19),
(298, 5, 20),
(299, 5, 21),
(300, 5, 22),
(301, 5, 23),
(302, 5, 24),
(303, 5, 25),
(304, 5, 26),
(305, 5, 27),
(306, 5, 28),
(307, 5, 31),
(308, 5, 32),
(309, 5, 34),
(310, 5, 36),
(311, 5, 37),
(312, 5, 38),
(313, 5, 40),
(314, 5, 41),
(315, 5, 42),
(316, 5, 43),
(317, 5, 44),
(741, 10, 16),
(742, 10, 18),
(743, 10, 19),
(744, 10, 20),
(745, 10, 21),
(746, 10, 23),
(747, 10, 24),
(748, 10, 26),
(749, 10, 27),
(750, 10, 28),
(751, 10, 34),
(752, 10, 36),
(753, 10, 37),
(754, 10, 38),
(755, 10, 40),
(756, 10, 41),
(757, 10, 42),
(758, 10, 43),
(759, 10, 44),
(760, 10, 45),
(761, 10, 57),
(762, 10, 58),
(763, 10, 59),
(764, 10, 60),
(765, 9, 47),
(766, 9, 16),
(767, 9, 18),
(768, 9, 19),
(769, 9, 20),
(770, 9, 21),
(771, 9, 22),
(772, 9, 23),
(773, 9, 24),
(774, 9, 25),
(775, 9, 26),
(776, 9, 27),
(777, 9, 28),
(778, 9, 31),
(779, 9, 34),
(780, 9, 36),
(781, 9, 37),
(782, 9, 38),
(783, 9, 40),
(784, 9, 43),
(785, 9, 44),
(786, 9, 45),
(787, 9, 48),
(788, 9, 50),
(789, 9, 51),
(790, 9, 52),
(791, 9, 53),
(792, 9, 54),
(793, 9, 55),
(794, 9, 56),
(795, 8, 47),
(796, 8, 16),
(797, 8, 18),
(798, 8, 19),
(799, 8, 20),
(800, 8, 21),
(801, 8, 22),
(802, 8, 23),
(803, 8, 24),
(804, 8, 25),
(805, 8, 26),
(806, 8, 27),
(807, 8, 36),
(808, 8, 37),
(809, 8, 38),
(810, 8, 40),
(811, 8, 41),
(812, 8, 42),
(813, 8, 43),
(814, 8, 44),
(815, 8, 45),
(816, 8, 48),
(817, 8, 49),
(818, 8, 50),
(819, 8, 51),
(820, 6, 19),
(821, 6, 23),
(822, 6, 26),
(823, 6, 28),
(824, 6, 31),
(825, 6, 34),
(826, 6, 36),
(827, 6, 37),
(828, 6, 38),
(829, 6, 40),
(830, 6, 41),
(831, 6, 42),
(832, 6, 44),
(833, 6, 45),
(834, 6, 46);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_ext`
-- 

CREATE TABLE `vehicle_2_ext` (
  `v2ext_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `ext_id` int(11) NOT NULL,
  PRIMARY KEY  (`v2ext_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=290 ;

-- 
-- Dumping data for table `vehicle_2_ext`
-- 

INSERT INTO `vehicle_2_ext` (`v2ext_id`, `vehicle_id`, `ext_id`) VALUES 
(15, 0, 1),
(128, 5, 11),
(129, 5, 12),
(130, 5, 13),
(131, 5, 14),
(132, 5, 15),
(133, 5, 16),
(134, 5, 17),
(135, 5, 19),
(136, 5, 20),
(259, 9, 50),
(260, 9, 19),
(261, 9, 59),
(262, 9, 60),
(263, 9, 61),
(264, 9, 62),
(265, 9, 63),
(266, 9, 64),
(267, 9, 65),
(268, 9, 68),
(269, 9, 69),
(270, 8, 57),
(271, 8, 56),
(272, 8, 55),
(273, 8, 54),
(274, 8, 53),
(275, 8, 52),
(276, 8, 51),
(277, 8, 50),
(278, 8, 12),
(279, 8, 15),
(280, 6, 19),
(281, 6, 41),
(282, 6, 42),
(283, 6, 43),
(284, 6, 44),
(285, 6, 45),
(286, 6, 46),
(287, 6, 47),
(288, 6, 48),
(289, 6, 49);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_int`
-- 

CREATE TABLE `vehicle_2_int` (
  `v2i_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `int_id` int(11) NOT NULL,
  PRIMARY KEY  (`v2i_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=736 ;

-- 
-- Dumping data for table `vehicle_2_int`
-- 

INSERT INTO `vehicle_2_int` (`v2i_id`, `vehicle_id`, `int_id`) VALUES 
(23, 0, 1),
(189, 5, 13),
(190, 5, 14),
(191, 5, 15),
(192, 5, 16),
(193, 5, 17),
(194, 5, 18),
(195, 5, 19),
(196, 5, 20),
(197, 5, 21),
(198, 5, 22),
(199, 5, 23),
(200, 5, 24),
(201, 5, 25),
(202, 5, 26),
(203, 5, 27),
(204, 5, 28),
(205, 5, 29),
(206, 5, 30),
(207, 5, 31),
(208, 5, 33),
(209, 5, 34),
(210, 5, 35),
(211, 5, 36),
(212, 5, 37),
(213, 5, 38),
(214, 5, 39),
(215, 5, 40),
(216, 5, 41),
(217, 5, 42),
(218, 5, 43),
(219, 5, 44),
(220, 5, 45),
(221, 5, 46),
(632, 9, 130),
(633, 9, 139),
(634, 9, 140),
(635, 9, 141),
(636, 9, 142),
(637, 9, 143),
(638, 9, 144),
(639, 9, 145),
(640, 9, 146),
(641, 9, 147),
(642, 9, 148),
(643, 9, 149),
(644, 9, 150),
(645, 9, 151),
(646, 9, 152),
(647, 9, 153),
(648, 9, 154),
(649, 9, 155),
(650, 9, 156),
(651, 9, 157),
(652, 9, 158),
(653, 9, 159),
(654, 9, 160),
(655, 9, 161),
(656, 9, 162),
(657, 9, 163),
(658, 9, 164),
(659, 9, 165),
(660, 9, 166),
(661, 9, 167),
(662, 9, 168),
(663, 9, 169),
(664, 9, 170),
(665, 9, 171),
(666, 9, 172),
(667, 9, 173),
(668, 9, 174),
(669, 9, 175),
(670, 9, 176),
(671, 9, 177),
(672, 9, 178),
(673, 9, 179),
(674, 9, 180),
(675, 9, 181),
(676, 9, 183),
(677, 9, 184),
(678, 9, 185),
(679, 9, 186),
(680, 8, 134),
(681, 8, 123),
(682, 8, 124),
(683, 8, 125),
(684, 8, 126),
(685, 8, 127),
(686, 8, 129),
(687, 8, 130),
(688, 8, 131),
(689, 8, 132),
(690, 8, 133),
(691, 8, 135),
(692, 8, 122),
(693, 8, 121),
(694, 8, 107),
(695, 8, 108),
(696, 8, 110),
(697, 8, 112),
(698, 8, 114),
(699, 8, 115),
(700, 8, 116),
(701, 8, 117),
(702, 8, 118),
(703, 8, 119),
(704, 8, 120),
(705, 8, 136),
(706, 8, 137),
(707, 8, 138),
(708, 8, 111),
(709, 8, 113),
(710, 8, 128),
(711, 8, 41),
(712, 6, 130),
(713, 6, 22),
(714, 6, 84),
(715, 6, 85),
(716, 6, 86),
(717, 6, 87),
(718, 6, 88),
(719, 6, 89),
(720, 6, 90),
(721, 6, 92),
(722, 6, 93),
(723, 6, 94),
(724, 6, 95),
(725, 6, 96),
(726, 6, 97),
(727, 6, 98),
(728, 6, 99),
(729, 6, 100),
(730, 6, 101),
(731, 6, 102),
(732, 6, 103),
(733, 6, 104),
(734, 6, 105),
(735, 6, 106);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_mech`
-- 

CREATE TABLE `vehicle_2_mech` (
  `v2m_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `mech_id` int(11) NOT NULL,
  PRIMARY KEY  (`v2m_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=329 ;

-- 
-- Dumping data for table `vehicle_2_mech`
-- 

INSERT INTO `vehicle_2_mech` (`v2m_id`, `vehicle_id`, `mech_id`) VALUES 
(8, 0, 1),
(151, 5, 4),
(152, 5, 5),
(153, 5, 6),
(154, 5, 7),
(155, 5, 8),
(156, 5, 9),
(157, 5, 10),
(158, 5, 11),
(159, 5, 12),
(160, 5, 13),
(296, 10, 32),
(297, 10, 39),
(298, 10, 40),
(299, 10, 41),
(300, 10, 42),
(301, 9, 11),
(302, 9, 21),
(303, 9, 31),
(304, 9, 32),
(305, 9, 33),
(306, 9, 34),
(307, 9, 35),
(308, 9, 36),
(309, 9, 37),
(310, 9, 38),
(311, 8, 22),
(312, 8, 24),
(313, 8, 25),
(314, 8, 26),
(315, 8, 27),
(316, 8, 28),
(317, 8, 29),
(318, 8, 30),
(319, 8, 23),
(320, 8, 8),
(321, 8, 9),
(322, 8, 20),
(323, 6, 11),
(324, 6, 17),
(325, 6, 18),
(326, 6, 19),
(327, 6, 20),
(328, 6, 21);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_safety`
-- 

CREATE TABLE `vehicle_2_safety` (
  `v2s_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `safe_id` int(11) NOT NULL,
  PRIMARY KEY  (`v2s_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=483 ;

-- 
-- Dumping data for table `vehicle_2_safety`
-- 

INSERT INTO `vehicle_2_safety` (`v2s_id`, `vehicle_id`, `safe_id`) VALUES 
(13, 0, 1),
(200, 5, 12),
(201, 5, 13),
(202, 5, 14),
(203, 5, 15),
(204, 5, 16),
(205, 5, 17),
(206, 5, 18),
(207, 5, 19),
(208, 5, 20),
(209, 5, 21),
(210, 5, 22),
(211, 5, 23),
(212, 5, 24),
(213, 5, 26),
(214, 5, 27),
(215, 5, 28),
(216, 5, 29),
(217, 5, 30),
(218, 5, 31),
(219, 5, 32),
(220, 5, 33),
(221, 5, 34),
(222, 5, 35),
(223, 5, 36),
(428, 9, 12),
(429, 9, 13),
(430, 9, 14),
(431, 9, 17),
(432, 9, 27),
(433, 9, 29),
(434, 9, 32),
(435, 9, 68),
(436, 9, 69),
(437, 9, 70),
(438, 9, 71),
(439, 9, 73),
(440, 9, 74),
(441, 9, 75),
(442, 9, 76),
(443, 9, 77),
(444, 9, 78),
(445, 9, 79),
(446, 9, 80),
(447, 9, 81),
(448, 9, 82),
(449, 8, 55),
(450, 8, 14),
(451, 8, 15),
(452, 8, 17),
(453, 8, 21),
(454, 8, 22),
(455, 8, 29),
(456, 8, 31),
(457, 8, 32),
(458, 8, 33),
(459, 8, 56),
(460, 8, 58),
(461, 8, 59),
(462, 8, 60),
(463, 8, 61),
(464, 8, 62),
(465, 8, 63),
(466, 8, 64),
(467, 8, 65),
(468, 8, 66),
(469, 6, 12),
(470, 6, 14),
(471, 6, 17),
(472, 6, 24),
(473, 6, 45),
(474, 6, 46),
(475, 6, 47),
(476, 6, 48),
(477, 6, 49),
(478, 6, 50),
(479, 6, 51),
(480, 6, 52),
(481, 6, 53),
(482, 6, 54);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_2_vin`
-- 

CREATE TABLE `vehicle_2_vin` (
  `vin2_id` int(11) NOT NULL auto_increment,
  `vin2_title` varchar(500) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  PRIMARY KEY  (`vin2_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=419 ;

-- 
-- Dumping data for table `vehicle_2_vin`
-- 

INSERT INTO `vehicle_2_vin` (`vin2_id`, `vin2_title`, `vehicle_id`) VALUES 
(280, 'Performance', 32),
(281, 'Size and Shape Measurements', 32),
(282, 'Weight Measurements', 32),
(283, 'Interior Dimensions', 32),
(284, 'Seating', 32),
(285, 'Truck Bed', 32),
(286, 'Wheels and Tires', 32),
(287, 'Fuel Storage', 32),
(288, 'Air Conditioning', 32),
(289, 'Airbags', 32),
(290, 'Audio System', 32),
(291, 'Brakes', 32),
(292, 'Child Safety', 32),
(293, 'Comfort Features', 32),
(294, 'Convenience Features', 32),
(295, 'Driver Seat', 32),
(296, 'Drivetrain', 32),
(297, 'Engine', 32),
(298, 'Exterior Features', 32),
(299, 'Headrests', 32),
(300, 'Instrumentation', 32),
(301, 'Lights', 32),
(302, 'Locks', 32),
(303, 'Mirrors', 32),
(304, 'Passenger Seat', 32),
(305, 'Rear Seats', 32),
(306, 'Roof', 32),
(307, 'Safety', 32),
(308, 'Seatbelts', 32),
(309, 'Seats', 32),
(310, 'Security', 32),
(311, 'Spare Tire', 32),
(312, 'Spare Wheel', 32),
(313, 'Stability and Traction', 32),
(314, 'Steering', 32),
(315, 'Suspension', 32),
(316, 'Telematics', 32),
(317, 'Tires', 32),
(318, 'Wheels', 32),
(319, 'Windows', 32),
(320, 'Engine', 32),
(321, 'Exterior Features', 32),
(322, 'Interior', 32),
(323, 'Marketing Package', 32),
(324, 'Security', 32),
(325, 'Driven Wheels', 32),
(326, 'Performance', 32),
(327, 'Size and Shape Measurements', 32),
(328, 'Weight Measurements', 32),
(329, 'Interior Dimensions', 32),
(330, 'Seating', 32),
(331, 'Truck Bed', 32),
(332, 'Wheels and Tires', 32),
(333, 'Fuel Storage', 32),
(334, 'Air Conditioning', 32),
(335, 'Airbags', 32),
(336, 'Audio System', 32),
(337, 'Brakes', 32),
(338, 'Child Safety', 32),
(339, 'Comfort Features', 32),
(340, 'Convenience Features', 32),
(341, 'Driver Seat', 32),
(342, 'Drivetrain', 32),
(343, 'Engine', 32),
(344, 'Exterior Features', 32),
(345, 'Headrests', 32),
(346, 'Instrumentation', 32),
(347, 'Lights', 32),
(348, 'Locks', 32),
(349, 'Mirrors', 32),
(350, 'Passenger Seat', 32),
(351, 'Rear Seats', 32),
(352, 'Roof', 32),
(353, 'Safety', 32),
(354, 'Seatbelts', 32),
(355, 'Seats', 32),
(356, 'Security', 32),
(357, 'Spare Tire', 32),
(358, 'Spare Wheel', 32),
(359, 'Stability and Traction', 32),
(360, 'Steering', 32),
(361, 'Suspension', 32),
(362, 'Telematics', 32),
(363, 'Tires', 32),
(364, 'Wheels', 32),
(365, 'Windows', 32),
(366, 'Engine', 32),
(367, 'Exterior Features', 32),
(368, 'Interior', 32),
(369, 'Marketing Package', 32),
(370, 'Security', 32),
(371, 'Driven Wheels', 32),
(372, 'Performance', 32),
(373, 'Size and Shape Measurements', 32),
(374, 'Weight Measurements', 32),
(375, 'Interior Dimensions', 32),
(376, 'Seating', 32),
(377, 'Truck Bed', 32),
(378, 'Wheels and Tires', 32),
(379, 'Fuel Storage', 32),
(380, 'Air Conditioning', 32),
(381, 'Airbags', 32),
(382, 'Audio System', 32),
(383, 'Brakes', 32),
(384, 'Child Safety', 32),
(385, 'Comfort Features', 32),
(386, 'Convenience Features', 32),
(387, 'Driver Seat', 32),
(388, 'Drivetrain', 32),
(389, 'Engine', 32),
(390, 'Exterior Features', 32),
(391, 'Headrests', 32),
(392, 'Instrumentation', 32),
(393, 'Lights', 32),
(394, 'Locks', 32),
(395, 'Mirrors', 32),
(396, 'Passenger Seat', 32),
(397, 'Rear Seats', 32),
(398, 'Roof', 32),
(399, 'Safety', 32),
(400, 'Seatbelts', 32),
(401, 'Seats', 32),
(402, 'Security', 32),
(403, 'Spare Tire', 32),
(404, 'Spare Wheel', 32),
(405, 'Stability and Traction', 32),
(406, 'Steering', 32),
(407, 'Suspension', 32),
(408, 'Telematics', 32),
(409, 'Tires', 32),
(410, 'Wheels', 32),
(411, 'Windows', 32),
(412, 'Engine', 32),
(413, 'Exterior Features', 32),
(414, 'Interior', 32),
(415, 'Marketing Package', 32),
(416, 'Safety', 32),
(417, 'Security', 32),
(418, 'Tires and Rims', 32);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_images`
-- 

CREATE TABLE `vehicle_images` (
  `vi_id` int(11) NOT NULL auto_increment,
  `vehicle_id` int(11) NOT NULL,
  `vi_image` varchar(500) NOT NULL,
  `vi_sort` int(11) NOT NULL default '0',
  `vi_status` int(11) NOT NULL default '0',
  `mainPage` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vi_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

-- 
-- Dumping data for table `vehicle_images`
-- 

INSERT INTO `vehicle_images` (`vi_id`, `vehicle_id`, `vi_image`, `vi_sort`, `vi_status`, `mainPage`) VALUES 
(24, 5, 'Z5ntLqK71N4CL21E69C181956_01.jpg', 1, 1, 0),
(25, 5, '6N8KkHnW2.jpg', 2, 0, 0),
(26, 5, 'bTgr1W0w3.jpg', 3, 0, 0),
(27, 5, 'Sd2v1t9p4.jpg', 4, 0, 0),
(28, 5, 'pn0BR5cg5.jpg', 5, 0, 0),
(29, 5, 'gWXb6LdB6.jpg', 6, 0, 0),
(30, 6, 'wb1Tt6qx1N4CL21E69C181956_01.jpg', 1, 1, 0),
(31, 6, 'W4YmKbs02.jpg', 2, 0, 0),
(32, 6, 'DkRr0VYJ3.jpg', 3, 0, 0),
(33, 6, '6jGgWLrq4.jpg', 4, 0, 0),
(34, 6, 'f2jv5YVr5.jpg', 5, 0, 0),
(35, 6, 'GTRhWzXY6.jpg', 6, 0, 0),
(36, 8, '4w2NGRQLJN8AZ18W19W128125_01.jpg', 0, 1, 0),
(37, 8, '2YrXfndBJN8AZ18W19W128125_02.jpg', 0, 0, 0),
(38, 8, 'dVXkC8Q3JN8AZ18W19W128125_03.jpg', 0, 0, 0),
(39, 8, 'HG4JtP2bJN8AZ18W19W128125_04.jpg', 0, 0, 0),
(40, 8, 'pNH4Cm5tJN8AZ18W19W128125_05.jpg', 0, 0, 0),
(41, 8, 'wS7hCvgtJN8AZ18W19W128125_06.jpg', 0, 0, 0),
(42, 9, 'zvCfHGj41N4CL21E69C181956_01.jpg', 1, 1, 0),
(45, 9, 'MRbDQgnh2.jpg', 2, 0, 0),
(47, 9, 'wZq4C5ts3.jpg', 3, 0, 0),
(48, 9, 'R7tB9zvP4.jpg', 4, 0, 0),
(49, 9, 'GYPWbTBM5.jpg', 5, 0, 0),
(50, 9, 'BZvNfLnt6.jpg', 6, 0, 0),
(51, 32, 'p9V7w8DBbabel2.jpg', 1, 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `vehicle_make`
-- 

CREATE TABLE `vehicle_make` (
  `vmake_id` int(11) NOT NULL auto_increment,
  `vmake_title` varchar(500) NOT NULL,
  `vmake_sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vmake_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `vehicle_make`
-- 

INSERT INTO `vehicle_make` (`vmake_id`, `vmake_title`, `vmake_sort`) VALUES 
(1, 'Nissan', 1),
(2, 'Toyota', 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `vin_values`
-- 

CREATE TABLE `vin_values` (
  `vinv_id` int(11) NOT NULL auto_increment,
  `vin2_id` int(11) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  `vin_value` varchar(5000) NOT NULL,
  PRIMARY KEY  (`vinv_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=410 ;

-- 
-- Dumping data for table `vin_values`
-- 

INSERT INTO `vin_values` (`vinv_id`, `vin2_id`, `vehicle_id`, `vin_value`) VALUES 
(274, 280, 32, '---0.33-37.4'),
(275, 281, 32, '---62.4-5.6-57.8-190.6-62.4-109.3-73.2'),
(276, 282, 32, '---4698-4001-5000-1000-1000'),
(277, 283, 32, '---14.2-95.8'),
(278, 284, 32, '---38.5-36.4-53.9-43.8-34.6-5-2-56.3-55.1-5'),
(279, 286, 32, '---P245/45R18 V-18 x 8.0'),
(280, 287, 32, '---20.0'),
(281, 288, 32, '---\r\n\r\n-\r\nautomatic climate control\r\n-\r\ndual\r\n'),
(282, 289, 32, '---\r\ndual\r\n-\r\noccupant sensing deactivation\r\n-\r\nfront\r\n-\r\nfront and rear\r\n'),
(283, 290, 32, '---\r\ndiversity\r\nelement\r\n-\r\njack\r\n-\r\n6 disc\r\n-\r\nCD MP3 Playback\r\n-\r\nAM/FM\r\n'),
(284, 291, 32, '---\r\n4-wheel\r\n-\r\n\r\n-\r\n\r\n-\r\n12.6\r\n-\r\n1.1\r\n-\r\nventilated disc\r\n-\r\n12.13\r\n-\r\n.63\r\n-\r\nventilated disc\r\n'),
(285, 292, 32, '---\r\n\r\n-\r\nLATCH system\r\n-\r\n\r\n'),
(286, 293, 32, '---\r\n\r\n-\r\naluminum\r\n-\r\nfront and rear\r\n-\r\nleather\r\n-\r\nleather\r\n'),
(287, 294, 32, '---\r\nfront and rear\r\n-\r\nfront\r\n-\r\ndual level\r\n-\r\n\r\n-\r\nfront and rear\r\n-\r\nlight\r\nlockable\r\n-\r\npush-button start\r\n-\r\n\r\nhands-free multi-function remote with keyless ignition\r\n\r\n-\r\nwith sunglass holder\r\n-\r\ntwo 12V\r\n-\r\nspeed-proportional\r\n-\r\n\r\n-\r\n\r\n-\r\ntilt and telescopic\r\n-\r\naudio and cruise controls\r\n-\r\ncargo tie-down anchors and hooks\r\nfront seatback\r\n'),
(288, 295, 32, '---\r\n\r\n-\r\n\r\n-\r\n8\r\n'),
(289, 296, 32, '---\r\n5.17\r\n'),
(290, 297, 32, '---\r\n130 amps\r\n-\r\n550 CCA\r\n-\r\n\r\n-\r\niridium tipped\r\n'),
(291, 298, 32, '---\r\nbody-color\r\n-\r\ndual exhaust tips\r\n-\r\nchrome\r\n-\r\nbody-color\r\n'),
(292, 299, 32, '---\r\nheight adjustable\r\n-\r\nheight adjustable\r\n-\r\n2\r\n-\r\n2\r\n'),
(293, 300, 32, '---\r\n\r\n-\r\n\r\n-\r\n\r\n-\r\nlamp failure, low fuel, engine oil, coolant\r\n'),
(294, 301, 32, '---\r\n\r\n-\r\n\r\n-\r\nAuto on/off\r\nHalogen\r\n-\r\nLED\r\n'),
(295, 302, 32, '---\r\nremote\r\n-\r\nspeed controlled\r\n-\r\nanti-lockout feature\r\n'),
(296, 303, 32, '---\r\nmanual folding\r\npower\r\n-\r\nauto-dimming\r\n-\r\ndual illuminating with sliding extensions\r\n'),
(297, 304, 32, '---\r\n\r\n-\r\n4\r\n'),
(298, 305, 32, '---\r\nfolding\r\n-\r\nvents\r\n-\r\n60-40 split bench\r\nsplit-folding\r\n'),
(299, 306, 32, '---\r\nanti-trapping feature\r\none-touch open/close\r\npower glass\r\nsliding sunshade\r\ntilt\r\n'),
(300, 307, 32, '---\r\nside impact door beams\r\n-\r\nfront and rear\r\n-\r\n\r\n-\r\n\r\n'),
(301, 308, 32, '---\r\nfront and rear\r\n-\r\n3-point\r\n-\r\nfront\r\n-\r\nfront\r\n\r\n-\r\n3-point\r\n'),
(302, 309, 32, '---\r\nbucket\r\n'),
(303, 310, 32, '---\r\nwith engine immobilizer\r\n'),
(304, 311, 32, '---\r\ninside\r\n-\r\ntemporary\r\n'),
(305, 312, 32, '---\r\nsteel\r\n'),
(306, 313, 32, '---\r\n\r\n-\r\n\r\n'),
(307, 314, 32, '---\r\n15.2\r\n-\r\n2.6\r\n'),
(308, 315, 32, '---\r\ndiameter 25.4 mm\r\n-\r\n\r\n-\r\nindependent\r\n-\r\nstrut\r\n-\r\ndiameter 21 mm\r\n-\r\nindependent\r\n-\r\nmulti-link\r\n'),
(309, 316, 32, '---\r\n\r\n-\r\nBluetooth\r\n'),
(310, 317, 32, '---\r\n\r\n-\r\nall season\r\n'),
(311, 318, 32, '---\r\naluminum\r\n-\r\n10\r\n'),
(312, 319, 32, '---\r\nspeed sensitive\r\nvariable intermittent\r\n-\r\n\r\n-\r\n2\r\n-\r\nremote operation\r\nwith safety reverse\r\n-\r\n\r\n-\r\n\r\n'),
(313, 320, 32, '---\r\nFactory Installed Option\r\n0\r\n0\r\nC03\r\n\r\n-\r\nFactory Installed Option\r\n0\r\n0\r\nC02\r\n\r\n'),
(314, 321, 32, '---\r\nPort Installed Option\r\n133\r\n170\r\nB92\r\nIncludes front and rear splash guards.\r\n-\r\nFactory Installed Option\r\n143\r\n180\r\nB10\r\nIncludes front and rear splash guards.\r\n'),
(315, 322, 32, '---\r\nPort Installed Option\r\n146\r\n195\r\nL92\r\n\r\n-\r\nPort Installed Option\r\n115\r\n140\r\nM92\r\n\r\nIncludes sub-floor organizer that fits directly beneath the trunk mat to give you extra usable space above the spare tire and an emergency road kit and a first-aid kit, each stored snugly in their own custom fit compartments.\r\n\r\n'),
(316, 323, 32, '---\r\nPort Installed Option\r\n272\r\n335\r\nN92\r\n\r\n'),
(317, 324, 32, '---\r\nPort Installed Option\r\n188\r\n210\r\nS92\r\n\r\n'),
(318, 325, 32, '---FWD'),
(319, 326, 32, '---0.33-37.4'),
(320, 327, 32, '---62.4-5.6-57.8-190.6-62.4-109.3-73.2'),
(321, 328, 32, '---3540-4698-4001-5000-1000-1000'),
(322, 329, 32, '---14.2-95.8'),
(323, 330, 32, '---38.5-36.4-53.9-43.8-34.6-5-2-56.3-55.1-5'),
(324, 332, 32, '---P245/45R18 V-18 x 8.0'),
(325, 333, 32, '---20.0'),
(326, 334, 32, '---\r\n\r\n-\r\nautomatic climate control\r\n-\r\ndual\r\n'),
(327, 335, 32, '---\r\ndual\r\n-\r\noccupant sensing deactivation\r\n-\r\nfront\r\n-\r\nfront and rear\r\n'),
(328, 336, 32, '---\r\ndiversity\r\nelement\r\n-\r\njack\r\n-\r\n6 disc\r\n-\r\nCD MP3 Playback\r\n-\r\nAM/FM\r\n-\r\n8\r\n'),
(329, 337, 32, '---\r\n4-wheel\r\n-\r\n\r\n-\r\n\r\n-\r\n12.6\r\n-\r\n1.1\r\n-\r\nventilated disc\r\n-\r\n12.13\r\n-\r\n.63\r\n-\r\nventilated disc\r\n'),
(330, 338, 32, '---\r\n\r\n-\r\nLATCH system\r\n-\r\n\r\n'),
(331, 339, 32, '---\r\n\r\n-\r\naluminum\r\n-\r\nfront and rear\r\n-\r\nleather\r\n-\r\nleather\r\n'),
(332, 340, 32, '---\r\nfront and rear\r\n-\r\nfront\r\n-\r\ndual level\r\n-\r\n\r\n-\r\nfront and rear\r\n-\r\nlight\r\nlockable\r\n-\r\npush-button start\r\n-\r\n\r\nhands-free multi-function remote with keyless ignition\r\n\r\n-\r\nwith sunglass holder\r\n-\r\ntwo 12V\r\n-\r\nspeed-proportional\r\n-\r\n\r\n-\r\n\r\n-\r\ntilt and telescopic\r\n-\r\naudio and cruise controls\r\n-\r\ncargo tie-down anchors and hooks\r\nfront seatback\r\n'),
(333, 341, 32, '---\r\n\r\n-\r\nmanual\r\n-\r\n\r\n-\r\n8\r\n'),
(334, 342, 32, '---\r\n5.17\r\n'),
(335, 343, 32, '---\r\n130 amps\r\n-\r\n550 CCA\r\n-\r\n\r\n-\r\niridium tipped\r\n'),
(336, 344, 32, '---\r\nbody-color\r\n-\r\ndual exhaust tips\r\n-\r\nchrome\r\n-\r\nbody-color\r\n'),
(337, 345, 32, '---\r\nheight adjustable\r\n-\r\nheight adjustable\r\n-\r\n2\r\n-\r\n2\r\n'),
(338, 346, 32, '---\r\n\r\n-\r\n\r\n-\r\n\r\n-\r\nlamp failure, low fuel, engine oil, coolant\r\n'),
(339, 347, 32, '---\r\n\r\n-\r\n\r\n-\r\nAuto on/off\r\nHalogen\r\n-\r\nLED\r\n'),
(340, 348, 32, '---\r\nremote\r\n-\r\nspeed controlled\r\n-\r\nanti-lockout feature\r\n'),
(341, 349, 32, '---\r\nmanual folding\r\npower\r\n-\r\nauto-dimming\r\n-\r\ndual illuminating with sliding extensions\r\n'),
(342, 350, 32, '---\r\n\r\n-\r\n4\r\n'),
(343, 351, 32, '---\r\nfolding\r\n-\r\nvents\r\n-\r\n60-40 split bench\r\nsplit-folding\r\n'),
(344, 352, 32, '---\r\nanti-trapping feature\r\none-touch open/close\r\npower glass\r\nsliding sunshade\r\ntilt\r\n'),
(345, 353, 32, '---\r\nside impact door beams\r\n-\r\nfront and rear\r\n-\r\n\r\n-\r\n\r\n'),
(346, 354, 32, '---\r\nfront and rear\r\n-\r\n3-point\r\n-\r\nfront\r\n-\r\nfront\r\n-\r\n3-point\r\n'),
(347, 355, 32, '---\r\nbucket\r\n-\r\ncloth\r\n'),
(348, 356, 32, '---\r\nwith engine immobilizer\r\n'),
(349, 357, 32, '---\r\ninside\r\n-\r\ntemporary\r\n'),
(350, 358, 32, '---\r\nsteel\r\n'),
(351, 359, 32, '---\r\n\r\n-\r\n\r\n'),
(352, 360, 32, '---\r\n15.2\r\n-\r\n2.6\r\n'),
(353, 361, 32, '---\r\ndiameter 25.4 mm\r\n-\r\n\r\n-\r\nindependent\r\n-\r\nstrut\r\n-\r\ndiameter 21 mm\r\n-\r\nindependent\r\n-\r\nmulti-link\r\n'),
(354, 362, 32, '---\r\n\r\n-\r\nBluetooth\r\n'),
(355, 363, 32, '---\r\n\r\n-\r\nall season\r\n'),
(356, 364, 32, '---\r\naluminum\r\n-\r\n10\r\n'),
(357, 365, 32, '---\r\nspeed sensitive\r\nvariable intermittent\r\n-\r\n\r\n-\r\n2\r\n-\r\nremote operation\r\nwith safety reverse\r\n-\r\n\r\n-\r\n\r\n'),
(358, 366, 32, '---\r\nFactory Installed Option\r\n0\r\n0\r\nC03\r\n\r\n-\r\nFactory Installed Option\r\n0\r\n0\r\nC02\r\n\r\n'),
(359, 367, 32, '---\r\nPort Installed Option\r\n133\r\n170\r\nB92\r\nIncludes front and rear splash guards.\r\n-\r\nFactory Installed Option\r\n143\r\n180\r\nB10\r\nIncludes front and rear splash guards.\r\n'),
(360, 368, 32, '---\r\nPort Installed Option\r\n146\r\n195\r\nL92\r\n\r\n-\r\nPort Installed Option\r\n115\r\n140\r\nM92\r\n\r\nIncludes sub-floor organizer that fits directly beneath the trunk mat to give you extra usable space above the spare tire and an emergency road kit and a first-aid kit, each stored snugly in their own custom fit compartments.\r\n\r\n'),
(361, 369, 32, '---\r\nPort Installed Option\r\n272\r\n335\r\nN92\r\n\r\n'),
(362, 370, 32, '---\r\nPort Installed Option\r\n188\r\n210\r\nS92\r\n\r\n'),
(363, 371, 32, '---FWD'),
(364, 372, 32, '---0.33-37.4'),
(365, 373, 32, '---62.4-5.6-57.8-190.6-62.4-109.3-73.2'),
(366, 374, 32, '---3565-4698-4001-5000-1000-1000'),
(367, 375, 32, '---14.2-95.8'),
(368, 376, 32, '---38.5-36.4-53.9-43.8-34.6-5-2-56.3-55.1-5'),
(369, 378, 32, '---P245/45R18 V-18 x 8.0'),
(370, 379, 32, '---20.0'),
(371, 380, 32, '---\r\n\r\n-\r\nautomatic climate control\r\n-\r\ndual\r\n'),
(372, 381, 32, '---\r\ndual\r\n-\r\noccupant sensing deactivation\r\n-\r\nfront\r\n-\r\nfront and rear\r\n'),
(373, 382, 32, '---\r\ndiversity\r\nelement\r\n-\r\njack\r\n-\r\n6 disc\r\n-\r\nCD MP3 Playback\r\n-\r\nBose\r\n-\r\nAM/FM\r\n-\r\n\r\n-\r\nXM\r\n-\r\n\r\n-\r\n9\r\n'),
(374, 383, 32, '---\r\n4-wheel\r\n-\r\n\r\n-\r\n\r\n-\r\n12.6\r\n-\r\n1.1\r\n-\r\nventilated disc\r\n-\r\n12.13\r\n-\r\n.63\r\n-\r\nventilated disc\r\n'),
(375, 384, 32, '---\r\n\r\n-\r\nLATCH system\r\n-\r\n\r\n'),
(376, 385, 32, '---\r\n\r\n-\r\naluminum\r\n-\r\nfront and rear\r\n-\r\nleather\r\n-\r\nleather\r\n'),
(377, 386, 32, '---\r\nfront and rear\r\n-\r\nfront\r\n-\r\ndual level\r\n-\r\n\r\n-\r\nfront and rear\r\n-\r\nlight\r\nlockable\r\n-\r\npush-button start\r\n-\r\n\r\nhands-free multi-function remote with keyless ignition\r\n\r\n-\r\nwith sunglass holder\r\n-\r\ntwo 12V\r\n-\r\nspeed-proportional\r\n-\r\n\r\n-\r\n\r\n-\r\ntilt and telescopic\r\n-\r\naudio and cruise controls\r\n-\r\ncargo tie-down anchors and hooks\r\nfront seatback\r\n-\r\nHomelink\r\n'),
(378, 387, 32, '---\r\n\r\n-\r\npower\r\n-\r\n\r\n-\r\n8\r\n'),
(379, 388, 32, '---\r\n5.17\r\n'),
(380, 389, 32, '---\r\n130 amps\r\n-\r\n550 CCA\r\n-\r\n\r\n-\r\niridium tipped\r\n'),
(381, 390, 32, '---\r\nbody-color\r\n-\r\ndual exhaust tips\r\n-\r\nchrome\r\n-\r\nbody-color\r\n'),
(382, 391, 32, '---\r\nheight adjustable\r\n-\r\nheight adjustable\r\n-\r\n2\r\n-\r\n2\r\n'),
(383, 392, 32, '---\r\n\r\n-\r\n\r\n-\r\n\r\n-\r\n\r\n-\r\nlamp failure, low fuel, engine oil, coolant\r\n'),
(384, 393, 32, '---\r\n\r\n-\r\n\r\n-\r\n\r\n-\r\nAuto on/off\r\nHalogen\r\n-\r\nLED\r\n'),
(385, 394, 32, '---\r\nremote\r\n-\r\nspeed controlled\r\n-\r\nanti-lockout feature\r\n'),
(386, 395, 32, '---\r\nintegrated turn signals\r\nmanual folding\r\npower\r\n-\r\nauto-dimming\r\n-\r\ndual illuminating with sliding extensions\r\n'),
(387, 396, 32, '---\r\n\r\n-\r\n4\r\n'),
(388, 397, 32, '---\r\nfolding\r\n-\r\nvents\r\n-\r\n60-40 split bench\r\nsplit-folding\r\n'),
(389, 398, 32, '---\r\nanti-trapping feature\r\none-touch open/close\r\npower glass\r\nsliding sunshade\r\ntilt\r\n'),
(390, 399, 32, '---\r\nside impact door beams\r\n-\r\nfront and rear\r\n-\r\n\r\n-\r\n\r\n'),
(391, 400, 32, '---\r\nfront and rear\r\n-\r\n3-point\r\n-\r\nfront\r\n-\r\nfront\r\n-\r\n3-point\r\n'),
(392, 401, 32, '---\r\nbucket\r\n-\r\nleather-appointed\r\n'),
(393, 402, 32, '---\r\nwith engine immobilizer\r\n'),
(394, 403, 32, '---\r\ninside\r\n-\r\ntemporary\r\n'),
(395, 404, 32, '---\r\nsteel\r\n'),
(396, 405, 32, '---\r\n\r\n-\r\n\r\n'),
(397, 406, 32, '---\r\n15.2\r\n-\r\n2.6\r\n'),
(398, 407, 32, '---\r\ndiameter 25.4 mm\r\n-\r\n\r\n-\r\nindependent\r\n-\r\nstrut\r\n-\r\ndiameter 21 mm\r\n-\r\nindependent\r\n-\r\nmulti-link\r\n'),
(399, 408, 32, '---\r\n\r\n-\r\nBluetooth\r\n'),
(400, 409, 32, '---\r\n\r\n-\r\nall season\r\n'),
(401, 410, 32, '---\r\naluminum\r\n-\r\n10\r\n'),
(402, 411, 32, '---\r\nspeed sensitive\r\nvariable intermittent\r\n-\r\n\r\n-\r\n2\r\n-\r\nremote operation\r\nwith safety reverse\r\n-\r\n\r\n-\r\n\r\n'),
(403, 412, 32, '---\r\nFactory Installed Option\r\n0\r\n0\r\nC03\r\n\r\n-\r\nFactory Installed Option\r\n0\r\n0\r\nC02\r\n\r\n'),
(404, 413, 32, '---\r\nFactory Installed Option\r\n298\r\n375\r\nR10\r\n\r\n-\r\nPort Installed Option\r\n133\r\n170\r\nB92\r\nIncludes front and rear splash guards.\r\n-\r\nFactory Installed Option\r\n143\r\n180\r\nB10\r\nIncludes front and rear splash guards.\r\n'),
(405, 414, 32, '---\r\nPort Installed Option\r\n146\r\n195\r\nL92\r\n\r\n-\r\nPort Installed Option\r\n115\r\n140\r\nM92\r\n\r\nIncludes sub-floor organizer that fits directly beneath the trunk mat to give you extra usable space above the spare tire and an emergency road kit and a first-aid kit, each stored snugly in their own custom fit compartments.\r\n\r\n'),
(406, 415, 32, '---\r\nFactory Installed Option\r\n347\r\n400\r\nG01\r\n\r\nIncludes heated outside mirrors, heated steering wheel, and heated front seats.\r\n\r\n-\r\nPort Installed Option\r\n272\r\n335\r\nN92\r\n\r\n-\r\nFactory Installed Option\r\n607\r\n700\r\nF01\r\n\r\nIncludes information center with 7.0 inch color monitor, rearview monitor, 2 GB Music Box flash drive for digital music storage and playback, USB connectivity (iPod compatible), auxiliary audio/video input jacks in center console (replace auxiliary audio input jack located on head unit), and iPod storage net inside center console. Single-CD player replaces in-dash 6-CD changer in this package.\r\n\r\n-\r\nFactory Installed Option\r\n2862\r\n3300\r\nP01\r\n\r\nIncludes dual panel moonroof with power retractable sunshades (replaces power sliding moonroof), Information Center with 7.0 inch color monitor, rearview monitor, 2 GB Music Box flash drive for digital music storage and playback, USB connectivity (iPod compatible), iPod center console storage net, auxiliary audio/video input jacks in center console, High Intensity Discharge (HID) xenon headlights, heated outside mirrors with reverse tilt-down feature, auto-dimming driver-side outside mirror, premium mood lighting, Eucalyptus wood-tone trim (replaces piano-dot trim), premium leather-appointed seats, heated front seats, parallel-seamed heated leather-wrapped steering wheel with paddle shifters, parallel-seamed leather-wrapped shift knob, power tilt/telescoping steering column, memory system - drivers seat, steering wheel, and outside mirrors (two settings, remote control-activated), drivers seat entry/exit system, climate-controlled drivers seat (heated and cooled), rear bucket seats (3-passenger capacity) with large fold-down center armrest, rear-seat trunk pass-through, rear-window power sunshade, rear door windows one-touch auto-up/down, and trunk chassis reinforcement. Overhead sunglasses storage is deleted and Single-CD player replaces in-dash 6-CD changer in this package.\r\n\r\n-\r\nFactory Installed Option\r\n1605\r\n1850\r\nU02\r\n\r\nIncludes Nissan Hard Drive Navigation System with 7.0 inch VGA touch-screen monitor and voice recognition, XM NavTraffic, XM NavWeather, Zagat Survey restaurant reviews, streaming audio via Bluetooth wireless technology, 9.3 GB Music Box hard drive for digital music storage and playback, and DVD playback capability. Single-CD player replaces in-dash 6-CD changer and digital compass in rearview mirror is deleted with this package.\r\n\r\n-\r\nFactory Installed Option\r\n1821\r\n2100\r\nR01\r\n\r\nIncludes sport-tuned suspension, 19 x 8.0-inch aluminum-alloy hyper-silver finish wheels with P245/40R19 V-rated all-season tires, rear spoiler, trunk chassis reinforcement, High Intensity Discharge (HID) xenon headlights, heated outside mirrors with reverse tilt-down feature, auto-dimming driver-side outside mirror, Metallic-link trim (replaces piano-dot trim), premium leather-appointed seats, heated front seats, parallel-seamed heated leather-wrapped steering wheel with paddle shifters, parallel-seamed leather-wrapped shift knob, power tilt/telescoping steering column, memory system - driver seat, steering wheel, and outside mirrors (two settings, remote control-activated), driver seat entry/exit system, rear bucket seats (3-passenger capacity) with large fold-down center armrest, and rear-seat trunk pass-through (replaces 60/40 split fold-down seats).\r\n\r\n-\r\nFactory Installed Option\r\n1605\r\n1850\r\nU03\r\n\r\nIncludes Nissan Hard Drive Navigation System with 7.0 inch VGA touch-screen monitor and voice recognition, XM NavTraffic, XM NavWeather, Zagat Survey restaurant reviews, streaming audio via Bluetooth wireless technology, 9.3 GB Music Box hard drive for digital music storage and playback, and DVD playback capability. Single-CD player replaces in-dash 6-CD changer and digital compass in rearview mirror is deleted with this package.\r\n\r\n-\r\nFactory Installed Option\r\n1605\r\n1850\r\nU01\r\n\r\nIncludes Nissan Hard Drive Navigation System with 7.0 inch VGA touch-screen monitor and voice recognition, XM NavTraffic, XM NavWeather, Zagat Survey restaurant reviews, streaming audio via Bluetooth wireless technology, 9.3 GB Music Box hard drive for digital music storage and playback, and DVD playback capability. Single-CD player replaces in-dash 6-CD changer and digital compass in rearview mirror is deleted with this package.\r\n\r\n'),
(407, 416, 32, '---\r\nFactory Installed Option\r\n347\r\n400\r\nS01\r\n\r\n'),
(408, 417, 32, '---\r\nPort Installed Option\r\n188\r\n210\r\nS92\r\n\r\n'),
(409, 418, 32, '---\r\nFactory Installed Option\r\n0\r\n0\r\nW01\r\n\r\nIncludes P245/40WR19 Bridgestone Potenza RE050A W-rated summer tires.\r\n\r\n');