CREATE TABLE roles(
    id INT PRIMARY KEY AUTO_INCREMENT,
    rol_name VARCHAR(30) NOT NULL UNIQUE,
    rol_status TINYINT(1) NOT NULL
)ENGINE=INNODB;

CREATE TABLE users(
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_name VARCHAR(20) NOT NULL UNIQUE,
    status_user TINYINT(1) NOT NULL,
    rol_id INT NOT NULL,
    CONSTRAINT fk_users_roles FOREIGN KEY(rol_id) REFERENCES roles(id)
);