Rev 1370 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 1370 | Rev 1373 | ||
---|---|---|---|
1 | CREATE SEQUENCE activecalls_acctid_seq; |
1 | CREATE SEQUENCE activecalls_acctid_seq; |
2 | 2 | ||
3 | CREATE TABLE activecalls ( |
3 | CREATE TABLE activecalls ( |
4 | acctid bigint not null, |
4 | acctid bigint not null, |
5 | calldate timestamp with time zone not null, |
5 | calldate timestamp with time zone not null, |
6 | linkdate timestamp with time zone, |
6 | linkdate timestamp with time zone, |
7 | clid character varying(80), |
7 | clid character varying(80), |
8 | src character varying(80), |
8 | src character varying(80), |
9 | dst character varying(80), |
9 | dst character varying(80), |
10 | dcontext character varying(80), |
10 | dcontext character varying(80), |
11 | channel character varying(80), |
11 | channel character varying(80), |
12 | dstchannel character varying(80), |
12 | dstchannel character varying(80), |
13 | lastapp character varying(80), |
13 | lastapp character varying(80), |
14 | lastdata character varying(80), |
14 | lastdata character varying(80), |
15 | duration integer, |
15 | duration integer, |
16 | billsec integer, |
16 | billsec integer, |
17 | disposition character varying(45), |
17 | disposition character varying(45), |
18 | amaflags integer, |
18 | amaflags integer, |
19 | accountcode character varying(20), |
19 | accountcode character varying(20), |
20 | uniqueid character varying(32), |
20 | uniqueid character varying(32), |
21 | userfield character varying(255) |
21 | userfield character varying(255) |
22 | ); |
22 | ); |