add_data_stored_procedures.sql

DELIMITER $$

DROP PROCEDURE IF EXISTS AddDorms$$
CREATE PROCEDURE AddDorms()
BEGIN
    INSERT INTO Dorm (name, campusEnd) VALUES ('CLARK-I','NORTH');
    INSERT INTO Dorm (name, campusEnd) VALUES ('CLARK-V', 'NORTH');
    INSERT INTO Dorm (name, campusEnd) VALUES ('LAWRY', 'NORTH');
    INSERT INTO Dorm (name, campusEnd) VALUES ('WALKER', 'NORTH');
    INSERT INTO Dorm (name, campusEnd) VALUES ('SMILEY', 'NORTH');
    INSERT INTO Dorm (name, campusEnd) VALUES ('NORTON-CLARK', 'NORTH');
END $$

DROP PROCEDURE IF EXISTS AddStudents$$
CREATE PROCEDURE AddStudents()
BEGIN
    INSERT INTO STUDENT (emailID, name, year, drawNum, drawGroup) VALUES ('hpaa2018', 'Helen Paulini', 3, 810, 6);
    INSERT INTO STUDENT (emailID, name, year, drawNum, drawGroup) VALUES ('ymac2018', 'Yurie Muramatsu', 2, 635, 7);
    INSERT INTO STUDENT (emailID, name, year, drawNum, drawGroup) VALUES ('ayza2018', 'Alan Zhou', 2, 844, 6);
    INSERT INTO STUDENT (emailID, name, year, drawNum, drawGroup) VALUES ('gpaa2018', 'Gabe Alzate', 3, 150, 1);
END $$

DELIMITER ;