Comment 6 for bug 1233861

Reviewed: https://review.openstack.org/51975
Committed: http://github.com/openstack/cinder/commit/5e489f475f4fe0529280f419b4708aa22c13ad39
Submitter: Jenkins
Branch: milestone-proposed

commit 5e489f475f4fe0529280f419b4708aa22c13ad39
Author: John Griffith <email address hidden>
Date: Tue Oct 15 13:57:48 2013 -0600

    FK lookup failures during migration

    There are a couple of cases where migrations have failed
    upgrading from Grizzly to Havana, this seems to be isolated
    to a couple of migrations so far and the error message is a
    failure to lookup/associate the volume-id FK dependency.

    It appears that this is caused by not setting the charset
    in the migration, so the result is that the initial db setup
    uses utf8 and the migrations are using the default latin1.

    This patch goes through all of the migrations in Havana that
    specify InnoDB and explicitly sets the charset to utf8 to match
    the volumes table (and the other original tables).

    Change-Id: I43b219ff5e4eea10a7391ad65ef68a80b7460370
    Closes-Bug: #1233861
    (cherry picked from commit 645a84f990c90e28548cf35b4b5f242eb0e0c286)