
    @h                         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)zaddition of global noise and download files

Revision ID: 8ba055a43d6d
Revises: 0f3a4026c398
Create Date: 2025-08-25 10:38:22.505832

    )SequenceUnion)opN8ba055a43d6drevision0f3a4026c398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                  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      d      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       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       y)zUpgrade schema.global_noisesidF)nullablenoise
created_atT
updated_at
deleted_atix_global_noises_id)uniquedownload_filesfile_id	file_typed   )lengthzfiles.idix_download_files_idappellations
country_idexisting_typer   	region_idsub_appellationssub_region_idN)r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintUniqueConstraintcreate_indexfForeignKeyConstraintalter_columnINTEGER     /var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/8ba055a43d6d_addition_of_global_noise_and_download_.pyupgrader3      s.    OOOIIdBJJL51IIgryy{U3IIlBKKMD9IIlBKKMD9IIlBKKMD9D!  OOBDD./4&QVWOO$IIdBJJL51IIi6IIlBKKMD9IIlBKKMD9IIlBKKMD9IIk299C04@YK*8D!	 OOBDD/02BTFSXYOONLZZ\ OONKZZ\ OO&ZZ\ OO&ZZ\ OO&ZZ\r1   c                     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                  t        j
                  d      d	
       t        j                  d	       t        j                  t        j
                  d      d
       t        j                  d       y)zDowngrade schema.r!   r"   Fr   r    r   r   r   r   )
table_namer   r   N)r   r.   r$   r/   
drop_indexr,   
drop_tabler0   r1   r2   	downgrader8   ?   s     OO&ZZ\ OO&ZZ\ OO&ZZ\ OONKZZ\ OONLZZ\ MM"$$-.;KLMM"#MM"$$,-/JMM/"r1   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr$   r   str__annotations__r	   r
   r   r3   r8   r0   r1   r2   <module>r@      ss    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2&T#r1   