--
-- Host: localhost    Database: miranda
-- ------------------------------------------------------


--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `code` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activations_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activations`
--

INSERT INTO `activations` VALUES (1,1,'068yMujYOpeJo4kmA4Qiv51qd7EccK0Y',1,'2020-09-01 20:15:07','2020-09-01 20:15:06','2020-09-01 20:15:07'),(2,1,'yH1V0D04GjlNceslIU91GHsyo1DLXYNS',1,'2021-01-03 17:44:54','2021-01-03 17:44:54','2021-01-03 17:44:54'),(3,1,'AHwoUIwvZ5rrYtXe84zwrnUjgYANzp9X',1,'2021-01-03 17:45:59','2021-01-03 17:45:59','2021-01-03 17:45:59'),(4,1,'U0kQv4TLrvDHUnEjWJGYxYbU5CLGRlWf',1,'2021-01-05 03:29:59','2021-01-05 03:29:59','2021-01-05 03:29:59');

--
-- Table structure for table `audit_histories`
--

CREATE TABLE `audit_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` text COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_user` int(10) unsigned NOT NULL,
  `reference_id` int(10) unsigned NOT NULL,
  `reference_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_histories_user_id_index` (`user_id`),
  KEY `audit_histories_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_histories`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint(4) NOT NULL DEFAULT '0',
  `is_featured` tinyint(4) NOT NULL DEFAULT '0',
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `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;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Travel',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2020-09-03 09:24:14','2020-09-04 06:56:38'),(2,'Business',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2020-09-04 06:55:24','2020-09-04 06:56:38'),(3,'Creative',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2020-09-04 06:55:49','2020-09-04 06:56:38'),(4,'Technology',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2020-09-04 06:56:15','2020-09-04 06:56:38');

--
-- Table structure for table `contact_replies`
--

CREATE TABLE `contact_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` 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;

--
-- Dumping data for table `contact_replies`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `dashboard_widget_settings`
--

CREATE TABLE `dashboard_widget_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `user_id` int(10) unsigned NOT NULL,
  `widget_id` int(10) unsigned NOT NULL,
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_widget_settings_user_id_index` (`user_id`),
  KEY `dashboard_widget_settings_widget_id_index` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widget_settings`
--


--
-- Table structure for table `dashboard_widgets`
--

CREATE TABLE `dashboard_widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) 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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widgets`
--

INSERT INTO `dashboard_widgets` VALUES (1,'widget_total_themes','2020-09-01 20:29:01','2020-09-01 20:29:01'),(2,'widget_total_users','2020-09-01 20:29:01','2020-09-01 20:29:01'),(3,'widget_total_pages','2020-09-01 20:29:01','2020-09-01 20:29:01'),(4,'widget_total_plugins','2020-09-01 20:29:01','2020-09-01 20:29:01'),(5,'widget_posts_recent','2020-09-03 09:20:38','2020-09-03 09:20:38'),(6,'widget_analytics_general','2020-09-04 19:03:45','2020-09-04 19:03:45'),(7,'widget_analytics_page','2020-09-04 19:03:45','2020-09-04 19:03:45'),(8,'widget_analytics_browser','2020-09-04 19:03:45','2020-09-04 19:03:45'),(9,'widget_analytics_referrer','2020-09-04 19:03:45','2020-09-04 19:03:45'),(10,'widget_audit_logs','2020-09-04 19:03:45','2020-09-04 19:03:45');

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

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

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


--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `galleries_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` VALUES (1,'Duplex Restaurant','--',0,0,'galleries/01.jpg',1,'published','2020-09-04 20:56:27','2020-09-04 20:56:27'),(2,'Luxury room','---',0,0,'galleries/02.jpg',1,'published','2020-09-04 20:56:55','2020-09-04 20:56:55'),(3,'Pacific Room','--',0,0,'galleries/03.jpg',1,'published','2020-09-04 20:57:42','2020-09-04 20:57:42'),(4,'Family Room','--',0,0,'rooms/05.jpg',1,'published','2020-09-04 21:21:02','2020-09-04 21:21:02'),(5,'King Bed','--',0,0,'news/03-1.jpg',1,'published','2020-09-04 21:21:53','2020-09-04 21:21:53'),(6,'Special Foods','--',0,0,'galleries/06.jpg',1,'published','2020-09-04 21:22:25','2020-09-04 21:22:46');

--
-- Table structure for table `gallery_meta`
--

CREATE TABLE `gallery_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_id` int(10) unsigned NOT NULL,
  `images` text COLLATE utf8mb4_unicode_ci,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gallery_meta_content_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_meta`
--

INSERT INTO `gallery_meta` VALUES (1,1,'[{\"img\":\"galleries/05.jpg\",\"description\":\"\"},{\"img\":\"galleries/08.jpg\",\"description\":\"\"},{\"img\":\"galleries/07.jpg\",\"description\":\"\"},{\"img\":\"galleries/06.jpg\",\"description\":\"\"},{\"img\":\"galleries/05.jpg\",\"description\":\"\"},{\"img\":\"galleries/04.jpg\",\"description\":\"\"},{\"img\":\"galleries/03.jpg\",\"description\":\"\"},{\"img\":\"galleries/02.jpg\",\"description\":\"\"},{\"img\":\"galleries/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:56:27','2020-09-04 20:56:27'),(2,2,'[{\"img\":\"galleries/08.jpg\",\"description\":\"\"},{\"img\":\"galleries/07.jpg\",\"description\":\"\"},{\"img\":\"galleries/06.jpg\",\"description\":\"\"},{\"img\":\"galleries/05.jpg\",\"description\":\"\"},{\"img\":\"galleries/04.jpg\",\"description\":\"\"},{\"img\":\"galleries/03.jpg\",\"description\":\"\"},{\"img\":\"galleries/02.jpg\",\"description\":\"\"},{\"img\":\"galleries/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:56:55','2020-09-04 20:56:55'),(3,3,'[{\"img\":\"galleries/08.jpg\",\"description\":\"\"},{\"img\":\"galleries/07.jpg\",\"description\":\"\"},{\"img\":\"galleries/06.jpg\",\"description\":\"\"},{\"img\":\"galleries/05.jpg\",\"description\":\"\"},{\"img\":\"galleries/04.jpg\",\"description\":\"\"},{\"img\":\"galleries/03.jpg\",\"description\":\"\"},{\"img\":\"galleries/02.jpg\",\"description\":\"\"},{\"img\":\"galleries/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:57:42','2020-09-04 20:57:42'),(5,5,NULL,'Botble\\Page\\Models\\Page','2020-09-04 21:04:11','2020-09-04 21:04:11'),(6,4,'[{\"img\":\"rooms/06.jpg\",\"description\":\"\"},{\"img\":\"rooms/05.jpg\",\"description\":\"\"},{\"img\":\"rooms/04.jpg\",\"description\":\"\"},{\"img\":\"rooms/03.jpg\",\"description\":\"\"},{\"img\":\"rooms/02.jpg\",\"description\":\"\"},{\"img\":\"rooms/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:21:03','2020-09-04 21:21:03'),(7,5,'[{\"img\":\"news/03-1.jpg\",\"description\":\"\"},{\"img\":\"news/02-1.jpg\",\"description\":\"\"},{\"img\":\"news/01-1.jpg\",\"description\":\"\"},{\"img\":\"news/02.jpg\",\"description\":\"\"},{\"img\":\"news/03.jpg\",\"description\":\"\"},{\"img\":\"news/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:21:53','2020-09-04 21:21:53'),(8,6,'[{\"img\":\"foods\\/09.jpg\",\"description\":\"\"},{\"img\":\"foods\\/10.jpg\",\"description\":\"\"},{\"img\":\"foods\\/08.jpg\",\"description\":\"\"},{\"img\":\"foods\\/07.jpg\",\"description\":\"\"},{\"img\":\"foods\\/06.jpg\",\"description\":\"\"},{\"img\":\"foods\\/05.jpg\",\"description\":\"\"},{\"img\":\"foods\\/04.jpg\",\"description\":\"\"},{\"img\":\"foods\\/03.jpg\",\"description\":\"\"},{\"img\":\"foods\\/02.jpg\",\"description\":\"\"},{\"img\":\"foods\\/01.jpg\",\"description\":\"\"}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:22:25','2020-09-04 21:22:46'),(16,6,NULL,'Botble\\Page\\Models\\Page','2020-09-05 02:21:38','2020-09-05 02:21:38'),(24,7,NULL,'Botble\\Page\\Models\\Page','2020-09-09 04:37:20','2020-09-09 04:37:20'),(25,1,NULL,'Botble\\Page\\Models\\Page','2021-01-03 17:32:01','2021-01-03 17:32:01');

--
-- Table structure for table `ht_amenities`
--

CREATE TABLE `ht_amenities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_amenities`
--

INSERT INTO `ht_amenities` VALUES (1,'Air conditioner','fal fa-bath','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(2,'High speed WiFi','fal fa-wifi','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(3,'Strong Locker','fal fa-key','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(4,'Breakfast','fal fa-cut','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(5,'Kitchen','fal fa-guitar','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(6,'Smart Security','fal fa-lock','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(7,'Cleaning','fal fa-broom','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(8,'Shower','fal fa-shower','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(9,'24/7 Online Support','fal fa-headphones-alt','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(10,'Grocery','fal fa-shopping-basket','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(11,'Single bed','fal fa-bed','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(12,'Expert Team','fal fa-users','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(13,'Shop near','fal fa-shopping-cart','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(14,'Towels','fal fa-bus','published','2021-01-05 03:29:34','2021-01-05 03:29:34');

--
-- Table structure for table `ht_booking_addresses`
--

CREATE TABLE `ht_booking_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_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;

--
-- Dumping data for table `ht_booking_addresses`
--


--
-- Table structure for table `ht_booking_rooms`
--

CREATE TABLE `ht_booking_rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(10) unsigned NOT NULL,
  `room_id` int(10) unsigned DEFAULT NULL,
  `price` decimal(15,2) NOT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `number_of_rooms` int(11) NOT NULL DEFAULT '1',
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_booking_rooms`
--


--
-- Table structure for table `ht_booking_services`
--

CREATE TABLE `ht_booking_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(10) unsigned NOT NULL,
  `service_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_booking_services`
--

INSERT INTO `ht_booking_services` VALUES (1,1,4);

--
-- Table structure for table `ht_bookings`
--

CREATE TABLE `ht_bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(15,2) NOT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `requests` text COLLATE utf8mb4_unicode_ci,
  `arrival_time` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` int(10) unsigned DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `transaction_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tax_amount` decimal(15,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_bookings`
--


--
-- Table structure for table `ht_currencies`
--

CREATE TABLE `ht_currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `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;

--
-- Dumping data for table `ht_currencies`
--

INSERT INTO `ht_currencies` VALUES (1,'USD','$',1,0,0,1,1,'2021-01-05 03:29:34','2021-01-05 03:29:34');

--
-- Table structure for table `ht_customers`
--

CREATE TABLE `ht_customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `phone` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ht_customers_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_customers`
--

INSERT INTO `ht_customers` VALUES (1,'Lolita','Rolfson','mavis09@example.com',NULL,NULL,'+2292930373774','2021-01-05 03:29:52','2021-01-05 03:29:52'),(2,'Vella','Tillman','nhahn@example.com',NULL,NULL,'+8377684679067','2021-01-05 03:29:52','2021-01-05 03:29:52'),(3,'Novella','Mitchell','olin62@example.com',NULL,NULL,'+4492465943011','2021-01-05 03:29:52','2021-01-05 03:29:52'),(4,'Corene','Kirlin','xkuhic@example.net',NULL,NULL,'+1767310097578','2021-01-05 03:29:52','2021-01-05 03:29:52'),(5,'Camden','Heathcote','erik63@example.com',NULL,NULL,'+8502127420621','2021-01-05 03:29:52','2021-01-05 03:29:52'),(6,'Will','Jenkins','litzy.schneider@example.org',NULL,NULL,'+3214734024825','2021-01-05 03:29:52','2021-01-05 03:29:52'),(7,'Genesis','Stanton','qdaugherty@example.com',NULL,NULL,'+4759329920245','2021-01-05 03:29:52','2021-01-05 03:29:52'),(8,'Marielle','O\'Hara','collin.ernser@example.net',NULL,NULL,'+1619507191217','2021-01-05 03:29:52','2021-01-05 03:29:52'),(9,'Paris','Koelpin','june31@example.com',NULL,NULL,'+3890014088775','2021-01-05 03:29:52','2021-01-05 03:29:52'),(10,'Hannah','Luettgen','daren.hamill@example.org',NULL,NULL,'+3490248838559','2021-01-05 03:29:52','2021-01-05 03:29:52');

--
-- Table structure for table `ht_features`
--

CREATE TABLE `ht_features` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `icon` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_features`
--

INSERT INTO `ht_features` VALUES (1,'Have High Rating','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-rating',1,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(2,'Quiet Hours','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-clock',1,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(3,'Best Locations','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-location-pin',1,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(4,'Free Cancellation','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-clock-1',0,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(5,'Payment Options','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-credit-card',0,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(6,'Special Offers','Lorem ipsum dolor sit amet, consectetur adipisicing 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.','flaticon-discount',0,'published','2021-01-05 03:29:51','2021-01-05 03:29:51');

--
-- Table structure for table `ht_food_types`
--

CREATE TABLE `ht_food_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_food_types`
--

INSERT INTO `ht_food_types` VALUES (1,'Chicken','flaticon-boiled','published','2021-01-05 03:29:40','2021-01-05 03:29:40'),(2,'Italian','flaticon-pizza','published','2021-01-05 03:29:40','2021-01-05 03:29:40'),(3,'Coffee','flaticon-coffee','published','2021-01-05 03:29:40','2021-01-05 03:29:40'),(4,'Bake Cake','flaticon-cake','published','2021-01-05 03:29:40','2021-01-05 03:29:40'),(5,'Cookies','flaticon-cookie','published','2021-01-05 03:29:40','2021-01-05 03:29:40'),(6,'Cocktail','flaticon-cocktail','published','2021-01-05 03:29:40','2021-01-05 03:29:40');

--
-- Table structure for table `ht_foods`
--

CREATE TABLE `ht_foods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(15,0) unsigned DEFAULT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `food_type_id` int(10) unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_foods`
--

INSERT INTO `ht_foods` VALUES (1,'Eggs & Bacon','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',197,NULL,1,'foods/01.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(2,'Tea or Coffee','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',147,NULL,1,'foods/02.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(3,'Chia Oatmeal','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',142,NULL,1,'foods/03.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(4,'Juice','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',182,NULL,1,'foods/04.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(5,'Chia Oatmeal','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',147,NULL,2,'foods/05.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(6,'Fruit Parfait','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',175,NULL,2,'foods/06.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(7,'Marmalade Selection','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',136,NULL,3,'foods/07.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(8,'Cheese Platen','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',122,NULL,4,'foods/08.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(9,'Avocado Toast','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',184,NULL,5,'foods/09.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(10,'Avocado Toast','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',169,NULL,6,'foods/10.jpg','published','2021-01-05 03:29:51','2021-01-05 03:29:51');

--
-- Table structure for table `ht_places`
--

CREATE TABLE `ht_places` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `distance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_places`
--

INSERT INTO `ht_places` VALUES (1,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'I never was so small as this is May it won\'t be raving mad after all! I almost wish I hadn\'t quite finished my tea when I was a general chorus of \'There goes Bill!\' then the puppy jumped into the garden with one elbow against the door, staring stupidly up into hers--she could hear the very middle of her voice, and the other bit. Her chin was pressed hard against it, that attempt proved a failure. Alice heard the Queen was silent. The Dormouse slowly opened his eyes were nearly out of their hearing her; and the whole thing, and she trembled till she had got its neck nicely straightened out, and was a general clapping of hands at this: it was all finished, the Owl, as a cushion, resting their elbows on it, and fortunately was just going to be, from one end to the Duchess: you\'d better leave off,\' said the Pigeon in a very hopeful tone though), \'I won\'t indeed!\' said the Pigeon. \'I\'m NOT a serpent!\' said Alice indignantly, and she told her sister, who was trembling down to look for her.','places/01.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'Mock Turtle said: \'I\'m too stiff. And the moral of that is, but I can\'t be Mabel, for I know I do!\' said Alice angrily. \'It wasn\'t very civil of you to get hold of this rope--Will the roof was thatched with fur. It was the White Rabbit was no one could possibly hear you.\' And certainly there was enough of it had gone. \'Well! I\'ve often seen them so often, you know.\' \'Who is it twelve? I--\' \'Oh, don\'t talk about trouble!\' said the Pigeon; \'but I know I have to whisper a hint to Time, and round Alice, every now and then quietly marched off after the birds! Why, she\'ll eat a little wider. \'Come, it\'s pleased so far,\' said the Caterpillar. \'Well, perhaps you were down here with me! There are no mice in the newspapers, at the bottom of a feather flock together.\"\' \'Only mustard isn\'t a bird,\' Alice remarked. \'Right, as usual,\' said the youth, \'as I mentioned before, And have grown most uncommonly fat; Yet you turned a back-somersault in at once.\' And in she went. Once more she found it.','places/02.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(3,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'Alice, very earnestly. \'I\'ve had nothing else to say it over) \'--yes, that\'s about the whiting!\' \'Oh, as to prevent its undoing itself,) she carried it out again, and said, \'That\'s right, Five! Always lay the blame on others!\' \'YOU\'D better not talk!\' said Five. \'I heard every word you fellows were saying.\' \'Tell us a story.\' \'I\'m afraid I don\'t take this child away with me,\' thought Alice, \'it\'ll never do to ask: perhaps I shall only look up and walking away. \'You insult me by talking such nonsense!\' \'I didn\'t know it was too small, but at last came a little before she got up, and there stood the Queen shrieked out. \'Behead that Dormouse! Turn that Dormouse out of its mouth and yawned once or twice, half hoping that the meeting adjourn, for the fan and gloves, and, as the large birds complained that they would go, and making quite a conversation of it in her life, and had no pictures or conversations in it, and very nearly carried it out to the door. \'Call the next verse,\' the.','places/03.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(4,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'Mouse in the sand with wooden spades, then a great thistle, to keep back the wandering hair that curled all over crumbs.\' \'You\'re wrong about the same size: to be ashamed of yourself for asking such a curious dream, dear, certainly: but now run in to your tea; it\'s getting late.\' So Alice began in a moment. \'Let\'s go on crying in this affair, He trusts to you never to lose YOUR temper!\' \'Hold your tongue!\' said the King; \'and don\'t be particular--Here, Bill! catch hold of this ointment--one shilling the box-- Allow me to him: She gave me a good deal until she made it out to the jury. They were just beginning to end,\' said the Mock Turtle went on, taking first one side and up I goes like a telescope! I think I must sugar my hair.\" As a duck with its eyelids, so he with his whiskers!\' For some minutes it puffed away without being seen, when she was ready to ask any more questions about it, so she sat down again into its nest. Alice crouched down among the trees, a little pattering of.','places/04.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(5,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'She took down a good deal: this fireplace is narrow, to be managed? I suppose Dinah\'ll be sending me on messages next!\' And she began nibbling at the Caterpillar\'s making such VERY short remarks, and she was always ready to ask his neighbour to tell them something more. \'You promised to tell me who YOU are, first.\' \'Why?\' said the Gryphon: \'I went to school in the other: he came trotting along in a hot tureen! Who for such a puzzled expression that she had expected: before she came suddenly upon an open place, with a smile. There was not a mile high,\' said Alice. \'I\'ve tried every way, and nothing seems to like her, down here, that I should understand that better,\' Alice said very politely, \'for I can\'t tell you how the Dodo in an impatient tone: \'explanations take such a curious dream, dear, certainly: but now run in to your places!\' shouted the Queen ordering off her unfortunate guests to execution--once more the shriek of the singers in the other: he came trotting along in a thick.','places/05.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(6,'Duplex Restaurant','1,500m | 21 min. Walk',NULL,'Alice said to Alice, very much what would be four thousand miles down, I think--\' (for, you see, because some of the water, and seemed to have any pepper in my size; and as Alice could not help thinking there MUST be more to be full of the court, she said to the Gryphon. \'Of course,\' the Mock Turtle in a day or two: wouldn\'t it be of any one; so, when the Rabbit say, \'A barrowful of WHAT?\' thought Alice \'without pictures or conversations?\' So she began thinking over other children she knew that were of the Gryphon, and all dripping wet, cross, and uncomfortable. The moment Alice felt a violent blow underneath her chin: it had entirely disappeared; so the King exclaimed, turning to the table for it, he was in the house till she shook the house, \"Let us both go to on the breeze that followed them, the melancholy words:-- \'Soo--oop of the jurors were writing down \'stupid things!\' on their slates, and then raised himself upon tiptoe, put his shoes on. \'--and just take his head.','places/06.jpg','published','2021-01-05 03:29:57','2021-01-05 03:29:57');

--
-- Table structure for table `ht_room_categories`
--

CREATE TABLE `ht_room_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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;

--
-- Dumping data for table `ht_room_categories`
--

INSERT INTO `ht_room_categories` VALUES (1,'Luxury','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(2,'Family','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(3,'Double Bed','published','2021-01-05 03:29:34','2021-01-05 03:29:34'),(4,'Relax','published','2021-01-05 03:29:34','2021-01-05 03:29:34');

--
-- Table structure for table `ht_room_dates`
--

CREATE TABLE `ht_room_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `max_guests` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '0',
  `note_to_customer` text COLLATE utf8mb4_unicode_ci,
  `note_to_admin` text COLLATE utf8mb4_unicode_ci,
  `number_of_rooms` smallint(6) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_room_dates`
--


--
-- Table structure for table `ht_rooms`
--

CREATE TABLE `ht_rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `images` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(15,0) unsigned DEFAULT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `number_of_rooms` int(10) unsigned DEFAULT '0',
  `number_of_beds` int(10) unsigned DEFAULT '0',
  `size` int(10) unsigned DEFAULT '0',
  `max_adults` int(11) DEFAULT '0',
  `max_children` int(11) DEFAULT '0',
  `room_category_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tax_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ht_rooms_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_rooms`
--

INSERT INTO `ht_rooms` VALUES (1,'Luxury Hall Of Fame','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,1,'[\"rooms\\/01.jpg\",\"rooms\\/02.jpg\",\"rooms\\/03.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',171,NULL,10,2,181,4,1,1,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(2,'Pendora Fame','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,1,'[\"rooms\\/02.jpg\",\"rooms\\/01.jpg\",\"rooms\\/03.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',126,NULL,9,4,109,3,1,1,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(3,'Pacific Room','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,1,'[\"rooms\\/03.jpg\",\"rooms\\/02.jpg\",\"rooms\\/01.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',175,NULL,9,3,179,5,1,1,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(4,'Junior Suite','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,0,'[\"rooms\\/04.jpg\",\"rooms\\/02.jpg\",\"rooms\\/01.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',124,NULL,9,1,164,2,1,1,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(5,'Family Suite','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,0,'[\"rooms\\/05.jpg\"]',117,NULL,2,3,127,3,2,1,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(6,'Relax Suite','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,0,'[\"rooms\\/06.jpg\",\"rooms\\/02.jpg\",\"rooms\\/03.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/01.jpg\"]',134,NULL,3,3,196,2,1,4,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(7,'Luxury Suite','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,0,'[\"rooms\\/01.jpg\",\"rooms\\/02.jpg\",\"rooms\\/03.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',121,NULL,9,4,170,3,2,2,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1),(8,'President Room','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,0,'[\"rooms\\/02.jpg\",\"rooms\\/01.jpg\",\"rooms\\/03.jpg\",\"rooms\\/04.jpg\",\"rooms\\/05.jpg\",\"rooms\\/06.jpg\"]',186,NULL,8,1,178,4,1,2,'published','2021-01-05 03:29:40','2021-01-05 03:29:40',1);

--
-- Table structure for table `ht_rooms_amenities`
--

CREATE TABLE `ht_rooms_amenities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amenity_id` int(10) unsigned 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 `ht_rooms_amenities_amenity_id_index` (`amenity_id`),
  KEY `ht_rooms_amenities_room_id_index` (`room_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_rooms_amenities`
--

INSERT INTO `ht_rooms_amenities` VALUES (1,1,1,NULL,NULL),(2,2,1,NULL,NULL),(3,3,1,NULL,NULL),(4,4,1,NULL,NULL),(5,6,1,NULL,NULL),(6,7,1,NULL,NULL),(7,9,1,NULL,NULL),(8,11,1,NULL,NULL),(9,1,2,NULL,NULL),(10,2,2,NULL,NULL),(11,3,2,NULL,NULL),(12,4,2,NULL,NULL),(13,6,2,NULL,NULL),(14,7,2,NULL,NULL),(15,9,2,NULL,NULL),(16,11,2,NULL,NULL),(17,1,3,NULL,NULL),(18,2,3,NULL,NULL),(19,3,3,NULL,NULL),(20,4,3,NULL,NULL),(21,6,3,NULL,NULL),(22,7,3,NULL,NULL),(23,9,3,NULL,NULL),(24,11,3,NULL,NULL),(25,1,4,NULL,NULL),(26,2,4,NULL,NULL),(27,3,4,NULL,NULL),(28,4,4,NULL,NULL),(29,6,4,NULL,NULL),(30,7,4,NULL,NULL),(31,9,4,NULL,NULL),(32,11,4,NULL,NULL),(33,1,5,NULL,NULL),(34,2,5,NULL,NULL),(35,3,5,NULL,NULL),(36,4,5,NULL,NULL),(37,6,5,NULL,NULL),(38,7,5,NULL,NULL),(39,9,5,NULL,NULL),(40,11,5,NULL,NULL),(41,1,6,NULL,NULL),(42,2,6,NULL,NULL),(43,3,6,NULL,NULL),(44,4,6,NULL,NULL),(45,6,6,NULL,NULL),(46,7,6,NULL,NULL),(47,9,6,NULL,NULL),(48,11,6,NULL,NULL),(49,1,7,NULL,NULL),(50,2,7,NULL,NULL),(51,3,7,NULL,NULL),(52,4,7,NULL,NULL),(53,6,7,NULL,NULL),(54,7,7,NULL,NULL),(55,9,7,NULL,NULL),(56,11,7,NULL,NULL),(57,1,8,NULL,NULL),(58,2,8,NULL,NULL),(59,3,8,NULL,NULL),(60,4,8,NULL,NULL),(61,6,8,NULL,NULL),(62,7,8,NULL,NULL),(63,9,8,NULL,NULL),(64,11,8,NULL,NULL);

--
-- Table structure for table `ht_services`
--

CREATE TABLE `ht_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `price` decimal(15,0) unsigned DEFAULT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ht_services`
--

INSERT INTO `ht_services` VALUES (1,'Wifi','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,100,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(2,'Car Rental','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,30,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(3,'Satellite TV','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,50,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(4,'Sea View','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,10,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(5,'Laundry','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,10,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51'),(6,'Breakfast','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel molestie nisl. Duis ac mi leo.',NULL,10,NULL,NULL,'published','2021-01-05 03:29:51','2021-01-05 03:29:51');

--
-- Table structure for table `ht_taxes`
--

CREATE TABLE `ht_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage` double(8,6) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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;

--
-- Dumping data for table `ht_taxes`
--

INSERT INTO `ht_taxes` VALUES (1,'VAT',10.000000,1,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,'None',0.000000,2,'published','2021-01-05 03:29:57','2021-01-05 03:29:57');

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `folder_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mime_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_files_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_files`
--

INSERT INTO `media_files` VALUES (162,0,'01',29,'image/jpeg',2181,'rooms/01.jpg','[]','2021-01-05 03:29:34','2021-01-05 03:29:34',NULL),(163,0,'02',29,'image/jpeg',2181,'rooms/02.jpg','[]','2021-01-05 03:29:35','2021-01-05 03:29:35',NULL),(164,0,'03',29,'image/jpeg',2181,'rooms/03.jpg','[]','2021-01-05 03:29:36','2021-01-05 03:29:36',NULL),(165,0,'04',29,'image/jpeg',2181,'rooms/04.jpg','[]','2021-01-05 03:29:37','2021-01-05 03:29:37',NULL),(166,0,'05',29,'image/jpeg',2181,'rooms/05.jpg','[]','2021-01-05 03:29:38','2021-01-05 03:29:38',NULL),(167,0,'06',29,'image/jpeg',2181,'rooms/06.jpg','[]','2021-01-05 03:29:39','2021-01-05 03:29:39',NULL),(168,0,'01',30,'image/jpeg',2165,'foods/01.jpg','[]','2021-01-05 03:29:40','2021-01-05 03:29:40',NULL),(169,0,'02',30,'image/jpeg',2165,'foods/02.jpg','[]','2021-01-05 03:29:41','2021-01-05 03:29:41',NULL),(170,0,'03',30,'image/jpeg',2165,'foods/03.jpg','[]','2021-01-05 03:29:42','2021-01-05 03:29:42',NULL),(171,0,'04',30,'image/jpeg',2165,'foods/04.jpg','[]','2021-01-05 03:29:43','2021-01-05 03:29:43',NULL),(172,0,'05',30,'image/jpeg',2165,'foods/05.jpg','[]','2021-01-05 03:29:45','2021-01-05 03:29:45',NULL),(173,0,'06',30,'image/jpeg',2165,'foods/06.jpg','[]','2021-01-05 03:29:46','2021-01-05 03:29:46',NULL),(174,0,'07',30,'image/jpeg',2165,'foods/07.jpg','[]','2021-01-05 03:29:47','2021-01-05 03:29:47',NULL),(175,0,'08',30,'image/jpeg',2165,'foods/08.jpg','[]','2021-01-05 03:29:48','2021-01-05 03:29:48',NULL),(176,0,'09',30,'image/jpeg',2165,'foods/09.jpg','[]','2021-01-05 03:29:49','2021-01-05 03:29:49',NULL),(177,0,'10',30,'image/jpeg',2165,'foods/10.jpg','[]','2021-01-05 03:29:50','2021-01-05 03:29:50',NULL),(178,0,'01',31,'image/jpeg',2041,'places/01.jpg','[]','2021-01-05 03:29:52','2021-01-05 03:29:52',NULL),(179,0,'02',31,'image/jpeg',2041,'places/02.jpg','[]','2021-01-05 03:29:53','2021-01-05 03:29:53',NULL),(180,0,'03',31,'image/jpeg',2041,'places/03.jpg','[]','2021-01-05 03:29:53','2021-01-05 03:29:53',NULL),(181,0,'04',31,'image/jpeg',2041,'places/04.jpg','[]','2021-01-05 03:29:54','2021-01-05 03:29:54',NULL),(182,0,'05',31,'image/jpeg',2041,'places/05.jpg','[]','2021-01-05 03:29:55','2021-01-05 03:29:55',NULL),(183,0,'06',31,'image/jpeg',2041,'places/06.jpg','[]','2021-01-05 03:29:56','2021-01-05 03:29:56',NULL),(184,0,'1',32,'image/jpeg',2165,'users/1.jpg','[]','2021-01-05 03:29:57','2021-01-05 03:29:57',NULL),(185,0,'01',33,'image/jpeg',2165,'galleries/01.jpg','[]','2021-01-05 03:29:59','2021-01-05 03:29:59',NULL),(186,0,'02',33,'image/jpeg',2165,'galleries/02.jpg','[]','2021-01-05 03:30:00','2021-01-05 03:30:00',NULL),(187,0,'03',33,'image/jpeg',2165,'galleries/03.jpg','[]','2021-01-05 03:30:01','2021-01-05 03:30:01',NULL),(188,0,'04',33,'image/jpeg',2165,'galleries/04.jpg','[]','2021-01-05 03:30:02','2021-01-05 03:30:02',NULL),(189,0,'05',33,'image/jpeg',2165,'galleries/05.jpg','[]','2021-01-05 03:30:03','2021-01-05 03:30:03',NULL),(190,0,'06',33,'image/jpeg',2165,'galleries/06.jpg','[]','2021-01-05 03:30:05','2021-01-05 03:30:05',NULL),(191,0,'07',33,'image/jpeg',2165,'galleries/07.jpg','[]','2021-01-05 03:30:06','2021-01-05 03:30:06',NULL),(192,0,'08',33,'image/jpeg',2165,'galleries/08.jpg','[]','2021-01-05 03:30:07','2021-01-05 03:30:07',NULL),(193,0,'01',34,'image/jpeg',984,'general/01.jpg','[]','2021-01-05 03:30:08','2021-01-05 03:30:08',NULL),(194,0,'02',34,'image/jpeg',820,'general/02.jpg','[]','2021-01-05 03:30:09','2021-01-05 03:30:09',NULL),(195,0,'03',34,'image/jpeg',1135,'general/03.jpg','[]','2021-01-05 03:30:10','2021-01-05 03:30:10',NULL),(196,0,'04',34,'image/jpeg',4202,'general/04.jpg','[]','2021-01-05 03:30:10','2021-01-05 03:30:10',NULL),(197,0,'banner-news',34,'image/jpeg',3936,'general/banner-news.jpg','[]','2021-01-05 03:30:12','2021-01-05 03:30:12',NULL),(198,0,'bg',34,'image/jpeg',7963,'general/bg.jpg','[]','2021-01-05 03:30:13','2021-01-05 03:30:13',NULL),(199,0,'favicon',34,'image/png',2386,'general/favicon.png','[]','2021-01-05 03:30:15','2021-01-05 03:30:15',NULL),(200,0,'logo-white',34,'image/png',3052,'general/logo-white.png','[]','2021-01-05 03:30:15','2021-01-05 03:30:15',NULL),(201,0,'logo',34,'image/png',3017,'general/logo.png','[]','2021-01-05 03:30:16','2021-01-05 03:30:16',NULL),(202,0,'video-background-02',34,'image/jpeg',7834,'general/video-background-02.jpg','[]','2021-01-05 03:30:17','2021-01-05 03:30:17',NULL),(203,0,'video-banner-01',34,'image/jpeg',2294,'general/video-banner-01.jpg','[]','2021-01-05 03:30:19','2021-01-05 03:30:19',NULL),(204,0,'01-1',35,'image/jpeg',2763,'news/01-1.jpg','[]','2021-01-05 03:30:20','2021-01-05 03:30:20',NULL),(205,0,'01',35,'image/jpeg',2763,'news/01.jpg','[]','2021-01-05 03:30:21','2021-01-05 03:30:21',NULL),(206,0,'02-1',35,'image/jpeg',2763,'news/02-1.jpg','[]','2021-01-05 03:30:22','2021-01-05 03:30:22',NULL),(207,0,'02',35,'image/jpeg',2763,'news/02.jpg','[]','2021-01-05 03:30:23','2021-01-05 03:30:23',NULL),(208,0,'03-1',35,'image/jpeg',2763,'news/03-1.jpg','[]','2021-01-05 03:30:24','2021-01-05 03:30:24',NULL),(209,0,'03',35,'image/jpeg',2763,'news/03.jpg','[]','2021-01-05 03:30:25','2021-01-05 03:30:25',NULL),(210,0,'04',36,'image/jpeg',8049,'sliders/04.jpg','[]','2021-01-05 03:30:26','2021-01-05 03:30:26',NULL),(211,0,'05',36,'image/jpeg',8049,'sliders/05.jpg','[]','2021-01-05 03:30:28','2021-01-05 03:30:28',NULL),(212,0,'01',37,'image/png',2165,'testimonials/01.png','[]','2021-01-05 03:30:30','2021-01-05 03:30:30',NULL),(213,0,'02',37,'image/png',2165,'testimonials/02.png','[]','2021-01-05 03:30:31','2021-01-05 03:30:31',NULL),(214,0,'03',37,'image/png',2165,'testimonials/03.png','[]','2021-01-05 03:30:32','2021-01-05 03:30:32',NULL);

--
-- Table structure for table `media_folders`
--

CREATE TABLE `media_folders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_folders_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_folders`
--

INSERT INTO `media_folders` VALUES (29,0,'rooms','rooms',0,'2021-01-05 03:29:34','2021-01-05 03:29:34',NULL),(30,0,'foods','foods',0,'2021-01-05 03:29:40','2021-01-05 03:29:40',NULL),(31,0,'places','places',0,'2021-01-05 03:29:52','2021-01-05 03:29:52',NULL),(32,0,'users','users',0,'2021-01-05 03:29:57','2021-01-05 03:29:57',NULL),(33,0,'galleries','galleries',0,'2021-01-05 03:29:59','2021-01-05 03:29:59',NULL),(34,0,'general','general',0,'2021-01-05 03:30:08','2021-01-05 03:30:08',NULL),(35,0,'news','news',0,'2021-01-05 03:30:20','2021-01-05 03:30:20',NULL),(36,0,'sliders','sliders',0,'2021-01-05 03:30:26','2021-01-05 03:30:26',NULL),(37,0,'testimonials','testimonials',0,'2021-01-05 03:30:30','2021-01-05 03:30:30',NULL);

--
-- Table structure for table `media_settings`
--

CREATE TABLE `media_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `media_id` int(11) DEFAULT NULL,
  `user_id` 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;

--
-- Dumping data for table `media_settings`
--


--
-- Table structure for table `menu_locations`
--

CREATE TABLE `menu_locations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) unsigned NOT NULL,
  `location` varchar(120) 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;

--
-- Dumping data for table `menu_locations`
--

INSERT INTO `menu_locations` VALUES (1,1,'header-menu','2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,2,'side-menu','2021-01-05 03:29:57','2021-01-05 03:29:57');

--
-- Table structure for table `menu_nodes`
--

CREATE TABLE `menu_nodes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `reference_id` int(10) unsigned DEFAULT '0',
  `reference_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_font` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `has_child` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_nodes_menu_id_index` (`menu_id`),
  KEY `menu_nodes_parent_id_index` (`parent_id`),
  KEY `menu_nodes_related_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_nodes`
--

INSERT INTO `menu_nodes` VALUES (1,1,0,0,NULL,'/',NULL,0,'Home',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,1,0,0,NULL,'/rooms',NULL,0,'Rooms',NULL,'_self',1,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(3,1,2,0,NULL,'/rooms/luxury-hall-of-fame',NULL,0,'Luxury Hall Of Fame',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(4,1,2,0,NULL,'/rooms/pendora-fame',NULL,1,'Pendora Fame',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(5,1,0,2,'Botble\\Page\\Models\\Page','/news',NULL,0,'News',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(6,1,0,3,'Botble\\Page\\Models\\Page','/contact',NULL,0,'Contact',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(7,2,0,6,'Botble\\Page\\Models\\Page','/about-us',NULL,0,'About Us',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(8,2,0,5,'Botble\\Page\\Models\\Page','/our-gallery',NULL,0,'Our Gallery',NULL,'_self',1,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(9,2,8,0,NULL,'/galleries/king-bed',NULL,0,'King Bed',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(10,2,8,0,NULL,'/galleries/duplex-restaurant',NULL,1,'Duplex Restaurant',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(11,2,0,4,'Botble\\Page\\Models\\Page','/restaurant',NULL,0,'Restaurant',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(12,2,0,7,'Botble\\Page\\Models\\Page','/places',NULL,0,'Places',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(13,2,0,8,'Botble\\Page\\Models\\Page','/our-offers',NULL,0,'Our Offers',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(14,3,0,0,NULL,'#',NULL,0,'Restaurant & Bar',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(15,3,0,0,NULL,'#',NULL,0,'Swimming Pool',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(16,3,0,0,NULL,'#',NULL,0,'Restaurant',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(17,3,0,0,NULL,'#',NULL,0,'Conference Room',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(18,3,0,0,NULL,'#',NULL,0,'Cocktail Party Houses',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(19,3,0,0,NULL,'#',NULL,0,'Gaming Zone',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(20,3,0,0,NULL,'#',NULL,0,'Marriage Party',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(21,3,0,0,NULL,'#',NULL,0,'Party Planning',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57'),(22,3,0,0,NULL,'#',NULL,0,'Tour Consultancy',NULL,'_self',0,'2021-01-05 03:29:57','2021-01-05 03:29:57');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Header menu','header-menu','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,'Our pages','our-pages','published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(3,'Services.','services','published','2021-01-05 03:29:57','2021-01-05 03:29:57');

--
-- Table structure for table `meta_boxes`
--

CREATE TABLE `meta_boxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_id` int(10) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `meta_boxes_content_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_boxes`
--

INSERT INTO `meta_boxes` VALUES (1,1,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Category','2020-09-03 09:24:14','2020-09-03 09:24:14'),(2,1,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Post','2020-09-03 09:24:36','2020-09-03 09:24:36'),(3,1,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Tag','2020-09-03 09:24:37','2020-09-03 09:24:37'),(4,2,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Tag','2020-09-03 09:24:37','2020-09-03 09:24:37'),(5,2,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Post','2020-09-03 09:25:13','2020-09-03 09:25:13'),(6,3,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Post','2020-09-03 09:25:44','2020-09-03 09:25:44'),(7,4,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Post','2020-09-03 09:50:38','2020-09-03 09:50:38'),(10,2,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Category','2020-09-04 06:55:24','2020-09-04 06:55:24'),(11,3,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Category','2020-09-04 06:55:50','2020-09-04 06:55:50'),(12,4,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Blog\\Models\\Category','2020-09-04 06:56:15','2020-09-04 06:56:15'),(15,1,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:56:27','2020-09-04 20:56:27'),(16,2,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:56:55','2020-09-04 20:56:55'),(17,3,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 20:57:42','2020-09-04 20:57:42'),(19,4,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:21:02','2020-09-04 21:21:02'),(20,5,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:21:53','2020-09-04 21:21:53'),(21,6,'seo_meta','[{\"seo_title\":null,\"seo_description\":null}]','Botble\\Gallery\\Models\\Gallery','2020-09-04 21:22:25','2020-09-04 21:22:25');

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

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=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2013_04_09_032329_create_base_tables',1),(2,'2013_04_09_062329_create_revisions_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2016_06_10_230148_create_acl_tables',1),(6,'2016_06_14_230857_create_menus_table',1),(7,'2016_06_28_221418_create_pages_table',1),(8,'2016_10_05_074239_create_setting_table',1),(9,'2016_11_28_032840_create_dashboard_widget_tables',1),(10,'2016_12_16_084601_create_widgets_table',1),(11,'2017_05_09_070343_create_media_tables',1),(12,'2017_11_03_070450_create_slug_table',1),(13,'2019_01_05_053554_create_jobs_table',1),(14,'2019_05_03_000001_create_customer_columns',1),(15,'2019_05_03_000002_create_subscriptions_table',1),(16,'2019_05_03_000003_create_subscription_items_table',1),(17,'2019_07_15_042406_change_site_title_from_settings_to_theme_options',1),(18,'2019_08_13_033145_remove_unused_columns_in_users_table',1),(19,'2019_08_19_000000_create_failed_jobs_table',1),(20,'2019_09_07_030654_update_menu_nodes_table',1),(21,'2019_09_07_045041_update_slugs_table',1),(22,'2019_09_07_050405_update_slug_reference_for_page',1),(23,'2019_09_08_014859_update_meta_boxes_table',1),(24,'2019_09_08_015629_update_meta_box_data_for_page',1),(25,'2019_09_12_073711_update_media_url',1),(26,'2019_09_12_073711_update_media_url_for_current_data',1),(27,'2019_10_20_002256_remove_parent_id_in_pages_table',1),(28,'2020_03_28_020724_make_column_user_id_nullable_table_revisions',1),(45,'2018_07_09_214610_create_testimonial_table',3),(46,'2018_07_09_221238_create_faq_table',4),(58,'2020_09_03_152245_add_company_to_testimonials_table',8),(59,'2020_09_03_153420_add_status_to_testimonials_table',9),(60,'2015_06_18_033822_create_blog_table',10),(61,'2019_09_07_035526_update_menu_node_reference_type_for_category',10),(62,'2019_09_07_050058_update_slug_reference_for_blog',10),(63,'2019_09_07_155716_update_language_meta_for_blog',10),(64,'2019_09_08_015552_update_meta_box_data_for_blog',10),(65,'2019_10_20_002342_remove_parent_id_in_tags_table',10),(68,'2016_06_17_091537_create_contacts_table',12),(69,'2015_06_29_025744_create_audit_history',13),(70,'2016_10_07_193005_create_translations_table',14),(71,'2020_09_05_021519_add_column_description_into_table_ht_foods',15),(72,'2016_10_13_150201_create_galleries_table',16),(73,'2019_09_07_050253_update_slug_reference_for_gallery',16),(74,'2019_09_07_155917_update_language_meta_for_gallery',16),(75,'2019_09_08_032534_update_gallery_meta_table',16),(96,'2020_09_02_033611_hotel_create_table',17),(97,'2017_05_18_080441_create_payment_tables',18),(98,'2020_02_03_144309_update_column_payment_channel',18),(99,'2020_02_11_133026_add_description_to_table_payments',18),(100,'2020_03_23_093053_update_payments_table',18),(101,'2020_10_05_030817_make_column_charge_id_nullable',19),(102,'2020_10_18_134416_fix_audit_logs_table',20),(104,'2020_10_20_031058_create_taxes_table',21),(105,'2021_02_16_092633_remove_default_value_for_author_type',22),(106,'2021_03_27_144913_add_customer_type_into_table_payments',23);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(4) NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Homepage','<div>[home-banner][/home-banner]</div><div>[check-availability-form][/check-availability-form]</div><div>[hotel-about title=\"since 1994\" description=\"Situated In Prime Position At The Foot Of The Slopes Of Courchevel Moriond.\" block_icon_1=\"flaticon-coffee\" block_text_1=\"Breakfast\" block_icon_2=\"flaticon-air-freight\" block_text_2=\"Airport Pickup\" block_icon_3=\"flaticon-marker\" block_text_3=\"City Guide\" block_icon_4=\"flaticon-barbecue\" block_text_4=\"BBQ Party\" block_icon_5=\"flaticon-hotel\" block_text_5=\"Luxury Room\"][/hotel-about]</div><div>[room-categories title=\"Room Type\" sub_title=\"Inspired Loding\" background_image=\"general/bg.jpg\"][/room-categories]</div><div>[hotel-featured-features title=\"The Thin Escape\" description=\"Miranda has everything for your trip & every single things.\" button_text=\"Take a tour\" button_url=\"/rooms\"][/hotel-featured-features]</div><div>[rooms][/rooms]</div><div>[video-introduction title=\"Take a tour\" sub_title=\"Discover Our Underground.\" description=\"Lorem ipsum dolor sit amet, consectetur adipisicing 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.\" background_image=\"general/video-background-02.jpg\" video_image=\"general/video-banner-01.jpg\" video_url=\"https://www.youtube.com/watch?v=EEJFMdfraVY\" button_text=\"Book Now\" button_url=\"/rooms\"][/video-introduction]</div><div>[testimonial title=\"testimonials\" description=\"Client Feedback\"][/testimonial]</div><div>[rooms-introduction title=\"Our rooms\" description=\"Each of our nine lovely double guest rooms feature a private bath, wi-fi, cable television and include full breakfast.\" background_image=\"general/bg.jpg\" first_image=\"general/01.jpg\" second_image=\"general/02.jpg\" third_image=\"general/03.jpg\" button_text=\"Take a tour\" button_url=\"/rooms\"][/rooms-introduction]</div><div>[featured-news title=\"Blog\" description=\"News Feeds\"][/featured-news]</div>',1,NULL,'homepage',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(2,'News','<p>--</p>',1,NULL,'default',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(3,'Contact','<div>[contact-info][/contact-info]</div><div>[google-map]19/A, Cirikon City hall Tower New York, NYC[/google-map]</div><div>[contact-form][/contact-form]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(4,'Restaurant','<div>[food-types][/food-types]</div><div>[foods title=\"Restaurant\" sub_title=\"Trending Menu\"][/foods]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(5,'Our Gallery','<div>[all-galleries title=\"Gallery\" sub_title=\"Our Rooms\"][/all-galleries]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(6,'About us','<div>[youtube-video url=\"https://www.youtube.com/watch?v=EEJFMdfraVY\" background_image=\"general/04.jpg\"][/youtube-video]</div><p>Hello. Our hotel has been present for over 20 years. We make the best or all our customers. Hello. Our hotel has been present for over 20 years. We make the best or all our customers. Hello. Our hotel has been present for over 20 years. We make the best or all our customers.</p><div>[hotel-core-features title=\"Facilities\" sub_title=\"Core Features\"][/hotel-core-features]</div><div>[featured-news title=\"Blog\" description=\"News Feeds\"][/featured-news]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(7,'Places','<div>[places][/places]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57'),(8,'Our Offers','<div>[our-offers][/our-offers]</div>',1,NULL,'no-sidebar',0,NULL,'published','2021-01-05 03:29:57','2021-01-05 03:29:57');

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

CREATE TABLE `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 `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(15,2) unsigned NOT NULL,
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `charge_id` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'confirm',
  `customer_id` int(10) unsigned DEFAULT NULL,
  `refunded_amount` decimal(15,2) unsigned DEFAULT NULL,
  `refund_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_categories`
--

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

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tag_id` int(10) unsigned NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` VALUES (1,1,1),(2,2,1),(3,1,2),(4,2,2),(5,1,3),(6,2,3),(7,1,4),(8,2,4);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `format_type` varchar(30) 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1,'Each of our 8 double rooms has its own distinct.','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/01-1.jpg',4,NULL,'2020-09-03 09:24:36','2020-09-04 06:39:31'),(2,'Each of our 8 double rooms has its own distinct.','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/02.jpg',4,NULL,'2020-09-03 09:25:13','2020-09-04 06:39:31'),(3,'Each of our 8 double rooms has its own distinct.','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/03.jpg',4,NULL,'2020-09-03 09:25:44','2020-09-04 06:39:31'),(4,'Each of our 8 double rooms has its own distinct.','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','published',1,'Botble\\ACL\\Models\\User',1,'news/01.jpg',4,NULL,'2020-09-03 09:50:38','2020-09-04 06:39:31');

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_users_user_id_index` (`user_id`),
  KEY `role_users_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--


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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`),
  KEY `roles_created_by_index` (`created_by`),
  KEY `roles_updated_by_index` (`updated_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` VALUES (1,'theme--site_title','Hotel Miranda',NULL,NULL),(2,'theme--show_site_name','0',NULL,NULL),(3,'theme--seo_title','Hotel Miranda',NULL,NULL),(4,'theme--seo_description','',NULL,NULL),(5,'membership_authorization_at','2020-09-17 07:25:49',NULL,NULL),(6,'activated_plugins','[\"hotel\",\"testimonial\",\"faq\",\"blog\",\"contact\",\"audit-log\",\"analytics\",\"backup\",\"captcha\",\"cookie-consent\",\"translation\",\"gallery\",\"payment\",\"paystack\",\"razorpay\"]',NULL,NULL),(7,'theme--seo_og_image','',NULL,NULL),(8,'theme--copyright','© 2020 Miranda. All right reserved.',NULL,NULL),(9,'theme--favicon','general/favicon.png',NULL,NULL),(10,'theme--logo','general/logo.png',NULL,NULL),(11,'theme--logo_white','general/logo-white.png',NULL,NULL),(12,'theme--about-us','Lorem ipsum dolor sit amet, consect etur adipisicing elit, sed doing eius mod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitat ion ullamco laboris nisi.',NULL,NULL),(13,'theme--hotline','+908 987 877 09',NULL,NULL),(14,'theme--address','14/A, Miranda City, NYC',NULL,NULL),(15,'theme--email','info@webmail.com',NULL,NULL),(16,'theme--facebook','https://www.facebook.com',NULL,NULL),(17,'theme--twitter','https://twitter.com',NULL,NULL),(18,'theme--youtube','https://youtube.com',NULL,NULL),(19,'theme--behance','https://www.behance.net',NULL,NULL),(20,'theme--traveloka','',NULL,NULL),(21,'theme--linkedin','https://linkedin.com',NULL,NULL),(22,'theme--term_of_use_url','#',NULL,NULL),(23,'theme--privacy_policy_url','#',NULL,NULL),(24,'theme--slider-image-1','sliders/04.jpg',NULL,NULL),(25,'theme--slider-title-1','The ultimate luxury experience',NULL,NULL),(26,'theme--slider-description-1','<p>The Perfect<br>\nBase For You</p>',NULL,NULL),(27,'theme--slider-primary-button-text-1','Take A tour',NULL,NULL),(28,'theme--slider-primary-button-url-1','/rooms',NULL,NULL),(29,'theme--slider-secondary-button-text-1','Learn more',NULL,NULL),(30,'theme--slider-secondary-button-url-1','/about-us',NULL,NULL),(31,'theme--slider-image-2','sliders/05.jpg',NULL,NULL),(32,'theme--slider-title-2','The ultimate luxury experience',NULL,NULL),(33,'theme--slider-description-2','<p>The Perfect<br>\nBase For You</p>',NULL,NULL),(34,'theme--slider-primary-button-text-2','Take A tour',NULL,NULL),(35,'theme--slider-primary-button-url-2','/rooms',NULL,NULL),(36,'theme--slider-secondary-button-text-2','Learn more',NULL,NULL),(37,'theme--slider-secondary-button-url-2','/about-us',NULL,NULL),(38,'theme--news_banner','general/banner-news.jpg',NULL,NULL),(39,'theme--number_of_posts_in_a_category','12',NULL,NULL),(40,'theme--number_of_posts_in_a_tag','12',NULL,NULL),(41,'admin_email','admin@botble.com',NULL,NULL),(42,'time_zone','UTC',NULL,NULL),(43,'locale','en',NULL,NULL),(44,'enable_send_error_reporting_via_email','0',NULL,NULL),(47,'admin_title','Botble Technologies',NULL,NULL),(48,'rich_editor','ckeditor',NULL,NULL),(49,'default_admin_theme','default',NULL,NULL),(50,'enable_change_admin_theme','1',NULL,NULL),(51,'enable_multi_language_in_admin','1',NULL,NULL),(52,'enable_cache','0',NULL,NULL),(53,'cache_time','10',NULL,NULL),(54,'cache_admin_menu_enable','0',NULL,NULL),(57,'cache_time_site_map','3600',NULL,NULL),(58,'show_admin_bar','1',NULL,NULL),(59,'blog_page_id','2',NULL,NULL),(60,'permalink-botble-page-models-page','',NULL,NULL),(61,'permalink-botble-hotel-models-roomtype','rooms',NULL,NULL),(62,'permalink-botble-hotel-models-food','foods',NULL,NULL),(63,'permalink-botble-blog-models-post','news',NULL,NULL),(64,'permalink-botble-blog-models-category','news',NULL,NULL),(65,'permalink-botble-blog-models-tag','news',NULL,NULL),(66,'theme--rooms_banner','general/banner-news.jpg',NULL,NULL),(67,'theme--hotel_rules','<ul><li>No smoking, parties or events.</li>\n	<li>Check-in time from 2 PM, check-out by 10 AM.</li>\n	<li>Time to time car parking</li>\n	<li>Download Our minimal app</li>\n	<li>Browse regular our website</li>\n</ul>',NULL,NULL),(68,'theme--cancellation','<p>Phasellus volutpat neque a tellus venenatis, a euismod augue facilisis. Fusce ut metus mattis, consequat metus nec, luctus lectus. Pellentesque orci quis hendrerit sed eu dolor. <strong>Cancel up</strong> to <strong>14 days</strong> to get a full refund.</p>',NULL,NULL),(71,'show_on_front','1',NULL,NULL),(77,'enable_captcha','0',NULL,NULL),(78,'captcha_type','v2',NULL,NULL),(79,'theme--cookie_consent_enable','yes',NULL,NULL),(80,'theme--cookie_consent_message','Your experience on this site will be improved by allowing cookies.',NULL,NULL),(81,'theme--cookie_consent_button_text','Allow cookies',NULL,NULL),(84,'payment_cod_status','1',NULL,NULL),(85,'payment_cod_description','Please pay money directly to the postman, if you choose cash on delivery method (COD).',NULL,NULL),(86,'payment_bank_transfer_status','1',NULL,NULL),(87,'payment_bank_transfer_description','Please send money to our bank account: ACB - 1990 404 19.',NULL,NULL);

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_plan_unique` (`subscription_id`,`stripe_plan`),
  KEY `subscription_items_stripe_id_index` (`stripe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'hotel',1,'Botble\\ACL\\Models\\User','','published','2020-09-03 09:24:36','2020-09-03 09:24:36'),(2,'booking',1,'Botble\\ACL\\Models\\User','','published','2020-09-03 09:24:37','2020-09-03 09:24:37');

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,'Donald H. Hilixer','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','testimonials/01.png','2020-09-03 08:18:53','2020-09-03 08:25:18','Founder, Hilix','published'),(2,'Rosalina D. William','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','testimonials/03.png','2020-09-03 08:25:59','2020-09-03 08:26:34','Founder, qux co.','published'),(3,'Browfish Dumble','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>','testimonials/02.png','2020-09-03 08:27:04','2020-09-03 08:27:04','Founder, Condo','published');

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL DEFAULT '0',
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2627 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `translations`
--



--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_meta`
--


--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sidebar_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `data` text COLLATE utf8mb4_unicode_ci,
  `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;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (2,'CustomMenuWidget','footer_sidebar','miranda',0,'{\"id\":\"CustomMenuWidget\",\"name\":\"Services.\",\"menu_id\":\"services\"}','2020-09-03 07:39:40','2020-09-03 07:39:40'),(19,'RecentPostsWidget','primary_sidebar','miranda',0,'{\"id\":\"RecentPostsWidget\",\"name\":\"Recent posts\",\"number_display\":\"5\"}','2020-09-04 07:00:46','2020-09-04 07:00:46'),(20,'BlogCategoriesWidget','primary_sidebar','miranda',1,'{\"id\":\"BlogCategoriesWidget\",\"name\":\"Categories\",\"number_display\":\"5\"}','2020-09-04 07:00:46','2020-09-04 07:00:46'),(21,'BlogTagsWidget','primary_sidebar','miranda',2,'{\"id\":\"BlogTagsWidget\",\"name\":\"Popular Tags\",\"number_display\":\"5\"}','2020-09-04 07:00:46','2020-09-04 07:00:46');


