# Init Data in Student, Course, Schedule tables
# Clear the tables
delete from Schedule where id >= 0;
delete from Student where id >= 0;
delete from Course where crn >= 0;

# Course records
INSERT INTO `Course` VALUES (0, 'CS360', 4);
INSERT INTO `Course` VALUES (1, 'CS257', 4);
INSERT INTO `Course` VALUES (2, 'PE180', 1);

#Student records
INSERT INTO `Student` (`id`, `name`) VALUES (0, 'Jimbob ');
INSERT INTO `Student` (`id`, `name`) VALUES (1, 'Jane');
INSERT INTO `Student` (`id`, `name`) VALUES (2, 'Herman');
INSERT INTO `Student` (`id`, `name`) VALUES (3, 'HermanBob');
INSERT INTO `Student` (`id`, `name`) VALUES (4, 'IronMan');

# Schedule records
INSERT INTO `Schedule` (`id`, `crn`) VALUES (1, 0);
INSERT INTO `Schedule` (`id`, `crn`) VALUES (1, 1);
INSERT INTO `Schedule` (`id`, `crn`) VALUES (2, 1);
INSERT INTO `Schedule` (`id`, `crn`) VALUES (2, 2);
INSERT INTO `Schedule` (`id`, `crn`) VALUES (3, 1);
INSERT INTO `Schedule` (`id`, `crn`) VALUES (4, 2);
