diff options
author | Grail Finder <wohilas@gmail.com> | 2025-04-05 15:04:15 +0300 |
---|---|---|
committer | Grail Finder <wohilas@gmail.com> | 2025-04-05 15:04:15 +0300 |
commit | 8bc7544e8933d64abc2610a265f37fe13b5767d5 (patch) | |
tree | ddcb10ff89723d0c490f6c1e781928ae89666b25 /internal/database/migrations/002_quiz_schema.up.sql | |
parent | 287da7acfa71ff07c52035a437209022b4ddc5d6 (diff) |
Feat: question repo
Diffstat (limited to 'internal/database/migrations/002_quiz_schema.up.sql')
-rw-r--r-- | internal/database/migrations/002_quiz_schema.up.sql | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/internal/database/migrations/002_quiz_schema.up.sql b/internal/database/migrations/002_quiz_schema.up.sql deleted file mode 100644 index 406432b..0000000 --- a/internal/database/migrations/002_quiz_schema.up.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE IF NOT EXISTS questions ( - id INTEGER PRIMARY KEY, - text TEXT NOT NULL, - option1 TEXT, - option2 TEXT, - option3 TEXT, - option4 TEXT, - correct_index INTEGER NOT NULL, - requirement TEXT, - explanation TEXT, - status INTEGER DEFAULT 0, - exam_id INTEGER, - mixed_id INTEGER -); - -CREATE INDEX IF NOT EXISTS idx_questions_exam_id ON questions(exam_id); -CREATE INDEX IF NOT EXISTS idx_questions_mixed_id ON questions(mixed_id); |