From d9440ab54a421f103aeed099739ac3471b96f521 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 12 Dec 2019 10:12:41 +0100 Subject: [PATCH] Bug 13775: Set main headings to mandatory in authority frameworks (UNIMARC) Same as previously, for UNNIMARC For unimarc_complet: CLASS => 245 CO => 210 CO_UNI_TI => 235 EXP => 232 FAM => 220 GENRE/FORM => 280 NAME_COL => 245 NP => 200 NTEXP => 242 NTWORK => 241 PA => 260 PERS => 223 PUB => 217 SAUTTIT => 240 SNC => 250 SNG => 215 TM => 216 TU => 230 WORK => 231 For unimarc_lecture_pub: CO => 210 NP => 200 SAUT => 200 SAUTTIT => 240 SCO => 210 SNC => 250 SNG => 215 STU => 230 TU => 230 Signed-off-by: Bernardo Gonzalez Kriegel Signed-off-by: Kyle M Hall --- .../Obligatoire/autorites_norme_unimarc.sql | 36 +++++++++---------- .../Obligatoire/autorites_norme_unimarc.sql | 16 ++++----- 2 files changed, 26 insertions(+), 26 deletions(-) diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql index 5d275768a1..4352af0869 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql @@ -79,24 +79,24 @@ INSERT IGNORE INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrari ('', '152', 'Règles', '', 0, 0, NULL), ('', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL), ('', '160', 'Code d''aire géographique', '', 0, 0, NULL), - ('', '200', 'Vedette', '', 1, 0, NULL), - ('', '210', 'Vedette', '', 1, 0, ''), - ('', '215', 'Vedette', '', 1, 0, ''), - ('', '216', 'Marque', '', 0, 0, ''), - ('', '217', 'Vedette - Editeur ou imprimeur', '', 1, 0, ''), - ('', '220', 'Nom famile', '', 0, 0, ''), - ('', '223', 'Vedette - Personnage', '', 1, 0, ''), - ('', '230', 'Vedette', '', 1, 0, NULL), - ('', '231', 'Vedette - Titre (oeuvre)', '', 1, 0, ''), - ('', '232', 'Vedette - Titre (expression)', '', 1, 0, ''), - ('', '235', 'Vedette Rubrique de classement', '', 0, 0, ''), - ('', '240', 'Vedette', '', 1, 0, NULL), - ('', '241', 'Vedette - Nom/Titre (oeuvre)', '', 1, 0, ''), - ('', '242', 'Vedette - Nom/Titre (expression)', '', 1, 0, ''), - ('', '245', 'Vedette Auteur Rubrique de classement', '', 0, 0, ''), - ('', '250', 'Vedette-Matière nom commun', '', 1, 0, ''), - ('', '260', 'Vedette Lieu d''édition', '', 0, 0, ''), - ('', '280', 'Vedette – Forme, genre ou caractéristiques physiques', '', 0, 0, ''), + ('', '200', 'Vedette', '', 1, 1, NULL), + ('', '210', 'Vedette', '', 1, 1, ''), + ('', '215', 'Vedette', '', 1, 1, ''), + ('', '216', 'Marque', '', 0, 1, ''), + ('', '217', 'Vedette - Editeur ou imprimeur', '', 1, 1, ''), + ('', '220', 'Nom famile', '', 0, 1, ''), + ('', '223', 'Vedette - Personnage', '', 1, 1, ''), + ('', '230', 'Vedette', '', 1, 1, NULL), + ('', '231', 'Vedette - Titre (oeuvre)', '', 1, 1, ''), + ('', '232', 'Vedette - Titre (expression)', '', 1, 1, ''), + ('', '235', 'Vedette Rubrique de classement', '', 0, 1, ''), + ('', '240', 'Vedette', '', 1, 1, NULL), + ('', '241', 'Vedette - Nom/Titre (oeuvre)', '', 1, 1, ''), + ('', '242', 'Vedette - Nom/Titre (expression)', '', 1, 1, ''), + ('', '245', 'Vedette Auteur Rubrique de classement', '', 0, 1, ''), + ('', '250', 'Vedette-Matière nom commun', '', 1, 1, ''), + ('', '260', 'Vedette Lieu d''édition', '', 0, 1, ''), + ('', '280', 'Vedette – Forme, genre ou caractéristiques physiques', '', 0, 1, ''), ('', '300', 'Note d''information', '', 1, 0, NULL), ('', '305', 'Note de renvoi textuel \"Voir aussi\"', '', 1, 0, NULL), ('', '310', 'Note de renvoi textuel \"Voir\"', '', 1, 0, NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/autorites_norme_unimarc.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/autorites_norme_unimarc.sql index 3faf9be50d..952f8c6b86 100644 --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/autorites_norme_unimarc.sql +++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/autorites_norme_unimarc.sql @@ -92,7 +92,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '200', 'Vedette', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '200', 'Vedette', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('NP', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -131,7 +131,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '200', 'Vedette', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '200', 'Vedette', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUT', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -170,7 +170,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '240', 'Vedette', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '240', 'Vedette', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SAUTTIT', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -209,7 +209,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '210', 'Vedette-Nom de collectivité', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '210', 'Vedette-Nom de collectivité', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SCO', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -248,7 +248,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '250', 'Vedette-Matière nom commun', '', 1, 0, ''); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '250', 'Vedette-Matière nom commun', '', 1, 1, ''); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNC', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -287,7 +287,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '215', 'Vedette', '', 1, 0, ''); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '215', 'Vedette', '', 1, 1, ''); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('SNG', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -326,7 +326,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '230', 'Vedette', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '230', 'Vedette', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('STU', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); @@ -365,7 +365,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '152', 'Règles', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '154', 'Zone de données codées : titre uniforme', '', 0, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '160', 'Code d''aire géographique', '', 0, 0, NULL); -INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '230', 'Vedette', '', 1, 0, NULL); +INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '230', 'Vedette', '', 1, 1, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '300', 'Note d''information', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '305', 'Note de renvoi textuel "Voir aussi"', '', 1, 0, NULL); INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`) VALUES ('TU', '310', 'Note de renvoi textuel "Voir"', '', 1, 0, NULL); -- 2.21.1 (Apple Git-122.3)