
    \d                      D    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 Zd Zy)	zhonline status

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

    )opN)
postgresql0610c65c8b66138d90f8c095c            	      
   t        j                  dt        j                  dt        j                  d      d             t        j
                  dd       t        j
                  d	d       t        j
                  d
d       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j
                  dd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d       dd!gd       t        j                  t        j                  d"      dd#gd       t        j                  t        j                  d$      dd%gd       t        j                  t        j                  d&      dd'gd       t        j                  t        j                  d(      dd)gd       t        j                  t        j                  d*      dd+gd       t        j                  t        j                  d,      dd-gd       t        j                  t        j                  d.      dd/gd       t        j                  t        j                  d0      dd1gd       t        j                  t        j                  d2      dd3gd       t        j                  t        j                  d4      dd5gd       t        j                  t        j                  d6      dd7gd       t        j                  t        j                  d8      dd9gd       t        j                  t        j                  d:      dd;gd       t        j                  t        j                  d<      dd=gd       t        j                  t        j                  d>      dd?gd       y )@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     ;/opt/eva-app/alembic/versions/0610c65c8b66_online_status.pyupgraderR      s   MM"BIIoryyPR?S^b$cdMM6CSTMM7DTUMM4AQRMM6CSTMM6CSTMM9FVWMM8EUVMM;HXYMM?L\]MM5BRSMM4AQRMM6CSTMM-:JKMM5BRSMM4AQRMM-:JKMM2?OPMM2?OPOOBDD:;=MP_O`inoOOBDD;<>NQaPbkpqOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD:;=MP_O`inoOOBDD=>@PSeRfotuOOBDD<=?ORcQdmrsOOBDD?@BRUiTjsxyOOBDDCDFVYqXr  |A  BOOBDD9:<L~N^glmOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD124DvhW[\OOBDD9:<L~N^glmOOBDD89;Km_ejkOOBDD124DvhW\]OOBDD679IK=afgOOBDD679IK=aefrP   c            	         t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d	      d       t        j                  t        j                  d
      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  dddgd       t        j                  dddgd       t        j                  dddgd       t        j                  dddgd       t        j                  ddd gd       t        j                  d!dd"gd       t        j                  d#dd$gd       t        j                  d%dd&gd       t        j                  d'dd(gd       t        j                  d)dd*gd       t        j                  d+dd,gd       t        j                  d-dd.gd       t        j                  d/dd0gd       t        j                  d1dd2gd       t        j                  d3dd4gd       t        j                  d5dd6gd       t        j                  d7dd8gd       t        j                  d9dd:gd       t        j                  dd;       t        j
                  d<t        j                  d=t        j                  d>?      dd@A             t        j                  dBd<d=gd       t        j                  t        j                  dC      dD       t        j
                  dEt        j                  dFt        j                  d>?      dd@A             t        j                  dGdEdHdFgdIg       t        j                  dJdEdFgd       y )KNrF   r   r   rD   rB   r@   r>   r<   r:   r8   r6   r4   r2   r0   r.   r,   r*   r(   r&   r"   r!   rG   Fr$   r    rE   r   rC   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	   
cmf_personhome_project_id@   r   T)autoincrementr   ix_cmf_person_home_project_idix_cmf_patch_name	cmf_patchcmf_invoice_itemsdeal_idcmf_invoice_items_deal_id_fkeycmf_dealidix_cmf_invoice_items_deal_id)
r   rL   rN   rM   drop_columnrH   rI   rJ   VARCHARcreate_foreign_keyrO   rP   rQ   	downgraderd   =   s;   MM"$$45BRSMM"$$45BRSMM"$$/0=MNMM"$$67DTUMM"$$78EUVMM"$$/0=MNMM"$$89FVWMM"$$67DTUMM"$$78EUVMM"$$ABO_`MM"$$=>K[\MM"$$:;HXYMM"$$;<IYZMM"$$89FVWMM"$$89FVWMM"$$67DTUMM"$$9:GWXMM"$$89FVWOO46F^cdOO46F^cdOO/1AF8TYZOO68H=/bghOO79INK[dijOO/1AF8TYZOO8:J_L]fklOO68H=/bghOO79INK[dijOOACSVnUox}~OO=?ORfQgpuvOO:<LO`NajopOO;=MPbOclqrOO8:J_L]fklOO8:J_L]fklOO68H=/bghOO9;KN^M_hmnOO8:J_L]fklNN#_5MM,		*;RZZr=Rbgrv wxOO3\DUCV_deMM"$$*+DMM%ryyBJJb<Qafqu'vw:<OQ[^g]hkojpqOO24G)]bcrP   )__doc__alembicr   
sqlalchemyrI   sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onrR   rd   rO   rP   rQ   <module>rm      s8      * 
&gT,drP   