Comment 8 for bug 993663

Reviewed: https://review.openstack.org/7139
Committed: http://github.com/openstack/nova/commit/7b5fdac84b513c6b606848cc353995d6abb9a7c9
Submitter: Jenkins
Branch: master

commit 7b5fdac84b513c6b606848cc353995d6abb9a7c9
Author: Dan Prince <email address hidden>
Date: Fri May 4 17:01:14 2012 -0400

    Create a utf8 version of the dns_domains table.

    The old dns_domains table was encoded in the 'latin1'
    charset and has its primary key length set to 512.
    This is too long to be a valid pkey in a proper 'utf8' encoded
    table and seems to cause a slew of errors like:

    1) Dumping a database with mysqldump and trying to import it fails
    because this table is latin1 but fkeys to utf8 tables (projects).

    2) Trying to alter the old dns_domains table fails with errors
    like:
     mysql> ALTER TABLE dns_domains DROP PRIMARY KEY;
     ERROR 1025 (HY000): Error on rename of './nova/#sql-6cf_855'....

    This patch creates a new migration that re-creates the dns_domains
    table with a shorter 'domain' column which works with the utf8
    charset.

    Fixes LP Bug #993663.

    Change-Id: I2060d39cbdabd20f410ebd501160a04c51641755