services/api/db/migrate/20151215134304_fix_containers_index.rb

   1 class FixContainersIndex < ActiveRecord::Migration
   2   def up
   3     execute "CREATE INDEX container_requests_full_text_search_idx ON container_requests USING gin(#{ContainerRequest.full_text_tsvector});"
   4     add_index :container_requests, ["uuid", "owner_uuid", "modified_by_client_uuid", "modified_by_user_uuid", "name", "state", "requesting_container_uuid", "container_uuid", "container_image", "cwd", "output_path"], name: 'container_requests_search_index'
   5     add_index :containers, ["uuid", "owner_uuid", "modified_by_client_uuid", "modified_by_user_uuid", "state", "log", "cwd", "output_path", "output", "container_image"], name: 'containers_search_index'
   6     add_index :container_requests, :owner_uuid
   7     add_index :containers, :owner_uuid
   8   end
   9
  10   def down
  11     remove_index :container_requests, :name => 'container_requests_full_text_search_idx'
  12     remove_index :container_requests, :name => 'container_requests_search_index'
  13     remove_index :containers, :name => 'containers_search_index'
  14     remove_index :container_requests, :owner_uuid
  15     remove_index :containers, :owner_uuid
  16   end
  17 end