--- notification-inbox

alter table notifications add updated_at datetimeoffset;
alter table notifications add resolved bit;
update notifications set resolved = 1;

create table notification_inboxes (
    user_id bigint primary key references users(id),
    unresolved bigint not null,

    created_at datetimeoffset not null,
    updated_at datetimeoffset not null
);

create index notifications_viol_ix on notifications(target_violation_id);
