migrations/20251028173914_pem_vapid_keys.sql


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

drop table vapid_signing_key;

create table vapid_signing_key (
    key text
        not null
);

create unique index vapid_signing_key_singleton
    on vapid_signing_key (0);

-- Whatever key we had, if any, was just destroyed by dropping the table. Delete the metadata
-- as well so that the server will issue a new one.
delete
from
    vapid_key;