
    ]dK                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zktimesehets_teams

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

    )opNf56a57f9a7e94defc9be4de7c                  04   t        j                  g dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                         d      t        j                  d#t        j                  d$      t        j                  d%      d&      t        j                  d't        j                  d      d      t        j                  d(t        j                  d      d      t        j                  d)t        j                  d      d      t        j                  d*t        j                  d      d      t        j                  d+t        j                  d      d      t        j                  d,t        j                  d      d      t        j                  d-t        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d/t        j                  d      d      t        j                  d0t        j                  d      d      t        j                  d1t        j                  d      d      t        j                  d,gd2g      t        j                  d1gd3g      t        j                  d/gd4g      t        j                  d        t        j                  t        j                  d5      dd'gd6       t        j                  t        j                  d7      dd
gd6       t        j                  t        j                  d8      ddgd6       t        j                  t        j                  d9      dd,gd6       t        j                  t        j                  d:      ddgd6       t        j                  t        j                  d;      dd+gd6       t        j                  t        j                  d<      ddgd6       t        j                  t        j                  d=      dd*gd6       t        j                  t        j                  d>      dd(gd6       t        j                  t        j                  d?      ddgd6       t        j                  t        j                  d@      ddgd6       t        j                  t        j                  dA      ddgd6       t        j                  t        j                  dB      dd1gd6       t        j                  t        j                  dC      ddgd6       t        j                  t        j                  dD      ddgd6       t        j                  t        j                  dE      dd)gd6       t        j                  t        j                  dF      dd/gd6       t        j                  t        j                  dG      dd0gd6       t        j                  t        j                  dH      dd.gd6       t        j                  t        j                  dI      dd-gd6       t        j                  g dJt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                         d      t        j                  dKt        j                         dLd&      t        j                  dMt        j                         d      t        j                  dNt        j                         d      t        j                  d't        j                  d      d      t        j                  d(t        j                  d      d      t        j                  d)t        j                  d      d      t        j                  d*t        j                  d      d      t        j                  d+t        j                  d      d      t        j                  d,t        j                  d      d      t        j                  d-t        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d/t        j                  d      d      t        j                  d0t        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dPt        j                  d      d      t        j                  d,gd2g      t        j                  d)gdQg      t        j                  d/gd4g      t        j                  dPgd3g      t        j                  dOgdRg      t        j                  d        t        j                  t        j                  dS      dJd'gd6       t        j                  t        j                  dT      dJd
gd6       t        j                  t        j                  dU      dJdgd6       t        j                  t        j                  dV      dJd,gd6       t        j                  t        j                  dW      dJdgd6       t        j                  t        j                  dX      dJd+gd6       t        j                  t        j                  dY      dJdgd6       t        j                  t        j                  dZ      dJd*gd6       t        j                  t        j                  d[      dJd(gd6       t        j                  t        j                  d\      dJdgd6       t        j                  t        j                  d]      dJdgd6       t        j                  t        j                  d^      dJdgd6       t        j                  t        j                  d_      dJdgd6       t        j                  t        j                  d`      dJdgd6       t        j                  t        j                  da      dJd)gd6       t        j                  t        j                  db      dJd/gd6       t        j                  t        j                  dc      dJd0gd6       t        j                  t        j                  dd      dJdPgd6       t        j                  t        j                  de      dJdOgd6       t        j                  t        j                  df      dJd.gd6       t        j                  t        j                  dg      dJd-gd6       t        j                  dht        j                  dt        j                  di      d      t        j                  d)t        j                  d      d      t        j                  djt        j                  d      d      t        j                  dkt        j                  dl      d      t        j                  dmt        j                  d      d      t        j                  dnt        j                  d      d      t        j                  dot        j                  d      d      t        j                  dpt        j                  d      d      t        j                  d      
       t        j                  t        j                  dq      dhdmgd6       t        j                  t        j                  dr      dhd)gd6       t        j                  t        j                  ds      dhdngd6       t        j                  t        j                  dt      dhdjgd6       t        j                  dut        j                  dt        j                  di      d      t        j                  d)t        j                  d      d      t        j                  djt        j                  d      d      t        j                  dkt        j                  dl      d      t        j                  dmt        j                  d      d      t        j                  dnt        j                  d      d      t        j                  dot        j                  d      d      t        j                  dpt        j                  d      d      t        j                  d      
       t        j                  t        j                  dv      dudmgd6       t        j                  t        j                  dw      dud)gd6       t        j                  t        j                  dx      dudngd6       t        j                  t        j                  dy      dudjgd6       y )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_at0ix_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     >/opt/eva-app/alembic/versions/f56a57f9a7e9_timesehets_teams.pyupgrader      s   OO +) +IIdBIIR(59+IIor||T:TJ+ IId ;eL+ IIt!<uM	+
 IIor||T:TJ+ IImRZZ\E:+ IImRYY[48+ IIfbiis+d;+ IIfbiir*T:+ IIh

u5+ IIfbggi$/+ II=+ IIT:+ IIh		d3+ IImRZZ\D9+  II

t<!+" II#RZZ\DA#+$ IImRZZ\D9%+& IIi5'+( IImRZZ\D9)+* IInbjjlT:++, IInbjjlT:-+. II$biir&:TJ/+0 II#RYYb%9DI1+2 II%ryy';dK3+4 IInbjjlT:5+6 IIk299B/@Xchi7+8 IIoryy3dC9+: IInbiir2TB;+< IIk299B/$?=+> II"BIIR$84H?+@ II "))2"6FA+B IIoryy3dCC+D II		 4tDE+F II		 4tDG+H IImRYYb1DAI+J II		 4tDK+L IIi"-=M+N _-/@CO+P YK/):=Q+R ]O.B-CFS+T D!U+X OOBDD?@BWZiYjsxyOOBDD@ACX[kZluz{OOBDD=>@UXeWfotuOOBDD?@BWZiYjsxyOOBDD?@BWZiYjsxyOOBDDBCEZ]o\py~OOBDDABDY\m[nw|}OOBDDDEG\_s^t  ~C  DOOBDD>?AVYgXhqvwOOBDD=>@UXeWfotuOOBDD?@BWZiYjsxyOOBDD679NQWPXaefOOBDD9:<QT]S^glmOOBDD679NQWPXafgOOBDD9:<QT]S^glmOOBDD;<>SVaUbkpqOOBDD=>@UXeWfotuOOBDD@ACX[kZluz{OOBDD@ACX[kZluz{OOBDD@ACX[kZluz{OO 00 0IIdBIIR(590IIor||T:TJ0 IId ;eL0 IIt!<uM	0
 IIor||T:TJ0 IImRZZ\E:0 IImRYY[480 IIfbiis+d;0 IIfbiir*T:0 IIh

u50 IIfbggi$/0 II=0 IIT:0 IIh		d30 IImRZZ\D90  II

t<!0" II#RZZ\DA#0$ IImRZZ\D9%0& IIi5'0( IImRZZ\D9)0* IInbjjlT:+0, IInbjjlT:-0. II$biir&:TJ/00 II#RYYb%9DI102 II%ryy';dK304 IInbjjlT:506 IIlBJJLO708 IIlBGGI590: IIj"'')d3;0< IIoryy3dC=0> IInbiir2TB?0@ IIk299B/%@A0B II"BIIR$84HC0D II "))2"6FE0F IIoryy3dCG0H II		 4tDI0J II		 4tDK0L IImRYYb1DAM0N II		 4tDO0P IIi"-=Q0R IIk299B/%@S0T _-/@CU0V [M,D+EHW0X ]O.B-CFY0Z [MO+<?[0\ YK-;]0^ D!_0b OOBDDFGIehwgx  BG  HOOBDDGHJfiyhz  DI  JOOBDDDEGcfset  ~C  DOOBDDFGIehwgx  BG  HOOBDDFGIehwgx  BG  HOOBDDIJLhk}j~  HM  NOOBDDHIKgj{i|  FK  LOOBDDKLNj  nB  mC  LQ  ROOBDDEFHdgufv  @E  FOOBDDDEGcfset  ~C  DOOBDDFGIehwgx  BG  HOOBDD=>@\_e^fostOOBDD=>@\_e^fotuOOBDD@AC_bkaluz{OOBDDBCEadocpy~OOBDDDEGcfset  ~C  DOOBDDGHJfiyhz  DI  JOOBDDBCEadocpy~OOBDD@AC_bkaluz{OOBDDGHJfiyhz  DI  JOOBDDGHJfiyhz  DI  JOO1IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDABDadmcnw|}OOBDDCDFcfqer  |A  BOOBDDBCEbeodpy~OOBDDABDadmcnw|}OO2IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDBCEcfoepy~OOBDDDEGehsgt  ~C  DOOBDDCDFdgqfr  |A  BOOBDDBCEcfoepy~r   c                     t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d	      d       t        j                  t        j                  d
      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d       d       t        j                  t        j                  d!      d       t        j                  d       t        j                  t        j                  d"      d#       t        j                  t        j                  d$      d#       t        j                  t        j                  d%      d#       t        j                  t        j                  d&      d#       t        j                  t        j                  d'      d#       t        j                  t        j                  d(      d#       t        j                  t        j                  d)      d#       t        j                  t        j                  d*      d#       t        j                  t        j                  d+      d#       t        j                  t        j                  d,      d#       t        j                  t        j                  d-      d#       t        j                  t        j                  d.      d#       t        j                  t        j                  d/      d#       t        j                  t        j                  d0      d#       t        j                  t        j                  d1      d#       t        j                  t        j                  d2      d#       t        j                  t        j                  d3      d#       t        j                  t        j                  d4      d#       t        j                  t        j                  d5      d#       t        j                  t        j                  d6      d#       t        j                  d#       y )7Nrv   rr   )
table_nameru   rt   rs   rq   rf   rp   ro   rn   re   rJ   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rI   r   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r5   )r   
drop_indexr   
drop_tabler   r   r   	downgrader      s   MM"$$@ANlmMM"$$ABOmnMM"$$BCPnoMM"$$@ANlmMM01MM"$$?@MjkMM"$$@ANklMM"$$ABOlmMM"$$?@MjkMM/0MM"$$EFSopMM"$$EFSopMM"$$>?LhiMM"$$@ANjkMM"$$EFSopMM"$$BCPlmMM"$$@ANjkMM"$$>?LhiMM"$$;<IefMM"$$;<IefMM"$$DERnoMM"$$BCPlmMM"$$CDQmnMM"$$IJWstMM"$$FGTpqMM"$$GHUqrMM"$$DERnoMM"$$DERnoMM"$$BCPlmMM"$$EFSopMM"$$DERnoMM./MM"$$>?LabMM"$$>?LabMM"$$>?LabMM"$$;<I^_MM"$$9:G\]MM"$$78EZ[MM"$$45BWXMM"$$78EZ[MM"$$45BWXMM"$$=>K`aMM"$$;<I^_MM"$$<=J_`MM"$$BCPefMM"$$?@MbcMM"$$@ANcdMM"$$=>K`aMM"$$=>K`aMM"$$;<I^_MM"$$>?LabMM"$$=>K`aMM'(r   )__doc__alembicr   
sqlalchemyrx   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s5      
e@R6)r   