U
    päVcR  ã                   @   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: f8d7a3e4db71
Revises: cce0a79830d6
Create Date: 2022-09-09 11:31:42.634938

é    )ÚopNÚf8d7a3e4db71Zcce0a79830d6c                K   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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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  dHt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dId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dJtjdKdddtjdLtjdMdddtjdNtjdMdddtjdOtjdMdddtjdPtjdMdddtjdQtjdKdddtjdRt ¡ ddtjdSt 	¡ ddtjdTt 	¡ ddtjdUt 	¡ ddtjdVt 	¡ ddtjdWtjdd	ddtjdXt ¡ ddtjdYt ¡ ddtjdZt ¡ 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datjdKdddtjdbt ¡ ddtjdct ¡ ddtjddt ¡ ddtjdet ¡ ddtjdft ¡ ddtjdgt ¡ ddtjdht ¡ ddtjdit ¡ ddtjdjtjdKd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dktjddddt 
d,gd1g¡t 
d.gd2g¡t 
dkgdlg¡t d¡¡G t jt  dm¡dHd&gdd4 t jt  dn¡dHd
gdd4 t jt  do¡dHdgdd4 t jt  dp¡dHd,gdd4 t jt  dq¡dHdgdd4 t jt  dr¡dHd+gdd4 t jt  ds¡dHdgdd4 t jt  dt¡dHd*gdd4 t jt  du¡dHd(gdd4 t jt  dv¡dHd'gdd4 t jt  dw¡dHdgdd4 t jt  dx¡dHdgdd4 t jt  dy¡dHdgdd4 t jt  dz¡dHdgdd4 t jt  d{¡dHdgdd4 t jt  d|¡dHdgdd4 t jt  d}¡dHd)gdd4 t jt  d~¡dHd.gdd4 t jt  d¡dHd/gdd4 t jt  d€¡dHdkgdd4 t jt  d¡dHd-gdd4 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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 d¡¡ 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  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  dtjdt ¡ dd¡ t  dtjd‘t ¡ dd¡ t  dtjd’t ¡ dd¡ t  dtjd“t ¡ dd¡ t  dtjd”t ¡ dd¡ d S )•NÚcmf_auth_externalÚ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Ú	sync_lastÚ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_idZauth_plugin_idzcmf_import.idzcmf_access_list.idÚ#ix_cmf_auth_external_auth_plugin_id)ÚuniqueÚ"ix_cmf_auth_external_cmf_author_idÚ#ix_cmf_auth_external_cmf_created_atÚ ix_cmf_auth_external_cmf_deletedÚ"ix_cmf_auth_external_cmf_import_idÚ"ix_cmf_auth_external_cmf_locked_atÚ%ix_cmf_auth_external_cmf_locked_by_idÚ$ix_cmf_auth_external_cmf_modified_atÚ'ix_cmf_auth_external_cmf_modified_by_idÚ+ix_cmf_auth_external_cmf_owner_assistant_idÚ!ix_cmf_auth_external_cmf_owner_idÚ ix_cmf_auth_external_cmf_versionÚ"ix_cmf_auth_external_cmf_viewed_atÚix_cmf_auth_external_codeÚix_cmf_auth_external_ext_idÚix_cmf_auth_external_ordernoÚix_cmf_auth_external_parent_idÚ ix_cmf_auth_external_perm_acl_idÚ#ix_cmf_auth_external_perm_parent_idÚ#ix_cmf_auth_external_tree_parent_idÚcmf_auth_ldap_pluginé   Údirectory_typeé    Úbase_dni   ÚdomainÚuser_dnÚgroup_dnÚmodeÚenable_subgroupsÚsync_intervalÚread_timeoutÚsearch_timeoutÚconnection_timeoutÚ	sync_dateÚuser_object_classÚuser_object_class_filterÚuser_full_name_attrÚuser_rdn_attrÚuser_name_attrÚuser_last_name_attrÚuser_display_name_attrÚuser_email_attrÚuser_password_attrÚuser_password_cryptÚuser_uid_attrÚgroup_object_classÚgroup_object_class_filterÚgroup_name_attrÚgroup_desc_attrÚgroup_users_attrÚuser_groups_attrÚuse_user_groups_attrÚorg_nameÚ	plugin_idzcmf_plugin.idÚ%ix_cmf_auth_ldap_plugin_cmf_author_idÚ&ix_cmf_auth_ldap_plugin_cmf_created_atÚ#ix_cmf_auth_ldap_plugin_cmf_deletedÚ%ix_cmf_auth_ldap_plugin_cmf_import_idÚ%ix_cmf_auth_ldap_plugin_cmf_locked_atÚ(ix_cmf_auth_ldap_plugin_cmf_locked_by_idÚ'ix_cmf_auth_ldap_plugin_cmf_modified_atÚ*ix_cmf_auth_ldap_plugin_cmf_modified_by_idÚ.ix_cmf_auth_ldap_plugin_cmf_owner_assistant_idÚ$ix_cmf_auth_ldap_plugin_cmf_owner_idÚ#ix_cmf_auth_ldap_plugin_cmf_versionÚ%ix_cmf_auth_ldap_plugin_cmf_viewed_atÚix_cmf_auth_ldap_plugin_codeÚix_cmf_auth_ldap_plugin_ext_idÚix_cmf_auth_ldap_plugin_nameÚix_cmf_auth_ldap_plugin_ordernoÚ!ix_cmf_auth_ldap_plugin_parent_idÚ#ix_cmf_auth_ldap_plugin_perm_acl_idÚ&ix_cmf_auth_ldap_plugin_perm_parent_idÚ!ix_cmf_auth_ldap_plugin_plugin_idÚ&ix_cmf_auth_ldap_plugin_tree_parent_idÚcmf_global_varÚix_cmf_global_var_cmf_author_idÚ ix_cmf_global_var_cmf_created_atÚix_cmf_global_var_cmf_deletedÚix_cmf_global_var_cmf_locked_atÚ"ix_cmf_global_var_cmf_locked_by_idÚ!ix_cmf_global_var_cmf_modified_atÚ$ix_cmf_global_var_cmf_modified_by_idÚ(ix_cmf_global_var_cmf_owner_assistant_idÚix_cmf_global_var_cmf_owner_idÚix_cmf_global_var_cmf_versionÚix_cmf_global_var_cmf_viewed_atÚix_cmf_global_var_parent_idÚcmf_authÚreg_org_name_listÚ
allow_ldapÚ
allow_baseÚallow_gmailÚallow_yandex)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_column© rŸ   rŸ   ú2/opt/account/alembic/versions/f8d7a3e4db71_ldap.pyÚupgrade   s€   Ô.ºHòr¡   c                   C   s‚  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  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  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 jt  d7¡d,d	 t jt  d8¡d,d	 t jt  d9¡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 )@Nr‹   r   r   rŽ   r   rŒ   rŠ   r~   )Ú
table_namer‰   rˆ   r‡   r†   r…   r„   rƒ   r‚   r   r€   r   r}   rF   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   ri   rE   r   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r1   )r   Údrop_columnÚ
drop_indexr   Ú
drop_tablerŸ   rŸ   rŸ   r    Ú	downgradeØ   sz    

r¦   )Ú__doc__Úalembicr   Ú
sqlalchemyr’   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr¡   r¦   rŸ   rŸ   rŸ   r    Ú<module>   s    F