Change the size of an InnoDB table field

[Félix Beltrán]

I'm trying to change the size of an InnoDB table field from CHAR(20) 
to CHAR(30) using MySQLCC, but i'm getting this error message

ERROR 1091: Can't DROP '0_87'. Check that column/key exists

This is the create query:

CREATE TABLE `presentacion` (
  `cl_Presentacion` char(4) NOT NULL default '',
  `cl_Embase` char(4) NOT NULL default '',
  `cl_Tamano` char(4) NOT NULL default '',
  `cl_Variedad` char(4) NOT NULL default '',
  `de_Presentacion` char(20) default NULL,
  PRIMARY KEY  (`cl_Presentacion`),
  KEY `presentacion_FKIndex1` (`cl_Variedad`),
  KEY `presentacion_FKIndex2` (`cl_Tamano`),
  KEY `presentacion_FKIndex3` (`cl_Embase`),
  CONSTRAINT `0_85` FOREIGN KEY (`cl_Variedad`) REFERENCES `variedad` 
(`cl_Variedad`),
  CONSTRAINT `0_86` FOREIGN KEY (`cl_Tamano`) REFERENCES `tamano` 
(`cl_Tamano`),
  CONSTRAINT `0_87` FOREIGN KEY (`cl_Embase`) REFERENCES `embase` 
(`cl_Embase`)
) TYPE=InnoDB; 

Any clues about this??


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]