text: -- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
  --
  -- Host: 127.0.0.1    Database: toll_management
  -- ------------------------------------------------------
  -- Server version	5.7.27-0ubuntu0.19.04.1
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `companies`
  --
  
  DROP TABLE IF EXISTS `companies`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `companies` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `established_in` datetime DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `trade_license` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_deleted` tinyint(1) DEFAULT NULL,
    `is_published` tinyint(1) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `companies`
  --
  
  LOCK TABLES `companies` WRITE;
  /*!40000 ALTER TABLE `companies` DISABLE KEYS */;
  INSERT INTO `companies` VALUES (1,'Toyota','222','alam@gmail.com','edfsdfs',NULL,NULL,NULL,NULL,1,'2019-07-04 15:40:55','2019-07-04 15:40:55'),(2,'BMW','22222','test@gmail.com','efesfx',NULL,NULL,NULL,NULL,1,'2019-07-04 15:41:19','2019-07-04 15:41:19'),(3,'Porsche','222','alam@gmail.com','wewew',NULL,NULL,NULL,NULL,1,'2019-07-04 15:42:04','2019-07-04 15:42:04');
  /*!40000 ALTER TABLE `companies` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `deposits`
  --
  
  DROP TABLE IF EXISTS `deposits`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `deposits` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `deposit_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vehicle_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `deposit_type` tinyint(4) NOT NULL,
    `amount` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `deposits`
  --
  
  LOCK TABLES `deposits` WRITE;
  /*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
  INSERT INTO `deposits` VALUES (1,'1',1,1,1,122,'2019-07-04 15:47:11','2019-07-04 15:47:11'),(2,'2',2,1,1,333,'2019-07-04 15:48:12','2019-07-04 15:48:12'),(3,'3',3,1,1,123,'2019-07-04 15:48:27','2019-07-04 15:48:27'),(4,'4',4,1,1,444,'2019-07-04 15:48:34','2019-07-04 15:48:45'),(5,'5',1,1,0,111,'2019-07-04 15:48:58','2019-07-04 15:48:58'),(6,'6',2,1,0,555,'2019-07-04 15:49:09','2019-07-04 15:49:09'),(7,'7',3,1,0,451,'2019-07-04 15:49:18','2019-07-04 15:49:18'),(8,'8',4,1,0,1,'2019-07-04 15:49:26','2019-07-04 15:49:26'),(14,'9',1,1,1,100,NULL,NULL),(15,'9',1,1,1,100,NULL,NULL),(16,'9',1,1,1,100,NULL,NULL),(17,'9',1,1,1,100,NULL,NULL),(18,'9',1,1,1,100,NULL,NULL);
  /*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_06_25_045547_create_companies_table',1),(9,'2019_06_25_075659_create_vehicles_table',1),(10,'2019_06_25_110621_create_deposits_table',1),(11,'2019_06_26_043057_create_vehicle_types_table',1),(12,'2019_06_26_071858_create_toll__plazas_table',1),(13,'2019_06_26_080018_create_toll_type_table',1),(14,'2019_06_26_121439_create_tolls_table',1);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `oauth_access_tokens`
  --
  
  DROP TABLE IF EXISTS `oauth_access_tokens`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `client_id` int(10) unsigned NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_access_tokens_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `oauth_access_tokens`
  --
  
  LOCK TABLES `oauth_access_tokens` WRITE;
  /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
  /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `oauth_auth_codes`
  --
  
  DROP TABLE IF EXISTS `oauth_auth_codes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `client_id` int(10) unsigned NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `oauth_auth_codes`
  --
  
  LOCK TABLES `oauth_auth_codes` WRITE;
  /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
  /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `oauth_clients`
  --
  
  DROP TABLE IF EXISTS `oauth_clients`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `oauth_clients` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_clients_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `oauth_clients`
  --
  
  LOCK TABLES `oauth_clients` WRITE;
  /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
  /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `oauth_personal_access_clients`
  --
  
  DROP TABLE IF EXISTS `oauth_personal_access_clients`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `oauth_personal_access_clients` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `oauth_personal_access_clients`
  --
  
  LOCK TABLES `oauth_personal_access_clients` WRITE;
  /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
  /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `oauth_refresh_tokens`
  --
  
  DROP TABLE IF EXISTS `oauth_refresh_tokens`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `oauth_refresh_tokens`
  --
  
  LOCK TABLES `oauth_refresh_tokens` WRITE;
  /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
  /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `password_resets`
  --
  
  DROP TABLE IF EXISTS `password_resets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `password_resets`
  --
  
  LOCK TABLES `password_resets` WRITE;
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `toll__plazas`
  --
  
  DROP TABLE IF EXISTS `toll__plazas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `toll__plazas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `district` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `toll_type` tinyint(4) NOT NULL,
    `imei` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `toll_amount` decimal(5,2) DEFAULT NULL,
    `operator` varchar(255) 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `toll__plazas`
  --
  
  LOCK TABLES `toll__plazas` WRITE;
  /*!40000 ALTER TABLE `toll__plazas` DISABLE KEYS */;
  INSERT INTO `toll__plazas` VALUES (1,'Boanai plaza','bonani','dhaka',NULL,1,'123123','123',50.00,'tanvir','2019-07-04 15:50:16','2019-07-04 15:50:16'),(2,'nadda plaza','nadda','dhaka',NULL,2,'123122311','1231231',90.00,'anik','2019-07-04 15:50:50','2019-07-04 15:50:50');
  /*!40000 ALTER TABLE `toll__plazas` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `toll_type`
  --
  
  DROP TABLE IF EXISTS `toll_type`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `toll_type` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `toll_type`
  --
  
  LOCK TABLES `toll_type` WRITE;
  /*!40000 ALTER TABLE `toll_type` DISABLE KEYS */;
  /*!40000 ALTER TABLE `toll_type` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tolls`
  --
  
  DROP TABLE IF EXISTS `tolls`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tolls` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `toll_plaza_id` int(11) NOT NULL,
    `vehicle_id` int(11) NOT NULL,
    `toll_amount` decimal(5,2) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tolls`
  --
  
  LOCK TABLES `tolls` WRITE;
  /*!40000 ALTER TABLE `tolls` DISABLE KEYS */;
  /*!40000 ALTER TABLE `tolls` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (1,'tanvir alam','test@gmail.com',NULL,'$2y$10$BEKoWPkVsAypgZqZs..SOuSvk2esnrcunW6muUYTrOveC.Z3QsIbu',NULL,'2019-07-04 15:35:52','2019-07-04 15:35:52'),(2,'tanvir','alam@gmail.com',NULL,'$2y$10$0tZP8bjXyypQvLs7UpMa/.xyZ98mINSe2DCVXK95x2FLaeZ4a5y1K',NULL,'2019-08-05 12:03:50','2019-08-05 12:03:50');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vehicle_types`
  --
  
  DROP TABLE IF EXISTS `vehicle_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vehicle_types` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vehicle_type` varchar(255) 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `vehicle_types`
  --
  
  LOCK TABLES `vehicle_types` WRITE;
  /*!40000 ALTER TABLE `vehicle_types` DISABLE KEYS */;
  INSERT INTO `vehicle_types` VALUES (1,'Bus',NULL,NULL),(2,'Truck',NULL,NULL),(3,'Personal Car',NULL,NULL),(4,'Others',NULL,NULL);
  /*!40000 ALTER TABLE `vehicle_types` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vehicles`
  --
  
  DROP TABLE IF EXISTS `vehicles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vehicles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vehicle_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_id` int(11) NOT NULL,
    `licence_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `engin_cc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `engin_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vehicle_type` tinyint(4) NOT NULL,
    `qr_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_permitted` tinyint(1) NOT NULL,
    `is_delete` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `vehicles`
  --
  
  LOCK TABLES `vehicles` WRITE;
  /*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
  INSERT INTO `vehicles` VALUES (1,'Toyota bus',1,'123','123','123',1,'345144297171626741479673336557232844723735',1,NULL,'2019-07-04 15:43:42','2019-07-04 15:45:19'),(2,'BMW Truck',2,'123','123','123',2,'237684035605807887215454907883818778734318',1,NULL,'2019-07-04 15:44:16','2019-07-04 15:45:36'),(3,'Porsche Car',3,'123','123','123',3,'134631074783691224332424991094505248168088',1,NULL,'2019-07-04 15:44:28','2019-07-04 15:45:49'),(4,'Other Porsche',3,'1233','1234','1234',4,'285998945307138722574568958261395009166966',1,NULL,'2019-07-04 15:44:43','2019-07-04 15:46:09');
  /*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2019-08-07  2:10:28
  