diff options
Diffstat (limited to 'contrib/scripts/postgres_cdr.sql')
-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 '' ); |