text: -- MySQL dump 10.17  Distrib 10.3.16-MariaDB, for Win64 (AMD64)
  --
  -- Host: localhost    Database: hotels
  -- ------------------------------------------------------
  -- Server version	10.3.16-MariaDB
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  /*!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 `admin_password_resets`
  --
  
  DROP TABLE IF EXISTS `admin_password_resets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `admin_password_resets_email_index` (`email`),
    KEY `admin_password_resets_token_index` (`token`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admin_password_resets`
  --
  
  LOCK TABLES `admin_password_resets` WRITE;
  /*!40000 ALTER TABLE `admin_password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `admin_password_resets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `admins`
  --
  
  DROP TABLE IF EXISTS `admins`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admins` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `active` tinyint(1) NOT NULL DEFAULT 0,
    `admin` tinyint(1) NOT NULL DEFAULT 0,
    `avatar` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default.jpg',
    `about` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `designation` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT 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 `admins_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `admins`
  --
  
  LOCK TABLES `admins` WRITE;
  /*!40000 ALTER TABLE `admins` DISABLE KEYS */;
  INSERT INTO `admins` VALUES (1,'Khadga Shretstha','admin@admin.com','$2y$10$fUdPjOmYtQYI6rMnSVp3seCRnQfWzKWEZQdKByCeHDfowxvkHxiMa',1,0,'default.jpg',NULL,NULL,'5PR0RB2exeQxPQKqBmVqM7Ty5w54Kyt6AdzX3YtPmimI1ftl5XE074TDcpl3','2020-10-07 13:47:31','2020-10-07 13:47:31');
  /*!40000 ALTER TABLE `admins` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `amenities`
  --
  
  DROP TABLE IF EXISTS `amenities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `amenities` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'icon.png',
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `created_by` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
    `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 `amenities`
  --
  
  LOCK TABLES `amenities` WRITE;
  /*!40000 ALTER TABLE `amenities` DISABLE KEYS */;
  INSERT INTO `amenities` VALUES (2,'AdminGPON','admingpon','1602085638.png','active','admin','2020-10-07 15:47:18','2020-10-07 15:47:18');
  /*!40000 ALTER TABLE `amenities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `amenity_vendor`
  --
  
  DROP TABLE IF EXISTS `amenity_vendor`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `amenity_vendor` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `amenity_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `amenity_vendor_vendor_id_foreign` (`vendor_id`),
    KEY `amenity_vendor_amenity_id_foreign` (`amenity_id`),
    CONSTRAINT `amenity_vendor_amenity_id_foreign` FOREIGN KEY (`amenity_id`) REFERENCES `amenities` (`id`) ON DELETE CASCADE,
    CONSTRAINT `amenity_vendor_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `amenity_vendor`
  --
  
  LOCK TABLES `amenity_vendor` WRITE;
  /*!40000 ALTER TABLE `amenity_vendor` DISABLE KEYS */;
  INSERT INTO `amenity_vendor` VALUES (1,6,2,NULL,NULL),(3,18,2,NULL,NULL),(4,20,2,NULL,NULL);
  /*!40000 ALTER TABLE `amenity_vendor` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bed_types`
  --
  
  DROP TABLE IF EXISTS `bed_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bed_types` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'icon.png',
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bed_types`
  --
  
  LOCK TABLES `bed_types` WRITE;
  /*!40000 ALTER TABLE `bed_types` DISABLE KEYS */;
  INSERT INTO `bed_types` VALUES (1,'asfsadfsad','asfsadfsad','1602087351.png','active','2020-10-07 16:15:52','2020-10-07 16:15:52');
  /*!40000 ALTER TABLE `bed_types` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `beds`
  --
  
  DROP TABLE IF EXISTS `beds`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `beds` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `room_id` int(10) unsigned NOT NULL,
    `bed_number` int(10) unsigned NOT NULL,
    `adult` int(11) NOT NULL DEFAULT 1,
    `child` int(11) NOT NULL DEFAULT 0,
    `bed_type_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `beds_room_id_foreign` (`room_id`),
    CONSTRAINT `beds_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `beds`
  --
  
  LOCK TABLES `beds` WRITE;
  /*!40000 ALTER TABLE `beds` DISABLE KEYS */;
  INSERT INTO `beds` VALUES (1,1,4,2,4,1,'2020-10-07 16:17:54','2020-10-07 16:17:54');
  /*!40000 ALTER TABLE `beds` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `booking_child_rooms`
  --
  
  DROP TABLE IF EXISTS `booking_child_rooms`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `booking_child_rooms` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `booking_id` int(10) unsigned NOT NULL,
    `child_rooms_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `booking_child_rooms_booking_id_foreign` (`booking_id`),
    KEY `booking_child_rooms_child_rooms_id_foreign` (`child_rooms_id`),
    CONSTRAINT `booking_child_rooms_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`),
    CONSTRAINT `booking_child_rooms_child_rooms_id_foreign` FOREIGN KEY (`child_rooms_id`) REFERENCES `child_rooms` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `booking_child_rooms`
  --
  
  LOCK TABLES `booking_child_rooms` WRITE;
  /*!40000 ALTER TABLE `booking_child_rooms` DISABLE KEYS */;
  /*!40000 ALTER TABLE `booking_child_rooms` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `booking_meals`
  --
  
  DROP TABLE IF EXISTS `booking_meals`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `booking_meals` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `booking_id` int(11) NOT NULL,
    `meal_id` int(11) NOT NULL,
    `meal_value` int(11) NOT NULL,
    `meal_price` double NOT NULL,
    `over_all` text 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 `booking_meals`
  --
  
  LOCK TABLES `booking_meals` WRITE;
  /*!40000 ALTER TABLE `booking_meals` DISABLE KEYS */;
  /*!40000 ALTER TABLE `booking_meals` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `booking_payments`
  --
  
  DROP TABLE IF EXISTS `booking_payments`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `booking_payments` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `booking_id` int(10) unsigned NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pay_at_hotel',
    `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `voucher` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `overall` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `booking_payments`
  --
  
  LOCK TABLES `booking_payments` WRITE;
  /*!40000 ALTER TABLE `booking_payments` DISABLE KEYS */;
  INSERT INTO `booking_payments` VALUES (1,8,'online',NULL,NULL,NULL,'test','1','2020-11-02 08:26:53','2020-11-02 08:26:53'),(2,9,'online',NULL,NULL,NULL,'test','1','2020-11-02 08:27:25','2020-11-02 08:27:25'),(3,10,'online',NULL,NULL,NULL,'test','1','2020-11-02 08:28:17','2020-11-02 08:28:17'),(4,11,'online','khalti','SK7XvsZFV8j5552h7dESyY','YLn8bjiM5ccuBpUdPaKXdQ','test','1','2020-11-02 08:43:15','2020-11-02 08:43:15'),(5,12,'online','khalti','DJUgnyy2d2GjNn4fUHaGUU','kmiSJXnSPFkfKd4m7XUXQZ','test','1','2020-11-02 08:51:02','2020-11-02 08:51:02'),(6,13,'online','khalti','h245byYT8yHyDBk6zCvcri','WH5NYmme7udX7wTgDdfbX9','test','1','2020-11-04 06:59:12','2020-11-04 06:59:12'),(7,15,'online','khalti','LDzGYJ6WSZXA52qSiw9TeA','GSJvsRDaSymrfkxPJDHCni','test','1','2020-11-04 07:13:23','2020-11-04 07:13:23'),(8,16,'online','khalti','5LAH9piBygNRarmAhbv7DT','suTPVnrfVhj6QXPVoLyseB','test','1','2020-11-04 07:21:33','2020-11-04 07:21:33'),(9,17,'online','khalti','A8bQpU3WNaYZimEfm3fULj','ADvpEmptHkFyUGUo5LwZ2G','test','1','2020-11-04 07:38:15','2020-11-04 07:38:15'),(10,18,'online','khalti','5FiyicyFCx7xhLTwTtxjte','Rxi52U5D8kNcVihMLwwuXn','test','1','2020-11-04 07:50:53','2020-11-04 07:50:53'),(11,19,'online','khalti','3vFJXi6xARh6heU7jvNeNW','si846x7Wpq7NQiDQVg9wZE','test','1','2020-12-07 10:31:01','2020-12-07 10:31:01'),(12,20,'online','khalti','NwfwLTevnCFt8rLU2yVagK','YunjZrjA3ZUPkx6WNWVEMF','test','1','2020-12-07 10:46:45','2020-12-07 10:46:45'),(13,21,'online','Khalti','3kaWMryi2eT9RW35EJaGaN','mx7vspSmZmqRC6AZE9TvkZ','{\"idx\":\"mx7vspSmZmqRC6AZE9TvkZ\",\"token\":\"3kaWMryi2eT9RW35EJaGaN\",\"amount\":10900,\"mobile\":\"98XXXXX665\",\"product_identity\":\"2\",\"product_name\":\"fsda\",\"product_url\":\"http://localhost:8000/service/chhatraman-shrestha/fsda\",\"widget_id\":\"khalti-widget-1610918715352\"}','1','2021-01-17 21:37:35','2021-01-17 21:37:35'),(14,22,'online','Khalti','3kaWMryi2eT9RW35EJaGaN','mx7vspSmZmqRC6AZE9TvkZ','{\"idx\":\"mx7vspSmZmqRC6AZE9TvkZ\",\"token\":\"3kaWMryi2eT9RW35EJaGaN\",\"amount\":10900,\"mobile\":\"98XXXXX665\",\"product_identity\":\"2\",\"product_name\":\"fsda\",\"product_url\":\"http://localhost:8000/service/chhatraman-shrestha/fsda\",\"widget_id\":\"khalti-widget-1610918715352\"}','1','2021-01-17 21:41:59','2021-01-17 21:41:59'),(15,23,'online','Khalti','mfWX5UuzPv2uWvvTB9o2Wk','dpLhHGVKtdQYPCXR3vHXKY','{\"idx\":\"dpLhHGVKtdQYPCXR3vHXKY\",\"token\":\"mfWX5UuzPv2uWvvTB9o2Wk\",\"amount\":12300,\"mobile\":\"98XXXXX665\",\"product_identity\":\"6\",\"product_name\":\"aalu aalu\",\"product_url\":\"http://192.168.254.3:8000/service/rose/aalu-aalu\",\"widget_id\":\"khalti-widget-1610924023690\"}','1','2021-01-17 22:54:49','2021-01-17 22:54:49'),(16,28,'online','Khalti','2zKdxypTtfgZqRMr5FtbVa','t7pzLvg94K3VoZvov5Ku6K','{\"idx\":\"t7pzLvg94K3VoZvov5Ku6K\",\"token\":\"2zKdxypTtfgZqRMr5FtbVa\",\"amount\":12300,\"mobile\":\"98XXXXX665\",\"product_identity\":\"6\",\"product_name\":\"Advance course (45Days)\",\"product_url\":\"http://localhost:8000/service/rose/aalu-aalu\",\"widget_id\":\"khalti-widget-1611379249208\"}','1','2021-01-23 05:22:52','2021-01-23 05:22:52'),(17,29,'online','Khalti','57B8ycJdTRnhQawvCSQauH','DDnPVNTMT6K4sbuGUB5fTB','{\"idx\":\"DDnPVNTMT6K4sbuGUB5fTB\",\"token\":\"57B8ycJdTRnhQawvCSQauH\",\"amount\":12300,\"mobile\":\"98XXXXX665\",\"product_identity\":\"6\",\"product_name\":\"Advance course (45Days)\",\"product_url\":\"http://192.168.254.3:8000/service/rose/aalu-aalu\",\"widget_id\":\"khalti-widget-1611529395314\"}','1','2021-01-24 23:04:01','2021-01-24 23:04:01'),(18,30,'online','Khalti','DPMVAW3kkoQ6VCGp3fUAUG','bhvoqbh33adNibgQTm3GqS','{\"idx\":\"bhvoqbh33adNibgQTm3GqS\",\"token\":\"DPMVAW3kkoQ6VCGp3fUAUG\",\"amount\":85000,\"mobile\":\"98XXXXX665\",\"product_identity\":\"18\",\"product_name\":\"Professional\",\"product_url\":\"http://localhost:8000/service/raj/professional-1\",\"widget_id\":\"khalti-widget-1611529558448\"}','1','2021-01-24 23:06:33','2021-01-24 23:06:33'),(19,31,'online','Khalti','DPMVAW3kkoQ6VCGp3fUAUG','bhvoqbh33adNibgQTm3GqS','{\"idx\":\"bhvoqbh33adNibgQTm3GqS\",\"token\":\"DPMVAW3kkoQ6VCGp3fUAUG\",\"amount\":85000,\"mobile\":\"98XXXXX665\",\"product_identity\":\"18\",\"product_name\":\"Professional\",\"product_url\":\"http://localhost:8000/service/raj/professional-1\",\"widget_id\":\"khalti-widget-1611529558448\"}','1','2021-01-24 23:07:16','2021-01-24 23:07:16'),(20,32,'online','Khalti','8HBiVFvxfpVyzvWc8Cr28F','ZCcPrQcwQkVEisQMuDgsHi','{\"idx\":\"ZCcPrQcwQkVEisQMuDgsHi\",\"token\":\"8HBiVFvxfpVyzvWc8Cr28F\",\"amount\":12300,\"mobile\":\"98XXXXX665\",\"product_identity\":\"6\",\"product_name\":\"Advance course (45Days)\",\"product_url\":\"http://192.168.100.175:8000/service/rose/aalu-aalu\",\"widget_id\":\"khalti-widget-1612687833472\"}','1','2021-02-07 08:58:16','2021-02-07 08:58:16'),(21,34,'online','Khalti','xmYySqQ4pYz7ZwFRioEwwa','2PxomcyyRRbTiqLoqgN8xm','{\"idx\":\"2PxomcyyRRbTiqLoqgN8xm\",\"token\":\"xmYySqQ4pYz7ZwFRioEwwa\",\"amount\":12300,\"mobile\":\"98XXXXX665\",\"product_identity\":\"6\",\"product_name\":\"Advance course (45Days)\",\"product_url\":\"http://192.168.100.175:8000/service/rose/aalu-aalu\",\"widget_id\":\"khalti-widget-1614751383287\"}','1','2021-03-03 06:03:59','2021-03-03 06:03:59');
  /*!40000 ALTER TABLE `booking_payments` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bookings`
  --
  
  DROP TABLE IF EXISTS `bookings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bookings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `adult` int(11) DEFAULT NULL,
    `children` int(11) DEFAULT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `booking_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `num_rooms` int(11) NOT NULL,
    `room_id` int(10) unsigned NOT NULL,
    `vendor_id` int(10) unsigned NOT NULL,
    `check_in_time` date DEFAULT NULL,
    `check_out_time` date DEFAULT NULL,
    `coupon_applied` tinyint(1) NOT NULL DEFAULT 0,
    `coupon_id` int(11) DEFAULT NULL,
    `approved_time` datetime DEFAULT NULL,
    `booking_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
    `new_price` double(8,2) DEFAULT NULL,
    `old_price` double(8,2) DEFAULT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payment_addition_info` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payment_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bookings`
  --
  
  LOCK TABLES `bookings` WRITE;
  /*!40000 ALTER TABLE `bookings` DISABLE KEYS */;
  INSERT INTO `bookings` VALUES (13,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BK3QEM7B20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'paid','2020-11-04 06:59:12','2020-11-04 08:13:58'),(14,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BK2B4UDP20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'pending',123.00,NULL,'1',NULL,'paid','2020-11-04 07:08:54','2020-11-04 09:17:21'),(15,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BKL9TORX20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'paid','2020-11-04 07:13:23','2020-11-04 07:13:23'),(16,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BK6HSMZB20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'paid','2020-11-04 07:21:33','2020-11-04 07:21:33'),(17,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BKESILGG20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'paid','2020-11-04 07:38:15','2020-11-04 07:41:04'),(18,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BKH2VDWW20',1,6,18,'2020-11-04',NULL,0,NULL,NULL,'confirmed',123.00,NULL,'2',NULL,'paid','2020-11-04 07:50:53','2020-11-04 10:03:05'),(19,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BKOAKDBM20',1,18,20,'2020-12-07',NULL,0,NULL,NULL,'completed',850.00,NULL,'2',NULL,'paid','2020-12-07 10:31:01','2020-12-07 10:33:23'),(20,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',1,0,2,'BKW3MDEG20',1,18,20,'2020-12-07',NULL,0,NULL,NULL,'completed',850.00,NULL,'2',NULL,'paid','2020-12-07 10:46:44','2021-02-09 02:46:34'),(21,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKDYIDHF21',0,0,6,'2021-01-18',NULL,0,NULL,NULL,'pending',109.00,NULL,'2',NULL,'unpaid','2021-01-17 21:37:35','2021-01-17 21:37:35'),(22,'chhatraman','shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKAWW0QQ21',0,2,6,'2021-01-18',NULL,0,NULL,NULL,'pending',109.00,NULL,'2',NULL,'unpaid','2021-01-17 21:41:59','2021-01-17 21:41:59'),(23,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKYVE2AX21',0,6,18,'2021-01-19',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'unpaid','2021-01-17 22:54:49','2021-01-17 22:54:49'),(24,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKR63LR821',0,7,19,'2021-01-19',NULL,0,NULL,NULL,'pending',7200.00,NULL,'1',NULL,'unpaid','2021-01-19 07:38:47','2021-01-19 07:38:47'),(25,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BK9PZ5D921',0,7,19,'2021-01-19',NULL,0,NULL,NULL,'pending',7200.00,NULL,'1',NULL,'unpaid','2021-01-19 07:41:34','2021-01-19 07:41:34'),(26,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BK5ZXQ9Q21',0,7,19,'2021-01-19',NULL,0,NULL,NULL,'pending',7200.00,NULL,'1',NULL,'unpaid','2021-01-19 07:42:32','2021-01-19 07:42:32'),(27,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKVJSQ1K21',0,1,6,'2021-01-22',NULL,0,NULL,NULL,'pending',2222.00,NULL,'1',NULL,'unpaid','2021-01-21 03:52:12','2021-01-21 03:52:12'),(28,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BK6MFRO921',0,6,18,'2021-01-22',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'unpaid','2021-01-23 05:22:51','2021-01-23 05:22:51'),(29,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BK1WXVM621',0,6,18,'2021-01-25',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'unpaid','2021-01-24 23:04:01','2021-01-24 23:04:01'),(30,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BK8CXTVD21',0,18,20,'2021-01-25',NULL,0,NULL,NULL,'pending',850.00,NULL,'2',NULL,'unpaid','2021-01-24 23:06:33','2021-01-24 23:06:33'),(31,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKUMM14821',0,18,20,'2021-01-25',NULL,0,NULL,NULL,'pending',850.00,NULL,'2',NULL,'unpaid','2021-01-24 23:07:15','2021-01-24 23:07:15'),(32,'krishna','rai','new@need.com','9829306787',NULL,NULL,19,'BK06K11321',0,6,18,'2021-02-07',NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'unpaid','2021-02-07 08:58:16','2021-02-07 08:58:16'),(33,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKZ5IDT121',0,1,6,NULL,NULL,0,NULL,NULL,'pending',2222.00,NULL,'1',NULL,'unpaid','2021-02-09 07:09:25','2021-02-09 07:09:25'),(34,'Chhatraman','Shrestha','cms111000111@gmail.com','9800916365',NULL,NULL,2,'BKXMNKP221',0,6,18,NULL,NULL,0,NULL,NULL,'pending',123.00,NULL,'2',NULL,'unpaid','2021-03-03 06:03:59','2021-03-03 06:03:59');
  /*!40000 ALTER TABLE `bookings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `categories`
  --
  
  DROP TABLE IF EXISTS `categories`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `categories` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `categories_slug_unique` (`slug`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `categories`
  --
  
  LOCK TABLES `categories` WRITE;
  /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
  INSERT INTO `categories` VALUES (3,'Driving center','driving-center','asdfasdfasd','active','2020-10-07 15:49:51','2020-11-04 06:49:51');
  /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `child_rooms`
  --
  
  DROP TABLE IF EXISTS `child_rooms`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `child_rooms` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `room_id` int(10) unsigned NOT NULL,
    `room_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unavailable',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `child_rooms_room_id_foreign` (`room_id`),
    CONSTRAINT `child_rooms_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `child_rooms`
  --
  
  LOCK TABLES `child_rooms` WRITE;
  /*!40000 ALTER TABLE `child_rooms` DISABLE KEYS */;
  INSERT INTO `child_rooms` VALUES (1,1,'234','active','2020-10-07 16:17:54','2020-10-07 16:17:54');
  /*!40000 ALTER TABLE `child_rooms` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cities`
  --
  
  DROP TABLE IF EXISTS `cities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `cities` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `state_id` int(11) NOT NULL,
    `name` varchar(191) 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 `cities`
  --
  
  LOCK TABLES `cities` WRITE;
  /*!40000 ALTER TABLE `cities` DISABLE KEYS */;
  INSERT INTO `cities` VALUES (1,1,'Biratnagar','2020-10-07 16:34:11','2020-10-07 16:34:11'),(2,1,'Kathmandu','2020-12-17 20:15:30','2020-12-17 20:15:30');
  /*!40000 ALTER TABLE `cities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `collection_vendors`
  --
  
  DROP TABLE IF EXISTS `collection_vendors`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `collection_vendors` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `collection_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `collection_vendors_vendor_id_foreign` (`vendor_id`),
    KEY `collection_vendors_collection_id_foreign` (`collection_id`),
    CONSTRAINT `collection_vendors_collection_id_foreign` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`) ON DELETE CASCADE,
    CONSTRAINT `collection_vendors_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `collection_vendors`
  --
  
  LOCK TABLES `collection_vendors` WRITE;
  /*!40000 ALTER TABLE `collection_vendors` DISABLE KEYS */;
  /*!40000 ALTER TABLE `collection_vendors` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `collections`
  --
  
  DROP TABLE IF EXISTS `collections`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `collections` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image.jpg',
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(1) NOT NULL DEFAULT 0,
    `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 `collections`
  --
  
  LOCK TABLES `collections` WRITE;
  /*!40000 ALTER TABLE `collections` DISABLE KEYS */;
  INSERT INTO `collections` VALUES (2,'Biratnagar Special','biratnagar-special','1608230641.png','this is the best collection you can find',1,'2020-12-17 18:44:02','2020-12-17 18:44:02'),(3,'Another Collection','another-collection','1608233220.png','we also love this collection',1,'2020-12-17 19:27:00','2020-12-17 19:27:00');
  /*!40000 ALTER TABLE `collections` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `countries`
  --
  
  DROP TABLE IF EXISTS `countries`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `countries` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sortname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phonecode` varchar(191) 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `countries`
  --
  
  LOCK TABLES `countries` WRITE;
  /*!40000 ALTER TABLE `countries` DISABLE KEYS */;
  INSERT INTO `countries` VALUES (1,'Nepal','np','977','2020-10-07 16:31:16','2020-10-07 16:31:16');
  /*!40000 ALTER TABLE `countries` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `coupon_settings`
  --
  
  DROP TABLE IF EXISTS `coupon_settings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `coupon_settings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `coupon_id` int(10) unsigned NOT NULL,
    `discount_type` int(11) NOT NULL,
    `discount_value` int(11) DEFAULT NULL,
    `issued_number_coupon` int(11) DEFAULT NULL,
    `minimum_order_value` int(11) DEFAULT NULL,
    `discount_percent` decimal(5,2) DEFAULT NULL,
    `maximum_discount_value` decimal(10,2) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `coupon_settings`
  --
  
  LOCK TABLES `coupon_settings` WRITE;
  /*!40000 ALTER TABLE `coupon_settings` DISABLE KEYS */;
  /*!40000 ALTER TABLE `coupon_settings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `coupons`
  --
  
  DROP TABLE IF EXISTS `coupons`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `coupons` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendorid` int(11) NOT NULL DEFAULT 0,
    `coupon_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `start_time` datetime DEFAULT NULL,
    `end_time` datetime DEFAULT NULL,
    `coupon_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(1) NOT NULL DEFAULT 0,
    `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 `coupons`
  --
  
  LOCK TABLES `coupons` WRITE;
  /*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
  /*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `enquiries`
  --
  
  DROP TABLE IF EXISTS `enquiries`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `enquiries` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `seen` tinyint(1) NOT NULL DEFAULT 0,
    `seen_at` datetime DEFAULT NULL,
    `seen_by` int(11) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `enquiries`
  --
  
  LOCK TABLES `enquiries` WRITE;
  /*!40000 ALTER TABLE `enquiries` DISABLE KEYS */;
  /*!40000 ALTER TABLE `enquiries` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `favourites`
  --
  
  DROP TABLE IF EXISTS `favourites`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `favourites` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_user_id` int(10) unsigned NOT NULL,
    `vendor_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `favourites_vendor_id_foreign` (`vendor_id`),
    KEY `favourites_vendor_user_id_foreign` (`vendor_user_id`),
    CONSTRAINT `favourites_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE,
    CONSTRAINT `favourites_vendor_user_id_foreign` FOREIGN KEY (`vendor_user_id`) REFERENCES `vendor_users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `favourites`
  --
  
  LOCK TABLES `favourites` WRITE;
  /*!40000 ALTER TABLE `favourites` DISABLE KEYS */;
  INSERT INTO `favourites` VALUES (2,2,6,'2020-10-25 03:03:55','2020-10-25 03:03:55');
  /*!40000 ALTER TABLE `favourites` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `galleries`
  --
  
  DROP TABLE IF EXISTS `galleries`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `galleries` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vendor_id` int(10) unsigned NOT NULL,
    `caption` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `galleries_vendor_id_foreign` (`vendor_id`),
    CONSTRAINT `galleries_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `galleries`
  --
  
  LOCK TABLES `galleries` WRITE;
  /*!40000 ALTER TABLE `galleries` DISABLE KEYS */;
  /*!40000 ALTER TABLE `galleries` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `locations`
  --
  
  DROP TABLE IF EXISTS `locations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `locations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city_id` int(11) DEFAULT NULL,
    `vendor_id` int(11) NOT NULL,
    `lat` double DEFAULT NULL,
    `lng` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `locations`
  --
  
  LOCK TABLES `locations` WRITE;
  /*!40000 ALTER TABLE `locations` DISABLE KEYS */;
  INSERT INTO `locations` VALUES (1,'biratnagar',1,1,NULL,NULL,'2020-10-07 13:54:57','2020-10-07 13:54:57'),(2,'biratnagar',1,2,NULL,NULL,'2020-10-07 13:58:04','2020-10-07 13:58:04'),(3,'biratnagar',1,3,NULL,NULL,'2020-10-07 14:56:49','2020-10-07 14:56:49'),(4,'biratnagar',1,4,NULL,NULL,'2020-10-07 14:58:47','2020-10-07 14:58:47'),(5,'biratnagar',1,6,NULL,NULL,'2020-10-07 16:01:26','2020-10-07 16:01:26'),(6,NULL,NULL,7,NULL,NULL,'2020-11-01 06:52:15','2020-11-01 06:52:15'),(7,NULL,NULL,8,NULL,NULL,'2020-11-02 05:25:59','2020-11-02 05:25:59'),(8,NULL,NULL,9,NULL,NULL,'2020-11-03 08:19:40','2020-11-03 08:19:40'),(9,NULL,NULL,10,NULL,NULL,'2020-11-03 08:21:05','2020-11-03 08:21:05'),(10,NULL,NULL,11,NULL,NULL,'2020-11-03 08:22:00','2020-11-03 08:22:00'),(11,NULL,NULL,12,NULL,NULL,'2020-11-03 09:19:39','2020-11-03 09:19:39'),(12,NULL,NULL,13,NULL,NULL,'2020-11-03 09:29:03','2020-11-03 09:29:03'),(13,NULL,NULL,14,NULL,NULL,'2020-11-03 09:29:31','2020-11-03 09:29:31'),(14,NULL,NULL,15,NULL,NULL,'2020-11-03 09:44:47','2020-11-03 09:44:47'),(15,NULL,NULL,16,NULL,NULL,'2020-11-03 12:13:01','2020-11-03 12:13:01'),(16,NULL,NULL,17,NULL,NULL,'2020-11-03 12:15:03','2020-11-03 12:15:03'),(17,'biratnagar',1,18,26.459159883753316,87.28130820642092,'2020-11-03 12:39:43','2020-11-04 10:09:50'),(18,NULL,NULL,19,NULL,NULL,'2020-12-06 07:44:35','2020-12-06 07:44:35'),(19,'biratnagar',1,20,26.452320910751958,87.2751283968506,'2020-12-06 08:13:45','2020-12-06 09:27:07'),(20,NULL,NULL,21,NULL,NULL,'2021-01-12 07:51:15','2021-01-12 07:51:15'),(21,NULL,NULL,22,NULL,NULL,'2021-01-12 07:56:21','2021-01-12 07:56:21'),(22,NULL,NULL,23,NULL,NULL,'2021-01-24 05:38:41','2021-01-24 05:38:41'),(23,'Munalpath',2,24,0,0,'2021-01-24 11:48:21','2021-01-24 21:23:21'),(24,NULL,NULL,25,NULL,NULL,'2021-02-07 08:40:06','2021-02-07 08:40:06'),(25,NULL,NULL,26,0,0,'2021-02-18 08:03:41','2021-02-18 08:03:41');
  /*!40000 ALTER TABLE `locations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `meals`
  --
  
  DROP TABLE IF EXISTS `meals`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `meals` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` double NOT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `meals_vendor_id_foreign` (`vendor_id`),
    CONSTRAINT `meals_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `meals`
  --
  
  LOCK TABLES `meals` WRITE;
  /*!40000 ALTER TABLE `meals` DISABLE KEYS */;
  /*!40000 ALTER TABLE `meals` 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=57 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,'2010_10_28_052249_create_roles_table',1),(2,'2014_10_12_000000_create_users_table',1),(3,'2014_10_12_100000_create_categories_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2016_06_01_000001_create_oauth_auth_codes_table',1),(6,'2016_06_01_000002_create_oauth_access_tokens_table',1),(7,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(8,'2016_06_01_000004_create_oauth_clients_table',1),(9,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(10,'2017_01_31_102739_create_bookings_table',1),(11,'2018_10_27_061141_create_locations_table',1),(12,'2018_10_29_050311_create_vendor_table',1),(13,'2018_10_29_112807_create_amenities_table',1),(14,'2018_10_31_044120_create_amenity_vendor_table',1),(15,'2018_10_31_065754_create_galleries_table',1),(16,'2018_11_01_051433_create_policies_table',1),(17,'2018_11_02_061127_create_admins_table',1),(18,'2018_11_16_073623_create_vendor_users_table',1),(19,'2018_11_20_100722_create_room_types_table',1),(20,'2018_11_20_100933_create_bed_types_table',1),(21,'2018_11_23_062431_create_rooms_table',1),(22,'2018_11_23_072430_create_room_amentiys_table',1),(23,'2018_11_23_072736_create_room_photos_table',1),(24,'2018_11_25_104848_create_room_policies_table',1),(25,'2018_11_30_073219_create_beds_table',1),(26,'2018_12_09_112538_create_reviews_table',1),(27,'2018_12_14_095626_create_favourites_table',1),(28,'2018_12_15_010729_create_tourism_areas_table',1),(29,'2018_12_15_084020_create_enquiries_table',1),(30,'2018_12_16_022827_create_meals_table',1),(31,'2019_01_22_102028_create_countries_table',1),(32,'2019_01_22_102801_create_states_table',1),(33,'2019_01_22_102811_create_cities_table',1),(34,'2019_01_25_080346_create_coupons_table',1),(35,'2019_01_25_081247_create_coupon_settings_table',1),(36,'2019_01_25_102050_create_admin_password_resets_table',1),(37,'2019_02_05_064103_create_collections_table',1),(38,'2019_02_05_064240_create_collection_vendors_table',1),(39,'2019_02_06_120203_create_booking_payments_table',1),(40,'2019_02_24_052538_create_booking_meals_table',1),(41,'2019_02_25_090432_create_user_coupons_table',1),(42,'2019_02_28_094123_create_notifications_table',1),(43,'2019_03_05_110623_create_payment_methods_table',1),(44,'2019_03_06_104449_create_child_rooms_table',1),(45,'2019_03_12_061306_create_booking_child_rooms_table',1),(46,'2019_03_13_090812_create_vendor_accounts_table',1),(47,'2020_11_01_113312_add_nullable_to_bookings_table',2),(50,'2020_11_03_122732_add_step_to_vendors_table',3),(51,'2020_11_03_130704_create_s_m_s_mocks_table',3),(52,'2020_11_11_141230_create_user_references_table',4),(53,'2020_11_17_100537_create_sliders_table',5),(54,'2021_02_09_123615_alter_checkin_time_to_bookings_table',5),(56,'2021_02_09_141244_create_vendor_requests_table',6);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `notifications`
  --
  
  DROP TABLE IF EXISTS `notifications`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` bigint(20) unsigned NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `notifications`
  --
  
  LOCK TABLES `notifications` WRITE;
  /*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
  INSERT INTO `notifications` VALUES ('1094e956-a99b-4ab5-b6f1-8cc094c13211','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:16:30','2020-11-04 08:16:30'),('13808b0f-bff1-4925-907e-4e92cf69087b','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:16:15','2020-11-04 08:16:15'),('15ab001b-355b-4704-b2df-ea584a171075','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:06:46.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:08:35','2020-11-04 08:08:35'),('17f36d81-a3cc-4e1d-a772-9997d341de08','App\\Notifications\\Vendor\\VendorNoti','App\\User',21,'{\"title\":\"aalu aalu has booked your room \",\"detail\":\"aalu aalu has booked your room at 2020-11-02 14:13:17\",\"link\":\"\"}',NULL,'2020-11-02 08:28:17','2020-11-02 08:28:17'),('1abb3289-5336-431f-a38b-52dba014b795','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:11:29.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:11:29','2020-11-04 08:11:29'),('1fa689a3-cdbe-4561-8499-bb44e373e0c0','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:01','2020-11-04 08:14:01'),('23ceb13d-4ab7-4d13-b77d-389f6acae6a0','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:10','2020-11-04 08:14:10'),('292acd96-9495-47d0-9007-39c180482dd5','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-02 14:11:53\",\"link\":\"\"}',NULL,'2020-11-02 08:26:55','2020-11-02 08:26:55'),('2ac4a119-3fa5-4074-b6b3-77c772d76a1b','App\\Notifications\\VendorUser\\UserNoti','App\\User',12,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Govean Driving Center has confirmed your booking for Govean Driving Center(Back Cover)\",\"link\":\"http:\\/\\/192.168.1.103:8000\\/user\\/bookings\\/show\\/BK765L7X20\",\"data\":{\"id\":2,\"first_name\":\"Komal\",\"last_name\":\"Shrestha\",\"email\":\"hirohamta@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":4,\"booking_id\":\"BK765L7X20\",\"num_rooms\":1,\"room_id\":4,\"vendor_id\":7,\"check_in_time\":\"2020-11-25\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":2000,\"old_price\":null,\"type\":\"1\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-01 12:47:59\",\"updated_at\":\"2020-11-01 12:49:09\",\"vendor\":{\"id\":7,\"user_id\":13,\"star\":null,\"name\":\"Govean Driving Center\",\"slug\":\"govean-driving-center\",\"phone_number\":\"9819365664\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":null,\"logo\":\"logo.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":null,\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"inactive\",\"verified_time\":null,\"created_at\":\"2020-11-01 12:37:15\",\"updated_at\":\"2020-11-01 12:37:15\"},\"room\":{\"id\":4,\"name\":\"Back Cover\",\"roomtype_id\":2,\"slug\":\"back-cover\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":2000,\"discount\":2,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>Watch your back and forth with you and i know if you need anything else from me please let<\\/p>\",\"vendor_id\":7,\"created_at\":\"2020-11-01 12:42:31\",\"updated_at\":\"2020-11-01 12:45:34\"},\"vendoruser\":{\"id\":4,\"user_id\":12,\"fname\":\"Komal\",\"lname\":\"Shrestha\",\"slug\":\"komal\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":null,\"city_id\":null,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-11-01 12:36:06\",\"updated_at\":\"2020-11-01 12:36:06\",\"user\":{\"id\":12,\"provider\":null,\"provider_id\":null,\"email\":\"hirohamta@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-11-01 12:36:06\",\"updated_at\":\"2020-11-01 12:37:58\"}}}}',NULL,'2020-11-01 07:04:09','2020-11-01 07:04:09'),('2c8b0ee3-ce59-4644-9823-b6dfd711c07d','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Raja has confirmed your booking for Raja(Professional)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/booking\\/single\\/BKW3MDEG20\",\"data\":{\"id\":20,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKW3MDEG20\",\"num_rooms\":1,\"room_id\":18,\"vendor_id\":20,\"check_in_time\":\"2020-12-07\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":850,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-12-07T10:46:44.000000Z\",\"updated_at\":\"2021-02-09T02:46:20.000000Z\",\"vendor\":{\"id\":20,\"user_id\":37,\"star\":1,\"name\":\"Raja\",\"slug\":\"raj\",\"phone_number\":\"9800000000\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":437,\"logo\":\"1612838025.png\",\"cover_img\":\"1612838004.jpeg\",\"secondary_email\":null,\"facebook_url\":\"https:\\/\\/www.facebook.com\\/\",\"twitter_url\":\"https:\\/\\/twitter.com\\/\",\"instagram_url\":\"https:\\/\\/www.instagram.com\\/\",\"tripadvisor_url\":null,\"description\":\"<p>Lorem&nbsp;ipsum&nbsp;dolor&nbsp;sit&nbsp;amet&nbsp;consectetur&nbsp;adipisicing&nbsp;elit.&nbsp;Quam,&nbsp;amet?&nbsp;Soluta&nbsp;voluptatibus&nbsp;quod&nbsp;sequi&nbsp;quis&nbsp;ipsa&nbsp;ad&nbsp;officia&nbsp;odit&nbsp;eaque,&nbsp;nam&nbsp;hic&nbsp;minima&nbsp;voluptate&nbsp;fugiat&nbsp;reiciendis&nbsp;labore&nbsp;aliquid&nbsp;unde&nbsp;delectus.<\\/p>\",\"verified\":\"1\",\"featured_verified\":0,\"featured\":\"active\",\"verified_time\":null,\"created_at\":\"2020-12-06T08:13:44.000000Z\",\"updated_at\":\"2021-02-09T02:33:46.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":18,\"name\":\"Professional\",\"roomtype_id\":3,\"slug\":\"professional-1\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":1000,\"discount\":15,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>It can also be successfully used as a daily exercise to get writers to begin writing. Being shown a random sentence and using it to complete a paragraph each day can be an excellent way to begin any writing session.<\\/p>\",\"vendor_id\":20,\"created_at\":\"2020-12-06T08:28:24.000000Z\",\"updated_at\":\"2020-12-07T10:28:37.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"Chhatraman\",\"lname\":\"Shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"1611582618.jpg\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"Munalpath\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2021-01-25T13:50:21.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2021-01-24T23:05:33.000000Z\"}}}}',NULL,'2021-02-09 02:46:20','2021-02-09 02:46:20'),('2e14b439-9eca-4103-b8d6-6ba32676bbba','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:09:59.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:09:59','2020-11-04 08:09:59'),('31a4557b-67ef-41f3-bb24-13dfe3ace0ea','App\\Notifications\\Vendor\\VendorNoti','App\\User',37,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-12-07 16:31:44\",\"link\":\"\"}',NULL,'2020-12-07 10:46:45','2020-12-07 10:46:45'),('333e1c03-27e4-4a00-9f68-0a2e4bb54d19','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK2B4UDP20\",\"data\":{\"id\":14,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK2B4UDP20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"1\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:08:54.000000Z\",\"updated_at\":\"2020-11-04T08:59:22.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:59:25','2020-11-04 08:59:25'),('33c28529-7ab9-49a6-8d57-b3ea57cdb4a7','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 12:58:23\",\"link\":\"\"}',NULL,'2020-11-04 07:13:23','2020-11-04 07:13:23'),('376a9b64-6e87-4055-94f2-e071d957c60e','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:50:15\",\"link\":\"\"}',NULL,'2020-11-01 07:05:15','2020-11-01 07:05:15'),('379a75b3-5d37-4536-89c8-6efabf71968a','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"Chhatraman Shrestha has booked your room \",\"detail\":\"Chhatraman Shrestha has booked your room at 2021-03-03 11:48:59\",\"link\":\"\"}',NULL,'2021-03-03 06:04:00','2021-03-03 06:04:00'),('397038df-57a4-45e6-8f42-ae0260514f2e','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Chhatraman Shrestha has booked your room \",\"detail\":\"Chhatraman Shrestha has booked your room at 2021-02-09 12:54:25\",\"link\":\"\"}',NULL,'2021-02-09 07:09:25','2021-02-09 07:09:25'),('3bb67a1c-b43f-4f88-875b-cd109fdbfaa9','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-02 14:28:14\",\"link\":\"\"}',NULL,'2020-11-02 08:43:15','2020-11-02 08:43:15'),('3bc5e367-91b5-47ba-a7fa-4bd406c4815c','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T07:51:42.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 07:51:43','2020-11-04 07:51:43'),('45c8a056-507b-4fc2-9611-45bd518e2042','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"aalu aalu has booked your room \",\"detail\":\"aalu aalu has booked your room at 2020-11-02 14:36:02\",\"link\":\"\"}',NULL,'2020-11-02 08:51:02','2020-11-02 08:51:02'),('4f76a35f-f7f6-4a4f-83a2-811ad8bac223','App\\Notifications\\Vendor\\VendorNoti','App\\User',37,'{\"title\":\"Chhatraman Shrestha has booked your room \",\"detail\":\"Chhatraman Shrestha has booked your room at 2021-01-25 04:52:15\",\"link\":\"\"}',NULL,'2021-01-24 23:07:16','2021-01-24 23:07:16'),('566838b7-7dd6-4477-ba51-46d4ff2d3684','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"krishna rai has booked your room \",\"detail\":\"krishna rai has booked your room at 2021-02-07 14:43:16\",\"link\":\"\"}',NULL,'2021-02-07 08:58:17','2021-02-07 08:58:17'),('5caf949d-2915-4a3e-a4b3-89e049baf452','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 13:35:53\",\"link\":\"\"}','2020-11-04 09:22:36','2020-11-04 07:50:53','2020-11-04 09:22:36'),('5ce7ff28-aeac-44da-9079-d9d2d74cf76f','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:16:00','2020-11-04 08:16:00'),('5f5a0f34-337e-4481-b3c9-f26ebb86a56f','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T09:58:26.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 09:58:27','2020-11-04 09:58:27'),('648d601b-b3ca-47e5-b13c-b96e09ed881b','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 13:06:33\",\"link\":\"\"}',NULL,'2020-11-04 07:21:33','2020-11-04 07:21:33'),('6597a759-79e9-4818-8693-bdd623ca3d7e','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:51:45\",\"link\":\"\"}',NULL,'2020-11-01 07:06:45','2020-11-01 07:06:45'),('6d3b9954-5d36-43f4-868c-3c14a423a675','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:06:46.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:06:46','2020-11-04 08:06:46'),('7109b1cf-8cb0-4956-a5a8-4a1ed73a288b','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:25','2020-11-04 08:14:25'),('71486c15-1d24-4a1b-8b4a-685b9ce4c5e9','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:02:45.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:02:45','2020-11-04 08:02:45'),('790a8911-bbdf-40bf-b011-3532af306939','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 13:23:15\",\"link\":\"\"}',NULL,'2020-11-04 07:38:15','2020-11-04 07:38:15'),('7b68357e-7e19-425e-84c4-feb8bdd2df96','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 12:44:12\",\"link\":\"\"}',NULL,'2020-11-04 06:59:13','2020-11-04 06:59:13'),('7e98ca49-7711-487b-af2b-c2b468308c9a','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-01 12:12:45\",\"link\":\"\"}',NULL,'2020-11-01 06:27:45','2020-11-01 06:27:45'),('844e6276-7567-4f65-b77b-65acce3018d0','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:50:15\",\"link\":\"\"}',NULL,'2020-11-01 07:05:15','2020-11-01 07:05:15'),('9443a6b5-ed74-4075-b220-a02b1c4ff8b4','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKESILGG20\",\"data\":{\"id\":17,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKESILGG20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:38:15.000000Z\",\"updated_at\":\"2020-11-04T07:41:04.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 07:41:04','2020-11-04 07:41:04'),('9906d4e1-6339-4746-88c4-f5a740622b65','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:16:23','2020-11-04 08:16:23'),('9af8e11f-2416-410a-8c5f-92447e6aa525','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-02 14:12:25\",\"link\":\"\"}',NULL,'2020-11-02 08:27:25','2020-11-02 08:27:25'),('9d339e97-c4dc-4280-bc91-08acc6535631','App\\Notifications\\Vendor\\VendorNoti','App\\User',35,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-11-04 12:53:54\",\"link\":\"\"}',NULL,'2020-11-04 07:08:54','2020-11-04 07:08:54'),('9f4bdbbd-f74f-4e66-84ea-a2fab97c9e51','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T10:03:05.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 10:03:06','2020-11-04 10:03:06'),('a2695061-032d-49f2-855d-6424705f0c5e','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:50:08\",\"link\":\"\"}',NULL,'2020-11-01 07:05:09','2020-11-01 07:05:09'),('acfe2b63-7442-4c42-89f9-464f07d56b51','App\\Notifications\\Vendor\\VendorNoti','App\\User',13,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:47:59\",\"link\":\"\"}',NULL,'2020-11-01 07:03:00','2020-11-01 07:03:00'),('b9424257-6e34-4151-8e14-da1d79bc3533','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:15:48','2020-11-04 08:15:48'),('b9af3eb4-1e96-4979-96ff-81a184836dfd','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:15:54','2020-11-04 08:15:54'),('c5b511fa-d239-44b3-931a-f79629ee6b12','App\\Notifications\\Vendor\\VendorNoti','App\\User',37,'{\"title\":\"chhatraman shrestha has booked your room \",\"detail\":\"chhatraman shrestha has booked your room at 2020-12-07 16:16:01\",\"link\":\"\"}',NULL,'2020-12-07 10:31:06','2020-12-07 10:31:06'),('cd86633f-5537-4674-8784-5f76b9da7f6d','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:54','2020-11-04 08:14:54'),('d00d1a1d-60a2-4092-b94a-89a4836fbcf6','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:15:02','2020-11-04 08:15:02'),('d68b4596-15fc-432c-a5da-525b2c721b76','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T10:03:05.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}','2021-01-21 02:51:20','2020-11-04 10:03:19','2021-01-21 02:51:20'),('dadde36c-e42c-4915-9542-c81909fc9d3b','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:13:58','2020-11-04 08:13:58'),('dc954cb4-65ec-44de-a2a5-066ab10855ff','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:30','2020-11-04 08:14:30'),('de5e2bd3-33e4-43eb-94f1-2e32d5199c15','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T07:01:30.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 07:01:31','2020-11-04 07:01:31'),('e0402978-7aa9-48fb-9eac-2689bd5cd5e8','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T07:01:30.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 07:01:41','2020-11-04 07:01:41'),('e4f2fb19-a7f8-4594-8097-19e374c3db77','App\\Notifications\\Vendor\\VendorNoti','App\\User',9,'{\"title\":\"Komal Shrestha has booked your room \",\"detail\":\"Komal Shrestha has booked your room at 2020-11-01 12:51:37\",\"link\":\"\"}',NULL,'2020-11-01 07:06:37','2020-11-01 07:06:37'),('e9a4bd97-1ed9-4d96-ad48-364797d5a325','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Raja has confirmed your booking for Raja(Professional)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKOAKDBM20\",\"data\":{\"id\":19,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKOAKDBM20\",\"num_rooms\":1,\"room_id\":18,\"vendor_id\":20,\"check_in_time\":\"2020-12-07\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":850,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-12-07T10:31:01.000000Z\",\"updated_at\":\"2020-12-07T10:32:57.000000Z\",\"vendor\":{\"id\":20,\"user_id\":37,\"star\":1,\"name\":\"Raja\",\"slug\":\"raj\",\"phone_number\":\"9800000000\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":437,\"logo\":\"1607242728.jpg\",\"cover_img\":\"1607242712.png\",\"secondary_email\":null,\"facebook_url\":\"https:\\/\\/www.facebook.com\\/\",\"twitter_url\":\"https:\\/\\/twitter.com\\/\",\"instagram_url\":\"https:\\/\\/www.instagram.com\\/\",\"tripadvisor_url\":null,\"description\":\"<p>Lorem&nbsp;ipsum&nbsp;dolor&nbsp;sit&nbsp;amet&nbsp;consectetur&nbsp;adipisicing&nbsp;elit.&nbsp;Quam,&nbsp;amet?&nbsp;Soluta&nbsp;voluptatibus&nbsp;quod&nbsp;sequi&nbsp;quis&nbsp;ipsa&nbsp;ad&nbsp;officia&nbsp;odit&nbsp;eaque,&nbsp;nam&nbsp;hic&nbsp;minima&nbsp;voluptate&nbsp;fugiat&nbsp;reiciendis&nbsp;labore&nbsp;aliquid&nbsp;unde&nbsp;delectus.<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-12-06T08:13:44.000000Z\",\"updated_at\":\"2020-12-06T09:27:06.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":18,\"name\":\"Professional\",\"roomtype_id\":3,\"slug\":\"professional-1\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":1000,\"discount\":15,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>It can also be successfully used as a daily exercise to get writers to begin writing. Being shown a random sentence and using it to complete a paragraph each day can be an excellent way to begin any writing session.<\\/p>\",\"vendor_id\":20,\"created_at\":\"2020-12-06T08:28:24.000000Z\",\"updated_at\":\"2020-12-07T10:28:37.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"1607333345.jpg\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-12-07T09:29:07.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-12-07T09:26:21.000000Z\"}}}}','2021-01-21 02:50:38','2020-12-07 10:32:57','2021-01-21 02:50:38'),('eea0e84e-2335-4bbe-880b-b63248301e21','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:37','2020-11-04 08:14:37'),('ef95b635-e669-4541-a320-993d747b72d6','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T10:03:05.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}','2021-01-21 02:51:03','2020-11-04 10:03:26','2021-01-21 02:51:03'),('f59a77de-51bd-4f8e-b2cd-48cc9bd019be','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:16:07','2020-11-04 08:16:07'),('f901e112-107e-40dc-a0ea-84bdf9276d27','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:13:58.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:14:47','2020-11-04 08:14:47'),('fbd9f5d6-1f56-45bc-9ddb-52701fc32bd2','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BK3QEM7B20\",\"data\":{\"id\":13,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BK3QEM7B20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T06:59:12.000000Z\",\"updated_at\":\"2020-11-04T08:11:29.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 08:11:40','2020-11-04 08:11:40'),('feb4afa0-5c9c-41ba-9a76-c3a84a78ebe5','App\\Notifications\\VendorUser\\UserNoti','App\\User',10,'{\"title\":\"Bookig has been confirmed\",\"detail\":\"Rose has confirmed your booking for Rose(aalu aalu)\",\"link\":\"http:\\/\\/localhost:8000\\/user\\/bookings\\/show\\/BKH2VDWW20\",\"data\":{\"id\":18,\"first_name\":\"chhatraman\",\"last_name\":\"shrestha\",\"email\":\"cms111000111@gmail.com\",\"phone_number\":\"9800916365\",\"adult\":1,\"children\":0,\"user_id\":2,\"booking_id\":\"BKH2VDWW20\",\"num_rooms\":1,\"room_id\":6,\"vendor_id\":18,\"check_in_time\":\"2020-11-04\",\"check_out_time\":null,\"coupon_applied\":0,\"coupon_id\":null,\"approved_time\":null,\"booking_status\":\"confirmed\",\"new_price\":123,\"old_price\":null,\"type\":\"2\",\"payment_addition_info\":null,\"payment_status\":\"paid\",\"created_at\":\"2020-11-04T07:50:53.000000Z\",\"updated_at\":\"2020-11-04T10:01:36.000000Z\",\"vendor\":{\"id\":18,\"user_id\":35,\"star\":1,\"name\":\"Rose\",\"slug\":\"rose\",\"phone_number\":\"9822334455\",\"secondary_phone_number\":null,\"website\":null,\"category_id\":3,\"featured_end_time\":null,\"featured_start_time\":null,\"average_cost\":333,\"logo\":\"1604416791.png\",\"cover_img\":\"1604415077.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"description\":\"<p>dsdfasdfasdf<\\/p>\",\"verified\":\"0\",\"featured_verified\":0,\"featured\":\"\",\"verified_time\":null,\"created_at\":\"2020-11-03T12:39:43.000000Z\",\"updated_at\":\"2020-11-03T15:39:53.000000Z\",\"step\":3,\"isverified\":0},\"room\":{\"id\":6,\"name\":\"aalu aalu\",\"roomtype_id\":2,\"slug\":\"aalu-aalu\",\"no_of_rooms\":0,\"vacant_rooms\":0,\"price\":123,\"discount\":null,\"status\":\"Available\",\"coupon_enabled\":null,\"exta_bed\":null,\"price_of_extra_bed\":null,\"description\":\"<p>helloworld<\\/p>\",\"vendor_id\":18,\"created_at\":\"2020-11-04T06:56:51.000000Z\",\"updated_at\":\"2020-11-04T06:56:51.000000Z\"},\"vendoruser\":{\"id\":2,\"user_id\":10,\"fname\":\"chhatraman\",\"lname\":\"shrestha\",\"slug\":\"chhatraman\",\"mobile_number\":\"9800916365\",\"profile_img\":\"profile.png\",\"cover_img\":\"cover.png\",\"secondary_email\":null,\"facebook_url\":null,\"twitter_url\":null,\"instagram_url\":null,\"tripadvisor_url\":null,\"location\":\"munal path\",\"city_id\":1,\"lat\":null,\"lng\":null,\"description\":null,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-11-01T16:36:57.000000Z\",\"user\":{\"id\":10,\"provider\":null,\"provider_id\":null,\"email\":\"cms111000111@gmail.com\",\"email_verified_at\":null,\"role_id\":1,\"active\":1,\"created_at\":\"2020-10-15T20:26:55.000000Z\",\"updated_at\":\"2020-10-15T20:27:51.000000Z\"}}}}',NULL,'2020-11-04 10:01:37','2020-11-04 10:01:37');
  /*!40000 ALTER TABLE `notifications` 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(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `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 */;
  INSERT INTO `oauth_access_tokens` VALUES ('1b71c3c293327de0d90d77241e9c3dee63f925351885e8779a96434c2c2d02573f3282b3a48760d5',10,1,'Personal Access Token','[]',0,'2020-11-02 12:03:05','2020-11-02 12:03:05','2021-11-02 17:48:05'),('20ba5afb9f1bb5421f99e7bfab774c2ca2549f2ccc8aaa7019cb1cf314e16b18de5b731dd57d841b',10,1,'Personal Access Token','[]',0,'2020-11-03 01:01:57','2020-11-03 01:01:57','2021-11-03 06:46:57'),('49539bf5e1082fbbaf51aef8175d6576c64b57559eee673354e8476d0c61ed9ad3118d2ffbf9a464',10,1,'Personal Access Token','[]',0,'2020-11-02 11:58:52','2020-11-02 11:58:52','2021-11-02 17:43:52');
  /*!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 DEFAULT NULL,
    `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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_clients_user_id_index` (`user_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 `oauth_clients`
  --
  
  LOCK TABLES `oauth_clients` WRITE;
  /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
  INSERT INTO `oauth_clients` VALUES (1,NULL,'AB_TESTS Personal Access Client','Bi3laT09QieTIemqBxOO8OfajVcAYjxG9W5drdR4','http://localhost',1,0,0,'2020-11-02 11:58:28','2020-11-02 11:58:28'),(2,NULL,'AB_TESTS Password Grant Client','9HAlrz955d5ugxfnVN4fK5XxHm3zTjI62ERKS3W7','http://localhost',0,1,0,'2020-11-02 11:58:29','2020-11-02 11:58:29');
  /*!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 AUTO_INCREMENT=2 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 */;
  INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2020-11-02 11:58:29','2020-11-02 11:58:29');
  /*!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` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `password_resets_email_index` (`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 `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 `payment_methods`
  --
  
  DROP TABLE IF EXISTS `payment_methods`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `payment_methods` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pkey` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'logo.png',
    `live_public_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `live_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `test_public_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `test_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'test',
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `payment_methods_pkey_unique` (`pkey`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `payment_methods`
  --
  
  LOCK TABLES `payment_methods` WRITE;
  /*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */;
  INSERT INTO `payment_methods` VALUES (1,'khalti','khalti','logo.png','live_public_key_3426d278d34a4da18686d04cb25986d4','live_secret_key_ba5fb8be76bd41408824bd3ba429807f','test_public_key_d193ed2c588a44cf8227d78fa567b5fd','test_secret_key_35c11470d355415c837aecf1374b6775','testing','active','asdfa','2020-11-02 08:26:40','2020-11-02 08:26:40');
  /*!40000 ALTER TABLE `payment_methods` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `policies`
  --
  
  DROP TABLE IF EXISTS `policies`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `policies` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `check_in_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `check_out_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `check_in_out_policy` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `cancelation_policy` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `extra_bed_policy` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_mode` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `policies_vendor_id_foreign` (`vendor_id`),
    CONSTRAINT `policies_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `policies`
  --
  
  LOCK TABLES `policies` WRITE;
  /*!40000 ALTER TABLE `policies` DISABLE KEYS */;
  INSERT INTO `policies` VALUES (1,18,'05 : 30 AM','05 : 30 PM','ssss','eeee','eeeeeeee','pppppppp','dd dd dd','2020-11-03 15:27:42','2020-11-03 15:27:42'),(2,6,'05 : 30 AM','05 : 30 PM','adsdsdsdsdsd','sfasdfsadf','aaaa','adads','asdfsad','2021-01-12 07:56:34','2021-01-12 07:56:34');
  /*!40000 ALTER TABLE `policies` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `reviews`
  --
  
  DROP TABLE IF EXISTS `reviews`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `reviews` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `vendor_user_id` int(10) unsigned NOT NULL,
    `booking_id` int(10) unsigned NOT NULL,
    `review_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `review_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `clean` double NOT NULL,
    `food` double NOT NULL,
    `comfort` double NOT NULL,
    `facility` double NOT NULL,
    `sbehaviour` double NOT NULL,
    `avg_rating` double NOT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unapproved',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `reviews_vendor_id_foreign` (`vendor_id`),
    KEY `reviews_vendor_user_id_foreign` (`vendor_user_id`),
    KEY `reviews_booking_id_foreign` (`booking_id`),
    CONSTRAINT `reviews_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE,
    CONSTRAINT `reviews_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE,
    CONSTRAINT `reviews_vendor_user_id_foreign` FOREIGN KEY (`vendor_user_id`) REFERENCES `vendor_users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `reviews`
  --
  
  LOCK TABLES `reviews` WRITE;
  /*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
  INSERT INTO `reviews` VALUES (3,20,2,19,'','sadfasdfsadf',0,0,0,0,0,2.5,'unapproved','2021-01-25 13:56:17','2021-01-25 13:56:17');
  /*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `roles`
  --
  
  DROP TABLE IF EXISTS `roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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 `roles`
  --
  
  LOCK TABLES `roles` WRITE;
  /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  INSERT INTO `roles` VALUES (1,'user',NULL,'2018-01-11 21:48:57','2020-10-07 13:47:31'),(2,'vendor',NULL,'2018-01-14 21:48:57','2020-10-07 13:47:31');
  /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `room_amenities`
  --
  
  DROP TABLE IF EXISTS `room_amenities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `room_amenities` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `room_id` int(10) unsigned NOT NULL,
    `amenity` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `room_amenities_room_id_foreign` (`room_id`),
    CONSTRAINT `room_amenities_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `room_amenities`
  --
  
  LOCK TABLES `room_amenities` WRITE;
  /*!40000 ALTER TABLE `room_amenities` DISABLE KEYS */;
  INSERT INTO `room_amenities` VALUES (1,1,'dfdfdf','2020-10-07 16:17:53','2020-10-07 16:17:53'),(2,1,'sdasdasd','2020-10-07 16:17:53','2020-10-07 16:17:53'),(3,1,'asdasdas','2020-10-07 16:17:53','2020-10-07 16:17:53'),(4,1,'asdasd','2020-10-07 16:17:54','2020-10-07 16:17:54'),(5,1,'jytdszxdcgvbhn','2020-10-07 17:32:50','2020-10-07 17:32:50'),(6,2,'asdfasd','2020-10-07 17:47:19','2020-10-07 17:47:19'),(7,2,'asdfas','2020-10-07 17:47:19','2020-10-07 17:47:19'),(8,2,'adfasdf','2020-10-07 17:47:19','2020-10-07 17:47:19'),(12,4,'Whatsssappp','2020-11-01 06:57:31','2020-11-01 06:57:31'),(17,6,'full something','2020-11-04 06:56:52','2020-11-04 06:56:52'),(18,6,'then something','2020-11-04 06:56:52','2020-11-04 06:56:52'),(19,7,'1 hour per day for 30 days','2020-12-06 07:57:00','2020-12-06 07:57:00'),(20,7,'School\'s Bike','2020-12-06 07:57:00','2020-12-06 07:57:00'),(21,8,'2 hours per day for 30 days','2020-12-06 07:59:24','2020-12-06 07:59:24'),(22,8,'School\'s Bike','2020-12-06 07:59:25','2020-12-06 07:59:25'),(23,8,'Trial Practice','2020-12-06 07:59:25','2020-12-06 07:59:25'),(24,9,'1 hour per day for 30 days','2020-12-06 08:03:46','2020-12-06 08:03:46'),(25,9,'Your Vehicle','2020-12-06 08:03:46','2020-12-06 08:03:46'),(26,10,'1 hour per day for 30 days','2020-12-06 08:06:19','2020-12-06 08:06:19'),(27,10,'School\'s Vehicle','2020-12-06 08:06:20','2020-12-06 08:06:20'),(28,10,'Trial Practice','2020-12-06 08:06:20','2020-12-06 08:06:20'),(29,11,'1 hour per day for 15 days','2020-12-06 08:08:02','2020-12-06 08:08:02'),(30,11,'School\'s Vehicle','2020-12-06 08:08:02','2020-12-06 08:08:02'),(31,12,'1 hour per day for 45 days','2020-12-06 08:10:47','2020-12-06 08:10:47'),(32,12,'School\'s Vehicle','2020-12-06 08:10:48','2020-12-06 08:10:48'),(33,12,'Trial Practice','2020-12-06 08:10:48','2020-12-06 08:10:48'),(34,12,'License Guaranteed','2020-12-06 08:10:48','2020-12-06 08:10:48'),(35,13,'1 hour per day for 20 days','2020-12-06 08:21:31','2020-12-06 08:21:31'),(36,14,'2 hours per day for 40 days','2020-12-06 08:23:18','2020-12-06 08:23:18'),(37,15,'1 hour per day for 15 days','2020-12-06 08:24:41','2020-12-06 08:24:41'),(38,16,'2 hours per day for 40 days','2020-12-06 08:25:54','2020-12-06 08:25:54'),(39,17,'1 hour per day for 15 days','2020-12-06 08:27:21','2020-12-06 08:27:21'),(40,18,'2 hours per day for 40 days','2020-12-06 08:28:24','2020-12-06 08:28:24'),(41,19,'services','2021-01-12 08:25:12','2021-01-12 08:25:12');
  /*!40000 ALTER TABLE `room_amenities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `room_photos`
  --
  
  DROP TABLE IF EXISTS `room_photos`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `room_photos` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `room_id` int(10) unsigned NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `room_photos_room_id_foreign` (`room_id`),
    CONSTRAINT `room_photos_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `room_photos`
  --
  
  LOCK TABLES `room_photos` WRITE;
  /*!40000 ALTER TABLE `room_photos` DISABLE KEYS */;
  INSERT INTO `room_photos` VALUES (1,1,'package.png','2020-10-07 16:17:54','2020-10-07 16:17:54'),(2,2,'package.png','2020-10-07 17:47:20','2020-10-07 17:47:20'),(5,4,'package.png','2020-11-01 06:57:31','2020-11-01 06:57:31'),(8,6,'package.png','2020-11-04 06:56:52','2020-11-04 06:56:52'),(9,6,'package.png','2020-11-04 06:56:53','2020-11-04 06:56:53'),(10,6,'package.png','2020-11-04 06:56:54','2020-11-04 06:56:54'),(11,7,'package.png','2020-12-06 07:57:00','2020-12-06 07:57:00'),(12,7,'package.png','2020-12-06 07:57:07','2020-12-06 07:57:07'),(13,7,'package.png','2020-12-06 07:57:08','2020-12-06 07:57:08'),(14,8,'package.png','2020-12-06 07:59:25','2020-12-06 07:59:25'),(15,8,'package.png','2020-12-06 07:59:25','2020-12-06 07:59:25'),(16,8,'package.png','2020-12-06 07:59:26','2020-12-06 07:59:26'),(17,9,'package.png','2020-12-06 08:03:46','2020-12-06 08:03:46'),(18,9,'package.png','2020-12-06 08:03:46','2020-12-06 08:03:46'),(19,9,'package.png','2020-12-06 08:03:47','2020-12-06 08:03:47'),(20,10,'package.png','2020-12-06 08:06:20','2020-12-06 08:06:20'),(21,10,'package.png','2020-12-06 08:06:20','2020-12-06 08:06:20'),(22,10,'package.png','2020-12-06 08:06:21','2020-12-06 08:06:21'),(23,11,'package.png','2020-12-06 08:08:02','2020-12-06 08:08:02'),(24,11,'package.png','2020-12-06 08:08:03','2020-12-06 08:08:03'),(25,11,'package.png','2020-12-06 08:08:03','2020-12-06 08:08:03'),(26,12,'package.png','2020-12-06 08:10:48','2020-12-06 08:10:48'),(27,12,'package.png','2020-12-06 08:10:49','2020-12-06 08:10:49'),(28,12,'package.png','2020-12-06 08:10:52','2020-12-06 08:10:52'),(29,12,'package.png','2020-12-06 08:10:54','2020-12-06 08:10:54'),(30,13,'package.png','2020-12-06 08:21:32','2020-12-06 08:21:32'),(31,13,'package.png','2020-12-06 08:21:41','2020-12-06 08:21:41'),(32,13,'package.png','2020-12-06 08:21:42','2020-12-06 08:21:42'),(33,13,'package.png','2020-12-06 08:21:42','2020-12-06 08:21:42'),(34,14,'package.png','2020-12-06 08:23:18','2020-12-06 08:23:18'),(35,14,'package.png','2020-12-06 08:23:24','2020-12-06 08:23:24'),(36,14,'package.png','2020-12-06 08:23:25','2020-12-06 08:23:25'),(37,14,'package.png','2020-12-06 08:23:25','2020-12-06 08:23:25'),(38,14,'package.png','2020-12-06 08:23:26','2020-12-06 08:23:26'),(39,15,'package.png','2020-12-06 08:24:41','2020-12-06 08:24:41'),(40,15,'package.png','2020-12-06 08:24:42','2020-12-06 08:24:42'),(41,15,'package.png','2020-12-06 08:24:42','2020-12-06 08:24:42'),(42,16,'package.png','2020-12-06 08:25:55','2020-12-06 08:25:55'),(43,16,'package.png','2020-12-06 08:25:56','2020-12-06 08:25:56'),(44,16,'package.png','2020-12-06 08:25:56','2020-12-06 08:25:56'),(45,16,'package.png','2020-12-06 08:25:57','2020-12-06 08:25:57'),(46,17,'package.png','2020-12-06 08:27:21','2020-12-06 08:27:21'),(47,17,'package.png','2020-12-06 08:27:22','2020-12-06 08:27:22'),(48,17,'package.png','2020-12-06 08:27:24','2020-12-06 08:27:24'),(49,17,'package.png','2020-12-06 08:27:24','2020-12-06 08:27:24'),(50,18,'package.png','2020-12-06 08:28:24','2020-12-06 08:28:24'),(51,18,'package.png','2020-12-06 08:28:24','2020-12-06 08:28:24'),(52,18,'package.png','2020-12-06 08:28:26','2020-12-06 08:28:26'),(53,18,'package.png','2020-12-06 08:28:26','2020-12-06 08:28:26'),(54,19,'cardriving.jpg','2021-01-12 08:25:13','2021-01-12 08:25:13');
  /*!40000 ALTER TABLE `room_photos` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `room_policies`
  --
  
  DROP TABLE IF EXISTS `room_policies`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `room_policies` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `check_in_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `check_out_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `check_out_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `cancelation_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `children_bed_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pet_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_policy` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `room_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `room_policies_room_id_foreign` (`room_id`),
    CONSTRAINT `room_policies_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `room_policies`
  --
  
  LOCK TABLES `room_policies` WRITE;
  /*!40000 ALTER TABLE `room_policies` DISABLE KEYS */;
  /*!40000 ALTER TABLE `room_policies` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `room_types`
  --
  
  DROP TABLE IF EXISTS `room_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `room_types` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'icon.png',
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `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 `room_types`
  --
  
  LOCK TABLES `room_types` WRITE;
  /*!40000 ALTER TABLE `room_types` DISABLE KEYS */;
  INSERT INTO `room_types` VALUES (2,'Car','car','1608226160.png','active','2020-10-07 16:15:23','2020-12-17 17:29:22'),(3,'Bus','bus','1608226217.png','active','2020-12-01 05:58:29','2020-12-17 17:30:17'),(4,'Bike','bike','1608226233.png','active','2020-12-01 05:59:02','2020-12-17 17:30:33');
  /*!40000 ALTER TABLE `room_types` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `rooms`
  --
  
  DROP TABLE IF EXISTS `rooms`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `rooms` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `roomtype_id` int(10) unsigned NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `no_of_rooms` int(11) NOT NULL,
    `vacant_rooms` int(11) DEFAULT NULL,
    `price` double(8,2) NOT NULL,
    `discount` double(8,2) DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UnAvailable',
    `coupon_enabled` int(11) DEFAULT NULL,
    `exta_bed` int(11) DEFAULT NULL,
    `price_of_extra_bed` double(8,2) DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `vendor_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `rooms_slug_unique` (`slug`),
    KEY `rooms_vendor_id_foreign` (`vendor_id`),
    CONSTRAINT `rooms_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `rooms`
  --
  
  LOCK TABLES `rooms` WRITE;
  /*!40000 ALTER TABLE `rooms` DISABLE KEYS */;
  INSERT INTO `rooms` VALUES (1,'nabin',2,'nabin',0,1,2222.00,NULL,'Available',NULL,NULL,NULL,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum</p>',6,'2020-10-07 16:17:53','2021-01-12 07:55:47'),(2,'fsda',2,'fsda',0,0,122.00,11.00,'Available',NULL,NULL,NULL,'<p>asdfasdfafas</p>',6,'2020-10-07 17:47:19','2020-10-07 17:47:19'),(4,'Back Cover',2,'back-cover',0,0,2000.00,2.00,'Available',NULL,NULL,NULL,'<p>Watch your back and forth with you and i know if you need anything else from me please let</p>',7,'2020-11-01 06:57:31','2020-11-01 07:00:34'),(6,'Advance course (45Days)',2,'aalu-aalu',0,0,123.00,NULL,'Available',NULL,NULL,NULL,'<p>helloworld</p>',18,'2020-11-04 06:56:51','2020-11-04 06:56:51'),(7,'Basic',4,'basic',0,0,8000.00,10.00,'Available',NULL,NULL,NULL,'<p>If you&#39;re visiting this page, you&#39;re likely here because you&#39;re searching for a random sentence. Sometimes a random word just isn&#39;t enough, and that is where the random sentence generator comes into play. By inputting the desired number, you can make a list of as many random sentences as you want or need. Producing random sentences can be helpful in a number of different ways.</p>',19,'2020-12-06 07:56:59','2020-12-06 07:56:59'),(8,'Advance',4,'advance',0,0,15000.00,10.00,'Available',NULL,NULL,NULL,'<p>For writers, a random sentence can help them get their creative juices flowing. Since the topic of the sentence is completely unknown, it forces the writer to be creative when the sentence appears. There are a number of different ways a writer can use the random sentence for creativity. The most common way to use the sentence is to begin a story. Another option is to include it somewhere in the story. A much more difficult challenge is to use it to end a story. In any of these cases, it forces the writer to think creatively since they have no idea what sentence will appear from the tool.</p>',19,'2020-12-06 07:59:24','2020-12-06 07:59:24'),(9,'Beginner',2,'beginner',0,0,12000.00,10.00,'Available',NULL,NULL,NULL,'<p>For those writers who have writers&#39; block, this can be an excellent way to take a step to crumbling those walls. By taking the writer away from the subject matter that is causing the block, a random sentence may allow them to see the project they&#39;re working on in a different light and perspective. Sometimes all it takes is to get that first sentence down to help break the block.</p>',19,'2020-12-06 08:03:45','2020-12-06 08:03:45'),(10,'Advance',2,'advance-1',0,0,25000.00,10.00,'Available',NULL,NULL,NULL,'<p>Random sentences can also spur creativity in other types of projects being done. If you are trying to come up with a new concept, a new idea or a new product, a random sentence may help you find unique qualities you may not have considered. Trying to incorporate the sentence into your project can help you look at it in different and unexpected ways than you would normally on your own.</p>',19,'2020-12-06 08:06:19','2020-12-06 08:06:19'),(11,'Starting',3,'starting',0,0,20000.00,10.00,'Available',NULL,NULL,NULL,'<p>These are just a few ways that one might use the random sentence generator for their benefit. If you&#39;re not sure if it will help in the way you want, the best course of action is to try it and see. Have several random sentences generated and you&#39;ll soon be able to see if they can help with your project.</p>',19,'2020-12-06 08:08:01','2020-12-06 08:08:01'),(12,'Professional',3,'professional',0,0,40000.00,12.00,'Available',NULL,NULL,NULL,'<p>No, the random sentences in our generator are not computer generated. We considered using computer generated sentences when building this tool, but found the results to be disappointing. Even though it took a lot of time, all the sentences in this generator were created by us.</p>',19,'2020-12-06 08:10:47','2020-12-06 08:10:47'),(13,'20 Days Package',4,'20-days-package',0,0,5000.00,5.00,'Available',NULL,NULL,NULL,'<p>If you&#39;re visiting this page, you&#39;re likely here because you&#39;re searching for a random sentence. Sometimes a random word just isn&#39;t enough, and that is where the random sentence generator comes into play. By inputting the desired number, you can make a list of as many random sentences as you want or need. Producing random sentences can be helpful in a number of different ways.</p>',20,'2020-12-06 08:21:31','2020-12-06 08:21:31'),(14,'40 Days Package',4,'40-days-package',0,0,15000.00,12.00,'Available',NULL,NULL,NULL,'<p>For writers, a random sentence can help them get their creative juices flowing. Since the topic of the sentence is completely unknown, it forces the writer to be creative when the sentence appears. There are a number of different ways a writer can use the random sentence for creativity. The most common way to use the sentence is to begin a story. Another option is to include it somewhere in the story. A much more difficult challenge is to use it to end a story. In any of these cases, it forces the writer to think creatively since they have no idea what sentence will appear from the tool.</p>',20,'2020-12-06 08:23:17','2020-12-06 08:23:17'),(15,'Basic',2,'basic-1',0,0,14000.00,12.00,'Available',NULL,NULL,NULL,'<p>For those writers who have writers&#39; block, this can be an excellent way to take a step to crumbling those walls. By taking the writer away from the subject matter that is causing the block, a random sentence may allow them to see the project they&#39;re working on in a different light and perspective. Sometimes all it takes is to get that first sentence down to help break the block.</p>',20,'2020-12-06 08:24:41','2020-12-06 08:24:41'),(16,'Advance',2,'advance-2',0,0,30000.00,15.00,'Available',NULL,NULL,NULL,'<p>It can also be successfully used as a daily exercise to get writers to begin writing. Being shown a random sentence and using it to complete a paragraph each day can be an excellent way to begin any writing session.</p>',20,'2020-12-06 08:25:54','2020-12-06 08:25:54'),(17,'Starting',3,'starting-1',0,0,15000.00,3.00,'Available',NULL,NULL,NULL,'<p>It can also be successfully used as a daily exercise to get writers to begin writing. Being shown a random sentence and using it to complete a paragraph each day can be an excellent way to begin any writing session.</p>',20,'2020-12-06 08:27:20','2020-12-06 08:27:20'),(18,'Professional',3,'professional-1',0,0,1000.00,15.00,'Available',NULL,NULL,NULL,'<p>It can also be successfully used as a daily exercise to get writers to begin writing. Being shown a random sentence and using it to complete a paragraph each day can be an excellent way to begin any writing session.</p>',20,'2020-12-06 08:28:24','2020-12-07 10:28:37'),(19,'TEST 3',2,'test-3',0,0,3000.00,5.00,'Available',NULL,NULL,NULL,'<p>best package</p>',6,'2021-01-12 08:25:12','2021-01-12 08:25:12');
  /*!40000 ALTER TABLE `rooms` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `s_m_s_mocks`
  --
  
  DROP TABLE IF EXISTS `s_m_s_mocks`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `s_m_s_mocks` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `number` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
    `msg` varchar(161) 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=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `s_m_s_mocks`
  --
  
  LOCK TABLES `s_m_s_mocks` WRITE;
  /*!40000 ALTER TABLE `s_m_s_mocks` DISABLE KEYS */;
  INSERT INTO `s_m_s_mocks` VALUES (12,'9800916365','Your Activation Code is 148949','2021-01-16 17:18:14','2021-01-16 17:18:14'),(13,'9800916365','Your Activation Code is 305381','2021-01-16 17:57:53','2021-01-16 17:57:53'),(14,'9800916365','Your Activation Code is 942342','2021-01-16 17:58:12','2021-01-16 17:58:12'),(15,'9800916365','Your Activation Code is 535568','2021-01-16 18:02:10','2021-01-16 18:02:10'),(16,'9800916365','Your Activation Code is 596869','2021-01-16 18:17:15','2021-01-16 18:17:15'),(17,'9800916365','Your Activation Code is 204006','2021-01-17 04:33:32','2021-01-17 04:33:32'),(18,'9800916365','Your Activation Code is 407928','2021-01-17 04:45:20','2021-01-17 04:45:20'),(19,'9800916365','Your Activation Code is 284093','2021-01-17 04:46:46','2021-01-17 04:46:46'),(20,'9800916365','Your Activation Code is 142428','2021-01-17 04:48:08','2021-01-17 04:48:08'),(21,'9800916365','Your Activation Code is 714109','2021-01-17 09:30:28','2021-01-17 09:30:28'),(22,'9800916365','Your Activation Code is 939712','2021-01-17 20:38:51','2021-01-17 20:38:51'),(23,'9800916365','Your Activation Code is 214918','2021-01-17 22:12:58','2021-01-17 22:12:58'),(24,'9800916365','Your Activation Code is 394094','2021-01-19 07:38:22','2021-01-19 07:38:22'),(25,'9800916365','Your Activation Code is 707203','2021-01-21 03:23:36','2021-01-21 03:23:36');
  /*!40000 ALTER TABLE `s_m_s_mocks` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `sliders`
  --
  
  DROP TABLE IF EXISTS `sliders`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sliders` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `subtitle` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `ismobile` tinyint(1) NOT NULL,
    `order` int(11) 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 `sliders`
  --
  
  LOCK TABLES `sliders` WRITE;
  /*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
  /*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `states`
  --
  
  DROP TABLE IF EXISTS `states`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `states` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `country_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `states`
  --
  
  LOCK TABLES `states` WRITE;
  /*!40000 ALTER TABLE `states` DISABLE KEYS */;
  INSERT INTO `states` VALUES (1,'Province no 1',1,'2020-10-07 16:33:17','2020-10-07 16:33:17');
  /*!40000 ALTER TABLE `states` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tourism_areas`
  --
  
  DROP TABLE IF EXISTS `tourism_areas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tourism_areas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_by_admin` int(11) NOT NULL DEFAULT 1,
    `creator_id` int(10) unsigned DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `featured_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_by` int(11) NOT NULL,
    `lat` double(10,5) unsigned DEFAULT NULL,
    `lng` double(10,5) unsigned DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `tourism_areas_slug_unique` (`slug`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tourism_areas`
  --
  
  LOCK TABLES `tourism_areas` WRITE;
  /*!40000 ALTER TABLE `tourism_areas` DISABLE KEYS */;
  /*!40000 ALTER TABLE `tourism_areas` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_coupons`
  --
  
  DROP TABLE IF EXISTS `user_coupons`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user_coupons` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendoruser_id` int(10) unsigned NOT NULL,
    `coupon_id` int(10) 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;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_coupons`
  --
  
  LOCK TABLES `user_coupons` WRITE;
  /*!40000 ALTER TABLE `user_coupons` DISABLE KEYS */;
  /*!40000 ALTER TABLE `user_coupons` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_references`
  --
  
  DROP TABLE IF EXISTS `user_references`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user_references` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `refkey` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `user_references_refkey_unique` (`refkey`),
    KEY `user_references_user_id_foreign` (`user_id`),
    CONSTRAINT `user_references_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_references`
  --
  
  LOCK TABLES `user_references` WRITE;
  /*!40000 ALTER TABLE `user_references` DISABLE KEYS */;
  /*!40000 ALTER TABLE `user_references` 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,
    `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `provider_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `role_id` int(10) unsigned NOT NULL DEFAULT 1,
    `active` tinyint(1) NOT NULL DEFAULT 0,
    `activation_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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`),
    KEY `users_role_id_foreign` (`role_id`),
    CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=49 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 (9,NULL,NULL,'c@f.l',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',2,1,'','DqAs6umQVJ2feqtfd5domsFDous1X5Po5RAKUQXBSl46FvQ1NnKK1i4vj0k0','2020-10-07 16:01:26','2020-12-07 09:26:21'),(10,NULL,NULL,'cms111000111@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,1,'241169','lh8UVWViwzHanfwPkIPlLEpmmlQoCccyxtrTRMOv1GeDnc8cy7ahy9qoiHUc','2020-10-15 20:26:55','2021-03-14 06:38:38'),(11,NULL,NULL,'krishna.rai.0759@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,0,'hardzLFLV8wwh3LGDvtSgstdfBg6ojkL61OAnX7m','iveFKKhx9jFYEgANJgzxaUsjVSbYV4UOwyRyYCBXjvxObYXDU5HddXyIeJ0U','2020-10-16 04:25:16','2021-01-12 08:10:33'),(12,NULL,NULL,'hirohamta@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,1,'','ptyBK4VS08kqEN1V5YqgER8QzzQWmk4C0aEuZ2js5gfJJQiDpmWpxhlftxG7','2020-11-01 06:51:06','2020-12-07 09:26:21'),(13,NULL,NULL,'goveanshrestha@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',2,1,'','yK5xRMHaZuJseU24qfisYXZ51jAw7Qefnxe5EaakyLKkkd7nP2M5rF2aqJT8','2020-11-01 06:52:15','2020-12-07 09:26:21'),(14,NULL,NULL,'mangello602@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,0,'i6EIxDU7tDk8W8HiEhtAtcBOV9kHbagHqc0V20fDwbbj2laRBTpqdG3VPL2f',NULL,'2020-11-01 06:52:59','2020-12-07 09:26:21'),(15,NULL,NULL,'bipinchaudhary6@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,0,'nF7DgF0ehU6X4L62qwufkyc5skopj764r3Y68IxQ3vydP6iiN8WYsrhBq9MI',NULL,'2020-11-01 07:00:02','2020-12-07 09:26:21'),(16,NULL,NULL,'face@face.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',1,0,'ARqhYiNQXD8gywl3zDEOGHB1GHyuZxDIvOpN66fO5ZVovn9zklQWZ9hy4kGS',NULL,'2020-11-01 07:02:10','2020-12-07 09:26:21'),(35,NULL,NULL,'rose@gmail.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',2,1,'','FTD9K32KhQt7TS0K4dSmKaB2SrWzmzlowAkDSkq6so67Ld6cFyXdvHMk6Mor','2020-11-03 12:39:43','2020-12-07 09:26:21'),(36,NULL,NULL,'abi@abc.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',2,1,'','UfVDrxdfndg7ZXisgpegYEECXZsUHV24U1mWK1ZkL1QUdBNLv5gTrH6ff8YB','2020-12-06 07:44:34','2020-12-07 09:26:21'),(37,NULL,NULL,'urr58775@bcaoo.com',NULL,'$2y$10$Pg8CgSuLAk3OZbtjm7WjMOwMKnROupMQwuzYNNEBcpyZzsjG.UvrS',2,1,'','9M5x1fpf2YYho9BtlTd4DBhDzQt8zGefrbvWLevuCqVrpSvnIcVsdo4s9BrI','2020-12-06 08:13:44','2021-02-09 02:33:04'),(38,NULL,NULL,'krishna9816985816@gmail.com',NULL,'$2y$10$pZ9byRzuD/xPK1Xgt9ZHE.tJXt4QARgn4V1vvFnH.OMLh4mWAxdSW',2,0,'998216','xSUC3isb9tqapjIjOP5koAeTgmJdUF0D1LTZoxiwp4JOHBioJCjgXEzuPj7Z','2021-01-12 07:51:14','2021-01-12 07:51:14'),(39,NULL,NULL,'diwanlimbu5816@gmail.com',NULL,'$2y$10$9RxxDP9rEQ5R1dWV1zizquh16tFsOf.CiYIXGX/mn72JsL7LMj5tC',2,0,'GOxcGxuSscCCmQ7jAWwk6sibsHr3AUKlrpb6fkTN','JzdG89zOft0pWOKzaVysFGTGla2CV2qzN8a7pJfFaxRuSjY4vPNfvCksCp2d','2021-01-12 07:56:20','2021-01-12 08:00:43'),(41,NULL,NULL,'kkk@gmail.com',NULL,'$2y$10$SLoPoG6SmxSBRfPtk5kRzOcMRwsvPJ9RvMwedKNSihE.H1emPSGUK',1,0,'148949',NULL,'2021-01-16 17:17:54','2021-01-16 17:17:54'),(42,NULL,NULL,'kankuro@kankuro.com',NULL,'$2y$10$ZFJ86tRTcZHP4EgtXr2iQevsRWaHpqSkIpzEvIX19UIrCxY5YyO8G',2,1,'','UemptAwXa4sKvdgOAeQ5ywQHMZpBhvBiMX06wSp04ZXD84bmtgC9civAeHSd','2021-01-24 05:38:40','2021-01-24 06:56:37'),(43,NULL,NULL,'kkk@r.com',NULL,'$2y$10$a4ATY1p9OZ7BH5zc.MlqjelyTJtX96CcuI3XyznN3hpZw3QZ6/Nn.',2,1,'','nR4aGGWuWXEgCsYDKunxIPFuWziC9SqZ7EJpL564jrCBVpPZpKzWvldlrzvZ','2021-01-24 11:48:20','2021-01-24 11:49:06'),(44,NULL,NULL,'gopal.ghimire332@gmail.com',NULL,'$2y$10$L3MBY0V0I6fPAAPkT7V/Cu4lZcxJ.jdJGbSxS4G8/AYfyKXaz2Zci',1,0,'621128','I8JJA1ENzvlmEQLpEIUpEdYqOkzxZApFoj9Ss6Tp4ktrJjG8wVNi6LMbboxa','2021-01-25 11:52:02','2021-01-25 11:52:02'),(45,NULL,NULL,'luipascher@hotmail.com',NULL,'$2y$10$8c8NH48qwT0efBFn..Eat.taValkDg3AUHQ2MTaiO5ZkQtfz4sJ0C',2,1,'','cYDWtJqpzgEbMt7UmEHpAOjL6R1q0drAw38oZn6FBv7NakEtA1R2VlN0LEmY','2021-02-07 08:40:04','2021-02-07 08:40:44'),(46,NULL,NULL,'new@need.com',NULL,'$2y$10$h0SLDPV9AwA0DcbJybqL2OkGAmUtZcHoOjDv/nSqwfM4p9ZSbZUVy',1,0,'674388','Og9NYajygviNEe6MtJSTcibwThqkT3yaByftx9ukeFUoXTaNQVD0GZ4mM0Iw','2021-02-07 08:49:36','2021-02-07 08:49:36'),(47,NULL,NULL,'chhata445@gmal.com',NULL,'$2y$10$aDyKLPDrac73WQjVCue6I.GOQcQX5.ibnrA5veItOR2u4vHGuSKfS',2,1,NULL,NULL,'2021-02-18 07:57:07','2021-02-18 07:57:07'),(48,NULL,NULL,'chhata44445@gmal.com',NULL,'$2y$10$gVP1fGeal/pzkhD6FYBju./GBilEIlWOydCqNzgE8POovyU/MmXBO',2,1,NULL,'LccpOQ3GVkj4fDypbtdjiyPaAlJQamACDaavc9AsceGLrY3vnh1Lm8T8P1yG','2021-02-18 08:03:40','2021-02-22 12:12:58');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vendor_accounts`
  --
  
  DROP TABLE IF EXISTS `vendor_accounts`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vendor_accounts` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `vendor_id` int(10) unsigned NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `bill` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `taken_by` int(10) unsigned NOT NULL,
    `invoice_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `ammount` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `vendor_accounts_vendor_id_foreign` (`vendor_id`),
    CONSTRAINT `vendor_accounts_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `vendor_accounts`
  --
  
  LOCK TABLES `vendor_accounts` WRITE;
  /*!40000 ALTER TABLE `vendor_accounts` DISABLE KEYS */;
  /*!40000 ALTER TABLE `vendor_accounts` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vendor_requests`
  --
  
  DROP TABLE IF EXISTS `vendor_requests`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vendor_requests` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `owner` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `accepted` tinyint(1) NOT NULL DEFAULT 0,
    `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 `vendor_requests`
  --
  
  LOCK TABLES `vendor_requests` WRITE;
  /*!40000 ALTER TABLE `vendor_requests` DISABLE KEYS */;
  /*!40000 ALTER TABLE `vendor_requests` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vendor_users`
  --
  
  DROP TABLE IF EXISTS `vendor_users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vendor_users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `fname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `mobile_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `profile_img` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'profile.png',
    `cover_img` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cover.png',
    `secondary_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `facebook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `twitter_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `instagram_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `tripadvisor_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city_id` int(11) DEFAULT NULL,
    `lat` double(10,5) unsigned DEFAULT NULL,
    `lng` double(10,5) unsigned DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `vendor_users_slug_unique` (`slug`),
    KEY `vendor_users_user_id_foreign` (`user_id`),
    CONSTRAINT `vendor_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `vendor_users`
  --
  
  LOCK TABLES `vendor_users` WRITE;
  /*!40000 ALTER TABLE `vendor_users` DISABLE KEYS */;
  INSERT INTO `vendor_users` VALUES (2,10,'Chhatraman','Shrestha','chhatraman','9800916365','1615704435.jpg','cover.png',NULL,NULL,NULL,NULL,NULL,'Munalpath',1,NULL,NULL,NULL,'2020-10-15 20:26:55','2021-03-14 06:47:18'),(3,11,'krishna','rai','krishna','9816985816','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-10-16 04:25:17','2020-10-16 04:25:17'),(4,12,'Komal','Shrestha','komal','9800916365','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-01 06:51:06','2020-11-01 06:51:06'),(5,14,'Bipin','Chaudhary','bipin','9804332352','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-01 06:52:59','2020-11-01 06:52:59'),(6,15,'Bipin','Chaudhary','bipin-1','9804332352','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-01 07:00:02','2020-11-01 07:00:02'),(7,16,'Face','Chaudhary','face','9804332352','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-01 07:02:10','2020-11-01 07:02:10'),(17,41,'chhatraman','shrestha','chhatraman-1','9800916365','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-01-16 17:17:54','2021-01-16 17:17:54'),(18,44,'Gopal gghgfghhghghhhjk','Ghimire hgfhhghjjhj','gopal-gghgfghhghghhhjk','9843697360','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-01-25 11:52:03','2021-01-25 11:52:03'),(19,46,'basanta','budhathoki','basanta','9829306787','profile.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-02-07 08:49:37','2021-02-07 08:49:37');
  /*!40000 ALTER TABLE `vendor_users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `vendors`
  --
  
  DROP TABLE IF EXISTS `vendors`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `vendors` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) unsigned NOT NULL,
    `star` int(11) DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secondary_phone_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `category_id` int(10) unsigned NOT NULL,
    `featured_end_time` datetime DEFAULT NULL,
    `featured_start_time` datetime DEFAULT NULL,
    `average_cost` double DEFAULT NULL,
    `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'logo.png',
    `cover_img` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cover.png',
    `secondary_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `facebook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `twitter_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `instagram_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `tripadvisor_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `verified` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `featured_verified` tinyint(1) NOT NULL DEFAULT 0,
    `featured` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
    `verified_time` datetime DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `step` int(11) NOT NULL DEFAULT 0,
    `isverified` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    UNIQUE KEY `vendors_slug_unique` (`slug`),
    KEY `vendors_category_id_foreign` (`category_id`),
    KEY `vendors_user_id_foreign` (`user_id`),
    CONSTRAINT `vendors_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
    CONSTRAINT `vendors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `vendors`
  --
  
  LOCK TABLES `vendors` WRITE;
  /*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
  INSERT INTO `vendors` VALUES (6,9,1,'Chhatraman Shrestha','chhatraman-shrestha','9800916365',NULL,NULL,3,NULL,NULL,3333,'logo.png','cover.png',NULL,NULL,NULL,NULL,NULL,'<p>sdafsad</p>','1',0,'active',NULL,'2020-10-07 16:01:26','2020-10-07 17:28:09',0,0),(7,13,NULL,'Govean Driving Center','govean-driving-center','9819365664',NULL,NULL,3,NULL,NULL,NULL,'logo.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,'1',0,'active',NULL,'2020-11-01 06:52:15','2020-11-04 10:08:04',0,0),(18,35,1,'Rose Driving Center','rose','9822334455',NULL,NULL,3,NULL,NULL,333,'1604416791.png','1604415077.png',NULL,NULL,NULL,NULL,NULL,'<p>dsdfasdfasdf</p>','1',0,'active',NULL,'2020-11-03 12:39:43','2020-11-04 10:09:49',0,0),(19,36,NULL,'Abiraj Driving Center','abi','980005400',NULL,NULL,3,NULL,NULL,NULL,'1607240834.jpg','1607240803.jpg',NULL,NULL,NULL,NULL,NULL,NULL,'1',0,'active',NULL,'2020-12-06 07:44:35','2020-12-06 07:47:15',0,0),(20,37,1,'Raja','raj','9800000000',NULL,NULL,3,NULL,NULL,437,'1612838025.png','1612838004.jpeg',NULL,'https://www.facebook.com/','https://twitter.com/','https://www.instagram.com/',NULL,'<p>Lorem&nbsp;ipsum&nbsp;dolor&nbsp;sit&nbsp;amet&nbsp;consectetur&nbsp;adipisicing&nbsp;elit.&nbsp;Quam,&nbsp;amet?&nbsp;Soluta&nbsp;voluptatibus&nbsp;quod&nbsp;sequi&nbsp;quis&nbsp;ipsa&nbsp;ad&nbsp;officia&nbsp;odit&nbsp;eaque,&nbsp;nam&nbsp;hic&nbsp;minima&nbsp;voluptate&nbsp;fugiat&nbsp;reiciendis&nbsp;labore&nbsp;aliquid&nbsp;unde&nbsp;delectus.</p>','1',0,'active',NULL,'2020-12-06 08:13:44','2021-02-09 02:33:46',3,0),(21,38,NULL,'krishna','krishna','9816985816',NULL,NULL,3,NULL,NULL,NULL,'logo.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,'0',0,'inactive',NULL,'2021-01-12 07:51:15','2021-01-12 07:51:15',0,0),(22,39,NULL,'krishna rai','krishna-rai','9816985816',NULL,NULL,3,NULL,NULL,NULL,'logo.png','cover.png',NULL,NULL,NULL,NULL,NULL,NULL,'0',0,'inactive',NULL,'2021-01-12 07:56:20','2021-01-12 07:56:20',0,0),(23,42,NULL,'kankuro driving center','kankuro-driving-center','9844404665',NULL,NULL,3,NULL,NULL,NULL,'1611471694.png','1611471474.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,'0',0,'inactive',NULL,'2021-01-24 05:38:41','2021-01-24 07:01:38',3,0),(24,43,1,'Chhatraman shrestha jfvbkjn','chhatraman-shrestha-jfvbkjn','9819356415',NULL,NULL,3,NULL,NULL,0,'1611488994.png','1611488970.jpeg',NULL,NULL,NULL,NULL,NULL,'<p>adasdas</p>','0',0,'',NULL,'2021-01-24 11:48:21','2021-01-24 21:23:21',3,0),(25,45,NULL,'basanta','basanta','9852078274',NULL,NULL,3,NULL,NULL,NULL,'1612689199.png','1612689187.jpg',NULL,NULL,NULL,NULL,NULL,NULL,'0',0,'inactive',NULL,'2021-02-07 08:40:06','2021-02-07 09:13:19',3,0),(26,48,NULL,'kankuro seesh','kankuro-seesh','9899880099',NULL,NULL,3,NULL,NULL,0,'1613635421.png','1613635423.jpg',NULL,NULL,NULL,NULL,NULL,'asdf','1',0,'0',NULL,'2021-02-18 08:03:40','2021-02-18 08:03:59',4,1);
  /*!40000 ALTER TABLE `vendors` 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 2021-03-19 12:38:10
  