create table users
(
    id         bigint generated by default as identity primary key,
    username   varchar(255) not null unique,
    login      varchar(255) not null unique,
    password   text         not null,
    role_id    bigint       not null references roles (id) on update cascade on delete restrict,
    created_at timestamptz  not null default now(),
    updated_at timestamptz  not null default now()
);
