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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (-114 / +1 lines)
Lines 1-4103 Link Here
1
-- *************************************************************
1
-- *************************************************************
2
--       SIMPLE KOHA 3.0 MARC 21 BIBLIOGRAPHIC FRAMEWORKS
2
--       SIMPLE KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORKS
3
--
4
--                     PRETEST VERSION 0.1.7
5
--                          2007-11-05
6
--
7
--                            edited
8
--                            by thd
9
--
10
--                          BASED UPON
11
--
12
--       SIMPLE KOHA 3.0 MARC 21 BIBLIOGRAPHIC FRAMEWORKS
13
--                    POST-INSTALLATION SCRIPT
14
--
15
--                     PRETEST VERSION 0.1.7
16
--                          2007-11-05
17
--
18
--                            edited
19
--                            by thd
20
--
21
--                          BASED UPON
22
--
23
--  KOHA 3.0 MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
24
--
25
--                    PRETEST VERSION 0.1.7
26
--                          2007-11-05
27
--
28
--                            edited
29
--                            by thd
30
--
31
--                        AND BASED UPON
32
--
33
--          SIMPLE KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORKS
34
--                    POST-INSTALLATION SCRIPT
35
--
36
--                     PRETEST VERSION 0.1.11
37
--                          2007-11-05
38
--
39
--                           drafted
40
--                      by thd for LibLime
41
--
42
--            with a frameworks nomenclature correction
43
--                     by kados at LibLime
44
--
45
--                             WITH
46
--
47
--     KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
48
--                    POST-INSTALLATION SCRIPT
49
--
50
--                     PRETEST VERSION 0.2.8
51
--                          2007-11-05
52
--
53
--                            edited
54
--                      by thd for LibLime
55
--
56
--                          BASED UPON
57
--
58
--     KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
59
--
60
--                     PRETEST VERSION 0.2.8
61
--                          2007-11-05
62
--
63
--     original default requiring greater user customisation
64
--                  created by a few Koha Hands
65
--                    guided by Paul POULAIN
66
--
67
--          revised and greatly enlarged to completion,
68
--               well not quite complete yet today
69
--           but close enough for someone to have use,
70
--                      by thd for LibLime
71
-- *************************************************************
3
-- *************************************************************
72
4
73
74
75
76
77
-- ********************************
78
-- SIMPLE KOHA MARC 21 FRAMEWORKS.
79
-- ********************************
80
81
82
INSERT INTO `biblio_framework` (`frameworkcode`,`frameworktext`) VALUES
83
		('BKS', 'Books, Booklets, Workbooks'),
84
		('CF', 'CD-ROMs, DVD-ROMs, General Online Resources'),
85
		('SR', 'Audio Cassettes, CDs'),
86
		('VR', 'DVDs, VHS'),
87
		('AR', 'Models'),
88
		('KT', 'Kits'),
89
		('IR', 'Binders'),
90
		('SER', 'Serials');
91
92
93
-- ******************************************************
94
95
96
97
-- *******************************************************************
5
-- *******************************************************************
98
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
6
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
99
-- *******************************************************************
7
-- *******************************************************************
100
101
102
-- Current Record ID Field/Subfields
103
104
105
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
106
		('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'BKS');
107
108
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
109
		('999', 'a', 'Item type [OBSOLETE]', 'Item type [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, '', NULL, -5, 'BKS', '', '', NULL),
110
		('999', 'b', 'Koha Dewey Subclass [OBSOLETE]', 'Koha Dewey Subclass [OBSOLETE]', 0, 0, NULL, 0, NULL, NULL, '', NULL, -5, 'BKS', '', '', NULL),
111
		('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'BKS', '', '', NULL),
112
		('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'BKS', '', '', NULL);
113
114
115
-- ******************************************************
116
117
118
-- Plugins which need to be written for primary biblioitems Field/Subfields.
119
120

Return to bug 10963