"""rename proposal FK column (previously pr_id) to proposal_id

Revision ID: 0027
Revises: 0026
Create Date: 2026-04-06
"""

from alembic import op

revision = "0027"
down_revision = "0026"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.alter_column("musehub_proposals", "pr_id", new_column_name="proposal_id")
    op.alter_column("musehub_proposal_reviews", "pr_id", new_column_name="proposal_id")
    op.alter_column("musehub_proposal_comments", "pr_id", new_column_name="proposal_id")
    op.alter_column("musehub_pr_labels", "pr_id", new_column_name="proposal_id")


def downgrade() -> None:
    op.alter_column("musehub_pr_labels", "proposal_id", new_column_name="pr_id")
    op.alter_column("musehub_proposal_comments", "proposal_id", new_column_name="pr_id")
    op.alter_column("musehub_proposal_reviews", "proposal_id", new_column_name="pr_id")
    op.alter_column("musehub_proposals", "proposal_id", new_column_name="pr_id")