def METHOD_NAME():
    op.drop_constraint('membership_membership_type_code_fkey', 'membership', type_='foreignkey')
    op.drop_constraint('invitation_membership_membership_type_code_fkey', 'invitation_membership', type_='foreignkey')
    op.drop_column('membership_type', 'display_name')
    op.drop_column('membership_type', 'display_order')
    op.execute(
        "UPDATE membership_type SET code = 'MEMBER',label='can add businesses, and file for a business.' where code= 'USER'")
    op.execute(
        "UPDATE membership_type SET code = 'OWNER',label='can add/remove team members and businesses, and file for a business.' where code = 'ADMIN'")
    op.execute(
        "UPDATE membership_type SET code = 'ADMIN',label='can add/remove team members, add businesses, and file for a business.'  where code = 'COORDINATOR'")
    op.execute("UPDATE membership SET membership_type_code = 'MEMBER' where membership_type_code= 'USER'")
    op.execute("UPDATE membership SET membership_type_code = 'OWNER' where membership_type_code= 'ADMIN'")
    op.execute("UPDATE membership SET membership_type_code = 'ADMIN' where membership_type_code= 'COORDINATOR'")
    op.execute("UPDATE invitation_membership SET membership_type_code = 'MEMBER' where membership_type_code= 'USER'")
    op.execute("UPDATE invitation_membership SET membership_type_code = 'OWNER' where membership_type_code= 'ADMIN'")
    op.execute(
        "UPDATE invitation_membership SET membership_type_code = 'ADMIN' where membership_type_code= 'COORDINATOR'")
    op.create_foreign_key('membership_membership_type_code_fkey', 'membership', 'membership_type',
                          ['membership_type_code'], ['code'])
    op.create_foreign_key('invitation_membership_membership_type_code_fkey', 'invitation_membership', 'membership_type',
                          ['membership_type_code'], ['code'])