Schema improvements suggested by Yorick

2 files changed, 5 insertions, 2 deletions

diff --git a/db/migrate/20160315135439_project_add_repository_check.rb b/db/migrate/20160315135439_project_add_repository_check.rb
index 5a0859a30b2..8687d5d6296 100644
--- a/db/migrate/20160315135439_project_add_repository_check.rb
+++ b/db/migrate/20160315135439_project_add_repository_check.rb
@@ -1,6 +1,8 @@
 class ProjectAddRepositoryCheck < ActiveRecord::Migration
   def change
-    add_column :projects, :last_repository_check_failed, :boolean, default: false
+    add_column :projects, :last_repository_check_failed, :boolean
+    add_index :projects, :last_repository_check_failed
+
     add_column :projects, :last_repository_check_at, :datetime
   end
 end
diff --git a/db/schema.rb b/db/schema.rb
index db18d56f9cd..863e1f3f075 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -732,7 +732,7 @@ ActiveRecord::Schema.define(version: 20160412140240) do
     t.boolean  "public_builds",          default: true,     null: false
     t.string   "main_language"
     t.integer  "pushes_since_gc",        default: 0
-    t.boolean  "last_repository_check_failed", default: false
+    t.boolean  "last_repository_check_failed"
     t.datetime "last_repository_check_at"
   end
 
@@ -743,6 +743,7 @@ ActiveRecord::Schema.define(version: 20160412140240) do
   add_index "projects", ["creator_id"], name: "index_projects_on_creator_id", using: :btree
   add_index "projects", ["description"], name: "index_projects_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
   add_index "projects", ["last_activity_at"], name: "index_projects_on_last_activity_at", using: :btree
+  add_index "projects", ["last_repository_check_failed"], name: "index_projects_on_last_repository_check_failed", using: :btree
   add_index "projects", ["name"], name: "index_projects_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
   add_index "projects", ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
   add_index "projects", ["path"], name: "index_projects_on_path", using: :btree