summaryrefslogtreecommitdiff
path: root/db/migrate/20120228154913_create_cdrs.rb
blob: f9f92b7185862058b60bff079932fd487d487628 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
class CreateCdrs < ActiveRecord::Migration
  def self.up
    create_table :cdrs, :id => false do |t|
      t.string   :uuid,                    :limit => '256', :primary => true
      t.integer  :account_id
      t.string   :account_type,            :limit => '256'
      t.string   :bleg_uuid,               :limit => '256'
      t.integer  :bleg_account_id
      t.string   :bleg_account_type,       :limit => '256'
      t.string   :dialed_number,           :limit => '256'
      t.string   :destination_number,      :limit => '256'
      t.string   :caller_id_number,        :limit => '256'
      t.string   :caller_id_name,          :limit => '256'
      t.string   :callee_id_number,        :limit => '256'
      t.string   :callee_id_name,          :limit => '256'
      t.datetime :start_stamp
      t.datetime :answer_stamp
      t.datetime :end_stamp
      t.integer  :duration
      t.integer  :billsec
      t.string   :hangup_cause,            :limit => '256'
      t.string   :dialstatus,              :limit => '256'
      t.string   :forwarding_number,       :limit => '256'
      t.integer  :forwarding_account_id
      t.string   :forwarding_account_type, :limit => '256'
      t.string   :forwarding_service,      :limit => '256'
    end
  end

  def self.down
    drop_table :cdrs
  end
end