"""cmf_text_search rename

Revision ID: 4c5bcdc300ff
Revises: bf2258be5664
Create Date: 2023-09-28 17:12:07.469837

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = '4c5bcdc300ff'
down_revision = 'bf2258be5664'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_full_search',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('part_no', sa.Integer(), nullable=False),
    sa.Column('obj_id', sa.String(length=64), nullable=False),
    sa.Column('obj_model', sa.TEXT(), nullable=True),
    sa.Column('obj_code', sa.TEXT(), nullable=True),
    sa.Column('obj_name', sa.TEXT(), nullable=True),
    sa.Column('obj_text', sa.TEXT(), nullable=True),
    sa.Column('obj_tags', sa.TEXT(), nullable=True),
    sa.Column('obj_logic_type_code', sa.TEXT(), nullable=True),
    sa.Column('obj_activity_code', sa.TEXT(), nullable=True),
    sa.Column('obj_status_type', sa.TEXT(), nullable=True),
    sa.Column('obj_result_text', sa.TEXT(), nullable=True),
    sa.Column('obj_comments', sa.TEXT(), nullable=True),
    sa.Column('obj_owner_name', sa.TEXT(), nullable=True),
    sa.Column('obj_responsible_names', sa.TEXT(), nullable=True),
    sa.Column('obj_href', sa.TEXT(), nullable=True),
    sa.Column('obj_parent_id', sa.String(length=64), nullable=True),
    sa.Column('obj_tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('obj_root_parent_id', sa.String(length=64), nullable=True),
    sa.Column('obj_created_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('obj_modified_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('obj_deleted', sa.Boolean(), nullable=False),
    sa.Column('obj_archived', sa.Boolean(), nullable=False),
    sa.Column('name_tsvector', postgresql.TSVECTOR(), nullable=True),
    sa.Column('text_tsvector', postgresql.TSVECTOR(), nullable=True),
    sa.Column('tags_tsvector', postgresql.TSVECTOR(), nullable=True),
    sa.Column('result_text_tsvector', postgresql.TSVECTOR(), nullable=True),
    sa.Column('comments_tsvector', postgresql.TSVECTOR(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index('ix_cmf_full_search_comments_tsvector_gin', 'cmf_full_search', ['comments_tsvector'], unique=False, postgresql_using='gin')
    op.create_index('ix_cmf_full_search_name_tsvector_gin', 'cmf_full_search', ['name_tsvector'], unique=False, postgresql_using='gin')
    op.create_index(op.f('ix_cmf_full_search_obj_activity_code'), 'cmf_full_search', ['obj_activity_code'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_archived'), 'cmf_full_search', ['obj_archived'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_code'), 'cmf_full_search', ['obj_code'], unique=False)
    op.create_index('ix_cmf_full_search_obj_comments_gin_trgm', 'cmf_full_search', ['obj_comments'], unique=False, postgresql_using='gin', postgresql_ops={'obj_comments': 'gin_trgm_ops'})
    op.create_index(op.f('ix_cmf_full_search_obj_created_at'), 'cmf_full_search', ['obj_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_deleted'), 'cmf_full_search', ['obj_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_id'), 'cmf_full_search', ['obj_id'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_logic_type_code'), 'cmf_full_search', ['obj_logic_type_code'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_model'), 'cmf_full_search', ['obj_model'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_modified_at'), 'cmf_full_search', ['obj_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_name'), 'cmf_full_search', ['obj_name'], unique=False)
    op.create_index('ix_cmf_full_search_obj_name_gin_trgm', 'cmf_full_search', ['obj_name'], unique=False, postgresql_using='gin', postgresql_ops={'obj_name': 'gin_trgm_ops'})
    op.create_index(op.f('ix_cmf_full_search_obj_owner_name'), 'cmf_full_search', ['obj_owner_name'], unique=False)
    op.create_index('ix_cmf_full_search_obj_owner_name_gin_trgm', 'cmf_full_search', ['obj_owner_name'], unique=False, postgresql_using='gin', postgresql_ops={'obj_owner_name': 'gin_trgm_ops'})
    op.create_index(op.f('ix_cmf_full_search_obj_parent_id'), 'cmf_full_search', ['obj_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_responsible_names'), 'cmf_full_search', ['obj_responsible_names'], unique=False)
    op.create_index('ix_cmf_full_search_obj_responsible_names_gin_trgm', 'cmf_full_search', ['obj_responsible_names'], unique=False, postgresql_using='gin', postgresql_ops={'obj_responsible_names': 'gin_trgm_ops'})
    op.create_index('ix_cmf_full_search_obj_result_text_gin_trgm', 'cmf_full_search', ['obj_result_text'], unique=False, postgresql_using='gin', postgresql_ops={'obj_result_text': 'gin_trgm_ops'})
    op.create_index(op.f('ix_cmf_full_search_obj_root_parent_id'), 'cmf_full_search', ['obj_root_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_full_search_obj_status_type'), 'cmf_full_search', ['obj_status_type'], unique=False)
    op.create_index('ix_cmf_full_search_obj_tags_gin_trgm', 'cmf_full_search', ['obj_tags'], unique=False, postgresql_using='gin', postgresql_ops={'obj_tags': 'gin_trgm_ops'})
    op.create_index('ix_cmf_full_search_obj_text_gin_trgm', 'cmf_full_search', ['obj_text'], unique=False, postgresql_using='gin', postgresql_ops={'obj_text': 'gin_trgm_ops'})
    op.create_index(op.f('ix_cmf_full_search_obj_tree_parent_id'), 'cmf_full_search', ['obj_tree_parent_id'], unique=False)
    op.create_index('ix_cmf_full_search_result_text_tsvector_gin', 'cmf_full_search', ['result_text_tsvector'], unique=False, postgresql_using='gin')
    op.create_index('ix_cmf_full_search_tags_tsvector_gin', 'cmf_full_search', ['tags_tsvector'], unique=False, postgresql_using='gin')
    op.create_index('ix_cmf_full_search_text_tsvector_gin', 'cmf_full_search', ['text_tsvector'], unique=False, postgresql_using='gin')
    op.drop_index('ix_cmf_text_search_comments_tsvector_gin', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_name_tsvector_gin', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_activity_code', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_archived', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_code', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_comments_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_created_at', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_deleted', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_id', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_logic_type_code', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_model', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_modified_at', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_name', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_name_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_owner_name', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_owner_name_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_parent_id', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_responsible_names', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_responsible_names_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_result_text_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_root_parent_id', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_status_type', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_tags_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_text_gin_trgm', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_obj_tree_parent_id', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_result_text_tsvector_gin', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_tags_tsvector_gin', table_name='cmf_text_search')
    op.drop_index('ix_cmf_text_search_text_tsvector_gin', table_name='cmf_text_search')
    op.drop_table('cmf_text_search')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_text_search',
    sa.Column('id', sa.VARCHAR(length=64), autoincrement=False, nullable=False),
    sa.Column('obj_id', sa.VARCHAR(length=64), autoincrement=False, nullable=False),
    sa.Column('obj_model', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_name', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_text', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_tags', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True),
    sa.Column('obj_tree_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True),
    sa.Column('obj_root_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True),
    sa.Column('obj_created_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('obj_modified_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('name_tsvector', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    sa.Column('text_tsvector', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    sa.Column('tags_tsvector', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    sa.Column('obj_logic_type_code', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_activity_code', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_comments', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_owner_name', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_responsible_names', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('comments_tsvector', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    sa.Column('obj_code', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_deleted', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False),
    sa.Column('obj_archived', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False),
    sa.Column('part_no', sa.INTEGER(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.Column('obj_status_type', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_href', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('obj_result_text', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('result_text_tsvector', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    sa.Column('test_text', sa.TEXT(), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name='cmf_text_search_pkey')
    )
    op.create_index('ix_cmf_text_search_text_tsvector_gin', 'cmf_text_search', ['text_tsvector'], unique=False)
    op.create_index('ix_cmf_text_search_tags_tsvector_gin', 'cmf_text_search', ['tags_tsvector'], unique=False)
    op.create_index('ix_cmf_text_search_result_text_tsvector_gin', 'cmf_text_search', ['result_text_tsvector'], unique=False)
    op.create_index('ix_cmf_text_search_obj_tree_parent_id', 'cmf_text_search', ['obj_tree_parent_id'], unique=False)
    op.create_index('ix_cmf_text_search_obj_text_gin_trgm', 'cmf_text_search', ['obj_text'], unique=False)
    op.create_index('ix_cmf_text_search_obj_tags_gin_trgm', 'cmf_text_search', ['obj_tags'], unique=False)
    op.create_index('ix_cmf_text_search_obj_status_type', 'cmf_text_search', ['obj_status_type'], unique=False)
    op.create_index('ix_cmf_text_search_obj_root_parent_id', 'cmf_text_search', ['obj_root_parent_id'], unique=False)
    op.create_index('ix_cmf_text_search_obj_result_text_gin_trgm', 'cmf_text_search', ['obj_result_text'], unique=False)
    op.create_index('ix_cmf_text_search_obj_responsible_names_gin_trgm', 'cmf_text_search', ['obj_responsible_names'], unique=False)
    op.create_index('ix_cmf_text_search_obj_responsible_names', 'cmf_text_search', ['obj_responsible_names'], unique=False)
    op.create_index('ix_cmf_text_search_obj_parent_id', 'cmf_text_search', ['obj_parent_id'], unique=False)
    op.create_index('ix_cmf_text_search_obj_owner_name_gin_trgm', 'cmf_text_search', ['obj_owner_name'], unique=False)
    op.create_index('ix_cmf_text_search_obj_owner_name', 'cmf_text_search', ['obj_owner_name'], unique=False)
    op.create_index('ix_cmf_text_search_obj_name_gin_trgm', 'cmf_text_search', ['obj_name'], unique=False)
    op.create_index('ix_cmf_text_search_obj_name', 'cmf_text_search', ['obj_name'], unique=False)
    op.create_index('ix_cmf_text_search_obj_modified_at', 'cmf_text_search', ['obj_modified_at'], unique=False)
    op.create_index('ix_cmf_text_search_obj_model', 'cmf_text_search', ['obj_model'], unique=False)
    op.create_index('ix_cmf_text_search_obj_logic_type_code', 'cmf_text_search', ['obj_logic_type_code'], unique=False)
    op.create_index('ix_cmf_text_search_obj_id', 'cmf_text_search', ['obj_id'], unique=False)
    op.create_index('ix_cmf_text_search_obj_deleted', 'cmf_text_search', ['obj_deleted'], unique=False)
    op.create_index('ix_cmf_text_search_obj_created_at', 'cmf_text_search', ['obj_created_at'], unique=False)
    op.create_index('ix_cmf_text_search_obj_comments_gin_trgm', 'cmf_text_search', ['obj_comments'], unique=False)
    op.create_index('ix_cmf_text_search_obj_code', 'cmf_text_search', ['obj_code'], unique=False)
    op.create_index('ix_cmf_text_search_obj_archived', 'cmf_text_search', ['obj_archived'], unique=False)
    op.create_index('ix_cmf_text_search_obj_activity_code', 'cmf_text_search', ['obj_activity_code'], unique=False)
    op.create_index('ix_cmf_text_search_name_tsvector_gin', 'cmf_text_search', ['name_tsvector'], unique=False)
    op.create_index('ix_cmf_text_search_comments_tsvector_gin', 'cmf_text_search', ['comments_tsvector'], unique=False)
    op.drop_index('ix_cmf_full_search_text_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_index('ix_cmf_full_search_tags_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_index('ix_cmf_full_search_result_text_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_index(op.f('ix_cmf_full_search_obj_tree_parent_id'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_obj_text_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_text': 'gin_trgm_ops'})
    op.drop_index('ix_cmf_full_search_obj_tags_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_tags': 'gin_trgm_ops'})
    op.drop_index(op.f('ix_cmf_full_search_obj_status_type'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_root_parent_id'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_obj_result_text_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_result_text': 'gin_trgm_ops'})
    op.drop_index('ix_cmf_full_search_obj_responsible_names_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_responsible_names': 'gin_trgm_ops'})
    op.drop_index(op.f('ix_cmf_full_search_obj_responsible_names'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_parent_id'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_obj_owner_name_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_owner_name': 'gin_trgm_ops'})
    op.drop_index(op.f('ix_cmf_full_search_obj_owner_name'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_obj_name_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_name': 'gin_trgm_ops'})
    op.drop_index(op.f('ix_cmf_full_search_obj_name'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_modified_at'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_model'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_logic_type_code'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_id'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_deleted'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_created_at'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_obj_comments_gin_trgm', table_name='cmf_full_search', postgresql_using='gin', postgresql_ops={'obj_comments': 'gin_trgm_ops'})
    op.drop_index(op.f('ix_cmf_full_search_obj_code'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_archived'), table_name='cmf_full_search')
    op.drop_index(op.f('ix_cmf_full_search_obj_activity_code'), table_name='cmf_full_search')
    op.drop_index('ix_cmf_full_search_name_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_index('ix_cmf_full_search_comments_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_table('cmf_full_search')
    # ### end Alembic commands ###