U
    \dv                     @   s<   d Z ddlmZ ddlZdZdZdZdZdd Z	dd	 Z
dS )
zi'roadmaps_m2m'

Revision ID: a40c51516f02
Revises: 132ade97e2f8
Create Date: 2022-05-11 11:26:02.589954

    )opNa40c51516f02132ade97e2f8c                   C   sF   t jddd t jddd t jddd t jddd t d d S )Nix_cmf_roadmap_members_left_idcmf_roadmap_members)
table_name ix_cmf_roadmap_members_parent_idix_cmf_roadmap_members_right_idix_cmf_roadmap_members_root_id)r   
drop_index
drop_table r   r   :/opt/eva-app/alembic/versions/a40c51516f02_roadmaps_m2m.pyupgrade   s
    r   c                   C   s*  t dtjdtjdddddtjdtjdddddtjd	tjdddddtjd
tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtj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 d S )Nr   id@   )lengthF)autoincrementnullable	parent_idTroot_iddescriptioni   left_idright_idleft_name_cache   right_name_cacheZcmf_roadmap_members_pkey)namer
   )uniquer	   r   r   )r   create_tablesaColumnVARCHARPrimaryKeyConstraintcreate_indexr   r   r   r   	downgrade   s    r%   )__doc__alembicr   
sqlalchemyr    revisiondown_revisionbranch_labels
depends_onr   r%   r   r   r   r   <module>   s   
