Contents

class MlmInitial < ActiveRecord::Migration
  def self.up
    create_table :mlm_mailing_lists do |t|
      t.string :name
      t.text :description
      t.string :status
      t.datetime :status_changed_at
      t.timestamps
    end
    create_table :mlm_subscriptions do |t|
      t.integer :mlm_contact_id
      t.integer :mlm_mailing_list_id
      t.string :status
      t.datetime :status_changed_at
      t.integer :updated_by
      t.timestamps
    end
    create_table :mlm_mailings do |t|
      t.string :subject
      t.string :from_email_address
      t.string :mailable
      t.string :status
      t.datetime :status_changed_at
      t.datetime :scheduled_at
      t.boolean :include_images
      t.timestamps
    end
    create_table :mlm_mailing_lists_mlm_mailings, :id => false do |t|
      t.integer :mlm_mailing_id
      t.integer :mlm_mailing_list_id
    end
    create_table :mlm_messages do |t|
      t.integer :mlm_contact_id
      t.integer :mlm_mailing_id
      t.string :guid
      t.string :status
      t.datetime :status_changed_at
      t.text :result
      t.timestamps
    end
    create_table :mlm_bounces do |t|
      t.integer :mlm_message_id
      t.string :status
      t.datetime :status_changed_at
      t.text :bounce_message
      t.text :comments
      t.timestamps
    end
    create_table :mlm_mailables do |t|
      t.string    :name, :null => false
      t.text      :email_html
      t.text      :email_text
      t.boolean   :reusable  
      t.integer   :updated_by
      t.timestamps
    end
  end

  def self.down
    drop_table :mlm_bounces
    drop_table :mlm_messages
    drop_table :mlm_mailing_lists_mlm_mailings
    drop_table :mlm_mailings
    drop_table :mlm_subscriptions
    drop_table :mlm_mailing_lists
  end
end

Version data entries

15 entries across 15 versions & 1 rubygems

Version	Path
mail_manager-3.2.25.1	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.22.0	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.7	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.6	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.5	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.4	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.2	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.1	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.2.0	db/mlm_migrate/001_mlm_initial.rb
mail_manager-3.0.0	db/mlm_migrate/001_mlm_initial.rb
mail_manager-0.1.4	db/mlm_migrate/001_mlm_initial.rb
mail_manager-0.1.2	db/mlm_migrate/001_mlm_initial.rb
mail_manager-0.1.1	db/mlm_migrate/001_mlm_initial.rb
mail_manager-0.1.0	db/mlm_migrate/001_mlm_initial.rb
mail_manager-0.0.1	db/mlm_migrate/001_mlm_initial.rb