1 files changed, 33 insertions, 0 deletions
diff --git a/db/migrate/20120228154913_create_cdrs.rb b/db/migrate/20120228154913_create_cdrs.rb
new file mode 100644
index 0000000..f9f92b7
--- /dev/null
+++ b/db/migrate/20120228154913_create_cdrs.rb
@@ -0,0 +1,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