diff options
Diffstat (limited to 'db/migrations/001_create_messages.rb')
-rw-r--r-- | db/migrations/001_create_messages.rb | 32 |
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 + |