Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i486)
- --
- -- Host: localhost Database: opensips
- -- ------------------------------------------------------
- -- Server version 5.1.49-3
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `acc`
- --
- DROP TABLE IF EXISTS `acc`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `acc` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `method` char(16) NOT NULL DEFAULT '',
- `from_tag` char(64) NOT NULL DEFAULT '',
- `to_tag` char(64) NOT NULL DEFAULT '',
- `callid` char(64) NOT NULL DEFAULT '',
- `sip_code` char(3) NOT NULL DEFAULT '',
- `sip_reason` char(32) NOT NULL DEFAULT '',
- `time` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `callid_idx` (`callid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `acc`
- --
- LOCK TABLES `acc` WRITE;
- /*!40000 ALTER TABLE `acc` DISABLE KEYS */;
- /*!40000 ALTER TABLE `acc` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `active_watchers`
- --
- DROP TABLE IF EXISTS `active_watchers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `active_watchers` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `presentity_uri` char(128) NOT NULL,
- `watcher_username` char(64) NOT NULL,
- `watcher_domain` char(64) NOT NULL,
- `to_user` char(64) NOT NULL,
- `to_domain` char(64) NOT NULL,
- `event` char(64) NOT NULL DEFAULT 'presence',
- `event_id` char(64) DEFAULT NULL,
- `to_tag` char(64) NOT NULL,
- `from_tag` char(64) NOT NULL,
- `callid` char(64) NOT NULL,
- `local_cseq` int(11) NOT NULL,
- `remote_cseq` int(11) NOT NULL,
- `contact` char(128) NOT NULL,
- `record_route` text,
- `expires` int(11) NOT NULL,
- `status` int(11) NOT NULL DEFAULT '2',
- `reason` char(64) NOT NULL,
- `version` int(11) NOT NULL DEFAULT '0',
- `socket_info` char(64) NOT NULL,
- `local_contact` char(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `active_watchers_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `active_watchers`
- --
- LOCK TABLES `active_watchers` WRITE;
- /*!40000 ALTER TABLE `active_watchers` DISABLE KEYS */;
- INSERT INTO `active_watchers` VALUES (4,'sip:kliensip3@apenksips.com','kliensip3','apenksips.com','kliensip3','apenksips.com','presence.winfo','','233b1bc6af3821ad79e1194f1e7de761-149f','a7345529','d96d4195122ae39c68eb4fe0f249c31b@0:0:0:0:0:0:0:0',1,2,'sip:kliensip3@192.168.26.1:5060;transport=udp;registering_acc=apenksips_com','',1334034943,1,'',1,'udp:192.168.26.5:5060','sip:192.168.26.5:5090');
- /*!40000 ALTER TABLE `active_watchers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `address`
- --
- DROP TABLE IF EXISTS `address`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `address` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `grp` smallint(5) unsigned NOT NULL DEFAULT '0',
- `ip` char(50) NOT NULL,
- `mask` tinyint(4) NOT NULL DEFAULT '32',
- `port` smallint(5) unsigned NOT NULL DEFAULT '0',
- `proto` char(4) NOT NULL DEFAULT 'any',
- `pattern` char(64) DEFAULT NULL,
- `context_info` char(32) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `address`
- --
- LOCK TABLES `address` WRITE;
- /*!40000 ALTER TABLE `address` DISABLE KEYS */;
- /*!40000 ALTER TABLE `address` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `aliases`
- --
- DROP TABLE IF EXISTS `aliases`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `aliases` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) DEFAULT NULL,
- `contact` char(255) NOT NULL DEFAULT '',
- `received` char(128) DEFAULT NULL,
- `path` char(128) DEFAULT NULL,
- `expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',
- `q` float(10,2) NOT NULL DEFAULT '1.00',
- `callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',
- `cseq` int(11) NOT NULL DEFAULT '13',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- `flags` int(11) NOT NULL DEFAULT '0',
- `cflags` int(11) NOT NULL DEFAULT '0',
- `user_agent` char(255) NOT NULL DEFAULT '',
- `socket` char(64) DEFAULT NULL,
- `methods` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `alias_idx` (`username`,`domain`,`contact`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `aliases`
- --
- LOCK TABLES `aliases` WRITE;
- /*!40000 ALTER TABLE `aliases` DISABLE KEYS */;
- /*!40000 ALTER TABLE `aliases` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `carrierfailureroute`
- --
- DROP TABLE IF EXISTS `carrierfailureroute`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `carrierfailureroute` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `carrier` int(10) unsigned NOT NULL DEFAULT '0',
- `domain` char(64) NOT NULL DEFAULT '',
- `scan_prefix` char(64) NOT NULL DEFAULT '',
- `host_name` char(128) NOT NULL DEFAULT '',
- `reply_code` char(3) NOT NULL DEFAULT '',
- `flags` int(11) unsigned NOT NULL DEFAULT '0',
- `mask` int(11) unsigned NOT NULL DEFAULT '0',
- `next_domain` char(64) NOT NULL DEFAULT '',
- `description` char(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `carrierfailureroute`
- --
- LOCK TABLES `carrierfailureroute` WRITE;
- /*!40000 ALTER TABLE `carrierfailureroute` DISABLE KEYS */;
- /*!40000 ALTER TABLE `carrierfailureroute` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `carrierroute`
- --
- DROP TABLE IF EXISTS `carrierroute`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `carrierroute` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `carrier` int(10) unsigned NOT NULL DEFAULT '0',
- `domain` char(64) NOT NULL DEFAULT '',
- `scan_prefix` char(64) NOT NULL DEFAULT '',
- `flags` int(11) unsigned NOT NULL DEFAULT '0',
- `mask` int(11) unsigned NOT NULL DEFAULT '0',
- `prob` float NOT NULL DEFAULT '0',
- `strip` int(11) unsigned NOT NULL DEFAULT '0',
- `rewrite_host` char(128) NOT NULL DEFAULT '',
- `rewrite_prefix` char(64) NOT NULL DEFAULT '',
- `rewrite_suffix` char(64) NOT NULL DEFAULT '',
- `description` char(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `carrierroute`
- --
- LOCK TABLES `carrierroute` WRITE;
- /*!40000 ALTER TABLE `carrierroute` DISABLE KEYS */;
- /*!40000 ALTER TABLE `carrierroute` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `cpl`
- --
- DROP TABLE IF EXISTS `cpl`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `cpl` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL,
- `domain` char(64) NOT NULL DEFAULT '',
- `cpl_xml` text,
- `cpl_bin` text,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `cpl`
- --
- LOCK TABLES `cpl` WRITE;
- /*!40000 ALTER TABLE `cpl` DISABLE KEYS */;
- /*!40000 ALTER TABLE `cpl` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dbaliases`
- --
- DROP TABLE IF EXISTS `dbaliases`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dbaliases` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `alias_username` char(64) NOT NULL DEFAULT '',
- `alias_domain` char(64) NOT NULL DEFAULT '',
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `alias_idx` (`alias_username`,`alias_domain`),
- KEY `target_idx` (`username`,`domain`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dbaliases`
- --
- LOCK TABLES `dbaliases` WRITE;
- /*!40000 ALTER TABLE `dbaliases` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dbaliases` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dialog`
- --
- DROP TABLE IF EXISTS `dialog`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dialog` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `hash_entry` int(10) unsigned NOT NULL,
- `hash_id` int(10) unsigned NOT NULL,
- `callid` char(255) NOT NULL,
- `from_uri` char(128) NOT NULL,
- `from_tag` char(64) NOT NULL,
- `to_uri` char(128) NOT NULL,
- `to_tag` char(64) NOT NULL,
- `caller_cseq` char(7) NOT NULL,
- `callee_cseq` char(7) NOT NULL,
- `caller_route_set` text,
- `callee_route_set` text,
- `caller_contact` char(128) NOT NULL,
- `callee_contact` char(128) NOT NULL,
- `caller_sock` char(64) NOT NULL,
- `callee_sock` char(64) NOT NULL,
- `state` int(10) unsigned NOT NULL,
- `start_time` int(10) unsigned NOT NULL,
- `timeout` int(10) unsigned NOT NULL,
- `vars` text,
- `profiles` text,
- `script_flags` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `hash_idx` (`hash_entry`,`hash_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dialog`
- --
- LOCK TABLES `dialog` WRITE;
- /*!40000 ALTER TABLE `dialog` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dialog` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dialplan`
- --
- DROP TABLE IF EXISTS `dialplan`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dialplan` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `dpid` int(11) NOT NULL,
- `pr` int(11) NOT NULL,
- `match_op` int(11) NOT NULL,
- `match_exp` char(64) NOT NULL,
- `match_len` int(11) NOT NULL,
- `subst_exp` char(64) NOT NULL,
- `repl_exp` char(32) NOT NULL,
- `attrs` char(32) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dialplan`
- --
- LOCK TABLES `dialplan` WRITE;
- /*!40000 ALTER TABLE `dialplan` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dialplan` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dispatcher`
- --
- DROP TABLE IF EXISTS `dispatcher`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dispatcher` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `setid` int(11) NOT NULL DEFAULT '0',
- `destination` char(192) NOT NULL DEFAULT '',
- `flags` int(11) NOT NULL DEFAULT '0',
- `weight` int(11) NOT NULL DEFAULT '1',
- `attrs` char(128) NOT NULL DEFAULT '',
- `description` char(64) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dispatcher`
- --
- LOCK TABLES `dispatcher` WRITE;
- /*!40000 ALTER TABLE `dispatcher` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dispatcher` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `domain`
- --
- DROP TABLE IF EXISTS `domain`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `domain` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `domain` char(64) NOT NULL DEFAULT '',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `domain_idx` (`domain`)
- ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `domain`
- --
- LOCK TABLES `domain` WRITE;
- /*!40000 ALTER TABLE `domain` DISABLE KEYS */;
- INSERT INTO `domain` VALUES (1,'apenksips.com','2012-04-10 00:09:34');
- /*!40000 ALTER TABLE `domain` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `domainpolicy`
- --
- DROP TABLE IF EXISTS `domainpolicy`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `domainpolicy` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `rule` char(255) NOT NULL,
- `type` char(255) NOT NULL,
- `att` char(255) DEFAULT NULL,
- `val` char(128) DEFAULT NULL,
- `description` char(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rav_idx` (`rule`,`att`,`val`),
- KEY `rule_idx` (`rule`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `domainpolicy`
- --
- LOCK TABLES `domainpolicy` WRITE;
- /*!40000 ALTER TABLE `domainpolicy` DISABLE KEYS */;
- /*!40000 ALTER TABLE `domainpolicy` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dr_gateways`
- --
- DROP TABLE IF EXISTS `dr_gateways`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dr_gateways` (
- `gwid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `type` int(11) unsigned NOT NULL DEFAULT '0',
- `address` char(128) NOT NULL,
- `strip` int(11) unsigned NOT NULL DEFAULT '0',
- `pri_prefix` char(16) DEFAULT NULL,
- `attrs` char(255) DEFAULT NULL,
- `probe_mode` int(11) unsigned NOT NULL DEFAULT '0',
- `description` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`gwid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dr_gateways`
- --
- LOCK TABLES `dr_gateways` WRITE;
- /*!40000 ALTER TABLE `dr_gateways` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dr_gateways` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dr_groups`
- --
- DROP TABLE IF EXISTS `dr_groups`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dr_groups` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL,
- `domain` char(128) NOT NULL DEFAULT '',
- `groupid` int(11) unsigned NOT NULL DEFAULT '0',
- `description` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dr_groups`
- --
- LOCK TABLES `dr_groups` WRITE;
- /*!40000 ALTER TABLE `dr_groups` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dr_groups` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dr_gw_lists`
- --
- DROP TABLE IF EXISTS `dr_gw_lists`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dr_gw_lists` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `gwlist` char(255) NOT NULL,
- `description` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dr_gw_lists`
- --
- LOCK TABLES `dr_gw_lists` WRITE;
- /*!40000 ALTER TABLE `dr_gw_lists` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dr_gw_lists` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `dr_rules`
- --
- DROP TABLE IF EXISTS `dr_rules`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dr_rules` (
- `ruleid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `groupid` char(255) NOT NULL,
- `prefix` char(64) NOT NULL,
- `timerec` char(255) NOT NULL,
- `priority` int(11) NOT NULL DEFAULT '0',
- `routeid` char(255) NOT NULL,
- `gwlist` char(255) NOT NULL,
- `description` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`ruleid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `dr_rules`
- --
- LOCK TABLES `dr_rules` WRITE;
- /*!40000 ALTER TABLE `dr_rules` DISABLE KEYS */;
- /*!40000 ALTER TABLE `dr_rules` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `globalblacklist`
- --
- DROP TABLE IF EXISTS `globalblacklist`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `globalblacklist` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `prefix` char(64) NOT NULL DEFAULT '',
- `whitelist` tinyint(1) NOT NULL DEFAULT '0',
- `description` char(255) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `globalblacklist_idx` (`prefix`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `globalblacklist`
- --
- LOCK TABLES `globalblacklist` WRITE;
- /*!40000 ALTER TABLE `globalblacklist` DISABLE KEYS */;
- /*!40000 ALTER TABLE `globalblacklist` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `grp`
- --
- DROP TABLE IF EXISTS `grp`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `grp` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `grp` char(64) NOT NULL DEFAULT '',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_group_idx` (`username`,`domain`,`grp`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `grp`
- --
- LOCK TABLES `grp` WRITE;
- /*!40000 ALTER TABLE `grp` DISABLE KEYS */;
- /*!40000 ALTER TABLE `grp` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `gw`
- --
- DROP TABLE IF EXISTS `gw`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `gw` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `gw_name` char(128) NOT NULL,
- `grp_id` int(10) unsigned NOT NULL,
- `ip_addr` char(15) NOT NULL,
- `port` smallint(5) unsigned DEFAULT NULL,
- `uri_scheme` tinyint(3) unsigned DEFAULT NULL,
- `transport` tinyint(3) unsigned DEFAULT NULL,
- `strip` tinyint(3) unsigned DEFAULT NULL,
- `tag` char(16) DEFAULT NULL,
- `flags` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `gw_name_idx` (`gw_name`),
- KEY `grp_id_idx` (`grp_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `gw`
- --
- LOCK TABLES `gw` WRITE;
- /*!40000 ALTER TABLE `gw` DISABLE KEYS */;
- /*!40000 ALTER TABLE `gw` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `imc_members`
- --
- DROP TABLE IF EXISTS `imc_members`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `imc_members` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL,
- `domain` char(64) NOT NULL,
- `room` char(64) NOT NULL,
- `flag` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_room_idx` (`username`,`domain`,`room`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `imc_members`
- --
- LOCK TABLES `imc_members` WRITE;
- /*!40000 ALTER TABLE `imc_members` DISABLE KEYS */;
- /*!40000 ALTER TABLE `imc_members` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `imc_rooms`
- --
- DROP TABLE IF EXISTS `imc_rooms`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `imc_rooms` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` char(64) NOT NULL,
- `domain` char(64) NOT NULL,
- `flag` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name_domain_idx` (`name`,`domain`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `imc_rooms`
- --
- LOCK TABLES `imc_rooms` WRITE;
- /*!40000 ALTER TABLE `imc_rooms` DISABLE KEYS */;
- /*!40000 ALTER TABLE `imc_rooms` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `lcr`
- --
- DROP TABLE IF EXISTS `lcr`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lcr` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `prefix` char(16) DEFAULT NULL,
- `from_uri` char(64) DEFAULT NULL,
- `grp_id` int(10) unsigned NOT NULL,
- `priority` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- KEY `prefix_idx` (`prefix`),
- KEY `from_uri_idx` (`from_uri`),
- KEY `grp_id_idx` (`grp_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `lcr`
- --
- LOCK TABLES `lcr` WRITE;
- /*!40000 ALTER TABLE `lcr` DISABLE KEYS */;
- /*!40000 ALTER TABLE `lcr` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `load_balancer`
- --
- DROP TABLE IF EXISTS `load_balancer`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `load_balancer` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `group_id` int(11) unsigned NOT NULL DEFAULT '0',
- `dst_uri` char(128) NOT NULL,
- `resources` char(255) NOT NULL,
- `probe_mode` int(11) unsigned NOT NULL DEFAULT '0',
- `description` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `dsturi_idx` (`dst_uri`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `load_balancer`
- --
- LOCK TABLES `load_balancer` WRITE;
- /*!40000 ALTER TABLE `load_balancer` DISABLE KEYS */;
- /*!40000 ALTER TABLE `load_balancer` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `location`
- --
- DROP TABLE IF EXISTS `location`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `location` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) DEFAULT NULL,
- `contact` char(255) NOT NULL DEFAULT '',
- `received` char(128) DEFAULT NULL,
- `path` char(128) DEFAULT NULL,
- `expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',
- `q` float(10,2) NOT NULL DEFAULT '1.00',
- `callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',
- `cseq` int(11) NOT NULL DEFAULT '13',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- `flags` int(11) NOT NULL DEFAULT '0',
- `cflags` int(11) NOT NULL DEFAULT '0',
- `user_agent` char(255) NOT NULL DEFAULT '',
- `socket` char(64) DEFAULT NULL,
- `methods` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `account_contact_idx` (`username`,`domain`,`contact`)
- ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `location`
- --
- LOCK TABLES `location` WRITE;
- /*!40000 ALTER TABLE `location` DISABLE KEYS */;
- INSERT INTO `location` VALUES (3,'kliensip1','apenksips.com','sip:kliensip1@192.168.27.5:35129;transport=udp','sip:192.168.26.1:35129',NULL,'2012-04-10 01:23:12',-1.00,'998135189522@192.168.27.5',2,'2012-04-10 00:23:12',0,192,'Sipdroid/2.5 beta/GT-S5570L','udp:192.168.26.5:5060',NULL),(2,'kliensip3','apenksips.com','sip:kliensip3@192.168.27.4:5060;transport=udp;registering_acc=apenksips_com','sip:192.168.26.1:5060',NULL,'2012-04-10 00:35:15',-1.00,'05beba61739421516d217b03ade25eea@0:0:0:0:0:0:0:0',4,'2012-04-10 00:25:15',0,192,'Jitsi1.0-beta1-nightly.build.3820Linux','udp:192.168.26.5:5060',NULL),(4,'kliensip1','apenksips.com','sip:kliensip1@192.168.27.5:47841;transport=udp','sip:192.168.26.1:47841',NULL,'2012-04-10 01:26:48',-1.00,'027200649125@192.168.27.5',2,'2012-04-10 00:26:48',0,192,'Sipdroid/2.5 beta/GT-S5570L','udp:192.168.26.5:5060',NULL),(5,'kliensip1','apenksips.com','sip:kliensip1@192.168.27.5:53993;transport=udp','sip:192.168.26.1:53993',NULL,'2012-04-10 01:27:02',-1.00,'145001129960@192.168.27.5',2,'2012-04-10 00:27:02',0,192,'Sipdroid/2.5 beta/GT-S5570L','udp:192.168.26.5:5060',NULL);
- /*!40000 ALTER TABLE `location` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `missed_calls`
- --
- DROP TABLE IF EXISTS `missed_calls`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `missed_calls` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `method` char(16) NOT NULL DEFAULT '',
- `from_tag` char(64) NOT NULL DEFAULT '',
- `to_tag` char(64) NOT NULL DEFAULT '',
- `callid` char(64) NOT NULL DEFAULT '',
- `sip_code` char(3) NOT NULL DEFAULT '',
- `sip_reason` char(32) NOT NULL DEFAULT '',
- `time` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `callid_idx` (`callid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `missed_calls`
- --
- LOCK TABLES `missed_calls` WRITE;
- /*!40000 ALTER TABLE `missed_calls` DISABLE KEYS */;
- /*!40000 ALTER TABLE `missed_calls` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `nh_sockets`
- --
- DROP TABLE IF EXISTS `nh_sockets`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `nh_sockets` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `rtpproxy_sock` text NOT NULL,
- `set_id` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `nh_sockets`
- --
- LOCK TABLES `nh_sockets` WRITE;
- /*!40000 ALTER TABLE `nh_sockets` DISABLE KEYS */;
- INSERT INTO `nh_sockets` VALUES (1,'udp:127.0.0.1:7890',0);
- /*!40000 ALTER TABLE `nh_sockets` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `pdt`
- --
- DROP TABLE IF EXISTS `pdt`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `pdt` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `sdomain` char(128) NOT NULL,
- `prefix` char(32) NOT NULL,
- `domain` char(128) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `sdomain_prefix_idx` (`sdomain`,`prefix`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `pdt`
- --
- LOCK TABLES `pdt` WRITE;
- /*!40000 ALTER TABLE `pdt` DISABLE KEYS */;
- /*!40000 ALTER TABLE `pdt` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `presentity`
- --
- DROP TABLE IF EXISTS `presentity`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `presentity` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL,
- `domain` char(64) NOT NULL,
- `event` char(64) NOT NULL,
- `etag` char(64) NOT NULL,
- `expires` int(11) NOT NULL,
- `received_time` int(11) NOT NULL,
- `body` blob NOT NULL,
- `sender` char(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `presentity_idx` (`username`,`domain`,`event`,`etag`)
- ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `presentity`
- --
- LOCK TABLES `presentity` WRITE;
- /*!40000 ALTER TABLE `presentity` DISABLE KEYS */;
- INSERT INTO `presentity` VALUES (1,'kliensip3','apenksips.com','presence','a.1334030743.13963.3.0',1334034943,1334031343,'<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?><presence xmlns=\"urn:ietf:params:xml:ns:pidf\" xmlns:dm=\"urn:ietf:params:xml:ns:pidf:data-model\" xmlns:rpid=\"urn:ietf:params:xml:ns:pidf:rpid\" entity=\"sip:kliensip3@apenksips.com\"><dm:person id=\"p748\"><rpid:activities/></dm:person><tuple id=\"t9359\"><status><basic>open</basic></status><contact>sip:kliensip3@apenksips.com</contact><note>Online</note></tuple></presence>','');
- /*!40000 ALTER TABLE `presentity` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `pua`
- --
- DROP TABLE IF EXISTS `pua`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `pua` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `pres_uri` char(128) NOT NULL,
- `pres_id` char(255) NOT NULL,
- `event` int(11) NOT NULL,
- `expires` int(11) NOT NULL,
- `desired_expires` int(11) NOT NULL,
- `flag` int(11) NOT NULL,
- `etag` char(64) DEFAULT NULL,
- `tuple_id` char(64) DEFAULT NULL,
- `watcher_uri` char(128) DEFAULT NULL,
- `to_uri` char(128) DEFAULT NULL,
- `call_id` char(64) DEFAULT NULL,
- `to_tag` char(64) DEFAULT NULL,
- `from_tag` char(64) DEFAULT NULL,
- `cseq` int(11) DEFAULT NULL,
- `record_route` text,
- `contact` char(128) DEFAULT NULL,
- `remote_contact` char(128) DEFAULT NULL,
- `version` int(11) DEFAULT NULL,
- `extra_headers` text,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `pua`
- --
- LOCK TABLES `pua` WRITE;
- /*!40000 ALTER TABLE `pua` DISABLE KEYS */;
- /*!40000 ALTER TABLE `pua` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `re_grp`
- --
- DROP TABLE IF EXISTS `re_grp`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `re_grp` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `reg_exp` char(128) NOT NULL DEFAULT '',
- `group_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `group_idx` (`group_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `re_grp`
- --
- LOCK TABLES `re_grp` WRITE;
- /*!40000 ALTER TABLE `re_grp` DISABLE KEYS */;
- /*!40000 ALTER TABLE `re_grp` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `rls_presentity`
- --
- DROP TABLE IF EXISTS `rls_presentity`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `rls_presentity` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `rlsubs_did` char(255) NOT NULL,
- `resource_uri` char(128) NOT NULL,
- `content_type` char(255) NOT NULL,
- `presence_state` blob NOT NULL,
- `expires` int(11) NOT NULL,
- `updated` int(11) NOT NULL,
- `auth_state` int(11) NOT NULL,
- `reason` char(64) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rls_presentity_idx` (`rlsubs_did`,`resource_uri`),
- KEY `updated_idx` (`updated`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `rls_presentity`
- --
- LOCK TABLES `rls_presentity` WRITE;
- /*!40000 ALTER TABLE `rls_presentity` DISABLE KEYS */;
- /*!40000 ALTER TABLE `rls_presentity` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `rls_watchers`
- --
- DROP TABLE IF EXISTS `rls_watchers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `rls_watchers` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `presentity_uri` char(128) NOT NULL,
- `to_user` char(64) NOT NULL,
- `to_domain` char(64) NOT NULL,
- `watcher_username` char(64) NOT NULL,
- `watcher_domain` char(64) NOT NULL,
- `event` char(64) NOT NULL DEFAULT 'presence',
- `event_id` char(64) DEFAULT NULL,
- `to_tag` char(64) NOT NULL,
- `from_tag` char(64) NOT NULL,
- `callid` char(64) NOT NULL,
- `local_cseq` int(11) NOT NULL,
- `remote_cseq` int(11) NOT NULL,
- `contact` char(64) NOT NULL,
- `record_route` text,
- `expires` int(11) NOT NULL,
- `status` int(11) NOT NULL DEFAULT '2',
- `reason` char(64) NOT NULL,
- `version` int(11) NOT NULL DEFAULT '0',
- `socket_info` char(64) NOT NULL,
- `local_contact` char(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rls_watcher_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `rls_watchers`
- --
- LOCK TABLES `rls_watchers` WRITE;
- /*!40000 ALTER TABLE `rls_watchers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `rls_watchers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `route_tree`
- --
- DROP TABLE IF EXISTS `route_tree`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `route_tree` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `carrier` char(64) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `route_tree`
- --
- LOCK TABLES `route_tree` WRITE;
- /*!40000 ALTER TABLE `route_tree` DISABLE KEYS */;
- /*!40000 ALTER TABLE `route_tree` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `silo`
- --
- DROP TABLE IF EXISTS `silo`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `silo` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `src_addr` char(128) NOT NULL DEFAULT '',
- `dst_addr` char(128) NOT NULL DEFAULT '',
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `inc_time` int(11) NOT NULL DEFAULT '0',
- `exp_time` int(11) NOT NULL DEFAULT '0',
- `snd_time` int(11) NOT NULL DEFAULT '0',
- `ctype` char(32) NOT NULL DEFAULT 'text/plain',
- `body` blob NOT NULL,
- PRIMARY KEY (`id`),
- KEY `account_idx` (`username`,`domain`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `silo`
- --
- LOCK TABLES `silo` WRITE;
- /*!40000 ALTER TABLE `silo` DISABLE KEYS */;
- /*!40000 ALTER TABLE `silo` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `sip_trace`
- --
- DROP TABLE IF EXISTS `sip_trace`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `sip_trace` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- `callid` char(255) NOT NULL DEFAULT '',
- `traced_user` char(128) DEFAULT NULL,
- `msg` text NOT NULL,
- `method` char(32) NOT NULL DEFAULT '',
- `status` char(128) DEFAULT NULL,
- `fromip` char(50) NOT NULL DEFAULT '',
- `toip` char(50) NOT NULL DEFAULT '',
- `fromtag` char(64) NOT NULL DEFAULT '',
- `direction` char(4) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `traced_user_idx` (`traced_user`),
- KEY `date_idx` (`time_stamp`),
- KEY `fromip_idx` (`fromip`),
- KEY `callid_idx` (`callid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `sip_trace`
- --
- LOCK TABLES `sip_trace` WRITE;
- /*!40000 ALTER TABLE `sip_trace` DISABLE KEYS */;
- /*!40000 ALTER TABLE `sip_trace` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `speed_dial`
- --
- DROP TABLE IF EXISTS `speed_dial`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `speed_dial` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `sd_username` char(64) NOT NULL DEFAULT '',
- `sd_domain` char(64) NOT NULL DEFAULT '',
- `new_uri` char(128) NOT NULL DEFAULT '',
- `fname` char(64) NOT NULL DEFAULT '',
- `lname` char(64) NOT NULL DEFAULT '',
- `description` char(64) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `speed_dial_idx` (`username`,`domain`,`sd_domain`,`sd_username`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `speed_dial`
- --
- LOCK TABLES `speed_dial` WRITE;
- /*!40000 ALTER TABLE `speed_dial` DISABLE KEYS */;
- /*!40000 ALTER TABLE `speed_dial` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `subscriber`
- --
- DROP TABLE IF EXISTS `subscriber`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `subscriber` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `password` char(25) NOT NULL DEFAULT '',
- `email_address` char(64) NOT NULL DEFAULT '',
- `ha1` char(64) NOT NULL DEFAULT '',
- `ha1b` char(64) NOT NULL DEFAULT '',
- `rpid` char(64) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`),
- KEY `username_idx` (`username`)
- ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `subscriber`
- --
- LOCK TABLES `subscriber` WRITE;
- /*!40000 ALTER TABLE `subscriber` DISABLE KEYS */;
- INSERT INTO `subscriber` VALUES (1,'kliensip1','apenksips.com','kliensip1pw','','e646cdaa128822f664897d6d94764d85','a9fc5b7165e244c17be09fae95eaf5bd',NULL),(2,'kliensip2','apenksips.com','kliensip2pw','','f209d3c0d12de525ef9d315db6f6641a','168d6cb7ee48b8192d9f142c63b54d84',NULL),(3,'kliensip3','apenksips.com','kliensip3pw','','47ad2b6ed1d22d4ba21ef1b17e978862','47790d97a7a345092adb51dbb577c961',NULL);
- /*!40000 ALTER TABLE `subscriber` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `uri`
- --
- DROP TABLE IF EXISTS `uri`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `uri` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `uri_user` char(64) NOT NULL DEFAULT '',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`,`uri_user`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `uri`
- --
- LOCK TABLES `uri` WRITE;
- /*!40000 ALTER TABLE `uri` DISABLE KEYS */;
- /*!40000 ALTER TABLE `uri` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `userblacklist`
- --
- DROP TABLE IF EXISTS `userblacklist`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `userblacklist` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL DEFAULT '',
- `domain` char(64) NOT NULL DEFAULT '',
- `prefix` char(64) NOT NULL DEFAULT '',
- `whitelist` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `userblacklist_idx` (`username`,`domain`,`prefix`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `userblacklist`
- --
- LOCK TABLES `userblacklist` WRITE;
- /*!40000 ALTER TABLE `userblacklist` DISABLE KEYS */;
- /*!40000 ALTER TABLE `userblacklist` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `usr_preferences`
- --
- DROP TABLE IF EXISTS `usr_preferences`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `usr_preferences` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `uuid` char(64) NOT NULL DEFAULT '',
- `username` char(128) NOT NULL DEFAULT '0',
- `domain` char(64) NOT NULL DEFAULT '',
- `attribute` char(32) NOT NULL DEFAULT '',
- `type` int(11) NOT NULL DEFAULT '0',
- `value` char(128) NOT NULL DEFAULT '',
- `last_modified` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- KEY `ua_idx` (`uuid`,`attribute`),
- KEY `uda_idx` (`username`,`domain`,`attribute`),
- KEY `value_idx` (`value`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `usr_preferences`
- --
- LOCK TABLES `usr_preferences` WRITE;
- /*!40000 ALTER TABLE `usr_preferences` DISABLE KEYS */;
- /*!40000 ALTER TABLE `usr_preferences` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `version`
- --
- DROP TABLE IF EXISTS `version`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `version` (
- `table_name` char(32) NOT NULL,
- `table_version` int(10) unsigned NOT NULL DEFAULT '0',
- UNIQUE KEY `t_name_idx` (`table_name`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `version`
- --
- LOCK TABLES `version` WRITE;
- /*!40000 ALTER TABLE `version` DISABLE KEYS */;
- INSERT INTO `version` VALUES ('acc',5),('missed_calls',4),('gw',8),('lcr',3),('domain',2),('grp',3),('re_grp',2),('address',5),('aliases',1005),('location',1005),('silo',6),('dbaliases',2),('uri',2),('nh_sockets',0),('speed_dial',3),('usr_preferences',3),('subscriber',7),('pdt',2),('dialog',4),('dispatcher',4),('dialplan',2),('dr_gateways',4),('dr_rules',3),('dr_gw_lists',1),('dr_groups',2),('load_balancer',2),('presentity',4),('active_watchers',10),('watchers',4),('xcap',4),('pua',8),('rls_presentity',1),('rls_watchers',2),('imc_rooms',2),('imc_members',2),('cpl',2),('sip_trace',3),('domainpolicy',3),('carrierroute',3),('carrierfailureroute',2),('route_tree',2),('userblacklist',2),('globalblacklist',2);
- /*!40000 ALTER TABLE `version` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `watchers`
- --
- DROP TABLE IF EXISTS `watchers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `watchers` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `presentity_uri` char(128) NOT NULL,
- `watcher_username` char(64) NOT NULL,
- `watcher_domain` char(64) NOT NULL,
- `event` char(64) NOT NULL DEFAULT 'presence',
- `status` int(11) NOT NULL,
- `reason` char(64) DEFAULT NULL,
- `inserted_time` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `watcher_idx` (`presentity_uri`,`watcher_username`,`watcher_domain`,`event`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `watchers`
- --
- LOCK TABLES `watchers` WRITE;
- /*!40000 ALTER TABLE `watchers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `watchers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `xcap`
- --
- DROP TABLE IF EXISTS `xcap`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `xcap` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` char(64) NOT NULL,
- `domain` char(64) NOT NULL,
- `doc` blob NOT NULL,
- `doc_type` int(11) NOT NULL,
- `etag` char(64) NOT NULL,
- `source` int(11) NOT NULL,
- `doc_uri` char(128) NOT NULL,
- `port` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_doc_type_idx` (`username`,`domain`,`doc_type`,`doc_uri`),
- KEY `source_idx` (`source`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `xcap`
- --
- LOCK TABLES `xcap` WRITE;
- /*!40000 ALTER TABLE `xcap` DISABLE KEYS */;
- /*!40000 ALTER TABLE `xcap` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2012-04-10 0:36:20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement