| @@ -1,19 +1,19 | |||||
| 1 | class CreateProjectsTrackers < ActiveRecord::Migration |
|
1 | class CreateProjectsTrackers < ActiveRecord::Migration | |
| 2 | def self.up |
|
2 | def self.up | |
| 3 | create_table :projects_trackers, :id => false do |t| |
|
3 | create_table :projects_trackers, :id => false do |t| | |
| 4 | t.column :project_id, :integer, :default => 0, :null => false |
|
4 | t.column :project_id, :integer, :default => 0, :null => false | |
| 5 | t.column :tracker_id, :integer, :default => 0, :null => false |
|
5 | t.column :tracker_id, :integer, :default => 0, :null => false | |
| 6 | end |
|
6 | end | |
| 7 | add_index :projects_trackers, :project_id, :name => :projects_trackers_project_id |
|
7 | add_index :projects_trackers, :project_id, :name => :projects_trackers_project_id | |
| 8 |
|
8 | |||
| 9 | # Associates all trackers to all projects (as it was before) |
|
9 | # Associates all trackers to all projects (as it was before) | |
| 10 | tracker_ids = Tracker.find(:all).collect(&:id) |
|
10 | tracker_ids = Tracker.find(:all).collect(&:id) | |
| 11 | Project.find(:all).each do |project| |
|
11 | Project.find(:all).each do |project| | |
| 12 | project.tracker_ids = tracker_ids |
|
12 | project.tracker_ids = tracker_ids | |
| 13 | end |
|
13 | end | |
| 14 | end |
|
14 | end | |
| 15 |
|
15 | |||
| 16 | def self.down |
|
16 | def self.down | |
| 17 | drop_table :projects_trackers |
|
17 | drop_table :projects_trackers | |
| 18 | end |
|
18 | end | |
| 19 | end |
|
19 | end | |
General Comments 0
You need to be logged in to leave comments.
Login now