--
-- Host: localhost    Database: gyannewsoftware_booking23
-- ------------------------------------------------------


--
-- Table structure for table `bravo_airline`
--

CREATE TABLE `bravo_airline` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `image_id` int(11) 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,
  `author_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_airline`
--

INSERT INTO `bravo_airline` (`id`, `name`, `image_id`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `author_id`) VALUES (1,'Reynoldborough',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(2,'Lake Curtshire',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(3,'Skilesfort',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(4,'West Hymanton',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(5,'Port Genevievestad',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(6,'Kuhlmanfurt',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(7,'Lloydmouth',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(8,'Kertzmannchester',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(9,'Lake Stanfordton',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(10,'West Josieberg',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(11,'New Jessika',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(12,'North Jadynstad',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(13,'North Reginald',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(14,'North Kristinastad',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(15,'Lennaburgh',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(16,'Gleichnerland',205,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(17,'South Brent',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(18,'North Chadd',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(19,'South Otto',203,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(20,'South Elouise',204,NULL,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(21,'Biman Bangladesh Airlines',204,1,1,NULL,'2023-03-27 15:43:21','2023-03-27 15:43:25',NULL);

--
-- Table structure for table `bravo_airport`
--

CREATE TABLE `bravo_airport` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `code` varchar(191) NOT NULL,
  `address` varchar(191) DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `map_lat` varchar(20) DEFAULT NULL,
  `map_lng` varchar(20) DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  `status` varchar(30) DEFAULT 'publish',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bravo_airport_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_airport`
--

INSERT INTO `bravo_airport` (`id`, `name`, `code`, `address`, `country`, `location_id`, `description`, `map_lat`, `map_lng`, `map_zoom`, `create_user`, `update_user`, `status`, `created_at`, `updated_at`, `author_id`) VALUES (1,'Reedbury','883','95601 Kaci Bypass\nWest Robynside, HI 37440',NULL,7,'Est assumenda et nisi nostrum ex quasi dolorem. Sunt voluptas consequatur deleniti ea aliquam ullam quas nemo. Reprehenderit et non impedit consequatur fugit.','-44.714886','-23.551641',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(2,'Libbystad','41','5795 Kohler Motorway Suite 336\nEast Jimmie, PA 46841',NULL,3,'Voluptatibus in optio libero beatae non sequi. Ut sunt esse minima sed nulla sit. Hic delectus officia sed omnis. Voluptate doloribus non possimus fuga impedit qui.','33.80041','117.12164',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(3,'Rosenbaumborough','792','321 Reichel Walks Suite 072\nSouth Ebony, MD 58390',NULL,5,'Ut dolor eos suscipit nisi maiores facilis. Totam eos voluptates est quis voluptatem sequi. Omnis repellat laudantium id dolores vel.','-50.19615','107.282258',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(4,'Anissaview','58','47260 Torphy Mountains Suite 630\nModestafurt, UT 33157-8902',NULL,2,'Qui voluptatem molestiae dolores quia ipsum in excepturi. Aperiam et atque hic repudiandae. Qui dignissimos eum quisquam velit eum atque.','-37.215666','53.183534',9,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(5,'Daniellefurt','307','673 Miller Falls\nWelchton, TN 27551',NULL,7,'Ipsum et qui voluptatem dolores laudantium delectus. Officia ad voluptate modi. Eum quia alias non tempora culpa perspiciatis aut.','-64.854768','-25.852528',9,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(6,'Jaysonchester','21','4238 Hessel Field Suite 999\nLake Clement, WI 25362-1812',NULL,8,'Quo amet assumenda perspiciatis doloremque dicta incidunt. Quod id eius perspiciatis. Qui ex rerum velit mollitia aut aut. Quis ut magni saepe explicabo consequatur.','-3.141922','166.55376',9,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(7,'Nicolashaven','527','251 Dietrich Court\nWaelchiview, OR 88680',NULL,1,'Ut quaerat qui mollitia ut est beatae. Omnis repellat sint iste est. Laborum eum consequatur eligendi qui. Consequatur quia voluptatem totam eius molestiae eos tempore.','27.356325','-90.098052',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(8,'Nitzscheville','286','109 Gulgowski Inlet\nWest Opal, MS 22569',NULL,2,'Tempora impedit rerum iure quam. Magni quia adipisci adipisci autem suscipit.','-86.262098','77.124147',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(9,'Terryville','388','2195 DuBuque Gardens Apt. 660\nJohnsonbury, MA 69898',NULL,6,'Debitis quia consequatur perspiciatis qui qui veniam facilis. Sint quia debitis non. Occaecati et velit quisquam dolore porro quia sunt et.','-38.296709','45.379802',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(10,'Whitebury','315','9453 Brandy Parkway\nAnabelberg, NV 82493-3035',NULL,8,'Modi placeat est est nostrum. Quia enim minus vitae porro sint. Officia excepturi in minima. Debitis voluptas et nobis aperiam consequuntur similique omnis sit.','-70.903277','151.959322',9,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(11,'South Leannville','975','902 Wilkinson Locks Apt. 547\nNorth Yoshikobury, NH 63420',NULL,5,'Aspernatur aut vel aperiam eligendi ipsum voluptates sed quod. Omnis error ut unde est. Incidunt fugit hic sint quasi sunt consequuntur. Et amet ipsa at corporis aut.','-88.230231','-52.669841',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(12,'New Marisol','35','6957 Moen Valleys Apt. 243\nPort Goldaland, OH 58579',NULL,1,'Sed quia qui rerum deleniti sint quasi. Delectus quasi ut sint omnis culpa quia. Dicta ipsa odit quis assumenda qui quam.','-0.780347','115.91109',9,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(13,'Walshview','723','412 Petra Shoal\nLake Billyborough, IN 25146-5152',NULL,1,'Aut ut rerum ullam. Impedit doloremque consequatur et ut voluptatem vitae animi. Magnam blanditiis quaerat quaerat distinctio sed consequatur voluptates.','57.921289','-68.086125',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(14,'Tateland','606','212 Ritchie Plains Suite 745\nPort Raquel, AR 73859-2611',NULL,2,'Facere voluptatum et itaque culpa eligendi. Nihil consequatur debitis cum dolores quas. Neque dolores quas ducimus provident quos rerum.','-2.329483','-40.083494',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(15,'Funkshire','735','91163 Addie Avenue Apt. 841\nNienowborough, AZ 82837-5822',NULL,10,'Tempore labore vero in consectetur consectetur. Minima voluptatem blanditiis voluptatum magni natus. Voluptatum sit quo quaerat occaecati ut minima eos ipsa.','28.52036','29.439054',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(16,'South Keelyton','249','2513 Eulalia Prairie Suite 944\nNew Jarret, HI 01315-6880',NULL,7,'Doloremque quo est minima a quae voluptatem. Voluptatum dolorum hic sit dolores. Modi ut quas quia sit nostrum ab facere. Nobis autem nobis fugit beatae qui fuga voluptatibus.','-82.722421','119.928178',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(17,'East Kaileeport','517','766 Jaren Valleys Suite 056\nLonietown, MI 52755-1657',NULL,10,'Voluptatem omnis incidunt tenetur sit. Fugit omnis ad sit temporibus sit et. Reprehenderit incidunt sed minima nesciunt.','-7.949106','-8.325289',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(18,'Lake Karelleshire','793','110 Schimmel Heights\nNorth Neha, HI 40955',NULL,9,'Rerum harum consequuntur illo vitae rerum tempore. Ut libero suscipit saepe nam. Quia corrupti aut et minus eos animi nihil. Sunt magni sed voluptatem laboriosam aut amet.','77.691301','-18.842234',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(19,'Asastad','11','789 Grady Cliffs Suite 076\nWest Reedmouth, TX 72942',NULL,10,'Voluptatem temporibus ullam beatae et in neque perspiciatis. Vel eveniet aut dicta perferendis. Velit enim voluptatem voluptatem. Deserunt repudiandae quibusdam incidunt sequi in voluptatem repellat.','75.310987','146.441449',8,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL),
(20,'East Kipville','865','158 Emmy Terrace\nWest Litzy, NJ 18899',NULL,9,'Omnis illo mollitia perferendis porro fugiat. Id similique voluptatem odit voluptate inventore nemo. Sunt delectus ipsa quam saepe. Minima occaecati dolorem a maiores laborum magnam.','35.41452','148.781202',10,NULL,NULL,'publish','2023-03-23 08:49:30','2023-03-23 08:49:30',NULL);

--
-- Table structure for table `bravo_attrs`
--

CREATE TABLE `bravo_attrs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `service` varchar(50) 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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `display_type` varchar(255) DEFAULT NULL,
  `hide_in_single` tinyint(4) DEFAULT NULL,
  `hide_in_filter_search` tinyint(4) DEFAULT NULL,
  `position` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_attrs`
--

INSERT INTO `bravo_attrs` (`id`, `name`, `slug`, `service`, `create_user`, `update_user`, `created_at`, `updated_at`, `deleted_at`, `display_type`, `hide_in_single`, `hide_in_filter_search`, `position`) VALUES (1,'Travel Styles','travel-styles','tour',NULL,NULL,'2023-03-23 08:49:26','2023-03-23 08:49:26',NULL,NULL,NULL,NULL,NULL),
(2,'Facilities','facilities','tour',NULL,NULL,'2023-03-23 08:49:26','2023-03-23 08:49:26',NULL,NULL,NULL,NULL,NULL),
(3,'Space Type','space-type','space',NULL,NULL,'2023-03-23 08:49:27','2023-03-23 08:49:27',NULL,NULL,NULL,NULL,NULL),
(4,'Amenities','amenities','space',NULL,NULL,'2023-03-23 08:49:27','2023-03-23 08:49:27',NULL,NULL,NULL,NULL,NULL),
(5,'Property type','property-type','hotel',NULL,NULL,'2023-03-23 08:49:27','2023-03-23 08:49:27',NULL,NULL,NULL,NULL,NULL),
(6,'Facilities','facilities-1','hotel',NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:28',NULL,NULL,NULL,NULL,NULL),
(7,'Hotel Service','hotel-service','hotel',NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:28',NULL,NULL,NULL,NULL,NULL),
(8,'Room Amenities','room-amenities','hotel_room',NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:28',NULL,NULL,NULL,NULL,NULL),
(9,'Car Type','car-type','car',NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29',NULL,NULL,1,NULL,NULL),
(10,'Car Features','car-features','car',NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29',NULL,NULL,NULL,NULL,NULL),
(11,'Event Type','event-type','event',NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29',NULL,NULL,NULL,NULL,NULL),
(12,'Seat Type','flight-type','flight',1,NULL,'2023-03-23 08:49:30','2024-03-23 06:24:09',NULL,NULL,NULL,NULL,NULL),
(13,'Inflight Experience','inflight-experience','flight',NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL),
(14,'Boat Type','boat-type','boat',NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',NULL,NULL,1,NULL,NULL),
(15,'Amenities','amenities-1','boat',NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',NULL,NULL,NULL,NULL,NULL),
(16,'Fair Type','flight-stoppage','flight',1,1,'2024-03-22 06:10:46','2024-03-23 06:22:52',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `bravo_attrs_translations`
--

CREATE TABLE `bravo_attrs_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_id` bigint(20) DEFAULT NULL,
  `locale` varchar(10) DEFAULT NULL,
  `name` varchar(255) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bravo_attrs_translations_origin_id_locale_unique` (`origin_id`,`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_attrs_translations`
--

INSERT INTO `bravo_attrs_translations` (`id`, `origin_id`, `locale`, `name`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES (1,16,'en','Fair Type',1,1,'2024-03-22 06:10:46','2024-03-23 06:22:53'),
(2,12,'en','Seat Type',1,NULL,'2024-03-23 06:24:09','2024-03-23 06:24:09');

--
-- Table structure for table `bravo_boat_dates`
--

CREATE TABLE `bravo_boat_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `target_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `price_per_hour` decimal(12,2) DEFAULT NULL,
  `price_per_day` decimal(12,2) DEFAULT NULL,
  `number` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 0,
  `note_to_customer` text DEFAULT NULL,
  `note_to_admin` text 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_boat_dates`
--


--
-- Table structure for table `bravo_boat_term`
--

CREATE TABLE `bravo_boat_term` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_boat_term`
--

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

--
-- Table structure for table `bravo_boat_translations`
--

CREATE TABLE `bravo_boat_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_id` int(10) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `specs` text DEFAULT NULL,
  `cancel_policy` text DEFAULT NULL,
  `terms_information` text DEFAULT NULL,
  `address` varchar(255) 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,
  `include` text DEFAULT NULL,
  `exclude` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_boat_translations_locale_index` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_boat_translations`
--


--
-- Table structure for table `bravo_boats`
--

CREATE TABLE `bravo_boats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `content` text DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `map_lat` varchar(20) DEFAULT NULL,
  `map_lng` varchar(20) DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `gallery` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `number` tinyint(4) DEFAULT NULL,
  `price_per_hour` decimal(12,2) DEFAULT NULL,
  `price_per_day` decimal(12,2) DEFAULT NULL,
  `min_price` decimal(12,2) DEFAULT NULL,
  `enable_extra_price` tinyint(4) DEFAULT NULL,
  `extra_price` text DEFAULT NULL,
  `max_guest` int(11) DEFAULT NULL,
  `cabin` int(11) DEFAULT NULL,
  `length` varchar(255) DEFAULT NULL,
  `speed` varchar(255) DEFAULT NULL,
  `specs` text DEFAULT NULL,
  `cancel_policy` text DEFAULT NULL,
  `terms_information` text DEFAULT NULL,
  `review_score` decimal(2,1) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `default_state` tinyint(4) DEFAULT 1,
  `enable_service_fee` tinyint(4) DEFAULT NULL,
  `service_fee` text DEFAULT NULL,
  `min_day_before_booking` int(11) 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,
  `author_id` bigint(20) DEFAULT NULL,
  `include` text DEFAULT NULL,
  `exclude` text DEFAULT NULL,
  `start_time_booking` varchar(191) DEFAULT NULL,
  `end_time_booking` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_boats_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_boats`
--

INSERT INTO `bravo_boats` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `faqs`, `number`, `price_per_hour`, `price_per_day`, `min_price`, `enable_extra_price`, `extra_price`, `max_guest`, `cabin`, `length`, `speed`, `specs`, `cancel_policy`, `terms_information`, `review_score`, `status`, `default_state`, `enable_service_fee`, `service_fee`, `min_day_before_booking`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `author_id`, `include`, `exclude`, `start_time_booking`, `end_time_booking`) VALUES (1,'Cruising Yacht','cruising-yacht','<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>',208,206,1,'Arrondissement de Paris','21.054831','105.796077',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,100.00,500.00,100.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',5,1,'12m','26km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.5,'publish',1,NULL,NULL,NULL,1,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',1,NULL,NULL,NULL,NULL),
(2,'Summer Breeze','summer-breeze','<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>',209,206,1,'Arrondissement de Paris','21.039771','105.777203',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,150.00,500.00,150.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',7,3,'10m','31km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.3,'publish',1,NULL,NULL,NULL,1,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',1,NULL,NULL,NULL,NULL),
(3,'Blue Moon Cruising','blue-moon-cruising','<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>',209,206,3,'Arrondissement de Paris','21.031217','105.773698',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,200.00,800.00,200.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',8,5,'14m','30km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.5,'publish',1,NULL,NULL,NULL,1,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',1,NULL,NULL,NULL,NULL),
(4,'BOAT 1992 ALISON','boat-1992-alison','<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>',210,206,1,'Arrondissement de Paris','21.020161','105.789655',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,50.00,300.00,50.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',8,5,'18m','31km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.5,'publish',1,NULL,NULL,NULL,1,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',1,NULL,NULL,NULL,NULL),
(5,'Andiamo MX-3','andiamo-mx-3','<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>',211,206,5,'Arrondissement de Paris','21.014873','105.794117',12,1,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,250.00,650.00,250.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',7,3,'16m','26km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',5.0,'publish',1,NULL,NULL,NULL,1,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',1,NULL,NULL,NULL,NULL),
(6,'Blue Dream TC-20','blue-dream-tc-20','<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>',212,206,1,'Arrondissement de Paris','21.018398','105.812820',12,1,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,130.00,670.00,130.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',7,5,'16m','28km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.3,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL),
(7,'Blue Moon YC-300','blue-moon-yc-300','<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>',213,206,1,'Arrondissement de Paris','21.025769','105.829635',12,1,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,130.00,800.00,130.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',7,4,'17m','26km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',5.0,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL),
(8,'Carpe Diem LA','carpe-diem-la','<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>',214,206,1,'Arrondissement de Paris','21.017437','105.831179',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,200.00,750.00,200.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',7,5,'19m','26km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.3,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL),
(9,'Destiny 6','destiny-6','<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>',215,206,6,'Arrondissement de Paris','21.047879','105.809731',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,180.00,400.00,180.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',8,3,'13m','25km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.8,'publish',1,NULL,NULL,NULL,6,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',6,NULL,NULL,NULL,NULL),
(10,'Endless Summer W-10','endless-summer-w-10','<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>',216,206,7,'Arrondissement de Paris','21.025449','105.804412',12,1,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,230.00,650.00,230.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',12,4,'19m','25km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.8,'publish',1,NULL,NULL,NULL,6,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',6,NULL,NULL,NULL,NULL),
(11,'Freedom M2','freedom-m2','<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>',217,206,8,'Arrondissement de Paris','21.020001','105.836670',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,50.00,200.00,50.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',8,2,'11m','30km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.3,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL),
(12,'Ohana 3X','ohana-3x','<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>',218,206,3,'Arrondissement de Paris','21.051244','105.777988',12,1,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,80.00,200.00,80.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',12,2,'18m','29km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.5,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL),
(13,'My Way 100','my-way-100','<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>',219,206,1,'Arrondissement de Paris','21.053326','105.841475',12,0,'220,221,222,223,224,225','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the boat can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,150.00,300.00,150.00,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',8,5,'14m','27km/h','{\"0\":{\"title\":\"Manufacturer\",\"content\":\"Sunrise\"},\"1\":{\"title\":\"Boat skipper\",\"content\":\"Bareboat\"},\"2\":{\"title\":\"Model\",\"content\":\"Summer Breeze\"},\"3\":{\"title\":\"Year\",\"content\":\"2010\"},\"4\":{\"title\":\"Number of crew\",\"content\":\"5\"},\"5\":{\"title\":\"Engines\",\"content\":\"Diesel\"},\"6\":{\"title\":\"Fuel\",\"content\":\"Composite\"}}','Full refund up to 4 days prior.','<p>For Sanitary purposes ONLY, although there is a working toilet and shower, we\'ve deactivated the shower and the toliet is for limited use (urine only..pardon the graphic detail!). This keeps the boat clean and odor-free for all of our guests.&nbsp; Sinks can be used.</p>\r\n<p>Booking is weather pending. Because of the safety factors associated with the boat and inclement weather, If forecast shows rain, strong winds etc, the Host will communicate with Guest 24-48hrs in advance to mutually cancel/reschedule reservation. No smoking in boat cabin.</p>',4.0,'publish',1,NULL,NULL,NULL,4,NULL,NULL,'2023-03-23 08:49:31','2023-03-23 08:49:31',4,NULL,NULL,NULL,NULL);

--
-- Table structure for table `bravo_booking_coupons`
--

CREATE TABLE `bravo_booking_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` bigint(20) DEFAULT NULL,
  `booking_status` varchar(30) DEFAULT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_model` varchar(191) DEFAULT NULL,
  `coupon_code` varchar(191) DEFAULT NULL,
  `coupon_amount` decimal(10,2) DEFAULT 0.00,
  `coupon_data` text 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_coupons`
--

INSERT INTO `bravo_booking_coupons` (`id`, `booking_id`, `booking_status`, `object_id`, `object_model`, `coupon_code`, `coupon_amount`, `coupon_data`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES (1,8,'draft',6,'hotel','Asad',10.00,'{\"id\":1,\"code\":\"Asad\",\"name\":\"asad\",\"amount\":10,\"discount_type\":\"fixed\",\"end_date\":null,\"min_total\":100,\"max_total\":10000,\"services\":null,\"only_for_user\":null,\"status\":\"publish\",\"quantity_limit\":1,\"limit_per_user\":1,\"image_id\":227,\"create_user\":1,\"update_user\":null,\"deleted_at\":null,\"created_at\":\"2023-09-19T06:29:41.000000Z\",\"updated_at\":\"2023-09-19T06:29:41.000000Z\"}',11,NULL,'2023-09-19 06:30:18','2023-09-19 06:30:18');

--
-- Table structure for table `bravo_booking_meta`
--

CREATE TABLE `bravo_booking_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `val` text DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_meta`
--

INSERT INTO `bravo_booking_meta` (`id`, `booking_id`, `name`, `val`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES (1,1,'duration',NULL,NULL,NULL,NULL,NULL),
(2,1,'base_price','300.00',NULL,NULL,NULL,NULL),
(3,1,'sale_price',NULL,NULL,NULL,NULL,NULL),
(4,1,'guests','1',NULL,NULL,NULL,NULL),
(5,1,'adults','1',NULL,NULL,NULL,NULL),
(6,1,'children','0',NULL,NULL,NULL,NULL),
(7,1,'extra_price','[]',NULL,NULL,NULL,NULL),
(8,1,'locale','en',NULL,NULL,NULL,NULL),
(9,1,'how_to_pay','',NULL,NULL,NULL,NULL),
(10,1,'razorpay_order_id','order_LUwrMwecd0XwMu',NULL,NULL,NULL,NULL),
(11,1,'razorpay_order_log','{\"id\":\"order_LUwrMwecd0XwMu\",\"entity\":\"order\",\"amount\":150000,\"amount_paid\":0,\"amount_due\":150000,\"currency\":\"INR\",\"receipt\":\"2\",\"offer_id\":null,\"status\":\"created\",\"attempts\":0,\"notes\":[],\"created_at\":1679570705}',NULL,NULL,NULL,NULL),
(12,2,'duration',NULL,NULL,NULL,NULL,NULL),
(13,2,'base_price','199',NULL,NULL,NULL,NULL),
(14,2,'sale_price','0',NULL,NULL,NULL,NULL),
(15,2,'extra_price','[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\",\"total\":100},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\",\"total\":200}]',NULL,NULL,NULL,NULL),
(16,2,'tmp_dates','{\"2023-05-18\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-19\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-20\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-21\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-22\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-23\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-24\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-25\":{\"number\":3,\"price\":199,\"status\":1},\"2023-05-26\":{\"number\":3,\"price\":199,\"status\":1}}',NULL,NULL,NULL,NULL),
(17,3,'duration',NULL,NULL,NULL,NULL,NULL),
(18,3,'base_price','400',NULL,NULL,NULL,NULL),
(19,3,'sale_price','0',NULL,NULL,NULL,NULL),
(20,3,'extra_price','[]',NULL,NULL,NULL,NULL),
(21,3,'tmp_dates','{\"2023-05-27\":{\"number\":4,\"price\":400,\"status\":1},\"2023-05-28\":{\"number\":4,\"price\":400,\"status\":1},\"2023-05-29\":{\"number\":4,\"price\":400,\"status\":1},\"2023-05-30\":{\"number\":4,\"price\":400,\"status\":1},\"2023-05-31\":{\"number\":4,\"price\":400,\"status\":1},\"2023-06-01\":{\"number\":4,\"price\":400,\"status\":1},\"2023-06-02\":{\"number\":4,\"price\":400,\"status\":1},\"2023-06-03\":{\"number\":4,\"price\":400,\"status\":1},\"2023-06-04\":{\"number\":4,\"price\":400,\"status\":1}}',NULL,NULL,NULL,NULL),
(22,3,'locale','en',NULL,NULL,NULL,NULL),
(23,3,'how_to_pay','',NULL,NULL,NULL,NULL),
(24,4,'duration',NULL,NULL,NULL,NULL,NULL),
(25,4,'base_price','200',NULL,NULL,NULL,NULL),
(26,4,'sale_price','0',NULL,NULL,NULL,NULL),
(27,4,'extra_price','[]',NULL,NULL,NULL,NULL),
(28,4,'tmp_dates','{\"2023-05-28\":{\"number\":4,\"price\":200,\"status\":1},\"2023-05-29\":{\"number\":4,\"price\":200,\"status\":1},\"2023-05-30\":{\"number\":4,\"price\":200,\"status\":1},\"2023-05-31\":{\"number\":4,\"price\":200,\"status\":1},\"2023-06-01\":{\"number\":4,\"price\":200,\"status\":1},\"2023-06-02\":{\"number\":4,\"price\":200,\"status\":1},\"2023-06-03\":{\"number\":4,\"price\":200,\"status\":1}}',NULL,NULL,NULL,NULL),
(29,5,'duration',NULL,NULL,NULL,NULL,NULL),
(30,5,'base_price','350.00',NULL,NULL,NULL,NULL),
(31,5,'sale_price',NULL,NULL,NULL,NULL,NULL),
(32,5,'guests','1',NULL,NULL,NULL,NULL),
(33,5,'adults','1',NULL,NULL,NULL,NULL),
(34,5,'children','0',NULL,NULL,NULL,NULL),
(35,5,'extra_price','[]',NULL,NULL,NULL,NULL),
(36,5,'locale','en',NULL,NULL,NULL,NULL),
(37,5,'how_to_pay','',NULL,NULL,NULL,NULL),
(38,6,'duration',NULL,NULL,NULL,NULL,NULL),
(39,6,'base_price','700.00',NULL,NULL,NULL,NULL),
(40,6,'sale_price',NULL,NULL,NULL,NULL,NULL),
(41,6,'guests','1',NULL,NULL,NULL,NULL),
(42,6,'adults','1',NULL,NULL,NULL,NULL),
(43,6,'children','0',NULL,NULL,NULL,NULL),
(44,6,'extra_price','[]',NULL,NULL,NULL,NULL),
(45,6,'locale','en',NULL,NULL,NULL,NULL),
(46,6,'how_to_pay','',NULL,NULL,NULL,NULL),
(47,7,'duration',NULL,NULL,NULL,NULL,NULL),
(48,7,'base_price','550.00',NULL,NULL,NULL,NULL),
(49,7,'sale_price',NULL,NULL,NULL,NULL,NULL),
(50,7,'guests','1',NULL,NULL,NULL,NULL),
(51,7,'adults','1',NULL,NULL,NULL,NULL),
(52,7,'children','0',NULL,NULL,NULL,NULL),
(53,7,'extra_price','[]',NULL,NULL,NULL,NULL),
(54,8,'duration',NULL,NULL,NULL,NULL,NULL),
(55,8,'base_price','700.00',NULL,NULL,NULL,NULL),
(56,8,'sale_price',NULL,NULL,NULL,NULL,NULL),
(57,8,'guests','1',NULL,NULL,NULL,NULL),
(58,8,'adults','1',NULL,NULL,NULL,NULL),
(59,8,'children','0',NULL,NULL,NULL,NULL),
(60,8,'extra_price','[]',NULL,NULL,NULL,NULL),
(61,9,'duration','7',NULL,NULL,NULL,NULL),
(62,9,'start_time','17:00',NULL,NULL,NULL,NULL),
(63,9,'total_tickets','1',NULL,NULL,NULL,NULL),
(64,9,'extra_price','[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\",\"total\":\"100\"}]',NULL,NULL,NULL,NULL),
(65,9,'base_price','1181',NULL,NULL,NULL,NULL),
(66,9,'booking_type','ticket',NULL,NULL,NULL,NULL),
(67,9,'ticket_types','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"1\"}]',NULL,NULL,NULL,NULL),
(68,9,'locale','en',NULL,NULL,NULL,NULL),
(69,9,'how_to_pay','',NULL,NULL,NULL,NULL),
(70,10,'duration',NULL,NULL,NULL,NULL,NULL),
(71,10,'base_price','700.00',NULL,NULL,NULL,NULL),
(72,10,'sale_price',NULL,NULL,NULL,NULL,NULL),
(73,10,'guests','3',NULL,NULL,NULL,NULL),
(74,10,'adults','2',NULL,NULL,NULL,NULL),
(75,10,'children','1',NULL,NULL,NULL,NULL),
(76,10,'extra_price','[]',NULL,NULL,NULL,NULL),
(77,10,'locale','en',NULL,NULL,NULL,NULL),
(78,10,'how_to_pay','',NULL,NULL,NULL,NULL),
(79,11,'duration','5',NULL,NULL,NULL,NULL),
(80,11,'base_price','722.00',NULL,NULL,NULL,NULL),
(81,11,'guests','1',NULL,NULL,NULL,NULL),
(82,11,'extra_price','[{\"name\":\"Clean\",\"price\":\"100\",\"type\":\"one_time\",\"total\":\"100\"}]',NULL,NULL,NULL,NULL),
(83,11,'person_types','[{\"name\":\"Adult\",\"desc\":\"Age 18+\",\"min\":\"1\",\"max\":\"10\",\"price\":\"1000\",\"number\":\"1\"}]',NULL,NULL,NULL,NULL),
(84,11,'discount_by_people','[]',NULL,NULL,NULL,NULL),
(85,11,'locale','en',NULL,NULL,NULL,NULL),
(86,11,'how_to_pay','',NULL,NULL,NULL,NULL),
(87,12,'duration',NULL,NULL,NULL,NULL,NULL),
(88,12,'base_price','400.00',NULL,NULL,NULL,NULL),
(89,12,'sale_price','350.00',NULL,NULL,NULL,NULL),
(90,12,'guests','6',NULL,NULL,NULL,NULL),
(91,12,'adults','6',NULL,NULL,NULL,NULL),
(92,12,'children','0',NULL,NULL,NULL,NULL),
(93,12,'extra_price','[]',NULL,NULL,NULL,NULL),
(94,12,'tmp_dates','[]',NULL,NULL,NULL,NULL),
(95,12,'booking_type','by_day',NULL,NULL,NULL,NULL),
(96,13,'duration',NULL,NULL,NULL,NULL,NULL),
(97,13,'base_price','400.00',NULL,NULL,NULL,NULL),
(98,13,'sale_price','350.00',NULL,NULL,NULL,NULL),
(99,13,'guests','2',NULL,NULL,NULL,NULL),
(100,13,'adults','2',NULL,NULL,NULL,NULL),
(101,13,'children','0',NULL,NULL,NULL,NULL),
(102,13,'extra_price','[{\"name\":\"Lawn garden\",\"price\":\"100\",\"type\":\"one_time\",\"total\":\"100\"}]',NULL,NULL,NULL,NULL),
(103,13,'tmp_dates','[]',NULL,NULL,NULL,NULL),
(104,13,'booking_type','by_day',NULL,NULL,NULL,NULL),
(105,13,'locale','en',NULL,NULL,NULL,NULL),
(106,13,'how_to_pay','',NULL,NULL,NULL,NULL);

--
-- Table structure for table `bravo_booking_passengers`
--

CREATE TABLE `bravo_booking_passengers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `flight_id` int(11) DEFAULT NULL,
  `flight_seat_id` int(11) DEFAULT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `seat_type` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `first_name` varchar(191) DEFAULT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `dob` datetime DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `id_card` varchar(191) DEFAULT NULL,
  `object_model` varchar(30) NOT NULL,
  `object_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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_booking_passengers_booking_id_index` (`booking_id`),
  KEY `bravo_booking_passengers_object_model_object_id_index` (`object_model`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_passengers`
--


--
-- Table structure for table `bravo_booking_payment_meta`
--

CREATE TABLE `bravo_booking_payment_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `val` text DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_booking_payment_meta_payment_id_name_index` (`payment_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_payment_meta`
--


--
-- Table structure for table `bravo_booking_payments`
--

CREATE TABLE `bravo_booking_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(64) DEFAULT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_model` varchar(40) DEFAULT NULL,
  `meta` text DEFAULT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `payment_gateway` varchar(50) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `converted_amount` decimal(10,2) DEFAULT NULL,
  `converted_currency` varchar(10) DEFAULT NULL,
  `exchange_rate` decimal(10,2) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `logs` text DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `wallet_transaction_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_payments`
--

INSERT INTO `bravo_booking_payments` (`id`, `code`, `object_id`, `object_model`, `meta`, `booking_id`, `payment_gateway`, `amount`, `currency`, `converted_amount`, `converted_currency`, `exchange_rate`, `status`, `logs`, `create_user`, `update_user`, `deleted_at`, `wallet_transaction_id`, `created_at`, `updated_at`, `user_id`) VALUES (1,'cdb529145ee9e528db16fd381868a148',NULL,NULL,NULL,1,'razorpay_gateway',1500.00,'inr',NULL,NULL,NULL,'draft',NULL,7,NULL,NULL,NULL,'2023-03-23 15:53:35','2023-03-23 15:53:35',NULL),
(2,'ca63b55c840db76afd2f60dc3d3c4c29',NULL,NULL,NULL,1,'razorpay_gateway',1500.00,'inr',NULL,NULL,NULL,'draft',NULL,7,NULL,NULL,NULL,'2023-03-23 15:55:05','2023-03-23 15:55:05',NULL);

--
-- Table structure for table `bravo_booking_time_slots`
--

CREATE TABLE `bravo_booking_time_slots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) DEFAULT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_model` varchar(40) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `duration` double(255,2) DEFAULT NULL,
  `duration_unit` varchar(255) DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_booking_time_slots`
--


--
-- Table structure for table `bravo_bookings`
--

CREATE TABLE `bravo_bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(64) DEFAULT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `gateway` varchar(50) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `object_model` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `total_guests` int(11) DEFAULT NULL,
  `currency` varchar(5) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `deposit` decimal(10,2) DEFAULT NULL,
  `deposit_type` varchar(30) DEFAULT NULL,
  `commission` decimal(10,2) DEFAULT NULL,
  `commission_type` varchar(150) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `customer_notes` text DEFAULT NULL,
  `vendor_service_fee_amount` decimal(8,2) DEFAULT NULL,
  `vendor_service_fee` text 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,
  `buyer_fees` text DEFAULT NULL,
  `total_before_fees` decimal(10,2) DEFAULT NULL,
  `paid_vendor` tinyint(4) DEFAULT NULL,
  `object_child_id` bigint(20) DEFAULT NULL,
  `number` smallint(6) DEFAULT NULL,
  `paid` decimal(10,2) DEFAULT NULL,
  `pay_now` decimal(10,2) DEFAULT NULL,
  `wallet_credit_used` double DEFAULT NULL,
  `wallet_total_used` double DEFAULT NULL,
  `wallet_transaction_id` bigint(20) DEFAULT NULL,
  `is_refund_wallet` tinyint(4) DEFAULT NULL,
  `is_paid` tinyint(4) DEFAULT NULL,
  `total_before_discount` decimal(10,2) DEFAULT 0.00,
  `coupon_amount` decimal(10,2) DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_bookings`
--

INSERT INTO `bravo_bookings` (`id`, `code`, `vendor_id`, `customer_id`, `payment_id`, `gateway`, `object_id`, `object_model`, `start_date`, `end_date`, `total`, `total_guests`, `currency`, `status`, `deposit`, `deposit_type`, `commission`, `commission_type`, `email`, `first_name`, `last_name`, `phone`, `address`, `address2`, `city`, `state`, `zip_code`, `country`, `customer_notes`, `vendor_service_fee_amount`, `vendor_service_fee`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `buyer_fees`, `total_before_fees`, `paid_vendor`, `object_child_id`, `number`, `paid`, `pay_now`, `wallet_credit_used`, `wallet_total_used`, `wallet_transaction_id`, `is_refund_wallet`, `is_paid`, `total_before_discount`, `coupon_amount`) VALUES (1,'072447e9f19bd4da29e51fb08b4e760c',1,7,2,'razorpay_gateway',1,'hotel','2023-03-24 00:00:00','2023-03-26 00:00:00',1500.00,1,NULL,'unpaid',NULL,NULL,140.00,'{\"amount\":\"10\",\"type\":\"percent\"}','gyanuk67@gmail.com','Gyanendu','Jigyasa','9106014883','Test Address','AFDSFDSGFDS','Test City',NULL,'123456','IN',NULL,0.00,'\"\"',7,7,NULL,'2023-03-23 15:53:03','2023-03-23 15:55:05','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',1400.00,NULL,NULL,NULL,NULL,1500.00,0,0,NULL,NULL,NULL,1400.00,0.00),
(2,'59a24d78b033c5fb0a4471270f561448',5,10,NULL,NULL,10,'car','2023-05-18 00:00:00','2023-05-26 00:00:00',2391.00,1,NULL,'draft',NULL,NULL,209.10,'{\"amount\":\"10\",\"type\":\"percent\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'\"\"',10,NULL,NULL,'2023-05-17 11:51:06','2023-05-17 11:51:06','[{\"name\":\"Equipment fee\",\"desc\":\"One-time fee charged by host to cover the cost of cleaning their space.\",\"name_ja\":\"\\u30af\\u30ea\\u30fc\\u30cb\\u30f3\\u30b0\\u4ee3\",\"desc_ja\":\"\\u30b9\\u30da\\u30fc\\u30b9\\u3092\\u6383\\u9664\\u3059\\u308b\\u8cbb\\u7528\\u3092\\u30db\\u30b9\\u30c8\\u304c\\u8acb\\u6c42\\u3059\\u308b1\\u56de\\u9650\\u308a\\u306e\\u6599\\u91d1\\u3002\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Facility fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"200\",\"type\":\"one_time\"}]',2091.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2091.00,0.00),
(3,'4448609d85f64b4869922a12bfc72c1f',4,1,NULL,'offline_payment',13,'car','2023-05-27 00:00:00','2023-06-04 00:00:00',3900.00,1,NULL,'processing',NULL,NULL,360.00,'{\"amount\":\"10\",\"type\":\"percent\"}','info@testsoftware.online','Test','Software','1234567890',NULL,NULL,'New York',NULL,NULL,'US',NULL,0.00,'\"\"',1,1,NULL,'2023-05-25 18:53:42','2023-05-25 18:54:47','[{\"name\":\"Equipment fee\",\"desc\":\"One-time fee charged by host to cover the cost of cleaning their space.\",\"name_ja\":\"\\u30af\\u30ea\\u30fc\\u30cb\\u30f3\\u30b0\\u4ee3\",\"desc_ja\":\"\\u30b9\\u30da\\u30fc\\u30b9\\u3092\\u6383\\u9664\\u3059\\u308b\\u8cbb\\u7528\\u3092\\u30db\\u30b9\\u30c8\\u304c\\u8acb\\u6c42\\u3059\\u308b1\\u56de\\u9650\\u308a\\u306e\\u6599\\u91d1\\u3002\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Facility fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"200\",\"type\":\"one_time\"}]',3600.00,NULL,NULL,1,NULL,3900.00,0,0,NULL,NULL,NULL,3600.00,0.00),
(4,'1626a0413db40f5587c31b1678ab2a3a',5,1,NULL,NULL,7,'car','2023-05-28 00:00:00','2023-06-03 00:00:00',1700.00,1,NULL,'draft',NULL,NULL,140.00,'{\"amount\":\"10\",\"type\":\"percent\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'\"\"',1,NULL,NULL,'2023-05-25 19:00:30','2023-05-25 19:00:30','[{\"name\":\"Equipment fee\",\"desc\":\"One-time fee charged by host to cover the cost of cleaning their space.\",\"name_ja\":\"\\u30af\\u30ea\\u30fc\\u30cb\\u30f3\\u30b0\\u4ee3\",\"desc_ja\":\"\\u30b9\\u30da\\u30fc\\u30b9\\u3092\\u6383\\u9664\\u3059\\u308b\\u8cbb\\u7528\\u3092\\u30db\\u30b9\\u30c8\\u304c\\u8acb\\u6c42\\u3059\\u308b1\\u56de\\u9650\\u308a\\u306e\\u6599\\u91d1\\u3002\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Facility fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"200\",\"type\":\"one_time\"}]',1400.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1400.00,0.00),
(5,'63aea8b536693610e5285885880d2ceb',1,11,NULL,'offline_payment',2,'hotel','2023-09-19 00:00:00','2023-09-20 00:00:00',450.00,1,NULL,'processing',NULL,NULL,35.00,'{\"amount\":\"10\",\"type\":\"percent\"}','abhishek@peytonsoft.com','Kumar','Abhi','9667732250','sdddddd','ssssssss','ssss','ssssssss','123332','IN','ddddddddddddd',0.00,'\"\"',11,11,NULL,'2023-09-18 05:33:36','2023-09-18 05:33:57','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',350.00,NULL,NULL,NULL,NULL,450.00,0,0,NULL,NULL,NULL,350.00,0.00),
(6,'9ec4fff71263d66656d961790080a3e9',6,11,NULL,'offline_payment',6,'hotel','2023-09-20 00:00:00','2023-09-21 00:00:00',450.00,1,NULL,'processing',NULL,NULL,35.00,'{\"amount\":\"10\",\"type\":\"percent\"}','abhishek@peytonsoft.com','Kumar','Abhi','9667732250','sdddddd','ssssssss','ssss','ssssssss','123332','IN','fffffffffffff',0.00,'\"\"',11,11,NULL,'2023-09-19 06:17:28','2023-09-19 06:18:06','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',350.00,NULL,NULL,NULL,NULL,450.00,0,0,NULL,NULL,NULL,350.00,0.00),
(7,'94f64989eb701a3cd1dbd601d7f1f213',5,1,NULL,NULL,11,'hotel','2023-09-29 00:00:00','2023-09-30 00:00:00',200.00,1,NULL,'draft',NULL,NULL,10.00,'{\"amount\":\"10\",\"type\":\"percent\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'\"\"',1,NULL,NULL,'2023-09-19 06:26:01','2023-09-19 06:26:01','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',100.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.00,0.00),
(8,'e1f769be16ebec1404aa9fda3146e01e',6,11,NULL,NULL,6,'hotel','2023-09-19 00:00:00','2023-09-20 00:00:00',440.00,1,NULL,'draft',NULL,NULL,34.00,'{\"amount\":\"10\",\"type\":\"percent\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'\"\"',11,11,NULL,'2023-09-19 06:29:59','2023-09-19 06:30:18','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',340.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,350.00,10.00),
(9,'ea014412a7d3a59d60851288115581e1',1,11,NULL,'offline_payment',12,'event','2023-09-19 00:00:00','2023-09-19 00:00:00',1200.00,1,NULL,'completed',NULL,NULL,110.00,'{\"amount\":\"10\",\"type\":\"percent\"}','abhishek@peytonsoft.com','Kumar','Abhi','9667732250','sdddddd','ssssssss','ssss','ssssssss','123332','IN',NULL,0.00,'\"\"',11,1,NULL,'2023-09-19 06:51:49','2023-09-19 07:41:54','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',1100.00,NULL,NULL,NULL,0.00,1200.00,0,0,NULL,NULL,NULL,1100.00,0.00),
(10,'819dd244715c1fac9a9e003c33c2871f',6,13,NULL,'offline_payment',6,'hotel','2023-10-01 00:00:00','2023-10-08 00:00:00',2550.00,3,NULL,'processing',NULL,NULL,245.00,'{\"amount\":\"10\",\"type\":\"percent\"}','nmalviya575@gmail.com','Nitesh','Malviya','+918871887109','Mansarover Complex, FF-8, Block A, 2nd Floor','Habibganj Rd, Near Railway Station','Bhopal','Madhya Pradesh','462016','IN',NULL,0.00,'\"\"',13,13,NULL,'2023-09-30 09:46:33','2023-09-30 09:46:52','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',2450.00,NULL,NULL,NULL,NULL,2550.00,0,0,NULL,NULL,NULL,2450.00,0.00),
(11,'5e5e4e420ddd126023d0af4231d7fa21',4,11,NULL,'offline_payment',3,'tour','2024-07-28 00:00:00','2024-07-28 05:00:00',1200.00,1,NULL,'confirmed',NULL,NULL,110.00,'{\"amount\":\"10\",\"type\":\"percent\"}','abhishek@peytonsoft.com','Kumar','Abhi','9667732250','sdddddd','ssssssss','ssss','ssssssss','123332','IN',NULL,0.00,'\"\"',11,1,NULL,'2024-07-26 20:54:08','2024-07-26 20:58:40','[{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"100\",\"type\":\"one_time\"}]',1100.00,NULL,NULL,NULL,0.00,1200.00,0,0,NULL,NULL,NULL,1100.00,0.00),
(12,'fa1e066773833f8044fd920416a07774',6,11,NULL,NULL,9,'space','2024-07-27 00:00:00','2024-07-28 00:00:00',1000.00,6,NULL,'draft',NULL,NULL,70.00,'{\"amount\":\"10\",\"type\":\"percent\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'\"\"',11,NULL,NULL,'2024-07-26 21:00:37','2024-07-26 21:00:37','[{\"name\":\"Cleaning fee\",\"desc\":\"One-time fee charged by host to cover the cost of cleaning their space.\",\"name_ja\":\"\\u30af\\u30ea\\u30fc\\u30cb\\u30f3\\u30b0\\u4ee3\",\"desc_ja\":\"\\u30b9\\u30da\\u30fc\\u30b9\\u3092\\u6383\\u9664\\u3059\\u308b\\u8cbb\\u7528\\u3092\\u30db\\u30b9\\u30c8\\u304c\\u8acb\\u6c42\\u3059\\u308b1\\u56de\\u9650\\u308a\\u306e\\u6599\\u91d1\\u3002\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"200\",\"type\":\"one_time\"}]',700.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,700.00,0.00),
(13,'da09b77a76c9c0220e573651e2aacf4d',6,1,NULL,'offline_payment',9,'space','2025-01-04 00:00:00','2025-01-04 00:00:00',750.00,2,NULL,'processing',NULL,NULL,45.00,'{\"amount\":\"10\",\"type\":\"percent\"}','info@testsoftware.online','Test','Software','1234567890',NULL,NULL,'Noida','Up','201301','IN',NULL,0.00,'\"\"',1,1,NULL,'2024-12-31 19:13:47','2024-12-31 19:14:18','[{\"name\":\"Cleaning fee\",\"desc\":\"One-time fee charged by host to cover the cost of cleaning their space.\",\"name_ja\":\"\\u30af\\u30ea\\u30fc\\u30cb\\u30f3\\u30b0\\u4ee3\",\"desc_ja\":\"\\u30b9\\u30da\\u30fc\\u30b9\\u3092\\u6383\\u9664\\u3059\\u308b\\u8cbb\\u7528\\u3092\\u30db\\u30b9\\u30c8\\u304c\\u8acb\\u6c42\\u3059\\u308b1\\u56de\\u9650\\u308a\\u306e\\u6599\\u91d1\\u3002\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Service fee\",\"desc\":\"This helps us run our platform and offer services like 24\\/7 support on your trip.\",\"name_ja\":\"\\u30b5\\u30fc\\u30d3\\u30b9\\u6599\",\"desc_ja\":\"\\u3053\\u308c\\u306b\\u3088\\u308a\\u3001\\u5f53\\u793e\\u306e\\u30d7\\u30e9\\u30c3\\u30c8\\u30d5\\u30a9\\u30fc\\u30e0\\u3092\\u5b9f\\u884c\\u3057\\u3001\\u65c5\\u884c\\u4e2d\\u306b\",\"price\":\"200\",\"type\":\"one_time\"}]',450.00,NULL,NULL,NULL,NULL,750.00,0,0,NULL,NULL,NULL,450.00,0.00);

--
-- Table structure for table `bravo_car_dates`
--

CREATE TABLE `bravo_car_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `target_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `number` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 0,
  `note_to_customer` text DEFAULT NULL,
  `note_to_admin` text DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_car_dates`
--


--
-- Table structure for table `bravo_car_term`
--

CREATE TABLE `bravo_car_term` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_car_term`
--

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

--
-- Table structure for table `bravo_car_translations`
--

CREATE TABLE `bravo_car_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_id` int(10) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `address` varchar(255) 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,
  PRIMARY KEY (`id`),
  KEY `bravo_car_translations_locale_index` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_car_translations`
--


--
-- Table structure for table `bravo_cars`
--

CREATE TABLE `bravo_cars` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `content` text DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `map_lat` varchar(20) DEFAULT NULL,
  `map_lng` varchar(20) DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `gallery` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `number` tinyint(4) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `is_instant` tinyint(4) DEFAULT 0,
  `enable_extra_price` tinyint(4) DEFAULT NULL,
  `extra_price` text DEFAULT NULL,
  `discount_by_days` text DEFAULT NULL,
  `passenger` tinyint(4) DEFAULT 0,
  `gear` varchar(191) DEFAULT '0',
  `baggage` tinyint(4) DEFAULT 0,
  `door` tinyint(4) DEFAULT 0,
  `status` varchar(50) 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,
  `enable_service_fee` tinyint(4) DEFAULT NULL,
  `service_fee` text DEFAULT NULL,
  `author_id` bigint(20) DEFAULT NULL,
  `ical_import_url` varchar(191) DEFAULT NULL,
  `min_day_before_booking` int(11) DEFAULT NULL,
  `min_day_stays` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_cars_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_cars`
--

INSERT INTO `bravo_cars` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `faqs`, `number`, `price`, `sale_price`, `is_instant`, `enable_extra_price`, `extra_price`, `discount_by_days`, `passenger`, `gear`, `baggage`, `door`, `status`, `default_state`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `review_score`, `enable_service_fee`, `service_fee`, `author_id`, `ical_import_url`, `min_day_before_booking`, `min_day_stays`) VALUES (1,'BMW-X6-facelift','bmw-x6-facelift','<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>',143,136,1,'Arrondissement de Paris','21.054831','105.796077',12,0,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',2,500.00,276.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,3,'Auto',3,4,'publish',1,1,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.5,NULL,NULL,1,NULL,NULL,NULL),
(2,'2019 Honda Clarity','2019-honda-clarityt-1','<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>',144,136,1,'Arrondissement de Paris','21.039771','105.777203',12,0,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',4,300.00,0.00,1,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,9,'Auto',5,4,'publish',1,1,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',5.0,NULL,NULL,1,NULL,NULL,NULL),
(3,'2019 Honda Clarity','2019-honda-clarityt','<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>',144,136,3,'Arrondissement de Paris','21.031217','105.773698',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',3,300.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,10,'Auto',5,4,'publish',1,1,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',5.0,NULL,NULL,1,NULL,NULL,NULL),
(4,'2019 BMW M6 Gran Coupe','2019-bmw-m6-gran-coupe','<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>',145,136,1,'Arrondissement de Paris','21.020161','105.789655',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',4,300.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,5,'Auto',10,4,'publish',1,1,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.3,NULL,NULL,1,NULL,NULL,NULL),
(5,'2019 Audi S3','2019-audi-s3','<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>',146,136,5,'Arrondissement de Paris','21.014873','105.794117',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,300.00,0.00,1,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,4,'Auto',7,4,'publish',1,1,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.2,NULL,NULL,1,NULL,NULL,NULL),
(6,'Vinfast Fadil Plus','vinfast-fadil-plus','<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>',147,136,1,'Arrondissement de Paris','21.018398','105.812820',12,0,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',5,400.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,3,'Auto',5,4,'publish',1,6,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.0,NULL,NULL,6,NULL,NULL,NULL),
(7,'Mercedes Benz','mercedes-benz','<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>',148,136,1,'Arrondissement de Paris','21.025769','105.829635',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',4,200.00,0.00,1,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,10,'Auto',7,4,'publish',1,5,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.7,NULL,NULL,5,NULL,NULL,NULL),
(8,'Vinfast Lux SA2.0 Plus','vinfast-lux-sa20-plus','<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>',149,136,1,'Arrondissement de Paris','21.017437','105.831179',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',1,600.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,4,'Auto',5,4,'publish',1,6,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.3,NULL,NULL,6,NULL,NULL,NULL),
(9,'Honda Civic','honda-civic','<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>',150,136,6,'Arrondissement de Paris','21.047879','105.809731',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',2,450.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,10,'Auto',4,4,'publish',1,6,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.7,NULL,NULL,6,NULL,NULL,NULL),
(10,'Toyota Prius Plus','toyota-prius-plus','<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>',151,136,7,'Arrondissement de Paris','21.025449','105.804412',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',3,199.00,0.00,1,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,4,'Auto',9,4,'publish',1,5,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.4,NULL,NULL,5,NULL,NULL,NULL),
(11,'Vinfast Lux V8 (SUV)','vinfast-lux-v8-suv','<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>',152,136,8,'Arrondissement de Paris','21.020001','105.836670',12,0,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',5,250.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,6,'Auto',9,4,'publish',1,5,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.0,NULL,NULL,5,NULL,NULL,NULL),
(12,'Vinfast Lux A2.0 Plus','vinfast-lux-a20-plus','<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>',153,136,3,'Arrondissement de Paris','21.051244','105.777988',12,0,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',3,350.00,0.00,1,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,9,'Auto',8,4,'publish',1,5,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.3,NULL,NULL,5,NULL,NULL,NULL),
(13,'Vinfast Fadil Standard','vinfast-fadil-standard','<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>',154,136,1,'Arrondissement de Paris','21.053326','105.841475',12,1,'155,156,157,158,159,160,161','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"When should I check the transmission fluid?\",\"content\":\"You should check the transmission fluid regularly. Try to check it at least once a month or at the sign of any trouble, for instance if there is any hesitation when you shift gears in an automatic.\"},{\"title\":\"How do I check the transmission fluid?\",\"content\":\"It\\u2019s not hard to check your transmission fluid if the vehicle is an automatic. This link to the Dummies guide to checking your transmission fluid has step-by-step instructions and illustrations that show you where to locate the dipstick. What you want is clear, pink transmission fluid. If it is low, top it up. If it is dark, smells burnt or has bits in it then you need to get it changed by at a reliable auto repair shop.\"},{\"title\":\"Is it really that important to check the transmission fluid?\",\"content\":\"Yes, it can be. Often times the symptoms you\\u2019ll experience from low or dirty transmission fluid will be the same as transmission problems. If you check the fluid levels regularly and refill as necessary then you\\u2019ll know if there are any symptoms of trouble that it\\u2019s not because the fluid levels are low and you need to see a mechanic.\"},{\"title\":\"Are there different types of transmission fluid?\",\"content\":\"How do I know what to buy? Yes, there are many different types of transmission fluid, each designed for a certain transmission. Different vehicles require different transmission fluids and the age of the car can also be a factor because newer transmissions take different types of transmission fluids than older vehicles. Don\\u2019t guess! Find out which type of transmission fluid is required for your vehicle by checking your owner\\u2019s manual.\"},{\"title\":\"What is a transmission flush and should I get one?\",\"content\":\"A transmission flush is used by some auto repair shops with the goal of flushing out debris.  Auto Tech does not do any sort of transmission flush.  Flushing an older transmission can cause harmful sediment to get stuck in the solenoids of the transmission. We heavily favor regular maintenance to lengthen the life of your transmission.  We service the transmission by changing fluid and the filter and do not recommend having your transmission flushed.\"},{\"title\":\"How do I know I have a fluid leak from the transmission?\",\"content\":\"Transmission fluid is slightly pink in color \\u2013 it will appear pink or red, or possibly more brownish if the transmission fluid is dirty and needs to be replaced. When you feel transmission fluid it will be slick and oily on your fingers. It smells much like oil unless it is dirty, in which case it will smell burnt. Usually transmission fluid leaks around the front or middle of your vehicle, so if you find puddles of reddish liquid there it is probably transmission fluid. Another clue is if in addition to the leak your transmission is not working well and you notice changes in the way it sounds when you shift gears, or if shifting gears is not working as well. In this case you likely have a leak of transmission fluid that is impacting how your transmission operates.\"}]',4,400.00,0.00,0,1,'[{\"name\":\"Child Toddler Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"Infant Child Seat\",\"price\":\"100\",\"type\":\"one_time\"},{\"name\":\"GPS Satellite\",\"price\":\"200\",\"type\":\"one_time\"}]',NULL,4,'Auto',4,4,'publish',1,4,NULL,NULL,'2023-03-23 08:49:28','2023-03-23 08:49:29',4.7,NULL,NULL,4,NULL,NULL,NULL);

--
-- Table structure for table `bravo_contact`
--

CREATE TABLE `bravo_contact` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` varchar(50) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_contact`
--


--
-- Table structure for table `bravo_coupon_services`
--

CREATE TABLE `bravo_coupon_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` bigint(20) DEFAULT NULL,
  `object_id` bigint(20) DEFAULT NULL,
  `object_model` varchar(191) DEFAULT NULL,
  `service_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_coupon_services`
--


--
-- Table structure for table `bravo_coupons`
--

CREATE TABLE `bravo_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `amount` double(8,2) DEFAULT NULL,
  `discount_type` varchar(50) DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `min_total` double(8,2) DEFAULT NULL,
  `max_total` double(8,2) DEFAULT NULL,
  `services` varchar(191) DEFAULT NULL,
  `only_for_user` varchar(191) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `quantity_limit` int(11) DEFAULT NULL,
  `limit_per_user` int(11) DEFAULT NULL,
  `image_id` bigint(20) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bravo_coupons_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_coupons`
--

INSERT INTO `bravo_coupons` (`id`, `code`, `name`, `amount`, `discount_type`, `end_date`, `min_total`, `max_total`, `services`, `only_for_user`, `status`, `quantity_limit`, `limit_per_user`, `image_id`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,'Asad','asad',10.00,'fixed',NULL,100.00,10000.00,NULL,NULL,'publish',1,1,227,1,NULL,NULL,'2023-09-19 06:29:41','2023-09-19 06:29:41');

--
-- Table structure for table `bravo_enquiries`
--

CREATE TABLE `bravo_enquiries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int(11) DEFAULT NULL,
  `object_model` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `vendor_id` bigint(20) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `publish_date` datetime 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_enquiries`
--

INSERT INTO `bravo_enquiries` (`id`, `object_id`, `object_model`, `name`, `email`, `phone`, `note`, `vendor_id`, `status`, `publish_date`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES (1,12,'event','Kumar Abhi','abhishek@peytonsoft.com','9667732250','bgftrhfg',1,'pending',NULL,11,NULL,'2023-09-19 06:35:14','2023-09-19 06:35:14');

--
-- Table structure for table `bravo_enquiry_replies`
--

CREATE TABLE `bravo_enquiry_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `create_user` int(11) DEFAULT NULL,
  `update_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_enquiry_replies_parent_id_index` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_enquiry_replies`
--


--
-- Table structure for table `bravo_event_dates`
--

CREATE TABLE `bravo_event_dates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `target_id` bigint(20) DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `ticket_types` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 0,
  `note_to_customer` text DEFAULT NULL,
  `note_to_admin` text DEFAULT NULL,
  `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,
  `price` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_event_dates`
--


--
-- Table structure for table `bravo_event_term`
--

CREATE TABLE `bravo_event_term` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_event_term`
--

INSERT INTO `bravo_event_term` (`id`, `term_id`, `target_id`, `create_user`, `update_user`, `created_at`, `updated_at`) VALUES (1,75,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(2,76,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(3,78,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(4,79,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(5,80,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(6,81,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(7,82,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(8,75,2,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(9,76,2,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(10,77,2,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(11,81,2,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(12,82,2,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(13,75,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(14,76,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(15,77,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(16,79,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(17,80,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(18,81,3,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(19,76,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(20,77,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(21,78,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(22,79,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(23,80,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(24,82,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(25,75,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(26,77,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(27,79,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(28,80,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(29,81,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:29'),
(30,82,5,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(31,75,6,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(32,78,6,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(33,75,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(34,76,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(35,77,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(36,80,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(37,81,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(38,82,7,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(39,77,8,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(40,78,8,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(41,80,8,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(42,81,8,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(43,82,8,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(44,76,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(45,77,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(46,78,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(47,79,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(48,80,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(49,81,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(50,82,9,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(51,75,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(52,76,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(53,77,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(54,79,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(55,80,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(56,81,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(57,82,10,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(58,75,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(59,76,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(60,77,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(61,78,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(62,79,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(63,80,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(64,81,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(65,82,11,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(66,75,12,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(67,78,12,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(68,81,12,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30'),
(69,82,12,NULL,NULL,'2023-03-23 08:49:30','2023-03-23 08:49:30');

--
-- Table structure for table `bravo_event_translations`
--

CREATE TABLE `bravo_event_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_id` int(10) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `address` varchar(255) 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 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_event_translations_locale_index` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_event_translations`
--


--
-- Table structure for table `bravo_events`
--

CREATE TABLE `bravo_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `content` text DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `map_lat` varchar(20) DEFAULT NULL,
  `map_lng` varchar(20) DEFAULT NULL,
  `map_zoom` int(11) DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `gallery` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `faqs` text DEFAULT NULL,
  `ticket_types` text DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `start_time` varchar(191) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `is_instant` tinyint(4) DEFAULT 0,
  `enable_extra_price` tinyint(4) DEFAULT NULL,
  `extra_price` text DEFAULT NULL,
  `review_score` decimal(2,1) DEFAULT NULL,
  `ical_import_url` varchar(191) DEFAULT NULL,
  `status` varchar(50) 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,
  `enable_service_fee` tinyint(4) DEFAULT NULL,
  `service_fee` text DEFAULT NULL,
  `surrounding` text DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `duration_unit` varchar(255) DEFAULT NULL,
  `author_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bravo_events_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bravo_events`
--

INSERT INTO `bravo_events` (`id`, `title`, `slug`, `content`, `image_id`, `banner_image_id`, `location_id`, `address`, `map_lat`, `map_lng`, `map_zoom`, `is_featured`, `gallery`, `video`, `faqs`, `ticket_types`, `duration`, `start_time`, `price`, `sale_price`, `is_instant`, `enable_extra_price`, `extra_price`, `review_score`, `ical_import_url`, `status`, `default_state`, `create_user`, `update_user`, `deleted_at`, `created_at`, `updated_at`, `enable_service_fee`, `service_fee`, `surrounding`, `end_time`, `duration_unit`, `author_id`) VALUES (1,'Andante & Allegro Event Design','andante-allegro-event-design','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',163,181,1,'Arrondissement de Paris','48.852754','2.339155',12,0,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',1,'20:00',2000.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.7,NULL,'publish',1,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,1),
(2,'Painted Desert Event Designs','painted-desert-event-designs','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',164,182,1,'Porte de Vanves','48.853917','2.307199',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',5,'19:00',900.00,742.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.7,NULL,'publish',1,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,1),
(3,'Bamboo Grove Event Planning','bamboo-grove-event-planning','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',165,183,1,'Petit-Montrouge','48.884900','2.346377',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',7,'19:00',1500.00,794.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.7,NULL,'publish',1,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,4),
(4,'Aspen Glade Weddings & Events','aspen-glade-weddings-events','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',166,181,2,'New York','40.707891','-74.008825',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',9,'17:00',850.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,1),
(5,'Southwest States (Ex Los Angeles) ','southwest-states','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',167,182,2,'Regal Cinemas Battery Park 11','40.714578','-73.983888',12,0,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',7,'18:00',1900.00,1094.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,5),
(6,'Spanish Moss Event Design','spanish-moss-event-design','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',168,183,2,'Prince St Station','40.720161','-74.009628',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',1,'19:00',600.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.7,NULL,'publish',1,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,5),
(7,'Eastern Discovery','eastern-discovery','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',169,181,2,'Pier 36 New York','40.708581','-73.998817',12,0,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',4,'15:00',2100.00,1682.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.5,NULL,'publish',1,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,5),
(8,'Pink Crescent Moon Events','pink-crescent-moon-events','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',170,182,3,'Trimmer Springs Rd, Sanger','36.822484','-119.365266',12,0,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',2,'21:00',700.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,4),
(9,'Northern Lights Event Planners','northern-lights-event-planners','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',171,183,4,'United States','37.040023','-95.643144',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',7,'20:00',800.00,600.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,4,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,4),
(10,'Origami Crane Wedding Planners','origami-crane-wedding-planners','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',172,181,5,'Washington, DC, USA','34.049345','-118.248479',12,0,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',6,'18:00',400.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,5,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,5),
(11,'New York – Discover America','new-york-discover-america','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',173,182,6,'New Jersey','40.035329','-74.417227',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',5,'14:00',300.00,0.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.3,NULL,'publish',1,6,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,6),
(12,'Event of Washington, D.C. Highlights','event-of-washington-dc-highlights','<p>Start and end in San Francisco! With the in-depth cultural event Northern California Summer 2019, you have a 8 day event 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>',174,183,7,'Francisco Parnassus Campus','37.782668','-122.425058',12,1,'175,176,177,178,179,180','https://www.youtube.com/watch?v=UfEiKK-iX70','[{\"title\":\"Can children come to events?\",\"content\":\"Unless otherwise stated, children are always welcome, but please be aware that most of our events are aimed at an adult audience.  Children must be supervised at all times.\"},{\"title\":\"Is there seating at events?\",\"content\":\"Yes, we always provide a variety of seating for all ticketholders unless it\\u2019s a dance event or art show opening.  One of our crew will always be on hand to assist you in finding a seat if you need one.\"},{\"title\":\"Where can I park?\",\"content\":\"There is a wide choice of places to park, however most are not free so please do check before you come on the Southampton City Council website.  We have no onsite parking.\"},{\"title\":\"Are you near public transport?\",\"content\":\"Very.  There is a bus stop a few doors up and the train station is about 7 minutes gentle walk away.\"},{\"title\":\"Is it safe to come at night?\",\"content\":\"To our knowledge, none of our customers has had any bad experience, however we do recommend that if you are worried you stick to the roads rather than walk through the parks.  The roads are well-lit and generally there are a lot of people about at night.\"},{\"title\":\"Can I come on my own?\",\"content\":\"YES!  Many of our customers come alone to events, it\\u2019s never a problem and you will be welcomed warmly.\"}]','[{\"code\":\"ticket_vip\",\"name\":\"Ticket Vip\",\"name_ja\":\"\\u30c1\\u30b1\\u30c3\\u30c8VIP\",\"name_egy\":null,\"price\":\"1000\",\"number\":\"10\"},{\"code\":\"ticket_group_tickets\",\"name\":\"Group Tickets\",\"name_ja\":\"\\u30b0\\u30eb\\u30fc\\u30d7\\u30c1\\u30b1\\u30c3\\u30c8\",\"name_egy\":null,\"price\":\"500\",\"number\":\"10\"}]',7,'17:00',2100.00,1181.00,0,1,'[{\"name\":\"Event service\",\"price\":\"100\",\"type\":\"one_time\"}]',4.0,NULL,'publish',1,1,NULL,NULL,'2023-03-23 08:49:29','2023-03-23 08:49:30',NULL,NULL,NULL,NULL,NULL,1);

--
