|
Lines 5-17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST
Link Here
|
| 5 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); |
5 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); |
| 6 |
|
6 |
|
| 7 |
-- availability statuses |
7 |
-- availability statuses |
| 8 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); |
8 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Długo przetrzymywany (Zagubiony)'); |
| 9 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); |
9 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Zagubiony'); |
| 10 |
INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); |
10 |
INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Zagubiony i opłacony'); |
| 11 |
INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); |
11 |
INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Zaginiony'); |
| 12 |
|
12 |
|
| 13 |
-- damaged status of an item |
13 |
-- damaged status of an item |
| 14 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); |
14 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Uszkodzony'); |
| 15 |
|
15 |
|
| 16 |
-- location qualification for an item, departments are linked by default to items.location |
16 |
-- location qualification for an item, departments are linked by default to items.location |
| 17 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction'); |
17 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction'); |
|
Lines 22-27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC',
Link Here
|
| 22 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks'); |
22 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks'); |
| 23 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual'); |
23 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual'); |
| 24 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference'); |
24 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference'); |
|
|
25 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart'); |
| 26 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center'); |
| 25 |
|
27 |
|
| 26 |
-- collection codes for an item |
28 |
-- collection codes for an item |
| 27 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); |
29 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); |
|
Lines 29-43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE
Link Here
|
| 29 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); |
31 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); |
| 30 |
|
32 |
|
| 31 |
-- withdrawn status of an item, linked to items.withdrawn |
33 |
-- withdrawn status of an item, linked to items.withdrawn |
| 32 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); |
34 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Wycofany'); |
| 33 |
|
35 |
|
| 34 |
-- loanability status of an item, linked to items.notforloan |
36 |
-- loanability status of an item, linked to items.notforloan |
| 35 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); |
37 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Zamówiony'); |
| 36 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); |
38 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nie do wypożyczenia'); |
| 37 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); |
39 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Zasób pracowniczy'); |
| 38 |
|
40 |
|
| 39 |
-- restricted status of an item, linked to items.restricted |
41 |
-- restricted status of an item, linked to items.restricted |
| 40 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); |
42 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Ograniczony dostęp'); |
|
|
43 |
|
| 44 |
-- manual invoice types |
| 45 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Opłata za ksero','.25'); |
| 46 |
|
| 47 |
-- custom borrower notes |
| 48 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Uwagi do adresu'); |
| 49 |
|
| 50 |
-- OPAC Suggestions reasons |
| 51 |
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged'); |
| 52 |
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author'); |
| 53 |
|
| 54 |
-- Report groups |
| 55 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Udostępnianie'); |
| 56 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog'); |
| 57 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Uzytkownicy'); |
| 58 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Gromadzenie'); |
| 59 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Konta'); |
| 41 |
|
60 |
|
| 42 |
-- SIP2 media types |
61 |
-- SIP2 media types |
| 43 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); |
62 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); |