Bugzilla – Attachment 121827 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: Revert "Bug 26995: Drop column relationship from borrowers, deletedborrowers and borrower_modifications tables"
Bug-28490-Revert-Bug-26995-Drop-column-relationshi.patch (text/plain), 4.96 KB, created by
Nick Clemens (kidclamp)
on 2021-06-11 12:40:31 UTC
(
hide
)
Description:
Bug 28490: Revert "Bug 26995: Drop column relationship from borrowers, deletedborrowers and borrower_modifications tables"
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2021-06-11 12:40:31 UTC
Size:
4.96 KB
patch
obsolete
>From 8f209155d824fbe963bbf6fddf84efa416057f5f 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 17:14:08 +0000 >Subject: [PATCH] Bug 28490: Revert "Bug 26995: Drop column relationship from > borrowers, deletedborrowers and borrower_modifications tables" > >This reverts commit ca0e7541ecdff13ada9ba8ffbd992c963959d30f. > >It was part of a patch set that removed actively used data and must be >therefore reverted. > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >Signed-off-by: Petro Vashchuk <stalkernoid@gmail.com> >Signed-off-by: Emmi Takkinen <emmi.takkinen@koha-suomi.fi> > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > C4/Auth_with_ldap.pm | 1 + > C4/SIP/ILS/Patron.pm | 1 + > installer/data/mysql/kohastructure.sql | 3 +++ > 3 files changed, 5 insertions(+) > >diff --git a/C4/Auth_with_ldap.pm b/C4/Auth_with_ldap.pm >index c87ea20c93..87a0538dea 100644 >--- a/C4/Auth_with_ldap.pm >+++ b/C4/Auth_with_ldap.pm >@@ -478,6 +478,7 @@ C4::Auth - Authenticates Koha users > | contactfirstname | text | YES | | NULL | | > | contacttitle | text | YES | | NULL | | > | borrowernotes | mediumtext | YES | | NULL | | >+ | relationship | varchar(100) | YES | | NULL | | > | ethnicity | varchar(50) | YES | | NULL | | > | ethnotes | varchar(255) | YES | | NULL | | > | sex | varchar(1) | YES | | NULL | | >diff --git a/C4/SIP/ILS/Patron.pm b/C4/SIP/ILS/Patron.pm >index b72128d7ab..d5ac629023 100644 >--- a/C4/SIP/ILS/Patron.pm >+++ b/C4/SIP/ILS/Patron.pm >@@ -690,6 +690,7 @@ __END__ > | contactfirstname | text | YES | | NULL | | > | contacttitle | text | YES | | NULL | | > | borrowernotes | mediumtext | YES | | NULL | | >+| relationship | varchar(100) | YES | | NULL | | > | ethnicity | varchar(50) | YES | | NULL | | > | ethnotes | varchar(255) | YES | | NULL | | > | sex | varchar(1) | YES | | NULL | | >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 900d8cf085..6f76d79ee4 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1283,6 +1283,7 @@ CREATE TABLE `borrower_modifications` ( > `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, >+ `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `flags` int(11) DEFAULT NULL, >@@ -1399,6 +1400,7 @@ CREATE TABLE `borrowers` ( > `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', > `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', > `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', >+ `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', > `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', > `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password', > `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', >@@ -2401,6 +2403,7 @@ CREATE TABLE `deletedborrowers` ( > `contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', > `contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', > `borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', >+ `relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', > `sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', > `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password', > `flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', >-- >2.11.0
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