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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +2 lines)
Lines 1-4 Link Here
1
INSERT IGNORE INTO biblio_framework VALUES ('FA', 'Fast Add Framework');
1
INSERT IGNORE INTO biblio_framework VALUES
2
		('FA', 'Fast Add Framework');
2
3
3
INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
4
INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
4
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
5
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (-9 / +16 lines)
Lines 6-12 Link Here
6
-- *******************************************************************
6
-- *******************************************************************
7
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
7
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
8
-- *******************************************************************
8
-- *******************************************************************
9
INSERT IGNORE INTO biblio_framework VALUES ( 'BKS', 'Books, Booklets, Workbooks' );
9
INSERT IGNORE INTO biblio_framework VALUES
10
		( 'BKS', 'Books, Booklets, Workbooks' );
10
11
11
INSERT IGNORE INTO marc_tag_structure (
12
INSERT IGNORE INTO marc_tag_structure (
12
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
13
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 28-34 INSERT IGNORE INTO marc_subfield_structure ( Link Here
28
-- ****************************************************************************
29
-- ****************************************************************************
29
-- SIMPLE COMPUTER FILES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
30
-- SIMPLE COMPUTER FILES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
30
-- ****************************************************************************
31
-- ****************************************************************************
31
INSERT IGNORE INTO biblio_framework VALUES ( 'CF', 'CD-ROMs, DVD-ROMs, General Online Resources' );
32
INSERT IGNORE INTO biblio_framework VALUES
33
		( 'CF', 'CD-ROMs, DVD-ROMs, General Online Resources' );
32
INSERT IGNORE INTO marc_tag_structure (
34
INSERT IGNORE INTO marc_tag_structure (
33
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
35
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
34
	SELECT
36
	SELECT
Lines 50-56 INSERT IGNORE INTO marc_subfield_structure ( Link Here
50
-- *****************************************************************************
52
-- *****************************************************************************
51
-- SIMPLE SOUND RECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
53
-- SIMPLE SOUND RECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
52
-- *****************************************************************************
54
-- *****************************************************************************
53
INSERT IGNORE INTO biblio_framework VALUES ( 'SR', 'Audio Cassettes, CDs' );
55
INSERT IGNORE INTO biblio_framework VALUES
56
		( 'SR', 'Audio Cassettes, CDs' );
54
57
55
INSERT IGNORE INTO marc_tag_structure (
58
INSERT IGNORE INTO marc_tag_structure (
56
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
59
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 73-79 INSERT IGNORE INTO marc_subfield_structure ( Link Here
73
-- ****************************************************************************
76
-- ****************************************************************************
74
-- SIMPLE VIDEORECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
77
-- SIMPLE VIDEORECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
75
-- ****************************************************************************
78
-- ****************************************************************************
76
INSERT IGNORE INTO biblio_framework VALUES ( 'VR', 'DVDs, VHS' );
79
INSERT IGNORE INTO biblio_framework VALUES
80
		( 'VR', 'DVDs, VHS' );
77
81
78
INSERT IGNORE INTO marc_tag_structure (
82
INSERT IGNORE INTO marc_tag_structure (
79
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
83
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 96-102 INSERT IGNORE INTO marc_subfield_structure ( Link Here
96
-- **************************************************************************
100
-- **************************************************************************
97
-- SIMPLE 3D ARTIFACTS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
101
-- SIMPLE 3D ARTIFACTS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
98
-- **************************************************************************
102
-- **************************************************************************
99
INSERT IGNORE INTO biblio_framework VALUES ( 'AR', 'Models' );
103
INSERT IGNORE INTO biblio_framework VALUES
104
		( 'AR', 'Models' );
100
105
101
INSERT IGNORE INTO marc_tag_structure (
106
INSERT IGNORE INTO marc_tag_structure (
102
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
107
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 119-125 INSERT IGNORE INTO marc_subfield_structure ( Link Here
119
-- ******************************************************************
124
-- ******************************************************************
120
-- SIMPLE KITS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
125
-- SIMPLE KITS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
121
-- ******************************************************************
126
-- ******************************************************************
122
INSERT IGNORE INTO biblio_framework VALUES ( 'KT', 'Kits' );
127
INSERT IGNORE INTO biblio_framework VALUES
128
		( 'KT', 'Kits' );
123
129
124
INSERT IGNORE INTO marc_tag_structure (
130
INSERT IGNORE INTO marc_tag_structure (
125
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
131
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 142-148 INSERT IGNORE INTO marc_subfield_structure ( Link Here
142
-- **********************************************************************************
148
-- **********************************************************************************
143
-- SIMPLE INTEGRATING RESOURCES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
149
-- SIMPLE INTEGRATING RESOURCES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
144
-- **********************************************************************************
150
-- **********************************************************************************
145
INSERT IGNORE INTO biblio_framework VALUES ( 'IR', 'Binders' );
151
INSERT IGNORE INTO biblio_framework VALUES
152
		( 'IR', 'Binders' );
146
153
147
INSERT IGNORE INTO marc_tag_structure (
154
INSERT IGNORE INTO marc_tag_structure (
148
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
155
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 165-171 INSERT IGNORE INTO marc_subfield_structure ( Link Here
165
-- *********************************************************************
172
-- *********************************************************************
166
-- SIMPLE SERIALS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
173
-- SIMPLE SERIALS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
167
-- *********************************************************************
174
-- *********************************************************************
168
INSERT IGNORE INTO biblio_framework VALUES ( 'SER', 'Serials' );
175
INSERT IGNORE INTO biblio_framework VALUES
176
		( 'SER', 'Serials' );
169
177
170
INSERT IGNORE INTO marc_tag_structure (
178
INSERT IGNORE INTO marc_tag_structure (
171
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
179
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
172
- 

Return to bug 14333