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

DROP TABLE IF EXISTS `wwa_offices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wwa_offices` (
  `idwwa_offices` double NOT NULL AUTO_INCREMENT,
  `pais` varchar(255) NOT NULL,
  `agente` varchar(255) NOT NULL,
  `senderid` varchar(255) NOT NULL,
  `receiverid` varchar(255) NOT NULL,
  `office` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `type_of_office` varchar(255) NOT NULL,
  `comment_1` varchar(255) NOT NULL,
  `comment_2` varchar(255) NOT NULL,
  PRIMARY KEY (`idwwa_offices`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wwa_offices`
--

LOCK TABLES `wwa_offices` WRITE;
/*!40000 ALTER TABLE `wwa_offices` DISABLE KEYS */;
INSERT INTO `wwa_offices` VALUES (1,'Algeria','Transglory','edi_transglory_prod','DZALG01','Algiers','Algeria','','Ocean',''),(2,'Argentina','SSL Consolidation Service','edi_sslconsolidation_prod','ARBUE01','Buenos Aires','Argentina','','Ocean',''),(3,'Australia','AGS','edi_ags_prod','AUSYD01','Sydney','Australia','','Ocean',''),(4,'Australia','AGS','edi_ags_prod','AUMEL01','Melbourne','Australia','','Ocean',''),(5,'Australia','AGS','edi_ags_prod','AUBNE01','Brisbane','Australia','','Ocean',''),(6,'Australia','AGS','edi_ags_prod','AUADL01','Adelaide','Australia','','Ocean',''),(7,'Australia','AGS','edi_ags_prod','AUFRE01','Freemantle','Australia','','Ocean',''),(8,'Belgium','SSC Consolidation','edi_sscconsolidation_prod','BEANR01','Antwerp','Belgium','','Ocean and Air',''),(9,'Brazil','Allink','edi_allink_prod','BRBHZ01','Belo Horizonte','Brazil','','Ocean',''),(10,'Brazil','Allink','edi_allink_prod','BRCWB01','Curitiba','Brazil','','Ocean',''),(11,'Brazil','Allink','edi_allink_prod','BRITJ01','Itajai','Brazil','','Ocean',''),(12,'Brazil','Allink','edi_allink_prod','BRPNG01','Paranagua','Brazil','','Ocean',''),(13,'Brazil','Allink','edi_allink_prod','BRPOA01','Porto Alegre','Brazil','','Ocean',''),(14,'Brazil','Allink','edi_allink_prod','BRRIG01','Rio Grande','Brazil','','Ocean',''),(15,'Brazil','Allink','edi_allink_prod','BRRIO01','Rio de Janeiro','Brazil','','Ocean',''),(16,'Brazil','Allink','edi_allink_prod','BRSAO01','Sao Paulo','Brazil','','Ocean',''),(17,'Brazil','Allink','edi_allink_prod','BRSSZ01','Santos','Brazil','','Ocean',''),(18,'Brazil','Allink','edi_allink_prod','BRVIX01','Vitoria','Brazil','','Ocean',''),(19,'Canada','Shipco Transport','edi_shipco_prod','CATOR01','Toronto','Canada','','Ocean and Air',''),(20,'Canada','Shipco Transport','edi_shipco_prod','CAMTR01','Montreal','Canada','','Ocean and Air',''),(21,'Chile','Shipco Transport','edi_shipco_prod','CLSCL01','Santiago','Chile','','Ocean and Air',''),(22,'Chile','SSL Consolidation Service','edi_sslconsolidation_prod','CLSCL02','Santiago','Chile','','Ocean',''),(23,'China','Shipco Transport','edi_shipco_prod','HKHKG01','Hong Kong','China','','Ocean and Air',''),(24,'China','Shipco Transport','edi_shipco_prod','CNSHA01','Shanghai','China','','Ocean and Air',''),(25,'China','Shipco Transport','edi_shipco_prod','CNSZX01','Shenzhen','China','','Ocean and Air',''),(26,'Columbia','Mahe Neutral Shipping','edi_mahe_prod','COBOG01','Bogota','Columbia','','Ocean',''),(27,'Columbia','Mahe Neutral Shipping','edi_mahe_prod','COMDE01','Medellin','Columbia','','Ocean',''),(28,'Columbia','Mahe Neutral Shipping','edi_mahe_prod','COCLO01','Cali','Columbia','','Ocean',''),(29,'Columbia','Mahe Neutral Shipping','edi_mahe_prod','COCTG01','Cartagena','Columbia','','Ocean',''),(30,'Columbia','Mahe Neutral Shipping','edi_mahe_prod','COBUN01','Buenaventura','Columbia','','Ocean',''),(31,'Cyprus','SSL Consolidation Service','edi_sslconsolidation_prod','CYLMS01','Limassol','Cyprus','','Ocean',''),(32,'Cyprus','SSL Consolidation Service','edi_sslconsolidation_prod','CYLCA01','Larnaca','Cyprus','','Ocean',''),(33,'Denmark','Shipco Transport','edi_shipco_prod','DKCPH01','Copenhagen','Denmark','','Ocean and Air',''),(34,'Dominican Republic','Dominican International Forwarding','edi_dominican_prod','DOSDQ01','Santo Domingo','Dominican','','Ocean',''),(35,'Dominican Republic','Dominican International Forwarding','edi_dominican_prod','DOSTI01','Santiago','Dominican','','Ocean',''),(36,'Ecuador','SSL Consolidation Service','edi_sslconsolidation_prod','ECGYE01','Guayaquil','Ecuador','','Ocean',''),(37,'Egypt','Mesco','edi_mesco_prod','EGALY01','Alexandria','Egypt','','Ocean',''),(38,'Estonia','Shipco Transport','edi_shipco_prod','EETLL01','Tallinn','Estonia','','Ocean and air',''),(39,'Finland','Shipco Transport','edi_shipco_prod','FIHEL01','Helsinki','Finland','','Ocean and Air',''),(40,'France','Multimodal','edi_multimodal_prod','FRPAR01','Paris','France','','Ocean',''),(41,'France','Multimodal','edi_multimodal_prod','FRLEH01','Le Havre','France','','Ocean',''),(42,'France','Multimodal','edi_multimodal_prod','FRLIO01','Lyon','France','','Ocean',''),(43,'France','Multimodal','edi_multimodal_prod','FRMRS01','Marseille','France','','Ocean',''),(44,'France','Multimodal','edi_multimodal_prod','FRFOS01','Fos','France','','Ocean',''),(45,'Germany','Saco Shipping','edi_saco_prod','DEHAM01','Bremen','Germany','','Ocean',''),(46,'Germany','Saco Shipping','edi_saco_prod','DEHAM01','Hamburg','Germany','','Ocean',''),(47,'India','Teamglobal','edi_teamglobal_prod','INBOM01','Mumbai','India','','Ocean',''),(48,'India','Teamglobal','edi_teamglobal_prod','INAMD01','Ahmedabad','India','','Ocean',''),(49,'India','Teamglobal','edi_teamglobal_prod','INBLR01','Bangalore','India','','Ocean',''),(50,'India','Teamglobal','edi_teamglobal_prod','INMAA01','Chennai','India','','Ocean',''),(51,'India','Teamglobal','edi_teamglobal_prod','INCCU01','Kolkata','India','','Ocean',''),(52,'India','Teamglobal','edi_teamglobal_prod','INPNQ01','Pune','India','','Ocean',''),(53,'India','Teamglobal','edi_teamglobal_prod','INTUP01','Tirupur','India','','Ocean',''),(54,'India','Teamglobal','edi_teamglobal_prod','INTUT01','Tuticorin','India','','Ocean',''),(55,'Indonesia','Shipco Transport','edi_shipco_prod','IDJKT01','Jakarta','Indonesia','','Ocean and Air',''),(56,'Indonesia','Shipco Transport','edi_shipco_prod','IDSUB01','Surabaya','Indonesia','','Ocean and Air',''),(57,'Israel','Eldan-Cargo','edi_eldancargo_prod','ILHFA01','Haifa','Israel','','Ocean',''),(58,'Israel','Eldan-Cargo','edi_eldancargo_prod','ILASH01','Ashdod','Israel','','Ocean',''),(59,'Israel','Eldan-Cargo','edi_eldancargo_prod','ILTLV01','Azur','Israel','','Ocean',''),(60,'Italy','Combimar & Agmar','edi_combimar_prod','ITVMD01','Vimodrone','Italy','','Ocean',''),(61,'Japan','Shipco Transport','edi_shipco_prod','JPTYO01','Tokyo','Japan','','Ocean and Air',''),(62,'Latvia','Shipco Transport','edi_shipco_prod','LVRIX01','Riga','Latvia','','Ocean and Air',''),(63,'Lebanon','Oceanair Consolidators','edi_oceanairconsolidators_prod','LBBEY01','Beirut','Lebanon','','Ocean and Air',''),(64,'Lithuania','Shipco Transport','edi_shipco_prod','LTVNO01','Vilnuis','Lithuania','','Ocean and Air',''),(65,'Malaysia','Shipco Transport','edi_shipco_prod','MYPEN01','Penang','Malaysia','','Ocean and Air',''),(66,'Malaysia','Shipco Transport','edi_shipco_prod','MYPKG01','Port Kelang','Malaysia','','Ocean and Air',''),(67,'Mexico','Interteam','edi_interteam_prod','MXMEX01','Mecico City','Mexico','','Ocean',''),(68,'Mexico','Interteam','edi_interteam_prod','MXVER01','Veracruz','Mexico','','Ocean',''),(69,'Mexico','Interteam','edi_interteam_prod','MXZLO01','Manzanillo','Mexico','','Ocean',''),(70,'Mexico','Interteam','edi_interteam_prod','MXGDL01','Guadalajara','Mexico','','Ocean',''),(71,'Mexico','Interteam','edi_interteam_prod','MXATM01','Altamira','Mexico','','Ocean',''),(72,'Netherlands','SSC Consolidation','edi_sscconsolidation_prod','NLRTM01','Rotterdam','Netherlands','','Ocean and Air',''),(73,'Norway','Shipco Transport','edi_shipco_prod','NOOSL01','Oslo','Norway','','Ocean and air',''),(74,'Panama','Panama Consolidation','edi_panamaconsolidation_prod','PAPTY0','Panama City','Panama','','Ocean',''),(75,'Peru','SSL Consolidation Service','edi_sslconsolidation_prod','PELIM01','Lima','Peru','','Ocean',''),(76,'Philippines','Shipco Transport','edi_shipco_prod','PHMNL01','Manila','Philippines','','Ocean and Air',''),(77,'Poland','Shipco Transport','edi_shipco_prod','PLGDY01','Gdynia','Poland','','Ocean and Air',''),(78,'Portugal','Transglory','edi_transglory_prod','PTLIS01','Lisbon','Portugal','','Ocean',''),(79,'Russia','Scanway Shipping','edi_scanway_prod','RUSTP01','St. Petersburg','Russia','','Ocean',''),(80,'Russia','Scanway Shipping','edi_scanway_prod','RUMOW01','Moscow','Russia','','Ocean',''),(81,'Singapore','Shipco Transport','edi_shipco_prod','SGSIN01','Singapore','Singapore','','Ocean and air',''),(82,'South Africa','CFR Freight','edi_cfrfreight_prod','ZACPT01','Cape Town','South Africa','','Ocean and Air',''),(83,'South Africa','CFR Freight','edi_cfrfreight_prod','ZADUR01','Durban','South Africa','','Ocean and Air',''),(84,'South Africa','CFR Freight','edi_cfrfreight_prod','ZAJBN01','Johannesburg','South Africa','','Ocean and Air',''),(85,'South Africa','CFR Freight','edi_cfrfreight_prod','ZAPLZ01','Port Elizabeth','South Africa','','Ocean and Air',''),(86,'Spain','Transglory','edi_transglory_prod','ESBCN01','Barcelona','Spain','','Ocean',''),(87,'Spain','Transglory','edi_transglory_prod','ESBIO01','Bilbao','Spain','','Ocean',''),(88,'Spain','Transglory','edi_transglory_prod','ESMAD01','Madrid','Spain','','Ocean',''),(89,'Spain','Transglory','edi_transglory_prod','ESVLC01','Valencia','Spain','','Ocean',''),(90,'Spain','Transglory','edi_transglory_prod','ESZAZ01','Zaragoza','Spain','','Ocean',''),(91,'Sri Lanka','Shipco Transport','edi_shipco_prod','LKCMB01','Colombo','Sri Lanka','','Ocean and Air',''),(92,'Sweden','Shipco Transport','edi_shipco_prod','SEGOT01','Gothenburg','Sweden','','Ocean and Air',''),(93,'Thailand','Shipco Transport','edi_shipco_prod','THBKK01','Bangkok','Thailand','','Ocean',''),(94,'Thailand','Shipco Transport','edi_shipco_prod','THBKK02','Bangkok','Thailand','','Air',''),(95,'Tunisia','Transglory','edi_transglory_prod','TNRDS01','Rades-Tunis','Tunisia','','Ocean',''),(96,'Tunisia','Transglory','edi_transglory_prod','TNSFA01','Sfax','Tunisia','','Ocean',''),(97,'Tunisia','Transglory','edi_transglory_prod','TNSUS01','Sousse','Tunisia','','Ocean',''),(98,'Turkey','SSL Consolidation  ','edi_sslconsolidation_prod','TRIST01','Istanbul','Turkey','','Ocean',''),(99,'United Kingdom','Shipco Transport','edi_shipco_prod','GBLON01','London','UK','','Ocean and Air',''),(100,'United States','Shipco Transport','edi_shipco_prod','USATL01','Atlanta','USA','','Ocean and Air',''),(101,'United States','Shipco Transport','edi_shipco_prod','USCHS01','Charleston','USA','','Ocean and Air',''),(102,'United States','Shipco Transport','edi_shipco_prod','USCHI01','Chicago','USA','','Ocean and Air',''),(103,'United States','Shipco Transport','edi_shipco_prod','USHOU01','Houston','USA','','Ocean and Air',''),(104,'United States','Shipco Transport','edi_shipco_prod','USLAX01','Los Angeles','USA','','Ocean',''),(105,'United States','Shipco Transport','edi_shipco_prod','USLAX02','Los Angeles','USA','','Air',''),(106,'United States','Shipco Transport','edi_shipco_prod','USMIA01','Miami','USA','','Ocean and Air',''),(107,'United States','Shipco Transport','edi_shipco_prod','USNYC01','New York','USA','','Ocean',''),(108,'United States','Shipco Transport','edi_shipco_prod','USNYC02','New York','USA','','Air',''),(109,'United States','Shipco Transport','edi_shipco_prod','USNYC03','New York','USA','','Corporate',''),(110,'United States','Shipco Transport','edi_shipco_prod','USSFO01','San Francisco','USA','','Ocean and Air',''),(111,'United States','Shipco Transport','edi_shipco_prod','USSEA01','Seattle','USA','','Ocean and Air',''),(112,'Uruguay','Shipco Transport','edi_sslconsolidation_prod','UYMVD01','Montevideo','Uruguay','','Ocean and Air',''),(113,'Vietnam','Shipco Transport','edi_shipco_prod','VNSGN01','Ho Chi Minh City','Vietnam','','Ocean and Air',''),(114,'Vietnam','Shipco Transport','edi_shipco_prod','VNDAD01','Danang','Vietnam','','Ocean and Air',''),(115,'Vietnam','Shipco Transport','edi_shipco_prod','VNHPH01','Haiphong','Vietnam','','Ocean and Air',''),(116,'Peru','SSL Consolidation','edi_sslconsolidation_prod','PELIM01','callao','Peru','Ocean','',''),(117,'Germany','SACO SHIPPING GMBH.','edi_saco_prod','DEHAM01','BREMERHAVEN','Germany','','Ocean',''),(118,'Germany','SACO SHIPPING GMBH.','edi_saco_prod','DEHAM01','HAMBURG, GERMANY','Germany','','Ocean',''),(119,'Germany','SACO SHIPPING GMBH.','edi_saco_prod','DEHAM01','Hamburg','Germany','','Ocean',''),(120,'Chile','SSL Consolidation Service','edi_sslconsolidation_prod','CLSCL02','VALPARAISO','Chile','','Ocean',''),(121,'Dominican Republic','Dominican International Forwarding','edi_mahe_prod','DOSDQ01','Caucedo','Dominican','','Ocean',''),(122,'Korea','GOLDWAY','edi_goldway_prod','KRPUS02','Busan','Korea','','Ocean',''),(123,'Korea','GOLDWAY','edi_goldway_prod','KRSEL03','Seoul','Korea','','Ocean',''),(124,'Korea','Shipco','edi_shipco_prod','KRSEL03','Seoul','Korea','','Ocean',''),(125,'Korea','GOLDWAY','edi_goldway_prod','KRPUS02','Pusan','Korea','','Ocean',''),(126,'Korea','GOLDWAY','edi_goldway_prod','KRPUS02','Busan','KOREA, REPUBLIC OF','','Ocean',''),(127,'Chile','SHIPCO TRANSPORT (CHILE) S.A.','edi_sslconsolidation_prod','CLSCL02','Santiago','Chile','','Ocean','');
/*!40000 ALTER TABLE `wwa_offices` 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:38:39
