def METHOD_NAME():
    op.drop_index(
        "ix_privacyexperiencehistory_experience_config_history_id",
        table_name="privacyexperiencehistory",
    )
    op.drop_index(
        "ix_privacyexperiencehistory_experience_config_id",
        table_name="privacyexperiencehistory",
    )
    op.drop_index(
        "ix_privacyexperiencehistory_id", table_name="privacyexperiencehistory"
    )
    op.drop_index(
        "ix_privacyexperiencehistory_privacy_experience_id",
        table_name="privacyexperiencehistory",
    )
    op.drop_index(
        "ix_privacyexperiencehistory_region", table_name="privacyexperiencehistory"
    )
    op.drop_constraint(
        "privacypreferencehistory_privacy_experience_history_id_fkey",
        "privacypreferencehistory",
        type_="foreignkey",
    )
    op.drop_table("privacyexperiencehistory")
    op.drop_index(
        "ix_privacyexperience_experience_config_history_id",
        table_name="privacyexperience",
    )
    op.drop_constraint(
        "privacyexperience_experience_config_history_id_fkey",
        "privacyexperience",
        type_="foreignkey",
    )
    op.drop_column("privacyexperience", "disabled")
    op.drop_column("privacyexperience", "version")
    op.drop_column("privacyexperience", "experience_config_history_id")
    op.drop_index(
        "ix_privacypreferencehistory_privacy_experience_history_id",
        table_name="privacypreferencehistory",
    )
    op.drop_column("privacypreferencehistory", "privacy_experience_history_id")
    op.add_column(
        "privacypreferencehistory",
        sa.Column("privacy_experience_id", sa.String(), nullable=True),
    )
    op.create_index(
        op.f("ix_privacypreferencehistory_privacy_experience_id"),
        "privacypreferencehistory",
        ["privacy_experience_id"],
        unique=False,
    )
    op.create_foreign_key(
        "privacypreferencehistory_privacy_experience_id_fkey",
        "privacypreferencehistory",
        "privacyexperience",
        ["privacy_experience_id"],
        ["id"],
    )
    # ### end Alembic commands ###