U
    ]Úd™7  ã                   @   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 )
zesec levels

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

é    )ÚopNÚ8aa7fb9145b1Ú09351c542f3ac                0   C   sf  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 ¡ 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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¡¡, t jt  d3¡dd0gdd4 t jt  d5¡dd&gdd4 t jt  d6¡dd
gdd4 t jt  d7¡ddgdd4 t jt  d8¡dd+gdd4 t jt  d9¡ddgdd4 t jt  d:¡dd*gdd4 t jt  d;¡ddgdd4 t jt  d<¡dd)gdd4 t jt  d=¡dd'gdd4 t jt  d>¡ddgdd4 t jt  d?¡ddgdd4 t jt  d@¡ddgdd4 t jt  dA¡ddgdd4 t jt  dB¡ddgdd4 t jt  dC¡dd(gdd4 t jt  dD¡dd.gdd4 t jt  dE¡dd/gdd4 t jt  dF¡dd-gdd4 t jt  dG¡dd,gdd4 t jdHdIdJ t jdKdIdJ t jdLdIdJ t jdMdIdJ t  dI¡ t jdNdOdJ t jdPdOdJ t jdQdOdJ t jdRdOdJ t  dO¡ t  dSdT¡ t  dSdU¡ t  dSdV¡ t  dSd$¡ t  dSdW¡ t  dSdX¡ t  dSdY¡ t  dSdZ¡ t  dSd[¡ t  dSd\¡ t  dSd]¡ d S )^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_nameÚ0ix_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© rq   rq   ú8/opt/eva-app/alembic/versions/8aa7fb9145b1_sec_levels.pyÚupgrade   s¬    Õ-

rs   c                   C   sX  t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjd	t ¡ ddd¡ t  dtjd
t ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ d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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dd¡
 t j	d ddgdd! t j	d"ddgdd! t j	d#ddgdd! t j	d$ddg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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gd&gd'dtj
dgd(gd)dtjdd*d¡ t j	d+d%dgdd! t j	d,d%dgdd! t j	d-d%dgdd! t j	d.d%dgdd! t jt  d/¡d0d1 t jt  d2¡d0d1 t jt  d3¡d0d1 t jt  d4¡d0d1 t jt  d5¡d0d1 t jt  d6¡d0d1 t jt  d7¡d0d1 t jt  d8¡d0d1 t jt  d9¡d0d1 t jt  d:¡d0d1 t jt  d;¡d0d1 t jt  d<¡d0d1 t jt  d=¡d0d1 t jt  d>¡d0d1 t jt  d?¡d0d1 t jt  d@¡d0d1 t jt  dA¡d0d1 t jt  dB¡d0d1 t jt  dC¡d0d1 t jt  dD¡d0d1 t  d0¡ d S )ENrV   r`   F)Úautoincrementr
   r_   r^   r]   r\   r[   rZ   r'   TrY   rX   rW   rR   r   é€   r   r+   r   Úroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacher   Úright_name_cacheZ&cmf_security_level_access_members_pkey)r   rU   r5   rT   rS   rQ   rK   zcmf_security_level.idZ0cmf_security_level_cmf_project_role_left_id_fkeyzcmf_project_role.idZ1cmf_security_level_cmf_project_role_right_id_fkeyZ(cmf_security_level_cmf_project_role_pkeyrP   rO   rN   rJ   rI   r   rL   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r4   )r   Ú
add_columnrb   rc   ÚBOOLEANrh   ra   ÚVARCHARrk   rl   rj   rn   rm   ro   rq   rq   rq   rr   Ú	downgraden   s€    ÷õr   )Ú__doc__Úalembicr   Ú
sqlalchemyrb   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrs   r   rq   rq   rq   rr   Ú<module>   s   [