"""Add category icon and compare-at price to collection landing pages.

Revision ID: 0051_add_collection_icon_compare_price
Revises: 0050_fix_shopify_static_content_mappings
"""

from alembic import op
import sqlalchemy as sa


revision = "0051_add_collection_icon_compare_price"
down_revision = "0050_fix_shopify_static_content_mappings"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column("collection_landing_page", sa.Column("category_icon_url", sa.Text(), nullable=True))
    op.add_column(
        "collection_landing_page",
        sa.Column("compare_at_price", sa.Numeric(12, 4), nullable=True),
    )


def downgrade() -> None:
    op.drop_column("collection_landing_page", "compare_at_price")
    op.drop_column("collection_landing_page", "category_icon_url")