SQL errors when updating to latest version

Hi,

After updating to the latest version, I have multiple occurrence of errors in the PHP error log like:

Specified key was too long; max key length is 1000 bytes
ALTER TABLE wp_mec_users ADD PRIMARY KEY (id), ADD UNIQUE KEY email (email);

Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE wp_mec_users MODIFY id int NOT NULL AUTO_INCREMENT;

Multiple primary key defined
ALTER TABLE wp_mec_occurrences ADD PRIMARY KEY (id), ADD KEY post_id (post_id), ADD KEY occurrence (occurrence);

What do you suggest?

Thanks