[Koha-bugs] [Bug 17160] Foreign key constraint for message_transports is too loose

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

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

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at bugs.koha-c
                   |                            |ommunity.org

--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Barton, I understand the problem but it does not look so easy to fix it.
In the message_transports we have

MariaDB [koha]> select message_transport_type, letter_module, letter_code from
message_transports;                            
+------------------------+---------------+-------------+
| message_transport_type | letter_module | letter_code |
+------------------------+---------------+-------------+
| email                  | circulation   | CHECKIN     |
| sms                    | circulation   | CHECKIN     |
| email                  | circulation   | CHECKOUT    |
| sms                    | circulation   | CHECKOUT    |
| email                  | circulation   | DUE         |
| sms                    | circulation   | DUE         |
| email                  | circulation   | DUEDGST     |
| sms                    | circulation   | DUEDGST     |
| email                  | circulation   | PREDUE      |
| sms                    | circulation   | PREDUE      |
| email                  | circulation   | PREDUEDGST  |
| sms                    | circulation   | PREDUEDGST  |
| email                  | reserves      | HOLD        |
| sms                    | reserves      | HOLD        |
+------------------------+---------------+-------------+
14 rows in set (0.10 sec)

But the letter table does necessarily contain a sms template for CHECKIN or
CHECKOUT (or whatever).
If it does not exist, we won't be able to create the FK correctly.

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