"""cms_pages: add content column (long-form body for legal pages)

Revision ID: 0057
Revises: 0056
Create Date: 2026-07-03
"""
from alembic import op
import sqlalchemy as sa

revision = "0057"
down_revision = "0056"
branch_labels = None
depends_on = None


def upgrade() -> None:
    conn = op.get_bind()
    exists = conn.execute(sa.text(
        "SELECT 1 FROM information_schema.columns "
        "WHERE table_name='cms_pages' AND column_name='content'"
    )).fetchone()
    if not exists:
        op.add_column("cms_pages", sa.Column("content", sa.Text(), nullable=True))


def downgrade() -> None:
    op.drop_column("cms_pages", "content")