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