mysql> show create table main;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------+
| Table | Create Table                                                                                                                                                                                           
                                                                                                                                                                                                                 
                          |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------+
| main  | CREATE TABLE `main` (  `pk` int(10) unsigned NOT NULL AUTO_INCREMENT,  `data_fk` int(10) unsigned NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `main_data` (`data_fk`),
  CONSTRAINT `main_info2` FOREIGN KEY (`pk`) REFERENCES `info2` (`info2_pk`),
  CONSTRAINT `main_data` FOREIGN KEY (`data_fk`) REFERENCES `data` (`d_pk`),  CONSTRAINT `main_info1` FOREIGN KEY (`pk`) REFERENCES `info1` (`info1_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table data;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------+
| Table | Create Table                                                                                                                                                                                           
              |+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------+
| data  | CREATE TABLE `data` (
  `d_pk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `some_dat` varchar(20) DEFAULT NULL,  `more_dat` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`d_pk`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)