-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: db
-- Generation Time: Mar 22, 2019 at 12:18 PM
-- Server version: 5.6.41
-- PHP Version: 7.2.8
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: `tobin_dcarfixers`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_users`
--
CREATE TABLE `admin_users` (
`id` int(11) NOT NULL,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`user_type` tinyint(3) NOT NULL COMMENT '1 => Super Admin, 2 => Mechanic',
`display_name` varchar(200) NOT NULL,
`profile_image` varchar(500) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin_users`
--
INSERT INTO `admin_users` (`id`, `username`, `password`, `user_type`, `display_name`, `profile_image`, `status`) VALUES
(1, 'admin', '202cb962ac59075b964b07152d234b70', 1, 'Super Admin', 'assets/uploads/services/1543990056_1523012120_default.png', 1),
(2, 'mechanics', '202cb962ac59075b964b07152d234b70', 2, 'kmjuiju', 'assets/uploads/services/1550042227_Yoshi_(Universal-X).png', 1),
(11, 'cfghbfchdrfg', '97a4aa7bfb0e20d7b9813ffe99f91fd4', 2, 'jiojio', 'assets/uploads/services/1544013534_images.jpg', 1),
(12, 'admin123', '202cb962ac59075b964b07152d234b70', 2, 'Super Hippo', 'assets/uploads/services/1544091403_Himalayan.jpg', 2),
(13, 'jansa', '202cb962ac59075b964b07152d234b70', 1, 'Jensa Mechanic', 'assets/uploads/services/1546851554_234858854male.jpg', 1),
(14, 'mechanic_1', '202cb962ac59075b964b07152d234b70', 2, 'Driver jiol', 'assets/uploads/services/1546929755_1523012036_hj.jpg', 1);
-- --------------------------------------------------------
--
-- Table structure for table `authtable`
--
CREATE TABLE `authtable` (
`id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`authtoken` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `authtable`
--
INSERT INTO `authtable` (`id`, `customer_id`, `authtoken`) VALUES
(1, 15, 'Dcarfixsce4c6f565626b189c050d7e1872bc220541cfd8d'),
(3, 17, 'Dcarfixs770a63377542b51aed33668e53f2736a16d3ef5a'),
(6, 18, 'Dcarfixsb5a5177e87d91dc0bfaa28ab3f09c62855be3a54'),
(8, 3, 'Dcarfixs26f38971326b399ef38e874128b44286f33031bc'),
(9, 8, 'Dcarfixs6552f72521375bfc5f3295d08137a71722c5155e');
-- --------------------------------------------------------
--
-- Table structure for table `bookings`
--
CREATE TABLE `bookings` (
`booking_id` int(13) NOT NULL,
`customer_id` int(13) DEFAULT NULL,
`mechanic_id` int(13) DEFAULT NULL,
`customer_veh_id` int(13) DEFAULT NULL,
`mileage` varchar(25) DEFAULT NULL,
`cost` decimal(10,0) DEFAULT NULL,
`issues_selected` longtext,
`custom_issue_data` longtext,
`scheduled_date` varchar(50) DEFAULT NULL,
`scheduled_time` varchar(50) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0-Pending Approval,1-Accepted,2-Deleted,3-Completed,4-Cancelled,5-Incomplete'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bookings`
--
INSERT INTO `bookings` (`booking_id`, `customer_id`, `mechanic_id`, `customer_veh_id`, `mileage`, `cost`, `issues_selected`, `custom_issue_data`, `scheduled_date`, `scheduled_time`, `status`) VALUES
(1, 3, 13, 40, '', '1500', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"Add notes for General Diagnosis (Please provide description in notes section) (optional) * Add notes for General Diagnosis (Please provide description in notes section) (optional) * Add notes for General Diagnosis (Please provide description in notes section) (optional) * \",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages323012019104623.jpg\",\"assets\\/uploads\\/services\\/optionalImages3230120191046231.jpg\",\"assets\\/uploads\\/services\\/optionalImages3230120191046232.jpg\",\"assets\\/uploads\\/services\\/optionalImages3230120191046233.jpg\"],\"optionalVideos\":[]}', '2019-01-23', '11:00 AM', 3),
(2, 2, 2, 43, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"Add notes for General Diagnosis (Please provide description in notes section) (optional) *\",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages323012019125439.png\"],\"optionalVideos\":[]}', '2019-01-23', '10:00 AM', 0),
(3, 3, 13, 49, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"\",\"optionalImages\":[],\"optionalVideos\":[]}', '2019-01-23', '11:00 AM', 0),
(4, 3, 13, 51, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"DESCRIPTION\\nAdd notes for General Diagnosis (Please provide description in notes section) (optional) *\",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages323012019143335.jpg\"],\"optionalVideos\":[]}', '2019-01-23', '11:00 AM', 0),
(5, 3, 13, 52, '', '700', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"\",\"optionalImages\":[],\"optionalVideos\":[]}', '2019-01-23', '05:00 PM', 0),
(6, 3, 13, 53, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"\",\"optionalImages\":[],\"optionalVideos\":[]}', '2019-01-23', '10:00 AM', 0),
(7, 3, 13, 54, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"\",\"optionalImages\":[],\"optionalVideos\":[]}', '2019-01-23', '12:00 PM', 0),
(8, 3, 13, 55, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"Add notes for General Diagnosis (Please provide description in notes section) (optional) *\",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages323012019144018.png\"],\"optionalVideos\":[]}', '2019-01-23', '11:00 AM', 0),
(9, 3, 13, 56, '', '500', '[{\"issue_id\":\"id of service\",\"issue\":\"name of service\",\"sub_issue_id\":\"id of sub service\",\"issue_category\":\"name of sub service\"},{\"issue_id\":\"id of service\",\"issue\":\"name of service\",\"sub_issue_id\":\"id of sub service\",\"issue_category\":\"name of sub service\"}]', '{\"optionlaDescription\":\"\",\"optionalImages\":[],\"optionalVideos\":[]}', '2019-02-24', '10:00 AM', 0),
(10, 17, 13, 57, '40', '500', 'null', '{\"optionlaDescription\":\"abcd\",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages13022019182314176298-nature-green-leaves-plants-digital_art-floating_island-trees-glass-broken-sphere-grass-rock13.jpg\",\"assets\\/uploads\\/services\\/optionalImages13022019182314639408-download-free-hd-3d-desktop-backgrounds-1920x1080-for-iphone-51.jpg\",\"assets\\/uploads\\/services\\/optionalImages130220191823157040690-desktop-backgrounds-hd14.jpg\",\"assets\\/uploads\\/services\\/optionalImages1302201918231541607821-Little-girl-with-red-umbrella-playing-in-the-rain-Kids-play-outdoors-by-rainy-weather-in-fall-Autumn-Stock-Photo.jpg\"],\"optionalVideos\":[]}', '2019-02-22', '10:00 AM', 5),
(11, 17, NULL, 58, '40', NULL, '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', NULL, NULL, NULL, 5),
(12, 17, NULL, 59, '40', NULL, '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', NULL, NULL, NULL, 5),
(13, 3, 13, 60, '', '400', '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', '{\"optionlaDescription\":\"Add notes for General Diagnosis (Please provide description in notes section) (optional) * Add notes for General Diagnosis (Please provide description in notes section) (optional) * Add notes for General Diagnosis (Please provide description in notes section) (optional) * \",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages330012019143038.jpg\",\"assets\\/uploads\\/services\\/optionalImages3300120191430381.jpg\",\"assets\\/uploads\\/services\\/optionalImages3300120191430382.jpg\",\"assets\\/uploads\\/services\\/optionalImages3300120191430383.jpg\"],\"optionalVideos\":[]}', '2019-01-31', '09:00 AM', 0),
(14, 17, NULL, 61, '40', NULL, '[{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"issue_category\":\"Oil Change\"},{\"issue\":\"Oil Change and General Service\",\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"issue_category\":\"Oil Top Up \"},{\"issue\":\"General Service\",\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"issue_category\":\"General Service L:0\"}]', NULL, NULL, NULL, 5),
(15, 17, NULL, 62, '30 - 32 miles/gallon', NULL, NULL, '{\"optionlaDescription\":\"abcd\",\"optionalImages\":[\"assets\\/uploads\\/services\\/optionalImages15022019112201Yoshi_(Universal-X).png\"],\"optionalVideos\":[]}', NULL, NULL, 5);
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`customer_id` int(20) NOT NULL,
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT NULL,
`country_code` varchar(50) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`address` varchar(500) DEFAULT NULL,
`profile_image` varchar(500) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`date_of_birth` varchar(200) DEFAULT NULL,
`is_otp_verified` int(11) NOT NULL DEFAULT '0' COMMENT '0-not verified,1-verified',
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customers`
--
INSERT INTO `customers` (`customer_id`, `first_name`, `last_name`, `country_code`, `phone`, `email`, `address`, `profile_image`, `password`, `date_of_birth`, `is_otp_verified`, `status`) VALUES
(1, 'Tobin', 'Thomas', '', '9995559194', 'tobin.techware@gmail.com', 'Techware', 'assets/uploads/services/1544417044_sniper.jpg', NULL, '05/05/1994', 0, 1),
(2, 'Tobin', 'Thomas', '', '99955752194', 'tobin8525@gmail.com', 'Techware', 'assets/uploads/services/1545036793_car1.jpg', NULL, '12/20/2018', 0, 1),
(3, 'Tobin', 'Thomas', '', '9993242394', 'tobin@gmail.com', 'Techware', 'assets/uploads/services/3_1393675771-ferrari.jpg', 'e10adc3949ba59abbe56e057f20f883e', '12/11/2018', 0, 1),
(7, 'tobin', 'thomas', '', '9995559194', 'tobin222@gmail.com', NULL, 'assets/uploads/services/1545036793_car1.jpg', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1),
(8, 'tobin', 'thomas', '', '8956235896', 'tobin123@gmail.com', NULL, 'assets/uploads/services/1545036793_car1.jpg', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1),
(9, 'tobin', 'thomas test', '', NULL, 'tobin1586@gmail.com', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1),
(16, 'anu', '', '+91', '9856215874', 'anu.techware@gmail.com', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1),
(17, 'anu', '', '+91', '98562152374', 'anu1.techware@gmail.com', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1),
(18, 'anu', '', '+91', '9857581523', 'anu42.techware@gmail.com', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `customer_vehicle`
--
CREATE TABLE `customer_vehicle` (
`customer_veh_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`car_name` varchar(250) DEFAULT NULL,
`car_model` varchar(150) DEFAULT NULL,
`car_maker` varchar(150) DEFAULT NULL,
`car_model_year` varchar(150) DEFAULT NULL,
`car_vin` varchar(150) DEFAULT NULL,
`vehicle_data` longtext,
`car_location` varchar(250) DEFAULT NULL,
`car_loc_lat` varchar(150) DEFAULT NULL,
`car_loc_lng` varchar(150) DEFAULT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` tinyint(3) NOT NULL DEFAULT '3' COMMENT '0-Inactive,1-Active,2-Deleted,3-Not Saved'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customer_vehicle`
--
INSERT INTO `customer_vehicle` (`customer_veh_id`, `customer_id`, `car_name`, `car_model`, `car_maker`, `car_model_year`, `car_vin`, `vehicle_data`, `car_location`, `car_loc_lat`, `car_loc_lng`, `created_date`, `status`) VALUES
(60, 3, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"\",\"Model\":\"Corolla\",\"Engine\":\"\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-30 09:00:59', 3),
(61, 17, '2018 Honda Corolla', 'Corolla', 'Honda', '2018', NULL, '{\"vehicle\":\"2018 Honda Corolla\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Honda\",\"Trim\":\"dsfds\",\"Model\":\"Corolla\",\"Engine\":\"Tg512\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '76.4521458', '10.247512', '2019-02-06 04:32:47', 3),
(62, 17, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"S\",\"Model\":\"Corolla\",\"Engine\":\"1.8-L L-4 DOHC 16V\"}}', 'kakkand info', '2134', '2433', '2019-02-08 07:17:53', 3),
(56, 3, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"\",\"Model\":\"Corolla\",\"Engine\":\"\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 09:11:12', 3),
(57, 17, '2018 Honda Corolla', 'Corolla', 'Honda', '2018', NULL, '{\"vehicle\":\"2018 Honda Corolla\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Honda\",\"Trim\":\"dsfds\",\"Model\":\"Corolla\",\"Engine\":\"Tg512\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '76.4521458', '10.247512', '2019-01-30 06:52:50', 3),
(58, 17, '2018 Honda Corolla', 'Corolla', 'Honda', '2018', NULL, '{\"vehicle\":\"2018 Honda Corolla\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Honda\",\"Trim\":\"dsfds\",\"Model\":\"Corolla\",\"Engine\":\"Tg512\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '76.4521458', '10.247512', '2019-01-30 06:53:42', 3),
(59, 17, '2018 Honda Corolla', 'Corolla', 'Honda', '2018', NULL, '{\"vehicle\":\"2018 Honda Corolla\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Honda\",\"Trim\":\"dsfds\",\"Model\":\"Corolla\",\"Engine\":\"Tg512\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '76.4521458', '10.247512', '2019-01-30 06:59:03', 3),
(52, 3, '2018 Peugeot 307 SW', '307 SW', 'Peugeot', '2018', NULL, '{\"vehicle\":\"2018 Peugeot 307 SW\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Peugeot\",\"Trim\":\"\",\"Model\":\"307 SW\",\"Engine\":\"\"}}', 'd808 El Camino Real, Burlingame, CA 94010, USA', '37.58087', '-122.3599866', '2019-01-23 09:07:05', 3),
(53, 3, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"\",\"Model\":\"Corolla\",\"Engine\":\"\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 09:07:19', 3),
(54, 3, '2016 Dacia Duster', 'Duster', 'Dacia', '2016', NULL, '{\"vehicle\":\"2016 Dacia Duster\",\"attributes\":{\"Year\":\"2016\",\"Make\":\"Dacia\",\"Trim\":\"\",\"Model\":\"Duster\",\"Engine\":\"\"}}', 'F1563 Princes Hwy, Termeil NSW 2539, Australia', '-35.4853846', '150.3415399', '2019-01-23 09:07:56', 3),
(55, 3, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"\",\"Model\":\"Corolla\",\"Engine\":\"\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 09:10:29', 3),
(51, 3, '2005 Toyota Corolla', 'Corolla', 'Toyota', '2005', NULL, '{\"vehicle\":\"2005 Toyota Corolla\",\"attributes\":{\"Year\":\"2005\",\"Make\":\"Toyota\",\"Trim\":\"\",\"Model\":\"Corolla\",\"Engine\":\"\"}}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 09:03:46', 3),
(49, 3, '2016 Citroën C6', 'C6', 'Citroën', '2016', NULL, '{\"vehicle\":\"2016 Citro\\u00ebn C6\",\"attributes\":{\"Year\":\"2016\",\"Make\":\"Citro\\u00ebn\",\"Trim\":\"\",\"Model\":\"C6\",\"Engine\":\"\"}}', 'Yonge St, Newmarket, ON, Canada', '44.0509919', '-79.4793029', '2019-01-23 08:57:08', 3),
(50, 3, '2005 Toyota Corolla S', 'Corolla', 'Toyota', '2005', '1NXBR32E85Z505904', '{\"vin\":\"1NXBR32E85Z505904\",\"attributes\":{\"VIN\":\"1NXBR32E85Z505904\",\"Year\":\"2005\",\"Make\":\"Toyota\",\"Model\":\"Corolla\",\"Trim\":\"S\",\"Short Trim\":\"S\",\"Trim Variations\":\"S \\/ CE \\/ LE\",\"Made In\":\"America\",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Test Car\",\"Vehicle Size\":\"Compact\",\"Vehicle Category\":\"Compact Cars\",\"Doors\":\"4\",\"Fuel Type\":\"Regular Unleaded\",\"Fuel Capacity\":\"13.20 gallons\",\"City Mileage\":\"30 - 32 miles\\/gallon\",\"Highway Mileage\":\"38 - 41 miles\\/gallon\",\"Engine\":\"1.8-L L-4 DOHC 16V\",\"Engine Size\":\"1.8\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"Manual\",\"Transmission Gears\":\"5\",\"Driven Wheels\":\"Front-Wheel Drive\",\"Anti-Brake System\":\"Non-ABS 4-Wheel ABS\",\"Steering Type\":\"Rack & Pinion\",\"Curb Weight\":\"2590\",\"Gross Weight\":\"\",\"Overall Height\":\"58.50 inches\",\"Overall Length\":\"178.30 inches\",\"Overall Width\":\"66.90 inches\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"$13,563\",\"Delivery Charges\":\"$540\",\"MSRP\":\"$14,990\"},\"success\":true,\"error\":\"\",\"vehicle\":\"2005 Toyota Corolla S\"}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 09:01:15', 1),
(48, 3, '2005 Toyota Corolla S', 'Corolla', 'Toyota', '2005', '1NXBR32E85Z505904', '{\"vin\":\"1NXBR32E85Z505904\",\"attributes\":{\"VIN\":\"1NXBR32E85Z505904\",\"Year\":\"2005\",\"Make\":\"Toyota\",\"Model\":\"Corolla\",\"Trim\":\"S\",\"Short Trim\":\"S\",\"Trim Variations\":\"S \\/ CE \\/ LE\",\"Made In\":\"America\",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Test Car\",\"Vehicle Size\":\"Compact\",\"Vehicle Category\":\"Compact Cars\",\"Doors\":\"4\",\"Fuel Type\":\"Regular Unleaded\",\"Fuel Capacity\":\"13.20 gallons\",\"City Mileage\":\"30 - 32 miles\\/gallon\",\"Highway Mileage\":\"38 - 41 miles\\/gallon\",\"Engine\":\"1.8-L L-4 DOHC 16V\",\"Engine Size\":\"1.8\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"Manual\",\"Transmission Gears\":\"5\",\"Driven Wheels\":\"Front-Wheel Drive\",\"Anti-Brake System\":\"Non-ABS 4-Wheel ABS\",\"Steering Type\":\"Rack & Pinion\",\"Curb Weight\":\"2590\",\"Gross Weight\":\"\",\"Overall Height\":\"58.50 inches\",\"Overall Length\":\"178.30 inches\",\"Overall Width\":\"66.90 inches\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"$13,563\",\"Delivery Charges\":\"$540\",\"MSRP\":\"$14,990\"},\"success\":true,\"error\":\"\",\"vehicle\":\"2005 Toyota Corolla S\"}', 'DFRRI Road, Fimeama, Port Harcourt, Nigeria', '4.7790458', '7.0365156', '2019-01-23 08:54:31', 2),
(47, 3, '2015 Hyundai Sonata', 'Sonata', 'Hyundai', '2015', NULL, '{\"vehicle\":\"2015 Hyundai Sonata\",\"attributes\":{\"Year\":\"2015\",\"Make\":\"Hyundai\",\"Model\":\"Sonata\",\"Trim\":\"\",\"Short Trim\":\"\",\"Trim Variations\":\"\",\"Made In\":\"United States \",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Passenger Car\",\"Vehicle Size\":\"\",\"Vehicle Category\":\"Sedan\",\"Doors\":\"4\",\"Fuel Type\":\"Gasoline\",\"Fuel Capacity\":\"\",\"City Mileage\":\"\",\"Highway Mileage\":\"\",\"Engine\":\"DOHC GDI THETA-II\",\"Engine Size\":\"2.4\",\"Engine Cylinders\":\"\",\"Transmission Type\":\"\",\"Transmission Gears\":\"\",\"Driven Wheels\":\"\",\"Anti-Brake System\":\"\",\"Steering Type\":\"\",\"Curb Weight\":\"\",\"Gross Weight\":\"\",\"Overall Height\":\"\",\"Overall Length\":\"\",\"Overall Width\":\"\",\"Standard Seating\":\"\",\"Optional Seating\":\"\",\"Invoice Price\":\"\",\"Delivery Charges\":\"\",\"MSRP\":\"\"},\"success\":true,\"error\":\"\"}', 'DF-8, 2nd Avenue, DF Block, Sector 1, Salt Lake City, Kolkata, West Bengal 700064, India', '22.5920989', '88.4167945', '2019-01-23 08:51:56', 2),
(46, 3, '2017 Toyota Corolla', 'Corolla', 'Toyota', '2017', NULL, '{\"vehicle\":\"2017 Toyota Corolla\",\"attributes\":{\"Year\":\"2017\",\"Make\":\"Toyota\",\"Model\":\"Corolla\",\"Trim\":\"\",\"Short Trim\":\"\",\"Trim Variations\":\"\",\"Made In\":\"Canada\",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Passenger Car\",\"Vehicle Size\":\"\",\"Vehicle Category\":\"Sedan\",\"Doors\":\"4\",\"Fuel Type\":\"Gasoline\",\"Fuel Capacity\":\"\",\"City Mileage\":\"\",\"Highway Mileage\":\"\",\"Engine\":\"2ZR-FE\",\"Engine Size\":\"1.8\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"\",\"Transmission Gears\":\"\",\"Driven Wheels\":\"4x2\",\"Anti-Brake System\":\"\",\"Steering Type\":\"\",\"Curb Weight\":\"\",\"Gross Weight\":\"\",\"Overall Height\":\"\",\"Overall Length\":\"\",\"Overall Width\":\"\",\"Standard Seating\":\"\",\"Optional Seating\":\"\",\"Invoice Price\":\"\",\"Delivery Charges\":\"\",\"MSRP\":\"\"},\"success\":true,\"error\":\"\"}', 'V US-6, Walkerton, IN 46574, USA', '41.4669876', '-86.5005615', '2019-01-23 08:32:45', 2),
(45, 3, '2005 Toyota Corolla S', 'Corolla', 'Toyota', '2005', '1NXBR32E85Z505904', '{\"vin\":\"1NXBR32E85Z505904\",\"attributes\":{\"VIN\":\"1NXBR32E85Z505904\",\"Year\":\"2005\",\"Make\":\"Toyota\",\"Model\":\"Corolla\",\"Trim\":\"S\",\"Short Trim\":\"S\",\"Trim Variations\":\"S \\/ CE \\/ LE\",\"Made In\":\"America\",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Test Car\",\"Vehicle Size\":\"Compact\",\"Vehicle Category\":\"Compact Cars\",\"Doors\":\"4\",\"Fuel Type\":\"Regular Unleaded\",\"Fuel Capacity\":\"13.20 gallons\",\"City Mileage\":\"30 - 32 miles\\/gallon\",\"Highway Mileage\":\"38 - 41 miles\\/gallon\",\"Engine\":\"1.8-L L-4 DOHC 16V\",\"Engine Size\":\"1.8\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"Manual\",\"Transmission Gears\":\"5\",\"Driven Wheels\":\"Front-Wheel Drive\",\"Anti-Brake System\":\"Non-ABS 4-Wheel ABS\",\"Steering Type\":\"Rack & Pinion\",\"Curb Weight\":\"2590\",\"Gross Weight\":\"\",\"Overall Height\":\"58.50 inches\",\"Overall Length\":\"178.30 inches\",\"Overall Width\":\"66.90 inches\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"$13,563\",\"Delivery Charges\":\"$540\",\"MSRP\":\"$14,990\"},\"success\":true,\"error\":\"\",\"vehicle\":\"2005 Toyota Corolla S\"}', 'F1563 Princes Hwy, Termeil NSW 2539, Australia', '-35.4853846', '150.3415399', '2019-01-23 08:32:19', 2),
(43, 3, '2017 Hyundai Sonata', 'Sonata', 'Hyundai', '2017', NULL, '{\"vehicle\":\"2017 Hyundai Sonata\",\"attributes\":{\"Year\":\"2017\",\"Make\":\"Hyundai\",\"Trim\":\"\",\"Model\":\"Sonata\",\"Engine\":\"\"}}', 'Broadway, New York, USA', '40.908288', '-73.896564', '2019-01-23 07:24:51', 3),
(44, 3, '2018 Hyundai Sonata', 'Sonata', 'Hyundai', '2018', NULL, '{\"vehicle\":\"2018 Hyundai Sonata\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Hyundai\",\"Model\":\"Sonata\",\"Trim\":\"\",\"Short Trim\":\"\",\"Trim Variations\":\"\",\"Made In\":\"United States \",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Passenger Car\",\"Vehicle Size\":\"\",\"Vehicle Category\":\"Sedan\",\"Doors\":\"4\",\"Fuel Type\":\"Gasoline\",\"Fuel Capacity\":\"\",\"City Mileage\":\"\",\"Highway Mileage\":\"\",\"Engine\":\"GDI THETA-II\",\"Engine Size\":\"2.4\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"\",\"Transmission Gears\":\"\",\"Driven Wheels\":\"FWD\\/Front Wheel Drive\",\"Anti-Brake System\":\"Standard\",\"Steering Type\":\"\",\"Curb Weight\":\"\",\"Gross Weight\":\"\",\"Overall Height\":\"\",\"Overall Length\":\"\",\"Overall Width\":\"\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"\",\"Delivery Charges\":\"\",\"MSRP\":\"\"},\"success\":true,\"error\":\"\"}', 'X US-64, Farmington, NM 87401, USA', '36.7151849', '-108.1481245', '2019-01-23 08:27:20', 2),
(42, 3, '2017 Hyundai Sonata', 'Sonata', 'Hyundai', '2017', NULL, '{\"vehicle\":\"2017 Hyundai Sonata\",\"attributes\":{\"Year\":\"2017\",\"Make\":\"Hyundai\",\"Model\":\"Sonata\",\"Trim\":\"\",\"Short Trim\":\"\",\"Trim Variations\":\"\",\"Made In\":\"South Korea\",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Sedan\",\"Vehicle Size\":\"\",\"Vehicle Category\":\"Sedan\",\"Doors\":\"4\",\"Fuel Type\":\"Regular Unleaded\",\"Fuel Capacity\":\"18.5 gallons\",\"City Mileage\":\"25 miles\\/gallon\",\"Highway Mileage\":\"36 miles\\/gallon\",\"Engine\":\"Regular Unleaded I-4 2.4 L\\/144\",\"Engine Size\":\"2.4\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"Automatic w\\/OD\",\"Transmission Gears\":\"\",\"Driven Wheels\":\"Front-Wheel Drive\",\"Anti-Brake System\":\"4-Wheel ABS\",\"Steering Type\":\"\",\"Curb Weight\":\"3250\",\"Gross Weight\":\"\",\"Overall Height\":\"58.1 inches\",\"Overall Length\":\"191.1 inches\",\"Overall Width\":\"73.4 inches\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"\",\"Delivery Charges\":\"\",\"MSRP\":\"\"},\"success\":true,\"error\":\"\"}', 'Broadway, New York, USA', '40.908288', '-73.896564', '2019-01-23 07:16:43', 2),
(41, 3, '2018 Hyundai Sonata', 'Sonata', 'Hyundai', '2018', NULL, '{\"vehicle\":\"2018 Hyundai Sonata\",\"attributes\":{\"Year\":\"2018\",\"Make\":\"Hyundai\",\"Model\":\"Sonata\",\"Trim\":\"\",\"Short Trim\":\"\",\"Trim Variations\":\"\",\"Made In\":\"United States \",\"Vehicle Style\":\"\",\"Vehicle Type\":\"Passenger Car\",\"Vehicle Size\":\"\",\"Vehicle Category\":\"Sedan\",\"Doors\":\"4\",\"Fuel Type\":\"Gasoline\",\"Fuel Capacity\":\"\",\"City Mileage\":\"\",\"Highway Mileage\":\"\",\"Engine\":\"GDI THETA-II\",\"Engine Size\":\"2.4\",\"Engine Cylinders\":\"4\",\"Transmission Type\":\"\",\"Transmission Gears\":\"\",\"Driven Wheels\":\"FWD\\/Front Wheel Drive\",\"Anti-Brake System\":\"Standard\",\"Steering Type\":\"\",\"Curb Weight\":\"\",\"Gross Weight\":\"\",\"Overall Height\":\"\",\"Overall Length\":\"\",\"Overall Width\":\"\",\"Standard Seating\":\"5\",\"Optional Seating\":\"\",\"Invoice Price\":\"\",\"Delivery Charges\":\"\",\"MSRP\":\"\"},\"success\":true,\"error\":\"\"}', 'Tr??c 71 Hai Bà Tr?ng, C?a Nam, Hoàn Ki?m, Hà N?i, Vietnam', '21.027065', '105.843043', '2019-01-23 05:43:03', 2),
(40, 3, '2017 Dacia Duster', 'Duster', 'Dacia', '2017', NULL, '{\"vehicle\":\"2017 Dacia Duster\",\"attributes\":{\"Year\":\"2017\",\"Make\":\"Dacia\",\"Trim\":\"\",\"Model\":\"Duster\",\"Engine\":\"\"}}', 'F1563 Princes Hwy, Termeil NSW 2539, Australia', '-35.4853846', '150.3415399', '2019-01-23 05:16:35', 3);
-- --------------------------------------------------------
--
-- Table structure for table `custom_quote`
--
CREATE TABLE `custom_quote` (
`custom_id` int(11) NOT NULL,
`booking_id` int(11) DEFAULT NULL,
`custom_service_quote` longtext,
`custom_amount` double DEFAULT NULL,
`status` tinyint(3) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `custom_quote`
--
INSERT INTO `custom_quote` (`custom_id`, `booking_id`, `custom_service_quote`, `custom_amount`, `status`) VALUES
(2, 1, '[{\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"description\":\"fgh\",\"amount\":\"54\"},{\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"description\":\"fghfg\",\"amount\":\"45\"},{\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"description\":\"h\",\"amount\":\"45\"}]', 144, 1),
(3, 2, '[{\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"description\":\"gyhu\",\"amount\":\"452\"},{\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"description\":\"ghju\",\"amount\":\"45345\"},{\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"description\":\"ghj\",\"amount\":\"4532\"}]', 50329, 1),
(4, 3, '[{\"issue_id\":\"11\",\"sub_issue_id\":\"7\",\"description\":\"yui\",\"amount\":\"67\"},{\"issue_id\":\"11\",\"sub_issue_id\":\"8\",\"description\":\"uyiy\",\"amount\":\"676\"},{\"issue_id\":\"12\",\"sub_issue_id\":\"9\",\"description\":\"yiuyiyui\",\"amount\":\"67\"}]', 810, 1);
-- --------------------------------------------------------
--
-- Table structure for table `forgot_password_link`
--
CREATE TABLE `forgot_password_link` (
`id` int(11) NOT NULL,
`user_type` tinyint(3) DEFAULT NULL COMMENT '1=>Customer 2=>Mechanic',
`user_id` int(11) DEFAULT NULL,
`token` varchar(500) DEFAULT NULL,
`created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `forgot_password_link`
--
INSERT INTO `forgot_password_link` (`id`, `user_type`, `user_id`, `token`, `created_date`, `status`) VALUES
(1, 1, NULL, '7e07594058e29d84ce3ff26e4b283fc3', '2018-12-30 13:12:20', 1),
(2, 1, 3, '747e195179012d145766f9ea9ee1f4aa', '2018-12-30 13:12:49', 1),
(3, 1, 3, '08be0c60b807ba994ca520d4c4f2d083', '2018-12-30 14:55:25', 1),
(4, 1, 3, '460fce2846e4bb57241d44745ede1482', '2018-12-31 08:56:06', 1);
-- --------------------------------------------------------
--
-- Table structure for table `issues`
--
CREATE TABLE `issues` (
`issue_id` int(11) NOT NULL,
`issue` varchar(500) NOT NULL,
`issue_image` varchar(500) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0-Inactive,1-Active,2-Delete'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `issues`
--
INSERT INTO `issues` (`issue_id`, `issue`, `issue_image`, `status`) VALUES
(9, 'Wheel Maintenance', 'assets/uploads/services/images8.jpg', 2),
(10, 'AC Maintenance', 'assets/uploads/services/car_ac.jpg', 2),
(11, 'Oil Change and General Service', 'assets/uploads/services/Vector_Smart_Object@3x.png', 1),
(12, 'General Service', 'assets/uploads/services/Vector_Smart_Object@3x3.png', 1),
(13, 'Oil Change and General Service (Free Water Service and Polishing).', 'assets/uploads/services/Vector_Smart_Object@3x2.png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `issues_category`
--
CREATE TABLE `issues_category` (
`issue_cat_id` int(11) NOT NULL,
`issue_id` int(11) DEFAULT NULL,
`issue_category` varchar(500) DEFAULT NULL,
`issue_cat_image` varchar(500) DEFAULT NULL,
`default_service_fee` double DEFAULT NULL,
`default_description` longtext,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0-Inactive,1-Active,2-Delete'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `issues_category`
--
INSERT INTO `issues_category` (`issue_cat_id`, `issue_id`, `issue_category`, `issue_cat_image`, `default_service_fee`, `default_description`, `status`) VALUES
(7, 11, 'Oil Change', 'assets/uploads/services/Twitch_KingpinSkin_old2_HD.jpg', 1500, 'Oil Change and general service with free water service. Oil Change and general service with free water service. Oil Change and general service with free water service. ', 1),
(8, 11, 'Oil Top Up ', 'assets/uploads/services/Himalayan1.jpg', 500, 'Oil Top Up and general service with free water service. ', 1),
(9, 12, 'General Service L:0', 'assets/uploads/services/park-512.png', 700, 'With out Water Service and Polishing. With out Water Service and Polishing. With out Water Service and Polishing. With out Water Service and Polishing. ', 1),
(10, 12, 'General Service L:1', 'assets/uploads/services/car.jpg', 700, 'Free Water Service and Polishing. Free Water Service and Polishing. Free Water Service and Polishing. Free Water Service and Polishing. ', 1),
(11, 13, 'Oil Change and General Service', 'assets/uploads/services/orig.jpg', 1500, 'Oil Change and General Service without free water service. Oil Change and General Service without free water service. Oil Change and General Service without free water service. ', 1),
(12, 13, 'Oil Change and General Service', 'assets/uploads/services/Audi-r8.jpg', 580, 'Oil Change and General Service', 1);
-- --------------------------------------------------------
--
-- Table structure for table `mechanic`
--
CREATE TABLE `mechanic` (
`id` int(11) NOT NULL,
`mechanic_id` int(11) NOT NULL,
`shop_id` int(11) NOT NULL DEFAULT '0',
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT NULL,
`email_id` varchar(250) NOT NULL,
`phone` varchar(15) NOT NULL,
`address` varchar(250) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`state` varchar(200) DEFAULT NULL,
`licence` varchar(500) NOT NULL,
`licence_number` varchar(250) DEFAULT NULL,
`licence_exp_date` varchar(250) DEFAULT NULL,
`location` varchar(250) DEFAULT NULL,
`location_lat` varchar(30) DEFAULT NULL,
`location_lng` varchar(30) DEFAULT NULL,
`start_time` varchar(250) DEFAULT NULL,
`end_time` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mechanic`
--
INSERT INTO `mechanic` (`id`, `mechanic_id`, `shop_id`, `first_name`, `last_name`, `email_id`, `phone`, `address`, `city`, `state`, `licence`, `licence_number`, `licence_exp_date`, `location`, `location_lat`, `location_lng`, `start_time`, `end_time`) VALUES
(1, 2, 0, 'ol', 'lk', 'tobin.tobi554@gmail.com', '9995559194', 'Techware Software Solution', 'Ernakulam', 'Kerala', 'assets/uploads/services/1546929651_1523012036_hj.jpg', 'LI000515456', '01/29/2019', 'FL, USA', '27.6648274', '-81.5157535', '10:00', '17:00'),
(5, 11, 0, 'uiou', 'ouji8o', 'lnkjlare@gmail.com', '34653456344456', 'Techware', 'Aiea', 'Hawaii', 'assets/uploads/services/1544091718_sniper.jpg', 'dfrgdersgt', '12/13/2018', 'Fort Lauderdale, FL, USA', '26.1224386', '-80.1373174', '06:30', '13:55'),
(6, 12, 0, 'Driver', 'john', '5545123@gmail.com', '9995551234', 'Techware', 'Aiea', 'Hawaii', 'assets/uploads/services/1544091568_1523012036_hj.jpg', 'LI00051545', '12/25/2018', NULL, NULL, NULL, NULL, NULL),
(7, 13, 0, 'Jensa', 'Jose', 'jensa@gmail.com', '9995559856', 'Techware', 'Aiea', 'Hawaii', 'assets/uploads/services/1546851554_1523012036_hj.jpg', 'LI0005154', '01/30/2019', 'Grand Rapids, MI, USA', '42.9633599', '-85.6680863', '08:00', '20:00'),
(8, 14, 0, 'Driver', 'jio', 'tobin.techware@gmail.com', '9934534594', 'Techware', 'Aiea', 'Hawaii', 'assets/uploads/services/1546929755_1523012036_hj1.jpg', 'LI000515456', '01/29/2019', 'J K O\'Donnell\'s, West Wayne Street, Fort Wayne, IN, USA', '41.0780191', '-85.1402719', '10:00', '17:00');
-- --------------------------------------------------------
--
-- Table structure for table `mechanic_issues`
--
CREATE TABLE `mechanic_issues` (
`id` int(11) NOT NULL,
`issue_id` int(11) DEFAULT NULL,
`issue_cat_id` int(11) DEFAULT NULL,
`mechanic_id` int(11) DEFAULT NULL,
`custom_description` longtext,
`custom_service_fee` double NOT NULL DEFAULT '0',
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mechanic_issues`
--
INSERT INTO `mechanic_issues` (`id`, `issue_id`, `issue_cat_id`, `mechanic_id`, `custom_description`, `custom_service_fee`, `status`) VALUES
(20, 9, NULL, 2, NULL, 0, 2),
(21, 11, NULL, 2, NULL, 0, 2),
(22, 11, NULL, 2, NULL, 0, 2),
(23, 10, NULL, 2, NULL, 0, 2),
(24, 11, 7, 13, '!@#$%^ N Oil Change and general service with free water service. Oil Change and general service with free water service. Oil Change and general service with free water service. ', 400, 1),
(25, 11, 8, 13, '!@#$%^ N Oil Top Up and general service with free water service. ', 400, 1),
(26, 11, NULL, 2, NULL, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `mechanic_shop`
--
CREATE TABLE `mechanic_shop` (
`shop_id` int(11) NOT NULL,
`shop_name` varchar(250) NOT NULL,
`address` varchar(500) NOT NULL,
`phone` varchar(15) NOT NULL,
`email_id` varchar(150) NOT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mechanic_shop`
--
INSERT INTO `mechanic_shop` (`shop_id`, `shop_name`, `address`, `phone`, `email_id`, `status`) VALUES
(1, 'Mechanic Shop', 'Kakkanad', '9995559194', 'tobin@gmail.com', 1),
(2, 'New Shop 1', 'Techware', '9995559194', 'tobin.techware@gmail.com', 1);
-- --------------------------------------------------------
--
-- Table structure for table `setting`
--
CREATE TABLE `setting` (
`id` int(11) NOT NULL,
`title` varchar(250) NOT NULL,
`title_short` varchar(250) NOT NULL,
`site_logo` varchar(150) NOT NULL,
`fav_icon` varchar(150) NOT NULL,
`country_flag` varchar(10) NOT NULL DEFAULT 'US',
`currency` varchar(10) NOT NULL,
`smtp_host` varchar(150) NOT NULL,
`smtp_username` varchar(150) NOT NULL,
`smtp_password` varchar(150) NOT NULL,
`google_api_key` varchar(500) DEFAULT NULL,
`vin_audit_url` varchar(500) DEFAULT NULL,
`vin_audit_api` varchar(500) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `setting`
--
INSERT INTO `setting` (`id`, `title`, `title_short`, `site_logo`, `fav_icon`, `country_flag`, `currency`, `smtp_host`, `smtp_username`, `smtp_password`, `google_api_key`, `vin_audit_url`, `vin_audit_api`) VALUES
(1, 'Dcarfixxers', 'Dcar', 'assets/uploads/services/1549257477_Twitch_KingpinSkin_old2_HD.jpg', 'assets/uploads/services/1549257477_sniper.jpg', 'US', 'USD', 'info@techlabz.in', 'AIzaSyC9JX3BZZfx2S6GQieC_PqjuJdUbZ7_wyM1', 'Golden_1234', 'AIzaSyCcc-YDSJyDpehNE6qfntfWpEQ4uS4aq6A', 'https://specifications.vinaudit.com/getspecifications.php', 'VA_DEMO_KEY');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `authtable`
--
ALTER TABLE `authtable`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
ADD PRIMARY KEY (`booking_id`);
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`customer_id`);
--
-- Indexes for table `customer_vehicle`
--
ALTER TABLE `customer_vehicle`
ADD PRIMARY KEY (`customer_veh_id`);
--
-- Indexes for table `custom_quote`
--
ALTER TABLE `custom_quote`
ADD PRIMARY KEY (`custom_id`);
--
-- Indexes for table `forgot_password_link`
--
ALTER TABLE `forgot_password_link`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `issues`
--
ALTER TABLE `issues`
ADD PRIMARY KEY (`issue_id`);
--
-- Indexes for table `issues_category`
--
ALTER TABLE `issues_category`
ADD PRIMARY KEY (`issue_cat_id`);
--
-- Indexes for table `mechanic`
--
ALTER TABLE `mechanic`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mechanic_issues`
--
ALTER TABLE `mechanic_issues`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mechanic_shop`
--
ALTER TABLE `mechanic_shop`
ADD PRIMARY KEY (`shop_id`);
--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `authtable`
--
ALTER TABLE `authtable`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
MODIFY `booking_id` int(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `customer_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `customer_vehicle`
--
ALTER TABLE `customer_vehicle`
MODIFY `customer_veh_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
--
-- AUTO_INCREMENT for table `custom_quote`
--
ALTER TABLE `custom_quote`
MODIFY `custom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `forgot_password_link`
--
ALTER TABLE `forgot_password_link`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `issues`
--
ALTER TABLE `issues`
MODIFY `issue_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `issues_category`
--
ALTER TABLE `issues_category`
MODIFY `issue_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `mechanic`
--
ALTER TABLE `mechanic`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `mechanic_issues`
--
ALTER TABLE `mechanic_issues`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `mechanic_shop`
--
ALTER TABLE `mechanic_shop`
MODIFY `shop_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;