All pastes #966331 Raw Edit

Stuff

public text v1 · immutable
·published 2008-04-01 17:54 UTC
rendered paste body
asterisk=# CREATE TABLE asterisk_cdr (
asterisk(# AcctId BIGSERIAL PRIMARY KEY,
asterisk(# calldate TIMESTAMP with time zone NOT NULL DEFAULT now(),
asterisk(# clid VARCHAR(80) NOT NULL default .,
asterisk(# src VARCHAR(80) NOT NULL default .,
asterisk(# dst VARCHAR(80) NOT NULL default .,
asterisk(# dcontext VARCHAR(80) NOT NULL default .,
asterisk(# channel VARCHAR(80) NOT NULL default .,
asterisk(# dstchannel VARCHAR(80) NOT NULL default .,
asterisk(# lastapp VARCHAR(80) NOT NULL default .,
asterisk(# lastdata VARCHAR(80) NOT NULL default .,
asterisk(# duration INTEGER NOT NULL default .0.,
asterisk(# billsec INTEGER NOT NULL default .0.,
asterisk(# disposition VARCHAR(45) NOT NULL default .,
asterisk(# amaflags INTEGER NOT NULL default .0.,
asterisk(# accountcode VARCHAR(20) NOT NULL default .,
asterisk(# uniqueid VARCHAR(32) NOT NULL default .,
asterisk(# userfield VARCHAR(255) NOT NULL default .
asterisk(# );
ERROR:  syntax error at or near "." at character 151
LINE 4: clid VARCHAR(80) NOT NULL default .,