USE test; DROP TABLE IF EXISTS relvar_a;
CREATE TABLE relvar_a ( #PK SSN CHAR(9) NOT NULL, #FK SUPERSSN CHAR(9), DNO INT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )ENGINE = INNODB; SHOW WARNINGS; DESCRIBE relvar_a; DROP TABLE IF EXISTS relvar_b; CREATE TABLE relvar_b ( #PK DNUMBER INT NOT NULL, #FK MGRSSN CHAR(9) NOT NULL DEFAULT '888665555', PRIMARY KEY (DNUMBER), INDEX(MGRSSN) )ENGINE = INNODB; SHOW INNODB STATUS ; ALTER TABLE relvar_a # won't do line 38 ADD FOREIGN KEY (DNO) REFERENCES relvar_b(DNUMBER) ON DELETE SET DEFAULT ON UPDATE CASCADE; ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150) Bye mysql> select version(); +--------------------+ | version() | +--------------------+ | 5.0.0-alpha-max-nt | +--------------------+ 1 row in set (0.11 sec) Microsoft Windows 2000 [Version 5.00.2195]