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(# );
NOTICE:  CREATE TABLE will create implicit sequence "asterisk_cdr_acctid_seq" fo                                                                             r serial column "asterisk_cdr.acctid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asterisk_cdr_pke                                                                             y" for table "asterisk_cdr"
CREATE TABLE
asterisk=#