migrations/20250724_subscription.sql


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

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,
    expiration_time text,
);