]> git.defcon.no Git - hermes/blob - doc/sql-data/sample-data.sql
git.defcon.no / hermes / blob
? search:


4c744c722d3f7b66cef1e577cbc90f69266b51ac
[hermes] / doc / sql-data / sample-data.sql
1 -- MySQL dump 10.11
2 --
3 -- Host: localhost Database: kamailio
4 -- ------------------------------------------------------
5 -- Server version 5.0.51a-24+lenny3-log
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18 --
19 -- Current Database: `kamailio`
20 --
21
22 USE `kamailio`;
23
24 --
25 -- Dumping data for table `acc`
26 --
27
28 LOCK TABLES `acc` WRITE;
29 /*!40000 ALTER TABLE `acc` DISABLE KEYS */;
30 /*!40000 ALTER TABLE `acc` ENABLE KEYS */;
31 UNLOCK TABLES;
32
33 --
34 -- Dumping data for table `active_watchers`
35 --
36
37 LOCK TABLES `active_watchers` WRITE;
38 /*!40000 ALTER TABLE `active_watchers` DISABLE KEYS */;
39 /*!40000 ALTER TABLE `active_watchers` ENABLE KEYS */;
40 UNLOCK TABLES;
41
42 --
43 -- Dumping data for table `address`
44 --
45
46 LOCK TABLES `address` WRITE;
47 /*!40000 ALTER TABLE `address` DISABLE KEYS */;
48 /*!40000 ALTER TABLE `address` ENABLE KEYS */;
49 UNLOCK TABLES;
50
51 --
52 -- Dumping data for table `aliases`
53 --
54
55 LOCK TABLES `aliases` WRITE;
56 /*!40000 ALTER TABLE `aliases` DISABLE KEYS */;
57 /*!40000 ALTER TABLE `aliases` ENABLE KEYS */;
58 UNLOCK TABLES;
59
60 --
61 -- Dumping data for table `carrier_name`
62 --
63
64 LOCK TABLES `carrier_name` WRITE;
65 /*!40000 ALTER TABLE `carrier_name` DISABLE KEYS */;
66 /*!40000 ALTER TABLE `carrier_name` ENABLE KEYS */;
67 UNLOCK TABLES;
68
69 --
70 -- Dumping data for table `carrierfailureroute`
71 --
72
73 LOCK TABLES `carrierfailureroute` WRITE;
74 /*!40000 ALTER TABLE `carrierfailureroute` DISABLE KEYS */;
75 /*!40000 ALTER TABLE `carrierfailureroute` ENABLE KEYS */;
76 UNLOCK TABLES;
77
78 --
79 -- Dumping data for table `carrierroute`
80 --
81
82 LOCK TABLES `carrierroute` WRITE;
83 /*!40000 ALTER TABLE `carrierroute` DISABLE KEYS */;
84 /*!40000 ALTER TABLE `carrierroute` ENABLE KEYS */;
85 UNLOCK TABLES;
86
87 --
88 -- Dumping data for table `cdrs`
89 --
90
91 LOCK TABLES `cdrs` WRITE;
92 /*!40000 ALTER TABLE `cdrs` DISABLE KEYS */;
93 /*!40000 ALTER TABLE `cdrs` ENABLE KEYS */;
94 UNLOCK TABLES;
95
96 --
97 -- Dumping data for table `cpl`
98 --
99
100 LOCK TABLES `cpl` WRITE;
101 /*!40000 ALTER TABLE `cpl` DISABLE KEYS */;
102 /*!40000 ALTER TABLE `cpl` ENABLE KEYS */;
103 UNLOCK TABLES;
104
105 --
106 -- Dumping data for table `custom_authorization`
107 --
108
109 LOCK TABLES `custom_authorization` WRITE;
110 /*!40000 ALTER TABLE `custom_authorization` DISABLE KEYS */;
111 /*!40000 ALTER TABLE `custom_authorization` ENABLE KEYS */;
112 UNLOCK TABLES;
113
114 --
115 -- Dumping data for table `dbaliases`
116 --
117
118 LOCK TABLES `dbaliases` WRITE;
119 /*!40000 ALTER TABLE `dbaliases` DISABLE KEYS */;
120 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');
121 /*!40000 ALTER TABLE `dbaliases` ENABLE KEYS */;
122 UNLOCK TABLES;
123
124 --
125 -- Dumping data for table `dialog`
126 --
127
128 LOCK TABLES `dialog` WRITE;
129 /*!40000 ALTER TABLE `dialog` DISABLE KEYS */;
130 /*!40000 ALTER TABLE `dialog` ENABLE KEYS */;
131 UNLOCK TABLES;
132
133 --
134 -- Dumping data for table `dialplan`
135 --
136
137 LOCK TABLES `dialplan` WRITE;
138 /*!40000 ALTER TABLE `dialplan` DISABLE KEYS */;
139 /*!40000 ALTER TABLE `dialplan` ENABLE KEYS */;
140 UNLOCK TABLES;
141
142 --
143 -- Dumping data for table `dispatcher`
144 --
145
146 LOCK TABLES `dispatcher` WRITE;
147 /*!40000 ALTER TABLE `dispatcher` DISABLE KEYS */;
148 /*!40000 ALTER TABLE `dispatcher` ENABLE KEYS */;
149 UNLOCK TABLES;
150
151 --
152 -- Dumping data for table `domain`
153 --
154
155 LOCK TABLES `domain` WRITE;
156 /*!40000 ALTER TABLE `domain` DISABLE KEYS */;
157 INSERT INTO `domain` VALUES (1,'example.com','1900-01-01 00:00:01');
158 /*!40000 ALTER TABLE `domain` ENABLE KEYS */;
159 UNLOCK TABLES;
160
161 --
162 -- Dumping data for table `domain_name`
163 --
164
165 LOCK TABLES `domain_name` WRITE;
166 /*!40000 ALTER TABLE `domain_name` DISABLE KEYS */;
167 /*!40000 ALTER TABLE `domain_name` ENABLE KEYS */;
168 UNLOCK TABLES;
169
170 --
171 -- Dumping data for table `domainpolicy`
172 --
173
174 LOCK TABLES `domainpolicy` WRITE;
175 /*!40000 ALTER TABLE `domainpolicy` DISABLE KEYS */;
176 /*!40000 ALTER TABLE `domainpolicy` ENABLE KEYS */;
177 UNLOCK TABLES;
178
179 --
180 -- Dumping data for table `globalblacklist`
181 --
182
183 LOCK TABLES `globalblacklist` WRITE;
184 /*!40000 ALTER TABLE `globalblacklist` DISABLE KEYS */;
185 /*!40000 ALTER TABLE `globalblacklist` ENABLE KEYS */;
186 UNLOCK TABLES;
187
188 --
189 -- Dumping data for table `grp`
190 --
191
192 LOCK TABLES `grp` WRITE;
193 /*!40000 ALTER TABLE `grp` DISABLE KEYS */;
194 /*!40000 ALTER TABLE `grp` ENABLE KEYS */;
195 UNLOCK TABLES;
196
197 --
198 -- Dumping data for table `htable`
199 --
200
201 LOCK TABLES `htable` WRITE;
202 /*!40000 ALTER TABLE `htable` DISABLE KEYS */;
203 /*!40000 ALTER TABLE `htable` ENABLE KEYS */;
204 UNLOCK TABLES;
205
206 --
207 -- Dumping data for table `imc_members`
208 --
209
210 LOCK TABLES `imc_members` WRITE;
211 /*!40000 ALTER TABLE `imc_members` DISABLE KEYS */;
212 /*!40000 ALTER TABLE `imc_members` ENABLE KEYS */;
213 UNLOCK TABLES;
214
215 --
216 -- Dumping data for table `imc_rooms`
217 --
218
219 LOCK TABLES `imc_rooms` WRITE;
220 /*!40000 ALTER TABLE `imc_rooms` DISABLE KEYS */;
221 /*!40000 ALTER TABLE `imc_rooms` ENABLE KEYS */;
222 UNLOCK TABLES;
223
224 --
225 -- Dumping data for table `lcr_gw`
226 --
227
228 LOCK TABLES `lcr_gw` WRITE;
229 /*!40000 ALTER TABLE `lcr_gw` DISABLE KEYS */;
230 /*!40000 ALTER TABLE `lcr_gw` ENABLE KEYS */;
231 UNLOCK TABLES;
232
233 --
234 -- Dumping data for table `lcr_rule`
235 --
236
237 LOCK TABLES `lcr_rule` WRITE;
238 /*!40000 ALTER TABLE `lcr_rule` DISABLE KEYS */;
239 /*!40000 ALTER TABLE `lcr_rule` ENABLE KEYS */;
240 UNLOCK TABLES;
241
242 --
243 -- Dumping data for table `lcr_rule_target`
244 --
245
246 LOCK TABLES `lcr_rule_target` WRITE;
247 /*!40000 ALTER TABLE `lcr_rule_target` DISABLE KEYS */;
248 /*!40000 ALTER TABLE `lcr_rule_target` ENABLE KEYS */;
249 UNLOCK TABLES;
250
251 --
252 -- Dumping data for table `location`
253 --
254
255 LOCK TABLES `location` WRITE;
256 /*!40000 ALTER TABLE `location` DISABLE KEYS */;
257 /*!40000 ALTER TABLE `location` ENABLE KEYS */;
258 UNLOCK TABLES;
259
260 --
261 -- Dumping data for table `missed_calls`
262 --
263
264 LOCK TABLES `missed_calls` WRITE;
265 /*!40000 ALTER TABLE `missed_calls` DISABLE KEYS */;
266 /*!40000 ALTER TABLE `missed_calls` ENABLE KEYS */;
267 UNLOCK TABLES;
268
269 --
270 -- Dumping data for table `pdt`
271 --
272
273 LOCK TABLES `pdt` WRITE;
274 /*!40000 ALTER TABLE `pdt` DISABLE KEYS */;
275 /*!40000 ALTER TABLE `pdt` ENABLE KEYS */;
276 UNLOCK TABLES;
277
278 --
279 -- Dumping data for table `presentity`
280 --
281
282 LOCK TABLES `presentity` WRITE;
283 /*!40000 ALTER TABLE `presentity` DISABLE KEYS */;
284 /*!40000 ALTER TABLE `presentity` ENABLE KEYS */;
285 UNLOCK TABLES;
286
287 --
288 -- Dumping data for table `pua`
289 --
290
291 LOCK TABLES `pua` WRITE;
292 /*!40000 ALTER TABLE `pua` DISABLE KEYS */;
293 /*!40000 ALTER TABLE `pua` ENABLE KEYS */;
294 UNLOCK TABLES;
295
296 --
297 -- Dumping data for table `purplemap`
298 --
299
300 LOCK TABLES `purplemap` WRITE;
301 /*!40000 ALTER TABLE `purplemap` DISABLE KEYS */;
302 /*!40000 ALTER TABLE `purplemap` ENABLE KEYS */;
303 UNLOCK TABLES;
304
305 --
306 -- Dumping data for table `re_grp`
307 --
308
309 LOCK TABLES `re_grp` WRITE;
310 /*!40000 ALTER TABLE `re_grp` DISABLE KEYS */;
311 /*!40000 ALTER TABLE `re_grp` ENABLE KEYS */;
312 UNLOCK TABLES;
313
314 --
315 -- Dumping data for table `rls_presentity`
316 --
317
318 LOCK TABLES `rls_presentity` WRITE;
319 /*!40000 ALTER TABLE `rls_presentity` DISABLE KEYS */;
320 /*!40000 ALTER TABLE `rls_presentity` ENABLE KEYS */;
321 UNLOCK TABLES;
322
323 --
324 -- Dumping data for table `rls_watchers`
325 --
326
327 LOCK TABLES `rls_watchers` WRITE;
328 /*!40000 ALTER TABLE `rls_watchers` DISABLE KEYS */;
329 /*!40000 ALTER TABLE `rls_watchers` ENABLE KEYS */;
330 UNLOCK TABLES;
331
332 --
333 -- Dumping data for table `silo`
334 --
335
336 LOCK TABLES `silo` WRITE;
337 /*!40000 ALTER TABLE `silo` DISABLE KEYS */;
338 /*!40000 ALTER TABLE `silo` ENABLE KEYS */;
339 UNLOCK TABLES;
340
341 --
342 -- Dumping data for table `sip_trace`
343 --
344
345 LOCK TABLES `sip_trace` WRITE;
346 /*!40000 ALTER TABLE `sip_trace` DISABLE KEYS */;
347 /*!40000 ALTER TABLE `sip_trace` ENABLE KEYS */;
348 UNLOCK TABLES;
349
350 --
351 -- Dumping data for table `speed_dial`
352 --
353
354 LOCK TABLES `speed_dial` WRITE;
355 /*!40000 ALTER TABLE `speed_dial` DISABLE KEYS */;
356 /*!40000 ALTER TABLE `speed_dial` ENABLE KEYS */;
357 UNLOCK TABLES;
358
359 --
360 -- Dumping data for table `statistics`
361 --
362
363 LOCK TABLES `statistics` WRITE;
364 /*!40000 ALTER TABLE `statistics` DISABLE KEYS */;
365 /*!40000 ALTER TABLE `statistics` ENABLE KEYS */;
366 UNLOCK TABLES;
367
368 --
369 -- Dumping data for table `subscriber`
370 --
371
372 LOCK TABLES `subscriber` WRITE;
373 /*!40000 ALTER TABLE `subscriber` DISABLE KEYS */;
374 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);
375 /*!40000 ALTER TABLE `subscriber` ENABLE KEYS */;
376 UNLOCK TABLES;
377
378 --
379 -- Dumping data for table `trusted`
380 --
381
382 LOCK TABLES `trusted` WRITE;
383 /*!40000 ALTER TABLE `trusted` DISABLE KEYS */;
384 /*!40000 ALTER TABLE `trusted` ENABLE KEYS */;
385 UNLOCK TABLES;
386
387 --
388 -- Dumping data for table `uri`
389 --
390
391 LOCK TABLES `uri` WRITE;
392 /*!40000 ALTER TABLE `uri` DISABLE KEYS */;
393 /*!40000 ALTER TABLE `uri` ENABLE KEYS */;
394 UNLOCK TABLES;
395
396 --
397 -- Dumping data for table `userblacklist`
398 --
399
400 LOCK TABLES `userblacklist` WRITE;
401 /*!40000 ALTER TABLE `userblacklist` DISABLE KEYS */;
402 /*!40000 ALTER TABLE `userblacklist` ENABLE KEYS */;
403 UNLOCK TABLES;
404
405 --
406 -- Dumping data for table `usr_preferences`
407 --
408
409 LOCK TABLES `usr_preferences` WRITE;
410 /*!40000 ALTER TABLE `usr_preferences` DISABLE KEYS */;
411 /*!40000 ALTER TABLE `usr_preferences` ENABLE KEYS */;
412 UNLOCK TABLES;
413
414 --
415 -- Dumping data for table `version`
416 --
417
418 LOCK TABLES `version` WRITE;
419 /*!40000 ALTER TABLE `version` DISABLE KEYS */;
420 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);
421 /*!40000 ALTER TABLE `version` ENABLE KEYS */;
422 UNLOCK TABLES;
423
424 --
425 -- Dumping data for table `watchers`
426 --
427
428 LOCK TABLES `watchers` WRITE;
429 /*!40000 ALTER TABLE `watchers` DISABLE KEYS */;
430 /*!40000 ALTER TABLE `watchers` ENABLE KEYS */;
431 UNLOCK TABLES;
432
433 --
434 -- Dumping data for table `xcap`
435 --
436
437 LOCK TABLES `xcap` WRITE;
438 /*!40000 ALTER TABLE `xcap` DISABLE KEYS */;
439 /*!40000 ALTER TABLE `xcap` ENABLE KEYS */;
440 UNLOCK TABLES;
441
442 --
443 -- Current Database: `provision`
444 --
445
446 USE `provision`;
447
448 --
449 -- Dumping data for table `number_pool`
450 --
451
452 LOCK TABLES `number_pool` WRITE;
453 /*!40000 ALTER TABLE `number_pool` DISABLE KEYS */;
454 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');
455 /*!40000 ALTER TABLE `number_pool` ENABLE KEYS */;
456 UNLOCK TABLES;
457
458 --
459 -- Dumping data for table `phones`
460 --
461
462 LOCK TABLES `phones` WRITE;
463 /*!40000 ALTER TABLE `phones` DISABLE KEYS */;
464 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);
465 /*!40000 ALTER TABLE `phones` ENABLE KEYS */;
466 UNLOCK TABLES;
467
468 --
469 -- Dumping data for table `servers`
470 --
471
472 LOCK TABLES `servers` WRITE;
473 /*!40000 ALTER TABLE `servers` DISABLE KEYS */;
474 INSERT INTO `servers` VALUES (1,'example.com','example.com',5062,'pbx.example.com',5060,NULL);
475 /*!40000 ALTER TABLE `servers` ENABLE KEYS */;
476 UNLOCK TABLES;
477
478 --
479 -- Dumping data for table `users`
480 --
481
482 LOCK TABLES `users` WRITE;
483 /*!40000 ALTER TABLE `users` DISABLE KEYS */;
484 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');
485 /*!40000 ALTER TABLE `users` ENABLE KEYS */;
486 UNLOCK TABLES;
487 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
488
489 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
490 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
491 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
492 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
493 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
494 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
495 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
496
497 -- Dump completed on 2012-01-17 17:21:45
Hermes is a framework for managing a Kamailio SIP VoIP infrastructure.