/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: uae_travel_system
-- ------------------------------------------------------
-- Server version	10.11.14-MariaDB-0ubuntu0.24.04.1

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `activities`
--

DROP TABLE IF EXISTS `activities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `activities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `activity_category_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `duration_minutes` int(10) unsigned DEFAULT NULL,
  `adult_price` decimal(10,2) NOT NULL,
  `child_price` decimal(10,2) DEFAULT NULL,
  `infant_price` decimal(10,2) DEFAULT NULL,
  `ai_price` decimal(10,2) DEFAULT NULL,
  `manual_price` decimal(10,2) DEFAULT NULL,
  `season` varchar(255) DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activities_area_id_fk` (`area_id`),
  KEY `activities_category_id_fk` (`activity_category_id`),
  CONSTRAINT `activities_area_id_fk` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activities_category_id_fk` FOREIGN KEY (`activity_category_id`) REFERENCES `activity_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activities`
--

LOCK TABLES `activities` WRITE;
/*!40000 ALTER TABLE `activities` DISABLE KEYS */;
INSERT INTO `activities` VALUES
(1,1,6,'Sheikh Zayed Grand Mosque',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,1,6,'Louvre Abu Dhabi',NULL,NULL,63.00,44.10,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,1,6,'Qasr Al Watan Palace',NULL,NULL,60.00,42.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,1,1,'Ferrari World',NULL,NULL,325.00,227.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,1,2,'Warner Bros. World',NULL,NULL,295.00,206.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,1,2,'Yas Waterworld',NULL,NULL,295.00,206.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,2,6,'Burj Khalifa — At the Top',NULL,NULL,169.00,118.30,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(8,2,6,'Museum of the Future',NULL,NULL,159.00,111.30,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(9,2,1,'Desert Safari with BBQ',NULL,NULL,225.00,157.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(10,2,2,'Dubai Frame',NULL,NULL,50.00,35.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(11,2,5,'Dubai Mall + Fountain Show',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(12,2,4,'JBR Beach Day',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(13,3,2,'Sharjah Aquarium',NULL,NULL,50.00,35.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(14,3,6,'Al Noor Island',NULL,NULL,35.00,24.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(15,3,6,'Rain Room',NULL,NULL,45.00,31.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(16,3,6,'Sharjah Museum of Islamic Civilization',NULL,NULL,20.00,14.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(17,3,6,'Sharjah Arts Foundation',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(18,3,2,'Al Qasba Canal Walk',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(19,4,4,'Ajman Beach',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(20,4,6,'Ajman Museum',NULL,NULL,15.00,10.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(21,4,1,'Al Zorah Nature Reserve',NULL,NULL,120.00,84.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(22,4,1,'Mangrove Kayaking Al Zorah',NULL,NULL,140.00,98.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(23,4,5,'Ajman China Mall',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(24,5,2,'Dreamland Aqua Park',NULL,NULL,130.00,91.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(25,5,1,'Mangrove Tours',NULL,NULL,150.00,105.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(26,5,4,'Marine Club Watersports',NULL,NULL,180.00,126.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(27,5,6,'UAQ Old Town Heritage Walk',NULL,NULL,20.00,14.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(28,5,4,'Kite Beach UAQ',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(29,6,1,'Jebel Jais Zipline',NULL,NULL,650.00,455.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(30,6,1,'Jais Sledder',NULL,NULL,150.00,105.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(31,6,1,'Overnight Desert Camp',NULL,NULL,380.00,266.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(32,6,6,'Dhayah Fort',NULL,NULL,10.00,7.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(33,6,6,'Suwaidi Pearl Farm Tour',NULL,NULL,95.00,66.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(34,6,2,'Iceland Waterpark RAK',NULL,NULL,185.00,129.50,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(35,7,4,'Snoopy Island Snorkeling',NULL,NULL,140.00,98.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(36,7,6,'Fujairah Fort',NULL,NULL,10.00,7.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(37,7,6,'Al Bidya Mosque',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(38,7,1,'Scuba Diving Tour',NULL,NULL,380.00,266.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(39,7,1,'Wadi Wurayah National Park Hike',NULL,NULL,90.00,63.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(40,7,5,'Fujairah Friday Market',NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,1,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `activities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `activity_categories`
--

DROP TABLE IF EXISTS `activity_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activity_categories`
--

LOCK TABLES `activity_categories` WRITE;
/*!40000 ALTER TABLE `activity_categories` DISABLE KEYS */;
INSERT INTO `activity_categories` VALUES
(1,'Adventure','2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,'Family','2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,'Luxury','2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,'Beach','2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,'Shopping','2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,'Culture','2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `activity_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `areas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `areas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `city_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `tourist_zone` varchar(255) DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `areas_city_id_fk` (`city_id`),
  CONSTRAINT `areas_city_id_fk` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `areas` WRITE;
/*!40000 ALTER TABLE `areas` DISABLE KEYS */;
INSERT INTO `areas` VALUES
(1,1,'Corniche & Yas Island','abu-dhabi-main-area','Corniche & Yas Island',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,2,'Downtown & Marina','dubai-main-area','Downtown & Marina',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,3,'Al Qasba & Heritage Area','sharjah-main-area','Al Qasba & Heritage Area',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,4,'Ajman Corniche','ajman-main-area','Ajman Corniche',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,5,'UAQ Corniche','umm-al-quwain-main-area','UAQ Corniche',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,6,'Al Marjan Island','ras-al-khaimah-main-area','Al Marjan Island',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,7,'Al Aqah Beach','fujairah-main-area','Al Aqah Beach',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `areas` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `region_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `cities_region_id_fk` (`region_id`),
  CONSTRAINT `cities_region_id_fk` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cities` WRITE;
/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
INSERT INTO `cities` VALUES
(1,1,'Abu Dhabi','abu-dhabi-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,2,'Dubai','dubai-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,3,'Sharjah','sharjah-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,4,'Ajman','ajman-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,5,'Umm Al Quwain','umm-al-quwain-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,6,'Ras Al Khaimah','ras-al-khaimah-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,7,'Fujairah','fujairah-city',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cost_calculations`
--

DROP TABLE IF EXISTS `cost_calculations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cost_calculations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trip_plan_id` bigint(20) unsigned NOT NULL,
  `itinerary_id` bigint(20) unsigned DEFAULT NULL,
  `hotel_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `flight_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `visa_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `activities_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `transport_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `intercity_travel_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `yacht_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `food_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `insurance_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `markup_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `service_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `cost_per_person` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_family_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `daily_cost` decimal(12,2) NOT NULL DEFAULT 0.00,
  `cost_by_region` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`cost_by_region`)),
  `cost_by_activity` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`cost_by_activity`)),
  `profit` decimal(12,2) NOT NULL DEFAULT 0.00,
  `grand_total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cost_calculations_trip_plan_id_fk` (`trip_plan_id`),
  KEY `cost_calculations_itinerary_id_fk` (`itinerary_id`),
  CONSTRAINT `cost_calculations_itinerary_id_fk` FOREIGN KEY (`itinerary_id`) REFERENCES `itineraries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `cost_calculations_trip_plan_id_fk` FOREIGN KEY (`trip_plan_id`) REFERENCES `trip_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cost_calculations`
--

LOCK TABLES `cost_calculations` WRITE;
/*!40000 ALTER TABLE `cost_calculations` DISABLE KEYS */;
/*!40000 ALTER TABLE `cost_calculations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(3) NOT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `default_timezone` varchar(255) DEFAULT NULL,
  `languages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`languages`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES
(1,'United Arab Emirates','UAE','AED','Asia/Dubai','[\"Arabic\",\"English\"]',1,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `destinations`
--

DROP TABLE IF EXISTS `destinations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `destinations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `banner_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`banner_images`)),
  `weather_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`weather_info`)),
  `best_time_to_visit` varchar(255) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `languages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`languages`)),
  `nearby_airports` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`nearby_airports`)),
  `average_daily_budget` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `destinations_area_id_fk` (`area_id`),
  CONSTRAINT `destinations_area_id_fk` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `destinations`
--

LOCK TABLES `destinations` WRITE;
/*!40000 ALTER TABLE `destinations` DISABLE KEYS */;
/*!40000 ALTER TABLE `destinations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `flight_routes`
--

DROP TABLE IF EXISTS `flight_routes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `flight_routes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_label` varchar(255) NOT NULL,
  `region_group` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `airport_code` varchar(8) DEFAULT NULL,
  `origin_code` varchar(255) NOT NULL,
  `economy_fare_per_adult` decimal(10,2) NOT NULL,
  `manual_economy_fare_per_adult` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `origin_code` (`origin_code`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `flight_routes`
--

LOCK TABLES `flight_routes` WRITE;
/*!40000 ALTER TABLE `flight_routes` DISABLE KEYS */;
INSERT INTO `flight_routes` VALUES
(1,'Riyadh — RUH','GCC & Middle East','Riyadh','RUH','ruh',650.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(2,'Jeddah — JED','GCC & Middle East','Jeddah','JED','jed',680.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(3,'Doha — DOH','GCC & Middle East','Doha','DOH','doh',550.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(4,'Kuwait City — KWI','GCC & Middle East','Kuwait City','KWI','kwi',600.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(5,'Manama — BAH','GCC & Middle East','Manama','BAH','bah',520.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(6,'Muscat — MCT','GCC & Middle East','Muscat','MCT','mct',480.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(7,'Mumbai — BOM','Indian Subcontinent','Mumbai','BOM','bom',950.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(8,'Delhi — DEL','Indian Subcontinent','Delhi','DEL','del',1000.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(9,'Kochi — COK','Indian Subcontinent','Kochi','COK','cok',900.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(10,'Chennai — MAA','Indian Subcontinent','Chennai','MAA','maa',950.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(11,'Hyderabad — HYD','Indian Subcontinent','Hyderabad','HYD','hyd',980.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(12,'Colombo — CMB','Indian Subcontinent','Colombo','CMB','cmb',1100.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(13,'Manila — MNL','Southeast & East Asia','Manila','MNL','mnl',1900.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(14,'Kuala Lumpur — KUL','Southeast & East Asia','Kuala Lumpur','KUL','kul',1850.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(15,'Jakarta — CGK','Southeast & East Asia','Jakarta','CGK','cgk',2100.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(16,'Singapore — SIN','Southeast & East Asia','Singapore','SIN','sin',2000.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(17,'Bangkok — BKK','Southeast & East Asia','Bangkok','BKK','bkk',1750.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(18,'Nairobi — NBO','Africa','Nairobi','NBO','nbo',1600.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(19,'Cairo — CAI','Africa','Cairo','CAI','cai',1300.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(20,'Lagos — LOS','Africa','Lagos','LOS','los',2400.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(21,'Addis Ababa — ADD','Africa','Addis Ababa','ADD','add',1500.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(22,'London — LHR','Europe','London','LHR','lhr',2200.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(23,'Paris — CDG','Europe','Paris','CDG','cdg',2150.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(24,'Frankfurt — FRA','Europe','Frankfurt','FRA','fra',2100.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(25,'Istanbul — IST','Europe','Istanbul','IST','ist',1400.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(26,'New York — JFK','Americas','New York','JFK','jfk',4300.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(27,'Toronto — YYZ','Americas','Toronto','YYZ','yyz',4400.00,NULL,1,'2026-07-15 10:00:00','2026-07-15 10:00:00');
/*!40000 ALTER TABLE `flight_routes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hotel_room_types`
--

DROP TABLE IF EXISTS `hotel_room_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hotel_room_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hotel_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `max_occupancy` tinyint(3) unsigned NOT NULL DEFAULT 2,
  `base_price_per_night` decimal(10,2) NOT NULL,
  `ai_price` decimal(10,2) DEFAULT NULL,
  `manual_price` decimal(10,2) DEFAULT NULL,
  `season` varchar(255) DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_room_types_hotel_id_fk` (`hotel_id`),
  CONSTRAINT `hotel_room_types_hotel_id_fk` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hotel_room_types`
--

LOCK TABLES `hotel_room_types` WRITE;
/*!40000 ALTER TABLE `hotel_room_types` DISABLE KEYS */;
INSERT INTO `hotel_room_types` VALUES
(1,1,'Standard',3,230.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,2,'Standard',3,250.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,3,'Standard',3,380.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,4,'Standard',3,420.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,5,'Standard',3,1450.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,6,'Standard',3,260.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,7,'Standard',3,380.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(8,8,'Standard',3,650.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(9,9,'Standard',3,980.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(10,10,'Standard',3,2100.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(11,11,'Standard',3,5200.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(12,12,'Standard',3,200.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(13,13,'Standard',3,220.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(14,14,'Standard',3,310.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(15,15,'Standard',3,350.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(16,16,'Standard',3,520.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(17,17,'Standard',3,200.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(18,18,'Standard',3,230.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(19,19,'Standard',3,650.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(20,20,'Standard',3,890.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(21,21,'Standard',3,950.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(22,22,'Standard',3,200.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(23,23,'Standard',3,250.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(24,24,'Standard',3,420.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(25,25,'Standard',3,520.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(26,26,'Standard',3,220.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(27,27,'Standard',3,240.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(28,28,'Standard',3,300.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(29,29,'Standard',3,480.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(30,30,'Standard',3,980.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(31,31,'Standard',3,1350.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(32,32,'Standard',3,260.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(33,33,'Standard',3,300.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(34,34,'Standard',3,390.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(35,35,'Standard',3,720.00,NULL,NULL,NULL,1,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `hotel_room_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hotels`
--

DROP TABLE IF EXISTS `hotels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hotels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `star_rating` tinyint(3) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  `amenities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`amenities`)),
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hotels_area_id_fk` (`area_id`),
  CONSTRAINT `hotels_area_id_fk` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hotels`
--

LOCK TABLES `hotels` WRITE;
/*!40000 ALTER TABLE `hotels` DISABLE KEYS */;
INSERT INTO `hotels` VALUES
(1,1,'Premier Inn Abu Dhabi Capital',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,1,'Ibis Abu Dhabi Gate',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,1,'Aloft Abu Dhabi',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,1,'Yas Island Rotana',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,1,'Emirates Palace Mandarin Oriental',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,2,'Ibis Styles Dubai Deira',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,2,'Rove Downtown',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(8,2,'Hilton Dubai Jumeirah',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(9,2,'Address Dubai Marina',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(10,2,'Atlantis The Palm',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(11,2,'Burj Al Arab Jumeirah',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(12,3,'Premier Inn Sharjah',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(13,3,'Coral Sharjah',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(14,3,'Sharjah Grand Hotel',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(15,3,'Radisson Blu Sharjah',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(16,3,'Sheraton Sharjah Beach Resort',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(17,4,'Ajman Beach Hotel',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(18,4,'City Seasons Ajman',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(19,4,'Fairmont Ajman',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(20,4,'Ajman Saray, a Luxury Collection Resort',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(21,4,'Oberoi Beach Resort Ajman',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(22,5,'UAQ Corniche Hotel',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(23,5,'Barracuda Beach Resort',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(24,5,'Palma Beach Resort & Spa',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(25,5,'Fairmont Al Salam Resort UAQ',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(26,6,'Bin Majid Beach Hotel',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(27,6,'Ras Al Khaimah Hotel',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(28,6,'Hampton by Hilton RAK',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(29,6,'DoubleTree by Hilton Marjan Island',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(30,6,'InterContinental RAK Mina Al Arab',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(31,6,'Waldorf Astoria Ras Al Khaimah',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(32,7,'City Stay Beach Hotel',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(33,7,'Fujairah Rotana Resort',3,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(34,7,'Miramar Al Aqah Beach Resort',4,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(35,7,'Le Meridien Al Aqah Beach Resort',5,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `hotels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itineraries`
--

DROP TABLE IF EXISTS `itineraries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `itineraries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trip_plan_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `total_days` int(10) unsigned NOT NULL,
  `ai_summary` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `itineraries_trip_plan_id_fk` (`trip_plan_id`),
  CONSTRAINT `itineraries_trip_plan_id_fk` FOREIGN KEY (`trip_plan_id`) REFERENCES `trip_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `itineraries`
--

LOCK TABLES `itineraries` WRITE;
/*!40000 ALTER TABLE `itineraries` DISABLE KEYS */;
/*!40000 ALTER TABLE `itineraries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itinerary_days`
--

DROP TABLE IF EXISTS `itinerary_days`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `itinerary_days` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `itinerary_id` bigint(20) unsigned NOT NULL,
  `day_number` int(10) unsigned NOT NULL,
  `region_id` bigint(20) unsigned DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `itinerary_days_itinerary_id_fk` (`itinerary_id`),
  KEY `itinerary_days_region_id_fk` (`region_id`),
  CONSTRAINT `itinerary_days_itinerary_id_fk` FOREIGN KEY (`itinerary_id`) REFERENCES `itineraries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `itinerary_days_region_id_fk` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `itinerary_days`
--

LOCK TABLES `itinerary_days` WRITE;
/*!40000 ALTER TABLE `itinerary_days` DISABLE KEYS */;
/*!40000 ALTER TABLE `itinerary_days` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itinerary_items`
--

DROP TABLE IF EXISTS `itinerary_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `itinerary_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `itinerary_day_id` bigint(20) unsigned NOT NULL,
  `itemable_type` varchar(255) NOT NULL,
  `itemable_id` bigint(20) unsigned NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0,
  `quoted_price` decimal(10,2) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `itinerary_items_day_id_fk` (`itinerary_day_id`),
  KEY `itinerary_items_itemable_index` (`itemable_type`,`itemable_id`),
  CONSTRAINT `itinerary_items_day_id_fk` FOREIGN KEY (`itinerary_day_id`) REFERENCES `itinerary_days` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `itinerary_items`
--

LOCK TABLES `itinerary_items` WRITE;
/*!40000 ALTER TABLE `itinerary_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `itinerary_items` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leads`
--

DROP TABLE IF EXISTS `leads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trip_plan_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `quote_snapshot` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`quote_snapshot`)),
  `status` varchar(255) NOT NULL DEFAULT 'new',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leads_trip_plan_id_fk` (`trip_plan_id`),
  CONSTRAINT `leads_trip_plan_id_fk` FOREIGN KEY (`trip_plan_id`) REFERENCES `trip_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leads`
--

LOCK TABLES `leads` WRITE;
/*!40000 ALTER TABLE `leads` DISABLE KEYS */;
/*!40000 ALTER TABLE `leads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `marinas`
--

DROP TABLE IF EXISTS `marinas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `marinas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marinas_area_id_fk` (`area_id`),
  CONSTRAINT `marinas_area_id_fk` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `marinas`
--

LOCK TABLES `marinas` WRITE;
/*!40000 ALTER TABLE `marinas` DISABLE KEYS */;
INSERT INTO `marinas` VALUES
(1,1,'Yas Marina',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,2,'Dubai Marina',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,6,'Al Hamra / Mina Al Arab Marina',NULL,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `marinas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` 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,'0001_01_01_000010_create_countries_table',1),
(5,'0001_01_01_000020_create_states_table',1),
(6,'0001_01_01_000030_create_regions_table',1),
(7,'0001_01_01_000040_create_cities_table',1),
(8,'0001_01_01_000050_create_areas_table',1),
(9,'0001_01_01_000060_create_destinations_table',1),
(10,'0001_01_01_000070_create_hotels_table',1),
(11,'0001_01_01_000080_create_activities_table',1),
(12,'0001_01_01_000090_create_restaurants_table',1),
(13,'0001_01_01_000100_create_transport_tables',1),
(14,'0001_01_01_000110_create_marina_and_yacht_tables',1),
(15,'0001_01_01_000120_create_trip_plans_table',1),
(16,'0001_01_01_000130_create_itinerary_tables',1),
(17,'0001_01_01_000140_create_cost_calculations_table',1),
(18,'0001_01_01_000150_create_flight_routes_table',1),
(19,'0001_01_01_000160_add_planner_fields_to_trip_plans_table',2),
(20,'0001_01_01_000170_add_region_group_to_flight_routes_table',2),
(21,'0001_01_01_000180_add_self_drive_tier_to_transports_table',2),
(22,'0001_01_01_000190_create_leads_table',2),
(23,'0001_01_01_000200_add_new_transport_types_enum',3),
(24,'0001_01_01_000210_add_is_admin_to_users_table',3);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `regions`
--

DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `regions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint(20) unsigned NOT NULL,
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `coast` enum('gulf','oman') NOT NULL DEFAULT 'gulf',
  `description` text DEFAULT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `average_daily_budget` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `regions_country_id_fk` (`country_id`),
  KEY `regions_state_id_fk` (`state_id`),
  CONSTRAINT `regions_country_id_fk` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `regions_state_id_fk` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regions`
--

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` VALUES
(1,1,NULL,'Abu Dhabi','abu-dhabi',1,'gulf',NULL,NULL,450.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,1,NULL,'Dubai','dubai',2,'gulf',NULL,NULL,600.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,1,NULL,'Sharjah','sharjah',3,'gulf',NULL,NULL,280.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,1,NULL,'Ajman','ajman',4,'gulf',NULL,NULL,220.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,1,NULL,'Umm Al Quwain','umm-al-quwain',5,'gulf',NULL,NULL,200.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,1,NULL,'Ras Al Khaimah','ras-al-khaimah',6,'gulf',NULL,NULL,320.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,1,NULL,'Fujairah','fujairah',7,'oman',NULL,NULL,260.00,1,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurants`
--

DROP TABLE IF EXISTS `restaurants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `restaurants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `cuisine_type` varchar(255) DEFAULT NULL,
  `price_tier` tinyint(3) unsigned DEFAULT NULL,
  `average_cost_per_person` decimal(10,2) DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurants_area_id_fk` (`area_id`),
  CONSTRAINT `restaurants_area_id_fk` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurants`
--

LOCK TABLES `restaurants` WRITE;
/*!40000 ALTER TABLE `restaurants` DISABLE KEYS */;
INSERT INTO `restaurants` VALUES
(1,1,'Li Beirut, Corniche','Lebanese',NULL,250.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(2,1,'Talea by Antoine','French',NULL,300.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(3,1,'Angar Indian Restaurant','Indian',NULL,180.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(4,1,'Nolu\'s Cafe','International',NULL,140.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(5,2,'Pierchic, Madinat Jumeirah','Seafood',NULL,420.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(6,2,'At.mosphere, Burj Khalifa','International',NULL,650.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(7,2,'Zheng He\'s','Chinese',NULL,220.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(8,2,'Ravi Restaurant','Pakistani',NULL,60.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(9,3,'Al Fanar Restaurant, Al Qasba','Emirati',NULL,140.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(10,3,'Kacip Kitchen','Asian',NULL,120.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(11,3,'Cafe Younes','Lebanese',NULL,110.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(12,4,'Kababji Ajman Corniche','Lebanese',NULL,110.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(13,4,'Filfil Restaurant','Arabic',NULL,130.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(14,4,'China Grand Restaurant','Chinese',NULL,100.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(15,5,'UAQ Marine Club Grill','Seafood',NULL,130.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(16,5,'Al Salam Restaurant','Arabic',NULL,90.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(17,5,'Barracuda Beach Grill','International',NULL,150.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(18,6,'Bab Al Bahr, Al Marjan Island','Mediterranean',NULL,190.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(19,6,'Camel Bar & Grill','International',NULL,160.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(20,6,'Al Fanar Seafood RAK','Seafood',NULL,200.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(21,7,'Rugged Shores Beach Club','International',NULL,160.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(22,7,'Fisherman\'s Corner','Seafood',NULL,140.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15'),
(23,7,'Al Meshwar Restaurant','Arabic',NULL,100.00,NULL,'2026-07-07 13:11:15','2026-07-07 13:11:15');
/*!40000 ALTER TABLE `restaurants` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `states`
--

DROP TABLE IF EXISTS `states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `states` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `states_country_id_fk` (`country_id`),
  CONSTRAINT `states_country_id_fk` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `states`
--

LOCK TABLES `states` WRITE;
/*!40000 ALTER TABLE `states` DISABLE KEYS */;
/*!40000 ALTER TABLE `states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transports`
--

DROP TABLE IF EXISTS `transports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `origin_area_id` bigint(20) unsigned NOT NULL,
  `destination_area_id` bigint(20) unsigned DEFAULT NULL,
  `type` enum('metro','taxi','uber','careem','rental_car','suv_rental','luxury_car','chauffeur','bus','airport_transfer','private_transfer','intercity_transfer','oneclick_drive','mk_rental_self_drive') NOT NULL,
  `self_drive_tier` enum('eco','luxury','ultra_luxury','exotic') DEFAULT NULL,
  `distance_km` decimal(8,2) DEFAULT NULL,
  `duration_minutes` int(10) unsigned DEFAULT NULL,
  `max_passengers` tinyint(3) unsigned DEFAULT NULL,
  `base_price` decimal(10,2) NOT NULL,
  `ai_price` decimal(10,2) DEFAULT NULL,
  `manual_price` decimal(10,2) DEFAULT NULL,
  `season` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transports_origin_area_id_fk` (`origin_area_id`),
  KEY `transports_destination_area_id_fk` (`destination_area_id`),
  CONSTRAINT `transports_destination_area_id_fk` FOREIGN KEY (`destination_area_id`) REFERENCES `areas` (`id`) ON DELETE SET NULL,
  CONSTRAINT `transports_origin_area_id_fk` FOREIGN KEY (`origin_area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transports`
--

LOCK TABLES `transports` WRITE;
/*!40000 ALTER TABLE `transports` DISABLE KEYS */;
INSERT INTO `transports` VALUES
(1,1,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(2,1,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(3,1,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(4,2,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(5,2,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(6,2,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(7,3,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(8,3,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(9,3,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(10,4,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(11,4,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(12,4,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(13,5,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(14,5,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(15,5,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(16,6,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(17,6,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(18,6,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(19,7,NULL,'oneclick_drive',NULL,NULL,NULL,NULL,250.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(20,7,NULL,'mk_rental_self_drive',NULL,NULL,NULL,NULL,320.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(21,7,NULL,'chauffeur',NULL,NULL,NULL,NULL,480.00,NULL,NULL,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(22,1,2,'bus',NULL,140.00,NULL,NULL,84.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(23,1,2,'rental_car','eco',140.00,NULL,NULL,252.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(24,1,2,'rental_car','luxury',140.00,NULL,NULL,490.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(25,1,2,'rental_car','ultra_luxury',140.00,NULL,NULL,910.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(26,1,2,'rental_car','exotic',140.00,NULL,NULL,1680.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(27,1,2,'suv_rental',NULL,140.00,NULL,NULL,364.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(28,1,2,'private_transfer',NULL,140.00,NULL,NULL,448.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(29,1,2,'airport_transfer',NULL,140.00,NULL,NULL,532.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(30,1,2,'chauffeur',NULL,140.00,NULL,NULL,770.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(31,2,1,'bus',NULL,140.00,NULL,NULL,84.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(32,2,1,'rental_car','eco',140.00,NULL,NULL,252.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(33,2,1,'rental_car','luxury',140.00,NULL,NULL,490.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(34,2,1,'rental_car','ultra_luxury',140.00,NULL,NULL,910.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(35,2,1,'rental_car','exotic',140.00,NULL,NULL,1680.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(36,2,1,'suv_rental',NULL,140.00,NULL,NULL,364.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(37,2,1,'private_transfer',NULL,140.00,NULL,NULL,448.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(38,2,1,'airport_transfer',NULL,140.00,NULL,NULL,532.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(39,2,1,'chauffeur',NULL,140.00,NULL,NULL,770.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(40,2,3,'bus',NULL,15.00,NULL,NULL,9.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(41,2,3,'rental_car','eco',15.00,NULL,NULL,27.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(42,2,3,'rental_car','luxury',15.00,NULL,NULL,52.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(43,2,3,'rental_car','ultra_luxury',15.00,NULL,NULL,97.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(44,2,3,'rental_car','exotic',15.00,NULL,NULL,180.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(45,2,3,'suv_rental',NULL,15.00,NULL,NULL,39.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(46,2,3,'private_transfer',NULL,15.00,NULL,NULL,48.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(47,2,3,'airport_transfer',NULL,15.00,NULL,NULL,57.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(48,2,3,'chauffeur',NULL,15.00,NULL,NULL,82.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(49,3,2,'bus',NULL,15.00,NULL,NULL,9.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(50,3,2,'rental_car','eco',15.00,NULL,NULL,27.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(51,3,2,'rental_car','luxury',15.00,NULL,NULL,52.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(52,3,2,'rental_car','ultra_luxury',15.00,NULL,NULL,97.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(53,3,2,'rental_car','exotic',15.00,NULL,NULL,180.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(54,3,2,'suv_rental',NULL,15.00,NULL,NULL,39.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(55,3,2,'private_transfer',NULL,15.00,NULL,NULL,48.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(56,3,2,'airport_transfer',NULL,15.00,NULL,NULL,57.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(57,3,2,'chauffeur',NULL,15.00,NULL,NULL,82.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(58,3,4,'bus',NULL,20.00,NULL,NULL,12.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(59,3,4,'rental_car','eco',20.00,NULL,NULL,36.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(60,3,4,'rental_car','luxury',20.00,NULL,NULL,70.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(61,3,4,'rental_car','ultra_luxury',20.00,NULL,NULL,130.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(62,3,4,'rental_car','exotic',20.00,NULL,NULL,240.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(63,3,4,'suv_rental',NULL,20.00,NULL,NULL,52.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(64,3,4,'private_transfer',NULL,20.00,NULL,NULL,64.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(65,3,4,'airport_transfer',NULL,20.00,NULL,NULL,76.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(66,3,4,'chauffeur',NULL,20.00,NULL,NULL,110.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(67,4,3,'bus',NULL,20.00,NULL,NULL,12.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(68,4,3,'rental_car','eco',20.00,NULL,NULL,36.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(69,4,3,'rental_car','luxury',20.00,NULL,NULL,70.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(70,4,3,'rental_car','ultra_luxury',20.00,NULL,NULL,130.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(71,4,3,'rental_car','exotic',20.00,NULL,NULL,240.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(72,4,3,'suv_rental',NULL,20.00,NULL,NULL,52.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(73,4,3,'private_transfer',NULL,20.00,NULL,NULL,64.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(74,4,3,'airport_transfer',NULL,20.00,NULL,NULL,76.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(75,4,3,'chauffeur',NULL,20.00,NULL,NULL,110.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(76,4,5,'bus',NULL,25.00,NULL,NULL,15.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(77,4,5,'rental_car','eco',25.00,NULL,NULL,45.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(78,4,5,'rental_car','luxury',25.00,NULL,NULL,87.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(79,4,5,'rental_car','ultra_luxury',25.00,NULL,NULL,162.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(80,4,5,'rental_car','exotic',25.00,NULL,NULL,300.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(81,4,5,'suv_rental',NULL,25.00,NULL,NULL,65.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(82,4,5,'private_transfer',NULL,25.00,NULL,NULL,80.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(83,4,5,'airport_transfer',NULL,25.00,NULL,NULL,95.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(84,4,5,'chauffeur',NULL,25.00,NULL,NULL,137.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(85,5,4,'bus',NULL,25.00,NULL,NULL,15.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(86,5,4,'rental_car','eco',25.00,NULL,NULL,45.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(87,5,4,'rental_car','luxury',25.00,NULL,NULL,87.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(88,5,4,'rental_car','ultra_luxury',25.00,NULL,NULL,162.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(89,5,4,'rental_car','exotic',25.00,NULL,NULL,300.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(90,5,4,'suv_rental',NULL,25.00,NULL,NULL,65.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(91,5,4,'private_transfer',NULL,25.00,NULL,NULL,80.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(92,5,4,'airport_transfer',NULL,25.00,NULL,NULL,95.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(93,5,4,'chauffeur',NULL,25.00,NULL,NULL,137.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(94,5,6,'bus',NULL,45.00,NULL,NULL,27.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(95,5,6,'rental_car','eco',45.00,NULL,NULL,81.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(96,5,6,'rental_car','luxury',45.00,NULL,NULL,157.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(97,5,6,'rental_car','ultra_luxury',45.00,NULL,NULL,292.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(98,5,6,'rental_car','exotic',45.00,NULL,NULL,540.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(99,5,6,'suv_rental',NULL,45.00,NULL,NULL,117.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(100,5,6,'private_transfer',NULL,45.00,NULL,NULL,144.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(101,5,6,'airport_transfer',NULL,45.00,NULL,NULL,171.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(102,5,6,'chauffeur',NULL,45.00,NULL,NULL,247.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(103,6,5,'bus',NULL,45.00,NULL,NULL,27.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(104,6,5,'rental_car','eco',45.00,NULL,NULL,81.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(105,6,5,'rental_car','luxury',45.00,NULL,NULL,157.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(106,6,5,'rental_car','ultra_luxury',45.00,NULL,NULL,292.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(107,6,5,'rental_car','exotic',45.00,NULL,NULL,540.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(108,6,5,'suv_rental',NULL,45.00,NULL,NULL,117.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(109,6,5,'private_transfer',NULL,45.00,NULL,NULL,144.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(110,6,5,'airport_transfer',NULL,45.00,NULL,NULL,171.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(111,6,5,'chauffeur',NULL,45.00,NULL,NULL,247.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(112,6,7,'bus',NULL,95.00,NULL,NULL,57.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(113,6,7,'rental_car','eco',95.00,NULL,NULL,171.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(114,6,7,'rental_car','luxury',95.00,NULL,NULL,332.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(115,6,7,'rental_car','ultra_luxury',95.00,NULL,NULL,617.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(116,6,7,'rental_car','exotic',95.00,NULL,NULL,1140.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(117,6,7,'suv_rental',NULL,95.00,NULL,NULL,247.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(118,6,7,'private_transfer',NULL,95.00,NULL,NULL,304.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(119,6,7,'airport_transfer',NULL,95.00,NULL,NULL,361.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(120,6,7,'chauffeur',NULL,95.00,NULL,NULL,522.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(121,7,6,'bus',NULL,95.00,NULL,NULL,57.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(122,7,6,'rental_car','eco',95.00,NULL,NULL,171.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(123,7,6,'rental_car','luxury',95.00,NULL,NULL,332.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(124,7,6,'rental_car','ultra_luxury',95.00,NULL,NULL,617.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(125,7,6,'rental_car','exotic',95.00,NULL,NULL,1140.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(126,7,6,'suv_rental',NULL,95.00,NULL,NULL,247.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(127,7,6,'private_transfer',NULL,95.00,NULL,NULL,304.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(128,7,6,'airport_transfer',NULL,95.00,NULL,NULL,361.00,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00'),
(129,7,6,'chauffeur',NULL,95.00,NULL,NULL,522.50,NULL,NULL,NULL,'2026-07-15 10:00:00','2026-07-15 10:00:00');
/*!40000 ALTER TABLE `transports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trip_plans`
--

DROP TABLE IF EXISTS `trip_plans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trip_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `budget` decimal(12,2) DEFAULT NULL,
  `number_of_days` int(10) unsigned NOT NULL,
  `adults` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `children` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `infants` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `preferred_region_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`preferred_region_ids`)),
  `emirates_count` tinyint(3) unsigned DEFAULT NULL,
  `hotel_category` varchar(255) DEFAULT NULL,
  `preferred_area` varchar(255) DEFAULT NULL,
  `occasion` varchar(255) DEFAULT NULL,
  `interests` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`interests`)),
  `status` enum('draft','generated','confirmed') NOT NULL DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trip_plans_user_id_fk` (`user_id`),
  CONSTRAINT `trip_plans_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trip_plans`
--

LOCK TABLES `trip_plans` WRITE;
/*!40000 ALTER TABLE `trip_plans` DISABLE KEYS */;
/*!40000 ALTER TABLE `trip_plans` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Travel System Cost Admin','admin@dextratechnologies.com',NULL,'$2b$12$Q2a09ms/bkpP9MUDDPeANeQ.PcEwXVhIXnaWgDUayMupuD3GtxkWS',1,NULL,'2026-08-20 09:00:00','2026-08-20 09:00:00');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yachts`
--

DROP TABLE IF EXISTS `yachts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `yachts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `marina_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `length_ft` int(10) unsigned DEFAULT NULL,
  `max_guests` tinyint(3) unsigned DEFAULT NULL,
  `price_per_hour` decimal(10,2) DEFAULT NULL,
  `price_per_day` decimal(10,2) DEFAULT NULL,
  `ai_price` decimal(10,2) DEFAULT NULL,
  `manual_price` decimal(10,2) DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `yachts_marina_id_fk` (`marina_id`),
  CONSTRAINT `yachts_marina_id_fk` FOREIGN KEY (`marina_id`) REFERENCES `marinas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yachts`
--

LOCK TABLES `yachts` WRITE;
/*!40000 ALTER TABLE `yachts` DISABLE KEYS */;
INSERT INTO `yachts` VALUES
(1,1,'Gunaydin Yacht Services','Standard',50,NULL,450.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(2,1,'Gunaydin Yacht Services','Luxury',50,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(3,1,'Gunaydin Yacht Services','Ultra Luxury',50,NULL,950.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(4,1,'Gunaydin Yacht Services','Standard',60,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(5,1,'Gunaydin Yacht Services','Luxury',60,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(6,1,'Gunaydin Yacht Services','Ultra Luxury',60,NULL,1300.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(7,1,'Gunaydin Yacht Services','Standard',70,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(8,1,'Gunaydin Yacht Services','Luxury',70,NULL,1250.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(9,1,'Gunaydin Yacht Services','Ultra Luxury',70,NULL,1800.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(10,2,'Gunaydin Yacht Services','Standard',50,NULL,450.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(11,2,'Gunaydin Yacht Services','Luxury',50,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(12,2,'Gunaydin Yacht Services','Ultra Luxury',50,NULL,950.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(13,2,'Gunaydin Yacht Services','Standard',60,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(14,2,'Gunaydin Yacht Services','Luxury',60,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(15,2,'Gunaydin Yacht Services','Ultra Luxury',60,NULL,1300.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(16,2,'Gunaydin Yacht Services','Standard',70,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(17,2,'Gunaydin Yacht Services','Luxury',70,NULL,1250.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(18,2,'Gunaydin Yacht Services','Ultra Luxury',70,NULL,1800.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(19,3,'Gunaydin Yacht Services','Standard',50,NULL,450.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(20,3,'Gunaydin Yacht Services','Luxury',50,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(21,3,'Gunaydin Yacht Services','Ultra Luxury',50,NULL,950.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(22,3,'Gunaydin Yacht Services','Standard',60,NULL,650.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(23,3,'Gunaydin Yacht Services','Luxury',60,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(24,3,'Gunaydin Yacht Services','Ultra Luxury',60,NULL,1300.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(25,3,'Gunaydin Yacht Services','Standard',70,NULL,900.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(26,3,'Gunaydin Yacht Services','Luxury',70,NULL,1250.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00'),
(27,3,'Gunaydin Yacht Services','Ultra Luxury',70,NULL,1800.00,NULL,NULL,NULL,NULL,1,'2026-08-20 09:00:00','2026-08-20 09:00:00');
/*!40000 ALTER TABLE `yachts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'uae_travel_system'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-07 13:22:56