mysqldump: [Warning] Using a password on the command line interface can be insecure.
-- MySQL dump 10.13  Distrib 8.0.44, for macos12.7 (arm64)
--
-- Host: localhost    Database: tefnet_erp
-- ------------------------------------------------------
-- Server version	8.0.44

/*!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 utf8mb4 */;
/*!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 `agente_apuracao_periodos`
--

DROP TABLE IF EXISTS `agente_apuracao_periodos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_apuracao_periodos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cod_Representante` int NOT NULL COMMENT 'O agente (idNatureza=3)',
  `competencia` char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'YYYY-MM',
  `modalidade_snap` enum('pct_parceiro','pct_cliente_final','tabela_preco') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pct_padrao_snap` decimal(8,4) DEFAULT NULL,
  `total_titulos_pagos` decimal(14,2) NOT NULL DEFAULT '0.00',
  `total_comissao` decimal(14,2) NOT NULL DEFAULT '0.00',
  `total_disponivel` decimal(14,2) NOT NULL DEFAULT '0.00',
  `total_em_lote` decimal(14,2) NOT NULL DEFAULT '0.00',
  `total_liquidado` decimal(14,2) NOT NULL DEFAULT '0.00',
  `status_ciclo` enum('prevista','apurada','fechada') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'prevista',
  `apurada_at` datetime DEFAULT NULL,
  `apurada_by` int DEFAULT NULL,
  `fechada_at` datetime DEFAULT NULL,
  `fechada_by` int DEFAULT NULL,
  `reaberta_at` datetime DEFAULT NULL,
  `reaberta_by` int DEFAULT NULL,
  `dirty` tinyint(1) NOT NULL DEFAULT '0',
  `dirty_em` datetime DEFAULT NULL,
  `dirty_motivo` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `situacao` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_apur_agente_competencia` (`cod_Representante`,`competencia`),
  KEY `idx_apur_status` (`status_ciclo`,`dirty`),
  KEY `idx_apur_competencia` (`competencia`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_apuracao_periodos`
--

LOCK TABLES `agente_apuracao_periodos` WRITE;
/*!40000 ALTER TABLE `agente_apuracao_periodos` DISABLE KEYS */;
INSERT INTO `agente_apuracao_periodos` VALUES (10,278,'2024-10','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-09 22:12:14',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(11,417,'2024-10','pct_cliente_final',10.0000,172.00,17.20,0.00,17.20,0.00,'fechada','2026-05-09 22:12:14',0,'2026-05-09 22:12:50',0,NULL,NULL,0,NULL,NULL,1),(12,278,'2025-12','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-09 22:12:14',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(13,417,'2025-12','pct_cliente_final',10.0000,1767.00,176.70,176.70,0.00,0.00,'apurada','2026-05-09 22:12:14',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(14,278,'2026-01','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-09 22:12:14',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(15,417,'2026-01','pct_cliente_final',10.0000,2087.00,208.70,208.70,0.00,0.00,'apurada','2026-05-09 22:12:14',0,'2026-05-09 22:54:29',0,'2026-05-09 22:54:30',0,1,'2026-05-09 22:54:30','reabertura: restauracao spec UI#23 Onda 5',1),(16,278,'2026-02','pct_parceiro',10.0000,0.00,0.00,0.00,0.00,0.00,'apurada','2026-05-09 22:12:14',0,NULL,NULL,NULL,NULL,0,NULL,NULL,1),(17,417,'2026-02','pct_cliente_final',10.0000,3778.83,375.70,375.70,0.00,0.00,'apurada','2026-05-09 22:21:32',0,'2026-05-09 22:51:06',0,'2026-05-09 22:51:27',0,1,'2026-05-09 22:51:27','reabertura: Smoke test UI#23 Onda 5 — habilitar botão Fechar pro dono testar',1);
/*!40000 ALTER TABLE `agente_apuracao_periodos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agente_apuracao_itens`
--

DROP TABLE IF EXISTS `agente_apuracao_itens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_apuracao_itens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `apuracao_id` int NOT NULL,
  `cod_Pedido_snap` int NOT NULL,
  `id_titulo_snap` int NOT NULL COMMENT 'tbl_Boleto.id ou tbl_Faturamento.id',
  `fonte_titulo` enum('boleto','faturamento') COLLATE utf8mb4_unicode_ci NOT NULL,
  `cod_Cliente` int NOT NULL,
  `data_pag` date NOT NULL,
  `valor_base` decimal(14,2) NOT NULL,
  `pct_aplicado` decimal(8,4) DEFAULT NULL,
  `comissao` decimal(14,2) NOT NULL,
  `regra_aplicada` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Texto humano-legivel da regra',
  `status_item` enum('disponivel','em_lote','liquidado','estornado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disponivel',
  `lote_id` int DEFAULT NULL,
  `situacao` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_apur_titulo` (`id_titulo_snap`,`fonte_titulo`) COMMENT 'idempotencia: 1 titulo so pode estar em 1 apuracao',
  KEY `idx_apur_item_apur` (`apuracao_id`,`status_item`),
  KEY `idx_apur_item_lote` (`lote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_apuracao_itens`
--

LOCK TABLES `agente_apuracao_itens` WRITE;
/*!40000 ALTER TABLE `agente_apuracao_itens` DISABLE KEYS */;
INSERT INTO `agente_apuracao_itens` VALUES (2,11,6340,78797,'faturamento',5812,'2024-11-18',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','em_lote',1,1),(3,13,6340,101025,'faturamento',5812,'2026-01-15',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(4,13,7692,101066,'faturamento',6887,'2026-01-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(5,13,7780,101069,'faturamento',7078,'2026-01-15',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(6,13,7867,101074,'faturamento',7146,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(7,13,7878,101075,'faturamento',7157,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(8,13,7941,101076,'faturamento',7214,'2026-01-15',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(9,13,8135,101086,'faturamento',7387,'2026-01-15',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(10,13,8246,101091,'faturamento',7487,'2026-01-15',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(11,13,8293,101103,'faturamento',7531,'2026-01-15',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(12,15,6340,102740,'faturamento',5812,'2026-02-18',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(13,15,7692,102780,'faturamento',6887,'2026-02-18',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(14,15,7780,102783,'faturamento',7078,'2026-02-18',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(15,15,7867,102788,'faturamento',7146,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(16,15,7878,102789,'faturamento',7157,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(17,15,7941,102790,'faturamento',7214,'2026-02-18',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(18,15,8135,102800,'faturamento',7387,'2026-02-18',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(19,15,8246,102805,'faturamento',7487,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(20,15,8293,102817,'faturamento',7531,'2026-02-18',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(21,15,8356,102824,'faturamento',7589,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(22,15,8377,102828,'faturamento',7610,'2026-02-18',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(86,17,6340,104575,'faturamento',5812,'2026-03-17',172.00,10.0000,17.20,'10% sobre valor cobrado do cliente final — 10% de R$ 172,00 = R$ 17,20','disponivel',NULL,1),(87,17,7692,104615,'faturamento',6887,'2026-03-16',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(88,17,7780,104618,'faturamento',7078,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(89,17,7867,104623,'faturamento',7146,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(90,17,7878,104624,'faturamento',7157,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(91,17,7941,104625,'faturamento',7214,'2026-03-16',335.00,10.0000,33.50,'10% sobre valor cobrado do cliente final — 10% de R$ 335,00 = R$ 33,50','disponivel',NULL,1),(92,17,8135,104635,'faturamento',7387,'2026-03-19',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(93,17,8246,104640,'faturamento',7487,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(94,17,8293,104653,'faturamento',7531,'2026-03-17',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(95,17,8356,104660,'faturamento',7589,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(96,17,8377,104664,'faturamento',7610,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(97,17,8414,104666,'faturamento',7647,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(98,17,8415,104667,'faturamento',7648,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(99,17,8417,104668,'faturamento',7650,'2026-03-19',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(100,17,8418,104669,'faturamento',7651,'2026-03-18',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(101,17,8419,104670,'faturamento',7652,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(102,17,8420,104671,'faturamento',7653,'2026-03-16',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1),(103,17,8421,104672,'faturamento',7654,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(104,17,8498,104676,'faturamento',7726,'2026-03-16',195.00,10.0000,19.50,'10% sobre valor cobrado do cliente final — 10% de R$ 195,00 = R$ 19,50','disponivel',NULL,1),(105,17,8499,104677,'faturamento',7728,'2026-03-16',125.00,10.0000,12.50,'10% sobre valor cobrado do cliente final — 10% de R$ 125,00 = R$ 12,50','disponivel',NULL,1),(106,17,8502,104678,'faturamento',7730,'2026-03-19',160.00,10.0000,16.00,'10% sobre valor cobrado do cliente final — 10% de R$ 160,00 = R$ 16,00','disponivel',NULL,1);
/*!40000 ALTER TABLE `agente_apuracao_itens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agente_lote_resgate`
--

DROP TABLE IF EXISTS `agente_lote_resgate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_lote_resgate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `numero_humano` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'LR-YYYY-NNNN',
  `cod_Representante` int NOT NULL,
  `data_resgate` datetime NOT NULL COMMENT 'capturado no cliente',
  `total` decimal(14,2) NOT NULL,
  `status_lote` enum('aguardando_pagamento','pago','liquidado','estornado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aguardando_pagamento',
  `data_pag` datetime DEFAULT NULL,
  `forma_pag` enum('pix','ted','boleto','outros') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comprovante_hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'hash_temp pos-upload',
  `observacao` text COLLATE utf8mb4_unicode_ci,
  `liquidado_at` datetime DEFAULT NULL,
  `liquidado_by` int DEFAULT NULL,
  `estornado_at` datetime DEFAULT NULL,
  `estornado_by` int DEFAULT NULL,
  `estorno_motivo` varchar(240) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `situacao` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_lote_numero` (`numero_humano`),
  KEY `idx_lote_repr_status` (`cod_Representante`,`status_lote`),
  KEY `idx_lote_data` (`data_resgate`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_lote_resgate`
--

LOCK TABLES `agente_lote_resgate` WRITE;
/*!40000 ALTER TABLE `agente_lote_resgate` DISABLE KEYS */;
INSERT INTO `agente_lote_resgate` VALUES (1,'LR-2024-0001',417,'2026-05-09 22:13:02',17.20,'aguardando_pagamento',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `agente_lote_resgate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agente_lote_item`
--

DROP TABLE IF EXISTS `agente_lote_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_lote_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lote_id` int NOT NULL,
  `apuracao_item_id` int NOT NULL,
  `valor_snap` decimal(14,2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_lote_item` (`apuracao_item_id`) COMMENT '1 item de apuracao em no maximo 1 lote nao-estornado',
  KEY `idx_lote_item_lote` (`lote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_lote_item`
--

LOCK TABLES `agente_lote_item` WRITE;
/*!40000 ALTER TABLE `agente_lote_item` DISABLE KEYS */;
INSERT INTO `agente_lote_item` VALUES (1,1,2,17.20);
/*!40000 ALTER TABLE `agente_lote_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agente_hist_detalhe`
--

DROP TABLE IF EXISTS `agente_hist_detalhe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_hist_detalhe` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cod_Representante` int NOT NULL,
  `campo` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor_antigo` text COLLATE utf8mb4_unicode_ci,
  `valor_novo` text COLLATE utf8mb4_unicode_ci,
  `alterado_at` datetime NOT NULL,
  `alterado_by` int NOT NULL,
  `origem` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_hist_det_repr` (`cod_Representante`,`alterado_at`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_hist_detalhe`
--

LOCK TABLES `agente_hist_detalhe` WRITE;
/*!40000 ALTER TABLE `agente_hist_detalhe` DISABLE KEYS */;
/*!40000 ALTER TABLE `agente_hist_detalhe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agente_hist_lote`
--

DROP TABLE IF EXISTS `agente_hist_lote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agente_hist_lote` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lote_id` int NOT NULL,
  `campo` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor_antigo` text COLLATE utf8mb4_unicode_ci,
  `valor_novo` text COLLATE utf8mb4_unicode_ci,
  `alterado_at` datetime NOT NULL,
  `alterado_by` int NOT NULL,
  `origem` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_hist_lote` (`lote_id`,`alterado_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agente_hist_lote`
--

LOCK TABLES `agente_hist_lote` WRITE;
/*!40000 ALTER TABLE `agente_hist_lote` DISABLE KEYS */;
/*!40000 ALTER TABLE `agente_hist_lote` 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 2026-05-10 11:18:46