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

START TRANSACTION;



--
-- Database: `ticeting`
--

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

--
-- Table structure for table `admin_login_logs`
--

CREATE TABLE `admin_login_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `status` enum('success','failed','blocked','locked') NOT NULL,
  `failure_reason` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `city` varchar(255) 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 `artists`
--

CREATE TABLE `artists` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `bio` text DEFAULT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `artists`
--

INSERT INTO `artists` (`id`, `name`, `bio`, `image`) VALUES
(4, 'mo7hamed', 'ثقثقثقثق', ''),
(5, 'mo7hamed', 'ثقثقثقثق', '1758494526_Capture001.png'),
(6, 'eng mohamed ', 'back end ', '1758494584_EasternDragon.png'),
(7, 'eng mohamed ail', 'back encd', '1758495286_AMERICAN.jpeg');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sub_city_id` int(11) DEFAULT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `name_en`, `parent_id`, `city_id`, `sub_city_id`, `image`) VALUES
(4, 'العاب', 'games', NULL, 1, 13, ''),
(5, 'العاب كبار', 'Senior games', 4, 1, 13, ''),
(6, 'العاب اطفال', 'Children\'s games', 4, 1, 13, '');

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

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

CREATE TABLE `cities` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `currency_name_ar` varchar(255) DEFAULT NULL,
  `currency_name_en` varchar(255) DEFAULT NULL,
  `currency_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `cities` (`id`, `name`, `name_en`, `currency_name_ar`, `currency_name_en`, `currency_code`) VALUES
(1, 'مصر', 'Egypt', 'الجنيه', 'pound', 'egt'),
(2, 'قطر', 'Qatar', 'ريال قطري', 'QAR', 'QAR'),
(3, 'السعوديه', 'Saudi Arabia', 'ريال سعودي', 'saudia rayal', 'sar'),
(4, 'سوريا', 'Syria', 'شيكل', 'sh', 'sh');

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

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

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `countries` (`id`, `name`) VALUES
(1, 'مصر'),
(2, 'الصعيد'),
(3, 'قطر'),
(4, 'السعوديه'),
(5, 'السعوديه'),
(6, 'امارات'),
(7, 'هخه');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `artist_id` int(11) DEFAULT NULL,
  `event_name` varchar(255) NOT NULL,
  `event_place` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `media_file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `event_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `artist_id`, `event_name`, `event_place`, `image`, `media_file`, `created_at`, `event_date`) VALUES
(1, 4, 'فغغف', 'اتفبلالبفغفغ', 'uploads/1756991250_BANKMUSCAT - Copy - Copy.jpeg', 'uploads/1756991293_ولا تيأسوا من روح الله إنه لا ييأس من روح الله إلا القوم الكافرون _ القارئ محمد الغزالي.mp4', '2025-09-04 13:07:30', '2025-09-09'),
(2, 5, 'فغغف', 'اتفبلالبفغفغ', 'uploads/1757002537_FIRSABUDHABI - Copy - Copy.png', NULL, '2025-09-04 15:49:45', '2025-09-16');

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

--
-- Table structure for table `event_media`
--

CREATE TABLE `event_media` (
  `id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_type` enum('image','video') NOT NULL,
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_media`
--

INSERT INTO `event_media` (`id`, `event_id`, `file_path`, `file_type`, `uploaded_at`) VALUES
(5, 1, 'uploads/1756992401_قال إنما أشكوا بثي وحزني إلى الله ~ من أجمل ما رتل الشيخ ياسر الدوسري في الحرم المكي 😭💔.mp4', 'video', '2025-09-04 13:26:41'),
(6, 1, 'uploads/1756992422_103S_AlAsr_العصر.mp3', 'video', '2025-09-04 13:27:02'),
(7, 1, 'uploads/1756992438_BRITISH.png', 'image', '2025-09-04 13:27:18');

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

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

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

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `file_type` enum('image','video') NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `link` varchar(500) NOT NULL,
  `offer_message` varchar(255) NOT NULL,
  `sub_city_id` int(11) 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;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_12_13_093912_add_sub_city_id_to_tickets_table', 1),
(5, '2025_12_13_094935_make_city_id_nullable_in_tickets_table', 1),
(6, '2025_12_18_010335_add_date_range_to_tickets_table', 1),
(7, '2025_12_18_012937_add_slug_to_tickets_table', 1),
(8, '2025_12_25_142658_create_ticket_dates_table', 1),
(9, '2025_12_27_100001_add_english_translations_to_tickets_table', 1),
(10, '2025_12_27_100004_add_english_translations_to_sub_cities_table', 1),
(11, '2025_12_17_072907_add_social_auth_to_users_table', 2),
(12, '2025_12_18_003832_add_social_auth_fields_to_users_table', 2),
(13, '2025_12_18_094738_create_trip_schedules_table', 2),
(14, '2025_12_26_025500_add_currency_fields_to_cities_table', 2),
(15, '2025_12_27_100002_add_english_translations_to_categories_table', 2),
(16, '2025_12_27_100003_add_english_translations_to_cities_table', 2),
(17, '2025_12_28_000001_create_orders_table', 2),
(18, '2025_12_28_120000_fix_trip_schedules_table', 3),
(19, '2025_12_28_130000_create_trip_timing_table', 4),
(20, '2025_12_28_192000_add_ticket_type_and_child_price_to_tickets', 5),
(21, '2025_12_28_193000_create_ticket_options_table', 6),
(22, '2025_12_29_074600_add_updated_at_to_telegram_tokens', 7),
(23, '2025_12_29_075000_change_telegram_tokens_columns_to_text', 8),
(24, '2025_12_29_082052_add_english_fields_to_trip_schedules_table', 9),
(25, '2025_12_30_091900_add_admin_fields_to_users_table', 10),
(26, '2025_12_30_092800_create_admin_login_logs_table', 11),
(27, '2025_12_30_164001_create_settings_table', 12),
(28, '2025_12_31_075705_add_two_factor_columns_to_users_table', 13);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `ticket_title` varchar(255) NOT NULL,
  `ticket_price` decimal(10,2) NOT NULL,
  `currency_code` varchar(255) DEFAULT 'SAR',
  `booking_date` date DEFAULT NULL,
  `booking_time` varchar(255) DEFAULT NULL,
  `adults` int(11) DEFAULT 1,
  `children` int(11) DEFAULT 0,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','paid','cancelled','refunded') DEFAULT 'pending',
  `payment_method` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) 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 `orders`
--

INSERT INTO `orders` (`id`, `customer_name`, `customer_email`, `customer_phone`, `country_code`, `ticket_id`, `ticket_title`, `ticket_price`, `currency_code`, `booking_date`, `booking_time`, `adults`, `children`, `total_amount`, `status`, `payment_method`, `transaction_id`, `created_at`, `updated_at`) VALUES
(12, 'Mohamed ail (TECH)', 'ly4320456u@gmail.com', '01154645120', '+20', 189, 'العاب المنتزه', 450.00, 'SAR', '2026-01-08', '21:00-04:00', 1, 0, 200.00, 'pending', 'card', 'TXN-6953F971DB271', '2025-12-31 00:10:25', '2025-12-31 00:10:25'),
(13, 'Mohamed ail (TECH)', 'ly4320456u@gmail.com', '01154645120', '+20', 189, 'العاب المنتزه', 450.00, 'egt', '2026-01-08', '21:00-04:00', 1, 0, 600.00, 'pending', 'card', 'TXN-6953FA426F6EA', '2025-12-31 00:13:54', '2025-12-31 00:13:54'),
(14, 'Admin', 'ly4320456@gmail.com', '01154645120', '+20', 189, 'العاب المنتزه', 450.00, 'egt', '2026-01-06', '21:00-04:00', 1, 0, 200.00, 'pending', 'card', 'TXN-6954E20A83FF4', '2025-12-31 16:42:50', '2025-12-31 16:42:50'),
(15, 'Admin', 'ly4320456@gmail.com', '01154645120', '+20', 189, 'العاب المنتزه', 450.00, 'egt', '2026-01-08', '21:00-04:00', 1, 0, 450.00, 'pending', 'card', 'TXN-6954E3028F4A8', '2025-12-31 16:46:58', '2025-12-31 16:46:58'),
(16, 'Admin', 'ly4320456@gmail.com', '01154645120', '+20', 189, 'العاب المنتزه', 450.00, 'egt', '2026-01-08', '21:00-04:00', 1, 0, 450.00, 'pending', 'card', 'TXN-6954E30C9A7BD', '2025-12-31 16:47:08', '2025-12-31 16:47:08');

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

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

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

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

--
-- Table structure for table `sub_cities`
--

CREATE TABLE `sub_cities` (
  `id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sub_cities`
--

INSERT INTO `sub_cities` (`id`, `city_id`, `name`, `name_en`, `image`) VALUES
(13, 1, 'اسيوط', 'Assiut', 'circles/1767079756_69537f4c0e777.png'),
(14, 1, 'اسيوط', 'Assiut', 'circles/1767079367_69537dc77bb8d.png'),
(15, 2, 'الدوحه', 'Doha', 'circles/1767080094_6953809ece488.jpg'),
(16, 3, 'الرياض', 'Riyadh', 'circles/1767080083_69538093f0f9a.webp'),
(17, 4, 'غزه', 'Gaza', 'circles/1767080073_6953808984f70.jpg');

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

--
-- Table structure for table `sub_city_media`
--

CREATE TABLE `sub_city_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sub_city_id` bigint(20) UNSIGNED NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_type` varchar(255) NOT NULL DEFAULT 'image',
  `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 `sub_city_media`
--

INSERT INTO `sub_city_media` (`id`, `sub_city_id`, `file_path`, `file_type`, `created_at`, `updated_at`) VALUES
(1, 13, 'subcities/1767005711_69525e0fbc628.jpg', 'image', '2025-12-29 18:55:11', '2025-12-29 18:55:11'),
(2, 13, 'subcities/1767006096_69525f907e414.mp4', 'video', '2025-12-29 19:01:36', '2025-12-29 19:01:36');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `city_id` int(10) UNSIGNED DEFAULT NULL,
  `sub_city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `ticket_type` enum('cinema','trip') NOT NULL DEFAULT 'cinema',
  `child_price` decimal(10,2) DEFAULT NULL,
  `adult_description` text DEFAULT NULL,
  `adult_description_en` text DEFAULT NULL,
  `child_description` text DEFAULT NULL,
  `child_description_en` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `availability` varchar(50) DEFAULT '100',
  `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 `tickets`
--

INSERT INTO `tickets` (`id`, `category_id`, `city_id`, `sub_city_id`, `title`, `title_en`, `description`, `description_en`, `price`, `ticket_type`, `child_price`, `adult_description`, `adult_description_en`, `child_description`, `child_description_en`, `image`, `video`, `event_date`, `start_date`, `end_date`, `start_time`, `end_time`, `availability`, `created_at`, `updated_at`) VALUES
(189, 6, 1, 13, 'العاب المنتزه', 'Park games', 'العاب المتنزه المصري', 'Egyptian theme park games', 450.00, 'trip', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-31', NULL, NULL, '08:22:00', '10:22:00', 'specific_dates', NULL, NULL),
(190, 6, 1, 13, 'يليل', 'Yalil', 'ليليليليل', 'Lillyllilil', 54545.00, 'trip', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-25', NULL, NULL, '03:52:00', '04:52:00', 'specific_dates', NULL, NULL),
(191, 6, 1, 13, 'ففقفقفق', 'Ffqffffqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqfqqfq', 'فقفقفقف', 'So he stopped', 54545.00, 'trip', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-31', NULL, NULL, '05:25:00', '07:25:00', 'specific_dates', NULL, NULL);

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

--
-- Table structure for table `ticket_dates`
--

CREATE TABLE `ticket_dates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `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 `ticket_dates`
--

INSERT INTO `ticket_dates` (`id`, `ticket_id`, `date`, `price`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 6, '2025-12-29', 400.00, 1, '2025-12-28 19:02:24', '2025-12-28 19:02:24'),
(2, 7, '2025-12-29', 400.00, 1, '2025-12-28 19:04:03', '2025-12-28 19:04:03'),
(3, 8, '2025-12-29', 400.00, 1, '2025-12-28 19:04:50', '2025-12-28 19:04:50'),
(4, 10, '2025-12-29', 434.00, 1, '2025-12-28 19:22:35', '2025-12-28 19:22:35'),
(5, 11, '2025-12-29', 500.00, 1, '2025-12-29 03:44:50', '2025-12-29 03:44:50'),
(6, 12, '2025-12-29', 3000.00, 1, '2025-12-29 15:38:47', '2025-12-29 15:38:47'),
(7, 35, '2025-12-23', 344.00, 1, '2025-12-29 21:53:09', '2025-12-29 21:53:09'),
(8, 56, '2025-12-23', 454.00, 1, '2025-12-29 22:09:39', '2025-12-29 22:09:39'),
(9, 187, '2025-12-31', 400.00, 1, '2025-12-30 19:07:42', '2025-12-30 19:07:42'),
(10, 188, '2025-12-31', 400.00, 1, '2025-12-30 19:11:58', '2025-12-30 19:11:58'),
(11, 188, '2025-12-31', 400.00, 1, '2025-12-30 19:11:58', '2025-12-30 19:11:58'),
(12, 189, '2026-01-06', 450.00, 1, '2025-12-30 20:23:33', '2025-12-30 20:23:33'),
(13, 189, '2026-01-08', 450.00, 1, '2025-12-30 20:23:33', '2025-12-30 20:23:33'),
(14, 190, '2026-01-06', 54545.00, 1, '2025-12-31 16:52:25', '2025-12-31 16:52:25'),
(15, 191, '2026-01-01', 54545.00, 1, '2025-12-31 17:25:53', '2025-12-31 17:25:53');

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

--
-- Table structure for table `ticket_options`
--

CREATE TABLE `ticket_options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `description` varchar(255) NOT NULL,
  `description_en` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `ticket_options`
--

INSERT INTO `ticket_options` (`id`, `ticket_id`, `description`, `description_en`, `price`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(12, 189, 'هتلعب جاتا فقط', 'You will only play Gatta', 200.00, 1, 1, '2025-12-30 20:23:35', '2025-12-30 20:23:35'),
(13, 189, 'هتلعب جاتا وبيس', 'You will play Gata and Pace', 600.00, 2, 1, '2025-12-30 20:23:35', '2025-12-30 20:23:35');

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

--
-- Table structure for table `trip_schedules`
--

CREATE TABLE `trip_schedules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `time` varchar(255) DEFAULT NULL,
  `activity` text DEFAULT NULL,
  `activity_en` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `order` int(11) DEFAULT 0,
  `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 `trip_schedules`
--

INSERT INTO `trip_schedules` (`id`, `ticket_id`, `time`, `activity`, `activity_en`, `title`, `title_en`, `description`, `description_en`, `order`, `created_at`, `updated_at`) VALUES
(15, 188, '07:11', 'اطلع من بيت', NULL, NULL, NULL, NULL, NULL, 1, '2025-12-30 19:11:58', '2025-12-30 19:11:58'),
(16, 188, '07:11', 'اضرب دكتور', NULL, NULL, NULL, NULL, NULL, 2, '2025-12-30 19:11:58', '2025-12-30 19:11:58'),
(17, 189, '06:22', 'اطلع من بيت', 'Get out of the house', NULL, NULL, NULL, NULL, 1, '2025-12-30 20:23:33', '2025-12-30 20:23:33'),
(18, 189, '06:22', 'اروح الكليه', 'I go to college', NULL, NULL, NULL, NULL, 2, '2025-12-30 20:23:33', '2025-12-30 20:23:33'),
(19, 189, '07:22', 'اضرب الدكتور', 'Hit the doctor', NULL, NULL, NULL, NULL, 3, '2025-12-30 20:23:34', '2025-12-30 20:23:34'),
(20, 189, '09:23', 'نمشيها تاني', 'Let\'s walk it again', NULL, NULL, NULL, NULL, 4, '2025-12-30 20:23:35', '2025-12-30 20:23:35');

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

--
-- Table structure for table `trip_timing`
--

CREATE TABLE `trip_timing` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `start_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `note` text 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 `trip_timings`
--

CREATE TABLE `trip_timings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time 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 `uploads`
--

CREATE TABLE `uploads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED DEFAULT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_type` varchar(50) DEFAULT NULL,
  `uploaded_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 `uploads`
--

INSERT INTO `uploads` (`id`, `ticket_id`, `category_id`, `file_path`, `file_type`, `uploaded_at`, `created_at`, `updated_at`) VALUES
(2, 6, 2, 'tickets/images/M0Nd7g3Gc8Pt0xFbfkbMqKlX5elbV1Pirk4cxCPf.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(3, 6, 2, 'tickets/images/UbnFaqoYKYiEJ6O1mSbGRsWlTHLcxgayAiT4bD9H.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(4, 6, 2, 'tickets/images/nETR1CtEwjRDy5y5yAznbdkXpodYU9le8cMLgbV0.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(5, 6, 2, 'tickets/images/BLBn9rmNFQ0WzPsttVLx6xZgfFFB0zjgCAotXvLw.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(6, 6, 2, 'tickets/images/Xkxd3iFwlh61nUyNorHeOugg1EeXKFbiLIyKeDEB.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(7, 6, 2, 'tickets/images/5wr64tHWWGRcN2ENwbB1fE1Uk1QbfqiistRQp0Rf.png', 'image', '2025-12-28 19:02:24', NULL, NULL),
(8, 7, 2, 'tickets/images/T33iRGMGMtmWeZMUGta4yserbcW3YU72PHqCAONo.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(9, 7, 2, 'tickets/images/zn12CxRDioWxRC2Ok2SVafbsw9NUO77wwEuD2gtg.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(10, 7, 2, 'tickets/images/tKXCyYgYIUIGSUE9XhMFuOvqOyGT0lNf9tiiXD44.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(11, 7, 2, 'tickets/images/8T9GxDznbEnf2IkeZewHWi22iv2pO6eZzu8LVZ8o.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(12, 7, 2, 'tickets/images/hFkFc2vhF8HUoyMNKxQL5vmhQrUznizBLJyCNCLt.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(13, 7, 2, 'tickets/images/uSHsJK1pqu4o2Em6hW6SJglZQoaJH7ReSj8ds61T.png', 'image', '2025-12-28 19:04:03', NULL, NULL),
(14, 8, 2, 'tickets/images/nDKQIX1goDOoMio2gFQ6S4xtWVwXjgPM5TV7WmV2.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(15, 8, 2, 'tickets/images/gUpN65IQkjgznRS7cYxU3bsccOvTJCp8sMPjte4s.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(16, 8, 2, 'tickets/images/aHfs8dGr5nFDmcAWvvdDHtjQ25WsgW154MgTtvUN.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(17, 8, 2, 'tickets/images/UYvDzv74UgCjSRRjJFqZY5XQPOAbhuYRMq9rhQhX.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(18, 8, 2, 'tickets/images/l4eW60DdMk4WScWKAbdDomxjgTaF9m5WKvMt8k3d.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(19, 8, 2, 'tickets/images/SXModIooCcyb298R6nIwE7KEiOKMI3rsnMnsHuar.png', 'image', '2025-12-28 19:04:50', NULL, NULL),
(20, 9, 2, 'tickets/images/x1cXWPvo0ZRnVT47t57T7vcuIcbp2yZFrdb3ss62.png', 'image', '2025-12-28 19:15:29', NULL, NULL),
(21, 10, 2, 'tickets/images/CUVLXhCxmxAKXXs4zzmaAXAe79qkdwQ7bGk1q5QQ.png', 'image', '2025-12-28 19:22:35', NULL, NULL),
(22, 11, 1, 'tickets/images/hXTUwhCW6mr0zMSfDqtpRxI9r95bzsTQFgMt1X3I.jpg', 'image', '2025-12-29 03:44:50', NULL, NULL),
(23, 12, 1, 'tickets/images/NB97xnlMnztEo2BHwMnGGcbNJOizVaOBRWIhemHP.png', 'image', '2025-12-29 15:38:47', NULL, NULL),
(26, 35, 4, 'tickets/images/qElzJ0VytxWHOrGQX5qFKsSKPIbPDmvSvuEIOZyx.jpg', 'image', '2025-12-29 21:53:09', NULL, NULL),
(27, 36, 5, 'tickets/images/0W3ibcTZkN6vwZdinGhyzpTAR1eiqApIqOsigsUK.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(28, 37, 5, 'tickets/images/53O4O6ZkNGlMQRaYJc5e9b39WJtLS8MVdcVT9P1c.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(29, 38, 5, 'tickets/images/5wr64tHWWGRcN2ENwbB1fE1Uk1QbfqiistRQp0Rf.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(30, 39, 5, 'tickets/images/5ylmTyDfMxI7SkGj3nMaLaEOGAJ4cGOr5gc6r24J.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(31, 40, 5, 'tickets/images/6cWKGEJfC3o8H8que0BHCWAFAzAAa90t3mpjww7m.jpg', 'image', '2025-12-29 21:57:01', NULL, NULL),
(32, 41, 5, 'tickets/images/6t5LpjhZ15x1jhltCCJtwI8mCZtoiOaiZLaZoM6f.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(33, 42, 5, 'tickets/images/7xu8T2oxNLuT9ZusCBplKcNrzOmeI9lmApqmbCx8.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(34, 43, 5, 'tickets/images/8T9GxDznbEnf2IkeZewHWi22iv2pO6eZzu8LVZ8o.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(35, 44, 5, 'tickets/images/9B0FkwduE9xY6E5ywmx51RYsfEK77JpxB2BxnSDw.jpg', 'image', '2025-12-29 21:57:01', NULL, NULL),
(36, 45, 5, 'tickets/images/BLBn9rmNFQ0WzPsttVLx6xZgfFFB0zjgCAotXvLw.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(37, 46, 6, 'tickets/images/CUVLXhCxmxAKXXs4zzmaAXAe79qkdwQ7bGk1q5QQ.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(38, 47, 6, 'tickets/images/HBFGHBvNbSM2icTtmSqxuGqjXXMNi7fzrZdMAv59.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(39, 48, 6, 'tickets/images/HeN4qfZ1RcsYtzjCBGYkU0WqEt3DQQz2Llw6F4g6.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(40, 49, 6, 'tickets/images/JCAowWmnvtvfpW4Lz3oHzRU4AssUAOW8oSA0rugq.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(41, 50, 6, 'tickets/images/KeqYr4s8hAtYnXznJBcg6nVjruDO6pCawLta2MvE.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(42, 51, 6, 'tickets/images/M0Nd7g3Gc8Pt0xFbfkbMqKlX5elbV1Pirk4cxCPf.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(43, 52, 6, 'tickets/images/NB97xnlMnztEo2BHwMnGGcbNJOizVaOBRWIhemHP.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(44, 53, 6, 'tickets/images/NLVw1iLZBKt0IK0N7TjIzKo6xJPQUJ1ErcGxfF7F.jpg', 'image', '2025-12-29 21:57:01', NULL, NULL),
(45, 54, 6, 'tickets/images/OIGcCmaTaUxJSADL7Wna7ZUkNzytOdqQApT3CkIx.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(46, 55, 6, 'tickets/images/PCocvkAZDo9pFdziEQHKUd0W1xWyg8qFOYfaNPRl.png', 'image', '2025-12-29 21:57:01', NULL, NULL),
(47, 56, 6, 'tickets/images/Qwz8td3JGcUkmDtreMHaXGl2sVgwgoVHwgkGjLLF.jpg', 'image', '2025-12-29 22:09:39', NULL, NULL),
(48, 187, 6, 'tickets/images/E5Ly9B9oxFtzz2QJhKtTVMCKxsRTRAp88qoO5AlX.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(49, 187, 6, 'tickets/images/F8XiZ0qs818PHMPnSBNnQ0VCLumNZKGtRsyHRXwU.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(50, 187, 6, 'tickets/images/ULGYks5M07JvtWLyXWfuxkhusScQoBh13bwGu05H.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(51, 187, 6, 'tickets/images/FifF1ip9CXG0nQtbVmP96EIxDFqTY6NIBUz9M2Av.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(52, 187, 6, 'tickets/images/NXz4d8kSWXlzT5TskXRDfHYh9eSh2kDJ6hISH0E4.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(53, 187, 6, 'tickets/images/z7YYqItYJZ4KQrEtCJMemVfGI2YzXLS0QB3W64bd.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(54, 187, 6, 'tickets/images/dAvi5qAfJMvp6Al1KMARRLV3BCVSU6p2Do0aCjgX.png', 'image', '2025-12-30 19:07:42', NULL, NULL),
(55, 188, 6, 'tickets/images/fmwI1s7nJYIQdH0HNRKzE6KkvNbUxgSsjX3UtG3z.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(56, 188, 6, 'tickets/images/BNkGtPRPGnadCdSTM8PaLAwgNctw2gOpE6SEsGny.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(57, 188, 6, 'tickets/images/Fv7FVI4y20blaIDSEF0u7l91JgpwbzlVz2O8z6jD.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(58, 188, 6, 'tickets/images/j5DlWKqP6UGqrMDR5VqAGNQcvdMQCRexPieWgEvc.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(59, 188, 6, 'tickets/images/4MwMZsLC0vdWe1VtpgoAvpPzUh34AZHQSXy6BaZh.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(60, 188, 6, 'tickets/images/kl6FYITXekhJ8jJLKlBoZ2KvEWoeTS8dh1iPdAlx.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(61, 188, 6, 'tickets/images/SKMSdrWkgV1aOw4yP16dk7eZdaa1VfsYiDQHJ61x.png', 'image', '2025-12-30 19:11:58', NULL, NULL),
(62, 189, 6, 'tickets/images/qQQmegQxyrGmar0e7zLLiAGOfeEjr8WkiYYeTXhb.png', 'image', '2025-12-30 20:23:32', NULL, NULL),
(63, 189, 6, 'tickets/images/1mAa7AilFqATzhqkwP7Uom3ZFjAO8my7mAiouh1O.png', 'image', '2025-12-30 20:23:32', NULL, NULL),
(64, 189, 6, 'tickets/images/pDF3UK1FuBylHDOHOHu2k9AX8ncFV66lpmVNyx7t.png', 'image', '2025-12-30 20:23:32', NULL, NULL),
(65, 189, 6, 'tickets/images/Nwd3X0bnB0rv8cyI3isWN03KCxX6KXX7wFB34QAP.png', 'image', '2025-12-30 20:23:33', NULL, NULL),
(66, 189, 6, 'tickets/images/szo9qJ1WCkGJznkhsQoRv9ajfnoTZOl9eK45CmjY.png', 'image', '2025-12-30 20:23:33', NULL, NULL),
(67, 189, 6, 'tickets/images/3OBquPSKVuoVq0DvVRhdSIAE0PWuEiG3XFqDhOCN.png', 'image', '2025-12-30 20:23:33', NULL, NULL),
(68, 189, 6, 'tickets/images/9gPgDuDBfPW1VGzvyCVETrKga9hSPYNzIBibXnWU.png', 'image', '2025-12-30 20:23:33', NULL, NULL),
(69, 190, 6, 'tickets/images/0oVusk2Apd2FfjVSqXaXfWE7JNDJkUmieQk05Kvb.png', 'image', '2025-12-31 16:52:25', NULL, NULL),
(70, 191, 6, 'tickets/images/xp6gbDWhhxlGH9AfM9RJg7S9HSip8XH4O5hMhI5Q.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(71, 191, 6, 'tickets/images/8WR2r3bAJbFAb1P2tSSRVaTevqMaQpvTjcm9eKkt.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(72, 191, 6, 'tickets/images/Ehb4no1DIU8bmsd3UPs0GdmyQvv84ySHFtSNKv0P.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(73, 191, 6, 'tickets/images/iQH0Rir3Urxnl64mDwwciqTghuaEUGTS0MHvNngf.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(74, 191, 6, 'tickets/images/QfAKDrhf2rAcTu5Exu3SdIhsf4M6OFHcs0KCObNo.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(75, 191, 6, 'tickets/images/cDbBfie4lnVF3qfZKhoESO05PmaWQaQiQZAgWKZO.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(76, 191, 6, 'tickets/images/xmJMO4sCx2FLIdKG8oZd4P1M3gHkM507Hu5uYQq7.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(77, 191, 6, 'tickets/images/Re2rFjiYwesEbJRUxr8SyszSoGViENjEpl23iY9E.png', 'image', '2025-12-31 17:25:53', NULL, NULL),
(78, 191, 6, 'tickets/images/p9jVW4b2s4GIVpplbAIzMODXUzqIJD9ih7nWgwFP.png', 'image', '2025-12-31 17:25:53', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_login_logs`
--
ALTER TABLE `admin_login_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_login_logs_user_id_foreign` (`user_id`),
  ADD KEY `admin_login_logs_email_index` (`email`),
  ADD KEY `admin_login_logs_ip_address_index` (`ip_address`),
  ADD KEY `admin_login_logs_status_index` (`status`),
  ADD KEY `admin_login_logs_created_at_index` (`created_at`);

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

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

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_id` (`ticket_id`);

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

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

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

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

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

--
-- Indexes for table `ticket_options`
--
ALTER TABLE `ticket_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_options_ticket_id_foreign` (`ticket_id`);

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

--
-- Indexes for table `trip_timing`
--
ALTER TABLE `trip_timing`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trip_timing_ticket_id_foreign` (`ticket_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_login_logs`
--
ALTER TABLE `admin_login_logs`
  ADD CONSTRAINT `admin_login_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ticket_options`
--
ALTER TABLE `ticket_options`
  ADD CONSTRAINT `ticket_options_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trip_timing`
--
ALTER TABLE `trip_timing`
  ADD CONSTRAINT `trip_timing_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE;
COMMIT;

