"""Check new

Revision ID: 92235b77ea53
Revises: 381fdb66ec27
Create Date: 2017-10-14 02:38:51.007307

"""

# revision identifiers, used by Alembic.
revision = '92235b77ea53'
down_revision = '381fdb66ec27'

from alembic import op
import sqlalchemy as sa


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index('ix_ActiveTranslationMessages_category', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_datetime', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_fmt', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_from_developer', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_key', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_namespace', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_position', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_same_tool', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_taken_from_default', table_name='ActiveTranslationMessages')
    op.drop_index('ix_ActiveTranslationMessages_tool_id', table_name='ActiveTranslationMessages')
    op.drop_index('ix_Apps_composer', table_name='Apps')
    op.drop_index('ix_Apps_creation_date', table_name='Apps')
    op.drop_index('ix_Apps_last_access_date', table_name='Apps')
    op.drop_index('ix_Apps_modification_date', table_name='Apps')
    op.drop_index('ix_Apps_name', table_name='Apps')
    op.drop_index('ix_Apps_owner_id', table_name='Apps')
    op.drop_index('ix_Apps_unique_id', table_name='Apps')
    op.drop_index('ix_GoLabOAuthUsers_display_name', table_name='GoLabOAuthUsers')
    op.drop_index('ix_GoLabOAuthUsers_email', table_name='GoLabOAuthUsers')
    op.drop_index('ix_Languages_language', table_name='Languages')
    op.drop_index('ix_RepositoryApps_adaptable', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_contents_hash', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_downloaded_hash', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_external_id', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_failing', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_failing_since', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_change', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_check', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_download_change', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_processed_contents_hash', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_processed_downloaded_hash', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_last_processed_time', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_name', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_repository', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_translatable', table_name='RepositoryApps')
    op.drop_index('ix_RepositoryApps_url', table_name='RepositoryApps')
    op.drop_index('ix_TranslatedApps_url', table_name='TranslatedApps')
    op.drop_index('ix_TranslationBundles_from_developer', table_name='TranslationBundles')
    op.drop_index('ix_TranslationBundles_language', table_name='TranslationBundles')
    op.drop_index('ix_TranslationBundles_target', table_name='TranslationBundles')
    op.drop_index('ix_TranslationCurrentActiveUsers_last_check', table_name='TranslationCurrentActiveUsers')
    op.drop_index('ix_TranslationExternalSuggestions_engine', table_name='TranslationExternalSuggestions')
    op.drop_index('ix_TranslationExternalSuggestions_human_key', table_name='TranslationExternalSuggestions')
    op.drop_index('ix_TranslationExternalSuggestions_human_key_hash', table_name='TranslationExternalSuggestions')
    op.drop_index('ix_TranslationExternalSuggestions_language', table_name='TranslationExternalSuggestions')
    op.drop_index('ix_TranslationExternalSuggestions_origin_language', table_name='TranslationExternalSuggestions')
    op.drop_index('ix_TranslationKeySuggestions_key', table_name='TranslationKeySuggestions')
    op.drop_index('ix_TranslationKeySuggestions_language', table_name='TranslationKeySuggestions')
    op.drop_index('ix_TranslationKeySuggestions_target', table_name='TranslationKeySuggestions')
    op.drop_index('ix_TranslationMessageHistory_category', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_datetime', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_fmt', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_from_developer', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_key', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_namespace', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_parent_translation_id', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_position', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_same_tool', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_taken_from_default', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationMessageHistory_tool_id', table_name='TranslationMessageHistory')
    op.drop_index('ix_TranslationNotificationRecipients_created', table_name='TranslationNotificationRecipients')
    op.drop_index('ix_TranslationNotificationRecipients_email', table_name='TranslationNotificationRecipients')
    op.drop_index('ix_TranslationSubscriptions_last_check', table_name='TranslationSubscriptions')
    op.drop_index('ix_TranslationSubscriptions_mechanism', table_name='TranslationSubscriptions')
    op.drop_index('ix_TranslationSyncLogs_end_datetime', table_name='TranslationSyncLogs')
    op.drop_index('ix_TranslationSyncLogs_start_datetime', table_name='TranslationSyncLogs')
    op.drop_index('ix_TranslationUrls_automatic', table_name='TranslationUrls')
    op.drop_index('ix_TranslationUrls_url', table_name='TranslationUrls')
    op.drop_index('ix_TranslationValueSuggestions_human_key', table_name='TranslationValueSuggestions')
    op.drop_index('ix_TranslationValueSuggestions_language', table_name='TranslationValueSuggestions')
    op.drop_index('ix_TranslationValueSuggestions_target', table_name='TranslationValueSuggestions')
    op.drop_index('ix_Users_creation_date', table_name='Users')
    op.drop_index('ix_Users_last_access_date', table_name='Users')

    op.create_index(op.f('ix_ActiveTranslationMessages_category'), 'ActiveTranslationMessages', ['category'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_datetime'), 'ActiveTranslationMessages', ['datetime'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_fmt'), 'ActiveTranslationMessages', ['fmt'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_from_developer'), 'ActiveTranslationMessages', ['from_developer'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_key'), 'ActiveTranslationMessages', ['key'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_namespace'), 'ActiveTranslationMessages', ['namespace'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_position'), 'ActiveTranslationMessages', ['position'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_same_tool'), 'ActiveTranslationMessages', ['same_tool'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_taken_from_default'), 'ActiveTranslationMessages', ['taken_from_default'], unique=False)
    op.create_index(op.f('ix_ActiveTranslationMessages_tool_id'), 'ActiveTranslationMessages', ['tool_id'], unique=False)
    op.create_index(op.f('ix_Apps_composer'), 'Apps', ['composer'], unique=False)
    op.create_index(op.f('ix_Apps_creation_date'), 'Apps', ['creation_date'], unique=False)
    op.create_index(op.f('ix_Apps_last_access_date'), 'Apps', ['last_access_date'], unique=False)
    op.create_index(op.f('ix_Apps_modification_date'), 'Apps', ['modification_date'], unique=False)
    op.create_index(op.f('ix_Apps_name'), 'Apps', ['name'], unique=False)
    op.create_index(op.f('ix_Apps_owner_id'), 'Apps', ['owner_id'], unique=False)
    op.create_index(op.f('ix_Apps_unique_id'), 'Apps', ['unique_id'], unique=True)
    op.create_index(op.f('ix_GoLabOAuthUsers_display_name'), 'GoLabOAuthUsers', ['display_name'], unique=False)
    op.create_index(op.f('ix_GoLabOAuthUsers_email'), 'GoLabOAuthUsers', ['email'], unique=True)
    op.create_index(op.f('ix_Languages_language'), 'Languages', ['language'], unique=True)
    op.create_index(op.f('ix_RepositoryApps_adaptable'), 'RepositoryApps', ['adaptable'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_contents_hash'), 'RepositoryApps', ['contents_hash'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_downloaded_hash'), 'RepositoryApps', ['downloaded_hash'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_external_id'), 'RepositoryApps', ['external_id'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_failing_since'), 'RepositoryApps', ['failing_since'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_failing'), 'RepositoryApps', ['failing'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_change'), 'RepositoryApps', ['last_change'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_check'), 'RepositoryApps', ['last_check'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_download_change'), 'RepositoryApps', ['last_download_change'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_processed_contents_hash'), 'RepositoryApps', ['last_processed_contents_hash'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_processed_downloaded_hash'), 'RepositoryApps', ['last_processed_downloaded_hash'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_last_processed_time'), 'RepositoryApps', ['last_processed_time'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_name'), 'RepositoryApps', ['name'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_repository'), 'RepositoryApps', ['repository'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_translatable'), 'RepositoryApps', ['translatable'], unique=False)
    op.create_index(op.f('ix_RepositoryApps_url'), 'RepositoryApps', ['url'], unique=False)
    op.create_index(op.f('ix_TranslatedApps_url'), 'TranslatedApps', ['url'], unique=True)
    op.create_index(op.f('ix_TranslationBundles_from_developer'), 'TranslationBundles', ['from_developer'], unique=False)
    op.create_index(op.f('ix_TranslationBundles_language'), 'TranslationBundles', ['language'], unique=False)
    op.create_index(op.f('ix_TranslationBundles_target'), 'TranslationBundles', ['target'], unique=False)
    op.create_index(op.f('ix_TranslationCurrentActiveUsers_last_check'), 'TranslationCurrentActiveUsers', ['last_check'], unique=False)
    op.create_index(op.f('ix_TranslationExternalSuggestions_engine'), 'TranslationExternalSuggestions', ['engine'], unique=False)
    op.create_index(op.f('ix_TranslationExternalSuggestions_human_key_hash'), 'TranslationExternalSuggestions', ['human_key_hash'], unique=False)
    op.create_index(op.f('ix_TranslationExternalSuggestions_human_key'), 'TranslationExternalSuggestions', ['human_key'], unique=False)
    op.create_index(op.f('ix_TranslationExternalSuggestions_language'), 'TranslationExternalSuggestions', ['language'], unique=False)
    op.create_index(op.f('ix_TranslationExternalSuggestions_origin_language'), 'TranslationExternalSuggestions', ['origin_language'], unique=False)
    op.create_index(op.f('ix_TranslationKeySuggestions_key'), 'TranslationKeySuggestions', ['key'], unique=False)
    op.create_index(op.f('ix_TranslationKeySuggestions_language'), 'TranslationKeySuggestions', ['language'], unique=False)
    op.create_index(op.f('ix_TranslationKeySuggestions_target'), 'TranslationKeySuggestions', ['target'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_category'), 'TranslationMessageHistory', ['category'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_datetime'), 'TranslationMessageHistory', ['datetime'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_fmt'), 'TranslationMessageHistory', ['fmt'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_from_developer'), 'TranslationMessageHistory', ['from_developer'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_key'), 'TranslationMessageHistory', ['key'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_namespace'), 'TranslationMessageHistory', ['namespace'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_parent_translation_id'), 'TranslationMessageHistory', ['parent_translation_id'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_position'), 'TranslationMessageHistory', ['position'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_same_tool'), 'TranslationMessageHistory', ['same_tool'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_taken_from_default'), 'TranslationMessageHistory', ['taken_from_default'], unique=False)
    op.create_index(op.f('ix_TranslationMessageHistory_tool_id'), 'TranslationMessageHistory', ['tool_id'], unique=False)
    op.create_index(op.f('ix_TranslationNotificationRecipients_created'), 'TranslationNotificationRecipients', ['created'], unique=False)
    op.create_index(op.f('ix_TranslationNotificationRecipients_email'), 'TranslationNotificationRecipients', ['email'], unique=True)
    op.create_index(op.f('ix_TranslationSubscriptions_last_check'), 'TranslationSubscriptions', ['last_check'], unique=False)
    op.create_index(op.f('ix_TranslationSubscriptions_mechanism'), 'TranslationSubscriptions', ['mechanism'], unique=False)
    op.create_index(op.f('ix_TranslationSyncLogs_end_datetime'), 'TranslationSyncLogs', ['end_datetime'], unique=False)
    op.create_index(op.f('ix_TranslationSyncLogs_start_datetime'), 'TranslationSyncLogs', ['start_datetime'], unique=False)
    op.create_index(op.f('ix_TranslationUrls_automatic'), 'TranslationUrls', ['automatic'], unique=False)
    op.create_index(op.f('ix_TranslationUrls_url'), 'TranslationUrls', ['url'], unique=True)
    op.create_index(op.f('ix_TranslationValueSuggestions_human_key'), 'TranslationValueSuggestions', ['human_key'], unique=False)
    op.create_index(op.f('ix_TranslationValueSuggestions_language'), 'TranslationValueSuggestions', ['language'], unique=False)
    op.create_index(op.f('ix_TranslationValueSuggestions_target'), 'TranslationValueSuggestions', ['target'], unique=False)
    op.create_index(op.f('ix_Users_creation_date'), 'Users', ['creation_date'], unique=False)
    op.create_index(op.f('ix_Users_last_access_date'), 'Users', ['last_access_date'], unique=False)

#     op.create_unique_constraint(None, 'ActiveTranslationMessages', ['bundle_id', 'key'])
#     op.create_unique_constraint(None, 'RepositoryApp2languages', ['repository_app_id', 'language_id'])
#     op.create_unique_constraint(None, 'TranslationBundles', ['translation_url_id', 'language', 'target'])

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_Users_last_access_date'), table_name='Users')
    op.drop_index(op.f('ix_Users_creation_date'), table_name='Users')

    op.drop_index(op.f('ix_TranslationValueSuggestions_target'), table_name='TranslationValueSuggestions')
    op.drop_index(op.f('ix_TranslationValueSuggestions_language'), table_name='TranslationValueSuggestions')
    op.drop_index(op.f('ix_TranslationValueSuggestions_human_key'), table_name='TranslationValueSuggestions')
    op.drop_index(op.f('ix_TranslationUrls_url'), table_name='TranslationUrls')
    op.drop_index(op.f('ix_TranslationUrls_automatic'), table_name='TranslationUrls')
    op.drop_index(op.f('ix_TranslationSyncLogs_start_datetime'), table_name='TranslationSyncLogs')
    op.drop_index(op.f('ix_TranslationSyncLogs_end_datetime'), table_name='TranslationSyncLogs')
    op.drop_index(op.f('ix_TranslationSubscriptions_mechanism'), table_name='TranslationSubscriptions')
    op.drop_index(op.f('ix_TranslationSubscriptions_last_check'), table_name='TranslationSubscriptions')
    op.drop_index(op.f('ix_TranslationNotificationRecipients_email'), table_name='TranslationNotificationRecipients')
    op.drop_index(op.f('ix_TranslationNotificationRecipients_created'), table_name='TranslationNotificationRecipients')
    op.drop_index(op.f('ix_TranslationMessageHistory_tool_id'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_taken_from_default'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_same_tool'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_position'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_parent_translation_id'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_namespace'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_key'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_from_developer'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_fmt'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_datetime'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationMessageHistory_category'), table_name='TranslationMessageHistory')
    op.drop_index(op.f('ix_TranslationKeySuggestions_target'), table_name='TranslationKeySuggestions')
    op.drop_index(op.f('ix_TranslationKeySuggestions_language'), table_name='TranslationKeySuggestions')
    op.drop_index(op.f('ix_TranslationKeySuggestions_key'), table_name='TranslationKeySuggestions')
    op.drop_index(op.f('ix_TranslationExternalSuggestions_origin_language'), table_name='TranslationExternalSuggestions')
    op.drop_index(op.f('ix_TranslationExternalSuggestions_language'), table_name='TranslationExternalSuggestions')
    op.drop_index(op.f('ix_TranslationExternalSuggestions_human_key'), table_name='TranslationExternalSuggestions')
    op.drop_index(op.f('ix_TranslationExternalSuggestions_human_key_hash'), table_name='TranslationExternalSuggestions')
    op.drop_index(op.f('ix_TranslationExternalSuggestions_engine'), table_name='TranslationExternalSuggestions')
    op.drop_index(op.f('ix_TranslationBundles_target'), table_name='TranslationBundles')
    op.drop_index(op.f('ix_TranslationBundles_language'), table_name='TranslationBundles')
    op.drop_index(op.f('ix_TranslationBundles_from_developer'), table_name='TranslationBundles')
    op.drop_index(op.f('ix_TranslationCurrentActiveUsers_last_check'), table_name='TranslationCurrentActiveUsers')
#    op.drop_constraint(None, 'TranslationBundles', type_='unique')

    op.drop_index(op.f('ix_RepositoryApps_url'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_translatable'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_repository'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_name'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_processed_time'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_processed_downloaded_hash'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_processed_contents_hash'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_download_change'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_check'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_last_change'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_failing'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_failing_since'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_external_id'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_downloaded_hash'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_contents_hash'), table_name='RepositoryApps')
    op.drop_index(op.f('ix_RepositoryApps_adaptable'), table_name='RepositoryApps')
#    op.drop_constraint(None, 'RepositoryApp2languages', type_='unique')

    op.drop_index(op.f('ix_TranslatedApps_url'), table_name='TranslatedApps')
    op.drop_index(op.f('ix_Languages_language'), table_name='Languages')
    op.drop_index(op.f('ix_GoLabOAuthUsers_email'), table_name='GoLabOAuthUsers')
    op.drop_index(op.f('ix_GoLabOAuthUsers_display_name'), table_name='GoLabOAuthUsers')
    op.drop_index(op.f('ix_Apps_unique_id'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_owner_id'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_name'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_modification_date'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_last_access_date'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_creation_date'), table_name='Apps')
    op.drop_index(op.f('ix_Apps_composer'), table_name='Apps')
#    op.drop_constraint(None, 'ActiveTranslationMessages', type_='unique')

    op.drop_index(op.f('ix_ActiveTranslationMessages_tool_id'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_taken_from_default'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_same_tool'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_position'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_namespace'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_key'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_from_developer'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_fmt'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_datetime'), table_name='ActiveTranslationMessages')
    op.drop_index(op.f('ix_ActiveTranslationMessages_category'), table_name='ActiveTranslationMessages')

    op.create_index('ix_Users_last_access_date', 'Users', ['last_access_date'], unique=False)
    op.create_index('ix_Users_creation_date', 'Users', ['creation_date'], unique=False)
    op.create_index('ix_TranslationValueSuggestions_target', 'TranslationValueSuggestions', ['target'], unique=False)
    op.create_index('ix_TranslationValueSuggestions_language', 'TranslationValueSuggestions', ['language'], unique=False)
    op.create_index('ix_TranslationValueSuggestions_human_key', 'TranslationValueSuggestions', ['human_key'], unique=False)
    op.create_index('ix_TranslationUrls_url', 'TranslationUrls', ['url'], unique=True)
    op.create_index('ix_TranslationUrls_automatic', 'TranslationUrls', ['automatic'], unique=False)

    op.create_index('ix_TranslationSyncLogs_start_datetime', 'TranslationSyncLogs', ['start_datetime'], unique=False)
    op.create_index('ix_TranslationSyncLogs_end_datetime', 'TranslationSyncLogs', ['end_datetime'], unique=False)

    op.create_index('ix_TranslationSubscriptions_mechanism', 'TranslationSubscriptions', ['mechanism'], unique=False)
    op.create_index('ix_TranslationSubscriptions_last_check', 'TranslationSubscriptions', ['last_check'], unique=False)

    op.create_index('ix_TranslationNotificationRecipients_email', 'TranslationNotificationRecipients', ['email'], unique=True)
    op.create_index('ix_TranslationNotificationRecipients_created', 'TranslationNotificationRecipients', ['created'], unique=False)

    op.create_index('ix_TranslationMessageHistory_tool_id', 'TranslationMessageHistory', ['tool_id'], unique=False)
    op.create_index('ix_TranslationMessageHistory_taken_from_default', 'TranslationMessageHistory', ['taken_from_default'], unique=False)
    op.create_index('ix_TranslationMessageHistory_same_tool', 'TranslationMessageHistory', ['same_tool'], unique=False)
    op.create_index('ix_TranslationMessageHistory_position', 'TranslationMessageHistory', ['position'], unique=False)
    op.create_index('ix_TranslationMessageHistory_parent_translation_id', 'TranslationMessageHistory', ['parent_translation_id'], unique=False)
    op.create_index('ix_TranslationMessageHistory_namespace', 'TranslationMessageHistory', ['namespace'], unique=False)
    op.create_index('ix_TranslationMessageHistory_key', 'TranslationMessageHistory', ['key'], unique=False)
    op.create_index('ix_TranslationMessageHistory_from_developer', 'TranslationMessageHistory', ['from_developer'], unique=False)
    op.create_index('ix_TranslationMessageHistory_fmt', 'TranslationMessageHistory', ['fmt'], unique=False)
    op.create_index('ix_TranslationMessageHistory_datetime', 'TranslationMessageHistory', ['datetime'], unique=False)
    op.create_index('ix_TranslationMessageHistory_category', 'TranslationMessageHistory', ['category'], unique=False)

    op.create_index('ix_TranslationKeySuggestions_target', 'TranslationKeySuggestions', ['target'], unique=False)
    op.create_index('ix_TranslationKeySuggestions_language', 'TranslationKeySuggestions', ['language'], unique=False)
    op.create_index('ix_TranslationKeySuggestions_key', 'TranslationKeySuggestions', ['key'], unique=False)

    op.create_index('ix_TranslationExternalSuggestions_origin_language', 'TranslationExternalSuggestions', ['origin_language'], unique=False)
    op.create_index('ix_TranslationExternalSuggestions_language', 'TranslationExternalSuggestions', ['language'], unique=False)
    op.create_index('ix_TranslationExternalSuggestions_human_key_hash', 'TranslationExternalSuggestions', ['human_key_hash'], unique=False)
    op.create_index('ix_TranslationExternalSuggestions_human_key', 'TranslationExternalSuggestions', ['human_key'], unique=False)
    op.create_index('ix_TranslationExternalSuggestions_engine', 'TranslationExternalSuggestions', ['engine'], unique=False)

    op.create_index('ix_TranslationCurrentActiveUsers_last_check', 'TranslationCurrentActiveUsers', ['last_check'], unique=False)

    op.create_index('ix_TranslationBundles_target', 'TranslationBundles', ['target'], unique=False)
    op.create_index('ix_TranslationBundles_language', 'TranslationBundles', ['language'], unique=False)
    op.create_index('ix_TranslationBundles_from_developer', 'TranslationBundles', ['from_developer'], unique=False)

    op.create_index('ix_TranslatedApps_url', 'TranslatedApps', ['url'], unique=True)

    op.create_index('ix_RepositoryApps_url', 'RepositoryApps', ['url'], unique=False)
    op.create_index('ix_RepositoryApps_translatable', 'RepositoryApps', ['translatable'], unique=False)
    op.create_index('ix_RepositoryApps_repository', 'RepositoryApps', ['repository'], unique=False)
    op.create_index('ix_RepositoryApps_name', 'RepositoryApps', ['name'], unique=False)
    op.create_index('ix_RepositoryApps_last_processed_time', 'RepositoryApps', ['last_processed_time'], unique=False)
    op.create_index('ix_RepositoryApps_last_processed_downloaded_hash', 'RepositoryApps', ['last_processed_downloaded_hash'], unique=False)
    op.create_index('ix_RepositoryApps_last_processed_contents_hash', 'RepositoryApps', ['last_processed_contents_hash'], unique=False)
    op.create_index('ix_RepositoryApps_last_download_change', 'RepositoryApps', ['last_download_change'], unique=False)
    op.create_index('ix_RepositoryApps_last_check', 'RepositoryApps', ['last_check'], unique=False)
    op.create_index('ix_RepositoryApps_last_change', 'RepositoryApps', ['last_change'], unique=False)
    op.create_index('ix_RepositoryApps_failing_since', 'RepositoryApps', ['failing_since'], unique=False)
    op.create_index('ix_RepositoryApps_failing', 'RepositoryApps', ['failing'], unique=False)
    op.create_index('ix_RepositoryApps_external_id', 'RepositoryApps', ['external_id'], unique=False)
    op.create_index('ix_RepositoryApps_downloaded_hash', 'RepositoryApps', ['downloaded_hash'], unique=False)
    op.create_index('ix_RepositoryApps_contents_hash', 'RepositoryApps', ['contents_hash'], unique=False)
    op.create_index('ix_RepositoryApps_adaptable', 'RepositoryApps', ['adaptable'], unique=False)

    op.create_index('ix_Languages_language', 'Languages', ['language'], unique=True)

    op.create_index('ix_GoLabOAuthUsers_email', 'GoLabOAuthUsers', ['email'], unique=True)
    op.create_index('ix_GoLabOAuthUsers_display_name', 'GoLabOAuthUsers', ['display_name'], unique=False)

    op.create_index('ix_Apps_unique_id', 'Apps', ['unique_id'], unique=True)
    op.create_index('ix_Apps_owner_id', 'Apps', ['owner_id'], unique=False)
    op.create_index('ix_Apps_name', 'Apps', ['name'], unique=False)
    op.create_index('ix_Apps_modification_date', 'Apps', ['modification_date'], unique=False)
    op.create_index('ix_Apps_last_access_date', 'Apps', ['last_access_date'], unique=False)
    op.create_index('ix_Apps_creation_date', 'Apps', ['creation_date'], unique=False)
    op.create_index('ix_Apps_composer', 'Apps', ['composer'], unique=False)

    op.create_index('ix_ActiveTranslationMessages_tool_id', 'ActiveTranslationMessages', ['tool_id'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_taken_from_default', 'ActiveTranslationMessages', ['taken_from_default'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_same_tool', 'ActiveTranslationMessages', ['same_tool'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_position', 'ActiveTranslationMessages', ['position'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_namespace', 'ActiveTranslationMessages', ['namespace'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_key', 'ActiveTranslationMessages', ['key'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_from_developer', 'ActiveTranslationMessages', ['from_developer'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_fmt', 'ActiveTranslationMessages', ['fmt'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_datetime', 'ActiveTranslationMessages', ['datetime'], unique=False)
    op.create_index('ix_ActiveTranslationMessages_category', 'ActiveTranslationMessages', ['category'], unique=False)

    # ### end Alembic commands ###
