
    ]d7                     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)zesec levels

Revision ID: 8aa7fb9145b1
Revises: 09351c542f3a
Create Date: 2023-07-13 11:49:33.816349

    )opN8aa7fb9145b109351c542f3ac            	         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$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                  d+gd1g      t        j                  d.gd2g      t        j                  d        t        j                  t        j                  d3      dd0gd4       t        j                  t        j                  d5      dd&gd4       t        j                  t        j                  d6      dd
gd4       t        j                  t        j                  d7      ddgd4       t        j                  t        j                  d8      dd+gd4       t        j                  t        j                  d9      ddgd4       t        j                  t        j                  d:      dd*gd4       t        j                  t        j                  d;      ddgd4       t        j                  t        j                  d<      dd)gd4       t        j                  t        j                  d=      dd'gd4       t        j                  t        j                  d>      ddgd4       t        j                  t        j                  d?      ddgd4       t        j                  t        j                  d@      ddgd4       t        j                  t        j                  dA      ddgd4       t        j                  t        j                  dB      ddgd4       t        j                  t        j                  dC      dd(gd4       t        j                  t        j                  dD      dd.gd4       t        j                  t        j                  dE      dd/gd4       t        j                  t        j                  dF      dd-gd4       t        j                  t        j                  dG      dd,gd4       t        j                  dHdIJ       t        j                  dKdIJ       t        j                  dLdIJ       t        j                  dMdIJ       t        j                  dI       t        j                  dNdOJ       t        j                  dPdOJ       t        j                  dQdOJ       t        j                  dRdOJ       t        j                  dO       t        j                   dSdT       t        j                   dSdU       t        j                   dSdV       t        j                   dSd$       t        j                   dSdW       t        j                   dSdX       t        j                   dSdY       t        j                   dSdZ       t        j                   dSd[       t        j                   dSd\       t        j                   dSd]       y )^Ncmf_security_level_rule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_security_level_allowed_ids_cacheperm_encryptaccess_task_fieldsaccess_readonly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access_members_idzcmf_import.idzcmf_access_list.id,ix_cmf_security_level_rule_access_members_idunique(ix_cmf_security_level_rule_cmf_author_id)ix_cmf_security_level_rule_cmf_created_at&ix_cmf_security_level_rule_cmf_deleted(ix_cmf_security_level_rule_cmf_import_id(ix_cmf_security_level_rule_cmf_locked_at+ix_cmf_security_level_rule_cmf_locked_by_id*ix_cmf_security_level_rule_cmf_modified_at-ix_cmf_security_level_rule_cmf_modified_by_id'ix_cmf_security_level_rule_cmf_owner_id&ix_cmf_security_level_rule_cmf_version(ix_cmf_security_level_rule_cmf_viewed_atix_cmf_security_level_rule_codeix_cmf_security_level_rule_name"ix_cmf_security_level_rule_orderno$ix_cmf_security_level_rule_parent_id&ix_cmf_security_level_rule_perm_acl_id)ix_cmf_security_level_rule_perm_parent_id)ix_cmf_security_level_rule_root_parent_id)ix_cmf_security_level_rule_tree_parent_id.ix_cmf_security_level_cmf_project_role_left_id#cmf_security_level_cmf_project_role
table_name0ix_cmf_security_level_cmf_project_role_parent_id/ix_cmf_security_level_cmf_project_role_right_id.ix_cmf_security_level_cmf_project_role_root_id,ix_cmf_security_level_access_members_left_id!cmf_security_level_access_members.ix_cmf_security_level_access_members_parent_id-ix_cmf_security_level_access_members_right_id,ix_cmf_security_level_access_members_root_idcmf_security_levelaccess_guestaccess_sdesk_clientaccess_anonymousaccess_responsibleaccess_local_useraccess_owneraccess_owner_assistantaccess_project_owneraccess_sharelink_anonymousaccess_author)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerForeignKeyConstraintPrimaryKeyConstraintcreate_indexf
drop_index
drop_tabledrop_column     8/opt/eva-app/alembic/versions/8aa7fb9145b1_sec_levels.pyupgraderv      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 II5rwwy4P5,6 IInbjjlT:7,8 II"BGGI=9,: II>;,< IIoryy3dC=,> IInbiir2TB?,@ IIk299B/%@A,B II"BIIR$84HC,D II "))2"6FE,F IIoryy3dCG,H II		 4tDI,J II		 4tDK,L IImRYYb1DAM,N II		 4tDO,P II!299B#7$GQ,R _-/@CS,T ]O.B-CFU,V D!W,Z OOBDDGHJcfyez  DI  JOOBDDCDF_bqar  |A  BOOBDDDEG`csbt  ~C  DOOBDDABD]`m_nw|}OOBDDCDF_bqar  |A  BOOBDDCDF_bqar  |A  BOOBDDFGIbewdx  BG  HOOBDDEFHaducv  @E  FOOBDDHIKdg{f|  FK  LOOBDDBCE^ao`py~OOBDDABD]`m_nw|}OOBDDCDF_bqar  |A  BOOBDD:;=VY_X`imnOOBDD:;=VY_X`inoOOBDD=>@Y\e[fotuOOBDD?@B[^i]jsxyOOBDDABD]`m_nw|}OOBDDDEG`csbt  ~C  DOOBDDDEG`csbt  ~C  DOOBDDDEG`csbt  ~C  DMMBOtuMMDQvwMMCPuvMMBOtuMM78MM@MpqMMBOrsMMANqrMM@MpqMM56NN'8NN')>?NN');<NN')=>NN')=>NN')<=NN'8NN')ABNN')?@NN')EFNN'9rt   c                  X   t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  d	t        j                         dd             t        j                  dt        j                  d
t        j                         dd             t        j                  dt        j                  dt        j
                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dd      
       t        j                  d ddgd!       t        j                  d"ddgd!       t        j                  d#ddgd!       t        j                  d$ddgd!       t        j                  d%t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dgd&gd'      t        j                  dgd(gd)      t        j                  dd*             t        j                  d+d%dgd!       t        j                  d,d%dgd!       t        j                  d-d%dgd!       t        j                  d.d%dgd!       t        j                  t        j                  d/      d01       t        j                  t        j                  d2      d01       t        j                  t        j                  d3      d01       t        j                  t        j                  d4      d01       t        j                  t        j                  d5      d01       t        j                  t        j                  d6      d01       t        j                  t        j                  d7      d01       t        j                  t        j                  d8      d01       t        j                  t        j                  d9      d01       t        j                  t        j                  d:      d01       t        j                  t        j                  d;      d01       t        j                  t        j                  d<      d01       t        j                  t        j                  d=      d01       t        j                  t        j                  d>      d01       t        j                  t        j                  d?      d01       t        j                  t        j                  d@      d01       t        j                  t        j                  dA      d01       t        j                  t        j                  dB      d01       t        j                  t        j                  dC      d01       t        j                  t        j                  dD      d01       t        j                  d0       y )ENrX   rb   F)autoincrementr   ra   r`   r_   r^   r]   r\   r)   Tr[   rZ   rY   rT   r      r
   r-   r	   root_iddescriptioni   left_idright_idleft_name_cacher   right_name_cache&cmf_security_level_access_members_pkey)r   rW   r7   rV   rU   rS   rM   zcmf_security_level.id0cmf_security_level_cmf_project_role_left_id_fkeyzcmf_project_role.id1cmf_security_level_cmf_project_role_right_id_fkey(cmf_security_level_cmf_project_role_pkeyrR   rQ   rP   rL   rK   r   rN   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r6   )r   
add_columnrd   re   BOOLEANrj   rc   VARCHARrm   rn   rl   rp   ro   rq   rs   rt   ru   	downgrader   n   s   MM&		/2::<_dot(uvMM&		2NPRPZPZP\lq  }B  )C  DMM&		2H"**,fkv{(|}MM&		2JBJJLhmx}(~MM&		."**,^cns(tuMM&		2Erzz|chsx(yzMM&		2F

dity(z{MM&		2F	afqu(vwMM&		2Dbjjlbgrw(xyMM&		2Gejuz({|MM&		."**,^cns(tuOO7IIdBJJc*%%PIIk2::R0PTUIIi2.edSIImRZZt4ETXYIIi2.edSIIj"**B/utTII3!7uW[\II "**C"8X\]D'OP
 OOBDgjsit  ~C  DOOCEhkujv  @E  FOODFilwkx  BG  HOOBDgjsit  ~C  DOO9IIdBJJc*%%PIIk2::R0PTUIIi2.edSIImRZZt4ETXYIIi2.edSIIj"**B/utTII3!7uW[\II "**C"8X\]YK*A)BI{|ZL+@*AH{|D'QR OODFknwmx  BG  HOOEGloynz  DI  JOOFHmp{o|  FK  LOODFknwmx  BG  HMM"$$BCPijMM"$$BCPijMM"$$BCPijMM"$$?@MfgMM"$$=>KdeMM"$$;<IbcMM"$$89F_`MM"$$89F_`MM"$$ABOhiMM"$$?@MfgMM"$$@ANghMM"$$FGTmnMM"$$CDQjkMM"$$DERklMM"$$ABOhiMM"$$ABOhiMM"$$?@MfgMM"$$BCPijMM"$$ABOhiMM"$$EFSlmMM+,rt   )__doc__alembicr   
sqlalchemyrd   revisiondown_revisionbranch_labels
depends_onrv   r   rs   rt   ru   <module>r      s5      
W:vA-rt   