diff options
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); |