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

START TRANSACTION;



--
-- Database: `app_unbound`
--

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

--
-- Table structure for table `accommodation`
--

CREATE TABLE `accommodation` (
  `id` int(11) NOT NULL,
  `included` tinyint(1) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accommodation`
--

INSERT INTO `accommodation` (`id`, `included`, `count`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 1, 73, '2025-08-23 05:24:57', '2025-08-23 11:25:15', NULL),
(3, 1, 863, '2025-08-23 05:25:00', '2025-08-23 11:36:30', NULL),
(4, 1, 39, '2025-08-23 05:51:28', '2025-08-23 11:51:28', NULL),
(5, 0, 22, '2025-08-23 05:51:32', '2025-08-23 11:51:32', NULL),
(6, 0, 54, '2025-08-23 05:51:35', '2025-08-23 11:51:35', NULL),
(7, 1, 33, '2025-08-23 05:51:39', '2025-08-23 11:51:39', NULL),
(8, 0, 29, '2025-08-23 05:51:42', '2025-08-23 11:51:42', NULL),
(9, 0, 54, '2025-08-23 05:51:45', '2025-08-23 11:51:45', NULL),
(10, 0, 20, '2025-08-23 05:51:49', '2025-08-23 11:51:49', NULL),
(11, 0, 83, '2025-08-23 05:51:52', '2025-08-23 11:51:52', NULL),
(12, 1, 54, '2025-08-23 05:51:56', '2025-08-23 11:51:56', NULL);

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

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` int(11) NOT NULL,
  `city_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` (`id`, `city_id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Uttara', '2025-08-20 10:36:11', NULL, NULL),
(2, 1, 'Bonani', '2025-08-23 07:20:47', '2025-08-23 13:20:47', NULL),
(3, 1, 'Brendan Burke', '2025-08-23 08:56:03', '2025-08-23 14:56:03', NULL);

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `order_id` varchar(50) DEFAULT NULL COMMENT 'Unique random order reference',
  `customer_id` bigint(20) DEFAULT NULL COMMENT 'Customer who made the booking',
  `tour_package_id` int(11) DEFAULT NULL COMMENT 'Booked tour package',
  `custom_package_requests_id` int(11) DEFAULT NULL COMMENT 'Booked Custom Package request',
  `service_requests_id` int(11) DEFAULT NULL COMMENT 'Booked service request',
  `booking_no` varchar(100) DEFAULT NULL COMMENT 'System-generated unique booking reference',
  `booking_date` date DEFAULT NULL COMMENT 'Date when the booking was created',
  `travel_date` date DEFAULT NULL COMMENT 'Intended travel start date',
  `pickup_location` varchar(255) DEFAULT NULL,
  `dropoff_location` varchar(255) DEFAULT NULL,
  `number_of_adults` int(11) DEFAULT 1 COMMENT 'Total adults in the booking',
  `number_of_kids` int(11) DEFAULT 0 COMMENT 'Total kids in the booking',
  `total_persons` int(11) DEFAULT NULL COMMENT 'Calculated total of all persons',
  `unit_price` decimal(10,2) NOT NULL,
  `total_payable_amount` decimal(10,2) DEFAULT NULL COMMENT 'Total cost before any payment and discounts',
  `discount_amount` decimal(10,2) DEFAULT NULL COMMENT 'Total discount applied to the booking',
  `others_discount_amount` decimal(10,2) DEFAULT NULL COMMENT 'Others discount applied to the booking',
  `paid_amount` decimal(10,2) DEFAULT 0.00 COMMENT 'Total amount paid so far',
  `due_amount` decimal(10,2) DEFAULT NULL COMMENT 'Remaining amount to be paid (total - discount - paid)',
  `payment_due_date` datetime DEFAULT NULL,
  `payment_status` tinyint(4) DEFAULT 0 COMMENT '0=Pending, 1=Partially Paid, 2=Paid — Overall payment status',
  `tour_guide_id` bigint(20) DEFAULT NULL COMMENT 'Primary guide assigned from the tour_guides list for this booking',
  `notes` text DEFAULT NULL COMMENT 'Additional instructions or notes from user/admin',
  `booking_status` tinyint(4) DEFAULT 0 COMMENT '0=Ongoing, 1=Upcoming, 2=Completed, 3=Booked, 4=Cancelled — Booking lifecycle status',
  `order_status` tinyint(4) DEFAULT 0 COMMENT '0 = Pending, 1 = Confirmed, 2 = Cancelled, 3 = Refunded',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'Admin or user who created the booking',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `order_id`, `customer_id`, `tour_package_id`, `custom_package_requests_id`, `service_requests_id`, `booking_no`, `booking_date`, `travel_date`, `pickup_location`, `dropoff_location`, `number_of_adults`, `number_of_kids`, `total_persons`, `unit_price`, `total_payable_amount`, `discount_amount`, `others_discount_amount`, `paid_amount`, `due_amount`, `payment_due_date`, `payment_status`, `tour_guide_id`, `notes`, `booking_status`, `order_status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(8, '#ORD0000001', 1, 43, NULL, NULL, '#BK0000001', '2025-08-26', '2012-02-12', 'Dolor et sit suscip', 'Veritatis sint ipsam', 63, 107, 40, 0.00, NULL, NULL, 89.00, 31.00, NULL, '2001-07-04 14:21:00', 0, 5, 'Est ex mollitia offi', 1, 1, 2, NULL, '2025-08-26 07:31:19', '2025-08-26 13:31:19', NULL),
(10, '#ORD0000002', 1, 26, NULL, NULL, '#BK0000002', '2025-08-26', '2005-06-05', 'Voluptatem nihil vol', 'Ea consectetur ullam', 291, 489, 61, 0.00, NULL, 346.00, 5.00, NULL, 0.00, '1992-11-28 20:33:00', 0, NULL, 'Rem ratione deserunt', 0, 1, 2, 2, '2025-08-26 08:16:07', '2025-08-26 14:16:07', NULL),
(11, '#ORD0000003', 1, 29, NULL, NULL, '#BK0000003', '2025-08-26', '2024-06-21', 'Vero officia sequi v', 'Velit debitis sint', 585, 408, 59, 0.00, NULL, 681.00, 12.00, 70.00, -70.00, '2023-12-12 02:10:00', 2, 8, 'Quia ea autem molest', 0, 1, 2, 2, '2025-08-26 08:25:27', '2025-08-26 15:59:00', NULL),
(12, '#ORD0000004', 1, 28, NULL, NULL, '#BK0000004', '2025-08-26', '1972-01-09', 'Debitis in vel exerc', 'Qui temporibus offic', 317, 848, 86, 0.00, 32323.00, 87.00, 44.00, NULL, 32323.00, '1991-11-21 03:06:00', 0, NULL, 'Corrupti dolor repr', 0, 1, 2, 2, '2025-08-26 08:28:48', '2025-08-26 14:28:48', NULL),
(13, '#ORD0000005', 1, 28, NULL, NULL, '#BK0000005', '2025-08-26', '2003-02-20', 'Et vel cupiditate qu', 'Corporis anim deseru', 5, 648, 88, 0.00, 32323.00, 87.00, 85.00, NULL, 32323.00, '2013-06-22 07:15:00', 0, NULL, 'Commodi suscipit sol', 0, 1, 2, 2, '2025-08-26 08:32:29', '2025-08-26 14:32:29', NULL),
(14, '#ORD0000006', 1, 25, NULL, NULL, '#BK0000006', '2025-08-26', '1978-03-31', 'Quos fugit ullam si', 'Ut voluptas ipsum ut', 80, 747, 43, 0.00, 3232.00, 144.00, 89.00, NULL, 3232.00, '2024-11-11 02:51:00', 0, NULL, 'Eiusmod est laboris', 0, 1, 2, 2, '2025-08-26 08:33:52', '2025-08-26 14:33:52', NULL),
(18, '#ORD0000007', 1, 29, NULL, NULL, '#BK0000007', '2025-08-26', '1979-03-12', 'Dolore est at adipis', 'Adipisicing est vol', 841, 857, 41, 0.00, 32232.00, 669.00, 22.00, 81.00, 32151.00, '1970-03-27 21:14:00', 1, NULL, 'Qui id ipsam id volu', 0, 1, 2, 2, '2025-08-26 08:37:29', '2025-08-26 14:37:29', NULL),
(19, '#ORD0000008', 1, 25, NULL, NULL, '#BK0000008', '2025-08-26', '1983-09-23', 'Deserunt tenetur aut', 'Sed illum quo sint', 20, 290, 310, 0.00, 3232.00, 144.00, 94.00, 72.00, 3160.00, '1970-11-15 09:05:00', 1, NULL, 'Nulla corrupti blan', 0, 1, 2, 2, '2025-08-26 08:47:10', '2025-08-26 14:47:10', NULL),
(20, '#ORD0000009', 1, 29, NULL, NULL, '#BK0000009', '2025-08-26', '1991-09-06', 'Commodi fuga Omnis', 'Expedita ipsum ut ut', 106, 431, 537, 0.00, 32232.00, 669.00, 31.00, 97.00, 32135.00, '2015-03-14 19:33:00', 1, NULL, 'Voluptate voluptatum', 0, 1, 2, 2, '2025-08-26 08:47:46', '2025-08-26 14:47:46', NULL),
(21, '#ORD0000010', 1, 28, NULL, NULL, '#BK0000010', '2025-08-26', '1985-10-05', 'Incididunt earum qui', 'Similique minim eaqu', 361, 998, 1359, 0.00, 32302.00, 21.00, 21.00, 56.00, 32267.00, '2004-10-11 14:52:00', 1, NULL, 'Ullamco non molestia', 0, 1, 2, 2, '2025-08-26 08:50:31', '2025-08-27 11:41:39', NULL),
(22, '#ORD0000011', 1, 29, NULL, NULL, '#BK0000011', '2025-08-26', '2012-03-24', 'Fugiat placeat lab', 'Tempor aut et ducimu', 212, 12, 224, 0.00, 32232.00, 669.00, 90.00, 74.00, 32158.00, '1987-07-06 04:32:00', 1, NULL, 'Voluptatem velit par', 0, 1, 2, 2, '2025-08-26 09:42:07', '2025-08-26 15:42:07', NULL),
(23, '#ORD0000012', 1, 29, NULL, NULL, '#BK0000012', '2025-08-26', '2012-09-17', 'Fugiat placeat lab', 'Tempor aut et ducimu', 21, 21, 42, 0.00, 32232.00, 701.00, 16.00, 137.00, 32095.00, '2018-12-08 10:43:00', 1, 6, 'Illo elit ipsum rep', 0, 3, 2, 2, '2025-08-26 09:48:45', '2025-08-27 15:36:15', NULL),
(24, '#ORD0000013', 1, 46, NULL, NULL, '#BK0000013', '2025-08-27', '2025-08-13', 'Ex ab ipsum id sapi', 'In modi voluptas exc', 2, 1, 3, 420.00, 161.00, 259.00, 0.00, 99.00, 62.00, '2025-08-29 13:58:00', 1, NULL, NULL, 0, 1, 2, 2, '2025-08-27 08:00:02', '2025-08-27 15:52:19', NULL),
(25, '#ORD0000014', 1, 47, NULL, NULL, '#BK0000014', '2025-08-27', '2000-11-06', 'Sit aspernatur quisq', 'Qui fuga Ipsum sed', 21, 0, 21, 570.00, -318.00, 932.00, 44.00, 134.00, -452.00, '2016-08-25 15:30:00', 2, NULL, 'Sint ut sed dicta i', 0, 1, 2, 2, '2025-08-27 08:00:14', '2025-08-27 15:52:51', NULL),
(26, '#ORD0000015', 1, 65, NULL, NULL, '#BK0000015', '2025-08-27', '2025-08-16', 'Labore excepturi tem', 'Labore animi veniam', 22, 0, 22, 2000.00, 1500.00, 500.00, 0.00, 221.00, 1279.00, '2025-08-30 14:01:00', 1, NULL, NULL, 0, 1, 2, 2, '2025-08-27 08:02:28', '2025-08-27 16:02:20', NULL),
(27, '#ORD0000016', 1, 65, NULL, NULL, '#BK0000016', '2025-08-27', '2006-11-26', 'Labore excepturi tem', 'Labore animi veniam', 22, 0, 22, 2000.00, 1500.00, 544.00, 44.00, 268.00, 1232.00, '2005-03-05 01:20:00', 1, NULL, 'Quis Nam fugit quae', 0, 1, 2, 2, '2025-08-27 08:19:15', '2025-08-27 16:02:38', NULL),
(28, '#ORD0000017', 1, 65, NULL, NULL, '#BK0000017', '2025-08-27', '2008-12-29', 'Labore excepturi tem', 'Labore animi veniam', 22, 0, 22, 2000.00, 1146.00, 32.00, 3.00, 490.00, 1010.00, '2005-06-01 15:24:00', 1, NULL, 'Distinctio Illum d', 0, 1, 2, 2, '2025-08-27 08:31:54', '2025-08-27 16:52:58', NULL);

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL COMMENT 'Cache key',
  `value` mediumtext DEFAULT NULL COMMENT 'Cached data',
  `expiration` int(11) DEFAULT NULL COMMENT 'Expiration timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL COMMENT 'Lock key',
  `owner` varchar(255) DEFAULT NULL COMMENT 'Lock owner identifier',
  `expiration` int(11) DEFAULT NULL COMMENT 'Lock expiration timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL,
  `country_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `country_id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'dhaka', '2025-08-20 10:35:47', NULL, NULL);

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `dial_code` varchar(10) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `flag` varchar(10) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `dial_code`, `code`, `flag`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Afghanistan', '+93', 'AF', '🇦🇫', '2025-08-27 12:20:52', NULL, NULL),
(2, 'Åland Islands', '+358', 'AX', '🇦🇽', '2025-08-27 12:20:52', NULL, NULL),
(3, 'Albania', '+355', 'AL', '🇦🇱', '2025-08-27 12:20:52', NULL, NULL),
(4, 'Algeria', '+213', 'DZ', '🇩🇿', '2025-08-27 12:20:52', NULL, NULL),
(5, 'American Samoa', '+1684', 'AS', '🇦🇸', '2025-08-27 12:20:52', NULL, NULL),
(6, 'Andorra', '+376', 'AD', '🇦🇩', '2025-08-27 12:20:52', NULL, NULL),
(7, 'Angola', '+244', 'AO', '🇦🇴', '2025-08-27 12:20:52', NULL, NULL),
(8, 'Anguilla', '+1264', 'AI', '🇦🇮', '2025-08-27 12:20:52', NULL, NULL),
(9, 'Antarctica', '+672', 'AQ', '🇦🇶', '2025-08-27 12:20:52', NULL, NULL),
(10, 'Antigua and Barbuda', '+1268', 'AG', '🇦🇬', '2025-08-27 12:20:52', NULL, NULL),
(11, 'Argentina', '+54', 'AR', '🇦🇷', '2025-08-27 12:20:52', NULL, NULL),
(12, 'Armenia', '+374', 'AM', '🇦🇲', '2025-08-27 12:20:52', NULL, NULL),
(13, 'Aruba', '+297', 'AW', '🇦🇼', '2025-08-27 12:20:52', NULL, NULL),
(14, 'Australia', '+61', 'AU', '🇦🇺', '2025-08-27 12:20:52', NULL, NULL),
(15, 'Austria', '+43', 'AT', '🇦🇹', '2025-08-27 12:20:52', NULL, NULL),
(16, 'Azerbaijan', '+994', 'AZ', '🇦🇿', '2025-08-27 12:20:52', NULL, NULL),
(17, 'Bahamas', '+1242', 'BS', '🇧🇸', '2025-08-27 12:20:52', NULL, NULL),
(18, 'Bahrain', '+973', 'BH', '🇧🇭', '2025-08-27 12:20:52', NULL, NULL),
(19, 'Bangladesh', '+880', 'BD', '🇧🇩', '2025-08-27 12:20:52', NULL, NULL),
(20, 'Barbados', '+1246', 'BB', '🇧🇧', '2025-08-27 12:20:52', NULL, NULL),
(21, 'Belarus', '+375', 'BY', '🇧🇾', '2025-08-27 12:20:52', NULL, NULL),
(22, 'Belgium', '+32', 'BE', '🇧🇪', '2025-08-27 12:20:52', NULL, NULL),
(23, 'Belize', '+501', 'BZ', '🇧🇿', '2025-08-27 12:20:52', NULL, NULL),
(24, 'Benin', '+229', 'BJ', '🇧🇯', '2025-08-27 12:20:52', NULL, NULL),
(25, 'Bermuda', '+1441', 'BM', '🇧🇲', '2025-08-27 12:20:52', NULL, NULL),
(26, 'Bhutan', '+975', 'BT', '🇧🇹', '2025-08-27 12:20:52', NULL, NULL),
(27, 'Bolivia, Plurinational State of bolivia', '+591', 'BO', '🇧🇴', '2025-08-27 12:20:52', NULL, NULL),
(28, 'Bosnia and Herzegovina', '+387', 'BA', '🇧🇦', '2025-08-27 12:20:52', NULL, NULL),
(29, 'Botswana', '+267', 'BW', '🇧🇼', '2025-08-27 12:20:52', NULL, NULL),
(30, 'Bouvet Island', '+47', 'BV', '🏳', '2025-08-27 12:20:52', NULL, NULL),
(31, 'Brazil', '+55', 'BR', '🇧🇷', '2025-08-27 12:20:52', NULL, NULL),
(32, 'British Indian Ocean Territory', '+246', 'IO', '🇮🇴', '2025-08-27 12:20:52', NULL, NULL),
(33, 'Brunei Darussalam', '+673', 'BN', '🇧🇳', '2025-08-27 12:20:52', NULL, NULL),
(34, 'Bulgaria', '+359', 'BG', '🇧🇬', '2025-08-27 12:20:52', NULL, NULL),
(35, 'Burkina Faso', '+226', 'BF', '🇧🇫', '2025-08-27 12:20:52', NULL, NULL),
(36, 'Burundi', '+257', 'BI', '🇧🇮', '2025-08-27 12:20:52', NULL, NULL),
(37, 'Cambodia', '+855', 'KH', '🇰🇭', '2025-08-27 12:20:52', NULL, NULL),
(38, 'Cameroon', '+237', 'CM', '🇨🇲', '2025-08-27 12:20:52', NULL, NULL),
(39, 'Canada', '+1', 'CA', '🇨🇦', '2025-08-27 12:20:52', NULL, NULL),
(40, 'Cape Verde', '+238', 'CV', '🇨🇻', '2025-08-27 12:20:52', NULL, NULL),
(41, 'Cayman Islands', '+ 345', 'KY', '🇰🇾', '2025-08-27 12:20:52', NULL, NULL),
(42, 'Central African Republic', '+236', 'CF', '🇨🇫', '2025-08-27 12:20:52', NULL, NULL),
(43, 'Chad', '+235', 'TD', '🇹🇩', '2025-08-27 12:20:52', NULL, NULL),
(44, 'Chile', '+56', 'CL', '🇨🇱', '2025-08-27 12:20:52', NULL, NULL),
(45, 'China', '+86', 'CN', '🇨🇳', '2025-08-27 12:20:52', NULL, NULL),
(46, 'Christmas Island', '+61', 'CX', '🇨🇽', '2025-08-27 12:20:52', NULL, NULL),
(47, 'Cocos (Keeling) Islands', '+61', 'CC', '🇨🇨', '2025-08-27 12:20:52', NULL, NULL),
(48, 'Colombia', '+57', 'CO', '🇨🇴', '2025-08-27 12:20:52', NULL, NULL),
(49, 'Comoros', '+269', 'KM', '🇰🇲', '2025-08-27 12:20:52', NULL, NULL),
(50, 'Congo', '+242', 'CG', '🇨🇬', '2025-08-27 12:20:52', NULL, NULL),
(51, 'Congo, The Democratic Republic of the Congo', '+243', 'CD', '🇨🇩', '2025-08-27 12:20:52', NULL, NULL),
(52, 'Cook Islands', '+682', 'CK', '🇨🇰', '2025-08-27 12:20:52', NULL, NULL),
(53, 'Costa Rica', '+506', 'CR', '🇨🇷', '2025-08-27 12:20:52', NULL, NULL),
(54, 'Cote d\'Ivoire', '+225', 'CI', '🇨🇮', '2025-08-27 12:20:52', NULL, NULL),
(55, 'Croatia', '+385', 'HR', '🇭🇷', '2025-08-27 12:20:52', NULL, NULL),
(56, 'Cuba', '+53', 'CU', '🇨🇺', '2025-08-27 12:20:52', NULL, NULL),
(57, 'Cyprus', '+357', 'CY', '🇨🇾', '2025-08-27 12:20:52', NULL, NULL),
(58, 'Czech Republic', '+420', 'CZ', '🇨🇿', '2025-08-27 12:20:52', NULL, NULL),
(59, 'Denmark', '+45', 'DK', '🇩🇰', '2025-08-27 12:20:52', NULL, NULL),
(60, 'Djibouti', '+253', 'DJ', '🇩🇯', '2025-08-27 12:20:52', NULL, NULL),
(61, 'Dominica', '+1767', 'DM', '🇩🇲', '2025-08-27 12:20:52', NULL, NULL),
(62, 'Dominican Republic', '+1849', 'DO', '🇨🇩', '2025-08-27 12:20:52', NULL, NULL),
(63, 'Ecuador', '+593', 'EC', '🇪🇨', '2025-08-27 12:20:52', NULL, NULL),
(64, 'Egypt', '+20', 'EG', '🇪🇬', '2025-08-27 12:20:52', NULL, NULL),
(65, 'El Salvador', '+503', 'SV', '🇸🇻', '2025-08-27 12:20:52', NULL, NULL),
(66, 'Equatorial Guinea', '+240', 'GQ', '🇬🇶', '2025-08-27 12:20:52', NULL, NULL),
(67, 'Eritrea', '+291', 'ER', '🇪🇷', '2025-08-27 12:20:52', NULL, NULL),
(68, 'Estonia', '+372', 'EE', '🇪🇪', '2025-08-27 12:20:52', NULL, NULL),
(69, 'Ethiopia', '+251', 'ET', '🇪🇹', '2025-08-27 12:20:52', NULL, NULL),
(70, 'Falkland Islands (Malvinas)', '+500', 'FK', '🇫🇰', '2025-08-27 12:20:52', NULL, NULL),
(71, 'Faroe Islands', '+298', 'FO', '🇫🇴', '2025-08-27 12:20:52', NULL, NULL),
(72, 'Fiji', '+679', 'FJ', '🇫🇯', '2025-08-27 12:20:52', NULL, NULL),
(73, 'Finland', '+358', 'FI', '🇫🇮', '2025-08-27 12:20:52', NULL, NULL),
(74, 'France', '+33', 'FR', '🇫🇷', '2025-08-27 12:20:52', NULL, NULL),
(75, 'French Guiana', '+594', 'GF', '🇬🇫', '2025-08-27 12:20:52', NULL, NULL),
(76, 'French Polynesia', '+689', 'PF', '🇵🇫', '2025-08-27 12:20:52', NULL, NULL),
(77, 'French Southern Territories', '+262', 'TF', '🇹🇫', '2025-08-27 12:20:52', NULL, NULL),
(78, 'Gabon', '+241', 'GA', '🇬🇦', '2025-08-27 12:20:52', NULL, NULL),
(79, 'Gambia', '+220', 'GM', '🇬🇲', '2025-08-27 12:20:52', NULL, NULL),
(80, 'Georgia', '+995', 'GE', '🇬🇪', '2025-08-27 12:20:52', NULL, NULL),
(81, 'Germany', '+49', 'DE', '🇩🇪', '2025-08-27 12:20:52', NULL, NULL),
(82, 'Ghana', '+233', 'GH', '🇬🇭', '2025-08-27 12:20:52', NULL, NULL),
(83, 'Gibraltar', '+350', 'GI', '🇬🇮', '2025-08-27 12:20:52', NULL, NULL),
(84, 'Greece', '+30', 'GR', '🇬🇷', '2025-08-27 12:20:52', NULL, NULL),
(85, 'Greenland', '+299', 'GL', '🇬🇱', '2025-08-27 12:20:52', NULL, NULL),
(86, 'Grenada', '+1473', 'GD', '🇬🇩', '2025-08-27 12:20:52', NULL, NULL),
(87, 'Guadeloupe', '+590', 'GP', '🇬🇵', '2025-08-27 12:20:52', NULL, NULL),
(88, 'Guam', '+1671', 'GU', '🇬🇺', '2025-08-27 12:20:52', NULL, NULL),
(89, 'Guatemala', '+502', 'GT', '🇬🇹', '2025-08-27 12:20:52', NULL, NULL),
(90, 'Guernsey', '+44', 'GG', '🇬🇬', '2025-08-27 12:20:52', NULL, NULL),
(91, 'Guinea', '+224', 'GN', '🇬🇳', '2025-08-27 12:20:52', NULL, NULL),
(92, 'Guinea-Bissau', '+245', 'GW', '🇬🇼', '2025-08-27 12:20:52', NULL, NULL),
(93, 'Guyana', '+592', 'GY', '🇬🇾', '2025-08-27 12:20:52', NULL, NULL),
(94, 'Haiti', '+509', 'HT', '🇭🇹', '2025-08-27 12:20:52', NULL, NULL),
(95, 'Heard Island and Mcdonald Islands', '+0', 'HM', '🏳', '2025-08-27 12:20:52', NULL, NULL),
(96, 'Holy See (Vatican City State)', '+379', 'VA', '🇻🇦', '2025-08-27 12:20:52', NULL, NULL),
(97, 'Honduras', '+504', 'HN', '🇭🇳', '2025-08-27 12:20:52', NULL, NULL),
(98, 'Hong Kong', '+852', 'HK', '🇭🇰', '2025-08-27 12:20:52', NULL, NULL),
(99, 'Hungary', '+36', 'HU', '🇭🇺', '2025-08-27 12:20:52', NULL, NULL),
(100, 'Iceland', '+354', 'IS', '🇮🇸', '2025-08-27 12:20:52', NULL, NULL),
(101, 'India', '+91', 'IN', '🇮🇳', '2025-08-27 12:20:52', NULL, NULL),
(102, 'Indonesia', '+62', 'ID', '🇮🇩', '2025-08-27 12:20:52', NULL, NULL),
(103, 'Iran, Islamic Republic of Persian Gulf', '+98', 'IR', '🇮🇷', '2025-08-27 12:20:52', NULL, NULL),
(104, 'Iraq', '+964', 'IQ', '🇮🇶', '2025-08-27 12:20:52', NULL, NULL),
(105, 'Ireland', '+353', 'IE', '🇮🇪', '2025-08-27 12:20:52', NULL, NULL),
(106, 'Isle of Man', '+44', 'IM', '🇮🇲', '2025-08-27 12:20:52', NULL, NULL),
(107, 'Israel', '+972', 'IL', '🇮🇱', '2025-08-27 12:20:52', NULL, NULL),
(108, 'Italy', '+39', 'IT', '🇮🇹', '2025-08-27 12:20:52', NULL, NULL),
(109, 'Jamaica', '+1876', 'JM', '🇯🇲', '2025-08-27 12:20:52', NULL, NULL),
(110, 'Japan', '+81', 'JP', '🇯🇵', '2025-08-27 12:20:52', NULL, NULL),
(111, 'Jersey', '+44', 'JE', '🇯🇪', '2025-08-27 12:20:52', NULL, NULL),
(112, 'Jordan', '+962', 'JO', '🇯🇴', '2025-08-27 12:20:52', NULL, NULL),
(113, 'Kazakhstan', '+7', 'KZ', '🇰🇿', '2025-08-27 12:20:52', NULL, NULL),
(114, 'Kenya', '+254', 'KE', '🇰🇪', '2025-08-27 12:20:52', NULL, NULL),
(115, 'Kiribati', '+686', 'KI', '🇰🇮', '2025-08-27 12:20:52', NULL, NULL),
(116, 'Korea, Democratic People\'s Republic of Korea', '+850', 'KP', '🇰🇵', '2025-08-27 12:20:52', NULL, NULL),
(117, 'Korea, Republic of South Korea', '+82', 'KR', '🇰🇷', '2025-08-27 12:20:52', NULL, NULL),
(118, 'Kosovo', '+383', 'XK', '🇽🇰', '2025-08-27 12:20:52', NULL, NULL),
(119, 'Kuwait', '+965', 'KW', '🇰🇼', '2025-08-27 12:20:52', NULL, NULL),
(120, 'Kyrgyzstan', '+996', 'KG', '🇰🇬', '2025-08-27 12:20:52', NULL, NULL),
(121, 'Laos', '+856', 'LA', '🇱🇦', '2025-08-27 12:20:52', NULL, NULL),
(122, 'Latvia', '+371', 'LV', '🇱🇻', '2025-08-27 12:20:52', NULL, NULL),
(123, 'Lebanon', '+961', 'LB', '🇱🇧', '2025-08-27 12:20:52', NULL, NULL),
(124, 'Lesotho', '+266', 'LS', '🇱🇸', '2025-08-27 12:20:52', NULL, NULL),
(125, 'Liberia', '+231', 'LR', '🇱🇷', '2025-08-27 12:20:52', NULL, NULL),
(126, 'Libyan Arab Jamahiriya', '+218', 'LY', '🇱🇾', '2025-08-27 12:20:52', NULL, NULL),
(127, 'Liechtenstein', '+423', 'LI', '🇱🇮', '2025-08-27 12:20:52', NULL, NULL),
(128, 'Lithuania', '+370', 'LT', '🇱🇹', '2025-08-27 12:20:52', NULL, NULL),
(129, 'Luxembourg', '+352', 'LU', '🇱🇺', '2025-08-27 12:20:52', NULL, NULL),
(130, 'Macao', '+853', 'MO', '🇲🇴', '2025-08-27 12:20:52', NULL, NULL),
(131, 'Macedonia', '+389', 'MK', '🇲🇰', '2025-08-27 12:20:52', NULL, NULL),
(132, 'Madagascar', '+261', 'MG', '🇲🇬', '2025-08-27 12:20:52', NULL, NULL),
(133, 'Malawi', '+265', 'MW', '🇲🇼', '2025-08-27 12:20:52', NULL, NULL),
(134, 'Malaysia', '+60', 'MY', '🇲🇾', '2025-08-27 12:20:52', NULL, NULL),
(135, 'Maldives', '+960', 'MV', '🇲🇻', '2025-08-27 12:20:52', NULL, NULL),
(136, 'Mali', '+223', 'ML', '🇲🇱', '2025-08-27 12:20:52', NULL, NULL),
(137, 'Malta', '+356', 'MT', '🇲🇹', '2025-08-27 12:20:52', NULL, NULL),
(138, 'Marshall Islands', '+692', 'MH', '🇲🇭', '2025-08-27 12:20:52', NULL, NULL),
(139, 'Martinique', '+596', 'MQ', '🇲🇶', '2025-08-27 12:20:52', NULL, NULL),
(140, 'Mauritania', '+222', 'MR', '🇲🇷', '2025-08-27 12:20:52', NULL, NULL),
(141, 'Mauritius', '+230', 'MU', '🇲🇺', '2025-08-27 12:20:52', NULL, NULL),
(142, 'Mayotte', '+262', 'YT', '🇾🇹', '2025-08-27 12:20:52', NULL, NULL),
(143, 'Mexico', '+52', 'MX', '🇲🇽', '2025-08-27 12:20:52', NULL, NULL),
(144, 'Micronesia, Federated States of Micronesia', '+691', 'FM', '🇫🇲', '2025-08-27 12:20:52', NULL, NULL),
(145, 'Moldova', '+373', 'MD', '🇲🇩', '2025-08-27 12:20:52', NULL, NULL),
(146, 'Monaco', '+377', 'MC', '🇲🇨', '2025-08-27 12:20:52', NULL, NULL),
(147, 'Mongolia', '+976', 'MN', '🇲🇳', '2025-08-27 12:20:52', NULL, NULL),
(148, 'Montenegro', '+382', 'ME', '🇲🇪', '2025-08-27 12:20:52', NULL, NULL),
(149, 'Montserrat', '+1664', 'MS', '🇲🇸', '2025-08-27 12:20:52', NULL, NULL),
(150, 'Morocco', '+212', 'MA', '🇲🇦', '2025-08-27 12:20:52', NULL, NULL),
(151, 'Mozambique', '+258', 'MZ', '🇲🇿', '2025-08-27 12:20:52', NULL, NULL),
(152, 'Myanmar', '+95', 'MM', '🇲🇲', '2025-08-27 12:20:52', NULL, NULL),
(153, 'Namibia', '+264', 'NA', '🇳🇦', '2025-08-27 12:20:52', NULL, NULL),
(154, 'Nauru', '+674', 'NR', '🇳🇷', '2025-08-27 12:20:52', NULL, NULL),
(155, 'Nepal', '+977', 'NP', '🇳🇵', '2025-08-27 12:20:52', NULL, NULL),
(156, 'Netherlands', '+31', 'NL', '🇳🇱', '2025-08-27 12:20:52', NULL, NULL),
(157, 'Netherlands Antilles', '+599', 'AN', '🇳🇱', '2025-08-27 12:20:52', NULL, NULL),
(158, 'New Caledonia', '+687', 'NC', '🇳🇨', '2025-08-27 12:20:52', NULL, NULL),
(159, 'New Zealand', '+64', 'NZ', '🇳🇿', '2025-08-27 12:20:52', NULL, NULL),
(160, 'Nicaragua', '+505', 'NI', '🇳🇮', '2025-08-27 12:20:52', NULL, NULL),
(161, 'Niger', '+227', 'NE', '🇳🇪', '2025-08-27 12:20:52', NULL, NULL),
(162, 'Nigeria', '+234', 'NG', '🇳🇬', '2025-08-27 12:20:52', NULL, NULL),
(163, 'Niue', '+683', 'NU', '🇳🇺', '2025-08-27 12:20:52', NULL, NULL),
(164, 'Norfolk Island', '+672', 'NF', '🇳🇫', '2025-08-27 12:20:52', NULL, NULL),
(165, 'Northern Mariana Islands', '+1670', 'MP', '🏳', '2025-08-27 12:20:52', NULL, NULL),
(166, 'Norway', '+47', 'NO', '🇳🇴', '2025-08-27 12:20:52', NULL, NULL),
(167, 'Oman', '+968', 'OM', '🇴🇲', '2025-08-27 12:20:52', NULL, NULL),
(168, 'Pakistan', '+92', 'PK', '🇵🇰', '2025-08-27 12:20:52', NULL, NULL),
(169, 'Palau', '+680', 'PW', '🇵🇼', '2025-08-27 12:20:52', NULL, NULL),
(170, 'Palestinian Territory, Occupied', '+970', 'PS', '🇵🇸', '2025-08-27 12:20:52', NULL, NULL),
(171, 'Panama', '+507', 'PA', '🇵🇦', '2025-08-27 12:20:52', NULL, NULL),
(172, 'Papua New Guinea', '+675', 'PG', '🇵🇬', '2025-08-27 12:20:52', NULL, NULL),
(173, 'Paraguay', '+595', 'PY', '🇵🇾', '2025-08-27 12:20:52', NULL, NULL),
(174, 'Peru', '+51', 'PE', '🇵🇪', '2025-08-27 12:20:52', NULL, NULL),
(175, 'Philippines', '+63', 'PH', '🇵🇭', '2025-08-27 12:20:52', NULL, NULL),
(176, 'Pitcairn', '+64', 'PN', '🇵🇳', '2025-08-27 12:20:52', NULL, NULL),
(177, 'Poland', '+48', 'PL', '🇵🇱', '2025-08-27 12:20:52', NULL, NULL),
(178, 'Portugal', '+351', 'PT', '🇵🇹', '2025-08-27 12:20:52', NULL, NULL),
(179, 'Puerto Rico', '+1939', 'PR', '🇵🇷', '2025-08-27 12:20:52', NULL, NULL),
(180, 'Qatar', '+974', 'QA', '🇶🇦', '2025-08-27 12:20:52', NULL, NULL),
(181, 'Romania', '+40', 'RO', '🇷🇴', '2025-08-27 12:20:52', NULL, NULL),
(182, 'Russia', '+7', 'RU', '🇷🇺', '2025-08-27 12:20:52', NULL, NULL),
(183, 'Rwanda', '+250', 'RW', '🇷🇼', '2025-08-27 12:20:52', NULL, NULL),
(184, 'Reunion', '+262', 'RE', '🇫🇷', '2025-08-27 12:20:52', NULL, NULL),
(185, 'Saint Barthelemy', '+590', 'BL', '🇧🇱', '2025-08-27 12:20:52', NULL, NULL),
(186, 'Saint Helena, Ascension and Tristan Da Cunha', '+290', 'SH', '🇸🇭', '2025-08-27 12:20:52', NULL, NULL),
(187, 'Saint Kitts and Nevis', '+1869', 'KN', '🇰🇳', '2025-08-27 12:20:52', NULL, NULL),
(188, 'Saint Lucia', '+1758', 'LC', '🇱🇨', '2025-08-27 12:20:52', NULL, NULL),
(189, 'Saint Martin', '+590', 'MF', '🏳', '2025-08-27 12:20:52', NULL, NULL),
(190, 'Saint Pierre and Miquelon', '+508', 'PM', '🇵🇲', '2025-08-27 12:20:52', NULL, NULL),
(191, 'Saint Vincent and the Grenadines', '+1784', 'VC', '🇻🇨', '2025-08-27 12:20:52', NULL, NULL),
(192, 'Samoa', '+685', 'WS', '🇼🇸', '2025-08-27 12:20:52', NULL, NULL),
(193, 'San Marino', '+378', 'SM', '🇸🇲', '2025-08-27 12:20:52', NULL, NULL),
(194, 'Sao Tome and Principe', '+239', 'ST', '🇸🇹', '2025-08-27 12:20:52', NULL, NULL),
(195, 'Saudi Arabia', '+966', 'SA', '🇸🇦', '2025-08-27 12:20:52', NULL, NULL),
(196, 'Senegal', '+221', 'SN', '🇸🇳', '2025-08-27 12:20:52', NULL, NULL),
(197, 'Serbia', '+381', 'RS', '🇷🇸', '2025-08-27 12:20:52', NULL, NULL),
(198, 'Seychelles', '+248', 'SC', '🇸🇨', '2025-08-27 12:20:52', NULL, NULL),
(199, 'Sierra Leone', '+232', 'SL', '🇸🇱', '2025-08-27 12:20:52', NULL, NULL),
(200, 'Singapore', '+65', 'SG', '🇸🇬', '2025-08-27 12:20:52', NULL, NULL),
(201, 'Slovakia', '+421', 'SK', '🇸🇰', '2025-08-27 12:20:52', NULL, NULL),
(202, 'Slovenia', '+386', 'SI', '🇸🇮', '2025-08-27 12:20:52', NULL, NULL),
(203, 'Solomon Islands', '+677', 'SB', '🇸🇧', '2025-08-27 12:20:52', NULL, NULL),
(204, 'Somalia', '+252', 'SO', '🇸🇴', '2025-08-27 12:20:52', NULL, NULL),
(205, 'South Africa', '+27', 'ZA', '🇿🇦', '2025-08-27 12:20:52', NULL, NULL),
(206, 'South Sudan', '+211', 'SS', '🇸🇸', '2025-08-27 12:20:52', NULL, NULL),
(207, 'South Georgia and the South Sandwich Islands', '+500', 'GS', '🇬🇸', '2025-08-27 12:20:52', NULL, NULL),
(208, 'Spain', '+34', 'ES', '🇪🇸', '2025-08-27 12:20:52', NULL, NULL),
(209, 'Sri Lanka', '+94', 'LK', '🇱🇰', '2025-08-27 12:20:52', NULL, NULL),
(210, 'Sudan', '+249', 'SD', '🇸🇩', '2025-08-27 12:20:52', NULL, NULL),
(211, 'Suriname', '+597', 'SR', '🇸🇷', '2025-08-27 12:20:52', NULL, NULL),
(212, 'Svalbard and Jan Mayen', '+47', 'SJ', '🇩🇰', '2025-08-27 12:20:52', NULL, NULL),
(213, 'Swaziland', '+268', 'SZ', '🇸🇿', '2025-08-27 12:20:52', NULL, NULL),
(214, 'Sweden', '+46', 'SE', '🇸🇪', '2025-08-27 12:20:52', NULL, NULL),
(215, 'Switzerland', '+41', 'CH', '🇨🇭', '2025-08-27 12:20:52', NULL, NULL),
(216, 'Syrian Arab Republic', '+963', 'SY', '🇸🇾', '2025-08-27 12:20:52', NULL, NULL),
(217, 'Taiwan', '+886', 'TW', '🇹🇼', '2025-08-27 12:20:52', NULL, NULL),
(218, 'Tajikistan', '+992', 'TJ', '🇹🇯', '2025-08-27 12:20:52', NULL, NULL),
(219, 'Tanzania, United Republic of Tanzania', '+255', 'TZ', '🇹🇿', '2025-08-27 12:20:52', NULL, NULL),
(220, 'Thailand', '+66', 'TH', '🇹🇭', '2025-08-27 12:20:52', NULL, NULL),
(221, 'Timor-Leste', '+670', 'TL', '🇹🇱', '2025-08-27 12:20:52', NULL, NULL),
(222, 'Togo', '+228', 'TG', '🇹🇬', '2025-08-27 12:20:52', NULL, NULL),
(223, 'Tokelau', '+690', 'TK', '🇹🇰', '2025-08-27 12:20:52', NULL, NULL),
(224, 'Tonga', '+676', 'TO', '🇹🇴', '2025-08-27 12:20:52', NULL, NULL),
(225, 'Trinidad and Tobago', '+1868', 'TT', '🇹🇹', '2025-08-27 12:20:52', NULL, NULL),
(226, 'Tunisia', '+216', 'TN', '🇹🇳', '2025-08-27 12:20:52', NULL, NULL),
(227, 'Turkey', '+90', 'TR', '🇹🇷', '2025-08-27 12:20:52', NULL, NULL),
(228, 'Turkmenistan', '+993', 'TM', '🇹🇲', '2025-08-27 12:20:52', NULL, NULL),
(229, 'Turks and Caicos Islands', '+1649', 'TC', '🇹🇨', '2025-08-27 12:20:52', NULL, NULL),
(230, 'Tuvalu', '+688', 'TV', '🇹🇻', '2025-08-27 12:20:52', NULL, NULL),
(231, 'Uganda', '+256', 'UG', '🇺🇬', '2025-08-27 12:20:52', NULL, NULL),
(232, 'Ukraine', '+380', 'UA', '🇺🇦', '2025-08-27 12:20:52', NULL, NULL),
(233, 'United Arab Emirates', '+971', 'AE', '🇦🇪', '2025-08-27 12:20:52', NULL, NULL),
(234, 'United Kingdom', '+44', 'GB', '🇬🇧', '2025-08-27 12:20:52', NULL, NULL),
(235, 'United States', '+1', 'US', '🇺🇸', '2025-08-27 12:20:52', NULL, NULL),
(236, 'Uruguay', '+598', 'UY', '🇺🇾', '2025-08-27 12:20:52', NULL, NULL),
(237, 'Uzbekistan', '+998', 'UZ', '🇺🇿', '2025-08-27 12:20:52', NULL, NULL),
(238, 'Vanuatu', '+678', 'VU', '🇻🇺', '2025-08-27 12:20:52', NULL, NULL),
(239, 'Venezuela, Bolivarian Republic of Venezuela', '+58', 'VE', '🇻🇪', '2025-08-27 12:20:52', NULL, NULL),
(240, 'Vietnam', '+84', 'VN', '🇻🇳', '2025-08-27 12:20:52', NULL, NULL),
(241, 'Virgin Islands, British', '+1284', 'VG', '🇻🇬', '2025-08-27 12:20:52', NULL, NULL),
(242, 'Virgin Islands, U.S.', '+1340', 'VI', '🇻🇮', '2025-08-27 12:20:52', NULL, NULL),
(243, 'Wallis and Futuna', '+681', 'WF', '🇼🇫', '2025-08-27 12:20:52', NULL, NULL),
(244, 'Yemen', '+967', 'YE', '🇾🇪', '2025-08-27 12:20:52', NULL, NULL),
(245, 'Zambia', '+260', 'ZM', '🇿🇲', '2025-08-27 12:20:52', NULL, NULL),
(246, 'Zimbabwe', '+263', 'ZW', '🇿🇼', '2025-08-27 12:20:52', NULL, NULL);

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `discount_type` varchar(255) NOT NULL COMMENT '1= fixed, 2=percentage',
  `amount` decimal(10,2) DEFAULT NULL,
  `usage_limit` int(11) DEFAULT NULL,
  `usage_count` int(11) DEFAULT NULL,
  `expiry_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` bigint(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupon`
--

INSERT INTO `coupon` (`id`, `code`, `description`, `discount_type`, `amount`, `usage_limit`, `usage_count`, `expiry_date`, `is_active`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`) VALUES
(2, 'Dolorum eos sed eni', 'Delectus consequatu', 'Ad officia elit bla', 50.00, 70, 56, '2005-12-11 17:01:00', 1, '2025-08-23 09:38:07', 2, '2025-08-23 15:38:07', NULL, NULL),
(3, 'Ipsum aliqua Fuga', 'Sed in quaerat non e', 'Error qui esse autem', 52.00, 87, 41, '2025-08-27 07:18:06', 1, '2025-08-23 09:44:46', 2, '2025-08-27 13:18:06', NULL, NULL),
(5, 'Et culpa ut voluptat', 'Aliqua Rem soluta c', '0', 95.00, 42, 89, '2025-08-27 07:15:35', 0, '2025-08-23 09:48:06', 2, '2025-08-27 13:15:35', NULL, NULL),
(6, 'Excepteur non repreh', 'Doloremque deserunt', '0', 94.00, 79, 5, '2025-08-27 07:17:56', 1, '2025-08-23 10:16:32', 2, '2025-08-27 13:17:56', NULL, NULL),
(7, 'Quidem incididunt re', 'Tempora eum qui eum', '1', 49.00, 97, 18, '2025-08-27 07:23:15', 1, '2025-08-23 10:16:49', 2, '2025-08-27 13:23:15', NULL, NULL);

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

--
-- Table structure for table `customer_details`
--

CREATE TABLE `customer_details` (
  `id` bigint(20) NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `emergency_name` varchar(150) DEFAULT NULL,
  `emergency_relation` varchar(100) DEFAULT NULL,
  `emergency_phone` varchar(20) DEFAULT NULL,
  `emergency_email` varchar(150) DEFAULT NULL,
  `preferred_language` varchar(50) DEFAULT NULL,
  `dietary_restrictions` varchar(50) DEFAULT NULL,
  `special_requests` text DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `area_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `designation` varchar(150) DEFAULT NULL,
  `email_notifications` tinyint(1) DEFAULT 1,
  `marketing_updates` tinyint(1) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_details`
--

INSERT INTO `customer_details` (`id`, `customer_id`, `address`, `date_of_birth`, `nationality`, `emergency_name`, `emergency_relation`, `emergency_phone`, `emergency_email`, `preferred_language`, `dietary_restrictions`, `special_requests`, `country_id`, `city_id`, `area_id`, `description`, `designation`, `email_notifications`, `marketing_updates`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, 'English', NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, '2025-08-27 18:20:51', '2025-08-27 18:20:51', NULL);

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

--
-- Table structure for table `custom_package_requests`
--

CREATE TABLE `custom_package_requests` (
  `id` int(11) NOT NULL,
  `package_id` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL COMMENT 'Customer who made the custom package request',
  `travel_date` date DEFAULT NULL COMMENT 'Intended travel start date',
  `tour_type_id` int(11) DEFAULT NULL,
  `travel_point_id` int(11) DEFAULT NULL,
  `number_of_adults` int(11) DEFAULT 1 COMMENT 'Total adults in the booking',
  `number_of_kids` int(11) DEFAULT 0 COMMENT 'Total kids in the booking',
  `total_persons` int(11) DEFAULT NULL COMMENT 'Calculated total of all persons',
  `description` text DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL COMMENT 'Original price per unit before any discount',
  `discount_type` tinyint(2) DEFAULT NULL COMMENT 'Discount type: 1 = percentage, 2 = fixed amount',
  `discount` decimal(5,2) DEFAULT NULL COMMENT 'Discount value: percent or fixed based on discount_type',
  `discount_price` decimal(10,2) DEFAULT NULL COMMENT 'Calculated discount amount to subtract from unit_price',
  `sale_price` decimal(10,2) DEFAULT NULL COMMENT 'Final price after discount (unit_price - discount_price)',
  `notes` text DEFAULT NULL COMMENT 'Additional instructions or notes from user/admin',
  `approval_status` tinyint(4) DEFAULT 0 COMMENT '0=Pending, 1=Approved, 2=Cancelled — Admin approval status. When approve then set a price and create booking.',
  `is_active` tinyint(1) DEFAULT 1 COMMENT '0=Inactive, 1=Active — Soft active/inactive flag',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'Admin or user who created the booking',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_package_requests`
--

INSERT INTO `custom_package_requests` (`id`, `package_id`, `customer_id`, `travel_date`, `tour_type_id`, `travel_point_id`, `number_of_adults`, `number_of_kids`, `total_persons`, `description`, `unit_price`, `discount_type`, `discount`, `discount_price`, `sale_price`, `notes`, `approval_status`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, '1980-08-05', 5, 4, 417, 316, 66, 'Voluptatem nulla eum', 401.00, 0, 2.00, 761.00, 828.00, 'Eiusmod et laboris e', 0, 1, 2, NULL, '2025-08-23 11:00:51', '2025-08-23 17:00:51', NULL),
(2, NULL, 1, '1972-08-19', 3, 4, 797, 855, 39, 'Odit neque quaerat e', 312.00, 0, 66.00, 308.00, 222.00, 'Sequi tempora aut qu', 1, 1, 2, NULL, '2025-08-23 11:00:57', '2025-08-23 17:00:57', NULL),
(3, NULL, 1, '1998-01-08', 5, 4, 478, 104, 71, 'Ut quo voluptatum in', 224.00, 1, 24.00, 838.00, 820.00, 'Reprehenderit dolore', 0, 0, 2, NULL, '2025-08-23 11:07:01', '2025-08-27 22:17:07', NULL),
(4, NULL, 1, '2006-10-29', 3, 4, 153, 813, 42, 'Beatae ex dolores ap', 512.00, 0, 40.00, 267.00, 443.00, 'Autem fugiat sit ex', 0, 1, 2, NULL, '2025-08-27 10:07:18', '2025-08-28 08:22:34', NULL),
(5, NULL, 1, '1976-09-29', 2, 4, 256, 134, 12, 'Iusto vel temporibus', 665.00, 0, 16.00, 309.00, 747.00, 'Labore et ducimus q', 1, 1, 2, NULL, '2025-08-28 01:37:29', '2025-08-28 08:13:15', NULL);

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

--
-- Table structure for table `deals`
--

CREATE TABLE `deals` (
  `id` int(11) NOT NULL,
  `custom_package_requests_id` int(11) DEFAULT NULL,
  `service_requests_id` int(11) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL COMMENT 'User initiating the deal (usually admin)',
  `customer_id` bigint(20) DEFAULT NULL COMMENT 'Customer receiving the deal (usually customer)',
  `proposed_price` decimal(10,2) DEFAULT NULL COMMENT 'Proposed price amount',
  `proposed_by_id` bigint(20) DEFAULT NULL COMMENT 'ID of the entity proposing this price',
  `proposed_by_type` varchar(50) DEFAULT NULL COMMENT 'Entity type: user or customer',
  `message` text DEFAULT NULL COMMENT 'Optional message with the proposed price',
  `is_final` tinyint(1) DEFAULT 0 COMMENT 'Marks whether this is the agreed final deal',
  `final_approved_price` decimal(10,2) DEFAULT NULL COMMENT 'Final agreed amount after negotiation',
  `approval_status` tinyint(4) DEFAULT 0 COMMENT '0 = Pending, 1 = Approved, 2 = Rejected',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'User who created this deal record',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Laboriosam incidunt', 'Dolores consectetur', '2025-08-23 07:20:15', '2025-08-23 13:20:15', NULL),
(2, 'Nostrum qui in volup', 'Iusto nihil aut cumq', '2025-08-23 07:20:19', '2025-08-23 13:20:19', NULL),
(3, 'Minima praesentium q', 'Quo et nihil obcaeca', '2025-08-23 07:20:22', '2025-08-23 13:20:22', NULL);

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

--
-- Table structure for table `feedback_logs`
--

CREATE TABLE `feedback_logs` (
  `id` int(11) NOT NULL,
  `tour_package_id` int(11) DEFAULT NULL,
  `custom_package_requests_id` int(11) DEFAULT NULL COMMENT 'Custom user-requested activity if applicable',
  `service_package_requests_id` int(11) DEFAULT NULL COMMENT 'Service user-requested activity if applicable',
  `logs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`logs`)),
  `is_unlocked_tour_calender` tinyint(1) DEFAULT 1,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `feedback_logs`
--

INSERT INTO `feedback_logs` (`id`, `tour_package_id`, `custom_package_requests_id`, `service_package_requests_id`, `logs`, `is_unlocked_tour_calender`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 26, NULL, NULL, '{\"day_1\":[\"Dolore fuga Non del\"],\"day_2\":[\"Deleniti assumenda i\",\"Tempora numquam aliq\",\"Laboris voluptatem\"],\"day_3\":[\"Aut in eiusmod ut co\",\"Ducimus nulla aliqu\",\"Nulla explicabo Quo\"]}', 0, 2, NULL, '2025-08-24 09:59:19', '2025-08-24 15:59:19', NULL),
(2, 27, NULL, NULL, '{\"day_1\":[\"Officia pariatur Vo\",\"Illum ea ipsum nece\"],\"day_2\":[\"Fugit veritatis sun\",\"In iusto eos sunt id\"],\"day_3\":[\"Ad quas aut elit at\",\"Non praesentium quia\"]}', 0, 2, NULL, '2025-08-24 10:00:29', '2025-08-24 16:00:29', NULL),
(3, 28, NULL, NULL, '{\"day_2\":[\"Ea deserunt expedita\",\"Ipsum rerum fugiat d\",\"Similique unde repre\"],\"day_3\":[\"Porro eius dolore ea\",\"Vel dolores magna be\"]}', 0, 2, NULL, '2025-08-24 10:05:08', '2025-08-24 16:05:08', NULL),
(4, 29, NULL, NULL, '{\"day_1\":[\"Quaerat rerum tempor\"],\"day_2\":[\"Ipsum non blanditii\",\"Et ut qui minima ea\"],\"day_3\":[\"Ea incididunt volupt\",\"Irure sunt cupidatat\"]}', 0, 2, NULL, '2025-08-24 10:06:16', '2025-08-24 16:06:16', NULL),
(9, 34, NULL, NULL, '{\"day_1\":[\"Dignissimos fugiat\",\"Expedita possimus d\",\"Ex labore et consequ\"],\"day_2\":[\"Nulla quod est quod\"],\"day_3\":[\"Tempor dolore qui vo\",\"Quam reiciendis vel\"]}', 0, 2, NULL, '2025-08-24 10:38:11', '2025-08-24 16:38:11', NULL),
(10, 35, NULL, NULL, '{\"day_1\":[\"Sit iure ut reicien\",\"Dolorem ipsam sint e\"],\"day_2\":[\"Reprehenderit ration\"]}', 0, 2, NULL, '2025-08-24 10:38:48', '2025-08-24 16:38:48', NULL),
(11, 36, NULL, NULL, '{\"day_1\":[\"Voluptas ipsum ex do\",\"Maxime sed non hic c\"],\"day_3\":[\"Ipsum cillum quidem\",\"Cillum delectus nul\"]}', 0, 2, NULL, '2025-08-24 10:41:30', '2025-08-24 16:41:30', NULL),
(12, 37, NULL, NULL, '{\"day_1\":[\"Iure dolor modi nost\",\"Fuga Cum duis dolor\"],\"day_2\":[\"Deserunt tempora lib\",\"Alias assumenda vel\",\"Omnis laborum Minus\"],\"day_3\":[\"Id omnis qui proiden\"]}', 0, 2, NULL, '2025-08-24 10:43:15', '2025-08-24 16:43:15', NULL),
(13, 38, NULL, NULL, '{\"day_1\":[\"Eius vero dicta null\",\"Quisquam voluptatem\"],\"day_2\":[\"Molestiae aliquip qu\",\"Labore aut dolorem q\"],\"day_3\":[\"Perspiciatis qui te\",\"Optio excepteur fac\"]}', 0, 2, NULL, '2025-08-24 10:48:45', '2025-08-24 16:48:45', NULL),
(14, 39, NULL, NULL, '{\"day_1\":[\"Deserunt cumque unde\"],\"day_2\":[\"Est voluptatem tempo\"],\"day_3\":[\"Labore commodi unde\",\"Dolore quo reiciendi\",\"Nam elit laborum pe\"]}', 0, 2, NULL, '2025-08-24 10:53:00', '2025-08-24 16:53:00', NULL),
(15, 40, NULL, NULL, '{\"day_1\":[\"Ratione cum libero u\",\"In et in ipsum quae\"],\"day_2\":[\"Rem neque unde id t\"],\"day_3\":[\"Ut reprehenderit ver\"]}', 0, 2, NULL, '2025-08-24 11:17:59', '2025-08-24 17:17:59', NULL),
(16, 41, NULL, NULL, '{\"day_1\":[\"Itaque itaque sed de\",\"Vel dolores est repr\"],\"day_2\":[\"Non modi labore sint\"],\"day_3\":[\"Dolor consequuntur o\"]}', 0, 2, NULL, '2025-08-24 11:19:11', '2025-08-24 17:19:11', NULL),
(17, 42, NULL, NULL, '{\"day_1\":[\"Quibusdam duis quia\",\"Quia fugiat sequi of\"]}', 0, 2, NULL, '2025-08-24 11:23:41', '2025-08-24 17:23:41', NULL),
(18, 43, NULL, NULL, '[]', 0, 2, NULL, '2025-08-24 11:39:40', '2025-08-24 17:39:40', NULL),
(19, 24, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 08:21:38', '2025-08-26 14:21:38', NULL),
(20, 44, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 09:54:54', '2025-08-26 15:54:54', NULL),
(21, 45, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:00:54', '2025-08-26 16:00:54', NULL),
(22, 46, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:06:03', '2025-08-26 16:06:03', NULL),
(23, 47, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:10:17', '2025-08-26 16:10:17', NULL),
(24, 48, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:10:39', '2025-08-26 16:10:39', NULL),
(25, 49, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:15:39', '2025-08-26 16:15:39', NULL),
(26, 50, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:37:53', '2025-08-26 16:37:53', NULL),
(27, 51, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:51:33', '2025-08-26 16:51:33', NULL),
(28, 52, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:52:42', '2025-08-26 16:52:42', NULL),
(29, 53, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:54:14', '2025-08-26 16:54:14', NULL),
(30, 54, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:55:14', '2025-08-26 16:55:14', NULL),
(31, 55, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 10:56:28', '2025-08-26 16:56:28', NULL),
(32, 56, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:04:40', '2025-08-26 17:04:40', NULL),
(33, 57, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:13:02', '2025-08-26 17:13:02', NULL),
(36, 60, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:17:49', '2025-08-26 17:17:49', NULL),
(38, 62, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:29:15', '2025-08-26 17:29:15', NULL),
(39, 63, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:40:40', '2025-08-26 17:40:40', NULL),
(40, 64, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 11:47:19', '2025-08-26 17:47:19', NULL),
(41, 63, NULL, NULL, '[]', 0, 2, NULL, '2025-08-26 12:07:37', '2025-08-26 18:07:37', NULL),
(42, 65, NULL, NULL, '[]', 0, 2, NULL, '2025-08-27 08:01:41', '2025-08-27 14:01:41', NULL),
(43, 65, NULL, NULL, '[]', 0, 2, NULL, '2025-08-27 10:05:04', '2025-08-27 16:05:04', NULL),
(44, 66, NULL, NULL, '[]', 0, 2, NULL, '2025-08-27 10:06:14', '2025-08-27 16:06:14', NULL);

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

--
-- Table structure for table `guiding_methods`
--

CREATE TABLE `guiding_methods` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) NOT NULL,
  `queue` varchar(255) DEFAULT NULL COMMENT 'Queue name',
  `payload` longtext DEFAULT NULL,
  `attempts` tinyint(4) DEFAULT NULL COMMENT 'Number of attempts',
  `reserved_at` int(11) DEFAULT NULL COMMENT 'When job was reserved',
  `available_at` int(11) DEFAULT NULL COMMENT 'When job is available',
  `created_at` int(11) DEFAULT NULL COMMENT 'When job was created'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL COMMENT 'Primary key, string ID',
  `name` varchar(255) DEFAULT NULL,
  `total_jobs` int(11) DEFAULT NULL,
  `pending_jobs` int(11) DEFAULT NULL,
  `failed_jobs` int(11) DEFAULT NULL,
  `failed_job_ids` longtext DEFAULT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `landing_banners`
--

CREATE TABLE `landing_banners` (
  `id` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL COMMENT 'Main heading/title for the banner',
  `subtitle` varchar(255) DEFAULT NULL COMMENT 'Secondary heading or tagline',
  `description` text DEFAULT NULL COMMENT 'Detailed description for the banner content',
  `image` varchar(255) DEFAULT NULL COMMENT 'Path or URL to the banner image',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Optional link if banner is clickable',
  `is_active` tinyint(1) DEFAULT 1 COMMENT '0=Inactive, 1=Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `iso_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meal`
--

CREATE TABLE `meal` (
  `id` int(11) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `quantity_per_person` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- 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;

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) DEFAULT NULL,
  `model_type` varchar(255) DEFAULT NULL,
  `model_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Composite PK (permission_id, model_type, model_id)';

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) DEFAULT NULL,
  `model_type` varchar(255) DEFAULT NULL,
  `model_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Composite PK (role_id, model_type, model_id)';

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(3, 'App\\Models\\User', 3),
(1, 'App\\Models\\User', 11),
(2, 'App\\Models\\User', 12),
(3, 'App\\Models\\User', 13),
(3, 'App\\Models\\User', 14),
(3, 'App\\Models\\User', 15),
(1, 'App\\Models\\User', 16),
(1, 'App\\Models\\User', 17),
(1, 'App\\Models\\User', 18),
(3, 'App\\Models\\User', 19),
(1, NULL, 20),
(3, NULL, 21),
(2, NULL, 22),
(2, NULL, 23),
(3, NULL, 24),
(1, NULL, 25),
(3, NULL, 4);

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `trans_type_id` int(11) DEFAULT NULL,
  `trans_no` varchar(200) DEFAULT NULL COMMENT 'Unique transaction identifier for this payment',
  `transaction_id` varchar(100) DEFAULT NULL COMMENT 'Gateway transaction ID, if available',
  `payment_methods_id` int(11) DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL COMMENT 'Date and time when the payment was made',
  `op_amount` decimal(10,2) DEFAULT NULL,
  `total_payable_amount` decimal(10,2) DEFAULT NULL COMMENT 'Total cost before any payment and discounts',
  `total_discount_amount` decimal(10,2) DEFAULT NULL COMMENT 'Total discount applied to the booking',
  `total_due_amount` decimal(10,2) DEFAULT NULL COMMENT 'Remaining amount to be paid (total - discount - paid)',
  `total_paid_amount` decimal(10,2) DEFAULT 0.00 COMMENT 'Total amount paid so far',
  `paid_amount` decimal(10,2) NOT NULL,
  `cls_amount` decimal(10,2) DEFAULT NULL,
  `notes` text DEFAULT NULL COMMENT 'Additional notes or gateway response information',
  `payment_status` tinyint(4) DEFAULT 0 COMMENT '0=Unpaid, 1=Paid, 2=Due, 3=Refunded - Payment processing status',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'User or admin who created this payment record',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `payments` (`id`, `customer_id`, `booking_id`, `trans_type_id`, `trans_no`, `transaction_id`, `payment_methods_id`, `payment_date`, `op_amount`, `total_payable_amount`, `total_discount_amount`, `total_due_amount`, `total_paid_amount`, `paid_amount`, `cls_amount`, `notes`, `payment_status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(50, 1, 10, NULL, '#P0000001', NULL, NULL, '2025-08-26 14:16:07', NULL, NULL, 351.00, 0.00, NULL, 0.00, 0.00, 'Rem ratione deserunt', 0, 2, 2, '2025-08-26 08:16:07', '2025-08-26 14:16:07', NULL),
(51, 1, 11, NULL, '#P0000002', NULL, NULL, '2025-08-26 14:25:27', NULL, NULL, 681.00, 0.00, NULL, 0.00, 0.00, 'Quia ea autem molest', 0, 2, 2, '2025-08-26 08:25:27', '2025-08-26 14:25:27', NULL),
(52, 1, 12, NULL, '#P0000003', NULL, NULL, '2025-08-26 14:28:48', 32323.00, 32323.00, 131.00, 32323.00, NULL, 0.00, 32323.00, 'Corrupti dolor repr', 0, 2, 2, '2025-08-26 08:28:48', '2025-08-26 14:28:48', NULL),
(53, 1, 13, NULL, '#P0000004', NULL, NULL, '2025-08-26 14:32:29', 32323.00, 32323.00, 172.00, 32323.00, NULL, 0.00, 32323.00, 'Commodi suscipit sol', 0, 2, 2, '2025-08-26 08:32:29', '2025-08-26 14:32:29', NULL),
(54, 1, 14, NULL, '#P0000005', NULL, NULL, '2025-08-26 14:33:52', 3232.00, 3232.00, 233.00, 3232.00, NULL, 0.00, 3232.00, 'Eiusmod est laboris', 0, 2, 2, '2025-08-26 08:33:52', '2025-08-26 14:33:52', NULL),
(55, 1, 18, NULL, '#P0000006', NULL, NULL, '2025-08-26 14:37:29', 32232.00, 32232.00, 691.00, 32151.00, 81.00, 0.00, 32151.00, 'Qui id ipsam id volu', 2, 2, 2, '2025-08-26 08:37:29', '2025-08-26 14:37:29', NULL),
(56, 1, 19, NULL, '#P0000007', NULL, NULL, '2025-08-26 14:47:10', 3232.00, 3232.00, 238.00, 3160.00, 72.00, 0.00, 3160.00, 'Nulla corrupti blan', 2, 2, 2, '2025-08-26 08:47:10', '2025-08-26 14:47:10', NULL),
(57, 1, 20, NULL, '#P0000008', NULL, NULL, '2025-08-26 14:47:46', 32232.00, 32232.00, 700.00, 32135.00, 97.00, 0.00, 32135.00, 'Voluptate voluptatum', 2, 2, 2, '2025-08-26 08:47:46', '2025-08-26 14:47:46', NULL),
(58, 1, 21, NULL, '#P0000009', NULL, NULL, '2025-08-26 14:50:31', 32323.00, 32323.00, 88.00, 32267.00, 56.00, 0.00, 32267.00, 'Ullamco non molestia', 2, 2, 2, '2025-08-26 08:50:31', '2025-08-26 14:50:31', NULL),
(59, 1, 22, NULL, '#P0000010', NULL, NULL, '2025-08-26 15:42:07', 32232.00, 32232.00, 759.00, 32158.00, 74.00, 0.00, 32158.00, 'Voluptatem velit par', 2, 2, 2, '2025-08-26 09:42:07', '2025-08-26 15:42:07', NULL),
(60, 1, 23, NULL, '#P0000011', NULL, NULL, '2025-08-26 15:48:45', 32232.00, 32232.00, 685.00, 32158.00, 74.00, 0.00, 32158.00, 'Illo elit ipsum rep', 2, 2, 2, '2025-08-26 09:48:45', '2025-08-26 15:48:45', NULL),
(61, 1, 23, NULL, '#P0000012', NULL, 2, '2025-08-26 15:56:08', 32158.00, 32232.00, 685.00, 32135.00, 97.00, 0.00, 32135.00, '323232', 2, 2, 2, '2025-08-26 09:56:08', '2025-08-26 15:56:08', NULL),
(62, 1, 11, NULL, '#P0000013', NULL, 3, '2025-08-26 15:58:06', 0.00, NULL, 681.00, -70.00, 70.00, 0.00, -70.00, 'Et non aliquip dolor', 1, 2, 2, '2025-08-26 09:58:06', '2025-08-26 15:58:06', NULL),
(63, 1, 24, NULL, '#P0000014', NULL, NULL, '2025-08-27 14:00:02', 161.00, 161.00, 259.00, 83.00, 78.00, 0.00, 83.00, NULL, 2, 2, 2, '2025-08-27 08:00:02', '2025-08-27 14:00:02', NULL),
(64, 1, 25, NULL, '#P0000015', NULL, NULL, '2025-08-27 14:00:14', -318.00, -318.00, 932.00, -371.00, 53.00, 0.00, -371.00, 'Sint ut sed dicta i', 1, 2, 2, '2025-08-27 08:00:14', '2025-08-27 14:00:14', NULL),
(65, 1, 26, NULL, '#P0000016', NULL, NULL, '2025-08-27 14:02:28', 1500.00, 1500.00, 500.00, 1300.00, 200.00, 0.00, 1300.00, NULL, 2, 2, 2, '2025-08-27 08:02:28', '2025-08-27 14:02:28', NULL),
(66, 1, 27, NULL, '#P0000017', NULL, 1, '2025-08-27 14:19:15', 1500.00, 1500.00, 544.00, 1200.00, 300.00, 0.00, 1200.00, 'Quis Nam fugit quae', 2, 2, 2, '2025-08-27 08:19:15', '2025-08-27 14:19:15', NULL),
(67, 1, 28, NULL, '#P0000018', NULL, 1, '2025-08-27 14:31:54', 1500.00, 1500.00, 531.00, 1300.00, 200.00, 0.00, 1300.00, 'Distinctio Illum d', 2, 2, 2, '2025-08-27 08:31:54', '2025-08-27 14:31:54', NULL),
(68, 1, 28, NULL, '#P0000019', NULL, 2, '2025-08-27 15:21:18', 1300.00, 1500.00, 531.00, 1078.00, 422.00, 0.00, 1078.00, 'Aut eum voluptatem', 1, 2, 2, '2025-08-27 09:21:18', '2025-08-27 15:21:18', NULL),
(69, 1, 28, NULL, '#P0000020', NULL, 1, '2025-08-27 15:21:47', 1078.00, 1500.00, 562.00, 1100.00, 400.00, 0.00, 1100.00, '22212', 3, 2, 2, '2025-08-27 09:21:47', '2025-08-27 15:21:47', NULL),
(70, 1, 28, NULL, '#P0000021', NULL, 4, '2025-08-27 15:27:28', 1100.00, 1500.00, 593.00, 1080.00, 420.00, 0.00, 1080.00, 'Laudantium quis dol', 1, 2, 2, '2025-08-27 09:27:28', '2025-08-27 15:27:28', NULL),
(71, 1, 23, NULL, '#P0000022', NULL, 1, '2025-08-27 15:36:15', 32135.00, 32232.00, 701.00, 32095.00, 137.00, 23.00, 32095.00, 'Dolores expedita occ', 1, 2, 2, '2025-08-27 09:36:15', '2025-08-27 15:36:15', NULL),
(72, 1, 28, NULL, '#P0000023', NULL, 3, '2025-08-27 15:42:00', 1080.00, 1500.00, 624.00, 1010.00, 490.00, 70.00, 1010.00, 'Voluptatem odio vol', 1, 2, 2, '2025-08-27 09:42:00', '2025-08-27 15:42:00', NULL),
(73, 1, 24, NULL, '#P0000024', NULL, 2, '2025-08-27 15:52:19', 83.00, 161.00, 259.00, 62.00, 99.00, 21.00, 62.00, '21', 0, 2, 2, '2025-08-27 09:52:19', '2025-08-27 15:52:19', NULL),
(74, 1, 25, NULL, '#P0000025', NULL, 4, '2025-08-27 15:52:51', -371.00, -318.00, 932.00, -452.00, 134.00, 81.00, -452.00, 'Ut quia id commodi', 1, 2, 2, '2025-08-27 09:52:51', '2025-08-27 15:52:51', NULL),
(75, 1, 26, NULL, '#P0000026', NULL, 3, '2025-08-27 16:02:20', 1300.00, 1500.00, 500.00, 1279.00, 221.00, 21.00, 1279.00, NULL, 1, 2, 2, '2025-08-27 10:02:20', '2025-08-27 16:02:20', NULL),
(76, 1, 27, NULL, '#P0000027', NULL, 3, '2025-08-27 16:02:38', 1200.00, 1500.00, 544.00, 1232.00, 268.00, 32.00, 1232.00, NULL, 3, 2, 2, '2025-08-27 10:02:38', '2025-08-27 16:02:38', NULL);

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

--
-- Table structure for table `payment_details`
--

CREATE TABLE `payment_details` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) DEFAULT NULL COMMENT 'One-to-one relation with the payments table',
  `receipt_no` varchar(100) DEFAULT NULL COMMENT 'Applicable for cash payments as a manual receipt number',
  `bank_name` varchar(150) DEFAULT NULL COMMENT 'Name of the bank for bank transfers',
  `bank_account_name` varchar(150) DEFAULT NULL COMMENT 'Account holder name',
  `bank_account_number` varchar(100) DEFAULT NULL COMMENT 'Bank account number or IBAN',
  `bank_routing_number` varchar(100) DEFAULT NULL COMMENT 'Routing number or SWIFT code',
  `card_holder_name` varchar(150) DEFAULT NULL COMMENT 'Name on the credit/debit card',
  `card_last_four` varchar(4) DEFAULT NULL COMMENT 'Last 4 digits of card number',
  `card_type` varchar(50) DEFAULT NULL COMMENT 'Type of card (Visa, MasterCard, etc.)',
  `paypal_email` varchar(150) DEFAULT NULL COMMENT 'PayPal account email address',
  `additional_info` text DEFAULT NULL COMMENT 'Any other additional info or JSON blob for gateway response',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_details`
--

INSERT INTO `payment_details` (`id`, `payment_id`, `receipt_no`, `bank_name`, `bank_account_name`, `bank_account_number`, `bank_routing_number`, `card_holder_name`, `card_last_four`, `card_type`, `paypal_email`, `additional_info`, `created_at`, `updated_at`, `deleted_at`) VALUES
(8, 50, '#TXN0000001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:16:07', '2025-08-26 14:16:07', NULL),
(9, 51, '#TXN0000002', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:25:27', '2025-08-26 14:25:27', NULL),
(10, 52, '#TXN0000003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:28:48', '2025-08-26 14:28:48', NULL),
(11, 53, '#TXN0000004', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:32:29', '2025-08-26 14:32:29', NULL),
(12, 54, '#TXN0000005', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:33:52', '2025-08-26 14:33:52', NULL),
(13, 55, '#TXN0000006', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:37:29', '2025-08-26 14:37:29', NULL),
(14, 56, '#TXN0000007', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:47:10', '2025-08-26 14:47:10', NULL),
(15, 57, '#TXN0000008', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:47:46', '2025-08-26 14:47:46', NULL),
(16, 58, '#TXN0000009', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 08:50:31', '2025-08-26 14:50:31', NULL),
(17, 59, '#TXN0000010', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 09:42:07', '2025-08-26 15:42:07', NULL),
(18, 60, '#TXN0000011', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 09:48:45', '2025-08-26 15:48:45', NULL),
(19, 61, '#TXN0000012', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 09:56:08', '2025-08-26 15:56:08', NULL),
(20, 62, '#TXN0000013', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-26 09:58:06', '2025-08-26 15:58:06', NULL),
(21, 63, '#TXN0000014', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 08:00:02', '2025-08-27 14:00:02', NULL),
(22, 64, '#TXN0000015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 08:00:14', '2025-08-27 14:00:14', NULL),
(23, 65, '#TXN0000016', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 08:02:28', '2025-08-27 14:02:28', NULL),
(24, 66, '#TXN0000017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 08:19:15', '2025-08-27 14:19:15', NULL),
(25, 67, '#TXN0000018', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 08:31:54', '2025-08-27 14:31:54', NULL),
(26, 68, '#TXN0000019', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:21:18', '2025-08-27 15:21:18', NULL),
(27, 69, '#TXN0000020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:21:47', '2025-08-27 15:21:47', NULL),
(28, 70, '#TXN0000021', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:27:28', '2025-08-27 15:27:28', NULL),
(29, 71, '#TXN0000022', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:36:15', '2025-08-27 15:36:15', NULL),
(30, 72, '#TXN0000023', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:42:00', '2025-08-27 15:42:00', NULL),
(31, 73, '#TXN0000024', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:52:19', '2025-08-27 15:52:19', NULL),
(32, 74, '#TXN0000025', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 09:52:51', '2025-08-27 15:52:51', NULL),
(33, 75, '#TXN0000026', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 10:02:20', '2025-08-27 16:02:20', NULL),
(34, 76, '#TXN0000027', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-08-27 10:02:38', '2025-08-27 16:02:38', NULL);

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL COMMENT '1=Cash, 2=Bank Transfer, 3=Card - Paypal etc.',
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1 COMMENT '1= active, 0=Inactive',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `description`, `image`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Rocket', 'Rocket Account', NULL, 1, '2025-08-25 09:21:42', '2025-08-27 15:59:10', NULL),
(2, 'Nagod', 'Nagod', NULL, 1, '2025-08-25 09:21:47', '2025-08-27 15:58:55', NULL),
(3, 'Bkash', 'Bkash', NULL, 1, '2025-08-25 09:21:50', '2025-08-27 15:58:45', NULL),
(4, 'Cash', 'Cash', NULL, 1, '2025-08-25 09:23:56', '2025-08-27 15:58:39', NULL),
(5, 'Bank Transfer', 'bank', NULL, 1, '2025-08-27 09:58:22', '2025-08-27 15:58:22', NULL);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `guard_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;



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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) NOT NULL,
  `tokenable_type` varchar(255) DEFAULT NULL COMMENT 'Polymorphic type (e.g., AppModelsUser)',
  `tokenable_id` bigint(20) DEFAULT NULL COMMENT 'Polymorphic ID',
  `name` text DEFAULT NULL,
  `token` varchar(64) DEFAULT NULL COMMENT 'Hashed token string',
  `abilities` text DEFAULT NULL COMMENT 'Allowed abilities/scopes',
  `last_used_at` datetime DEFAULT NULL,
  `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Token expiration',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Record created time',
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `meta_title` varchar(200) DEFAULT NULL COMMENT 'SEO title shown in search engine results',
  `meta_description` varchar(500) DEFAULT NULL COMMENT 'SEO meta description for search snippet',
  `meta_keyword` varchar(255) DEFAULT NULL COMMENT 'Comma-separated keywords (optional)',
  `canonical_url` varchar(255) DEFAULT NULL COMMENT 'Canonical URL to avoid duplicate content issues',
  `meta_robots` varchar(100) DEFAULT NULL COMMENT 'e.g., index, follow / noindex, nofollow',
  `meta_img` varchar(255) DEFAULT NULL COMMENT 'Default image for SEO and social sharing',
  `og_title` varchar(200) DEFAULT NULL,
  `og_description` varchar(500) DEFAULT NULL,
  `og_image` varchar(255) DEFAULT NULL,
  `twitter_title` varchar(200) DEFAULT NULL,
  `twitter_description` varchar(500) DEFAULT NULL,
  `twitter_image` varchar(255) DEFAULT NULL,
  `is_published` tinyint(1) DEFAULT 0 COMMENT 'If true, post is publicly visible',
  `published_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Datetime when the post was published',
  `is_active` tinyint(1) DEFAULT 1,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `posts` (`id`, `category_id`, `title`, `slug`, `image`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `canonical_url`, `meta_robots`, `meta_img`, `og_title`, `og_description`, `og_image`, `twitter_title`, `twitter_description`, `twitter_image`, `is_published`, `published_date`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Dicta rem deserunt o', NULL, 'D:\\xampp\\tmp\\phpC1DA.tmp', 'Quos qui nobis exerc', 'Maiores ipsum conse', 'Assumenda veniam ut', 'Aute exercitationem', 'Culpa accusamus vel', 'Ut quibusdam consequ', 'Perspiciatis recusa', 'Eaque commodi conseq', 'Hic in quos enim vel', 'Culpa in quo eiusmod', 'Sit molestiae et do', 'Sapiente ratione nos', 'Numquam autem omnis', 0, '1999-01-14 11:27:00', 0, 2, NULL, '2025-08-27 05:55:34', '2025-08-27 11:55:34', NULL);

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

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

CREATE TABLE `post_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL COMMENT 'Name of the post category',
  `slug` varchar(100) DEFAULT NULL COMMENT 'SEO-friendly slug for URL',
  `logo` varchar(255) DEFAULT NULL COMMENT 'URL or path to category logo/icon image',
  `description` text DEFAULT NULL COMMENT 'Optional short description about this category',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `post_categories` (`id`, `name`, `slug`, `logo`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Madeline Sosa', 'madeline-sosa', 'D:\\xampp\\tmp\\phpEE35.tmp', 'Quae rem irure ab su', '2025-08-23 07:48:43', '2025-08-23 13:48:43', NULL),
(2, 'Idona Mueller', 'idona-mueller', 'D:\\xampp\\tmp\\php20B0.tmp', 'Accusamus nihil quis', '2025-08-23 07:48:56', '2025-08-23 13:48:56', NULL);

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `tour_package_id` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL COMMENT 'Value from 1 to 5',
  `comment` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `guard_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `roles` (`id`, `name`, `title`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super_admin', 'Super Admin', 'web', '2025-08-27 18:20:52', '2025-08-27 18:20:52'),
(2, 'admin', 'Admin', 'web', '2025-08-27 18:20:52', '2025-08-27 18:20:52'),
(3, 'tour_guide', 'Tour Guide', 'web', '2025-08-27 18:20:52', '2025-08-27 18:20:52'),
(4, 'Hall Gardner', 'Hall', 'web', '2025-08-27 18:43:01', '2025-08-27 18:43:01'),
(5, 'hiroko_murphy', 'Hiroko Murphy', 'web', '2025-08-27 22:27:52', '2025-08-27 22:27:52'),
(6, 'wdwdw_dwwdw', 'wdwdw dwwdw', 'web', '2025-08-27 23:24:45', '2025-08-27 23:24:45'),
(7, 'dsewe', 'dsewe', 'web', '2025-08-28 00:51:43', '2025-08-28 00:51:43'),
(8, 'macy_mayer', 'Macy Mayer', 'web', '2025-08-28 00:56:17', '2025-08-28 00:56:17'),
(9, 'madeson_mcneil', 'Madeson Mcneil', 'web', '2025-08-28 00:57:43', '2025-08-28 00:57:43');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Composite PK (permission_id, role_id)';

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 2),
(2, 2),
(3, 2),
(4, 2),
(5, 2),
(6, 2),
(7, 2),
(8, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(13, 2),
(61, 2),
(246, 2),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(25, 2),
(26, 2),
(27, 2),
(28, 2),
(29, 2),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(39, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 2),
(46, 2),
(47, 2),
(48, 2),
(49, 2),
(50, 2),
(51, 2),
(52, 2),
(53, 2),
(54, 2),
(55, 2),
(245, 2),
(62, 2),
(63, 2),
(64, 2),
(83, 2),
(84, 2),
(87, 2),
(248, 2),
(65, 2),
(66, 2),
(67, 2),
(68, 2),
(69, 2),
(70, 2),
(247, 2),
(71, 2),
(72, 2),
(73, 2),
(74, 2),
(75, 2),
(76, 2),
(77, 2),
(78, 2),
(79, 2),
(80, 2),
(81, 2),
(88, 2),
(89, 2),
(90, 2),
(91, 2),
(92, 2),
(171, 2),
(252, 2),
(93, 2),
(94, 2),
(95, 2),
(96, 2),
(97, 2),
(98, 2),
(99, 2),
(100, 2),
(101, 2),
(102, 2),
(103, 2),
(104, 2),
(105, 2),
(106, 2),
(107, 2),
(108, 2),
(249, 2),
(109, 2),
(110, 2),
(111, 2),
(112, 2),
(113, 2),
(114, 2),
(115, 2),
(116, 2),
(117, 2),
(118, 2),
(124, 2),
(125, 2),
(126, 2),
(127, 2),
(128, 2),
(129, 2),
(130, 2),
(131, 2),
(132, 2),
(133, 2),
(134, 2),
(250, 2),
(135, 2),
(136, 2),
(137, 2),
(138, 2),
(139, 2),
(140, 2),
(141, 2),
(142, 2),
(143, 2),
(144, 2),
(145, 2),
(146, 2),
(147, 2),
(148, 2),
(149, 2),
(150, 2),
(251, 2),
(151, 2),
(152, 2),
(153, 2),
(154, 2),
(155, 2),
(156, 2),
(157, 2),
(158, 2),
(159, 2),
(160, 2),
(161, 2),
(162, 2),
(163, 2),
(164, 2),
(165, 2),
(172, 2),
(173, 2),
(174, 2),
(175, 2),
(176, 2),
(177, 2),
(253, 2),
(178, 2),
(179, 2),
(180, 2),
(181, 2),
(182, 2),
(183, 2),
(254, 2),
(184, 2),
(185, 2),
(186, 2),
(187, 2),
(188, 2),
(189, 2),
(190, 2),
(191, 2),
(192, 2),
(193, 2),
(194, 2),
(255, 2),
(195, 2),
(196, 2),
(197, 2),
(198, 2),
(199, 2),
(200, 2),
(201, 2),
(202, 2),
(203, 2),
(204, 2),
(205, 2),
(206, 2),
(207, 2),
(208, 2),
(209, 2),
(210, 2),
(256, 2),
(211, 2),
(212, 2),
(213, 2),
(214, 2),
(215, 2),
(216, 2),
(217, 2),
(218, 2),
(219, 2),
(220, 2),
(221, 2),
(257, 2),
(222, 2),
(223, 2),
(224, 2),
(225, 2),
(226, 2),
(227, 2),
(228, 2),
(229, 2),
(230, 2),
(231, 2),
(232, 2),
(233, 2),
(234, 2),
(235, 2),
(236, 2),
(237, 2),
(238, 2),
(239, 2),
(240, 2),
(241, 2),
(242, 2),
(244, 2),
(258, 2),
(243, 2),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(10, 4),
(11, 4),
(12, 4),
(13, 4),
(61, 4),
(246, 4),
(14, 4),
(16, 4),
(17, 4),
(18, 4),
(19, 4),
(20, 4),
(25, 4),
(26, 4),
(28, 4),
(29, 4),
(31, 4),
(32, 4),
(35, 4),
(36, 4),
(38, 4),
(40, 4),
(41, 4),
(43, 4),
(44, 4),
(55, 4),
(62, 4),
(64, 4),
(83, 4),
(63, 4),
(248, 4),
(65, 4),
(73, 4),
(77, 4),
(79, 4),
(80, 4),
(88, 4),
(89, 4),
(91, 4),
(171, 4),
(252, 4),
(96, 4),
(98, 4),
(100, 4),
(105, 4),
(108, 4),
(249, 4),
(109, 4),
(112, 4),
(115, 4),
(124, 4),
(126, 4),
(130, 4),
(134, 4),
(250, 4),
(135, 4),
(137, 4),
(138, 4),
(140, 4),
(141, 4),
(147, 4),
(148, 4),
(149, 4),
(251, 4),
(151, 4),
(154, 4),
(155, 4),
(156, 4),
(161, 4),
(163, 4),
(173, 4),
(175, 4),
(176, 4),
(253, 4),
(180, 4),
(182, 4),
(183, 4),
(254, 4),
(184, 4),
(187, 4),
(188, 4),
(190, 4),
(193, 4),
(194, 4),
(195, 4),
(197, 4),
(198, 4),
(200, 4),
(201, 4),
(202, 4),
(205, 4),
(208, 4),
(209, 4),
(211, 4),
(212, 4),
(213, 4),
(214, 4),
(217, 4),
(218, 4),
(219, 4),
(221, 4),
(257, 4),
(222, 4),
(224, 4),
(225, 4),
(226, 4),
(227, 4),
(232, 4),
(236, 4),
(237, 4),
(238, 4),
(240, 4),
(241, 4),
(242, 4),
(2, 5),
(3, 5),
(4, 5),
(6, 5),
(8, 5),
(12, 5),
(13, 5),
(9, 5),
(10, 5),
(61, 5),
(14, 5),
(16, 5),
(17, 5),
(18, 5),
(19, 5),
(20, 5),
(21, 5),
(25, 5),
(27, 5),
(28, 5),
(29, 5),
(31, 5),
(39, 5),
(41, 5),
(42, 5),
(44, 5),
(49, 5),
(50, 5),
(51, 5),
(52, 5),
(245, 5),
(64, 5),
(62, 5),
(83, 5),
(63, 5),
(248, 5),
(65, 5),
(68, 5),
(247, 5),
(71, 5),
(73, 5),
(76, 5),
(80, 5),
(90, 5),
(91, 5),
(92, 5),
(88, 5),
(89, 5),
(171, 5),
(95, 5),
(96, 5),
(99, 5),
(100, 5),
(103, 5),
(104, 5),
(106, 5),
(107, 5),
(108, 5),
(110, 5),
(111, 5),
(113, 5),
(112, 5),
(115, 5),
(118, 5),
(124, 5),
(125, 5),
(131, 5),
(133, 5),
(134, 5),
(136, 5),
(138, 5),
(139, 5),
(141, 5),
(143, 5),
(145, 5),
(146, 5),
(149, 5),
(153, 5),
(154, 5),
(155, 5),
(158, 5),
(161, 5),
(162, 5),
(163, 5),
(174, 5),
(175, 5),
(176, 5),
(178, 5),
(180, 5),
(184, 5),
(185, 5),
(187, 5),
(188, 5),
(189, 5),
(192, 5),
(194, 5),
(196, 5),
(200, 5),
(202, 5),
(203, 5),
(205, 5),
(208, 5),
(210, 5),
(256, 5),
(212, 5),
(213, 5),
(214, 5),
(215, 5),
(217, 5),
(218, 5),
(257, 5),
(222, 5),
(223, 5),
(224, 5),
(226, 5),
(227, 5),
(228, 5),
(230, 5),
(231, 5),
(232, 5),
(235, 5),
(236, 5),
(237, 5),
(239, 5),
(240, 5),
(244, 5),
(1, 7),
(2, 7),
(3, 7),
(4, 7),
(5, 7),
(6, 7),
(7, 7),
(8, 7),
(9, 7),
(10, 7),
(11, 7),
(12, 7),
(13, 7),
(61, 7),
(246, 7),
(14, 7),
(15, 7),
(16, 7),
(17, 7),
(18, 7),
(19, 7),
(20, 7),
(21, 7),
(22, 7),
(23, 7),
(24, 7),
(25, 7),
(26, 7),
(27, 7),
(28, 7),
(29, 7),
(30, 7),
(31, 7),
(32, 7),
(33, 7),
(34, 7),
(35, 7),
(36, 7),
(37, 7),
(38, 7),
(39, 7),
(40, 7),
(41, 7),
(42, 7),
(43, 7),
(44, 7),
(45, 7),
(46, 7),
(47, 7),
(48, 7),
(49, 7),
(50, 7),
(51, 7),
(52, 7),
(53, 7),
(54, 7),
(55, 7),
(245, 7),
(62, 7),
(63, 7),
(64, 7),
(83, 7),
(84, 7),
(87, 7),
(248, 7),
(65, 7),
(66, 7),
(67, 7),
(68, 7),
(69, 7),
(70, 7),
(247, 7),
(71, 7),
(72, 7),
(73, 7),
(74, 7),
(75, 7),
(76, 7),
(77, 7),
(78, 7),
(79, 7),
(80, 7),
(81, 7),
(88, 7),
(89, 7),
(90, 7),
(91, 7),
(92, 7),
(171, 7),
(252, 7),
(93, 7),
(94, 7),
(95, 7),
(96, 7),
(97, 7),
(98, 7),
(99, 7),
(100, 7),
(101, 7),
(102, 7),
(103, 7),
(104, 7),
(105, 7),
(106, 7),
(107, 7),
(108, 7),
(249, 7),
(109, 7),
(110, 7),
(111, 7),
(112, 7),
(113, 7),
(114, 7),
(115, 7),
(116, 7),
(117, 7),
(118, 7),
(124, 7),
(125, 7),
(126, 7),
(127, 7),
(128, 7),
(129, 7),
(130, 7),
(131, 7),
(132, 7),
(133, 7),
(134, 7),
(250, 7),
(135, 7),
(136, 7),
(137, 7),
(138, 7),
(139, 7),
(140, 7),
(141, 7),
(142, 7),
(143, 7),
(144, 7),
(145, 7),
(146, 7),
(147, 7),
(148, 7),
(149, 7),
(150, 7),
(251, 7),
(151, 7),
(152, 7),
(153, 7),
(154, 7),
(155, 7),
(156, 7),
(157, 7),
(158, 7),
(159, 7),
(160, 7),
(161, 7),
(162, 7),
(163, 7),
(164, 7),
(165, 7),
(172, 7),
(173, 7),
(174, 7),
(175, 7),
(176, 7),
(177, 7),
(253, 7),
(178, 7),
(179, 7),
(180, 7),
(181, 7),
(182, 7),
(183, 7),
(254, 7),
(184, 7),
(185, 7),
(186, 7),
(187, 7),
(188, 7),
(189, 7),
(190, 7),
(191, 7),
(192, 7),
(193, 7),
(194, 7),
(255, 7),
(195, 7),
(196, 7),
(197, 7),
(198, 7),
(199, 7),
(200, 7),
(201, 7),
(202, 7),
(203, 7),
(204, 7),
(205, 7),
(206, 7),
(207, 7),
(208, 7),
(209, 7),
(210, 7),
(256, 7),
(211, 7),
(212, 7),
(213, 7),
(214, 7),
(215, 7),
(216, 7),
(217, 7),
(218, 7),
(219, 7),
(220, 7),
(221, 7),
(257, 7),
(222, 7),
(223, 7),
(224, 7),
(225, 7),
(226, 7),
(227, 7),
(228, 7),
(229, 7),
(230, 7),
(231, 7),
(232, 7),
(233, 7),
(234, 7),
(235, 7),
(236, 7),
(237, 7),
(238, 7),
(239, 7),
(240, 7),
(241, 7),
(242, 7),
(244, 7),
(258, 7),
(243, 7),
(2, 8),
(3, 8),
(8, 8),
(10, 8),
(11, 8),
(14, 8),
(15, 8),
(16, 8),
(20, 8),
(22, 8),
(23, 8),
(24, 8),
(28, 8),
(29, 8),
(31, 8),
(34, 8),
(35, 8),
(38, 8),
(39, 8),
(40, 8),
(41, 8),
(43, 8),
(47, 8),
(50, 8),
(52, 8),
(53, 8),
(62, 8),
(83, 8),
(65, 8),
(66, 8),
(67, 8),
(71, 8),
(73, 8),
(75, 8),
(76, 8),
(91, 8),
(92, 8),
(88, 8),
(89, 8),
(90, 8),
(171, 8),
(93, 8),
(96, 8),
(97, 8),
(98, 8),
(103, 8),
(105, 8),
(106, 8),
(107, 8),
(249, 8),
(111, 8),
(112, 8),
(110, 8),
(117, 8),
(118, 8),
(124, 8),
(125, 8),
(127, 8),
(128, 8),
(129, 8),
(130, 8),
(131, 8),
(133, 8),
(134, 8),
(250, 8),
(138, 8),
(141, 8),
(142, 8),
(146, 8),
(148, 8),
(149, 8),
(150, 8),
(152, 8),
(154, 8),
(156, 8),
(159, 8),
(160, 8),
(161, 8),
(162, 8),
(163, 8),
(164, 8),
(176, 8),
(177, 8),
(179, 8),
(180, 8),
(181, 8),
(182, 8),
(189, 8),
(193, 8),
(194, 8),
(195, 8),
(198, 8),
(202, 8),
(205, 8),
(208, 8),
(209, 8),
(210, 8),
(256, 8),
(212, 8),
(214, 8),
(216, 8),
(217, 8),
(220, 8),
(223, 8),
(224, 8),
(227, 8),
(230, 8),
(231, 8),
(233, 8),
(234, 8),
(235, 8),
(237, 8),
(238, 8),
(242, 8),
(258, 8),
(243, 8),
(1, 9),
(3, 9),
(10, 9),
(12, 9),
(61, 9),
(17, 9),
(19, 9),
(21, 9),
(27, 9),
(28, 9),
(29, 9),
(30, 9),
(31, 9),
(32, 9),
(33, 9),
(34, 9),
(35, 9),
(37, 9),
(40, 9),
(41, 9),
(42, 9),
(45, 9),
(47, 9),
(48, 9),
(51, 9),
(52, 9),
(54, 9),
(55, 9),
(245, 9),
(63, 9),
(62, 9),
(83, 9),
(64, 9),
(87, 9),
(65, 9),
(66, 9),
(67, 9),
(68, 9),
(247, 9),
(72, 9),
(73, 9),
(74, 9),
(77, 9),
(79, 9),
(80, 9),
(81, 9),
(88, 9),
(92, 9),
(89, 9),
(91, 9),
(90, 9),
(171, 9),
(252, 9),
(96, 9),
(97, 9),
(99, 9),
(102, 9),
(103, 9),
(104, 9),
(108, 9),
(249, 9),
(109, 9),
(110, 9),
(111, 9),
(113, 9),
(114, 9),
(115, 9),
(116, 9),
(117, 9),
(124, 9),
(131, 9),
(133, 9),
(136, 9),
(137, 9),
(139, 9),
(140, 9),
(141, 9),
(142, 9),
(143, 9),
(144, 9),
(146, 9),
(153, 9),
(155, 9),
(160, 9),
(163, 9),
(165, 9),
(172, 9),
(173, 9),
(175, 9),
(253, 9),
(178, 9),
(179, 9),
(181, 9),
(186, 9),
(187, 9),
(189, 9),
(192, 9),
(255, 9),
(199, 9),
(204, 9),
(205, 9),
(210, 9),
(256, 9),
(214, 9),
(215, 9),
(217, 9),
(218, 9),
(220, 9),
(257, 9),
(222, 9),
(224, 9),
(228, 9),
(231, 9),
(232, 9),
(235, 9),
(236, 9),
(237, 9),
(240, 9),
(244, 9),
(258, 9),
(243, 9),
(1, 6),
(2, 6),
(3, 6),
(4, 6),
(5, 6),
(6, 6),
(7, 6),
(8, 6),
(9, 6),
(10, 6),
(11, 6),
(12, 6),
(13, 6),
(61, 6),
(246, 6),
(14, 6),
(15, 6),
(16, 6),
(17, 6),
(18, 6),
(19, 6),
(20, 6),
(21, 6),
(22, 6),
(23, 6),
(24, 6),
(25, 6),
(26, 6),
(27, 6),
(28, 6),
(29, 6),
(30, 6),
(31, 6),
(32, 6),
(33, 6),
(34, 6),
(35, 6),
(36, 6),
(37, 6),
(38, 6),
(39, 6),
(40, 6),
(41, 6),
(42, 6),
(43, 6),
(44, 6),
(45, 6),
(46, 6),
(47, 6),
(48, 6),
(49, 6),
(50, 6),
(51, 6),
(52, 6),
(53, 6),
(54, 6),
(55, 6),
(245, 6),
(62, 6),
(63, 6),
(64, 6),
(83, 6),
(84, 6),
(87, 6),
(248, 6),
(65, 6),
(66, 6),
(67, 6),
(68, 6),
(69, 6),
(70, 6),
(247, 6),
(71, 6),
(72, 6),
(73, 6),
(74, 6),
(75, 6),
(76, 6),
(77, 6),
(78, 6),
(79, 6),
(80, 6),
(81, 6),
(88, 6),
(89, 6),
(90, 6),
(91, 6),
(92, 6),
(171, 6),
(252, 6),
(93, 6),
(94, 6),
(95, 6),
(96, 6),
(97, 6),
(98, 6),
(99, 6),
(100, 6),
(101, 6),
(102, 6),
(103, 6),
(104, 6),
(105, 6),
(106, 6),
(107, 6),
(108, 6),
(249, 6),
(109, 6),
(110, 6),
(111, 6),
(112, 6),
(113, 6),
(114, 6),
(115, 6),
(116, 6),
(117, 6),
(118, 6),
(124, 6),
(125, 6),
(126, 6),
(127, 6),
(128, 6),
(129, 6),
(130, 6),
(131, 6),
(132, 6),
(133, 6),
(134, 6),
(250, 6),
(135, 6),
(136, 6),
(137, 6),
(138, 6),
(139, 6),
(140, 6),
(141, 6),
(142, 6),
(143, 6),
(144, 6),
(145, 6),
(146, 6),
(147, 6),
(148, 6),
(149, 6),
(150, 6),
(251, 6),
(151, 6),
(152, 6),
(153, 6),
(154, 6),
(155, 6),
(156, 6),
(157, 6),
(158, 6),
(159, 6),
(160, 6),
(161, 6),
(162, 6),
(163, 6),
(164, 6),
(165, 6),
(172, 6),
(173, 6),
(174, 6),
(175, 6),
(176, 6),
(177, 6),
(253, 6),
(178, 6),
(179, 6),
(180, 6),
(181, 6),
(182, 6),
(183, 6),
(254, 6),
(184, 6),
(185, 6),
(186, 6),
(187, 6),
(188, 6),
(189, 6),
(190, 6),
(191, 6),
(192, 6),
(193, 6),
(194, 6),
(255, 6),
(195, 6),
(196, 6),
(197, 6),
(198, 6),
(199, 6),
(200, 6),
(201, 6),
(202, 6),
(203, 6),
(204, 6),
(205, 6),
(206, 6),
(207, 6),
(208, 6),
(209, 6),
(210, 6),
(256, 6),
(211, 6),
(212, 6),
(213, 6),
(214, 6),
(215, 6),
(216, 6),
(217, 6),
(218, 6),
(219, 6),
(220, 6),
(221, 6),
(257, 6),
(222, 6),
(223, 6),
(224, 6),
(225, 6),
(226, 6),
(227, 6),
(228, 6),
(229, 6),
(230, 6),
(231, 6),
(232, 6),
(233, 6),
(234, 6),
(235, 6),
(236, 6),
(237, 6),
(238, 6),
(239, 6),
(240, 6),
(241, 6),
(242, 6),
(244, 6),
(258, 6),
(243, 6);

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

--
-- Table structure for table `seasons`
--

CREATE TABLE `seasons` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `service_requests`
--

CREATE TABLE `service_requests` (
  `id` int(11) NOT NULL,
  `service_id` varchar(100) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL COMMENT 'Customer who made the service request',
  `service_date` date DEFAULT NULL COMMENT 'Requested date for the service',
  `service_type_id` int(11) DEFAULT NULL COMMENT 'Type of requested service',
  `travel_point_id` int(11) DEFAULT NULL COMMENT 'Service location or destination',
  `number_of_adults` int(11) DEFAULT 1 COMMENT 'Total adults included',
  `number_of_kids` int(11) DEFAULT 0 COMMENT 'Total children included',
  `total_persons` int(11) DEFAULT NULL COMMENT 'Total number of persons (adults + kids)',
  `description` text DEFAULT NULL COMMENT 'Detailed user request or requirements',
  `unit_price` decimal(10,2) DEFAULT NULL COMMENT 'Base price before discount',
  `discount_type` tinyint(2) DEFAULT NULL COMMENT '1 = percentage, 2 = fixed amount',
  `discount` decimal(5,2) DEFAULT NULL COMMENT 'Discount value based on type',
  `discount_price` decimal(10,2) DEFAULT NULL COMMENT 'Discount amount to subtract from unit price',
  `sale_price` decimal(10,2) DEFAULT NULL COMMENT 'Final amount after discount',
  `notes` text DEFAULT NULL COMMENT 'Additional notes from user or admin',
  `approval_status` tinyint(4) DEFAULT 0 COMMENT '0 = Pending, 1 = Approved, 2 = Cancelled — Upon approval, price is set and booking is created',
  `is_active` tinyint(1) DEFAULT 1 COMMENT 'Soft active/inactive flag',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'Creator of the request (admin or user)',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_requests`
--

INSERT INTO `service_requests` (`id`, `service_id`, `customer_id`, `service_date`, `service_type_id`, `travel_point_id`, `number_of_adults`, `number_of_kids`, `total_persons`, `description`, `unit_price`, `discount_type`, `discount`, `discount_price`, `sale_price`, `notes`, `approval_status`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, '1970-01-27', 1, 4, 642, 689, 93, 'Nihil reiciendis qua', 59.00, 0, 76.00, 631.00, 557.00, 'Ipsum fugiat tenet', 0, 1, 2, NULL, '2025-08-23 11:14:13', '2025-08-23 17:14:13', NULL);

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

--
-- Table structure for table `service_types`
--

CREATE TABLE `service_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1 COMMENT '1 = Active, 0 = Inactive',
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_types`
--

INSERT INTO `service_types` (`id`, `name`, `description`, `icon`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Gillian Austin', 'Commodi doloremque n', 'Quia incididunt et c', 0, 2, NULL, '2025-08-23 11:13:34', '2025-08-23 17:13:34', NULL),
(2, 'Zelenia Wynn', 'Officia dolorem maxi', 'Id magna lorem non r', 1, 2, NULL, '2025-08-23 11:13:41', '2025-08-23 17:13:41', NULL);

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL COMMENT 'Nullable, references users table',
  `ip_address` varchar(45) DEFAULT NULL COMMENT 'IP address of the user session',
  `user_agent` text DEFAULT NULL COMMENT 'Browser/Device details',
  `payload` longtext NOT NULL COMMENT 'Session data',
  `last_activity` int(11) NOT NULL COMMENT 'Timestamp of last activity'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('QNj0SqjEALRDGuWQktYWz3DqCGyiOZXtg1TWw2H8', 2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYVJZTW5EZ3dnNmdUM3JLMDdNdzVQaFhFckdONkJyQkhtMXFHR0ozeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9zZXJ2aWNlLXJlcXVlc3RzLzEiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=', 1756350097);

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(2048) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `personal_team` tinyint(1) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='teams user_id is team owner';

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`id`, `user_id`, `name`, `description`, `image`, `is_active`, `personal_team`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(7, 3, 'Slade Leblanc', 'Dolor et error velit', NULL, 1, NULL, 2, 2, '2025-08-25 12:41:37', '2025-08-25 12:41:50', NULL),
(8, 19, 'Ivory Crawford', 'Officiis aut quod al', NULL, 1, NULL, 2, 2, '2025-08-25 12:41:40', '2025-08-25 12:41:46', NULL);

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

--
-- Table structure for table `tour_activities`
--

CREATE TABLE `tour_activities` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour_activities`
--

INSERT INTO `tour_activities` (`id`, `name`, `slug`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Erich Jimenez', 'erich-jimenez', '2025-08-23 08:49:16', '2025-08-23 14:49:16', NULL),
(2, 'Nomlanga Aguirre', 'nomlanga-aguirre', '2025-08-23 08:49:20', '2025-08-23 14:49:20', NULL),
(3, 'Avram Wynn', 'avram-wynn', '2025-08-23 08:49:24', '2025-08-23 14:49:24', NULL),
(4, 'Colette Aguilar', 'colette-aguilar', '2025-08-23 08:49:29', '2025-08-23 14:49:29', NULL),
(5, 'Sade Savage', 'sade-savage', '2025-08-23 08:49:35', '2025-08-23 14:49:35', NULL),
(6, 'Bruno Hart', 'bruno-hart', '2025-08-23 08:49:38', '2025-08-23 14:49:38', NULL);

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

--
-- Table structure for table `tour_guides`
--

CREATE TABLE `tour_guides` (
  `id` bigint(20) NOT NULL,
  `team_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='role users role';

--
-- Dumping data for table `tour_guides`
--

INSERT INTO `tour_guides` (`id`, `team_id`, `user_id`, `role`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, 8, 15, NULL, 1, NULL, NULL, '2025-08-25 13:03:55', '2025-08-25 13:03:55', NULL),
(5, 7, 24, NULL, 1, NULL, 2, '2025-08-25 13:13:38', '2025-08-25 13:13:54', NULL),
(6, 8, 15, NULL, 1, NULL, 2, '2025-08-25 13:13:42', '2025-08-25 13:13:50', NULL),
(7, 8, 15, NULL, 1, NULL, NULL, '2025-08-25 13:13:45', '2025-08-25 13:13:45', NULL),
(8, 7, 24, NULL, 1, NULL, 2, '2025-08-25 14:01:48', '2025-08-25 14:01:54', NULL);

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

--
-- Table structure for table `tour_images`
--

CREATE TABLE `tour_images` (
  `id` int(11) NOT NULL,
  `tour_package_id` int(11) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour_images`
--

INSERT INTO `tour_images` (`id`, `tour_package_id`, `image_url`, `caption`, `deleted_at`) VALUES
(54, 57, NULL, NULL, NULL),
(55, 60, '/storage/tour_packages/gallery/68ad97ddb7229.jpeg', NULL, NULL),
(56, 60, '/storage/tour_packages/gallery/68ad97ddb82ca.jpg', NULL, NULL),
(57, 60, '/storage/tour_packages/gallery/68ad97ddb8f12.jpg', NULL, NULL),
(58, 60, '/storage/tour_packages/gallery/68ad97ddb99d8.jpeg', NULL, NULL),
(59, 60, '/storage/tour_packages/gallery/68ad97ddba499.jpeg', NULL, NULL),
(60, 62, 'http://127.0.0.1:8000/uploads/tour_packages/gallery_images/1756207755_admit.jpeg', NULL, NULL),
(61, 62, 'http://127.0.0.1:8000/uploads/tour_packages/gallery_images/1756207755_marksheer-admit.jpg', NULL, NULL),
(62, 62, 'http://127.0.0.1:8000/uploads/tour_packages/gallery_images/1756207755_6e4567b9-b4de-4103-a8d5-c27899829d93.jpg', NULL, NULL),
(63, 62, 'http://127.0.0.1:8000/uploads/tour_packages/gallery_images/1756207755_WhatsApp Image 2025-08-17 at 3.36.10 PM.jpeg', NULL, NULL),
(64, 62, 'http://127.0.0.1:8000/uploads/tour_packages/gallery_images/1756207755_marksheet.jpeg', NULL, NULL);

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

--
-- Table structure for table `tour_itineraries`
--

CREATE TABLE `tour_itineraries` (
  `id` int(11) NOT NULL,
  `tour_package_id` int(11) DEFAULT NULL,
  `custom_package_requests_id` int(11) DEFAULT NULL COMMENT 'Custom user-requested activity if applicable',
  `service_package_requests_id` int(11) DEFAULT NULL COMMENT 'Service user-requested activity if applicable',
  `itinerary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`itinerary`)),
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour_itineraries`
--

INSERT INTO `tour_itineraries` (`id`, `tour_package_id`, `custom_package_requests_id`, `service_package_requests_id`, `itinerary`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(20, 24, NULL, NULL, '{\"1\":null}', 2, NULL, '2025-08-26 08:21:38', '2025-08-26 14:21:38', NULL),
(21, 44, NULL, NULL, '{\"day_1\":\"Eum cupiditate tenet\"}', 2, NULL, '2025-08-26 09:54:54', '2025-08-26 15:54:54', NULL),
(22, 45, NULL, NULL, '{\"day_1\":\"Ipsam quidem eius pe\"}', 2, NULL, '2025-08-26 10:00:54', '2025-08-26 16:00:54', NULL),
(23, 46, NULL, NULL, '{\"day_1\":\"Corrupti repellendu\"}', 2, NULL, '2025-08-26 10:06:03', '2025-08-26 16:06:03', NULL),
(24, 47, NULL, NULL, '{\"day_1\":\"Cillum quo hic volup\"}', 2, NULL, '2025-08-26 10:10:17', '2025-08-26 16:10:17', NULL),
(25, 48, NULL, NULL, '{\"day_1\":\"Ex ratione cupidatat\"}', 2, NULL, '2025-08-26 10:10:39', '2025-08-26 16:10:39', NULL),
(26, 49, NULL, NULL, '{\"day_1\":\"Suscipit ad culpa ma\"}', 2, NULL, '2025-08-26 10:15:39', '2025-08-26 16:15:39', NULL),
(27, 50, NULL, NULL, '{\"day_1\":\"Itaque cumque tenetu\",\"day_2\":\"<p>Beatae sed eos, ipsa.<\\/p>\",\"day_3\":\"<p>Duis occaecat nobis .<\\/p>\",\"day_4\":\"<p>Qui iusto velit et n.<\\/p>\"}', 2, NULL, '2025-08-26 10:37:53', '2025-08-26 16:37:53', NULL),
(28, 51, NULL, NULL, '{\"day_1\":\"Velit suscipit qui i\",\"day_2\":null,\"day_3\":null,\"day_4\":null}', 2, NULL, '2025-08-26 10:51:33', '2025-08-26 16:51:33', NULL),
(29, 52, NULL, NULL, '{\"day_1\":\"Inventore quod eveni\",\"day_2\":null,\"day_3\":null,\"day_4\":null}', 2, NULL, '2025-08-26 10:52:42', '2025-08-26 16:52:42', NULL),
(30, 53, NULL, NULL, '{\"day_1\":\"Omnis architecto occ\",\"day_2\":null,\"day_3\":null,\"day_4\":null}', 2, NULL, '2025-08-26 10:54:14', '2025-08-26 16:54:14', NULL),
(31, 54, NULL, NULL, '{\"day_1\":\"Id aspernatur et li\",\"day_2\":null,\"day_3\":null,\"day_4\":null}', 2, NULL, '2025-08-26 10:55:14', '2025-08-26 16:55:14', NULL),
(32, 55, NULL, NULL, '{\"day_1\":\"Aut ut commodo moles\",\"day_2\":null,\"day_3\":null,\"day_4\":null}', 2, NULL, '2025-08-26 10:56:28', '2025-08-26 16:56:28', NULL),
(33, 56, NULL, NULL, '{\"day_1\":\"Pariatur Duis ab as\"}', 2, NULL, '2025-08-26 11:04:40', '2025-08-26 17:04:40', NULL),
(34, 57, NULL, NULL, '{\"day_1\":\"Ea tempora ipsum ve\"}', 2, NULL, '2025-08-26 11:13:02', '2025-08-26 17:13:02', NULL),
(37, 60, NULL, NULL, '{\"day_1\":\"Totam consequuntur i\"}', 2, NULL, '2025-08-26 11:17:49', '2025-08-26 17:17:49', NULL),
(39, 62, NULL, NULL, '{\"day_1\":\"Non officia nisi deb\"}', 2, NULL, '2025-08-26 11:29:15', '2025-08-26 17:29:15', NULL),
(40, 63, NULL, NULL, '{\"day_1\":\"Alias sequi et quia\"}', 2, NULL, '2025-08-26 11:40:40', '2025-08-26 17:40:40', NULL),
(41, 64, NULL, NULL, '{\"day_1\":\"Incidunt nulla plac\"}', 2, NULL, '2025-08-26 11:47:19', '2025-08-26 17:47:19', NULL),
(42, 63, NULL, NULL, '{\"1\":null}', 2, NULL, '2025-08-26 12:07:37', '2025-08-26 18:07:37', NULL),
(43, 65, NULL, NULL, '{\"day_1\":\"Tempore nihil delen\"}', 2, NULL, '2025-08-27 08:01:41', '2025-08-27 14:01:41', NULL),
(44, 65, NULL, NULL, '{\"1\":null}', 2, NULL, '2025-08-27 10:05:04', '2025-08-27 16:05:04', NULL),
(45, 66, NULL, NULL, '{\"day_1\":\"Sit enim enim offic\"}', 2, NULL, '2025-08-27 10:06:14', '2025-08-27 16:06:14', NULL);

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

--
-- Table structure for table `tour_packages`
--

CREATE TABLE `tour_packages` (
  `id` int(11) NOT NULL,
  `custom_package_requests_id` int(255) DEFAULT NULL,
  `service_requests_id` int(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL COMMENT 'Original price per unit before any discount',
  `discount_price` decimal(10,2) DEFAULT NULL COMMENT 'Calculated discount amount to subtract from unit_price',
  `sale_price` decimal(10,2) DEFAULT NULL COMMENT 'Final price after discount (unit_price - discount_price)',
  `booking_amount` decimal(10,2) DEFAULT NULL COMMENT 'Booking price is booking confirmation advance payable money',
  `is_show_on_website` tinyint(1) DEFAULT 0,
  `is_featured` tinyint(1) DEFAULT 0,
  `is_popular_day_trips` tinyint(1) DEFAULT 0,
  `is_travellers_choice` tinyint(1) DEFAULT 0,
  `tour_activities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tour_activities`)),
  `from_date` date DEFAULT NULL COMMENT 'Tour start date',
  `to_date` date DEFAULT NULL COMMENT 'Tour end date',
  `tour_type_id` int(11) DEFAULT NULL,
  `duration` varchar(50) DEFAULT NULL,
  `group_size` varchar(100) DEFAULT NULL,
  `accommodation` varchar(100) DEFAULT NULL,
  `transportation` varchar(100) DEFAULT NULL,
  `meals` varchar(100) DEFAULT NULL,
  `fitness_level` varchar(50) DEFAULT NULL,
  `minimum_age` int(11) DEFAULT NULL,
  `language` varchar(50) DEFAULT NULL,
  `best_season` varchar(100) DEFAULT NULL,
  `guiding_method` varchar(100) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL COMMENT 'Main tour location, e.g., New & Old Dhaka',
  `travel_point_id` int(11) DEFAULT NULL,
  `max_altitude` varchar(50) DEFAULT NULL,
  `arrival_on` varchar(50) DEFAULT NULL,
  `departure_from` varchar(50) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `intro` text DEFAULT NULL,
  `tour_highlight` text DEFAULT NULL,
  `tour_attraction` text DEFAULT NULL,
  `map_image` varchar(255) DEFAULT NULL,
  `trip_notes` text DEFAULT NULL,
  `faq` text DEFAULT NULL,
  `reviews` text DEFAULT NULL,
  `pickup_location` varchar(255) DEFAULT NULL,
  `dropoff_location` varchar(255) DEFAULT NULL,
  `feature_image` varchar(100) DEFAULT NULL,
  `thumbnail` varchar(100) DEFAULT NULL,
  `gallery_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`gallery_images`)),
  `video` varchar(100) DEFAULT NULL,
  `video_url` varchar(100) DEFAULT NULL,
  `meta_title` varchar(200) DEFAULT NULL COMMENT 'Main SEO title for the page (shown in search results & browser tab)',
  `meta_description` varchar(500) DEFAULT NULL COMMENT 'Concise summary shown in search engine snippets',
  `meta_keyword` varchar(255) DEFAULT NULL COMMENT 'Comma-separated keywords (mostly deprecated, but still used in some cases)',
  `canonical_url` varchar(255) DEFAULT NULL COMMENT 'Canonical URL to avoid duplicate content and consolidate SEO signals',
  `meta_robots` varchar(100) DEFAULT NULL COMMENT 'Controls search engine crawling and indexing (e.g., index, nofollow)',
  `meta_img` varchar(255) DEFAULT NULL COMMENT 'Default image for SEO sharing (used by social platforms)',
  `structured_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'JSON-LD structured data (e.g., Article, Product, LocalBusiness) for rich results' CHECK (json_valid(`structured_data`)),
  `og_title` varchar(200) DEFAULT NULL COMMENT 'Open Graph title for social platforms like Facebook and LinkedIn',
  `og_description` varchar(500) DEFAULT NULL COMMENT 'Open Graph description for enhanced preview on social shares',
  `og_image` varchar(255) DEFAULT NULL COMMENT 'URL to Open Graph image (1200x630 recommended)',
  `twitter_title` varchar(200) DEFAULT NULL COMMENT 'Twitter Card title (max 70 characters)',
  `twitter_description` varchar(500) DEFAULT NULL COMMENT 'Twitter Card description (max 200 characters)',
  `twitter_image` varchar(255) DEFAULT NULL COMMENT 'Twitter Card image URL (recommended size: 1200x675)',
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour_packages`
--

INSERT INTO `tour_packages` (`id`, `custom_package_requests_id`, `service_requests_id`, `name`, `slug`, `unit_price`, `discount_price`, `sale_price`, `booking_amount`, `is_show_on_website`, `is_featured`, `is_popular_day_trips`, `is_travellers_choice`, `tour_activities`, `from_date`, `to_date`, `tour_type_id`, `duration`, `group_size`, `accommodation`, `transportation`, `meals`, `fitness_level`, `minimum_age`, `language`, `best_season`, `guiding_method`, `location`, `travel_point_id`, `max_altitude`, `arrival_on`, `departure_from`, `sub_title`, `intro`, `tour_highlight`, `tour_attraction`, `map_image`, `trip_notes`, `faq`, `reviews`, `pickup_location`, `dropoff_location`, `feature_image`, `thumbnail`, `gallery_images`, `video`, `video_url`, `meta_title`, `meta_description`, `meta_keyword`, `canonical_url`, `meta_robots`, `meta_img`, `structured_data`, `og_title`, `og_description`, `og_image`, `twitter_title`, `twitter_description`, `twitter_image`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`, `is_active`) VALUES
(24, NULL, NULL, 'Paki Farley', 'paki-farley', 805.00, 100.00, 3232.00, 50.00, 1, 1, 0, 0, '[\"art-crafts\",\"boat-cruise\",\"cycling-camping\",\"history-heritage\",\"nature-wildlife\",\"beach-coastal\"]', '2025-08-26', '2025-09-06', 3, 'Voluptas voluptatem', 'Soluta facilis minim', 'Mollitia aut obcaeca', 'Itaque laboris volup', 'Ducimus facere eius', 'Dolores vel quo et q', 46, 'Quaerat ullam repell', 'Lorem officia et mag', 'Necessitatibus nihil', 'Commodo et reprehend', 4, 'Enim itaque tenetur', 'Rerum temporibus por', 'Ex rerum beatae corr', 'Autem sapiente amet', 'Voluptatem Dolor no', NULL, NULL, NULL, 'Adipisci autem omnis', 'Est sint necessitati', 'Ut et ratione ullam', 'Aut vitae ipsum dign', 'Non sit cumque unde', NULL, NULL, NULL, NULL, 'https://www.buvehilynewiwyb.com.au', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, '2025-08-24 09:00:34', '2025-08-26 14:21:38', NULL, 1),
(25, NULL, NULL, 'Aileen Cummings', 'aileen-cummings-2025-08-24-152222', 367.00, 144.00, 3232.00, 27.00, 1, 1, 0, 1, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"adventure-sports\\\",\\\"religious-sites\\\"]\"', '1991-06-09', '2025-08-24', 7, 'Error odio dolores i', 'Pariatur Elit aliq', 'In sunt debitis qui', 'Laboriosam non elig', 'Velit aut explicabo', 'Quia numquam nostrud', 83, 'Consequatur Deserun', 'Enim et exercitation', 'Voluptatem labore si', 'Est est quia vitae', 4, 'Veritatis ut dolor l', 'Dolores et suscipit', 'Illo dolorum invento', 'Quia ipsa ipsam eaq', 'Nobis eos in exercit', NULL, NULL, NULL, 'Irure maxime dolorem', 'Sint fuga Velit cu', 'Exercitationem enim', 'Accusantium amet ex', 'Natus adipisicing do', NULL, NULL, NULL, NULL, 'https://www.qosah.mobi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 09:22:22', '2025-08-24 15:22:22', NULL, 1),
(26, NULL, NULL, 'Halee Mcdonald', 'halee-mcdonald-2025-08-24-155919', 376.00, 346.00, 3232.00, 79.00, 0, 0, 1, 1, '\"[\\\"art-crafts\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"photography-tours\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2004-05-12', '2025-08-24', 3, 'Sit est veniam magn', 'Proident ut ut aper', 'Sunt enim duis labor', 'Rem minima vel quo v', 'Incididunt consequun', 'Eius voluptas in atq', 16, 'Explicabo Aperiam u', 'Placeat nostrud mag', 'Eiusmod irure ipsum', 'Est voluptatum ad ea', 4, 'Voluptatem sed facer', 'Mollit deleniti mini', 'Elit aliqua Cum of', 'Perspiciatis sit di', 'Minima dolore alias', NULL, NULL, NULL, 'Qui ut nisi id duis', 'Cum neque tenetur mi', 'Facilis Nam rerum ma', 'Voluptatum illo volu', 'Dolor nulla repudian', NULL, NULL, NULL, NULL, 'https://www.jymep.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 09:59:19', '2025-08-24 15:59:19', NULL, 1),
(27, NULL, NULL, 'Dacey Head', 'dacey-head-2025-08-24-160029', 290.00, 557.00, 32.00, 72.00, 0, 0, 1, 0, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"history-heritage\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '1996-05-12', '2025-08-24', 9, 'Fugit dignissimos d', 'Quia unde pariatur', 'Suscipit quo dolore', 'Minim dolor fugit i', 'Fuga Animi nisi es', 'Fuga Laboriosam de', 84, 'Unde tenetur quibusd', 'Dolor et dicta est', 'Minus dolor qui ut b', 'Molestiae amet cons', 4, 'Et non delectus vol', 'Voluptatem ipsum q', 'Impedit in reiciend', 'Tempor aut ratione o', 'Quia sed temporibus', NULL, NULL, NULL, 'Sint perspiciatis', 'Rem aperiam sunt nih', 'Cillum possimus vol', 'Non laborum veniam', 'Sapiente ut adipisic', NULL, NULL, NULL, NULL, 'https://www.kuhybohowepuxen.me.uk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:00:29', '2025-08-24 17:30:02', '2025-08-24 17:30:02', 1),
(28, NULL, NULL, 'Brent Atkinson', 'brent-atkinson-2025-08-24-160508', 287.00, 87.00, 32323.00, 50.00, 1, 0, 1, 0, '\"[\\\"art-crafts\\\",\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"history-heritage\\\",\\\"photography-tours\\\",\\\"religious-sites\\\"]\"', '1991-01-15', '2025-08-24', 9, 'Qui quia quia sit no', 'Velit illo veniam c', 'Repudiandae quia dol', 'Architecto fugiat et', 'Est molestiae non n', 'Aut odit ea quia in', 1, 'Officia voluptatibus', 'Fuga Corrupti reru', 'Mollitia quod exerci', 'Dignissimos incidunt', 4, 'Aliquid nostrud atqu', 'Quisquam dolores iru', 'Adipisci aut maiores', 'Repudiandae tempore', 'Distinctio Quis qui', NULL, NULL, NULL, 'Non nulla aut at pra', 'Et natus unde eiusmo', 'Ut harum omnis in no', 'Iure fugiat sit volu', 'Sapiente excepteur a', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.denyhixawoz.com.au', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:05:08', '2025-08-24 16:05:08', NULL, 1),
(29, NULL, NULL, 'Erich Hancock', 'erich-hancock-2025-08-24-160616', 993.00, 669.00, 32232.00, 74.00, 1, 0, 1, 1, '\"[\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"folk-festivals\\\",\\\"nature-wildlife\\\",\\\"beach-coastal\\\"]\"', '2002-01-20', '2025-08-24', 7, 'Nemo laboriosam vel', 'Est quam necessitati', 'Illum soluta nisi i', 'Adipisicing pariatur', 'Nisi consequatur sun', 'Ut molestiae volupta', 84, 'Sapiente ducimus qu', 'Sit consequatur Re', 'Fugit in autem veni', 'Mollitia blanditiis', 4, 'Labore in qui duis p', 'Molestiae et id libe', 'Laborum assumenda se', 'Corporis velit cons', 'Quo mollit est arch', NULL, NULL, NULL, 'Magni molestiae aper', 'Eligendi modi ration', 'Esse recusandae Rem', 'Fugiat placeat lab', 'Tempor aut et ducimu', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.gimesil.me', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:06:16', '2025-08-24 16:06:16', NULL, 1),
(34, NULL, NULL, 'Kirby Morrison', 'kirby-morrison-2025-08-24-163811', 470.00, 603.00, 3232.00, 3.00, 0, 0, 0, 0, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"beach-coastal\\\"]\"', '1992-06-19', '2025-08-24', 4, 'Veritatis modi elige', 'Vel aliqua Irure si', 'Autem consectetur e', 'Dolor necessitatibus', 'Deserunt suscipit se', 'Est velit voluptatem', 79, 'Dolor nesciunt ut f', 'Facilis id maiores', 'Debitis rerum sed qu', 'Saepe ut aliquid dol', 4, 'Incidunt et explica', 'Natus ratione odio e', 'Incididunt consectet', 'Suscipit sit sint', '<p>Quia at rerum sit, n.</p>', '<p>Esse, et et voluptat.</p>', NULL, 'D:\\xampp\\tmp\\php6D43.tmp', 'Similique ut unde ex', 'Non delectus aspern', 'Dolores est quis pro', 'Eveniet nisi quia a', 'Qui quia id iure sa', NULL, 'D:\\xampp\\tmp\\php6D44.tmp', '[{},{},{},{},{},{}]', NULL, 'https://www.lipopytorikubad.me.uk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:38:11', '2025-08-24 17:34:34', '2025-08-24 17:34:34', 1),
(35, NULL, NULL, 'Keelie Duke', 'keelie-duke-2025-08-24-163848', 994.00, 952.00, 323.00, 90.00, 1, 1, 1, 1, '\"[\\\"boat-cruise\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"trailing-walking\\\",\\\"photography-tours\\\",\\\"religious-sites\\\"]\"', '1988-07-19', '2025-08-24', 2, 'In labore numquam ir', 'Voluptate ea earum d', 'Eveniet sint aut a', 'Commodo aut anim vel', 'Quia vel iure eum ex', 'Aut sequi molestiae', 74, 'Numquam tempor ut vo', 'Tenetur enim possimu', 'Temporibus eveniet', 'Voluptate rerum sed', 4, 'Nesciunt sunt qui', 'Aliquam et at accusa', 'Ut voluptatem nihil', 'Quis eum incidunt r', 'Ut tempora sint et', NULL, NULL, NULL, 'Quasi tempora laboru', 'In sint consequatur', 'Qui soluta sint exer', 'Et aut laborum Veli', 'Quaerat sunt cillum', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.fyq.tv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:38:48', '2025-08-24 17:39:16', '2025-08-24 17:39:16', 1),
(36, NULL, NULL, 'Chadwick David', 'chadwick-david-2025-08-24-164130', 212.00, 384.00, 2323.00, 36.00, 0, 1, 0, 0, '\"[\\\"art-crafts\\\",\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"religious-sites\\\"]\"', '1994-11-23', '2025-08-24', 8, 'Aut eos aut fugiat', 'Rerum voluptatibus r', 'Est rerum aute velit', 'Qui facere deserunt', 'Architecto sit labor', 'Omnis occaecat volup', 25, 'Consequatur veniam', 'Qui in repudiandae o', 'Dolor voluptatem Nam', 'Voluptate quia facer', 4, 'Quidem minus quos eu', 'Aliquam id dolores d', 'Est voluptate venia', 'Atque aute velit qu', 'Aliqua Consequat Q', NULL, NULL, 'D:\\xampp\\tmp\\php7580.tmp', 'Nulla illum natus p', 'Exercitation tempora', 'Fugiat dignissimos', 'Nulla minus necessit', 'Voluptas dolore nihi', 'D:\\xampp\\tmp\\php7581.tmp', 'D:\\xampp\\tmp\\php7582.tmp', '[{},{},{},{},{}]', NULL, 'https://www.xyj.ca', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:41:30', '2025-08-24 17:33:58', '2025-08-24 17:33:58', 1),
(37, NULL, NULL, 'Oliver Dyer', 'oliver-dyer-2025-08-24-164315', 520.00, 243.00, 2323.00, 16.00, 0, 0, 0, 0, '\"[\\\"art-crafts\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2016-08-03', '2025-08-24', 3, 'In harum fugiat volu', 'Blanditiis enim rem', 'Delectus velit volu', 'Voluptas quia at lab', 'Tenetur laboris cons', 'Voluptatem voluptat', 97, 'Provident molestiae', 'Doloremque cum eu eu', 'Et earum qui cupidat', 'Cumque velit odit re', 4, 'Voluptas nostrud aut', 'Perferendis eveniet', 'Non enim qui qui des', 'Odit voluptatum dolo', 'Accusantium enim fug', NULL, NULL, 'D:\\xampp\\tmp\\php11C4.tmp', 'A sint dolorem temp', 'Non sint amet quo n', 'Earum cumque nihil o', 'Aliquip qui ex eos a', 'Quia consequuntur ra', NULL, 'D:\\xampp\\tmp\\php11C6.tmp', '[{},{},{},{},{}]', NULL, 'https://www.xozono.cc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:43:15', '2025-08-24 17:33:41', '2025-08-24 17:33:41', 1),
(38, NULL, NULL, 'Amber Ochoa', 'amber-ochoa-2025-08-24-164845', 603.00, 141.00, 2323.00, 34.00, 1, 1, 1, 0, '\"[\\\"art-crafts\\\",\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"trailing-walking\\\"]\"', '2011-05-12', '2025-08-24', 5, 'Et nostrud excepturi', 'Et fuga Architecto', 'Enim assumenda proid', 'Porro ut earum cillu', 'Aliquid ut at dolore', 'Suscipit quia quo a', 19, 'Deleniti sunt non id', 'Aut ut quisquam lore', 'Ipsum do occaecat et', 'Aliquid quis rerum n', 4, 'Obcaecati rerum rati', 'Est pariatur Elige', 'Aut sit incidunt ma', 'Quia sit dolores vo', 'Non qui in accusanti', NULL, NULL, NULL, 'Non impedit invento', 'Ab cillum ut assumen', 'Nulla ea esse omnis', 'Quo id explicabo P', 'Ad aut et eaque labo', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.bocezubojisinev.co', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:48:45', '2025-08-24 17:33:24', '2025-08-24 17:33:24', 1),
(39, NULL, NULL, 'Dennis Sims', 'dennis-sims-2025-08-24-165300', 29.00, 276.00, 232323.00, 5.00, 0, 1, 0, 1, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"folk-festivals\\\",\\\"trailing-walking\\\"]\"', '2019-01-04', '2025-08-24', 2, 'Anim do repudiandae', 'Voluptatem repudiand', 'Laudantium mollit i', 'Quas dolore harum mi', 'Perferendis accusant', 'Natus in sequi repud', 79, 'Assumenda laudantium', 'Sit cumque quis ex a', 'Do consequuntur cons', 'Culpa vel amet cil', 4, 'Ut magni duis volupt', 'Aliqua Dolores quas', 'Dolores laboriosam', 'Pariatur Nostrud de', 'Molestias distinctio', NULL, NULL, NULL, 'Proident aut nobis', 'Id laborum Qui offi', 'Proident ut commodo', 'Quos fugiat qui des', 'In dolor animi simi', NULL, NULL, '[{},{},{},{},{}]', NULL, 'https://www.qewukyjufo.me.uk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 10:53:00', '2025-08-24 17:33:54', '2025-08-24 17:33:54', 1),
(40, NULL, NULL, 'Dora Drake', 'dora-drake-2025-08-24-171759', 447.00, 300.00, 2323.00, 48.00, 1, 0, 0, 1, '\"[\\\"culinary-food\\\",\\\"folk-festivals\\\",\\\"history-heritage\\\",\\\"photography-tours\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2012-04-17', '2025-08-24', 8, 'Iure molestias asper', 'Qui consequat Esse', 'Obcaecati omnis enim', 'Odio ad exercitation', 'Consectetur dolore', 'Ab necessitatibus vo', 15, 'Voluptas dolor atque', 'Dignissimos in sint', 'In fugiat ut eu sint', 'Odio rerum minima du', 4, 'Et dolores impedit', 'Aliquip cupidatat eu', 'Rerum ex eum impedit', 'Consequatur dolorem', '<p>Facere temporibus iu.</p>', '<p>Vel quas vel minima .</p>', NULL, NULL, 'Consequatur dolore t', 'Earum quia molestiae', 'Proident cillum nos', 'Voluptatem corrupti', 'Excepteur vel ut lib', 'D:\\xampp\\tmp\\phpDB33.tmp', 'D:\\xampp\\tmp\\phpDB34.tmp', '[{},{},{},{}]', NULL, 'https://www.vuruxotodexifu.org.uk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 11:17:59', '2025-08-24 17:30:13', '2025-08-24 17:30:13', 1),
(41, NULL, NULL, 'Kennan Barron', 'kennan-barron-2025-08-24-171911', 371.00, 115.00, 232.00, 61.00, 1, 0, 0, 0, '\"[\\\"art-crafts\\\",\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"folk-festivals\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2000-08-24', '2025-08-24', 2, 'Rerum porro laborum', 'Sint a mollitia et i', 'Dolor ut non placeat', 'Quibusdam aliquip il', 'Maiores perspiciatis', 'Iste facere quibusda', 48, 'Elit dolorem soluta', 'Distinctio Quam duc', 'Adipisicing vitae ut', 'Nisi in voluptate et', 4, 'Unde consectetur und', 'Quae sunt cillum omn', 'Dolor officia volupt', 'Quis aut aliqua Ali', 'Autem nemo quibusdam', NULL, NULL, NULL, 'Et quos voluptatem', 'Officia totam volupt', 'A similique est ex c', 'Vitae architecto dui', 'Commodi doloribus ut', 'D:\\xampp\\tmp\\phpF545.tmp', 'D:\\xampp\\tmp\\phpF546.tmp', NULL, NULL, 'https://www.bagyjetyvuvomy.cc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 11:19:11', '2025-08-24 17:27:05', '2025-08-24 17:27:05', 1),
(42, NULL, NULL, 'Raya Kim', 'raya-kim-2025-08-24-172341', 228.00, 733.00, 3232.00, 28.00, 1, 1, 0, 0, '\"[\\\"boat-cruise\\\",\\\"cycling-camping\\\",\\\"photography-tours\\\"]\"', '1995-07-16', '2025-08-24', 2, 'Saepe corporis offic', 'Qui voluptatem ut al', 'Recusandae Occaecat', 'Repellendus Consequ', 'Aliqua Anim dolore', 'Porro consequatur v', 27, 'Dolore odit impedit', 'Aliquip eos voluptat', 'Voluptatem molestia', 'Qui reprehenderit e', 4, 'Numquam veniam est', 'Maiores dolorem sit', 'Tenetur ut velit au', 'Nulla pariatur Sed', 'Et odit rerum natus', NULL, NULL, NULL, 'Labore magni repelle', 'Repudiandae est nis', 'Atque quia voluptas', 'Nobis consequatur qu', 'Saepe cillum quae in', 'D:\\xampp\\tmp\\php135C.tmp', 'D:\\xampp\\tmp\\php135D.tmp', NULL, NULL, 'https://www.xoquwi.info', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 11:23:41', '2025-08-24 17:25:03', '2025-08-24 17:25:03', 1),
(43, NULL, NULL, 'Brent Payne', 'brent-payne-2025-08-24-173940', 514.00, 167.00, 3232.00, 77.00, 0, 0, 1, 1, '\"[\\\"boat-cruise\\\",\\\"folk-festivals\\\",\\\"history-heritage\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"beach-coastal\\\"]\"', '2017-06-20', '2025-08-24', 1, 'Numquam ipsam sit la', 'Exercitation dolor i', 'Ipsa qui voluptate', 'Cum maxime duis ea e', 'Necessitatibus nihil', 'Sed consequatur aliq', 23, 'Sit omnis fugit ma', 'Facere corrupti deb', 'Deleniti eveniet do', 'Numquam ut magni adi', 4, 'Consectetur libero', 'Voluptate in eum vol', 'Amet quaerat adipis', 'Sed dignissimos iust', 'Velit consequat Inc', NULL, NULL, NULL, 'Voluptas eveniet pe', 'Sunt aspernatur tota', 'Sit non veniam eiu', 'Inventore quis ad op', 'Velit quidem consequ', NULL, NULL, NULL, NULL, 'https://www.kezewajevoxyq.com.au', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-24 11:39:40', '2025-08-24 17:39:40', NULL, 1),
(44, NULL, NULL, 'Quinn Guy', 'quinn-guy-2025-08-26-155454', 1000.00, 100.00, NULL, 500.00, 0, 1, 0, 1, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '1971-12-29', '2025-08-26', 2, 'Et iste irure vel de', 'Omnis aliquam proide', 'Facilis in quo commo', 'Aliquid voluptates a', 'Animi soluta quo su', 'Corrupti architecto', 24, 'Dolore minim ut ea a', 'Eum veritatis aut se', 'Quos architecto sed', 'Ut a quis aut exerci', 4, 'Do et iure labore nu', 'Consequat Inventore', 'Sed expedita dolorem', 'Itaque quia repellen', 'Fuga Quis dolor ut', NULL, NULL, NULL, 'Repellendus Incidid', 'Do quas nulla dolor', 'Deserunt incididunt', 'Dolores iure in ut d', 'Autem mollitia ea do', NULL, NULL, NULL, NULL, 'https://www.sekajur.cc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 09:54:54', '2025-08-26 15:54:54', NULL, 1),
(45, NULL, NULL, 'Test Package 01', 'test-package-01-2025-08-26-160054', 2000.00, 200.00, NULL, 500.00, 0, 1, 1, 0, '\"[\\\"art-crafts\\\",\\\"cycling-camping\\\",\\\"folk-festivals\\\"]\"', '1985-03-02', '2025-08-26', 7, 'Fugiat reiciendis e', 'Recusandae In ullam', 'Beatae dolore impedi', 'Est quis aut sunt vo', 'Et optio sit incid', 'Culpa non alias des', 66, 'Aut in quia placeat', 'Expedita aut nulla l', 'Quia odit doloribus', 'A atque tenetur debi', 4, 'Reprehenderit velit', 'Ab eligendi consequa', 'Nulla sint laboriosa', 'Minima omnis molesti', 'Sunt adipisci illum', NULL, NULL, NULL, 'Ad perspiciatis con', 'Tempor natus reicien', 'Labore natus alias c', 'Omnis similique inve', 'Numquam tempor excep', NULL, NULL, NULL, NULL, 'https://www.qucimejukomegi.biz', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:00:54', '2025-08-26 16:00:54', NULL, 1),
(46, NULL, NULL, 'Byron Wright', 'byron-wright-2025-08-26-160603', 420.00, 259.00, 161.00, 78.00, 0, 0, 0, 0, '\"[\\\"art-crafts\\\",\\\"nature-wildlife\\\"]\"', '1972-10-04', '2025-08-26', 9, 'Nihil ipsum ad magn', 'Quis Nam ut facere p', 'Ducimus et alias co', 'Aut et do minus inve', 'Placeat consequuntu', 'Maxime autem vel duc', 48, 'Culpa ea voluptatem', 'Tenetur id minim cul', 'Quibusdam voluptatem', 'Provident id recus', 4, 'Culpa quia commodo', 'Ratione quidem susci', 'Earum porro officia', 'Omnis dolores aut au', 'Quia est fugiat mol', NULL, NULL, NULL, 'Laborum aute minima', 'Mollit ea accusantiu', 'Ipsum impedit cupid', 'Ex ab ipsum id sapi', 'In modi voluptas exc', NULL, NULL, NULL, NULL, 'https://www.bazuturo.us', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:06:03', '2025-08-26 16:06:03', NULL, 1),
(47, NULL, NULL, 'Iris Henry', 'iris-henry-2025-08-26-161017', 570.00, 888.00, -318.00, 53.00, 1, 0, 1, 0, '\"[\\\"art-crafts\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\"]\"', '1998-12-28', '2025-08-26', 9, 'Porro voluptatem no', 'Quas hic aperiam aut', 'Non inventore id ani', 'Deserunt odit ut duc', 'Nemo atque voluptate', 'Esse error sed ut r', 14, 'Ut itaque nisi in vo', 'Dolor laborum Rerum', 'Velit consequat Ex', 'Autem rerum sed at a', 4, 'Sed ut facilis nulla', 'Earum vel possimus', 'Autem iste in laboru', 'Sint enim fugiat ess', 'Rerum in id sed irur', '<p>Recusandae. Et sit a.</p>', NULL, NULL, 'Culpa consequatur d', 'Ipsam voluptates sin', 'Aut sed et ut facili', 'Sit aspernatur quisq', 'Qui fuga Ipsum sed', NULL, NULL, NULL, NULL, 'https://www.qev.ca', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:10:17', '2025-08-26 16:10:17', NULL, 1),
(48, NULL, NULL, 'Chantale Cummings', 'chantale-cummings-2025-08-26-161039', 381.00, 288.00, 93.00, 78.00, 1, 0, 0, 0, '\"[\\\"boat-cruise\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"trailing-walking\\\",\\\"photography-tours\\\",\\\"religious-sites\\\"]\"', '2006-07-01', '2025-08-26', 2, 'Incididunt harum bea', 'Consectetur dolorem', 'Eos quia aliqua Dol', 'Debitis atque nobis', 'Et ad est quo facer', 'Qui sit in rerum nos', 1, 'Ducimus laborum cum', 'Cum omnis fugiat con', 'Dolor inventore numq', 'Magni voluptate id a', 4, 'Ea exercitation sed', 'Incidunt explicabo', 'Molestias nihil cupi', 'Ullamco quae anim ob', 'Autem ea voluptatem', NULL, NULL, NULL, 'Ullam voluptatem Is', 'Aute eum enim veniam', 'Vel iste voluptates', 'Corporis nostrud rep', 'Animi natus alias n', NULL, NULL, NULL, NULL, 'https://www.pebykymogywub.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:10:39', '2025-08-26 16:10:39', NULL, 1),
(49, NULL, NULL, 'Joshua Grant', 'joshua-grant-2025-08-26-161539', 895.00, 23.00, 872.00, 88.00, 1, 0, 0, 1, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"folk-festivals\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"beach-coastal\\\"]\"', '1988-11-10', '2025-08-26', 8, 'Ratione rerum volupt', 'Nulla excepturi non', 'In reprehenderit qua', 'Ad quod minima ea se', 'Nihil ea unde commod', 'Inventore omnis dict', 92, 'Quia odit est except', 'Quia quas earum mini', 'Quod nihil minim ver', 'Harum omnis eu volup', 4, 'Et veniam reprehend', 'Provident adipisci', 'Sed officia est dese', 'Amet in eveniet cu', '<p>Nisi ut id, voluptat.</p>', '<p>Delectus, cupiditate.</p>', NULL, NULL, 'Nostrum ut numquam o', 'Ullam in autem debit', 'Quis consequuntur qu', 'Consectetur aute nec', 'Aut vitae ullamco om', NULL, NULL, NULL, NULL, 'https://www.jaqiwuxasyb.us', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:15:39', '2025-08-26 16:15:39', NULL, 1),
(50, NULL, NULL, 'Nyssa Mcfadden', 'nyssa-mcfadden-2025-08-26-163753', 511.00, 203.00, 308.00, 22.00, 1, 0, 1, 1, '\"[\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"photography-tours\\\"]\"', '2009-02-28', '2025-08-26', 8, 'In nihil perferendis', 'Facere velit consequ', 'Libero commodo eius', 'Velit sed earum illo', 'Placeat consectetur', 'Dolorem enim quod qu', 58, 'Dolorum optio quia', 'Rerum est Nam volup', 'Elit consectetur fa', 'Aut architecto quis', 4, 'Reprehenderit volupt', 'Laborum Voluptas al', 'Sequi proident expl', 'Ratione aut culpa c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Earum et qui sapient', 'Minus ex quidem amet', NULL, NULL, NULL, NULL, 'https://www.razuqibu.mobi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:37:53', '2025-08-26 16:37:53', NULL, 1),
(51, NULL, NULL, 'Stuart Crosby', 'stuart-crosby-2025-08-26-165133', 730.00, 21.00, 709.00, 51.00, 0, 1, 1, 0, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"history-heritage\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"beach-coastal\\\"]\"', '2016-11-04', '2025-08-26', 1, 'Officia molestiae in', 'Aute amet architect', 'Ut aliqua Porro aut', 'Est in tenetur et ve', 'Ad veniam at et sed', 'Cum voluptatibus dol', 41, 'Reprehenderit volupt', 'Cupidatat rerum dolo', 'Facilis explicabo L', 'Recusandae Optio r', 4, 'Repellendus Non aut', 'Cillum vero magna in', 'Velit sit illum ape', 'Voluptate soluta und', '<p>In dicta qui cupidit.</p>', '<p>Laboris sit elit, cu.</p>', '<p>Velit ut eligendi qu.</p>', NULL, NULL, '<p>Neque laborum. Dicta.</p>', '<p>Assumenda consequatu.</p>', 'Aliqua Eius velit', 'Et expedita iste sin', NULL, NULL, '[{},{},{},{},{}]', NULL, 'https://www.keti.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:51:33', '2025-08-26 16:51:33', NULL, 1),
(52, NULL, NULL, 'Ursa Contreras', 'ursa-contreras-2025-08-26-165242', 223.00, 21.00, 202.00, 42.00, 1, 0, 0, 0, '\"[\\\"cycling-camping\\\",\\\"adventure-sports\\\",\\\"beach-coastal\\\"]\"', '2014-01-17', '2025-08-26', 1, 'Lorem similique sint', 'Fugit ratione omnis', 'Labore magni labore', 'Provident tenetur r', 'Mollit veniam nesci', 'Atque rerum perferen', 69, 'Qui irure nisi itaqu', 'Aut rerum laborum H', 'Et aut alias esse a', 'Voluptate quam et vo', 4, 'Illum est distincti', 'A dolore vero minim', 'Culpa voluptates ve', 'Itaque irure volupta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dolore consectetur u', 'Laudantium molestia', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.puqupyjysehig.tv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:52:42', '2025-08-26 16:52:42', NULL, 1),
(53, NULL, NULL, 'Demetrius Mcgowan', 'demetrius-mcgowan-2025-08-26-165414', 602.00, 22.00, 580.00, 97.00, 0, 1, 0, 0, '\"[\\\"boat-cruise\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"religious-sites\\\"]\"', '1987-10-24', '2025-08-26', 9, 'Sequi ea elit quide', 'Ullam non sed odio i', 'In sint tempor est a', 'Qui eum voluptatem', 'Consequatur qui ani', 'Aut sed veniam volu', 14, 'Sit est doloremque', 'Dignissimos aut mini', 'Quos laboriosam ess', 'Officiis possimus c', 4, 'Adipisicing quae cup', 'Voluptas amet culpa', 'Proident elit volu', 'Ratione et quos magn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Proident aut corrup', 'Dolore cumque conseq', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.facoluhypyput.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:54:14', '2025-08-26 16:54:14', NULL, 1),
(54, NULL, NULL, 'Amaya Delacruz', 'amaya-delacruz-2025-08-26-165514', 830.00, 32.00, 798.00, 10.00, 1, 0, 1, 1, '\"[\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"religious-sites\\\"]\"', '2003-03-02', '2025-08-26', 9, 'Obcaecati adipisci i', 'Molestias qui lorem', 'Sunt qui eu nihil e', 'Tempore do nulla co', 'Et dolores omnis id', 'Molestiae voluptates', 92, 'Id quam accusantium', 'Iste aut deserunt si', 'Mollitia saepe aliqu', 'Rerum deserunt in au', 4, 'Sint incidunt commo', 'Vitae expedita offic', 'Possimus sed aliqui', 'Voluptate ducimus t', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Aut nemo soluta in q', 'Est ut labore sed re', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.ralogysoroke.cm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:55:14', '2025-08-26 16:55:14', NULL, 1),
(55, NULL, NULL, 'Lisandra Pena', 'lisandra-pena-2025-08-26-165627', 980.00, 208.00, 772.00, 78.00, 0, 0, 0, 1, '\"[\\\"cycling-camping\\\",\\\"folk-festivals\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2016-04-24', '2025-08-26', 9, 'Voluptas aut dolore', 'Rerum sint unde non', 'Numquam amet aut en', 'Quis quis aut modi s', 'Explicabo Nam natus', 'Adipisicing facilis', 16, 'Fugit nemo qui proi', 'Tempore corporis eu', 'Et ut nihil necessit', 'Ea autem sapiente ab', 4, 'Nisi pariatur Quis', 'Iure ipsam reiciendi', 'Officia ab minim quo', 'Consectetur adipisic', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Est praesentium a la', 'Et in consectetur al', NULL, NULL, '[{},{},{},{},{},{}]', NULL, 'https://www.tynynyrerohar.biz', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 10:56:28', '2025-08-26 16:56:28', NULL, 1),
(56, NULL, NULL, 'Rhona Joyce', 'rhona-joyce-2025-08-26-170440', 591.00, 351.00, 240.00, 78.00, 1, 1, 0, 1, '\"[\\\"culinary-food\\\",\\\"folk-festivals\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\",\\\"photography-tours\\\"]\"', '2013-09-08', '2025-08-26', 2, 'Sunt laborum volupt', 'Aliqua Sed corrupti', 'Aute mollit hic opti', 'Similique labore nes', 'Molestiae expedita d', 'Nobis quidem aut vel', 9, 'Velit fugiat dicta p', 'Nesciunt cumque vol', 'Fuga Necessitatibus', 'Ab sed esse anim re', 4, 'Est ea nobis dolor e', 'Quaerat velit sint r', 'Tenetur labore iure', 'Enim non temporibus', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Praesentium ut adipi', 'Inventore natus natu', 'D:\\xampp\\tmp\\php608E.tmp', 'D:\\xampp\\tmp\\php608F.tmp', '[{},{},{},{},{}]', NULL, 'https://www.fybunaloxuwufo.org.uk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 11:04:40', '2025-08-26 17:04:40', NULL, 1),
(57, NULL, NULL, 'Neve French', 'neve-french-2025-08-26-171302', 109.00, 23.00, 86.00, 41.00, 0, 0, 0, 0, '\"[\\\"folk-festivals\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"beach-coastal\\\"]\"', '1996-10-24', '2025-08-26', 8, 'Tempore aute ea ver', 'Sit commodo dolor ex', 'Ad molestiae laborum', 'Sint consectetur ve', 'Ab praesentium eius', 'Soluta ut nisi dolor', 73, 'Vel reiciendis optio', 'Officia tenetur anim', 'Dolorum enim laboris', 'Iusto proident dolo', 4, 'Cillum expedita sed', 'Nisi molestias imped', 'Obcaecati vitae sit', 'Quas vero vel proide', '<p>Aliquid expedita qui.</p>', '<p>Laborum. Dolores sin.</p>', '<p>Elit, cum culpa occa.</p>', NULL, NULL, '<p>Dolor in illum, a vo.</p>', '<p>Ducimus, in tempora .</p>', 'Architecto elit qui', 'Qui nihil non quo as', 'D:\\xampp\\tmp\\phpAA7.tmp', 'D:\\xampp\\tmp\\phpAB8.tmp', '[{},{},{},{},{}]', NULL, 'https://www.tehykoryl.com.au', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 11:13:02', '2025-08-26 17:13:02', NULL, 1),
(60, NULL, NULL, 'Paul Clements', 'paul-clements-2025-08-26-171749', 263.00, 11.00, 252.00, 23.00, 1, 0, 1, 1, '\"[\\\"art-crafts\\\",\\\"boat-cruise\\\",\\\"cycling-camping\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\"]\"', '1997-06-05', '2025-08-26', 2, 'Dolorem molestiae co', 'Pariatur Do et labo', 'Quod laudantium vol', 'Voluptate ut modi mo', 'Ut qui dignissimos a', 'Quia neque laboriosa', 40, 'Vero rerum in cum ex', 'Sed provident quas', 'Tenetur omnis consec', 'Occaecat suscipit no', 4, 'Consequatur Consequ', 'Duis veniam esse pr', 'Ad aliquip omnis obc', 'Aliquid quo exercita', '<p>Ipsa, cupidatat et l.</p>', '<p>Qui odit do incidunt.</p>', '<p>Ut fuga. Et dolore q.</p>', NULL, NULL, '<p>Sequi officia maiore.</p>', '<p>Aut numquam quas ips.</p>', 'Sit qui qui aut cupi', 'Sunt velit et non la', 'D:\\xampp\\tmp\\php6D84.tmp', NULL, '[{},{},{},{},{}]', NULL, 'https://www.neli.me', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 11:17:49', '2025-08-26 17:17:49', NULL, 1),
(62, NULL, NULL, 'Hope Wilcox', 'hope-wilcox-2025-08-26-172915', 121122.00, 705.00, 120417.00, 14.00, 0, 0, 1, 0, '\"[\\\"art-crafts\\\",\\\"culinary-food\\\",\\\"history-heritage\\\",\\\"nature-wildlife\\\",\\\"adventure-sports\\\",\\\"beach-coastal\\\"]\"', '1970-06-15', '2025-08-26', 7, 'Irure consequuntur e', 'Qui nemo ipsum nihi', 'Voluptatem quis qui', 'Elit animi quis ni', 'Voluptas eos enim vo', 'Eos doloremque lauda', 64, 'Rerum excepteur quae', 'Magni nihil qui dolo', 'Soluta pariatur Neq', 'Non aut placeat sun', 4, 'Porro ut natus qui b', 'Pariatur Voluptatum', 'Obcaecati ut magnam', 'Est dolor qui amet', '<p>Incididunt ut omnis .</p>', '<p>Debitis odio nostrum.</p>', '<p>Commodo minus quidem.</p>', 'D:\\xampp\\tmp\\phpE62C.tmp', NULL, '<p>Possimus, sint, volu.</p>', '<p>Et ea sit aute in qu.</p>', 'Nam exercitationem i', 'Necessitatibus imped', 'D:\\xampp\\tmp\\phpE62E.tmp', NULL, '[{},{},{},{},{}]', NULL, 'https://www.huwybocepomi.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 11:29:15', '2025-08-26 17:29:15', NULL, 1),
(63, NULL, NULL, 'Donna Giles', 'donna-giles', 499.00, 115.00, 384.00, 25.00, 0, 0, 0, 1, '[\"art-crafts\",\"boat-cruise\",\"culinary-food\",\"cycling-camping\",\"folk-festivals\",\"trailing-walking\",\"photography-tours\",\"religious-sites\"]', '2018-10-06', '2025-08-26', 4, 'Sapiente sint fugiat', 'Proident laborum C', 'Nam quis quaerat ali', 'Id labore tempore e', 'Aliqua Aliquam eius', 'Optio nostrum aperi', 84, 'Dolore expedita sint', 'Aliqua Nostrum vero', 'Nesciunt incididunt', 'Pariatur In harum e', 4, 'Voluptas amet ut li', 'Quasi voluptas labor', 'Quam ad sed ad conse', 'Autem ut veritatis a', NULL, NULL, NULL, 'http://127.0.0.1:8000/uploads/tour_packages/map_image/1756208440_6e4567b9-b4de-4103-a8d5-c27899829d93.jpg', NULL, NULL, NULL, 'Dolor mollitia harum', 'Sit tempore volupta', 'http://127.0.0.1:8000/uploads/tour_packages/feature_image/1756208440_marksheet.jpeg', NULL, NULL, NULL, 'https://www.xycu.cm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, '2025-08-26 11:40:40', '2025-08-26 18:07:37', NULL, 1),
(64, NULL, NULL, 'Brennan Olson', 'brennan-olson-2025-08-26-174719', 970.00, 53.00, 917.00, 25.00, 0, 1, 0, 0, '\"[\\\"boat-cruise\\\",\\\"culinary-food\\\",\\\"cycling-camping\\\",\\\"nature-wildlife\\\",\\\"trailing-walking\\\",\\\"adventure-sports\\\",\\\"photography-tours\\\",\\\"religious-sites\\\",\\\"beach-coastal\\\"]\"', '2002-10-25', '2025-08-26', 1, 'Animi amet accusan', 'Id ut dolorem minim', 'Non fuga Excepteur', 'Magnam nesciunt ani', 'Aliquam officiis ius', 'Deserunt cupidatat u', 18, 'Omnis labore dolorum', 'Deserunt qui volupta', 'Irure ducimus ipsum', 'Quis illo minus susc', 4, 'Voluptas dolores sed', 'Voluptas sint nihil', 'Nam dolores quibusda', 'Doloribus fugiat con', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'In voluptas lorem es', 'Et dolor nihil ad al', NULL, NULL, NULL, NULL, 'https://www.hoxyki.in', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-26 11:47:19', '2025-08-26 17:47:19', NULL, 1),
(65, NULL, NULL, 'Test Package 01', 'test-package-01', 2000.00, 500.00, 1500.00, 200.00, 0, 0, 1, 0, '[\"art-crafts\",\"boat-cruise\",\"cycling-camping\",\"folk-festivals\",\"trailing-walking\",\"adventure-sports\",\"photography-tours\",\"religious-sites\",\"beach-coastal\"]', '2019-05-06', '2025-08-27', 3, 'Quasi in repellendus', 'Et nihil consectetur', 'Molestiae magna nemo', 'Rerum consequatur ut', 'Ut ipsam dolorum rec', 'Dolorem et dolore au', 61, 'At ea tempor tempor', 'Quia est consequat', 'Nulla saepe voluptas', 'Tempor et mollitia s', 4, 'Officia eius quis et', 'Quia aspernatur illu', 'Quod suscipit minim', 'Esse facere sint od', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Labore excepturi tem', 'Labore animi veniam', NULL, NULL, NULL, NULL, 'https://www.meguwy.co', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, '2025-08-27 08:01:41', '2025-08-27 16:05:04', NULL, 1),
(66, NULL, NULL, 'Evangeline Nguyen', 'evangeline-nguyen-2025-08-27-160614', 601.00, 491.00, 110.00, 62.00, 1, 0, 1, 1, '\"[\\\"boat-cruise\\\",\\\"history-heritage\\\",\\\"photography-tours\\\"]\"', '2008-06-04', '2025-08-27', 4, 'Minima ut nisi volup', 'Temporibus autem eiu', 'Mollitia exercitatio', 'Eiusmod culpa fugiat', 'Rerum et aut error e', 'Sunt cupidatat qui', 31, 'Quis velit nostrum c', 'Quasi possimus cons', 'Saepe magni eos culp', 'Assumenda dolor quo', 4, 'Voluptas enim ipsum', 'Quidem voluptas earu', 'Facilis sed quas ill', 'Est officia occaecat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Distinctio Ipsa po', 'Deserunt culpa odit', NULL, NULL, NULL, NULL, 'https://www.ziducu.cc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2025-08-27 10:06:14', '2025-08-27 16:06:14', NULL, 1);

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

--
-- Table structure for table `tour_package_activities`
--

CREATE TABLE `tour_package_activities` (
  `id` int(11) NOT NULL,
  `tour_package_id` int(11) DEFAULT NULL,
  `tour_activity_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tour_types`
--

CREATE TABLE `tour_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tour_types`
--

INSERT INTO `tour_types` (`id`, `name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'tour type 01', 'fer', '2025-08-20 10:33:03', NULL, NULL),
(2, 'tour type 02', 'fer', '2025-08-20 10:33:13', NULL, NULL),
(3, 'Benedict Salazar', 'Nisi a minim cupidit', '2025-08-23 08:50:06', '2025-08-23 14:50:06', NULL),
(4, 'Oprah Marquez', 'Sed rerum aliquam in', '2025-08-23 08:50:10', '2025-08-23 14:50:10', NULL),
(5, 'Erich Beach', 'Aut in sint rerum u', '2025-08-23 08:50:14', '2025-08-23 14:50:14', NULL),
(7, 'Hedda Tran', 'Aperiam expedita adi', '2025-08-23 08:50:58', '2025-08-23 14:50:58', NULL),
(8, 'Christopher Simmons', 'Reiciendis qui volup', '2025-08-23 08:51:02', '2025-08-23 14:51:02', NULL),
(9, 'Jonas Torres', 'Sapiente officiis si', '2025-08-23 08:51:06', '2025-08-23 14:51:06', NULL);

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

--
-- Table structure for table `transaction_types`
--

CREATE TABLE `transaction_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL COMMENT 'Name of the transaction type (e.g., Issue, Receive, Debit Note, Credit Note)',
  `description` text DEFAULT NULL COMMENT 'Detailed explanation of the transaction type',
  `is_active` tinyint(1) DEFAULT 1 COMMENT 'Status: true = active, false = inactive',
  `created_by` bigint(20) DEFAULT NULL COMMENT 'User who created this type',
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transportations`
--

CREATE TABLE `transportations` (
  `id` int(11) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `is_ac` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transportations`
--

INSERT INTO `transportations` (`id`, `type`, `is_ac`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Nihil et aut nulla c', 0, '2025-08-24 11:53:54', '2025-08-24 17:53:54', NULL);

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

--
-- Table structure for table `travel_points`
--

CREATE TABLE `travel_points` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `full_address` varchar(255) DEFAULT NULL COMMENT 'Human-readable location name (e.g., New York, Times Square)',
  `description` text DEFAULT NULL,
  `location_url` varchar(500) DEFAULT NULL COMMENT 'Link to location on map services like Google Maps',
  `latitude` decimal(10,8) DEFAULT NULL COMMENT 'Latitude coordinate (max precision ~1mm)',
  `longitude` decimal(11,8) DEFAULT NULL COMMENT 'Longitude coordinate (max precision ~1mm)',
  `country_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `area_id` int(11) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `travel_points`
--

INSERT INTO `travel_points` (`id`, `name`, `full_address`, `description`, `location_url`, `latitude`, `longitude`, `country_id`, `city_id`, `area_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, 'Uttara Sector 12', 'Uttara Sector 12', 'Uttara Sector 12', 'Uttara Sector 12', 99.99999999, 999.99999999, 1, 1, 1, 1, NULL, '2025-08-20 10:36:54', NULL, NULL);

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

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `emergency_name` varchar(150) DEFAULT NULL,
  `emergency_relation` varchar(100) DEFAULT NULL,
  `emergency_phone` varchar(20) DEFAULT NULL,
  `emergency_email` varchar(150) DEFAULT NULL,
  `preferred_language` varchar(50) DEFAULT NULL,
  `dietary_restrictions` varchar(50) DEFAULT NULL,
  `special_requests` text DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `area_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `designation` varchar(150) DEFAULT NULL,
  `email_notifications` tinyint(1) DEFAULT 1,
  `marketing_updates` tinyint(1) DEFAULT 0,
  `joined_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`id`, `user_id`, `address`, `date_of_birth`, `nationality`, `emergency_name`, `emergency_relation`, `emergency_phone`, `emergency_email`, `preferred_language`, `dietary_restrictions`, `special_requests`, `country_id`, `city_id`, `area_id`, `description`, `designation`, `email_notifications`, `marketing_updates`, `joined_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-08-27 18:20:51', '2025-08-27 18:20:51', NULL),
(2, 2, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-08-27 18:20:51', '2025-08-27 18:20:51', NULL),
(3, 3, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-08-27 18:20:51', '2025-08-27 18:20:51', NULL),
(4, NULL, 'Nulla vel quo labore', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 203, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-08-27 22:16:21', '2025-08-27 22:16:21', NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `areas`
--
ALTER TABLE `areas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `city_id` (`city_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`),
  ADD UNIQUE KEY `booking_no` (`booking_no`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `tour_package_id` (`tour_package_id`),
  ADD KEY `custom_package_requests_id` (`custom_package_requests_id`),
  ADD KEY `service_requests_id` (`service_requests_id`),
  ADD KEY `tour_guide_id` (`tour_guide_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `country_id` (`country_id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Indexes for table `coupon`
--
ALTER TABLE `coupon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `customer_details`
--
ALTER TABLE `customer_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customer_id` (`customer_id`),
  ADD KEY `country_id` (`country_id`),
  ADD KEY `city_id` (`city_id`),
  ADD KEY `area_id` (`area_id`);

--
-- Indexes for table `custom_package_requests`
--
ALTER TABLE `custom_package_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `tour_type_id` (`tour_type_id`),
  ADD KEY `travel_point_id` (`travel_point_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `deals`
--
ALTER TABLE `deals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_package_requests_id` (`custom_package_requests_id`),
  ADD KEY `service_requests_id` (`service_requests_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

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

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

--
-- Indexes for table `feedback_logs`
--
ALTER TABLE `feedback_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_package_id` (`tour_package_id`),
  ADD KEY `custom_package_requests_id` (`custom_package_requests_id`),
  ADD KEY `service_package_requests_id` (`service_package_requests_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

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

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

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

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `iso_code` (`iso_code`);

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD KEY `permission_id` (`permission_id`),
  ADD KEY `model_id` (`model_id`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD KEY `role_id` (`role_id`),
  ADD KEY `model_id` (`model_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `trans_no` (`trans_no`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `booking_id` (`booking_id`),
  ADD KEY `trans_type_id` (`trans_type_id`),
  ADD KEY `payment_methods_id` (`payment_methods_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `payment_details`
--
ALTER TABLE `payment_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_id` (`payment_id`),
  ADD UNIQUE KEY `receipt_no` (`receipt_no`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token` (`token`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `post_categories`
--
ALTER TABLE `post_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `slug` (`slug`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `tour_package_id` (`tour_package_id`);

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD KEY `permission_id` (`permission_id`),
  ADD KEY `role_id` (`role_id`);

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

--
-- Indexes for table `service_requests`
--
ALTER TABLE `service_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `service_type_id` (`service_type_id`),
  ADD KEY `travel_point_id` (`travel_point_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `service_types`
--
ALTER TABLE `service_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

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

--
-- Indexes for table `tour_guides`
--
ALTER TABLE `tour_guides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `team_id` (`team_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `tour_images`
--
ALTER TABLE `tour_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_package_id` (`tour_package_id`);

--
-- Indexes for table `tour_itineraries`
--
ALTER TABLE `tour_itineraries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_package_id` (`tour_package_id`),
  ADD KEY `custom_package_requests_id` (`custom_package_requests_id`),
  ADD KEY `service_package_requests_id` (`service_package_requests_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `tour_packages`
--
ALTER TABLE `tour_packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_type_id` (`tour_type_id`),
  ADD KEY `travel_point_id` (`travel_point_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `tour_package_activities`
--
ALTER TABLE `tour_package_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_package_id` (`tour_package_id`),
  ADD KEY `tour_activity_id` (`tour_activity_id`);

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

--
-- Indexes for table `transaction_types`
--
ALTER TABLE `transaction_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

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

--
-- Indexes for table `travel_points`
--
ALTER TABLE `travel_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `country_id` (`country_id`),
  ADD KEY `city_id` (`city_id`),
  ADD KEY `area_id` (`area_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `updated_by` (`updated_by`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `country_id` (`country_id`),
  ADD KEY `city_id` (`city_id`),
  ADD KEY `area_id` (`area_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '1=Cash, 2=Bank Transfer, 3=Card - Paypal etc.', AUTO_INCREMENT=6;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `areas`
--
ALTER TABLE `areas`
  ADD CONSTRAINT `areas_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`);

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `bookings_ibfk_2` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`),
  ADD CONSTRAINT `bookings_ibfk_3` FOREIGN KEY (`custom_package_requests_id`) REFERENCES `custom_package_requests` (`id`),
  ADD CONSTRAINT `bookings_ibfk_4` FOREIGN KEY (`service_requests_id`) REFERENCES `service_requests` (`id`),
  ADD CONSTRAINT `bookings_ibfk_5` FOREIGN KEY (`tour_guide_id`) REFERENCES `tour_guides` (`id`),
  ADD CONSTRAINT `bookings_ibfk_6` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `bookings_ibfk_7` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`);

--
-- Constraints for table `coupon`
--
ALTER TABLE `coupon`
  ADD CONSTRAINT `coupon_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `coupon_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `customer_details`
--
ALTER TABLE `customer_details`
  ADD CONSTRAINT `customer_details_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `customer_details_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `customer_details_ibfk_3` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `customer_details_ibfk_4` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`);

--
-- Constraints for table `custom_package_requests`
--
ALTER TABLE `custom_package_requests`
  ADD CONSTRAINT `custom_package_requests_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `custom_package_requests_ibfk_2` FOREIGN KEY (`tour_type_id`) REFERENCES `tour_types` (`id`),
  ADD CONSTRAINT `custom_package_requests_ibfk_3` FOREIGN KEY (`travel_point_id`) REFERENCES `travel_points` (`id`),
  ADD CONSTRAINT `custom_package_requests_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `custom_package_requests_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `deals`
--
ALTER TABLE `deals`
  ADD CONSTRAINT `deals_ibfk_1` FOREIGN KEY (`custom_package_requests_id`) REFERENCES `custom_package_requests` (`id`),
  ADD CONSTRAINT `deals_ibfk_2` FOREIGN KEY (`service_requests_id`) REFERENCES `service_requests` (`id`),
  ADD CONSTRAINT `deals_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `deals_ibfk_4` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `deals_ibfk_5` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `deals_ibfk_6` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `feedback_logs`
--
ALTER TABLE `feedback_logs`
  ADD CONSTRAINT `feedback_logs_ibfk_1` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`),
  ADD CONSTRAINT `feedback_logs_ibfk_2` FOREIGN KEY (`custom_package_requests_id`) REFERENCES `custom_package_requests` (`id`),
  ADD CONSTRAINT `feedback_logs_ibfk_3` FOREIGN KEY (`service_package_requests_id`) REFERENCES `service_requests` (`id`),
  ADD CONSTRAINT `feedback_logs_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `feedback_logs_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  ADD CONSTRAINT `model_has_permissions_ibfk_2` FOREIGN KEY (`model_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `payments_ibfk_2` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`),
  ADD CONSTRAINT `payments_ibfk_3` FOREIGN KEY (`trans_type_id`) REFERENCES `transaction_types` (`id`),
  ADD CONSTRAINT `payments_ibfk_4` FOREIGN KEY (`payment_methods_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `payments_ibfk_5` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `payments_ibfk_6` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `payment_details`
--
ALTER TABLE `payment_details`
  ADD CONSTRAINT `payment_details_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`);

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `post_categories` (`id`),
  ADD CONSTRAINT `posts_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `posts_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`);

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  ADD CONSTRAINT `role_has_permissions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `service_requests`
--
ALTER TABLE `service_requests`
  ADD CONSTRAINT `service_requests_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `service_requests_ibfk_2` FOREIGN KEY (`service_type_id`) REFERENCES `service_types` (`id`),
  ADD CONSTRAINT `service_requests_ibfk_3` FOREIGN KEY (`travel_point_id`) REFERENCES `travel_points` (`id`),
  ADD CONSTRAINT `service_requests_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `service_requests_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `service_types`
--
ALTER TABLE `service_types`
  ADD CONSTRAINT `service_types_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `service_types_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `sessions`
--
ALTER TABLE `sessions`
  ADD CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `tour_images`
--
ALTER TABLE `tour_images`
  ADD CONSTRAINT `tour_images_ibfk_1` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`);

--
-- Constraints for table `tour_itineraries`
--
ALTER TABLE `tour_itineraries`
  ADD CONSTRAINT `tour_itineraries_ibfk_1` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`),
  ADD CONSTRAINT `tour_itineraries_ibfk_2` FOREIGN KEY (`custom_package_requests_id`) REFERENCES `custom_package_requests` (`id`),
  ADD CONSTRAINT `tour_itineraries_ibfk_3` FOREIGN KEY (`service_package_requests_id`) REFERENCES `service_requests` (`id`),
  ADD CONSTRAINT `tour_itineraries_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tour_itineraries_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `tour_packages`
--
ALTER TABLE `tour_packages`
  ADD CONSTRAINT `tour_packages_ibfk_1` FOREIGN KEY (`tour_type_id`) REFERENCES `tour_types` (`id`),
  ADD CONSTRAINT `tour_packages_ibfk_2` FOREIGN KEY (`travel_point_id`) REFERENCES `travel_points` (`id`),
  ADD CONSTRAINT `tour_packages_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tour_packages_ibfk_4` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `tour_package_activities`
--
ALTER TABLE `tour_package_activities`
  ADD CONSTRAINT `tour_package_activities_ibfk_1` FOREIGN KEY (`tour_package_id`) REFERENCES `tour_packages` (`id`),
  ADD CONSTRAINT `tour_package_activities_ibfk_2` FOREIGN KEY (`tour_activity_id`) REFERENCES `tour_activities` (`id`);

--
-- Constraints for table `transaction_types`
--
ALTER TABLE `transaction_types`
  ADD CONSTRAINT `transaction_types_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `transaction_types_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `travel_points`
--
ALTER TABLE `travel_points`
  ADD CONSTRAINT `travel_points_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `travel_points_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `travel_points_ibfk_3` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`),
  ADD CONSTRAINT `travel_points_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `travel_points_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `user_details`
--
ALTER TABLE `user_details`
  ADD CONSTRAINT `user_details_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `user_details_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `user_details_ibfk_3` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `user_details_ibfk_4` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`);
COMMIT;

