MODE_OPTIONS table is not valid in a MySQL database

Ran across this the other day w/ Brian. The table's just not valid with MySQL even after running the generator

mysql> create table MODE_OPTIONS (NAME varchar(512) not null, VALUE varchar(512) not null, primary key (NAME)) ENGINE=InnoDB;
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
mysql> create table MODE_OPTIONS (NAME varchar(512) not null, VALUE varchar(512) not null, primary key (NAME)) ENGINE=InnoDB;
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

so if it's InnoDB or MyISAM it fails.