From a63d06b26485e8859f9367d0d1d2dfee615ed4c4 Mon Sep 17 00:00:00 2001 From: Jon Langseth Date: Tue, 17 Jan 2012 18:49:31 +0100 Subject: [PATCH] Added doc/ directory for documentation et.al. Added README file and sample SQL data to doc/ --- doc/README | 49 ++ doc/sql-data/dump-sample.sh | 15 + doc/sql-data/sample-data.sql | 497 +++++++++++++++ doc/sql-data/structure.sql | 1110 ++++++++++++++++++++++++++++++++++ 4 files changed, 1671 insertions(+) create mode 100644 doc/README create mode 100755 doc/sql-data/dump-sample.sh create mode 100644 doc/sql-data/sample-data.sql create mode 100644 doc/sql-data/structure.sql diff --git a/doc/README b/doc/README new file mode 100644 index 0000000..8af719f --- /dev/null +++ b/doc/README @@ -0,0 +1,49 @@ +ABOUT HERMES +------------------------- + +Hermes is a framework for managing a Kamailio SIP VoIP infrastructure. It is +designed to manage user accounts, SIP aliases, E164 phone number aliases and +automatic provisioning of hardphones. Hermes provides an API as a foundation +for its own user interface, and for integration with other systems. The API is +implemented as HTTP-REST using JSON. The user interface focuses on dayly +administration tasks (user management, alias handling, phone registration) and +not on Kamailio server management. + + +CONFIGURING THE FRONTEND/UI +------------------------- +TBD + +CONFIGURING THE API +------------------------- + +The API needs to be configured separately from the UI. +API configuration is done by creating the PHP file +$install_path/api/config.php. A sample configuration file +is provided as $install_path/api/config.php.sample. +If config.php is not present, the API may fail in +in somewhat unpredictable ways ... + +sql_server -> Your MySQL server ... +sql_username -> Username for MySQL access + Needs RW access to kamailio and provision db's +sql_password -> Password for the above username +kamailio_db -> Database name of kamailio db. +provision_db -> Database name of provision db. + +standard_dialplan -> Dialling pattern to use for new users +default_domain -> What domain should always be listed first +permit_multiple_e164alias -> Currently not used ... + +The following configuration options define SQL table names +for respective data-sets, values for the sample-data.sql +are listed... : + +kamailio_domain_table (domain) +kamailio_subscriber_table (subscriber) +kamailio_alias_table (dbaliases) +provision_users_table (users) +provision_phones_table (phones) +provision_servers_table (servers) +numbers_table (numbers) + diff --git a/doc/sql-data/dump-sample.sh b/doc/sql-data/dump-sample.sh new file mode 100755 index 0000000..2c0da77 --- /dev/null +++ b/doc/sql-data/dump-sample.sh @@ -0,0 +1,15 @@ +#!/bin/bash +DB_HOST="database.example.com" +DB_USER="hermes" +KAMAILIO_DB="kamailio" +PROVISION_DB="provision" + +mysqldump -p -u ${DB_USER} -h ${DB_HOST} \ + --no-data \ + --databases ${KAMAILIO_DB} ${PROVISION_DB} \ + > structure.sql + +mysqldump -p -u ${DB_USER} -h ${DB_HOST} \ + --no-create-db --no-create-info \ + --databases ${KAMAILIO_DB} ${PROVISION_DB} \ + > sample-data.sql diff --git a/doc/sql-data/sample-data.sql b/doc/sql-data/sample-data.sql new file mode 100644 index 0000000..9c5c0ed --- /dev/null +++ b/doc/sql-data/sample-data.sql @@ -0,0 +1,497 @@ +-- MySQL dump 10.11 +-- +-- Host: localhost Database: kamailio +-- ------------------------------------------------------ +-- Server version 5.0.51a-24+lenny3-log + +/*!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 */; + +-- +-- Current Database: `kamailio` +-- + +USE `kamailio`; + +-- +-- Dumping data for table `acc` +-- + +LOCK TABLES `acc` WRITE; +/*!40000 ALTER TABLE `acc` DISABLE KEYS */; +/*!40000 ALTER TABLE `acc` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `active_watchers` +-- + +LOCK TABLES `active_watchers` WRITE; +/*!40000 ALTER TABLE `active_watchers` DISABLE KEYS */; +/*!40000 ALTER TABLE `active_watchers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `address` +-- + +LOCK TABLES `address` WRITE; +/*!40000 ALTER TABLE `address` DISABLE KEYS */; +/*!40000 ALTER TABLE `address` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `aliases` +-- + +LOCK TABLES `aliases` WRITE; +/*!40000 ALTER TABLE `aliases` DISABLE KEYS */; +/*!40000 ALTER TABLE `aliases` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `carrier_name` +-- + +LOCK TABLES `carrier_name` WRITE; +/*!40000 ALTER TABLE `carrier_name` DISABLE KEYS */; +/*!40000 ALTER TABLE `carrier_name` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `carrierfailureroute` +-- + +LOCK TABLES `carrierfailureroute` WRITE; +/*!40000 ALTER TABLE `carrierfailureroute` DISABLE KEYS */; +/*!40000 ALTER TABLE `carrierfailureroute` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `carrierroute` +-- + +LOCK TABLES `carrierroute` WRITE; +/*!40000 ALTER TABLE `carrierroute` DISABLE KEYS */; +/*!40000 ALTER TABLE `carrierroute` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `cdrs` +-- + +LOCK TABLES `cdrs` WRITE; +/*!40000 ALTER TABLE `cdrs` DISABLE KEYS */; +/*!40000 ALTER TABLE `cdrs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `cpl` +-- + +LOCK TABLES `cpl` WRITE; +/*!40000 ALTER TABLE `cpl` DISABLE KEYS */; +/*!40000 ALTER TABLE `cpl` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `custom_authorization` +-- + +LOCK TABLES `custom_authorization` WRITE; +/*!40000 ALTER TABLE `custom_authorization` DISABLE KEYS */; +/*!40000 ALTER TABLE `custom_authorization` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `dbaliases` +-- + +LOCK TABLES `dbaliases` WRITE; +/*!40000 ALTER TABLE `dbaliases` DISABLE KEYS */; +INSERT INTO `dbaliases` VALUES (1,'jon.langseth','example.com','jonl','example.com'),(34,'+4761135156','example.com','jonl','example.com'),(6,'+4773411490','example.com','externaluser','asteriskbox.example.com:5062'),(18,'+4773411495','example.com','sipp','example.com'); +/*!40000 ALTER TABLE `dbaliases` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `dialog` +-- + +LOCK TABLES `dialog` WRITE; +/*!40000 ALTER TABLE `dialog` DISABLE KEYS */; +/*!40000 ALTER TABLE `dialog` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `dialplan` +-- + +LOCK TABLES `dialplan` WRITE; +/*!40000 ALTER TABLE `dialplan` DISABLE KEYS */; +/*!40000 ALTER TABLE `dialplan` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `dispatcher` +-- + +LOCK TABLES `dispatcher` WRITE; +/*!40000 ALTER TABLE `dispatcher` DISABLE KEYS */; +/*!40000 ALTER TABLE `dispatcher` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `domain` +-- + +LOCK TABLES `domain` WRITE; +/*!40000 ALTER TABLE `domain` DISABLE KEYS */; +INSERT INTO `domain` VALUES (1,'example.com','1900-01-01 00:00:01'); +/*!40000 ALTER TABLE `domain` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `domain_name` +-- + +LOCK TABLES `domain_name` WRITE; +/*!40000 ALTER TABLE `domain_name` DISABLE KEYS */; +/*!40000 ALTER TABLE `domain_name` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `domainpolicy` +-- + +LOCK TABLES `domainpolicy` WRITE; +/*!40000 ALTER TABLE `domainpolicy` DISABLE KEYS */; +/*!40000 ALTER TABLE `domainpolicy` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `globalblacklist` +-- + +LOCK TABLES `globalblacklist` WRITE; +/*!40000 ALTER TABLE `globalblacklist` DISABLE KEYS */; +/*!40000 ALTER TABLE `globalblacklist` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `grp` +-- + +LOCK TABLES `grp` WRITE; +/*!40000 ALTER TABLE `grp` DISABLE KEYS */; +/*!40000 ALTER TABLE `grp` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `htable` +-- + +LOCK TABLES `htable` WRITE; +/*!40000 ALTER TABLE `htable` DISABLE KEYS */; +/*!40000 ALTER TABLE `htable` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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; + +-- +-- 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; + +-- +-- Dumping data for table `lcr_gw` +-- + +LOCK TABLES `lcr_gw` WRITE; +/*!40000 ALTER TABLE `lcr_gw` DISABLE KEYS */; +/*!40000 ALTER TABLE `lcr_gw` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `lcr_rule` +-- + +LOCK TABLES `lcr_rule` WRITE; +/*!40000 ALTER TABLE `lcr_rule` DISABLE KEYS */; +/*!40000 ALTER TABLE `lcr_rule` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `lcr_rule_target` +-- + +LOCK TABLES `lcr_rule_target` WRITE; +/*!40000 ALTER TABLE `lcr_rule_target` DISABLE KEYS */; +/*!40000 ALTER TABLE `lcr_rule_target` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `location` +-- + +LOCK TABLES `location` WRITE; +/*!40000 ALTER TABLE `location` DISABLE KEYS */; +/*!40000 ALTER TABLE `location` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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; + +-- +-- Dumping data for table `pdt` +-- + +LOCK TABLES `pdt` WRITE; +/*!40000 ALTER TABLE `pdt` DISABLE KEYS */; +/*!40000 ALTER TABLE `pdt` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `presentity` +-- + +LOCK TABLES `presentity` WRITE; +/*!40000 ALTER TABLE `presentity` DISABLE KEYS */; +/*!40000 ALTER TABLE `presentity` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `pua` +-- + +LOCK TABLES `pua` WRITE; +/*!40000 ALTER TABLE `pua` DISABLE KEYS */; +/*!40000 ALTER TABLE `pua` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `purplemap` +-- + +LOCK TABLES `purplemap` WRITE; +/*!40000 ALTER TABLE `purplemap` DISABLE KEYS */; +/*!40000 ALTER TABLE `purplemap` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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; + +-- +-- 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; + +-- +-- 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; + +-- +-- Dumping data for table `silo` +-- + +LOCK TABLES `silo` WRITE; +/*!40000 ALTER TABLE `silo` DISABLE KEYS */; +/*!40000 ALTER TABLE `silo` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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; + +-- +-- 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; + +-- +-- Dumping data for table `statistics` +-- + +LOCK TABLES `statistics` WRITE; +/*!40000 ALTER TABLE `statistics` DISABLE KEYS */; +/*!40000 ALTER TABLE `statistics` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `subscriber` +-- + +LOCK TABLES `subscriber` WRITE; +/*!40000 ALTER TABLE `subscriber` DISABLE KEYS */; +INSERT INTO `subscriber` VALUES (3,'jonl','example.com','f4837c002110e777170a7eba','jon.langseth@example.com','f24154226327c08b70f9884eae1bcc6f','41edc21917bb779abf1b1ab9b46ac36f',NULL,30,30),(5,'testuser','example.com','test12345user','justtesting@no.email','5a5437231dca810192a31be83b498af1','6218bae3b04f4f850d1aafb699125427',NULL,14,14),(40,'sipp','example.com','yQ7f5xsLCEmsGOa','sipp@example.com','','',NULL,14,14),(48,'foo','example.com','84ee6d6155abfbd408cbe0b2f','example@example.com','8fc0bd6512f0eb81a98e25e61c78ff25','95e59e343587489471d69a3557332641',NULL,14,14); +/*!40000 ALTER TABLE `subscriber` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `trusted` +-- + +LOCK TABLES `trusted` WRITE; +/*!40000 ALTER TABLE `trusted` DISABLE KEYS */; +/*!40000 ALTER TABLE `trusted` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `uri` +-- + +LOCK TABLES `uri` WRITE; +/*!40000 ALTER TABLE `uri` DISABLE KEYS */; +/*!40000 ALTER TABLE `uri` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `userblacklist` +-- + +LOCK TABLES `userblacklist` WRITE; +/*!40000 ALTER TABLE `userblacklist` DISABLE KEYS */; +/*!40000 ALTER TABLE `userblacklist` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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; + +-- +-- Dumping data for table `version` +-- + +LOCK TABLES `version` WRITE; +/*!40000 ALTER TABLE `version` DISABLE KEYS */; +INSERT INTO `version` VALUES ('acc',4),('missed_calls',3),('lcr_gw',1),('lcr_rule_target',1),('lcr_rule',1),('domain',1),('grp',2),('re_grp',1),('trusted',5),('address',4),('aliases',1004),('location',1004),('silo',5),('dbaliases',1),('uri',1),('speed_dial',2),('usr_preferences',2),('subscriber',6),('pdt',1),('dialog',5),('dispatcher',4),('dialplan',1),('imc_rooms',1),('imc_members',1),('cpl',1),('sip_trace',2),('domainpolicy',2),('carrierroute',3),('carrierfailureroute',2),('carrier_name',1),('domain_name',1),('userblacklist',1),('globalblacklist',1),('htable',1),('purplemap',1),('presentity',3),('active_watchers',9),('watchers',3),('xcap',3),('pua',6),('rls_presentity',0),('rls_watchers',1); +/*!40000 ALTER TABLE `version` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `watchers` +-- + +LOCK TABLES `watchers` WRITE; +/*!40000 ALTER TABLE `watchers` DISABLE KEYS */; +/*!40000 ALTER TABLE `watchers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `xcap` +-- + +LOCK TABLES `xcap` WRITE; +/*!40000 ALTER TABLE `xcap` DISABLE KEYS */; +/*!40000 ALTER TABLE `xcap` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Current Database: `provision` +-- + +USE `provision`; + +-- +-- Dumping data for table `number_pool` +-- + +LOCK TABLES `number_pool` WRITE; +/*!40000 ALTER TABLE `number_pool` DISABLE KEYS */; +INSERT INTO `number_pool` VALUES (1,'2011-05-23 12:00:03','+4773411491'),(2,'2011-05-23 12:00:05','+4773411492'),(3,'2011-05-23 12:00:07','+4773411494'),(4,'2011-05-23 12:00:11','+4773411495'),(5,'2011-05-23 12:00:12','+4773411496'),(6,'2011-05-23 12:00:13','+4773411497'),(7,'2011-05-23 12:00:15','+4773411498'),(8,'2011-05-23 12:00:17','+4773411499'),(29,'2012-01-12 14:03:06','+4761135305'),(28,'2011-05-24 19:03:49','+4773411493'),(27,'2011-05-24 19:03:10','+4773411468'),(26,'2011-05-24 19:03:01','+4773411462'); +/*!40000 ALTER TABLE `number_pool` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `phones` +-- + +LOCK TABLES `phones` WRITE; +/*!40000 ALTER TABLE `phones` DISABLE KEYS */; +INSERT INTO `phones` VALUES (1,'2011-05-10 12:06:14','c89c1d6db76c',1,NULL),(2,'2011-05-10 12:06:45','1cdf0f4a35eb',30,NULL),(3,'2011-05-10 12:06:49','1cdf0f4a35eb',1,NULL),(12,'2012-01-17 12:22:55','f00ba2ba5c00',1,NULL); +/*!40000 ALTER TABLE `phones` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `servers` +-- + +LOCK TABLES `servers` WRITE; +/*!40000 ALTER TABLE `servers` DISABLE KEYS */; +INSERT INTO `servers` VALUES (1,'example.com','example.com',5062,'pbx.example.com',5060); +/*!40000 ALTER TABLE `servers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `users` +-- + +LOCK TABLES `users` WRITE; +/*!40000 ALTER TABLE `users` DISABLE KEYS */; +INSERT INTO `users` VALUES (1,'2011-05-10 12:02:48','jonl','f4837c002110e777170a7eba','Langseth, Jon','example.com','example.com',5062,'pbx.example.com',5060,'jonl','(*xx*|*xx*x.|*xx*x.*|*xx|*xx.|xxx.)','73411463'),(30,'2012-01-12 16:53:59','foo','84ee6d6155abfbd408cbe0b2f0d363a9','Hey Yo','example.com','example.com',5062,'pbx.example.com',5060,'foo','(*xx*.|xxx.)','lolol'),(32,'2012-01-16 23:00:00','testuser','test12345user','Test User','example.com','example.com',5062,'pbx.example.com',5060,'jonl','(*xx*|*xx*x.|*xx*x.*|*xx|*xx.|xxx.)','testuser'); +/*!40000 ALTER TABLE `users` 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-01-17 17:21:45 diff --git a/doc/sql-data/structure.sql b/doc/sql-data/structure.sql new file mode 100644 index 0000000..aa05a75 --- /dev/null +++ b/doc/sql-data/structure.sql @@ -0,0 +1,1110 @@ +-- MySQL dump 10.11 +-- +-- Host: localhost Database: kamailio +-- ------------------------------------------------------ +-- Server version 5.0.51a-24+lenny3-log + +/*!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 */; + +-- +-- Current Database: `kamailio` +-- + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kamailio` /*!40100 DEFAULT CHARACTER SET latin1 */; + +USE `kamailio`; + +-- +-- Table structure for table `acc` +-- + +DROP TABLE IF EXISTS `acc`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `acc` ( + `id` int(10) unsigned NOT NULL auto_increment, + `method` varchar(16) NOT NULL default '', + `from_tag` varchar(64) NOT NULL default '', + `to_tag` varchar(64) NOT NULL default '', + `callid` varchar(128) NOT NULL default '', + `sip_code` char(3) NOT NULL default '', + `sip_reason` varchar(32) NOT NULL default '', + `time` datetime NOT NULL default '0000-00-00 00:00:00', + `src_ip` varchar(64) NOT NULL default '', + `dst_user` varchar(64) NOT NULL default '', + `dst_domain` varchar(128) NOT NULL default '', + `src_user` varchar(64) NOT NULL default '', + `src_domain` varchar(128) NOT NULL default '', + `cdr_id` int(11) NOT NULL default '0', + `dst_ouser` varchar(64) NOT NULL default '', + PRIMARY KEY (`id`), + KEY `acc_callid` (`callid`) +) ENGINE=MyISAM AUTO_INCREMENT=8086 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `active_watchers` +-- + +DROP TABLE IF EXISTS `active_watchers`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `active_watchers` ( + `id` int(10) unsigned NOT NULL auto_increment, + `presentity_uri` varchar(128) NOT NULL, + `watcher_username` varchar(64) NOT NULL, + `watcher_domain` varchar(64) NOT NULL, + `to_user` varchar(64) NOT NULL, + `to_domain` varchar(64) NOT NULL, + `event` varchar(64) NOT NULL default 'presence', + `event_id` varchar(64) default NULL, + `to_tag` varchar(64) NOT NULL, + `from_tag` varchar(64) NOT NULL, + `callid` varchar(64) NOT NULL, + `local_cseq` int(11) NOT NULL, + `remote_cseq` int(11) NOT NULL, + `contact` varchar(64) NOT NULL, + `record_route` text, + `expires` int(11) NOT NULL, + `status` int(11) NOT NULL default '2', + `reason` varchar(64) NOT NULL, + `version` int(11) NOT NULL default '0', + `socket_info` varchar(64) NOT NULL, + `local_contact` varchar(128) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `active_watchers_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `address` +-- + +DROP TABLE IF EXISTS `address`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `address` ( + `id` int(10) unsigned NOT NULL auto_increment, + `grp` smallint(5) unsigned NOT NULL default '1', + `ip_addr` varchar(15) NOT NULL, + `mask` tinyint(4) NOT NULL default '32', + `port` smallint(5) unsigned NOT NULL default '0', + `tag` varchar(64) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `aliases` +-- + +DROP TABLE IF EXISTS `aliases`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `aliases` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) default NULL, + `contact` varchar(255) NOT NULL default '', + `received` varchar(128) default NULL, + `path` varchar(128) default NULL, + `expires` datetime NOT NULL default '2020-05-28 21:32:15', + `q` float(10,2) NOT NULL default '1.00', + `callid` varchar(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` varchar(255) NOT NULL default '', + `socket` varchar(64) default NULL, + `methods` int(11) default NULL, + PRIMARY KEY (`id`), + KEY `alias_idx` (`username`,`domain`,`contact`) +) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `carrier_name` +-- + +DROP TABLE IF EXISTS `carrier_name`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `carrier_name` ( + `id` int(10) unsigned NOT NULL auto_increment, + `carrier` varchar(64) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `carrierfailureroute` +-- + +DROP TABLE IF EXISTS `carrierfailureroute`; +SET @saved_cs_client = @@character_set_client; +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` int(10) unsigned NOT NULL default '0', + `scan_prefix` varchar(64) NOT NULL default '', + `host_name` varchar(128) NOT NULL default '', + `reply_code` varchar(3) NOT NULL default '', + `flags` int(11) unsigned NOT NULL default '0', + `mask` int(11) unsigned NOT NULL default '0', + `next_domain` int(10) unsigned NOT NULL default '0', + `description` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `carrierroute` +-- + +DROP TABLE IF EXISTS `carrierroute`; +SET @saved_cs_client = @@character_set_client; +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` int(10) unsigned NOT NULL default '0', + `scan_prefix` varchar(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` varchar(128) NOT NULL default '', + `rewrite_prefix` varchar(64) NOT NULL default '', + `rewrite_suffix` varchar(64) NOT NULL default '', + `description` varchar(255) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `cdrs` +-- + +DROP TABLE IF EXISTS `cdrs`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `cdrs` ( + `cdr_id` bigint(20) NOT NULL auto_increment, + `src_username` varchar(64) NOT NULL default '', + `src_domain` varchar(128) NOT NULL default '', + `dst_username` varchar(64) NOT NULL default '', + `dst_domain` varchar(128) NOT NULL default '', + `call_start_time` datetime NOT NULL default '0000-00-00 00:00:00', + `duration` int(10) unsigned NOT NULL default '0', + `sip_call_id` varchar(128) NOT NULL default '', + `sip_from_tag` varchar(128) NOT NULL default '', + `sip_to_tag` varchar(128) NOT NULL default '', + `src_ip` varchar(64) NOT NULL default '', + `cost` int(11) NOT NULL default '0', + `rated` int(11) NOT NULL default '0', + `created` datetime NOT NULL, + PRIMARY KEY (`cdr_id`), + UNIQUE KEY `uk_cft` (`sip_call_id`,`sip_from_tag`,`sip_to_tag`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `cpl` +-- + +DROP TABLE IF EXISTS `cpl`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `cpl` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL, + `domain` varchar(64) NOT NULL default '', + `cpl_xml` text, + `cpl_bin` text, + PRIMARY KEY (`id`), + UNIQUE KEY `account_idx` (`username`,`domain`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `custom_authorization` +-- + +DROP TABLE IF EXISTS `custom_authorization`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `custom_authorization` ( + `id` int(11) NOT NULL auto_increment, + `username` varchar(64) NOT NULL, + `permitedcalls` smallint(6) NOT NULL default '30', + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `dbaliases` +-- + +DROP TABLE IF EXISTS `dbaliases`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dbaliases` ( + `id` int(10) unsigned NOT NULL auto_increment, + `alias_username` varchar(64) NOT NULL default '', + `alias_domain` varchar(64) NOT NULL default '', + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `alias_idx` (`alias_username`,`alias_domain`), + KEY `target_idx` (`username`,`domain`) +) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `dialog` +-- + +DROP TABLE IF EXISTS `dialog`; +SET @saved_cs_client = @@character_set_client; +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` varchar(255) NOT NULL, + `from_uri` varchar(128) NOT NULL, + `from_tag` varchar(64) NOT NULL, + `to_uri` varchar(128) NOT NULL, + `to_tag` varchar(64) NOT NULL, + `caller_cseq` varchar(7) NOT NULL, + `callee_cseq` varchar(7) NOT NULL, + `caller_route_set` varchar(512) default NULL, + `callee_route_set` varchar(512) default NULL, + `caller_contact` varchar(128) NOT NULL, + `callee_contact` varchar(128) NOT NULL, + `caller_sock` varchar(64) NOT NULL, + `callee_sock` varchar(64) NOT NULL, + `state` int(10) unsigned NOT NULL, + `start_time` int(10) unsigned NOT NULL, + `timeout` int(10) unsigned NOT NULL default '0', + `sflags` int(10) unsigned NOT NULL default '0', + `toroute` int(10) unsigned NOT NULL default '0', + `toroute_name` varchar(32) default NULL, + `req_uri` varchar(128) NOT NULL, + PRIMARY KEY (`id`), + KEY `hash_idx` (`hash_entry`,`hash_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `dialplan` +-- + +DROP TABLE IF EXISTS `dialplan`; +SET @saved_cs_client = @@character_set_client; +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` varchar(64) NOT NULL, + `match_len` int(11) NOT NULL, + `subst_exp` varchar(64) NOT NULL, + `repl_exp` varchar(32) NOT NULL, + `attrs` varchar(32) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `dispatcher` +-- + +DROP TABLE IF EXISTS `dispatcher`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dispatcher` ( + `id` int(10) unsigned NOT NULL auto_increment, + `setid` int(11) NOT NULL default '0', + `destination` varchar(192) NOT NULL default '', + `flags` int(11) NOT NULL default '0', + `priority` int(11) NOT NULL default '0', + `attrs` varchar(128) NOT NULL default '', + `description` varchar(64) NOT NULL default '', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `domain` +-- + +DROP TABLE IF EXISTS `domain`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `domain` ( + `id` int(10) unsigned NOT NULL auto_increment, + `domain` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `domain_name` +-- + +DROP TABLE IF EXISTS `domain_name`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `domain_name` ( + `id` int(10) unsigned NOT NULL auto_increment, + `domain` varchar(64) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `domainpolicy` +-- + +DROP TABLE IF EXISTS `domainpolicy`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `domainpolicy` ( + `id` int(10) unsigned NOT NULL auto_increment, + `rule` varchar(255) NOT NULL, + `type` varchar(255) NOT NULL, + `att` varchar(255) default NULL, + `val` varchar(128) default NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `rav_idx` (`rule`,`att`,`val`), + KEY `rule_idx` (`rule`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `globalblacklist` +-- + +DROP TABLE IF EXISTS `globalblacklist`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `globalblacklist` ( + `id` int(10) unsigned NOT NULL auto_increment, + `prefix` varchar(64) NOT NULL default '', + `whitelist` tinyint(1) NOT NULL default '0', + `description` varchar(255) default NULL, + PRIMARY KEY (`id`), + KEY `globalblacklist_idx` (`prefix`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `grp` +-- + +DROP TABLE IF EXISTS `grp`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `grp` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + `grp` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `htable` +-- + +DROP TABLE IF EXISTS `htable`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `htable` ( + `id` int(10) unsigned NOT NULL auto_increment, + `key_name` varchar(64) NOT NULL default '', + `key_type` int(11) NOT NULL default '0', + `value_type` int(11) NOT NULL default '0', + `key_value` varchar(128) NOT NULL default '', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `imc_members` +-- + +DROP TABLE IF EXISTS `imc_members`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `imc_members` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL, + `domain` varchar(64) NOT NULL, + `room` varchar(64) NOT NULL, + `flag` int(11) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `account_room_idx` (`username`,`domain`,`room`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `imc_rooms` +-- + +DROP TABLE IF EXISTS `imc_rooms`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `imc_rooms` ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(64) NOT NULL, + `domain` varchar(64) NOT NULL, + `flag` int(11) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name_domain_idx` (`name`,`domain`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `lcr_gw` +-- + +DROP TABLE IF EXISTS `lcr_gw`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `lcr_gw` ( + `id` int(10) unsigned NOT NULL auto_increment, + `lcr_id` smallint(5) unsigned NOT NULL, + `gw_name` varchar(128) default NULL, + `ip_addr` varchar(15) default NULL, + `hostname` varchar(64) default NULL, + `port` smallint(5) unsigned default NULL, + `params` varchar(64) default NULL, + `uri_scheme` tinyint(3) unsigned default NULL, + `transport` tinyint(3) unsigned default NULL, + `strip` tinyint(3) unsigned default NULL, + `tag` varchar(16) default NULL, + `flags` int(10) unsigned NOT NULL default '0', + `defunct` int(10) unsigned default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `lcr_id_ip_addr_port_hostname_idx` (`lcr_id`,`ip_addr`,`port`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `lcr_rule` +-- + +DROP TABLE IF EXISTS `lcr_rule`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `lcr_rule` ( + `id` int(10) unsigned NOT NULL auto_increment, + `lcr_id` smallint(5) unsigned NOT NULL, + `prefix` varchar(16) default NULL, + `from_uri` varchar(64) default NULL, + `stopper` int(10) unsigned NOT NULL default '0', + `enabled` int(10) unsigned NOT NULL default '1', + PRIMARY KEY (`id`), + UNIQUE KEY `lcr_id_prefix_from_uri_idx` (`lcr_id`,`prefix`,`from_uri`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `lcr_rule_target` +-- + +DROP TABLE IF EXISTS `lcr_rule_target`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `lcr_rule_target` ( + `id` int(10) unsigned NOT NULL auto_increment, + `lcr_id` smallint(5) unsigned NOT NULL, + `rule_id` int(10) unsigned NOT NULL, + `gw_id` int(10) unsigned NOT NULL, + `priority` tinyint(3) unsigned NOT NULL, + `weight` int(10) unsigned NOT NULL default '1', + PRIMARY KEY (`id`), + UNIQUE KEY `rule_id_gw_id_idx` (`rule_id`,`gw_id`), + KEY `lcr_id_idx` (`lcr_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `location` +-- + +DROP TABLE IF EXISTS `location`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `location` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) default NULL, + `contact` varchar(255) NOT NULL default '', + `received` varchar(128) default NULL, + `path` varchar(128) default NULL, + `expires` datetime NOT NULL default '2020-05-28 21:32:15', + `q` float(10,2) NOT NULL default '1.00', + `callid` varchar(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` varchar(255) NOT NULL default '', + `socket` varchar(64) default NULL, + `methods` int(11) default NULL, + PRIMARY KEY (`id`), + KEY `account_contact_idx` (`username`,`domain`,`contact`) +) ENGINE=MyISAM AUTO_INCREMENT=3088 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `missed_calls` +-- + +DROP TABLE IF EXISTS `missed_calls`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `missed_calls` ( + `id` int(10) unsigned NOT NULL auto_increment, + `method` varchar(16) NOT NULL default '', + `from_tag` varchar(64) NOT NULL default '', + `to_tag` varchar(64) NOT NULL default '', + `callid` varchar(128) NOT NULL default '', + `sip_code` char(3) NOT NULL default '', + `sip_reason` varchar(32) NOT NULL default '', + `time` datetime NOT NULL default '0000-00-00 00:00:00', + `src_ip` varchar(64) NOT NULL default '', + `dst_user` varchar(64) NOT NULL default '', + `dst_domain` varchar(128) NOT NULL default '', + `src_user` varchar(64) NOT NULL default '', + `src_domain` varchar(128) NOT NULL default '', + `cdr_id` int(11) NOT NULL default '0', + `dst_ouser` varchar(64) NOT NULL default '', + PRIMARY KEY (`id`), + KEY `mc_callid` (`callid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `pdt` +-- + +DROP TABLE IF EXISTS `pdt`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `pdt` ( + `id` int(10) unsigned NOT NULL auto_increment, + `sdomain` varchar(128) NOT NULL, + `prefix` varchar(32) NOT NULL, + `domain` varchar(128) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `sdomain_prefix_idx` (`sdomain`,`prefix`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `presentity` +-- + +DROP TABLE IF EXISTS `presentity`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `presentity` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL, + `domain` varchar(64) NOT NULL, + `event` varchar(64) NOT NULL, + `etag` varchar(64) NOT NULL, + `expires` int(11) NOT NULL, + `received_time` int(11) NOT NULL, + `body` blob NOT NULL, + `sender` varchar(128) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `presentity_idx` (`username`,`domain`,`event`,`etag`) +) ENGINE=MyISAM AUTO_INCREMENT=1289 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `pua` +-- + +DROP TABLE IF EXISTS `pua`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `pua` ( + `id` int(10) unsigned NOT NULL auto_increment, + `pres_uri` varchar(128) NOT NULL, + `pres_id` varchar(64) NOT NULL, + `event` int(11) NOT NULL, + `expires` int(11) NOT NULL, + `desired_expires` int(11) NOT NULL, + `flag` int(11) NOT NULL, + `etag` varchar(64) NOT NULL, + `tuple_id` varchar(64) default NULL, + `watcher_uri` varchar(128) NOT NULL, + `call_id` varchar(64) NOT NULL, + `to_tag` varchar(64) NOT NULL, + `from_tag` varchar(64) NOT NULL, + `cseq` int(11) NOT NULL, + `record_route` text, + `contact` varchar(128) NOT NULL, + `remote_contact` varchar(128) NOT NULL, + `version` int(11) NOT NULL, + `extra_headers` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `purplemap` +-- + +DROP TABLE IF EXISTS `purplemap`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `purplemap` ( + `id` int(10) unsigned NOT NULL auto_increment, + `sip_user` varchar(128) NOT NULL, + `ext_user` varchar(128) NOT NULL, + `ext_prot` varchar(16) NOT NULL, + `ext_pass` varchar(64) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `re_grp` +-- + +DROP TABLE IF EXISTS `re_grp`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `re_grp` ( + `id` int(10) unsigned NOT NULL auto_increment, + `reg_exp` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `rls_presentity` +-- + +DROP TABLE IF EXISTS `rls_presentity`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `rls_presentity` ( + `id` int(10) unsigned NOT NULL auto_increment, + `rlsubs_did` varchar(255) NOT NULL, + `resource_uri` varchar(128) NOT NULL, + `content_type` varchar(64) NOT NULL, + `presence_state` blob NOT NULL, + `expires` int(11) NOT NULL, + `updated` int(11) NOT NULL, + `auth_state` int(11) NOT NULL, + `reason` varchar(64) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `rls_presentity_idx` (`rlsubs_did`,`resource_uri`), + KEY `updated_idx` (`updated`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `rls_watchers` +-- + +DROP TABLE IF EXISTS `rls_watchers`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `rls_watchers` ( + `id` int(10) unsigned NOT NULL auto_increment, + `presentity_uri` varchar(128) NOT NULL, + `to_user` varchar(64) NOT NULL, + `to_domain` varchar(64) NOT NULL, + `watcher_username` varchar(64) NOT NULL, + `watcher_domain` varchar(64) NOT NULL, + `event` varchar(64) NOT NULL default 'presence', + `event_id` varchar(64) default NULL, + `to_tag` varchar(64) NOT NULL, + `from_tag` varchar(64) NOT NULL, + `callid` varchar(64) NOT NULL, + `local_cseq` int(11) NOT NULL, + `remote_cseq` int(11) NOT NULL, + `contact` varchar(64) NOT NULL, + `record_route` text, + `expires` int(11) NOT NULL, + `status` int(11) NOT NULL default '2', + `reason` varchar(64) NOT NULL, + `version` int(11) NOT NULL default '0', + `socket_info` varchar(64) NOT NULL, + `local_contact` varchar(128) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `rls_watcher_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `silo` +-- + +DROP TABLE IF EXISTS `silo`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `silo` ( + `id` int(10) unsigned NOT NULL auto_increment, + `src_addr` varchar(128) NOT NULL default '', + `dst_addr` varchar(128) NOT NULL default '', + `username` varchar(64) NOT NULL default '', + `domain` varchar(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` varchar(32) NOT NULL default 'text/plain', + `body` blob NOT NULL, + PRIMARY KEY (`id`), + KEY `account_idx` (`username`,`domain`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `sip_trace` +-- + +DROP TABLE IF EXISTS `sip_trace`; +SET @saved_cs_client = @@character_set_client; +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` varchar(255) NOT NULL default '', + `traced_user` varchar(128) NOT NULL default '', + `msg` text NOT NULL, + `method` varchar(50) NOT NULL default '', + `status` varchar(128) NOT NULL default '', + `fromip` varchar(50) NOT NULL default '', + `toip` varchar(50) NOT NULL default '', + `fromtag` varchar(64) NOT NULL default '', + `direction` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `speed_dial` +-- + +DROP TABLE IF EXISTS `speed_dial`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `speed_dial` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + `sd_username` varchar(64) NOT NULL default '', + `sd_domain` varchar(64) NOT NULL default '', + `new_uri` varchar(128) NOT NULL default '', + `fname` varchar(64) NOT NULL default '', + `lname` varchar(64) NOT NULL default '', + `description` varchar(64) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `speed_dial_idx` (`username`,`domain`,`sd_domain`,`sd_username`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `statistics` +-- + +DROP TABLE IF EXISTS `statistics`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `statistics` ( + `id` int(10) unsigned NOT NULL auto_increment, + `time_stamp` int(10) unsigned NOT NULL default '0', + `shm_used_size` int(10) unsigned NOT NULL default '0', + `shm_real_used_size` int(10) unsigned NOT NULL default '0', + `shm_max_used_size` int(10) unsigned NOT NULL default '0', + `shm_free_used_size` int(10) unsigned NOT NULL default '0', + `ul_users` int(10) unsigned NOT NULL default '0', + `ul_contacts` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `subscriber` +-- + +DROP TABLE IF EXISTS `subscriber`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `subscriber` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + `password` varchar(25) NOT NULL default '', + `email_address` varchar(64) NOT NULL default '', + `ha1` varchar(64) NOT NULL default '', + `ha1b` varchar(64) NOT NULL default '', + `rpid` varchar(64) default NULL, + `permitedcalls` smallint(6) default '14', + `permittedcalls` smallint(6) default '14', + PRIMARY KEY (`id`), + UNIQUE KEY `account_idx` (`username`,`domain`), + KEY `username_idx` (`username`) +) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `trusted` +-- + +DROP TABLE IF EXISTS `trusted`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `trusted` ( + `id` int(10) unsigned NOT NULL auto_increment, + `src_ip` varchar(50) NOT NULL, + `proto` varchar(4) NOT NULL, + `from_pattern` varchar(64) default NULL, + `tag` varchar(64) default NULL, + PRIMARY KEY (`id`), + KEY `peer_idx` (`src_ip`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `uri` +-- + +DROP TABLE IF EXISTS `uri`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `uri` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + `uri_user` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `userblacklist` +-- + +DROP TABLE IF EXISTS `userblacklist`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `userblacklist` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL default '', + `domain` varchar(64) NOT NULL default '', + `prefix` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `usr_preferences` +-- + +DROP TABLE IF EXISTS `usr_preferences`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `usr_preferences` ( + `id` int(10) unsigned NOT NULL auto_increment, + `uuid` varchar(64) NOT NULL default '', + `username` varchar(128) NOT NULL default '0', + `domain` varchar(64) NOT NULL default '', + `attribute` varchar(32) NOT NULL default '', + `type` int(11) NOT NULL default '0', + `value` varchar(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`) +) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `version` +-- + +DROP TABLE IF EXISTS `version`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `version` ( + `table_name` varchar(32) NOT NULL, + `table_version` int(10) unsigned NOT NULL default '0' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `watchers` +-- + +DROP TABLE IF EXISTS `watchers`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `watchers` ( + `id` int(10) unsigned NOT NULL auto_increment, + `presentity_uri` varchar(128) NOT NULL, + `watcher_username` varchar(64) NOT NULL, + `watcher_domain` varchar(64) NOT NULL, + `event` varchar(64) NOT NULL default 'presence', + `status` int(11) NOT NULL, + `reason` varchar(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 AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `xcap` +-- + +DROP TABLE IF EXISTS `xcap`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `xcap` ( + `id` int(10) unsigned NOT NULL auto_increment, + `username` varchar(64) NOT NULL, + `domain` varchar(64) NOT NULL, + `doc` blob NOT NULL, + `doc_type` int(11) NOT NULL, + `etag` varchar(64) NOT NULL, + `source` int(11) NOT NULL, + `doc_uri` varchar(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; +SET character_set_client = @saved_cs_client; + +-- +-- Current Database: `provision` +-- + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `provision` /*!40100 DEFAULT CHARACTER SET latin1 */; + +USE `provision`; + +-- +-- Table structure for table `number_pool` +-- + +DROP TABLE IF EXISTS `number_pool`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `number_pool` ( + `id` int(11) NOT NULL auto_increment, + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `number` varchar(128) character set utf8 NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `phones` +-- + +DROP TABLE IF EXISTS `phones`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `phones` ( + `id` int(11) NOT NULL auto_increment, + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `mac` varchar(32) character set utf8 NOT NULL, + `user_rel` int(11) NOT NULL, + `ua_type` int(11) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `servers` +-- + +DROP TABLE IF EXISTS `servers`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `servers` ( + `id` int(11) NOT NULL auto_increment, + `domain` varchar(255) character set utf8 NOT NULL, + `registrar` varchar(255) character set utf8 default NULL, + `r_port` int(11) default NULL, + `proxy` varchar(255) character set utf8 default NULL, + `p_port` int(11) default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `users` +-- + +DROP TABLE IF EXISTS `users`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `users` ( + `id` int(11) NOT NULL auto_increment, + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, + `username` varchar(128) character set utf8 NOT NULL, + `password` varchar(128) character set utf8 NOT NULL, + `displayname` varchar(255) character set utf8 NOT NULL, + `domain` varchar(255) character set utf8 NOT NULL, + `registrar` varchar(255) character set utf8 default NULL, + `r_port` int(11) default NULL, + `proxy` varchar(255) character set utf8 default NULL, + `p_port` int(11) default NULL, + `authid` varchar(128) character set utf8 default NULL, + `dialplan` varchar(255) character set utf8 default NULL, + `linetext` varchar(64) character set utf8 default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; +/*!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-01-17 17:21:39 -- 2.39.2