puffpastry-server/migrations/2024-10-07-200931_create_votes/up.sql

-- Your SQL goes here
create table issue_votes (
    id bigserial primary key,
    positive boolean,
    issue_id int not null references issues (id),
    user_id bigint not null,
    unique (issue_id, user_id)
);