"""cmf_text_search3

Revision ID: 6cf4d48b461b
Revises: 94e543923dcc
Create Date: 2023-09-28 01:28:45.573260

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '6cf4d48b461b'
down_revision = '94e543923dcc'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_text_search', sa.Column('part_no', sa.Integer(), nullable=False, server_default="0"))
    op.add_column('cmf_text_search', sa.Column('obj_status_type', sa.TEXT(), nullable=True))
    op.drop_index('ix_cmf_text_search_orderno', table_name='cmf_text_search')
    op.create_index(op.f('ix_cmf_text_search_obj_status_type'), 'cmf_text_search', ['obj_status_type'], unique=False)
    op.drop_column('cmf_text_search', 'orderno')
    op.create_index('ix_cmf_text_search_obj_text_gin_trgm', 'cmf_text_search', ['obj_text'], unique=False,
                    postgresql_using='gin', postgresql_ops={'obj_text': 'gin_trgm_ops'})
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_text_search', sa.Column('orderno', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_text_search_obj_status_type'), table_name='cmf_text_search')
    op.create_index('ix_cmf_text_search_orderno', 'cmf_text_search', ['orderno'], unique=False)
    op.drop_column('cmf_text_search', 'obj_status_type')
    op.drop_column('cmf_text_search', 'part_no')
    op.drop_index('ix_cmf_text_search_obj_text_gin_trgm', table_name='cmf_text_search', postgresql_using='gin',
                  postgresql_ops={'obj_text': 'gin_trgm_ops'})
    # ### end Alembic commands ###