-- Use question_options table for MMCQ/dropdown options
-- If you already have question_options with (question_id, _options), you're set.
-- If you previously ran add_question_options_column.sql, run:
--   ALTER TABLE questions DROP COLUMN options;

-- Create question_options if it doesn't exist (table has question_id, _options)
CREATE TABLE IF NOT EXISTS question_options (
    question_options_id INT AUTO_INCREMENT PRIMARY KEY,
    question_id INT NOT NULL,
    _options VARCHAR(500) NOT NULL,
    FOREIGN KEY (question_id) REFERENCES questions(question_id) ON DELETE CASCADE
);
