"""option_variants + screens.selected_variants Revision ID: e91c37fa5b62 Revises: d5f2a08c31be Create Date: 2026-09-01 rian's M2 ask 3: a concept is two options plus toggleable variants, not one option per combination. The variant is a CSS class the bridge swaps on , and the chosen values are part of the locked direction. """ from typing import Sequence, Union import sqlalchemy as sa from alembic import op revision: str = 'e91c37fa5b62' down_revision: Union[str, Sequence[str], None] = 'd5f2a08c31be' branch_labels: Union[str, Sequence[str], None] = None depends_on: Union[str, Sequence[str], None] = None def upgrade() -> None: op.create_table( 'option_variants', sa.Column('id', sa.Integer(), nullable=False), sa.Column('option_id', sa.Integer(), nullable=False), sa.Column('axis', sa.String(length=40), nullable=False), sa.Column('axis_label', sa.String(length=80), nullable=False), sa.Column('key', sa.String(length=40), nullable=False), sa.Column('label', sa.String(length=80), nullable=False), sa.Column('css_class', sa.String(length=60), nullable=False), sa.Column('position', sa.Integer(), nullable=False), sa.Column('is_default', sa.Boolean(), nullable=False), sa.Column('created_at', sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint(['option_id'], ['options.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('option_id', 'axis', 'key', name='uq_option_variant'), ) op.create_index(op.f('ix_option_variants_option_id'), 'option_variants', ['option_id'], unique=False) op.add_column('screens', sa.Column('selected_variants', sa.JSON(), nullable=True)) def downgrade() -> None: op.drop_column('screens', 'selected_variants') op.drop_index(op.f('ix_option_variants_option_id'), table_name='option_variants') op.drop_table('option_variants')