I updated 2.0-beta12 to 2.0-beta13.

In the Status Report, schema reported one of the tables was missing: formcolumns_ui_fields

Because of some other problems, I did a fresh install of beta13. Same thing, formcolumns_ui_fields was missing.

Schema module suggest following SQL query for that missing table:

CREATE TABLE {formcolumns_ui_fields} (
`form_id` VARCHAR(255) NOT NULL, 
`name` VARCHAR(255) NOT NULL, 
`region` VARCHAR(50) NOT NULL DEFAULT '', 
`weight` INT NOT NULL DEFAULT 0, 
`collapsed` TINYINT NOT NULL DEFAULT 0, 
`hidden` TINYINT NOT NULL DEFAULT 0, 
PRIMARY KEY (form_id, name)
) /*!40100 DEFAULT CHARACTER SET utf8 */;

However, when I try to run this query, phpMyAdmin complains about it:
#1071 - Specified key was too long; max key length is 1000 bytes

Since UTF8 adds extra characters, PRIMARY KEY (form_id, name) becomes larger than 1000 bytes. Thus, it is not created during update or install.

Closest topic I could find about this issue is #1335698: Aegir 'Install' task exhausts memory for 2.0b9 and 2.0b12

One solution is changing default character set to:
/*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci */

I am not sure if this is the right solution though. Any thoughts?