[Dbmail] Error 1005 migrating dbmail-1 to dbmail-2 with Innodb

[Jacques Beaudoin]

Hi all

I get this message when migrating dbmail-1.2.6 to dbmail-2.0.0
via the "migrate_from_1.x_to_2.0_innodb.mysql" script

ERROR 1005 at line 164 : Can`t create table
"./dmail/auto_notification.frm" (errno:150)

Line 164 in the script is:

CREATE TABLE IF NOT EXISTS auto_notifications (
   auto_notify_idnr bigint(21) default '0' not null auto_increment,
   user_idnr bigint(21) DEFAULT '0' NOT NULL,
   notify_address VARCHAR(100),
   PRIMARY KEY (auto_notify_idnr),
   FOREIGN KEY (`user_idnr`)
                REFERENCES `dbmail_users`(`user_idnr`) ON DELETE CASCADE
) TYPE=InnoDB;

Looking for any help
Thanks

Bien à vous

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île
Montréal, Québec, Canada