
    \dE                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)z_test

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

    )opN05a67001f0462a98ce8fbda7c                  b   t        j                  d       t        j                  ddt        j                         d       t        j                  d       t        j                  ddt        j
                  d	      d       t        j                  t        j                  d
      ddgd       y )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     5/opt/eva-app/alembic/versions/05a67001f046_orderno.pyupgrader      sz    JJFGOOL)ZZ\ JJSTOOL-ZZr2 OOBDD01<)UZ[r   c                     t        j                  t        j                  d      d       t        j                  ddt	        j
                  d      d       t        j                  dd	t	        j                         d       y )
Nr   r   )
table_namer   r   r   Tr	   r   )r   
drop_indexr   r   r   r   r   r   r   r   	downgrader    !   sW    MM"$$./LIOOL-ZZr2 OOL)ZZ\r   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r    r   r   r   <module>r(      s3      

\r   