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

-- Disable foreign key checks

START TRANSACTION;



--
-- Database: `unbound_bd`
--

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

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

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

--
-- 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-10-15 14:36:13', '2025-10-15 20:36:13', NULL),
(2, 1, 'Katakhali', '2025-10-15 14:37:34', '2025-10-15 20:37:34', 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
(1, '#ORD0000001', 1, 1, NULL, NULL, '#BK0000001', '2025-10-15', '2025-10-15', 'Rajshahi, 01 road', 'Rajshahi, 01 road', 10, 0, 10, 20000.00, 19600.00, 400.00, NULL, 1600.00, 18000.00, NULL, 1, 1, NULL, 4, 1, 1, 1, '2025-10-15 14:52:16', '2025-10-15 21:17:15', NULL);

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

--
-- Table structure for table `booking_feedbacks`
--

CREATE TABLE `booking_feedbacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_id` bigint(20) UNSIGNED NOT NULL,
  `day_number` int(11) NOT NULL,
  `activities_completed` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`activities_completed`)),
  `comments` text DEFAULT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_feedbacks`
--

INSERT INTO `booking_feedbacks` (`id`, `booking_id`, `day_number`, `activities_completed`, `comments`, `submitted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '\"[\\\"Day 1 Add Feedback Logs 01\\\",\\\"Day 1 Add Feedback Logs 02\\\",\\\"Day 1 Add Feedback Logs 03\\\"]\"', 'Day 01 Tour Calendar feedback. Good service.', '2025-10-15 15:02:44', '2025-10-15 15:02:44', '2025-10-15 15:02:44');

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

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

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('unboundbd-cache-spatie.permission.cache', 'a:3:{s:5:\"alias\";a:7:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:5:\"alias\";s:1:\"d\";s:5:\"group\";s:1:\"e\";s:10:\"guard_name\";s:1:\"r\";s:5:\"roles\";s:1:\"j\";s:5:\"title\";}s:11:\"permissions\";a:163:{i:0;a:6:{s:1:\"a\";i:1;s:1:\"b\";s:14:\"dashboard-view\";s:1:\"c\";s:14:\"View Dashboard\";s:1:\"d\";s:9:\"Dashboard\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:1;a:6:{s:1:\"a\";i:2;s:1:\"b\";s:12:\"profile-view\";s:1:\"c\";s:30:\"View Profile User Profile Page\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:2;a:6:{s:1:\"a\";i:3;s:1:\"b\";s:12:\"profile-edit\";s:1:\"c\";s:12:\"Edit Profile\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:3;a:6:{s:1:\"a\";i:4;s:1:\"b\";s:20:\"profile-update-photo\";s:1:\"c\";s:20:\"Update Profile Photo\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:4;a:6:{s:1:\"a\";i:5;s:1:\"b\";s:23:\"profile-update-password\";s:1:\"c\";s:15:\"Update Password\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:5;a:6:{s:1:\"a\";i:6;s:1:\"b\";s:22:\"profile-delete-account\";s:1:\"c\";s:14:\"Delete Account\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:6;a:6:{s:1:\"a\";i:7;s:1:\"b\";s:28:\"profile-manage-notifications\";s:1:\"c\";s:20:\"Manage Notifications\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:7;a:6:{s:1:\"a\";i:8;s:1:\"b\";s:25:\"profile-toggle-two-factor\";s:1:\"c\";s:17:\"Toggle Two Factor\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:8;a:6:{s:1:\"a\";i:9;s:1:\"b\";s:14:\"profile-export\";s:1:\"c\";s:14:\"Export Profile\";s:1:\"d\";s:7:\"Profile\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:9;a:6:{s:1:\"a\";i:10;s:1:\"b\";s:12:\"booking-list\";s:1:\"c\";s:13:\"View Bookings\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:10;a:6:{s:1:\"a\";i:11;s:1:\"b\";s:14:\"booking-create\";s:1:\"c\";s:15:\"Create Bookings\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:11;a:6:{s:1:\"a\";i:12;s:1:\"b\";s:12:\"booking-view\";s:1:\"c\";s:20:\"View Booking Details\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:12;a:6:{s:1:\"a\";i:13;s:1:\"b\";s:12:\"booking-edit\";s:1:\"c\";s:13:\"Edit Bookings\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:13;a:6:{s:1:\"a\";i:14;s:1:\"b\";s:11:\"assign-team\";s:1:\"c\";s:28:\"Assign Tour Guide to Booking\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:14;a:6:{s:1:\"a\";i:15;s:1:\"b\";s:19:\"change-order-status\";s:1:\"c\";s:32:\"Change Order Status to a Booking\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:15;a:6:{s:1:\"a\";i:16;s:1:\"b\";s:14:\"booking-delete\";s:1:\"c\";s:15:\"Delete Bookings\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:16;a:6:{s:1:\"a\";i:17;s:1:\"b\";s:20:\"booking-set-discount\";s:1:\"c\";s:20:\"Set Booking Discount\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:17;a:6:{s:1:\"a\";i:18;s:1:\"b\";s:11:\"booking-pay\";s:1:\"c\";s:20:\"Make Booking Payment\";s:1:\"d\";s:8:\"Bookings\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:18;a:6:{s:1:\"a\";i:19;s:1:\"b\";s:12:\"payment-list\";s:1:\"c\";s:13:\"View Payments\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:19;a:6:{s:1:\"a\";i:20;s:1:\"b\";s:14:\"payment-create\";s:1:\"c\";s:15:\"Create Payments\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:20;a:6:{s:1:\"a\";i:21;s:1:\"b\";s:12:\"payment-view\";s:1:\"c\";s:20:\"View Payment Details\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:21;a:6:{s:1:\"a\";i:22;s:1:\"b\";s:12:\"payment-edit\";s:1:\"c\";s:13:\"Edit Payments\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:22;a:6:{s:1:\"a\";i:23;s:1:\"b\";s:14:\"payment-delete\";s:1:\"c\";s:15:\"Delete Payments\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:23;a:6:{s:1:\"a\";i:24;s:1:\"b\";s:20:\"payment-view-receipt\";s:1:\"c\";s:20:\"View Payment Receipt\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:24;a:6:{s:1:\"a\";i:25;s:1:\"b\";s:19:\"payment-receipt-pdf\";s:1:\"c\";s:30:\"Download/Print Payment Receipt\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:25;a:6:{s:1:\"a\";i:26;s:1:\"b\";s:14:\"payment-refund\";s:1:\"c\";s:19:\"Make Payment Refund\";s:1:\"d\";s:8:\"Payments\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:26;a:6:{s:1:\"a\";i:27;s:1:\"b\";s:11:\"coupon-list\";s:1:\"c\";s:12:\"View Coupons\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:27;a:6:{s:1:\"a\";i:28;s:1:\"b\";s:13:\"coupon-create\";s:1:\"c\";s:14:\"Create Coupons\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:28;a:6:{s:1:\"a\";i:29;s:1:\"b\";s:11:\"coupon-view\";s:1:\"c\";s:19:\"View Coupon Details\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:29;a:6:{s:1:\"a\";i:30;s:1:\"b\";s:11:\"coupon-edit\";s:1:\"c\";s:12:\"Edit Coupons\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:30;a:6:{s:1:\"a\";i:31;s:1:\"b\";s:13:\"coupon-delete\";s:1:\"c\";s:14:\"Delete Coupons\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:31;a:6:{s:1:\"a\";i:32;s:1:\"b\";s:27:\"coupon-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:7:\"Coupons\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:32;a:6:{s:1:\"a\";i:33;s:1:\"b\";s:17:\"tour-package-list\";s:1:\"c\";s:18:\"View Tour Packages\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:33;a:6:{s:1:\"a\";i:34;s:1:\"b\";s:19:\"tour-package-create\";s:1:\"c\";s:20:\"Create Tour Packages\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:34;a:6:{s:1:\"a\";i:35;s:1:\"b\";s:17:\"tour-package-view\";s:1:\"c\";s:25:\"View Tour Package Details\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:35;a:6:{s:1:\"a\";i:36;s:1:\"b\";s:17:\"tour-package-edit\";s:1:\"c\";s:18:\"Edit Tour Packages\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:36;a:6:{s:1:\"a\";i:37;s:1:\"b\";s:19:\"tour-package-delete\";s:1:\"c\";s:20:\"Delete Tour Packages\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:37;a:6:{s:1:\"a\";i:38;s:1:\"b\";s:33:\"tour-package-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:13:\"Tour Packages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:38;a:6:{s:1:\"a\";i:39;s:1:\"b\";s:13:\"customer-list\";s:1:\"c\";s:14:\"View Customers\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:39;a:6:{s:1:\"a\";i:40;s:1:\"b\";s:15:\"customer-create\";s:1:\"c\";s:16:\"Create Customers\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:40;a:6:{s:1:\"a\";i:41;s:1:\"b\";s:13:\"customer-view\";s:1:\"c\";s:21:\"View Customer Details\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:41;a:6:{s:1:\"a\";i:42;s:1:\"b\";s:13:\"customer-edit\";s:1:\"c\";s:14:\"Edit Customers\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:42;a:6:{s:1:\"a\";i:43;s:1:\"b\";s:15:\"customer-delete\";s:1:\"c\";s:16:\"Delete Customers\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:43;a:6:{s:1:\"a\";i:44;s:1:\"b\";s:29:\"customer-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:9:\"Customers\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:44;a:6:{s:1:\"a\";i:45;s:1:\"b\";s:27:\"custom-package-request-list\";s:1:\"c\";s:33:\"View Custom Package Requests List\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:45;a:6:{s:1:\"a\";i:46;s:1:\"b\";s:29:\"custom-package-request-create\";s:1:\"c\";s:30:\"Create Custom Package Requests\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:46;a:6:{s:1:\"a\";i:47;s:1:\"b\";s:27:\"custom-package-request-edit\";s:1:\"c\";s:28:\"Edit Custom Package Requests\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:47;a:6:{s:1:\"a\";i:48;s:1:\"b\";s:27:\"custom-package-request-view\";s:1:\"c\";s:35:\"View Custom Package Request Details\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:48;a:6:{s:1:\"a\";i:49;s:1:\"b\";s:29:\"custom-package-request-delete\";s:1:\"c\";s:30:\"Delete Custom Package Requests\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:49;a:6:{s:1:\"a\";i:50;s:1:\"b\";s:43:\"custom-package-request-change-active-status\";s:1:\"c\";s:43:\"Change Custom Package Request Active Status\";s:1:\"d\";s:23:\"Custom Package Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:50;a:6:{s:1:\"a\";i:51;s:1:\"b\";s:20:\"service-request-list\";s:1:\"c\";s:26:\"View Service Requests List\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:51;a:6:{s:1:\"a\";i:52;s:1:\"b\";s:22:\"service-request-create\";s:1:\"c\";s:23:\"Create Service Requests\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:52;a:6:{s:1:\"a\";i:53;s:1:\"b\";s:20:\"service-request-view\";s:1:\"c\";s:28:\"View Service Request Details\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:53;a:6:{s:1:\"a\";i:54;s:1:\"b\";s:20:\"service-request-edit\";s:1:\"c\";s:21:\"Edit Service Requests\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:54;a:6:{s:1:\"a\";i:55;s:1:\"b\";s:22:\"service-request-delete\";s:1:\"c\";s:23:\"Delete Service Requests\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:55;a:6:{s:1:\"a\";i:56;s:1:\"b\";s:36:\"service-request-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:16:\"Service Requests\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:56;a:6:{s:1:\"a\";i:57;s:1:\"b\";s:18:\"post-category-list\";s:1:\"c\";s:25:\"View Post Categories List\";s:1:\"d\";s:15:\"Post Categories\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:57;a:6:{s:1:\"a\";i:58;s:1:\"b\";s:20:\"post-category-create\";s:1:\"c\";s:22:\"Create Post Categories\";s:1:\"d\";s:15:\"Post Categories\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:58;a:6:{s:1:\"a\";i:59;s:1:\"b\";s:18:\"post-category-view\";s:1:\"c\";s:26:\"View Post Category Details\";s:1:\"d\";s:15:\"Post Categories\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:59;a:6:{s:1:\"a\";i:60;s:1:\"b\";s:18:\"post-category-edit\";s:1:\"c\";s:20:\"Edit Post Categories\";s:1:\"d\";s:15:\"Post Categories\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:60;a:6:{s:1:\"a\";i:61;s:1:\"b\";s:20:\"post-category-delete\";s:1:\"c\";s:22:\"Delete Post Categories\";s:1:\"d\";s:15:\"Post Categories\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:61;a:6:{s:1:\"a\";i:62;s:1:\"b\";s:9:\"post-list\";s:1:\"c\";s:15:\"View Posts List\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:62;a:6:{s:1:\"a\";i:63;s:1:\"b\";s:11:\"post-create\";s:1:\"c\";s:12:\"Create Posts\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:63;a:6:{s:1:\"a\";i:64;s:1:\"b\";s:9:\"post-view\";s:1:\"c\";s:17:\"View Post Details\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:64;a:6:{s:1:\"a\";i:65;s:1:\"b\";s:9:\"post-edit\";s:1:\"c\";s:10:\"Edit Posts\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:65;a:6:{s:1:\"a\";i:66;s:1:\"b\";s:11:\"post-delete\";s:1:\"c\";s:12:\"Delete Posts\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:66;a:6:{s:1:\"a\";i:67;s:1:\"b\";s:25:\"post-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:5:\"Posts\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:67;a:6:{s:1:\"a\";i:68;s:1:\"b\";s:19:\"landing-banner-list\";s:1:\"c\";s:30:\"View Landing Page Banners List\";s:1:\"d\";s:20:\"Landing Page Banners\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:68;a:6:{s:1:\"a\";i:69;s:1:\"b\";s:21:\"landing-banner-create\";s:1:\"c\";s:27:\"Create Landing Page Banners\";s:1:\"d\";s:20:\"Landing Page Banners\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:69;a:6:{s:1:\"a\";i:70;s:1:\"b\";s:19:\"landing-banner-edit\";s:1:\"c\";s:25:\"Edit Landing Page Banners\";s:1:\"d\";s:20:\"Landing Page Banners\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:70;a:6:{s:1:\"a\";i:71;s:1:\"b\";s:21:\"landing-banner-delete\";s:1:\"c\";s:27:\"Delete Landing Page Banners\";s:1:\"d\";s:20:\"Landing Page Banners\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:71;a:6:{s:1:\"a\";i:72;s:1:\"b\";s:35:\"landing-banner-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:20:\"Landing Page Banners\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:72;a:6:{s:1:\"a\";i:73;s:1:\"b\";s:13:\"language-list\";s:1:\"c\";s:19:\"View Languages List\";s:1:\"d\";s:9:\"Languages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:73;a:6:{s:1:\"a\";i:74;s:1:\"b\";s:15:\"language-create\";s:1:\"c\";s:16:\"Create Languages\";s:1:\"d\";s:9:\"Languages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:74;a:6:{s:1:\"a\";i:75;s:1:\"b\";s:13:\"language-edit\";s:1:\"c\";s:14:\"Edit Languages\";s:1:\"d\";s:9:\"Languages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:75;a:6:{s:1:\"a\";i:76;s:1:\"b\";s:13:\"language-view\";s:1:\"c\";s:21:\"View Language Details\";s:1:\"d\";s:9:\"Languages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:76;a:6:{s:1:\"a\";i:77;s:1:\"b\";s:15:\"language-delete\";s:1:\"c\";s:16:\"Delete Languages\";s:1:\"d\";s:9:\"Languages\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:77;a:6:{s:1:\"a\";i:78;s:1:\"b\";s:19:\"payment-method-list\";s:1:\"c\";s:20:\"View Payment Methods\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:78;a:6:{s:1:\"a\";i:79;s:1:\"b\";s:21:\"payment-method-create\";s:1:\"c\";s:22:\"Create Payment Methods\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:79;a:6:{s:1:\"a\";i:80;s:1:\"b\";s:19:\"payment-method-view\";s:1:\"c\";s:27:\"View Payment Method Details\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:80;a:6:{s:1:\"a\";i:81;s:1:\"b\";s:19:\"payment-method-edit\";s:1:\"c\";s:20:\"Edit Payment Methods\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:81;a:6:{s:1:\"a\";i:82;s:1:\"b\";s:21:\"payment-method-delete\";s:1:\"c\";s:22:\"Delete Payment Methods\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:82;a:6:{s:1:\"a\";i:83;s:1:\"b\";s:35:\"payment-method-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:15:\"Payment Methods\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:83;a:6:{s:1:\"a\";i:84;s:1:\"b\";s:15:\"permission-list\";s:1:\"c\";s:21:\"View Permissions List\";s:1:\"d\";s:11:\"Permissions\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:84;a:6:{s:1:\"a\";i:85;s:1:\"b\";s:9:\"role-list\";s:1:\"c\";s:15:\"View Roles List\";s:1:\"d\";s:5:\"Roles\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:85;a:6:{s:1:\"a\";i:86;s:1:\"b\";s:11:\"role-create\";s:1:\"c\";s:12:\"Create Roles\";s:1:\"d\";s:5:\"Roles\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:86;a:6:{s:1:\"a\";i:87;s:1:\"b\";s:9:\"role-view\";s:1:\"c\";s:17:\"View Role Details\";s:1:\"d\";s:5:\"Roles\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:87;a:6:{s:1:\"a\";i:88;s:1:\"b\";s:9:\"role-edit\";s:1:\"c\";s:10:\"Edit Roles\";s:1:\"d\";s:5:\"Roles\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:88;a:6:{s:1:\"a\";i:89;s:1:\"b\";s:11:\"role-delete\";s:1:\"c\";s:12:\"Delete Roles\";s:1:\"d\";s:5:\"Roles\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:89;a:6:{s:1:\"a\";i:90;s:1:\"b\";s:17:\"service-type-list\";s:1:\"c\";s:23:\"View Service Types List\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:90;a:6:{s:1:\"a\";i:91;s:1:\"b\";s:19:\"service-type-create\";s:1:\"c\";s:20:\"Create Service Types\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:91;a:6:{s:1:\"a\";i:92;s:1:\"b\";s:17:\"service-type-view\";s:1:\"c\";s:25:\"View Service Type Details\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:92;a:6:{s:1:\"a\";i:93;s:1:\"b\";s:17:\"service-type-edit\";s:1:\"c\";s:18:\"Edit Service Types\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:93;a:6:{s:1:\"a\";i:94;s:1:\"b\";s:19:\"service-type-delete\";s:1:\"c\";s:20:\"Delete Service Types\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:94;a:6:{s:1:\"a\";i:95;s:1:\"b\";s:33:\"service-type-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:13:\"Service Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:95;a:6:{s:1:\"a\";i:96;s:1:\"b\";s:9:\"team-list\";s:1:\"c\";s:15:\"View Teams List\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:96;a:6:{s:1:\"a\";i:97;s:1:\"b\";s:11:\"team-create\";s:1:\"c\";s:12:\"Create Teams\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:97;a:6:{s:1:\"a\";i:98;s:1:\"b\";s:9:\"team-view\";s:1:\"c\";s:17:\"View Team Details\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:98;a:6:{s:1:\"a\";i:99;s:1:\"b\";s:9:\"team-edit\";s:1:\"c\";s:10:\"Edit Teams\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:99;a:6:{s:1:\"a\";i:100;s:1:\"b\";s:11:\"team-delete\";s:1:\"c\";s:12:\"Delete Teams\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:100;a:6:{s:1:\"a\";i:101;s:1:\"b\";s:25:\"team-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:5:\"Teams\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:101;a:6:{s:1:\"a\";i:102;s:1:\"b\";s:18:\"tour-activity-list\";s:1:\"c\";s:25:\"View Tour Activities List\";s:1:\"d\";s:15:\"Tour Activities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:102;a:6:{s:1:\"a\";i:103;s:1:\"b\";s:20:\"tour-activity-create\";s:1:\"c\";s:22:\"Create Tour Activities\";s:1:\"d\";s:15:\"Tour Activities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:103;a:6:{s:1:\"a\";i:104;s:1:\"b\";s:18:\"tour-activity-view\";s:1:\"c\";s:26:\"View Tour Activity Details\";s:1:\"d\";s:15:\"Tour Activities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:104;a:6:{s:1:\"a\";i:105;s:1:\"b\";s:18:\"tour-activity-edit\";s:1:\"c\";s:20:\"Edit Tour Activities\";s:1:\"d\";s:15:\"Tour Activities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:105;a:6:{s:1:\"a\";i:106;s:1:\"b\";s:20:\"tour-activity-delete\";s:1:\"c\";s:22:\"Delete Tour Activities\";s:1:\"d\";s:15:\"Tour Activities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:106;a:6:{s:1:\"a\";i:107;s:1:\"b\";s:15:\"tour-guide-list\";s:1:\"c\";s:21:\"View Tour Guides List\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:107;a:6:{s:1:\"a\";i:108;s:1:\"b\";s:17:\"tour-guide-create\";s:1:\"c\";s:18:\"Create Tour Guides\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:108;a:6:{s:1:\"a\";i:109;s:1:\"b\";s:15:\"tour-guide-view\";s:1:\"c\";s:23:\"View Tour Guide Details\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:109;a:6:{s:1:\"a\";i:110;s:1:\"b\";s:15:\"tour-guide-edit\";s:1:\"c\";s:16:\"Edit Tour Guides\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:110;a:6:{s:1:\"a\";i:111;s:1:\"b\";s:17:\"tour-guide-delete\";s:1:\"c\";s:18:\"Delete Tour Guides\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:111;a:6:{s:1:\"a\";i:112;s:1:\"b\";s:31:\"tour-guide-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:11:\"Tour Guides\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:112;a:6:{s:1:\"a\";i:113;s:1:\"b\";s:14:\"tour-type-list\";s:1:\"c\";s:20:\"View Tour Types List\";s:1:\"d\";s:10:\"Tour Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:113;a:6:{s:1:\"a\";i:114;s:1:\"b\";s:16:\"tour-type-create\";s:1:\"c\";s:17:\"Create Tour Types\";s:1:\"d\";s:10:\"Tour Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:114;a:6:{s:1:\"a\";i:115;s:1:\"b\";s:14:\"tour-type-view\";s:1:\"c\";s:22:\"View Tour Type Details\";s:1:\"d\";s:10:\"Tour Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:115;a:6:{s:1:\"a\";i:116;s:1:\"b\";s:14:\"tour-type-edit\";s:1:\"c\";s:15:\"Edit Tour Types\";s:1:\"d\";s:10:\"Tour Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:116;a:6:{s:1:\"a\";i:117;s:1:\"b\";s:16:\"tour-type-delete\";s:1:\"c\";s:17:\"Delete Tour Types\";s:1:\"d\";s:10:\"Tour Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:117;a:6:{s:1:\"a\";i:118;s:1:\"b\";s:21:\"transaction-type-list\";s:1:\"c\";s:27:\"View Transaction Types List\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:118;a:6:{s:1:\"a\";i:119;s:1:\"b\";s:23:\"transaction-type-create\";s:1:\"c\";s:24:\"Create Transaction Types\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:119;a:6:{s:1:\"a\";i:120;s:1:\"b\";s:21:\"transaction-type-view\";s:1:\"c\";s:29:\"View Transaction Type Details\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:120;a:6:{s:1:\"a\";i:121;s:1:\"b\";s:21:\"transaction-type-edit\";s:1:\"c\";s:22:\"Edit Transaction Types\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:121;a:6:{s:1:\"a\";i:122;s:1:\"b\";s:23:\"transaction-type-delete\";s:1:\"c\";s:24:\"Delete Transaction Types\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:122;a:6:{s:1:\"a\";i:123;s:1:\"b\";s:37:\"transaction-type-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:17:\"Transaction Types\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:123;a:6:{s:1:\"a\";i:124;s:1:\"b\";s:17:\"travel-point-list\";s:1:\"c\";s:23:\"View Travel Points List\";s:1:\"d\";s:13:\"Travel Points\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:124;a:6:{s:1:\"a\";i:125;s:1:\"b\";s:19:\"travel-point-create\";s:1:\"c\";s:20:\"Create Travel Points\";s:1:\"d\";s:13:\"Travel Points\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:125;a:6:{s:1:\"a\";i:126;s:1:\"b\";s:17:\"travel-point-view\";s:1:\"c\";s:25:\"View Travel Point Details\";s:1:\"d\";s:13:\"Travel Points\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:126;a:6:{s:1:\"a\";i:127;s:1:\"b\";s:17:\"travel-point-edit\";s:1:\"c\";s:18:\"Edit Travel Points\";s:1:\"d\";s:13:\"Travel Points\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:127;a:6:{s:1:\"a\";i:128;s:1:\"b\";s:19:\"travel-point-delete\";s:1:\"c\";s:20:\"Delete Travel Points\";s:1:\"d\";s:13:\"Travel Points\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:128;a:6:{s:1:\"a\";i:129;s:1:\"b\";s:9:\"user-list\";s:1:\"c\";s:15:\"View Users List\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:129;a:6:{s:1:\"a\";i:130;s:1:\"b\";s:11:\"user-create\";s:1:\"c\";s:12:\"Create Users\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:130;a:6:{s:1:\"a\";i:131;s:1:\"b\";s:9:\"user-view\";s:1:\"c\";s:17:\"View User Details\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:131;a:6:{s:1:\"a\";i:132;s:1:\"b\";s:9:\"user-edit\";s:1:\"c\";s:10:\"Edit Users\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:132;a:6:{s:1:\"a\";i:133;s:1:\"b\";s:11:\"user-delete\";s:1:\"c\";s:12:\"Delete Users\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:133;a:6:{s:1:\"a\";i:134;s:1:\"b\";s:25:\"user-change-active-status\";s:1:\"c\";s:20:\"Change Active Status\";s:1:\"d\";s:5:\"Users\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:134;a:6:{s:1:\"a\";i:135;s:1:\"b\";s:14:\"faq-group-list\";s:1:\"c\";s:20:\"View FAQs Group List\";s:1:\"d\";s:10:\"FAQs Group\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:135;a:6:{s:1:\"a\";i:136;s:1:\"b\";s:16:\"faq-group-create\";s:1:\"c\";s:17:\"Create FAQs Group\";s:1:\"d\";s:10:\"FAQs Group\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:136;a:6:{s:1:\"a\";i:137;s:1:\"b\";s:14:\"faq-group-view\";s:1:\"c\";s:22:\"View FAQ Group Details\";s:1:\"d\";s:10:\"FAQs Group\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:137;a:6:{s:1:\"a\";i:138;s:1:\"b\";s:14:\"faq-group-edit\";s:1:\"c\";s:15:\"Edit FAQs Group\";s:1:\"d\";s:10:\"FAQs Group\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:138;a:6:{s:1:\"a\";i:139;s:1:\"b\";s:16:\"faq-group-delete\";s:1:\"c\";s:17:\"Delete FAQs Group\";s:1:\"d\";s:10:\"FAQs Group\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:139;a:6:{s:1:\"a\";i:140;s:1:\"b\";s:8:\"faq-list\";s:1:\"c\";s:14:\"View FAQs List\";s:1:\"d\";s:4:\"FAQs\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:140;a:6:{s:1:\"a\";i:141;s:1:\"b\";s:10:\"faq-create\";s:1:\"c\";s:11:\"Create FAQs\";s:1:\"d\";s:4:\"FAQs\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:141;a:6:{s:1:\"a\";i:142;s:1:\"b\";s:8:\"faq-view\";s:1:\"c\";s:16:\"View FAQ Details\";s:1:\"d\";s:4:\"FAQs\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:142;a:6:{s:1:\"a\";i:143;s:1:\"b\";s:8:\"faq-edit\";s:1:\"c\";s:9:\"Edit FAQs\";s:1:\"d\";s:4:\"FAQs\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:143;a:6:{s:1:\"a\";i:144;s:1:\"b\";s:10:\"faq-delete\";s:1:\"c\";s:11:\"Delete FAQs\";s:1:\"d\";s:4:\"FAQs\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:144;a:6:{s:1:\"a\";i:145;s:1:\"b\";s:12:\"country-list\";s:1:\"c\";s:14:\"View Countries\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:145;a:6:{s:1:\"a\";i:146;s:1:\"b\";s:14:\"country-create\";s:1:\"c\";s:16:\"Create Countries\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:146;a:6:{s:1:\"a\";i:147;s:1:\"b\";s:12:\"country-view\";s:1:\"c\";s:20:\"View Country Details\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:147;a:6:{s:1:\"a\";i:148;s:1:\"b\";s:12:\"country-edit\";s:1:\"c\";s:14:\"Edit Countries\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:148;a:6:{s:1:\"a\";i:149;s:1:\"b\";s:14:\"country-delete\";s:1:\"c\";s:16:\"Delete Countries\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:149;a:6:{s:1:\"a\";i:150;s:1:\"b\";s:11:\"country-all\";s:1:\"c\";s:18:\"View All Countries\";s:1:\"d\";s:9:\"Countries\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:150;a:6:{s:1:\"a\";i:151;s:1:\"b\";s:9:\"city-list\";s:1:\"c\";s:11:\"View Cities\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:151;a:6:{s:1:\"a\";i:152;s:1:\"b\";s:11:\"city-create\";s:1:\"c\";s:13:\"Create Cities\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:152;a:6:{s:1:\"a\";i:153;s:1:\"b\";s:9:\"city-view\";s:1:\"c\";s:17:\"View City Details\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:153;a:6:{s:1:\"a\";i:154;s:1:\"b\";s:9:\"city-edit\";s:1:\"c\";s:11:\"Edit Cities\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:154;a:6:{s:1:\"a\";i:155;s:1:\"b\";s:11:\"city-delete\";s:1:\"c\";s:13:\"Delete Cities\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:155;a:6:{s:1:\"a\";i:156;s:1:\"b\";s:8:\"city-all\";s:1:\"c\";s:15:\"View All Cities\";s:1:\"d\";s:6:\"Cities\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:156;a:6:{s:1:\"a\";i:157;s:1:\"b\";s:9:\"area-list\";s:1:\"c\";s:10:\"View Areas\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:157;a:6:{s:1:\"a\";i:158;s:1:\"b\";s:11:\"area-create\";s:1:\"c\";s:12:\"Create Areas\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:158;a:6:{s:1:\"a\";i:159;s:1:\"b\";s:9:\"area-view\";s:1:\"c\";s:17:\"View Area Details\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:159;a:6:{s:1:\"a\";i:160;s:1:\"b\";s:9:\"area-edit\";s:1:\"c\";s:10:\"Edit Areas\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:160;a:6:{s:1:\"a\";i:161;s:1:\"b\";s:11:\"area-delete\";s:1:\"c\";s:12:\"Delete Areas\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:161;a:6:{s:1:\"a\";i:162;s:1:\"b\";s:8:\"area-all\";s:1:\"c\";s:14:\"View All Areas\";s:1:\"d\";s:5:\"Areas\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}i:162;a:6:{s:1:\"a\";i:163;s:1:\"b\";s:18:\"data-toggle-status\";s:1:\"c\";s:13:\"Toggle Status\";s:1:\"d\";s:7:\"General\";s:1:\"e\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:2;i:1;i:4;}}}s:5:\"roles\";a:2:{i:0;a:4:{s:1:\"a\";i:2;s:1:\"b\";s:5:\"admin\";s:1:\"j\";s:5:\"Admin\";s:1:\"e\";s:3:\"web\";}i:1;a:4:{s:1:\"a\";i:4;s:1:\"b\";s:11:\"team_leader\";s:1:\"j\";s:11:\"Team Leader\";s:1:\"e\";s:3:\"web\";}}}', 1760629279);

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

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

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) NOT NULL,
  `total_payable_amount` decimal(10,2) NOT NULL COMMENT 'sum of payable amount''s of cart items',
  `total_price` decimal(10,2) NOT NULL COMMENT 'sum of sale_price of cart items',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cart_id` bigint(20) UNSIGNED NOT NULL,
  `booking_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `payable_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Payable amount for each items in the cart'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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, 19, 'Rajshahi', '2025-10-15 14:34:20', '2025-10-15 20:35:32', NULL),
(2, 19, 'Dhaka', '2025-10-15 14:35:16', '2025-10-15 20:35:16', NULL);

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_id` bigint(20) UNSIGNED NOT NULL,
  `day_number` int(11) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `resolved_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `complaints`
--

INSERT INTO `complaints` (`id`, `booking_id`, `day_number`, `description`, `status`, `admin_notes`, `submitted_at`, `resolved_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Day 01 Tour Calendar Complaint', 'pending', NULL, '2025-10-15 15:03:03', NULL, '2025-10-15 15:03:03', '2025-10-15 15:03:03');

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

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

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

--
-- Table structure for table `coupon_usages`
--

CREATE TABLE `coupon_usages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `usage_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `booking_id` bigint(12) DEFAULT NULL,
  `order_id` bigint(12) DEFAULT NULL,
  `usage_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`usage_details`)),
  `status` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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', '2015-06-10', 'Bangladeshi', 'Travel point 01', 'brother', '9013515243', 'anisur@gmail.com', 'en', 'vegan', NULL, 1, NULL, NULL, NULL, NULL, 1, 0, '2025-10-15 19:45:37', '2025-10-15 21:35:03', 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(4) 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',
  `additional_services` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `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`, `additional_services`, `approval_status`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, '2025-10-16', 1, 1, 6, 5, 11, NULL, NULL, NULL, NULL, NULL, NULL, 'Voluptatum perferend', '[\"0\",\"1\",\"2\",\"3\"]', 0, 1, NULL, NULL, '2025-10-15 15:42:25', '2025-10-15 21:42:25', 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',
  `confirmation_token` varchar(100) DEFAULT NULL,
  `is_processed` tinyint(1) NOT NULL DEFAULT 0,
  `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,
  `faq_group_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`, `faq_group_id`, `question`, `answer`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Id in molestiae mol', 'Explicabo Maxime do', '2025-10-15 13:48:48', '2025-10-15 19:48:57', NULL);

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

--
-- Table structure for table `faq_groups`
--

CREATE TABLE `faq_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_groups`
--

INSERT INTO `faq_groups` (`id`, `name`, `slug`, `description`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Aileen Mcfadden', NULL, 'Quia labore ea et no', 1, '2025-10-15 13:48:16', '2025-10-15 13:48:28', 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,
  `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, 1, NULL, NULL, '\"{\\\"1\\\":[\\\"Day 1 Add Feedback Logs 01\\\",\\\"Day 1 Add Feedback Logs 02\\\",\\\"Day 1 Add Feedback Logs 03\\\"],\\\"2\\\":[\\\"Day 2 Add Feedback Logs 02\\\",\\\"Day 2 Add Feedback Logs 02\\\",\\\"Day 2 Add Feedback Logs 02\\\"]}\"', 0, 4, 4, '2025-10-15 14:47:25', '2025-10-15 20:49:45', 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;

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

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"bca66422-0496-48e1-ba71-bf024432522b\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Customer\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:16:\\\"Booking Success!\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:70:\\\"Your booking for Test Package Name 01 has been successfully Submitted.\\\";s:2:\\\"id\\\";s:36:\\\"a82d1608-31c6-46a6-afee-59fe4ac737fe\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(2, 'default', '{\"uuid\":\"149df545-d78e-4ffe-85cd-4f4eab03bb61\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Customer\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:16:\\\"Booking Success!\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:70:\\\"Your booking for Test Package Name 01 has been successfully Submitted.\\\";s:2:\\\"id\\\";s:36:\\\"a82d1608-31c6-46a6-afee-59fe4ac737fe\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(3, 'default', '{\"uuid\":\"6f0b0506-1019-4dbf-8463-8b5c78b363a8\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:19:\\\"New Booking Created\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:71:\\\"A new booking has been created by Super Admin for Test Package Name 01.\\\";s:2:\\\"id\\\";s:36:\\\"774d76f5-7987-4dc7-82bb-b7e5081c41c9\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(4, 'default', '{\"uuid\":\"6b518a1e-e75a-4dae-9235-32faa268714f\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:19:\\\"New Booking Created\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:71:\\\"A new booking has been created by Super Admin for Test Package Name 01.\\\";s:2:\\\"id\\\";s:36:\\\"774d76f5-7987-4dc7-82bb-b7e5081c41c9\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(5, 'default', '{\"uuid\":\"3c50a74e-d279-4b09-b725-72180685b891\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:19:\\\"New Booking Created\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:70:\\\"A new booking has been created by Admin User for Test Package Name 01.\\\";s:2:\\\"id\\\";s:36:\\\"10297f66-bdba-4323-b6e9-7f938a2eb09a\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(6, 'default', '{\"uuid\":\"49c04f33-aa62-42fc-8043-9a70680e644c\",\"displayName\":\"App\\\\Notifications\\\\BookingReminderNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:45:\\\"App\\\\Notifications\\\\BookingReminderNotification\\\":4:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:10:\\\"\\u0000*\\u0000subject\\\";s:19:\\\"New Booking Created\\\";s:7:\\\"\\u0000*\\u0000body\\\";s:70:\\\"A new booking has been created by Admin User for Test Package Name 01.\\\";s:2:\\\"id\\\";s:36:\\\"10297f66-bdba-4323-b6e9-7f938a2eb09a\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"},\"createdAt\":1760540485,\"delay\":null}', 0, NULL, 1760540485, 1760540485),
(7, 'default', '{\"uuid\":\"a9e8c8ef-3da1-410b-a516-6493bf504719\",\"displayName\":\"App\\\\Jobs\\\\SendBookingReminderJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendBookingReminderJob\",\"command\":\"O:31:\\\"App\\\\Jobs\\\\SendBookingReminderJob\\\":3:{s:10:\\\"\\u0000*\\u0000booking\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Booking\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:1:{i:0;s:11:\\\"tourPackage\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:13:\\\"\\u0000*\\u0000daysBefore\\\";i:0;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-10-15 00:00:00.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:10:\\\"Asia\\/Dhaka\\\";}}\"},\"createdAt\":1760540485,\"delay\":0}', 0, NULL, 1760464800, 1760540485);

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

--
-- 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` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Path or URL to the banner image' CHECK (json_valid(`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,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL 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, NULL, 1),
(2, NULL, 2),
(4, NULL, 4),
(3, NULL, 3);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `title`, `sub_title`, `slug`, `content`, `meta_title`, `meta_description`, `meta_keywords`, `featured_image`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'About Us', 'About UnboundBD', 'about-us', '<h2>About UnboundBD</h2>\n                          <p>UnboundBD is dedicated to providing the best services to our clients.\n                          Our team works tirelessly to ensure satisfaction, quality, and innovation in everything we do.</p>', 'About Us - UnboundBD', 'Learn more about UnboundBD, our vision, and values.', 'about, UnboundBD, company, mission, vision', NULL, 1, 1, NULL, '2025-10-15 13:45:39', '2025-10-15 13:45:39', NULL),
(2, 'Contact Us', 'Ask UnboundBD', 'contact-us', '<h2>Contact UnboundBD</h2>\n                          <p>If you have any questions or inquiries, please reach out to UnboundBD via email or phone.\n                          Our team is always ready to assist you.</p>', 'Contact Us - UnboundBD', 'Get in touch with UnboundBD for inquiries or support.', 'contact, UnboundBD, support, help, email, phone', NULL, 1, 1, NULL, '2025-10-15 13:45:39', '2025-10-15 13:45:39', NULL);

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

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

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

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

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

--
-- 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,
  `is_for_admin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If true, will show in admin add payment method'
) 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`, `is_for_admin`) VALUES
(1, 'Cash', 'cash', NULL, 1, '2025-08-30 00:47:04', '2025-08-30 12:48:06', NULL, 1),
(2, 'SSLCommerz', 'SSLcommerz Payment gateway', NULL, 1, '2025-08-30 00:47:16', '2025-09-25 13:09:06', NULL, 0),
(3, 'Paypal', 'Paypal payment Gateway', NULL, 0, '2025-08-30 00:47:30', '2025-09-25 13:09:44', NULL, 0),
(4, 'Stripe', 'Stripe Payment Gateway', NULL, 1, '2025-08-30 00:47:47', '2025-09-25 13:08:06', NULL, 0),
(5, 'Bank Transfer', 'Manual Bank transfer', NULL, 1, '2025-09-25 01:09:37', '2025-09-25 13:09:37', NULL, 1),
(6, 'cs', 'cs', '[]', 0, '2025-10-10 09:19:56', '2025-10-10 21:19:56', NULL, 0),
(7, 'Cassandra Morrison', 'Corrupti deserunt p', 'http://127.0.0.1:8000/uploads/payment-method/image/1760109767_low.svg', 1, '2025-10-10 09:20:43', '2025-10-10 21:22:47', NULL, 0),
(8, 'Sebastian Flores', 'Quia odit laborum L', 'http://127.0.0.1:8000/uploads/payment-method/image/1760109778_avatar.jpg', 0, '2025-10-10 09:22:58', '2025-10-10 21:22:58', NULL, 0),
(9, 'Orson Whitaker', 'Similique ipsum aut', 'http://127.0.0.1:8000/uploads/payment-method/image/1760260865_travel-story-1.png', 1, '2025-10-12 03:20:44', '2025-10-12 15:21:05', NULL, 0);

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

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

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

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

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

--
-- 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-10-15 19:45:38', '2025-10-15 19:45:38'),
(2, 'admin', 'Admin', 'web', '2025-10-15 19:45:38', '2025-10-15 19:45:38'),
(3, 'tour_guide', 'Tour Guide', 'web', '2025-10-15 19:45:38', '2025-10-15 19:45:38'),
(4, 'team_leader', 'Team Leader', 'web', '2025-10-15 19:45:38', '2025-10-15 19:45:38');

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

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

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

--
-- 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(4) 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,
  `till_date` date 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`, `till_date`) VALUES
(1, NULL, 1, '2025-10-16', 1, 1, 3, 2, 5, 'customer message', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, '2025-10-15 15:41:49', '2025-10-15 21:41:49', NULL, 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, 'Service type 01', 'desc', 'http://127.0.0.1:8000/uploads/service-types/icon/1760542752_travel-story-1.png', 1, 1, NULL, '2025-10-15 15:39:12', '2025-10-15 21:39:12', 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
('32LDaYCIE23G6g8H6oExlLzs2Ot5DSGAuO4HLvin', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNVdCUm0zYnVGUUcycnRmVkUxS1htNmpJQmJ0d1BpUXFpTndzYlI2RSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozOToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2FkbWluL2ZhcXMvY3JlYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9yb2xlcyI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1760543003),
('8qn8ECLyQnIWnWDntOjlSyrRZ7niskc9Jz3FEyqf', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYTF3VDhJVklVeUxmV3RHREg3aFluUHJOeDVsZ01IODJVdVV6V3FvYyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNzoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2NoZWNrb3V0L2NyZWF0ZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6MzoibmV3IjthOjA6e31zOjM6Im9sZCI7YTowOnt9fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM5OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvY3VzdG9tZXIvYm9va2luZ3MiO31zOjU1OiJsb2dpbl9jdXN0b21lcl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1760542074),
('D5l7Zavk7XXYGSKIjehNk9RDvaYFyaHBDSsMMv9D', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYnhSQUVrNnJ0YnlQcmhwcENTY0VLV3N4YzEyMG5mcHVNR0FTa0FLRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jaGVja291dC9jcmVhdGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjM6InVybCI7YToxOntzOjg6ImludGVuZGVkIjtzOjYxOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvY3VzdG9tZXIvY3VzdG9tLXBhY2thZ2UtcmVxdWVzdHMvY3JlYXRlIjt9czo1NToibG9naW5fY3VzdG9tZXJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1760540075),
('KGD8L1YwvaNJEv5PaF9InUrYLwBVGSq5qtLG13e4', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 Edg/141.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSXF6UXd2eklvcU5DdEJZbzRpeElnQm5ma0wxTHAxaUxXbDFaaEFaYiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jdXN0b21lci9jdXN0b20tcGFja2FnZS1yZXF1ZXN0cy8xIjt9czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo2MToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2N1c3RvbWVyL2N1c3RvbS1wYWNrYWdlLXJlcXVlc3RzL2NyZWF0ZSI7fXM6NTU6ImxvZ2luX2N1c3RvbWVyXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1760542965),
('WUgNIofk9gMqUzosIHK0PiWDvUBHxsWn0rPVZcK7', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS1pTRUE5VGJjS3ZvTEc3Ynd3T2M4d09ncGZKYndldVFlZXNMUTVCUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jdXN0b21lci9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6NjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jdXN0b21lci9jdXN0b20tcGFja2FnZS1yZXF1ZXN0cy9jcmVhdGUiO319', 1760541089);

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

--
-- 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
(1, 4, 'Team A', 'Team leader Is Anisur Rahman for this Team', 'http://127.0.0.1:8000/uploads/team/image/1760541138_travel-story-1.png', 1, NULL, 1, 1, '2025-10-15 21:12:08', '2025-10-15 21:12:18', NULL);

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

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

CREATE TABLE `tour_activities` (
  `id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT 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`, `image`, `name`, `slug`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'frontend/img/tour-activity/ta1.jpg', 'Art & Crafts', 'art-crafts', '2025-10-15 13:45:39', NULL, NULL),
(2, 'frontend/img/tour-activity/ta2.jpg', 'Boat & Cruise', 'boat-cruise', '2025-10-15 13:45:39', NULL, NULL),
(3, 'frontend/img/tour-activity/ta3.jpg', 'Culinary & Food', 'culinary-food', '2025-10-15 13:45:39', NULL, NULL),
(4, 'frontend/img/tour-activity/ta4.jpg', 'Cycling & Camping', 'cycling-camping', '2025-10-15 13:45:39', NULL, NULL),
(5, 'frontend/img/tour-activity/ta3.jpg', 'Folk & Festivals', 'folk-festivals', '2025-10-15 13:45:39', NULL, NULL),
(6, 'frontend/img/tour-activity/ta4.jpg', 'History & Heritage', 'history-heritage', '2025-10-15 13:45:39', NULL, NULL),
(7, 'frontend/img/tour-activity/ta5.jpg', 'Nature & Wildlife', 'nature-wildlife', '2025-10-15 13:45:39', NULL, NULL),
(8, 'frontend/img/tour-activity/ta6.jpg', 'Trailing & Walking', 'trailing-walking', '2025-10-15 13:45:39', NULL, NULL),
(9, 'frontend/img/tour-activity/ta1.jpg', 'Adventure & Sports', 'adventure-sports', '2025-10-15 13:45:39', NULL, NULL),
(10, 'frontend/img/tour-activity/ta2.jpg', 'Photography Tours', 'photography-tours', '2025-10-15 13:45:39', NULL, NULL),
(11, 'frontend/img/tour-activity/ta3.jpg', 'Religious Sites', 'religious-sites', '2025-10-15 13:45:39', NULL, NULL),
(12, 'frontend/img/tour-activity/ta4.jpg', 'Beach & Coastal', 'beach-coastal', '2025-10-15 13:45:39', NULL, 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
(1, 1, 3, NULL, 1, NULL, NULL, '2025-10-15 21:16:21', '2025-10-15 21:16:21', 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;

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

--
-- 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,
  `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
(1, 1, NULL, NULL, '\"{\\\"1\\\":\\\"<p>Day 1 <span style=\\\\\\\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\\\\\\\">Itinerary<\\\\\\/span><\\\\\\/p>\\\",\\\"2\\\":\\\"<p>Day 2 <span style=\\\\\\\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\\\\\\\">Itinerary<\\\\\\/span><\\\\\\/p>\\\",\\\"3\\\":\\\"<p>Day 3 <span style=\\\\\\\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\\\\\\\">Itinerary<\\\\\\/span><\\\\\\/p>\\\"}\"', 4, 4, '2025-10-15 14:47:25', '2025-10-15 20:49:45', NULL);

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

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

CREATE TABLE `tour_packages` (
  `id` int(11) NOT NULL,
  `custom_package_requests_id` int(11) DEFAULT NULL,
  `service_requests_id` int(11) 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,
  `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,
  `features_image` 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,
  `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',
  `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`, `features_image`, `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
(1, NULL, NULL, 'Test Package Name 01', 'test-package-name-01', 20000.00, 400.00, 19600.00, 600.00, 1, 1, 1, 1, NULL, '2025-10-15', '2025-11-06', 2, '50 Days', '500', 'Omnis mollit ea cons', 'Ex voluptates vel om', 'Vel est fugit quasi', 'Cumque recusandae A', 11, 'Velit dolore tempori', 'Aut repudiandae veli', 'Ducimus aut magni m', 'Rajshahi', 1, '3', 'Rajshahi', 'Rajshahi', 'Commodi quis eveniet', '<p>Eveniet, reprehender.</p>', '<p>Rerum aliquip magnam.</p>', '<p>Dolore excepteur mag.</p>', 'http://127.0.0.1:8000/uploads/tour_packages/map_image/1760539645_f1.jpg', '<p><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Trip Notes 01</span></p>', '<p><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">FAQ&nbsp;</span>Quia delectus, repre.</p>', '<p><span style=\"color: rgb(51, 51, 51); background-color: rgb(255, 255, 255);\">Reviews&nbsp;</span>Eos, officia vero bl.</p>', 'Rajshahi, 01 road', 'Rajshahi, 01 road', 'http://127.0.0.1:8000/uploads/tour_packages/features_image/1760539645_f2.jpg', 'http://127.0.0.1:8000/uploads/tour_packages/feature_image/1760539645_f1.jpg', 'http://127.0.0.1:8000/uploads/tour_packages/thumbnail/1760539645_f2.jpg', '[{},{}]', NULL, 'https://www.dyqepu.tv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, 4, '2025-10-15 14:47:25', '2025-10-15 20:49:45', 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;

--
-- Dumping data for table `tour_package_activities`
--

INSERT INTO `tour_package_activities` (`id`, `tour_package_id`, `tour_activity_id`) VALUES
(13, 1, 1),
(14, 1, 2),
(15, 1, 3),
(16, 1, 4),
(17, 1, 5),
(18, 1, 6),
(19, 1, 7),
(20, 1, 8),
(21, 1, 9),
(22, 1, 10),
(23, 1, 11),
(24, 1, 12);

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

--
-- 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', 'Lorem exercitationem', '2025-10-15 14:33:05', '2025-10-15 20:33:19', NULL),
(2, 'Tour Type 02', 'Id anim consequuntu', '2025-10-15 14:33:32', '2025-10-15 20:33:32', NULL);

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

--
-- Table structure for table `transaction_items`
--

CREATE TABLE `transaction_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `booking_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'amount for this booking in the transaction',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_items`
--

INSERT INTO `transaction_items` (`id`, `transaction_id`, `booking_id`, `amount`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 600.00, '2025-10-15 15:01:25', '2025-10-15 15:01:25'),
(2, 2, 1, 1000.00, '2025-10-15 15:17:15', '2025-10-15 15:17:15');

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

--
-- 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 `travel_points`
--

CREATE TABLE `travel_points` (
  `id` int(11) NOT NULL,
  `thumbnail` varchar(255) DEFAULT 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`, `thumbnail`, `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
(1, 'http://127.0.0.1:8000/uploads/thumbnails/1760539090.png', 'Travel point 01', 'Rajshahi', 'Maiores necessitatib', 'https://www.vow.ws', NULL, NULL, 19, 1, 2, 4, 4, '2025-10-15 14:38:10', '2025-10-15 20:39:28', 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-10-15 19:45:37', '2025-10-15 19:45:37', NULL),
(2, 2, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-10-15 19:45:37', '2025-10-15 19:45:37', NULL),
(3, 3, 'Dhaka, Bangladesh', NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-10-15 19:45:37', '2025-10-15 19:45:37', NULL),
(4, 4, 'Dhaka', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-10-15 19:50:31', '2025-10-15 19:50:31', 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`),
  ADD KEY `idx_tour_package_id` (`tour_package_id`);

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

--
-- 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 `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_customer_id_foreign` (`customer_id`),
  ADD KEY `idx_customer_id` (`customer_id`);

--
-- Indexes for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cart_id` (`cart_id`),
  ADD KEY `idx_booking_id` (`booking_id`);

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

--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
  ADD PRIMARY KEY (`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 `coupon_usages`
--
ALTER TABLE `coupon_usages`
  ADD PRIMARY KEY (`id`);

--
-- 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 `faq_groups`
--
ALTER TABLE `faq_groups`
  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 `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`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_items`
--
ALTER TABLE `transaction_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_items_transaction_id_foreign` (`transaction_id`),
  ADD KEY `transaction_items_booking_id_foreign` (`booking_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 `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 for table `areas`
--
ALTER TABLE `areas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `id` bigint(20) UNSIGNED 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 for table `coupon_usages`
--
ALTER TABLE `coupon_usages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- 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 `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

--
-- 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 for table `post_categories`
--
ALTER TABLE `post_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `transaction_items`
--
ALTER TABLE `transaction_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

--
-- 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 `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD CONSTRAINT `cart_items_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_items_ibfk_1` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_items_ibfk_2` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE;

--
-- 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_items`
--
ALTER TABLE `transaction_items`
  ADD CONSTRAINT `transaction_items_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_items_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;

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


-- Re-enable foreign key checks
