feat: add SQLite schema for quiz questions storage

2 files changed, 18 insertions, 0 deletions

diff --git a/internal/database/migrations/002_quiz_schema.down.sql b/internal/database/migrations/002_quiz_schema.down.sql
new file mode 100644
index 0000000..8f644e8
--- /dev/null
+++ b/internal/database/migrations/002_quiz_schema.down.sql
@@ -0,0 +1 @@
+DROP TABLE IF EXISTS questions;
diff --git a/internal/database/migrations/002_quiz_schema.up.sql b/internal/database/migrations/002_quiz_schema.up.sql
new file mode 100644
index 0000000..406432b
--- /dev/null
+++ b/internal/database/migrations/002_quiz_schema.up.sql
@@ -0,0 +1,17 @@
+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);