-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 04/02/2026 às 07:30
-- Versão do servidor: 8.0.42-0ubuntu0.20.04.1
-- Versão do PHP: 7.4.3-4ubuntu2.29

START TRANSACTION;



--
-- Banco de dados: `lanchonete`
--

-- --------------------------------------------------------

--
-- Estrutura para tabela `caixas`
--

CREATE TABLE `caixas` (
  `id` int NOT NULL,
  `usuario_id` int NOT NULL,
  `aberto_em` datetime NOT NULL,
  `fechado_em` datetime DEFAULT NULL,
  `saldo_inicial` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_dinheiro` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_pix` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_debito` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_credito` decimal(10,2) NOT NULL DEFAULT '0.00',
  `saldo_final` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` enum('ABERTO','FECHADO') NOT NULL DEFAULT 'ABERTO',
  `observacoes` text,
  `criado_em` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `caixas`
--

INSERT INTO `caixas` (`id`, `usuario_id`, `aberto_em`, `fechado_em`, `saldo_inicial`, `total_dinheiro`, `total_pix`, `total_debito`, `total_credito`, `saldo_final`, `status`, `observacoes`, `criado_em`) VALUES
(1, 1, '2026-01-21 17:33:47', NULL, '50.00', '0.00', '0.00', '0.00', '0.00', '0.00', 'FECHADO', '', '2026-01-21 17:33:47'),
(2, 1, '2026-01-25 18:54:16', NULL, '50.00', '0.00', '0.00', '0.00', '0.00', '0.00', 'ABERTO', '', '2026-01-25 18:54:16');

-- --------------------------------------------------------

--
-- Estrutura para tabela `caixa_lancamentos`
--

CREATE TABLE `caixa_lancamentos` (
  `id` int NOT NULL,
  `caixa_id` int DEFAULT NULL,
  `usuario_id` int DEFAULT NULL,
  `tipo` enum('ENTRADA','SAIDA') NOT NULL DEFAULT 'ENTRADA',
  `categoria` varchar(40) NOT NULL DEFAULT 'OUTRO',
  `valor` decimal(10,2) NOT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  `ref_table` varchar(40) DEFAULT NULL,
  `ref_id` int DEFAULT NULL,
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('OK','PENDENTE','CANCELADO') NOT NULL DEFAULT 'OK',
  `conciliado_em` datetime DEFAULT NULL,
  `caixa_conciliado_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `caixa_lancamentos`
--

INSERT INTO `caixa_lancamentos` (`id`, `caixa_id`, `usuario_id`, `tipo`, `categoria`, `valor`, `descricao`, `ref_table`, `ref_id`, `criado_em`, `status`, `conciliado_em`, `caixa_conciliado_id`) VALUES
(1, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '15.00', 'Pagamento fatura • conta #204 • sessão 9eb2578b1955 • método PIX', 'pagamentos', 126, '2026-01-25 19:19:58', 'OK', NULL, NULL),
(2, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '11.00', 'Pagamento fatura • conta #204 • sessão 9eb2578b1955 • método PIX', 'pagamentos', 127, '2026-01-25 19:20:16', 'OK', NULL, NULL),
(3, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '80.00', 'Pagamento fatura • conta #204 • sessão 9eb2578b1955 • método PIX', 'pagamentos', 128, '2026-01-25 19:21:42', 'OK', NULL, NULL),
(4, 2, NULL, 'ENTRADA', 'RECARGA_CARTAO', '1000.00', 'Recarga cartão 12345', 'cartao_movimentos', 165, '2026-01-25 20:10:01', 'OK', NULL, NULL),
(5, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '4.00', 'Pagamento fatura • conta #205 • sessão 772c087f4467 • método PIX', 'pagamentos', 129, '2026-01-25 21:58:20', 'OK', NULL, NULL),
(6, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '21.00', 'Pagamento fatura • conta #205 • sessão 772c087f4467 • método PIX', 'pagamentos', 130, '2026-01-25 21:58:47', 'OK', NULL, NULL),
(7, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '49.00', 'Pagamento fatura • conta #205 • sessão 772c087f4467 • método PIX', 'pagamentos', 131, '2026-01-25 22:16:00', 'OK', NULL, NULL),
(8, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '53.00', 'Pagamento fatura • conta #205 • sessão 772c087f4467 • método PIX', 'pagamentos', 132, '2026-01-25 22:16:44', 'OK', NULL, NULL),
(9, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '52.00', 'Pagamento fatura • conta #206 • sessão a66e7d27cb1f • método PIX', 'pagamentos', 133, '2026-01-25 22:19:37', 'OK', NULL, NULL),
(10, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '31.00', 'Pagamento fatura • conta #207 • sessão a876c0603c6a • método DINHEIRO', 'pagamentos', 134, '2026-01-26 08:49:54', 'OK', NULL, NULL),
(11, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '70.00', 'Pagamento fatura • conta #207 • sessão a876c0603c6a • método DINHEIRO', 'pagamentos', 137, '2026-01-26 09:22:32', 'OK', NULL, NULL),
(12, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '100.00', 'Pagamento fatura • conta #207 • sessão a876c0603c6a • método DINHEIRO', 'pagamentos', 138, '2026-01-26 13:12:49', 'OK', NULL, NULL),
(13, 2, 1, 'SAIDA', 'TROCO', '40.00', 'Troco do pagamento em dinheiro • conta #207 • sessão a876c0603c6a', 'pagamentos', 138, '2026-01-26 13:12:49', 'OK', NULL, NULL),
(14, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '50.00', 'Pagamento fatura • conta #207 • sessão a876c0603c6a • método DINHEIRO', 'pagamentos', 139, '2026-01-26 13:47:09', 'OK', NULL, NULL),
(15, 2, 1, 'SAIDA', 'TROCO', '5.00', 'Troco do pagamento em dinheiro • conta #207 • sessão a876c0603c6a', 'pagamentos', 139, '2026-01-26 13:47:09', 'OK', NULL, NULL),
(16, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '100.00', 'Recarga cartão 12345', 'cartao_movimentos', 169, '2026-01-28 18:55:50', 'OK', NULL, NULL),
(17, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '100.00', 'Recarga cartão 6156027574236', 'cartao_movimentos', 171, '2026-01-28 19:41:12', 'OK', NULL, NULL),
(18, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '1.00', 'Recarga cartão 0738030849711', 'cartao_movimentos', 172, '2026-01-28 19:44:32', 'OK', NULL, NULL),
(19, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '1.00', 'Recarga cartão PKGKR12345abcdeg', 'cartao_movimentos', 173, '2026-01-28 19:44:55', 'OK', NULL, NULL),
(20, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '1.00', 'Recarga cartão 12345', 'cartao_movimentos', 174, '2026-01-28 19:45:26', 'OK', NULL, NULL),
(21, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '82.00', 'Pagamento fatura • conta #208 • sessão 6bae57877604 • método PIX', 'pagamentos', 140, '2026-01-28 19:56:51', 'OK', NULL, NULL),
(22, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '100.00', 'Recarga cartão 12345', 'cartao_movimentos', 175, '2026-01-28 20:04:05', 'OK', NULL, NULL),
(23, 2, 1, 'SAIDA', 'ESTORNO_CARTAO', '23.00', 'Devolução saldo cartão 12345 (PIX)', 'cartao_movimentos', 178, '2026-01-28 20:06:39', 'OK', NULL, NULL),
(24, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '50.00', 'Pagamento fatura • conta #210 • sessão c4f09bc7f9a7 • método DINHEIRO', 'pagamentos', 141, '2026-01-29 19:36:17', 'OK', NULL, NULL),
(25, 2, 1, 'SAIDA', 'TROCO', '20.00', 'Troco do pagamento em dinheiro • conta #210 • sessão c4f09bc7f9a7', 'pagamentos', 141, '2026-01-29 19:36:18', 'OK', NULL, NULL),
(26, 2, 3, 'ENTRADA', 'PAGAMENTO_FATURA', '50.00', 'Pagamento fatura • conta #211 • sessão 690ccb30a748 • método DINHEIRO', 'pagamentos', 142, '2026-01-29 23:14:09', 'OK', NULL, NULL),
(27, 2, 3, 'SAIDA', 'TROCO', '18.00', 'Troco do pagamento em dinheiro • conta #211 • sessão 690ccb30a748', 'pagamentos', 142, '2026-01-29 23:14:09', 'OK', NULL, NULL),
(28, 2, 3, 'ENTRADA', 'PAGAMENTO_FATURA', '50.00', 'Pagamento fatura • conta #211 • sessão 690ccb30a748 • método DINHEIRO', 'pagamentos', 143, '2026-01-29 23:19:13', 'OK', NULL, NULL),
(29, 2, 3, 'SAIDA', 'TROCO', '13.00', 'Troco do pagamento em dinheiro • conta #211 • sessão 690ccb30a748', 'pagamentos', 143, '2026-01-29 23:19:13', 'OK', NULL, NULL),
(30, 2, 3, 'ENTRADA', 'PAGAMENTO_FATURA', '70.00', 'Pagamento fatura • conta #211 • sessão 690ccb30a748 • método DINHEIRO', 'pagamentos', 144, '2026-01-29 23:20:57', 'OK', NULL, NULL),
(31, 2, 3, 'SAIDA', 'TROCO', '10.00', 'Troco do pagamento em dinheiro • conta #211 • sessão 690ccb30a748', 'pagamentos', 144, '2026-01-29 23:20:57', 'OK', NULL, NULL),
(32, 2, 3, 'ENTRADA', 'PAGAMENTO_FATURA', '50.00', 'Pagamento fatura • conta #211 • sessão 690ccb30a748 • método DINHEIRO', 'pagamentos', 145, '2026-01-29 23:23:02', 'OK', NULL, NULL),
(33, 2, 3, 'SAIDA', 'TROCO', '4.00', 'Troco do pagamento em dinheiro • conta #211 • sessão 690ccb30a748', 'pagamentos', 145, '2026-01-29 23:23:02', 'OK', NULL, NULL),
(34, 2, 3, 'ENTRADA', 'PAGAMENTO_FATURA', '120.00', 'Pagamento fatura • conta #211 • sessão 690ccb30a748 • método DINHEIRO', 'pagamentos', 146, '2026-01-29 23:24:35', 'OK', NULL, NULL),
(35, 2, 3, 'SAIDA', 'TROCO', '20.00', 'Troco do pagamento em dinheiro • conta #211 • sessão 690ccb30a748', 'pagamentos', 146, '2026-01-29 23:24:35', 'OK', NULL, NULL),
(36, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '76.00', 'Pagamento fatura • conta #212 • sessão f41f06fb6fb3 • método PIX', 'pagamentos', 147, '2026-01-30 21:28:22', 'OK', NULL, NULL),
(37, 2, 1, 'ENTRADA', 'RECARGA_CARTAO', '100.00', 'Recarga cartão 12345', 'cartao_movimentos', 179, '2026-01-30 21:30:37', 'OK', NULL, NULL),
(38, 2, NULL, 'ENTRADA', 'PAGAMENTO_FATURA', '70.00', 'Pagamento fatura • conta #213 • sessão 88142df75640 • método PIX', 'pagamentos', 148, '2026-02-02 09:48:11', 'OK', NULL, NULL),
(39, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '70.00', 'Pagamento fatura • conta #214 • sessão d0fbf454488c • método PIX', 'pagamentos', 149, '2026-02-02 09:50:54', 'OK', NULL, NULL),
(40, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '26.00', 'Pagamento fatura • conta #215 • sessão 04dda86eed49 • método PIX', 'pagamentos', 150, '2026-02-02 14:11:04', 'OK', NULL, NULL),
(41, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '32.00', 'Pagamento fatura • conta #216 • sessão 529fe94b8257 • método PIX', 'pagamentos', 151, '2026-02-02 21:12:38', 'OK', NULL, NULL),
(42, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '70.00', 'Pagamento fatura • conta #217 • sessão 07dd332e2fbb • método PIX', 'pagamentos', 152, '2026-02-02 23:03:33', 'OK', NULL, NULL),
(43, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '24.00', 'Pagamento fatura • conta #218 • sessão d27a2fd0ee61 • método PIX', 'pagamentos', 153, '2026-02-03 08:14:49', 'OK', NULL, NULL),
(44, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '30.00', 'Pagamento fatura • conta #221 • sessão 113d9d4054e0 • método DINHEIRO', 'pagamentos', 154, '2026-02-03 10:40:41', 'OK', NULL, NULL),
(45, 2, 1, 'SAIDA', 'TROCO', '6.00', 'Troco do pagamento em dinheiro • conta #221 • sessão 113d9d4054e0', 'pagamentos', 154, '2026-02-03 10:40:41', 'OK', NULL, NULL),
(46, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '51.00', 'Pagamento fatura • conta #223 • sessão d7498419bf7a • método PIX', 'pagamentos', 155, '2026-02-03 13:04:55', 'OK', NULL, NULL),
(47, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '64.00', 'Pagamento fatura • conta #228 • sessão 873757699ec4 • método PIX', 'pagamentos', 156, '2026-02-03 14:20:53', 'OK', NULL, NULL),
(48, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '37.00', 'Pagamento fatura • conta #229 • sessão 5f6f49726a15 • método PIX', 'pagamentos', 157, '2026-02-03 15:15:59', 'OK', NULL, NULL),
(49, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '46.00', 'Pagamento fatura • conta #229 • sessão 99fdcddb886b • método PIX', 'pagamentos', 158, '2026-02-03 15:16:02', 'OK', NULL, NULL),
(50, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '80.00', 'Pagamento fatura • conta #230 • sessão 73f87c612e06 • método PIX', 'pagamentos', 159, '2026-02-03 15:25:30', 'OK', NULL, NULL),
(51, 2, 1, 'ENTRADA', 'PAGAMENTO_FATURA', '26.00', 'Pagamento fatura • conta #231 • sessão 3449073a7b41 • método PIX', 'pagamentos', 160, '2026-02-03 15:25:36', 'OK', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura para tabela `caixa_movimentos`
--

CREATE TABLE `caixa_movimentos` (
  `id` int NOT NULL,
  `caixa_id` int NOT NULL,
  `tipo` enum('ENTRADA','SAIDA') NOT NULL,
  `origem` enum('RECARGA','FATURA','SANGRIA','SUPRIMENTO','AJUSTE') NOT NULL,
  `forma_pagamento` enum('DINHEIRO','PIX','DEBITO','CREDITO') NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  `criado_em` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cartao_movimentos`
--

CREATE TABLE `cartao_movimentos` (
  `id` int NOT NULL,
  `cartao_id` int NOT NULL,
  `ref_mov_id` int DEFAULT NULL,
  `operacao` enum('C','D','E') NOT NULL,
  `motivo` varchar(40) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `origem` enum('BALCAO','GARCOM','SISTEMA') NOT NULL DEFAULT 'SISTEMA',
  `observacao` varchar(255) DEFAULT NULL,
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `cartao_movimentos`
--

INSERT INTO `cartao_movimentos` (`id`, `cartao_id`, `ref_mov_id`, `operacao`, `motivo`, `valor`, `origem`, `observacao`, `criado_em`) VALUES
(1, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', 'Recarga no balcão', '2026-01-18 17:00:44'),
(2, 1, NULL, 'D', 'DEBITO', '12.50', 'GARCOM', 'teste', '2026-01-18 17:02:36'),
(3, 1, NULL, 'D', 'DEBITO', '25.00', 'GARCOM', 'teste', '2026-01-18 17:07:36'),
(4, 1, NULL, 'D', 'DEBITO', '0.01', 'GARCOM', 'teste', '2026-01-18 17:08:08'),
(5, 1, NULL, 'C', 'RECARGA', '0.01', 'BALCAO', 'Recarga no balcão', '2026-01-18 17:09:01'),
(6, 1, NULL, 'D', 'ZERAMENTO', '62.50', 'BALCAO', 'Zeramento', '2026-01-18 18:00:39'),
(7, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 00:48:02'),
(8, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 10:44:13'),
(9, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 10:44:55'),
(10, 1, 9, 'D', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-19 10:46:08'),
(11, 1, NULL, 'C', 'RECARGA', '5.00', 'BALCAO', NULL, '2026-01-19 10:48:39'),
(12, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 11:08:11'),
(13, 1, NULL, 'D', 'FECHAMENTO', '50.00', 'BALCAO', 'Zerado no fechamento do cartão', '2026-01-19 11:08:29'),
(14, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 11:08:56'),
(15, 1, NULL, 'D', 'FECHAMENTO', '100.00', 'BALCAO', 'Zerado no fechamento do cartão', '2026-01-19 11:09:13'),
(16, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 11:09:37'),
(17, 1, NULL, 'D', 'FECHAMENTO', '100.00', 'BALCAO', 'Zerado no fechamento do cartão', '2026-01-19 11:10:32'),
(18, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', 'teste', '2026-01-19 18:05:34'),
(19, 3, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', 'teste', '2026-01-19 18:07:21'),
(20, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-19 18:16:03'),
(21, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 18:26:56'),
(22, 3, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 18:29:22'),
(23, 3, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 18:46:41'),
(24, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-19 18:57:34'),
(25, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 18:58:13'),
(26, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 19:14:36'),
(27, 3, NULL, 'C', 'RECARGA', '1000.00', 'BALCAO', NULL, '2026-01-19 19:22:55'),
(28, 3, NULL, 'D', 'TRANSFERENCIA', '1000.00', 'BALCAO', 'Para cartão 12345', '2026-01-19 19:23:43'),
(29, 1, NULL, 'C', 'TRANSFERENCIA', '1000.00', 'BALCAO', 'De cartão C000003', '2026-01-19 19:23:43'),
(30, 1, NULL, 'D', 'CONSUMO', '350.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:29:36'),
(31, 1, 30, 'C', 'ESTORNO', '350.00', 'BALCAO', NULL, '2026-01-19 19:29:54'),
(32, 1, NULL, 'D', 'CONSUMO', '24.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:30:22'),
(33, 1, NULL, 'D', 'CONSUMO', '35.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:30:31'),
(34, 1, NULL, 'D', 'CONSUMO', '60.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:30:41'),
(35, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 19:43:37'),
(36, 1, NULL, 'D', 'CONSUMO', '35.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:43:55'),
(37, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 19:45:40'),
(38, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-19 19:57:38'),
(39, 1, NULL, 'D', 'CONSUMO', '35.00', 'SISTEMA', 'Débito simulado (SQL)', '2026-01-19 19:59:30'),
(40, 1, 39, 'C', 'ESTORNO', '35.00', 'BALCAO', NULL, '2026-01-19 20:02:04'),
(41, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-19 22:59:50'),
(42, 1, NULL, 'D', 'CONSUMO', '5.00', 'GARCOM', NULL, '2026-01-19 23:00:05'),
(43, 1, NULL, 'D', 'CONSUMO', '23.60', 'GARCOM', NULL, '2026-01-19 23:01:41'),
(44, 1, 42, 'C', 'ESTORNO', '5.00', 'BALCAO', NULL, '2026-01-19 23:02:13'),
(45, 1, 43, 'C', 'ESTORNO', '23.60', 'BALCAO', NULL, '2026-01-19 23:03:02'),
(46, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-19 23:03:31'),
(47, 1, 46, 'C', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-19 23:03:45'),
(48, 1, NULL, 'D', 'CONSUMO', '5.00', 'GARCOM', NULL, '2026-01-19 23:04:03'),
(49, 1, 48, 'C', 'ESTORNO', '5.00', 'BALCAO', NULL, '2026-01-19 23:04:18'),
(50, 1, NULL, 'D', 'CONSUMO', '45.00', 'GARCOM', NULL, '2026-01-19 23:04:29'),
(51, 1, 50, 'C', 'ESTORNO', '45.00', 'BALCAO', NULL, '2026-01-19 23:04:50'),
(52, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-20 00:03:06'),
(53, 1, NULL, 'D', 'CONSUMO', '5.00', 'GARCOM', NULL, '2026-01-20 00:03:58'),
(54, 1, NULL, 'D', 'CONSUMO', '15.00', 'GARCOM', NULL, '2026-01-20 00:04:08'),
(55, 1, NULL, 'D', 'CONSUMO', '24.90', 'GARCOM', NULL, '2026-01-20 00:05:25'),
(56, 1, NULL, 'D', 'CONSUMO', '5.10', 'GARCOM', NULL, '2026-01-20 00:05:49'),
(57, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 00:14:07'),
(58, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-20 00:15:11'),
(59, 1, NULL, 'D', 'CONSUMO', '45.00', 'GARCOM', NULL, '2026-01-20 00:15:31'),
(60, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-20 00:15:52'),
(61, 1, NULL, 'D', 'CONSUMO', '9.00', 'GARCOM', NULL, '2026-01-20 00:16:05'),
(62, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 00:46:34'),
(63, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-20 00:48:13'),
(64, 1, 63, 'C', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-20 00:48:24'),
(65, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 00:49:09'),
(66, 1, 65, 'C', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 00:49:27'),
(67, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 00:49:45'),
(68, 1, NULL, 'D', 'CONSUMO', '7.00', 'GARCOM', NULL, '2026-01-20 00:50:15'),
(69, 1, 67, 'C', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 00:50:31'),
(70, 1, 68, 'C', 'ESTORNO', '7.00', 'BALCAO', NULL, '2026-01-20 00:50:49'),
(71, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 00:51:43'),
(72, 1, NULL, 'D', 'CONSUMO', '35.00', 'GARCOM', NULL, '2026-01-20 00:51:53'),
(73, 1, 71, 'C', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 00:52:07'),
(74, 1, 72, 'C', 'ESTORNO', '35.00', 'BALCAO', NULL, '2026-01-20 00:52:11'),
(75, 1, NULL, 'D', 'CONSUMO', '12.00', 'GARCOM', NULL, '2026-01-20 00:52:25'),
(76, 1, NULL, 'D', 'CONSUMO', '12.00', 'GARCOM', 'agua', '2026-01-20 01:28:11'),
(77, 1, 75, 'C', 'ESTORNO', '12.00', 'BALCAO', NULL, '2026-01-20 01:30:15'),
(78, 1, 76, 'C', 'ESTORNO', '12.00', 'BALCAO', NULL, '2026-01-20 01:30:22'),
(79, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 01:30:38'),
(80, 1, 79, 'C', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 01:30:49'),
(81, 4, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 10:50:41'),
(82, 4, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', 'Cerveja', '2026-01-20 10:51:54'),
(83, 4, NULL, 'D', 'CONSUMO', '15.00', 'GARCOM', NULL, '2026-01-20 10:52:57'),
(84, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 16:35:21'),
(85, 1, NULL, 'D', 'CONSUMO', '5.40', 'GARCOM', NULL, '2026-01-20 16:49:38'),
(86, 1, NULL, 'D', 'CONSUMO', '60.00', 'GARCOM', 'PORÇÃO PEIXE', '2026-01-20 16:50:08'),
(87, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', 'CERVEJA', '2026-01-20 16:51:38'),
(88, 1, NULL, 'D', 'REFRIGERANTE', '7.00', 'GARCOM', NULL, '2026-01-20 16:52:09'),
(89, 1, 88, 'C', 'ESTORNO', '7.00', 'BALCAO', NULL, '2026-01-20 16:52:32'),
(90, 1, NULL, 'D', 'REFRIGERANTE', '24.60', 'GARCOM', NULL, '2026-01-20 16:53:42'),
(91, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-20 17:06:36'),
(93, 1, 92, 'E', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-20 17:07:56'),
(94, 1, NULL, 'D', 'PORÇÃO', '60.00', 'GARCOM', NULL, '2026-01-20 17:29:49'),
(95, 1, NULL, 'D', 'PORÇÃO', '10.00', 'GARCOM', NULL, '2026-01-20 17:32:19'),
(96, 1, 95, 'E', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-20 17:32:54'),
(97, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 17:33:39'),
(98, 1, 97, 'E', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 17:33:58'),
(99, 1, NULL, 'D', 'CONSUMO', '110.00', 'GARCOM', NULL, '2026-01-20 17:34:19'),
(100, 1, NULL, 'D', 'CONSUMO', '30.00', 'GARCOM', NULL, '2026-01-20 17:34:28'),
(101, 1, NULL, 'D', 'CONSUMO', '12.00', 'GARCOM', NULL, '2026-01-20 17:34:41'),
(102, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-20 17:36:03'),
(103, 1, NULL, 'D', 'CONSUMO', '15.00', 'GARCOM', NULL, '2026-01-20 17:36:33'),
(104, 1, 103, 'E', 'ESTORNO', '15.00', 'BALCAO', NULL, '2026-01-20 17:36:45'),
(105, 1, NULL, 'D', 'CONSUMO', '35.00', 'GARCOM', NULL, '2026-01-20 17:38:00'),
(106, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-20 18:05:48'),
(107, 1, NULL, 'D', 'CONSUMO', '250.00', 'GARCOM', NULL, '2026-01-20 18:21:00'),
(108, 1, 107, 'E', 'ESTORNO', '250.00', 'BALCAO', NULL, '2026-01-20 18:21:18'),
(109, 1, NULL, 'D', 'CONSUMO', '500.00', 'GARCOM', NULL, '2026-01-20 18:21:59'),
(110, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-20 18:28:58'),
(111, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-20 18:29:15'),
(112, 1, 111, 'E', 'ESTORNO', '50.00', 'BALCAO', NULL, '2026-01-20 18:29:28'),
(113, 1, NULL, 'D', 'CONSUMO', '30.00', 'GARCOM', NULL, '2026-01-20 18:39:13'),
(114, 1, 113, 'E', 'ESTORNO', '30.00', 'BALCAO', NULL, '2026-01-20 18:39:26'),
(115, 1, NULL, 'D', 'CONSUMO', '400.00', 'GARCOM', NULL, '2026-01-20 18:39:58'),
(116, 1, NULL, 'D', 'CONSUMO', '32.00', 'GARCOM', NULL, '2026-01-20 18:40:12'),
(117, 1, 116, 'E', 'ESTORNO', '32.00', 'BALCAO', NULL, '2026-01-20 18:40:22'),
(118, 1, NULL, 'D', 'CONSUMO', '100.00', 'GARCOM', NULL, '2026-01-20 18:40:40'),
(119, 1, NULL, 'C', 'RECARGA', '120.00', 'BALCAO', NULL, '2026-01-20 18:44:43'),
(120, 1, NULL, 'D', 'CONSUMO', '60.50', 'GARCOM', NULL, '2026-01-20 18:45:31'),
(121, 1, NULL, 'D', 'CONSUMO', '35.00', 'GARCOM', NULL, '2026-01-20 19:00:17'),
(122, 1, NULL, 'D', 'CONSUMO', '24.50', 'GARCOM', NULL, '2026-01-20 19:00:46'),
(123, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 19:25:28'),
(124, 1, NULL, 'D', 'CONSUMO', '18.00', 'GARCOM', NULL, '2026-01-20 19:25:56'),
(125, 1, 124, 'E', 'ESTORNO', '18.00', 'BALCAO', NULL, '2026-01-20 19:27:30'),
(126, 1, NULL, 'D', 'CONSUMO', '25.00', 'GARCOM', NULL, '2026-01-20 19:27:47'),
(127, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-20 20:42:35'),
(128, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-20 20:42:57'),
(129, 1, NULL, 'C', 'RECARGA', '16.00', 'BALCAO', NULL, '2026-01-20 20:44:33'),
(130, 1, NULL, 'D', 'CONSUMO', '16.00', 'GARCOM', NULL, '2026-01-20 20:45:00'),
(131, 1, NULL, 'D', 'CONSUMO', '24.00', 'GARCOM', NULL, '2026-01-20 20:45:15'),
(132, 1, 128, 'E', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-20 20:46:27'),
(133, 1, NULL, 'C', 'RECARGA', '150.00', 'BALCAO', NULL, '2026-01-21 01:05:22'),
(134, 1, NULL, 'D', 'CONSUMO', '25.00', 'GARCOM', NULL, '2026-01-21 01:06:42'),
(135, 1, NULL, 'D', 'CONSUMO', '12.00', 'GARCOM', NULL, '2026-01-21 01:08:29'),
(136, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-21 01:08:42'),
(137, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-21 14:26:37'),
(138, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-21 17:34:25'),
(139, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-21 19:04:08'),
(140, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-21 19:14:05'),
(141, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-21 19:48:20'),
(142, 1, NULL, 'C', 'RECARGA', '1000.00', 'BALCAO', NULL, '2026-01-21 20:20:12'),
(143, 1, NULL, 'C', 'RECARGA', '15.00', 'BALCAO', NULL, '2026-01-23 13:40:24'),
(144, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-23 14:00:22'),
(145, 1, NULL, 'C', 'RECARGA', '50.00', 'BALCAO', NULL, '2026-01-23 17:17:38'),
(146, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-23 14:41:44'),
(147, 1, 146, 'E', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-23 14:51:56'),
(148, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-23 14:53:38'),
(149, 1, NULL, 'D', 'CONSUMO', '43.00', 'GARCOM', NULL, '2026-01-23 14:53:50'),
(150, 5, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-23 14:55:33'),
(151, 5, NULL, 'D', 'CONSUMO', '47.00', 'GARCOM', NULL, '2026-01-23 14:55:49'),
(152, 5, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-23 15:07:38'),
(153, 5, NULL, 'D', 'CONSUMO', '40.00', 'GARCOM', NULL, '2026-01-23 15:08:01'),
(154, 6, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-23 17:02:52'),
(155, 1, NULL, 'C', 'RECARGA', '500.00', 'BALCAO', NULL, '2026-01-23 19:47:20'),
(156, 1, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-23 19:47:38'),
(157, 1, NULL, 'D', 'CONSUMO', '32.00', 'GARCOM', NULL, '2026-01-23 19:47:56'),
(158, 1, NULL, 'D', 'CONSUMO', '18.00', 'GARCOM', NULL, '2026-01-23 19:48:12'),
(159, 1, 157, 'E', 'ESTORNO', '32.00', 'BALCAO', NULL, '2026-01-23 19:48:27'),
(160, 1, NULL, 'C', 'RECARGA', '1000.00', 'BALCAO', NULL, '2026-01-23 22:30:35'),
(161, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-23 22:31:54'),
(162, 1, NULL, 'D', 'CONSUMO', '123.00', 'GARCOM', NULL, '2026-01-23 22:32:01'),
(163, 1, 162, 'E', 'ESTORNO', '123.00', 'BALCAO', NULL, '2026-01-23 22:32:52'),
(164, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-25 20:03:26'),
(165, 1, NULL, 'C', 'RECARGA', '1000.00', 'BALCAO', NULL, '2026-01-25 20:10:01'),
(166, 1, NULL, 'D', 'CONSUMO', '10.00', 'GARCOM', NULL, '2026-01-25 22:13:22'),
(167, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-25 22:14:13'),
(168, 1, 166, 'E', 'ESTORNO', '10.00', 'BALCAO', NULL, '2026-01-25 22:14:36'),
(169, 8, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-28 18:55:50'),
(170, 8, NULL, 'D', 'CONSUMO', '50.00', 'GARCOM', NULL, '2026-01-28 19:26:02'),
(171, 6, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-28 19:41:12'),
(172, 7, NULL, 'C', 'RECARGA', '1.00', 'BALCAO', NULL, '2026-01-28 19:44:32'),
(173, 4, NULL, 'C', 'RECARGA', '1.00', 'BALCAO', NULL, '2026-01-28 19:44:55'),
(174, 1, NULL, 'C', 'RECARGA', '1.00', 'BALCAO', NULL, '2026-01-28 19:45:26'),
(175, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-28 20:04:04'),
(176, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-28 20:05:29'),
(177, 1, NULL, 'D', 'CONSUMO', '41.00', 'GARCOM', NULL, '2026-01-28 20:05:41'),
(178, 1, NULL, 'D', 'DEVOLUCAO_SALDO', '23.00', 'BALCAO', 'Devolução de saldo no fechamento (PIX)', '2026-01-28 20:06:39'),
(179, 1, NULL, 'C', 'RECARGA', '100.00', 'BALCAO', NULL, '2026-01-30 21:30:37'),
(180, 1, NULL, 'D', 'CONSUMO', '36.00', 'GARCOM', NULL, '2026-01-30 21:31:24');

-- --------------------------------------------------------

--
-- Estrutura para tabela `cartoes`
--

CREATE TABLE `cartoes` (
  `id` int NOT NULL,
  `codigo` varchar(20) NOT NULL,
  `status` enum('LIVRE','EM_USO','BLOQUEADO') NOT NULL DEFAULT 'LIVRE',
  `nome` varchar(120) DEFAULT NULL,
  `celular` varchar(40) DEFAULT NULL,
  `mesa` int DEFAULT NULL,
  `aberto_em` datetime DEFAULT NULL,
  `fechado_em` datetime DEFAULT NULL,
  `atualizado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `cartoes`
--

INSERT INTO `cartoes` (`id`, `codigo`, `status`, `nome`, `celular`, `mesa`, `aberto_em`, `fechado_em`) VALUES
(1, '12345', 'EM_USO', 'João Paulo', '3599999999959', NULL, '2026-01-30 21:30:37', NULL),
(3, 'C000003', 'LIVRE', 'TESTE', '359999999', NULL, '2026-01-19 19:22:55', '2026-01-19 19:23:43'),
(4, 'PKGKR12345abcdeg', 'LIVRE', 'jp', '35999994999', NULL, '2026-01-28 19:44:55', '2026-01-28 19:45:02'),
(5, '0014035776270', 'LIVRE', 'ANDRE', '35999999999', NULL, '2026-01-23 14:55:33', '2026-01-23 15:08:41'),
(6, '6156027574236', 'LIVRE', 'jp', '35999994999', NULL, '2026-01-28 19:41:12', '2026-01-28 19:44:10'),
(7, '0738030849711', 'LIVRE', 'jp', '35999994999', NULL, '2026-01-28 19:44:32', '2026-01-28 19:44:39'),
(8, '5222071833183', 'LIVRE', 'jpaulo', '35999994999', NULL, '2026-01-28 18:55:50', '2026-01-28 19:43:17'),
(9, '3896266924120', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(10, '3815119428387', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(11, '7386796676913', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(12, '5488625406742', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(13, '5282737310307', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(14, '9947810638646', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(15, '3890841569649', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(16, '9610776239642', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(17, '6381356796604', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(18, '3074455571429', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(19, '6228207774672', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(20, '1917672466409', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(21, '0903739315367', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(22, '8765679484945', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(23, '1117179785964', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(24, '9288860782317', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(25, '3092764861036', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(26, '7597242265563', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(27, '8707917052048', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(28, '0747858770888', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(29, '7615543005629', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(30, '5834139022821', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(31, '6324066404554', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(32, '4117915261646', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(33, '1617377401904', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(34, '5733141531918', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(35, '3813575761218', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(36, '1868454517673', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(37, '7901545612049', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(38, '3902364814562', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(39, '5807187544001', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(40, '7328843583658', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(41, '9222655593624', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(42, '4126747524483', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(43, '2965771148880', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(44, '2448613478288', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(45, '3345754252137', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(46, '9382931133156', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(47, '6877393216711', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(48, '6238172991422', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(49, '0558685614316', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(50, '4078909404648', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(51, '8718490487632', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(52, '1355724531557', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(53, '0623151502220', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(54, '9048584223769', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(55, '3373466919523', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(56, '9721582233645', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(57, '8487510716995', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(58, '3272807191379', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(59, '0901504113247', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(60, '4689099299431', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(61, '0740984464754', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(62, '9637624732811', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(63, '5965170577135', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(64, '0912978994578', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(65, '6669383548822', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(66, '0607981067716', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(67, '3031754999450', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(68, '3334832101440', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(69, '7578895816186', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(70, '7889983083949', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(71, '6713228278525', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(72, '9896192448116', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(73, '9341277712341', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(74, '7017811524697', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(75, '7065224793799', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(76, '4272689702242', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(77, '0167774437151', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(78, '8020803386364', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(79, '9600693927704', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(80, '3941059786771', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(81, '0903217458075', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(82, '2692908237401', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(83, '0754889120119', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(84, '5695721195726', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(85, '6213938925613', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(86, '3982531348226', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(87, '1270840271628', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(88, '4406607620796', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(89, '8220517596434', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(90, '7882765427121', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(91, '4752274653643', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(92, '0113077294186', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(93, '6308562817338', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(94, '1203582511472', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(95, '7092224412682', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(96, '1850374836335', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(97, '7975201250961', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(98, '4324882053140', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(99, '7698806820156', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(100, '5519388248695', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(101, '4500521090347', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(102, '5944441012985', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(103, '6220642101224', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(104, '3269887774502', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(105, '7687512876174', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(106, '8627901364701', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(107, '0076968502324', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(108, '4501138724852', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(109, '2274788424628', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(110, '7870526255918', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(111, '2528266313046', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(112, '9029753104810', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(113, '7563966892252', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(114, '0730575454170', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(115, '0960976901427', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(116, '2613158451964', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(117, '0182861862874', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(118, '3074834265815', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(119, '4825586047791', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(120, '4903427748850', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(121, '0040380908213', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(122, '5491621601852', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(123, '7336965591959', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(124, '0209963461579', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(125, '9038920839352', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(126, '4564714119363', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(127, '5706808386096', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(128, '4839899879730', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(129, '7079074547699', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(130, '0875673406641', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(131, '3141143697445', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(132, '3078698574638', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(133, '5970062088192', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(134, '0614215024387', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(135, '5160889164693', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(136, '3961801057645', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(137, '4326338101481', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(138, '9746287641809', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(139, '5752424211941', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(140, '9523258441614', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(141, '0359019879586', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(142, '3225324380421', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(143, '5049562570684', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(144, '5571840019497', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(145, '2710512692770', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(146, '6837043712694', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(147, '6053680792500', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(148, '9757273131754', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(149, '0625323588610', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(150, '3854798855124', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(151, '7398023817126', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(152, '5425722827599', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(153, '4934542993953', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(154, '8395546794305', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(155, '7174105297004', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(156, '0683886409442', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(157, '1897116463535', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(158, '7433923396685', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(159, '1478267900159', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(160, '5089569618077', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(161, '1013044697244', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(162, '9796514939326', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(163, '5943440912238', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(164, '0327660050548', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(165, '3807977823361', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(166, '8056909272499', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(167, '8860613199751', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(168, '0132338488597', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(169, '4079853151067', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(170, '0002250596883', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(171, '7771693838546', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(172, '8851717709424', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(173, '0943507338821', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(174, '8162383873166', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(175, '7981397656705', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(176, '5419836971367', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(177, '3154992194058', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(178, '9515450363526', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(179, '8112275542795', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(180, '2015026930733', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(181, '5738308332616', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(182, '2646461178219', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(183, '6017381200582', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(184, '2147522775593', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(185, '2685470583555', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(186, '6984784898333', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(187, '6867513048338', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(188, '3383210854030', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(189, '6313515432470', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(190, '1417944907599', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(191, '8149178547922', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(192, '6492058324153', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(193, '8012756284337', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(194, '0587606756563', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(195, '8899765237140', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(196, '2736006223350', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(197, '6980735712666', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(198, '6695660200617', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(199, '2536094172425', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(200, '2593490567610', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(201, '5359170628114', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(202, '9015381745076', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(203, '8999397148376', 'LIVRE', NULL, NULL, NULL, NULL, NULL),
(204, '7950840813992', 'LIVRE', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura para tabela `chamados_garcom`
--

CREATE TABLE `chamados_garcom` (
  `id` int NOT NULL,
  `mesa` int NOT NULL,
  `conta_id` int NOT NULL,
  `cliente_id` int NOT NULL,
  `sessao_key` varchar(20) NOT NULL,
  `status` enum('ABERTO','ATENDIDO') NOT NULL DEFAULT 'ABERTO',
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `atendido_em` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `chamados_garcom`
--

INSERT INTO `chamados_garcom` (`id`, `mesa`, `conta_id`, `cliente_id`, `sessao_key`, `status`, `criado_em`, `atendido_em`) VALUES
(1, 1, 166, 22, '1d0638b85dc0', 'ATENDIDO', '2026-01-23 16:19:07', '2026-01-24 11:22:14'),
(2, 1, 169, 28, '978952359279', 'ATENDIDO', '2026-01-23 16:48:52', '2026-01-24 11:22:15'),
(3, 1, 169, 28, '978952359279', 'ATENDIDO', '2026-01-23 16:48:58', '2026-01-24 11:22:16'),
(4, 1, 173, 33, '5686cb387d6b', 'ATENDIDO', '2026-01-23 20:01:16', '2026-01-24 11:22:18'),
(5, 1, 173, 33, '5686cb387d6b', 'ATENDIDO', '2026-01-23 20:01:29', '2026-01-24 11:22:19'),
(6, 1, 173, 33, '5686cb387d6b', 'ATENDIDO', '2026-01-23 20:19:22', '2026-01-24 11:22:20'),
(7, 1, 173, 33, '5686cb387d6b', 'ATENDIDO', '2026-01-23 20:19:48', '2026-01-24 11:22:21'),
(8, 1, 173, 33, '5686cb387d6b', 'ATENDIDO', '2026-01-23 20:28:20', '2026-01-24 11:22:22'),
(9, 1, 174, 34, '55e0eb81272a', 'ATENDIDO', '2026-01-23 20:32:23', '2026-01-24 11:22:33'),
(10, 1, 177, 37, '6fd0f403a37e', 'ATENDIDO', '2026-01-23 21:33:24', '2026-01-24 11:22:32'),
(11, 1, 178, 38, '054afcfdf500', 'ATENDIDO', '2026-01-23 21:57:00', '2026-01-24 11:22:32'),
(12, 1, 178, 38, '054afcfdf500', 'ATENDIDO', '2026-01-23 22:16:35', '2026-01-24 11:22:31'),
(13, 1, 179, 39, '1f88a276934d', 'ATENDIDO', '2026-01-23 22:24:28', '2026-01-24 11:22:30'),
(14, 1, 188, 52, '7afb2c13b60c', 'ATENDIDO', '2026-01-24 09:46:42', '2026-01-24 11:22:30'),
(15, 1, 195, 61, '971db26a1d96', 'ATENDIDO', '2026-01-24 10:56:51', '2026-01-24 11:22:29'),
(16, 1, 195, 61, '971db26a1d96', 'ATENDIDO', '2026-01-24 10:56:54', '2026-01-24 11:22:28'),
(17, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:00:21', '2026-01-24 11:22:27'),
(18, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:22:42', '2026-01-24 11:22:50'),
(19, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:22:53', '2026-01-24 11:23:07'),
(20, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:22:55', '2026-01-24 11:23:09'),
(21, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:24:29', '2026-01-24 11:24:38'),
(22, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:45:19', '2026-01-24 11:45:41'),
(23, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:45:27', '2026-01-24 11:45:39'),
(24, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:45:29', '2026-01-24 11:45:38'),
(25, 1, 197, 63, '68a4d32a6031', 'ATENDIDO', '2026-01-24 11:45:31', '2026-01-24 11:45:37'),
(26, 1, 198, 65, 'c88016ef0f94', 'ATENDIDO', '2026-01-24 13:25:42', '2026-01-24 13:25:48'),
(27, 1, 198, 65, 'c88016ef0f94', 'ATENDIDO', '2026-01-24 14:01:15', '2026-01-24 14:01:21'),
(28, 1, 210, 81, 'c4f09bc7f9a7', 'ATENDIDO', '2026-01-29 19:33:24', '2026-01-29 19:33:40'),
(29, 1, 210, 81, 'c4f09bc7f9a7', 'ATENDIDO', '2026-01-29 19:34:47', '2026-01-29 19:34:56'),
(30, 1, 210, 81, 'c4f09bc7f9a7', 'ATENDIDO', '2026-01-29 19:37:28', '2026-01-29 23:13:43'),
(31, 1, 214, 87, 'd0fbf454488c', 'ATENDIDO', '2026-02-02 09:50:15', '2026-02-02 09:50:41'),
(32, 2, 220, 93, '06a8d38b3757', 'ATENDIDO', '2026-02-03 09:43:44', '2026-02-03 09:43:49'),
(33, 1, 222, 95, '0615f686d1ea', 'ATENDIDO', '2026-02-03 12:23:31', '2026-02-03 12:23:42');

-- --------------------------------------------------------

--
-- Estrutura para tabela `clientes`
--

CREATE TABLE `clientes` (
  `id` int NOT NULL,
  `nome` varchar(120) NOT NULL,
  `celular` varchar(20) NOT NULL,
  `criado_em` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `clientes`
--

INSERT INTO `clientes` (`id`, `nome`, `celular`, `criado_em`) VALUES
(1, 'JPAULOAM', '35999991111', '2026-01-23 13:15:41'),
(3, 'TESTE', '35999999999', '2026-01-23 13:17:23'),
(5, 'JPAULO', '35999999999', '2026-01-23 13:19:33'),
(6, 'TESTE', '35999999999', '2026-01-23 13:19:56'),
(7, 'TESTE', '35999999999', '2026-01-23 13:22:15'),
(8, 'PEDRO', '35998807210', '2026-01-23 16:16:07'),
(9, 'MARCIA', '35999223887', '2026-01-23 16:53:21'),
(10, 'MARCIA', '35999223887', '2026-01-23 16:59:40'),
(11, 'JPAULO', '35999999999', '2026-01-23 17:01:18'),
(12, 'MARCIA', '35999223887', '2026-01-23 17:02:37'),
(13, 'JPAULO', '35999999999', '2026-01-23 17:02:46'),
(14, 'Lopes', '35999223887', '2026-01-23 15:03:09'),
(15, 'Lopes', '35999223887', '2026-01-23 15:06:52'),
(16, 'jpaulo', '35999999999999999', '2026-01-23 15:20:50'),
(17, 'joao', '35992419749', '2026-01-23 15:25:09'),
(18, 'jpaulo', '3599999999999', '2026-01-23 15:26:09'),
(19, 'joao', '35992419749', '2026-01-23 15:28:38'),
(20, '<img src=x onerror=alert(1)>', '35992419749', '2026-01-23 15:45:34'),
(21, 'JPaulo', '3599999999992', '2026-01-23 16:03:59'),
(22, 'joao paulo', '35999999999', '2026-01-23 16:12:14'),
(23, 'Jpaulo', '3599999999765', '2026-01-23 16:13:49'),
(24, 'joao', '3599999995999', '2026-01-23 16:31:57'),
(25, 'Teste5', '3599988768', '2026-01-23 16:32:30'),
(26, 'joaopaulo', '35999992999', '2026-01-23 16:42:49'),
(27, 'Teste5', '359988877888', '2026-01-23 16:43:42'),
(28, 'joao', '359999999999', '2026-01-23 16:48:48'),
(29, 'joaopaulo', '3599999899', '2026-01-23 16:50:53'),
(30, 'joao paulo', '359999993232', '2026-01-23 16:52:54'),
(31, 'JOAO', '3599999999999', '2026-01-23 19:40:36'),
(32, 'jpaulo', '3599999999999', '2026-01-23 19:43:18'),
(33, 'jpaulo', '3599999999999', '2026-01-23 20:01:02'),
(34, 'JOAO', '3599999999999', '2026-01-23 20:30:33'),
(35, 'JOAO', '3599999999999', '2026-01-23 20:34:55'),
(36, 'JOAO', '3599999999999', '2026-01-23 21:15:54'),
(37, 'JOAO', '3599999999999', '2026-01-23 21:24:49'),
(38, 'JOAO', '3599999999999', '2026-01-23 21:49:40'),
(39, 'JOAO', '3599999999999', '2026-01-23 22:22:07'),
(40, 'teste', '3599999999999', '2026-01-23 22:26:12'),
(41, 'JOAO', '3599999999999', '2026-01-23 22:38:24'),
(42, 'jao', '35999999999', '2026-01-23 22:47:34'),
(43, 'JOAO', '3599999999999', '2026-01-23 22:51:29'),
(44, 'JOAO', '3599999999999', '2026-01-23 23:13:21'),
(45, 'JOAO', '3599999999999', '2026-01-23 23:22:28'),
(46, 'JOAO', '3599999999999', '2026-01-23 23:28:57'),
(47, 'João Paulo', '359999999999999', '2026-01-24 08:25:18'),
(48, 'joao', '3599999999999', '2026-01-24 08:45:04'),
(49, 'jpaulo', '359999999999', '2026-01-24 08:46:22'),
(50, 'JOAO', '3599999999999', '2026-01-24 09:29:47'),
(51, 'jpaulo', '35999994999', '2026-01-24 09:43:10'),
(52, 'jpaulo', '35999994999', '2026-01-24 09:46:29'),
(53, 'jpaulo', '35999994999', '2026-01-24 09:54:53'),
(54, 'jpaulo', '35999994999', '2026-01-24 10:14:09'),
(55, 'jpaulo', '35999994999', '2026-01-24 10:23:30'),
(56, 'jpaulo', '35999994999', '2026-01-24 10:25:51'),
(57, 'jpaulo', '35999994999', '2026-01-24 10:27:29'),
(58, 'jpaulo', '35999994999', '2026-01-24 10:30:38'),
(59, 'João Paulo', '35999999999999', '2026-01-24 10:39:01'),
(60, 'jpaulo', '35999994999', '2026-01-24 10:40:06'),
(61, 'jpaulo', '35999994999', '2026-01-24 10:42:37'),
(62, 'jpaulo', '35999994999', '2026-01-24 10:58:00'),
(63, 'jpaulo', '35999994999', '2026-01-24 10:59:59'),
(64, 'João', '35999999999999', '2026-01-24 11:18:54'),
(65, 'jpaulo', '35999994999', '2026-01-24 13:22:07'),
(66, 'jpaulo', '35999994999', '2026-01-24 14:24:19'),
(67, 'jpaulo', '35999994999', '2026-01-24 14:55:40'),
(68, 'jpaulo', '35999994999', '2026-01-24 15:21:43'),
(69, 'Jpaulo', '35999999999999', '2026-01-24 15:35:14'),
(70, 'jpaulo', '35999994999', '2026-01-24 15:56:04'),
(71, 'Jpaulo 2', '3698998887887', '2026-01-24 16:13:50'),
(72, 'jpaulo', '35999994999', '2026-01-25 14:21:32'),
(73, 'Jp', '3599999999939999', '2026-01-25 14:23:15'),
(74, 'jpaulo', '35999994999', '2026-01-25 18:55:26'),
(75, 'jpaulo', '35999994999', '2026-01-25 21:56:33'),
(76, 'jpaulo', '35999994999', '2026-01-25 22:18:52'),
(77, 'jpaulo', '35999994999', '2026-01-26 08:24:01'),
(78, 'João Paulo', '35999999999', '2026-01-26 17:53:22'),
(79, 'jpaulo', '359999994332', '2026-01-28 16:13:48'),
(80, 'jpaulo', '35999994999', '2026-01-29 00:19:06'),
(81, 'joao', '3588877899', '2026-01-29 19:33:05'),
(82, 'jp', '35999949990', '2026-01-29 23:13:02'),
(83, 'jpaulo', '35992698956', '2026-01-30 09:41:17'),
(84, 'Jpaulo', '359999999666', '2026-01-30 21:26:07'),
(85, 'joao', '3595959995', '2026-02-02 09:01:28'),
(86, 'Joao', '359999993999', '2026-02-02 09:47:17'),
(87, 'jpaulo', '359999399993', '2026-02-02 09:50:04'),
(88, 'Teste', '35999393999', '2026-02-02 09:51:59'),
(89, 'teste', '3599943949', '2026-02-02 14:28:32'),
(90, 'jpaulo', '359989565989', '2026-02-02 21:59:11'),
(91, 'jpaulo', '35956698565', '2026-02-03 08:05:49'),
(92, 'jp', '359532356565', '2026-02-03 08:15:27'),
(93, 'jpaulo', '35926565999', '2026-02-03 08:43:33'),
(94, 'jpaulo', '3599295959', '2026-02-03 10:01:05'),
(95, 'joao', '3598569856568', '2026-02-03 11:08:44'),
(96, 'joao', '35999959999', '2026-02-03 13:02:04'),
(97, 'Teste', '35999889987', '2026-02-03 13:03:08'),
(98, 'jpaulo', '35999988999', '2026-02-03 13:06:38'),
(99, 'teste', '3599999955999', '2026-02-03 13:38:22'),
(100, 'teste5', '359562986326', '2026-02-03 13:40:42'),
(101, 'teste2', '35985885555', '2026-02-03 14:19:23'),
(102, 'Jpaulo', '359999888998', '2026-02-03 14:59:40'),
(103, 'teste5', '35999988558', '2026-02-03 15:12:46'),
(104, 'TESTE04', '3599995298', '2026-02-03 15:19:50'),
(105, 'TESTE09', '3599995999', '2026-02-03 15:23:00'),
(106, 'Joao', '35998569852', '2026-02-03 19:16:10'),
(107, 'JOAO', '35956598535', '2026-02-03 19:21:12'),
(108, 'teste', '35988558555', '2026-02-03 19:23:01');

-- --------------------------------------------------------

--
-- Estrutura para tabela `contas`
--

CREATE TABLE `contas` (
  `id` int NOT NULL,
  `mesa` int DEFAULT NULL,
  `mesa_id` int NOT NULL,
  `status` enum('ABERTA','FECHADA') DEFAULT 'ABERTA',
  `criada_em` datetime DEFAULT CURRENT_TIMESTAMP,
  `fechada_em` datetime DEFAULT NULL,
  `aberta_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total_fatura` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_pago` decimal(10,2) NOT NULL DEFAULT '0.00',
  `liberada_em` datetime DEFAULT NULL,
  `liberada_por_staff_id` int DEFAULT NULL,
  `status_acesso` enum('LIVRE','PENDENTE','LIBERADA') NOT NULL DEFAULT 'PENDENTE',
  `liberada` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `contas`
--

INSERT INTO `contas` (`id`, `mesa`, `mesa_id`, `status`, `criada_em`, `fechada_em`, `aberta_em`, `total_fatura`, `total_pago`, `liberada_em`, `liberada_por_staff_id`, `status_acesso`, `liberada`) VALUES
(1, NULL, 1, 'FECHADA', '2026-01-14 13:19:11', '2026-01-14 16:10:37', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(2, NULL, 1, 'FECHADA', '2026-01-14 16:12:36', '2026-01-14 16:36:43', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(3, NULL, 1, 'FECHADA', '2026-01-14 16:37:01', '2026-01-14 16:40:17', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(4, NULL, 1, 'FECHADA', '2026-01-14 16:55:56', '2026-01-14 16:58:27', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(5, NULL, 1, 'FECHADA', '2026-01-14 16:58:30', '2026-01-14 17:01:36', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(6, NULL, 1, 'FECHADA', '2026-01-14 17:01:39', '2026-01-14 17:05:44', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(7, NULL, 1, 'FECHADA', '2026-01-14 17:07:55', '2026-01-14 17:15:06', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(8, NULL, 1, 'FECHADA', '2026-01-14 17:16:14', '2026-01-14 17:18:20', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(9, NULL, 2, 'FECHADA', '2026-01-14 17:28:10', '2026-01-14 17:28:48', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(10, NULL, 1, 'FECHADA', '2026-01-14 17:30:24', '2026-01-14 17:35:27', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(11, NULL, 2, 'FECHADA', '2026-01-14 17:33:09', '2026-01-14 17:35:39', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(12, NULL, 1, 'FECHADA', '2026-01-14 17:47:19', '2026-01-14 17:49:28', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(13, NULL, 1, 'FECHADA', '2026-01-14 17:51:50', '2026-01-14 17:55:33', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(14, NULL, 1, 'FECHADA', '2026-01-14 17:55:56', '2026-01-14 17:57:55', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(15, NULL, 1, 'FECHADA', '2026-01-14 18:04:09', '2026-01-14 18:05:00', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(16, NULL, 1, 'FECHADA', '2026-01-14 18:19:20', '2026-01-14 18:29:06', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(17, NULL, 1, 'FECHADA', '2026-01-14 18:32:04', '2026-01-14 18:39:01', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(18, NULL, 2, 'FECHADA', '2026-01-14 18:33:25', '2026-01-14 18:38:56', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(19, NULL, 1, 'FECHADA', '2026-01-14 18:49:55', '2026-01-14 18:51:46', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(20, NULL, 2, 'FECHADA', '2026-01-14 18:50:42', '2026-01-14 18:51:52', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(21, NULL, 1, 'FECHADA', '2026-01-14 18:57:23', '2026-01-14 19:29:56', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(22, NULL, 1, 'FECHADA', '2026-01-14 19:32:56', '2026-01-14 19:34:38', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(23, NULL, 1, 'FECHADA', '2026-01-14 19:38:37', '2026-01-14 19:55:22', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(24, NULL, 2, 'FECHADA', '2026-01-14 19:40:03', '2026-01-14 19:55:31', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(25, NULL, 1, 'FECHADA', '2026-01-14 19:57:25', '2026-01-14 19:57:35', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(26, NULL, 1, 'FECHADA', '2026-01-14 20:06:56', '2026-01-14 20:07:48', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(27, NULL, 2, 'FECHADA', '2026-01-14 23:36:29', '2026-01-14 23:38:13', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(28, NULL, 1, 'FECHADA', '2026-01-14 23:40:01', '2026-01-14 23:40:35', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(29, NULL, 1, 'FECHADA', '2026-01-15 00:08:30', '2026-01-15 00:11:07', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(30, NULL, 2, 'FECHADA', '2026-01-15 00:10:33', '2026-01-15 00:11:45', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(31, NULL, 1, 'FECHADA', '2026-01-15 00:46:06', '2026-01-15 00:51:21', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(32, NULL, 2, 'FECHADA', '2026-01-15 00:48:00', '2026-01-15 00:51:08', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(33, NULL, 1, 'FECHADA', '2026-01-15 01:03:13', '2026-01-15 01:08:17', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(34, NULL, 1, 'FECHADA', '2026-01-15 01:16:17', '2026-01-15 01:17:50', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(35, NULL, 1, 'FECHADA', '2026-01-15 01:19:36', '2026-01-15 01:22:21', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(36, NULL, 1, 'FECHADA', '2026-01-15 01:37:10', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(37, NULL, 2, 'FECHADA', '2026-01-15 02:00:57', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(38, NULL, 1, 'FECHADA', '2026-01-15 10:36:26', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(39, NULL, 1, 'FECHADA', '2026-01-15 10:52:44', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(40, NULL, 1, 'FECHADA', '2026-01-15 11:11:45', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(41, NULL, 1, 'FECHADA', '2026-01-15 11:13:47', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(42, NULL, 1, 'FECHADA', '2026-01-15 11:15:32', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(43, NULL, 1, 'FECHADA', '2026-01-15 11:29:06', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(44, NULL, 1, 'FECHADA', '2026-01-15 11:41:54', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(45, NULL, 1, 'FECHADA', '2026-01-15 12:08:43', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(46, NULL, 1, 'FECHADA', '2026-01-15 12:25:55', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(47, NULL, 2, 'FECHADA', '2026-01-15 12:27:10', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(48, NULL, 1, 'FECHADA', '2026-01-15 12:38:49', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(49, NULL, 1, 'FECHADA', '2026-01-15 12:45:08', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(50, NULL, 1, 'FECHADA', '2026-01-15 12:55:22', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(51, NULL, 1, 'FECHADA', '2026-01-15 13:07:00', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(52, NULL, 1, 'FECHADA', '2026-01-15 13:18:16', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(53, NULL, 2, 'FECHADA', '2026-01-15 13:21:39', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(54, NULL, 1, 'FECHADA', '2026-01-15 13:31:06', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(55, NULL, 1, 'FECHADA', '2026-01-15 13:33:06', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(56, NULL, 1, 'FECHADA', '2026-01-15 13:41:28', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(57, NULL, 1, 'FECHADA', '2026-01-15 13:51:42', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(58, NULL, 1, 'FECHADA', '2026-01-15 13:54:28', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(59, NULL, 1, 'FECHADA', '2026-01-15 13:57:49', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(60, NULL, 1, 'FECHADA', '2026-01-15 14:06:20', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(61, NULL, 1, 'FECHADA', '2026-01-15 16:11:10', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(62, NULL, 1, 'FECHADA', '2026-01-15 16:29:25', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(63, NULL, 1, 'FECHADA', '2026-01-15 16:30:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(64, NULL, 1, 'FECHADA', '2026-01-15 16:33:13', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(65, NULL, 1, 'FECHADA', '2026-01-15 16:54:07', '2026-01-15 17:03:41', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(66, NULL, 1, 'FECHADA', '2026-01-15 17:12:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(67, NULL, 1, 'FECHADA', '2026-01-15 17:32:07', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(68, NULL, 1, 'FECHADA', '2026-01-15 17:45:10', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(69, NULL, 1, 'FECHADA', '2026-01-15 18:02:37', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(70, NULL, 1, 'FECHADA', '2026-01-15 18:15:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(71, NULL, 1, 'FECHADA', '2026-01-15 18:27:46', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(72, NULL, 1, 'FECHADA', '2026-01-15 19:08:44', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(73, NULL, 1, 'FECHADA', '2026-01-15 19:50:18', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(74, NULL, 1, 'FECHADA', '2026-01-15 20:04:58', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(75, NULL, 1, 'FECHADA', '2026-01-15 20:57:25', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(76, NULL, 1, 'FECHADA', '2026-01-15 21:51:47', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(77, NULL, 2, 'FECHADA', '2026-01-15 22:28:11', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(78, NULL, 1, 'FECHADA', '2026-01-15 22:54:50', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(79, NULL, 1, 'FECHADA', '2026-01-15 22:57:50', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(80, NULL, 1, 'FECHADA', '2026-01-15 23:03:18', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(81, NULL, 1, 'FECHADA', '2026-01-15 23:14:37', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(82, NULL, 1, 'FECHADA', '2026-01-16 00:26:24', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(83, NULL, 1, 'FECHADA', '2026-01-16 00:33:20', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(84, NULL, 1, 'FECHADA', '2026-01-16 00:37:50', '2026-01-16 00:38:38', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(85, NULL, 1, 'FECHADA', '2026-01-16 01:05:45', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(86, NULL, 1, 'FECHADA', '2026-01-16 01:17:31', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(87, NULL, 1, 'FECHADA', '2026-01-16 16:35:48', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(88, NULL, 1, 'FECHADA', '2026-01-16 16:56:11', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(89, NULL, 1, 'FECHADA', '2026-01-16 17:25:33', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(90, NULL, 1, 'FECHADA', '2026-01-16 17:29:17', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(91, NULL, 2, 'FECHADA', '2026-01-16 17:30:49', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(92, NULL, 1, 'FECHADA', '2026-01-16 17:36:51', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(93, NULL, 1, 'FECHADA', '2026-01-16 17:37:54', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(94, NULL, 2, 'FECHADA', '2026-01-16 17:43:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(95, NULL, 1, 'FECHADA', '2026-01-16 17:49:12', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(96, NULL, 1, 'FECHADA', '2026-01-16 18:01:41', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(97, NULL, 1, 'FECHADA', '2026-01-16 18:18:28', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(98, NULL, 1, 'FECHADA', '2026-01-16 18:59:25', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(99, NULL, 1, 'FECHADA', '2026-01-16 19:02:05', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(100, NULL, 1, 'FECHADA', '2026-01-16 19:43:34', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(101, NULL, 1, 'FECHADA', '2026-01-16 19:53:11', '2026-01-16 19:53:36', '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(102, NULL, 1, 'FECHADA', '2026-01-16 20:29:45', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(103, NULL, 1, 'FECHADA', '2026-01-16 20:46:23', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(104, NULL, 2, 'FECHADA', '2026-01-16 21:15:03', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(105, NULL, 2, 'FECHADA', '2026-01-17 12:26:03', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(106, NULL, 2, 'FECHADA', '2026-01-17 13:48:02', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(107, NULL, 1, 'FECHADA', '2026-01-17 13:55:04', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(108, NULL, 1, 'FECHADA', '2026-01-17 16:37:13', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(109, NULL, 1, 'FECHADA', '2026-01-17 16:45:51', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(110, NULL, 1, 'FECHADA', '2026-01-17 17:21:08', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(111, NULL, 1, 'FECHADA', '2026-01-17 19:42:58', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(112, NULL, 2, 'FECHADA', '2026-01-17 19:43:22', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(113, NULL, 1, 'FECHADA', '2026-01-17 19:58:46', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(114, NULL, 1, 'FECHADA', '2026-01-17 20:15:46', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(115, NULL, 1, 'FECHADA', '2026-01-17 21:29:13', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(116, NULL, 1, 'FECHADA', '2026-01-17 23:06:03', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(117, NULL, 1, 'FECHADA', '2026-01-18 15:11:59', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(118, NULL, 1, 'FECHADA', '2026-01-18 15:14:56', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(119, NULL, 1, 'FECHADA', '2026-01-18 18:37:46', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(120, NULL, 1, 'FECHADA', '2026-01-19 01:06:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(121, NULL, 1, 'FECHADA', '2026-01-19 22:11:23', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(122, NULL, 1, 'FECHADA', '2026-01-21 17:35:48', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(123, NULL, 1, 'FECHADA', '2026-01-21 17:41:19', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(124, NULL, 1, 'FECHADA', '2026-01-21 18:47:55', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(125, NULL, 1, 'FECHADA', '2026-01-21 20:05:36', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(126, NULL, 1, 'FECHADA', '2026-01-21 23:38:13', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(127, NULL, 2, 'FECHADA', '2026-01-21 23:43:03', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(128, NULL, 2, 'FECHADA', '2026-01-22 00:22:47', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(129, NULL, 2, 'FECHADA', '2026-01-22 00:27:56', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(130, NULL, 1, 'FECHADA', '2026-01-22 00:30:22', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(131, NULL, 1, 'FECHADA', '2026-01-22 01:20:30', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(132, NULL, 1, 'FECHADA', '2026-01-22 11:17:43', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(133, NULL, 1, 'FECHADA', '2026-01-22 16:11:54', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(134, NULL, 2, 'FECHADA', '2026-01-22 16:23:45', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(135, NULL, 1, 'FECHADA', '2026-01-22 16:24:47', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(136, NULL, 2, 'FECHADA', '2026-01-22 16:39:16', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(137, NULL, 1, 'FECHADA', '2026-01-22 16:40:45', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(138, NULL, 2, 'FECHADA', '2026-01-22 17:15:40', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(139, NULL, 1, 'FECHADA', '2026-01-22 17:51:36', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(140, NULL, 1, 'FECHADA', '2026-01-22 19:04:09', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(141, NULL, 1, 'FECHADA', '2026-01-22 21:07:14', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(142, NULL, 1, 'FECHADA', '2026-01-22 23:35:05', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(143, NULL, 1, 'FECHADA', '2026-01-22 23:39:10', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(144, NULL, 1, 'FECHADA', '2026-01-22 23:53:18', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(145, NULL, 1, 'FECHADA', '2026-01-23 12:15:15', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(146, NULL, 1, 'FECHADA', '2026-01-23 12:58:31', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(147, NULL, 1, 'FECHADA', '2026-01-23 13:01:02', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(148, NULL, 1, 'FECHADA', '2026-01-23 13:15:41', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(149, NULL, 1, 'FECHADA', '2026-01-23 13:16:39', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(150, NULL, 1, 'FECHADA', '2026-01-23 13:17:23', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(151, NULL, 1, 'FECHADA', '2026-01-23 13:18:09', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(152, NULL, 1, 'FECHADA', '2026-01-23 13:19:56', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(153, NULL, 1, 'FECHADA', '2026-01-23 13:22:15', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(154, NULL, 1, 'FECHADA', '2026-01-23 16:16:06', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(155, NULL, 1, 'FECHADA', '2026-01-23 16:53:21', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(156, NULL, 1, 'FECHADA', '2026-01-23 16:59:40', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(157, NULL, 1, 'FECHADA', '2026-01-23 17:01:18', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(158, NULL, 1, 'FECHADA', '2026-01-23 17:02:37', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(159, NULL, 2, 'FECHADA', '2026-01-23 17:04:35', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(160, NULL, 2, 'FECHADA', '2026-01-23 15:03:09', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(161, NULL, 1, 'FECHADA', '2026-01-23 15:06:52', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(162, NULL, 1, 'FECHADA', '2026-01-23 15:20:50', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(163, NULL, 1, 'FECHADA', '2026-01-23 15:25:09', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(164, NULL, 2, 'FECHADA', '2026-01-23 15:28:38', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(165, NULL, 1, 'FECHADA', '2026-01-23 15:41:38', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(166, NULL, 1, 'FECHADA', '2026-01-23 16:03:59', NULL, '2026-01-23 16:31:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(167, NULL, 1, 'FECHADA', '2026-01-23 16:31:57', NULL, '2026-01-23 16:31:57', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(168, NULL, 1, 'FECHADA', '2026-01-23 16:42:49', NULL, '2026-01-23 16:42:49', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(169, NULL, 1, 'FECHADA', '2026-01-23 16:48:48', NULL, '2026-01-23 16:48:48', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(170, NULL, 1, 'FECHADA', '2026-01-23 16:50:53', NULL, '2026-01-23 16:50:53', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(171, NULL, 1, 'FECHADA', '2026-01-23 16:52:54', NULL, '2026-01-23 16:52:54', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(172, NULL, 1, 'FECHADA', '2026-01-23 19:43:18', NULL, '2026-01-23 19:43:18', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(173, NULL, 1, 'FECHADA', '2026-01-23 20:01:02', NULL, '2026-01-23 20:01:02', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(174, NULL, 1, 'FECHADA', '2026-01-23 20:30:33', NULL, '2026-01-23 20:30:33', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(175, NULL, 1, 'FECHADA', '2026-01-23 20:34:55', NULL, '2026-01-23 20:34:55', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(176, NULL, 1, 'FECHADA', '2026-01-23 21:15:54', NULL, '2026-01-23 21:15:54', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(177, NULL, 1, 'FECHADA', '2026-01-23 21:24:49', NULL, '2026-01-23 21:24:49', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(178, NULL, 1, 'FECHADA', '2026-01-23 21:49:40', NULL, '2026-01-23 21:49:40', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(179, NULL, 1, 'FECHADA', '2026-01-23 22:22:07', NULL, '2026-01-23 22:22:07', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(180, NULL, 1, 'FECHADA', '2026-01-23 22:38:24', NULL, '2026-01-23 22:38:24', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(181, NULL, 1, 'FECHADA', '2026-01-23 22:47:34', NULL, '2026-01-23 22:47:34', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(182, NULL, 1, 'FECHADA', '2026-01-23 23:13:21', NULL, '2026-01-23 23:13:21', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(183, NULL, 1, 'FECHADA', '2026-01-23 23:22:28', NULL, '2026-01-23 23:22:28', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(184, NULL, 1, 'FECHADA', '2026-01-23 23:28:57', NULL, '2026-01-23 23:28:57', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(185, NULL, 1, 'FECHADA', '2026-01-24 08:46:22', NULL, '2026-01-24 08:46:22', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(186, NULL, 1, 'FECHADA', '2026-01-24 09:29:47', NULL, '2026-01-24 09:29:47', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(187, NULL, 1, 'FECHADA', '2026-01-24 09:43:10', NULL, '2026-01-24 09:43:10', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(188, NULL, 1, 'FECHADA', '2026-01-24 09:46:29', NULL, '2026-01-24 09:46:29', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(189, NULL, 1, 'FECHADA', '2026-01-24 09:54:53', NULL, '2026-01-24 09:54:53', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(190, NULL, 1, 'FECHADA', '2026-01-24 10:23:30', NULL, '2026-01-24 10:23:30', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(191, NULL, 1, 'FECHADA', '2026-01-24 10:25:51', NULL, '2026-01-24 10:25:51', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(192, NULL, 1, 'FECHADA', '2026-01-24 10:27:29', NULL, '2026-01-24 10:27:29', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(193, NULL, 1, 'FECHADA', '2026-01-24 10:30:38', NULL, '2026-01-24 10:30:38', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(194, NULL, 1, 'FECHADA', '2026-01-24 10:39:01', NULL, '2026-01-24 10:39:01', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(195, NULL, 1, 'FECHADA', '2026-01-24 10:42:37', NULL, '2026-01-24 10:42:37', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(196, NULL, 1, 'FECHADA', '2026-01-24 10:58:00', NULL, '2026-01-24 10:58:00', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(197, NULL, 1, 'FECHADA', '2026-01-24 10:59:59', NULL, '2026-01-24 10:59:59', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(198, NULL, 1, 'FECHADA', '2026-01-24 13:22:06', NULL, '2026-01-24 13:22:06', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(199, NULL, 1, 'FECHADA', '2026-01-24 14:24:19', NULL, '2026-01-24 14:24:19', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(200, NULL, 1, 'FECHADA', '2026-01-24 14:55:40', NULL, '2026-01-24 14:55:40', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(201, NULL, 1, 'FECHADA', '2026-01-24 15:21:43', NULL, '2026-01-24 15:21:43', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(202, NULL, 1, 'FECHADA', '2026-01-24 15:56:04', NULL, '2026-01-24 15:56:04', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(203, NULL, 1, 'FECHADA', '2026-01-25 14:21:32', NULL, '2026-01-25 14:21:32', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(204, NULL, 1, 'FECHADA', '2026-01-25 18:55:26', NULL, '2026-01-25 18:55:26', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(205, NULL, 1, 'FECHADA', '2026-01-25 21:56:33', NULL, '2026-01-25 21:56:33', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(206, NULL, 1, 'FECHADA', '2026-01-25 22:18:52', NULL, '2026-01-25 22:18:52', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(207, NULL, 1, 'FECHADA', '2026-01-26 08:24:01', NULL, '2026-01-26 08:24:01', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(208, NULL, 1, 'FECHADA', '2026-01-28 16:13:48', NULL, '2026-01-28 16:13:48', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(209, NULL, 1, 'FECHADA', '2026-01-29 00:19:06', NULL, '2026-01-29 00:19:06', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(210, NULL, 1, 'FECHADA', '2026-01-29 19:33:05', NULL, '2026-01-29 19:33:05', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(211, NULL, 1, 'FECHADA', '2026-01-29 23:13:02', NULL, '2026-01-29 23:13:02', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(212, NULL, 1, 'FECHADA', '2026-01-30 09:41:17', NULL, '2026-01-30 09:41:17', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(213, NULL, 1, 'FECHADA', '2026-02-02 09:01:28', NULL, '2026-02-02 09:01:28', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(214, NULL, 1, 'FECHADA', '2026-02-02 09:50:04', NULL, '2026-02-02 09:50:04', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(215, NULL, 1, 'FECHADA', '2026-02-02 09:51:59', NULL, '2026-02-02 09:51:59', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(216, NULL, 1, 'FECHADA', '2026-02-02 14:28:32', NULL, '2026-02-02 14:28:32', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(217, NULL, 1, 'FECHADA', '2026-02-02 21:59:11', NULL, '2026-02-02 21:59:11', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(218, NULL, 1, 'FECHADA', '2026-02-03 08:05:48', NULL, '2026-02-03 08:05:48', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(219, NULL, 1, 'FECHADA', '2026-02-03 08:15:27', NULL, '2026-02-03 08:15:27', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(220, NULL, 1, 'FECHADA', '2026-02-03 08:43:33', NULL, '2026-02-03 08:43:33', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(221, NULL, 1, 'FECHADA', '2026-02-03 10:01:05', NULL, '2026-02-03 10:01:05', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(222, NULL, 1, 'FECHADA', '2026-02-03 11:08:44', NULL, '2026-02-03 11:08:44', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(223, NULL, 1, 'FECHADA', '2026-02-03 13:02:03', NULL, '2026-02-03 13:02:03', '0.00', '0.00', '2026-02-03 13:03:37', NULL, 'PENDENTE', 1),
(224, NULL, 2, 'FECHADA', '2026-02-03 13:03:08', NULL, '2026-02-03 13:03:08', '0.00', '0.00', '2026-02-03 13:05:13', NULL, 'PENDENTE', 1),
(225, NULL, 1, 'FECHADA', '2026-02-03 13:06:38', NULL, '2026-02-03 13:06:38', '0.00', '0.00', '2026-02-03 13:07:27', NULL, 'PENDENTE', 1),
(226, NULL, 1, 'FECHADA', '2026-02-03 13:38:22', NULL, '2026-02-03 13:38:22', '0.00', '0.00', '2026-02-03 13:39:07', NULL, 'PENDENTE', 1),
(227, NULL, 1, 'FECHADA', '2026-02-03 13:40:42', NULL, '2026-02-03 13:40:42', '0.00', '0.00', '2026-02-03 13:40:50', NULL, 'PENDENTE', 1),
(228, NULL, 1, 'FECHADA', '2026-02-03 14:19:23', NULL, '2026-02-03 14:19:23', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1),
(229, NULL, 2, 'FECHADA', '2026-02-03 14:59:40', NULL, '2026-02-03 14:59:40', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1),
(230, NULL, 3, 'FECHADA', '2026-02-03 15:19:50', NULL, '2026-02-03 15:19:50', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1),
(231, NULL, 1, 'FECHADA', '2026-02-03 15:23:00', NULL, '2026-02-03 15:23:00', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1),
(232, NULL, 1, 'FECHADA', '2026-02-03 19:16:10', NULL, '2026-02-03 19:16:10', '0.00', '0.00', NULL, NULL, 'PENDENTE', 0),
(233, NULL, 2, 'FECHADA', '2026-02-03 19:21:12', NULL, '2026-02-03 19:21:12', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1),
(234, NULL, 1, 'FECHADA', '2026-02-03 19:23:01', NULL, '2026-02-03 19:23:01', '0.00', '0.00', NULL, NULL, 'PENDENTE', 1);

-- --------------------------------------------------------

--
-- Estrutura para tabela `contas_liberacoes`
--

CREATE TABLE `contas_liberacoes` (
  `conta_id` int NOT NULL,
  `liberada` tinyint NOT NULL DEFAULT '0',
  `liberada_em` datetime DEFAULT NULL,
  `liberada_por` int DEFAULT NULL,
  `recusada_em` datetime DEFAULT NULL,
  `recusada_por` int DEFAULT NULL,
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `atualizado_em` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `contas_liberacoes`
--

INSERT INTO `contas_liberacoes` (`conta_id`, `liberada`, `liberada_em`, `liberada_por`, `recusada_em`, `recusada_por`, `criado_em`, `atualizado_em`) VALUES
(228, 1, '2026-02-03 14:20:09', NULL, '2026-02-03 14:19:53', NULL, '2026-02-03 14:19:53', '2026-02-03 14:20:09'),
(229, 1, '2026-02-03 15:00:18', NULL, NULL, NULL, '2026-02-03 15:00:18', '2026-02-03 15:00:18'),
(230, 1, '2026-02-03 15:20:15', NULL, NULL, NULL, '2026-02-03 15:20:15', '2026-02-03 15:20:15'),
(231, 1, '2026-02-03 15:24:17', NULL, '2026-02-03 15:24:13', NULL, '2026-02-03 15:24:13', '2026-02-03 15:24:17'),
(233, 1, '2026-02-03 19:22:07', NULL, NULL, NULL, '2026-02-03 19:22:07', '2026-02-03 19:22:07'),
(234, 1, '2026-02-03 19:23:37', NULL, '2026-02-03 19:23:15', NULL, '2026-02-03 19:23:15', '2026-02-03 19:23:37');

-- --------------------------------------------------------

--
-- Estrutura para tabela `conta_participantes`
--

CREATE TABLE `conta_participantes` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `cliente_id` int NOT NULL,
  `sessao_key` varchar(32) NOT NULL,
  `status` enum('PENDENTE','ATIVO','NEGADO','SAIU') NOT NULL DEFAULT 'PENDENTE',
  `solicitado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `aprovado_em` datetime DEFAULT NULL,
  `aprovado_por_cliente_id` int DEFAULT NULL,
  `atualizado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `conta_participantes`
--

INSERT INTO `conta_participantes` (`id`, `conta_id`, `cliente_id`, `sessao_key`, `status`, `solicitado_em`, `aprovado_em`, `aprovado_por_cliente_id`) VALUES
(1, 166, 22, '1d0638b85dc0', 'SAIU', '2026-01-23 16:12:14', NULL, NULL),
(2, 166, 23, 'e91e2c0fbd50', 'NEGADO', '2026-01-23 16:13:49', '2026-01-23 16:19:30', 22),
(3, 167, 24, '16548da26c1b', 'ATIVO', '2026-01-23 16:31:57', NULL, NULL),
(4, 167, 25, '11fbdf017ee1', 'ATIVO', '2026-01-23 16:32:30', '2026-01-23 16:32:40', 24),
(5, 169, 28, '978952359279', 'SAIU', '2026-01-23 16:48:48', NULL, NULL),
(6, 170, 29, '7c7c6e3d7f4a', 'SAIU', '2026-01-23 16:50:54', NULL, NULL),
(7, 171, 30, 'c7975796f00b', 'ATIVO', '2026-01-23 16:52:54', NULL, NULL),
(8, 171, 31, '8dcec6619e90', 'SAIU', '2026-01-23 19:40:36', NULL, NULL),
(9, 173, 33, '5686cb387d6b', 'SAIU', '2026-01-23 20:01:02', NULL, NULL),
(10, 174, 34, '55e0eb81272a', 'SAIU', '2026-01-23 20:30:33', NULL, NULL),
(11, 175, 35, 'b077b20ca797', 'ATIVO', '2026-01-23 20:34:55', NULL, NULL),
(12, 176, 36, '66c0259d40b4', 'SAIU', '2026-01-23 21:15:54', NULL, NULL),
(13, 177, 37, '6fd0f403a37e', 'SAIU', '2026-01-23 21:24:49', NULL, NULL),
(14, 178, 38, '054afcfdf500', 'SAIU', '2026-01-23 21:49:40', NULL, NULL),
(15, 179, 39, '1f88a276934d', 'SAIU', '2026-01-23 22:22:07', NULL, NULL),
(16, 179, 40, 'b2d0580c738c', 'SAIU', '2026-01-23 22:26:12', '2026-01-23 22:26:28', 39),
(17, 180, 41, '1ac37b371c0e', 'ATIVO', '2026-01-23 22:38:24', NULL, NULL),
(18, 181, 42, '068fd87e5a44', 'ATIVO', '2026-01-23 22:47:34', NULL, NULL),
(19, 181, 43, '5c33ef6aff5e', 'NEGADO', '2026-01-23 22:51:29', '2026-02-03 08:40:43', NULL),
(20, 182, 44, '50b296c1c37a', 'SAIU', '2026-01-23 23:13:21', NULL, NULL),
(21, 183, 45, '3ef9d76118d9', 'SAIU', '2026-01-23 23:22:28', NULL, NULL),
(22, 184, 46, 'a3a56cea9c7e', 'ATIVO', '2026-01-23 23:28:57', NULL, NULL),
(23, 184, 47, '78b2d8b9aa7a', 'NEGADO', '2026-01-24 08:25:18', '2026-02-03 08:40:51', NULL),
(24, 184, 48, '7935b555b037', 'SAIU', '2026-01-24 08:45:04', NULL, NULL),
(25, 185, 49, '655d546b53d8', 'SAIU', '2026-01-24 08:46:22', NULL, NULL),
(26, 186, 50, '82ab8f4e6147', 'SAIU', '2026-01-24 09:29:47', NULL, NULL),
(27, 187, 51, '76b28bcdde36', 'SAIU', '2026-01-24 09:43:10', NULL, NULL),
(28, 188, 52, '7afb2c13b60c', 'SAIU', '2026-01-24 09:46:30', NULL, NULL),
(29, 189, 53, 'd10a5ee78090', 'SAIU', '2026-01-24 09:54:53', NULL, NULL),
(30, 189, 54, '7d849fea6516', 'SAIU', '2026-01-24 10:14:10', NULL, NULL),
(31, 190, 55, '253dce98ce08', 'SAIU', '2026-01-24 10:23:30', NULL, NULL),
(32, 191, 56, '9f2acbe25a5e', 'SAIU', '2026-01-24 10:25:51', NULL, NULL),
(33, 192, 57, '1983e79c7c49', 'SAIU', '2026-01-24 10:27:29', NULL, NULL),
(34, 193, 58, 'a50117de4d5f', 'SAIU', '2026-01-24 10:30:38', NULL, NULL),
(35, 194, 59, 'e4616c8bbdae', 'SAIU', '2026-01-24 10:39:01', NULL, NULL),
(36, 194, 60, '1ec2d7fed395', 'SAIU', '2026-01-24 10:40:06', '2026-01-24 10:40:28', 59),
(37, 195, 61, '971db26a1d96', 'SAIU', '2026-01-24 10:42:37', NULL, NULL),
(38, 196, 62, '5b2300646934', 'SAIU', '2026-01-24 10:58:00', NULL, NULL),
(39, 197, 63, '68a4d32a6031', 'SAIU', '2026-01-24 10:59:59', NULL, NULL),
(40, 197, 64, 'c190576df6b4', 'SAIU', '2026-01-24 11:18:54', '2026-01-24 11:19:03', 63),
(41, 198, 65, 'c88016ef0f94', 'SAIU', '2026-01-24 13:22:07', NULL, NULL),
(42, 199, 66, '9566055f909a', 'SAIU', '2026-01-24 14:24:19', NULL, NULL),
(43, 200, 67, 'aef09bd7cecc', 'SAIU', '2026-01-24 14:55:40', NULL, NULL),
(44, 201, 68, '15fd81da55b9', 'SAIU', '2026-01-24 15:21:43', NULL, NULL),
(45, 201, 69, 'efe740618329', 'SAIU', '2026-01-24 15:35:14', '2026-01-24 15:35:24', 68),
(46, 202, 70, '7456f77aa746', 'ATIVO', '2026-01-24 15:56:04', NULL, NULL),
(47, 202, 71, 'f3a2aa7e0c6c', 'SAIU', '2026-01-24 16:13:50', NULL, NULL),
(48, 203, 72, '6fd2f72588ce', 'SAIU', '2026-01-25 14:21:32', NULL, NULL),
(49, 203, 73, '20e6ce388d71', 'SAIU', '2026-01-25 14:23:15', '2026-01-25 14:23:54', 72),
(50, 204, 74, '9eb2578b1955', 'ATIVO', '2026-01-25 18:55:27', NULL, NULL),
(51, 205, 75, '772c087f4467', 'SAIU', '2026-01-25 21:56:33', NULL, NULL),
(52, 206, 76, 'a66e7d27cb1f', 'SAIU', '2026-01-25 22:18:52', NULL, NULL),
(53, 207, 77, 'a876c0603c6a', 'ATIVO', '2026-01-26 08:24:01', NULL, NULL),
(54, 207, 78, '51b207d4f247', 'SAIU', '2026-01-26 17:53:22', NULL, NULL),
(55, 208, 79, '6bae57877604', 'ATIVO', '2026-01-28 16:13:48', NULL, NULL),
(56, 209, 80, 'fcad55ba541e', 'ATIVO', '2026-01-29 00:19:06', NULL, NULL),
(57, 210, 81, 'c4f09bc7f9a7', 'ATIVO', '2026-01-29 19:33:05', NULL, NULL),
(58, 211, 82, '690ccb30a748', 'SAIU', '2026-01-29 23:13:02', NULL, NULL),
(59, 212, 83, 'f41f06fb6fb3', 'ATIVO', '2026-01-30 09:41:17', NULL, NULL),
(60, 212, 84, '2817482aa26e', 'NEGADO', '2026-01-30 21:26:07', '2026-02-03 08:40:55', NULL),
(61, 213, 85, '88142df75640', 'ATIVO', '2026-02-02 09:01:29', NULL, NULL),
(62, 213, 86, '48a15c72105a', 'SAIU', '2026-02-02 09:47:17', NULL, NULL),
(63, 214, 87, 'd0fbf454488c', 'SAIU', '2026-02-02 09:50:04', NULL, NULL),
(64, 215, 88, '04dda86eed49', 'ATIVO', '2026-02-02 09:51:59', NULL, NULL),
(65, 216, 89, '529fe94b8257', 'SAIU', '2026-02-02 14:28:32', NULL, NULL),
(66, 217, 90, '07dd332e2fbb', 'SAIU', '2026-02-02 21:59:11', NULL, NULL),
(67, 218, 91, 'd27a2fd0ee61', 'SAIU', '2026-02-03 08:05:49', NULL, NULL),
(68, 219, 92, '942d49bce7b1', 'SAIU', '2026-02-03 08:15:27', NULL, NULL),
(69, 220, 93, '06a8d38b3757', 'SAIU', '2026-02-03 08:43:33', NULL, NULL),
(70, 221, 94, '113d9d4054e0', 'SAIU', '2026-02-03 10:01:05', NULL, NULL),
(71, 222, 95, '0615f686d1ea', 'ATIVO', '2026-02-03 11:08:44', NULL, NULL),
(72, 223, 96, 'd7498419bf7a', 'SAIU', '2026-02-03 13:02:04', NULL, NULL),
(73, 224, 97, 'aeb71b4dfa4b', 'SAIU', '2026-02-03 13:03:08', NULL, NULL),
(74, 225, 98, '164e0d9c85d4', 'ATIVO', '2026-02-03 13:06:38', NULL, NULL),
(75, 226, 99, 'ab0df1b37643', 'SAIU', '2026-02-03 13:38:22', NULL, NULL),
(76, 227, 100, '7465ccd442c6', 'SAIU', '2026-02-03 13:40:42', NULL, NULL),
(77, 228, 101, '873757699ec4', 'SAIU', '2026-02-03 14:19:23', NULL, NULL),
(78, 229, 102, '5f6f49726a15', 'ATIVO', '2026-02-03 14:59:40', NULL, NULL),
(79, 229, 103, '99fdcddb886b', 'SAIU', '2026-02-03 15:12:46', '2026-02-03 15:13:11', 102),
(80, 230, 104, '73f87c612e06', 'ATIVO', '2026-02-03 15:19:50', NULL, NULL),
(81, 231, 105, '3449073a7b41', 'ATIVO', '2026-02-03 15:23:00', NULL, NULL),
(82, 232, 106, 'a38ea5e872b8', 'SAIU', '2026-02-03 19:16:10', NULL, NULL),
(83, 233, 107, '88d98f7dd948', 'SAIU', '2026-02-03 19:21:12', NULL, NULL),
(84, 234, 108, '94a9389518bd', 'SAIU', '2026-02-03 19:23:01', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura para tabela `lancamentos`
--

CREATE TABLE `lancamentos` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `sessao_key` varchar(32) NOT NULL,
  `descricao` varchar(255) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `status` enum('CONFIRMADO','CANCELADO') NOT NULL DEFAULT 'CONFIRMADO',
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `lancamentos`
--

INSERT INTO `lancamentos` (`id`, `conta_id`, `sessao_key`, `descricao`, `valor`, `status`, `criado_em`) VALUES
(1, 88, '71a442408b0b', 'teste', '10.00', 'CONFIRMADO', '2026-01-16 16:58:35'),
(2, 95, '4b6c968094cb', 'Chocolate', '2.50', 'CONFIRMADO', '2026-01-16 17:50:13'),
(3, 99, '6821e7e56d28', 'Sorvete', '10.00', 'CONFIRMADO', '2026-01-16 19:09:19'),
(4, 99, '6821e7e56d28', 'balas', '5.00', 'CONFIRMADO', '2026-01-16 19:11:23'),
(5, 100, '3d71ce5f4600', 'doce', '10.00', 'CONFIRMADO', '2026-01-16 19:46:50'),
(6, 109, '436eb01643f3', 'Sorvete', '10.00', 'CONFIRMADO', '2026-01-17 16:52:53'),
(7, 110, '3aa38f2298d3', 'teste', '5.00', 'CONFIRMADO', '2026-01-17 17:24:00'),
(8, 110, '3aa38f2298d3', 'Bala', '12.00', 'CONFIRMADO', '2026-01-17 17:49:27'),
(9, 111, '84bcf8fc7f5a', 'Balas', '1.00', 'CONFIRMADO', '2026-01-17 19:51:36'),
(10, 116, 'e2dbad1ee965', 'balcao', '50.43', 'CONFIRMADO', '2026-01-17 23:12:23'),
(11, 120, '1da5e6db582e', 'Sorverte', '10.00', 'CONFIRMADO', '2026-01-19 01:08:18'),
(12, 133, '6fbbda4080bf', 'teste', '10.00', 'CONFIRMADO', '2026-01-22 16:21:18'),
(13, 167, '16548da26c1b', 'sorvete', '15.00', 'CONFIRMADO', '2026-01-23 16:41:59'),
(14, 177, '6fd0f403a37e', 'teste', '34.00', 'CONFIRMADO', '2026-01-23 21:32:18'),
(15, 201, 'efe740618329', 'teste', '15.00', 'CONFIRMADO', '2026-01-24 15:49:01'),
(16, 203, '20e6ce388d71', 'teste', '25.00', 'CONFIRMADO', '2026-01-25 16:31:29'),
(17, 203, '6fd2f72588ce', 'teste', '10.00', 'CONFIRMADO', '2026-01-25 16:32:26');

-- --------------------------------------------------------

--
-- Estrutura para tabela `mesa_participantes`
--

CREATE TABLE `mesa_participantes` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `cliente_id` int NOT NULL,
  `sessao_key` varchar(20) NOT NULL,
  `ultimo_ping` datetime NOT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `pagamentos`
--

CREATE TABLE `pagamentos` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `sessao_key` varchar(32) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `metodo` varchar(30) DEFAULT NULL,
  `status` enum('PENDENTE','CONFIRMADO','CANCELADO') NOT NULL DEFAULT 'CONFIRMADO',
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmado_em` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `pagamentos`
--

INSERT INTO `pagamentos` (`id`, `conta_id`, `sessao_key`, `valor`, `metodo`, `status`, `criado_em`, `confirmado_em`) VALUES
(1, 87, 'bdf23bcc66a4', '92.00', 'PIX', 'CONFIRMADO', '2026-01-16 16:37:56', '2026-01-16 16:37:56'),
(2, 88, '71a442408b0b', '5.00', 'PIX', 'CONFIRMADO', '2026-01-16 16:58:15', '2026-01-16 16:58:15'),
(3, 88, '71a442408b0b', '17.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:00:35', '2026-01-16 17:00:35'),
(4, 89, '78d3183007ac', '80.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:26:00', '2026-01-16 17:26:00'),
(5, 89, '78d3183007ac', '80.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:26:15', '2026-01-16 17:26:15'),
(6, 91, '78155de3e80b', '10.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:32:36', '2026-01-16 17:32:36'),
(7, 91, '78155de3e80b', '20.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:32:44', '2026-01-16 17:32:44'),
(8, 92, 'ad8ffcb04636', '30.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:37:11', '2026-01-16 17:37:11'),
(9, 93, 'ad8ffcb04636', '12.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:38:19', '2026-01-16 17:38:19'),
(10, 94, '71aca4e283e8', '2.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:44:07', '2026-01-16 17:44:07'),
(11, 94, '71aca4e283e8', '13.00', 'PIX', 'CONFIRMADO', '2026-01-16 17:44:14', '2026-01-16 17:44:14'),
(12, 95, '4b6c968094cb', '30.50', 'PIX', 'CONFIRMADO', '2026-01-16 17:51:57', '2026-01-16 17:51:57'),
(13, 96, '4f82bd63a313', '240.00', 'PIX', 'CONFIRMADO', '2026-01-16 18:02:42', '2026-01-16 18:02:42'),
(14, 97, 'd03df48be766', '25.00', 'PIX', 'CONFIRMADO', '2026-01-16 18:36:43', '2026-01-16 18:36:43'),
(15, 98, '132d5651ae74', '97.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:01:47', '2026-01-16 19:01:47'),
(16, 99, '6821e7e56d28', '25.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:08:48', '2026-01-16 19:08:48'),
(17, 99, 'b2d8093d0dbf', '20.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:35:27', '2026-01-16 19:35:27'),
(18, 99, '6821e7e56d28', '25.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:36:17', '2026-01-16 19:36:17'),
(19, 99, '6821e7e56d28', '65.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:36:25', '2026-01-16 19:36:25'),
(20, 100, '38393c8eda14', '30.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:49:31', '2026-01-16 19:49:31'),
(21, 100, '38393c8eda14', '25.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:50:09', '2026-01-16 19:50:09'),
(22, 100, '3d71ce5f4600', '50.00', 'PIX', 'CONFIRMADO', '2026-01-16 19:50:40', '2026-01-16 19:50:40'),
(23, 103, '215ba6d98c2e', '6.00', 'PIX', 'CONFIRMADO', '2026-01-16 20:52:06', '2026-01-16 20:52:06'),
(24, 104, '1b734d7c317d', '10.00', 'PIX', 'CONFIRMADO', '2026-01-16 21:17:34', '2026-01-16 21:17:34'),
(25, 105, '2a5094c5d857', '50.00', 'PIX', 'CONFIRMADO', '2026-01-17 13:37:50', '2026-01-17 13:37:50'),
(26, 106, '5c403cae2317', '120.00', 'PIX', 'CONFIRMADO', '2026-01-17 13:49:20', '2026-01-17 13:49:20'),
(27, 108, 'af393858c3fa', '82.00', 'PIX', 'CONFIRMADO', '2026-01-17 16:38:57', '2026-01-17 16:38:57'),
(28, 109, '436eb01643f3', '88.00', 'PIX', 'CONFIRMADO', '2026-01-17 16:53:25', '2026-01-17 16:53:25'),
(29, 109, '436eb01643f3', '20.00', 'PIX', 'CONFIRMADO', '2026-01-17 17:04:39', '2026-01-17 17:04:39'),
(30, 109, '436eb01643f3', '30.00', 'PIX', 'CONFIRMADO', '2026-01-17 17:14:56', '2026-01-17 17:14:56'),
(31, 110, '3aa38f2298d3', '17.00', 'PIX', 'CONFIRMADO', '2026-01-17 17:49:54', '2026-01-17 17:49:54'),
(32, 110, '3aa38f2298d3', '20.00', 'PIX', 'CONFIRMADO', '2026-01-17 17:50:07', '2026-01-17 17:50:07'),
(33, 111, '84bcf8fc7f5a', '12.00', 'PIX', 'CONFIRMADO', '2026-01-17 19:52:36', '2026-01-17 19:52:36'),
(34, 111, '84bcf8fc7f5a', '99.00', 'PIX', 'CONFIRMADO', '2026-01-17 19:53:20', '2026-01-17 19:53:20'),
(35, 113, 'b03ae2df583e', '60.00', 'PIX', 'CONFIRMADO', '2026-01-17 20:00:48', '2026-01-17 20:00:48'),
(36, 114, 'bba50be8e745', '60.00', 'PIX', 'CONFIRMADO', '2026-01-17 21:17:36', '2026-01-17 21:17:36'),
(37, 115, 'd5ee07c8ab13', '80.00', 'PIX', 'CONFIRMADO', '2026-01-17 21:41:43', '2026-01-17 21:41:43'),
(38, 116, 'e2dbad1ee965', '60.43', 'PIX', 'CONFIRMADO', '2026-01-17 23:13:53', '2026-01-17 23:13:53'),
(39, 117, 'b297ed05972b', '10.00', 'PIX', 'CONFIRMADO', '2026-01-18 15:12:58', '2026-01-18 15:12:58'),
(40, 118, 'e9ec43831c83', '76.00', 'PIX', 'CONFIRMADO', '2026-01-18 16:36:38', '2026-01-18 16:36:38'),
(41, 119, '46a14db02538', '20.00', 'PIX', 'CONFIRMADO', '2026-01-18 18:38:22', '2026-01-18 18:38:22'),
(42, 120, '1da5e6db582e', '35.50', 'PIX', 'CONFIRMADO', '2026-01-19 01:07:43', '2026-01-19 01:07:43'),
(43, 120, '1da5e6db582e', '36.50', 'PIX', 'CONFIRMADO', '2026-01-19 01:08:57', '2026-01-19 01:08:57'),
(44, 121, '2531c81cd53b', '20.00', 'PIX', 'CONFIRMADO', '2026-01-19 22:12:02', '2026-01-19 22:12:02'),
(45, 122, '3619efbf75dc', '25.00', 'PIX', 'CONFIRMADO', '2026-01-21 17:36:54', '2026-01-21 17:36:54'),
(46, 122, '3619efbf75dc', '25.00', 'PIX', 'CONFIRMADO', '2026-01-21 17:37:05', '2026-01-21 17:37:05'),
(47, 123, 'aadae712c7c9', '30.00', 'PIX', 'CONFIRMADO', '2026-01-21 17:50:56', '2026-01-21 17:50:56'),
(48, 124, '444fa97da672', '12.00', 'PIX', 'CONFIRMADO', '2026-01-21 19:02:48', '2026-01-21 19:02:48'),
(49, 125, 'e97eabae6a3e', '81.00', 'PIX', 'CONFIRMADO', '2026-01-21 23:31:42', '2026-01-21 23:31:42'),
(50, 125, 'e97eabae6a3e', '4.00', 'PIX', 'CONFIRMADO', '2026-01-21 23:31:48', '2026-01-21 23:31:48'),
(51, 125, 'e97eabae6a3e', '4.00', 'PIX', 'CONFIRMADO', '2026-01-21 23:31:55', '2026-01-21 23:31:55'),
(52, 125, 'e97eabae6a3e', '23.00', 'PIX', 'CONFIRMADO', '2026-01-21 23:32:12', '2026-01-21 23:32:12'),
(53, 125, 'e97eabae6a3e', '8.00', 'PIX', 'CONFIRMADO', '2026-01-21 23:32:16', '2026-01-21 23:32:16'),
(54, 126, '69132317c3c0', '20.00', 'PIX', 'CONFIRMADO', '2026-01-22 00:20:48', '2026-01-22 00:20:48'),
(55, 128, 'ed52552581f8', '20.00', 'PIX', 'CONFIRMADO', '2026-01-22 00:25:05', '2026-01-22 00:25:05'),
(56, 129, '3e36e023ad5a', '120.00', 'PIX', 'CONFIRMADO', '2026-01-22 00:31:06', '2026-01-22 00:31:06'),
(57, 131, '412596f763f1', '60.00', 'PIX', 'CONFIRMADO', '2026-01-22 11:17:05', '2026-01-22 11:17:05'),
(58, 133, 'e4c7c588b4f3', '15.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:20:20', '2026-01-22 16:20:20'),
(59, 133, '6fbbda4080bf', '15.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:21:03', '2026-01-22 16:21:03'),
(60, 133, 'e4c7c588b4f3', '5.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:21:55', '2026-01-22 16:21:55'),
(61, 133, '6fbbda4080bf', '47.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:21:58', '2026-01-22 16:21:58'),
(62, 134, '81a2fb922b2a', '50.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:25:38', '2026-01-22 16:25:38'),
(63, 134, '81a2fb922b2a', '32.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:26:00', '2026-01-22 16:26:00'),
(64, 135, 'efe0ed79f40c', '16.00', 'PIX', 'CONFIRMADO', '2026-01-22 16:26:26', '2026-01-22 16:26:26'),
(65, 139, '49e6a749f49e', '82.00', 'PIX', 'CONFIRMADO', '2026-01-22 17:57:03', '2026-01-22 17:57:03'),
(66, 140, '5a8f853f47f3', '31.00', 'PIX', 'CONFIRMADO', '2026-01-22 19:04:24', '2026-01-22 19:04:24'),
(67, 153, '54d83d1a5937', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 13:22:47', '2026-01-23 13:22:47'),
(68, 154, '1ed9a14b8a33', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:17:25', '2026-01-23 16:17:25'),
(69, 155, 'c83126f4bac2', '15.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:55:41', '2026-01-23 16:55:41'),
(70, 155, 'c83126f4bac2', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:56:03', '2026-01-23 16:56:03'),
(71, 157, 'af6e49576cd7', '120.00', 'PIX', 'CONFIRMADO', '2026-01-23 17:01:55', '2026-01-23 17:01:55'),
(72, 158, '431b265f3642', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 17:04:22', '2026-01-23 17:04:22'),
(73, 159, '431b265f3642', '25.00', 'PIX', 'CONFIRMADO', '2026-01-23 17:06:03', '2026-01-23 17:06:03'),
(74, 158, '21f2d3c7a231', '72.00', 'PIX', 'CONFIRMADO', '2026-01-23 17:07:04', '2026-01-23 17:07:04'),
(75, 160, '6bb08d82d35b', '25.00', 'PIX', 'CONFIRMADO', '2026-01-23 15:05:44', '2026-01-23 15:05:44'),
(76, 161, '2c6613ee6afd', '30.00', 'PIX', 'CONFIRMADO', '2026-01-23 15:13:03', '2026-01-23 15:13:03'),
(77, 165, '7b750bcec473', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 15:47:34', '2026-01-23 15:47:34'),
(78, 166, '7689a29840ed', '56.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:15:18', '2026-01-23 16:15:18'),
(79, 167, '16548da26c1b', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:41:40', '2026-01-23 16:41:40'),
(80, 167, '16548da26c1b', '25.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:42:05', '2026-01-23 16:42:05'),
(81, 168, '0b6620dea7e6', '31.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:47:51', '2026-01-23 16:47:51'),
(82, 168, 'f00fce504732', '12.00', 'PIX', 'CONFIRMADO', '2026-01-23 16:47:53', '2026-01-23 16:47:53'),
(83, 172, 'ee1e13367a4d', '37.00', 'PIX', 'CONFIRMADO', '2026-01-23 19:45:55', '2026-01-23 19:45:55'),
(84, 173, '5686cb387d6b', '41.00', 'PIX', 'CONFIRMADO', '2026-01-23 20:28:42', '2026-01-23 20:28:42'),
(85, 174, '55e0eb81272a', '5.00', 'PIX', 'CONFIRMADO', '2026-01-23 20:31:49', '2026-01-23 20:31:49'),
(86, 174, '55e0eb81272a', '5.00', 'PIX', 'CONFIRMADO', '2026-01-23 20:31:53', '2026-01-23 20:31:53'),
(87, 175, 'b077b20ca797', '34.00', 'PIX', 'CONFIRMADO', '2026-01-23 21:15:09', '2026-01-23 21:15:09'),
(88, 176, '66c0259d40b4', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 21:16:17', '2026-01-23 21:16:17'),
(89, 177, '6fd0f403a37e', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 21:31:58', '2026-01-23 21:31:58'),
(90, 177, '6fd0f403a37e', '34.00', 'PIX', 'CONFIRMADO', '2026-01-23 21:32:37', '2026-01-23 21:32:37'),
(91, 178, '054afcfdf500', '20.00', 'PIX', 'CONFIRMADO', '2026-01-23 21:56:51', '2026-01-23 21:56:51'),
(92, 178, '054afcfdf500', '191.00', 'PIX', 'CONFIRMADO', '2026-01-23 22:17:46', '2026-01-23 22:17:46'),
(93, 179, '1f88a276934d', '6.00', 'PIX', 'CONFIRMADO', '2026-01-23 22:27:27', '2026-01-23 22:27:27'),
(94, 179, 'b2d0580c738c', '10.00', 'PIX', 'CONFIRMADO', '2026-01-23 22:27:29', '2026-01-23 22:27:29'),
(95, 182, '50b296c1c37a', '88.00', 'PIX', 'CONFIRMADO', '2026-01-23 23:15:26', '2026-01-23 23:15:26'),
(96, 183, '3ef9d76118d9', '6.00', 'PIX', 'CONFIRMADO', '2026-01-23 23:23:02', '2026-01-23 23:23:02'),
(97, 185, '655d546b53d8', '85.00', 'PIX', 'CONFIRMADO', '2026-01-24 08:49:11', '2026-01-24 08:49:11'),
(98, 186, '82ab8f4e6147', '25.00', 'PIX', 'CONFIRMADO', '2026-01-24 09:31:44', '2026-01-24 09:31:44'),
(99, 188, '7afb2c13b60c', '41.00', 'PIX', 'CONFIRMADO', '2026-01-24 09:54:01', '2026-01-24 09:54:01'),
(100, 189, '7d849fea6516', '109.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:23:04', '2026-01-24 10:23:04'),
(101, 189, 'd10a5ee78090', '103.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:23:06', '2026-01-24 10:23:06'),
(102, 190, '253dce98ce08', '95.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:25:30', '2026-01-24 10:25:30'),
(103, 191, '9f2acbe25a5e', '85.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:27:06', '2026-01-24 10:27:06'),
(104, 192, '1983e79c7c49', '152.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:28:30', '2026-01-24 10:28:30'),
(105, 193, 'a50117de4d5f', '103.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:31:13', '2026-01-24 10:31:13'),
(106, 194, 'e4616c8bbdae', '92.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:41:11', '2026-01-24 10:41:11'),
(107, 194, '1ec2d7fed395', '31.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:41:13', '2026-01-24 10:41:13'),
(108, 195, '971db26a1d96', '457.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:56:40', '2026-01-24 10:56:40'),
(109, 196, '5b2300646934', '25.00', 'PIX', 'CONFIRMADO', '2026-01-24 10:59:00', '2026-01-24 10:59:00'),
(110, 197, '68a4d32a6031', '268.00', 'PIX', 'CONFIRMADO', '2026-01-24 11:46:01', '2026-01-24 11:46:01'),
(111, 197, 'c190576df6b4', '91.00', 'PIX', 'CONFIRMADO', '2026-01-24 11:46:03', '2026-01-24 11:46:03'),
(112, 197, '68a4d32a6031', '25.00', 'PIX', 'CONFIRMADO', '2026-01-24 11:46:53', '2026-01-24 11:46:53'),
(113, 198, 'c88016ef0f94', '330.00', 'PIX', 'CONFIRMADO', '2026-01-24 14:04:00', '2026-01-24 14:04:00'),
(114, 199, '9566055f909a', '16.00', 'PIX', 'CONFIRMADO', '2026-01-24 14:54:30', '2026-01-24 14:54:30'),
(115, 201, '15fd81da55b9', '50.00', 'PIX', 'CONFIRMADO', '2026-01-24 15:47:45', '2026-01-24 15:47:45'),
(116, 201, 'efe740618329', '40.00', 'PIX', 'CONFIRMADO', '2026-01-24 15:53:42', '2026-01-24 15:53:42'),
(117, 201, '15fd81da55b9', '63.00', 'PIX', 'CONFIRMADO', '2026-01-24 15:54:00', '2026-01-24 15:54:00'),
(118, 202, '7456f77aa746', '43.00', 'PIX', 'CONFIRMADO', '2026-01-24 15:56:43', '2026-01-24 15:56:43'),
(119, 202, '7456f77aa746', '66.00', 'PIX', 'CONFIRMADO', '2026-01-25 14:18:13', '2026-01-25 14:18:13'),
(120, 203, '6fd2f72588ce', '25.00', 'PIX', 'CONFIRMADO', '2026-01-25 15:04:11', '2026-01-25 15:04:11'),
(121, 203, '20e6ce388d71', '35.00', 'PIX', 'CONFIRMADO', '2026-01-25 16:31:06', '2026-01-25 16:31:06'),
(122, 203, '20e6ce388d71', '25.00', 'PIX', 'CONFIRMADO', '2026-01-25 16:31:57', '2026-01-25 16:31:57'),
(123, 203, '6fd2f72588ce', '197.00', 'PIX', 'CONFIRMADO', '2026-01-25 16:32:15', '2026-01-25 16:32:15'),
(124, 203, '6fd2f72588ce', '10.00', 'PIX', 'CONFIRMADO', '2026-01-25 16:32:52', '2026-01-25 16:32:52'),
(125, 204, '9eb2578b1955', '50.00', 'PIX', 'CONFIRMADO', '2026-01-25 19:06:55', '2026-01-25 19:06:55'),
(126, 204, '9eb2578b1955', '15.00', 'PIX', 'CONFIRMADO', '2026-01-25 19:19:58', '2026-01-25 19:19:58'),
(127, 204, '9eb2578b1955', '11.00', 'PIX', 'CONFIRMADO', '2026-01-25 19:20:16', '2026-01-25 19:20:16'),
(128, 204, '9eb2578b1955', '80.00', 'PIX', 'CONFIRMADO', '2026-01-25 19:21:42', '2026-01-25 19:21:42'),
(129, 205, '772c087f4467', '4.00', 'PIX', 'CONFIRMADO', '2026-01-25 21:58:20', '2026-01-25 21:58:20'),
(130, 205, '772c087f4467', '21.00', 'PIX', 'CONFIRMADO', '2026-01-25 21:58:47', '2026-01-25 21:58:47'),
(131, 205, '772c087f4467', '49.00', 'PIX', 'CONFIRMADO', '2026-01-25 22:16:00', '2026-01-25 22:16:00'),
(132, 205, '772c087f4467', '53.00', 'PIX', 'CONFIRMADO', '2026-01-25 22:16:44', '2026-01-25 22:16:44'),
(133, 206, 'a66e7d27cb1f', '52.00', 'PIX', 'CONFIRMADO', '2026-01-25 22:19:37', '2026-01-25 22:19:37'),
(134, 207, 'a876c0603c6a', '31.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-26 08:49:54', '2026-01-26 08:49:54'),
(137, 207, 'a876c0603c6a', '70.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-26 09:22:32', '2026-01-26 09:22:32'),
(138, 207, 'a876c0603c6a', '60.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-26 13:12:49', '2026-01-26 13:12:49'),
(139, 207, 'a876c0603c6a', '45.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-26 13:47:09', '2026-01-26 13:47:09'),
(140, 208, '6bae57877604', '82.00', 'PIX', 'CONFIRMADO', '2026-01-28 19:56:51', '2026-01-28 19:56:51'),
(141, 210, 'c4f09bc7f9a7', '30.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 19:36:16', '2026-01-29 19:36:16'),
(142, 211, '690ccb30a748', '32.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 23:14:09', '2026-01-29 23:14:09'),
(143, 211, '690ccb30a748', '37.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 23:19:13', '2026-01-29 23:19:13'),
(144, 211, '690ccb30a748', '60.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 23:20:57', '2026-01-29 23:20:57'),
(145, 211, '690ccb30a748', '46.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 23:23:02', '2026-01-29 23:23:02'),
(146, 211, '690ccb30a748', '100.00', 'DINHEIRO', 'CONFIRMADO', '2026-01-29 23:24:35', '2026-01-29 23:24:35'),
(147, 212, 'f41f06fb6fb3', '76.00', 'PIX', 'CONFIRMADO', '2026-01-30 21:28:22', '2026-01-30 21:28:22'),
(148, 213, '88142df75640', '70.00', 'PIX', 'CONFIRMADO', '2026-02-02 09:48:11', '2026-02-02 09:48:11'),
(149, 214, 'd0fbf454488c', '70.00', 'PIX', 'CONFIRMADO', '2026-02-02 09:50:54', '2026-02-02 09:50:54'),
(150, 215, '04dda86eed49', '26.00', 'PIX', 'CONFIRMADO', '2026-02-02 14:11:04', '2026-02-02 14:11:04'),
(151, 216, '529fe94b8257', '32.00', 'PIX', 'CONFIRMADO', '2026-02-02 21:12:38', '2026-02-02 21:12:38'),
(152, 217, '07dd332e2fbb', '70.00', 'PIX', 'CONFIRMADO', '2026-02-02 23:03:33', '2026-02-02 23:03:33'),
(153, 218, 'd27a2fd0ee61', '24.00', 'PIX', 'CONFIRMADO', '2026-02-03 08:14:49', '2026-02-03 08:14:49'),
(154, 221, '113d9d4054e0', '24.00', 'DINHEIRO', 'CONFIRMADO', '2026-02-03 10:40:41', '2026-02-03 10:40:41'),
(155, 223, 'd7498419bf7a', '51.00', 'PIX', 'CONFIRMADO', '2026-02-03 13:04:55', '2026-02-03 13:04:55'),
(156, 228, '873757699ec4', '64.00', 'PIX', 'CONFIRMADO', '2026-02-03 14:20:53', '2026-02-03 14:20:53'),
(157, 229, '5f6f49726a15', '37.00', 'PIX', 'CONFIRMADO', '2026-02-03 15:15:59', '2026-02-03 15:15:59'),
(158, 229, '99fdcddb886b', '46.00', 'PIX', 'CONFIRMADO', '2026-02-03 15:16:02', '2026-02-03 15:16:02'),
(159, 230, '73f87c612e06', '80.00', 'PIX', 'CONFIRMADO', '2026-02-03 15:25:30', '2026-02-03 15:25:30'),
(160, 231, '3449073a7b41', '26.00', 'PIX', 'CONFIRMADO', '2026-02-03 15:25:36', '2026-02-03 15:25:36');

-- --------------------------------------------------------

--
-- Estrutura para tabela `pagamentos_pix`
--

CREATE TABLE `pagamentos_pix` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `txid` varchar(35) NOT NULL,
  `chave_pix` varchar(120) NOT NULL,
  `beneficiario_nome` varchar(80) NOT NULL,
  `beneficiario_cidade` varchar(50) NOT NULL,
  `descricao` varchar(60) DEFAULT NULL,
  `payload` text NOT NULL,
  `copia_cola` text NOT NULL,
  `status` enum('PENDENTE','CONFIRMADO','CANCELADO','EXPIRADO') NOT NULL DEFAULT 'PENDENTE',
  `criado_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmado_em` datetime DEFAULT NULL,
  `confirmado_por` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `pagamentos_pix`
--

INSERT INTO `pagamentos_pix` (`id`, `conta_id`, `valor`, `txid`, `chave_pix`, `beneficiario_nome`, `beneficiario_cidade`, `descricao`, `payload`, `copia_cola`, `status`, `criado_em`, `confirmado_em`, `confirmado_por`) VALUES
(1, 212, '76.00', 'C212Ta05464614fe8', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Ta05464614fe86304033E', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Ta05464614fe86304033E', 'PENDENTE', '2026-01-30 10:52:13', NULL, NULL),
(2, 212, '76.00', 'C212Tc5f5e93f7f0f', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Tc5f5e93f7f0f6304C918', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Tc5f5e93f7f0f6304C918', 'PENDENTE', '2026-01-30 10:52:18', NULL, NULL),
(3, 212, '76.00', 'C212Tccc601f3fb6f', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Tccc601f3fb6f6304EB29', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540576.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C212Tccc601f3fb6f6304EB29', 'PENDENTE', '2026-01-30 10:52:22', NULL, NULL),
(4, 213, '70.00', 'C213Tb3c86cab0775', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Tb3c86cab077563041380', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Tb3c86cab077563041380', 'PENDENTE', '2026-02-02 09:02:10', NULL, NULL),
(5, 213, '70.00', 'C213T6a1703ee327c', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T6a1703ee327c6304A0DF', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T6a1703ee327c6304A0DF', 'PENDENTE', '2026-02-02 09:15:03', NULL, NULL),
(6, 213, '70.00', 'C213T86dc076446d2', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T86dc076446d26304A979', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T86dc076446d26304A979', 'PENDENTE', '2026-02-02 09:15:09', NULL, NULL),
(7, 213, '70.00', 'C213T290f85698226', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T290f856982266304B64E', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213T290f856982266304B64E', 'PENDENTE', '2026-02-02 09:15:28', NULL, NULL),
(8, 213, '70.00', 'C213Taf0c1ad92c65', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Taf0c1ad92c656304C133', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Taf0c1ad92c656304C133', 'PENDENTE', '2026-02-02 09:16:09', NULL, NULL),
(9, 213, '70.00', 'C213Tf1332f051bff', 'SUA-CHAVE-PIX-AQUI', 'SEU ESTABELECIMENTO', 'SUA CIDADE', NULL, '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Tf1332f051bff63045D94', '00020101021226400014BR.GOV.BCB.PIX0118SUA-CHAVE-PIX-AQUI520400005303986540570.005802BR5919SEU ESTABELECIMENTO6010SUA CIDADE62210517C213Tf1332f051bff63045D94', 'PENDENTE', '2026-02-02 09:19:07', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura para tabela `pedidos`
--

CREATE TABLE `pedidos` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `criado_em` datetime DEFAULT CURRENT_TIMESTAMP,
  `entregue_em` datetime DEFAULT NULL,
  `cliente_id` int DEFAULT NULL,
  `sessao_key` varchar(64) DEFAULT NULL,
  `sessao_seq` int DEFAULT NULL,
  `entregue_por` int DEFAULT NULL,
  `recusado_motivo` varchar(255) DEFAULT NULL,
  `recusado_em` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `pedidos`
--

INSERT INTO `pedidos` (`id`, `conta_id`, `status`, `criado_em`, `entregue_em`, `cliente_id`, `sessao_key`, `sessao_seq`, `entregue_por`, `recusado_motivo`, `recusado_em`) VALUES
(1, 1, 'ENTREGUE', '2026-01-14 13:19:11', '2026-01-14 13:44:46', 1, NULL, NULL, 1, NULL, NULL),
(2, 1, 'ENTREGUE', '2026-01-14 13:48:32', '2026-01-14 13:48:49', 1, NULL, NULL, 1, NULL, NULL),
(3, 2, 'ENTREGUE', '2026-01-14 16:22:39', '2026-01-14 16:23:06', 1, NULL, NULL, 1, NULL, NULL),
(4, 2, 'ENTREGUE', '2026-01-14 16:23:26', '2026-01-14 16:23:54', 1, NULL, NULL, 1, NULL, NULL),
(5, 2, 'ENTREGUE', '2026-01-14 16:24:07', '2026-01-14 16:24:12', 1, NULL, NULL, 1, NULL, NULL),
(6, 3, 'ENTREGUE', '2026-01-14 16:37:45', '2026-01-14 16:38:00', 5, NULL, NULL, 1, NULL, NULL),
(7, 4, 'ENTREGUE', '2026-01-14 16:56:20', '2026-01-14 16:58:11', 6, '6a1f7b002064757753394a897c9eb498', NULL, 1, NULL, NULL),
(8, 9, 'ENTREGUE', '2026-01-14 17:28:20', '2026-01-14 17:28:39', 8, '7fafeea709060a0b0523df54d54b8540', 1, 1, NULL, NULL),
(9, 10, 'ENTREGUE', '2026-01-14 17:33:30', '2026-01-14 17:34:22', 9, '7af7cd99c680b293b8c1072b26aade8b', 1, 1, NULL, NULL),
(10, 11, 'ENTREGUE', '2026-01-14 17:33:49', '2026-01-14 17:34:38', 10, 'ba2f466052d752bd6ad6df93cba7ba54', 1, 1, NULL, NULL),
(11, 12, 'ENTREGUE', '2026-01-14 17:47:34', '2026-01-14 17:49:20', 11, '64a64beb2c98f58a7873867b902556b3', 1, 1, NULL, NULL),
(12, 13, 'ENTREGUE', '2026-01-14 17:51:58', '2026-01-14 17:55:18', 12, '1b0743ca5c4c2e44387dc9d08600da4b', 1, NULL, NULL, NULL),
(13, 13, 'ENTREGUE', '2026-01-14 17:54:54', '2026-01-15 23:29:43', 12, '1b0743ca5c4c2e44387dc9d08600da4b', 2, NULL, NULL, NULL),
(14, 14, 'ENTREGUE', '2026-01-14 17:57:11', '2026-01-14 17:57:47', 13, '72ee1d803789e4401acfcccc649af529', 1, NULL, NULL, NULL),
(15, 15, 'ENTREGUE', '2026-01-14 18:04:14', '2026-01-14 18:04:43', 14, '719bc63bf19241d0b0215ee7908cdf33', 1, NULL, NULL, NULL),
(16, 15, 'ENTREGUE', '2026-01-14 18:04:32', '2026-01-14 18:04:42', 14, '719bc63bf19241d0b0215ee7908cdf33', 2, NULL, NULL, NULL),
(17, 16, 'ENTREGUE', '2026-01-14 18:19:24', '2026-01-14 18:25:50', 15, '50b2dd61a37250607dd524ab10f4895c', 1, NULL, NULL, NULL),
(18, 16, 'ENTREGUE', '2026-01-14 18:28:05', '2026-01-14 18:28:26', 15, '50b2dd61a37250607dd524ab10f4895c', 2, NULL, NULL, NULL),
(19, 17, 'ENTREGUE', '2026-01-14 18:32:11', '2026-01-14 18:34:12', 16, 'f2f3d3dd2a3896ee544b753ce134b463', 1, NULL, NULL, NULL),
(20, 18, 'ENTREGUE', '2026-01-14 18:33:30', '2026-01-14 18:34:13', 17, '863b1f12ce1e3f65f84d034b3e5e9812', 1, NULL, NULL, NULL),
(21, 18, 'ENTREGUE', '2026-01-14 18:35:17', '2026-01-14 18:36:00', 17, '863b1f12ce1e3f65f84d034b3e5e9812', 2, NULL, NULL, NULL),
(22, 18, 'ENTREGUE', '2026-01-14 18:36:34', '2026-01-14 18:38:05', 17, '863b1f12ce1e3f65f84d034b3e5e9812', 3, NULL, NULL, NULL),
(23, 17, 'ENTREGUE', '2026-01-14 18:37:55', '2026-01-14 18:38:06', 16, 'f2f3d3dd2a3896ee544b753ce134b463', 2, NULL, NULL, NULL),
(24, 21, 'ENTREGUE', '2026-01-14 19:29:30', '2026-01-14 19:29:49', 20, '1c9cffee9709b1ce979af2bf0cabcf3b', NULL, NULL, NULL, NULL),
(25, 22, 'ENTREGUE', '2026-01-14 19:33:07', '2026-01-14 19:33:31', 21, '3ae00d2ec5885fa6800d3eefac88c33e', NULL, NULL, NULL, NULL),
(26, 23, 'ENTREGUE', '2026-01-14 19:38:47', '2026-01-14 19:46:29', 22, '6d6f20d46e0471ef09d3d2983cd64c17', NULL, NULL, NULL, NULL),
(27, 23, 'ENTREGUE', '2026-01-14 19:39:04', '2026-01-14 19:53:40', 22, '6d6f20d46e0471ef09d3d2983cd64c17', NULL, NULL, NULL, NULL),
(28, 24, 'ENTREGUE', '2026-01-14 19:40:10', '2026-01-14 19:46:33', 23, 'e7857a45748e006fac4a5cc092d37cbd', NULL, NULL, NULL, NULL),
(29, 23, 'ENTREGUE', '2026-01-14 19:53:19', '2026-01-14 19:53:41', 22, '6d6f20d46e0471ef09d3d2983cd64c17', NULL, NULL, NULL, NULL),
(30, 24, 'ENTREGUE', '2026-01-14 19:54:03', '2026-01-14 19:54:22', 23, 'e7857a45748e006fac4a5cc092d37cbd', NULL, NULL, NULL, NULL),
(31, 26, 'ENTREGUE', '2026-01-14 20:07:02', '2026-01-14 20:07:26', 25, 'fbd854bc72f7', NULL, NULL, NULL, NULL),
(32, 27, 'ENTREGUE', '2026-01-14 23:36:43', '2026-01-14 23:37:14', 26, '3ced6ab70c4e', NULL, NULL, NULL, NULL),
(33, 28, 'ENTREGUE', '2026-01-14 23:40:09', '2026-01-14 23:40:24', 27, '1427fbc4d0cf', NULL, NULL, NULL, NULL),
(34, 29, 'ENTREGUE', '2026-01-15 00:08:38', '2026-01-15 00:08:56', 28, 'cd0c5044c52e', NULL, NULL, NULL, NULL),
(35, 29, 'ENTREGUE', '2026-01-15 00:09:22', '2026-01-15 00:09:35', 28, 'cd0c5044c52e', NULL, NULL, NULL, NULL),
(36, 30, 'ENTREGUE', '2026-01-15 00:10:37', '2026-01-15 00:10:47', 29, '88e96a25ae49', NULL, NULL, NULL, NULL),
(37, 31, 'ENTREGUE', '2026-01-15 00:46:12', '2026-01-15 00:46:31', 30, '6c08113a195d', NULL, NULL, NULL, NULL),
(38, 31, 'ENTREGUE', '2026-01-15 00:46:45', '2026-01-15 00:47:06', 30, '6c08113a195d', NULL, NULL, NULL, NULL),
(39, 32, 'ENTREGUE', '2026-01-15 00:48:17', '2026-01-15 00:48:47', 31, '79c2d295d970', NULL, NULL, NULL, NULL),
(40, 32, 'ENTREGUE', '2026-01-15 00:50:11', '2026-01-15 00:50:46', 31, '79c2d295d970', NULL, NULL, NULL, NULL),
(41, 33, 'ENTREGUE', '2026-01-15 01:03:18', '2026-01-15 01:03:44', 32, '17ba8c584af3', NULL, NULL, NULL, NULL),
(42, 33, 'ENTREGUE', '2026-01-15 01:04:09', '2026-01-15 01:04:48', 32, '17ba8c584af3', NULL, NULL, NULL, NULL),
(43, 33, 'ENTREGUE', '2026-01-15 01:05:28', '2026-01-15 01:07:12', 32, '17ba8c584af3', NULL, NULL, NULL, NULL),
(44, 34, 'ENTREGUE', '2026-01-15 01:16:33', '2026-01-15 01:16:56', 33, '66dd3380865f', NULL, NULL, NULL, NULL),
(45, 35, 'ENTREGUE', '2026-01-15 01:20:27', '2026-01-15 01:20:49', 35, 'd673f746cfe1', NULL, NULL, NULL, NULL),
(46, 35, 'ENTREGUE', '2026-01-15 01:21:38', '2026-01-15 01:22:03', 34, '52e4c3553272', NULL, NULL, NULL, NULL),
(47, 36, 'ENTREGUE', '2026-01-15 01:37:20', '2026-01-15 01:37:32', NULL, '908dc606d6ff', NULL, NULL, NULL, NULL),
(48, 36, 'ENTREGUE', '2026-01-15 01:48:15', '2026-01-15 01:48:32', NULL, '0e95813b0325', NULL, NULL, NULL, NULL),
(49, 37, 'ENTREGUE', '2026-01-15 02:01:42', '2026-01-15 02:02:50', NULL, '151d3b444b94', NULL, NULL, NULL, NULL),
(50, 37, 'ENTREGUE', '2026-01-15 02:01:42', '2026-01-15 02:02:35', NULL, '8e57a723077b', NULL, NULL, NULL, NULL),
(51, 38, 'ENTREGUE', '2026-01-15 10:36:34', '2026-01-15 10:37:19', NULL, '49082d48992d', NULL, NULL, NULL, NULL),
(52, 38, 'ENTREGUE', '2026-01-15 10:39:14', '2026-01-15 10:39:29', NULL, '9465fe6916da', NULL, NULL, NULL, NULL),
(53, 39, 'ENTREGUE', '2026-01-15 10:52:49', '2026-01-15 10:52:57', NULL, '7a219abf2f94', NULL, NULL, NULL, NULL),
(54, 40, 'ENTREGUE', '2026-01-15 11:11:49', '2026-01-15 23:29:39', NULL, 'e3f0a6e3ec86', NULL, NULL, NULL, NULL),
(55, 41, 'ENTREGUE', '2026-01-15 11:13:55', '2026-01-15 11:14:21', NULL, '5abb344ab929', NULL, NULL, NULL, NULL),
(56, 42, 'ENTREGUE', '2026-01-15 11:15:36', '2026-01-15 11:15:43', NULL, '98560eeeb609', NULL, NULL, NULL, NULL),
(57, 42, 'ENTREGUE', '2026-01-15 11:15:58', '2026-01-15 11:16:04', NULL, '98560eeeb609', NULL, NULL, NULL, NULL),
(58, 43, 'ENTREGUE', '2026-01-15 11:29:16', '2026-01-15 11:29:25', NULL, 'feaa49406457', NULL, NULL, NULL, NULL),
(59, 43, 'ENTREGUE', '2026-01-15 11:30:30', '2026-01-15 11:30:36', NULL, 'feaa49406457', NULL, NULL, NULL, NULL),
(60, 44, 'ENTREGUE', '2026-01-15 11:41:59', '2026-01-15 11:42:05', NULL, '116e2fc4ec75', NULL, NULL, NULL, NULL),
(61, 44, 'ENTREGUE', '2026-01-15 11:44:01', '2026-01-15 11:44:06', NULL, '116e2fc4ec75', NULL, NULL, NULL, NULL),
(62, 44, 'ENTREGUE', '2026-01-15 11:45:44', '2026-01-15 11:45:52', NULL, '116e2fc4ec75', NULL, NULL, NULL, NULL),
(63, 45, 'ENTREGUE', '2026-01-15 12:08:47', '2026-01-15 12:09:17', NULL, '11173ca56f66', NULL, NULL, NULL, NULL),
(64, 45, 'ENTREGUE', '2026-01-15 12:10:47', '2026-01-15 12:11:12', NULL, '11173ca56f66', NULL, NULL, NULL, NULL),
(65, 45, 'ENTREGUE', '2026-01-15 12:11:29', '2026-01-15 12:11:34', NULL, '11173ca56f66', NULL, NULL, NULL, NULL),
(66, 46, 'ENTREGUE', '2026-01-15 12:26:01', '2026-01-15 12:26:10', NULL, '00592b4c44fc', NULL, NULL, NULL, NULL),
(67, 47, 'ENTREGUE', '2026-01-15 12:27:15', '2026-01-15 12:27:22', NULL, '499f59dd1b8c', NULL, NULL, NULL, NULL),
(68, 48, 'ENTREGUE', '2026-01-15 12:39:00', '2026-01-15 12:40:08', NULL, '7f230b512964', NULL, NULL, NULL, NULL),
(69, 49, 'CANCELADO', '2026-01-15 12:45:14', NULL, NULL, 'ea9cb5d82394', NULL, NULL, 'TESTE', '2026-01-15 12:45:24'),
(70, 49, 'ENTREGUE', '2026-01-15 12:45:49', '2026-01-15 12:45:53', NULL, 'ea9cb5d82394', NULL, NULL, NULL, NULL),
(71, 50, 'ENTREGUE', '2026-01-15 12:56:35', '2026-01-15 12:56:43', NULL, '038ced36fcbf', NULL, NULL, NULL, NULL),
(72, 51, 'ENTREGUE', '2026-01-15 13:07:34', '2026-01-15 13:08:00', NULL, '82d2ea350005', NULL, NULL, NULL, NULL),
(73, 52, 'ENTREGUE', '2026-01-15 13:18:54', '2026-01-15 13:18:58', NULL, '491a1920d536', NULL, NULL, NULL, NULL),
(74, 53, 'ENTREGUE', '2026-01-15 13:21:51', '2026-01-15 13:22:06', NULL, 'a61eb80bead0', NULL, NULL, NULL, NULL),
(75, 54, 'ENTREGUE', '2026-01-15 13:31:45', '2026-01-15 13:31:50', NULL, '3a9b8db69421', NULL, NULL, NULL, NULL),
(76, 56, 'ENTREGUE', '2026-01-15 13:50:19', '2026-01-15 13:50:23', NULL, 'f053636c1ebc', NULL, NULL, NULL, NULL),
(77, 56, 'ENTREGUE', '2026-01-15 13:50:51', '2026-01-15 13:51:03', NULL, '4bc54e90f739', NULL, NULL, NULL, NULL),
(78, 57, 'ENTREGUE', '2026-01-15 13:52:03', '2026-01-15 13:52:15', NULL, 'f053636c1ebc', NULL, NULL, NULL, NULL),
(79, 58, 'ENTREGUE', '2026-01-15 13:54:41', '2026-01-15 13:54:47', NULL, 'f053636c1ebc', NULL, NULL, NULL, NULL),
(80, 59, 'ENTREGUE', '2026-01-15 13:58:01', '2026-01-15 13:58:12', NULL, '4bc54e90f739', NULL, NULL, NULL, NULL),
(81, 60, 'ENTREGUE', '2026-01-15 14:24:28', '2026-01-15 16:09:40', NULL, 'a4e8172979ef', NULL, NULL, NULL, NULL),
(82, 61, 'ENTREGUE', '2026-01-15 16:26:37', '2026-01-15 16:26:47', NULL, '1bc6fa002624', NULL, NULL, NULL, NULL),
(83, 62, 'ENTREGUE', '2026-01-15 16:29:52', '2026-01-15 16:30:09', NULL, '10ffbc590d7f', NULL, NULL, NULL, NULL),
(84, 63, 'ENTREGUE', '2026-01-15 16:30:40', '2026-01-15 16:30:48', NULL, '10ffbc590d7f', NULL, NULL, NULL, NULL),
(85, 64, 'ENTREGUE', '2026-01-15 16:34:59', '2026-01-15 16:35:03', NULL, '10ffbc590d7f', NULL, NULL, NULL, NULL),
(86, 65, 'ENTREGUE', '2026-01-15 16:54:29', '2026-01-15 16:54:37', NULL, NULL, 1, NULL, NULL, NULL),
(87, 65, 'ENTREGUE', '2026-01-15 16:57:28', '2026-01-15 16:57:33', NULL, '7f37ca4d0e8f', NULL, NULL, NULL, NULL),
(88, 66, 'ENTREGUE', '2026-01-15 17:13:02', '2026-01-15 17:13:09', NULL, 'fc066e725e4e', NULL, NULL, NULL, NULL),
(89, 67, 'ENTREGUE', '2026-01-15 17:33:40', '2026-01-15 17:33:47', NULL, 'e2317987b631', NULL, NULL, NULL, NULL),
(90, 68, 'ENTREGUE', '2026-01-15 17:46:25', '2026-01-15 17:46:55', NULL, 'f4c61f61ecad', NULL, NULL, NULL, NULL),
(91, 68, 'ENTREGUE', '2026-01-15 17:46:38', '2026-01-15 17:46:57', NULL, '475375fe198c', NULL, NULL, NULL, NULL),
(92, 69, 'ENTREGUE', '2026-01-15 18:06:28', '2026-01-15 18:07:08', NULL, '63dde023aa72', NULL, NULL, NULL, NULL),
(93, 69, 'ENTREGUE', '2026-01-15 18:06:46', '2026-01-15 18:07:06', NULL, 'cebc9a79c92b', NULL, NULL, NULL, NULL),
(94, 70, 'ENTREGUE', '2026-01-15 18:27:13', '2026-01-15 18:27:17', NULL, '564b42bd23ac', NULL, NULL, NULL, NULL),
(95, 71, 'ENTREGUE', '2026-01-15 18:39:50', '2026-01-15 18:39:56', NULL, 'f88db6e6ccdc', NULL, NULL, NULL, NULL),
(96, 72, 'ENTREGUE', '2026-01-15 19:24:38', '2026-01-15 19:25:05', NULL, '3578342caef8', NULL, NULL, NULL, NULL),
(97, 73, 'ENTREGUE', '2026-01-15 19:51:54', '2026-01-15 19:52:01', NULL, 'e17fa74090f1', NULL, NULL, NULL, NULL),
(98, 74, 'ENTREGUE', '2026-01-15 20:05:17', '2026-01-15 20:05:24', NULL, 'b481ba6ac419', NULL, NULL, NULL, NULL),
(99, 75, 'ENTREGUE', '2026-01-15 20:58:30', '2026-01-15 20:58:41', NULL, 'ac0d32925e7c', NULL, NULL, NULL, NULL),
(100, 76, 'ENTREGUE', '2026-01-15 21:52:09', '2026-01-15 21:53:07', NULL, '4431a348a2ec', NULL, NULL, NULL, NULL),
(101, 77, 'ENTREGUE', '2026-01-15 22:28:21', '2026-01-15 22:30:20', NULL, 'ffadf64bc8c9', NULL, NULL, NULL, NULL),
(102, 77, 'ENTREGUE', '2026-01-15 22:29:34', '2026-01-15 22:30:10', NULL, '10e915d10972', NULL, NULL, NULL, NULL),
(103, 78, 'ENTREGUE', '2026-01-15 22:55:49', '2026-01-15 22:55:59', NULL, 'd69629ec281e', NULL, NULL, NULL, NULL),
(104, 79, 'ENTREGUE', '2026-01-15 22:57:50', '2026-01-15 22:57:58', NULL, 'd69629ec281e', NULL, NULL, NULL, NULL),
(105, 80, 'ENTREGUE', '2026-01-15 23:03:18', '2026-01-15 23:03:26', NULL, 'd69629ec281e', NULL, NULL, NULL, NULL),
(106, 81, 'ENTREGUE', '2026-01-15 23:14:37', '2026-01-15 23:15:04', NULL, 'd69629ec281e', NULL, NULL, NULL, NULL),
(107, 82, 'ENTREGUE', '2026-01-16 00:26:52', '2026-01-16 00:27:01', NULL, '75c6596f5187', NULL, NULL, NULL, NULL),
(108, 83, 'ENTREGUE', '2026-01-16 00:33:20', '2026-01-16 00:33:29', NULL, '75c6596f5187', NULL, NULL, NULL, NULL),
(109, 85, 'ENTREGUE', '2026-01-16 01:07:30', '2026-01-16 01:07:39', NULL, '03608080eb73', NULL, NULL, NULL, NULL),
(110, 85, 'CANCELADO', '2026-01-16 01:09:12', NULL, NULL, '03608080eb73', NULL, NULL, 'Não tem peixe', '2026-01-16 01:10:10'),
(111, 86, 'ENTREGUE', '2026-01-16 01:17:53', '2026-01-16 01:18:00', NULL, '2f7517463e74', NULL, NULL, NULL, NULL),
(112, 86, 'ENTREGUE', '2026-01-16 01:18:49', '2026-01-16 01:19:24', NULL, '2f7517463e74', NULL, NULL, NULL, NULL),
(113, 87, 'ENTREGUE', '2026-01-16 16:36:14', '2026-01-16 16:36:22', NULL, 'bdf23bcc66a4', NULL, NULL, NULL, NULL),
(114, 88, 'ENTREGUE', '2026-01-16 16:57:45', '2026-01-16 16:57:55', NULL, '71a442408b0b', NULL, NULL, NULL, NULL),
(115, 89, 'ENTREGUE', '2026-01-16 17:25:45', '2026-01-16 17:25:50', NULL, '78d3183007ac', NULL, NULL, NULL, NULL),
(116, 91, 'ENTREGUE', '2026-01-16 17:31:17', '2026-01-16 17:31:23', NULL, '78155de3e80b', NULL, NULL, NULL, NULL),
(117, 92, 'ENTREGUE', '2026-01-16 17:36:56', '2026-01-16 17:37:01', NULL, 'ad8ffcb04636', NULL, NULL, NULL, NULL),
(118, 93, 'ENTREGUE', '2026-01-16 17:38:03', '2026-01-16 17:38:11', NULL, 'ad8ffcb04636', NULL, NULL, NULL, NULL),
(119, 94, 'ENTREGUE', '2026-01-16 17:43:48', '2026-01-16 17:43:55', NULL, '71aca4e283e8', NULL, NULL, NULL, NULL),
(120, 95, 'ENTREGUE', '2026-01-16 17:49:23', '2026-01-16 17:49:29', NULL, '4b6c968094cb', NULL, NULL, NULL, NULL),
(121, 96, 'ENTREGUE', '2026-01-16 18:01:45', '2026-01-16 18:02:24', NULL, '4f82bd63a313', NULL, NULL, NULL, NULL),
(122, 97, 'ENTREGUE', '2026-01-16 18:28:30', '2026-01-16 18:28:36', NULL, 'd03df48be766', NULL, NULL, NULL, NULL),
(123, 98, 'ENTREGUE', '2026-01-16 19:00:22', '2026-01-16 19:00:54', NULL, '132d5651ae74', NULL, NULL, NULL, NULL),
(124, 99, 'ENTREGUE', '2026-01-16 19:04:05', '2026-01-16 19:08:22', NULL, '6821e7e56d28', NULL, NULL, NULL, NULL),
(125, 99, 'ENTREGUE', '2026-01-16 19:10:42', '2026-01-16 19:27:12', NULL, '6821e7e56d28', NULL, NULL, NULL, NULL),
(126, 99, 'ENTREGUE', '2026-01-16 19:15:26', '2026-01-16 19:16:48', NULL, 'b2d8093d0dbf', NULL, NULL, NULL, NULL),
(127, 100, 'ENTREGUE', '2026-01-16 19:43:45', '2026-01-16 19:45:30', NULL, '3d71ce5f4600', NULL, NULL, NULL, NULL),
(128, 100, 'ENTREGUE', '2026-01-16 19:45:03', '2026-01-16 19:45:32', NULL, '38393c8eda14', NULL, NULL, NULL, NULL),
(129, 100, 'ENTREGUE', '2026-01-16 19:45:53', '2026-01-16 19:46:05', NULL, '38393c8eda14', NULL, NULL, NULL, NULL),
(130, 103, 'ENTREGUE', '2026-01-16 20:49:22', '2026-01-16 20:50:40', NULL, '215ba6d98c2e', NULL, NULL, NULL, NULL),
(131, 104, 'ENTREGUE', '2026-01-16 21:15:46', '2026-01-16 21:16:27', NULL, '1b734d7c317d', NULL, NULL, NULL, NULL),
(132, 105, 'ENTREGUE', '2026-01-17 12:26:24', '2026-01-17 13:37:02', NULL, '2a5094c5d857', NULL, NULL, NULL, NULL),
(133, 106, 'ENTREGUE', '2026-01-17 13:48:11', '2026-01-17 13:49:03', NULL, '5c403cae2317', NULL, NULL, NULL, NULL),
(134, 108, 'ENTREGUE', '2026-01-17 16:37:41', '2026-01-17 16:38:15', NULL, 'af393858c3fa', NULL, NULL, NULL, NULL),
(135, 109, 'ENTREGUE', '2026-01-17 16:46:07', '2026-01-17 16:50:12', NULL, '436eb01643f3', NULL, NULL, NULL, NULL),
(136, 109, 'ENTREGUE', '2026-01-17 16:49:43', '2026-01-17 16:52:03', NULL, '436eb01643f3', NULL, NULL, NULL, NULL),
(137, 109, 'ENTREGUE', '2026-01-17 17:05:00', '2026-01-17 17:11:58', NULL, '436eb01643f3', NULL, NULL, NULL, NULL),
(138, 110, 'ENTREGUE', '2026-01-17 17:21:16', '2026-01-17 17:21:26', NULL, '3aa38f2298d3', NULL, NULL, NULL, NULL),
(139, 110, 'ACEITO', '2026-01-17 17:29:45', NULL, NULL, '3aa38f2298d3', NULL, NULL, NULL, NULL),
(140, 111, 'ENTREGUE', '2026-01-17 19:44:29', '2026-01-17 19:48:20', NULL, '84bcf8fc7f5a', NULL, NULL, NULL, NULL),
(141, 111, 'ENTREGUE', '2026-01-17 19:45:41', '2026-01-17 19:51:10', NULL, '84bcf8fc7f5a', NULL, NULL, NULL, NULL),
(142, 113, 'ENTREGUE', '2026-01-17 19:58:51', '2026-01-17 20:00:25', NULL, 'b03ae2df583e', NULL, NULL, NULL, NULL),
(143, 114, 'ENTREGUE', '2026-01-17 20:15:54', '2026-01-17 21:17:23', NULL, 'bba50be8e745', NULL, NULL, NULL, NULL),
(144, 115, 'ENTREGUE', '2026-01-17 21:29:34', '2026-01-17 21:41:13', NULL, 'd5ee07c8ab13', NULL, NULL, NULL, NULL),
(145, 115, 'ENTREGUE', '2026-01-17 21:39:09', '2026-01-17 21:41:24', NULL, 'd5ee07c8ab13', NULL, NULL, NULL, NULL),
(146, 116, 'ENTREGUE', '2026-01-17 23:06:09', '2026-01-17 23:06:18', NULL, 'e2dbad1ee965', NULL, NULL, NULL, NULL),
(147, 117, 'ENTREGUE', '2026-01-18 15:12:14', '2026-01-18 15:12:46', NULL, 'b297ed05972b', NULL, NULL, NULL, NULL),
(148, 118, 'ENTREGUE', '2026-01-18 15:15:20', '2026-01-18 15:15:35', NULL, 'e9ec43831c83', NULL, NULL, NULL, NULL),
(149, 119, 'ENTREGUE', '2026-01-18 18:37:51', '2026-01-18 18:38:06', NULL, '46a14db02538', NULL, NULL, NULL, NULL),
(150, 120, 'ENTREGUE', '2026-01-19 01:07:07', '2026-01-19 01:07:23', NULL, '1da5e6db582e', NULL, NULL, NULL, NULL),
(151, 121, 'ENTREGUE', '2026-01-19 22:11:28', '2026-01-19 22:11:40', NULL, '2531c81cd53b', NULL, NULL, NULL, NULL),
(152, 122, 'ENTREGUE', '2026-01-21 17:36:04', '2026-01-21 17:36:29', NULL, '3619efbf75dc', NULL, NULL, NULL, NULL),
(153, 122, 'ENTREGUE', '2026-01-21 17:36:13', '2026-01-21 17:36:30', NULL, '3619efbf75dc', NULL, NULL, NULL, NULL),
(154, 123, 'ENTREGUE', '2026-01-21 17:50:31', '2026-01-21 17:50:42', NULL, 'aadae712c7c9', NULL, NULL, NULL, NULL),
(155, 124, 'ENTREGUE', '2026-01-21 19:02:38', '2026-01-21 19:02:43', NULL, '444fa97da672', NULL, NULL, NULL, NULL),
(156, 125, 'ENTREGUE', '2026-01-21 23:24:52', '2026-01-21 23:25:49', NULL, 'e97eabae6a3e', NULL, NULL, NULL, NULL),
(157, 125, 'ENTREGUE', '2026-01-21 23:26:12', '2026-01-21 23:26:28', NULL, 'e97eabae6a3e', NULL, NULL, NULL, NULL),
(158, 126, 'ENTREGUE', '2026-01-21 23:38:44', '2026-01-22 00:20:39', NULL, '69132317c3c0', NULL, NULL, NULL, NULL),
(159, 128, 'ENTREGUE', '2026-01-22 00:24:15', '2026-01-22 00:24:46', NULL, 'ed52552581f8', NULL, NULL, NULL, NULL),
(160, 129, 'ENTREGUE', '2026-01-22 00:28:04', '2026-01-22 00:28:28', NULL, '3e36e023ad5a', NULL, NULL, NULL, NULL),
(161, 131, 'ENTREGUE', '2026-01-22 01:25:34', '2026-01-22 01:25:44', NULL, '412596f763f1', NULL, NULL, NULL, NULL),
(162, 133, 'ENTREGUE', '2026-01-22 16:17:32', '2026-01-22 16:17:41', NULL, '6fbbda4080bf', NULL, NULL, NULL, NULL),
(163, 133, 'ENTREGUE', '2026-01-22 16:18:36', '2026-01-22 16:18:53', NULL, 'e4c7c588b4f3', NULL, NULL, NULL, NULL),
(164, 134, 'ENTREGUE', '2026-01-22 16:23:53', '2026-01-22 16:24:02', NULL, '81a2fb922b2a', NULL, NULL, NULL, NULL),
(165, 135, 'ENTREGUE', '2026-01-22 16:25:01', '2026-01-22 16:25:08', NULL, 'efe0ed79f40c', NULL, NULL, NULL, NULL),
(166, 139, 'ENTREGUE', '2026-01-22 17:51:47', '2026-01-22 17:52:49', NULL, '49e6a749f49e', NULL, NULL, NULL, NULL),
(167, 140, 'ENTREGUE', '2026-01-22 19:04:14', '2026-01-22 19:04:18', NULL, '5a8f853f47f3', NULL, NULL, NULL, NULL),
(168, 141, 'ENVIADO', '2026-01-22 21:07:19', NULL, NULL, '1fdc44038f74', NULL, NULL, NULL, NULL),
(169, 142, 'ENVIADO', '2026-01-22 23:35:26', NULL, NULL, '2b0a3501d231', NULL, NULL, NULL, NULL),
(170, 153, 'ENTREGUE', '2026-01-23 13:22:21', '2026-01-23 13:22:40', 7, '54d83d1a5937', NULL, NULL, NULL, NULL),
(171, 154, 'ENTREGUE', '2026-01-23 16:16:30', '2026-01-23 16:17:10', 8, '1ed9a14b8a33', NULL, NULL, NULL, NULL),
(172, 155, 'ENTREGUE', '2026-01-23 16:54:40', '2026-01-23 16:55:10', 9, 'c83126f4bac2', NULL, NULL, NULL, NULL),
(173, 156, 'ENVIADO', '2026-01-23 16:59:58', NULL, 10, 'f7943fbdc338', NULL, NULL, NULL, NULL),
(174, 157, 'ENTREGUE', '2026-01-23 17:01:24', '2026-01-23 17:01:40', 11, 'af6e49576cd7', NULL, NULL, NULL, NULL),
(175, 158, 'ENTREGUE', '2026-01-23 17:02:44', '2026-01-23 17:03:02', 12, '431b265f3642', NULL, NULL, NULL, NULL),
(176, 158, 'ENTREGUE', '2026-01-23 17:02:53', '2026-01-23 17:03:03', 13, '21f2d3c7a231', NULL, NULL, NULL, NULL),
(177, 159, 'ENTREGUE', '2026-01-23 17:04:45', '2026-01-23 17:04:52', 12, '431b265f3642', NULL, NULL, NULL, NULL),
(178, 160, 'ENTREGUE', '2026-01-23 15:04:47', '2026-01-23 15:05:20', 14, '6bb08d82d35b', NULL, NULL, NULL, NULL),
(179, 160, 'ENTREGUE', '2026-01-23 15:05:03', '2026-01-23 15:05:18', 14, '6bb08d82d35b', NULL, NULL, NULL, NULL),
(180, 161, 'ENTREGUE', '2026-01-23 15:07:12', '2026-01-23 15:12:36', 15, '2c6613ee6afd', NULL, NULL, NULL, NULL),
(181, 161, 'ENTREGUE', '2026-01-23 15:09:36', '2026-01-23 15:12:37', 15, '2c6613ee6afd', NULL, NULL, NULL, NULL),
(182, 161, 'ENTREGUE', '2026-01-23 15:10:26', '2026-01-23 15:12:40', 15, '2c6613ee6afd', NULL, NULL, NULL, NULL),
(183, 163, 'ENVIADO', '2026-01-23 15:26:23', NULL, 17, '4bd8c9259c0a', NULL, NULL, NULL, NULL),
(184, 164, 'ENVIADO', '2026-01-23 15:28:49', NULL, 19, '0335e8c9082e', NULL, NULL, NULL, NULL),
(185, 165, 'ENTREGUE', '2026-01-23 15:46:50', '2026-01-23 15:47:22', 20, '7b750bcec473', NULL, NULL, NULL, NULL),
(186, 166, 'ENTREGUE', '2026-01-23 16:04:07', '2026-01-23 16:14:48', 21, '7689a29840ed', NULL, NULL, NULL, NULL),
(187, 167, 'ENTREGUE', '2026-01-23 16:39:44', '2026-01-23 16:39:59', 24, '16548da26c1b', NULL, NULL, NULL, NULL),
(188, 168, 'ENTREGUE', '2026-01-23 16:43:50', '2026-01-23 16:45:13', 27, '0b6620dea7e6', NULL, NULL, NULL, NULL),
(189, 168, 'ENTREGUE', '2026-01-23 16:45:33', '2026-01-23 16:45:37', 26, 'f00fce504732', NULL, NULL, NULL, NULL),
(192, 172, 'ENTREGUE', '2026-01-23 19:43:31', '2026-01-23 19:45:21', 32, 'ee1e13367a4d', NULL, NULL, NULL, NULL),
(196, 173, 'ENTREGUE', '2026-01-23 20:26:20', '2026-01-23 20:26:48', 33, '5686cb387d6b', NULL, NULL, NULL, NULL),
(197, 173, 'ENTREGUE', '2026-01-23 20:27:24', '2026-01-23 20:27:59', 33, '5686cb387d6b', NULL, NULL, NULL, NULL),
(198, 174, 'ENTREGUE', '2026-01-23 20:30:37', '2026-01-23 20:31:34', 34, '55e0eb81272a', NULL, NULL, NULL, NULL),
(199, 175, 'ENTREGUE', '2026-01-23 20:35:06', '2026-01-23 20:35:11', 35, 'b077b20ca797', NULL, NULL, NULL, NULL),
(200, 175, 'ENTREGUE', '2026-01-23 20:41:40', '2026-01-23 20:41:53', 35, 'b077b20ca797', NULL, NULL, NULL, NULL),
(201, 176, 'ENTREGUE', '2026-01-23 21:15:57', '2026-01-23 21:16:09', 36, '66c0259d40b4', NULL, NULL, NULL, NULL),
(202, 177, 'ENTREGUE', '2026-01-23 21:24:53', '2026-01-23 21:31:48', 37, '6fd0f403a37e', NULL, NULL, NULL, NULL),
(203, 178, 'ENTREGUE', '2026-01-23 21:49:44', '2026-01-23 21:56:42', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(204, 178, 'ENTREGUE', '2026-01-23 21:50:04', '2026-01-23 21:56:39', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(205, 178, 'ENTREGUE', '2026-01-23 22:01:12', '2026-01-23 22:02:32', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(206, 178, 'ENTREGUE', '2026-01-23 22:01:30', '2026-01-23 22:02:33', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(207, 178, 'ENTREGUE', '2026-01-23 22:05:06', '2026-01-23 22:07:37', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(208, 178, 'ENTREGUE', '2026-01-23 22:07:55', '2026-01-23 22:08:11', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(209, 178, 'ENTREGUE', '2026-01-23 22:11:38', '2026-01-23 22:11:58', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(210, 178, 'ENTREGUE', '2026-01-23 22:12:24', '2026-01-23 22:12:30', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(211, 178, 'ENTREGUE', '2026-01-23 22:16:44', '2026-01-23 22:17:23', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(212, 178, 'ENTREGUE', '2026-01-23 22:16:56', '2026-01-23 22:17:25', 38, '054afcfdf500', NULL, NULL, NULL, NULL),
(213, 179, 'ENTREGUE', '2026-01-23 22:22:21', '2026-01-23 22:22:27', 39, '1f88a276934d', NULL, NULL, NULL, NULL),
(214, 179, 'ENTREGUE', '2026-01-23 22:26:38', '2026-01-23 22:26:44', 40, 'b2d0580c738c', NULL, NULL, NULL, NULL),
(215, 182, 'ENTREGUE', '2026-01-23 23:13:34', '2026-01-23 23:13:41', 44, '50b296c1c37a', NULL, NULL, NULL, NULL),
(216, 182, 'NOVO', '2026-01-23 23:13:57', NULL, 44, '50b296c1c37a', NULL, NULL, NULL, NULL),
(217, 183, 'ENTREGUE', '2026-01-23 23:22:36', '2026-01-23 23:22:42', 45, '3ef9d76118d9', NULL, NULL, NULL, NULL),
(218, 185, 'ENTREGUE', '2026-01-24 08:46:38', '2026-01-24 08:47:37', 49, '655d546b53d8', NULL, NULL, NULL, NULL),
(219, 185, 'ENTREGUE', '2026-01-24 08:47:19', '2026-01-24 08:47:36', 49, '655d546b53d8', NULL, NULL, NULL, NULL),
(220, 185, 'ENTREGUE', '2026-01-24 08:48:15', '2026-01-24 08:48:49', 49, '655d546b53d8', NULL, NULL, NULL, NULL),
(221, 186, 'ENTREGUE', '2026-01-24 09:30:20', '2026-01-24 09:31:26', 50, '82ab8f4e6147', NULL, NULL, NULL, NULL),
(222, 188, 'ENTREGUE', '2026-01-24 09:52:42', '2026-01-24 09:53:53', 52, '7afb2c13b60c', NULL, NULL, NULL, NULL),
(223, 189, 'ENTREGUE', '2026-01-24 10:00:41', '2026-01-24 10:22:42', 53, 'd10a5ee78090', NULL, NULL, NULL, NULL),
(224, 189, 'ENTREGUE', '2026-01-24 10:22:36', '2026-01-24 10:22:46', 54, '7d849fea6516', NULL, NULL, NULL, NULL),
(225, 190, 'ENTREGUE', '2026-01-24 10:23:41', '2026-01-24 10:25:22', 55, '253dce98ce08', NULL, NULL, NULL, NULL),
(226, 190, 'ENTREGUE', '2026-01-24 10:25:02', '2026-01-24 10:25:23', 55, '253dce98ce08', NULL, NULL, NULL, NULL),
(227, 191, 'ENTREGUE', '2026-01-24 10:26:01', '2026-01-24 10:26:48', 56, '9f2acbe25a5e', NULL, NULL, NULL, NULL),
(228, 191, 'ENTREGUE', '2026-01-24 10:26:33', '2026-01-24 10:26:49', 56, '9f2acbe25a5e', NULL, NULL, NULL, NULL),
(229, 192, 'ENTREGUE', '2026-01-24 10:27:43', '2026-01-24 10:28:09', 57, '1983e79c7c49', NULL, NULL, NULL, NULL),
(230, 192, 'ENTREGUE', '2026-01-24 10:28:12', '2026-01-24 10:28:19', 57, '1983e79c7c49', NULL, NULL, NULL, NULL),
(231, 193, 'ENTREGUE', '2026-01-24 10:30:49', '2026-01-24 10:31:06', 58, 'a50117de4d5f', NULL, NULL, NULL, NULL),
(232, 194, 'ENTREGUE', '2026-01-24 10:39:25', '2026-01-24 10:40:18', 59, 'e4616c8bbdae', NULL, NULL, NULL, NULL),
(233, 194, 'ENTREGUE', '2026-01-24 10:40:46', '2026-01-24 10:40:54', 60, '1ec2d7fed395', NULL, NULL, NULL, NULL),
(234, 195, 'ENTREGUE', '2026-01-24 10:43:05', '2026-01-24 10:43:35', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(235, 195, 'ENTREGUE', '2026-01-24 10:44:20', '2026-01-24 10:56:26', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(236, 195, 'ENTREGUE', '2026-01-24 10:45:36', '2026-01-24 10:56:21', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(237, 195, 'ENTREGUE', '2026-01-24 10:52:22', '2026-01-24 10:56:22', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(238, 195, 'ENTREGUE', '2026-01-24 10:53:45', '2026-01-24 10:56:24', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(239, 195, 'ENTREGUE', '2026-01-24 10:56:14', '2026-01-24 10:56:24', 61, '971db26a1d96', NULL, NULL, NULL, NULL),
(240, 196, 'ENTREGUE', '2026-01-24 10:58:42', '2026-01-24 10:58:46', 62, '5b2300646934', NULL, NULL, NULL, NULL),
(241, 197, 'ENTREGUE', '2026-01-24 11:17:55', '2026-01-24 11:18:08', 63, '68a4d32a6031', NULL, NULL, NULL, NULL),
(242, 197, 'ENTREGUE', '2026-01-24 11:19:48', '2026-01-24 11:20:02', 64, 'c190576df6b4', NULL, NULL, NULL, NULL),
(243, 197, 'ENTREGUE', '2026-01-24 11:24:09', '2026-01-24 11:24:54', 63, '68a4d32a6031', NULL, NULL, NULL, NULL),
(244, 197, 'ENTREGUE', '2026-01-24 11:35:41', '2026-01-24 11:35:57', 63, '68a4d32a6031', NULL, NULL, NULL, NULL),
(245, 197, 'ENTREGUE', '2026-01-24 11:36:45', '2026-01-24 11:36:55', 63, '68a4d32a6031', NULL, NULL, NULL, NULL),
(246, 197, 'ENTREGUE', '2026-01-24 11:46:24', '2026-01-24 11:46:30', 63, '68a4d32a6031', NULL, NULL, NULL, NULL),
(247, 198, 'ENTREGUE', '2026-01-24 13:22:20', '2026-01-24 13:23:13', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(248, 198, 'ENTREGUE', '2026-01-24 13:24:04', '2026-01-24 13:25:03', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(249, 198, 'ENTREGUE', '2026-01-24 13:25:20', '2026-01-24 13:25:32', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(250, 198, 'ENTREGUE', '2026-01-24 13:42:25', '2026-01-24 13:43:09', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(251, 198, 'ENTREGUE', '2026-01-24 13:45:15', '2026-01-24 13:45:46', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(252, 198, 'ENTREGUE', '2026-01-24 13:46:46', '2026-01-24 13:47:19', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(253, 198, 'ENTREGUE', '2026-01-24 13:48:35', '2026-01-24 13:49:28', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(254, 198, 'ENTREGUE', '2026-01-24 13:51:40', '2026-01-24 13:56:01', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(255, 198, 'ENTREGUE', '2026-01-24 13:52:35', '2026-01-24 13:53:12', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(256, 198, 'ENTREGUE', '2026-01-24 13:57:00', '2026-01-24 14:00:41', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(257, 198, 'ENTREGUE', '2026-01-24 14:00:03', '2026-01-24 14:00:42', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(258, 198, 'ENTREGUE', '2026-01-24 14:02:42', '2026-01-24 14:02:52', 65, 'c88016ef0f94', NULL, NULL, NULL, NULL),
(259, 199, 'ENTREGUE', '2026-01-24 14:25:46', '2026-01-24 14:26:45', 66, '9566055f909a', NULL, NULL, NULL, NULL),
(260, 199, 'ENTREGUE', '2026-01-24 14:48:13', '2026-01-24 14:48:33', 66, '9566055f909a', NULL, NULL, NULL, NULL),
(261, 201, 'ENTREGUE', '2026-01-24 15:22:11', '2026-01-24 15:23:03', 68, '15fd81da55b9', NULL, NULL, NULL, NULL),
(262, 201, 'ENTREGUE', '2026-01-24 15:34:20', '2026-01-24 15:34:37', 68, '15fd81da55b9', NULL, NULL, NULL, NULL),
(263, 201, 'ENTREGUE', '2026-01-24 15:35:44', '2026-01-24 15:36:08', 69, 'efe740618329', NULL, NULL, NULL, NULL),
(264, 202, 'ENTREGUE', '2026-01-24 15:56:17', '2026-01-24 15:56:25', 70, '7456f77aa746', NULL, NULL, NULL, NULL),
(265, 203, 'ENTREGUE', '2026-01-25 14:21:59', '2026-01-25 14:22:46', 72, '6fd2f72588ce', NULL, NULL, NULL, NULL),
(266, 203, 'ENTREGUE', '2026-01-25 15:03:34', '2026-01-25 15:03:40', 73, '20e6ce388d71', NULL, NULL, NULL, NULL),
(267, 203, 'ENTREGUE', '2026-01-25 16:27:23', '2026-01-25 16:30:03', 72, '6fd2f72588ce', NULL, NULL, NULL, NULL),
(268, 203, 'ENTREGUE', '2026-01-25 16:29:57', '2026-01-25 16:30:05', 72, '6fd2f72588ce', NULL, NULL, NULL, NULL),
(269, 204, 'ENTREGUE', '2026-01-25 18:55:42', '2026-01-25 18:56:03', 74, '9eb2578b1955', NULL, NULL, NULL, NULL),
(270, 204, 'ENTREGUE', '2026-01-25 19:21:02', '2026-01-25 19:21:32', 74, '9eb2578b1955', NULL, NULL, NULL, NULL),
(271, 204, 'NOVO', '2026-01-25 21:52:28', NULL, 74, '9eb2578b1955', NULL, NULL, NULL, NULL),
(272, 205, 'ENTREGUE', '2026-01-25 21:56:43', '2026-01-25 21:57:16', 75, '772c087f4467', NULL, NULL, NULL, NULL),
(273, 205, 'ENTREGUE', '2026-01-25 22:00:06', '2026-01-25 22:00:45', 75, '772c087f4467', NULL, NULL, NULL, NULL),
(274, 205, 'ENTREGUE', '2026-01-25 22:15:19', '2026-01-25 22:15:34', 75, '772c087f4467', NULL, NULL, NULL, NULL),
(275, 206, 'ENTREGUE', '2026-01-25 22:19:01', '2026-01-25 22:19:15', 76, 'a66e7d27cb1f', NULL, NULL, NULL, NULL),
(276, 207, 'ENTREGUE', '2026-01-26 08:24:31', '2026-01-26 08:25:01', 77, 'a876c0603c6a', NULL, NULL, NULL, NULL),
(277, 207, 'ENTREGUE', '2026-01-26 09:03:42', '2026-01-26 09:03:50', 77, 'a876c0603c6a', NULL, NULL, NULL, NULL),
(278, 207, 'ENTREGUE', '2026-01-26 13:07:55', '2026-01-26 13:07:58', 77, 'a876c0603c6a', NULL, NULL, NULL, NULL),
(279, 207, 'ENTREGUE', '2026-01-26 13:46:42', '2026-01-26 13:46:47', 77, 'a876c0603c6a', NULL, NULL, NULL, NULL),
(280, 208, 'ENTREGUE', '2026-01-28 16:34:36', '2026-01-28 16:34:40', 79, '6bae57877604', NULL, NULL, NULL, NULL),
(281, 210, 'ENTREGUE', '2026-01-29 19:34:01', '2026-01-29 19:35:36', 81, 'c4f09bc7f9a7', NULL, NULL, NULL, NULL),
(282, 211, 'ENTREGUE', '2026-01-29 23:13:17', '2026-01-29 23:13:38', 82, '690ccb30a748', NULL, NULL, NULL, NULL),
(283, 211, 'ENTREGUE', '2026-01-29 23:18:25', '2026-01-29 23:18:54', 82, '690ccb30a748', NULL, NULL, NULL, NULL),
(284, 211, 'ENTREGUE', '2026-01-29 23:20:15', '2026-01-29 23:20:21', 82, '690ccb30a748', NULL, NULL, NULL, NULL),
(285, 211, 'ENTREGUE', '2026-01-29 23:22:38', '2026-01-29 23:22:47', 82, '690ccb30a748', NULL, NULL, NULL, NULL),
(286, 211, 'ENTREGUE', '2026-01-29 23:23:48', '2026-01-29 23:23:57', 82, '690ccb30a748', NULL, NULL, NULL, NULL),
(287, 212, 'ENTREGUE', '2026-01-30 09:41:30', '2026-01-30 09:41:40', 83, 'f41f06fb6fb3', NULL, NULL, NULL, NULL),
(288, 213, 'ENTREGUE', '2026-02-02 09:01:38', '2026-02-02 09:01:43', 85, '88142df75640', NULL, NULL, NULL, NULL),
(289, 214, 'ENTREGUE', '2026-02-02 09:50:14', '2026-02-02 09:50:43', 87, 'd0fbf454488c', NULL, NULL, NULL, NULL),
(290, 215, 'ENTREGUE', '2026-02-02 09:52:08', '2026-02-02 09:52:20', 88, '04dda86eed49', NULL, NULL, NULL, NULL),
(291, 216, 'ENTREGUE', '2026-02-02 14:28:44', '2026-02-02 14:53:24', 89, '529fe94b8257', NULL, NULL, NULL, NULL),
(292, 216, 'CANCELADO', '2026-02-02 14:53:35', NULL, 89, '529fe94b8257', NULL, NULL, 'teste', '2026-02-02 15:11:01'),
(293, 216, 'CANCELADO', '2026-02-02 15:20:49', NULL, 89, '529fe94b8257', NULL, NULL, 'teste', '2026-02-02 15:22:32'),
(294, 216, 'CANCELADO', '2026-02-02 21:11:22', NULL, 89, '529fe94b8257', NULL, NULL, 'teste', '2026-02-02 21:11:47'),
(295, 217, 'CANCELADO', '2026-02-02 21:59:19', NULL, 90, '07dd332e2fbb', NULL, NULL, 'teste', '2026-02-02 21:59:29'),
(296, 217, 'CANCELADO', '2026-02-02 22:45:32', NULL, 90, '07dd332e2fbb', NULL, NULL, 'Acabaram os espetos', '2026-02-02 22:46:02'),
(297, 217, 'CANCELADO', '2026-02-02 22:51:45', NULL, 90, '07dd332e2fbb', NULL, NULL, 'TESTE', '2026-02-02 22:51:58'),
(298, 217, 'ENTREGUE', '2026-02-02 23:02:31', '2026-02-02 23:02:47', 90, '07dd332e2fbb', NULL, NULL, NULL, NULL),
(299, 218, 'ENTREGUE', '2026-02-03 08:09:01', '2026-02-03 08:09:13', 91, 'd27a2fd0ee61', NULL, NULL, NULL, NULL),
(300, 221, 'ENTREGUE', '2026-02-03 10:40:16', '2026-02-03 10:40:27', 94, '113d9d4054e0', NULL, NULL, NULL, NULL),
(301, 223, 'ENTREGUE', '2026-02-03 13:04:27', '2026-02-03 13:04:35', 96, 'd7498419bf7a', NULL, NULL, NULL, NULL),
(302, 228, 'ENTREGUE', '2026-02-03 14:20:34', '2026-02-03 14:20:47', 101, '873757699ec4', NULL, NULL, NULL, NULL),
(303, 229, 'ENTREGUE', '2026-02-03 15:13:56', '2026-02-03 15:14:38', 103, '99fdcddb886b', NULL, NULL, NULL, NULL),
(304, 229, 'ENTREGUE', '2026-02-03 15:15:07', '2026-02-03 15:15:36', 102, '5f6f49726a15', NULL, NULL, NULL, NULL),
(305, 230, 'ENTREGUE', '2026-02-03 15:21:08', '2026-02-03 15:21:29', 104, '73f87c612e06', NULL, NULL, NULL, NULL),
(306, 231, 'ENTREGUE', '2026-02-03 15:24:43', '2026-02-03 15:24:59', 105, '3449073a7b41', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura para tabela `pedido_itens`
--

CREATE TABLE `pedido_itens` (
  `id` int NOT NULL,
  `pedido_id` int NOT NULL,
  `produto_id` int NOT NULL,
  `qtd` int NOT NULL,
  `preco_unit` decimal(10,2) NOT NULL,
  `observacao` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `pedido_itens`
--

INSERT INTO `pedido_itens` (`id`, `pedido_id`, `produto_id`, `qtd`, `preco_unit`, `observacao`) VALUES
(1, 71, 3, 1, '6.00', NULL),
(2, 71, 1, 1, '15.00', NULL),
(3, 71, 2, 1, '18.00', NULL),
(4, 72, 3, 1, '6.00', NULL),
(5, 73, 2, 1, '18.00', NULL),
(6, 73, 1, 1, '15.00', NULL),
(7, 74, 2, 1, '18.00', NULL),
(8, 75, 3, 1, '6.00', NULL),
(9, 75, 1, 1, '15.00', NULL),
(10, 75, 2, 1, '18.00', NULL),
(11, 76, 3, 1, '6.00', NULL),
(12, 77, 1, 4, '15.00', NULL),
(13, 78, 3, 4, '6.00', NULL),
(14, 79, 2, 3, '18.00', NULL),
(15, 80, 1, 2, '15.00', NULL),
(16, 81, 3, 4, '6.00', NULL),
(17, 81, 2, 3, '18.00', NULL),
(18, 81, 1, 3, '15.00', NULL),
(19, 82, 2, 2, '18.00', NULL),
(20, 83, 1, 2, '15.00', NULL),
(21, 83, 2, 1, '18.00', NULL),
(22, 84, 2, 1, '18.00', NULL),
(23, 85, 2, 1, '18.00', NULL),
(24, 86, 1, 1, '15.00', NULL),
(25, 87, 3, 1, '6.00', NULL),
(26, 87, 2, 1, '18.00', NULL),
(27, 88, 2, 3, '18.00', NULL),
(28, 89, 3, 1, '6.00', NULL),
(29, 90, 2, 2, '18.00', NULL),
(30, 91, 2, 3, '18.00', NULL),
(31, 91, 1, 2, '15.00', NULL),
(32, 92, 1, 1, '15.00', NULL),
(33, 92, 2, 1, '18.00', NULL),
(34, 93, 2, 1, '18.00', NULL),
(35, 93, 3, 1, '6.00', NULL),
(36, 94, 3, 1, '6.00', NULL),
(37, 94, 4, 1, '10.00', NULL),
(38, 95, 4, 1, '10.00', NULL),
(39, 95, 3, 1, '6.00', NULL),
(40, 95, 2, 1, '18.00', NULL),
(41, 96, 5, 1, '60.00', NULL),
(42, 96, 3, 2, '6.00', NULL),
(43, 96, 4, 2, '10.00', NULL),
(44, 97, 5, 2, '60.00', NULL),
(45, 98, 3, 1, '6.00', NULL),
(46, 99, 3, 2, '6.00', NULL),
(47, 99, 1, 2, '15.00', NULL),
(48, 99, 4, 1, '10.00', NULL),
(49, 100, 4, 2, '10.00', NULL),
(50, 100, 5, 1, '60.00', NULL),
(51, 100, 3, 3, '6.00', NULL),
(52, 101, 1, 1, '15.00', NULL),
(53, 102, 4, 2, '10.00', NULL),
(54, 103, 1, 3, '15.00', NULL),
(55, 104, 4, 1, '10.00', NULL),
(56, 105, 5, 1, '60.00', NULL),
(57, 106, 4, 1, '10.00', NULL),
(58, 107, 4, 4, '10.00', NULL),
(59, 108, 1, 2, '15.00', NULL),
(60, 109, 3, 1, '6.00', NULL),
(61, 109, 4, 1, '10.00', NULL),
(62, 109, 1, 2, '15.00', NULL),
(63, 110, 4, 2, '10.00', NULL),
(64, 110, 5, 1, '60.00', NULL),
(65, 111, 4, 2, '10.00', NULL),
(66, 111, 5, 1, '60.00', NULL),
(67, 111, 3, 2, '6.00', NULL),
(68, 112, 4, 2, '10.00', NULL),
(69, 113, 4, 2, '10.00', NULL),
(70, 113, 5, 1, '60.00', NULL),
(71, 113, 3, 2, '6.00', NULL),
(72, 114, 3, 2, '6.00', NULL),
(73, 115, 5, 2, '60.00', NULL),
(74, 115, 4, 4, '10.00', NULL),
(75, 116, 1, 2, '15.00', NULL),
(76, 117, 1, 2, '15.00', NULL),
(77, 118, 3, 2, '6.00', NULL),
(78, 119, 1, 1, '15.00', NULL),
(79, 120, 2, 1, '18.00', NULL),
(80, 120, 4, 1, '10.00', NULL),
(81, 121, 5, 4, '60.00', NULL),
(82, 122, 1, 1, '15.00', NULL),
(83, 122, 4, 1, '10.00', NULL),
(84, 123, 1, 1, '15.00', NULL),
(85, 123, 3, 2, '6.00', NULL),
(86, 123, 4, 1, '10.00', NULL),
(87, 123, 5, 1, '60.00', NULL),
(88, 124, 1, 2, '15.00', NULL),
(89, 124, 2, 1, '18.00', NULL),
(90, 124, 3, 2, '6.00', NULL),
(91, 124, 4, 2, '10.00', 'Gelada'),
(92, 125, 4, 2, '10.00', NULL),
(93, 126, 4, 2, '10.00', NULL),
(94, 127, 4, 4, '10.00', NULL),
(95, 128, 4, 4, '10.00', NULL),
(96, 129, 1, 1, '15.00', NULL),
(97, 130, 3, 1, '6.00', NULL),
(98, 131, 4, 1, '10.00', NULL),
(99, 132, 4, 2, '10.00', NULL),
(100, 132, 1, 2, '15.00', NULL),
(101, 133, 5, 2, '60.00', NULL),
(102, 134, 5, 1, '60.00', NULL),
(103, 134, 4, 1, '10.00', NULL),
(104, 134, 3, 2, '6.00', NULL),
(105, 135, 4, 2, '10.00', NULL),
(106, 135, 5, 1, '60.00', NULL),
(107, 136, 2, 1, '18.00', NULL),
(108, 137, 1, 2, '15.00', NULL),
(109, 138, 4, 2, '10.00', NULL),
(110, 139, 5, 1, '60.00', NULL),
(111, 140, 4, 2, '10.00', NULL),
(112, 140, 1, 2, '15.00', NULL),
(113, 141, 5, 1, '60.00', NULL),
(114, 142, 5, 1, '60.00', NULL),
(115, 143, 5, 1, '60.00', NULL),
(116, 144, 5, 1, '60.00', NULL),
(117, 145, 4, 2, '10.00', NULL),
(118, 146, 4, 1, '10.00', NULL),
(119, 147, 4, 1, '10.00', NULL),
(120, 148, 3, 1, '6.00', NULL),
(121, 148, 4, 1, '10.00', NULL),
(122, 148, 5, 1, '60.00', NULL),
(123, 149, 4, 2, '10.00', NULL),
(124, 150, 1, 2, '15.00', NULL),
(125, 150, 4, 2, '10.00', NULL),
(126, 150, 3, 2, '6.00', NULL),
(127, 151, 4, 2, '10.00', NULL),
(128, 152, 4, 2, '10.00', NULL),
(129, 153, 1, 2, '15.00', NULL),
(130, 154, 1, 2, '15.00', NULL),
(131, 155, 3, 2, '6.00', NULL),
(132, 156, 1, 2, '15.00', NULL),
(133, 156, 5, 1, '60.00', NULL),
(134, 157, 3, 2, '6.00', NULL),
(135, 157, 2, 1, '18.00', NULL),
(136, 158, 4, 2, '10.00', NULL),
(137, 159, 4, 2, '10.00', NULL),
(138, 160, 5, 2, '60.00', NULL),
(139, 161, 5, 1, '60.00', NULL),
(140, 162, 1, 2, '15.00', NULL),
(141, 162, 4, 1, '10.00', NULL),
(142, 162, 3, 2, '6.00', NULL),
(143, 163, 4, 2, '10.00', NULL),
(144, 164, 5, 1, '60.00', NULL),
(145, 164, 4, 1, '10.00', NULL),
(146, 164, 3, 2, '6.00', NULL),
(147, 165, 4, 1, '10.00', NULL),
(148, 165, 3, 1, '6.00', NULL),
(149, 166, 5, 1, '60.00', NULL),
(150, 166, 4, 1, '10.00', NULL),
(151, 166, 3, 2, '6.00', NULL),
(152, 167, 3, 1, '6.00', NULL),
(153, 167, 4, 1, '10.00', NULL),
(154, 167, 1, 1, '15.00', NULL),
(155, 168, 4, 1, '10.00', NULL),
(156, 169, 4, 1, '10.00', NULL),
(157, 169, 3, 1, '6.00', NULL),
(158, 169, 1, 1, '15.00', NULL),
(159, 170, 4, 1, '10.00', NULL),
(160, 171, 4, 1, '10.00', NULL),
(161, 172, 4, 1, '10.00', NULL),
(162, 172, 1, 1, '15.00', NULL),
(163, 173, 4, 1, '10.00', NULL),
(164, 174, 5, 2, '60.00', NULL),
(165, 175, 4, 1, '10.00', NULL),
(166, 176, 5, 1, '60.00', NULL),
(167, 176, 3, 2, '6.00', NULL),
(168, 177, 4, 1, '10.00', NULL),
(169, 177, 1, 1, '15.00', NULL),
(170, 178, 4, 1, '10.00', NULL),
(171, 179, 1, 1, '15.00', NULL),
(172, 180, 4, 1, '10.00', NULL),
(173, 181, 4, 1, '10.00', NULL),
(174, 182, 4, 1, '10.00', NULL),
(175, 183, 4, 1, '10.00', NULL),
(176, 184, 1, 1, '15.00', NULL),
(177, 185, 4, 1, '10.00', NULL),
(178, 186, 4, 2, '10.00', NULL),
(179, 186, 2, 2, '18.00', NULL),
(180, 187, 4, 2, '10.00', NULL),
(181, 188, 1, 1, '15.00', NULL),
(182, 188, 4, 1, '10.00', NULL),
(183, 188, 3, 1, '6.00', NULL),
(184, 189, 3, 2, '6.00', NULL),
(185, 192, 3, 2, '6.00', NULL),
(186, 192, 1, 1, '15.00', NULL),
(187, 192, 4, 1, '10.00', NULL),
(188, 196, 3, 1, '6.00', ''),
(189, 196, 4, 1, '10.00', ''),
(190, 197, 1, 1, '15.00', ''),
(191, 197, 4, 1, '10.00', ''),
(192, 198, 4, 1, '10.00', ''),
(193, 199, 2, 1, '18.00', ''),
(194, 200, 4, 1, '10.00', ''),
(195, 200, 3, 1, '6.00', ''),
(196, 201, 4, 1, '10.00', ''),
(197, 202, 4, 1, '10.00', ''),
(198, 203, 4, 1, '10.00', ''),
(199, 204, 4, 1, '10.00', ''),
(200, 205, 4, 1, '10.00', ''),
(201, 205, 1, 1, '15.00', ''),
(202, 206, 4, 1, '10.00', ''),
(203, 207, 1, 1, '15.00', ''),
(204, 207, 2, 1, '18.00', ''),
(205, 208, 1, 1, '15.00', ''),
(206, 208, 4, 1, '10.00', ''),
(207, 209, 4, 1, '10.00', ''),
(208, 210, 5, 1, '60.00', ''),
(209, 211, 2, 1, '18.00', ''),
(210, 212, 4, 1, '10.00', ''),
(211, 213, 3, 1, '6.00', ''),
(212, 214, 4, 1, '10.00', ''),
(213, 215, 4, 1, '10.00', ''),
(214, 215, 2, 1, '18.00', ''),
(215, 215, 5, 1, '60.00', ''),
(216, 216, 3, 1, '6.00', ''),
(217, 216, 5, 1, '60.00', ''),
(218, 216, 1, 1, '15.00', ''),
(219, 217, 3, 1, '6.00', ''),
(220, 218, 4, 1, '10.00', ''),
(221, 219, 5, 1, '60.00', ''),
(222, 220, 1, 1, '15.00', ''),
(223, 221, 4, 1, '10.00', ''),
(224, 221, 1, 1, '15.00', ''),
(225, 222, 3, 1, '6.00', ''),
(226, 222, 4, 2, '10.00', ''),
(227, 222, 1, 1, '15.00', ''),
(228, 223, 4, 1, '10.00', ''),
(229, 223, 1, 1, '15.00', ''),
(230, 223, 5, 1, '60.00', ''),
(231, 223, 2, 1, '18.00', ''),
(232, 224, 4, 1, '10.00', ''),
(233, 224, 1, 1, '15.00', ''),
(234, 224, 5, 1, '60.00', ''),
(235, 224, 2, 1, '18.00', ''),
(236, 224, 3, 1, '6.00', ''),
(237, 225, 4, 1, '10.00', ''),
(238, 225, 3, 2, '6.00', ''),
(239, 225, 1, 2, '15.00', ''),
(240, 226, 4, 1, '10.00', ''),
(241, 226, 1, 1, '15.00', ''),
(242, 226, 2, 1, '18.00', ''),
(243, 227, 3, 1, '6.00', ''),
(244, 227, 1, 1, '15.00', ''),
(245, 228, 4, 1, '10.00', ''),
(246, 228, 2, 3, '18.00', ''),
(247, 229, 3, 1, '6.00', ''),
(248, 229, 2, 1, '18.00', ''),
(249, 229, 4, 1, '10.00', ''),
(250, 229, 1, 1, '15.00', ''),
(251, 229, 5, 1, '60.00', ''),
(252, 230, 4, 1, '10.00', ''),
(253, 230, 2, 1, '18.00', ''),
(254, 230, 1, 1, '15.00', ''),
(255, 231, 4, 1, '10.00', ''),
(256, 231, 1, 1, '15.00', ''),
(257, 231, 5, 1, '60.00', ''),
(258, 231, 2, 1, '18.00', ''),
(259, 232, 4, 2, '10.00', ''),
(260, 232, 3, 2, '6.00', ''),
(261, 232, 5, 1, '60.00', ''),
(262, 233, 4, 1, '10.00', ''),
(263, 233, 1, 1, '15.00', ''),
(264, 233, 3, 1, '6.00', ''),
(265, 234, 4, 1, '10.00', ''),
(266, 234, 1, 1, '15.00', ''),
(267, 234, 5, 1, '60.00', ''),
(268, 234, 3, 1, '6.00', ''),
(269, 235, 4, 1, '10.00', ''),
(270, 235, 1, 1, '15.00', ''),
(271, 236, 4, 1, '10.00', ''),
(272, 236, 1, 1, '15.00', ''),
(273, 236, 5, 1, '60.00', ''),
(274, 236, 2, 1, '18.00', ''),
(275, 237, 4, 2, '10.00', ''),
(276, 237, 1, 3, '15.00', ''),
(277, 237, 3, 2, '6.00', ''),
(278, 238, 3, 1, '6.00', ''),
(279, 238, 5, 1, '60.00', ''),
(280, 238, 4, 1, '10.00', ''),
(281, 239, 1, 1, '15.00', ''),
(282, 239, 5, 1, '60.00', ''),
(283, 239, 4, 1, '10.00', ''),
(284, 240, 4, 1, '10.00', ''),
(285, 240, 1, 1, '15.00', ''),
(286, 241, 4, 2, '10.00', ''),
(287, 241, 1, 1, '15.00', ''),
(288, 241, 5, 1, '60.00', ''),
(289, 242, 3, 1, '6.00', ''),
(290, 242, 4, 1, '10.00', ''),
(291, 242, 1, 1, '15.00', ''),
(292, 242, 5, 1, '60.00', ''),
(293, 243, 4, 1, '10.00', ''),
(294, 243, 1, 1, '15.00', ''),
(295, 243, 5, 1, '60.00', ''),
(296, 243, 2, 1, '18.00', ''),
(297, 243, 3, 1, '6.00', ''),
(298, 244, 1, 1, '15.00', ''),
(299, 245, 1, 1, '15.00', ''),
(300, 245, 4, 1, '10.00', ''),
(301, 245, 2, 1, '18.00', ''),
(302, 245, 3, 1, '6.00', ''),
(303, 246, 1, 1, '15.00', ''),
(304, 246, 4, 1, '10.00', ''),
(305, 247, 3, 1, '6.00', ''),
(306, 247, 4, 1, '10.00', ''),
(307, 248, 4, 1, '10.00', ''),
(308, 248, 1, 1, '15.00', ''),
(309, 249, 5, 1, '60.00', ''),
(310, 250, 1, 1, '15.00', ''),
(311, 250, 2, 1, '18.00', ''),
(312, 251, 1, 1, '15.00', ''),
(313, 252, 2, 1, '18.00', ''),
(314, 253, 4, 1, '10.00', ''),
(315, 254, 4, 1, '10.00', ''),
(316, 255, 4, 1, '10.00', ''),
(317, 256, 4, 1, '10.00', ''),
(318, 257, 4, 1, '10.00', ''),
(319, 257, 1, 1, '15.00', ''),
(320, 257, 5, 1, '60.00', ''),
(321, 257, 2, 1, '18.00', ''),
(322, 258, 4, 2, '10.00', ''),
(323, 259, 4, 1, '10.00', ''),
(324, 260, 3, 1, '6.00', ''),
(325, 261, 4, 1, '10.00', ''),
(326, 261, 3, 2, '6.00', ''),
(327, 261, 5, 1, '60.00', ''),
(328, 262, 4, 1, '10.00', ''),
(329, 262, 1, 1, '15.00', ''),
(330, 262, 3, 1, '6.00', ''),
(331, 263, 4, 1, '10.00', ''),
(332, 263, 1, 1, '15.00', ''),
(333, 264, 1, 1, '15.00', ''),
(334, 264, 5, 1, '60.00', ''),
(335, 264, 4, 1, '10.00', ''),
(336, 264, 2, 1, '18.00', ''),
(337, 264, 3, 1, '6.00', ''),
(338, 265, 1, 1, '15.00', ''),
(339, 265, 2, 1, '18.00', ''),
(340, 266, 4, 2, '10.00', ''),
(341, 266, 1, 1, '15.00', ''),
(342, 267, 4, 2, '10.00', ''),
(343, 267, 5, 1, '60.00', ''),
(344, 268, 4, 1, '10.00', ''),
(345, 268, 1, 1, '15.00', ''),
(346, 268, 5, 1, '60.00', ''),
(347, 268, 2, 1, '18.00', ''),
(348, 268, 3, 1, '6.00', ''),
(349, 269, 4, 1, '10.00', ''),
(350, 269, 3, 1, '6.00', ''),
(351, 269, 5, 1, '60.00', ''),
(352, 270, 5, 1, '60.00', ''),
(353, 270, 4, 2, '10.00', ''),
(354, 271, 4, 1, '10.00', ''),
(355, 271, 1, 1, '15.00', ''),
(356, 272, 4, 1, '10.00', ''),
(357, 272, 1, 1, '15.00', ''),
(358, 273, 5, 1, '60.00', ''),
(359, 273, 3, 1, '6.00', ''),
(360, 274, 1, 2, '15.00', ''),
(361, 274, 3, 1, '6.00', ''),
(362, 275, 1, 2, '15.00', ''),
(363, 275, 4, 1, '10.00', ''),
(364, 275, 3, 2, '6.00', ''),
(365, 276, 4, 1, '10.00', ''),
(366, 276, 1, 1, '15.00', ''),
(367, 276, 3, 1, '6.00', ''),
(368, 277, 5, 1, '60.00', ''),
(369, 277, 4, 1, '10.00', ''),
(370, 278, 5, 1, '60.00', ''),
(371, 279, 4, 3, '10.00', ''),
(372, 279, 1, 1, '15.00', ''),
(373, 280, 4, 1, '10.00', ''),
(374, 280, 5, 1, '60.00', ''),
(375, 280, 3, 2, '6.00', ''),
(376, 281, 6, 1, '8.00', ''),
(377, 281, 4, 1, '10.00', ''),
(378, 281, 3, 2, '6.00', ''),
(379, 282, 4, 1, '10.00', ''),
(380, 282, 6, 2, '8.00', ''),
(381, 282, 3, 1, '6.00', ''),
(382, 283, 1, 1, '15.00', ''),
(383, 283, 4, 1, '10.00', ''),
(384, 283, 3, 2, '6.00', ''),
(385, 284, 5, 1, '60.00', ''),
(386, 285, 6, 3, '8.00', ''),
(387, 285, 4, 1, '10.00', ''),
(388, 285, 3, 2, '6.00', ''),
(389, 286, 4, 10, '10.00', ''),
(390, 287, 5, 1, '60.00', ''),
(391, 287, 4, 1, '10.00', ''),
(392, 287, 3, 1, '6.00', ''),
(393, 288, 4, 1, '10.00', ''),
(394, 288, 5, 1, '60.00', ''),
(395, 289, 4, 1, '10.00', ''),
(396, 289, 5, 1, '60.00', ''),
(397, 290, 4, 1, '10.00', ''),
(398, 290, 6, 2, '8.00', ''),
(399, 291, 4, 1, '10.00', ''),
(400, 291, 6, 2, '8.00', ''),
(401, 291, 3, 1, '6.00', ''),
(402, 292, 6, 3, '8.00', ''),
(403, 292, 4, 1, '10.00', ''),
(404, 293, 4, 1, '10.00', ''),
(405, 293, 3, 1, '6.00', ''),
(406, 294, 5, 1, '60.00', ''),
(407, 294, 4, 1, '10.00', ''),
(408, 295, 4, 1, '10.00', ''),
(409, 295, 6, 2, '8.00', ''),
(410, 296, 4, 1, '10.00', ''),
(411, 296, 6, 3, '8.00', ''),
(412, 296, 3, 2, '6.00', ''),
(413, 297, 4, 1, '10.00', ''),
(414, 297, 6, 2, '8.00', ''),
(415, 297, 3, 2, '6.00', ''),
(416, 298, 4, 1, '10.00', ''),
(417, 298, 5, 1, '60.00', ''),
(418, 299, 4, 1, '10.00', ''),
(419, 299, 6, 1, '8.00', ''),
(420, 299, 3, 1, '6.00', ''),
(421, 300, 4, 1, '10.00', ''),
(422, 300, 6, 1, '8.00', ''),
(423, 300, 3, 1, '6.00', ''),
(424, 301, 6, 1, '8.00', ''),
(425, 301, 4, 1, '10.00', ''),
(426, 301, 1, 1, '15.00', ''),
(427, 301, 2, 1, '18.00', ''),
(428, 302, 3, 2, '6.00', ''),
(429, 302, 2, 2, '18.00', ''),
(430, 302, 6, 2, '8.00', ''),
(431, 303, 4, 1, '10.00', ''),
(432, 303, 3, 2, '6.00', ''),
(433, 303, 6, 3, '8.00', ''),
(434, 304, 3, 2, '6.00', ''),
(435, 304, 1, 1, '15.00', ''),
(436, 304, 4, 1, '10.00', ''),
(437, 305, 4, 2, '10.00', ''),
(438, 305, 5, 1, '60.00', ''),
(439, 306, 6, 2, '8.00', ''),
(440, 306, 4, 1, '10.00', '');

-- --------------------------------------------------------

--
-- Estrutura para tabela `produtos`
--

CREATE TABLE `produtos` (
  `id` int NOT NULL,
  `nome` varchar(120) NOT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  `categoria` varchar(80) NOT NULL DEFAULT 'Geral',
  `foto` varchar(180) DEFAULT NULL,
  `preco` decimal(10,2) NOT NULL,
  `ativo` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Despejando dados para a tabela `produtos`
--

INSERT INTO `produtos` (`id`, `nome`, `descricao`, `categoria`, `foto`, `preco`, `ativo`) VALUES
(1, 'X-Burger', NULL, 'LANCHES', 'xburger.png', '15.00', 1),
(2, 'X-Salada', NULL, 'LANCHES', 'vazio.png', '18.00', 1),
(3, 'Refrigerante', NULL, 'REFRIGERANTES', 'prod_697ad189521122.88460134.png', '6.00', 1),
(4, 'BRAHMA', '600ml', 'CERVEJAS', 'brahma600.png', '10.00', 1),
(5, 'Porção de Peixe', '500gr', 'PORÇÕES', 'peixe.png', '60.00', 1),
(6, 'Espetinhos', 'Boi, Porco, Medalhão e Linguiça', 'ESPETOS', 'prod_697ad3486845b7.19942122.png', '8.00', 1);

-- --------------------------------------------------------

--
-- Estrutura para tabela `sessoes_cliente`
--

CREATE TABLE `sessoes_cliente` (
  `id` int NOT NULL,
  `conta_id` int NOT NULL,
  `cliente_id` int NOT NULL,
  `sessao_key` varchar(32) NOT NULL,
  `criada_em` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `encerrada_em` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Índices de tabelas apagadas
--

--
-- Índices de tabela `caixas`
--
ALTER TABLE `caixas`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `caixa_lancamentos`
--
ALTER TABLE `caixa_lancamentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `caixa_id` (`caixa_id`),
  ADD KEY `criado_em` (`criado_em`),
  ADD KEY `categoria` (`categoria`),
  ADD KEY `idx_caixa_lanc_status` (`status`,`criado_em`);

--
-- Índices de tabela `caixa_movimentos`
--
ALTER TABLE `caixa_movimentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `caixa_id` (`caixa_id`);

--
-- Índices de tabela `cartao_movimentos`
--
ALTER TABLE `cartao_movimentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cartao_id` (`cartao_id`),
  ADD KEY `idx_criado_em` (`criado_em`),
  ADD KEY `idx_ref_mov_id` (`ref_mov_id`);

--
-- Índices de tabela `cartoes`
--
ALTER TABLE `cartoes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `codigo` (`codigo`);

--
-- Índices de tabela `chamados_garcom`
--
ALTER TABLE `chamados_garcom`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `contas`
--
ALTER TABLE `contas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mesa_id` (`mesa_id`),
  ADD KEY `idx_contas_status` (`status`),
  ADD KEY `idx_contas_status_acesso` (`status_acesso`);

--
-- Índices de tabela `contas_liberacoes`
--
ALTER TABLE `contas_liberacoes`
  ADD PRIMARY KEY (`conta_id`);

--
-- Índices de tabela `conta_participantes`
--
ALTER TABLE `conta_participantes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_conta_cliente` (`conta_id`,`cliente_id`),
  ADD KEY `idx_conta_status` (`conta_id`,`status`),
  ADD KEY `idx_conta_sessao` (`conta_id`,`sessao_key`);

--
-- Índices de tabela `lancamentos`
--
ALTER TABLE `lancamentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `conta_id` (`conta_id`),
  ADD KEY `conta_id_2` (`conta_id`,`sessao_key`),
  ADD KEY `status` (`status`);

--
-- Índices de tabela `mesa_participantes`
--
ALTER TABLE `mesa_participantes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_conta_cliente` (`conta_id`,`cliente_id`),
  ADD KEY `idx_conta_ping` (`conta_id`,`ultimo_ping`);

--
-- Índices de tabela `pagamentos`
--
ALTER TABLE `pagamentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `conta_id` (`conta_id`),
  ADD KEY `conta_id_2` (`conta_id`,`sessao_key`),
  ADD KEY `status` (`status`);

--
-- Índices de tabela `pagamentos_pix`
--
ALTER TABLE `pagamentos_pix`
  ADD PRIMARY KEY (`id`),
  ADD KEY `conta_id` (`conta_id`),
  ADD KEY `txid` (`txid`);

--
-- Índices de tabela `pedidos`
--
ALTER TABLE `pedidos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_pedidos_status` (`status`),
  ADD KEY `fk_pedidos_clientes` (`cliente_id`),
  ADD KEY `fk_pedidos_entregue_por` (`entregue_por`),
  ADD KEY `idx_pedidos_conta_status` (`conta_id`,`status`),
  ADD KEY `idx_pedidos_conta_sessao` (`conta_id`,`sessao_key`),
  ADD KEY `idx_pedidos_conta_sessao_seq` (`conta_id`,`sessao_key`,`sessao_seq`);

--
-- Índices de tabela `pedido_itens`
--
ALTER TABLE `pedido_itens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pedido_id` (`pedido_id`),
  ADD KEY `produto_id` (`produto_id`);

--
-- Índices de tabela `produtos`
--
ALTER TABLE `produtos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_produtos_categoria` (`categoria`);

--
-- Índices de tabela `sessoes_cliente`
--
ALTER TABLE `sessoes_cliente`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_conta_sessao` (`conta_id`,`sessao_key`),
  ADD KEY `conta_id` (`conta_id`),
  ADD KEY `cliente_id` (`cliente_id`);

--
-- AUTO_INCREMENT de tabelas apagadas
--

--
-- AUTO_INCREMENT de tabela `caixas`
--
ALTER TABLE `caixas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `caixa_lancamentos`
--
ALTER TABLE `caixa_lancamentos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT de tabela `caixa_movimentos`
--
ALTER TABLE `caixa_movimentos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cartao_movimentos`
--
ALTER TABLE `cartao_movimentos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT de tabela `cartoes`
--
ALTER TABLE `cartoes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=205;

--
-- AUTO_INCREMENT de tabela `chamados_garcom`
--
ALTER TABLE `chamados_garcom`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de tabela `clientes`
--
ALTER TABLE `clientes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

--
-- AUTO_INCREMENT de tabela `contas`
--
ALTER TABLE `contas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235;

--
-- AUTO_INCREMENT de tabela `conta_participantes`
--
ALTER TABLE `conta_participantes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT de tabela `lancamentos`
--
ALTER TABLE `lancamentos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT de tabela `mesa_participantes`
--
ALTER TABLE `mesa_participantes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `pagamentos`
--
ALTER TABLE `pagamentos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;

--
-- AUTO_INCREMENT de tabela `pagamentos_pix`
--
ALTER TABLE `pagamentos_pix`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de tabela `pedidos`
--
ALTER TABLE `pedidos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=307;

--
-- AUTO_INCREMENT de tabela `pedido_itens`
--
ALTER TABLE `pedido_itens`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=441;

--
-- AUTO_INCREMENT de tabela `produtos`
--
ALTER TABLE `produtos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de tabela `sessoes_cliente`
--
ALTER TABLE `sessoes_cliente`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- Restrições para dumps de tabelas
--

--
-- Restrições para tabelas `caixa_lancamentos`
--
ALTER TABLE `caixa_lancamentos`
  ADD CONSTRAINT `fk_caixa_lancamentos_caixa` FOREIGN KEY (`caixa_id`) REFERENCES `caixas` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `caixa_movimentos`
--
ALTER TABLE `caixa_movimentos`
  ADD CONSTRAINT `caixa_movimentos_ibfk_1` FOREIGN KEY (`caixa_id`) REFERENCES `caixas` (`id`);

--
-- Restrições para tabelas `cartao_movimentos`
--
ALTER TABLE `cartao_movimentos`
  ADD CONSTRAINT `fk_cartao_mov_cartao` FOREIGN KEY (`cartao_id`) REFERENCES `cartoes` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `contas`
--
ALTER TABLE `contas`
  ADD CONSTRAINT `contas_ibfk_1` FOREIGN KEY (`mesa_id`) REFERENCES `mesas` (`id`);

--
-- Restrições para tabelas `pagamentos_pix`
--
ALTER TABLE `pagamentos_pix`
  ADD CONSTRAINT `fk_pix_conta` FOREIGN KEY (`conta_id`) REFERENCES `contas` (`id`);

--
-- Restrições para tabelas `pedidos`
--
ALTER TABLE `pedidos`
  ADD CONSTRAINT `fk_pedidos_clientes` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`),
  ADD CONSTRAINT `fk_pedidos_entregue_por` FOREIGN KEY (`entregue_por`) REFERENCES `garcons` (`id`),
  ADD CONSTRAINT `pedidos_ibfk_1` FOREIGN KEY (`conta_id`) REFERENCES `contas` (`id`);

--
-- Restrições para tabelas `pedido_itens`
--
ALTER TABLE `pedido_itens`
  ADD CONSTRAINT `pedido_itens_ibfk_1` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`),
  ADD CONSTRAINT `pedido_itens_ibfk_2` FOREIGN KEY (`produto_id`) REFERENCES `produtos` (`id`);
COMMIT;

