git.defcon.no Git - hermes/blob - doc/sql-data/structure.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 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kamailio` /*!40100 DEFAULT CHARACTER SET latin1 */;
  23
  24 USE `kamailio`;
  25
  26 --
  27 -- Table structure for table `acc`
  28 --
  29
  30 DROP TABLE IF EXISTS `acc`;
  31 SET @saved_cs_client     = @@character_set_client;
  32 SET character_set_client = utf8;
  33 CREATE TABLE `acc` (
  34   `id` int(10) unsigned NOT NULL auto_increment,
  35   `method` varchar(16) NOT NULL default '',
  36   `from_tag` varchar(64) NOT NULL default '',
  37   `to_tag` varchar(64) NOT NULL default '',
  38   `callid` varchar(128) NOT NULL default '',
  39   `sip_code` char(3) NOT NULL default '',
  40   `sip_reason` varchar(32) NOT NULL default '',
  41   `time` datetime NOT NULL default '0000-00-00 00:00:00',
  42   `src_ip` varchar(64) NOT NULL default '',
  43   `dst_user` varchar(64) NOT NULL default '',
  44   `dst_domain` varchar(128) NOT NULL default '',
  45   `src_user` varchar(64) NOT NULL default '',
  46   `src_domain` varchar(128) NOT NULL default '',
  47   `cdr_id` int(11) NOT NULL default '0',
  48   `dst_ouser` varchar(64) NOT NULL default '',
  49   PRIMARY KEY  (`id`),
  50   KEY `acc_callid` (`callid`)
  51 ) ENGINE=MyISAM AUTO_INCREMENT=8086 DEFAULT CHARSET=latin1;
  52 SET character_set_client = @saved_cs_client;
  53
  54 --
  55 -- Table structure for table `active_watchers`
  56 --
  57
  58 DROP TABLE IF EXISTS `active_watchers`;
  59 SET @saved_cs_client     = @@character_set_client;
  60 SET character_set_client = utf8;
  61 CREATE TABLE `active_watchers` (
  62   `id` int(10) unsigned NOT NULL auto_increment,
  63   `presentity_uri` varchar(128) NOT NULL,
  64   `watcher_username` varchar(64) NOT NULL,
  65   `watcher_domain` varchar(64) NOT NULL,
  66   `to_user` varchar(64) NOT NULL,
  67   `to_domain` varchar(64) NOT NULL,
  68   `event` varchar(64) NOT NULL default 'presence',
  69   `event_id` varchar(64) default NULL,
  70   `to_tag` varchar(64) NOT NULL,
  71   `from_tag` varchar(64) NOT NULL,
  72   `callid` varchar(64) NOT NULL,
  73   `local_cseq` int(11) NOT NULL,
  74   `remote_cseq` int(11) NOT NULL,
  75   `contact` varchar(64) NOT NULL,
  76   `record_route` text,
  77   `expires` int(11) NOT NULL,
  78   `status` int(11) NOT NULL default '2',
  79   `reason` varchar(64) NOT NULL,
  80   `version` int(11) NOT NULL default '0',
  81   `socket_info` varchar(64) NOT NULL,
  82   `local_contact` varchar(128) NOT NULL,
  83   PRIMARY KEY  (`id`),
  84   UNIQUE KEY `active_watchers_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
  85 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  86 SET character_set_client = @saved_cs_client;
  87
  88 --
  89 -- Table structure for table `address`
  90 --
  91
  92 DROP TABLE IF EXISTS `address`;
  93 SET @saved_cs_client     = @@character_set_client;
  94 SET character_set_client = utf8;
  95 CREATE TABLE `address` (
  96   `id` int(10) unsigned NOT NULL auto_increment,
  97   `grp` smallint(5) unsigned NOT NULL default '1',
  98   `ip_addr` varchar(15) NOT NULL,
  99   `mask` tinyint(4) NOT NULL default '32',
 100   `port` smallint(5) unsigned NOT NULL default '0',
 101   `tag` varchar(64) default NULL,
 102   PRIMARY KEY  (`id`)
 103 ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
 104 SET character_set_client = @saved_cs_client;
 105
 106 --
 107 -- Table structure for table `aliases`
 108 --
 109
 110 DROP TABLE IF EXISTS `aliases`;
 111 SET @saved_cs_client     = @@character_set_client;
 112 SET character_set_client = utf8;
 113 CREATE TABLE `aliases` (
 114   `id` int(10) unsigned NOT NULL auto_increment,
 115   `username` varchar(64) NOT NULL default '',
 116   `domain` varchar(64) default NULL,
 117   `contact` varchar(255) NOT NULL default '',
 118   `received` varchar(128) default NULL,
 119   `path` varchar(128) default NULL,
 120   `expires` datetime NOT NULL default '2020-05-28 21:32:15',
 121   `q` float(10,2) NOT NULL default '1.00',
 122   `callid` varchar(255) NOT NULL default 'Default-Call-ID',
 123   `cseq` int(11) NOT NULL default '13',
 124   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 125   `flags` int(11) NOT NULL default '0',
 126   `cflags` int(11) NOT NULL default '0',
 127   `user_agent` varchar(255) NOT NULL default '',
 128   `socket` varchar(64) default NULL,
 129   `methods` int(11) default NULL,
 130   PRIMARY KEY  (`id`),
 131   KEY `alias_idx` (`username`,`domain`,`contact`)
 132 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
 133 SET character_set_client = @saved_cs_client;
 134
 135 --
 136 -- Table structure for table `carrier_name`
 137 --
 138
 139 DROP TABLE IF EXISTS `carrier_name`;
 140 SET @saved_cs_client     = @@character_set_client;
 141 SET character_set_client = utf8;
 142 CREATE TABLE `carrier_name` (
 143   `id` int(10) unsigned NOT NULL auto_increment,
 144   `carrier` varchar(64) default NULL,
 145   PRIMARY KEY  (`id`)
 146 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 147 SET character_set_client = @saved_cs_client;
 148
 149 --
 150 -- Table structure for table `carrierfailureroute`
 151 --
 152
 153 DROP TABLE IF EXISTS `carrierfailureroute`;
 154 SET @saved_cs_client     = @@character_set_client;
 155 SET character_set_client = utf8;
 156 CREATE TABLE `carrierfailureroute` (
 157   `id` int(10) unsigned NOT NULL auto_increment,
 158   `carrier` int(10) unsigned NOT NULL default '0',
 159   `domain` int(10) unsigned NOT NULL default '0',
 160   `scan_prefix` varchar(64) NOT NULL default '',
 161   `host_name` varchar(128) NOT NULL default '',
 162   `reply_code` varchar(3) NOT NULL default '',
 163   `flags` int(11) unsigned NOT NULL default '0',
 164   `mask` int(11) unsigned NOT NULL default '0',
 165   `next_domain` int(10) unsigned NOT NULL default '0',
 166   `description` varchar(255) default NULL,
 167   PRIMARY KEY  (`id`)
 168 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 169 SET character_set_client = @saved_cs_client;
 170
 171 --
 172 -- Table structure for table `carrierroute`
 173 --
 174
 175 DROP TABLE IF EXISTS `carrierroute`;
 176 SET @saved_cs_client     = @@character_set_client;
 177 SET character_set_client = utf8;
 178 CREATE TABLE `carrierroute` (
 179   `id` int(10) unsigned NOT NULL auto_increment,
 180   `carrier` int(10) unsigned NOT NULL default '0',
 181   `domain` int(10) unsigned NOT NULL default '0',
 182   `scan_prefix` varchar(64) NOT NULL default '',
 183   `flags` int(11) unsigned NOT NULL default '0',
 184   `mask` int(11) unsigned NOT NULL default '0',
 185   `prob` float NOT NULL default '0',
 186   `strip` int(11) unsigned NOT NULL default '0',
 187   `rewrite_host` varchar(128) NOT NULL default '',
 188   `rewrite_prefix` varchar(64) NOT NULL default '',
 189   `rewrite_suffix` varchar(64) NOT NULL default '',
 190   `description` varchar(255) default NULL,
 191   PRIMARY KEY  (`id`)
 192 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 193 SET character_set_client = @saved_cs_client;
 194
 195 --
 196 -- Table structure for table `cdrs`
 197 --
 198
 199 DROP TABLE IF EXISTS `cdrs`;
 200 SET @saved_cs_client     = @@character_set_client;
 201 SET character_set_client = utf8;
 202 CREATE TABLE `cdrs` (
 203   `cdr_id` bigint(20) NOT NULL auto_increment,
 204   `src_username` varchar(64) NOT NULL default '',
 205   `src_domain` varchar(128) NOT NULL default '',
 206   `dst_username` varchar(64) NOT NULL default '',
 207   `dst_domain` varchar(128) NOT NULL default '',
 208   `call_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
 209   `duration` int(10) unsigned NOT NULL default '0',
 210   `sip_call_id` varchar(128) NOT NULL default '',
 211   `sip_from_tag` varchar(128) NOT NULL default '',
 212   `sip_to_tag` varchar(128) NOT NULL default '',
 213   `src_ip` varchar(64) NOT NULL default '',
 214   `cost` int(11) NOT NULL default '0',
 215   `rated` int(11) NOT NULL default '0',
 216   `created` datetime NOT NULL,
 217   PRIMARY KEY  (`cdr_id`),
 218   UNIQUE KEY `uk_cft` (`sip_call_id`,`sip_from_tag`,`sip_to_tag`)
 219 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 220 SET character_set_client = @saved_cs_client;
 221
 222 --
 223 -- Table structure for table `cpl`
 224 --
 225
 226 DROP TABLE IF EXISTS `cpl`;
 227 SET @saved_cs_client     = @@character_set_client;
 228 SET character_set_client = utf8;
 229 CREATE TABLE `cpl` (
 230   `id` int(10) unsigned NOT NULL auto_increment,
 231   `username` varchar(64) NOT NULL,
 232   `domain` varchar(64) NOT NULL default '',
 233   `cpl_xml` text,
 234   `cpl_bin` text,
 235   PRIMARY KEY  (`id`),
 236   UNIQUE KEY `account_idx` (`username`,`domain`)
 237 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 238 SET character_set_client = @saved_cs_client;
 239
 240 --
 241 -- Table structure for table `custom_authorization`
 242 --
 243
 244 DROP TABLE IF EXISTS `custom_authorization`;
 245 SET @saved_cs_client     = @@character_set_client;
 246 SET character_set_client = utf8;
 247 CREATE TABLE `custom_authorization` (
 248   `id` int(11) NOT NULL auto_increment,
 249   `username` varchar(64) NOT NULL,
 250   `permitedcalls` smallint(6) NOT NULL default '30',
 251   PRIMARY KEY  (`id`)
 252 ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 253 SET character_set_client = @saved_cs_client;
 254
 255 --
 256 -- Table structure for table `dbaliases`
 257 --
 258
 259 DROP TABLE IF EXISTS `dbaliases`;
 260 SET @saved_cs_client     = @@character_set_client;
 261 SET character_set_client = utf8;
 262 CREATE TABLE `dbaliases` (
 263   `id` int(10) unsigned NOT NULL auto_increment,
 264   `alias_username` varchar(64) NOT NULL default '',
 265   `alias_domain` varchar(64) NOT NULL default '',
 266   `username` varchar(64) NOT NULL default '',
 267   `domain` varchar(64) NOT NULL default '',
 268   PRIMARY KEY  (`id`),
 269   UNIQUE KEY `alias_idx` (`alias_username`,`alias_domain`),
 270   KEY `target_idx` (`username`,`domain`)
 271 ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
 272 SET character_set_client = @saved_cs_client;
 273
 274 --
 275 -- Table structure for table `dialog`
 276 --
 277
 278 DROP TABLE IF EXISTS `dialog`;
 279 SET @saved_cs_client     = @@character_set_client;
 280 SET character_set_client = utf8;
 281 CREATE TABLE `dialog` (
 282   `id` int(10) unsigned NOT NULL auto_increment,
 283   `hash_entry` int(10) unsigned NOT NULL,
 284   `hash_id` int(10) unsigned NOT NULL,
 285   `callid` varchar(255) NOT NULL,
 286   `from_uri` varchar(128) NOT NULL,
 287   `from_tag` varchar(64) NOT NULL,
 288   `to_uri` varchar(128) NOT NULL,
 289   `to_tag` varchar(64) NOT NULL,
 290   `caller_cseq` varchar(7) NOT NULL,
 291   `callee_cseq` varchar(7) NOT NULL,
 292   `caller_route_set` varchar(512) default NULL,
 293   `callee_route_set` varchar(512) default NULL,
 294   `caller_contact` varchar(128) NOT NULL,
 295   `callee_contact` varchar(128) NOT NULL,
 296   `caller_sock` varchar(64) NOT NULL,
 297   `callee_sock` varchar(64) NOT NULL,
 298   `state` int(10) unsigned NOT NULL,
 299   `start_time` int(10) unsigned NOT NULL,
 300   `timeout` int(10) unsigned NOT NULL default '0',
 301   `sflags` int(10) unsigned NOT NULL default '0',
 302   `toroute` int(10) unsigned NOT NULL default '0',
 303   `toroute_name` varchar(32) default NULL,
 304   `req_uri` varchar(128) NOT NULL,
 305   PRIMARY KEY  (`id`),
 306   KEY `hash_idx` (`hash_entry`,`hash_id`)
 307 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 308 SET character_set_client = @saved_cs_client;
 309
 310 --
 311 -- Table structure for table `dialplan`
 312 --
 313
 314 DROP TABLE IF EXISTS `dialplan`;
 315 SET @saved_cs_client     = @@character_set_client;
 316 SET character_set_client = utf8;
 317 CREATE TABLE `dialplan` (
 318   `id` int(10) unsigned NOT NULL auto_increment,
 319   `dpid` int(11) NOT NULL,
 320   `pr` int(11) NOT NULL,
 321   `match_op` int(11) NOT NULL,
 322   `match_exp` varchar(64) NOT NULL,
 323   `match_len` int(11) NOT NULL,
 324   `subst_exp` varchar(64) NOT NULL,
 325   `repl_exp` varchar(32) NOT NULL,
 326   `attrs` varchar(32) NOT NULL,
 327   PRIMARY KEY  (`id`)
 328 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 329 SET character_set_client = @saved_cs_client;
 330
 331 --
 332 -- Table structure for table `dispatcher`
 333 --
 334
 335 DROP TABLE IF EXISTS `dispatcher`;
 336 SET @saved_cs_client     = @@character_set_client;
 337 SET character_set_client = utf8;
 338 CREATE TABLE `dispatcher` (
 339   `id` int(10) unsigned NOT NULL auto_increment,
 340   `setid` int(11) NOT NULL default '0',
 341   `destination` varchar(192) NOT NULL default '',
 342   `flags` int(11) NOT NULL default '0',
 343   `priority` int(11) NOT NULL default '0',
 344   `attrs` varchar(128) NOT NULL default '',
 345   `description` varchar(64) NOT NULL default '',
 346   PRIMARY KEY  (`id`)
 347 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 348 SET character_set_client = @saved_cs_client;
 349
 350 --
 351 -- Table structure for table `domain`
 352 --
 353
 354 DROP TABLE IF EXISTS `domain`;
 355 SET @saved_cs_client     = @@character_set_client;
 356 SET character_set_client = utf8;
 357 CREATE TABLE `domain` (
 358   `id` int(10) unsigned NOT NULL auto_increment,
 359   `domain` varchar(64) NOT NULL default '',
 360   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 361   PRIMARY KEY  (`id`),
 362   UNIQUE KEY `domain_idx` (`domain`)
 363 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
 364 SET character_set_client = @saved_cs_client;
 365
 366 --
 367 -- Table structure for table `domain_name`
 368 --
 369
 370 DROP TABLE IF EXISTS `domain_name`;
 371 SET @saved_cs_client     = @@character_set_client;
 372 SET character_set_client = utf8;
 373 CREATE TABLE `domain_name` (
 374   `id` int(10) unsigned NOT NULL auto_increment,
 375   `domain` varchar(64) default NULL,
 376   PRIMARY KEY  (`id`)
 377 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 378 SET character_set_client = @saved_cs_client;
 379
 380 --
 381 -- Table structure for table `domainpolicy`
 382 --
 383
 384 DROP TABLE IF EXISTS `domainpolicy`;
 385 SET @saved_cs_client     = @@character_set_client;
 386 SET character_set_client = utf8;
 387 CREATE TABLE `domainpolicy` (
 388   `id` int(10) unsigned NOT NULL auto_increment,
 389   `rule` varchar(255) NOT NULL,
 390   `type` varchar(255) NOT NULL,
 391   `att` varchar(255) default NULL,
 392   `val` varchar(128) default NULL,
 393   `description` varchar(255) NOT NULL,
 394   PRIMARY KEY  (`id`),
 395   UNIQUE KEY `rav_idx` (`rule`,`att`,`val`),
 396   KEY `rule_idx` (`rule`)
 397 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 398 SET character_set_client = @saved_cs_client;
 399
 400 --
 401 -- Table structure for table `globalblacklist`
 402 --
 403
 404 DROP TABLE IF EXISTS `globalblacklist`;
 405 SET @saved_cs_client     = @@character_set_client;
 406 SET character_set_client = utf8;
 407 CREATE TABLE `globalblacklist` (
 408   `id` int(10) unsigned NOT NULL auto_increment,
 409   `prefix` varchar(64) NOT NULL default '',
 410   `whitelist` tinyint(1) NOT NULL default '0',
 411   `description` varchar(255) default NULL,
 412   PRIMARY KEY  (`id`),
 413   KEY `globalblacklist_idx` (`prefix`)
 414 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 415 SET character_set_client = @saved_cs_client;
 416
 417 --
 418 -- Table structure for table `grp`
 419 --
 420
 421 DROP TABLE IF EXISTS `grp`;
 422 SET @saved_cs_client     = @@character_set_client;
 423 SET character_set_client = utf8;
 424 CREATE TABLE `grp` (
 425   `id` int(10) unsigned NOT NULL auto_increment,
 426   `username` varchar(64) NOT NULL default '',
 427   `domain` varchar(64) NOT NULL default '',
 428   `grp` varchar(64) NOT NULL default '',
 429   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 430   PRIMARY KEY  (`id`),
 431   UNIQUE KEY `account_group_idx` (`username`,`domain`,`grp`)
 432 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 433 SET character_set_client = @saved_cs_client;
 434
 435 --
 436 -- Table structure for table `htable`
 437 --
 438
 439 DROP TABLE IF EXISTS `htable`;
 440 SET @saved_cs_client     = @@character_set_client;
 441 SET character_set_client = utf8;
 442 CREATE TABLE `htable` (
 443   `id` int(10) unsigned NOT NULL auto_increment,
 444   `key_name` varchar(64) NOT NULL default '',
 445   `key_type` int(11) NOT NULL default '0',
 446   `value_type` int(11) NOT NULL default '0',
 447   `key_value` varchar(128) NOT NULL default '',
 448   PRIMARY KEY  (`id`)
 449 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 450 SET character_set_client = @saved_cs_client;
 451
 452 --
 453 -- Table structure for table `imc_members`
 454 --
 455
 456 DROP TABLE IF EXISTS `imc_members`;
 457 SET @saved_cs_client     = @@character_set_client;
 458 SET character_set_client = utf8;
 459 CREATE TABLE `imc_members` (
 460   `id` int(10) unsigned NOT NULL auto_increment,
 461   `username` varchar(64) NOT NULL,
 462   `domain` varchar(64) NOT NULL,
 463   `room` varchar(64) NOT NULL,
 464   `flag` int(11) NOT NULL,
 465   PRIMARY KEY  (`id`),
 466   UNIQUE KEY `account_room_idx` (`username`,`domain`,`room`)
 467 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 468 SET character_set_client = @saved_cs_client;
 469
 470 --
 471 -- Table structure for table `imc_rooms`
 472 --
 473
 474 DROP TABLE IF EXISTS `imc_rooms`;
 475 SET @saved_cs_client     = @@character_set_client;
 476 SET character_set_client = utf8;
 477 CREATE TABLE `imc_rooms` (
 478   `id` int(10) unsigned NOT NULL auto_increment,
 479   `name` varchar(64) NOT NULL,
 480   `domain` varchar(64) NOT NULL,
 481   `flag` int(11) NOT NULL,
 482   PRIMARY KEY  (`id`),
 483   UNIQUE KEY `name_domain_idx` (`name`,`domain`)
 484 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 485 SET character_set_client = @saved_cs_client;
 486
 487 --
 488 -- Table structure for table `lcr_gw`
 489 --
 490
 491 DROP TABLE IF EXISTS `lcr_gw`;
 492 SET @saved_cs_client     = @@character_set_client;
 493 SET character_set_client = utf8;
 494 CREATE TABLE `lcr_gw` (
 495   `id` int(10) unsigned NOT NULL auto_increment,
 496   `lcr_id` smallint(5) unsigned NOT NULL,
 497   `gw_name` varchar(128) default NULL,
 498   `ip_addr` varchar(15) default NULL,
 499   `hostname` varchar(64) default NULL,
 500   `port` smallint(5) unsigned default NULL,
 501   `params` varchar(64) default NULL,
 502   `uri_scheme` tinyint(3) unsigned default NULL,
 503   `transport` tinyint(3) unsigned default NULL,
 504   `strip` tinyint(3) unsigned default NULL,
 505   `tag` varchar(16) default NULL,
 506   `flags` int(10) unsigned NOT NULL default '0',
 507   `defunct` int(10) unsigned default NULL,
 508   PRIMARY KEY  (`id`),
 509   UNIQUE KEY `lcr_id_ip_addr_port_hostname_idx` (`lcr_id`,`ip_addr`,`port`,`hostname`)
 510 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 511 SET character_set_client = @saved_cs_client;
 512
 513 --
 514 -- Table structure for table `lcr_rule`
 515 --
 516
 517 DROP TABLE IF EXISTS `lcr_rule`;
 518 SET @saved_cs_client     = @@character_set_client;
 519 SET character_set_client = utf8;
 520 CREATE TABLE `lcr_rule` (
 521   `id` int(10) unsigned NOT NULL auto_increment,
 522   `lcr_id` smallint(5) unsigned NOT NULL,
 523   `prefix` varchar(16) default NULL,
 524   `from_uri` varchar(64) default NULL,
 525   `stopper` int(10) unsigned NOT NULL default '0',
 526   `enabled` int(10) unsigned NOT NULL default '1',
 527   PRIMARY KEY  (`id`),
 528   UNIQUE KEY `lcr_id_prefix_from_uri_idx` (`lcr_id`,`prefix`,`from_uri`)
 529 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 530 SET character_set_client = @saved_cs_client;
 531
 532 --
 533 -- Table structure for table `lcr_rule_target`
 534 --
 535
 536 DROP TABLE IF EXISTS `lcr_rule_target`;
 537 SET @saved_cs_client     = @@character_set_client;
 538 SET character_set_client = utf8;
 539 CREATE TABLE `lcr_rule_target` (
 540   `id` int(10) unsigned NOT NULL auto_increment,
 541   `lcr_id` smallint(5) unsigned NOT NULL,
 542   `rule_id` int(10) unsigned NOT NULL,
 543   `gw_id` int(10) unsigned NOT NULL,
 544   `priority` tinyint(3) unsigned NOT NULL,
 545   `weight` int(10) unsigned NOT NULL default '1',
 546   PRIMARY KEY  (`id`),
 547   UNIQUE KEY `rule_id_gw_id_idx` (`rule_id`,`gw_id`),
 548   KEY `lcr_id_idx` (`lcr_id`)
 549 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 550 SET character_set_client = @saved_cs_client;
 551
 552 --
 553 -- Table structure for table `location`
 554 --
 555
 556 DROP TABLE IF EXISTS `location`;
 557 SET @saved_cs_client     = @@character_set_client;
 558 SET character_set_client = utf8;
 559 CREATE TABLE `location` (
 560   `id` int(10) unsigned NOT NULL auto_increment,
 561   `username` varchar(64) NOT NULL default '',
 562   `domain` varchar(64) default NULL,
 563   `contact` varchar(255) NOT NULL default '',
 564   `received` varchar(128) default NULL,
 565   `path` varchar(128) default NULL,
 566   `expires` datetime NOT NULL default '2020-05-28 21:32:15',
 567   `q` float(10,2) NOT NULL default '1.00',
 568   `callid` varchar(255) NOT NULL default 'Default-Call-ID',
 569   `cseq` int(11) NOT NULL default '13',
 570   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 571   `flags` int(11) NOT NULL default '0',
 572   `cflags` int(11) NOT NULL default '0',
 573   `user_agent` varchar(255) NOT NULL default '',
 574   `socket` varchar(64) default NULL,
 575   `methods` int(11) default NULL,
 576   PRIMARY KEY  (`id`),
 577   KEY `account_contact_idx` (`username`,`domain`,`contact`)
 578 ) ENGINE=MyISAM AUTO_INCREMENT=3088 DEFAULT CHARSET=latin1;
 579 SET character_set_client = @saved_cs_client;
 580
 581 --
 582 -- Table structure for table `missed_calls`
 583 --
 584
 585 DROP TABLE IF EXISTS `missed_calls`;
 586 SET @saved_cs_client     = @@character_set_client;
 587 SET character_set_client = utf8;
 588 CREATE TABLE `missed_calls` (
 589   `id` int(10) unsigned NOT NULL auto_increment,
 590   `method` varchar(16) NOT NULL default '',
 591   `from_tag` varchar(64) NOT NULL default '',
 592   `to_tag` varchar(64) NOT NULL default '',
 593   `callid` varchar(128) NOT NULL default '',
 594   `sip_code` char(3) NOT NULL default '',
 595   `sip_reason` varchar(32) NOT NULL default '',
 596   `time` datetime NOT NULL default '0000-00-00 00:00:00',
 597   `src_ip` varchar(64) NOT NULL default '',
 598   `dst_user` varchar(64) NOT NULL default '',
 599   `dst_domain` varchar(128) NOT NULL default '',
 600   `src_user` varchar(64) NOT NULL default '',
 601   `src_domain` varchar(128) NOT NULL default '',
 602   `cdr_id` int(11) NOT NULL default '0',
 603   `dst_ouser` varchar(64) NOT NULL default '',
 604   PRIMARY KEY  (`id`),
 605   KEY `mc_callid` (`callid`)
 606 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 607 SET character_set_client = @saved_cs_client;
 608
 609 --
 610 -- Table structure for table `pdt`
 611 --
 612
 613 DROP TABLE IF EXISTS `pdt`;
 614 SET @saved_cs_client     = @@character_set_client;
 615 SET character_set_client = utf8;
 616 CREATE TABLE `pdt` (
 617   `id` int(10) unsigned NOT NULL auto_increment,
 618   `sdomain` varchar(128) NOT NULL,
 619   `prefix` varchar(32) NOT NULL,
 620   `domain` varchar(128) NOT NULL default '',
 621   PRIMARY KEY  (`id`),
 622   UNIQUE KEY `sdomain_prefix_idx` (`sdomain`,`prefix`)
 623 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 624 SET character_set_client = @saved_cs_client;
 625
 626 --
 627 -- Table structure for table `presentity`
 628 --
 629
 630 DROP TABLE IF EXISTS `presentity`;
 631 SET @saved_cs_client     = @@character_set_client;
 632 SET character_set_client = utf8;
 633 CREATE TABLE `presentity` (
 634   `id` int(10) unsigned NOT NULL auto_increment,
 635   `username` varchar(64) NOT NULL,
 636   `domain` varchar(64) NOT NULL,
 637   `event` varchar(64) NOT NULL,
 638   `etag` varchar(64) NOT NULL,
 639   `expires` int(11) NOT NULL,
 640   `received_time` int(11) NOT NULL,
 641   `body` blob NOT NULL,
 642   `sender` varchar(128) NOT NULL,
 643   PRIMARY KEY  (`id`),
 644   UNIQUE KEY `presentity_idx` (`username`,`domain`,`event`,`etag`)
 645 ) ENGINE=MyISAM AUTO_INCREMENT=1289 DEFAULT CHARSET=latin1;
 646 SET character_set_client = @saved_cs_client;
 647
 648 --
 649 -- Table structure for table `pua`
 650 --
 651
 652 DROP TABLE IF EXISTS `pua`;
 653 SET @saved_cs_client     = @@character_set_client;
 654 SET character_set_client = utf8;
 655 CREATE TABLE `pua` (
 656   `id` int(10) unsigned NOT NULL auto_increment,
 657   `pres_uri` varchar(128) NOT NULL,
 658   `pres_id` varchar(64) NOT NULL,
 659   `event` int(11) NOT NULL,
 660   `expires` int(11) NOT NULL,
 661   `desired_expires` int(11) NOT NULL,
 662   `flag` int(11) NOT NULL,
 663   `etag` varchar(64) NOT NULL,
 664   `tuple_id` varchar(64) default NULL,
 665   `watcher_uri` varchar(128) NOT NULL,
 666   `call_id` varchar(64) NOT NULL,
 667   `to_tag` varchar(64) NOT NULL,
 668   `from_tag` varchar(64) NOT NULL,
 669   `cseq` int(11) NOT NULL,
 670   `record_route` text,
 671   `contact` varchar(128) NOT NULL,
 672   `remote_contact` varchar(128) NOT NULL,
 673   `version` int(11) NOT NULL,
 674   `extra_headers` text NOT NULL,
 675   PRIMARY KEY  (`id`)
 676 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 677 SET character_set_client = @saved_cs_client;
 678
 679 --
 680 -- Table structure for table `purplemap`
 681 --
 682
 683 DROP TABLE IF EXISTS `purplemap`;
 684 SET @saved_cs_client     = @@character_set_client;
 685 SET character_set_client = utf8;
 686 CREATE TABLE `purplemap` (
 687   `id` int(10) unsigned NOT NULL auto_increment,
 688   `sip_user` varchar(128) NOT NULL,
 689   `ext_user` varchar(128) NOT NULL,
 690   `ext_prot` varchar(16) NOT NULL,
 691   `ext_pass` varchar(64) default NULL,
 692   PRIMARY KEY  (`id`)
 693 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 694 SET character_set_client = @saved_cs_client;
 695
 696 --
 697 -- Table structure for table `re_grp`
 698 --
 699
 700 DROP TABLE IF EXISTS `re_grp`;
 701 SET @saved_cs_client     = @@character_set_client;
 702 SET character_set_client = utf8;
 703 CREATE TABLE `re_grp` (
 704   `id` int(10) unsigned NOT NULL auto_increment,
 705   `reg_exp` varchar(128) NOT NULL default '',
 706   `group_id` int(11) NOT NULL default '0',
 707   PRIMARY KEY  (`id`),
 708   KEY `group_idx` (`group_id`)
 709 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 710 SET character_set_client = @saved_cs_client;
 711
 712 --
 713 -- Table structure for table `rls_presentity`
 714 --
 715
 716 DROP TABLE IF EXISTS `rls_presentity`;
 717 SET @saved_cs_client     = @@character_set_client;
 718 SET character_set_client = utf8;
 719 CREATE TABLE `rls_presentity` (
 720   `id` int(10) unsigned NOT NULL auto_increment,
 721   `rlsubs_did` varchar(255) NOT NULL,
 722   `resource_uri` varchar(128) NOT NULL,
 723   `content_type` varchar(64) NOT NULL,
 724   `presence_state` blob NOT NULL,
 725   `expires` int(11) NOT NULL,
 726   `updated` int(11) NOT NULL,
 727   `auth_state` int(11) NOT NULL,
 728   `reason` varchar(64) NOT NULL,
 729   PRIMARY KEY  (`id`),
 730   UNIQUE KEY `rls_presentity_idx` (`rlsubs_did`,`resource_uri`),
 731   KEY `updated_idx` (`updated`)
 732 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 733 SET character_set_client = @saved_cs_client;
 734
 735 --
 736 -- Table structure for table `rls_watchers`
 737 --
 738
 739 DROP TABLE IF EXISTS `rls_watchers`;
 740 SET @saved_cs_client     = @@character_set_client;
 741 SET character_set_client = utf8;
 742 CREATE TABLE `rls_watchers` (
 743   `id` int(10) unsigned NOT NULL auto_increment,
 744   `presentity_uri` varchar(128) NOT NULL,
 745   `to_user` varchar(64) NOT NULL,
 746   `to_domain` varchar(64) NOT NULL,
 747   `watcher_username` varchar(64) NOT NULL,
 748   `watcher_domain` varchar(64) NOT NULL,
 749   `event` varchar(64) NOT NULL default 'presence',
 750   `event_id` varchar(64) default NULL,
 751   `to_tag` varchar(64) NOT NULL,
 752   `from_tag` varchar(64) NOT NULL,
 753   `callid` varchar(64) NOT NULL,
 754   `local_cseq` int(11) NOT NULL,
 755   `remote_cseq` int(11) NOT NULL,
 756   `contact` varchar(64) NOT NULL,
 757   `record_route` text,
 758   `expires` int(11) NOT NULL,
 759   `status` int(11) NOT NULL default '2',
 760   `reason` varchar(64) NOT NULL,
 761   `version` int(11) NOT NULL default '0',
 762   `socket_info` varchar(64) NOT NULL,
 763   `local_contact` varchar(128) NOT NULL,
 764   PRIMARY KEY  (`id`),
 765   UNIQUE KEY `rls_watcher_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
 766 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 767 SET character_set_client = @saved_cs_client;
 768
 769 --
 770 -- Table structure for table `silo`
 771 --
 772
 773 DROP TABLE IF EXISTS `silo`;
 774 SET @saved_cs_client     = @@character_set_client;
 775 SET character_set_client = utf8;
 776 CREATE TABLE `silo` (
 777   `id` int(10) unsigned NOT NULL auto_increment,
 778   `src_addr` varchar(128) NOT NULL default '',
 779   `dst_addr` varchar(128) NOT NULL default '',
 780   `username` varchar(64) NOT NULL default '',
 781   `domain` varchar(64) NOT NULL default '',
 782   `inc_time` int(11) NOT NULL default '0',
 783   `exp_time` int(11) NOT NULL default '0',
 784   `snd_time` int(11) NOT NULL default '0',
 785   `ctype` varchar(32) NOT NULL default 'text/plain',
 786   `body` blob NOT NULL,
 787   PRIMARY KEY  (`id`),
 788   KEY `account_idx` (`username`,`domain`)
 789 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 790 SET character_set_client = @saved_cs_client;
 791
 792 --
 793 -- Table structure for table `sip_trace`
 794 --
 795
 796 DROP TABLE IF EXISTS `sip_trace`;
 797 SET @saved_cs_client     = @@character_set_client;
 798 SET character_set_client = utf8;
 799 CREATE TABLE `sip_trace` (
 800   `id` int(10) unsigned NOT NULL auto_increment,
 801   `time_stamp` datetime NOT NULL default '1900-01-01 00:00:01',
 802   `callid` varchar(255) NOT NULL default '',
 803   `traced_user` varchar(128) NOT NULL default '',
 804   `msg` text NOT NULL,
 805   `method` varchar(50) NOT NULL default '',
 806   `status` varchar(128) NOT NULL default '',
 807   `fromip` varchar(50) NOT NULL default '',
 808   `toip` varchar(50) NOT NULL default '',
 809   `fromtag` varchar(64) NOT NULL default '',
 810   `direction` varchar(4) NOT NULL default '',
 811   PRIMARY KEY  (`id`),
 812   KEY `traced_user_idx` (`traced_user`),
 813   KEY `date_idx` (`time_stamp`),
 814   KEY `fromip_idx` (`fromip`),
 815   KEY `callid_idx` (`callid`)
 816 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 817 SET character_set_client = @saved_cs_client;
 818
 819 --
 820 -- Table structure for table `speed_dial`
 821 --
 822
 823 DROP TABLE IF EXISTS `speed_dial`;
 824 SET @saved_cs_client     = @@character_set_client;
 825 SET character_set_client = utf8;
 826 CREATE TABLE `speed_dial` (
 827   `id` int(10) unsigned NOT NULL auto_increment,
 828   `username` varchar(64) NOT NULL default '',
 829   `domain` varchar(64) NOT NULL default '',
 830   `sd_username` varchar(64) NOT NULL default '',
 831   `sd_domain` varchar(64) NOT NULL default '',
 832   `new_uri` varchar(128) NOT NULL default '',
 833   `fname` varchar(64) NOT NULL default '',
 834   `lname` varchar(64) NOT NULL default '',
 835   `description` varchar(64) NOT NULL default '',
 836   PRIMARY KEY  (`id`),
 837   UNIQUE KEY `speed_dial_idx` (`username`,`domain`,`sd_domain`,`sd_username`)
 838 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 839 SET character_set_client = @saved_cs_client;
 840
 841 --
 842 -- Table structure for table `statistics`
 843 --
 844
 845 DROP TABLE IF EXISTS `statistics`;
 846 SET @saved_cs_client     = @@character_set_client;
 847 SET character_set_client = utf8;
 848 CREATE TABLE `statistics` (
 849   `id` int(10) unsigned NOT NULL auto_increment,
 850   `time_stamp` int(10) unsigned NOT NULL default '0',
 851   `shm_used_size` int(10) unsigned NOT NULL default '0',
 852   `shm_real_used_size` int(10) unsigned NOT NULL default '0',
 853   `shm_max_used_size` int(10) unsigned NOT NULL default '0',
 854   `shm_free_used_size` int(10) unsigned NOT NULL default '0',
 855   `ul_users` int(10) unsigned NOT NULL default '0',
 856   `ul_contacts` int(10) unsigned NOT NULL default '0',
 857   PRIMARY KEY  (`id`)
 858 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 859 SET character_set_client = @saved_cs_client;
 860
 861 --
 862 -- Table structure for table `subscriber`
 863 --
 864
 865 DROP TABLE IF EXISTS `subscriber`;
 866 SET @saved_cs_client     = @@character_set_client;
 867 SET character_set_client = utf8;
 868 CREATE TABLE `subscriber` (
 869   `id` int(10) unsigned NOT NULL auto_increment,
 870   `username` varchar(64) NOT NULL default '',
 871   `domain` varchar(64) NOT NULL default '',
 872   `password` varchar(25) NOT NULL default '',
 873   `email_address` varchar(64) NOT NULL default '',
 874   `ha1` varchar(64) NOT NULL default '',
 875   `ha1b` varchar(64) NOT NULL default '',
 876   `rpid` varchar(64) default NULL,
 877   `permitedcalls` smallint(6) default '14',
 878   `permittedcalls` smallint(6) default '14',
 879   PRIMARY KEY  (`id`),
 880   UNIQUE KEY `account_idx` (`username`,`domain`),
 881   KEY `username_idx` (`username`)
 882 ) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
 883 SET character_set_client = @saved_cs_client;
 884
 885 --
 886 -- Table structure for table `trusted`
 887 --
 888
 889 DROP TABLE IF EXISTS `trusted`;
 890 SET @saved_cs_client     = @@character_set_client;
 891 SET character_set_client = utf8;
 892 CREATE TABLE `trusted` (
 893   `id` int(10) unsigned NOT NULL auto_increment,
 894   `src_ip` varchar(50) NOT NULL,
 895   `proto` varchar(4) NOT NULL,
 896   `from_pattern` varchar(64) default NULL,
 897   `tag` varchar(64) default NULL,
 898   PRIMARY KEY  (`id`),
 899   KEY `peer_idx` (`src_ip`)
 900 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 901 SET character_set_client = @saved_cs_client;
 902
 903 --
 904 -- Table structure for table `uri`
 905 --
 906
 907 DROP TABLE IF EXISTS `uri`;
 908 SET @saved_cs_client     = @@character_set_client;
 909 SET character_set_client = utf8;
 910 CREATE TABLE `uri` (
 911   `id` int(10) unsigned NOT NULL auto_increment,
 912   `username` varchar(64) NOT NULL default '',
 913   `domain` varchar(64) NOT NULL default '',
 914   `uri_user` varchar(64) NOT NULL default '',
 915   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 916   PRIMARY KEY  (`id`),
 917   UNIQUE KEY `account_idx` (`username`,`domain`,`uri_user`)
 918 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 919 SET character_set_client = @saved_cs_client;
 920
 921 --
 922 -- Table structure for table `userblacklist`
 923 --
 924
 925 DROP TABLE IF EXISTS `userblacklist`;
 926 SET @saved_cs_client     = @@character_set_client;
 927 SET character_set_client = utf8;
 928 CREATE TABLE `userblacklist` (
 929   `id` int(10) unsigned NOT NULL auto_increment,
 930   `username` varchar(64) NOT NULL default '',
 931   `domain` varchar(64) NOT NULL default '',
 932   `prefix` varchar(64) NOT NULL default '',
 933   `whitelist` tinyint(1) NOT NULL default '0',
 934   PRIMARY KEY  (`id`),
 935   KEY `userblacklist_idx` (`username`,`domain`,`prefix`)
 936 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 937 SET character_set_client = @saved_cs_client;
 938
 939 --
 940 -- Table structure for table `usr_preferences`
 941 --
 942
 943 DROP TABLE IF EXISTS `usr_preferences`;
 944 SET @saved_cs_client     = @@character_set_client;
 945 SET character_set_client = utf8;
 946 CREATE TABLE `usr_preferences` (
 947   `id` int(10) unsigned NOT NULL auto_increment,
 948   `uuid` varchar(64) NOT NULL default '',
 949   `username` varchar(128) NOT NULL default '0',
 950   `domain` varchar(64) NOT NULL default '',
 951   `attribute` varchar(32) NOT NULL default '',
 952   `type` int(11) NOT NULL default '0',
 953   `value` varchar(128) NOT NULL default '',
 954   `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
 955   PRIMARY KEY  (`id`),
 956   KEY `ua_idx` (`uuid`,`attribute`),
 957   KEY `uda_idx` (`username`,`domain`,`attribute`)
 958 ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
 959 SET character_set_client = @saved_cs_client;
 960
 961 --
 962 -- Table structure for table `version`
 963 --
 964
 965 DROP TABLE IF EXISTS `version`;
 966 SET @saved_cs_client     = @@character_set_client;
 967 SET character_set_client = utf8;
 968 CREATE TABLE `version` (
 969   `table_name` varchar(32) NOT NULL,
 970   `table_version` int(10) unsigned NOT NULL default '0'
 971 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 972 SET character_set_client = @saved_cs_client;
 973
 974 --
 975 -- Table structure for table `watchers`
 976 --
 977
 978 DROP TABLE IF EXISTS `watchers`;
 979 SET @saved_cs_client     = @@character_set_client;
 980 SET character_set_client = utf8;
 981 CREATE TABLE `watchers` (
 982   `id` int(10) unsigned NOT NULL auto_increment,
 983   `presentity_uri` varchar(128) NOT NULL,
 984   `watcher_username` varchar(64) NOT NULL,
 985   `watcher_domain` varchar(64) NOT NULL,
 986   `event` varchar(64) NOT NULL default 'presence',
 987   `status` int(11) NOT NULL,
 988   `reason` varchar(64) default NULL,
 989   `inserted_time` int(11) NOT NULL,
 990   PRIMARY KEY  (`id`),
 991   UNIQUE KEY `watcher_idx` (`presentity_uri`,`watcher_username`,`watcher_domain`,`event`)
 992 ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
 993 SET character_set_client = @saved_cs_client;
 994
 995 --
 996 -- Table structure for table `xcap`
 997 --
 998
 999 DROP TABLE IF EXISTS `xcap`;
1000 SET @saved_cs_client     = @@character_set_client;
1001 SET character_set_client = utf8;
1002 CREATE TABLE `xcap` (
1003   `id` int(10) unsigned NOT NULL auto_increment,
1004   `username` varchar(64) NOT NULL,
1005   `domain` varchar(64) NOT NULL,
1006   `doc` blob NOT NULL,
1007   `doc_type` int(11) NOT NULL,
1008   `etag` varchar(64) NOT NULL,
1009   `source` int(11) NOT NULL,
1010   `doc_uri` varchar(128) NOT NULL,
1011   `port` int(11) NOT NULL,
1012   PRIMARY KEY  (`id`),
1013   UNIQUE KEY `account_doc_type_idx` (`username`,`domain`,`doc_type`,`doc_uri`),
1014   KEY `source_idx` (`source`)
1015 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1016 SET character_set_client = @saved_cs_client;
1017
1018 --
1019 -- Current Database: `hermes`
1020 --
1021
1022 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hermes` /*!40100 DEFAULT CHARACTER SET latin1 */;
1023
1024 USE `hermes`;
1025
1026 --
1027 -- Table structure for table `apikeys`
1028 --
1029
1030 CREATE TABLE IF NOT EXISTS `apikeys` (
1031   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1032   `host` varchar(64) NOT NULL,
1033   `apikey` varchar(128) NOT NULL,
1034   PRIMARY KEY  (`apikey`)
1035 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1036
1037 -- --------------------------------------------------------
1038
1039 --
1040 -- Table structure for table `authorizations`
1041 --
1042
1043 DROP TABLE IF EXISTS `authorizations`;
1044 SET @saved_cs_client     = @@character_set_client;
1045 SET character_set_client = utf8;
1046 CREATE TABLE IF NOT EXISTS `authorizations` (
1047   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1048   `authid` varchar(255) NOT NULL,
1049   `type` varchar(16) NOT NULL,
1050   `access_level` int(11) NOT NULL,
1051   PRIMARY KEY  (`authid`)
1052 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1053 SET character_set_client = @saved_cs_client;
1054
1055 --
1056 -- Table structure for table `number_pool`
1057 --
1058
1059 DROP TABLE IF EXISTS `number_pool`;
1060 SET @saved_cs_client     = @@character_set_client;
1061 SET character_set_client = utf8;
1062 CREATE TABLE `number_pool` (
1063   `id` int(11) NOT NULL auto_increment,
1064   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1065   `number` varchar(128) character set utf8 NOT NULL,
1066   PRIMARY KEY  (`id`)
1067 ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
1068 SET character_set_client = @saved_cs_client;
1069
1070 --
1071 -- Table structure for table `phones`
1072 --
1073
1074 DROP TABLE IF EXISTS `phones`;
1075 SET @saved_cs_client     = @@character_set_client;
1076 SET character_set_client = utf8;
1077 CREATE TABLE `phones` (
1078   `id` int(11) NOT NULL auto_increment,
1079   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1080   `mac` varchar(32) character set utf8 NOT NULL,
1081   `user_rel` int(11) NOT NULL,
1082   `ua_type` int(11) default NULL,
1083   PRIMARY KEY  (`id`)
1084 ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
1085 SET character_set_client = @saved_cs_client;
1086
1087 --
1088 -- Table structure for table `servers`
1089 --
1090
1091 DROP TABLE IF EXISTS `servers`;
1092 SET @saved_cs_client     = @@character_set_client;
1093 SET character_set_client = utf8;
1094 CREATE TABLE `servers` (
1095   `id` int(11) NOT NULL auto_increment,
1096   `domain` varchar(255) character set utf8 NOT NULL,
1097   `registrar` varchar(255) character set utf8 default NULL,
1098   `r_port` int(11) default NULL,
1099   `proxy` varchar(255) character set utf8 default NULL,
1100   `p_port` int(11) default NULL,
1101   `prov_url` text,
1102    PRIMARY KEY  (`id`)
1103 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1104 SET character_set_client = @saved_cs_client;
1105
1106 --
1107 -- Table structure for table `sessionkeys`
1108 --
1109
1110 DROP TABLE IF EXISTS `sessionkeys`;
1111 SET @saved_cs_client     = @@character_set_client;
1112 SET character_set_client = utf8;
1113 CREATE TABLE `sessionkeys` (
1114   `sessid` varchar(255) NOT NULL,
1115   `session` varchar(128) NOT NULL,
1116   `authid` varchar(128) NOT NULL,
1117   `client` varchar(255) NOT NULL,
1118   `key` varchar(128) NOT NULL,
1119   `last` datetime default NULL,
1120   PRIMARY KEY  (`session`,`authid`)
1121 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1122 SET character_set_client = @saved_cs_client;
1123
1124 --
1125 -- Table structure for table `users`
1126 --
1127
1128 DROP TABLE IF EXISTS `users`;
1129 SET @saved_cs_client     = @@character_set_client;
1130 SET character_set_client = utf8;
1131 CREATE TABLE `users` (
1132   `id` int(11) NOT NULL auto_increment,
1133   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1134   `username` varchar(128) character set utf8 NOT NULL,
1135   `password` varchar(128) character set utf8 NOT NULL,
1136   `displayname` varchar(255) character set utf8 NOT NULL,
1137   `domain` varchar(255) character set utf8 NOT NULL,
1138   `registrar` varchar(255) character set utf8 default NULL,
1139   `r_port` int(11) default NULL,
1140   `proxy` varchar(255) character set utf8 default NULL,
1141   `p_port` int(11) default NULL,
1142   `authid` varchar(128) character set utf8 default NULL,
1143   `dialplan` varchar(255) character set utf8 default NULL,
1144   `linetext` varchar(64) character set utf8 default NULL,
1145   PRIMARY KEY  (`id`)
1146 ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
1147 SET character_set_client = @saved_cs_client;
1148 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1149
1150 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1151 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1152 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1153 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1154 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1155 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1156 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1157
1158 -- Dump completed on 2012-01-17 17:21:39