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

(-)a/installer/data/mysql/en/mandatory/class_sources.sql (-3 / +3 lines)
Lines 1-4 Link Here
1
-- 
1
--
2
-- Default classification sources and filing rules
2
-- Default classification sources and filing rules
3
-- for Koha.
3
-- for Koha.
4
--
4
--
Lines 10-20 Link Here
10
-- terms of the GNU General Public License as published by the Free Software
10
-- terms of the GNU General Public License as published by the Free Software
11
-- Foundation; either version 2 of the License, or (at your option) any later
11
-- Foundation; either version 2 of the License, or (at your option) any later
12
-- version.
12
-- version.
13
-- 
13
--
14
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
16
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
17
-- 
17
--
18
-- You should have received a copy of the GNU General Public License along
18
-- You should have received a copy of the GNU General Public License along
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
(-)a/installer/data/mysql/en/optional/csv_profiles.sql (-1 / +1 lines)
Lines 1-2 Link Here
1
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type ) 
1
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type )
2
VALUES ( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql" );
2
VALUES ( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql" );
(-)a/installer/data/mysql/en/optional/csv_profiles.txt (-2 lines)
Lines 1-3 Link Here
1
CSV profiles
2
3
Default CSV export profiles; including one for exporting serial claims.
1
Default CSV export profiles; including one for exporting serial claims.
(-)a/installer/data/mysql/en/mandatory/message_transport_types.txt (-1 lines)
Lines 1-2 Link Here
1
Defines default message transports for email and sms.
1
Defines default message transports for email and sms.
2
(-)a/installer/data/mysql/en/default/patron_attributes.txt (+1 lines)
Line 0 Link Here
1
Patron attributes
(-)a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql (-1 lines)
Lines 6-9 values Link Here
6
(4, 'Hold_Filled', 0),
6
(4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
7
(5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
8
(6, 'Item_Checkout', 0);
9
(-)a/installer/data/mysql/en/marcflavour/marc21/default/authorities_normal_marc21.txt (+9 lines)
Line 0 Link Here
1
Default MARC21 Standard Authority types:
2
	Personal Name
3
	Corporate Name
4
	Meeting Name
5
	Uniform Title
6
	Chronological Term
7
	Topical Term
8
	Geographic Name
9
	Genre/Form Term
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-9 / +9 lines)
Lines 1-4 Link Here
1
-- 
1
--
2
-- Default MARC matching rules for Koha
2
-- Default MARC matching rules for Koha
3
--
3
--
4
-- Copyright (C) 2007 LiblimeA
4
-- Copyright (C) 2007 LiblimeA
Lines 9-39 Link Here
9
-- terms of the GNU General Public License as published by the Free Software
9
-- terms of the GNU General Public License as published by the Free Software
10
-- Foundation; either version 2 of the License, or (at your option) any later
10
-- Foundation; either version 2 of the License, or (at your option) any later
11
-- version.
11
-- version.
12
-- 
12
--
13
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
16
-- 
16
--
17
-- You should have received a copy of the GNU General Public License along
17
-- You should have received a copy of the GNU General Public License along
18
-- with Koha; if not, write to the Free Software Foundation, Inc.,
18
-- with Koha; if not, write to the Free Software Foundation, Inc.,
19
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
20
21
INSERT INTO marc_matchers (code, description, record_type, threshold) 
21
INSERT INTO marc_matchers (code, description, record_type, threshold)
22
    VALUES ('ISBN', '020$a', 'biblio', 1000);
22
    VALUES ('ISBN', '020$a', 'biblio', 1000);
23
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
23
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
24
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
24
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
25
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
25
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
26
    SELECT MAX(matchpoint_id), 1, '020', 'a' FROM matchpoints;
26
    SELECT MAX(matchpoint_id), 1, '020', 'a' FROM matchpoints;
27
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
27
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
28
    SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;
28
    SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_default_matching_rules.txt (-4 / +1 lines)
Lines 1-5 Link Here
1
Selected matching rules for MARC 21 bibliographic
1
Selected matching rules for MARC 21 bibliographic
2
records, including:
2
records, including: ISBN, ISSN
3
4
ISBN
5
ISSN
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt (-1 lines)
Lines 1-5 Link Here
1
Simple MARC 21 bibliographic frameworks for some common types of bibliographic material.  Frameworks are used to define the structure of your MARC records and the behavior of the integrated MARC editor. You can change these at any time after installation. The frameworks in this optional default setting include:
1
Simple MARC 21 bibliographic frameworks for some common types of bibliographic material.  Frameworks are used to define the structure of your MARC records and the behavior of the integrated MARC editor. You can change these at any time after installation. The frameworks in this optional default setting include:
2
3
BKS	Books, Booklets, Workbooks
2
BKS	Books, Booklets, Workbooks
4
CF	CD-ROMs, DVD-ROMs, General Online Resources
3
CF	CD-ROMs, DVD-ROMs, General Online Resources
5
SR	Audio Cassettes, CDs
4
SR	Audio Cassettes, CDs
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.txt (-11 lines)
Lines 1-11 Link Here
1
Default MARC21 Standard Authority types:
2
3
	Personal Name 
4
	Corporate Name 
5
	Meeting Name 
6
	Uniform Title 
7
	Chronological Term 
8
	Topical Term 
9
	Geographic Name 
10
	Genre/Form Term 
11
(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/authorities_normal_unimarc.sql (-2 lines)
Lines 819-823 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
819
		('', '886', '2', 'System Code', 'System Code', 0, 0, 8, '', '', '', 0, -5, 0, '', ''),
819
		('', '886', '2', 'System Code', 'System Code', 0, 0, 8, '', '', '', 0, -5, 0, '', ''),
820
		('', '886', 'a', 'Tag of the Source Format Field', 'Tag of the Source Format Field', 1, 0, 8, '', '', '', 0, -5, 0, '', ''),
820
		('', '886', 'a', 'Tag of the Source Format Field', 'Tag of the Source Format Field', 1, 0, 8, '', '', '', 0, -5, 0, '', ''),
821
		('', '886', 'b', 'Indicators and Subfields of the Source Format Field', 'Indicators and Subfields of the Source Format Field', 1, 0, 8, '', '', '', 0, -5, 0, '', '');
821
		('', '886', 'b', 'Indicators and Subfields of the Source Format Field', 'Indicators and Subfields of the Source Format Field', 1, 0, 8, '', '', '', 0, -5, 0, '', '');
822
823
(-)a/installer/data/mysql/en/marcflavour/unimarc/default/authorities_normal_unimarc.txt (+1 lines)
Line 0 Link Here
1
 Authority structure for UNIMARC in English.
(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (-5 / +5 lines)
Lines 23-29 Link Here
23
23
24
-- From Zeno Tajoli (2010-08-12):
24
-- From Zeno Tajoli (2010-08-12):
25
--
25
--
26
-- Improved default id Koha field (090) and koha date field (099). 
26
-- Improved default id Koha field (090) and koha date field (099).
27
-- Insert link to sql coloum biblio.biblionumber in tag 001
27
-- Insert link to sql coloum biblio.biblionumber in tag 001
28
-- Insert the use of 942, local data
28
-- Insert the use of 942, local data
29
-- Insert a standard minimun on 995 (holding field)
29
-- Insert a standard minimun on 995 (holding field)
Lines 72-78 Link Here
72
insert  into `marc_tag_structure`(`tagfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`authorised_value`,`frameworkcode`) values
72
insert  into `marc_tag_structure`(`tagfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`authorised_value`,`frameworkcode`) values
73
	('090','System Control Numbers (Koha)','System Control Numbers (Koha)',0,0,'','');
73
	('090','System Control Numbers (Koha)','System Control Numbers (Koha)',0,0,'','');
74
74
75
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 
75
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
76
	('090','a','Koha biblioitem number (autogenerated)','Koha biblioitem number (autogenerated)',0,0,'biblioitems.biblioitemnumber',9,'','','',0,-5,'',NULL,'','');
76
	('090','a','Koha biblioitem number (autogenerated)','Koha biblioitem number (autogenerated)',0,0,'biblioitems.biblioitemnumber',9,'','','',0,-5,'',NULL,'','');
77
77
78
-- Local date field/Subfields (099)
78
-- Local date field/Subfields (099)
Lines 80-88 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here
80
insert  into `marc_tag_structure`(`tagfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`authorised_value`,`frameworkcode`) values
80
insert  into `marc_tag_structure`(`tagfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`authorised_value`,`frameworkcode`) values
81
	('099','local dates','',0,0,'','');
81
	('099','local dates','',0,0,'','');
82
82
83
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 
83
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
84
	('099','c','Date of creation (bib. record)','Date of creation (bib. record)',0,0,'biblio.datecreated',0,'','','',0,-5,'',NULL,'','');
84
	('099','c','Date of creation (bib. record)','Date of creation (bib. record)',0,0,'biblio.datecreated',0,'','','',0,-5,'',NULL,'','');
85
 
85
86
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
86
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
87
	('099','d','Last modified date (bib. record)','Last modified data (bib. record)',0,0,'biblio.timestamp',0,'','','',0,-5,'',NULL,'','');
87
	('099','d','Last modified date (bib. record)','Last modified data (bib. record)',0,0,'biblio.timestamp',0,'','','',0,-5,'',NULL,'','');
88
88
Lines 151-157 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
151
		('995', 'r', 'Type of item and material', 'Type of item and material', 0, 1, 'items.itype', 10, 'itemtypes', '', '', 0, 0, '', '', '', NULL),
151
		('995', 'r', 'Type of item and material', 'Type of item and material', 0, 1, 'items.itype', 10, 'itemtypes', '', '', 0, 0, '', '', '', NULL),
152
		('995', 'u', 'Copy note', 'Copy note', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', '', '', NULL),
152
		('995', 'u', 'Copy note', 'Copy note', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', '', '', NULL),
153
		('995', 'v', 'Serial Enumeration / chronology', 'Serial Enumeration / chronology', 0, 0, 'items.enumchron', 10, '', '', '', 0, -1, '', '', '', NULL);
153
		('995', 'v', 'Serial Enumeration / chronology', 'Serial Enumeration / chronology', 0, 0, 'items.enumchron', 10, '', '', '', 0, -1, '', '', '', NULL);
154
 
154
155
155
156
156
157
-- *******************************************************
157
-- *******************************************************
(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/authorities_normal_unimarc.txt (-2 lines)
Line 1 Link Here
1
Authority structure for UNIMARC in English.
2
- 

Return to bug 18039