0,0 → 1,22 |
CREATE SEQUENCE activecalls_acctid_seq; |
|
CREATE TABLE activecalls ( |
acctid bigint not null, |
calldate timestamp with time zone not null, |
linkdate timestamp with time zone, |
clid character varying(80), |
src character varying(80), |
dst character varying(80), |
dcontext character varying(80), |
channel character varying(80), |
dstchannel character varying(80), |
lastapp character varying(80), |
lastdata character varying(80), |
duration integer, |
billsec integer, |
disposition character varying(45), |
amaflags integer, |
accountcode character varying(20), |
uniqueid character varying(32), |
userfield character varying(255) |
); |