CREATE 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;