Chris@909: class AddIssuesNestedSetsColumns < ActiveRecord::Migration
Chris@909:   def self.up
Chris@909:     add_column :issues, :parent_id, :integer, :default => nil
Chris@909:     add_column :issues, :root_id, :integer, :default => nil
Chris@909:     add_column :issues, :lft, :integer, :default => nil
Chris@909:     add_column :issues, :rgt, :integer, :default => nil
Chris@909: 
Chris@909:     Issue.update_all("parent_id = NULL, root_id = id, lft = 1, rgt = 2")
Chris@909:   end
Chris@909: 
Chris@909:   def self.down
Chris@909:     remove_column :issues, :parent_id
Chris@909:     remove_column :issues, :root_id
Chris@909:     remove_column :issues, :lft
Chris@909:     remove_column :issues, :rgt
Chris@909:   end
Chris@909: end