
    h                         U d Z ddlmZmZ ddlmZ ddl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)zlAlter Base Tables

Revision ID: 27578d637b15
Revises: 5100906b53c3
Create Date: 2025-08-12 15:24:39.209951

    )SequenceUnion)opN27578d637b15revision5100906b53c3down_revisionbranch_labels
depends_onc                     t        j                  dt        j                  dt        j                         d             t        j
                  dd       t        j
                  dd       t        j                  ddg dd	       t        j                  d
dd       t        j                  d
dg d       t        j                  t        j                  d      ddgd	       t        j                  ddd       t        j                  ddddgdg       t        j                  dd       t        j                  d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dg dd	       t        j                  t        j                  d      ddgd	       t        j                  ddd       t        j                  ddddgdg       t        j                  dd       t        j
                  d d!       t        j                  d"d!d       t        j
                  d#d!       t        j                  d#d!g d$d	       t        j                  d%d!d       t        j                  d!d       y)&zUpgrade schema.appellationssub_region_idF)nullableix_appellations_location_id
table_nameix_appellations_scope)
country_id	region_idr   unique!uq_appellation_scope_name_deletedr   type_)r   r   r   name
deleted_atix_appellations_sub_region_idappellations_location_id_fkey
foreignkeyNsub_regionsidlocation_idregionsregion_code   lengthexisting_typer   sub_appellationsix_sub_appellations_location_idix_sub_appellations_lineage)r   r   r   appellation_id!ix_sub_appellations_sub_region_id!sub_appellations_location_id_fkey ix_wine_appellations_location_idwine_appellationsuq_wa_title_location!ix_wine_appellations_level_picker)r   r   r   r-   sub_appellation_id"wine_appellations_location_id_fkey)r   
add_columnsaColumnInteger
drop_indexcreate_indexdrop_constraintcreate_unique_constraintfcreate_foreign_keydrop_columnalter_columnVARCHAR     l/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/27578d637b15_alter_base_tables.pyupgraderF      sH    MM."))ORZZ\TY"Z[MM/NKMM)nEOO+^=irwx:NRZ[ C^  VX  YOOBDD89>OK\ejk6l[$?PSWRXYNN>=1OOI}ZZs3 MM$biiX]&^_MM3@RSMM/<NOOO13E  HF  OT  UOOBDD<=?QTcSdmrs:<NVbc$ 2MOCTW[V\]NN%}5MM4ATU-/B(SMM5BUVOO79L  Oc  lq  r;=PXdeNN&6rD   c            	      :   t        j                  dt        j                  dt        j                         dd             t        j
                  ddddgdgd	
       t        j                  dd       t        j                  ddg dd       t        j                  ddddg       t        j                  dddgd       t        j                  dt        j                  dt        j                         dd             t        j                  ddd       t        j
                  ddddgdg       t        j                  t        j                  d      d       t        j                  dd       t        j                  ddg dd       t        j                  dddgd       t        j                  dd       t        j                  ddt        j                  d      d        t        j                  d!t        j                  dt        j                         dd             t        j                  dd!d       t        j
                  d"d!ddgdg       t        j                  t        j                  d#      d!       t        j                  d$d!d%       t        j                  d$d!g d&       t        j                  d'd!       t        j                  d'd!g d(d       t        j                  d)d!dgd       t        j                  d!d       y)*zDowngrade schema.r1   r"   FT)autoincrementr   r5   	locationsr!   RESTRICT)ondeleter3   r   )r   r   r   r"   r-   r4   r   r2   titler0   r*   Nr   r   r/   r.   r,   )r   r   r"   r-   r+   r   r#   r$   r%   r&   r(   r   r   r   r   r   )r   r   r"   r   r   r   )r   r   r"   r   )r   r6   r7   r8   INTEGERr?   r:   r;   r=   r<   r>   r@   rA   rB   rC   rD   rE   	downgraderN   6   s    MM%ryy

\alp'qr>@SU`cpbqtxsy  EO  PMM5BUVOO79L  Or  {@  A 68KgWdMefOO68Km_ejkMM$biirzz|[`kp&qrt/|D=?QS^an`orvqwxMM"$$:;HZ[MM/<NOOO13E  HD  MR  SOO57IM?chiNN%7OOI}ZZs3 MM."))M2::<W\gl"mnt^<@9>;YfXgjniopMM"$$67NS:NRZ[ C^  VV  WMM)nEOO+^=gpuvOO1>M?[`aNN>?3rD   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr7   r   str__annotations__r	   r
   r   rF   rN   rC   rD   rE   <module>rV      ss    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 27B4rD   