dolan

class CreateItemChildrenCountView < ActiveRecord::Migration
  def self.up
    execute <<-SQL
      CREATE VIEW item_children_count AS
      SELECT parent_id AS item_id, COUNT(*) as children_count
      FROM items GROUP BY parent_id;
    SQL
  end

  def self.down