Andrea Brancatelli wrote:
mysql> alter table dbmail_subscription add FOREIGN KEY user_id_fk (user_id) REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCAde; ERROR 1005 (HY000): Can't create table 'dbmail.#sql-11c81_2f519' (errno: 150)

SET FOREIGN_KEY_CHECKS = 0;
Do your modifications.
SET FOREIGN_KEY_CHECKS = 1;

Alex
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to