[Koha-bugs] [Bug 10382] collection not returning to null when removed from course reserves

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

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

--- Comment #19 from M. Tompsett <mtompset at hotmail.com> ---
Comment on attachment 60979
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=60979
Bug 10382 - Course reserves: handle empty values

Review of attachment 60979:
 --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=10382&attachment=60979)
-----------------------------------------------------------------

:::
installer/data/mysql/atomicupdate/bug_10382-changes-on-courseitems-table.sql
@@ +1,4 @@
> +ALTER TABLE course_items DROP FOREIGN KEY course_items_ibfk_2;
> +ALTER TABLE course_items MODIFY itype VARCHAR(20);
> +ALTER TABLE course_items MODIFY ccode VARCHAR(20);
> +ALTER TABLE course_items MODIFY holdingbranch VARCHAR(20);
\ No newline at end of file

Why drop the foreign key completely? Shouldn't the key be recreated?

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