Contents

class CreateEmails < ActiveRecord::Migration
  def self.up
    create_table :emails, force: true do |t|
      t.string :imap_message_id, null: false  # IMAP internal message identifier.
      t.references :user                             # User who created th email.
      t.references :mediator, polymorphic: true   # Identifies where the email is attached to.
      t.string :sent_from, null: false        # From:
      t.string :sent_to, null: false          # To:
      t.string :cc                               # Cc:
      t.string :bcc                              # Bcc:
      t.string :subject                          # Subject:
      t.text :body                             # Body:
      t.text :header                           # Raw header as received from IMAP server.
      t.datetime :sent_at                          # Time the message was sent.
      t.datetime :received_at                      # Time the message was received.
      t.datetime :deleted_at
      t.timestamps
    end

    add_index :emails, [:mediator_id, :mediator_type]
  end

  def self.down
    drop_table :emails
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
fat_free_crm-0.14.2	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.14.1	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.15.0.beta.2	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.15.0.beta	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.14.0	db/migrate/20100928030625_create_emails.rb
reduced_fat_crm-0.15.0.beta	db/migrate/20100928030625_create_emails.rb
reduced_fat_crm-0.14.0	db/migrate/20100928030625_create_emails.rb