[Koha-bugs] [Bug 30899] Upgrade sometimes fails at "Upgrade to 21.11.05.004"
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jun 8 09:17:21 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899
Fridolin Somers <fridolin.somers at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #135779|0 |1
is obsolete| |
--- Comment #18 from Fridolin Somers <fridolin.somers at biblibre.com> ---
Created attachment 135790
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=135790&action=edit
Bug 30899: [MASTER 22.12] Correct dbrev 211200041
Replace DROP CONSTRAINT by DROP FOREIGN KEY.
Note: It seems that we do not need a new dbrev for master. A developer
could follow test plan below to correct if really needed.
Test plan:
NOTE: When you check show create table, verify that you see an index for
category_code and a foreign key called borrower_attribute_types_ibfk_1.
[1] cp installer/data/mysql/db_revs/211200041.pl
installer/data/mysql/atomicupdate/
[2] run updatedatabase; check show create table
[3] alter table borrower_attribute_types drop foreign key
borrower_attribute_types_ibfk_1; alter table borrower_attribute_types drop
index category_code; RUN updatedatabase again; check show create table
[4] alter table borrower_attribute_types drop foreign key
borrower_attribute_types_ibfk_1; ALTER TABLE borrower_attribute_types ADD
CONSTRAINT category_code_fk FOREIGN KEY (category_code) REFERENCES
categories(categorycode); RUN updatedatabase again; check show create table
[5] rm installer/data/atomicupdate/211200041.pl
Signed-off-by: Fridolin Somers <fridolin.somers at biblibre.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list