From a23b77f76f373cd02192117e0ba0aaa389aa9c1a Mon Sep 17 00:00:00 2001
From: "Grail Finder (aider)" <wohilas@gmail.com>
Date: Sat, 5 Apr 2025 12:28:35 +0300
Subject: feat: add SQLite schema for quiz questions storage

---
 internal/database/migrations/002_quiz_schema.down.sql |  1 +
 internal/database/migrations/002_quiz_schema.up.sql   | 17 +++++++++++++++++
 2 files changed, 18 insertions(+)
 create mode 100644 internal/database/migrations/002_quiz_schema.down.sql
 create mode 100644 internal/database/migrations/002_quiz_schema.up.sql

(limited to 'internal/database/migrations')

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);
-- 
cgit v1.2.3