"""add image_short_url table

Revision ID: 0009_add_image_short_url
Revises: 0008_add_sku_override
Create Date: 2026-02-24 00:00:00.000000
"""

from alembic import op
import sqlalchemy as sa


revision = "0009_add_image_short_url"
down_revision = "0008_add_sku_override"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_table(
        "image_short_url",
        sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True),
        sa.Column("slug", sa.String(length=12), nullable=False),
        sa.Column("destination_url", sa.Text(), nullable=False),
        sa.Column("created_at", sa.DateTime(timezone=True), server_default=sa.func.now(), nullable=False),
    )
    op.create_unique_constraint("uq_image_short_url_slug", "image_short_url", ["slug"])
    op.create_index("ix_image_short_url_slug", "image_short_url", ["slug"])


def downgrade() -> None:
    op.drop_index("ix_image_short_url_slug", table_name="image_short_url")
    op.drop_constraint("uq_image_short_url_slug", "image_short_url", type_="unique")
    op.drop_table("image_short_url")