Sha256: a55df912888da07b8bdd9ef7cbfab7fa59631f612eca6f362c7c08d23a5e47f7
Contents?: true
Size: 1.16 KB
Versions: 16
Compression:
Stored size: 1.16 KB
Contents
class CreateCampaigns < ActiveRecord::Migration
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, [ :user_id, :name, :deleted_at ], :unique => true
add_index :campaigns, :assigned_to
end
def self.down
drop_table :campaigns
end
end
Version data entries
16 entries across 16 versions & 1 rubygems