blob: 9ff04e88fe8aa6234c0d1612962c1a477e0fff2c (
plain)
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
|
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
|