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

DROP TABLE IF EXISTS `carta_porte_prin_dom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `carta_porte_prin_dom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_solicitud` varchar(100) DEFAULT NULL,
  `raz_social` varchar(255) DEFAULT NULL,
  `rfc` varchar(50) DEFAULT NULL,
  `cp` varchar(10) DEFAULT NULL,
  `calle` varchar(255) DEFAULT NULL,
  `no_ext` varchar(10) DEFAULT NULL,
  `no_int` varchar(10) DEFAULT NULL,
  `colonia` varchar(150) DEFAULT NULL,
  `localidad` varchar(150) DEFAULT NULL,
  `municipio` varchar(150) DEFAULT NULL,
  `estado` varchar(100) DEFAULT NULL,
  `pais` varchar(100) DEFAULT NULL,
  `contacto` varchar(255) DEFAULT NULL,
  `telefono` varchar(100) DEFAULT NULL,
  `referencia` varchar(255) DEFAULT NULL,
  `tipo` varchar(15) DEFAULT NULL,
  `fechaHoraSalidaLlegada` varchar(100) DEFAULT NULL,
  `distanciaRecorrida` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i_nosolicitud` (`no_solicitud`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carta_porte_prin_dom`
--

LOCK TABLES `carta_porte_prin_dom` WRITE;
/*!40000 ALTER TABLE `carta_porte_prin_dom` DISABLE KEYS */;
INSERT INTO `carta_porte_prin_dom` VALUES (50,'CP-2402-00002','RAZON 5','RFCV891021GT5','43825','MADRESELVA','10','','OLMOS','','TIZAYUCA','HIDALGO','MEX','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN',NULL,NULL),(52,'CP-2402-00003','LOGISTICA PORTUARIA DE MANZANILLO','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','FERNANDO ROBLES','556677889','UNICA','DESTINO',NULL,NULL),(53,'CP-2402-00004','S','S','20010','S','S','','LAS BRISAS','AGUASCALIENTES','AGUASCALIENTES','AGUASCALIENTES','MEX','','','','ORIGEN',NULL,NULL),(54,'CP-2402-00004','S','S','20010','S','S','S','LAS BRISAS','AGUASCALIENTES','AGUASCALIENTES','AGUASCALIENTES','MEX','','','','DESTINO',NULL,NULL),(55,'CP-2402-00006','OPERADORA DE LA CUENCA DEL PACIFICO S.A. DE C.V.','OCP9209235J9','28259','PUERTO INTERIOR MANZANILLO','B','SECCION 5','SAN PEDRITO','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','ORIGEN',NULL,NULL),(56,'CP-2402-00006','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO',NULL,NULL),(57,'CP-2402-00007','TERMINAL MARITINA HAZESA  S.A. DE C.V.','TMH1304086Q5','28219','PUERTO INTERIOR MANZANILLO ZONA NORTE','POLIGONO I','','PARQUE INDUSTRIAL FONDEPORT','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','ORIGEN',NULL,NULL),(58,'CP-2402-00007','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO',NULL,NULL),(59,'CP-2402-00001','OPERADORA DE LA CUENCA DEL PACIFICO S.A. DE C.V.','OCP9209235J9','28259','PUERTO INTERIOR MANZANILLO','B','SECCION 5','SAN PEDRITO','MANZANILLO','MANZANILLO','COLIMA','MEX','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/03/05 10:03:54',''),(61,'CP-2403-00008','OPERADORA DE LA CUENCA DEL PACIFICO S.A. DE C.V.','OCP9209235J9','28259','PUERTO INTERIOR MANZANILLO','B','SECCION 5','SAN PEDRITO','MANZANILLO','MANZANILLO','COLIMA','MEX','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/03/05 11:03:02',''),(62,'CP-2403-00008','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','CONTACTO 6','5544332233','REFERENCIA 67','DESTINO','2024/03/05 11:03:02','554345'),(63,'CP-2403-00009','SSA MEXICO S.A. DE C.V.','SME9603142NA','28219','CARRETERA MANZANILLO-SANTIAGO','SN','','PARQUE INDUSTRIAL FONDEPORT','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','ORIGEN','2024/03/11 12:03:03',''),(64,'CP-2403-00009','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO','2024/03/11 12:03:03',''),(66,'CP-2403-00010','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO','2024/03/22 07:03:27','150'),(67,'CP-2403-00010','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE .C.V','LPM050301E69','28219','AV. PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO','2024/03/23 07:03:06','1121'),(69,'CP-2402-00001','NRG LOGISTICS S.A. DE C.V.','NLO180212DI8','53120','LOMAS VERDES','640','LOCAL 53','LOMAS VERDES','','','MEXICO','MEXICO','','','','ORIGEN','2024/03/24 06:03:42',''),(70,'CP-2403-00018','SA AUTOMOTIVE S. DE R.L. DE C.V.','SAU100330AL1','72710','AUTOPISTA MEXICO-PUEBLA CERRADA ENCINO','KILOMETRO ','1','PARQUE INDUSTRIAL FINSA','','','PUEBLA','MEXICO','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/03/26 06:03:26',''),(71,'CP-2403-00018','O AND P DE MEXICO S.A. DE C.V.','OPM031203J17','44260','GUANAJUATO','1235','','LA NORMAL','','','JALISCO','MEXICO','CONTACTO 4','4455667788','REFEFENCIA 6','DESTINO','2024/03/26 06:03:26',''),(72,'CP-2403-00020','SE BORDNETZE - MEXICO S.A. DE C.V.','SBG070523JR0','90860','CARRETERA VIA CORTA PUEBLA SANTA ANA KM 17.2','-','','-','','','TLAXCALA','MEXICO','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/03/31 10:03:34',''),(73,'CP-2403-00020','BE LIGHT AND BLUE S.A. DE C.V.','BLA140506T98','52966','MEXICO NUEVO','11 MZ 60 L','','MEXICO NUEVO','','','MEXICO','MEXICO','CONTACTO 5','4433223344','REFERENCIA 2','DESTINO','2024/03/31 10:03:34','42423'),(74,'CP-2403-00019','GERARDO AGUILAR GONZALEZ','AUGG730122L51','58195','ANTONIO CUMPLIDO','62-A','','ANA MARIA GALLAGA','','','MICHOACAN','MEXICO','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/03/31 11:03:04',''),(75,'CP-2403-00019','FAB OPERATIONS S. DE R.L. DE C.V.','FAB191108AY4','66647','AVENIDA (AV.) RUIZ CORTINES','6049','','OTRA NO ESPECIFICADA EN EL CATALOGO','','','NUEVO LEON','MEXICO','CONTACTO 6','4433223344','REFERENCIA 555','DESTINO','2024/03/31 11:03:04','322121'),(76,'CP-2404-00021','TERMINAL INTERNACIONAL DE MANZANILLO S.A. DE C.V.','TIM980730NK3','28239','BOULEVARD MIGUEL DE LA MADRID','286','LOCAL 003','TAPEIXTLES','','','COLIMA','MEXICO','','','','ORIGEN','2024/04/01 08:04:02',''),(77,'CP-2404-00021','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/04/01 08:04:02',''),(79,'CP-2404-00022','TERMINAL INTERNACIONAL DE MANZANILLO S.A. DE C.V.','TIM980730NK3','28239','BOULEVARD MIGUEL DE LA MADRID','286','LOCAL 003','TAPEIXTLES','','','COLIMA','MEXICO','','','','DESTINO','2024/04/01 10:04:53',''),(80,'CP-2404-00023','NRG LOGISTICS S.A. DE C.V.','NLO180212DI8','53120','LOMAS VERDES','640','LOCAL 53','LOMAS VERDES','','','MEXICO','MEXICO','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/04/04 02:04:17',''),(81,'CP-2404-00023','G A RODRIGUEZ S.C.','GAR740314P44','91700','AVENIDA (AV.) MONTESINOS','166','','VERACRUZ CENTRO','','','VERACRUZ','MEXICO','CONTACTO 8','43322344','REFERENCIA 8','DESTINO','2024/04/04 02:04:17','4324234'),(82,'CP-2404-00024','GERARDO AGUILAR GONZALEZ','AUGG730122L51','58195','ANTONIO CUMPLIDO','62-A','','ANA MARIA GALLAGA','','','MICHOACAN','MEXICO','','','','DESTINO','2024/04/05 11:04:24',''),(83,'CP-2404-00024','SA AUTOMOTIVE S. DE R.L. DE C.V.','SAU100330AL1','72710','AUTOPISTA MEXICO-PUEBLA CERRADA ENCINO','KILOMETRO ','1','PARQUE INDUSTRIAL FINSA','','','PUEBLA','MEXICO','','','','ORIGEN','2024/04/05 11:04:24',''),(84,'CP-2404-00022','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','28219','PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','ORIGEN','2024/04/25 04:04:35',''),(85,'CP-2404-00028','SSA MEXICO S.A. DE C.V.','SME9603142NA','01030','AVENIDA (AV.) INSURGENTES SUR','1898','PISO 11','FLORIDA','','','CIUDAD DE MEXICO','MEXICO','','','','ORIGEN','2024/04/30 11:04:20',''),(86,'CP-2404-00028','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','28219','PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO','2024/04/30 11:04:20',''),(89,'CP-2405-00030','C.H. ROBINSON GLOBAL FORWARDING MEXICO S.A. DE C.V.','CRG180816GA9','66260','AVENIDA (AV.) LAZARO CARDENAS','301','PISO 1','DEL VALLE ORIENTE','','','NUEVO LEON','MEXICO','','','','ORIGEN','2024/05/20 09:05:14',''),(90,'CP-2405-00030','C.H. ROBINSON GLOBAL FORWARDING MEXICO S.A. DE C.V.','CRG180816GA9','66260','AVENIDA (AV.) LAZARO CARDENAS','301','PISO 1','DEL VALLE ORIENTE','','','NUEVO LEON','MEXICO','','','','DESTINO','2024/05/20 02:05:44',''),(92,'CP-2404-00027','MABUCHI MOTOR MEXICO S.A. DE C.V.','MMM140808BJ9','20304','CIRCUITO CEREZOS ORIENTE','105','','S/C','','','AGUASCALIENTES','MEXICO','','','','DESTINO','2024/05/21 08:05:21',''),(93,'CP-2404-00027','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','ORIGEN','2024/05/21 09:05:35',''),(94,'CP-2405-00031','TE DE MEXICO S. DE R.L. DE C.V.','TME080325J21','21430','AVENIDA LOS OLIVOS','2500','2','PARQUE INDUSTRIAL EL BAJIO','','','BAJA CALIFORNIA','MEXICO','CONTACTO NUEVO','5566778899','REFERENCIA 2','DESTINO','2024/05/21 06:05:08','120000'),(95,'CP-2405-00031','FE SOLUCIONES S.A. DE C.V.','FSO1603285J8','06400','SALVADOR DIAZ MIRON','61','','SANTA MARIA LA RIBERA','','','CDMX','MEXICO','CONTACTO 5','2233445566','REFERENCIA 5','ORIGEN','2024/05/21 06:05:08',''),(96,'CP-2406-00032','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/06 01:06:06',''),(97,'CP-2406-00032','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','28219','PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','SARAHI MAGAÑA','3141201442','','DESTINO','2024/06/06 01:06:06',''),(98,'CP-2406-00033','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/13 04:06:28',''),(99,'CP-2406-00033','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','28219','PRIVADA PAROTAS I','1','','VALLE DE LAS GARZAS','MANZANILLO','MANZANILLO','COLIMA','MEX','','','','DESTINO','2024/06/13 04:06:28',''),(100,'CP-2406-00034','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/06/19 11:06:32',''),(101,'CP-2406-00034','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/19 11:06:32',''),(102,'CP-2406-00035','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/19 03:06:21',''),(103,'CP-2406-00035','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/06/19 03:06:21',''),(104,'CP-2406-00036','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/06/20 09:06:36',''),(105,'CP-2406-00036','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/20 09:06:36',''),(106,'CP-2406-00037','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/06/20 04:06:13',''),(107,'CP-2406-00037','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/20 04:06:13',''),(108,'CP-2406-00038','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/06/21 03:06:45',''),(109,'CP-2406-00038','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/06/21 03:06:45',''),(110,'CP-2411-00041','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/11/27 05:11:42',''),(111,'CP-2411-00041','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/11/27 05:11:42',''),(112,'CP-2412-00042','LORENA FABIANA ZAPATA','ZALO740606NZA','02410','CASTAÑA','134','','NUEVA SANTA MARÍA','','','DISTRITO FEDERAL','MEXICO','','','','DESTINO','2024/12/12 01:12:21','105'),(113,'CP-2412-00042','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','ORIGEN','2024/12/12 01:12:21',''),(114,'CP-2412-00043','CORPORACION MULTIMODAL S.A. DE C.V.','CMU981126TL6','28250','TRAMO 6','BANDA B','','BUROCRATA','','','COLIMA','MEXICO','','','','ORIGEN','2024/12/20 04:12:43',''),(115,'CP-2412-00043','LOGISTICA PORTUARIA DE MANZANILLO S.A. DE C.V.','LPM050301E69','06700','COLIMA','114','202','ROMA','','','CIUDAD DE MEXICO','MEXICO','','','','DESTINO','2024/12/20 04:12:43','');
/*!40000 ALTER TABLE `carta_porte_prin_dom` 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:30
