-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2017_2018
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!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 `puertos_aereos`
--

DROP TABLE IF EXISTS `puertos_aereos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `puertos_aereos` (
  `idpuerto_aereo` int(11) NOT NULL AUTO_INCREMENT,
  `CIUDAD` varchar(18) DEFAULT NULL,
  `PAIS` varchar(16) DEFAULT NULL,
  `IATA` varchar(7) DEFAULT NULL,
  PRIMARY KEY (`idpuerto_aereo`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `puertos_aereos`
--

LOCK TABLES `puertos_aereos` WRITE;
/*!40000 ALTER TABLE `puertos_aereos` DISABLE KEYS */;
INSERT INTO `puertos_aereos` VALUES (1,'ABU DHABI','EMIRATOS ARABES ','AUH'),(2,'ABUJA','NIGERIA','ABV'),(3,'ADDIS ABEBA','ETIOPIA','ADD'),(4,'ADELAIDE','AUSTRALIA','ADL'),(5,'AHMADABAD','INDIA','AMD'),(6,'AMMAN','JORDANIA','AMM'),(7,'AMSTERDAM','HOLANDA','AMS'),(8,'ANTOFAGASTA','CHILE','ANF'),(9,'ATLANTA','USA','ATL'),(10,'AUCKLAND','NEW ZEALAND','AKL'),(11,'BANGALORE','INDIA','BLR'),(12,'BANGKOK','TAILANDIA','BKK'),(13,'BARCELONA','ESPAÑA','BCN'),(14,'BARRANQUILLA','COLOMBIA','BAQ'),(15,'BASEL','SUIZA','BSL'),(16,'BEIJING','CHINA','BJS'),(17,'BEIRUT','LIBANO','BEY'),(18,'BELO HORIZONTE','BRASIL','CNF'),(19,'BOGOTA','COLOMBIA','BOG'),(20,'BOMBAI/MUMBAI','INDIA','BOM'),(21,'BRATISLAVA','SLOVAKIA','BTS'),(22,'BREMEN','ALEMANIA','BRE'),(23,'BRISBANE','AUSTRALIA','BNE'),(24,'BRUSELAS','BELGICA','BRU'),(25,'BUDAPEST','HUNGRIA','BUD'),(26,'BUENOS AIRES','ARGENTINA','EZE'),(27,'CAIRO','EGIPTO','CAI'),(28,'CALI','COLOMBIA','CLO'),(29,'CAPE TOWN','SUD AFRICA','CPT'),(30,'CARACAS','VENEZUELA','CCS'),(31,'CHENNAI','INDIA','MAA'),(32,'CHICAGO','USA','ORD'),(33,'COCHABAMBA','BOLIVIA','CBB'),(34,'COLONIA','ALEMANIA','CGN'),(35,'COPENHAGEN','DINAMARCA','CPH'),(36,'CURITIBA','BRASIL','CWB'),(37,'DALLAS','USA','DFW'),(38,'DAMMAM','ARABIA SAUDITA','DMM'),(39,'DENVER','USA','DEN'),(40,'DUBAI','EMIRATOS ARABES ','DXB'),(41,'DUBLIN','IRLANDA','DUB'),(42,'ESTOCOLMO','SUECIA','ARN'),(43,'FRANKFURT','ALEMANIA','FRA'),(44,'GENEVA','SUIZA','GVA'),(45,'GENOVA','ITALIA','GOA'),(46,'GLASGOW','ESCOCIA','GGW'),(47,'GOTEMBURGO','SUECIA','GOT'),(48,'GUANGZHOU','CHINA','CAN'),(49,'GUARULHOS','BRASIL','GRU'),(50,'GUATEMALA','GUATEMALA','GUA'),(51,'GUAYAQUIL','ECUADOR','GYE'),(52,'HAMBURGO','ALEMANIA','HAM'),(53,'HANNOVER','ALEMANIA','HAJ'),(54,'HELSINKI','FINLANDIA','HEL'),(55,'HO CHI MINH','VIETNAM','SGN'),(56,'HONG KONG','HONG KONG','HKG'),(57,'HOUSTON','USA','IAH'),(58,'HYDERABAD','INDIA','HYD'),(59,'ISLAS CAIMAN','ISLAS CAIMAN','GCM'),(60,'ISTANBUL','TURQUIA','IST'),(61,'IZMIR','TURQUIA','IZM/ADB'),(62,'JAKARTA','INDONESIA','JKT'),(63,'JOHANNESBURG','SUD AFRICA','JNB'),(64,'KARACHI','PAKISTAN','KHI'),(65,'KIEV','UCRANIA','KBP'),(66,'KINGSTON','JAMAICA','KIN'),(67,'KUALA LUMPUR','MALAYSIA','KUL'),(68,'LA HABANA','CUBA','HAV'),(69,'LA PAZ  ','BOLIVIA','LPB'),(70,'LAGOS','NIGERIA','LOS'),(71,'LAHORE','PAKISTAN','LHE'),(72,'LIMA','PERU','LIM'),(73,'LISBOA','PORTUGAL','LIS'),(74,'LONDON','U.K.','LHR'),(75,'LOS ANGELES','USA','LAX'),(76,'LUXEMBURGO','LUXEMBURGO','LUX'),(77,'LYON','FRANCIA','LYO'),(78,'MADRID','ESPAÑA','MAD'),(79,'MALMO','SUECIA','MMX'),(80,'MANAGUA','NICARAGUA','MGA'),(81,'MANCHESTER','U.K.','MAN'),(82,'MANILA','FILIPINAS','MNL'),(83,'MARACAIBO','VENEZUELA','MAR'),(84,'MARSEILLE','FRANCIA','MRS'),(85,'MEDELLIN','COLOMBIA','MDE'),(86,'MELBOURNE     ','AUSTRALIA','MEL'),(87,'MIAMI','USA','MIA'),(88,'MILAN','ITALIA','MXP'),(89,'MONTEVIDEO','URUGUAY','MVD'),(90,'MONTREAL','CANADA','YUL'),(91,'MOSCOW','RUSIA','SVO'),(92,'MUNICH','ALEMANIA','MUC'),(93,'NAGOYA','JAPON','NGO'),(94,'NAIROBI','KENYA','NBO'),(95,'NARITA','JAPON','NRT'),(96,'NAVEGANTES','BRASIL','NVT'),(97,'NEW DELHI','INDIA','DEL'),(98,'NEW YORK','USA','JFK'),(99,'NUREMBERG','ALEMANIA','NUE'),(100,'OSLO','NORUEGA','OSL'),(101,'PANAMA','PANAMA','PTY'),(102,'PARIS','FRANCIA','CDG'),(103,'PENANG','MALAYSIA','PEN'),(104,'PORT HARCOURT','NIGERIA','PHC'),(105,'PORTO','PORTUGAL','OPO'),(106,'PORTO ALLEGRE','BRASIL','POA'),(107,'PRAGA','REP. CHECA','PRG'),(108,'PUSAN','COREA DEL SUR','PUS'),(109,'QUITO','ECUADOR','UIO'),(110,'RABAT','MARRUECOS','RBA'),(111,'RIO DE JANEIRO','BRASIL','GIG'),(112,'RIYADH','ARABIA SAUDITA','RUH'),(113,'ROMA','ITALIA','FCO'),(114,'SALVADOR BAHIA','BRASIL','SSA'),(115,'SAN ANTONIO','USA','SAT'),(116,'SAN FRANCISCO','USA','SFO'),(117,'SAN JOSE','COSTA RICA','SJO'),(118,'SAN JUAN','PUERTO RICO','SJU'),(119,'SAN PEDRO SULA','HONDURAS','SAP'),(120,'SAN SALVADOR','EL SALVADOR','SAL'),(121,'SANTIAGO  ','CHILE','SCL'),(122,'SANTO DOMINGO','REP. DOMICANA','SDQ'),(123,'SEOUL/INCHEON','COREA DEL SUR','ICN'),(124,'SHANGHAI','CHINA','PVG'),(125,'SIDNEY            ','AUSTRALIA','SYD'),(126,'SINGAPORE','SINGAPORE','SIN'),(127,'STTUTGART','ALEMANIA','STR'),(128,'TAIPEI','TAIWAN','TPE'),(129,'TEGUCIGALPA','HONDURAS','TGU'),(130,'TEL AVIV','ISRAEL','TLV'),(131,'TORONTO','CANADA','YYZ'),(132,'TRINIDAD','PUERTO ESPAÑA','POS'),(133,'VALENCIA','ESPAÑA','VLC'),(134,'VANCOUVER','CANADA','YVR'),(135,'VARSOVIA','POLONIA','WAW'),(136,'VIENNA','AUSTRIA','VIE'),(137,'VIRACOPOS','BRASIL','VCP'),(138,'ZURICH','SUIZA','ZRH'),(139,'DISTRITO FEDERAL','MEXICO','MEX'),(140,'INCHEON','KOREA','ICN'),(141,'GUADALAJARA','MEXICO','GDL'),(142,'MONTERREY','MEXICO','MTY'),(143,'SHENZHEN','CHINA','SZX'),(147,'Q','Q',''),(148,'PARANA','ARGENTINA',''),(149,'DHAKA','BANGLADESH','DAC'),(150,'ESTAMBUK','TURQUIA','SAW'),(151,'SEATTLE','USA','SEA'),(152,'SRI LANKA','COLOMBO','LKL'),(153,'FLORENCE','ITALY','FLR'),(154,'AHMEDABAD','INDIA','AMD'),(155,'ZADUR','SOUTH AFRICA','DUR'),(156,'CASABLANCA MOHAMED','MOROCCO','CMN'),(157,'KOLN','GERMANY','CGN'),(158,'DUSSELDORF','GERMANY','DUS');
/*!40000 ALTER TABLE `puertos_aereos` 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-07-25 21:48:42
