git.defcon.no Git - hermes/blob - 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: `hermes`
 444 --
 445
 446 USE `hermes`;
 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,'http://pbx.example.com/hermes/prov/');
 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