X-Git-Url: https://git.defcon.no/?a=blobdiff_plain;f=doc%2Fsql-data%2Fsampledata-hermes.sql;fp=doc%2Fsql-data%2Fsampledata-hermes.sql;h=ffc6431d8fe2698046b79a014799839ef134e544;hb=982133eab5129d84716dc1132b2430714103b9a5;hp=0000000000000000000000000000000000000000;hpb=48430664a49aee26cfbf8bd6be1a1817457fb802;p=hermes

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 */;
+