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 )
zaopenid

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

é    )ÚopNÚ5c62730317a5Ú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Ú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_encryptÚapp_typeé    Úcreate_new_userÚ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Ú	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_sessionÚ
user_loginÚ
user_emailé€   Úuser_idÚ	auth_dateÚreauth_dateÚlifetimeÚblockedÚexpiredÚcheckedÚ
two_factorÚsms_codeÚsms_send_timeÚsms_try_countÚsms_try_timeÚjwtÚ	client_ip)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© rg   rg   ú4/opt/eva-app/alembic/versions/5c62730317a5_openid.pyÚupgrade   sª    Õ-îri   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 )NÚcmf_task_queueÚtime_estimateFT)Úautoincrementr	   rH   rG   r   )Ú
table_namerF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r3   )r   Ú
add_columnr[   r\   ÚINTEGERÚ
drop_tableÚ
drop_indexrf   rg   rg   rg   rh   Ú	downgradem   s.    
rr   )Ú__doc__Úalembicr   Ú
sqlalchemyr[   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onri   rr   rg   rg   rg   rh   Ú<module>   s   Z