create table roles
(
    id   bigint generated by default as identity primary key,
    name varchar(255) not null unique
);

insert into roles (id, name)
values (1, 'admin'),
       (2, 'security'),
       (3, 'audit');

select setval(pg_get_serial_sequence('roles', 'id'), (select max(id) from roles), true);
