Bugzilla – Attachment 167500 Details for
Bug 35635
Expand patron attribute type mandatory field to allow different settings for OPAC and staff interface
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35635: DB Updates
Bug-35635-DB-Updates.patch (text/plain), 2.86 KB, created by
Lucas Gass (lukeg)
on 2024-06-05 22:17:05 UTC
(
hide
)
Description:
Bug 35635: DB Updates
Filename:
MIME Type:
Creator:
Lucas Gass (lukeg)
Created:
2024-06-05 22:17:05 UTC
Size:
2.86 KB
patch
obsolete
>From 8fcf6c7cdedae036e2387489852b0aeb0a32b98c Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >Date: Wed, 5 Jun 2024 22:10:34 +0000 >Subject: [PATCH] Bug 35635: DB Updates > >--- > .../bug_35635_add_opac_mandatory.pl | 30 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 3 +- > 2 files changed, 32 insertions(+), 1 deletion(-) > create mode 100755 installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl b/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl >new file mode 100755 >index 0000000000..85b9e7a7e6 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl >@@ -0,0 +1,30 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_failure say_success say_info); >+ >+return { >+ bug_number => "35635", >+ description => "Add opac_mandatory column to borrower_attribute_type table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ if ( !column_exists( 'borrower_attribute_types', 'opac_mandatory' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE borrower_attribute_types >+ ADD COLUMN `opac_mandatory` tinyint(1) DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not on the OPAC' >+ AFTER `mandatory` >+ } >+ ); >+ >+ say $out "Added column 'borrower_attribute_types.opac_mandatory'"; >+ >+ $dbh->do(q{ >+ UPDATE borrower_attribute_types >+ SET opac_mandatory = 1 WHERE mandatory = 1; >+ }); >+ say $out "Update opac_mandatory to match mandatory column"; >+ } >+ }, >+ >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 91c1bec42f..e9b0ca98e2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1250,7 +1250,8 @@ CREATE TABLE `borrower_attribute_types` ( > `category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type', > `class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type', > `keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)', >- `mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not', >+ `mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff client', >+ `opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', > PRIMARY KEY (`code`), > KEY `auth_val_cat_idx` (`authorised_value_category`), > KEY `category_code` (`category_code`), >-- >2.39.2
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 35635
:
167500
|
167501
|
167502
|
167546
|
167548
|
167643
|
167644
|
167645
|
167646
|
174962
|
175059
|
175635
|
175858
|
176595
|
176596
|
176597
|
176598
|
176599
|
176600
|
176601
|
176602
|
176603
|
176604
|
177803
|
177804
|
177805
|
177806
|
177807
|
177808
|
177809
|
177810
|
177811
|
177812
|
177814
|
177815
|
177816
|
177817
|
177818
|
177819
|
177820
|
177821
|
177822
|
177823
|
179165