
    \d                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zhdocument sign

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

    )opN07290dc6ee68a0a9bfc49e50c                  j   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      d      t        j                  dt        j                  d      d      t        j                  dgdg      t        j                  dgdg      t        j                  d      	       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       y )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     ;/opt/eva-app/alembic/versions/07290dc6ee68_document_sign.pyupgrader!      s*   OO%IIdBIIR(59IId ;eLIIfbiikD1IIk299B/%@IImRYYb1EB]O.?-@C[MO+<?D!	 OOBDD<=?PScRdmrsOOBDD9:<MP]glmOOBDD78:Kk]chir   c                  *   t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       y )Nr   r   )
table_namer   r   )r   
drop_indexr   
drop_tabler   r   r    	downgrader&   %   sZ    MM"$$56CTUMM"$$78EVWMM"$$:;HYZMM#$r   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr!   r&   r   r   r    <module>r.      s3      
j$%r   