--
-- Table structure for table `sippeers`
--

DROP TABLE IF EXISTS `sippeers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sippeers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `host` varchar(15) NOT NULL default 'dynamic',
  `context` varchar(80) NOT NULL default 'forbidden',
  `insecure` varchar(15) NOT NULL default 'no',
  `ipaddr` varchar(15) default NULL,
  `port` smallint(5) unsigned default NULL,
  `regseconds` int(11) default NULL,
  `username` varchar(80) default NULL,
  `md5secret` varchar(32) default NULL,
  `nat` varchar(15) default 'yes',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ;

--
-- Table structure for table `sipusers`
--

DROP TABLE IF EXISTS `sipusers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sipusers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `context` varchar(80) NOT NULL default 'fromaccount',
  `md5secret` varchar(32) default NULL,
  `nat` varchar(15) default 'yes',
  `deny` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ;
