From 9d6d1cbd18329bc91b2320a6ea75a04f4333485f Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Thu, 23 Jun 2022 12:14:33 -0300 Subject: [PATCH] Bug 12446: (QA follow-up) Minor kohastructure.sql fix Signed-off-by: Tomas Cohen Arazi --- Koha/Schema/Result/Category.pm | 6 ++++-- installer/data/mysql/db_revs/220600004.pl | 3 ++- installer/data/mysql/kohastructure.sql | 4 ++-- 3 files changed, 8 insertions(+), 5 deletions(-) diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index e5bb22f068..fd8e78167f 100644 --- a/Koha/Schema/Result/Category.pm +++ b/Koha/Schema/Result/Category.pm @@ -168,6 +168,8 @@ produce a warning for this patron category if this item has previously been chec default_value: 0 is_nullable: 0 +if patrons of this category can be guarantees + =head2 reset_password data_type: 'tinyint' @@ -361,8 +363,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-23 14:48:14 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:onduD3AbdO0w18tOKuTLzA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-23 15:17:56 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5gVAZYJ4TW6H2DjdmBXkBQ __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/installer/data/mysql/db_revs/220600004.pl b/installer/data/mysql/db_revs/220600004.pl index eab9269c0e..1363e95d16 100755 --- a/installer/data/mysql/db_revs/220600004.pl +++ b/installer/data/mysql/db_revs/220600004.pl @@ -10,7 +10,8 @@ return { unless ( column_exists( 'categories', 'canbeguarantee' ) ) { $dbh->do(q{ ALTER TABLE categories - ADD COLUMN `canbeguarantee` tinyint(1) NOT NULL default '0' AFTER `checkprevcheckout` + ADD COLUMN `canbeguarantee` tinyint(1) NOT NULL default 0 COMMENT 'if patrons of this category can be guarantees' + AFTER `checkprevcheckout` }); } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 8ca69bcc88..c164cb404d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1664,8 +1664,8 @@ CREATE TABLE `categories` ( `BlockExpiredPatronOpacActions` tinyint(1) NOT NULL DEFAULT -1 COMMENT 'wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions', `default_privacy` enum('default','never','forever') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Default privacy setting for this patron category', `checkprevcheckout` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for this patron category if this item has previously been checked out to this patron if ''yes'', not if ''no'', defer to syspref setting if ''inherit''.', -`canbeguarantee` tinyint(1) NOT NULL default '0', -`reset_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can do the password reset flow,', + `canbeguarantee` tinyint(1) NOT NULL default 0 COMMENT 'if patrons of this category can be guarantees', + `reset_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can do the password reset flow,', `change_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can change their passwords in the OAPC', `min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', `require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', -- 2.39.2