diff options
7 files changed, 69 insertions, 0 deletions
diff --git a/db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb b/db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb new file mode 100644 index 000000000..14174935e --- /dev/null +++ b/db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb @@ -0,0 +1,9 @@ +class AddRawEmailIndexToIncomingMessages < ActiveRecord::Migration + def self.up + add_index :incoming_messages, :raw_email_id + end + + def self.down + remove_index :incoming_messages, :raw_email_id + end +end diff --git a/db/migrate/20120912112036_add_info_request_id_index_to_exim_logs.rb b/db/migrate/20120912112036_add_info_request_id_index_to_exim_logs.rb new file mode 100644 index 000000000..81e2a7946 --- /dev/null +++ b/db/migrate/20120912112036_add_info_request_id_index_to_exim_logs.rb @@ -0,0 +1,9 @@ +class AddInfoRequestIdIndexToEximLogs < ActiveRecord::Migration + def self.up + add_index :exim_logs, :info_request_id + end + + def self.down + remove_index :exim_logs, :info_request_id + end +end diff --git a/db/migrate/20120912112312_add_info_request_id_index_to_incoming_and_outgoing_messages.rb b/db/migrate/20120912112312_add_info_request_id_index_to_incoming_and_outgoing_messages.rb new file mode 100644 index 000000000..814fa7540 --- /dev/null +++ b/db/migrate/20120912112312_add_info_request_id_index_to_incoming_and_outgoing_messages.rb @@ -0,0 +1,11 @@ +class AddInfoRequestIdIndexToIncomingAndOutgoingMessages < ActiveRecord::Migration + def self.up + add_index :incoming_messages, :info_request_id + add_index :outgoing_messages, :info_request_id + end + + def self.down + remove_index :incoming_messages, :info_request_id + remove_index :outgoing_messages, :info_request_id + end +end diff --git a/db/migrate/20120912112655_add_incoming_message_id_index_to_foi_attachments.rb b/db/migrate/20120912112655_add_incoming_message_id_index_to_foi_attachments.rb new file mode 100644 index 000000000..be0bf76c3 --- /dev/null +++ b/db/migrate/20120912112655_add_incoming_message_id_index_to_foi_attachments.rb @@ -0,0 +1,9 @@ +class AddIncomingMessageIdIndexToFoiAttachments < ActiveRecord::Migration + def self.up + add_index :foi_attachments, :incoming_message_id + end + + def self.down + remove_index :foi_attachments, :incoming_message_id + end +end diff --git a/db/migrate/20120912113004_add_indexes_to_info_request_events.rb b/db/migrate/20120912113004_add_indexes_to_info_request_events.rb new file mode 100644 index 000000000..b3780322f --- /dev/null +++ b/db/migrate/20120912113004_add_indexes_to_info_request_events.rb @@ -0,0 +1,13 @@ +class AddIndexesToInfoRequestEvents < ActiveRecord::Migration + def self.up + add_index :info_request_events, :incoming_message_id + add_index :info_request_events, :outgoing_message_id + add_index :info_request_events, :comment_id + end + + def self.down + remove_index :info_request_events, :incoming_message_id + remove_index :info_request_events, :outgoing_message_id + remove_index :info_request_events, :comment_id + end +end diff --git a/db/migrate/20120912113720_add_public_body_index_to_info_requests.rb b/db/migrate/20120912113720_add_public_body_index_to_info_requests.rb new file mode 100644 index 000000000..a56cad1f9 --- /dev/null +++ b/db/migrate/20120912113720_add_public_body_index_to_info_requests.rb @@ -0,0 +1,9 @@ +class AddPublicBodyIndexToInfoRequests < ActiveRecord::Migration + def self.up + add_index :info_requests, :public_body_id + end + + def self.down + remove_index :info_requests, :public_body_id + end +end diff --git a/db/migrate/20120912114022_add_user_index_to_info_requests.rb b/db/migrate/20120912114022_add_user_index_to_info_requests.rb new file mode 100644 index 000000000..8be51c0c8 --- /dev/null +++ b/db/migrate/20120912114022_add_user_index_to_info_requests.rb @@ -0,0 +1,9 @@ +class AddUserIndexToInfoRequests < ActiveRecord::Migration + def self.up + add_index :info_requests, :user_id + end + + def self.down + remove_index :info_requests, :user_id + end +end |