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