CREATE TABLE `voicemails` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL default '0',
  `context` varchar(50) NOT NULL default 'default',
  `mailbox` varchar(20) NOT NULL default '0',
  `password` int(4) NOT NULL default '1234',
  `fullname` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `pager` varchar(50) NOT NULL default '',
  `options` varchar(100) NOT NULL default '',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`uniqueid`),
  KEY `mailbox_context` (`mailbox`,`context`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


CREATE TABLE `sipfriends` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `username` varchar(80) NOT NULL default '',
  `context` varchar(80) default 'default',
  `secret` varchar(80) default 'passwd',
  `callerid` varchar(80) default NULL,
  `musiconhold` varchar(100) default 'default',
  `accountcode` varchar(20) default NULL,
  `mailbox` varchar(50) default NULL,
  `host` varchar(31) NOT NULL default 'dynamic',
  `qualify` char(3) default 'yes',
  `outboundproxy` varchar(31) NOT NULL default '',
  `fromdomain` varchar(80) default NULL,
  `fromuser` varchar(80) default NULL,
  `type` varchar(6) NOT NULL default 'friend',
  `regexten` varchar(80) default NULL,
  `usereqphone` char(3) default 'no',
  `defaultip` varchar(15) default NULL,
  `disallow` varchar(100) default NULL,
  `allow` varchar(100) default 'g723.1;g729;ulaw;alaw;gsm',
  `rtptimeout` char(3) default '60',
  `rtpholdtimeout` char(3) default '300',
  `incominglimit` char(2) default NULL,
  `outgoinglimit` char(2) default NULL,
  `md5secret` varchar(80) default NULL,
  `callgroup` varchar(10) default NULL,
  `pickupgroup` varchar(10) default NULL,
  `canreinvite` char(3) default 'yes',
  `dtmfmode` varchar(7) default 'rfc2833',
  `insecure` varchar(4) default NULL,
  `nat` char(3) NOT NULL default 'yes',
  `mask` varchar(95) default NULL,
  `restrictcid` char(1) default NULL,
  `cancallforward` char(3) default 'yes',
  `language` char(2) default 'en',
  `amaflags` varchar(7) default NULL,
  `regseconds` int(11) NOT NULL default '0',
  `bindport` varchar(5) NOT NULL default '',
  `port` varchar(5) NOT NULL default '',
  `ipaddr` varchar(15) NOT NULL default '',
  `permit` varchar(95) default NULL,
  `deny` varchar(95) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


CREATE TABLE `iaxfriends` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `secret` varchar(80) default 'passwd',
  `mailbox` varchar(80) default NULL,
  `mailboxdetail` varchar(8) NOT NULL default 'yes',
  `context` varchar(80) NOT NULL default 'default',
  `username` varchar(80) NOT NULL default '',
  `callerid` varchar(50) default NULL,
  `type` varchar(10) NOT NULL default 'friend',
  `trunk` varchar(8) NOT NULL default 'no',
  `auth` varchar(30) NOT NULL default 'plaintext',
  `encryption` varchar(30) NOT NULL default 'no',
  `notransfer` varchar(8) NOT NULL default 'no',
  `jitterbuffer` varchar(8) NOT NULL default 'yes',
  `host` varchar(31) NOT NULL default 'dynamic',
  `permit` varchar(95) default NULL,
  `deny` varchar(95) default NULL,
  `regexten` varchar(80) default NULL,
  `peercontext` varchar(80) default NULL,
  `allow` varchar(100) default 'g729;g723.1;ulaw;alaw;gsm',
  `disallow` varchar(100) default NULL,
  `sendani` varchar(8) NOT NULL default 'no',
  `inkeys` varchar(30) default NULL,
  `outkey` varchar(30) default NULL,
  `qualify` varchar(8) NOT NULL default 'no',
  `accountcode` varchar(20) default NULL,
  `regseconds` int(11) NOT NULL default '0',
  `language` char(2) default NULL,
  `amaflags` char(1) default NULL,
  `ipaddr` varchar(15) NOT NULL default '',
  `port` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`uniqueid`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;