|
Lines 2821-2823
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
Link Here
|
| 2821 |
|
2821 |
|
| 2822 |
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000'; |
2822 |
UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000'; |
| 2823 |
UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008'; |
2823 |
UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008'; |
|
|
2824 |
|
| 2825 |
|
| 2826 |
-- Create the ACQ framework based on the default framework |
| 2827 |
-- Fields 952 |
| 2828 |
INSERT IGNORE INTO biblio_framework VALUES( 'ACQ', 'Grille d\'acquisitions' ); |
| 2829 |
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) |
| 2830 |
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='952' AND frameworkcode=''; |
| 2831 |
|
| 2832 |
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) |
| 2833 |
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=''; |
| 2834 |
|
| 2835 |
-- Some biblio-level fields |
| 2836 |
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) |
| 2837 |
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' |
| 2838 |
FROM marc_tag_structure |
| 2839 |
WHERE frameworkcode="" AND tagfield IN ( |
| 2840 |
SELECT tagfield |
| 2841 |
FROM marc_subfield_structure |
| 2842 |
WHERE ( |
| 2843 |
kohafield="biblio.title" |
| 2844 |
OR kohafield="biblio.author" |
| 2845 |
OR kohafield="biblioitems.publishercode" |
| 2846 |
OR kohafield="biblioitems.editionstatement" |
| 2847 |
OR kohafield="biblio.copyrightdate" |
| 2848 |
OR kohafield="biblioitems.isbn" |
| 2849 |
OR kohafield="biblio.seriestitle" |
| 2850 |
) AND frameworkcode="" |
| 2851 |
); |
| 2852 |
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) |
| 2853 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength |
| 2854 |
FROM marc_subfield_structure |
| 2855 |
WHERE frameworkcode="" |
| 2856 |
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); |
| 2857 |
|
| 2858 |
|
| 2859 |
-- ************************************** |
| 2860 |
-- IGNORE CERTAINES SOUS-ZONES EXEMPLAIRE |
| 2861 |
-- ************************************** |
| 2862 |
|
| 2863 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = '0' AND frameworkcode = 'ACQ'; |
| 2864 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'ACQ'; |
| 2865 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = '2' AND frameworkcode = 'ACQ'; |
| 2866 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = '4' AND frameworkcode = 'ACQ'; |
| 2867 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = '5' AND frameworkcode = 'ACQ'; |
| 2868 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'f' AND frameworkcode = 'ACQ'; |
| 2869 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'g' AND frameworkcode = 'ACQ'; |
| 2870 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'ACQ'; |
| 2871 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'ACQ'; |
| 2872 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'ACQ'; |
| 2873 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'ACQ'; |
| 2874 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'ACQ'; |
| 2875 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'ACQ'; |
| 2876 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'ACQ'; |
| 2877 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'u' AND frameworkcode = 'ACQ'; |
| 2878 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'v' AND frameworkcode = 'ACQ'; |
| 2879 |
UPDATE marc_subfield_structure SET tab = -1 WHERE tagfield = '952' AND tagsubfield = 'w' AND frameworkcode = 'ACQ'; |