"""Add actual_myself_cost

Revision ID: 4d0bca55d982
Revises: 461abdd3a91d
Create Date: 2022-11-24 18:49:20.298693

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '4d0bca55d982'
down_revision = '461abdd3a91d'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_gantt_task', sa.Column('actual_myself_cost', sa.Integer(), nullable=False, server_default='0'))
    op.drop_column('cmf_gantt_task', 'perform_cost')
    op.drop_column('cmf_gantt_task', 'perform_duration')
    op.drop_column('cmf_gantt_task', 'perform_work')
    op.drop_column('cmf_gantt_task', 'perform_complete')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_gantt_task', sa.Column('perform_complete', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('cmf_gantt_task', sa.Column('perform_work', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('cmf_gantt_task', sa.Column('perform_duration', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('cmf_gantt_task', sa.Column('perform_cost', sa.NUMERIC(precision=14, scale=2), autoincrement=False, nullable=False))
    op.drop_column('cmf_gantt_task', 'actual_myself_cost')
    # ### end Alembic commands ###