Attachment 110459 Details for Bug 25265 – Bug 19889: (follow-up) update DB adjustments

[patch] Bug 19889: (follow-up) update DB adjustments

Bug-19889-follow-up-update-DB-adjustments.patch (text/plain), 3.05 KB, created by Kyle M Hall (khall) on 2020-09-21 12:41:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-09-21 12:41:34 UTC

Size: 3.05 KB

patch

obsolete

>From 3803bbb275b7ff75054384e9d340eb6be2a0804d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 18 Sep 2020 11:38:57 +0200
>Subject: [PATCH] Bug 19889: (follow-up) update DB adjustments
>
>Fix fields order
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>
>https://bugs.koha-community.org/show_bug.cgi?id=25265
>---
> Koha/Schema/Result/Category.pm         | 18 +++++++++---------
> installer/data/mysql/updatedatabase.pl |  2 +-
> 2 files changed, 10 insertions(+), 10 deletions(-)
>
>diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm
>index 363329d265..0fdac2cc7c 100644
>--- a/Koha/Schema/Result/Category.pm
>+++ b/Koha/Schema/Result/Category.pm
>@@ -133,11 +133,6 @@ __PACKAGE__->table("categories");
>   data_type: 'tinyint'
>   is_nullable: 1
> 
>-=head2 exclude_from_local_holds_priority
>-
>-  data_type: 'tinyint'
>-  is_nullable: 1
>-
> =head2 min_password_length
> 
>   data_type: 'smallint'
>@@ -148,6 +143,11 @@ __PACKAGE__->table("categories");
>   data_type: 'tinyint'
>   is_nullable: 1
> 
>+=head2 exclude_from_local_holds_priority
>+
>+  data_type: 'tinyint'
>+  is_nullable: 1
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -204,12 +204,12 @@ __PACKAGE__->add_columns(
>   { data_type => "tinyint", is_nullable => 1 },
>   "change_password",
>   { data_type => "tinyint", is_nullable => 1 },
>-  "exclude_from_local_holds_priority",
>-  { data_type => "tinyint", is_nullable => 1 },
>   "min_password_length",
>   { data_type => "smallint", is_nullable => 1 },
>   "require_strong_password",
>   { data_type => "tinyint", is_nullable => 1 },
>+  "exclude_from_local_holds_priority",
>+  { data_type => "tinyint", is_nullable => 1 },
> );
> 
> =head1 PRIMARY KEY
>@@ -302,8 +302,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-02 12:50:50
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JOzFLxLwouaTl5dQJrOdZA
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-18 09:33:32
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ab4IZUfNu63C/SWLPXlMNg
> 
> __PACKAGE__->add_columns(
>     '+exclude_from_local_holds_priority' => { is_boolean => 1 },
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index f61b7c5976..40e6a11a3f 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -22719,7 +22719,7 @@ if( CheckVersion( $DBversion ) ) {
> 
>     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 `change_password`
>+            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");
>-- 
>2.24.1 (Apple Git-126)

Actions: View | Diff | Splinter Review

Attachments on bug 25265: 107832 | 107855 | 107867 | 109538 | 109556 | 110262 | 110263 | 110264 | 110380 | 110381 | 110382 | 110457 | 110458 | 110459 | 110560 | 110561 | 110562 | 110565 | 110594 | 110595 | 110596 | 110597 | 110615 | 110618 | 110729 | 110730 | 110731 | 110732 | 110733 | 110734 | 110736 | 110737 | 110882 | 110883 | 110937