api/migrations/003_create_lesson_state.sql at push-notifications

pierrelf.com / ayos

fork atom

this repo has no description

fork atom

ayos / api / migrations / 003_create_lesson_state.sql

at push-notifications 11 lines 417 B view raw

wrap content

pierrelf.com Save lesson progress at each task for mid-lesson resume 3w ago

61abbd26

 1CREATE TABLE IF NOT EXISTS lesson_state (
 2    user_id    TEXT    NOT NULL,
 3    topic_id   TEXT    NOT NULL,
 4    lesson_id  TEXT    NOT NULL,
 5    current_index  INTEGER NOT NULL DEFAULT 0,
 6    hearts         INTEGER NOT NULL DEFAULT 5,
 7    correct_count  INTEGER NOT NULL DEFAULT 0,
 8    updated_at     TEXT    NOT NULL,
 9    PRIMARY KEY (user_id, topic_id, lesson_id),
10    FOREIGN KEY (user_id) REFERENCES users(id)
11);