Attachment #170967 for bug #27490

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

Lines 36-41 UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWee Link Here

(-)a/installer/data/mysql/localization/de-DE/custom.sql (-1 / +1 lines)
36	UPDATE systempreferences SET value = '0.07\|0.19\|0.00' WHERE variable = 'TaxRates';	36	UPDATE systempreferences SET value = '0.07\|0.19\|0.00' WHERE variable = 'TaxRates';
37	UPDATE systempreferences SET value = 'Dieser Text wird über den Systemparameter <a href="/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped">RoutingListNote</a> konfiguriert.' where variable = 'RoutingListNote';	37	UPDATE systempreferences SET value = 'Dieser Text wird über den Systemparameter <a href="/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped">RoutingListNote</a> konfiguriert.' where variable = 'RoutingListNote';
38	UPDATE systempreferences SET value = 'barcode stocknumber' WHERE variable = 'uniqueitemfields';	38	UPDATE systempreferences SET value = 'barcode stocknumber' WHERE variable = 'uniqueitemfields';
39	UPDATE systempreferences SET value = 'de-DE,en' WHERE variable = 'language';	39	UPDATE systempreferences SET value = 'de-DE,en' WHERE variable = 'StaffInterfaceLanguages';
40	UPDATE systempreferences SET value = 'de-DE,en' WHERE variable = 'OPACLanguages';	40	UPDATE systempreferences SET value = 'de-DE,en' WHERE variable = 'OPACLanguages';
41	UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';	41	UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';

Lines 23-30 UPDATE systempreferences SET value = 'M.\|Mme\|Mx' WHERE variable = 'BorrowersTitl Link Here

(-)a/installer/data/mysql/localization/fr-CA/custom.sql (-2 / +2 lines)
23	UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';	23	UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';
24	UPDATE systempreferences SET value = 'iso' WHERE variable = 'dateformat';	24	UPDATE systempreferences SET value = 'iso' WHERE variable = 'dateformat';
25	UPDATE systempreferences SET value = 'fr' WHERE variable = 'KohaManualLanguage';	25	UPDATE systempreferences SET value = 'fr' WHERE variable = 'KohaManualLanguage';
26	UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'language';	26	UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'StaffInterfaceLanguages';
27	UPDATE systempreferences SET value = 'http://www.marc21.ca/MaJ/BIB/B{FIELD}.pdf' WHERE variable = 'MarcFieldDocURL';	27	UPDATE systempreferences SET value = 'http://www.marc21.ca/MaJ/BIB/B{FIELD}.pdf' WHERE variable = 'MarcFieldDocURL';
28	UPDATE systempreferences SET value = 'pdfformat::layout3pagesfr' WHERE variable = 'OrderPdfFormat';	28	UPDATE systempreferences SET value = 'pdfformat::layout3pagesfr' WHERE variable = 'OrderPdfFormat';
29	UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'OPACLanguages';	29	UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'OPACLanguages';
30	UPDATE systempreferences SET value = '0\|0.05\|0.09975\|0.14975' WHERE variable = 'TaxRates';	30	UPDATE systempreferences SET value = '0\|0.05\|0.09975\|0.14975' WHERE variable = 'TaxRates';

Lines 1-7 Link Here

(-)a/installer/data/mysql/localization/fr-FR/custom.sql (-1 / +1 lines)
1	UPDATE systempreferences SET value = 'Père\|Mère\|grand-parent\|Tuteur légal\|Autre' WHERE variable = 'borrowerRelationship';	1	UPDATE systempreferences SET value = 'Père\|Mère\|grand-parent\|Tuteur légal\|Autre' WHERE variable = 'borrowerRelationship';
2	UPDATE systempreferences SET value = 'M\|Mme\|Mlle' WHERE variable = 'BorrowersTitles';	2	UPDATE systempreferences SET value = 'M\|Mme\|Mlle' WHERE variable = 'BorrowersTitles';
3	UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';	3	UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
4	UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'language';	4	UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'StaffInterfaceLanguages';
5	UPDATE systempreferences SET value = 'Ma bibliothèque' WHERE variable = 'LibraryName';	5	UPDATE systempreferences SET value = 'Ma bibliothèque' WHERE variable = 'LibraryName';
6	UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'OPACLanguages';	6	UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'OPACLanguages';
7	UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay';	7	UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay';

Lines 40-46 UPDATE systempreferences SET value = '0' WHERE variable = 'IssueLog'; Link Here

(-)a/installer/data/mysql/localization/it-IT/custom.sql (-1 / +1 lines)
40	UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter';	40	UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter';
41	UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';	41	UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
42	UPDATE systempreferences SET value = 'koha@xxx.it' WHERE variable = 'KohaAdminEmailAddress';	42	UPDATE systempreferences SET value = 'koha@xxx.it' WHERE variable = 'KohaAdminEmailAddress';
43	UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language';	43	UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'StaffInterfaceLanguages';
44	UPDATE systempreferences SET value = '0' WHERE variable = 'ClaimsLog';	44	UPDATE systempreferences SET value = '0' WHERE variable = 'ClaimsLog';
45	UPDATE systempreferences SET value = '' WHERE variable = 'MARCOrgCode';	45	UPDATE systempreferences SET value = '' WHERE variable = 'MARCOrgCode';
46	UPDATE systempreferences SET value = '5' WHERE variable = 'maxreserves';	46	UPDATE systempreferences SET value = '5' WHERE variable = 'maxreserves';

Lines 21-27 UPDATE systempreferences SET value = 'far\|mor' WHERE variable = 'borrowerRelatio Link Here

(-)a/installer/data/mysql/localization/nb-NO/custom.sql (-1 / +1 lines)
21	UPDATE systempreferences SET value = 'Fru\|Frøken\|Herr' WHERE variable = 'BorrowersTitles';	21	UPDATE systempreferences SET value = 'Fru\|Frøken\|Herr' WHERE variable = 'BorrowersTitles';
22	UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat';	22	UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat';
23	UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';	23	UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
24	UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'language';	24	UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'StaffInterfaceLanguages';
25	UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'OPACLanguages';	25	UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'OPACLanguages';
26	UPDATE systempreferences SET value = '<p>Velkommen til Koha...</p><hr />' WHERE variable = 'OpacMainUserBlock';	26	UPDATE systempreferences SET value = '<p>Velkommen til Koha...</p><hr />' WHERE variable = 'OpacMainUserBlock';
27	UPDATE systempreferences SET value = '<p>Viktige lenker kan plasseres her</p>' WHERE variable = 'OpacNav';	27	UPDATE systempreferences SET value = '<p>Viktige lenker kan plasseres her</p>' WHERE variable = 'OpacNav';

Lines 38-44 INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rul Link Here

(-)a/installer/data/mysql/localization/ru-RU/custom.sql (-2 / +1 lines)
38	UPDATE systempreferences SET value = 'Господин\|Госпожа\|Мистер\|Миссис\|Уважаемый\|Уважаемая\|Товарищ\|Добродий\|Добродийка' WHERE variable = 'BorrowersTitles';	38	UPDATE systempreferences SET value = 'Господин\|Госпожа\|Мистер\|Миссис\|Уважаемый\|Уважаемая\|Товарищ\|Добродий\|Добродийка' WHERE variable = 'BorrowersTitles';
39	UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';	39	UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
40	UPDATE systempreferences SET value = 'udc' WHERE variable = 'DefaultClassificationSource';	40	UPDATE systempreferences SET value = 'udc' WHERE variable = 'DefaultClassificationSource';
41	UPDATE systempreferences SET value = 'ru-RU,uk-UA,en,fr-FR,de-DE' WHERE variable = 'language';	41	UPDATE systempreferences SET value = 'ru-RU,uk-UA,en,fr-FR,de-DE' WHERE variable = 'StaffInterfaceLanguages';
42	UPDATE systempreferences SET value = 'ru-RU,uk-UA,en,fr-FR,de-DE' WHERE variable = 'OPACLanguages';	42	UPDATE systempreferences SET value = 'ru-RU,uk-UA,en,fr-FR,de-DE' WHERE variable = 'OPACLanguages';
43		43
44	UPDATE systempreferences SET value = '#200\|<h2>Заглавие: \|{200a}{. 200c}{ : 200e}{200d}{. 200h}{. 200i}\|</h2>\r\n#500\|<label class="ipt">Унифицированое заглавие: </label>\|{500a}{. 500i}{. 500h}{. 500m}{. 500q}{. 500k}<br/>\|\r\n#517\|<label class="ipt"> </label>\|{517a}{ : 517e}{. 517h}{, 517i}<br/>\|\r\n#541\|<label class="ipt"> </label>\|{541a}{ : 541e}<br/>\|\r\n#200\|\|<label class="ipt">Автора: </label><br/>\|\r\n#700\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7009}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{700c}{ 700b}{ 700a}{ 700d}{ (700f)}{. 7004}<br/>\|\r\n#701\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7019}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{701c}{ 701b}{ 701a}{ 701d}{ (701f)}{. 7014}<br/>\|\r\n#702\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7029}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{702c}{ 702b}{ 702a}{ 702d}{ (702f)}{. 7024}<br/>\|\r\n#710\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7109}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{710a}{ (710c)}{. 710b}{ : 710d}{ ; 710f}{ ; 710e}<br/>\|\r\n#711\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7119}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{711a}{ (711c)}{. 711b}{ : 711d}{ ; 711f}{ ; 711e}<br/>\|\r\n#712\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7129}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{712a}{ (712c)}{. 712b}{ : 712d}{ ; 712f}{ ; 712e}<br/>\|\r\n#210\|<label class="ipt">Унифицированная форма заглавия: </label>\|{ 210a}<br/>\|\r\n#210\|<label class="ipt">Издатель: </label>\|{ 210c}<br/>\|\r\n#210\|<label class="ipt">Дата публикации: </label>\|{ 210d}<br/>\|\r\n#215\|<label class="ipt">Физическое описание: </label>\|{215a}{ : 215c}{ ; 215d}{ + 215e}\|<br/>\r\n#225\|<label class="ipt">Серія:</label>\|<a href="opac-search.pl?op=do_search&marclist=225a&operator==&type=intranet&value={225a}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {225a}"></a>{ (225a}{ = 225d}{ : 225e}{. 225h}{. 225i}{ / 225f}{, 225x}{ ; 225v}\|)<br/>\r\n#200\|\|<label class="ipt">Тематические рубрики: </label><br/>\|\r\n#600\|\|<a href="opac-search.pl?op=do_search&marclist=6009&operator==&type=intranet&value={6009}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6009}"></a>{ 600c}{ 600b}{ 600a}{ 600d}{ (600f)} {-- 600x }{-- 600z }{-- 600y}<br />\|\r\n#604\|\|<a href="opac-search.pl?op=do_search&marclist=6049&operator==&type=intranet&value={6049}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6049}"></a>{ 604a}{. 604t}<br />\|\r\n#601\|\|<a href="opac-search.pl?op=do_search&marclist=6019&operator==&type=intranet&value={6019}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6019}"></a>{ 601a}{ (601c)}{. 601b}{ : 601d} { ; 601f}{ ; 601e}{ -- 601x }{-- 601z }{-- 601y}<br />\|\r\n#605\|\|<a href="opac-search.pl?op=do_search&marclist=6059&operator==&type=intranet&value={6059}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6059}"></a>{ 605a}{. 605i}{. 605h}{. 605k}{. 605m}{. 605q} {-- 605x }{-- 605z }{-- 605y }{-- 605l}<br />\|\r\n#606\|\|<a href="opac-search.pl?op=do_search&marclist=6069&operator==&type=intranet&value={6069}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6069}">xx</a>{ 606a}{-- 606x }{-- 606z }{606y }<br />\|\r\n#607\|\|<a href="opac-search.pl?op=do_search&marclist=6079&operator==&type=intranet&value={6079}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6079}"></a>{ 607a}{-- 607x}{-- 607z}{-- 607y}<br />\|\r\n#010\|<label class="ipt">ISBN: </label>\|{010a}\|<br/>\r\n#011\|<label class="ipt">ISSN: </label>\|{011a}\|<br/>\r\n#200\|\|<label class="ipt">Заметки: </label>\|<br/>\r\n#300\|\|{300a}\|<br/>\r\n#320\|\|{320a}\|<br/>\r\n#327\|\|{327a}\|<br/>\r\n#328\|\|{328a}\|<br/>\r\n#200\|\|<br/><h2>Экземпляры</h2>\|\r\n#200\|<table>\|<th>Расположение</th><th>Cote</th>\|\r\n#995\|\|<tr><td>{995e}  </td><td> {995k}</td></tr>\|\r\n#200\|\|\|</table>' WHERE variable = 'ISBD';	44	UPDATE systempreferences SET value = '#200\|<h2>Заглавие: \|{200a}{. 200c}{ : 200e}{200d}{. 200h}{. 200i}\|</h2>\r\n#500\|<label class="ipt">Унифицированое заглавие: </label>\|{500a}{. 500i}{. 500h}{. 500m}{. 500q}{. 500k}<br/>\|\r\n#517\|<label class="ipt"> </label>\|{517a}{ : 517e}{. 517h}{, 517i}<br/>\|\r\n#541\|<label class="ipt"> </label>\|{541a}{ : 541e}<br/>\|\r\n#200\|\|<label class="ipt">Автора: </label><br/>\|\r\n#700\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7009}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{700c}{ 700b}{ 700a}{ 700d}{ (700f)}{. 7004}<br/>\|\r\n#701\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7019}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{701c}{ 701b}{ 701a}{ 701d}{ (701f)}{. 7014}<br/>\|\r\n#702\|\|<a href="opac-search.pl?op=do_search&marclist=7009&operator==&type=intranet&value={7029}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{702c}{ 702b}{ 702a}{ 702d}{ (702f)}{. 7024}<br/>\|\r\n#710\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7109}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{710a}{ (710c)}{. 710b}{ : 710d}{ ; 710f}{ ; 710e}<br/>\|\r\n#711\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7119}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{711a}{ (711c)}{. 711b}{ : 711d}{ ; 711f}{ ; 711e}<br/>\|\r\n#712\|\|<a href="opac-search.pl?op=do_search&marclist=7109&operator==&type=intranet&value={7129}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по автору"></a>{712a}{ (712c)}{. 712b}{ : 712d}{ ; 712f}{ ; 712e}<br/>\|\r\n#210\|<label class="ipt">Унифицированная форма заглавия: </label>\|{ 210a}<br/>\|\r\n#210\|<label class="ipt">Издатель: </label>\|{ 210c}<br/>\|\r\n#210\|<label class="ipt">Дата публикации: </label>\|{ 210d}<br/>\|\r\n#215\|<label class="ipt">Физическое описание: </label>\|{215a}{ : 215c}{ ; 215d}{ + 215e}\|<br/>\r\n#225\|<label class="ipt">Серія:</label>\|<a href="opac-search.pl?op=do_search&marclist=225a&operator==&type=intranet&value={225a}"> <img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {225a}"></a>{ (225a}{ = 225d}{ : 225e}{. 225h}{. 225i}{ / 225f}{, 225x}{ ; 225v}\|)<br/>\r\n#200\|\|<label class="ipt">Тематические рубрики: </label><br/>\|\r\n#600\|\|<a href="opac-search.pl?op=do_search&marclist=6009&operator==&type=intranet&value={6009}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6009}"></a>{ 600c}{ 600b}{ 600a}{ 600d}{ (600f)} {-- 600x }{-- 600z }{-- 600y}<br />\|\r\n#604\|\|<a href="opac-search.pl?op=do_search&marclist=6049&operator==&type=intranet&value={6049}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6049}"></a>{ 604a}{. 604t}<br />\|\r\n#601\|\|<a href="opac-search.pl?op=do_search&marclist=6019&operator==&type=intranet&value={6019}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6019}"></a>{ 601a}{ (601c)}{. 601b}{ : 601d} { ; 601f}{ ; 601e}{ -- 601x }{-- 601z }{-- 601y}<br />\|\r\n#605\|\|<a href="opac-search.pl?op=do_search&marclist=6059&operator==&type=intranet&value={6059}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6059}"></a>{ 605a}{. 605i}{. 605h}{. 605k}{. 605m}{. 605q} {-- 605x }{-- 605z }{-- 605y }{-- 605l}<br />\|\r\n#606\|\|<a href="opac-search.pl?op=do_search&marclist=6069&operator==&type=intranet&value={6069}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6069}">xx</a>{ 606a}{-- 606x }{-- 606z }{606y }<br />\|\r\n#607\|\|<a href="opac-search.pl?op=do_search&marclist=6079&operator==&type=intranet&value={6079}"><img border="0" src="/opac-tmpl/css/en/images/filefind.png" height="15" title="Поиск по {6079}"></a>{ 607a}{-- 607x}{-- 607z}{-- 607y}<br />\|\r\n#010\|<label class="ipt">ISBN: </label>\|{010a}\|<br/>\r\n#011\|<label class="ipt">ISSN: </label>\|{011a}\|<br/>\r\n#200\|\|<label class="ipt">Заметки: </label>\|<br/>\r\n#300\|\|{300a}\|<br/>\r\n#320\|\|{320a}\|<br/>\r\n#327\|\|{327a}\|<br/>\r\n#328\|\|{328a}\|<br/>\r\n#200\|\|<br/><h2>Экземпляры</h2>\|\r\n#200\|<table>\|<th>Расположение</th><th>Cote</th>\|\r\n#995\|\|<tr><td>{995e}  </td><td> {995k}</td></tr>\|\r\n#200\|\|\|</table>' WHERE variable = 'ISBD';
45	-

Return to bug 27490