From 2e20f0bb11acba2039e404eb9cb91fa9bf455fc3 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Thu, 22 Oct 2015 12:34:47 -0300 Subject: [PATCH] [SIGNED-OFF 1/3] Bug 14333: Update MARC21 frameworks to Update No. 20 and 21 Default frameworks updated to update 20 (April 2015) and 21 (September 2015) Update No. 20 Bibliographic New field 884 New subfields 037$3, 037$5 and 382$e Authority New field 884 New subfields 046$q, 046$r and 382$e Update No. 21 Bibliographic New tag 348 New subfields 336$0, 337$0 and 338$0 Authority New field 348 New sufields 336$0 and 670$w To test: 1) Remove all your frameworks 2) Check mandatory bibliographic and authority files load without problem 3) Check new fields/subfields Signed-off-by: Zeno Tajoli --- .../marc21/mandatory/authorities_normal_marc21.sql | 21 ++++++++++++++++++- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 22 +++++++++++++++++++- 2 files changed, 41 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index f205398..a250b28 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -1,7 +1,7 @@ -- ******************************************************* -- KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS -- --- Revised to Update No. 19 (October 2014) +-- Revised to Update No. 21 (September 2015) -- ******************************************************* -- ****************************************************** @@ -162,6 +162,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '253', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL), ('', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL), ('', '336', 'CONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL), + ('', '348', 'FORMAT OF NOTATED MUSIC', 'FORMAT OF NOTATED MUSIC', 1, 0, NULL), ('', '353', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL), ('', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL), ('', '368', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 1, 0, NULL), @@ -264,6 +265,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL), ('', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL), ('', '883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL), + ('', '884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL), ('', '942', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', 0, 1, NULL); @@ -376,6 +378,8 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '046', 'l', 'Ending date created', 'Ending date created', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '046', 'o', 'Single or starting date for aggregated content', 'Single or starting date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '046', 'p', 'Ending date for aggregated content', 'Ending date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '046', 'q', 'Establishment date', 'Establishment date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '046', 'r', 'Termination date', 'Termination date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '046', 's', 'Start period', 'Start period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '046', 't', 'End period', 'End period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '046', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -776,10 +780,18 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 2, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', 'a', 'Content type term', 'Content type term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', 'b', 'Content type code', 'Content type code', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '336', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', '2', 'Source', 'Source', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', 'a', 'Format of notated music term', 'Format of notated music term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', 'b', 'Format of notated music code', 'Format of notated music code', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '348', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '353', 'a', 'Classification number referred to--Single number or beginning number of span', 'Classification number referred to--Single number or beginning number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '353', 'c', 'Classification number referred to--Ending number of span', 'Classification number referred to--Ending number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '353', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -903,6 +915,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '382', 'b', 'Soloist', 'Soloist', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '382', 'e', 'Number of ensembles', 'Number of ensembles', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1458,6 +1471,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '670', 'a', 'Source citation', 'Source citation', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '670', 'b', 'Information found', 'Information found', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '670', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '670', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '670', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '670', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '671', 'a', 'Citation', 'Citation', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1932,6 +1946,11 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '883', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '883', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '884', 'a', 'Conversion process', 'Conversion process', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '884', 'g', 'Conversion date', 'Conversion date', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '884', 'k', 'Identifier of source metadata', 'Identifier of source metadata', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '884', 'q', 'Conversion agency', 'Conversion agency', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '884', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '942', 'a', 'Koha auth type', 'Koha auth type', 0, 1, 9, NULL, NULL, NULL, 0, 8, '', 'auth_header.authtypecode', ''); diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 7a8316c..ca5fdfa 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -7,7 +7,7 @@ -- guided by Paul POULAIN -- by thd for LibLime -- --- Revised to Update No. 19 (October 2014) +-- Revised to Update No. 21 (September 2015) -- ************************************************************* @@ -289,6 +289,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''), ('346', 'VIDEO CHARACTERISTICS', 'VIDEO CHARACTERISTICS', 1, 0, NULL, ''), ('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, ''), + ('348', 'FORMAT OF NOTATED MUSIC', 'FORMAT OF NOTATED MUSIC', 1, 0, NULL, ''), ('350', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 1, 0, NULL, ''), ('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL, ''), ('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL, ''), @@ -463,6 +464,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''), ('882', 'REPLACEMENT RECORD INFORMATION', 'REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''), ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''), + ('884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL, ''), ('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''), ('887', 'NON-MARC INFORMATION FIELD', 'NON-MARC INFORMATION FIELD', 1, 0, NULL, ''), ('896', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''), @@ -670,6 +672,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('036', 'b', 'Source agency assigning number', 'Source agency assigning number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('037', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), + ('037', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), @@ -1213,18 +1217,21 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('321', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', 'b', 'Dates of former publication frequency', 'Dates of former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('336', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', 'a', 'Content type term', 'Content type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('336', 'b', 'Content type code', 'Content type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('337', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', 'a', 'Media type term', 'Media type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('337', 'b', 'Media type code', 'Media type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('338', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('338', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('338', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('338', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), @@ -1324,6 +1331,13 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('347', 'd', 'Resolution', 'Resolution', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('347', 'e', 'Regional encoding', 'Regional encoding', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('347', 'f', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', 'a', 'Format of notated music term', 'Format of notated music term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', 'b', 'Format of notated music code', 'Format of notated music code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('348', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('350', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('350', 'a', 'Price', 'Price', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('350', 'b', 'Form of issue', 'Form of issue', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1448,6 +1462,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('382', 'b', 'Soloist', 'Soloist', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('382', 'e', 'Number of ensembles', 'Number of ensembles', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), @@ -3576,6 +3591,11 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('883', 'x', 'Validity end date', 'Validity end date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('884', 'a', 'Conversion process', 'Conversion process', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('884', 'g', 'Conversion date', 'Conversion date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('884', 'k', 'Identifier of source metadata', 'Identifier of source metadata', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('884', 'q', 'Conversion agency', 'Conversion agency', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('884', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('886', '0', '0', '0', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('886', '1', '1', '1', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('886', '2', '2', '2', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), -- 1.7.10.4