U
    \Úd¬   ã                   @   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 )zhonline status

Revision ID: 0610c65c8b66
Revises: 138d90f8c095
Create Date: 2021-09-30 18:06:46.714677

é    )ÚopN)Ú
postgresqlZ0610c65c8b66Z138d90f8c095c                   C   sô  t  dtjdtjd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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 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 jt  d,¡dd-gdd t jt  d.¡dd/gdd t jt  d0¡dd1gdd t jt  d2¡dd3gdd t jt  d4¡dd5gdd t jt  d6¡dd7gdd t jt  d8¡dd9g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 d S )@NÚcmf_person_varÚonline_statusé    ©ÚlengthT)ÚnullableÚ"ix_cmf_staff_control_cmf_author_id©Ú
table_nameÚ#ix_cmf_staff_control_cmf_created_atÚ ix_cmf_staff_control_cmf_deletedÚ"ix_cmf_staff_control_cmf_import_idÚ"ix_cmf_staff_control_cmf_locked_atÚ%ix_cmf_staff_control_cmf_locked_by_idÚ$ix_cmf_staff_control_cmf_modified_atÚ'ix_cmf_staff_control_cmf_modified_by_idÚ+ix_cmf_staff_control_cmf_owner_assistant_idÚ!ix_cmf_staff_control_cmf_owner_idÚ ix_cmf_staff_control_cmf_versionÚ"ix_cmf_staff_control_cmf_viewed_atÚix_cmf_staff_control_codeÚ!ix_cmf_staff_control_last_ping_atÚ ix_cmf_staff_control_last_sms_atÚix_cmf_staff_control_nameÚix_cmf_staff_control_parent_idÚix_cmf_staff_control_person_idÚix_cmf_person_var_cmf_author_idÚcmf_author_idF©ÚuniqueÚ ix_cmf_person_var_cmf_created_atÚcmf_created_atÚix_cmf_person_var_cmf_deletedÚcmf_deletedÚix_cmf_person_var_cmf_import_idÚcmf_import_idÚix_cmf_person_var_cmf_locked_atÚcmf_locked_atÚ"ix_cmf_person_var_cmf_locked_by_idÚcmf_locked_by_idÚ!ix_cmf_person_var_cmf_modified_atÚcmf_modified_atÚ$ix_cmf_person_var_cmf_modified_by_idÚcmf_modified_by_idÚ(ix_cmf_person_var_cmf_owner_assistant_idÚcmf_owner_assistant_idÚix_cmf_person_var_cmf_owner_idÚcmf_owner_idÚix_cmf_person_var_cmf_versionÚcmf_versionÚix_cmf_person_var_cmf_viewed_atÚcmf_viewed_atÚix_cmf_person_var_codeÚcodeÚix_cmf_person_var_last_ping_atÚlast_ping_atÚix_cmf_person_var_last_sms_atÚlast_sms_atÚix_cmf_person_var_nameÚnameÚix_cmf_person_var_parent_idÚ	parent_idÚix_cmf_person_var_person_idÚ	person_id)r   Ú
add_columnÚsaÚColumnÚStringÚ
drop_indexÚcreate_indexÚf© rK   rK   ú;/opt/eva-app/alembic/versions/0610c65c8b66_online_status.pyÚupgrade   sJ     rM   c                	   C   sv  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dddgdd t jdddgdd t jdddgdd t jdddgdd t jddd gdd t jd!dd"gdd t jd#dd$gdd t jd%dd&gdd t jd'dd(gdd t jd)dd*gdd t jd+dd,gdd t jd-dd.gdd t jd/dd0gdd t jd1dd2gdd t jd3dd4gdd t jd5dd6gdd t jd7dd8gdd t jd9dd:gdd t  dd;¡ t  d<tjd=tjd>d?dd@dA¡ t jdBd<d=gdd t jt  dC¡dDd t  dEtjdFtjd>d?dd@dA¡ t  	dGdEdHdFgdIg¡ t jdJdEdFgdd d S )KNrB   r   r   r@   r>   r<   r:   r8   r6   r4   r2   r0   r.   r,   r*   r(   r&   r$   r"   r   r   rC   Fr    r   rA   r   r?   r   r=   r   r;   r   r9   r   r7   r   r5   r   r3   r   r1   r   r/   r   r-   r   r+   r   r)   r   r'   r   r%   r   r#   r
   r   r   Ú
cmf_personZhome_project_idé@   r   T)Úautoincrementr	   Zix_cmf_person_home_project_idZix_cmf_patch_nameÚ	cmf_patchÚcmf_invoice_itemsÚdeal_idZcmf_invoice_items_deal_id_fkeyÚcmf_dealÚidZix_cmf_invoice_items_deal_id)
r   rH   rJ   rI   Údrop_columnrD   rE   rF   ÚVARCHARÚcreate_foreign_keyrK   rK   rK   rL   Ú	downgrade=   sV    ""rY   )Ú__doc__Úalembicr   Ú
sqlalchemyrE   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrM   rY   rK   rK   rK   rL   Ú<module>   s   *