rendered paste bodyCREATE TABLE voicemessages
(
id int4 NOT NULL DEFAULT nextval('tb_voicemail_messages_id_seq'::regclass),
msgnum int4,
dir varchar(80),
context varchar(80),
macrocontext varchar(80),
callerid varchar(40),
origtime varchar(40),
duration varchar(20),
mailboxuser varchar(80),
mailboxcontext varchar(80),
recording oid,
label varchar(30),
"read" bool DEFAULT false,
sip_id int4,
pabx_id int4,
iax_id int4,
CONSTRAINT voicemessages_pk PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE voicemessages OWNER TO postgres;