aboutsummaryrefslogtreecommitdiffstats
path: root/1.2-netsec/contrib/scripts/postgres_cdr.sql
diff options
context:
space:
mode:
Diffstat (limited to '1.2-netsec/contrib/scripts/postgres_cdr.sql')
-rw-r--r--1.2-netsec/contrib/scripts/postgres_cdr.sql33
1 files changed, 0 insertions, 33 deletions
diff --git a/1.2-netsec/contrib/scripts/postgres_cdr.sql b/1.2-netsec/contrib/scripts/postgres_cdr.sql
deleted file mode 100644
index a4701bd77..000000000
--- a/1.2-netsec/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 ''
-);
-