-- Table structure for table `bravo_services`
--

CREATE TABLE `bravo_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lng` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `star_rate` tinyint(4) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `min_people` int(11) DEFAULT NULL,
  `max_people` int(11) DEFAULT NULL,
  `max_guests` int(11) DEFAULT NULL,
  `review_score` int(11) DEFAULT NULL,
  `min_day_before_booking` int(11) DEFAULT NULL,
  `min_day_stays` int(11) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `object_model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_services`
--

INSERT INTO `bravo_services` (`id`, `title`, `slug`, `category_id`, `location_id`, `address`, `map_lat`, `map_lng`, `is_featured`, `star_rate`, `price`, `sale_price`, `min_people`, `max_people`, `max_guests`, `review_score`, `min_day_before_booking`, `min_day_stays`, `object_id`, `object_model`, `status`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `author_id`) VALUES
(1, 'Remington Collier II', 'remington-collier-ii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(2, 'Enrique Aufderhar', 'enrique-aufderhar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 2, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(3, 'Hattie Moen', 'hattie-moen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 3, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(4, 'Dr. Price McDermott', 'dr-price-mcdermott', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 4, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(5, 'Prof. Triston Wilderman DVM', 'prof-triston-wilderman-dvm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 5, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(6, 'Arely Heller', 'arely-heller', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 6, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(7, 'Prof. Cecile Daniel', 'prof-cecile-daniel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 7, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(8, 'Brown Roberts III', 'brown-roberts-iii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 8, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(9, 'Khalid Murazik', 'khalid-murazik', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 9, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(10, 'Samara Vandervort', 'samara-vandervort', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 10, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(11, 'Maribel Goodwin Sr.', 'maribel-goodwin-sr', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 11, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(12, 'Ms. Kenyatta Howell III', 'ms-kenyatta-howell-iii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 12, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(13, 'Eleazar Friesen', 'eleazar-friesen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 13, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(14, 'Dr. Jacey Rempel II', 'dr-jacey-rempel-ii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 14, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(15, 'Vilma VonRueden', 'vilma-vonrueden', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 15, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(16, 'Kelli Langosh', 'kelli-langosh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 16, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(17, 'Reymundo Dickinson Jr.', 'reymundo-dickinson-jr', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 17, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(18, 'Wallace Walsh MD', 'wallace-walsh-md', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 18, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(19, 'Aglae Weimann', 'aglae-weimann', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 19, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(20, 'Lelia Rippin', 'lelia-rippin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 20, 'flight', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:14', '2023-03-14 13:16:17', NULL),
(21, 'The May Fair Hotel', 'the-may-fair-hotel', NULL, 1, 'Paris Cinemas Battery', '19.277696', '72.887009', 0, 4, 550.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 11, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(22, 'Dylan Hotel', 'dylan-hotel', NULL, 2, 'Regal Cinemas Battery', '19.229727', '72.984470', 1, 5, 550.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 10, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(23, 'Parian Holiday Villas', 'parian-holiday-villas', NULL, 1, 'Regal Cinemas Battery Park', '19.161637', '72.997510', 1, 5, 550.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 9, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(24, 'Stewart Hotel', 'stewart-hotel', NULL, 5, 'New York', '19.080542', '73.010551', 0, 5, 900.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 8, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(25, 'Crowne Plaza Hotel', 'crowne-plaza-hotel', NULL, 2, 'New York', '19.001355', '73.111444', 0, 5, 900.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 7, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 6),
(26, 'EnVision Hotel Boston', 'envision-hotel-boston', NULL, 3, 'New York', '18.873011', '72.975724', 0, 5, 700.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 6, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(27, 'Studio Allston Hotel', 'studio-allston-hotel', NULL, 5, 'New York', '18.972786', '72.819724', 0, 5, 500.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 5, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(28, 'Redac Gateway Hotel', 'redac-gateway-hotel', NULL, 1, 'Petit-Montrouge', '19.031217', '72.851982', 0, 5, 500.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 4, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(29, 'Castello Casole Hotel', 'castello-casole-hotel', NULL, 1, 'Petit-Montrouge', '19.077946', '72.838255', 0, 5, 350.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 3, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(30, 'Hotel WBF Hommachi', 'hotel-wbf-hommachi', NULL, 1, 'Porte de Vanves', '19.110390', '72.832764', 0, 5, 350.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 2, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(31, 'Hotel Stanford', 'hotel-stanford', NULL, 1, 'Arrondissement de Paris', '19.148665', '72.839670', 0, 5, 300.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 1, 'hotel', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(32, 'STAY GREENWICH VILLAGE', 'stay-greenwich-village', NULL, 1, 'Porte de Vanves', '51.514892', '-0.176181', 0, NULL, 300.00, 150.00, NULL, NULL, 9, 5, NULL, NULL, 11, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(33, 'LILY DALE VILLAGE', 'lily-dale-village', NULL, 1, 'Porte de Vanves', '51.517883', '-0.134314', 1, NULL, 250.00, 0.00, NULL, NULL, 9, 5, NULL, NULL, 10, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(34, 'LUXURY SINGLE', 'luxury-single', NULL, 1, 'Porte de Vanves', '51.569555', '0.012563', 0, NULL, 400.00, 350.00, NULL, NULL, 5, 5, NULL, NULL, 9, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(35, 'PARIS GREENWICH VILLA', 'paris-greenwich-villa', NULL, 1, 'Porte de Vanves', '51.556749', '-0.091124', 1, NULL, 500.00, 0.00, NULL, NULL, 9, 5, NULL, NULL, 8, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(36, 'EAST VILLAGE', 'east-village', NULL, 1, 'Porte de Vanves', '51.524292', '-0.022489', 1, NULL, 300.00, 260.00, NULL, NULL, 10, 5, NULL, NULL, 7, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(37, 'THE MEATPACKING SUITES', 'the-meatpacking-suites', NULL, 1, 'Porte de Vanves', '51.475135', '0.003592', 1, NULL, 320.00, 0.00, NULL, NULL, 6, 4, NULL, NULL, 6, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 6),
(38, 'DUPLEX GREENWICH', 'duplex-greenwich', NULL, 1, 'Porte de Vanves', '51.442192', '-0.043778', 0, NULL, 220.00, 0.00, NULL, NULL, 8, 5, NULL, NULL, 5, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(39, 'BEST OF WEST VILLAGE', 'best-of-west-village', NULL, 4, 'Porte de Vanves', '51.427638', '-0.170752', 1, NULL, 800.00, 0.00, NULL, NULL, 5, 4, NULL, NULL, 4, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(40, 'BEAUTIFUL LOFT', 'beautiful-loft', NULL, 3, 'Porte de Vanves', '51.461875', '-0.211246', 0, NULL, 650.00, 0.00, NULL, NULL, 8, 5, NULL, NULL, 3, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(41, 'LUXURY APARTMENT', 'luxury-apartment', NULL, 3, 'Porte de Vanves', '51.519592', '-0.226346', 0, NULL, 900.00, 0.00, NULL, NULL, 9, 5, NULL, NULL, 2, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(42, 'LUXURY STUDIO', 'luxury-studio', NULL, 2, 'Arrondissement de Paris', '51.528564', '-0.203010', 0, NULL, 300.00, 191.00, NULL, NULL, 5, 5, NULL, NULL, 1, 'space', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(43, 'Vinfast Fadil Standard', 'vinfast-fadil-standard', NULL, 1, 'Arrondissement de Paris', '21.053326', '105.841475', NULL, NULL, 400.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 13, 'car', 'draft', 1, 1, '2023-04-17 11:07:28', '2023-03-14 13:16:15', '2023-04-17 11:07:28', NULL),
(44, 'Vinfast Lux A2.0 Plus', 'vinfast-lux-a20-plus', NULL, 3, 'Arrondissement de Paris', '21.051244', '105.777988', 1, NULL, 350.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 12, 'car', 'publish', 1, 1, '2023-05-14 20:10:36', '2023-03-14 13:16:15', '2023-05-14 20:10:36', NULL),
(45, 'Vinfast Lux V8 (SUV)', 'vinfast-lux-v8-suv', NULL, 8, 'Arrondissement de Paris', '21.020001', '105.836670', 1, NULL, 250.00, 0.00, NULL, NULL, NULL, 0, NULL, NULL, 11, 'car', 'publish', 1, 1, '2023-05-14 20:10:36', '2023-03-14 13:16:15', '2023-05-14 20:10:36', NULL),
(46, 'Toyota Prius Plus', 'toyota-prius-plus', NULL, 7, 'Arrondissement de Paris', '21.025449', '105.804412', 1, NULL, 199.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 10, 'car', 'publish', 1, 1, '2023-04-17 10:59:12', '2023-03-14 13:16:15', '2023-04-17 10:59:12', NULL),
(47, 'Honda Civic', 'honda-civic', NULL, 6, 'Arrondissement de Paris', '21.047879', '105.809731', 1, NULL, 450.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 9, 'car', 'publish', 1, NULL, '2023-04-17 10:59:12', '2023-03-14 13:16:15', '2023-04-17 10:59:12', NULL),
(48, 'Vinfast Lux SA2.0 Plus', 'vinfast-lux-sa20-plus', NULL, 1, 'Arrondissement de Paris', '21.017437', '105.831179', 1, NULL, 600.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 8, 'car', 'publish', 1, 1, '2023-05-14 20:10:36', '2023-03-14 13:16:15', '2023-05-14 20:10:36', NULL),
(49, 'Mercedes Benz', 'mercedes-benz', NULL, 1, 'Arrondissement de Paris', '21.025769', '105.829635', 0, NULL, 200.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 7, 'car', 'publish', 1, NULL, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(50, 'Vinfast Fadil Plus', 'vinfast-fadil-plus', NULL, 1, 'Arrondissement de Paris', '21.018398', '105.812820', 1, NULL, 400.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 6, 'car', 'publish', 1, NULL, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(51, '2019 Audi S3', '2019-audi-s3', NULL, 5, 'Arrondissement de Paris', '21.014873', '105.794117', 1, NULL, 300.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 5, 'car', 'publish', 1, NULL, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(52, '2019 BMW M6 Gran Coupe', '2019-bmw-m6-gran-coupe', NULL, 1, 'Arrondissement de Paris', '21.020161', '105.789655', 1, NULL, 300.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 4, 'car', 'publish', 1, 1, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(53, '2019 Honda Clarity', '2019-honda-clarity', NULL, 3, 'Arrondissement de Paris', '21.031217', '105.773698', 0, NULL, 300.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 3, 'car', 'publish', 1, 1, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(54, '2019 Honda Clarity', '2019-honda-clarity-1', NULL, 1, 'Arrondissement de Paris', '21.039771', '105.777203', 1, NULL, 300.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 2, 'car', 'publish', 1, NULL, '2023-04-17 10:19:07', '2023-03-14 13:16:15', '2023-04-17 10:19:07', NULL),
(55, 'BMW-X6-facelift', 'bmw-x6-facelift', NULL, 1, 'Arrondissement de Paris', '21.054831', '105.796077', 1, NULL, 500.00, 240.00, NULL, NULL, NULL, 5, NULL, NULL, 1, 'car', 'publish', 1, NULL, '2023-04-17 10:43:26', '2023-03-14 13:16:15', '2023-04-17 10:43:26', NULL),
(56, 'Event of Washington, D.C. Highlights', 'event-of-washington-dc-highlights', NULL, 7, 'Francisco Parnassus Campus', '37.782668', '-122.425058', 1, NULL, 2100.00, 417.00, NULL, NULL, NULL, 4, NULL, NULL, 12, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(57, 'New York – Discover America', 'new-york-discover-america', NULL, 6, 'New Jersey', '40.035329', '-74.417227', 1, NULL, 300.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 11, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(58, 'Origami Crane Wedding Planners', 'origami-crane-wedding-planners', NULL, 5, 'Washington, DC, USA', '34.049345', '-118.248479', 0, NULL, 400.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 10, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(59, 'Northern Lights Event Planners', 'northern-lights-event-planners', NULL, 4, 'United States', '37.040023', '-95.643144', 1, NULL, 800.00, 600.00, NULL, NULL, NULL, 5, NULL, NULL, 9, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 6),
(60, 'Pink Crescent Moon Events', 'pink-crescent-moon-events', NULL, 3, 'Trimmer Springs Rd, Sanger', '36.822484', '-119.365266', 0, NULL, 700.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 8, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 6),
(61, 'Eastern Discovery', 'eastern-discovery', NULL, 2, 'Pier 36 New York', '40.708581', '-73.998817', 0, NULL, 2100.00, 1038.00, NULL, NULL, NULL, 4, NULL, NULL, 7, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 6),
(62, 'Spanish Moss Event Design', 'spanish-moss-event-design', NULL, 2, 'Prince St Station', '40.720161', '-74.009628', 1, NULL, 600.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 6, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(63, 'Southwest States (Ex Los Angeles) ', 'southwest-states-ex-los-angeles', NULL, 2, 'Regal Cinemas Battery Park 11', '40.714578', '-73.983888', 0, NULL, 1900.00, 1729.00, NULL, NULL, NULL, 4, NULL, NULL, 5, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 5),
(64, 'Aspen Glade Weddings & Events', 'aspen-glade-weddings-events', NULL, 2, 'New York', '40.707891', '-74.008825', 1, NULL, 850.00, 0.00, NULL, NULL, NULL, 5, NULL, NULL, 4, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(65, 'Bamboo Grove Event Planning', 'bamboo-grove-event-planning', NULL, 1, 'Petit-Montrouge', '48.884900', '2.346377', 1, NULL, 1500.00, 647.00, NULL, NULL, NULL, 4, NULL, NULL, 3, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(66, 'Painted Desert Event Designs', 'painted-desert-event-designs', NULL, 1, 'Porte de Vanves', '48.853917', '2.307199', 1, NULL, 900.00, 250.00, NULL, NULL, NULL, 5, NULL, NULL, 2, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(67, 'Andante & Allegro Event Design', 'andante-allegro-event-design', NULL, 1, 'Arrondissement de Paris', '48.852754', '2.339155', 0, NULL, 2000.00, 0.00, NULL, NULL, NULL, 4, NULL, NULL, 1, 'event', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(68, 'River Cruise Tour on the Seine', 'river-cruise-tour-on-the-seine', 2, 1, 'Nevada, US', '36.401066', '-88.312292', 0, NULL, 2100.00, 1267.00, 1, 10, NULL, 5, NULL, NULL, 16, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(69, 'Cannes and Antibes Night Tour', 'cannes-and-antibes-night-tour', 2, 1, 'UCSF Helen Diller Family', '36.201066', '-88.112292', 0, NULL, 2100.00, 1203.00, 1, 15, NULL, 4, NULL, NULL, 15, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(70, 'San Francisco Express Never Ceases', 'san-francisco-express-never-ceases', 4, 7, 'Comprehensive Cancer Center', '37.757522', '-122.447984', 0, NULL, 2100.00, 261.00, 1, 16, NULL, 4, NULL, NULL, 14, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(71, 'Hollywood Sign Small Group Tour in Luxury Van', 'hollywood-sign-small-group-tour-in-luxury-van', 1, 8, 'Virginia', '37.445688', '-78.673668', 0, NULL, 2100.00, 644.00, 1, 17, NULL, 4, NULL, NULL, 13, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 4),
(72, 'Segway Tour of Washington, D.C. Highlights', 'segway-tour-of-washington-dc-highlights', 3, 7, 'Francisco Parnassus Campus', '37.782668', '-122.425058', 0, NULL, 2100.00, 505.00, 1, 19, NULL, 4, NULL, NULL, 12, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:15', '2023-03-14 13:16:17', 1),
(73, 'Trip of New York – Discover America', 'trip-of-new-york-discover-america', 3, 6, 'New Jersey', '40.035329', '-74.417227', 0, NULL, 2100.00, 344.00, 1, 17, NULL, 4, NULL, NULL, 11, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(74, 'Giverny and Versailles Small Group Day Trip', 'giverny-and-versailles-small-group-day-trip', 3, 5, 'Washington, DC, USA', '34.049345', '-118.248479', 0, NULL, 2100.00, 619.00, 1, 13, NULL, 5, NULL, NULL, 10, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 5),
(75, 'Tastes and Sounds of the South 2019', 'tastes-and-sounds-of-the-south-2019', 3, 4, 'United States', '37.040023', '-95.643144', 0, NULL, 2100.00, 307.00, 1, 14, NULL, 4, NULL, NULL, 9, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(76, 'Pure Luxe in Punta Mita', 'pure-luxe-in-punta-mita', 4, 3, 'Trimmer Springs Rd, Sanger', '36.822484', '-119.365266', 0, NULL, 2100.00, 1193.00, 1, 18, NULL, 4, NULL, NULL, 8, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(77, 'Eastern Discovery', 'eastern-discovery-1', 3, 2, 'Pier 36 New York', '40.708581', '-73.998817', 0, NULL, 2100.00, 1346.00, 1, 15, NULL, 4, NULL, NULL, 7, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(78, 'Eastern Discovery (Start New Orleans)', 'eastern-discovery-start-new-orleans', 1, 2, 'Prince St Station', '40.720161', '-74.009628', 1, NULL, 2100.00, 1592.00, 1, 17, NULL, 5, NULL, NULL, 6, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(79, 'Southwest States (Ex Los Angeles) ', 'southwest-states-ex-los-angeles-1', 4, 2, 'Regal Cinemas Battery Park 11', '40.714578', '-73.983888', 0, NULL, 1900.00, 604.00, 1, 18, NULL, 5, NULL, NULL, 5, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(80, 'Tour in Vienna', 'paris-vacation-travel', 1, 24, 'Vienna', '48.210033', '16.363449', 1, NULL, 850.00, 505.00, 1, 13, NULL, 5, NULL, NULL, 4, 'tour', 'publish', 1, 1, NULL, '2023-03-14 13:16:16', '2023-05-29 21:54:30', 1),
(81, 'Los Angeles to San Francisco Express ', 'los-angeles-to-san-francisco-express', 4, 1, 'Petit-Montrouge', '48.884900', '2.346377', 1, NULL, 1500.00, 338.00, 1, 10, NULL, 5, NULL, NULL, 3, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(82, 'New York: Museum of Modern Art', 'new-york-museum-of-modern-art', 4, 1, 'Porte de Vanves', '48.853917', '2.307199', 1, NULL, 900.00, 172.00, 1, 16, NULL, 5, NULL, NULL, 2, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(83, 'American Parks Trail end Rapid City', 'american-parks-trail-end-rapid-city', 4, 1, 'Arrondissement de Paris', '48.852754', '2.339155', 0, NULL, 2000.00, 540.00, 1, 14, NULL, 5, NULL, NULL, 1, 'tour', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(84, 'My Way 100', 'my-way-100', NULL, 1, 'Arrondissement de Paris', '21.053326', '105.841475', 1, NULL, 150.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 13, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 5),
(85, 'Ohana 3X', 'ohana-3x', NULL, 3, 'Arrondissement de Paris', '21.051244', '105.777988', 0, NULL, 80.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 12, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(86, 'Freedom M2', 'freedom-m2', NULL, 8, 'Arrondissement de Paris', '21.020001', '105.836670', 0, NULL, 50.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 11, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(87, 'Endless Summer W-10', 'endless-summer-w-10', NULL, 7, 'Arrondissement de Paris', '21.025449', '105.804412', 1, NULL, 230.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 10, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 6),
(88, 'Destiny 6', 'destiny-6', NULL, 6, 'Arrondissement de Paris', '21.047879', '105.809731', 1, NULL, 180.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 9, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(89, 'Carpe Diem LA', 'carpe-diem-la', NULL, 1, 'Arrondissement de Paris', '21.017437', '105.831179', 1, NULL, 200.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 8, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(90, 'Blue Moon YC-300', 'blue-moon-yc-300', NULL, 1, 'Arrondissement de Paris', '21.025769', '105.829635', 0, NULL, 130.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 7, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 5),
(91, 'Blue Dream TC-20', 'blue-dream-tc-20', NULL, 1, 'Arrondissement de Paris', '21.018398', '105.812820', 1, NULL, 130.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 6, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 4),
(92, 'Andiamo MX-3', 'andiamo-mx-3', NULL, 5, 'Arrondissement de Paris', '21.014873', '105.794117', 0, NULL, 250.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 5, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(93, 'BOAT 1992 ALISON', 'boat-1992-alison', NULL, 1, 'Arrondissement de Paris', '21.020161', '105.789655', 0, NULL, 50.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 4, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(94, 'Blue Moon Cruising', 'blue-moon-cruising', NULL, 3, 'Arrondissement de Paris', '21.031217', '105.773698', 0, NULL, 200.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 3, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(95, 'Summer Breeze', 'summer-breeze', NULL, 1, 'Arrondissement de Paris', '21.039771', '105.777203', 1, NULL, 150.00, NULL, NULL, NULL, NULL, 4, NULL, NULL, 2, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(96, 'Cruising Yacht', 'cruising-yacht', NULL, 1, 'Arrondissement de Paris', '21.054831', '105.796077', 0, NULL, 100.00, NULL, NULL, NULL, NULL, 5, NULL, NULL, 1, 'boat', 'publish', NULL, NULL, NULL, '2023-03-14 13:16:16', '2023-03-14 13:16:17', 1),
(97, 'Test BMW X5', 'test-bmw-x5', NULL, 1, NULL, NULL, NULL, 1, NULL, 180.00, NULL, NULL, NULL, NULL, NULL, 2, 7, 14, 'car', 'publish', 1, NULL, '2023-05-14 20:10:36', '2023-03-29 02:33:12', '2023-05-14 20:10:36', NULL),
(98, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 22231.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'car', NULL, 1, 1, '2023-04-17 11:41:24', '2023-04-17 11:36:48', '2023-04-17 11:41:24', NULL),
(99, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 33.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'car', NULL, 1, NULL, '2023-04-18 08:33:58', '2023-04-17 11:51:53', '2023-04-18 08:33:58', NULL),
(100, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'car', NULL, 1, 1, '2023-04-18 08:34:47', '2023-04-18 08:05:14', '2023-04-18 08:34:47', NULL),
(101, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 'car', NULL, 1, NULL, '2023-04-18 08:40:27', '2023-04-18 08:35:08', '2023-04-18 08:40:27', NULL),
(102, NULL, '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, 'car', NULL, 1, NULL, '2023-04-18 08:40:27', '2023-04-18 08:35:38', '2023-04-18 08:40:27', NULL),
(103, 'sda', 'sda', NULL, 3, 'sdasd', '51.47966951391817', '0.4627496337890724', NULL, NULL, 22.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 'car', 'publish', 1, NULL, '2023-05-14 20:18:12', '2023-05-14 20:17:37', '2023-05-14 20:18:12', NULL),
(104, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14, 'car', NULL, 1, NULL, '2023-05-14 20:33:13', '2023-05-14 20:31:02', '2023-05-14 20:33:13', NULL),
(105, 'test', 'test', NULL, NULL, NULL, '51.41290926091943', '-0.01326736450194321', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16, 'car', 'publish', 1, 1, '2023-05-16 20:42:25', '2023-05-16 20:40:22', '2023-05-16 20:42:25', NULL),
(106, 'Bmw x6', 'bmw-x6', NULL, NULL, NULL, '51.66488676922796', '1.0908586120605568', NULL, NULL, 199999.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17, 'car', 'publish', 1, NULL, '2023-05-16 20:51:55', '2023-05-16 20:48:38', '2023-05-16 20:51:55', NULL),
(107, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15, 'car', NULL, 1, 1, '2023-05-16 20:55:58', '2023-05-16 20:55:08', '2023-05-16 20:55:58', NULL),
(108, 'Mercedes V Class', 'mercedes-v-class', NULL, 24, NULL, NULL, NULL, NULL, NULL, 280.00, 250.00, NULL, NULL, NULL, NULL, 1, 5, 18, 'car', 'publish', 1, 1, '2023-05-17 00:09:43', '2023-05-16 23:56:24', '2023-05-17 00:09:43', NULL),
(109, 'Mercedes V Class - Copy', 'mercedes-v-class-copy', NULL, 24, NULL, NULL, NULL, NULL, NULL, 280.00, 250.00, NULL, NULL, NULL, NULL, 1, 5, 19, 'car', 'publish', 1, 1, '2023-05-17 00:12:35', '2023-05-17 00:00:57', '2023-05-17 00:12:35', NULL),
(110, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16, 'car', NULL, 1, 1, NULL, '2023-05-17 00:08:37', '2023-05-17 00:09:55', NULL),
(111, NULL, '-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17, 'car', NULL, 1, NULL, NULL, '2023-05-17 00:09:10', '2023-05-17 00:09:10', NULL),
(112, 'Toyota Proace', 'toyota-proace', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 320.00, 220.00, NULL, NULL, NULL, NULL, 1, NULL, 20, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:19:15', '2023-06-08 13:29:44', NULL),
(113, 'VW Multivan', 'vw-multivan', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 330.00, 230.00, NULL, NULL, NULL, NULL, 0, 0, 21, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:22:43', '2023-06-08 13:29:50', NULL),
(114, 'Mercedes GLS', 'mercedes-gls', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 290.00, 210.00, NULL, NULL, NULL, NULL, 1, 5, 22, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:26:11', '2023-06-08 13:29:56', NULL),
(115, 'Rang Rover Vouge XL', 'rang-rover-vouge-xl', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 350.00, 290.00, NULL, NULL, NULL, NULL, 1, 5, 23, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:29:59', '2023-06-08 13:30:07', NULL),
(116, 'Audi SQ5', 'audi-sq5', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 320.00, 280.00, NULL, NULL, NULL, NULL, 1, 5, 24, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:33:14', '2023-06-08 13:30:11', NULL),
(117, 'Mercedes G Class 400', 'mercedes-g-class-400', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 590.00, 490.00, NULL, NULL, NULL, NULL, NULL, NULL, 25, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:36:24', '2023-06-08 13:30:15', NULL),
(118, 'Mercedes Vito', 'mercedes-vito', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 280.00, 250.00, NULL, NULL, NULL, NULL, 1, 5, 26, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:38:39', '2023-06-08 13:30:21', NULL),
(119, 'Skoda Suberb', 'skoda-suberb', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 220.00, 180.00, NULL, NULL, NULL, NULL, NULL, NULL, 27, 'car', 'publish', 1, 1, NULL, '2023-05-17 00:41:17', '2023-06-08 13:30:28', NULL),
(120, 'Skoda Suberb - Copy', 'skoda-suberb-copy', NULL, 24, NULL, '51.37692099676258', '0.11256042480469741', NULL, NULL, 180.00, 150.00, NULL, NULL, NULL, NULL, NULL, NULL, 28, 'car', 'publish', 1, NULL, '2023-05-18 13:24:14', '2023-05-18 13:24:02', '2023-05-18 13:24:14', NULL),
(121, 'Skoda Suberb', 'skoda-suberb-copy', NULL, 24, NULL, '51.37692099676258', '0.11256042480469741', NULL, NULL, 180.00, 150.00, NULL, NULL, NULL, NULL, NULL, NULL, 29, 'car', 'publish', 1, 1, '2023-05-18 13:32:13', '2023-05-18 13:25:24', '2023-05-18 13:32:13', NULL),
(122, 'Opel Vivaro', 'opel-vivaro', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 280.00, 180.00, NULL, NULL, NULL, NULL, NULL, NULL, 30, 'car', 'publish', 1, 1, NULL, '2023-05-27 12:39:25', '2023-06-08 13:30:33', NULL),
(123, 'Opel Vivaro', 'opel-vivaro-1', NULL, 24, NULL, NULL, NULL, NULL, NULL, 280.00, 180.00, NULL, NULL, NULL, NULL, NULL, NULL, 31, 'car', 'draft', 1, NULL, '2023-05-27 12:45:23', '2023-05-27 12:42:06', '2023-05-27 12:45:23', NULL),
(124, 'VW Tiguan', 'vw-tiguan', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 240.00, 180.00, NULL, NULL, NULL, NULL, NULL, NULL, 32, 'car', 'publish', 1, 1, NULL, '2023-05-27 12:46:58', '2023-06-08 13:30:40', NULL),
(125, 'Renault Koleos', 'renault-koleos', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 220.00, 170.00, NULL, NULL, NULL, NULL, NULL, NULL, 33, 'car', 'publish', 1, 1, NULL, '2023-05-27 13:59:34', '2023-06-08 13:30:46', NULL),
(126, 'Mercedes E Class', 'mercedes-e-class', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 250.00, 190.00, NULL, NULL, NULL, NULL, NULL, NULL, 34, 'car', 'publish', 1, 1, NULL, '2023-05-27 14:04:36', '2023-06-08 13:30:51', NULL),
(127, 'Mercedes Vito', 'mercedes-vito-1', NULL, 24, NULL, NULL, NULL, NULL, NULL, 350.00, 250.00, NULL, NULL, NULL, NULL, NULL, NULL, 35, 'car', 'publish', 1, 1, '2023-06-08 11:53:09', '2023-05-27 14:13:21', '2023-06-08 11:53:09', NULL),
(128, 'Mercedes Vito', 'mercedes-vito-2', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 350.00, 250.00, NULL, NULL, NULL, NULL, NULL, NULL, 36, 'car', 'publish', 1, 1, NULL, '2023-05-27 14:16:14', '2023-06-08 13:30:57', NULL),
(129, 'VW Caravelle', 'vw-caravelle', NULL, 34, NULL, '52.377956', '4.897070', NULL, NULL, 320.00, 220.00, NULL, NULL, NULL, NULL, NULL, NULL, 37, 'car', 'publish', 1, 1, NULL, '2023-05-27 14:18:43', '2023-06-11 05:01:25', NULL),
(130, 'Mercedes G-Klass', 'mercedes-g-klass', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 650.00, 450.00, NULL, NULL, NULL, NULL, NULL, NULL, 38, 'car', 'publish', 1, 1, NULL, '2023-05-27 14:20:48', '2023-06-08 13:31:06', NULL),
(131, 'Mercedes V Class', 'mercedes-v-class', NULL, 24, NULL, '48.210033', '16.363449', NULL, NULL, 350.00, 250.00, NULL, NULL, NULL, NULL, 1, 5, 18, 'car', 'publish', 1, 1, NULL, '2023-05-27 14:22:10', '2023-06-08 13:31:13', NULL),
(132, 'Toyota VIP Proace', 'toyota-vip-proace', NULL, 24, NULL, NULL, NULL, NULL, NULL, 320.00, 220.00, NULL, NULL, NULL, NULL, NULL, NULL, 39, 'car', 'draft', 1, NULL, '2023-05-27 14:25:49', '2023-05-27 14:24:00', '2023-05-27 14:25:49', NULL),
(133, 'Tour in Salzburg', 'tour-in-salzburg', 1, 25, 'Salzburg', '47.8095', '13.0550', 1, NULL, NULL, NULL, 1, 13, NULL, NULL, NULL, NULL, 17, 'tour', 'publish', 1, 1, NULL, '2023-05-31 07:21:42', '2023-05-31 07:46:36', NULL),
(134, 'Tour in Geneva', 'geneva', 1, 30, 'Geneva', '46.2044', '6.1432', NULL, NULL, NULL, NULL, 1, 13, NULL, NULL, NULL, NULL, 18, 'tour', 'publish', 1, 1, NULL, '2023-05-31 07:47:04', '2023-05-31 07:49:31', NULL),
(135, 'Tour in Paris', 'tour-in-paris', 1, 21, 'Paris', '48.8566', '2.3522', 1, NULL, NULL, NULL, 1, 13, NULL, NULL, NULL, NULL, 19, 'tour', 'publish', 1, NULL, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03', NULL),
(136, 'Tour in Interlaken', 'tour-in-interlaken', 1, 28, 'Interlaken', '46.6863', '7.8632', 1, NULL, NULL, NULL, 1, 13, NULL, NULL, NULL, NULL, 20, 'tour', 'publish', 1, NULL, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bravo_service_translations`
--

CREATE TABLE `bravo_service_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `locale` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `content` text COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_spaces`
--

CREATE TABLE `bravo_spaces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `image_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lng` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `gallery` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `faqs` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `is_instant` tinyint(4) DEFAULT '0',
  `allow_children` tinyint(4) DEFAULT '0',
  `allow_infant` tinyint(4) DEFAULT '0',
  `max_guests` int(11) DEFAULT NULL,
  `bed` int(11) DEFAULT NULL,
  `bathroom` int(11) DEFAULT NULL,
  `square` int(11) DEFAULT NULL,
  `enable_extra_price` tinyint(4) DEFAULT NULL,
  `extra_price` text COLLATE utf8mb4_unicode_ci,
  `discount_by_days` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_state` tinyint(4) DEFAULT '1',
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `review_score` decimal(2,1) DEFAULT NULL,
  `ical_import_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_service_fee` tinyint(4) DEFAULT NULL,
  `service_fee` text COLLATE utf8mb4_unicode_ci,
  `surrounding` text COLLATE utf8mb4_unicode_ci,
  `author_id` bigint(20) DEFAULT NULL,
  `min_day_before_booking` int(11) DEFAULT NULL,
  `min_day_stays` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_spaces`
--

INSERT INTO `bravo_spaces` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `faqs`, `price`, `sale_price`, `is_instant`, `allow_children`, `allow_infant`, `max_guests`, `bed`, `bathroom`, `square`, `enable_extra_price`, `extra_price`, `discount_by_days`, `status`, `default_state`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `review_score`, `ical_import_url`, `enable_service_fee`, `service_fee`, `surrounding`, `author_id`, `min_day_before_booking`, `min_day_stays`) VALUES
(1, 'LUXURY STUDIO', 'luxury-studio', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 63, 84, 2, 'Arrondissement de Paris', '51.528564', '-0.203010', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 300.00, 191.00, 1, 0, 0, 5, 9, 4, 117, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.5, NULL, NULL, NULL, NULL, 1, NULL, NULL),
(2, 'LUXURY APARTMENT', 'luxury-apartment', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 64, 84, 3, 'Porte de Vanves', '51.519592', '-0.226346', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 900.00, 0.00, 1, 0, 0, 9, 7, 1, 106, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.8, NULL, NULL, NULL, NULL, 1, NULL, NULL),
(3, 'BEAUTIFUL LOFT', 'beautiful-loft', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 65, 85, 3, 'Porte de Vanves', '51.461875', '-0.211246', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 650.00, 0.00, 0, 0, 0, 8, 10, 4, 189, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.8, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(4, 'BEST OF WEST VILLAGE', 'best-of-west-village', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 66, 84, 4, 'Porte de Vanves', '51.427638', '-0.170752', 12, 1, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 800.00, 0.00, 0, 0, 0, 5, 8, 9, 200, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.2, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(5, 'DUPLEX GREENWICH', 'duplex-greenwich', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 67, 84, 1, 'Porte de Vanves', '51.442192', '-0.043778', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 220.00, 0.00, 0, 0, 0, 8, 3, 2, 159, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.5, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(6, 'THE MEATPACKING SUITES', 'the-meatpacking-suites', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 68, 85, 1, 'Porte de Vanves', '51.475135', '0.003592', 12, 1, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 320.00, 0.00, 0, 0, 0, 6, 9, 2, 105, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.3, NULL, NULL, NULL, NULL, 6, NULL, NULL),
(7, 'EAST VILLAGE', 'east-village', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 69, 85, 1, 'Porte de Vanves', '51.524292', '-0.022489', 12, 1, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 300.00, 260.00, 0, 0, 0, 10, 9, 9, 134, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 5.0, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(8, 'PARIS GREENWICH VILLA', 'paris-greenwich-villa', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 70, 85, 1, 'Porte de Vanves', '51.556749', '-0.091124', 12, 1, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 500.00, 0.00, 0, 0, 0, 9, 3, 2, 103, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.7, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(9, 'LUXURY SINGLE', 'luxury-single', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 71, 84, 1, 'Porte de Vanves', '51.569555', '0.012563', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 400.00, 350.00, 0, 0, 0, 5, 6, 2, 180, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.8, NULL, NULL, NULL, NULL, 4, NULL, NULL),
(10, 'LILY DALE VILLAGE', 'lily-dale-village', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 72, 83, 1, 'Porte de Vanves', '51.517883', '-0.134314', 12, 1, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 250.00, 0.00, 0, 0, 0, 9, 5, 6, 133, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.7, NULL, NULL, NULL, NULL, 1, NULL, NULL),
(11, 'STAY GREENWICH VILLAGE', 'stay-greenwich-village', '<p>Libero sem vitae sed donec conubia integer nisi integer rhoncus imperdiet orci odio libero est integer a integer tincidunt sollicitudin blandit fusce nibh leo vulputate lobortis egestas dapibus faucibus metus conubia maecenas cras potenti cum hac arcu rhoncus nullam eros dictum torquent integer cursus bibendum sem sociis molestie tellus purus</p><p>Quam fusce convallis ipsum malesuada amet velit aliquam urna nullam vehicula fermentum id morbi dis magnis porta sagittis euismod etiam</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 73, 84, 1, 'Porte de Vanves', '51.514892', '-0.176181', 12, 0, '76,77,78,79,80,81,82', 'https://www.youtube.com/watch?v=UfEiKK-iX70', '[{\"title\":\"Check-in time?\",\"content\":\"As a rough guide, the check-in time is after 12 a.m. Let us know your arrival time in case you schedule and early check in we\\u2018ll do our best to have your room available.\"},{\"title\":\"Check-out time?\",\"content\":\"As a rough guide, the check-out time is before 12pm. If you plan a late check out kindly let us know your departure time, we\\u2019ll our best to satisfy your needs.\"},{\"title\":\"Is Reception open 24 hours?\",\"content\":\"Yes, Reception service is available 24 hours.\"},{\"title\":\"Which languages are spoken at Reception?\",\"content\":\"Italian, English, French, German and Spanish.\"},{\"title\":\"Can I leave my luggage?\",\"content\":\"Yes, we can look after your luggage. If at check in your room is not ready yet or in case of early check out after .We will store your luggage free of charge on your check-in and check-out days.\"},{\"title\":\"Internet connection?\",\"content\":\"A wireless internet connection is available throughout the hotel.\\r\\n\\r\\nThe guest rooms feature hi-speed web connectivity (both wireless and cabled).\"}]', 300.00, 150.00, 1, 0, 0, 9, 9, 6, 102, 1, '[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Clearning\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Breakfasts\",\"price\":\"200\",\"type\":\"one_time\"}]', NULL, 'publish', 1, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:39', 4.8, NULL, NULL, NULL, NULL, 5, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bravo_space_dates`
--

CREATE TABLE `bravo_space_dates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `target_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `price` decimal(12,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,
  `is_instant` tinyint(4) DEFAULT '0',
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_space_term`
--

CREATE TABLE `bravo_space_term` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `term_id` int(11) DEFAULT NULL,
  `target_id` int(11) DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_space_term`
--

INSERT INTO `bravo_space_term` (`id`, `term_id`, `target_id`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES
(1, 16, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(2, 17, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(3, 18, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(4, 19, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(5, 21, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(6, 22, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(7, 23, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(8, 24, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(9, 25, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(10, 26, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(11, 27, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(12, 28, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(13, 29, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(14, 30, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(15, 31, 1, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(16, 15, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(17, 16, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(18, 17, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(19, 18, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(20, 19, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(21, 20, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(22, 21, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(23, 22, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(24, 23, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(25, 24, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(26, 25, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(27, 26, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(28, 28, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(29, 29, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(30, 30, 2, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(31, 15, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(32, 17, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(33, 18, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(34, 20, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(35, 23, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(36, 24, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(37, 26, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(38, 27, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(39, 28, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(40, 29, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(41, 30, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(42, 31, 3, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(43, 15, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(44, 16, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(45, 17, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(46, 18, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(47, 19, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(48, 20, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(49, 21, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(50, 22, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(51, 24, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(52, 25, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(53, 26, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(54, 27, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(55, 28, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(56, 30, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(57, 31, 4, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(58, 15, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(59, 16, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(60, 17, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(61, 18, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(62, 19, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(63, 20, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(64, 22, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(65, 23, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(66, 24, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(67, 25, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(68, 27, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(69, 28, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(70, 29, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(71, 30, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(72, 31, 5, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(73, 15, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(74, 16, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(75, 17, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(76, 18, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(77, 20, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(78, 22, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(79, 23, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(80, 24, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(81, 25, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(82, 26, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(83, 27, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(84, 29, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(85, 31, 6, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(86, 15, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(87, 16, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(88, 17, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(89, 18, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(90, 19, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(91, 20, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(92, 21, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(93, 22, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(94, 24, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(95, 25, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(96, 26, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(97, 27, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(98, 28, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(99, 30, 7, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(100, 15, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(101, 16, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(102, 17, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(103, 18, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(104, 19, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(105, 20, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(106, 21, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(107, 23, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(108, 24, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(109, 25, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(110, 26, 8, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38'),
(111, 27, 8, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(112, 29, 8, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(113, 30, 8, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(114, 31, 8, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(115, 17, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(116, 18, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(117, 19, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(118, 20, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(119, 21, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(120, 22, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(121, 23, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(122, 24, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(123, 25, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(124, 27, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(125, 28, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(126, 29, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(127, 30, 9, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(128, 15, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(129, 16, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(130, 17, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(131, 18, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(132, 19, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(133, 20, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(134, 21, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(135, 22, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(136, 23, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(137, 24, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(138, 25, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(139, 26, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(140, 27, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(141, 29, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(142, 30, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(143, 31, 10, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(144, 15, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(145, 16, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(146, 17, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(147, 18, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(148, 19, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(149, 20, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(150, 22, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(151, 23, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(152, 24, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(153, 25, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(154, 28, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(155, 30, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39'),
(156, 31, 11, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39');

-- --------------------------------------------------------

--
-- Table structure for table `bravo_space_translations`
--

CREATE TABLE `bravo_space_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `faqs` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `surrounding` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_terms`
--

CREATE TABLE `bravo_terms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `attr_id` int(11) DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_terms`
--

INSERT INTO `bravo_terms` (`id`, `name`, `content`, `attr_id`, `slug`, `create_user`, `update_user`, `origin_id`, `lang`, `created_at`, `updated_at`, `deleted_at`, `image_id`, `icon`) VALUES
(1, 'Cultural', NULL, 1, 'cultural', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(2, 'Nature & Adventure', NULL, 1, 'nature-adventure', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(3, 'Marine', NULL, 1, 'marine', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(4, 'Independent', NULL, 1, 'independent', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(5, 'Activities', NULL, 1, 'activities', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(6, 'Festival & Events', NULL, 1, 'festival-events', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(7, 'Special Interest', NULL, 1, 'special-interest', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(8, 'Wifi', NULL, 2, 'wifi', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(9, 'Gymnasium', NULL, 2, 'gymnasium', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(10, 'Mountain Bike', NULL, 2, 'mountain-bike', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(11, 'Satellite Office', NULL, 2, 'satellite-office', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(12, 'Staff Lounge', NULL, 2, 'staff-lounge', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(13, 'Golf Cages', NULL, 2, 'golf-cages', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(14, 'Aerobics Room', NULL, 2, 'aerobics-room', NULL, NULL, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37', NULL, NULL, NULL),
(15, 'Auditorium', NULL, 3, 'auditorium', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(16, 'Bar', NULL, 3, 'bar', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(17, 'Cafe', NULL, 3, 'cafe', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(18, 'Ballroom', NULL, 3, 'ballroom', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(19, 'Dance Studio', NULL, 3, 'dance-studio', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(20, 'Office', NULL, 3, 'office', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(21, 'Party Hall', NULL, 3, 'party-hall', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(22, 'Recording Studio', NULL, 3, 'recording-studio', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(23, 'Yoga Studio', NULL, 3, 'yoga-studio', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(24, 'Villa', NULL, 3, 'villa', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(25, 'Warehouse', NULL, 3, 'warehouse', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, NULL, NULL),
(26, 'Air Conditioning', NULL, 4, 'air-conditioning', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 86, NULL),
(27, 'Breakfast', NULL, 4, 'breakfast', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 87, NULL),
(28, 'Kitchen', NULL, 4, 'kitchen', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 88, NULL),
(29, 'Parking', NULL, 4, 'parking', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 89, NULL),
(30, 'Pool', NULL, 4, 'pool', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 90, NULL),
(31, 'Wi-Fi Internet', NULL, 4, 'wi-fi-internet', NULL, NULL, NULL, NULL, '2023-03-14 13:15:38', '2023-03-14 13:15:38', NULL, 91, NULL),
(32, 'Apartments', NULL, 5, 'apartments', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(33, 'Hotels', NULL, 5, 'hotels', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(34, 'Homestays', NULL, 5, 'homestays', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(35, 'Villas', NULL, 5, 'villas', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(36, 'Boats', NULL, 5, 'boats', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(37, 'Motels', NULL, 5, 'motels', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(38, 'Resorts', NULL, 5, 'resorts', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(39, 'Lodges', NULL, 5, 'lodges', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(40, 'Holiday homes', NULL, 5, 'holiday-homes', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(41, 'Cruises', NULL, 5, 'cruises', NULL, NULL, NULL, NULL, '2023-03-14 13:15:39', '2023-03-14 13:15:39', NULL, NULL, NULL),
(42, 'Wake-up call', NULL, 6, 'wake-up-call', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-wall-clock'),
(43, 'Car hire', NULL, 6, 'car-hire', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-car-alt-3'),
(44, 'Bicycle hire', NULL, 6, 'bicycle-hire', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-bicycle-alt-2'),
(45, 'Flat Tv', NULL, 6, 'flat-tv', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-imac'),
(46, 'Laundry and dry cleaning', NULL, 6, 'laundry-and-dry-cleaning', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-recycle-alt'),
(47, 'Internet – Wifi', NULL, 6, 'internet-wifi', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-wifi-alt'),
(48, 'Coffee and tea', NULL, 6, 'coffee-and-tea', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-tea'),
(49, 'Havana Lobby bar', NULL, 7, 'havana-lobby-bar', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(50, 'Fiesta Restaurant', NULL, 7, 'fiesta-restaurant', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(51, 'Hotel transport services', NULL, 7, 'hotel-transport-services', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(52, 'Free luggage deposit', NULL, 7, 'free-luggage-deposit', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(53, 'Laundry Services', NULL, 7, 'laundry-services', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(54, 'Pets welcome', NULL, 7, 'pets-welcome', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(55, 'Tickets', NULL, 7, 'tickets', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, NULL),
(56, 'Wake-up call', NULL, 8, 'wake-up-call-1', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-wall-clock'),
(57, 'Flat Tv', NULL, 8, 'flat-tv-1', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-imac'),
(58, 'Laundry and dry cleaning', NULL, 8, 'laundry-and-dry-cleaning-1', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-recycle-alt'),
(59, 'Internet – Wifi', NULL, 8, 'internet-wifi-1', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-wifi-alt'),
(60, 'Coffee and tea', NULL, 8, 'coffee-and-tea-1', NULL, NULL, NULL, NULL, '2023-03-14 13:15:40', '2023-03-14 13:15:40', NULL, NULL, 'icofont-tea'),
(61, 'Convertibles', NULL, 9, 'convertibles', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 124, NULL),
(62, 'Coupes', NULL, 9, 'coupes', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 125, NULL),
(63, 'Hatchbacks', NULL, 9, 'hatchbacks', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 126, NULL),
(64, 'Minivans', NULL, 9, 'minivans', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 127, NULL),
(65, 'Sedan', NULL, 9, 'sedan', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 128, NULL),
(66, 'SUVs', NULL, 9, 'suvs', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 129, NULL),
(67, 'Trucks', NULL, 9, 'trucks', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 130, NULL),
(68, 'Wagons', NULL, 9, 'wagons', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 131, NULL),
(69, 'Airbag', NULL, 10, 'airbag', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 137, NULL),
(70, 'FM Radio', NULL, 10, 'fm-radio', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 138, NULL),
(71, 'Power Windows', NULL, 10, 'power-windows', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 142, NULL),
(72, 'Sensor', NULL, 10, 'sensor', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 139, NULL),
(73, 'Speed Km', NULL, 10, 'speed-km', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 140, NULL),
(74, 'Steering Wheel', NULL, 10, 'steering-wheel', NULL, NULL, NULL, NULL, '2023-03-14 13:15:42', '2023-03-14 13:15:42', NULL, 141, NULL),
(75, 'Field Day', NULL, 11, 'field-day', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(76, 'Glastonbury', NULL, 11, 'glastonbury', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(77, 'Green Man', NULL, 11, 'green-man', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(78, 'Latitude', NULL, 11, 'latitude', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(79, 'Boomtown', NULL, 11, 'boomtown', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(80, 'Wilderness', NULL, 11, 'wilderness', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(81, 'Exit Festival', NULL, 11, 'exit-festival', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(82, 'Primavera Sound', NULL, 11, 'primavera-sound', NULL, NULL, NULL, NULL, '2023-03-14 13:15:43', '2023-03-14 13:15:43', NULL, NULL, NULL),
(83, 'Business', NULL, 12, 'business', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(84, 'First Class', NULL, 12, 'first-class', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(85, 'Economy', NULL, 12, 'economy', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(86, 'Premium Economy', NULL, 12, 'premium-economy', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(87, 'Inflight Dining', NULL, 13, 'inflight-dining', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(88, 'Music', NULL, 13, 'music', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(89, 'Sky Shopping', NULL, 13, 'sky-shopping', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(90, 'Seats & Cabin', NULL, 13, 'seats-cabin', NULL, NULL, NULL, NULL, '2023-03-14 13:15:44', '2023-03-14 13:15:44', NULL, NULL, NULL),
(91, 'Airboat', NULL, 14, 'airboat', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(92, 'Cabin cruiser', NULL, 14, 'cabin-cruiser', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(93, 'Cruise ship', NULL, 14, 'cruise-ship', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(94, 'Express cruiser', NULL, 14, 'express-cruiser', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(95, 'Electric boat', NULL, 14, 'electric-boat', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(96, 'Ferry', NULL, 14, 'ferry', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(97, 'Inflatable boat', NULL, 14, 'inflatable-boat', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(98, 'Jetboat', NULL, 14, 'jetboat', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(99, 'Events and Meetings', NULL, 15, 'events-and-meetings', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(100, 'Scuba Gear', NULL, 15, 'scuba-gear', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(101, 'Hot Tub/Jacuzzi on Deck', NULL, 15, 'hot-tubjacuzzi-on-deck', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(102, 'Sport Fishing', NULL, 15, 'sport-fishing', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(103, 'Speciality Classic Yacht', NULL, 15, 'speciality-classic-yacht', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL),
(104, 'Gulet', NULL, 15, 'gulet', NULL, NULL, NULL, NULL, '2023-03-14 13:15:46', '2023-03-14 13:15:46', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bravo_terms_translations`
--

CREATE TABLE `bravo_terms_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `locale` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tours`
--

CREATE TABLE `bravo_tours` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `image_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) DEFAULT NULL,
  `short_desc` text COLLATE utf8mb4_unicode_ci,
  `category_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_lng` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `gallery` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `min_people` int(11) DEFAULT NULL,
  `max_people` int(11) DEFAULT NULL,
  `faqs` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_date` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `default_state` tinyint(4) DEFAULT '1',
  `enable_fixed_date` tinyint(4) DEFAULT '0',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `last_booking_date` datetime DEFAULT NULL,
  `include` text COLLATE utf8mb4_unicode_ci,
  `exclude` text COLLATE utf8mb4_unicode_ci,
  `itinerary` text COLLATE utf8mb4_unicode_ci,
  `review_score` decimal(2,1) DEFAULT NULL,
  `ical_import_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_service_fee` tinyint(4) DEFAULT NULL,
  `service_fee` text COLLATE utf8mb4_unicode_ci,
  `surrounding` text COLLATE utf8mb4_unicode_ci,
  `author_id` bigint(20) DEFAULT NULL,
  `min_day_before_booking` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_tours`
--

INSERT INTO `bravo_tours` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `short_desc`, `category_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `price`, `sale_price`, `duration`, `min_people`, `max_people`, `faqs`, `status`, `publish_date`, `create_user`, `update_user`, `deleted_at`, `origin_id`, `lang`, `created_at`, `updated_at`, `default_state`, `enable_fixed_date`, `start_date`, `end_date`, `last_booking_date`, `include`, `exclude`, `itinerary`, `review_score`, `ical_import_url`, `enable_service_fee`, `service_fee`, `surrounding`, `author_id`, `min_day_before_booking`) VALUES
(1, 'American Parks Trail end Rapid City', 'american-parks-trail', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 21, 44, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 1, 'Arrondissement de Paris', '48.852754', '2.339155', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2000.00, 540.00, 4, 1, 14, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.7, NULL, NULL, NULL, NULL, 1, NULL),
(2, 'New York: Museum of Modern Art', 'new-york-museum-of-modern-art', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 22, 45, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 1, 'Porte de Vanves', '48.853917', '2.307199', 12, 1, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 900.00, 172.00, 5, 1, 16, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.6, NULL, NULL, NULL, NULL, 1, NULL),
(3, 'Los Angeles to San Francisco Express ', 'los-angeles-to-san-francisco-express', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 23, 46, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 1, 'Petit-Montrouge', '48.884900', '2.346377', 12, 1, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 1500.00, 338.00, 4, 1, 10, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 6, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.5, NULL, NULL, NULL, NULL, 6, NULL),
(4, 'Tour in Vienna', 'paris-vacation-travel', '<p class=\"p-rich_text_section\" style=\"color: #1d1c1d; font-family: \'Slack-Lato\', \'Slack-Fractions\', appleLogo, sans-serif; font-size: 15px; background-color: #f8f8f8;\">Embark on a captivating <strong>5-day city tour of Vienna</strong> and immerse yourself in the rich history, culture, and culinary delights of this enchanting city. Explore magnificent palaces, indulge in delicious cuisine, and discover the vibrant atmosphere of Vienna\'s iconic landmarks</p>\r\n<div class=\"p-rich_text_section\" style=\"color: #1d1c1d; font-family: \'Slack-Lato\', \'Slack-Fractions\', appleLogo, sans-serif; font-size: 15px; background-color: #f8f8f8;\">\r\n<ul>\r\n<li>Majestic Palaces: Explore the grandeur of Hofburg Palace and Sch&ouml;nbrunn Palace, witnessing the opulence of Vienna\'s imperial history.</li>\r\n<li>Cultural Delights: Discover art masterpieces at the Belvedere Palace and delve into Vienna\'s artistic heritage at the Albertina Museum.</li>\r\n<li>Gastronomic Experiences: Indulge in Turkish cuisine at Turkis Marianilf and enjoy delicious pizzas at Pizza Randale.</li>\r\n<li>Musical Enchantment: Experience the captivating performances at the State Opera, immersing yourself in Vienna\'s renowned musical legacy.</li>\r\n<li>Vibrant Cityscape: Soak in the energetic atmosphere of Mariahilfer Street and enjoy breathtaking views from 360 Ocean Sky.</li>\r\n</ul>\r\n</div>', 24, 47, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 1, 24, 'Vienna', '48.210033', '16.363449', 12, 1, '37,38,39,40,41,42,43', NULL, 850.00, 505.00, 5, 1, 13, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, 1, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-05-29 21:54:30', 1, NULL, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"390\",\"title\":\"Day 1\",\"desc\":\"Hofburg Palace, Naschmarkt & Sch\\u00f6nbrunn Palace\",\"content\":\"Begin your Vienna adventure with a visit to the majestic Hofburg Palace, steeped in imperial history. Explore the vibrant Naschmarkt for an eclectic mix of flavors and unique finds, and end the day with the splendor of Sch\\u00f6nbrunn Palace\'s breathtaking gardens.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Belvedere Palace, Stadtpark & State Opera\",\"content\":\"Immerse yourself in art and culture at the Belvedere Palace, where you\'ll encounter masterpieces like Gustav Klimt\'s \\\"The Kiss.\\\" Take a leisurely stroll through Stadtpark, relax amidst its serene surroundings, and delve into Vienna\'s artistic treasures at the Albertina Museum. Indulge in a delightful Turkish meal at Turkis Marianilf, and experience the magic of the State Opera in the evening.\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Caf\\u00e9 Museum, Natural- Art Museum & Rathausplace\",\"content\":\"Begin your day with Viennese charm at Caf\\u00e9 Museum, known for its delectable pastries. Explore the Natural History Museum\'s fascinating exhibits, and enjoy a culinary journey at O Bouf\\u00e9s restaurant. In the afternoon, soak up the atmosphere at Rathausplatz, where seasonal events and bustling markets await.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"Caf\\u00e9 Schwarzenberg, Prater & Pizza Day\",\"content\":\"Start your day at Caf\\u00e9 Schwarzenberg, savoring Viennese coffee culture at its finest. Thrill yourself at Prater amusement park with its exciting rides and entertainment, and treat your taste buds to authentic Italian pizzas at Pizza Randale.\"},{\"image_id\":null,\"title\":\"Day 5\",\"desc\":\"360 Oceac Sky, Mariahilfer Street & Ferhat Kebab\",\"content\":\"Take in breathtaking views from 360 Ocean Sky and discover the shopping delights of Mariahilfer Street. Indulge in the flavors of Ferhat Doner Re and enjoy a satisfying doner kebab before bidding farewell to Vienna.\"}]', 4.5, NULL, NULL, NULL, NULL, 1, NULL),
(5, 'Southwest States (Ex Los Angeles) ', 'southwest-states', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 25, 48, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 2, 'Regal Cinemas Battery Park 11', '40.714578', '-73.983888', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 1900.00, 604.00, 3, 1, 18, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 4, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.7, NULL, NULL, NULL, NULL, 4, NULL),
(6, 'Eastern Discovery (Start New Orleans)', 'eastern-discovery-start-new-orleans', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 26, 49, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 1, 2, 'Prince St Station', '40.720161', '-74.009628', 12, 1, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 1592.00, 8, 1, 17, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 4, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 5.0, NULL, NULL, NULL, NULL, 4, NULL),
(7, 'Eastern Discovery', 'eastern-discovery', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 27, 50, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 3, 2, 'Pier 36 New York', '40.708581', '-73.998817', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 1346.00, 4, 1, 15, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 6, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.0, NULL, NULL, NULL, NULL, 6, NULL),
(8, 'Pure Luxe in Punta Mita', 'pure-luxe-in-punta-mita', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 28, 51, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 3, 'Trimmer Springs Rd, Sanger', '36.822484', '-119.365266', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 1193.00, 6, 1, 18, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 6, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.2, NULL, NULL, NULL, NULL, 6, NULL),
(9, 'Tastes and Sounds of the South 2019', 'tastes-and-sounds-of-the-south-2019', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 29, 52, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 3, 4, 'United States', '37.040023', '-95.643144', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 307.00, 6, 1, 14, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 6, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.0, NULL, NULL, NULL, NULL, 6, NULL),
(10, 'Giverny and Versailles Small Group Day Trip', 'giverny-and-versailles-small-group-day-trip', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 30, 53, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 3, 5, 'Washington, DC, USA', '34.049345', '-118.248479', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 619.00, 9, 1, 13, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 5, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 5.0, NULL, NULL, NULL, NULL, 5, NULL),
(11, 'Trip of New York – Discover America', 'trip-of-new-york-discover-america', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 31, 54, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 3, 6, 'New Jersey', '40.035329', '-74.417227', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 344.00, 3, 1, 17, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 6, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.4, NULL, NULL, NULL, NULL, 6, NULL);
INSERT INTO `bravo_tours` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `short_desc`, `category_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `price`, `sale_price`, `duration`, `min_people`, `max_people`, `faqs`, `status`, `publish_date`, `create_user`, `update_user`, `deleted_at`, `origin_id`, `lang`, `created_at`, `updated_at`, `default_state`, `enable_fixed_date`, `start_date`, `end_date`, `last_booking_date`, `include`, `exclude`, `itinerary`, `review_score`, `ical_import_url`, `enable_service_fee`, `service_fee`, `surrounding`, `author_id`, `min_day_before_booking`) VALUES
(12, 'Segway Tour of Washington, D.C. Highlights', 'segway-tour-of-washington-dc-highlights', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 32, 55, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 3, 7, 'Francisco Parnassus Campus', '37.782668', '-122.425058', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 505.00, 6, 1, 19, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.3, NULL, NULL, NULL, NULL, 1, NULL),
(13, 'Hollywood Sign Small Group Tour in Luxury Van', 'hollywood-sign-small-group-tour-in-luxury-van', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 33, 56, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 1, 8, 'Virginia', '37.445688', '-78.673668', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 644.00, 2, 1, 17, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 4, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.4, NULL, NULL, NULL, NULL, 4, NULL),
(14, 'San Francisco Express Never Ceases', 'san-francisco-express', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 34, 57, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 4, 7, 'Comprehensive Cancer Center', '37.757522', '-122.447984', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 261.00, 8, 1, 16, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.0, NULL, NULL, NULL, NULL, 1, NULL),
(15, 'Cannes and Antibes Night Tour', 'cannes-and-antibes-night-tour', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 35, 58, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 2, 1, 'UCSF Helen Diller Family', '36.201066', '-88.112292', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 1203.00, 3, 1, 15, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 4, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.0, NULL, NULL, NULL, NULL, 4, NULL),
(16, 'River Cruise Tour on the Seine', 'river-cruise-tour-on-the-seine', '<p>Start and end in San Francisco! With the in-depth cultural tour Northern California Summer 2019, you have a 8 day tour package taking you through San Francisco, USA and 9 other destinations in USA. Northern California Summer 2019 includes accommodation as well as an expert guide, meals, transport and more.</p><h4>HIGHLIGHTS</h4><ul><li>Visit the Museum of Modern Art in Manhattan</li><li>See amazing works of contemporary art, including Vincent van Gogh\'s The Starry Night</li><li>Check out Campbell\'s Soup Cans by Warhol and The Dance (I) by Matisse</li><li>Behold masterpieces by Gauguin, Dali, Picasso, and Pollock</li><li>Enjoy free audio guides available in English, French, German, Italian, Spanish, Portuguese</li></ul>', 36, 59, 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 2, 1, 'Nevada, US', '36.401066', '-88.312292', 12, 0, '37,38,39,40,41,42,43', 'https://www.youtube.com/watch?v=UfEiKK-iX70', 2100.00, 1267.00, 7, 1, 10, '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-03-14 13:15:36', '2023-03-14 13:15:37', 1, 0, NULL, NULL, NULL, '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"110\",\"title\":\"Day 1\",\"desc\":\"Los Angeles\",\"content\":\"There are no activities planned until an evening welcome meeting. Additional Notes: We highly recommend booking pre-tour accommodation to fully experience this crazy city.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Lake Havasu City\",\"content\":\"Pack up the van in the morning and check out the stars on the most famous sidewalk in Hollywood on an orientation tour\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Las Vegas\\/Bakersfield\",\"content\":\"Travel to one of the country\'s most rugged landscapes \\u2014 the legendary Death Valley, California. Soak in the dramatic landscape. In the afternoon, continue on to Bakersfield for the night.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"San Francisco\",\"content\":\"We highly recommend booking post-accommodation to fully experience this famous city.\"}]', 4.7, NULL, NULL, NULL, NULL, 1, NULL),
(17, 'Tour in Salzburg', 'tour-in-salzburg', '<p>Embark on a remarkable 3-day city tour in Salzburg, where historical charm and natural beauty await at every turn. Here are three highlights that make this tour truly unforgettable:</p>\r\n<ul>\r\n<li>Mirabell Palace and Garden: Immerse yourself in the beauty of this enchanting palace and its meticulously manicured gardens, featuring the iconic Pegasus Fountain.</li>\r\n<li>Mondsee: Explore the picturesque lakeside town of Mondsee, known for its stunning Lake Mondsee and the magnificent Mondsee Abbey.</li>\r\n<li>Fortress Hohensalzburg: Discover the medieval charm of this impressive fortress perched on a hill, offering panoramic views of Salzburg and a journey into its rich history.</li>\r\n</ul>', 266, 362, NULL, 1, 25, 'Salzburg', '47.8095', '13.0550', 8, 1, NULL, NULL, NULL, NULL, 3, 1, 13, '[{\"title\":\"What is the best time to visit Salzburg?\",\"content\":\"A: Salzburg is a year-round destination, but the best time to visit is during the summer months (June to August) when the weather is pleasant and outdoor activities are in full swing. The city is also charming during the winter holiday season, especially if you want to experience the festive atmosphere and visit the famous Salzburg Christmas markets.\"},{\"title\":\"How do I get from Salzburg Airport to the city center?\",\"content\":\"A: Salzburg Airport is conveniently located just a few kilometers from the city center. You can easily reach the city center by taxi, airport shuttle service, or public transportation. The Salzburg Airport W. A. Mozart is well-connected with regular bus services that take you directly to the city center and other major attractions.\"},{\"title\":\"Are there any Sound of Music tours available in Salzburg?\",\"content\":\"A: Yes, Salzburg is famous for its association with the beloved movie \\\"The Sound of Music.\\\" There are several guided tours available that take you to the iconic filming locations, including the Mirabell Gardens, Nonnberg Abbey, and the Leopoldskron Palace. These tours offer a chance to relive the magic of the movie and learn interesting behind-the-scenes facts.\"}]', 'publish', NULL, 1, 1, NULL, NULL, NULL, '2023-05-31 07:21:42', '2023-05-31 07:46:36', 1, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"mirabell palace and garden , doner mann restaurant , getredegasse streets\",\"content\":\"Begin your tour with a visit to the enchanting Mirabell Palace and its exquisite gardens, where you can immerse yourself in the beauty of Baroque architecture. Indulge in a delightful meal at Doner Mann restaurant and explore the charming streets of Getreidegasse, known for its historical significance and unique shops.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"mondsee , op of salzburg (telef\\u00e8ric) , kitzsteinhorn , sofra restaurant\",\"content\":\"Venture beyond Salzburg to the serene town of Mondsee, where you can enjoy the picturesque views of Lake Mondsee and visit the impressive Mondsee Abbey. Take a thrilling cable car ride to the Top of Salzburg, offering breathtaking alpine panoramas, and conclude the day with a delicious meal at Sofra restaurant.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"hellbrunn palace , fortress hohen Salzburg , eleven 11:11 eleven restaurant\",\"content\":\"Discover the fascinating Hellbrunn Palace, known for its captivating gardens and intriguing trick fountains. Immerse yourself in the medieval heritage of Salzburg by exploring the grand Fortress Hohensalzburg. Wrap up your tour with a memorable dining experience at Eleven 11:11 Eleven restaurant, savoring innovative cuisine in a cozy atmosphere.\"}]', NULL, 'https://stag.gotravoo.com/booking/export-ical/tour/4', NULL, NULL, NULL, NULL, NULL),
(18, 'Tour in Geneva', 'geneva', '<p>Embark on a remarkable 3-day city tour in Geneva , where historical charm and natural beauty await at every turn. Here are three highlights that make this tour truly unforgettable:</p>\r\n<ul>\r\n<li>Lake Geneva: Explore the stunning beauty of one of Europe\'s largest lakes and witness the iconic Jet d\'Eau.</li>\r\n<li>Reformation Wall and Musee Ariana: Discover Geneva\'s history and culture at the Reformation Wall monument and Musee Ariana, showcasing ceramics and glass art.</li>\r\n<li>Rue du Rhone and Centre Commercial Balexert: Enjoy a shopping spree at Rue du Rhone, known for luxury boutiques, and Centre Commercial Balexert, a large shopping center.</li>\r\n</ul>', 261, 368, NULL, 1, 30, 'Geneva', '46.2044', '6.1432', 8, NULL, NULL, NULL, NULL, NULL, 3, 1, 13, '[{\"title\":\"What are the must-see attractions in Geneva?\",\"content\":\"Some of the must-see attractions in Geneva include the Jet d\'Eau, a magnificent water fountain on Lake Geneva; the Old Town with its charming cobblestone streets; the United Nations Office; and the St. Pierre Cathedral, offering panoramic views of the city.\"},{\"title\":\"What is the best time to visit Geneva?\",\"content\":\"Geneva is a year-round destination, but the best time to visit is during the summer months (June to August) when the weather is pleasant, and outdoor activities and festivals are in full swing. Spring (April to May) and autumn (September to October) also offer mild weather and fewer crowds.\"},{\"title\":\"What is Geneva known for?\",\"content\":\"Geneva is renowned as a global hub for diplomacy and international cooperation, hosting numerous international organizations such as the United Nations and the Red Cross. It is also known for its stunning lakeside setting, luxury watchmaking industry, vibrant cultural scene, and being a center for fine dining and chocolate.\"}]', 'publish', NULL, 1, 1, NULL, NULL, NULL, '2023-05-31 07:47:04', '2023-05-31 07:49:31', 1, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"lake geneva  jet d eau  cafe remor -jardin anglais\",\"content\":\"Begin your tour by immersing yourself in the beauty of Lake Geneva, where you can take a leisurely stroll along the lakeside promenade and admire the stunning views. Don\'t miss the iconic Jet d\'Eau, a magnificent water fountain that graces the lake\'s horizon. Enjoy a delightful break at Caf\\u00e9 Remor, savoring delicious Swiss cuisine. Explore Jardin Anglais, a tranquil park offering scenic spots and the famous L\'Horloge Fleurie, a stunning flower clock.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"reformation wall musee ariana rue du rhone  ali haydar kebab\",\"content\":\"Discover Geneva\'s rich history and culture by visiting the Reformation Wall, an impressive monument commemorating the Protestant Reformation. Dive into the world of ceramics and glass art at Musee Ariana, home to a remarkable collection of exquisite pieces. Indulge in a shopping spree on Rue du Rhone, known for its luxury boutiques and high-end fashion. Treat yourself to a flavorful meal at Ali Haydar Kebab, savoring authentic Middle Eastern cuisine.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"parc de mon repos  centre commercial balexert  street beirut restaurant\",\"content\":\"Relax and unwind at Parc de Mon Repos, a peaceful park where you can enjoy nature, stroll along its pathways, and perhaps have a picnic. Experience shopping at its finest at Centre Commercial Balexert, a large shopping center offering a wide range of stores and boutiques to satisfy all your retail desires. End your tour on a culinary note by dining at Street Beirut Restaurant, immersing yourself in the flavors of Lebanese cuisine.\"}]', NULL, 'https://stag.gotravoo.com/booking/export-ical/tour/17', NULL, NULL, NULL, NULL, NULL),
(19, 'Tour in Paris', 'tour-in-paris', '<p>Embark on a memorable tour of Paris, immersing yourself in its rich history, breathtaking landmarks, and vibrant culture. Over the course of three days, you\'ll explore iconic sites such as the majestic Arc de Triomphe and the world-famous Eiffel Tower, where you\'ll be treated to panoramic views of the city. Cruise along the enchanting Seine River, stroll through the tranquil Luxembourg Garden, and marvel at the architectural grandeur of Notre Dame de Paris. Immerse yourself in the art world at the renowned Musee d\'Orsay and the historic Louvre Museum, home to masterpieces that have captivated audiences for centuries. Indulge your taste buds with the flavors of the Middle East at Al Dar Restaurant. This tour promises an unforgettable journey through the captivating beauty and cultural treasures of the City of Light.</p>\r\n<ul>\r\n<li>Iconic Landmarks: Arc de Triomphe, Eiffel Tower, Seine River</li>\r\n<li>Artistic Treasures: Musee d\'Orsay, Louvre Museum</li>\r\n<li>Cultural Delights: Luxembourg Garden, Al Dar Restaurant</li>\r\n</ul>', 252, 358, NULL, 1, 21, 'Paris', '48.8566', '2.3522', 8, 1, NULL, NULL, NULL, NULL, 3, 1, 13, '[{\"title\":\"How can I skip the long lines at popular attractions like the Louvre Museum in Paris?\",\"content\":\"To avoid long queues, it\'s recommended to purchase skip-the-line tickets or consider visiting during less busy times such as early morning or weekdays.\"},{\"title\":\"What is the best way to get around Paris and explore its attractions?\",\"content\":\"Paris has an extensive public transportation system, including the metro, buses, and trams, making it convenient to navigate the city. Alternatively, renting a bicycle or walking can be great options to explore the city\'s charming streets and landmarks.\"},{\"title\":\"Are there any specific dress codes to keep in mind when visiting religious sites in Paris, such as Notre Dame Cathedral?\",\"content\":\"It\'s advisable to dress modestly when visiting religious sites in Paris. This generally means avoiding revealing clothing and ensuring shoulders and knees are covered. Respectful attire shows appreciation for the cultural and religious significance of these sites.\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03', 1, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"Eiffel tower , seine river , luxembourg garden , frenchy taste restaurant\",\"content\":\"Start your Paris adventure by visiting two iconic landmarks, the Arc de Triomphe and the majestic Eiffel Tower. Take in breathtaking views of the city from the top of these architectural marvels. Enjoy a leisurely stroll along the Seine River and immerse yourself in the beauty of the Luxembourg Garden. Indulge in a delightful culinary experience at Frenchy Taste Restaurant, savoring delicious French cuisine.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"notre dame de paris , musee d\'orsay  , louvre museum , al dar restaurant\",\"content\":\"Explore the cultural and artistic gems of Paris. Begin with a visit to the magnificent Notre Dame de Paris, admiring its Gothic architecture and rich history. Continue to the Musee d\'Orsay, home to an impressive collection of Impressionist and Post-Impressionist masterpieces. Then, venture to the world-famous Louvre Museum, where you can marvel at timeless works of art, including the iconic Mona Lisa. Conclude your day with a delightful meal at Al Dar Restaurant, indulging in exquisite Middle Eastern flavors.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"latin quarter , avenue des champs , galeries lafayette  , new jawad restaurant\",\"content\":\"Discover the vibrant atmosphere of the Latin Quarter, known for its lively streets, charming cafes, and bohemian ambiance. Wander along the iconic Avenue des Champs-\\u00c9lys\\u00e9es, lined with luxurious shops and iconic landmarks. Explore the renowned Galeries Lafayette, a shopper\'s paradise offering a wide range of high-end fashion and luxury goods. Treat your taste buds to a culinary journey at New Jawad Restaurant, savoring delicious Middle Eastern cuisine in a warm and inviting setting.\"}]', NULL, 'https://stag.gotravoo.com/booking/export-ical/tour/4', NULL, NULL, NULL, NULL, NULL),
(20, 'Tour in Interlaken', 'tour-in-interlaken', '<p>Interlaken is a breathtaking destination nestled in the heart of the Swiss Alps, offering a plethora of natural beauty and thrilling adventures.</p>\r\n<ul>\r\n<li>Breathtaking Alpine Beauty: Explore the stunning Lake Thun and Lake Brienz, surrounded by awe-inspiring mountain landscapes.</li>\r\n<li>Thrilling Mountain Adventures: Ascend to the summit of Schilthorn for panoramic views and discover the captivating St. Beatus Cave.</li>\r\n<li>Cultural Immersion: Immerse yourself in Swiss history and culture at the Ballenberg Swiss Open-Air Museum and experience the charm of Unterseen village.</li>\r\n</ul>', 267, 369, NULL, 1, 28, 'Interlaken', '46.6863', '7.8632', 8, 1, NULL, NULL, NULL, NULL, 3, 1, 13, '[{\"title\":\"What are the must-visit natural attractions in Interlaken?\",\"content\":\"Interlaken is blessed with breathtaking natural beauty. Don\'t miss the stunning lakes of Thun and Brienz, as well as the magnificent Schilthorn mountain. These attractions offer picturesque views and unforgettable experiences.\"},{\"title\":\"Are there any adventure activities available in Interlaken?\",\"content\":\"Absolutely! Interlaken is known as the adventure capital of Switzerland. You can indulge in thrilling activities like paragliding, skydiving, canyoning, and bungee jumping. The region\'s natural landscape provides the perfect backdrop for adrenaline-pumping adventures\"},{\"title\":\"What cultural experiences can I have in Interlaken?\",\"content\":\"Interlaken offers unique cultural experiences as well. Visit the St. Beatus Cave to explore its fascinating underground formations. Don\'t miss the Ballenberg Swiss Open-Air Museum, where you can immerse yourself in traditional Swiss architecture, crafts, and customs. These attractions provide insights into the rich cultural heritage of the region\"}]', 'publish', NULL, 1, NULL, NULL, NULL, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57', 1, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"lake thun , schilthorn , layaly Beirut , lake brienz\",\"content\":\"Begin your day by exploring the picturesque Lake Thun, surrounded by stunning mountain scenery. Afterward, embark on an unforgettable journey to the summit of Schilthorn, where you\'ll be rewarded with breathtaking panoramic views. For a delightful culinary experience, indulge in the flavors of Lebanon at the Layaly Beirut restaurant. End your day by visiting the enchanting Lake Brienz, known for its crystal-clear waters and charming ambiance.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"st. Beatus cave , bellenberg swiss open air museum ,  Aare Korean BBQ restaurant\",\"content\":\"Delve into the fascinating St. Beatus Cave, a natural wonder filled with awe-inspiring rock formations and mythical legends. Immerse yourself in Swiss history and traditions at the Ballenberg Swiss Open-Air Museum, where you can explore authentic Swiss buildings and artifacts. Enjoy a delectable dining experience at Aare Korean BBQ restaurant, savoring the flavors of Korean cuisine.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"Harder kulm  , unterseen ,  jungfraupark , napoli pizza\\u00a0restaurant\",\"content\":\"Ascend to the summit of Harder Kulm and be rewarded with panoramic views of Interlaken and the surrounding Alps. Take a leisurely stroll through the charming village of Unterseen, known for its quaint streets and traditional Swiss architecture. Discover the exciting Jungfraupark, a family-friendly amusement park with thrilling rides and entertainment. End your day with a taste of Italy at Napoli Pizza restaurant, where you can indulge in delicious pizzas and Italian specialties.\"}]', NULL, 'https://stag.gotravoo.com/booking/export-ical/tour/4', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_category`
--

CREATE TABLE `bravo_tour_category` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `_lft` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `_rgt` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `parent_id` int(10) UNSIGNED DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_tour_category`
--

INSERT INTO `bravo_tour_category` (`id`, `name`, `content`, `slug`, `status`, `_lft`, `_rgt`, `parent_id`, `create_user`, `update_user`, `deleted_at`, `origin_id`, `lang`, `created_at`, `updated_at`) VALUES
(1, 'City trips', '', 'city-trips', 'publish', 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-03-14 13:15:35'),
(2, 'Ecotourism', '', 'ecotourism', 'publish', 3, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-03-14 13:15:35'),
(3, 'Escorted tour', '', 'escorted-tour', 'publish', 5, 6, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-03-14 13:15:35'),
(4, 'Ligula', '', 'ligula', 'publish', 7, 8, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-03-14 13:15:35');

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_category_translations`
--

CREATE TABLE `bravo_tour_category_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `locale` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_dates`
--

CREATE TABLE `bravo_tour_dates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `target_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `person_types` text COLLATE utf8mb4_unicode_ci,
  `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,
  `is_instant` tinyint(4) DEFAULT '0',
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_meta`
--

CREATE TABLE `bravo_tour_meta` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tour_id` int(11) DEFAULT NULL,
  `enable_person_types` tinyint(4) DEFAULT NULL,
  `person_types` text COLLATE utf8mb4_unicode_ci,
  `enable_extra_price` tinyint(4) DEFAULT NULL,
  `extra_price` text COLLATE utf8mb4_unicode_ci,
  `discount_by_people` text COLLATE utf8mb4_unicode_ci,
  `enable_open_hours` tinyint(4) DEFAULT NULL,
  `open_hours` text COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_tour_meta`
--

INSERT INTO `bravo_tour_meta` (`id`, `tour_id`, `enable_person_types`, `person_types`, `enable_extra_price`, `extra_price`, `discount_by_people`, `enable_open_hours`, `open_hours`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 2, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 3, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 4, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"name_ja\":null,\"desc_ja\":null,\"name_egy\":null,\"desc_egy\":null,\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"name_ja\":null,\"desc_ja\":null,\"name_egy\":null,\"desc_egy\":null,\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"name_ja\":null,\"name_egy\":null,\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, '{\"1\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"2\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"3\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"4\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"5\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"6\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"7\":{\"from\":\"00:00\",\"to\":\"00:00\"}}', 1, 1, NULL, '2023-05-29 21:40:59'),
(5, 5, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 6, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 7, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 8, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 9, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 10, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 11, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 12, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 13, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 14, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 15, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 16, 1, '[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\"},{\"name\":\"Child\",\"desc\":\"Age 6-17\",\"min\":\"0\",\"max\":\"10\",\"price\":\"300\"}]', 1, '[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, 17, NULL, NULL, NULL, NULL, NULL, NULL, '{\"1\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"2\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"3\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"4\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"5\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"6\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"7\":{\"from\":\"00:00\",\"to\":\"00:00\"}}', 1, 1, '2023-05-31 07:21:42', '2023-05-31 07:41:47'),
(18, 18, NULL, NULL, NULL, NULL, NULL, NULL, '{\"1\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"2\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"3\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"4\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"5\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"6\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"7\":{\"from\":\"00:00\",\"to\":\"00:00\"}}', 1, 1, '2023-05-31 07:47:04', '2023-05-31 07:48:02'),
(19, 19, NULL, NULL, NULL, NULL, NULL, NULL, '{\"1\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"2\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"3\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"4\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"5\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"6\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"7\":{\"from\":\"00:00\",\"to\":\"00:00\"}}', 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03'),
(20, 20, NULL, NULL, NULL, NULL, NULL, NULL, '{\"1\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"2\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"3\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"4\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"5\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"6\":{\"from\":\"00:00\",\"to\":\"00:00\"},\"7\":{\"from\":\"00:00\",\"to\":\"00:00\"}}', 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57');

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_term`
--

CREATE TABLE `bravo_tour_term` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `term_id` int(11) DEFAULT NULL,
  `tour_id` int(11) DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_tour_term`
--

INSERT INTO `bravo_tour_term` (`id`, `term_id`, `tour_id`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(2, 2, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(3, 3, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(4, 4, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(5, 5, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(6, 6, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(7, 7, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(8, 1, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(9, 2, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(10, 7, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(11, 1, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(12, 4, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(13, 7, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(14, 1, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(15, 2, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(20, 3, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(21, 4, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(22, 7, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(23, 1, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(24, 3, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(25, 4, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(26, 5, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(27, 6, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(28, 7, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(29, 1, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(30, 2, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(31, 3, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(32, 7, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(33, 1, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(34, 2, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(35, 4, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(36, 5, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(37, 1, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(38, 6, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(39, 7, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(40, 1, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(41, 2, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(42, 4, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(43, 6, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(44, 7, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(45, 2, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(46, 4, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(47, 6, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(48, 7, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(49, 1, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(50, 4, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(51, 5, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(52, 6, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(53, 7, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(54, 1, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(55, 2, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(56, 3, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(57, 4, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(58, 5, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(59, 6, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(60, 7, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(61, 2, 14, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(62, 3, 14, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(63, 5, 14, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(64, 4, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(65, 1, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(66, 2, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(67, 4, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(68, 6, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(69, 7, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(70, 9, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(71, 10, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(72, 12, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(73, 13, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(74, 14, 1, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(75, 8, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(76, 9, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(77, 10, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(78, 12, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(79, 13, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(80, 14, 2, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(81, 11, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(82, 12, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(83, 13, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(84, 14, 3, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(85, 8, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(86, 9, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(87, 13, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(88, 14, 4, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(89, 9, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(90, 12, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(91, 13, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(92, 14, 5, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(93, 9, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(94, 11, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(95, 12, 6, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(96, 8, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(97, 9, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(98, 11, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(99, 13, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(100, 14, 7, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(101, 10, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(102, 11, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(103, 12, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(104, 13, 8, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(105, 9, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(106, 12, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(107, 14, 9, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(108, 8, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(109, 9, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(110, 10, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(111, 11, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(112, 12, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(113, 13, 10, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(114, 8, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(115, 9, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(116, 10, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(117, 13, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(118, 14, 11, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(119, 8, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(120, 10, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(121, 14, 12, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(122, 8, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(123, 9, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(124, 10, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(125, 12, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(126, 13, 13, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(127, 8, 14, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(128, 13, 14, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(129, 8, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(130, 9, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(131, 10, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(132, 11, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(133, 14, 15, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(134, 8, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(135, 9, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(136, 10, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(137, 11, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(138, 12, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(139, 14, 16, NULL, NULL, '2023-03-14 13:15:37', '2023-03-14 13:15:37'),
(140, 1, 17, 1, NULL, '2023-05-31 07:21:42', '2023-05-31 07:21:42'),
(141, 2, 17, 1, NULL, '2023-05-31 07:21:42', '2023-05-31 07:21:42'),
(142, 8, 17, 1, NULL, '2023-05-31 07:21:42', '2023-05-31 07:21:42'),
(143, 9, 17, 1, NULL, '2023-05-31 07:21:42', '2023-05-31 07:21:42'),
(144, 1, 18, 1, NULL, '2023-05-31 07:47:04', '2023-05-31 07:47:04'),
(145, 2, 18, 1, NULL, '2023-05-31 07:47:04', '2023-05-31 07:47:04'),
(146, 8, 18, 1, NULL, '2023-05-31 07:47:04', '2023-05-31 07:47:04'),
(147, 9, 18, 1, NULL, '2023-05-31 07:47:04', '2023-05-31 07:47:04'),
(148, 1, 19, 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03'),
(149, 2, 19, 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03'),
(150, 8, 19, 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03'),
(151, 9, 19, 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03'),
(152, 1, 20, 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57'),
(153, 2, 20, 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57'),
(154, 8, 20, 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57'),
(155, 9, 20, 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57');

-- --------------------------------------------------------

--
-- Table structure for table `bravo_tour_translations`
--

CREATE TABLE `bravo_tour_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `locale` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `short_desc` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `faqs` text COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `include` text COLLATE utf8mb4_unicode_ci,
  `exclude` text COLLATE utf8mb4_unicode_ci,
  `itinerary` text COLLATE utf8mb4_unicode_ci,
  `surrounding` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_tour_translations`
--

INSERT INTO `bravo_tour_translations` (`id`, `origin_id`, `locale`, `title`, `slug`, `content`, `short_desc`, `address`, `faqs`, `create_user`, `update_user`, `created_at`, `updated_at`, `include`, `exclude`, `itinerary`, `surrounding`) VALUES
(1, 4, 'en', 'Tour in Vienna', '', '<p class=\"p-rich_text_section\" style=\"color:#1d1c1d;font-family:\'Slack-Lato\', \'Slack-Fractions\', appleLogo, sans-serif;font-size:15px;background-color:#f8f8f8;\">Embark on a captivating <strong>5-day city tour of Vienna</strong> and immerse yourself in the rich history, culture, and culinary delights of this enchanting city. Explore magnificent palaces, indulge in delicious cuisine, and discover the vibrant atmosphere of Vienna\'s iconic landmarks</p>\n<div class=\"p-rich_text_section\" style=\"color:#1d1c1d;font-family:\'Slack-Lato\', \'Slack-Fractions\', appleLogo, sans-serif;font-size:15px;background-color:#f8f8f8;\">\n<ul>\n<li>Majestic Palaces: Explore the grandeur of Hofburg Palace and Schönbrunn Palace, witnessing the opulence of Vienna\'s imperial history.</li>\n<li>Cultural Delights: Discover art masterpieces at the Belvedere Palace and delve into Vienna\'s artistic heritage at the Albertina Museum.</li>\n<li>Gastronomic Experiences: Indulge in Turkish cuisine at Turkis Marianilf and enjoy delicious pizzas at Pizza Randale.</li>\n<li>Musical Enchantment: Experience the captivating performances at the State Opera, immersing yourself in Vienna\'s renowned musical legacy.</li>\n<li>Vibrant Cityscape: Soak in the energetic atmosphere of Mariahilfer Street and enjoy breathtaking views from 360 Ocean Sky.</li>\n</ul>\n</div>', 'From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of \'The City\'. Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 'Vienna', '[{\"title\":\"When and where does the tour end?\",\"content\":\"Your tour will conclude in San Francisco on Day 8 of the trip. There are no activities planned for this day so you\'re free to depart at any time. We highly recommend booking post-accommodation to give yourself time to fully experience the wonders of this iconic city!\"},{\"title\":\"When and where does the tour start?\",\"content\":\"Day 1 of this tour is an arrivals day, which gives you a chance to settle into your hotel and explore Los Angeles. The only planned activity for this day is an evening welcome meeting at 7pm, where you can get to know your guides and fellow travellers. Please be aware that the meeting point is subject to change until your final documents are released.\"},{\"title\":\"Do you arrange airport transfers?\",\"content\":\"Airport transfers are not included in the price of this tour, however you can book for an arrival transfer in advance. In this case a tour operator representative will be at the airport to greet you. To arrange this please contact our customer service team once you have a confirmed booking.\"},{\"title\":\"What is the age range\",\"content\":\"This tour has an age range of 12-70 years old, this means children under the age of 12 will not be eligible to participate in this tour. However, if you are over 70 years please contact us as you may be eligible to join the tour if you fill out G Adventures self-assessment form.\"}]', 1, 1, '2023-05-29 21:39:44', '2023-05-29 21:54:30', '[{\"title\":\"Specialized bilingual guide\"},{\"title\":\"Private Transport\"},{\"title\":\"Entrance fees (Cable and car and Moon Valley)\"},{\"title\":\"Box lunch water, banana apple and chocolate\"}]', '[{\"title\":\"Additional Services\"},{\"title\":\"Insurance\"},{\"title\":\"Drink\"},{\"title\":\"Tickets\"}]', '[{\"image_id\":\"390\",\"title\":\"Day 1\",\"desc\":\"Hofburg Palace, Naschmarkt & Sch\\u00f6nbrunn Palace\",\"content\":\"Begin your Vienna adventure with a visit to the majestic Hofburg Palace, steeped in imperial history. Explore the vibrant Naschmarkt for an eclectic mix of flavors and unique finds, and end the day with the splendor of Sch\\u00f6nbrunn Palace\'s breathtaking gardens.\"},{\"image_id\":\"109\",\"title\":\"Day 2\",\"desc\":\"Belvedere Palace, Stadtpark & State Opera\",\"content\":\"Immerse yourself in art and culture at the Belvedere Palace, where you\'ll encounter masterpieces like Gustav Klimt\'s \\\"The Kiss.\\\" Take a leisurely stroll through Stadtpark, relax amidst its serene surroundings, and delve into Vienna\'s artistic treasures at the Albertina Museum. Indulge in a delightful Turkish meal at Turkis Marianilf, and experience the magic of the State Opera in the evening.\"},{\"image_id\":\"108\",\"title\":\"Day 3\",\"desc\":\"Caf\\u00e9 Museum, Natural- Art Museum & Rathausplace\",\"content\":\"Begin your day with Viennese charm at Caf\\u00e9 Museum, known for its delectable pastries. Explore the Natural History Museum\'s fascinating exhibits, and enjoy a culinary journey at O Bouf\\u00e9s restaurant. In the afternoon, soak up the atmosphere at Rathausplatz, where seasonal events and bustling markets await.\"},{\"image_id\":\"107\",\"title\":\"Day 4\",\"desc\":\"Caf\\u00e9 Schwarzenberg, Prater & Pizza Day\",\"content\":\"Start your day at Caf\\u00e9 Schwarzenberg, savoring Viennese coffee culture at its finest. Thrill yourself at Prater amusement park with its exciting rides and entertainment, and treat your taste buds to authentic Italian pizzas at Pizza Randale.\"},{\"image_id\":null,\"title\":\"Day 5\",\"desc\":\"360 Oceac Sky, Mariahilfer Street & Ferhat Kebab\",\"content\":\"Take in breathtaking views from 360 Ocean Sky and discover the shopping delights of Mariahilfer Street. Indulge in the flavors of Ferhat Doner Re and enjoy a satisfying doner kebab before bidding farewell to Vienna.\"}]', NULL),
(2, 17, 'en', 'Tour in Salzburg', '', '<p>Embark on a remarkable 3-day city tour in Salzburg, where historical charm and natural beauty await at every turn. Here are three highlights that make this tour truly unforgettable:</p>\n<ul>\n<li>Mirabell Palace and Garden: Immerse yourself in the beauty of this enchanting palace and its meticulously manicured gardens, featuring the iconic Pegasus Fountain.</li>\n<li>Mondsee: Explore the picturesque lakeside town of Mondsee, known for its stunning Lake Mondsee and the magnificent Mondsee Abbey.</li>\n<li>Fortress Hohensalzburg: Discover the medieval charm of this impressive fortress perched on a hill, offering panoramic views of Salzburg and a journey into its rich history.</li>\n</ul>', NULL, 'Salzburg', '[{\"title\":\"What is the best time to visit Salzburg?\",\"content\":\"A: Salzburg is a year-round destination, but the best time to visit is during the summer months (June to August) when the weather is pleasant and outdoor activities are in full swing. The city is also charming during the winter holiday season, especially if you want to experience the festive atmosphere and visit the famous Salzburg Christmas markets.\"},{\"title\":\"How do I get from Salzburg Airport to the city center?\",\"content\":\"A: Salzburg Airport is conveniently located just a few kilometers from the city center. You can easily reach the city center by taxi, airport shuttle service, or public transportation. The Salzburg Airport W. A. Mozart is well-connected with regular bus services that take you directly to the city center and other major attractions.\"},{\"title\":\"Are there any Sound of Music tours available in Salzburg?\",\"content\":\"A: Yes, Salzburg is famous for its association with the beloved movie \\\"The Sound of Music.\\\" There are several guided tours available that take you to the iconic filming locations, including the Mirabell Gardens, Nonnberg Abbey, and the Leopoldskron Palace. These tours offer a chance to relive the magic of the movie and learn interesting behind-the-scenes facts.\"}]', 1, 1, '2023-05-31 07:21:42', '2023-05-31 07:41:47', NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"mirabell palace and garden , doner mann restaurant , getredegasse streets\",\"content\":\"Begin your tour with a visit to the enchanting Mirabell Palace and its exquisite gardens, where you can immerse yourself in the beauty of Baroque architecture. Indulge in a delightful meal at Doner Mann restaurant and explore the charming streets of Getreidegasse, known for its historical significance and unique shops.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"mondsee , op of salzburg (telef\\u00e8ric) , kitzsteinhorn , sofra restaurant\",\"content\":\"Venture beyond Salzburg to the serene town of Mondsee, where you can enjoy the picturesque views of Lake Mondsee and visit the impressive Mondsee Abbey. Take a thrilling cable car ride to the Top of Salzburg, offering breathtaking alpine panoramas, and conclude the day with a delicious meal at Sofra restaurant.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"hellbrunn palace , fortress hohen Salzburg , eleven 11:11 eleven restaurant\",\"content\":\"Discover the fascinating Hellbrunn Palace, known for its captivating gardens and intriguing trick fountains. Immerse yourself in the medieval heritage of Salzburg by exploring the grand Fortress Hohensalzburg. Wrap up your tour with a memorable dining experience at Eleven 11:11 Eleven restaurant, savoring innovative cuisine in a cozy atmosphere.\"}]', NULL),
(3, 18, 'en', 'Tour in Geneva', '', '<p>Embark on a remarkable 3-day city tour in Geneva , where historical charm and natural beauty await at every turn. Here are three highlights that make this tour truly unforgettable:</p>\n<ul>\n<li>Lake Geneva: Explore the stunning beauty of one of Europe\'s largest lakes and witness the iconic Jet d\'Eau.</li>\n<li>Reformation Wall and Musee Ariana: Discover Geneva\'s history and culture at the Reformation Wall monument and Musee Ariana, showcasing ceramics and glass art.</li>\n<li>Rue du Rhone and Centre Commercial Balexert: Enjoy a shopping spree at Rue du Rhone, known for luxury boutiques, and Centre Commercial Balexert, a large shopping center.</li>\n</ul>', NULL, 'Geneva', '[{\"title\":\"What are the must-see attractions in Geneva?\",\"content\":\"Some of the must-see attractions in Geneva include the Jet d\'Eau, a magnificent water fountain on Lake Geneva; the Old Town with its charming cobblestone streets; the United Nations Office; and the St. Pierre Cathedral, offering panoramic views of the city.\"},{\"title\":\"What is the best time to visit Geneva?\",\"content\":\"Geneva is a year-round destination, but the best time to visit is during the summer months (June to August) when the weather is pleasant, and outdoor activities and festivals are in full swing. Spring (April to May) and autumn (September to October) also offer mild weather and fewer crowds.\"},{\"title\":\"What is Geneva known for?\",\"content\":\"Geneva is renowned as a global hub for diplomacy and international cooperation, hosting numerous international organizations such as the United Nations and the Red Cross. It is also known for its stunning lakeside setting, luxury watchmaking industry, vibrant cultural scene, and being a center for fine dining and chocolate.\"}]', 1, 1, '2023-05-31 07:47:04', '2023-05-31 07:49:31', NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"lake geneva  jet d eau  cafe remor -jardin anglais\",\"content\":\"Begin your tour by immersing yourself in the beauty of Lake Geneva, where you can take a leisurely stroll along the lakeside promenade and admire the stunning views. Don\'t miss the iconic Jet d\'Eau, a magnificent water fountain that graces the lake\'s horizon. Enjoy a delightful break at Caf\\u00e9 Remor, savoring delicious Swiss cuisine. Explore Jardin Anglais, a tranquil park offering scenic spots and the famous L\'Horloge Fleurie, a stunning flower clock.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"reformation wall musee ariana rue du rhone  ali haydar kebab\",\"content\":\"Discover Geneva\'s rich history and culture by visiting the Reformation Wall, an impressive monument commemorating the Protestant Reformation. Dive into the world of ceramics and glass art at Musee Ariana, home to a remarkable collection of exquisite pieces. Indulge in a shopping spree on Rue du Rhone, known for its luxury boutiques and high-end fashion. Treat yourself to a flavorful meal at Ali Haydar Kebab, savoring authentic Middle Eastern cuisine.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"parc de mon repos  centre commercial balexert  street beirut restaurant\",\"content\":\"Relax and unwind at Parc de Mon Repos, a peaceful park where you can enjoy nature, stroll along its pathways, and perhaps have a picnic. Experience shopping at its finest at Centre Commercial Balexert, a large shopping center offering a wide range of stores and boutiques to satisfy all your retail desires. End your tour on a culinary note by dining at Street Beirut Restaurant, immersing yourself in the flavors of Lebanese cuisine.\"}]', NULL),
(4, 19, 'en', 'Tour in Paris', '', '<p>Embark on a memorable tour of Paris, immersing yourself in its rich history, breathtaking landmarks, and vibrant culture. Over the course of three days, you\'ll explore iconic sites such as the majestic Arc de Triomphe and the world-famous Eiffel Tower, where you\'ll be treated to panoramic views of the city. Cruise along the enchanting Seine River, stroll through the tranquil Luxembourg Garden, and marvel at the architectural grandeur of Notre Dame de Paris. Immerse yourself in the art world at the renowned Musee d\'Orsay and the historic Louvre Museum, home to masterpieces that have captivated audiences for centuries. Indulge your taste buds with the flavors of the Middle East at Al Dar Restaurant. This tour promises an unforgettable journey through the captivating beauty and cultural treasures of the City of Light.</p>\n<ul>\n<li>Iconic Landmarks: Arc de Triomphe, Eiffel Tower, Seine River</li>\n<li>Artistic Treasures: Musee d\'Orsay, Louvre Museum</li>\n<li>Cultural Delights: Luxembourg Garden, Al Dar Restaurant</li>\n</ul>', NULL, 'Paris', '[{\"title\":\"How can I skip the long lines at popular attractions like the Louvre Museum in Paris?\",\"content\":\"To avoid long queues, it\'s recommended to purchase skip-the-line tickets or consider visiting during less busy times such as early morning or weekdays.\"},{\"title\":\"What is the best way to get around Paris and explore its attractions?\",\"content\":\"Paris has an extensive public transportation system, including the metro, buses, and trams, making it convenient to navigate the city. Alternatively, renting a bicycle or walking can be great options to explore the city\'s charming streets and landmarks.\"},{\"title\":\"Are there any specific dress codes to keep in mind when visiting religious sites in Paris, such as Notre Dame Cathedral?\",\"content\":\"It\'s advisable to dress modestly when visiting religious sites in Paris. This generally means avoiding revealing clothing and ensuring shoulders and knees are covered. Respectful attire shows appreciation for the cultural and religious significance of these sites.\"}]', 1, NULL, '2023-05-31 08:12:03', '2023-05-31 08:12:03', NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"Eiffel tower , seine river , luxembourg garden , frenchy taste restaurant\",\"content\":\"Start your Paris adventure by visiting two iconic landmarks, the Arc de Triomphe and the majestic Eiffel Tower. Take in breathtaking views of the city from the top of these architectural marvels. Enjoy a leisurely stroll along the Seine River and immerse yourself in the beauty of the Luxembourg Garden. Indulge in a delightful culinary experience at Frenchy Taste Restaurant, savoring delicious French cuisine.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"notre dame de paris , musee d\'orsay  , louvre museum , al dar restaurant\",\"content\":\"Explore the cultural and artistic gems of Paris. Begin with a visit to the magnificent Notre Dame de Paris, admiring its Gothic architecture and rich history. Continue to the Musee d\'Orsay, home to an impressive collection of Impressionist and Post-Impressionist masterpieces. Then, venture to the world-famous Louvre Museum, where you can marvel at timeless works of art, including the iconic Mona Lisa. Conclude your day with a delightful meal at Al Dar Restaurant, indulging in exquisite Middle Eastern flavors.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"latin quarter , avenue des champs , galeries lafayette  , new jawad restaurant\",\"content\":\"Discover the vibrant atmosphere of the Latin Quarter, known for its lively streets, charming cafes, and bohemian ambiance. Wander along the iconic Avenue des Champs-\\u00c9lys\\u00e9es, lined with luxurious shops and iconic landmarks. Explore the renowned Galeries Lafayette, a shopper\'s paradise offering a wide range of high-end fashion and luxury goods. Treat your taste buds to a culinary journey at New Jawad Restaurant, savoring delicious Middle Eastern cuisine in a warm and inviting setting.\"}]', NULL),
(5, 20, 'en', 'Tour in Interlaken', '', '<p>Interlaken is a breathtaking destination nestled in the heart of the Swiss Alps, offering a plethora of natural beauty and thrilling adventures.</p>\n<ul>\n<li>Breathtaking Alpine Beauty: Explore the stunning Lake Thun and Lake Brienz, surrounded by awe-inspiring mountain landscapes.</li>\n<li>Thrilling Mountain Adventures: Ascend to the summit of Schilthorn for panoramic views and discover the captivating St. Beatus Cave.</li>\n<li>Cultural Immersion: Immerse yourself in Swiss history and culture at the Ballenberg Swiss Open-Air Museum and experience the charm of Unterseen village.</li>\n</ul>', NULL, 'Interlaken', '[{\"title\":\"What are the must-visit natural attractions in Interlaken?\",\"content\":\"Interlaken is blessed with breathtaking natural beauty. Don\'t miss the stunning lakes of Thun and Brienz, as well as the magnificent Schilthorn mountain. These attractions offer picturesque views and unforgettable experiences.\"},{\"title\":\"Are there any adventure activities available in Interlaken?\",\"content\":\"Absolutely! Interlaken is known as the adventure capital of Switzerland. You can indulge in thrilling activities like paragliding, skydiving, canyoning, and bungee jumping. The region\'s natural landscape provides the perfect backdrop for adrenaline-pumping adventures\"},{\"title\":\"What cultural experiences can I have in Interlaken?\",\"content\":\"Interlaken offers unique cultural experiences as well. Visit the St. Beatus Cave to explore its fascinating underground formations. Don\'t miss the Ballenberg Swiss Open-Air Museum, where you can immerse yourself in traditional Swiss architecture, crafts, and customs. These attractions provide insights into the rich cultural heritage of the region\"}]', 1, NULL, '2023-05-31 08:32:57', '2023-05-31 08:32:57', NULL, NULL, '[{\"image_id\":null,\"title\":\"Day 1\",\"desc\":\"lake thun , schilthorn , layaly Beirut , lake brienz\",\"content\":\"Begin your day by exploring the picturesque Lake Thun, surrounded by stunning mountain scenery. Afterward, embark on an unforgettable journey to the summit of Schilthorn, where you\'ll be rewarded with breathtaking panoramic views. For a delightful culinary experience, indulge in the flavors of Lebanon at the Layaly Beirut restaurant. End your day by visiting the enchanting Lake Brienz, known for its crystal-clear waters and charming ambiance.\"},{\"image_id\":null,\"title\":\"Day 2\",\"desc\":\"st. Beatus cave , bellenberg swiss open air museum ,  Aare Korean BBQ restaurant\",\"content\":\"Delve into the fascinating St. Beatus Cave, a natural wonder filled with awe-inspiring rock formations and mythical legends. Immerse yourself in Swiss history and traditions at the Ballenberg Swiss Open-Air Museum, where you can explore authentic Swiss buildings and artifacts. Enjoy a delectable dining experience at Aare Korean BBQ restaurant, savoring the flavors of Korean cuisine.\"},{\"image_id\":null,\"title\":\"Day 3\",\"desc\":\"Harder kulm  , unterseen ,  jungfraupark , napoli pizza\\u00a0restaurant\",\"content\":\"Ascend to the summit of Harder Kulm and be rewarded with panoramic views of Interlaken and the surrounding Alps. Take a leisurely stroll through the charming village of Unterseen, known for its quaint streets and traditional Swiss architecture. Discover the exciting Jungfraupark, a family-friendly amusement park with thrilling rides and entertainment. End your day with a taste of Italy at Napoli Pizza restaurant, where you can indulge in delicious pizzas and Italian specialties.\"}]', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bravo_user_plan`
--

CREATE TABLE `bravo_user_plan` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) NOT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `max_service` int(11) DEFAULT '0',
  `price` decimal(12,2) DEFAULT NULL,
  `plan_data` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) DEFAULT '1',
  `user_id` bigint(20) DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `car_seats`
--

CREATE TABLE `car_seats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `car_types`
--

CREATE TABLE `car_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_classes_id` bigint(20) UNSIGNED NOT NULL,
  `car_seats_id` bigint(20) UNSIGNED NOT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ch_favorites`
--

CREATE TABLE `ch_favorites` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `favorite_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ch_messages`
--

CREATE TABLE `ch_messages` (
  `id` bigint(20) NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_id` bigint(20) NOT NULL,
  `to_id` bigint(20) NOT NULL,
  `body` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_inbox`
--

CREATE TABLE `core_inbox` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_user` bigint(20) DEFAULT NULL,
  `to_user` bigint(20) DEFAULT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_model` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint(4) DEFAULT '0',
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_inbox_messages`
--

CREATE TABLE `core_inbox_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inbox_id` bigint(20) DEFAULT NULL,
  `from_user` bigint(20) DEFAULT NULL,
  `to_user` bigint(20) DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `type` tinyint(4) DEFAULT '0',
  `is_read` tinyint(4) DEFAULT '0',
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `core_languages`
--

CREATE TABLE `core_languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `last_build_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `core_languages`
--

INSERT INTO `core_languages` (`id`, `locale`, `name`, `flag`, `status`, `create_user`, `update_user`, `last_build_at`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'en', 'English', 'gb', 'publish', 1, NULL, NULL, NULL, '2023-03-14 13:15:34', '2023-03-14 13:15:34'),
(2, 'ja', 'Japanese', 'jp', 'publish', 1, NULL, NULL, NULL, '2023-03-14 13:15:34', '2023-03-14 13:15:34'),
(3, 'egy', 'Egyptian', 'eg', 'publish', 1, NULL, NULL, NULL, '2023-03-14 13:15:34', '2023-03-14 13:15:34');

-- --------------------------------------------------------

--
-- Table structure for table `core_menus`
--

CREATE TABLE `core_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `items` longtext COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `core_menus`
--

INSERT INTO `core_menus` (`id`, `name`, `items`, `create_user`, `update_user`, `origin_id`, `lang`, `created_at`, `updated_at`) VALUES
(1, 'Main Menu', '[{\"name\":\"Home\",\"url\":\"\\/\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel\",\"url\":\"\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Hotel List\",\"url\":\"\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel Map\",\"url\":\"\\/hotel?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel Detail\",\"url\":\"\\/hotel\\/parian-holiday-villas\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Tours\",\"url\":\"\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Tour List\",\"url\":\"\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Tour Map\",\"url\":\"\\/tour?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Tour Detail\",\"url\":\"\\/tour\\/paris-vacation-travel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Space\",\"url\":\"\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Space List\",\"url\":\"\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Space Map\",\"url\":\"\\/space?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Space Detail\",\"url\":\"\\/space\\/stay-greenwich-village\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Car\",\"url\":\"\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Car List\",\"url\":\"\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Car Map\",\"url\":\"\\/car?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Car Detail\",\"url\":\"\\/car\\/vinfast-lux-a20-plus\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Airboat Transportation\",\"url\":\"\\/AirboatTransportation\",\"item_model\":\"custom\",\"_open\":true,\"class\":\"ds\",\"target\":\"\",\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"City Transportation\",\"url\":\"\\/CityTransportation\",\"item_model\":\"custom\",\"_open\":true,\"model_name\":\"Custom\",\"is_removed\":true}]},{\"name\":\"Event\",\"url\":\"\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Event List\",\"url\":\"\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Event Map\",\"url\":\"\\/event?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Event Detail\",\"url\":\"\\/event\\/aspen-glade-weddings-events\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Flight\",\"url\":\"\\/flight\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false},{\"name\":\"Boat\",\"url\":\"\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Boat List\",\"url\":\"\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Boat Map\",\"url\":\"\\/boat?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Boat Detail\",\"url\":\"\\/boat\\/blue-moon-yc-300\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Pages\",\"url\":\"#\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Plan\",\"url\":\"\\/plan\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"News List\",\"url\":\"\\/news\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"News Detail\",\"url\":\"\\/news\\/morning-in-the-northern-sea\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Location Detail\",\"url\":\"\\/location\\/paris\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Become a vendor\",\"url\":\"\\/page\\/become-a-vendor\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Contact\",\"url\":\"\\/contact\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]}]', 1, 7, NULL, NULL, '2023-03-14 13:15:35', '2023-07-05 08:52:31'),
(2, 'Main Menu 2', '[{\"name\":\"Home\",\"url\":\"\\/\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"Package\",\"url\":\"\\/tour\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"Contact\",\"url\":\"\\/contact\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"About us\",\"url\":\"#\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true}]', 1, 1, NULL, NULL, '2023-05-16 13:51:16', '2024-02-11 15:49:15'),
(3, 'test', '[{\"name\":\"test\",\"url\":\"\\/test\",\"item_model\":\"custom\",\"_open\":true}]', 1, 1, NULL, NULL, '2023-05-16 14:17:59', '2023-05-16 14:18:54');

-- --------------------------------------------------------

--
-- Table structure for table `core_menu_translations`
--

CREATE TABLE `core_menu_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `items` longtext COLLATE utf8mb4_unicode_ci,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `core_menu_translations`
--

INSERT INTO `core_menu_translations` (`id`, `origin_id`, `locale`, `items`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES
(1, 1, 'ja', '[{\"name\":\"Home\",\"url\":\"\\/ja\\/\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Home Page\",\"url\":\"\\/ja\\/\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Page v2\",\"url\":\"\\/ja\\/page\\/home-page-v2\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Hotel\",\"url\":\"\\/ja\\/page\\/hotel\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Tour Agency\",\"url\":\"\\/ja\\/page\\/home-tour-agency\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Tour\",\"url\":\"\\/ja\\/page\\/tour\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Space\",\"url\":\"\\/ja\\/page\\/space\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Car\",\"url\":\"\\/ja\\/page\\/car\",\"item_model\":\"custom\",\"children\":[]}]},{\"name\":\"Hotel\",\"url\":\"\\/ja\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Hotel List\",\"url\":\"\\/ja\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Hotel Map\",\"url\":\"\\/ja\\/hotel?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Hotel Detail\",\"url\":\"\\/ja\\/hotel\\/parian-holiday-villas\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Tours\",\"url\":\"\\/ja\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Tour List\",\"url\":\"\\/ja\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Tour Map\",\"url\":\"\\/ja\\/tour?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Tour Detail\",\"url\":\"\\/ja\\/tour\\/paris-vacation-travel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Space\",\"url\":\"\\/ja\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Space List\",\"url\":\"\\/ja\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Space Map\",\"url\":\"\\/ja\\/space?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Space Detail\",\"url\":\"\\/ja\\/space\\/stay-greenwich-village\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Car\",\"url\":\"\\/ja\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Car List\",\"url\":\"\\/ja\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Car Map\",\"url\":\"\\/ja\\/car?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Car Detail\",\"url\":\"\\/ja\\/car\\/vinfast-lux-a20-plus\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Event\",\"url\":\"\\/ja\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Event List\",\"url\":\"\\/ja\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Event Map\",\"url\":\"\\/ja\\/event?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Event Detail\",\"url\":\"\\/ja\\/event\\/aspen-glade-weddings-events\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Flight\",\"url\":\"\\/ja\\/flight\",\"item_model\":\"custom\",\"model_name\":\"Custom\"},{\"name\":\"Boat\",\"url\":\"\\/ja\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Boat List\",\"url\":\"\\/ja\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Boat Map\",\"url\":\"\\/ja\\/boat?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Boat Detail\",\"url\":\"\\/ja\\/boat\\/blue-moon-yc-300\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Pages\",\"url\":\"#\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Plan\",\"url\":\"\\/ja\\/plan\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"News List\",\"url\":\"\\/ja\\/news\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"News Detail\",\"url\":\"\\/ja\\/news\\/morning-in-the-northern-sea\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Location Detail\",\"url\":\"\\/ja\\/location\\/paris\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Become a vendor\",\"url\":\"\\/ja\\/page\\/become-a-vendor\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Contact\",\"url\":\"\\/ja\\/contact\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]}]', 1, NULL, '2023-03-14 13:15:35', NULL),
(2, 1, 'egy', '[{\"name\":\"Home\",\"url\":\"\\/egy\\/\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Home Page\",\"url\":\"\\/egy\\/\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Page v2\",\"url\":\"\\/egy\\/page\\/home-page-v2\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Hotel\",\"url\":\"\\/egy\\/page\\/hotel\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Tour Agency\",\"url\":\"\\/egy\\/page\\/home-tour-agency\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Tour\",\"url\":\"\\/egy\\/page\\/tour\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Space\",\"url\":\"\\/egy\\/page\\/space\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Home Car\",\"url\":\"\\/egy\\/page\\/car\",\"item_model\":\"custom\",\"children\":[]}]},{\"name\":\"Hotel\",\"url\":\"\\/egy\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Hotel List\",\"url\":\"\\/egy\\/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Hotel Map\",\"url\":\"\\/egy\\/hotel?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Hotel Detail\",\"url\":\"\\/egy\\/hotel\\/parian-holiday-villas\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Tours\",\"url\":\"\\/egy\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Tour List\",\"url\":\"\\/egy\\/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Tour Map\",\"url\":\"\\/egy\\/tour?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Tour Detail\",\"url\":\"\\/egy\\/tour\\/paris-vacation-travel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Space\",\"url\":\"\\/egy\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Space List\",\"url\":\"\\/egy\\/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Space Map\",\"url\":\"\\/egy\\/space?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Space Detail\",\"url\":\"\\/egy\\/space\\/stay-greenwich-village\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Car\",\"url\":\"\\/egy\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Car List\",\"url\":\"\\/egy\\/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Car Map\",\"url\":\"\\/egy\\/car?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Car Detail\",\"url\":\"\\/egy\\/car\\/vinfast-lux-a20-plus\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Event\",\"url\":\"\\/egy\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Event List\",\"url\":\"\\/egy\\/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Event Map\",\"url\":\"\\/egy\\/event?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Event Detail\",\"url\":\"\\/egy\\/event\\/aspen-glade-weddings-events\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Flight\",\"url\":\"\\/egy\\/flight\",\"item_model\":\"custom\",\"model_name\":\"Custom\"},{\"name\":\"Boat\",\"url\":\"\\/egy\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Boat List\",\"url\":\"\\/egy\\/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Boat Map\",\"url\":\"\\/egy\\/boat?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Boat Detail\",\"url\":\"\\/egy\\/boat\\/blue-moon-yc-300\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]},{\"name\":\"Pages\",\"url\":\"#\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[{\"name\":\"Plan\",\"url\":\"\\/egy\\/plan\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"News List\",\"url\":\"\\/egy\\/news\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"News Detail\",\"url\":\"\\/egy\\/news\\/morning-in-the-northern-sea\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]},{\"name\":\"Location Detail\",\"url\":\"\\/egy\\/location\\/paris\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Become a vendor\",\"url\":\"\\/egy\\/page\\/become-a-vendor\",\"item_model\":\"custom\",\"children\":[]},{\"name\":\"Contact\",\"url\":\"\\/egy\\/contact\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"children\":[]}]}]', 1, NULL, '2023-03-14 13:15:35', NULL),
(3, 1, 'en', '[{\"name\":\"Home\",\"url\":\"/\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel\",\"url\":\"/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Hotel List\",\"url\":\"/hotel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel Map\",\"url\":\"/hotel?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Hotel Detail\",\"url\":\"/hotel/parian-holiday-villas\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Tours\",\"url\":\"/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Tour List\",\"url\":\"/tour\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Tour Map\",\"url\":\"/tour?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Tour Detail\",\"url\":\"/tour/paris-vacation-travel\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Space\",\"url\":\"/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Space List\",\"url\":\"/space\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Space Map\",\"url\":\"/space?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Space Detail\",\"url\":\"/space/stay-greenwich-village\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Car\",\"url\":\"/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Car List\",\"url\":\"/car\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Car Map\",\"url\":\"/car?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Car Detail\",\"url\":\"/car/vinfast-lux-a20-plus\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Airboat Transportation\",\"url\":\"/AirboatTransportation\",\"item_model\":\"custom\",\"_open\":true,\"class\":\"ds\",\"target\":\"\",\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"City Transportation\",\"url\":\"/CityTransportation\",\"item_model\":\"custom\",\"_open\":true,\"model_name\":\"Custom\",\"is_removed\":true}]},{\"name\":\"Event\",\"url\":\"/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Event List\",\"url\":\"/event\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Event Map\",\"url\":\"/event?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Event Detail\",\"url\":\"/event/aspen-glade-weddings-events\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Flight\",\"url\":\"/flight\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false},{\"name\":\"Boat\",\"url\":\"/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Boat List\",\"url\":\"/boat\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Boat Map\",\"url\":\"/boat?_layout=map\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Boat Detail\",\"url\":\"/boat/blue-moon-yc-300\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]},{\"name\":\"Pages\",\"url\":\"#\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[{\"name\":\"Plan\",\"url\":\"/plan\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"News List\",\"url\":\"/news\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"News Detail\",\"url\":\"/news/morning-in-the-northern-sea\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Location Detail\",\"url\":\"/location/paris\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Become a vendor\",\"url\":\"/page/become-a-vendor\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]},{\"name\":\"Contact\",\"url\":\"/contact\",\"item_model\":\"custom\",\"model_name\":\"Custom\",\"is_removed\":true,\"_open\":false,\"children\":[]}]}]', 1, 7, '2023-03-27 03:40:13', '2023-07-05 08:52:31'),
(4, 2, 'en', '[{\"name\":\"Home\",\"url\":\"/\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"Package\",\"url\":\"/tour\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"Contact\",\"url\":\"/contact\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true},{\"name\":\"About us\",\"url\":\"#\",\"item_model\":\"custom\",\"_open\":false,\"model_name\":\"Custom\",\"is_removed\":true}]', 1, 1, '2023-05-16 13:51:16', '2024-02-11 15:49:15'),
(5, 3, 'en', '[{\"name\":\"test\",\"url\":\"/test\",\"item_model\":\"custom\",\"_open\":true}]', 1, 1, '2023-05-16 14:17:59', '2023-05-16 14:18:54');

-- --------------------------------------------------------

--
-- Table structure for table `core_news`
--

CREATE TABLE `core_news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `origin_id` bigint(20) DEFAULT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `core_news`
--

INSERT INTO `core_news` (`id`, `title`, `content`, `slug`, `status`, `cat_id`, `image_id`, `create_user`, `update_user`, `deleted_at`, `origin_id`, `lang`, `created_at`, `updated_at`, `author_id`) VALUES
(1, 'The day on Paris', ' From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception  From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception <br/>From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception<br/>\r\n    From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 'the-day-on-paris', 'publish', 1, 115, 1, NULL, '2023-05-17 02:01:53', NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 02:01:53', 1),
(2, 'Pure Luxe in Punta Mita', ' From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception <br/>From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception<br/>\r\n    From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 'pure-luxe-in-punta-mita', 'publish', 3, 116, 1, NULL, '2023-05-17 02:01:53', NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 02:01:53', 1),
(3, 'All Aboard the Rocky Mountaineer', ' From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception  From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception <br/>From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception<br/>\r\n    From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 'all-aboard-the-rocky-mountaineer', 'publish', 1, 117, 1, NULL, '2023-05-17 02:01:53', NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 02:01:53', 1),
(4, 'City Spotlight: Philadelphia', ' From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception  From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception <br/>From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception<br/>\r\n    From the iconic to the unexpected, the city of San Francisco never ceases to surprise. Kick-start your effortlessly delivered Northern California holiday in the cosmopolitan hills of  The City . Join your Travel Director and fellow travellers for a Welcome Reception at your hotel.Welcome Reception', 'city-spotlight-philadelphia', 'publish', 4, 118, 1, NULL, '2023-05-17 02:01:53', NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 02:01:53', 1),
(5, 'GoTravoo\'s Comprehensive Guide to Choosing the Perfect Rental Car for Your Vacation', '<p>Vacation planning often revolves around flights, accommodation, and itineraries, but choosing the right rental car can also significantly impact your travel experience. GoTravoo\'s Rent-a-Car services offer a wide range of vehicles, ensuring you find the perfect car for your needs. Here\'s our guide to choosing the best rental car for your next vacation.</p>\r\n<p><strong>Consider Your Destination</strong></p>\r\n<p>Your destination can influence the type of car you need. If you\'re exploring European cities with narrow streets, a compact car might be your best bet. For a countryside getaway, consider a vehicle with off-road capabilities like an SUV.</p>\r\n<p><strong>Think About Your Traveling Party</strong></p>\r\n<p>The size of your traveling party matters. A couple might only need a small car, while a family or a group of friends could require a minivan or an SUV. GoTravoo offers a variety of vehicles to accommodate different group sizes comfortably.</p>\r\n<p><strong>Keep Your Luggage in Mind</strong></p>\r\n<p>Consider the amount of luggage you\'ll be bringing along. Ensure the vehicle has enough cargo space for your suitcases, and remember to leave room for any souvenirs you might pick up along the way!</p>\r\n<p><strong>Factor in Comfort and Features</strong></p>\r\n<p>Long drives can be tiring, so comfort should be a priority. Look for vehicles with comfortable seats, ample legroom, and modern infotainment systems. If you\'re traveling during summer, make sure the car has effective air conditioning.</p>\r\n<p><strong>Fuel Efficiency Matters</strong></p>\r\n<p>Fuel efficiency can make a significant difference to your travel budget. GoTravoo\'s selection includes many fuel-efficient models, helping you save money and reduce your carbon footprint.</p>\r\n<p><strong>Luxury Options for Special Occasions</strong></p>\r\n<p>If you\'re planning a special trip, consider splurging on a luxury vehicle. GoTravoo offers a range of premium cars, adding a touch of sophistication and luxury to your vacation.</p>\r\n<p><strong>Conclusion</strong></p>\r\n<p>Choosing the perfect rental car can enhance your vacation experience, and GoTravoo is here to help. With our wide selection of quality vehicles and easy-to-use booking system, you\'re sure to find the perfect car for your travel needs. Start planning your perfect vacation with GoTravoo today!</p>', 'tiptoe-through-the-tulips-of-washington', 'publish', 4, 244, 1, 1, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 02:01:35', 40),
(6, 'Why Rent-a-Car Services are Essential for Your Next Business Trip', '<p>In the world of business, time is money. When you\'re traveling for work, efficiency and reliability are paramount. That\'s where GoTravoo\'s Rent-a-Car services come in, offering a range of benefits that can make your next business trip more productive, less stressful, and even enjoyable.</p>\r\n<p><strong>Flexibility and Convenience</strong></p>\r\n<p>With GoTravoo\'s Rent-a-Car services, you have the freedom to travel according to your own schedule. No more waiting around for taxis or trying to navigate public transportation in a foreign city. You can go from meeting to meeting with ease, and even take some time to explore your surroundings.</p>\r\n<p><strong>First Impressions Matter</strong></p>\r\n<p>Arriving in a stylish, well-maintained car can create a positive first impression. Whether you\'re meeting with potential clients, partners, or employers, showing up in a quality vehicle can send a message of professionalism and reliability.</p>\r\n<p><strong>A Wide Range of Vehicles</strong></p>\r\n<p>GoTravoo offers a wide range of vehicles to suit your specific needs. From luxury cars for high-stakes meetings to practical sedans for efficient city travel, you\'ll find the perfect car for your business trip. And with our seamless booking process, reserving your vehicle is a breeze.</p>\r\n<p><strong>Reduced Travel Stress</strong></p>\r\n<p>Traveling can be stressful, especially when you\'re on a tight schedule. Renting a car can alleviate some of this stress by giving you control over your journey. No more worrying about missing a bus or train &ndash; with a rental car, you\'re in the driver\'s seat.</p>\r\n<p><strong>Added Comfort</strong></p>\r\n<p>Our fleet of cars is designed with comfort in mind, making them ideal for long journeys or busy days of back-to-back meetings. Enjoy spacious interiors, advanced infotainment systems, and smooth performance to make your business trip as comfortable as possible.</p>\r\n<p><strong>Conclusion</strong></p>\r\n<p>Rent-a-Car services, like those offered by GoTravoo, are essential for business trips. They provide the flexibility, convenience, and comfort that business travelers need, allowing you to focus on what matters most &ndash; your work. So, for your next business trip, consider GoTravoo\'s Rent-a-Car services for a more efficient and enjoyable travel experience.</p>', 'a-seaside-reset-in-laguna-beach', 'publish', 5, 243, 1, 1, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 01:57:55', 40),
(7, 'Experience Luxury on the Road: Discovering GoTravoo\'s Premium Car Rental Options', '<p>Are you planning to explore the stunning landscapes and vibrant cities of Europe? If so, consider the flexibility, convenience, and independence offered by GoTravoo\'s Rent-a-Car services. It&rsquo;s the perfect way to discover Europe at your own pace and according to your own itinerary.</p>\r\n<p><strong>Why Choose GoTravoo\'s Rent-a-Car Services</strong></p>\r\n<p>GoTravoo\'s Rent-a-Car service is designed to make your European adventure seamless and enjoyable. With a wide selection of vehicles, from compact cars perfect for city driving, to luxurious SUVs suitable for family trips, GoTravoo ensures you travel in comfort and style.</p>\r\n<p><strong>Convenience and Flexibility</strong></p>\r\n<p>When you choose GoTravoo, you can pick up and drop off your rental car at a location that suits you. This flexibility allows you to start your journey from anywhere and plan your route without any restrictions. You are not bound by train or bus schedules, giving you the freedom to explore off-the-beaten-path destinations or extend your stay in places you love.</p>\r\n<p><strong>Quality and Variety</strong></p>\r\n<p>GoTravoo offers a wide range of high-quality vehicles from top manufacturers like Mercedes, Audi, and Range Rover. Whether you\'re looking for a fuel-efficient car for city exploration, a spacious van for group travel, or a luxury vehicle for a special occasion, GoTravoo has got you covered.</p>\r\n<p><strong>Easy Booking Process</strong></p>\r\n<p>GoTravoo\'s booking process is easy and straightforward. The booking is automatically managed via an API, ensuring a smooth, hassle-free experience. In addition, GoTravoo\'s customer service is always ready to assist you with any inquiries or issues.</p>\r\n<p><strong>Explore Europe with GoTravoo</strong></p>\r\n<p>Imagine cruising along the stunning Amalfi Coast, exploring the picturesque villages of Provence, or embarking on a road trip through the majestic Scottish Highlands. With GoTravoo\'s Rent-a-Car services, these dream vacations can become a reality.</p>\r\n<p>Whether you\'re visiting Europe for business or pleasure, GoTravoo\'s Rent-a-Car services offer the flexibility, convenience, and quality you need to make the most of your trip. So, why wait? Start planning your European adventure with GoTravoo today.</p>', 'america-national-parks-with-denver', 'publish', 5, 121, 1, 1, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 01:53:29', 40),
(8, 'Exploring Europe with GoTravoo\'s Rent-a-Car Services: Your Ultimate Guide', '<p>Are you planning to explore the stunning landscapes and vibrant cities of Europe? If so, consider the flexibility, convenience, and independence offered by GoTravoo\'s Rent-a-Car services. It&rsquo;s the perfect way to discover Europe at your own pace and according to your own itinerary.</p>\r\n<h2>Why Choose GoTravoo\'s Rent-a-Car Services</h2>\r\n<p>GoTravoo\'s Rent-a-Car service is designed to make your European adventure seamless and enjoyable. With a wide selection of vehicles, from compact cars perfect for city driving, to luxurious SUVs suitable for family trips, GoTravoo ensures you travel in comfort and style.</p>\r\n<h2>Convenience and Flexibility</h2>\r\n<p>When you choose GoTravoo, you can pick up and drop off your rental car at a location that suits you. This flexibility allows you to start your journey from anywhere and plan your route without any restrictions. You are not bound by train or bus schedules, giving you the freedom to explore off-the-beaten-path destinations or extend your stay in places you love.</p>\r\n<h2>Quality and Variety</h2>\r\n<p>GoTravoo offers a wide range of high-quality vehicles from top manufacturers like Mercedes, Audi, and Range Rover. Whether you\'re looking for a fuel-efficient car for city exploration, a spacious van for group travel, or a luxury vehicle for a special occasion, GoTravoo has got you covered.</p>\r\n<h2>Easy Booking Process</h2>\r\n<p>GoTravoo\'s booking process is easy and straightforward. The booking is automatically managed via an API, ensuring a smooth, hassle-free experience. In addition, GoTravoo\'s customer service is always ready to assist you with any inquiries or issues.</p>\r\n<h2>Explore Europe with GoTravoo</h2>\r\n<p>Imagine cruising along the stunning Amalfi Coast, exploring the picturesque villages of Provence, or embarking on a road trip through the majestic Scottish Highlands. With GoTravoo\'s Rent-a-Car services, these dream vacations can become a reality.</p>\r\n<p>Whether you\'re visiting Europe for business or pleasure, GoTravoo\'s Rent-a-Car services offer the flexibility, convenience, and quality you need to make the most of your trip. So, why wait? Start planning your European adventure with GoTravoo today.</p>', 'morning-in-the-northern-sea', 'publish', 1, 116, 1, 1, NULL, NULL, NULL, '2023-03-14 13:15:35', '2023-05-17 01:48:17', 40);

-- --------------------------------------------------------

--
