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 |
-- ******************************************************* |