"""gantt_operational_fields

Revision ID: ea85d383dcc9
Revises: 6c508b853b8c
Create Date: 2025-10-29 13:04:26.705264

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ea85d383dcc9'
down_revision = '6c508b853b8c'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_gantt_task', sa.Column('constrain_duration', sa.Integer(), nullable=True))
    op.add_column('cmf_gantt_task', sa.Column('update_sched_dates_from_actual', sa.Boolean(), nullable=False, server_default="false"))
    op.create_index(op.f('ix_cmf_gantt_task_constrain_duration'), 'cmf_gantt_task', ['constrain_duration'], unique=False)
    op.add_column('cmf_project', sa.Column('gantt_sync_actual_and_sched_dates', sa.Boolean(), nullable=False, server_default="false"))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_project', 'gantt_sync_actual_and_sched_dates')
    op.drop_index(op.f('ix_cmf_gantt_task_constrain_duration'), table_name='cmf_gantt_task')
    op.drop_column('cmf_gantt_task', 'update_sched_dates_from_actual')
    op.drop_column('cmf_gantt_task', 'constrain_duration')
    # ### end Alembic commands ###