[Asterisk-Dev] Postgres and Asterisk

[Peter Nixon]

Hi Guys

here is a quick schema I whipped up for Asterisk and Postgresql as I could not 
find one in the source and no-one onf #asterisk had one either. Also attached 
is a sample cdr_pgsql.conf

I herby grant Digium the authority to use this code commercially, and 
relinquish any copyright I may have over the code. It can also be used to 
beat your mother with if anyone feels the need.

PS. Mark/Jac/Chris, yes there is a CVS version number in the file :-)

Cheers
-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-------------- next part --------------

/*
 * Id: postgres_cdr.sql,v 1.8.2.11 2003/10/10 11:15:43 pnixon Exp $
 *
 * --- Peter Nixon [ codemonkey at peternixon.net ]
 *
 * 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(45) NOT NULL default '',
	src		VARCHAR(45) NOT NULL default '',
	dst		VARCHAR(45) NOT NULL default '',
	dcontext	VARCHAR(45) NOT NULL default '',
	channel		VARCHAR(45) NOT NULL default '',
	dstchannel	VARCHAR(45) NOT NULL default '',
	lastapp		VARCHAR(45) NOT NULL default '',
	lastdata	VARCHAR(45) 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(45) NOT NULL default '',
	uniqueid	VARCHAR(45) NOT NULL default ''
);

-------------- next part --------------
[global]
hostname=127.0.0.1
dbname=asterisk
password=
user=postgres