http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6434
--- Comment #16 from Serhij Dubyk <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
