diff options
| -rw-r--r-- | db/migrate/091_add_censor_rules_indices.rb | 11 | ||||
| -rw-r--r-- | db/schema.rb | 6 |
2 files changed, 16 insertions, 1 deletions
diff --git a/db/migrate/091_add_censor_rules_indices.rb b/db/migrate/091_add_censor_rules_indices.rb new file mode 100644 index 000000000..59f5db6cc --- /dev/null +++ b/db/migrate/091_add_censor_rules_indices.rb @@ -0,0 +1,11 @@ +class AddCensorRulesIndices < ActiveRecord::Migration + def self.up + add_index :censor_rules, :info_request_id + add_index :censor_rules, :user_id + add_index :censor_rules, :public_body_id + end + + def self.down + raise "no down" + end +end diff --git a/db/schema.rb b/db/schema.rb index c79ef31c9..d0dcead79 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 => 90) do +ActiveRecord::Schema.define(:version => 91) do create_table "acts_as_xapian_jobs", :force => true do |t| t.string "model", :null => false @@ -31,6 +31,10 @@ ActiveRecord::Schema.define(:version => 90) do t.datetime "updated_at", :null => false end + add_index "censor_rules", ["info_request_id"], :name => "index_censor_rules_on_info_request_id" + add_index "censor_rules", ["public_body_id"], :name => "index_censor_rules_on_public_body_id" + add_index "censor_rules", ["user_id"], :name => "index_censor_rules_on_user_id" + create_table "comments", :force => true do |t| t.integer "user_id", :null => false t.string "comment_type", :default => "internal_error", :null => false |