populate_role.sql

-- Make Alex Broaddus an admin
INSERT INTO role VALUES (
    43782859, 'system-admin'
);

-- Make Narahari and Choi instructors
INSERT INTO role VALUES (
    10101010, 'faculty'
);

INSERT INTO role VALUES (
    12121212, 'faculty'
);

INSERT INTO role VALUES (
    10101010, 'advisor'
);

INSERT INTO role VALUES (
    16161616, 'advisor'
);

INSERT INTO role VALUES (
    13131313, 'gs'
);

-- Make Billie Holiday and Diana Krall students
INSERT INTO role VALUES (
    88888888, 'student'
);

INSERT INTO role VALUES (
    88888888, 'master'
);

INSERT INTO role VALUES (
    99999999, 'student'
);

INSERT INTO role VALUES (
    99999999, 'master'
);

INSERT INTO role VALUES (
    23456789, 'student'
);

INSERT INTO role VALUES (
    23456789, 'phd'
);

INSERT INTO role VALUES (
    87654321, 'student'
);

INSERT INTO role VALUES (
    87654321, 'master'
);

INSERT INTO role VALUES (
    45678901, 'student'
);

INSERT INTO role VALUES (
    45678901, 'master'
);

INSERT INTO role VALUES (
    55555555, 'student'
);

INSERT INTO role VALUES (
    55555555, 'master'
);

INSERT INTO role VALUES (
    66666666, 'student'
);

INSERT INTO role VALUES (
    66666666, 'master'
);

INSERT INTO role VALUES (
    12345678, 'student'
);

INSERT INTO role VALUES (
    12345678, 'phd'
);

INSERT INTO role VALUES (
    77777777, 'alumni'
);

INSERT INTO role VALUES (
    77777777, 'master'
);

INSERT INTO role VALUES (
    34567890, 'alumni'
);

INSERT INTO role VALUES (
    34567890, 'phd'
);

INSERT INTO role VALUES (
    66661111, 
    'applicant'
);

INSERT INTO role VALUES (
    55551111, 
    'applicant'
);

INSERT INTO role VALUES (
    00001234, 
    'applicant'
);

INSERT INTO role VALUES (
    00001235, 
    'applicant'
);

INSERT INTO role VALUES (
    00001236, 
    'applicant'
);

INSERT INTO role VALUES (
    45454545,
    'cac'
);