Hello
I have a problem for creating 2 Innodb tables with foreign keys :
CREATE TABLE article ( id_art smallint(5) unsigned NOT NULL auto_increment, intituler varchar(255) default NULL, texte_art text, id_rub smallint(5) unsigned NOT NULL default '0', id_membre smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (id_art), UNIQUE KEY id_art (id_art), KEY index_id_rub (id_rub), KEY index_id_membre (id_membre), KEY id_artr (id_art), FOREIGN KEY (id_rub) REFERENCES rubrique (id_rub), FOREIGN KEY (id_membre) REFERENCES membres (id_membre) ) TYPE=InnoDB;
And this is the table that mysql can't create :
CREATE TABLE commentaire ( id_comm smallint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, pseudo varchar( 50 ) NOT NULL default '', email varchar( 50 ) NOT NULL default '', note tinyint default NULL , id_art smallint NOT NULL, index index_id_art(id_art), FOREIGN KEY (id_art) REFERENCES article(id_art) ) TYPE = InnoDB;
Mysql give me this error :
Can't create table '.\ppn\commentaire.frm' (errno: 150)
PS : I'm on WIN 2000 with MYSQL 3.51
Thanks
bye
