From 03ec0856f99217816d99ee79e31d1ae4a267eb78 Mon Sep 17 00:00:00 2001 From: russell Date: Thu, 8 May 2008 15:37:49 +0000 Subject: [PATCH] remove postgres_cdr.sql, as the CDR schema is in realtime_pgsql.sql, as well (closes issue #9676) git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@115557 614ede4d-c843-0410-af14-a771ab80d22e --- contrib/scripts/postgres_cdr.sql | 33 --------------------------------- 1 file changed, 33 deletions(-) delete mode 100644 contrib/scripts/postgres_cdr.sql diff --git a/contrib/scripts/postgres_cdr.sql b/contrib/scripts/postgres_cdr.sql deleted file mode 100644 index a4701bd77..000000000 --- a/contrib/scripts/postgres_cdr.sql +++ /dev/null @@ -1,33 +0,0 @@ - -/* - * Id: postgres_cdr.sql,v 1.8.2.11 2003/10/10 11:15:43 pnixon Exp $ - * - * --- Peter Nixon [ codemonkey@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(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 '' -); - -- 2.11.4.GIT