https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556
--- Comment #3 from Galen Charlton <gmcha...@gmail.com> ---
This could do it in-place:
ALTER TABLE borrower_message_transport_preferences
DROP FOREIGN KEY borrower_message_transport_preferences_ibfk_1;
ALTER TABLE borrower_message_preferences0
MODIFY borrower_message_preference_id bigint(11) UNSIGNED NOT NULL
AUTO_INCREMENT;
ALTER TABLE borrower_message_transport_preferences
MODIFY borrower_message_preference_id bigint(11) UNSIGNED NOT NULL DEFAULT
0;
ALTER TABLE borrower_message_transport_preferences
ADD CONSTRAINT borrower_message_transport_preferences_ibfk_1
FOREIGN KEY (`borrower_message_preference_id`)
REFERENCES `borrower_message_preferences`
(`borrower_message_preference_id`)
ON DELETE CASCADE ON UPDATE CASCADE;
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://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/
