X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/9ec15072e6631578584bd9c08d26025e807a8d48..79a2d819d596e610f26c08beee53f5432bfbb360:/services/api/db/migrate/20171212153352_add_gin_index_to_collection_properties.rb?ds=sidebyside

diff --git a/services/api/db/migrate/20171212153352_add_gin_index_to_collection_properties.rb b/services/api/db/migrate/20171212153352_add_gin_index_to_collection_properties.rb
new file mode 100644
index 0000000000..ce2403e743
--- /dev/null
+++ b/services/api/db/migrate/20171212153352_add_gin_index_to_collection_properties.rb
@@ -0,0 +1,8 @@
+class AddGinIndexToCollectionProperties < ActiveRecord::Migration
+  def up
+    ActiveRecord::Base.connection.execute("CREATE INDEX collection_index_on_properties ON collections USING gin (properties);")
+  end
+  def down
+    ActiveRecord::Base.connection.execute("DROP INDEX collection_index_on_properties")
+  end
+end