U
    NÃ@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 )
zaopenid

Revision ID: 5c62730317a5
Revises: 882b484dda5c
Create Date: 2023-04-11 15:11:11.111449

é    )ÚopNZ5c62730317a5Z882b484dda5cc                0   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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jd$d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 
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d0gdd5 t jt  dG¡dd-gdd5 t jt  dH¡dd,gdd5 t  dItjdtjddddtjdJtjddddtjdKtjdLdddtjdMt ¡ ddtjdNtjdd	ddtjdOtjdd	ddtjdPt 	¡ ddtjdQt ¡ ddtjdRt ¡ ddtjdSt ¡ ddtjdTtjd$dddtjdUtjd$dddtjdVtjdd	ddtjdWt 	¡ ddtjdXtjdd	ddtjdYt ¡ ddtjdZtjd$dddt d¡¡ d S )[NÚcmf_auth_open_id_pluginÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextZimport_originalZimport_raw_jsonZext_idZis_favoriteZhas_tree_nodesZtree_node_is_branchZtree_hiddenÚordernoZperm_publicZperm_has_aclZperm_inheritZperm_parent_owner_idZperm_inherit_acl_idZperm_effective_acl_idZperm_encryptZapp_typeé    Zcreate_new_userÚcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idZcmf_import_idZtree_parent_idZroot_parent_idZperm_acl_idZperm_parent_idZ	plugin_idzcmf_import.idzcmf_access_list.idzcmf_plugin.idÚ(ix_cmf_auth_open_id_plugin_cmf_author_id)ÚuniqueÚ)ix_cmf_auth_open_id_plugin_cmf_created_atÚ&ix_cmf_auth_open_id_plugin_cmf_deletedÚ(ix_cmf_auth_open_id_plugin_cmf_import_idÚ(ix_cmf_auth_open_id_plugin_cmf_locked_atÚ+ix_cmf_auth_open_id_plugin_cmf_locked_by_idÚ*ix_cmf_auth_open_id_plugin_cmf_modified_atÚ-ix_cmf_auth_open_id_plugin_cmf_modified_by_idÚ'ix_cmf_auth_open_id_plugin_cmf_owner_idÚ&ix_cmf_auth_open_id_plugin_cmf_versionÚ(ix_cmf_auth_open_id_plugin_cmf_viewed_atÚix_cmf_auth_open_id_plugin_codeÚix_cmf_auth_open_id_plugin_nameÚ"ix_cmf_auth_open_id_plugin_ordernoÚ$ix_cmf_auth_open_id_plugin_parent_idÚ&ix_cmf_auth_open_id_plugin_perm_acl_idÚ)ix_cmf_auth_open_id_plugin_perm_parent_idÚ$ix_cmf_auth_open_id_plugin_plugin_idÚ)ix_cmf_auth_open_id_plugin_root_parent_idÚ)ix_cmf_auth_open_id_plugin_tree_parent_idÚcmf_sessionZ
user_loginZ
user_emailé€   Zuser_idZ	auth_dateZreauth_dateZlifetimeZblockedZexpiredÚcheckedZ
two_factorZsms_codeZsms_send_timeZsms_try_countZsms_try_timeZjwtZ	client_ip)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© r@   r@   ú0/opt/crm/alembic/versions/5c62730317a5_openid.pyÚupgrade   sª    Õ-îrB   c                	   C   sÆ  t  dtjd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  d¡ d S )NZcmf_task_queueZtime_estimateFT)Úautoincrementr   r0   r/   r   )Ú
table_namer.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r$   r#   r"   r!   r    r   r   r   r   )r   Ú
add_columnr4   r5   ÚINTEGERÚ
drop_tableÚ
drop_indexr?   r@   r@   r@   rA   Ú	downgradem   s.    
rI   )Ú__doc__Úalembicr   Ú
sqlalchemyr4   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrB   rI   r@   r@   r@   rA   Ú<module>   s   Z