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 )
zhdocument sign

Revision ID: 07290dc6ee68
Revises: a0a9bfc49e50
Create Date: 2022-03-29 11:08:15.488600

    )opN07290dc6ee68a0a9bfc49e50c                   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 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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 d S )Ncmf_person_signid@   )lengthF)nullablecmf_created_atT)timezonesign	person_iddocument_idzcmf_document.idzcmf_person.id!ix_cmf_person_sign_cmf_created_at)uniqueix_cmf_person_sign_document_idix_cmf_person_sign_person_id)
r   create_tablesaColumnString	TIMESTAMPForeignKeyConstraintPrimaryKeyConstraintcreate_indexf r   r   ;/opt/eva-app/alembic/versions/07290dc6ee68_document_sign.pyupgrade   s    
r   c                   C   sJ   t jt ddd t jt ddd t jt ddd t d d S )Nr   r   )
table_namer   r   )r   
drop_indexr   
drop_tabler   r   r   r   	downgrade%   s    r"   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r"   r   r   r   r   <module>   s   