def METHOD_NAME():
    if context.is_offline_mode():
        raise Exception('This upgrade is only possible in online mode')
    _make_names_unique()
    op.drop_index('ix_room_attributes_name', table_name='room_attributes', schema='roombooking')
    op.drop_constraint('uq_room_attributes_name_location_id', 'room_attributes', schema='roombooking')
    op.create_index(None, 'room_attributes', ['name'], unique=True, schema='roombooking')
    op.drop_column('room_attributes', 'location_id', schema='roombooking')
    op.drop_column('room_attributes', 'type', schema='roombooking')