[Contrib: Evaluation System] EVALSYS broken for MySQL???

[Jim Eng]

I think we've discussed this before, but I am not finding a record of it. 

I am attempting to build trunk of evaluation along with the 1.2.5 tag of hierarchy in sakai trunk.  It builds and deploys just fine but fails to start up due to SQL errors.  In particular, there are a number of errors relating to primary keys that exceed MySQL's 1000-byte maximum key length.  Here's an example: 

WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create table EVAL_ASSIGN_USER (ID bigint not null auto_increment, EID varchar(255), LAST_MODIFIED datetime not null, OWNER varchar(255) not null, USER_ID varchar(255) not null, GROUP_ID varchar(255) not null, ASSIGN_TYPE varchar(255) not null, ASSIGN_STATUS varchar(255) not null, LIST_ORDER integer not null, ASSIGN_GROUP_ID bigint, EVALUATION_FK bigint not null, primary key (ID), unique (USER_ID, GROUP_ID, ASSIGN_TYPE, EVALUATION_FK))
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes

Have other people seen this with MySQL?  Is there an existing fix or workaround?

Thanks.

Jim