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

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

    )opN6cf95957d1f66113e779a4f9c                     t        j                  dt        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d	t        j                  d      d      t        j                  d
t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      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       t        j                  t        j                  d      dd	gd       t        j                  dt        j                  dt        j                         d             t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  d      d             t        j                  dt        j                  dt        j                  d      dd              t        j                  dt        j                  d!t        j                  d      d             t        j                  dt        j                  d"t        j                         dd#              t        j                  dt        j                  d$t        j                         d             t        j                  dt        j                  d%t        j                         d             t        j                  dt        j                  d&t        j                  d      d             t        j                  dt        j                  d't        j                  d      d             t        j                  dt        j                  d(t        j                  d      d             t        j                  dt        j                  dt        j                  d      d             t        j                  dt        j                  d)t        j                  d      d             t        j                  dt        j                  d*t        j                  d      d             t        j                  dt        j                  d+t        j                  d      d             t        j                  d,d-       t        j                  d.d-       t        j                  t        j                  d/      dd&gd       t        j                  t        j                  d0      dd"gd       t        j                  t        j                  d1      ddgd       t        j                  t        j                  d2      dd*gd       t        j                  t        j                  d3      ddgd       t        j                  t        j                  d4      dd)gd       t        j                  t        j                  d5      dd(gd       t        j                  t        j                  d6      dd'gd       t        j                  t        j                  d7      dd$gd       t        j                  t        j                  d8      dd!gd       t        j                  t        j                  d9      dd%gd       t        j                  t        j                  d:      ddgd       t        j                  t        j                  d;      dd+gd       t        j                  d<dd=>       t        j                  dd?       t        j                  dd@       y )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unique1ix_cmf_document_history_cmf_person_sign_parent_id0ix_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     ./opt/eva-app/alembic/versions/6cf95957d1f6_.pyupgraderV      s4   OO:IIdBIIR(59IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GYK*C)DGZL+?*@CD! OOBDDJKMsv  vA  JO  POOBDDLMOu  yD  xE  NS  TOOBDDKLNt  xB  wC  LQ  ROOBDDJKMsv  vA  JO  PMM("))4JBIIKbf*ghOOBDDGHJ`cybz  DI  JMM#RYYVZ@[fj%klMM#RYY/@",,X\B]hm  F  &G  HMM#RYYVZ@[fj%klMM#RYY}bjjlUZkr%stMM#RYY}biikTX%YZMM#RYY/CRYY[[_%`aMM#RYY		QS@T_c%deMM#RYY~ryyPR?S^b%cdMM#RYY/GZ\I]hl%mnMM#RYY{BIIR<P[_%`aMM#RYY/CRYYVXEYdh%ijMM#RYY/A299TVCWbf%ghMM#RYY/A299TVCWbf%ghMM2?PQMM0=NOOOBDD;<>ORaQbkpqOOBDD9:<MP]glmOOBDD;<>ORaQbkpqOOBDD>?ARUgThqvwOOBDD=>@QTeSfotuOOBDD@ACTWkVluz{OOBDDDEGX[sZt  ~C  DOOBDD:;=NQ_P`inoOOBDD9:<MP]glmOOBDD;<>ORaQbkpqOOBDD@ACTWkVluz{OOBDD78:Kk]chiOOBDD>?ARUgThqvw79JR^_NN$k2NN$m4rT   c            	       
   t        j                  dt        j                  dt        j                  d      dd             t        j                  dt        j                  dt        j                  d      dd             t        j
                  ddd	dgd
g       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  dddgd       t        j                  dddgd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd        t        j                  dd!       t        j                  dd"       t        j                  dd#       t        j                  dd$       t        j                  dd%       t        j                  dd&       t        j                  dd'       t        j                  dd(       t        j                  t        j                  d)      d*       t        j                  d*d+       t        j                  t        j                  d,      d-       t        j                  t        j                  d.      d-       t        j                  t        j                  d/      d-       t        j                  t        j                  d0      d-       t        j                  d-       y )1Nr   rC   r	   r
   F)autoincrementr   rB   r?   
cmf_personr   r>   r/   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r   r.   r-   r,   r+   r   r*   r)   r(   r'   r&   r$   r#   r!   r   r   r   r   r   r   r   r   r   )r   rL   rE   rF   VARCHARcreate_foreign_keyrP   rK   rJ   rR   
drop_tablerS   rT   rU   	downgrader]   J   sK   MM#RYY}bjjPR>Schsx%yzMM#RYY{BJJb<Qafqv%wx:<M|^i]jmqlrsMM"$$<=J[\MM"$$56CTUMM"$$>?L]^MM"$$9:GXYMM"$$78EVWMM"$$89FWXMM"$$BCPabMM"$$>?L]^MM"$$;<IZ[MM"$$<=J[\MM"$$9:GXYMM"$$78EVWMM"$$9:GXYOO24E}]bcOO46G-afgNN$&89NN$&89NN$&:;NN$k2NN$&>?NN$n5NN$o6NN$&:;NN$m4NN$m4NN$o6NN$&78NN$o6MM"$$EFSijNN)+ABMM"$$HIV|}MM"$$IJW}~MM"$$JKX~MM"$$HIV|}MM89rT   )__doc__alembicr   
sqlalchemyrE   revisiondown_revisionbranch_labels
depends_onrV   r]   rS   rT   rU   <module>re      s3      
35n':rT   