[Koha-bugs] [Bug 32556] borrower_message_preference_id reaches limit

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

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

--- Comment #4 from Galen Charlton <gmcharlt at gmail.com> ---
Whoops, syntax error. I meant:

ALTER TABLE borrower_message_transport_preferences 
  DROP FOREIGN KEY borrower_message_transport_preferences_ibfk_1;
ALTER TABLE borrower_message_preferences
  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.