db/migrations/001_create_messages.rb


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
26
27
28
29
30
31
32
33
34
35


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
      t.string :re_message_id
      t.string :status
      t.float :delay
      t.string :delays
    end
    add_index :messages, :message_id
  end

  def down
    drop_table :messages
  end
end