
    2Yh                         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)z~create base and wine setting models

Revision ID: 1d108970fe0a
Revises: 910b03df97c9
Create Date: 2025-06-23 11:55:03.338285

    )SequenceUnion)opN1d108970fe0arevision910b03df97c9down_revisionbranch_labels
depends_onc                     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                  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      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j                         d      t        j                  dt        j                         d      t        j                  dgdg      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gdg      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g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gdg      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                  dt        j                         d      t        j                  dgd!g      t        j                  dgdg      t        j                  d gd"g      t        j                  d             y#)$zUpgrade schema.	countriesidF)nullablenamed   )lengthcountry_code
   
created_atT
updated_atix_countries_id)uniqueregions   region_codezcountries.country_code	locations	region_idz
regions.idsub_regionssub_region_codeCASCADE)ondeletelocaleslocation_idzlocations.idwine_appellationstitle
country_idsub_region_idzcountries.idzsub_regions.idN)r   create_tablesaColumnIntegerStringDateTimePrimaryKeyConstraintUniqueConstraintcreate_indexfForeignKeyConstraint     ~/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/1d108970fe0a_create_base_and_wine_setting_models.pyupgrader6      s    OOKIIdBJJL51IIfbiis+e<IInbiir2UCIIlBKKMD9IIlBKKMD9D!' OOBDD*+[4&OOOIIIdBJJL51IIfbiis+e<IImRYYc2UCIInbiir2TBIIlBKKMD9IIlBKKMD9^,/G.HKD!	 OOKIIdBJJL51IIfbiis+e<IIk2::<%8IIlBKKMD9IIlBKKMD9[ML><D! OOMIIdBJJL51IIfbiis+e<II#!6GIIk2::<%8IIlBKKMD9IIlBKKMD9[ML>IND!)*
 OOIIIdBJJL51IIfbiis+e<IImRZZ\E:IIlBKKMD9IIlBKKMD9]On-=@D! OO'IIdBJJL51IIgryy,u=IIlBJJL48IIk2::<$7IIorzz|d;IIlBKKMD9IIlBKKMD9\N^,<?[ML><_-0@/ADD!r4   c                  T   t        j                  d       t        j                  d       t        j                  d       t        j                  d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       y	)
zDowngrade schema.r$   r"   r   r   r   r   r   )
table_nameN)r   
drop_table
drop_indexr1   r3   r4   r5   	downgrader;   Y   se     MM%&MM)MM- MM+MM)MM"$$()kBMM+r4   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr)   r   str__annotations__r	   r
   r   r6   r;   r3   r4   r5   <module>rC      st    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2@H	r4   