summaryrefslogtreecommitdiffstats
path: root/db/migrate/20091220183727_add_index_to_settings_name.rb
diff options
context:
space:
mode:
authorEric Davis <edavis@littlestreamsoftware.com>2009-12-20 19:13:22 +0000
committerEric Davis <edavis@littlestreamsoftware.com>2009-12-20 19:13:22 +0000
commit1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f (patch)
treebd09373e5322dec25bbafe8ec8730e4ef24b0c22 /db/migrate/20091220183727_add_index_to_settings_name.rb
parent7955e1eb9facf7349dd9b2ec1fb389b1eedb4a34 (diff)
downloadredmine-1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f.tar.gz
redmine-1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f.zip
Added some database indexes to commonly queried fields.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3206 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db/migrate/20091220183727_add_index_to_settings_name.rb')
-rw-r--r--db/migrate/20091220183727_add_index_to_settings_name.rb9
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrate/20091220183727_add_index_to_settings_name.rb b/db/migrate/20091220183727_add_index_to_settings_name.rb
new file mode 100644
index 000000000..e6c96ec3f
--- /dev/null
+++ b/db/migrate/20091220183727_add_index_to_settings_name.rb
@@ -0,0 +1,9 @@
+class AddIndexToSettingsName < ActiveRecord::Migration
+ def self.up
+ add_index :settings, :name
+ end
+
+ def self.down
+ remove_index :settings, :name
+ end
+end