1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
|
