def METHOD_NAME() -> None:
    op.add_column(
        'session',
        sa.Column(
            'speaker_bio_html',
            sa.TEXT(),
            autoincrement=False,
            nullable=False,
            server_default='',
        ),
    )
    op.alter_column('session', 'speaker_bio_html', server_default=None)
    op.add_column(
        'session',
        sa.Column(
            'speaker_bio_text',
            sa.TEXT(),
            autoincrement=False,
            nullable=False,
            server_default='',
        ),
    )
    op.alter_column('session', 'speaker_bio_text', server_default=None)
    op.execute(
        sa.DDL(
            dedent(
                '''
                UPDATE session SET search_vector = setweight(to_tsvector('english', COALESCE(title, '')), 'A') || setweight(to_tsvector('english', COALESCE(description_text, '')), 'B') || setweight(to_tsvector('english', COALESCE(speaker_bio_text, '')), 'B') || setweight(to_tsvector('english', COALESCE(speaker, '')), 'A');
                DROP TRIGGER session_search_vector_trigger ON session;
                DROP FUNCTION session_search_vector_update();
                CREATE FUNCTION session_search_vector_update() RETURNS trigger AS $$
                BEGIN
                    NEW.search_vector := setweight(to_tsvector('english', COALESCE(NEW.title, '')), 'A') || setweight(to_tsvector('english', COALESCE(NEW.description_text, '')), 'B') || setweight(to_tsvector('english', COALESCE(NEW.speaker_bio_text, '')), 'B') || setweight(to_tsvector('english', COALESCE(NEW.speaker, '')), 'A');
                    RETURN NEW;
                END
                $$ LANGUAGE plpgsql;
                CREATE TRIGGER session_search_vector_trigger BEFORE INSERT OR UPDATE ON session
                FOR EACH ROW EXECUTE PROCEDURE session_search_vector_update();
                '''
            )
        )
    )