U
    \Úd®  ã                   @   s<   d Z ddlmZ ddlZdZdZdZdZdd„ Z	dd	„ Z
dS )
zccontract

Revision ID: b2ae40ca8fe8
Revises: d755bad7803f
Create Date: 2021-09-24 08:25:22.631768

é    )ÚopNZb2ae40ca8fe8Zf3cf0170ff35c                   C   sˆ  t  dtjdtjddddtjdtjdd	ddtjd
tjdd	ddtjdtjdd	ddtjdtjdd	ddtjdt ¡ ddtjdt ¡ ddtjdtjddddtjdtjddddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddt 	dgdg¡t 
d¡¡ t jt  d¡ddgdd t jt  d¡dd
gdd t jt  d ¡ddgdd t jt  d!¡ddgdd t jt  d"¡ddgdd t jt  d#¡ddgdd t jt  d$¡ddgdd t jt  d%¡ddgdd t jt  d&¡ddgdd t jt  d'¡ddgdd t jt  d(¡ddgdd t jt  d)¡ddgdd t jt  d*¡ddgdd t jt  d+¡ddgdd t jt  d,¡ddgdd t  d-tjd.tjdddd¡ t jt  d/¡d-d.gdd t  d d-dd.gdg¡ d S )0NÚcmf_contractÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚcache_last_commentsÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idzcmf_import.idÚix_cmf_contract_cmf_author_id)ÚuniqueÚix_cmf_contract_cmf_created_atÚix_cmf_contract_cmf_deletedÚix_cmf_contract_cmf_import_idÚix_cmf_contract_cmf_locked_atÚ ix_cmf_contract_cmf_locked_by_idÚix_cmf_contract_cmf_modified_atÚ"ix_cmf_contract_cmf_modified_by_idÚ&ix_cmf_contract_cmf_owner_assistant_idÚix_cmf_contract_cmf_owner_idÚix_cmf_contract_cmf_versionÚix_cmf_contract_cmf_viewed_atÚix_cmf_contract_codeÚix_cmf_contract_nameÚix_cmf_contract_parent_idÚcmf_dealÚcontract_idÚix_cmf_deal_contract_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚIntegerÚTEXTÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚcreate_foreign_key© r=   r=   ú6/opt/eva-app/alembic/versions/b2ae40ca8fe8_contract.pyÚupgrade   sR    ë r?   c                   C   sj  t jd ddd t jt  d¡dd t  dd¡ t jt  d¡dd t jt  d	¡dd t jt  d
¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t jt  d¡dd t  d¡ d S )Nr,   Ú
foreignkey)Útype_r.   )Ú
table_namer-   r+   r   r*   r)   r(   r'   r&   r%   r$   r#   r"   r!   r    r   r   r   )r   Údrop_constraintÚ
drop_indexr:   Údrop_columnÚ
drop_tabler=   r=   r=   r>   Ú	downgradeA   s&    rG   )Ú__doc__Úalembicr   Ú
sqlalchemyr0   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr?   rG   r=   r=   r=   r>   Ú<module>   s   .