
    h'                         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)zyeliminations and substitutions

Revision ID: 6cd4376bdff5
Revises: 8008c59dddd5
Create Date: 2025-08-06 13:15:40.353272

    )SequenceUnion)opN)
postgresql6cd4376bdff5revision8008c59dddd5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      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                  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      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      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      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                  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dt        j                         t        j
                         d       t        j                  dd t        j                  d!      t        j
                  d      d	       t        j                  t        j                  d"      ddgd       t        j                  d#ddg       t        j                   dd$       t        j                   dd%       y&)'zUpgrade schema.keyword_spreadsidF)nullablekeywordregion_coded   lengthTkeyword_typedate_createdlast_updated
deleted_atix_keyword_spreads_id)uniquekeyword_substitutionssubstitutionsubstitution_typeix_keyword_substitutions_idword_eliminationswordelimination_typeix_word_eliminations_idword_reservedreserved_typeix_word_reserved_idvintagesix_vintages_idword_aliasesaliasexisting_typetype_r   
alias_type2   ix_word_aliases_idword_aliases_word_key
created_at
updated_atN)r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintUniqueConstraintcreate_indexf
add_columnalter_columnTEXTVARCHARcreate_unique_constraintdrop_column     y/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/6cd4376bdff5_eliminations_and_substitutions.pyupgraderG      s    OO%IIdBJJL51IIiu5IImRYYc2TBIInbiis3dCIInbkkmd;IInbkkmd;IIlBKKMD9D!	"
 OOBDD013DtfUZ[OO+IIdBJJL51IIiu5IInbiikD9II!299C#84HIInbkkmd;IInbkkmd;IIlBKKMD9D!	"
 OOBDD679PSWRXafgOO'IIdBJJL51IIfbiikE2II "))3"7$GIInbkkmd;IInbkkmd;IIlBKKMD9D!	 OOBDD235H4&Y^_OOOIIdBJJL51IIfbiikE2IIoryy4tDIInbkkmd;IInbkkmd;IIlBKKMD9D!	 OOBDD./4&QVWMM*biibkkmdSTOOBDD)*JuMMM."))NBKKMTX"YZMM."))NBKKMTX"YZMM."))L"++-RV"WXOONGWWYYY[ OONLZZr2YYc* OOBDD-.uU 7&RNN><0NN><0rE   c            	         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                  d      t        j                  d      d       t        j                  ddt        j                         t        j                         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                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       y) zDowngrade schema.r)   r3   FT)autoincrementr   r2   r1   r   )r-   r0   )
table_namer.   r   r   r/   r+   r*   r   r   r   r(   r'   r&   r$   r#   r    r   r   r   r   N)r   r>   r5   r6   r   	TIMESTAMPdrop_constraint
drop_indexr=   r?   r8   rA   r@   rC   
drop_tablerD   rE   rF   	downgraderO   Z   s    MM."))L*:N:N:P`ept"uvMM."))L*:N:N:P`ept"uv.hOMM"$$+,HOONLYYc2ZZr* OONGYY[WWY NN><0NN>>2NN>>2MM"$$'(Z@NN:|,MM"$$,-/JMM/"MM"$$01>QRMM%&MM"$$45BYZMM)*MM"$$./<MNMM#$rE   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr5   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   rG   rO   rD   rE   rF   <module>rX      sw    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2A1J%rE   