Rework of structure SQL and sample data. Hermes and Kamailio SQL structures are now...

[hermes] / doc / sql-data / sampledata-kamailio.sql

diff --git a/doc/sql-data/sampledata-kamailio.sql b/doc/sql-data/sampledata-kamailio.sql
new file mode 100644 (file)
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