U
    ]ÚduJ  ã                   @   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 )
zdTaskQueue

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

é    )ÚopNÚ8b04d6a16e4bÚde0a98fc480bc                `   C   sJ  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 ¡ ddtjdt ¡ ddtjdtjddddtjdtjddddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt 	¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ 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 ¡ ddtjd#t ¡ ddtjd$t ¡ ddtjd%t ¡ ddtjd&t ¡ ddtjd'tjd(dddtjd)t ¡ 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 ¡ ddtjd0t 	¡ ddtjd1tjd(dddtjd2tjdd	ddtjd3tjdd	ddtjd4t 	¡ ddtjd5tjdd	ddtjd6tjdd	ddtjd7tjdd	ddtjd8tjd(dddtjd9t ¡ ddtjd:t ¡ ddtjd;tjd(dddtjd<t ¡ ddtjd=t ¡ 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dAtjd(dddtjdBtjd(dddtjdCtjddddtjdDtjddddtjdEtjddddtjdFtjddddtjdGtjddddtjdHtjddddtjdItjddddtjdJtjddddtjdKtjddddtjdLtjddddtjdMtjddddtjdNtjddddtjdOtjddddtjdPtjddddtjdQtjddddtjdRtjddddtjdStjddddtjdTtjddddtjdUtjddddtjdVtjddddtjdWtjddddtjdXtjddddt 
dVgdYg¡t 
dWgdZg¡t 
dHgd[g¡t 
dRgd\g¡t 
dMgd]g¡t 
dNgd^g¡t 
dJgd_g¡t 
dOgd`g¡t 
dQgdag¡t 
dXgdbg¡t 
dLgd]g¡t d¡¡\ t jt  dc¡ddVgddd t jt  de¡dd2gddd t jt  df¡dd=gddd t jt  dg¡ddWgddd t jt  dh¡dd;gddd t jt  di¡ddUgddd t jt  dj¡ddCgddd t jt  dk¡dd
gddd t jt  dl¡ddgddd t jt  dm¡ddHgddd t jt  dn¡ddgddd t jt  do¡ddGgddd t jt  dp¡ddgddd t jt  dq¡ddFgddd t jt  dr¡ddPgddd t jt  ds¡ddDgddd t jt  dt¡ddgddd t jt  du¡ddgddd t jt  dv¡ddgddd t jt  dw¡ddRgddd t jt  dx¡ddMgddd t jt  dy¡dd9gddd t jt  dz¡dd&gddd t jt  d{¡ddNgddd t jt  d|¡ddgddd t jt  d}¡ddgddd t jt  d~¡ddEgddd t jt  d¡dd)gddd t jt  d€¡ddJgddd t jt  d¡ddKgddd t jt  d‚¡ddSgddd t jt  dƒ¡ddOgddd t jt  d„¡ddQgddd t jt  d…¡ddXgddd t jt  d†¡ddIgddd t jt  d‡¡ddTgddd t jt  dˆ¡ddLgddd t  d‰tjdtjdŠdddtjdEtjddddtjd‹tjddddtjdŒtjddddtjdŽtjddddtjdtjddddtjdtjddddtjd‘tjddddt d¡¡
 t jt  d’¡d‰dŽgddd t jt  d“¡d‰dEgddd t jt  d”¡d‰dgddd t jt  d•¡d‰d‹gddd t  d–tjdtjdŠdddtjdEtjddddtjd‹tjddddtjdŒtjddddtjdŽtjddddtjdtjddddtjdtjddddtjd‘tjddddt d¡¡
 t jt  d—¡d–dŽgddd t jt  d˜¡d–dEgddd t jt  d™¡d–dgddd t jt  dš¡d–d‹gddd t  d›tjdtjdŠdddtjdEtjddddtjd‹tjddddtjdŒtjddddtjdŽtjddddtjdtjddddtjdtjddddtjd‘tjddddt d¡¡
 t jt  dœ¡d›dŽgddd t jt  d¡d›dEgddd t jt  dž¡d›dgddd t jt  dŸ¡d›d‹gddd d S ) 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_idÚ0ix_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© r¤   r¤   ú7/opt/eva-app/alembic/versions/8b04d6a16e4b_taskqueue.pyÚupgrade   s^   ¥]÷÷÷r¦   c                   C   s   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  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  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  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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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  d0¡dd t jt  d1¡dd t jt  d2¡dd t jt  d3¡dd t jt  d4¡dd t jt  d5¡dd t jt  d6¡dd t  d¡ d S )7Nr–   r’   )Ú
table_namer•   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]   r[   )r   Ú
drop_indexr£   Ú
drop_tabler¤   r¤   r¤   r¥   Ú	downgradeÇ   sj    


rª   )Ú__doc__Úalembicr   Ú
sqlalchemyr˜   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr¦   rª   r¤   r¤   r¤   r¥   Ú<module>   s    5