Subversion Repositories general

Rev

Rev 1370 | Details | Compare with Previous | 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 
);