diff options
Diffstat (limited to 'db/migrate/20111104140800_create_calls.rb')
| -rw-r--r-- | db/migrate/20111104140800_create_calls.rb | 28 |
1 files changed, 28 insertions, 0 deletions
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 |