CREATE TABLE IF NOT EXISTS `voicemail_data` (
  `filename` varchar(255) NOT NULL,
  `origmailbox` varchar(80) DEFAULT NULL,
  `context` varchar(80) DEFAULT NULL,
  `macrocontext` varchar(80) DEFAULT NULL,
  `exten` varchar(80) DEFAULT NULL,
  `priority` varchar(80) DEFAULT '0',
  `callerchan` varchar(100) DEFAULT NULL,
  `callerid` varchar(80) DEFAULT NULL,
  `origdate` varchar(30) DEFAULT NULL,
  `origtime` varchar(80) DEFAULT NULL,
  `category` varchar(30) NOT NULL DEFAULT '''''',
  `duration` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `voicemail_data`
  ADD PRIMARY KEY (`filename`);