CREATE TABLE `sipusers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `accountcode` varchar(20) default NULL,
  `amaflags` varchar(13) default NULL,
  `callgroup` varchar(10) default NULL,
  `callerid` varchar(80) default NULL,
  `canreinvite` char(3) default 'no',
  `context` varchar(80) NOT NULL default 'from_backoffice',
  `defaultip` varchar(15) default NULL,
  `dtmfmode` varchar(7) NOT NULL default 'rfc2833',
  `fromuser` varchar(80) default NULL,
  `fromdomain` varchar(80) default NULL,
  `fullcontact` varchar(80) default NULL,
  `host` varchar(31) NOT NULL default 'dynamic',
  `insecure` varchar(4) default NULL,
  `language` char(2) default NULL,
  `mailbox` varchar(50) default NULL,
  `md5secret` varchar(80) default NULL,
  `nat` varchar(5) NOT NULL default 'no',
  `deny` varchar(95) default NULL,
  `permit` varchar(95) default NULL,
  `mask` varchar(95) default NULL,
  `pickupgroup` varchar(10) default NULL,
  `call-limit` varchar(5) default NULL,
  `port` varchar(5) NOT NULL default '',
  `qualify` char(3) NOT NULL default '300',
  `restrictcid` char(1) default NULL,
  `rtptimeout` char(3) default NULL,
  `rtpholdtimeout` char(3) default NULL,
  `secret` varchar(80) default NULL,
  `type` varchar(6) NOT NULL default 'friend',
  `username` varchar(80) NOT NULL default '',
  `disallow` varchar(100) default 'all',
  `allow` varchar(100) default 'ulaw',
  `musiconhold` varchar(100) default NULL,
  `regseconds` int(11) NOT NULL default '0',
  `ipaddr` varchar(15) NOT NULL default '',
  `regexten` varchar(80) NOT NULL default '',
  `cancallforward` char(3) default 'yes',
  `setvar` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=66 ;

-- 
-- Dumping data for table `sipusers`
-- 

INSERT INTO `sipusers` (`id`, `name`, `accountcode`, `amaflags`, `callgroup`, `callerid`, `canreinvite`, `context`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `fullcontact`, `host`, `insecure`, `language`, `mailbox`, `md5secret`, `nat`, `deny`, `permit`, `mask`, `pickupgroup`, `call-limit`, `port`, `qualify`, `restrictcid`, `rtptimeout`, `rtpholdtimeout`, `secret`, `type`, `username`, `disallow`, `allow`, `musiconhold`, `regseconds`, `ipaddr`, `regexten`, `cancallforward`, `setvar`) VALUES 
(1, '337', NULL, NULL, '1', 'Clive Mowers', 'no', 'from_agents', NULL, 'rfc2833', NULL, NULL, 'sip:337@10.2.2.218:2063;line=2zlsu13g', 'dynamic', NULL, NULL, NULL, NULL, 'no', NULL, NULL, NULL, '1', NULL, '2063', '300', NULL, NULL, NULL, NULL, 'friend', '337', 'all', 'alaw;ulaw', NULL, 1174399006, '10.2.2.218', '', 'yes', ''),
(2, '308', NULL, NULL, '1', 'Allan Thomas', 'no', 'from_supervisors', NULL, 'rfc2833', NULL, NULL, 'sip:308@10.2.2.215:2066;line=zi9arbj9', 'dynamic', NULL, NULL, NULL, NULL, 'no', NULL, NULL, NULL, '1', NULL, '2066', '300', NULL, NULL, NULL, NULL, 'friend', '308', 'all', 'alaw;ulaw', NULL, 1174399002, '10.2.2.215', '', 'yes', ''),