Bugzilla – Attachment 22134 Details for
Bug 10970
Update MARC21 frameworks to Update Nr. 17 - DB update
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update
Bug-10970---Update-MARC21-frameworks-to-Update-Nr-.patch (text/plain), 2.97 KB, created by
David Cook
on 2013-10-20 23:27:22 UTC
(
hide
)
Description:
Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update
Filename:
MIME Type:
Creator:
David Cook
Created:
2013-10-20 23:27:22 UTC
Size:
2.97 KB
patch
obsolete
>From 94a76ab16bac572ba25f38c3422c61626b265565 Mon Sep 17 00:00:00 2001 >From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Date: Sun, 29 Sep 2013 14:14:21 -0300 >Subject: [PATCH] Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB > update > >Database counterpart of Bug 10962. Updates existing MARC21 >default frameworks to Update Nr. 17 (September 2013) > >To test >1) Apply patch >2) run updatedatabase.pl >3) Verify new subtags > >biblio > 015_q 020_q 024_q 027_q 800_7 810_7 811_7 830_7 > >authorities > 020_q 024_q > >Signed-off-by: David Cook <dcook@prosentient.com.au> >--- > installer/data/mysql/updatedatabase.pl | 26 ++++++++++++++++++++++++++ > 1 file changed, 26 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 9f57eff..0ca275d 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -7306,6 +7306,32 @@ if ( CheckVersion($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "3.13.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(qq{ >+ INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, >+ kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, >+ defaultvalue) VALUES >+ ('015', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), >+ ('020', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), >+ ('024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), >+ ('027', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), >+ ('800', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), >+ ('810', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), >+ ('811', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), >+ ('830', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL); >+ }); >+ $dbh->do(qq{ >+ INSERT IGNORE INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, >+ mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode) VALUES >+ ('', '020', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), >+ ('', '024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''); >+ }); >+ print "Upgrade to $DBversion done (Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update)\n"; >+ SetVersion($DBversion); >+} >+ >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10970
:
21601
|
22134
|
23332