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

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