Hi,
I'm wondering if anybody can help me decrypt what this error code is referring to:
ERROR 1071: Specified key was too long. Max key length is 500
This is the offending table creation script:
CREATE TABLE `APPROVAL` (
`APPROVAL_ID` mediumint(9) unsigned NOT NULL auto_increment,
`APPROVAL_CURRENT_LEVEL` mediumint(8) unsigned NOT NULL default '1',
`APPROVAL_HIGHEST_LEVEL` mediumint(8) unsigned NOT NULL default '1',
`APPROVAL_STATUS` varchar(255) NOT NULL default '',
`APPROVAL_SUB_STATUS` varchar(255) default NULL,
`APPROVAL_APPLICATION` varchar(255) NOT NULL default '',
`FOREIGN_ID` mediumint(9) unsigned NOT NULL default '0',
`FOREIGN_PARENT_ID` mediumint(9) NOT NULL default '0',
`FOREIGN_TYPE` varchar(255) NOT NULL default '',
`CREATED_BY` mediumint(9) NOT NULL default '0',
`CREATED_DT` date NOT NULL default '0000-00-00',
`MODIFIED_BY` mediumint(9) default NULL,
`MODIFIED_TS` timestamp(14) NOT NULL,
PRIMARY KEY (`APPROVAL_ID`),
UNIQUE KEY `APPROVAL_APPLICATION` (`APPROVAL_APPLICATION`,`FOREIGN_ID`,`FOREIGN_TYPE`)
) TYPE=InnoDB ROW_FORMAT=DYNAMIC;
Is it the unique key I'm creating and if so how do I get around that?
Thanks,
Jon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
