CREATE TABLE IF NOT EXISTS `sippeers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `context` varchar(80) default NULL,
  `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib','unavailable') default 'allowed_not_screened',
  `secret` varchar(80) default NULL,
  `md5secret` varchar(80) default NULL,
  `remotesecret` varchar(250) default NULL,
  `transport` enum('tcp','udp','tcp,udp') default 'udp',
  `host` varchar(31) NOT NULL default '',
  `nat` varchar(5) NOT NULL default 'no',
  `type` enum('user','peer','friend') NOT NULL default 'friend',
  `accountcode` varchar(20) default NULL,
  `amaflags` varchar(13) default NULL,
  `callgroup` varchar(10) default NULL,
  `callerid` varchar(80) default NULL,
  `defaultip` varchar(15) default NULL,
  `dtmfmode` varchar(7) default NULL,
  `fromuser` varchar(80) default NULL,
  `fromdomain` varchar(80) default NULL,
  `insecure` varchar(4) default NULL,
  `language` char(2) default NULL,
  `mailbox` varchar(50) default NULL,
  `pickupgroup` varchar(10) default NULL,
  `rtcachefriends` char(3) default NULL,
  `regexten` varchar(80) default NULL,
  `rtptimeout` char(3) default NULL,
  `rtpholdtimeout` char(3) default NULL,
  `setvar` varchar(100) default NULL,
  `disallow` varchar(100) default 'all',
  `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
  `fullcontact` varchar(80) NOT NULL default '',
  `ipaddr` varchar(15) NOT NULL default '',
  `port` smallint(5) unsigned NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `defaultuser` varchar(80) NOT NULL default '',
  `subscribecontext` varchar(80) default NULL,
  `directmedia` enum('yes','no') default NULL,
  `trustrpid` enum('yes','no') default NULL,
  `sendrpid` enum('yes','no') default NULL,
  `progressinband` enum('never','yes','no') default NULL,
  `promiscredir` enum('yes','no') default NULL,
  `useclientcode` enum('yes','no') default NULL,
  `callcounter` enum('yes','no') default NULL,
  `busylevel` int(10) unsigned default NULL,
  `allowoverlap` enum('yes','no') default 'yes',
  `allowsubscribe` enum('yes','no') default 'yes',
  `allowtransfer` enum('yes','no') default 'yes',
  `ignoresdpversion` enum('yes','no') default 'no',
  `template` varchar(100) default NULL,
  `mask` varchar(100) default NULL,
  `videosupport` enum('yes','no','always') default 'no',
  `maxcallbitrate` int(10) unsigned default NULL,
  `rfc2833compensate` enum('yes','no') default 'yes',
  `session-timers` enum('originate','accept','refuse') default 'accept',
  `session-expires` int(5) unsigned default '1800',
  `session-minse` int(5) unsigned default '90',
  `session-refresher` enum('uac','uas') default 'uas',
  `t38pt_usertpsource` enum('yes','no') default NULL,
  `outboundproxy` varchar(250) default NULL,
  `callbackextension` varchar(250) default NULL,
  `registertrying` enum('yes','no') default 'yes',
  `timert1` int(5) unsigned default '500',
  `timerb` int(8) unsigned default NULL,
  `qualifyfreq` int(5) unsigned default '120',
  `contactpermit` varchar(250) default NULL,
  `contactdeny` varchar(250) default NULL,
  `lastms` int(11) NOT NULL,
  `canreinvite` enum('yes','no') NOT NULL default 'no',
  `tos_sip` varchar(10) NOT NULL,
  `tos_audio` varchar(10) NOT NULL,
  `tos_video` varchar(11) NOT NULL,
  `call-limit` int(11) NOT NULL default '2',
  `regserver` varchar(10) NOT NULL,
  `regseconds` varchar(10) NOT NULL,
  `useragent` varchar(45) NOT NULL,
  `tos` varchar(11) NOT NULL default 'ef',
  `deny` varchar(90) NOT NULL,
  `permit` varchar(90) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=598 ;