Sha256: 0e877c6e340b22e27255e6f6a13b92fd50f076f439aeb32c8e813e0af41a4d1a

Contents?: true

Size: 1.07 KB

Versions: 13

Compression:

Stored size: 1.07 KB

Contents

# frozen_string_literal: true

class CreateCampaigns < ActiveRecord::Migration[4.2]
  def self.up
    create_table :campaigns, force: true do |t|
      t.string :uuid, limit: 36
      t.references :user
      t.integer :assigned_to
      t.string :name,   limit: 64, null: false, default: ""
      t.string :access, limit: 8, default: "Public" # %w(Private Public Shared)
      t.string :status, limit: 64
      t.decimal :budget, precision: 12, scale: 2
      # Target metrics.
      t.integer :target_leads
      t.float :target_conversion # leads-to-opportunities conversion ratio (%)
      t.decimal :target_revenue, precision: 12, scale: 2
      # Actual metrics.
      t.integer :leads_count
      t.integer :opportunities_count
      t.decimal :revenue, precision: 12, scale: 2
      # Dates.
      t.date :starts_on
      t.date :ends_on
      t.text :objectives
      t.datetime :deleted_at
      t.timestamps
    end

    add_index :campaigns, %i[user_id name deleted_at], unique: true
    add_index :campaigns, :assigned_to
  end

  def self.down
    drop_table :campaigns
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

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