[Koha-cvs] koha/misc marc21_simple_bib_frameworks.sql marc... [rel_2_2]
Thomas D
koha at alinto.com
Tue Aug 21 01:24:42 CEST 2007
CVSROOT: /sources/koha
Module name: koha
Branch: rel_2_2
Changes by: Thomas D <thd> 07/08/20 23:24:39
Modified files:
misc : marc21_simple_bib_frameworks.sql
marc21_standard_auth_frameworks.sql
marc21_standard_bib_framework.sql
misc/sql-datas/english: authorities_normal_marc21.sql
Log message:
Corrected internal versioning and treatment of authority types.
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/marc21_simple_bib_frameworks.sql?cvsroot=koha&only_with_tag=rel_2_2&r1=1.1.2.5&r2=1.1.2.6
http://cvs.savannah.gnu.org/viewcvs/koha/misc/marc21_standard_auth_frameworks.sql?cvsroot=koha&only_with_tag=rel_2_2&r1=1.1.2.2&r2=1.1.2.3
http://cvs.savannah.gnu.org/viewcvs/koha/misc/marc21_standard_bib_framework.sql?cvsroot=koha&only_with_tag=rel_2_2&r1=1.1.2.11&r2=1.1.2.12
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/english/authorities_normal_marc21.sql?cvsroot=koha&only_with_tag=rel_2_2&r1=1.2.2.2&r2=1.2.2.3
Patches:
Index: marc21_simple_bib_frameworks.sql
===================================================================
RCS file: /sources/koha/koha/misc/marc21_simple_bib_frameworks.sql,v
retrieving revision 1.1.2.5
retrieving revision 1.1.2.6
diff -u -b -r1.1.2.5 -r1.1.2.6
--- marc21_simple_bib_frameworks.sql 17 Aug 2007 17:38:07 -0000 1.1.2.5
+++ marc21_simple_bib_frameworks.sql 20 Aug 2007 23:24:32 -0000 1.1.2.6
@@ -2,8 +2,8 @@
-- SIMPLE KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORKS
-- POST-INSTALLATION SCRIPT
--
--- PRETEST VERSION 0.1.6
--- 2007-08-17
+-- PRETEST VERSION 0.1.7
+-- 2007-08-20
--
-- drafted
-- by thd for LibLime
@@ -16,6 +16,16 @@
-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
-- POST-INSTALLATION SCRIPT
--
+-- PRETEST VERSION 0.2.4
+-- 2007-08-20
+--
+-- edited
+-- by thd for LibLime
+--
+-- BASED UPON
+--
+-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
+--
-- PRETEST VERSION 0.2.3
-- 2007-08-17
--
Index: marc21_standard_auth_frameworks.sql
===================================================================
RCS file: /sources/koha/koha/misc/marc21_standard_auth_frameworks.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -b -r1.1.2.2 -r1.1.2.3
--- marc21_standard_auth_frameworks.sql 17 Aug 2007 08:51:48 -0000 1.1.2.2
+++ marc21_standard_auth_frameworks.sql 20 Aug 2007 23:24:36 -0000 1.1.2.3
@@ -2,8 +2,18 @@
-- KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
-- POST-INSTALLATION SCRIPT
--
--- PRETEST VERSION 0.0.2
--- 2007-08-17
+-- PRETEST VERSION 0.0.3
+-- 2007-08-20
+--
+-- edited
+-- by thd for LibLime
+--
+-- BASED UPON
+--
+-- KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
+--
+-- PRETEST VERSION 0.0.3
+-- 2007-08-20
--
-- original default requiring greater user customisation
-- created by a few Koha Hands
@@ -141,6 +151,11 @@
--
+
+-- ******************************************************
+
+
+
DROP TABLE IF EXISTS `auth_types`;
CREATE TABLE IF NOT EXISTS `auth_types` (
`authtypecode` varchar(10) NOT NULL default '',
@@ -158,6 +173,29 @@
;
+
+-- ******************************************************
+
+
+
+-- ******************************************************
+-- KOHA DEFAULT MARC 21 AUTHORITY TYPE.
+-- ******************************************************
+
+-- This authority type includes all fields and subfieds used by any
+-- authority type.
+
+INSERT INTO `auth_types` 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` VALUES ('PERS0_NAME', 'Personal Name', '100', 'Personal Names');
INSERT INTO `auth_types` VALUES ('CORP0_NAME', 'Corporate Name', '110', 'Corporate Names');
INSERT INTO `auth_types` VALUES ('MEETI_NAME', 'Meeting Name', '111', 'Meeting Name');
@@ -166,12 +204,34 @@
INSERT INTO `auth_types` VALUES ('TOPIC_TERM', 'Topical Term', '150', 'Topical Term');
INSERT INTO `auth_types` VALUES ('GEOGR_NAME', 'Geographic Name', '151', 'Geographic Name');
INSERT INTO `auth_types` VALUES ('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` VALUES ('TOPIC_SUBD', 'General Topical Term Subdivision', '180', 'General Topical Term Subdivision');
-- INSERT INTO `auth_types` VALUES ('GEOGR_SUBD', 'Geographic Subdivision', '181', 'Geographic Subdivision');
-- INSERT INTO `auth_types` VALUES ('CHRON_SUBD', 'Chronological Subdivision', '182', 'Chronological Subdivision');
-- INSERT INTO `auth_types` VALUES ('FORM_SUBDI', 'Form Subdivision', '185', 'Form Subdivision');
+
+-- ******************************************************
+
+
+
DROP TABLE IF EXISTS `auth_tag_structure`;
CREATE TABLE IF NOT EXISTS `auth_tag_structure` (
`authtypecode` char(10) NOT NULL default '',
@@ -400,6 +460,7 @@
INSERT INTO `auth_tag_structure` VALUES ('', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL);
+
INSERT INTO `auth_subfield_structure` VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL);
INSERT INTO `auth_subfield_structure` VALUES ('', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL);
INSERT INTO `auth_subfield_structure` VALUES ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL);
Index: marc21_standard_bib_framework.sql
===================================================================
RCS file: /sources/koha/koha/misc/marc21_standard_bib_framework.sql,v
retrieving revision 1.1.2.11
retrieving revision 1.1.2.12
diff -u -b -r1.1.2.11 -r1.1.2.12
--- marc21_standard_bib_framework.sql 17 Aug 2007 17:38:11 -0000 1.1.2.11
+++ marc21_standard_bib_framework.sql 20 Aug 2007 23:24:37 -0000 1.1.2.12
@@ -2,6 +2,16 @@
-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
-- POST-INSTALLATION SCRIPT
--
+-- PRETEST VERSION 0.2.4
+-- 2007-08-20
+--
+-- edited
+-- by thd for LibLime
+--
+-- BASED UPON
+--
+-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
+--
-- PRETEST VERSION 0.2.3
-- 2007-08-17
--
Index: sql-datas/english/authorities_normal_marc21.sql
===================================================================
RCS file: /sources/koha/koha/misc/sql-datas/english/Attic/authorities_normal_marc21.sql,v
retrieving revision 1.2.2.2
retrieving revision 1.2.2.3
diff -u -b -r1.2.2.2 -r1.2.2.3
--- sql-datas/english/authorities_normal_marc21.sql 17 Aug 2007 08:51:49 -0000 1.2.2.2
+++ sql-datas/english/authorities_normal_marc21.sql 20 Aug 2007 23:24:38 -0000 1.2.2.3
@@ -1,8 +1,8 @@
-- *******************************************************
-- KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
--
--- PRETEST VERSION 0.0.2
--- 2007-08-17
+-- PRETEST VERSION 0.0.3
+-- 2007-08-20
--
-- original default requiring greater user customisation
-- created by a few Koha Hands
@@ -16,6 +16,60 @@
+-- ******************************************************
+-- KOHA DEFAULT MARC 21 AUTHORITY TYPE.
+-- ******************************************************
+
+-- This authority type includes all fields and subfieds used by any
+-- authority type.
+
+INSERT INTO `auth_types` 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` VALUES ('PERS0_NAME', 'Personal Name', '100', 'Personal Names');
+INSERT INTO `auth_types` VALUES ('CORP0_NAME', 'Corporate Name', '110', 'Corporate Names');
+INSERT INTO `auth_types` VALUES ('MEETI_NAME', 'Meeting Name', '111', 'Meeting Name');
+INSERT INTO `auth_types` VALUES ('UNIF_TITLE', 'Uniform Title', '130', 'Uniform Title');
+INSERT INTO `auth_types` VALUES ('CHRON_TERM', 'Chronological Term', '148', 'Chronological Term');
+INSERT INTO `auth_types` VALUES ('TOPIC_TERM', 'Topical Term', '150', 'Topical Term');
+INSERT INTO `auth_types` VALUES ('GEOGR_NAME', 'Geographic Name', '151', 'Geographic Name');
+INSERT INTO `auth_types` VALUES ('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` VALUES ('TOPIC_SUBD', 'General Topical Term Subdivision', '180', 'General Topical Term Subdivision');
+-- INSERT INTO `auth_types` VALUES ('GEOGR_SUBD', 'Geographic Subdivision', '181', 'Geographic Subdivision');
+-- INSERT INTO `auth_types` VALUES ('CHRON_SUBD', 'Chronological Subdivision', '182', 'Chronological Subdivision');
+-- INSERT INTO `auth_types` VALUES ('FORM_SUBDI', 'Form Subdivision', '185', 'Form Subdivision');
+
+
+
+-- ******************************************************
+
+
+
-- *****************************************************************
-- MARC 21 AUTHORITY FIELDS/SUBFIELDS AND COMMMONLY USED EXTENSIONS
-- *****************************************************************
More information about the Koha-cvs
mailing list