Data

gistfile1.txt

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 13, 2023 at 04:18 PM
-- Server version: 8.0.33-0ubuntu0.22.04.2
-- PHP Version: 8.2.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `magical_booking_new`
--

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

--
-- Table structure for table `user_packages`
--

CREATE TABLE `user_packages` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED NOT NULL,
  `departure_id` bigint UNSIGNED NOT NULL,
  `number_of_trekkers` int NOT NULL,
  `trek_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'group',
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `coupon_id` bigint UNSIGNED DEFAULT NULL,
  `coupon_amount` decimal(10,2) DEFAULT NULL,
  `arrival_date` date DEFAULT NULL,
  `arrival_time` time DEFAULT NULL,
  `flight_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `airport_pickup` enum('Yes','No') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
  `group_dates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `special_instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `emergency_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emergency_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `send_review_email` tinyint(1) NOT NULL DEFAULT '1',
  `appointment_date` date DEFAULT NULL,
  `appointment_time` time DEFAULT NULL,
  `meeting_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_checkout_hotel` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ;

--
-- Dumping data for table `user_packages`
--

INSERT INTO `user_packages` (`id`, `package_id`, `departure_id`, `user_id`, `number_of_trekkers`, `trek_group`, `start_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(35, 11, 117, 238, 1, 'group', '2022-03-21', '2021-11-12 22:48:14', '2022-03-17 08:42:50', NULL),
(69, 8, 127, 280, 2, 'group', '2022-05-02', '2021-12-08 02:44:34', '2021-12-08 02:54:28', NULL),
(72, 9, 128, 283, 2, 'group', '2022-04-04', '2022-01-11 05:42:12', '2022-01-11 05:57:35', NULL),
(92, 32, 132, 303, 1, 'group', '2022-05-22', '2022-01-22 21:04:19', '2022-02-28 05:25:23', NULL),
(104, 34, 224, 315, 2, 'group', '2022-04-01', '2022-01-31 06:24:23', '2022-01-31 06:24:23', NULL),
(109, 17, 130, 320, 6, 'group', '2022-10-06', '2022-02-01 04:57:13', '2022-05-19 22:10:13', NULL),
(111, 11, 117, 322, 1, 'group', '2022-03-21', '2022-02-02 03:04:23', '2022-05-08 11:10:51', NULL),
(112, 17, 130, 323, 1, 'group', '2022-10-06', '2022-02-02 05:55:28', '2022-02-02 05:56:19', NULL),
(113, 11, 110, 324, 1, 'group', '2022-03-05', '2022-02-02 11:33:12', '2022-03-02 16:40:15', NULL),
(114, 9, 128, 325, 1, 'group', '2022-04-04', '2022-02-03 17:02:35', '2022-02-03 19:47:22', NULL),
(115, 34, 224, 326, 2, 'group', '2022-04-01', '2022-02-04 07:49:18', '2022-05-08 11:10:53', NULL),
(116, 34, 224, 327, 2, 'group', '2022-04-01', '2022-02-04 07:54:09', '2022-02-04 08:10:23', NULL),
(119, 7, 287, 330, 2, 'group', '2022-02-20', '2022-02-08 03:36:05', '2022-03-03 12:11:09', NULL),
(120, 32, 132, 331, 1, 'group', '2022-05-22', '2022-02-11 01:41:30', '2022-02-28 05:17:57', NULL),
(121, 9, 225, 332, 2, 'group', '2022-04-07', '2022-02-11 13:15:29', '2022-02-11 17:20:27', NULL),
(126, 11, 291, 339, 2, 'group', '2022-11-30', '2022-02-24 16:27:53', '2022-11-27 01:05:29', NULL),
(128, 36, 292, 341, 2, 'group', '2022-03-15', '2022-02-26 17:43:50', '2022-02-26 18:01:19', NULL),
(131, 17, 290, 344, 2, 'group', '2022-09-11', '2022-03-01 03:00:32', '2022-03-01 03:09:46', NULL),
(134, 10, 294, 347, 2, 'group', '2022-10-02', '2022-03-07 12:14:33', '2022-03-07 12:27:00', NULL),
(135, 12, 296, 348, 2, 'group', '2022-03-14', '2022-03-09 22:53:10', '2022-03-11 02:41:10', NULL),
(139, 9, 293, 352, 2, 'group', '2022-05-12', '2022-03-12 15:25:36', '2022-03-12 15:25:36', NULL),
(140, 9, 289, 353, 2, 'group', '2022-04-03', '2022-03-13 07:41:37', '2022-03-14 05:34:59', NULL),
(141, 9, 295, 354, 2, 'group', '2022-10-29', '2022-03-13 12:33:04', '2022-09-24 12:43:16', NULL),
(146, 17, 297, 359, 1, 'group', '2022-04-28', '2022-03-17 14:09:13', '2022-04-01 11:01:18', NULL),
(147, 12, 298, 361, 2, 'group', '2022-04-02', '2022-03-18 08:12:42', '2022-03-18 21:41:20', NULL),
(148, 37, 303, 371, 1, 'group', '2022-05-02', '2022-03-21 04:24:28', '2022-03-21 04:34:19', NULL),
(149, 9, 293, 372, 2, 'group', '2022-05-12', '2022-03-22 09:39:56', '2022-03-22 10:18:08', NULL),
(150, 17, 130, 373, 1, 'group', '2022-10-06', '2022-03-26 18:49:01', '2022-10-02 16:36:10', NULL),
(151, 11, 242, 374, 2, 'group', '2022-04-22', '2022-04-02 02:07:28', '2022-04-02 02:38:58', NULL),
(152, 12, 309, 375, 1, 'group', '2022-04-15', '2022-04-04 05:41:20', '2022-04-04 05:59:26', NULL),
(153, 17, 310, 376, 2, 'group', '2022-04-27', '2022-04-10 12:23:59', '2022-04-10 12:48:57', NULL),
(154, 17, 130, 377, 1, 'group', '2022-10-06', '2022-05-23 12:32:02', '2022-05-24 11:10:04', NULL),
(155, 9, 311, 378, 2, 'group', '2022-10-09', '2022-06-06 03:56:36', '2022-07-06 18:46:39', NULL),
(156, 17, 130, 379, 2, 'group', '2022-10-06', '2022-06-17 05:32:19', '2022-09-29 17:57:32', NULL),
(157, 17, 977, 380, 2, 'group', '2022-09-22', '2022-07-03 20:18:04', '2022-09-08 12:52:10', NULL),
(158, 9, 978, 381, 1, 'group', '2022-11-07', '2022-07-09 07:09:37', '2022-08-11 22:34:28', NULL),
(159, 9, 978, 382, 1, 'group', '2022-11-07', '2022-07-09 10:31:48', '2022-08-11 22:32:40', NULL),
(160, 9, 978, 383, 1, 'group', '2022-11-07', '2022-07-12 04:39:31', '2022-08-11 22:35:09', NULL),
(161, 9, 956, 384, 2, 'group', '2022-10-09', '2022-07-19 01:42:39', '2022-09-29 02:52:46', NULL),
(162, 12, 979, 385, 1, 'solo', '2022-09-30', '2022-07-27 20:39:39', '2022-09-28 21:36:57', NULL),
(163, 9, 980, 386, 1, 'group', '2022-11-07', '2022-08-18 22:43:36', '2022-08-19 02:07:54', NULL),
(165, 9, 1005, 388, 2, 'group', '2022-10-18', '2022-08-24 20:44:17', '2022-10-05 01:33:59', NULL),
(166, 9, 1006, 389, 2, 'group', '2022-10-06', '2022-08-25 00:10:46', '2022-08-30 06:35:50', NULL),
(167, 9, 1007, 395, 2, 'group', '2022-10-08', '2022-08-31 01:02:17', '2022-08-31 02:40:06', NULL),
(168, 9, 961, 396, 2, 'group', '2022-10-29', '2022-08-31 14:38:43', '2022-09-07 13:40:18', NULL),
(169, 9, 1120, 397, 5, 'group', '2022-09-25', '2022-09-08 06:30:27', '2022-11-09 02:40:50', NULL),
(170, 9, 1119, 398, 4, 'group', '2022-10-31', '2022-09-08 07:28:51', '2022-09-09 22:11:09', NULL),
(171, 9, 1007, 399, 2, 'private', '2022-10-08', '2022-09-09 03:38:13', '2022-10-13 22:46:32', NULL),
(172, 28, 1121, 400, 1, 'group', '2022-10-03', '2022-09-10 12:39:04', '2022-10-02 04:55:08', NULL),
(173, 9, 953, 401, 1, 'group', '2022-09-27', '2022-09-16 09:06:02', '2022-09-30 12:44:54', NULL),
(174, 9, 1135, 402, 2, 'private', '2022-11-13', '2022-09-19 02:25:48', '2022-11-11 05:41:44', NULL),
(175, 28, 705, 403, 2, 'group', '2022-10-29', '2022-09-19 11:30:01', '2022-09-19 11:35:21', NULL),
(176, 30, 967, 404, 1, 'group', '2023-01-18', '2022-09-26 03:58:35', '2022-11-14 03:28:59', NULL),
(177, 9, 967, 405, 1, 'group', '2023-01-18', '2022-09-26 04:04:33', '2023-01-16 02:07:15', NULL),
(178, 23, 1137, 406, 3, 'group', '2022-10-05', '2022-10-03 02:54:26', '2022-10-03 02:55:41', NULL),
(179, 10, 896, 407, 2, 'group', '2022-12-07', '2022-10-05 23:27:25', '2022-12-14 01:29:10', NULL),
(180, 10, 850, 408, 2, 'group', '2022-10-22', '2022-10-07 05:39:58', '2022-10-07 05:43:01', NULL),
(181, 9, 1138, 409, 2, 'group', '2022-10-17', '2022-10-10 00:28:33', '2022-10-11 19:06:46', NULL),
(182, 9, 295, 410, 1, 'group', '2022-10-29', '2022-10-11 10:35:07', '2022-10-11 10:35:07', NULL),
(183, 11, 1188, 411, 4, 'group', '2023-03-07', '2022-10-12 21:20:02', '2023-03-06 22:27:42', NULL),
(184, 11, 1000, 412, 3, 'group', '2022-11-06', '2022-10-13 09:27:46', '2022-10-13 10:08:58', NULL),
(185, 37, 1118, 413, 3, 'group', '2023-04-29', '2022-10-19 14:51:28', '2022-12-22 19:05:30', NULL),
(186, 7, 1200, 414, 4, 'group', '2023-03-03', '2022-10-23 07:57:08', '2022-12-27 13:57:38', NULL),
(187, 7, 1199, 415, 5, 'group', '2023-01-25', '2022-10-25 14:56:50', '2022-12-27 01:25:34', NULL),
(188, 28, 719, 416, 1, 'solo', '2022-11-12', '2022-11-07 08:05:18', '2022-11-08 00:28:13', NULL),
(189, 11, 1001, 417, 2, 'group', '2022-11-01', '2022-11-08 02:55:35', '2022-11-08 02:58:21', NULL),
(190, 27, 1204, 419, 2, 'private', '2022-12-25', '2022-12-13 03:15:00', '2022-12-13 22:34:17', NULL),
(191, 9, 1157, 420, 4, 'private', '2023-03-28', '2022-12-15 01:12:19', '2022-12-19 22:01:17', NULL),
(192, 9, 1205, 421, 1, 'solo', '2022-12-18', '2022-12-15 19:41:44', '2022-12-15 21:26:44', NULL),
(193, 9, 1156, 422, 2, 'private', '2023-03-22', '2022-12-20 17:26:54', '2022-12-20 17:56:32', NULL),
(194, 17, 1206, 427, 2, 'private', '2023-03-27', '2022-12-24 02:51:18', '2022-12-24 03:27:35', NULL),
(195, 13, 1207, 430, 1, 'private', '2023-03-04', '2023-01-04 02:14:19', '2023-01-04 08:33:31', NULL),
(196, 13, 1207, 431, 1, 'private', '2023-03-04', '2023-01-04 08:01:21', '2023-01-10 03:05:06', NULL),
(197, 13, 1207, 432, 1, 'private', '2023-03-04', '2023-01-05 13:46:00', '2023-01-05 13:50:11', NULL),
(198, 9, 1159, 433, 2, 'private', '2023-04-09', '2023-01-06 13:28:30', '2023-04-03 12:53:50', NULL),
(199, 9, 1202, 434, 1, 'group', '2023-03-20', '2023-01-10 13:03:00', '2023-03-08 10:16:41', NULL),
(200, 9, 1176, 435, 2, 'private', '2023-10-24', '2023-01-13 03:09:47', '2023-01-13 03:25:08', NULL),
(201, 9, 1163, 436, 2, 'group', '2023-05-03', '2023-01-14 22:32:58', '2023-05-02 05:47:21', NULL),
(202, 39, 2689, 437, 2, 'private', '2023-03-20', '2023-01-15 02:59:22', '2023-01-16 02:12:01', NULL),
(203, 39, 2689, 438, 1, 'private', '2023-03-20', '2023-01-15 06:08:37', '2023-01-16 02:11:41', NULL),
(204, 39, 2689, 439, 1, 'group', '2023-03-20', '2023-01-16 04:29:08', '2023-01-16 04:29:08', NULL),
(205, 41, 2695, 440, 2, 'private', '2023-03-18', '2023-01-16 10:00:46', '2023-03-09 21:57:57', NULL),
(206, 12, 2696, 441, 2, 'group', '2023-04-23', '2023-01-21 12:25:52', '2023-01-21 12:59:52', NULL),
(207, 12, 2696, 442, 1, 'group', '2023-04-23', '2023-01-21 15:18:29', '2023-01-22 02:41:05', NULL),
(208, 11, 2698, 443, 2, 'private', '2023-04-21', '2023-01-21 23:49:05', '2023-04-16 19:30:41', NULL),
(209, 37, 2699, 444, 3, 'private', '2023-04-16', '2023-01-23 10:56:35', '2023-04-26 02:53:25', NULL),
(210, 9, 2700, 445, 1, 'group', '2023-04-09', '2023-01-24 11:17:09', '2023-04-07 06:37:05', NULL),
(211, 10, 1209, 446, 1, 'group', '2023-03-01', '2023-01-24 12:57:28', '2023-01-24 13:27:55', NULL),
(212, 12, 2696, 447, 1, 'group', '2023-04-23', '2023-01-25 15:09:40', '2023-01-25 15:19:23', NULL),
(213, 9, 2702, 448, 1, 'group', '2023-03-12', '2023-01-28 10:29:43', '2023-01-28 10:36:06', NULL),
(214, 12, 2701, 449, 1, 'private', '2023-03-30', '2023-01-29 12:22:56', '2023-01-29 12:58:45', NULL),
(215, 9, 1176, 450, 2, 'group', '2023-10-24', '2023-02-03 13:44:56', '2023-02-03 13:56:38', NULL),
(216, 11, 2708, 451, 2, 'group', '2023-09-16', '2023-02-03 21:08:46', '2023-02-03 21:08:46', NULL),
(217, 12, 2866, 452, 2, 'group', '2023-04-04', '2023-02-05 08:53:17', '2023-05-16 04:31:14', NULL),
(218, 37, 2868, 453, 1, 'group', '2023-02-12', '2023-02-09 08:20:07', '2023-02-09 08:20:07', NULL),
(219, 11, 2708, 454, 1, 'group', '2023-09-16', '2023-02-12 17:40:53', '2023-02-12 17:49:20', NULL),
(220, 9, 2871, 455, 2, 'private', '2023-02-27', '2023-02-13 10:28:52', '2023-02-17 21:00:01', NULL),
(221, 37, 2874, 456, 1, 'private', '2023-02-16', '2023-02-13 23:10:25', '2023-02-13 23:13:40', NULL),
(222, 9, 2873, 457, 1, 'private', '2023-02-26', '2023-02-14 13:38:35', '2023-03-11 08:11:15', NULL),
(223, 9, 2875, 458, 1, 'group', '2023-03-12', '2023-02-16 13:12:17', '2023-02-16 13:12:17', NULL),
(224, 9, 1167, 459, 1, 'group', '2023-09-08', '2023-02-16 23:57:31', '2023-02-17 00:18:26', NULL),
(225, 9, 2690, 460, 2, 'group', '2023-03-20', '2023-02-27 00:11:07', '2023-03-19 00:16:13', NULL),
(226, 30, 2692, 461, 3, 'private', '2023-10-03', '2023-03-03 11:01:59', '2023-03-03 11:05:51', NULL),
(227, 18, 2879, 462, 2, 'group', '2023-05-01', '2023-03-06 07:50:42', '2023-03-06 08:28:56', NULL),
(228, 41, 2880, 463, 2, 'group', '2023-05-13', '2023-03-06 14:18:00', '2023-05-12 07:30:16', NULL),
(229, 28, 2881, 464, 1, 'group', '2023-04-11', '2023-03-08 01:37:08', '2023-04-10 10:39:33', NULL),
(230, 9, 2690, 465, 1, 'group', '2023-03-20', '2023-03-09 03:15:00', '2023-03-15 20:51:52', NULL),
(231, 9, 1157, 466, 1, 'group', '2023-03-28', '2023-03-12 15:25:05', '2023-03-12 15:37:51', NULL),
(232, 9, 1170, 467, 1, 'group', '2023-09-24', '2023-03-12 23:49:51', '2023-03-13 19:59:14', NULL),
(233, 9, 2882, 468, 2, 'group', '2023-04-22', '2023-03-13 13:43:36', '2023-06-06 02:49:13', NULL),
(234, 9, 2884, 472, 1, 'private', '2023-09-13', '2023-03-17 04:26:29', '2023-03-17 04:44:26', NULL),
(235, 9, 2884, 473, 1, 'private', '2023-09-13', '2023-03-17 04:34:45', '2023-03-17 05:17:39', NULL),
(236, 9, 2885, 474, 2, 'private', '2023-04-23', '2023-03-19 08:38:42', '2023-03-19 08:58:42', NULL),
(237, 10, 1272, 475, 2, 'group', '2023-09-06', '2023-03-20 19:52:20', '2023-06-18 11:09:28', NULL),
(238, 9, 2886, 476, 2, 'group', '2023-04-07', '2023-03-20 23:25:33', '2023-04-04 23:29:25', NULL),
(239, 9, 2885, 477, 1, 'group', '2023-04-23', '2023-03-23 11:01:27', '2023-03-23 11:07:34', NULL),
(240, 10, 1334, 478, 1, 'group', '2024-03-10', '2023-03-25 17:29:14', '2023-03-25 17:29:14', NULL),
(241, 9, 1177, 479, 2, 'group', '2023-10-29', '2023-03-28 12:51:30', '2023-03-28 13:01:47', NULL),
(244, 11, 2876, 482, 2, 'group', '2023-04-09', '2023-03-30 09:32:07', '2023-03-31 07:10:20', NULL),
(246, 11, 2704, 484, 1, 'group', '2023-09-04', '2023-04-04 07:41:07', '2023-04-04 08:05:13', NULL),
(247, 9, 1168, 484, 1, 'group', '2023-09-14', '2023-04-04 08:09:27', '2023-07-08 04:14:26', NULL),
(248, 9, 2882, 485, 1, 'group', '2023-04-22', '2023-04-07 05:11:06', '2023-04-07 06:00:17', NULL),
(249, 9, 1162, 486, 1, 'group', '2023-04-27', '2023-04-07 16:31:18', '2023-04-07 16:41:56', NULL),
(250, 11, 2911, 487, 2, 'group', '2023-10-10', '2023-04-12 13:11:01', '2023-04-12 13:18:31', NULL),
(251, 28, 2914, 488, 1, 'group', '2023-10-12', '2023-04-13 02:31:31', '2023-04-13 02:49:05', NULL),
(254, 9, 2913, 491, 3, 'private', '2023-10-09', '2023-04-17 06:17:53', '2023-04-17 06:20:07', NULL),
(255, 17, 2917, 492, 1, 'group', '2023-04-27', '2023-04-18 03:08:09', '2023-04-18 03:15:04', NULL),
(256, 23, 2916, 493, 1, 'group', '2023-06-04', '2023-04-19 06:38:36', '2023-06-20 08:21:51', NULL),
(257, 23, 2916, 494, 1, 'group', '2023-06-04', '2023-04-19 09:51:29', '2023-04-19 10:04:28', NULL),
(258, 23, 2916, 495, 1, 'private', '2023-06-04', '2023-04-21 19:59:30', '2023-04-21 20:02:56', NULL),
(259, 10, 1238, 496, 1, 'group', '2023-05-27', '2023-04-24 20:34:42', '2023-06-08 05:53:47', NULL),
(260, 9, 1164, 497, 1, 'group', '2023-05-09', '2023-04-25 19:59:42', '2023-04-25 20:12:42', NULL),
(261, 36, 2912, 498, 4, 'group', '2023-10-11', '2023-04-27 15:53:42', '2023-04-27 16:24:28', NULL),
(262, 11, 2945, 499, 2, 'group', '2023-05-01', '2023-04-29 00:31:55', '2023-04-29 00:31:55', NULL),
(263, 28, 1561, 500, 2, 'group', '2024-03-16', '2023-05-07 16:17:50', '2023-05-07 16:17:50', NULL),
(264, 13, 3349, 501, 2, 'private', '2023-07-31', '2023-05-09 08:36:22', '2023-05-09 08:49:48', NULL),
(265, 9, 1166, 502, 1, 'group', '2023-05-21', '2023-05-11 07:16:44', '2023-05-11 07:54:43', NULL),
(266, 9, 3350, 503, 2, 'group', '2023-05-12', '2023-05-11 09:02:54', '2023-05-11 09:02:54', NULL),
(267, 9, 1169, 504, 2, 'private', '2023-09-19', '2023-05-13 17:57:28', '2023-05-13 18:11:57', NULL),
(268, 9, 1166, 505, 1, 'group', '2023-05-21', '2023-05-20 02:31:50', '2023-05-20 02:34:43', NULL),
(269, 7, 3474, 506, 1, 'group', '2023-05-25', '2023-05-21 05:37:47', '2023-05-22 00:27:18', NULL),
(270, 7, 3475, 507, 1, 'group', '2023-05-26', '2023-05-21 05:38:22', '2023-05-22 00:27:26', NULL),
(271, 8, 3476, 508, 2, 'group', '2023-06-01', '2023-05-22 01:20:13', '2023-05-30 01:48:03', NULL),
(272, 41, 3477, 509, 1, 'private', '2023-06-26', '2023-05-23 23:51:03', '2023-05-23 23:55:50', NULL),
(273, 33, 2931, 510, 2, 'group', '2023-05-29', '2023-05-24 10:39:16', '2023-05-30 00:29:38', NULL),
(274, 11, 2709, 511, 4, 'group', '2023-09-19', '2023-06-07 09:57:20', '2023-06-07 09:57:39', NULL),
(275, 9, 2870, 513, 1, 'group', '2023-09-08', '2023-06-08 12:42:11', '2023-06-08 12:54:10', NULL),
(276, 33, 3506, 514, 1, 'group', '2023-09-21', '2023-06-10 06:19:10', '2023-06-10 06:19:10', NULL),
(277, 44, 7887, 515, 2, 'private', '2023-10-25', '2023-06-10 13:41:42', '2023-06-10 13:43:59', NULL),
(278, 9, 1171, 516, 1, 'group', '2023-09-29', '2023-06-13 14:43:15', '2023-06-13 14:43:15', NULL),
(279, 23, 9600, 517, 2, 'private', '2023-06-20', '2023-06-14 02:18:05', '2023-06-14 05:45:03', NULL),
(280, 17, 3478, 518, 2, 'private', '2023-11-02', '2023-06-22 06:50:05', '2023-06-23 14:05:11', NULL),
(281, 11, 9602, 519, 4, 'private', '2023-10-03', '2023-06-25 06:40:51', '2023-07-02 19:13:38', NULL),
(282, 9, 2892, 520, 4, 'group', '2023-11-17', '2023-06-26 07:19:08', '2023-06-26 07:19:08', NULL),
(283, 11, 2705, 521, 2, 'group', '2023-09-07', '2023-06-27 05:22:54', '2023-06-27 05:49:09', NULL),
(284, 9, 1168, 522, 2, 'group', '2023-09-14', '2023-06-29 11:03:47', '2023-06-29 11:23:58', NULL),
(285, 11, 2710, 523, 1, 'group', '2023-09-22', '2023-07-02 05:39:46', '2023-07-02 05:46:21', NULL),
(286, 9, 1177, 524, 2, 'group', '2023-10-29', '2023-07-02 14:00:28', '2023-07-02 14:12:15', NULL),
(287, 10, 1281, 525, 1, 'group', '2023-10-03', '2023-07-06 01:48:18', '2023-07-06 14:58:08', NULL),
(288, 9, 2891, 526, 1, 'group', '2023-11-13', '2023-07-07 02:51:21', '2023-07-07 03:08:21', NULL),
(289, 10, 1431, 528, 2, 'group', '2024-12-26', '2023-07-08 18:12:08', '2023-07-08 22:39:16', NULL),
(290, 9, 1167, 529, 1, 'group', '2023-09-09', '2023-07-11 02:21:27', '2023-07-11 02:22:46', NULL),
(291, 9, 1167, 530, 1, 'group', '2023-09-09', '2023-07-11 02:23:56', '2023-07-11 02:25:07', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `user_packages`
--
ALTER TABLE `user_packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_packages_user_id_foreign` (`user_id`),
  ADD KEY `user_packages_package_id_foreign` (`package_id`),
  ADD KEY `user_packages_departure_id_foreign` (`departure_id`),
  ADD KEY `user_packages_coupon_id_foreign` (`coupon_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `user_packages`
--
ALTER TABLE `user_packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `user_packages`
--
ALTER TABLE `user_packages`
  ADD CONSTRAINT `user_packages_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_packages_departure_id_foreign` FOREIGN KEY (`departure_id`) REFERENCES `package_departures` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_packages_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_packages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;