def METHOD_NAME():
    op.drop_column('job', 'visibility')
    op.drop_index('ix_shift_job_id', table_name='shift')
    op.drop_index('ix_shift_attendee_id', table_name='shift')
    op.drop_index('ix_job_required_role_job_id', table_name='job_required_role')
    op.drop_index('ix_job_required_role_dept_role_id', table_name='job_required_role')
    op.drop_index('ix_job_department_id', table_name='job')
    op.drop_index('ix_dept_role_department_id', table_name='dept_role')
    op.drop_index('ix_dept_membership_request_department_id', table_name='dept_membership_request')
    op.drop_index('ix_dept_membership_request_attendee_id', table_name='dept_membership_request')
    op.drop_index('ix_dept_membership_dept_role_dept_role_id', table_name='dept_membership_dept_role')
    op.drop_index('ix_dept_membership_dept_role_dept_membership_id', table_name='dept_membership_dept_role')
    op.drop_index('ix_dept_membership_department_id', table_name='dept_membership')
    op.drop_index('ix_dept_membership_attendee_id', table_name='dept_membership')