View | Details | Raw Unified | Return to bug 32918
Collapse All | Expand All

(-)a/installer/data/mysql/en/mandatory/auth_values.yml (+151 lines)
Lines 57-62 tables: Link Here
57
        - category: "HSBND_FREQ"
57
        - category: "HSBND_FREQ"
58
          authorised_value: "EW"
58
          authorised_value: "EW"
59
          lib: "Every week"
59
          lib: "Every week"
60
      #ERM
61
        - category: "ERM_AGREEMENT_STATUS"
62
          authorised_value: "active"
63
          lib: "Active"
64
        - category: "ERM_AGREEMENT_STATUS"
65
          authorised_value: "in_negotiation"
66
          lib: "In negotiation"
67
        - category: "ERM_AGREEMENT_STATUS"
68
          authorised_value: "closed"
69
          lib: "Closed"
70
        - category: "ERM_AGREEMENT_CLOSURE_REASON"
71
          authorised_value: "expired"
72
          lib: "Expired"
73
        - category: "ERM_AGREEMENT_CLOSURE_REASON"
74
          authorised_value: "cancelled"
75
          lib: "Cancelled"
76
        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
77
          authorised_value: "for_review"
78
          lib: "For review"
79
        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
80
          authorised_value: "renew"
81
          lib: "Renew"
82
        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
83
          authorised_value: "cancel"
84
          lib: "Cancel"
85
        - category: "ERM_USER_ROLES"
86
          authorised_value: "librarian"
87
          lib: "ERM librarian"
88
        - category: "ERM_USER_ROLES"
89
          authorised_value: "subject_specialist"
90
          lib: "Subject specialist"
91
        - category: "ERM_LICENSE_TYPE"
92
          authorised_value: "local"
93
          lib: "Local"
94
        - category: "ERM_LICENSE_TYPE"
95
          authorised_value: "consortial"
96
          lib: "Consortial"
97
        - category: "ERM_LICENSE_TYPE"
98
          authorised_value: "national"
99
          lib: "National"
100
        - category: "ERM_LICENSE_TYPE"
101
          authorised_value: "alliance"
102
          lib: "Alliance"
103
        - category: "ERM_LICENSE_STATUS"
104
          authorised_value: "in_negotiation"
105
          lib: "In negotiation"
106
        - category: "ERM_LICENSE_STATUS"
107
          authorised_value: "not_yet_active"
108
          lib: "Not yet active"
109
        - category: "ERM_LICENSE_STATUS"
110
          authorised_value: "active"
111
          lib: "Active"
112
        - category: "ERM_LICENSE_STATUS"
113
          authorised_value: "rejected"
114
          lib: "Rejected"
115
        - category: "ERM_LICENSE_STATUS"
116
          authorised_value: "expired"
117
          lib: "Expired"
118
        - category: "ERM_AGREEMENT_LICENSE_STATUS"
119
          authorised_value: "controlling"
120
          lib: "Controlling"
121
        - category: "ERM_AGREEMENT_LICENSE_STATUS"
122
          authorised_value: "future"
123
          lib: "Future"
124
        - category: "ERM_AGREEMENT_LICENSE_STATUS"
125
          authorised_value: "history"
126
          lib: "Historic"
127
        - category: "ERM_AGREEMENT_LICENSE_LOCATION"
128
          authorised_value: "filing_cabinet"
129
          lib: "Filing cabinet"
130
        - category: "ERM_AGREEMENT_LICENSE_LOCATION"
131
          authorised_value: "cupboard"
132
          lib: "Cupboard"
133
        - category: "ERM_PACKAGE_TYPE"
134
          authorised_value: "local"
135
          lib: "Local"
136
        - category: "ERM_PACKAGE_TYPE"
137
          authorised_value: "complete"
138
          lib: "Complete"
139
        - category: "ERM_PACKAGE_CONTENT_TYPE"
140
          authorised_value: "AggregatedFullText"
141
          lib: "Aggregated full"
142
        - category: "ERM_PACKAGE_CONTENT_TYPE"
143
          authorised_value: "AbstractAndIndex"
144
          lib: "Abstract and index"
145
        - category: "ERM_PACKAGE_CONTENT_TYPE"
146
          authorised_value: "EBook"
147
          lib: "E-book"
148
        - category: "ERM_PACKAGE_CONTENT_TYPE"
149
          authorised_value: "MixedContent"
150
          lib: "Mixed content"
151
        - category: "ERM_PACKAGE_CONTENT_TYPE"
152
          authorised_value: "EJournal"
153
          lib: "E-journal"
154
        - category: "ERM_PACKAGE_CONTENT_TYPE"
155
          authorised_value: "OnlineReference"
156
          lib: "Online reference"
157
        - category: "ERM_PACKAGE_CONTENT_TYPE"
158
          authorised_value: "Print"
159
          lib: "Print"
160
        - category: "ERM_PACKAGE_CONTENT_TYPE"
161
          authorised_value: "StreamingMedia"
162
          lib: "Streaming media"
163
        - category: "ERM_PACKAGE_CONTENT_TYPE"
164
          authorised_value: "Unknown"
165
          lib: "Unknown"
166
        - category: "ERM_TITLE_PUBLICATION_TYPE"
167
          authorised_value: "journal"
168
          lib: "Journal"
169
        - category: "ERM_TITLE_PUBLICATION_TYPE"
170
          authorised_value: "newsletter"
171
          lib: "Newsletter"
172
        - category: "ERM_TITLE_PUBLICATION_TYPE"
173
          authorised_value: "report"
174
          lib: "Report"
175
        - category: "ERM_TITLE_PUBLICATION_TYPE"
176
          authorised_value: "proceedings"
177
          lib: "Proceedings"
178
        - category: "ERM_TITLE_PUBLICATION_TYPE"
179
          authorised_value: "website"
180
          lib: "Website"
181
        - category: "ERM_TITLE_PUBLICATION_TYPE"
182
          authorised_value: "newspaper"
183
          lib: "Newspaper"
184
        - category: "ERM_TITLE_PUBLICATION_TYPE"
185
          authorised_value: "unspecified"
186
          lib: "Unspecified"
187
        - category: "ERM_TITLE_PUBLICATION_TYPE"
188
          authorised_value: "book"
189
          lib: "Book"
190
        - category: "ERM_TITLE_PUBLICATION_TYPE"
191
          authorised_value: "ebook"
192
          lib: "E-book"
193
        - category: "ERM_TITLE_PUBLICATION_TYPE"
194
          authorised_value: "bookseries"
195
          lib: "Bookseries"
196
        - category: "ERM_TITLE_PUBLICATION_TYPE"
197
          authorised_value: "database"
198
          lib: "Database"
199
        - category: "ERM_TITLE_PUBLICATION_TYPE"
200
          authorised_value: "thesisdissertation"
201
          lib: "Thesis/Dissertation"
202
        - category: "ERM_TITLE_PUBLICATION_TYPE"
203
          authorised_value: "streamingaudio"
204
          lib: "Streaming audio"
205
        - category: "ERM_TITLE_PUBLICATION_TYPE"
206
          authorised_value: "streamingvideo"
207
          lib: "Streaming video"
208
        - category: "ERM_TITLE_PUBLICATION_TYPE"
209
          authorised_value: "audiobook"
210
          lib: "AudioBook"
60
211
61
  # Country codes
212
  # Country codes
62
  - authorised_values:
213
  - authorised_values:
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-54 lines)
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
- 

Return to bug 32918