From 44bf50567ffe82b4318a93c62b07adb2f60c95f0 Mon Sep 17 00:00:00 2001 From: Russell Bryant Date: Thu, 8 May 2008 15:38:27 +0000 Subject: Merged revisions 115557 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.4 ........ r115557 | russell | 2008-05-08 10:37:49 -0500 (Thu, 08 May 2008) | 3 lines remove postgres_cdr.sql, as the CDR schema is in realtime_pgsql.sql, as well (closes issue #9676) ........ git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@115558 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- 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 '' -); - -- cgit v1.2.3