-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_impo
-- ------------------------------------------------------
-- 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=168 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','UNITED ARAB EMIR','AUH'),(2,'ABUJA','NIGERIA','ABV'),(3,'ADDIS ABEBA','ETHIOPIA','ADD'),(4,'ADELAIDE','AUSTRALIA','ADL'),(6,'AMMAN','JORDAN','AMM'),(7,'AMSTERDAM','NETHERLANDS','AMS'),(8,'ANTOFAGASTA','CHILE','ANF'),(9,'ATLANTA','UNITED STATES','ATL'),(10,'AUCKLAND','NEW ZEALAND','AKL'),(11,'BANGALORE','INDIA','BLR'),(12,'BANGKOK','THAILAND','BKK'),(13,'BARCELONA','SPAIN','BCN'),(14,'BARRANQUILLA','COLOMBIA','BAQ'),(15,'BASEL','SWITZERLAND','BSL'),(16,'BEIJING','CHINA','BJS'),(17,'BEIRUT','LEBANON','BEY'),(18,'BELO HORIZONTE','BRAZIL','CNF'),(19,'BOGOTA','COLOMBIA','BOG'),(20,'BOMBAI/MUMBAI','INDIA','BOM'),(21,'BRATISLAVA','SLOVAKIA','BTS'),(22,'BREMEN','GERMANY','BRE'),(23,'BRISBANE','AUSTRALIA','BNE'),(24,'BRUSSELS','BELGIUM','BRU'),(25,'BUDAPEST','HUNGARY','BUD'),(26,'BUENOS AIRES','ARGENTINA','EZE'),(27,'CAIRO','EGYPT','CAI'),(28,'CALI','COLOMBIA','CLO'),(29,'CAPE TOWN','SOUTH AFRICA','CPT'),(30,'CARACAS','VENEZUELA','CCS'),(31,'CHENNAI','INDIA','MAA'),(32,'CHICAGO','UNITED STATES','ORD'),(33,'COCHABAMBA','BOLIVIA','CBB'),(34,'COLONIA','GERMANY','CGN'),(35,'COPENHAGEN','DENMARK','CPH'),(36,'CURITIBA','BRAZIL','CWB'),(37,'DALLAS','UNITED STATES','DFW'),(38,'DAMMAM','SAUDI ARABIA','DMM'),(39,'DENVER','UNITED STATES','DEN'),(40,'DUBAI','UNITED ARAB EMIR','DXB'),(41,'DUBLIN','IRELAND','DUB'),(42,'STOCKHOLM','SWEDEN','ARN'),(43,'FRANKFURT','GERMANY','FRA'),(44,'GENEVA','SWITZERLAND','GVA'),(45,'GENOA','ITALY','GOA'),(46,'GLASGOW','SCOTLAND','GGW'),(47,'GOTHENBURG','SWEDEN','GOT'),(48,'GUANGZHOU','CHINA','CAN'),(49,'GUARULHOS','BRAZIL','GRU'),(50,'GUATEMALA','GUATEMALA','GUA'),(51,'GUAYAQUIL','ECUADOR','GYE'),(52,'HAMBURG','GERMANY','HAM'),(53,'HANNOVER','GERMANY','HAJ'),(54,'HELSINKI','FINLAND','HEL'),(55,'HO CHI MINH','VIETNAM','SGN'),(56,'HONG KONG','HONG KONG','HKG'),(57,'HOUSTON','UNITED STATES','IAH'),(58,'HYDERABAD','INDIA','HYD'),(59,'ISLAS CAIMAN','ISLAS CAIMAN','GCM'),(60,'ISTANBUL','TURKEY','IST'),(61,'IZMIR','TURKEY','IZM/ADB'),(62,'JAKARTA','INDONESIA','JKT'),(63,'JOHANNESBURG','SOUTH AFRICA','JNB'),(64,'KARACHI','PAKISTAN','KHI'),(65,'KIEV','UKRAINE','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,'LISBON','PORTUGAL','LIS'),(74,'LONDON','UNITED KINGDOM','LHR'),(75,'LOS ANGELES','UNITED STATES','LAX'),(76,'LUXEMBOURG','LUXEMBOURG','LUX'),(77,'LYON','FRANCE','LYO'),(78,'MADRID','SPAIN','MAD'),(79,'MALMO','SWITZERLAND','MMX'),(80,'MANAGUA','NICARAGUA','MGA'),(81,'MANCHESTER','UNITED KINGDOM','MAN'),(82,'MANILA','PHILIPPINES','MNL'),(83,'MARACAIBO','VENEZUELA','MAR'),(84,'MARSEILLE','FRANCE','MRS'),(85,'MEDELLIN','COLOMBIA','MDE'),(86,'MELBOURNE     ','AUSTRALIA','MEL'),(87,'MIAMI','UNITED STATES','MIA'),(88,'MILAN','ITALY','MXP'),(89,'MONTEVIDEO','URUGUAY','MVD'),(90,'MONTREAL','CANADA','YUL'),(91,'MOSCOW','RUSSIAN FEDERATI','SVO'),(92,'MUNICH','GERMANY','MUC'),(93,'NAGOYA','JAPAN','NGO'),(94,'NAIROBI','KENYA','NBO'),(95,'NARITA','JAPAN','NRT'),(96,'NAVEGANTES','BRAZIL','NVT'),(97,'NEW DELHI','INDIA','DEL'),(98,'NEW YORK','UNITED STATES','JFK'),(99,'NUREMBERG','GERMANY','NUE'),(100,'OSLO','NORWAY','OSL'),(101,'PANAMA','PANAMA','PTY'),(102,'PARIS','FRANCE','CDG'),(103,'PENANG','MALAYSIA','PEN'),(104,'PORT HARCOURT','NIGERIA','PHC'),(105,'PORTO','PORTUGAL','OPO'),(106,'PORTO ALLEGRE','BRAZIL','POA'),(107,'PRAGUE','CZECH REPUBLIC','PRG'),(108,'BUSAN','KOREA - REPUBLIC','PUS'),(109,'QUITO','ECUADOR','UIO'),(110,'RABAT','MOROCCO','RBA'),(111,'RIO DE JANEIRO','BRAZIL','GIG'),(112,'RIYADH','SAUDI ARABIA','RUH'),(113,'ROME','ITALY','FCO'),(114,'SALVADOR BAHIA','BRAZIL','SSA'),(115,'SAN ANTONIO','UNITED STATES','SAT'),(116,'SAN FRANCISCO','UNITED STATES','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','DOMINICAN REPUBL','SDQ'),(124,'SHANGHAI','CHINA','PVG'),(125,'SIDNEY            ','AUSTRALIA','SYD'),(126,'SINGAPORE','SINGAPORE','SIN'),(127,'STTUTGART','GERMANY','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','SPAIN','VLC'),(134,'VANCOUVER','CANADA','YVR'),(136,'VIENNA','AUSTRIA','VIE'),(137,'VIRACOPOS','BRAZIL','VCP'),(138,'ZURICH','SWITZERLAND','ZRH'),(139,'MEXICO CITY','MEXICO','MEX'),(140,'INCHEON','KOREA - REPUBLIC','ICN'),(141,'GUADALAJARA','MEXICO','GDL'),(142,'MONTERREY','MEXICO','MTY'),(143,'SHENZHEN','CHINA','SZX'),(148,'PARANA','ARGENTINA','PRA'),(149,'DHAKA','BANGLADESH','DAC'),(150,'ESTAMBUK','TURKEY','SAW'),(151,'SEATTLE','UNITED STATES','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'),(159,'BILBAO','SPAIN','BIO'),(160,'EDMONTON','CANADA','YEG'),(161,'INDEL','INDIA','DEL'),(162,'ALICANTE','SPAIN','ALC'),(163,'XIAMEN','CHINA','XMN'),(164,'TUNIS','TUNISIA','TUN'),(165,'WARSAW','POLAND','WAW'),(167,'BILLUND','DENMARK','BLL');
/*!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 20:21:16
