U
    päVcè­  ã                   @   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 )
zhempty message

Revision ID: e324133fa8e0
Revises: 854eab3a823b
Create Date: 2022-07-18 12:38:35.090534

é    )ÚopNZe324133fa8e0Ú854eab3a823bc                .   C   s6   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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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d,tjddddtjd-tjddddt 
d)gd.g¡t 
d+gd/g¡t d¡¡( t jt  d0¡dd#gdd1 t jt  d2¡dd
gdd1 t jt  d3¡ddgdd1 t jt  d4¡dd)gdd1 t jt  d5¡ddgdd1 t jt  d6¡dd(gdd1 t jt  d7¡ddgdd1 t jt  d8¡dd'gdd1 t jt  d9¡dd%gdd1 t jt  d:¡dd$gdd1 t jt  d;¡ddgdd1 t jt  d<¡ddgdd1 t jt  d=¡ddgdd1 t jt  d>¡ddgdd1 t jt  d?¡dd-gdd1 t jt  d@¡ddgdd1 t jt  dA¡dd&gdd1 t jt  dB¡dd+gdd1 t jt  dC¡dd,gdd1 t jt  dD¡dd*gdd1 t  dEt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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dFt ¡ ddtjdGt ¡ ddtjdHt ¡ ddtjdIt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 
d)gd.g¡t 
d&gd/g¡t 
d+gd/g¡t d¡¡* t jt  dJ¡dEd#gdd1 t jt  dK¡dEd
gdd1 t jt  dL¡dEdgdd1 t jt  dM¡dEd)gdd1 t jt  dN¡dEdgdd1 t jt  dO¡dEd(gdd1 t jt  dP¡dEdgdd1 t jt  dQ¡dEd'gdd1 t jt  dR¡dEd%gdd1 t jt  dS¡dEd$gdd1 t jt  dT¡dEdgdd1 t jt  dU¡dEdgdd1 t jt  dV¡dEdgdd1 t jt  dW¡dEdgdd1 t jt  dX¡dEdgdd1 t jt  dY¡dEd&gdd1 t jt  dZ¡dEd+gdd1 t jt  d[¡dEd,gdd1 t jt  d\¡dEd*gdd1 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datjddddtjdbtjddddtjdctjddddtjddtjddddt d¡¡
 t jt  de¡d]dagdd1 t jt  df¡d]d&gdd1 t jt  dg¡d]dbgdd1 t jt  dh¡d]d^gdd1 t  dit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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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 
d)gd.g¡t 
d+gd/g¡t d¡¡$ t jt  dj¡did#gdd1 t jt  dk¡did
gdd1 t jt  dl¡didgdd1 t jt  dm¡did)gdd1 t jt  dn¡didgdd1 t jt  do¡did(gdd1 t jt  dp¡didgdd1 t jt  dq¡did'gdd1 t jt  dr¡did%gdd1 t jt  ds¡did$gdd1 t jt  dt¡didgdd1 t jt  du¡didgdd1 t jt  dv¡didgdd1 t jt  dw¡didgdd1 t jt  dx¡didgdd1 t jt  dy¡did&gdd1 t jt  dz¡did+gdd1 t jt  d{¡did,gdd1 t jt  d|¡did*gdd1 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datjddddtjdbtjddddtjdctjddddtjddtjddddt d¡¡
 t jt  d~¡d}dagdd1 t jt  d¡d}d&gdd1 t jt  d€¡d}dbgdd1 t jt  d¡d}d^gdd1 t  d‚tjdtjdddd¡ t  d‚tjdt ¡ dd¡ t  d‚tjdt ¡ dd¡ t  d‚tjdtjdddd¡ t  d‚tjdtjdddd¡ t  d‚tjdt ¡ dd¡ t  d‚tjdƒt ¡ dd¡ t  d‚tjd„tjdddd¡ t  d‚tjd+tjdddd¡ t  d‚tjd,tjdddd¡ t jt  d…¡d‚dƒgdd1 t jt  d†¡d‚d+gdd1 t jt  d‡¡d‚d,gdd1 t jt  dˆ¡d‚d„gdd1 t  d d‚dd+gdg¡ t  d‰tjdtjdddd¡ t  d‰tjdt ¡ dd¡ t  d‰tjdt ¡ dd¡ t  d‰tjdtjdddd¡ t  d‰tjdtjdddd¡ t  d‰tjdt ¡ dd¡ t  d‰tjd+tjdddd¡ t  d‰tjd,tjdddd¡ t jt  dŠ¡d‰d+gdd1 t jt  d‹¡d‰d,gdd1 t  d d‰dd+gdg¡ t  dŒtjdtjdddd¡ t  dŒtjdt ¡ dd¡ t  dŒtjdt ¡ dd¡ t  dŒtjdtjdddd¡ t  dŒtjdtjdddd¡ t  dŒtjdt ¡ dd¡ t  dŒtjd+tjdddd¡ t  dŒtjd,tjdddd¡ t jt  d¡dŒd+gdd1 t jt  dŽ¡dŒd,gdd1 t  d dŒdd+gdg¡ t  dtjdtjdddd¡ t  dtjdt ¡ dd¡ t  dtjdt ¡ dd¡ t  dtjdtjdddd¡ t  dtjdtjdddd¡ t  dtjdt ¡ dd¡ t  dtjd+tjdddd¡ t  dtjd,tjdddd¡ t jt  d¡dd+gdd1 t jt  d‘¡dd,gdd1 t  d ddd+gdg¡ t  d’tjdtjdddd¡ t  d’tjdt ¡ dd¡ t  d’tjdt ¡ dd¡ t  d’tjdtjdddd¡ t  d’tjdtjdddd¡ t  d’tjdt ¡ dd¡ t  d’tjd+tjdddd¡ t  d’tjd,tjdddd¡ t jt  d“¡d’d+gdd1 t jt  d”¡d’d,gdd1 t  d d’dd+gdg¡ t  d•tjdtjdddd¡ t  d•tjdt ¡ dd¡ t  d•tjdt ¡ dd¡ t  d•tjdtjdddd¡ t  d•tjdtjdddd¡ t  d•tjdt ¡ dd¡ t  d•tjd+tjdddd¡ t  d•tjd,tjdddd¡ t jt  d–¡d•d+gdd1 t jt  d—¡d•d,gdd1 t  d d•dd+gdg¡ t  d˜tjdtjdddd¡ t  d˜tjdt ¡ dd¡ t  d˜tjdt ¡ dd¡ t  d˜tjdtjdddd¡ t  d˜tjdtjdddd¡ t  d˜tjdt ¡ dd¡ t  d˜tjd+tjdddd¡ t  d˜tjd,tjdddd¡ t jt  d™¡d˜d+gdd1 t jt  dš¡d˜d,gdd1 t  d d˜dd+gdg¡ t  d›tjdtjdddd¡ t  d›tjdt ¡ dd¡ t  d›tjdt ¡ dd¡ t  d›tjdtjdddd¡ t  d›tjdtjdddd¡ t  d›tjdt ¡ dd¡ t  d›tjdœtjdddd¡ t  d›tjdt ¡ dd¡ t  d›tjdžt ¡ dd¡ t  d›tjd+tjdddd¡ t  d›tjd,tjdddd¡ t jt  dŸ¡d›dœgdd1 t jt  d ¡d›d+gdd1 t jt  d¡¡d›d,gdd1 t  d d›dd+gdg¡ t  d¢tjdtjdddd¡ t  d¢tjdt ¡ dd¡ t  d¢tjdt ¡ dd¡ t  d¢tjdtjdddd¡ t  d¢tjdtjdddd¡ t  d¢tjdt ¡ dd¡ t  d¢tjd+tjdddd¡ t  d¢tjd,tjdddd¡ t jt  d£¡d¢d+gdd1 t jt  d¤¡d¢d,gdd1 t  d d¢dd+gdg¡ t  d¥tjdtjdddd¡ t  d¥tjdt ¡ dd¡ t  d¥tjdt ¡ dd¡ t  d¥tjdtjdddd¡ t  d¥tjdtjdddd¡ t  d¥tjdt ¡ dd¡ t  d¥tjd+tjdddd¡ t  d¥tjd,tjdddd¡ t jt  d¦¡d¥d+gdd1 t jt  d§¡d¥d,gdd1 t  d d¥dd+gdg¡ t  d¨tjdtjdddd¡ t  d¨tjd
tjdd	dd¡ t jt  d©¡d¨d
gdd1 t jt  dª¡d¨dgdd1 t  d«tjdtjdddd¡ t  d«tjdt ¡ dd¡ t  d«tjdt ¡ dd¡ t  d«tjdtjdddd¡ t  d«tjdtjdddd¡ t  d«tjdt ¡ dd¡ t  d«tjd+tjdddd¡ t  d«tjd,tjdddd¡ t jt  d¬¡d«d+gdd1 t jt  d­¡d«d,gdd1 t  d d«dd+gdg¡ d S )®NÚcmf_access_listÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚordernoÚperm_policyé    Úperm_has_aclÚperm_inheritÚperm_inherit_acl_idÚperm_effective_acl_idÚperm_encryptÚdisabledÚinherit_acl_idÚpolicyÚ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_inherit_parent_idÚobject_owner_idzcmf_import.idzcmf_access_list.idÚ ix_cmf_access_list_cmf_author_id)ÚuniqueÚ!ix_cmf_access_list_cmf_created_atÚix_cmf_access_list_cmf_deletedÚ ix_cmf_access_list_cmf_import_idÚ ix_cmf_access_list_cmf_locked_atÚ#ix_cmf_access_list_cmf_locked_by_idÚ"ix_cmf_access_list_cmf_modified_atÚ%ix_cmf_access_list_cmf_modified_by_idÚ)ix_cmf_access_list_cmf_owner_assistant_idÚix_cmf_access_list_cmf_owner_idÚix_cmf_access_list_cmf_versionÚ ix_cmf_access_list_cmf_viewed_atÚix_cmf_access_list_codeÚix_cmf_access_list_nameÚ"ix_cmf_access_list_object_owner_idÚix_cmf_access_list_ordernoÚix_cmf_access_list_parent_idÚix_cmf_access_list_perm_acl_idÚ)ix_cmf_access_list_perm_inherit_parent_idÚ!ix_cmf_access_list_tree_parent_idÚcmf_access_ruleÚsys_typeÚobject_modelÚobject_fieldsÚaccess_levelÚ ix_cmf_access_rule_cmf_author_idÚ!ix_cmf_access_rule_cmf_created_atÚix_cmf_access_rule_cmf_deletedÚ ix_cmf_access_rule_cmf_import_idÚ ix_cmf_access_rule_cmf_locked_atÚ#ix_cmf_access_rule_cmf_locked_by_idÚ"ix_cmf_access_rule_cmf_modified_atÚ%ix_cmf_access_rule_cmf_modified_by_idÚ)ix_cmf_access_rule_cmf_owner_assistant_idÚix_cmf_access_rule_cmf_owner_idÚix_cmf_access_rule_cmf_versionÚ ix_cmf_access_rule_cmf_viewed_atÚix_cmf_access_rule_codeÚix_cmf_access_rule_nameÚix_cmf_access_rule_ordernoÚix_cmf_access_rule_parent_idÚix_cmf_access_rule_perm_acl_idÚ)ix_cmf_access_rule_perm_inherit_parent_idÚ!ix_cmf_access_rule_tree_parent_idÚcmf_access_rule_subjectsÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheÚright_name_cacheÚ#ix_cmf_access_rule_subjects_left_idÚ%ix_cmf_access_rule_subjects_parent_idÚ$ix_cmf_access_rule_subjects_right_idÚ#ix_cmf_access_rule_subjects_root_idÚcmf_person_groupÚ!ix_cmf_person_group_cmf_author_idÚ"ix_cmf_person_group_cmf_created_atÚix_cmf_person_group_cmf_deletedÚ!ix_cmf_person_group_cmf_import_idÚ!ix_cmf_person_group_cmf_locked_atÚ$ix_cmf_person_group_cmf_locked_by_idÚ#ix_cmf_person_group_cmf_modified_atÚ&ix_cmf_person_group_cmf_modified_by_idÚ*ix_cmf_person_group_cmf_owner_assistant_idÚ ix_cmf_person_group_cmf_owner_idÚix_cmf_person_group_cmf_versionÚ!ix_cmf_person_group_cmf_viewed_atÚix_cmf_person_group_codeÚix_cmf_person_group_nameÚix_cmf_person_group_ordernoÚix_cmf_person_group_parent_idÚix_cmf_person_group_perm_acl_idÚ*ix_cmf_person_group_perm_inherit_parent_idÚ"ix_cmf_person_group_tree_parent_idÚcmf_person_group_rg_membersÚ&ix_cmf_person_group_rg_members_left_idÚ(ix_cmf_person_group_rg_members_parent_idÚ'ix_cmf_person_group_rg_members_right_idÚ&ix_cmf_person_group_rg_members_root_idÚcmf_commentÚinlineÚstatusÚix_cmf_comment_inlineÚix_cmf_comment_perm_acl_idÚ%ix_cmf_comment_perm_inherit_parent_idÚix_cmf_comment_statusÚcmf_documentÚix_cmf_document_perm_acl_idÚ&ix_cmf_document_perm_inherit_parent_idÚcmf_document_historyÚ#ix_cmf_document_history_perm_acl_idÚ.ix_cmf_document_history_perm_inherit_parent_idÚ
cmf_filterÚix_cmf_filter_perm_acl_idÚ$ix_cmf_filter_perm_inherit_parent_idÚ
cmf_importÚix_cmf_import_perm_acl_idÚ$ix_cmf_import_perm_inherit_parent_idÚcmf_linkÚix_cmf_link_perm_acl_idÚ"ix_cmf_link_perm_inherit_parent_idÚ
cmf_notifyÚix_cmf_notify_perm_acl_idÚ$ix_cmf_notify_perm_inherit_parent_idÚ
cmf_personÚloginÚ
user_localÚ
is_supportÚix_cmf_person_loginÚix_cmf_person_perm_acl_idÚ$ix_cmf_person_perm_inherit_parent_idÚcmf_person_varÚix_cmf_person_var_perm_acl_idÚ(ix_cmf_person_var_perm_inherit_parent_idÚ
cmf_pluginÚix_cmf_plugin_perm_acl_idÚ$ix_cmf_plugin_perm_inherit_parent_idÚcmf_shadow_linkÚ!ix_cmf_shadow_link_cmf_created_atÚix_cmf_shadow_link_nameÚcmf_taskÚix_cmf_task_perm_acl_idÚ"ix_cmf_task_perm_inherit_parent_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚcreate_foreign_key© r»   r»   ú./opt/account/alembic/versions/e324133fa8e0_.pyÚupgrade   s¬   Ù)×+÷Ý%÷                                                           r½   c                   C   sž  t jd ddd t jt  d¡dd t jt  d¡dd 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  dd¡ t  dd¡ t jd ddd t jt  d¡dd t jt  d¡dd 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d ddd t jt  d¡dd t jt  d¡dd 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d ddd t jt  d¡dd t jt  d¡dd t jt  d¡dd 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  dd¡ t  dd¡ t  dd¡ t jd d!dd t jt  d"¡d!d t jt  d#¡d!d 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d d$dd t jt  d%¡d$d t jt  d&¡d$d 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d d'dd t jt  d(¡d'd t jt  d)¡d'd 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d d*dd t jt  d+¡d*d t jt  d,¡d*d 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d d-dd t jt  d.¡d-d t jt  d/¡d-d 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d d0dd t jt  d1¡d0d t jt  d2¡d0d t  d0d¡ t  d0d¡ t  d0d	¡ t  d0d
¡ t  d0d¡ t  d0d¡ t  d0d¡ t  d0d¡ t jd d3dd t jt  d4¡d3d t jt  d5¡d3d t jt  d6¡d3d t jt  d7¡d3d t  d3d¡ t  d3d¡ t  d3d8¡ t  d3d9¡ t  d3d	¡ t  d3d
¡ t  d3d¡ t  d3d¡ t  d3d¡ t  d3d¡ 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  dA¡d@d t jt  dB¡d@d t jt  dC¡d@d t jt  dD¡d@d t jt  dE¡d@d t jt  dF¡d@d t jt  dG¡d@d t jt  dH¡d@d t jt  dI¡d@d t jt  dJ¡d@d t jt  dK¡d@d t jt  dL¡d@d t jt  dM¡d@d t jt  dN¡d@d t jt  dO¡d@d t jt  dP¡d@d t jt  dQ¡d@d t jt  dR¡d@d t  d@¡ t jt  dS¡dTd t jt  dU¡dTd t jt  dV¡dTd t jt  dW¡dTd t  dT¡ t jt  dX¡dYd t jt  dZ¡dYd t jt  d[¡dYd t jt  d\¡dYd t jt  d]¡dYd t jt  d^¡dYd t jt  d_¡dYd t jt  d`¡dYd t jt  da¡dYd t jt  db¡dYd t jt  dc¡dYd t jt  dd¡dYd t jt  de¡dYd t jt  df¡dYd t jt  dg¡dYd t jt  dh¡dYd t jt  di¡dYd t jt  dj¡dYd t jt  dk¡dYd t  dY¡ t jt  dl¡dmd t jt  dn¡dmd t jt  do¡dmd t jt  dp¡dmd t jt  dq¡dmd t jt  dr¡dmd t jt  ds¡dmd t jt  dt¡dmd t jt  du¡dmd t jt  dv¡dmd t jt  dw¡dmd t jt  dx¡dmd t jt  dy¡dmd t jt  dz¡dmd t jt  d{¡dmd t jt  d|¡dmd t jt  d}¡dmd t jt  d~¡dmd t jt  d¡dmd t jt  d€¡dmd t  dm¡ d S )Nr©   Ú
foreignkey)Útype_r«   )Ú
table_namerª   r-   r,   r    r   r   r   r   r   r¨   r¦   r§   r   r   r£   r¥   r¤   r    r¢   r¡   r™   rŸ   rž   r   rœ   r›   rš   r–   r˜   r—   r“   r•   r”   r   r’   r‘   r   r   rŽ   rŠ   rŒ   r‹   r‡   r‰   rˆ   r€   r†   r…   r„   rƒ   r‚   r   r   r{   r~   r}   r|   rz   rg   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   ri   rh   rf   r\   re   rd   rc   r[   rD   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rC   r   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r/   )r   Údrop_constraintÚ
drop_indexr¸   Údrop_columnÚ
drop_tabler»   r»   r»   r¼   Ú	downgraden  s˜   



rÅ   )Ú__doc__Úalembicr   Ú
sqlalchemyr­   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr½   rÅ   r»   r»   r»   r¼   Ú<module>   s     ]