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

DROP TABLE IF EXISTS `hblexpint_canceled`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hblexpint_canceled` (
  `files` varchar(255) NOT NULL DEFAULT '',
  `hbl` varchar(255) NOT NULL DEFAULT '',
  `shipper` varchar(255) NOT NULL DEFAULT '',
  `refcustomer` varchar(255) NOT NULL DEFAULT '',
  `consignee` varchar(255) NOT NULL DEFAULT '',
  `notify` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent` varchar(255) NOT NULL DEFAULT '',
  `freightpayable` varchar(255) NOT NULL DEFAULT '',
  `numberoforiginalbillsofloading` varchar(255) NOT NULL DEFAULT '',
  `valueofgoods` varchar(255) NOT NULL DEFAULT '',
  `addvaloremfreightpaid` varchar(255) NOT NULL DEFAULT '',
  `generalclause` varchar(255) NOT NULL DEFAULT '',
  `boardtextcode` varchar(255) NOT NULL DEFAULT '',
  `protectionclause` varchar(255) NOT NULL DEFAULT '',
  `valoremfreightpaid` varchar(255) NOT NULL DEFAULT '',
  `id` varchar(250) NOT NULL DEFAULT '',
  `shipper2` varchar(255) NOT NULL DEFAULT '',
  `shipper3` varchar(255) NOT NULL DEFAULT '',
  `shipper4` varchar(255) NOT NULL DEFAULT '',
  `shipper5` varchar(255) NOT NULL DEFAULT '',
  `shipper6` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent2` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent3` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent4` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent5` varchar(255) NOT NULL DEFAULT '',
  `deliveryagent6` varchar(255) NOT NULL DEFAULT '',
  `consignee2` varchar(255) NOT NULL DEFAULT '',
  `consignee3` varchar(255) NOT NULL DEFAULT '',
  `consignee4` varchar(255) NOT NULL DEFAULT '',
  `consignee5` varchar(255) NOT NULL DEFAULT '',
  `consignee6` varchar(255) NOT NULL DEFAULT '',
  `notify2` varchar(255) NOT NULL DEFAULT '',
  `notify3` varchar(255) NOT NULL DEFAULT '',
  `notify4` varchar(255) NOT NULL DEFAULT '',
  `notify5` varchar(255) NOT NULL DEFAULT '',
  `notify6` varchar(255) NOT NULL DEFAULT '',
  `idhbl` double NOT NULL AUTO_INCREMENT,
  `booking` varchar(100) NOT NULL DEFAULT '',
  `hbl_interteam` varchar(250) NOT NULL DEFAULT '',
  `reservation_clause` varchar(250) NOT NULL DEFAULT '',
  `extra_clause` varchar(250) NOT NULL DEFAULT '',
  `final_port_of_discharge_bl` varchar(180) NOT NULL,
  `booking_cliente` varchar(30) DEFAULT NULL,
  `harmonized_code` int(250) DEFAULT NULL,
  `transmision_ams` varchar(250) DEFAULT NULL,
  `hbl_veracruz` tinyint(4) DEFAULT NULL,
  `referencia_veracruz` varchar(250) DEFAULT NULL,
  `fechaRegistro` datetime DEFAULT NULL,
  `partidas_veracruz` int(11) DEFAULT '0',
  `rebate_wm` varchar(100) DEFAULT NULL,
  `rebate_hbl` varchar(100) DEFAULT NULL,
  `ingresos_transbordo` varchar(100) DEFAULT NULL,
  `fecha_update` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `actualizacion_remota` int(11) DEFAULT '0',
  `PhoneSH` text,
  `FaxSH` text,
  `EmailSH` text,
  `PhoneCN` text,
  `FaxCN` text,
  `EmailCN` text,
  `PhoneN1` text,
  `FaxN1` text,
  `EmailN1` text,
  PRIMARY KEY (`idhbl`),
  KEY `i_B_HBLEXPINT` (`booking`),
  KEY `i_FB_HBLEXPINT` (`files`,`booking`),
  KEY `i_FH_HBLEXPINT` (`files`,`hbl`),
  KEY `i_hbl_interteam` (`hbl_interteam`),
  KEY `i_consignee` (`consignee`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hblexpint_canceled`
--

LOCK TABLES `hblexpint_canceled` WRITE;
/*!40000 ALTER TABLE `hblexpint_canceled` DISABLE KEYS */;
/*!40000 ALTER TABLE `hblexpint_canceled` 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:18:44
