U
    z]f                     @   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 )zeproject v2

Revision ID: 89ed5087e878
Revises: af18a0280adf
Create Date: 2024-03-14 11:46:29.718900

    )opN)
postgresqlZ89ed5087e878Zaf18a0280adfc                   C   s   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 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_active_entity_filter
project_id@   )lengthT)nullable&ix_cmf_active_entity_filter_project_idF)uniquecmf_projectidcmf_s_desk_knowlage_category*ix_cmf_s_desk_knowlage_category_project_id)r   
add_columnsaColumnStringcreate_indexfcreate_foreign_key r   r   8/opt/eva-app/alembic/versions/89ed5087e878_project_v2.pyupgrade   s      r   c                   C   sd   t jd ddd t jt ddd t dd t jd ddd t jt ddd t dd d S )	Nr   
foreignkey)type_r   )
table_namer   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   