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

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (+22 lines)
Lines 500-502 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
500
500
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
503
504
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
505
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
506
FROM marc_tag_structure
507
WHERE frameworkcode="" AND tagfield IN (
508
    SELECT tagfield
509
    FROM marc_subfield_structure
510
    WHERE (
511
            kohafield="biblio.title"
512
        OR  kohafield="biblio.author"
513
        OR  kohafield="biblioitems.publishercode"
514
        OR  kohafield="biblioitems.editionstatement"
515
        OR  kohafield="biblio.copyrightdate"
516
        OR  kohafield="biblioitems.isbn"
517
        OR  kohafield="biblio.seriestitle"
518
    ) AND frameworkcode=""
519
);
520
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
521
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
522
FROM marc_subfield_structure
523
WHERE frameworkcode=""
524
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (+22 lines)
Lines 500-502 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
500
500
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
503
504
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
505
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
506
FROM marc_tag_structure
507
WHERE frameworkcode="" AND tagfield IN (
508
    SELECT tagfield
509
    FROM marc_subfield_structure
510
    WHERE (
511
            kohafield="biblio.title"
512
        OR  kohafield="biblio.author"
513
        OR  kohafield="biblioitems.publishercode"
514
        OR  kohafield="biblioitems.editionstatement"
515
        OR  kohafield="biblio.copyrightdate"
516
        OR  kohafield="biblioitems.isbn"
517
        OR  kohafield="biblio.seriestitle"
518
    ) AND frameworkcode=""
519
);
520
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
521
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
522
FROM marc_subfield_structure
523
WHERE frameworkcode=""
524
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql (+22 lines)
Lines 11-16 SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, koha Link Here
11
FROM marc_subfield_structure
11
FROM marc_subfield_structure
12
WHERE frameworkcode = '';
12
WHERE frameworkcode = '';
13
13
14
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
15
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
16
FROM marc_tag_structure
17
WHERE frameworkcode="" AND tagfield IN (
18
    SELECT tagfield
19
    FROM marc_subfield_structure
20
    WHERE (
21
            kohafield="biblio.title"
22
        OR  kohafield="biblio.author"
23
        OR  kohafield="biblioitems.publishercode"
24
        OR  kohafield="biblioitems.editionstatement"
25
        OR  kohafield="biblio.copyrightdate"
26
        OR  kohafield="biblioitems.isbn"
27
        OR  kohafield="biblio.seriestitle"
28
    ) AND frameworkcode=""
29
);
30
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
32
FROM marc_subfield_structure
33
WHERE frameworkcode=""
34
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
35
14
-- **************************************
36
-- **************************************
15
-- IGNORE CERTAINES SOUS-ZONES EXEMPLAIRE
37
-- IGNORE CERTAINES SOUS-ZONES EXEMPLAIRE
16
-- **************************************
38
-- **************************************
(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql (+22 lines)
Lines 31494-31496 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
31494
31494
31495
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31495
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31496
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
31496
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
31497
31498
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
31499
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
31500
FROM marc_tag_structure
31501
WHERE frameworkcode="" AND tagfield IN (
31502
    SELECT tagfield
31503
    FROM marc_subfield_structure
31504
    WHERE (
31505
            kohafield="biblio.title"
31506
        OR  kohafield="biblio.author"
31507
        OR  kohafield="biblioitems.publishercode"
31508
        OR  kohafield="biblioitems.editionstatement"
31509
        OR  kohafield="biblio.copyrightdate"
31510
        OR  kohafield="biblioitems.isbn"
31511
        OR  kohafield="biblio.seriestitle"
31512
    ) AND frameworkcode=""
31513
);
31514
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31515
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
31516
FROM marc_subfield_structure
31517
WHERE frameworkcode=""
31518
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (+22 lines)
Lines 7894-7896 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
7894
7894
7895
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
7895
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
7896
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
7896
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
7897
7898
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
7899
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
7900
FROM marc_tag_structure
7901
WHERE frameworkcode="" AND tagfield IN (
7902
    SELECT tagfield
7903
    FROM marc_subfield_structure
7904
    WHERE (
7905
            kohafield="biblio.title"
7906
        OR  kohafield="biblio.author"
7907
        OR  kohafield="biblioitems.publishercode"
7908
        OR  kohafield="biblioitems.editionstatement"
7909
        OR  kohafield="biblioitems.publicationyear"
7910
        OR  kohafield="biblioitems.isbn"
7911
        OR  kohafield="biblio.seriestitle"
7912
    ) AND frameworkcode=""
7913
);
7914
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
7915
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
7916
FROM marc_subfield_structure
7917
WHERE frameworkcode=""
7918
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (+22 lines)
Lines 500-502 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
500
500
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
501
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
502
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
503
504
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
505
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
506
FROM marc_tag_structure
507
WHERE frameworkcode="" AND tagfield IN (
508
    SELECT tagfield
509
    FROM marc_subfield_structure
510
    WHERE (
511
            kohafield="biblio.title"
512
        OR  kohafield="biblio.author"
513
        OR  kohafield="biblioitems.publishercode"
514
        OR  kohafield="biblioitems.editionstatement"
515
        OR  kohafield="biblio.copyrightdate"
516
        OR  kohafield="biblioitems.isbn"
517
        OR  kohafield="biblio.seriestitle"
518
    ) AND frameworkcode=""
519
);
520
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
521
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
522
FROM marc_subfield_structure
523
WHERE frameworkcode=""
524
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (+22 lines)
Lines 31486-31488 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
31486
31486
31487
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31487
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31488
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
31488
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
31489
31490
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
31491
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
31492
FROM marc_tag_structure
31493
WHERE frameworkcode="" AND tagfield IN (
31494
    SELECT tagfield
31495
    FROM marc_subfield_structure
31496
    WHERE (
31497
            kohafield="biblio.title"
31498
        OR  kohafield="biblio.author"
31499
        OR  kohafield="biblioitems.publishercode"
31500
        OR  kohafield="biblioitems.editionstatement"
31501
        OR  kohafield="biblio.copyrightdate"
31502
        OR  kohafield="biblioitems.isbn"
31503
        OR  kohafield="biblio.seriestitle"
31504
    ) AND frameworkcode=""
31505
);
31506
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
31507
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
31508
FROM marc_subfield_structure
31509
WHERE frameworkcode=""
31510
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (+22 lines)
Lines 4006-4008 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
4006
4006
4007
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4007
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4008
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
4008
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
4009
4010
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
4011
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
4012
FROM marc_tag_structure
4013
WHERE frameworkcode="" AND tagfield IN (
4014
    SELECT tagfield
4015
    FROM marc_subfield_structure
4016
    WHERE (
4017
            kohafield="biblio.title"
4018
        OR  kohafield="biblio.author"
4019
        OR  kohafield="biblioitems.publishercode"
4020
        OR  kohafield="biblioitems.editionstatement"
4021
        OR  kohafield="biblio.copyrightdate"
4022
        OR  kohafield="biblioitems.isbn"
4023
        OR  kohafield="biblio.seriestitle"
4024
    ) AND frameworkcode=""
4025
);
4026
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4027
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
4028
FROM marc_subfield_structure
4029
WHERE frameworkcode=""
4030
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql (+22 lines)
Lines 2218-2220 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
2218
2218
2219
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2219
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2220
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
2220
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
2221
2222
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
2223
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
2224
FROM marc_tag_structure
2225
WHERE frameworkcode="" AND tagfield IN (
2226
    SELECT tagfield
2227
    FROM marc_subfield_structure
2228
    WHERE (
2229
            kohafield="biblio.title"
2230
        OR  kohafield="biblio.author"
2231
        OR  kohafield="biblioitems.publishercode"
2232
        OR  kohafield="biblioitems.editionstatement"
2233
        OR  kohafield="biblioitems.publicationyear"
2234
        OR  kohafield="biblioitems.isbn"
2235
        OR  kohafield="biblio.seriestitle"
2236
    ) AND frameworkcode=""
2237
);
2238
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2239
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
2240
FROM marc_subfield_structure
2241
WHERE frameworkcode=""
2242
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql (+22 lines)
Lines 4228-4230 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
4228
4228
4229
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4229
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4230
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
4230
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode='';
4231
4232
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
4233
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
4234
FROM marc_tag_structure
4235
WHERE frameworkcode="" AND tagfield IN (
4236
    SELECT tagfield
4237
    FROM marc_subfield_structure
4238
    WHERE (
4239
            kohafield="biblio.title"
4240
        OR  kohafield="biblio.author"
4241
        OR  kohafield="biblioitems.publishercode"
4242
        OR  kohafield="biblioitems.editionstatement"
4243
        OR  kohafield="biblio.copyrightdate"
4244
        OR  kohafield="biblioitems.isbn"
4245
        OR  kohafield="biblio.seriestitle"
4246
    ) AND frameworkcode=""
4247
);
4248
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
4249
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
4250
FROM marc_subfield_structure
4251
WHERE frameworkcode=""
4252
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
(-)a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql (-1 / +22 lines)
Lines 2221-2224 SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, Link Here
2221
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2221
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2222
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
2222
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode='';
2223
2223
2224
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
2225
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ'
2226
FROM marc_tag_structure
2227
WHERE frameworkcode="" AND tagfield IN (
2228
    SELECT tagfield
2229
    FROM marc_subfield_structure
2230
    WHERE (
2231
            kohafield="biblio.title"
2232
        OR  kohafield="biblio.author"
2233
        OR  kohafield="biblioitems.publishercode"
2234
        OR  kohafield="biblioitems.editionstatement"
2235
        OR  kohafield="biblioitems.publicationyear"
2236
        OR  kohafield="biblioitems.isbn"
2237
        OR  kohafield="biblio.seriestitle"
2238
    ) AND frameworkcode=""
2239
);
2240
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength)
2241
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
2242
FROM marc_subfield_structure
2243
WHERE frameworkcode=""
2244
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" );
2245
2224
SET FOREIGN_KEY_CHECKS=1;
2246
SET FOREIGN_KEY_CHECKS=1;
2225
- 

Return to bug 19289