INSERT INTO `courses` (`id`, `code`, `name`, `semester`, `year`) VALUES
(10101, '', 'Computer Science 1 ', 0, 2023),
(10115, 'CSE 116', 'Computer Science 2', 4, 2023),
(10116, 'CSE 312', 'Introduction to Web Applications', 2, 2023),
(10117, 'CSE 404', 'Software Project Managment', 4, 2023),
(10118, 'CSE199', 'UB Seminar', 4, 2023),
(10119, 'CSE 115', 'Computer Science 1', 4, 2023),
(10120, 'CSE 305', 'Programming Languages', 4, 2023),
(10121, 'CSE250', 'Data Structures', 2, 2023),
(10122, 'CSE331', 'Algorithms and Complexity', 1, 2022),
(10123, 'CSE 365', 'Computer Security', 1, 2022),
(10124, 'CSE 220', 'Systems Programming', 3, 2022),
(10125, 'CSE 241', 'Digital Systems', 3, 2022),
(10126, 'CSE 410', 'Special Topics', 2, 2023),
(10127, 'CSE 306', 'Software Quality in Practice', 3, 2022),
(10128, 'CSE 234', 'Intro to Blockchain', 3, 2022),
(42356, 'CSE 442', 'Software Engineering Concepts ', 0, 2023),
(42357, 'XMS 101', 'Introduction to Christmas', 1, 2024),
(42358, 'XMS 101', 'Introduction to Christmas', 4, 2023);

INSERT INTO `course_instructors` (`course_id`, `instructor_id`) VALUES
(10101, 0),
(10115, 1),
(10116, 1),
(10117, 1),
(10118, 1),
(10119, 1),
(10120, 1),
(10121, 1),
(10122, 1),
(10123, 1),
(10124, 1),
(10125, 1),
(10126, 1),
(10127, 1),
(10128, 1),
(42356, 2),
(42357, 5),
(42358, 5);

INSERT INTO `enrollments` (`student_id`, `course_id`) VALUES
(10000001, 42357),
(10000001, 42358),
(10000002, 42357),
(10000002, 42358),
(10000003, 42357),
(10000003, 42358),
(10000004, 42357),
(10000004, 42358),
(10000005, 42357),
(10000005, 42358),
(10000006, 42357),
(10000006, 42358),
(10000007, 42357),
(10000007, 42358),
(10000008, 42357),
(10000008, 42358),
(10000009, 42357),
(10000009, 42358),
(10000010, 42357),
(10000010, 42358),
(50243400, 42356),
(50243479, 10101),
(50243480, 10115),
(50243535, 10117),
(50243535, 10118),
(50243535, 10122),
(50243535, 10123),
(50243536, 10117),
(50243536, 10118),
(50243536, 10122),
(50243536, 10123),
(50243537, 10117),
(50243537, 10118),
(50243537, 10122),
(50243537, 10123),
(50243538, 10117),
(50243538, 10118);

INSERT INTO `evals` (`id`, `review_id`) VALUES
(95, 3),
(94, 4),
(96, 41),
(97, 42),
(110, 43),
(111, 44),
(112, 45),
(113, 46),
(114, 47),
(115, 48),
(116, 49),
(117, 50),
(118, 51),
(119, 52),
(120, 53),
(121, 54),
(122, 55),
(123, 56),
(124, 57),
(125, 58),
(126, 59),
(127, 60),
(128, 61),
(129, 62),
(130, 63),
(131, 64),
(132, 65),
(133, 66),
(134, 67),
(135, 68),
(136, 69),
(137, 70),
(138, 71),
(139, 72),
(140, 73),
(141, 74),
(142, 75),
(143, 76),
(144, 77),
(145, 78),
(146, 79),
(147, 80),
(148, 81),
(149, 82),
(150, 83),
(151, 84),
(152, 85),
(153, 86),
(212, 212),
(213, 213),
(214, 214),
(215, 215),
(216, 216),
(217, 217),
(218, 218),
(219, 219),
(220, 220),
(221, 221),
(222, 222),
(223, 223),
(224, 224),
(225, 225),
(226, 226),
(227, 227),
(228, 228),
(229, 229),
(230, 230),
(231, 231),
(232, 232),
(233, 233),
(234, 234),
(235, 235),
(236, 236),
(237, 237),
(238, 238);

INSERT INTO `freeforms` (`eval_id`, `topic_id`, `response`) VALUES
(0, 0, 'FreeForm One');

INSERT INTO `reviews` (`id`, `survey_id`, `reviewer_id`, `team_id`, `reviewed_id`, `eval_weight`) VALUES
(39, 20, 50243535, 15, 50243535, 1),
(40, 20, 50243535, 15, 50243536, 1),
(41, 20, 50243535, 15, 50243537, 1),
(42, 20, 50243535, 15, 50243538, 1),
(43, 20, 50243536, 15, 50243536, 1),
(44, 20, 50243536, 15, 50243537, 1),
(45, 20, 50243536, 15, 50243538, 1),
(46, 20, 50243536, 15, 50243535, 1),
(47, 20, 50243537, 15, 50243537, 1),
(48, 20, 50243537, 15, 50243538, 1),
(49, 20, 50243537, 15, 50243535, 1),
(50, 20, 50243537, 15, 50243536, 1),
(51, 20, 50243538, 15, 50243538, 1),
(52, 20, 50243538, 15, 50243535, 1),
(53, 20, 50243538, 15, 50243536, 1),
(54, 20, 50243538, 15, 50243537, 1),
(55, 18, 50243535, 16, 50243535, 1),
(56, 18, 50243535, 16, 50243536, 1),
(57, 18, 50243535, 16, 50243537, 1),
(58, 18, 50243535, 16, 50243538, 1),
(59, 18, 50243536, 16, 50243536, 1),
(60, 18, 50243536, 16, 50243537, 1),
(61, 18, 50243536, 16, 50243538, 1),
(62, 18, 50243536, 16, 50243535, 1),
(63, 18, 50243537, 16, 50243537, 1),
(64, 18, 50243537, 16, 50243538, 1),
(65, 18, 50243537, 16, 50243535, 1),
(66, 18, 50243537, 16, 50243536, 1),
(67, 18, 50243538, 16, 50243538, 1),
(68, 18, 50243538, 16, 50243535, 1),
(69, 18, 50243538, 16, 50243536, 1),
(70, 18, 50243538, 16, 50243537, 1),
(71, 19, 50243535, 17, 50243535, 1),
(72, 19, 50243535, 17, 50243536, 1),
(73, 19, 50243535, 17, 50243537, 1),
(74, 19, 50243535, 17, 50243538, 1),
(75, 19, 50243536, 17, 50243536, 1),
(76, 19, 50243536, 17, 50243537, 1),
(77, 19, 50243536, 17, 50243538, 1),
(78, 19, 50243536, 17, 50243535, 1),
(79, 19, 50243537, 17, 50243537, 1),
(80, 19, 50243537, 17, 50243538, 1),
(81, 19, 50243537, 17, 50243535, 1),
(82, 19, 50243537, 17, 50243536, 1),
(83, 19, 50243538, 17, 50243538, 1),
(84, 19, 50243538, 17, 50243535, 1),
(85, 19, 50243538, 17, 50243536, 1),
(86, 19, 50243538, 17, 50243537, 1),
(212, 23, 50243535, 7, 50243535, 1),
(213, 23, 50243535, 7, 50243536, 1),
(214, 23, 50243535, 7, 50243537, 1),
(215, 23, 50243536, 7, 50243536, 1),
(216, 23, 50243536, 7, 50243535, 1),
(217, 23, 50243536, 7, 50243537, 1),
(218, 23, 50243537, 7, 50243537, 1),
(219, 23, 50243537, 7, 50243535, 1),
(220, 23, 50243537, 7, 50243536, 1),
(221, 27, 50243535, 5, 50243535, 1),
(222, 27, 50243535, 5, 50243536, 1),
(223, 27, 50243535, 5, 50243537, 1),
(224, 27, 50243536, 5, 50243536, 1),
(225, 27, 50243536, 5, 50243535, 1),
(226, 27, 50243536, 5, 50243537, 1),
(227, 27, 50243537, 5, 50243537, 1),
(228, 27, 50243537, 5, 50243535, 1),
(229, 27, 50243537, 5, 50243536, 1),
(230, 42, 10000010, 0, 10000001, 1),
(231, 42, 10000010, 1, 10000002, 1),
(232, 42, 10000010, 2, 10000003, 1),
(233, 42, 10000010, 3, 10000004, 1),
(234, 42, 10000010, 4, 10000005, 1),
(235, 42, 10000010, 5, 10000006, 1),
(236, 42, 10000010, 6, 10000007, 1),
(237, 42, 10000010, 7, 10000008, 1),
(238, 42, 10000010, 8, 10000009, 1),
(239, 43, 10000009, 0, 10000001, 4),
(240, 43, 10000001, 0, 10000001, 1),
(241, 43, 10000001, 0, 10000002, 1),
(242, 43, 10000001, 0, 10000003, 1),
(243, 43, 10000001, 0, 10000004, 1),
(244, 43, 10000009, 0, 10000002, 4),
(245, 43, 10000002, 0, 10000001, 1),
(246, 43, 10000002, 0, 10000002, 1),
(247, 43, 10000002, 0, 10000003, 1),
(248, 43, 10000002, 0, 10000004, 1),
(249, 43, 10000009, 0, 10000003, 4),
(250, 43, 10000003, 0, 10000001, 1),
(251, 43, 10000003, 0, 10000002, 1),
(252, 43, 10000003, 0, 10000003, 1),
(253, 43, 10000003, 0, 10000004, 1),
(254, 43, 10000009, 0, 10000004, 4),
(255, 43, 10000004, 0, 10000001, 1),
(256, 43, 10000004, 0, 10000002, 1),
(257, 43, 10000004, 0, 10000003, 1),
(258, 43, 10000004, 0, 10000004, 1),
(259, 43, 10000009, 1, 10000005, 4),
(260, 43, 10000005, 1, 10000005, 1),
(261, 43, 10000005, 1, 10000006, 1),
(262, 43, 10000005, 1, 10000007, 1),
(263, 43, 10000005, 1, 10000008, 1),
(264, 43, 10000009, 1, 10000006, 4),
(265, 43, 10000006, 1, 10000005, 1),
(266, 43, 10000006, 1, 10000006, 1),
(267, 43, 10000006, 1, 10000007, 1),
(268, 43, 10000006, 1, 10000008, 1),
(269, 43, 10000009, 1, 10000007, 4),
(270, 43, 10000007, 1, 10000005, 1),
(271, 43, 10000007, 1, 10000006, 1),
(272, 43, 10000007, 1, 10000007, 1),
(273, 43, 10000007, 1, 10000008, 1),
(274, 43, 10000009, 1, 10000008, 4),
(275, 43, 10000008, 1, 10000005, 1),
(276, 43, 10000008, 1, 10000006, 1),
(277, 43, 10000008, 1, 10000007, 1),
(278, 43, 10000008, 1, 10000008, 1);

INSERT INTO `rubrics` (`id`, `description`) VALUES
(1, 'ABET Teamwork'),
(2, 'PM Evaluation'),
(3, 'Miss Claus Evaluaton');

INSERT INTO `rubric_responses` (`topic_id`, `rubric_score_id`, `response`) VALUES
(1, 1, 'Does not willingly assume team roles, rarely completes assigned work'),
(1, 2, 'Usually accepts assigned team roles, occasionally completes assigned work'),
(1, 3, 'Accepts assigned team roles, mostly completes assigned work'),
(1, 4, 'Accepts all assigned team roles, always completes assigned work'),
(2, 1, 'Rarely takes leadership role, does not collaborate, sometimes willing to assist teammates'),
(2, 2, 'Occasionally shows leadership, mostly collaborates, generally willing to assist teammates'),
(2, 3, 'Shows an ability to lead when necessary, willing to collaborate, willing to assist teammates'),
(2, 4, 'Takes leadership role, is a good collaborator, always willing to assist teammates'),
(3, 1, 'Often misses meetings, routinely unprepared for meetings, rarely participates in meetings and doesn\'t share ideas'),
(3, 2, 'Occasionally misses/doesn\'t participate in meetings, somewhat unprepared for meetings, offers unclear/unhelpful ideas'),
(3, 3, 'Attends and participates in most meetings, comes prepared, offers useful ideas'),
(3, 4, 'Attends and participates in all meetings, comes prepared, and clearly expresses well-developed ideas'),
(4, 1, 'Often discourteous and/or openly critical of teammates, doesn\'t listen to alternative perspectives'),
(4, 2, 'Often courteous to teammates, usually appreciates teammates perspectives but often unwilling to consider them'),
(4, 3, 'Mostly courteous to teammates, values teammates\' perspectives and often willing to consider them'),
(4, 4, 'Always courteous to teammates, values teammates\' perspectives, knowledge, and experience, and always willing to consider them'),
(5, 1, 'Rarely commits to shared documents, others often required to revise, debug, or fix their work'),
(5, 2, 'Occasionally commits to shared documents, others sometimes needed to revise, debug, or fix their work'),
(5, 3, 'Often commits to shared documents, others occasionally needed to revise, debug, or fix their work'),
(5, 4, 'Frequently commits to shared documents, others rarely need to revise, debug, or fix their work'),
(6, 5, 'Agree Strongly'),
(6, 6, 'Agree'),
(6, 7, 'Neither Agree or Disagree'),
(6, 8, 'Disagree'),
(6, 9, 'Disagree Strongly'),
(7, 5, 'Agree Strongly'),
(7, 6, 'Agree'),
(7, 7, 'Neither Agree or Disagree'),
(7, 8, 'Disagree'),
(7, 9, 'Disagree Strongly'),
(8, 5, 'Agree Strongly'),
(8, 6, 'Agree'),
(8, 7, 'Neither Agree or Disagree'),
(8, 8, 'Disagree'),
(8, 9, 'Disagree Strongly'),
(9, 5, 'Agree Strongly'),
(9, 6, 'Agree'),
(9, 7, 'Neither Agree or Disagree'),
(9, 8, 'Disagree'),
(9, 9, 'Disagree Strongly'),
(10, 5, 'Agree Strongly'),
(10, 6, 'Agree'),
(10, 7, 'Neither Agree or Disagree'),
(10, 8, 'Disagree'),
(10, 9, 'Disagree Strongly'),
(11, 10, 'Miss Claus feeds me bad food and I startve'),
(11, 11, 'Miss Claus feeds me bad food but she tries'),
(11, 12, 'Miss Claus feeds me good food'),
(12, 10, 'Miss Claus never cleans me'),
(12, 11, 'Miss Claus cleans me every month'),
(12, 12, 'Miss Claus washes me everyday'),
(13, 10, 'Miss Claus never walks me'),
(13, 11, 'Miss Claus walks me sometimes'),
(13, 12, 'Miss Claus walks me every week');

INSERT INTO `rubric_scores` (`id`, `rubric_id`, `name`, `score`) VALUES
(1, 1, 'Unsatisfactory', 0),
(2, 1, 'Developing', 1),
(3, 1, 'Satisfactory', 2),
(4, 1, 'Exemplary', 3),
(5, 2, 'Agree Strongly', 4),
(6, 2, 'Agree', 3),
(7, 2, 'Neither Agree or Disagree', 2),
(8, 2, 'Disagree', 1),
(9, 2, 'Disagree Strongly', 0),
(10, 3, 'Bad', 1),
(11, 3, 'Good', 2),
(12, 3, 'Amazing', 3);

INSERT INTO `rubric_topics` (`id`, `rubric_id`, `question`, `question_response`) VALUES
(1, 1, 'Teamwork ', 'multiple_choice'),
(2, 1, 'Leadership', 'multiple_choice'),
(3, 1, 'Participation', 'multiple_choice'),
(4, 1, 'Professionalism', 'multiple_choice'),
(5, 1, 'Quality', 'multiple_choice'),
(6, 2, 'My Project Manager set clear expectation for what they expect each of us to accomplish each week', 'multiple_choice'),
(7, 2, 'My Project Manager practiced open communication with the group', 'multiple_choice'),
(8, 2, 'My Project Manager gave constructive feedback', 'multiple_choice'),
(9, 2, 'My Project Manager demanded and maintained accountability from everyone, including themselves', 'multiple_choice'),
(10, 2, 'I felt that I could trust my Project Manager', 'multiple_choice'),
(11, 3, 'Food quality', 'multiple_choice'),
(12, 3, 'Cleanliness', 'multiple_choice'),
(13, 3, 'Walks', 'multiple_choice');

INSERT INTO `scores` (`eval_id`, `topic_id`, `rubric_score_id`) VALUES
(0, 0, 0),
(1, 1, 1),
(94, 1, 1),
(94, 2, 1),
(95, 3, 1),
(97, 2, 1),
(110, 3, 1),
(111, 3, 1),
(112, 5, 1),
(114, 2, 1),
(116, 1, 1),
(116, 5, 1),
(118, 1, 1),
(124, 2, 1),
(125, 2, 1),
(125, 4, 1),
(126, 3, 1),
(126, 5, 1),
(127, 1, 1),
(128, 3, 1),
(128, 5, 1),
(132, 1, 1),
(133, 1, 1),
(135, 1, 1),
(135, 3, 1),
(136, 2, 1),
(136, 3, 1),
(137, 5, 1),
(138, 4, 1),
(139, 3, 1),
(139, 4, 1),
(139, 5, 1),
(140, 3, 1),
(142, 2, 1),
(143, 1, 1),
(143, 2, 1),
(146, 4, 1),
(147, 5, 1),
(148, 2, 1),
(148, 4, 1),
(151, 4, 1),
(152, 1, 1),
(153, 2, 1),
(153, 5, 1),
(213, 2, 1),
(214, 4, 1),
(215, 1, 1),
(215, 3, 1),
(215, 4, 1),
(216, 1, 1),
(216, 4, 1),
(216, 5, 1),
(217, 4, 1),
(218, 2, 1),
(219, 2, 1),
(221, 5, 1),
(222, 3, 1),
(223, 5, 1),
(225, 5, 1),
(226, 4, 1),
(229, 1, 1),
(229, 3, 1),
(229, 4, 1),
(230, 5, 1),
(236, 1, 1),
(236, 2, 1),
(236, 3, 1),
(236, 4, 1),
(2, 2, 2),
(95, 1, 2),
(95, 2, 2),
(95, 4, 2),
(96, 1, 2),
(96, 3, 2),
(97, 3, 2),
(110, 2, 2),
(111, 4, 2),
(112, 3, 2),
(114, 4, 2),
(118, 5, 2),
(119, 2, 2),
(119, 4, 2),
(120, 1, 2),
(120, 3, 2),
(121, 2, 2),
(121, 3, 2),
(122, 4, 2),
(123, 3, 2),
(123, 4, 2),
(124, 1, 2),
(126, 2, 2),
(127, 2, 2),
(127, 3, 2),
(129, 5, 2),
(131, 2, 2),
(131, 4, 2),
(132, 4, 2),
(133, 5, 2),
(135, 2, 2),
(138, 5, 2),
(139, 1, 2),
(141, 5, 2),
(142, 4, 2),
(142, 5, 2),
(143, 4, 2),
(143, 5, 2),
(144, 4, 2),
(145, 5, 2),
(146, 1, 2),
(146, 5, 2),
(147, 1, 2),
(148, 3, 2),
(148, 5, 2),
(149, 1, 2),
(149, 3, 2),
(150, 2, 2),
(151, 3, 2),
(152, 5, 2),
(153, 4, 2),
(212, 1, 2),
(212, 5, 2),
(213, 3, 2),
(214, 3, 2),
(215, 2, 2),
(217, 2, 2),
(217, 3, 2),
(219, 5, 2),
(221, 4, 2),
(223, 1, 2),
(223, 3, 2),
(224, 2, 2),
(225, 1, 2),
(225, 4, 2),
(226, 5, 2),
(227, 4, 2),
(228, 5, 2),
(230, 3, 2),
(230, 4, 2),
(231, 4, 2),
(232, 1, 2),
(232, 2, 2),
(232, 5, 2),
(233, 1, 2),
(233, 2, 2),
(233, 3, 2),
(234, 1, 2),
(234, 3, 2),
(234, 5, 2),
(235, 2, 2),
(236, 5, 2),
(237, 1, 2),
(237, 3, 2),
(238, 4, 2),
(94, 4, 3),
(95, 5, 3),
(96, 2, 3),
(96, 4, 3),
(97, 1, 3),
(97, 4, 3),
(110, 1, 3),
(111, 5, 3),
(112, 1, 3),
(114, 1, 3),
(114, 3, 3),
(114, 5, 3),
(115, 1, 3),
(115, 2, 3),
(115, 4, 3),
(115, 5, 3),
(116, 2, 3),
(116, 3, 3),
(117, 1, 3),
(117, 2, 3),
(117, 4, 3),
(117, 5, 3),
(118, 2, 3),
(118, 3, 3),
(118, 4, 3),
(119, 3, 3),
(120, 2, 3),
(120, 5, 3),
(121, 1, 3),
(121, 4, 3),
(121, 5, 3),
(122, 1, 3),
(122, 5, 3),
(123, 1, 3),
(123, 5, 3),
(124, 5, 3),
(125, 1, 3),
(125, 3, 3),
(127, 4, 3),
(128, 1, 3),
(128, 2, 3),
(128, 4, 3),
(129, 2, 3),
(130, 1, 3),
(130, 3, 3),
(130, 5, 3),
(131, 1, 3),
(131, 3, 3),
(131, 5, 3),
(132, 3, 3),
(133, 2, 3),
(134, 1, 3),
(134, 3, 3),
(134, 4, 3),
(135, 4, 3),
(137, 2, 3),
(138, 1, 3),
(138, 2, 3),
(139, 2, 3),
(140, 2, 3),
(140, 5, 3),
(141, 1, 3),
(141, 2, 3),
(141, 3, 3),
(142, 1, 3),
(143, 3, 3),
(144, 3, 3),
(144, 5, 3),
(145, 3, 3),
(146, 2, 3),
(146, 3, 3),
(147, 3, 3),
(148, 1, 3),
(149, 4, 3),
(149, 5, 3),
(150, 1, 3),
(150, 4, 3),
(150, 5, 3),
(151, 2, 3),
(153, 1, 3),
(153, 3, 3),
(212, 3, 3),
(213, 5, 3),
(214, 1, 3),
(214, 2, 3),
(215, 5, 3),
(216, 3, 3),
(217, 5, 3),
(218, 1, 3),
(218, 3, 3),
(218, 5, 3),
(220, 5, 3),
(221, 3, 3),
(222, 2, 3),
(223, 2, 3),
(224, 4, 3),
(224, 5, 3),
(225, 3, 3),
(226, 1, 3),
(228, 1, 3),
(229, 5, 3),
(230, 2, 3),
(231, 1, 3),
(231, 3, 3),
(231, 5, 3),
(232, 3, 3),
(233, 4, 3),
(233, 5, 3),
(234, 2, 3),
(234, 4, 3),
(235, 3, 3),
(235, 4, 3),
(235, 5, 3),
(237, 2, 3),
(237, 4, 3),
(238, 1, 3),
(238, 2, 3),
(238, 3, 3),
(238, 5, 3),
(94, 3, 4),
(94, 5, 4),
(96, 5, 4),
(97, 5, 4),
(110, 4, 4),
(110, 5, 4),
(111, 1, 4),
(111, 2, 4),
(112, 2, 4),
(112, 4, 4),
(113, 1, 4),
(113, 2, 4),
(113, 3, 4),
(113, 4, 4),
(113, 5, 4),
(115, 3, 4),
(116, 4, 4),
(117, 3, 4),
(119, 1, 4),
(119, 5, 4),
(120, 4, 4),
(122, 2, 4),
(122, 3, 4),
(123, 2, 4),
(124, 3, 4),
(124, 4, 4),
(125, 5, 4),
(126, 1, 4),
(126, 4, 4),
(127, 5, 4),
(129, 1, 4),
(129, 3, 4),
(129, 4, 4),
(130, 2, 4),
(130, 4, 4),
(132, 2, 4),
(132, 5, 4),
(133, 3, 4),
(133, 4, 4),
(134, 2, 4),
(134, 5, 4),
(135, 5, 4),
(136, 1, 4),
(136, 4, 4),
(136, 5, 4),
(137, 1, 4),
(137, 3, 4),
(137, 4, 4),
(138, 3, 4),
(140, 1, 4),
(140, 4, 4),
(141, 4, 4),
(142, 3, 4),
(144, 1, 4),
(144, 2, 4),
(145, 1, 4),
(145, 2, 4),
(145, 4, 4),
(147, 2, 4),
(147, 4, 4),
(149, 2, 4),
(150, 3, 4),
(151, 1, 4),
(151, 5, 4),
(152, 2, 4),
(152, 3, 4),
(152, 4, 4),
(212, 2, 4),
(212, 4, 4),
(213, 1, 4),
(213, 4, 4),
(214, 5, 4),
(216, 2, 4),
(217, 1, 4),
(218, 4, 4),
(219, 1, 4),
(219, 3, 4),
(219, 4, 4),
(220, 1, 4),
(220, 2, 4),
(220, 3, 4),
(220, 4, 4),
(221, 1, 4),
(221, 2, 4),
(222, 1, 4),
(222, 4, 4),
(222, 5, 4),
(223, 4, 4),
(224, 1, 4),
(224, 3, 4),
(225, 2, 4),
(226, 2, 4),
(226, 3, 4),
(227, 1, 4),
(227, 2, 4),
(227, 3, 4),
(227, 5, 4),
(228, 2, 4),
(228, 3, 4),
(228, 4, 4),
(229, 2, 4),
(230, 1, 4),
(231, 2, 4),
(232, 4, 4),
(235, 1, 4),
(237, 5, 4);

INSERT INTO `students` (`id`, `name`, `email`) VALUES
(10000001, 'Dasher Reindeer', 'dasher@buffalo.edu'),
(10000002, 'Dancer Reindeer', 'dancer@buffalo.edu'),
(10000003, 'Prancer Reindeer', 'prancer@buffalo.edu'),
(10000004, 'Vixen Reindeer', 'vixen@buffalo.edu'),
(10000005, 'Comet Reindeer', 'comet@buffalo.edu'),
(10000006, 'Cupid Reindeer', 'cupid@buffalo.edu'),
(10000007, 'Donner Reindeer', 'donner@buffalo.edu'),
(10000008, 'Blitzen Reindeer', 'blitzen@buffalo.edu'),
(10000009, 'Rudolph Red', 'rudolph@buffalo.edu'),
(10000010, 'Miss Claus', 'msclaus@buffalo.edu'),
(50243400, 'Smitty Johnson', ''),
(50243479, 'Jim Jones', 'jjones@buffalo.edu'),
(50243480, 'John Eggert', 'jeggert@buffalo.edu'),
(50243485, 'Student Five', 's5@buffalo.edu'),
(50243486, 'Student Six', 's6@buffalo.edu'),
(50243487, 'Student Seven', 's7@buffalo.edu'),
(50243488, 'Student Eight', 's8@buffalo.edu'),
(50243489, 'Student Nine', 's9@buffalo.edu'),
(50243490, 'Student Ten', 's10@buffalo.edu'),
(50243491, 'Student Eleven', 's11@buffalo.edu'),
(50243492, 'Student Manager One', 'manager1@buffalo.edu'),
(50243493, 'Team One Member One', 't1m1@buffalo.edu'),
(50243494, 'Team One Member Two', 't1m2@buffalo.edu'),
(50243495, 'Team One Member Three', 't1m3@buffalo.edu'),
(50243496, 'Team One Member Four', 't1m4@buffalo.edu'),
(50243497, 'Student Manager Two', 'manager2@buffalo.edu'),
(50243498, 'Team Two Member One', 't2m1@buffalo.edu'),
(50243499, 'Team Two Member Two', 't2m2@buffalo.edu'),
(50243500, 'Team Two Member Three', 't2m3@buffalo.edu'),
(50243535, 'Student One', 's1@buffalo.edu'),
(50243536, 'Student Two', 's2@buffalo.edu'),
(50243537, 'Student Three', 's3@buffalo.edu'),
(50243538, 'Student Four', 's4@buffalo.edu');

INSERT INTO `surveys` (`id`, `course_id`, `start_date`, `end_date`, `name`, `rubric_id`, `survey_type_id`) VALUES
(1, 10115, '2023-09-19 08:31:19', '2023-09-19 08:31:19', 'Survey #2', 1, 1),
(2, 42356, '2023-09-19 08:32:44', '2023-09-19 08:32:44', 'Survey #3', 2, 2),
(5, 10115, '2023-09-19 08:31:19', '2023-09-19 08:31:19', 'Survey #1', 0, 1),
(6, 10115, '2023-09-19 08:31:19', '2023-09-19 08:31:19', 'Survey #2', 1, 1),
(7, 10115, '2023-10-26 22:39:52', '2023-10-27 22:39:52', 'Survey #4', 1, 1),
(8, 10115, '2023-10-26 22:41:41', '2023-10-27 22:41:41', 'Survey #5', 1, 1),
(9, 10115, '2023-09-19 08:32:44', '2023-09-19 08:32:44', 'Survey #3', 2, 2),
(10, 10116, '2023-10-27 22:46:46', '2023-10-27 22:46:46', 'Dummy Name 2', 1, 1),
(11, 10116, '2023-10-27 22:44:38', '2023-10-27 22:44:38', 'Dummy Name 1', 1, 1),
(12, 10119, '2023-10-27 00:37:18', '2023-10-28 00:37:18', 'Dummy Name 1', 1, 1),
(13, 10119, '2023-10-27 00:37:57', '2023-10-28 00:37:57', 'Dummy Name 2', 1, 1),
(14, 10120, '2023-10-27 00:39:53', '2023-10-28 00:39:53', 'Dummy Name 1', 1, 1),
(15, 10120, '2023-10-27 00:40:37', '2023-10-28 00:40:37', 'Dummy Name 2', 1, 1),
(16, 10120, '2023-10-27 00:40:59', '2023-10-28 00:40:59', 'Dummy Name 3', 1, 1),
(17, 10120, '2023-10-27 00:41:25', '2023-10-28 00:41:25', 'Dummy Name 4', 1, 1),
(18, 10117, '2023-10-27 00:42:35', '2023-10-28 00:42:35', 'CSE 404', 1, 1),
(19, 10117, '2023-10-27 00:43:04', '2023-10-28 00:43:04', 'CSE 404 #2', 1, 1),
(20, 10118, '2023-10-27 00:43:43', '2023-10-28 00:43:43', 'A Very Very Big Dummy Name 1', 1, 1),
(21, 10116, '2023-10-27 00:47:03', '2023-10-28 00:47:03', 'Dummy Name 1', 1, 1),
(22, 10116, '2023-10-27 00:47:25', '2023-10-28 00:47:25', 'Dummy Name 2', 1, 1),
(23, 10123, '2023-10-27 01:58:06', '2023-10-28 01:58:06', 'Dummy Name 1', 1, 1),
(24, 10123, '2023-10-27 02:05:33', '2023-10-28 02:05:33', 'Dummy Name 2', 1, 1),
(25, 10123, '2023-10-27 02:06:08', '2023-10-28 02:06:08', 'Dummy Name 3', 1, 1),
(26, 10101, '2023-09-19 08:31:19', '2023-09-19 08:31:19', 'Survey #1', 0, 0),
(27, 10122, '2023-10-27 04:25:09', '2023-10-28 04:25:09', 'Dummy Name 1', 1, 1),
(28, 10121, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 1', 1, 1),
(29, 10121, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 2', 1, 1),
(30, 10121, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 3', 1, 1),
(31, 10121, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 4', 1, 1),
(32, 10121, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 5', 1, 1),
(33, 10127, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 1', 1, 1),
(34, 10127, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 2', 1, 1),
(35, 10127, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 3', 1, 1),
(36, 10128, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 1', 1, 1),
(37, 10128, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 2', 1, 1),
(38, 10128, '2023-10-27 04:38:21', '2023-10-28 04:38:21', 'Dummy Name 3', 1, 1),
(39, 10122, '2023-10-27 04:46:05', '2023-10-28 04:46:05', 'Dummy Name 2', 1, 1),
(40, 10118, '2023-11-08 04:38:21', '2023-12-01 04:38:21', 'Active Survey 1', 1, 1),
(41, 10118, '2023-11-10 04:46:05', '2023-11-28 04:46:05', 'Active Survey 2', 1, 1),
(42, 42358, '2023-12-10 13:08:00', '2023-12-31 23:00:00', 'Miss Claus TA Grading', 1, 1),
(43, 42358, '2023-12-10 15:00:00', '2023-12-20 16:00:00', 's1', 1, 3),
(44, 42358, '2023-12-15 20:00:00', '2023-12-20 20:00:00', '86 - Duplicate this survey', 1, 2),
(45, 42358, '2023-12-15 22:00:00', '2023-12-20 23:00:00', '71 - Survey', 1, 2),
(46, 42358, '2023-12-15 23:00:00', '2023-12-20 23:00:00', 'Delete this survey 1', 1, 2);

INSERT INTO `survey_types` (`id`, `description`, `file_organization`, `display_multiplier`) VALUES
(1, 'Individual Reviewed by Individual', 'One row per review. Each row has 2 columns: email of the reviewer, email of the person being reviewed.', 0),
(2, 'Each Team Member Reviewed By Entire Team', 'One row per team. Each row contains the email addresses for all team members. Blank columns are ignored', 0),
(3, 'Each Team Member Reviewed by Entire Team + Manager', 'One row per team. Each row contains the email addresses for all team members with the manager email address listed last. Blank columns are ignored', 1),
(4, 'Single Individual Reviewed by Each Team Member', 'One row per individual being reviewed. Every row contains the email addresses of the reviewers and the person being reviewed. The person being reviewed MUST be in the final column in the row.', 0);