Sha256: 17f35d8084a16d26b6f929037bc5e1feff96ae154a7f394e98a292195fd0ea46

Contents?: true

Size: 404 Bytes

Versions: 6

Compression:

Stored size: 404 Bytes

Contents

class EltChildrenCount < ActiveRecord::Migration
  def self.up
		add_column :elts, :elts_count, :integer, :default => 0
		execute 'UPDATE elts SET elts_count = (SELECT COUNT(*) FROM elts e2 WHERE e2.parent_id = elts.id)'
		add_index "elts", ["lft"], :name => "elts_lft_key"
		add_index "elts", ["parent_id"], :name => "elts_parent_key"
  end

  def self.down
		remove_column :elts, :elts_count
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version Path
parlement-0.10 db/migrate/003_elt_children_count.rb
parlement-0.11 db/migrate/003_elt_children_count.rb
parlement-0.12 db/migrate/003_elt_children_count.rb
parlement-0.13 db/migrate/003_elt_children_count.rb
parlement-0.14 db/migrate/003_elt_children_count.rb
parlement-0.17 db/migrate/003_elt_children_count.rb