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)
Make sure you have an index on dbmail_users.user_idnr because mysql cant create a key restraint if the column referenced isn't indexed first. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
