Contents

class CreateOpportunities < ActiveRecord::Migration
  def self.up
    create_table :opportunities, force: true do |t|
      t.string :uuid,     limit: 36
      t.references :user
      t.references :campaign
      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 :source,   limit: 32
      t.string :stage,    limit: 32
      t.integer :probability
      t.decimal :amount,   precision: 12, scale: 2
      t.decimal :discount, precision: 12, scale: 2
      t.date :closes_on
      t.datetime :deleted_at
      t.timestamps
    end

    add_index :opportunities, [:user_id, :name, :deleted_at], unique: true, name: 'id_name_deleted'
    add_index :opportunities, :assigned_to
  end

  def self.down
    drop_table :opportunities
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
fat_free_crm-0.14.2	db/migrate/20100928030608_create_opportunities.rb
fat_free_crm-0.14.1	db/migrate/20100928030608_create_opportunities.rb
fat_free_crm-0.15.0.beta.2	db/migrate/20100928030608_create_opportunities.rb
fat_free_crm-0.15.0.beta	db/migrate/20100928030608_create_opportunities.rb
fat_free_crm-0.14.0	db/migrate/20100928030608_create_opportunities.rb
reduced_fat_crm-0.15.0.beta	db/migrate/20100928030608_create_opportunities.rb
reduced_fat_crm-0.14.0	db/migrate/20100928030608_create_opportunities.rb