
    ]dE                     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)zecomponents

Revision ID: e7916fbdb2bd
Revises: 41eef43ae0f9
Create Date: 2023-06-26 17:26:35.601227

    )opNe7916fbdb2bd41eef43ae0f9c                  -   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      
       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      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                  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      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                  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      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                  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                  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	,      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                  d0t        j                  d	,      d	             t        j                  d&t        j                  d1t        j                         d	             t        j                  d&t        j                  d2t        j                         d             t        j                  d&t        j                  d3t        j                  d)      d	             t        j                  d&t        j                  d4t        j                  d	,      d	             t        j                  d&t        j                  d5t        j                  d	,      d	             t        j                  d&t        j                  d6t        j                  d	,      d	             t        j                  d&t        j                  d7t        j                  d	,      d	             t        j                  d&t        j                  d8t        j                  d	,      d	             t        j                  d&t        j                  d9t        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	             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                  dAt        j                  d)      d             t        j                  d&t        j                  dBt        j                  d)      d             t        j                  d&t        j                  dCt        j                  d)      d	             t        j                  d&t        j                  dDt        j                  d      d	             t        j                  d&t        j                  dEt        j                  d      d	             t        j                  d&t        j                  dFt        j                  d      d	             t        j                  d&t        j                  dGt        j                  d      d	             t        j                  d&t        j                  dHt        j                  d      d	             t        j                  d&t        j                  dIt        j                  d      d	             t        j                  d&t        j                  dJt        j                  d      d	             t        j                  d&t        j                  dKt        j                  d      d	             t        j                  d&t        j                  dLt        j                  d      d	             t        j                  d&t        j                  dMt        j                  d      d	             t        j                  d&t        j                  dNt        j                  d      d	             t        j                  d&t        j                  dOt        j                  d      d	             t        j                  t        j                  dP      d&dNgd       t        j                  t        j                  dQ      d&d4gd       t        j                  t        j                  dR      d&d>gd       t        j                  t        j                  dS      d&dOgd       t        j                  t        j                  dT      d&d<gd       t        j                  t        j                  dU      d&dMgd       t        j                  t        j                  dV      d&dHgd       t        j                  t        j                  dW      d&dJgd       t        j                  t        j                  dX      d&dEgd       t        j                  t        j                  dY      d&d:gd       t        j                  t        j                  dZ      d&d'gd       t        j                  t        j                  d[      d&dFgd       t        j                  t        j                  d\      d&d*gd       t        j                  t        j                  d]      d&dKgd       t        j                  t        j                  d^      d&dGgd       t        j                  t        j                  d_      d&dIgd       t        j                  t        j                  d`      d&dLgd       t        j                  t        j                  da      d&dDgd       t        j                  d d&dbdIgdg       t        j                  d d&dcdNgdg       t        j                  d d&dddJgdg       t        j                  d d&dedEgdg       t        j                  d d&dedDgdg       t        j                  d d&dfdFgdg       t        j                  d d&dgdOgdg       t        j                  d d&dhdGgdg       y )iN"cmf_component_cmf_owner_assistantsid   )lengthF)nullable	parent_id@   Troot_iddescriptioni   left_idright_idleft_name_cache   right_name_cache-ix_cmf_component_cmf_owner_assistants_left_id)unique/ix_cmf_component_cmf_owner_assistants_parent_id.ix_cmf_component_cmf_owner_assistants_right_id-ix_cmf_component_cmf_owner_assistants_root_idcmf_component_executors"ix_cmf_component_executors_left_id$ix_cmf_component_executors_parent_id#ix_cmf_component_executors_right_id"ix_cmf_component_executors_root_idcmf_component_local_links$ix_cmf_component_local_links_left_id&ix_cmf_component_local_links_parent_id%ix_cmf_component_local_links_right_id$ix_cmf_component_local_links_root_idcmf_component_spectators#ix_cmf_component_spectators_left_id%ix_cmf_component_spectators_parent_id$ix_cmf_component_spectators_right_id#ix_cmf_component_spectators_root_idcmf_componentlogic_prefixui_view_form    parent_logic_prefixstatus_modified_at)timezonestatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymark
alarm_datedeadlineplan_start_dateplan_end_dateperiod_next_dateperiod_intervalis_template
is_penaltycache_status_typecache_fieldsapprovedperm_policyperm_policy_guestperm_policy_anonymousperm_policy_sharelinksharelink_hashworkflow_iddefault_task_workflow_idlogic_type_idscheme_wf_idcmf_owner_assistant_id	status_id
company_idresponsible_idwaiting_for_idcloned_from_idactivity_idcache_status_opt_idix_cmf_component_activity_idix_cmf_component_alarm_dateix_cmf_component_approved$ix_cmf_component_cache_status_opt_id"ix_cmf_component_cache_status_typeix_cmf_component_cloned_from_id'ix_cmf_component_cmf_owner_assistant_idix_cmf_component_company_id)ix_cmf_component_default_task_workflow_idix_cmf_component_is_templateix_cmf_component_logic_prefixix_cmf_component_logic_type_id$ix_cmf_component_parent_logic_prefixix_cmf_component_responsible_idix_cmf_component_scheme_wf_idix_cmf_component_status_idix_cmf_component_waiting_for_idix_cmf_component_workflow_id
cmf_statuscmf_activitycmf_companycmf_workflowcmf_logic_typecmf_status_optcmf_scheme_wf)r   create_tablesaColumnStringPrimaryKeyConstraintcreate_indexf
add_column	TIMESTAMPBooleanIntegerTEXTcreate_foreign_key     8/opt/eva-app/alembic/versions/e7916fbdb2bd_components.pyupgrader|      s   OO8IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDHIKor{q|  FK  LOOBDDJKMqt  tA  JO  POOBDDIJLps}r~  HM  NOOBDDHIKor{q|  FK  LOO-IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD=>@Y\e[fotuOOBDD?@B[^i]jsxyOOBDD>?AZ]g\hqvwOOBDD=>@Y\e[fotuOO/IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD?@B]`i_jsxyOOBDDABD_bmanw|}OOBDD@AC^ak`luz{OOBDD?@B]`i_jsxyOO.IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD>?A[^g]hqvwOOBDD@AC]`k_luz{OOBDD?@B\_i^jsxyOOBDD>?A[^g]hqvwMM/299^RYY[SW#XYMM/299^RYYb=Q\a#bcMM/299-BBIIKZ^#_`MM/299-A2<<Y]C^im#noMM/299-G_cIdos#tuMM/299-Er||]aGbmq#rsMM/299-?W[A\gk#lmMM/299-?W[A\gk#lmMM/299\2::<RV#WXMM/299ZPU#VWMM/299VRYYb5ITX#YZMM/299\2<<QU;Vae#fgMM/299Zt9T_c#deMM/299->VZ@[fj#klMM/299_bllTX>Ydh#ijMM/299-?W[A\gk#lmMM/299->		QS@T_c#deMM/299]BJJLSW#XYMM/299\2::<RV#WXMM/299-@"))SUBVae#fgMM/299^RWWYQU#VWMM/299ZPU#VWMM/299]BIIR<P[`#abMM/299-@"))SUBVaf#ghMM/299-DbiiWYFZej#klMM/299-DbiiWYFZej#klMM/299-=ryyPR?S^b#cdMM/299]BIIR<P[_#`aMM/299-GZ\I]hl#mnMM/299_biir>R]a#bcMM/299^RYYb=Q\`#abMM/299-EryyXZG[fj#klMM/299["))2:NY]#^_MM/299\299B;OZ^#_`MM/299-=ryyPR?S^b#cdMM/299-=ryyPR?S^b#cdMM/299-=ryyPR?S^b#cdMM/299]BIIR<P[_#`aMM/299-BBIIUWDXcg#hiOOBDD78/M?chiOOBDD67<.afgOOBDD45]bcOOBDD?@/TiSjsxyOOBDD=>ReQfotuOOBDD:;_O_N`inoOOBDDBC_WoVpy~OOBDD67<.afgOOBDDDEYsXt  ~C  DOOBDD78/M?chiOOBDD89?^L\ejkOOBDD9:OoM^glmOOBDD?@/TiSjsxyOOBDD:;_O_N`inoOOBDD89?^L\ejkOOBDD56+_deOOBDD:;_O_N`inoOOBDD78/M?chi$}tfU$-SWRXY$QUPVW$B\A]`d_ef$-SWRXY$1AOCTW[V\]$1ADYCZ]a\bc$>BRUYTZ[rz   c                     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                  d dd       t        j                  d dd       t        j                  d 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                  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       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*       t        j                  dd+       t        j                  dd,       t        j                  dd-       t        j                  dd.       t        j                  dd/       t        j                  dd0       t        j                  dd1       t        j                  dd2       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                  t        j                  d>      d?       t        j                  t        j                  d@      d?       t        j                  t        j                  dA      d?       t        j                  t        j                  dB      d?       t        j
                  d?       t        j                  t        j                  dC      dD       t        j                  t        j                  dE      dD       t        j                  t        j                  dF      dD       t        j                  t        j                  dG      dD       t        j
                  dD       t        j                  t        j                  dH      dI       t        j                  t        j                  dJ      dI       t        j                  t        j                  dK      dI       t        j                  t        j                  dL      dI       t        j
                  dI       t        j                  t        j                  dM      dN       t        j                  t        j                  dO      dN       t        j                  t        j                  dP      dN       t        j                  t        j                  dQ      dN       t        j
                  dN       y )RNr)   
foreignkey)type_rd   )
table_namerc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   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   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   drop_constraint
drop_indexrr   drop_column
drop_tablery   rz   r{   	downgrader      s=   t_LAt_LAt_LAt_LAt_LAt_LAt_LAt_LAMM"$$56?SMM"$$89oVMM"$$34QMM"$$67OTMM"$$89oVMM"$$=>?[MM"$$78_UMM"$$67OTMM"$$56?SMM"$$BCP_`MM"$$45/RMM"$$@Ao^MM"$$89oVMM"$$;<YMM"$$=>?[MM"$$23PMM"$$45/RMM"$$56?SNN?$9:NN?M2NN?$45NN?$45NN?$45NN?L1NN?K0NN?$<=NN?N3NN?O4NN?$>?NN?M2NN?$45NN?$;<NN?$;<NN?$78NN?M2NN?J/NN?N3NN?$78NN?L1NN?M2NN?$56NN?$67NN?O4NN?$56NN?J/NN?L1NN?F+NN?J/NN?L1NN?$67NN?$67NN?$<=NN?$>?NN?$89NN?$9:NN?N3NN?N3MM"$$<=JdeMM"$$=>KefMM"$$>?LfgMM"$$<=JdeMM,-MM"$$=>KfgMM"$$>?LghMM"$$?@MhiMM"$$=>KfgMM-.MM"$$;<IbcMM"$$<=JcdMM"$$=>KdeMM"$$;<IbcMM+,MM"$$FGTxyMM"$$GHUyzMM"$$HIVz{MM"$$FGTxyMM67rz   )__doc__alembicr   
sqlalchemyrm   revisiondown_revisionbranch_labels
depends_onr|   r   ry   rz   r{   <module>r      s6      
~\DV8rz   