U
    Ef`                     @   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)
postgresqlZ66a3b835f9e1Z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_id2ix_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	   rP   r   rg   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#   rN   rO   r)   r*   r+   r,   r-   r.   r/   r0   r1   r2   r3   Zestimater   r4   Z(cmf_task_time_history_cmf_import_id_fkey)r   r5   Z&cmf_task_time_history_perm_acl_id_fkeyr6   Z"cmf_task_time_history_task_id_fkeyZcmf_task_time_history_pkeyr~   r8   r}   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   rf   re   rM   rh   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rL   r   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r7   )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    "