13562: Add "properties" field to groups, supports subproperty query.

[arvados.git] / services / api / db / migrate / 20180608123145_add_properties_to_groups.rb

class AddPropertiesToGroups < ActiveRecord::Migration
  def up
    add_column :groups, :properties, :jsonb, default: {}
    ActiveRecord::Base.connection.execute("CREATE INDEX group_index_on_properties ON groups USING gin (properties);")
  end

  def down
    ActiveRecord::Base.connection.execute("DROP INDEX IF EXISTS group_index_on_properties")
    remove_column :groups, :properties
  end
end