|
Lines 30-35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','S
Link Here
|
| 30 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale'); |
30 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale'); |
| 31 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo'); |
31 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo'); |
| 32 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference'); |
32 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference'); |
|
|
33 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','CART','Scaffale smistamento'); |
| 34 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','PROC','Centro lavorazione'); |
| 33 |
|
35 |
|
| 34 |
-- collection codes for an item |
36 |
-- collection codes for an item |
| 35 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); |
37 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); |
|
Lines 85-91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_
Link Here
|
| 85 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Utenti'); |
87 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Utenti'); |
| 86 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisizione'); |
88 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisizione'); |
| 87 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts'); |
89 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts'); |
| 88 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Serials'); |
90 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Seriali'); |
| 89 |
|
91 |
|
| 90 |
-- SIP2 media types |
92 |
-- SIP2 media types |
| 91 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); |
93 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other'); |
|
Lines 101-115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED
Link Here
|
| 101 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette'); |
103 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette'); |
| 102 |
|
104 |
|
| 103 |
-- order cancellation reasons |
105 |
-- order cancellation reasons |
| 104 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); |
106 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'Nessuna ragione fornita'); |
| 105 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); |
107 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Fuori mercato'); |
| 106 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); |
108 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'In ristampa'); |
| 107 |
|
109 |
|
| 108 |
-- Desired formats for requesting new materials |
110 |
-- Desired formats for requesting new materials |
| 109 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); |
111 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Libro', 'Libro'); |
| 110 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); |
112 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'A caratteri ingranditi', 'A caratteri ingranditi'); |
| 111 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); |
113 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'Ebook', 'Ebook'); |
| 112 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); |
114 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiolibro', 'Audiolibro'); |
| 113 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); |
115 |
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); |
| 114 |
|
116 |
|
| 115 |
SET FOREIGN_KEY_CHECKS=1; |
117 |
SET FOREIGN_KEY_CHECKS=1; |