diff options
author | Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com> | 2012-12-03 19:50:33 +0400 |
---|---|---|
committer | Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com> | 2012-12-03 19:50:33 +0400 |
commit | 8dec24a33ca35cbd9daa6ba38df4fe1e1f9eb2ee (patch) | |
tree | 05b6b84a12e5a976cb2813497d39b9bd8ab14e6f /db | |
parent | 05820516f1940b50a493fe9f702bdb0a57723d19 (diff) |
Event indices related to #2159
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/20121203154450_add_events_indices.rb | 8 | ||||
-rw-r--r-- | db/schema.rb | 7 |
2 files changed, 14 insertions, 1 deletions
diff --git a/db/migrate/20121203154450_add_events_indices.rb b/db/migrate/20121203154450_add_events_indices.rb new file mode 100644 index 00000000000..502a2ccbcda --- /dev/null +++ b/db/migrate/20121203154450_add_events_indices.rb @@ -0,0 +1,8 @@ +class AddEventsIndices < ActiveRecord::Migration + def change + add_index :events, :project_id + add_index :events, :author_id + add_index :events, :action + add_index :events, :target_type + end +end diff --git a/db/schema.rb b/db/schema.rb index 32dafed2b63..dca7b109df7 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20121123164910) do +ActiveRecord::Schema.define(:version => 20121203154450) do create_table "events", :force => true do |t| t.string "target_type" @@ -25,6 +25,11 @@ ActiveRecord::Schema.define(:version => 20121123164910) do t.integer "author_id" end + add_index "events", ["action"], :name => "index_events_on_action" + add_index "events", ["author_id"], :name => "index_events_on_author_id" + add_index "events", ["project_id"], :name => "index_events_on_project_id" + add_index "events", ["target_type"], :name => "index_events_on_target_type" + create_table "issues", :force => true do |t| t.string "title" t.integer "assignee_id" |