Issue promoting a mysql table containing a structure field

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.

The table which is created by your CREATE TABLE statement is not valid JChem structure table. You can not create JChem structure tables directly in MySQL. Structure table contains specific chemical finger print and flag columns. Please read the details at http://www.chemaxon.com/jchem/doc/dev/dbconcepts/#tablestructure 

You can create structure tables by importing data in GUI by JCMan or IJC, or using JChem API directly in Java.

In this tutorial:

http://www.chemaxon.com/library/schema-editor-using-existing-db-tables/

an existing table is promoted to a structure table.
Was this existing table created using one of the tools you mentioned ?

 

Yes, that's right. The tables were formerly created by IJC (but other mentioned tools are also suitable).