"""add_obj_related_person_logins

Revision ID: 1fc30e4e1b6e
Revises: 01aadd71f4a6
Create Date: 2025-09-17 13:12:05.870654

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

# revision identifiers, used by Alembic.
revision = '1fc30e4e1b6e'
down_revision = '01aadd71f4a6'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    # op.add_column('cmf_full_search', sa.Column('obj_related_person_logins', sa.TEXT(), nullable=True))
    op.execute('ALTER TABLE cmf_full_search ADD COLUMN IF NOT EXISTS obj_related_person_logins text')
    # op.add_column('cmf_full_search', sa.Column('obj_related_person_logins_tsvector', postgresql.TSVECTOR(), nullable=True))
    op.execute('ALTER TABLE cmf_full_search ADD COLUMN IF NOT EXISTS obj_related_person_logins_tsvector tsvector')
    # op.create_index('ix_cmf_full_search_obj_related_person_logins_tsvector_gin', 'cmf_full_search', ['obj_related_person_logins_tsvector'], unique=False, postgresql_using='gin')
    op.execute('CREATE INDEX IF NOT EXISTS ix_cmf_full_search_obj_related_person_logins_tsvector_gin ON cmf_full_search USING gin (obj_related_person_logins_tsvector)')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index('ix_cmf_full_search_obj_related_person_logins_tsvector_gin', table_name='cmf_full_search', postgresql_using='gin')
    op.drop_column('cmf_full_search', 'obj_related_person_logins_tsvector')
    op.drop_column('cmf_full_search', 'obj_related_person_logins')
    # ### end Alembic commands ###