summaryrefslogtreecommitdiff
path: root/contrib/scripts/postgres_cdr.sql
diff options
context:
space:
mode:
authorMark Spencer <markster@digium.com>2003-12-02 23:42:39 +0000
committerMark Spencer <markster@digium.com>2003-12-02 23:42:39 +0000
commit5b13ea0278af5fe1c4d42ff5614e7025bbf4cccc (patch)
tree3c79e362dd8169054fa405e7b434c3217ad403dc /contrib/scripts/postgres_cdr.sql
parent08c7c4be3131df965fcc2ac30167900f344e4964 (diff)
Fix SQL description for longer channels
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@1815 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/scripts/postgres_cdr.sql')
-rwxr-xr-xcontrib/scripts/postgres_cdr.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/contrib/scripts/postgres_cdr.sql b/contrib/scripts/postgres_cdr.sql
index 3db3fc037..e03fd957e 100755
--- a/contrib/scripts/postgres_cdr.sql
+++ b/contrib/scripts/postgres_cdr.sql
@@ -14,19 +14,19 @@
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 '',
+ 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(45) NOT NULL default '',
- uniqueid VARCHAR(45) NOT NULL default ''
+ accountcode VARCHAR(20) NOT NULL default '',
+ uniqueid VARCHAR(32) NOT NULL default ''
);