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 )
zhempty message

Revision ID: 6cf95957d1f6
Revises: 6113e779a4f9
Create Date: 2022-08-17 20:25:45.517734

é    )ÚopNÚ6cf95957d1f6Ú6113e779a4f9c                   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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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  	dtjdt 
¡ dd¡ t jt  d¡ddgdd t  	dtjdtjdddd¡ t  	dtjdtjddddd ¡ t  	dtjd!tjdddd¡ t  	dtjd"t ¡ dd#d ¡ t  	dtjd$t 
¡ dd¡ t  	dtjd%t 
¡ dd¡ t  	dtjd&tjdddd¡ t  	dtjd'tjdddd¡ t  	dtjd(tjdddd¡ t  	dtjdtjdddd¡ t  	dtjd)tjdddd¡ t  	dtjd*tjdddd¡ t  	dtjd+tjdddd¡ t jd,dd- t jd.dd- t jt  d/¡dd&gdd t jt  d0¡dd"gdd t jt  d1¡ddgdd t jt  d2¡dd*gdd t jt  d3¡ddgdd t jt  d4¡dd)gdd t jt  d5¡dd(gdd t jt  d6¡dd'gdd t jt  d7¡dd$gdd t jt  d8¡dd!gdd t jt  d9¡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d<dd=d> t  dd?¡ t  dd@¡ d S )ANÚ$cmf_document_history_cmf_person_signÚidé@   ©ÚlengthF)ÚnullableÚ	parent_idTÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheé   Úright_name_cachezcmf_document_history.idzcmf_person_sign.idÚ/ix_cmf_document_history_cmf_person_sign_left_id©ÚuniqueÚ1ix_cmf_document_history_cmf_person_sign_parent_idÚ0ix_cmf_document_history_cmf_person_sign_right_idÚ/ix_cmf_document_history_cmf_person_sign_root_idÚcmf_document_historyÚdocument_cmf_versionÚ,ix_cmf_document_history_document_cmf_versionÚcmf_person_signÚcmf_locked_at)ÚtimezoneÚcmf_modified_atzNOW())r
   Úserver_defaultÚcmf_viewed_atÚcmf_deletedÚfalseÚcmf_versionÚobject_cmf_versionÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚcmf_modified_by_idÚcmf_locked_by_idÚsigned_object_idÚix_cmf_person_sign_document_id©Ú
table_nameÚix_cmf_person_sign_person_idÚ ix_cmf_person_sign_cmf_author_idÚix_cmf_person_sign_cmf_deletedÚ ix_cmf_person_sign_cmf_locked_atÚ#ix_cmf_person_sign_cmf_locked_by_idÚ"ix_cmf_person_sign_cmf_modified_atÚ%ix_cmf_person_sign_cmf_modified_by_idÚ)ix_cmf_person_sign_cmf_owner_assistant_idÚix_cmf_person_sign_cmf_owner_idÚix_cmf_person_sign_cmf_versionÚ ix_cmf_person_sign_cmf_viewed_atÚ%ix_cmf_person_sign_object_cmf_versionÚix_cmf_person_sign_parent_idÚ#ix_cmf_person_sign_signed_object_idÚcmf_person_sign_person_id_fkeyÚ
foreignkey)Útype_Ú	person_idÚdocument_id)r   Úcreate_tableÚsaÚColumnÚStringÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚBIGINTÚ	TIMESTAMPÚBooleanÚ
drop_indexÚdrop_constraintÚdrop_column© rQ   rQ   ú./opt/eva-app/alembic/versions/6cf95957d1f6_.pyÚupgrade   sd    õ "        rS   c                	   C   s   t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  ddd	dgd
g¡ 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dddgdd t jdddgdd t  	dd¡ t  	dd¡ t  	dd¡ t  	dd¡ t  	dd ¡ t  	dd!¡ t  	dd"¡ t  	dd#¡ t  	dd$¡ t  	dd%¡ t  	dd&¡ t  	dd'¡ t  	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  d0¡d-d t  
d-¡ d S )1Nr   rA   r   r   F)Úautoincrementr
   r@   r=   Ú
cmf_personr   r<   r-   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r0   r/   r   r,   r+   r*   r)   r   r(   r'   r&   r%   r$   r"   r!   r   r   r   r   r   r   r   r   r   r   )r   rJ   rC   rD   ÚVARCHARÚcreate_foreign_keyrN   rI   rH   rP   Ú
drop_tablerQ   rQ   rQ   rR   Ú	downgradeJ   sL    ""rY   )Ú__doc__Úalembicr   Ú
sqlalchemyrC   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrS   rY   rQ   rQ   rQ   rR   Ú<module>   s   7