[Koha-bugs] [Bug 6434] Many changes for Ukrainian and Russian sql-tables

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6434

--- Comment #16 from Serhij Dubyk <dubyk at library.lviv.ua> ---
Work on these tables in partly sponsored by the libraries: LTS
Library(http://koha.lts.lviv.ua:8008/,Unimarc), TNTU Scintific Technical
Library(http://koha.tntu.edu.ua/,Unimarc), DCU Library
(http://109.254.48.77:8008/,Unimarc), Dmitry Pozharsky University Library
(http://lib.s-and-e.ru/,Marc21) and ServanTek Company
(http://servantek.org.ua/).
I not so frequently updating these MARC-sql-table, so there are so many
changes.
Old tables deleted in this patch (add ~ 2 Mb to patch). To facilitate further
support all tables converted as follows: 1) separated standard MARC
fields/subfields and specific for Koha 2) reformated all sql as follow
(collected the appropriate fields/subfields and aligned):

INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory,
repeatable, liblibrarian, libopac, authorised_value) VALUE
 ('', '011', '', 1, 'Міжнародний стандартний номер серіального видання (ISSN)',
'ISSN', '');
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield,
tagsubfield, mandatory, repeatable, liblibrarian,
 ('', '', '011', 'a', 0, 0, 'Номер (ISSN)', 'ISSN',                     0,
NULL, 'biblioitems.issn', '', '', NULL, NULL, NULL,
 ('', '', '011', 'b', 0, 0, 'Уточнення', '',                            -1,
NULL, '', '', '', NULL, NULL, NULL, NULL),
 ('', '', '011', 'd', 0, 0, 'Умови придбання і/або ціна', '',           -1,
NULL, '', '', '', NULL, NULL, NULL, NULL),
 ('', '', '011', 'y', 0, 0, 'Анульований ISSN', '',                     -1,
NULL, '', '', '', NULL, NULL, NULL, NULL),
 ('', '', '011', 'z', 0, 0, 'Помилковий ISSN', '',                      -1,
NULL, '', '', '', NULL, NULL, NULL, NULL);
- for easier reading/editing by human.

In result, the size of the tables corresponding to the size of other languages
from /data/mysql/ ​​(including the fact that that the Cyrillic characters are 2
bytes).

P.S. Also, I have scripts that perform such reformatting as above and the
initial script, which compares the fields/subfields for all languages ​​from
Koha-sql.  If someone is interested, I unload them somewhere publicly.

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.