Bugzilla – Attachment 121601 Details for
Bug 28490
Cannot modify patrons in some categories (e.g. Child category)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28490: Bring back accidentally deleted relationship columns
Bug-28490-Bring-back-accidentally-deleted-relation.patch (text/plain), 2.19 KB, created by
Kyle M Hall (khall)
on 2021-06-03 14:29:47 UTC
(
hide
)
Description:
Bug 28490: Bring back accidentally deleted relationship columns
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2021-06-03 14:29:47 UTC
Size:
2.19 KB
patch
obsolete
>From eff4790e6d85e659263c8873ebb8da74b7c59060 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Joonas=20Kylm=C3=A4l=C3=A4?= <joonas.kylmala@helsinki.fi> >Date: Wed, 2 Jun 2021 20:37:25 +0300 >Subject: [PATCH] Bug 28490: Bring back accidentally deleted relationship > columns > >These were in active use before and were accidentally deleted in Bug >26995. This restores those deleted relationship columns. > >To test: > 1) verify the borrower_modifications, borrowers, > deletedborrowers contain the column exactly like it was before after > applying these patches by comparing to the old kohastructure.sql > version > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > ...g_28490-recreate_relationship_columns.perl | 22 +++++++++++++++++++ > 1 file changed, 22 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_28490-recreate_relationship_columns.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_28490-recreate_relationship_columns.perl b/installer/data/mysql/atomicupdate/bug_28490-recreate_relationship_columns.perl >new file mode 100644 >index 0000000000..1940ca0a7c >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_28490-recreate_relationship_columns.perl >@@ -0,0 +1,22 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'borrower_modifications', 'relationship' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE borrower_modifications ADD COLUMN `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL >+ }); >+ } >+ >+ if( !column_exists( 'borrowers', 'relationship' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE borrowers ADD COLUMN `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor' >+ }); >+ } >+ >+ if( !column_exists( 'deletedborrowers', 'relationship' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE deletedborrowers ADD COLUMN `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor' >+ }); >+ } >+ >+ NewVersion( $DBversion, 28490, "Bring back accidentally deleted relationship columns"); >+} >-- >2.30.1 (Apple Git-130)
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 28490
:
121538
|
121545
|
121546
|
121547
|
121548
|
121549
|
121550
|
121551
|
121552
|
121595
|
121596
|
121597
|
121598
|
121599
|
121600
|
121601
|
121602
|
121655
|
121656
|
121661
|
121662
|
121663
|
121664
|
121665
|
121666
|
121667
|
121669
|
121811
|
121812
|
121813
|
121814
|
121815
|
121816
|
121817
|
121818
|
121823
|
121824
|
121825
|
121826
|
121827
|
121828
|
121829
|
121830
|
121915