create table users(
    id varchar(100) not null,
    password varchar(100) not null,
    name varchar(255) not null,
    email varchar(255) not null,
    type varchar(25) not null,

    PRIMARY KEY(id)
);

create table roles(
   id varchar(100) not null,
   user_id varchar(100) not null,
   role_name varchar(100) not null,

   PRIMARY KEY(id)
)