Bug 30852

Summary: article_requests missing index on debit_id
Product: Koha Reporter: Fridolin Somers <fridolin.somers>
Component: DatabaseAssignee: Fridolin Somers <fridolin.somers>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: tomascohen
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
22.05.00
Circulation function:
Bug Depends on: 27946    
Bug Blocks:    
Attachments: Bug 30852: Add index on article_requests.debit_id
Bug 30852: DBRev 21.12.00.057

Description Fridolin Somers 2022-05-26 06:25:25 UTC
Bug 27946 added foreign key in article_requests on debit_id.
This column needs a performance index.
Comment 1 Fridolin Somers 2022-05-26 06:37:27 UTC
I SO and PQA, this is needed for the release
Comment 2 Fridolin Somers 2022-05-26 06:37:58 UTC
Created attachment 135358 [details] [review]
Bug 30852: Add index on article_requests.debit_id

Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Comment 3 Fridolin Somers 2022-05-26 06:38:13 UTC
Created attachment 135359 [details] [review]
Bug 30852: DBRev 21.12.00.057

Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Comment 4 Fridolin Somers 2022-05-26 06:39:05 UTC
Pushed to master for 22.05, thanks to everybody involved ﷐[U+1F984]﷑