
    B
duJ                     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)zdTaskQueue

Revision ID: 8b04d6a16e4b
Revises: de0a98fc480b
Create Date: 2023-01-30 12:04:33.955215

    )opN8b04d6a16e4bde0a98fc480bc                  `7   t        j                  g 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      t        j                  d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      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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      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      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&t        j                         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,t        j
                  d	      d      t        j                  d-t        j
                  d	      d      t        j                  d.t        j
                  d	      d      t        j                  d/t        j                         d      t        j                  d0t        j                         d      t        j                  d1t        j                  d(      d      t        j                  d2t        j
                  d	      d      t        j                  d3t        j
                  d	      d      t        j                  d4t        j                         d      t        j                  d5t        j
                  d	      d      t        j                  d6t        j
                  d	      d      t        j                  d7t        j
                  d	      d      t        j                  d8t        j                  d(      d      t        j                  d9t        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(      d      t        j                  d@t        j                  d(      d      t        j                  dAt        j                  d(      d      t        j                  dBt        j                  d(      d      t        j                  dCt        j                  d      d      t        j                  dDt        j                  d      d      t        j                  dEt        j                  d      d      t        j                  dFt        j                  d      d      t        j                  dGt        j                  d      d      t        j                  dHt        j                  d      d      t        j                  dIt        j                  d      d      t        j                  dJt        j                  d      d      t        j                  dKt        j                  d      d      t        j                  dLt        j                  d      d      t        j                  dMt        j                  d      d      t        j                  dNt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dPt        j                  d      d      t        j                  dQt        j                  d      d      t        j                  dRt        j                  d      d      t        j                  dSt        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  d      d      t        j                  dVt        j                  d      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dVgdYg      t        j                  dWgdZg      t        j                  dHgd[g      t        j                  dRgd\g      t        j                  dMgd]g      t        j                  dNgd^g      t        j                  dJgd_g      t        j                  dOgd`g      t        j                  dQgdag      t        j                  dXgdbg      t        j                  dLgd]g      t        j                  d        t        j                  t        j                  dc      ddVgdd       t        j                  t        j                  de      dd2gdd       t        j                  t        j                  df      dd=gdd       t        j                  t        j                  dg      ddWgdd       t        j                  t        j                  dh      dd;gdd       t        j                  t        j                  di      ddUgdd       t        j                  t        j                  dj      ddCgdd       t        j                  t        j                  dk      dd
gdd       t        j                  t        j                  dl      ddgdd       t        j                  t        j                  dm      ddHgdd       t        j                  t        j                  dn      ddgdd       t        j                  t        j                  do      ddGgdd       t        j                  t        j                  dp      ddgdd       t        j                  t        j                  dq      ddFgdd       t        j                  t        j                  dr      ddPgdd       t        j                  t        j                  ds      ddDgdd       t        j                  t        j                  dt      ddgdd       t        j                  t        j                  du      ddgdd       t        j                  t        j                  dv      ddgdd       t        j                  t        j                  dw      ddRgdd       t        j                  t        j                  dx      ddMgdd       t        j                  t        j                  dy      dd9gdd       t        j                  t        j                  dz      dd&gdd       t        j                  t        j                  d{      ddNgdd       t        j                  t        j                  d|      ddgdd       t        j                  t        j                  d}      ddgdd       t        j                  t        j                  d~      ddEgdd       t        j                  t        j                  d      dd)gdd       t        j                  t        j                  d      ddJgdd       t        j                  t        j                  d      ddKgdd       t        j                  t        j                  d      ddSgdd       t        j                  t        j                  d      ddOgdd       t        j                  t        j                  d      ddQgdd       t        j                  t        j                  d      ddXgdd       t        j                  t        j                  d      ddIgdd       t        j                  t        j                  d      ddTgdd       t        j                  t        j                  d      ddLgdd       t        j                  dt        j                  dt        j                  d      d      t        j                  dEt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddEgdd       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddgdd       t        j                  dt        j                  dt        j                  d      d      t        j                  dEt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddEgdd       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddgdd       t        j                  dt        j                  dt        j                  d      d      t        j                  dEt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddEgdd       t        j                  t        j                  d      ddgdd       t        j                  t        j                  d      ddgdd       y )Ncmf_task_queueid@   )lengthF)nullablecmf_locked_atT)timezonecmf_created_atcmf_modified_atcmf_viewed_atcmf_deletedcmf_versionname   codesystemtextimport_originalimport_raw_jsonext_idis_favoritehas_tree_nodestree_node_is_branchtree_hiddenordernoperm_publicperm_has_aclperm_inheritperm_parent_owner_idperm_inherit_acl_idperm_effective_acl_idperm_encrypt	is_publicis_public_editableis_public_commentslogic_prefixui_view_form    parent_logic_prefixstatus_modified_atstatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymark
alarm_datedeadlinetime_estimate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cmf_author_idcmf_owner_id	parent_idcmf_modified_by_idcmf_locked_by_idcmf_import_idtree_parent_idperm_acl_idperm_parent_id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task_filter_idzcmf_activity.idzcmf_status_opt.idzcmf_import.idzcmf_company.idzcmf_workflow.idzcmf_logic_type.idzcmf_access_list.idzcmf_scheme_wf.idzcmf_status.idzcmf_task_filter.idix_cmf_task_queue_activity_id)uniqueix_cmf_task_queue_alarm_dateix_cmf_task_queue_approved%ix_cmf_task_queue_cache_status_opt_id#ix_cmf_task_queue_cache_status_type ix_cmf_task_queue_cloned_from_idix_cmf_task_queue_cmf_author_id ix_cmf_task_queue_cmf_created_atix_cmf_task_queue_cmf_deletedix_cmf_task_queue_cmf_import_idix_cmf_task_queue_cmf_locked_at"ix_cmf_task_queue_cmf_locked_by_id!ix_cmf_task_queue_cmf_modified_at$ix_cmf_task_queue_cmf_modified_by_id(ix_cmf_task_queue_cmf_owner_assistant_idix_cmf_task_queue_cmf_owner_idix_cmf_task_queue_cmf_versionix_cmf_task_queue_cmf_viewed_atix_cmf_task_queue_codeix_cmf_task_queue_company_id*ix_cmf_task_queue_default_task_workflow_idix_cmf_task_queue_is_templateix_cmf_task_queue_logic_prefixix_cmf_task_queue_logic_type_idix_cmf_task_queue_nameix_cmf_task_queue_ordernoix_cmf_task_queue_parent_id%ix_cmf_task_queue_parent_logic_prefixix_cmf_task_queue_perm_acl_id ix_cmf_task_queue_perm_parent_id ix_cmf_task_queue_responsible_idix_cmf_task_queue_scheme_wf_idix_cmf_task_queue_status_id ix_cmf_task_queue_task_filter_id ix_cmf_task_queue_tree_parent_id ix_cmf_task_queue_waiting_for_idix_cmf_task_queue_workflow_id#cmf_task_queue_cmf_owner_assistants   root_iddescriptioni   left_idright_idleft_name_cacheright_name_cache.ix_cmf_task_queue_cmf_owner_assistants_left_id0ix_cmf_task_queue_cmf_owner_assistants_parent_id/ix_cmf_task_queue_cmf_owner_assistants_right_id.ix_cmf_task_queue_cmf_owner_assistants_root_idcmf_task_queue_executors#ix_cmf_task_queue_executors_left_id%ix_cmf_task_queue_executors_parent_id$ix_cmf_task_queue_executors_right_id#ix_cmf_task_queue_executors_root_idcmf_task_queue_spectators$ix_cmf_task_queue_spectators_left_id&ix_cmf_task_queue_spectators_parent_id%ix_cmf_task_queue_spectators_right_id$ix_cmf_task_queue_spectators_root_id)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerForeignKeyConstraintPrimaryKeyConstraintcreate_indexf     7/opt/eva-app/alembic/versions/8b04d6a16e4b_taskqueue.pyupgrader      sJ   OO \$ \IIdBIIR(59\IIor||T:TJ\ IId ;eL\ IIt!<uM	\
 IIor||T:TJ\ IImRZZ\E:\ IImRYY[48\ IIfbiis+d;\ IIfbiir*T:\ IIh

u5\ IIfbggi$/\ II=\ IIT:\ IIh		d3\ IImRZZ\D9\  II

t<!\" II#RZZ\DA#\$ IImRZZ\D9%\& IIi5'\( IImRZZ\D9)\* IInbjjlT:+\, IInbjjlT:-\. II$biir&:TJ/\0 II#RYYb%9DI1\2 II%ryy';dK3\4 IInbjjlT:5\6 IIk2::<$77\8 II"BJJL4@9\: II"BJJL4@;\< IInbiikD9=\> IInbiir2UC?\@ II#RYY[4@A\B II"BLL$$?$OC\D II(",,*EPTUE\F II&d(CdSG\H II ",,"=MI\J II ",,"=MK\L IIlBJJL48M\N IIj"**,7O\P IIfbiir*T:Q\R IIlBLL$7$GS\T IIj",,5EU\V IIorzz|d;W\X IIt!<tLY\Z IIor||T:TJ[\\ II ",,"=M]\^ II"!5E_\` IImRZZ\D9a\b IIlBJJL48c\d II!299B#7$Ge\f IInbggi$7g\h IIj"**,7i\j IImRYYb1EBk\l II!299B#7%Hm\n II%ryy';eLo\p II%ryy';eLq\r II		 4tDs\t IIoryy3dCu\v IInbiir2TBw\x IIk299B/$?y\z II"BIIR$84H{\| II "))2"6F}\~ IIoryy3dC\@ II		 4tDA\B IImRYYb1DAC\D II		 4tDE\F IImRYYb1DAG\H II("))2*>NI\J IIoryy3dCK\L IInbiir2TBM\N II&		(<tLO\P IIk299B/$?Q\R IIlBIIR04@S\T II		 4tDU\V II		 4tDW\X II		 4tDY\Z IImRYYb1DA[\\ II#RYYb%9DI]\^ II		 4tD_\` ]O.?-@Ca\b 236I5JMc\d _-/@Ce\f \N-=,>Ag\h 78;L:MPi\j _-0C/DGk\l ]O.B-CFm\n ^,/A.BEo\p [MO+<?q\r -.1E0FIs\t ]O.?-@Cu\v D!w\z OOBDD89;Km_ejkOOBDD78:J\NchiOOBDD568H:,_deOOBDD@ACSVkUluz{OOBDD>?AQTgShqvwOOBDD;<>NQaPbkpqOOBDD:;=MP_O`inoOOBDD;<>NQaPbkpqOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD:;=MP_O`inoOOBDD=>@PSeRfotuOOBDD<=?ORcQdmrsOOBDD?@BRUiTjsxyOOBDDCDFVYqXr  |A  BOOBDD9:<L~N^glmOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD124DvhW[\OOBDD78:J\NchiOOBDDEFHX[uZv  @E  FOOBDD89;Km_ejkOOBDD9:<L~N^glmOOBDD:;=MP_O`inoOOBDD124DvhW\]OOBDD457G)]bcOOBDD679IK=afgOOBDD@ACSVkUluz{OOBDD89;Km_ejkOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpqOOBDD9:<L~N^glmOOBDD679IK=afgOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpqOOBDD89;Km_ejkOO9IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDIJLqt}s~  HM  NOOBDDKLNs  wB  vC  LQ  ROOBDDJKMru  uA  JO  POOBDDIJLqt}s~  HM  N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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yr   c                     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       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       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       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                  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                  d0      d       t        j                  t        j                  d1      d       t        j                  t        j                  d2      d       t        j                  t        j                  d3      d       t        j                  t        j                  d4      d       t        j                  t        j                  d5      d       t        j                  t        j                  d6      d       t        j                  d       y )7Nr   r   )
table_namer   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   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   
drop_indexr   
drop_tabler   r   r   	downgrader      s   MM"$$=>KfgMM"$$>?LghMM"$$?@MhiMM"$$=>KfgMM-.MM"$$<=JdeMM"$$=>KefMM"$$>?LfgMM"$$<=JdeMM,-MM"$$GHUz{MM"$$HIV{|MM"$$IJW|}MM"$$GHUz{MM78MM"$$67DTUMM"$$9:GWXMM"$$9:GWXMM"$$9:GWXMM"$$45BRSMM"$$78EUVMM"$$9:GWXMM"$$9:GWXMM"$$67DTUMM"$$>?L\]MM"$$45BRSMM"$$23@PQMM"$$/0=MNMM"$$89FVWMM"$$78EUVMM"$$67DTUMM"$$CDQabMM"$$56CSTMM"$$/0=MNMM"$$89FVWMM"$$67DTUMM"$$78EUVMM"$$ABO_`MM"$$=>K[\MM"$$:;HXYMM"$$;<IYZMM"$$89FVWMM"$$89FVWMM"$$67DTUMM"$$9:GWXMM"$$89FVWMM"$$9:GWXMM"$$<=JZ[MM"$$>?L\]MM"$$34AQRMM"$$56CSTMM"$$67DTUMM"#r   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s5      
pzh6$r   