migrations/20250725023155_push_notification.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

create table subscription (
    id text
        not null
        primary key,
    user text
        not null
        references user (id),
    endpoint text
        unique
        not null,
    key_p256dh text
        not null,
    key_auth text
        not null
);