Lines 30-36
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 |
|
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'); |
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'); |
36 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference'); |
38 |
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference'); |
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; |