diff options
author | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2003-12-02 23:42:39 +0000 |
---|---|---|
committer | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2003-12-02 23:42:39 +0000 |
commit | 3c5c0a609e123190db474dc18aabaf4aa80b5523 (patch) | |
tree | 3c79e362dd8169054fa405e7b434c3217ad403dc /contrib | |
parent | c4f2be53f82132909cde080408af68f9601dd0d9 (diff) |
Fix SQL description for longer channels
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@1815 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
-rwxr-xr-x | contrib/scripts/postgres_cdr.sql | 20 |
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 '' ); |