Comment 5 for bug 2053211

Reviewed: https://review.opendev.org/c/openstack/manila/+/909555
Committed: https://opendev.org/openstack/manila/commit/695df5993e76b12bbb50bb84c4dbf8db234d3054
Submitter: "Zuul (22348)"
Branch: stable/2023.2

commit 695df5993e76b12bbb50bb84c4dbf8db234d3054
Author: Takashi Kajinami <email address hidden>
Date: Sun Feb 11 16:50:31 2024 +0900

    db: Fix charset updates in migrations

    We are failing py311 jobs with our migration checks;
    and the reason is that we have some 'implied' sql defaults
    that might be inconsistent with the server versions - one
    of them is the charset. We recently [1] fixed a bunch of
    un-annotated tables with explicit charset declarations.
    This is a continuation of that attempt.

    Unfortunately, we can't change history. On existing
    deployments, changes to these migrations will be ignored,
    and must be done manually if there are any inconsistencies
    to be fixed.

    While we're at it, this commit also cleans up separate
    steps to set the charset and engine to pre-created
    tables.

    [1] I7cd6fa0cc8e054af112493746e753fef2024000f
    Closes-Bug: #2053211
    Change-Id: I16345f63a279549e81cbde7b60fed29521d48a02
    Signed-off-by: Goutham Pacha Ravi <email address hidden>
    (cherry picked from commit c8ed5b05e9e8644d7418f8c5c46bee64a9835500)