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

Revision ID: ecc8471fb4f4
Revises: b2ba9386f50c
Create Date: 2022-03-02 11:14:19.283913

é    )ÚopN)Ú
postgresqlÚecc8471fb4f4Úb2ba9386f50cc                )   C   sì  t  dtjdtjddddt d¡¡ 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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d t jt  d¡ddgdd t jt  d¡ddgdd t jt  d¡dd
gdd 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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¡¡ t jt  d-¡dd&gdd t jt  d.¡ddgdd t jt  d/¡ddgdd t jt  d0¡dd+gdd t jt  d1¡ddgdd t jt  d2¡dd*gdd t jt  d3¡ddgdd t jt  d4¡dd)gdd t jt  d5¡dd(gdd t jt  d6¡dd'gdd t jt  d7¡ddgdd t jt  d8¡ddgdd t jt  d9¡dd gd	d t jt  d:¡ddgdd t jt  d;¡ddgdd 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jd@dd	dtjdAt 	¡ 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jdEtjddd	dtjdFtjd@dd	dtjdGtjddd	dtjdHt 
¡ ddtjdItjd@dddtjdJt 
¡ ddtjdKt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¡¡% t jt  dL¡d<dKgdd t jt  dM¡d<d&gdd t jt  dN¡d<dgdd t jt  dO¡d<dgdd t jt  dP¡d<d+gdd t jt  dQ¡d<dgdd t jt  dR¡d<d*gdd t jt  dS¡d<dgdd t jt  dT¡d<d)gdd t jt  dU¡d<d(gdd t jt  dV¡d<d'gdd t jt  dW¡d<dgdd t jt  dX¡d<dgdd t jt  dY¡d<d gd	d t jt  dZ¡d<d>gdd t jt  d[¡d<dgdd t jt  d\¡d<dFgdd t jt  d]¡d<dCgdd t jt  d^¡d<dEgdd t jt  d_¡d<dBgdd t jt  d`¡d<dDgdd t jt  da¡d<dgdd t jt  db¡d<dGgdd t jt  dc¡d<d?gdd t jt  dd¡d<dHgdd 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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¡¡ t jt  df¡ded&gdd t jt  dg¡dedgdd t jt  dh¡dedgdd t jt  di¡ded+gdd t jt  dj¡dedgdd t jt  dk¡ded*gdd t jt  dl¡dedgdd t jt  dm¡ded)gdd t jt  dn¡ded(gdd t jt  do¡ded'gdd t jt  dp¡dedgdd t jt  dq¡dedgdd t jt  dr¡ded gd	d t jt  ds¡dedgdd t jt  dt¡dedgdd t  dutjdtjddddtjdtjd	dddtjdGtjddddtjdBtjddddt dGgdvg¡t d¡¡ t jt  dw¡dudgdd t jt  dx¡dudBgdd t jt  dy¡dudGgdd t  dztjd$t 	¡ d	d¡ t  d{tjd$t 	¡ d	d¡ t  d|tjd$t 	¡ d	d¡ t  d}tjd$t 	¡ d	d¡ t  d~tjd$t 	¡ d	d¡ t  dtjd$t 	¡ d	d¡ t  d€tjd$t 	¡ d	d¡ d S )NÚcmf_global_settingsÚidé@   )ÚlengthF)ÚnullableÚcmf_person_var_favoritesÚ	parent_idTÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheé   Úright_name_cacheÚ#ix_cmf_person_var_favorites_left_id)ÚuniqueÚ%ix_cmf_person_var_favorites_parent_idÚ$ix_cmf_person_var_favorites_right_idÚ#ix_cmf_person_var_favorites_root_idÚcmf_linkÚcmf_locked_at)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameÚcodeÚsystemÚtextÚcache_last_commentsÚis_favoriteÚurlÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idzcmf_import.idÚix_cmf_link_cmf_author_idÚix_cmf_link_cmf_created_atÚix_cmf_link_cmf_deletedÚix_cmf_link_cmf_import_idÚix_cmf_link_cmf_locked_atÚix_cmf_link_cmf_locked_by_idÚix_cmf_link_cmf_modified_atÚix_cmf_link_cmf_modified_by_idÚ"ix_cmf_link_cmf_owner_assistant_idÚix_cmf_link_cmf_owner_idÚix_cmf_link_cmf_versionÚix_cmf_link_cmf_viewed_atÚix_cmf_link_codeÚix_cmf_link_nameÚix_cmf_link_parent_idÚ
cmf_notifyÚcommentsÚ	confirmedÚstatusé    ÚstrikethroughÚobj_idÚobj_codeÚobj_ui_nameÚobj_hrefÚobj_cache_status_typeÚ	person_idÚ
unread_cntÚpriority_oldÚpriorityÚ
alarm_dateÚix_cmf_notify_alarm_dateÚix_cmf_notify_cmf_author_idÚix_cmf_notify_cmf_created_atÚix_cmf_notify_cmf_deletedÚix_cmf_notify_cmf_import_idÚix_cmf_notify_cmf_locked_atÚix_cmf_notify_cmf_locked_by_idÚix_cmf_notify_cmf_modified_atÚ ix_cmf_notify_cmf_modified_by_idÚ$ix_cmf_notify_cmf_owner_assistant_idÚix_cmf_notify_cmf_owner_idÚix_cmf_notify_cmf_versionÚix_cmf_notify_cmf_viewed_atÚix_cmf_notify_codeÚix_cmf_notify_confirmedÚix_cmf_notify_nameÚ#ix_cmf_notify_obj_cache_status_typeÚix_cmf_notify_obj_codeÚix_cmf_notify_obj_hrefÚix_cmf_notify_obj_idÚix_cmf_notify_obj_ui_nameÚix_cmf_notify_parent_idÚix_cmf_notify_person_idÚix_cmf_notify_statusÚix_cmf_notify_unread_cntÚcmf_person_varÚix_cmf_person_var_cmf_author_idÚ ix_cmf_person_var_cmf_created_atÚix_cmf_person_var_cmf_deletedÚix_cmf_person_var_cmf_import_idÚix_cmf_person_var_cmf_locked_atÚ"ix_cmf_person_var_cmf_locked_by_idÚ!ix_cmf_person_var_cmf_modified_atÚ$ix_cmf_person_var_cmf_modified_by_idÚ(ix_cmf_person_var_cmf_owner_assistant_idÚix_cmf_person_var_cmf_owner_idÚix_cmf_person_var_cmf_versionÚix_cmf_person_var_cmf_viewed_atÚix_cmf_person_var_codeÚix_cmf_person_var_nameÚix_cmf_person_var_parent_idÚcmf_person_viewzcmf_person.idÚ!ix_cmf_person_view_cmf_created_atÚix_cmf_person_view_obj_idÚix_cmf_person_view_person_idÚcmf_commentÚcmf_documentÚ
cmf_filterÚ
cmf_importÚ
cmf_personÚ
cmf_pluginÚcmf_task)r   Úcreate_tableÚsaÚColumnÚStringÚPrimaryKeyConstraintÚcreate_indexÚfÚ	TIMESTAMPÚBooleanÚIntegerÚTEXTÚForeignKeyConstraintÚ
add_column© rŽ   rŽ   ú./opt/account/alembic/versions/ecc8471fb4f4_.pyÚupgrade   sf   þ÷éÜ&êúr   c                   C   sl  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 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  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  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  d¡ t jt  d8¡d9d t jt  d:¡d9d t jt  d;¡d9d t jt  d<¡d9d t jt  d=¡d9d t jt  d>¡d9d t jt  d?¡d9d t jt  d@¡d9d t jt  dA¡d9d t jt  dB¡d9d t jt  dC¡d9d t jt  dD¡d9d t jt  dE¡d9d t jt  dF¡d9d t jt  dG¡d9d t  d9¡ t jt  dH¡dId t jt  dJ¡dId t jt  dK¡dId t jt  dL¡dId t  dI¡ t  dM¡ d S )NNr€   r&   r   r~   r}   r|   r{   rz   ry   rv   )Ú
table_namerx   rw   ru   rf   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   ri   rh   rg   re   r=   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   r<   r   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r0   r/   r.   r   r   r   r   r   r   )r   Údrop_columnÚ
drop_indexr‡   Ú
drop_tablerŽ   rŽ   rŽ   r   Ú	downgradeË   s–    




r•   )Ú__doc__Úalembicr   Ú
sqlalchemyr‚   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr   r•   rŽ   rŽ   rŽ   r   Ú<module>   s    9