-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 10-Maio-2026 às 17:44
-- Versão do servidor: 11.4.10-MariaDB
-- versão do PHP: 8.4.20

START TRANSACTION;



--
-- Base de dados: `nanodelivery_2026`
--

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

--
-- Estrutura da tabela `adicionais`
--

CREATE TABLE `adicionais` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `grupo_id` bigint(20) UNSIGNED NOT NULL,
  `nome` varchar(100) NOT NULL,
  `descricao` text DEFAULT NULL,
  `preco` decimal(10,2) NOT NULL DEFAULT 0.00,
  `estoque` int(11) DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `ordem` int(11) 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;

--
-- Extraindo dados da tabela `adicionais`
--

INSERT INTO `adicionais` (`id`, `grupo_id`, `nome`, `descricao`, `preco`, `estoque`, `ativo`, `ordem`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mal passado', NULL, 0.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(2, 1, 'Ao ponto', NULL, 0.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(3, 1, 'Bem passado', NULL, 0.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(4, 2, 'Queijo extra', NULL, 2.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(5, 2, 'Bacon extra', NULL, 3.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(6, 2, 'Ovo frito', NULL, 2.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(7, 2, 'Milho', NULL, 1.00, NULL, 1, 4, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(8, 2, 'Batata palha', NULL, 1.50, NULL, 1, 5, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(9, 2, 'Cebola crispy', NULL, 2.00, NULL, 1, 6, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(10, 3, 'Mal passado', NULL, 0.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(11, 3, 'Ao ponto', NULL, 0.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(12, 3, 'Bem passado', NULL, 0.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(13, 4, 'Queijo extra', NULL, 2.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(14, 4, 'Bacon extra', NULL, 3.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(15, 4, 'Ovo frito', NULL, 2.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(16, 4, 'Milho', NULL, 1.00, NULL, 1, 4, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(17, 4, 'Batata palha', NULL, 1.50, NULL, 1, 5, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(18, 4, 'Cebola crispy', NULL, 2.00, NULL, 1, 6, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(19, 5, 'Queijo extra', NULL, 2.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(20, 5, 'Bacon extra', NULL, 3.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(21, 5, 'Ovo frito', NULL, 2.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(22, 5, 'Milho', NULL, 1.00, NULL, 1, 4, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(23, 5, 'Batata palha', NULL, 1.50, NULL, 1, 5, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(24, 5, 'Cebola crispy', NULL, 2.00, NULL, 1, 6, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(25, 6, 'Mal passado', NULL, 0.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(26, 6, 'Ao ponto', NULL, 0.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(27, 6, 'Bem passado', NULL, 0.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(28, 7, 'Queijo extra', NULL, 2.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(29, 7, 'Bacon extra', NULL, 3.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(30, 7, 'Ovo frito', NULL, 2.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(31, 7, 'Milho', NULL, 1.00, NULL, 1, 4, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(32, 7, 'Batata palha', NULL, 1.50, NULL, 1, 5, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(33, 7, 'Cebola crispy', NULL, 2.00, NULL, 1, 6, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(34, 8, 'Queijo extra', NULL, 2.00, NULL, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(35, 8, 'Bacon extra', NULL, 3.00, NULL, 1, 2, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(36, 8, 'Ovo frito', NULL, 2.00, NULL, 1, 3, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(37, 8, 'Milho', NULL, 1.00, NULL, 1, 4, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(38, 8, 'Batata palha', NULL, 1.50, NULL, 1, 5, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(39, 8, 'Cebola crispy', NULL, 2.00, NULL, 1, 6, '2026-03-18 05:20:19', '2026-03-18 05:20:19');

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

--
-- Estrutura da tabela `assinaturas`
--

CREATE TABLE `assinaturas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `plano_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('trial','ativa','cancelada','suspensa','expirada') NOT NULL DEFAULT 'trial',
  `data_inicio` date NOT NULL,
  `data_fim` date DEFAULT NULL,
  `trial_expira_em` date DEFAULT NULL,
  `periodo` enum('mensal','anual') NOT NULL DEFAULT 'mensal',
  `valor_pago` decimal(10,2) DEFAULT NULL,
  `metodo_pagamento` varchar(50) DEFAULT NULL,
  `gateway_id` varchar(100) DEFAULT NULL,
  `notas` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `avaliacoes`
--

CREATE TABLE `avaliacoes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pedido_id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `nota_loja` int(11) DEFAULT NULL,
  `nota_entrega` int(11) DEFAULT NULL,
  `nota_comida` int(11) DEFAULT NULL,
  `comentario` text DEFAULT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)),
  `fotos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`fotos`)),
  `aprovado` tinyint(1) NOT NULL DEFAULT 1,
  `anonimo` tinyint(1) 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 da tabela `bairros_entrega`
--

CREATE TABLE `bairros_entrega` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `nome` varchar(100) NOT NULL,
  `cidade` varchar(100) NOT NULL,
  `estado` varchar(2) NOT NULL DEFAULT 'SP',
  `taxa` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tempo_estimado_min` int(11) NOT NULL DEFAULT 30,
  `tempo_estimado_max` int(11) NOT NULL DEFAULT 60,
  `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;

--
-- Extraindo dados da tabela `bairros_entrega`
--

INSERT INTO `bairros_entrega` (`id`, `loja_id`, `nome`, `cidade`, `estado`, `taxa`, `tempo_estimado_min`, `tempo_estimado_max`, `ativo`, `created_at`, `updated_at`) VALUES
(1, 1, 'Bela Vista', 'São Paulo', 'SP', 4.00, 20, 35, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(2, 1, 'Consolação', 'São Paulo', 'SP', 4.00, 20, 35, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(3, 1, 'Jardins', 'São Paulo', 'SP', 5.00, 25, 40, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(4, 1, 'Pinheiros', 'São Paulo', 'SP', 6.00, 30, 45, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(5, 1, 'Itaim Bibi', 'São Paulo', 'SP', 6.00, 30, 45, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(6, 1, 'Vila Mariana', 'São Paulo', 'SP', 5.50, 25, 40, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(7, 1, 'Centro', 'São Paulo', 'SP', 3.50, 15, 30, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18'),
(8, 1, 'Paraíso', 'São Paulo', 'SP', 4.50, 20, 35, 1, '2026-03-18 05:20:18', '2026-03-18 05:20:18');

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

--
-- Estrutura da tabela `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `titulo` varchar(150) DEFAULT NULL,
  `imagem` varchar(255) NOT NULL,
  `url` varchar(500) DEFAULT NULL,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `valido_de` timestamp NULL DEFAULT NULL,
  `valido_ate` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `categorias`
--

CREATE TABLE `categorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `categoria_pai_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nome` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `descricao` text DEFAULT NULL,
  `imagem` varchar(255) DEFAULT NULL,
  `icone` varchar(50) DEFAULT NULL,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `destaque` tinyint(1) NOT NULL DEFAULT 0,
  `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;

--
-- Extraindo dados da tabela `categorias`
--

INSERT INTO `categorias` (`id`, `loja_id`, `categoria_pai_id`, `nome`, `slug`, `descricao`, `imagem`, `icone`, `ordem`, `ativo`, `destaque`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, NULL, 'Lanches', 'lanches', NULL, NULL, 'burger', 1, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(2, 1, NULL, 'Pizzas', 'pizzas', NULL, NULL, 'circle', 2, 1, 0, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(3, 1, NULL, 'Porções', 'porcoes', NULL, NULL, 'box-seam', 3, 1, 0, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(4, 1, NULL, 'Bebidas', 'bebidas', NULL, NULL, 'cup-straw', 4, 1, 0, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(5, 1, NULL, 'Sobremesas', 'sobremesas', NULL, NULL, 'cake2', 5, 1, 0, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(6, 1, NULL, 'Combos', 'combos', NULL, NULL, 'bag-check', 6, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(7, 1, NULL, 'Promoções', 'promocoes', NULL, NULL, 'tag', 7, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL);

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

--
-- Estrutura da tabela `contadores_visitas`
--

CREATE TABLE `contadores_visitas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `entidade_id` bigint(20) UNSIGNED NOT NULL,
  `data` date NOT NULL,
  `total_visitas` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `visitas_unicas` int(10) UNSIGNED 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;

--
-- Extraindo dados da tabela `contadores_visitas`
--

INSERT INTO `contadores_visitas` (`id`, `tipo`, `entidade_id`, `data`, `total_visitas`, `visitas_unicas`, `created_at`, `updated_at`) VALUES
(1, 'produto', 1, '2026-03-18', 2, 2, '2026-03-18 06:31:32', '2026-03-18 22:14:12'),
(2, 'loja', 1, '2026-03-18', 7, 2, '2026-03-18 06:32:05', '2026-03-18 22:14:09'),
(3, 'produto', 16, '2026-03-18', 2, 1, '2026-03-18 06:39:09', '2026-03-18 22:12:32'),
(4, 'produto', 4, '2026-03-18', 4, 1, '2026-03-18 14:52:55', '2026-03-18 22:08:51'),
(5, 'produto', 5, '2026-03-18', 2, 2, '2026-03-18 16:51:08', '2026-03-18 22:14:25'),
(6, 'produto', 3, '2026-03-18', 2, 2, '2026-03-18 16:59:39', '2026-03-18 17:08:44'),
(7, 'produto', 2, '2026-03-18', 1, 1, '2026-03-18 17:35:55', '2026-03-18 17:35:55'),
(8, 'produto', 6, '2026-03-18', 1, 1, '2026-03-18 17:58:27', '2026-03-18 17:58:27'),
(9, 'loja', 1, '2026-03-19', 3, 2, '2026-03-19 10:02:05', '2026-03-19 14:32:59'),
(10, 'produto', 6, '2026-03-19', 1, 1, '2026-03-19 10:03:11', '2026-03-19 10:03:11'),
(11, 'produto', 13, '2026-03-19', 1, 1, '2026-03-19 10:03:17', '2026-03-19 10:03:17'),
(12, 'produto', 16, '2026-03-19', 1, 1, '2026-03-19 10:04:03', '2026-03-19 10:04:03'),
(13, 'produto', 2, '2026-03-19', 1, 1, '2026-03-19 10:04:40', '2026-03-19 10:04:40'),
(14, 'produto', 11, '2026-03-19', 1, 1, '2026-03-19 10:05:52', '2026-03-19 10:05:52'),
(15, 'produto', 3, '2026-03-19', 1, 1, '2026-03-19 10:06:14', '2026-03-19 10:06:14'),
(16, 'produto', 12, '2026-03-19', 1, 1, '2026-03-19 10:07:48', '2026-03-19 10:07:48'),
(17, 'produto', 7, '2026-03-19', 1, 1, '2026-03-19 10:08:07', '2026-03-19 10:08:07'),
(18, 'produto', 9, '2026-03-19', 1, 1, '2026-03-19 10:09:14', '2026-03-19 10:09:14'),
(19, 'produto', 4, '2026-03-19', 2, 2, '2026-03-19 10:12:50', '2026-03-19 14:15:31'),
(20, 'produto', 1, '2026-03-19', 1, 1, '2026-03-19 10:14:12', '2026-03-19 10:14:12'),
(21, 'produto', 8, '2026-03-19', 1, 1, '2026-03-19 10:24:40', '2026-03-19 10:24:40'),
(22, 'produto', 10, '2026-03-19', 1, 1, '2026-03-19 14:14:40', '2026-03-19 14:14:40'),
(23, 'loja', 1, '2026-03-20', 5, 0, '2026-03-20 12:36:37', '2026-03-21 00:09:15'),
(24, 'produto', 9, '2026-03-20', 3, 3, '2026-03-20 12:36:53', '2026-03-20 18:12:23'),
(25, 'produto', 8, '2026-03-20', 3, 3, '2026-03-20 12:36:54', '2026-03-20 18:12:30'),
(26, 'produto', 1, '2026-03-20', 3, 3, '2026-03-20 12:36:54', '2026-03-20 18:12:21'),
(27, 'produto', 13, '2026-03-20', 3, 3, '2026-03-20 12:36:55', '2026-03-20 18:12:24'),
(28, 'produto', 7, '2026-03-20', 3, 3, '2026-03-20 12:36:55', '2026-03-20 18:12:26'),
(29, 'produto', 16, '2026-03-20', 3, 3, '2026-03-20 12:36:56', '2026-03-20 18:12:22'),
(30, 'produto', 6, '2026-03-20', 3, 3, '2026-03-20 12:36:56', '2026-03-20 18:12:31'),
(31, 'produto', 11, '2026-03-20', 3, 3, '2026-03-20 12:36:57', '2026-03-20 18:12:24'),
(32, 'produto', 12, '2026-03-20', 3, 3, '2026-03-20 12:36:58', '2026-03-20 18:12:25'),
(33, 'produto', 4, '2026-03-20', 3, 3, '2026-03-20 12:36:58', '2026-03-20 18:12:26'),
(34, 'produto', 10, '2026-03-20', 3, 3, '2026-03-20 12:36:59', '2026-03-20 18:12:33'),
(35, 'produto', 15, '2026-03-20', 3, 3, '2026-03-20 12:36:59', '2026-03-20 18:12:32'),
(36, 'produto', 14, '2026-03-20', 3, 3, '2026-03-20 12:37:00', '2026-03-20 18:12:32'),
(37, 'produto', 2, '2026-03-20', 3, 3, '2026-03-20 12:37:00', '2026-03-20 18:12:29'),
(38, 'produto', 5, '2026-03-20', 3, 3, '2026-03-20 12:37:01', '2026-03-20 18:12:33'),
(39, 'produto', 3, '2026-03-20', 3, 3, '2026-03-20 12:37:02', '2026-03-20 18:12:29'),
(40, 'loja', 1, '2026-03-22', 1, 0, '2026-03-22 15:22:56', '2026-03-22 15:22:56'),
(41, 'loja', 1, '2026-03-24', 4, 0, '2026-03-24 16:48:29', '2026-03-24 23:50:19'),
(42, 'produto', 6, '2026-03-24', 1, 1, '2026-03-25 01:17:54', '2026-03-25 01:17:54'),
(43, 'produto', 11, '2026-03-25', 1, 1, '2026-03-25 05:33:38', '2026-03-25 05:33:38'),
(44, 'produto', 8, '2026-03-25', 1, 1, '2026-03-25 08:08:22', '2026-03-25 08:08:22'),
(45, 'produto', 16, '2026-03-25', 1, 1, '2026-03-25 10:40:00', '2026-03-25 10:40:00'),
(46, 'produto', 3, '2026-03-26', 1, 1, '2026-03-26 07:47:56', '2026-03-26 07:47:56'),
(47, 'produto', 4, '2026-03-26', 1, 1, '2026-03-26 10:59:24', '2026-03-26 10:59:24'),
(48, 'loja', 1, '2026-03-26', 2, 0, '2026-03-26 20:11:36', '2026-03-26 22:06:08'),
(49, 'produto', 2, '2026-03-27', 1, 1, '2026-03-27 08:32:37', '2026-03-27 08:32:37'),
(50, 'loja', 1, '2026-03-27', 1, 0, '2026-03-27 20:53:27', '2026-03-27 20:53:27'),
(51, 'produto', 1, '2026-03-27', 1, 1, '2026-03-27 20:53:46', '2026-03-27 20:53:46'),
(52, 'produto', 7, '2026-03-27', 1, 1, '2026-03-28 01:49:16', '2026-03-28 01:49:16'),
(53, 'produto', 8, '2026-03-28', 1, 1, '2026-03-28 22:29:26', '2026-03-28 22:29:26'),
(54, 'produto', 13, '2026-03-29', 1, 1, '2026-03-29 07:39:24', '2026-03-29 07:39:24'),
(55, 'produto', 4, '2026-03-29', 1, 1, '2026-03-29 07:39:27', '2026-03-29 07:39:27'),
(56, 'produto', 1, '2026-03-29', 1, 1, '2026-03-29 18:12:44', '2026-03-29 18:12:44'),
(57, 'produto', 2, '2026-03-29', 1, 1, '2026-03-29 20:39:07', '2026-03-29 20:39:07'),
(58, 'produto', 16, '2026-03-29', 1, 1, '2026-03-29 22:13:05', '2026-03-29 22:13:05'),
(59, 'produto', 6, '2026-03-29', 1, 1, '2026-03-30 00:04:36', '2026-03-30 00:04:36'),
(60, 'produto', 14, '2026-03-30', 1, 1, '2026-03-30 04:03:57', '2026-03-30 04:03:57'),
(61, 'loja', 1, '2026-03-31', 2, 0, '2026-03-31 10:01:22', '2026-03-31 14:04:10'),
(62, 'produto', 9, '2026-03-31', 1, 1, '2026-03-31 18:28:09', '2026-03-31 18:28:09'),
(63, 'produto', 12, '2026-03-31', 2, 2, '2026-03-31 20:17:42', '2026-03-31 21:48:27'),
(64, 'produto', 11, '2026-03-31', 1, 1, '2026-03-31 22:43:46', '2026-03-31 22:43:46'),
(65, 'produto', 13, '2026-03-31', 1, 1, '2026-03-31 22:45:35', '2026-03-31 22:45:35'),
(66, 'produto', 1, '2026-03-31', 1, 1, '2026-04-01 00:17:08', '2026-04-01 00:17:08'),
(67, 'loja', 1, '2026-04-03', 1, 0, '2026-04-03 05:20:05', '2026-04-03 05:20:05'),
(68, 'produto', 1, '2026-04-03', 1, 1, '2026-04-03 05:20:15', '2026-04-03 05:20:15'),
(69, 'produto', 9, '2026-04-03', 1, 1, '2026-04-03 20:13:21', '2026-04-03 20:13:21'),
(70, 'produto', 7, '2026-04-03', 1, 1, '2026-04-03 23:32:16', '2026-04-03 23:32:16'),
(71, 'produto', 15, '2026-04-03', 1, 1, '2026-04-03 23:33:57', '2026-04-03 23:33:57'),
(72, 'produto', 10, '2026-04-03', 1, 1, '2026-04-04 01:59:40', '2026-04-04 01:59:40'),
(73, 'produto', 15, '2026-04-04', 1, 1, '2026-04-04 08:12:29', '2026-04-04 08:12:29'),
(74, 'loja', 1, '2026-04-05', 1, 0, '2026-04-05 20:34:24', '2026-04-05 20:34:24'),
(75, 'produto', 10, '2026-04-06', 1, 1, '2026-04-06 19:52:06', '2026-04-06 19:52:06'),
(76, 'loja', 1, '2026-04-06', 2, 0, '2026-04-07 02:43:48', '2026-04-07 02:54:20'),
(77, 'produto', 3, '2026-04-07', 1, 1, '2026-04-07 03:07:33', '2026-04-07 03:07:33'),
(78, 'produto', 6, '2026-04-07', 1, 1, '2026-04-07 03:08:55', '2026-04-07 03:08:55'),
(79, 'produto', 9, '2026-04-07', 1, 1, '2026-04-07 03:09:02', '2026-04-07 03:09:02'),
(80, 'produto', 8, '2026-04-07', 1, 1, '2026-04-07 03:11:11', '2026-04-07 03:11:11'),
(81, 'produto', 7, '2026-04-07', 1, 1, '2026-04-07 03:11:40', '2026-04-07 03:11:40'),
(82, 'produto', 4, '2026-04-07', 1, 1, '2026-04-07 03:12:38', '2026-04-07 03:12:38'),
(83, 'produto', 1, '2026-04-07', 1, 1, '2026-04-07 03:12:59', '2026-04-07 03:12:59'),
(84, 'produto', 16, '2026-04-07', 1, 1, '2026-04-07 03:14:08', '2026-04-07 03:14:08'),
(85, 'loja', 1, '2026-04-07', 2, 0, '2026-04-07 06:35:45', '2026-04-07 13:59:07'),
(86, 'loja', 1, '2026-04-08', 1, 0, '2026-04-08 08:17:08', '2026-04-08 08:17:08'),
(87, 'produto', 14, '2026-04-09', 1, 1, '2026-04-09 18:44:15', '2026-04-09 18:44:15'),
(88, 'produto', 3, '2026-04-09', 1, 1, '2026-04-09 21:47:42', '2026-04-09 21:47:42'),
(89, 'produto', 5, '2026-04-09', 1, 1, '2026-04-09 21:54:01', '2026-04-09 21:54:01'),
(90, 'loja', 1, '2026-04-11', 2, 0, '2026-04-11 06:02:05', '2026-04-11 08:02:12'),
(91, 'produto', 5, '2026-04-12', 1, 1, '2026-04-12 14:38:40', '2026-04-12 14:38:40'),
(92, 'produto', 12, '2026-04-13', 1, 1, '2026-04-13 10:03:40', '2026-04-13 10:03:40'),
(93, 'produto', 7, '2026-04-13', 1, 1, '2026-04-13 10:04:22', '2026-04-13 10:04:22'),
(94, 'produto', 1, '2026-04-13', 1, 1, '2026-04-13 10:05:48', '2026-04-13 10:05:48'),
(95, 'produto', 4, '2026-04-13', 1, 1, '2026-04-13 10:07:51', '2026-04-13 10:07:51'),
(96, 'produto', 16, '2026-04-13', 1, 1, '2026-04-13 10:07:51', '2026-04-13 10:07:51'),
(97, 'produto', 9, '2026-04-13', 1, 1, '2026-04-13 10:08:42', '2026-04-13 10:08:42'),
(98, 'produto', 8, '2026-04-13', 1, 1, '2026-04-13 10:09:08', '2026-04-13 10:09:08'),
(99, 'produto', 6, '2026-04-13', 1, 1, '2026-04-13 10:09:08', '2026-04-13 10:09:08'),
(100, 'produto', 13, '2026-04-13', 1, 1, '2026-04-13 10:09:41', '2026-04-13 10:09:41'),
(101, 'produto', 2, '2026-04-13', 1, 1, '2026-04-13 10:10:36', '2026-04-13 10:10:36'),
(102, 'produto', 3, '2026-04-13', 1, 1, '2026-04-13 10:11:01', '2026-04-13 10:11:01'),
(103, 'produto', 11, '2026-04-13', 1, 1, '2026-04-13 10:12:05', '2026-04-13 10:12:05'),
(104, 'produto', 14, '2026-04-13', 1, 1, '2026-04-13 11:41:27', '2026-04-13 11:41:27'),
(105, 'produto', 10, '2026-04-13', 1, 1, '2026-04-13 11:41:40', '2026-04-13 11:41:40'),
(106, 'produto', 5, '2026-04-13', 1, 1, '2026-04-13 11:44:53', '2026-04-13 11:44:53'),
(107, 'produto', 15, '2026-04-13', 1, 1, '2026-04-13 11:45:42', '2026-04-13 11:45:42'),
(108, 'loja', 1, '2026-04-13', 1, 0, '2026-04-14 00:13:42', '2026-04-14 00:13:42'),
(109, 'loja', 1, '2026-04-16', 2, 0, '2026-04-16 09:06:54', '2026-04-16 16:00:16'),
(110, 'produto', 8, '2026-04-16', 2, 2, '2026-04-16 11:09:25', '2026-04-16 12:29:35'),
(111, 'produto', 3, '2026-04-16', 3, 3, '2026-04-16 11:10:30', '2026-04-16 22:50:05'),
(112, 'produto', 7, '2026-04-16', 3, 3, '2026-04-16 11:11:31', '2026-04-17 02:01:50'),
(113, 'produto', 6, '2026-04-16', 3, 3, '2026-04-16 11:11:36', '2026-04-17 02:46:31'),
(114, 'produto', 12, '2026-04-16', 2, 2, '2026-04-16 11:11:36', '2026-04-16 12:25:28'),
(115, 'produto', 16, '2026-04-16', 2, 2, '2026-04-16 11:12:29', '2026-04-16 12:34:25'),
(116, 'produto', 13, '2026-04-16', 2, 2, '2026-04-16 11:12:30', '2026-04-16 12:30:58'),
(117, 'produto', 2, '2026-04-16', 3, 3, '2026-04-16 11:12:30', '2026-04-17 01:17:08'),
(118, 'produto', 4, '2026-04-16', 3, 3, '2026-04-16 11:13:16', '2026-04-17 00:27:19'),
(119, 'produto', 11, '2026-04-16', 2, 2, '2026-04-16 11:14:04', '2026-04-16 12:25:28'),
(120, 'produto', 1, '2026-04-16', 3, 3, '2026-04-16 11:15:06', '2026-04-16 23:34:49'),
(121, 'produto', 9, '2026-04-16', 1, 1, '2026-04-16 12:29:35', '2026-04-16 12:29:35'),
(122, 'produto', 5, '2026-04-16', 2, 2, '2026-04-16 12:36:57', '2026-04-16 14:14:10'),
(123, 'produto', 10, '2026-04-16', 2, 2, '2026-04-16 12:37:38', '2026-04-16 14:08:31'),
(124, 'produto', 14, '2026-04-16', 2, 2, '2026-04-16 12:43:03', '2026-04-16 14:14:10'),
(125, 'produto', 15, '2026-04-16', 2, 2, '2026-04-16 12:44:27', '2026-04-16 14:07:06'),
(126, 'produto', 9, '2026-04-17', 1, 1, '2026-04-17 03:08:26', '2026-04-17 03:08:26'),
(127, 'produto', 16, '2026-04-17', 1, 1, '2026-04-17 03:29:51', '2026-04-17 03:29:51'),
(128, 'produto', 11, '2026-04-17', 1, 1, '2026-04-17 03:49:00', '2026-04-17 03:49:00'),
(129, 'produto', 12, '2026-04-17', 1, 1, '2026-04-17 04:13:53', '2026-04-17 04:13:53'),
(130, 'produto', 13, '2026-04-17', 1, 1, '2026-04-17 04:28:24', '2026-04-17 04:28:24'),
(131, 'produto', 8, '2026-04-17', 1, 1, '2026-04-17 04:41:18', '2026-04-17 04:41:18'),
(132, 'produto', 5, '2026-04-17', 1, 1, '2026-04-17 06:05:07', '2026-04-17 06:05:07'),
(133, 'produto', 10, '2026-04-17', 1, 1, '2026-04-17 06:20:29', '2026-04-17 06:20:29'),
(134, 'produto', 14, '2026-04-17', 1, 1, '2026-04-17 06:34:53', '2026-04-17 06:34:53'),
(135, 'produto', 15, '2026-04-17', 1, 1, '2026-04-17 06:49:09', '2026-04-17 06:49:09'),
(136, 'produto', 9, '2026-04-18', 1, 1, '2026-04-18 08:41:39', '2026-04-18 08:41:39'),
(137, 'loja', 1, '2026-04-22', 2, 0, '2026-04-22 09:11:27', '2026-04-23 00:22:03'),
(138, 'loja', 1, '2026-04-23', 2, 0, '2026-04-23 15:39:47', '2026-04-23 20:30:45'),
(139, 'produto', 8, '2026-04-23', 2, 2, '2026-04-23 15:40:02', '2026-04-23 20:31:04'),
(140, 'produto', 13, '2026-04-23', 2, 2, '2026-04-23 15:40:03', '2026-04-23 20:31:07'),
(141, 'produto', 3, '2026-04-23', 2, 2, '2026-04-23 15:40:04', '2026-04-23 20:31:10'),
(142, 'produto', 6, '2026-04-23', 2, 2, '2026-04-23 15:40:05', '2026-04-23 20:31:08'),
(143, 'produto', 1, '2026-04-23', 2, 2, '2026-04-23 15:40:05', '2026-04-23 20:31:09'),
(144, 'produto', 16, '2026-04-23', 2, 2, '2026-04-23 15:40:06', '2026-04-23 20:31:06'),
(145, 'produto', 2, '2026-04-23', 2, 2, '2026-04-23 15:40:07', '2026-04-23 20:31:00'),
(146, 'produto', 4, '2026-04-23', 2, 2, '2026-04-23 15:40:09', '2026-04-23 20:31:02'),
(147, 'produto', 9, '2026-04-23', 2, 2, '2026-04-23 15:40:10', '2026-04-23 20:31:03'),
(148, 'produto', 7, '2026-04-23', 2, 2, '2026-04-23 15:40:11', '2026-04-23 20:31:01'),
(149, 'produto', 12, '2026-04-23', 2, 2, '2026-04-23 15:40:11', '2026-04-23 20:31:02'),
(150, 'produto', 11, '2026-04-23', 2, 2, '2026-04-23 15:40:12', '2026-04-23 20:31:08'),
(151, 'produto', 14, '2026-04-23', 2, 2, '2026-04-23 15:40:14', '2026-04-23 20:31:12'),
(152, 'produto', 5, '2026-04-23', 2, 2, '2026-04-23 15:40:15', '2026-04-23 20:31:11'),
(153, 'produto', 15, '2026-04-23', 2, 2, '2026-04-23 15:40:15', '2026-04-23 20:31:13'),
(154, 'produto', 10, '2026-04-23', 2, 2, '2026-04-23 15:40:16', '2026-04-23 20:31:12'),
(155, 'loja', 1, '2026-04-30', 1, 0, '2026-04-30 15:08:33', '2026-04-30 15:08:33'),
(156, 'loja', 1, '2026-05-02', 1, 0, '2026-05-02 21:28:55', '2026-05-02 21:28:55'),
(157, 'loja', 1, '2026-05-03', 2, 0, '2026-05-03 12:52:56', '2026-05-03 13:56:21'),
(158, 'loja', 1, '2026-05-08', 3, 0, '2026-05-08 07:26:34', '2026-05-08 21:26:44'),
(159, 'produto', 6, '2026-05-08', 3, 3, '2026-05-08 07:26:51', '2026-05-08 21:27:05'),
(160, 'produto', 13, '2026-05-08', 3, 3, '2026-05-08 07:26:52', '2026-05-08 21:27:03'),
(161, 'produto', 2, '2026-05-08', 3, 3, '2026-05-08 07:26:53', '2026-05-08 21:27:04'),
(162, 'produto', 8, '2026-05-08', 3, 3, '2026-05-08 07:26:54', '2026-05-08 21:27:07'),
(163, 'produto', 11, '2026-05-08', 3, 3, '2026-05-08 07:26:55', '2026-05-08 21:26:59'),
(164, 'produto', 12, '2026-05-08', 3, 3, '2026-05-08 07:26:56', '2026-05-08 21:27:04'),
(165, 'produto', 16, '2026-05-08', 3, 3, '2026-05-08 07:26:57', '2026-05-08 21:27:02'),
(166, 'produto', 7, '2026-05-08', 3, 3, '2026-05-08 07:26:59', '2026-05-08 21:27:06'),
(167, 'produto', 9, '2026-05-08', 3, 3, '2026-05-08 07:26:59', '2026-05-08 21:27:07'),
(168, 'produto', 4, '2026-05-08', 3, 3, '2026-05-08 07:27:00', '2026-05-08 21:27:08'),
(169, 'produto', 1, '2026-05-08', 3, 3, '2026-05-08 07:27:01', '2026-05-08 21:27:09'),
(170, 'produto', 3, '2026-05-08', 3, 3, '2026-05-08 07:27:01', '2026-05-08 21:27:00'),
(171, 'produto', 10, '2026-05-08', 3, 3, '2026-05-08 07:27:03', '2026-05-08 21:27:10'),
(172, 'produto', 15, '2026-05-08', 3, 3, '2026-05-08 07:27:04', '2026-05-08 21:27:11'),
(173, 'produto', 14, '2026-05-08', 3, 3, '2026-05-08 07:27:04', '2026-05-08 21:27:11'),
(174, 'produto', 5, '2026-05-08', 3, 3, '2026-05-08 07:27:05', '2026-05-08 21:27:12');

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

--
-- Estrutura da tabela `cupons`
--

CREATE TABLE `cupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `codigo` varchar(50) NOT NULL,
  `descricao` text DEFAULT NULL,
  `tipo` enum('percentual','fixo','frete_gratis') NOT NULL DEFAULT 'fixo',
  `valor` decimal(10,2) NOT NULL DEFAULT 0.00,
  `valor_minimo_pedido` decimal(10,2) NOT NULL DEFAULT 0.00,
  `desconto_maximo` decimal(10,2) DEFAULT NULL,
  `usos_maximos` int(11) DEFAULT NULL,
  `usos_por_usuario` int(11) NOT NULL DEFAULT 1,
  `usos_realizados` int(11) NOT NULL DEFAULT 0,
  `valido_de` timestamp NULL DEFAULT NULL,
  `valido_ate` timestamp NULL DEFAULT NULL,
  `primeiro_pedido` tinyint(1) NOT NULL DEFAULT 0,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `enderecos`
--

CREATE TABLE `enderecos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED NOT NULL,
  `apelido` varchar(50) NOT NULL DEFAULT 'Casa',
  `destinatario` varchar(150) DEFAULT NULL,
  `cep` varchar(9) NOT NULL,
  `logradouro` varchar(200) NOT NULL,
  `numero` varchar(20) NOT NULL,
  `complemento` varchar(100) DEFAULT NULL,
  `bairro` varchar(100) NOT NULL,
  `cidade` varchar(100) NOT NULL,
  `estado` varchar(2) NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `principal` tinyint(1) NOT NULL DEFAULT 0,
  `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 da tabela `entregas`
--

CREATE TABLE `entregas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pedido_id` bigint(20) UNSIGNED NOT NULL,
  `entregador_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('aguardando','aceito','coletado','em_rota','entregue','cancelado') NOT NULL DEFAULT 'aguardando',
  `distancia_km` decimal(8,3) DEFAULT NULL,
  `tempo_estimado_min` int(11) DEFAULT NULL,
  `taxa_entrega` decimal(10,2) NOT NULL DEFAULT 0.00,
  `latitude_coleta` decimal(10,8) DEFAULT NULL,
  `longitude_coleta` decimal(11,8) DEFAULT NULL,
  `latitude_destino` decimal(10,8) DEFAULT NULL,
  `longitude_destino` decimal(11,8) DEFAULT NULL,
  `latitude_atual` decimal(10,8) DEFAULT NULL,
  `longitude_atual` decimal(11,8) DEFAULT NULL,
  `token_rastreamento` varchar(64) NOT NULL,
  `link_rastreamento_whatsapp` varchar(255) DEFAULT NULL,
  `aceito_em` timestamp NULL DEFAULT NULL,
  `coletado_em` timestamp NULL DEFAULT NULL,
  `entregue_em` timestamp NULL DEFAULT NULL,
  `localizacao_atualizada_em` timestamp NULL DEFAULT NULL,
  `observacoes` text DEFAULT NULL,
  `rota_historico` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`rota_historico`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `failed_jobs`
--

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

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

--
-- Estrutura da tabela `funcionarios`
--

CREATE TABLE `funcionarios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `tipo` enum('funcionario','freelancer','autonomo','terceirizado') NOT NULL DEFAULT 'funcionario',
  `cargo` varchar(100) DEFAULT NULL,
  `salario` decimal(10,2) DEFAULT NULL,
  `data_admissao` date DEFAULT NULL,
  `data_demissao` date DEFAULT NULL,
  `e_entregador` tinyint(1) NOT NULL DEFAULT 0,
  `veiculo` varchar(100) DEFAULT NULL,
  `placa_veiculo` varchar(10) DEFAULT NULL,
  `cnh` varchar(11) DEFAULT NULL,
  `latitude_atual` decimal(10,8) DEFAULT NULL,
  `longitude_atual` decimal(11,8) DEFAULT NULL,
  `localizacao_atualizada_em` timestamp NULL DEFAULT NULL,
  `disponivel_entregas` tinyint(1) NOT NULL DEFAULT 0,
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `configuracoes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`configuracoes`)),
  `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;

--
-- Extraindo dados da tabela `funcionarios`
--

INSERT INTO `funcionarios` (`id`, `usuario_id`, `loja_id`, `tipo`, `cargo`, `salario`, `data_admissao`, `data_demissao`, `e_entregador`, `veiculo`, `placa_veiculo`, `cnh`, `latitude_atual`, `longitude_atual`, `localizacao_atualizada_em`, `disponivel_entregas`, `ativo`, `configuracoes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 3, 1, 'funcionario', 'Atendente', NULL, '2026-03-18', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(2, 4, 1, 'funcionario', 'Entregador', NULL, '2026-03-18', NULL, 1, 'Moto Honda CG 160', 'ABC-1234', NULL, NULL, NULL, NULL, 1, 1, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL);

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

--
-- Estrutura da tabela `grupos_adicionais`
--

CREATE TABLE `grupos_adicionais` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `produto_id` bigint(20) UNSIGNED NOT NULL,
  `nome` varchar(100) NOT NULL,
  `descricao` text DEFAULT NULL,
  `min_selecao` int(11) NOT NULL DEFAULT 0,
  `max_selecao` int(11) NOT NULL DEFAULT 1,
  `obrigatorio` tinyint(1) NOT NULL DEFAULT 0,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `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;

--
-- Extraindo dados da tabela `grupos_adicionais`
--

INSERT INTO `grupos_adicionais` (`id`, `produto_id`, `nome`, `descricao`, `min_selecao`, `max_selecao`, `obrigatorio`, `ordem`, `ativo`, `created_at`, `updated_at`) VALUES
(1, 1, 'Ponto do Hambúrguer', NULL, 1, 1, 1, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(2, 1, 'Adicionais', NULL, 0, 5, 0, 2, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(3, 2, 'Ponto do Hambúrguer', NULL, 1, 1, 1, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(4, 2, 'Adicionais', NULL, 0, 5, 0, 2, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(5, 3, 'Adicionais', NULL, 0, 5, 0, 2, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(6, 4, 'Ponto do Hambúrguer', NULL, 1, 1, 1, 1, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(7, 4, 'Adicionais', NULL, 0, 5, 0, 2, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19'),
(8, 5, 'Adicionais', NULL, 0, 5, 0, 2, 1, '2026-03-18 05:20:19', '2026-03-18 05:20:19');

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

--
-- Estrutura da tabela `itens_adicionais_pedido`
--

CREATE TABLE `itens_adicionais_pedido` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `item_pedido_id` bigint(20) UNSIGNED NOT NULL,
  `adicional_id` bigint(20) UNSIGNED NOT NULL,
  `adicional_nome` varchar(100) NOT NULL,
  `adicional_preco` decimal(10,2) NOT NULL,
  `quantidade` int(11) NOT NULL DEFAULT 1,
  `subtotal` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `itens_pedido`
--

CREATE TABLE `itens_pedido` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pedido_id` bigint(20) UNSIGNED NOT NULL,
  `produto_id` bigint(20) UNSIGNED NOT NULL,
  `produto_nome` varchar(150) NOT NULL,
  `produto_descricao` text DEFAULT NULL,
  `produto_preco` decimal(10,2) NOT NULL,
  `quantidade` int(11) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `observacoes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `jobs`
--

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

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

--
-- Estrutura da tabela `lgpd_aceites`
--

CREATE TABLE `lgpd_aceites` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED DEFAULT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `versao` varchar(20) NOT NULL DEFAULT '1.0',
  `tipo` enum('cookies','termos','ambos') NOT NULL DEFAULT 'ambos',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `lgpd_aceites`
--

INSERT INTO `lgpd_aceites` (`id`, `usuario_id`, `loja_id`, `ip`, `user_agent`, `versao`, `tipo`, `created_at`, `updated_at`) VALUES
(1, NULL, 1, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', '1.0', 'cookies', '2026-03-18 06:32:40', '2026-03-18 06:32:40'),
(2, NULL, 1, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '1.0', 'cookies', '2026-03-18 06:36:57', '2026-03-18 06:36:57'),
(3, NULL, 1, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 6.0.1; Moto G (4)) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', '1.0', 'cookies', '2026-03-18 17:39:06', '2026-03-18 17:39:06'),
(4, NULL, 1, '189.89.12.169', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '1.0', 'cookies', '2026-04-03 05:20:09', '2026-04-03 05:20:09');

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

--
-- Estrutura da tabela `migrations`
--

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

--
-- Extraindo dados da tabela `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2024_01_01_000001_create_lojas_table', 1),
(2, '2024_01_01_000002_create_usuarios_table', 1),
(3, '2024_01_01_000003_create_funcionarios_table', 1),
(4, '2024_01_01_000004_create_enderecos_table', 1),
(5, '2024_01_01_000005_create_categorias_table', 1),
(6, '2024_01_01_000006_create_produtos_table', 1),
(7, '2024_01_01_000007_create_bairros_entrega_table', 1),
(8, '2024_01_01_000008_create_pedidos_table', 1),
(9, '2024_01_01_000009_create_pagamentos_table', 1),
(10, '2024_01_01_000010_create_entregas_table', 1),
(11, '2024_01_01_000011_create_cupons_table', 1),
(12, '2024_01_01_000012_create_avaliacoes_table', 1),
(13, '2024_01_02_000001_add_features_to_lojas_table', 1),
(14, '2024_01_03_000001_add_cnpj_alphanumeric_visits_auto_hours', 1),
(15, '2024_01_04_000001_create_planos_system', 1),
(16, '2024_01_05_000001_create_tours_system', 2),
(17, '2026_03_18_000100_add_gorjeta_and_avaliacoes_columns', 3);

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

--
-- Estrutura da tabela `notas_fiscais`
--

CREATE TABLE `notas_fiscais` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pedido_id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `numero` varchar(20) DEFAULT NULL,
  `serie` varchar(10) NOT NULL DEFAULT '1',
  `tipo` enum('nfce','nfe') NOT NULL DEFAULT 'nfce',
  `ambiente` enum('homologacao','producao') NOT NULL DEFAULT 'homologacao',
  `status` enum('pendente','processando','autorizada','cancelada','rejeitada') NOT NULL DEFAULT 'pendente',
  `chave_acesso` varchar(50) DEFAULT NULL,
  `protocolo` varchar(30) DEFAULT NULL,
  `url_danfe` varchar(500) DEFAULT NULL,
  `xml_path` varchar(255) DEFAULT NULL,
  `motivo_rejeicao` text DEFAULT NULL,
  `dados_emissao` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`dados_emissao`)),
  `resposta_sefaz` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`resposta_sefaz`)),
  `valor_total` decimal(10,2) DEFAULT NULL,
  `emitida_em` timestamp NULL DEFAULT NULL,
  `cancelada_em` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `notificacoes`
--

CREATE TABLE `notificacoes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED NOT NULL,
  `titulo` varchar(150) NOT NULL,
  `mensagem` text NOT NULL,
  `tipo` varchar(50) NOT NULL DEFAULT 'info',
  `icone` varchar(50) DEFAULT NULL,
  `url` varchar(500) DEFAULT NULL,
  `dados` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`dados`)),
  `lida` tinyint(1) NOT NULL DEFAULT 0,
  `lida_em` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `pagamentos`
--

CREATE TABLE `pagamentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pedido_id` bigint(20) UNSIGNED NOT NULL,
  `metodo` varchar(50) NOT NULL,
  `status` enum('pendente','aprovado','recusado','cancelado','reembolsado','em_analise') NOT NULL DEFAULT 'pendente',
  `valor` decimal(10,2) NOT NULL,
  `mp_payment_id` varchar(255) DEFAULT NULL,
  `mp_preference_id` varchar(255) DEFAULT NULL,
  `mp_status` varchar(255) DEFAULT NULL,
  `mp_status_detail` varchar(255) DEFAULT NULL,
  `mp_transaction_id` varchar(255) DEFAULT NULL,
  `pix_qr_code` varchar(255) DEFAULT NULL,
  `pix_qr_code_base64` text DEFAULT NULL,
  `pix_expiracao` timestamp NULL DEFAULT NULL,
  `parcelas` int(11) NOT NULL DEFAULT 1,
  `bandeira_cartao` varchar(30) DEFAULT NULL,
  `ultimos_digitos_cartao` varchar(4) DEFAULT NULL,
  `titular_cartao` varchar(150) DEFAULT NULL,
  `comprovante` varchar(255) DEFAULT NULL,
  `resposta_gateway` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`resposta_gateway`)),
  `pago_em` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `pedidos`
--

CREATE TABLE `pedidos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED NOT NULL,
  `numero` varchar(20) NOT NULL,
  `status` enum('aguardando_pagamento','pagamento_aprovado','confirmado','em_preparo','pronto','saiu_para_entrega','entregue','cancelado','recusado') NOT NULL DEFAULT 'aguardando_pagamento',
  `tipo_entrega` enum('entrega','retirada') NOT NULL DEFAULT 'entrega',
  `endereco_id` bigint(20) UNSIGNED DEFAULT NULL,
  `endereco_cep` varchar(9) DEFAULT NULL,
  `endereco_logradouro` varchar(200) DEFAULT NULL,
  `endereco_numero` varchar(20) DEFAULT NULL,
  `endereco_complemento` varchar(100) DEFAULT NULL,
  `endereco_bairro` varchar(100) DEFAULT NULL,
  `endereco_cidade` varchar(100) DEFAULT NULL,
  `endereco_estado` varchar(2) DEFAULT NULL,
  `endereco_latitude` decimal(10,8) DEFAULT NULL,
  `endereco_longitude` decimal(11,8) DEFAULT NULL,
  `subtotal` decimal(10,2) NOT NULL DEFAULT 0.00,
  `taxa_entrega` decimal(10,2) NOT NULL DEFAULT 0.00,
  `desconto` decimal(10,2) NOT NULL DEFAULT 0.00,
  `gorjeta_entregador` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `observacoes` text DEFAULT NULL,
  `cupom_codigo` varchar(50) DEFAULT NULL,
  `tempo_estimado_min` int(11) DEFAULT NULL,
  `confirmado_em` timestamp NULL DEFAULT NULL,
  `entregue_em` timestamp NULL DEFAULT NULL,
  `cancelado_em` timestamp NULL DEFAULT NULL,
  `motivo_cancelamento` text DEFAULT NULL,
  `entregador_id` bigint(20) UNSIGNED DEFAULT NULL,
  `link_rastreamento` varchar(255) DEFAULT NULL,
  `historico_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`historico_status`)),
  `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 da tabela `planos`
--

CREATE TABLE `planos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nome` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `descricao` text DEFAULT NULL,
  `preco_mensal` decimal(10,2) NOT NULL DEFAULT 0.00,
  `preco_anual` decimal(10,2) DEFAULT NULL,
  `recursos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`recursos`)),
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `destaque` tinyint(1) NOT NULL DEFAULT 0,
  `ordem` int(11) 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;

--
-- Extraindo dados da tabela `planos`
--

INSERT INTO `planos` (`id`, `nome`, `slug`, `descricao`, `preco_mensal`, `preco_anual`, `recursos`, `ativo`, `destaque`, `ordem`, `created_at`, `updated_at`) VALUES
(1, 'Plano Gratuita', 'gratuita', 'Período de teste de 14 dias com todos os recursos disponíveis', 0.00, 0.00, '{\"produtos_ilimitados\":true,\"pedidos_ilimitados\":true,\"pagamento_online\":true,\"relatorios_completos\":true,\"estatisticas_visitas\":true,\"notificacoes_whatsapp\":true,\"cozinha_app\":true,\"nfe_integracao\":true,\"lgpd_compliance\":true,\"popups_marketing\":true,\"suporte_prioritario\":false,\"dominio_personalizado\":false,\"api_acesso\":false}', 1, 0, 1, '2026-03-18 02:31:29', '2026-03-18 02:31:29'),
(2, 'Plano Profissional', 'profissional', 'Acesso completo a todos os recursos com suporte prioritário', 97.00, 970.00, '{\"produtos_ilimitados\":true,\"pedidos_ilimitados\":true,\"pagamento_online\":true,\"relatorios_completos\":true,\"estatisticas_visitas\":true,\"notificacoes_whatsapp\":true,\"cozinha_app\":true,\"nfe_integracao\":true,\"lgpd_compliance\":true,\"popups_marketing\":true,\"suporte_prioritario\":true,\"dominio_personalizado\":true,\"api_acesso\":true}', 1, 1, 2, '2026-03-18 02:31:29', '2026-03-18 02:31:29');

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

--
-- Estrutura da tabela `produtos`
--

CREATE TABLE `produtos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `categoria_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nome` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `descricao` text DEFAULT NULL,
  `ingredientes` text DEFAULT NULL,
  `preco` decimal(10,2) NOT NULL,
  `preco_promocional` decimal(10,2) DEFAULT NULL,
  `peso_gramas` decimal(10,2) DEFAULT NULL,
  `imagem_principal` varchar(255) DEFAULT NULL,
  `imagens` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`imagens`)),
  `estoque` int(11) DEFAULT NULL,
  `controla_estoque` tinyint(1) NOT NULL DEFAULT 0,
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `disponivel` tinyint(1) NOT NULL DEFAULT 1,
  `destaque` tinyint(1) NOT NULL DEFAULT 0,
  `novo` tinyint(1) NOT NULL DEFAULT 0,
  `tempo_preparo_min` int(11) NOT NULL DEFAULT 15,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `vendas_total` int(11) NOT NULL DEFAULT 0,
  `avaliacao_media` decimal(3,2) NOT NULL DEFAULT 0.00,
  `avaliacoes_total` int(11) NOT NULL DEFAULT 0,
  `informacoes_nutricionais` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`informacoes_nutricionais`)),
  `alergicos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`alergicos`)),
  `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;

--
-- Extraindo dados da tabela `produtos`
--

INSERT INTO `produtos` (`id`, `loja_id`, `categoria_id`, `nome`, `slug`, `descricao`, `ingredientes`, `preco`, `preco_promocional`, `peso_gramas`, `imagem_principal`, `imagens`, `estoque`, `controla_estoque`, `ativo`, `disponivel`, `destaque`, `novo`, `tempo_preparo_min`, `ordem`, `vendas_total`, `avaliacao_media`, `avaliacoes_total`, `informacoes_nutricionais`, `alergicos`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 'X-Burguer', 'x-burguer', 'Pão, hambúrguer artesanal 150g, queijo, alface, tomate, maionese caseira.', NULL, 22.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 1, 0, 15, 1, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(2, 1, 1, 'X-Bacon', 'x-bacon', 'Pão, hambúrguer 150g, bacon crocante, queijo cheddar, cebola crispy.', NULL, 26.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 1, 0, 15, 2, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(3, 1, 1, 'X-Frango', 'x-frango', 'Pão, filé de frango grelhado, queijo prato, alface americana, tomate.', NULL, 24.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 3, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(4, 1, 1, 'X-Tudo', 'x-tudo', 'Pão, hambúrguer duplo, bacon, queijo, alface, tomate, ovo, milho, batata palha.', NULL, 32.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 1, 1, 15, 4, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(5, 1, 1, 'X-Veggie', 'x-veggie', 'Pão integral, hambúrguer de grão-de-bico, queijo, rúcula, tomate seco.', NULL, 24.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 1, 15, 5, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(6, 1, 4, 'Refrigerante Lata', 'refrigerante-lata', NULL, NULL, 5.00, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 1, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(7, 1, 4, 'Suco Natural 300ml', 'suco-natural-300ml', NULL, NULL, 9.00, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 2, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(8, 1, 4, 'Água Mineral', 'agua-mineral', NULL, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 3, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(9, 1, 4, 'Milkshake 400ml', 'milkshake-400ml', NULL, NULL, 14.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 4, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(10, 1, 4, 'Vitamina de Frutas', 'vitamina-de-frutas', NULL, NULL, 12.00, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 15, 5, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(11, 1, 3, 'Batata Frita P', 'batata-frita-p', NULL, NULL, 16.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 12, 1, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(12, 1, 3, 'Batata Frita M', 'batata-frita-m', NULL, NULL, 22.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 12, 2, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(13, 1, 3, 'Batata Frita G', 'batata-frita-g', NULL, NULL, 28.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 12, 3, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(14, 1, 3, 'Onion Rings', 'onion-rings', NULL, NULL, 22.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 12, 4, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(15, 1, 3, 'Nuggets 10 peças', 'nuggets-10-pecas', NULL, NULL, 19.90, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, 0, 12, 5, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL),
(16, 1, 6, 'Combo X-Burguer', 'combo-x-burguer', 'X-Burguer + Batata Frita M + Refrigerante Lata. Economia de R$ 5,00!', NULL, 34.90, 32.90, NULL, NULL, NULL, NULL, 0, 1, 1, 1, 0, 20, 1, 0, 0.00, 0, NULL, NULL, '2026-03-18 05:20:19', '2026-03-18 05:20:19', NULL);

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

--
-- Estrutura da tabela `sessions`
--

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

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

--
-- Estrutura da tabela `tours`
--

CREATE TABLE `tours` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nome` varchar(100) NOT NULL,
  `titulo` varchar(200) NOT NULL,
  `descricao` text DEFAULT NULL,
  `passos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`passos`)),
  `ativo` tinyint(1) NOT NULL DEFAULT 1,
  `ordem` int(11) NOT NULL DEFAULT 0,
  `target_role` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `tours`
--

INSERT INTO `tours` (`id`, `nome`, `titulo`, `descricao`, `passos`, `ativo`, `ordem`, `target_role`, `created_at`, `updated_at`) VALUES
(1, 'primeiro_acesso_admin', 'Bem-vindo ao Painel Administrativo!', 'Tour guiado para conhecer as principais funcionalidades do sistema', '[{\"id\":\"dashboard\",\"element\":\".admin-nav-link[href=\\\"\\/admin\\/dashboard\\\"]\",\"title\":\"\\ud83c\\udfe0 Dashboard\",\"text\":\"Este \\u00e9 seu painel principal! Aqui voc\\u00ea ver\\u00e1 um resumo das vendas, pedidos recentes e estat\\u00edsticas importantes da sua loja.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"pedidos\",\"element\":\".admin-nav-link[href*=\\\"pedidos\\\"]\",\"title\":\"\\ud83d\\udccb Pedidos\",\"text\":\"Aqui voc\\u00ea gerencia todos os pedidos da sua loja. Visualize, atualize status, atribua entregadores e muito mais!\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"produtos\",\"element\":\".admin-nav-link[href*=\\\"produtos\\\"]\",\"title\":\"\\ud83d\\udce6 Produtos\",\"text\":\"Cadastre e gerencie seu card\\u00e1pio aqui! Adicione produtos, categorias, pre\\u00e7os e fotos.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"planos\",\"element\":\".admin-nav-link[href*=\\\"planos\\\"]\",\"title\":\"\\ud83d\\udcb3 Meu Plano\",\"text\":\"Gerencie sua assinatura aqui. Veja seu plano atual, upgrade ou downgrade e hist\\u00f3rico de pagamentos.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"relatorios\",\"element\":\".admin-nav-link[href*=\\\"relatorios\\\"]\",\"title\":\"\\ud83d\\udcca Relat\\u00f3rios\",\"text\":\"An\\u00e1lise detalhada das suas vendas. Gere relat\\u00f3rios, exporte dados e acompanhe o desempenho.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"estatisticas\",\"element\":\".admin-nav-link[href*=\\\"estatisticas\\\"]\",\"title\":\"\\ud83d\\udc41\\ufe0f Visitas\",\"text\":\"Veja estat\\u00edsticas de visitas \\u00e0 sua loja. Saiba quais produtos s\\u00e3o mais vistos e de onde v\\u00eam seus clientes.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"loja_config\",\"element\":\".admin-nav-link[href*=\\\"lojas\\\"]\",\"title\":\"\\u2699\\ufe0f Configura\\u00e7\\u00f5es da Loja\",\"text\":\"Personalize sua loja aqui! Configure dados, hor\\u00e1rios, delivery, pagamentos e muito mais.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"dashboard_content\",\"element\":\".dashboard-cards\",\"title\":\"\\ud83d\\udcc8 Cards de Informa\\u00e7\\u00f5es\",\"text\":\"Estes cards mostram as informa\\u00e7\\u00f5es mais importantes em tempo real: vendas do dia, pedidos pendentes, faturamento e mais.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"pedidos_recentes\",\"element\":\".pedidos-recentes\",\"title\":\"\\ud83d\\udccb Pedidos Recentes\",\"text\":\"Aqui voc\\u00ea v\\u00ea os \\u00faltimos pedidos e pode agir rapidamente: aceitar, preparar para entrega ou cancelar.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"acoes_rapidas\",\"element\":\".acoes-rapidas\",\"title\":\"\\ud83d\\ude80 A\\u00e7\\u00f5es R\\u00e1pidas\",\"text\":\"Bot\\u00f5es para a\\u00e7\\u00f5es comuns: cadastrar produto, ver pedidos, configurar delivery. Economize tempo!\",\"buttons\":[{\"text\":\"Concluir Tour\",\"action\":\"complete\"}]}]', 1, 1, 'admin', '2026-03-18 02:48:29', '2026-03-18 02:48:29'),
(2, 'primeiro_produto', '📦 Cadastre seu Primeiro Produto', 'Aprenda a cadastrar produtos no seu cardápio', '[{\"id\":\"btn_novo_produto\",\"element\":\".btn-novo-produto\",\"title\":\"\\u2795 Novo Produto\",\"text\":\"Clique aqui para adicionar um novo produto ao seu card\\u00e1pio. Vamos cadastrar seu primeiro item!\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"nome_produto\",\"element\":\"input[name=\\\"nome\\\"]\",\"title\":\"\\ud83d\\udcdd Nome do Produto\",\"text\":\"D\\u00ea um nome claro e apetitoso ao seu produto. Ex: \\\"Hamb\\u00farguer X-Bacon\\\" ou \\\"Pizza Calabresa\\\".\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"descricao_produto\",\"element\":\"textarea[name=\\\"descricao\\\"]\",\"title\":\"\\ud83d\\udcc4 Descri\\u00e7\\u00e3o\",\"text\":\"Descreva seu produto detalhadamente. Ingredientes, modo de preparo, informa\\u00e7\\u00f5es al\\u00e9rgicas, etc.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"preco_produto\",\"element\":\"input[name=\\\"preco\\\"]\",\"title\":\"\\ud83d\\udcb0 Pre\\u00e7o\",\"text\":\"Defina o pre\\u00e7o do produto. Use v\\u00edrgula para centavos: 29,90\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"categoria_produto\",\"element\":\"select[name=\\\"categoria_id\\\"]\",\"title\":\"\\ud83d\\udcc2 Categoria\",\"text\":\"Selecione a categoria adequada. Isso ajuda os clientes a encontrarem seus produtos.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"imagem_produto\",\"element\":\".upload-produto\",\"title\":\"\\ud83d\\udcf8 Foto do Produto\",\"text\":\"Uma boa foto aumenta as vendas! Clique aqui para fazer upload da imagem do seu produto.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"disponibilidade\",\"element\":\"input[name=\\\"disponivel\\\"]\",\"title\":\"\\u2705 Disponibilidade\",\"text\":\"Marque se o produto est\\u00e1 dispon\\u00edvel para venda. Desmarque quando estiver em falta.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"btn_salvar\",\"element\":\".btn-salvar-produto\",\"title\":\"\\ud83d\\udcbe Salvar Produto\",\"text\":\"Pronto! Clique aqui para salvar seu primeiro produto. Depois voc\\u00ea pode cadastrar mais!\",\"buttons\":[{\"text\":\"Concluir Tour\",\"action\":\"complete\"}]}]', 1, 2, 'admin', '2026-03-18 02:48:29', '2026-03-18 02:48:29'),
(3, 'primeiro_pedido', '📋 Gerenciando seu Primeiro Pedido', 'Aprenda a processar pedidos dos clientes', '[{\"id\":\"lista_pedidos\",\"element\":\".pedidos-table\",\"title\":\"\\ud83d\\udccb Lista de Pedidos\",\"text\":\"Aqui voc\\u00ea v\\u00ea todos os pedidos recebidos. Cada linha mostra informa\\u00e7\\u00f5es importantes do pedido.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"status_pedido\",\"element\":\".status-badge\",\"title\":\"\\ud83d\\udd04 Status do Pedido\",\"text\":\"Cores diferentes indicam status: azul (novo), verde (confirmado), laranja (preparando), etc.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"btn_detalhes\",\"element\":\".btn-ver-pedido\",\"title\":\"\\ud83d\\udc41\\ufe0f Ver Detalhes\",\"text\":\"Clique para ver todos os detalhes do pedido: itens, endere\\u00e7o, cliente, forma de pagamento.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"acoes_status\",\"element\":\".acoes-status\",\"title\":\"\\u26a1 A\\u00e7\\u00f5es R\\u00e1pidas\",\"text\":\"Use estes bot\\u00f5es para atualizar o status rapidamente: confirmar, preparar, entregar, etc.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"imprimir_pedido\",\"element\":\".btn-imprimir\",\"title\":\"\\ud83d\\udda8\\ufe0f Imprimir\",\"text\":\"Imprima o pedido para a cozinha ou para controle interno. Formato otimizado para impress\\u00e3o.\",\"buttons\":[{\"text\":\"Pr\\u00f3ximo\",\"action\":\"next\"}]},{\"id\":\"notificar_cliente\",\"element\":\".btn-notificar\",\"title\":\"\\ud83d\\udcf1 Notificar Cliente\",\"text\":\"Envie notifica\\u00e7\\u00f5es autom\\u00e1ticas por WhatsApp sobre o status do pedido.\",\"buttons\":[{\"text\":\"Concluir Tour\",\"action\":\"complete\"}]}]', 1, 3, 'admin', '2026-03-18 02:48:29', '2026-03-18 02:48:29');

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

--
-- Estrutura da tabela `tour_usuarios`
--

CREATE TABLE `tour_usuarios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `tour_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('pendente','em_andamento','concluido','pulado') NOT NULL DEFAULT 'pendente',
  `passo_atual` int(11) NOT NULL DEFAULT 0,
  `dados_adicionais` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`dados_adicionais`)),
  `iniciado_em` timestamp NULL DEFAULT NULL,
  `concluido_em` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `visitas_categorias`
--

CREATE TABLE `visitas_categorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `categoria_id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `referer` varchar(500) DEFAULT NULL,
  `device_type` varchar(20) DEFAULT NULL,
  `visitado_em` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `visitas_lojas`
--

CREATE TABLE `visitas_lojas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `referer` varchar(500) DEFAULT NULL,
  `device_type` varchar(20) DEFAULT NULL,
  `visitado_em` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `visitas_lojas`
--

INSERT INTO `visitas_lojas` (`id`, `loja_id`, `usuario_id`, `ip`, `user_agent`, `referer`, `device_type`, `visitado_em`) VALUES
(1, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lojas', 'desktop', '2026-03-18 06:32:05'),
(2, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lojas', 'mobile', '2026-03-18 06:37:43'),
(3, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 6.0.1; Moto G (4)) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'https://delivery.nano-servidor.rio.br/login', 'mobile', '2026-03-18 17:58:02'),
(4, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lojas', 'desktop', '2026-03-18 18:31:33'),
(5, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 19:04:30'),
(6, 1, NULL, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lojas', 'mobile', '2026-03-18 22:08:30'),
(7, 1, 6, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/notificacoes', 'mobile', '2026-03-18 22:14:09'),
(8, 1, NULL, '57.141.0.12', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:02:05'),
(9, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lojas', 'desktop', '2026-03-19 14:13:59'),
(10, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lojas', 'desktop', '2026-03-19 14:32:59'),
(11, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-20 12:36:37'),
(12, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-20 16:57:57'),
(13, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-20 18:12:09'),
(14, 1, NULL, '66.249.85.7', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', '', 'mobile', '2026-03-21 00:09:14'),
(15, 1, NULL, '66.102.8.33', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', '', 'mobile', '2026-03-21 00:09:15'),
(16, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-22 15:22:56'),
(17, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-24 16:48:29'),
(18, 1, NULL, '181.77.236.26', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/notificacoes', 'desktop', '2026-03-24 22:27:53'),
(19, 1, NULL, '181.77.236.26', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/notificacoes', 'desktop', '2026-03-24 23:42:11'),
(20, 1, NULL, '181.77.236.26', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/notificacoes', 'desktop', '2026-03-24 23:50:19'),
(21, 1, NULL, '74.7.229.15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; +https://openai.com/searchbot', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-26 20:11:36'),
(22, 1, NULL, '181.77.247.0', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/notificacoes', 'desktop', '2026-03-26 22:06:08'),
(23, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-27 20:53:27'),
(24, 1, NULL, '74.7.243.218', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-31 10:01:22'),
(25, 1, NULL, '74.7.241.25', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-31 14:04:10'),
(26, 1, NULL, '189.89.12.169', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'mobile', '2026-04-03 05:20:05'),
(27, 1, NULL, '74.7.227.28', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-04-05 20:34:24'),
(28, 1, NULL, '91.231.89.22', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 02:43:48'),
(29, 1, NULL, '91.231.89.17', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 02:54:20'),
(30, 1, NULL, '216.73.216.211', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-07 06:35:45'),
(31, 1, NULL, '66.249.65.164', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.7680.177 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', '', 'mobile', '2026-04-07 13:59:07'),
(32, 1, NULL, '5.133.192.187', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123', '', 'desktop', '2026-04-08 08:17:08'),
(33, 1, NULL, '74.7.243.218', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-04-11 06:02:05'),
(34, 1, NULL, '74.7.227.178', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-04-11 08:02:12'),
(35, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-14 00:13:42'),
(36, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 09:06:54'),
(37, 1, NULL, '54.39.0.105', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-16 16:00:16'),
(38, 1, NULL, '74.7.229.124', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.3; +https://openai.com/searchbot', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-04-22 09:11:27'),
(39, 1, NULL, '142.44.233.218', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-23 00:22:02'),
(40, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-04-23 15:39:47'),
(41, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-04-23 20:30:45'),
(42, 1, NULL, '74.7.241.25', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-04-30 15:08:33'),
(43, 1, NULL, '194.116.236.215', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:41.0) Gecko/20100101 Firefox/41.0', '', 'desktop', '2026-05-02 21:28:55'),
(44, 1, NULL, '74.7.227.53', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-05-03 12:52:56'),
(45, 1, NULL, '74.7.242.41', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-05-03 13:56:21'),
(46, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-05-08 07:26:34'),
(47, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/', 'desktop', '2026-05-08 16:32:56'),
(48, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-05-08 21:26:44');

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

--
-- Estrutura da tabela `visitas_produtos`
--

CREATE TABLE `visitas_produtos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `produto_id` bigint(20) UNSIGNED NOT NULL,
  `loja_id` bigint(20) UNSIGNED NOT NULL,
  `usuario_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `referer` varchar(500) DEFAULT NULL,
  `device_type` varchar(20) DEFAULT NULL,
  `visitado_em` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `visitas_produtos`
--

INSERT INTO `visitas_produtos` (`id`, `produto_id`, `loja_id`, `usuario_id`, `ip`, `user_agent`, `referer`, `device_type`, `visitado_em`) VALUES
(1, 1, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 06:31:32'),
(2, 16, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/buscar', 'mobile', '2026-03-18 06:39:09'),
(3, 4, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 14:52:55'),
(4, 4, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 15:35:06'),
(5, 5, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 16:51:08'),
(6, 3, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 16:59:39'),
(7, 3, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 17:08:44'),
(8, 4, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 17:27:53'),
(9, 2, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/', 'desktop', '2026-03-18 17:35:55'),
(10, 6, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Linux; Android 6.0.1; Moto G (4)) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'https://delivery.nano-servidor.rio.br/buscar', 'mobile', '2026-03-18 17:58:27'),
(11, 4, 1, NULL, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lanchonete-do-ze', 'mobile', '2026-03-18 22:08:51'),
(12, 16, 1, 6, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lanchonete-do-ze', 'mobile', '2026-03-18 22:12:32'),
(13, 1, 1, 6, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lanchonete-do-ze', 'mobile', '2026-03-18 22:14:12'),
(14, 5, 1, 6, '181.77.242.5', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://www.delivery.nano-servidor.rio.br/lanchonete-do-ze', 'mobile', '2026-03-18 22:14:25'),
(15, 6, 1, NULL, '57.141.0.62', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:03:11'),
(16, 13, 1, NULL, '57.141.0.10', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:03:17'),
(17, 16, 1, NULL, '57.141.0.25', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:04:03'),
(18, 2, 1, NULL, '57.141.0.63', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:04:40'),
(19, 11, 1, NULL, '57.141.0.8', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:05:52'),
(20, 3, 1, NULL, '57.141.0.35', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:06:14'),
(21, 12, 1, NULL, '57.141.0.38', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:07:48'),
(22, 7, 1, NULL, '57.141.0.7', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:08:07'),
(23, 9, 1, NULL, '57.141.0.12', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:09:14'),
(24, 4, 1, NULL, '57.141.0.65', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:12:50'),
(25, 1, 1, NULL, '57.141.0.17', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:14:12'),
(26, 8, 1, NULL, '57.141.0.51', 'meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)', '', 'desktop', '2026-03-19 10:24:40'),
(27, 10, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lanchonete-do-ze', 'desktop', '2026-03-19 14:14:40'),
(28, 4, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lanchonete-do-ze', 'desktop', '2026-03-19 14:15:31'),
(29, 9, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:53'),
(30, 8, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:54'),
(31, 1, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:54'),
(32, 13, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:55'),
(33, 7, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:55'),
(34, 16, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:56'),
(35, 6, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:56'),
(36, 11, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:57'),
(37, 12, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:58'),
(38, 4, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:36:58'),
(39, 10, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 12:36:59'),
(40, 15, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 12:36:59'),
(41, 14, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 12:37:00'),
(42, 2, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:37:00'),
(43, 5, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 12:37:01'),
(44, 3, 1, NULL, '74.7.227.138', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 12:37:02'),
(45, 16, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:11'),
(46, 4, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:11'),
(47, 13, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:12'),
(48, 9, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:13'),
(49, 12, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:13'),
(50, 11, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:14'),
(51, 6, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:15'),
(52, 7, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:15'),
(53, 8, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:16'),
(54, 1, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:17'),
(55, 2, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:17'),
(56, 3, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 16:58:19'),
(57, 14, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 16:58:19'),
(58, 15, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 16:58:20'),
(59, 10, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 16:58:20'),
(60, 5, 1, NULL, '74.7.242.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 16:58:21'),
(61, 1, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:21'),
(62, 16, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:22'),
(63, 9, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:23'),
(64, 11, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:24'),
(65, 13, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:24'),
(66, 12, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:25'),
(67, 7, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:26'),
(68, 4, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:26'),
(69, 3, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:29'),
(70, 2, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:29'),
(71, 8, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:30'),
(72, 6, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-03-20 18:12:31'),
(73, 15, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 18:12:32'),
(74, 14, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 18:12:32'),
(75, 5, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 18:12:33'),
(76, 10, 1, NULL, '74.7.227.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-03-20 18:12:33'),
(77, 6, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-25 01:17:54'),
(78, 11, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-25 05:33:38'),
(79, 8, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-25 08:08:21'),
(80, 16, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-25 10:40:00'),
(81, 3, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-26 07:47:56'),
(82, 4, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-26 10:59:24'),
(83, 2, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-27 08:32:37'),
(84, 1, 1, NULL, '177.192.7.91', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'https://delivery.nano-servidor.rio.br/lanchonete-do-ze', 'desktop', '2026-03-27 20:53:46'),
(85, 7, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-28 01:49:16'),
(86, 8, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-28 22:29:26'),
(87, 13, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-29 07:39:24'),
(88, 4, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-29 07:39:27'),
(89, 1, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-29 18:12:43'),
(90, 2, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-29 20:39:07'),
(91, 16, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-29 22:13:05'),
(92, 6, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-30 00:04:36'),
(93, 14, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-30 04:03:57'),
(94, 9, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-31 18:28:09'),
(95, 12, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-31 20:17:42'),
(96, 12, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-31 21:48:27'),
(97, 11, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-31 22:43:46'),
(98, 13, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-03-31 22:45:35'),
(99, 1, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-01 00:17:08'),
(100, 1, 1, NULL, '189.89.12.169', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', 'https://delivery.nano-servidor.rio.br/lanchonete-do-ze', 'mobile', '2026-04-03 05:20:15'),
(101, 9, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-03 20:13:21'),
(102, 7, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-03 23:32:16'),
(103, 15, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-03 23:33:57'),
(104, 10, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-04 01:59:40'),
(105, 15, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-04 08:12:29'),
(106, 10, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-06 19:52:06'),
(107, 3, 1, NULL, '91.231.89.126', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:07:33'),
(108, 6, 1, NULL, '91.231.89.37', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:08:55'),
(109, 9, 1, NULL, '91.231.89.34', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:09:02'),
(110, 8, 1, NULL, '91.231.89.38', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:11:11'),
(111, 7, 1, NULL, '91.231.89.38', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:11:40'),
(112, 4, 1, NULL, '91.231.89.37', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:12:38'),
(113, 1, 1, NULL, '91.231.89.127', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:12:59'),
(114, 16, 1, NULL, '91.231.89.124', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', '', 'desktop', '2026-04-07 03:14:08'),
(115, 14, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-09 18:44:15'),
(116, 3, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-09 21:47:42'),
(117, 5, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-09 21:54:01'),
(118, 5, 1, NULL, '216.244.66.198', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', '', 'desktop', '2026-04-12 14:38:40'),
(119, 12, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:03:39'),
(120, 7, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:04:22'),
(121, 1, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:05:48'),
(122, 16, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:07:51'),
(123, 4, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:07:51'),
(124, 9, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:08:42'),
(125, 8, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:09:08'),
(126, 6, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:09:08'),
(127, 13, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:09:41'),
(128, 2, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:10:36'),
(129, 3, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:11:01'),
(130, 11, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 10:12:05'),
(131, 14, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 11:41:27'),
(132, 10, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 11:41:40'),
(133, 5, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 11:44:53'),
(134, 15, 1, NULL, '216.73.216.34', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-13 11:45:42'),
(135, 8, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:09:25'),
(136, 3, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:10:30'),
(137, 7, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:11:31'),
(138, 6, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:11:36'),
(139, 12, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:11:36'),
(140, 16, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:12:29'),
(141, 13, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:12:30'),
(142, 2, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:12:30'),
(143, 4, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:13:16'),
(144, 11, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:14:04'),
(145, 1, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 11:15:06'),
(146, 11, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:25:28'),
(147, 12, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:25:28'),
(148, 7, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:26:21'),
(149, 6, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:27:02'),
(150, 9, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:29:35'),
(151, 8, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:29:35'),
(152, 13, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:30:58'),
(153, 1, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:32:01'),
(154, 3, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:32:42'),
(155, 4, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:33:25'),
(156, 16, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:34:25'),
(157, 2, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:34:41'),
(158, 5, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:36:57'),
(159, 10, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:37:38'),
(160, 14, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:43:03'),
(161, 15, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 12:44:27'),
(162, 15, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 14:07:06'),
(163, 10, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 14:08:31'),
(164, 5, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 14:14:10'),
(165, 14, 1, NULL, '216.73.216.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-16 14:14:10'),
(166, 3, 1, NULL, '54.39.203.44', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-16 22:50:05'),
(167, 1, 1, NULL, '54.39.210.218', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-16 23:34:49'),
(168, 4, 1, NULL, '15.235.96.253', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 00:27:19'),
(169, 2, 1, NULL, '54.39.203.185', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 01:17:08'),
(170, 7, 1, NULL, '142.44.228.45', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 02:01:50'),
(171, 6, 1, NULL, '15.235.27.106', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 02:46:31'),
(172, 9, 1, NULL, '51.222.168.241', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 03:08:26'),
(173, 16, 1, NULL, '54.39.203.187', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 03:29:51'),
(174, 11, 1, NULL, '51.161.37.10', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 03:49:00'),
(175, 12, 1, NULL, '142.44.225.210', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 04:13:53'),
(176, 13, 1, NULL, '54.39.89.174', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 04:28:24'),
(177, 8, 1, NULL, '51.222.168.3', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 04:41:18'),
(178, 5, 1, NULL, '142.44.228.48', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 06:05:07'),
(179, 10, 1, NULL, '51.161.65.32', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 06:20:29'),
(180, 14, 1, NULL, '54.39.210.76', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 06:34:53'),
(181, 15, 1, NULL, '51.222.168.245', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', '', 'desktop', '2026-04-17 06:49:09'),
(182, 9, 1, NULL, '216.73.217.27', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 'desktop', '2026-04-18 08:41:39'),
(183, 8, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:02'),
(184, 13, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:03'),
(185, 3, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:04'),
(186, 6, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:05'),
(187, 1, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:05'),
(188, 16, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:06'),
(189, 2, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:07'),
(190, 4, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:09'),
(191, 9, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:10'),
(192, 7, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:11'),
(193, 12, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:11'),
(194, 11, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 15:40:12'),
(195, 14, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 15:40:14'),
(196, 5, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 15:40:15'),
(197, 15, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 15:40:15'),
(198, 10, 1, NULL, '74.7.227.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 15:40:16'),
(199, 2, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:00'),
(200, 7, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:01'),
(201, 12, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:02'),
(202, 4, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:02'),
(203, 9, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:03'),
(204, 8, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:04'),
(205, 16, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:06'),
(206, 13, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:07'),
(207, 11, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:08'),
(208, 6, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:08'),
(209, 1, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:09'),
(210, 3, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-04-23 20:31:10'),
(211, 5, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 20:31:11'),
(212, 14, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 20:31:12'),
(213, 10, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 20:31:12'),
(214, 15, 1, NULL, '74.7.242.20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-04-23 20:31:13'),
(215, 6, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:51'),
(216, 13, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:52'),
(217, 2, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:53'),
(218, 8, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:54'),
(219, 11, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:55'),
(220, 12, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:56'),
(221, 16, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:57'),
(222, 7, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:59'),
(223, 9, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:26:59'),
(224, 4, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:27:00'),
(225, 1, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:27:01'),
(226, 3, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 07:27:01'),
(227, 10, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 07:27:03'),
(228, 15, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 07:27:04'),
(229, 14, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 07:27:04'),
(230, 5, 1, NULL, '74.7.243.225', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 07:27:05'),
(231, 6, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:15'),
(232, 2, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:16'),
(233, 3, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:16'),
(234, 1, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:18'),
(235, 4, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:18'),
(236, 12, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:19'),
(237, 7, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:20'),
(238, 16, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:21'),
(239, 13, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:22'),
(240, 11, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:23'),
(241, 8, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:24'),
(242, 9, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 16:33:27'),
(243, 15, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 16:33:29'),
(244, 5, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 16:33:31'),
(245, 10, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 16:33:31'),
(246, 14, 1, NULL, '74.7.227.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://mail.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 16:33:32'),
(247, 11, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:26:59'),
(248, 3, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:00'),
(249, 16, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:02'),
(250, 13, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:03');
INSERT INTO `visitas_produtos` (`id`, `produto_id`, `loja_id`, `usuario_id`, `ip`, `user_agent`, `referer`, `device_type`, `visitado_em`) VALUES
(251, 2, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:04'),
(252, 12, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:04'),
(253, 6, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:05'),
(254, 7, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:06'),
(255, 9, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:07'),
(256, 8, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:07'),
(257, 4, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:08'),
(258, 1, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar', 'desktop', '2026-05-08 21:27:09'),
(259, 10, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 21:27:10'),
(260, 15, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 21:27:11'),
(261, 14, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 21:27:11'),
(262, 5, 1, NULL, '74.7.227.143', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'https://www.delivery.nano-servidor.rio.br/buscar?page=2&q=', 'desktop', '2026-05-08 21:27:12');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `adicionais`
--
ALTER TABLE `adicionais`
  ADD PRIMARY KEY (`id`),
  ADD KEY `adicionais_grupo_id_foreign` (`grupo_id`);

--
-- Índices para tabela `assinaturas`
--
ALTER TABLE `assinaturas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assinaturas_plano_id_foreign` (`plano_id`),
  ADD KEY `assinaturas_loja_id_status_index` (`loja_id`,`status`),
  ADD KEY `assinaturas_trial_expira_em_index` (`trial_expira_em`);

--
-- Índices para tabela `avaliacoes`
--
ALTER TABLE `avaliacoes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `avaliacoes_pedido_id_foreign` (`pedido_id`),
  ADD KEY `avaliacoes_usuario_id_foreign` (`usuario_id`),
  ADD KEY `avaliacoes_loja_id_aprovado_index` (`loja_id`,`aprovado`);

--
-- Índices para tabela `bairros_entrega`
--
ALTER TABLE `bairros_entrega`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bairros_entrega_loja_id_ativo_index` (`loja_id`,`ativo`);

--
-- Índices para tabela `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `banners_loja_id_ativo_index` (`loja_id`,`ativo`);

--
-- Índices para tabela `categorias`
--
ALTER TABLE `categorias`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categorias_loja_id_slug_unique` (`loja_id`,`slug`),
  ADD KEY `categorias_categoria_pai_id_foreign` (`categoria_pai_id`),
  ADD KEY `categorias_loja_id_ativo_ordem_index` (`loja_id`,`ativo`,`ordem`);

--
-- Índices para tabela `contadores_visitas`
--
ALTER TABLE `contadores_visitas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `contadores_visitas_tipo_entidade_id_data_unique` (`tipo`,`entidade_id`,`data`),
  ADD KEY `contadores_visitas_tipo_entidade_id_data_index` (`tipo`,`entidade_id`,`data`);

--
-- Índices para tabela `cupons`
--
ALTER TABLE `cupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cupons_codigo_unique` (`codigo`),
  ADD KEY `cupons_loja_id_ativo_index` (`loja_id`,`ativo`),
  ADD KEY `cupons_codigo_index` (`codigo`);

--
-- Índices para tabela `enderecos`
--
ALTER TABLE `enderecos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `enderecos_usuario_id_index` (`usuario_id`);

--
-- Índices para tabela `entregas`
--
ALTER TABLE `entregas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `entregas_pedido_id_unique` (`pedido_id`),
  ADD UNIQUE KEY `entregas_token_rastreamento_unique` (`token_rastreamento`),
  ADD KEY `entregas_entregador_id_status_index` (`entregador_id`,`status`),
  ADD KEY `entregas_token_rastreamento_index` (`token_rastreamento`);

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

--
-- Índices para tabela `funcionarios`
--
ALTER TABLE `funcionarios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `funcionarios_usuario_id_foreign` (`usuario_id`),
  ADD KEY `funcionarios_loja_id_e_entregador_disponivel_entregas_index` (`loja_id`,`e_entregador`,`disponivel_entregas`),
  ADD KEY `funcionarios_loja_id_ativo_index` (`loja_id`,`ativo`);

--
-- Índices para tabela `grupos_adicionais`
--
ALTER TABLE `grupos_adicionais`
  ADD PRIMARY KEY (`id`),
  ADD KEY `grupos_adicionais_produto_id_foreign` (`produto_id`);

--
-- Índices para tabela `itens_adicionais_pedido`
--
ALTER TABLE `itens_adicionais_pedido`
  ADD PRIMARY KEY (`id`),
  ADD KEY `itens_adicionais_pedido_item_pedido_id_foreign` (`item_pedido_id`),
  ADD KEY `itens_adicionais_pedido_adicional_id_foreign` (`adicional_id`);

--
-- Índices para tabela `itens_pedido`
--
ALTER TABLE `itens_pedido`
  ADD PRIMARY KEY (`id`),
  ADD KEY `itens_pedido_produto_id_foreign` (`produto_id`),
  ADD KEY `itens_pedido_pedido_id_index` (`pedido_id`);

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

--
-- Índices para tabela `lgpd_aceites`
--
ALTER TABLE `lgpd_aceites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lgpd_aceites_usuario_id_foreign` (`usuario_id`),
  ADD KEY `lgpd_aceites_loja_id_foreign` (`loja_id`);

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

--
-- Índices para tabela `notas_fiscais`
--
ALTER TABLE `notas_fiscais`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notas_fiscais_pedido_id_foreign` (`pedido_id`),
  ADD KEY `notas_fiscais_loja_id_status_index` (`loja_id`,`status`),
  ADD KEY `notas_fiscais_chave_acesso_index` (`chave_acesso`);

--
-- Índices para tabela `notificacoes`
--
ALTER TABLE `notificacoes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notificacoes_usuario_id_lida_index` (`usuario_id`,`lida`);

--
-- Índices para tabela `pagamentos`
--
ALTER TABLE `pagamentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pagamentos_pedido_id_status_index` (`pedido_id`,`status`),
  ADD KEY `pagamentos_mp_payment_id_index` (`mp_payment_id`),
  ADD KEY `pagamentos_mp_preference_id_index` (`mp_preference_id`);

--
-- Índices para tabela `pedidos`
--
ALTER TABLE `pedidos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pedidos_numero_unique` (`numero`),
  ADD KEY `pedidos_endereco_id_foreign` (`endereco_id`),
  ADD KEY `pedidos_entregador_id_foreign` (`entregador_id`),
  ADD KEY `pedidos_loja_id_status_index` (`loja_id`,`status`),
  ADD KEY `pedidos_usuario_id_status_index` (`usuario_id`,`status`),
  ADD KEY `pedidos_numero_index` (`numero`),
  ADD KEY `pedidos_created_at_index` (`created_at`);

--
-- Índices para tabela `planos`
--
ALTER TABLE `planos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `planos_slug_unique` (`slug`);

--
-- Índices para tabela `produtos`
--
ALTER TABLE `produtos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `produtos_loja_id_slug_unique` (`loja_id`,`slug`),
  ADD KEY `produtos_categoria_id_foreign` (`categoria_id`),
  ADD KEY `produtos_loja_id_ativo_disponivel_index` (`loja_id`,`ativo`,`disponivel`),
  ADD KEY `produtos_loja_id_categoria_id_index` (`loja_id`,`categoria_id`),
  ADD KEY `produtos_destaque_index` (`destaque`);

--
-- Índices para 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 para tabela `tours`
--
ALTER TABLE `tours`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tours_ativo_ordem_index` (`ativo`,`ordem`),
  ADD KEY `tours_target_role_index` (`target_role`);

--
-- Índices para tabela `tour_usuarios`
--
ALTER TABLE `tour_usuarios`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tour_usuarios_user_id_tour_id_unique` (`user_id`,`tour_id`),
  ADD KEY `tour_usuarios_tour_id_foreign` (`tour_id`),
  ADD KEY `tour_usuarios_user_id_status_index` (`user_id`,`status`);

--
-- Índices para tabela `visitas_categorias`
--
ALTER TABLE `visitas_categorias`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitas_categorias_usuario_id_foreign` (`usuario_id`),
  ADD KEY `visitas_categorias_categoria_id_visitado_em_index` (`categoria_id`,`visitado_em`),
  ADD KEY `visitas_categorias_loja_id_visitado_em_index` (`loja_id`,`visitado_em`);

--
-- Índices para tabela `visitas_lojas`
--
ALTER TABLE `visitas_lojas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitas_lojas_usuario_id_foreign` (`usuario_id`),
  ADD KEY `visitas_lojas_loja_id_visitado_em_index` (`loja_id`,`visitado_em`),
  ADD KEY `visitas_lojas_ip_index` (`ip`);

--
-- Índices para tabela `visitas_produtos`
--
ALTER TABLE `visitas_produtos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitas_produtos_usuario_id_foreign` (`usuario_id`),
  ADD KEY `visitas_produtos_produto_id_visitado_em_index` (`produto_id`,`visitado_em`),
  ADD KEY `visitas_produtos_loja_id_visitado_em_index` (`loja_id`,`visitado_em`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `adicionais`
--
ALTER TABLE `adicionais`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT de tabela `assinaturas`
--
ALTER TABLE `assinaturas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `avaliacoes`
--
ALTER TABLE `avaliacoes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `bairros_entrega`
--
ALTER TABLE `bairros_entrega`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de tabela `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de tabela `contadores_visitas`
--
ALTER TABLE `contadores_visitas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175;

--
-- AUTO_INCREMENT de tabela `cupons`
--
ALTER TABLE `cupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `enderecos`
--
ALTER TABLE `enderecos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `entregas`
--
ALTER TABLE `entregas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT de tabela `funcionarios`
--
ALTER TABLE `funcionarios`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `grupos_adicionais`
--
ALTER TABLE `grupos_adicionais`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de tabela `itens_adicionais_pedido`
--
ALTER TABLE `itens_adicionais_pedido`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `itens_pedido`
--
ALTER TABLE `itens_pedido`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT de tabela `lgpd_aceites`
--
ALTER TABLE `lgpd_aceites`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT de tabela `notas_fiscais`
--
ALTER TABLE `notas_fiscais`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `notificacoes`
--
ALTER TABLE `notificacoes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `pagamentos`
--
ALTER TABLE `pagamentos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `pedidos`
--
ALTER TABLE `pedidos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `planos`
--
ALTER TABLE `planos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `produtos`
--
ALTER TABLE `produtos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT de tabela `tours`
--
ALTER TABLE `tours`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `tour_usuarios`
--
ALTER TABLE `tour_usuarios`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `visitas_categorias`
--
ALTER TABLE `visitas_categorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `visitas_lojas`
--
ALTER TABLE `visitas_lojas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT de tabela `visitas_produtos`
--
ALTER TABLE `visitas_produtos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=263;

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

--
-- Limitadores para a tabela `adicionais`
--
ALTER TABLE `adicionais`
  ADD CONSTRAINT `adicionais_grupo_id_foreign` FOREIGN KEY (`grupo_id`) REFERENCES `grupos_adicionais` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `assinaturas`
--
ALTER TABLE `assinaturas`
  ADD CONSTRAINT `assinaturas_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `assinaturas_plano_id_foreign` FOREIGN KEY (`plano_id`) REFERENCES `planos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `avaliacoes`
--
ALTER TABLE `avaliacoes`
  ADD CONSTRAINT `avaliacoes_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `avaliacoes_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `avaliacoes_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `bairros_entrega`
--
ALTER TABLE `bairros_entrega`
  ADD CONSTRAINT `bairros_entrega_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `banners`
--
ALTER TABLE `banners`
  ADD CONSTRAINT `banners_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `categorias`
--
ALTER TABLE `categorias`
  ADD CONSTRAINT `categorias_categoria_pai_id_foreign` FOREIGN KEY (`categoria_pai_id`) REFERENCES `categorias` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `categorias_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `cupons`
--
ALTER TABLE `cupons`
  ADD CONSTRAINT `cupons_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `enderecos`
--
ALTER TABLE `enderecos`
  ADD CONSTRAINT `enderecos_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `entregas`
--
ALTER TABLE `entregas`
  ADD CONSTRAINT `entregas_entregador_id_foreign` FOREIGN KEY (`entregador_id`) REFERENCES `funcionarios` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `entregas_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `funcionarios`
--
ALTER TABLE `funcionarios`
  ADD CONSTRAINT `funcionarios_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `funcionarios_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `grupos_adicionais`
--
ALTER TABLE `grupos_adicionais`
  ADD CONSTRAINT `grupos_adicionais_produto_id_foreign` FOREIGN KEY (`produto_id`) REFERENCES `produtos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `itens_adicionais_pedido`
--
ALTER TABLE `itens_adicionais_pedido`
  ADD CONSTRAINT `itens_adicionais_pedido_adicional_id_foreign` FOREIGN KEY (`adicional_id`) REFERENCES `adicionais` (`id`),
  ADD CONSTRAINT `itens_adicionais_pedido_item_pedido_id_foreign` FOREIGN KEY (`item_pedido_id`) REFERENCES `itens_pedido` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `itens_pedido`
--
ALTER TABLE `itens_pedido`
  ADD CONSTRAINT `itens_pedido_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `itens_pedido_produto_id_foreign` FOREIGN KEY (`produto_id`) REFERENCES `produtos` (`id`);

--
-- Limitadores para a tabela `lgpd_aceites`
--
ALTER TABLE `lgpd_aceites`
  ADD CONSTRAINT `lgpd_aceites_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `lgpd_aceites_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL;

--
-- Limitadores para a tabela `notas_fiscais`
--
ALTER TABLE `notas_fiscais`
  ADD CONSTRAINT `notas_fiscais_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `notas_fiscais_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `notificacoes`
--
ALTER TABLE `notificacoes`
  ADD CONSTRAINT `notificacoes_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `pagamentos`
--
ALTER TABLE `pagamentos`
  ADD CONSTRAINT `pagamentos_pedido_id_foreign` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `pedidos`
--
ALTER TABLE `pedidos`
  ADD CONSTRAINT `pedidos_endereco_id_foreign` FOREIGN KEY (`endereco_id`) REFERENCES `enderecos` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pedidos_entregador_id_foreign` FOREIGN KEY (`entregador_id`) REFERENCES `funcionarios` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pedidos_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pedidos_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `produtos`
--
ALTER TABLE `produtos`
  ADD CONSTRAINT `produtos_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `produtos_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `tour_usuarios`
--
ALTER TABLE `tour_usuarios`
  ADD CONSTRAINT `tour_usuarios_tour_id_foreign` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tour_usuarios_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `visitas_categorias`
--
ALTER TABLE `visitas_categorias`
  ADD CONSTRAINT `visitas_categorias_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitas_categorias_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitas_categorias_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL;

--
-- Limitadores para a tabela `visitas_lojas`
--
ALTER TABLE `visitas_lojas`
  ADD CONSTRAINT `visitas_lojas_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitas_lojas_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL;

--
-- Limitadores para a tabela `visitas_produtos`
--
ALTER TABLE `visitas_produtos`
  ADD CONSTRAINT `visitas_produtos_loja_id_foreign` FOREIGN KEY (`loja_id`) REFERENCES `lojas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitas_produtos_produto_id_foreign` FOREIGN KEY (`produto_id`) REFERENCES `produtos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `visitas_produtos_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL;
COMMIT;

