Bugzilla – Attachment 34947 Details for
Bug 13478
Force item holds only for specific biblios
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13478: Database revision for table biblio_force_item_holds
Bug-13478-Database-revision-for-table-biblioforcei.patch (text/plain), 2.24 KB, created by
Marcel de Rooy
on 2015-01-05 10:48:59 UTC
(
hide
)
Description:
Bug 13478: Database revision for table biblio_force_item_holds
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2015-01-05 10:48:59 UTC
Size:
2.24 KB
patch
obsolete
>From dbec302ef7d8d052fed2ca1d201079d5dd9d3e6f Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Thu, 18 Dec 2014 11:59:13 +0100 >Subject: [PATCH] Bug 13478: Database revision for table > biblio_force_item_holds >Content-Type: text/plain; charset=utf-8 > >TEST PLAN: >[1] Run the database revision. Check if the new table is present. >--- > installer/data/mysql/kohastructure.sql | 10 ++++++++++ > installer/data/mysql/updatedatabase.pl | 15 +++++++++++++++ > 2 files changed, 25 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 1f22106..3f1d1f6 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -132,6 +132,16 @@ CREATE TABLE `biblio` ( -- table that stores bibliographic information > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- >+-- Table structure for table `biblio_force_item_holds` >+-- >+ >+DROP TABLE IF EXISTS `biblio_force_item_holds`; >+CREATE TABLE `biblio_force_item_holds` ( -- biblios with forced item holds >+ `biblionumber` int NOT NULL, -- primary key >+ PRIMARY KEY (`biblionumber`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ >+-- > -- Table structure for table `biblio_framework` > -- > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index d2b03c3..0b39964 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -9656,6 +9656,21 @@ if(CheckVersion($DBversion)) { > SetVersion($DBversion); > } > >+ >+$DBversion = "3.19.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(qq| >+ CREATE TABLE biblio_force_item_holds >+ (biblionumber int NOT NULL PRIMARY KEY); >+ |); >+ $dbh->do(qq| >+ UPDATE systempreferences SET explanation = 'Allow OPAC users to place hold on specific items. If No, users can only request next available copy. If Yes, users can choose between next available and specific copy. If Force, users *must* choose a specific copy. Selectiveforce works on specific biblios.' >+ WHERE variable = 'OPACItemHolds'; >+ |); >+ print "Upgrade to $DBversion done (Update OPACItemHolds description)\n"; >+ SetVersion ($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.7.6
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 13478
:
34513
|
34947
|
34948
|
36193
|
36237
|
36238
|
36566
|
36567
|
36866
|
36867