"""add literal in match  tables

Revision ID: f652e94c3a0f
Revises: 43569c02276e
Create Date: 2025-07-17 12:38:31.055370

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = 'f652e94c3a0f'
down_revision: Union[str, None] = '43569c02276e'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    """Upgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('appellations', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('bottle_sizes', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('producer_keywords', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('producer_noises', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('producers', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('retailer_wines', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('retailers', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('wine_db', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('wine_duplications', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('wine_keywords', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('wine_noises', sa.Column('literal', sa.String(), nullable=True))
    op.add_column('wines', sa.Column('literal', sa.String(), nullable=True))
    # ### end Alembic commands ###


def downgrade() -> None:
    """Downgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('wines', 'literal')
    op.drop_column('wine_noises', 'literal')
    op.drop_column('wine_keywords', 'literal')
    op.drop_column('wine_duplications', 'literal')
    op.drop_column('wine_db', 'literal')
    op.drop_column('retailers', 'literal')
    op.drop_column('retailer_wines', 'literal')
    op.drop_column('producers', 'literal')
    op.drop_column('producer_noises', 'literal')
    op.drop_column('producer_keywords', 'literal')
    op.drop_column('bottle_sizes', 'literal')
    op.drop_column('appellations', 'literal')
    # ### end Alembic commands ###