Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
ETD Framework setup support file (SQL)
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`, `lib_opac`, `imageurl`) VALUES
('856Q_LIST', 'text/html', 'text/html', 'text/html', ''),
('856Q_LIST', 'application/pdf', 'Adobe PDF (.pdf)', 'Adobe PDF (.pdf)', ''),
('856Q_LIST', 'application/msword', 'MS-Word (.doc / .docx)', 'MS-Word (.doc / .docx)', ''),
('856Q_LIST', 'jpeg', 'JPEG image (.jpg / .jpeg)', 'JPEG image (.jpg / .jpeg)', ''),
('856Q_LIST', 'application/vnd.ms-excel', 'MS-Excel (.xls / .xlsx)', 'MS-Excel (.xls / .xlsx)', ''),
('DEG_NAME', 'Master of Science', 'Master of Science', 'Master of Science', ''),
('DEG_NAME', 'Doctor of Education', 'Doctor of Education', 'Doctor of Education', ''),
('DEG_NAME', 'Doctor of Philosophy', 'Doctor of Philosophy', 'Doctor of Philosophy', ''),
('DEG_ROLES', 'GS', 'Guide / Supervisor', 'Guide / Supervisor', ''),
('DEG_ROLES', 'CG', 'Co-Guide / Co-Supervisor', 'Co-Guide / Co-Supervisor', ''),
('DEG_ROLES', 'CM', 'Committee Member', 'Committee Member', ''),
('DEG_TYPE', '0', 'Undergraduate (pre-masters)', 'Undergraduate (pre-masters)', ''),
('DEG_TYPE', '1', 'Masters (pre-doctoral)', 'Masters (pre-doctoral)', ''),
('DEG_TYPE', '2', 'Doctoral (includes post-doctoral)', 'Doctoral (includes post-doctoral)', '');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment