-- 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_interteam`
--

DROP TABLE IF EXISTS `puertos_interteam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `puertos_interteam` (
  `idpuertos_internacionales` double NOT NULL AUTO_INCREMENT,
  `clave_del_pais` varchar(255) NOT NULL DEFAULT '',
  `nombre_del_pais` varchar(255) NOT NULL DEFAULT '',
  `clave_del_puerto` varchar(255) NOT NULL DEFAULT '',
  `nombre_del_puerto` varchar(255) NOT NULL DEFAULT '',
  `location_code` varchar(10) DEFAULT NULL,
  `location_code_pais` varchar(45) DEFAULT NULL,
  `location_code_wwa` varchar(45) DEFAULT NULL,
  `location_code_interteam` varchar(45) DEFAULT NULL,
  `clave_del_puerto_transmision_sat` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idpuertos_internacionales`),
  KEY `i_nombre_del_puerto` (`nombre_del_puerto`)
) ENGINE=InnoDB AUTO_INCREMENT=35629 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `puertos_interteam`
--

LOCK TABLES `puertos_interteam` WRITE;
/*!40000 ALTER TABLE `puertos_interteam` DISABLE KEYS */;
INSERT INTO `puertos_interteam` VALUES (138,'ARE','UNITED ARAB EMIRATES','DXB','Dubai','AEDXB','AE','AEDXB','AEDXB','DXB'),(172,'ARG','ARGENTINA','BUE','Buenos Aires','ARBUE','AR','ARBUE','ARBUE','BUE'),(323,'AUS','AUSTRALIA','ADL','Adelaide','AUADL','AU','AUADL','AUADL','ADL'),(386,'AUS','AUSTRALIA','BNE','Brisbane','AUBNE','AU','AUBNE','AUBNE','BNE'),(555,'AUS','AUSTRALIA','FRE','Fremantle','AUFRE','AU','AUFRE','AUFRE','FRE'),(740,'AUS','AUSTRALIA','MEL','Melbourne','AUMEL','AU','AUMEL','AUMEL','MEL'),(975,'AUS','AUSTRALIA','SYD','Sydney','AUSYD','AU','AUSYD','AUSYD','SYD'),(1432,'BEL','BELGIUM','ANR','Antwerpen','BEANR','BE','BEANR','BEANR','ANR'),(1920,'BGD','BANGLADESH','CGP','Chattogram','BDCGP','BD','BDCGP','BDCGP','CGP'),(2255,'BRA','BRAZIL','CWB','Curitiba','BRCWB','BR','BRCWB','BRCWB','CWB'),(2305,'BRA','BRAZIL','ITJ','Itajai','BRITJ','BR','BRITJ','BRITJ','ITJ'),(2396,'BRA','BRAZIL','POA','Porto Alegre','BRPOA','BR','BRPOA','BRPOA','POA'),(2440,'BRA','BRAZIL','QHV','Novo Hamburgo','BRQHV','BR','BRQHV','BRNHO','QHV'),(2472,'BRA','BRAZIL','RIO','Rio de Janeiro','BRRIO','BR','BRRIO','BRRIO','RIO'),(2499,'BRA','BRAZIL','SSA','Salvador','BRSSA','BR','BRSSA','BRSSA','SSA'),(2501,'BRA','BRAZIL','SSZ','Santos','BRSSZ','BR','BRSSZ','BRSSZ','SSZ'),(3222,'CAN','CANADA','MTR','Montreal','CAMTR','CA','CAMTR','CAMTR','MTR'),(3628,'CAN','CANADA','TOR','Toronto','CATOR','CA','CATOR','CATOR','TOR'),(3651,'CAN','CANADA','VAN','Vancouver','CAVAN','CA','CAVAN','CAVAN','VAN'),(4211,'COL','COLOMBIA','BUN','Buenaventura','COBUN','CO','COBUN','COBUN','BUN'),(4215,'COL','COLOMBIA','CTG','Cartagena','COCTG','CO','COCTG','COCTG','CTG'),(4291,'CRI','COSTA RICA','SJO','San Jose','CRSJO','CR','CRSJO','CRSJO','SJO'),(4519,'CZE','CZECH REPUBLIC','PRG','Praha','CZPRG','CZ','CZPRG','CZPRG','PRG'),(4957,'CHN','CHINA','CAN','Guangzhou PT','CNCAN','CN','CNCAN','CNGZG','CAN'),(4968,'CHN','CHINA','CKG','Chongqing PT','CNCKG','CN','CNCKG','CNCHQ','CKG'),(4975,'CHN','CHINA','CTU','Chengdu','CNCTU','CN','CNCTU','CNCDU','CTU'),(4990,'CHN','CHINA','DLC','Dalian PT','CNDLC','CN','CNDLC','CNDAG','DLC'),(5007,'CHN','CHINA','FOC','Fuzhou PT','CNFOC','CN','CNFOC','CNFZG','FOC'),(5008,'CHN','CHINA','FOS','Foshan','CNFOS','CN','CNFOS','CNFOS','FOS'),(5033,'CHN','CHINA','HAK','Haikou PT','CNHKO','CN','CNHAK','CNHIG','HAK'),(5060,'CHN','CHINA','HUA','Huangpu PT','CNHUA','CN','CNHUA','CNHUA','HUA'),(5086,'CHN','CHINA','JMN','Jiangmen','CNJMN','CN','CNJMN','CNJMN','JMN'),(5092,'CHN','CHINA','JXN','Jiao Xin PT','CNJXN','CN','CNJXN','CNJIA','JXN'),(5127,'CHN','CHINA','LYG','Lianyungang','CNLYG','CN','CNLYG','CNLYG','LYG'),(5149,'CHN','CHINA','NGB','Ningbo PT','CNNGB','CN','CNNGB','CNNBG','NGB'),(5151,'CHN','CHINA','NKG','Nanjing PT','CNNKG','CN','CNNKG','CNNJG','NKG'),(5154,'CHN','CHINA','NSA','Nansha PT','CNNSA','CN','CNNSA','CNNSA','NSA'),(5181,'CHN','CHINA','ROQ','Rongqi PT','CNROQ','CN','CNROQ','CNROQ','ROQ'),(5191,'CHN','CHINA','SHA','Shanghai PT','CNSHA','CN','CNSHA','CNSHG','SHA'),(5194,'CHN','CHINA','SHG','Sanshan PT','CNSHG','CN','CNSHG','CNNHS','SHG'),(5198,'CHN','CHINA','SHK','Shekou PT','CNSHK','CN','CNSHK','CNSZP','SZX'),(5215,'CHN','CHINA','SUD','Shunde PT','CNSUD','CN','CNSUD','CNSUD','SUD'),(5217,'CHN','CHINA','SWA','Shantou','CNSWA','CN','CNSWA','CNSTG','SWA'),(5227,'CHN','CHINA','SZX','Shenzhen PT','CNSZX','CN','CNSZX','CNSZP','SZX'),(5230,'CHN','CHINA','TAO','Qingdao PT','CNTAO','CN','CNTAO','CNQDG','TAO'),(5244,'CHN','CHINA','TXG','Tianjin PT','CNTXG','CN','CNTSN','CNTNG','TSN'),(5261,'CHN','CHINA','WUH','Wuhan PT','CNWUH','CN','CNWUH','CNWHG','WUH'),(5268,'CHN','CHINA','XIL','Xiaolan','CNXIL','CN','CNXAO','CNXAO','XIL'),(5274,'CHN','CHINA','XMG','Xiamen PT','CNXMN','CN','CNXMN','CNXMG','XMN'),(5292,'CHN','CHINA','YTN','Yantian','CNYTN','CN','CNYTN','CNYTN','YTN'),(5313,'CHN','CHINA','ZQG','Zhaoqing','CNZQG','CN','CNZQG','CNZQG','ZQG'),(5314,'CHN','CHINA','ZSN','Zhongshan','CNZSN','CN','CNZSN','CNZSN','ZSN'),(5315,'CHN','CHINA','ZUH','Zhuhai','CNZUH','CN','CNZUH','CNZUH','ZUH'),(5593,'DEU','GERMANY','BRE','Bremen','DEBRE','DE','DEBRE','DEBRE','BRE'),(6096,'DEU','GERMANY','HAM','Hamburg','DEHAM','DE','DEHAM','DEHAM','HAM'),(8153,'DOM','DOMINICAN REPUBLIC','HAI','Rio Haina','DOHAI','DO','DOHAI','DOHAI','HAI'),(8438,'ESP','SPAIN','BCN','Barcelona','ESBCN','ES','ESBCN','ESBCN','BCN'),(8458,'ESP','SPAIN','BIO','Bilbao','ESBIO','ES','ESBIO','ESBIO','BIO'),(8853,'ESP','SPAIN','MAD','Madrid','ESMAD','ES','ESMAD','ESMAD','MAD'),(9175,'ESP','SPAIN','SVQ','Sevilla','ESSVQ','ES','ESSVQ','ESSVQ','SVQ'),(9280,'ESP','SPAIN','VLC','Valencia','ESVLC','ES','ESVLC','ESVLC','VLC'),(9309,'ESP','SPAIN','ZAZ','Zaragoza','ESZAZ','ES','ESZAZ','ESZAZ','ZAZ'),(9407,'FIN','FINLAND','HEL','Helsinki (Helsingfors)','FIHEL','FI','FIHEL','FIHEL','HEL'),(10266,'FRA','FRANCE','COU','Fos sur Mer','FRCOU','FR','FRCOU','FRFOS','COU'),(10824,'FRA','FRANCE','LEH','Le Havre','FRLEH','FR','FRLEH','FRLEH','LEH'),(10873,'FRA','FRANCE','LIO','Lyon','FRLIO','FR','FRLIO','FRLIO','LIO'),(11176,'FRA','FRANCE','MRS','Marseille','FRMRS','FR','FRMRS','FRMRS','MRS'),(11359,'FRA','FRANCE','PAR','Paris','FRPAR','FR','FRPAR','FRPAR','PAR'),(13724,'GBR','UNITED KINGDOM','LON','London','GBLON','GB','GBLON','GBLON','LON'),(15385,'HKG','HONG KONG','HKG','Hong Kong','HKHKG','HK','HKHKG','HKHKG','HKG'),(15739,'IDN','INDONESIA','JKT','Jakarta, Java','IDJKT','ID','IDJKT','IDJKT','JKT'),(15934,'IDN','INDONESIA','SRG','Semarang','IDSRG','ID','IDSRG','IDSRG','SRG'),(15939,'IDN','INDONESIA','SUB','Surabaya','IDSUB','ID','IDSUB','IDSUB','SUB'),(16009,'IND','INDIA','AMD','Ahmedabad','INAMD','IN','INAMD','INAMD','AMD'),(16045,'IND','INDIA','BLR','Bangalore','INBLR','IN','INBLR','INBLR','BLR'),(16075,'IND','INDIA','CCU','Kolkata (ex Calcutta)','INCCU','IN','INCCU','INCCU','CCU'),(16100,'IND','INDIA','DEL','New Delhi','INDEL','IN','INDEL','INDEL','DEL'),(16163,'IND','INDIA','HYD','Hyderabad','INHYD','IN','INHYD','INHYD','HYD'),(16189,'IND','INDIA','JAI','Jaipur','INJAI','IN','INJAI','INJAI','JAI'),(16256,'IND','INDIA','LUH','Ludhiana','INLUH','IN','INLUH','INLUH','LUH'),(16257,'IND','INDIA','MAA','Chennai (ex Madras)','INMAA','IN','INMAA','INMAA','MAA'),(16284,'IND','INDIA','MOR','Moradabad','INMOR','IN','INMOR','INMOR','MOR'),(16314,'IND','INDIA','NSA','Nhava Sheva (Jawaharlal Nehru)','INNSA','IN','INNSA','INNSA','NSA'),(16341,'IND','INDIA','PNQ','Pune','INPNQ','IN','INPNQ','INPNQ','PNQ'),(16435,'IND','INDIA','TUT','Tuticorin','INTUT','IN','INTUT','INTUT','TUT'),(17740,'ITA','ITALY','MIL','Milano','ITMIL','IT','ITMIL','ITMIL','MIL'),(19298,'JPN','JAPAN','MOJ','Moji','JPMOJ','JP','JPMOJ','JPMOJ','MOJ'),(19398,'JPN','JAPAN','NGO','Nagoya, Aichi','JPNGO','JP','JPNGO','JPNGO','NGO'),(19591,'JPN','JAPAN','OSA','Osaka','JPOSA','JP','JPOSA','JPOSA','OSA'),(19976,'JPN','JAPAN','TYO','Tokyo','JPTYO','JP','JPTYO','JPTYO','TYO'),(20000,'JPN','JAPAN','UKB','Kobe','JPUKB','JP','JPUKB','JPUKB','UKB'),(20097,'JPN','JAPAN','YOK','Yokohama','JPYOK','JP','JPYOK','JPYOK','YOK'),(20202,'KHM','CAMBODIA','KOS','Sihanoukville','KHKOS','KH','KHKOS','KHKOS','KOS'),(20210,'KHM','CAMBODIA','PNH','Phnom Penh','KHPNH','KH','KHPNH','KHPNH','PNH'),(20294,'KOR','KOREA - REPUBLIC OF','PUS','Busan','KRPUS','KR','KRPUS','KRPUS','PUS'),(20456,'LKA','SRI LANKA','CMB','Colombo','LKCMB','LK','LKCMB','LKCMB','CMB'),(20556,'MAC','MACAO','FMM','Macau','MOFMM','MO','MOMFM','MOMFM','MFM'),(21036,'MMR','MYANMAR','RGN','Yangon','MMRGN','MM','MMRGN','MMRGN','RGN'),(21242,'MYS','MALAYSIA','PEN','PENANG (GEORGETOWN)','MYPEN','MY','MYPEN','MYPEN','PEN'),(21245,'MYS','MALAYSIA','PGU','Pasir Gudang, Johor','MYPGU','MY','MYPGU','MYPGU','PGU'),(21248,'MYS','MALAYSIA','PKG','PORT KLANG (PELABUHAN KLANG)','MYPKG','MY','MYPKG','MYPKG','PKG'),(22062,'NZL','NEW ZEALAND','AKL','Auckland','NZAKL','NZ','NZAKL','NZAKL','AKL'),(22069,'NZL','NEW ZEALAND','CHC','Christchurch','NZCHC','NZ','NZCHC','NZCHC','CHC'),(22148,'NZL','NEW ZEALAND','TRG','Tauranga','NZTRG','NZ','NZTRG','NZTRG','TRG'),(22169,'NZL','NEW ZEALAND','WLG','Wellington','NZWLG','NZ','NZWLG','NZWLG','WLG'),(22225,'PAK','PAKISTAN','KHI','Karachi','PKKHI','PK','PKKHI','PKKHI','KHI'),(22309,'PAN','PANAMA','ONX','Colon Free Zone','PAONX','PA','PAONX','PACFZ','ONX'),(22355,'PER','PERU','CLL','Callao','PECLL','PE','PECLL','PECLL','CLL'),(22484,'PHL','PHILIPPINES','CEB','Cebu','PHCEB','PH','PHCEB','PHCEB','CEB'),(22625,'PHL','PHILIPPINES','MNL','Manila','PHMNL','PH','PHMNL','PHMNL','MNL'),(23230,'POL','POLAND','GDY','Gdynia','PLGDY','PL','PLGDY','PLGDY','GDY'),(23274,'POL','POLAND','KRK','Krakow','PLKRK','PL','PLKRK','PLKRK','KRK'),(23422,'POL','POLAND','WAW','Warszawa','PLWAW','PL','PLWAW','PLWAW','WAW'),(23614,'PRT','PORTUGAL','LEI','Leixoes','PTLEI','PT','PTLEI','PTLEI','LEI'),(23617,'PRT','PORTUGAL','LIS','Lisboa','PTLIS','PT','PTLIS','PTLIS','LIS'),(23643,'PRT','PORTUGAL','OPO','Porto','PTOPO','PT','PTOPO','PTOPO','OPO'),(24265,'SGP','SINGAPORE','SIN','Singapore','SGSIN','SG','SGSIN','SGSIN','SIN'),(24749,'SWE','SWEDEN','GOT','Goteborg','SEGOT','SE','SEGOT','SEGOT','GOT'),(25304,'THA','THAILAND','BKK','Bangkok','THBKK','TH','THBKK','THBKK','BKK'),(25337,'THA','THAILAND','LKR','Bangkok','THLKR','TH','THBKK','THBKK','BKK'),(25460,'TUN','TUNISIA','TUN','Tunis','TNTUN','TN','TNTUN','TNTUN','TUN'),(25699,'TUR','TURKEY','IST','Istanbul','TRIST','TR','TRIST','TRIST','IST'),(25938,'TWN','TAIWAN','KEL','Keelung (Chilung)','TWKEL','TW','TWKEL','TWKEL','KEL'),(25940,'TWN','TAIWAN','KHH','Kaohsiung','TWKHH','TW','TWKHH','TWKHH','KHH'),(25957,'TWN','TAIWAN','TXG','Taichung','TWTXG','TW','TWTXG','TWTXG','TXG'),(26417,'USA','UNITED STATES OF AMERICA','ATL','Atlanta','USATL','US','USATL','USATL','ATL'),(26528,'USA','UNITED STATES OF AMERICA','BAL','Baltimore','USBAL','US','USBAL','USBAL','BAL'),(26825,'USA','UNITED STATES OF AMERICA','BOS','Boston','USBOS','US','USBOS','USBOS','BOS'),(27234,'USA','UNITED STATES OF AMERICA','CHI','Chicago','USCHI','US','USCHI','USCHI','CHI'),(27244,'USA','UNITED STATES OF AMERICA','CHS','Charleston','USCHS','US','USCHS','USCHS','CHS'),(27320,'USA','UNITED STATES OF AMERICA','CLE','Cleveland','USCLE','US','USCLE','USCLE','CLE'),(27335,'USA','UNITED STATES OF AMERICA','CLT','Charlotte','USCLT','US','USCLT','USCLT','CLT'),(27349,'USA','UNITED STATES OF AMERICA','CMH','Columbus','USCMH','US','USCMH','USCMH','CMH'),(27574,'USA','UNITED STATES OF AMERICA','CVG','Cincinnati','USCVG','US','USCVG','USCVG','CVG'),(27690,'USA','UNITED STATES OF AMERICA','DAL','Dallas','USDAL','US','USDAL','USDAL','DAL'),(27747,'USA','UNITED STATES OF AMERICA','DET','Detroit','USDET','US','USDET','USDET','DET'),(29110,'USA','UNITED STATES OF AMERICA','HOU','Houston','USHOU','US','USHOU','USHOU','HOU'),(29324,'USA','UNITED STATES OF AMERICA','IND','Indianapolis','USIND','US','USIND','USIND','IND'),(29521,'USA','UNITED STATES OF AMERICA','KCK','Kansas City','USKCK','US','USKCK','USKCK','KCK'),(29704,'USA','UNITED STATES OF AMERICA','LAX','Los Angeles','USLAX','US','USLAX','USLAX','LAX'),(30262,'USA','UNITED STATES OF AMERICA','MEM','Memphis','USMEM','US','USMEM','USMEM','MEM'),(30268,'USA','UNITED STATES OF AMERICA','MES','Minneapolis','USMES','US','USMES','USMES','MES'),(30351,'USA','UNITED STATES OF AMERICA','MIA','Miami','USMIA','US','USMIA','USMIA','MIA'),(30406,'USA','UNITED STATES OF AMERICA','MKE','Milwaukee','USMKE','US','USMKE','USMKE','MKE'),(30617,'USA','UNITED STATES OF AMERICA','MSY','New Orleans','USMSY','US','USMSY','USMSY','MSY'),(31075,'USA','UNITED STATES OF AMERICA','NYC','New York','USNYC','US','USNYC','USNYC','NYC'),(31224,'USA','UNITED STATES OF AMERICA','ORF','Norfolk','USORF','US','USORF','USORF','ORF'),(31372,'USA','UNITED STATES OF AMERICA','PDX','Portland','USPDX','US','USPDX','USPDX','PDX'),(31379,'USA','UNITED STATES OF AMERICA','PEF','Port Everglades','USPEF','US','USPEF','USPEF','PEF'),(31440,'USA','UNITED STATES OF AMERICA','PHL','Philadelphia','USPHL','US','USPHL','USPHL','PHL'),(32315,'USA','UNITED STATES OF AMERICA','SFO','San Francisco','USSFO','US','USSFO','USSFO','SFO'),(34423,'VNM','VIET NAM','DAD','Da Nang','VNDAD','VN','VNDAD','VNDAD','DAD'),(34432,'VNM','VIET NAM','HPH','Haiphong','VNHPH','VN','VNHPH','VNHPH','HPH'),(34448,'VNM','VIET NAM','SGN','Ho Chi Minh City','VNSGN','VN','VNSGN','VNSGN','SGN'),(35388,'ZYA','NETHERLANDS','RTM','Rotterdam','NLRTM','NL','NLRTM','NLRTM','RTM'),(35623,'CHL','CHILE','SAI','San Antonio','CLSAI','CL','CLSAI','CLSAI','SAI'),(35624,'THA','THAILAND','LKR','Laem Chabang','THLKR','TH','THLKR','THLCH','LCH'),(35626,'GTM','GUATEMALA','PRQ','Puerto Quetzal','GTPRQ','GT','GTPRQ','GTPRQ','PRQ'),(35627,'ZAF','SOUTH AFRICA','DUR','Durban','ZADUR','ZA','ZADUR','ZADUR','DUR'),(35628,'BRA','BRAZIL','VIX','Vitoria','BRVIX','BR','BRVIX','BRVIX','VIX');
/*!40000 ALTER TABLE `puertos_interteam` 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:37:50
