Attachment #43983 for bug #14333

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

Lines 1-4 Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +2 lines)
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'




-- *******************************************************************
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- *******************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'BKS', 'Books, Booklets, Workbooks' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- ****************************************************************************
-- SIMPLE COMPUTER FILES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- ****************************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'CF', 'CD-ROMs, DVD-ROMs, General Online Resources' );
INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
	SELECT

-- *****************************************************************************
-- SIMPLE SOUND RECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- *****************************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'SR', 'Audio Cassettes, CDs' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- ****************************************************************************
-- SIMPLE VIDEORECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- ****************************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'VR', 'DVDs, VHS' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- **************************************************************************
-- SIMPLE 3D ARTIFACTS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- **************************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'AR', 'Models' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- ******************************************************************
-- SIMPLE KITS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- ******************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'KT', 'Kits' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- **********************************************************************************
-- SIMPLE INTEGRATING RESOURCES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- **********************************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'IR', 'Binders' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)

-- *********************************************************************
-- SIMPLE SERIALS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
-- *********************************************************************
INSERT IGNORE INTO biblio_framework VALUES 
		( 'SER', 'Serials' );

INSERT IGNORE INTO marc_tag_structure (
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
- 

Return to bug 14333

Lines 6-12 Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (-9 / +16 lines)
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	-