Mercurial > hg > soundsoftware-site
annotate db/migrate/.svn/text-base/081_create_projects_trackers.rb.svn-base @ 507:0c939c159af4 redmine-1.2
Update to Redmine 1.2.1 on 1.2-stable branch (Redmine SVN rev 6270)
author | Chris Cannam |
---|---|
date | Thu, 14 Jul 2011 10:32:19 +0100 |
parents | 513646585e45 |
children |
rev | line source |
---|---|
Chris@0 | 1 class CreateProjectsTrackers < ActiveRecord::Migration |
Chris@0 | 2 def self.up |
Chris@0 | 3 create_table :projects_trackers, :id => false do |t| |
Chris@0 | 4 t.column :project_id, :integer, :default => 0, :null => false |
Chris@0 | 5 t.column :tracker_id, :integer, :default => 0, :null => false |
Chris@0 | 6 end |
Chris@0 | 7 add_index :projects_trackers, :project_id, :name => :projects_trackers_project_id |
Chris@0 | 8 |
Chris@0 | 9 # Associates all trackers to all projects (as it was before) |
Chris@0 | 10 tracker_ids = Tracker.find(:all).collect(&:id) |
Chris@0 | 11 Project.find(:all).each do |project| |
Chris@0 | 12 project.tracker_ids = tracker_ids |
Chris@0 | 13 end |
Chris@0 | 14 end |
Chris@0 | 15 |
Chris@0 | 16 def self.down |
Chris@0 | 17 drop_table :projects_trackers |
Chris@0 | 18 end |
Chris@0 | 19 end |