From 3803bbb275b7ff75054384e9d340eb6be2a0804d Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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 Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall 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)