U
    päVc‹#  ã                   @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd„ Zd	d
„ ZdS )z_ldap

Revision ID: 34183a1400de
Revises: f92ee225e374
Create Date: 2022-09-13 08:29:48.670370

é    )ÚopN)Ú
postgresqlÚ34183a1400deÚf92ee225e374c                   C   sr  t jddd t jddd t jddd t jddd t jddd t jddd t jd	dd t jd
dd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t  d¡ t  dtjdt ¡ dd¡ t  dd¡ t  dd¡ t  dd¡ t  dd¡ d S )NÚ#ix_cmf_auth_external_auth_plugin_idÚcmf_auth_external)Ú
table_nameÚ"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Úauth_optionsT)ÚnullableÚallow_yandexÚ
allow_ldapÚ
allow_baseÚallow_gmail)r   Ú
drop_indexÚ
drop_tableÚ
add_columnÚsaÚColumnÚTEXTÚdrop_column© r*   r*   ú2/opt/account/alembic/versions/34183a1400de_ldap.pyÚupgrade   s4    
r,   c                1   C   sÂ  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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 ¡ dddtjdt 
¡ dddtjdt ¡ dddtjdtjdddddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjdt ¡ dddtjd t ¡ dddtjd!t ¡ 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 ¡ dddtjd&t ¡ dddtjd't ¡ dddtjd(t ¡ dddtjd)t ¡ dddtjd*t ¡ 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d0tjdddddtjd1tjdddddtjd2tjdddddtjd3tjdddddtjd4tjdddddtjd5tjdddddtjd1gd6gd7d8tjd3gd9gd:d8tjdd;d8¡, t jd<d
d2gdd= t jd>d
d4gdd= t jd?d
d3gdd= t jd@d
d.gdd= t jdAd
dgdd= t jdBd
dgdd= t jdCd
dgdd= t jdDd
dgdd= t jdEd
dgdd= t jdFd
d,gdd= t jdGd
d-gdd= t jdHd
d/gdd= t jdId
dgdd= t jdJd
d0gdd= t jdKd
dgdd= t jdLd
d1gdd= t jdMd
dgdd= t jdNd
dgdd= t jdOd
d+gdd= t jdPd
d5gdd= d S )QNr   r"   FT)Úautoincrementr   r!   r    r   r   r   Úidé@   )ÚlengthÚcmf_locked_at)Ú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_idzcmf_import.idZ$cmf_auth_external_cmf_import_id_fkey)r8   zcmf_access_list.idZ"cmf_auth_external_perm_acl_id_fkeyZcmf_auth_external_pkeyr   )Úuniquer   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r
   r	   r   )r   r%   r&   r'   ÚBOOLEANr)   Úcreate_tableÚVARCHARr   Ú	TIMESTAMPÚBIGINTr(   ÚINTEGERÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexr*   r*   r*   r+   Ú	downgrade2   sŒ    Õ-rc   )Ú__doc__Úalembicr   Ú
sqlalchemyr&   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr,   rc   r*   r*   r*   r+   Ú<module>   s   