def METHOD_NAME():
    op.execute('CREATE TYPE comment_types AS ENUM ("text", "redshift"")')
    op.execute('CREATE TYPE followup_apis__old_version_to_be_dropped')
    op.execute(
        'ALTER TABLE "public"."instruments" ALTER COLUMN api_classname TYPE api_classname::text::"public"."followup_apis" USING "public"."followup_apis"'
    )
    op.execute('DROP TYPE  "public"."followup_apis"')
    op.execute(
        'ALTER TYPE "followup_apis__old_version_to_be_dropped" RENAME TO "public"."followup_apis"'
    )
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        'comments',
        sa.Column(
            'ctype',
            postgresql.ENUM('text', 'redshift', name='comment_types'),
            autoincrement=False,
            nullable=True,
        ),
    )
    op.drop_index(
        op.f('ix_group_comments_on_spectra_created_at'),
        table_name='group_comments_on_spectra',
    )
    op.drop_index(
        'group_comments_on_spectra_reverse_ind', table_name='group_comments_on_spectra'
    )
    op.drop_index(
        'group_comments_on_spectra_forward_ind', table_name='group_comments_on_spectra'
    )
    op.drop_table('group_comments_on_spectra')
    op.drop_index(
        op.f('ix_comments_on_spectra_spectrum_id'), table_name='comments_on_spectra'
    )
    op.drop_index(
        op.f('ix_comments_on_spectra_obj_id'), table_name='comments_on_spectra'
    )
    op.drop_index(
        op.f('ix_comments_on_spectra_created_at'), table_name='comments_on_spectra'
    )
    op.drop_index(
        op.f('ix_comments_on_spectra_author_id'), table_name='comments_on_spectra'
    )
    op.drop_table('comments_on_spectra')
    # ### end Alembic commands ###