summaryrefslogtreecommitdiff
path: root/internal/database/migrations/002_quiz_schema.up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/database/migrations/002_quiz_schema.up.sql')
-rw-r--r--internal/database/migrations/002_quiz_schema.up.sql17
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);