From b80bd744ad873f6fc43018bc4bfb90677de167bd Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Mon, 17 Dec 2012 12:01:45 +0100 Subject: Start of GS5. --- db/migrate/20111104140800_create_calls.rb | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 db/migrate/20111104140800_create_calls.rb (limited to 'db/migrate/20111104140800_create_calls.rb') diff --git a/db/migrate/20111104140800_create_calls.rb b/db/migrate/20111104140800_create_calls.rb new file mode 100644 index 0000000..1b66a76 --- /dev/null +++ b/db/migrate/20111104140800_create_calls.rb @@ -0,0 +1,28 @@ +class CreateCalls < ActiveRecord::Migration + def self.up + create_table :calls, :id => false do |t| + t.string :call_uuid, :limit=>'255', :primary => true + t.string :call_created, :limit=>'128' + t.integer :call_created_epoch + t.string :function, :limit=>'1024' + t.string :caller_cid_name, :limit=>'1024' + t.string :caller_cid_num, :limit=>'256' + t.string :caller_dest_num, :limit=>'256' + t.string :caller_chan_name, :limit=>'1024' + t.string :caller_uuid, :limit=>'256' + t.string :callee_cid_name, :limit=>'1024' + t.string :callee_cid_numcallee_dest_num, :limit=>'256' + t.string :callee_chan_name, :limit=>'1024' + t.string :callee_uuid, :limit=>'256' + t.string :hostname, :limit=>'256' + end + add_index :calls, [ :hostname ], :unique => false, :name => 'calls1' + add_index :calls, [ :callee_uuid, :hostname ], :unique => false, :name => 'eeuuindex' + add_index :calls, [ :call_uuid, :hostname ], :unique => false, :name => 'eeuuindex2' + add_index :calls, [ :caller_uuid, :hostname ], :unique => false, :name => 'eruuindex' + end + + def self.down + drop_table :calls + end +end -- cgit v1.2.3