U
    \dE                     @   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 )
z_test

Revision ID: 05a67001f046
Revises: 2a98ce8fbda7
Create Date: 2021-02-26 14:33:05.153852

    )opNZ05a67001f0462a98ce8fbda7c                   C   sb   t d t jddt dd t d t jddtjdd	dd t jt d
ddgdd d S )Nz5update cmf_status set orderno=0 where orderno is null
cmf_statusordernoFexisting_typenullablezBupdate cmf_status set status_type='open' where status_type is nullstatus_type    lengthix_cmf_status_orderno)unique)r   executealter_columnsaINTEGERVARCHARcreate_indexf r   r   5/opt/eva-app/alembic/versions/05a67001f046_orderno.pyupgrade   s    


r   c                   C   sH   t jt ddd t jddtjdddd t jdd	t dd d S )
Nr   r   )
table_namer	   r
   r   Tr   r   )r   
drop_indexr   r   r   r   r   r   r   r   r   	downgrade!   s    
r   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   r   <module>   s   