o Ng@sUdZddlmZmZddlmZddlZddlm Z ddlm Z dZ e e d<d Zee dfe d <dZee ee dfe d <dZee ee dfe d <dddZdddZdS)zqadd_user_address_table Revision ID: b43b32dbe7d2 Revises: a31fb3c02c61 Create Date: 2025-02-25 14:31:28.933373 )SequenceUnion)opN)mysql)inspect b43b32dbe7d2revision a31fb3c02c61 down_revision branch_labels depends_onreturncCst}t|}d|vrtjdtjdtjdddddtjdtjdddddtjdtj d d dd tjd tj d d dd tjdtj d d dd tjdtj d d dd tjdtj dd dd tjdtj dd dd tjdtj dd dd tjdt dddtjdt dd tjdt dd tj dgdgdddt ddddd d!d"d#|dDvrtjd!ddgdd$d%d#|d&D}d'|vrtd&tjd'tjdddd d(d#|d&D}d)|vrtjd)d&dd'gdgd*d+dSdSdS),Nuser_addressesidT)unsignedF) autoincrementnullableuser_idZrecipient_named)length)rZ address_line1Z address_line2ZcityZ postal_codeZcountryphone is_default)defaultr created_at updated_atzusers.idZuser_addresses_ibfk_1CASCADE)nameondeleteutf8mb4_unicode_ciutf8mb4InnoDB) mysql_collatemysql_default_charset mysql_engine idx_user_idcSg|]}|dqSr.0idxr*r*5zupgrade..)uniquecSr(r)r*r,cr*r*r.r/9r0orders address_idcSr(r)r*r,fkr*r*r.r/>r0fk_orders_addresszSET NULL)r )rget_bindrget_table_names create_tablesaColumnrBIGINTStringBooleanDateTimeForeignKeyConstraintPrimaryKeyConstraint get_indexes create_index get_columns add_columnget_foreign_keyscreate_foreign_key)conn inspectorcolumnsfksr*r*r.upgradesJ   rNcCst}t|}dd|dD}d|vrtjdddddd|dD}d|vr2tddd |vrRd d d|d DvrKtj d d d t d dSdS) NcSr(r)r*r6r*r*r.r/Rr0zdowngrade..r4r8 foreignkey)type_cSr(r)r*r2r*r*r.r/Vr0r5rr'cSr(r)r*r+r*r*r.r/]r0) table_name) rr9rrHdrop_constraintrF drop_columnr:rD drop_index drop_table)rJrKrMrLr*r*r. downgradeJs  rV)r N)__doc__typingrralembicr sqlalchemyr<Zsqlalchemy.dialectsrrrstr__annotations__r r r rNrVr*r*r*r.s     4