1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/009_create_outgoing_messages.rb b/db/migrate/009_create_outgoing_messages.rb
new file mode 100644
index 000000000..62bf25392
--- /dev/null
+++ b/db/migrate/009_create_outgoing_messages.rb
@@ -0,0 +1,20 @@
+class CreateOutgoingMessages < ActiveRecord::Migration
+  def self.up
+    create_table :outgoing_messages do |t|
+      t.column :info_request_id, :integer
+
+      t.column :body, :text
+      t.column :status, :string
+
+      t.column :public_body_id, :integer
+      t.column :message_type, :string
+
+      t.column :created_at, :datetime
+      t.column :updated_at, :datetime
+    end
+  end
+
+  def self.down
+    drop_table :outgoing_messages
+  end
+end