"""empty message

Revision ID: e2086f78ba0e
Revises: 88e485ebc3ab
Create Date: 2020-09-15 13:27:57.039267

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'e2086f78ba0e'
down_revision = '88e485ebc3ab'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_index(op.f('ix_cmf_event_cmf_modified_at'), 'cmf_event', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_event_event_alarm_date'), 'cmf_event', ['event_alarm_date'], unique=False)
    op.create_index(op.f('ix_cmf_event_event_status'), 'cmf_event', ['event_status'], unique=False)
    op.create_index(op.f('ix_cmf_event_msg_alarm_date'), 'cmf_event', ['msg_alarm_date'], unique=False)
    op.create_index(op.f('ix_cmf_event_msg_type'), 'cmf_event', ['msg_type'], unique=False)
    op.create_index(op.f('ix_cmf_event_unread_cnt'), 'cmf_event', ['unread_cnt'], unique=False)
    op.create_index(op.f('ix_cmf_event_event_person_id'), 'cmf_event', ['event_person_id'], unique=False)
    op.create_index(op.f('ix_cmf_event_object_id'), 'cmf_event', ['object_id'], unique=False)
    op.create_index(op.f('ix_cmf_event_view_object_id'), 'cmf_event', ['view_object_id'], unique=False)
    op.add_column('cmf_project', sa.Column('orderno', sa.Integer(), nullable=True))
    op.create_index(op.f('ix_cmf_project_orderno'), 'cmf_project', ['orderno'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_project_orderno'), table_name='cmf_project')
    op.drop_column('cmf_project', 'orderno')
    op.drop_index(op.f('ix_cmf_event_unread_cnt'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_msg_type'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_msg_alarm_date'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_event_status'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_event_alarm_date'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_cmf_modified_at'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_event_person_id'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_object_id'), table_name='cmf_event')
    op.drop_index(op.f('ix_cmf_event_view_object_id'), table_name='cmf_event')
    # ### end Alembic commands ###