Hi,
I'm trying to create a table with 2 foreign keys from two tables, but
it not workin
here is the query ( i have generated this query from mysql workbench)
--
CREATE TABLE IF NOT EXISTS `menutest`.`role_perm` (
`idrole` INT NOT NULL ,
`permid` VARCHAR(45) NOT NULL ,
`status` BOOLEAN NOT NULL DEFAULT 1 ,
INDEX fk_role (`idrole` ASC) ,
INDEX fk_perm (`permid` ASC) ,
CONSTRAINT `fk_role`
FOREIGN KEY (`idrole` )
REFERENCES `menutest`.`role` (`idrole` )
ON DELETE SET NULL
ON UPDATE CASCADE,
CONSTRAINT `fk_perm`
FOREIGN KEY (`permid` )
REFERENCES `menutest`.`permission` (`idpermission` )
ON DELETE SET NULL
ON UPDATE CASCADE)
ENGINE = InnoDB;
--
here is the error mssage :Can't create table
'.\menutest\role_perm.frm' (errno: 150)
--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
