"""CmfPerson add indexes

Revision ID: 9ea98cfdd74b
Revises: d8804eebd48c
Create Date: 2022-10-30 18:43:53.359692

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '9ea98cfdd74b'
down_revision = 'd8804eebd48c'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_index(op.f('ix_cmf_person_birthday'), 'cmf_person', ['birthday'], unique=False)
    op.create_index(op.f('ix_cmf_person_does_not_work'), 'cmf_person', ['does_not_work'], unique=False)
    op.create_index(op.f('ix_cmf_person_email'), 'cmf_person', ['email'], unique=False)
    op.create_index(op.f('ix_cmf_person_email_2'), 'cmf_person', ['email_2'], unique=False)
    op.create_index(op.f('ix_cmf_person_first_name'), 'cmf_person', ['first_name'], unique=False)
    op.create_index(op.f('ix_cmf_person_has_penalty'), 'cmf_person', ['has_penalty'], unique=False)
    op.create_index(op.f('ix_cmf_person_ip_address'), 'cmf_person', ['ip_address'], unique=False)
    op.create_index(op.f('ix_cmf_person_last_name'), 'cmf_person', ['last_name'], unique=False)
    op.create_index(op.f('ix_cmf_person_no_staff_control'), 'cmf_person', ['no_staff_control'], unique=False)
    op.create_index(op.f('ix_cmf_person_on_vacation'), 'cmf_person', ['on_vacation'], unique=False)
    op.create_index(op.f('ix_cmf_person_phone'), 'cmf_person', ['phone'], unique=False)
    op.create_index(op.f('ix_cmf_person_phone_2'), 'cmf_person', ['phone_2'], unique=False)
    op.create_index(op.f('ix_cmf_person_phone_assistant'), 'cmf_person', ['phone_assistant'], unique=False)
    op.create_index(op.f('ix_cmf_person_phone_internal'), 'cmf_person', ['phone_internal'], unique=False)
    op.create_index(op.f('ix_cmf_person_phone_mobile'), 'cmf_person', ['phone_mobile'], unique=False)
    op.create_index(op.f('ix_cmf_person_second_name'), 'cmf_person', ['second_name'], unique=False)
    op.create_index(op.f('ix_cmf_person_user_local'), 'cmf_person', ['user_local'], unique=False)
    op.create_index(op.f('ix_cmf_person_vacation_end'), 'cmf_person', ['vacation_end'], unique=False)
    op.create_index(op.f('ix_cmf_person_vacation_start'), 'cmf_person', ['vacation_start'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_person_vacation_start'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_vacation_end'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_user_local'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_second_name'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_phone_mobile'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_phone_internal'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_phone_assistant'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_phone_2'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_phone'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_on_vacation'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_no_staff_control'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_last_name'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_ip_address'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_has_penalty'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_first_name'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_email_2'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_email'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_does_not_work'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_birthday'), table_name='cmf_person')
    # ### end Alembic commands ###