aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/001_create_users.rb1
-rw-r--r--db/migrate/002_add_sessions.rb1
-rw-r--r--db/migrate/004_create_info_requests.rb1
-rw-r--r--db/migrate/005_create_public_bodies.rb1
-rw-r--r--db/migrate/006_version_public_body.rb1
-rw-r--r--db/migrate/007_add_public_body_editor_notes.rb1
-rw-r--r--db/migrate/008_request_has_public_body.rb1
-rw-r--r--db/migrate/009_create_outgoing_messages.rb1
-rw-r--r--db/migrate/010_remove_public_body_id_from_outgoing_messages.rb1
-rw-r--r--db/migrate/011_add_created_updated_fields.rb1
-rw-r--r--db/migrate/012_add_sent_outgoing_message.rb1
-rw-r--r--db/migrate/013_create_incoming_messages.rb1
-rw-r--r--db/migrate/014_create_post_redirects.rb1
-rw-r--r--db/migrate/015_add_email_token_to_post_redirects.rb1
-rw-r--r--db/migrate/016_add_reasons_to_post_redirects.rb1
-rw-r--r--db/migrate/017_add_email_confirmed_to_users.rb1
-rw-r--r--db/migrate/018_add_response_type_to_incoming_message.rb1
-rw-r--r--db/migrate/021_remove_contains_information_default.rb1
-rw-r--r--db/migrate/022_create_info_request_events.rb1
-rw-r--r--db/migrate/023_outgoing_message_last_sent_at.rb1
-rw-r--r--db/migrate/024_add_is_bounce_to_incoming_messages.rb1
-rw-r--r--db/migrate/025_add_followup_to_outgoing_message.rb1
-rw-r--r--db/migrate/026_add_many_null_constraints.rb1
-rw-r--r--db/migrate/027_change_classification_system.rb1
-rw-r--r--db/migrate/028_give_incoming_messages_events.rb1
-rw-r--r--db/migrate/029_add_describe_status_history.rb1
-rw-r--r--db/migrate/030_add_some_indices.rb1
-rw-r--r--db/migrate/031_add_indices_for_session_deletion.rb1
-rw-r--r--db/migrate/032_addforeignkeys.rb1
-rw-r--r--db/migrate/033_add_prominence.rb1
-rw-r--r--db/migrate/034_run_solr_indexing.rb1
-rw-r--r--db/migrate/035_track_overdue_alerts.rb1
-rw-r--r--db/migrate/036_add_public_body_tags.rb1
-rw-r--r--db/migrate/037_add_url_name.rb1
-rw-r--r--db/migrate/038_add_more_url_names.rb1
-rw-r--r--db/migrate/039_request_url_names.rb1
-rw-r--r--db/migrate/040_email_is_unique.rb1
-rw-r--r--db/migrate/041_index_requests_with_solr.rb1
-rw-r--r--db/migrate/042_unique_user_urls.rb1
-rw-r--r--db/migrate/043_remove_complaint_email.rb1
-rw-r--r--db/migrate/044_remove_is_bounce.rb1
-rw-r--r--db/migrate/045_add_circumstance_to_post_redirect.rb1
-rw-r--r--db/migrate/046_add_last_event_id_to_alert_table.rb1
-rw-r--r--db/migrate/047_add_calculated_state.rb1
-rw-r--r--db/migrate/048_add_calculated_state_at.rb1
-rw-r--r--db/migrate/049_track_things.rb1
-rw-r--r--db/migrate/050_improve_track_things.rb1
-rw-r--r--db/migrate/051_add_track_things_unique_indices.rb1
-rw-r--r--db/migrate/052_include_event_foreign_references.rb1
-rw-r--r--db/migrate/053_acts_as_xapian_migration.rb1
-rw-r--r--db/migrate/054_allow_longer_comments.rb1
-rw-r--r--db/migrate/055_stop_new_responses.rb1
-rw-r--r--db/migrate/056_add_attachment_text.rb1
-rw-r--r--db/migrate/057_add_law_used.rb1
-rw-r--r--db/migrate/058_remove_sessions.rb1
-rw-r--r--db/migrate/059_add_url_notes.rb1
-rw-r--r--db/migrate/060_add_cached_main_text.rb1
-rw-r--r--db/migrate/061_include_responses_in_tracks.rb1
-rw-r--r--db/migrate/062_add_comments.rb1
-rw-r--r--db/migrate/063_add_admin_users.rb1
-rw-r--r--db/migrate/064_indices_for_annotations.rb1
-rw-r--r--db/migrate/065_add_comments_to_user_track.rb1
-rw-r--r--db/migrate/066_add_first_letter.rb1
-rw-r--r--db/migrate/067_factor_out_raw_email.rb1
-rw-r--r--db/migrate/068_add_censor_table.rb1
-rw-r--r--db/migrate/069_add_what_doing.rb1
-rw-r--r--db/migrate/070_sent_are_waiting_response.rb1
-rw-r--r--db/migrate/071_add_exim_log.rb1
-rw-r--r--db/migrate/072_add_publication_scheme.rb1
-rw-r--r--db/migrate/073_add_ban_user.rb1
-rw-r--r--db/migrate/074_create_holidays.rb1
-rw-r--r--db/migrate/075_add_charity_number.rb1
-rw-r--r--db/migrate/076_add_indices.rb1
-rw-r--r--db/migrate/077_add_exim_log_index.rb1
-rw-r--r--db/migrate/078_expand_stop_new_responses.rb1
-rw-r--r--db/migrate/079_add_profile_photo.rb1
-rw-r--r--db/migrate/080_cache_only_clipped_attachment_text.rb1
-rw-r--r--db/migrate/081_add_event_prominence.rb1
-rw-r--r--db/migrate/082_change_raw_email_to_binary.rb1
-rw-r--r--db/migrate/083_add_indices_track_sent.rb1
-rw-r--r--db/migrate/084_alter_profile_photo.rb1
-rw-r--r--db/migrate/085_draft_profile_photo.rb1
-rw-r--r--db/migrate/086_allow_null_profile_photo_user.rb1
-rw-r--r--db/migrate/087_add_about_me.rb1
-rw-r--r--db/migrate/088_public_body_machine_tags.rb1
-rw-r--r--db/migrate/089_remove_charity_number.rb1
-rw-r--r--db/migrate/090_remove_tag_uniqueness.rb1
-rw-r--r--db/migrate/091_add_censor_rules_indices.rb1
-rw-r--r--db/migrate/092_cache_only_marked_body_text.rb1
-rw-r--r--db/migrate/093_move_to_has_tag_string.rb1
-rw-r--r--db/migrate/094_remove_old_tags_foreign_key.rb1
-rw-r--r--db/migrate/095_add_post_redirect_user_index.rb1
-rw-r--r--db/migrate/096_create_translation_tables.rb1
-rw-r--r--db/migrate/097_add_comment_locale.rb1
-rw-r--r--db/migrate/098_fix_public_body_translations.rb1
-rw-r--r--db/migrate/099_move_raw_email_to_filesystem.rb1
-rw-r--r--db/migrate/100_remove_redundant_raw_email_columns.rb1
-rw-r--r--db/migrate/101_add_hash_to_info_request.rb1
-rw-r--r--db/migrate/102_add_locale_to_users.rb1
-rw-r--r--db/migrate/103_add_user_bounce_columns.rb1
-rw-r--r--db/migrate/104_create_foi_attachments.rb1
-rw-r--r--db/migrate/105_extend_incoming_message.rb1
-rw-r--r--db/migrate/106_add_hex_digest_to_foi_attachment.rb1
-rw-r--r--db/migrate/107_add_date_parsed_field_to_incoming_message.rb1
-rw-r--r--db/migrate/108_change_safe_mail_from_to_mail_from.rb1
-rw-r--r--db/migrate/109_change_sent_at_to_datetime.rb1
-rw-r--r--db/migrate/110_add_user_no_limit.rb1
-rw-r--r--db/migrate/111_create_purge_requests.rb1
-rw-r--r--db/migrate/112_add_api_key_to_public_bodies.rb1
-rw-r--r--db/migrate/113_add_external_fields_to_info_requests.rb1
-rw-r--r--db/migrate/114_add_attention_requested_flag_to_info_requests.rb1
-rw-r--r--db/migrate/115_add_receive_email_alerts_to_user.rb1
-rw-r--r--db/migrate/116_add_censor_rule_regexp.rb1
-rw-r--r--db/migrate/117_create_sessions.rb1
-rw-r--r--db/migrate/118_remove_sessions_again.rb1
-rw-r--r--db/migrate/20120822145640_correct_external_request_constraint.rb1
-rw-r--r--db/migrate/20120910153022_create_request_classifications.rb1
-rw-r--r--db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb1
-rw-r--r--db/migrate/20120912112036_add_info_request_id_index_to_exim_logs.rb1
-rw-r--r--db/migrate/20120912112312_add_info_request_id_index_to_incoming_and_outgoing_messages.rb1
-rw-r--r--db/migrate/20120912112655_add_incoming_message_id_index_to_foi_attachments.rb1
-rw-r--r--db/migrate/20120912113004_add_indexes_to_info_request_events.rb1
-rw-r--r--db/migrate/20120912113720_add_public_body_index_to_info_requests.rb1
-rw-r--r--db/migrate/20120912114022_add_user_index_to_info_requests.rb1
-rw-r--r--db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb1
-rw-r--r--db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb1
-rw-r--r--db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb1
-rw-r--r--db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb1
-rw-r--r--db/migrate/20120913135745_add_updated_at_index_to_public_body_versions.rb1
-rw-r--r--db/migrate/20120919140404_add_comments_allowed_to_info_request.rb1
-rw-r--r--db/migrate/20121010214348_rename_exim_log_tables.rb1
-rw-r--r--db/migrate/20121022031914_add_disclosure_log.rb1
-rw-r--r--db/migrate/20130731142632_remove_prominence_from_info_request_event.rb1
-rw-r--r--db/migrate/20130731145325_add_prominence_to_incoming_message.rb1
-rw-r--r--db/migrate/20130801154033_add_prominence_reason_to_incoming_message.rb1
-rw-r--r--db/migrate/20130816150110_add_statistics_to_public_body.rb1
-rw-r--r--db/migrate/20130822161803_add_prominence_fields_to_outgoing_message.rb1
-rw-r--r--db/migrate/20130919151140_add_can_make_batch_requests_to_user.rb1
-rw-r--r--db/migrate/20131024114346_create_info_request_batches.rb1
-rw-r--r--db/migrate/20131024152540_add_body_to_info_request_batches.rb1
-rw-r--r--db/migrate/20131101155844_add_stats_denominator.rb1
-rw-r--r--db/migrate/20131127105438_create_info_request_batch_public_bodies_join_table.rb1
-rw-r--r--db/migrate/20131127135622_add_sent_at_to_info_request_batch.rb1
-rw-r--r--db/migrate/20131211152641_create_public_body_change_requests.rb1
-rw-r--r--db/migrate/20140325120619_create_spam_addresses.rb1
-rw-r--r--db/migrate/20140408145616_add_default_short_name_to_public_bodies.rb1
-rw-r--r--db/migrate/20140528110536_update_track_things_index.rb1
-rw-r--r--db/migrate/20140710094405_create_public_body_headings_and_categories.rb3
-rw-r--r--db/migrate/20140716131107_create_category_translation_tables.rb1
-rw-r--r--db/migrate/20140801132719_add_index_to_info_request_events.rb1
-rw-r--r--db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb1
-rw-r--r--db/migrate/20140824191444_create_widget_votes.rb12
-rw-r--r--db/seeds.rb1
153 files changed, 165 insertions, 1 deletions
diff --git a/db/migrate/001_create_users.rb b/db/migrate/001_create_users.rb
index ba528c038..4181a37d4 100644
--- a/db/migrate/001_create_users.rb
+++ b/db/migrate/001_create_users.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateUsers < ActiveRecord::Migration
def self.up
create_table :users do |t|
diff --git a/db/migrate/002_add_sessions.rb b/db/migrate/002_add_sessions.rb
index 22b4a0065..571321683 100644
--- a/db/migrate/002_add_sessions.rb
+++ b/db/migrate/002_add_sessions.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddSessions < ActiveRecord::Migration
def self.up
create_table :sessions do |t|
diff --git a/db/migrate/004_create_info_requests.rb b/db/migrate/004_create_info_requests.rb
index 29a3a9f22..7de918c3f 100644
--- a/db/migrate/004_create_info_requests.rb
+++ b/db/migrate/004_create_info_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateInfoRequests < ActiveRecord::Migration
def self.up
create_table :info_requests do |t|
diff --git a/db/migrate/005_create_public_bodies.rb b/db/migrate/005_create_public_bodies.rb
index d37def301..9d51e4942 100644
--- a/db/migrate/005_create_public_bodies.rb
+++ b/db/migrate/005_create_public_bodies.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreatePublicBodies < ActiveRecord::Migration
def self.up
create_table :public_bodies do |t|
diff --git a/db/migrate/006_version_public_body.rb b/db/migrate/006_version_public_body.rb
index 0e4527133..3656f738f 100644
--- a/db/migrate/006_version_public_body.rb
+++ b/db/migrate/006_version_public_body.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class VersionPublicBody < ActiveRecord::Migration
def self.up
PublicBody.create_versioned_table
diff --git a/db/migrate/007_add_public_body_editor_notes.rb b/db/migrate/007_add_public_body_editor_notes.rb
index 7500ee649..d07e02b2e 100644
--- a/db/migrate/007_add_public_body_editor_notes.rb
+++ b/db/migrate/007_add_public_body_editor_notes.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddPublicBodyEditorNotes < ActiveRecord::Migration
def self.up
add_column :public_bodies, :last_edit_editor, :string
diff --git a/db/migrate/008_request_has_public_body.rb b/db/migrate/008_request_has_public_body.rb
index c7a2e9f34..95fa2731a 100644
--- a/db/migrate/008_request_has_public_body.rb
+++ b/db/migrate/008_request_has_public_body.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RequestHasPublicBody < ActiveRecord::Migration
def self.up
add_column :info_requests, :public_body_id, :integer
diff --git a/db/migrate/009_create_outgoing_messages.rb b/db/migrate/009_create_outgoing_messages.rb
index 62bf25392..a36d37cf2 100644
--- a/db/migrate/009_create_outgoing_messages.rb
+++ b/db/migrate/009_create_outgoing_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateOutgoingMessages < ActiveRecord::Migration
def self.up
create_table :outgoing_messages do |t|
diff --git a/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb b/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
index da5ffc87e..5599d6131 100644
--- a/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
+++ b/db/migrate/010_remove_public_body_id_from_outgoing_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemovePublicBodyIdFromOutgoingMessages < ActiveRecord::Migration
def self.up
remove_column :outgoing_messages, :public_body_id
diff --git a/db/migrate/011_add_created_updated_fields.rb b/db/migrate/011_add_created_updated_fields.rb
index 47bb27b78..0152ec842 100644
--- a/db/migrate/011_add_created_updated_fields.rb
+++ b/db/migrate/011_add_created_updated_fields.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCreatedUpdatedFields < ActiveRecord::Migration
def self.up
# InfoRequest
diff --git a/db/migrate/012_add_sent_outgoing_message.rb b/db/migrate/012_add_sent_outgoing_message.rb
index 8b3059347..c7b42951c 100644
--- a/db/migrate/012_add_sent_outgoing_message.rb
+++ b/db/migrate/012_add_sent_outgoing_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddSentOutgoingMessage < ActiveRecord::Migration
def self.up
add_column :outgoing_messages, :sent_at, :datetime
diff --git a/db/migrate/013_create_incoming_messages.rb b/db/migrate/013_create_incoming_messages.rb
index c747fcb8c..bd7dc20cd 100644
--- a/db/migrate/013_create_incoming_messages.rb
+++ b/db/migrate/013_create_incoming_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateIncomingMessages < ActiveRecord::Migration
def self.up
create_table :incoming_messages do |t|
diff --git a/db/migrate/014_create_post_redirects.rb b/db/migrate/014_create_post_redirects.rb
index 26c561dac..1f5c8f146 100644
--- a/db/migrate/014_create_post_redirects.rb
+++ b/db/migrate/014_create_post_redirects.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreatePostRedirects < ActiveRecord::Migration
def self.up
create_table :post_redirects do |t|
diff --git a/db/migrate/015_add_email_token_to_post_redirects.rb b/db/migrate/015_add_email_token_to_post_redirects.rb
index 47d070533..991df8cfd 100644
--- a/db/migrate/015_add_email_token_to_post_redirects.rb
+++ b/db/migrate/015_add_email_token_to_post_redirects.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddEmailTokenToPostRedirects < ActiveRecord::Migration
def self.up
add_column :post_redirects, :email_token, :text
diff --git a/db/migrate/016_add_reasons_to_post_redirects.rb b/db/migrate/016_add_reasons_to_post_redirects.rb
index 622e1173b..e0d4af5e3 100644
--- a/db/migrate/016_add_reasons_to_post_redirects.rb
+++ b/db/migrate/016_add_reasons_to_post_redirects.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddReasonsToPostRedirects < ActiveRecord::Migration
def self.up
add_column :post_redirects, :reason_params_yaml, :text
diff --git a/db/migrate/017_add_email_confirmed_to_users.rb b/db/migrate/017_add_email_confirmed_to_users.rb
index b552e853e..56b3dacb4 100644
--- a/db/migrate/017_add_email_confirmed_to_users.rb
+++ b/db/migrate/017_add_email_confirmed_to_users.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddEmailConfirmedToUsers < ActiveRecord::Migration
def self.up
add_column :users, :email_confirmed, :boolean, :default => false
diff --git a/db/migrate/018_add_response_type_to_incoming_message.rb b/db/migrate/018_add_response_type_to_incoming_message.rb
index c841b599a..8ef2c7dd4 100644
--- a/db/migrate/018_add_response_type_to_incoming_message.rb
+++ b/db/migrate/018_add_response_type_to_incoming_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddResponseTypeToIncomingMessage < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :user_classified, :boolean, :default => false
diff --git a/db/migrate/021_remove_contains_information_default.rb b/db/migrate/021_remove_contains_information_default.rb
index 9969cbc2c..a50e06299 100644
--- a/db/migrate/021_remove_contains_information_default.rb
+++ b/db/migrate/021_remove_contains_information_default.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveContainsInformationDefault < ActiveRecord::Migration
def self.up
change_column :incoming_messages, :contains_information, :boolean, :default => nil
diff --git a/db/migrate/022_create_info_request_events.rb b/db/migrate/022_create_info_request_events.rb
index 858444298..3efc69ccf 100644
--- a/db/migrate/022_create_info_request_events.rb
+++ b/db/migrate/022_create_info_request_events.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateInfoRequestEvents < ActiveRecord::Migration
def self.up
create_table :info_request_events do |t|
diff --git a/db/migrate/023_outgoing_message_last_sent_at.rb b/db/migrate/023_outgoing_message_last_sent_at.rb
index 24cb55257..2a2fd4eac 100644
--- a/db/migrate/023_outgoing_message_last_sent_at.rb
+++ b/db/migrate/023_outgoing_message_last_sent_at.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class OutgoingMessageLastSentAt < ActiveRecord::Migration
def self.up
rename_column(:outgoing_messages, :sent_at, :last_sent_at)
diff --git a/db/migrate/024_add_is_bounce_to_incoming_messages.rb b/db/migrate/024_add_is_bounce_to_incoming_messages.rb
index f81ff4401..54ac6d334 100644
--- a/db/migrate/024_add_is_bounce_to_incoming_messages.rb
+++ b/db/migrate/024_add_is_bounce_to_incoming_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIsBounceToIncomingMessages < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :is_bounce, :boolean, :default => false
diff --git a/db/migrate/025_add_followup_to_outgoing_message.rb b/db/migrate/025_add_followup_to_outgoing_message.rb
index d3bd7444c..2e50ced27 100644
--- a/db/migrate/025_add_followup_to_outgoing_message.rb
+++ b/db/migrate/025_add_followup_to_outgoing_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddFollowupToOutgoingMessage < ActiveRecord::Migration
def self.up
add_column :outgoing_messages, :incoming_message_followup_id, :integer
diff --git a/db/migrate/026_add_many_null_constraints.rb b/db/migrate/026_add_many_null_constraints.rb
index 7abd2e8f2..8ff01fe1f 100644
--- a/db/migrate/026_add_many_null_constraints.rb
+++ b/db/migrate/026_add_many_null_constraints.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddManyNullConstraints < ActiveRecord::Migration
def self.up
change_column :users, :email, :string, :null => false
diff --git a/db/migrate/027_change_classification_system.rb b/db/migrate/027_change_classification_system.rb
index d9e6ad844..d1f68500a 100644
--- a/db/migrate/027_change_classification_system.rb
+++ b/db/migrate/027_change_classification_system.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ChangeClassificationSystem < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :contains_information
diff --git a/db/migrate/028_give_incoming_messages_events.rb b/db/migrate/028_give_incoming_messages_events.rb
index 46acd831e..f2f5e7706 100644
--- a/db/migrate/028_give_incoming_messages_events.rb
+++ b/db/migrate/028_give_incoming_messages_events.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
# TODO: If this one fails with errors about described_state on save, then you need
# to temporarily modify the model for InfoRequestEvents to remove this part:
# validates_inclusion_of :described_state, :in => [
diff --git a/db/migrate/029_add_describe_status_history.rb b/db/migrate/029_add_describe_status_history.rb
index 0c6095d69..8b448284c 100644
--- a/db/migrate/029_add_describe_status_history.rb
+++ b/db/migrate/029_add_describe_status_history.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddDescribeStatusHistory < ActiveRecord::Migration
def self.up
add_column :info_request_events, :described_state, :string
diff --git a/db/migrate/030_add_some_indices.rb b/db/migrate/030_add_some_indices.rb
index 066fc29cb..0c58617e9 100644
--- a/db/migrate/030_add_some_indices.rb
+++ b/db/migrate/030_add_some_indices.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddSomeIndices < ActiveRecord::Migration
def self.up
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
diff --git a/db/migrate/031_add_indices_for_session_deletion.rb b/db/migrate/031_add_indices_for_session_deletion.rb
index 9a6f6b326..2a263fece 100644
--- a/db/migrate/031_add_indices_for_session_deletion.rb
+++ b/db/migrate/031_add_indices_for_session_deletion.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIndicesForSessionDeletion < ActiveRecord::Migration
def self.up
add_index :post_redirects, :updated_at
diff --git a/db/migrate/032_addforeignkeys.rb b/db/migrate/032_addforeignkeys.rb
index f8d8f8b0d..5cff3b9d0 100644
--- a/db/migrate/032_addforeignkeys.rb
+++ b/db/migrate/032_addforeignkeys.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class Addforeignkeys < ActiveRecord::Migration
def self.up
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
diff --git a/db/migrate/033_add_prominence.rb b/db/migrate/033_add_prominence.rb
index 15d548f37..e192044b2 100644
--- a/db/migrate/033_add_prominence.rb
+++ b/db/migrate/033_add_prominence.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddProminence < ActiveRecord::Migration
def self.up
add_column :info_requests, :prominence, :string, :null => false, :default => 'normal'
diff --git a/db/migrate/034_run_solr_indexing.rb b/db/migrate/034_run_solr_indexing.rb
index 3cdfdbde9..c48fd4702 100644
--- a/db/migrate/034_run_solr_indexing.rb
+++ b/db/migrate/034_run_solr_indexing.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RunSolrIndexing < ActiveRecord::Migration
def self.up
# Not using SOLR yet after all
diff --git a/db/migrate/035_track_overdue_alerts.rb b/db/migrate/035_track_overdue_alerts.rb
index 7ef164271..48dc23e7d 100644
--- a/db/migrate/035_track_overdue_alerts.rb
+++ b/db/migrate/035_track_overdue_alerts.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class TrackOverdueAlerts < ActiveRecord::Migration
def self.up
create_table :user_info_request_sent_alerts do |t|
diff --git a/db/migrate/036_add_public_body_tags.rb b/db/migrate/036_add_public_body_tags.rb
index f7fefdf48..523b7a05b 100644
--- a/db/migrate/036_add_public_body_tags.rb
+++ b/db/migrate/036_add_public_body_tags.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddPublicBodyTags < ActiveRecord::Migration
def self.up
create_table :public_body_tags do |t|
diff --git a/db/migrate/037_add_url_name.rb b/db/migrate/037_add_url_name.rb
index 84aad9cc8..b1141e176 100644
--- a/db/migrate/037_add_url_name.rb
+++ b/db/migrate/037_add_url_name.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddUrlName < ActiveRecord::Migration
def self.up
add_column :public_bodies, :url_name, :text
diff --git a/db/migrate/038_add_more_url_names.rb b/db/migrate/038_add_more_url_names.rb
index 9798f4b4b..568610417 100644
--- a/db/migrate/038_add_more_url_names.rb
+++ b/db/migrate/038_add_more_url_names.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddMoreUrlNames < ActiveRecord::Migration
def self.up
add_column :users, :url_name, :text
diff --git a/db/migrate/039_request_url_names.rb b/db/migrate/039_request_url_names.rb
index 5227b887a..999e7c290 100644
--- a/db/migrate/039_request_url_names.rb
+++ b/db/migrate/039_request_url_names.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RequestUrlNames < ActiveRecord::Migration
def self.up
add_column :info_requests, :url_title, :text
diff --git a/db/migrate/040_email_is_unique.rb b/db/migrate/040_email_is_unique.rb
index c61362de2..aba1ef28d 100644
--- a/db/migrate/040_email_is_unique.rb
+++ b/db/migrate/040_email_is_unique.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class EmailIsUnique < ActiveRecord::Migration
def self.up
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
diff --git a/db/migrate/041_index_requests_with_solr.rb b/db/migrate/041_index_requests_with_solr.rb
index f18b947a6..8b95e6604 100644
--- a/db/migrate/041_index_requests_with_solr.rb
+++ b/db/migrate/041_index_requests_with_solr.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class IndexRequestsWithSolr < ActiveRecord::Migration
def self.up
add_column :info_requests, :solr_up_to_date, :boolean, :default => false, :null => false
diff --git a/db/migrate/042_unique_user_urls.rb b/db/migrate/042_unique_user_urls.rb
index 45e4fd11d..39a7a4849 100644
--- a/db/migrate/042_unique_user_urls.rb
+++ b/db/migrate/042_unique_user_urls.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class UniqueUserUrls < ActiveRecord::Migration
def self.up
# do last registered ones first, so the last ones get rubbish URLs
diff --git a/db/migrate/043_remove_complaint_email.rb b/db/migrate/043_remove_complaint_email.rb
index cc03f6507..7c57ce2fc 100644
--- a/db/migrate/043_remove_complaint_email.rb
+++ b/db/migrate/043_remove_complaint_email.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveComplaintEmail < ActiveRecord::Migration
def self.up
remove_column :public_body_versions, :complaint_email
diff --git a/db/migrate/044_remove_is_bounce.rb b/db/migrate/044_remove_is_bounce.rb
index 8e2307060..6656a237c 100644
--- a/db/migrate/044_remove_is_bounce.rb
+++ b/db/migrate/044_remove_is_bounce.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveIsBounce < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :is_bounce
diff --git a/db/migrate/045_add_circumstance_to_post_redirect.rb b/db/migrate/045_add_circumstance_to_post_redirect.rb
index e6e7ca513..bddd5b24a 100644
--- a/db/migrate/045_add_circumstance_to_post_redirect.rb
+++ b/db/migrate/045_add_circumstance_to_post_redirect.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCircumstanceToPostRedirect < ActiveRecord::Migration
def self.up
add_column :post_redirects, :circumstance, :text, :default => "normal"
diff --git a/db/migrate/046_add_last_event_id_to_alert_table.rb b/db/migrate/046_add_last_event_id_to_alert_table.rb
index 361bd0af4..aab547a63 100644
--- a/db/migrate/046_add_last_event_id_to_alert_table.rb
+++ b/db/migrate/046_add_last_event_id_to_alert_table.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddLastEventIdToAlertTable < ActiveRecord::Migration
def self.up
add_column :user_info_request_sent_alerts, :info_request_event_id, :integer, :default => nil
diff --git a/db/migrate/047_add_calculated_state.rb b/db/migrate/047_add_calculated_state.rb
index 5e5b93512..ad77b366d 100644
--- a/db/migrate/047_add_calculated_state.rb
+++ b/db/migrate/047_add_calculated_state.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCalculatedState < ActiveRecord::Migration
def self.up
add_column :info_request_events, :calculated_state, :string, :default => nil
diff --git a/db/migrate/048_add_calculated_state_at.rb b/db/migrate/048_add_calculated_state_at.rb
index 63f7e996d..8a4ffa4ef 100644
--- a/db/migrate/048_add_calculated_state_at.rb
+++ b/db/migrate/048_add_calculated_state_at.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCalculatedStateAt < ActiveRecord::Migration
def self.up
# This is for use in RSS feeds
diff --git a/db/migrate/049_track_things.rb b/db/migrate/049_track_things.rb
index aad50a69e..8d94602b9 100644
--- a/db/migrate/049_track_things.rb
+++ b/db/migrate/049_track_things.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class TrackThings < ActiveRecord::Migration
def self.up
create_table :track_things do |t|
diff --git a/db/migrate/050_improve_track_things.rb b/db/migrate/050_improve_track_things.rb
index 430dd5946..5d621ad36 100644
--- a/db/migrate/050_improve_track_things.rb
+++ b/db/migrate/050_improve_track_things.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ImproveTrackThings < ActiveRecord::Migration
def self.up
# SQLite at least needs a default for this
diff --git a/db/migrate/051_add_track_things_unique_indices.rb b/db/migrate/051_add_track_things_unique_indices.rb
index 27d901734..3ff90d79e 100644
--- a/db/migrate/051_add_track_things_unique_indices.rb
+++ b/db/migrate/051_add_track_things_unique_indices.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddTrackThingsUniqueIndices < ActiveRecord::Migration
def self.up
add_index :track_things, [:tracking_user_id, :track_query], :unique => true
diff --git a/db/migrate/052_include_event_foreign_references.rb b/db/migrate/052_include_event_foreign_references.rb
index 5dfcce4a7..c48a65a6f 100644
--- a/db/migrate/052_include_event_foreign_references.rb
+++ b/db/migrate/052_include_event_foreign_references.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class IncludeEventForeignReferences < ActiveRecord::Migration
def self.up
add_column :info_request_events, :incoming_message_id, :integer
diff --git a/db/migrate/053_acts_as_xapian_migration.rb b/db/migrate/053_acts_as_xapian_migration.rb
index cc2680533..291e0bb4e 100644
--- a/db/migrate/053_acts_as_xapian_migration.rb
+++ b/db/migrate/053_acts_as_xapian_migration.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ActsAsXapianMigration < ActiveRecord::Migration
def self.up
create_table :acts_as_xapian_jobs do |t|
diff --git a/db/migrate/054_allow_longer_comments.rb b/db/migrate/054_allow_longer_comments.rb
index 35f2bee9c..fb19a1045 100644
--- a/db/migrate/054_allow_longer_comments.rb
+++ b/db/migrate/054_allow_longer_comments.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AllowLongerComments < ActiveRecord::Migration
def self.up
change_column :public_body_versions, :last_edit_comment, :text
diff --git a/db/migrate/055_stop_new_responses.rb b/db/migrate/055_stop_new_responses.rb
index 1ebe2142a..dce034b95 100644
--- a/db/migrate/055_stop_new_responses.rb
+++ b/db/migrate/055_stop_new_responses.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class StopNewResponses < ActiveRecord::Migration
def self.up
add_column :info_requests, :stop_new_responses, :boolean, :default => false, :null => false
diff --git a/db/migrate/056_add_attachment_text.rb b/db/migrate/056_add_attachment_text.rb
index adcb97d5f..f9c0801cf 100644
--- a/db/migrate/056_add_attachment_text.rb
+++ b/db/migrate/056_add_attachment_text.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddAttachmentText < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :cached_attachment_text, :text
diff --git a/db/migrate/057_add_law_used.rb b/db/migrate/057_add_law_used.rb
index ec4efd0bc..1ed73bee0 100644
--- a/db/migrate/057_add_law_used.rb
+++ b/db/migrate/057_add_law_used.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddLawUsed < ActiveRecord::Migration
def self.up
add_column :info_requests, :law_used, :string, :null => false, :default => 'foi'
diff --git a/db/migrate/058_remove_sessions.rb b/db/migrate/058_remove_sessions.rb
index 316fcfdda..d94865eb7 100644
--- a/db/migrate/058_remove_sessions.rb
+++ b/db/migrate/058_remove_sessions.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveSessions < ActiveRecord::Migration
def self.up
drop_table :sessions
diff --git a/db/migrate/059_add_url_notes.rb b/db/migrate/059_add_url_notes.rb
index ae6a998aa..c0e708e12 100644
--- a/db/migrate/059_add_url_notes.rb
+++ b/db/migrate/059_add_url_notes.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddUrlNotes < ActiveRecord::Migration
def self.up
add_column :public_bodies, :home_page, :text, :null => false, :default => ""
diff --git a/db/migrate/060_add_cached_main_text.rb b/db/migrate/060_add_cached_main_text.rb
index c372b471c..2317de1ad 100644
--- a/db/migrate/060_add_cached_main_text.rb
+++ b/db/migrate/060_add_cached_main_text.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCachedMainText < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :cached_main_body_text, :text
diff --git a/db/migrate/061_include_responses_in_tracks.rb b/db/migrate/061_include_responses_in_tracks.rb
index c7a3b26cf..8ebee5a1f 100644
--- a/db/migrate/061_include_responses_in_tracks.rb
+++ b/db/migrate/061_include_responses_in_tracks.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class IncludeResponsesInTracks < ActiveRecord::Migration
def self.up
TrackThing.update_all "track_query = replace(track_query, 'variety:sent ', '') where track_type in ('public_body_updates', 'user_updates')"
diff --git a/db/migrate/062_add_comments.rb b/db/migrate/062_add_comments.rb
index d523dd808..da42786d8 100644
--- a/db/migrate/062_add_comments.rb
+++ b/db/migrate/062_add_comments.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddComments < ActiveRecord::Migration
def self.up
create_table :comments do |t|
diff --git a/db/migrate/063_add_admin_users.rb b/db/migrate/063_add_admin_users.rb
index 9daa64a35..ca6acc679 100644
--- a/db/migrate/063_add_admin_users.rb
+++ b/db/migrate/063_add_admin_users.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddAdminUsers < ActiveRecord::Migration
def self.up
add_column :users, :admin_level, :string, :null => false, :default => 'none'
diff --git a/db/migrate/064_indices_for_annotations.rb b/db/migrate/064_indices_for_annotations.rb
index 5b89271fe..88e267c64 100644
--- a/db/migrate/064_indices_for_annotations.rb
+++ b/db/migrate/064_indices_for_annotations.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class IndicesForAnnotations < ActiveRecord::Migration
def self.up
add_index :info_request_events, :created_at
diff --git a/db/migrate/065_add_comments_to_user_track.rb b/db/migrate/065_add_comments_to_user_track.rb
index 50d1f9d5d..9b2ef8747 100644
--- a/db/migrate/065_add_comments_to_user_track.rb
+++ b/db/migrate/065_add_comments_to_user_track.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCommentsToUserTrack < ActiveRecord::Migration
def self.up
TrackThing.update_all "track_query = replace(track_query, 'variety:sent ', '') where track_type in ('public_body_updates', 'user_updates')"
diff --git a/db/migrate/066_add_first_letter.rb b/db/migrate/066_add_first_letter.rb
index 7878098e0..e29dfef37 100644
--- a/db/migrate/066_add_first_letter.rb
+++ b/db/migrate/066_add_first_letter.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddFirstLetter < ActiveRecord::Migration
def self.up
add_column :public_bodies, :first_letter, :string
diff --git a/db/migrate/067_factor_out_raw_email.rb b/db/migrate/067_factor_out_raw_email.rb
index be4153938..869430e05 100644
--- a/db/migrate/067_factor_out_raw_email.rb
+++ b/db/migrate/067_factor_out_raw_email.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class FactorOutRawEmail < ActiveRecord::Migration
def self.up
create_table :raw_emails do |t|
diff --git a/db/migrate/068_add_censor_table.rb b/db/migrate/068_add_censor_table.rb
index 92a17d2bc..8bfc4fbd6 100644
--- a/db/migrate/068_add_censor_table.rb
+++ b/db/migrate/068_add_censor_table.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCensorTable < ActiveRecord::Migration
def self.up
create_table :censor_rules do |t|
diff --git a/db/migrate/069_add_what_doing.rb b/db/migrate/069_add_what_doing.rb
index be8039fec..2ede40603 100644
--- a/db/migrate/069_add_what_doing.rb
+++ b/db/migrate/069_add_what_doing.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddWhatDoing < ActiveRecord::Migration
def self.up
add_column :outgoing_messages, :what_doing, :string
diff --git a/db/migrate/070_sent_are_waiting_response.rb b/db/migrate/070_sent_are_waiting_response.rb
index af66705b5..a2c2278ee 100644
--- a/db/migrate/070_sent_are_waiting_response.rb
+++ b/db/migrate/070_sent_are_waiting_response.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class SentAreWaitingResponse < ActiveRecord::Migration
def self.up
InfoRequestEvent.update_all "described_state = 'waiting_response', calculated_state = 'waiting_response', last_described_at = created_at where event_type = 'sent'"
diff --git a/db/migrate/071_add_exim_log.rb b/db/migrate/071_add_exim_log.rb
index d3780affa..94924569c 100644
--- a/db/migrate/071_add_exim_log.rb
+++ b/db/migrate/071_add_exim_log.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddEximLog < ActiveRecord::Migration
def self.up
create_table :exim_logs do |t|
diff --git a/db/migrate/072_add_publication_scheme.rb b/db/migrate/072_add_publication_scheme.rb
index 5040d1709..16507411d 100644
--- a/db/migrate/072_add_publication_scheme.rb
+++ b/db/migrate/072_add_publication_scheme.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddPublicationScheme < ActiveRecord::Migration
def self.up
add_column :public_bodies, :publication_scheme, :text, :null => false, :default => ""
diff --git a/db/migrate/073_add_ban_user.rb b/db/migrate/073_add_ban_user.rb
index 15a1ea121..045c65fcd 100644
--- a/db/migrate/073_add_ban_user.rb
+++ b/db/migrate/073_add_ban_user.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddBanUser < ActiveRecord::Migration
def self.up
add_column :users, :ban_text, :text, :null => false, :default => ""
diff --git a/db/migrate/074_create_holidays.rb b/db/migrate/074_create_holidays.rb
index f2197e89e..406b9c44e 100644
--- a/db/migrate/074_create_holidays.rb
+++ b/db/migrate/074_create_holidays.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateHolidays < ActiveRecord::Migration
def self.up
create_table :holidays do |t|
diff --git a/db/migrate/075_add_charity_number.rb b/db/migrate/075_add_charity_number.rb
index 41743a922..af0208b44 100644
--- a/db/migrate/075_add_charity_number.rb
+++ b/db/migrate/075_add_charity_number.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCharityNumber < ActiveRecord::Migration
def self.up
add_column :public_bodies, :charity_number, :text, :null => false, :default => ""
diff --git a/db/migrate/076_add_indices.rb b/db/migrate/076_add_indices.rb
index fd102caba..50fc1e3ea 100644
--- a/db/migrate/076_add_indices.rb
+++ b/db/migrate/076_add_indices.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIndices < ActiveRecord::Migration
def self.up
add_index :track_things_sent_emails, :track_thing_id
diff --git a/db/migrate/077_add_exim_log_index.rb b/db/migrate/077_add_exim_log_index.rb
index c2d04d7ca..c7526c252 100644
--- a/db/migrate/077_add_exim_log_index.rb
+++ b/db/migrate/077_add_exim_log_index.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddEximLogIndex < ActiveRecord::Migration
def self.up
add_index :exim_logs, :exim_log_done_id
diff --git a/db/migrate/078_expand_stop_new_responses.rb b/db/migrate/078_expand_stop_new_responses.rb
index ae0d4db91..24b384ea1 100644
--- a/db/migrate/078_expand_stop_new_responses.rb
+++ b/db/migrate/078_expand_stop_new_responses.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ExpandStopNewResponses < ActiveRecord::Migration
def self.up
add_column :info_requests, :allow_new_responses_from, :string
diff --git a/db/migrate/079_add_profile_photo.rb b/db/migrate/079_add_profile_photo.rb
index a6c031d89..9777b1948 100644
--- a/db/migrate/079_add_profile_photo.rb
+++ b/db/migrate/079_add_profile_photo.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddProfilePhoto < ActiveRecord::Migration
def self.up
create_table :profile_photos do |t|
diff --git a/db/migrate/080_cache_only_clipped_attachment_text.rb b/db/migrate/080_cache_only_clipped_attachment_text.rb
index 0cd835e49..71b801e53 100644
--- a/db/migrate/080_cache_only_clipped_attachment_text.rb
+++ b/db/migrate/080_cache_only_clipped_attachment_text.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CacheOnlyClippedAttachmentText < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :cached_attachment_text
diff --git a/db/migrate/081_add_event_prominence.rb b/db/migrate/081_add_event_prominence.rb
index 184e1a267..2b0d3a8ea 100644
--- a/db/migrate/081_add_event_prominence.rb
+++ b/db/migrate/081_add_event_prominence.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddEventProminence < ActiveRecord::Migration
def self.up
add_column :info_request_events, :prominence, :string, :null => false, :default => 'normal'
diff --git a/db/migrate/082_change_raw_email_to_binary.rb b/db/migrate/082_change_raw_email_to_binary.rb
index ec16d54a0..5123f2825 100644
--- a/db/migrate/082_change_raw_email_to_binary.rb
+++ b/db/migrate/082_change_raw_email_to_binary.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ChangeRawEmailToBinary < ActiveRecord::Migration
def self.up
change_column :raw_emails, :data, :text, :null => true # allow null
diff --git a/db/migrate/083_add_indices_track_sent.rb b/db/migrate/083_add_indices_track_sent.rb
index 2b0908af8..f292b02ab 100644
--- a/db/migrate/083_add_indices_track_sent.rb
+++ b/db/migrate/083_add_indices_track_sent.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIndicesTrackSent < ActiveRecord::Migration
def self.up
add_index :track_things_sent_emails, :created_at
diff --git a/db/migrate/084_alter_profile_photo.rb b/db/migrate/084_alter_profile_photo.rb
index d2717b047..14c84ac99 100644
--- a/db/migrate/084_alter_profile_photo.rb
+++ b/db/migrate/084_alter_profile_photo.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AlterProfilePhoto < ActiveRecord::Migration
def self.up
remove_column :users, :profile_photo_id
diff --git a/db/migrate/085_draft_profile_photo.rb b/db/migrate/085_draft_profile_photo.rb
index c0b507485..98c08a35e 100644
--- a/db/migrate/085_draft_profile_photo.rb
+++ b/db/migrate/085_draft_profile_photo.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class DraftProfilePhoto < ActiveRecord::Migration
def self.up
add_column :profile_photos, :draft, :boolean, :default => false, :null => false
diff --git a/db/migrate/086_allow_null_profile_photo_user.rb b/db/migrate/086_allow_null_profile_photo_user.rb
index f4e107848..a070df560 100644
--- a/db/migrate/086_allow_null_profile_photo_user.rb
+++ b/db/migrate/086_allow_null_profile_photo_user.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AllowNullProfilePhotoUser < ActiveRecord::Migration
def self.up
change_column :profile_photos, :user_id, :integer, :null => true
diff --git a/db/migrate/087_add_about_me.rb b/db/migrate/087_add_about_me.rb
index 9916454f3..907cd472b 100644
--- a/db/migrate/087_add_about_me.rb
+++ b/db/migrate/087_add_about_me.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddAboutMe < ActiveRecord::Migration
def self.up
add_column :users, :about_me, :text, :null => false, :default => ""
diff --git a/db/migrate/088_public_body_machine_tags.rb b/db/migrate/088_public_body_machine_tags.rb
index 6a0815568..33f035a8e 100644
--- a/db/migrate/088_public_body_machine_tags.rb
+++ b/db/migrate/088_public_body_machine_tags.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class PublicBodyMachineTags < ActiveRecord::Migration
def self.up
add_column :public_body_tags, :value, :text
diff --git a/db/migrate/089_remove_charity_number.rb b/db/migrate/089_remove_charity_number.rb
index 9b7d0935b..0d67bef04 100644
--- a/db/migrate/089_remove_charity_number.rb
+++ b/db/migrate/089_remove_charity_number.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveCharityNumber < ActiveRecord::Migration
def self.up
remove_column :public_bodies, :charity_number
diff --git a/db/migrate/090_remove_tag_uniqueness.rb b/db/migrate/090_remove_tag_uniqueness.rb
index d1affade3..37b9a39b4 100644
--- a/db/migrate/090_remove_tag_uniqueness.rb
+++ b/db/migrate/090_remove_tag_uniqueness.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveTagUniqueness < ActiveRecord::Migration
def self.up
# MySQL cannot index text blobs like this
diff --git a/db/migrate/091_add_censor_rules_indices.rb b/db/migrate/091_add_censor_rules_indices.rb
index 59f5db6cc..88869be1c 100644
--- a/db/migrate/091_add_censor_rules_indices.rb
+++ b/db/migrate/091_add_censor_rules_indices.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCensorRulesIndices < ActiveRecord::Migration
def self.up
add_index :censor_rules, :info_request_id
diff --git a/db/migrate/092_cache_only_marked_body_text.rb b/db/migrate/092_cache_only_marked_body_text.rb
index e05e23e74..5ce26f1c1 100644
--- a/db/migrate/092_cache_only_marked_body_text.rb
+++ b/db/migrate/092_cache_only_marked_body_text.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CacheOnlyMarkedBodyText < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :cached_main_body_text
diff --git a/db/migrate/093_move_to_has_tag_string.rb b/db/migrate/093_move_to_has_tag_string.rb
index 58f36c224..f819045a9 100644
--- a/db/migrate/093_move_to_has_tag_string.rb
+++ b/db/migrate/093_move_to_has_tag_string.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class MoveToHasTagString < ActiveRecord::Migration
def self.up
rename_table :public_body_tags, :has_tag_string_tags
diff --git a/db/migrate/094_remove_old_tags_foreign_key.rb b/db/migrate/094_remove_old_tags_foreign_key.rb
index 5a6a00acc..1e9abaff6 100644
--- a/db/migrate/094_remove_old_tags_foreign_key.rb
+++ b/db/migrate/094_remove_old_tags_foreign_key.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveOldTagsForeignKey < ActiveRecord::Migration
def self.up
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
diff --git a/db/migrate/095_add_post_redirect_user_index.rb b/db/migrate/095_add_post_redirect_user_index.rb
index 05d5f7a35..d6e9162d1 100644
--- a/db/migrate/095_add_post_redirect_user_index.rb
+++ b/db/migrate/095_add_post_redirect_user_index.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddPostRedirectUserIndex < ActiveRecord::Migration
# This index is for admin interface
diff --git a/db/migrate/096_create_translation_tables.rb b/db/migrate/096_create_translation_tables.rb
index 4b47c11f7..fe076cbfd 100644
--- a/db/migrate/096_create_translation_tables.rb
+++ b/db/migrate/096_create_translation_tables.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateTranslationTables < ActiveRecord::Migration
def self.up
fields = {:name => :text,
diff --git a/db/migrate/097_add_comment_locale.rb b/db/migrate/097_add_comment_locale.rb
index 92ac7c4a5..8a47351a6 100644
--- a/db/migrate/097_add_comment_locale.rb
+++ b/db/migrate/097_add_comment_locale.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCommentLocale < ActiveRecord::Migration
def self.up
add_column :comments, :locale, :text, :null => false, :default => ""
diff --git a/db/migrate/098_fix_public_body_translations.rb b/db/migrate/098_fix_public_body_translations.rb
index 25f36336f..53d62ab7e 100644
--- a/db/migrate/098_fix_public_body_translations.rb
+++ b/db/migrate/098_fix_public_body_translations.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
# The PublicBody model class had a bug that meant the
# translations for first_letter and publication_scheme
# were not being correctly populated.
diff --git a/db/migrate/099_move_raw_email_to_filesystem.rb b/db/migrate/099_move_raw_email_to_filesystem.rb
index ea77580e1..bd9e8efb4 100644
--- a/db/migrate/099_move_raw_email_to_filesystem.rb
+++ b/db/migrate/099_move_raw_email_to_filesystem.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class MoveRawEmailToFilesystem < ActiveRecord::Migration
def self.up
batch_size = 10
diff --git a/db/migrate/100_remove_redundant_raw_email_columns.rb b/db/migrate/100_remove_redundant_raw_email_columns.rb
index edf6006d7..d974e78df 100644
--- a/db/migrate/100_remove_redundant_raw_email_columns.rb
+++ b/db/migrate/100_remove_redundant_raw_email_columns.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveRedundantRawEmailColumns < ActiveRecord::Migration
def self.up
remove_column :raw_emails, :data_text
diff --git a/db/migrate/101_add_hash_to_info_request.rb b/db/migrate/101_add_hash_to_info_request.rb
index e38384cd6..564067438 100644
--- a/db/migrate/101_add_hash_to_info_request.rb
+++ b/db/migrate/101_add_hash_to_info_request.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
require 'digest/sha1'
class AddHashToInfoRequest < ActiveRecord::Migration
diff --git a/db/migrate/102_add_locale_to_users.rb b/db/migrate/102_add_locale_to_users.rb
index a299a8561..eff9f60da 100644
--- a/db/migrate/102_add_locale_to_users.rb
+++ b/db/migrate/102_add_locale_to_users.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddLocaleToUsers < ActiveRecord::Migration
def self.up
add_column :users, :locale, :string
diff --git a/db/migrate/103_add_user_bounce_columns.rb b/db/migrate/103_add_user_bounce_columns.rb
index a16ecde75..81daf3ed5 100644
--- a/db/migrate/103_add_user_bounce_columns.rb
+++ b/db/migrate/103_add_user_bounce_columns.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
require 'digest/sha1'
class AddUserBounceColumns < ActiveRecord::Migration
diff --git a/db/migrate/104_create_foi_attachments.rb b/db/migrate/104_create_foi_attachments.rb
index c53cd4f64..bcef00985 100644
--- a/db/migrate/104_create_foi_attachments.rb
+++ b/db/migrate/104_create_foi_attachments.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateFoiAttachments < ActiveRecord::Migration
def self.up
diff --git a/db/migrate/105_extend_incoming_message.rb b/db/migrate/105_extend_incoming_message.rb
index 9db8649a0..bb244e777 100644
--- a/db/migrate/105_extend_incoming_message.rb
+++ b/db/migrate/105_extend_incoming_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ExtendIncomingMessage < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :sent_at, :time
diff --git a/db/migrate/106_add_hex_digest_to_foi_attachment.rb b/db/migrate/106_add_hex_digest_to_foi_attachment.rb
index d9520a934..20a9d5fb2 100644
--- a/db/migrate/106_add_hex_digest_to_foi_attachment.rb
+++ b/db/migrate/106_add_hex_digest_to_foi_attachment.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddHexDigestToFoiAttachment < ActiveRecord::Migration
def self.up
add_column :foi_attachments, :hexdigest, :string, :limit => 32
diff --git a/db/migrate/107_add_date_parsed_field_to_incoming_message.rb b/db/migrate/107_add_date_parsed_field_to_incoming_message.rb
index fbc017134..e13f7b776 100644
--- a/db/migrate/107_add_date_parsed_field_to_incoming_message.rb
+++ b/db/migrate/107_add_date_parsed_field_to_incoming_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddDateParsedFieldToIncomingMessage < ActiveRecord::Migration
def self.up
add_column :incoming_messages, :last_parsed, :datetime
diff --git a/db/migrate/108_change_safe_mail_from_to_mail_from.rb b/db/migrate/108_change_safe_mail_from_to_mail_from.rb
index 57997f674..7bc5e47b6 100644
--- a/db/migrate/108_change_safe_mail_from_to_mail_from.rb
+++ b/db/migrate/108_change_safe_mail_from_to_mail_from.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ChangeSafeMailFromToMailFrom < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :safe_mail_from
diff --git a/db/migrate/109_change_sent_at_to_datetime.rb b/db/migrate/109_change_sent_at_to_datetime.rb
index 5fc9b29ae..4ce1831c0 100644
--- a/db/migrate/109_change_sent_at_to_datetime.rb
+++ b/db/migrate/109_change_sent_at_to_datetime.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class ChangeSentAtToDatetime < ActiveRecord::Migration
def self.up
remove_column :incoming_messages, :sent_at
diff --git a/db/migrate/110_add_user_no_limit.rb b/db/migrate/110_add_user_no_limit.rb
index d78a05f75..4d8274fbf 100644
--- a/db/migrate/110_add_user_no_limit.rb
+++ b/db/migrate/110_add_user_no_limit.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
require 'digest/sha1'
class AddUserNoLimit < ActiveRecord::Migration
diff --git a/db/migrate/111_create_purge_requests.rb b/db/migrate/111_create_purge_requests.rb
index 0b4fd1d1d..c5ddaf4a2 100644
--- a/db/migrate/111_create_purge_requests.rb
+++ b/db/migrate/111_create_purge_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreatePurgeRequests < ActiveRecord::Migration
def self.up
create_table :purge_requests do |t|
diff --git a/db/migrate/112_add_api_key_to_public_bodies.rb b/db/migrate/112_add_api_key_to_public_bodies.rb
index 43dccb198..a7b3903f1 100644
--- a/db/migrate/112_add_api_key_to_public_bodies.rb
+++ b/db/migrate/112_add_api_key_to_public_bodies.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
require "securerandom"
class AddApiKeyToPublicBodies < ActiveRecord::Migration
diff --git a/db/migrate/113_add_external_fields_to_info_requests.rb b/db/migrate/113_add_external_fields_to_info_requests.rb
index 1ad7634ff..c350f432b 100644
--- a/db/migrate/113_add_external_fields_to_info_requests.rb
+++ b/db/migrate/113_add_external_fields_to_info_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddExternalFieldsToInfoRequests < ActiveRecord::Migration
def self.up
change_column_null :info_requests, :user_id, true
diff --git a/db/migrate/114_add_attention_requested_flag_to_info_requests.rb b/db/migrate/114_add_attention_requested_flag_to_info_requests.rb
index 48c98e5a9..61a3b5e5e 100644
--- a/db/migrate/114_add_attention_requested_flag_to_info_requests.rb
+++ b/db/migrate/114_add_attention_requested_flag_to_info_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
require 'digest/sha1'
class AddAttentionRequestedFlagToInfoRequests < ActiveRecord::Migration
diff --git a/db/migrate/115_add_receive_email_alerts_to_user.rb b/db/migrate/115_add_receive_email_alerts_to_user.rb
index 7e06dd275..0f3747294 100644
--- a/db/migrate/115_add_receive_email_alerts_to_user.rb
+++ b/db/migrate/115_add_receive_email_alerts_to_user.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddReceiveEmailAlertsToUser < ActiveRecord::Migration
def self.up
add_column :users, :receive_email_alerts, :boolean, :default => true, :null => false
diff --git a/db/migrate/116_add_censor_rule_regexp.rb b/db/migrate/116_add_censor_rule_regexp.rb
index d9c4664cd..235a3a0cc 100644
--- a/db/migrate/116_add_censor_rule_regexp.rb
+++ b/db/migrate/116_add_censor_rule_regexp.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCensorRuleRegexp < ActiveRecord::Migration
def self.up
add_column :censor_rules, :regexp, :boolean
diff --git a/db/migrate/117_create_sessions.rb b/db/migrate/117_create_sessions.rb
index 4ccc353b1..7d95f8935 100644
--- a/db/migrate/117_create_sessions.rb
+++ b/db/migrate/117_create_sessions.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateSessions < ActiveRecord::Migration
def self.up
create_table :sessions do |t|
diff --git a/db/migrate/118_remove_sessions_again.rb b/db/migrate/118_remove_sessions_again.rb
index dc5a63df7..88e896c08 100644
--- a/db/migrate/118_remove_sessions_again.rb
+++ b/db/migrate/118_remove_sessions_again.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveSessionsAgain < ActiveRecord::Migration
def self.up
drop_table :sessions
diff --git a/db/migrate/20120822145640_correct_external_request_constraint.rb b/db/migrate/20120822145640_correct_external_request_constraint.rb
index 6902f3cb2..6d6b58f28 100644
--- a/db/migrate/20120822145640_correct_external_request_constraint.rb
+++ b/db/migrate/20120822145640_correct_external_request_constraint.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CorrectExternalRequestConstraint < ActiveRecord::Migration
def self.up
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
diff --git a/db/migrate/20120910153022_create_request_classifications.rb b/db/migrate/20120910153022_create_request_classifications.rb
index 7c6270c9e..253e45909 100644
--- a/db/migrate/20120910153022_create_request_classifications.rb
+++ b/db/migrate/20120910153022_create_request_classifications.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateRequestClassifications < ActiveRecord::Migration
def self.up
create_table :request_classifications do |t|
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
index 14174935e..b69006e88 100644
--- a/db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb
+++ b/db/migrate/20120912111713_add_raw_email_index_to_incoming_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddRawEmailIndexToIncomingMessages < ActiveRecord::Migration
def self.up
add_index :incoming_messages, :raw_email_id
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
index 81e2a7946..e926b110e 100644
--- 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
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddInfoRequestIdIndexToEximLogs < ActiveRecord::Migration
def self.up
add_index :exim_logs, :info_request_id
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
index 814fa7540..d77196062 100644
--- 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
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddInfoRequestIdIndexToIncomingAndOutgoingMessages < ActiveRecord::Migration
def self.up
add_index :incoming_messages, :info_request_id
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
index be0bf76c3..c6d8008cf 100644
--- 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
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIncomingMessageIdIndexToFoiAttachments < ActiveRecord::Migration
def self.up
add_index :foi_attachments, :incoming_message_id
diff --git a/db/migrate/20120912113004_add_indexes_to_info_request_events.rb b/db/migrate/20120912113004_add_indexes_to_info_request_events.rb
index b3780322f..49178e4ce 100644
--- a/db/migrate/20120912113004_add_indexes_to_info_request_events.rb
+++ b/db/migrate/20120912113004_add_indexes_to_info_request_events.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIndexesToInfoRequestEvents < ActiveRecord::Migration
def self.up
add_index :info_request_events, :incoming_message_id
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
index a56cad1f9..a105fbc6d 100644
--- a/db/migrate/20120912113720_add_public_body_index_to_info_requests.rb
+++ b/db/migrate/20120912113720_add_public_body_index_to_info_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddPublicBodyIndexToInfoRequests < ActiveRecord::Migration
def self.up
add_index :info_requests, :public_body_id
diff --git a/db/migrate/20120912114022_add_user_index_to_info_requests.rb b/db/migrate/20120912114022_add_user_index_to_info_requests.rb
index 8be51c0c8..b44934feb 100644
--- a/db/migrate/20120912114022_add_user_index_to_info_requests.rb
+++ b/db/migrate/20120912114022_add_user_index_to_info_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddUserIndexToInfoRequests < ActiveRecord::Migration
def self.up
add_index :info_requests, :user_id
diff --git a/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb b/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb
index d187dcfa5..5cc82106f 100644
--- a/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb
+++ b/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddInfoRequestsCountToPublicBodies < ActiveRecord::Migration
def self.up
add_column :public_bodies, :info_requests_count, :integer, :null => false, :default => 0
diff --git a/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb b/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb
index 893395f41..a2a855d9d 100644
--- a/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb
+++ b/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIncomingMessageIndexToOutgoingMessages < ActiveRecord::Migration
def self.up
add_index :outgoing_messages, :incoming_message_followup_id
diff --git a/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb b/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb
index d119f55b3..0270c3e1e 100644
--- a/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb
+++ b/db/migrate/20120913080807_add_info_request_event_index_to_track_things_sent_emails.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddInfoRequestEventIndexToTrackThingsSentEmails < ActiveRecord::Migration
def self.up
add_index :track_things_sent_emails, :info_request_event_id
diff --git a/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb b/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb
index aa9f404f7..1b789c4e9 100644
--- a/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb
+++ b/db/migrate/20120913081136_add_info_request_event_index_to_user_info_request_sent_alerts.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddInfoRequestEventIndexToUserInfoRequestSentAlerts < ActiveRecord::Migration
def self.up
add_index :user_info_request_sent_alerts, :info_request_event_id
diff --git a/db/migrate/20120913135745_add_updated_at_index_to_public_body_versions.rb b/db/migrate/20120913135745_add_updated_at_index_to_public_body_versions.rb
index 6ae58c884..ceeee6efd 100644
--- a/db/migrate/20120913135745_add_updated_at_index_to_public_body_versions.rb
+++ b/db/migrate/20120913135745_add_updated_at_index_to_public_body_versions.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddUpdatedAtIndexToPublicBodyVersions < ActiveRecord::Migration
def self.up
add_index :public_body_versions, :updated_at
diff --git a/db/migrate/20120919140404_add_comments_allowed_to_info_request.rb b/db/migrate/20120919140404_add_comments_allowed_to_info_request.rb
index 4ae0bce18..a7671507f 100644
--- a/db/migrate/20120919140404_add_comments_allowed_to_info_request.rb
+++ b/db/migrate/20120919140404_add_comments_allowed_to_info_request.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCommentsAllowedToInfoRequest < ActiveRecord::Migration
def self.up
add_column :info_requests, :comments_allowed, :boolean, :null => false, :default => true
diff --git a/db/migrate/20121010214348_rename_exim_log_tables.rb b/db/migrate/20121010214348_rename_exim_log_tables.rb
index 75fcff065..5c8ee8297 100644
--- a/db/migrate/20121010214348_rename_exim_log_tables.rb
+++ b/db/migrate/20121010214348_rename_exim_log_tables.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RenameEximLogTables < ActiveRecord::Migration
def self.up
rename_table :exim_logs, :mail_server_logs
diff --git a/db/migrate/20121022031914_add_disclosure_log.rb b/db/migrate/20121022031914_add_disclosure_log.rb
index 82ea7dbcd..65ab7162d 100644
--- a/db/migrate/20121022031914_add_disclosure_log.rb
+++ b/db/migrate/20121022031914_add_disclosure_log.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddDisclosureLog < ActiveRecord::Migration
def self.up
add_column :public_bodies, :disclosure_log, :text, :null => false, :default => ""
diff --git a/db/migrate/20130731142632_remove_prominence_from_info_request_event.rb b/db/migrate/20130731142632_remove_prominence_from_info_request_event.rb
index df0278c20..c0509e2e4 100644
--- a/db/migrate/20130731142632_remove_prominence_from_info_request_event.rb
+++ b/db/migrate/20130731142632_remove_prominence_from_info_request_event.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class RemoveProminenceFromInfoRequestEvent < ActiveRecord::Migration
def up
remove_column :info_request_events, :prominence
diff --git a/db/migrate/20130731145325_add_prominence_to_incoming_message.rb b/db/migrate/20130731145325_add_prominence_to_incoming_message.rb
index 01c4906a7..89d2eb26c 100644
--- a/db/migrate/20130731145325_add_prominence_to_incoming_message.rb
+++ b/db/migrate/20130731145325_add_prominence_to_incoming_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddProminenceToIncomingMessage < ActiveRecord::Migration
def change
add_column :incoming_messages, :prominence, :string, :null => false, :default => 'normal'
diff --git a/db/migrate/20130801154033_add_prominence_reason_to_incoming_message.rb b/db/migrate/20130801154033_add_prominence_reason_to_incoming_message.rb
index 2d189f658..9f6ecac27 100644
--- a/db/migrate/20130801154033_add_prominence_reason_to_incoming_message.rb
+++ b/db/migrate/20130801154033_add_prominence_reason_to_incoming_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddProminenceReasonToIncomingMessage < ActiveRecord::Migration
def change
add_column :incoming_messages, :prominence_reason, :text
diff --git a/db/migrate/20130816150110_add_statistics_to_public_body.rb b/db/migrate/20130816150110_add_statistics_to_public_body.rb
index fb3a67e83..aaa7b0f27 100644
--- a/db/migrate/20130816150110_add_statistics_to_public_body.rb
+++ b/db/migrate/20130816150110_add_statistics_to_public_body.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddStatisticsToPublicBody < ActiveRecord::Migration
def self.up
add_column :public_bodies, :info_requests_successful_count, :integer
diff --git a/db/migrate/20130822161803_add_prominence_fields_to_outgoing_message.rb b/db/migrate/20130822161803_add_prominence_fields_to_outgoing_message.rb
index a75e0d426..fc4c5540f 100644
--- a/db/migrate/20130822161803_add_prominence_fields_to_outgoing_message.rb
+++ b/db/migrate/20130822161803_add_prominence_fields_to_outgoing_message.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddProminenceFieldsToOutgoingMessage < ActiveRecord::Migration
def change
add_column :outgoing_messages, :prominence, :string, :null => false, :default => 'normal'
diff --git a/db/migrate/20130919151140_add_can_make_batch_requests_to_user.rb b/db/migrate/20130919151140_add_can_make_batch_requests_to_user.rb
index cc9d8e76f..5bf1db6de 100644
--- a/db/migrate/20130919151140_add_can_make_batch_requests_to_user.rb
+++ b/db/migrate/20130919151140_add_can_make_batch_requests_to_user.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddCanMakeBatchRequestsToUser < ActiveRecord::Migration
def change
add_column :users, :can_make_batch_requests, :boolean, :default => false, :null => false
diff --git a/db/migrate/20131024114346_create_info_request_batches.rb b/db/migrate/20131024114346_create_info_request_batches.rb
index 09c6f467b..bb56be6d2 100644
--- a/db/migrate/20131024114346_create_info_request_batches.rb
+++ b/db/migrate/20131024114346_create_info_request_batches.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateInfoRequestBatches < ActiveRecord::Migration
def up
create_table :info_request_batches do |t|
diff --git a/db/migrate/20131024152540_add_body_to_info_request_batches.rb b/db/migrate/20131024152540_add_body_to_info_request_batches.rb
index 5f9b3af10..ad547c467 100644
--- a/db/migrate/20131024152540_add_body_to_info_request_batches.rb
+++ b/db/migrate/20131024152540_add_body_to_info_request_batches.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddBodyToInfoRequestBatches < ActiveRecord::Migration
def up
add_column :info_request_batches, :body, :text
diff --git a/db/migrate/20131101155844_add_stats_denominator.rb b/db/migrate/20131101155844_add_stats_denominator.rb
index 7df4c8200..05920084b 100644
--- a/db/migrate/20131101155844_add_stats_denominator.rb
+++ b/db/migrate/20131101155844_add_stats_denominator.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddStatsDenominator < ActiveRecord::Migration
def up
add_column :public_bodies, :info_requests_visible_classified_count, :integer
diff --git a/db/migrate/20131127105438_create_info_request_batch_public_bodies_join_table.rb b/db/migrate/20131127105438_create_info_request_batch_public_bodies_join_table.rb
index 11a9c7066..8e75eb9bf 100644
--- a/db/migrate/20131127105438_create_info_request_batch_public_bodies_join_table.rb
+++ b/db/migrate/20131127105438_create_info_request_batch_public_bodies_join_table.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateInfoRequestBatchPublicBodiesJoinTable < ActiveRecord::Migration
def change
create_table :info_request_batches_public_bodies, :id => false do |t|
diff --git a/db/migrate/20131127135622_add_sent_at_to_info_request_batch.rb b/db/migrate/20131127135622_add_sent_at_to_info_request_batch.rb
index 27d4aecee..2d485a065 100644
--- a/db/migrate/20131127135622_add_sent_at_to_info_request_batch.rb
+++ b/db/migrate/20131127135622_add_sent_at_to_info_request_batch.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddSentAtToInfoRequestBatch < ActiveRecord::Migration
def change
add_column :info_request_batches, :sent_at, :datetime
diff --git a/db/migrate/20131211152641_create_public_body_change_requests.rb b/db/migrate/20131211152641_create_public_body_change_requests.rb
index e3fb560a6..76e24d589 100644
--- a/db/migrate/20131211152641_create_public_body_change_requests.rb
+++ b/db/migrate/20131211152641_create_public_body_change_requests.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreatePublicBodyChangeRequests < ActiveRecord::Migration
def up
create_table :public_body_change_requests do |t|
diff --git a/db/migrate/20140325120619_create_spam_addresses.rb b/db/migrate/20140325120619_create_spam_addresses.rb
index 7c730a5c7..0258e01b9 100644
--- a/db/migrate/20140325120619_create_spam_addresses.rb
+++ b/db/migrate/20140325120619_create_spam_addresses.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateSpamAddresses < ActiveRecord::Migration
def change
create_table :spam_addresses do |t|
diff --git a/db/migrate/20140408145616_add_default_short_name_to_public_bodies.rb b/db/migrate/20140408145616_add_default_short_name_to_public_bodies.rb
index 5fb239ebd..0a4ce19b3 100644
--- a/db/migrate/20140408145616_add_default_short_name_to_public_bodies.rb
+++ b/db/migrate/20140408145616_add_default_short_name_to_public_bodies.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddDefaultShortNameToPublicBodies < ActiveRecord::Migration
def up
diff --git a/db/migrate/20140528110536_update_track_things_index.rb b/db/migrate/20140528110536_update_track_things_index.rb
index 55ee0b70b..209beecce 100644
--- a/db/migrate/20140528110536_update_track_things_index.rb
+++ b/db/migrate/20140528110536_update_track_things_index.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class UpdateTrackThingsIndex < ActiveRecord::Migration
def up
diff --git a/db/migrate/20140710094405_create_public_body_headings_and_categories.rb b/db/migrate/20140710094405_create_public_body_headings_and_categories.rb
index 0ba7f64a0..b65d2078b 100644
--- a/db/migrate/20140710094405_create_public_body_headings_and_categories.rb
+++ b/db/migrate/20140710094405_create_public_body_headings_and_categories.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreatePublicBodyHeadingsAndCategories < ActiveRecord::Migration
def up
create_table :public_body_headings, :force => true do |t|
@@ -24,4 +25,4 @@ class CreatePublicBodyHeadingsAndCategories < ActiveRecord::Migration
drop_table :public_body_headings
drop_table :public_body_categories_public_body_headings
end
-end \ No newline at end of file
+end
diff --git a/db/migrate/20140716131107_create_category_translation_tables.rb b/db/migrate/20140716131107_create_category_translation_tables.rb
index f4b90b330..95591caf2 100644
--- a/db/migrate/20140716131107_create_category_translation_tables.rb
+++ b/db/migrate/20140716131107_create_category_translation_tables.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class CreateCategoryTranslationTables < ActiveRecord::Migration
class PublicBodyCategory < ActiveRecord::Base
translates :title, :description
diff --git a/db/migrate/20140801132719_add_index_to_info_request_events.rb b/db/migrate/20140801132719_add_index_to_info_request_events.rb
index 5f0a77eac..48c36f2b4 100644
--- a/db/migrate/20140801132719_add_index_to_info_request_events.rb
+++ b/db/migrate/20140801132719_add_index_to_info_request_events.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddIndexToInfoRequestEvents < ActiveRecord::Migration
def change
add_index :info_request_events, :event_type
diff --git a/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb b/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb
index c2e7e2ac3..a7160995d 100644
--- a/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb
+++ b/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
class AddDisplayOrderToCategoriesAndHeadings < ActiveRecord::Migration
def up
add_column :public_body_categories_public_body_headings, :category_display_order, :integer
diff --git a/db/migrate/20140824191444_create_widget_votes.rb b/db/migrate/20140824191444_create_widget_votes.rb
new file mode 100644
index 000000000..467f937e2
--- /dev/null
+++ b/db/migrate/20140824191444_create_widget_votes.rb
@@ -0,0 +1,12 @@
+# -*- encoding : utf-8 -*-
+class CreateWidgetVotes < ActiveRecord::Migration
+ def change
+ create_table :widget_votes do |t|
+ t.string :cookie
+ t.belongs_to :info_request, :null => false
+
+ t.timestamps
+ end
+ add_index :widget_votes, :info_request_id
+ end
+end
diff --git a/db/seeds.rb b/db/seeds.rb
index 664d8c74c..d12490d17 100644
--- a/db/seeds.rb
+++ b/db/seeds.rb
@@ -1,3 +1,4 @@
+# -*- encoding : utf-8 -*-
# This file should contain all the record creation needed to seed the database with its default values.
# The data can then be loaded with the rake db:seed (or created alongside the db with db:setup).
#