-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 18/11/2025 às 12:42
-- Versão do servidor: 8.0.43
-- Versão do PHP: 8.2.27

START TRANSACTION;



--
-- Banco de dados: `adm_freefi`
--

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

--
-- Estrutura para tabela `auditoria_splash`
--

CREATE TABLE `auditoria_splash` (
  `id` bigint UNSIGNED NOT NULL,
  `processed` tinyint(1) NOT NULL DEFAULT '0',
  `hs_serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Serial do hotspot',
  `cl_mac_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'MAC address do cliente',
  `ip_origem` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_cliente` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pag_click` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Página clicada',
  `imagem` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nome da imagem exibida',
  `dsc_identity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Identity do equipamento',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `auditoria_splash`
--

INSERT INTO `auditoria_splash` (`id`, `processed`, `hs_serial`, `cl_mac_address`, `ip_origem`, `ip_cliente`, `pag_click`, `imagem`, `dsc_identity`, `created_at`) VALUES
(1, 0, 'AP001', 'AA:BB:CC:DD:EE:FF', NULL, NULL, 'https://example.com', '/uploads/banner_teste.jpg', 'usuario_teste', '2025-11-04 16:08:05'),
(2, 0, 'AP002', '11:22:33:44:55:66', NULL, NULL, 'https://teste.com', '/uploads/banner2.jpg', 'teste_timezone', '2025-11-04 13:10:50'),
(3, 0, 'AP003', 'AA:BB:CC:DD:EE:01', '172.20.0.1', NULL, 'https://test-ip.com', '/uploads/banner3.jpg', 'teste_ip', '2025-11-04 13:12:35'),
(4, 0, 'AP004', 'AA:BB:CC:DD:EE:02', '203.0.113.45', NULL, 'https://test-proxy.com', '/uploads/banner4.jpg', 'teste_proxy', '2025-11-04 13:14:00'),
(5, 0, 'TESTE', 'AA:BB:CC:DD:EE:FF', '172.233.21.57', NULL, 'https://teste.com', '/uploads/banner_teste.jpg', 'teste_mikrotik', '2025-11-04 13:20:31'),
(6, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 15:26:34'),
(7, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 15:26:39'),
(8, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 15:26:51'),
(9, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 15:26:56'),
(10, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 15:27:00'),
(11, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 15:27:04'),
(12, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 15:27:09'),
(13, 0, 'HH30A0C1CJT', 'DE:39:A8:FC:C0:F8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 15:27:31'),
(14, 0, 'HH30A0C1CJT', '42:81:99:1D:43:CB', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 17:05:59'),
(15, 0, 'HH30A0C1CJT', '42:81:99:1D:43:CB', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 17:06:04'),
(16, 0, 'HH30A0C1CJT', 'D2:C2:69:DE:74:46', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 18:02:09'),
(17, 0, 'HH30A0C1CJT', 'D2:C2:69:DE:74:46', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 18:02:14'),
(18, 0, 'HH30A0C1CJT', '6A:33:97:0F:A3:60', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 18:27:01'),
(19, 0, 'HH30A0C1CJT', 'A2:E4:9B:23:6E:02', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 18:48:14'),
(20, 0, 'HH30A0C1CJT', 'A2:E4:9B:23:6E:02', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 18:48:21'),
(21, 0, 'HH30A0C1CJT', '1A:5A:3E:65:3D:B9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 20:10:55'),
(22, 0, 'HH30A0C1CJT', '36:12:36:0B:F9:82', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 20:11:58'),
(23, 0, 'HH30A0C1CJT', '36:12:36:0B:F9:82', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 20:12:03'),
(24, 0, 'HH30A0C1CJT', '8A:F9:E6:4C:29:B6', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 20:25:42'),
(25, 0, 'HH30A0C1CJT', '8A:F9:E6:4C:29:B6', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 20:25:47'),
(26, 0, 'HH30A0C1CJT', '8A:F9:E6:4C:29:B6', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 20:26:42'),
(27, 0, 'HH30A0C1CJT', '8A:F9:E6:4C:29:B6', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 20:26:48'),
(28, 0, 'HH30A0C1CJT', 'A4:4B:D5:E9:1E:33', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 21:04:47'),
(29, 0, 'HH30A0C1CJT', 'A4:4B:D5:E9:1E:33', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 21:04:53'),
(30, 0, 'HH30A0C1CJT', 'A4:4B:D5:E9:1E:33', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-04 21:05:00'),
(31, 0, 'HH30A0C1CJT', 'A4:4B:D5:E9:1E:33', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-04 21:05:04'),
(32, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 05:54:19'),
(33, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 05:54:24'),
(34, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 05:54:32'),
(35, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 05:54:38'),
(36, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 05:54:55'),
(37, 0, 'HH30A0C1CJT', '76:B7:F6:FE:79:C0', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 05:55:00'),
(38, 0, 'HH30A0C1CJT', 'C6:76:D2:F3:9E:B7', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 06:37:24'),
(39, 0, 'HH30A0C1CJT', 'C6:76:D2:F3:9E:B7', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 06:37:29'),
(40, 0, 'HH30A0C1CJT', 'DA:BA:F8:82:D4:FB', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 09:46:11'),
(41, 0, 'HH30A0C1CJT', 'DA:BA:F8:82:D4:FB', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 09:46:17'),
(42, 0, 'HH30A0C1CJT', '82:66:0E:40:C5:D3', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 10:41:39'),
(43, 0, 'HH30A0C1CJT', 'B6:BB:D4:13:9B:5C', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 11:46:29'),
(44, 0, 'HH30A0C1CJT', 'B6:BB:D4:13:9B:5C', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 11:46:34'),
(45, 0, 'HH30A0C1CJT', 'D6:6D:77:7F:23:E5', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 18:46:29'),
(46, 0, 'HH30A0C1CJT', 'D6:6D:77:7F:23:E5', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 18:46:35'),
(47, 0, 'HH30A0C1CJT', '7E:CE:AB:55:AE:69', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-05 21:51:24'),
(48, 0, 'HH30A0C1CJT', '7E:CE:AB:55:AE:69', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-05 21:51:29'),
(49, 0, 'HH30A0C1CJT', '5E:BE:17:2E:E8:D8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 00:04:01'),
(50, 0, 'HH30A0C1CJT', '5E:BE:17:2E:E8:D8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-06 00:04:06'),
(51, 0, 'HH30A0C1CJT', 'E2:4F:7D:E8:0D:44', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 07:56:57'),
(52, 0, 'HH30A0C1CJT', 'E2:4F:7D:E8:0D:44', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-06 07:57:02'),
(53, 0, 'HH30A0C1CJT', 'A6:02:71:75:35:13', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 15:39:34'),
(54, 0, 'HH30A0C1CJT', 'A6:02:71:75:35:13', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-06 15:39:39'),
(55, 0, 'HH30A0C1CJT', 'E8:5A:8B:B2:6B:75', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 18:45:37'),
(56, 0, 'HH30A0C1CJT', 'E6:74:89:3A:F2:CA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 18:47:54'),
(57, 0, 'HH30A0C1CJT', 'E6:74:89:3A:F2:CA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 18:48:38'),
(58, 0, 'HH30A0C1CJT', 'CA:F2:4E:1A:25:6F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 21:20:18'),
(59, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 21:21:29'),
(60, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-06 21:21:34'),
(61, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 21:22:28'),
(62, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-06 21:22:33'),
(63, 0, 'HH30A0C1CJT', '4A:C8:8F:51:7B:F9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-06 22:36:17'),
(64, 0, 'HH30A0C1CJT', 'D2:D9:49:0D:0D:0E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 07:07:11'),
(65, 0, 'HH30A0C1CJT', 'D2:D9:49:0D:0D:0E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 07:07:16'),
(66, 0, 'HH30A0C1CJT', 'B6:82:B1:B0:8E:04', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:08:21'),
(67, 0, 'HH30A0C1CJT', 'B6:82:B1:B0:8E:04', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:08:26'),
(68, 0, 'HH30A0C1CJT', '4E:83:F6:6A:B5:8E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:09:57'),
(69, 0, 'HH30A0C1CJT', '4E:83:F6:6A:B5:8E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:10:03'),
(70, 0, 'HH30A0C1CJT', '4E:83:F6:6A:B5:8E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:10:10'),
(71, 0, 'HH30A0C1CJT', '4E:83:F6:6A:B5:8E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:10:15'),
(72, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:41:57'),
(73, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:42:02'),
(74, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:42:20'),
(75, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:42:26'),
(76, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:43:03'),
(77, 0, 'HH30A0C1CJT', '22:C7:7F:3E:C6:69', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 08:43:08'),
(78, 0, 'HH30A0C1CJT', 'AA:37:8F:B8:A0:60', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 08:49:25'),
(79, 0, 'HH30A0C1CJT', 'AE:68:F1:AC:4C:EC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 11:49:17'),
(80, 0, 'HH30A0C1CJT', 'AE:68:F1:AC:4C:EC', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 11:49:22'),
(81, 0, 'HH30A0C1CJT', 'AE:68:F1:AC:4C:EC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 11:58:01'),
(82, 0, 'HH30A0C1CJT', 'AE:68:F1:AC:4C:EC', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 11:58:07'),
(83, 0, 'MikroTik', 'E0:1F:88:61:29:DC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 13:36:38'),
(84, 0, 'MikroTik', 'E0:1F:88:61:29:DC', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 13:36:44'),
(85, 0, 'HH30A0C1CJT', 'BA:AF:C5:BE:64:75', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 17:51:48'),
(86, 0, 'HH30A0C1CJT', '7E:CC:35:16:CF:30', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 19:07:10'),
(87, 0, 'HH30A0C1CJT', '7E:CC:35:16:CF:30', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 19:07:16'),
(88, 0, 'HH30A0C1CJT', '4A:ED:8D:42:51:45', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 19:44:32'),
(89, 0, 'HH30A0C1CJT', '4A:ED:8D:42:51:45', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 19:44:37'),
(90, 0, 'HH30A0C1CJT', 'EA:A9:67:DD:71:D1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-07 19:47:04'),
(91, 0, 'HH30A0C1CJT', 'EA:A9:67:DD:71:D1', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-07 19:47:09'),
(92, 0, 'HH30A0C1CJT', 'CE:52:0A:04:F9:BB', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 09:33:12'),
(93, 0, 'HH30A0C1CJT', 'CE:52:0A:04:F9:BB', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 09:33:17'),
(94, 0, 'HH30A0C1CJT', '66:58:67:B7:71:B5', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 10:58:30'),
(95, 0, 'HH30A0C1CJT', '66:58:67:B7:71:B5', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 10:58:35'),
(96, 0, 'HH30A0C1CJT', '5E:48:89:38:F8:BD', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 11:43:24'),
(97, 0, 'HH30A0C1CJT', '5E:48:89:38:F8:BD', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 11:43:29'),
(98, 0, 'HH30A0C1CJT', 'CA:B7:00:0E:D4:A0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:00:17'),
(99, 0, 'HH30A0C1CJT', 'CA:B7:00:0E:D4:A0', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 12:00:22'),
(100, 0, 'HH30A0C1CJT', 'CA:B7:00:0E:D4:A0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:02:52'),
(101, 0, 'HH30A0C1CJT', 'CA:B7:00:0E:D4:A0', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 12:02:57'),
(102, 0, 'HH30A0C1CJT', 'B6:C6:D8:87:2C:0E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:03:23'),
(103, 0, 'HH30A0C1CJT', 'B6:C6:D8:87:2C:0E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 12:03:28'),
(104, 0, 'HH30A0C1CJT', 'B6:C6:D8:87:2C:0E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:03:43'),
(105, 0, 'HH30A0C1CJT', 'E6:81:64:51:63:51', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:44:42'),
(106, 0, 'HH30A0C1CJT', 'E6:81:64:51:63:51', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 12:44:48'),
(107, 0, 'HH30A0C1CJT', 'E6:81:64:51:63:51', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 12:46:42'),
(108, 0, 'HH30A0C1CJT', '4A:CB:7D:EC:84:8B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 13:06:10'),
(109, 0, 'HH30A0C1CJT', '7A:5C:F0:0B:E9:B7', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 13:22:02'),
(110, 0, 'HH30A0C1CJT', '7A:5C:F0:0B:E9:B7', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 13:22:07'),
(111, 0, 'HH30A0C1CJT', '56:9B:1A:6F:6F:9B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 16:10:33'),
(112, 0, 'HH30A0C1CJT', '3E:FF:60:E1:E9:17', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 17:47:01'),
(113, 0, 'HH30A0C1CJT', '3E:FF:60:E1:E9:17', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 17:47:07'),
(114, 0, 'HH30A0C1CJT', 'E6:9A:73:3D:73:F9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 20:13:14'),
(115, 0, 'HH30A0C1CJT', 'E6:9A:73:3D:73:F9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 20:13:19'),
(116, 0, 'HH30A0C1CJT', 'E6:9A:73:3D:73:F9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 20:13:56'),
(117, 0, 'HH30A0C1CJT', 'E6:9A:73:3D:73:F9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 20:14:01'),
(118, 0, 'HH30A0C1CJT', '9A:A9:CA:B8:FF:AC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 20:16:30'),
(119, 0, 'HH30A0C1CJT', 'D6:92:51:DF:E8:71', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 20:34:18'),
(120, 0, 'HH30A0C1CJT', 'D6:92:51:DF:E8:71', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 20:34:23'),
(121, 0, 'HH30A0C1CJT', '2E:64:45:18:74:BA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 20:34:41'),
(122, 0, 'HH30A0C1CJT', '2E:64:45:18:74:BA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 20:34:46'),
(123, 0, 'HH30A0C1CJT', '7E:CE:AB:55:AE:69', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-08 21:58:23'),
(124, 0, 'HH30A0C1CJT', '7E:CE:AB:55:AE:69', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-08 21:58:29'),
(125, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 01:46:58'),
(126, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 01:47:05'),
(127, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 01:47:09'),
(128, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 01:47:11'),
(129, 0, 'HH30A0C1CJT', 'A2:8F:68:7B:DE:17', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 06:24:35'),
(130, 0, 'HH30A0C1CJT', 'A2:8F:68:7B:DE:17', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 06:24:40'),
(131, 0, 'HH30A0C1CJT', 'A2:8F:68:7B:DE:17', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 06:24:56'),
(132, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 07:00:13'),
(133, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 07:00:18'),
(134, 0, 'HH30A0C1CJT', '3A:E6:A0:5B:93:27', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 11:15:47'),
(135, 0, 'HH30A0C1CJT', '3A:E6:A0:5B:93:27', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 11:15:52'),
(136, 0, 'HH30A0C1CJT', '52:77:3C:8C:14:9B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 12:18:43'),
(137, 0, 'HH30A0C1CJT', 'AE:B0:BD:E0:7E:86', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 17:25:31'),
(138, 0, 'HH30A0C1CJT', 'AE:B0:BD:E0:7E:86', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 17:25:36'),
(139, 0, 'HH30A0C1CJT', '32:96:62:95:BD:9F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:17:57'),
(140, 0, 'HH30A0C1CJT', '32:96:62:95:BD:9F', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:18:02'),
(141, 0, 'HH30A0C1CJT', '0E:7E:79:B1:84:9E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:24:21'),
(142, 0, 'HH30A0C1CJT', '0E:7E:79:B1:84:9E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:24:26'),
(143, 0, 'HH30A0C1CJT', '62:A1:42:FD:B4:1A', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:44:42'),
(144, 0, 'HH30A0C1CJT', '62:A1:42:FD:B4:1A', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:44:47'),
(145, 0, 'HH30A0C1CJT', '62:A1:42:FD:B4:1A', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:47:44'),
(146, 0, 'HH30A0C1CJT', '62:A1:42:FD:B4:1A', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:47:49'),
(147, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:50:12'),
(148, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:50:18'),
(149, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 18:50:24'),
(150, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 18:50:29'),
(151, 0, 'HH30A0C1CJT', '60:1D:91:02:42:EB', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 19:01:03'),
(152, 0, 'HH30A0C1CJT', '60:1D:91:02:42:EB', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 19:01:08'),
(153, 0, 'HH30A0C1CJT', '60:1D:91:02:42:EB', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 19:01:13'),
(154, 0, 'HH30A0C1CJT', '36:73:36:46:48:58', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 19:54:47'),
(155, 0, 'HH30A0C1CJT', '36:73:36:46:48:58', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 19:54:52'),
(156, 0, 'HH30A0C1CJT', '12:1F:75:4E:7C:95', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 20:21:54'),
(157, 0, 'HH30A0C1CJT', '12:1F:75:4E:7C:95', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 20:22:01'),
(158, 0, 'HH30A0C1CJT', '32:FE:24:6D:AA:9B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 20:25:46'),
(159, 0, 'HH30A0C1CJT', '32:FE:24:6D:AA:9B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 20:26:47'),
(160, 0, 'HH30A0C1CJT', '7A:19:EF:E0:2A:D1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 20:32:31'),
(161, 0, 'HH30A0C1CJT', '7A:19:EF:E0:2A:D1', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 20:32:36'),
(162, 0, 'HH30A0C1CJT', '7A:19:EF:E0:2A:D1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 20:32:42'),
(163, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:01:06'),
(164, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:01:11'),
(165, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:01:33'),
(166, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:01:39'),
(167, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:03:15'),
(168, 0, 'HH30A0C1CJT', '0A:2E:3C:A7:C9:CA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:03:28'),
(169, 0, 'HH30A0C1CJT', '9E:43:BA:A3:1C:70', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:24:34'),
(170, 0, 'HH30A0C1CJT', '9E:43:BA:A3:1C:70', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:24:39'),
(171, 0, 'HH30A0C1CJT', 'CE:0D:38:2F:95:F1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:48:53'),
(172, 0, 'HH30A0C1CJT', 'CE:0D:38:2F:95:F1', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:48:59'),
(173, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:59:01'),
(174, 0, 'HH30A0C1CJT', 'C2:DD:72:91:EE:0F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:59:03'),
(175, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:59:06'),
(176, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-09 21:59:07'),
(177, 0, 'HH30A0C1CJT', 'C2:DD:72:91:EE:0F', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:59:08'),
(178, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-09 21:59:12'),
(179, 0, 'HH30A0C1CJT', '02:0B:6F:93:09:BC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 06:10:02'),
(180, 0, 'HH30A0C1CJT', '02:0B:6F:93:09:BC', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 06:10:07'),
(181, 0, 'HH30A0C1CJT', 'D6:01:9F:9A:90:24', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 08:42:05'),
(182, 0, 'HH30A0C1CJT', '0A:C4:38:1B:D3:B6', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 10:28:23'),
(183, 0, 'HH30A0C1CJT', '0A:C4:38:1B:D3:B6', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 10:28:28'),
(184, 0, 'HH30A0C1CJT', 'B2:AE:10:07:B8:90', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 12:04:06'),
(185, 0, 'HH30A0C1CJT', 'B2:AE:10:07:B8:90', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 12:04:11'),
(186, 0, 'HH30A0C1CJT', 'B2:AE:10:07:B8:90', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 12:04:28'),
(187, 0, 'HH30A0C1CJT', 'B2:AE:10:07:B8:90', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 12:04:33'),
(188, 0, 'HH30A0C1CJT', '9E:F5:71:72:72:0C', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 13:03:38'),
(189, 0, 'HH30A0C1CJT', '9E:F5:71:72:72:0C', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 13:03:43'),
(190, 0, 'HH30A0C1CJT', '98:F6:21:EC:8B:A8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 13:46:48'),
(191, 0, 'HH30A0C1CJT', '98:F6:21:EC:8B:A8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 13:46:53'),
(192, 0, 'HH30A0C1CJT', '82:82:24:09:B5:5B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 15:59:06'),
(193, 0, 'HH30A0C1CJT', '82:82:24:09:B5:5B', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 15:59:11'),
(194, 0, 'HH30A0C1CJT', '9A:AA:BE:FC:D2:D5', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 18:02:29'),
(195, 0, 'HH30A0C1CJT', '9A:AA:BE:FC:D2:D5', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 18:03:16'),
(196, 0, 'HH30A0C1CJT', '1A:D8:28:60:FF:CC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 18:25:34'),
(197, 0, 'HH30A0C1CJT', 'B6:FA:4C:7D:B4:5B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 18:26:33'),
(198, 0, 'HH30A0C1CJT', 'BA:26:56:2A:C4:4C', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:19:58'),
(199, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:20:01'),
(200, 0, 'HH30A0C1CJT', 'BA:26:56:2A:C4:4C', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:20:03'),
(201, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:20:06'),
(202, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:20:07'),
(203, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:20:12'),
(204, 0, 'HH30A0C1CJT', '76:1D:C7:C1:D3:66', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:28:36'),
(205, 0, 'HH30A0C1CJT', '0E:57:06:FF:4C:63', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:38:27'),
(206, 0, 'HH30A0C1CJT', '0E:57:06:FF:4C:63', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:38:32'),
(207, 0, 'HH30A0C1CJT', '0E:57:06:FF:4C:63', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:38:37'),
(208, 0, 'HH30A0C1CJT', '0E:57:06:FF:4C:63', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:38:43'),
(209, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:52:07'),
(210, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:52:12'),
(211, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 19:54:23'),
(212, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 19:54:28'),
(213, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 20:15:29'),
(214, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 20:15:35'),
(215, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 20:16:25'),
(216, 0, 'HH30A0C1CJT', '52:8D:A4:C2:5B:D9', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 20:16:30'),
(217, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 20:22:47'),
(218, 0, 'HH30A0C1CJT', '7E:B5:2F:F0:F4:A4', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 20:22:52'),
(219, 0, 'HH30A0C1CJT', '36:60:B5:8E:27:4E', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 21:14:37'),
(220, 0, 'HH30A0C1CJT', '36:60:B5:8E:27:4E', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 21:14:44'),
(221, 0, 'HH30A0C1CJT', '7E:02:7C:9A:99:CE', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-10 21:17:44'),
(222, 0, 'HH30A0C1CJT', '7E:02:7C:9A:99:CE', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-10 21:17:49'),
(223, 0, 'HH30A0C1CJT', 'D6:79:69:43:F6:84', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 09:36:17'),
(224, 0, 'HH30A0C1CJT', 'D6:79:69:43:F6:84', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 09:36:22'),
(225, 0, 'HH30A0C1CJT', '06:8C:5A:4B:06:73', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 10:26:12'),
(226, 0, 'HH30A0C1CJT', '06:8C:5A:4B:06:73', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 10:26:17'),
(227, 0, 'HH30A0C1CJT', '06:8C:5A:4B:06:73', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 10:26:40'),
(228, 0, 'HH30A0C1CJT', 'E2:02:69:50:2B:DD', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:02:51'),
(229, 0, 'HH30A0C1CJT', 'C2:7A:1E:15:96:77', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:20:23'),
(230, 0, 'HH30A0C1CJT', 'C2:7A:1E:15:96:77', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 15:20:29'),
(231, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:33:38'),
(232, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 15:33:43'),
(233, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:34:06'),
(234, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 15:34:11'),
(235, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:35:09'),
(236, 0, 'HH30A0C1CJT', '6A:12:5A:11:99:85', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 15:35:16'),
(237, 0, 'HH30A0C1CJT', '7A:28:33:88:5B:E0', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 16:49:20'),
(238, 0, 'HH30A0C1CJT', 'B6:BA:F4:06:25:88', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 18:12:53'),
(239, 0, 'HH30A0C1CJT', 'B6:BA:F4:06:25:88', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-11 18:12:58'),
(240, 0, 'HH30A0C1CJT', 'CA:A8:A8:2C:42:FA', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 21:23:48'),
(241, 0, 'HH30A0C1CJT', '22:8F:1C:FD:17:7F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-11 22:43:40'),
(254, 0, 'HH30A0C1CJT', '42:61:57:95:AD:D1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 09:29:03'),
(255, 0, 'HH30A0C1CJT', '42:61:57:95:AD:D1', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 09:29:08'),
(256, 0, 'HH30A0C1CJT', '42:61:57:95:AD:D1', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 09:29:22'),
(257, 0, 'HH30A0C1CJT', '42:61:57:95:AD:D1', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 09:29:27'),
(262, 0, 'HH30A0C1CJT', '4E:79:8C:01:56:7D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 10:49:45'),
(263, 0, 'HH30A0C1CJT', '4E:79:8C:01:56:7D', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 10:49:50'),
(264, 0, 'HH30A0C1CJT', '4E:79:8C:01:56:7D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 11:04:29'),
(265, 0, 'HH30A0C1CJT', '4E:79:8C:01:56:7D', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 11:04:34'),
(266, 0, 'HH30A0C1CJT', '4E:79:8C:01:56:7D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 11:04:56'),
(312, 0, 'HH30A0C1CJT', 'B6:93:BD:35:D0:0D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 16:47:08'),
(313, 0, 'HH30A0C1CJT', 'B6:93:BD:35:D0:0D', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 16:47:13'),
(314, 0, 'HH30A0C1CJT', 'B6:93:BD:35:D0:0D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 16:47:36'),
(315, 0, 'HH30A0C1CJT', 'B6:93:BD:35:D0:0D', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 16:47:47'),
(323, 0, 'HH30A0C1CJT', 'EE:8A:81:BB:E8:B5', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 17:56:01'),
(342, 0, 'HH30A0C1CJT', 'A4:4B:D5:E9:1E:33', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 19:39:19'),
(343, 0, 'HH30A0C1CJT', 'C6:FE:A9:FB:08:B8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:08:36'),
(344, 0, 'HH30A0C1CJT', 'C6:FE:A9:FB:08:B8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 20:08:41'),
(345, 0, 'HH30A0C1CJT', 'DA:0E:85:5F:85:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:16:51'),
(346, 0, 'HH30A0C1CJT', 'DA:0E:85:5F:85:D9', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:16:54'),
(347, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:18:05'),
(348, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 20:18:10'),
(349, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:18:22'),
(350, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 20:18:27'),
(351, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 20:19:47'),
(352, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 20:19:52'),
(361, 0, 'HH30A0C1CJT', 'B2:18:49:82:8A:EC', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 21:20:01'),
(362, 0, 'HH30A0C1CJT', 'B2:18:49:82:8A:EC', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 21:20:07'),
(363, 0, 'HH30A0C1CJT', '66:B1:B2:38:F9:7A', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 21:20:26'),
(364, 0, 'HH30A0C1CJT', '66:B1:B2:38:F9:7A', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 21:20:31'),
(365, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 21:22:13'),
(366, 0, 'HH30A0C1CJT', '62:99:6F:12:C1:D2', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 21:22:18'),
(367, 0, 'HH30A0C1CJT', '2A:68:91:91:D8:4C', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-12 21:51:29'),
(368, 0, 'HH30A0C1CJT', '2A:68:91:91:D8:4C', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-12 21:51:35'),
(425, 0, 'HH30A0C1CJT', '4A:55:9F:DD:CD:0F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 07:43:36'),
(426, 0, 'HH30A0C1CJT', '4A:55:9F:DD:CD:0F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 08:01:26'),
(427, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 08:15:53'),
(428, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 08:15:58'),
(429, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 08:16:20'),
(430, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 08:16:26'),
(431, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 08:16:32'),
(432, 0, 'HH30A0C1CJT', 'CE:7F:B6:9B:8B:63', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 09:39:10'),
(433, 0, 'HH30A0C1CJT', 'CE:7F:B6:9B:8B:63', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 09:39:15'),
(434, 0, 'HH30A0C1CJT', 'CE:7F:B6:9B:8B:63', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 09:39:28'),
(435, 0, 'HH30A0C1CJT', '56:A8:B7:86:07:F4', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 14:09:47'),
(436, 0, 'HH30A0C1CJT', '56:A8:B7:86:07:F4', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 14:09:52'),
(437, 0, 'HH30A0C1CJT', '56:A8:B7:86:07:F4', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 14:10:10'),
(438, 0, 'HH30A0C1CJT', '56:A8:B7:86:07:F4', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 14:10:15'),
(439, 0, 'HH30A0C1CJT', '86:28:0A:2A:38:CE', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 17:06:11'),
(440, 0, 'HH30A0C1CJT', '86:28:0A:2A:38:CE', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 17:06:16'),
(441, 0, 'HH30A0C1CJT', '1A:AD:0E:05:FE:B8', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 19:43:06'),
(442, 0, 'HH30A0C1CJT', '1A:AD:0E:05:FE:B8', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 19:43:13'),
(443, 0, 'HH30A0C1CJT', '9E:01:17:80:23:1A', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 23:14:43'),
(444, 0, 'HH30A0C1CJT', '9E:01:17:80:23:1A', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 23:14:48'),
(445, 0, 'HH30A0C1CJT', '96:55:41:07:D0:2A', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-13 23:41:56'),
(446, 0, 'HH30A0C1CJT', '96:55:41:07:D0:2A', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-13 23:42:01'),
(447, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 00:08:39'),
(448, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 00:08:44'),
(449, 0, 'HH30A0C1CJT', 'CA:B0:0E:EE:2F:5C', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 10:02:58'),
(450, 0, 'HH30A0C1CJT', 'CA:B0:0E:EE:2F:5C', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 10:03:04'),
(451, 0, 'HH30A0C1CJT', '66:01:E9:C7:63:99', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 10:05:28'),
(452, 0, 'HH30A0C1CJT', '06:F1:35:B6:6A:14', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 12:19:50'),
(453, 0, 'HH30A0C1CJT', '06:F1:35:B6:6A:14', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 12:19:56'),
(454, 0, 'HH30A0C1CJT', 'AA:E2:32:DF:5F:5B', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 17:51:05'),
(455, 0, 'HH30A0C1CJT', 'AA:E2:32:DF:5F:5B', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 17:51:10'),
(456, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 18:57:35'),
(457, 0, 'HH30A0C1CJT', 'EA:A6:8B:1C:8C:8F', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 18:57:40'),
(458, 0, 'HH30A0C1CJT', '4E:3F:9B:04:15:68', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 19:11:46'),
(459, 0, 'HH30A0C1CJT', '4E:3F:9B:04:15:68', '177.221.46.201', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 19:11:49'),
(460, 0, 'HH30A0C1CJT', '4E:3F:9B:04:15:68', '177.221.46.201', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 19:11:54'),
(461, 0, 'HH30A0C1CJT', 'CE:23:AA:E2:D8:82', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 20:49:36'),
(462, 0, 'HH30A0C1CJT', 'CE:23:AA:E2:D8:82', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 20:49:41'),
(463, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 21:43:51'),
(464, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 21:47:14'),
(465, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 21:48:05'),
(466, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 21:49:34');
INSERT INTO `auditoria_splash` (`id`, `processed`, `hs_serial`, `cl_mac_address`, `ip_origem`, `ip_cliente`, `pag_click`, `imagem`, `dsc_identity`, `created_at`) VALUES
(467, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 21:49:39'),
(468, 0, 'HH30A0C1CJT', '36:E0:E6:4C:44:D7', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 22:24:41'),
(469, 0, 'HH30A0C1CJT', '36:E0:E6:4C:44:D7', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 22:24:46'),
(470, 0, 'HH30A0C1CJT', '36:E0:E6:4C:44:D7', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 22:25:00'),
(471, 0, 'HH30A0C1CJT', '36:E0:E6:4C:44:D7', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 22:25:05'),
(472, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-14 23:15:16'),
(473, 0, 'HH30A0C1CJT', '5E:69:A0:96:AF:D6', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-14 23:15:21'),
(474, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', '192.168.88.226', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 02:52:42'),
(475, 0, 'HH30A0C1CJT', 'E2:1A:B0:99:73:FF', '177.221.46.201', '192.168.88.226', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 02:52:47'),
(476, 0, 'HH30A0C1CJT', '66:28:63:80:A8:BA', '177.221.46.201', '192.168.88.93', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 07:12:39'),
(477, 0, 'HH30A0C1CJT', '66:28:63:80:A8:BA', '177.221.46.201', '192.168.88.93', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 07:12:45'),
(478, 0, 'HH30A0C1CJT', 'F2:FC:B8:B2:1D:7C', '177.221.46.201', '192.168.88.92', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 09:13:27'),
(479, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:21:08'),
(480, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:21:13'),
(481, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:22:22'),
(482, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:22:27'),
(483, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:29:40'),
(484, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:29:45'),
(485, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:35:10'),
(486, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:35:15'),
(487, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:36:09'),
(488, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:36:14'),
(489, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:37:25'),
(490, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:37:30'),
(491, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:40:00'),
(492, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:40:05'),
(493, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:40:17'),
(494, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:40:23'),
(495, 0, '71AF07A21A3D', 'DC:56:7B:1C:CC:59', '177.81.78.53', '192.168.88.252', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:40:47'),
(496, 0, '71AF07A21A3D', 'DC:56:7B:1C:CC:59', '177.81.78.53', '192.168.88.252', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:40:52'),
(497, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:42:18'),
(498, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:42:23'),
(499, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:42:42'),
(500, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:42:48'),
(501, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:44:26'),
(502, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:44:31'),
(503, 0, '71AF07A21A3D', '62:4B:CA:89:4D:DF', '177.81.78.53', '192.168.88.250', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:44:43'),
(504, 0, '71AF07A21A3D', '62:4B:CA:89:4D:DF', '177.81.78.53', '192.168.88.250', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:44:48'),
(505, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:45:58'),
(506, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:46:03'),
(507, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:46:26'),
(508, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:46:31'),
(509, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:47:49'),
(510, 0, '71AF07A21A3D', '62:4B:CA:89:4D:DF', '177.81.78.53', '192.168.88.250', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:47:51'),
(511, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:47:54'),
(512, 0, '71AF07A21A3D', '62:4B:CA:89:4D:DF', '177.81.78.53', '192.168.88.250', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:47:56'),
(513, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 12:48:47'),
(514, 0, '71AF07A21A3D', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 12:48:52'),
(515, 0, '71AF07A21A3D', 'BC:98:DF:83:9C:33', '177.81.78.53', '192.168.88.248', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 13:03:15'),
(516, 0, '71AF07A21A3D', 'BC:98:DF:83:9C:33', '177.81.78.53', '192.168.88.248', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 13:03:20'),
(517, 0, 'CC3E0CCDEC35', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 13:18:56'),
(518, 0, 'CC3E0CCDEC35', '9A:43:8F:C4:92:30', '177.81.78.53', '192.168.88.251', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 13:19:02'),
(519, 0, '3D78016D3437', 'EA:3F:EE:46:FD:88', '45.239.174.240', '192.168.88.254', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 13:20:27'),
(520, 0, '3D78016D3437', 'EA:3F:EE:46:FD:88', '45.239.174.240', '192.168.88.254', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 13:20:32'),
(521, 0, 'HH30A0C1CJT', 'CE:23:AA:E2:D8:82', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 13:31:56'),
(522, 0, 'HH30A0C1CJT', 'CE:23:AA:E2:D8:82', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 13:32:01'),
(523, 0, 'HH30A0C1CJT', 'E6:74:89:3A:F2:CA', '177.221.46.201', '192.168.88.131', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 16:59:04'),
(524, 0, 'HH30A0C1CJT', 'DE:D2:05:74:C3:46', '177.221.46.201', '192.168.88.86', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 17:32:14'),
(525, 0, 'HH30A0C1CJT', 'DE:D2:05:74:C3:46', '177.221.46.201', '192.168.88.86', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 17:32:19'),
(526, 0, 'HH30A0C1CJT', 'DE:D2:05:74:C3:46', '177.221.46.201', '192.168.88.86', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 17:32:30'),
(527, 0, 'HH30A0C1CJT', 'DE:D2:05:74:C3:46', '177.221.46.201', '192.168.88.86', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 17:32:35'),
(528, 0, 'HH30A0C1CJT', '72:57:56:9F:53:36', '177.221.46.201', '192.168.88.81', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-15 22:32:47'),
(529, 0, 'HH30A0C1CJT', '72:57:56:9F:53:36', '177.221.46.201', '192.168.88.81', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-15 22:32:52'),
(530, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', '192.168.88.172', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 06:39:07'),
(531, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', '192.168.88.172', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 06:39:12'),
(532, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', '192.168.88.172', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 06:39:17'),
(533, 0, 'HH30A0C1CJT', '16:0D:AF:04:4C:B6', '177.221.46.201', '192.168.88.172', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 06:39:22'),
(534, 0, 'HH30A0C1CJT', '06:16:64:36:B3:0B', '177.221.46.201', '192.168.88.78', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 07:52:00'),
(535, 0, 'HH30A0C1CJT', '92:E9:0C:70:AC:77', '177.221.46.201', '192.168.88.76', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 11:00:46'),
(536, 0, 'HH30A0C1CJT', '06:16:64:36:B3:0B', '177.221.46.201', '192.168.88.78', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 12:00:46'),
(537, 0, 'HH30A0C1CJT', '06:16:64:36:B3:0B', '177.221.46.201', '192.168.88.78', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 12:00:51'),
(538, 0, 'HH30A0C1CJT', 'FE:4E:E2:0D:DB:9A', '177.221.46.201', '192.168.88.70', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 17:18:37'),
(539, 0, 'HH30A0C1CJT', 'FE:4E:E2:0D:DB:9A', '177.221.46.201', '192.168.88.70', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 17:18:45'),
(540, 0, 'HH30A0C1CJT', 'FE:4E:E2:0D:DB:9A', '177.221.46.201', '192.168.88.70', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 17:18:51'),
(541, 0, 'HH30A0C1CJT', '1E:61:AD:B5:D2:D1', '177.221.46.201', '192.168.88.67', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 17:57:02'),
(542, 0, 'HH30A0C1CJT', '1E:61:AD:B5:D2:D1', '177.221.46.201', '192.168.88.67', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 17:57:07'),
(543, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 18:11:09'),
(544, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 18:11:14'),
(545, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 18:11:35'),
(546, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 18:11:40'),
(547, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 18:14:26'),
(548, 0, 'HH30A0C1CJT', '06:41:2C:4A:65:85', '177.221.46.201', '192.168.88.64', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 18:14:31'),
(549, 0, 'HH30A0C1CJT', '9E:67:2C:80:E6:EF', '177.221.46.201', '192.168.88.59', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 18:58:04'),
(550, 0, 'HH30A0C1CJT', '9E:67:2C:80:E6:EF', '177.221.46.201', '192.168.88.59', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 18:58:10'),
(551, 0, 'HH30A0C1CJT', 'FA:45:CD:5D:47:37', '177.221.46.201', '192.168.88.58', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:09:27'),
(552, 0, 'HH30A0C1CJT', 'FA:45:CD:5D:47:37', '177.221.46.201', '192.168.88.58', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 19:09:50'),
(553, 0, 'HH30A0C1CJT', 'FA:45:CD:5D:47:37', '177.221.46.201', '192.168.88.58', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:09:51'),
(554, 0, 'HH30A0C1CJT', '4A:AF:E8:4D:01:49', '177.221.46.201', '192.168.88.57', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:10:03'),
(555, 0, 'HH30A0C1CJT', '4A:AF:E8:4D:01:49', '177.221.46.201', '192.168.88.57', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 19:10:08'),
(556, 0, 'HH30A0C1CJT', 'FA:45:CD:5D:47:37', '177.221.46.201', '192.168.88.58', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:10:24'),
(557, 0, 'HH30A0C1CJT', '5A:10:0F:B6:45:80', '177.221.46.201', '192.168.88.53', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:34:11'),
(558, 0, 'HH30A0C1CJT', '5A:10:0F:B6:45:80', '177.221.46.201', '192.168.88.53', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 19:34:16'),
(559, 0, 'HH30A0C1CJT', '36:EB:05:29:6F:00', '177.221.46.201', '192.168.88.52', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 19:35:46'),
(560, 0, 'HH30A0C1CJT', '36:EB:05:29:6F:00', '177.221.46.201', '192.168.88.52', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 19:35:52'),
(561, 0, 'HH30A0C1CJT', '36:EB:05:29:6F:00', '177.221.46.201', '192.168.88.52', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 20:26:13'),
(562, 0, 'HH30A0C1CJT', '36:EB:05:29:6F:00', '177.221.46.201', '192.168.88.52', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 20:26:18'),
(563, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:25:18'),
(564, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:25:24'),
(565, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:25:36'),
(566, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:25:41'),
(567, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', '192.168.88.47', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:26:11'),
(568, 0, 'HH30A0C1CJT', 'F6:67:29:D8:AE:EA', '177.221.46.201', '192.168.88.47', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:26:16'),
(569, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:26:42'),
(570, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:26:47'),
(571, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:27:50'),
(572, 0, 'HH30A0C1CJT', 'FE:59:CC:90:17:A7', '177.221.46.201', '192.168.88.46', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:27:55'),
(573, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:53:19'),
(574, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:53:26'),
(575, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:53:31'),
(576, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 21:53:43'),
(577, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 21:53:48'),
(578, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 23:01:27'),
(579, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-16 23:01:32'),
(580, 0, 'HH30A0C1CJT', 'D6:FF:A9:F0:16:80', '177.221.46.201', '192.168.88.44', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-16 23:27:25'),
(581, 0, 'HH30A0C1CJT', '02:3A:48:90:73:11', '177.221.46.201', '192.168.88.45', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 00:55:35'),
(582, 0, 'HH30A0C1CJT', 'E6:77:BE:D6:83:EF', '177.221.46.201', '192.168.88.43', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 06:02:04'),
(583, 0, 'HH30A0C1CJT', 'E6:77:BE:D6:83:EF', '177.221.46.201', '192.168.88.43', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 06:02:09'),
(584, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 08:44:27'),
(585, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 08:44:32'),
(586, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 08:46:20'),
(587, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 08:46:26'),
(588, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 09:16:18'),
(589, 0, 'HH30A0C1CJT', '22:28:D8:11:25:D5', '177.221.46.201', '192.168.88.36', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 09:16:23'),
(590, 0, 'HH30A0C1CJT', 'B2:BB:F6:88:8B:D9', '177.221.46.201', '192.168.88.35', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 10:11:31'),
(591, 0, 'HH30A0C1CJT', 'B2:BB:F6:88:8B:D9', '177.221.46.201', '192.168.88.35', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 10:11:37'),
(592, 0, 'HH30A0C1CJT', 'F2:C0:5C:F9:ED:A7', '177.221.46.201', '192.168.88.31', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 11:26:29'),
(593, 0, 'HH30A0C1CJT', 'F2:C0:5C:F9:ED:A7', '177.221.46.201', '192.168.88.31', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 11:26:34'),
(594, 0, 'HH30A0C1CJT', 'F2:C0:5C:F9:ED:A7', '177.221.46.201', '192.168.88.31', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 11:27:03'),
(595, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 13:37:37'),
(596, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 13:37:42'),
(597, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 13:38:18'),
(598, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 13:38:23'),
(599, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 13:41:26'),
(600, 0, 'HH30A0C1CJT', '9A:0D:13:AA:F1:E4', '177.221.46.201', '192.168.88.23', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 13:41:31'),
(601, 0, 'HH30A0C1CJT', '8E:04:3A:C2:A1:C0', '177.221.46.201', '192.168.88.19', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 15:35:12'),
(602, 0, 'HH30A0C1CJT', 'C2:8F:09:8E:0C:CB', '177.221.46.201', '192.168.88.17', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 15:45:13'),
(603, 0, 'HH30A0C1CJT', 'C2:8F:09:8E:0C:CB', '177.221.46.201', '192.168.88.17', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 15:45:18'),
(604, 0, 'HH30A0C1CJT', 'C2:8F:09:8E:0C:CB', '177.221.46.201', '192.168.88.17', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 15:45:34'),
(605, 0, 'HH30A0C1CJT', 'C2:8F:09:8E:0C:CB', '177.221.46.201', '192.168.88.17', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 15:45:39'),
(606, 0, 'HH30A0C1CJT', 'C2:8F:09:8E:0C:CB', '177.221.46.201', '192.168.88.17', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 15:46:00'),
(607, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:13:05'),
(608, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:13:11'),
(609, 0, 'HH30A0C1CJT', 'B2:F7:B0:03:6C:49', '177.221.46.201', '192.168.88.74', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:13:43'),
(610, 0, 'HH30A0C1CJT', 'B2:F7:B0:03:6C:49', '177.221.46.201', '192.168.88.74', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:13:48'),
(611, 0, 'HH30A0C1CJT', 'B6:8E:32:5E:F8:68', '177.221.46.201', '192.168.88.75', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:14:43'),
(612, 0, 'HH30A0C1CJT', 'B6:8E:32:5E:F8:68', '177.221.46.201', '192.168.88.75', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:14:48'),
(613, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:28:04'),
(614, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:28:09'),
(615, 0, 'HH30A0C1CJT', '6E:47:06:5A:8C:9C', '177.221.46.201', '192.168.88.76', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:29:19'),
(616, 0, 'HH30A0C1CJT', '6E:47:06:5A:8C:9C', '177.221.46.201', '192.168.88.76', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:29:24'),
(617, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:32:55'),
(618, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:33:00'),
(619, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:34:06'),
(620, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', NULL, 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:34:12'),
(621, 0, 'HH30A0C1CJT', 'C6:8E:90:A2:C7:14', '177.221.46.201', '192.168.88.78', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:36:02'),
(622, 0, 'HH30A0C1CJT', '76:47:22:D0:CB:BC', '177.221.46.201', '192.168.88.79', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:37:19'),
(623, 0, 'HH30A0C1CJT', '76:47:22:D0:CB:BC', '177.221.46.201', '192.168.88.79', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:37:24'),
(624, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:52:35'),
(625, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:52:40'),
(626, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:53:45'),
(627, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:53:50'),
(628, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 18:58:07'),
(629, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.64.194', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 18:58:12'),
(630, 0, 'HH30A0C1CJT', '66:5D:37:83:EC:D9', '177.221.46.201', '192.168.88.80', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 19:10:01'),
(631, 0, 'HH30A0C1CJT', '66:5D:37:83:EC:D9', '177.221.46.201', '192.168.88.80', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 19:10:06'),
(632, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 19:43:51'),
(633, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 19:43:57'),
(634, 0, 'HH30A0C1CJT', 'BA:B5:7E:54:D7:3E', '177.221.46.201', '192.168.88.83', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 20:35:41'),
(635, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 20:37:29'),
(636, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 20:37:34'),
(637, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 20:37:46'),
(638, 0, 'HH30A0C1CJT', '8E:C6:A6:B3:BB:AE', '177.221.46.201', '192.168.88.73', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 20:37:51'),
(639, 0, 'HH30A0C1CJT', 'B6:8E:32:5E:F8:68', '177.221.46.201', '192.168.88.75', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 20:41:52'),
(640, 0, 'HH30A0C1CJT', 'B6:8E:32:5E:F8:68', '177.221.46.201', '192.168.88.75', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 20:41:57'),
(641, 0, 'HH30A0C1CJT', '22:6F:36:94:CF:2E', '177.221.46.201', '192.168.88.94', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 22:06:19'),
(642, 0, 'HH30A0C1CJT', '22:6F:36:94:CF:2E', '177.221.46.201', '192.168.88.94', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 22:06:24'),
(643, 0, 'HH30A0C1CJT', '22:6F:36:94:CF:2E', '177.221.46.201', '192.168.88.94', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 22:06:44'),
(644, 0, 'HH30A0C1CJT', '5E:F3:5B:94:D3:0C', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 22:34:32'),
(645, 0, 'HH30A0C1CJT', '5E:F3:5B:94:D3:0C', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 22:34:37'),
(646, 0, 'HH30A0C1CJT', '6A:A6:5B:36:A0:65', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 23:12:48'),
(647, 0, 'HH30A0C1CJT', '6A:A6:5B:36:A0:65', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 23:12:53'),
(648, 0, 'HH30A0C1CJT', '6A:A6:5B:36:A0:65', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 23:13:02'),
(649, 0, 'HH30A0C1CJT', '6A:A6:5B:36:A0:65', '177.221.46.201', '192.168.88.96', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 23:13:07'),
(650, 0, 'HH30A0C1CJT', '5E:F3:5B:94:D3:0C', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-17 23:31:23'),
(651, 0, 'HH30A0C1CJT', '5E:F3:5B:94:D3:0C', '177.221.46.201', '192.168.88.95', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-17 23:31:28'),
(652, 0, 'HH30A0C1CJT', '86:28:0A:2A:38:CE', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 06:38:53'),
(653, 0, 'HH30A0C1CJT', '86:28:0A:2A:38:CE', '177.221.46.201', '192.168.88.97', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 06:38:58'),
(654, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 06:48:23'),
(655, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 06:48:28'),
(656, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 06:48:38'),
(657, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 06:48:43'),
(658, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 06:48:48'),
(659, 0, 'HH30A0C1CJT', 'E6:6E:80:EF:EF:94', '177.221.46.201', '192.168.88.98', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 06:48:53'),
(660, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:05:20'),
(661, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:05:26'),
(662, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:05:50'),
(663, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:05:56'),
(664, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:06:13'),
(665, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:06:18'),
(666, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:06:48'),
(667, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:06:53'),
(668, 0, 'HH30A0C1CJT', '7C:F3:1B:FE:5C:D1', '177.221.46.201', '192.168.88.100', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:31:38'),
(669, 0, 'HH30A0C1CJT', '7C:F3:1B:FE:5C:D1', '177.221.46.201', '192.168.88.100', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:31:48'),
(670, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 07:43:54'),
(671, 0, 'HH30A0C1CJT', '72:00:E7:39:D2:20', '177.221.46.201', '192.168.88.99', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 07:43:59'),
(672, 0, 'HH30A0C1CJT', 'EE:DB:B7:4F:AE:56', '177.221.46.201', '192.168.88.101', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 08:11:53'),
(673, 0, 'HH30A0C1CJT', 'EE:DB:B7:4F:AE:56', '177.221.46.201', '192.168.88.101', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 08:11:58'),
(674, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 08:52:57'),
(675, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 08:53:02'),
(676, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, '2025-11-18 09:14:36'),
(677, 0, 'C6CC0BE2C0DA', '18:0D:2C:3F:AB:FC', '179.42.122.18', '192.168.87.255', 'index.html', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, '2025-11-18 09:14:41');

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

--
-- Estrutura para tabela `configuracao_precos`
--

CREATE TABLE `configuracao_precos` (
  `id` bigint UNSIGNED NOT NULL,
  `chave` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Chave de configuração (ex: preco_semanal, preco_mensal)',
  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nome descritivo da configuração',
  `valor` decimal(10,2) NOT NULL COMMENT 'Valor em reais',
  `descricao` text COLLATE utf8mb4_unicode_ci COMMENT 'Descrição detalhada',
  `ativo` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Se a configuração está ativa',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `configuracao_precos`
--

INSERT INTO `configuracao_precos` (`id`, `chave`, `nome`, `valor`, `descricao`, `ativo`, `created_at`, `updated_at`) VALUES
(1, 'preco_semanal', 'Publicidade Semanal', 150.00, 'Valor para publicidade por 1 semana', 1, '2025-11-10 18:27:06', '2025-11-10 18:27:06'),
(2, 'preco_mensal', 'Publicidade Mensal', 600.00, 'Valor para publicidade por 1 mês (4 semanas)', 1, '2025-11-10 18:27:06', '2025-11-10 18:27:06'),
(3, 'multiplicador_mensal', 'Multiplicador Mensal', 4.00, 'Quantidade de semanas em um mês', 1, '2025-11-10 18:27:06', '2025-11-10 18:27:06');

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

--
-- Estrutura para tabela `criativos`
--

CREATE TABLE `criativos` (
  `id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED DEFAULT NULL,
  `tipo` enum('imagem','video','html','quiz','nps') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'imagem',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `formato` enum('jpg','png','gif','mp4','html') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'jpg',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conteudo_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status_aprovacao` enum('pendente','aprovado','rejeitado','bloqueado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aprovado',
  `aprovado_por` bigint UNSIGNED DEFAULT NULL,
  `aprovado_em` timestamp NULL DEFAULT NULL,
  `motivo_rejeicao` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bloqueado_permanente` tinyint(1) NOT NULL DEFAULT '0',
  `empresa_legado_id` bigint UNSIGNED DEFAULT NULL,
  `equipment_serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `views_count` int UNSIGNED NOT NULL DEFAULT '0',
  `position` int DEFAULT NULL,
  `start_datetime` datetime DEFAULT NULL,
  `end_datetime` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `criativos`
--

INSERT INTO `criativos` (`id`, `franquia_id`, `tipo`, `title`, `formato`, `path`, `conteudo_html`, `status_aprovacao`, `aprovado_por`, `aprovado_em`, `motivo_rejeicao`, `bloqueado_permanente`, `empresa_legado_id`, `equipment_serial`, `status`, `views_count`, `position`, `start_datetime`, `end_datetime`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, NULL, 'imagem', 'Freefi - Instruções', 'png', 'midias/d0b3c953a97c30537d0997aefb971b12.png', NULL, 'aprovado', NULL, NULL, NULL, 0, 1, NULL, 0, 0, NULL, NULL, NULL, '2025-11-04 06:56:29', '2025-11-04 06:56:29', NULL, 1, 1, NULL),
(2, NULL, 'imagem', 'Anuncie Conosco', 'png', 'midias/448f4db478c93dac8cb77cfde8e875ef.png', NULL, 'aprovado', NULL, NULL, NULL, 0, 1, NULL, 0, 0, NULL, NULL, NULL, '2025-11-04 06:56:57', '2025-11-04 06:56:57', NULL, 1, 1, NULL);

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

--
-- Estrutura para tabela `empresa_user`
--

CREATE TABLE `empresa_user` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `empresa_id` bigint UNSIGNED NOT NULL,
  `role` enum('gestor','operador','visualizador') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'gestor' COMMENT 'Papel do usuário nesta empresa específica',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `estatisticas_midia`
--

CREATE TABLE `estatisticas_midia` (
  `id` bigint UNSIGNED NOT NULL,
  `publicacao_id` bigint UNSIGNED NOT NULL,
  `criativo_id` bigint UNSIGNED NOT NULL,
  `cliente_id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED NOT NULL,
  `hotspot_id` bigint UNSIGNED NOT NULL,
  `data` date NOT NULL,
  `total_impressoes` int NOT NULL DEFAULT '0',
  `total_cliques` int NOT NULL DEFAULT '0',
  `tempo_medio_visualizacao` int NOT NULL DEFAULT '0' COMMENT 'Em segundos',
  `dispositivos_unicos` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `franquia_formatos_permitidos`
--

CREATE TABLE `franquia_formatos_permitidos` (
  `id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED NOT NULL,
  `formato` enum('jpg','png','gif','mp4','html') COLLATE utf8mb4_unicode_ci NOT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `groups`
--

CREATE TABLE `groups` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `group_permission`
--

CREATE TABLE `group_permission` (
  `group_id` bigint UNSIGNED NOT NULL,
  `permission_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `group_user`
--

CREATE TABLE `group_user` (
  `group_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `logs_acesso_wifi`
--

CREATE TABLE `logs_acesso_wifi` (
  `id` bigint UNSIGNED NOT NULL,
  `hotspot_id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED NOT NULL,
  `cliente_id` bigint UNSIGNED DEFAULT NULL,
  `mac_address_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Hash do MAC para privacidade',
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `publicacao_visualizada_id` bigint UNSIGNED DEFAULT NULL,
  `tempo_sessao` int NOT NULL DEFAULT '0',
  `dispositivo_tipo` enum('mobile','desktop','tablet','outro') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'outro',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `midias_pedido`
--

CREATE TABLE `midias_pedido` (
  `id` bigint UNSIGNED NOT NULL,
  `pedido_id` bigint UNSIGNED NOT NULL,
  `criativo_id` bigint UNSIGNED DEFAULT NULL,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Título do criativo',
  `arquivo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Caminho do arquivo criativo',
  `tipo_arquivo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'MIME type',
  `duracao` int DEFAULT NULL COMMENT 'Duração em segundos (para vídeos)',
  `dimensoes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Largura x Altura (ex: 1920x1080)',
  `tamanho_arquivo` bigint DEFAULT NULL COMMENT 'Tamanho em bytes',
  `status` enum('pendente','aprovado','rejeitado','publicado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendente',
  `aprovado_por` bigint UNSIGNED DEFAULT NULL,
  `aprovado_em` timestamp NULL DEFAULT NULL,
  `observacoes` text COLLATE utf8mb4_unicode_ci,
  `motivo_rejeicao` text COLLATE utf8mb4_unicode_ci,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_10_10_000000_create_groups_and_permissions_tables', 1),
(5, '2025_10_10_110000_create_empresas_table', 1),
(6, '2025_10_10_110001_create_midias_table', 1),
(7, '2025_10_10_120000_add_position_and_datetime_to_midias_table', 1),
(8, '2025_10_10_130000_make_midias_path_nullable', 1),
(9, '2025_10_11_011547_alter_midias_table_increase_title_width', 1),
(10, '2025_10_11_140000_add_status_and_softdeletes_to_midias_table', 1),
(11, '2025_10_12_030351_add_views_count_to_midias_table', 1),
(12, '2025_10_12_043137_add_userstamps_to_midias_table', 1),
(13, '2025_10_12_053010_add_status_and_userstamps_to_empresas_table', 1),
(14, '2025_10_13_121454_add_standard_fields_to_groups_table', 1),
(15, '2025_10_13_121454_add_standard_fields_to_permissions_table', 1),
(16, '2025_10_13_121454_add_standard_fields_to_users_table', 1),
(17, '2025_10_13_121621_create_roles_table', 1),
(18, '2025_10_13_121622_add_standard_fields_to_roles_table', 1),
(19, '2025_10_16_020944_add_logomarca_to_empresas_table', 1),
(20, '2025_10_17_075540_create_hotspots_table', 1),
(21, '2025_10_17_082055_add_last_activity_at_to_hotspots_table', 1),
(22, '2025_10_17_092625_add_hierarquia_fields_to_empresas_table', 1),
(23, '2025_10_17_092633_add_empresa_and_approval_fields_to_users_table', 1),
(24, '2025_10_17_092642_add_franquia_and_situacao_to_hotspots_table', 1),
(25, '2025_10_17_092649_transform_midias_to_criativos_table', 1),
(26, '2025_10_17_092655_create_publicacoes_table', 1),
(27, '2025_10_17_092702_create_franquia_formatos_permitidos_table', 1),
(28, '2025_10_17_092709_create_estatisticas_midia_table', 1),
(29, '2025_10_17_092715_create_logs_acesso_wifi_table', 1),
(30, '2025_10_17_101035_make_empresa_legado_id_nullable_in_criativos_table', 1),
(31, '2025_10_17_180512_add_equipment_fields_to_publicacoes_table', 1),
(32, '2025_10_17_181919_fix_criativos_charset', 1),
(33, '2025_10_17_182854_update_publicacoes_alcance_to_empresa', 1),
(34, '2025_10_17_184815_add_avatar_to_users_table', 1),
(35, '2025_10_18_130244_increase_codigo_convite_length_in_empresas_table', 1),
(36, '2025_10_18_153251_add_visualization_and_position_fields_to_publicacoes_table', 1),
(37, '2025_10_18_160049_change_publicacoes_dates_to_datetime', 1),
(38, '2025_10_19_013043_add_vpn_fields_to_hotspots_table', 1),
(39, '2025_10_19_023511_add_tracking_fields_to_publicacoes_table', 1),
(40, '2025_10_19_023513_create_walled_gardens_table', 1),
(41, '2025_10_19_023516_create_publicacao_impressoes_table', 1),
(42, '2025_10_19_023518_create_publicacao_cliques_table', 1),
(43, '2025_10_21_131620_add_is_superadmin_to_users_table', 1),
(44, '2025_10_21_202616_create_auditoria_splash_table', 1),
(45, '2025_11_03_030000_create_hotspot_customizations_table', 2),
(46, '2025_11_03_181317_add_processed_to_auditoria_splash_table', 2),
(47, '2025_11_10_162743_add_mercadopago_fields_to_empresas_table', 3),
(48, '2025_11_09_154021_create_empresa_user_table', 4),
(49, '2025_11_09_224911_add_aprovacao_fields_to_hotspots_table', 4),
(50, '2025_11_09_225202_add_token_convite_to_empresas_table', 4),
(51, '2025_11_09_225950_add_aprovacao_fields_to_empresas_table', 4),
(52, '2025_11_10_131100_create_configuracao_precos_table', 4),
(53, '2025_11_10_131136_create_pedidos_publicidade_table', 4),
(54, '2025_11_10_132242_add_codigo_to_empresas_table', 4),
(55, '2025_11_10_142945_create_midias_pedido_table', 4),
(56, '2025_11_10_142953_create_transacoes_financeiras_table', 4),
(57, '2025_11_10_142959_add_pedido_id_to_publicacoes_table', 4),
(58, '2025_11_12_221707_add_cod_cliente_cod_franquia_to_hotspots_table', 5),
(59, '2025_11_12_222802_reorder_cod_fields_in_hotspots_table', 6),
(60, '2025_11_13_024617_create_tawkto_configs_table', 7);

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

--
-- Estrutura para tabela `pedidos_publicidade`
--

CREATE TABLE `pedidos_publicidade` (
  `id` bigint UNSIGNED NOT NULL,
  `codigo_pedido` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Código único do pedido',
  `empresa_id` bigint UNSIGNED NOT NULL,
  `codigo_empresa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Código da empresa fornecido no wizard',
  `arquivo_criativo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Caminho do arquivo do criativo',
  `nome_criativo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_arquivo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tipo MIME do arquivo',
  `tipo_selecao` enum('individual','franquia_completa','multiplas_franquias') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Tipo de seleção de hotspots',
  `hotspots_selecionados` json DEFAULT NULL COMMENT 'IDs dos hotspots selecionados',
  `franquias_selecionadas` json DEFAULT NULL COMMENT 'IDs das franquias selecionadas',
  `data_inicio` date NOT NULL COMMENT 'Data de início da publicação',
  `data_fim` date NOT NULL COMMENT 'Data de término da publicação',
  `posicao` int NOT NULL DEFAULT '1' COMMENT 'Posição do anúncio (1-5)',
  `periodicidade` enum('semanal','mensal') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Periodicidade da publicidade',
  `valor_unitario` decimal(10,2) NOT NULL COMMENT 'Valor unitário do período',
  `quantidade_hotspots` int NOT NULL DEFAULT '1' COMMENT 'Quantidade de hotspots',
  `valor_total` decimal(10,2) NOT NULL COMMENT 'Valor total do pedido',
  `status_pagamento` enum('pendente','aprovado','rejeitado','cancelado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendente',
  `forma_pagamento` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Forma de pagamento escolhida',
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID da transação do gateway',
  `dados_pagamento` text COLLATE utf8mb4_unicode_ci COMMENT 'Dados adicionais do pagamento (JSON)',
  `pago_em` timestamp NULL DEFAULT NULL,
  `status` enum('rascunho','aguardando_pagamento','aprovado','publicado','cancelado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'rascunho',
  `observacoes` text COLLATE utf8mb4_unicode_ci,
  `criado_por` bigint UNSIGNED DEFAULT NULL,
  `aprovado_por` bigint UNSIGNED DEFAULT NULL,
  `aprovado_em` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `subsystem` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `publicacao_cliques`
--

CREATE TABLE `publicacao_cliques` (
  `id` bigint UNSIGNED NOT NULL,
  `hotspot_id` bigint UNSIGNED NOT NULL,
  `publicacao_id` bigint UNSIGNED NOT NULL,
  `criativo_id` bigint UNSIGNED NOT NULL,
  `ip_usuario` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `clicked_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `publicacao_impressoes`
--

CREATE TABLE `publicacao_impressoes` (
  `id` bigint UNSIGNED NOT NULL,
  `hotspot_id` bigint UNSIGNED NOT NULL,
  `publicacao_id` bigint UNSIGNED NOT NULL,
  `criativo_id` bigint UNSIGNED NOT NULL,
  `data` date NOT NULL,
  `impressoes` int NOT NULL DEFAULT '0',
  `usuarios_unicos` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `publicacoes`
--

CREATE TABLE `publicacoes` (
  `id` bigint UNSIGNED NOT NULL,
  `pedido_id` bigint UNSIGNED DEFAULT NULL,
  `criativo_id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED NOT NULL,
  `cliente_id` bigint UNSIGNED NOT NULL,
  `titulo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_inicio` datetime NOT NULL,
  `data_fim` datetime NOT NULL,
  `link_destino` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `habilitar_clique` tinyint(1) NOT NULL DEFAULT '0',
  `track_impressoes` tinyint(1) NOT NULL DEFAULT '1',
  `track_cliques` tinyint(1) NOT NULL DEFAULT '1',
  `valor_contrato` decimal(10,2) DEFAULT NULL,
  `impressoes_contratadas` int DEFAULT NULL,
  `total_visualizacoes` bigint UNSIGNED NOT NULL DEFAULT '0',
  `tipo_midia` enum('imagem','video') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `posicao` tinyint UNSIGNED DEFAULT NULL COMMENT 'Posição de 1 a 6 para exibição',
  `status` enum('ativa','pausada','expirada','cancelada','pendente_configuracao') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ativa',
  `tipo_alcance` enum('todos','serial_especifico','empresa') COLLATE utf8mb4_unicode_ci DEFAULT 'todos',
  `equipment_serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Serial do equipamento específico (opcional)',
  `empresa_alcance_id` bigint UNSIGNED DEFAULT NULL COMMENT 'ID do grupo de equipamentos (opcional)',
  `publicada_por` bigint UNSIGNED DEFAULT NULL,
  `publicada_em` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `publicacoes`
--

INSERT INTO `publicacoes` (`id`, `pedido_id`, `criativo_id`, `franquia_id`, `cliente_id`, `titulo`, `data_inicio`, `data_fim`, `link_destino`, `habilitar_clique`, `track_impressoes`, `track_cliques`, `valor_contrato`, `impressoes_contratadas`, `total_visualizacoes`, `tipo_midia`, `posicao`, `status`, `tipo_alcance`, `equipment_serial`, `empresa_alcance_id`, `publicada_por`, `publicada_em`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 1, 2, 3, 'Instruções de Acesso', '2025-11-01 00:00:00', '2025-11-30 23:59:00', '#', 1, 1, 1, NULL, NULL, 372, 'imagem', 1, 'ativa', 'todos', NULL, NULL, 1, '2025-11-04 06:58:01', 1, 1, NULL, '2025-11-04 06:58:01', '2025-11-04 06:58:01', NULL),
(2, NULL, 2, 2, 3, 'Anuncie Conosco', '2025-11-01 00:00:00', '2025-11-30 23:59:00', '#', 1, 1, 1, NULL, NULL, 298, 'imagem', 2, 'ativa', 'todos', NULL, NULL, 1, '2025-11-04 06:59:10', 1, 1, NULL, '2025-11-04 06:59:10', '2025-11-04 06:59:10', NULL);

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

--
-- Estrutura para tabela `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `tawkto_configs`
--

CREATE TABLE `tawkto_configs` (
  `id` bigint UNSIGNED NOT NULL,
  `empresa_id` bigint UNSIGNED NOT NULL,
  `property_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID do site no Tawk.to',
  `widget_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID do widget no Tawk.to',
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `paginas_habilitadas` json DEFAULT NULL COMMENT '["index","cadastro","login","welcome"]',
  `customizacao` json DEFAULT NULL COMMENT 'Cores, posição, etc',
  `metadata_personalizado` json DEFAULT NULL COMMENT 'Campos extras para enviar ao Tawk.to',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `tawkto_configs`
--

INSERT INTO `tawkto_configs` (`id`, `empresa_id`, `property_id`, `widget_id`, `ativo`, `paginas_habilitadas`, `customizacao`, `metadata_personalizado`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
(1, 2, '691540cab11a42195bb4bd5a', '1j9tga678', 1, '[\"index\", \"cadastro\", \"login\", \"welcome\"]', '{\"position\": \"br\", \"primaryColor\": \"#3b87c6\"}', '[]', '2025-11-13 03:41:58', '2025-11-13 03:41:58', NULL, 1, 1, NULL);

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

--
-- Estrutura para tabela `transacoes_financeiras`
--

CREATE TABLE `transacoes_financeiras` (
  `id` bigint UNSIGNED NOT NULL,
  `pedido_id` bigint UNSIGNED NOT NULL,
  `empresa_id` bigint UNSIGNED NOT NULL,
  `franquia_id` bigint UNSIGNED DEFAULT NULL,
  `codigo_transacao` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'TRX-XXXXXXXX',
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID do gateway (MP, PagSeguro, etc)',
  `tipo` enum('pagamento','estorno','cancelamento','reembolso') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pagamento',
  `canal` enum('mercado_pago','pagseguro','stripe','pix_manual','transferencia','outro') COLLATE utf8mb4_unicode_ci NOT NULL,
  `forma_pagamento` enum('pix','cartao_credito','cartao_debito','boleto','transferencia') COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor_bruto` decimal(10,2) NOT NULL COMMENT 'Valor total',
  `taxa_gateway` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Taxa cobrada pelo gateway',
  `valor_liquido` decimal(10,2) NOT NULL COMMENT 'Valor líquido (bruto - taxa)',
  `status` enum('pendente','processando','aprovado','recusado','estornado','cancelado') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendente',
  `data_transacao` timestamp NULL DEFAULT NULL COMMENT 'Data/hora da transação',
  `data_aprovacao` timestamp NULL DEFAULT NULL COMMENT 'Data/hora da aprovação',
  `data_estorno` timestamp NULL DEFAULT NULL COMMENT 'Data/hora do estorno',
  `data_liquidacao` timestamp NULL DEFAULT NULL COMMENT 'Data que cai na conta',
  `dados_gateway` text COLLATE utf8mb4_unicode_ci COMMENT 'JSON com dados completos do gateway',
  `comprovante` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Caminho do comprovante',
  `observacoes` text COLLATE utf8mb4_unicode_ci,
  `motivo_estorno` text COLLATE utf8mb4_unicode_ci,
  `conciliado` tinyint(1) NOT NULL DEFAULT '0',
  `conciliado_em` timestamp NULL DEFAULT NULL,
  `conciliado_por` bigint UNSIGNED DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura para tabela `walled_gardens`
--

CREATE TABLE `walled_gardens` (
  `id` bigint UNSIGNED NOT NULL,
  `publicacao_id` bigint UNSIGNED NOT NULL,
  `tipo` enum('domain','ip','subnet') COLLATE utf8mb4_unicode_ci NOT NULL,
  `endereco` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descricao` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tabelas despejadas
--

--
-- Índices de tabela `auditoria_splash`
--
ALTER TABLE `auditoria_splash`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auditoria_splash_hs_serial_index` (`hs_serial`),
  ADD KEY `auditoria_splash_created_at_index` (`created_at`),
  ADD KEY `auditoria_splash_processed_index` (`processed`);

--
-- Índices de tabela `configuracao_precos`
--
ALTER TABLE `configuracao_precos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `configuracao_precos_chave_unique` (`chave`);

--
-- Índices de tabela `criativos`
--
ALTER TABLE `criativos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `midias_empresa_id_foreign` (`empresa_legado_id`),
  ADD KEY `midias_created_by_foreign` (`created_by`),
  ADD KEY `midias_updated_by_foreign` (`updated_by`),
  ADD KEY `midias_deleted_by_foreign` (`deleted_by`),
  ADD KEY `criativos_aprovado_por_foreign` (`aprovado_por`),
  ADD KEY `criativos_franquia_id_index` (`franquia_id`),
  ADD KEY `criativos_formato_index` (`formato`),
  ADD KEY `criativos_status_aprovacao_index` (`status_aprovacao`);

--
-- Índices de tabela `empresa_user`
--
ALTER TABLE `empresa_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_empresa_unique` (`user_id`,`empresa_id`),
  ADD KEY `empresa_user_user_id_index` (`user_id`),
  ADD KEY `empresa_user_empresa_id_index` (`empresa_id`);

--
-- Índices de tabela `estatisticas_midia`
--
ALTER TABLE `estatisticas_midia`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `estatisticas_midia_publicacao_id_hotspot_id_data_unique` (`publicacao_id`,`hotspot_id`,`data`),
  ADD KEY `estatisticas_midia_publicacao_id_index` (`publicacao_id`),
  ADD KEY `estatisticas_midia_criativo_id_index` (`criativo_id`),
  ADD KEY `estatisticas_midia_cliente_id_index` (`cliente_id`),
  ADD KEY `estatisticas_midia_franquia_id_index` (`franquia_id`),
  ADD KEY `estatisticas_midia_hotspot_id_index` (`hotspot_id`),
  ADD KEY `estatisticas_midia_data_index` (`data`),
  ADD KEY `estatisticas_midia_cliente_id_data_index` (`cliente_id`,`data`),
  ADD KEY `estatisticas_midia_franquia_id_data_index` (`franquia_id`,`data`);

--
-- Índices de tabela `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Índices de tabela `franquia_formatos_permitidos`
--
ALTER TABLE `franquia_formatos_permitidos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `franquia_formatos_permitidos_franquia_id_formato_unique` (`franquia_id`,`formato`),
  ADD KEY `franquia_formatos_permitidos_franquia_id_index` (`franquia_id`),
  ADD KEY `franquia_formatos_permitidos_ativo_index` (`ativo`);

--
-- Índices de tabela `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groups_created_by_foreign` (`created_by`),
  ADD KEY `groups_updated_by_foreign` (`updated_by`),
  ADD KEY `groups_deleted_by_foreign` (`deleted_by`);

--
-- Índices de tabela `group_permission`
--
ALTER TABLE `group_permission`
  ADD PRIMARY KEY (`group_id`,`permission_id`);

--
-- Índices de tabela `group_user`
--
ALTER TABLE `group_user`
  ADD PRIMARY KEY (`group_id`,`user_id`);

--
-- Índices de tabela `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Índices de tabela `logs_acesso_wifi`
--
ALTER TABLE `logs_acesso_wifi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logs_acesso_wifi_publicacao_visualizada_id_foreign` (`publicacao_visualizada_id`),
  ADD KEY `logs_acesso_wifi_hotspot_id_index` (`hotspot_id`),
  ADD KEY `logs_acesso_wifi_franquia_id_index` (`franquia_id`),
  ADD KEY `logs_acesso_wifi_cliente_id_index` (`cliente_id`),
  ADD KEY `logs_acesso_wifi_created_at_index` (`created_at`),
  ADD KEY `logs_acesso_wifi_hotspot_id_created_at_index` (`hotspot_id`,`created_at`),
  ADD KEY `logs_acesso_wifi_cliente_id_created_at_index` (`cliente_id`,`created_at`),
  ADD KEY `logs_acesso_wifi_mac_address_hash_index` (`mac_address_hash`);

--
-- Índices de tabela `midias_pedido`
--
ALTER TABLE `midias_pedido`
  ADD PRIMARY KEY (`id`),
  ADD KEY `midias_pedido_criativo_id_foreign` (`criativo_id`),
  ADD KEY `midias_pedido_aprovado_por_foreign` (`aprovado_por`),
  ADD KEY `midias_pedido_created_by_foreign` (`created_by`),
  ADD KEY `midias_pedido_updated_by_foreign` (`updated_by`),
  ADD KEY `midias_pedido_deleted_by_foreign` (`deleted_by`),
  ADD KEY `midias_pedido_pedido_id_index` (`pedido_id`),
  ADD KEY `midias_pedido_status_index` (`status`);

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

--
-- Índices de tabela `pedidos_publicidade`
--
ALTER TABLE `pedidos_publicidade`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pedidos_publicidade_codigo_pedido_unique` (`codigo_pedido`),
  ADD KEY `pedidos_publicidade_empresa_id_foreign` (`empresa_id`),
  ADD KEY `pedidos_publicidade_criado_por_foreign` (`criado_por`),
  ADD KEY `pedidos_publicidade_aprovado_por_foreign` (`aprovado_por`);

--
-- Índices de tabela `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_slug_unique` (`slug`),
  ADD KEY `permissions_created_by_foreign` (`created_by`),
  ADD KEY `permissions_updated_by_foreign` (`updated_by`),
  ADD KEY `permissions_deleted_by_foreign` (`deleted_by`);

--
-- Índices de tabela `publicacao_cliques`
--
ALTER TABLE `publicacao_cliques`
  ADD PRIMARY KEY (`id`),
  ADD KEY `publicacao_cliques_criativo_id_foreign` (`criativo_id`),
  ADD KEY `publicacao_cliques_hotspot_id_publicacao_id_clicked_at_index` (`hotspot_id`,`publicacao_id`,`clicked_at`),
  ADD KEY `publicacao_cliques_publicacao_id_clicked_at_index` (`publicacao_id`,`clicked_at`),
  ADD KEY `publicacao_cliques_clicked_at_index` (`clicked_at`);

--
-- Índices de tabela `publicacao_impressoes`
--
ALTER TABLE `publicacao_impressoes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `impressoes_unique` (`hotspot_id`,`publicacao_id`,`criativo_id`,`data`),
  ADD KEY `publicacao_impressoes_criativo_id_foreign` (`criativo_id`),
  ADD KEY `publicacao_impressoes_publicacao_id_data_index` (`publicacao_id`,`data`),
  ADD KEY `publicacao_impressoes_hotspot_id_data_index` (`hotspot_id`,`data`);

--
-- Índices de tabela `publicacoes`
--
ALTER TABLE `publicacoes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `publicacoes_publicada_por_foreign` (`publicada_por`),
  ADD KEY `publicacoes_created_by_foreign` (`created_by`),
  ADD KEY `publicacoes_updated_by_foreign` (`updated_by`),
  ADD KEY `publicacoes_deleted_by_foreign` (`deleted_by`),
  ADD KEY `publicacoes_criativo_id_index` (`criativo_id`),
  ADD KEY `publicacoes_franquia_id_index` (`franquia_id`),
  ADD KEY `publicacoes_cliente_id_index` (`cliente_id`),
  ADD KEY `publicacoes_status_index` (`status`),
  ADD KEY `publicacoes_data_inicio_data_fim_index` (`data_inicio`,`data_fim`),
  ADD KEY `publicacoes_tipo_alcance_index` (`tipo_alcance`),
  ADD KEY `publicacoes_equipment_serial_index` (`equipment_serial`),
  ADD KEY `publicacoes_grupo_equipamentos_id_index` (`empresa_alcance_id`),
  ADD KEY `publicacoes_total_visualizacoes_index` (`total_visualizacoes`),
  ADD KEY `publicacoes_posicao_index` (`posicao`),
  ADD KEY `publicacoes_pedido_id_index` (`pedido_id`);

--
-- Índices de tabela `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`),
  ADD KEY `roles_created_by_foreign` (`created_by`),
  ADD KEY `roles_updated_by_foreign` (`updated_by`),
  ADD KEY `roles_deleted_by_foreign` (`deleted_by`);

--
-- Índices de tabela `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Índices de tabela `tawkto_configs`
--
ALTER TABLE `tawkto_configs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tawkto_configs_empresa_id_index` (`empresa_id`),
  ADD KEY `tawkto_configs_ativo_index` (`ativo`);

--
-- Índices de tabela `transacoes_financeiras`
--
ALTER TABLE `transacoes_financeiras`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transacoes_financeiras_codigo_transacao_unique` (`codigo_transacao`),
  ADD KEY `transacoes_financeiras_conciliado_por_foreign` (`conciliado_por`),
  ADD KEY `transacoes_financeiras_created_by_foreign` (`created_by`),
  ADD KEY `transacoes_financeiras_updated_by_foreign` (`updated_by`),
  ADD KEY `transacoes_financeiras_deleted_by_foreign` (`deleted_by`),
  ADD KEY `transacoes_financeiras_pedido_id_index` (`pedido_id`),
  ADD KEY `transacoes_financeiras_empresa_id_index` (`empresa_id`),
  ADD KEY `transacoes_financeiras_franquia_id_index` (`franquia_id`),
  ADD KEY `transacoes_financeiras_canal_index` (`canal`),
  ADD KEY `transacoes_financeiras_status_index` (`status`),
  ADD KEY `transacoes_financeiras_data_transacao_index` (`data_transacao`),
  ADD KEY `transacoes_financeiras_conciliado_index` (`conciliado`),
  ADD KEY `transacoes_financeiras_transaction_id_index` (`transaction_id`);

--
-- Índices de tabela `walled_gardens`
--
ALTER TABLE `walled_gardens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `walled_gardens_publicacao_id_ativo_index` (`publicacao_id`,`ativo`),
  ADD KEY `walled_gardens_tipo_index` (`tipo`);

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `auditoria_splash`
--
ALTER TABLE `auditoria_splash`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=678;

--
-- AUTO_INCREMENT de tabela `configuracao_precos`
--
ALTER TABLE `configuracao_precos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `criativos`
--
ALTER TABLE `criativos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `empresa_user`
--
ALTER TABLE `empresa_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `estatisticas_midia`
--
ALTER TABLE `estatisticas_midia`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `franquia_formatos_permitidos`
--
ALTER TABLE `franquia_formatos_permitidos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `groups`
--
ALTER TABLE `groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `logs_acesso_wifi`
--
ALTER TABLE `logs_acesso_wifi`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `midias_pedido`
--
ALTER TABLE `midias_pedido`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT de tabela `pedidos_publicidade`
--
ALTER TABLE `pedidos_publicidade`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `publicacao_cliques`
--
ALTER TABLE `publicacao_cliques`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `publicacao_impressoes`
--
ALTER TABLE `publicacao_impressoes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `publicacoes`
--
ALTER TABLE `publicacoes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `tawkto_configs`
--
ALTER TABLE `tawkto_configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `transacoes_financeiras`
--
ALTER TABLE `transacoes_financeiras`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `walled_gardens`
--
ALTER TABLE `walled_gardens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Restrições para tabelas despejadas
--

--
-- Restrições para tabelas `criativos`
--
ALTER TABLE `criativos`
  ADD CONSTRAINT `criativos_aprovado_por_foreign` FOREIGN KEY (`aprovado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `criativos_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE RESTRICT,
  ADD CONSTRAINT `midias_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_empresa_id_foreign` FOREIGN KEY (`empresa_legado_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `midias_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `empresa_user`
--
ALTER TABLE `empresa_user`
  ADD CONSTRAINT `empresa_user_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `empresa_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `estatisticas_midia`
--
ALTER TABLE `estatisticas_midia`
  ADD CONSTRAINT `estatisticas_midia_cliente_id_foreign` FOREIGN KEY (`cliente_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `estatisticas_midia_criativo_id_foreign` FOREIGN KEY (`criativo_id`) REFERENCES `criativos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `estatisticas_midia_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `estatisticas_midia_hotspot_id_foreign` FOREIGN KEY (`hotspot_id`) REFERENCES `hotspots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `estatisticas_midia_publicacao_id_foreign` FOREIGN KEY (`publicacao_id`) REFERENCES `publicacoes` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `franquia_formatos_permitidos`
--
ALTER TABLE `franquia_formatos_permitidos`
  ADD CONSTRAINT `franquia_formatos_permitidos_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `groups`
--
ALTER TABLE `groups`
  ADD CONSTRAINT `groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `groups_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `groups_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `logs_acesso_wifi`
--
ALTER TABLE `logs_acesso_wifi`
  ADD CONSTRAINT `logs_acesso_wifi_cliente_id_foreign` FOREIGN KEY (`cliente_id`) REFERENCES `empresas` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `logs_acesso_wifi_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `logs_acesso_wifi_hotspot_id_foreign` FOREIGN KEY (`hotspot_id`) REFERENCES `hotspots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `logs_acesso_wifi_publicacao_visualizada_id_foreign` FOREIGN KEY (`publicacao_visualizada_id`) REFERENCES `publicacoes` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `midias_pedido`
--
ALTER TABLE `midias_pedido`
  ADD CONSTRAINT `midias_pedido_aprovado_por_foreign` FOREIGN KEY (`aprovado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_pedido_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_pedido_criativo_id_foreign` FOREIGN KEY (`criativo_id`) REFERENCES `criativos` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_pedido_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `midias_pedido_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos_publicidade` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `midias_pedido_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `pedidos_publicidade`
--
ALTER TABLE `pedidos_publicidade`
  ADD CONSTRAINT `pedidos_publicidade_aprovado_por_foreign` FOREIGN KEY (`aprovado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pedidos_publicidade_criado_por_foreign` FOREIGN KEY (`criado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pedidos_publicidade_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `permissions`
--
ALTER TABLE `permissions`
  ADD CONSTRAINT `permissions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `permissions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `permissions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `publicacao_cliques`
--
ALTER TABLE `publicacao_cliques`
  ADD CONSTRAINT `publicacao_cliques_criativo_id_foreign` FOREIGN KEY (`criativo_id`) REFERENCES `criativos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publicacao_cliques_hotspot_id_foreign` FOREIGN KEY (`hotspot_id`) REFERENCES `hotspots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publicacao_cliques_publicacao_id_foreign` FOREIGN KEY (`publicacao_id`) REFERENCES `publicacoes` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `publicacao_impressoes`
--
ALTER TABLE `publicacao_impressoes`
  ADD CONSTRAINT `publicacao_impressoes_criativo_id_foreign` FOREIGN KEY (`criativo_id`) REFERENCES `criativos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publicacao_impressoes_hotspot_id_foreign` FOREIGN KEY (`hotspot_id`) REFERENCES `hotspots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publicacao_impressoes_publicacao_id_foreign` FOREIGN KEY (`publicacao_id`) REFERENCES `publicacoes` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `publicacoes`
--
ALTER TABLE `publicacoes`
  ADD CONSTRAINT `publicacoes_cliente_id_foreign` FOREIGN KEY (`cliente_id`) REFERENCES `empresas` (`id`) ON DELETE RESTRICT,
  ADD CONSTRAINT `publicacoes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `publicacoes_criativo_id_foreign` FOREIGN KEY (`criativo_id`) REFERENCES `criativos` (`id`) ON DELETE RESTRICT,
  ADD CONSTRAINT `publicacoes_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `publicacoes_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE RESTRICT,
  ADD CONSTRAINT `publicacoes_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos_publicidade` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `publicacoes_publicada_por_foreign` FOREIGN KEY (`publicada_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `publicacoes_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `roles_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `roles_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `tawkto_configs`
--
ALTER TABLE `tawkto_configs`
  ADD CONSTRAINT `tawkto_configs_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE;

--
-- Restrições para tabelas `transacoes_financeiras`
--
ALTER TABLE `transacoes_financeiras`
  ADD CONSTRAINT `transacoes_financeiras_conciliado_por_foreign` FOREIGN KEY (`conciliado_por`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transacoes_financeiras_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transacoes_financeiras_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transacoes_financeiras_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transacoes_financeiras_franquia_id_foreign` FOREIGN KEY (`franquia_id`) REFERENCES `empresas` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transacoes_financeiras_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos_publicidade` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transacoes_financeiras_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Restrições para tabelas `walled_gardens`
--
ALTER TABLE `walled_gardens`
  ADD CONSTRAINT `walled_gardens_publicacao_id_foreign` FOREIGN KEY (`publicacao_id`) REFERENCES `publicacoes` (`id`) ON DELETE CASCADE;
COMMIT;

