-- DROP DATABASE quiz;

-- question

INSERT INTO `quiz`.`question` (`id`, `difficulty`, `question_content`, `version`,`points`)
VALUES ('1', 'easy', 'Which of the following statements about the Java language is true?', '1',1);
INSERT INTO `quiz`.`question` (`id`, `difficulty`, `question_content`, `version`,`points`)
VALUES ('2', 'medium', 'Is this True or False. In Java an abstract class cannot be sub-classed.', '1',2);
INSERT INTO `quiz`.`question` (`id`, `difficulty`, `question_content`, `version`,`points`) VALUES
  ('3', 'hard', 'TreeMap class is used to implement which collection interface. Select the one correct answer.', '1',3);

-- quiz

INSERT INTO `quiz`.`quiz` (`id`, `name`, `time_assigned`) VALUES ('1', 'Java 8 Quiz', 600);

-- answer

INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`)
VALUES ('1', 'Both procedural and OOP are supported in Java.', '1', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`)
VALUES ('2', 'Java supports only procedural approach towards programming.', '0', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`)
VALUES ('3', 'Java supports only OOP approach. ', '0', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`)
VALUES ('4', 'None of the above. ', '0', '1');
-- pytanie 2
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('5', 'True', '0', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('6', 'False', '1', '1');
-- pytanie 3
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('7', 'Set', '0', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('8', 'SortedSet', '1', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('9', 'Tree', '1', '1');
INSERT INTO `quiz`.`answer` (`id`, `answer_content`, `correct`, `version`) VALUES ('10', 'SortedMap', '0', '1');

-- question-answer relation

INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('1', '1');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('1', '2');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('1', '3');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('1', '4');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('2', '5');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('2', '6');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('3', '7');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('3', '8');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('3', '9');
INSERT INTO `quiz`.`question_answers` (`question_id`, `answers_id`) VALUES ('3', '10');

-- quiz-content relation
--
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('1', '1', '1', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('2', '2', '1', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('3', '3', '1', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('4', '4', '1', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('5', '5', '2', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('6', '6', '2', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('7', '7', '3', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('8', '8', '3', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('9', '9', '3', '1');
INSERT INTO `quiz`.`content` (`id`, `answer_id`, `question_id`, `quiz_id`) VALUES ('10', '10', '3', '1');

-- user-role table

INSERT INTO `quiz`.`user_role` (`id`, `name`) VALUES ('1', 'ADMIN');
INSERT INTO `quiz`.`user_role` (`id`, `name`) VALUES ('2', 'USER');
INSERT INTO `quiz`.`user_role` (`id`, `name`) VALUES ('3', 'SUPPORT');

-- user table

INSERT INTO `quiz`.`user` (`id`, `email`, `enabled`, `name`, `password`, `surname`)
VALUES ('1', 'admin@gmail.com', '1', 'Admin', 'admin', 'Adminewicz');
INSERT INTO `quiz`.`user` (`id`, `email`, `enabled`, `name`, `password`, `surname`)
VALUES ('2', 'user@gmail.com', '1', 'User', 'user', 'Userowski');
INSERT INTO `quiz`.`user` (`id`, `email`, `enabled`, `name`, `password`, `surname`)
VALUES ('3', 'support@gmail.com', '1', 'Support', 'support', 'Supportario');
INSERT INTO `quiz`.`user` (`id`, `email`, `enabled`, `name`, `password`, `surname`)
VALUES ('4', 'banned@gmail.com', '0', 'Banned', 'banned', 'Bannederino');

-- user_user_role

INSERT INTO `quiz`.`user_user_role` (`user_id`, `user_role_id`) VALUES ('1', '1');
INSERT INTO `quiz`.`user_user_role` (`user_id`, `user_role_id`) VALUES ('2', '2');
INSERT INTO `quiz`.`user_user_role` (`user_id`, `user_role_id`) VALUES ('3', '3');
INSERT INTO `quiz`.`user_user_role` (`user_id`, `user_role_id`) VALUES ('4', '1');

-- attempts

INSERT INTO `quiz`.`attempt` (`id`, `status`, `quiz_id`, `user_id`, `start_date_time`, `end_date_time`) VALUES ('1', 'in progress', '1', '3','2017-12-15 09:30:19', '2017-12-15 20:30:19');
INSERT INTO `quiz`.`attempt` (`id`, `status`, `quiz_id`, `user_id`, `start_date_time`, `end_date_time`) VALUES ('2', 'completed', '1', '3','2017-12-15 09:30:19', '2017-12-15 20:30:19');
INSERT INTO `quiz`.`attempt` (`id`, `status`, `quiz_id`, `user_id`, `end_date_time`) VALUES ('3', 'assigned', '1', '3', '2017-12-15 20:30:19');
-- INSERT INTO `quiz`.`attempt` (`id`, `status`, `quiz_id`, `user_id`) VALUES ('2', 'completed', '1', '3');
-- INSERT INTO `quiz`.`attempt` (`id`, `status`, `quiz_id`, `user_id`) VALUES ('3', 'assigned', '1', '3');