
    1Eg                     >    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
d Zy)	zlarchived_quickfix

Revision ID: 6b5b0854d342
Revises: 5b28afa694a0
Create Date: 2024-09-23 09:38:54.911404

    )opN6b5b0854d3425b28afa694a0c                 z    t        j                         }|j                  d|  d| d      j                         d uS )NzG
        SELECT 1 
        FROM pg_indexes 
        WHERE indexname = 'z' 
        AND tablename = 'z
'
        )r   get_bindexecutescalar)
index_name
table_nameconns      ?/opt/eva-app/alembic/versions/6b5b0854d342_archived_quickfix.pyindex_existsr      sN    ;;=D<< '< ($ &			 fhd     c            	         t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        dd	      rt        j                  dd	
       t        dd	      rt        j                  dd	
       t        dd	      st        j                  dd	dgdd       t        dd	      st        j                  dd	dgddddi       y y )Ncmf_asset_cathas_children_archivedFfalse)nullableserver_defaultcmf_asset_schemecmf_asset_type_cat-ix_cmf_full_search_custom_fields_tsvector_gincmf_full_searchr   -ix_cmf_full_search_obj_custom_fields_gin_trgm,ix_cmf_full_search_addon_fields_tsvector_ginaddon_fields_tsvectorgin)uniquepostgresql_using,ix_cmf_full_search_obj_addon_fields_gin_trgmobj_addon_fieldsgin_trgm_ops)r   r    postgresql_ops)r   
add_columnsaColumnBooleanr   
drop_indexcreate_index r   r   upgrader,      s   MM/299-Dbjjl]bsz#{|MM$bii0G`ev}&~MM&		2I2::<bgx  )A  B CEVW
ERcdCEVW
ERcd FHYZ
F(+B*C#e	= FHYZ
F(+=*>#e'9>&J	L [r   c                     t        dd      rt        j                  dd       t        dd      rt        j                  dd       t        dd      st        j                  dddgd       t        d	d      st        j                  d	dd
gd       t        j                  dd       t        j                  dd       t        j                  dd       y )Nr!   r   r   r   r   r"   F)r   r   r   r   r   r   r   )r   r   r)   r*   drop_columnr+   r   r   	downgrader/   6   s    BDUV
D 1	3 BDUV
D 1	3 GIZ[
G(+=*>#	% GIZ[
G(+B*C#	% NN')@ANN%'>?NN?$;<r   )__doc__alembicr   
sqlalchemyr&   revisiondown_revisionbranch_labels
depends_onr   r,   r/   r+   r   r   <module>r7      s8      
	L4=r   