(96,2,'T286EAV',NULL,NULL,2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T286EAV.jpg','[encoded data, 65535 characters]','YUTONG','YUTONG','2000','YUTONG','RED','2022','12345','8000','5000','DIESEL','5000','5000','5000','CHINA',0,'2022-11-16 10:20:21','2023-11-06 09:55:50'),(97,2,'T200DMX',NULL,'0152274665300',3,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T200DMX.png','[encoded data, 28380 characters]','Yutong KLQ','Yutong KLQ','42357244','YUTONG','RED','2020','AFH355836967','2A3568363','20000','Diesel','3','30000','40000','CHINA',0,'2023-04-30 15:31:56','2023-04-30 15:31:56'),(98,2,'T418EEE',NULL,'0152274665300',2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T418EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF990','YUTONG',NULL,NULL,NULL,NULL,'20000','DIESEL','3','25000','30000','CHINA',0,'2023-10-11 14:06:48','2023-10-11 15:15:37'),(99,2,'T414EEE',NULL,'0152274665300',2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T412EEE.png','[encoded data, 16924 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF321','YUTONG','RED','2022','242424','2A3568363','25000','Diesel','3','25000','30000','China',0,'2023-10-11 16:05:25','2023-10-17 14:58:24'),(100,2,'T412EEE',NULL,'0152274665300',2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T417EEE.png','[encoded data, 16924 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF200','YUTONG','RED','2022','AFH355830111','2A3568193','25000','Diesel','3','25000','30000','China',0,'2023-10-11 16:17:34','2023-10-27 17:03:08'),(101,2,'T417EEE',NULL,'0152274665300',2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T417EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3W','YUTONG','RED','2022','AFH355836966','2A3568361','25000','DIESEL','3','30000','35000','CHINA',0,'2023-10-28 08:28:56','2023-10-28 10:13:38'),(102,2,'T408EEE',NULL,'0152274665300',2,53,1,'YUTONG','2*2','Number','34-21-53SEAT-TOILET','/storage/T408EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3W','YUTONG','RED','2022','AFH355836966','2A3568361','25000','DIESEL','3','25000','30000','CHINA',0,'2023-10-28 09:41:11','2023-10-28 09:41:11'),(103,2,'T421EEE',NULL,'0152274665300',4,57,1,'YUTONG','2*2','AlphaNumeric','34-21-57SEAT','/storage/T421EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3W','YUTONG','RED','2022','AFH355836966','2A3568361','25000','DIESEL','3','30000','35000','CHINA',0,'2023-10-28 10:23:11','2023-10-28 10:23:11'),(104,2,'T422EEE',NULL,'0152274665300',4,57,1,'YUTONG','2*2','AlphaNumeric','12-34-57SEAT','/storage/T422EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF','YUTONG','RED','2022','AFH355836966','2A3568363','25000','DIESEL','3','25000','30000','CHINA',0,'2023-10-28 10:24:25','2023-10-28 10:24:25'),(105,2,'T425EEE',NULL,'0152274665300',4,57,1,'YUTONG','2*2','AlphaNumeric','12-34-57SEAT','/storage/T425EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3','YUTONG','RED','2022','2555636','971386745','25000','DIESEL','3','25000','30000','CHINA',0,'2023-10-28 10:26:26','2023-10-28 10:26:26'),(106,2,'T411EEE',NULL,'0152274665300',3,53,1,'YUTONG','2*2','AlphaNumeric','12-34-57SEAT','/storage/T411EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3','YUTONG','RED','2022','AFH355836967','24675985','25000','DIESEL','3','25000','30000','CHINA',0,'2023-10-28 10:37:40','2024-01-01 07:21:14'),(107,2,'T431EEE',NULL,'0152274665300',4,57,1,'YUTONG','2*2','AlphaNumeric','34-21-57SEAT','/storage/T431EEE.png','[encoded data, 7972 characters]','Yutong KLQ','Yutong KLQ','KRQ3444DRF3','YUTONG','RED','2022','AFH355836967','2A3568361','25000','DIESEL','3','25000','30000','CHINA',0,'2023-10-28 10:40:42','2023-10-28 10:40:42');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `city` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `is_deleted` int NOT NULL DEFAULT '0',
  `priority` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'DAR ES SALAAM',NULL,'DAR ES SALAAM',1,0,1,NULL,NULL),(2,'MBEYA',NULL,'MBEYA',1,0,4,NULL,NULL),(3,'ARUSHA',NULL,'ARUSHA',1,0,5,NULL,NULL),(4,'DODOMA',NULL,'DODOMA',1,0,6,NULL,NULL),(5,'MOROGORO',NULL,'MOROGORO',1,0,3,NULL,NULL),(6,'MWANZA',NULL,'MWANZA',1,0,2,NULL,NULL),(7,'TANGA',NULL,'TANGA',1,0,10,NULL,NULL),(8,'MOMBASA',NULL,'MOMBASA',1,1,23,NULL,NULL),(9,'LUSAKA',NULL,'LUSAKA',1,1,24,NULL,NULL),(10,'TUNDUMA',NULL,'TUNDUMA',1,0,9,NULL,NULL),(11,'SONGEA',NULL,'SONGEA',1,0,14,NULL,NULL),(12,'RUKWA',NULL,'RUKWA',1,0,19,NULL,NULL),(13,'LINDI',NULL,'LINDI',1,0,18,NULL,NULL),(14,'MTWARA',NULL,'MTWARA',1,0,17,NULL,NULL),(15,'SINGIDA',NULL,'SINGIDA',1,0,13,NULL,NULL),(16,'MARA',NULL,'MARA',1,0,21,NULL,NULL),(17,'PWANI',NULL,'PWANI',1,0,22,NULL,NULL),(20,'KIGOMA',NULL,'KIGOMA',1,0,12,'2020-04-01 14:35:08','2020-04-01 14:35:08'),(21,'SONGWE',NULL,'SONGWE',1,0,20,'2020-04-06 15:11:16','2020-04-06 15:11:16'),(22,'ZANZIBAR',NULL,'ZANZIBAR',1,1,25,'2020-07-10 09:11:13','2020-07-10 09:11:13'),(23,'BUKOBA',NULL,'KAGERA',1,0,3,'2020-08-03 13:36:32','2020-08-03 13:36:32'),(24,'BABATI',NULL,'MANYARA',1,0,11,'2020-08-03 13:37:27','2020-08-03 13:37:27'),(25,'MOSHI',NULL,'KILIMANJARO',1,0,16,'2020-08-03 13:38:18','2020-08-03 13:38:18'),(26,'KAHAMA',NULL,'SHINYANGA',1,0,7,'2021-02-05 16:02:23','2021-02-05 16:02:23'),(27,'TABORA',NULL,'TABORA',1,0,8,'2021-02-05 16:05:45','2021-02-05 16:05:45'),(28,'IRINGA',NULL,'IRINGA',1,0,8,'2021-02-05 16:05:45','2021-02-05 16:05:45'),(29,'MUSOMA',NULL,'MARA',1,0,7,'2022-12-10 14:35:08','2022-12-10 14:35:08');

--
-- Table structure for table `collection_posts`
--

CREATE TABLE `collection_posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `region` int NOT NULL,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `leader` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_deleted` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `collection_posts`
--

INSERT INTO `collection_posts` VALUES (1,2,1,'Shekilango engine','Ashumy Mohamed','0656855038','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(2,2,1,'Mbezi','Hamisi Nkya','0745459685','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(3,2,6,'Mwanza','Mabolingo-Lushinge','0767890945','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(4,2,23,'Bukoba','Ahmad Ally','0744553590','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(5,2,2,'Mbeya','Seleman Kaseka','0783840060','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(6,2,3,'Arusha','Karigo','0744489555','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(7,2,4,'Dodoma','Siti Issack','0744553590','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(21,2,4,'Morogoro-Msamvu','Siti Issack','0744553590','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(22,2,4,'Tabora','Siti Issack','0744553590','1','0','2021-07-12 17:29:37','2021-07-12 17:35:44'),(23,2,24,'Musoma','Musa Igito','0762689893','1','0','2021-07-12 17:29:37','2021-07-12 17:29:37');

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TIN` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contacts` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `licence` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vending_commission` float DEFAULT NULL,
  `hosting` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'VENDOR',
  `website` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://tiketigala.com',
  `senderID` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verification_link` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://verify.tra.go.tz/',
  `moto` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SAFARI NJEMA',
  `departure_policy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Fika dakika 30 kabla ya muda wa kuondoka',
  `role` int NOT NULL DEFAULT '2',
  `status` int NOT NULL DEFAULT '1',
  `isFloat` int NOT NULL DEFAULT '1',
  `is_deleted` int NOT NULL DEFAULT '0',
  `cancellation` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `holding` int NOT NULL DEFAULT '1',
  `min_time` int DEFAULT NULL,
  `timeout_payment` int NOT NULL DEFAULT '10',
  `refundPercent` int DEFAULT NULL,
  `advert1` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `advert2` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adv1_exp` date DEFAULT NULL,
  `adv2_exp` date DEFAULT NULL,
  `announcement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_media` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `special_msg` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor_link` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'www.tiketigala.com',
  `floatAccount` bigint NOT NULL DEFAULT '190700112233',
  `floatAccountPIN` int NOT NULL DEFAULT '10101',
  `utsURL` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'http://41.59.225.242//.well-known/tz-UTS-server',
  `discoveryURL` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://tiketigala.com/.well-known/tz-e-ticketing-server',
  `reservation_request_id` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txn_prefix` int NOT NULL DEFAULT '910',
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `darMoroFare` double NOT NULL DEFAULT '10000',
  `serviceClass` int NOT NULL DEFAULT '4',
  `printing_copy` int NOT NULL DEFAULT '1',
  `powered_by` int NOT NULL DEFAULT '1',
  `agent_name_mobile` int NOT NULL DEFAULT '1',
  `display_contact` int NOT NULL DEFAULT '1',
  `Telephone` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `business_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,'EXABYTES AFRICA LIMITED','TIKETIGALA','144291336','Sam Nujoma Rd,Savei Plaza, Dar Es Salaam, Tanzania','0744489555','info@eafrica.co.tz','123456789','CRDB','015C543500700','EXABYTES AFRICA LIMITED',NULL,'VENDOR','https://tiketigala.com','TiketiGala','https://verify.tra.go.tz/','TiketiGala Online Booking','SAFARI NJEMA','Fika dk 30 kabla ya muda wa kuondoka',1,1,1,0,NULL,1,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'safari njema','www.tiketigala.com',190700112233,10101,'http://41.59.225.242//.well-known/tz-UTS-server','https://tiketigala.com/.well-known/tz-e-ticketing-server',NULL,910,NULL,10000,4,1,1,1,1,NULL,NULL,NULL,'2022-05-31 21:00:00','2022-05-31 21:00:00','993355'),(2,'ABOOD BUS SERVICE','ABOOD BUS SERVICE','100756927','P.O Box 127 Morogoro, Tanzania','+255748 771 551','customercare@aboodbus.co.tz','123456789','CRDB','01J1076544500','ABOOD BUS Services ltd',0.0151,'VENDOR','www.aboodbus.co.tz','ABOOD BUS','https://verify.tra.go.tz/','*** King Of The Road ***','Speed*Comfort*Luxury*Reliability','Fika dk30 kabla muda wa kuondoka',2,1,1,0,NULL,3,NULL,10,NULL,NULL,NULL,NULL,NULL,'ABOOD BUS SERVICE King of the Roads','Instagram: aboodbustz',NULL,'www.aboodbus.co.tz',190700112233,10101,'http://41.59.227.19/.well-known/tz-payment-ticketing','https://aboodbus.co.tz/.well-known/tz-payment-ticketing',NULL,913,NULL,10000,4,1,0,0,0,'CustomerCare Hotline: 0748771551','Fax: +255 (0) 23 2603 039','','2022-05-31 21:00:00','2023-06-25 19:10:46','993355');

--
-- Table structure for table `customer_review_kpis`
--

CREATE TABLE `customer_review_kpis` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_review_id` bigint unsigned NOT NULL,
  `kpi_id` bigint unsigned NOT NULL,
  `rate` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `kpi_id` (`kpi_id`),
  KEY `customer_review_id` (`customer_review_id`),
  CONSTRAINT `customer_review_kpis_ibfk_1` FOREIGN KEY (`customer_review_id`) REFERENCES `customer_reviews` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `customer_review_kpis_ibfk_2` FOREIGN KEY (`kpi_id`) REFERENCES `kpis` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_review_kpis`
--

INSERT INTO `customer_review_kpis` VALUES (1,1,2,4),(2,1,3,5),(3,1,5,1),(4,1,4,3),(5,1,1,4);

--
-- Table structure for table `customer_reviews`
--

CREATE TABLE `customer_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `passenger_id` int DEFAULT NULL,
  `device_id` text,
  `trip_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `passenger_id` (`passenger_id`,`trip_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_reviews`
--

INSERT INTO `customer_reviews` VALUES (1,'2023-01-26',NULL,NULL,NULL,'2023-01-26 15:37:46','2023-01-26 15:37:46');

--
-- Table structure for table `daily_counters`
--

CREATE TABLE `daily_counters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `code` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `TIN` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `daily_counters`
--


--
-- Table structure for table `device_notifications`
--

CREATE TABLE `device_notifications` (
  `id` bigint unsigned NOT NULL,
  `device_id` bigint unsigned NOT NULL,
  `notification_id` bigint unsigned NOT NULL,
  `message` text,
  `date` date NOT NULL,
  `frequency` int DEFAULT '0',
  `status` int DEFAULT '1',
  `is_deleted` int DEFAULT '0',
  `event` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `device_notifications`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `fare_structure_sub_routes`
--

CREATE TABLE `fare_structure_sub_routes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fare_structure_id` bigint unsigned NOT NULL,
  `sub_route_id` bigint unsigned NOT NULL,
  `commission` float NOT NULL DEFAULT '0',
  `agent_id` bigint unsigned DEFAULT NULL,
  `fare` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fare_structure_id` (`fare_structure_id`),
  KEY `sub_route_id` (`sub_route_id`),
  KEY `agent_id` (`agent_id`),
  CONSTRAINT `fare_structure_sub_routes_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fare_structure_sub_routes_ibfk_2` FOREIGN KEY (`fare_structure_id`) REFERENCES `fare_structures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fare_structure_sub_routes_ibfk_3` FOREIGN KEY (`sub_route_id`) REFERENCES `sub_routes` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fare_structure_sub_routes`
--


--
-- Table structure for table `fare_structures`
--

CREATE TABLE `fare_structures` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `route_id` bigint unsigned NOT NULL,
  `date` date NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `route_id` (`route_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `fare_structures_ibfk_1` FOREIGN KEY (`route_id`) REFERENCES `routes` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fare_structures_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fare_structures`
--


--
-- Table structure for table `group_user`
--

CREATE TABLE `group_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `status` int unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_user_group_id_index` (`group_id`),
  KEY `group_user_user_id_index` (`user_id`),
  KEY `group_user_created_by_index` (`created_by`),
  CONSTRAINT `group_user_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `group_user_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `group_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_user`
--


--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `groups_created_by_index` (`created_by`),
  CONSTRAINT `groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--


--
-- Table structure for table `kpis`
--

CREATE TABLE `kpis` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `descriptions` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kpis`
--

INSERT INTO `kpis` VALUES (1,'Punctuality',' '),(2,'Bus Clean Lines',' '),(3,'Comfort',' '),(4,'Driving Habit',' '),(5,'Customer Service - Conductor',' ');

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `labels`
--

INSERT INTO `labels` VALUES (1,'NAMBA 1',1,NULL,NULL),(2,'NAMBA 2',1,NULL,NULL),(3,'NAMBA 3',1,NULL,NULL),(4,'NAMBA 4',1,NULL,NULL),(5,'KB1',1,NULL,NULL),(6,'KB2',1,NULL,NULL),(7,'KB3',1,NULL,NULL),(8,'KB4',1,NULL,NULL),(9,'KB5',1,NULL,NULL),(10,'SHB1',1,NULL,NULL),(11,'MBC1',1,NULL,NULL),(12,'MBC2',1,NULL,NULL),(13,'MBC3',1,NULL,NULL),(14,'MBC4',1,NULL,NULL),(15,'MBC5',1,NULL,NULL),(16,'F',1,NULL,NULL),(17,'G',1,NULL,NULL),(18,'H',1,NULL,NULL),(19,'I',1,NULL,NULL),(20,'J',1,NULL,NULL),(21,'SHB2',1,NULL,NULL),(22,'SHB3',1,NULL,NULL),(23,'SHB4',1,NULL,NULL),(24,'SHB5',1,NULL,NULL),(25,'SHC1',1,NULL,NULL),(26,'SHC2',1,NULL,NULL),(27,'SHC3',1,NULL,NULL),(28,'SHC4',1,NULL,NULL),(29,'SHC5',1,NULL,NULL),(30,'NAMBA 11',1,NULL,NULL),(31,'NAMBA 12',1,NULL,NULL),(32,'NAMBA 13',1,NULL,NULL),(33,'NAMBA 14',1,NULL,NULL),(34,'NAMBA 15',1,NULL,NULL),(35,'NAMBA 16',1,NULL,NULL),(36,'NAMBA 17',1,NULL,NULL),(37,'NAMBA 18',1,NULL,NULL),(38,'NAMBA 19',1,NULL,NULL),(39,'NAMBA 20',1,NULL,NULL),(40,'NAMBA 21',1,NULL,NULL),(41,'NAMBA 22',1,NULL,NULL),(42,'NAMBA 23',1,NULL,NULL),(43,'NAMBA 24',1,NULL,NULL),(44,'NAMBA 25',1,NULL,NULL),(45,'NAMBA 26',1,NULL,NULL),(46,'NAMBA 27',1,NULL,NULL),(47,'NAMBA 28',1,NULL,NULL),(48,'NAMBA 29',1,NULL,NULL),(49,'NAMBA 30',1,NULL,NULL),(50,'NAMBA 31',1,NULL,NULL),(51,'NAMBA 32',1,NULL,NULL),(52,'NAMBA 33',1,NULL,NULL),(53,'NAMBA 34',1,NULL,NULL),(54,'NAMBA 35',1,NULL,NULL),(55,'NAMBA 36',1,NULL,NULL),(56,'NAMBA 37',1,NULL,NULL),(57,'NAMBA 38',1,NULL,NULL),(58,'NAMBA 39',1,NULL,NULL),(59,'NAMBA 40',1,NULL,NULL);

--
-- Table structure for table `latras`
--

CREATE TABLE `latras` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `route` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_point` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_point` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fare` double NOT NULL,
  `ordinary` int DEFAULT NULL,
  `semi_luxury` int DEFAULT NULL,
  `luxury` int DEFAULT NULL,
  `vip` int DEFAULT NULL,
  `vvip` int DEFAULT NULL,
  `distance` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int DEFAULT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `latras`
--

INSERT INTO `latras` VALUES (1,'DAR ES SALAAM - MWANZA','1','6',0,50000,75000,80000,100000,NULL,'1154',16,1,'2020-08-03 13:56:24','2023-10-06 17:26:17'),(2,'MWANZA - DAR ES SALAAM','6','1',0,50000,75000,80000,100000,NULL,'1154',16,1,'2020-08-03 13:56:24','2023-10-06 17:27:15'),(3,'DAR ES SALAAM - BUKOBA','1','23',0,60000,95000,100000,130000,NULL,'1453',20,1,'2020-08-03 14:01:26','2023-10-06 17:16:54'),(4,'BUKOBA - DAR ES SALAAM','23','1',0,60000,95000,100000,130000,NULL,'1453',20,1,'2020-08-03 14:01:26','2023-10-06 17:17:16'),(5,'DAR ES SALAAM - MBEYA','1','2',0,34000,47000,55000,60000,NULL,'833',14,1,'2020-08-03 14:04:54','2023-10-08 06:34:22'),(6,'MBEYA - DAR ES SALAAM','2','1',0,33000,47000,55000,60000,NULL,'833',14,1,'2020-08-03 14:04:54','2023-10-08 06:34:32'),(7,'DAR ES SALAAM - ARUSHA','1','3',0,22700,2500000,2500000,2500000,NULL,'616',10,1,'2020-08-03 14:05:49','2023-03-09 12:50:43'),(8,'ARUSHA - DAR ES SALAAM','3','1',0,22700,2280000,2280000,2280000,NULL,'616',10,1,'2020-08-03 14:05:49','2023-03-09 12:51:30'),(9,'DAR ES SALAAM - BABATI','1','24',0,29000,45000,NULL,NULL,NULL,'785',11,1,'2020-08-03 14:07:29','2020-08-03 14:07:29'),(10,'BABATI - DAR ES SALAAM','24','1',0,29000,45000,NULL,NULL,NULL,'785',11,1,'2020-08-03 14:07:29','2020-08-03 14:07:29'),(11,'DAR ES SALAAM - DODOMA','1','4',0,16700,1000,NULL,NULL,NULL,'452',9,1,'2021-02-04 10:24:24','2021-05-02 08:27:41'),(12,'DODOMA - DAR ES SALAAM','4','1',0,20000,40000,NULL,NULL,NULL,'452',9,1,'2021-02-04 10:24:24','2023-07-28 18:26:00'),(13,'DAR ES SALAAM - KAHAMA','1','26',0,36600,52700,NULL,NULL,NULL,'1030',15,1,'2021-02-05 16:12:38','2021-02-05 16:12:38'),(14,'KAHAMA - DAR ES SALAAM','26','1',0,36600,52700,NULL,NULL,NULL,'1030',15,1,'2021-02-05 16:12:38','2021-02-05 16:12:38'),(15,'DAR ES SALAAM - TABORA','1','27',0,30000,50000,50000,NULL,NULL,'890',12,1,'2021-03-30 10:49:40','2022-07-01 22:11:27'),(16,'TABORA - DAR ES SALAAM','27','1',0,30000,45000,50000,NULL,NULL,'890',12,1,'2021-03-30 10:49:40','2022-09-02 22:56:00'),(17,'MWANZA - KAHAMA','6','26',0,15000,20000,25000,NULL,NULL,'280',4,1,'2021-04-18 11:35:52','2021-04-18 11:35:52'),(18,'KAHAMA - MWANZA','26','6',0,8000,10000,15000,NULL,NULL,'280',4,1,'2021-04-18 11:35:52','2021-04-18 11:58:34'),(19,'BUKOBA - MOSHI','23','25',0,55000,65000,70000,NULL,NULL,'1900',15,1,'2021-04-19 11:46:46','2021-04-19 11:46:46'),(20,'MOSHI - BUKOBA','25','23',0,55000,65000,70000,NULL,NULL,'1900',15,1,'2021-04-19 11:46:46','2021-04-19 11:46:46'),(21,'DAR ES SALAAM - MOROGORO','1','5',0,10000,15000,25000,30000,NULL,'183',4,1,'2022-06-08 08:19:16','2023-09-10 20:22:00'),(22,'MOROGORO - DAR ES SALAAM','5','1',0,10000,15000,25000,30000,NULL,'183',4,1,'2022-06-08 08:19:16','2023-09-10 20:22:22'),(23,'ARUSHA - MOROGORO','3','5',0,20000,35000,40000,45000,NULL,'632',10,1,'2022-06-08 12:03:12','2023-12-03 07:31:41'),(24,'MOROGORO - ARUSHA','5','3',0,20000,35000,40000,45000,NULL,'632',10,1,'2022-06-08 12:03:12','2023-12-03 07:31:52'),(25,'DAR ES SALAAM - TUNDUMA','1','10',0,50000,60000,70000,90000,NULL,'900',15,1,'2022-06-22 10:18:31','2023-10-06 17:08:05'),(26,'TUNDUMA - DAR ES SALAAM','10','1',0,50000,70000,80000,90000,NULL,'900',15,1,'2022-06-22 10:18:31','2023-10-06 17:10:18'),(27,'DAR ES SALAAM - IRINGA','1','28',0,25000,45000,NULL,NULL,NULL,'432',11,1,'2022-06-22 10:19:06','2022-06-22 10:19:06'),(28,'IRINGA - DAR ES SALAAM','28','1',0,25000,45000,NULL,NULL,NULL,'432',11,1,'2022-06-22 10:19:06','2022-06-22 10:19:06'),(29,'MOROGORO - MOSHI','5','25',0,30000,40000,50000,NULL,NULL,'600',13,1,'2022-06-30 22:50:56','2022-06-30 22:50:56'),(30,'MOSHI - MOROGORO','25','5',0,30000,40000,50000,NULL,NULL,'600',13,1,'2022-06-30 22:50:56','2022-06-30 22:50:56'),(31,'MOROGORO - MWANZA','5','6',0,50000,65000,70000,NULL,NULL,'800',13,1,'2022-07-01 17:37:44','2022-07-01 17:37:44'),(32,'MWANZA - MOROGORO','6','5',0,50000,6500000,70000,NULL,NULL,'800',13,1,'2022-07-01 17:37:44','2023-01-05 10:20:30'),(33,'DAR ES SALAAM - BUKOBA','1','23',0,65000,80000,100000,120000,120000,'1100',20,1,'2022-11-16 09:59:20','2022-11-16 09:59:20'),(34,'BUKOBA - DAR ES SALAAM','23','1',0,65000,80000,100000,120000,NULL,'1100',20,1,'2022-11-16 09:59:20','2022-11-16 09:59:20'),(35,'DAR ES SALAAM - MUSOMA','1','29',0,60000,75000,85000,100000,100000,'1000',17,1,'2022-12-10 16:18:59','2022-12-10 16:18:59'),(36,'MUSOMA - DAR ES SALAAM','29','1',0,60000,75000,85000,100000,NULL,'1000',17,1,'2022-12-10 16:18:59','2022-12-10 16:18:59');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int unsigned NOT NULL DEFAULT '1',
  `created_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int unsigned NOT NULL DEFAULT '1',
  `created_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--


--
-- Table structure for table `nominal_ledgers`
--

CREATE TABLE `nominal_ledgers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `vno` bigint DEFAULT NULL,
  `movement_date` datetime NOT NULL,
  `debit` int DEFAULT NULL,
  `outflow` double DEFAULT NULL,
  `credit` int DEFAULT NULL,
  `inflow` double DEFAULT NULL,
  `balance` double DEFAULT NULL,
  `system_reference` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nominal_ledgers`
--

INSERT INTO `nominal_ledgers` VALUES (1,2,1,'2022-10-05 18:33:04',1,0,3,1595000,1595000,'9550883E','2022-10-05 15:33:04','2022-10-05 15:33:04'),(2,2,2,'2022-10-08 21:23:17',1,0,3,1875000,1595000,'97140W11','2022-10-08 18:23:17','2022-10-08 18:23:17'),(3,2,3,'2022-10-08 21:24:21',1,0,3,1875000,3470000,'9780P47','2022-10-08 18:24:21','2022-10-08 18:24:21');

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

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `message` text,
  `date` date NOT NULL,
  `repeat` int DEFAULT '1',
  `status` int DEFAULT '1',
  `is_deleted` int DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `notifications` VALUES (1,'welcome new user','Welcome and enjoy ABOOD BUS SERVICE','2023-02-01',1,1,0,NULL,'2023-02-01 12:37:46','2023-02-01 12:37:46');

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

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 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,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


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

CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 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,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT 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 `oauth_personal_access_clients`
--


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

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

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `offices`
--

CREATE TABLE `offices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `office` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offices`
--

INSERT INTO `offices` VALUES (1,2,'DAR ES SALAAM','DAR ES SALAAM','Shekilango Engine','0745459685','DSM','111222',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(2,2,'MWANZA','MWANZA','Mwanza(Nata/Nyegezi)','0622358630','MWZ','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(3,2,'BUKOBA','BUKOBA','Bukoba Stand','0655611106','BKB','111222',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(4,2,'MBEYA','MBEYA','Mbeya Stand','0783840060','MBY','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(5,2,'DODOMA','DODOMA','Dodoma Stand','0683644591','DOM','111222',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(6,2,'ARUSHA','ARUSHA','Arusha Stand','0745459685','ARS','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(7,2,'KAHAMA','KAHAMA','Kahama','0755539556','KHM','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(8,2,'MOSHI','MOSHI','Moshi','0755539556','MSH','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(9,2,'MOROGORO','MOROGORO','Msamvu Morogoro','0755539556','MOR','111333',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(20,2,'DAR ES SALAAM','DAR ES SALAAM','Mbezi Stand','0745459685','DSM','111222',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(26,2,'TABORA','TABORA','Tabora Office 1','0745459685','TBR','111222',1,0,'2021-05-16 00:00:00','2021-05-16 00:00:00'),(27,2,'SINGIDA','15',NULL,'0716628365',NULL,'90764E2',1,0,'2023-05-04 08:51:24','2023-05-04 08:51:24'),(28,2,'SINGIDA','15',NULL,'0716628365',NULL,'09I3237',1,0,'2023-05-04 08:52:32','2023-05-04 08:52:32');

--
-- Table structure for table `parcelRoute`
--

CREATE TABLE `parcelRoute` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `route_id` int NOT NULL,
  `route_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parcelRoute`
--

INSERT INTO `parcelRoute` VALUES (1,2,1,'DSM-BUKOBA',1),(2,0,2,'BUKOBA-DSM',1),(3,2,3,'DSM-MWANZA',1),(4,0,4,'MWANZA-DSM',1),(5,2,5,'DSM-MBEYA',1),(6,0,6,'MBEYA-DSM',1),(7,2,7,'DSM-ARUSHA',1),(8,0,8,'ARUSHA-DSM',1),(9,2,9,'DSM-DODOMA',1),(10,0,10,'DODOMA-DSM',1),(13,2,56,'TABORA-DSM',1);

--
-- Table structure for table `parcels`
--

CREATE TABLE `parcels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `senderAgent` int NOT NULL,
  `receiverAgent` int DEFAULT NULL,
  `origin` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `destination` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_location` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sentOffice` int NOT NULL,
  `receiveOffice` int DEFAULT NULL,
  `company` int NOT NULL,
  `parcel` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int NOT NULL,
  `collection` float DEFAULT NULL,
  `trackingNumber` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `senderMsisdn` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiver` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiverMsisdn` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateSent` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateReceived` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateReleased` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `payment` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CASH',
  `parcelWorth` int DEFAULT NULL,
  `weight` int DEFAULT NULL,
  `size` int DEFAULT NULL,
  `color` int DEFAULT NULL,
  `count` int NOT NULL DEFAULT '1',
  `device_id` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manifestByOffice` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manifestByRegion` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route_id` int DEFAULT NULL,
  `route` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_date` date DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `session_id` int DEFAULT NULL,
  `agent_total` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parcels_trackingnumber_unique` (`trackingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parcels`
--


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

CREATE TABLE `password_resets` (
  `email` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `payment_number` varchar(15) DEFAULT NULL,
  `amount` varchar(10) DEFAULT NULL,
  `external_payment_reference_number` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `internal_payment_reference` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_logs`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_created_by_index` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `policies`
--

CREATE TABLE `policies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cancellation` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_time` int DEFAULT NULL,
  `refundPercent` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `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 `policies`
--


--
-- Table structure for table `pos_machines`
--

CREATE TABLE `pos_machines` (
  `id` int NOT NULL AUTO_INCREMENT,
  `device_name` varchar(155) DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `model` varchar(155) DEFAULT NULL,
  `company` int DEFAULT NULL,
  `assigned` varchar(155) DEFAULT NULL,
  `assigned_to` varchar(155) DEFAULT NULL,
  `registered_date` datetime DEFAULT NULL,
  `last_used` datetime DEFAULT NULL,
  `last_used_by` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `is_deleted` int DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `registered_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pos_machines`
--

INSERT INTO `pos_machines` VALUES (2,'z91 Wilson','1234567890','57389',2,'1','179','2023-09-23 17:58:33',NULL,NULL,0,1,NULL,75,'2023-09-23 17:58:33','2023-09-23 17:58:33'),(3,'Z91','1ebec0se1b22dcbd','1ebec0se1b22dcbd',2,'1',NULL,'2023-09-23 20:11:50',NULL,NULL,1,0,NULL,41,'2023-09-23 20:11:50','2023-09-23 20:11:50'),(4,'Z91','flad68ccc812ffb2','flad68ccc812ffb2',2,'1','368','2023-09-23 20:16:44',NULL,NULL,1,0,NULL,41,'2023-09-23 20:16:44','2023-09-23 20:16:44'),(5,'Z91','e630177a97145635','e630177a97145635',2,'1','440','2023-09-23 20:17:48',NULL,NULL,1,0,NULL,41,'2023-09-23 20:17:48','2023-09-23 20:17:48'),(6,'Z91','98b68a22508f8e2a','98b68a22508f8e2a',2,'1','252','2023-09-23 20:18:22','2023-09-29 16:21:30',252,1,0,NULL,41,'2023-09-23 20:18:22','2023-10-03 19:23:36'),(7,'Z91','bb8b0964f05b8b837d','bb8b0964f05b8b837d',2,'1','449','2023-09-23 20:19:06',NULL,NULL,1,0,NULL,41,'2023-09-23 20:19:06','2023-09-23 20:19:06'),(8,'Z91','s630177a97145635','s630177a97145635',2,'1','264','2023-09-23 20:20:16',NULL,NULL,1,0,NULL,41,'2023-09-23 20:20:16','2023-09-23 20:20:16'),(9,'Z91','023ib9c04db4','023ib9c04db4',2,'1','268','2023-09-23 20:20:51','2023-09-24 10:59:33',276,1,0,NULL,41,'2023-09-23 20:20:51','2023-09-24 11:52:39'),(10,'Z91','b26024e1ad5fc20c','b26024e1ad5fc20c',2,'1','542','2023-09-23 20:21:56',NULL,NULL,1,0,NULL,41,'2023-09-23 20:21:56','2023-09-23 20:21:56'),(11,'Z91','46af8e546p5747a6','46af8e546p5747a6',2,'1','557','2023-09-23 20:22:58',NULL,NULL,1,0,NULL,41,'2023-09-23 20:22:58','2023-09-23 20:22:58'),(12,'Z91','b3f5afbb6c3b14c6','b3f5afbb6c3b14c6',2,'1','480','2023-09-23 20:23:30','2023-09-01 13:28:06',408,1,0,NULL,41,'2023-09-23 20:23:30','2023-10-03 19:23:44'),(13,'Z91','Oe71105e971de87a','Oe71105e971de87a',2,'1',NULL,'2023-09-23 20:30:51',NULL,NULL,1,0,NULL,41,'2023-09-23 20:30:51','2023-09-23 20:30:51'),(14,'Z91','11175ee8cce37162','11175ee8cce37162',2,'1','338','2023-09-23 20:31:49','2023-08-11 05:31:21',338,1,0,NULL,41,'2023-09-23 20:31:49','2023-10-03 19:23:46'),(15,'Z91','bcef2b112a95be96','bcef2b112a95be96',2,'1','408','2023-09-23 20:32:34',NULL,NULL,1,0,NULL,41,'2023-09-23 20:32:34','2023-09-23 20:32:34'),(16,'Z91','0df5b9795426a5bd','0df5b9795426a5bd',2,'1',NULL,'2023-09-23 20:33:50',NULL,NULL,1,0,NULL,41,'2023-09-23 20:33:50','2023-09-23 20:33:50'),(17,'Z91','20285ced53bce162','20285ced53bce162',2,'1','553','2023-09-23 20:34:29','2023-09-24 14:10:48',457,1,0,NULL,41,'2023-09-23 20:34:29','2023-10-03 19:23:50'),(18,'Z91','c8cc21c3b2a2fce2','c8cc21c3b2a2fce2',2,'1','385','2023-09-23 20:35:13','2023-05-27 10:16:43',367,1,0,NULL,41,'2023-09-23 20:35:13','2023-10-03 19:23:51'),(19,'Z91','5dfa769e35e95692','5dfa769e35e95692',2,'1','205','2023-09-23 20:36:19','2023-10-03 19:27:25',211,1,0,NULL,41,'2023-09-23 20:36:19','2023-10-03 19:23:51'),(20,'Q1','5b72df6353efee5','5b72df6353efee5',2,'1','236','2023-09-23 20:39:22',NULL,NULL,1,0,NULL,41,'2023-09-23 20:39:22','2023-09-23 20:39:22'),(21,'Z91','c5ddb93813f65b30','c5ddb93813f65b30',2,'1','179','2023-09-23 20:40:06','2023-10-02 06:14:22',180,1,0,NULL,41,'2023-09-23 20:40:06','2023-10-03 19:23:52'),(22,'Z91','eb6fa520c9fd673b','eb6fa520c9fd673b',2,'1','179','2023-09-23 20:41:01','2023-10-02 20:29:16',325,1,0,NULL,41,'2023-09-23 20:41:01','2023-10-03 19:23:52'),(23,'Z91','147f69d711986fc6','147f69d711986fc6',2,'1',NULL,'2023-09-23 20:42:07','2023-10-03 19:07:39',193,1,0,NULL,41,'2023-09-23 20:42:07','2023-10-03 19:23:52'),(24,'Z91','bf6c8db5558e28','bf6c8db5558e28',2,'1','188','2023-09-23 20:42:35',NULL,NULL,1,0,NULL,41,'2023-09-23 20:42:35','2023-09-23 20:42:35'),(25,'Z91','26765a5ca954d341','26765a5ca954d341',2,'1',NULL,'2023-09-23 20:43:11','2023-10-03 09:23:16',276,1,0,NULL,41,'2023-09-23 20:43:11','2023-10-03 19:23:54'),(26,'Q1','5954a1382831a167','5954a1382831a167',2,'1','236','2023-09-23 20:47:47','2023-10-03 19:43:38',237,1,0,NULL,41,'2023-09-23 20:47:47','2023-10-03 19:23:54'),(27,'Z91','8db83f5be78041f96','8db83f5be78041f96',2,'1',NULL,'2023-09-24 14:43:06',NULL,NULL,1,0,NULL,41,'2023-09-24 14:43:06','2023-09-24 14:43:06'),(28,'Z91','8d3f7ce55a03dd','8d3f7ce55a03dd',2,'1',NULL,'2023-09-24 14:44:36',NULL,NULL,1,0,NULL,41,'2023-09-24 14:44:36','2023-09-24 14:44:36'),(29,'Z91','392617fa8265170d','392617fa8265170d',2,'1',NULL,'2023-09-24 14:44:55','2023-10-03 19:58:37',230,1,0,NULL,41,'2023-09-24 14:44:55','2023-10-03 19:23:57'),(30,'Z91','5ea1722b5b5ae1','5ea1722b5b5ae1',2,'1',NULL,'2023-09-24 14:45:13',NULL,NULL,1,0,NULL,41,'2023-09-24 14:45:13','2023-09-24 14:45:13'),(31,'Z91','5fe621112bbae7ce','5fe621112bbae7ce',2,'1',NULL,'2023-09-24 14:45:44','2023-10-03 19:21:18',475,1,0,NULL,41,'2023-09-24 14:45:44','2023-10-03 19:23:58'),(32,'Z91','d29172227eb357b9','d29172227eb357b9',2,'1','342','2023-09-24 14:46:19',NULL,NULL,1,0,NULL,41,'2023-09-24 14:46:19','2023-09-24 14:46:19'),(33,'Z91','219b1349515c68fd','219b1349515c68fd',2,'1',NULL,'2023-09-24 14:46:43','2023-10-03 20:21:28',356,1,0,NULL,41,'2023-09-24 14:46:43','2023-10-03 19:24:00'),(34,'Z91','b863a6bf97addee3','b863a6bf97addee3',2,'1',NULL,'2023-09-24 14:47:08','2023-10-03 19:41:16',363,1,0,NULL,41,'2023-09-24 14:47:08','2023-10-03 19:24:00'),(35,'Z91','7a1085d6ea7f4ta6','7a1085d6ea7f4ta6',2,'1',NULL,'2023-09-24 14:47:47',NULL,NULL,1,0,NULL,41,'2023-09-24 14:47:47','2023-09-24 14:47:47'),(36,'Z91','2t2e711806d2791d','2t2e711806d2791d',2,'1',NULL,'2023-09-24 14:48:13',NULL,NULL,1,0,NULL,41,'2023-09-24 14:48:13','2023-09-24 14:48:13'),(37,'Z91','1949c2acc24b6dfd','1949c2acc24b6dfd',2,'1','343','2023-09-25 14:50:18','2023-09-30 14:56:56',343,1,0,NULL,41,'2023-09-25 14:50:18','2023-10-03 19:24:03'),(38,'Z91','19e2cf6d786037da','19e2cf6d786037da',2,'1','230','2023-09-25 15:21:03','2023-10-03 16:56:48',235,1,0,NULL,41,'2023-09-25 15:21:03','2023-10-03 19:24:03'),(39,'Z91','0fd64d19c8e1886a','0fd64d19c8e1886a',2,'1','230','2023-09-25 15:22:42','2023-09-18 12:06:42',235,1,0,NULL,41,'2023-09-25 15:22:42','2023-10-03 19:24:03'),(40,'Z91','8a17d69fa134579d','8a17d69fa134579d',2,'1','261','2023-09-26 11:23:35','2023-10-03 17:31:37',261,1,0,NULL,41,'2023-09-26 11:23:35','2023-10-03 19:24:03'),(41,'Z91','afs136053a563028','afs136053a563028',2,'1','223','2023-09-26 11:24:40',NULL,NULL,1,0,NULL,41,'2023-09-26 11:24:40','2023-09-26 11:24:40'),(42,'z91','24bob7b35bccibes','24bob7b35bccibes',2,'1','223','2023-09-26 11:25:57',NULL,NULL,1,0,NULL,41,'2023-09-26 11:25:57','2023-09-26 11:25:57'),(43,'Z91','340ecb4383a5c234','340ecb4383a5c234',2,'1','225','2023-09-26 11:28:07',NULL,NULL,2,0,NULL,41,'2023-09-26 11:28:07','2023-09-26 11:28:07'),(44,'Z91','a7f3c68c72c32ee7','a7f3c68c72c32ee7',2,'1','478','2023-09-26 11:39:01',NULL,NULL,1,0,NULL,41,'2023-09-26 11:39:01','2023-09-26 11:39:01'),(45,'Z91','30f475cbff51bb34','30f475cbff51bb34',2,'1','278','2023-09-26 11:40:32','2023-10-03 10:58:03',278,1,0,NULL,41,'2023-09-26 11:40:32','2023-10-03 19:24:08'),(46,'Z91','2803ac6c2d6c9ac8','hard disk not found vestro 3910',2,'1','383','2023-09-26 16:14:58','2023-10-03 22:13:05',479,1,0,NULL,41,'2023-09-26 16:14:58','2023-10-03 19:24:08'),(47,'Z91','4655310ca761fa5d','4655310ca761fa5d',2,'1','413','2023-09-26 16:16:16','2023-10-03 22:15:31',413,1,0,NULL,41,'2023-09-26 16:16:16','2023-10-03 19:24:08'),(48,'Z91','Oadaci65a662118','Oadaci65a662118',2,'1','351','2023-09-26 16:20:32',NULL,NULL,1,0,NULL,41,'2023-09-26 16:20:32','2023-09-26 16:20:32'),(49,'Z91','0c0146b3966541','0c0146b3966541',2,'1','479','2023-09-26 16:23:30',NULL,NULL,1,0,NULL,41,'2023-09-26 16:23:30','2023-09-26 16:23:30'),(50,'z91','300221120152026','300221120152026',2,'1','257','2023-09-26 16:24:57',NULL,NULL,1,0,NULL,41,'2023-09-26 16:24:57','2023-09-26 16:24:57'),(51,'Z91','781e2eb3de11c7c','781e2eb3de11c7c',2,'1',NULL,'2023-09-26 16:26:22',NULL,NULL,1,0,NULL,41,'2023-09-26 16:26:22','2023-09-26 16:26:22'),(52,'Z91','1785479373f33e05','1785479373f33e05',2,'1',NULL,'2023-09-26 16:28:12','2023-10-03 20:19:56',352,1,0,NULL,41,'2023-09-26 16:28:12','2023-10-03 19:24:14'),(53,'Z91','sc3ee579addae508','sc3ee579addae508',2,'1',NULL,'2023-09-26 16:29:09',NULL,NULL,1,0,NULL,41,'2023-09-26 16:29:09','2023-09-26 16:29:09'),(54,'Z91','300221120152027','300221120152027',2,'1',NULL,'2023-09-26 16:29:57',NULL,NULL,1,0,NULL,41,'2023-09-26 16:29:57','2023-09-26 16:29:57'),(55,'Z91','72cfesfi9c5ae07','72cfesfi9c5ae07',2,'1',NULL,'2023-09-26 16:31:03',NULL,NULL,1,0,NULL,41,'2023-09-26 16:31:03','2023-09-26 16:31:03');

--
-- Table structure for table `references`
--

CREATE TABLE `references` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` int NOT NULL,
  `code` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `references`
--


--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int NOT NULL,
  `date` date NOT NULL,
  `noon` int NOT NULL DEFAULT '0',
  `evening` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reports`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  `status` int unsigned NOT NULL DEFAULT '1',
  `created_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roles_created_by_index` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super Admin','web',1,1,NULL,'2020-04-13 07:20:00','2020-04-13 07:20:00'),(2,'Admin','web',1,1,NULL,'2020-04-13 07:21:00','2020-04-13 07:21:00'),(3,'Supervisor','web',1,1,NULL,'2020-04-15 08:46:26','2020-04-15 08:46:26'),(4,'Manager','web',1,NULL,NULL,NULL,NULL),(5,'Staff','web',1,NULL,NULL,NULL,NULL),(6,'Driver','web',1,NULL,NULL,NULL,NULL),(7,'Condoctor','web',1,NULL,NULL,NULL,NULL),(8,'HR Manager','web',1,1,NULL,'2020-04-13 07:21:00','2020-04-13 07:21:00'),(9,'Finance Manager','web',1,1,NULL,'2020-04-15 08:46:26','2020-04-15 08:46:26');

--
-- Table structure for table `routes`
--

CREATE TABLE `routes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `route_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` int NOT NULL,
  `class` int NOT NULL,
  `start_point` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_point` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `via` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `distance` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approximate_hours` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `code` int NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `commission` double NOT NULL DEFAULT '0',
  `fare` double NOT NULL DEFAULT '0',
  `is_deleted` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
