
    $ch                         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)zradd uuid and soft delete

Revision ID: a24538bfa409
Revises: b63374a17449
Create Date: 2025-06-27 12:27:12.999523
    )SequenceUnion)opNa24538bfa409revisionb63374a17449down_revisionbranch_labels
depends_onc                  
   t        j                  dt        j                  dt        j                         d             t        j                  dt        j                  dt        j
                         d             t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd	       t        j                  d
t        j                  dt        j                         d             t        j                  d
t        j                  dt        j
                         d             t        j                  d
t        j                  dt        j                         d             t        j                  t        j                  d      d
dgd	       t        j                  dt        j                  dt        j                         d             t        j                  dt        j                  dt        j
                         d             t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd	       t        j                  dt        j                  dt        j                         d             t        j                  dt        j                  dt        j
                         d             t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd	       t        j                  t        j                  d      dd       t        j                  dd       t        j                  dt        j                  dt        j                         d             t        j                  dt        j                  dt        j                         d             t        j                  dt        j                  dt        j
                         d             t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd	       t        j                  ddddgdgd       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      dd       t        j                  t        j                  d      dd       t        j                  dddd gd!gd       t        j                  ddddgd!gd       y)"zUpgrade schema.	countriesuuidFnullable
is_deleted
deleted_atTix_countries_uuiduniqueregionsix_regions_uuid	locationsix_locations_uuidsub_regionsix_sub_regions_uuidlocales_location_id_fkeylocales
foreignkeytype_location_idlocation_uuidix_locales_uuidNCASCADE)ondeleteix_web_crawlers_country_idweb_crawlers
table_nameix_web_crawlers_location_idweb_crawlers_country_id_fkeyweb_crawlers_location_id_fkey
country_idid)r   
add_columnsaColumnUUIDBooleanDateTimecreate_indexfdrop_constraintdrop_columncreate_foreign_key
drop_index     s/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/a24538bfa409_add_uuid_and_soft_delete.pyupgrader>      s    MM+ryyUKLMM+ryyrzz|eTUMM+ryyr{{}tTUOOBDD,-{VHTRMM)RYYvrwwy5IJMM)RYY|RZZ\ERSMM)RYY|R[[]TRSOOBDD*+YNMM+ryyUKLMM+ryyrzz|eTUMM+ryyr{{}tTUOOBDD,-{VHTRMM-62779u!MNMM-<PU!VWMM-<QU!VWOOBDD./QUV rtt67,WNN9m,MM)RYYvrwwy5IJMM)RYY	ERSMM)RYY|RZZ\ERSMM)RYY|R[[]TRSOOBDD*+YN$	;8IF8^gh MM"$$34PMM"$$45.Qrtt:;^S_`rtt;<nT`a$l^dV^gh$m_tf_hir<   c                     t        j                  ddd       t        j                  ddd       t        j                  t        j                  d      dddgdg       t        j                  t        j                  d	      dd
dgdg       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  ddd       t        j
                  t        j                  d      d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      dddgdg       t        j
                  t        j                  d      d       t        j                  dd       t        j                  dd       t        j                  dd       t        j
                  t        j                  d      d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  ddd       t        j                  t        j                  d      dddgdg       t        j
                  t        j                  d      d       t        j                  dd       t        j                  dd       t        j                  dd       t        j
                  t        j                  d       d
       t        j                  d
d       t        j                  d
d       t        j                  d
d       y)!zDowngrade schema.Nr'   r   r   r,   r   r!   r.   r+   r   r-   r*   Fr   r&   r   r#   r(   r   r   r"   r   r   r   r   r   r   r   locations_region_id_fkey	region_idr   r   )r   r7   r9   r6   r5   r:   r8   r/   r0   r1   INTEGERr;   r<   r=   	downgraderC   @   s    t^<@t^<@"$$>?Q\_l^mptouv"$$=>P[^j]knrmstOOBDD67-afgOOBDD56_de tYl;MM"$$()i@NN9l+NN9l+NN9o.NN9f%MM)RYY}bjjlUST"$$9:I{UbTcfjekl MM"$$,--HNN=,/NN=,/NN=&)MM"$$()i@NN9l+NN9l+NN9f%t[="$$9:KU`TadhcijMM"$$*+DNN;-NN;-NN;'MM"$$*+DNN;-NN;-NN;'r<   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr0   r   str__annotations__r	   r
   r   r>   rC   r;   r<   r=   <module>rK      st    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2(jX)(r<   