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 )z`chats

Revision ID: e52701faecde
Revises: 95ba9d99b5ec
Create Date: 2021-09-14 17:54:00.167847

é    )ÚopN)Ú
postgresqlZe52701faecdeÚ95ba9d99b5ecc                   C   s  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d t jt  d¡dd	gdd t  d ddd	gdg¡ t  d dddgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd t  d dddgdg¡ d S )NÚcmf_channel_messageÚmessage_flowé    )ÚlengthT)ÚnullableÚperson_from_idé@   Úperson_to_idÚ%ix_cmf_channel_message_person_from_idF)ÚuniqueÚ#ix_cmf_channel_message_person_to_idÚ
cmf_personÚidÚcmf_commentÚdeal_idÚix_cmf_comment_deal_idÚcmf_deal)r   Ú
add_columnÚsaÚColumnÚStringÚcreate_indexÚfÚcreate_foreign_key© r   r   ú3/opt/eva-app/alembic/versions/e52701faecde_chats.pyÚupgrade   s        r   c                   C   s    t jd ddd t jt  d¡dd t  dd¡ t jd d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¡ d S )Nr   Ú
foreignkey)Útype_r   )Ú
table_namer   r   r   r   r   r
   r   )r   Údrop_constraintÚ
drop_indexr   Údrop_columnr   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   