text: 
  CREATE DATABASE `employee_cms_db`;
  
  USE `employee_cms_db`;
  
  CREATE TABLE `employee_cms_db`.`departments` (
    `id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(30) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `id_UNIQUE` (`id`)
  );
  
  CREATE TABLE `employee_cms_db`.`employees` (
    `id` int NOT NULL AUTO_INCREMENT,
    `first_name` varchar(30) DEFAULT NULL,
    `last_name` varchar(30) DEFAULT NULL,
    `role_id` int DEFAULT NULL,
    `manager_id` int DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `id_UNIQUE` (`id`)
  );
  
  CREATE TABLE `employee_cms_db`.`roles` (
    `id` int NOT NULL AUTO_INCREMENT,
    `title` varchar(30) DEFAULT NULL,
    `salary` decimal(10,0) DEFAULT NULL,
    `department_id` int DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `id_UNIQUE` (`id`)
  );