Attachment #8711 for bug #7855

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

Lines 3995-3997 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+3 lines)
3995	('998', 's', 'CC (RLIN)', 'CC (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),	3995	('998', 's', 'CC (RLIN)', 'CC (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),
3996	('998', 't', 'RTYP (RLIN)', 'RTYP (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),	3996	('998', 't', 'RTYP (RLIN)', 'RTYP (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),
3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
		3998
		3999	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4000	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 3999-4001 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+2 lines)
3999	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3999	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
4000		4000
4001		4001
		4002	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4003	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 1402-1405 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (-1 / +2 lines)
1402	('856', 'y', 'Access Method', 'Access Method', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),	1402	('856', 'y', 'Access Method', 'Access Method', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),
1403	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);	1403	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);
1404		1404
1405		1405	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		1406	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 3997-3999 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+2 lines)
3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
3998		3998
3999		3999
		4000	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4001	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 1403-1405 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (+2 lines)
1403	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);	1403	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);
1404		1404
1405		1405
		1406	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		1407	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 3997-3999 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql (+2 lines)
3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
3998		3998
3999		3999
		4000	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4001	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 2033-2035 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql (+2 lines)
2033	('995', 's', 'élément de tri', '', 0, 1, '', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),	2033	('995', 's', 'élément de tri', '', 0, 1, '', -1, '', '', '', NULL, 0, '', NULL, NULL, ''),
2034	('995', 'u', 'note', '', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', NULL, NULL, '');	2034	('995', 'u', 'note', '', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', NULL, NULL, '');
2035		2035
		2036	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		2037	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 7885-7887 INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VA Link Here

(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (+3 lines)
7885	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (147, 'COUNTRY', 'FR', 'France');	7885	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (147, 'COUNTRY', 'FR', 'France');
7886	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne');	7886	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (148, 'COUNTRY', 'EN', 'Grande Bretagne');
7887	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne');	7887	INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (149, 'COUNTRY', 'DE', 'Allemagne');
		7888
		7889	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		7890	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 3992-3995 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +2 lines)
3992	('998', 't', 'RTYP (RLIN)', 'RTYP (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),	3992	('998', 't', 'RTYP (RLIN)', 'RTYP (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL),
3993	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3993	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
3994		3994
3995		3995	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		3996	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 2675-2679 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql (+2 lines)
2675	insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','y','Codice dell\'ente destinatario superiore','',0,0,'',10,'','','',0,-5,'PR',NULL,'','');	2675	insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','y','Codice dell\'ente destinatario superiore','',0,0,'',10,'','','',0,-5,'PR',NULL,'','');
2676	insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','z','Ente destinatario superiore, testo libero','',0,0,'',10,'','','',0,-5,'PR',NULL,'','');	2676	insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','z','Ente destinatario superiore, testo libero','',0,0,'',10,'','','',0,-5,'PR',NULL,'','');
2677		2677
		2678	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		2679	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';
2678		2680
2679	SET FOREIGN_KEY_CHECKS=1;	2681	SET FOREIGN_KEY_CHECKS=1;

Lines 3997-3999 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+2 lines)
3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3997	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
3998		3998
3999		3999
		4000	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4001	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 3996-3998 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+2 lines)
3996	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);	3996	('998', 'w', 'PLINK (RLIN)', 'PLINK (RLIN)', 0, 0, '', 9, '', '', '', 0, 5, '', '', '', NULL);
3997		3997
3998		3998
		3999	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		4000	UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008';

Lines 1466-1468 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (+2 lines)
1466	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);	1466	('856', 'z', 'Public Note', 'Public Note', 1, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL);
1467		1467
1468		1468
		1469	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		1470	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 1760-1763 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].sql (-1 / +2 lines)
1760	INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('899','y','Публикуемое примечание','Публикуемое примечание',1,0,'',8,'','','',0,0,'',NULL,'','');	1760	INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('899','y','Публикуемое примечание','Публикуемое примечание',1,0,'',8,'','','',0,0,'',NULL,'','');
1761	INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('899','z','Публикуемое примечание','Публикуемое примечание',1,0,'',8,'','','',0,0,'',NULL,'','');	1761	INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('899','z','Публикуемое примечание','Публикуемое примечание',1,0,'',8,'','','',0,0,'',NULL,'','');
1762		1762
1763		1763	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		1764	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 2366-2368 INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopa Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].sql (+3 lines)
2366	('886', '2', 'Код правил каталогізації і форматів', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL),	2366	('886', '2', 'Код правил каталогізації і форматів', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL),
2367	('886', 'a', 'Мітка поля вихідного формату', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL),	2367	('886', 'a', 'Мітка поля вихідного формату', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL),
2368	('886', 'b', 'Індикатори та підполя вихідного формату', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);	2368	('886', 'b', 'Індикатори та підполя вихідного формату', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
		2369
		2370	UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000';
		2371	UPDATE `marc_subfield_structure` SET maxlength=36 WHERE tagfield='100';

Lines 5044-5049 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +3 lines)
5044	UPDATE marc_subfield_structure SET maxlength = IF ((SELECT value FROM systempreferences WHERE variable = 'marcflavour')='MARC21','40','9999') WHERE tagfield='008';	5044	UPDATE marc_subfield_structure SET maxlength = IF ((SELECT value FROM systempreferences WHERE variable = 'marcflavour')='MARC21','40','9999') WHERE tagfield='008';
5045	");	5045	");
5046	$dbh->do("	5046	$dbh->do("
		5047	UPDATE marc_subfield_structure SET maxlength = IF ((SELECT value FROM systempreferences WHERE variable = 'marcflavour')='NORMARC','40','9999') WHERE tagfield='008';
		5048	");
		5049	$dbh->do("
5047	UPDATE marc_subfield_structure SET maxlength = IF ((SELECT value FROM systempreferences WHERE variable = 'marcflavour')='UNIMARC','36','9999') WHERE tagfield='100';	5050	UPDATE marc_subfield_structure SET maxlength = IF ((SELECT value FROM systempreferences WHERE variable = 'marcflavour')='UNIMARC','36','9999') WHERE tagfield='100';
5048	");	5051	");
5049	print "Upgrade to $DBversion done (Add new field maxlength to marc_subfield_structure)\n";	5052	print "Upgrade to $DBversion done (Add new field maxlength to marc_subfield_structure)\n";
5050	-

Return to bug 7855