INSERT INTO `enroll` (`studentid`, `tutorialid`, `joindate`, `leavedate`) VALUES
(1, 1, '2017-02-28', NULL),
(2, 1, '2017-02-28', NULL),
(3, 1, '2017-02-28', NULL),
(8, 1, '2017-02-28', NULL),
(5, 1, '2017-02-28', NULL),
(3, 2, '2017-02-23', '2017-02-28'),
(4, 2, '2017-02-23', '2017-02-28'),
(5, 2, '2017-02-23', '2017-02-28'),
(6, 2, '2017-02-23', '2017-03-01'),
(7, 2, '2017-02-23', '2017-03-01'),
(8, 2, '2017-02-23', '2017-03-01'),
(9, 2, '2017-02-23', '2017-03-01'),
(10, 2, '2017-02-23', '2017-03-01'),
(1, 3, '2017-01-23', '2017-01-27'),
(2, 3, '2017-01-23', '2017-01-27'),
(3, 3, '2017-01-23', '2017-01-27'),
(4, 3, '2017-01-23', '2017-01-27'),
(5, 3, '2017-01-23', '2017-01-27'),
(6, 4, '2017-02-01', '2017-03-01'),
(7, 4, '2017-02-01', '2017-03-01'),
(8, 4, '2017-02-01', '2017-03-01'),
(9, 4, '2017-02-01', '2017-03-01'),
(5, 4, '2017-03-01', '2017-02-28'),
(4, 4, '2017-02-01', '2017-03-01'),
(5, 5, '2017-02-01', NULL),
(8, 5, '2017-02-01', NULL),
(9, 5, '2017-03-01', '2017-02-02'),
(10, 5, '2017-02-01', '2017-02-02');

INSERT INTO `register` (`studentid`, `tutorialid`, `mark`) VALUES
(1, 1, 'Y'),
(1, 1, 'Y'),
(1, 1, 'N'),
(1, 1, 'S'),
(2, 1, 'S'),
(2, 1, 'S'),
(2, 1, 'S'),
(2, 1, 'Y'),
(3, 1, 'Y'),
(3, 1, 'N'),
(3, 1, 'N'),
(3, 1, 'S'),
(4, 1, 'Y'),
(4, 1, 'Y'),
(4, 1, 'Y'),
(4, 1, 'Y'),
(5, 1, 'S'),
(5, 1, 'S'),
(5, 1, 'N'),
(5, 1, 'N'),
(1, 1, 'N'),
(1, 1, 'N'),
(2, 1, 'Y'),
(3, 1, 'N'),
(5, 1, 'Y'),
(8, 1, 'S'),
(9, 1, 'Y'),
(3, 2, 'N'),
(4, 2, 'N'),
(5, 2, 'Y'),
(6, 2, 'Y'),
(7, 2, 'N'),
(8, 2, 'N'),
(8, 2, 'N'),
(9, 2, 'N'),
(0, 0, ''),
(10, 2, 'S'),
(1, 3, 'Y'),
(2, 3, 'Y'),
(3, 3, 'Y'),
(4, 3, 'N'),
(5, 3, 'Y'),
(6, 4, 'N'),
(7, 4, 'N'),
(8, 4, 'N'),
(9, 4, 'N'),
(5, 4, 'N'),
(4, 4, 'Y'),
(5, 5, 'S'),
(5, 5, 'S'),
(5, 5, 'S'),
(5, 5, 'S'),
(9, 5, 'N'),
(10, 5, 'N');


INSERT INTO `room` (`roomid`, `roomname`) VALUES
(1, 'Bancroft 1.15a'),
(2, 'ITL Ground Floor'),
(3, 'Mason Lecture Theatre'),
(4, 'Arts Two 3.10'),
(5, 'Arts One Room 4.67');


INSERT INTO `schedule` (`tutorid`, `dateandtime`, `roomid`) VALUES
(1, '2017-02-01 12:00:00', 1),
(1, '2017-02-08 12:00:00', 1),
(1, '2017-02-15 12:00:00', 1),
(1, '2017-02-22 12:00:00', 1),
(2, '2017-02-28 00:00:00', 2),
(1, '2017-02-01 09:00:00', 1),
(2, '2017-02-01 09:00:00', 4),
(3, '2017-01-26 09:00:00', 3),
(4, '2017-01-25 10:00:00', 3),
(4, '2017-02-01 09:00:00', 5),
(4, '2017-02-02 11:00:00', 2);


INSERT INTO `student` (`studentid`, `firstname`, `lastname`, `email`) VALUES
(1, 'Prash', 'Jay', 'prash@gmail.com'),
(2, 'Adam', 'Laraqui', 'adam@gmail.com'),
(3, 'Kev', 'Wedderburn', 'kev@gmail.com'),
(4, 'Melo', 'Jan', 'melo@gmail.com'),
(5, 'Johnny', 'Smith', 'john@gmail.com'),
(6, 'Chris', 'Cooper', 'chris@gmail.com'),
(7, 'Molos', 'Dautaj', 'molos@gmail.com'),
(8, 'Rabi', 'Ahmed', 'rabi@gmail.com'),
(9, 'Elmo', 'Muppet', 'elmo@muppetmail.com'),
(10, 'Rahi', 'Alam', 'rahi@gmail.com'),
(11, 'Jaden', 'Smith', 'jaden@smiths.com'),
(12, 'Will', 'Smith', 'will@smiths.com'),
(13, 'Jacrispy', 'Vulcano', 'jacrisp@gmail.com'),
(14, 'James', 'Murray', 'james@gmail.com'),
(15, 'Ted', 'Baker', 'ted@hotmail.com'),
(16, 'Ralph', 'Lauren', 'ralph@gmail.com'),
(17, 'Tony', 'Stark', 'tony@starks.com'),
(18, 'Pepper', 'Potts', 'pepper@gmail.com'),
(19, 'Paul', 'Ingram', 'paul@yahoo.com'),
(20, 'Ilias', 'Papounidis', 'ilias@gmail.com');


INSERT INTO `studentTutorialInfo` (`studentID`, `tutorialID`, `tutorID`, `dateandtime`, `roomID`) VALUES
(1, 1, 1, '2017-02-01 12:00:00', 1),
(2, 1, 1, '2017-02-01 12:00:00', 1),
(3, 1, 1, '2017-02-01 12:00:00', 1),
(4, 1, 1, '2017-02-01 12:00:00', 1),
(5, 1, 1, '2017-02-01 12:00:00', 1),
(1, 1, 1, '2017-02-08 12:00:00', 1),
(2, 1, 1, '2017-02-08 12:00:00', 1),
(3, 1, 1, '2017-02-08 12:00:00', 1),
(4, 1, 1, '2017-02-08 12:00:00', 1),
(5, 1, 1, '2017-02-08 12:00:00', 1),
(1, 1, 1, '2017-02-15 12:00:00', 1),
(2, 1, 1, '2017-02-15 12:00:00', 1),
(3, 1, 1, '2017-02-15 12:00:00', 1),
(4, 1, 1, '2017-02-15 12:00:00', 1),
(5, 1, 1, '2017-02-15 12:00:00', 1),
(1, 1, 1, '2017-02-22 12:00:00', 1),
(2, 1, 1, '2017-02-22 12:00:00', 1),
(3, 1, 1, '2017-02-22 12:00:00', 1),
(4, 1, 1, '2017-02-22 12:00:00', 1),
(5, 1, 1, '2017-02-22 12:00:00', 1),
(1, 1, 2, '2017-02-28 09:00:00', 1),
(2, 1, 2, '2017-02-28 09:00:00', NULL),
(5, 1, 2, '2017-02-28 09:00:00', 1),
(1, 2, 1, '2017-02-23 09:00:00', 1),
(1, 2, 2, '2017-01-23 09:00:00', 1),
(6, 4, 1, '2017-02-01 09:00:00', NULL),
(7, 4, 1, '2017-02-01 09:00:00', NULL),
(5, 5, 4, '2017-02-02 09:00:00', 2),
(8, 5, 4, '2017-02-02 09:00:00', 2);


INSERT INTO `timeslot` (`dateandtime`) VALUES
('2017-01-26 09:00:00'),
('2017-01-27 09:00:00'),
('2017-02-01 12:00:00'),
('2017-02-02 09:00:00'),
('2017-02-02 11:00:00'),
('2017-02-03 09:00:00'),
('2017-02-06 09:00:00'),
('2017-02-06 11:00:00'),
('2017-02-07 09:00:00'),
('2017-02-08 12:00:00'),
('2017-02-15 12:00:00'),
('2017-02-22 12:00:00'),
('2017-02-28 09:00:00');


INSERT INTO `tutor` (`tutorid`, `firstname`, `lastname`, `email`) VALUES
(1, 'Rob', 'Bobsky', 'rob_b@gmail.com'),
(2, 'Doctor', 'Pepper', 'dr@drpepper.com'),
(3, 'Matthew', 'Huntbach', 'm_hutbach@se15.qmul.ac.uk'),
(4, 'Tasos', 'Lavista', 'tasos@qmul.ac.uk'),
(5, 'Martin', 'Neil', 'martin@qmul.ac.uk');


INSERT INTO `tutorial` (`tutorialid`, `tutorialtype`, `startdate`, `enddate`) VALUES
(1, 'programming', '2017-02-28', '2017-03-01'),
(2, 'programming', '2017-01-23', '2017-03-01'),
(3, 'programming', '2017-01-23', '2017-01-27'),
(4, 'non-programming', '2017-02-01', '2017-03-01'),
(5, 'non-programming', '2017-02-01', '2017-03-01');