class CreateAssetGroups < ActiveRecord::Migration
  def change
    create_table :asset_groups do |t|
      t.string    :type,            :null => false, :limit => 50
      t.string    :name,            :null => false, :limit => 200, :index => :unique

      # Nested set
      t.integer   :asset_group_id,  :null => true,  :on_delete => :cascade
      t.integer   :lft,             :null => true
      t.integer   :rgt,             :null => true
      t.integer   :depth,           :null => false, :limit => 3, :default => 1
      t.integer   :children_count,  :null => false, :limit => 3, :default => 0

      t.integer   :creator_id,      :null => false, :references => :users
      t.integer   :updater_id,      :null => false, :references => :users

      t.timestamps
    end
  end
end

class CreateAssetGroups < ActiveRecord::Migration
  def change
    create_table :asset_groups do |t|
      t.string    :type,            :null => false, :limit => 50
      t.string    :name,            :null => false, :limit => 200, :index => {:unique => true, :with => :asset_group_id}

      # Nested set
      t.integer   :asset_group_id,  :null => true,  :on_delete => :cascade
      t.integer   :lft,             :null => true
      t.integer   :rgt,             :null => true
      t.integer   :depth,           :null => false, :limit => 3, :default => 1
      t.integer   :children_count,  :null => false, :limit => 3, :default => 0

      t.integer   :creator_id,      :null => false, :references => :users
      t.integer   :updater_id,      :null => false, :references => :users

      t.timestamps
    end
  end
end

Change the unique constraints on the asset group name to apply only within a leaf of the hierarchy.
Change the unique constraints on the asset group name to apply only within a leaf of the hierarchy.
