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 _______________________________________________ To unsubscribe, email [EMAIL PROTECTED] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
