Bugzilla – Attachment 110598 Details for
Bug 26513
Problematic DBRev order
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26513: Fix problematic DBRev order
Bug-26513-Fix-problematic-DBRev-order.patch (text/plain), 3.08 KB, created by
Tomás Cohen Arazi (tcohen)
on 2020-09-23 12:46:09 UTC
(
hide
)
Description:
Bug 26513: Fix problematic DBRev order
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2020-09-23 12:46:09 UTC
Size:
3.08 KB
patch
obsolete
>From bedac4babaf45274549af8c03798d1e2285c5f9b Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Wed, 23 Sep 2020 09:45:49 -0300 >Subject: [PATCH] Bug 26513: Fix problematic DBRev order > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > installer/data/mysql/updatedatabase.pl | 44 +++++++++++++------------- > 1 file changed, 22 insertions(+), 22 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 40e6a11a3f6..ee0bc9910e4 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -22703,28 +22703,6 @@ if( CheckVersion( $DBversion ) ) { > NewVersion( $DBversion, 22789, "Add non_priority column on reserves and old_reserves tables"); > } > >-$DBversion = '20.06.00.032'; >-if( CheckVersion( $DBversion ) ) { >- if( !column_exists( 'items', 'exclude_from_local_holds_priority' ) ) { >- $dbh->do(q{ >- ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status` >- }); >- } >- >- if( !column_exists( 'deleteditems', 'exclude_from_local_holds_priority' ) ) { >- $dbh->do(q{ >- ALTER TABLE `deleteditems` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status` >- }); >- } >- >- if( !column_exists( 'categories', 'exclude_from_local_holds_priority' ) ) { >- $dbh->do(q{ >- ALTER TABLE `categories` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `require_strong_password` >- }); >- } >- NewVersion( $DBversion, 19889, "Add exclude_from_local_holds_priority column to items, deleteditems and categories tables"); >-} >- > $DBversion = '20.06.00.033'; > if( CheckVersion( $DBversion ) ) { > if( column_exists( 'opac_news', 'timestamp' ) ) { >@@ -22807,6 +22785,28 @@ if( CheckVersion( $DBversion ) ) { > NewVersion( $DBversion, 18958, "Add reserve_id to hold_fill_targets"); > } > >+$DBversion = '20.06.00.040'; >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'items', 'exclude_from_local_holds_priority' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status` >+ }); >+ } >+ >+ if( !column_exists( 'deleteditems', 'exclude_from_local_holds_priority' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE `deleteditems` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status` >+ }); >+ } >+ >+ if( !column_exists( 'categories', 'exclude_from_local_holds_priority' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE `categories` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `require_strong_password` >+ }); >+ } >+ NewVersion( $DBversion, 19889, "Add exclude_from_local_holds_priority column to items, deleteditems and categories tables"); >+} >+ > # SEE bug 13068 > # if there is anything in the atomicupdate, read and execute it. > my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; >-- >2.28.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 26513
: 110598