Bug 33671: Fix for 30472 - Remove null-guarantors
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 4 May 2023 06:41:19 +0000 (06:41 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 10 May 2023 17:19:24 +0000 (14:19 -0300)
commit1dee35d412f9aada8ae58d72a7fa1f4ff88dde7c
treedb7318fe5aa065709c1db4a9228bd7c9f39cbc63
parent6fafe5e05b542a6da3b2338ef071f4ebc31d0810
Bug 33671: Fix for 30472 - Remove null-guarantors

These guarantors cannot be added. They are of no use.

NOTE FOR QA/RM: I do not think that it is needed to add a new
db rev for this change since it happens seldom. But if you think
that it is, just copy it to atomicupdate/change bugno.

Test plan:
[1] Check your table definition and modify it:
    alter table borrower_relationships modify column `guarantor_id` int(11) NULL;
[2] Add an empty guarantor:
    insert into borrower_relationships (guarantee_id,relationship) values (SOME_PATRON_ID,'father');
[3] Run the dbrev and verify that the inserted record has been removed.
[4] Check table definition with 'show create table borrower_relationships'.
    You should see NOT NULL with guarantor_id.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/db_revs/220600048.pl