Contents

# frozen_string_literal: true

class CreateEmails < ActiveRecord::Migration[4.2]
  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 the 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, %i[mediator_id mediator_type]
  end

  def self.down
    drop_table :emails
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
fat_free_crm-0.22.1	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.22.0	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.21.0	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.20.1	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.20.0	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.19.2	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.19.0	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.18.2	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.17.3	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.18.1	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.18.0	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.17.2	db/migrate/20100928030625_create_emails.rb
fat_free_crm-0.17.1	db/migrate/20100928030625_create_emails.rb