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

DROP TABLE IF EXISTS `email_contacto_puertos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_contacto_puertos` (
  `id_email_contacto` int(11) NOT NULL AUTO_INCREMENT,
  `ejecutivo` text,
  `correo` text,
  `prefijo_puerto` varchar(3) DEFAULT NULL,
  `prefijo_cliente` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`id_email_contacto`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_contacto_puertos`
--

LOCK TABLES `email_contacto_puertos` WRITE;
/*!40000 ALTER TABLE `email_contacto_puertos` DISABLE KEYS */;
INSERT INTO `email_contacto_puertos` VALUES (1,'Christel de Ajuria','christel.deajuria@interteam.com.mx','INT',NULL),(2,'Christian Vega','christian.vega@interteam.com.mx','INT',NULL),(4,'Daniela Borja','daniela.borja@interteam.com.mx','INT',NULL),(5,'Marcela Godinez','marcela.godinez@interteam.com.mx','INT',NULL),(6,'Rosario Carrillo','rosario.carrillo@interteam.com.mx','INT',NULL),(7,'Sofia Garcia','sofia.garcia@interteam.com.mx','INT',NULL),(8,'Tania Rodriguez','tania.rodriguez@interteam.com.mx','INT',NULL),(9,'Jimena Gutierrez','jimena.gutierrez@bollore.com','LPV','BLL'),(10,'Victor Galicia','victor.galicia@dachser.com','LPV','DAC'),(11,'Osvaldo Rangel','osvaldo.rangel@dbschenker.com','LPV','SCH'),(12,'Hector Perez','hector.perez@dbschenker.com','LPV','SCH'),(13,'Korina Gomez','korina.gomez@dbschenker.com','LPV','SCH'),(14,'Christian Flores','christian.flores@dbschenker.com','LPV','SCH'),(15,'Andrea Rodriguez','andrea.rodriguez@dbschenker.com','LPV','SCH'),(16,'Araceli Holguin','araceli.holguin@dbschenker.com','LPV','SCH'),(17,'Marlen Cedeno','marlen.cedeno@dbschenker.com','LPV','SCH'),(18,'Clara Soto','clara.soto@geodis.com','LPV','GEO'),(19,'Juana Pina','juana.pina@jas.com','LPV','JAS'),(20,'Angelica Ortiz','import@newtral.com.mx','LPV','NEW'),(21,'Paola Olvera','paola.olvera@dbschenker.com','LPV','SCH'),(22,'Dora Bustos','dora.bustos@schryver.com','LPV','SCY'),(23,'Jazell Hutchinson','jazell.hutchinson@mex.senator-international.com','LPV','SEN'),(24,'Ana Valdes','ana.valdez@ctl-latam.com','LPV','CTL'),(25,'Erik Carreon','erik@binexline.com','LPV','BIL'),(26,'Gerardo Tamez','gtamez@unitedfc.com.mx','LPV','UFS'),(27,'Manuel Aguillar','mbarriga@rh-shipping.com','LPV','RHS'),(28,'Araceli Vazquez','araceli.vazquez@bonanzalogistics.com.mx','LPV','BOL'),(29,'Christian Vega','christian.vega@interteam.com.mx','LPV',NULL),(30,'Elias Cruz','elias.cruz@interteam.com.mx','LPV',NULL),(31,'Karen Montiel','karen.montiel@interteam.com.mx','LPV',NULL),(32,'Marcela Godinez','marcela.godinez@interteam.com.mx','LPV',NULL),(33,'Rosario Carrillo','rosario.carrillo@interteam.com.mx','LPV',NULL),(34,'Sofia Garcia','sofia.garcia@interteam.com.mx','LPV',NULL),(35,'Tania Rodriguez','tania.rodriguez@interteam.com.mx','LPV',NULL),(36,'Laura Rodriguez','l.rodriguez@dachser.com','LPM','DAC'),(37,'Yessica Galicia','yessica.galicia@jas.com','LPM','JAS'),(38,'Ana Valdes','ana.valdez@ctl-latam.com','LPM','CTL'),(39,'Angelica Ortiz','import@newtral.com.mx','LPM','NEW'),(40,'Carlos Juarez','carlos.juarez@dbschenker.com','LPL','SCH'),(41,'Patricia Gonzalez','patricia.gonzalez@mex.senator-international.com','LPM','SEN'),(42,'Christian Vega','christian.vega@interteam.com.mx','LPM',NULL),(43,'Rosario Carrillo','rosario.carrillo@interteam.com.mx','LPM',NULL),(44,'Tania Rodriguez','tania.rodriguez@interteam.com.mx','LPM',NULL),(45,'Sofia Garcia','sofia.garcia@interteam.com.mx','LPM',NULL),(46,'Elias Cruz','elias.cruz@interteam.com.mx','LPM',NULL),(47,'Karen Montiel','karen.montiel@interteam.com.mx','LPM',NULL),(48,'Marcela Godinez','marcela.godinez@interteam.com.mx','LPM',NULL),(49,'Marcela Godinez','marcela.godinez@interteam.com.mx','LPL',NULL),(50,'Tania Rodriguez','tania.rodriguez@interteam.com.mx','LPL',NULL),(51,'Isaac Rodriguez','isaac.rodriguez@ctl-latam.com','LPL','CTL'),(52,'Ana Valdes','ana.valdez@ctl-latam.com','LPL','CTL'),(53,'Paola Olvera','paola.olvera@dbschenker.com','LPA','SCH'),(54,'Osvaldo Rangel','osvaldo.rangel@dbschenker.com','LPA','SCH'),(55,'Elizabeth Estrada','beatriz.estrada@jas.com','LPA','JAS'),(56,'Flor Cortes','flor.cortes@jas.com','LPA','JAS'),(57,'Manual Martinez','manual.martinez@chrobinson','LPA','CHR'),(58,'Maria Perez','maria.perez@chrobinson','LPA','CHR'),(59,'Paola Rangel','paola.rangel@chrobinson','LPA','CHR'),(60,'Ana Valdes','ana.valdez@ctl-latam.com','LPA','CTL'),(61,'Janet Solis','janet.solis@bonanzalogistics.com.mx','LPA','BOL'),(62,'Jazell Hutchinson','jazell.hutchinson@mex.senator-international.com','LPA','SEN'),(63,'Sharon Romero','sharon.romero@mex.senator-international.com ','LPA','SEN'),(64,'Victor Galicia','victor.galicia@dachser.com','LPA','DAC'),(65,'Christel de Ajuria','christel.deajuria@interteam.com.mx','LPA',NULL),(66,'Christian Vega','christian.vega@interteam.com.mx','LPA',NULL),(67,'Elias Cruz','elias.cruz@interteam.com.mx','LPA',NULL),(68,'Karen Montiel','karen.montiel@interteam.com.mx','LPA',NULL),(69,'Sofia Garcia','sofia.garcia@interteam.com.mx','LPA',NULL),(70,'Laura Rodriguez',' l.rodriguez@dachser.com','LPV','DAC'),(72,'Yessica Galicia','yessica.galicia@jas.com','LPV','JAS'),(73,'Rodrigo Sanchez Galvez','rodrigo.sanchez@dbschenker.com','LPV','SCH'),(74,'Josimar Ramirez','Josimar.Ramirez@dbschenker.com','LPV','SCH'),(75,'Ana Maria Campos','operaciones3@fttransport.com.mx','LPM','FTL'),(76,'Cristian Sanchez','cristian.sanchez@geodis.com','LPV','GEO'),(77,'Miguel Sanchez','miguel.sanchez@bollore.com','LPV','BLL'),(78,'Esteban Gutierrez','importnwt@newtral.com.mx','LPV','NEW'),(79,'Fernanda Bonilla','Fernanda.Bonilla@dbschenker.com','LPV','SCH'),(80,'Paola Contreras','paola.contreras@mex.senator-international.com','LPV','SEN'),(81,'Sharon Romero','sharon.romero@mex.senator-international.com','LPV','SEN'),(82,'Angelica Ortiz','import@newtral.com.mx','LPL','NEW'),(83,'Paulina Calderon','pcalderon@newtral.com.mx','LPV','NEW'),(84,'Diana Ayala','diana.ayala@dbschenker.com','LPV','SCH'),(85,'Ana Isabela Correa','Isabela.Correa@chrobinson.com','LPV','CHR'),(86,'Paola Gomez','paogomez@newtral.com.mx','LPV','NEW'),(87,'Claudia Toledo','cltoledo@seabridge.mx','LPM','SEA'),(88,'Alejandra Sarahi Acevedo','AlejandraSarahi.Acevedo@chrobinson.com','LPM','CHR'),(89,'Siddharta Villar',' siddharta.villar@interteam.com.mx','INT',NULL),(90,'Agustin Dominguez',' Agustin.dominguez@bollore.com','LPV','BLL'),(91,'Cristina Montes','importnwt1@newtral.com.mx','LPV','NEW'),(92,'Tania Sanchez','tania.sanchez@interteam.com.mx','INT',NULL),(93,'Yessica Galicia','yessica.galicia@jas.com','LPA','JAS'),(94,'Diana Alaya','diana.ayala@dbschenker.com','LPA','SCH'),(95,'Marcos Hernandez',' marcos.hernandez@interteam.com.mx','INT',NULL),(96,'Paola Rangel',' Paola.Rangel@chrobinson.com','LPV','CHR'),(97,'Axel Mendez','axel.mendez@jas.com','LPL','JAS'),(98,'Fatima Arevalo','farevalo@macargo.com.mx','LPM','MAC'),(99,'Manuel Martinez','Manuel.Martinez@chrobinson.com','LPV','CHR'),(101,'Lorena Rodriguez','Lorena.Rodriguez@chrobinson.com','LPV','CHR'),(102,'Fernanda Hernandez','fernanda.hernandez2@chrobinson.com','LPV','CHR'),(103,'Patricia Palacios','epalacios@macargo.com.mx','LPA','MAC'),(104,'Rafael Rodriguez','rafrodriguez@seabridge.mx','LPV','SEA'),(105,'Mildred Mares','mildred.mares@chrobinson.com','LPV','CHR'),(106,'Sinhue Bocanegra','Sinhue.Bocanegra@mx.rhenus.com','LPV','RHE'),(107,'Sergio Jimenez','sejimenez@seabridge.mx','LPV','SEA'),(108,'Angel Garcia','Angel.Garcia@chrobinson.com','LPL','CHR'),(109,'Monserrat Martinez','montserrat.martinez@interteam.com.mx','INT',NULL),(110,'Ivan Rodriguez','Ivan.Rodriguez@chrobinson.com','LPV','CHR'),(111,'Janet Solis','janet.solis@bonanzalogistics.com.mx','LPV','BOL'),(113,'FERNANDA LOZOYA','Fernanda.Lozoya@chrobinson.com','LPV','CHR'),(114,'Enriqueta Meza','enriqueta.meza@bonanzalogistics.com.mx','LPV','BOL'),(115,'Alma Andrade','aandrade@newtral.com.mx','LPV','NEW'),(116,'Veronica Flores','Veronica.Flores@mx.rhenus.com','LPV','RHE'),(117,'Alma Andrade','aandrade@newtral.com.mx','LPA','NEW'),(118,'Daysi Lobaco','dlobaco@newtral.com.mx','LPA','NEW'),(119,'Ana Patricia Gutierrez','pagutierrez@newtral.com.mx','LPV','NEW'),(120,'Claudia Toledo','cltoledo@seabridge.mx','LPV','SEA'),(122,'Carlos Ochoa','carlosalberto.ochoagarcia@dbschenker.com','LPM','SCH'),(123,'THALIA MACIAS','thalia.macias@strd.com.mx','LPM','STR'),(124,'Andrea Vazquez','andrea.vazquez@chrobinson.com','LPV','CHR'),(126,'Carlos Juarez','carlos.juarez@dbschenker.com','LPM','SCH'),(127,'GABRIELA MONTES DE OCA','gabriela.montesdeoca@interteam.com.mx','','INT'),(128,'Daniela Perez','daniela.perez@dbschenker.com','LPV','SCH'),(129,'FERNANDA HERRERA','Fernanda.Herrera@chrobinson.com','LPV','CHR'),(130,'ALEJANDRO ARELLANO','Alejandro.Arellano@mx.rhenus.com','LPA','RHE'),(131,'MARIANA RAMOS','mramos@seabridge.mx','LPV','SEA'),(132,'GRACE BUSTAMANTE','Grace.Bustamante@chrobinson.com','LPV','CHR'),(133,'GILBERTO GOMEZ','GILBERTO.GOMEZ@LCLINTERNATIONAL.MX','LPL','LIF'),(134,'JOSELINE URIBE','JOSELINE.URIBE@LCLINTERNATIONAL.MX','LPL','LIF'),(135,'PATRICIA GONZALEZ','operaciones.mx@ankerlogistica.com','LPM','ANK'),(136,'Joseline Uribe','joseline.uribe@lclinternational.mx','LPM','LIF'),(137,'VANESSA MANZO','Vanessa.Manzo@chrobinson.com','LPV','CHR'),(138,'DANIELA MUNIZ','daniela.muniz@bollore.com','LPV','BLL'),(139,'David Carreto','david.carreto@chrobinson.com','LPV','CHR'),(141,'OMAR FLORES','omar.flores@bollore.com','LPV','BLL'),(142,'CLAUDIA TOLEDO','cltoledo@seabridge.mx','LPL','SEA'),(143,'Wendy Lucero Escalante','wendy.lucero@jas.com','LPV','JAS'),(144,'ERANDY CORTES','Erandy.Cortes@hellmann.com','LPM','HEL'),(145,'ELIZABETH CHAVEZ','Elizabeth.Chavez@hellmann.com','LPA','HEL'),(146,'JESSICA RAMIREZ','jessica.ramirez@bollore.com','LPV','BLL'),(147,'ELIZABETH CHAVEZ','Elizabeth.Chavez@hellmann.com','LPV','HEL'),(148,'EDUARDO CASTRO','ecastro@romeumexico.com','LPM','ROM'),(150,'JUAN CARLOS JUAREZ','carlos.juarez@dbschenker.com','LPV','SCH'),(151,'ANA MARIA CAMPOS','operaciones3@fttransport.com.mx','LPV','FTL'),(152,'VERONICA TAVASCI','Veronica.Tavasci@chrobinson.com','LPV','CHR'),(153,'ARIANA SANTANA','ariana.santana@dachser.com','LPV','DAC'),(154,'EDUARDO CRUZ','eduardo.cruz@jas.com','LPV','JAS'),(155,'JESSICA TOLEDANO','jessica.toledano@interteam.com.mx','','INT'),(156,'MARIA FERNANDA ORTEGA','marortega@newtral.com.mx','LPV','NEW'),(157,'SOFIA GARCIA','Sofia.Garcia@chrobinson.com','LPV','CHR'),(158,'VANESSA TREJO','vanessa.trejo@dbschenker.com','LPL','SCH'),(159,'Nelida Santamaria','nesantamaria@newtral.com.mx','LPV','NEW'),(160,'DIANA PALOMARES','dpalomares@newtral.com.mx','LPV','NEW'),(161,'ANGEL GARCIA','Angel.Garcia@chrobinson.com','LPV','CHR'),(162,'YAZMIN TORRES','Yazmin.Torres@chrobinson.com','LPV','CHR'),(163,'Cecilia Gonzalez','cecilia.gonzalez2@chrobinson.com','LPM','CHR'),(164,'ERIKA RAMIREZ','erika.ramirez@chrobinson.com','LPM','CHR'),(165,'ADRIAN MORA','adrian.mora@chrobinson.com','LPM','CHR'),(166,'IRIS MIRANDA','iris.miranda@chrobinson.com','LPM','CHR'),(167,'VANESSA TREJO','vanessa.trejo@dbschenker.com','LPV','SCH'),(168,'Claudia Toledo','cltoledo@seabridge.mx','LPA','SEA'),(169,'MARIA DEL  ANGEL RIVAS','mariadelangel.rivas@dbschenker.com','LPV','SCH'),(170,'ROGERIO MARTINEZ','rogerio.martinez@bonanzalogistics.com.mx','LPV','BOL'),(171,'ALEXIS MORALES','alexis.morales@dachser.com','LPV','DAC'),(172,'Cecilia Herrera','cecilia.herrera@fracht.com','LPA','FLM'),(173,'HECTOR VIGIL','hector.vigil@bollore.com','LPV','BLL'),(174,'VANESSA TREJO','vanessa.trejo@dbschenker.com','LPM','SCH'),(175,'MARIA DEL ANGEL RIVAS','mariadelangel.rivas@dbschenker.com','LPM','SCH'),(176,'CRISTINA CARDENAS TST','cristina.cardenas@lpmzlo.com','LPM','KUE'),(177,'CRISTINA CARDENAS','cristina.cardenas@logisticasportuarias.com.mx','LPA','KUE'),(178,'CRISTINA CARDENAS','cristina.cardenas@logisticasportuarias.com.mx','LPL','KUE'),(179,'CRISTINA CARDENAS','cristina.cardenas@logisticasportuarias.com.mx','LPV','KUE'),(180,'CRISTINA CARDENAS','cristina.cardenas@logisticasportuarias.com.mx','LPL','DSV'),(181,'CRISTINA CARDENA','CRISTINA.CARDENAS@LOGISTICASPORTUARIAS.COM.MX','LPL','PAN'),(182,'GABRIELA FRANCO','gabriela.franco@interteam.com.mx','','INT'),(183,'VALERIA PEREZ','valeria.perez@hellmann.com','LPV','HEL'),(184,'CRISTINA CARDENAS VELAZCO','cristina.cardenas@lpmzlo.com','LPM','PAN'),(185,'FERNANDA VILLEGAS GARCIA','fernanda.f.villegas@dbschenker.com','LPV','SCH'),(186,'JAQUELINE NAJERA','jaqueline.najera@dachser.com','LPV','DAC'),(187,'ENILU GONZALEZ','Enilu.Gonzalez@cevalogistics.com','LPV','BLL'),(188,'CORAL RAMIREZ','Coral.Ramirez@hellmann.com','LPV','HEL'),(189,'VALERY ALVARADO','valvarado@seabridge.mx','LPV','SEA'),(190,'ALEJANDRO MAGAÑA','Alejandro.Magana@chrobinson.com','LPV','CHR'),(191,'Adamary Sanchez','adsanchez@newtral.com.mx','LPV','NEW'),(192,'ADRIAN MORA','Adrian.Mora@chrobinson.com','LPV','CHR'),(193,'SAMANTA MORALES','samorales@seabridge.mx','LPM','SEA'),(194,'SB MX OPERATIONS','operations@seabridge.mx','LPM','SEA'),(195,'TANIA ROMERO','taromero@newtral.com.mx','LPV','NEW'),(196,'FERNANDA CASTAÑON','Fernanda.Castanon@cevalogistics.com','LPV','BLL'),(197,'IVAN SORIA','ivan.soria@dbschenker.com','LPV','SCH'),(198,'DANIELA MONROY','dmonroy@newtral.com.mx','LPV','NEW');
/*!40000 ALTER TABLE `email_contacto_puertos` 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:40
