Issue #96: MySQL Operational Error 1071 when running paster setup-db production.ini (conservancy/kallithea)

[Brandon Jones]

New issue 96: MySQL Operational Error 1071 when running paster setup-db production.ini
https://bitbucket.org/conservancy/kallithea/issue/96/mysql-operational-error-1071-when-running

Brandon Jones:

I am receiving the following error when trying to run the database setup for Kallithea:

(Operational Error) (1071, 'Specified key was too long: max key length is 767 bytes') 'CREATE INDEX notification_type_idx ON notifications (type)' ()

Looking at the schema, it would appear that the **type** field of the *notifications* table is a VARCHAR(256) - which, with UTF-8, puts that at 768 bytes with 3 bytes per character - 1 byte over the Inno-DB limitation.  

Is it assumed that innodb_large_prefix is true?