I think this has to do with your (newer) MySQL version; from what I can find by searching it doesn't like that we're allowing 255 chars for a varchar which is a primary index; could you try opening install/createtable.php and find:
REGISTRATION_FIELD varchar(255) not null primary key,
And replace that with:
REGISTRATION_FIELD varchar(100) not null primary key,
So we can see if it will allow the index length; these values haven't changed in eons, and we're not entirely sure your individual settings on your SQL server.