postgres_cdr.sql

来自「一个非常美妙的proxy。功能强大。基于sip的协议。如果还要的话」· SQL 代码 · 共 34 行

/*
 * Id: postgres_cdr.sql,v 1.8.2.11 2003/10/10 11:15:43 pnixon Exp $
 *
 * --- Peter Nixon [ [e-mail] ]
 *
 * This is a PostgreSQL schema for doing CDR accounting with Asterisk
 *
 * The calls will automatically be logged as long as the module is loaded.
 *
 */


CREATE TABLE cdr (
        AcctId		BIGSERIAL PRIMARY KEY,
	calldate	TIMESTAMP with time zone NOT NULL DEFAULT now(),
	clid		VARCHAR(80) NOT NULL default '',
	src		VARCHAR(80) NOT NULL default '',
	dst		VARCHAR(80) NOT NULL default '',
	dcontext	VARCHAR(80) NOT NULL default '',
	channel		VARCHAR(80) NOT NULL default '',
	dstchannel	VARCHAR(80) NOT NULL default '',
	lastapp		VARCHAR(80) NOT NULL default '',
	lastdata	VARCHAR(80) NOT NULL default '',
	duration	INTEGER NOT NULL default '0',
	billsec		INTEGER NOT NULL default '0',
	disposition	VARCHAR(45) NOT NULL default '',
	amaflags	INTEGER NOT NULL default '0',
	accountcode	VARCHAR(20) NOT NULL default '',
	uniqueid	VARCHAR(32) NOT NULL default '',
	userfield	VARCHAR(255) NOT NULL default ''
);