summaryrefslogtreecommitdiff
path: root/internal/database/migrations/002_quiz_schema.up.sql
diff options
context:
space:
mode:
authorGrail Finder <wohilas@gmail.com>2025-04-05 15:04:15 +0300
committerGrail Finder <wohilas@gmail.com>2025-04-05 15:04:15 +0300
commit8bc7544e8933d64abc2610a265f37fe13b5767d5 (patch)
treeddcb10ff89723d0c490f6c1e781928ae89666b25 /internal/database/migrations/002_quiz_schema.up.sql
parent287da7acfa71ff07c52035a437209022b4ddc5d6 (diff)
Feat: question repo
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);