pierrelf.com
this repo has no description
1CREATE TABLE IF NOT EXISTS progress (
2 user_id TEXT NOT NULL REFERENCES users(id),
3 topic_id TEXT NOT NULL,
4 lesson_id TEXT NOT NULL,
5 completed INTEGER NOT NULL DEFAULT 0,
6 best_score INTEGER NOT NULL DEFAULT 0,
7 completed_at TEXT,
8 PRIMARY KEY (user_id, topic_id, lesson_id)
9);
10
11CREATE TABLE IF NOT EXISTS user_stats (
12 user_id TEXT PRIMARY KEY REFERENCES users(id),
13 xp INTEGER NOT NULL DEFAULT 0,
14 streak_days INTEGER NOT NULL DEFAULT 0,
15 last_active_date TEXT,
16 hearts INTEGER NOT NULL DEFAULT 5
17);