-- *******************************************************
-- KOHA 3.0 MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
--
--                  PRETEST VERSION 0.0.9
--                       2007-09-29
--
--                         edited
--                   by thd for LibLime
--
--                       BASED UPON
--
--   KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
--
--                  PRETEST VERSION 0.0.6
--                       2007-09-29
--
--  original default requiring greater user customisation
--               created by a few Koha Hands
--                 guided by Paul POULAIN
--
--       revised and greatly enlarged to completion,
--            well not quite complete yet today
--        but close enough for someone to have use,
--                   by thd for LibLime
-- *******************************************************


--SET CONSTRAINTS ALL DEFERRED;


-- ******************************************************
-- KOHA DEFAULT MARC 21 AUTHORITY TYPE.
-- ******************************************************

-- This authority type includes all fields and subfieds used by any
-- authority type.

INSERT INTO auth_types (authtypecode, authtypetext, auth_tag_to_report, summary) VALUES
('', 'Default', '', '');


-- ******************************************************
-- KOHA SUPPORTED STANDARD MARC 21 AUTHORITY TYPES.
-- ******************************************************

-- These authority types are supported for for guiding the cataloguer to
-- fill authorised values in Koha MARC bibliographic editor.


INSERT INTO auth_types (authtypecode, authtypetext, auth_tag_to_report, summary) VALUES
('PERSO_NAME', 'Personal Name', '100', 'Personal Names'),
('CORPO_NAME', 'Corporate Name', '110', 'Corporate Names'),
('MEETI_NAME', 'Meeting Name', '111', 'Meeting Name'),
('UNIF_TITLE', 'Uniform Title', '130', 'Uniform Title'),
('CHRON_TERM', 'Chronological Term', '148', 'Chronological Term'),
('TOPIC_TERM', 'Topical Term', '150', 'Topical Term'),
('GEOGR_NAME', 'Geographic Name', '151', 'Geographic Name'),
('GENRE/FORM', 'Genre/Form Term', '155', 'Genre/Form Term');


-- ******************************************************
-- KOHA UNSUPPORTED STANDARD MARC 21 AUTHORITY TYPES.
-- ******************************************************

-- These authority types are only supported for guiding the cataloguer to
-- fill authorised values in the Koha MARC bibliographic editor to the
-- extent that they have already been included in a primary authority type,
-- therefore, they have not yet been specified.
--
-- Minimal primary authorities including subdivisions may currently be
-- built by a script which uses the values in bibliographic records but
-- include no tracings and references which are necessarily not present
-- in bibliographic records.


-- INSERT INTO auth_types (authtypecode, authtypetext, auth_tag_to_report, summary) VALUES
-- ('TOPIC_SUBD', 'General Topical Term Subdivision', '180', 'General Topical Term Subdivision'),
-- ('GEOGR_SUBD', 'Geographic Subdivision', '181', 'Geographic Subdivision'),
-- ('CHRON_SUBD', 'Chronological Subdivision', '182', 'Chronological Subdivision'),
-- ('FORM_SUBDI', 'Form Subdivision', '185', 'Form Subdivision');



-- *****************************************************************
-- MARC 21 AUTHORITY FIELDS/SUBFIELDS AND COMMMONLY USED EXTENSIONS
-- *****************************************************************


-- No support for subfield visibility is yet provided by the Koha code
-- matching the column name 'hidden' in the bibliographic framework.
--
-- Needs checking for errors but probably tolerable for use on a production.
-- A server can be upgraded easily from later versions of this file.
--
-- In the absense of more column support for qualifying the relative
-- importance of subfields to the record editor, some modest modification of
-- the default framework is needed setting the not-useful non-Koha holdings
-- subfields to not managed in Koha.

-- MARC fields including letters as part of the field identifier are from RLIN
-- and should be expected to remain along with RLIN $% subfields.  RLIN has
-- been using letters in fields because there are not enough local use number
-- fields which have not already been specified for very large union catalogue
-- networks such as RLIN itself.

-- Fields ending in a or b are temporary placeholders for information from
-- a numeric value until a non-conflicting way to treat the content under the
-- proper original numeric field is adopted.  090 for LC call numbers is much
-- too common and important so 999 is also provided as a temporary place
-- holder until all Koha code for finding control fields has been changed from
-- a numeric test of < 10 to a regular expression match of m/^00/ to prevent
-- mistaken matching of fields with letters such as 09o if they were control
-- fields.

-- Fields and subfields which belong exclusively in a classification
-- framework have been marked '[CLASSIFICATION FRAMEWORK]'.  They are retained
-- or included here becuase some had been included previously and Koha does
-- not yet have a classification framework.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('', '014', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 1, 0, NULL),
('', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('', '020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL),
('', '022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL),
('', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('', '031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, NULL),
('', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('', '058', 'LC CLASSIFICATION NUMBER ASSIGNED IN CANADA [OBSOLETE, CAN/MARC]', 'LC CLASSIFICATION NUMBER ASSIGNED IN CANADA [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('', '063', 'NLM CLASSIFICATION NUMBER ASSIGNED BY NLM [OBSOLETE, CAN/MARC]', 'NLM CLASSIFICATION NUMBER ASSIGNED BY NLM [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('', '068', 'NLM CLASSIFICATION NUMBER ASSIGNED IN CANADA [OBSOLETE, CAN/MARC]', 'NLM CLASSIFICATION NUMBER ASSIGNED IN CANADA [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('', '084', 'CLASSIFICATION SCHEME AND EDITION [CLASSIFICATION FORMAT]', 'CLASSIFICATION SCHEME AND EDITION [CLASSIFICATION FORMAT]', 0, 0, NULL),
('', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('', '088', 'DOCUMENT SHELVING NUMBER (CODOC) [OBSOLETE, CAN/MARC]', 'DOCUMENT SHELVING NUMBER (CODOC) [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
('', '185', 'HEADING--FORM SUBDIVISION', 'HEADING--FORM SUBDIVISION', 0, 0, NULL),
('', '253', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('', '353', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('', '453', 'INVALID NUMBER TRACING [CLASSIFICATION FORMAT]', 'INVALID NUMBER TRACING [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('', '553', 'VALID NUMBER TRACING [CLASSIFICATION FORMAT]', 'VALID NUMBER TRACING [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('', '640', 'SERIES DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 'SERIES DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 1, 0, NULL),
('', '641', 'SERIES NUMBERING PECULIARITIES', 'SERIES NUMBERING PECULIARITIES', 1, 0, NULL),
('', '642', 'SERIES NUMBERING EXAMPLE', 'SERIES NUMBERING EXAMPLE', 1, 0, NULL),
('', '643', 'SERIES PLACE AND PUBLISHER/ISSUING BODY', 'SERIES PLACE AND PUBLISHER/ISSUING BODY', 1, 0, NULL),
('', '644', 'SERIES ANALYSIS PRACTICE', 'SERIES ANALYSIS PRACTICE', 1, 0, NULL),
('', '645', 'SERIES TRACING PRACTICE', 'SERIES TRACING PRACTICE', 1, 0, NULL),
('', '646', 'SERIES CLASSIFICATION PRACTICE', 'SERIES CLASSIFICATION PRACTICE', 1, 0, NULL),
('', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('', '668', 'CHARACTERS IN NONROMAN ALPHABETS [OBSOLETE]', 'CHARACTERS IN NONROMAN ALPHABETS [OBSOLETE]', 1, 0, NULL),
('', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('', '671', 'NOTE--WORK CATALOGUED [OBSOLETE, CAN/MARC ONLY]', 'NOTE--WORK CATALOGUED [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
('', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('', '676', 'NOTE--CATALOGUING RULES (NAMES/TITLES) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--CATALOGUING RULES (NAMES/TITLES) [OBSOLETE, CAN/MARC ONLY]', 0, 0, NULL),
('', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('', '684', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '685', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
('', '68a', 'HISTORY NOTE [CLASSIFICATION FORMAT]', 'HISTORY NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '686', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
('', '68b', 'RELATIONSHIP TO SOURCE NOTE [CLASSIFICATION FORMAT]', 'RELATIONSHIP TO SOURCE NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '687', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
('', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('', '700', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 1, 0, NULL),
('', '710', 'ESTABLISHED HEADING LINKING ENTRY--CORPORATE NAME', 'ESTABLISHED HEADING LINKING ENTRY--CORPORATE NAME', 1, 0, NULL),
('', '711', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 1, 0, NULL),
('', '730', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 1, 0, NULL),
('', '748', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 1, 0, NULL),
('', '750', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 1, 0, NULL),
('', '751', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 1, 0, NULL),
('', '753', 'INDEX TERM--UNCONTROLLED [CLASSIFICATION FORMAT]', 'INDEX TERM--UNCONTROLLED [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '754', 'INDEX TERM--FACETED TOPICAL TERMS [CLASSIFICATION FORMAT]', 'INDEX TERM--FACETED TOPICAL TERMS [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '755', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 1, 0, NULL),
('', '761', 'ADD OR DIVIDE LIKE INSTRUCTIONS [CLASSIFICATION FORMAT]', 'ADD OR DIVIDE LIKE INSTRUCTIONS [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '762', 'TABLE IDENTIFICATION [CLASSIFICATION FORMAT]', 'TABLE IDENTIFICATION [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '763', 'INTERNAL SUBARRANGEMENT OR ADD TABLE ENTRY [CLASSIFICATION FORMAT]', 'INTERNAL SUBARRANGEMENT OR ADD TABLE ENTRY [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '764', 'RULE IDENTIFICATION [CLASSIFICATION FORMAT]', 'RULE IDENTIFICATION [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '765', 'SYNTHESIZED NUMBER COMPONENTS [CLASSIFICATION FORMAT]', 'SYNTHESIZED NUMBER COMPONENTS [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '766', 'SECONDARY TABLE INFORMATION [CLASSIFICATION FORMAT]', 'SECONDARY TABLE INFORMATION [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '768', 'CITATION AND PREFERENCE ORDER INSTRUCTIONS [CLASSIFICATION FORMAT]', 'CITATION AND PREFERENCE ORDER INSTRUCTIONS [CLASSIFICATION FORMAT]', 1, 0, NULL),
('', '780', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 1, 0, NULL),
('', '781', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('', '782', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('', '785', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 1, 0, NULL),
('', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);






-- ******************************************************



-- *******************************************************************
-- PERSONAL NAME AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('PERSO_NAME', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('PERSO_NAME', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('PERSO_NAME', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('PERSO_NAME', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('PERSO_NAME', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('PERSO_NAME', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('PERSO_NAME', '014', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 1, 0, NULL),
('PERSO_NAME', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('PERSO_NAME', '020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL),
('PERSO_NAME', '022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL),
('PERSO_NAME', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('PERSO_NAME', '031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, NULL),
('PERSO_NAME', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('PERSO_NAME', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('PERSO_NAME', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('PERSO_NAME', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('PERSO_NAME', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('PERSO_NAME', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('PERSO_NAME', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('PERSO_NAME', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('PERSO_NAME', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('PERSO_NAME', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('PERSO_NAME', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('PERSO_NAME', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('PERSO_NAME', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('PERSO_NAME', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('PERSO_NAME', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('PERSO_NAME', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('PERSO_NAME', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('PERSO_NAME', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
('PERSO_NAME', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('PERSO_NAME', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('PERSO_NAME', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('PERSO_NAME', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('PERSO_NAME', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('PERSO_NAME', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('PERSO_NAME', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('PERSO_NAME', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('PERSO_NAME', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('PERSO_NAME', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('PERSO_NAME', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('PERSO_NAME', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('PERSO_NAME', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('PERSO_NAME', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('PERSO_NAME', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('PERSO_NAME', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('PERSO_NAME', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('PERSO_NAME', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('PERSO_NAME', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('PERSO_NAME', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('PERSO_NAME', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('PERSO_NAME', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('PERSO_NAME', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('PERSO_NAME', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('PERSO_NAME', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('PERSO_NAME', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('PERSO_NAME', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('PERSO_NAME', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('PERSO_NAME', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('PERSO_NAME', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('PERSO_NAME', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('PERSO_NAME', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('PERSO_NAME', '700', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 1, 0, NULL),
('PERSO_NAME', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('PERSO_NAME', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('PERSO_NAME', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- CORPORATE NAME AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('CORPO_NAME', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('CORPO_NAME', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('CORPO_NAME', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('CORPO_NAME', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('CORPO_NAME', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('CORPO_NAME', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('CORPO_NAME', '014', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 1, 0, NULL),
('CORPO_NAME', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('CORPO_NAME', '020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL),
('CORPO_NAME', '022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL),
('CORPO_NAME', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('CORPO_NAME', '031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, NULL),
('CORPO_NAME', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('CORPO_NAME', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('CORPO_NAME', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('CORPO_NAME', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('CORPO_NAME', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('CORPO_NAME', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('CORPO_NAME', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('CORPO_NAME', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('CORPO_NAME', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('CORPO_NAME', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('CORPO_NAME', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('CORPO_NAME', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('CORPO_NAME', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('CORPO_NAME', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('CORPO_NAME', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('CORPO_NAME', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('CORPO_NAME', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('CORPO_NAME', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
('CORPO_NAME', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('CORPO_NAME', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('CORPO_NAME', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('CORPO_NAME', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('CORPO_NAME', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('CORPO_NAME', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('CORPO_NAME', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('CORPO_NAME', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('CORPO_NAME', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('CORPO_NAME', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('CORPO_NAME', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('CORPO_NAME', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('CORPO_NAME', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('CORPO_NAME', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('CORPO_NAME', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('CORPO_NAME', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('CORPO_NAME', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('CORPO_NAME', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('CORPO_NAME', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('CORPO_NAME', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('CORPO_NAME', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('CORPO_NAME', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('CORPO_NAME', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('CORPO_NAME', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('CORPO_NAME', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('CORPO_NAME', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('CORPO_NAME', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('CORPO_NAME', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('CORPO_NAME', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('CORPO_NAME', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('CORPO_NAME', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('CORPO_NAME', '700', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 1, 0, NULL),
('CORPO_NAME', '710', 'ESTABLISHED HEADING LINKING ENTRY--CORPORATE NAME', 'ESTABLISHED HEADING LINKING ENTRY--CORPORATE NAME', 1, 0, NULL),
('CORPO_NAME', '711', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 1, 0, NULL),
('CORPO_NAME', '730', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 1, 0, NULL),
('CORPO_NAME', '748', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 1, 0, NULL),
('CORPO_NAME', '750', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 1, 0, NULL),
('CORPO_NAME', '751', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 1, 0, NULL),
('CORPO_NAME', '755', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 1, 0, NULL),
('CORPO_NAME', '780', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '781', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '782', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '785', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 1, 0, NULL),
('CORPO_NAME', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('CORPO_NAME', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('CORPO_NAME', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- MEETING NAME AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('MEETI_NAME', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('MEETI_NAME', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('MEETI_NAME', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('MEETI_NAME', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('MEETI_NAME', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('MEETI_NAME', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('MEETI_NAME', '014', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 1, 0, NULL),
('MEETI_NAME', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('MEETI_NAME', '020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL),
('MEETI_NAME', '022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL),
('MEETI_NAME', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('MEETI_NAME', '031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, NULL),
('MEETI_NAME', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('MEETI_NAME', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('MEETI_NAME', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('MEETI_NAME', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('MEETI_NAME', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('MEETI_NAME', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('MEETI_NAME', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('MEETI_NAME', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('MEETI_NAME', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('MEETI_NAME', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('MEETI_NAME', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('MEETI_NAME', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('MEETI_NAME', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('MEETI_NAME', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('MEETI_NAME', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('MEETI_NAME', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('MEETI_NAME', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('MEETI_NAME', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('MEETI_NAME', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
('MEETI_NAME', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('MEETI_NAME', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('MEETI_NAME', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('MEETI_NAME', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('MEETI_NAME', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('MEETI_NAME', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('MEETI_NAME', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('MEETI_NAME', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('MEETI_NAME', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('MEETI_NAME', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('MEETI_NAME', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('MEETI_NAME', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('MEETI_NAME', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('MEETI_NAME', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('MEETI_NAME', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('MEETI_NAME', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('MEETI_NAME', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('MEETI_NAME', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('MEETI_NAME', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('MEETI_NAME', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('MEETI_NAME', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('MEETI_NAME', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('MEETI_NAME', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('MEETI_NAME', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('MEETI_NAME', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('MEETI_NAME', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('MEETI_NAME', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('MEETI_NAME', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('MEETI_NAME', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('MEETI_NAME', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('MEETI_NAME', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('MEETI_NAME', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('MEETI_NAME', '711', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 'ESTABLISHED HEADING LINKING ENTRY--MEETING NAME', 1, 0, NULL),
('MEETI_NAME', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('MEETI_NAME', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('MEETI_NAME', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- UNIFORM TITLE AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('UNIF_TITLE', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('UNIF_TITLE', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('UNIF_TITLE', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('UNIF_TITLE', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('UNIF_TITLE', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('UNIF_TITLE', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('UNIF_TITLE', '014', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 'LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM', 1, 0, NULL),
('UNIF_TITLE', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL),
('UNIF_TITLE', '022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('UNIF_TITLE', '031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, NULL),
('UNIF_TITLE', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('UNIF_TITLE', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('UNIF_TITLE', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('UNIF_TITLE', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('UNIF_TITLE', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('UNIF_TITLE', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('UNIF_TITLE', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('UNIF_TITLE', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('UNIF_TITLE', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('UNIF_TITLE', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('UNIF_TITLE', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('UNIF_TITLE', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('UNIF_TITLE', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('UNIF_TITLE', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('UNIF_TITLE', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('UNIF_TITLE', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('UNIF_TITLE', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
('UNIF_TITLE', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('UNIF_TITLE', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('UNIF_TITLE', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('UNIF_TITLE', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('UNIF_TITLE', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('UNIF_TITLE', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('UNIF_TITLE', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('UNIF_TITLE', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('UNIF_TITLE', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('UNIF_TITLE', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('UNIF_TITLE', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('UNIF_TITLE', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('UNIF_TITLE', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('UNIF_TITLE', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('UNIF_TITLE', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('UNIF_TITLE', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('UNIF_TITLE', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('UNIF_TITLE', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('UNIF_TITLE', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('UNIF_TITLE', '640', 'SERIES DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 'SERIES DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 1, 0, NULL),
('UNIF_TITLE', '641', 'SERIES NUMBERING PECULIARITIES', 'SERIES NUMBERING PECULIARITIES', 1, 0, NULL),
('UNIF_TITLE', '642', 'SERIES NUMBERING EXAMPLE', 'SERIES NUMBERING EXAMPLE', 1, 0, NULL),
('UNIF_TITLE', '643', 'SERIES PLACE AND PUBLISHER/ISSUING BODY', 'SERIES PLACE AND PUBLISHER/ISSUING BODY', 1, 0, NULL),
('UNIF_TITLE', '644', 'SERIES ANALYSIS PRACTICE', 'SERIES ANALYSIS PRACTICE', 1, 0, NULL),
('UNIF_TITLE', '645', 'SERIES TRACING PRACTICE', 'SERIES TRACING PRACTICE', 1, 0, NULL),
('UNIF_TITLE', '646', 'SERIES CLASSIFICATION PRACTICE', 'SERIES CLASSIFICATION PRACTICE', 1, 0, NULL),
('UNIF_TITLE', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('UNIF_TITLE', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('UNIF_TITLE', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('UNIF_TITLE', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('UNIF_TITLE', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('UNIF_TITLE', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('UNIF_TITLE', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('UNIF_TITLE', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('UNIF_TITLE', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('UNIF_TITLE', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('UNIF_TITLE', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('UNIF_TITLE', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('UNIF_TITLE', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('UNIF_TITLE', '730', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 'ESTABLISHED HEADING LINKING ENTRY--UNIFORM TITLE', 1, 0, NULL),
('UNIF_TITLE', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('UNIF_TITLE', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('UNIF_TITLE', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- TOPICAL TERM AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('CHRON_TERM', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('CHRON_TERM', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('CHRON_TERM', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('CHRON_TERM', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('CHRON_TERM', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('CHRON_TERM', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('CHRON_TERM', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('CHRON_TERM', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('CHRON_TERM', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('CHRON_TERM', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('CHRON_TERM', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('CHRON_TERM', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('CHRON_TERM', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('CHRON_TERM', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('CHRON_TERM', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('CHRON_TERM', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('CHRON_TERM', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('CHRON_TERM', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('CHRON_TERM', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('CHRON_TERM', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('CHRON_TERM', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('CHRON_TERM', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('CHRON_TERM', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('CHRON_TERM', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('CHRON_TERM', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('CHRON_TERM', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('CHRON_TERM', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
('CHRON_TERM', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
('CHRON_TERM', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('CHRON_TERM', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('CHRON_TERM', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('CHRON_TERM', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('CHRON_TERM', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('CHRON_TERM', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('CHRON_TERM', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('CHRON_TERM', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('CHRON_TERM', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('CHRON_TERM', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('CHRON_TERM', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('CHRON_TERM', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('CHRON_TERM', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('CHRON_TERM', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('CHRON_TERM', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('CHRON_TERM', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('CHRON_TERM', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('CHRON_TERM', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('CHRON_TERM', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('CHRON_TERM', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('CHRON_TERM', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('CHRON_TERM', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('CHRON_TERM', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('CHRON_TERM', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('CHRON_TERM', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('CHRON_TERM', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('CHRON_TERM', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('CHRON_TERM', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('CHRON_TERM', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('CHRON_TERM', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('CHRON_TERM', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('CHRON_TERM', '748', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--CHRONOLOGICAL TERM', 1, 0, NULL),
('CHRON_TERM', '782', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('CHRON_TERM', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('CHRON_TERM', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('CHRON_TERM', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- TOPICAL TERM AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('TOPIC_TERM', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('TOPIC_TERM', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('TOPIC_TERM', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('TOPIC_TERM', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('TOPIC_TERM', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('TOPIC_TERM', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('TOPIC_TERM', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('TOPIC_TERM', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('TOPIC_TERM', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('TOPIC_TERM', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('TOPIC_TERM', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('TOPIC_TERM', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('TOPIC_TERM', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('TOPIC_TERM', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('TOPIC_TERM', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('TOPIC_TERM', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('TOPIC_TERM', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('TOPIC_TERM', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('TOPIC_TERM', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('TOPIC_TERM', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('TOPIC_TERM', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('TOPIC_TERM', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('TOPIC_TERM', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('TOPIC_TERM', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
('TOPIC_TERM', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
('TOPIC_TERM', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('TOPIC_TERM', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('TOPIC_TERM', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('TOPIC_TERM', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('TOPIC_TERM', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('TOPIC_TERM', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('TOPIC_TERM', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('TOPIC_TERM', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('TOPIC_TERM', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('TOPIC_TERM', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('TOPIC_TERM', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('TOPIC_TERM', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('TOPIC_TERM', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('TOPIC_TERM', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('TOPIC_TERM', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('TOPIC_TERM', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('TOPIC_TERM', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('TOPIC_TERM', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('TOPIC_TERM', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('TOPIC_TERM', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('TOPIC_TERM', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('TOPIC_TERM', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('TOPIC_TERM', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('TOPIC_TERM', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('TOPIC_TERM', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('TOPIC_TERM', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('TOPIC_TERM', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('TOPIC_TERM', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('TOPIC_TERM', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('TOPIC_TERM', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('TOPIC_TERM', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('TOPIC_TERM', '750', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 1, 0, NULL),
('TOPIC_TERM', '780', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 1, 0, NULL),
('TOPIC_TERM', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('TOPIC_TERM', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('TOPIC_TERM', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- GEOGRAPHIC NAME AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('GEOGR_NAME', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('GEOGR_NAME', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('GEOGR_NAME', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('GEOGR_NAME', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('GEOGR_NAME', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('GEOGR_NAME', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('GEOGR_NAME', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('GEOGR_NAME', '034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL),
('GEOGR_NAME', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('GEOGR_NAME', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('GEOGR_NAME', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('GEOGR_NAME', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('GEOGR_NAME', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('GEOGR_NAME', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('GEOGR_NAME', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('GEOGR_NAME', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('GEOGR_NAME', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('GEOGR_NAME', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('GEOGR_NAME', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('GEOGR_NAME', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('GEOGR_NAME', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('GEOGR_NAME', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('GEOGR_NAME', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('GEOGR_NAME', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
('GEOGR_NAME', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
('GEOGR_NAME', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('GEOGR_NAME', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('GEOGR_NAME', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('GEOGR_NAME', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('GEOGR_NAME', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('GEOGR_NAME', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('GEOGR_NAME', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('GEOGR_NAME', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('GEOGR_NAME', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('GEOGR_NAME', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('GEOGR_NAME', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('GEOGR_NAME', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('GEOGR_NAME', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('GEOGR_NAME', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('GEOGR_NAME', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('GEOGR_NAME', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('GEOGR_NAME', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('GEOGR_NAME', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('GEOGR_NAME', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('GEOGR_NAME', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('GEOGR_NAME', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('GEOGR_NAME', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('GEOGR_NAME', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('GEOGR_NAME', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('GEOGR_NAME', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('GEOGR_NAME', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('GEOGR_NAME', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('GEOGR_NAME', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('GEOGR_NAME', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('GEOGR_NAME', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('GEOGR_NAME', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('GEOGR_NAME', '751', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 'ESTABLISHED HEADING LINKING ENTRY--GEOGRAPHIC NAME', 1, 0, NULL),
('GEOGR_NAME', '781', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('GEOGR_NAME', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('GEOGR_NAME', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('GEOGR_NAME', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





-- ******************************************************



-- *******************************************************************
-- GENRE/FORM TERM AUTHORITY FIELDS/SUBFIELDS.
-- *******************************************************************

-- These ought to be adjusted for different less conflicting and more
-- rationally chosen fields and subfields but I had left that for last.

-- ADJUST ME
-- Use values from your dump of auth_tag_structure and auth_subfield_structure
-- to provide support for your Koha database.


INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
('GENRE/FORM', '000', 'LEADER', 'LEADER', 0, 1, NULL),
('GENRE/FORM', '001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 1, NULL),
('GENRE/FORM', '003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, NULL),
('GENRE/FORM', '005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, NULL),
('GENRE/FORM', '008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, NULL),
('GENRE/FORM', '010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, NULL),
('GENRE/FORM', '016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL),
('GENRE/FORM', '024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL),
('GENRE/FORM', '035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL),
('GENRE/FORM', '040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL),
('GENRE/FORM', '042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL),
('GENRE/FORM', '043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL),
('GENRE/FORM', '045', 'TIME PERIOD OF HEADING', 'TIME PERIOD OF HEADING', 0, 0, NULL),
('GENRE/FORM', '050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '052', 'GEOGRAPHIC CLASSIFICATION', 'GEOGRAPHIC CLASSIFICATION', 1, 0, NULL),
('GENRE/FORM', '053', 'LC CLASSIFICATION NUMBER', 'LC CLASSIFICATION NUMBER', 1, 0, NULL),
('GENRE/FORM', '055', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 'NATIONAL LIBRARY AND ARCHIVE OF CANADA CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '065', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL),
('GENRE/FORM', '066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL),
('GENRE/FORM', '070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL),
('GENRE/FORM', '073', 'SUBDIVISION USAGE', 'SUBDIVISION USAGE', 0, 0, NULL),
('GENRE/FORM', '082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '083', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL),
('GENRE/FORM', '086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL),
('GENRE/FORM', '087', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL),
('GENRE/FORM', '090', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCAL CALL NUMBER (SERIES) [OBSOLETE]; LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '091', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CLASSIFICATION NUMBER (OCLC); LOCAL CLASSIFICATION NUMBER (RLIN)', 0, 0, NULL),
('GENRE/FORM', '092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '093', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
('GENRE/FORM', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
('GENRE/FORM', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
('GENRE/FORM', '185', 'HEADING--FORM SUBDIVISION', 'HEADING--FORM SUBDIVISION', 0, 0, NULL),
('GENRE/FORM', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
('GENRE/FORM', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
('GENRE/FORM', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('GENRE/FORM', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('GENRE/FORM', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
('GENRE/FORM', '430', 'SEE FROM TRACING--UNIFORM TITLE', 'SEE FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('GENRE/FORM', '448', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 'SEE FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('GENRE/FORM', '450', 'SEE FROM TRACING--TOPICAL TERM', 'SEE FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('GENRE/FORM', '451', 'SEE FROM TRACING--GEOGRAPHIC NAME', 'SEE FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('GENRE/FORM', '455', 'SEE FROM TRACING--GENRE/FORM TERM', 'SEE FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('GENRE/FORM', '480', 'SEE FROM TRACING--GENERAL SUBDIVISION', 'SEE FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '481', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '482', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '485', 'SEE FROM TRACING--FORM SUBDIVISION', 'SEE FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '500', 'SEE ALSO FROM TRACING--PERSONAL NAME', 'SEE ALSO FROM TRACING--PERSONAL NAME', 1, 0, NULL),
('GENRE/FORM', '510', 'SEE ALSO FROM TRACING--CORPORATE NAME', 'SEE ALSO FROM TRACING--CORPORATE NAME', 1, 0, NULL),
('GENRE/FORM', '511', 'SEE ALSO FROM TRACING--MEETING NAME', 'SEE ALSO FROM TRACING--MEETING NAME', 1, 0, NULL),
('GENRE/FORM', '530', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 'SEE ALSO FROM TRACING--UNIFORM TITLE', 1, 0, NULL),
('GENRE/FORM', '548', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 'SEE ALSO FROM TRACING--CHRONOLOGICAL TERM', 1, 0, NULL),
('GENRE/FORM', '550', 'SEE ALSO FROM TRACING--TOPICAL TERM', 'SEE ALSO FROM TRACING--TOPICAL TERM', 1, 0, NULL),
('GENRE/FORM', '551', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 'SEE ALSO FROM TRACING--GEOGRAPHIC NAME', 1, 0, NULL),
('GENRE/FORM', '555', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 'SEE ALSO FROM TRACING--GENRE/FORM TERM', 1, 0, NULL),
('GENRE/FORM', '580', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 'SEE ALSO FROM TRACING--GENERAL SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '581', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 'SEE ALSO FROM TRACING--GEOGRAPHIC SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '582', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 'SEE ALSO FROM TRACING--CHRONOLOGICAL SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '585', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 'SEE ALSO FROM TRACING--FORM SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '663', 'COMPLEX SEE ALSO REFERENCE--NAME', 'COMPLEX SEE ALSO REFERENCE--NAME', 0, 0, NULL),
('GENRE/FORM', '664', 'COMPLEX SEE REFERENCE--NAME', 'COMPLEX SEE REFERENCE--NAME', 0, 0, NULL),
('GENRE/FORM', '665', 'HISTORY REFERENCE', 'HISTORY REFERENCE', 0, 0, NULL),
('GENRE/FORM', '666', 'GENERAL EXPLANATORY REFERENCE--NAME', 'GENERAL EXPLANATORY REFERENCE--NAME', 0, 0, NULL),
('GENRE/FORM', '667', 'NONPUBLIC GENERAL NOTE', 'NONPUBLIC GENERAL NOTE', 1, 0, NULL),
('GENRE/FORM', '670', 'SOURCE DATA FOUND', 'SOURCE DATA FOUND', 1, 0, NULL),
('GENRE/FORM', '675', 'SOURCE DATA NOT FOUND', 'SOURCE DATA NOT FOUND', 0, 0, NULL),
('GENRE/FORM', '678', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL),
('GENRE/FORM', '680', 'PUBLIC GENERAL NOTE', 'PUBLIC GENERAL NOTE', 1, 0, NULL),
('GENRE/FORM', '681', 'SUBJECT EXAMPLE TRACING NOTE', 'SUBJECT EXAMPLE TRACING NOTE', 1, 0, NULL),
('GENRE/FORM', '682', 'DELETED HEADING INFORMATION', 'DELETED HEADING INFORMATION', 0, 0, NULL),
('GENRE/FORM', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('GENRE/FORM', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
('GENRE/FORM', '750', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 'ESTABLISHED HEADING LINKING ENTRY--TOPICAL TERM', 1, 0, NULL),
('GENRE/FORM', '755', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 'ESTABLISHED HEADING LINKING ENTRY--GENRE/FORM TERM', 1, 0, NULL),
('GENRE/FORM', '780', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 'SUBDIVISION LINKING ENTRY--GENERAL SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '785', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 'SUBDIVISION LINKING ENTRY--FORM SUBDIVISION', 1, 0, NULL),
('GENRE/FORM', '788', 'COMPLEX LINKING ENTRY DATA', 'COMPLEX LINKING ENTRY DATA', 0, 0, NULL),
('GENRE/FORM', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
('GENRE/FORM', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);





