create table roles
(
    id serial primary key not null,
    role_name varchar(50) not null
);

create table users
(
    id serial primary key not null,
    fname varchar(100) not null,
    lname varchar(100) not null,
    login varchar(100) not null,
    password varchar(100) not null,
    role int not null references roles (id)
);