|
Lines 87-142
VALUES
Link Here
|
| 87 |
('ERM_PACKAGE_TYPE', 1), |
87 |
('ERM_PACKAGE_TYPE', 1), |
| 88 |
('ERM_PACKAGE_CONTENT_TYPE', 1), |
88 |
('ERM_PACKAGE_CONTENT_TYPE', 1), |
| 89 |
('ERM_TITLE_PUBLICATION_TYPE', 1); |
89 |
('ERM_TITLE_PUBLICATION_TYPE', 1); |
| 90 |
|
|
|
| 91 |
INSERT IGNORE INTO authorised_values (category, authorised_value, lib) |
| 92 |
VALUES |
| 93 |
('ERM_AGREEMENT_STATUS', 'active', 'Active'), |
| 94 |
('ERM_AGREEMENT_STATUS', 'in_negotiation', 'In negotiation'), |
| 95 |
('ERM_AGREEMENT_STATUS', 'closed', 'Closed'), |
| 96 |
('ERM_AGREEMENT_CLOSURE_REASON', 'expired', 'Expired'), |
| 97 |
('ERM_AGREEMENT_CLOSURE_REASON', 'cancelled', 'Cancelled'), |
| 98 |
('ERM_AGREEMENT_RENEWAL_PRIORITY', 'for_review', 'For review'), |
| 99 |
('ERM_AGREEMENT_RENEWAL_PRIORITY', 'renew', 'Renew'), |
| 100 |
('ERM_AGREEMENT_RENEWAL_PRIORITY', 'cancel', 'Cancel'), |
| 101 |
('ERM_USER_ROLES', 'librarian', 'ERM librarian'), |
| 102 |
('ERM_USER_ROLES', 'subject_specialist', 'Subject specialist'), |
| 103 |
('ERM_LICENSE_TYPE', 'local', 'Local'), |
| 104 |
('ERM_LICENSE_TYPE', 'consortial', 'Consortial'), |
| 105 |
('ERM_LICENSE_TYPE', 'national', 'National'), |
| 106 |
('ERM_LICENSE_TYPE', 'alliance', 'Alliance'), |
| 107 |
('ERM_LICENSE_STATUS', 'in_negotiation', 'In negotiation'), |
| 108 |
('ERM_LICENSE_STATUS', 'not_yet_active', 'Not yet active'), |
| 109 |
('ERM_LICENSE_STATUS', 'active', 'Active'), |
| 110 |
('ERM_LICENSE_STATUS', 'rejected', 'Rejected'), |
| 111 |
('ERM_LICENSE_STATUS', 'expired', 'Expired'), |
| 112 |
('ERM_AGREEMENT_LICENSE_STATUS', 'controlling', 'Controlling'), |
| 113 |
('ERM_AGREEMENT_LICENSE_STATUS', 'future', 'Future'), |
| 114 |
('ERM_AGREEMENT_LICENSE_STATUS', 'history', 'Historic'), |
| 115 |
('ERM_AGREEMENT_LICENSE_LOCATION', 'filing_cabinet', 'Filing cabinet'), |
| 116 |
('ERM_AGREEMENT_LICENSE_LOCATION', 'cupboard', 'Cupboard'), |
| 117 |
('ERM_PACKAGE_TYPE', 'local', 'Local'), |
| 118 |
('ERM_PACKAGE_TYPE', 'complete', 'Complete'), |
| 119 |
('ERM_PACKAGE_CONTENT_TYPE', 'AggregatedFullText', 'Aggregated full'), |
| 120 |
('ERM_PACKAGE_CONTENT_TYPE', 'AbstractAndIndex', 'Abstract and index'), |
| 121 |
('ERM_PACKAGE_CONTENT_TYPE', 'EBook', 'E-book'), |
| 122 |
('ERM_PACKAGE_CONTENT_TYPE', 'MixedContent', 'Mixed content'), |
| 123 |
('ERM_PACKAGE_CONTENT_TYPE', 'EJournal', 'E-journal'), |
| 124 |
('ERM_PACKAGE_CONTENT_TYPE', 'OnlineReference', 'Online reference'), |
| 125 |
('ERM_PACKAGE_CONTENT_TYPE', 'Print', 'Print'), |
| 126 |
('ERM_PACKAGE_CONTENT_TYPE', 'StreamingMedia', 'Streaming media'), |
| 127 |
('ERM_PACKAGE_CONTENT_TYPE', 'Unknown', 'Unknown'), |
| 128 |
('ERM_TITLE_PUBLICATION_TYPE', 'journal', 'Journal'), |
| 129 |
('ERM_TITLE_PUBLICATION_TYPE', 'newsletter', 'Newsletter'), |
| 130 |
('ERM_TITLE_PUBLICATION_TYPE', 'report', 'Report'), |
| 131 |
('ERM_TITLE_PUBLICATION_TYPE', 'proceedings', 'Proceedings'), |
| 132 |
('ERM_TITLE_PUBLICATION_TYPE', 'website', 'Website'), |
| 133 |
('ERM_TITLE_PUBLICATION_TYPE', 'newspaper', 'Newspaper'), |
| 134 |
('ERM_TITLE_PUBLICATION_TYPE', 'unspecified', 'Unspecified'), |
| 135 |
('ERM_TITLE_PUBLICATION_TYPE', 'book', 'Book'), |
| 136 |
('ERM_TITLE_PUBLICATION_TYPE', 'ebook', 'E-book'), |
| 137 |
('ERM_TITLE_PUBLICATION_TYPE', 'bookseries', 'Bookseries'), |
| 138 |
('ERM_TITLE_PUBLICATION_TYPE', 'database', 'Database'), |
| 139 |
('ERM_TITLE_PUBLICATION_TYPE', 'thesisdissertation', 'Thesis/Dissertation'), |
| 140 |
('ERM_TITLE_PUBLICATION_TYPE', 'streamingaudio', 'Streaming audio'), |
| 141 |
('ERM_TITLE_PUBLICATION_TYPE', 'streamingvideo', 'Streaming video'), |
| 142 |
('ERM_TITLE_PUBLICATION_TYPE', 'audiobook', 'AudioBook'); |
| 143 |
- |