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

(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (+7 lines)
Lines 1158-1174 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
1158
		('510', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1158
		('510', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1159
		('512', 'a', 'Cover Title', 'Cover Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1159
		('512', 'a', 'Cover Title', 'Cover Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1160
		('512', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1160
		('512', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1161
		('512', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1161
		('513', 'a', 'Added Title - Page Title', 'Added Title - Page Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1162
		('513', 'a', 'Added Title - Page Title', 'Added Title - Page Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1162
		('513', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1163
		('513', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1163
		('513', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1164
		('513', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1164
		('513', 'i', 'Name of Part', 'Name of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1165
		('513', 'i', 'Name of Part', 'Name of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1166
		('513', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1165
		('514', 'a', 'Caption Title', 'Caption Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1167
		('514', 'a', 'Caption Title', 'Caption Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1166
		('514', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1168
		('514', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1169
		('514', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1167
		('515', 'a', 'Running Title', 'Running Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1170
		('515', 'a', 'Running Title', 'Running Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1171
		('515', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1168
		('516', 'a', 'Spine Title', 'Spine Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1172
		('516', 'a', 'Spine Title', 'Spine Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1169
		('516', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1173
		('516', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1174
		('516', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1170
		('517', 'a', 'Variant Title', 'Variant Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1175
		('517', 'a', 'Variant Title', 'Variant Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1171
		('517', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', NULL, 0, 0, '', '', '', NULL),
1176
		('517', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', NULL, 0, 0, '', '', '', NULL),
1177
		('517', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1172
		('518', 'a', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1178
		('518', 'a', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 'Title Proper, Variant Title or Uniform Title in Standard Modern Spelling', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1173
		('518', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1179
		('518', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1174
		('518', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1180
		('518', 'h', 'Number of Part', 'Number of Part', 1, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
Lines 1193-1198 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
1193
		('532', 'a', 'Expanded Title', 'Expanded Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1199
		('532', 'a', 'Expanded Title', 'Expanded Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1194
		('532', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1200
		('532', 'z', 'Language of Title', 'Language of Title', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1195
		('540', 'a', 'Additional Title Supplied by Cataloguer', 'Additional Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1201
		('540', 'a', 'Additional Title Supplied by Cataloguer', 'Additional Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1202
		('540', 'n', 'Miscellaneous Information', 'Miscellaneous Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1196
		('541', 'a', 'Translated Title Supplied by Cataloguer', 'Translated Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1203
		('541', 'a', 'Translated Title Supplied by Cataloguer', 'Translated Title Supplied by Cataloguer', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1197
		('541', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1204
		('541', 'e', 'Other Title Information', 'Other Title Information', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1198
		('541', 'h', 'Number of Part', 'Number of Part', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
1205
		('541', 'h', 'Number of Part', 'Number of Part', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL),
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (-1 / +2 lines)
Lines 1872-1877 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
1872
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 ('517', 'e', 'sous-titre', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1872
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 ('517', 'e', 'sous-titre', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1873
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 ('517', 'h', 'numéro de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1873
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 ('517', 'h', 'numéro de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1874
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 ('517', 'i', 'titre de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1874
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 ('517', 'i', 'titre de partie', '', 1, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1875
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 ('517', 'n', 'autres informations', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1875
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 ('518', 'a', 'titre de dos', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1876
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 ('518', 'a', 'titre de dos', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1876
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 ('518', 'e', 'complément du titre', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1877
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 ('518', 'e', 'complément du titre', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1877
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 ('518', 'h', 'numéro de partie', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1878
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 ('518', 'h', 'numéro de partie', '', 0, 1, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
Lines 1896-1901 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
1896
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 ('532', 'a', 'titre développé', 'titre développé', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1897
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 ('532', 'a', 'titre développé', 'titre développé', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1897
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 ('532', 'z', 'langue du titre', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1898
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 ('532', 'z', 'langue du titre', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1898
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 ('540', 'a', 'titre ajouté par le catalogueur', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1899
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 ('540', 'a', 'titre ajouté par le catalogueur', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1900
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 ('540', 'n', 'autres informations', '', 0, 0, NULL, -1, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);
1899
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 ('541', 'a', 'titre traduit', 'titre traduit', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1901
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 ('541', 'a', 'titre traduit', 'titre traduit', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1900
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 ('541', 'e', 'complément du titre', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1902
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 ('541', 'e', 'complément du titre', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1901
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 ('541', 'h', 'numéro de partie', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1903
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 ('541', 'h', 'numéro de partie', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL);
1902
- 

Return to bug 10726