class RemoveLegacyAssistant < ActiveRecord::Migration[7.0]
  def change
    drop_table :assistant_threads do |t|
      t.string :thread_id
      t.string :assistant_id
      t.integer :user_id
      t.timestamps

      t.index [:user_id], name: "index_assistant_threads_on_user_id"
    end

    remove_column :respondents, :assistant_file_id, :string
    remove_column :respondent_categories, :assistant_id, :integer
  end
end