Mercurial > hg > soundsoftware-site

view db/migrate/20100313132032_add_issues_nested_sets_columns.rb @ 535:dd9d9c0ff0f9 feature_36

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
created the helpers to display correctly the My Publications Authors and Projects.
author luisf <luis.figueira@eecs.qmul.ac.uk>
date Tue, 26 Jul 2011 18:25:14 +0100
parents 513646585e45
children cbb26bc654de
line wrap: on
line source
class AddIssuesNestedSetsColumns < ActiveRecord::Migration
  def self.up
    add_column :issues, :parent_id, :integer, :default => nil
    add_column :issues, :root_id, :integer, :default => nil
    add_column :issues, :lft, :integer, :default => nil
    add_column :issues, :rgt, :integer, :default => nil
    
    Issue.update_all("parent_id = NULL, root_id = id, lft = 1, rgt = 2")
  end

  def self.down
    remove_column :issues, :parent_id
    remove_column :issues, :root_id
    remove_column :issues, :lft
    remove_column :issues, :rgt
  end
end