(3940,200,'Guadalcanal','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3941,200,'Isabel','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3942,200,'Makira and Ulawa','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3943,200,'Malaita','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3944,200,'Rennell and Bellona','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3945,200,'Temotu','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3946,200,'Western','Pacific/Guadalcanal','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3947,89,'Agana Heights','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3948,89,'Agat','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3949,89,'Barrigada','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3950,89,'Chalan-Pago-Ordot','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3951,89,'Dededo','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3952,89,'Hagatna','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3953,89,'Inarajan','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3954,89,'Mangilao','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3955,89,'Merizo','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3956,89,'Mongmong-Toto-Maite','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3957,89,'Santa Rita','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3958,89,'Sinajana','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3959,89,'Talofofo','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3960,89,'Tamuning','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3961,89,'Yigo','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3962,89,'Yona','Pacific/Guam','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3963,137,'Ailinlaplap','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3964,137,'Ailuk','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3965,137,'Arno','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3966,137,'Aur','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3967,137,'Bikini','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3968,137,'Ebon','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3969,137,'Enewetak','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3970,137,'Jabat','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3971,137,'Jaluit','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3972,137,'Kili','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3973,137,'Kwajalein','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3974,137,'Lae','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3975,137,'Lib','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3976,137,'Likiep','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3977,137,'Majuro','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3978,137,'Maloelap','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3979,137,'Mejit','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3980,137,'Mili','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3981,137,'Namorik','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3982,137,'Namu','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3983,137,'Rongelap','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3984,137,'Ujae','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3985,137,'Utrik','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3986,137,'Wotho','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3987,137,'Wotje','Pacific/Kwajalein','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3988,152,'Yaren','Pacific/Nauru','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3989,161,'Niue','Pacific/Niue','-11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3990,162,'Norfolk Island','Pacific/Norfolk','+11:30',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3991,156,'Iles','Pacific/Noumea','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3992,156,'Nord','Pacific/Noumea','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3993,156,'Sud','Pacific/Noumea','+11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3994,4,'Eastern','Pacific/Pago_Pago','-11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3995,4,'Manu\'a','Pacific/Pago_Pago','-11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3996,4,'Swains Island','Pacific/Pago_Pago','-11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3997,4,'Western','Pacific/Pago_Pago','-11:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3998,167,'Aimeliik','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(3999,167,'Airai','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4000,167,'Angaur','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4001,167,'Hatobohei','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4002,167,'Kayangel','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4003,167,'Koror','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4004,167,'Melekeok','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4005,167,'Ngaraard','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4006,167,'Ngardmau','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4007,167,'Ngaremlengui','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4008,167,'Ngatpang','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4009,167,'Ngchesar','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4010,167,'Ngerchelong','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4011,167,'Ngiwal','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4012,167,'Peleliu','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4013,167,'Sonsorol','Pacific/Palau','+09:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4014,174,'Pitcairn Island','Pacific/Pitcairn','-08:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4015,170,'East New Britain','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4016,170,'East Sepik','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4017,170,'Eastern Highlands','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4018,170,'Enga','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4019,170,'Fly River','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4020,170,'Gulf','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4021,170,'Madang','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4022,170,'Manus','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4023,170,'Milne Bay','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4024,170,'Morobe','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4025,170,'National Capital District','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4026,170,'New Ireland','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4027,170,'North Solomons','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4028,170,'Oro','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4029,170,'Sandaun','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4030,170,'Simbu','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4031,170,'Southern Highlands','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4032,170,'West New Britain','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4033,170,'Western Highlands','Pacific/Port_Moresby','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4034,51,'Aitutaki','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4035,51,'Atiu','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4036,51,'Mangaia','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4037,51,'Manihiki','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4038,51,'Mauke','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4039,51,'Mitiaro','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4040,51,'Nassau','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4041,51,'Pukapuka','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4042,51,'Rakahanga','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4043,51,'Rarotonga','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4044,51,'Tongareva','Pacific/Rarotonga','-10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4045,163,'Northern Islands','Pacific/Saipan','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4046,163,'Rota','Pacific/Saipan','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4047,163,'Saipan','Pacific/Saipan','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4048,163,'Tinian','Pacific/Saipan','+10:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4049,220,'Eua','Pacific/Tongatapu','+13:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4050,220,'Ha\'apai','Pacific/Tongatapu','+13:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4051,220,'Niuas','Pacific/Tongatapu','+13:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4052,220,'Tongatapu','Pacific/Tongatapu','+13:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4053,220,'Vava\'u','Pacific/Tongatapu','+13:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4054,241,'Alo','Pacific/Wallis','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4055,241,'Singave','Pacific/Wallis','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4056,241,'Wallis','Pacific/Wallis','+12:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4057,29,'Bouvet Island','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4058,62,'Aileu','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4059,62,'Ainaro','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4060,62,'Ambeno','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4061,62,'Baucau','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4062,62,'Bobonaro','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4063,62,'Cova Lima','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4064,62,'Dili','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4065,62,'Ermera','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4066,62,'Lautem','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4067,62,'Liquica','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4068,62,'Manatuto','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4069,62,'Manufahi','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4070,62,'Viqueque','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4071,70,'Christmas Island','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4072,70,'Cocos Islands','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4073,70,'Coral Sea Islands','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4074,78,'Amsterdam','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4075,78,'Crozet Islands','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4076,78,'Kerguelen','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4077,91,'Alderney','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4078,91,'Castel','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4079,91,'Forest','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4080,91,'Saint Andrew','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4081,91,'Saint Martin','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4082,91,'Saint Peter Port','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4083,91,'Saint Pierre du Bois','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4084,91,'Saint Sampson','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4085,91,'Saint Saviour','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4086,91,'Sark','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4087,91,'Torteval','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4088,91,'Vale','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4089,96,'Heard and McDonald Islands','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4090,110,'Grouville','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4091,110,'Saint Brelade','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4092,110,'Saint Clement','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4093,110,'Saint Helier','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4094,110,'Saint John','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4095,110,'Saint Lawrence','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4096,110,'Saint Martin','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4097,110,'Saint Mary','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4098,110,'Saint Peter','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4099,110,'Saint Saviour','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4100,110,'Trinity','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4101,136,'Castletown','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4102,136,'Douglas','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4103,136,'Laxey','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4104,136,'Onchan','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4105,136,'Peel','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4106,136,'Port Erin','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4107,136,'Port Saint Mary','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4108,136,'Ramsey','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4109,199,'Pitcairn','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4110,204,'Central Equatoria','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4111,232,'United States Minor Outlying I','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4112,242,'Bu Jaydur','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4113,242,'Wad-adh-Dhahab','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4114,242,'al-\'Ayun','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4115,242,'as-Samarah','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4116,244,'Central Serbia','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4117,244,'Kosovo and Metohija','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4118,244,'Montenegro','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4119,244,'Republic of Serbia','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4120,244,'Serbia','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL),(4121,244,'Vojvodina','UTC','+00:00',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:09','2020-11-18 06:07:09',NULL);

--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `address_type` enum('Home','Work','Other') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landmark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flat_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `street` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `county` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(15,8) DEFAULT NULL,
  `longitude` double(15,8) DEFAULT NULL,
  `map_address` text COLLATE utf8mb4_unicode_ci,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_addresses_user_id_foreign` (`user_id`),
  KEY `user_addresses_created_by_foreign` (`created_by`),
  KEY `user_addresses_modified_by_foreign` (`modified_by`),
  KEY `user_addresses_deleted_by_foreign` (`deleted_by`),
  CONSTRAINT `user_addresses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_addresses_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_addresses_modified_by_foreign` FOREIGN KEY (`modified_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_addresses`
--


--
-- Table structure for table `user_requests`
--

CREATE TABLE `user_requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `provider_id` int(10) unsigned DEFAULT NULL,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `schedule_at` timestamp NULL DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_requests`
--


--
-- Table structure for table `user_wallets`
--

CREATE TABLE `user_wallets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` int(11) NOT NULL,
  `transaction_alias` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_wallets_user_id_foreign` (`user_id`),
  CONSTRAINT `user_wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_wallets`
--


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

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CASH',
  `user_type` enum('INSTANT','NORMAL') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NORMAL',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` enum('MALE','FEMALE','OTHER') COLLATE utf8mb4_unicode_ci NOT NULL,
  `jwt_token` text COLLATE utf8mb4_unicode_ci,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_type` enum('ANDROID','IOS') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_by` enum('MANUAL','FACEBOOK','GOOGLE','APPLE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(15,8) DEFAULT NULL,
  `longitude` double(15,8) DEFAULT NULL,
  `stripe_cust_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet_balance` double(15,2) NOT NULL DEFAULT '0.00',
  `rating` double(4,2) NOT NULL DEFAULT '5.00',
  `otp` mediumint(9) NOT NULL DEFAULT '0',
  `language` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `qrcode_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_unique_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referal_count` mediumint(9) NOT NULL DEFAULT '0',
  `country_id` int(10) unsigned DEFAULT NULL,
  `state_id` int(10) unsigned DEFAULT NULL,
  `city_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_company_id_foreign` (`company_id`),
  CONSTRAINT `users_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,'USR1','User','Demo','CASH','NORMAL','MkbSEZOFVv0zPJ7iSZmcew==','eTJqdmrXTbyoZI6VsU8NvQ==','$2y$10$xUK2wZZr3Oito2Aw03fKkO1Ms0PLF4XhpZHwav8TJb6vxU3QyukSK','MALE','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvZ294ZGV2YWRtaW4ubWkyLmluXC9hcGlcL3YxXC91c2VyXC9sb2dpbiIsImlhdCI6MTYwNjMxMjIxNCwiZXhwIjoxNjA2NTI4MjE0LCJuYmYiOjE2MDYzMTIyMTQsImp0aSI6Ik9EZDN6MUowN2p5ejhhVGUiLCJzdWIiOjEsInBydiI6ImM3MjEyZTQ4ZjlmNGI0ZGYyNjRjNTYxMzAxNmRiN2QyZTlmZGQ1MWYifQ.o-3sUtzcHUyggbeos3OBD5ICyLU8SjbrqBwKvxH21ZE','91','$','http://lorempixel.com/512/512/business/Tranxit','',NULL,'','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB001',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-25 13:50:14'),(2,'USR2','provider','Demo','CASH','NORMAL','5VW2cGflYMQmRB3asR76U8QzMpRJt9wgf2tiu3oSIpc=','iX0znKeqG4cCVuFK//fF8g==','$2y$10$dtJgeeXhofQARd60qKpygu.uOoH68t9TTFAGT5g6IxmtgE7Z3bEP2','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB002',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(3,'USR3','James','Demo','CASH','NORMAL','mekhgw/6Vq6YcnBTjfEEzQ==','R/8Lo5rDVB/rQOsxEANu9A==','$2y$10$oQwrQBdhgeKhU4./BYm4o.4wCAxmwh2XTRf7jOd1f2Y9LepHYc5US','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB003',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(4,'USR4','Emily','Demo','CASH','NORMAL','yASee73m7j2Dfiry7jbZrA==','1ioIKsKZ3xTj9ioGXBPLZw==','$2y$10$r8yXlwyAz7O85wK2f4Zz/OnCdD89Pw7kisJbUF3rc5qnFbJi.DmtW','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB004',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(5,'USR5','Jack','Demo','CASH','NORMAL','4FBtMFs+UmP1LusRJkg0ow==','2nYJTEX8G3kWVZ4Iz7XPuQ==','$2y$10$csZO7PIVDUUqg2erd7Y2geKCyNBWP6KYXi0A3w7yTTmyJFeI1WDB.','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB005',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(6,'USR6','Conor','Demo','CASH','NORMAL','03hiNyRxoS9Awiqlsf/83A==','Qxczd2hKIf5SZleV8HuQcw==','$2y$10$SXcQJB.beyBYQ.QTciMvtu5kQQnSok0v.BIotWo4W70qt1mMsZ1Vi','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB006',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(7,'USR7','Amelia','Demo','CASH','NORMAL','etrwzUmu9IRadqo1SFjSbg==','KLmBcsn8o/bZrWMIxl+5WA==','$2y$10$5JbvQFI84lJglp4dyfLQreCD9yv5cC9Pdx/.vK11sGRnw6lig08..','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB007',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(8,'USR8','Adam','Demo','CASH','NORMAL','H5Wrw7TLX0+0AmOA1fAEyA==','8TdNkRMpXWy9W2Dx6ItwKQ==','$2y$10$j6TIU1IKOoX7qkj2R3C7q.Ya.q8XYwNisdhZ8DTrs5cvN5jYBZJAa','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB008',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(9,'USR9','Liam','Demo','CASH','NORMAL','7+FMr87LkNSV0gxDkqY5zg==','yxwoqHdC5NK3g9hrwFhpFw==','$2y$10$BhARDa8abaR88Lzez2ykROtRUhjd3puyqe3ROr336rOdSwhsUoJ9m','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB009',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(10,'USR10','Noah','Demo','CASH','NORMAL','reuQbhoILC86KpBZxcL4Bw==','YAMnrqhDXdRK1eT/3AJSwA==','$2y$10$pRwF6wALG4qWJWGaWMc4OObsmqaMFGxmxxSc5JskD9cA/hBJimHfe','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB010',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(11,'USR11','Emma','Demo','CASH','NORMAL','nWWDvtdZ/4cNI/70t76aGw==','UJFOMw22bQmj20RuH/iLlA==','$2y$10$JYl5d2a9d0X7Lp.WvaX3qO/S9tHxX5weYmFqr8oAfg2cYd61FEL6O','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB011',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(12,'USR12','Nia','Demo','CASH','NORMAL','ddaOvqCTt+M8pr6lue2t7g==','tcNzWsak1tkAy9sV2YGQBA==','$2y$10$nB4fEtWxwnmTA307RxBEw.AuhtBuZXJ6ND0Rr4WtjoHDc04qKzuLW','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB012',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(13,'USR13','Diegi','Demo','CASH','NORMAL','NGYkD++id1ALd8a4gUzlvw==','pPEzfVJW6EeTDvi+AbfCvg==','$2y$10$o4t9ppk9bP/HPDtGKw.3aeW/pplPvrMuux2qaZL1rJab7sn6DT9d2','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB013',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(14,'USR14','Booker','Demo','CASH','NORMAL','008ioyOKU4L3XZFKNbKB/Q==','gPrUCNrllwHAxwlgCFNQ0Q==','$2y$10$Hl42ZqUzSB52UxhylPPkk.7zSf1bQg2rTmvKbYvon5Jo/UsbQr542','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB014',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(15,'USR15','Cillian','Demo','CASH','NORMAL','JWIJDLFYKRyDKsPpdbR9vaJCckr+MGySjLfV3JGXgmw=','BbrlCPzYO9wRjDDCQsmUng==','$2y$10$gDtX9zA7rkA7R9e3Lvk4MOHEtVm.zGyPhETdHRC0bKjARbu4X25JS','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB015',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(16,'USR16','Imala','Demo','CASH','NORMAL','cbjH4kwLbkWVOKDBfQAyHg==','iC2+QemI+TOziBKxOxTV1Q==','$2y$10$MIZ1a0CODqwqYpRuwahfm.cklw3czEVZcv7ea0FCQurbvzdeGiwDq','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB016',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(17,'USR17','Beyon','Demo','CASH','NORMAL','kQjWEQC+/l0+QvGe1Caxjg==','7UYKD/5oVc11oteqKwpz9A==','$2y$10$kR3ZXk9fOf1ttc/C8yWN7OwqzhPp361FEGSleNMqkC9RNOLHvocaO','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB017',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(18,'USR18','Lutana','Demo','CASH','NORMAL','mhIa16tj0CLG+r4SjBZZlA==','V1kJP9XYrNJevwZZRIu/Hw==','$2y$10$nPcFWlr8QwJ1zGV892X6i.OkzNswftIQaWIBRuzY6/HtfojDXoUz6','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB018',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(19,'USR19','Mirri','Demo','CASH','NORMAL','AscI9UNgFk+cX6Fbu+m9jA==','Pjbq3Y3kzOIbXKJLhQKUeQ==','$2y$10$9/wtdcIAw7u63rK4uMPg8.AyJIW5FamjkcIlV2IRcnv9Wohu3nqX6','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB019',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(20,'USR20','Gough','Demo','CASH','NORMAL','9Gb4IWzuhQm0gOVcvM+TDw==','cQh5p+RL6QsVrOJVhUbT3A==','$2y$10$GdCv7s2BCUszeFzmsa.Qle9OrnDESR02G/9b4e26/1j5t.yVC9AM2','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB020',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(21,'USR21','Voss','Demo','CASH','NORMAL','FFnme4TT/kMqCFzMAjn4Sw==','MFUnssJOgTex/YqWTdFRRA==','$2y$10$6Dh0IcuuelLFtpIEh7Y2seoOYdLDwY767ejwPVC2Q8odNlese2Gkq','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB021',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(22,'USR22','Lucinda','Demo','CASH','NORMAL','+bna/KcHyLE/HtEPV/c+njMeVgJ9w59GAJqxbuEXEVo=','5yCXWwl6cEiVfU4luehl6g==','$2y$10$pRHWMQT8XS.M1I1oucXhGuXKLAaXuSJn2tmQB1pcXA6Jkt3ti7MXq','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB022',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(23,'USR23','Melba','Demo','CASH','NORMAL','puBsEjzNNaGSSCDydfBSng==','1QX+cV4rLP0fV8AqM/LibA==','$2y$10$66NQSk0TrYBRTzQd4PMVlOGprL1jQdwmwQGQsyI8agHJFNupCgrRO','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB023',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(24,'USR24','Clancy','Demo','CASH','NORMAL','fHw+r0cCGPFuiJ3WEZAPqw==','G43wNrRUr7IfA9pRELHJXg==','$2y$10$WuSp1R/3wVxa9LnR1sAP7e3DaHPIqaGRQcEhGDIMHxqTCVlMgLWJa','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB024',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(25,'USR25','Hart','Demo','CASH','NORMAL','IzwIv8nminWJ+axZHIDzNw==','4hFE8Rwl9GtLNLxLNybzRg==','$2y$10$GaCe0/ti7bFkn2QDLyzfq.uT1jFBQ1Are1gTGNogTKdz3QBfKC/3O','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB025',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(26,'USR26','Chet','Demo','CASH','NORMAL','jB8QOHeU6XBT36axFyMnQg==','rdvGSMtJBD/BMJSuSDDe7A==','$2y$10$DvC02qHsS7FydBMNPkCGCO/oYAlZLWLl03C7YJuD3RJi7HQE/IphS','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB026',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(27,'USR27','Win','Demo','CASH','NORMAL','w5PfGHTG+Cvtt+cPTwwjmg==','x/5+SccrX25u/4bdqpWNEw==','$2y$10$EtjS7/20WrpqX4UE81iwx.kUgmfUFbQ8NX2V1QgWYBCwKP.Ch5uIm','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB027',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(28,'USR28','Coltran','Demo','CASH','NORMAL','g+rqcBDXBJCMpeovyFkKH8i3juB/sw1d7Ao7+GaMZ1s=','M1oGfhVl7k168S0tvI2mTA==','$2y$10$IuPjlaF0KjPwAD1ZA1WIIOXvB.hGQpxb/EK/c2gumH5Il/gmZNOgW','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB028',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(29,'USR29','Tobiah','Demo','CASH','NORMAL','xtba+XH5xqBJNWqXJ/H8QQ==','VnFrFNPSFxx+XoQnBpHXnw==','$2y$10$Mk6IJX.nE2yw.J1Ip6Z1iOsFbua.dCIKafqPEidtaqxcKYMftVdNC','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB029',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(30,'USR30','Sybil','Demo','CASH','NORMAL','V8kE1yKjq+4LX/r/TCRnrg==','73QO2gNhK+V//BdKR3Gr9g==','$2y$10$ke.m0Sv7bOCwT9c135prPu0Sz0/nsSwWKgAzz3LCbxX2JFtg4icTO','MALE',NULL,'91','$','http://lorempixel.com/512/512/business/Tranxit',NULL,NULL,NULL,'MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','','9AB030',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:45','2020-11-18 06:07:45'),(31,'USR31','User','Demo','CASH','NORMAL','+TQgt00+qdVjS6E3DpG6Zg==','sKDqQVNAHnuX6LqmpU2t7Q==','$2y$10$bcGuHtvwJCxGmrW/JQwa4eBAnXdRpuLISX.zimAibBHXlefOhslm2','','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvZ294ZGV2YWRtaW4ubWkyLmluXC9hcGlcL3YxXC91c2VyXC9sb2dpbiIsImlhdCI6MTYwNTg5NDkzMiwiZXhwIjoxNjA2MTEwOTMyLCJuYmYiOjE2MDU4OTQ5MzIsImp0aSI6IlZDOXBuNnRoM3BzZm9XVngiLCJzdWIiOjMxLCJwcnYiOiJjNzIxMmU0OGY5ZjRiNGRmMjY0YzU2MTMwMTZkYjdkMmU5ZmRkNTFmIn0.sRX5OpC88P2LpoPJhB-T9UXyhq-QRa2uATKS0er7Em0',' 91','$','','emuoEZCWVYo:APA91bGstfkboajwrqNcDApTJkbn7r2M0wpKVCL--xppjov4vmdVfVsItPcFklKygTOJITdJolTj-TCcsrWCrIrKN90dO8xebOMjECBMaAemqZf7nf5L48IzyTNRrsgMDQ2KhJx-Vrkp',NULL,'ANDROID','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','https://goxdevadmin.mi2.in/storage/1/qr_code/31.png','D1F225',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:31:32','2020-11-20 17:57:21'),(32,'USR32','Ajinkya','Dube','CASH','NORMAL','AizS1QxGpHxa+lz/qeZ6gh+x+Yb8TcwMJFUNu4FbqN8d4UALH/mgvs3Hq6paDDgc','h0FI8DFzi1phLMsKjZ4jSQ==','$2y$10$P6jCUvd5Liune7JJKlBSGupwAyjFerxjPCOgcNt8eSPs5LnS5xbzK','MALE',NULL,'91','$',NULL,'12345679',NULL,'ANDROID','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','https://goxdevadmin.mi2.in/storage/1/qr_code/32.png','12AB44',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 07:33:43','2020-11-18 07:33:43'),(33,'USR33','Ajinkya','Dube','CASH','NORMAL','re4j4nFYl5fG2F9BI8tvVDgyQ3ZWHrrW1BA8C3zhSJNEpITDMylpM1Xex8wxhcwM','q3wjunGSz8o4q2vFhAy2AQ==','$2y$10$5nqNNDz4FgVSyVsPA1gruu.HWt1jdyMt8xxBO4z8RdBbu6cAEYeou','MALE',NULL,'91','$',NULL,'12345679',NULL,'ANDROID','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','https://goxdevadmin.mi2.in/storage/1/qr_code/33.png','783397',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 07:59:35','2020-11-18 07:59:35'),(34,'USR34','Pratik','Dhone','CASH','NORMAL','L8wExqrrItUOrCU+9bCg4A==','AgwqJSVtQ158Vwm0K37b9g==','$2y$10$PnWmAEsctsalfNz9iVSQX.SRusq4Y.8PlcDsLJxr5tTOu2lQKEdF2','MALE',NULL,'91','₹',NULL,'emuoEZCWVYo:APA91bGstfkboajwrqNcDApTJkbn7r2M0wpKVCL--xppjov4vmdVfVsItPcFklKygTOJITdJolTj-TCcsrWCrIrKN90dO8xebOMjECBMaAemqZf7nf5L48IzyTNRrsgMDQ2KhJx-Vrkp',NULL,'ANDROID','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','https://goxdevadmin.mi2.in/storage/1/qr_code/34.png','C904B1',0,101,2144,3659,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-20 10:18:38','2020-11-20 11:17:00'),(35,'USR35','User','Demo','CASH','NORMAL','jMccP8GvEvLZgpWu7zPxeQ==','L/cRJ2pxDuTwK5Ul7tt87Q==','$2y$10$lVwnkKOMh.JRGErwaO3HEuh42TPIerok8y3V7L2PqCe1ud6YwRDCu','MALE','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczpcL1wvZ294ZGV2YWRtaW4ubWkyLmluXC9hcGlcL3YxXC91c2VyXC9sb2dpbiIsImlhdCI6MTYwNjExNjU0OCwiZXhwIjoxNjA2MzMyNTQ4LCJuYmYiOjE2MDYxMTY1NDgsImp0aSI6Ijh6RU9jNnB2b0VnUXhjUWMiLCJzdWIiOjM1LCJwcnYiOiJjNzIxMmU0OGY5ZjRiNGRmMjY0YzU2MTMwMTZkYjdkMmU5ZmRkNTFmIn0.yH3MEEIXzOUVvZB8SkTyc5MYUkexGaThR_lH8ijMqoY','91','$',NULL,'d8CBA52vIc0:APA91bFQY3-DDnxFmdKfEVHYnnECiftCO8V2YihhvYT-Ma0wyrVSpJTaFbU6hy5jB_8WWioH-YETib2LetHjwDpClBB82RtwbY6Juif_kgNe_Ol3k_Yd8wvtoFDg2XxRUO88NVSTwZ_4',NULL,'ANDROID','MANUAL',NULL,NULL,NULL,NULL,0.00,5.00,0,'en','https://goxdevadmin.mi2.in/storage/1/qr_code/35.png','4CE117',0,231,865,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-23 07:24:55','2020-11-23 07:29:08');

--
-- Table structure for table `vehicle_services`
--

CREATE TABLE `vehicle_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ride_type_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `vehicle_service_type` enum('RIDE','DELIVERY','ORDERS') COLLATE utf8mb4_unicode_ci NOT NULL,
  `vehicle_service_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capacity` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicle_services`
--


--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_type` enum('SHOP','PROVIDER','FLEET') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SHOP',
  `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zones`
--



