summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2007-12-07 11:19:30 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2007-12-07 11:19:30 +0000
commit5e38bd93634b9135e5f294ec1823e8a6b04c3b64 (patch)
tree0abe6ed37c9b5f8e6c2266b75178af7b4a2b9c73 /db
parenta79cf8d574d1bdad8483586014019ed9ee2b3bdf (diff)
downloadredmine-5e38bd93634b9135e5f294ec1823e8a6b04c3b64.tar.gz
redmine-5e38bd93634b9135e5f294ec1823e8a6b04c3b64.zip
Performance improvement on workflow setup screen.
git-svn-id: http://redmine.rubyforge.org/svn/trunk@957 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db')
-rw-r--r--db/migrate/085_add_role_tracker_old_status_index_to_workflows.rb9
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrate/085_add_role_tracker_old_status_index_to_workflows.rb b/db/migrate/085_add_role_tracker_old_status_index_to_workflows.rb
new file mode 100644
index 000000000..523cf091b
--- /dev/null
+++ b/db/migrate/085_add_role_tracker_old_status_index_to_workflows.rb
@@ -0,0 +1,9 @@
+class AddRoleTrackerOldStatusIndexToWorkflows < ActiveRecord::Migration
+ def self.up
+ add_index :workflows, [:role_id, :tracker_id, :old_status_id], :name => :workflows_role_tracker_old_status
+ end
+
+ def self.down
+ remove_index :workflows, :name => :workflows_role_tracker_old_status
+ end
+end