-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 20, 2026 at 12:21 PM
-- Server version: 8.4.7
-- PHP Version: 8.3.28

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: `airline_agency`
--

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

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
CREATE TABLE IF NOT EXISTS `admins` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admins_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `first_name`, `last_name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'بهار', 'رضایی', 'kiarash12@gmail.com', '12345678', NULL, '2026-08-18 12:18:38', '2026-08-18 12:18:38', NULL),
(3, 'مینا', 'اسمعیل نژاد', 'bahar@gmail.com', 'bahar1314', NULL, '2026-08-18 14:31:19', '2026-08-19 07:25:27', NULL),
(5, 'کیارشش', 'مصطفی پور', 'masomewewe12@gmail.com', '12345678', NULL, '2026-08-20 04:45:38', '2026-08-20 08:18:54', NULL),
(6, 'احمدد', 'صادقی', 'ahmad@gmail.com', '$2y$12$eDwk2UL1yVP0ADyDKnI.0ehi1Mgx76/3xorzx309ptmF4j/CQBmg.', NULL, '2026-08-20 08:09:18', '2026-08-20 08:17:27', NULL);

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

--
-- Table structure for table `airlines`
--

DROP TABLE IF EXISTS `airlines`;
CREATE TABLE IF NOT EXISTS `airlines` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `country` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `mobile` varchar(11) COLLATE utf8mb4_persian_ci NOT NULL,
  `status` tinyint NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `airlines`
--

INSERT INTO `airlines` (`id`, `name`, `country`, `mobile`, `status`, `created_at`, `updated_at`) VALUES
(2, 'delta', 'iran', '09025347788', 1, '2026-08-16 11:06:00', '2026-08-16 11:06:00');

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

--
-- Table structure for table `airports`
--

DROP TABLE IF EXISTS `airports`;
CREATE TABLE IF NOT EXISTS `airports` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_persian_ci NOT NULL,
  `city` varchar(100) COLLATE utf8mb4_persian_ci NOT NULL,
  `country` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `airports`
--

INSERT INTO `airports` (`id`, `name`, `city`, `country`, `created_at`, `updated_at`) VALUES
(1, 'mehrabad', 'تهران', 'iran', '2026-08-16 11:06:56', '2026-08-16 11:06:56'),
(2, 'emam', 'مشهد', 'iran', '2026-08-16 11:07:38', '2026-08-16 11:07:38');

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

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

DROP TABLE IF EXISTS `cities`;
CREATE TABLE IF NOT EXISTS `cities` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `province_id` bigint UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `province` (`province_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

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

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
CREATE TABLE IF NOT EXISTS `comments` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `guest_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci DEFAULT NULL,
  `commentable_id` bigint UNSIGNED NOT NULL,
  `commentable_type` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fk_comment` (`user_id`),
  KEY `tour_fk_comment` (`commentable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `user_id`, `guest_name`, `commentable_id`, `commentable_type`, `body`, `created_at`, `updated_at`) VALUES
(1, NULL, 'کیارشششش', 1, 'App\\Models\\Tour', 'به نظرم خیلی خوبه', '2026-08-18 06:41:56', '2026-08-18 06:41:56'),
(2, NULL, 'کیارشaa', 1, 'App\\Models\\Tour', 'lqovti', '2026-08-18 06:42:22', '2026-08-18 06:42:22'),
(3, 6, NULL, 1, 'App\\Models\\Tour', 'سلام', '2026-08-18 06:44:24', '2026-08-18 06:44:24'),
(4, 6, NULL, 8, 'App\\Models\\Tour', 'سلام', '2026-08-18 06:49:15', '2026-08-18 06:49:15'),
(5, 4, NULL, 8, 'App\\Models\\Tour', '...', '2026-08-18 07:00:27', '2026-08-18 07:00:27'),
(6, 4, NULL, 8, 'App\\Models\\Tour', 'یشسیسبیالبتالن', '2026-08-18 07:04:29', '2026-08-18 07:04:29'),
(7, 4, NULL, 8, 'App\\Models\\Tour', 'یشسبیلسای', '2026-08-18 07:04:34', '2026-08-18 07:04:34'),
(8, 4, NULL, 8, 'App\\Models\\Tour', 'یشسبیلسبایلتب', '2026-08-18 07:04:38', '2026-08-18 07:04:38'),
(9, 4, NULL, 8, 'App\\Models\\Tour', 'این خیلی خوب بود', '2026-08-18 07:06:35', '2026-08-18 07:06:35'),
(10, 4, NULL, 1, 'App\\Models\\Tour', 'فطفزرذتذدمنئکم', '2026-08-18 09:10:32', '2026-08-18 09:10:32'),
(11, 4, NULL, 1, 'App\\Models\\Tour', 'sghl', '2026-08-18 09:14:06', '2026-08-18 09:14:06'),
(12, 4, NULL, 18, 'App\\Models\\Tour', 'افرین عجب توری', '2026-08-20 06:09:10', '2026-08-20 06:09:10');

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

--
-- Table structure for table `favorites`
--

DROP TABLE IF EXISTS `favorites`;
CREATE TABLE IF NOT EXISTS `favorites` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NOT NULL,
  `favoritable_id` bigint UNSIGNED NOT NULL,
  `favoritable_type` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `favorites_unique_combo` (`user_id`,`favoritable_id`,`favoritable_type`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `favorites`
--

INSERT INTO `favorites` (`id`, `user_id`, `favoritable_id`, `favoritable_type`, `created_at`, `updated_at`) VALUES
(13, 4, 3, 'App\\Models\\Flight', '2026-08-18 03:43:20', '2026-08-18 03:43:20'),
(16, 4, 1, 'App\\Models\\Tour', '2026-08-20 03:29:30', '2026-08-20 03:29:30');

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

--
-- Table structure for table `flights`
--

DROP TABLE IF EXISTS `flights`;
CREATE TABLE IF NOT EXISTS `flights` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `flight_number` varchar(10) COLLATE utf8mb4_persian_ci NOT NULL,
  `airline_id` bigint UNSIGNED NOT NULL,
  `origin_airports_id` bigint UNSIGNED NOT NULL,
  `destination_airports_id` bigint UNSIGNED NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `price` bigint NOT NULL,
  `capacity` int NOT NULL,
  `status` tinyint NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `airline_fk1` (`airline_id`),
  KEY `origin_fk1` (`origin_airports_id`),
  KEY `destination_fk1` (`destination_airports_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `flights`
--

INSERT INTO `flights` (`id`, `flight_number`, `airline_id`, `origin_airports_id`, `destination_airports_id`, `start_time`, `end_time`, `price`, `capacity`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '2123456789', 2, 2, 1, '2026-06-08 03:30:00', '2026-08-20 09:46:00', 2000000, 20, 1, '2026-08-16 11:08:26', '2026-08-20 02:49:20', NULL),
(2, '987654321', 2, 1, 2, '2026-08-17 14:55:00', '2026-08-18 14:33:00', 2000000, 10, 0, '2026-08-17 11:25:47', '2026-08-20 01:54:27', NULL),
(4, '4546474849', 2, 1, 2, '2026-08-16 05:44:00', '2026-08-22 09:53:00', 3900000, 30, 0, '2026-08-20 05:15:16', '2026-08-20 02:53:55', NULL),
(5, '9876543211', 2, 1, 2, '2026-08-22 02:30:00', '2026-09-21 03:00:00', 290000, 10, 1, '2026-08-20 06:01:03', '2026-08-20 06:04:32', NULL),
(6, '9876543211', 2, 2, 1, '2026-08-20 09:43:00', '2026-08-21 08:44:00', 290000, 10, 1, '2026-08-20 07:07:41', '2026-08-20 07:07:41', NULL),
(7, '9876543211', 2, 2, 1, '2026-08-12 14:13:00', '2026-08-13 14:13:00', 290000, 10, 1, '2026-08-20 07:13:53', '2026-08-20 07:16:31', NULL),
(8, '1234567822', 2, 2, 1, '2026-08-19 14:21:00', '2026-08-22 17:21:00', 300000, 10, 1, '2026-08-20 07:22:13', '2026-08-20 08:48:10', NULL),
(9, '1515151515', 2, 2, 1, '2026-08-20 14:38:00', '2026-08-20 15:38:00', 290000, 25, 1, '2026-08-20 07:38:40', '2026-08-20 07:39:00', '2026-08-20 07:39:00');

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

--
-- Table structure for table `provinces`
--

DROP TABLE IF EXISTS `provinces`;
CREATE TABLE IF NOT EXISTS `provinces` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8mb4_persian_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'مازندران', 0, '2026-08-16 05:54:31', '2026-08-16 05:54:31');

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

--
-- Table structure for table `tours`
--

DROP TABLE IF EXISTS `tours`;
CREATE TABLE IF NOT EXISTS `tours` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `file_id` bigint UNSIGNED DEFAULT NULL,
  `tour_type` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci NOT NULL,
  `summary` varchar(200) COLLATE utf8mb4_persian_ci NOT NULL,
  `description` text COLLATE utf8mb4_persian_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `origin_airports_id` bigint UNSIGNED NOT NULL,
  `destination_airports_id` bigint UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `file_fk2` (`file_id`),
  KEY `origin_fk2` (`origin_airports_id`),
  KEY `destination_fk2` (`destination_airports_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `tours`
--

INSERT INTO `tours` (`id`, `title`, `file_id`, `tour_type`, `summary`, `description`, `created_at`, `updated_at`, `origin_airports_id`, `destination_airports_id`, `deleted_at`) VALUES
(1, 'تور شیراز', NULL, 'تفریحی', 'در اینجا ما خوش میگذرانیم', 'شیسبیسایتغسلبدلیالبرظیذطبسلس', '2026-08-16 12:12:51', '2026-08-20 01:17:05', 1, 2, NULL),
(9, 'تور رشت', NULL, 'تفریحی', 'یشصبسلیابتنلتما', 'سشبیلیقافبتلنغعم', '2026-08-20 04:10:41', '2026-08-20 04:18:59', 1, 2, '2026-08-20 04:18:59'),
(10, 'تور رشت', NULL, 'تاریخی', 'یشصبسثلقیافبتلغفنع', 'یشصبثسلقیافبتغلنع', '2026-08-20 04:15:36', '2026-08-20 04:18:55', 2, 1, '2026-08-20 04:18:55'),
(11, 'تور تهران', NULL, 'تاریخی', 'یشسبیلبیالبتانلت', 'شیسشبلابلن', '2026-08-20 04:17:19', '2026-08-20 04:18:51', 2, 1, '2026-08-20 04:18:51'),
(12, 'تور رشت', NULL, 'تاریخی', 'یسشبسیلایبلتبا', 'سشیبیسلبیالتبان', '2026-08-20 04:19:26', '2026-08-20 04:19:26', 2, 1, NULL),
(13, 'تور تهران', NULL, 'تاریخی', 'یشسبیسلبیالتبا', 'یسشبیسلبالبنال', '2026-08-20 04:20:46', '2026-08-20 04:20:46', 2, 1, NULL),
(14, 'تور مینا', NULL, 'تفریحی', 'یشسبیسلبایتلبنالمتا', 'شیسبیسلیبالتبنالمتا', '2026-08-20 04:22:27', '2026-08-20 04:30:24', 2, 1, '2026-08-20 04:30:24'),
(15, 'تور مینا', NULL, 'تفریحی', 'یشسبیسلبایتلبنالمتا', 'شیسبیسلیبالتبنالمتا', '2026-08-20 04:22:55', '2026-08-20 04:28:40', 2, 1, '2026-08-20 04:28:40'),
(16, 'تور تهران', NULL, 'تفریحی', 'یشبثسلقیافتبغنل', 'یشصبسثلطایبت', '2026-08-20 04:29:12', '2026-08-20 04:30:20', 2, 1, '2026-08-20 04:30:20'),
(17, 'تور تهران', NULL, 'تفریحی', 'یشبثسلقیافتبغنل', 'یشصبسثلطایبت', '2026-08-20 04:30:13', '2026-08-20 04:30:13', 2, 1, NULL),
(18, 'تور بهار', NULL, 'تفریحی', 'ق،ٌظثغسقعیتفغ', 'قثذصشدقثغسفاقئثغف', '2026-08-20 04:36:44', '2026-08-20 04:36:44', 2, 1, NULL),
(19, 'تور مینا', NULL, 'تفریحی', 'یشبسثلیقافبتلغ', 'یشسبظیلیبالاتا', '2026-08-20 04:54:02', '2026-08-20 04:54:02', 2, 1, NULL),
(20, 'سوگند تور', NULL, 'تفریحی', 'شسیبیسلبیالتبانل', 'یشبسیلایببتنال', '2026-08-20 06:06:34', '2026-08-20 06:06:34', 2, 1, NULL),
(21, 'تور احمد', NULL, 'تاریخی', 'یسظبسلطبیالزتبا', 'یسبظیسلطیبالتنات', '2026-08-20 07:21:23', '2026-08-20 07:21:23', 1, 2, NULL),
(22, 'تورر ماهان', NULL, 'تاریخی', 'شیبسلیالزتبا', 'شیسبیسلبیالتبا', '2026-08-20 07:36:29', '2026-08-20 07:37:06', 1, 2, NULL);

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

--
-- Table structure for table `tour_details`
--

DROP TABLE IF EXISTS `tour_details`;
CREATE TABLE IF NOT EXISTS `tour_details` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tour_id` bigint UNSIGNED DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `price` int NOT NULL,
  `capacity` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tour_id` (`tour_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `tour_details`
--

INSERT INTO `tour_details` (`id`, `tour_id`, `start_date`, `end_date`, `price`, `capacity`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, '2026-08-05', '2026-08-07', 2000000, 20, 1, '2026-08-16 11:35:28', '2026-08-20 02:54:38', NULL),
(16, 10, '1405-05-29', '1405-05-31', 290000, 10, 1, '2026-08-20 04:15:36', '2026-08-20 04:18:55', '2026-08-20 04:18:55'),
(17, 11, '1405-05-29', '1405-05-29', 290000, 10, 1, '2026-08-20 04:17:19', '2026-08-20 04:18:51', '2026-08-20 04:18:51'),
(18, 12, '2026-08-21', '2026-08-22', 290000, 8, 1, '2026-08-20 04:19:26', '2026-08-20 04:20:11', NULL),
(19, 13, '2026-08-20', '2026-08-22', 290000, 10, 1, '2026-08-20 04:20:46', '2026-08-20 04:21:00', NULL),
(20, 15, '1405-05-29', '1405-05-31', 2500000, 10, 1, '2026-08-20 04:22:55', '2026-08-20 04:28:40', '2026-08-20 04:28:40'),
(21, 17, '2026-08-22', '2026-08-22', 290000, 10, 1, '2026-08-20 04:30:13', '2026-08-20 04:35:44', NULL),
(22, 18, '2026-08-21', '2026-08-22', 100000, 5, 1, '2026-08-20 04:36:44', '2026-08-20 04:36:44', NULL),
(23, 19, '2026-08-22', '2026-08-22', 2500000, 5, 1, '2026-08-20 04:54:02', '2026-08-20 04:54:32', NULL),
(24, 20, '2026-08-21', '2026-08-22', 290000, 10, 1, '2026-08-20 06:06:34', '2026-08-20 06:06:34', NULL),
(25, 21, '2026-08-21', '2026-08-22', 290000, 15, 1, '2026-08-20 07:21:23', '2026-08-20 07:21:23', NULL),
(26, 22, '2026-08-19', '2026-08-21', 1000000, 5, 1, '2026-08-20 07:36:29', '2026-08-20 07:36:29', NULL);

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `first_name` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8mb4_persian_ci NOT NULL,
  `national_code` varchar(10) COLLATE utf8mb4_persian_ci NOT NULL,
  `gender` tinyint(1) NOT NULL COMMENT '1:male | 0:female',
  `marital_status` tinyint UNSIGNED NOT NULL COMMENT '0:single | 1:married | 2:divorced',
  `spouse_name` varchar(250) COLLATE utf8mb4_persian_ci DEFAULT NULL,
  `file_id` bigint UNSIGNED DEFAULT NULL,
  `mobile` varchar(11) COLLATE utf8mb4_persian_ci NOT NULL,
  `email` varchar(500) COLLATE utf8mb4_persian_ci NOT NULL,
  `user_name` varchar(100) COLLATE utf8mb4_persian_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_persian_ci NOT NULL,
  `user_province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci DEFAULT NULL,
  `user_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `file_fk1` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `first_name`, `last_name`, `national_code`, `gender`, `marital_status`, `spouse_name`, `file_id`, `mobile`, `email`, `user_name`, `password`, `user_province`, `user_city`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, 'کیارشش', 'مصطفی پور', '2081573830', 1, 0, NULL, NULL, '09025347787', 'masomewewe12@gmail.com', 'Kiarash56', '$2y$12$NpQZ6gjNyKwyMS9KsfakkOIDzdxsj9o7KeerVoj5e.2p7aGOTg6WC', NULL, NULL, '2026-08-16 02:59:49', '2026-08-20 08:17:41', NULL),
(5, 'مینا', 'اسمعیل نژاد', '2110932325', 0, 0, NULL, NULL, '09036097643', 'mina@email.com', 'mina1313', '$2y$12$tB2CHigq23QLCafwZcLTf.tE.lGHZlxmz.u8MtHNRH5rqWr2bAGga', NULL, NULL, '2026-08-16 03:07:54', '2026-08-19 01:41:07', NULL),
(6, 'بهاررر', 'رضایی', '2150620261', 0, 0, NULL, NULL, '09370032857', 'bahar@gmail.com', 'bahar14', '$2y$12$qpjX4BIqLbVhFRdQWQEJX.vMpUFpe4L2nIRyRTafQIjHqdbfkqUuG', 'مازندران', 'ساری', '2026-08-18 06:44:09', '2026-08-20 02:19:03', NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `province` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `user_fk_comment` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `flights`
--
ALTER TABLE `flights`
  ADD CONSTRAINT `airline_fk1` FOREIGN KEY (`airline_id`) REFERENCES `airlines` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `destination_fk1` FOREIGN KEY (`destination_airports_id`) REFERENCES `airports` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `origin_fk1` FOREIGN KEY (`origin_airports_id`) REFERENCES `airports` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `tours`
--
ALTER TABLE `tours`
  ADD CONSTRAINT `destination_fk2` FOREIGN KEY (`destination_airports_id`) REFERENCES `airports` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `origin_fk2` FOREIGN KEY (`origin_airports_id`) REFERENCES `airports` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `tour_details`
--
ALTER TABLE `tour_details`
  ADD CONSTRAINT `tour_fk1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
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 */;