(error #1005) Can't create table 'newdb.business' (errno: 150)
При создании таблицы, выдаёт ошибку как в заголовке.
Таблица accounts так-же на движке InnoDB. Что может быть не так?
mysql_tquery(mysql, "\
CREATE TABLE IF NOT EXISTS `business` (\
`business_id` int(9) NOT NULL,\
`business_type` int(3) NOT NULL,\
`business_owner` varchar(25) NOT NULL DEFAULT 'Unknown',\
`business_owner_id` int(11) NOT NULL DEFAULT '-1',\
PRIMARY KEY (`business_id`),\
CONSTRAINT `account_business_fk`\
FOREIGN KEY (`business_owner_id`,`business_owner`) REFERENCES accounts (`ID`,`ID`) ON DELETE SET DEFAULT,\
CONSTRAINT `account_business_fk_2`\
FOREIGN KEY (`business_owner`) REFERENCES accounts (`Name`) ON UPDATE CASCADE\
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;\
");