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

DROP TABLE IF EXISTS `numero_transportista`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `numero_transportista` (
  `idnumero_transportista` double NOT NULL AUTO_INCREMENT,
  `transportista` varchar(255) NOT NULL DEFAULT '',
  `numero_transportista` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(45) DEFAULT NULL,
  `SCAC` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idnumero_transportista`)
) ENGINE=InnoDB AUTO_INCREMENT=298 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `numero_transportista`
--

LOCK TABLES `numero_transportista` WRITE;
/*!40000 ALTER TABLE `numero_transportista` DISABLE KEYS */;
INSERT INTO `numero_transportista` VALUES (1,'HAPAG-LLOYD AKTIENGESELLSCHAFT, HAMBURG','2509','HAPAG LLOYD','HLCU'),(2,'COSTA CONTAINER LINE ADMINISTRATION S.A. DE C.V.','3476',NULL,NULL),(3,'H. STINNES LINIEN GMBH','3477',NULL,NULL),(4,'NORDANA LINE A/S','3478',NULL,NULL),(5,'GALBORG PTE. LTD.','3479',NULL,NULL),(6,'SCM LINES','3480',NULL,NULL),(7,'RICKMERS LINIE GMBH','3481',NULL,NULL),(9,'WESTERN BULK CARRIERS','3483',NULL,NULL),(10,'HOEGH AUTOLINERS A/S','3484',NULL,NULL),(11,'SEATRADE REEFER CHARTERING','3485',NULL,NULL),(12,'CARGO LEVANT SCHIFFAHRTS GMBH','3486',NULL,NULL),(13,'SILKTON CORPORATION','3487',NULL,NULL),(14,'COMPANIA SUD AMERICANA DE VAPORES S.A.','3490',NULL,NULL),(15,'COMPAÑIA LIBRA DE NAVEGACION (URUGUAY) S.A.','3491',NULL,NULL),(16,'CSAV NORASIA','3498',NULL,NULL),(18,'COMPAÑIA SUD AMERICANA DE VAPORES PANAMA','3500',NULL,NULL),(19,'CGRAILWAY, INC.','3520',NULL,NULL),(21,'DAIICHI CHUO KISEN KAISHA','3630',NULL,NULL),(22,'FEDNAV INTERNATIONAL LTD','3631',NULL,NULL),(23,'KAWASAKI KISEN KAISHA LTD','3651','KAWASAKI KISEN KAISHA LTD','KKLU'),(24,'ODFJELL SEACHEM AS','3894',NULL,NULL),(25,'ORIENT OVERSEAS CONTAINER LINE LTD','4309','OOCL','OOCL'),(26,'MELFI MARINE CORP. S.A.','4310',NULL,NULL),(27,'ORIENT OVERSEAS CONTAINER LINE LTD.','4311','OOCL','OOCL'),(28,'SEABOARD MARINE LIMITED','4540','SEABOARD','SMLU'),(29,'CMA CGM','4727','CMA CGM','CMDU'),(30,'HANJIN SHIPPING CO., LTD.','4760',NULL,NULL),(31,'MITSUI O.S.K. LINES, LTD.','4891',NULL,NULL),(32,'MARUBA, S. A., EMPRESA DE NAVEGACIÓN MARITIMA','4994',NULL,NULL),(33,'COMPANIA CHILENA DE NAVEGACION INTEROCEANICA, S.A.','4995',NULL,NULL),(34,'EVERGREEN MARINE CORP. (TAIWAN) LTD.','4996','EVERGREEN','EGLV'),(35,'WALLENIUS WILHELMSEN LOGISTICS AMERICAS, LLC','5001',NULL,NULL),(36,'EVERGREEN MARINE (UK) LTD.','5002','EVERGREEN','EGLV'),(37,'CHINA SHIPPING CONTAINER LINES CO.,LTD.','5008',NULL,NULL),(38,'CHINA SHIPPING CONTAINER LINES (HONG KONG) CO., LT','5009',NULL,NULL),(39,'MAERSK LINE','5037','MAERSK','MAEU'),(40,'SAFMARINE','5038',NULL,NULL),(42,'NAVIERA CHILENA DEL PACIFICO S.A.','5095',NULL,NULL),(43,'AGENCIA CONSIGNATARIA LATINOAMERICANA SA DE CV','5258',NULL,NULL),(44,'TOKO KAIUN KAISHA,LTD.','5273',NULL,NULL),(45,'TBS SHIPPING SERVICES INC.','5274',NULL,NULL),(46,'MITSUI O.S.K. LINES','5322',NULL,NULL),(47,'NISSAN MOTOR CAR CARRIER CO., LTD.','5359',NULL,NULL),(48,'PACC CONTAINER LINE PTE LTD','5360',NULL,NULL),(49,'CORRAL LINE APS','5361',NULL,NULL),(50,'SHINWA KAIUN KAISHA, LTD.','5363',NULL,NULL),(51,'WATERFRONT SHIPPING COMPANY LIMITED','5368',NULL,NULL),(52,'STX PAN OCEAN SHIPPING CO., LTD.','5392',NULL,NULL),(53,'ONEGO SHIPPING & CHARTERING','5393',NULL,NULL),(54,'ONEGO SHIPPING INC.','5394',NULL,NULL),(55,'ONEGO SHIPPING & CHARTERING B.V.','5401',NULL,NULL),(56,'STX PAN OCEAN CO., LTD.','5431',NULL,NULL),(57,'DORVAL KAIUN K.K.','5433',NULL,NULL),(58,'KINGFISH SERVICES LIMITED','5434',NULL,NULL),(59,'MORGAN STANLEY CAPITAL GROUP INC','5435',NULL,NULL),(60,'SKS OBO LIMITED','5436',NULL,NULL),(61,'SKS TANKERS LIMITED','5437',NULL,NULL),(62,'HAMBURG SÜDAMERIKANISCHE DAMPFSCHIFFFAHRTS-GESELLS','5438','HAMBURG SUD','SUDU'),(63,'ALIANCA NAVECAGAO E LOGISTICA LTDA.','5440',NULL,NULL),(64,'JUMBO SHIPPING V.O.F.','5450',NULL,NULL),(65,'PENNANT SERVICOS MARITIMOS','5472',NULL,NULL),(66,'LAURIN MARITIME (AMERICA) INC.','5478',NULL,NULL),(67,'STAR SHIPPING A/S','5502',NULL,NULL),(68,'STOLT NIELSEN TRANSPORTATION GROUP','5521',NULL,NULL),(69,'BERTLING LOGISTICS (PERU) SAC','5533',NULL,NULL),(70,'INTERSEE SCHIFFAHRTSGESELLSCHAFT MBH & CO','5534',NULL,NULL),(71,'CANFORNAV INC.','5535',NULL,NULL),(72,'TRAFIGURA BEHEER B.V.','5536',NULL,NULL),(73,'CHINA SHIPPING DEVELOPMENT CO., LTD.','5542',NULL,NULL),(74,'CLIPPER WONSILD TANKERS, INC.','5543',NULL,NULL),(75,'PANAMERICAN TANKERS INC.','5544',NULL,NULL),(76,'CLIPPER STEEL SERVICES BV','5545',NULL,NULL),(77,'SAN REMOLQUES, S.A. DE C.V.','5579',NULL,NULL),(78,'TRANS SEA TRANSPORT NV','5585',NULL,NULL),(79,'UNITED BULK CARRIERS','5588',NULL,NULL),(80,'INTRAHA SHIPPING INC','5589',NULL,NULL),(81,'CANFORNAV INC','5608',NULL,NULL),(82,'NYK DE MEXICO, S.A. DE C.V.','5609',NULL,NULL),(83,'P.M.I. TRADING LIMITED','5613',NULL,NULL),(84,'AET INC. LIMITED','5614',NULL,NULL),(85,'HEIDENREICH MARINE INC','5615',NULL,NULL),(86,'SHELL OIL COMPANY','5616',NULL,NULL),(87,'MINERVA MARINE INC','5617',NULL,NULL),(88,'NOVOSHIP (UK) LTD','5618',NULL,NULL),(89,'SKAUGEN PETROTRANS INC','5620',NULL,NULL),(90,'VALERO MARKETING AND SUPPLY COMPANY','5622',NULL,NULL),(91,'INDUSTRIAL MARITIME CARRIERS, L.L.C.','5623',NULL,NULL),(92,'CHEVRON TRANSPORT CORPORATION LTD','5624',NULL,NULL),(93,'OSG SHIP MANAGEMENT INC','5625',NULL,NULL),(94,'ST SHIPPING AND TRANSPORT PTE LTD','5626',NULL,NULL),(95,'TRANSOCEAN GRABBULK POOL PTE LTD','5627',NULL,NULL),(96,'FRONT SPLENDOUR SHIPPING INC','5628',NULL,NULL),(97,'MELIDA EDIKI NAFTIKI EPIHIRISI','5630',NULL,NULL),(98,'STANDARD TANKERS BAHAMAS LIMITED','5632',NULL,NULL),(99,'HEIDMAR INC','5634',NULL,NULL),(100,'KYODO SHIPPING LIMITED','5636',NULL,NULL),(101,'ASSOCIATED TRANSPORT LINE','5637',NULL,NULL),(102,'TRANSPORTACION MARITIMA MEXICANA, S.A. DE C.V.','5641',NULL,NULL),(103,'HILTVEIT ASSOCIATES INC','5642',NULL,NULL),(104,'MEGA SHIPPING LINE CORP','5643',NULL,NULL),(105,'NOVOROSSIYSK SHIPPING COMPANY','5644',NULL,NULL),(106,'TEEKAY CORPORATION','5645',NULL,NULL),(107,'SCHENKER INTERNATIONAL SA DE CV','5646',NULL,NULL),(108,'BBC CHARTERING & LOGISTIC GMBH & CO. KG','5647',NULL,NULL),(109,'DAN-GULF SHIPPING, INC.','5648',NULL,NULL),(110,'PMI TRADING LIMITED','5649',NULL,NULL),(111,'NAVIERA YACUPUMA S.A.','5650',NULL,NULL),(112,'CLIPPER AMERICAS INC','5651',NULL,NULL),(113,'ELETSON CORPORATION','5652',NULL,NULL),(114,'MITTAL SHIPPING, LTD.','5654',NULL,NULL),(115,'TRIWORLD SHIPPING SERVICES INC','5655',NULL,NULL),(116,'LAURIN MARITIME AMERICA INC','5657',NULL,NULL),(117,'WEST COAST INDUSTRIAL EXPRESS','5658',NULL,NULL),(118,'CSL INTERNATIONAL','5659',NULL,NULL),(119,'VULICA SHIPPING COMPANY LTD','5660',NULL,NULL),(120,'OCEAN LOGISTICS CORPORATION','5661',NULL,NULL),(121,'MANSEL OIL LTD','5662',NULL,NULL),(122,'CAJA LOGISTICS GROUP CORP.','5663',NULL,NULL),(123,'EITZEN BULK (USA) INC','5664',NULL,NULL),(124,'THOMPSON SHIPPING COMPANY','5665',NULL,NULL),(125,'ONEGO SHIPPING INC','5666',NULL,NULL),(126,'AMERICAN EAGLE TANKERS INC, LIMITED','5668',NULL,NULL),(127,'TSAKOS SHIPPING AND TRADING S.A.','5669',NULL,NULL),(128,'STAVANGER NAVION KS','5670',NULL,NULL),(129,'STVANGER BAY KS','5671',NULL,NULL),(130,'STAVANGER VIKING KS','5672',NULL,NULL),(131,'STVANGER BLOSSOM KS','5673',NULL,NULL),(132,'ZIM AMERICAN INTEGRATED SHIPPING SERVICES','5674','ZIM','ZIMU'),(133,'MEXSHIPPING AGENCIA, S.A DE C.V.','5675',NULL,NULL),(135,'APL MÉXICO S.A. DE C.V.','5677','APL MEXICO S.A. DE C.V.','APLU'),(136,'MCDONOUGH MARINE SERVICE','5678',NULL,NULL),(137,'FAIRFIELD CHEMICAL CARRIERS, INC','5679',NULL,NULL),(138,'OCEAN BULK SHIPPING LLC','5680',NULL,NULL),(139,'JACOB SCORPIO TANKER POOL C/O JACOB SCORPIO POOL M','5692',NULL,NULL),(140,'VOLKSWAGEN LOGISTICS GMBH & CO. OHG','5695',NULL,NULL),(141,'REDWISE MARITIME SERVICES B.V.','5698',NULL,NULL),(142,'ONEGO SHIPPING AND CHARTERING B.V.','5699',NULL,NULL),(143,'CMA-CGM','5700','CMA CGM','CMDU'),(144,'GAZ DE FRANCE S.A.','5702',NULL,NULL),(145,'UNICOM MANAGEMENT SERVICES (CYPRUS) LTD','5703',NULL,NULL),(146,'MITTAL STEEL LAZARO CARDENAS, S.A. DE C.V.','5713',NULL,NULL),(147,'SWISSMARINE SERVICES S.A.','5718',NULL,NULL),(148,'WESTERN B CARRIERS','5719',NULL,NULL),(149,'NIPON YUSEN KAISHA LINE','5720',NULL,NULL),(150,'EUROPEAN EASTERN CARRIERS','5721',NULL,NULL),(151,'LINEA PENINSULAR, INC.','5722',NULL,NULL),(152,'THE SANKO STEAMSHIP COMPANY LIMITED','5724',NULL,NULL),(153,'NOVOSHIP UK LTD','5725',NULL,NULL),(154,'HAPAG-LLOYD AKTIENGESELLSCHAFT,HAMBURG','5726','HAPAG LLOYD','HLCU'),(155,'EITZEN CHEMICAL USA LLC','5732',NULL,NULL),(156,'BLUE MARLIN CHARTERING N.V.','5733',NULL,NULL),(157,'ALLIED MARITIME INC.','5734',NULL,NULL),(158,'THE RICE COMPANY','5735',NULL,NULL),(159,'SHIPPING GMBH & CO.KG','5736',NULL,NULL),(160,'POLSTEAMUSA INC.','5737',NULL,NULL),(161,'SCHENKER DO BRASIL TRANSP.INTL.LTDA','5738',NULL,NULL),(162,'JSC NOVOROSSIYSK SHIPPING COMPANY','5739',NULL,NULL),(163,'SCHENKER CHILE S.A.','5740',NULL,NULL),(164,'SCHENKER ALEMANIA','5741',NULL,NULL),(165,'MERIDIAN BULK CARRIERS LTD OF MARSHALL ISLANDS','5753',NULL,NULL),(166,'IONIA MANAGEMENT S.A.','5755',NULL,NULL),(167,'MANSEL OIL BERMUDA','5758',NULL,NULL),(168,'PRONAV SHIPPING SERVICES GMBH','5759',NULL,NULL),(169,'FR8 SINGAPORE PTE. LTD','5760',NULL,NULL),(170,'MED LNG & GAS LTD.','5762',NULL,NULL),(171,'GAZ DE FRANCE INTERNATIONAL TRADING','5763',NULL,NULL),(172,'SINOPE SHIPPING CO LTD','5767',NULL,NULL),(173,'TRAMMO NAVIGATION LTD. C/O TRANSAMMONIA SARL','5771',NULL,NULL),(174,'SK SHIPPING CO., LTD.','5773',NULL,NULL),(175,'GEARBULK SHIPPING CANADA LTD.','5774',NULL,NULL),(176,'KLINE MEXICO S.A DE C.V.','5832',NULL,NULL),(197,'WAN HAI LINES','A06M','WAN HAI','22AA'),(198,'XCF, S.A. DE C.V.','5836',NULL,NULL),(199,'YANG MING MARINE','10YD','YANG MING','YMLU'),(200,'MTI TRANSPORT, S.A. DE C.V.','5838',NULL,NULL),(201,'TRANSPORTES DK, S.A. DE C.V.','5839',NULL,NULL),(202,'INTERJET','5840',NULL,NULL),(203,'PACIFIC INTERNATIONAL LINES (PTE) LTD.','5841',NULL,NULL),(204,'TRANSPORTES LOGIS, S.A. DE C.V.','5842',NULL,NULL),(205,'INTERMODAL EXPRESS SERVICIOS LOGISTICOS','5843',NULL,NULL),(206,'ATLANTA LOGISTICA, S.A. DE C.V.','5844','ATLANTA LOGISTICA, S.A. DE C.V.','HYDU'),(207,'TRANSPORTES BALLESTEROS','5845',NULL,NULL),(208,'LOGISTICA INTEGRAL VALERA, S.A. DE C.V. ','5846',NULL,NULL),(214,'HYUNDAI MERCHANT MARINE CO.,LTD.','5951','HYUNDAI','HDMU'),(267,'MEDITERRANEAN SHIPPING COMPANY S.A.','5069','MSC','MSCU'),(273,'TRANS NEYNO, S.A. DE C.V.','1',NULL,NULL),(274,'AUTOLINEAS MEXICANAS, S.A. DE C.V.','1',NULL,NULL),(275,'COSCO CONTAINER LINES, CO. LTD.','3629',NULL,NULL),(276,'REPRESENTACIONES TRANSPACíFICAS (TRANSPAC), S.A. DE C.V.','1',NULL,NULL),(277,'AIR FRANCE','1',NULL,NULL),(278,'APL','5677','APL MEXICO S.A. DE C.V.','APLU'),(279,'COSCO CONTAINER LINES LTD','3629',NULL,NULL),(280,'CHINA SHIPPING CONTAINER LINES CO., LTD.','1',NULL,NULL),(281,'OCEAN NETWORK EXPRESS','34ME','ONE','ONEY'),(282,'SEALAND','A0VJ','SEALAND','SEJJ'),(283,'NORTON LILLY SHIPPING MEXICO','7501','NORTON LILLY SHIPPING MEXICO','NLSS'),(284,'MARFRET COMPAGNIE MARITIME','31QF','COMPAGNIE MARITIME MARFRET','MFTU'),(286,'COSCO SHIPPING CO LTD','5962','COSCO','COSU'),(287,'ECU LOGISTICS DE MEXICO SA DE CV','A02H','ECULINE','ECUI'),(288,'AGENCIA NAVIERA VICANE S.A. DE C.V. / HYDE SHIPPING / ULTRAMAR','5844','VICANE','HYDU'),(290,'WAN HAI LINES','A06M','WAN HAI','WHLC'),(291,'WAN HAI LINES','A06M','WAN HAI','WHLU'),(292,'SEALEAD SHIPPING PTE LTD.','4214','SEALEAD','SJHH'),(293,'SINOKOR MERCHANT MARINE CO., LTD.','6888','SINOKOR','SKLU'),(294,'TS LINES LIMITED','41YK','TS LINES','TSTU'),(295,'EMIRATES SHIPPING LINE FZE','41QN','FZE','ESPU'),(296,'SINOTRANS CONTAINER LINES CO., LTD.','41Y0','SINOTRANS','12IH'),(297,'KOREA MARINE TRANSPORT CO LTD','41MD','KMTC','KMTU');
/*!40000 ALTER TABLE `numero_transportista` 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:25:32
