]> git.koha-community.org Git - koha.git/commit
Bug 24289: Add foreign keys on *_holidays.branchcode tables
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 26 Dec 2019 10:42:43 +0000 (11:42 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 20 Jan 2020 14:03:51 +0000 (14:03 +0000)
commit89f572ff5f9788d5e392804d04c5ce39d0655424
tree764dd47b28052a11aa9baf72971aa396218a7e6c
parent90c92686eb037ff032614a0f5b79da6c66e640eb
Bug 24289: Add foreign keys on *_holidays.branchcode tables

Those are missing foreign keys, it will also clean the holidays tables
and automatically remove the holidays when a library is removed.

Test plan:
0. Do not apply this patch
1. Create a new library
2. Create special and repeatable holiday for this library
3. Remove the library
=> Notice that the holidays still exist in DB
4. Apply this patch
5. Execute the update database entry
=> Notice that the holidays for this library have been removed from the DB
6. Repeat 1-3
=> Notice that the holidays have been removed along with the library

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/atomicupdate/bug_24289.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql