Bugzilla – Attachment 182242 Details for
Bug 35145
Add ability to order patron attributes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35145: Database updates
Bug-35145-Database-updates.patch (text/plain), 2.64 KB, created by
David Nind
on 2025-05-11 22:41:31 UTC
(
hide
)
Description:
Bug 35145: Database updates
Filename:
MIME Type:
Creator:
David Nind
Created:
2025-05-11 22:41:31 UTC
Size:
2.64 KB
patch
obsolete
>From f9f8a57900905ebb9d8e728006ca8d46dde8c992 Mon Sep 17 00:00:00 2001 >From: Hammat Wele <hammat.wele@inlibro.com> >Date: Wed, 14 Aug 2024 20:00:42 +0000 >Subject: [PATCH] Bug 35145: Database updates >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >Signed-off-by: Anneli Ãsterman <anneli.osterman@koha-suomi.fi> >Signed-off-by: Lucas Gass <lucas@bywatersolutions.com> >Signed-off-by: David Nind <david@davidnind.com> >--- > .../bug_35145_order_patron_attributes.pl | 23 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 24 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl b/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl >new file mode 100755 >index 0000000000..4a7a690ee2 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl >@@ -0,0 +1,23 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "35145", >+ description => "Add display_order column to borrower_attribute_types table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ # Do you stuffs here >+ $dbh->do( >+ q{ >+ ALTER TABLE borrower_attribute_types >+ ADD COLUMN IF NOT EXISTS display_order INT(11) DEFAULT NULL COMMENT >+ 'the order in which this attribute type appears in patron form' AFTER `mandatory` >+ } >+ ); >+ >+ # Print useful stuff here >+ # tables >+ say_success( $out, "Added column 'borrower_attribute_types.display_order'" ); >+ }, >+}; >\ No newline at end of file >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3602c65c18..f9fee94044 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1261,6 +1261,7 @@ CREATE TABLE `borrower_attribute_types` ( > `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 in the staff interface', > `opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', >+ `display_order` int(11) DEFAULT NULL COMMENT 'the order in which this attribute type appears in patron form', > PRIMARY KEY (`code`), > KEY `auth_val_cat_idx` (`authorised_value_category`), > KEY `category_code` (`category_code`), >-- >2.39.5
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 35145
:
159182
|
159193
|
159344
|
159345
|
162347
|
162348
|
162619
|
162620
|
162621
|
162622
|
162676
|
166473
|
166519
|
166520
|
166521
|
169256
|
169257
|
169258
|
170330
|
170331
|
170332
|
170627
|
170628
|
170629
|
176756
|
176757
|
176758
|
176760
|
176761
|
176762
|
176763
|
176764
|
176765
|
177119
|
181885
|
181886
|
181887
|
181888
|
181889
|
181890
|
182241
| 182242 |
182243
|
182244
|
182245
|
182246