Bug 31626: Add letter id to the message queue table
authorKyle Hall <kyle@bywatersolutions.com>
Mon, 26 Sep 2022 16:05:10 +0000 (12:05 -0400)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 18 Oct 2022 12:41:41 +0000 (09:41 -0300)
commit9bc996be91c58b22497bdb258df13306cce31767
treef50770d58d0471f641f170b523f0b082aaf77f88
parent6fc1ddd1442ee4ef32a7d9b4487fa32a7ac2a205
Bug 31626: Add letter id to the message queue table

It can be useful to know exactly what template was used to generate a notice. To this end, it would be useful to store the letter id as a foreign key in the message queue table.

Test Plan:
1) Apply this patch
2) Run updatedatabase.pl
3) Restart all the things!
4) Run an action that will send a notice to a patron
5) Note the letter id is now in the message_queue table for that notice!

Signed-off-by: Andrew Fuerste-Henry <andrewfh@dubcolib.org>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
C4/Letters.pm
installer/data/mysql/atomicupdate/bug_31626.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql
t/db_dependent/Letters.t