It works
mysql> create table esf_company( id int(11) auto_increment primary key,
-> remarks varchar(50)) ENGINE = InnoDB DEFAULT CHARSET = latin1
AUTO_INCREMENT =1;
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE IF NOT EXISTS esf_company_config ( esf_config_id
int( 11 ) NOT NULL AUTO_INCREMENT Primary key , esf_config_company_id
int( 11 ) NOT NULL , esf_config_name varchar( 10 ) NOT NULL ,
esf_config_status int( 11 ) NOT NULL , FOREIGN KEY (
esf_config_company_id ) REFERENCES esf_company( id ) ) ENGINE =
InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;
Query OK, 0 rows affected (0.03 sec)
Thyagarajan Shanmugham