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