Bugzilla – Attachment 90611 Details for
Bug 9834
Reverting a waiting hold should lead to the former hold type (item or biblio level)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9834: Add DB changes
Bug-9834-Add-DB-changes.patch (text/plain), 2.73 KB, created by
Nick Clemens (kidclamp)
on 2019-06-14 17:49:40 UTC
(
hide
)
Description:
Bug 9834: Add DB changes
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2019-06-14 17:49:40 UTC
Size:
2.73 KB
patch
obsolete
>From 749509163da3acebb01627f595c44c7cd0d53a51 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 6 Jun 2019 14:49:18 -0500 >Subject: [PATCH] Bug 9834: Add DB changes > >Signed-off-by: Liz Rea <wizzyrea@gmail.com> > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > installer/data/mysql/atomicupdate/bug_9834.perl | 12 ++++++++++++ > installer/data/mysql/kohastructure.sql | 2 ++ > 2 files changed, 14 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_9834.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_9834.perl b/installer/data/mysql/atomicupdate/bug_9834.perl >new file mode 100644 >index 0000000000..37189f562c >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_9834.perl >@@ -0,0 +1,12 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ unless ( column_exists( 'reserves', 'item_level_hold' ) ) { >+ $dbh->do( "ALTER TABLE reserves ADD COLUMN item_level_hold BOOLEAN NOT NULL DEFAULT 0 AFTER itemtype" ); >+ } >+ unless ( column_exists( 'old_reserves', 'item_level_hold' ) ) { >+ $dbh->do( "ALTER TABLE old_reserves ADD COLUMN item_level_hold BOOLEAN NOT NULL DEFAULT 0 AFTER itemtype" ); >+ } >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 9834 - Add the reserves.item_level_hold column)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index e171b32e19..e3d0930369 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1882,6 +1882,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha > `suspend` BOOLEAN NOT NULL DEFAULT 0, > `suspend_until` DATETIME NULL DEFAULT NULL, > `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting >+ `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level > PRIMARY KEY (`reserve_id`), > KEY priorityfoundidx (priority,found), > KEY `borrowernumber` (`borrowernumber`), >@@ -1921,6 +1922,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b > `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) > `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) > `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting >+ `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level > PRIMARY KEY (`reserve_id`), > KEY `old_reserves_borrowernumber` (`borrowernumber`), > KEY `old_reserves_biblionumber` (`biblionumber`), >-- >2.11.0
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 9834
:
90397
|
90398
|
90399
|
90436
|
90437
|
90438
| 90611 |
90612
|
90613
|
90677