diff options
Diffstat (limited to 'db/migrate')
| -rw-r--r-- | db/migrate/052_include_event_foreign_references.rb | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/db/migrate/052_include_event_foreign_references.rb b/db/migrate/052_include_event_foreign_references.rb new file mode 100644 index 000000000..faa853ef4 --- /dev/null +++ b/db/migrate/052_include_event_foreign_references.rb @@ -0,0 +1,25 @@ +class IncludeEventForeignReferences < ActiveRecord::Migration + def self.up + add_column :info_request_events, :incoming_message_id, :integer + add_column :info_request_events, :outgoing_message_id, :integer + for event in InfoRequestEvent.find(:all) + #STDERR.puts "event " + event.id.to_s + incoming_message = event.incoming_message_via_params + if not incoming_message.nil? + event.incoming_message_id = incoming_message.id + end + outgoing_message = event.outgoing_message_via_params + if not outgoing_message.nil? + event.outgoing_message_id = outgoing_message.id + end + event.save! + end + execute "ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_incoming_message_id FOREIGN KEY (incoming_message_id) REFERENCES incoming_messages(id)" + execute "ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_outgoing_message_id FOREIGN KEY (outgoing_message_id) REFERENCES outgoing_messages(id)" + end + + def self.down + remove_column :info_request_events, :outgoing_message_id + remove_column :info_request_events, :incoming_message_id + end +end |