Dear All,
check the my following error, could any give me a clue where my states goes
wrong..
CREATE TABLE IF NOT EXISTS `esf_company_config` ( `esf_config_id` int( 11 )
NOT NULL AUTO_INCREMENT ,
`esf_config_company_id` int( 11 ) NOT NULL ,
`esf_config_name` varchar( 10 ) NOT NULL ,
`esf_config_status` int( 11 ) NOT NULL ,
PRIMARY KEY ( `esf_config_id` ) ,
FOREIGN KEY ( `esf_config_company_id` ) REFERENCES esf_company(
esf_company_id )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1
*MySQL said: *[image:
Documentation]<http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html>
#1005 - Can't create table './esf2/esf_company_config.frm' (errno: 150)
cheers
Ravi Jaya
feel the flavour of freedom
