"""post caption overrides

Revision ID: 9be0c0227263
Revises: ca1f17d23b39
Create Date: 2026-10-27 10:15:56.169485
"""

from __future__ import annotations

from collections.abc import Sequence

from alembic import op
import sqlalchemy as sa


revision: str = '9be0c0227263'
down_revision: str | None = 'ca1f17d23b39'
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('posts', schema=None) as batch_op:
        batch_op.add_column(sa.Column('caption_prefix_override', sa.Text(), nullable=True))
        batch_op.add_column(sa.Column('caption_suffix_override', sa.Text(), nullable=True))
        batch_op.add_column(sa.Column('signature_override', sa.String(length=255), nullable=True))
        batch_op.add_column(sa.Column('video_link_template_override', sa.String(length=512), nullable=True))

    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('posts', schema=None) as batch_op:
        batch_op.drop_column('video_link_template_override')
        batch_op.drop_column('signature_override')
        batch_op.drop_column('caption_suffix_override')
        batch_op.drop_column('caption_prefix_override')

    # ### end Alembic commands ###