drop table if exists api_keys;

create table api_keys (
    username                           varchar(50) not null,
    api_key                            varchar(36) not null,
    constraint fk_api_keys_users foreign key(username) references users(username)
);

insert into api_keys (username, api_key) values ('administrator', '2fad1f99-6052-475b-a6a0-3bf445203585');

insert into api_keys (username, api_key) values ('optisan', '6b7212f2-38cf-470d-a2de-f89d27fedaf2');

insert into api_keys (username, api_key) values ('zaraza', '3e0a720c-80b4-4d75-be38-e8ced278a692');

insert into api_keys (username, api_key) values ('fingir', '517cb0eb-379f-449e-94da-6a824f30ecd3')