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

(-)a/installer/data/mysql/it-IT/necessari/auth_val.sql (-9 / +11 lines)
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;
(-)a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql (-1 / +2 lines)
Lines 3-9 Link Here
3
3
4
LOCK TABLES `creator_layouts` WRITE;
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6
INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
6
INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES 
7
(1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
7
(2,'CODE39',1,'BAR','Test etic. (BAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
8
(2,'CODE39',1,'BAR','Test etic. (BAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
8
(3,'CODE39',1,'BAR','Test tessere',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
9
(3,'CODE39',1,'BAR','Test tessere',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
9
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
10
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
(-)a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql (-7 / +7 lines)
Lines 1-12 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
1
SET FOREIGN_KEY_CHECKS=0;
2
2
3
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',5,0,'bridge/book.gif','');
3
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.gif','');
4
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',5,0,'bridge/kit.gif','');
4
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.gif','');
5
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
5
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.gif','');
6
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',5,0,'bridge/map.gif','');
6
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.gif','');
7
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',5,1,'bridge/dvd.gif','');
7
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.gif','');
8
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',5,0,'bridge/sound.gif','');
8
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.gif','');
9
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',5,0,'bridge/periodical.gif','');
9
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.gif','');
10
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');
10
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');
11
11
12
SET FOREIGN_KEY_CHECKS=1;
12
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql (-1 / +1 lines)
Lines 9-15 VALUES Link Here
9
    NULL, NULL, NULL, NULL, NULL, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
11
12
    ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Number {Y}, Issue {Z}',
12
    ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Num. {Y}, Fasc. {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
15
    'Issue', 1, 1, 4, 1, NULL),
(-)a/installer/data/mysql/it-IT/necessari/system_preferences.sql (-16 / +7 lines)
Lines 20-67 UPDATE systempreferences SET value = 'cataloguing' WHERE variable = 'AcqCreateIt Link Here
20
UPDATE systempreferences SET value = '1' WHERE variable = 'AllowRenewalLimitOverride';
20
UPDATE systempreferences SET value = '1' WHERE variable = 'AllowRenewalLimitOverride';
21
UPDATE systempreferences SET value = 'annual' WHERE variable = 'autoBarcode';
21
UPDATE systempreferences SET value = 'annual' WHERE variable = 'autoBarcode';
22
UPDATE systempreferences SET value = 'email' WHERE variable = 'AutoEmailPrimaryAddress';
22
UPDATE systempreferences SET value = 'email' WHERE variable = 'AutoEmailPrimaryAddress';
23
UPDATE systempreferences SET value = '1' WHERE variable = 'BiblioAddsAuthorities';
23
UPDATE systempreferences SET value = '0' WHERE variable = 'BiblioAddsAuthorities';
24
UPDATE systempreferences SET value = 'city|surname|cardnumber' WHERE variable = 'BorrowerMandatoryField';
24
UPDATE systempreferences SET value = 'surname|cardnumber' WHERE variable = 'BorrowerMandatoryField';
25
UPDATE systempreferences SET value = '0' WHERE variable = 'BorrowersLog';
25
UPDATE systempreferences SET value = '0' WHERE variable = 'BorrowersLog';
26
UPDATE systempreferences SET value = 'Sig|Sig.ra|Sig.na' WHERE variable = 'BorrowersTitles';
26
UPDATE systempreferences SET value = 'Sig|Sig.ra|Sig.na' WHERE variable = 'BorrowersTitles';
27
UPDATE systempreferences SET value = '0' WHERE variable = 'CataloguingLog';
27
UPDATE systempreferences SET value = '0' WHERE variable = 'CataloguingLog';
28
UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat';
28
UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat';
29
UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
29
UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
30
UPDATE systempreferences SET value = 'relevance' WHERE variable = 'defaultSortField';
30
UPDATE systempreferences SET value = 'title' WHERE variable = 'defaultSortField';
31
UPDATE systempreferences SET value = 'asc' WHERE variable = 'defaultSortOrder';
31
UPDATE systempreferences SET value = 'asc' WHERE variable = 'defaultSortOrder';
32
UPDATE systempreferences SET value = '0' WHERE variable = 'FinesLog';
32
UPDATE systempreferences SET value = '0' WHERE variable = 'FinesLog';
33
UPDATE systempreferences SET value = '1' WHERE variable = 'FRBRizeEditions';
34
UPDATE systempreferences SET value = '1' WHERE variable = 'GoogleJackets';
33
UPDATE systempreferences SET value = '1' WHERE variable = 'GoogleJackets';
35
UPDATE systempreferences SET value = '0' WHERE variable = 'IssueLog';
34
UPDATE systempreferences SET value = '0' WHERE variable = 'IssueLog';
36
UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter';
35
UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter';
37
UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
36
UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
38
UPDATE systempreferences SET value = 'koha@cilea.it' WHERE variable = 'KohaAdminEmailAddress';
37
UPDATE systempreferences SET value = 'koha@xxx.it' WHERE variable = 'KohaAdminEmailAddress';
39
UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language';
38
UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language';
40
UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog';
39
UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog';
41
UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode';
40
UPDATE systempreferences SET value = ''  WHERE variable = 'MARCOrgCode';
42
UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves';
41
UPDATE systempreferences SET value = '5' WHERE variable = 'maxreserves';
43
UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities';
42
UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities';
44
UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField';
43
UPDATE systempreferences SET value = 'title' WHERE variable = 'OPACdefaultSortField';
45
UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';
44
UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';
46
UPDATE systempreferences SET value = '1' WHERE variable = 'OPACFRBRizeEditions';
47
UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'opaclanguages';
45
UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'opaclanguages';
48
UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';
46
UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';
49
UPDATE systempreferences SET value = '<h3>Benvenuto !!</h3>' WHERE variable = 'OpacMainUserBlock';
47
UPDATE systempreferences SET value = '<h3>Benvenuto !!</h3>' WHERE variable = 'OpacMainUserBlock';
50
UPDATE systempreferences SET value = 'Links importanti qui.' WHERE variable = 'OpacNav';
48
UPDATE systempreferences SET value = 'Links importanti qui.' WHERE variable = 'OpacNav';
51
UPDATE systempreferences SET value = '0' WHERE variable = 'OPACShelfBrowser';
49
UPDATE systempreferences SET value = '0' WHERE variable = 'OPACShelfBrowser';
52
UPDATE systempreferences SET value = '1' WHERE variable = 'OpacTopissue';
53
UPDATE systempreferences SET value = '1' WHERE variable = 'OPACURLOpenInNewWindow';
50
UPDATE systempreferences SET value = '1' WHERE variable = 'OPACURLOpenInNewWindow';
54
UPDATE systempreferences SET value = 'jpg' WHERE variable = 'patronimages';
55
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryFuzzy';
51
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryFuzzy';
56
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryStemming';
52
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryStemming';
57
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryWeightFields';
53
UPDATE systempreferences SET value = '0' WHERE variable = 'QueryWeightFields';
58
UPDATE systempreferences SET value = '0' WHERE variable = 'ReservesNeedReturns';
59
UPDATE systempreferences SET value = '1' WHERE variable = 'ReturnBeforeExpiry';
60
UPDATE systempreferences SET value = '1' WHERE variable = 'TagsModeration';
54
UPDATE systempreferences SET value = '1' WHERE variable = 'TagsModeration';
61
UPDATE systempreferences SET value = '1' WHERE variable = 'ThingISBN';
62
UPDATE systempreferences SET value = '30600' WHERE variable = 'timeout';
55
UPDATE systempreferences SET value = '30600' WHERE variable = 'timeout';
63
UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
56
UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
64
UPDATE systempreferences SET value = '1' WHERE variable = 'XISBN';
65
57
66
UPDATE systempreferences SET value = '#200|<span style=\"font-weight:bold\">|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|</span>\r\n#210|. &ndash; |{210a}{ : 210c}{, 210d}|\r\n#215|. &ndash; |{215a}{ ; 215d}|\r\n#225|. &ndash; |{(225a}{ ; 225v)}|\r\n#010|. &ndash; |{ISBN 010a}|' WHERE variable = 'ISBD';
58
UPDATE systempreferences SET value = '#200|<span style=\"font-weight:bold\">|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|</span>\r\n#210|. &ndash; |{210a}{ : 210c}{, 210d}|\r\n#215|. &ndash; |{215a}{ ; 215d}|\r\n#225|. &ndash; |{(225a}{ ; 225v)}|\r\n#010|. &ndash; |{ISBN 010a}|' WHERE variable = 'ISBD';
67
59
68
- 

Return to bug 15178