text: -- phpMyAdmin SQL Dump
  -- version 4.7.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1:3306
  -- Generation Time: Oct 23, 2018 at 01:39 AM
  -- Server version: 5.7.19
  -- PHP Version: 5.6.31
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `carrentaldb`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_group`
  --
  
  DROP TABLE IF EXISTS `auth_group`;
  CREATE TABLE IF NOT EXISTS `auth_group` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(80) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_group_permissions`
  --
  
  DROP TABLE IF EXISTS `auth_group_permissions`;
  CREATE TABLE IF NOT EXISTS `auth_group_permissions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `group_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
    KEY `auth_group_permissions_group_id_b120cbf9` (`group_id`),
    KEY `auth_group_permissions_permission_id_84c5c92e` (`permission_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_permission`
  --
  
  DROP TABLE IF EXISTS `auth_permission`;
  CREATE TABLE IF NOT EXISTS `auth_permission` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `content_type_id` int(11) NOT NULL,
    `codename` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
    KEY `auth_permission_content_type_id_2f476e4b` (`content_type_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `auth_permission`
  --
  
  INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
  (1, 'Can add customer', 1, 'add_customer'),
  (2, 'Can change customer', 1, 'change_customer'),
  (3, 'Can delete customer', 1, 'delete_customer'),
  (4, 'Can view customer', 1, 'view_customer'),
  (5, 'Can add employee', 2, 'add_employee'),
  (6, 'Can change employee', 2, 'change_employee'),
  (7, 'Can delete employee', 2, 'delete_employee'),
  (8, 'Can view employee', 2, 'view_employee'),
  (9, 'Can add inspects', 3, 'add_inspects'),
  (10, 'Can change inspects', 3, 'change_inspects'),
  (11, 'Can delete inspects', 3, 'delete_inspects'),
  (12, 'Can view inspects', 3, 'view_inspects'),
  (13, 'Can add invoice', 4, 'add_invoice'),
  (14, 'Can change invoice', 4, 'change_invoice'),
  (15, 'Can delete invoice', 4, 'delete_invoice'),
  (16, 'Can view invoice', 4, 'view_invoice'),
  (17, 'Can add order', 5, 'add_order'),
  (18, 'Can change order', 5, 'change_order'),
  (19, 'Can delete order', 5, 'delete_order'),
  (20, 'Can view order', 5, 'view_order'),
  (21, 'Can add order for', 6, 'add_orderfor'),
  (22, 'Can change order for', 6, 'change_orderfor'),
  (23, 'Can delete order for', 6, 'delete_orderfor'),
  (24, 'Can view order for', 6, 'view_orderfor'),
  (25, 'Can add store', 7, 'add_store'),
  (26, 'Can change store', 7, 'change_store'),
  (27, 'Can delete store', 7, 'delete_store'),
  (28, 'Can view store', 7, 'view_store'),
  (29, 'Can add vehicle', 8, 'add_vehicle'),
  (30, 'Can change vehicle', 8, 'change_vehicle'),
  (31, 'Can delete vehicle', 8, 'delete_vehicle'),
  (32, 'Can view vehicle', 8, 'view_vehicle'),
  (33, 'Can add log entry', 9, 'add_logentry'),
  (34, 'Can change log entry', 9, 'change_logentry'),
  (35, 'Can delete log entry', 9, 'delete_logentry'),
  (36, 'Can view log entry', 9, 'view_logentry'),
  (37, 'Can add permission', 10, 'add_permission'),
  (38, 'Can change permission', 10, 'change_permission'),
  (39, 'Can delete permission', 10, 'delete_permission'),
  (40, 'Can view permission', 10, 'view_permission'),
  (41, 'Can add group', 11, 'add_group'),
  (42, 'Can change group', 11, 'change_group'),
  (43, 'Can delete group', 11, 'delete_group'),
  (44, 'Can view group', 11, 'view_group'),
  (45, 'Can add user', 12, 'add_user'),
  (46, 'Can change user', 12, 'change_user'),
  (47, 'Can delete user', 12, 'delete_user'),
  (48, 'Can view user', 12, 'view_user'),
  (49, 'Can add content type', 13, 'add_contenttype'),
  (50, 'Can change content type', 13, 'change_contenttype'),
  (51, 'Can delete content type', 13, 'delete_contenttype'),
  (52, 'Can view content type', 13, 'view_contenttype'),
  (53, 'Can add session', 14, 'add_session'),
  (54, 'Can change session', 14, 'change_session'),
  (55, 'Can delete session', 14, 'delete_session'),
  (56, 'Can view session', 14, 'view_session');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_user`
  --
  
  DROP TABLE IF EXISTS `auth_user`;
  CREATE TABLE IF NOT EXISTS `auth_user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `password` varchar(128) NOT NULL,
    `last_login` datetime(6) DEFAULT NULL,
    `is_superuser` tinyint(1) NOT NULL,
    `username` varchar(150) NOT NULL,
    `first_name` varchar(30) NOT NULL,
    `last_name` varchar(150) NOT NULL,
    `email` varchar(254) NOT NULL,
    `is_staff` tinyint(1) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `date_joined` datetime(6) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_user_groups`
  --
  
  DROP TABLE IF EXISTS `auth_user_groups`;
  CREATE TABLE IF NOT EXISTS `auth_user_groups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
    KEY `auth_user_groups_user_id_6a12ed8b` (`user_id`),
    KEY `auth_user_groups_group_id_97559544` (`group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_user_user_permissions`
  --
  
  DROP TABLE IF EXISTS `auth_user_user_permissions`;
  CREATE TABLE IF NOT EXISTS `auth_user_user_permissions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
    KEY `auth_user_user_permissions_user_id_a95ead1b` (`user_id`),
    KEY `auth_user_user_permissions_permission_id_1fbb5f2c` (`permission_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_customer`
  --
  
  DROP TABLE IF EXISTS `crcapp_customer`;
  CREATE TABLE IF NOT EXISTS `crcapp_customer` (
    `customerID` varchar(10) NOT NULL,
    `firstName` varchar(80) NOT NULL,
    `lastName` varchar(80) NOT NULL,
    `streetAddress` varchar(50) DEFAULT NULL,
    `cityAddress` varchar(16) DEFAULT NULL,
    `postCodeAddress` int(11) DEFAULT NULL,
    `stateAddress` varchar(30) DEFAULT NULL,
    `DOB` date NOT NULL,
    `driverLicenceNumber` bigint(20) DEFAULT NULL,
    `occupation` varchar(50) DEFAULT NULL,
    `phoneNumber` bigint(20) DEFAULT NULL,
    `email` varchar(254) DEFAULT NULL,
    `userName` varchar(50) DEFAULT NULL,
    `password` longtext,
    `dateJoined` date DEFAULT NULL,
    `lastLogin` date DEFAULT NULL,
    `gender` varchar(2) NOT NULL,
    `disable` tinyint(1) NOT NULL,
    PRIMARY KEY (`customerID`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_customer`
  --
  
  INSERT INTO `crcapp_customer` (`customerID`, `firstName`, `lastName`, `streetAddress`, `cityAddress`, `postCodeAddress`, `stateAddress`, `DOB`, `driverLicenceNumber`, `occupation`, `phoneNumber`, `email`, `userName`, `password`, `dateJoined`, `lastLogin`, `gender`, `disable`) VALUES
  ('C0011010', 'Jacquelyn', 'S', '7800 Corrinne Court', NULL, NULL, NULL, '1968-02-16', NULL, 'Labour', 111543535016, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011011', 'Curtis', 'L', '1224 Shoenic', NULL, NULL, NULL, '1967-11-14', NULL, 'Labour', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011012', 'Lauren', 'W', '4785 Scott Street', NULL, NULL, NULL, '1972-01-28', NULL, 'Labour', 717535016, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011013', 'Ian', 'J', '7902 Hudson Ave.', NULL, NULL, NULL, '1972-08-16', NULL, 'Labour', 817535018, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011014', 'Sydney', 'B', '9011 Tank Drive', NULL, NULL, NULL, '1972-05-19', NULL, 'Labour', 431535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011015', 'Chloe', 'Y', '244 Willow Pass Road', NULL, NULL, NULL, '1983-02-10', NULL, 'Labour', 208535014, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011016', 'Wyatt', 'H', '9666 Northridge Ct.', NULL, NULL, NULL, '1983-04-18', NULL, 'Labour', 135535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011017', 'Shannon', 'W', '7330 Saddlehill Lane', NULL, NULL, NULL, '1948-06-16', NULL, 'Labour', 111543535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011018', 'Clarence', 'R', '244 Rivewview', NULL, NULL, NULL, '1948-10-19', NULL, 'Labour', 111543535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011019', 'Luke', 'L', '7832 Landing Dr', NULL, NULL, NULL, '1982-03-10', NULL, 'Labour', 262535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011050', 'Alan', 'Z', '2741 Gainborough Dr.', NULL, NULL, NULL, '1955-09-10', NULL, 'Labour', 111543535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011051', 'Daniel', 'J', '8085 Sunnyvale Avenue', NULL, NULL, NULL, '1955-08-14', NULL, 'Labour', 111543535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011052', 'Heidi', 'L', '2514 Via Cordona', NULL, NULL, NULL, '1955-08-10', NULL, 'Labour', 111543535016, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011053', 'Ana', 'P', '1660 Stonyhill Circle', NULL, NULL, NULL, '1984-08-10', NULL, 'Labour', 859535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011054', 'Deanna', 'M', '5825 B Way', NULL, NULL, NULL, '1956-03-20', NULL, 'Labour', 111543535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011055', 'Gilbert', 'R', '8811 The Trees Dr.', NULL, NULL, NULL, '1956-03-15', NULL, 'Labour', 111543535012, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011056', 'Michele', 'N', '5464 Janin Pl.', NULL, NULL, NULL, '1957-04-13', NULL, 'Labour', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011057', 'Carl', 'A', '6930 Lake Nadine Place', NULL, NULL, NULL, '1957-10-21', NULL, 'Labour', 111543535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011058', 'Marc', 'D', '6645 Sinaloa', NULL, NULL, NULL, '1958-04-10', NULL, 'Labour', 111543535014, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011059', 'Ashlee', 'A', '8255 Highland Road', NULL, NULL, NULL, '1958-04-13', NULL, 'Labour', 111543535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011111', 'Meredith', 'G', '7610 Northridge Ct.', NULL, NULL, NULL, '1966-02-13', NULL, 'Labour', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011112', 'Crystal', 'W', '2773 Kirkwood Dr', NULL, NULL, NULL, '1966-09-19', NULL, 'Labour', 111543535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011113', 'Micheal', 'B', '596 Marfargoa Drive', NULL, NULL, NULL, '1966-02-13', NULL, 'Labour', 111543535013, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011114', 'Leslie', 'M', '7941 Cristobal', NULL, NULL, NULL, '1966-05-18', NULL, 'Labour', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011115', 'Alvin', 'C', '7759 Azalea Avenue', NULL, NULL, NULL, '1966-02-21', NULL, 'Labour', 111543535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011116', 'Clinton', 'C', '7943 Cunha Ct.', NULL, NULL, NULL, '1966-10-10', NULL, 'Labour', 111543535018, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011117', 'April', 'D', '485 Ash Lane', NULL, NULL, NULL, '1965-02-13', NULL, 'Labour', 111543535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011119', 'Evan', 'J', '4157 Sierra Ridge', NULL, NULL, NULL, '1939-04-20', NULL, 'Retiree', 111543535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011150', 'Russell', 'S', '4755 Easley Drive', NULL, NULL, NULL, '1945-03-25', NULL, 'Retiree', 111543535019, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011151', 'Melinda', 'G', '805 Rainier Dr.', NULL, NULL, NULL, '1946-02-15', NULL, 'Labour', 111543535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011152', 'James', 'W', '6827 Seagull Court', NULL, NULL, NULL, '1980-01-20', NULL, 'Labour', 355535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011153', 'Angela', 'J', '8877 Weatherly Drive', NULL, NULL, NULL, '1980-06-13', NULL, 'Labour', 847535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011154', 'Megan', 'W', '6898 Holiday Hills', NULL, NULL, NULL, '1980-08-13', NULL, 'Labour', 918535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011155', 'Hunter', 'R', '8356 Mori Court', NULL, NULL, NULL, '1980-01-16', NULL, 'Labour', 891535012, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011156', 'Maria', 'R', '9452 Mariposa Ct.', NULL, NULL, NULL, '1980-02-10', NULL, 'Labour', 158535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011157', 'Hannah', 'L', '1832 Preston Ct.', NULL, NULL, NULL, '1979-06-23', NULL, 'Labour', 974535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011158', 'Jason', 'W', '6771 Bundros Court', NULL, NULL, NULL, '1979-10-18', NULL, 'Labour', 694535017, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011159', 'Brianna', 'H', '6793 Bonifacio St.', NULL, NULL, NULL, '1979-09-20', NULL, 'Labour', 319535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011210', 'Edward', 'W', '1039 Adelaide St.', NULL, NULL, NULL, '1952-06-18', NULL, 'Researcher', 229535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011213', 'Stephanie', 'M', '5514 Grant Street', NULL, NULL, NULL, '1953-05-24', NULL, 'Researcher', 293535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011214', 'Charles', 'M', '2719 Little Dr', NULL, NULL, NULL, '1953-11-10', NULL, 'Researcher', 389535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011215', 'Ana', 'P', '3114 Arlington Way', NULL, NULL, NULL, '1954-06-13', NULL, 'Researcher', 446535013, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011216', 'Jasmine', 'T', '8328 San Francisco', NULL, NULL, NULL, '1954-05-10', NULL, 'Researcher', 939535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011217', 'Natalie', 'A', '6592 Bent Tree Lane', NULL, NULL, NULL, '1954-02-23', NULL, 'Researcher', 300535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011218', 'Olivia', 'B', '3964 Stony Hill Circle', NULL, NULL, NULL, '1954-09-23', NULL, 'Researcher', 414535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011219', 'Charles', 'C', '6871 Bel Air Dr.', NULL, NULL, NULL, '1954-12-11', NULL, 'Researcher', 755535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011250', 'Shannon', 'L', '4185 Keywood Ct.', NULL, NULL, NULL, '1959-03-21', NULL, 'Manager', 111543535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011251', 'Xavier', 'L', '9245 Dantley Way', NULL, NULL, NULL, '1936-07-14', NULL, 'Retiree', 243535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011252', 'Nicholas', 'T', '504 O St.', NULL, NULL, NULL, '1936-06-10', NULL, 'Retiree', 377535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011253', 'José', 'H', '5703 Donald Dr.', NULL, NULL, NULL, '1937-02-18', NULL, 'Retiree', 712535013, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011254', 'Johnathan', 'V', '9430 Versailles Pl', NULL, NULL, NULL, '1937-03-13', NULL, 'Retiree', 494535016, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011255', 'Colin', 'L', '6083 San Jose', NULL, NULL, NULL, '1937-04-14', NULL, 'Retiree', 599535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011256', 'Katelyn', 'H', '7496 Deerfield Dr.', NULL, NULL, NULL, '1937-09-10', NULL, 'Retiree', 249535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011257', 'Jacqueline', 'P', '4076 Northwood Dr', NULL, NULL, NULL, '1937-01-16', NULL, 'Retiree', 796535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011258', 'Xavier', 'H', '2707 Virgil Street', NULL, NULL, NULL, '1937-06-18', NULL, 'Retiree', 559535014, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011259', 'Victoria', 'S', '3623 Barquentine Court', NULL, NULL, NULL, '1969-03-10', NULL, 'Manager', 230535013, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011310', 'Erin', 'S', '7541 Black Point Pl', NULL, NULL, NULL, '1957-07-19', NULL, 'Manager', 233535016, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011311', 'Gabrielle', 'L', '8619 Parkside Dr.', NULL, NULL, NULL, '1957-08-14', NULL, 'Manager', 783535017, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011312', 'Sara', 'R', '7375 Kipling Court', NULL, NULL, NULL, '1957-04-13', NULL, 'Manager', 296535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011313', 'Trevor', 'J', '4697 Yosemite Dr.', NULL, NULL, NULL, '1957-02-10', NULL, 'Manager', 120535012, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011314', 'Mya', 'F', '8439 Rio Grande Drive', NULL, NULL, NULL, '1957-12-13', NULL, 'Manager', 522535014, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011315', 'Hailey', 'W', '6321 Maya', NULL, NULL, NULL, '1957-10-13', NULL, 'Manager', 767535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011316', 'Luke', 'A', '419 Deermeadow Way', NULL, NULL, NULL, '1957-11-20', NULL, 'Manager', 786535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011317', 'Victoria', 'R', '9268 Keller Ridge', NULL, NULL, NULL, '1956-09-20', NULL, 'Manager', 663535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011318', 'Jessica', 'W', '1652 Willcrest Circle', NULL, NULL, NULL, '1956-10-16', NULL, 'Manager', 702535018, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011319', 'Jade', 'B', '8119 Northridge Ct', NULL, NULL, NULL, '1941-04-10', NULL, 'Retiree', 819535016, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011350', 'Cara', 'Z', '7280 Greendell Pl', NULL, NULL, NULL, '1941-01-24', NULL, 'Retiree', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011351', 'Anne', 'R', '7113 Eastgate Ave.', NULL, NULL, NULL, '1943-04-16', NULL, 'Retiree', 111543535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011352', 'Raymond', 'R', '24, impasse Ste-Madeleine', NULL, NULL, NULL, '1944-03-10', NULL, 'Retiree', 111543535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011353', 'Carrie', 'O', '1883 Cowell Rd.', NULL, NULL, NULL, '1945-06-23', NULL, 'Retiree', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011354', 'Deanna', 'S', 'Dunckerstr 22525', NULL, NULL, NULL, '1946-02-13', NULL, 'Manager', 111543535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011355', 'Roberto', 'G', '3545 Chickpea Ct.', NULL, NULL, NULL, '1946-12-18', NULL, 'Manager', 111543535012, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011356', 'Terrence', 'C', '6613 Thornhill Place', NULL, NULL, NULL, '1984-05-10', NULL, 'Manager', 111543535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011357', 'Ramon', 'Y', '3245 Vista Oak Dr.', NULL, NULL, NULL, '1983-03-13', NULL, 'Manager', 111543535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011358', 'Cynthia', 'M', '6757 Pamplona Ct.', NULL, NULL, NULL, '1982-11-23', NULL, 'Manager', 111543535018, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011359', 'Jarrod', 'P', '7657 H St.', NULL, NULL, NULL, '1982-09-14', NULL, 'Manager', 111543535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011410', 'Maurice', 'G', '15, avenue de la Gare', NULL, NULL, NULL, '1972-08-15', NULL, 'Manager', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011411', 'Devin', 'R', 'Postenweg 2428', NULL, NULL, NULL, '1958-02-21', NULL, 'Manager', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011412', 'Sydney', 'B', 'Postfach 99 92 92', NULL, NULL, NULL, '1958-04-19', NULL, 'Manager', 111543535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011413', 'Megan', 'S', '8192 Seagull Court', NULL, NULL, NULL, '1958-04-25', NULL, 'Manager', 111543535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011414', 'Ian', 'R', '726 W. Buchanan Rd.', NULL, NULL, NULL, '1958-03-28', NULL, 'Manager', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011415', 'Randy', 'S', 'Ro?str 5538', NULL, NULL, NULL, '1948-06-15', NULL, 'Manager', 111543535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011416', 'Katrina', 'B', '8205, rue Malar', NULL, NULL, NULL, '1949-03-29', NULL, 'Manager', 111543535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011417', 'Lacey', 'Z', '4, rue de Linois', NULL, NULL, NULL, '1949-02-16', NULL, 'Manager', 111543535017, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011418', 'Rafael', 'H', 'Zeiter Weg 7765', NULL, NULL, NULL, '1949-02-19', NULL, 'Manager', 111543535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011419', 'Kyle', 'S', '9381 Alpine Rd.', NULL, NULL, NULL, '1949-02-28', NULL, 'Manager', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011459', 'Tasha', 'D', '9627 Kendall Rd', NULL, NULL, NULL, '1976-10-23', NULL, 'Nurse', 111543535017, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011510', 'Seth', 'R', '5989 Concord Ave', NULL, NULL, NULL, '1957-07-23', NULL, 'Nurse', 199535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011511', 'Caleb', 'P', '2324 Cherry Street', NULL, NULL, NULL, '1957-06-24', NULL, 'Nurse', 786535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011512', 'Natalie', 'C', '3481 Broadmoor Drive', NULL, NULL, NULL, '1958-08-23', NULL, 'Nurse', 178535014, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011513', 'Alyssa', 'H', '5780 Conifer Terrace', NULL, NULL, NULL, '1958-09-10', NULL, 'Nurse', 805535018, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011514', 'Dalton', 'D', '8033 Danesta Dr.', NULL, NULL, NULL, '1958-04-10', NULL, 'Nurse', 994535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011515', 'Shannon', 'H', '4679 Duke Way', NULL, NULL, NULL, '1958-02-15', NULL, 'Nurse', 458535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011516', 'Mya', 'G', '8826 Fine Drive', NULL, NULL, NULL, '1958-10-13', NULL, 'Nurse', 211535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011517', 'Katherine', 'B', '8761 Dancing Court', NULL, NULL, NULL, '1958-06-10', NULL, 'Nurse', 802535013, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011518', 'Edward', 'W', '2747 Carmel Dr.', NULL, NULL, NULL, '1959-05-20', NULL, 'Nurse', 446535017, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011519', 'Jerome', 'N', '9537 Ridgewood Drive', NULL, NULL, NULL, '1959-03-20', NULL, 'Nurse', 934535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011535', 'Alexandria', 'H', '11, rue de la Cavalerie', NULL, NULL, NULL, '1930-07-18', NULL, 'Retiree', 111543535018, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011550', 'Deb', 'T', '7553 Harness Circle', NULL, NULL, NULL, '1972-08-18', NULL, 'Nurse', 111543535012, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011551', 'Shannon', 'A', '268, avenue de l?Europe', NULL, NULL, NULL, '1971-05-15', NULL, 'Nurse', 111543535015, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011552', 'Eddie', 'R', 'Heiderplatz 662', NULL, NULL, NULL, '1971-05-10', NULL, 'Nurse', 111543535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011553', 'Sharon', 'L', '6804 Coldwater Drive', NULL, NULL, NULL, '1971-09-19', NULL, 'Nurse', 111543535011, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011554', 'Sydney', 'S', '88, avenue de l? Union Centrale', NULL, NULL, NULL, '1930-09-18', NULL, 'Retiree', 111543535019, NULL, NULL, NULL, NULL, NULL, 'F', 0),
  ('C0011556', 'Lucas', 'E', '3663 A St.', NULL, NULL, NULL, '1971-05-24', NULL, 'Nurse', 111543535015, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011557', 'Felicia', 'R', '9557 Steven Circle', NULL, NULL, NULL, '1971-01-25', NULL, 'Nurse', 111543535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011558', 'Ivan', 'M', '5086 Nottingham Place', NULL, NULL, NULL, '1971-08-11', NULL, 'Nurse', 111543535019, NULL, NULL, NULL, NULL, NULL, 'M', 0),
  ('C0011559', 'Frederick', 'S', 'Rotth?user Weg 636', NULL, NULL, NULL, '1971-12-26', NULL, 'Nurse', 111543535011, NULL, NULL, NULL, NULL, NULL, 'M', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_employee`
  --
  
  DROP TABLE IF EXISTS `crcapp_employee`;
  CREATE TABLE IF NOT EXISTS `crcapp_employee` (
    `employeeID` varchar(10) NOT NULL,
    `firstName` varchar(50) NOT NULL,
    `lastName` varchar(50) NOT NULL,
    `streetAddress` varchar(50) NOT NULL,
    `cityAddress` varchar(50) NOT NULL,
    `postCodeAddress` int(11) NOT NULL,
    `stateAddress` varchar(50) NOT NULL,
    `DOB` date NOT NULL,
    `TFN` bigint(20) NOT NULL,
    `phoneNumber` bigint(20) NOT NULL,
    `email` varchar(254) NOT NULL,
    `userName` varchar(50) DEFAULT NULL,
    `password` longtext,
    `dateJoined` date NOT NULL,
    `lastLogin` date NOT NULL,
    `storeID_id` varchar(10) DEFAULT NULL,
    `userType` varchar(16) NOT NULL,
    `disable` tinyint(1) NOT NULL,
    PRIMARY KEY (`employeeID`),
    KEY `crcapp_employee_storeID_id_df63687d` (`storeID_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_employee`
  --
  
  INSERT INTO `crcapp_employee` (`employeeID`, `firstName`, `lastName`, `streetAddress`, `cityAddress`, `postCodeAddress`, `stateAddress`, `DOB`, `TFN`, `phoneNumber`, `email`, `userName`, `password`, `dateJoined`, `lastLogin`, `storeID_id`, `userType`, `disable`) VALUES
  ('E00001', 'Dev', 'Team Bois', ' 2 George St', 'Brisbane ', 4000, 'QLD', '2018-08-05', 1, 1000000, 'admin@admin.com', 'dev', 'argon2$argon2i$v=19$m=512,t=2,p=2$dHJmeFhiNm5qd0s1$EPUBcr3FsVh4dLom/iytXw', '2018-09-05', '2018-09-24', 'S0020', 'Developer', 0),
  ('E00002', 'Jax', 'Lee', 'Test', 'Brisbane', 4000, 'QLD', '1998-09-12', 4548545558, 422325325, 'jax@jax.com', 'gsjaxl', 'argon2$argon2i$v=19$m=512,t=2,p=2$dTUxWW1ydEZWYnhM$LvDMKxTis3QPiXYTxngH4Q', '2018-09-12', '2018-09-17', 'S0004', 'Manager', 0),
  ('E00003', 'Frank', 'King', 'Test', 'Brisbane', 4000, 'QLD', '1992-06-19', 1234567898, 412121212, 'sample@sample.com', 'csfrankk1', 'argon2$argon2i$v=19$m=512,t=2,p=2$T1N4ejc5NEJkSnly$ULISu+PtY7h8FnCJQm6Dew', '2018-09-17', '2018-09-17', 'S0021', 'Staff', 0),
  ('E00004', 'Oscar', 'Li', 'Test', 'Sydeny', 4000, 'QLD', '1998-09-12', 544545454, 45454545, 'sample@sample.com', 'ssoscarl1', 'argon2$argon2i$v=19$m=512,t=2,p=2$cEJlR0xhTFdzeDZY$00WNEd8BCYW38zsWSwph4Q', '2018-09-17', '2018-09-19', 'S0018', 'Staff', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_inspects`
  --
  
  DROP TABLE IF EXISTS `crcapp_inspects`;
  CREATE TABLE IF NOT EXISTS `crcapp_inspects` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `employeeID_id` varchar(10) DEFAULT NULL,
    `vehicleID_id` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `crcapp_inspects_employeeID_id_vehicleID_id_83572f35_uniq` (`employeeID_id`,`vehicleID_id`),
    KEY `crcapp_inspects_employeeID_id_9c71115a` (`employeeID_id`),
    KEY `crcapp_inspects_vehicleID_id_fa8eca30` (`vehicleID_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_invoice`
  --
  
  DROP TABLE IF EXISTS `crcapp_invoice`;
  CREATE TABLE IF NOT EXISTS `crcapp_invoice` (
    `invoiceID` varchar(10) NOT NULL,
    `amount` decimal(12,2) NOT NULL,
    `paymentType` varchar(20) NOT NULL,
    `orderID_id` varchar(12) DEFAULT NULL,
    PRIMARY KEY (`invoiceID`),
    KEY `crcapp_invoice_orderID_id_8fbd017e` (`orderID_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_order`
  --
  
  DROP TABLE IF EXISTS `crcapp_order`;
  CREATE TABLE IF NOT EXISTS `crcapp_order` (
    `orderID` varchar(12) NOT NULL,
    `orderDate` date NOT NULL,
    `pickupDate` date NOT NULL,
    `returnDate` date NOT NULL,
    `customerID_id` varchar(10) DEFAULT NULL,
    `employeeID_id` varchar(10) DEFAULT NULL,
    `pickupStoreID_id` varchar(10) DEFAULT NULL,
    `returnStoreID_id` varchar(10) DEFAULT NULL,
    `orderType` varchar(16) NOT NULL,
    PRIMARY KEY (`orderID`),
    KEY `crcapp_order_customerID_id_fb5b78f3` (`customerID_id`),
    KEY `crcapp_order_employeeID_id_e766cf67` (`employeeID_id`),
    KEY `crcapp_order_pickupStoreID_id_22093484` (`pickupStoreID_id`),
    KEY `crcapp_order_returnStoreID_id_6786777b` (`returnStoreID_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_order`
  --
  
  INSERT INTO `crcapp_order` (`orderID`, `orderDate`, `pickupDate`, `returnDate`, `customerID_id`, `employeeID_id`, `pickupStoreID_id`, `returnStoreID_id`, `orderType`) VALUES
  ('O000003', '2005-07-03', '2005-07-03', '2005-07-11', 'C0011014', 'E00001', 'S0003', 'S0016', 'In Store'),
  ('O000004', '2005-07-04', '2005-07-04', '2005-07-09', 'C0011012', 'E00002', 'S0012', 'S0008', 'In Store'),
  ('O000005', '2005-07-05', '2005-07-05', '2005-07-10', 'C0011011', 'E00003', 'S0005', 'S0005', 'In Store'),
  ('O000006', '2005-07-06', '2005-07-09', '2005-07-15', 'C0011011', 'E00004', 'S0006', 'S0025', 'In Store'),
  ('O000007', '2005-07-07', '2005-07-07', '2005-07-15', 'C0011014', 'E00005', 'S0007', 'S0014', 'In Store'),
  ('O000008', '2005-07-08', '2005-07-09', '2005-07-16', 'C0011016', 'E00006', 'S0008', 'S0029', 'In Store'),
  ('O000009', '2005-07-09', '2005-07-09', '2005-07-18', 'C0011014', 'E00007', 'S0009', 'S0018', 'In Store'),
  ('O000011', '2005-07-11', '2005-07-11', '2005-07-16', 'C0011059', 'E00008', 'S0011', 'S0013', 'In Store'),
  ('O000012', '2005-07-12', '2005-07-15', '2005-08-13', 'C0011017', 'E00009', 'S0025', 'S0025', 'In Store'),
  ('O000013', '2005-07-13', '2005-07-14', '2005-07-21', 'C0011054', 'E00010', 'S0050', 'S0013', 'In Store'),
  ('O000014', '2005-07-14', '2005-07-15', '2005-07-19', 'C0011055', 'E00011', 'S0014', 'S0014', 'In Store'),
  ('O000015', '2005-07-15', '2005-07-15', '2005-07-24', 'C0011056', 'E00012', 'S0015', 'S0015', 'In Store'),
  ('O000016', '2005-07-16', '2005-07-16', '2005-08-17', 'C0011052', 'E00013', 'S0029', 'S0029', 'In Store'),
  ('O000017', '2005-07-17', '2005-07-17', '2005-07-22', 'C0011011', 'E00014', 'S0017', 'S0050', 'In Store'),
  ('O000018', '2005-07-18', '2005-07-18', '2005-07-23', 'C0011055', 'E00015', 'S0018', 'S0018', 'In Store'),
  ('O000019', '2005-07-19', '2005-07-20', '2005-08-10', 'C0011017', 'E00016', 'S0014', 'S0014', 'In Store'),
  ('O000020', '2005-07-20', '2005-07-23', '2005-08-04', 'C0011052', 'E00017', 'S0015', 'S0035', 'In Store'),
  ('O000021', '2005-07-21', '2005-07-21', '2005-08-10', 'C0011053', 'E00018', 'S0050', 'S0001', 'In Store'),
  ('O000022', '2005-07-22', '2005-07-22', '2005-08-08', 'C0011018', 'E00019', 'S0017', 'S0039', 'In Store'),
  ('O000023', '2005-07-23', '2005-07-23', '2005-08-07', 'C0011015', 'E00020', 'S0015', 'S0025', 'In Store'),
  ('O000024', '2005-07-24', '2005-07-27', '2005-08-12', 'C0011018', 'E00021', 'S0019', 'S0019', 'In Store'),
  ('O000025', '2005-07-25', '2005-07-25', '2005-08-14', 'C0011016', 'E00022', 'S0025', 'S0005', 'In Store'),
  ('O000026', '2005-07-26', '2005-07-29', '2005-08-14', 'C0011018', 'E00023', 'S0021', 'S0021', 'In Store'),
  ('O000027', '2005-07-27', '2005-07-27', '2005-08-12', 'C0011051', 'E00024', 'S0019', 'S0003', 'In Store'),
  ('O000028', '2005-07-28', '2005-07-28', '2005-08-21', 'C0011054', 'E00025', 'S0050', 'S0022', 'In Store'),
  ('O000029', '2005-07-29', '2005-07-29', '2005-08-18', 'C0011016', 'E00026', 'S0029', 'S0009', 'In Store'),
  ('O000030', '2005-07-30', '2005-07-30', '2005-08-20', 'C0011016', 'E00027', 'S0030', 'S0010', 'In Store'),
  ('O000031', '2005-07-31', '2005-07-31', '2005-08-24', 'C0011012', 'E00028', 'S0021', 'S0024', 'In Store'),
  ('O000032', '2005-08-01', '2005-08-04', '2005-08-06', 'C0011015', 'E00029', 'S0021', 'S0021', 'In Store'),
  ('O000033', '2005-08-02', '2005-08-02', '2005-08-07', 'C0011019', 'E00030', 'S0033', 'S0015', 'In Store'),
  ('O000034', '2005-08-03', '2005-08-03', '2005-08-24', 'C0011057', 'E00031', 'S0021', 'S0021', 'In Store'),
  ('O000035', '2005-08-04', '2005-08-04', '2005-08-13', 'C0011056', 'E00032', 'S0035', 'S0035', 'In Store'),
  ('O000036', '2005-08-05', '2005-08-05', '2005-08-26', 'C0011057', 'E00033', 'S0023', 'S0023', 'In Store'),
  ('O000037', '2005-08-06', '2005-08-06', '2005-08-15', 'C0011013', 'E00034', 'S0037', 'S0037', 'In Store'),
  ('O000038', '2005-08-07', '2005-08-07', '2005-08-28', 'C0011012', 'E00035', 'S0025', 'S0025', 'In Store'),
  ('O000039', '2005-08-08', '2005-08-08', '2005-08-16', 'C0011014', 'E00036', 'S0039', 'S0009', 'In Store'),
  ('O000040', '2005-08-09', '2005-08-10', '2005-09-21', 'C0011013', 'E00037', 'S0040', 'S0015', 'In Store'),
  ('O000041', '2005-08-10', '2005-08-10', '2005-08-19', 'C0011016', 'E00038', 'S0001', 'S0001', 'In Store'),
  ('O000042', '2005-08-11', '2005-08-14', '2005-08-16', 'C0011015', 'E00039', 'S0013', 'S0013', 'In Store'),
  ('O000043', '2005-08-12', '2005-08-12', '2005-08-17', 'C0011059', 'E00040', 'S0003', 'S0010', 'In Store'),
  ('O000044', '2005-08-13', '2005-08-16', '2005-08-28', 'C0011051', 'E00041', 'S0015', 'S0019', 'In Store'),
  ('O000045', '2005-08-14', '2005-08-14', '2005-08-23', 'C0011053', 'E00042', 'S0005', 'S0005', 'In Store'),
  ('O000046', '2005-08-15', '2005-08-15', '2005-09-01', 'C0011051', 'E00043', 'S0017', 'S0023', 'In Store'),
  ('O000047', '2005-08-16', '2005-08-16', '2005-08-24', 'C0011053', 'E00044', 'S0007', 'S0014', 'In Store'),
  ('O000048', '2005-08-17', '2005-08-18', '2005-09-08', 'C0011017', 'E00045', 'S0022', 'S0030', 'In Store'),
  ('O000049', '2005-08-18', '2005-08-18', '2005-08-27', 'C0011053', 'E00046', 'S0009', 'S0018', 'In Store'),
  ('O000050', '2005-08-19', '2005-08-20', '2005-08-29', 'C0011050', 'E00047', 'S0010', 'S0011', 'In Store'),
  ('O000051', '2005-08-20', '2005-08-21', '2005-08-25', 'C0011015', 'E00048', 'S0022', 'S0022', 'In Store'),
  ('O000052', '2005-08-21', '2005-08-21', '2005-09-07', 'C0011015', 'E00049', 'S0023', 'S0016', 'In Store'),
  ('O000053', '2005-08-22', '2005-08-22', '2005-09-10', 'C0011018', 'E00050', 'S0009', 'S0009', 'In Store'),
  ('O000054', '2005-08-23', '2005-08-24', '2005-09-12', 'C0011053', 'E00051', 'S0014', 'S0014', 'In Store'),
  ('O000055', '2005-08-24', '2005-08-24', '2005-09-15', 'C0011012', 'E00052', 'S0024', 'S0024', 'In Store'),
  ('O000056', '2005-08-25', '2005-08-26', '2005-09-10', 'C0011019', 'E00053', 'S0016', 'S0014', 'In Store'),
  ('O000057', '2005-08-26', '2005-08-26', '2005-09-14', 'C0011018', 'E00054', 'S0013', 'S0013', 'In Store'),
  ('O000058', '2005-08-27', '2005-08-27', '2005-09-12', 'C0011011', 'E00055', 'S0018', 'S0018', 'In Store'),
  ('O000059', '2005-08-28', '2005-08-28', '2005-09-13', 'C0011019', 'E00056', 'S0019', 'S0009', 'In Store'),
  ('O000060', '2005-08-29', '2005-08-29', '2005-09-10', 'C0011012', 'E00057', 'S0011', 'S0011', 'In Store'),
  ('O000061', '2005-08-30', '2005-08-30', '2005-09-18', 'C0011054', 'E00058', 'S0017', 'S0021', 'In Store'),
  ('O000062', '2005-08-31', '2005-08-31', '2005-09-16', 'C0011011', 'E00059', 'S0050', 'S0022', 'In Store'),
  ('O000063', '2005-09-01', '2005-09-01', '2005-09-10', 'C0011053', 'E00060', 'S0023', 'S0023', 'In Store'),
  ('O000064', '2005-09-02', '2005-09-02', '2005-09-23', 'C0011052', 'E00061', 'S0017', 'S0017', 'In Store'),
  ('O000065', '2005-09-03', '2005-09-03', '2005-09-11', 'C0011054', 'E00062', 'S0018', 'S0025', 'In Store'),
  ('O000066', '2005-09-04', '2005-09-05', '2005-09-13', 'C0011056', 'E00063', 'S0026', 'S0026', 'In Store'),
  ('O000067', '2005-09-05', '2005-09-05', '2005-09-10', 'C0011011', 'E00064', 'S0027', 'S0027', 'In Store'),
  ('O000068', '2005-09-06', '2005-09-07', '2005-09-07', 'C0011057', 'E00065', 'S0016', 'S0017', 'In Store'),
  ('O000069', '2005-09-07', '2005-09-07', '2005-09-28', 'C0011057', 'E00066', 'S0017', 'S0017', 'In Store'),
  ('O000070', '2005-09-08', '2005-09-08', '2005-09-13', 'C0011055', 'E00067', 'S0030', 'S0030', 'In Store'),
  ('O000071', '2005-09-09', '2005-09-09', '2005-09-14', 'C0011011', 'E00068', 'S0031', 'S0031', 'In Store'),
  ('O000072', '2005-09-10', '2005-09-11', '2005-10-01', 'C0011010', 'E00069', 'S0032', 'S0021', 'In Store'),
  ('O000073', '2005-09-11', '2005-09-11', '2005-09-16', 'C0011015', 'E00070', 'S0023', 'S0023', 'In Store'),
  ('O000074', '2005-09-12', '2005-09-15', '2005-09-17', 'C0011015', 'E00071', 'S0024', 'S0024', 'In Store'),
  ('O000075', '2005-09-13', '2005-09-14', '2005-10-14', 'C0011017', 'E00072', 'S0028', 'S0028', 'In Store'),
  ('O000076', '2005-09-14', '2005-09-15', '2005-09-19', 'C0011015', 'E00073', 'S0026', 'S0026', 'In Store'),
  ('O000077', '2005-09-15', '2005-09-15', '2005-09-24', 'C0011013', 'E00074', 'S0037', 'S0037', 'In Store'),
  ('O000078', '2005-09-16', '2005-09-17', '2005-09-24', 'C0011014', 'E00075', 'S0038', 'S0013', 'In Store'),
  ('O000079', '2005-09-17', '2005-09-17', '2005-09-25', 'C0011014', 'E00076', 'S0039', 'S0014', 'In Store'),
  ('O000080', '2005-09-18', '2005-09-21', '2005-10-19', 'C0011017', 'E00077', 'S0015', 'S0015', 'In Store'),
  ('O000081', '2005-09-19', '2005-09-19', '2005-09-24', 'C0011051', 'E00078', 'S0013', 'S0013', 'In Store'),
  ('O000082', '2005-09-20', '2005-09-20', '2005-10-11', 'C0011057', 'E00079', 'S0012', 'S0012', 'In Store'),
  ('O000083', '2005-09-21', '2005-09-21', '2005-09-26', 'C0011055', 'E00080', 'S0003', 'S0003', 'In Store'),
  ('O000084', '2005-09-22', '2005-09-23', '2005-10-10', 'C0011010', 'E00081', 'S0004', 'S0004', 'In Store'),
  ('O000085', '2005-09-23', '2005-09-24', '2005-10-14', 'C0011052', 'E00082', 'S0020', 'S0020', 'In Store'),
  ('O000086', '2005-09-24', '2005-09-27', '2005-10-12', 'C0011054', 'E00083', 'S0021', 'S0006', 'In Store'),
  ('O000087', '2005-09-25', '2005-09-25', '2005-10-13', 'C0011058', 'E00084', 'S0007', 'S0007', 'In Store'),
  ('O000088', '2005-09-26', '2005-09-26', '2005-10-17', 'C0011052', 'E00085', 'S0023', 'S0023', 'In Store'),
  ('O000089', '2005-09-27', '2005-09-27', '2005-10-12', 'C0011051', 'E00086', 'S0021', 'S0021', 'In Store'),
  ('O000090', '2005-09-28', '2005-09-29', '2005-10-19', 'C0011057', 'E00087', 'S0020', 'S0020', 'In Store'),
  ('O000091', '2005-09-29', '2005-09-29', '2005-10-17', 'C0011014', 'E00088', 'S0011', 'S0010', 'In Store'),
  ('O000092', '2005-09-30', '2005-09-30', '2005-10-15', 'C0011015', 'E00089', 'S0024', 'S0024', 'In Store'),
  ('O000093', '2005-10-01', '2005-10-01', '2005-10-07', 'C0011012', 'E00090', 'S0021', 'S0026', 'In Store'),
  ('O000094', '2005-10-02', '2005-10-02', '2005-10-07', 'C0011051', 'E00091', 'S0024', 'S0024', 'In Store'),
  ('O000095', '2005-10-03', '2005-10-03', '2005-10-08', 'C0011015', 'E00092', 'S0025', 'S0025', 'In Store'),
  ('O000096', '2005-10-04', '2005-10-05', '2005-10-09', 'C0011051', 'E00093', 'S0026', 'S0026', 'In Store'),
  ('O000097', '2005-10-05', '2005-10-05', '2005-10-13', 'C0011014', 'E00094', 'S0017', 'S0014', 'In Store'),
  ('O000098', '2005-10-06', '2005-10-07', '2005-10-27', 'C0011012', 'E00095', 'S0026', 'S0026', 'In Store'),
  ('O000099', '2005-10-07', '2005-10-08', '2005-10-28', 'C0011017', 'E00096', 'S0014', 'S0014', 'In Store'),
  ('O000100', '2005-10-08', '2005-10-09', '2005-10-17', 'C0011016', 'E00097', 'S0020', 'S0020', 'In Store'),
  ('O000101', '2005-10-09', '2005-10-09', '2005-10-18', 'C0011113', 'E00098', 'S0021', 'S0021', 'In Store'),
  ('O000102', '2005-10-10', '2005-10-10', '2005-10-18', 'C0011114', 'E00099', 'S0017', 'S0022', 'In Store'),
  ('O000103', '2005-10-11', '2005-10-11', '2005-10-22', 'C0011114', 'E00100', 'S0018', 'S0010', 'In Store'),
  ('O000104', '2005-10-12', '2005-10-15', '2005-10-21', 'C0011116', 'E00101', 'S0024', 'S0024', 'In Store'),
  ('O000105', '2005-10-13', '2005-10-13', '2005-10-18', 'C0011115', 'E00102', 'S0025', 'S0025', 'In Store'),
  ('O000106', '2005-10-14', '2005-10-14', '2005-10-25', 'C0011112', 'E00103', 'S0021', 'S0010', 'In Store'),
  ('O000107', '2005-10-15', '2005-10-15', '2005-10-24', 'C0011113', 'E00104', 'S0027', 'S0027', 'In Store'),
  ('O000108', '2005-10-16', '2005-10-17', '2005-10-21', 'C0011111', 'E00105', 'S0020', 'S0020', 'In Store'),
  ('O000109', '2005-10-17', '2005-10-17', '2005-10-22', 'C0011119', 'E00106', 'S0029', 'S0015', 'In Store'),
  ('O000110', '2005-10-18', '2005-10-21', '2005-11-19', 'C0011112', 'E00107', 'S0025', 'S0025', 'In Store'),
  ('O000111', '2005-10-19', '2005-10-19', '2005-11-10', 'C0011117', 'E00108', 'S0021', 'S0021', 'In Store'),
  ('O000112', '2005-10-20', '2005-10-21', '2005-10-25', 'C0011119', 'E00109', 'S0032', 'S0010', 'In Store'),
  ('O000113', '2005-10-21', '2005-10-22', '2005-10-26', 'C0011114', 'E00110', 'S0010', 'S0014', 'In Store'),
  ('O000114', '2005-10-22', '2005-10-23', '2005-10-27', 'C0011111', 'E00111', 'S0026', 'S0026', 'In Store'),
  ('O000115', '2005-10-23', '2005-10-23', '2005-10-28', 'C0011115', 'E00112', 'S0035', 'S0035', 'In Store'),
  ('O000116', '2005-10-24', '2005-10-25', '2005-11-08', 'C0011111', 'E00113', 'S0010', 'S0025', 'In Store'),
  ('O000117', '2005-10-25', '2005-10-26', '2005-10-26', 'C0011114', 'E00114', 'S0014', 'S0015', 'In Store'),
  ('O000118', '2005-10-26', '2005-10-26', '2005-10-28', 'C0011112', 'E00115', 'S0015', 'S0016', 'In Store'),
  ('O000119', '2005-10-27', '2005-10-28', '2005-11-15', 'C0011114', 'E00116', 'S0016', 'S0039', 'In Store'),
  ('O000120', '2005-10-28', '2005-10-28', '2005-11-10', 'C0011117', 'E00117', 'S0012', 'S0013', 'In Store'),
  ('O000121', '2005-10-29', '2005-10-29', '2005-11-17', 'C0011114', 'E00118', 'S0018', 'S0001', 'In Store'),
  ('O000122', '2005-10-30', '2005-10-30', '2005-11-18', 'C0011158', 'E00119', 'S0002', 'S0002', 'In Store'),
  ('O000123', '2005-10-31', '2005-10-31', '2005-11-12', 'C0011116', 'E00120', 'S0003', 'S0009', 'In Store'),
  ('O000124', '2005-11-01', '2005-11-01', '2005-11-12', 'C0011111', 'E00121', 'S0015', 'S0010', 'In Store'),
  ('O000125', '2005-11-02', '2005-11-02', '2005-11-11', 'C0011116', 'E00122', 'S0005', 'S0005', 'In Store'),
  ('O000126', '2005-11-03', '2005-11-04', '2005-11-24', 'C0011112', 'E00123', 'S0020', 'S0020', 'In Store'),
  ('O000127', '2005-11-04', '2005-11-04', '2005-11-28', 'C0011115', 'E00124', 'S0007', 'S0024', 'In Store'),
  ('O000128', '2005-11-05', '2005-11-06', '2005-11-13', 'C0011158', 'E00125', 'S0008', 'S0008', 'In Store'),
  ('O000129', '2005-11-06', '2005-11-07', '2005-12-01', 'C0011159', 'E00126', 'S0020', 'S0025', 'In Store'),
  ('O000130', '2005-11-07', '2005-11-07', '2005-11-15', 'C0011114', 'E00127', 'S0024', 'S0010', 'In Store'),
  ('O000131', '2005-11-08', '2005-11-08', '2005-11-14', 'C0011157', 'E00128', 'S0025', 'S0031', 'In Store'),
  ('O000132', '2005-11-09', '2005-11-12', '2005-11-15', 'C0011156', 'E00129', 'S0009', 'S0015', 'In Store'),
  ('O000133', '2005-11-10', '2005-11-10', '2005-11-14', 'C0011158', 'E00130', 'S0013', 'S0016', 'In Store'),
  ('O000134', '2005-11-11', '2005-11-12', '2005-11-12', 'C0011114', 'E00131', 'S0010', 'S0011', 'In Store'),
  ('O000135', '2005-11-12', '2005-11-12', '2005-12-10', 'C0011150', 'E00132', 'S0011', 'S0028', 'In Store'),
  ('O000136', '2005-11-13', '2005-11-14', '2005-11-16', 'C0011119', 'E00133', 'S0016', 'S0019', 'In Store'),
  ('O000137', '2005-11-14', '2005-11-14', '2005-12-15', 'C0011157', 'E00134', 'S0031', 'S0031', 'In Store'),
  ('O000138', '2005-11-15', '2005-11-15', '2005-11-24', 'C0011156', 'E00135', 'S0015', 'S0015', 'In Store'),
  ('O000139', '2005-11-16', '2005-11-16', '2005-12-06', 'C0011151', 'E00136', 'S0019', 'S0036', 'In Store'),
  ('O000140', '2005-11-17', '2005-11-18', '2005-11-22', 'C0011155', 'E00137', 'S0020', 'S0020', 'In Store'),
  ('O000141', '2005-11-18', '2005-11-18', '2005-12-10', 'C0011154', 'E00138', 'S0021', 'S0012', 'In Store'),
  ('O000142', '2005-11-19', '2005-11-19', '2005-12-10', 'C0011152', 'E00139', 'S0018', 'S0018', 'In Store'),
  ('O000143', '2005-11-20', '2005-11-20', '2005-12-02', 'C0011154', 'E00140', 'S0023', 'S0012', 'In Store'),
  ('O000144', '2005-11-21', '2005-11-24', '2005-12-06', 'C0011153', 'E00141', 'S0021', 'S0014', 'In Store'),
  ('O000145', '2005-11-22', '2005-11-22', '2005-12-11', 'C0011116', 'E00142', 'S0025', 'S0025', 'In Store'),
  ('O000146', '2005-11-23', '2005-11-24', '2005-11-28', 'C0011155', 'E00143', 'S0026', 'S0026', 'In Store'),
  ('O000147', '2005-11-24', '2005-11-24', '2005-12-05', 'C0011117', 'E00144', 'S0018', 'S0010', 'In Store'),
  ('O000148', '2005-11-25', '2005-11-26', '2005-12-10', 'C0011119', 'E00145', 'S0028', 'S0011', 'In Store'),
  ('O000149', '2005-11-26', '2005-11-27', '2005-12-15', 'C0011153', 'E00146', 'S0026', 'S0026', 'In Store'),
  ('O000150', '2005-11-27', '2005-11-27', '2005-12-15', 'C0011154', 'E00147', 'S0030', 'S0030', 'In Store'),
  ('O000151', '2005-11-28', '2005-11-28', '2005-12-13', 'C0011111', 'E00148', 'S0024', 'S0024', 'In Store'),
  ('O000152', '2005-11-29', '2005-11-29', '2005-12-10', 'C0011157', 'E00149', 'S0028', 'S0028', 'In Store'),
  ('O000153', '2005-11-30', '2005-11-30', '2005-12-19', 'C0011153', 'E00150', 'S0012', 'S0012', 'In Store'),
  ('O000154', '2005-12-01', '2005-12-01', '2005-12-06', 'C0011111', 'E00151', 'S0025', 'S0025', 'In Store'),
  ('O000155', '2005-12-02', '2005-12-02', '2005-12-07', 'C0011156', 'E00152', 'S0012', 'S0016', 'In Store'),
  ('O000156', '2005-12-03', '2005-12-06', '2005-12-08', 'C0011155', 'E00153', 'S0036', 'S0036', 'In Store'),
  ('O000157', '2005-12-04', '2005-12-05', '2005-12-09', 'C0011159', 'E00154', 'S0010', 'S0012', 'In Store'),
  ('O000158', '2005-12-05', '2005-12-06', '2005-12-08', 'C0011157', 'E00155', 'S0014', 'S0017', 'In Store'),
  ('O000159', '2005-12-06', '2005-12-07', '2005-12-07', 'C0011156', 'E00156', 'S0016', 'S0017', 'In Store'),
  ('O000160', '2005-12-07', '2005-12-07', '2005-12-11', 'C0011153', 'E00157', 'S0017', 'S0020', 'In Store'),
  ('O000161', '2005-12-08', '2005-12-08', '2005-12-12', 'C0011152', 'E00158', 'S0017', 'S0020', 'In Store'),
  ('O000162', '2005-12-09', '2005-12-10', '2006-01-03', 'C0011154', 'E00159', 'S0002', 'S0026', 'In Store'),
  ('O000163', '2005-12-10', '2005-12-11', '2005-12-15', 'C0011156', 'E00160', 'S0020', 'S0025', 'In Store'),
  ('O000164', '2005-12-11', '2005-12-12', '2005-12-18', 'C0011150', 'E00161', 'S0020', 'S0027', 'In Store'),
  ('O000165', '2005-12-12', '2005-12-12', '2005-12-22', 'C0011158', 'E00162', 'S0005', 'S0015', 'In Store'),
  ('O000166', '2005-12-13', '2005-12-13', '2005-12-19', 'C0011154', 'E00163', 'S0006', 'S0009', 'In Store'),
  ('O000167', '2005-12-14', '2005-12-14', '2005-12-24', 'C0011154', 'E00164', 'S0007', 'S0014', 'In Store'),
  ('O000168', '2005-12-15', '2005-12-15', '2005-12-24', 'C0011156', 'E00165', 'S0025', 'S0025', 'In Store'),
  ('O000169', '2005-12-16', '2005-12-16', '2005-12-24', 'C0011158', 'E00166', 'S0009', 'S0009', 'In Store'),
  ('O000170', '2005-12-17', '2005-12-20', '2005-12-19', 'C0011156', 'E00167', 'S0009', 'S0011', 'In Store'),
  ('O000171', '2005-12-18', '2005-12-18', '2005-12-20', 'C0011157', 'E00168', 'S0027', 'S0029', 'In Store'),
  ('O000172', '2005-12-19', '2005-12-19', '2006-01-11', 'C0011156', 'E00169', 'S0011', 'S0022', 'In Store'),
  ('O000173', '2005-12-20', '2005-12-20', '2006-01-11', 'C0011152', 'E00170', 'S0029', 'S0029', 'In Store'),
  ('O000174', '2005-12-21', '2005-12-22', '2006-01-01', 'C0011158', 'E00171', 'S0014', 'S0025', 'In Store'),
  ('O000175', '2005-12-22', '2005-12-22', '2006-01-10', 'C0011158', 'E00172', 'S0015', 'S0015', 'In Store'),
  ('O000176', '2005-12-23', '2005-12-24', '2005-12-24', 'C0011157', 'E00173', 'S0014', 'S0015', 'In Store'),
  ('O000177', '2005-12-24', '2005-12-24', '2005-12-26', 'C0011152', 'E00174', 'S0015', 'S0016', 'In Store'),
  ('O000178', '2005-12-25', '2005-12-26', '2005-12-26', 'C0011152', 'E00175', 'S0016', 'S0017', 'In Store'),
  ('O000179', '2005-12-26', '2005-12-26', '2005-12-28', 'C0011152', 'E00176', 'S0017', 'S0020', 'In Store'),
  ('O000180', '2005-12-27', '2005-12-28', '2006-01-10', 'C0011155', 'E00177', 'S0020', 'S0020', 'In Store'),
  ('O000181', '2005-12-28', '2005-12-28', '2006-01-03', 'C0011154', 'E00178', 'S0021', 'S0021', 'In Store'),
  ('O000182', '2005-12-29', '2005-12-29', '2006-01-15', 'C0011157', 'E00179', 'S0020', 'S0038', 'In Store'),
  ('O000183', '2005-12-30', '2005-12-30', '2006-01-06', 'C0011156', 'E00180', 'S0022', 'S0030', 'In Store'),
  ('O000184', '2005-12-31', '2005-12-31', '2006-01-16', 'C0011159', 'E00181', 'S0019', 'S0015', 'In Store'),
  ('O000185', '2006-01-01', '2006-01-01', '2006-01-05', 'C0011158', 'E00182', 'S0025', 'S0028', 'In Store'),
  ('O000186', '2006-01-02', '2006-01-03', '2006-01-06', 'C0011151', 'E00183', 'S0026', 'S0022', 'In Store'),
  ('O000187', '2006-01-03', '2006-01-03', '2006-01-12', 'C0011153', 'E00184', 'S0021', 'S0021', 'In Store'),
  ('O000188', '2006-01-04', '2006-01-05', '2006-01-09', 'C0011151', 'E00185', 'S0028', 'S0028', 'In Store'),
  ('O000189', '2006-01-05', '2006-01-06', '2006-01-07', 'C0011157', 'E00186', 'S0022', 'S0024', 'In Store'),
  ('O000190', '2006-01-06', '2006-01-06', '2006-01-11', 'C0011151', 'E00187', 'S0030', 'S0030', 'In Store'),
  ('O000191', '2006-01-07', '2006-01-07', '2006-01-10', 'C0011152', 'E00188', 'S0024', 'S0026', 'In Store'),
  ('O000192', '2006-01-08', '2006-01-09', '2006-01-13', 'C0011151', 'E00189', 'S0032', 'S0032', 'In Store'),
  ('O000193', '2006-01-09', '2006-01-10', '2006-01-12', 'C0011157', 'E00190', 'S0026', 'S0028', 'In Store'),
  ('O000194', '2006-01-10', '2006-01-13', '2006-01-12', 'C0011150', 'E00191', 'S0009', 'S0011', 'In Store'),
  ('O000195', '2006-01-11', '2006-01-12', '2006-02-12', 'C0011152', 'E00192', 'S0028', 'S0028', 'In Store'),
  ('O000196', '2006-01-12', '2006-01-12', '2006-01-13', 'C0011150', 'E00193', 'S0011', 'S0012', 'In Store'),
  ('O000197', '2006-01-13', '2006-01-13', '2006-01-21', 'C0011150', 'E00194', 'S0012', 'S0012', 'In Store'),
  ('O000198', '2006-01-14', '2006-01-15', '2006-01-22', 'C0011158', 'E00195', 'S0038', 'S0038', 'In Store'),
  ('O000199', '2006-01-15', '2006-01-15', '2006-01-24', 'C0011156', 'E00196', 'S0015', 'S0015', 'In Store'),
  ('O000200', '2006-01-16', '2006-01-17', '2006-01-21', 'C0011154', 'E00197', 'S0040', 'S0004', 'In Store'),
  ('O000201', '2006-01-17', '2006-01-17', '2006-02-03', 'C0011250', 'E00198', 'S0001', 'S0018', 'In Store'),
  ('O000202', '2006-01-18', '2006-01-19', '2006-01-23', 'C0011259', 'E00199', 'S0002', 'S0011', 'In Store'),
  ('O000203', '2006-01-19', '2006-01-19', '2006-02-11', 'C0011258', 'E00200', 'S0018', 'S0012', 'In Store'),
  ('O000204', '2006-01-20', '2006-01-21', '2006-01-29', 'C0011256', 'E00201', 'S0004', 'S0013', 'In Store'),
  ('O000205', '2006-01-21', '2006-01-21', '2006-01-27', 'C0011251', 'E00202', 'S0005', 'S0011', 'In Store'),
  ('O000206', '2006-01-22', '2006-01-25', '2006-02-11', 'C0011259', 'E00203', 'S0006', 'S0009', 'In Store'),
  ('O000207', '2006-01-23', '2006-01-23', '2006-02-12', 'C0011253', 'E00204', 'S0007', 'S0007', 'In Store'),
  ('O000208', '2006-01-24', '2006-01-24', '2006-02-24', 'C0011258', 'E00205', 'S0023', 'S0038', 'In Store'),
  ('O000209', '2006-01-25', '2006-01-25', '2006-02-02', 'C0011253', 'E00206', 'S0009', 'S0016', 'In Store'),
  ('O000210', '2006-01-26', '2006-01-27', '2006-02-11', 'C0011251', 'E00207', 'S0010', 'S0010', 'In Store'),
  ('O000211', '2006-01-27', '2006-01-27', '2006-02-11', 'C0011254', 'E00208', 'S0011', 'S0014', 'In Store'),
  ('O000212', '2006-01-28', '2006-01-28', '2006-02-24', 'C0011251', 'E00209', 'S0012', 'S0039', 'In Store'),
  ('O000213', '2006-01-29', '2006-01-29', '2006-02-14', 'C0011259', 'E00210', 'S0013', 'S0014', 'In Store'),
  ('O000214', '2006-01-30', '2006-01-30', '2006-02-18', 'C0011251', 'E00211', 'S0014', 'S0032', 'In Store'),
  ('O000215', '2006-01-31', '2006-01-31', '2006-02-20', 'C0011255', 'E00212', 'S0009', 'S0028', 'In Store'),
  ('O000216', '2006-02-01', '2006-02-02', '2006-02-18', 'C0011254', 'E00213', 'S0016', 'S0024', 'In Store'),
  ('O000217', '2006-02-02', '2006-02-02', '2006-02-10', 'C0011250', 'E00214', 'S0017', 'S0017', 'In Store'),
  ('O000218', '2006-02-03', '2006-02-03', '2006-02-16', 'C0011250', 'E00215', 'S0018', 'S0031', 'In Store'),
  ('O000219', '2006-02-04', '2006-02-04', '2006-02-25', 'C0011257', 'E00216', 'S0031', 'S0031', 'In Store'),
  ('O000220', '2006-02-05', '2006-02-06', '2006-02-10', 'C0011251', 'E00217', 'S0020', 'S0020', 'In Store'),
  ('O000221', '2006-02-06', '2006-02-06', '2006-02-27', 'C0011257', 'E00218', 'S0015', 'S0015', 'In Store'),
  ('O000222', '2006-02-07', '2006-02-08', '2006-02-12', 'C0011251', 'E00219', 'S0022', 'S0022', 'In Store'),
  ('O000223', '2006-02-08', '2006-02-08', '2006-02-17', 'C0011253', 'E00220', 'S0023', 'S0023', 'In Store'),
  ('O000224', '2006-02-09', '2006-02-12', '2006-03-10', 'C0011256', 'E00221', 'S0024', 'S0029', 'In Store'),
  ('O000225', '2006-02-10', '2006-02-10', '2006-02-18', 'C0011258', 'E00222', 'S0019', 'S0019', 'In Store'),
  ('O000226', '2006-02-11', '2006-02-11', '2006-03-12', 'C0011252', 'E00223', 'S0015', 'S0015', 'In Store'),
  ('O000227', '2006-02-12', '2006-02-12', '2006-02-21', 'C0011256', 'E00224', 'S0027', 'S0027', 'In Store'),
  ('O000228', '2006-02-13', '2006-02-14', '2006-02-22', 'C0011256', 'E00225', 'S0028', 'S0028', 'In Store'),
  ('O000229', '2006-02-14', '2006-02-14', '2006-02-19', 'C0011259', 'E00226', 'S0029', 'S0011', 'In Store'),
  ('O000230', '2006-02-15', '2006-02-18', '2006-03-16', 'C0011252', 'E00227', 'S0019', 'S0019', 'In Store'),
  ('O000231', '2006-02-16', '2006-02-16', '2006-02-21', 'C0011251', 'E00228', 'S0031', 'S0031', 'In Store'),
  ('O000232', '2006-02-17', '2006-02-18', '2006-02-25', 'C0011254', 'E00229', 'S0032', 'S0010', 'In Store'),
  ('O000233', '2006-02-18', '2006-02-18', '2006-02-20', 'C0011255', 'E00230', 'S0024', 'S0035', 'In Store'),
  ('O000234', '2006-02-19', '2006-02-20', '2006-02-22', 'C0011217', 'E00231', 'S0028', 'S0031', 'In Store'),
  ('O000235', '2006-02-20', '2006-02-20', '2006-02-28', 'C0011256', 'E00232', 'S0035', 'S0035', 'In Store'),
  ('O000236', '2006-02-21', '2006-02-24', '2006-03-12', 'C0011252', 'E00233', 'S0025', 'S0025', 'In Store'),
  ('O000237', '2006-02-22', '2006-02-22', '2006-03-13', 'C0011217', 'E00234', 'S0031', 'S0031', 'In Store'),
  ('O000238', '2006-02-23', '2006-02-24', '2006-02-28', 'C0011251', 'E00235', 'S0038', 'S0038', 'In Store'),
  ('O000239', '2006-02-24', '2006-02-24', '2006-03-13', 'C0011256', 'E00236', 'S0039', 'S0039', 'In Store'),
  ('O000240', '2006-02-25', '2006-02-28', '2006-03-15', 'C0011219', 'E00237', 'S0013', 'S0018', 'In Store'),
  ('O000241', '2006-02-26', '2006-02-27', '2006-03-12', 'C0011219', 'E00238', 'S0014', 'S0015', 'In Store'),
  ('O000243', '2006-02-28', '2006-02-28', '2006-03-08', 'C0011213', 'E00239', 'S0020', 'S0011', 'In Store'),
  ('O000244', '2006-03-01', '2006-03-02', '2006-04-05', 'C0011218', 'E00240', 'S0004', 'S0039', 'In Store'),
  ('O000245', '2006-03-02', '2006-03-02', '2006-03-20', 'C0011215', 'E00241', 'S0005', 'S0018', 'In Store'),
  ('O000246', '2006-03-03', '2006-03-04', '2006-03-28', 'C0011217', 'E00242', 'S0022', 'S0030', 'In Store'),
  ('O000247', '2006-03-04', '2006-03-04', '2006-03-12', 'C0011218', 'E00243', 'S0007', 'S0012', 'In Store'),
  ('O000248', '2006-03-05', '2006-03-05', '2006-03-20', 'C0011216', 'E00244', 'S0025', 'S0022', 'In Store'),
  ('O000249', '2006-03-06', '2006-03-06', '2006-03-24', 'C0011214', 'E00245', 'S0009', 'S0027', 'In Store'),
  ('O000250', '2006-03-07', '2006-03-07', '2006-03-12', 'C0011219', 'E00246', 'S0023', 'S0011', 'In Store'),
  ('O000251', '2006-03-08', '2006-03-08', '2006-03-14', 'C0011259', 'E00247', 'S0011', 'S0017', 'In Store'),
  ('O000252', '2006-03-09', '2006-03-12', '2006-03-13', 'C0011254', 'E00248', 'S0012', 'S0009', 'In Store'),
  ('O000253', '2006-03-10', '2006-03-10', '2006-04-11', 'C0011257', 'E00249', 'S0029', 'S0029', 'In Store'),
  ('O000254', '2006-03-11', '2006-03-14', '2006-03-18', 'C0011210', 'E00250', 'S0012', 'S0020', 'In Store'),
  ('O000255', '2006-03-12', '2006-03-12', '2006-03-16', 'C0011256', 'E00251', 'S0015', 'S0019', 'In Store'),
  ('O000256', '2006-03-13', '2006-03-13', '2006-03-19', 'C0011252', 'E00252', 'S0009', 'S0014', 'In Store'),
  ('O000257', '2006-03-14', '2006-03-14', '2006-03-23', 'C0011256', 'E00253', 'S0017', 'S0017', 'In Store'),
  ('O000258', '2006-03-15', '2006-03-15', '2006-03-24', 'C0011251', 'E00254', 'S0018', 'S0024', 'In Store'),
  ('O000259', '2006-03-16', '2006-03-16', '2006-03-24', 'C0011259', 'E00255', 'S0019', 'S0026', 'In Store'),
  ('O000260', '2006-03-17', '2006-03-18', '2006-04-10', 'C0011259', 'E00256', 'S0020', 'S0031', 'In Store'),
  ('O000261', '2006-03-18', '2006-03-19', '2006-04-10', 'C0011252', 'E00257', 'S0014', 'S0032', 'In Store'),
  ('O000262', '2006-03-19', '2006-03-20', '2006-04-03', 'C0011253', 'E00258', 'S0022', 'S0037', 'In Store'),
  ('O000263', '2006-03-20', '2006-03-20', '2006-03-23', 'C0011255', 'E00259', 'S0018', 'S0020', 'In Store'),
  ('O000264', '2006-03-21', '2006-03-24', '2006-03-26', 'C0011256', 'E00260', 'S0024', 'S0028', 'In Store'),
  ('O000265', '2006-03-22', '2006-03-23', '2006-03-26', 'C0011255', 'E00261', 'S0020', 'S0024', 'In Store'),
  ('O000266', '2006-03-23', '2006-03-24', '2006-04-11', 'C0011250', 'E00262', 'S0026', 'S0026', 'In Store'),
  ('O000267', '2006-03-24', '2006-03-24', '2006-03-29', 'C0011251', 'E00263', 'S0027', 'S0027', 'In Store'),
  ('O000268', '2006-03-25', '2006-03-26', '2006-04-01', 'C0011259', 'E00264', 'S0028', 'S0035', 'In Store'),
  ('O000269', '2006-03-26', '2006-03-26', '2006-04-11', 'C0011255', 'E00265', 'S0024', 'S0024', 'In Store'),
  ('O000270', '2006-03-27', '2006-03-27', '2006-03-28', 'C0011253', 'E00266', 'S0030', 'S0031', 'In Store'),
  ('O000271', '2006-03-28', '2006-03-28', '2006-04-12', 'C0011254', 'E00267', 'S0031', 'S0034', 'In Store'),
  ('O000272', '2006-03-29', '2006-03-29', '2006-04-05', 'C0011254', 'E00268', 'S0032', 'S0036', 'In Store'),
  ('O000273', '2006-03-30', '2006-03-30', '2006-04-11', 'C0011257', 'E00269', 'S0031', 'S0031', 'In Store'),
  ('O000274', '2006-03-31', '2006-03-31', '2006-04-16', 'C0011251', 'E00270', 'S0034', 'S0034', 'In Store'),
  ('O000275', '2006-04-01', '2006-04-01', '2006-04-10', 'C0011256', 'E00271', 'S0035', 'S0035', 'In Store'),
  ('O000276', '2006-04-02', '2006-04-05', '2006-04-07', 'C0011259', 'E00272', 'S0036', 'S0015', 'In Store'),
  ('O000277', '2006-04-03', '2006-04-03', '2006-04-08', 'C0011259', 'E00273', 'S0037', 'S0008', 'In Store'),
  ('O000278', '2006-04-04', '2006-04-04', '2006-04-15', 'C0011255', 'E00274', 'S0012', 'S0022', 'In Store'),
  ('O000279', '2006-04-05', '2006-04-05', '2006-04-14', 'C0011256', 'E00275', 'S0039', 'S0039', 'In Store'),
  ('O000280', '2006-04-06', '2006-04-06', '2006-04-13', 'C0011257', 'E00276', 'S0017', 'S0024', 'In Store'),
  ('O000281', '2006-04-07', '2006-04-07', '2006-05-13', 'C0011251', 'E00277', 'S0001', 'S0037', 'In Store'),
  ('O000282', '2006-04-08', '2006-04-09', '2006-04-17', 'C0011256', 'E00278', 'S0002', 'S0002', 'In Store'),
  ('O000283', '2006-04-09', '2006-04-09', '2006-04-11', 'C0011252', 'E00279', 'S0015', 'S0017', 'In Store'),
  ('O000284', '2006-04-10', '2006-04-11', '2006-04-19', 'C0011254', 'E00280', 'S0004', 'S0013', 'In Store'),
  ('O000285', '2006-04-11', '2006-04-11', '2006-05-12', 'C0011252', 'E00281', 'S0017', 'S0017', 'In Store'),
  ('O000286', '2006-04-12', '2006-04-12', '2006-04-19', 'C0011256', 'E00282', 'S0006', 'S0009', 'In Store'),
  ('O000287', '2006-04-13', '2006-04-13', '2006-04-16', 'C0011258', 'E00283', 'S0024', 'S0026', 'In Store'),
  ('O000288', '2006-04-14', '2006-04-15', '2006-04-19', 'C0011255', 'E00284', 'S0022', 'S0022', 'In Store'),
  ('O000289', '2006-04-15', '2006-04-16', '2006-04-23', 'C0011258', 'E00285', 'S0026', 'S0031', 'In Store'),
  ('O000290', '2006-04-16', '2006-04-19', '2006-04-24', 'C0011258', 'E00286', 'S0009', 'S0017', 'In Store'),
  ('O000291', '2006-04-17', '2006-04-17', '2006-05-07', 'C0011250', 'E00287', 'S0011', 'S0031', 'In Store'),
  ('O000292', '2006-04-18', '2006-04-18', '2006-05-15', 'C0011251', 'E00288', 'S0012', 'S0039', 'In Store'),
  ('O000293', '2006-04-19', '2006-04-19', '2006-04-23', 'C0011256', 'E00289', 'S0013', 'S0017', 'In Store'),
  ('O000294', '2006-04-20', '2006-04-23', '2006-05-11', 'C0011257', 'E00290', 'S0031', 'S0031', 'In Store'),
  ('O000295', '2006-04-21', '2006-04-21', '2006-04-26', 'C0011255', 'E00291', 'S0011', 'S0011', 'In Store'),
  ('O000296', '2006-04-22', '2006-04-23', '2006-04-25', 'C0011254', 'E00292', 'S0016', 'S0019', 'In Store'),
  ('O000297', '2006-04-23', '2006-04-23', '2006-04-28', 'C0011259', 'E00293', 'S0017', 'S0012', 'In Store'),
  ('O000298', '2006-04-24', '2006-04-24', '2006-05-15', 'C0011257', 'E00294', 'S0017', 'S0017', 'In Store'),
  ('O000299', '2006-04-25', '2006-04-25', '2006-05-10', 'C0011259', 'E00295', 'S0019', 'S0014', 'In Store'),
  ('O000300', '2006-04-26', '2006-04-27', '2006-05-15', 'C0011253', 'E00296', 'S0020', 'S0020', 'In Store'),
  ('O000301', '2006-04-27', '2006-04-27', '2006-05-08', 'C0011355', 'E00297', 'S0021', 'S0011', 'In Store'),
  ('O000302', '2006-04-28', '2006-04-29', '2006-05-13', 'C0011359', 'E00298', 'S0022', 'S0010', 'In Store'),
  ('O000303', '2006-04-29', '2006-04-29', '2006-05-14', 'C0011351', 'E00299', 'S0019', 'S0019', 'In Store'),
  ('O000304', '2006-04-30', '2006-04-30', '2006-05-12', 'C0011350', 'E00300', 'S0024', 'S0012', 'In Store'),
  ('O000305', '2006-05-01', '2006-05-01', '2006-05-10', 'C0011353', 'E00301', 'S0025', 'S0025', 'In Store'),
  ('O000306', '2006-05-02', '2006-05-02', '2006-05-14', 'C0011354', 'E00302', 'S0023', 'S0012', 'In Store'),
  ('O000307', '2006-05-03', '2006-05-03', '2006-05-08', 'C0011355', 'E00303', 'S0027', 'S0027', 'In Store'),
  ('O000308', '2006-05-04', '2006-05-04', '2006-05-25', 'C0011352', 'E00304', 'S0025', 'S0025', 'In Store'),
  ('O000309', '2006-05-05', '2006-05-05', '2006-05-14', 'C0011353', 'E00305', 'S0029', 'S0029', 'In Store'),
  ('O000310', '2006-05-06', '2006-05-06', '2006-05-11', 'C0011351', 'E00306', 'S0024', 'S0024', 'In Store'),
  ('O000311', '2006-05-07', '2006-05-07', '2006-05-11', 'C0011350', 'E00307', 'S0031', 'S0034', 'In Store'),
  ('O000312', '2006-05-08', '2006-05-08', '2006-05-09', 'C0011354', 'E00308', 'S0011', 'S0012', 'In Store'),
  ('O000313', '2006-05-09', '2006-05-09', '2006-05-17', 'C0011354', 'E00309', 'S0012', 'S0033', 'In Store'),
  ('O000314', '2006-05-10', '2006-05-11', '2006-05-15', 'C0011359', 'E00310', 'S0034', 'S0012', 'In Store'),
  ('O000315', '2006-05-11', '2006-05-11', '2006-05-19', 'C0011350', 'E00311', 'S0035', 'S0035', 'In Store'),
  ('O000316', '2006-05-12', '2006-05-12', '2006-05-17', 'C0011351', 'E00312', 'S0012', 'S0012', 'In Store'),
  ('O000317', '2006-05-13', '2006-05-13', '2006-05-22', 'C0011353', 'E00313', 'S0037', 'S0037', 'In Store'),
  ('O000318', '2006-05-14', '2006-05-14', '2006-05-27', 'C0011357', 'E00314', 'S0012', 'S0025', 'In Store'),
  ('O000319', '2006-05-15', '2006-05-15', '2006-05-23', 'C0011350', 'E00315', 'S0039', 'S0039', 'In Store'),
  ('O000320', '2006-05-16', '2006-05-17', '2006-05-21', 'C0011350', 'E00316', 'S0040', 'S0004', 'In Store'),
  ('O000321', '2006-05-17', '2006-05-17', '2006-05-25', 'C0011350', 'E00317', 'S0001', 'S0001', 'In Store'),
  ('O000322', '2006-05-18', '2006-05-18', '2006-06-24', 'C0011354', 'E00318', 'S0021', 'S0038', 'In Store'),
  ('O000323', '2006-05-19', '2006-05-19', '2006-06-18', 'C0011356', 'E00319', 'S0003', 'S0033', 'In Store'),
  ('O000324', '2006-05-20', '2006-05-21', '2006-06-20', 'C0011353', 'E00320', 'S0004', 'S0034', 'In Store'),
  ('O000325', '2006-05-21', '2006-05-21', '2006-05-29', 'C0011358', 'E00321', 'S0005', 'S0005', 'In Store'),
  ('O000326', '2006-05-22', '2006-05-25', '2006-06-13', 'C0011352', 'E00322', 'S0025', 'S0025', 'In Store'),
  ('O000327', '2006-05-23', '2006-05-23', '2006-06-03', 'C0011357', 'E00323', 'S0021', 'S0010', 'In Store'),
  ('O000328', '2006-05-24', '2006-05-25', '2006-06-11', 'C0011358', 'E00324', 'S0008', 'S0014', 'In Store'),
  ('O000329', '2006-05-25', '2006-05-25', '2006-06-02', 'C0011357', 'E00325', 'S0023', 'S0016', 'In Store'),
  ('O000330', '2006-05-26', '2006-05-26', '2006-06-17', 'C0011352', 'E00326', 'S0029', 'S0029', 'In Store'),
  ('O000331', '2006-05-27', '2006-05-27', '2006-05-29', 'C0011312', 'E00327', 'S0025', 'S0026', 'In Store'),
  ('O000332', '2006-05-28', '2006-05-29', '2006-06-19', 'C0011312', 'E00328', 'S0026', 'S0026', 'In Store'),
  ('O000333', '2006-05-29', '2006-05-29', '2006-06-12', 'C0011318', 'E00329', 'S0014', 'S0016', 'In Store'),
  ('O000334', '2006-05-30', '2006-05-30', '2006-06-18', 'C0011350', 'E00330', 'S0014', 'S0014', 'In Store'),
  ('O000335', '2006-05-31', '2006-05-31', '2006-06-12', 'C0011317', 'E00331', 'S0016', 'S0016', 'In Store'),
  ('O000336', '2006-06-01', '2006-06-02', '2006-06-04', 'C0011314', 'E00332', 'S0016', 'S0019', 'In Store'),
  ('O000337', '2006-06-02', '2006-06-03', '2006-06-03', 'C0011312', 'E00333', 'S0010', 'S0011', 'In Store'),
  ('O000338', '2006-06-03', '2006-06-03', '2006-06-22', 'C0011312', 'E00334', 'S0011', 'S0037', 'In Store'),
  ('O000339', '2006-06-04', '2006-06-04', '2006-06-20', 'C0011319', 'E00335', 'S0019', 'S0035', 'In Store'),
  ('O000340', '2006-06-05', '2006-06-05', '2006-06-16', 'C0011351', 'E00336', 'S0015', 'S0011', 'In Store'),
  ('O000342', '2006-06-07', '2006-06-08', '2006-07-06', 'C0011314', 'E00337', 'S0022', 'S0028', 'In Store'),
  ('O000343', '2006-06-08', '2006-06-08', '2006-06-13', 'C0011311', 'E00338', 'S0023', 'S0023', 'In Store'),
  ('O000344', '2006-06-09', '2006-06-12', '2006-06-18', 'C0011316', 'E00339', 'S0024', 'S0024', 'In Store'),
  ('O000345', '2006-06-10', '2006-06-10', '2006-06-28', 'C0011313', 'E00340', 'S0025', 'S0018', 'In Store'),
  ('O000346', '2006-06-11', '2006-06-12', '2006-06-16', 'C0011311', 'E00341', 'S0026', 'S0026', 'In Store'),
  ('O000347', '2006-06-12', '2006-06-13', '2006-07-13', 'C0011312', 'E00342', 'S0020', 'S0020', 'In Store'),
  ('O000348', '2006-06-13', '2006-06-14', '2006-07-14', 'C0011317', 'E00343', 'S0026', 'S0026', 'In Store'),
  ('O000349', '2006-06-14', '2006-06-14', '2006-07-15', 'C0011317', 'E00344', 'S0027', 'S0027', 'In Store'),
  ('O000350', '2006-06-15', '2006-06-18', '2006-06-23', 'C0011314', 'E00345', 'S0030', 'S0016', 'In Store'),
  ('O000351', '2006-06-16', '2006-06-16', '2006-06-17', 'C0011318', 'E00346', 'S0011', 'S0012', 'In Store'),
  ('O000352', '2006-06-17', '2006-06-17', '2006-06-24', 'C0011318', 'E00347', 'S0012', 'S0019', 'In Store'),
  ('O000353', '2006-06-18', '2006-06-18', '2006-06-26', 'C0011311', 'E00348', 'S0033', 'S0040', 'In Store'),
  ('O000354', '2006-06-19', '2006-06-20', '2006-06-24', 'C0011311', 'E00349', 'S0034', 'S0034', 'In Store'),
  ('O000355', '2006-06-20', '2006-06-20', '2006-06-24', 'C0011316', 'E00350', 'S0035', 'S0036', 'In Store'),
  ('O000356', '2006-06-21', '2006-06-24', '2006-06-29', 'C0011314', 'E00351', 'S0036', 'S0014', 'In Store'),
  ('O000357', '2006-06-22', '2006-06-22', '2006-06-27', 'C0011319', 'E00352', 'S0037', 'S0011', 'In Store'),
  ('O000358', '2006-06-23', '2006-06-24', '2006-07-12', 'C0011313', 'E00353', 'S0038', 'S0038', 'In Store'),
  ('O000359', '2006-06-24', '2006-06-24', '2006-07-15', 'C0011317', 'E00354', 'S0019', 'S0019', 'In Store'),
  ('O000360', '2006-06-25', '2006-06-26', '2006-07-13', 'C0011314', 'E00355', 'S0040', 'S0010', 'In Store'),
  ('O000361', '2006-06-26', '2006-06-26', '2006-07-06', 'C0011316', 'E00356', 'S0001', 'S0011', 'In Store'),
  ('O000362', '2006-06-27', '2006-06-28', '2006-07-08', 'C0011313', 'E00357', 'S0002', 'S0013', 'In Store'),
  ('O000363', '2006-06-28', '2006-06-28', '2006-07-04', 'C0011312', 'E00358', 'S0018', 'S0021', 'In Store'),
  ('O000364', '2006-06-29', '2006-06-29', '2006-08-10', 'C0011316', 'E00359', 'S0004', 'S0035', 'In Store'),
  ('O000365', '2006-06-30', '2006-06-30', '2006-07-04', 'C0011316', 'E00360', 'S0005', 'S0009', 'In Store'),
  ('O000366', '2006-07-01', '2006-07-04', '2006-07-06', 'C0011315', 'E00361', 'S0021', 'S0021', 'In Store'),
  ('O000367', '2006-07-02', '2006-07-02', '2006-07-13', 'C0011316', 'E00362', 'S0007', 'S0018', 'In Store'),
  ('O000368', '2006-07-03', '2006-07-04', '2006-07-10', 'C0011313', 'E00363', 'S0008', 'S0012', 'In Store'),
  ('O000369', '2006-07-04', '2006-07-04', '2006-07-10', 'C0011311', 'E00364', 'S0009', 'S0015', 'In Store'),
  ('O000370', '2006-07-05', '2006-07-06', '2006-07-26', 'C0011317', 'E00365', 'S0028', 'S0028', 'In Store'),
  ('O000371', '2006-07-06', '2006-07-06', '2006-07-12', 'C0011313', 'E00366', 'S0011', 'S0012', 'In Store'),
  ('O000372', '2006-07-07', '2006-07-10', '2006-07-12', 'C0011319', 'E00367', 'S0012', 'S0008', 'In Store'),
  ('O000373', '2006-07-08', '2006-07-08', '2006-07-12', 'C0011314', 'E00368', 'S0013', 'S0016', 'In Store'),
  ('O000374', '2006-07-09', '2006-07-10', '2006-07-17', 'C0011318', 'E00369', 'S0014', 'S0014', 'In Store'),
  ('O000375', '2006-07-10', '2006-07-10', '2006-07-14', 'C0011313', 'E00370', 'S0015', 'S0019', 'In Store'),
  ('O000376', '2006-07-11', '2006-07-12', '2006-07-18', 'C0011319', 'E00371', 'S0016', 'S0023', 'In Store'),
  ('O000377', '2006-07-12', '2006-07-12', '2006-07-17', 'C0011312', 'E00372', 'S0012', 'S0017', 'In Store'),
  ('O000378', '2006-07-13', '2006-07-13', '2006-07-16', 'C0011310', 'E00373', 'S0018', 'S0021', 'In Store'),
  ('O000379', '2006-07-14', '2006-07-14', '2006-07-22', 'C0011319', 'E00374', 'S0019', 'S0026', 'In Store'),
  ('O000380', '2006-07-15', '2006-07-16', '2006-07-24', 'C0011310', 'E00375', 'S0020', 'S0029', 'In Store'),
  ('O000381', '2006-07-16', '2006-07-16', '2006-07-21', 'C0011319', 'E00376', 'S0021', 'S0009', 'In Store'),
  ('O000382', '2006-07-17', '2006-07-17', '2006-07-21', 'C0011312', 'E00377', 'S0017', 'S0019', 'In Store'),
  ('O000383', '2006-07-18', '2006-07-18', '2006-07-28', 'C0011318', 'E00378', 'S0023', 'S0012', 'In Store'),
  ('O000384', '2006-07-19', '2006-07-22', '2006-07-21', 'C0011312', 'E00379', 'S0019', 'S0020', 'In Store'),
  ('O000385', '2006-07-20', '2006-07-21', '2006-07-23', 'C0011312', 'E00380', 'S0020', 'S0023', 'In Store'),
  ('O000386', '2006-07-21', '2006-07-22', '2006-08-14', 'C0011318', 'E00381', 'S0026', 'S0036', 'In Store'),
  ('O000387', '2006-07-22', '2006-07-22', '2006-08-10', 'C0011314', 'E00382', 'S0027', 'S0011', 'In Store'),
  ('O000388', '2006-07-23', '2006-07-23', '2006-07-26', 'C0011312', 'E00383', 'S0023', 'S0031', 'In Store'),
  ('O000389', '2006-07-24', '2006-07-24', '2006-08-13', 'C0011313', 'E00384', 'S0029', 'S0029', 'In Store'),
  ('O000390', '2006-07-25', '2006-07-28', '2006-07-28', 'C0011318', 'E00385', 'S0012', 'S0033', 'In Store'),
  ('O000391', '2006-07-26', '2006-07-26', '2006-08-15', 'C0011313', 'E00386', 'S0031', 'S0031', 'In Store'),
  ('O000392', '2006-07-27', '2006-07-27', '2006-08-16', 'C0011315', 'E00387', 'S0011', 'S0031', 'In Store'),
  ('O000393', '2006-07-28', '2006-07-28', '2006-08-16', 'C0011310', 'E00388', 'S0033', 'S0033', 'In Store'),
  ('O000395', '2006-07-30', '2006-07-30', '2006-08-18', 'C0011310', 'E00389', 'S0035', 'S0035', 'In Store'),
  ('O000396', '2006-07-31', '2006-07-31', '2006-08-19', 'C0011310', 'E00390', 'S0036', 'S0036', 'In Store'),
  ('O000397', '2006-08-01', '2006-08-01', '2006-08-02', 'C0011312', 'E00391', 'S0011', 'S0012', 'In Store'),
  ('O000398', '2006-08-02', '2006-08-02', '2006-08-23', 'C0011312', 'E00392', 'S0012', 'S0012', 'In Store'),
  ('O000399', '2006-08-03', '2006-08-03', '2006-08-08', 'C0011315', 'E00393', 'S0015', 'S0015', 'In Store'),
  ('O000400', '2006-08-04', '2006-08-05', '2006-08-13', 'C0011315', 'E00394', 'S0016', 'S0009', 'In Store'),
  ('O000401', '2006-08-05', '2006-08-05', '2006-08-13', 'C0011410', 'E00395', 'S0001', 'S0001', 'In Store'),
  ('O000402', '2006-08-06', '2006-08-07', '2006-08-21', 'C0011419', 'E00396', 'S0002', 'S0014', 'In Store'),
  ('O000403', '2006-08-07', '2006-08-07', '2006-08-12', 'C0011415', 'E00397', 'S0003', 'S0003', 'In Store'),
  ('O000404', '2006-08-08', '2006-08-09', '2006-08-19', 'C0011410', 'E00398', 'S0004', 'S0015', 'In Store'),
  ('O000405', '2006-08-09', '2006-08-09', '2006-09-08', 'C0011418', 'E00399', 'S0005', 'S0034', 'In Store'),
  ('O000406', '2006-08-10', '2006-08-10', '2006-08-17', 'C0011413', 'E00400', 'S0006', 'S0013', 'In Store'),
  ('O000407', '2006-08-11', '2006-08-11', '2006-08-19', 'C0011411', 'E00401', 'S0023', 'S0014', 'In Store'),
  ('O000408', '2006-08-12', '2006-08-13', '2006-08-23', 'C0011416', 'E00402', 'S0008', 'S0019', 'In Store'),
  ('O000409', '2006-08-13', '2006-08-13', '2006-08-22', 'C0011416', 'E00403', 'S0009', 'S0009', 'In Store'),
  ('O000410', '2006-08-14', '2006-08-14', '2006-09-15', 'C0011412', 'E00404', 'S0029', 'S0029', 'In Store'),
  ('O000411', '2006-08-15', '2006-08-15', '2006-08-21', 'C0011419', 'E00405', 'S0011', 'S0017', 'In Store'),
  ('O000412', '2006-08-16', '2006-08-16', '2006-09-17', 'C0011412', 'E00406', 'S0031', 'S0031', 'In Store'),
  ('O000413', '2006-08-17', '2006-08-17', '2006-08-26', 'C0011416', 'E00407', 'S0013', 'S0013', 'In Store'),
  ('O000414', '2006-08-18', '2006-08-19', '2006-09-09', 'C0011416', 'E00408', 'S0014', 'S0036', 'In Store'),
  ('O000415', '2006-08-19', '2006-08-19', '2006-09-06', 'C0011419', 'E00409', 'S0015', 'S0033', 'In Store'),
  ('O000416', '2006-08-20', '2006-08-21', '2006-08-25', 'C0011411', 'E00410', 'S0014', 'S0014', 'In Store'),
  ('O000417', '2006-08-21', '2006-08-21', '2006-09-06', 'C0011413', 'E00411', 'S0017', 'S0032', 'In Store'),
  ('O000418', '2006-08-22', '2006-08-22', '2006-09-10', 'C0011414', 'E00412', 'S0019', 'S0018', 'In Store'),
  ('O000419', '2006-08-23', '2006-08-23', '2006-08-28', 'C0011419', 'E00413', 'S0019', 'S0013', 'In Store'),
  ('O000420', '2006-08-24', '2006-08-25', '2006-09-04', 'C0011418', 'E00414', 'S0020', 'S0011', 'In Store'),
  ('O000421', '2006-08-25', '2006-08-25', '2006-09-14', 'C0011416', 'E00415', 'S0021', 'S0021', 'In Store'),
  ('O000422', '2006-08-26', '2006-08-27', '2006-09-11', 'C0011411', 'E00416', 'S0020', 'S0020', 'In Store'),
  ('O000423', '2006-08-27', '2006-08-27', '2006-09-08', 'C0011418', 'E00417', 'S0023', 'S0012', 'In Store'),
  ('O000424', '2006-08-28', '2006-08-28', '2006-09-26', 'C0011415', 'E00418', 'S0024', 'S0014', 'In Store'),
  ('O000425', '2006-08-29', '2006-08-29', '2006-09-25', 'C0011412', 'E00419', 'S0026', 'S0026', 'In Store'),
  ('O000426', '2006-08-30', '2006-08-30', '2006-09-15', 'C0011411', 'E00420', 'S0024', 'S0024', 'In Store'),
  ('O000427', '2006-08-31', '2006-08-31', '2006-09-16', 'C0011411', 'E00421', 'S0025', 'S0025', 'In Store'),
  ('O000428', '2006-09-01', '2006-09-02', '2006-09-10', 'C0011413', 'E00422', 'S0028', 'S0028', 'In Store'),
  ('O000429', '2006-09-02', '2006-09-02', '2006-09-07', 'C0011411', 'E00423', 'S0024', 'S0024', 'In Store'),
  ('O000430', '2006-09-03', '2006-09-03', '2006-09-12', 'C0011416', 'E00424', 'S0030', 'S0030', 'In Store'),
  ('O000431', '2006-09-04', '2006-09-04', '2006-09-12', 'C0011414', 'E00425', 'S0011', 'S0019', 'In Store'),
  ('O000432', '2006-09-05', '2006-09-06', '2006-09-12', 'C0011415', 'E00426', 'S0032', 'S0038', 'In Store'),
  ('O000433', '2006-09-06', '2006-09-06', '2006-09-14', 'C0011418', 'E00427', 'S0033', 'S0033', 'In Store'),
  ('O000434', '2006-09-07', '2006-09-08', '2006-09-10', 'C0011410', 'E00428', 'S0034', 'S0037', 'In Store'),
  ('O000435', '2006-09-08', '2006-09-08', '2006-09-13', 'C0011411', 'E00429', 'S0012', 'S0012', 'In Store'),
  ('O000436', '2006-09-09', '2006-09-09', '2006-09-17', 'C0011418', 'E00430', 'S0036', 'S0036', 'In Store'),
  ('O000437', '2006-09-10', '2006-09-10', '2006-09-15', 'C0011415', 'E00431', 'S0037', 'S0037', 'In Store'),
  ('O000438', '2006-09-11', '2006-09-12', '2006-09-20', 'C0011416', 'E00432', 'S0038', 'S0038', 'In Store'),
  ('O000439', '2006-09-12', '2006-09-12', '2006-09-20', 'C0011414', 'E00433', 'S0019', 'S0039', 'In Store'),
  ('O000440', '2006-09-13', '2006-09-14', '2006-09-14', 'C0011418', 'E00434', 'S0040', 'S0001', 'In Store'),
  ('O000441', '2006-09-14', '2006-09-14', '2006-09-26', 'C0011418', 'E00435', 'S0001', 'S0013', 'In Store'),
  ('O000442', '2006-09-15', '2006-09-16', '2006-09-28', 'C0011415', 'E00436', 'S0002', 'S0014', 'In Store'),
  ('O000443', '2006-09-16', '2006-09-16', '2006-09-28', 'C0011416', 'E00437', 'S0003', 'S0015', 'In Store'),
  ('O000444', '2006-09-17', '2006-09-18', '2006-10-06', 'C0011410', 'E00438', 'S0004', 'S0022', 'In Store'),
  ('O000445', '2006-09-18', '2006-09-18', '2006-10-10', 'C0011412', 'E00439', 'S0025', 'S0027', 'In Store'),
  ('O000446', '2006-09-19', '2006-09-22', '2006-09-28', 'C0011416', 'E00440', 'S0006', 'S0006', 'In Store'),
  ('O000447', '2006-09-20', '2006-09-20', '2006-10-02', 'C0011419', 'E00441', 'S0007', 'S0019', 'In Store'),
  ('O000448', '2006-09-21', '2006-09-22', '2006-10-12', 'C0011412', 'E00442', 'S0028', 'S0010', 'In Store'),
  ('O000449', '2006-09-22', '2006-09-22', '2006-10-10', 'C0011415', 'E00443', 'S0009', 'S0017', 'In Store'),
  ('O000450', '2006-09-23', '2006-09-26', '2006-10-11', 'C0011414', 'E00444', 'S0012', 'S0010', 'In Store'),
  ('O000451', '2006-09-24', '2006-09-25', '2006-10-15', 'C0011417', 'E00445', 'S0026', 'S0026', 'In Store'),
  ('O000452', '2006-09-25', '2006-09-26', '2006-10-16', 'C0011412', 'E00446', 'S0014', 'S0014', 'In Store'),
  ('O000453', '2006-09-26', '2006-09-26', '2006-10-12', 'C0011419', 'E00447', 'S0013', 'S0029', 'In Store'),
  ('O000454', '2006-09-27', '2006-09-28', '2006-10-10', 'C0011419', 'E00448', 'S0014', 'S0024', 'In Store'),
  ('O000455', '2006-09-28', '2006-09-28', '2006-10-12', 'C0011415', 'E00449', 'S0015', 'S0013', 'In Store'),
  ('O000456', '2006-09-29', '2006-09-29', '2006-10-03', 'C0011417', 'E00450', 'S0013', 'S0017', 'In Store'),
  ('O000457', '2006-09-30', '2006-09-30', '2006-10-08', 'C0011416', 'E00451', 'S0017', 'S0025', 'In Store'),
  ('O000458', '2006-10-01', '2006-10-01', '2006-10-10', 'C0011413', 'E00452', 'S0018', 'S0018', 'In Store'),
  ('O000459', '2006-10-02', '2006-10-02', '2006-10-18', 'C0011419', 'E00453', 'S0019', 'S0035', 'In Store'),
  ('O000460', '2006-10-03', '2006-10-03', '2006-10-04', 'C0011411', 'E00454', 'S0017', 'S0018', 'In Store'),
  ('O000461', '2006-10-04', '2006-10-04', '2006-10-07', 'C0011411', 'E00455', 'S0018', 'S0020', 'In Store'),
  ('O000462', '2006-10-05', '2006-10-06', '2006-10-10', 'C0011416', 'E00456', 'S0022', 'S0026', 'In Store'),
  ('O000463', '2006-10-06', '2006-10-07', '2006-10-16', 'C0011411', 'E00457', 'S0020', 'S0032', 'In Store'),
  ('O000464', '2006-10-07', '2006-10-10', '2006-10-16', 'C0011419', 'E00458', 'S0024', 'S0030', 'In Store'),
  ('O000465', '2006-10-08', '2006-10-08', '2006-10-14', 'C0011412', 'E00459', 'S0025', 'S0031', 'In Store'),
  ('O000466', '2006-10-09', '2006-10-10', '2006-10-14', 'C0011415', 'E00460', 'S0026', 'S0026', 'In Store'),
  ('O000467', '2006-10-10', '2006-10-10', '2006-10-16', 'C0011415', 'E00461', 'S0027', 'S0033', 'In Store'),
  ('O000468', '2006-10-11', '2006-10-12', '2006-10-19', 'C0011414', 'E00462', 'S0010', 'S0028', 'In Store'),
  ('O000469', '2006-10-12', '2006-10-12', '2006-10-24', 'C0011416', 'E00463', 'S0029', 'S0040', 'In Store'),
  ('O000470', '2006-10-13', '2006-10-16', '2006-10-18', 'C0011413', 'E00464', 'S0030', 'S0016', 'In Store'),
  ('O000471', '2006-10-14', '2006-10-14', '2006-10-19', 'C0011415', 'E00465', 'S0031', 'S0031', 'In Store'),
  ('O000472', '2006-10-15', '2006-10-16', '2006-10-23', 'C0011410', 'E00466', 'S0032', 'S0032', 'In Store'),
  ('O000473', '2006-10-16', '2006-10-16', '2006-10-20', 'C0011413', 'E00467', 'S0033', 'S0037', 'In Store'),
  ('O000474', '2006-10-17', '2006-10-18', '2006-10-25', 'C0011414', 'E00468', 'S0016', 'S0034', 'In Store'),
  ('O000475', '2006-10-18', '2006-10-18', '2006-10-22', 'C0011413', 'E00469', 'S0035', 'S0036', 'In Store'),
  ('O000476', '2006-10-19', '2006-10-22', '2006-10-27', 'C0011418', 'E00470', 'S0036', 'S0036', 'In Store'),
  ('O000477', '2006-10-20', '2006-10-20', '2006-10-25', 'C0011415', 'E00471', 'S0037', 'S0037', 'In Store'),
  ('O000478', '2006-10-21', '2006-10-21', '2006-10-22', 'C0011411', 'E00472', 'S0017', 'S0018', 'In Store'),
  ('O000479', '2006-10-22', '2006-10-22', '2006-10-28', 'C0011411', 'E00473', 'S0018', 'S0024', 'In Store'),
  ('O000480', '2006-10-23', '2006-10-24', '2006-11-11', 'C0011410', 'E00474', 'S0040', 'S0040', 'In Store');
  INSERT INTO `crcapp_order` (`orderID`, `orderDate`, `pickupDate`, `returnDate`, `customerID_id`, `employeeID_id`, `pickupStoreID_id`, `returnStoreID_id`, `orderType`) VALUES
  ('O000481', '2006-10-24', '2006-10-24', '2006-10-26', 'C0011410', 'E00475', 'S0001', 'S0003', 'In Store'),
  ('O000482', '2006-10-25', '2006-10-28', '2006-10-27', 'C0011417', 'E00476', 'S0019', 'S0021', 'In Store'),
  ('O000483', '2006-10-26', '2006-10-26', '2006-11-10', 'C0011410', 'E00477', 'S0003', 'S0007', 'In Store'),
  ('O000484', '2006-10-27', '2006-10-27', '2006-11-08', 'C0011417', 'E00478', 'S0021', 'S0016', 'In Store'),
  ('O000485', '2006-10-28', '2006-10-28', '2006-11-12', 'C0011411', 'E00479', 'S0024', 'S0025', 'In Store'),
  ('O000486', '2006-10-29', '2006-10-29', '2006-11-03', 'C0011411', 'E00480', 'S0025', 'S0030', 'In Store'),
  ('O000487', '2006-10-30', '2006-10-30', '2006-11-12', 'C0011418', 'E00481', 'S0007', 'S0008', 'In Store'),
  ('O000488', '2006-10-31', '2006-10-31', '2006-11-03', 'C0011415', 'E00482', 'S0008', 'S0010', 'In Store'),
  ('O000489', '2006-11-01', '2006-11-01', '2006-11-06', 'C0011411', 'E00483', 'S0025', 'S0025', 'In Store'),
  ('O000490', '2006-11-02', '2006-11-03', '2006-11-05', 'C0011418', 'E00484', 'S0010', 'S0013', 'In Store'),
  ('O000491', '2006-11-03', '2006-11-03', '2006-11-07', 'C0011412', 'E00485', 'S0030', 'S0031', 'In Store'),
  ('O000492', '2006-11-04', '2006-11-07', '2006-11-25', 'C0011412', 'E00486', 'S0031', 'S0031', 'In Store'),
  ('O000493', '2006-11-05', '2006-11-05', '2006-11-09', 'C0011415', 'E00487', 'S0013', 'S0016', 'In Store'),
  ('O000494', '2006-11-06', '2006-11-09', '2006-11-11', 'C0011459', 'E00488', 'S0012', 'S0018', 'In Store'),
  ('O000495', '2006-11-07', '2006-11-08', '2006-11-28', 'C0011412', 'E00489', 'S0016', 'S0016', 'In Store'),
  ('O000496', '2006-11-08', '2006-11-09', '2006-11-29', 'C0011413', 'E00490', 'S0016', 'S0036', 'In Store'),
  ('O000497', '2006-11-09', '2006-11-09', '2006-12-10', 'C0011417', 'E00491', 'S0013', 'S0013', 'In Store'),
  ('O000498', '2006-11-10', '2006-11-10', '2006-11-18', 'C0011414', 'E00492', 'S0019', 'S0018', 'In Store'),
  ('O000499', '2006-11-11', '2006-11-12', '2006-11-19', 'C0011414', 'E00493', 'S0020', 'S0019', 'In Store'),
  ('O000500', '2006-11-12', '2006-11-15', '2006-12-10', 'C0011412', 'E00494', 'S0021', 'S0018', 'In Store'),
  ('O000501', '2006-11-13', '2006-11-13', '2006-11-18', 'C0011559', 'E00495', 'S0021', 'S0014', 'In Store'),
  ('O000502', '2006-11-14', '2006-11-14', '2006-12-15', 'C0011552', 'E00496', 'S0018', 'S0018', 'In Store'),
  ('O000503', '2006-11-15', '2006-11-15', '2006-11-20', 'C0011559', 'E00497', 'S0023', 'S0008', 'In Store'),
  ('O000504', '2006-11-16', '2006-11-19', '2006-11-24', 'C0011554', 'E00498', 'S0024', 'S0013', 'In Store'),
  ('O000505', '2006-11-17', '2006-11-18', '2006-12-18', 'C0011557', 'E00499', 'S0026', 'S0026', 'In Store'),
  ('O000506', '2006-11-18', '2006-11-19', '2006-11-27', 'C0011556', 'E00500', 'S0026', 'S0026', 'In Store'),
  ('O000507', '2006-11-19', '2006-11-19', '2006-11-27', 'C0011554', 'E00501', 'S0027', 'S0016', 'In Store'),
  ('O000508', '2006-11-20', '2006-11-21', '2006-11-28', 'C0011550', 'E00502', 'S0028', 'S0028', 'In Store'),
  ('O000509', '2006-11-21', '2006-11-21', '2006-11-29', 'C0011550', 'E00503', 'S0029', 'S0029', 'In Store'),
  ('O000510', '2006-11-22', '2006-11-25', '2006-12-10', 'C0011554', 'E00504', 'S0030', 'S0011', 'In Store'),
  ('O000511', '2006-11-23', '2006-11-24', '2006-11-26', 'C0011557', 'E00505', 'S0014', 'S0015', 'In Store'),
  ('O000512', '2006-11-24', '2006-11-27', '2006-11-26', 'C0011557', 'E00506', 'S0015', 'S0016', 'In Store'),
  ('O000513', '2006-11-25', '2006-11-26', '2006-11-26', 'C0011557', 'E00507', 'S0016', 'S0017', 'In Store'),
  ('O000514', '2006-11-26', '2006-11-26', '2006-11-27', 'C0011558', 'E00508', 'S0017', 'S0018', 'In Store'),
  ('O000515', '2006-11-27', '2006-11-27', '2006-12-15', 'C0011558', 'E00509', 'S0018', 'S0018', 'In Store'),
  ('O000516', '2006-11-28', '2006-11-28', '2006-11-29', 'C0011556', 'E00510', 'S0036', 'S0037', 'In Store'),
  ('O000517', '2006-11-29', '2006-11-29', '2006-12-01', 'C0011550', 'E00511', 'S0037', 'S0039', 'In Store'),
  ('O000518', '2006-11-30', '2006-11-30', '2006-12-15', 'C0011535', 'E00512', 'S0018', 'S0018', 'In Store'),
  ('O000519', '2006-12-01', '2006-12-01', '2006-12-09', 'C0011550', 'E00513', 'S0039', 'S0039', 'In Store'),
  ('O000520', '2006-12-02', '2006-12-03', '2006-12-09', 'C0011551', 'E00514', 'S0040', 'S0007', 'In Store'),
  ('O000521', '2006-12-03', '2006-12-03', '2007-01-08', 'C0011551', 'E00515', 'S0001', 'S0018', 'In Store'),
  ('O000522', '2006-12-04', '2006-12-05', '2006-12-13', 'C0011535', 'E00516', 'S0020', 'S0011', 'In Store'),
  ('O000523', '2006-12-05', '2006-12-05', '2006-12-19', 'C0011558', 'E00517', 'S0024', 'S0016', 'In Store'),
  ('O000524', '2006-12-06', '2006-12-07', '2006-12-15', 'C0011556', 'E00518', 'S0004', 'S0013', 'In Store'),
  ('O000525', '2006-12-07', '2006-12-07', '2006-12-17', 'C0011553', 'E00519', 'S0005', 'S0015', 'In Store'),
  ('O000526', '2006-12-08', '2006-12-08', '2007-01-12', 'C0011559', 'E00520', 'S0006', 'S0040', 'In Store'),
  ('O000527', '2006-12-09', '2006-12-09', '2007-01-02', 'C0011554', 'E00521', 'S0007', 'S0031', 'In Store'),
  ('O000528', '2006-12-10', '2006-12-11', '2006-12-20', 'C0011553', 'E00522', 'S0008', 'S0018', 'In Store'),
  ('O000529', '2006-12-11', '2006-12-11', '2006-12-21', 'C0011554', 'E00523', 'S0009', 'S0019', 'In Store'),
  ('O000530', '2006-12-12', '2006-12-13', '2006-12-21', 'C0011553', 'E00524', 'S0010', 'S0010', 'In Store'),
  ('O000531', '2006-12-13', '2006-12-13', '2006-12-22', 'C0011553', 'E00525', 'S0011', 'S0011', 'In Store'),
  ('O000532', '2006-12-14', '2006-12-14', '2006-12-16', 'C0011558', 'E00526', 'S0015', 'S0017', 'In Store'),
  ('O000533', '2006-12-15', '2006-12-15', '2006-12-19', 'C0011553', 'E00527', 'S0013', 'S0017', 'In Store'),
  ('O000534', '2006-12-16', '2006-12-16', '2007-01-17', 'C0011557', 'E00528', 'S0017', 'S0017', 'In Store'),
  ('O000535', '2006-12-17', '2006-12-17', '2006-12-25', 'C0011550', 'E00529', 'S0015', 'S0015', 'In Store'),
  ('O000536', '2006-12-18', '2006-12-19', '2007-01-06', 'C0011551', 'E00530', 'S0016', 'S0034', 'In Store'),
  ('O000537', '2006-12-19', '2006-12-19', '2007-01-06', 'C0011551', 'E00531', 'S0017', 'S0035', 'In Store'),
  ('O000538', '2006-12-20', '2006-12-20', '2007-01-10', 'C0011550', 'E00532', 'S0018', 'S0039', 'In Store'),
  ('O000539', '2006-12-21', '2006-12-21', '2006-12-29', 'C0011550', 'E00533', 'S0019', 'S0019', 'In Store'),
  ('O000540', '2006-12-22', '2006-12-23', '2007-01-08', 'C0011535', 'E00534', 'S0020', 'S0016', 'In Store'),
  ('O000541', '2006-12-23', '2006-12-23', '2006-12-28', 'C0011551', 'E00535', 'S0021', 'S0021', 'In Store'),
  ('O000542', '2006-12-24', '2006-12-25', '2007-01-13', 'C0011513', 'E00536', 'S0026', 'S0026', 'In Store'),
  ('O000543', '2006-12-25', '2006-12-25', '2007-01-05', 'C0011514', 'E00537', 'S0023', 'S0009', 'In Store'),
  ('O000544', '2006-12-26', '2006-12-26', '2007-01-14', 'C0011518', 'E00538', 'S0024', 'S0024', 'In Store'),
  ('O000545', '2006-12-27', '2006-12-27', '2007-01-12', 'C0011519', 'E00539', 'S0025', 'S0011', 'In Store'),
  ('O000546', '2006-12-28', '2006-12-28', '2007-01-19', 'C0011517', 'E00540', 'S0029', 'S0011', 'In Store'),
  ('O000547', '2006-12-29', '2006-12-29', '2007-01-14', 'C0011519', 'E00541', 'S0009', 'S0013', 'In Store'),
  ('O000548', '2006-12-30', '2006-12-30', '2007-01-15', 'C0011551', 'E00542', 'S0028', 'S0028', 'In Store'),
  ('O000549', '2006-12-31', '2006-12-31', '2007-01-19', 'C0011550', 'E00543', 'S0029', 'S0029', 'In Store'),
  ('O000550', '2007-01-01', '2007-01-01', '2007-01-09', 'C0011550', 'E00544', 'S0030', 'S0030', 'In Store'),
  ('O000551', '2007-01-02', '2007-01-02', '2007-01-07', 'C0011515', 'E00545', 'S0031', 'S0031', 'In Store'),
  ('O000552', '2007-01-03', '2007-01-06', '2007-01-05', 'C0011519', 'E00546', 'S0009', 'S0010', 'In Store'),
  ('O000553', '2007-01-04', '2007-01-05', '2007-01-18', 'C0011519', 'E00547', 'S0010', 'S0021', 'In Store'),
  ('O000554', '2007-01-05', '2007-01-06', '2007-01-13', 'C0011518', 'E00548', 'S0034', 'S0034', 'In Store'),
  ('O000556', '2007-01-07', '2007-01-08', '2007-01-18', 'C0011512', 'E00549', 'S0016', 'S0026', 'In Store'),
  ('O000557', '2007-01-08', '2007-01-08', '2007-01-17', 'C0011513', 'E00550', 'S0018', 'S0018', 'In Store'),
  ('O000558', '2007-01-09', '2007-01-10', '2007-01-14', 'C0011511', 'E00551', 'S0038', 'S0038', 'In Store'),
  ('O000559', '2007-01-10', '2007-01-10', '2007-01-18', 'C0011518', 'E00552', 'S0039', 'S0039', 'In Store'),
  ('O000560', '2007-01-11', '2007-01-12', '2007-01-16', 'C0011511', 'E00553', 'S0040', 'S0040', 'In Store'),
  ('O000561', '2007-01-12', '2007-01-12', '2007-02-03', 'C0011515', 'E00554', 'S0001', 'S0022', 'In Store'),
  ('O000562', '2007-01-13', '2007-01-13', '2007-01-22', 'C0011516', 'E00555', 'S0023', 'S0023', 'In Store'),
  ('O000563', '2007-01-14', '2007-01-14', '2007-01-24', 'C0011511', 'E00556', 'S0003', 'S0013', 'In Store'),
  ('O000564', '2007-01-15', '2007-01-18', '2007-01-20', 'C0011519', 'E00557', 'S0021', 'S0011', 'In Store'),
  ('O000565', '2007-01-16', '2007-01-16', '2007-01-23', 'C0011511', 'E00558', 'S0005', 'S0010', 'In Store'),
  ('O000566', '2007-01-17', '2007-01-18', '2007-01-18', 'C0011517', 'E00559', 'S0026', 'S0027', 'In Store'),
  ('O000567', '2007-01-18', '2007-01-18', '2007-01-20', 'C0011512', 'E00560', 'S0027', 'S0029', 'In Store'),
  ('O000568', '2007-01-19', '2007-01-19', '2007-01-28', 'C0011516', 'E00561', 'S0011', 'S0011', 'In Store'),
  ('O000569', '2007-01-20', '2007-01-20', '2007-02-10', 'C0011512', 'E00562', 'S0029', 'S0018', 'In Store'),
  ('O000570', '2007-01-21', '2007-01-22', '2007-02-13', 'C0011515', 'E00563', 'S0010', 'S0012', 'In Store'),
  ('O000571', '2007-01-22', '2007-01-23', '2007-01-26', 'C0011519', 'E00564', 'S0010', 'S0012', 'In Store'),
  ('O000572', '2007-01-23', '2007-01-26', '2007-01-27', 'C0011514', 'E00565', 'S0012', 'S0014', 'In Store'),
  ('O000573', '2007-01-24', '2007-01-24', '2007-02-12', 'C0011515', 'E00566', 'S0013', 'S0020', 'In Store'),
  ('O000574', '2007-01-25', '2007-01-26', '2007-01-28', 'C0011514', 'E00567', 'S0014', 'S0017', 'In Store'),
  ('O000575', '2007-01-26', '2007-01-27', '2007-02-02', 'C0011519', 'E00568', 'S0014', 'S0020', 'In Store'),
  ('O000576', '2007-01-27', '2007-01-27', '2007-02-18', 'C0011512', 'E00569', 'S0018', 'S0018', 'In Store'),
  ('O000577', '2007-01-28', '2007-01-28', '2007-02-19', 'C0011515', 'E00570', 'S0017', 'S0038', 'In Store'),
  ('O000578', '2007-01-29', '2007-01-29', '2007-02-05', 'C0011515', 'E00571', 'S0018', 'S0025', 'In Store'),
  ('O000579', '2007-01-30', '2007-01-30', '2007-02-09', 'C0011518', 'E00572', 'S0019', 'S0010', 'In Store'),
  ('O000580', '2007-01-31', '2007-01-31', '2007-02-07', 'C0011514', 'E00573', 'S0020', 'S0009', 'In Store'),
  ('O000581', '2007-02-01', '2007-02-02', '2007-02-04', 'C0011517', 'E00574', 'S0020', 'S0022', 'In Store'),
  ('O000582', '2007-02-02', '2007-02-03', '2007-02-07', 'C0011511', 'E00575', 'S0022', 'S0022', 'In Store'),
  ('O000583', '2007-02-03', '2007-02-04', '2007-02-04', 'C0011517', 'E00576', 'S0022', 'S0023', 'In Store'),
  ('O000584', '2007-02-04', '2007-02-04', '2007-02-06', 'C0011510', 'E00577', 'S0023', 'S0025', 'In Store'),
  ('O000585', '2007-02-05', '2007-02-05', '2007-02-14', 'C0011513', 'E00578', 'S0025', 'S0025', 'In Store'),
  ('O000586', '2007-02-06', '2007-02-06', '2007-02-10', 'C0011512', 'E00579', 'S0025', 'S0028', 'In Store'),
  ('O000587', '2007-02-07', '2007-02-07', '2007-02-11', 'C0011513', 'E00580', 'S0009', 'S0031', 'In Store'),
  ('O000588', '2007-02-08', '2007-02-09', '2007-02-17', 'C0011516', 'E00581', 'S0010', 'S0010', 'In Store'),
  ('O000589', '2007-02-09', '2007-02-10', '2007-02-12', 'C0011512', 'E00582', 'S0028', 'S0031', 'In Store'),
  ('O000590', '2007-02-10', '2007-02-13', '2007-02-19', 'C0011513', 'E00583', 'S0012', 'S0012', 'In Store'),
  ('O000591', '2007-02-11', '2007-02-11', '2007-02-15', 'C0011514', 'E00584', 'S0031', 'S0034', 'In Store'),
  ('O000592', '2007-02-12', '2007-02-12', '2007-02-13', 'C0011517', 'E00585', 'S0031', 'S0033', 'In Store'),
  ('O000593', '2007-02-13', '2007-02-13', '2007-02-21', 'C0011518', 'E00586', 'S0033', 'S0033', 'In Store'),
  ('O000594', '2007-02-14', '2007-02-15', '2007-02-19', 'C0011515', 'E00587', 'S0034', 'S0034', 'In Store'),
  ('O000595', '2007-02-15', '2007-02-15', '2007-02-20', 'C0011511', 'E00588', 'S0035', 'S0035', 'In Store'),
  ('O000596', '2007-02-16', '2007-02-16', '2007-03-17', 'C0011512', 'E00589', 'S0017', 'S0017', 'In Store'),
  ('O000597', '2007-02-17', '2007-02-17', '2007-02-25', 'C0011514', 'E00590', 'S0037', 'S0037', 'In Store'),
  ('O000598', '2007-02-18', '2007-02-19', '2007-02-23', 'C0011511', 'E00591', 'S0038', 'S0038', 'In Store'),
  ('O000599', '2007-02-19', '2007-02-19', '2007-02-28', 'C0011513', 'E00592', 'S0021', 'S0021', 'In Store'),
  ('O000600', '2007-02-20', '2007-02-21', '2007-02-28', 'C0011514', 'E00593', 'S0040', 'S0040', 'In Store'),
  ('O000601', '2007-01-06', '2007-01-06', '2007-01-10', 'C0011518', 'E00594', 'S0035', 'S0038', 'In Store');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_orderfor`
  --
  
  DROP TABLE IF EXISTS `crcapp_orderfor`;
  CREATE TABLE IF NOT EXISTS `crcapp_orderfor` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `vehicleID_id` varchar(10) DEFAULT NULL,
    `orderID_id` varchar(12) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `crcapp_orderfor_orderID_id_vehicleID_id_869f09df_uniq` (`orderID_id`,`vehicleID_id`),
    KEY `crcapp_orderfor_carID_id_41913d71` (`vehicleID_id`),
    KEY `crcapp_orderfor_orderID_id_f61a599b` (`orderID_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=595 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_orderfor`
  --
  
  INSERT INTO `crcapp_orderfor` (`id`, `vehicleID_id`, `orderID_id`) VALUES
  (1, 'V14806', 'O000003'),
  (2, 'V14816', 'O000004'),
  (3, 'V14810', 'O000005'),
  (4, 'V14812', 'O000006'),
  (5, 'V14814', 'O000007'),
  (6, 'V14816', 'O000008'),
  (7, 'V14818', 'O000009'),
  (8, 'V14811', 'O000011'),
  (9, 'V14812', 'O000012'),
  (10, 'V14813', 'O000013'),
  (11, 'V14814', 'O000014'),
  (12, 'V14815', 'O000015'),
  (13, 'V14816', 'O000016'),
  (14, 'V14817', 'O000017'),
  (15, 'V14818', 'O000018'),
  (16, 'V14819', 'O000019'),
  (17, 'V14835', 'O000020'),
  (18, 'V14842', 'O000021'),
  (19, 'V14839', 'O000022'),
  (20, 'V14838', 'O000023'),
  (21, 'V14843', 'O000024'),
  (22, 'V14850', 'O000025'),
  (23, 'V14847', 'O000026'),
  (24, 'V14846', 'O000027'),
  (25, 'V14851', 'O000028'),
  (26, 'V14858', 'O000029'),
  (27, 'V14860', 'O000030'),
  (28, 'V14831', 'O000031'),
  (29, 'V14832', 'O000032'),
  (30, 'V14833', 'O000033'),
  (31, 'V14834', 'O000034'),
  (32, 'V14835', 'O000035'),
  (33, 'V14836', 'O000036'),
  (34, 'V14837', 'O000037'),
  (35, 'V14838', 'O000038'),
  (36, 'V14839', 'O000039'),
  (37, 'V14880', 'O000040'),
  (38, 'V14842', 'O000041'),
  (39, 'V14855', 'O000042'),
  (40, 'V14846', 'O000043'),
  (41, 'V14859', 'O000044'),
  (42, 'V14850', 'O000045'),
  (43, 'V14863', 'O000046'),
  (44, 'V14854', 'O000047'),
  (45, 'V14870', 'O000048'),
  (46, 'V14858', 'O000049'),
  (47, 'V14860', 'O000050'),
  (48, 'V14851', 'O000051'),
  (49, 'V14852', 'O000052'),
  (50, 'V14853', 'O000053'),
  (51, 'V14854', 'O000054'),
  (52, 'V14831', 'O000055'),
  (53, 'V14856', 'O000056'),
  (54, 'V14857', 'O000057'),
  (55, 'V14858', 'O000058'),
  (56, 'V14859', 'O000059'),
  (57, 'V14860', 'O000060'),
  (58, 'V14861', 'O000061'),
  (59, 'V14862', 'O000062'),
  (60, 'V14863', 'O000063'),
  (61, 'V14864', 'O000064'),
  (62, 'V14865', 'O000065'),
  (63, 'V14866', 'O000066'),
  (64, 'V14867', 'O000067'),
  (65, 'V14852', 'O000068'),
  (66, 'V14852', 'O000069'),
  (67, 'V14870', 'O000070'),
  (68, 'V14871', 'O000071'),
  (69, 'V14872', 'O000072'),
  (70, 'V14873', 'O000073'),
  (71, 'V14874', 'O000074'),
  (72, 'V14875', 'O000075'),
  (73, 'V14876', 'O000076'),
  (74, 'V14877', 'O000077'),
  (75, 'V14878', 'O000078'),
  (76, 'V14879', 'O000079'),
  (77, 'V14880', 'O000080'),
  (78, 'V14881', 'O000081'),
  (79, 'V14882', 'O000082'),
  (80, 'V14883', 'O000083'),
  (81, 'V14884', 'O000084'),
  (82, 'V14885', 'O000085'),
  (83, 'V14886', 'O000086'),
  (84, 'V14887', 'O000087'),
  (85, 'V14888', 'O000088'),
  (86, 'V14889', 'O000089'),
  (87, 'V14890', 'O000090'),
  (88, 'V14891', 'O000091'),
  (89, 'V14892', 'O000092'),
  (90, 'V14872', 'O000093'),
  (91, 'V14894', 'O000094'),
  (92, 'V14895', 'O000095'),
  (93, 'V14896', 'O000096'),
  (94, 'V14897', 'O000097'),
  (95, 'V14872', 'O000098'),
  (96, 'V14899', 'O000099'),
  (97, 'V14900', 'O000100'),
  (98, 'V14901', 'O000101'),
  (99, 'V14902', 'O000102'),
  (100, 'V14903', 'O000103'),
  (101, 'V14904', 'O000104'),
  (102, 'V14905', 'O000105'),
  (103, 'V14906', 'O000106'),
  (104, 'V14907', 'O000107'),
  (105, 'V14908', 'O000108'),
  (106, 'V14909', 'O000109'),
  (107, 'V14910', 'O000110'),
  (108, 'V14911', 'O000111'),
  (109, 'V14912', 'O000112'),
  (110, 'V14903', 'O000113'),
  (111, 'V14914', 'O000114'),
  (112, 'V14915', 'O000115'),
  (113, 'V14906', 'O000116'),
  (114, 'V14903', 'O000117'),
  (115, 'V14903', 'O000118'),
  (116, 'V14903', 'O000119'),
  (117, 'V14920', 'O000120'),
  (118, 'V14921', 'O000121'),
  (119, 'V14922', 'O000122'),
  (120, 'V14923', 'O000123'),
  (121, 'V14924', 'O000124'),
  (122, 'V14925', 'O000125'),
  (123, 'V14926', 'O000126'),
  (124, 'V14927', 'O000127'),
  (125, 'V14928', 'O000128'),
  (126, 'V14929', 'O000129'),
  (127, 'V14930', 'O000130'),
  (128, 'V14906', 'O000131'),
  (129, 'V14923', 'O000132'),
  (130, 'V14920', 'O000133'),
  (131, 'V14924', 'O000134'),
  (132, 'V14924', 'O000135'),
  (133, 'V14920', 'O000136'),
  (134, 'V14906', 'O000137'),
  (135, 'V14923', 'O000138'),
  (136, 'V14920', 'O000139'),
  (137, 'V14940', 'O000140'),
  (138, 'V14941', 'O000141'),
  (139, 'V14942', 'O000142'),
  (140, 'V14943', 'O000143'),
  (141, 'V14944', 'O000144'),
  (142, 'V14945', 'O000145'),
  (143, 'V14946', 'O000146'),
  (144, 'V14947', 'O000147'),
  (145, 'V14948', 'O000148'),
  (146, 'V14949', 'O000149'),
  (147, 'V14950', 'O000150'),
  (148, 'V14927', 'O000151'),
  (149, 'V14924', 'O000152'),
  (150, 'V14941', 'O000153'),
  (151, 'V14929', 'O000154'),
  (152, 'V14943', 'O000155'),
  (153, 'V14920', 'O000156'),
  (154, 'V14947', 'O000157'),
  (155, 'V14944', 'O000158'),
  (156, 'V14943', 'O000159'),
  (157, 'V14943', 'O000160'),
  (158, 'V14944', 'O000161'),
  (159, 'V14967', 'O000162'),
  (160, 'V14943', 'O000163'),
  (161, 'V14944', 'O000164'),
  (162, 'V14960', 'O000165'),
  (163, 'V14961', 'O000166'),
  (164, 'V14962', 'O000167'),
  (165, 'V14943', 'O000168'),
  (166, 'V14964', 'O000169'),
  (167, 'V14961', 'O000170'),
  (168, 'V14944', 'O000171'),
  (169, 'V14961', 'O000172'),
  (170, 'V14944', 'O000173'),
  (171, 'V14969', 'O000174'),
  (172, 'V14960', 'O000175'),
  (173, 'V14962', 'O000176'),
  (174, 'V14962', 'O000177'),
  (175, 'V14962', 'O000178'),
  (176, 'V14962', 'O000179'),
  (177, 'V14962', 'O000180'),
  (178, 'V14966', 'O000181'),
  (179, 'V14962', 'O000182'),
  (180, 'V14961', 'O000183'),
  (181, 'V14965', 'O000184'),
  (182, 'V14969', 'O000185'),
  (183, 'V14967', 'O000186'),
  (184, 'V14966', 'O000187'),
  (185, 'V14969', 'O000188'),
  (186, 'V14967', 'O000189'),
  (187, 'V14961', 'O000190'),
  (188, 'V14967', 'O000191'),
  (189, 'V14963', 'O000192'),
  (190, 'V14967', 'O000193'),
  (191, 'V14985', 'O000194'),
  (192, 'V14967', 'O000195'),
  (193, 'V14985', 'O000196'),
  (194, 'V14985', 'O000197'),
  (195, 'V14962', 'O000198'),
  (196, 'V14984', 'O000199'),
  (197, 'V15004', 'O000200'),
  (198, 'V15001', 'O000201'),
  (199, 'V15002', 'O000202'),
  (200, 'V15003', 'O000203'),
  (201, 'V15004', 'O000204'),
  (202, 'V15005', 'O000205'),
  (203, 'V15006', 'O000206'),
  (204, 'V15007', 'O000207'),
  (205, 'V15008', 'O000208'),
  (206, 'V15009', 'O000209'),
  (207, 'V15010', 'O000210'),
  (208, 'V15005', 'O000211'),
  (209, 'V15003', 'O000212'),
  (210, 'V15004', 'O000213'),
  (211, 'V15005', 'O000214'),
  (212, 'V15006', 'O000215'),
  (213, 'V15009', 'O000216'),
  (214, 'V15000', 'O000217'),
  (215, 'V15001', 'O000218'),
  (216, 'V14988', 'O000219'),
  (217, 'V15020', 'O000220'),
  (218, 'V15021', 'O000221'),
  (219, 'V15022', 'O000222'),
  (220, 'V15023', 'O000223'),
  (221, 'V15024', 'O000224'),
  (222, 'V15025', 'O000225'),
  (223, 'V15026', 'O000226'),
  (224, 'V15027', 'O000227'),
  (225, 'V15028', 'O000228'),
  (226, 'V15029', 'O000229'),
  (227, 'V15030', 'O000230'),
  (228, 'V15001', 'O000231'),
  (229, 'V15005', 'O000232'),
  (230, 'V15009', 'O000233'),
  (231, 'V15006', 'O000234'),
  (232, 'V15009', 'O000235'),
  (233, 'V15011', 'O000236'),
  (234, 'V15006', 'O000237'),
  (235, 'V15008', 'O000238'),
  (236, 'V15003', 'O000239'),
  (237, 'V15040', 'O000240'),
  (238, 'V15041', 'O000241'),
  (239, 'V15043', 'O000243'),
  (240, 'V15044', 'O000244'),
  (241, 'V15045', 'O000245'),
  (242, 'V15046', 'O000246'),
  (243, 'V15047', 'O000247'),
  (244, 'V15048', 'O000248'),
  (245, 'V15049', 'O000249'),
  (246, 'V15050', 'O000250'),
  (247, 'V15043', 'O000251'),
  (248, 'V15047', 'O000252'),
  (249, 'V15024', 'O000253'),
  (250, 'V15042', 'O000254'),
  (251, 'V15041', 'O000255'),
  (252, 'V15047', 'O000256'),
  (253, 'V15043', 'O000257'),
  (254, 'V15040', 'O000258'),
  (255, 'V15041', 'O000259'),
  (256, 'V15042', 'O000260'),
  (257, 'V15047', 'O000261'),
  (258, 'V15048', 'O000262'),
  (259, 'V15045', 'O000263'),
  (260, 'V15040', 'O000264'),
  (261, 'V15045', 'O000265'),
  (262, 'V15041', 'O000266'),
  (263, 'V15049', 'O000267'),
  (264, 'V15040', 'O000268'),
  (265, 'V15045', 'O000269'),
  (266, 'V15046', 'O000270'),
  (267, 'V15046', 'O000271'),
  (268, 'V15047', 'O000272'),
  (269, 'V15042', 'O000273'),
  (270, 'V15046', 'O000274'),
  (271, 'V15040', 'O000275'),
  (272, 'V15047', 'O000276'),
  (273, 'V15048', 'O000277'),
  (274, 'V15066', 'O000278'),
  (275, 'V15044', 'O000279'),
  (276, 'V15063', 'O000280'),
  (277, 'V15082', 'O000281'),
  (278, 'V15087', 'O000282'),
  (279, 'V15068', 'O000283'),
  (280, 'V15088', 'O000284'),
  (281, 'V15068', 'O000285'),
  (282, 'V15081', 'O000286'),
  (283, 'V15063', 'O000287'),
  (284, 'V15066', 'O000288'),
  (285, 'V15063', 'O000289'),
  (286, 'V15081', 'O000290'),
  (287, 'V15085', 'O000291'),
  (288, 'V15083', 'O000292'),
  (289, 'V15088', 'O000293'),
  (290, 'V15063', 'O000294'),
  (291, 'V15084', 'O000295'),
  (292, 'V15080', 'O000296'),
  (293, 'V15088', 'O000297'),
  (294, 'V15081', 'O000298'),
  (295, 'V15080', 'O000299'),
  (296, 'V15100', 'O000300'),
  (297, 'V15101', 'O000301'),
  (298, 'V15102', 'O000302'),
  (299, 'V15103', 'O000303'),
  (300, 'V15104', 'O000304'),
  (301, 'V15105', 'O000305'),
  (302, 'V15106', 'O000306'),
  (303, 'V15107', 'O000307'),
  (304, 'V15108', 'O000308'),
  (305, 'V15109', 'O000309'),
  (306, 'V15110', 'O000310'),
  (307, 'V15085', 'O000311'),
  (308, 'V15101', 'O000312'),
  (309, 'V15101', 'O000313'),
  (310, 'V15085', 'O000314'),
  (311, 'V15089', 'O000315'),
  (312, 'V15104', 'O000316'),
  (313, 'V15082', 'O000317'),
  (314, 'V15106', 'O000318'),
  (315, 'V15083', 'O000319'),
  (316, 'V15124', 'O000320'),
  (317, 'V15121', 'O000321'),
  (318, 'V15122', 'O000322'),
  (319, 'V15123', 'O000323'),
  (320, 'V15124', 'O000324'),
  (321, 'V15125', 'O000325'),
  (322, 'V15126', 'O000326'),
  (323, 'V15127', 'O000327'),
  (324, 'V15128', 'O000328'),
  (325, 'V15129', 'O000329'),
  (326, 'V15130', 'O000330'),
  (327, 'V15106', 'O000331'),
  (328, 'V15106', 'O000332'),
  (329, 'V15119', 'O000333'),
  (330, 'V15128', 'O000334'),
  (331, 'V15119', 'O000335'),
  (332, 'V15129', 'O000336'),
  (333, 'V15127', 'O000337'),
  (334, 'V15127', 'O000338'),
  (335, 'V15129', 'O000339'),
  (336, 'V15140', 'O000340'),
  (337, 'V15142', 'O000342'),
  (338, 'V15143', 'O000343'),
  (339, 'V15144', 'O000344'),
  (340, 'V15145', 'O000345'),
  (341, 'V15146', 'O000346'),
  (342, 'V15147', 'O000347'),
  (343, 'V15148', 'O000348'),
  (344, 'V15149', 'O000349'),
  (345, 'V15150', 'O000350'),
  (346, 'V15140', 'O000351'),
  (347, 'V15140', 'O000352'),
  (348, 'V15123', 'O000353'),
  (349, 'V15124', 'O000354'),
  (350, 'V15129', 'O000355'),
  (351, 'V15129', 'O000356'),
  (352, 'V15127', 'O000357'),
  (353, 'V15122', 'O000358'),
  (354, 'V15140', 'O000359'),
  (355, 'V15123', 'O000360'),
  (356, 'V15165', 'O000361'),
  (357, 'V15166', 'O000362'),
  (358, 'V15145', 'O000363'),
  (359, 'V15168', 'O000364'),
  (360, 'V15169', 'O000365'),
  (361, 'V15145', 'O000366'),
  (362, 'V15161', 'O000367'),
  (363, 'V15162', 'O000368'),
  (364, 'V15169', 'O000369'),
  (365, 'V15142', 'O000370'),
  (366, 'V15165', 'O000371'),
  (367, 'V15162', 'O000372'),
  (368, 'V15166', 'O000373'),
  (369, 'V15167', 'O000374'),
  (370, 'V15169', 'O000375'),
  (371, 'V15166', 'O000376'),
  (372, 'V15165', 'O000377'),
  (373, 'V15161', 'O000378'),
  (374, 'V15169', 'O000379'),
  (375, 'V15163', 'O000380'),
  (376, 'V15161', 'O000381'),
  (377, 'V15165', 'O000382'),
  (378, 'V15166', 'O000383'),
  (379, 'V15165', 'O000384'),
  (380, 'V15165', 'O000385'),
  (381, 'V15169', 'O000386'),
  (382, 'V15160', 'O000387'),
  (383, 'V15165', 'O000388'),
  (384, 'V15163', 'O000389'),
  (385, 'V15166', 'O000390'),
  (386, 'V15165', 'O000391'),
  (387, 'V15181', 'O000392'),
  (388, 'V15166', 'O000393'),
  (389, 'V15168', 'O000395'),
  (390, 'V15169', 'O000396'),
  (391, 'V15186', 'O000397'),
  (392, 'V15186', 'O000398'),
  (393, 'V15184', 'O000399'),
  (394, 'V15209', 'O000400'),
  (395, 'V15201', 'O000401'),
  (396, 'V15202', 'O000402'),
  (397, 'V15203', 'O000403'),
  (398, 'V15204', 'O000404'),
  (399, 'V15205', 'O000405'),
  (400, 'V15206', 'O000406'),
  (401, 'V15207', 'O000407'),
  (402, 'V15208', 'O000408'),
  (403, 'V15209', 'O000409'),
  (404, 'V15210', 'O000410'),
  (405, 'V15200', 'O000411'),
  (406, 'V15181', 'O000412'),
  (407, 'V15206', 'O000413'),
  (408, 'V15207', 'O000414'),
  (409, 'V15204', 'O000415'),
  (410, 'V15202', 'O000416'),
  (411, 'V15200', 'O000417'),
  (412, 'V15199', 'O000418'),
  (413, 'V15208', 'O000419'),
  (414, 'V15220', 'O000420'),
  (415, 'V15221', 'O000421'),
  (416, 'V15222', 'O000422'),
  (417, 'V15223', 'O000423'),
  (418, 'V15224', 'O000424'),
  (419, 'V15225', 'O000425'),
  (420, 'V15226', 'O000426'),
  (421, 'V15227', 'O000427'),
  (422, 'V15228', 'O000428'),
  (423, 'V15229', 'O000429'),
  (424, 'V15230', 'O000430'),
  (425, 'V15220', 'O000431'),
  (426, 'V15200', 'O000432'),
  (427, 'V15204', 'O000433'),
  (428, 'V15205', 'O000434'),
  (429, 'V15223', 'O000435'),
  (430, 'V15207', 'O000436'),
  (431, 'V15205', 'O000437'),
  (432, 'V15200', 'O000438'),
  (433, 'V15220', 'O000439'),
  (434, 'V15241', 'O000440'),
  (435, 'V15241', 'O000441'),
  (436, 'V15242', 'O000442'),
  (437, 'V15243', 'O000443'),
  (438, 'V15244', 'O000444'),
  (439, 'V15245', 'O000445'),
  (440, 'V15246', 'O000446'),
  (441, 'V15247', 'O000447'),
  (442, 'V15248', 'O000448'),
  (443, 'V15249', 'O000449'),
  (444, 'V15250', 'O000450'),
  (445, 'V15225', 'O000451'),
  (446, 'V15224', 'O000452'),
  (447, 'V15241', 'O000453'),
  (448, 'V15242', 'O000454'),
  (449, 'V15243', 'O000455'),
  (450, 'V15243', 'O000456'),
  (451, 'V15249', 'O000457'),
  (452, 'V15240', 'O000458'),
  (453, 'V15247', 'O000459'),
  (454, 'V15243', 'O000460'),
  (455, 'V15243', 'O000461'),
  (456, 'V15244', 'O000462'),
  (457, 'V15243', 'O000463'),
  (458, 'V15242', 'O000464'),
  (459, 'V15249', 'O000465'),
  (460, 'V15244', 'O000466'),
  (461, 'V15245', 'O000467'),
  (462, 'V15248', 'O000468'),
  (463, 'V15241', 'O000469'),
  (464, 'V15242', 'O000470'),
  (465, 'V15249', 'O000471'),
  (466, 'V15243', 'O000472'),
  (467, 'V15245', 'O000473'),
  (468, 'V15242', 'O000474'),
  (469, 'V15247', 'O000475'),
  (470, 'V15247', 'O000476'),
  (471, 'V15245', 'O000477'),
  (472, 'V15261', 'O000478'),
  (473, 'V15261', 'O000479'),
  (474, 'V15241', 'O000480'),
  (475, 'V15280', 'O000481'),
  (476, 'V15263', 'O000482'),
  (477, 'V15280', 'O000483'),
  (478, 'V15263', 'O000484'),
  (479, 'V15261', 'O000485'),
  (480, 'V15261', 'O000486'),
  (481, 'V15280', 'O000487'),
  (482, 'V15280', 'O000488'),
  (483, 'V15264', 'O000489'),
  (484, 'V15280', 'O000490'),
  (485, 'V15261', 'O000491'),
  (486, 'V15261', 'O000492'),
  (487, 'V15280', 'O000493'),
  (488, 'V15282', 'O000494'),
  (489, 'V15263', 'O000495'),
  (490, 'V15280', 'O000496'),
  (491, 'V15284', 'O000497'),
  (492, 'V15260', 'O000498'),
  (493, 'V15259', 'O000499'),
  (494, 'V15300', 'O000500'),
  (495, 'V15301', 'O000501'),
  (496, 'V15302', 'O000502'),
  (497, 'V15303', 'O000503'),
  (498, 'V15304', 'O000504'),
  (499, 'V15305', 'O000505'),
  (500, 'V15306', 'O000506'),
  (501, 'V15307', 'O000507'),
  (502, 'V15308', 'O000508'),
  (503, 'V15309', 'O000509'),
  (504, 'V15310', 'O000510'),
  (505, 'V15297', 'O000511'),
  (506, 'V15297', 'O000512'),
  (507, 'V15297', 'O000513'),
  (508, 'V15297', 'O000514'),
  (509, 'V15297', 'O000515'),
  (510, 'V15280', 'O000516'),
  (511, 'V15280', 'O000517'),
  (512, 'V15300', 'O000518'),
  (513, 'V15280', 'O000519'),
  (514, 'V15327', 'O000520'),
  (515, 'V15321', 'O000521'),
  (516, 'V15322', 'O000522'),
  (517, 'V15323', 'O000523'),
  (518, 'V15324', 'O000524'),
  (519, 'V15325', 'O000525'),
  (520, 'V15326', 'O000526'),
  (521, 'V15327', 'O000527'),
  (522, 'V15328', 'O000528'),
  (523, 'V15329', 'O000529'),
  (524, 'V15330', 'O000530'),
  (525, 'V15322', 'O000531'),
  (526, 'V15317', 'O000532'),
  (527, 'V15324', 'O000533'),
  (528, 'V15317', 'O000534'),
  (529, 'V15325', 'O000535'),
  (530, 'V15323', 'O000536'),
  (531, 'V15324', 'O000537'),
  (532, 'V15328', 'O000538'),
  (533, 'V15329', 'O000539'),
  (534, 'V15340', 'O000540'),
  (535, 'V15341', 'O000541'),
  (536, 'V15342', 'O000542'),
  (537, 'V15343', 'O000543'),
  (538, 'V15344', 'O000544'),
  (539, 'V15345', 'O000545'),
  (540, 'V15346', 'O000546'),
  (541, 'V15347', 'O000547'),
  (542, 'V15348', 'O000548'),
  (543, 'V15349', 'O000549'),
  (544, 'V15350', 'O000550'),
  (545, 'V15327', 'O000551'),
  (546, 'V15343', 'O000552'),
  (547, 'V15343', 'O000553'),
  (548, 'V15323', 'O000554'),
  (549, 'V15340', 'O000556'),
  (550, 'V15321', 'O000557'),
  (551, 'V15324', 'O000558'),
  (552, 'V15328', 'O000559'),
  (553, 'V15326', 'O000560'),
  (554, 'V15367', 'O000561'),
  (555, 'V15316', 'O000562'),
  (556, 'V15369', 'O000563'),
  (557, 'V15343', 'O000564'),
  (558, 'V15361', 'O000565'),
  (559, 'V15340', 'O000566'),
  (560, 'V15340', 'O000567'),
  (561, 'V15346', 'O000568'),
  (562, 'V15340', 'O000569'),
  (563, 'V15366', 'O000570'),
  (564, 'V15361', 'O000571'),
  (565, 'V15361', 'O000572'),
  (566, 'V15369', 'O000573'),
  (567, 'V15363', 'O000574'),
  (568, 'V15361', 'O000575'),
  (569, 'V15340', 'O000576'),
  (570, 'V15363', 'O000577'),
  (571, 'V15364', 'O000578'),
  (572, 'V15368', 'O000579'),
  (573, 'V15369', 'O000580'),
  (574, 'V15361', 'O000581'),
  (575, 'V15367', 'O000582'),
  (576, 'V15361', 'O000583'),
  (577, 'V15361', 'O000584'),
  (578, 'V15364', 'O000585'),
  (579, 'V15361', 'O000586'),
  (580, 'V15369', 'O000587'),
  (581, 'V15368', 'O000588'),
  (582, 'V15361', 'O000589'),
  (583, 'V15366', 'O000590'),
  (584, 'V15369', 'O000591'),
  (585, 'V15361', 'O000592'),
  (586, 'V15361', 'O000593'),
  (587, 'V15369', 'O000594'),
  (588, 'V15360', 'O000595'),
  (589, 'V15362', 'O000596'),
  (590, 'V15365', 'O000597'),
  (591, 'V15363', 'O000598'),
  (592, 'V15357', 'O000599'),
  (593, 'V15400', 'O000600'),
  (594, 'V15324', 'O000601');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_store`
  --
  
  DROP TABLE IF EXISTS `crcapp_store`;
  CREATE TABLE IF NOT EXISTS `crcapp_store` (
    `storeID` varchar(10) NOT NULL,
    `storeName` varchar(50) NOT NULL,
    `storePhone` bigint(20) NOT NULL,
    `street` varchar(70) NOT NULL,
    `city` varchar(30) NOT NULL,
    `state` varchar(30) NOT NULL,
    PRIMARY KEY (`storeID`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_store`
  --
  
  INSERT INTO `crcapp_store` (`storeID`, `storeName`, `storePhone`, `street`, `city`, `state`) VALUES
  ('S0001', 'Alexandria Store', 1115435350162, '3761 N. 14th St', 'Alexandria      ', 'New South Wales'),
  ('S0002', 'Coffs Harbour Store', 1115435350110, '2243 W St.', 'Coffs Harbour   ', 'New South Wales'),
  ('S0003', 'Darlinghurst Store', 1115435350184, '5844 Linden Land', 'Darlinghurst    ', 'New South Wales'),
  ('S0004', 'Goulburn Store', 1115435350162, '1825 Village Pl.', 'Goulburn        ', 'New South Wales'),
  ('S0005', 'Lane Cove Store', 1115435350131, '7553 Harness Circle', 'Lane Cove       ', 'New South Wales'),
  ('S0006', 'Lavender Bay Store', 1115435350151, '7305 Humphrey Drive', 'Lavender Bay    ', 'New South Wales'),
  ('S0007', 'Malabar Store', 1115435350184, '2612 Berry Dr', 'Malabar         ', 'New South Wales'),
  ('S0008', 'Matraville Store', 1115435350126, '942 Brook Street', 'Matraville      ', 'New South Wales'),
  ('S0009', 'Milsons Point Store', 1115435350164, '624 Peabody Road', 'Milsons Point   ', 'New South Wales'),
  ('S0010', 'Newcastle Store', 1115435350110, '3839 Northgate Road', 'Newcastle       ', 'New South Wales'),
  ('S0011', 'North Ryde Store', 1115435350169, '7800 Corrinne Court', 'North Ryde      ', 'New South Wales'),
  ('S0012', 'North Sydney Store', 1115435350117, '1224 Shoenic', 'North Sydney    ', 'New South Wales'),
  ('S0013', 'Port Macquarie Store', 7175350164, '4785 Scott Street', 'Port Macquarie  ', 'New South Wales'),
  ('S0014', 'Rhodes Store', 8175350185, '7902 Hudson Ave.', 'Rhodes          ', 'New South Wales'),
  ('S0015', 'Silverwater Store', 4315350156, '9011 Tank Drive', 'Silverwater     ', 'New South Wales'),
  ('S0016', 'Springwood Store', 2085350142, '244 Willow Pass Road', 'Springwood      ', 'New South Wales'),
  ('S0017', 'St. Leonards Store', 1355350171, '9666 Northridge Ct.', 'St. Leonards    ', 'New South Wales'),
  ('S0018', 'Sydney Store', 1115435350195, '7330 Saddlehill Lane', 'Sydney          ', 'New South Wales'),
  ('S0019', 'Wollongong Store', 1115435350137, '244 Rivewview', 'Wollongong      ', 'New South Wales'),
  ('S0020', 'Brisbane Store', 2625350112, '7832 Landing Dr', 'Brisbane        ', 'Queensland'),
  ('S0021', 'Caloundra Store', 5505350163, '7156 Rose Dr.', 'Caloundra       ', 'Queensland'),
  ('S0022', 'East Brisbane Store', 6225350158, '8148 W. Lake Dr.', 'East Brisbane   ', 'Queensland'),
  ('S0023', 'Gold Coast Store', 5895350185, '1769 Nicholas Drive', 'Gold Coast      ', 'Queensland'),
  ('S0024', 'Hawthorne Store', 4525350188, '4499 Valley Crest', 'Hawthorne       ', 'Queensland'),
  ('S0025', 'Hervey Bay Store', 7465350186, '8734 Oxford Place', 'Hervey Bay      ', 'Queensland'),
  ('S0026', 'Rockhampton Store', 1115435350178, '2596 Franklin Canyon Road', 'Rockhampton     ', 'Queensland'),
  ('S0027', 'Townsville Store', 1115435350131, '8211 Leeds Ct.', 'Townsville      ', 'Queensland'),
  ('S0028', 'Cloverdale Store', 1115435350184, '213 Valencia Place', 'Cloverdale      ', 'South Australia'),
  ('S0029', 'Findon Store', 1115435350116, '9111 Rose Ann Ave', 'Findon          ', 'South Australia'),
  ('S0030', 'Perth Store', 1115435350146, '6385 Mark Twain', 'Perth           ', 'South Australia'),
  ('S0031', 'Hobart Store', 1115435350182, '636 Vine Hill Way', 'Hobart          ', 'Tasmania'),
  ('S0032', 'Bendigo Store', 1115435350195, '6465 Detroit Ave.', 'Bendigo         ', 'Victoria'),
  ('S0033', 'Cranbourne Store', 1115435350169, '626 Bentley Street', 'Cranbourne      ', 'Victoria'),
  ('S0034', 'Geelong Store', 1115435350137, '5927 Rainbow Dr', 'Geelong         ', 'Victoria'),
  ('S0035', 'Melbourne Store', 1115435350136, '5167 Condor Place', 'Melbourne       ', 'Victoria'),
  ('S0036', 'Melton Store', 1115435350177, '1873 Mt. Whitney Dr', 'Melton          ', 'Victoria'),
  ('S0037', 'Seaford Store', 1155350183, '3981 Augustine Drive', 'Seaford         ', 'Victoria'),
  ('S0038', 'South Melbourne Store', 2295350112, '8915 Woodside Way', 'South Melbourne ', 'Victoria'),
  ('S0039', 'Sunbury Store', 1115435350114, '8357 Sandy Cove Lane', 'Sunbury         ', 'Victoria'),
  ('S0040', 'Warrnambool Store', 1115435350183, '9353 Creekside Dr.', 'Warrnambool     ', 'Victoria');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `crcapp_vehicle`
  --
  
  DROP TABLE IF EXISTS `crcapp_vehicle`;
  CREATE TABLE IF NOT EXISTS `crcapp_vehicle` (
    `vehicleID` varchar(10) NOT NULL,
    `makeName` varchar(50) NOT NULL,
    `model` varchar(50) NOT NULL,
    `series` varchar(50) NOT NULL,
    `year` int(11) NOT NULL,
    `newPrice` decimal(10,2) NOT NULL,
    `enginesize` decimal(4,1) NOT NULL,
    `fuelSystem` varchar(50) NOT NULL,
    `tankcapacity` decimal(7,1) NOT NULL,
    `power` int(11) NOT NULL,
    `seatingCapacity` int(11) NOT NULL,
    `standardTransmission` varchar(50) NOT NULL,
    `bodyType` varchar(50) NOT NULL,
    `driveType` varchar(30) NOT NULL,
    `wheelbase` int(11) NOT NULL,
    `storeID_id` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`vehicleID`),
    KEY `crcapp_vehicle_storeID_id_a6b52d2b` (`storeID_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `crcapp_vehicle`
  --
  
  INSERT INTO `crcapp_vehicle` (`vehicleID`, `makeName`, `model`, `series`, `year`, `newPrice`, `enginesize`, `fuelSystem`, `tankcapacity`, `power`, `seatingCapacity`, `standardTransmission`, `bodyType`, `driveType`, `wheelbase`, `storeID_id`) VALUES
  ('V14806', 'LAND ROVER', 'DISCOVERY 3', 'HSE', 2006, '83650.00', '2.7', 'DIESEL TURBO F/INJ', '82.0', 140, 7, '6A', '4D WAGON', '4WD', 2885, 'S0016'),
  ('V14816', 'LAND ROVER', 'DISCOVERY', 'SERIES II S 4x4', 2003, '55450.00', '4.0', 'MULTI POINT F/INJ', '93.0', 136, 7, '4A', '4D WAGON', '4WD', 2540, 'S0008'),
  ('V14810', 'LAND ROVER', 'DISCOVERY', 'Tdi 4x4', 1996, '51800.00', '2.5', 'DIESEL TURBO', '88.5', 83, 5, '4A4x4', '4D WAGON', '4WD', 2540, 'S0005'),
  ('V14812', 'LAND ROVER', 'DISCOVERY', 'ES V8 4x4', 1999, '66000.00', '4.0', 'MULTI POINT F/INJ', '95.0', 132, 7, '4A', '4D WAGON', '4WD', 2540, 'S0025'),
  ('V14814', 'LAND ROVER', 'DISCOVERY', 'SERIES II SE 4x4', 2004, '71450.00', '4.0', 'MULTI POINT F/INJ', '93.0', 136, 7, '4A', '4D WAGON', '4WD', 2540, 'S0014'),
  ('V14818', 'LAND ROVER', 'DISCOVERY', 'S 4x4', 1998, '39990.00', '2.5', 'DIESEL TURBO', '88.5', 83, 5, '5M4x4', '4D WAGON', '4WD', 2540, 'S0018'),
  ('V14811', 'LAND ROVER', 'FREELANDER', 'XEi 4x4', 2000, '34886.00', '1.8', 'MULTI POINT F/INJ', '59.0', 84, 5, '5M4x4', '3D HARDBACK', '4WD', 2535, 'S0013'),
  ('V14813', 'LAND ROVER', 'DISCOVERY', 'Tdi 4x4', 1994, '50430.00', '2.5', 'DIESEL TURBO', '88.5', 83, 5, '4A4x4', '4D WAGON', '4WD', 2540, 'S0013'),
  ('V14815', 'LAND ROVER', '(4x4)', 'SWB', 1978, '9045.00', '2.3', 'DIESEL', '45.0', 46, 8, '4M4x4', '2D HARDTOP', '4WD', 2230, 'S0015'),
  ('V14817', 'LAND ROVER', 'DISCOVERY', 'SERIES II', 2003, '51950.00', '2.5', 'DIESEL TURBO F/INJ', '93.0', 101, 5, '5M', '4D WAGON', '4WD', 2540, 'S0050'),
  ('V14819', 'LAND ROVER', '(4x4)', 'LWB', 1972, '5203.00', '2.3', 'DIESEL', '73.0', 46, 12, '4M4x4', '2D HARDTOP', '4WD', 2768, 'S0014'),
  ('V14835', 'BMW', '7', '35i EXECUTIVE', 1987, '136500.00', '3.4', 'ELECTRONIC F/INJ', '90.0', 155, 5, '4A', '4D SEDAN', 'RWD', 2833, 'S0035'),
  ('V14842', 'BMW', '3', 'E90 20i EXECUTIVE', 2005, '57200.00', '2.0', 'MULTI POINT F/INJ', '65.0', 110, 5, '6AS', '4D SEDAN', 'RWD', 2760, 'S0001'),
  ('V14839', 'BMW', '3', 'E36 16i OPEN AIR', 1995, '46200.00', '1.6', 'MULTI POINT F/INJ', '52.0', 75, 5, '5M', '3D HATCHBACK', 'RWD', 2700, 'S0039'),
  ('V14838', 'BMW', '5', 'E34 25i EXECUTIVE', 1996, '98200.00', '2.5', 'ELECTRONIC F/INJ', '80.0', 141, 5, '5A', '4D SEDAN', 'RWD', 2761, 'S0025'),
  ('V14843', 'BMW', '3', 'E46 30i', 2001, '90700.00', '3.0', 'MULTI POINT F/INJ', '63.0', 170, 5, '5AS', '4D SEDAN', 'RWD', 2725, 'S0019'),
  ('V14850', 'BMW', '7', '35i', 1984, '59500.00', '3.2', 'ELECTRONIC F/INJ', '100.0', 145, 5, '4A', '4D SEDAN', 'RWD', 2795, 'S0005'),
  ('V14847', 'BMW', '3', '18is', 1998, '56600.00', '1.9', 'MULTI POINT F/INJ', '65.0', 103, 5, '4A', '4D SEDAN', 'RWD', 2700, 'S0021'),
  ('V14846', 'BMW', 'X5', 'E53 3.0i', 2004, '84000.00', '3.0', 'MULTI POINT F/INJ', '93.0', 170, 5, '5AS', '4D WAGON', '4WD', 2820, 'S0003'),
  ('V14851', 'BMW', '3', 'E46 20i SPORT', 2005, '65300.00', '2.2', 'MULTI POINT F/INJ', '63.0', 125, 5, '5AS', '4D SEDAN', 'RWD', 2725, 'S0022'),
  ('V14858', 'BMW', '3', 'E36 28i', 1996, '83330.00', '2.8', 'MULTI POINT F/INJ', '65.0', 142, 5, '5A', '4D SEDAN', 'RWD', 2700, 'S0009'),
  ('V14860', 'BMW', '3', '18i', 1997, '51320.00', '1.8', 'ELECTRONIC F/INJ', '65.0', 85, 5, '4A', '4D SEDAN', 'RWD', 2700, 'S0010'),
  ('V14831', 'BMW', 'X5', 'E53 3.0d', 2004, '84500.00', '3.0', 'TURBO CDI', '93.0', 150, 5, '6A', '4D WAGON', '4WD', 2820, 'S0024'),
  ('V14832', 'BMW', '3', 'E46 18i EXECUTIVE', 2002, '56550.00', '2.0', 'MULTI POINT F/INJ', '63.0', 105, 5, '5AS', '4D SEDAN', 'RWD', 2725, 'S0021'),
  ('V14833', 'BMW', '3', '23i', 1996, '62550.00', '2.5', 'MULTI POINT F/INJ', '62.0', 125, 5, '5M', '4D SEDAN', 'RWD', 2700, 'S0015'),
  ('V14834', 'BMW', '3', 'E46 30Ci', 2001, '109050.00', '3.0', 'MULTI POINT F/INJ', '63.0', 170, 5, '5AS', '2D CONVERTIBLE', 'RWD', 2725, 'S0021'),
  ('V14836', 'BMW', '5', 'E60 25i', 2005, '89000.00', '2.5', 'MULTI POINT F/INJ', '70.0', 141, 5, '6AS', '4D SEDAN', 'RWD', 2888, 'S0023'),
  ('V14837', 'BMW', '3', 'E91 23i TOURING', 2006, '71500.00', '2.5', 'MULTI POINT F/INJ', '60.0', 130, 5, '6AS', '4D WAGON', 'RWD', 2760, 'S0037'),
  ('V14880', 'BMW', '5', '20i', 1991, '69100.00', '2.0', 'ELECTRONIC F/INJ', '80.0', 110, 5, '5A', '4D SEDAN', 'RWD', 2761, 'S0015'),
  ('V14855', 'BMW', '3', 'E46 20Ci', 2001, '67050.00', '2.2', 'MULTI POINT F/INJ', '63.0', 125, 5, '5AS', '2D COUPE', 'RWD', 2725, 'S0013'),
  ('V14859', 'BMW', '5', '28i', 1997, '96500.00', '2.8', 'MULTI POINT F/INJ', '70.0', 142, 5, '5AS', '4D SEDAN', 'RWD', 2830, 'S0019'),
  ('V14863', 'BMW', 'X5', 'E53 3.0i', 2001, '82350.00', '3.0', 'MULTI POINT F/INJ', '93.0', 170, 5, '5AS', '4D WAGON', '4WD', 2820, 'S0023'),
  ('V14854', 'BMW', '3', '20i', 1989, '54700.00', '2.0', 'ELECTRONIC F/INJ', '65.0', 95, 5, '5M', '4D SEDAN', 'RWD', 2570, 'S0014'),
  ('V14870', 'BMW', '3', '23Ci', 1999, '73900.00', '2.5', 'MULTI POINT F/INJ', '63.0', 125, 5, '5M', '2D COUPE', 'RWD', 2725, 'S0030'),
  ('V14852', 'BMW', '3', 'E46 16ti', 2002, '43869.00', '1.8', 'MULTI POINT F/INJ', '63.0', 85, 5, '5AS', '3D HATCHBACK', 'RWD', 2725, 'S0016'),
  ('V14853', 'BMW', '1', 'E87 20i', 2005, '44100.00', '2.0', 'MULTI POINT F/INJ', '50.0', 110, 5, '6A', '5D HATCHBACK', 'RWD', 2660, 'S0009'),
  ('V14856', 'BMW', '3', '25i', 1988, '74500.00', '2.5', 'ELECTRONIC F/INJ', '55.0', 125, 5, '4A', '4D SEDAN', 'RWD', 2570, 'S0014'),
  ('V14857', 'BMW', '3', 'E46 18i SPORT', 2005, '54500.00', '2.0', 'MULTI POINT F/INJ', '63.0', 105, 5, '5M', '4D SEDAN', 'RWD', 2725, 'S0013'),
  ('V14861', 'BMW', '3', '18is', 1997, '55100.00', '1.9', 'MULTI POINT F/INJ', '65.0', 103, 5, '5M', '4D SEDAN', 'RWD', 2700, 'S0021'),
  ('V14862', 'BMW', '3', 'E46 18i EXECUTIVE', 2001, '53950.00', '2.0', 'MULTI POINT F/INJ', '63.0', 105, 5, '5M', '4D SEDAN', 'RWD', 2725, 'S0022'),
  ('V14864', 'BMW', '1', 'E87 20d', 2006, '47800.00', '2.0', 'DIESEL TURBO F/INJ', '51.0', 115, 5, '6A', '5D HATCHBACK', 'RWD', 2660, 'S0017'),
  ('V14865', 'BMW', '3', 'E46 18i EXECUTIVE', 2000, '52070.00', '1.9', 'MULTI POINT F/INJ', '63.0', 87, 5, '5M', '4D SEDAN', 'RWD', 2725, 'S0025'),
  ('V14866', 'BMW', 'X5', 'E53 3.0i', 2006, '84000.00', '3.0', 'MULTI POINT F/INJ', '93.0', 170, 5, '5AS', '4D WAGON', '4WD', 2820, 'S0026'),
  ('V14867', 'BMW', '3', '18i', 1995, '49650.00', '1.8', 'ELECTRONIC F/INJ', '65.0', 85, 5, '5M', '4D SEDAN', 'RWD', 2700, 'S0027'),
  ('V14871', 'BMW', 'X5', 'E53 MY06 UPGRADE 3.0d', 2006, '86800.00', '3.0', 'TURBO CDI', '93.0', 150, 5, '6A', '4D WAGON', '4WD', 2820, 'S0031'),
  ('V14872', 'BMW', '3', 'E46 18i', 1999, '54370.00', '1.9', 'MULTI POINT F/INJ', '63.0', 87, 5, '5M', '4D SEDAN', 'RWD', 2725, 'S0021'),
  ('V14873', 'BMW', '3', '18is', 1996, '57110.00', '1.8', 'ELECTRONIC F/INJ', '65.0', 103, 5, '4A', '2D COUPE', 'RWD', 2700, 'S0023'),
  ('V14874', 'BMW', '3', 'E46 16ti', 2004, '41750.00', '1.8', 'MULTI POINT F/INJ', '63.0', 85, 5, '5M', '3D HATCHBACK', 'RWD', 2725, 'S0024'),
  ('V14875', 'BMW', '3', '18i', 1989, '36950.00', '1.8', 'ELECTRONIC F/INJ', '55.0', 83, 5, '5M', '2D SEDAN', 'RWD', 2570, 'S0028'),
  ('V14876', 'BMW', '3', '18i', 1994, '46500.00', '1.8', 'ELECTRONIC F/INJ', '65.0', 85, 5, '5M', '4D SEDAN', 'RWD', 2700, 'S0026'),
  ('V14877', 'BMW', '3', 'E90 20i', 2006, '53400.00', '2.0', 'MULTI POINT F/INJ', '65.0', 110, 5, '6AS', '4D SEDAN', 'RWD', 2760, 'S0037'),
  ('V14878', 'BMW', '5', 'E39 23i', 1996, '83600.00', '2.5', 'MULTI POINT F/INJ', '70.0', 125, 5, '5AS', '4D SEDAN', 'RWD', 2830, 'S0013'),
  ('V14879', 'BMW', '5', 'E39 30i SPORT', 2002, '101400.00', '3.0', 'MULTI POINT F/INJ', '70.0', 170, 5, '5AS', '4D SEDAN', 'RWD', 2830, 'S0014'),
  ('V14881', 'BMW', '3', '18i', 1991, '44300.00', '1.8', 'ELECTRONIC F/INJ', '65.0', 85, 5, '4A', '4D SEDAN', 'RWD', 2700, 'S0013'),
  ('V14882', 'BMW', '3', 'E46 18i', 2000, '48315.00', '1.9', 'MULTI POINT F/INJ', '63.0', 87, 5, '5M', '4D SEDAN', 'RWD', 2725, 'S0012'),
  ('V14883', 'BMW', '3', '18i', 1986, '38600.00', '1.8', 'ELECTRONIC F/INJ', '58.0', 77, 5, '5M', '4D SEDAN', 'RWD', 2570, 'S0003'),
  ('V14884', 'BMW', '3', 'E36 18is SPORT', 1998, '58950.00', '1.9', 'MULTI POINT F/INJ', '62.0', 103, 5, '5M', '2D COUPE', 'RWD', 2700, 'S0004'),
  ('V14885', 'BMW', '7', '35iL EXECUTIVE', 1988, '145900.00', '3.4', 'ELECTRONIC F/INJ', '95.0', 155, 5, '4A', '4D SEDAN', 'RWD', 2945, 'S0020'),
  ('V14887', 'BMW', '5', '25i', 1991, '80200.00', '2.5', 'ELECTRONIC F/INJ', '80.0', 141, 5, '5M', '4D SEDAN', 'RWD', 2761, 'S0007'),
  ('V15130', 'PEUGEOT', '205', 'GTi', 1990, '33750.00', '1.9', 'ELECTRONIC F/INJ', '50.0', 75, 5, '5M', '3D HATCHBACK', 'FWD', 2420, 'S0029'),
  ('V15106', 'VOLVO', 'S40', '2', 1997, '44950.00', '1.9', 'MULTI POINT F/INJ', '60.0', 103, 5, '4A', '4D SEDAN', 'FWD', 2550, 'S0012'),
  ('V15119', 'VOLVO', '4', '40 GLT', 1996, '45500.00', '2.0', 'ELECTRONIC F/INJ', '60.0', 80, 5, '4A', '4D HATCHBACK', 'FWD', 2503, 'S0016'),
  ('V15128', 'NISSAN', '200', 'S15 SX SPEC S', 2001, '40990.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '6M', '2D COUPE', 'RWD', 2525, 'S0014'),
  ('V15129', 'NISSAN', '200', 'SX LUXURY', 1998, '49995.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '5M', '2D COUPE', 'RWD', 2525, 'S0016'),
  ('V15127', 'NISSAN', '200', 'SX SPORTS LIMITED', 1998, '39990.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '5M', '2D COUPE', 'RWD', 2525, 'S0010'),
  ('V15140', 'PEUGEOT', '406', 'D8 ST', 1997, '39995.00', '2.0', 'MULTI POINT F/INJ', '70.0', 100, 5, '5M', '4D SEDAN', 'FWD', 2700, 'S0011'),
  ('V15142', 'PEUGEOT', '405', 'Mi16', 1993, '41995.00', '2.0', 'ELECTRONIC F/INJ', '70.0', 112, 5, '5M', '4D SEDAN', 'FWD', 2669, 'S0028'),
  ('V15143', 'PEUGEOT', '306', 'XT', 2000, '29490.00', '2.0', 'MULTI POINT F/INJ', '60.0', 100, 5, '5M', '5D HATCHBACK', 'FWD', 2580, 'S0023'),
  ('V15144', 'PEUGEOT', '206', 'XT', 2001, '22990.00', '1.6', 'MULTI POINT F/INJ', '50.0', 67, 5, '5M', '5D HATCHBACK', 'FWD', 2442, 'S0024'),
  ('V15146', 'PEUGEOT', '206', 'GTi', 2004, '29990.00', '2.0', 'MULTI POINT F/INJ', '50.0', 102, 5, '5M', '3D HATCHBACK', 'FWD', 2442, 'S0026'),
  ('V15147', 'PEUGEOT', '406', 'D9', 2004, '69550.00', '2.9', 'MULTI POINT F/INJ', '70.0', 157, 4, '5M', '2D COUPE', 'FWD', 2700, 'S0020'),
  ('V15148', 'PEUGEOT', '206', 'CC', 2005, '32990.00', '1.6', 'MULTI POINT F/INJ', '50.0', 80, 4, '5M', '2D CABRIOLET', 'FWD', 2442, 'S0026'),
  ('V15149', 'PEUGEOT', '307', 'XSE', 2003, '31790.00', '2.0', 'MULTI POINT F/INJ', '60.0', 100, 5, '5M', '5D HATCHBACK', 'FWD', 2608, 'S0027'),
  ('V15150', 'PEUGEOT', '206', 'XR', 2002, '19990.00', '1.4', 'MULTI POINT F/INJ', '50.0', 55, 5, '5M', '5D HATCHBACK', 'FWD', 2442, 'S0016'),
  ('V15123', 'NISSAN', '200', 'SX SPORTS LIMITED', 1994, '38500.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '5M', '2D COUPE', 'RWD', 2525, 'S0033'),
  ('V15124', 'NISSAN', '200', 'SX SPORTS', 1996, '44510.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '5M', '2D COUPE', 'RWD', 2525, 'S0004'),
  ('V15122', 'NISSAN', '200', 'S15 SX SPEC S GT', 2002, '42990.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '6M', '2D COUPE', 'RWD', 2525, 'S0038'),
  ('V15165', 'PEUGEOT', '206', 'CC', 2006, '34990.00', '1.6', 'MULTI POINT F/INJ', '50.0', 80, 4, '4ATip', '2D CABRIOLET', 'FWD', 2442, 'S0011'),
  ('V15166', 'PEUGEOT', '307', 'XSE', 2004, '33990.00', '2.0', 'MULTI POINT F/INJ', '60.0', 100, 5, '4ATip', '5D HATCHBACK', 'FWD', 2608, 'S0013'),
  ('V15168', 'PEUGEOT', '206', 'XR', 2004, '19990.00', '1.4', 'MULTI POINT F/INJ', '50.0', 55, 5, '5M', '5D HATCHBACK', 'FWD', 2442, 'S0035'),
  ('V15169', 'PEUGEOT', '307', 'MY06 UPGRADE XSE HDi 2.0 TOURING', 2006, '33990.00', '2.0', 'DIESEL TURBO F/INJ', '60.0', 100, 5, '6M', '4D WAGON', 'FWD', 2708, 'S0009'),
  ('V15161', 'PEUGEOT', '307', 'MY06 UPGRADE XSE HDi 2.0', 2006, '32290.00', '2.0', 'DIESEL TURBO F/INJ', '60.0', 100, 5, '6M', '5D HATCHBACK', 'FWD', 2608, 'S0018'),
  ('V15162', 'PEUGEOT', '206', 'XT', 2000, '22450.00', '1.6', 'MULTI POINT F/INJ', '50.0', 67, 5, '5M', '5D HATCHBACK', 'FWD', 2442, 'S0012'),
  ('V15167', 'PEUGEOT', '206', 'C', 2006, '22990.00', '1.6', 'MULTI POINT F/INJ', '50.0', 82, 5, '5M', '5D HATCHBACK', 'FWD', 2442, 'S0014'),
  ('V15163', 'PEUGEOT', '307', 'MY06 UPGRADE SPORT 2.0', 2005, '37990.00', '2.0', 'MULTI POINT F/INJ', '60.0', 130, 5, '5M', '5D HATCHBACK', 'FWD', 2608, 'S0029'),
  ('V15160', 'PEUGEOT', '405', 'D60 SRI', 1992, '34995.00', '1.9', 'ELECTRONIC F/INJ', '70.0', 80, 5, '5M', '4D SEDAN', 'FWD', 2669, 'S0011'),
  ('V15181', 'PEUGEOT', '206', 'XR', 2003, '21990.00', '1.6', 'MULTI POINT F/INJ', '50.0', 82, 5, '5M', '3D HATCHBACK', 'FWD', 2442, 'S0031'),
  ('V15186', 'EUNOS', '30', 'X SPORT', 1996, '37155.00', '1.8', 'ELECTRONIC F/INJ', '50.0', 99, 4, '5M', '2D COUPE', 'FWD', 2455, 'S0012'),
  ('V15184', 'EUNOS', '800', 'M', 1996, '85165.00', '2.3', 'MILLER CYCLE', '68.0', 149, 5, '4A', '4D SEDAN', 'FWD', 2750, 'S0015'),
  ('V15209', 'CHRYSLER', 'NEON', 'SE', 1997, '24880.00', '2.0', 'ELECTRONIC F/INJ', '47.0', 98, 5, '3A', '4D SEDAN', 'FWD', 2642, 'S0009'),
  ('V15201', 'CHRYSLER', 'VOYAGER', 'RG SE', 2002, '52590.00', '3.3', 'MULTI POINT F/INJ', '75.0', 128, 7, '4A', '4D WAGON', 'FWD', 2787, 'S0001'),
  ('V15202', 'CHRYSLER', 'CROSSFIRE', 'ZH ROADSTER', 2005, '75990.00', '3.2', 'MULTI POINT F/INJ', '60.0', 160, 2, '5ASeq', '2D CONVERTIBLE', 'RWD', 2400, 'S0014'),
  ('V15203', 'CHRYSLER', 'VOYAGER', 'GS SE', 1999, '48200.00', '3.3', 'MULTI POINT F/INJ', '76.0', 116, 7, '4A', '4D WAGON', 'FWD', 2878, 'S0003'),
  ('V15204', 'CHRYSLER', 'PT CRUISER', 'MY06 CLASSIC', 2005, '31990.00', '2.4', 'MULTI POINT F/INJ', '57.0', 105, 5, '4A', '5D HATCHBACK', 'FWD', 2616, 'S0015'),
  ('V15205', 'CHRYSLER', 'PT CRUISER', 'CLASSIC', 2001, '35200.00', '2.0', 'MULTI POINT F/INJ', '57.0', 104, 5, '5M', '5D HATCHBACK', 'FWD', 2616, 'S0034'),
  ('V15207', 'CHRYSLER', '300C', 'LE MY06 SRT8', 2006, '71990.00', '6.1', 'MULTI POINT F/INJ', '71.0', 317, 5, '5A', '4D SEDAN', 'RWD', 3050, 'S0014'),
  ('V15208', 'CHRYSLER', 'GRAND VOYAGER', 'RG SE', 2004, '59090.00', '3.3', 'MULTI POINT F/INJ', '75.0', 128, 7, '4A', '4D WAGON', 'FWD', 3030, 'S0019'),
  ('V15210', 'CHRYSLER', 'PT CRUISER', 'CLASSIC', 2004, '32490.00', '2.0', 'MULTI POINT F/INJ', '57.0', 104, 5, '4A', '5D HATCHBACK', 'FWD', 2616, 'S0029'),
  ('V15200', 'CHRYSLER', '300C', 'LE MY06 CRD', 2006, '57990.00', '3.0', 'DIESEL TURBO F/INJ', '71.0', 160, 5, '5A', '4D SEDAN', 'RWD', 3050, 'S0017'),
  ('V15199', 'CHRYSLER', 'VALIANT', 'CM GLX', 1979, '8014.00', '4.3', 'CARB', '79.0', 120, 5, '3A', '4D SEDAN', 'RWD', 2820, 'S0018'),
  ('V15220', 'CHRYSLER', 'VOYAGER', 'RG 05 UPGRADE LX', 2004, '62980.00', '3.3', 'MULTI POINT F/INJ', '75.0', 128, 7, '4A', '4D WAGON', 'FWD', 3030, 'S0011'),
  ('V15221', 'CHRYSLER', 'PT CRUISER', 'LIMITED', 2004, '38490.00', '2.0', 'MULTI POINT F/INJ', '57.0', 104, 5, '4A', '5D HATCHBACK', 'FWD', 2616, 'S0021'),
  ('V15222', 'CHRYSLER', 'VOYAGER', 'GS SE', 2001, '46900.00', '3.3', 'MULTI POINT F/INJ', '76.0', 116, 7, '4A', '4D WAGON', 'FWD', 2878, 'S0020'),
  ('V15223', 'MAZDA', '323', 'PROTEGE', 1999, '20990.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0012'),
  ('V15224', 'MAZDA', '323', 'ASTINA', 1997, '35700.00', '2.0', 'MULTI POINT F/INJ', '55.0', 104, 5, '5M', '5D HATCHBACK', 'FWD', 2605, 'S0014'),
  ('V15225', 'MAZDA', '323', 'ASTINA SHADES', 2001, '20490.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '5D HATCHBACK', 'FWD', 2605, 'S0026'),
  ('V15226', 'MAZDA', '323', 'DELUXE', 1983, '8835.00', '1.5', 'CARB', '45.0', 54, 4, '5M', '4D WAGON', 'RWD', 2315, 'S0024'),
  ('V15227', 'MAZDA', '323', 'PROTEGE SHADES', 2000, '19715.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0025'),
  ('V15228', 'MAZDA', '323', 'PROTEGE', 1997, '22915.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '4D SEDAN', 'FWD', 2605, 'S0028'),
  ('V15229', 'MAZDA', '323', 'ASTINA', 1995, '31050.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '4A', '5D HATCHBACK', 'FWD', 2605, 'S0024'),
  ('V15230', 'MAZDA', '323', 'PROTEGE', 1998, '22915.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '4D SEDAN', 'FWD', 2605, 'S0030'),
  ('V15241', 'MAZDA', '323', 'ASTINA', 1993, '25715.00', '1.8', 'MULTI POINT F/INJ', '55.0', 76, 5, '5M', '5D HATCHBACK', 'FWD', 2500, 'S0001'),
  ('V15242', 'MAZDA', '323', 'ASTINA SHADES', 2000, '19715.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '5D HATCHBACK', 'FWD', 2605, 'S0014'),
  ('V15243', 'MAZDA', '323', 'ASTINA', 1996, '38270.00', '2.0', 'MULTI POINT F/INJ', '55.0', 104, 5, '5M', '5D HATCHBACK', 'FWD', 2605, 'S0015'),
  ('V15244', 'MAZDA', '323', 'ASTINA', 1998, '28480.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '4A', '5D HATCHBACK', 'FWD', 2605, 'S0022'),
  ('V15245', 'MAZDA', '323', 'SUPER DELUXE', 1989, '20210.00', '1.6', 'MULTI POINT F/INJ', '48.0', 61, 5, '4A', '5D HATCHBACK', 'FWD', 2400, 'S0027'),
  ('V15246', 'MAZDA', '323', 'PROTEGE', 2003, '21840.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '4A', '4D SEDAN', 'FWD', 2610, 'S0006'),
  ('V15247', 'MAZDA', '323', 'ASTINA', 2003, '21840.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '4A', '5D HATCHBACK', 'FWD', 2610, 'S0019'),
  ('V15248', 'MAZDA', '323', 'SUPER DELUXE', 1988, '19390.00', '1.6', 'CARB', '48.0', 53, 5, '3A', '5D HATCHBACK', 'FWD', 2400, 'S0010'),
  ('V15249', 'MAZDA', '323', 'ASTINA SHADES', 1998, '26990.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '5D HATCHBACK', 'FWD', 2605, 'S0017'),
  ('V15250', 'MAZDA', '323', 'ASTINA SP', 1994, '30085.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '5D HATCHBACK', 'FWD', 2500, 'S0010'),
  ('V15240', 'MAZDA', '323', 'PROTEGE', 2000, '19715.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0018'),
  ('V15261', 'MAZDA', '323', 'PROTEGE SHADES', 2002, '20695.00', '1.6', 'MULTI POINT F/INJ', '55.0', 78, 5, '5M', '4D SEDAN', 'FWD', 2605, 'S0018'),
  ('V15280', 'MITSUBISHI', '380', 'DB', 2005, '35990.00', '3.8', 'MULTI POINT F/INJ', '67.0', 175, 5, '5ASPM', '4D SEDAN', 'FWD', 2750, 'S0003'),
  ('V15263', 'MAZDA', '323', 'BJ PROTEGE SHADES', 2003, '19990.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0021'),
  ('V15264', 'MAZDA', '323', 'PROTEGE SP20', 2002, '26990.00', '2.0', 'MULTI POINT F/INJ', '55.0', 98, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0025'),
  ('V15282', 'TOYOTA', '4 RUNNER', 'DELUXE 4x4', 1989, '28200.00', '2.4', 'CARB', '65.0', 75, 5, '5M4x4', '4D WAGON', '4WD', 2625, 'S0018'),
  ('V15284', 'TOYOTA', '4 RUNNER', 'RV6 4x4', 1992, '36954.00', '3.0', 'ELECTRONIC F/INJ', '65.0', 105, 5, '4A4x4', '4D WAGON', '4WD', 2625, 'S0013'),
  ('V15260', 'MAZDA', '323', 'ASTINA SP20', 2002, '29180.00', '2.0', 'MULTI POINT F/INJ', '55.0', 98, 5, '5M', '5D HATCHBACK', 'FWD', 2610, 'S0018'),
  ('V15259', 'MAZDA', '323', 'LIMITED', 1985, '15826.00', '1.6', 'MULTI POINT F/INJ', '45.0', 61, 5, '5M', '5D HATCHBACK', 'FWD', 2400, 'S0019'),
  ('V15300', 'MAZDA', '626', 'ECLIPSE', 2002, '31980.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '4A', '4D SEDAN', 'FWD', 2610, 'S0018'),
  ('V15301', 'MAZDA', '626', 'LUXURY', 1999, '37290.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '4A', '5D HATCHBACK', 'FWD', 2610, 'S0014'),
  ('V15302', 'MAZDA', '626', 'DELUXE', 1994, '31335.00', '2.0', 'MULTI POINT F/INJ', '60.0', 85, 5, '4A', '4D SEDAN', 'FWD', 2610, 'S0018'),
  ('V15303', 'MAZDA', '626', 'CLASSIC', 1998, '30180.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0008'),
  ('V15304', 'MAZDA', '626', 'CLASSIC', 1999, '32430.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '4A', '4D SEDAN', 'FWD', 2610, 'S0013'),
  ('V15305', 'MAZDA', '626', 'CLASSIC', 2001, '32900.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '4A', '5D HATCHBACK', 'FWD', 2610, 'S0026'),
  ('V15306', 'MAZDA', '626', 'LIMITED EDITION', 2000, '30160.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '5M', '4D SEDAN', 'FWD', 2610, 'S0026'),
  ('V15307', 'AUDI', 'A4', 'B6 2.0', 2002, '50650.00', '2.0', 'MULTI POINT F/INJ', '70.0', 96, 5, 'CVTM', '4D SEDAN', 'FWD', 2650, 'S0016'),
  ('V15308', 'AUDI', 'A3', '8P SPORTBACK 2.0 TDI AMBITION DSG', 2005, '47750.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6ADSG', '5D HATCHBACK', 'FWD', 2578, 'S0028'),
  ('V15309', 'AUDI', '90', 'SPORT', 1990, '42245.00', '2.3', 'ELECTRONIC F/INJ', '68.0', 100, 5, '5M', '4D SEDAN', 'FWD', 2546, 'S0029'),
  ('V15310', 'AUDI', 'A4', 'B7 2.0', 2007, '50450.00', '2.0', 'MULTI POINT F/INJ', '70.0', 96, 5, 'CVTM', '4D SEDAN', 'FWD', 2648, 'S0011'),
  ('V15297', 'MAZDA', '626', 'CLASSIC', 2000, '31070.00', '2.0', 'MULTI POINT F/INJ', '64.0', 93, 5, '5M', '5D HATCHBACK', 'FWD', 2610, 'S0015'),
  ('V15327', 'AUDI', 'A3', '1.8 TURBO', 2004, '44950.00', '1.8', 'TURBO MPFI', '55.0', 110, 5, '5M', '5D HATCHBACK', 'FWD', 2512, 'S0007'),
  ('V15321', 'AUDI', 'A4', 'B6 2.0 AVANT', 2003, '54250.00', '2.0', 'MULTI POINT F/INJ', '70.0', 96, 5, 'CVTM6', '4D WAGON', 'FWD', 2650, 'S0018'),
  ('V15322', 'AUDI', 'ALLROAD QUATTRO', 'C5', 2001, '99250.00', '2.7', 'TWIN TURBO MPFI', '70.0', 184, 5, '5ATip', '4D WAGON', 'AWD', 2760, 'S0011'),
  ('V15323', 'AUDI', 'A3', '1.6', 2003, '35400.00', '1.6', 'MULTI POINT F/INJ', '55.0', 75, 5, '5M', '5D HATCHBACK', 'FWD', 2512, 'S0016'),
  ('V15324', 'AUDI', 'S3', '1.8', 2000, '65850.00', '1.8', 'TURBO MPFI', '62.0', 154, 5, '6M', '3D HATCHBACK', 'AWD', 2519, 'S0013'),
  ('V15325', 'AUDI', 'A3', '8P SPORTBACK 2.0 TDI AMBITION DSG', 2006, '47750.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6ADSG', '5D HATCHBACK', 'FWD', 2578, 'S0015'),
  ('V15326', 'AUDI', 'A3', '1.8', 1999, '42450.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '4A', '3D HATCHBACK', 'FWD', 2512, 'S0040'),
  ('V15328', 'AUDI', 'TT', 'QUATTRO', 2004, '92500.00', '1.8', 'TURBO MPFI', '62.0', 165, 2, '6M', '2D ROADSTER', 'AWD', 2429, 'S0018'),
  ('V15329', 'AUDI', 'A3', '1.8', 2002, '38700.00', '1.8', 'MULTI POINT F/INJ', '55.0', 92, 5, '5M', '5D HATCHBACK', 'FWD', 2512, 'S0019'),
  ('V15330', 'AUDI', 'A6', '4B 2.4 V6', 2003, '80900.00', '2.4', 'MULTI POINT F/INJ', '70.0', 125, 5, 'CVTM6', '4D SEDAN', 'FWD', 2749, 'S0010'),
  ('V15317', 'AUDI', 'A4', '1.8 SE 20V', 1996, '51320.00', '1.8', 'MULTI POINT F/INJ', '60.0', 92, 5, '4A', '4D SEDAN', 'FWD', 2617, 'S0017'),
  ('V15340', 'SAAB', '09-Mar', 'MY07 LINEAR SPORT 1.9TiD SPORTCOMBI', 2007, '53400.00', '1.9', 'TURBO MPFI', '58.0', 110, 5, '5A', '4D WAGON', 'FWD', 2675, 'S0016'),
  ('V15341', 'SAAB', '09-May', 'SE', 2000, '67986.00', '2.3', 'TURBO MPFI', '75.0', 125, 5, '4A', '4D SEDAN', 'FWD', 2703, 'S0021'),
  ('V15342', 'SAAB', '09-Mar', 'MY04 ARC 2.0T', 2004, '56400.00', '2.0', 'TURBO MPFI', '62.0', 129, 5, '5A', '4D SEDAN', 'FWD', 2675, 'S0026'),
  ('V15343', 'SAAB', '09-Mar', 'MY02 AERO', 2002, '64575.00', '2.0', 'TURBO MPFI', '68.0', 151, 5, '4A', '5D HATCHBACK', 'FWD', 2605, 'S0009'),
  ('V15344', 'SAAB', '09-May', 'MY04 AERO', 2004, '84900.00', '2.3', 'TURBO MPFI', '75.0', 184, 5, '5AST', '4D SEDAN', 'FWD', 2703, 'S0024'),
  ('V15345', 'SAAB', '900', 'SE 2.5 V6', 1996, '63900.00', '2.5', 'MULTI POINT F/INJ', '68.0', 125, 5, '4A', '5D HATCHBACK', 'FWD', 2600, 'S0011'),
  ('V15346', 'SAAB', '09-Mar', 'MY03 TURBO 2.0t LTD ED', 2003, '73000.00', '2.0', 'TURBO MPFI', '68.0', 110, 5, '4A', '2D CONVERTIBLE', 'FWD', 2605, 'S0011'),
  ('V15347', 'SAAB', '9000', 'CS ANNIVERSARY', 1998, '54900.00', '2.3', 'TURBO EFI', '66.0', 125, 5, '4A', '4D HATCHBACK', 'FWD', 2672, 'S0013'),
  ('V15348', 'SAAB', '900', 'S 2.5 V6', 1994, '45900.00', '2.5', 'MULTI POINT F/INJ', '68.0', 125, 5, '5M', '5D HATCHBACK', 'FWD', 2600, 'S0028'),
  ('V15349', 'SAAB', '09-May', 'MY01 S', 2001, '64000.00', '2.3', 'TURBO MPFI', '75.0', 136, 5, '4A', '4D SEDAN', 'FWD', 2703, 'S0029'),
  ('V15350', 'SAAB', '09-Mar', 'MY05 AERO', 2005, '93000.00', '2.0', 'TURBO MPFI', '62.0', 155, 4, '5ASEN', '2D CONVERTIBLE', 'FWD', 2675, 'S0030'),
  ('V15367', 'SAAB', '9000', 'CD 16', 1993, '46990.00', '2.3', 'ELECTRONIC F/INJ', '66.0', 108, 5, '4A', '4D SEDAN', 'FWD', 2672, 'S0022'),
  ('V15316', 'AUDI', 'TT', 'MY99', 1999, '73000.00', '1.8', 'TURBO MPFI', '55.0', 132, 4, '5M', '2D COUPE', 'FWD', 2419, 'S0023'),
  ('V15369', 'MAZDA', '929', 'LUXURY', 1986, '29600.00', '2.0', 'MULTI POINT F/INJ', '60.0', 70, 5, '4A', '2D HARDTOP', 'RWD', 2615, 'S0013'),
  ('V15361', 'SAAB', '09-Mar', 'S', 2001, '63885.00', '2.0', 'TURBO MPFI', '68.0', 113, 4, '5M', '2D CONVERTIBLE', 'FWD', 2605, 'S0010'),
  ('V15366', 'SAAB', '09-Mar', 'SE', 1999, '62000.00', '2.0', 'TURBO MPFI', '68.0', 136, 5, '4A', '5D SEDAN', 'FWD', 2605, 'S0012'),
  ('V15363', 'SAAB', '9000', 'CS', 1997, '52000.00', '2.3', 'TURBO EFI', '66.0', 125, 5, '4A', '4D HATCHBACK', 'FWD', 2672, 'S0017'),
  ('V15364', 'SAAB', '9000', 'CS', 1996, '50400.00', '2.3', 'TURBO EFI', '66.0', 125, 5, '4A', '4D HATCHBACK', 'FWD', 2672, 'S0025'),
  ('V15368', 'MAZDA', '929', 'DELUXE', 1987, '23010.00', '2.0', 'MULTI POINT F/INJ', '60.0', 70, 5, '5M', '4D SEDAN', 'RWD', 2615, 'S0010'),
  ('V15360', 'SAAB', '09-Mar', 'AERO', 2000, '80887.00', '2.0', 'TURBO MPFI', '64.0', 158, 5, '5M', '2D CONVERTIBLE', 'FWD', 2605, 'S0035'),
  ('V15362', 'SAAB', '09-Mar', 'MY04 AERO 2.0t', 2004, '67900.00', '2.0', 'TURBO MPFI', '62.0', 155, 5, '6M', '4D SEDAN', 'FWD', 2675, 'S0017'),
  ('V15365', 'SAAB', '09-Mar', 'S', 2000, '65985.00', '2.0', 'TURBO MPFI', '68.0', 113, 4, '4A', '2D CONVERTIBLE', 'FWD', 2605, 'S0037'),
  ('V15357', 'SAAB', '9000', 'CSE', 1994, '79200.00', '2.3', 'TURBO EFI', '66.0', 147, 5, '4A', '4D HATCHBACK', 'FWD', 2672, 'S0021'),
  ('V15400', 'HONDA', 'ACCORD', '40 VTi', 2005, '29990.00', '2.4', 'MULTI POINT F/INJ', '65.0', 118, 5, '5A', '4D SEDAN', 'FWD', 2740, 'S0040'),
  ('V14888', 'BMW', '3', 'E46 25Ci', 2002, '75000.00', '2.5', 'MULTI POINT F/INJ', '63.0', 141, 5, '5AS', '2D COUPE', 'RWD', 2725, 'S0023'),
  ('V14889', 'BMW', '3', 'E46 16ti', 2005, '40350.00', '1.8', 'MULTI POINT F/INJ', '63.0', 85, 5, '5M', '3D HATCHBACK', 'RWD', 2725, 'S0021'),
  ('V14890', 'BMW', 'X5', 'E53 3.0d', 2005, '84300.00', '3.0', 'TURBO CDI', '93.0', 150, 5, '6A', '4D WAGON', '4WD', 2820, 'S0020'),
  ('V14891', 'DATSUN', 'FAIRLADY', 'SPORTS', 1964, '2530.00', '1.5', 'CARB', '43.0', 63, 0, '4M', '2D ROADSTER', 'RWD', 2280, 'S0010'),
  ('V14895', 'DATSUN', '180B', 'SSS', 1977, '6012.00', '1.8', 'CARB', '55.0', 82, 5, '5M', '2D HARDTOP', 'RWD', 2500, 'S0025'),
  ('V14896', 'MAZDA', '121', 'METRO SHADES', 2001, '19050.00', '1.5', 'ELECTRONIC F/INJ', '43.0', 64, 5, '5M', '5D HATCHBACK', 'FWD', 2390, 'S0026'),
  ('V14897', 'MAZDA', '121', 'SHADES', 1997, '14200.00', '1.3', 'SINGLE POINT F/INJ', '40.0', 54, 5, '5M', '4D SEDAN', 'FWD', 2390, 'S0014'),
  ('V14899', 'MAZDA', '121', 'METRO SHADES', 2002, '19240.00', '1.5', 'ELECTRONIC F/INJ', '43.0', 64, 5, '5M', '5D HATCHBACK', 'FWD', 2390, 'S0014'),
  ('V14900', 'MAZDA', '121', 'DELUXE', 1987, '12250.00', '1.3', 'CARB', '38.0', 46, 5, '5M', '3D HATCHBACK', 'FWD', 2295, 'S0020'),
  ('V14901', 'MAZDA', '121', 'METRO SHADES', 1999, '19590.00', '1.5', 'ELECTRONIC F/INJ', '40.0', 64, 5, '4A', '5D HATCHBACK', 'FWD', 2390, 'S0021'),
  ('V14902', 'VOLKSWAGEN', 'TRANSPORTER', 'T5 MY08 CREWVAN SWB', 2008, '42990.00', '2.5', 'DIESEL TURBO F/INJ', '80.0', 96, 5, '6ATip', 'VAN', 'FWD', 3000, 'S0022'),
  ('V14903', 'VOLKSWAGEN', 'JETTA', '1KM 2.0 TDI', 2006, '35490.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6M', '4D SEDAN', 'FWD', 2578, 'S0010'),
  ('V14904', 'VOLKSWAGEN', 'TRANSPORTER', 'T5 SWB', 2005, '43400.00', '2.5', 'DIESEL TURBO F/INJ', '80.0', 96, 2, '6ATip', 'VAN', 'FWD', 3000, 'S0024'),
  ('V14905', 'VOLKSWAGEN', 'POLO', '9N MY07 UPGRADE CLUB', 2007, '16990.00', '1.4', 'MULTI POINT F/INJ', '45.0', 59, 5, '5M', '3D HATCHBACK', 'FWD', 2465, 'S0025'),
  ('V14906', 'VOLKSWAGEN', 'JETTA', '1KM 2.0 TURBO FSI', 2006, '39990.00', '2.0', 'TURBO MPFI', '55.0', 147, 5, '6ADSG', '4D SEDAN', 'FWD', 2578, 'S0010'),
  ('V14907', 'VOLKSWAGEN', 'MULTIVAN', 'T5 HIGHLINE', 2006, '72990.00', '2.5', 'DIESEL TURBO F/INJ', '80.0', 128, 7, '6ATip', '4D VAN', 'FWD', 3000, 'S0027'),
  ('V14908', 'VOLKSWAGEN', 'JETTA', '1KM 2.0 TURBO FSI', 2007, '39990.00', '2.0', 'TURBO MPFI', '55.0', 147, 5, '6ADSG', '4D SEDAN', 'FWD', 2578, 'S0020'),
  ('V14909', 'VOLKSWAGEN', 'GOLF', '1K GTi', 2007, '39990.00', '2.0', 'TURBO MPFI', '55.0', 147, 5, '6M', '5D HATCHBACK', 'FWD', 2578, 'S0015'),
  ('V14910', 'VOLKSWAGEN', 'GOLF', 'GL', 2001, '25990.00', '1.6', 'MULTI POINT F/INJ', '55.0', 74, 5, '5M', '5D HATCHBACK', 'FWD', 2511, 'S0025'),
  ('V14911', 'VOLKSWAGEN', 'GOLF', '1K 1.9 TDI COMFORTLINE', 2005, '32290.00', '1.9', 'DIESEL TURBO F/INJ', '55.0', 77, 5, '6ADSG', '5D HATCHBACK', 'FWD', 2578, 'S0021'),
  ('V14912', 'VOLKSWAGEN', 'JETTA', '1KM 2.0 FSI', 2007, '35290.00', '2.0', 'MULTI POINT F/INJ', '55.0', 110, 5, '6ATip', '4D SEDAN', 'FWD', 2578, 'S0010'),
  ('V14914', 'VOLKSWAGEN', 'GOLF', '1K GT', 2007, '37290.00', '1.4', 'S/C & T/C MPFI', '55.0', 125, 5, '6ADSG', '5D HATCHBACK', 'FWD', 2578, 'S0026'),
  ('V14915', 'VOLKSWAGEN', 'GOLF', 'GL', 1995, '30490.00', '2.0', 'MULTI POINT F/INJ', '55.0', 85, 5, '5M', '5D HATCHBACK', 'FWD', 2475, 'S0035'),
  ('V14920', 'VOLKSWAGEN', 'JETTA', '1KM 2.0 TDI', 2007, '37990.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6ADSG', '4D SEDAN', 'FWD', 2578, 'S0013'),
  ('V14921', 'VOLKSWAGEN', 'GOLF', '1K 2.0 FSI COMFORTLINE', 2005, '32290.00', '2.0', 'ELECTRONIC F/INJ', '55.0', 110, 5, '6ATip', '5D HATCHBACK', 'FWD', 2578, 'S0001'),
  ('V14922', 'VOLKSWAGEN', 'GOLF', '1K 2.0 TDI COMFORTLINE', 2007, '32490.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6M', '5D HATCHBACK', 'FWD', 2578, 'S0002'),
  ('V14923', 'VOLKSWAGEN', 'PASSAT', '3B 1.8T', 2002, '49800.00', '1.8', 'TURBO MPFI', '62.0', 110, 5, '5ATip', '4D WAGON', 'FWD', 2703, 'S0009'),
  ('V14924', 'VOLKSWAGEN', 'GOLF', '1K 2.0 FSI SPORTLINE', 2006, '32990.00', '2.0', 'ELECTRONIC F/INJ', '55.0', 110, 5, '6M', '5D HATCHBACK', 'FWD', 2578, 'S0010'),
  ('V14925', 'VOLKSWAGEN', 'GOLF', 'GLE', 1999, '34990.00', '2.0', 'MULTI POINT F/INJ', '55.0', 85, 5, '5M', '5D HATCHBACK', 'FWD', 2511, 'S0005'),
  ('V14926', 'VOLKSWAGEN', 'GOLF', 'GL', 1998, '31980.00', '1.6', 'MULTI POINT F/INJ', '55.0', 74, 5, '4A', '5D HATCHBACK', 'FWD', 2511, 'S0020'),
  ('V14927', 'VOLKSWAGEN', 'MULTIVAN', 'T5 COMFORTLINE 4MOTION', 2006, '60990.00', '2.5', 'DIESEL TURBO F/INJ', '80.0', 128, 7, '6M', '4D VAN', '4WD', 3000, 'S0024'),
  ('V14928', 'VOLKSWAGEN', 'POLO', '9N S', 2002, '21800.00', '1.4', 'MULTI POINT F/INJ', '45.0', 55, 5, '5M', '5D HATCHBACK', 'FWD', 2460, 'S0008'),
  ('V14929', 'VOLKSWAGEN', 'TOUAREG', '7L R5 TDi LUXURY', 2006, '78600.00', '2.5', 'DIESEL TURBO F/INJ', '100.0', 128, 5, '6ATip', '4D WAGON', '4WD', 2855, 'S0025'),
  ('V14930', 'VOLKSWAGEN', 'CADDY', '2K LIFE', 2006, '34990.00', '1.9', 'DIESEL TURBO F/INJ', '60.0', 77, 5, '6ADSG', '4D WAGON', 'FWD', 2682, 'S0010'),
  ('V14940', 'VOLKSWAGEN', 'GOLF', '1K 2.0 TDI COMFORTLINE', 2004, '32490.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6M', '5D HATCHBACK', 'FWD', 2578, 'S0020'),
  ('V14941', 'VOLKSWAGEN', 'BORA', '1J 2.0', 2001, '36350.00', '2.0', 'MULTI POINT F/INJ', '55.0', 85, 5, '5M', '4D SEDAN', 'FWD', 2500, 'S0012'),
  ('V14942', 'VOLKSWAGEN', 'POLO', '9N MY06 UPGRADE CLUB', 2006, '16990.00', '1.4', 'MULTI POINT F/INJ', '45.0', 55, 5, '5M', '3D HATCHBACK', 'FWD', 2465, 'S0018'),
  ('V14943', 'VOLKSWAGEN', 'CADDY', '2K 1.9 TDi', 2006, '24990.00', '1.9', 'DIESEL TURBO F/INJ', '60.0', 77, 2, '5M', 'VAN', 'FWD', 2682, 'S0012'),
  ('V14944', 'VOLKSWAGEN', 'POLO', '9N', 2003, '19800.00', '1.4', 'MULTI POINT F/INJ', '45.0', 55, 5, '5M', '3D HATCHBACK', 'FWD', 2460, 'S0014'),
  ('V14945', 'VOLKSWAGEN', 'GOLF', '1.6 GENERATION', 2004, '25990.00', '1.6', 'MULTI POINT F/INJ', '55.0', 75, 5, '5M', '5D HATCHBACK', 'FWD', 2511, 'S0025'),
  ('V14946', 'VOLKSWAGEN', 'POLO', '9N MY07 UPGRADE GTi', 2007, '26990.00', '1.8', 'TURBO MPFI', '45.0', 110, 5, '5M', '3D HATCHBACK', 'FWD', 2466, 'S0026'),
  ('V14947', 'VOLKSWAGEN', 'GOLF', 'GL', 1999, '31190.00', '1.6', 'MULTI POINT F/INJ', '55.0', 74, 5, '4A', '5D HATCHBACK', 'FWD', 2511, 'S0010'),
  ('V14948', 'VOLKSWAGEN', 'GOLF', '1K 2.0 TDI COMFORTLINE', 2006, '34790.00', '2.0', 'DIESEL TURBO F/INJ', '55.0', 103, 5, '6ADSG', '5D HATCHBACK', 'FWD', 2578, 'S0011'),
  ('V14949', 'VOLKSWAGEN', 'GOLF', 'GL', 2000, '25990.00', '1.6', 'MULTI POINT F/INJ', '55.0', 74, 5, '5M', '5D HATCHBACK', 'FWD', 2511, 'S0026'),
  ('V14950', 'VOLKSWAGEN', 'GOLF', '1K 1.6 TRENDLINE', 2005, '25490.00', '1.6', 'MULTI POINT F/INJ', '55.0', 75, 5, '5M', '5D HATCHBACK', 'FWD', 2578, 'S0030'),
  ('V14967', 'VOLKSWAGEN', 'POLO', 'OPEN AIR', 1999, '21490.00', '1.6', 'MULTI POINT F/INJ', '45.0', 55, 5, '5M', '5D HATCHBACK', 'FWD', 2400, 'S0026'),
  ('V14960', 'VOLKSWAGEN', 'PASSAT', '3C 2.0T FSI', 2006, '44990.00', '2.0', 'TURBO MPFI', '70.0', 147, 5, '6ATip', '4D SEDAN', 'FWD', 2709, 'S0015'),
  ('V14961', 'VOLKSWAGEN', 'TOUAREG', '7L R5 TDi LUXURY', 2005, '78600.00', '2.5', 'DIESEL TURBO F/INJ', '100.0', 128, 5, '6ATip', '4D WAGON', '4WD', 2855, 'S0009'),
  ('V14962', 'VOLKSWAGEN', 'PASSAT', '3C 3.2 V6 FSI', 2006, '54990.00', '3.2', 'MULTI POINT F/INJ', '70.0', 184, 5, '6ADSG', '4D SEDAN', 'AWD', 2709, 'S0014'),
  ('V14964', 'VOLKSWAGEN', 'GOLF', '2.0 S', 2002, '29490.00', '2.0', 'MULTI POINT F/INJ', '55.0', 85, 5, '5M', '5D HATCHBACK', 'FWD', 2511, 'S0009'),
  ('V14969', 'VOLKSWAGEN', '1600', 'SUPER BUG L', 1975, '3798.00', '1.6', 'CARB', '42.0', 37, 4, '4M', '2D SEDAN', 'RWD', 2420, 'S0025'),
  ('V14966', 'VOLKSWAGEN', 'GOLF', '2.0 GENERATION', 2004, '29490.00', '2.0', 'MULTI POINT F/INJ', '55.0', 85, 5, '4A', '5D HATCHBACK', 'FWD', 2511, 'S0021'),
  ('V14965', 'VOLKSWAGEN', 'CARAVELLE', 'V6', 2003, '59990.00', '2.8', 'MULTI POINT F/INJ', '80.0', 150, 8, '4A', '4D WAGON', 'FWD', 2920, 'S0015'),
  ('V14985', 'ALFA ROMEO', '156', 'V6 24V', 2002, '57500.00', '2.5', 'MULTI POINT F/INJ', '63.0', 140, 5, '6M', '4D SEDAN', 'FWD', 2595, 'S0011'),
  ('V14984', 'ALFA ROMEO', 'GTV', '2', 1999, '61990.00', '2.0', 'MULTI POINT F/INJ', '70.0', 114, 4, '5M', '2D COUPE', 'FWD', 2540, 'S0015'),
  ('V15004', 'MERCEDES-BENZ', 'ML', 'W163 270 CDI 4x4', 2002, '69474.00', '2.7', 'TURBO CDI', '83.0', 120, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0004'),
  ('V15001', 'ALFA ROMEO', '156', '2.0 SELESPEED TWIN SPARK', 1999, '49950.00', '2.0', 'MULTI POINT F/INJ', '63.0', 114, 5, '5MSel', '4D SEDAN', 'FWD', 2595, 'S0018'),
  ('V15002', 'ALFA ROMEO', '147', '2.0 TWIN SPARK', 2003, '39500.00', '2.0', 'MULTI POINT F/INJ', '60.0', 110, 5, '5M', '5D HATCHBACK', 'FWD', 2546, 'S0011'),
  ('V15003', 'MERCEDES-BENZ', 'SLK', 'R171 200K', 2004, '86900.00', '1.8', 'SUPERCHARGED MPFI', '70.0', 120, 2, '5ATS', '2D CONVERTIBLE', 'RWD', 2430, 'S0012'),
  ('V15005', 'MERCEDES-BENZ', 'ML', 'W163 320 LUXURY 4x4', 2002, '77274.00', '3.2', 'MULTI POINT F/INJ', '83.0', 160, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0011'),
  ('V15006', 'MERCEDES-BENZ', 'C180', 'W203 KOMPRESSOR AVANTGARDE', 2002, '61400.00', '1.8', 'SUPERCHARGED MPFI', '70.0', 105, 5, '5ATS', '4D SEDAN', 'RWD', 2715, 'S0009'),
  ('V15007', 'MERCEDES-BENZ', 'ML', '320 LUXURY 4x4', 2000, '72900.00', '3.2', 'MULTI POINT F/INJ', '70.0', 160, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0007'),
  ('V15008', 'MERCEDES-BENZ', 'SLK230', 'KOMPRESSOR', 2000, '95380.00', '2.3', 'SUPERCHARGED MPFI', '53.0', 142, 2, '5A', '2D CONVERTIBLE', 'RWD', 2400, 'S0038'),
  ('V15009', 'MERCEDES-BENZ', 'ML', 'W163 500 LUXURY 4x4', 2004, '99900.00', '5.0', 'MULTI POINT F/INJ', '83.0', 215, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0016'),
  ('V15010', 'MERCEDES-BENZ', '300', 'TE', 1991, '124500.00', '3.0', 'ELECTRONIC F/INJ', '70.0', 135, 7, '4A', '4D WAGON', 'RWD', 2800, 'S0010'),
  ('V15000', 'ALFA ROMEO', '147', 'GTA MONZA', 2005, '59990.00', '3.2', 'MULTI POINT F/INJ', '63.0', 184, 5, '6M', '3D HATCHBACK', 'FWD', 2546, 'S0017'),
  ('V15020', 'MERCEDES-BENZ', '280', 'W126 SE', 1982, '55979.00', '2.7', 'ELECTRONIC F/INJ', '90.0', 125, 5, '4A', '4D SEDAN', 'RWD', 2935, 'S0020'),
  ('V15022', 'MERCEDES-BENZ', 'ML', '320 LUXURY 4x4', 1999, '73400.00', '3.2', 'MULTI POINT F/INJ', '70.0', 160, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0022'),
  ('V15023', 'MERCEDES-BENZ', 'ML', 'W163 270 CDI LUXURY 4x4', 2003, '77274.00', '2.7', 'TURBO CDI', '83.0', 120, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0023'),
  ('V15024', 'MERCEDES-BENZ', 'E280', 'W210 ELEGANCE', 1999, '112400.00', '2.8', 'MULTI POINT F/INJ', '80.0', 150, 5, '5ASeq', '4D SEDAN', 'RWD', 2833, 'S0029'),
  ('V15025', 'MERCEDES-BENZ', 'VITO', '115CDI COMPACT CREW CAB', 2005, '48380.00', '2.1', 'DIESEL TURBO F/INJ', '75.0', 110, 5, '5A', '5D VAN', 'RWD', 3200, 'S0019'),
  ('V15026', 'MERCEDES-BENZ', '180', 'E LIMITED EDITION', 1993, '47115.00', '1.8', 'ELECTRONIC F/INJ', '55.0', 82, 5, '4A', '4D SEDAN', 'RWD', 2665, 'S0015'),
  ('V15027', 'MERCEDES-BENZ', 'A160', 'AVANTGARDE', 1999, '41400.00', '1.6', 'MULTI POINT F/INJ', '54.0', 75, 5, '5MSeq', '5D HATCHBACK', 'FWD', 2423, 'S0027'),
  ('V15028', 'MERCEDES-BENZ', 'ML', '270 CDI 4x4', 2001, '64900.00', '2.7', 'TURBO CDI', '70.0', 120, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0028'),
  ('V15029', 'MERCEDES-BENZ', 'A170', 'W169 ELEGANCE', 2006, '42400.00', '1.7', 'MULTI POINT F/INJ', '54.0', 85, 5, 'CVT7', '5D HATCHBACK', 'FWD', 2568, 'S0011'),
  ('V15030', 'MERCEDES-BENZ', '300', 'W124 E', 1986, '79296.00', '3.0', 'ELECTRONIC F/INJ', '70.0', 135, 5, '4A', '4D SEDAN', 'RWD', 2800, 'S0019'),
  ('V15011', 'MERCEDES-BENZ', 'C200', 'W202 ELEGANCE', 2000, '64580.00', '2.0', 'MULTI POINT F/INJ', '62.0', 100, 5, '5A', '4D SEDAN', 'RWD', 2690, 'S0025'),
  ('V15040', 'MERCEDES-BENZ', '230', 'W124 E', 1988, '87100.00', '2.3', 'ELECTRONIC F/INJ', '70.0', 97, 5, '4A', '4D SEDAN', 'RWD', 2800, 'S0018'),
  ('V15041', 'MERCEDES-BENZ', '180', 'E LIMITED EDITION', 1992, '45690.00', '1.8', 'ELECTRONIC F/INJ', '55.0', 82, 5, '4A', '4D SEDAN', 'RWD', 2665, 'S0015'),
  ('V15043', 'MERCEDES-BENZ', '380', 'SEL', 1982, '68795.00', '3.8', 'ELECTRONIC F/INJ', '90.0', 145, 5, '4A', '4D SEDAN', 'RWD', 3075, 'S0011'),
  ('V15044', 'MERCEDES-BENZ', 'A190', 'W168 LWB ELEGANCE', 2004, '42900.00', '1.9', 'MULTI POINT F/INJ', '54.0', 92, 5, '5MSeq', '5D HATCHBACK', 'FWD', 2593, 'S0039'),
  ('V15045', 'MERCEDES-BENZ', '180', 'E LIMITED EDITION', 1994, '47115.00', '1.8', 'ELECTRONIC F/INJ', '55.0', 82, 5, '4A', '4D SEDAN', 'RWD', 2665, 'S0018'),
  ('V15046', 'MERCEDES-BENZ', 'A190', 'W168 AVANTGARDE', 2001, '41230.00', '1.9', 'MULTI POINT F/INJ', '54.0', 92, 5, '5MSeq', '5D HATCHBACK', 'FWD', 2423, 'S0030'),
  ('V15047', 'MERCEDES-BENZ', 'CLK230', 'KOMP ELEGANCE', 2000, '111580.00', '2.3', 'SUPERCHARGED MPFI', '62.0', 142, 4, '5A', '2D CABRIOLET', 'RWD', 2690, 'S0012'),
  ('V15048', 'MERCEDES-BENZ', 'A190', 'W168 AVANTGARDE', 2000, '41230.00', '1.9', 'MULTI POINT F/INJ', '54.0', 92, 5, '5MSeq', '5D HATCHBACK', 'FWD', 2423, 'S0022'),
  ('V15049', 'MERCEDES-BENZ', 'ML', 'W163 500 LUXURY 4x4', 2001, '98500.00', '5.0', 'MULTI POINT F/INJ', '83.0', 215, 5, '5ATS', '4D WAGON', '4WD', 2820, 'S0027'),
  ('V15050', 'MERCEDES-BENZ', 'E500', '211 AVANTGARDE', 2002, '153900.00', '5.0', 'MULTI POINT F/INJ', '89.0', 225, 5, '5ATSh', '4D SEDAN', 'RWD', 2854, 'S0011'),
  ('V15042', 'MERCEDES-BENZ', 'E55', '211 MY06 UPGRADE AMG', 2006, '225600.00', '5.4', 'SUPERCHARGED MPFI', '80.0', 350, 5, '5ATSh', '4D SEDAN', 'RWD', 2854, 'S0020'),
  ('V15066', 'RENAULT', 'CLIO', 'CAMPUS', 2006, '18990.00', '1.4', 'MULTI POINT F/INJ', '50.0', 72, 5, '5M', '5D HATCHBACK', 'FWD', 2472, 'S0022'),
  ('V15063', 'RENAULT', 'CLIO', 'SPORT', 2002, '33990.00', '2.0', 'MULTI POINT F/INJ', '50.0', 124, 5, '5M', '3D HATCHBACK', 'FWD', 2472, 'S0024'),
  ('V15082', 'RENAULT', 'MEGANE', 'EXPRESSION', 2002, '41490.00', '1.6', 'MULTI POINT F/INJ', '60.0', 79, 4, '5M', '2D CABRIOLET', 'FWD', 2461, 'S0037'),
  ('V15087', 'VOLVO', '8', '50 GLE', 1992, '45690.00', '2.4', 'ELECTRONIC F/INJ', '73.0', 103, 5, '4A', '4D SEDAN', 'FWD', 2665, 'S0002'),
  ('V15068', 'RENAULT', 'SCENIC', 'PRIVILEGE', 2003, '37990.00', '2.0', 'MULTI POINT F/INJ', '60.0', 101, 5, '4A', '5D WAGON', 'FWD', 2580, 'S0017'),
  ('V15088', 'VOLVO', 'XC70', '05 UPGRADE II LIFESTYLE EDITION LE', 2005, '64450.00', '2.5', 'TURBO MPFI', '70.0', 154, 5, '5AG', '4D WAGON', 'AWD', 2761, 'S0013'),
  ('V15081', 'RENAULT', 'MEGANE', 'PRIVILEGE', 2004, '35990.00', '2.0', 'MULTI POINT F/INJ', '60.0', 98, 5, '4A', '4D SEDAN', 'FWD', 2686, 'S0009'),
  ('V15085', 'VOLVO', '7', '40 TURBO', 1989, '65900.00', '2.3', 'TURBO EFI', '82.0', 119, 5, '4A', '4D SEDAN', 'RWD', 2770, 'S0031'),
  ('V15083', 'VOLVO', 'S60', '05 UPGRADE 2.4 20V SE', 2006, '56950.00', '2.4', 'MULTI POINT F/INJ', '70.0', 125, 5, '5A', '4D SEDAN', 'FWD', 2715, 'S0039'),
  ('V15084', 'VOLVO', 'V50', 'MY08 D5', 2008, '47950.00', '2.4', 'DIESEL TURBO F/INJ', '60.0', 132, 5, '5AG', '4D WAGON', 'FWD', 2640, 'S0011'),
  ('V15080', 'RENAULT', '19', 'RT', 1995, '26790.00', '1.7', 'MULTI POINT F/INJ', '55.0', 68, 5, '5M', '5D HATCHBACK', 'FWD', 2540, 'S0019'),
  ('V15100', 'VOLVO', 'S40', 'MY2003 2.0 SE', 2003, '47950.00', '1.9', 'MULTI POINT F/INJ', '60.0', 100, 5, '5A', '4D SEDAN', 'FWD', 2562, 'S0020'),
  ('V15101', 'VOLVO', 'S40', 'MY2001 2.0 SE', 2001, '47950.00', '1.9', 'MULTI POINT F/INJ', '60.0', 100, 5, '5A', '4D SEDAN', 'FWD', 2562, 'S0011'),
  ('V15102', 'VOLVO', '8', '50 GLE', 1994, '47950.00', '2.4', 'ELECTRONIC F/INJ', '73.0', 103, 5, '4A', '4D SEDAN', 'FWD', 2665, 'S0010'),
  ('V15103', 'VOLVO', 'S80', 'T6 SE', 2001, '98950.00', '2.8', 'TWIN TURBO MPFI', '80.0', 200, 5, '4AG', '4D SEDAN', 'RWD', 2791, 'S0019'),
  ('V15104', 'VOLVO', '8', '50 SE', 1997, '59950.00', '2.4', 'MULTI POINT F/INJ', '73.0', 125, 5, '4A', '5D WAGON', 'FWD', 2665, 'S0012'),
  ('V15105', 'VOLVO', 'V40', '2', 1997, '45950.00', '1.9', 'MULTI POINT F/INJ', '60.0', 103, 5, '4A', '5D WAGON', 'FWD', 2550, 'S0025'),
  ('V15107', 'VOLVO', 'XC90', 'MY06 LIFESTYLE EDITION LE', 2006, '69950.00', '2.5', 'TURBO MPFI', '72.0', 154, 7, '5AG', '4D WAGON', 'AWD', 2857, 'S0027'),
  ('V15108', 'VOLVO', 'S40', 'T4', 1998, '53450.00', '1.9', 'TURBO MPFI', '60.0', 147, 5, '5M', '4D SEDAN', 'FWD', 2550, 'S0025'),
  ('V15109', 'VOLVO', '4', '40 GLT', 1994, '40950.00', '2.0', 'ELECTRONIC F/INJ', '60.0', 80, 5, '4A', '4D HATCHBACK', 'FWD', 2503, 'S0029'),
  ('V15110', 'VOLVO', '2', '44 GL', 1979, '11220.00', '2.1', 'FUEL INJECTED', '60.0', 91, 5, '3A', '4D SEDAN', 'RWD', 2640, 'S0024'),
  ('V15089', 'VOLVO', 'V50', 'MY07 2.4 LE', 2007, '47950.00', '2.4', 'MULTI POINT F/INJ', '62.0', 125, 5, '5AG', '4D WAGON', 'FWD', 2640, 'S0035'),
  ('V15121', 'VOLVO', 'S40', 'MY06 T5 AWD', 2006, '54950.00', '2.5', 'TURBO MPFI', '57.0', 162, 5, '5AG', '4D SEDAN', 'AWD', 2640, 'S0001'),
  ('V15125', 'NISSAN', '200', 'S15 SX SPEC S', 2002, '40990.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '6M', '2D COUPE', 'RWD', 2525, 'S0005'),
  ('V15126', 'NISSAN', '200', 'S15 SX SPEC R GT', 2002, '46490.00', '2.0', 'TURBO MPFI', '65.0', 147, 4, '6M', '2D COUPE', 'RWD', 2525, 'S0025'),
  ('V15401', 'MERCEDES BENZ', 'CLA200', 'CLA CLASS', 2018, '53000.00', '1.6', 'PREMIUM UNLEADED PETROL', '50.0', 115, 5, '7A', '4D SEDAN', 'FWD', 2699, 'S0020');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `django_admin_log`
  --
  
  DROP TABLE IF EXISTS `django_admin_log`;
  CREATE TABLE IF NOT EXISTS `django_admin_log` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `action_time` datetime(6) NOT NULL,
    `object_id` longtext,
    `object_repr` varchar(200) NOT NULL,
    `action_flag` smallint(5) UNSIGNED NOT NULL,
    `change_message` longtext NOT NULL,
    `content_type_id` int(11) DEFAULT NULL,
    `user_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `django_admin_log_content_type_id_c4bce8eb` (`content_type_id`),
    KEY `django_admin_log_user_id_c564eba6` (`user_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `django_content_type`
  --
  
  DROP TABLE IF EXISTS `django_content_type`;
  CREATE TABLE IF NOT EXISTS `django_content_type` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app_label` varchar(100) NOT NULL,
    `model` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
  ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `django_content_type`
  --
  
  INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES
  (1, 'crcapp', 'customer'),
  (2, 'crcapp', 'employee'),
  (3, 'crcapp', 'inspects'),
  (4, 'crcapp', 'invoice'),
  (5, 'crcapp', 'order'),
  (6, 'crcapp', 'orderfor'),
  (7, 'crcapp', 'store'),
  (8, 'crcapp', 'vehicle'),
  (9, 'admin', 'logentry'),
  (10, 'auth', 'permission'),
  (11, 'auth', 'group'),
  (12, 'auth', 'user'),
  (13, 'contenttypes', 'contenttype'),
  (14, 'sessions', 'session');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `django_migrations`
  --
  
  DROP TABLE IF EXISTS `django_migrations`;
  CREATE TABLE IF NOT EXISTS `django_migrations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `applied` datetime(6) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `django_migrations`
  --
  
  INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES
  (1, 'contenttypes', '0001_initial', '2018-09-17 02:04:44.694872'),
  (2, 'auth', '0001_initial', '2018-09-17 02:04:48.209284'),
  (3, 'admin', '0001_initial', '2018-09-17 02:04:48.906890'),
  (4, 'admin', '0002_logentry_remove_auto_add', '2018-09-17 02:04:48.946080'),
  (5, 'admin', '0003_logentry_add_action_flag_choices', '2018-09-17 02:04:48.982123'),
  (6, 'contenttypes', '0002_remove_content_type_name', '2018-09-17 02:04:49.250120'),
  (7, 'auth', '0002_alter_permission_name_max_length', '2018-09-17 02:04:49.388879'),
  (8, 'auth', '0003_alter_user_email_max_length', '2018-09-17 02:04:49.518965'),
  (9, 'auth', '0004_alter_user_username_opts', '2018-09-17 02:04:49.558790'),
  (10, 'auth', '0005_alter_user_last_login_null', '2018-09-17 02:04:49.702724'),
  (11, 'auth', '0006_require_contenttypes_0002', '2018-09-17 02:04:49.713080'),
  (12, 'auth', '0007_alter_validators_add_error_messages', '2018-09-17 02:04:49.748377'),
  (13, 'auth', '0008_alter_user_username_max_length', '2018-09-17 02:04:49.901199'),
  (14, 'auth', '0009_alter_user_last_name_max_length', '2018-09-17 02:04:50.022349'),
  (15, 'crcapp', '0001_initial', '2018-09-17 02:04:55.634752'),
  (16, 'crcapp', '0002_auto_20180909_1600', '2018-09-17 02:04:59.757599'),
  (17, 'crcapp', '0003_auto_20180917_1203', '2018-09-17 02:05:00.050819'),
  (18, 'sessions', '0001_initial', '2018-09-17 02:05:00.309525'),
  (19, 'crcapp', '0004_auto_20180917_1211', '2018-09-17 02:11:38.891998'),
  (20, 'crcapp', '0005_auto_20180917_1213', '2018-09-17 02:13:10.631120'),
  (21, 'crcapp', '0006_auto_20180917_1213', '2018-09-17 02:14:04.499050'),
  (22, 'crcapp', '0007_auto_20180917_1528', '2018-09-20 01:56:19.491321'),
  (23, 'crcapp', '0008_auto_20180920_1150', '2018-09-20 01:56:20.523593'),
  (24, 'crcapp', '0009_auto_20180920_1156', '2018-09-20 01:56:21.158062'),
  (25, 'crcapp', '0010_auto_20180920_1157', '2018-09-20 01:57:43.061275');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `django_session`
  --
  
  DROP TABLE IF EXISTS `django_session`;
  CREATE TABLE IF NOT EXISTS `django_session` (
    `session_key` varchar(40) NOT NULL,
    `session_data` longtext NOT NULL,
    `expire_date` datetime(6) NOT NULL,
    PRIMARY KEY (`session_key`),
    KEY `django_session_expire_date_a5c62663` (`expire_date`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `django_session`
  --
  
  INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES
  ('3n3wuj0v0fux0we6e2wzk8rb3qlxwnxz', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-17 04:27:37.436923'),
  ('96plk0wna0y4sm5e9d0w4wmqq9a2726w', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-17 06:46:03.377342'),
  ('3wf02w7scuryw5awknmj36unh5t3elr6', 'YmQyNWI0M2M1M2U0M2Y3MWFlZDA2ODlmOTZjYWYyNGVmYTBjNjdjNDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidXR5cGUiOiJNYW5hZ2VyIiwibmFtZSI6Ik9zY2FyIExpIn0=', '2018-09-17 06:48:31.788257'),
  ('n4wxaebo4l6vd47olmpaqwnrim9um167', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-19 01:52:11.462011'),
  ('og6mddarkunycpe12xig4d474rlrqocr', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-19 03:56:10.966121'),
  ('ksxn4v1a0ghepeyjvlj9ymqa0enfieil', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-19 03:56:10.968146'),
  ('3dkof5w081q4pf33m7maazw3e2rlx2v8', 'NTRkY2U4YTZmZGJkZjhkZGQ3NzE5ZjZiNTZjYjk1ZWJmNDhiMzNmYzp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyIsInVpZCI6IkUwMDAwMSJ9', '2018-09-19 04:29:45.742567'),
  ('uygo3ft6lecnhlptuq614tmb8lhalfli', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-19 07:03:28.932721'),
  ('t8dy6j29qnrfhnvc0zenknli9qwi1fcs', 'ZWZjN2JjYjQxNDVkNTkwODM5ZGYyYjQ1MTQzZTgyNzgxODI4N2Y3OTp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidXR5cGUiOiJTdGFmZiIsIm5hbWUiOiJPc2NhciBMaSJ9', '2018-09-19 07:39:21.020071'),
  ('gui5u9nchtoikmn1cgfifsi6on1szuwg', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-20 02:22:00.409988'),
  ('a1ush70nlwaig2wut0zxgrowiv4911hz', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-20 04:28:21.065963'),
  ('omxi4qkdvv227l7xq7k31wkh7gooww8c', 'ZDVlNjlhOTRkOGNhODU1MjZlMmZkZTU4MjQ0ZTBlYWNiMGMzZTA4ODp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-21 05:19:14.262227'),
  ('low99aj7w8uu3o932jm4ypfl8v0wildh', 'ZDVlNjlhOTRkOGNhODU1MjZlMmZkZTU4MjQ0ZTBlYWNiMGMzZTA4ODp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-21 08:08:20.984325'),
  ('szvbmnfqilk7y1s59wt0it4i9hixlw1i', 'ZWI1N2M5YzJkZGQ4YTkxYTY3MzkzMzU3NWY5ZTU2MjY3ODViYjU1MDp7Il9zZXNzaW9uX2V4cGlyeSI6NzIwMCwidWlkIjoiRTAwMDAxIiwidXR5cGUiOiJEZXZlbG9wZXIiLCJuYW1lIjoiRGV2IFRlYW0gQm9pcyJ9', '2018-09-24 05:43:49.944617');
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  