18 lines
509 B
SQL
18 lines
509 B
SQL
|
ALTER TABLE users ADD COLUMN notification_prefs TEXT NOT NULL
|
||
|
|
DEFAULT '{"blocking_questions":true,"questions":false,"reports":false,"errors":false,"rate_limits":false}';
|
||
|
|
|
||
|
|
CREATE TABLE vapid_keys (
|
||
|
|
id INTEGER PRIMARY KEY CHECK (id = 1),
|
||
|
|
public_key TEXT NOT NULL,
|
||
|
|
private_key TEXT NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE push_subscriptions (
|
||
|
|
endpoint TEXT PRIMARY KEY,
|
||
|
|
user_login TEXT NOT NULL REFERENCES users(login),
|
||
|
|
p256dh TEXT NOT NULL,
|
||
|
|
auth TEXT NOT NULL,
|
||
|
|
subscriber TEXT NOT NULL,
|
||
|
|
created_at TEXT NOT NULL
|
||
|
|
);
|