Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Inserting some test Authors
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (1, "Alex", "Chan", "Woodeward Hall", "Chanimal@gmail.com", "Dartmouth");
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (2, "Steven", "Jiang", "1 Webster Avenue", "SJ@dartmouth.edu", "Dartmouth");
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (3, "Ted", "Bausch", "6 Smith Avenue", "TD@dartmouth.edu", "Dartmouth");
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (4, "Dan", "Lein", "1 Webster Avenue", "bigshow@yahoo.com", "toysRus");
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (5, "Re", "McLendon", "Triangle Avenue", "Redawg@gmail.edu", "Collis");
- INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (6, "fake first name", "fake last name", "1 Webster Avenue", "2ndTierschool.edu", "Fake affiliation");
- --Inserting some test editors
- INSERT INTO Editor(idEditor, firstName, lastName) VALUES (1, "Al", "Forbes");
- INSERT INTO Editor(idEditor, firstName, lastName) VALUES (2, "ted", "poatsy");
- INSERT INTO Editor(idEditor, firstName, lastName) VALUES (3, "johnny", "emm");
- INSERT INTO Editor(idEditor, firstName, lastName) VALUES (4, "kuroosh", "sagin");
- -- Inserting RICodes
- INSERT INTO RICode(idRICODE) VALUES(1);
- INSERT INTO RICode(idRICODE) VALUES(2);
- INSERT INTO RICode(idRICODE) VALUES(3);
- INSERT INTO RICode(idRICODE) VALUES(4);
- -- Inserting Test Issues
- INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (1, 2017, 1, NOW());
- INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (2, 2011, 3, NOW());
- INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (3, 2012, 3, NOW());
- INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (4, 1998, 1, NOW());
- INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (5, 3000, 4, NOW());
- -- Inserting Test Reviewers
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "Matt", "Vance", "MVp@gmail.com", 1);
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "R1", "R1", "wowwow.com", 1);
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "R2", "wow", "not_real.com", 1);
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "fakeReviewer3", "Vance", "fake.com", 2);
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "george", "bush", "MVp@gmail.com", 3);
- INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "bayrock", "Ohbahma", "POTUS@gmail.com", 1776);
- -- Inserting Test Interest Groups
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (1, 1);
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (1, 2);
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (1, 3);
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (3, 1);
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (3, 2);
- INSERT INTO InterestGroup(RICode, idReviewer) VALUES (11, 10);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement