mysql> show create table info1; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | info1 | CREATE TABLE `info1` ( `info1_pk` int(10) unsigned NOT NULL, `info1_1` varchar(20) DEFAULT NULL, `info1_2` varchar(20) DEFAULT NULL, PRIMARY KEY (`info1_pk`), CONSTRAINT `info1_main` FOREIGN KEY (`info1_pk`) REFERENCES `main` (`pk`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table info2; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | info2 | CREATE TABLE `info2` ( `info2_pk` int(10) unsigned NOT NULL, `info2_1` varchar(20) DEFAULT NULL, `info2_2` varchar(20) DEFAULT NULL, PRIMARY KEY (`info2_pk`), CONSTRAINT `info2_main` FOREIGN KEY (`info2_pk`) REFERENCES `main` (`pk`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)