"""company_fields

Revision ID: e52adcaec0d8
Revises: 9238020169c5
Create Date: 2021-02-19 15:44:40.598352

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'e52adcaec0d8'
down_revision = '9238020169c5'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_company', sa.Column('account', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('address', sa.String(length=4096), nullable=True))
    op.add_column('cmf_company', sa.Column('bank_bik', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('bank_inn', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('birth_date', sa.DATE(), nullable=True))
    op.add_column('cmf_company', sa.Column('city', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('correspondent_account', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('email1', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('email2', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('inn', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('kpp', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('manager', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('ogrn', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('passport', sa.TEXT(), nullable=True))
    op.add_column('cmf_company', sa.Column('phone1', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('phone2', sa.String(length=32), nullable=True))
    op.add_column('cmf_company', sa.Column('signer', sa.String(length=256), nullable=True))
    op.add_column('cmf_company', sa.Column('type', sa.String(length=32), nullable=True))
    op.create_index(op.f('ix_cmf_company_account'), 'cmf_company', ['account'], unique=False)
    op.create_index(op.f('ix_cmf_company_address'), 'cmf_company', ['address'], unique=False)
    op.create_index(op.f('ix_cmf_company_bank_bik'), 'cmf_company', ['bank_bik'], unique=False)
    op.create_index(op.f('ix_cmf_company_bank_inn'), 'cmf_company', ['bank_inn'], unique=False)
    op.create_index(op.f('ix_cmf_company_birth_date'), 'cmf_company', ['birth_date'], unique=False)
    op.create_index(op.f('ix_cmf_company_city'), 'cmf_company', ['city'], unique=False)
    op.create_index(op.f('ix_cmf_company_correspondent_account'), 'cmf_company', ['correspondent_account'], unique=False)
    op.create_index(op.f('ix_cmf_company_email1'), 'cmf_company', ['email1'], unique=False)
    op.create_index(op.f('ix_cmf_company_email2'), 'cmf_company', ['email2'], unique=False)
    op.create_index(op.f('ix_cmf_company_inn'), 'cmf_company', ['inn'], unique=False)
    op.create_index(op.f('ix_cmf_company_kpp'), 'cmf_company', ['kpp'], unique=False)
    op.create_index(op.f('ix_cmf_company_manager'), 'cmf_company', ['manager'], unique=False)
    op.create_index(op.f('ix_cmf_company_ogrn'), 'cmf_company', ['ogrn'], unique=False)
    op.create_index(op.f('ix_cmf_company_passport'), 'cmf_company', ['passport'], unique=False)
    op.create_index(op.f('ix_cmf_company_phone1'), 'cmf_company', ['phone1'], unique=False)
    op.create_index(op.f('ix_cmf_company_phone2'), 'cmf_company', ['phone2'], unique=False)
    op.create_index(op.f('ix_cmf_company_signer'), 'cmf_company', ['signer'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_company_signer'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_phone2'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_phone1'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_passport'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_ogrn'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_manager'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_kpp'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_inn'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_email2'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_email1'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_correspondent_account'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_city'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_birth_date'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_bank_inn'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_bank_bik'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_address'), table_name='cmf_company')
    op.drop_index(op.f('ix_cmf_company_account'), table_name='cmf_company')
    op.drop_column('cmf_company', 'type')
    op.drop_column('cmf_company', 'signer')
    op.drop_column('cmf_company', 'phone2')
    op.drop_column('cmf_company', 'phone1')
    op.drop_column('cmf_company', 'passport')
    op.drop_column('cmf_company', 'ogrn')
    op.drop_column('cmf_company', 'manager')
    op.drop_column('cmf_company', 'kpp')
    op.drop_column('cmf_company', 'inn')
    op.drop_column('cmf_company', 'email2')
    op.drop_column('cmf_company', 'email1')
    op.drop_column('cmf_company', 'correspondent_account')
    op.drop_column('cmf_company', 'city')
    op.drop_column('cmf_company', 'birth_date')
    op.drop_column('cmf_company', 'bank_inn')
    op.drop_column('cmf_company', 'bank_bik')
    op.drop_column('cmf_company', 'address')
    op.drop_column('cmf_company', 'account')
    # ### end Alembic commands ###