services/api/db/migrate/20160509143250_add_auth_and_lock_to_container_index.rb

   1 # Copyright (C) The Arvados Authors. All rights reserved.
   2 #
   3 # SPDX-License-Identifier: AGPL-3.0
   4
   5 class AddAuthAndLockToContainerIndex < ActiveRecord::Migration
   6   Columns_were = ["uuid", "owner_uuid", "modified_by_client_uuid", "modified_by_user_uuid", "state", "log", "cwd", "output_path", "output", "container_image"]
   7   Columns = Columns_were + ["auth_uuid", "locked_by_uuid"]
   8   def up
   9     begin
  10       remove_index :containers, :name => 'containers_search_index'
  11     rescue
  12     end
  13     add_index(:containers, Columns, name: "containers_search_index")
  14   end
  15
  16   def down
  17     begin
  18       remove_index :containers, :name => 'containers_search_index'
  19     rescue
  20     end
  21     add_index(:containers, Columns_were, name: "containers_search_index")
  22   end
  23 end