-- Add three new question types: Single Selection Dropdown, Multiple Dropdown Selection, Image Mark/Attach
-- Run this on existing databases that only have Text, Number, Yes/No.

INSERT INTO question_type (question_type_id, question_type)
VALUES (4, 'Single Selection Dropdown'),
       (5, 'Multiple Dropdown Selection'),
       (6, 'Image Mark/Attach')
AS new_row
ON DUPLICATE KEY UPDATE question_type = new_row.question_type;
