From 8bc7544e8933d64abc2610a265f37fe13b5767d5 Mon Sep 17 00:00:00 2001 From: Grail Finder Date: Sat, 5 Apr 2025 15:04:15 +0300 Subject: Feat: question repo --- internal/database/migrations/002_quiz_schema.up.sql | 17 ----------------- 1 file changed, 17 deletions(-) delete mode 100644 internal/database/migrations/002_quiz_schema.up.sql (limited to 'internal/database/migrations/002_quiz_schema.up.sql') 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); -- cgit v1.2.3