-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `flexzyn_traveltra`
--

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

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `activityName` text DEFAULT NULL,
  `firm_name` varchar(255) DEFAULT NULL,
  `duration` varchar(100) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `image3` varchar(255) DEFAULT NULL,
  `image4` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` varchar(255) DEFAULT NULL,
  `metaDescription` varchar(255) DEFAULT NULL,
  `metaImage` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity`
--

INSERT INTO `activity` (`id`, `user_id`, `activityName`, `firm_name`, `duration`, `destination`, `image`, `image2`, `image3`, `image4`, `description`, `status`, `seoUrl`, `metaTitle`, `metaKeyword`, `metaDescription`, `metaImage`, `created_at`, `updated_at`) VALUES
(2, NULL, 'Golden Circle, Kerid Volcanic Crater, and Blue Lagoon Day Tripw', 'Lorem Ipsum', '1 hour', 'Westminster Borough, London', '19883067411 (2).png', '4382860106.png', '5254381074.png', '18368409033.png', '<p>1Unless you hire a car, visiting Stonehenge, Bath, and Windsor Castle in one day is next to impossible. Designed specifically for travelers with limited time in London, this tour allows you to check off a range of southern England&#39;s historical attractions in just one day by eliminating the hassle of traveling between each one independently. Travel by comfortable coach and witness your guide bring each UNESCO World Heritage Site to life with commentary. Plus, all admission tickets are included in the tour price.</p>', 1, 'golden-circle-kerid-volcanic-crater-and-blue-lagoon-day-trip', 'Golden Circle, Kerid Volcanic Crater, and Blue Lagoon Day Trip | Travel Tra', NULL, 'Golden Circle, Kerid Volcanic Crater, and Blue Lagoon Day Trip | Travel Tra', NULL, '2023-05-12 05:42:25', '2023-07-13 00:49:56'),
(3, NULL, 'Edinburgh Sky to Sea Bike Tour by Manual or E-Bike1', 'Lorem Ipsum', NULL, 'Ciutat Vella, Barcelona', '8416823422 (2).png', NULL, NULL, NULL, NULL, 1, 'edinburgh-sky-to-sea-bike-tour-by-manual-or-e-bike', 'Edinburgh Sky to Sea Bike Tour by Manual or E-Bike | Travel Tra', NULL, 'Edinburgh Sky to Sea Bike Tour by Manual or E-Bike | Travel Tra', NULL, '2023-05-12 05:43:15', '2023-06-20 23:01:08'),
(4, NULL, 'Natural Crystal Blue Ice Cave Tour of Vatnajökull Glacier', 'Lorem Ipsum', NULL, 'Manhattan, New York', '5371538683 (2).png', NULL, NULL, NULL, NULL, 1, 'natural-crystal-blue-ice-cave-tour-of-vatnaj-kull-glacier', 'Natural Crystal Blue Ice Cave Tour of Vatnajökull Glacier | Travel Tra', NULL, 'Natural Crystal Blue Ice Cave Tour of Vatnajökull Glacier | Travel Tra', NULL, '2023-05-12 05:44:00', '2023-05-12 05:44:00'),
(5, NULL, 'South Coast Full Day Tour by Minibus from Reykjavik', 'Lorem Ipsum', NULL, 'Vaticano Prati, Rome', '26264404561.2.jpg', NULL, NULL, NULL, NULL, 1, 'south-coast-full-day-tour-by-minibus-from-reykjavik', 'South Coast Full Day Tour by Minibus from Reykjavik | Travel Tra', NULL, 'South Coast Full Day Tour by Minibus from Reykjavik | Travel Tra', NULL, '2023-05-12 05:44:51', '2023-06-20 23:01:24'),
(6, 20, 'swimming', 'Swimming Industries', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '2023-07-10 05:34:14', '2023-07-10 05:34:14');

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` int(11) NOT NULL,
  `amenity_categoryId` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`id`, `amenity_categoryId`, `name`, `status`, `created_at`, `updated_at`) VALUES
(3, 1, 'Towels', 1, '2023-07-13 03:53:22', '2023-07-13 03:53:22'),
(4, 1, 'Bath or showe', 1, '2023-07-13 03:53:36', '2023-07-13 03:53:36'),
(5, 1, 'Private bathroom', 1, '2023-07-13 03:53:52', '2023-07-13 03:53:52'),
(6, 1, 'Toilet', 1, '2023-07-13 03:54:12', '2023-07-13 03:54:12'),
(7, 1, 'Free toiletries', 1, '2023-07-13 03:54:22', '2023-07-13 03:54:22'),
(8, 1, 'Hairdryer', 1, '2023-07-13 03:54:33', '2023-07-13 03:54:33'),
(9, 1, 'Bath', 1, '2023-07-13 03:54:46', '2023-07-13 03:54:46'),
(10, 1, 'Linen', 1, '2023-07-13 03:55:02', '2023-07-13 03:55:02'),
(11, 1, 'Wardrobe or closet', 1, '2023-07-13 03:55:14', '2023-07-13 03:55:14'),
(12, 1, 'Invoice provided', 1, '2023-07-13 03:55:32', '2023-07-13 03:55:32'),
(13, 1, 'Private check-in/check-out', 1, '2023-07-13 03:55:49', '2023-07-13 03:55:49'),
(14, 1, 'Luggage storage', 1, '2023-07-13 03:56:00', '2023-07-13 03:56:00'),
(15, 1, '24-hour front desk', 1, '2023-07-13 03:56:09', '2023-07-13 03:56:09'),
(16, 2, 'Entry ticket to Harry Potter Warner Bros Studio Tour London', 1, '2023-07-13 03:57:29', '2023-07-13 03:57:29'),
(17, 2, 'Return transfers in air-conditioned coach', 1, '2023-07-13 03:57:43', '2023-07-13 03:57:43'),
(18, 2, 'Food and drinks', 1, '2023-07-13 03:57:55', '2023-07-13 03:57:55'),
(19, 2, 'Gratuities', 1, '2023-07-13 03:58:07', '2023-07-13 03:58:07'),
(20, 2, 'Digital guide available in 10 different languages at additional cost', 1, '2023-07-13 03:58:21', '2023-07-13 03:58:21'),
(21, 3, 'lorem ipsum 1', 1, '2023-07-13 03:59:48', '2023-07-13 03:59:48'),
(22, 3, 'lorem Ipsum 2', 1, '2023-07-13 04:00:01', '2023-07-13 04:00:01'),
(23, 3, 'lorem ipsum 3', 1, '2023-07-13 04:00:14', '2023-07-13 04:00:14'),
(24, 3, 'loem ipsum 4', 1, '2023-07-13 04:00:29', '2023-07-13 04:00:29'),
(25, 4, 'Airbag', 0, '2023-07-13 04:01:35', '2023-07-13 04:01:35'),
(26, 4, 'Power Windows', 0, '2023-07-13 04:01:46', '2023-07-13 04:01:46'),
(27, 4, 'Speed Km', 0, '2023-07-13 04:02:08', '2023-07-13 04:02:08'),
(28, 4, 'FM Radio', 0, '2023-07-13 04:02:20', '2023-07-13 04:02:20'),
(29, 4, 'Sensor', 1, '2023-07-13 04:02:33', '2023-07-13 04:02:33'),
(30, 4, 'Steering Wheel', 1, '2023-07-13 04:02:43', '2023-07-13 04:02:43');

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

--
-- Table structure for table `amenities_category`
--

CREATE TABLE `amenities_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `amenities_category`
--

INSERT INTO `amenities_category` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hotel', 1, '2023-07-13 03:23:43', '2023-07-13 03:23:43'),
(2, 'Tour', 1, '2023-07-13 03:25:48', '2023-07-13 03:25:48'),
(3, 'Activity', 1, '2023-07-13 03:26:00', '2023-07-13 03:26:00'),
(4, 'Car', 1, '2023-07-13 03:26:17', '2023-07-13 03:26:17');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `bannerName` varchar(255) DEFAULT NULL,
  `bannerName_lang1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `heading_lang1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `buttonLink` varchar(255) DEFAULT NULL,
  `videoLink` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `is_app` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) NOT NULL,
  `blogTitle` varchar(100) DEFAULT NULL,
  `blog_categoryId` tinyint(4) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `metaTitle` varchar(150) DEFAULT NULL,
  `metaKeyword` text DEFAULT NULL,
  `metaDescription` text DEFAULT NULL,
  `thumbnail` varchar(100) DEFAULT NULL,
  `banner` varchar(100) DEFAULT NULL,
  `publishDate` date DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `seoUrl` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `blogTitle`, `blog_categoryId`, `description`, `metaTitle`, `metaKeyword`, `metaDescription`, `thumbnail`, `banner`, `publishDate`, `status`, `seoUrl`, `created_at`, `updated_at`) VALUES
(1, 'The National Avg Interest Rate for Savings Accounts', 2, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', NULL, NULL, '9961947837.png', '247875788blog-v1-1.jpg', '2022-05-29', 1, 'the-national-avg-interest-rate-for-savings-accounts-', '2023-04-15 02:43:01', '2023-07-11 22:50:17'),
(2, 'Board Approves Capital Raise of Rs. 2000 Crores', 1, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'Board Approves Capital Raise of Rs. 2000 Crores                                  | SRSN', NULL, NULL, '9705562056.png', '1878432772blog-v1-2.jpg', '2022-05-25', 1, 'board-approves-capital-raise-of-rs-2000-crores-', '2023-04-15 02:45:01', '2023-07-11 22:50:27'),
(3, 'The National Avg Interest Rate for Savings Accounts', 3, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', NULL, NULL, '18606792025.png', '1103411324blog-v1-3.jpg', '2022-05-10', 1, 'the-national-avg-interest-rate-for-savings-accounts-', '2023-04-15 02:46:02', '2023-07-11 22:50:50'),
(5, 'asa', 4, NULL, 'asa | SRSN', NULL, 'asa | SRSN', '5491952752.png', '1565154627unnamed.jpg', NULL, 1, 'asa', '2023-05-02 01:21:50', '2023-07-11 22:51:21'),
(6, 'The National Avg Interest Rate for Savings Accounts', 4, NULL, 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', NULL, 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', '2669383318.png', '582062924logo.png', '2023-05-19', 1, 'the-national-avg-interest-rate-for-savings-accounts-', '2023-05-02 01:30:01', '2023-07-11 22:50:07'),
(7, 'The National Avg Interest Rate for Savings Accounts', 1, NULL, 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', NULL, 'The National Avg Interest Rate for Savings Accounts                                  | SRSN', '4169563422024851147.png', '21387297823.png', '2023-05-19', 1, 'the-national-avg-interest-rate-for-savings-accounts-', '2023-05-02 01:36:29', '2023-07-21 04:50:33');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `id` int(11) NOT NULL,
  `cat_name` varchar(255) DEFAULT NULL,
  `sortOrder` int(11) DEFAULT NULL,
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` text DEFAULT NULL,
  `metaDescription` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`id`, `cat_name`, `sortOrder`, `seoUrl`, `metaTitle`, `metaKeyword`, `metaDescription`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Art and culture', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:52:48', '2023-07-11 06:52:48'),
(2, 'Beaches', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:52:58', '2023-07-11 06:52:58'),
(3, 'Adventure travel', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:53:08', '2023-07-11 06:53:08'),
(4, 'Explore', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:55:47', '2023-07-11 06:55:47'),
(5, 'Family holidays', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:55:58', '2023-07-11 06:55:58'),
(6, 'Air travel', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:56:18', '2023-07-11 06:56:18'),
(7, 'Food and drink', NULL, NULL, NULL, NULL, NULL, 1, '2023-07-11 06:56:36', '2023-07-11 06:56:36');

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

--
-- Table structure for table `car`
--

CREATE TABLE `car` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `carName` text DEFAULT NULL,
  `owner_name` varchar(255) DEFAULT NULL,
  `firm_name` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `image3` varchar(255) DEFAULT NULL,
  `image4` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` varchar(255) DEFAULT NULL,
  `metaDescription` varchar(255) DEFAULT NULL,
  `metaImage` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `car`
--

INSERT INTO `car` (`id`, `user_id`, `carName`, `owner_name`, `firm_name`, `destination`, `image`, `image2`, `image3`, `image4`, `description`, `status`, `seoUrl`, `metaTitle`, `metaKeyword`, `metaDescription`, `metaImage`, `created_at`, `updated_at`) VALUES
(3, NULL, 'Mercedes-Benz E-Class', NULL, 'Lorem Ipsum', 'Heathrow Airport', '11733828311 (3).png', NULL, NULL, NULL, NULL, 1, '-mercedes-benz-e-class', 'Mercedes-Benz E-Class | Travel Tra', NULL, 'Mercedes-Benz E-Class | Travel Tra', NULL, '2023-05-12 05:49:57', '2023-05-12 05:49:57'),
(4, NULL, 'Jaguar F-Pace', NULL, 'Lorem Ipsum', 'Heathrow Airport', '10984267252 (3).png', NULL, NULL, NULL, NULL, 1, '-jaguar-f-pace', 'Jaguar F-Pace | Travel Tra', NULL, 'Jaguar F-Pace | Travel Tra', NULL, '2023-05-12 05:50:32', '2023-05-12 05:50:32'),
(5, NULL, 'Volvo XC90', NULL, 'Lorem Ipsum', 'Heathrow Airport', '7501874493 (3).png', NULL, NULL, NULL, NULL, 1, '-volvo-xc90', 'Volvo XC90 | Travel Tra', NULL, 'Volvo XC90 | Travel Tra', NULL, '2023-05-12 05:51:13', '2023-05-12 05:51:13'),
(6, NULL, 'BMW 5 Series', 's', 'Lorem Ipsum', 'Heathrow Airport', '7264979584 (3).png', '2402677689.png', '16056930316.png', '19129696928.png', '<p>&nbsp;tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 'bmw-5-series-', 'BMW 5 Series  | Travel Tra', NULL, 'BMW 5 Series  | Travel Tra', NULL, '2023-05-12 05:51:37', '2023-07-13 01:18:02'),
(7, 20, 'Suzuki', NULL, 'Suzuki Tour and Travel', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '2023-07-10 05:37:26', '2023-07-10 05:37:26');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hotel`
--

CREATE TABLE `hotel` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `hotelName` text DEFAULT NULL,
  `amenities` longtext DEFAULT NULL,
  `firm_name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `image3` varchar(255) DEFAULT NULL,
  `image4` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` varchar(255) DEFAULT NULL,
  `metaDescription` varchar(255) DEFAULT NULL,
  `metaImage` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hotel`
--

INSERT INTO `hotel` (`id`, `user_id`, `hotelName`, `amenities`, `firm_name`, `image`, `image2`, `image3`, `image4`, `description`, `status`, `address`, `seoUrl`, `metaTitle`, `metaKeyword`, `metaDescription`, `metaImage`, `created_at`, `updated_at`) VALUES
(3, NULL, 'The Montcalm At Brewery London City', NULL, 'Lorem Ipsum', '11664049301.png', NULL, NULL, NULL, NULL, 1, 'Westminster Borough, London', 'the-montcalm-at-brewery-london-city', 'The Montcalm At Brewery London City | Travel Tra', NULL, 'The Montcalm At Brewery London City | Travel Tra', NULL, '2023-05-12 05:25:22', '2023-05-12 05:25:22'),
(4, NULL, 'Staycity Aparthotels Deptford Bridge Station', NULL, 'Lorem Ipsum', '1927186192.png', NULL, NULL, NULL, NULL, 1, 'Ciutat Vella, Barcelona', 'staycity-aparthotels-deptford-bridge-station', 'Staycity Aparthotels Deptford Bridge Station | Travel Tra', NULL, 'Staycity Aparthotels Deptford Bridge Station | Travel Tra', NULL, '2023-05-12 05:26:56', '2023-05-12 05:26:56'),
(5, NULL, 'The Westin New York at Times Square', NULL, 'Lorem Ipsum', '201953773.png', NULL, NULL, NULL, NULL, 1, 'Manhattan, New York', 'the-westin-new-york-at-times-square', 'The Westin New York at Times Square | Travel Tra', NULL, 'The Westin New York at Times Square | Travel Tra', NULL, '2023-05-12 05:27:40', '2023-05-12 05:27:40'),
(6, NULL, 'DoubleTree by Hilton Hotel New York Times Square West', NULL, 'Lorem Ipsum', '13606447364.png', '4339678185.png', '8852299344.png', '9838526403.png', '<p>&nbsp;Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 'Vaticano Prati, Rome', 'doubletree-by-hilton-hotel-new-york-times-square-west', 'DoubleTree by Hilton Hotel New York Times Square West | Travel Tra', NULL, 'DoubleTree by Hilton Hotel New York Times Square West | Travel Tra', NULL, '2023-05-12 05:28:24', '2023-07-12 23:58:35'),
(12, 2, 'Taj Hotel', NULL, 'Tata Gropups', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-09 22:42:56', '2023-07-09 22:42:56'),
(13, NULL, 'mayfire', NULL, 'mayfire pvt. Ltd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 00:12:48', '2023-07-10 00:12:48'),
(14, 20, 'Hotel Royal', NULL, 'Royal Industries', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 00:17:16', '2023-07-10 00:22:18'),
(15, NULL, 'Test', NULL, 'Test Industries', '1226736890783132013_Virgin-Coconut-Oil-Softgels1-min.jpg', NULL, NULL, NULL, NULL, NULL, 'balangir', 'test', 'Test | Travel Tra', NULL, 'Test | Travel Tra', NULL, '2023-07-10 00:24:09', '2023-07-10 00:24:09'),
(16, 2, 'Hotel Garden Inn', NULL, 'Garden In Pvt.Ltd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 00:38:33', '2023-07-10 00:38:33'),
(17, 21, 'Hote Grand Avenue', NULL, 'Avenue Industries', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 00:43:18', '2023-07-10 00:43:18'),
(18, 20, 'hotel Blue Lagoon', NULL, 'blue lagoon pvt.ltd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 01:32:58', '2023-07-10 01:32:58'),
(20, 20, 'Hello Url', NULL, 'My First Seo Url', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 01:43:05', '2023-07-10 01:43:05'),
(21, 1, 'xyz', NULL, 'Lorem Ipsum', '533881684.png', '8292875305.png', '5719767696.png', '12643030047.png', 'sdasdsa', NULL, 'loremipsum', NULL, NULL, NULL, NULL, NULL, '2023-07-12 01:39:19', '2023-07-12 03:10:21');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1);

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

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

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `pageName` varchar(255) DEFAULT NULL,
  `img_1` varchar(255) DEFAULT NULL,
  `img_2` varchar(255) DEFAULT NULL,
  `img_3` varchar(255) DEFAULT NULL,
  `img_4` varchar(255) DEFAULT NULL,
  `firm_name` varchar(200) DEFAULT NULL,
  `destination` varchar(200) DEFAULT NULL,
  `is_feature` tinyint(4) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `onTop` int(11) DEFAULT NULL,
  `onFooter` int(11) DEFAULT NULL,
  `sortOrder` int(11) DEFAULT NULL,
  `heading1` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` text DEFAULT NULL,
  `metaDescription` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('vW4n2X6zUnfW3tVO7nb9UTdICCCA1vdsq7s9S5Cv', 21, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNTExT2ZwRXBaTzJPUURYc043SkZZZnJ3VXFxWnlGTW5KV1p1NFNnRCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9ob3RlbC90aGUtbW9udGNhbG0tYXQtYnJld2VyeS1sb25kb24tY2l0eSI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjIxO3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkSlQxWWxhdHJOZG1vaVN4Q0RNSDg4dXFQNTlFUml3ekpkNk5JL3lkL3BMOWhSR3k1ODJFYzIiO30=', 1689665460),
('6MOYoZ4JvZmBdWgulJNVP5HAj928M21ct6w0Vgf8', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMFh2Z3VZTmlCRUtFRGJWb1FKWWNkaG1JbDh3OWJRVlNnM0Zudm1JSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1689661114);

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `phone1` varchar(255) DEFAULT NULL,
  `phone2` varchar(255) DEFAULT NULL,
  `email1` varchar(255) DEFAULT NULL,
  `email2` varchar(255) DEFAULT NULL,
  `audio` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `address_lang1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `workingHour` varchar(255) DEFAULT NULL,
  `fbLink` varchar(255) DEFAULT NULL,
  `twitterLink` varchar(255) DEFAULT NULL,
  `linkedinLink` varchar(255) DEFAULT NULL,
  `instaLink` varchar(255) DEFAULT NULL,
  `youtubeLink` varchar(255) DEFAULT NULL,
  `googlePlusLink` varchar(255) DEFAULT NULL,
  `mapLink` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `tax_name` varchar(200) DEFAULT NULL,
  `is_tax` tinyint(4) NOT NULL DEFAULT 0,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `shipping_cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `min_value_for_free_shipping` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `logo`, `phone1`, `phone2`, `email1`, `email2`, `audio`, `address`, `address_lang1`, `workingHour`, `fbLink`, `twitterLink`, `linkedinLink`, `instaLink`, `youtubeLink`, `googlePlusLink`, `mapLink`, `created_at`, `updated_at`, `tax_name`, `is_tax`, `tax`, `shipping_cost`, `min_value_for_free_shipping`) VALUES
(1, '', '9959277205', '40-29558083', 'info@amrutavani.com', 'amruthavani.c.cen@hotmail.com', NULL, '<p>50 Sebastian Road Regimental Bazar, Secunderabad &ndash; 500003, Telangana, India</p>', '<p>asdsada</p>', '9:00 AM - 19:00 PM', 'https://www.facebook.com/', 'https://www.twitter.com/', NULL, 'https://www.instagram.com/', 'https://www.youtube.com/', NULL, NULL, '2022-08-17 04:27:39', '2022-08-16 22:57:39', 'GST', 0, 0.00, 0.00, 0.00);

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

--
-- Table structure for table `tour`
--

CREATE TABLE `tour` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `amenities` longtext DEFAULT NULL,
  `firm_name` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `image3` varchar(255) DEFAULT NULL,
  `image4` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `seoUrl` varchar(255) DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaKeyword` varchar(255) DEFAULT NULL,
  `metaDescription` varchar(255) DEFAULT NULL,
  `metaImage` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour`
--

INSERT INTO `tour` (`id`, `user_id`, `name`, `amenities`, `firm_name`, `destination`, `image`, `image2`, `image3`, `image4`, `description`, `status`, `seoUrl`, `metaTitle`, `metaKeyword`, `metaDescription`, `metaImage`, `created_at`, `updated_at`) VALUES
(3, NULL, 'Stonehenge, Windsor Castle and Bath with Pub Lunch in Lacock', NULL, 'Lorem Ipsum', 'Westminster Borough, London', '17415347921 (1).png', NULL, NULL, NULL, NULL, 1, 'stonehenge-windsor-castle-and-bath-with-pub-lunch-in-lacock', 'Stonehenge, Windsor Castle and Bath with Pub Lunch in Lacock | Travel Tra', NULL, 'Stonehenge, Windsor Castle and Bath with Pub Lunch in Lacock | Travel Tra', NULL, '2023-05-12 05:35:16', '2023-05-12 05:35:16'),
(4, NULL, 'Westminster Walking Tour & Westminster Abbey Entry', NULL, 'Lorem Ipsum', 'Ciutat Vella, Barcelona', '7357661462 (1).png', NULL, NULL, NULL, NULL, 1, 'westminster-walking-tour-and-westminster-abbey-entry', 'Westminster Walking Tour & Westminster Abbey Entry | Travel Tra', NULL, 'Westminster Walking Tour & Westminster Abbey Entry | Travel Tra', NULL, '2023-05-12 05:36:13', '2023-05-12 05:36:13'),
(5, NULL, 'High-Speed Thames River RIB Cruise in London', NULL, 'Lorem Ipsum', 'Manhattan, New York', '16962848093 (1).png', '19428095279.png', '2024851147.png', '16992824051.png', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 'high-speed-thames-river-rib-cruise-in-london', 'High-Speed Thames River RIB Cruise in London | Travel Tra', NULL, 'High-Speed Thames River RIB Cruise in London | Travel Tra', NULL, '2023-05-12 05:36:54', '2023-07-12 23:28:21'),
(6, NULL, 'Edinburgh Darkside Walking Tour: Mysteries, Murder and Legends', NULL, 'Lorem Ipsum', 'Vaticano Prati, Rome', '20609957174 (1).png', NULL, NULL, NULL, NULL, 1, 'edinburgh-darkside-walking-tour-mysteries-murder-and-legends', 'Edinburgh Darkside Walking Tour: Mysteries, Murder and Legends | Travel Tra', NULL, 'Edinburgh Darkside Walking Tour: Mysteries, Murder and Legends | Travel Tra', NULL, '2023-05-12 05:37:25', '2023-05-12 05:37:25'),
(7, 20, 'Manali  3 Day 3 Night .', NULL, 'Praresh Harpal', 'Manali', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '2023-07-10 05:24:01', '2023-07-10 05:24:01'),
(8, 20, 'asasa', NULL, 'sasa', 'asas', '1228408411783132013_Virgin-Coconut-Oil-Softgels1-min.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 06:01:26', '2023-07-10 06:36:34'),
(9, 20, 'dd', NULL, 'sdasd', 'asdasd', '1189544922Tshirt.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-10 06:29:16', '2023-07-10 06:29:16'),
(10, 1, 'Test', NULL, 'Lorem Ipsum', 'Heathrow Airport', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-13 06:32:28', '2023-07-13 06:32:28'),
(11, 1, 'gdfgd', '[\"16\",\"17\",\"18\",\"19\",\"20\"]', 'fgdfg', 'dgdf', NULL, NULL, NULL, NULL, '<p>dgffdg</p>', NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-13 06:53:34', '2023-07-13 06:53:34');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity`
--
ALTER TABLE `activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `amenities`
--
ALTER TABLE `amenities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `amenities_category`
--
ALTER TABLE `amenities_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_category`
--
ALTER TABLE `blog_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car`
--
ALTER TABLE `car`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `hotel`
--
ALTER TABLE `hotel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tour`
--
ALTER TABLE `tour`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity`
--
ALTER TABLE `activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `amenities_category`
--
ALTER TABLE `amenities_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `car`
--
ALTER TABLE `car`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hotel`
--
ALTER TABLE `hotel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tour`
--
ALTER TABLE `tour`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

