"""Phase 3 - 清理 EditPlan 表冗余字段

Revision ID: 048
Revises: 047
Create Date: 2026-07-21

Changes:
1. 删除 edit_plans.result_count 字段（剪辑计划独立功能遗留，模板草稿不用，
   生成结果数由 generation_tasks.result_count 承载）
"""

import sqlalchemy as sa

from alembic import op

revision = "048_cleanup_result_count"
down_revision = "047_template_versioning"
branch_labels = None
depends_on = None


def upgrade() -> None:
    # 删除 result_count 字段（剪辑计划独立功能遗留字段）
    op.drop_column("edit_plans", "result_count")


def downgrade() -> None:
    # 回滚：恢复 result_count 字段，默认值 0
    op.add_column(
        "edit_plans",
        sa.Column(
            "result_count",
            sa.Integer,
            nullable=False,
            server_default="0",
        ),
    )