-- http://www.phpmyadmin.net
--




--
-- Database: `superride_prod`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`sa`@`localhost` PROCEDURE `Admin_users_list`(IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `order_col` VARCHAR(100), IN `order_type` INT, IN `search_status` INT, IN `keyword` VARCHAR(30), IN `defaultPic` VARCHAR(191), IN `date1` VARCHAR(30), IN `date2` VARCHAR(30), IN `countryID` INT, IN `cityID` INT, IN `sortBy` INT, IN `off_val` INT, IN `per_page` INT)
    NO SQL
SELECT DISTINCT users.id, users.email, users.country_code, users.phone, users.created_at, users.active, users.social_provider_type, 
CASE
	WHEN users.profile_pic='' OR users.profile_pic IS null OR users.profile_pic='0' THEN defaultPic
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS pro_pic_url,
(SELECT count(*) FROM joinees WHERE joinees.user_id=users.id) AS joinees_count,
(SELECT count(*) FROM post_ads WHERE post_ads.user_id=users.id) AS ads_count,
(SELECT count(*) FROM reviews WHERE reviews.user_id=users.id) AS reviews_count,
users.user_type
FROM users
LEFT JOIN joinees ON joinees.user_id = users.id
LEFT JOIN post_ads ON post_ads.user_id = users.id
LEFT JOIN reviews ON reviews.user_id = users.id
WHERE 
users.user_type = utype
AND
CASE 
	WHEN search_status=1 THEN users.name LIKE CONCAT('%', keyword , '%') OR users.email LIKE CONCAT('%', keyword , '%') OR  users.phone LIKE CONCAT('%', keyword , '%')
    ELSE users.id IS NOT NULL
END 
AND
CASE
	WHEN date1 !='0' AND date2 = '0' THEN DATE(users.created_at) = date1
    WHEN date1 !='0' AND date2 != '0' THEN DATe(users.created_at) BETWEEN date1 AND date2
    ELSE users.created_at IS NOT null
END
ORDER BY  
CASE WHEN order_type=1 THEN order_col END ASC,
CASE WHEN order_type=2 THEN order_col END DESC
LIMIT per_page OFFSET off_val$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(191))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id, bookings.pickup_lat, bookings.pickup_lng, 

bookings.pickup_add, bookings.drop_lat, bookings.drop_lng, bookings.drop_add, 
CASE
	WHEN bookings.ride_type = '1' THEN bookings.pickup_at
    ELSE bookings.created_at
END AS booking_date, 
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status, car_categories.name AS car_name, CONCAT

(baseUrl,'public/car_categ/',car_categories.selected_icon) AS car_img,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE WHEN drivers.license_plate_number IS null THEN '' ELSE drivers.license_plate_number END AS 

license_plate_number,
CASE WHEN drivers.veh_model IS null THEN '' ELSE drivers.veh_model END AS veh_model,
CASE WHEN drivers.vehicle_make IS null THEN '' ELSE drivers.vehicle_make END AS vehicle_make,
CASE WHEN bookings.pickup_at IS null THEN '' ELSE bookings.pickup_at END AS pickup_at,
CASE WHEN bookings.drop_at IS null THEN '' ELSE bookings.drop_at END AS drop_at,
CASE WHEN drivers.direction IS null THEN '' ELSE drivers.direction END AS direction,
car_categories.no_of_seats, 
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic,CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS 

payable_amount, bookings.drop_at, bookings.pickup_at, bookings.payment_method, drivers.cur_lng AS 

driver_lng, drivers.cur_lat AS driver_lat,
ROUND((SELECT AVG(rating) FROM feedback WHERE driver_id=users.id),1) AS avg_rating, users.id AS driver_id, 

bookings.otp, CASE WHEN bookings.instructions IS null THEN '' ELSE bookings.instructions END AS 

instructions, drivers.is_ride, bookings.ride_type, bookings.name AS for_name, 

bookings.driver_comm_amount, bookings.bsu_comm_amount, bookings.is_fav, bookings.is_other, users.country_code AS driver_ccode, users.phone AS driver_phone
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.user_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.status != '8' AND bookings.status != '3' AND bookings.status != '13'
END AND bookings.status !='1' AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' AND bookings.cancelled_show = '0' THEN 

bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN is_bs = '1' THEN bookings.is_other = '1'
    WHEN is_bs = '2' THEN bookings.status = '6' AND bookings.is_other = '1'
    ELSE bookings.is_other != '1'
END AND
CASE
	WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) = date1
    
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    
    ELSE bookings.id IS NOT null
END AND bookings.status != '0'
GROUP BY bookings.id
ORDER BY bookings.id DESC
LIMIT 10 OFFSET offval$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_count`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(191))
    NO SQL
SELECT bookings.id AS request_id
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.user_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.status != '8' AND bookings.status != '3' AND bookings.status != '13'
END AND bookings.status !='1' AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' AND bookings.cancelled_show = '0' THEN 

bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN is_bs = '1' THEN bookings.is_other = '1'

    WHEN is_bs = '2' THEN bookings.status = '6' AND bookings.is_other = '1'
    ELSE bookings.is_other != '1'
END AND
CASE
	WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) = date1
    
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    
    ELSE bookings.id IS NOT null
END
GROUP BY bookings.id
ORDER BY bookings.id DESC$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `Booking_list_details`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(191))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id, bookings.pickup_lat, bookings.pickup_lng, 

bookings.pickup_add, bookings.drop_lat, bookings.drop_lng, bookings.drop_add, 
CASE
	WHEN bookings.ride_type = '1' THEN bookings.pickup_at
    ELSE bookings.created_at
END AS booking_date, 
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status, car_categories.name AS car_name, CONCAT

(baseUrl,'public/car_categ/',car_categories.selected_icon) AS car_img,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE WHEN drivers.license_plate_number IS null THEN '' ELSE drivers.license_plate_number END AS 

license_plate_number,
CASE WHEN drivers.veh_model IS null THEN '' ELSE drivers.veh_model END AS veh_model,
CASE WHEN drivers.vehicle_make IS null THEN '' ELSE drivers.vehicle_make END AS vehicle_make,
CASE WHEN bookings.pickup_at IS null THEN '' ELSE bookings.pickup_at END AS pickup_at,
CASE WHEN bookings.drop_at IS null THEN '' ELSE bookings.drop_at END AS drop_at,
CASE WHEN drivers.direction IS null THEN '' ELSE drivers.direction END AS direction,
car_categories.no_of_seats, 
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic,CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS 

payable_amount, bookings.drop_at, bookings.pickup_at, bookings.payment_method, drivers.cur_lng AS 

driver_lng, drivers.cur_lat AS driver_lat,
ROUND((SELECT AVG(rating) FROM feedback WHERE driver_id=users.id),1) AS avg_rating, users.id AS driver_id, 

bookings.otp, CASE WHEN bookings.instructions IS null THEN '' ELSE bookings.instructions END AS 

instructions, drivers.is_ride, bookings.ride_type, bookings.name AS for_name, 

bookings.driver_comm_amount, bookings.bsu_comm_amount, bookings.is_fav, bookings.is_other
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.user_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 

CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.status != '8' AND bookings.status != '3' AND bookings.status != '13'
END
LIMIT 1 OFFSET offval$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_driver`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(191))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id, bookings.pickup_lat, bookings.pickup_lng, bookings.pickup_add, bookings.drop_lat, bookings.drop_lng, bookings.drop_add, bookings.created_at AS booking_date, 
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status, car_categories.name AS car_name, CONCAT(baseUrl,'public/car_categ/',car_categories.selected_icon) AS car_img,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE WHEN drivers.license_plate_number IS null THEN '' ELSE drivers.license_plate_number END AS license_plate_number,
CASE WHEN drivers.veh_model IS null THEN '' ELSE drivers.veh_model END AS veh_model,
CASE WHEN drivers.vehicle_make IS null THEN '' ELSE drivers.vehicle_make END AS vehicle_make,
CASE WHEN bookings.pickup_at IS null THEN '' ELSE bookings.pickup_at END AS pickup_at,
CASE WHEN bookings.drop_at IS null THEN '' ELSE bookings.drop_at END AS drop_at,
CASE WHEN drivers.direction IS null THEN '' ELSE drivers.direction END AS direction,
car_categories.no_of_seats, 
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic,CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS payable_amount, bookings.drop_at, bookings.pickup_at, bookings.payment_method, drivers.cur_lng AS driver_lng, drivers.cur_lat AS driver_lat,
ROUND((SELECT AVG(rating) FROM feedback WHERE driver_id=users.id),1) AS avg_rating, users.id AS driver_id, bookings.otp, CASE WHEN bookings.instructions IS null THEN '' ELSE bookings.instructions END AS 
instructions, drivers.is_ride, bookings.ride_type, bookings.name AS for_name, bookings.driver_comm_amount, bookings.bsu_comm_amount, bookings.plan_type, bookings.is_fav, bookings.is_other
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.user_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.status != '8' AND bookings.status != '3' AND bookings.status != '13'
END AND bookings.status !='1' AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' AND bookings.cancelled_show = '0' THEN 

bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) = date1
    
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    
    ELSE bookings.id IS NOT null
END AND bookings.status != '0'
GROUP BY bookings.id
ORDER BY bookings.id DESC
LIMIT 10 OFFSET offval$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_driver_earning`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(191))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id, bookings.pickup_lat, bookings.pickup_lng, bookings.pickup_add, bookings.drop_lat, bookings.drop_lng, bookings.drop_add, bookings.created_at AS booking_date, 
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status, car_categories.name AS car_name, CONCAT(baseUrl,'public/car_categ/',car_categories.selected_icon) AS car_img,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE WHEN drivers.license_plate_number IS null THEN '' ELSE drivers.license_plate_number END AS license_plate_number,
CASE WHEN drivers.veh_model IS null THEN '' ELSE drivers.veh_model END AS veh_model,
CASE WHEN drivers.vehicle_make IS null THEN '' ELSE drivers.vehicle_make END AS vehicle_make,
CASE WHEN bookings.pickup_at IS null THEN '' ELSE bookings.pickup_at END AS pickup_at,
CASE WHEN bookings.drop_at IS null THEN '' ELSE bookings.drop_at END AS drop_at,
CASE WHEN drivers.direction IS null THEN '' ELSE drivers.direction END AS direction,
car_categories.no_of_seats, 
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic,CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS payable_amount, bookings.drop_at, bookings.pickup_at, bookings.payment_method, drivers.cur_lng AS driver_lng, drivers.cur_lat AS driver_lat,
ROUND((SELECT AVG(rating) FROM feedback WHERE driver_id=users.id),1) AS avg_rating, users.id AS driver_id, bookings.otp, CASE WHEN bookings.instructions IS null THEN '' ELSE bookings.instructions END AS 
instructions, drivers.is_ride, bookings.ride_type, bookings.name AS for_name, bookings.driver_comm_amount, bookings.bsu_comm_amount, bookings.plan_type, bookings.is_fav, bookings.price_tip
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.user_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.status = '6'
END AND bookings.status !='1' AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' AND bookings.cancelled_show = '0' THEN 

bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) = date1
    
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '1' THEN DATE(ADDTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '0' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 AND date2
    WHEN date_type = '2' AND bookings.ride_type = '1' AND add_sub_type = '2' THEN DATE(SUBTIME(bookings.pickup_at,timeZone)) BETWEEN date1 AND date2
    
    ELSE bookings.id IS NOT null
END
GROUP BY bookings.id
ORDER BY bookings.id DESC
LIMIT 10 OFFSET offval$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_reviews_based`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(100))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id,
CASE WHEN bookings.ride_type = 0 THEN bookings.created_at ELSE CONCAT(bookings.ride_date,' ',bookings.ride_time) END AS booking_date,
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic, CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS payable_amount, bookings.payment_method, drivers.cur_lng AS driver_lng, drivers.cur_lat AS driver_lat,
(SELECT AVG(rating) FROM feedback WHERE driver_id=users.id) AS avg_rating, users.id AS driver_id
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.id IS NOT null
END AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' THEN bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN date_type = '1' AND add_sub_type = 1 AND bookings.ride_type = 0 THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND add_sub_type = 2 AND bookings.ride_type = 0 THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '2' and add_sub_type = 1 AND bookings.ride_type = 0 THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 and date2
    WHEN date_type = '2' and add_sub_type = 2 AND bookings.ride_type = 0 THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 and date2
    
    WHEN date_type = '1' AND add_sub_type = 1 AND bookings.ride_type = 1 THEN DATE(ADDTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) = date1
    WHEN date_type = '1' AND add_sub_type = 2 AND bookings.ride_type = 1 THEN DATE(SUBTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) = date1
    WHEN date_type = '2' and add_sub_type = 1 AND bookings.ride_type = 1 THEN DATE(ADDTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) BETWEEN date1 and date2
    WHEN date_type = '2' and add_sub_type = 2 AND bookings.ride_type = 1 THEN DATE(SUBTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) BETWEEN date1 and date2
    
    ELSE bookings.id IS NOT null
END
ORDER BY bookings.id DESC
LIMIT 10 OFFSET offval$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_reviews_based_count`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `add_sub_type` INT, IN `timeZone` VARCHAR(100))
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id,
CASE WHEN bookings.ride_type = 0 THEN bookings.created_at ELSE CONCAT(bookings.ride_date,' ',bookings.ride_time) END AS booking_date,
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic, CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS payable_amount, bookings.payment_method, drivers.cur_lng AS driver_lng, drivers.cur_lat AS driver_lat,
(SELECT AVG(rating) FROM feedback WHERE driver_id=users.id) AS avg_rating, users.id AS driver_id
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.id IS NOT null
END AND bookings.driver_id IS NOT null AND
CASE
	WHEN drivers.is_ride = '0' AND booking_id!='0' THEN bookings.status != '7'
    ELSE bookings.status IS NOT null
END AND
CASE
	WHEN date_type = '1' AND add_sub_type = 1 AND bookings.ride_type = 0 THEN DATE(ADDTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '1' AND add_sub_type = 2 AND bookings.ride_type = 0 THEN DATE(SUBTIME(bookings.created_at,timeZone)) = date1
    WHEN date_type = '2' and add_sub_type = 1 AND bookings.ride_type = 0 THEN DATE(ADDTIME(bookings.created_at,timeZone)) BETWEEN date1 and date2
    WHEN date_type = '2' and add_sub_type = 2 AND bookings.ride_type = 0 THEN DATE(SUBTIME(bookings.created_at,timeZone)) BETWEEN date1 and date2
    
    WHEN date_type = '1' AND add_sub_type = 1 AND bookings.ride_type = 1 THEN DATE(ADDTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) = date1
    WHEN date_type = '1' AND add_sub_type = 2 AND bookings.ride_type = 1 THEN DATE(SUBTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) = date1
    WHEN date_type = '2' and add_sub_type = 1 AND bookings.ride_type = 1 THEN DATE(ADDTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) BETWEEN date1 and date2
    WHEN date_type = '2' and add_sub_type = 2 AND bookings.ride_type = 1 THEN DATE(SUBTIME(CONCAT(bookings.ride_date,' ',bookings.ride_time),timeZone)) BETWEEN date1 and date2
    
    ELSE bookings.id IS NOT null
END
ORDER BY bookings.id DESC$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Booking_list_single`(IN `uid` INT, IN `booking_id` INT, IN `status` INT, IN `date_type` INT, IN `date1` DATE, IN `date2` DATE, IN `offval` INT, IN `baseUrl` VARCHAR(191), IN `utype` INT, IN `is_bs` INT)
    NO SQL
SELECT bookings.id AS request_id, bookings.booking_id, bookings.pickup_lat, bookings.pickup_lng, bookings.total_passenger,

bookings.pickup_add, bookings.drop_lat, bookings.drop_lng, bookings.drop_add, bookings.created_at AS 

booking_date, 
CASE WHEN bookings.estimate_price IS null THEN '' ELSE bookings.estimate_price END AS estimate_price,
CASE WHEN bookings.price_tip IS null THEN '' ELSE bookings.price_tip END AS price_tip,
CASE WHEN bookings.price_response IS null THEN '' ELSE bookings.price_response END AS price_response,
bookings.status, car_categories.name AS car_name, CONCAT

(baseUrl,'public/car_categ/',car_categories.selected_icon) AS car_img,
CASE WHEN users.name IS null THEN '' ELSE users.name END AS driver_name,
CASE WHEN drivers.license_plate_number IS null THEN '' ELSE drivers.license_plate_number END AS 

license_plate_number,
CASE WHEN drivers.veh_model IS null THEN '' ELSE drivers.veh_model END AS veh_model,
CASE WHEN drivers.vehicle_make IS null THEN '' ELSE drivers.vehicle_make END AS vehicle_make,
CASE WHEN bookings.pickup_at IS null THEN '' ELSE bookings.pickup_at END AS pickup_at,
CASE WHEN bookings.drop_at IS null THEN '' ELSE bookings.drop_at END AS drop_at,
CASE WHEN drivers.direction IS null THEN '' ELSE drivers.direction END AS direction,
car_categories.no_of_seats, 
CASE
	WHEN users.profile_pic = '' OR users.profile_pic IS NULL THEN ''
    WHEN users.social_provider_type != '' THEN users.profile_pic
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic)
END AS driver_pic,CASE WHEN bookings.payable_amount IS null THEN '' ELSE bookings.payable_amount END AS 

payable_amount, bookings.drop_at, bookings.pickup_at, bookings.payment_method, drivers.cur_lng AS 

driver_lng, drivers.cur_lat AS driver_lat,
(SELECT AVG(rating) FROM feedback WHERE driver_id=users.id) AS avg_rating, users.id AS driver_id, 

bookings.otp, CASE WHEN bookings.instructions IS null THEN '' ELSE bookings.instructions END AS 

instructions, drivers.is_ride, bookings.ride_type, bookings.name AS for_name, 

bookings.driver_comm_amount, bookings.bsu_comm_amount, bookings.is_other
FROM bookings
LEFT JOIN users ON users.id = 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.driver_id 
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id 
    ELSE bookings.driver_id 
END
LEFT JOIN drivers ON drivers.user_id = users.id
LEFT JOIN car_categories ON bookings.car_type = car_categories.id
LEFT JOIN feedback ON bookings.id = feedback.request_id
WHERE 
CASE
	WHEN uid != '0' AND utype = '1' THEN bookings.user_id = uid
    WHEN uid != '0' AND utype = '2' THEN bookings.driver_id = uid
    ELSE bookings.user_id IS NOT null
END
AND
CASE
	WHEN booking_id != '0' THEN bookings.id = booking_id
    ELSE bookings.driver_id IS NOT null
END
LIMIT 10 OFFSET offval$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `Driver_car_type`(IN `req_lat` VARCHAR(191), IN `req_lng` VARCHAR(191), IN `ctype` INT)
    NO SQL
SELECT users.id,d.car_type, 111.045*GetDistance(req_lat,req_lng,d.cur_lat,d.cur_lng) AS distance
FROM drivers AS d 
JOIN users ON users.id=d.user_id
WHERE d.car_type = ctype AND users.active = 1 AND d.is_online = 1 AND d.is_ride = 0 AND d.cur_lat IS NOT null AND d.plan_expire_at >= DATE(NOW())
HAVING distance < 10
ORDER BY distance
LIMIT 1$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Get_booking_driver`(IN `p_lat` VARCHAR(255), IN `p_lng` VARCHAR(255), IN `cartype` INT, IN `toodseat` INT, IN `childseat` INT, IN `boostseat` INT, IN `carboost` INT, IN `baseUrl` VARCHAR(191), IN `reject_ids` TEXT, IN `req_id` INT, IN `ridedate` VARCHAR(191), IN `dradius` INT)
    NO SQL
SELECT users.id,drivers.car_type, users.name AS u_name, users.country_code,users.phone,111.045*GetDistance(p_lat,p_lng,drivers.cur_lat,drivers.cur_lng) AS distance, 
CASE 
	WHEN users.profile_pic='0' OR users.profile_pic='' OR users.profile_pic IS null THEN '' 
    WHEN users.social_provider_type!='' THEN users.profile_pic 
	ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic) 
END AS upic, car_categories.name AS c_name, CONCAT(baseUrl,'public/car_categ/',car_categories.selected_icon) AS selected_icon, CONCAT(baseUrl,'public/car_categ/',car_categories.unselected_icon) AS unselected_icon, car_categories.no_of_seats, users.device_token, users.device_type,(SELECT COUNT(*) FROM bookings WHERE DATE(ride_date)=ridedate AND driver_id=users.id) AS driver_today_bookings
FROM users
JOIN drivers ON drivers.user_id = users.id
JOIN car_categories ON car_categories.id = drivers.car_type
WHERE drivers.car_type = cartype AND users.active = '1' AND drivers.is_online = '1' AND drivers.is_ride = '0' AND users.user_type = '2' AND 
(CASE
	WHEN toodseat='1' THEN drivers.toodler_seat = toodseat
	ELSE drivers.toodler_seat IS NOT null
END AND
CASE
	WHEN childseat='1' THEN drivers.child_seat = childseat
	ELSE drivers.child_seat IS NOT null
END AND
CASE
	WHEN boostseat='1' THEN drivers.booster_seat = boostseat
	ELSE drivers.booster_seat IS NOT null
END AND
CASE
	WHEN carboost='1' THEN drivers.car_boosting = carboost
	ELSE drivers.car_boosting IS NOT null
END)
AND
CASE
	WHEN (reject_ids != '' OR reject_ids !='0') THEN users.id NOT IN (reject_ids)
    ELSE users.id IS NOT null
END AND users.device_token IS NOT null AND users.device_token !='' AND drivers.cur_lat IS NOT null AND drivers.plan_expire_at >= DATE(NOW())
HAVING distance < dradius
ORDER BY distance, driver_today_bookings ASC
LIMIT 1$$

CREATE DEFINER=`sa`@`localhost` PROCEDURE `Get_late_ride_later`(IN `cur_date` VARCHAR(191), IN `cur_time` VARCHAR(191))
    NO SQL
SELECT booking_id, user_id, driver_id, AddTime(ride_time,'00:20') AS booking_time 
FROM `bookings`
WHERE ride_type = '1' AND ride_date  = cur_date AND status = '4' AND user_id IS NOT null AND driver_id IS NOT null
HAVING CONCAT("'",cur_time,"'") > CONCAT("'",booking_time,"'")$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `Get_user_data`(IN `uid` INT, IN `baseUrl` VARCHAR(191))
    NO SQL
SELECT 
CASE
	WHEN users.name IS null THEN ''
    ELSE users.name
END AS name,
CASE
	WHEN users.first_name IS null THEN ''
    ELSE users.first_name
END AS first_name, 
CASE
	WHEN users.last_name IS null THEN ''
    ELSE users.last_name
END AS last_name,
users.phone, users.country_code,
CASE
	WHEN users.address IS null THEN ''
    ELSE users.address
END AS address,
CASE
	WHEN users.add_lat IS null THEN ''
    ELSE users.add_lat
END AS add_lat,
CASE
	WHEN users.add_lng IS null THEN ''
    ELSE users.add_lng
END AS add_lng,
CASE 
	WHEN users.profile_pic='' OR users.profile_pic IS null THEN '' 
    WHEN users.profile_pic LIKE '%http%' THEN users.profile_pic 
    ELSE CONCAT(baseUrl,'public/profile_pics/',users.profile_pic) 
END AS profile_pic,
CASE
	WHEN business_users.business_name IS null THEN ''
    ELSE business_users.business_name
END AS business_name,
CASE
	WHEN business_users.status IS null THEN ''
    ELSE business_users.status
END AS bu_status,
CASE
	WHEN business_users.business_doc IS null THEN ''
    ELSE business_users.business_doc
END AS business_doc,
CASE
	WHEN business_users.status IS null THEN 0
    ELSE 1
END AS is_business_user, users.email
FROM users
LEFT JOIN business_users ON users.id = business_users.user_id
WHERE users.id = uid$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `Test`(IN `rowId` INT)
    NO SQL
SELECT * FROM car_categories$$

--
-- Functions
--
CREATE DEFINER=`root`@`localhost` FUNCTION `Distance`(`lat1` FLOAT, `lon1` FLOAT, `lat2` FLOAT, `lon2` FLOAT) RETURNS float
    NO SQL
    COMMENT 'Returns the distance in degrees on the Earth              betwee'
RETURN DEGREES(ACOS(
              COS(RADIANS(lat1)) *
              COS(RADIANS(lat2)) *
              COS(RADIANS(lon2) - RADIANS(lon1)) +
              SIN(RADIANS(lat1)) * SIN(RADIANS(lat2))
            ))$$

CREATE DEFINER=`root`@`localhost` FUNCTION `GetDistance`(`lat1` FLOAT, `lon1` FLOAT, `lat2` FLOAT, `lon2` FLOAT) RETURNS float
    NO SQL
    COMMENT 'Returns the distance in degrees on the Earth              betwee'
RETURN DEGREES(ACOS(
              COS(RADIANS(lat1)) *
              COS(RADIANS(lat2)) *
              COS(RADIANS(lon2) - RADIANS(lon1)) +
              SIN(RADIANS(lat1)) * SIN(RADIANS(lat2))
            ))$$

DELIMITER ;

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

--
-- Table structure for table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `user_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `this_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `otp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permission_ids` text COLLATE utf8mb4_unicode_ci,
  `member_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `password`, `remember_token`, `active`, `user_token`, `this_id`, `mobile`, `otp`, `permission_ids`, `member_id`, `created_at`, `updated_at`) VALUES
(1, 'Sanjay Kumar', 'sanjay.kumar@appsinvo.com', 'lSGB4dTf8Iu21reabklsnkv9aEgFvTwXcCsI_MTIzNDU2Nzg5', NULL, '1', 'o8ClELDBH0lKAMuHutIk5GTLD76MNATQ4zreskNiTbdU4vaxGmF331DZU7NEY0LB', NULL, '9999989878', '917304', NULL, NULL, '2019-05-14 05:40:54', '2019-08-21 13:12:40'),
(3, 'Admin', 'admin@superride.com', '$2y$10$r5ZZ2Mv9f3WAp/OG54g8l.RUUVYa1k5cWbARNS5wj7m0wztkisPzy', NULL, '1', 'c3tjlZORr3g:APA91bHpIF_lrT6tbcduuqgospNg56m4lBJ5FFYX6PEL-C0PSPhadIGmOBBNqC_etrCgq7vC_ATB8ebK6AoytVk0TZxwMYT-2Mo0Rks8hbKAo4Bs9307DcZA4lP4Zc5GTTUVWufiGXYy', '65aa2869029c08b5f6f0c1621b8000aa', '9888587458', '56096', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17', NULL, '2019-05-16 00:39:13', '2021-08-27 08:23:44'),
(4, 'Shashank', 'shashank.sachdev@appsinvo.com', '9BEkBn3GsYNa57unHRPm3iJG7F88PuedUhVZ_c3VwZXJyaWRlNTAxMw==', NULL, '1', 'xQti9CCuAHZQk5isrdmrvFxsCH3YyysIZVwEH9nc9BSUvFKMdcROJOFUypbKcgAs', NULL, '29037', NULL, '3,4,5,7,8,9,10,11,12,13,14,15,16', 3, '2020-03-19 15:21:03', '2020-03-19 15:21:32'),
(5, 'a1@@', 'testw@mailinatorcom', 'J7Je1tGbpWTqTyQT4yYtiCaOjPfyo3uAvfoG_c3VwZXJyaWRlMTE0OQ==', NULL, '1', 'GsEQmYrDKnJpvEmTsD1BjXxlwYh2kU3hjdWXlLLpFpqSGrKrXZU7dKN35TdleKSi', NULL, '95718', NULL, '4,5,8', 4, '2020-04-06 08:16:23', NULL),
(6, 'test singh', 'testsingh@mailinator.com', 'KJef6wtdZTfXM0LbAXv0DNQttvnM7nD4WShH_c3VwZXJyaWRlODgxOA==', NULL, '1', 'iLUMAjKH4xIfmhwMnHRdrrclI5QDkbxMT6g8fbGgRkqAy0sYNoqSrDAQ8IoWLUwp', NULL, '39827', NULL, '1', 5, '2020-04-06 08:19:27', NULL),
(7, 'Kadher Sulaimon', 'rahsulaimon@yahoo.com', '1rctuzUGoFwfnvELzyibBgwvjysmGtyQtfmC_c3VwZXJyaWRlNjczNA==', NULL, '1', 'kJCkzG8Qo7UCv5Hc9FhNoFcynkBeZrnMeT7OkyHCBWOpvXrypiiInDnhxWQdyVo8', NULL, '6720', '286534', '1', 6, '2020-08-05 00:51:40', '2020-08-05 00:52:15');

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

--
-- Table structure for table `bank_details`
--

CREATE TABLE IF NOT EXISTS `bank_details` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `institution` varchar(100) NOT NULL,
  `branch` varchar(50) NOT NULL,
  `account_number` text NOT NULL,
  `account_holder_name` varchar(100) NOT NULL,
  `bank_id` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bookings`
--

CREATE TABLE IF NOT EXISTS `bookings` (
  `id` bigint(20) unsigned NOT NULL,
  `booking_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `driver_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `pickup_lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pickup_lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pickup_add` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drop_lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drop_lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drop_add` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toodler_seat` int(11) DEFAULT NULL,
  `child_seat` int(11) DEFAULT NULL,
  `booster_seat` int(11) DEFAULT NULL,
  `car_boosting` int(11) DEFAULT NULL,
  `car_type` bigint(20) unsigned DEFAULT NULL,
  `instructions` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '0 means driver found, 1 means no driver found, 3 means request expired, 4 means accept, 7 means reject',
  `request_count` int(11) NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payable_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estimate_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_tip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `price_response` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ride_type` int(11) DEFAULT '0' COMMENT '0 means normal, 1 means ride later',
  `ride_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ride_time` varchar(191) CHARACTER SET latin1 COLLATE latin1_spanish_ci DEFAULT NULL,
  `ride_amount` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ride_later_notif` int(11) NOT NULL DEFAULT '0' COMMENT '1 for sent in Ride Later situation, 0 for no activity',
  `pickup_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drop_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 for card, 2 for cash and 3 for wallet',
  `coupon_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_passenger` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_other` int(11) DEFAULT '0' COMMENT 'optional, pass 1 if you want to book for others only if you are a business user',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'optional if for other',
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'optional if for other',
  `ccode` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'optional if for other',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'optional if for other',
  `driver_comm_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `bsu_comm_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `reject_by_driver_ids` text COLLATE utf8mb4_unicode_ci,
  `booked_by` int(11) NOT NULL DEFAULT '1' COMMENT '	1 means user, 2 means buser, 3 for admin',
  `cancelled_show` int(11) NOT NULL DEFAULT '0' COMMENT '1 time show in get driver status',
  `cancelled_by` int(11) DEFAULT NULL COMMENT '1 means user, 2 means driver',
  `otp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coupon_id` bigint(20) DEFAULT NULL,
  `plan_type` bigint(20) unsigned NOT NULL DEFAULT '1',
  `is_fav` int(11) NOT NULL DEFAULT '0',
  `res_message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'success',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=868 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `booking_id`, `driver_id`, `user_id`, `pickup_lat`, `pickup_lng`, `pickup_add`, `drop_lat`, `drop_lng`, `drop_add`, `toodler_seat`, `child_seat`, `booster_seat`, `car_boosting`, `car_type`, `instructions`, `status`, `request_count`, `reason`, `payable_amount`, `tax`, `tax_type`, `price`, `estimate_price`, `price_tip`, `price_response`, `ride_type`, `ride_date`, `ride_time`, `ride_amount`, `ride_later_notif`, `pickup_at`, `drop_at`, `payment_method`, `coupon_code`, `total_passenger`, `is_other`, `name`, `phone`, `ccode`, `email`, `driver_comm_amount`, `bsu_comm_amount`, `reject_by_driver_ids`, `booked_by`, `cancelled_show`, `cancelled_by`, `otp`, `coupon_id`, `plan_type`, `is_fav`, `res_message`, `created_at`, `updated_at`) VALUES
(846, 'Taxi_742173', 263, 261, '29.3775505', '78.1391193', 'Parnami''s House,  H. No. 211', '29.3803819', '78.1393022', 'SRS Cinemas', 0, 0, 0, 0, 2, NULL, 6, 1, NULL, '5.22', '5', '1', NULL, '5.84', '0', NULL, 0, '2020-09-11', '14:45:26', '5.22', 0, '2020-09-11 14:45:26', '2020-09-11 14:45:49', '2', NULL, '2', 0, NULL, NULL, NULL, NULL, '4.7', '0.26', NULL, 1, 0, NULL, '5167', NULL, 2, 0, 'success', '2020-09-11 14:44:54', '2020-09-18 14:45:49'),
(847, 'Taxi_367912', 263, 261, '29.3773475', '78.1394136', 'Parnami''s House,  H. No. 211', '29.3803819', '78.1393022', 'SRS Cinemas', 0, 0, 0, 0, 2, NULL, 6, 1, NULL, '4.21', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-11', '15:56:32', '4.21', 0, '2020-09-11 15:56:32', '2020-09-11 16:06:04', '1', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.79', '0.21', NULL, 1, 0, NULL, '0578', NULL, 2, 0, 'success', '2020-09-11 15:56:08', '2020-09-18 16:06:04'),
(848, 'Taxi_173627', 264, 261, '29.3774139', '78.1393832', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.2', '5', '1', NULL, '5.41', '0', '1', 0, '2020-09-11', '16:30:31', '4.2', 0, '2020-09-11 16:30:31', '2020-09-11 16:31:19', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.78', '0.21', NULL, 1, 0, NULL, '3976', NULL, 2, 0, 'success', '2020-09-11 16:30:12', '2020-09-18 16:31:19'),
(849, 'Taxi_558766', 0, 261, '29.3775401', '78.1394331', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 8, 1, NULL, NULL, NULL, NULL, NULL, '5.41', '0', NULL, 0, '2020-09-18', NULL, NULL, 0, NULL, NULL, '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '0', '0', '264', 1, 0, NULL, NULL, NULL, 1, 0, 'success', '2020-09-18 16:32:20', '2020-09-18 16:32:47'),
(850, 'Taxi_964482', 264, 261, '29.3775401', '78.1394331', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.2', '5', '1', NULL, '5.41', '0', NULL, 0, '2020-09-11', '16:34:21', '4.2', 0, '2020-09-11 16:34:21', '2020-09-11 16:34:31', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.78', '0.21', NULL, 1, 0, NULL, '1124', NULL, 2, 0, 'success', '2020-09-11 16:34:00', '2020-09-18 16:34:31'),
(851, 'Taxi_783226', 265, 261, '29.3774452', '78.1394118', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.2', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-11', '17:06:20', '4.2', 0, '2020-09-11 17:06:20', '2020-09-11 17:11:41', '1', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.78', '0.21', NULL, 1, 0, NULL, '1425', NULL, 2, 0, 'success', '2020-09-11 17:05:48', '2020-09-18 17:11:41'),
(852, 'Taxi_287961', 266, 261, '29.3771086', '78.1396131', 'B-14,  Nai Basti Rd', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.28', '5', '1', NULL, '5.32', '0', NULL, 0, '2020-09-11', '17:33:04', '4.28', 0, '2020-09-11 17:33:04', '2020-09-11 17:33:10', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.85', '0.21', NULL, 1, 0, NULL, '3590', NULL, 2, 0, 'success', '2020-09-11 17:32:43', '2020-09-18 17:33:10'),
(853, 'Taxi_626987', 262, 261, '29.3774251', '78.1394371', 'Parnami''s House,  H. No. 211', '28.6460176', '77.3695166', 'Indirapuram', 0, 0, 0, 0, 1, NULL, 4, 1, NULL, '9.21', NULL, NULL, NULL, NULL, '0.0', '1', 1, '2021-09-09', '12:35:56', '9.21', 0, '2020-09-11 17:48:56', '2020-09-11 17:49:29', '1', NULL, '6', 0, NULL, NULL, NULL, NULL, '8.29', '0.46', NULL, 1, 0, NULL, '5244', NULL, 1, 0, 'success', '2020-09-11 17:48:40', '2021-09-06 06:08:28'),
(854, 'Taxi_887777', 268, 261, '29.3774251', '78.1394371', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '6.21', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-11', '18:09:41', '6.21', 0, '2020-09-11 18:09:41', '2020-09-11 18:10:13', '1', NULL, '3', 0, NULL, NULL, NULL, NULL, '5.59', '0.31', NULL, 1, 0, NULL, '5634', NULL, 1, 0, 'success', '2020-09-11 18:09:19', '2020-09-18 18:10:13'),
(855, 'Taxi_237073', 269, 261, '29.3774191', '78.1393856', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 2, NULL, 6, 1, NULL, '5.2', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-11', '18:25:29', '5.2', 0, '2020-09-11 18:25:29', '2020-09-11 18:25:59', '1', NULL, '2', 0, NULL, NULL, NULL, NULL, '4.68', '0.26', NULL, 1, 0, NULL, '3976', NULL, 1, 0, 'success', '2020-09-11 18:25:05', '2020-09-18 18:25:59'),
(856, 'Taxi_003819', 270, 261, '29.3774054', '78.1393778', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.21', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-20', '12:06:34', '4.21', 0, '2020-09-20 12:06:34', '2020-09-20 12:07:05', '1', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.79', '0.21', NULL, 1, 0, NULL, '1544', NULL, 2, 0, 'success', '2020-09-20 12:06:14', '2020-09-20 12:07:05'),
(857, 'Taxi_039837', 271, 261, '29.3773881', '78.1394081', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.21', '5', '1', NULL, '5.4', '0', NULL, 0, '2020-09-20', '12:10:21', '4.21', 0, '2020-09-20 12:10:21', '2020-09-20 12:12:16', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.79', '0.21', NULL, 1, 0, NULL, '0459', NULL, 2, 0, 'success', '2020-09-20 12:09:57', '2020-09-20 12:12:16'),
(858, 'Taxi_443553', 272, 261, '29.3774583', '78.1393642', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '5.21', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-20', '12:18:00', '5.21', 0, '2020-09-20 12:18:00', '2020-09-20 12:18:24', '1', NULL, '2', 0, NULL, NULL, NULL, NULL, '4.69', '0.26', NULL, 1, 0, NULL, '7789', NULL, 1, 0, 'success', '2020-09-20 12:17:38', '2020-09-20 12:18:24'),
(859, 'Taxi_419546', 273, 261, '29.3774583', '78.1393642', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '380.0', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-20', '12:22:38', '4.21', 0, '2020-09-20 12:22:38', '2020-09-20 12:23:03', '1', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.79', '0.21', NULL, 1, 0, NULL, '4422', NULL, 1, 0, 'success', '2020-09-20 12:22:13', '2020-09-20 12:23:03'),
(860, 'Taxi_102689', 274, 261, '29.3774672', '78.1393821', 'Parnami''s House,  H. No. 211', '29.380382', '78.139302', 'SRS Cinemas,  बिजनौर', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '4.21', '5', '1', NULL, '5.41', '0', NULL, 0, '2020-09-20', '12:28:25', '4.21', 0, '2020-09-20 12:28:25', '2020-09-20 12:28:30', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '3.79', '0.21', NULL, 1, 0, NULL, '1930', NULL, 1, 0, 'success', '2020-09-20 12:28:07', '2020-09-20 12:28:30'),
(861, 'Taxi_375884', 276, 278, '46.0993131', '-64.8066803', '800 Mountain Rd', '46.10688069999999', '-64.85520869999999', '39 Caspian Ct', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '6.32', '5', '1', NULL, '16.2', '0', NULL, 0, '2020-09-22', '14:20:43', '6.32', 0, '2020-09-22 14:20:43', '2020-09-22 14:23:04', '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '5.69', '0.32', NULL, 1, 0, NULL, '8801', NULL, 2, 0, 'success', '2020-09-22 14:20:20', '2020-09-22 14:23:04'),
(862, 'Taxi_887398', 276, 278, '46.099313', '-64.80668', '800 Mountain Rd', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '6.32', NULL, NULL, NULL, NULL, '0.0', '1', 0, '2020-09-22', '14:25:01', '6.32', 0, '2020-09-22 14:25:01', '2020-09-22 14:26:01', '1', NULL, '1', 0, NULL, NULL, NULL, NULL, '5.69', '0.32', NULL, 1, 0, NULL, '4338', NULL, 2, 0, 'success', '2020-09-22 14:24:17', '2020-09-22 14:26:01'),
(863, 'Taxi_086757', 276, 278, '46.106881', '-64.855209', '39 Caspian Court,  Moncton', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '15.68', '5', '1', NULL, '13.62', '0', NULL, 0, '2020-09-22', '15:05:00', '15.68', 0, '2020-09-22 15:05:00', '2020-09-22 15:06:28', '4', NULL, '1', 0, NULL, NULL, NULL, NULL, '14.11', '0.78', NULL, 1, 0, NULL, '6721', NULL, 2, 0, 'success', '2020-09-22 15:04:41', '2020-09-22 15:06:28'),
(864, 'Taxi_838446', 276, 278, '46.106881', '-64.855209', '39 Caspian Court,  Moncton', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 13, 1, NULL, NULL, NULL, NULL, NULL, '13.62', '0', NULL, 0, '2020-09-22', '15:07:46', NULL, 0, NULL, NULL, '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '0', '0', NULL, 1, 0, 1, NULL, NULL, 1, 0, 'This ride is cancelled by Test Payg', '2020-09-22 15:07:43', '2020-09-22 15:07:48'),
(865, 'Taxi_355199', 276, 278, '46.099313', '-64.80668', '800 Mountain Rd', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '6.43', '5', '1', NULL, '4.2', '0', NULL, 0, '2020-09-22', '15:09:26', '6.43', 0, '2020-09-22 15:09:26', '2020-09-22 15:10:44', '4', NULL, '1', 0, NULL, NULL, NULL, NULL, '5.79', '0.32', NULL, 1, 0, NULL, '5929', NULL, 2, 0, 'success', '2020-09-22 15:08:16', '2020-09-22 15:10:44'),
(866, 'Taxi_957051', 276, 278, '46.106881', '-64.855209', '39 Caspian Court,  Moncton', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 7, 1, 'Changed my mind', NULL, NULL, NULL, NULL, '13.62', '0', NULL, 0, '2020-09-22', NULL, NULL, 0, NULL, NULL, '2', NULL, '1', 0, NULL, NULL, NULL, NULL, '0', '0', NULL, 1, 0, 1, '1419', NULL, 2, 0, 'This ride is cancelled by Test Payg', '2020-09-22 15:15:20', '2020-09-22 15:18:22'),
(867, 'Taxi_216347', 276, 278, '46.099313', '-64.80668', '800 Mountain Rd', '46.099313', '-64.80668', '800 Mountain Rd', 0, 0, 0, 0, 1, NULL, 6, 1, NULL, '6.44', '5', '1', NULL, '4.2', '0', NULL, 0, '2020-09-22', '15:19:07', '6.44', 0, '2020-09-22 15:19:07', '2020-09-22 15:20:34', '4', NULL, '1', 0, NULL, NULL, NULL, NULL, '5.8', '0.32', NULL, 1, 0, NULL, '9086', NULL, 2, 0, 'success', '2020-09-22 15:18:44', '2020-09-22 15:20:34');

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

--
-- Table structure for table `business_users`
--

CREATE TABLE IF NOT EXISTS `business_users` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` varchar(191) NOT NULL,
  `business_name` varchar(191) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0 for pending, 1 for accept, 2 for reject',
  `business_doc` varchar(191) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cancel_reasons`
--

CREATE TABLE IF NOT EXISTS `cancel_reasons` (
  `id` bigint(20) unsigned NOT NULL,
  `reason` text NOT NULL,
  `fee` varchar(191) DEFAULT NULL,
  `type` int(11) NOT NULL COMMENT '1 for users, 2 for drivers',
  `active` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cancel_reasons`
--

INSERT INTO `cancel_reasons` (`id`, `reason`, `fee`, `type`, `active`, `created_at`, `updated_at`) VALUES
(2, 'Not Want To Go For Now.', '1', 2, 1, '2019-10-23 13:51:54', '2019-10-23 20:51:54'),
(4, 'testing driver cancellation', '12', 2, 0, '2019-12-12 07:12:44', '2019-12-12 14:12:44'),
(13, 'There is no delete option.  What kind of test you did?', NULL, 2, 1, '2020-01-02 04:49:36', NULL),
(16, 'Driver Too Late', NULL, 1, 1, '2020-03-20 01:10:15', NULL),
(17, 'Changed my mind', NULL, 1, 0, '2020-07-09 12:17:44', NULL),
(18, 'testing driver cancellation', '12', 1, 1, '2020-04-06 06:05:39', '2020-04-06 06:05:39'),
(22, 'Driver Cancel Ride', NULL, 2, 1, '2020-04-06 06:11:46', NULL),
(24, 'test reason', '1', 1, 0, '2020-07-09 12:17:12', NULL),
(26, 'test reason', '1', 2, 1, '2020-04-26 17:45:32', NULL);

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

--
-- Table structure for table `car_categories`
--

CREATE TABLE IF NOT EXISTS `car_categories` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `selected_icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unselected_icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_of_seats` int(11) NOT NULL,
  `status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_categories`
--

INSERT INTO `car_categories` (`id`, `name`, `selected_icon`, `unselected_icon`, `no_of_seats`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ford', 'car-category-fill.png', 'car-category-unfill.png', 7, '1', '2019-10-21 19:00:50', '2019-10-21 19:00:50'),
(2, 'Audi', '6k7p4pnw4aqelmzeoee0fjboztneu1skut1z0mjcjpeg.jpg', 'z8meqxn5r8anjb1pqvttaoc4jcncyawv4ueimg0vjpeg.jpg', 2, '1', '2019-10-21 19:01:02', '2020-04-03 07:03:57'),
(7, 'bmws', 'car-category-fill.png', 'car-category-unfill.png', 8, '1', '2020-03-29 13:46:44', '2020-07-17 19:08:08');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE IF NOT EXISTS `coupons` (
  `id` bigint(20) unsigned NOT NULL,
  `car_type_ids` text NOT NULL,
  `user_ids` text NOT NULL,
  `coupon_name` varchar(50) NOT NULL,
  `coupon_code` varchar(50) NOT NULL,
  `start_date` varchar(191) NOT NULL,
  `end_date` varchar(191) NOT NULL,
  `coupon_amount` int(11) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `details` text,
  `is_used` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  `created_at` varchar(191) DEFAULT NULL,
  `updated_at` varchar(191) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `car_type_ids`, `user_ids`, `coupon_name`, `coupon_code`, `start_date`, `end_date`, `coupon_amount`, `image`, `details`, `is_used`, `active`, `created_at`, `updated_at`) VALUES
(1, '2', '2,12,84', 'FIRST50', 'FST50', '2019-12-12', '2019-12-31', 50, NULL, NULL, 0, 1, '2019-10-21 12:51:58', '2019-12-12 15:36:03'),
(2, '1,2,3', '89,94', 'Flat $ 5 off', 'Super', '2019-12-23', '2020-12-30', 5, NULL, NULL, 0, 1, '2019-12-17 11:24:18', '2019-12-23 07:31:47'),
(3, '2,7', '105', 'tests', '18978', '2020-04-03', '2020-04-05', 11, NULL, NULL, 0, 1, '2020-04-03 15:32:53', '2020-04-03 15:34:08'),
(4, '1', '93', 'FIRST51', '1221', '2020-04-06', '2020-04-06', 10, NULL, NULL, 0, 1, '2020-04-06 05:42:33', NULL),
(5, '1', '198', 'COUPTEST', 'TRY6', '2020-07-29', '2020-11-30', 5, NULL, NULL, 0, 1, '2020-07-29 01:46:34', NULL);

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

--
-- Table structure for table `drivers`
--

CREATE TABLE IF NOT EXISTS `drivers` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `vehicle_make` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_plate_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `veh_model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seat_nos` int(11) DEFAULT NULL,
  `toodler_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `child_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_boosting` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_type` bigint(20) unsigned DEFAULT NULL,
  `booster_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `insurance_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operator_lic_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `criminal_bg_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_type` int(11) DEFAULT NULL COMMENT '1 for Weekly, 2 for Pay as you go',
  `plan_expire_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_expired` int(11) NOT NULL DEFAULT '1' COMMENT '1 means plan expired, 0 means not',
  `plan_status` int(11) DEFAULT '1' COMMENT '0 due, 1 paid',
  `cur_lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_ride` int(11) NOT NULL DEFAULT '0' COMMENT '0 means available, 1 means on ride',
  `is_online` int(11) NOT NULL DEFAULT '0' COMMENT '0 for offline, 1 for online',
  `is_activate_first_plan` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=408 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drivers`
--

INSERT INTO `drivers` (`id`, `user_id`, `vehicle_make`, `license_plate_number`, `veh_model`, `seat_nos`, `toodler_seat`, `child_seat`, `car_boosting`, `car_type`, `booster_seat`, `license_img`, `insurance_img`, `operator_lic_img`, `criminal_bg_img`, `plan_type`, `plan_expire_at`, `is_expired`, `plan_status`, `cur_lat`, `cur_lng`, `cur_address`, `direction`, `is_ride`, `is_online`, `is_activate_first_plan`, `created_at`, `updated_at`) VALUES
(390, 262, 'Vmake', 'Lpnum', 'Vmodel', 4, '0', '0', '0', 1, '0', '', '', '', '', 1, '2020-09-20 23:59:59', 1, 1, '23.0752623', '72.5261683', 'Ganesh Meridian,  Opp. Gujarat High Court', '12.9946165', 1, 1, 1, '2020-09-18 14:30:31', '2021-09-13 06:08:26'),
(391, 263, 'Vpayg', 'Lpsjen', 'Vmodelpay', 4, '0', '0', '0', 2, '0', '', '', '', '', 2, '5935-09-20 23:59:59', 1, 1, '23.049910626423355', '72.51733937231417', 'gsdfsdfsdfsdf', NULL, 0, 0, 1, '2020-09-18 14:33:52', '2021-09-09 04:32:44'),
(392, 264, 'Yiyo', 'Hikn', 'Ygf', 4, '0', '0', '0', 1, '0', '', '', '', '', 2, '7664-09-20 23:59:59', 1, 1, '29.3773904', '78.139364', 'Parnami''s House,  H. No. 211', '45.0', 0, 0, 1, '2020-09-18 15:30:49', '2020-09-18 17:03:47'),
(393, 265, 'yomade', 'LPNUM3232', 'modeloiy', NULL, '0', '0', '0', 1, '0', NULL, NULL, NULL, NULL, 2, '2020-09-20 23:59:59', 1, 1, '29.3773931', '78.1393649', 'Parnami''s House,  H. No. 211', '8.092197', 0, 0, 1, '2020-09-18 16:43:33', '2020-09-18 17:26:49'),
(394, 266, 'Hsjsj', 'Djjdjdn', 'Djjdjfn', 4, '0', '0', '0', 1, '0', '', '', '', '', 2, '2020-09-20 23:59:59', 1, 1, '29.3773946', '78.1393658', 'Parnami''s House,  H. No. 211', '242.02052', 0, 0, 1, '2020-09-18 17:27:01', '2020-09-18 17:40:42'),
(395, 267, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, 0, 0, 0, '2020-09-18 17:40:59', NULL),
(396, 268, 'khaskdh', 'kasjdhkash', 'kashdka', NULL, '0', '0', '0', 1, '0', NULL, NULL, NULL, NULL, 1, '2020-09-20 23:59:59', 1, 1, '29.3774135', '78.1393872', 'Parnami''s House,  H. No. 211', '101.30993', 0, 0, 1, '2020-09-18 18:06:07', '2020-09-18 18:23:56'),
(397, 269, 'wert', 'sdfsdsdf', 'sdfsdf', NULL, '0', '0', '0', 2, '0', NULL, NULL, NULL, NULL, 1, '2020-09-20 23:59:59', 1, 1, '29.3774028', '78.139368', 'Parnami''s House,  H. No. 211', '61.14434', 0, 0, 1, '2020-09-18 18:23:15', '2020-09-20 12:01:33'),
(398, 270, 'Hdheh', 'Hdhdh', 'Hdhdh', 4, '0', '0', '0', 1, '0', '', '', '', '', 2, '2020-09-20 23:59:59', 1, 1, '29.3774247', '78.1394196', 'Parnami''s House,  H. No. 211', '245.23364', 0, 0, 1, '2020-09-20 12:01:41', '2020-09-22 06:32:26'),
(399, 271, 'Jdjdn', 'Hxjdh', 'Duujf', 4, '0', '0', '0', 1, '0', '', '', '', '', 2, '2020-09-27 23:59:59', 1, 1, '29.3774031', '78.1393715', 'Parnami''s House,  H. No. 211', '0.0', 0, 0, 1, '2020-09-20 12:07:53', '2020-09-22 09:15:05'),
(400, 272, 'Hdbx', 'Hdhdhf', 'Hdhd', 4, '0', '0', '0', 1, '0', '', '', '', '', 1, '2020-09-20 23:59:59', 1, 1, '29.3773469', '78.1394129', 'Parnami''s House,  H. No. 211', '123.26488', 0, 0, 1, '2020-09-20 12:12:44', '2020-09-21 14:43:31'),
(401, 273, 'Jdjd', 'Hdjdn', 'Dhd', 4, '0', '0', '0', 1, '0', '', '', '', '', 1, '2020-09-20 23:59:59', 1, 1, '29.3774212', '78.1394375', 'Parnami''s House,  H. No. 211', '73.76967', 0, 0, 1, '2020-09-20 12:18:49', '2020-09-22 09:09:42'),
(402, 274, 'Hdhdh', 'Hdhdbbd', 'Hshdh', 4, '0', '0', '0', 1, '0', '', '', '', '', 1, '2020-09-20 23:59:59', 1, 1, '29.3774156', '78.1394057', 'Parnami''s House,  H. No. 211', '18.081276', 0, 0, 1, '2020-09-20 12:23:33', '2020-09-21 14:55:08'),
(403, 275, 'Chhhh', 'Gyuu', 'Ghh', 4, '1', '0', '0', 1, '0', '', '', '', '', 1, NULL, 1, 1, NULL, NULL, NULL, NULL, 0, 0, 0, '2020-09-21 13:29:22', '2020-09-21 13:30:12'),
(404, 276, 'Jdjd7272', 'Bsbbs3883', 'Bbdbd272', NULL, '0', '0', '0', 1, '0', NULL, NULL, NULL, NULL, 2, '2020-09-27 23:59:59', 1, 1, '46.1043915', '-64.7979902', '20 Connaught Ave,  Moncton', '340.0559', 0, 0, 1, '2020-09-21 14:25:55', '2020-09-22 15:20:37'),
(405, 277, 'Fff', 'Ggg', 'Vvv', 4, '0', '0', '0', 1, '0', '', '', '', '', 1, '2020-09-20 23:59:59', 1, 1, '29.3773916', '78.13941', 'Parnami''s House,  H. No. 211', '53.98903', 0, 0, 1, '2020-09-21 14:55:17', '2020-09-21 15:01:33'),
(406, 279, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '23.049910626423355', '72.51733937231417', 'gsdfsdfsdfsdf', NULL, 0, 0, 0, '2021-09-02 06:08:56', '2021-09-09 07:01:06'),
(407, 280, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, 0, 0, 0, '2021-09-02 06:09:31', NULL);

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

--
-- Table structure for table `driverstatuscheck`
--

CREATE TABLE IF NOT EXISTS `driverstatuscheck` (
  `id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `timezone` varchar(191) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `driverstatuscheck`
--

INSERT INTO `driverstatuscheck` (`id`, `driver_id`, `timezone`, `created_at`, `updated_at`) VALUES
(1, 390, 'asia/kolkata', '2021-09-01 00:18:33', '2021-09-01 00:18:33'),
(2, 391, 'asia/kolkata', '2021-09-01 00:20:22', '2021-09-01 00:20:22'),
(3, 392, 'asia/kolkata', '2021-09-01 03:23:11', '2021-09-01 03:23:11'),
(4, 393, 'asia/kolkata', '2021-09-01 03:33:04', '2021-09-01 03:33:04'),
(5, 394, 'asia/kolkata', '2021-09-01 03:34:49', '2021-09-01 03:34:49'),
(6, 395, 'asia/kolkata', '2021-09-01 03:35:12', '2021-09-01 03:35:12'),
(7, 396, 'asia/kolkata', '2021-09-01 03:35:56', '2021-09-01 03:35:56'),
(8, 397, 'asia/kolkata', '2021-09-01 03:38:59', '2021-09-01 03:38:59'),
(9, 398, 'asia/kolkata', '2021-09-01 03:39:51', '2021-09-01 03:39:51'),
(10, 399, 'asia/kolkata', '2021-09-01 03:40:52', '2021-09-01 03:40:52'),
(11, 400, 'asia/kolkata', '2021-09-01 03:44:40', '2021-09-01 03:44:40'),
(12, 401, 'asia/kolkata', '2021-09-01 03:44:50', '2021-09-01 03:44:50'),
(13, 402, 'asia/kolkata', '2021-09-01 04:07:42', '2021-09-01 04:07:42'),
(14, 403, 'asia/kolkata', '2021-09-01 04:08:00', '2021-09-01 04:08:00'),
(15, 403, 'asia/kolkata', '2021-09-01 04:11:07', '2021-09-01 04:11:07'),
(16, 403, 'asia/kolkata', '2021-09-01 04:44:01', '2021-09-01 04:44:01'),
(17, 404, 'asia/kolkata', '2021-09-02 01:08:23', '2021-09-02 01:08:23'),
(18, 404, 'asia/kolkata', '2021-09-02 01:37:49', '2021-09-02 01:37:49'),
(21, 404, 'asia/kolkata', '2021-09-02 01:53:55', '2021-09-02 01:53:55'),
(22, 404, 'asia/kolkata', '2021-09-02 02:00:16', '2021-09-02 02:00:16'),
(23, 404, 'asia/kolkata', '2021-09-02 02:17:17', '2021-09-02 02:17:17'),
(24, 404, 'asia/kolkata', '2021-09-02 02:27:06', '2021-09-02 02:27:06'),
(25, 262, '+05:30', '2021-09-06 00:09:37', '2021-09-13 11:38:26'),
(27, 279, '+05:30', '2021-09-09 12:32:41', '2021-09-09 12:32:41');

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

--
-- Table structure for table `driver_full_settles`
--

CREATE TABLE IF NOT EXISTS `driver_full_settles` (
  `id` bigint(20) unsigned NOT NULL,
  `driver_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 pending, 1 done',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='driver full settlement request list';

--
-- Dumping data for table `driver_full_settles`
--

INSERT INTO `driver_full_settles` (`id`, `driver_id`, `status`, `created_at`, `updated_at`) VALUES
(2, 274, 0, '2020-09-21 14:52:53', NULL),
(3, 271, 0, '2020-09-21 15:04:26', NULL);

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

--
-- Table structure for table `driver_plans`
--

CREATE TABLE IF NOT EXISTS `driver_plans` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(35) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int(11) NOT NULL,
  `commission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `driver_plans`
--

INSERT INTO `driver_plans` (`id`, `name`, `price`, `commission`, `details`, `created_at`, `updated_at`) VALUES
(1, 'Weekly Plan', 300, '0', 'Select this plan to pay SuperRide a fixed amount in exchange for getting unlimited booking requests throughout the week. Keep 100% of your tips. SuperRide prorates the Fixed Plan amount you pay, so if you come mid-week, you only pay for the remainder of the week. We pay you on time every week, by cheque or digital payment, and you can change your Driver Plan whenever you want.', NULL, NULL),
(2, 'Pay As You Go (PAYG)', 40, '0', 'Select this plan if you want part-time work or want to try out our new exciting app.  With this plan you only pay for the number of booking requests you actually receive. Keep 100% of your tips. On Wednesday of the following week you’ll be paid by check or other preferred digital methods for your online earnings (from saved debit or credit cards, wallets, and Point of Sale machines), minus your booking fee. The advantage of this plan is that you have full control of your schedule and you can be your own boss.  You decide when you want to work, which can be few hours a day.', NULL, NULL);

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

--
-- Table structure for table `emr_contacts`
--

CREATE TABLE IF NOT EXISTS `emr_contacts` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `relation` varchar(50) NOT NULL,
  `ccode` varchar(10) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `favourite_places`
--

CREATE TABLE IF NOT EXISTS `favourite_places` (
  `id` bigint(20) unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `add` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` double(8,6) NOT NULL,
  `lng` double(8,6) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1 for home, 2 for work, 3 for other',
  `user_id` bigint(20) unsigned NOT NULL,
  `request_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favourite_places`
--

INSERT INTO `favourite_places` (`id`, `title`, `add`, `lat`, `lng`, `type`, `user_id`, `request_id`, `created_at`, `updated_at`) VALUES
(197, 'Srs', 'SRS Cinemas, बिजनौर, Bijnor, Uttar Pradesh, India', 29.380382, 78.139302, 3, 261, NULL, '2020-09-18 00:00:00', NULL),
(198, 'test', '800 Mountain Rd', 46.099313, -64.806680, 3, 278, NULL, '2020-09-22 00:00:00', NULL),
(199, 'test1', '39 Caspian Court, Moncton, NB, Canada', 46.106881, -64.855209, 3, 278, NULL, '2020-09-22 00:00:00', NULL);

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

--
-- Table structure for table `feedback`
--

CREATE TABLE IF NOT EXISTS `feedback` (
  `id` bigint(20) unsigned NOT NULL,
  `request_id` bigint(20) unsigned DEFAULT NULL,
  `driver_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `rating` float NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=338 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` (`id`, `request_id`, `driver_id`, `user_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES
(327, 846, 263, 261, 5, NULL, '2020-09-18 14:46:06', '2020-09-18 14:46:06'),
(328, 850, 264, 261, 5, NULL, '2020-09-18 16:34:37', '2020-09-18 16:34:37'),
(329, 851, 265, 261, 5, NULL, '2020-09-18 17:11:38', '2020-09-18 17:11:38'),
(330, 852, 266, 261, 5, NULL, '2020-09-18 17:33:36', '2020-09-18 17:33:36'),
(331, 853, 262, 261, 5, NULL, '2020-09-18 17:49:38', '2020-09-18 17:49:38'),
(332, 855, 269, 261, 5, NULL, '2020-09-18 18:25:56', '2020-09-18 18:25:56'),
(333, 856, 270, 261, 5, NULL, '2020-09-20 12:07:00', '2020-09-20 12:07:00'),
(334, 860, 274, 261, 5, NULL, '2020-09-20 12:28:36', '2020-09-20 12:28:36'),
(335, 861, 276, 278, 3, NULL, '2020-09-22 14:23:17', '2020-09-22 14:23:17'),
(336, 862, 276, 278, 3, NULL, '2020-09-22 14:25:59', '2020-09-22 14:25:59'),
(337, 867, 276, 278, 2, NULL, '2020-09-22 15:20:46', '2020-09-22 15:20:46');

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

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE IF NOT EXISTS `f_a_q_s` (
  `id` bigint(20) unsigned NOT NULL,
  `question` varchar(191) NOT NULL,
  `answer` text NOT NULL,
  `user_type` int(11) NOT NULL DEFAULT '1' COMMENT '1 for customer, 2 for driver',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `f_a_q_s`
--

INSERT INTO `f_a_q_s` (`id`, `question`, `answer`, `user_type`, `created_at`, `updated_at`) VALUES
(1, 'What is SuperRide?', 'SuperRide connects drivers with private and business users. Our goal is to digitize and disrupt the city’s taxi service using a convenient mobile app, while offering self-employment opportunities to hundreds of people.', 1, '2019-12-17 11:54:38', '2019-12-17 11:54:38'),
(2, 'How can I book a taxi?', 'You are just a few clicks away!  After registering with our Android or IOS app, all you need to do is: a) Select the pickup and drop off location and select the number of passengers b) Select the payment method and c) Click on the Confirm Booking button. That’s it! You will be assigned the closest driver in your area within a few seconds. It is that easy. You can also select optional special requests if you have any.', 1, '2019-12-23 10:29:19', '2019-12-23 10:29:19'),
(3, 'What is Ride Later?', 'Using the Ride Later feature, passengers can make bookings from 15 minutes to up to a week in advance.', 1, '2019-12-23 10:29:19', '2019-12-23 10:29:19'),
(4, 'What are the different payment methods you accept?', 'We accept Cash, Interac, Debit Cards, Credit Cards, Apple Pay, and Google Pay.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(5, 'How safe is your payment method?', 'We don''t store your credit or debit card details. We use Stripe for payments originating from the mobile app, i.e., saved cards, and a Square POS device for physical card payments. Both of these payment methods offer reliability, security, and are widely used across Canada.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(6, 'How much do you charge for deliveries?', 'Our delivery price is based on the distance from the restaurant, auto parts shop, or pharmacy.  You can refer to the prices on our website.\r\n', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(7, 'What is wallet?\r\n', 'Wallet is a feature that is built into our app. You can recharge it within our app and use it for your ride as needed.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(8, 'Who is a business user?', 'Anyone who owns a business or works in the hospitality industry and books a cab on behalf of customers is considered a business user.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(9, 'Why am I not able to select the destination?', 'Our robust app first looks for available vehicles nearby. If it finds a nearby driver, then it displays the available cars along with the estimated arrival time.  If it says Not Available, that means there is no nearby car and you will not be able to enter a destination to book the car until a driver is available.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(10, 'What is SOS in the app?', 'If you feel like you are in danger, then you can use the SOS button. When you click the SOS button, you''ll be asked whether you want to share your location with your added emergency contacts or to place a 911 call.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(11, 'How much do you charge for payments using Debit or credit card?', 'We do not charge anything for debit cards using Interac tap.  However, for credit card transactions we charge 75 cents and for transactions using a saved card, we charge $1.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(12, 'Why do the estimated fare and taximeter fare differ?', 'Estimated fare is based on the distance calculated by Google maps. You are required to pay only the taximeter fare, not the amount shown in estimated fare. You can ignore the estimated fare as it is just an estimation and we are testing it out for the future.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(13, 'Do you deliver alcohol?', 'No, we do not do alcohol delivery.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(14, 'How do I report issues?', 'The app has a support system built into it. If you have any feedback or complaints, you can leave those within the app itself, using the Support option in the menu. We will try to resolve it quickly to the best of our ability.', 1, '2020-03-04 15:36:22', '2020-03-04 15:36:22'),
(15, 'How do I become a driver for SuperRide?', 'Becoming a driver for SuperRide is very easy. Either in the website or in our mobile app you can register and submit your documents. It takes only a few minutes. We will verify your documents and schedule a short interview over the phone or in person at our office. Next, we will activate your account and send a confirmation email along with onboarding instructions. Now you are signed up as a driver and ready to receive bookings.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(16, 'How do I get paid?\r\n', 'We pay out weekly. We pay your earnings the following week, after deducting the SuperRide fee for weekly payments or commission for Pay-As-You-Go payments, as applicable.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(17, 'How does the weekly plan work?\r\n', 'With the weekly plan, you will receive unlimited ride requests throughout the week and pay SuperRide a fixed amount.  You will keep 100% of your tips. SuperRide prorates the Fixed Plan amount you pay, so if you start mid-week, you only pay for the remainder of the week.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(18, 'How does the PAYG (Pay As You Go) plan work?', 'With the PAYG plan, you only pay for the number of ride requests you actually receive. You will keep 100% of your tips. We deduct a small portion as a commission for every booking you receive, and pay you the rest of the money in the following week. The advantage of this plan is that you have full control of your schedule and you can be your own boss.  You decide when you want to work, which can be few hours a day.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(19, 'How do I pay my SuperRide fee or commission?', 'You can pay the SuperRide fee (for weekly plan) and commission (for Pay As You Go) plan in cash in the office, or pay through a debit or credit card within the app itself.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(20, 'When am I eligible to get maintenance costs for my vehicle?', 'After you work with us continuously for a year on the weekly plan, you are eligible to receive vehicle maintenance costs. Terms and conditions apply.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(21, 'How does the SuperRide Drivers app work?', 'Once you are a driver, all you have to do is log in with your mobile number and password. You’ll quickly start to receive ride requests from the passengers closest to your location, and you’ll be clearly shown the point of pickup origin and the destination where you have to go.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31'),
(22, 'Do you give me a tablet or how do I use the app?\r\n', 'You use our app on your own iPhone or Android device. Our app can be used alongside other apps.', 2, '2020-03-04 15:40:31', '2020-03-04 15:40:31');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_06_07_090818_create_drivers_table', 2),
(9, '2019_07_01_132223_create_favourite_places_table', 3),
(10, '2019_07_23_123750_create_car_categories_table', 4);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` bigint(20) unsigned NOT NULL,
  `booking_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `obj_id` int(11) DEFAULT NULL,
  `obj_type` int(11) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `body` text NOT NULL,
  `data` text,
  `is_show` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2029 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `booking_id`, `user_id`, `obj_id`, `obj_type`, `title`, `body`, `data`, `is_show`, `created_at`, `updated_at`) VALUES
(1963, 846, 263, 846, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3775505","pickup_lng":"78.1391193","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":846,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"2","pickup_at":"","drop_lat":"29.3803819","drop_lng":"78.1393022","drop_add":"SRS Cinemas","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 14:44:54', NULL),
(1964, 846, 261, 846, 1, 'Request Accept', 'Your request has been accepted by Driver Payg', '', 1, '2020-09-18 14:45:04', NULL),
(1965, 846, 261, 846, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 14:45:10', NULL),
(1966, 847, 263, 847, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3773475","pickup_lng":"78.1394136","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":847,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.3803819","drop_lng":"78.1393022","drop_add":"SRS Cinemas","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 15:56:08', NULL),
(1967, 847, 261, 847, 1, 'Request Accept', 'Your request has been accepted by Driver Payg', '', 1, '2020-09-18 15:56:14', NULL),
(1968, 847, 261, 847, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 15:56:22', NULL),
(1969, 848, 264, 848, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774139","pickup_lng":"78.1393832","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":848,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 16:30:12', NULL),
(1970, 848, 261, 848, 1, 'Request Accept', 'Your request has been accepted by Payg New', '', 1, '2020-09-18 16:30:15', NULL),
(1971, 848, 261, 848, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 16:30:21', NULL),
(1972, 849, 264, 849, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3775401","pickup_lng":"78.1394331","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":849,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 16:32:20', NULL),
(1973, 849, 261, 849, 1, 'Customer Request', 'Request rejected no new driver found', '', 1, '2020-09-18 16:32:47', NULL),
(1974, 850, 264, 850, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3775401","pickup_lng":"78.1394331","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":850,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 16:34:00', NULL),
(1975, 850, 261, 850, 1, 'Request Accept', 'Your request has been accepted by Payg New', '', 1, '2020-09-18 16:34:05', NULL),
(1976, 850, 261, 850, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 16:34:10', NULL),
(1977, 851, 265, 851, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774452","pickup_lng":"78.1394118","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":851,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 17:05:48', NULL),
(1978, 851, 261, 851, 1, 'Request Accept', 'Your request has been accepted by Driver PaygAgain', '', 1, '2020-09-18 17:05:55', NULL),
(1979, 851, 261, 851, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 17:06:11', NULL),
(1980, 852, 266, 852, 1, 'Customer Request', 'New request from customer for the address is: B-14,  Nai Basti Rd', '{"title":"Customer Request","body":"New request from customer for the address is: B-14,  Nai Basti Rd","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3771086","pickup_lng":"78.1396131","pickup_add":"B-14,  Nai Basti Rd","time":"1","u_pic":"","status":"0","request_id":852,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 17:32:43', NULL),
(1981, 852, 261, 852, 1, 'Request Accept', 'Your request has been accepted by Driverpayg Dhtp', '', 1, '2020-09-18 17:32:51', NULL),
(1982, 852, 261, 852, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 17:32:56', NULL),
(1983, 853, 262, 853, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774251","pickup_lng":"78.1394371","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":853,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"6","pickup_at":"","drop_lat":"28.6460176","drop_lng":"77.3695166","drop_add":"Indirapuram","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2021-09-09 12:42:14', '2021-09-09 07:12:14'),
(1984, 853, 261, 853, 1, 'Request Accept', 'Your request has been accepted by Driver Weekly', '', 1, '2021-09-09 12:42:14', '2021-09-09 07:12:14'),
(1985, 853, 261, 853, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2021-09-09 12:42:14', '2021-09-09 07:12:14'),
(1986, 854, 268, 854, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774251","pickup_lng":"78.1394371","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":854,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"3","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 18:09:19', NULL),
(1987, 854, 261, 854, 1, 'Request Accept', 'Your request has been accepted by Driverweek DHP', '', 1, '2020-09-18 18:09:25', NULL),
(1988, 854, 261, 854, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 18:09:30', NULL),
(1989, 855, 269, 855, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774191","pickup_lng":"78.1393856","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":855,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"2","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-18","ride_time":null}', 1, '2020-09-18 18:25:05', NULL),
(1990, 855, 261, 855, 1, 'Request Accept', 'Your request has been accepted by ewuriw asudoiua', '', 1, '2020-09-18 18:25:12', NULL),
(1991, 855, 261, 855, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-18 18:25:17', NULL),
(1992, 856, 270, 856, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774054","pickup_lng":"78.1393778","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":856,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-20","ride_time":null}', 1, '2020-09-20 12:06:14', NULL),
(1993, 856, 261, 856, 1, 'Request Accept', 'Your request has been accepted by Driverpayg Comppay', '', 1, '2020-09-20 12:06:18', NULL),
(1994, 856, 261, 856, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-20 12:06:24', NULL),
(1995, 857, 271, 857, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3773881","pickup_lng":"78.1394081","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":857,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-20","ride_time":null}', 1, '2020-09-20 12:09:57', NULL),
(1996, 857, 261, 857, 1, 'Request Accept', 'Your request has been accepted by Driverpayg driverpay', '', 1, '2020-09-20 12:10:04', NULL),
(1997, 857, 261, 857, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-20 12:10:09', NULL),
(1998, 858, 272, 858, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774583","pickup_lng":"78.1393642","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":858,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"2","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-20","ride_time":null}', 1, '2020-09-20 12:17:38', NULL),
(1999, 858, 261, 858, 1, 'Request Accept', 'Your request has been accepted by DriverWeekly DriverPay', '', 1, '2020-09-20 12:17:43', NULL),
(2000, 858, 261, 858, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-20 12:17:47', NULL),
(2001, 859, 273, 859, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774583","pickup_lng":"78.1393642","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":859,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-20","ride_time":null}', 1, '2020-09-20 12:22:13', NULL),
(2002, 859, 261, 859, 1, 'Request Accept', 'Your request has been accepted by Driveremweekly Comppay', '', 1, '2020-09-20 12:22:22', NULL),
(2003, 859, 261, 859, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-20 12:22:26', NULL),
(2004, 860, 274, 860, 1, 'Customer Request', 'New request from customer for the address is: Parnami''s House,  H. No. 211', '{"title":"Customer Request","body":"New request from customer for the address is: Parnami''s House,  H. No. 211","u_name":"Cust Payg","u_ccode":" 1","u_phone":"1099","pickup_lat":"29.3774672","pickup_lng":"78.1393821","pickup_add":"Parnami''s House,  H. No. 211","time":"1","u_pic":"","status":"0","request_id":860,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"29.380382","drop_lng":"78.139302","drop_add":"SRS Cinemas,  \\u092c\\u093f\\u091c\\u0928\\u094c\\u0930","ride_type":0,"ride_date":"2020-09-20","ride_time":null}', 1, '2020-09-20 12:28:07', NULL),
(2005, 860, 261, 860, 1, 'Request Accept', 'Your request has been accepted by Driverweekly Driverpaycash', '', 1, '2020-09-20 12:28:12', NULL),
(2006, 860, 261, 860, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-20 12:28:16', NULL),
(2007, 0, 274, NULL, NULL, 'Settlement Notification', 'Please settle your weekly transaction amount', NULL, 1, '2020-09-21 14:47:29', NULL),
(2008, 0, 274, NULL, NULL, 'Settlement Notification', 'Please settle your weekly transaction amount', NULL, 1, '2020-09-21 14:48:38', NULL),
(2009, 0, 274, NULL, NULL, 'Settlement Notification', 'Please settle your weekly transaction amount', NULL, 1, '2020-09-21 14:49:02', NULL),
(2010, 861, 276, 861, 1, 'Customer Request', 'New request from customer for the address is: 800 Mountain Rd', '{"title":"Customer Request","body":"New request from customer for the address is: 800 Mountain Rd","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.0993131","pickup_lng":"-64.8066803","pickup_add":"800 Mountain Rd","time":"2","u_pic":"","status":"0","request_id":861,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.10688069999999","drop_lng":"-64.85520869999999","drop_add":"39 Caspian Ct","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 14:20:20', NULL),
(2011, 861, 278, 861, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 14:20:23', NULL),
(2012, 861, 278, 861, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-22 14:20:30', NULL),
(2013, 862, 276, 862, 1, 'Customer Request', 'New request from customer for the address is: 800 Mountain Rd', '{"title":"Customer Request","body":"New request from customer for the address is: 800 Mountain Rd","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.099313","pickup_lng":"-64.80668","pickup_add":"800 Mountain Rd","time":"2","u_pic":"","status":"0","request_id":862,"instructions":null,"payment_method":"1","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 14:24:17', NULL),
(2014, 862, 278, 862, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 14:24:24', NULL),
(2015, 862, 278, 862, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-22 14:24:48', NULL),
(2016, 863, 276, 863, 1, 'Customer Request', 'New request from customer for the address is: 39 Caspian Court,  Moncton', '{"title":"Customer Request","body":"New request from customer for the address is: 39 Caspian Court,  Moncton","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.106881","pickup_lng":"-64.855209","pickup_add":"39 Caspian Court,  Moncton","time":"9","u_pic":"","status":"0","request_id":863,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 15:04:41', NULL),
(2017, 863, 278, 863, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 15:04:45', NULL),
(2018, 863, 278, 863, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-22 15:04:48', NULL),
(2019, 864, 276, 864, 1, 'Customer Request', 'New request from customer for the address is: 39 Caspian Court,  Moncton', '{"title":"Customer Request","body":"New request from customer for the address is: 39 Caspian Court,  Moncton","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.106881","pickup_lng":"-64.855209","pickup_add":"39 Caspian Court,  Moncton","time":"9","u_pic":"","status":"0","request_id":864,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 15:07:43', NULL),
(2020, 865, 276, 865, 1, 'Customer Request', 'New request from customer for the address is: 800 Mountain Rd', '{"title":"Customer Request","body":"New request from customer for the address is: 800 Mountain Rd","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.099313","pickup_lng":"-64.80668","pickup_add":"800 Mountain Rd","time":"2","u_pic":"","status":"0","request_id":865,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 15:08:16', NULL),
(2021, 865, 278, 865, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 15:08:21', NULL),
(2022, 865, 278, 865, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-22 15:09:16', NULL),
(2023, 866, 276, 866, 1, 'Customer Request', 'New request from customer for the address is: 39 Caspian Court,  Moncton', '{"title":"Customer Request","body":"New request from customer for the address is: 39 Caspian Court,  Moncton","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.106881","pickup_lng":"-64.855209","pickup_add":"39 Caspian Court,  Moncton","time":"9","u_pic":"","status":"0","request_id":866,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 15:15:20', NULL),
(2024, 866, 278, 866, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 15:15:25', NULL),
(2025, 866, 276, 276, 1, 'Ride Cancelled', 'This ride is cancelled by Test Payg', '{"title":"Ride Cancelled","body":"This ride is cancelled by Test Payg","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","u_pic":"","status":"7","request_id":"866","pickup_at":null,"payment_method":"2","is_other":0}', 1, '2020-09-22 15:18:19', NULL),
(2026, 867, 276, 867, 1, 'Customer Request', 'New request from customer for the address is: 800 Mountain Rd', '{"title":"Customer Request","body":"New request from customer for the address is: 800 Mountain Rd","u_name":"Test Payg","u_ccode":" 1","u_phone":"506988","pickup_lat":"46.099313","pickup_lng":"-64.80668","pickup_add":"800 Mountain Rd","time":"2","u_pic":"","status":"0","request_id":867,"instructions":null,"payment_method":"2","is_other":null,"total_passenger":"1","pickup_at":"","drop_lat":"46.099313","drop_lng":"-64.80668","drop_add":"800 Mountain Rd","ride_type":0,"ride_date":"2020-09-22","ride_time":null}', 1, '2020-09-22 15:18:44', NULL),
(2027, 867, 278, 867, 1, 'Request Accept', 'Your request has been accepted by Kadher Sulaiman', '', 1, '2020-09-22 15:18:50', NULL),
(2028, 867, 278, 867, 1, 'Driver Arrived', 'Driver has been reached to your location.', '', 1, '2020-09-22 15:18:57', NULL);

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('00a6b36b8a4e2bcb5ed9d099e54b1f00f24b9b6e451a74ced314eb9166a09ff2113e941854108343', 278, 1, 'EasyHop', '[]', 0, '2020-09-22 14:17:20', '2020-09-22 14:17:20', '2021-09-22 14:17:20'),
('01b0aec60f44f9f52c32b8710307eea468796a9a65b35dc5a5c7c5a5d04ce4ed480f973b70924287', 271, 1, 'EasyHop', '[]', 0, '2020-09-21 15:02:34', '2020-09-21 15:02:34', '2021-09-21 15:02:34'),
('09b73c01c6edfe1f4f241627c991726237ae91cf88d2ca3d7bb6d595695b6e6078a821a28cb9ed0d', 279, 1, 'EasyHop', '[]', 0, '2021-09-09 07:04:51', '2021-09-09 07:04:51', '2022-09-09 12:34:51'),
('0a8195b967ef8020babe06e7e43043ef89e2149aa8840d13dcf07f1cddb307944a27e3f6cb3e2803', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:32:46', '2021-09-13 01:32:46', '2022-09-13 07:02:46'),
('0eaddebbdd02b084f97e35698bf748663b197ad953710d0a314a52876b3713bef7dfbc756d63eb2e', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:22:37', '2021-09-13 02:22:37', '2022-09-13 07:52:37'),
('147b2917c8156e86370ce565c5ea9b0b6a6f4b9de5141a2283f3a8592543f55e4414ddf7b03194f6', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:49:56', '2021-09-14 23:49:56', '2022-09-15 05:19:56'),
('14e6ab522e0127bcb7ce574b7f3f9b183d4b051e4cc55b44c29390dc7fdfd454f3154081a24b827b', 262, 1, 'EasyHop', '[]', 0, '2020-09-18 14:33:04', '2020-09-18 14:33:04', '2021-09-18 14:33:04'),
('1564957e7a6e86c03de345535464373e323c43eb50f3d92a74afca6efe4670b0dc31589aec3884ce', 262, 1, 'EasyHop', '[]', 0, '2020-09-18 17:41:17', '2020-09-18 17:41:17', '2021-09-18 17:41:17'),
('19bae311272133bf5bf275529c337453b1598ddcd769ceda149e9c83977018c86db6a78a10fb5464', 274, 1, 'EasyHop', '[]', 0, '2020-09-21 14:46:47', '2020-09-21 14:46:47', '2021-09-21 14:46:47'),
('1d286c422793e62fe849f831692af5b483c65c883e37c8099e4c741f3fffb479358f4104ced24969', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:27:25', '2021-09-13 01:27:25', '2022-09-13 06:57:25'),
('1d51a7f0452e2589bd97db30b72e40238a76633bd7f05dad29573d446ef7c4203b760a7a2072e5c0', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 06:40:11', '2021-09-02 06:40:11', '2022-09-02 12:10:11'),
('1fd449570475f33395b4be707ff87a3d381221572f4fa375f3a5097bae769836770f44b93425fa7d', 266, 1, 'EasyHop', '[]', 0, '2020-09-18 17:27:01', '2020-09-18 17:27:01', '2021-09-18 17:27:01'),
('21e78aabca81465b855bad3a19b3627b355873a4e2c7a3222d39b0b32df73ed4cc41ff7a6e39b04a', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:18:59', '2021-09-13 01:18:59', '2022-09-13 06:48:59'),
('220a0397295853cd328a5b2aff28ca3233c2240b9459373f6daf41b7255dfeeead21e661eb0bce4a', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:56:25', '2021-09-14 23:56:25', '2022-09-15 05:26:25'),
('22b20e9e09dde3bce9e41dbd3851319c790043865f459cfcb2319a3c6f948e42c8cb7f20f4ef5d79', 272, 1, 'EasyHop', '[]', 0, '2020-09-21 11:35:47', '2020-09-21 11:35:47', '2021-09-21 11:35:47'),
('241357efcdfca45fc08293cd52274e4c75a68edab16d501ce04ef83933c8e1ab01abcbd103e51289', 264, 1, 'EasyHop', '[]', 0, '2020-09-18 15:33:52', '2020-09-18 15:33:52', '2021-09-18 15:33:52'),
('24271760f8f6684be2d46bc0eb29dfc75071f7e01bc9f0cd4757db8d5b981fc5dd110f9d4a645b97', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 02:19:57', '2021-09-09 02:19:57', '2022-09-09 07:49:57'),
('2556820903254859555d15866766932d5ec8b22ff1370a2d58f0f260804b11fdf2d73077bca497de', 261, 1, 'EasyHop', '[]', 0, '2020-09-18 14:30:27', '2020-09-18 14:30:27', '2021-09-18 14:30:27'),
('2667586479ce96a5feda0636d893b5f59a5374afbe2d5c59a4b6887e16e0d26db6a00bb25593fe37', 281, 1, 'EasyHop', '[]', 0, '2021-09-02 06:13:47', '2021-09-02 06:13:47', '2022-09-02 11:43:47'),
('273468f058f0d5ea34b2f4a24cc78fc5930f2770c8b0064d0b4f7a55a68378409d01ae8a04e056d8', 262, 1, 'EasyHop', '[]', 0, '2021-09-02 07:36:16', '2021-09-02 07:36:16', '2022-09-02 13:06:16'),
('29859e0047d10367b08efafd456f75e06ffd874ab5c396f965886ece14365cf1c561ec2ae9f067ee', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:05:44', '2021-09-09 07:05:44', '2022-09-09 12:35:44'),
('2a20887baa9ae6df5f77a6810be3540ee7ba044047a8c26a03e69c4e7c74416d402902d465ecec57', 261, 1, 'EasyHop', '[]', 0, '2021-09-02 06:12:30', '2021-09-02 06:12:30', '2022-09-02 11:42:30'),
('2bde1fb36033bfd1518a88e624d2cce8b48dc6fa1d498fa06127ea2880f041d0887b19a0781b92c7', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:03:43', '2021-09-13 02:03:43', '2022-09-13 07:33:43'),
('30bbe311cb51635c5cf16745009d0464f69eb224cbb1cd13af295e9282d9af916c87232c7f8d1187', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:42:50', '2021-09-14 23:42:50', '2022-09-15 05:12:50'),
('30dabf25407952e1ed24a6f563bb2176601638d0b46b37e9761799ddb0efe44be265a107a9b1fa73', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:00:49', '2021-09-09 07:00:49', '2022-09-09 12:30:49'),
('32ecac662c6a64eee5dc7bfb84902cea356dbd2a764d406f6bc4a11070a79b031a54d0919e7c1016', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:38:31', '2021-09-13 01:38:31', '2022-09-13 07:08:31'),
('3421a21096a77b8605b25cf708ec9a6d67cca78278df367ca1c268be7559e7df5962c0dd824f0e3b', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:46:36', '2021-09-13 01:46:36', '2022-09-13 07:16:36'),
('35c9800bba84698a200d3b36e243b7071d65de2dd1165f9562a795d2ab098f28a5bc28778931ba2d', 262, 1, 'EasyHop', '[]', 0, '2021-09-02 08:13:04', '2021-09-02 08:13:04', '2022-09-02 13:43:04'),
('36ff4e9b83525db516b1912d55a09d48d3549f3ae9d8f40a0d9c120132b2c341965ad392bf247efc', 261, 1, 'EasyHop', '[]', 0, '2021-09-02 06:08:13', '2021-09-02 06:08:13', '2022-09-02 11:38:13'),
('373ea4c482c7be7f230f36ebd4301d9beee6a767e2e8d22efb013e791477c44196790be9c1d5de8b', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:09:57', '2021-09-13 02:09:57', '2022-09-13 07:39:57'),
('39da52675d92c69f6b9d2deb38281152c3822ae9e064d23538d93d2f8ec247c7e86051c4e443431b', 261, 1, 'EasyHop', '[]', 0, '2021-09-09 05:22:27', '2021-09-09 05:22:27', '2022-09-09 10:52:27'),
('3bb5ea1aaed53671f616008e9b3bb083839647909b2fb1e80c17d7f0af79ff967f458dbdb4a63bc1', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:04:56', '2021-09-09 07:04:56', '2022-09-09 12:34:56'),
('3c4e139e88ef8517ce9065b2aca0f34d716929c66b4a05dd3e5123ba6318e18b7899af65609f282a', 266, 1, 'EasyHop', '[]', 0, '2020-09-18 17:28:17', '2020-09-18 17:28:17', '2021-09-18 17:28:17'),
('41a00437c21ef903bc5f8d6fc971cecb2becb721fc4f50742c8af42cdc71c447d73f9be24ced1821', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:32:03', '2021-09-15 00:32:03', '2022-09-15 06:02:03'),
('41e58441636262ed0f1e40e863a75e4f479950a6102f578fc1e7d39c6a5fc6794b7b62b748a0f818', 272, 1, 'EasyHop', '[]', 0, '2020-09-21 11:04:30', '2020-09-21 11:04:30', '2021-09-21 11:04:30'),
('44045226f3fe5e1cb7913392958aa49e241f621e8e00726b24afe7a8cd8baeda89e53b8c85a91004', 274, 1, 'EasyHop', '[]', 0, '2020-09-20 12:23:33', '2020-09-20 12:23:33', '2021-09-20 12:23:33'),
('467c6b5516f327e511d3d8900b502109eea421b65a4c4a1557bf8c4cef331d05f72ecdc06696cb58', 263, 1, 'EasyHop', '[]', 0, '2020-09-18 14:33:52', '2020-09-18 14:33:52', '2021-09-18 14:33:52'),
('48a02b67ff992a04529ad56f37b75869698feed46039395b6b0d7d04db447379aebbaa8302c1b24f', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:46:35', '2021-09-14 23:46:35', '2022-09-15 05:16:35'),
('4e4e36774a7953cfbd50b7c488dcf9ea9bccdc611dae283cc91cc0c9a419b8c2402c3db7d7c798ae', 267, 1, 'EasyHop', '[]', 0, '2020-09-18 17:40:59', '2020-09-18 17:40:59', '2021-09-18 17:40:59'),
('4f4ac244fe43c12a4dfbb0b0ecddf97bc771fc0b1eaf820045df3d5e37c7d2c094cc03f90b3e52b9', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:03:51', '2021-09-15 00:03:51', '2022-09-15 05:33:51'),
('512c07314a03f00c606c8f8e45fb6a597c3375b5d781fbd47c018c0359fea92764405cca9d50bc78', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:35:00', '2021-09-09 07:35:00', '2022-09-09 13:05:00'),
('53f80a75efd934c141815e8a5489eb2824b67e77df6cb0a696be0fa6b79184874b26f175c8c463e3', 275, 1, 'EasyHop', '[]', 0, '2020-09-21 13:29:22', '2020-09-21 13:29:22', '2021-09-21 13:29:22'),
('54d44ee6c3bbd17a9e61097d67b67b4d0b1318428569a05f448715ca87f668713dd3cd4a9bfe281c', 279, 1, NULL, '[]', 0, '2021-09-02 06:09:00', '2021-09-02 06:09:00', '2022-09-02 11:39:00'),
('57d223fbcf33aaf44f461c9283dcaebdf67265c0b526a93cd04af84063bf69efef2931596f7efe3a', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:15:56', '2021-09-13 02:15:56', '2022-09-13 07:45:56'),
('5bcee14abc10adf1b94d1526767fa58b4a3cddf8b480a277d7e7ff99f4b62a938cf85a122374ef37', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 06:14:37', '2021-09-02 06:14:37', '2022-09-02 11:44:37'),
('615036524147496f50a4f9d6b076a76cf0d45e8c2005aee2d4dca868dae0ae4ed0ef84920ff1220d', 270, 1, 'EasyHop', '[]', 0, '2020-09-20 12:01:41', '2020-09-20 12:01:41', '2021-09-20 12:01:41'),
('6664c67bc8f42a2d63c42e635becda39ee30650bb42094c18ef893111d8f11515e649c42e0be9f65', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:33:23', '2021-09-13 02:33:23', '2022-09-13 08:03:23'),
('66e25f3e9417b072be9f6f2d9222baa61313a3fdd47a49a038fffadfad141577007c2f96ffe75f83', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 05:19:11', '2021-09-13 05:19:11', '2022-09-13 10:49:11'),
('695d5c4e052c3b47e30550e9e7c7d46b785207d1ddd15c05979de73136f22736f7c6500730c0e953', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:50:53', '2021-09-14 23:50:53', '2022-09-15 05:20:53'),
('6a02a0c1fe2c0e1460705b95fca4d2ae02161ef8bded5980439a7bf349f72e08139c92c2bca9b938', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 06:14:03', '2021-09-02 06:14:03', '2022-09-02 11:44:03'),
('6a594fa8a5e38f658ef52db7b1c4388effa38c9fcb627384d20a09233064fea7ece555ed29f9b996', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:12:54', '2021-09-13 02:12:54', '2022-09-13 07:42:54'),
('6a7b3533212cd00474032f8f98c2916c4b8e1b6552015f86d9b579579953548f5ee2f01086a2af9c', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 05:39:21', '2021-09-09 05:39:21', '2022-09-09 11:09:21'),
('6f6689eed506dd52eec26e25cca0ab04070266d5bc05fb45c1c25b36e9de717eb366891026dee9f7', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:46:33', '2021-09-15 00:46:33', '2022-09-15 06:16:33'),
('7124a8ea81f7618df99ed377be0ed7dd7595005b6b46622b0559a34f26b9b1b02d7489ab5fb12fd5', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 02:23:07', '2021-09-15 02:23:07', '2022-09-15 07:53:07'),
('72ac1ff37bd3bf24046675604bc113e71cc3936c232827bba820e3417cd05b8a074538abfb72c01d', 270, 1, 'EasyHop', '[]', 0, '2020-09-20 12:05:09', '2020-09-20 12:05:09', '2021-09-20 12:05:09'),
('72ee5fcdb449a50f1dc2aa31a69440175db9fd909b63cef89760e9b67fa0911d15d7830a8d50a690', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:36:15', '2021-09-15 00:36:15', '2022-09-15 06:06:15'),
('74f60515790e291933f18206acb6531efbb21541ffe33bde784988266edc91c0b1bd3475a210f3e9', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 23:58:39', '2021-09-14 23:58:39', '2022-09-15 05:28:39'),
('77dd2a922dedb1e9542a07501262e46b93eac1739436cb7c2b4c3d5272624ca1986ed6758e4bc773', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:36:00', '2021-09-13 01:36:00', '2022-09-13 07:06:00'),
('78e3ec4f4cfe0e1ed1f2e5541da051fbed0c1624d2d64c66bc18b3c749a836eaf6c2e072a6b78d1b', 262, 1, 'EasyHop', '[]', 0, '2021-09-05 23:57:33', '2021-09-05 23:57:33', '2022-09-06 05:27:33'),
('7dc83c9aedee2eee74d970a27bdf35bcba22e61d82e87214d6a3e06cbcf49c86dab0cee8e7f7b4b9', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:30:20', '2021-09-09 07:30:20', '2022-09-09 13:00:20'),
('7ea7c6cc121d831197788f3c13a2e214cb6fef77b53a1b0edc6e4b239a4fea02cce820c7122615b8', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:19:09', '2021-09-13 01:19:09', '2022-09-13 06:49:09'),
('802f340bd972df23e2ff0a0f735fd98cfb61cb9966b30ee8a1be7c48554677a001abb3eeb4d450ef', 268, 1, 'EasyHop', '[]', 0, '2020-09-18 18:06:40', '2020-09-18 18:06:40', '2021-09-18 18:06:40'),
('850750e0f9c2fd058b4f5d3ccfa3c232f59df2c7970081307319abfcb560be7b965c988bbe446d69', 262, 1, 'EasyHop', '[]', 0, '2021-09-10 04:36:00', '2021-09-10 04:36:00', '2022-09-10 10:06:00'),
('8622d2db1f9ba2620c831d99182aad14fe41417219d7b5dfdfa9fe9040c9ee32c9c9580ebc5e3ed9', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 00:47:43', '2021-09-13 00:47:43', '2022-09-13 06:17:43'),
('869482ce189362e4e03a6f9d02ed7db76973e3f03e7e0f0f8198e6cd8d13237bd2dfa0ab7fd73520', 262, 1, 'EasyHop', '[]', 0, '2020-09-18 17:43:16', '2020-09-18 17:43:16', '2021-09-18 17:43:16'),
('898a15815506a6604b23abaea5b6d9cb823e9b110196eaec71de4d9cd557f03bd7b30832335d939d', 262, 1, 'EasyHop', '[]', 0, '2020-09-20 12:15:29', '2020-09-20 12:15:29', '2021-09-20 12:15:29'),
('8e42afb342c2743fcd971f7550d4eff86a13d819380ee20b3ee478ee27644cdb433f413fb9565ba7', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 07:10:53', '2021-09-09 07:10:53', '2022-09-09 12:40:53'),
('8f65ac4d30e235eb7c98a28c3229a16827d1b1c4d6a58a31e7448cf1907562b77de2dcff6c1ee80e', 271, 1, 'EasyHop', '[]', 0, '2020-09-20 12:09:05', '2020-09-20 12:09:05', '2021-09-20 12:09:05'),
('9204a35d27fd197b74ca034fad97c6391b4857df1fe19c8f1acf888b71550989877441c3e603f381', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 02:16:24', '2021-09-09 02:16:24', '2022-09-09 07:46:24'),
('93025626f2f783c3924653c105535b6975d0ac02bea05b6300fe7cf06d31f22abbae4d8579894139', 274, 1, 'EasyHop', '[]', 0, '2020-09-20 12:26:43', '2020-09-20 12:26:43', '2021-09-20 12:26:43'),
('9577e986c1a124306e40f3d671685fd470d442c7a6d8d86e7f6972aaa1ca6534e9b992642a2edeb2', 263, 1, 'EasyHop', '[]', 0, '2020-09-18 15:44:33', '2020-09-18 15:44:33', '2021-09-18 15:44:33'),
('97cb632d9f82057961fa62916b96b248af79053e7a735f67a78e9248d3abf3306364f035e9a265a7', 273, 1, 'EasyHop', '[]', 0, '2020-09-21 14:43:50', '2020-09-21 14:43:50', '2021-09-21 14:43:50'),
('980c864aa0c2547b22b5da538a97e89170ba9aca1aba842e7970feee2bb89cefb693ff82188aa1e3', 264, 1, 'EasyHop', '[]', 0, '2020-09-18 15:30:49', '2020-09-18 15:30:49', '2021-09-18 15:30:49'),
('99d0e58beb1b3962a17489f8348a5cce9f9026ff9ba9dc0768410e9a904efd255feb6be90d7348a5', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:34:58', '2021-09-15 00:34:58', '2022-09-15 06:04:58'),
('9a090837e222288fa79de29780e495c63d581c6297194e802ab5fae361816e19e22c11bded561fca', 279, 1, 'EasyHop', '[]', 0, '2021-09-09 05:21:28', '2021-09-09 05:21:28', '2022-09-09 10:51:28'),
('9b644cd654d762e232e5d699432bb03d971d30537f094c5cec5531afab6ef706faccbe5662ab9f73', 273, 1, 'EasyHop', '[]', 0, '2020-09-20 12:18:49', '2020-09-20 12:18:49', '2021-09-20 12:18:49'),
('9fd335d211b4666b8f3d63315ffc0465f49fdaae39d35b9c24f57359e41aeafdcb2b0770d92556cc', 265, 1, 'EasyHop', '[]', 0, '2020-09-18 17:04:25', '2020-09-18 17:04:25', '2021-09-18 17:04:25'),
('a1d7cb5428e1659c8ca42bb2ffbb01fcb794f83cf172eb88ed0c88149e1f534a4221512f23d1ee4f', 272, 1, 'EasyHop', '[]', 0, '2020-09-22 09:09:50', '2020-09-22 09:09:50', '2021-09-22 09:09:50'),
('a256d5f2885f8e294791236ac308da223374f4bac24d175a27a34f17b16f4623914259cabd7a0f63', 273, 1, 'EasyHop', '[]', 0, '2020-09-22 06:34:18', '2020-09-22 06:34:18', '2021-09-22 06:34:18'),
('a479c6e150c48b1dd2ca6db67011ca5a69e6e499e893c93661293782174a19927e8e58ac9fb035e6', 280, 1, NULL, '[]', 0, '2021-09-02 06:09:34', '2021-09-02 06:09:34', '2022-09-02 11:39:34'),
('a5196a6614fbdaf60a542047e3f567ae859765c659775083b42b69c7deca9e6fdf804283d2499190', 279, 1, 'EasyHop', '[]', 0, '2021-09-02 06:12:44', '2021-09-02 06:12:44', '2022-09-02 11:42:44'),
('a7fbf6f7fc1ca35c2adc2b06e856f5330d60768cd84ecab7cca065e425fa9ab7ef7c485ce1bd81ab', 264, 1, 'EasyHop', '[]', 0, '2021-09-02 07:38:35', '2021-09-02 07:38:35', '2022-09-02 13:08:35'),
('ae64f883b6be90f80018d6e4e6b8a21123f56939044a0bd1ceec4ebbf39ab07eed8ec179d48abcdf', 277, 1, 'EasyHop', '[]', 0, '2020-09-21 14:57:38', '2020-09-21 14:57:38', '2021-09-21 14:57:38'),
('afacbc10d24f893d335159bd6f75c922374a135e308fcf490f0b2198ea62428e028a1dfd8abfa5a4', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:19:25', '2021-09-13 02:19:25', '2022-09-13 07:49:25'),
('b0bd353d20efb953a07e8cd2202d7dc90e789bd14e32e5d28627b2527c63b520eb4a0d2e3c030e99', 262, 1, 'EasyHop', '[]', 0, '2021-09-14 04:54:20', '2021-09-14 04:54:20', '2022-09-14 10:24:20'),
('b0dcc9c0f54439dccb0c3b08e35d8ee6d0874447eb07b60c03edb9834787ceb7f29d6b1d3c9c9f49', 271, 1, 'EasyHop', '[]', 0, '2020-09-20 12:07:53', '2020-09-20 12:07:53', '2021-09-20 12:07:53'),
('b0dd95a6cc3033da24108dd16bc603748335142badf1bf14c55429c457a78c0542230a36ba82afe5', 261, 1, 'EasyHop', '[]', 0, '2021-09-13 01:12:04', '2021-09-13 01:12:04', '2022-09-13 06:42:04'),
('b3f335aee5cd7e8efd0e768a04d6a9ab1bd4982c37a81052206296b913d1939f9c2883c7a01e45c0', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:19:14', '2021-09-13 02:19:14', '2022-09-13 07:49:14'),
('b611cadda6b8e6317b25a3908db7b4b51505f47e1f2aeb70c10308986627385c3b6b20203713df06', 269, 1, 'EasyHop', '[]', 0, '2020-09-18 18:24:05', '2020-09-18 18:24:05', '2021-09-18 18:24:05'),
('b83c09470054106b51dc501706dd64d49d6296b9aec28ff40b3a3dd122527b231383d0a71fa58f0b', 263, 1, 'EasyHop', '[]', 0, '2020-09-18 14:36:02', '2020-09-18 14:36:02', '2021-09-18 14:36:02'),
('b8f1a5a7776fc2e976ec4c548412d8b4924463b37a50580193057ca22a5bbe448e27f25362b99607', 263, 1, 'EasyHop', '[]', 0, '2021-09-09 04:32:06', '2021-09-09 04:32:06', '2022-09-09 10:02:06'),
('bfd169547bb6edb40b7cdbccf89ed8f06adc1521ef5ef6226d76fef416be697c8ecd477b9fd14c48', 279, 1, 'EasyHop', '[]', 0, '2021-09-09 07:00:55', '2021-09-09 07:00:55', '2022-09-09 12:30:55'),
('c0338f79aa9021375ba2627c28c985296db1ac41dbf7aa1b3be87b6dcac65dbe9e22392b1576a3df', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:13:51', '2021-09-13 02:13:51', '2022-09-13 07:43:51'),
('c1e42095c8be0dc7b1e62aee76fded51749773b10f29026a8923fede19d01fe1660757a6340d59ae', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 05:24:46', '2021-09-09 05:24:46', '2022-09-09 10:54:46'),
('c22cedb2711b9e9ed08d996403b3c6b16fe10346c2033c8c27deff0d2770aa99e1018eea2714a147', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 04:30:20', '2021-09-09 04:30:20', '2022-09-09 10:00:20'),
('c3376d48c5385f88fef0371d55b423b325c4fcf7b7bc919dcf500087f89e1759af669f7ecb906206', 264, 1, 'EasyHop', '[]', 0, '2020-09-18 16:27:31', '2020-09-18 16:27:31', '2021-09-18 16:27:31'),
('c429bdb90f43694d26cfe395c2a87c104e77596d62d92225c434328ae3fa82e4b642fadd0317452d', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:20:13', '2021-09-13 01:20:13', '2022-09-13 06:50:13'),
('c483cbde878e1fbcf0fef4d112562dff31eea899cec97fd9d753a9b437ade7427f948734bf635bee', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:01:21', '2021-09-15 00:01:21', '2022-09-15 05:31:21'),
('c751ff2491f6dca3ebf8fb1c773702d3a976097a88c4f42f77265b3a13e90ff471fb4bbeec515c90', 276, 1, 'EasyHop', '[]', 0, '2020-09-22 14:14:23', '2020-09-22 14:14:23', '2021-09-22 14:14:23'),
('c846d604778fd427e763d85ffec555207d8c4717d93e01a593638aa7e0191ab8674eaadbd9b5f0dc', 281, 1, NULL, '[]', 0, '2021-09-02 06:13:09', '2021-09-02 06:13:09', '2022-09-02 11:43:09'),
('c85b2dfcabec1060cb0284352d40b7af25b970066395edb27276a493bd23d6db8cdb56b0187b08e2', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:26:47', '2021-09-13 02:26:47', '2022-09-13 07:56:47'),
('c871a56937801dfc608f094fc7b6630b1cb8e6eda054276c4715f43885fe73de76399b54dc1c8a9f', 276, 1, 'EasyHop', '[]', 0, '2020-09-22 14:14:48', '2020-09-22 14:14:48', '2021-09-22 14:14:48'),
('ca69a81cd652dbdcd1882be5cb142c286557a19b05f4728da78e092a187d810920086aca6cebd13e', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 06:26:29', '2021-09-09 06:26:29', '2022-09-09 11:56:29'),
('cb73a68dcbfbc0dfeacfe60a3a9262f680a52e444ba4548cea57750cdefe68141ba049ca3e039b4b', 261, 1, 'EasyHop', '[]', 0, '2021-09-13 04:59:11', '2021-09-13 04:59:11', '2022-09-13 10:29:11'),
('ce5575ce2184313a51db197675b0c3a63b6adbc0975307a0d8b55de6bf925df34d66903c6c6e4575', 261, 1, 'EasyHop', '[]', 0, '2021-09-02 06:06:05', '2021-09-02 06:06:05', '2022-09-02 11:36:05'),
('d13d116b155dbcd979dc27aa72ffe12308f2d03bbc8e009bc973b6fc9fd0e11d748c216fda63b404', 270, 1, 'EasyHop', '[]', 0, '2020-09-21 15:25:35', '2020-09-21 15:25:35', '2021-09-21 15:25:35'),
('dc0bf3880d8b83ce8de5105fd29d941c2dd26ed10c5703c373f69addf863d1336946dfbe21582e8e', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 06:20:36', '2021-09-02 06:20:36', '2022-09-02 11:50:36'),
('dce05a5895aa77312811229b31a8dfcee65dc89c2af3ac8d1792b9334837ea510ba0b2d614e67159', 272, 1, 'EasyHop', '[]', 0, '2020-09-20 12:12:44', '2020-09-20 12:12:44', '2021-09-20 12:12:44'),
('dfd2e8c1701e182bebb4ebedb53ce5f96d470b23cb30a6744f743c0cf396318e13006e3372e77bfa', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 06:00:44', '2021-09-13 06:00:44', '2022-09-13 11:30:44'),
('e2eec2f1bfa69f6e3e9ddaed2ea62d06edceb2c5fb3bbcf204408b408b461de1f3472ed8a2dfb140', 277, 1, 'EasyHop', '[]', 0, '2020-09-21 14:55:17', '2020-09-21 14:55:17', '2021-09-21 14:55:17'),
('e31f3d7ade227f08cd08568f4d1ff577ba1ef2996e08824aa4fa84e9e00f803228fefce648fb848a', 273, 1, 'EasyHop', '[]', 0, '2020-09-20 12:19:49', '2020-09-20 12:19:49', '2021-09-20 12:19:49'),
('eef0cefcef3571c1612ce899be214a9adf77c6e6404a229dd35d5955927dabf84994153c395a7105', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 02:36:13', '2021-09-13 02:36:13', '2022-09-13 08:06:13'),
('f67087deeb3fe1a18ce0c14ce994b0133de03f7f87328d673363caa8906d0d29948a7683416c15d8', 263, 1, 'EasyHop', '[]', 0, '2021-09-02 07:37:23', '2021-09-02 07:37:23', '2022-09-02 13:07:23'),
('f80736a02c5caf9b882221b452441a1e0d66cb954c45f09d310b574a0f425ba72009808794166d55', 272, 1, 'EasyHop', '[]', 0, '2020-09-20 12:16:02', '2020-09-20 12:16:02', '2021-09-20 12:16:02'),
('f826a22de5163abc1b8fc5e23067bbb6d33646c4ece3760b45c2cc40b11bd5a3dee923fbcda4d219', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 06:26:21', '2021-09-02 06:26:21', '2022-09-02 11:56:21'),
('f8651270b5050c5987d3fc294dfe9e730b0052b2a9fcfaed9efe0ae51381184c2add6d3ac719813c', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 03:14:22', '2021-09-13 03:14:22', '2022-09-13 08:44:22'),
('fa0bd6b36018edc4d95b2bd138883d656b6adc003fef8cc28054d1f8518fe0f7a86281c1cfe14330', 262, 1, 'EasyHop', '[]', 0, '2021-09-15 00:37:33', '2021-09-15 00:37:33', '2022-09-15 06:07:33'),
('fb77ed642b5a42236c60cfb145c1527ba54943f0bb0b82d5753a6090dae3c15e9f82c577772c705b', 262, 1, 'EasyHop', '[]', 0, '2021-09-09 06:03:57', '2021-09-09 06:03:57', '2022-09-09 11:33:57'),
('fc7dc65aad1c6bd53b0838fc5dbd2e48883ceb00f602a552266be793e3e8041a9fe281fd0d1ff8f0', 262, 1, 'EasyHop', '[]', 0, '2020-09-18 14:30:31', '2020-09-18 14:30:31', '2021-09-18 14:30:31'),
('fce8c465d5dda4c62005292ddd8fa26a9339b331ce8a04aa882c69b5529214624a14f90cafa8d69d', 262, 1, 'EasyHop', '[]', 0, '2021-09-13 01:13:41', '2021-09-13 01:13:41', '2022-09-13 06:43:41'),
('fe1854075f7890c879bb4d129bcc3c4151c647542da800d6d7f6dd8e58346814dd1c1db1d0f3602f', 280, 1, 'EasyHop', '[]', 0, '2021-09-02 07:00:18', '2021-09-02 07:00:18', '2022-09-02 12:30:18');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE IF NOT EXISTS `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE IF NOT EXISTS `oauth_clients` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'EasyHop Personal Access Client', 'Jo3tEdBbAjy4gJF6hbIyi4AY9X7PzWrjb40cn8us', 'http://localhost', 1, 0, 0, '2019-05-27 20:26:00', '2019-05-27 20:26:00'),
(2, NULL, 'EasyHop Password Grant Client', 'p2FXdAVzDRkQm4fRejZXCxtEENKJO2zIGVleDXND', 'http://localhost', 0, 1, 0, '2019-05-27 20:26:00', '2019-05-27 20:26:00');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE IF NOT EXISTS `oauth_personal_access_clients` (
  `id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2019-05-27 20:26:00', '2019-05-27 20:26:00');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_name` text COLLATE utf8mb4_unicode_ci,
  `route` text COLLATE utf8mb4_unicode_ci,
  `icon` text COLLATE utf8mb4_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `page_name`, `route`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Dashboard', 'home', 'admin/dashboard', 'fas fa-home', 1, '2019-07-11 07:30:00', NULL),
(2, 'Car Categories', 'car_categories', 'admin/car_categories', 'fas fa-car', 1, '2019-07-11 07:30:00', NULL),
(3, 'Customers', 'customers', 'admin/customer_list', 'fas fa-users', 1, '2019-07-11 07:30:00', NULL),
(4, 'Drivers', 'drivers', 'admin/driver_list', 'fas fa-users', 1, '2019-07-11 07:30:00', NULL),
(5, 'Business Users', 'bs_user', 'admin/business_users', 'fas fa-user-friends', 1, '2019-07-11 07:30:00', NULL),
(6, 'Price Management', 'price', 'admin/price_list', 'fas fa-money-bill-alt', 1, '2019-07-11 07:30:00', NULL),
(7, 'Coupon Management', 'coupons', 'admin/coupon_list', 'fas fa-tag', 1, '2019-07-11 07:30:00', NULL),
(8, 'Cancellation Reasons', 'reasons', 'admin/cancel_reasons', 'fa fa-ban', 1, '2019-07-11 07:30:00', NULL),
(9, 'Bookings', 'bookings', 'admin/bookings', 'fa fa-bookmark', 1, '2019-07-11 07:30:00', NULL),
(10, 'Bookings Report', 'bookings_today', 'admin/bookings_this', 'far fa-flag', 0, '2019-08-29 13:00:00', NULL),
(11, 'Sales Report', 'sales_report', 'admin/sales_report', 'fas fa-signal', 1, '2019-08-29 13:00:00', NULL),
(12, 'Transactions', 'transaction', 'admin/transaction', 'fas fa-money-check-alt', 1, '2019-08-29 13:00:00', NULL),
(13, 'Rate Card', 'rate_card', 'admin/rate_card_list', 'fas fa-vr-cardboard', 0, '2019-09-23 13:00:00', NULL),
(14, 'Site Earning', 'earning', '#', 'fas fa-dollar-sign', 1, '2019-09-23 13:00:00', NULL),
(15, 'Team', 'team', 'admin/team', 'fas fa-user-friends', 1, '2019-09-24 13:00:00', NULL),
(16, 'Support', 'support', 'admin/support', 'fas fa-ticket-alt', 1, '2019-09-24 13:00:00', NULL),
(17, 'Settings', 'setting', '#', 'fas fa-cog', 1, '2019-12-24 01:30:00', '2019-12-24 01:30:00');

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

--
-- Table structure for table `plan_recharges`
--

CREATE TABLE IF NOT EXISTS `plan_recharges` (
  `id` bigint(20) unsigned NOT NULL,
  `driver_id` bigint(20) unsigned NOT NULL,
  `amount` varchar(191) NOT NULL DEFAULT '0',
  `pending_amount` float NOT NULL DEFAULT '0',
  `start_date` varchar(191) DEFAULT NULL,
  `expiry_date` varchar(191) DEFAULT NULL,
  `plan_type` bigint(20) unsigned NOT NULL DEFAULT '1',
  `payment_id` varchar(191) DEFAULT NULL,
  `weekly_charge` int(11) NOT NULL DEFAULT '0',
  `is_reactivate` int(11) NOT NULL DEFAULT '0',
  `online` int(11) NOT NULL DEFAULT '0' COMMENT 'total online amount',
  `is_paid` int(11) NOT NULL DEFAULT '0',
  `is_settled` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 week amount settled, 0 means not',
  `is_past_week` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 past week, 0 current week',
  `is_admin` int(11) NOT NULL DEFAULT '0',
  `payment_method` int(11) NOT NULL DEFAULT '1' COMMENT '1 online, 2 cash, 3 wallet, 4 pos',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `plan_recharges`
--

INSERT INTO `plan_recharges` (`id`, `driver_id`, `amount`, `pending_amount`, `start_date`, `expiry_date`, `plan_type`, `payment_id`, `weekly_charge`, `is_reactivate`, `online`, `is_paid`, `is_settled`, `is_past_week`, `is_admin`, `payment_method`, `created_at`, `updated_at`) VALUES
(302, 263, '0', 3.27, '2020-09-11 20:05:44', '2020-09-13 23:59:59', 2, NULL, 200, 0, 0, 0, 1, 1, 1, 2, '2020-09-11 09:05:44', '2020-09-18 10:52:15'),
(303, 264, '0', 0, '2020-09-11 21:03:35', '2020-09-13 23:59:59', 2, NULL, 200, 0, 0, 1, 1, 1, 1, 2, '2020-09-11 10:03:35', '2020-09-18 11:21:04'),
(304, 263, '0.94', 0, '2020-09-18 21:03:35', '2020-09-22 23:59:59', 2, 'REC-1600446132775', 200, 1, 4, 0, 0, 0, 0, 1, '2020-09-18 10:52:15', '2020-09-18 10:52:15'),
(305, 264, '0.84', 0, '1600467664', '7664-09-21 23:59:59', 2, 'REC-1600447863860', 200, 1, 0, 0, 0, 0, 0, 1, '2020-09-18 11:21:04', '2020-09-18 11:21:04'),
(306, 265, '0', 3.78, '2020-09-11 22:34:35', '2020-09-13 23:59:59', 2, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-11 11:34:35', '2020-09-18 11:56:49'),
(307, 265, '0.42', 0, '2020-09-18 22:50:43', '2020-09-20 23:59:59', 2, 'REC-1600449642977', 200, 1, 4, 0, 0, 0, 0, 1, '2020-09-18 11:50:43', '2020-09-18 11:50:43'),
(308, 266, '0', 0, '2020-09-11 22:58:23', '2020-09-13 23:59:59', 2, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-11 11:58:23', '2020-09-18 12:09:57'),
(309, 266, '0.43', 0, '2020-09-18 23:09:57', '2020-09-20 23:59:59', 2, 'REC-1600450797308', 200, 1, 0, 0, 0, 0, 0, 1, '2020-09-18 12:09:57', '2020-09-18 12:09:57'),
(310, 262, '85.71', 0, '2020-09-11 23:12:02', '2020-09-13 23:59:59', 1, NULL, 200, 0, 0, 1, 1, 1, 1, 2, '2020-09-11 12:12:02', '2020-09-18 12:29:41'),
(311, 262, '85.71', 0, '2020-09-18 23:29:41', '2020-09-20 23:59:59', 1, 'REC-1600451981246', 200, 1, 9, 0, 0, 0, 0, 1, '2020-09-18 12:29:41', '2020-09-18 12:29:41'),
(312, 268, '85.71', 0, '2020-09-11 23:37:30', '2020-09-13 23:59:59', 1, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-11 12:37:30', '2020-09-18 12:45:52'),
(313, 268, '85.71', 0, '2020-09-18 00:00:01', '2020-09-20 23:59:59', 1, NULL, 200, 1, 0, 1, 0, 0, 1, 1, '2020-09-18 12:45:51', '2020-09-18 12:45:52'),
(314, 269, '85.71', 0, '2020-09-11 23:54:37', '2020-09-13 23:59:59', 1, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-11 12:54:37', '2020-09-18 13:09:20'),
(315, 269, '57.14', 0, '2020-09-19 00:09:20', '2020-09-20 23:59:59', 1, 'REC-1600454359066', 200, 1, 5, 0, 0, 0, 0, 1, '2020-09-18 13:09:20', '2020-09-18 13:09:20'),
(316, 270, '0', 0, '2020-09-20 17:35:14', '2020-09-20 23:59:59', 2, NULL, 200, 0, 0, 0, 0, 0, 0, 1, '2020-09-20 06:35:14', '2020-09-20 06:35:14'),
(317, 271, '0', 0, '2020-09-20 17:39:13', '2020-09-20 23:59:59', 2, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-20 06:39:13', '2020-09-22 03:45:05'),
(318, 272, '28.57', 0, '2020-09-20 17:46:35', '2020-09-20 23:59:59', 1, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-20 06:46:35', '2020-09-21 09:12:28'),
(319, 273, '28.57', 180, '2020-09-20 17:50:25', '2020-09-20 23:59:59', 1, NULL, 200, 0, 0, 1, 1, 1, 0, 1, '2020-09-20 06:50:25', '2020-09-21 09:15:25'),
(320, 274, '28.57', 0, '2020-09-20 17:57:14', '2020-09-20 23:59:59', 1, NULL, 200, 0, 0, 0, 0, 0, 0, 1, '2020-09-20 06:57:14', '2020-09-20 06:57:14'),
(321, 272, '194.79', 0, '2020-09-14 00:00:01', '2020-09-20 23:59:59', 1, NULL, 200, 1, 0, 1, 0, 0, 1, 1, '2020-09-14 09:12:28', '2020-09-21 09:12:28'),
(322, 273, '200', 0, '2020-09-14 20:14:04', '2020-09-20 23:59:59', 1, 'REC-1600699443364', 200, 1, 380, 0, 0, 0, 0, 1, '2020-09-14 09:14:04', '2020-09-21 09:14:04'),
(323, 277, '200.0', 0, '2020-09-14 20:28:06', '2020-09-20 23:59:59', 1, NULL, 200, 0, 0, 0, 0, 0, 0, 1, '2020-09-14 09:28:06', '2020-09-21 09:28:06'),
(324, 271, '0.42', 0, '2020-09-22 00:00:01', '2020-09-27 23:59:59', 2, NULL, 200, 1, 0, 1, 0, 0, 1, 1, '2020-09-22 03:45:05', '2020-09-22 03:45:05'),
(325, 276, '0', 0, '2020-09-22 11:14:53', '2020-09-27 23:59:59', 2, NULL, 200, 0, 0, 0, 0, 0, 0, 1, '2020-09-22 08:44:53', '2020-09-22 08:44:53');

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

--
-- Table structure for table `price_management`
--

CREATE TABLE IF NOT EXISTS `price_management` (
  `id` bigint(20) unsigned NOT NULL,
  `car_type` int(11) DEFAULT NULL,
  `initial_price` float NOT NULL,
  `initial_price_with_distance` float NOT NULL DEFAULT '0',
  `per_km_price` float NOT NULL,
  `addit_person_price` float NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `price_management`
--

INSERT INTO `price_management` (`id`, `car_type`, `initial_price`, `initial_price_with_distance`, `per_km_price`, `addit_person_price`, `created_at`, `updated_at`) VALUES
(1, NULL, 3.2, 0, 1.7, 1, '2020-09-11 09:22:30', '2020-09-11 09:22:30');

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

--
-- Table structure for table `promo_codes`
--

CREATE TABLE IF NOT EXISTS `promo_codes` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `start_date` varchar(30) NOT NULL,
  `end_date` varchar(30) NOT NULL,
  `code` varchar(6) NOT NULL,
  `description` text,
  `picture` varchar(191) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `promo_codes`
--

INSERT INTO `promo_codes` (`id`, `title`, `start_date`, `end_date`, `code`, `description`, `picture`, `created_at`, `updated_at`) VALUES
(1, 'Hello This is promo code for india', '2019-12-27', '2019-12-31', 'MS4846', 'Find the best place to hang out with friends. Visit Café Coffee Day and enjoy hot coffees, cold coffees, snacks and more. CCD is the best place to spend time with.', 'r2yqtitkyfeapkguy3nv13smbebeyrk8bdkahimjpng.png', '2019-12-27 06:51:24', '2019-12-27 08:47:42'),
(2, 'Testing for promo code', '2019-12-28', '2019-12-31', 'MOF654', 'Find the best place to hang out with friends. Visit Café Coffee Day and enjoy hot coffees, cold coffees, snacks and more. CCD is the best place to spend time with.\r\n\r\nFind the best place to hang out with friends. Visit Café Coffee Day and enjoy hot coffees, cold coffees, snacks and more. CCD is the best place to spend time with.', 'qxvbkrjcz8gzytq0tmjeltuq7rydc3pikxlbiroujpeg.jpg', '2019-12-27 06:58:20', '2019-12-27 09:17:59');

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

--
-- Table structure for table `rate_cards`
--

CREATE TABLE IF NOT EXISTS `rate_cards` (
  `id` bigint(20) unsigned NOT NULL,
  `user_type` int(11) NOT NULL COMMENT '1 for users, 2 for drivers',
  `car_type` bigint(20) unsigned NOT NULL,
  `details` text,
  `active` int(11) NOT NULL DEFAULT '1' COMMENT '1 means active. 0 means not',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rejects`
--

CREATE TABLE IF NOT EXISTS `rejects` (
  `id` bigint(20) unsigned NOT NULL,
  `request_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `created_at` varchar(191) DEFAULT NULL,
  `updated_at` varchar(191) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) unsigned NOT NULL,
  `app_name` varchar(191) DEFAULT NULL,
  `ios_version` varchar(30) DEFAULT NULL,
  `android_version` varchar(30) DEFAULT NULL,
  `driver_radius` varchar(30) DEFAULT NULL,
  `driver_comm` varchar(30) DEFAULT NULL,
  `bsu_comm` varchar(30) DEFAULT NULL,
  `sms` int(11) NOT NULL DEFAULT '0' COMMENT '1 for on, 0 for off',
  `driver_duty` int(11) NOT NULL DEFAULT '0' COMMENT '1 for on, 0 for off',
  `hst` int(11) NOT NULL DEFAULT '15',
  `ride_later` int(11) NOT NULL DEFAULT '0' COMMENT '1 for on, 0 for off',
  `ride_accept_time` int(11) NOT NULL DEFAULT '30' COMMENT 'seconds',
  `coupon` int(11) NOT NULL DEFAULT '1' COMMENT 'Status - 1 means on, 0 means off',
  `business_booking` int(11) NOT NULL DEFAULT '1' COMMENT 'Status - 1 means on, 0 means off',
  `weekly_charge` int(11) NOT NULL DEFAULT '0' COMMENT 'for drivers',
  `customer_wait_time` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `app_name`, `ios_version`, `android_version`, `driver_radius`, `driver_comm`, `bsu_comm`, `sms`, `driver_duty`, `hst`, `ride_later`, `ride_accept_time`, `coupon`, `business_booking`, `weekly_charge`, `customer_wait_time`, `created_at`, `updated_at`) VALUES
(1, 'SuperRide', '1.0', '1.1', '9', '90', '5', 1, 0, 15, 1, 20, 0, 1, 200, 60, '2019-10-21 14:23:26', '2020-07-28 13:58:21');

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

--
-- Table structure for table `special_requests`
--

CREATE TABLE IF NOT EXISTS `special_requests` (
  `id` bigint(20) unsigned NOT NULL,
  `toodler_seat_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `child_seat_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `car_boosting_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `booster_seat_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `toodler_seat_price` int(11) DEFAULT NULL,
  `child_seat_price` int(11) DEFAULT NULL,
  `car_boosting_price` int(11) DEFAULT NULL,
  `booster_seat_price` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `supports`
--

CREATE TABLE IF NOT EXISTS `supports` (
  `id` bigint(20) unsigned NOT NULL,
  `booking_id` varchar(20) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `details` text,
  `user_id` bigint(20) unsigned NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `ticket_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `support_actions`
--

CREATE TABLE IF NOT EXISTS `support_actions` (
  `id` bigint(20) unsigned NOT NULL,
  `support_id` bigint(20) unsigned NOT NULL,
  `reply` text NOT NULL,
  `is_admin` int(11) NOT NULL DEFAULT '1',
  `admin_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `team_members`
--

CREATE TABLE IF NOT EXISTS `team_members` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_pic` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission_ids` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_members`
--

INSERT INTO `team_members` (`id`, `name`, `email`, `profile_pic`, `permission_ids`, `created_at`, `updated_at`) VALUES
(1, 'Appsinvo Group', 'appsinvo1234@gmail.com', 'xtcjy3mwgbinxafnoz0ujvi3xhilyxe59bk993vzpng.png', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17', '2020-03-16 14:22:10', '2020-03-19 05:52:58'),
(2, 'Sanjay Kumar', 'sanjay.kumar@appsinvo.com', 'ygljjg1h9g44oea3cl6knkoegdgw7gwbrevsyzkgpng.png', '3,4,5,6,7,8,9,10,11,12,13,14,15,16', '2020-03-16 14:26:06', '2020-03-19 05:53:14'),
(3, 'Shashank', 'shashank.sachdev@appsinvo.com', 'kwhbqux4xwwd80tnzchc4rv8qiln9rs9llzbovmwpng.png', '3,4,5,7,8,9,10,11,12,13,14,15,16', '2020-03-19 09:51:02', '2020-03-19 09:51:32'),
(5, 'test singh', 'testsingh@mailinator.com', '', '1', '2020-04-06 02:49:27', '2020-04-06 02:49:27'),
(6, 'Kadher Sulaimon', 'rahsulaimon@yahoo.com', '', '1', '2020-08-04 19:21:40', '2020-08-04 19:22:15');

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

--
-- Table structure for table `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`id`, `name`, `status`, `updated_at`) VALUES
(1, 'Darshan', 'Active', '2021-08-31 01:00:34'),
(2, 'Darshan', 'Active', '2021-08-31 01:04:23'),
(3, 'Darshan', 'Active', '2021-08-31 01:07:01'),
(4, 'Darshan', 'Active', '2021-08-31 01:16:45'),
(5, 'Darshan', 'Active', '2021-08-31 01:19:07'),
(6, 'Darshan', 'Active', '2021-08-31 01:21:43'),
(7, 'Darshan', 'Active', '2021-08-31 01:28:19');

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

--
-- Table structure for table `tokens`
--

CREATE TABLE IF NOT EXISTS `tokens` (
  `id` int(4) NOT NULL,
  `token` varchar(300) NOT NULL,
  `created_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `booking_id` bigint(20) DEFAULT NULL,
  `payment_method` int(11) NOT NULL DEFAULT '0' COMMENT '1 online, 2 case, 3 wallet, 4 pos',
  `transaction_id` varchar(191) NOT NULL,
  `amount` varchar(191) NOT NULL DEFAULT '0',
  `amount_type` int(11) NOT NULL COMMENT '	1 means add (for obj_type 3 driver has paid), 2 means deduct (for obj_type 3 company has paid)',
  `details` text,
  `obj_id` bigint(20) unsigned NOT NULL,
  `obj_type` int(11) NOT NULL DEFAULT '1' COMMENT '1 for wallet, 2 for plan, 3 for settlement plan amount',
  `is_admin` int(11) NOT NULL DEFAULT '0' COMMENT '1 means transferred by admin',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `booking_id`, `payment_method`, `transaction_id`, `amount`, `amount_type`, `details`, `obj_id`, `obj_type`, `is_admin`, `created_at`, `updated_at`) VALUES
(313, 263, NULL, 2, 'PAY882273', '3.27', 2, 'Your plan has been activated successfully.', 302, 2, 0, '2020-09-11 09:05:44', '2020-09-18 09:05:44'),
(314, 264, NULL, 2, 'PAY702663', '0', 1, 'Your plan has been activated successfully.', 303, 2, 0, '2020-09-11 10:03:35', '2020-09-18 10:03:35'),
(315, 263, NULL, 2, 'PAY117123', '0.94', 1, 'Your plan has been re-activated successfully.', 304, 2, 0, '2020-09-18 10:52:15', '2020-09-18 10:52:15'),
(316, 264, NULL, 2, 'PAY897981', '0.84', 1, 'Your plan has been re-activated successfully.', 305, 2, 0, '2020-09-18 11:21:04', '2020-09-18 11:21:04'),
(317, 265, NULL, 2, 'PAY832535', '3.78', 2, 'Your plan has been activated successfully.', 306, 2, 0, '2020-09-11 11:34:35', '2020-09-18 11:56:49'),
(318, 265, NULL, 2, 'PAY373542', '0.42', 1, 'Your plan has been re-activated successfully.', 307, 2, 0, '2020-09-18 11:50:43', '2020-09-18 11:50:43'),
(319, 266, NULL, 2, 'PAY961894', '0.43', 1, 'Your plan has been activated successfully.', 308, 2, 0, '2020-09-11 11:58:23', '2020-09-18 12:09:57'),
(320, 266, NULL, 2, 'PAY945636', '0.43', 1, 'Your plan has been re-activated successfully.', 309, 2, 0, '2020-09-18 12:09:57', '2020-09-18 12:09:57'),
(321, 262, NULL, 2, 'PAY519036', '85.71', 1, 'Your plan has been activated successfully.', 310, 2, 0, '2020-09-11 12:12:02', '2020-09-18 12:29:41'),
(322, 262, NULL, 2, 'PAY510095', '85.71', 1, 'Your plan has been re-activated successfully.', 311, 2, 0, '2020-09-18 12:29:41', '2020-09-18 12:29:41'),
(323, 268, NULL, 2, 'PAY497796', '85.71', 1, 'Your plan has been activated successfully.', 312, 2, 0, '2020-09-11 12:37:30', '2020-09-18 12:37:30'),
(324, 268, NULL, 2, 'PAY557841', '85.71', 1, 'Your plan has been re-activated successfully.', 313, 2, 0, '2020-09-18 12:45:52', '2020-09-18 12:45:52'),
(325, 269, NULL, 2, 'PAY35083', '57.14', 1, 'Your plan has been activated successfully.', 314, 2, 0, '2020-09-11 12:54:37', '2020-09-18 13:09:20'),
(326, 269, NULL, 2, 'PAY261747', '57.14', 1, 'Your plan has been re-activated successfully.', 315, 2, 0, '2020-09-18 13:09:20', '2020-09-18 13:09:20'),
(327, 270, NULL, 2, 'PAY816164', '0', 1, 'Your plan has been activated successfully.', 316, 2, 0, '2020-09-20 06:35:14', '2020-09-20 06:35:14'),
(328, 271, NULL, 2, 'PAY468944', '0', 1, 'Your plan has been activated successfully.', 317, 2, 0, '2020-09-20 06:39:13', '2020-09-20 06:39:13'),
(329, 272, NULL, 2, 'PAY382165', '28.57', 1, 'Your plan has been activated successfully.', 318, 2, 0, '2020-09-20 06:46:35', '2020-09-20 06:46:35'),
(330, 273, NULL, 2, 'PAY344733', '180', 2, 'Your plan has been activated successfully.', 319, 2, 0, '2020-09-20 06:50:25', '2020-09-21 09:15:25'),
(331, 274, NULL, 2, 'PAY33277', '28.57', 1, 'Your plan has been activated successfully.', 320, 2, 0, '2020-09-20 06:57:14', '2020-09-20 06:57:14'),
(332, 272, NULL, 2, 'PAY97969', '194.79', 1, 'Your plan has been re-activated successfully.', 321, 2, 0, '2020-09-14 09:12:28', '2020-09-21 09:12:28'),
(333, 273, NULL, 2, 'PAY202534', '200', 1, 'Your plan has been re-activated successfully.', 322, 2, 0, '2020-09-14 09:14:04', '2020-09-21 09:14:04'),
(334, 277, NULL, 2, 'PAY878587', '200.0', 1, 'Your plan has been activated successfully.', 323, 2, 0, '2020-09-14 09:28:06', '2020-09-21 09:28:06'),
(335, 271, NULL, 2, 'PAY576556', '0.42', 1, 'Your plan has been re-activated successfully.', 324, 2, 0, '2020-09-22 03:45:05', '2020-09-22 03:45:05'),
(336, 276, NULL, 2, 'PAY115804', '0', 1, 'Your plan has been activated successfully.', 325, 2, 0, '2020-09-22 08:44:53', '2020-09-22 08:44:53');

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

--
-- Table structure for table `update_locations`
--

CREATE TABLE IF NOT EXISTS `update_locations` (
  `id` int(11) NOT NULL,
  `driver_id` bigint(20) NOT NULL,
  `ongoing_booking_id` varchar(255) NOT NULL,
  `drop_lat` varchar(255) NOT NULL,
  `drop_lng` varchar(255) NOT NULL,
  `status` int(11) NOT NULL COMMENT '0 for offline, 1 for online',
  `current_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `update_locations`
--

INSERT INTO `update_locations` (`id`, `driver_id`, `ongoing_booking_id`, `drop_lat`, `drop_lng`, `status`, `current_datetime`, `created_at`, `updated_at`) VALUES
(1, 262, 'Taxi_626987', '23.049910626423355', '72.51733937231417', 1, '2021-09-09 07:12:15', '2021-09-09 07:12:15', '2021-09-09 07:12:15');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) unsigned NOT NULL,
  `cus_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_type` int(11) NOT NULL COMMENT '1 for customer, 2 for driver',
  `device_type` int(11) NOT NULL COMMENT '1 for android, 2 for ios',
  `social_provider_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 for facebook 2 for google',
  `social_provider_uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_pic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `add_lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `add_lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `driver_docs` text COLLATE utf8mb4_unicode_ci,
  `otp` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1234',
  `otp_verified` int(11) NOT NULL DEFAULT '0' COMMENT '1 means verified, 0 means not',
  `active` int(11) DEFAULT NULL COMMENT '1 means active, 0 means deactive, 2 means pending, 3 means rejected',
  `admin_approved` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '1 means approved , 0 means not ',
  `profile_setup` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '1 means setup, 0 means not',
  `vehicle_make` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_plate_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `veh_model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seat_nos` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toodler_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 means yes and 0 means no	',
  `child_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 means yes and 0 means no	',
  `car_boosting` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 means yes and 0 means no',
  `car_type` bigint(20) unsigned DEFAULT NULL COMMENT 'means car category reference',
  `booster_seat` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 means yes and 0 means no	',
  `license_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `insurance_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operator_lic_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `criminal_bg_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_online` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '1 means online, 0 means not',
  `is_ride` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '0 means available, 1 means on ride',
  `plan_type` int(11) DEFAULT NULL COMMENT '1 for Weekly, 2 for Pay as you go',
  `plan_expire_at` date DEFAULT NULL,
  `avg_rating` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `pkey` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_id` int(11) DEFAULT NULL,
  `is_reject` int(11) NOT NULL DEFAULT '0',
  `is_bs_first` int(11) NOT NULL DEFAULT '0' COMMENT 'business user first time congrats msg',
  `wallet_amount` float NOT NULL DEFAULT '0',
  `timezone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=282 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `cus_id`, `name`, `first_name`, `last_name`, `email`, `email_verified_at`, `password`, `remember_token`, `phone`, `country_code`, `user_type`, `device_type`, `social_provider_type`, `social_provider_uid`, `profile_pic`, `address`, `add_lat`, `add_lng`, `direction`, `cur_address`, `cur_lat`, `cur_lng`, `city`, `driver_docs`, `otp`, `otp_verified`, `active`, `admin_approved`, `profile_setup`, `vehicle_make`, `license_plate_number`, `veh_model`, `seat_nos`, `toodler_seat`, `child_seat`, `car_boosting`, `car_type`, `booster_seat`, `license_img`, `insurance_img`, `operator_lic_img`, `criminal_bg_img`, `device_token`, `is_online`, `is_ride`, `plan_type`, `plan_expire_at`, `avg_rating`, `pkey`, `request_id`, `is_reject`, `is_bs_first`, `wallet_amount`, `timezone`, `created_at`, `updated_at`) VALUES
(261, 'cus_I2rpqzklmnKI4d', 'Cust Payg', 'Cust', 'Payg', 'cust@weekly.com', NULL, '$2y$10$r5ZZ2Mv9f3WAp/OG54g8l.RUUVYa1k5cWbARNS5wj7m0wztkisPzy', NULL, '1099', '+1', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6060', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fQMg9vklQ3CBBPXnzWpd2D:APA91bFLKJ-IHeROzauTSFEYT67tRcAjYlSKibcx6O8ggsEX95LA-8aVpry4uE_sIHfCLSV9RX-QBut_WZZ2SUCYxfJ8ivKWnLMJ-iTFI-RNpN21jKN1EqLVNpgKzOAScEnXkDpGRtrE', '0', '0', NULL, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, 'Asia/Kolkata', '2020-09-18 09:00:26', '2021-09-16 06:13:00'),
(262, 'cus_I2tfxPD5FFQu9H', 'Driver Weekly', 'Driver', 'Weekly', 'driver@weekly.com', NULL, '$2y$10$r5ZZ2Mv9f3WAp/OG54g8l.RUUVYa1k5cWbARNS5wj7m0wztkisPzy', NULL, '2099', '+1', 2, 1, NULL, NULL, '26abfe9r09i8xysekj9vs8wb56pcqpzk0y0apiayjpeg.jpg', 'Bijnor', '29.3731673', '78.1350904', NULL, NULL, NULL, NULL, NULL, NULL, '0893', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '12345', '0', '1', 1, NULL, '0', NULL, NULL, 0, 0, 0, 'Asia/Kolkata', '2020-09-18 09:00:31', '2021-09-15 02:23:22'),
(263, NULL, 'Driver Payg', 'Driver', 'Payg', 'driver@payg.com', NULL, '$2y$10$ZHsaKqCLnqrTeynBP6lIA.xafvjRG20Eoi.v5oPaz5BSN6yG8RUkC', NULL, '3099', '+1', 2, 1, NULL, NULL, 'ppz749x84eurt6ec9nmpwc8tknyd8xqidatpzq9cjpeg.jpg', 'Noida', '28.5355161', '77.3910265', NULL, NULL, NULL, NULL, NULL, NULL, '4977', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', NULL, NULL, 0, 0, 0, 'Asia/Kolkata', '2020-09-18 09:03:52', '2021-09-09 04:32:05'),
(264, NULL, 'Payg New', 'Payg', 'New', 'gyg@gh.ggg', NULL, '$2y$10$sj34L.6fCDY7RAmbM6F6MOBh/jfSPc8mqyYlKQ8jiOs.IYpk7BHaK', NULL, '9999', '+1', 2, 1, NULL, NULL, '2ocelhtezwywiilj2u1gutck0qbzgcwizinvpjj3jpeg.jpg', 'Bijnor', '29.3731673', '78.1350904', NULL, NULL, NULL, NULL, NULL, NULL, '6906', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', NULL, NULL, 0, 0, 0, 'America/New_York', '2020-09-18 10:00:49', '2021-09-02 02:08:35'),
(265, NULL, 'Driver PaygAgain', 'Driver', 'PaygAgain', 'superride@driver.payg', NULL, '$2y$10$IXUvZq3k5Mx5sRoHe2.nRulPd2/Ac84Fu4BSheTUEQO/uNt9RPOKi', NULL, '12345', '+1', 2, 1, NULL, NULL, 'efyvaltn29nxpfxksllvluuknj1t8s3ygfsvojympng.png', 'Barakhamba Road, Barakhamba, New Delhi, Delhi, India', '28.6286466', '77.2268253', NULL, NULL, NULL, NULL, NULL, NULL, '9680', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, NULL, '2020-09-18 11:13:33', '2020-09-18 11:56:49'),
(266, NULL, 'Driverpayg Dhtp', 'Driverpayg', 'Dhtp', 'hdhdh@jeje.djnen', NULL, '$2y$10$/OahyKSmsZefBttdeub/Uuoq9ju/5lh8z6tbUjOSQjTn2RiANDOfi', NULL, '9009', '+1', 2, 1, NULL, NULL, 'iiptqg3uyt2nb3gqeawbfqzghleljtahwshf3dcyjpeg.jpg', 'Noida', '28.5355161', '77.3910265', NULL, NULL, NULL, NULL, NULL, NULL, '5923', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-18 11:57:00', '2020-09-18 12:10:42'),
(267, NULL, NULL, NULL, NULL, 'user7835@dummy.com', NULL, '$2y$10$Y9ZMnMvLUzDY7cimQz9/tuyHpHzVqf2YUhQEn/cTRQRxgfMgBCMOe', NULL, '2009', '+1', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7235', 1, 2, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-18 12:10:59', '2020-09-18 12:11:06'),
(268, 'cus_I2tnxsxt51Glas', 'Driverweek DHP', 'Driverweek', 'DHP', 'sadha@ssdfs.sda', NULL, '$2y$10$bNkiJhedIPsBMpLwOr6DMOwBqhD7uoxxo6sIy.I4yf3yBFaD34BuS', NULL, '8765', '+1', 2, 1, NULL, NULL, 'ptcyflut0tgg1xgmnrmyxtnmtrl9jvyy2pcxz1xxpng.png', 'Barasat, Calcutta, West Bengal, India', '22.7247556', '88.4789351', NULL, NULL, NULL, NULL, NULL, NULL, '7970', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 1, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, NULL, '2020-09-18 12:36:07', '2020-09-18 12:53:56'),
(269, 'cus_I2u416M7Bsk0ej', 'ewuriw asudoiua', 'ewuriw', 'asudoiua', 'dusa@sdf.sdf', NULL, '$2y$10$DqOgbPVSNG8WvQwhTk6V6OXmldO/7AtcuFRAdPabUHqoBCEFwhdJ.', NULL, '39874', '+1', 2, 1, NULL, NULL, 'jvmishvphcjqzys9scxfls1diyqsxjlbutep5kybpng.png', 'SDSU, Campanile Drive, San Diego, CA, USA', '32.7759894', '-117.0712533', NULL, NULL, NULL, NULL, NULL, NULL, '5366', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 1, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, NULL, '2020-09-18 12:53:15', '2020-09-20 06:31:33'),
(270, NULL, 'Driverpayg Comppay', 'Driverpayg', 'Comppay', 'gshs@heje.jdjn', NULL, '$2y$10$x1yYNIW7Phd2cnZt3zvV3ecLtMAeGV5Oph17UzKiFiDA/OrmWruW2', NULL, '0077', '+1', 2, 1, NULL, NULL, 'erqjpsoqowosgfrhq8exqwxufwdqnb3hir6bymapjpeg.jpg', 'Batam', '1.1300779', '104.0529207', NULL, NULL, NULL, NULL, NULL, NULL, '8492', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-20 06:31:41', '2020-09-22 01:02:26'),
(271, NULL, 'Driverpayg driverpay', 'Driverpayg', 'driverpay', 'hdhdh@hshe.djdh', NULL, '$2y$10$ifvtRDnVXM0sOXQmel/Lve81r3Hwok2xdN4GsCf99Mn7HgUScW64i', NULL, '0088', '+1', 2, 1, NULL, NULL, 'rkgdzw4m0h81fu3tee3ffrmcax6gh4dbdahgxbxfjpeg.jpg', 'Udhampur', '32.9159847', '75.1416173', NULL, NULL, NULL, NULL, NULL, NULL, '2253', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 2, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-20 06:37:53', '2020-09-21 09:54:54'),
(272, 'cus_I3YaSurGbUon8i', 'DriverWeekly DriverPay', 'DriverWeekly', 'DriverPay', 'djjdj@shhd.djnd', NULL, '$2y$10$L76fKSFeT5IzNnK4u6m5XOrXLWObUS5mwhCLhiNW3PKhtvQGO/ZwS', NULL, '2200', '+1', 2, 1, NULL, NULL, 'pnc9dqu7ux6vbibbdr7fgpqarevyqd0didmkvxmdjpeg.jpg', 'Hdhdhsh', '28.7726202', '77.5123765', NULL, NULL, NULL, NULL, NULL, NULL, '3149', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'cJOecnIsfTQ:APA91bG2UBb8hK77Da-5FByrlCrE-erKshUR7iE8PkMKQPCBA10yEXq6ZRKNJY-gMLLGQHfOI1VcESo1V03CDenvXC9pfxMcsR1ZkYbHGwxY-bXQmG2sfWbwkwNUAm6G8vllztOGr3BS', '0', '1', 1, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, NULL, '2020-09-20 06:42:44', '2020-09-22 03:40:39'),
(273, 'cus_I3YdmJm98gJcfu', 'Driveremweekly Comppay', 'Driveremweekly', 'Comppay', 'hdhdb@hsh.djdb', NULL, '$2y$10$HGWCg7sLCQeiGFJIqHc.quYrAGqTILJfhFIwTzoHyp0WCnWeJVPK6', NULL, '2211', '+1', 2, 1, NULL, NULL, 'ohfiylr7ntpa8h75qd1hcfu4q0v5n4pvgnn3h8cejpeg.jpg', 'Delhi', '28.68627380000001', '77.2217831', NULL, NULL, NULL, NULL, NULL, NULL, '6730', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 1, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-20 06:48:49', '2020-09-22 03:39:42'),
(274, 'cus_I3YkH4hfo4Kgjf', 'Driverweekly Driverpaycash', 'Driverweekly', 'Driverpaycash', 'vhhg@gjj.jhh', NULL, '$2y$10$lZa.wYwnd95sR4HQisBaE.ZBPdhTBsqseJVq9WwokZiqtLgCvfLBe', NULL, '5522', '+1', 2, 1, NULL, NULL, 'mlgqdlaoiw3zxgozq0l5pf7x8wg4v4j51vmzqniwjpeg.jpg', 'Delhi', '28.68627380000001', '77.2217831', NULL, NULL, NULL, NULL, NULL, NULL, '1421', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '1', 1, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-20 06:53:33', '2020-09-21 09:25:08'),
(275, NULL, 'Wrt Rfg', 'Wrt', 'Rfg', 'dff@ghj.in', NULL, '$2y$10$FNT7HFEOC.VEiAxUFppJmu2AQR4cm77JDWjm07QdIRAk71LV7nvPO', NULL, '6666333321', '+1', 2, 1, NULL, NULL, 'yuhbunaxx4mp8ire2pddglfobjnnyxzvdopzteumjpeg.jpg', 'Uttam Nagar', '28.6195574', '77.0549901', NULL, NULL, NULL, NULL, NULL, NULL, '8377', 1, 2, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', 1, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-21 07:59:22', '2020-09-21 08:00:12'),
(276, NULL, 'Kadher Sulaiman', 'Kadher', 'Sulaiman', 'hdhhsbs@hdhs.com', NULL, '$2y$10$OALcv2mp3kWQjHejnEXccOVcmjQMvNWNIcROuBtuae8fIE.Trkx9C', NULL, '48838383', '+1', 2, 1, NULL, NULL, NULL, '6500 Reisterstown Road, Baltimore, MD, USA', '39.3554922', '-76.70458049999999', NULL, NULL, NULL, NULL, NULL, NULL, '7261', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'eLItEtlMTWg:APA91bFqe4rfGCptKfdfzn_6wejrin8OEJwROYuHUnfpkHaIw_fdcfp7FVkXRGQQbIQNXaKSeKTTe9On8dTGV02QD79n_yU-t8rLfjW0wJkbuqv8us3Ss-kMz5upaFsDkd9W0mxZPQi6', '0', '1', 2, NULL, '0', 'MTIzNDU2', NULL, 0, 0, 0, NULL, '2020-09-21 08:55:55', '2020-09-22 09:48:50'),
(277, 'cus_I3yPbXilMx3Amq', 'Fff Cfff', 'Fff', 'Cfff', 'ccccxs@sd.gg', NULL, '$2y$10$nidKkeII0iqj8z4espm.uOtzbDi35ydqAywwcSb8d8WoqYwocvP8O', NULL, '12380', '+1', 2, 1, NULL, NULL, 'y3ciavzrmzfu1nfv4zzymblfstr0f5ctaxczet0ojpeg.jpg', 'Delhi', '28.68627380000001', '77.2217831', NULL, NULL, NULL, NULL, NULL, NULL, '7124', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', '0', 1, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-21 09:25:17', '2020-09-21 09:31:33'),
(278, 'cus_I4L7lltxNuR1dS', 'Test Payg', 'Test', 'Payg', 'nnjdjd@jsns.com', NULL, '$2y$10$//QwGJ6FmVmApwA9G6R3f.0EYzQOmVvxsZdFdt34.scQIgR1NMv46', NULL, '506988', '+1', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6741', 1, 1, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dFvv2A4BBCw:APA91bEdCKHMiFInoGsufsiOsByzwjusq-ysGr75iGhxBqj__ZkVbcuQvLHHRdVpn_sERLxornydPdXHU7oLue2OJcM52DnqRD6BRQ8icRfCVrfaZO29z-tQ-dUQzcQGEnhgHBL5SyV1', '0', '0', NULL, NULL, '0', NULL, NULL, 0, 0, 0, NULL, '2020-09-22 08:47:19', '2020-09-22 09:34:12'),
(279, NULL, NULL, NULL, NULL, 'user4812@dummy.com', NULL, '$2y$10$p8rFOIJDXIutDaXZF2I4KefgWNCIHlihwuoMeTxI2pRlGy5w3dadG', NULL, '1099', '+1', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9546', 0, 2, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, NULL, 0, 0, 0, 'Asia/Kolkata', '2021-09-02 00:38:56', '2021-09-09 07:04:50'),
(280, NULL, NULL, NULL, NULL, 'user567@dummy.com', NULL, '$2y$10$0vmRxpRpe0nKnj48NjpfeecNXO7xbta87TmfxBCyOxzcbuJuZ78l2', NULL, '2536', '+1', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7996', 1, 2, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, NULL, 0, 0, 0, 'America/New_York', '2021-09-02 00:39:30', '2021-09-02 01:30:18'),
(281, NULL, NULL, NULL, NULL, 'user1917@dummy.com', NULL, '$2y$10$g0dFyI6lvV.WqGLaZfjZbO.7cOxo0nYbi/9pKbh46SPgUGEMZzuii', NULL, '2536', '+1', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7538', 0, 1, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, NULL, 0, 0, 0, 'America/New_York', '2021-09-02 00:43:08', '2021-09-02 00:43:47');

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

--
-- Table structure for table `witdrawal_amounts`
--

CREATE TABLE IF NOT EXISTS `witdrawal_amounts` (
  `id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `bank_details`
--
ALTER TABLE `bank_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `driver_id` (`driver_id`),
  ADD KEY `car_type` (`car_type`),
  ADD KEY `plan_type` (`plan_type`);

--
-- Indexes for table `business_users`
--
ALTER TABLE `business_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cancel_reasons`
--
ALTER TABLE `cancel_reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car_categories`
--
ALTER TABLE `car_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `drivers`
--
ALTER TABLE `drivers`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `license_plate_number` (`license_plate_number`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `car_type` (`car_type`);

--
-- Indexes for table `driverstatuscheck`
--
ALTER TABLE `driverstatuscheck`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `driver_full_settles`
--
ALTER TABLE `driver_full_settles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `driver_id` (`driver_id`);

--
-- Indexes for table `driver_plans`
--
ALTER TABLE `driver_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `emr_contacts`
--
ALTER TABLE `emr_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `favourite_places`
--
ALTER TABLE `favourite_places`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `feedback`
--
ALTER TABLE `feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `request_id` (`request_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plan_recharges`
--
ALTER TABLE `plan_recharges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `driver_id` (`driver_id`),
  ADD KEY `plan_type` (`plan_type`);

--
-- Indexes for table `price_management`
--
ALTER TABLE `price_management`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `promo_codes`
--
ALTER TABLE `promo_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rate_cards`
--
ALTER TABLE `rate_cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `car_type` (`car_type`);

--
-- Indexes for table `rejects`
--
ALTER TABLE `rejects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `special_requests`
--
ALTER TABLE `special_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supports`
--
ALTER TABLE `supports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `support_actions`
--
ALTER TABLE `support_actions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_id` (`support_id`);

--
-- Indexes for table `team_members`
--
ALTER TABLE `team_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test`
--
ALTER TABLE `test`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tokens`
--
ALTER TABLE `tokens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `update_locations`
--
ALTER TABLE `update_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `unique_social_uid` (`social_provider_uid`) USING BTREE,
  ADD UNIQUE KEY `unique_country_code_plus_phone` (`phone`,`country_code`,`user_type`) USING BTREE;

--
-- Indexes for table `witdrawal_amounts`
--
ALTER TABLE `witdrawal_amounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `bank_details`
--
ALTER TABLE `bank_details`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=868;
--
-- AUTO_INCREMENT for table `business_users`
--
ALTER TABLE `business_users`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cancel_reasons`
--
ALTER TABLE `cancel_reasons`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `car_categories`
--
ALTER TABLE `car_categories`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `drivers`
--
ALTER TABLE `drivers`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=408;
--
-- AUTO_INCREMENT for table `driverstatuscheck`
--
ALTER TABLE `driverstatuscheck`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `driver_full_settles`
--
ALTER TABLE `driver_full_settles`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `driver_plans`
--
ALTER TABLE `driver_plans`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `emr_contacts`
--
ALTER TABLE `emr_contacts`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `favourite_places`
--
ALTER TABLE `favourite_places`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=200;
--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=338;
--
-- AUTO_INCREMENT for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2029;
--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `plan_recharges`
--
ALTER TABLE `plan_recharges`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=326;
--
-- AUTO_INCREMENT for table `price_management`
--
ALTER TABLE `price_management`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `promo_codes`
--
ALTER TABLE `promo_codes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `rate_cards`
--
ALTER TABLE `rate_cards`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `rejects`
--
ALTER TABLE `rejects`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `special_requests`
--
ALTER TABLE `special_requests`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `support_actions`
--
ALTER TABLE `support_actions`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `team_members`
--
ALTER TABLE `team_members`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `test`
--
ALTER TABLE `test`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tokens`
--
ALTER TABLE `tokens`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=337;
--
-- AUTO_INCREMENT for table `update_locations`
--
ALTER TABLE `update_locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=282;
--
-- AUTO_INCREMENT for table `witdrawal_amounts`
--
ALTER TABLE `witdrawal_amounts`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `bank_details`
--
ALTER TABLE `bank_details`
  ADD CONSTRAINT `bank_details_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `bookings_ibfk_3` FOREIGN KEY (`car_type`) REFERENCES `car_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `bookings_ibfk_4` FOREIGN KEY (`plan_type`) REFERENCES `driver_plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `business_users`
--
ALTER TABLE `business_users`
  ADD CONSTRAINT `business_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `drivers`
--
ALTER TABLE `drivers`
  ADD CONSTRAINT `drivers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `drivers_ibfk_2` FOREIGN KEY (`car_type`) REFERENCES `car_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `driver_full_settles`
--
ALTER TABLE `driver_full_settles`
  ADD CONSTRAINT `driver_full_settles_ibfk_1` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `emr_contacts`
--
ALTER TABLE `emr_contacts`
  ADD CONSTRAINT `emr_contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `favourite_places`
--
ALTER TABLE `favourite_places`
  ADD CONSTRAINT `favourite_places_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `feedback`
--
ALTER TABLE `feedback`
  ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`request_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `feedback_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD CONSTRAINT `oauth_access_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `plan_recharges`
--
ALTER TABLE `plan_recharges`
  ADD CONSTRAINT `plan_recharges_ibfk_1` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `plan_recharges_ibfk_2` FOREIGN KEY (`plan_type`) REFERENCES `driver_plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `supports`
--
ALTER TABLE `supports`
  ADD CONSTRAINT `supports_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `support_actions`
--
ALTER TABLE `support_actions`
  ADD CONSTRAINT `support_actions_ibfk_1` FOREIGN KEY (`support_id`) REFERENCES `supports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `witdrawal_amounts`
--
ALTER TABLE `witdrawal_amounts`
  ADD CONSTRAINT `witdrawal_amounts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

