defmodule Medicode.Repo.Migrations.MigrateToVectorForCodeFeedbacks do
  use Ecto.Migration

  def change do
    alter table("code_feedbacks") do
      add :text_vector, :vector, size: 384

      add :code_vector_id,
          references(:code_vectors, type: :binary_id, on_delete: :delete_all),
          null: false

      # These two columns can be found on the `code_vectors` table referenced above
      remove :code, :string
      remove :long_description, :string
    end
  end
end