https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10382
--- Comment #19 from M. Tompsett <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
