U
    ]Úd¹t  ã                   @   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 )
zdSDesk SLA

Revision ID: 81f94b797e0a
Revises: 9ed53447673f
Create Date: 2023-02-20 10:20:34.177245

é    )ÚopNZ81f94b797e0aZ9ed53447673fc                ;   C   s  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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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jddddt 
d*gd/g¡t 
d'gd0g¡t 
d-gd1g¡t d¡¡* t jt  d2¡dd%gdd3 t jt  d4¡dd
gdd3 t jt  d5¡ddgdd3 t jt  d6¡dd*gdd3 t jt  d7¡ddgdd3 t jt  d8¡dd)gdd3 t jt  d9¡ddgdd3 t jt  d:¡dd(gdd3 t jt  d;¡dd&gdd3 t jt  d<¡ddgdd3 t jt  d=¡ddgdd3 t jt  d>¡ddgdd3 t jt  d?¡ddgdd3 t jt  d@¡ddgdd3 t jt  dA¡dd'gdd3 t jt  dB¡dd-gdd3 t jt  dC¡dd.gdd3 t jt  dD¡dd,gdd3 t jt  dE¡dd+gdd3 t  dFt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dGt 	¡ ddtjdHt ¡ ddtjdIt ¡ 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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 
d*gd/g¡t 
d'gdJg¡t 
d-gd1g¡t d¡¡, t jt  dK¡dFd%gdd3 t jt  dL¡dFd
gdd3 t jt  dM¡dFdgdd3 t jt  dN¡dFd*gdd3 t jt  dO¡dFdgdd3 t jt  dP¡dFd)gdd3 t jt  dQ¡dFdgdd3 t jt  dR¡dFd(gdd3 t jt  dS¡dFd&gdd3 t jt  dT¡dFdgdd3 t jt  dU¡dFdgdd3 t jt  dV¡dFdgdd3 t jt  dW¡dFdgdd3 t jt  dX¡dFdgdd3 t jt  dY¡dFd'gdd3 t jt  dZ¡dFd-gdd3 t jt  d[¡dFd.gdd3 t jt  d\¡dFd,gdd3 t jt  d]¡dFd+gdd3 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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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jddddtjd.tjddddtjdatjddddt 
d*gd/g¡t 
d'gdJg¡t 
d-gd1g¡t 
dagdbg¡t d¡¡- t jt  dc¡d^d%gdd3 t jt  dd¡d^d
gdd3 t jt  de¡d^dgdd3 t jt  df¡d^d*gdd3 t jt  dg¡d^dgdd3 t jt  dh¡d^d)gdd3 t jt  di¡d^dgdd3 t jt  dj¡d^d(gdd3 t jt  dk¡d^d&gdd3 t jt  dl¡d^dgdd3 t jt  dm¡d^dgdd3 t jt  dn¡d^dgdd3 t jt  do¡d^dgdd3 t jt  dp¡d^dgdd3 t jt  dq¡d^d'gdd3 t jt  dr¡d^d-gdd3 t jt  ds¡d^d.gdd3 t jt  dt¡d^d,gdd3 t jt  du¡d^d+gdd3 t jt  dv¡d^dagdd3 t  dwt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dxtjdd	ddtjdytjdd	ddtjdzt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jdd	ddtjd€t 	¡ ddtjdt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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jddddtjd‚tjddddtjdƒtjddddt 
d*gd/g¡t 
d'gd„g¡t 
d-gd1g¡t 
dƒgd…g¡t 
d‚gdJg¡t d¡¡7 t jt  d†¡dwd%gdd3 t jt  d‡¡dwd
gdd3 t jt  dˆ¡dwdgdd3 t jt  d‰¡dwd*gdd3 t jt  dŠ¡dwdgdd3 t jt  d‹¡dwd)gdd3 t jt  dŒ¡dwdgdd3 t jt  d¡dwd(gdd3 t jt  dŽ¡dwd&gdd3 t jt  d¡dwdgdd3 t jt  d¡dwdgdd3 t jt  d‘¡dwdgdd3 t jt  d’¡dwdgdd3 t jt  d“¡dwdgdd3 t jt  d”¡dwd'gdd3 t jt  d•¡dwd-gdd3 t jt  d–¡dwd.gdd3 t jt  d—¡dwd,gdd3 t jt  d˜¡dwdƒgdd3 t jt  d™¡dwd‚gdd3 t jt  dš¡dwd+gdd3 d S )›NÚcmf_s_desk_slaÚ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Úwidget_typeé    Úcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚroot_parent_idÚperm_acl_idÚperm_parent_idzcmf_import.idzcmf_project.idzcmf_access_list.idÚix_cmf_s_desk_sla_cmf_author_id)ÚuniqueÚ ix_cmf_s_desk_sla_cmf_created_atÚix_cmf_s_desk_sla_cmf_deletedÚix_cmf_s_desk_sla_cmf_import_idÚix_cmf_s_desk_sla_cmf_locked_atÚ"ix_cmf_s_desk_sla_cmf_locked_by_idÚ!ix_cmf_s_desk_sla_cmf_modified_atÚ$ix_cmf_s_desk_sla_cmf_modified_by_idÚix_cmf_s_desk_sla_cmf_owner_idÚix_cmf_s_desk_sla_cmf_versionÚix_cmf_s_desk_sla_cmf_viewed_atÚix_cmf_s_desk_sla_codeÚix_cmf_s_desk_sla_nameÚix_cmf_s_desk_sla_ordernoÚix_cmf_s_desk_sla_parent_idÚix_cmf_s_desk_sla_perm_acl_idÚ ix_cmf_s_desk_sla_perm_parent_idÚ ix_cmf_s_desk_sla_root_parent_idÚ ix_cmf_s_desk_sla_tree_parent_idÚcmf_s_desk_sla_goalÚ	goal_timeÚubqlÚbqlzcmf_s_desk_sla.idÚ$ix_cmf_s_desk_sla_goal_cmf_author_idÚ%ix_cmf_s_desk_sla_goal_cmf_created_atÚ"ix_cmf_s_desk_sla_goal_cmf_deletedÚ$ix_cmf_s_desk_sla_goal_cmf_import_idÚ$ix_cmf_s_desk_sla_goal_cmf_locked_atÚ'ix_cmf_s_desk_sla_goal_cmf_locked_by_idÚ&ix_cmf_s_desk_sla_goal_cmf_modified_atÚ)ix_cmf_s_desk_sla_goal_cmf_modified_by_idÚ#ix_cmf_s_desk_sla_goal_cmf_owner_idÚ"ix_cmf_s_desk_sla_goal_cmf_versionÚ$ix_cmf_s_desk_sla_goal_cmf_viewed_atÚix_cmf_s_desk_sla_goal_codeÚix_cmf_s_desk_sla_goal_nameÚix_cmf_s_desk_sla_goal_ordernoÚ ix_cmf_s_desk_sla_goal_parent_idÚ"ix_cmf_s_desk_sla_goal_perm_acl_idÚ%ix_cmf_s_desk_sla_goal_perm_parent_idÚ%ix_cmf_s_desk_sla_goal_root_parent_idÚ%ix_cmf_s_desk_sla_goal_tree_parent_idÚcmf_s_desk_sla_triggerÚtrigger_typeÚtrigger_conditionÚ trigger_condition_status_code_idzcmf_status_code.idÚ'ix_cmf_s_desk_sla_trigger_cmf_author_idÚ(ix_cmf_s_desk_sla_trigger_cmf_created_atÚ%ix_cmf_s_desk_sla_trigger_cmf_deletedÚ'ix_cmf_s_desk_sla_trigger_cmf_import_idÚ'ix_cmf_s_desk_sla_trigger_cmf_locked_atÚ*ix_cmf_s_desk_sla_trigger_cmf_locked_by_idÚ)ix_cmf_s_desk_sla_trigger_cmf_modified_atÚ,ix_cmf_s_desk_sla_trigger_cmf_modified_by_idÚ&ix_cmf_s_desk_sla_trigger_cmf_owner_idÚ%ix_cmf_s_desk_sla_trigger_cmf_versionÚ'ix_cmf_s_desk_sla_trigger_cmf_viewed_atÚix_cmf_s_desk_sla_trigger_codeÚix_cmf_s_desk_sla_trigger_nameÚ!ix_cmf_s_desk_sla_trigger_ordernoÚ#ix_cmf_s_desk_sla_trigger_parent_idÚ%ix_cmf_s_desk_sla_trigger_perm_acl_idÚ(ix_cmf_s_desk_sla_trigger_perm_parent_idÚ(ix_cmf_s_desk_sla_trigger_root_parent_idÚ(ix_cmf_s_desk_sla_trigger_tree_parent_idÚ:ix_cmf_s_desk_sla_trigger_trigger_condition_status_code_idÚcmf_s_desk_sla_cycleÚ
start_timeÚbreach_timeÚ	stop_timeÚbreachedÚpausedÚwithin_calendar_hoursÚelapsed_timeÚelapsed_time__addon_startÚremaining_timeÚremaining_time__addon_startÚsla_idÚsla_goal_idzcmf_task.idzcmf_s_desk_sla_goal.idÚ%ix_cmf_s_desk_sla_cycle_cmf_author_idÚ&ix_cmf_s_desk_sla_cycle_cmf_created_atÚ#ix_cmf_s_desk_sla_cycle_cmf_deletedÚ%ix_cmf_s_desk_sla_cycle_cmf_import_idÚ%ix_cmf_s_desk_sla_cycle_cmf_locked_atÚ(ix_cmf_s_desk_sla_cycle_cmf_locked_by_idÚ'ix_cmf_s_desk_sla_cycle_cmf_modified_atÚ*ix_cmf_s_desk_sla_cycle_cmf_modified_by_idÚ$ix_cmf_s_desk_sla_cycle_cmf_owner_idÚ#ix_cmf_s_desk_sla_cycle_cmf_versionÚ%ix_cmf_s_desk_sla_cycle_cmf_viewed_atÚix_cmf_s_desk_sla_cycle_codeÚix_cmf_s_desk_sla_cycle_nameÚix_cmf_s_desk_sla_cycle_ordernoÚ!ix_cmf_s_desk_sla_cycle_parent_idÚ#ix_cmf_s_desk_sla_cycle_perm_acl_idÚ&ix_cmf_s_desk_sla_cycle_perm_parent_idÚ&ix_cmf_s_desk_sla_cycle_root_parent_idÚ#ix_cmf_s_desk_sla_cycle_sla_goal_idÚix_cmf_s_desk_sla_cycle_sla_idÚ&ix_cmf_s_desk_sla_cycle_tree_parent_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/81f94b797e0a_sdesk_sla.pyÚupgrade   s   ×+Õ-Ô.Ê8r£   c                   C   sX  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  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  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 jt  d7¡d,d t jt  d8¡d,d t jt  d9¡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  d,¡ t jt  dA¡dBd t jt  dC¡dBd t jt  dD¡dBd t jt  dE¡dBd t jt  dF¡dBd t jt  dG¡dBd t jt  dH¡dBd t jt  dI¡dBd t jt  dJ¡dBd t jt  dK¡dBd t jt  dL¡dBd t jt  dM¡dBd t jt  dN¡dBd t jt  dO¡dBd t jt  dP¡dBd t jt  dQ¡dBd t jt  dR¡dBd t jt  dS¡dBd t jt  dT¡dBd t  dB¡ d S )UNrq   rZ   )Ú
table_namerp   ro   rn   rm   rl   rk   rj   ri   rh   rg   rf   re   rd   rc   rb   ra   r`   r_   r^   rY   rC   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   r“   rr   r’   r‘   r   r   rŽ   r   rŒ   r‹   rŠ   r‰   rˆ   r‡   r†   r…   r„   rƒ   r‚   r   r€   r   rB   r   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r/   )r   Ú
drop_indexr    Ú
drop_tabler¡   r¡   r¡   r¢   Ú	downgrade%  s¦    


r§   )Ú__doc__Úalembicr   Ú
sqlalchemyr•   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr£   r§   r¡   r¡   r¡   r¢   Ú<module>   s     