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
_______________________________________________
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
