From 7ff3178e578df7b7094f09c90f56a42831440530 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 11 Aug 2023 13:07:52 +0000 Subject: [PATCH] Bug 34517: DB updates --- ..._searched_by_default_to_attribute_types.pl | 25 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 26 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_34517_add_searched_by_default_to_attribute_types.pl diff --git a/installer/data/mysql/atomicupdate/bug_34517_add_searched_by_default_to_attribute_types.pl b/installer/data/mysql/atomicupdate/bug_34517_add_searched_by_default_to_attribute_types.pl new file mode 100755 index 0000000000..767f212513 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_34517_add_searched_by_default_to_attribute_types.pl @@ -0,0 +1,25 @@ +use Modern::Perl; + +return { + bug_number => "34517", + description => "Add option to specify which patron attributes are searched by default", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # Do you stuffs here + unless ( column_exists( 'borrower_attribute_type', 'searched_by_default' ) ) { + $dbh->do(q{ + ALTER TABLE borrower_attribute_types + ADD COLUMN `searched_by_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is included in "Standard" patron searches in the staff interface (1 for yes, 0 for no)' + AFTER `staff_searchable` + }); + say $out "Added column 'borrower_attribute_types.searched_by_default'"; + $dbh->do(q{ + UPDATE borrower_attribute_types + SET searched_by_default = 1 WHERE staff_searchable = 1; + }); + say $out "Updated values to match staff_searchable columns"; + } + }, +}; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c1f800fe7f..81a5cbd9c7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1193,6 +1193,7 @@ CREATE TABLE `borrower_attribute_types` ( `opac_display` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)', `opac_editable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no)', `staff_searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is searchable via the patron search in the staff interface (1 for yes, 0 for no)', + `searched_by_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is included in "Standard" patron searches in the staff interface (1 for yes, 0 for no)', `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'foreign key from authorised_values that links this custom field to an authorized value category', `display_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field displays in checkout screens', `category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', -- 2.30.2