text: -- phpMyAdmin SQL Dump
  -- version 4.1.14
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 13, 2016 at 01:33 PM
  -- Server version: 5.6.17
  -- PHP Version: 5.5.12
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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 utf8 */;
  
  --
  -- Database: `repairshop`
  --
  CREATE DATABASE IF NOT EXISTS `repairshop` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `repairshop`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `address`
  --
  
  CREATE TABLE IF NOT EXISTS `address` (
    `address_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `persontitle` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    `firstname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    `lastname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    `address1` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    `address2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `zone_id` int(10) unsigned NOT NULL,
    `country` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NGA',
    `po_box` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
    `phone` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `mobilephone` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `fax` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`address_id`),
    KEY `fk_zone_id_idx` (`zone_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=51 ;
  
  --
  -- Dumping data for table `address`
  --
  
  INSERT INTO `address` (`address_id`, `persontitle`, `firstname`, `lastname`, `address1`, `address2`, `zone_id`, `country`, `po_box`, `phone`, `mobilephone`, `fax`, `email`, `created_at`, `updated_at`) VALUES
  (1, 'Mr', 'Danny', 'Glover', '1 Oyingbo', '2 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'dglover@hotmail.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Mr', 'Schumm', 'Kaitlyn', '2 Oyingbo', '3 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Sydnee@winston.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Mr', 'Ruecker', 'Kaylin', '3 Oyingbo', '4 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Felix@elian.ca', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Mr', 'Zander', 'Ondricka', '4 Oyingbo', '5 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Buster_Wolf@eden.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Mr', 'Camila', 'O''Kon', '5 Oyingbo', '6 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Nathen_Hammes@dasia.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Mr', 'Keshawn', 'Braun', '6 Oyingbo', '7 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Samson.Cummings@dariana.io', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'Mr', 'Bonnie', 'Smitham', '7 Oyingbo', '8 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Lavinia_Grimes@aliyah.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Mr', 'Parker', 'Abernathy', '8 Oyingbo', '9 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Virginie_Walsh@leta.io', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'Mr', 'Alvah', 'Deckow', '9 Oyingbo', '10 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Glenna@xavier.name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'Mr', 'Adonis', 'Medhurst', '10 Oyingbo', '11 Fadeyi', 1, 'NGA', '100273', '8067314', '8067314', '100273', 'Kiera.Stiedemann@timmothy.biz', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'Mr', 'Ken', 'Schinner', '11 Oyingbo', '12 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Mozelle@breanne.io', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 'Mr', 'George', 'Shields', '12 Oyingbo', '13 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Brionna.Marquardt@merle.biz', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 'Mr', 'Alexzander', 'Kuhn', '13 Oyingbo', '14 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Johathan_Purdy@paris.us', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 'Mr', 'Monserrate', 'Harber', '14 Oyingbo', '15 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Brant@zack.io', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 'Mr', 'Ara', 'Willms', '15 Oyingbo', '16 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Roosevelt.Doyle@kelli.name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 'Mr', 'Jesus', 'Smith', '16 Oyingbo', '17 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Adeline@shaina.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 'Mr', 'Madisen', 'Braun', '17 Oyingbo', '18 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Kaleigh.Shanahan@weldon.ca', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 'Mr', 'Edwin', 'Abernathy', '18 Oyingbo', '19 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Reilly@nicola.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 'Mr', 'Cathy', 'Padberg', '19 Oyingbo', '20 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Gail@ahmed.ca', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 'Mr', 'Katlyn', 'Nikolaus', '20 Oyingbo', '21 Fadeyi', 5, 'NGA', '100273', '8067314', '8067314', '100273', 'Joey@karson.name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, 'Mr', 'Garrison', 'Cummings', '21 Oyingbo', '22 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Maggie.Kreiger@coby.co.uk', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, 'Mr', 'Melyssa', 'D''Amore', '22 Oyingbo', '23 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Laverna@gerhard.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, 'Mr', 'Axel', 'Ruecker', '23 Oyingbo', '24 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Francisco@loy.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, 'Mr', 'Dario', 'Nicolas', '24 Oyingbo', '25 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Max@zita.ca', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, 'Mr', 'Felipe', 'Harber', '25 Oyingbo', '26 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Daryl.Stanton@eulah.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, 'Mr', 'Brigitte', 'Hegmann', '26 Oyingbo', '27 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Madalyn.Oberbrunner@ocie.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 'Mr', 'Regan', 'Turner', '27 Oyingbo', '28 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Jett_Lueilwitz@halle.biz', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 'Mr', 'Vincenzo', 'Hettinger', '28 Oyingbo', '29 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Jordan.Hegmann@kathlyn.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 'Mr', 'Lauryn', 'Bosco', '29 Oyingbo', '30 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Micah@delphine.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 'Mr', 'Mitchel', 'Abbott', '30 Oyingbo', '31 Fadeyi', 10, 'NGA', '100273', '8067314', '8067314', '100273', 'Abe_Jakubowski@hershel.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'Mr', 'Angeline', 'Farrell', '31 Oyingbo', '32 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Sierra_Denesik@luciano.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'Mr', 'Alvina', 'Rippin', '32 Oyingbo', '33 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Jade@diana.ca', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'Mr', 'Gage', 'Bins', '33 Oyingbo', '34 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Orval@eunice.io', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'Mr', 'Aaliyah', 'Collins', '34 Oyingbo', '35 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Gayle.Christiansen@tatyana.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'Mr', 'Sibyl', 'Witting', '35 Oyingbo', '36 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Janie@lolita.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'Mr', 'Diana', 'Streich', '36 Oyingbo', '37 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Conrad_Schuppe@queen.us', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'Mr', 'Albertha', 'Dicki', '37 Oyingbo', '38 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Fausto.Pagac@ofelia.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'Mr', 'Chester', 'Smitham', '38 Oyingbo', '39 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Vivian@laverne.co.uk', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'Mr', 'Lance', 'Mante', '39 Oyingbo', '40 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Philip@fred.tv', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'Mr', 'Abner', 'Beier', '40 Oyingbo', '41 Fadeyi', 15, 'NGA', '100273', '8067314', '8067314', '100273', 'Arnoldo_Fahey@kristoffer.us', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'Mr', 'Alek', 'Kerluke', '41 Oyingbo', '42 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Lonie@avery.info', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'Mr', 'Joanny', 'O''Hara', '42 Oyingbo', '43 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Kaycee_Morissette@tianna.name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'Mr', 'Lucius', 'Smitham', '43 Oyingbo', '44 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Destinee_Borer@raphael.name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'Mr', 'Bertrand', 'McCullough', '44 Oyingbo', '45 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Sophie@onie.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'Mr', 'Maybelle', 'Turcotte', '45 Oyingbo', '46 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Bernadette@alycia.me', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'Mr', 'Miguel', 'Durgan', '46 Oyingbo', '47 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Grayson@michel.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'Mr', 'Christ', 'Medhurst', '47 Oyingbo', '48 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Clotilde.Lynch@mortimer.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (48, 'Mr', 'Prudence', 'Jast', '48 Oyingbo', '49 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Madisen_Brakus@samantha.me', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (49, 'Mr', 'Tate', 'O''Reilly', '49 Oyingbo', '50 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Tessie@lincoln.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'Mr', 'Cristopher', 'Rodriguez', '50 Oyingbo', '51 Fadeyi', 20, 'NGA', '100273', '8067314', '8067314', '100273', 'Miracle.Littel@jermaine.biz', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `carmake`
  --
  
  CREATE TABLE IF NOT EXISTS `carmake` (
    `carmake_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `carmake` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`carmake_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
  
  --
  -- Dumping data for table `carmake`
  --
  
  INSERT INTO `carmake` (`carmake_id`, `carmake`, `created_at`, `updated_at`) VALUES
  (1, 'Toyota', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Honda', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Ford', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Nissan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Mercedes Benz', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Volkswagen', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'BMW', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Hyundai', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'Kia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'Audi', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'Chevrolet', '2016-02-12 22:03:23', '2016-02-12 22:03:23'),
  (12, 'Pagani', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (13, 'Rolls Royce', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (14, 'Skoda', '2016-02-12 22:08:37', '2016-02-12 22:08:37');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `carmodel`
  --
  
  CREATE TABLE IF NOT EXISTS `carmodel` (
    `carmodel_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `carmodel` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `carmake_id` int(10) unsigned NOT NULL,
    `year` date NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`carmodel_id`),
    KEY `fk_id_car_idx` (`carmake_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=61 ;
  
  --
  -- Dumping data for table `carmodel`
  --
  
  INSERT INTO `carmodel` (`carmodel_id`, `carmodel`, `carmake_id`, `year`, `created_at`, `updated_at`) VALUES
  (1, 'Camry', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Corolla', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Avensis', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Highlander', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Prado', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Land Cruiser', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'Sienna', 1, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Accord', 2, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'Civic', 2, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'Pilot', 2, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'Odyssey', 2, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 'Edge', 3, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 'Escape', 3, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 'Explorer', 3, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 'Fusion', 3, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 'Focus', 3, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 'Altima', 4, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 'Maxima', 4, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 'Almera', 4, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 'Murano', 4, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, ' G Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, ' S Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, ' E Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, ' C Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, ' CL Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, ' ML Class', 5, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 'Passat', 6, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 'Golf', 6, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 'Touareg', 6, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 'Jetta', 6, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'X5', 7, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'X6', 7, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'X7', 7, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'I8', 7, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'Elantra', 8, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'Sonata', 8, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'Accent', 8, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'ix35', 8, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'Azera', 8, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'Soul', 9, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'Rio', 9, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'Optima', 9, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'Sorentto', 9, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'A6', 10, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'A7', 10, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'A8', 10, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'Q3', 10, '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'Avalanche', 11, '0000-00-00', '2016-02-12 22:08:36', '2016-02-12 22:08:36'),
  (51, 'Zonda Absolute', 12, '0000-00-00', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (52, 'Phantom I', 13, '0000-00-00', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (53, 'Skoda Mission', 14, '0000-00-00', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (54, 'Traverse', 11, '0000-00-00', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (55, 'Zonda Cinque Roadster', 12, '0000-00-00', '2016-02-12 22:08:37', '2016-02-12 22:08:37'),
  (56, 'Silver Cloud', 13, '0000-00-00', '2016-02-12 22:08:38', '2016-02-12 22:08:38'),
  (57, 'Skoda Roomster', 14, '0000-00-00', '2016-02-12 22:08:38', '2016-02-12 22:08:38'),
  (58, 'Zonda Roadster', 12, '0000-00-00', '2016-02-12 22:08:38', '2016-02-12 22:08:38'),
  (59, 'Wraith', 13, '0000-00-00', '2016-02-12 22:08:38', '2016-02-12 22:08:38'),
  (60, 'Skoda Yeti', 14, '0000-00-00', '2016-02-12 22:08:39', '2016-02-12 22:08:39');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `city`
  --
  
  CREATE TABLE IF NOT EXISTS `city` (
    `city_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `city` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `state_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`city_id`),
    KEY `fk_state_id_idx` (`state_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
  
  --
  -- Dumping data for table `city`
  --
  
  INSERT INTO `city` (`city_id`, `city`, `state_id`, `created_at`, `updated_at`) VALUES
  (1, 'Agege', 1, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (2, 'Ikeja', 1, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (3, 'Yaba', 1, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (4, 'Surulere', 1, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (5, 'Iyana Ipaja', 1, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (6, 'Garki', 2, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (7, 'Asokoro', 2, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (8, 'Jabi', 2, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (9, 'Gwagwalada', 2, '2016-02-04 19:06:19', '2016-02-04 19:06:19'),
  (10, 'Central District', 2, '2016-02-04 19:06:19', '2016-02-04 19:06:19');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `component`
  --
  
  CREATE TABLE IF NOT EXISTS `component` (
    `component_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `component` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`component_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
  
  --
  -- Dumping data for table `component`
  --
  
  INSERT INTO `component` (`component_id`, `component`, `created_at`, `updated_at`) VALUES
  (1, 'Diagnosis', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Engine', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Electrical Components', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Transmission and Axle', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Suspension & Steering', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Brake System', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'Fuel Delivery', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Engine Cooling System', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'Exhaust & Emissions', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'Air Conditioning', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE IF NOT EXISTS `migrations` (
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`migration`, `batch`) VALUES
  ('2016_02_09_201835_create_password_resets_table', 1),
  ('2016_02_09_201835_create_users_table', 1),
  ('2016_02_09_202509_create_address_table', 1),
  ('2016_02_09_202509_create_carmake_table', 1),
  ('2016_02_09_202509_create_carmodel_table', 1),
  ('2016_02_09_202509_create_city_table', 1),
  ('2016_02_09_202509_create_component_table', 1),
  ('2016_02_09_202509_create_rate_table', 1),
  ('2016_02_09_202509_create_repairshop_table', 1),
  ('2016_02_09_202509_create_state_table', 1),
  ('2016_02_09_202509_create_subcomponent_table', 1),
  ('2016_02_09_202509_create_zone_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_address_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_carmodel_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_city_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_rate_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_repairshop_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_subcomponent_table', 1),
  ('2016_02_09_202512_add_foreign_keys_to_zone_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` datetime NOT NULL,
    KEY `password_resets_email_index` (`email`),
    KEY `password_resets_token_index` (`token`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `rate`
  --
  
  CREATE TABLE IF NOT EXISTS `rate` (
    `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `subcomponent_id` int(10) unsigned NOT NULL,
    `repairshop_id` int(10) unsigned NOT NULL,
    `carmodel_id` int(10) unsigned NOT NULL,
    `amount` decimal(9,2) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `min_amount` decimal(9,2) DEFAULT NULL,
    `max_amount` decimal(9,2) DEFAULT NULL,
    PRIMARY KEY (`rate_id`),
    UNIQUE KEY `unique` (`subcomponent_id`,`repairshop_id`,`carmodel_id`),
    KEY `fk_repair_details_idx` (`subcomponent_id`),
    KEY `fk_company_id_idx` (`repairshop_id`),
    KEY `fk_brand_id_idx` (`carmodel_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=379 ;
  
  --
  -- Dumping data for table `rate`
  --
  
  INSERT INTO `rate` (`rate_id`, `subcomponent_id`, `repairshop_id`, `carmodel_id`, `amount`, `created_at`, `updated_at`, `min_amount`, `max_amount`) VALUES
  (1, 1, 1, 1, '10000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (2, 2, 2, 2, '10500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (3, 3, 3, 3, '11000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (4, 4, 4, 4, '11500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (5, 5, 5, 5, '12000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (6, 6, 6, 6, '12500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (7, 7, 7, 7, '13000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (8, 8, 8, 8, '13500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (9, 9, 9, 9, '14000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (10, 10, 10, 10, '14500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (11, 11, 11, 11, '15000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (12, 12, 12, 12, '15500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (13, 13, 13, 13, '16000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (14, 14, 14, 14, '16500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (15, 15, 15, 15, '17000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (16, 16, 16, 16, '17500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (17, 17, 17, 17, '18000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (18, 18, 18, 18, '18500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (19, 19, 19, 19, '19000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (20, 20, 20, 20, '19500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (21, 21, 21, 21, '20000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (22, 22, 22, 22, '20500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (23, 23, 23, 23, '21000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (24, 24, 24, 24, '21500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (25, 25, 25, 25, '22000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (26, 26, 26, 26, '22500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (27, 27, 27, 27, '23000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (28, 28, 28, 28, '23500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (29, 29, 29, 29, '24000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (30, 30, 30, 30, '24500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (31, 31, 31, 31, '25000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (32, 32, 32, 32, '25500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (33, 33, 33, 33, '26000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (34, 34, 34, 34, '26500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (35, 35, 35, 35, '27000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (36, 36, 36, 36, '27500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (37, 37, 37, 37, '28000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (38, 38, 38, 38, '28500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (39, 39, 39, 39, '29000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (40, 40, 40, 40, '29500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (41, 41, 41, 41, '30000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (42, 42, 42, 42, '30500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (43, 43, 43, 43, '31000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (44, 44, 44, 44, '31500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (45, 45, 45, 45, '32000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (46, 46, 46, 46, '32500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (47, 47, 47, 47, '33000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (48, 48, 48, 1, '33500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (49, 49, 49, 2, '34000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (50, 50, 50, 3, '34500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (51, 51, 1, 4, '35000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (52, 52, 2, 5, '35500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (53, 53, 3, 6, '36000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (54, 54, 4, 7, '36500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (55, 55, 5, 8, '37000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (56, 56, 6, 9, '37500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (57, 57, 7, 10, '38000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (58, 58, 8, 11, '38500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (59, 59, 9, 12, '39000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (60, 60, 10, 13, '39500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (61, 61, 11, 14, '40000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (62, 1, 12, 15, '40500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (63, 2, 13, 16, '41000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (64, 3, 14, 17, '41500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (65, 4, 15, 18, '42000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (66, 5, 16, 19, '42500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (67, 6, 17, 20, '43000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (68, 7, 18, 21, '43500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (69, 8, 19, 22, '44000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (70, 9, 20, 23, '44500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (71, 10, 21, 24, '45000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (72, 11, 22, 25, '45500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (73, 12, 23, 26, '46000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (74, 13, 24, 27, '46500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (75, 14, 25, 28, '47000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (76, 15, 26, 29, '47500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (77, 16, 27, 30, '48000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (78, 17, 28, 31, '48500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (79, 18, 29, 32, '49000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (80, 19, 30, 33, '49500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (81, 20, 31, 34, '50000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (82, 21, 32, 35, '50500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (83, 22, 33, 36, '51000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (84, 23, 34, 37, '51500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (85, 24, 35, 38, '52000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (86, 25, 36, 39, '52500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (87, 26, 37, 40, '53000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (88, 27, 38, 41, '53500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (89, 28, 39, 42, '54000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (90, 29, 40, 43, '54500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (91, 30, 41, 44, '55000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (92, 31, 42, 45, '55500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (93, 32, 43, 46, '56000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (94, 33, 44, 47, '56500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (95, 34, 45, 1, '57000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (96, 35, 46, 2, '57500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (97, 36, 47, 3, '58000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (98, 37, 48, 4, '58500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (99, 38, 49, 5, '59000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (100, 39, 50, 6, '59500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (101, 40, 1, 7, '60000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (102, 41, 2, 8, '60500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (103, 42, 3, 9, '61000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (104, 43, 4, 10, '61500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (105, 44, 5, 11, '62000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (106, 45, 6, 12, '62500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (107, 46, 7, 13, '63000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (108, 47, 8, 14, '63500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (109, 48, 9, 15, '64000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (110, 49, 10, 16, '64500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (111, 50, 11, 17, '65000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (112, 51, 12, 18, '65500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (113, 52, 13, 19, '66000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (114, 53, 14, 20, '66500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (115, 54, 15, 21, '67000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (116, 55, 16, 22, '67500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (117, 56, 17, 23, '68000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (118, 57, 18, 24, '68500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (119, 58, 19, 25, '69000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (120, 59, 20, 26, '69500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (121, 60, 21, 27, '70000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (122, 61, 22, 28, '70500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (123, 1, 23, 29, '71000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (124, 2, 24, 30, '71500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (125, 3, 25, 31, '72000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (126, 4, 26, 32, '72500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (127, 5, 27, 33, '73000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (128, 6, 28, 34, '73500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (129, 7, 29, 35, '74000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (130, 8, 30, 36, '74500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (131, 9, 31, 37, '75000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (132, 10, 32, 38, '75500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (133, 11, 33, 39, '76000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (134, 12, 34, 40, '76500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (135, 13, 35, 41, '77000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (136, 14, 36, 42, '77500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (137, 15, 37, 43, '78000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (138, 16, 38, 44, '78500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (139, 17, 39, 45, '79000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (140, 18, 40, 46, '79500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (141, 19, 41, 47, '80000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (142, 20, 42, 1, '80500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (143, 21, 43, 2, '81000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (144, 22, 44, 3, '81500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (145, 23, 45, 4, '82000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (146, 24, 46, 5, '82500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (147, 25, 47, 6, '83000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (148, 26, 48, 7, '83500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (149, 27, 49, 8, '84000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (150, 28, 50, 9, '84500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (151, 29, 1, 10, '85000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (152, 30, 2, 11, '85500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (153, 31, 3, 12, '86000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (154, 32, 4, 13, '86500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (155, 33, 5, 14, '87000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (156, 34, 6, 15, '87500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (157, 35, 7, 16, '88000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (158, 36, 8, 17, '88500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (159, 37, 9, 18, '89000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (160, 38, 10, 19, '89500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (161, 39, 11, 20, '90000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (162, 40, 12, 21, '90500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (163, 41, 13, 22, '91000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (164, 42, 14, 23, '91500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (165, 43, 15, 24, '92000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (166, 44, 16, 25, '92500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (167, 45, 17, 26, '93000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (168, 46, 18, 27, '93500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (169, 47, 19, 28, '94000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (170, 48, 20, 29, '94500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (171, 49, 21, 30, '95000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (172, 50, 22, 31, '95500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (173, 51, 23, 32, '96000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (174, 52, 24, 33, '96500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (175, 53, 25, 34, '97000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (176, 54, 26, 35, '97500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (177, 55, 27, 36, '98000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (178, 56, 28, 37, '98500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (179, 57, 29, 38, '99000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (180, 58, 30, 39, '99500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (181, 59, 31, 40, '100000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (182, 60, 32, 41, '100500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (183, 61, 33, 42, '101000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (184, 1, 34, 43, '101500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (185, 2, 35, 44, '102000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (186, 3, 36, 45, '102500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (187, 4, 37, 46, '103000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (188, 5, 38, 47, '103500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (189, 6, 39, 1, '104000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (190, 7, 40, 2, '104500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (191, 8, 41, 3, '105000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (192, 9, 42, 4, '105500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (193, 10, 43, 5, '106000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (194, 11, 44, 6, '106500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (195, 12, 45, 7, '107000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (196, 13, 46, 8, '107500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (197, 14, 47, 9, '108000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (198, 15, 48, 10, '108500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (199, 16, 49, 11, '109000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (200, 17, 50, 12, '109500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (201, 18, 1, 13, '110000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (202, 19, 2, 14, '110500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (203, 20, 3, 15, '111000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (204, 21, 4, 16, '111500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (205, 22, 5, 17, '112000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (206, 23, 6, 18, '112500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (207, 24, 7, 19, '113000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (208, 25, 8, 20, '113500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (209, 26, 9, 21, '114000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (210, 27, 10, 22, '114500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (211, 28, 11, 23, '115000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (212, 29, 12, 24, '115500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (213, 30, 13, 25, '116000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (214, 31, 14, 26, '116500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (215, 32, 15, 27, '117000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (216, 33, 16, 28, '117500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (217, 34, 17, 29, '118000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (218, 35, 18, 30, '118500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (219, 36, 19, 31, '119000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (220, 37, 20, 32, '119500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (221, 38, 21, 33, '120000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (222, 39, 22, 34, '120500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (223, 40, 23, 35, '121000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (224, 41, 24, 36, '121500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (225, 42, 25, 37, '122000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (226, 43, 26, 38, '122500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (227, 44, 27, 39, '123000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (228, 45, 28, 40, '123500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (229, 46, 29, 41, '124000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (230, 47, 30, 42, '124500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (231, 48, 31, 43, '125000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (232, 49, 32, 44, '125500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (233, 50, 33, 45, '126000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (234, 51, 34, 46, '126500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (235, 52, 35, 47, '127000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (236, 53, 36, 1, '127500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (237, 54, 37, 2, '128000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (238, 55, 38, 3, '128500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (239, 56, 39, 4, '129000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (240, 57, 40, 5, '129500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (241, 58, 41, 6, '130000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (242, 59, 42, 7, '130500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (243, 60, 43, 8, '131000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (244, 61, 44, 9, '131500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (245, 1, 45, 10, '132000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (246, 2, 46, 11, '132500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (247, 3, 47, 12, '133000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (248, 4, 48, 13, '133500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (249, 5, 49, 14, '134000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (250, 6, 50, 15, '134500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (251, 7, 1, 16, '135000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (252, 8, 2, 17, '135500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (253, 9, 3, 18, '136000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (254, 10, 4, 19, '136500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (255, 11, 5, 20, '137000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (256, 12, 6, 21, '137500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (257, 13, 7, 22, '138000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (258, 14, 8, 23, '138500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (259, 15, 9, 24, '139000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (260, 16, 10, 25, '139500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (261, 17, 11, 26, '140000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (262, 18, 12, 27, '140500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (263, 19, 13, 28, '141000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (264, 20, 14, 29, '141500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (265, 21, 15, 30, '142000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (266, 22, 16, 31, '142500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (267, 23, 17, 32, '143000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (268, 24, 18, 33, '143500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (269, 25, 19, 34, '144000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (270, 26, 20, 35, '144500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (271, 27, 21, 36, '145000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (272, 28, 22, 37, '145500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (273, 29, 23, 38, '146000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (274, 30, 24, 39, '146500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (275, 31, 25, 40, '147000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (276, 32, 26, 41, '147500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (277, 33, 27, 42, '148000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (278, 34, 28, 43, '148500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (279, 35, 29, 44, '149000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (280, 36, 30, 45, '149500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (281, 37, 31, 46, '150000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (282, 38, 32, 47, '150500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (283, 39, 33, 1, '151000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (284, 40, 34, 2, '151500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (285, 41, 35, 3, '152000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (286, 42, 36, 4, '152500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (287, 43, 37, 5, '153000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (288, 44, 38, 6, '153500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (289, 45, 39, 7, '154000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (290, 46, 40, 8, '154500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (291, 47, 41, 9, '155000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (292, 48, 42, 10, '155500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (293, 49, 43, 11, '156000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (294, 50, 44, 12, '156500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (295, 51, 45, 13, '157000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (296, 52, 46, 14, '157500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (297, 53, 47, 15, '158000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (298, 54, 48, 16, '158500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (299, 55, 49, 17, '159000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (300, 56, 50, 18, '159500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (301, 57, 1, 19, '160000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (302, 58, 2, 20, '160500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (303, 59, 3, 21, '161000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (304, 60, 4, 22, '161500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (305, 61, 5, 23, '162000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (306, 1, 6, 24, '162500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (307, 2, 7, 25, '163000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (308, 3, 8, 26, '163500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (309, 4, 9, 27, '164000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (310, 5, 10, 28, '164500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (311, 6, 11, 29, '165000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (312, 7, 12, 30, '165500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (313, 8, 13, 31, '166000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (314, 9, 14, 32, '166500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (315, 10, 15, 33, '167000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (316, 11, 16, 34, '167500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (317, 12, 17, 35, '168000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (318, 13, 18, 36, '168500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (319, 14, 19, 37, '169000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (320, 15, 20, 38, '169500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (321, 16, 21, 39, '170000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (322, 17, 22, 40, '170500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (323, 18, 23, 41, '171000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (324, 19, 24, 42, '171500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (325, 20, 25, 43, '172000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (326, 21, 26, 44, '172500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (327, 22, 27, 45, '173000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (328, 23, 28, 46, '173500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (329, 24, 29, 47, '174000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (330, 25, 30, 1, '174500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (331, 26, 31, 2, '175000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (332, 27, 32, 3, '175500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (333, 28, 33, 4, '176000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (334, 29, 34, 5, '176500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (335, 30, 35, 6, '177000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (336, 31, 36, 7, '177500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (337, 32, 37, 8, '178000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (338, 33, 38, 9, '178500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (339, 34, 39, 10, '179000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (340, 35, 40, 11, '179500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (341, 36, 41, 12, '180000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (342, 37, 42, 13, '180500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (343, 38, 43, 14, '181000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (344, 39, 44, 15, '181500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (345, 40, 45, 16, '182000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (346, 41, 46, 17, '182500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (347, 42, 47, 18, '183000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (348, 43, 48, 19, '183500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (349, 44, 49, 20, '184000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (350, 45, 50, 21, '184500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (351, 46, 1, 22, '185000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (352, 47, 2, 23, '185500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (353, 48, 3, 24, '186000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (354, 49, 4, 25, '186500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (355, 50, 5, 26, '187000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (356, 51, 6, 27, '187500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (357, 52, 7, 28, '188000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (358, 53, 8, 29, '188500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (359, 54, 9, 30, '189000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (360, 55, 10, 31, '189500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (361, 56, 11, 32, '190000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (362, 57, 12, 33, '190500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (363, 58, 13, 34, '191000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (364, 59, 14, 35, '191500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (365, 60, 15, 36, '192000.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (366, 61, 16, 37, '192500.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0.00', '0.00'),
  (367, 1, 1, 50, '3000.00', '2016-02-12 22:45:53', '2016-02-12 22:47:15', NULL, NULL),
  (368, 2, 2, 51, '5000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (369, 3, 3, 52, '3000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (370, 4, 4, 53, '6000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (371, 5, 5, 54, '7000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (372, 6, 6, 55, '9000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (373, 7, 7, 56, '5000.00', '2016-02-12 22:47:15', '2016-02-12 22:47:15', NULL, NULL),
  (374, 8, 8, 57, '4000.00', '2016-02-12 22:47:16', '2016-02-12 22:47:16', NULL, NULL),
  (375, 9, 9, 58, '8000.00', '2016-02-12 22:47:16', '2016-02-12 22:47:16', NULL, NULL),
  (376, 10, 10, 59, '9000.00', '2016-02-12 22:47:16', '2016-02-12 22:47:16', NULL, NULL),
  (377, 11, 11, 60, '3000.00', '2016-02-12 22:47:16', '2016-02-12 22:47:16', NULL, NULL),
  (378, 62, 11, 59, '800000.00', '2016-02-12 22:47:16', '2016-02-12 22:47:16', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `repairshop`
  --
  
  CREATE TABLE IF NOT EXISTS `repairshop` (
    `repairshop_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `repairshop` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `address_id` int(10) unsigned NOT NULL,
    `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `zone_id` int(10) unsigned NOT NULL,
    `phone_number` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`repairshop_id`),
    KEY `fk_zone_id_idx` (`zone_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=52 ;
  
  --
  -- Dumping data for table `repairshop`
  --
  
  INSERT INTO `repairshop` (`repairshop_id`, `repairshop`, `address_id`, `email`, `zone_id`, `phone_number`, `created_at`, `updated_at`) VALUES
  (1, 'Elvie Luettgen Repair Shop', 1, 'Enola@kaleigh.biz', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Virgil Daugherty V Repair Shop', 2, 'Mertie@johann.name', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Marisa Hagenes Repair Shop', 3, 'Jayda_Bruen@andres.me', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Elias Stark Repair Shop', 4, 'Myrtis_Hansen@oswaldo.name', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Raquel Auer Repair Shop', 5, 'Evie.Prosacco@seamus.io', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Dino Prosacco Repair Shop', 6, 'Willa_Glover@ceasar.co.uk', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'Leola Weissnat Repair Shop', 7, 'Einar_Kovacek@owen.com', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Ola Cummerata Repair Shop', 8, 'Alexzander.Pagac@erin.org', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'Karina Gleason Repair Shop', 9, 'Serena@dallin.tv', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'Kameron Braun Repair Shop', 10, 'Chadd@sandrine.biz', 1, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'Miles Barrows Repair Shop', 11, 'Orion.Jewess@letha.us', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 'Marquis Connelly MD Repair Shop', 12, 'Marcia.Koelpin@matteo.io', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 'Amelia Friesen Repair Shop', 13, 'Ralph_Goyette@loren.io', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 'Willis Gutkowski Repair Shop', 14, 'Albert@clinton.io', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 'Simeon Daugherty Repair Shop', 15, 'Dolly_Waelchi@keon.name', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 'Anthony Rippin Repair Shop', 16, 'Warren@francisca.tv', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 'Abigayle Strosin Repair Shop', 17, 'Lynn@edythe.co.uk', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 'Salvatore Ferry Repair Shop', 18, 'Moriah.Rodriguez@berenice.name', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 'Oswaldo Cremin I Repair Shop', 19, 'Bradly.Kris@kaley.org', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 'Hellen Kreiger Repair Shop', 20, 'Annie.Fay@abby.io', 5, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, 'Gayle Jakubowski Repair Shop', 21, 'Einar@sophie.biz', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, 'Evangeline Fisher Repair Shop', 22, 'Isabel@althea.tv', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, 'Noelia Rempel Repair Shop', 23, 'Granville@cayla.me', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, 'Helmer White Repair Shop', 24, 'Gussie_Rohan@ashly.biz', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, 'Miss Madison Gleason Repair Shop', 25, 'Martine@casandra.com', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, 'Spencer Zemlak Repair Shop', 26, 'Ettie@paige.io', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 'Antoinette Bergnaum Repair Shop', 27, 'Luella_Jacobs@jacey.net', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 'Gage Davis Repair Shop', 28, 'Trinity@hudson.info', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 'Jovanny Hackett Repair Shop', 29, 'Emely@mariano.org', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 'Juliana McCullough Repair Shop', 30, 'Lera@jerel.com', 10, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'Kariane Barrows Repair Shop', 31, 'Vladimir.Roberts@therese.us', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'Miguel Ullrich Repair Shop', 32, 'Stephanie@marco.me', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'Blanche Sawayn Repair Shop', 33, 'Henriette.Jenkins@remington.ca', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'Madisyn Bailey Repair Shop', 34, 'Joesph@merlin.net', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'Aracely Fisher Repair Shop', 35, 'Nathan.Williamson@wilhelmine.io', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'Chase Spencer Repair Shop', 36, 'Albertha@gaylord.io', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'Destiney Adams Repair Shop', 37, 'Janet.Hilpert@talon.tv', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'Michale Roberts Repair Shop', 38, 'Gonzalo@bryana.com', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'Mr. Tatum Renner Repair Shop', 39, 'Abbey@filomena.io', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'Bernadine Lubowitz Repair Shop', 40, 'Lisette_Kub@christopher.us', 15, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'Nickolas Hoppe Repair Shop', 41, 'Stephanie@jackeline.org', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'Sheila Bashirian Repair Shop', 42, 'Otha.Labadie@brent.info', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'Furman Sipes Jr. Repair Shop', 43, 'Paxton@katarina.tv', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'Ashley Will Repair Shop', 44, 'Lizeth.Reynolds@ned.biz', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'Ericka Kulas Repair Shop', 45, 'Abdiel_Torphy@kobe.biz', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'Cathy Schaden Repair Shop', 46, 'Haleigh@kyra.ca', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'Noemie Wintheiser Repair Shop', 47, 'Geo@tito.com', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (48, 'Mario Flatley Repair Shop', 48, 'Myrtle@jabari.info', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (49, 'Rickie Fisher Repair Shop', 49, 'Dejuan@joaquin.me', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'Arden Glover V Repair Shop', 50, 'Daniela_King@audreanne.biz', 20, '100273', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `state`
  --
  
  CREATE TABLE IF NOT EXISTS `state` (
    `state_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `state` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`state_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
  
  --
  -- Dumping data for table `state`
  --
  
  INSERT INTO `state` (`state_id`, `state`, `created_at`, `updated_at`) VALUES
  (1, 'Lagos', NULL, NULL),
  (2, 'Abuja', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `subcomponent`
  --
  
  CREATE TABLE IF NOT EXISTS `subcomponent` (
    `subcomponent_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `subcomponent` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `component_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`subcomponent_id`),
    KEY `fk_type_id_idx` (`component_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=63 ;
  
  --
  -- Dumping data for table `subcomponent`
  --
  
  INSERT INTO `subcomponent` (`subcomponent_id`, `subcomponent`, `component_id`, `created_at`, `updated_at`) VALUES
  (1, 'ABS System Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'Air Conditioning Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'Automatic Transmission Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'Charging System Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'Check Engine Light Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'Coolant Leak Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'Engine Oil Light Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'Engine Overheating Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'General Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'No Start Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'Oil Leak Diagnosis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 'Head Gasket(s) Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 'Ignition Coil Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 'Intake Manifold Gasket Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 'Mass Airflow Sensor Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 'Oil Pan Reseal - Engine', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 'Oil Pump Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 'Valve Cover Gasket(s) Replacement', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 'Engine rebuild', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 'Alternator Replacement', 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, 'Wiper Motor Replacement', 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, 'Door Window Motor Replacement', 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, 'Door Window Regulator Replacement', 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, 'Starter Replacement', 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, 'Axle/Half Shaft Replacement - Rear', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, 'Transmission Replacement', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 'Transmission Rebuild', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 'Clutch Master Cylinder Replacement', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 'Clutch Replacement', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 'Clutch Slave Cylinder Replacement', 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'Power Steering Pressure Hose Replacement', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'Power Steering Pump Replacement', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'Steering Rack Replacement', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'Strut Replacement - Rear', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'Strut/Shock Absorber Replacement - Front', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'Tie Rod End Replacement - Inner', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'Tie Rod End Replacement - Outer', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'Wheel Bearing Replacement - Front', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'Wheel Bearing Replacement - Rear', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'ABS Control Module Replacement', 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'ABS Wheel Speed Sensor Replacement', 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'Brake Caliper Replacement - Front', 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'Brake Caliper Replacement - Rear', 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'Brake Master Cylinder Replacement', 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'Fuel Injector Replacement', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'Fuel Pump Replacement', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'Radiator Fan Assembly Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (48, 'Radiator Fan Motor Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (49, 'Radiator Hose Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'Radiator Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (51, 'Thermostat Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (52, 'Water Pump Replacement', 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (53, 'Catalytic Converter Replacement', 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (54, 'Exhaust Manifold Gasket(s) Replacement', 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (55, 'Exhaust Manifold Replacement', 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (56, 'Oxygen Sensor Replacement - Front', 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (57, 'Oxygen Sensor Replacement - Rear', 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (58, 'AC Compressor Replacement', 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (59, 'AC Condenser Replacement', 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (60, 'AC Evaporator Replacement', 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (61, 'AC Recharge', 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (62, 'Engine Cover Issue', 2, '2016-02-12 22:44:55', '2016-02-12 22:44:55');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Kaba Yusuf', 'y_kabs@yahoo.com', '$2y$10$KUQjxW09VeK.1FiLTaoPBOH/NshJ14Z0cGiUcWHVNPojoe.oev7fu', 'vQI6qegzA1NsaSx9PDkkDDUahhzXG5rmIBMIgNm5N7wgan84dBsIohTt136m', NULL, '2016-02-12 23:40:31'),
  (2, 'Segun Obasanjo', 'sobasanjo@yahoo.com', '$2y$10$DOzAOMpo3RBHmBYaywI3NuxZWjNbC/XGvaVvKSkWWBuqUrgTBuGgW', '3yGCZe2D9NTvS5hdCJAR3Zlq9KCPD6QrNDgElQ0jLJuNo3sVP5B46RdUz5ar', '2016-02-09 20:31:31', '2016-02-09 20:32:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `zone`
  --
  
  CREATE TABLE IF NOT EXISTS `zone` (
    `zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `zone` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
    `city_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`zone_id`),
    KEY `fk_city_id_idx` (`city_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=21 ;
  
  --
  -- Dumping data for table `zone`
  --
  
  INSERT INTO `zone` (`zone_id`, `zone`, `city_id`, `created_at`, `updated_at`) VALUES
  (1, 'Agege Zone I', 1, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (2, 'Agege Zone II', 1, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (3, 'Ikeja Zone I', 2, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (4, 'Ikeja Zone II', 2, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (5, 'Yaba Zone I', 3, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (6, 'Yaba Zone II', 3, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (7, 'Surulere Zone I', 4, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (8, 'Surulere Zone II', 4, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (9, 'Iyana Ipaja Zone I', 5, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (10, 'Iyana Ipaja Zone II', 5, '2016-02-06 18:57:52', '2016-02-06 18:57:52'),
  (11, 'Garki Zone I', 6, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (12, 'Garki Zone II', 6, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (13, 'Asokoro Zone I', 7, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (14, 'Asokoro Zone II', 7, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (15, 'Jabi Zone I', 8, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (16, 'Jabi Zone II', 8, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (17, 'Gwagwalada Zone I', 9, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (18, 'Gwagwalada Zone II', 9, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (19, 'Central District Zone I', 10, '2016-02-06 19:00:32', '2016-02-06 19:00:32'),
  (20, 'Central District Zone II', 10, '2016-02-06 19:02:24', '2016-02-06 19:02:24');
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `address`
  --
  ALTER TABLE `address`
    ADD CONSTRAINT `fk_address_zone_id` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`zone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `carmodel`
  --
  ALTER TABLE `carmodel`
    ADD CONSTRAINT `fk_carmake_id` FOREIGN KEY (`carmake_id`) REFERENCES `carmake` (`carmake_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `city`
  --
  ALTER TABLE `city`
    ADD CONSTRAINT `fk_state_id` FOREIGN KEY (`state_id`) REFERENCES `state` (`state_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `rate`
  --
  ALTER TABLE `rate`
    ADD CONSTRAINT `fk_carmodel_id` FOREIGN KEY (`carmodel_id`) REFERENCES `carmodel` (`carmodel_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_repairshop_id` FOREIGN KEY (`repairshop_id`) REFERENCES `repairshop` (`repairshop_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_subcomponent_id` FOREIGN KEY (`subcomponent_id`) REFERENCES `subcomponent` (`subcomponent_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `repairshop`
  --
  ALTER TABLE `repairshop`
    ADD CONSTRAINT `fk_zone_id` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`zone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `subcomponent`
  --
  ALTER TABLE `subcomponent`
    ADD CONSTRAINT `fk_component_id` FOREIGN KEY (`component_id`) REFERENCES `component` (`component_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Constraints for table `zone`
  --
  ALTER TABLE `zone`
    ADD CONSTRAINT `fk_city_id` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  /*!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 */;
  