--
-- Host: localhost    Database: hci-db-system
-- ------------------------------------------------------


--
-- Table structure for table `Permissions`
--

CREATE TABLE `Permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `assignedTo` text NOT NULL,
  `dataCreated` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Permissions`
--

INSERT INTO `Permissions` VALUES (1,'User Manager','','2024-01-06 12:09:52'),(2,'Dashboard','','2024-01-06 12:22:18');

--
-- Table structure for table `Roles`
--

CREATE TABLE `Roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) NOT NULL,
  `role_users` text,
  `role_ability` json DEFAULT NULL,
  `createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_name` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Roles`
--

INSERT INTO `Roles` VALUES (3,'Comercial',NULL,'[{\"name\": \"User Manager\", \"read\": true, \"write\": true, \"create\": true}, {\"name\": \"Dashboard\", \"read\": true, \"write\": true, \"create\": true}]','2024-01-06 19:30:52'),(11,'admin',NULL,'[{\"name\": \"User Manager\", \"read\": true, \"write\": true, \"create\": true}, {\"name\": \"Dashboard\", \"read\": true, \"write\": true, \"create\": true}]','2024-01-07 23:24:37'),(16,'Válvulas',NULL,'[]','2024-01-11 00:05:09'),(17,'Tubos',NULL,'[{\"name\": \"User Manager\", \"read\": true, \"write\": true, \"create\": true}, {\"name\": \"Dashboard\", \"read\": true, \"write\": true, \"create\": true}]','2024-01-11 00:09:53'),(18,'SAC',NULL,'[]','2024-01-11 00:09:59'),(19,'Recebimento',NULL,'[]','2024-01-11 00:10:18'),(20,'Logística',NULL,'[]','2024-01-11 00:10:26'),(21,'Industrial',NULL,'[]','2024-01-11 00:10:34'),(22,'Financeiro',NULL,'[]','2024-01-11 00:10:40'),(23,'Qualidade',NULL,'[]','2024-01-11 00:10:44'),(24,'Compras Nacionais',NULL,'[]','2024-01-11 00:10:50');


