migrations/20250829220738_vapid_keys.sql


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

create table vapid_signing_key (
    key blob
        not null
);

create unique index vapid_signing_key_singleton
    on vapid_signing_key (0);

create table vapid_key (
    changed_at text
        not null,
    changed_sequence bigint
        not null
);

create unique index vapid_key_singleton
    on vapid_key (0);