From: Jon Langseth Date: Tue, 24 Jan 2012 12:23:01 +0000 (+0100) Subject: Rework of structure SQL and sample data. Hermes and Kamailio SQL structures are now... X-Git-Url: https://git.defcon.no/?p=hermes;a=commitdiff_plain;h=982133eab5129d84716dc1132b2430714103b9a5 Rework of structure SQL and sample data. Hermes and Kamailio SQL structures are now separate, the database names are not bound, DROP TABLE statements are removed, the Kamailio-structure is stripped down to only Hermes-relevant tables. --- diff --git a/doc/sql-data/dump-sample.sh b/doc/sql-data/dump-sample.sh deleted file mode 100755 index 2c0da77..0000000 --- a/doc/sql-data/dump-sample.sh +++ /dev/null @@ -1,15 +0,0 @@ -#!/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 deleted file mode 100644 index 722d16d..0000000 --- a/doc/sql-data/sample-data.sql +++ /dev/null @@ -1,497 +0,0 @@ --- 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: `hermes` --- - -USE `hermes`; - --- --- 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,'http://pbx.example.com/hermes/prov/'); -/*!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/sampledata-hermes.sql b/doc/sql-data/sampledata-hermes.sql new file mode 100644 index 0000000..ffc6431 --- /dev/null +++ b/doc/sql-data/sampledata-hermes.sql @@ -0,0 +1,82 @@ + +/*!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 */; + + +-- +-- Dumping data for table `apikeys` +-- + +LOCK TABLES `apikeys` WRITE; +/*!40000 ALTER TABLE `apikeys` DISABLE KEYS */; +INSERT INTO `apikeys` VALUES ('2012-01-20 09:27:35','10.0.2.5','4hErgw3QFJLeuXGW'),('2012-01-21 20:09:55','10.0.3.87','Cfjl7LRtY74rU5hU'); +/*!40000 ALTER TABLE `apikeys` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping data for table `authorizations` +-- + +LOCK TABLES `authorizations` WRITE; +/*!40000 ALTER TABLE `authorizations` DISABLE KEYS */; +INSERT INTO `authorizations` VALUES ('2012-01-20 10:11:07','testuser','user',3),('2012-01-20 10:10:56','4hErgw3QFJLeuXGW','key',3),('2012-01-21 20:09:55','Cfjl7LRtY74rU5hU','key',2); +/*!40000 ALTER TABLE `authorizations` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 (3,'example.com','registrar.example.com',5060,'proxy.example.com',5060,'http://phone.example.com/hermes/prov/'); +/*!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','New text','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'),(33,'2012-01-17 18:39:38','foobar','a8b687dec028ffe2d1b3030d','Another Test','example.com','example.com',5062,'pbx.example.com',5060,'foobar','(*xx*.|xxx.)','foobar'); +/*!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 */; + diff --git a/doc/sql-data/sampledata-kamailio.sql b/doc/sql-data/sampledata-kamailio.sql new file mode 100644 index 0000000..d45ecc1 --- /dev/null +++ b/doc/sql-data/sampledata-kamailio.sql @@ -0,0 +1,62 @@ + +/*!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 */; + +-- +-- 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'),(35,'foofoo','example.com','jonl','example.com'); +/*!40000 ALTER TABLE `dbaliases` 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 `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),(49,'foobar','example.com','a8b687dec028ffe2d1b3030d','foobar@example.com','294a3c8bc1967a3b7d42bfd209319f7a','19f7a29110d892316c10a7b2d6a7cc39',NULL,14,14); +/*!40000 ALTER TABLE `subscriber` 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; + + +/*!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-23 13:37:42 diff --git a/doc/sql-data/structure-hermes.sql b/doc/sql-data/structure-hermes.sql new file mode 100644 index 0000000..cd1c201 --- /dev/null +++ b/doc/sql-data/structure-hermes.sql @@ -0,0 +1,123 @@ +/*!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 */; + + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; + +-- +-- Table structure for table `apikeys` +-- + +CREATE TABLE `apikeys` ( + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `host` varchar(64) NOT NULL, + `apikey` varchar(128) NOT NULL, + PRIMARY KEY (`apikey`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `authorizations` +-- + +CREATE TABLE `authorizations` ( + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `authid` varchar(255) NOT NULL, + `type` varchar(16) NOT NULL, + `access_level` int(11) NOT NULL, + PRIMARY KEY (`authid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `number_pool` +-- + +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 DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `phones` +-- + +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 DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `servers` +-- + +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, + `prov_url` text, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `sessionkeys` +-- + +CREATE TABLE `sessionkeys` ( + `sessid` varchar(255) NOT NULL, + `session` varchar(128) NOT NULL, + `authid` varchar(128) NOT NULL, + `client` varchar(255) NOT NULL, + `key` varchar(128) NOT NULL, + `last` datetime default NULL, + PRIMARY KEY (`session`,`authid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `users` +-- + +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 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 */; diff --git a/doc/sql-data/structure-kamailio.sql b/doc/sql-data/structure-kamailio.sql new file mode 100644 index 0000000..2738d5a --- /dev/null +++ b/doc/sql-data/structure-kamailio.sql @@ -0,0 +1,81 @@ +/*!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 */; + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; + +-- +-- Table structure for table `dbaliases` +-- + +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 DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `domain` +-- + +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 DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `subscriber` +-- + +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 DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `version` +-- + +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; + +/*!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 */; diff --git a/doc/sql-data/structure.sql b/doc/sql-data/structure.sql deleted file mode 100644 index bd7f96e..0000000 --- a/doc/sql-data/structure.sql +++ /dev/null @@ -1,1158 +0,0 @@ --- 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: `hermes` --- - -CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hermes` /*!40100 DEFAULT CHARACTER SET latin1 */; - -USE `hermes`; - --- --- Table structure for table `apikeys` --- - -CREATE TABLE IF NOT EXISTS `apikeys` ( - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `host` varchar(64) NOT NULL, - `apikey` varchar(128) NOT NULL, - PRIMARY KEY (`apikey`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- -------------------------------------------------------- - --- --- Table structure for table `authorizations` --- - -DROP TABLE IF EXISTS `authorizations`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE IF NOT EXISTS `authorizations` ( - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `authid` varchar(255) NOT NULL, - `type` varchar(16) NOT NULL, - `access_level` int(11) NOT NULL, - PRIMARY KEY (`authid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -SET character_set_client = @saved_cs_client; - --- --- 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, - `prov_url` text, - PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -SET character_set_client = @saved_cs_client; - --- --- Table structure for table `sessionkeys` --- - -DROP TABLE IF EXISTS `sessionkeys`; -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; -CREATE TABLE `sessionkeys` ( - `sessid` varchar(255) NOT NULL, - `session` varchar(128) NOT NULL, - `authid` varchar(128) NOT NULL, - `client` varchar(255) NOT NULL, - `key` varchar(128) NOT NULL, - `last` datetime default NULL, - PRIMARY KEY (`session`,`authid`) -) ENGINE=MyISAM 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