mysql> SHOW CREATE TABLE wc_acj.multi_resource_apt\G *************************** 1. row *************************** Table: multi_resource_apt Create Table: CREATE TABLE `multi_resource_apt` ( `apt_id` int(10) unsigned NOT NULL DEFAULT '0', `res_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`apt_id`,`res_id`), KEY `resid` (`res_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec)
mysql> SHOW CREATE TABLE wc_acj. multi_resource_ apt\G ******* ******* ****** 1. row ******* ******* ******* ****** resource_ apt` ( ,`res_id` ),
*******
Table: multi_resource_apt
Create Table: CREATE TABLE `multi_
`apt_id` int(10) unsigned NOT NULL DEFAULT '0',
`res_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`apt_id`
KEY `resid` (`res_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)