pierrelf.com
this repo has no description
1CREATE TABLE IF NOT EXISTS push_subscriptions (
2 id TEXT PRIMARY KEY,
3 user_id TEXT NOT NULL,
4 endpoint TEXT NOT NULL UNIQUE,
5 p256dh TEXT NOT NULL,
6 auth TEXT NOT NULL,
7 created_at TEXT NOT NULL DEFAULT (datetime('now'))
8);
9
10CREATE TABLE IF NOT EXISTS vapid_keys (
11 id INTEGER PRIMARY KEY CHECK (id = 1),
12 private_key_pem TEXT NOT NULL,
13 public_key_base64url TEXT NOT NULL
14);
15
16ALTER TABLE user_stats ADD COLUMN reminder_enabled INTEGER DEFAULT 0;
17ALTER TABLE user_stats ADD COLUMN reminder_time TEXT DEFAULT '20:00';
18ALTER TABLE user_stats ADD COLUMN last_notified_date TEXT;