[Koha-bugs] [Bug 22658] aqbasket.authorisedby is missing a foreign key constraint

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22658

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tomascohen at gmail.com

--- Comment #1 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
I propose we create a new column: creator_id INT(11) NULL DEFAULT NULL, with FK
constraint on the borrowers table, and we move/copy there the values of
authorisedby that look like a number. If there's no remaining value on
authorisedby, then drop the column. Otherwise, just leave it and print a
noticeable message about manually removing the column once inconsistencies are
solved.

I haven't found references to the column in contexts in which it is not tested
against the borrowers.borrowernumber column, but there might be old/legacy data
there, or I'm sure Jonathan will find that spot I missed.

-- 
You are receiving this mail because:
You are watching all bug changes.