]>
git.defcon.no Git - hermes/blob - doc/sql-data/sample-data.sql
3 -- Host: localhost Database: kamailio
4 -- ------------------------------------------------------
5 -- Server version 5.0.51a-24+lenny3-log
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 */ ;
19 -- Current Database: `kamailio`
25 -- Dumping data for table `acc`
28 LOCK TABLES `acc`
WRITE ;
29 /*!40000 ALTER TABLE `acc` DISABLE KEYS */ ;
30 /*!40000 ALTER TABLE `acc` ENABLE KEYS */ ;
34 -- Dumping data for table `active_watchers`
37 LOCK TABLES `active_watchers`
WRITE ;
38 /*!40000 ALTER TABLE `active_watchers` DISABLE KEYS */ ;
39 /*!40000 ALTER TABLE `active_watchers` ENABLE KEYS */ ;
43 -- Dumping data for table `address`
46 LOCK TABLES `address`
WRITE ;
47 /*!40000 ALTER TABLE `address` DISABLE KEYS */ ;
48 /*!40000 ALTER TABLE `address` ENABLE KEYS */ ;
52 -- Dumping data for table `aliases`
55 LOCK TABLES `aliases`
WRITE ;
56 /*!40000 ALTER TABLE `aliases` DISABLE KEYS */ ;
57 /*!40000 ALTER TABLE `aliases` ENABLE KEYS */ ;
61 -- Dumping data for table `carrier_name`
64 LOCK TABLES `carrier_name`
WRITE ;
65 /*!40000 ALTER TABLE `carrier_name` DISABLE KEYS */ ;
66 /*!40000 ALTER TABLE `carrier_name` ENABLE KEYS */ ;
70 -- Dumping data for table `carrierfailureroute`
73 LOCK TABLES `carrierfailureroute`
WRITE ;
74 /*!40000 ALTER TABLE `carrierfailureroute` DISABLE KEYS */ ;
75 /*!40000 ALTER TABLE `carrierfailureroute` ENABLE KEYS */ ;
79 -- Dumping data for table `carrierroute`
82 LOCK TABLES `carrierroute`
WRITE ;
83 /*!40000 ALTER TABLE `carrierroute` DISABLE KEYS */ ;
84 /*!40000 ALTER TABLE `carrierroute` ENABLE KEYS */ ;
88 -- Dumping data for table `cdrs`
91 LOCK TABLES `cdrs`
WRITE ;
92 /*!40000 ALTER TABLE `cdrs` DISABLE KEYS */ ;
93 /*!40000 ALTER TABLE `cdrs` ENABLE KEYS */ ;
97 -- Dumping data for table `cpl`
100 LOCK TABLES `cpl`
WRITE ;
101 /*!40000 ALTER TABLE `cpl` DISABLE KEYS */ ;
102 /*!40000 ALTER TABLE `cpl` ENABLE KEYS */ ;
106 -- Dumping data for table `custom_authorization`
109 LOCK TABLES `custom_authorization`
WRITE ;
110 /*!40000 ALTER TABLE `custom_authorization` DISABLE KEYS */ ;
111 /*!40000 ALTER TABLE `custom_authorization` ENABLE KEYS */ ;
115 -- Dumping data for table `dbaliases`
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 */ ;
125 -- Dumping data for table `dialog`
128 LOCK TABLES `dialog`
WRITE ;
129 /*!40000 ALTER TABLE `dialog` DISABLE KEYS */ ;
130 /*!40000 ALTER TABLE `dialog` ENABLE KEYS */ ;
134 -- Dumping data for table `dialplan`
137 LOCK TABLES `dialplan`
WRITE ;
138 /*!40000 ALTER TABLE `dialplan` DISABLE KEYS */ ;
139 /*!40000 ALTER TABLE `dialplan` ENABLE KEYS */ ;
143 -- Dumping data for table `dispatcher`
146 LOCK TABLES `dispatcher`
WRITE ;
147 /*!40000 ALTER TABLE `dispatcher` DISABLE KEYS */ ;
148 /*!40000 ALTER TABLE `dispatcher` ENABLE KEYS */ ;
152 -- Dumping data for table `domain`
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 */ ;
162 -- Dumping data for table `domain_name`
165 LOCK TABLES `domain_name`
WRITE ;
166 /*!40000 ALTER TABLE `domain_name` DISABLE KEYS */ ;
167 /*!40000 ALTER TABLE `domain_name` ENABLE KEYS */ ;
171 -- Dumping data for table `domainpolicy`
174 LOCK TABLES `domainpolicy`
WRITE ;
175 /*!40000 ALTER TABLE `domainpolicy` DISABLE KEYS */ ;
176 /*!40000 ALTER TABLE `domainpolicy` ENABLE KEYS */ ;
180 -- Dumping data for table `globalblacklist`
183 LOCK TABLES `globalblacklist`
WRITE ;
184 /*!40000 ALTER TABLE `globalblacklist` DISABLE KEYS */ ;
185 /*!40000 ALTER TABLE `globalblacklist` ENABLE KEYS */ ;
189 -- Dumping data for table `grp`
192 LOCK TABLES `grp`
WRITE ;
193 /*!40000 ALTER TABLE `grp` DISABLE KEYS */ ;
194 /*!40000 ALTER TABLE `grp` ENABLE KEYS */ ;
198 -- Dumping data for table `htable`
201 LOCK TABLES `htable`
WRITE ;
202 /*!40000 ALTER TABLE `htable` DISABLE KEYS */ ;
203 /*!40000 ALTER TABLE `htable` ENABLE KEYS */ ;
207 -- Dumping data for table `imc_members`
210 LOCK TABLES `imc_members`
WRITE ;
211 /*!40000 ALTER TABLE `imc_members` DISABLE KEYS */ ;
212 /*!40000 ALTER TABLE `imc_members` ENABLE KEYS */ ;
216 -- Dumping data for table `imc_rooms`
219 LOCK TABLES `imc_rooms`
WRITE ;
220 /*!40000 ALTER TABLE `imc_rooms` DISABLE KEYS */ ;
221 /*!40000 ALTER TABLE `imc_rooms` ENABLE KEYS */ ;
225 -- Dumping data for table `lcr_gw`
228 LOCK TABLES `lcr_gw`
WRITE ;
229 /*!40000 ALTER TABLE `lcr_gw` DISABLE KEYS */ ;
230 /*!40000 ALTER TABLE `lcr_gw` ENABLE KEYS */ ;
234 -- Dumping data for table `lcr_rule`
237 LOCK TABLES `lcr_rule`
WRITE ;
238 /*!40000 ALTER TABLE `lcr_rule` DISABLE KEYS */ ;
239 /*!40000 ALTER TABLE `lcr_rule` ENABLE KEYS */ ;
243 -- Dumping data for table `lcr_rule_target`
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 */ ;
252 -- Dumping data for table `location`
255 LOCK TABLES `
location `
WRITE ;
256 /*!40000 ALTER TABLE `location` DISABLE KEYS */ ;
257 /*!40000 ALTER TABLE `location` ENABLE KEYS */ ;
261 -- Dumping data for table `missed_calls`
264 LOCK TABLES `missed_calls`
WRITE ;
265 /*!40000 ALTER TABLE `missed_calls` DISABLE KEYS */ ;
266 /*!40000 ALTER TABLE `missed_calls` ENABLE KEYS */ ;
270 -- Dumping data for table `pdt`
273 LOCK TABLES `pdt`
WRITE ;
274 /*!40000 ALTER TABLE `pdt` DISABLE KEYS */ ;
275 /*!40000 ALTER TABLE `pdt` ENABLE KEYS */ ;
279 -- Dumping data for table `presentity`
282 LOCK TABLES `presentity`
WRITE ;
283 /*!40000 ALTER TABLE `presentity` DISABLE KEYS */ ;
284 /*!40000 ALTER TABLE `presentity` ENABLE KEYS */ ;
288 -- Dumping data for table `pua`
291 LOCK TABLES `pua`
WRITE ;
292 /*!40000 ALTER TABLE `pua` DISABLE KEYS */ ;
293 /*!40000 ALTER TABLE `pua` ENABLE KEYS */ ;
297 -- Dumping data for table `purplemap`
300 LOCK TABLES `purplemap`
WRITE ;
301 /*!40000 ALTER TABLE `purplemap` DISABLE KEYS */ ;
302 /*!40000 ALTER TABLE `purplemap` ENABLE KEYS */ ;
306 -- Dumping data for table `re_grp`
309 LOCK TABLES `re_grp`
WRITE ;
310 /*!40000 ALTER TABLE `re_grp` DISABLE KEYS */ ;
311 /*!40000 ALTER TABLE `re_grp` ENABLE KEYS */ ;
315 -- Dumping data for table `rls_presentity`
318 LOCK TABLES `rls_presentity`
WRITE ;
319 /*!40000 ALTER TABLE `rls_presentity` DISABLE KEYS */ ;
320 /*!40000 ALTER TABLE `rls_presentity` ENABLE KEYS */ ;
324 -- Dumping data for table `rls_watchers`
327 LOCK TABLES `rls_watchers`
WRITE ;
328 /*!40000 ALTER TABLE `rls_watchers` DISABLE KEYS */ ;
329 /*!40000 ALTER TABLE `rls_watchers` ENABLE KEYS */ ;
333 -- Dumping data for table `silo`
336 LOCK TABLES `silo`
WRITE ;
337 /*!40000 ALTER TABLE `silo` DISABLE KEYS */ ;
338 /*!40000 ALTER TABLE `silo` ENABLE KEYS */ ;
342 -- Dumping data for table `sip_trace`
345 LOCK TABLES `sip_trace`
WRITE ;
346 /*!40000 ALTER TABLE `sip_trace` DISABLE KEYS */ ;
347 /*!40000 ALTER TABLE `sip_trace` ENABLE KEYS */ ;
351 -- Dumping data for table `speed_dial`
354 LOCK TABLES `speed_dial`
WRITE ;
355 /*!40000 ALTER TABLE `speed_dial` DISABLE KEYS */ ;
356 /*!40000 ALTER TABLE `speed_dial` ENABLE KEYS */ ;
360 -- Dumping data for table `statistics`
363 LOCK TABLES `
statistics `
WRITE ;
364 /*!40000 ALTER TABLE `statistics` DISABLE KEYS */ ;
365 /*!40000 ALTER TABLE `statistics` ENABLE KEYS */ ;
369 -- Dumping data for table `subscriber`
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 */ ;
379 -- Dumping data for table `trusted`
382 LOCK TABLES `
trusted `
WRITE ;
383 /*!40000 ALTER TABLE `trusted` DISABLE KEYS */ ;
384 /*!40000 ALTER TABLE `trusted` ENABLE KEYS */ ;
388 -- Dumping data for table `uri`
391 LOCK TABLES `
uri `
WRITE ;
392 /*!40000 ALTER TABLE `uri` DISABLE KEYS */ ;
393 /*!40000 ALTER TABLE `uri` ENABLE KEYS */ ;
397 -- Dumping data for table `userblacklist`
400 LOCK TABLES `userblacklist`
WRITE ;
401 /*!40000 ALTER TABLE `userblacklist` DISABLE KEYS */ ;
402 /*!40000 ALTER TABLE `userblacklist` ENABLE KEYS */ ;
406 -- Dumping data for table `usr_preferences`
409 LOCK TABLES `usr_preferences`
WRITE ;
410 /*!40000 ALTER TABLE `usr_preferences` DISABLE KEYS */ ;
411 /*!40000 ALTER TABLE `usr_preferences` ENABLE KEYS */ ;
415 -- Dumping data for table `version`
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 */ ;
425 -- Dumping data for table `watchers`
428 LOCK TABLES `watchers`
WRITE ;
429 /*!40000 ALTER TABLE `watchers` DISABLE KEYS */ ;
430 /*!40000 ALTER TABLE `watchers` ENABLE KEYS */ ;
434 -- Dumping data for table `xcap`
437 LOCK TABLES `xcap`
WRITE ;
438 /*!40000 ALTER TABLE `xcap` DISABLE KEYS */ ;
439 /*!40000 ALTER TABLE `xcap` ENABLE KEYS */ ;
443 -- Current Database: `provision`
449 -- Dumping data for table `number_pool`
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 */ ;
459 -- Dumping data for table `phones`
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 */ ;
469 -- Dumping data for table `servers`
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 );
475 /*!40000 ALTER TABLE `servers` ENABLE KEYS */ ;
479 -- Dumping data for table `users`
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 */ ;
487 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */ ;
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 */ ;
497 -- Dump completed on 2012-01-17 17:21:45