
    \dB%                     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)	zhchat_messages

Revision ID: c1fb20145a41
Revises: 5c86366d5292
Create Date: 2021-11-09 15:43:22.985835

    )opN)
postgresqlc1fb20145a415c86366d5292c                      t        j                  dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d t        j                  d      d      t        j                  dgd!g      t        j                  d gd"g      t        j                  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                  d.      ddgd$       t        j                  t        j                  d/      ddgd$       t        j                  t        j                  d0      ddgd$       t        j                  t        j                  d1      ddgd$       t        j                  t        j                  d2      dd gd$       t        j                  t        j                  d3      ddgd$       t        j                  t        j                  d4      ddgd$       t        j                  d5t        j                  dt        j                  d      d      t        j                  d6t        j                  d      d      t        j                  d7t        j                  d      d      t        j                  d8t        j                  d      d      t        j                  d6gd9g      t        j                  d8gd:g      t        j                  d7gd;g      t        j                  d      	       t        j                  t        j                  d<      d5d6gd$       t        j                  t        j                  d=      d5d8gd$       t        j                  t        j                  d>      d5d7gd$       t        j                  d?d@A       t        j                  dBd@A       t        j                  dCd@A       t        j                  d@       t        j                  dDt        j                  dEt        j                  d      d             t        j                  t        j                  dF      dDdEgd$       t        j                   d dDddEgdg       y )GNcmf_chat_messageid@   lengthF)nullablecmf_locked_atT)timezonecmf_created_atcmf_modified_atcmf_viewed_atcmf_deletedcmf_versiontextlikesviews	importantprioritypinnedcache_cmf_author_logincache_cmf_author_name   cache_cmf_author_codecmf_author_idcmf_owner_idcmf_owner_assistant_id	parent_idcmf_modified_by_idcmf_locked_by_iddeal_idlead_idzcmf_deal.idzcmf_lead.id)ix_cmf_chat_message_cache_cmf_author_codeunique)ix_cmf_chat_message_cache_cmf_author_name!ix_cmf_chat_message_cmf_author_id"ix_cmf_chat_message_cmf_created_atix_cmf_chat_message_cmf_deleted!ix_cmf_chat_message_cmf_locked_at$ix_cmf_chat_message_cmf_locked_by_id#ix_cmf_chat_message_cmf_modified_at&ix_cmf_chat_message_cmf_modified_by_id*ix_cmf_chat_message_cmf_owner_assistant_id ix_cmf_chat_message_cmf_owner_idix_cmf_chat_message_cmf_version!ix_cmf_chat_message_cmf_viewed_atix_cmf_chat_message_deal_idix_cmf_chat_message_lead_idix_cmf_chat_message_parent_idix_cmf_chat_message_pinnedcmf_chat_topic_unread_messagechat_topic_id	person_id
message_idcmf_chat_topic.idzcmf_chat_message.idcmf_person.id.ix_cmf_chat_topic_unread_message_chat_topic_id+ix_cmf_chat_topic_unread_message_message_id*ix_cmf_chat_topic_unread_message_person_id.ix_cmf_chat_topic_unread_comment_chat_topic_idcmf_chat_topic_unread_comment
table_name+ix_cmf_chat_topic_unread_comment_comment_id*ix_cmf_chat_topic_unread_comment_person_idcmf_channel_messagechat_message_id&ix_cmf_channel_message_chat_message_id)r   create_tablesaColumnString	TIMESTAMPBooleanIntegerTEXTForeignKeyConstraintPrimaryKeyConstraintcreate_indexf
drop_index
drop_table
add_columncreate_foreign_key     ;/opt/eva-app/alembic/versions/c1fb20145a41_chat_messages.pyupgrader_      s   OO&IIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRZZ\D9IIfbiikD1IIgrwwy40IIgrwwy40IIk2::<$7IIj"**,7IIh

u5II&		(<tLII%ryy'<tLII%ryy';dKIIoryy3dCIInbiir2TBII&		(<tLIIk299B/$?II"BIIR$84HII "))2"6FIIi"-=IIi"-=YK-;YK-;D!7: OOBDDDEGY\s[t  ~C  DOOBDDDEGY\s[t  ~C  DOOBDD<=?QTcSdmrsOOBDD=>@RUeTfotuOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD?@BTWiVjsxyOOBDD>?ASVgUhqvwOOBDDABDVYmXnw|}OOBDDEFHZ]u\v  @E  FOOBDD;<>PSaRbkpqOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD679Ki[afgOOBDD679Ki[afgOOBDD89;MP[}ejkOOBDD568JXJ_deOO3IIdBIIR(59IIoryy3eDIIk299B/%@IIlBIIR05A_-0C/DG\N-B,CF[MO+<?D!	 OOBDDIJLkn}m~  HM  NOOBDDFGIhkwjx  BG  HOOBDDEFHgjuiv  @E  FMMBOnoMM?LklMM>KjkMM12MM'3DbiiWYFZei)jkOOBDDABDY\m[nw|}$ 57IL]K^ae`fgr]   c                  
   t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j
                  dt        j                  dt        j                  d	
      dd      t        j                  dt        j                  d	
      dd      t        j                  dt        j                  d	
      dd      t        j                  dt        j                  d	
      dd      t        j                  dgdgd      t        j                  dgdgd      t        j                  dgdgd      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                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  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                  d0      d!       t        j                  t        j                  d1      d!       t        j                  d!       y )2NrI   
foreignkey)type_rK   rE   rJ   rD   r	   r
   r   F)autoincrementr   r;   r<   
comment_idr>   0cmf_chat_topic_unread_comment_chat_topic_id_fkey)namezcmf_comment.id-cmf_chat_topic_unread_comment_comment_id_fkeyr?   ,cmf_chat_topic_unread_comment_person_id_fkey"cmf_chat_topic_unread_comment_pkeyrH   r(   rG   rC   rB   r:   rA   r@   r9   r   r8   r7   r6   r5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r'   )r   drop_constraintrX   rW   drop_columnrL   rM   rN   VARCHARrT   rU   rV   rY   r\   r]   r^   	downgraderm   Z   s   t2,GMM"$$?@MbcNN(*;<OO3IIdBJJb)OIIorzz4ETYZIIk2::R0PUVIIlBJJb1QVW_-0C/DK}~\N-=,>Etu[MO+<CqrD'KL	 OO@Badocpy~OOACbeqdr  |A  BOODFehwgx  BG  HMM"$$CDQpqMM"$$DERqrMM"$$GHUtuMM12MM"$$34ASTMM"$$67DVWMM"$$45BTUMM"$$45BTUMM"$$:;HZ[MM"$$89FXYMM"$$9:GYZMM"$$CDQcdMM"$$?@M_`MM"$$<=J\]MM"$$=>K]^MM"$$:;HZ[MM"$$89FXYMM"$$;<I[\MM"$$:;HZ[MM"$$BCPbcMM"$$BCPbcMM$%r]   )__doc__alembicr   
sqlalchemyrM   sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr_   rm   r\   r]   r^   <module>rv      s8      * 
ChN'&r]   