Sha256: 9c35771be2d3df40a82d86f43cd9108f8a8f17e9dde94eb7a7d34c8cc51f4660
Contents?: true
Size: 972 Bytes
Versions: 16
Compression:
Stored size: 972 Bytes
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
16 entries across 16 versions & 1 rubygems