From 8a7181b9a4e84f1090fee56ca3cd16a3f5784a9d Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Thu, 12 Nov 2015 13:43:33 -0300 Subject: [PATCH] [SIGNED-OFF] Bug 15181: Rename marc21 fast add framework sql file This patch simply renames fast add sql file in order to load this file before default framework. To test: 1) Do a marc21 install (de,en,es,it) load all sample files check Fast Add framework is empty (no fields/subfields) 2) Apply the patch 3) Do an install again, this time FastAdd must have values. Signed-off-by: Zeno Tajoli --- .../marc21/optional/marc21_fastadd_framework.sql | 89 ------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 89 +++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + .../marc21/optional/marc21_fastadd_framework.sql | 89 ------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 89 +++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + .../marc21/optional/marc21_fastadd_framework.sql | 88 ------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 88 +++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + .../marc21/optional/marc21_fastadd_framework.sql | 141 --------------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 141 +++++++++++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + .../marc21/optional/marc21_fastadd_framework.sql | 138 -------------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 138 ++++++++++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + .../marc21/optional/marc21_fastadd_framework.sql | 139 -------------------- .../marc21/optional/marc21_fastadd_framework.txt | 1 - .../optional/marc21_sample_fastadd_framework.sql | 139 ++++++++++++++++++++ .../optional/marc21_sample_fastadd_framework.txt | 1 + 24 files changed, 690 insertions(+), 690 deletions(-) delete mode 100644 installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt delete mode 100644 installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt delete mode 100644 installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt delete mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt delete mode 100644 installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt delete mode 100644 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql delete mode 100644 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100644 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql create mode 100644 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index 69a79d5..0000000 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,89 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES - ('FA', 'Schnellaufnahme'); - -INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) -SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' -FROM marc_tag_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - -INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) -SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue -FROM marc_subfield_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - --- ************************************************** --- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES --- ************************************************** - -UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; - diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index 7386655..0000000 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -"FA", ein MARC21-Framework (Erfassungsmaske) für Schnellaufnahmen oder Fernleihtitel diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..69a79d5 --- /dev/null +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,89 @@ +INSERT IGNORE INTO biblio_framework VALUES + ('FA', 'Schnellaufnahme'); + +INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) +SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' +FROM marc_tag_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) +SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue +FROM marc_subfield_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +-- ************************************************** +-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES +-- ************************************************** + +UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; + diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..7386655 --- /dev/null +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +"FA", ein MARC21-Framework (Erfassungsmaske) für Schnellaufnahmen oder Fernleihtitel diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index fadc7bc..0000000 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,89 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES - ('FA', 'Fast Add Framework'); - -INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) -SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' -FROM marc_tag_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - -INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) -SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue -FROM marc_subfield_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - --- ************************************************** --- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES --- ************************************************** - -UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; - diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index a183658..0000000 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing. diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..fadc7bc --- /dev/null +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,89 @@ +INSERT IGNORE INTO biblio_framework VALUES + ('FA', 'Fast Add Framework'); + +INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) +SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' +FROM marc_tag_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) +SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue +FROM marc_subfield_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +-- ************************************************** +-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES +-- ************************************************** + +UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; + diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..a183658 --- /dev/null +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing. diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index cd8c60b..0000000 --- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,88 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES - ('FA', 'Plantilla de carga rápida'); - -INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) -SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' -FROM marc_tag_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - -INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) -SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, 0, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue -FROM marc_subfield_structure -WHERE frameworkcode = '' AND -tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); - --- ************************************************** --- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES --- ************************************************** - -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; -UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; - diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index 4e9b358..0000000 --- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -'FA', una hoja de trabajo minimalista MARC21 para 'Carga Rápida' ('Fast Add'). diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..cd8c60b --- /dev/null +++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,88 @@ +INSERT IGNORE INTO biblio_framework VALUES + ('FA', 'Plantilla de carga rápida'); + +INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) +SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' +FROM marc_tag_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) +SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, 0, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue +FROM marc_subfield_structure +WHERE frameworkcode = '' AND +tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); + +-- ************************************************** +-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES +-- ************************************************** + +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA'; +UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA'; + diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..4e9b358 --- /dev/null +++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +'FA', una hoja de trabajo minimalista MARC21 para 'Carga Rápida' ('Fast Add'). diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index 3706025..0000000 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,141 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES - ('FA', 'Cat. veloce'); - -INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES - ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), - ('008', 'Elementi di lunghezza fissa--Informazione generale', 'Elementi di lunghezza fissa--Informazione generale', 0, 1, '', 'FA'), - ('010', 'Numero di controllo della Library of Congress', 'Numero di controllo della Library of Congress', 0, 0, '', 'FA'), - ('020', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 1, 0, NULL, 'FA'), - ('022', 'ISSN (International Standard Serial Number)', 'ISSN (International Standard Serial Number)', 1, 0, NULL, 'FA'), - ('050', 'Numero di chiamata (collocazione) della Library of Congress', 'Numero di chiamata (collocazione) della Library of Congress', 1, 0, NULL, 'FA'), - ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 1, 0, '', 'FA'), - ('099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, '', 'FA'), - ('100', 'Accesso principale -- nome di persona', 'Accesso principale -- nome di persona', 0, 0, NULL, 'FA'), - ('245', 'Formulazione del titolo', 'Formulazione del titolo', 0, 1, '', 'FA'), - ('250', 'Formulazione di edizione', 'Formulazione di edizione', 0, 0, NULL, 'FA'), - ('260', 'Pubblicazione, distribuzione, ecc. (stampa)', 'Pubblicazione, distribuzione, ecc. (stampa)', 1, 0, NULL, 'FA'), - ('300', 'Descrizione fisica', 'Descrizione fisica', 1, 0, NULL, 'FA'), - ('500', 'Nota generale', 'Nota generale', 1, 0, NULL, 'FA'), - ('942', 'Dati aggiuntivi (Koha)', 'Dati aggiuntivi (Koha)', 0, 0, '', 'FA'), - ('952', 'Dati di copia (Koha)', 'Dati di copia (Koha)', 1, 0, '', 'FA'), - ('999', 'Sys Number locale (Koha)', 'Sys Number locale (Koha)', 1, 0, '', 'FA'); - -INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_leader.pl', NULL, 0, 'FA', '', NULL, NULL), - ('008', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_field_008.pl', NULL, 0, 'FA', '', NULL, NULL), - ('010', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('010', 'a', 'Numero di controllo della LC', 'Numero di controllo della LC', 0, 0, 'biblioitems.lccn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('010', 'b', 'Numero di controllo del NUCMC', 'Numero di controllo del NUCMC', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('010', 'z', 'Numero di controllo della LC cancellato o errato', 'Numero di controllo della LC cancellato o errato', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('020', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('020', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('020', 'a', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('020', 'c', 'Termini di disponibilità', 'Termini di disponibilità', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('020', 'z', 'ISBN cancellato o errato', 'ISBN cancellato o errato', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('050', 'a', 'Numero di classificazione', 'Numero di classificazione', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('050', 'b', 'Numero d\'item', 'Numero d\'item', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('082', '2', 'Numero dell\'edizione', 'Numero dell\'edizione', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('082', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('082', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('082', 'a', 'Numero di classificazione', 'Numero di classificazione', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('082', 'b', 'Numero d\'item', 'Numero d\'item', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('090', 'a', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), - ('090', 'b', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 0, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), - ('100', '4', 'Codice di ruolo', 'Codice di ruolo', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 0, '', 'PERSO_NAME', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'b', 'Numerazione', 'Numerazione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'c', 'Titoli e altre parole associate al nome', 'Titoli e altre parole associate al nome', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'd', 'Date associate al nome', 'Date associate al nome', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'e', 'Termine di ruolo', 'Termine di ruolo', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'j', 'Qualificazione d\'attribuzione', 'Qualificazione d\'attribuzione', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'k', 'Sottointestazione formale', 'Sottointestazione formale', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'l', 'Lingua dell\'opera', 'Lingua dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'q', 'Forma completa del nome', 'Forma completa del nome', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 't', 'Titolo dell\'opera', 'Titolo dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('100', 'u', 'Affiliazione', 'Affiliazione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'a', 'Titolo', 'Titolo', 0, 1, 'biblio.title', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'b', 'Complemento del titolo', 'Complemento del titolo', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'c', 'Formulazione di responsabilità, ecc.', 'Formulazione di responsabilità, ecc.', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section/part/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'f', 'Date inclusive', 'Date inclusive', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'g', 'Date preponderanti', 'Date preponderanti', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'h', 'Supporto', 'Supporto', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'k', 'Forma', 'Forma', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('245', 's', 'Versione', 'Versione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('250', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('250', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('250', 'a', 'Formulazione di edizione', 'Formulazione di edizione', 0, 0, 'biblioitems.editionstatement', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('250', 'b', 'Restante parte della formulazione di edizione', 'Restante parte della formulazione di edizione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'a', 'Luogo di pubblicazione, distribuzione, ecc.', 'Luogo di pubblicazione, distribuzione, ecc.', 1, 0, 'biblioitems.place', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'b', 'Nome dell\'editore, distributore, ecc.', 'Nome dell\'editore, distributore, ecc.', 1, 0, 'biblioitems.publishercode', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'c', 'Data di pubblicazione, distribuzione, ecc.', 'Data di pubblicazione, distribuzione, ecc.', 1, 0, 'biblio.copyrightdate', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'd', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'e', 'Luogo di stampa', 'Luogo di stampa', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'f', 'Stampatore', 'Stampatore', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'g', 'Data di stampa', 'Data di stampa', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'k', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('260', 'l', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', '3', 'Materiale specificato', 'Materiale specificato', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', '5', 'Istituzione a cui si applica il campo', 'Istituzione a cui si applica il campo', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', 'a', 'Nota generale', 'Nota generale', 0, 0, 'biblio.notes', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', 'n', 'n (RLIN) [OBSOLETE]', 'n (RLIN) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', 'x', 'International Standard Serial Number (SE) [OBSOLETE]', 'International Standard Serial Number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('500', 'z', 'Source of note information (AM SE) [OBSOLETE]', 'Source of note information (AM SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), - ('942', '0', 'Numero prestiti (tutte le copie)', 'Numero prestiti (tutte le copie)', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'c', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'n', 'Nasconto in Opac', 'Nasconto in Opac', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), - ('942', 's', 'Flag seriale', 'Flag seriale', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('952', '0', 'Ritirato (status)', 'Ritirato (status)', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '1', 'Perso (status)', 'Perso (status)', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '2', 'Fonte della classificazione o dello schema di collocazione (segnatura)', 'Fonte della classificazione o dello schema di collocazione (segnatura)', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '3', 'Materiali specifici (rilegati o simili)', 'Materiali specifici (rilegati o simili)', 0, 0, 'items.materials', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '4', 'Danneggiato (status)', 'Danneggiato (status)', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '5', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '6', 'Class. Normalizzata per ordinamento', 'Class. Normalizzata per ordinamento', 0, 0, 'items.cn_sort', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '7', 'Non per il presito', 'Non per il presito', 0, 0, 'items.notforloan', 10, 'NOT_LOAN', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '8', 'Codice collezione', 'Codice collezione', 0, 0, 'items.ccode', 10, 'CCODE', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', '9', 'Numero di copia (ID autogenerato)', 'Numero di copia (ID autogenerato)', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'a', 'Biblioteca proprietaria', 'Biblioteca proprietaria', 0, 0, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'b', 'Biblioteca in cui si trova', 'Biblioteca in cui si trova', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'c', 'Localizzazione a scaffale', 'Localizzazione a scaffale', 0, 0, 'items.location', 10, 'LOC', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'd', 'Data d\'acquisizione', 'Data d\'acquisizione', 0, 0, 'items.dateaccessioned', 10, '', '', 'dateaccessioned.pl', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'e', 'Fonte d\'acquisto', 'Fonte d\'acquisto', 0, 0, 'items.booksellerid', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'f', 'Qualificatore di localizzazione codificato', 'Qualificatore di localizzazione codificato', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'g', 'Costo, prezzo di acquisto', 'Costo, prezzo di acquisto', 0, 0, 'items.price', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'h', 'Enumerazione seriale / cronologia', 'Enumerazione seriale / cronologia', 0, 0, 'items.enumchron', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'i', 'Numero di inventario', 'Numero di inventario', 0, 0, 'items.stocknumber', 10, '', '', '', 0, 0, 'FA', '', NULL, NULL), - ('952', 'j', 'Collocazione (segnatura)', 'Collocazione (segnatura)', 0, 0, 'items.stack', 10, 'STACK', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'l', 'Totale prestiti', 'Totale prestiti', 0, 0, 'items.issues', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'm', 'Totale rinnovi', 'Totale rinnovi', 0, 0, 'items.renewals', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'n', 'Totale prenotazioni', 'Totale prenotazioni', 0, 0, 'items.reserves', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'o', 'Collocazione', 'Collocazione', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, NULL, 0, 'FA', '', NULL, NULL), - ('952', 'p', 'Codice a barre', 'Codice a barre', 0, 0, 'items.barcode', 10, '', '', 'barcode.pl', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'q', 'Prestito', 'Prestito', 0, 0, 'items.onloan', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'r', 'Data ultima operazione', 'Data ultima operazione', 0, 0, 'items.datelastseen', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 's', 'Data ultimo prestito', 'Data ultimo prestito', 0, 0, 'items.datelastborrowed', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 't', 'Numero di copia', 'Numero di copia', 0, 0, 'items.copynumber', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'u', 'URI (Uniform Resource Identifier)', 'URI (Uniform Resource Identifier)', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'v', 'Costo, costo di riacquisto', 'Costo, costo di riacquisto', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'w', 'Prezzo in vigore dal', 'Prezzo in vigore dal', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 1, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('952', 'z', 'Nota pubblica', 'Nota pubblica', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), - ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), - ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index a59e3c2..0000000 --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -'FA', una griglia di catalogazione minimale, 'FAST' per ILL o ctalogazionone al volo. diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..3706025 --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,141 @@ +INSERT IGNORE INTO biblio_framework VALUES + ('FA', 'Cat. veloce'); + +INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES + ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), + ('008', 'Elementi di lunghezza fissa--Informazione generale', 'Elementi di lunghezza fissa--Informazione generale', 0, 1, '', 'FA'), + ('010', 'Numero di controllo della Library of Congress', 'Numero di controllo della Library of Congress', 0, 0, '', 'FA'), + ('020', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 1, 0, NULL, 'FA'), + ('022', 'ISSN (International Standard Serial Number)', 'ISSN (International Standard Serial Number)', 1, 0, NULL, 'FA'), + ('050', 'Numero di chiamata (collocazione) della Library of Congress', 'Numero di chiamata (collocazione) della Library of Congress', 1, 0, NULL, 'FA'), + ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 1, 0, '', 'FA'), + ('099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, '', 'FA'), + ('100', 'Accesso principale -- nome di persona', 'Accesso principale -- nome di persona', 0, 0, NULL, 'FA'), + ('245', 'Formulazione del titolo', 'Formulazione del titolo', 0, 1, '', 'FA'), + ('250', 'Formulazione di edizione', 'Formulazione di edizione', 0, 0, NULL, 'FA'), + ('260', 'Pubblicazione, distribuzione, ecc. (stampa)', 'Pubblicazione, distribuzione, ecc. (stampa)', 1, 0, NULL, 'FA'), + ('300', 'Descrizione fisica', 'Descrizione fisica', 1, 0, NULL, 'FA'), + ('500', 'Nota generale', 'Nota generale', 1, 0, NULL, 'FA'), + ('942', 'Dati aggiuntivi (Koha)', 'Dati aggiuntivi (Koha)', 0, 0, '', 'FA'), + ('952', 'Dati di copia (Koha)', 'Dati di copia (Koha)', 1, 0, '', 'FA'), + ('999', 'Sys Number locale (Koha)', 'Sys Number locale (Koha)', 1, 0, '', 'FA'); + +INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES + ('000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_leader.pl', NULL, 0, 'FA', '', NULL, NULL), + ('008', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_field_008.pl', NULL, 0, 'FA', '', NULL, NULL), + ('010', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('010', 'a', 'Numero di controllo della LC', 'Numero di controllo della LC', 0, 0, 'biblioitems.lccn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('010', 'b', 'Numero di controllo del NUCMC', 'Numero di controllo del NUCMC', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('010', 'z', 'Numero di controllo della LC cancellato o errato', 'Numero di controllo della LC cancellato o errato', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('020', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('020', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('020', 'a', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('020', 'c', 'Termini di disponibilità', 'Termini di disponibilità', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('020', 'z', 'ISBN cancellato o errato', 'ISBN cancellato o errato', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('050', 'a', 'Numero di classificazione', 'Numero di classificazione', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('050', 'b', 'Numero d\'item', 'Numero d\'item', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('082', '2', 'Numero dell\'edizione', 'Numero dell\'edizione', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('082', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('082', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('082', 'a', 'Numero di classificazione', 'Numero di classificazione', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('082', 'b', 'Numero d\'item', 'Numero d\'item', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('090', 'a', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), + ('090', 'b', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 0, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), + ('100', '4', 'Codice di ruolo', 'Codice di ruolo', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 0, '', 'PERSO_NAME', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'b', 'Numerazione', 'Numerazione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'c', 'Titoli e altre parole associate al nome', 'Titoli e altre parole associate al nome', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'd', 'Date associate al nome', 'Date associate al nome', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'e', 'Termine di ruolo', 'Termine di ruolo', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'f', 'Data dell\'opera', 'Data dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'g', 'Informazione miscellanea', 'Informazione miscellanea', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'j', 'Qualificazione d\'attribuzione', 'Qualificazione d\'attribuzione', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'k', 'Sottointestazione formale', 'Sottointestazione formale', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'l', 'Lingua dell\'opera', 'Lingua dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'q', 'Forma completa del nome', 'Forma completa del nome', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 't', 'Titolo dell\'opera', 'Titolo dell\'opera', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('100', 'u', 'Affiliazione', 'Affiliazione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'a', 'Titolo', 'Titolo', 0, 1, 'biblio.title', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'b', 'Complemento del titolo', 'Complemento del titolo', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'c', 'Formulazione di responsabilità, ecc.', 'Formulazione di responsabilità, ecc.', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section/part/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'f', 'Date inclusive', 'Date inclusive', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'g', 'Date preponderanti', 'Date preponderanti', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'h', 'Supporto', 'Supporto', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'k', 'Forma', 'Forma', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('245', 's', 'Versione', 'Versione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('250', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('250', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('250', 'a', 'Formulazione di edizione', 'Formulazione di edizione', 0, 0, 'biblioitems.editionstatement', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('250', 'b', 'Restante parte della formulazione di edizione', 'Restante parte della formulazione di edizione', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'a', 'Luogo di pubblicazione, distribuzione, ecc.', 'Luogo di pubblicazione, distribuzione, ecc.', 1, 0, 'biblioitems.place', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'b', 'Nome dell\'editore, distributore, ecc.', 'Nome dell\'editore, distributore, ecc.', 1, 0, 'biblioitems.publishercode', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'c', 'Data di pubblicazione, distribuzione, ecc.', 'Data di pubblicazione, distribuzione, ecc.', 1, 0, 'biblio.copyrightdate', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'd', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'e', 'Luogo di stampa', 'Luogo di stampa', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'f', 'Stampatore', 'Stampatore', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'g', 'Data di stampa', 'Data di stampa', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'k', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('260', 'l', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', '3', 'Materiale specificato', 'Materiale specificato', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', '5', 'Istituzione a cui si applica il campo', 'Istituzione a cui si applica il campo', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', 'a', 'Nota generale', 'Nota generale', 0, 0, 'biblio.notes', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', 'n', 'n (RLIN) [OBSOLETE]', 'n (RLIN) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', 'x', 'International Standard Serial Number (SE) [OBSOLETE]', 'International Standard Serial Number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('500', 'z', 'Source of note information (AM SE) [OBSOLETE]', 'Source of note information (AM SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''), + ('942', '0', 'Numero prestiti (tutte le copie)', 'Numero prestiti (tutte le copie)', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'c', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'n', 'Nasconto in Opac', 'Nasconto in Opac', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), + ('942', 's', 'Flag seriale', 'Flag seriale', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('952', '0', 'Ritirato (status)', 'Ritirato (status)', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '1', 'Perso (status)', 'Perso (status)', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '2', 'Fonte della classificazione o dello schema di collocazione (segnatura)', 'Fonte della classificazione o dello schema di collocazione (segnatura)', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '3', 'Materiali specifici (rilegati o simili)', 'Materiali specifici (rilegati o simili)', 0, 0, 'items.materials', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '4', 'Danneggiato (status)', 'Danneggiato (status)', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '5', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '6', 'Class. Normalizzata per ordinamento', 'Class. Normalizzata per ordinamento', 0, 0, 'items.cn_sort', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '7', 'Non per il presito', 'Non per il presito', 0, 0, 'items.notforloan', 10, 'NOT_LOAN', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '8', 'Codice collezione', 'Codice collezione', 0, 0, 'items.ccode', 10, 'CCODE', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', '9', 'Numero di copia (ID autogenerato)', 'Numero di copia (ID autogenerato)', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'a', 'Biblioteca proprietaria', 'Biblioteca proprietaria', 0, 0, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'b', 'Biblioteca in cui si trova', 'Biblioteca in cui si trova', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'c', 'Localizzazione a scaffale', 'Localizzazione a scaffale', 0, 0, 'items.location', 10, 'LOC', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'd', 'Data d\'acquisizione', 'Data d\'acquisizione', 0, 0, 'items.dateaccessioned', 10, '', '', 'dateaccessioned.pl', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'e', 'Fonte d\'acquisto', 'Fonte d\'acquisto', 0, 0, 'items.booksellerid', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'f', 'Qualificatore di localizzazione codificato', 'Qualificatore di localizzazione codificato', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'g', 'Costo, prezzo di acquisto', 'Costo, prezzo di acquisto', 0, 0, 'items.price', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'h', 'Enumerazione seriale / cronologia', 'Enumerazione seriale / cronologia', 0, 0, 'items.enumchron', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'i', 'Numero di inventario', 'Numero di inventario', 0, 0, 'items.stocknumber', 10, '', '', '', 0, 0, 'FA', '', NULL, NULL), + ('952', 'j', 'Collocazione (segnatura)', 'Collocazione (segnatura)', 0, 0, 'items.stack', 10, 'STACK', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'l', 'Totale prestiti', 'Totale prestiti', 0, 0, 'items.issues', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'm', 'Totale rinnovi', 'Totale rinnovi', 0, 0, 'items.renewals', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'n', 'Totale prenotazioni', 'Totale prenotazioni', 0, 0, 'items.reserves', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'o', 'Collocazione', 'Collocazione', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, NULL, 0, 'FA', '', NULL, NULL), + ('952', 'p', 'Codice a barre', 'Codice a barre', 0, 0, 'items.barcode', 10, '', '', 'barcode.pl', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'q', 'Prestito', 'Prestito', 0, 0, 'items.onloan', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'r', 'Data ultima operazione', 'Data ultima operazione', 0, 0, 'items.datelastseen', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 's', 'Data ultimo prestito', 'Data ultimo prestito', 0, 0, 'items.datelastborrowed', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 't', 'Numero di copia', 'Numero di copia', 0, 0, 'items.copynumber', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'u', 'URI (Uniform Resource Identifier)', 'URI (Uniform Resource Identifier)', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'v', 'Costo, costo di riacquisto', 'Costo, costo di riacquisto', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'w', 'Prezzo in vigore dal', 'Prezzo in vigore dal', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 1, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('952', 'z', 'Nota pubblica', 'Nota pubblica', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL), + ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), + ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..a59e3c2 --- /dev/null +++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +'FA', una griglia di catalogazione minimale, 'FAST' per ILL o ctalogazionone al volo. diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index 3b5d7bb..0000000 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,138 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Fast Add Framework' ); -INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES - ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), - ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'FA'), - ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'FA'), - ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'FA'), - ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'FA'), - ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'), - ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 1, 0, '', 'FA'), - ('099', 'LOCAL FREE-TEXT CALL NUMBER', 'LOCAL FREE-TEXT CALL NUMBER', 1, 0, '', 'FA'), - ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'), - ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'), - ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'), - ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'), - ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'), - ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'), - ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'), - ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'), - ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'FA'); - -INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('000','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_leader.pl',NULL,0,'FA','',NULL,NULL), - ('008','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_field_008.pl',NULL,0,'FA','',NULL,NULL), - ('010','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('010','a','LC control number','LC control number',0,0,'biblioitems.lccn',0,'','','',0,0,'FA',NULL,'',''), - ('010','b','NUCMC control number','NUCMC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('010','z','Canceled/invalid LC control number','Canceled/invalid LC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','a','International Standard Book Number','International Standard Book Number',0,0,'biblioitems.isbn',0,'','','',0,0,'FA',NULL,'',''), - ('020','c','Terms of availability','Terms of availability',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','z','Cancelled/invalid ISBN','Cancelled/invalid ISBN',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('082','2','Edition number','Edition number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','6','Linkage','Linkage',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','a','Classification number','Classification number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','b','Item number','Item number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('090', 'a', 'Local Classification number (NR)', 'Local Classification number (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), - ('090', 'b', 'Local cutter number', 'Local cutter number', 0, 0, '', 0, '', '','', 0, 5, 'FA', '', '', NULL), - ('100','4','Relator code','Relator code',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','9','9 (RLIN)','9 (RLIN)',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','a','Personal name','Personal name',0,0,'biblio.author',0,'','PERSO_NAME','',0,0,'FA',NULL,'',''), - ('100','b','Numeration','Numeration',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','c','Titles and other words associated with a name','Titles and other words associated with a name',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','d','Dates associated with a name','Dates associated with a name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','e','Relator term','Relator term',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','f','Date of a work','Date of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','g','Miscellaneous information','Miscellaneous information',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','j','Attribution qualifier','Attribution qualifier',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','k','Form subheading','Form subheading',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','l','Language of a work','Language of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','q','Fuller form of name','Fuller form of name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','t','Title of a work','Title of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','u','Affiliation','Affiliation',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','a','Title','Title',0,1,'biblio.title',0,'','','',0,0,'FA',NULL,'',''), - ('245','b','Remainder of title','Remainder of title',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','c','Statement of responsibility, etc','Statement of responsibility, etc',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','d','Designation of section/part/series (SE) [OBSOLETE]','Designation of section section/part/series: (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','e','Name of part/section/series (SE) [OBSOLETE]','Name of part/section/series (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','f','Inclusive dates','Inclusive dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','g','Bulk dates','Bulk dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','h','Medium','Medium',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','k','Form','Form',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','s','Version','Version',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','a','Edition statement','Edition statement',0,0,'biblioitems.editionstatement',0,'','','',0,0,'FA',NULL,'',''), - ('250','b','Remainder of edition statement','Remainder of edition statement',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','a','Place of publication, distribution, etc','Place of publication, distribution, etc',1,0,'biblioitems.place',0,'','','',0,0,'FA',NULL,'',''), - ('260','b','Name of publisher, distributor, etc','Name of publisher, distributor, etc',1,0,'biblioitems.publishercode',0,'','','',0,0,'FA',NULL,'',''), - ('260','c','Date of publication, distribution, etc','Date of publication, distribution, etc',1,0,'biblio.copyrightdate',0,'','','',0,0,'FA',NULL,'',''), - ('260','d','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','e','Place of manufacture','Place of manufacture',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','f','Manufacturer','Manufacturer',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','g','Date of manufacture','Date of manufacture',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','k','Identification/manufacturer number [OBSOLETE, CAN/MARC]','Identification/manufacturer number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','l','Matrix and/or take number [OBSOLETE, CAN/MARC]','Matrix and/or take number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','3','Materials specified','Materials specified',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','5','Institution to which field applies','Institution to which field applies',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','a','General note','General note',0,0,'biblio.notes',0,'','','',0,0,'FA',NULL,'',''), - ('500','l','Library of Congress call number (SE) [OBSOLETE]','Library of Congress call number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','n','n (RLIN) [OBSOLETE]','n (RLIN) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','x','International Standard Serial Number (SE) [OBSOLETE]','International Standard Serial Number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','z','Source of note information (AM SE) [OBSOLETE]','Source of note information (AM SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), - ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), - ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), - ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), - ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','4','Damaged status','Damaged status',0,0,'items.damaged',10,'DAMAGED','','',NULL,0,'FA','',NULL,NULL), - ('952','5','Use restrictions','Use restrictions',0,0,'items.restricted',10,'RESTRICTED','','',NULL,0,'FA','',NULL,NULL), - ('952','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'items.cn_sort',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','7','Not for loan','Not for loan',0,0,'items.notforloan',10,'NOT_LOAN','','',NULL,0,'FA','',NULL,NULL), - ('952','8','Koha collection','Koha collection',0,0,'items.ccode',10,'CCODE','','',NULL,0,'FA','',NULL,NULL), - ('952','9','Koha itemnumber (autogenerated)','Koha itemnumber',0,0,'items.itemnumber',-1,'','','',NULL,0,'FA','',NULL,NULL), - ('952','a','Location (home branch)','Location (home branch)',0,0,'items.homebranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), - ('952','b','Sublocation or collection (holding branch)','Sublocation or collection (holding branch)',0,0,'items.holdingbranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), - ('952','c','Shelving location','Shelving location',0,0,'items.location',10,'LOC','','',NULL,0,'FA','',NULL,NULL), - ('952','d','Date acquired','Date acquired',0,0,'items.dateaccessioned',10,'','','dateaccessioned.pl',NULL,0,'FA','',NULL,NULL), - ('952','e','Source of acquisition','Source of acquisition',0,0,'items.booksellerid',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','f','Coded location qualifier','Coded location qualifier',0,0,'items.coded_location_qualifier',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','g','Cost, normal purchase price','Cost, normal purchase price',0,0,'items.price',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','h','Serial Enumeration / chronology','Serial Enumeration / chronology',0,0,'items.enumchron',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','j','Shelving control number','Shelving control number',0,0,'items.stack',10,'STACK','','',NULL,0,'FA','',NULL,NULL), - ('952','l','Koha issues (times borrowed)','Koha issues (times borrowed)',0,0,'items.issues',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','m','Koha renewals','Koha renewals',0,0,'items.renewals',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','n','Koha reserves (requests)','Koha reserves (requests)',0,0,'items.reserves',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','o','Koha full call number','Koha full call number',0,0,'items.itemcallnumber',10,'','',NULL,NULL,0,'FA','',NULL,NULL), - ('952','p','Piece designation (barcode)','Piece designation (barcode)',0,0,'items.barcode',10,'','','barcode.pl',NULL,0,'FA','',NULL,NULL), - ('952','q','Koha out on loan','Koha out on loan',0,0,'items.onloan',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','r','Koha date last seen','Koha date last seen',0,0,'items.datelastseen',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','s','Koha date last borrowed','Koha date last borrowed',0,0,'items.datelastborrowed',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','t','Copy number','Copy number',0,0,'items.copynumber',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.itemnotes_nonpublic',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL), - ('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',NULL,0,'FA','',NULL,NULL), - ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), - ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index a183658..0000000 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing. diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..3b5d7bb --- /dev/null +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,138 @@ +INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Fast Add Framework' ); +INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES + ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), + ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'FA'), + ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'FA'), + ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'FA'), + ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'FA'), + ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'), + ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 1, 0, '', 'FA'), + ('099', 'LOCAL FREE-TEXT CALL NUMBER', 'LOCAL FREE-TEXT CALL NUMBER', 1, 0, '', 'FA'), + ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'), + ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'), + ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'), + ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'), + ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'), + ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'), + ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'), + ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'), + ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'FA'); + +INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES + ('000','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_leader.pl',NULL,0,'FA','',NULL,NULL), + ('008','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_field_008.pl',NULL,0,'FA','',NULL,NULL), + ('010','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('010','a','LC control number','LC control number',0,0,'biblioitems.lccn',0,'','','',0,0,'FA',NULL,'',''), + ('010','b','NUCMC control number','NUCMC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('010','z','Canceled/invalid LC control number','Canceled/invalid LC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','a','International Standard Book Number','International Standard Book Number',0,0,'biblioitems.isbn',0,'','','',0,0,'FA',NULL,'',''), + ('020','c','Terms of availability','Terms of availability',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','z','Cancelled/invalid ISBN','Cancelled/invalid ISBN',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('082','2','Edition number','Edition number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','6','Linkage','Linkage',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','a','Classification number','Classification number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','b','Item number','Item number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('090', 'a', 'Local Classification number (NR)', 'Local Classification number (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), + ('090', 'b', 'Local cutter number', 'Local cutter number', 0, 0, '', 0, '', '','', 0, 5, 'FA', '', '', NULL), + ('100','4','Relator code','Relator code',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','9','9 (RLIN)','9 (RLIN)',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','a','Personal name','Personal name',0,0,'biblio.author',0,'','PERSO_NAME','',0,0,'FA',NULL,'',''), + ('100','b','Numeration','Numeration',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','c','Titles and other words associated with a name','Titles and other words associated with a name',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','d','Dates associated with a name','Dates associated with a name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','e','Relator term','Relator term',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','f','Date of a work','Date of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','g','Miscellaneous information','Miscellaneous information',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','j','Attribution qualifier','Attribution qualifier',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','k','Form subheading','Form subheading',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','l','Language of a work','Language of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','q','Fuller form of name','Fuller form of name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','t','Title of a work','Title of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','u','Affiliation','Affiliation',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','a','Title','Title',0,1,'biblio.title',0,'','','',0,0,'FA',NULL,'',''), + ('245','b','Remainder of title','Remainder of title',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','c','Statement of responsibility, etc','Statement of responsibility, etc',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','d','Designation of section/part/series (SE) [OBSOLETE]','Designation of section section/part/series: (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','e','Name of part/section/series (SE) [OBSOLETE]','Name of part/section/series (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','f','Inclusive dates','Inclusive dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','g','Bulk dates','Bulk dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','h','Medium','Medium',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','k','Form','Form',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','s','Version','Version',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','a','Edition statement','Edition statement',0,0,'biblioitems.editionstatement',0,'','','',0,0,'FA',NULL,'',''), + ('250','b','Remainder of edition statement','Remainder of edition statement',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','a','Place of publication, distribution, etc','Place of publication, distribution, etc',1,0,'biblioitems.place',0,'','','',0,0,'FA',NULL,'',''), + ('260','b','Name of publisher, distributor, etc','Name of publisher, distributor, etc',1,0,'biblioitems.publishercode',0,'','','',0,0,'FA',NULL,'',''), + ('260','c','Date of publication, distribution, etc','Date of publication, distribution, etc',1,0,'biblio.copyrightdate',0,'','','',0,0,'FA',NULL,'',''), + ('260','d','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','e','Place of manufacture','Place of manufacture',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','f','Manufacturer','Manufacturer',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','g','Date of manufacture','Date of manufacture',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','k','Identification/manufacturer number [OBSOLETE, CAN/MARC]','Identification/manufacturer number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','l','Matrix and/or take number [OBSOLETE, CAN/MARC]','Matrix and/or take number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','3','Materials specified','Materials specified',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','5','Institution to which field applies','Institution to which field applies',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','a','General note','General note',0,0,'biblio.notes',0,'','','',0,0,'FA',NULL,'',''), + ('500','l','Library of Congress call number (SE) [OBSOLETE]','Library of Congress call number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','n','n (RLIN) [OBSOLETE]','n (RLIN) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','x','International Standard Serial Number (SE) [OBSOLETE]','International Standard Serial Number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','z','Source of note information (AM SE) [OBSOLETE]','Source of note information (AM SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), + ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), + ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), + ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), + ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','4','Damaged status','Damaged status',0,0,'items.damaged',10,'DAMAGED','','',NULL,0,'FA','',NULL,NULL), + ('952','5','Use restrictions','Use restrictions',0,0,'items.restricted',10,'RESTRICTED','','',NULL,0,'FA','',NULL,NULL), + ('952','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'items.cn_sort',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','7','Not for loan','Not for loan',0,0,'items.notforloan',10,'NOT_LOAN','','',NULL,0,'FA','',NULL,NULL), + ('952','8','Koha collection','Koha collection',0,0,'items.ccode',10,'CCODE','','',NULL,0,'FA','',NULL,NULL), + ('952','9','Koha itemnumber (autogenerated)','Koha itemnumber',0,0,'items.itemnumber',-1,'','','',NULL,0,'FA','',NULL,NULL), + ('952','a','Location (home branch)','Location (home branch)',0,0,'items.homebranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), + ('952','b','Sublocation or collection (holding branch)','Sublocation or collection (holding branch)',0,0,'items.holdingbranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), + ('952','c','Shelving location','Shelving location',0,0,'items.location',10,'LOC','','',NULL,0,'FA','',NULL,NULL), + ('952','d','Date acquired','Date acquired',0,0,'items.dateaccessioned',10,'','','dateaccessioned.pl',NULL,0,'FA','',NULL,NULL), + ('952','e','Source of acquisition','Source of acquisition',0,0,'items.booksellerid',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','f','Coded location qualifier','Coded location qualifier',0,0,'items.coded_location_qualifier',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','g','Cost, normal purchase price','Cost, normal purchase price',0,0,'items.price',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','h','Serial Enumeration / chronology','Serial Enumeration / chronology',0,0,'items.enumchron',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','j','Shelving control number','Shelving control number',0,0,'items.stack',10,'STACK','','',NULL,0,'FA','',NULL,NULL), + ('952','l','Koha issues (times borrowed)','Koha issues (times borrowed)',0,0,'items.issues',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','m','Koha renewals','Koha renewals',0,0,'items.renewals',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','n','Koha reserves (requests)','Koha reserves (requests)',0,0,'items.reserves',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','o','Koha full call number','Koha full call number',0,0,'items.itemcallnumber',10,'','',NULL,NULL,0,'FA','',NULL,NULL), + ('952','p','Piece designation (barcode)','Piece designation (barcode)',0,0,'items.barcode',10,'','','barcode.pl',NULL,0,'FA','',NULL,NULL), + ('952','q','Koha out on loan','Koha out on loan',0,0,'items.onloan',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','r','Koha date last seen','Koha date last seen',0,0,'items.datelastseen',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','s','Koha date last borrowed','Koha date last borrowed',0,0,'items.datelastborrowed',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','t','Copy number','Copy number',0,0,'items.copynumber',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.itemnotes_nonpublic',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL), + ('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',NULL,0,'FA','',NULL,NULL), + ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), + ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..a183658 --- /dev/null +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing. diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql deleted file mode 100644 index 77dde7e..0000000 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ /dev/null @@ -1,139 +0,0 @@ -INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Fast Add Framework' ); -INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES - ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), - ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'FA'), - ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'FA'), - ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'FA'), - ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'FA'), - ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'), - ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 1, 0, '', 'FA'), - ('099', 'LOCAL FREE-TEXT CALL NUMBER', 'LOCAL FREE-TEXT CALL NUMBER', 1, 0, '', 'FA'), - ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'), - ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'), - ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'), - ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'), - ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'), - ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'), - ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'), - ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'), - ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'FA'); - -INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('000','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_leader.pl',NULL,0,'FA','',NULL,NULL), - ('008','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_field_008.pl',NULL,0,'FA','',NULL,NULL), - ('010','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('010','a','LC control number','LC control number',0,0,'biblioitems.lccn',0,'','','',0,0,'FA',NULL,'',''), - ('010','b','NUCMC control number','NUCMC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('010','z','Canceled/invalid LC control number','Canceled/invalid LC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','a','International Standard Book Number','International Standard Book Number',0,0,'biblioitems.isbn',0,'','','',0,0,'FA',NULL,'',''), - ('020','c','Terms of availability','Terms of availability',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('020','z','Cancelled/invalid ISBN','Cancelled/invalid ISBN',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), - ('082','2','Edition number','Edition number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','6','Linkage','Linkage',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','a','Classification number','Classification number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('082','b','Item number','Item number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), - ('090', 'a', 'Local Classification number (NR)', 'Local Classification number (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), - ('090', 'b', 'Local cutter number', 'Local cutter number', 0, 0, '', 0, '', '','', 0, 5, 'FA', '', '', NULL), - ('100','4','Relator code','Relator code',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','9','9 (RLIN)','9 (RLIN)',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','a','Personal name','Personal name',0,0,'biblio.author',0,'','PERSO_NAME','',0,0,'FA',NULL,'',''), - ('100','b','Numeration','Numeration',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','c','Titles and other words associated with a name','Titles and other words associated with a name',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','d','Dates associated with a name','Dates associated with a name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','e','Relator term','Relator term',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','f','Date of a work','Date of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','g','Miscellaneous information','Miscellaneous information',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','j','Attribution qualifier','Attribution qualifier',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','k','Form subheading','Form subheading',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','l','Language of a work','Language of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','q','Fuller form of name','Fuller form of name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','t','Title of a work','Title of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('100','u','Affiliation','Affiliation',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','a','Title','Title',0,1,'biblio.title',0,'','','',0,0,'FA',NULL,'',''), - ('245','b','Remainder of title','Remainder of title',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','c','Statement of responsibility, etc','Statement of responsibility, etc',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','d','Designation of section/part/series (SE) [OBSOLETE]','Designation of section section/part/series: (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','e','Name of part/section/series (SE) [OBSOLETE]','Name of part/section/series (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','f','Inclusive dates','Inclusive dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','g','Bulk dates','Bulk dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','h','Medium','Medium',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','k','Form','Form',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('245','s','Version','Version',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('250','a','Edition statement','Edition statement',0,0,'biblioitems.editionstatement',0,'','','',0,0,'FA',NULL,'',''), - ('250','b','Remainder of edition statement','Remainder of edition statement',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','a','Place of publication, distribution, etc','Place of publication, distribution, etc',1,0,'biblioitems.place',0,'','','',0,0,'FA',NULL,'',''), - ('260','b','Name of publisher, distributor, etc','Name of publisher, distributor, etc',1,0,'biblioitems.publishercode',0,'','','',0,0,'FA',NULL,'',''), - ('260','c','Date of publication, distribution, etc','Date of publication, distribution, etc',1,0,'biblio.copyrightdate',0,'','','',0,0,'FA',NULL,'',''), - ('260','d','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','e','Place of manufacture','Place of manufacture',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','f','Manufacturer','Manufacturer',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','g','Date of manufacture','Date of manufacture',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','k','Identification/manufacturer number [OBSOLETE, CAN/MARC]','Identification/manufacturer number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('260','l','Matrix and/or take number [OBSOLETE, CAN/MARC]','Matrix and/or take number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','3','Materials specified','Materials specified',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','5','Institution to which field applies','Institution to which field applies',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','a','General note','General note',0,0,'biblio.notes',0,'','','',0,0,'FA',NULL,'',''), - ('500','l','Library of Congress call number (SE) [OBSOLETE]','Library of Congress call number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','n','n (RLIN) [OBSOLETE]','n (RLIN) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','x','International Standard Serial Number (SE) [OBSOLETE]','International Standard Serial Number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('500','z','Source of note information (AM SE) [OBSOLETE]','Source of note information (AM SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), - ('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), - ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), - ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), - ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), - ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), - ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), - ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','4','Damaged status','Damaged status',0,0,'items.damaged',10,'DAMAGED','','',NULL,0,'FA','',NULL,NULL), - ('952','5','Use restrictions','Use restrictions',0,0,'items.restricted',10,'RESTRICTED','','',NULL,0,'FA','',NULL,NULL), - ('952','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'items.cn_sort',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','7','Not for loan','Not for loan',0,0,'items.notforloan',10,'NOT_LOAN','','',NULL,0,'FA','',NULL,NULL), - ('952','8','Koha collection','Koha collection',0,0,'items.ccode',10,'CCODE','','',NULL,0,'FA','',NULL,NULL), - ('952','9','Koha itemnumber (autogenerated)','Koha itemnumber',0,0,'items.itemnumber',-1,'','','',NULL,0,'FA','',NULL,NULL), - ('952','a','Location (home branch)','Location (home branch)',0,0,'items.homebranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), - ('952','b','Sublocation or collection (holding branch)','Sublocation or collection (holding branch)',0,0,'items.holdingbranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), - ('952','c','Shelving location','Shelving location',0,0,'items.location',10,'LOC','','',NULL,0,'FA','',NULL,NULL), - ('952','d','Date acquired','Date acquired',0,0,'items.dateaccessioned',10,'','','dateaccessioned.pl',NULL,0,'FA','',NULL,NULL), - ('952','e','Source of acquisition','Source of acquisition',0,0,'items.booksellerid',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','f','Coded location qualifier','Coded location qualifier',0,0,'items.coded_location_qualifier',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','g','Cost, normal purchase price','Cost, normal purchase price',0,0,'items.price',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','h','Serial Enumeration / chronology','Serial Enumeration / chronology',0,0,'items.enumchron',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','i','Inventory number','Inventory number',0,0,'items.stocknumber',10,'','','',0,0,'FA','',NULL,NULL), - ('952','j','Shelving control number','Shelving control number',0,0,'items.stack',10,'STACK','','',NULL,0,'FA','',NULL,NULL), - ('952','l','Koha issues (times borrowed)','Koha issues (times borrowed)',0,0,'items.issues',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','m','Koha renewals','Koha renewals',0,0,'items.renewals',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','n','Koha reserves (requests)','Koha reserves (requests)',0,0,'items.reserves',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','o','Koha full call number','Koha full call number',0,0,'items.itemcallnumber',10,'','',NULL,NULL,0,'FA','',NULL,NULL), - ('952','p','Piece designation (barcode)','Piece designation (barcode)',0,0,'items.barcode',10,'','','barcode.pl',NULL,0,'FA','',NULL,NULL), - ('952','q','Koha out on loan','Koha out on loan',0,0,'items.onloan',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','r','Koha date last seen','Koha date last seen',0,0,'items.datelastseen',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','s','Koha date last borrowed','Koha date last borrowed',0,0,'items.datelastborrowed',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','t','Copy number','Copy number',0,0,'items.copynumber',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.paidfor',10,'','','',NULL,0,'FA','',NULL,NULL), - ('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL), - ('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',NULL,0,'FA','',NULL,NULL), - ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), - ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.txt b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.txt deleted file mode 100644 index 40917db..0000000 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.txt +++ /dev/null @@ -1 +0,0 @@ -"Opis skrócony" minimalny szablon MARC21 przydatny w wypożyczeniach międzybibliotecznych i przy szybkim katalogowaniu. diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql new file mode 100644 index 0000000..77dde7e --- /dev/null +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql @@ -0,0 +1,139 @@ +INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Fast Add Framework' ); +INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES + ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'), + ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'FA'), + ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'FA'), + ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'FA'), + ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'FA'), + ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'), + ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER', 1, 0, '', 'FA'), + ('099', 'LOCAL FREE-TEXT CALL NUMBER', 'LOCAL FREE-TEXT CALL NUMBER', 1, 0, '', 'FA'), + ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'), + ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'), + ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'), + ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'), + ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'), + ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'), + ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'), + ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'), + ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'FA'); + +INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES + ('000','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_leader.pl',NULL,0,'FA','',NULL,NULL), + ('008','@','fixed length control field','fixed length control field',0,1,'',0,'','','marc21_field_008.pl',NULL,0,'FA','',NULL,NULL), + ('010','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('010','a','LC control number','LC control number',0,0,'biblioitems.lccn',0,'','','',0,0,'FA',NULL,'',''), + ('010','b','NUCMC control number','NUCMC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('010','z','Canceled/invalid LC control number','Canceled/invalid LC control number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','a','International Standard Book Number','International Standard Book Number',0,0,'biblioitems.isbn',0,'','','',0,0,'FA',NULL,'',''), + ('020','c','Terms of availability','Terms of availability',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('020','z','Cancelled/invalid ISBN','Cancelled/invalid ISBN',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL), + ('082','2','Edition number','Edition number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','6','Linkage','Linkage',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','a','Classification number','Classification number',1,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('082','b','Item number','Item number',0,0,'',0,'','','',NULL,0,'FA','',NULL,NULL), + ('090', 'a', 'Local Classification number (NR)', 'Local Classification number (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL), + ('090', 'b', 'Local cutter number', 'Local cutter number', 0, 0, '', 0, '', '','', 0, 5, 'FA', '', '', NULL), + ('100','4','Relator code','Relator code',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','9','9 (RLIN)','9 (RLIN)',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','a','Personal name','Personal name',0,0,'biblio.author',0,'','PERSO_NAME','',0,0,'FA',NULL,'',''), + ('100','b','Numeration','Numeration',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','c','Titles and other words associated with a name','Titles and other words associated with a name',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','d','Dates associated with a name','Dates associated with a name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','e','Relator term','Relator term',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','f','Date of a work','Date of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','g','Miscellaneous information','Miscellaneous information',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','j','Attribution qualifier','Attribution qualifier',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','k','Form subheading','Form subheading',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','l','Language of a work','Language of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','q','Fuller form of name','Fuller form of name',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','t','Title of a work','Title of a work',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('100','u','Affiliation','Affiliation',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','a','Title','Title',0,1,'biblio.title',0,'','','',0,0,'FA',NULL,'',''), + ('245','b','Remainder of title','Remainder of title',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','c','Statement of responsibility, etc','Statement of responsibility, etc',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','d','Designation of section/part/series (SE) [OBSOLETE]','Designation of section section/part/series: (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','e','Name of part/section/series (SE) [OBSOLETE]','Name of part/section/series (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','f','Inclusive dates','Inclusive dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','g','Bulk dates','Bulk dates',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','h','Medium','Medium',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','k','Form','Form',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','n','Number of part/section of a work','Number of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','p','Name of part/section of a work','Name of part/section of a work',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('245','s','Version','Version',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('250','a','Edition statement','Edition statement',0,0,'biblioitems.editionstatement',0,'','','',0,0,'FA',NULL,'',''), + ('250','b','Remainder of edition statement','Remainder of edition statement',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','a','Place of publication, distribution, etc','Place of publication, distribution, etc',1,0,'biblioitems.place',0,'','','',0,0,'FA',NULL,'',''), + ('260','b','Name of publisher, distributor, etc','Name of publisher, distributor, etc',1,0,'biblioitems.publishercode',0,'','','',0,0,'FA',NULL,'',''), + ('260','c','Date of publication, distribution, etc','Date of publication, distribution, etc',1,0,'biblio.copyrightdate',0,'','','',0,0,'FA',NULL,'',''), + ('260','d','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','e','Place of manufacture','Place of manufacture',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','f','Manufacturer','Manufacturer',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','g','Date of manufacture','Date of manufacture',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','k','Identification/manufacturer number [OBSOLETE, CAN/MARC]','Identification/manufacturer number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('260','l','Matrix and/or take number [OBSOLETE, CAN/MARC]','Matrix and/or take number [OBSOLETE, CAN/MARC]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','3','Materials specified','Materials specified',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','5','Institution to which field applies','Institution to which field applies',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','6','Linkage','Linkage',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','a','General note','General note',0,0,'biblio.notes',0,'','','',0,0,'FA',NULL,'',''), + ('500','l','Library of Congress call number (SE) [OBSOLETE]','Library of Congress call number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','n','n (RLIN) [OBSOLETE]','n (RLIN) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','x','International Standard Serial Number (SE) [OBSOLETE]','International Standard Serial Number (SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('500','z','Source of note information (AM SE) [OBSOLETE]','Source of note information (AM SE) [OBSOLETE]',0,0,'',0,'','','',0,0,'FA',NULL,'',''), + ('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), + ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), + ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), + ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), + ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), + ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), + ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','4','Damaged status','Damaged status',0,0,'items.damaged',10,'DAMAGED','','',NULL,0,'FA','',NULL,NULL), + ('952','5','Use restrictions','Use restrictions',0,0,'items.restricted',10,'RESTRICTED','','',NULL,0,'FA','',NULL,NULL), + ('952','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'items.cn_sort',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','7','Not for loan','Not for loan',0,0,'items.notforloan',10,'NOT_LOAN','','',NULL,0,'FA','',NULL,NULL), + ('952','8','Koha collection','Koha collection',0,0,'items.ccode',10,'CCODE','','',NULL,0,'FA','',NULL,NULL), + ('952','9','Koha itemnumber (autogenerated)','Koha itemnumber',0,0,'items.itemnumber',-1,'','','',NULL,0,'FA','',NULL,NULL), + ('952','a','Location (home branch)','Location (home branch)',0,0,'items.homebranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), + ('952','b','Sublocation or collection (holding branch)','Sublocation or collection (holding branch)',0,0,'items.holdingbranch',10,'branches','','',NULL,0,'FA','',NULL,NULL), + ('952','c','Shelving location','Shelving location',0,0,'items.location',10,'LOC','','',NULL,0,'FA','',NULL,NULL), + ('952','d','Date acquired','Date acquired',0,0,'items.dateaccessioned',10,'','','dateaccessioned.pl',NULL,0,'FA','',NULL,NULL), + ('952','e','Source of acquisition','Source of acquisition',0,0,'items.booksellerid',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','f','Coded location qualifier','Coded location qualifier',0,0,'items.coded_location_qualifier',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','g','Cost, normal purchase price','Cost, normal purchase price',0,0,'items.price',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','h','Serial Enumeration / chronology','Serial Enumeration / chronology',0,0,'items.enumchron',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','i','Inventory number','Inventory number',0,0,'items.stocknumber',10,'','','',0,0,'FA','',NULL,NULL), + ('952','j','Shelving control number','Shelving control number',0,0,'items.stack',10,'STACK','','',NULL,0,'FA','',NULL,NULL), + ('952','l','Koha issues (times borrowed)','Koha issues (times borrowed)',0,0,'items.issues',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','m','Koha renewals','Koha renewals',0,0,'items.renewals',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','n','Koha reserves (requests)','Koha reserves (requests)',0,0,'items.reserves',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','o','Koha full call number','Koha full call number',0,0,'items.itemcallnumber',10,'','',NULL,NULL,0,'FA','',NULL,NULL), + ('952','p','Piece designation (barcode)','Piece designation (barcode)',0,0,'items.barcode',10,'','','barcode.pl',NULL,0,'FA','',NULL,NULL), + ('952','q','Koha out on loan','Koha out on loan',0,0,'items.onloan',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','r','Koha date last seen','Koha date last seen',0,0,'items.datelastseen',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','s','Koha date last borrowed','Koha date last borrowed',0,0,'items.datelastborrowed',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','t','Copy number','Copy number',0,0,'items.copynumber',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.paidfor',10,'','','',NULL,0,'FA','',NULL,NULL), + ('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',NULL,0,'FA','',NULL,NULL), + ('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',NULL,0,'FA','',NULL,NULL), + ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL), + ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt new file mode 100644 index 0000000..40917db --- /dev/null +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt @@ -0,0 +1 @@ +"Opis skrócony" minimalny szablon MARC21 przydatny w wypożyczeniach międzybibliotecznych i przy szybkim katalogowaniu. -- 2.1.4