"""add wine adition

Revision ID: 6eb0826e7959
Revises: 7123375920d1
Create Date: 2025-08-08 16:21:39.437885

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision: str = '6eb0826e7959'
down_revision: Union[str, None] = '7123375920d1'
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.create_table('wine_additions',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('literal', sa.String(), nullable=True),
    sa.Column('wine_vinid', sa.String(), nullable=True),
    sa.Column('region_code', sa.String(), nullable=True),
    sa.Column('vintage', sa.String(), nullable=True),
    sa.Column('variety', sa.String(), nullable=True),
    sa.Column('label', sa.String(), nullable=True),
    sa.Column('producer_name', sa.String(), nullable=True),
    sa.Column('producer_name_show', sa.String(), nullable=True),
    sa.Column('country', sa.String(), nullable=True),
    sa.Column('region', sa.String(), nullable=True),
    sa.Column('location', sa.String(), nullable=True),
    sa.Column('locale', sa.String(), nullable=True),
    sa.Column('site', sa.String(), nullable=True),
    sa.Column('sweetness', sa.String(), nullable=True),
    sa.Column('color', sa.String(), nullable=True),
    sa.Column('wine_type', sa.String(), nullable=True),
    sa.Column('date_created', sa.DateTime(), nullable=True),
    sa.Column('last_updated', sa.DateTime(), nullable=True),
    sa.Column('deleted_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_wine_additions_id'), 'wine_additions', ['id'], unique=False)
    # ### end Alembic commands ###


def downgrade() -> None:
    """Downgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_wine_additions_id'), table_name='wine_additions')
    op.drop_table('wine_additions')
    # ### end Alembic commands ###