U
    \Úd`  ã                   @   sH   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d„ Zd	d
„ ZdS )zhempty message

Revision ID: 66a3b835f9e1
Revises: 67c7d330ecca
Create Date: 2022-10-19 07:28:33.924476

é    )ÚopN)Ú
postgresqlÚ66a3b835f9e1Ú67c7d330eccac                /   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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#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d0tjddddt 
d,gd1g¡t 
d)gd2g¡t 
d.gd3g¡t 
d0gd4g¡t d¡¡+ t jt  d5¡dd&gdd6 t jt  d7¡dd
gdd6 t jt  d8¡ddgdd6 t jt  d9¡dd,gdd6 t jt  d:¡ddgdd6 t jt  d;¡dd+gdd6 t jt  d<¡ddgdd6 t jt  d=¡dd*gdd6 t jt  d>¡dd(gdd6 t jt  d?¡dd'gdd6 t jt  d@¡ddgdd6 t jt  dA¡ddgdd6 t jt  dB¡ddgdd6 t jt  dC¡ddgdd6 t jt  dD¡ddgdd6 t jt  dE¡dd)gdd6 t jt  dF¡dd.gdd6 t jt  dG¡dd/gdd6 t jt  dH¡dd0gdd6 t jt  dI¡dd-gdd6 t  dJt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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dKtjdd	ddtjdLtjdd	ddtjdMt 	¡ 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d1g¡t 
d)gd4g¡t 
d.gd3g¡t d¡¡+ t jt  dN¡dJd&gdd6 t jt  dO¡dJd
gdd6 t jt  dP¡dJdgdd6 t jt  dQ¡dJd,gdd6 t jt  dR¡dJdgdd6 t jt  dS¡dJd+gdd6 t jt  dT¡dJdgdd6 t jt  dU¡dJd*gdd6 t jt  dV¡dJd(gdd6 t jt  dW¡dJd'gdd6 t jt  dX¡dJdgdd6 t jt  dY¡dJdgdd6 t jt  dZ¡dJdgdd6 t jt  d[¡dJdLgdd6 t jt  d\¡dJdgdd6 t jt  d]¡dJdgdd6 t jt  d^¡dJd)gdd6 t jt  d_¡dJd.gdd6 t jt  d`¡dJd/gdd6 t jt  da¡dJdKgdd6 t jt  db¡dJd-gdd6 t jdcddde t jdfddde t jdgddde t jdhddde t jdiddde t jdjddde t jdkddde t jdlddde t jdmddde t jdnddde t jdoddde t jdpddde t jdqddde t jdrddde t jdsddde t jdtddde t jduddde t jdvddde t jdwddde t jdxddde t jdyddde t jdzddde t  dd¡ t  d{tjd|tjd"ddd#d$¡ t  d{tjdMt 	¡ dd}d$¡ t  d{d~¡ t  d{d¡ d S )€NÚcmf_time_trackerÚidé@   ©ÚlengthF)ÚnullableÚcmf_locked_atT©ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚ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Ústatusé    Úopen)r   Úserver_defaultÚplay_start_dateÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚperm_acl_idÚperm_parent_idÚtask_idúcmf_import.idzcmf_person.idúcmf_access_list.idúcmf_task.idÚ!ix_cmf_time_tracker_cmf_author_id©ÚuniqueÚ"ix_cmf_time_tracker_cmf_created_atÚix_cmf_time_tracker_cmf_deletedÚ!ix_cmf_time_tracker_cmf_import_idÚ!ix_cmf_time_tracker_cmf_locked_atÚ$ix_cmf_time_tracker_cmf_locked_by_idÚ#ix_cmf_time_tracker_cmf_modified_atÚ&ix_cmf_time_tracker_cmf_modified_by_idÚ*ix_cmf_time_tracker_cmf_owner_assistant_idÚ ix_cmf_time_tracker_cmf_owner_idÚix_cmf_time_tracker_cmf_versionÚ!ix_cmf_time_tracker_cmf_viewed_atÚix_cmf_time_tracker_codeÚix_cmf_time_tracker_nameÚix_cmf_time_tracker_ordernoÚix_cmf_time_tracker_parent_idÚix_cmf_time_tracker_perm_acl_idÚ"ix_cmf_time_tracker_perm_parent_idÚix_cmf_time_tracker_task_idÚ"ix_cmf_time_tracker_tree_parent_idÚcmf_time_tracker_historyÚ
start_dateÚend_dateÚ
time_spentÚ)ix_cmf_time_tracker_history_cmf_author_idÚ*ix_cmf_time_tracker_history_cmf_created_atÚ'ix_cmf_time_tracker_history_cmf_deletedÚ)ix_cmf_time_tracker_history_cmf_import_idÚ)ix_cmf_time_tracker_history_cmf_locked_atÚ,ix_cmf_time_tracker_history_cmf_locked_by_idÚ+ix_cmf_time_tracker_history_cmf_modified_atÚ.ix_cmf_time_tracker_history_cmf_modified_by_idÚ2ix_cmf_time_tracker_history_cmf_owner_assistant_idÚ(ix_cmf_time_tracker_history_cmf_owner_idÚ'ix_cmf_time_tracker_history_cmf_versionÚ)ix_cmf_time_tracker_history_cmf_viewed_atÚ ix_cmf_time_tracker_history_codeÚ$ix_cmf_time_tracker_history_end_dateÚ ix_cmf_time_tracker_history_nameÚ#ix_cmf_time_tracker_history_ordernoÚ%ix_cmf_time_tracker_history_parent_idÚ'ix_cmf_time_tracker_history_perm_acl_idÚ*ix_cmf_time_tracker_history_perm_parent_idÚ&ix_cmf_time_tracker_history_start_dateÚ*ix_cmf_time_tracker_history_tree_parent_idÚ&ix_cmf_task_time_history_cmf_author_idÚcmf_task_time_history©Ú
table_nameÚ'ix_cmf_task_time_history_cmf_created_atÚ$ix_cmf_task_time_history_cmf_deletedÚ&ix_cmf_task_time_history_cmf_import_idÚ&ix_cmf_task_time_history_cmf_locked_atÚ)ix_cmf_task_time_history_cmf_locked_by_idÚ(ix_cmf_task_time_history_cmf_modified_atÚ+ix_cmf_task_time_history_cmf_modified_by_idÚ/ix_cmf_task_time_history_cmf_owner_assistant_idÚ%ix_cmf_task_time_history_cmf_owner_idÚ$ix_cmf_task_time_history_cmf_versionÚ&ix_cmf_task_time_history_cmf_viewed_atÚix_cmf_task_time_history_codeÚ!ix_cmf_task_time_history_end_dateÚix_cmf_task_time_history_nameÚ ix_cmf_task_time_history_ordernoÚ"ix_cmf_task_time_history_parent_idÚ$ix_cmf_task_time_history_perm_acl_idÚ'ix_cmf_task_time_history_perm_parent_idÚ#ix_cmf_task_time_history_start_dateÚ ix_cmf_task_time_history_task_idÚ'ix_cmf_task_time_history_tree_parent_idÚcmf_taskÚtimetracker_cache_statusÚ0Úcmf_task_playÚ
spent_time)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
drop_indexÚ
drop_tableÚ
add_columnÚdrop_column© r—   r—   ú./opt/eva-app/alembic/versions/66a3b835f9e1_.pyÚupgrade   s8   Ö,Ö,
"r™   c                0   C   s	  t  dtjdt ¡ t d¡ddd¡ t  dtjdt ¡ ddd¡ t  dd	¡ t  dd
¡ t  dtjdtj	dddddtjdt
jdddddtjdt
jdddddtjdt
jdddddtjdt
jdddddtjdt ¡ dddtjdt ¡ dddtjdtj	dddddtjdtj	dddddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjd t ¡ dddtjd!t ¡ dddtjd"t ¡ dddtjd#tj	dddddtjd$tj	dddddtjd%tj	dddddtjd&t ¡ dddtjd't
jdddddtjd(t
jdddddtjd)tj	dddddtjd*tj	dddddtjd+tj	dddddtjd,tj	dddddtjd-tj	dddddtjd.tj	dddddtjd/tj	dddddtjd0tj	dddddtjd1tj	dddddtjd2tj	dddddtjd3tj	dddddtjd4t ¡ t d¡dddtjd5t 	¡ dddtjd/gd6gd7d8tjd1gd9gd:d8tjd3gd;gd<d8tjdd=d8¡+ t jd>dd0gdd? t jd@dd3gdd? t jdAdd'gdd? t jdBdd2gdd? t jdCdd1gdd? t jdDdd,gdd? t jdEddgdd? t jdFddgdd? t jdGdd(gdd? t jdHddgdd? t jdIddgdd? t jdJddgdd? t jdKdd*gdd? t jdLdd+gdd? t jdMdd-gdd? t jdNddgdd? t jdOdd.gdd? t jdPddgdd? t jdQdd/gdd? t jdRddgdd? t jdSddgdd? t jdTdd)gdd? t jt  dU¡dVdW t jt  dX¡dVdW t jt  dY¡dVdW t jt  dZ¡dVdW t jt  d[¡dVdW t jt  d\¡dVdW t jt  d]¡dVdW t jt  d^¡dVdW t jt  d_¡dVdW t jt  d`¡dVdW t jt  da¡dVdW t jt  db¡dVdW t jt  dc¡dVdW t jt  dd¡dVdW t jt  de¡dVdW t jt  df¡dVdW t jt  dg¡dVdW t jt  dh¡dVdW t jt  di¡dVdW t jt  dj¡dVdW t jt  dk¡dVdW t  dV¡ t jt  dl¡dmdW t jt  dn¡dmdW t jt  do¡dmdW t jt  dp¡dmdW t jt  dq¡dmdW t jt  dr¡dmdW t jt  ds¡dmdW t jt  dt¡dmdW t jt  du¡dmdW t jt  dv¡dmdW t jt  dw¡dmdW t jt  dx¡dmdW t jt  dy¡dmdW t jt  dz¡dmdW t jt  d{¡dmdW t jt  d|¡dmdW t jt  d}¡dmdW t jt  d~¡dmdW t jt  d¡dmdW t jt  d€¡dmdW t  dm¡ d S )Nr   r…   rƒ   F)r)   Úautoincrementr   r„   T)rš   r   rR   r‚   ri   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#   r$   r%   rP   rQ   r+   r,   r-   r.   r/   r0   r1   r2   r3   r4   r5   Úestimater   r6   Z(cmf_task_time_history_cmf_import_id_fkey)r   r7   Z&cmf_task_time_history_perm_acl_id_fkeyr8   Z"cmf_task_time_history_task_id_fkeyZcmf_task_time_history_pkeyr€   r:   r   r~   r}   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rh   rg   rO   rj   rf   re   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rN   r   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r9   )r   r•   r‡   rˆ   ÚINTEGERr   ÚBOOLEANr–   r†   ÚVARCHARr   rŠ   rŒ   r   r   r   r‘   r“   r’   r”   r—   r—   r—   r˜   Ú	downgrade´   sâ    &Ö,
rŸ   )Ú__doc__Úalembicr   Ú
sqlalchemyr‡   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr™   rŸ   r—   r—   r—   r˜   Ú<module>   s    "