Thomas Gelf skrev:
> 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?
It is exactly what I am trying to explain to Zhang, I showed it with an example.
/Max
-------------------------------------------------------------------------
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/
