
    ]dDK                     D    d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
d Zd Zy)	z_mail

Revision ID: 528e7d5a5be9
Revises: bc64b34418f1
Create Date: 2023-03-17 16:06:08.772151

    )opN)
postgresql528e7d5a5be9bc64b34418f1c                     t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  d       t        j                  dd       t        j                  d	d       t        j                  d
d       t        j                  dd       t        j                  d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  d       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  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                  d$d       t        j                  d%d       t        j                  d&d       t        j                  d'd       t        j                  d(d       t        j                  d)dd*+       t        j                  d,dd*+       t        j                  d-dd*+       t        j                  d.dd*+       t        j                  d/dd*+       t        j                  d0dd*+       t        j                  d1dd*+       t        j                  d2dd*+       t        j                  dd3       t        j                  dd4       t        j                  dd5       t        j                  dd6       t        j                  dd7       t        j                  dd8       t        j                  dd9       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dA       t        j                  ddB       t        j                  ddC       t        j                  ddD       t        j                  ddE       t        j                  ddF       t        j                  ddG       t        j                  ddH       t        j                  ddI       t        j                  ddJ       t        j                  ddK       t        j                  ddL       t        j                  ddM       t        j                  ddN       t        j                  ddO       t        j                  ddP       t        j                  ddQ       t        j                  ddR       t        j                  ddS       t        j                  ddT       t        j                  ddU       t        j                  ddV       t        j                  ddW       t        j                  ddX       t        j                  ddY       t        j                  ddZ       t        j                  dd[       t        j                  dd\       y )]Nix_cmf_mail_local_links_left_idcmf_mail_local_links)
table_name!ix_cmf_mail_local_links_parent_id ix_cmf_mail_local_links_right_idix_cmf_mail_local_links_root_idix_cmf_mail_executors_left_idcmf_mail_executorsix_cmf_mail_executors_parent_idix_cmf_mail_executors_right_idix_cmf_mail_executors_root_id(ix_cmf_mail_cmf_owner_assistants_left_idcmf_mail_cmf_owner_assistants*ix_cmf_mail_cmf_owner_assistants_parent_id)ix_cmf_mail_cmf_owner_assistants_right_id(ix_cmf_mail_cmf_owner_assistants_root_idix_cmf_mail_spectators_left_idcmf_mail_spectators ix_cmf_mail_spectators_parent_idix_cmf_mail_spectators_right_idix_cmf_mail_spectators_root_idix_cmf_mail_activity_idcmf_mailix_cmf_mail_alarm_dateix_cmf_mail_approvedix_cmf_mail_cache_status_opt_idix_cmf_mail_cache_status_typeix_cmf_mail_cloned_from_id"ix_cmf_mail_cmf_owner_assistant_idix_cmf_mail_company_id$ix_cmf_mail_default_task_workflow_idix_cmf_mail_is_templateix_cmf_mail_logic_prefixix_cmf_mail_logic_type_idix_cmf_mail_parent_logic_prefixix_cmf_mail_responsible_idix_cmf_mail_scheme_wf_idix_cmf_mail_status_idix_cmf_mail_waiting_for_idix_cmf_mail_workflow_idcmf_mail_status_id_fkey
foreignkey)type_cmf_mail_logic_type_id_fkeycmf_mail_workflow_id_fkeycmf_mail_company_id_fkeycmf_mail_scheme_wf_id_fkey!cmf_mail_cache_status_opt_id_fkey&cmf_mail_default_task_workflow_id_fkeycmf_mail_activity_id_fkeystatus_modified_atperiod_intervalperm_policymarkscheme_wf_idplan_end_datestatus_review_at
no_controldefault_task_workflow_idplan_start_datestatus_in_progress_startcmf_owner_assistant_id	is_publicsharelink_hashparent_logic_prefixstatus_in_progress_endapprovedresponsible_idwaiting_for_idis_templatecache_status_opt_idis_public_editabledeadlineis_public_commentscloned_from_idperiod_next_dateperm_policy_guest
alarm_date
is_penalty	status_idcache_status_typestatus_closed_at
company_idcache_fieldsprioritylogic_type_idui_view_formactivity_idperm_policy_sharelinkworkflow_idperm_policy_anonymouslogic_prefix)r   
drop_index
drop_tabledrop_constraintdrop_column     2/opt/eva-app/alembic/versions/528e7d5a5be9_mail.pyupgraderk      s?   MM3@VWMM5BXYMM4AWXMM3@VWMM()MM1>RSMM3@TUMM2?STMM1>RSMM&'MM<IhiMM>KjkMM=JijMM<IhiMM12MM2?TUMM4AVWMM3@UVMM2?TUMM'(MM+
CMM*zBMM(Z@MM3
KMM1jIMM.:FMM6:NMM*zBMM8ZPMM+
CMM,DMM-*EMM3
KMM.:FMM,DMM)jAMM.:FMM+
C0*LQ4jU2JlS1:\R3Z|T:Jl[?S_`2JlSNN:34NN:01NN:}-NN:v&NN:~.NN:/NN:12NN:|,NN:9:NN:01NN:9:NN:78NN:{+NN:/0NN:45NN:78NN:z*NN:/0NN:/0NN:}-NN:45NN:34NN:z*NN:34NN:/0NN:12NN:23NN:|,NN:|,NN:{+NN:23NN:12NN:|,NN:~.NN:z*NN:/NN:~.NN:}-NN:67NN:}-NN:67NN:~.ri   c                  +   t        j                  dt        j                  dt        j                         dd             t        j                  d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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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t        j                  dt        j                         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d             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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d             t        j                  d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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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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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d             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t        j                  d.t        j                  d      dd             t        j                  dt        j                  d/t        j                         dd             t        j                  dt        j                  d0t        j                  d      dd             t        j                  dt        j                  d1t        j                  d      dd             t        j                  dt        j                  d2t        j                  d      dd             t        j                  dt        j                  d3t        j                  d      dd             t        j                  dt        j                  d4t        j                  d      t        j
                  d	      dd
             t        j                  dt        j                  d5t        j                  d      dd             t        j                  dt        j                  d6t        j                  d      dd             t        j                  d7dd8dgd9g       t        j                  d:dd;d.gd9g       t        j                  d<dd=d"gd9g       t        j                  d>dd?d2gd9g       t        j                  d@ddAdgd9g       t        j                  dBdd;dgd9g       t        j                  dCddDdgd9g       t        j                  dEddFdgd9g       t        j                  dGddgdH       t        j                  dIdd$gdH       t        j                  dJddgdH       t        j                  dKdd2gdH       t        j                  dLdd%gdH       t        j                  dMdd(gdH       t        j                  dNddgdH       t        j                  dOddgdH       t        j                  dPdd#gdH       t        j                  dQdd.gdH       t        j                  dRddgdH       t        j                  dSdd+gdH       t        j                  dTddgdH       t        j                  dUddgdH       t        j                  dVdd"gdH       t        j                  dWdd&gdH       t        j                  dXddgdH       t        j                  dYddgdH       t        j                  dZt        j                  d[t        j                  d\      dd      t        j                  d9t        j                  d]      dd      t        j                  d^t        j                  d      dd      t        j                  d_t        j                  d`      dd      t        j                  dat        j                  d      dd      t        j                  dbt        j                  d      dd      t        j                  dct        j                  d`      dd      t        j                  ddt        j                  d      dd      t        j                  d9def      
       t        j                  dgdZddgdH       t        j                  dhdZdbgdH       t        j                  didZdagdH       t        j                  djdZd^gdH       t        j                  dkt        j                  d9t        j                  d]      dd      t        j                  dat        j                  d      dd      t        j                  ddt        j                  d      dd      t        j                  d[t        j                  d\      dd      t        j                  d^t        j                  d      dd      t        j                  dbt        j                  d      dd      t        j                  d_t        j                  d`      dd      t        j                  dct        j                  d`      dd      t        j                  d9dlf      
       t        j                  dmdkddgdH       t        j                  dndkdbgdH       t        j                  dodkdagdH       t        j                  dpdkd^gdH       t        j                  dqt        j                  d[t        j                  d\      dd      t        j                  d9t        j                  d]      dd      t        j                  d^t        j                  d      dd      t        j                  d_t        j                  d`      dd      t        j                  dat        j                  d      dd      t        j                  dbt        j                  d      dd      t        j                  dct        j                  d`      dd      t        j                  ddt        j                  d      dd      t        j                  d9drf      
       t        j                  dsdqddgdH       t        j                  dtdqdbgdH       t        j                  dudqdagdH       t        j                  dvdqd^gdH       t        j                  dwt        j                  d9t        j                  d]      dd      t        j                  dat        j                  d      dd      t        j                  ddt        j                  d      dd      t        j                  d[t        j                  d\      dd      t        j                  d^t        j                  d      dd      t        j                  dbt        j                  d      dd      t        j                  d_t        j                  d`      dd      t        j                  dct        j                  d`      dd      t        j                  d9dxf      
       t        j                  dydwddgdH       t        j                  dzdwdbgdH       t        j                  d{dwdagdH       t        j                  d|dwd^gdH       y )}Nr   rc   FT)autoincrementnullablerb       )lengthz'default'::character varying)server_defaultrm   rn   ra   @   r`   r_   r^   z'mail'::character varyingr]   r\   0r[   rZ   rY   )timezonerX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   cmf_activityidr8   cmf_workflowr7   cmf_status_optr6   cmf_scheme_wfr5   cmf_companyr4   r3   cmf_logic_typer0   
cmf_statusr/   )uniquer.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r$   r#   r"   r!   r    r   r   r   descriptioni      left_idleft_name_cache   	parent_idright_idright_name_cacheroot_idcmf_mail_spectators_pkey)namer   r   r   r   r   "cmf_mail_cmf_owner_assistants_pkeyr   r   r   r   r   cmf_mail_executors_pkeyr   r   r   r   r	   cmf_mail_local_links_pkeyr   r   r   r   )r   
add_columnsaColumnVARCHARtextINTEGERTEXTr   	TIMESTAMPBOOLEANcreate_foreign_keycreate_indexcreate_tablePrimaryKeyConstraintrh   ri   rj   	downgrader   p   s   MM*bii

TYdhijMM*bii(?SUAVgigngn  pN  hO  _d  ot  u  vMM*biirzz7L\alpqrMM*bii(?SUAVgigngn  pN  hO  _d  ot  u  vMM*biirzz7L\alpqrMM*bii

"8M^`^e^e  gB  _C  SX  ch  i  jMM*bii29N^cnrstMM*bii
BJJLQSQXQXY\Q]mr  ~C  D  EMM*bii	QVaefgMM*biibjj6K[`kopqMM*bii(:J<P<PZ^<_ot  @D  E  FMM*bii(;RZZr=RbgrvwxMM*biiRZZr5JZ_jnopMM*biibjjlRWbfghMM*biij6J6JTX6Yiny}~MM*bii(;RZZr=Rcecjcj  lJ  dK  [`  kp  q  rMM*bii(:J<P<PZ^<_ot  @D  E  FMM*bii(8"**B:O_dostuMM*bii(<bjjlZ_jnopMM*bii
J4H4HRV4Wglw{|}MM*bii(<bjjlZ_jnopMM*bii(=rzzQS?TditxyzMM*biirzz|SXcghiMM*bii(8"**B:O_dostuMM*bii(8"**B:O_dostuMM*bii
BJJLPU`efgMM*bii(@*BVBV`dBeuz  FJ  K  LMM*bii(=rzz|[`kopqMM*bii(8"**B:O_dostuMM*biiRZZ\QVaefgMM*bii(@"**TVBWglw{|}MM*bii(BJDXDXbfDgw|  HL  M  NMM*bii(9:;O;OY];^ns  C  D  EMM*bii(BBJJVXDYiny}~MM*biibjjlRWbfghMM*bii(:J<P<PZ^<_ot  @D  E  FMM*bii9M9MW[9\lq  }A  B  CMM*bii

"8M]bmqrsMM*bii

"0EUZeijkMM*biirzz7L]_]d]d  fD  ^E  UZ  ej  k  lMM*bii(92::R;P`eptuvMM*bii(<j>R>R\`>aqv  BF  G  H5z>TaSbeidjkBJP^a{`|  @D  E  F=zK[^s]tw{v|}6
OVdUehlgmn4j-R^Q_bfagh5z>TaSbeidjk7EUXgWhkojpq3ZP[}_c^deOO-zM?SXYOO0*?O>PY^_OO+Z+uUOO.
^<LUZ[OO0*?O>PY^_OO5zDYCZchiOO/o=NW\]OO.
^<LUZ[OO-zM?SXYOO:JIcHdmrsOO,j<.QVWOO8*G_F`inoOO0*?O>PY^_OO3ZBUAV_deOO5zDYCZchiOO*JUSOO,j<.QVWOO-zM?SXYOO)IImRZZt4ETXYIIdBJJc*%%PIIi2.edSII3!7uW[\IIk2::R0PTUIIj"**B/utTII "**C"8X\]IIi2.edSD'AB
 OO46Ki[afgOO57LzlchiOO68MP[}ejkOO46Ki[afgOO3IIdBJJc*%%PIIk2::R0PTUIIi2.edSIImRZZt4ETXYIIi2.edSIIj"**B/utTII3!7uW[\II "**C"8X\]D'KL
 OO>@_bkaluz{OO?A`cmbnw|}OO@Badocpy~OO>@_bkaluz{OO(IImRZZt4ETXYIIdBJJc*%%PIIi2.edSII3!7uW[\IIk2::R0PTUIIj"**B/utTII "**C"8X\]IIi2.edSD'@A
 OO35II;_deOO46JZLafgOO57Kk]chiOO35II;_deOO*IIdBJJc*%%PIIk2::R0PTUIIi2.edSIImRZZt4ETXYIIi2.edSIIj"**B/utTII3!7uW[\II "**C"8X\]D'BC
 OO57MPY{chiOO68NQ[P\ejkOO79OR]Q^glmOO57MPY{chiri   )__doc__alembicr   
sqlalchemyr   sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onrk   r   rh   ri   rj   <module>r      s9      * 
Y/zAjri   