git.defcon.no Git - hermes/blob - doc/sql-data/sampledata-hermes.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 --
  15 -- Dumping data for table `apikeys`
  16 --
  17
  18 LOCK TABLES `apikeys` WRITE;
  19 /*!40000 ALTER TABLE `apikeys` DISABLE KEYS */;
  20 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');
  21 /*!40000 ALTER TABLE `apikeys` ENABLE KEYS */;
  22 UNLOCK TABLES;
  23
  24 --
  25 -- Dumping data for table `authorizations`
  26 --
  27
  28 LOCK TABLES `authorizations` WRITE;
  29 /*!40000 ALTER TABLE `authorizations` DISABLE KEYS */;
  30 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);
  31 /*!40000 ALTER TABLE `authorizations` ENABLE KEYS */;
  32 UNLOCK TABLES;
  33
  34 --
  35 -- Dumping data for table `number_pool`
  36 --
  37
  38 LOCK TABLES `number_pool` WRITE;
  39 /*!40000 ALTER TABLE `number_pool` DISABLE KEYS */;
  40 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');
  41 /*!40000 ALTER TABLE `number_pool` ENABLE KEYS */;
  42 UNLOCK TABLES;
  43
  44 --
  45 -- Dumping data for table `phones`
  46 --
  47
  48 LOCK TABLES `phones` WRITE;
  49 /*!40000 ALTER TABLE `phones` DISABLE KEYS */;
  50 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);
  51 /*!40000 ALTER TABLE `phones` ENABLE KEYS */;
  52 UNLOCK TABLES;
  53
  54 --
  55 -- Dumping data for table `servers`
  56 --
  57
  58 LOCK TABLES `servers` WRITE;
  59 /*!40000 ALTER TABLE `servers` DISABLE KEYS */;
  60 INSERT INTO `servers` VALUES (3,'example.com','registrar.example.com',5060,'proxy.example.com',5060,'http://phone.example.com/hermes/prov/');
  61 /*!40000 ALTER TABLE `servers` ENABLE KEYS */;
  62 UNLOCK TABLES;
  63
  64 --
  65 -- Dumping data for table `users`
  66 --
  67
  68 LOCK TABLES `users` WRITE;
  69 /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  70 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');
  71 /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  72 UNLOCK TABLES;
  73 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  74
  75 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  76 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  77 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  78 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  79 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  80 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  81 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  82