-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: flying_experto
-- ------------------------------------------------------
-- Server version	8.0.39-0ubuntu0.24.04.2

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `airports_details`
--

DROP TABLE IF EXISTS `airports_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `airports_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `iata_code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `city_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `airport_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `country` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=234 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `airports_details`
--

LOCK TABLES `airports_details` WRITE;
/*!40000 ALTER TABLE `airports_details` DISABLE KEYS */;
INSERT INTO `airports_details` VALUES (1,'KHI','KARACHI','Jinnah International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(2,'LHE','LAHORE','Allama Iqbal International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(3,'ISB','ISLAMABAD','Islamabad International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(4,'MUX','MULTAN','Multan International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(5,'UET','QUETTA','Quetta International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(6,'SKT','SALKOIT','Sialkot International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(7,'LYP','FAISLABAD','Faisalabad International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(8,'GIL','GILGIT','Gilgit Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(9,'CJL','CHITRAL','Chitral Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(10,'KDU','SKARDU','Skardu International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(11,'PEW','PESHAWAR','Bacha Khan International Airport,','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(12,'TUK','TURBAT','Turbat International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(13,'YOW','OTTAWA*','Ottawa International Airport','CANADA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(14,'YYC','CALGARY','Calgary International Airport','CANADA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(15,'YUL','MONTREAL','Montréal-Trudeau International Airport','CANADA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(16,'YYZ','TORONTO','Toronto Pearson Airport','CANADA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(17,'YVR','VANCOUVER','Vancouver International Airport','CANADA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(18,'DTT','DETROIT','Detroit-Wayne County Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(19,'DFW','DALLAS','Dallas Fort Worth International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(20,'HOU','HOUSTON','William P. Hobby Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(21,'MSY','NEW ORLEANS','Louis Armstrong New Orleans International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(22,'ATL','ATLANTA','Hartsfield-Jackson Atlanta International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(23,'MIA','MIAMI','Miami international airport code','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(24,'WAS,IAD','WASHINGTON*','Dulles International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(25,'PHI','PHILANDELPHIA','PHL Philadelphia International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(26,'NYC','NEW YORK','John F. Kennedy International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(27,'BOS','BOSTON','Boston Logan International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(28,'MEX','MEXICO','Mexico City International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(29,'ACA','ACAPULCO','Acapulco International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(30,'','SOUTH AMERICA','','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(31,'BSB','BRASILIA','Brasília International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(32,'RIO','RIO DE JANEIRO','Rio de Janeiro/Galeão International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(33,'SAO','SAO PAULO','São Paulo/Guarulhos International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(34,'ASU','ASUNCION','Silvio Pettirossi International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(35,'MVD','MONTEVIDEO','Carrasco International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(36,'BUE','BUENOS AIRES','Buenos Aires Airport (EZE)','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(37,'HAV','HAVANA','José Martí International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(38,'SCL','SANTIAGO','Arturo Merino Benítez International Airport','AMERICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(39,'REK','REYKJAVIK','Reykjavík Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(40,'ABZ','ABERDEEN','Aberdeen Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(41,'EDI','EDINBURGH','Edinburgh Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(42,'GLA','GALSGOW','Glasgow Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(43,'LPL','LIVERPOOL','Liverpool John Lennon Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(44,'MAN','MANCHESTER','Manchester Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(45,'BHX','BIRMINGHAM','Birmingham Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(46,'LON,LHR','LONDON*','London International Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(47,'BFS','BELFAST','Belfast International Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(48,'DUB','DUBLIN*','Dublin Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(49,'SNN','SHANNON','Shannon Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(50,'PAR','PARIS*','Paris Charles de Gaulle Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(51,'BRU','BRUSSELS*','Brussels Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(52,'AMS','AMSTERDAM*','Amsterdam Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(53,'CPH','COPENHAGEN*','Copenhagen Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(54,'AAL','AABORG','Aalborg Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(55,'GOT','GOTHENBURG','Göteborg Landvetter Airport - Swedavia','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(56,'STO','STOCKHOLM*','Stockholm Arlanda Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(57,'OSL','OSLO*','Oslo Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(58,'BGO','BERGEN','Bergen Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(59,'HEL','HELSINKI*','Helsinki Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(60,'HAM','HAMBURG','Hamburg Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(61,'BRE','BREMEN','Bremen Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(62,'DUS','DUSSELDORF','Düsseldorf Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(63,'FRA','FRANKFURT','Frankfurt Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(64,'MUC','MUNICH','Munich International Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(65,'BER','BERLIN','Berlin Brandenburg Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(66,'LUX','LUXEMBOURG*','Luxembourg-Findel International','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(67,'PRG','PRAGUE*','Václav Havel Airport Prague','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(68,'WAW','WARSAW*','Warsaw Chopin Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(69,'IEV','KIVE','Kyiv International Airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(70,'MOW','MOSCOW*','Sheremetyevo - A.S. Pushkin international airport','EUROPE 1','0000-00-00 00:00:00','2024-05-27 19:13:26'),(71,'FRU','BISHKEK,','Manas International Airport','KYRGYZSTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(72,'TBS','Tbilisi','Tbilisi International Airport','Georgia','0000-00-00 00:00:00','2024-05-27 19:13:26'),(73,'LEX','LENINGAD','Pulkovo Airport','RUSSAI','0000-00-00 00:00:00','2024-05-27 19:13:26'),(74,'CAS','CASABLANCA','Casablanca Mohammed V International Airport','MOROCCO','0000-00-00 00:00:00','2024-05-27 19:13:26'),(75,'RBA','RABAT*','Rabat - Sale International Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(76,'TNG','TANGIER','Tangier Ibn Battouta Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(77,'LPA','LAS PALMAS','Gran Canaria Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(78,'AGP','MALAGA*','Málaga-Costa del Sol Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(79,'MAD','MADRID','Adolfo Suárez Madrid-Barajas Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(80,'BCN','BARCELONA','Josep Tarradellas Barcelona-El Prat Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(81,'VLC','VALENCIA','Valencia Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(82,'PMI','PALMA DE MALLORCA','Palma de Mallorca Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(83,'LIS','LISBON*','Humberto Delgado Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(84,'OPO','PORTO','Francisco Sá Carneiro Airport','EUROPE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(85,'TAF','ORAN','Oran Ahmed Ben Bella Airport','ALGERIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(86,'ALG','ALGERS*','Algiers International Airport Houari Boumediene','','0000-00-00 00:00:00','2024-05-27 19:13:26'),(87,'TUN','TUNIS*','Tunis-Carthage International Airport','TUNISA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(88,'MRS','MARSEILLE','Marseille Provence Airport','FRANCE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(89,'TLS','TOULOUSE','Toulouse-Blagnac Airport','FRANCE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(90,'LYS','LYON','Lyon-Saint Exupéry Airport','FRANCE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(91,'NCE','NICE','Nice Côte d\'Azur Airport','FRANCE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(92,'GVA','GENEVA','Geneva Airport','SWITZERLAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(93,'ZRH','ZURICH','zurich airport code','SWITZERLAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(94,'GOA','GENOA','Genoa Cristoforo Colombo Airport','ITLY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(95,'MAIL,MXP','MILAN','Milan Malpensa Airport','ITLY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(96,'ROM','ROME*','Leonardo da Vinci–Fiumicino Airport','ITLY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(97,'NAP','NAPLES','Naples International Airport','ITLY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(98,'PMO','PA;EROM','Palermo Airport','ITLY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(99,'MLA','MALTA','Malta International Airport','MALTA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(100,'SZG','SALZBURG','salzburg airport code','AUSTRIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(101,'VIE','VIENNA*','Vienna International Airport','AUSTRIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(102,'ZAG','ZAGREB','Franjo Tuđman Airport Zagreb','Croatia','0000-00-00 00:00:00','2024-05-27 19:13:26'),(103,'DBV','DUBROVNIC','Dubrovnik Airport','Croatia','0000-00-00 00:00:00','2024-05-27 19:13:26'),(104,'BEG','BELGADE*','Belgrade Nikola Tesla Airport','Croatia','0000-00-00 00:00:00','2024-05-27 19:13:26'),(105,'BUD','BUDAPEST*','Budapest Ferenc Liszt International Airport','HUNGARY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(106,'BUH','BUCHREST*','Bucharest Henri Coandă International Airport','ROMNIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(107,'SOF','SOFIA*','Sofia International Airport','BULGARIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(108,'IST','ISTNBUL','Istanbul Airport','TURKEY','0000-00-00 00:00:00','2024-05-27 19:13:26'),(109,'SKG','THESSALONIKI','Thessaloniki Airport Makedonia','GREECE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(110,'ATH','ATHENS*','Athens International Airport','GREECE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(111,'RHO','RHODES','Rhodes International Airport','GREECE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(112,'KWI','KUWAIT*','Kuwait International Airport','KUWAIT','0000-00-00 00:00:00','2024-05-27 19:13:26'),(113,'BGD','BAGHDAD*','Baghdad International Airport','IRAQ','0000-00-00 00:00:00','2024-05-27 19:13:26'),(114,'AMM','AMMAN*','Queen Alia International Airport','JORDAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(115,'DAM','DAMASCUS*','Damascus International Airport','SYRIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(116,'BEY','BEIRUT*','Beirut Rafic Hariri International Airport','LEBANON','0000-00-00 00:00:00','2024-05-27 19:13:26'),(117,'LCA','LARNACA','Larnaca International Airport','CYPRUS','0000-00-00 00:00:00','2024-05-27 19:13:26'),(118,'CAI','CAIRO*','Cairo International Airport','EGYPT','0000-00-00 00:00:00','2024-05-27 19:13:26'),(119,'ALY','ALEXANDERIA','Borg El Arab International Airport','EGYPT','0000-00-00 00:00:00','2024-05-27 19:13:26'),(120,'LXR','LUXOR','Luxor International Airport','EGYPT','0000-00-00 00:00:00','2024-05-27 19:13:26'),(121,'KRT','KHRTOUM','Khartoum International Airport','SUDAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(122,'PZU','PORT SUDAN','Port Sudan International Airport','SUDAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(123,'JED','JEDDAH','King Abdulaziz International Airport','SAUDI ARABIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(124,'MED','MEDDINA','Prince Mohammed Bin Abdulaziz International Airport','SAUDI ARABIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(125,'RUH','RYADH*','King Khalid International Airport','SAUDI ARABIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(126,'DMM','Dammam','King Fahd International Airport','SAUDI ARABIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(127,'BAH','BAHRAIN','Bahrain International Airport','BAHARAIN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(128,'DOH','DOHA*','Hamad International Airport','QATAR','0000-00-00 00:00:00','2024-05-27 19:13:26'),(129,'AUH','ABUO DHABI*','Zayed International Airport','U.A.E','0000-00-00 00:00:00','2024-05-27 19:13:26'),(130,'DXB','DUBAI','Dubai International Airport','U.A.E','0000-00-00 00:00:00','2024-05-27 19:13:26'),(131,'SHJ','SHARJAH','Sharjah International Airport','U.A.E','0000-00-00 00:00:00','2024-05-27 19:13:26'),(132,'RKT','RAS EL KHAIMA','Ras Al Khaimah International Airport','U.A.E','0000-00-00 00:00:00','2024-05-27 19:13:26'),(133,'MCT','MUSCAT*','Muscat International Airport','OMAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(134,'IKA','TEHRAN','Imam Khomeini International Airport','IRAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(135,'IFN','ISFAHAN','Isfahan Shahid Beheshti International Airport','IRAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(136,'EBL','ERIBLE','Erbil International Airport','IRAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(137,'NJF','NAJAF','Al Najaf International Airport','IRAQ','0000-00-00 00:00:00','2024-05-27 19:13:26'),(138,'BGW','Baghdad','Baghdad International Airport','IRAQ','0000-00-00 00:00:00','2024-05-27 19:13:26'),(139,'SYZ','SHIRAZ','Shiraz Shahid Dastgheib International Airport','IRAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(140,'SAH','SANAA*','Sanaa International Airport','YEMEN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(141,'HOD','HODEIDAH','Hodeida International Airport','YEMEN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(142,'ADE','ADEN*','Aden International Airport','YEMEN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(143,'RIY','RIYAN','Riyan International Airport','YEMEN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(144,'BEN','BENGHAZI','Benina International Airport','LIBYA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(145,'TIP','TRIPOLI','Tripoli International airport','LIBYA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(146,'NKG','NOUAKKCHOTT','Nouakchott–Oumtounsy International Airport','MAURITANIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(147,'DKR','DAKAR','Blaise Diagne International Airport','SENEGAL','0000-00-00 00:00:00','2024-05-27 19:13:26'),(148,'BKO','BAMAKO','Modibo Keita International Airport','MALI','0000-00-00 00:00:00','2024-05-27 19:13:26'),(149,'CKY','CONAKRY','Ahmed Sékou Touré International Airport','GUINEA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(150,'FNA','FREFTOWN','Freetown International Airport','SIERRA LEONE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(151,'MLW','MONROVIA','Roberts International Airport','LIBERIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(152,'ABT','ABIDJAN','Félix Houphouët Boigny International Airport','COTED','0000-00-00 00:00:00','2024-05-27 19:13:26'),(153,'ACC','ACCRA','Kotoka International Airport','GHANA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(154,'LOG','LAGOS','Murtala Muhammed International Airport','NIGERIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(155,'NDJ','NDJAMENA','N\'Djamena International Airport','CHAD','0000-00-00 00:00:00','2024-05-27 19:13:26'),(156,'BGF','BANGUI','Bangui-M\'Poko International Airport','CENTRAZ AFRICAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(157,'DLA','DOUALA','Douala International Airport','CAMEROON','0000-00-00 00:00:00','2024-05-27 19:13:26'),(158,'BZV','BRAZZAVILLE','Maya-Maya International Airport','CONGO','0000-00-00 00:00:00','2024-05-27 19:13:26'),(159,'FIJ','KINSHASA','N’djili International Airport','ZAIRE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(160,'LAD','LUANDA','Quatro de Fevereiro Luanda International Airport','ANGOLA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(161,'LUN','LUSAKA','Kenneth Kaunda International Airport','ZAMBIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(162,'HRE','HARERE','Robert Gabriel Mugabe International Airport','ZIMBABWE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(163,'WDH','WINDHOEK','Hosea Kutako International Airport','NAMIBIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(164,'JNB','JOHANNESBURG','O.R. Tambo International Airport','SOUTH AFRICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(165,'CPT','CAPE TOWN','Cape Town International Airport','//','0000-00-00 00:00:00','2024-05-27 19:13:26'),(166,'MPM','MAPUTO','Maputo International Airport','MOZAMBIQUE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(167,'DAR','DAR ESSALA','Julius Nyerere International Airport','TANZANIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(168,'NBO','NAIROBI','Jomo Kenyatta International Airport','KENYA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(169,'EBB','ENTEBBE','Entebbe International Airport','URANDA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(170,'JID','DJIBOUTI','Djibouti-Ambouli International Airport','DJIBOUTI','0000-00-00 00:00:00','2024-05-27 19:13:26'),(171,'ADD','ADDIS ABABA','Bole Addis Ababa International Airport','ETHIOPIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(172,'MGQ','MOGADISHU','Aden Adde International Airport','SOMALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(173,'SEZ','MAHE ASLAND','Seychelles International Airport','SEYCHELLES','0000-00-00 00:00:00','2024-05-27 19:13:26'),(174,'YVA','MORONT','Prince Said Ibrahim International Airport','COMORES ISLAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(175,'TNR','ANTANANARIVO','Ivato International Airport','MADAGASCAR','0000-00-00 00:00:00','2024-05-27 19:13:26'),(176,'MRU','MAURITIUS','Sir Seewoosagur Ramgoolam International Airport','MAURITIUS','0000-00-00 00:00:00','2024-05-27 19:13:26'),(177,'DUR','DURBAN','King Shaka International Airport','SOUTH AFRICA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(178,'KBL','KABAL*','Kabul International Airport','AFGHANISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(179,'ISB','ISBLABAD*','Islamabad International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(181,'KHI','KARACHI','Jinnah International Airport','PAKISTAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(182,'DEL','DELHI*','Indira Gandhi International Airport','INDIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(183,'BOM','BOMOBAY','Chhatrapati Shivaji Maharaj International Airport','INDIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(184,'CCU','CALCUTTA','Netaji Subhash Chandra Bose International Airport','INDIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(185,'MAA','MADRAS','Chennai International Airport','INDIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(186,'TRV','TRIVANDRUM','Thiruvananthapuram International Airport','INDIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(187,'CMB','COLOMBO*','Bandaranaike International Airport','SIR LANKA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(188,'MEL','MALATA*','Malta International Airport','MALDIVES','0000-00-00 00:00:00','2024-05-27 19:13:26'),(189,'KTM','KATHMANDU*','Tribhuvan International Airport','NEPAL','0000-00-00 00:00:00','2024-05-27 19:13:26'),(190,'DAC','DHAKA*','Hazrat Shahjalal International Airport','BANGLADESH','0000-00-00 00:00:00','2024-05-27 19:13:26'),(191,'RGN','RANGOON*','Yangon International Airport','BURMA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(192,'VTE','VIENTIANE','Wattay International Airport','LA09','0000-00-00 00:00:00','2024-05-27 19:13:26'),(193,'BKK','BANGKOK*','Suvarnabhumi Airport','THAILAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(194,'PEN','PENANG','Penang International','MALAYSIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(195,'KUL','KUALA LAMPUR*','Kuala Lumpur International Airport','MALAYSIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(196,'SIN','SINGAPORE','Singapore Changi Airport','SINGAPORE','0000-00-00 00:00:00','2024-05-27 19:13:26'),(197,'JKT','JAKARTA*','Soekarno–Hatta International Airport, Pajang','INDONESIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(198,'DPS','DENPASAR','Ngurah Rai International Airport','INDONESIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(199,'HKT','PHUKET','Phuket International Airport','THAILAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(200,'MNL','MANILA*','Manila Ninoy Aquino International Airport','PHILIPPINES','0000-00-00 00:00:00','2024-05-27 19:13:26'),(201,'HAN','vietnam','Noi Bai International Airport','vietnam','0000-00-00 00:00:00','2024-05-27 19:13:26'),(202,'HKG','HONGKONG','Hong Kong International Airport','HONGKONG','0000-00-00 00:00:00','2024-05-27 19:13:26'),(203,'TPE','TAIPEI*','Taipei Songshan Airport','TQIWAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(204,'CAN','GHUANGZHOU','Guangzhou Baiyun International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(205,'PEK','BEIJING*','Beijing Capital International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(206,'SHA','SHANGHAI','Shanghai Pudong International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(207,'HZH','LIPING','Liping Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(208,'HGH','HANGZHOU','Hangzhou International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(209,'HYN','HUANGTYAN','huangtian international airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(210,'URC','URUMQI','Ürümqi Diwopu International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(211,'YIW','YIWU','Yiwu Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(212,'CTU','CHENGDU','Chengdu Shuangliu International Airport','CHINA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(213,'SEL','SEOUL*','Incheon International Airport','S.KOREA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(214,'FUK','FUKUOKA','Fukuoka Airport','JAPAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(215,'OSA','OSAKA','Osaka International Airport','JAPAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(216,'NGO','NAGOYA','Chubu Centrair International Airport','JAPAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(217,'TYO','TOKYO*','Haneda Airport','JAPAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(218,'SPK','SAPPORO','New Chitose Airport','JAPAN','0000-00-00 00:00:00','2024-05-27 19:13:26'),(219,'GUM','GUAM','Antonio B. Won Pat International Airport','GUAM','0000-00-00 00:00:00','2024-05-27 19:13:26'),(220,'PEK','PEKRTH','Perth Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(221,'ADL','ADELAIDE','Adelaide Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(222,'MEL','MELBOURNE','Melbourne Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(223,'SYD','SYDNEY','Sydney Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(224,'CBR','CANBERRA*','Canberra Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(225,'POM','PORT MORESBY*','Port Moresby International Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(226,'VLI','PORT VILA*','Bauerfield International Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(227,'NOU','NOUMEA*','La Tontouta International Airport','AUSTRALIA','0000-00-00 00:00:00','2024-05-27 19:13:26'),(228,'NAN','NADI','Nadi International Airport','FIJI ISLANDS','0000-00-00 00:00:00','2024-05-27 19:13:26'),(229,'SUV','SUVA','Suva-Nausori Airport','FIJI ISLANDS','0000-00-00 00:00:00','2024-05-27 19:13:26'),(230,'LBS','LABASA','Labasa Airport','FIJI ISLANDS','0000-00-00 00:00:00','2024-05-27 19:13:26'),(231,'AKL','AUCKLAND','Auckland Airport','NEW ZELAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(232,'WLG','WELLINGTON*','Wellington International Airport','NEW ZELAND','0000-00-00 00:00:00','2024-05-27 19:13:26'),(233,'CHC','CHRISTCHURCH','Christchurch International Airport','NEW ZELAND','0000-00-00 00:00:00','2024-05-27 19:13:26');
/*!40000 ALTER TABLE `airports_details` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int 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 `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`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 `group_ticket_queries`
--

DROP TABLE IF EXISTS `group_ticket_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `group_ticket_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `depart_from` date NOT NULL,
  `depart_to` date NOT NULL,
  `adults` int NOT NULL,
  `children` int DEFAULT '0',
  `infants` int DEFAULT '0',
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  CONSTRAINT `group_ticket_queries_chk_1` CHECK ((`adults` > 0)),
  CONSTRAINT `group_ticket_queries_chk_2` CHECK ((`children` >= 0)),
  CONSTRAINT `group_ticket_queries_chk_3` CHECK ((`infants` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `group_ticket_queries`
--

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

--
-- Table structure for table `hotal_queries`
--

DROP TABLE IF EXISTS `hotal_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hotal_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `want_to_stay` varchar(45) DEFAULT NULL,
  `destination` varchar(45) DEFAULT NULL,
  `room_type` varchar(45) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `message` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hotal_queries`
--

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

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

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int 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 `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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);
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci 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 `search_queries`
--

DROP TABLE IF EXISTS `search_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `search_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `flying_from` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `flying_to` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `depart_date` date NOT NULL,
  `return_date` date DEFAULT NULL,
  `direct_flight_only` enum('yes','no') COLLATE utf8mb4_general_ci DEFAULT NULL,
  `adult_count` int NOT NULL,
  `child_count` int NOT NULL,
  `infant_count` int NOT NULL,
  `flight_type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subject` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `message` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `search_queries`
--

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

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

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int 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 */;
INSERT INTO `sessions` VALUES ('99DPODZIiv5jGKjIZvF0jfVFVyezVkmli4RDCeBG',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRmFSMDZhMkVnNEI5SDBBd2N2VEpBbll2VVJaZkN6TExKcW9FcGpqViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC90aGFuay15b3UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1738179434),('i8a2X8kdC2kpNxDqXoRmUOLgRavZZYlVoIS522qy',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidzNKd1M2dHdzU3c4M3hlSUFyTjhvZWZrZzdTcVhwV2hqWDhKVzhyVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1738255029),('PoftyZY2AP6TowFa4KMyY2mNQcOALj7FBU6UB6cV',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTTF5c0w5UWJGRkpHeWoyTllkNWo0S0drMUdQUXBWUkNmaFhQbDRCVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1738177237);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tour_queries`
--

DROP TABLE IF EXISTS `tour_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tour_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `no_of_traveler` int NOT NULL,
  `selected_tour` varchar(255) NOT NULL,
  `depart_date` date NOT NULL,
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tour_queries`
--

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

--
-- Table structure for table `umrah_queries`
--

DROP TABLE IF EXISTS `umrah_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `umrah_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lead_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `departure_city` varchar(255) NOT NULL,
  `departure_date` date NOT NULL,
  `night_in_madinah` varchar(255) NOT NULL,
  `adults` int NOT NULL,
  `children` int DEFAULT '0',
  `infants` int DEFAULT '0',
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  CONSTRAINT `umrah_queries_chk_1` CHECK ((`adults` >= 1)),
  CONSTRAINT `umrah_queries_chk_2` CHECK ((`children` >= 0)),
  CONSTRAINT `umrah_queries_chk_3` CHECK ((`infants` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `umrah_queries`
--

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

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visa_queries`
--

DROP TABLE IF EXISTS `visa_queries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `visa_queries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `country_for_visa` varchar(255) NOT NULL,
  `visa_type` varchar(50) NOT NULL,
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visa_queries`
--

LOCK TABLES `visa_queries` WRITE;
/*!40000 ALTER TABLE `visa_queries` DISABLE KEYS */;
/*!40000 ALTER TABLE `visa_queries` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2025-01-30 21:53:23
