Contents

class RenameBacklogsToProjects < ActiveRecord::Migration
  def self.up
    remove_foreign_key "backlogs", "backlogs_customer_id_fkey"
    remove_foreign_key "tasks", "tasks_backlog_id_fkey"
    remove_foreign_key "work_lock_subscriptions", "work_lock_subscriptions_backlog_id_fkey"
    remove_foreign_key "works", "works_backlog_id_fkey"
    
    rename_table :backlogs, :projects
    rename_column :tasks, :backlog_id, :project_id
    rename_column :work_lock_subscriptions, :backlog_id, :project_id
    rename_column :works, :backlog_id, :project_id
        
    add_foreign_key "projects", ["customer_id"], "customers", ["id"], :name => "projects_customer_id_fkey"
    add_foreign_key "tasks", ["project_id"], "projects", ["id"], :name => "tasks_project_id_fkey"
    add_foreign_key "work_lock_subscriptions", ["project_id"], "projects", ["id"], :name => "work_lock_subscriptions_project_id_fkey"
    add_foreign_key "works", ["project_id"], "projects", ["id"], :name => "works_project_id_fkey"
  end
  
  def self.down
    raise "Not gonna happen!"
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
backlog-0.37.2	db/migrate/20101006092700_rename_backlogs_to_projects.rb
backlog-0.37.1	db/migrate/20101006092700_rename_backlogs_to_projects.rb