Subversion Repositories general

Rev

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 
);