def METHOD_NAME():
    op.drop_index(dbtableprefix + 'ix_attachments_filename', table_name='attachments')
    op.drop_index(dbtableprefix + 'ix_attachments_key', table_name='attachments')
    op.drop_index(dbtableprefix + 'ix_chatlog_filename', table_name='chatlog')
    op.drop_index(dbtableprefix + 'ix_chatlog_key', table_name='chatlog')
    op.drop_index(dbtableprefix + 'ix_machinelearning_key', table_name='machinelearning')
    op.drop_index(dbtableprefix + 'ix_objectstorage_key', table_name='objectstorage')
    op.drop_index(dbtableprefix + 'ix_role_name', table_name='role')
    op.drop_index(dbtableprefix + 'ix_shortener_filename', table_name='shortener')
    op.drop_index(dbtableprefix + 'ix_shortener_key', table_name='shortener')
    op.drop_index(dbtableprefix + 'ix_speaklist_filename', table_name='speaklist')
    op.drop_index(dbtableprefix + 'ix_speaklist_key', table_name='speaklist')
    op.drop_index(dbtableprefix + 'ix_uploads_filename', table_name='uploads')
    op.drop_index(dbtableprefix + 'ix_uploads_key', table_name='uploads')
    op.drop_index(dbtableprefix + 'ix_user_auth_user_id', table_name='user_auth')
    op.drop_index(dbtableprefix + 'ix_user_email', table_name='user')
    op.drop_index(dbtableprefix + 'ix_user_roles_role_id', table_name='user_roles')
    op.drop_index(dbtableprefix + 'ix_user_roles_user_id', table_name='user_roles')
    op.drop_index(dbtableprefix + 'ix_userdict_filename', table_name='userdict')
    op.drop_index(dbtableprefix + 'ix_userdict_key', table_name='userdict')
    op.drop_index(dbtableprefix + 'ix_userdictkeys_filename', table_name='userdictkeys')
    op.drop_index(dbtableprefix + 'ix_userdictkeys_key', table_name='userdictkeys')
    op.drop_index(dbtableprefix + 'ix_userdictkeys_temp_user_id', table_name='userdictkeys')
    op.drop_index(dbtableprefix + 'ix_userdictkeys_user_id', table_name='userdictkeys')
    op.drop_index(dbtableprefix + 'ix_userdict_key_filename', table_name='userdict')
    op.drop_index(dbtableprefix + 'ix_userdictkeys_key_filename', table_name='userdictkeys')