diff options
Diffstat (limited to 'db/migrate/027_change_classification_system.rb')
| -rw-r--r-- | db/migrate/027_change_classification_system.rb | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/db/migrate/027_change_classification_system.rb b/db/migrate/027_change_classification_system.rb new file mode 100644 index 000000000..d9e6ad844 --- /dev/null +++ b/db/migrate/027_change_classification_system.rb @@ -0,0 +1,25 @@ +class ChangeClassificationSystem < ActiveRecord::Migration + def self.up + remove_column :incoming_messages, :contains_information + remove_column :incoming_messages, :user_classified + + add_column :info_requests, :described_state, :string + InfoRequest.update_all "described_state = 'waiting_response'" + change_column :info_requests, :described_state, :string, :null => false + + add_column :info_requests, :awaiting_description, :boolean, :default => false, :null => false + InfoRequest.update_all "awaiting_description = 't' where (select count(*) from incoming_messages where info_request_id = info_requests.id) > 0" + + add_column :info_requests, :described_last_incoming_message_id, :integer + InfoRequest.update_all "described_last_incoming_message_id = null" + end + + def self.down + add_column :incoming_messages, :contains_information, :boolean + add_column :incoming_messages, :user_classified, :boolean + + remove_column :info_requests, :described_state + remove_column :info_requests, :awaiting_description + remove_column :info_requests, :described_last_incoming_message_id + end +end |