I have an issue promoting a mysql table containing a structure field.
This is the table definition:
CREATE TABLE `test3` (
`x_id` int(11) NOT NULL AUTO_INCREMENT,
`structure` text NOT NULL,
`ID` varchar(12) DEFAULT NULL,
`FORMULA` varchar(15) DEFAULT NULL,
`WEIGHT` varchar(11) DEFAULT NULL,
`SMILES` varchar(88) DEFAULT NULL,
`KEGG` varchar(9) DEFAULT NULL,
`NAME` varchar(15) DEFAULT NULL,
`CAS` varchar(67) DEFAULT NULL,
PRIMARY KEY (`x_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1
IJC does not see the table as containing structures, and is thus promoting it to a standard table.
I tried converting the TEXT field into a MEDIUMBLOB field, to no avail.
I probably missed something obvious, and would be grateful to anyone that can point it out.