adding indeces to events table

2 files changed, 8 insertions, 0 deletions

diff --git a/db/migrate/20150320001810_create_event_table.rb b/db/migrate/20150320001810_create_event_table.rb
index 555aee9..8d889ae 100644
--- a/db/migrate/20150320001810_create_event_table.rb
+++ b/db/migrate/20150320001810_create_event_table.rb
@@ -7,6 +7,10 @@ class CreateEventTable < ActiveRecord::Migration
       t.text    :description
 
       t.timestamps
+      
+      t.index :created_at
+      t.index :is_admin
+      t.index :project_id
     end
   end
 end
diff --git a/db/schema.rb b/db/schema.rb
index b7b58ce..390d175 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -66,6 +66,10 @@ ActiveRecord::Schema.define(version: 20150320001810) do
     t.datetime "updated_at"
   end
 
+  add_index "events", ["created_at"], name: "index_events_on_created_at", using: :btree
+  add_index "events", ["is_admin"], name: "index_events_on_is_admin", using: :btree
+  add_index "events", ["project_id"], name: "index_events_on_project_id", using: :btree
+
   create_table "jobs", force: true do |t|
     t.integer  "project_id",                          null: false
     t.text     "commands"