One Hat Cyber Team
Your IP :
216.73.216.36
Server IP :
162.240.179.46
Server :
Linux vps-14493116.nutrivittasaude.com.br 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64
Server Software :
Apache
PHP Version :
8.2.31
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
lifeprimeti
/
meta.lifeprimeti.com.br
/
backup
/
View File Name :
barbearia_2026-05-24_22-17-05.sql
-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: barbearia_db -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `agendamentos` -- DROP TABLE IF EXISTS `agendamentos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `agendamentos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `cliente_id` int(11) NOT NULL, `profissional_id` int(11) NOT NULL, `servico_id` int(11) NOT NULL, `data` date NOT NULL, `hora` time NOT NULL, `hora_fim` time NOT NULL, `status` enum('pendente','confirmado','em_andamento','concluido','cancelado') NOT NULL DEFAULT 'pendente', `confirmado_cliente` tinyint(1) NOT NULL DEFAULT 0, `confirmado_admin` tinyint(1) NOT NULL DEFAULT 0, `pagamento_tipo` enum('gratis','manual','mercadopago','asaas') DEFAULT 'gratis', `pagamento_status` enum('pendente','aprovado','recusado','cancelado') DEFAULT 'pendente', `observacao` text DEFAULT NULL, `hash_link` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `lembrete_enviado` tinyint(1) NOT NULL DEFAULT 0, `hubpay_charge_id` varchar(100) DEFAULT NULL, `hubpay_pix_copy_paste` text DEFAULT NULL, `hubpay_pix_qrcode` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `cliente_id` (`cliente_id`), KEY `profissional_id` (`profissional_id`), KEY `servico_id` (`servico_id`), KEY `idx_data` (`data`), KEY `idx_status` (`status`), CONSTRAINT `agendamentos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `agendamentos_ibfk_2` FOREIGN KEY (`cliente_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE, CONSTRAINT `agendamentos_ibfk_3` FOREIGN KEY (`profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE CASCADE, CONSTRAINT `agendamentos_ibfk_4` FOREIGN KEY (`servico_id`) REFERENCES `servicos` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agendamentos` -- LOCK TABLES `agendamentos` WRITE; /*!40000 ALTER TABLE `agendamentos` DISABLE KEYS */; INSERT INTO `agendamentos` VALUES (1,3,8,2,6,'2026-05-25','17:00:00','17:20:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-21 22:42:41','2026-05-22 20:03:43',0,NULL,NULL,NULL),(3,3,8,2,6,'2026-05-25','17:40:00','18:00:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-22 17:19:25','2026-05-23 11:22:04',0,NULL,NULL,NULL),(4,3,8,2,6,'2026-05-26','16:20:00','16:40:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-23 11:23:32','2026-05-23 11:23:43',0,NULL,NULL,NULL),(5,3,8,2,6,'2026-05-26','14:00:00','14:20:00','cancelado',0,0,'gratis','pendente','',NULL,'2026-05-23 17:22:35','2026-05-23 17:23:45',0,NULL,NULL,NULL),(6,3,8,2,6,'2026-05-26','14:40:00','15:00:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-23 17:24:02','2026-05-23 17:24:41',0,NULL,NULL,NULL),(7,3,8,2,6,'2026-05-25','16:20:00','16:40:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-23 22:44:24','2026-05-24 01:59:37',0,NULL,NULL,NULL),(8,3,8,2,6,'2026-05-25','10:40:00','11:00:00','concluido',0,0,'gratis','pendente','',NULL,'2026-05-23 23:45:07','2026-05-23 23:45:26',0,NULL,NULL,NULL); /*!40000 ALTER TABLE `agendamentos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `anexos` -- DROP TABLE IF EXISTS `anexos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `anexos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `modelo` varchar(50) NOT NULL, `modelo_id` int(11) NOT NULL, `nome_original` varchar(255) DEFAULT NULL, `arquivo` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `anexos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `anexos` -- LOCK TABLES `anexos` WRITE; /*!40000 ALTER TABLE `anexos` DISABLE KEYS */; INSERT INTO `anexos` VALUES (1,3,'suporte',1,'digitalsac500.png','assets/uploads/suporte/suporte_6a0f7428e0e0e.png','2026-05-21 21:07:52'),(2,3,'suporte_resposta',1,'digitalsac600.png','assets/uploads/suporte/suporte_resp_6a0f7fd2bcbb4.png','2026-05-21 21:57:38'),(3,3,'suporte_resposta',2,'marketing.png','assets/uploads/suporte/suporte_resp_6a0f800aad544.png','2026-05-21 21:58:34'),(4,3,'suporte',2,'fat.jpeg','assets/uploads/suporte/suporte_resp_6a0f8034baf75.jpeg','2026-05-21 21:59:16'),(5,3,'suporte',3,'digitalsac500(1).png','assets/uploads/suporte/suporte_6a0f810db44ee.png','2026-05-21 22:02:53'),(6,3,'suporte',3,'marketing.png','assets/uploads/suporte/suporte_resp_6a0f811e8a6f1.png','2026-05-21 22:03:10'),(7,3,'suporte_resposta',5,'miguel.jpg','assets/uploads/suporte/suporte_resp_6a0f819840077.jpg','2026-05-21 22:05:12'),(8,1,'suporte',4,'aniversario.jpeg','assets/uploads/suporte/suporte_6a0f82588a99d.jpeg','2026-05-21 22:08:24'),(9,3,'suporte',5,'marketing.png','assets/uploads/suporte/suporte_6a0f8280924ba.png','2026-05-21 22:09:05'); /*!40000 ALTER TABLE `anexos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bloqueio_dias` -- DROP TABLE IF EXISTS `bloqueio_dias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bloqueio_dias` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `profissional_id` int(11) DEFAULT NULL, `data` date NOT NULL, `hora_inicio` time DEFAULT NULL, `hora_fim` time DEFAULT NULL, `motivo` varchar(255) DEFAULT NULL, `tipo` enum('empresa','profissional') NOT NULL DEFAULT 'empresa', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `profissional_id` (`profissional_id`), CONSTRAINT `bloqueio_dias_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `bloqueio_dias_ibfk_2` FOREIGN KEY (`profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bloqueio_dias` -- LOCK TABLES `bloqueio_dias` WRITE; /*!40000 ALTER TABLE `bloqueio_dias` DISABLE KEYS */; /*!40000 ALTER TABLE `bloqueio_dias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `caixa` -- DROP TABLE IF EXISTS `caixa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caixa` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `usuario_id` int(11) NOT NULL, `data_abertura` datetime NOT NULL, `data_fechamento` datetime DEFAULT NULL, `valor_abertura` decimal(10,2) NOT NULL DEFAULT 0.00, `valor_fechamento` decimal(10,2) DEFAULT 0.00, `status` enum('aberto','fechado') NOT NULL DEFAULT 'aberto', `observacoes` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `usuario_id` (`usuario_id`), CONSTRAINT `caixa_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `caixa_ibfk_2` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `caixa` -- LOCK TABLES `caixa` WRITE; /*!40000 ALTER TABLE `caixa` DISABLE KEYS */; INSERT INTO `caixa` VALUES (1,1,5,'2026-05-21 16:59:00',NULL,0.00,0.00,'aberto','','2026-05-21 19:59:31'),(2,3,4,'2026-05-21 17:18:00','2026-05-21 18:47:03',0.00,0.00,'fechado','','2026-05-21 20:18:14'),(3,3,4,'2026-05-22 14:04:00',NULL,0.00,0.00,'aberto','','2026-05-22 17:04:16'); /*!40000 ALTER TABLE `caixa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `caixa_movimentos` -- DROP TABLE IF EXISTS `caixa_movimentos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caixa_movimentos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `caixa_id` int(11) NOT NULL, `tipo` enum('entrada','saida','sangria','suprimento') NOT NULL, `descricao` varchar(255) DEFAULT NULL, `valor` decimal(10,2) NOT NULL, `forma_pagamento_id` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `caixa_id` (`caixa_id`), KEY `forma_pagamento_id` (`forma_pagamento_id`), CONSTRAINT `caixa_movimentos_ibfk_1` FOREIGN KEY (`caixa_id`) REFERENCES `caixa` (`id`) ON DELETE CASCADE, CONSTRAINT `caixa_movimentos_ibfk_2` FOREIGN KEY (`forma_pagamento_id`) REFERENCES `formas_pagamento` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `caixa_movimentos` -- LOCK TABLES `caixa_movimentos` WRITE; /*!40000 ALTER TABLE `caixa_movimentos` DISABLE KEYS */; INSERT INTO `caixa_movimentos` VALUES (1,3,'entrada','barba - life - por life prime ti (1/2)',2000.00,3,'2026-05-23 23:34:44'),(2,3,'entrada','barba - life - por life prime ti (2/2)',1000.00,1,'2026-05-23 23:34:44'); /*!40000 ALTER TABLE `caixa_movimentos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campanhas` -- DROP TABLE IF EXISTS `campanhas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campanhas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `titulo` varchar(200) NOT NULL, `corpo_html` text NOT NULL, `status` enum('rascunho','agendada','enviando','concluida','cancelada') NOT NULL DEFAULT 'rascunho', `data_agendamento` datetime DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `assunto` varchar(255) NOT NULL DEFAULT '', `enviadas` int(11) NOT NULL DEFAULT 0, `total_destinatarios` int(11) NOT NULL DEFAULT 0, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `campanhas_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campanhas` -- LOCK TABLES `campanhas` WRITE; /*!40000 ALTER TABLE `campanhas` DISABLE KEYS */; INSERT INTO `campanhas` VALUES (1,3,'teste','novo teste','',NULL,'2026-05-23 22:49:10','teste',0,1,'2026-05-23 22:51:55'); /*!40000 ALTER TABLE `campanhas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cargos` -- DROP TABLE IF EXISTS `cargos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cargos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `nome` varchar(100) NOT NULL, `ativo` tinyint(1) DEFAULT 1, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `cargos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cargos` -- LOCK TABLES `cargos` WRITE; /*!40000 ALTER TABLE `cargos` DISABLE KEYS */; INSERT INTO `cargos` VALUES (1,3,'Administrador',1); /*!40000 ALTER TABLE `cargos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comissoes` -- DROP TABLE IF EXISTS `comissoes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comissoes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `profissional_id` int(11) NOT NULL, `periodo_inicio` date NOT NULL, `periodo_fim` date NOT NULL, `valor` decimal(10,2) NOT NULL, `status` enum('pendente','pago','cancelado') NOT NULL DEFAULT 'pendente', `forma_pagamento_id` int(11) DEFAULT NULL, `data_pagamento` date DEFAULT NULL, `observacao` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `contas_pagar_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_comissao_periodo` (`empresa_id`,`profissional_id`,`periodo_inicio`,`periodo_fim`), KEY `profissional_id` (`profissional_id`), CONSTRAINT `comissoes_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `comissoes_ibfk_2` FOREIGN KEY (`profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comissoes` -- LOCK TABLES `comissoes` WRITE; /*!40000 ALTER TABLE `comissoes` DISABLE KEYS */; INSERT INTO `comissoes` VALUES (1,3,2,'2026-05-20','2026-05-29',0.00,'pago',1,'2026-05-23',NULL,'2026-05-23 23:43:06','2026-05-24 01:56:25',NULL),(2,3,2,'2026-05-01','2026-05-30',0.00,'pago',1,'2026-05-23',NULL,'2026-05-23 23:45:58','2026-05-24 01:56:20',NULL),(4,3,2,'2026-05-01','2026-05-29',0.00,'pendente',NULL,NULL,NULL,'2026-05-24 17:38:38','2026-05-24 17:38:38',NULL); /*!40000 ALTER TABLE `comissoes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config_smtp` -- DROP TABLE IF EXISTS `config_smtp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config_smtp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `host` varchar(255) NOT NULL DEFAULT '', `porta` int(11) NOT NULL DEFAULT 587, `usuario` varchar(255) NOT NULL DEFAULT '', `senha` varchar(255) NOT NULL DEFAULT '', `criptografia` enum('tls','ssl','nenhuma') NOT NULL DEFAULT 'tls', `email_from` varchar(255) NOT NULL DEFAULT '', `nome_from` varchar(255) NOT NULL DEFAULT '', `ativo` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config_smtp` -- LOCK TABLES `config_smtp` WRITE; /*!40000 ALTER TABLE `config_smtp` DISABLE KEYS */; INSERT INTO `config_smtp` VALUES (1,'mail.lifeprimeti.com.br',465,'bruno@lifeprimeti.com.br','lex18raf15*','ssl','bruno@lifeprimeti.com.br','bruno',1,'2026-05-22 17:38:32','2026-05-22 17:42:17'); /*!40000 ALTER TABLE `config_smtp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `configuracoes` -- DROP TABLE IF EXISTS `configuracoes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `configuracoes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `opcao_pagar` enum('sim','nao') NOT NULL DEFAULT 'nao', `gateway_padrao` enum('mercadopago','asaas','nenhum') NOT NULL DEFAULT 'nenhum', `mp_public_key` varchar(255) DEFAULT NULL, `mp_access_token` varchar(255) DEFAULT NULL, `asaas_api_key` varchar(255) DEFAULT NULL, `asaas_token` varchar(255) DEFAULT NULL, `whatsapp_api` varchar(255) DEFAULT NULL, `whatsapp_token` varchar(255) DEFAULT NULL, `whatsapp_instance` varchar(100) DEFAULT NULL, `horario_inicio` time DEFAULT '08:00:00', `horario_fim` time DEFAULT '18:00:00', `intervalo_padrao` int(11) DEFAULT 60, `confirma_cadastro` tinyint(1) NOT NULL DEFAULT 1, `confirma_agendamento` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `openai_api_key` varchar(255) DEFAULT NULL, `gemini_api_key` varchar(255) DEFAULT NULL, `claude_api_key` varchar(255) DEFAULT NULL, `smtp_host` varchar(255) DEFAULT '', `smtp_porta` int(11) DEFAULT 587, `smtp_usuario` varchar(255) DEFAULT '', `smtp_senha` varchar(255) DEFAULT '', `smtp_criptografia` enum('tls','ssl','nenhuma') NOT NULL DEFAULT 'tls', `smtp_email_from` varchar(255) DEFAULT '', `smtp_nome_from` varchar(255) DEFAULT '', `smtp_ativo` tinyint(1) NOT NULL DEFAULT 0, `waba_phone_id` varchar(100) DEFAULT '', `waba_token` varchar(512) DEFAULT '', `waba_business_id` varchar(100) DEFAULT '', `waba_webhook_token` varchar(100) DEFAULT '', `lembrete_ativo` tinyint(1) NOT NULL DEFAULT 0, `lembrete_timezone` varchar(50) DEFAULT 'America/Sao_Paulo', `lembrete_metodo` enum('email','whatsapp','digigo') NOT NULL DEFAULT 'email', `hubpay_api_key` varchar(255) DEFAULT '', `hubpay_webhook_secret` varchar(255) DEFAULT '', `hubpay_ambiente` enum('test','live') NOT NULL DEFAULT 'test', `digigo_base_url` varchar(255) DEFAULT '', `digigo_admin_token` varchar(512) DEFAULT '', `digigo_user_token` varchar(512) DEFAULT '', `digigo_user_name` varchar(100) DEFAULT '', `digigo_connected` tinyint(1) DEFAULT 0, `digigo_envio_ativo` tinyint(1) DEFAULT 0, `app_nome` varchar(100) DEFAULT NULL, `login_bg_tipo` enum('imagem','video') DEFAULT NULL, `login_bg_arquivo` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `empresa_id` (`empresa_id`), CONSTRAINT `configuracoes_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `configuracoes` -- LOCK TABLES `configuracoes` WRITE; /*!40000 ALTER TABLE `configuracoes` DISABLE KEYS */; INSERT INTO `configuracoes` VALUES (1,1,'nao','nenhum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08:00:00','18:00:00',60,1,1,'2026-05-21 16:11:25','2026-05-25 01:11:42',NULL,NULL,NULL,'',587,'','','tls','','',0,'','','','',0,'America/Sao_Paulo','email','','','test','https://server01.digigo.dev','45c16c900e4b30ef844d34a4e19432742fa7fd1ebd5e77a415d82f36aa411642','','',0,0,'Life Agendamentos','imagem','login_bg_1779671502.png'),(2,2,'nao','nenhum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08:00:00','18:00:00',60,1,1,'2026-05-21 16:31:57','2026-05-21 16:31:57',NULL,NULL,NULL,'',587,'','','tls','','',0,'','','','',0,'America/Sao_Paulo','email','','','test','','','','',0,0,NULL,NULL,NULL),(3,3,'nao','nenhum','','','',NULL,NULL,NULL,NULL,'08:00:00','18:00:00',60,1,1,'2026-05-21 16:51:07','2026-05-23 22:40:58','','','','mail.lifeprimeti.com.br',587,'bruno@lifeprimeti.com.br','152599lex18raf15*','tls','bruno@lifeprimeti.com.br','life',1,'','','','',0,'America/Sao_Paulo','email','','','test','','','','',0,0,NULL,NULL,NULL); /*!40000 ALTER TABLE `configuracoes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contas_pagar` -- DROP TABLE IF EXISTS `contas_pagar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contas_pagar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `descricao` varchar(255) NOT NULL, `fornecedor` varchar(200) DEFAULT NULL, `valor` decimal(10,2) NOT NULL, `repasse_profissional_id` int(11) DEFAULT NULL, `tipo` enum('funcionario','fornecedor','comissao') NOT NULL DEFAULT 'fornecedor', `status` enum('pendente','pago','cancelado') NOT NULL DEFAULT 'pendente', `data_vencimento` date DEFAULT NULL, `data_pagamento` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `fornecedor_id` int(11) DEFAULT NULL, `profissional_id` int(11) DEFAULT NULL, `forma_pagamento_id` int(11) DEFAULT NULL, `frequencia_id` int(11) DEFAULT NULL, `recorrente` tinyint(1) DEFAULT 0, `total_vezes` int(11) DEFAULT 0, `parcela_atual` int(11) DEFAULT 0, `observacoes` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `repasse_profissional_id` (`repasse_profissional_id`), CONSTRAINT `contas_pagar_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `contas_pagar_ibfk_2` FOREIGN KEY (`repasse_profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contas_pagar` -- LOCK TABLES `contas_pagar` WRITE; /*!40000 ALTER TABLE `contas_pagar` DISABLE KEYS */; INSERT INTO `contas_pagar` VALUES (1,3,'midia','life',100.00,NULL,'','pago','2026-05-28','2026-05-21','2026-05-21 16:53:04',NULL,NULL,NULL,NULL,0,0,0,NULL),(2,3,'Comissao periodo 2026-05-01 a 2026-05-30',NULL,0.00,NULL,'comissao','pago','2026-05-23','2026-05-23','2026-05-24 01:56:20',NULL,2,1,NULL,0,0,0,NULL),(3,3,'Comissao periodo 2026-05-20 a 2026-05-29',NULL,0.00,NULL,'comissao','pago','2026-05-23','2026-05-23','2026-05-24 01:56:25',NULL,2,1,NULL,0,0,0,NULL); /*!40000 ALTER TABLE `contas_pagar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contas_receber` -- DROP TABLE IF EXISTS `contas_receber`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contas_receber` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `agendamento_id` int(11) NOT NULL, `cliente_id` int(11) NOT NULL, `profissional_id` int(11) NOT NULL, `servico_id` int(11) NOT NULL, `valor_total` decimal(10,2) NOT NULL, `valor_recebido` decimal(10,2) DEFAULT 0.00, `comissao_valor` decimal(10,2) DEFAULT 0.00, `repasse_profissional` decimal(10,2) DEFAULT 0.00, `status` enum('pendente','parcial','pago','cancelado') NOT NULL DEFAULT 'pendente', `data_vencimento` date DEFAULT NULL, `data_pagamento` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `descricao` varchar(255) DEFAULT NULL, `forma_pagamento_id` int(11) DEFAULT NULL, `frequencia_id` int(11) DEFAULT NULL, `recorrente` tinyint(1) DEFAULT 0, `total_vezes` int(11) DEFAULT 0, `parcela_atual` int(11) DEFAULT 0, `juros` decimal(10,2) DEFAULT 0.00, `mora` decimal(10,2) DEFAULT 0.00, `observacoes` text DEFAULT NULL, `valor_juros` decimal(10,2) DEFAULT 0.00, `valor_mora` decimal(10,2) DEFAULT 0.00, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `agendamento_id` (`agendamento_id`), CONSTRAINT `contas_receber_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `contas_receber_ibfk_2` FOREIGN KEY (`agendamento_id`) REFERENCES `agendamentos` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contas_receber` -- LOCK TABLES `contas_receber` WRITE; /*!40000 ALTER TABLE `contas_receber` DISABLE KEYS */; INSERT INTO `contas_receber` VALUES (1,3,1,8,2,6,30.00,30.00,0.00,0.00,'pago','2026-05-25','2026-05-22','2026-05-21 22:42:41',NULL,NULL,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(3,3,3,8,2,6,30.00,0.00,0.00,0.00,'pago','2026-05-25','2026-05-23','2026-05-22 17:19:25',NULL,NULL,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(4,3,4,8,2,6,30.00,30.00,0.00,0.00,'pago','2026-05-26','2026-05-23','2026-05-23 11:23:32',NULL,1,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(5,3,5,8,2,6,30.00,0.00,0.00,0.00,'cancelado','2026-05-26',NULL,'2026-05-23 17:22:35',NULL,NULL,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(6,3,6,8,2,6,30.00,30.00,0.00,0.00,'pago','2026-05-26','2026-05-23','2026-05-23 17:24:02',NULL,1,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(7,3,7,8,2,6,30.00,0.00,0.00,0.00,'pago','2026-05-25','2026-05-23','2026-05-23 22:44:24',NULL,NULL,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00),(8,3,8,8,2,6,30.00,30.00,0.00,0.00,'pago','2026-05-25','2026-05-23','2026-05-23 23:45:07',NULL,1,NULL,0,0,0,0.00,0.00,NULL,0.00,0.00); /*!40000 ALTER TABLE `contas_receber` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `disparos` -- DROP TABLE IF EXISTS `disparos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `disparos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campanha_id` int(11) NOT NULL, `contato_id` int(11) NOT NULL, `status` enum('pendente','enviado','falhou') NOT NULL DEFAULT 'pendente', `enviado_em` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `campanha_id` (`campanha_id`), KEY `contato_id` (`contato_id`), CONSTRAINT `disparos_ibfk_1` FOREIGN KEY (`campanha_id`) REFERENCES `campanhas` (`id`) ON DELETE CASCADE, CONSTRAINT `disparos_ibfk_2` FOREIGN KEY (`contato_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `disparos` -- LOCK TABLES `disparos` WRITE; /*!40000 ALTER TABLE `disparos` DISABLE KEYS */; /*!40000 ALTER TABLE `disparos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `empresas` -- DROP TABLE IF EXISTS `empresas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `empresas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `plano_id` int(11) DEFAULT NULL, `nome` varchar(200) NOT NULL, `slug` varchar(100) NOT NULL, `documento` varchar(20) DEFAULT NULL, `telefone` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `endereco` text DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `cor_primaria` varchar(7) DEFAULT '#667eea', `cor_secundaria` varchar(7) DEFAULT '#764ba2', `ativo` tinyint(1) NOT NULL DEFAULT 1, `aprovado` tinyint(1) NOT NULL DEFAULT 0, `plano_valor` decimal(10,2) DEFAULT 0.00, `data_expiracao` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`), KEY `plano_id` (`plano_id`), CONSTRAINT `empresas_ibfk_1` FOREIGN KEY (`plano_id`) REFERENCES `planos` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `empresas` -- LOCK TABLES `empresas` WRITE; /*!40000 ALTER TABLE `empresas` DISABLE KEYS */; INSERT INTO `empresas` VALUES (1,3,'Barbearia Prime','barbearia-prime','00.000.000/0001-00','(11) 99999-9999','contato@barbeariaprime.com',NULL,NULL,'#667eea','#764ba2',1,1,0.00,NULL,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(2,1,'life','life-3ed7',NULL,'(21) 98820-4730','bruno@lifeprimeti.com.br',NULL,NULL,'#667eea','#764ba2',1,1,0.00,NULL,'2026-05-21 16:31:57','2026-05-21 16:31:57'),(3,2,'teste','teste-b70b','','(21) 97082-7226','teste@teste.com','','assets/img/empresas/foto_6a11e1c99916b.png','#667eea','#764ba2',1,1,0.00,NULL,'2026-05-21 16:51:07','2026-05-23 17:20:09'); /*!40000 ALTER TABLE `empresas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `formas_pagamento` -- DROP TABLE IF EXISTS `formas_pagamento`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `formas_pagamento` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `nome` varchar(100) NOT NULL, `taxa` decimal(5,2) DEFAULT 0.00, `ativo` tinyint(1) DEFAULT 1, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `formas_pagamento_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `formas_pagamento` -- LOCK TABLES `formas_pagamento` WRITE; /*!40000 ALTER TABLE `formas_pagamento` DISABLE KEYS */; INSERT INTO `formas_pagamento` VALUES (1,3,'Pix',0.00,1),(2,3,'Cartão de Débito',0.00,1),(3,3,'Cartão de Crédito',0.00,1); /*!40000 ALTER TABLE `formas_pagamento` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fornecedores` -- DROP TABLE IF EXISTS `fornecedores`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fornecedores` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `cpf_cnpj` varchar(20) DEFAULT NULL, `razao_social` varchar(200) DEFAULT NULL, `nome_fantasia` varchar(200) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `telefones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`telefones`)), `chave_pix_tipo` enum('telefone','cpf','aleatoria','cnpj','email') DEFAULT NULL, `chave_pix` varchar(255) DEFAULT NULL, `cep` varchar(10) DEFAULT NULL, `endereco` varchar(255) DEFAULT NULL, `numero` varchar(20) DEFAULT NULL, `complemento` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `estado` char(2) DEFAULT NULL, `ativo` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `cpf_cnpj` (`cpf_cnpj`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `fornecedores_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fornecedores` -- LOCK TABLES `fornecedores` WRITE; /*!40000 ALTER TABLE `fornecedores` DISABLE KEYS */; INSERT INTO `fornecedores` VALUES (1,3,'29.959.199/0001-61','','','','[]','cpf',NULL,'21555-500','Rua Doutor Gonçalves Lima','130','','Marechal Hermes','Rio de Janeiro','RJ',1,'2026-05-21 20:03:41','2026-05-21 20:03:41'); /*!40000 ALTER TABLE `fornecedores` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `frequencias` -- DROP TABLE IF EXISTS `frequencias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `frequencias` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `nome` varchar(100) NOT NULL, `dias` int(11) NOT NULL, `ativo` tinyint(1) DEFAULT 1, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `frequencias_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `frequencias` -- LOCK TABLES `frequencias` WRITE; /*!40000 ALTER TABLE `frequencias` DISABLE KEYS */; INSERT INTO `frequencias` VALUES (1,3,'Diário',1,1),(2,3,'Quinzenal',15,1),(3,3,'Mensal',30,1),(4,3,'Trimestral',90,1),(5,3,'Semestral',180,1),(6,3,'Anual',365,1); /*!40000 ALTER TABLE `frequencias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `grupos` -- DROP TABLE IF EXISTS `grupos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `grupos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `nome` varchar(100) NOT NULL, `descricao` text DEFAULT NULL, `permissoes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`permissoes`)), `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `grupos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grupos` -- LOCK TABLES `grupos` WRITE; /*!40000 ALTER TABLE `grupos` DISABLE KEYS */; INSERT INTO `grupos` VALUES (1,1,'Administrador','Acesso total ao sistema','[\"admin\",\"dashboard\",\"usuarios\",\"grupos\",\"profissionais\",\"servicos\",\"clientes\",\"agendamentos\",\"calendario\",\"relatorios\",\"configuracoes\",\"campanhas\",\"bloqueio_dias\",\"financeiro\"]','2026-05-21 16:11:25'),(2,1,'Profissional','Acesso a propria agenda e perfil','[\"dashboard\",\"meus_agendamentos\",\"meu_calendario\"]','2026-05-21 16:11:25'),(3,1,'Administrador','Acesso total','[\"admin\",\"dashboard\",\"usuarios\",\"grupos\",\"profissionais\",\"servicos\",\"clientes\",\"agendamentos\",\"calendario\",\"relatorios\",\"configuracoes\",\"campanhas\",\"bloqueio_dias\",\"financeiro\"]','2026-05-21 16:31:57'),(4,1,'Profissional','Acesso a agenda','[\"dashboard\",\"meus_agendamentos\",\"meu_calendario\"]','2026-05-21 16:31:57'),(5,3,'Administrador','Acesso total','[\"admin\",\"dashboard\",\"usuarios\",\"grupos\",\"profissionais\",\"servicos\",\"clientes\",\"agendamentos\",\"calendario\",\"relatorios\",\"configuracoes\",\"campanhas\",\"bloqueio_dias\",\"financeiro\"]','2026-05-21 16:51:09'),(6,3,'Profissional','Acesso a agenda','[\"dashboard\",\"meus_agendamentos\",\"meu_calendario\"]','2026-05-21 16:51:09'); /*!40000 ALTER TABLE `grupos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `grupos_disparo` -- DROP TABLE IF EXISTS `grupos_disparo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `grupos_disparo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `campanha_id` int(11) NOT NULL, `nome` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `campanha_id` (`campanha_id`), CONSTRAINT `grupos_disparo_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `grupos_disparo_ibfk_2` FOREIGN KEY (`campanha_id`) REFERENCES `campanhas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grupos_disparo` -- LOCK TABLES `grupos_disparo` WRITE; /*!40000 ALTER TABLE `grupos_disparo` DISABLE KEYS */; /*!40000 ALTER TABLE `grupos_disparo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `horarios_profissionais` -- DROP TABLE IF EXISTS `horarios_profissionais`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `horarios_profissionais` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profissional_id` int(11) NOT NULL, `dia_semana` tinyint(4) NOT NULL, `hora_inicio` time NOT NULL, `hora_fim` time NOT NULL, PRIMARY KEY (`id`), KEY `profissional_id` (`profissional_id`), CONSTRAINT `horarios_profissionais_ibfk_1` FOREIGN KEY (`profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `horarios_profissionais` -- LOCK TABLES `horarios_profissionais` WRITE; /*!40000 ALTER TABLE `horarios_profissionais` DISABLE KEYS */; INSERT INTO `horarios_profissionais` VALUES (1,1,1,'08:00:00','18:00:00'),(2,1,2,'08:00:00','18:00:00'),(3,2,1,'08:00:00','18:00:00'),(4,2,2,'08:00:00','18:00:00'); /*!40000 ALTER TABLE `horarios_profissionais` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `horarios_sistema` -- DROP TABLE IF EXISTS `horarios_sistema`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `horarios_sistema` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `dia_semana` tinyint(4) NOT NULL, `hora_inicio` time NOT NULL, `hora_fim` time NOT NULL, `intervalo` int(11) NOT NULL DEFAULT 60, PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `horarios_sistema_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `horarios_sistema` -- LOCK TABLES `horarios_sistema` WRITE; /*!40000 ALTER TABLE `horarios_sistema` DISABLE KEYS */; INSERT INTO `horarios_sistema` VALUES (1,1,1,'08:00:00','18:00:00',60),(2,1,2,'08:00:00','18:00:00',60),(3,1,3,'08:00:00','18:00:00',60),(4,1,4,'08:00:00','18:00:00',60),(5,1,5,'08:00:00','18:00:00',60),(6,1,6,'08:00:00','13:00:00',60); /*!40000 ALTER TABLE `horarios_sistema` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ia_prompts` -- DROP TABLE IF EXISTS `ia_prompts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ia_prompts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `titulo` varchar(200) NOT NULL, `prompt_texto` text NOT NULL, `ia_provedor` enum('openai','gemini','claude') NOT NULL DEFAULT 'openai', `temperatura` decimal(3,2) DEFAULT 0.70, `max_tokens` int(11) DEFAULT 2048, `ativo` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `ia_prompts_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ia_prompts` -- LOCK TABLES `ia_prompts` WRITE; /*!40000 ALTER TABLE `ia_prompts` DISABLE KEYS */; /*!40000 ALTER TABLE `ia_prompts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `lembretes_config` -- DROP TABLE IF EXISTS `lembretes_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lembretes_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `tipo` enum('minutos','horas','dias','meses') NOT NULL DEFAULT 'horas', `valor` int(11) NOT NULL DEFAULT 1, `metodo` enum('email','whatsapp','digigo') NOT NULL DEFAULT 'email', `ativo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `lembretes_config_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `lembretes_config` -- LOCK TABLES `lembretes_config` WRITE; /*!40000 ALTER TABLE `lembretes_config` DISABLE KEYS */; /*!40000 ALTER TABLE `lembretes_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pagamentos` -- DROP TABLE IF EXISTS `pagamentos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pagamentos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `agendamento_id` int(11) NOT NULL, `cliente_id` int(11) NOT NULL, `valor` decimal(10,2) NOT NULL, `taxa` decimal(10,2) DEFAULT 0.00, `metodo` enum('dinheiro','pix','cartao','boleto','asaas','mercadopago') NOT NULL DEFAULT 'pix', `status` enum('pendente','aprovado','recusado','cancelado') NOT NULL DEFAULT 'pendente', `transacao_id` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `agendamento_id` (`agendamento_id`), KEY `cliente_id` (`cliente_id`), CONSTRAINT `pagamentos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `pagamentos_ibfk_2` FOREIGN KEY (`agendamento_id`) REFERENCES `agendamentos` (`id`) ON DELETE CASCADE, CONSTRAINT `pagamentos_ibfk_3` FOREIGN KEY (`cliente_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pagamentos` -- LOCK TABLES `pagamentos` WRITE; /*!40000 ALTER TABLE `pagamentos` DISABLE KEYS */; /*!40000 ALTER TABLE `pagamentos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usuario_id` int(11) NOT NULL, `token` varchar(100) NOT NULL, `usado` tinyint(1) NOT NULL DEFAULT 0, `expires_at` datetime NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `token` (`token`), KEY `usuario_id` (`usuario_id`), CONSTRAINT `password_reset_tokens_ibfk_1` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `planos` -- DROP TABLE IF EXISTS `planos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `planos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nome` varchar(100) NOT NULL, `valor` decimal(10,2) NOT NULL DEFAULT 0.00, `recorencia` enum('mensal','trimestral','semestral','anual') NOT NULL DEFAULT 'mensal', `limite_profissionais` int(11) DEFAULT 0, `limite_clientes` int(11) DEFAULT 0, `recursos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`recursos`)), `ativo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `whatsapp_available` tinyint(1) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `planos` -- LOCK TABLES `planos` WRITE; /*!40000 ALTER TABLE `planos` DISABLE KEYS */; INSERT INTO `planos` VALUES (1,'Gratis',0.00,'mensal',2,0,'[\"dashboard\",\"agendamentos\",\"clientes\"]',1,'2026-05-21 16:11:25',1),(2,'Basico',49.90,'mensal',5,0,'[\"dashboard\",\"agendamentos\",\"clientes\",\"profissionais\",\"servicos\",\"relatorios\",\"financeiro\",\"campanhas\",\"whatsapp\",\"pagamentos\",\"api\",\"multiusuario\"]',1,'2026-05-21 16:11:25',1),(3,'Profissional',99.90,'mensal',15,0,'[\"dashboard\",\"agendamentos\",\"clientes\",\"profissionais\",\"servicos\",\"relatorios\",\"campanhas\",\"whatsapp\",\"pagamentos\"]',1,'2026-05-21 16:11:25',1),(4,'Enterprise',199.90,'mensal',999,0,'[\"dashboard\",\"agendamentos\",\"clientes\",\"profissionais\",\"servicos\",\"relatorios\",\"financeiro\",\"campanhas\",\"whatsapp\",\"pagamentos\",\"api\",\"multiusuario\"]',1,'2026-05-21 16:11:25',1); /*!40000 ALTER TABLE `planos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `profissionais` -- DROP TABLE IF EXISTS `profissionais`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profissionais` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `usuario_id` int(11) NOT NULL, `foto` varchar(255) DEFAULT NULL, `especialidade` varchar(255) DEFAULT NULL, `descricao` text DEFAULT NULL, `cor_calendario` varchar(7) DEFAULT '#667eea', `comissao_tipo` enum('percentual','fixo') NOT NULL DEFAULT 'percentual', `comissao_valor` decimal(10,2) DEFAULT 0.00, `ativo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `cargo_id` int(11) DEFAULT NULL, `mostrar` tinyint(1) DEFAULT 1, `data_nascimento` date DEFAULT NULL, `cpf` varchar(14) DEFAULT NULL, `chave_pix_tipo` enum('telefone','cpf','aleatoria','cnpj','email') DEFAULT NULL, `chave_pix` varchar(255) DEFAULT NULL, `cep` varchar(10) DEFAULT NULL, `endereco` varchar(255) DEFAULT NULL, `numero` varchar(20) DEFAULT NULL, `complemento` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `estado` char(2) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `usuario_id` (`usuario_id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `profissionais_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `profissionais_ibfk_2` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `profissionais` -- LOCK TABLES `profissionais` WRITE; /*!40000 ALTER TABLE `profissionais` DISABLE KEYS */; INSERT INTO `profissionais` VALUES (1,1,6,NULL,'life','teste','#667eea','percentual',5.00,1,'2026-05-21 19:43:44',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,3,7,NULL,'','','#667eea','percentual',10.00,1,'2026-05-21 20:57:25',1,1,'1979-05-05','05314281767','cpf','05314281767','21555500','Doutor Gonçalves Lima','130','','Mal Hermes','RIO DE JANEIRO','RJ'); /*!40000 ALTER TABLE `profissionais` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `servicos` -- DROP TABLE IF EXISTS `servicos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `servicos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `nome` varchar(150) NOT NULL, `descricao` text DEFAULT NULL, `preco` decimal(10,2) NOT NULL, `duracao` int(11) NOT NULL COMMENT 'duracao em minutos', `foto` varchar(255) DEFAULT NULL, `comissao_tipo` enum('percentual','fixo') NOT NULL DEFAULT 'percentual', `comissao_valor` decimal(10,2) DEFAULT 0.00, `ativo` tinyint(1) NOT NULL DEFAULT 1, `mostrar_site` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `servicos_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `servicos` -- LOCK TABLES `servicos` WRITE; /*!40000 ALTER TABLE `servicos` DISABLE KEYS */; INSERT INTO `servicos` VALUES (1,1,'Corte Masculino','Corte tradicional com tesoura e maquina',45.00,40,NULL,'percentual',50.00,1,1,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(2,1,'Barba','Aparacao e modelagem de barba',30.00,20,NULL,'percentual',50.00,1,1,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(3,1,'Corte + Barba','Combo corte masculino + barba',65.00,60,NULL,'percentual',50.00,1,1,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(4,1,'Hidratacao','Hidratacao capilar profunda',50.00,30,NULL,'fixo',20.00,1,1,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(5,1,'Sobrancelha','Design de sobrancelha',20.00,15,NULL,'percentual',40.00,1,1,'2026-05-21 16:11:25','2026-05-21 16:11:25'),(6,3,'barba','barba',30.00,20,NULL,'percentual',0.00,1,1,'2026-05-21 21:02:08','2026-05-21 21:02:08'); /*!40000 ALTER TABLE `servicos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `servicos_profissionais` -- DROP TABLE IF EXISTS `servicos_profissionais`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `servicos_profissionais` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profissional_id` int(11) NOT NULL, `servico_id` int(11) NOT NULL, `preco` decimal(10,2) DEFAULT NULL, `duracao` int(11) DEFAULT NULL, `comissao_tipo` enum('percentual','fixo') DEFAULT NULL, `comissao_valor` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_prof_serv` (`profissional_id`,`servico_id`), KEY `servico_id` (`servico_id`), CONSTRAINT `servicos_profissionais_ibfk_1` FOREIGN KEY (`profissional_id`) REFERENCES `profissionais` (`id`) ON DELETE CASCADE, CONSTRAINT `servicos_profissionais_ibfk_2` FOREIGN KEY (`servico_id`) REFERENCES `servicos` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `servicos_profissionais` -- LOCK TABLES `servicos_profissionais` WRITE; /*!40000 ALTER TABLE `servicos_profissionais` DISABLE KEYS */; INSERT INTO `servicos_profissionais` VALUES (1,1,1,NULL,NULL,'percentual',NULL),(2,2,6,NULL,NULL,'percentual',NULL); /*!40000 ALTER TABLE `servicos_profissionais` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suporte_respostas` -- DROP TABLE IF EXISTS `suporte_respostas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `suporte_respostas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ticket_id` int(11) NOT NULL, `usuario_id` int(11) NOT NULL, `mensagem` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `ticket_id` (`ticket_id`), KEY `usuario_id` (`usuario_id`), CONSTRAINT `suporte_respostas_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `suporte_tickets` (`id`) ON DELETE CASCADE, CONSTRAINT `suporte_respostas_ibfk_2` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suporte_respostas` -- LOCK TABLES `suporte_respostas` WRITE; /*!40000 ALTER TABLE `suporte_respostas` DISABLE KEYS */; INSERT INTO `suporte_respostas` VALUES (1,1,4,'esse','2026-05-21 21:57:38'),(4,3,4,'sgola','2026-05-21 22:03:10'),(5,3,4,'resp','2026-05-21 22:05:12'),(6,3,5,'ta','2026-05-21 22:05:57'),(7,4,5,'teste','2026-05-21 22:09:27'),(8,5,4,'entendi','2026-05-21 22:09:42'),(9,4,5,'wntendi','2026-05-21 22:19:14'); /*!40000 ALTER TABLE `suporte_respostas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suporte_tickets` -- DROP TABLE IF EXISTS `suporte_tickets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `suporte_tickets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `usuario_id` int(11) NOT NULL, `titulo` varchar(200) NOT NULL, `mensagem` text NOT NULL, `status` enum('aberto','fechado') NOT NULL DEFAULT 'aberto', `respondido` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), KEY `usuario_id` (`usuario_id`), CONSTRAINT `suporte_tickets_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `suporte_tickets_ibfk_2` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suporte_tickets` -- LOCK TABLES `suporte_tickets` WRITE; /*!40000 ALTER TABLE `suporte_tickets` DISABLE KEYS */; INSERT INTO `suporte_tickets` VALUES (1,3,4,'teste','teste','fechado',0,'2026-05-21 21:07:52','2026-05-21 21:59:47'),(3,3,4,'oi','yes','fechado',1,'2026-05-21 22:02:53','2026-05-21 22:07:50'),(4,1,5,'tfr','onj','aberto',1,'2026-05-21 22:08:24','2026-05-21 22:09:27'),(5,3,4,'juh','lkkj','fechado',0,'2026-05-21 22:09:03','2026-05-25 00:34:26'); /*!40000 ALTER TABLE `suporte_tickets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usuarios` -- DROP TABLE IF EXISTS `usuarios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usuarios` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `grupo_id` int(11) DEFAULT NULL, `nome` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `telefone` varchar(20) DEFAULT NULL, `senha` varchar(255) NOT NULL, `tipo` enum('super_admin','admin','profissional','cliente') NOT NULL DEFAULT 'cliente', `foto` varchar(255) DEFAULT NULL, `ativo` tinyint(1) NOT NULL DEFAULT 1, `aprovado` tinyint(1) NOT NULL DEFAULT 0, `hash_link` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `whatsapp` varchar(20) DEFAULT NULL, `cep` varchar(9) DEFAULT NULL, `endereco` varchar(255) DEFAULT NULL, `numero` varchar(20) DEFAULT NULL, `complemento` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `estado` char(2) DEFAULT NULL, `data_nascimento` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `hash_link` (`hash_link`), KEY `empresa_id` (`empresa_id`), KEY `grupo_id` (`grupo_id`), CONSTRAINT `usuarios_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE, CONSTRAINT `usuarios_ibfk_2` FOREIGN KEY (`grupo_id`) REFERENCES `grupos` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usuarios` -- LOCK TABLES `usuarios` WRITE; /*!40000 ALTER TABLE `usuarios` DISABLE KEYS */; INSERT INTO `usuarios` VALUES (1,1,1,'Administrador','admin@barbearia.com','(11) 99999-9999','$2y$10$gG6oVng/8fU/tycT04ETMuVsVyw5LNMkgs9R9J0ARGiBiQEaCz9Jq','admin',NULL,1,1,NULL,'2026-05-21 16:11:25','2026-05-21 16:11:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,2,NULL,'bruno silvares','bruno@lifeprimeti.com.br','(21) 98820-4730','$2y$10$cAxWgYoVE92gQnEPWcVC3.rNsNzcpgl.3WLZ8P4SADXNM7krxeOy6','admin',NULL,1,1,'3768f6bdcbfbee6d93ba628afea3af71','2026-05-21 16:31:57','2026-05-22 17:46:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,NULL,'bruno silvares','bruno@com.br','(21) 98820-4730','$2y$10$DILRgdB0Btvgxflz1GyClOI49REOvd1Kesy.kcz1140tCrdYJhV4C','cliente',NULL,1,0,NULL,'2026-05-21 16:37:37','2026-05-21 16:37:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,3,5,'life teste','teste@teste.com','(21) 97082-7226','$2y$10$fVg09uezhrfYOgzZTRezdu0FmEyQbgYZ.pG2jbxGUlAc2ea0dP1dO','admin',NULL,1,1,'da812486fdc1fb6a5b81de0db0e881a5','2026-05-21 16:51:09','2026-05-21 16:51:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,'Super Admin','super@barbearia.com','(11) 99999-9999','$2y$10$jvJPvDEtHA7ywA84KpQUqOq.NpplH2yjGpXAMiqSxmtRo6Jmx3QK6','super_admin',NULL,1,1,NULL,'2026-05-21 17:05:27','2026-05-21 17:05:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,NULL,'life','life@life.com','(21) 99999-9999','$2y$10$EluEQyuI0PeMquMax67AB.pAiS.16NQbTSJhc2t5NDkV252WL53jq','profissional','assets/img/fotos/foto_6a0f607012391.png',1,0,NULL,'2026-05-21 19:43:44','2026-05-21 19:44:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,3,NULL,'life prime ti','bruno@lifeprimeti.com.br','(21) 97082-7226','$2y$10$XcMmmWr527cTEUiO5La0cexiLTQ1z66M3LQZnI9.Z9aENKrdt5Z4y','profissional','assets/img/fotos/foto_6a0f71b5d9222.png',1,0,NULL,'2026-05-21 20:57:25','2026-05-21 20:57:25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,3,NULL,'life','ttt@ttt.com','(21) 98820-4736','$2y$10$5p7FG01V.s2R49XDJaVSLeKFB67F4M..D0/RTGpm0QrhVIkfcG242','cliente',NULL,1,0,NULL,'2026-05-21 22:42:20','2026-05-21 22:42:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `usuarios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `whatsapp_config` -- DROP TABLE IF EXISTS `whatsapp_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `whatsapp_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `empresa_id` int(11) NOT NULL, `dispositivo_nome` varchar(100) DEFAULT NULL, `dispositivo_id` varchar(255) DEFAULT NULL, `qr_code` text DEFAULT NULL, `status` enum('desconectado','conectando','conectado') NOT NULL DEFAULT 'desconectado', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `empresa_id` (`empresa_id`), CONSTRAINT `whatsapp_config_ibfk_1` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `whatsapp_config` -- LOCK TABLES `whatsapp_config` WRITE; /*!40000 ALTER TABLE `whatsapp_config` DISABLE KEYS */; /*!40000 ALTER TABLE `whatsapp_config` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-05-24 22:17:07