initial commit

1 files changed, 32 insertions, 0 deletions

diff --git a/db/migrations/001_create_messages.rb b/db/migrations/001_create_messages.rb
new file mode 100644
index 0000000..9ff04e8
--- /dev/null
+++ b/db/migrations/001_create_messages.rb
@@ -0,0 +1,32 @@
+
+class CreateMessages < ActiveRecord::Migration
+  def up
+    create_table :messages do |t|
+      t.string :queue_id
+      t.string :message_id
+      t.datetime :first_seen_at
+      t.datetime :sent_at
+      t.datetime :received_at
+      t.datetime :date
+      t.string :sender
+      t.string :recipient
+      t.string :orig_to
+      t.string :from
+      t.text :to
+      t.text :cc
+      t.text :bcc
+      t.integer :size
+      t.integer :spam_score
+      t.integer :subject_length
+      t.boolean :is_list, :default => false
+      t.boolean :is_outgoing, :default => nil
+      t.string :re_message_id, :default => nil
+    end
+    add_index :messages, :message_id
+  end
+
+  def down
+    drop_table :messages
+  end
+end
+