
    hK                         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)zlAlter Base Tables

Revision ID: 5100906b53c3
Revises: 6eb0826e7959
Create Date: 2025-08-12 14:39:07.994532

    )SequenceUnion)opN)
postgresql5100906b53c3revision6eb0826e7959down_revisionbranch_labels
depends_onc                     t        j                  dt        j                  dt        j                         d      t        j                  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                  dt        j                         d      t        j                  dgdg      t        j                  d	gdg      t        j                  dgdg      t        j                  d
gdg      t        j                  d      t        j                  dddd             t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd	gd       t        j                  t        j                  d      ddgd       t        j                  ddg dd       t        j                  t        j                  d      ddgd       t        j                  dddgd       t        j                  t        j                  d      dd
g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        t        j                  ddt        j                          d        t        j                  ddt        j                          d        t        j"                  d!dd"#       t        j                  t        j                  d$      dd	gd       t        j                  t        j                  d%      ddgd       t        j                  d&ddgd       t        j                  t        j                  d'      dd
gd       t        j                  d(dg d)d       t        j$                  d*dg d+       t        j&                  dd,       t        j&                  dd-       t        j                  d.d/t        j                          d        t        j                  d.d0t        j                          d        t        j"                  d1d2d3#       t        j"                  d4d.d"#       t        j(                  d5d.6       t        j                  d7d.dgd       t        j$                  d8d.ddg       t        j&                  d.d9       t        j&                  d.d:       t        j&                  d.d;       t        j&                  d<d=       t        j(                  d>d?6       t        j"                  d@d?d3#       t        j&                  d?d;       t        j&                  d?dA       t        j&                  d?d:       t        j(                  dBdC6       t        j&                  dCd;       t        j&                  dCd:       t        j                  d2t        j                  d	t        j                         d             t        j                  d2d/t        j                          d        t        j                  d2d0t        j                          d        t        j(                  dDd26       t        j                  t        j                  dE      d2d	gd       t        j                  dFd2dgd       t        j                  dGd2dHgd       t        j$                  dId2g dJ       t        j$                  dKd2g dL       t        j*                  dMd2d.d	gdgdNO       t        j&                  d2d9       t        j&                  d2d:       t        j&                  d2d;       t        j                  dPd/t        j                          d        t        j                  dPd0t        j                          d        t        j(                  dQdP6       t        j"                  dRdPd"#       t        j                  dSdPdgd       t        j                  t        j                  dT      dPd
gd       t        j$                  dUdPg dV       t        j&                  dPd;       t        j&                  dPd:       t        j&                  dPdW       t        j                  dXt        j                  dt        j                         d             t        j                  dXt        j                  dt        j                         d             t        j                  dXt        j                  dYt        j                         d             t        j                  dXd/t        j                          d        t        j                  dXd0t        j                          d        t        j                  t        j                  dZ      dXdgd       t        j                  t        j                  d[      dXd	gd       t        j                  d\dXg d]d       t        j                  t        j                  d^      dXdgd       t        j                  t        j                  d_      dXd
gd       t        j                  t        j                  d`      dXdYgd       t        j                  t        j                  da      dXdbgd       t        j                  dcdXddgd       t        j$                  dedXdddg       t        j$                  dfdXddd	g       t        j$                  dgdXdddg       t        j$                  dhdXddd
g       t        j$                  didXdddYg       t        j$                  djdXdddbg       t        j"                  dkdXd3#       t        j"                  dldXd3#       t        j"                  dmdXd3#       t        j*                  dMdXdCdgdgdNO       t        j*                  dMdXddYgdgdNO       t        j*                  dMdXd2d
gdgdNO       t        j*                  dMdXdPdbgdgdNO       t        j*                  dMdXd.d	gdgdNO       t        j*                  dMdXddgdgdNO       yM)nzUpgrade schema.sub_appellationsidF)nullablename   lengthappellation_id
country_id	region_idlocation_iddate_createdlast_updated
deleted_atTzappellations.idzcountries.idzlocations.idz
regions.id+uq_sub_appellation_appellation_name_deleted)r   "ix_sub_appellations_appellation_iduniqueix_sub_appellations_country_idix_sub_appellations_idix_sub_appellations_lineage)r   r   r   r   ix_sub_appellations_location_idix_sub_appellations_nameix_sub_appellations_region_idappellationsexisting_typer   uq_appellation_mongo_idr   type_ix_appellations_country_idix_appellations_location_idix_appellations_nameix_appellations_region_idix_appellations_scope)r   r   r   !uq_appellation_scope_name_deleted)r   r   r   r   r   mongo_idliteral	countries
created_at
updated_atregions_country_code_fkeyregions
foreignkeycountries_country_code_keyix_countries_uuid
table_nameix_countries_nameuq_countries_name_deletedcountry_code
is_deleteduuidkeyword_spreadsversionix_locales_uuidlocaleslocales_location_uuid_fkeylocation_uuidix_locations_uuid	locationsix_regions_uuidix_regions_country_idix_regions_nameix_regions_region_coderegion_codeuq_region_country_code_deleted)r   rO   r   uq_region_country_name_deleted)r   r   r   NRESTRICTondeletesub_regionsix_sub_regions_uuidsub_regions_sub_region_code_keyix_sub_regions_nameix_sub_regions_region_id!uq_sub_region_region_name_deleted)r   r   r   sub_region_codewine_appellationssub_appellation_id#ix_wine_appellations_appellation_idix_wine_appellations_country_id!ix_wine_appellations_level_picker)r   r   sub_region_idr   r   r]    ix_wine_appellations_location_idix_wine_appellations_region_id'ix_wine_appellations_sub_appellation_id"ix_wine_appellations_sub_region_idra   ix_wine_appellations_titletitleuq_wa_title_appellationuq_wa_title_countryuq_wa_title_locationuq_wa_title_regionuq_wa_title_sub_appellationuq_wa_title_sub_region!wine_appellations_country_id_fkey wine_appellations_region_id_fkey$wine_appellations_sub_region_id_fkey)r   create_tablesaColumnIntegerStringDateTimeForeignKeyConstraintPrimaryKeyConstraintUniqueConstraintcreate_indexf
add_columnalter_columnINTEGERr   	TIMESTAMPdrop_constraintcreate_unique_constraintdrop_column
drop_indexcreate_foreign_key     l/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/5100906b53c3_alter_base_tables.pyupgrader      sw
    OO&IIdBJJL51IIfbiis+e<II

u=IIlBJJL59IIk2::<%8IImRZZ\E:IInbkkme<IInbkkme<IIlBKKMD9-.1B0CF\N^,<?]On-=@[ML><D!(&,Ers" OOBDD=>@RUeTfotuOOBDD9:<NQ]P^glmOOBDD124FW\]OO13E  HD  MR  SOOBDD:;=OR_Q`inoOO.0BVHUZ[OOBDD89;MP[}ejkMM."))FBIIS4ITY"Z[OONLZZ\ OONKZZ\ OONMZZ\ OONN'113 OONN'113 0.QOOBDD56_deOOBDD67-afgOO*NVHUSOOBDD45~}]bcOO+^=gpuv C^  VV  WNN>:.NN>9-OOK'113 OOK'113 2I\R3[QMM%+>OO'vhuM ;[6S_J`aNN;/NN;-NN;'NN$i0MM#	:3YlSNN9f%NN9o.NN9l+MM%+>NN;'NN;-MM)RYY|RZZ\ERSOOI|'113 OOI|'113 MM#	:OOBDD019|nUZ[OO%y6(5IOO,i-QVW @)Mxy @)Mqr$	;YcdNN9n-NN9l+NN9f%OOM<'113 OOM<'113 MM'MB8-xXOO)=6(5QOOBDD34mk][`a C]TwxNN=&)NN=,/NN="34MM%ryy

W['\]MM%ryy1A2::<Z^'_`MM%ryy1Erzz|^b'cdOO''113 OO''113 OOBDD>?ATWgVhqvwOOBDD:;=PS_R`inoOO79L  Or  {@  AOOBDD;<>QTaSbkpqOOBDD9:<OR]Q^glmOOBDDBCEX[oZpy~OOBDD=>@SVeUfotuOO02EyY^_ 9;NQXZjPkl 57JWVbLcd 68KgWdMef 46IGU`Kab =?RU\^rTst 8:MPWYhOij:<OWcd9;NVbc=?RZfg$ 3[=/TXSYdno$ 35GJ^I_bfagr|}$ 3YPTv`jk$ 3]_DUX\W]hrs$ 3[<.SWRXcmn$ 3^FVEWZ^Y_jtur   c            	         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d       t        j                  ddddgdg       t        j                  d	dd
dgdg       t        j                  ddddgdg       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d       t        j                  dd       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  dd       t        j                  t        j                  d      d       t        j                  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$       t        j                  dd%       t        j                  dt        j                  d&t        j                  d'(      d)d)*             t        j                  dt        j                  d+t        j                         d)d)*             t        j                  dt        j                  d,t        j                         d)d)*             t        j                  d-dd       t        j                  t        j                  d.      d       t        j                  d/d       t        j                  d0dd&g       t        j                   d1dd,gd 2       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
t        j                  d+t        j                         d)d)*             t        j                  d
t        j                  d3t        j                  d4(      d)d *             t        j                  dd
d       t        j                  d5d
dd3gd3g       t        j                  d6d
d       t        j                  d7d
d       t        j                  d8d
       t        j                  d9d
       t        j                  t        j                  d:      d
       t        j                   d;d
d,gd 2       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)d)*             t        j                  d<t        j                  d,t        j                         d)d)*             t        j                   d=d<d,gd 2       t        j                  d>t        j                  d+t        j                         d)d)*             t        j                  d>t        j                  d?t        j                         d)d)*             t        j                  d>t        j                  d,t        j                         d)d)*             t        j                  d@d>d<d?gd,gdAB       t        j                   dCd>d,gd 2       t        j                  dDt        j                  dEt        j                         d)d *             t        j                  dt        j                  d,t        j                         d)d *             t        j                  dt        j                  d+t        j                         d)d *             t        j                  dt        j                  d3t        j                  d4(      d)d *             t        j                  dFdd       t        j                  dGd       t        j                   dHdd,gd 2       t        j                  dIdd3g       t        j
                  ddt        j                         d !       t        j
                  dd"t        j                         d !       t        j                  dJt        j                  dKt        j                         d)d *             t        j                  dJt        j                  dLt        j                         d)d *             t        j                  dMdJd       t        j                  dNdJ       t        j                  t        j                  dO      dJ       t        j                  dPdJ       t        j                  t        j                  dQ      dJ       t        j                  t        j                  dR      dJ       t        j                  dSdJdLg       t        j
                  dJdTt        j                         d !       t        j
                  dJdUt        j                         d !       t        j
                  dJd%t        j"                         d !       t        j
                  dJdt        j"                         d !       t        j
                  dJdt        j"                         d !       t        j                  dJdV       t        j                  t        j                  dW      dX       t        j                  dYdX       t        j                  t        j                  dZ      dX       t        j                  d[dX       t        j                  t        j                  d\      dX       t        j                  t        j                  d]      dX       t        j                  t        j                  d^      dX       t        j$                  dX       y)_zDowngrade schema.Nr\   r9   r*   rp   rU   ra   r   ro   r8   r   rn   r4   r   rm   r   rl   rk   rj   ri   rh   rf   r<   re   rd   rc   rb   r`   r_   r^   r6   Tr'   r5   r]   r   r   r[   d   r   F)autoincrementr   rA   rB   rZ   rY   rX   rW   rV   r   r@   
   r7   rQ   rP   rN   rM   rL   rK   rJ   rI   rF   rH   rG   CASCADErS   rE   rC   rD   r?   r>   r;   r:   r&   r3   r2   r1   r0   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|   rr   rs   VARCHARBOOLEANUUIDr   rz   r~   
drop_tabler   r   r   	downgrader      sV	    t0Et0Et0Et0Et0Et0E@BUWdgvfwz~y  A<>QS\_j^knrmst=?RT_bnaorvqwx/1DHU46IQYZ+-@Q-/B(S,.AR02EXVMM.;NOMM"$$;<I\]MM"$$@ANabMM"$$78EXYMM"$$9:GZ[MM5BUVMM"$$89FYZMM"$$<=J]^OO''113 OO''113 NN&(<=NN&(89NN&6MM-+<bjjPS>Tdity!z{MM-<UZej!klMM-62779E\a!bc:MQYZMM"$$12}MMM'MB A=SdRefOO)=6(4POOM<'113 OOM<'113 MM)RYYvrwwyX]^_MM)RYY|RZZ\QVafghMM)RYY~rzz7L\alpqrtYl;5y+P^O_bpaqr7(S7(SMM*yAMM#	:MM"$$./IFOO%y6(4HOOI|'113 OOI|'113 NN9l+MM+ryyrzz|SXchijMM+ryy%Z_`aOO'vhtLMM)RYY|RZZ\QVafghMM)RYY	QVafghMM)RYYvrwwyX]^_6	;Q`Padjckv  AOO%y6(4HMM#RYYy"**,V[fj%klMM+ryy%Z^_`MM+ryyrzz|SXcghiMM+ryy29N^cnrst2KxPMM%+>OO'vhtL <kNK[\OOK'113 OOK'113 MM."))Irzz|SXcg"hiMM."))J

TYdh"ij:NRZ[MM)nEMM"$$23OMM(^DMM"$$45.QMM"$$34P 9>J<XOONN'113 OONN'113 OONMZZ\ OONKZZ\ OONLZZ\ NN>6*MM"$$67DVWMM,9KLMM"$$89FXYMM/<NOMM"$$/0=OPMM"$$78EWXMM"$$;<I[\MM$%r   )returnN)__doc__typingr   r   alembicr   
sqlalchemyrr   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r   r   r   r   r   <module>r      sy    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2QvjA&r   