
    ߏhZ                         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)zyeliminations and substitutions

Revision ID: 7123375920d1
Revises: 8008c59dddd5
Create Date: 2025-08-07 20:00:32.512764

    )SequenceUnion)opN7123375920d1revision8008c59dddd5down_revisionbranch_labels
depends_onc                  T   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                  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                  t        j                  d      ddg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                  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                  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                  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                  t        j                  d"      d dg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vintagesname   ix_vintages_idword_aliaseswordalias
alias_typeix_word_aliases_idword_eliminationselimination_typeix_word_eliminations_idword_reservedreserved_typeix_word_reserved_idN)
r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintcreate_indexf     y/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/7123375920d1_eliminations_and_substitutions.pyupgrader9      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OOJIIdBJJL51IIfbiis+e<IInbkkmd;IInbkkmd;IIlBKKMD9D! OOBDD)*JuMOONIIdBJJL51IIfbiikE2IIgryy{U3IIlBIIS1DAIInbkkmd;IInbkkmd;IIlBKKMD9D!	 OOBDD-.uU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Wr7   c                     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	       t        j                  t        j                  d
      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       y)zDowngrade schema.r,   r*   )
table_namer)   r'   r&   r"   r!   r   r   r   r   r   N)r   
drop_indexr5   
drop_tabler6   r7   r8   	downgrader>   Y   s     MM"$$,-/JMM/"MM"$$01>QRMM%&MM"$$+,HMM.!MM"$$'(Z@MM*MM"$$45BYZMM)*MM"$$./<MNMM#$r7   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr.   r   str__annotations__r	   r
   r   r9   r>   r6   r7   r8   <module>rF      su    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2@XH%r7   