INSERT INTO category('text') VALUES ('category1');
INSERT INTO category('text') VALUES ('category2');
INSERT INTO category('text') VALUES ('category3');
INSERT INTO question('category_id', 'text') VALUES (1, 'Question 1');
INSERT INTO question('category_id', 'text') VALUES (1, 'Question 2');
INSERT INTO question('category_id', 'text') VALUES (1, 'Question 3');
INSERT INTO question('category_id', 'text') VALUES (1, 'Question 4');
INSERT INTO choices('question_id', 'text', 'correct') VALUES (1, 'q1 Right answer', 1);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (1, 'q1 wrong answer 1', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (1, 'q1 wrong answer 2', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (1, 'q1 wrong answer 3', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (2, 'q2 Right answer', 1);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (2, 'q2 wrong answer 1', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (2, 'q2 wrong answer 2', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (2, 'q2 wrong answer 3', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (3, 'q3 Right answer', 1);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (3, 'q3 wrong answer 1', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (3, 'q3 wrong answer 2', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (3, 'q3 wrong answer 3', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (4, 'q4 Right answer', 1);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (4, 'q4 wrong answer 1', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (4, 'q4 wrong answer 2', 0);
INSERT INTO choices('question_id', 'text', 'correct') VALUES (4, 'q4 wrong answer 3', 0);


Add SQL script for adding test data
Add SQL script for adding test data

When I reset the DB, this makes it really easy to get test data in
there. Yay automation!
