-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 08/01/2026 às 10:56
-- Versão do servidor: 10.6.18-MariaDB-cll-lve-log
-- Versão do PHP: 8.1.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Banco de dados: `credinowe_wifi`
--

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

--
-- Estrutura para tabela `portal_registros`
--

CREATE TABLE `portal_registros` (
  `id` int(11) NOT NULL,
  `nome` varchar(150) NOT NULL,
  `telefone` varchar(40) DEFAULT NULL,
  `cpf` varchar(20) DEFAULT NULL,
  `client_mac` varchar(50) DEFAULT NULL,
  `client_ip` varchar(45) DEFAULT NULL,
  `voucher` varchar(50) DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Despejando dados para a tabela `portal_registros`
--

INSERT INTO `portal_registros` (`id`, `nome`, `telefone`, `cpf`, `client_mac`, `client_ip`, `voucher`, `expires_at`, `created_at`) VALUES
(1, 'Lucas Alves', '85981693842', '07850595394', '', '', 'CRED-GBDEH3KZ', '2025-10-14 21:28:16', '2025-10-14 17:28:16'),
(2, 'CRED-GBDEH3KZ', '', '', '', '', 'CRED-SMVTER9H', '2025-10-14 21:29:08', '2025-10-14 17:29:08'),
(3, 'Lucas Alves', '85981696842', '07850595394', '', '', 'CRED-7J9QME35', '2025-10-14 21:30:59', '2025-10-14 17:30:59'),
(4, 'Lucas Alves', '85981693842', '07850595394', '', '', 'CRED-8JFQWHDT', '2025-10-14 21:39:28', '2025-10-14 17:39:28'),
(5, 'Lucas Alves', '85981693842', '07850595394', '', '', 'CRED-E5WBSAL7', '2025-10-14 21:41:58', '2025-10-14 17:41:58'),
(6, 'Alice Fernanda sousa', '85963254869', '01113839007', '', '', 'CRED-ZP6HRDK9', '2025-10-14 21:47:46', '2025-10-14 17:47:46'),
(7, 'Lucas Alves', '85981693812', '07850595394', '', '', 'CRED-D9FEBR72', '2025-10-14 18:49:58', '2025-10-14 17:49:58'),
(8, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-8BBFF05F', '2025-10-14 19:18:06', '2025-10-14 18:18:06'),
(9, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-1A584BF7', '2025-10-14 19:18:17', '2025-10-14 18:18:17'),
(10, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-A891F1BD', '2025-10-14 19:24:58', '2025-10-14 18:24:58'),
(11, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-28DBE2AF', '2025-10-14 19:25:01', '2025-10-14 18:25:01'),
(12, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-B56573AD', '2025-10-14 19:25:09', '2025-10-14 18:25:09'),
(13, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-99CC19FB', '2025-10-14 19:25:25', '2025-10-14 18:25:25'),
(14, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-3EE96F7F', '2025-10-14 19:25:30', '2025-10-14 18:25:30'),
(15, 'Lucas Alves', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-830C5B52', '2025-10-14 19:25:45', '2025-10-14 18:25:45'),
(16, 'Lucas Alves Vieira da Silva', '85981693842', '07850595394', '52-D6-23-2C-53-8A', '10.0.0.122', 'CRED-15CAF21B', '2025-10-15 10:01:55', '2025-10-15 09:01:55'),
(17, 'Vanila de Albuquerque Alves dos Santos', '85996804741', '07271006370', '%CLIENT_MAC%', '%client_ip%', 'CRED-A77C1D50', '2025-10-15 10:06:06', '2025-10-15 09:06:06'),
(18, 'Vanila de Albuquerque Alves dos Santos', '85996804741', '07271006370', '%CLIENT_MAC%', '%client_ip%', 'CRED-47E7663F', '2025-10-15 10:06:11', '2025-10-15 09:06:11'),
(19, 'Vanila de Albuquerque Alves dos Santos', '85996804741', '07271006370', '%CLIENT_MAC%', '%client_ip%', 'CRED-308157F0', '2025-10-15 10:08:15', '2025-10-15 09:08:15');

--
-- Índices para tabelas despejadas
--

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

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `portal_registros`
--
ALTER TABLE `portal_registros`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
