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
34
35
36
37
38
39
40
41
42
|
class CreateChannels < ActiveRecord::Migration
def self.up
create_table :channels, :id => false do |t|
t.string :uuid, :limit=>'256', :primary => true
t.string :direction, :limit=>'32'
t.string :created, :limit=>'128'
t.integer :created_epoch
t.string :name, :limit=>'1024'
t.string :state, :limit=>'64'
t.string :cid_name, :limit=>'1024'
t.string :cid_num, :limit=>'256'
t.string :ip_addr, :limit=>'256'
t.string :dest, :limit=>'1024'
t.string :application, :limit=>'128'
t.string :application_data, :limit=>'4096'
t.string :dialplan, :limit=>'128'
t.string :context, :limit=>'128'
t.string :read_codec, :limit=>'128'
t.string :read_rate, :limit=>'32'
t.string :read_bit_rate, :limit=>'32'
t.string :write_codec, :limit=>'128'
t.string :write_rate, :limit=>'32'
t.string :write_bit_rate, :limit=>'32'
t.string :secure, :limit=>'32'
t.string :hostname, :limit=>'256'
t.string :presence_id, :limit=>'4096'
t.string :presence_data, :limit=>'4096'
t.string :callstate, :limit=>'64'
t.string :callee_name, :limit=>'1024'
t.string :callee_num, :limit=>'256'
t.string :callee_direction, :limit=>'5'
t.string :call_uuid, :limit=>'256'
end
add_index :channels, [ :hostname ], :unique => false, :name => 'channels1'
add_index :channels, [ :uuid, :hostname ], :unique => true, :name => 'uuindex'
add_index :channels, [ :call_uuid, :hostname ], :unique => false, :name => 'uuindex2'
end
def self.down
drop_table :channels
end
end
|
