https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10382 --- Comment #19 from M. Tompsett <mtompset@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.