git.defcon.no Git - hermes/blob - doc/sql-data/sampledata-kamailio.sql

   1
   2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   3 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   4 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
   5 /*!40101 SET NAMES utf8 */;
   6 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
   7 /*!40103 SET TIME_ZONE='+00:00' */;
   8 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
   9 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  10 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  11 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  12
  13 --
  14 -- Dumping data for table `dbaliases`
  15 --
  16
  17 LOCK TABLES `dbaliases` WRITE;
  18 /*!40000 ALTER TABLE `dbaliases` DISABLE KEYS */;
  19 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');
  20 /*!40000 ALTER TABLE `dbaliases` ENABLE KEYS */;
  21 UNLOCK TABLES;
  22
  23 --
  24 -- Dumping data for table `domain`
  25 --
  26
  27 LOCK TABLES `domain` WRITE;
  28 /*!40000 ALTER TABLE `domain` DISABLE KEYS */;
  29 INSERT INTO `domain` VALUES (1,'example.com','1900-01-01 00:00:01');
  30 /*!40000 ALTER TABLE `domain` ENABLE KEYS */;
  31 UNLOCK TABLES;
  32
  33 --
  34 -- Dumping data for table `subscriber`
  35 --
  36
  37 LOCK TABLES `subscriber` WRITE;
  38 /*!40000 ALTER TABLE `subscriber` DISABLE KEYS */;
  39 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);
  40 /*!40000 ALTER TABLE `subscriber` ENABLE KEYS */;
  41 UNLOCK TABLES;
  42
  43 --
  44 -- Dumping data for table `version`
  45 --
  46
  47 LOCK TABLES `version` WRITE;
  48 /*!40000 ALTER TABLE `version` DISABLE KEYS */;
  49 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);
  50 /*!40000 ALTER TABLE `version` ENABLE KEYS */;
  51 UNLOCK TABLES;
  52
  53
  54 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  55 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  56 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  57 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  58 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  59 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  60 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  61
  62 -- Dump completed on 2012-01-23 13:37:42