Lines 1-18
Link Here
|
1 |
-- Reasons for acceptance or rejection of suggestions in acquisitions |
1 |
-- Reasons for acceptance or rejection of suggestions in acquisitions |
2 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller'); |
2 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller'); |
3 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt'); |
3 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt'); |
4 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Biblitoheksexemplar vermisst'); |
4 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotheksexemplar vermisst'); |
5 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Über Fernleihe bestellbar'); |
5 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Über Fernleihe bestellbar'); |
6 |
|
6 |
|
7 |
-- availability statuses |
7 |
-- availability statuses |
8 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); |
|
|
9 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)'); |
8 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)'); |
10 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren'); |
9 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren'); |
11 |
INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt'); |
10 |
INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt'); |
12 |
INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Vermisst'); |
11 |
INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Vermisst'); |
13 |
|
12 |
|
14 |
-- damaged status of an item |
13 |
-- damaged status of an item |
15 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); |
|
|
16 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt'); |
14 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt'); |
17 |
|
15 |
|
18 |
-- 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 |
Lines 33-49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE
Link Here
|
33 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur'); |
31 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur'); |
34 |
|
32 |
|
35 |
-- withdrawn status of an item, linked to items.wthdrawn |
33 |
-- withdrawn status of an item, linked to items.wthdrawn |
36 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); |
|
|
37 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden'); |
34 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden'); |
38 |
|
35 |
|
39 |
-- loanability status of an item, linked to items.notforloan |
36 |
-- loanability status of an item, linked to items.notforloan |
40 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt'); |
37 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt'); |
41 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); |
|
|
42 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar'); |
38 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar'); |
43 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek'); |
39 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek'); |
44 |
|
40 |
|
45 |
-- restricted status of an item, linked to items.restricted |
41 |
-- restricted status of an item, linked to items.restricted |
46 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); |
|
|
47 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich'); |
42 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich'); |
48 |
|
43 |
|
49 |
-- manual invoice types |
44 |
-- manual invoice types |