##// END OF EJS Templates
Added some database indexes to commonly queried fields....
Eric Davis -
r3092:1ebb78e412a7
parent child
Show More
@@ -0,0 +1,11
1 class AddLftAndRgtIndexesToProjects < ActiveRecord::Migration
2 def self.up
3 add_index :projects, :lft
4 add_index :projects, :rgt
5 end
6
7 def self.down
8 remove_index :projects, :lft
9 remove_index :projects, :rgt
10 end
11 end
@@ -0,0 +1,9
1 class AddIndexToSettingsName < ActiveRecord::Migration
2 def self.up
3 add_index :settings, :name
4 end
5
6 def self.down
7 remove_index :settings, :name
8 end
9 end
@@ -0,0 +1,13
1 class AddIndexesToIssueStatus < ActiveRecord::Migration
2 def self.up
3 add_index :issue_statuses, :position
4 add_index :issue_statuses, :is_closed
5 add_index :issue_statuses, :is_default
6 end
7
8 def self.down
9 remove_index :issue_statuses, :position
10 remove_index :issue_statuses, :is_closed
11 remove_index :issue_statuses, :is_default
12 end
13 end
General Comments 0
You need to be logged in to leave comments. Login now