Failure to update MySQL database from 0.7 - text column can't have default value

[Jack!]

MySQL (version 5.5.19) on Windows is throwing an error if I'm trying to upgrade from RC 0.7 to RC 0.7.1 using appropriate part in file mysql.update.sql.

Command that throws an error:

ALTER TABLE `contacts` MODIFY `email` text NOT NULL DEFAULT '';

Error shown:

ERROR 1101 (42000): BLOB/TEXT column 'email' can't have a default value

MySQL 5.5 manual (see ​http://dev.mysql.com/doc/refman/5.5/en/blob.html) says "BLOB and TEXT columns cannot have DEFAULT values."

Next command works though:

ALTER TABLE `contacts` MODIFY `email` text NOT NULL;

but I'm not sure if this meets the RC requirements for the database.

[alec]

Fixed in [3d4a482f].