
    lh%                         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)zdvarieties

Revision ID: 8008c59dddd5
Revises: b24999d1237d
Create Date: 2025-08-01 17:04:49.810401

    )SequenceUnion)opN)
postgresql8008c59dddd5revisionb24999d1237d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                  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                  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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dddgdg       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             y)"zUpgrade schema.	varietiesidF)nullabledefault_colorTnamedate_createdlast_updated
deleted_atix_varieties_id)uniqueappellationsbottle_sizesjob_logsmatched_logsproducer_keywordsproducer_noises	producersretailer_wines	retailersweb_crawler_files	file_typed   )lengthwine_db
variety_idNvarietywine_duplicationswine_keywordswine_noiseswines)r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintUniqueConstraintcreate_indexf
add_columncreate_foreign_keydrop_column     d/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/8008c59dddd5_varieties.pyupgrader<      s    OOKIIdBJJL51IIoryy{T:IIfbiikE2IInbkkmd;IInbkkmd;IIlBKKMD9D!	 OOBDD*+[4&OMM."))L"++-RV"WXMM."))L"++-RV"WXMM*biibkkmdSTMM."))L"++-RV"WXMM%ryyr{{}W['\]MM#RYY|R[[]UY%Z[MM+ryyr{{}tTUMM"BIIlBKKMTX$YZMM+ryyr{{}tTUMM%ryybiis>S^b'cdMM)RYY|RZZ\DQRMM)RYY|R[[]TRS$	;ONN9i(MM%ryyr{{}W['\]MM/299\2;;=SW#XYMM-<QU!VWMM'299\2;;=4PQr:   c            	         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d	
             t        j                  ddd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       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       y)zDowngrade schema.r+   r   r*   r)   r(   r%   r'   FT)autoincrementr   N
foreignkey)type_r&   r!   r"   r    r   r   r   r   r   r   r   r   r   r   )
table_name)
r   r8   r6   r-   r.   VARCHARdrop_constraint
drop_indexr5   
drop_tabler9   r:   r;   	downgraderF   8   sC    NN7L)NN=,/NN?L1NN&5MM)RYYy"**,e^bcdtYl;NN9l+NN9l+NN&4NN;-NN#\2NN;-NN$l3NN&5NN><0NN:|,NN><0NN><0MM"$$()kBMM+r:   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr-   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r<   rF   r9   r:   r;   <module>rO      sw    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2RFr:   