U
    \Úd%  ã                   @   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 )
z_ldap

Revision ID: 6d14082c7ee2
Revises: ffac8603544f
Create Date: 2022-09-12 12:24:53.599826

é    )ÚopNÚ6d14082c7ee2Zffac8603544fc                2   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 ¡ 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 ¡ 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d/tjddddtjd0tjddddt 
d+gd1g¡t 
d-gd2g¡t 
d0gd3g¡t d¡¡. t jt  d4¡dd/gdd5 t jt  d6¡dd%gdd5 t jt  d7¡dd
gdd5 t jt  d8¡ddgdd5 t jt  d9¡dd+gdd5 t jt  d:¡ddgdd5 t jt  d;¡dd*gdd5 t jt  d<¡ddgdd5 t jt  d=¡dd)gdd5 t jt  d>¡dd'gdd5 t jt  d?¡dd&gdd5 t jt  d@¡ddgdd5 t jt  dA¡ddgdd5 t jt  dB¡ddgdd5 t jt  dC¡ddgdd5 t jt  dD¡ddgdd5 t jt  dE¡dd(gdd5 t jt  dF¡dd-gdd5 t jt  dG¡dd.gdd5 t jt  dH¡dd0gdd5 t jt  dI¡dd,gdd5 t  dJtjdKtjdLddd¡ t  dMtjdNt ¡ dd¡ t  dMtjdOt ¡ dd¡ t  dMtjdPt ¡ dd¡ t  dMtjdQt ¡ dd¡ t  dMtjdRt ¡ dd¡ t  dMtjdSt ¡ dd¡ t  dTtjdUt ¡ dd¡ d S )VNÚcmf_auth_plugin_dataÚ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ÚloginÚgroupsÚemailÚphoneÚdescÚ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Úauth_plugin_idÚ	person_idzcmf_import.idzcmf_access_list.idzcmf_person.idÚ&ix_cmf_auth_plugin_data_auth_plugin_id)ÚuniqueÚ%ix_cmf_auth_plugin_data_cmf_author_idÚ&ix_cmf_auth_plugin_data_cmf_created_atÚ#ix_cmf_auth_plugin_data_cmf_deletedÚ%ix_cmf_auth_plugin_data_cmf_import_idÚ%ix_cmf_auth_plugin_data_cmf_locked_atÚ(ix_cmf_auth_plugin_data_cmf_locked_by_idÚ'ix_cmf_auth_plugin_data_cmf_modified_atÚ*ix_cmf_auth_plugin_data_cmf_modified_by_idÚ.ix_cmf_auth_plugin_data_cmf_owner_assistant_idÚ$ix_cmf_auth_plugin_data_cmf_owner_idÚ#ix_cmf_auth_plugin_data_cmf_versionÚ%ix_cmf_auth_plugin_data_cmf_viewed_atÚix_cmf_auth_plugin_data_codeÚix_cmf_auth_plugin_data_ext_idÚix_cmf_auth_plugin_data_ordernoÚ!ix_cmf_auth_plugin_data_parent_idÚ#ix_cmf_auth_plugin_data_perm_acl_idÚ&ix_cmf_auth_plugin_data_perm_parent_idÚ!ix_cmf_auth_plugin_data_person_idÚ&ix_cmf_auth_plugin_data_tree_parent_idÚcmf_auth_ldap_pluginÚsync_statusé    Úcmf_global_varÚauth_options_allow_baseÚauth_options_admin_allow_baseÚauth_options_allow_ldapÚauth_options_admin_allow_ldapÚauth_options_allow_oauthÚauth_options_admin_allow_oauthÚ
cmf_personÚauth_options)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_column© rb   rb   ú2/opt/eva-app/alembic/versions/6d14082c7ee2_ldap.pyÚupgrade   s˜    Ó/ rd   c                   C   s  t  dd¡ t  dd¡ t  dd¡ t  dd¡ t  dd¡ t  dd¡ t  dd	¡ t  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 jt  d"¡dd t  d¡ d S )#NrR   rS   rK   rQ   rP   rO   rN   rM   rL   rH   rI   rG   r   )Ú
table_namerF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r2   )r   Údrop_columnÚ
drop_indexr`   Ú
drop_tablerb   rb   rb   rc   Ú	downgraded   s<    ri   )Ú__doc__Úalembicr   Ú
sqlalchemyrU   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrd   ri   rb   rb   rb   rc   Ú<module>   s   Q