
    =h0                         U d Z ddlmZmZ ddlmZ ddlZddlm	Z	 dZ
eed<   dZeedf   ed	<   dZeeee   df   ed
<   dZeeee   df   ed<   ddZddZy)zrAlter Appellation Table

Revision ID: 0f3a4026c398
Revises: 913ee7a57f67
Create Date: 2025-08-22 14:02:16.747673

    )SequenceUnion)opN)
postgresql0f3a4026c398revision913ee7a57f67down_revisionbranch_labels
depends_onc            	         t        j                  ddt        j                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  dd	t        j                  d
      d       t        j                  ddt        j                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  ddt        j                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  ddt        j                         d       t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  dt        j                  dt        j                  d
      d             t        j                  ddt	        j
                         d       t        j                  ddt	        j
                         d       t        j                  dd       t        j                  ddd       t        j                  ddd       t        j                  ddd       t        j                  ddd       t        j                  ddd       t        j                  dd       y) zUpgrade schema.appellationssub_region_idTexisting_typenullable
created_at
updated_at	countriesregionsregion_code   lengthF
country_idsub_appellationsappellation_idsub_regions	region_idwine_appellations
import_tag)r   ix_wine_appellations_title)
table_nameuq_wa_title_appellationunique)type_uq_wa_title_countryuq_wa_title_regionuq_wa_title_sub_appellationuq_wa_title_sub_regiontitleN)r   alter_columnsaINTEGERr   	TIMESTAMPVARCHAR
add_columnColumnString
drop_indexdrop_constraintdrop_column     r/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/0f3a4026c398_alter_appellation_table.pyupgrader:      s    OONOZZ\ OONL'113 OONL'113 OOK'113 OOK'113 OOI}ZZs3 OOI|ZZ\ OOI|'113 OOI|'113 OO&(8ZZ\ OO&'113 OO&'113 OOM;ZZ\ OOM<'113 OOM<'113 MM%ryyryyPS?T_c'deOO''113 OO''113 MM.;NO02EXV,.AR+-@Q46IQYZ/1DHUNN&0r8   c            	         t        j                  dt        j                  dt        j                  d      dd             t        j
                  ddddg       t        j
                  d	ddd
g       t        j
                  ddddg       t        j
                  ddddg       t        j
                  ddddg       t        j                  dddgd       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  dd       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                  d      d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       t        j                  ddt        j                         d       y)zDowngrade schema.r    r+   r   r   F)autoincrementr   r*   r   r)   sub_appellation_idr(   r   r'   r   r$   r   r"   )r%   r   r   r   r!   r   r   r   r   Tr   r   N)r   r1   r-   r2   r0   create_unique_constraintcreate_indexr,   r   r/   r6   r.   r7   r8   r9   	downgrader@   V   s    MM%ryy"**C:P`epu'vw 8:MPWYhOij =?RU\^rTst 46IGU`Kab 57JWVbLcd 9;NQXZjPklOO02EyY^_OO''113 OO''113 NN&5OOM<'113 OOM<'113 OOM;ZZ\ OO&'113 OO&'113 OO&(8ZZ\ OOI|'113 OOI|'113 OOI|ZZ\ OOI}ZZs3 OOK'113 OOK'113 OONL'113 OONL'113 OONOZZ\r8   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr-   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r:   r@   r7   r8   r9   <module>rI      sv    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2=1B=r8   