-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_tarifario
-- ------------------------------------------------------
-- 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 `tarifarios`
--

DROP TABLE IF EXISTS `tarifarios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tarifarios` (
  `idtarifarios` int(11) NOT NULL AUTO_INCREMENT,
  `codigo_tarifario` varchar(45) DEFAULT NULL,
  `customer` varchar(100) DEFAULT NULL,
  `agent` varchar(100) DEFAULT NULL,
  `nac` varchar(45) DEFAULT NULL,
  `fecha_creacion` date DEFAULT NULL,
  `fecha_actualizacion` datetime DEFAULT NULL,
  `usuario` varchar(45) DEFAULT NULL,
  `tipo` varchar(10) DEFAULT NULL,
  `servicio` varchar(45) DEFAULT NULL,
  `vigencia_especial` tinyint(4) DEFAULT '0',
  `monto_especial` tinyint(4) DEFAULT '0',
  `id_solicitud` int(11) DEFAULT NULL,
  `validity_general_from` date DEFAULT NULL,
  `validity_general_to` date DEFAULT NULL,
  `pss_validity_from` date DEFAULT NULL,
  `pss_validity_to` date DEFAULT NULL,
  `status_solicitud` varchar(45) DEFAULT NULL,
  `aprobo_solicitud` varchar(45) DEFAULT NULL,
  `historial` text,
  `activo` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`idtarifarios`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifarios`
--

LOCK TABLES `tarifarios` WRITE;
/*!40000 ALTER TABLE `tarifarios` DISABLE KEYS */;
INSERT INTO `tarifarios` VALUES (1,'STD-skxmjtyofvaec8phduw4','STANDARD',NULL,'','2023-06-08',NULL,'HGUILLEN','LCL','EXPORTACION',0,0,NULL,'2023-06-01','2023-09-30','2023-06-01','2023-09-30',NULL,NULL,NULL,1),(4,'AG-ijned0batvx7u4lgpf3q',NULL,'TRANSGLORY S.A.','','2023-09-28',NULL,'HGUILLEN','LCL','EXPORTACION',0,1,3,'2023-09-29','2023-10-31',NULL,NULL,'En Revision',NULL,NULL,1),(5,'AG-tvmzbo419spixj07elru',NULL,'MAHE NEUTRAL SHIPPING S.A.','','2023-09-28',NULL,'HGUILLEN','LCL','EXPORTACION',0,0,NULL,'2023-09-29','2023-10-31',NULL,NULL,NULL,NULL,NULL,1),(6,'AG-m2zt9xca537ndpgybijk',NULL,'SSC CONSOLIDATION NV','','2023-10-05',NULL,'OHERNANDEZ','LCL','EXPORTACION',0,0,NULL,'2023-11-01','2023-11-30',NULL,NULL,NULL,NULL,NULL,1),(7,'AG-tpbx8g6yqn7rkcu4im1j',NULL,'SACO SHIPPING GMBH','','2023-10-05',NULL,'OHERNANDEZ','LCL','EXPORTACION',0,0,NULL,'2023-11-01','2023-11-30',NULL,NULL,NULL,NULL,NULL,1),(8,'AG-ya7evd1p0w392c8hijro',NULL,'ALLINK TRANSPORTES INTERNACIONAIS','','2023-10-05',NULL,'OHERNANDEZ','LCL','EXPORTACION',0,0,NULL,'2023-11-01','2023-11-30',NULL,NULL,NULL,NULL,NULL,1),(9,'AG-bxzhygkct2pmjlau65f3',NULL,'SACO SHIPPING LINE S.A.','','2023-10-05',NULL,'OHERNANDEZ','LCL','EXPORTACION',0,0,NULL,'2023-11-01','2023-11-30',NULL,NULL,NULL,NULL,NULL,1),(10,'AG-ty6up5s4lh1g0divbe7r',NULL,'GOLDWAY LOGISTICS SERVICE CO. LTD','','2023-10-26',NULL,'OHERNANDEZ','LCL','EXPORTACION',0,0,NULL,'2023-10-26','2023-11-30',NULL,NULL,NULL,NULL,NULL,1),(11,'CUS-71pyond2kg8ac3vrmqfs','4 CARGO SERVICIOS DE COMERCIO S.A. DE C.V.','','','2023-11-28',NULL,'CSAMAYOA','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(13,'AG-sec84qa3umflirg19kyn','','INTERTEAM, S.A. DE C.V.','','2023-12-07',NULL,'HGUILLEN','LCL','EXPORTACION',0,0,NULL,'2023-12-08','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(14,'CUS-wg31uky96a8mxvno7i25','CLIENTE TEST - ESPANA','','','2023-12-07',NULL,'LLOOSLISTG','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(15,'CUS-htqopnjz0wk2c9drf83s','CLIENTE PROSPECTO PRUEBA 1 CRM CENTIA','','','2023-12-07',NULL,'LLOOSLISTG','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(16,'AG-i9zph5oc1brwm4vegl36','','PANDA QINGDAO','','2023-12-07',NULL,'HGUILLEN','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(17,'AG-p9rflzksnq5oa4u7vtiw','','AIR SEA LOPES TRANSITARIOS LDA','','2023-12-14',NULL,'OHERNANDEZSTG','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(18,'CUS-8mxut014gqirz65bh7wn','A. HARTRODT MEXICO S.A. DE C.V.','','','2023-12-14',NULL,'LLOOSLISTG','LCL','EXPORTACION',1,0,4,'2023-08-01','2023-12-31',NULL,NULL,'Pendiente',NULL,NULL,0),(19,'AG-f85d6nh3kytea74jqzs2','','AGS WORLD TRANSPORT','','2023-12-14',NULL,'LLOOSLISTG','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(20,'CUS-wp7lkue523cd9gibrxy1','98 COAST AVENUE S.A. DE C.V.','','','2023-12-14',NULL,'LLOOSLISTG','LCL','EXPORTACION',0,0,NULL,'2023-12-15','2024-01-31',NULL,NULL,NULL,NULL,NULL,1),(21,'AG-7w620udhv85lkfc1prtb','','SACO SHIPPING S.A., BUENOS AIRES, ARGENTINA','','2023-12-20',NULL,'OHERNANDEZSTG','LCL','EXPORTACION',0,0,NULL,'2023-08-01','2023-12-31',NULL,NULL,NULL,NULL,NULL,1),(22,'CUS-d1g2lqzcvufk6sem097a','GEODIS MEXICO S.A. DE C.V.','','','2024-05-30',NULL,'ARAMIREZSTG','LCL','EXPORTACION',1,0,1,'2024-05-31','2024-06-15',NULL,NULL,'En Revision',NULL,NULL,0),(23,'CUS-8uwk4anrfg7bvijmy1xz','A SCHULMAN DE MEXICO S.A. DE C.V.','','','2024-07-19',NULL,'CSAMAYOA','LCL','EXPORTACION',1,0,2,'2024-07-01','2024-08-29',NULL,NULL,'En Revision',NULL,NULL,0),(24,'CUS-5r8kv19l7sy3dxzoamqb','COZZINI MIDDLEBY DE MEXICO S. DE R.L. DE C.V.','','','2024-08-07',NULL,'CSAMAYOA','LCL','EXPORTACION',0,0,NULL,'2024-08-01','2024-12-31',NULL,NULL,NULL,NULL,NULL,1),(25,'CUS-tsjwbm5v7yd3rcfgqehz','AIGX LOGISTICA INTERNACIONAL S.A. DE C.V.','','','2025-02-06',NULL,'CSAMAYOA','LCL','EXPORTACION',0,0,NULL,'2025-02-03','2025-02-20',NULL,NULL,NULL,NULL,NULL,1),(26,'CUS-zycvaqrl5248bfdntsmg','APTAR QUERETARO S.A. DE C.V.','','','2025-02-06',NULL,'CSAMAYOA','LCL','EXPORTACION',0,0,NULL,'2025-02-11','2025-03-24',NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `tarifarios` 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 21:02:06
