And indices for everything that is searched for or ordered by.

1 files changed, 7 insertions, 1 deletions

diff --git a/db/schema.rb b/db/schema.rb
index 6632f5de9..07e62f893 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 29) do
+ActiveRecord::Schema.define(:version => 30) do
 
   create_table "incoming_messages", :force => true do |t|
     t.integer  "info_request_id",                    :null => false
@@ -37,6 +37,9 @@ ActiveRecord::Schema.define(:version => 29) do
     t.boolean  "awaiting_description", :default => false, :null => false
   end
 
+  add_index "info_requests", ["created_at"], :name => "index_info_requests_on_created_at"
+  add_index "info_requests", ["title"], :name => "index_info_requests_on_title"
+
   create_table "outgoing_messages", :force => true do |t|
     t.integer  "info_request_id",              :null => false
     t.text     "body",                         :null => false
@@ -59,6 +62,9 @@ ActiveRecord::Schema.define(:version => 29) do
     t.integer  "user_id"
   end
 
+  add_index "post_redirects", ["email_token"], :name => "index_post_redirects_on_email_token"
+  add_index "post_redirects", ["token"], :name => "index_post_redirects_on_token"
+
   create_table "public_bodies", :force => true do |t|
     t.text     "name",              :null => false
     t.text     "short_name",        :null => false