-- MySQL dump 10.13  Distrib 8.4.11, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: rhodia
-- ------------------------------------------------------
-- Server version	8.4.11

/*!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 */;
/*!50503 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 `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_08_20_000000_create_projects_table',2),(5,'2026_08_20_000001_create_project_phases_table',2),(6,'2026_08_20_000002_create_requirement_questions_table',2),(7,'2026_08_20_000003_create_project_decisions_table',2),(8,'2026_08_24_000000_add_role_to_users_table',3),(9,'2026_08_24_000001_add_assignee_to_requirement_questions_table',3),(10,'2026_08_24_000002_add_is_active_to_users_table',4),(11,'2026_08_24_000003_add_fluig_number_to_projects_table',5);
/*!40000 ALTER TABLE `migrations` 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) 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 `project_decisions`
--

DROP TABLE IF EXISTS `project_decisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_decisions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `decided_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `decided_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_decisions_project_id_decided_at_index` (`project_id`,`decided_at`),
  CONSTRAINT `project_decisions_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`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 `project_decisions`
--

LOCK TABLES `project_decisions` WRITE;
/*!40000 ALTER TABLE `project_decisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_decisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project_phases`
--

DROP TABLE IF EXISTS `project_phases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project_phases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` smallint unsigned NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_phases_project_id_slug_unique` (`project_id`,`slug`),
  UNIQUE KEY `project_phases_project_id_position_unique` (`project_id`,`position`),
  KEY `project_phases_project_id_status_index` (`project_id`,`status`),
  CONSTRAINT `project_phases_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`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 `project_phases`
--

LOCK TABLES `project_phases` WRITE;
/*!40000 ALTER TABLE `project_phases` DISABLE KEYS */;
INSERT INTO `project_phases` VALUES (1,1,'Discovery','discovery',1,'in_progress','2026-08-24 14:04:10',NULL,'2026-08-20 17:17:19','2026-08-24 14:04:10'),(2,1,'Requisitos','requisitos',2,'pending',NULL,NULL,'2026-08-20 17:17:19','2026-08-20 17:17:19'),(3,1,'Modelagem','modelagem',3,'pending',NULL,NULL,'2026-08-20 17:17:19','2026-08-20 17:17:19'),(4,1,'MVP','mvp',4,'pending',NULL,NULL,'2026-08-20 17:17:19','2026-08-20 17:17:19'),(5,1,'Homologação','homologacao',5,'pending',NULL,NULL,'2026-08-20 17:17:19','2026-08-20 17:17:19'),(6,1,'Produção','producao',6,'pending',NULL,NULL,'2026-08-20 17:17:19','2026-08-20 17:17:19');
/*!40000 ALTER TABLE `project_phases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fluig_number` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `current_phase` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `objective` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_request` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `interpretation` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `projects_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects`
--

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
INSERT INTO `projects` VALUES (1,'One Check — Rhodia','Rhodia','250857','Em desenvolvimento','Discovery','Disponibilizar uma ferramenta centralizada e parametrizável para geração de checklists operacionais adequados às características de cada operação.','Proposta de Projeto: Desenvolvimento de Aplicação Web para Gestão de Check-list Operacional RHODIA\n\nEm função do volume recorrente de reclamações registradas na operação On Site da Rhodia, identificou-se a necessidade de aprimorar o processo de geração e controle dos check-lists operacionais, visando aumentar a padronização, reduzir falhas e melhorar a qualidade das atividades executadas.\n\nPara atender a essa demanda, propõe-se o desenvolvimento de uma aplicação web que permita ao time de Planning da Rhodia realizar o upload da programação operacional. Com base nas informações cadastradas, especialmente na combinação entre Cliente e Item, o sistema será responsável por gerar automaticamente check-lists personalizados para cada cenário operacional.\n\nA solução deverá contemplar as seguintes funcionalidades:\n\nUpload da programação operacional pelo time de Planning;\nGeração automática de check-lists personalizados com base nas regras definidas para cada combinação de Cliente e Item;\nInclusão de imagens ilustrativas e orientações específicas em cada check-list;\nEmissão dos check-lists em formato PDF para impressão e utilização na operação;\nAcesso administrativo para usuários-chave (Key Users), permitindo a manutenção e configuração das regras de negócio;\nGestão das perguntas, critérios e imagens associadas a cada cenário operacional, sem necessidade de desenvolvimento adicional.\n\nObjetivo do Projeto:\n\nDisponibilizar uma ferramenta centralizada e parametrizável que garanta a emissão de check-lists adequados às características de cada operação, aumentando a conformidade dos processos, reduzindo a incidência de erros operacionais e contribuindo para a melhoria contínua da qualidade dos serviços prestados na operação On Site da Rhodia.','O One Check permitirá ao time de Planning importar a programação operacional e, com base nas regras configuradas para cada cenário, gerar automaticamente checklists personalizados contendo perguntas, critérios, orientações e imagens.\n\nA identificação do cenário partirá inicialmente da combinação Cliente + Item, mas essa regra ainda deve ser validada durante o Discovery para verificar se existem outros fatores, como tipo de operação, embalagem ou outras características.\n\nOs Key Users poderão administrar as regras e o conteúdo dos checklists sem necessidade de alteração de código.','2026-08-20 17:17:19','2026-08-24 14:04:10');
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requirement_questions`
--

DROP TABLE IF EXISTS `requirement_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `requirement_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `assigned_to_user_id` bigint unsigned DEFAULT NULL,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `context` text COLLATE utf8mb4_unicode_ci,
  `answer` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `answered_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answered_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `requirement_questions_project_id_status_index` (`project_id`,`status`),
  KEY `requirement_questions_assigned_to_user_id_status_index` (`assigned_to_user_id`,`status`),
  CONSTRAINT `requirement_questions_assigned_to_user_id_foreign` FOREIGN KEY (`assigned_to_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requirement_questions_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requirement_questions`
--

LOCK TABLES `requirement_questions` WRITE;
/*!40000 ALTER TABLE `requirement_questions` DISABLE KEYS */;
INSERT INTO `requirement_questions` VALUES (7,1,3,'O checklist é definido somente pela combinação Cliente + Item ou existem outros fatores que alteram seu conteúdo?','Precisamos identificar corretamente quais informações determinam qual checklist deve ser gerado.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(8,1,3,'Qual é o formato atual da programação enviada pelo Planning e quais campos ela possui?','Isso definirá a estrutura da importação e os dados disponíveis para identificar cada cenário operacional.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(9,1,3,'Existe hoje um checklist utilizado na operação que possamos usar como referência?','Precisamos entender a estrutura atual, perguntas, orientações, imagens e formato utilizado pela operação.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(10,1,3,'Quando não existir uma regra ou checklist cadastrado para determinada programação, o que o sistema deve fazer?','Precisamos definir o tratamento de exceções antes da geração dos checklists.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(11,1,3,'Quem será responsável por criar e manter as regras, perguntas, orientações e imagens dos checklists?','Isso ajudará a definir os Key Users e as permissões administrativas do sistema.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(12,1,3,'Como os checklists serão utilizados na operação inicialmente?','Precisamos confirmar se o escopo inicial será apenas geração de PDF/impressão ou se haverá consulta ou preenchimento digital.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21'),(13,1,3,'Existe necessidade de manter histórico das versões dos checklists e identificar qual versão foi utilizada em cada programação?','Isso define a necessidade de versionamento e rastreabilidade desde a modelagem inicial.',NULL,'open',NULL,NULL,'2026-08-24 13:23:21','2026-08-24 13:23:21');
/*!40000 ALTER TABLE `requirement_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'viewer',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_index` (`role`),
  KEY `users_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Ricardo Medeiros','ricardo.medeiros@katoennatie.com','2026-08-24 11:41:01','$2y$12$GF.rifP0aPAGUlOXJTs16.ykmJTOPaMdkfeTpGy7jyBv9EaPncrLW','admin',1,NULL,'2026-08-20 16:49:25','2026-08-24 11:41:01'),(3,'David Gomes','david.gomes@katoennatie.com.br','2026-08-24 11:41:01','$2y$12$/wydzFgQtHtH.pvv34S1SOAE4pKS9lztfTEQ.pyEo.uX2uN4V7gJS','collaborator',1,NULL,'2026-08-24 11:41:02','2026-08-24 13:05:01'),(4,'Reginaldo Rodrigues','reginaldo.rodrigues@katoennatie.com','2026-08-24 11:41:02','$2y$12$NnZTIj4ay9jpSpKFynpn9OstSW6qeqiMD3rhhjddLgVhrZeu83NmW','collaborator',1,'O56bZxqVv7mQAQnROnnFqKOQfTez1GIBH0WWx9X5XHS0ou30N2GYG6VgjeRy','2026-08-24 11:41:02','2026-08-24 13:06:29'),(5,'Marcelo Martins','marcelo.martins@katoennatie.com','2026-08-24 11:41:02','$2y$12$FC2Nva4sk6YI4vQyGhUExeP59lcwMF1vB29aPfkAtyQ3rq8Ihw4JW','viewer',1,NULL,'2026-08-24 11:41:02','2026-08-24 11:41:02');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'rhodia'
--

--
-- Dumping routines for database 'rhodia'
--
/*!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-08-24 17:59:09