U
    ]ÚdK  ã                   @   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 )
zktimesehets_teams

Revision ID: f56a57f9a7e9
Revises: 4defc9be4de7
Create Date: 2023-06-22 14:44:11.131646

é    )ÚopNZf56a57f9a7e9Ú4defc9be4de7c                4   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t 
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jd1tjddddt d,gd2g¡t d1gd3g¡t d/g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d1g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d0gdd6 t jt  dH¡dd.g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 ¡ 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 	¡ dLdd&tjdMt ¡ ddtjdNt ¡ 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jdOtjddddtjdPtjddddt d,gd2g¡t d)gdQg¡t d/gd4g¡t dPgd3g¡t dOgdRg¡t d¡¡0 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[¡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  d`¡dJdgdd6 t jt  da¡dJd)gdd6 t jt  db¡dJd/gdd6 t jt  dc¡dJd0gdd6 t jt  dd¡dJdPgdd6 t jt  de¡dJdOgdd6 t jt  df¡dJd.gdd6 t jt  dg¡dJd-gdd6 t  dhtjdtjdidddtjd)tjddddtjdjtjddddtjdktjdld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 d¡¡
 t jt  dq¡dhdmgdd6 t jt  dr¡dhd)gdd6 t jt  ds¡dhdngdd6 t jt  dt¡dhdjgdd6 t  dutjdtjdidddtjd)tjddddtjdjtjddddtjdktjdld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 d¡¡
 t jt  dv¡dudmgdd6 t jt  dw¡dud)gdd6 t jt  dx¡dudngdd6 t jt  dy¡dudjgdd6 d S )zNÚcmf_timesheets_teamÚ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Ú	team_typeé    z'independent')Úserver_defaultr   Ú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_idÚhead_idzcmf_import.idzcmf_person.idzcmf_access_list.idÚ$ix_cmf_timesheets_team_cmf_author_id)ÚuniqueÚ%ix_cmf_timesheets_team_cmf_created_atÚ"ix_cmf_timesheets_team_cmf_deletedÚ$ix_cmf_timesheets_team_cmf_import_idÚ$ix_cmf_timesheets_team_cmf_locked_atÚ'ix_cmf_timesheets_team_cmf_locked_by_idÚ&ix_cmf_timesheets_team_cmf_modified_atÚ)ix_cmf_timesheets_team_cmf_modified_by_idÚ#ix_cmf_timesheets_team_cmf_owner_idÚ"ix_cmf_timesheets_team_cmf_versionÚ$ix_cmf_timesheets_team_cmf_viewed_atÚix_cmf_timesheets_team_codeÚix_cmf_timesheets_team_head_idÚix_cmf_timesheets_team_nameÚix_cmf_timesheets_team_ordernoÚ ix_cmf_timesheets_team_parent_idÚ"ix_cmf_timesheets_team_perm_acl_idÚ%ix_cmf_timesheets_team_perm_parent_idÚ%ix_cmf_timesheets_team_root_parent_idÚ%ix_cmf_timesheets_team_tree_parent_idÚcmf_timesheets_team_memberÚ
share_partÚ100Ú
date_startÚdate_endÚrole_idÚ	person_idzcmf_timesheets_team.idzcmf_role.idÚ+ix_cmf_timesheets_team_member_cmf_author_idÚ,ix_cmf_timesheets_team_member_cmf_created_atÚ)ix_cmf_timesheets_team_member_cmf_deletedÚ+ix_cmf_timesheets_team_member_cmf_import_idÚ+ix_cmf_timesheets_team_member_cmf_locked_atÚ.ix_cmf_timesheets_team_member_cmf_locked_by_idÚ-ix_cmf_timesheets_team_member_cmf_modified_atÚ0ix_cmf_timesheets_team_member_cmf_modified_by_idÚ*ix_cmf_timesheets_team_member_cmf_owner_idÚ)ix_cmf_timesheets_team_member_cmf_versionÚ+ix_cmf_timesheets_team_member_cmf_viewed_atÚ"ix_cmf_timesheets_team_member_codeÚ"ix_cmf_timesheets_team_member_nameÚ%ix_cmf_timesheets_team_member_ordernoÚ'ix_cmf_timesheets_team_member_parent_idÚ)ix_cmf_timesheets_team_member_perm_acl_idÚ,ix_cmf_timesheets_team_member_perm_parent_idÚ'ix_cmf_timesheets_team_member_person_idÚ%ix_cmf_timesheets_team_member_role_idÚ,ix_cmf_timesheets_team_member_root_parent_idÚ,ix_cmf_timesheets_team_member_tree_parent_idÚcmf_timesheets_team_membersé€   Úroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheÚright_name_cacheÚ&ix_cmf_timesheets_team_members_left_idÚ(ix_cmf_timesheets_team_members_parent_idÚ'ix_cmf_timesheets_team_members_right_idÚ&ix_cmf_timesheets_team_members_root_idÚcmf_timesheets_team_projectsÚ'ix_cmf_timesheets_team_projects_left_idÚ)ix_cmf_timesheets_team_projects_parent_idÚ(ix_cmf_timesheets_team_projects_right_idÚ'ix_cmf_timesheets_team_projects_root_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerr   ÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚDATE© r‚   r‚   ú>/opt/eva-app/alembic/versions/f56a57f9a7e9_timesehets_teams.pyÚupgrade   sH   Ö,Ñ1÷÷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 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  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 )7Nrs   ro   )Ú
table_namerr   rq   rp   rn   rc   rm   rl   rk   rb   rG   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rF   r   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r2   )r   Ú
drop_indexr€   Ú
drop_tabler‚   r‚   r‚   rƒ   Ú	downgrade¼   sj    


rˆ   )Ú__doc__Úalembicr   Ú
sqlalchemyru   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr„   rˆ   r‚   r‚   r‚   rƒ   Ú<module>   s    *