"""add mixin to activity model

Revision ID: 0867f18fc4a3
Revises: 2fad01ea7cd0
Create Date: 2019-07-09 11:12:33.961001

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '0867f18fc4a3'
down_revision = '2fad01ea7cd0'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('Activity', sa.Column('create_date', sa.DateTime(), nullable=True))
    op.add_column('Activity', sa.Column('edit_date', sa.DateTime(), nullable=True))
    op.add_column('Activity', sa.Column('edit_user_id', sa.String(), nullable=True))
    op.alter_column('Activity', 'create_user_id', existing_type=sa.VARCHAR(), nullable=True)
    op.create_foreign_key(op.f('fk_Activity_edit_user_id_HistoryUser'), 'Activity', 'HistoryUser', ['edit_user_id'], ['id'])
    op.create_foreign_key(op.f('fk_Activity_create_user_id_HistoryUser'), 'Activity', 'HistoryUser', ['create_user_id'], ['id'])
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(op.f('fk_Activity_create_user_id_HistoryUser'), 'Activity', type_='foreignkey')
    op.drop_constraint(op.f('fk_Activity_edit_user_id_HistoryUser'), 'Activity', type_='foreignkey')
    op.alter_column('Activity', 'create_user_id',
               existing_type=sa.VARCHAR(),
               nullable=True)
    op.drop_column('Activity', 'edit_user_id')
    op.drop_column('Activity', 'edit_date')
    op.drop_column('Activity', 'create_date')
    # ### end Alembic commands ###