Max Matslofva schrieb: > mysql> CREATE TABLE quarantine ( > -> ... > -> FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE > -> ) ENGINE=InnoDB; > ERROR 1005 (HY000): Can't create table './maxtest/quarantine.frm' (errno: 150) > > mysql> CREATE TABLE msgs ( > -> ... > -> ) ENGINE=InnoDB; > Query OK, 0 rows affected (0.03 sec) > > mysql> CREATE TABLE quarantine ( > -> ... > -> FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE > -> ) ENGINE=InnoDB; > Query OK, 0 rows affected (0.03 sec)
You can't create table quarantine referencing table msgs as long as msgs doesn't exist. Could this be the root your problem? Cheers, Thomas Gelf ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
