From 6fadf7eb004ceac37735eab1dd8e77c04f6becd9 Mon Sep 17 00:00:00 2001 From: David Gustafsson Date: Tue, 25 Mar 2025 21:44:14 +0100 Subject: [PATCH] Bug 39453: Schema changes --- Koha/Schema/Result/BorrowerAttributeType.pm | 37 +++++++++++++++++++ ...new-columns-to-borrower-attribute-types.pl | 2 +- 2 files changed, 38 insertions(+), 1 deletion(-) diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm index 36bf42d4c91..2fb2d3d214d 100644 --- a/Koha/Schema/Result/BorrowerAttributeType.pm +++ b/Koha/Schema/Result/BorrowerAttributeType.pm @@ -155,6 +155,37 @@ defines if the attribute is mandatory or not in the OPAC =cut +=head2 hidden + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +defines if the attribute is hidden or not + +=cut + +=head2 readonly + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +defines if the attribute is readonly or not + +=cut + +=head2 secret + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +defines if the attribute is secret or not + +=cut + + __PACKAGE__->add_columns( "code", { data_type => "varchar", is_nullable => 0, size => 64 }, @@ -188,6 +219,12 @@ __PACKAGE__->add_columns( { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "opac_mandatory", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "hidden", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "readonly", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "secret", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); =head1 PRIMARY KEY diff --git a/installer/data/mysql/atomicupdate/bug_39453-add-new-columns-to-borrower-attribute-types.pl b/installer/data/mysql/atomicupdate/bug_39453-add-new-columns-to-borrower-attribute-types.pl index 9d846da2cc0..585f4cd617f 100755 --- a/installer/data/mysql/atomicupdate/bug_39453-add-new-columns-to-borrower-attribute-types.pl +++ b/installer/data/mysql/atomicupdate/bug_39453-add-new-columns-to-borrower-attribute-types.pl @@ -9,7 +9,7 @@ return { my ( $dbh, $out ) = @$args{qw(dbh out)}; $dbh->do( - q{ALTER TABLE `borrower_attribute_types` ADD COLUMN `hidden` tinyint(1) NOT NULL DEFAULT 0, ADD COLUMN `readonly` tinyint(1) NOT NULL DEFAULT 0, ADD COLUMN `secret` tinyint(1) NOT NULL DEFAULT 0} + q{ALTER TABLE `borrower_attribute_types` ADD COLUMN IF NOT EXISTS `hidden` tinyint(1) NOT NULL DEFAULT 0, ADD COLUMN IF NOT EXISTS `readonly` tinyint(1) NOT NULL DEFAULT 0, ADD COLUMN IF NOT EXISTS `secret` tinyint(1) NOT NULL DEFAULT 0} ); say $out -- 2.51.2