
    gh&                         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)ziadd validation

Revision ID: 71046ff74214
Revises: 8ba055a43d6d
Create Date: 2025-09-01 16:47:49.275007

    )SequenceUnion)opN)
postgresql71046ff74214revision8ba055a43d6d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                  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gdg      t        j                  dgdg      t        j                  d      	       t        j                  t        j                  d      ddgd
       t        j                  ddt        j                  dd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      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       t        j                  d"d#t        j                          d$       y%)&zUpgrade schema.work_groupsidF)nullablenamedate_createdTlast_updatedix_work_groups_id)uniquework_group_web_crawlerswork_group_idweb_crawler_idzweb_crawlers.idzwork_groups.idix_work_group_web_crawlers_idwine_dbsourceIMPORTMANUAL
sourceenumr   existing_typetype_existing_nullablewine_matcheswine_alert_id   )lengthvalidation_typekeywordstatus2   ix_wine_matches_web_crawler_idweb_crawlerswine_noises
wine_db_idr!   r   N)r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintcreate_indexfForeignKeyConstraintalter_columnr   ENUM
add_columncreate_foreign_keyINTEGER     i/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/71046ff74214_add_validation.pyupgraderC      s    OOMIIdBJJL51IIfbiikE2IInbkkmd;IInbkkmd;D! OOBDD,-}tfUSOO-IIdBJJL51IIorzz|e<II

u=IInbkkmd;IInbkkmd;-.1B0CF_-0@/ADD!	 OOBDD89;TW[V\ejkOOIx'__XxlSYY[!%' MM."))ORYYc=R]a"bcMM.")),<bjjlUY"Z[MM.")),=ryyPS?T_c"deMM."))Iryy7LW["\]MM."))Hbiir6JUY"Z[:NN]m\nqupvwOOM<ZZ\rA   c            
         t        j                  ddt        j                         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                         t        j                  ddd      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/   Fr0   r,   r$   
foreignkey)r"   r*   r)   r(   r   r%   r   r   r   r   r   r   Tr    r   r   )
table_namer   r   N)r   r;   r2   r?   drop_constraintdrop_columnr5   r   r<   
drop_indexr9   
drop_tabler@   rA   rB   	downgraderK   ;   s     OOM<ZZ\ 7|\NN>8,NN>9-NN>#45NN>#34NN>?3OOIxYY[__XxlK!%' MM"$$67D]^MM+,MM"$$*+FMM- rA   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr2   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   rC   rK   r@   rA   rB   <module>rT      sv    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2"L!rA   