Anonymous

public text v1 · immutable

#1676

·published 2004-10-24 04:21 UTC

CREATE TABLE `sipfriends` (
  `name` varchar(40) NOT NULL default '',
  `qualify` varchar(5) NOT NULL default '',
  `username` varchar(10) NOT NULL default '',
  `callerid` varchar(128) NOT NULL default '',
  `secret` varchar(40) NOT NULL default '',
  `type` varchar(25) NOT NULL default '',
  `context` varchar(40) NOT NULL default '',
  `host` varchar(25) NOT NULL default '',
  `ipaddr` varchar(20) NOT NULL default '',
  `port` int(6) NOT NULL default '0',
  `regseconds` int(11) NOT NULL default '0',
  `accountcode` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;