+++ /dev/null
--- MySQL dump 10.11
---
--- Host: localhost Database: kamailio
--- ------------------------------------------------------
--- Server version 5.0.51a-24+lenny3-log
-
-/*!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 */;
-
---
--- Current Database: `kamailio`
---
-
-CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kamailio` /*!40100 DEFAULT CHARACTER SET latin1 */;
-
-USE `kamailio`;
-
---
--- Table structure for table `acc`
---
-
-DROP TABLE IF EXISTS `acc`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `acc` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `method` varchar(16) NOT NULL default '',
- `from_tag` varchar(64) NOT NULL default '',
- `to_tag` varchar(64) NOT NULL default '',
- `callid` varchar(128) NOT NULL default '',
- `sip_code` char(3) NOT NULL default '',
- `sip_reason` varchar(32) NOT NULL default '',
- `time` datetime NOT NULL default '0000-00-00 00:00:00',
- `src_ip` varchar(64) NOT NULL default '',
- `dst_user` varchar(64) NOT NULL default '',
- `dst_domain` varchar(128) NOT NULL default '',
- `src_user` varchar(64) NOT NULL default '',
- `src_domain` varchar(128) NOT NULL default '',
- `cdr_id` int(11) NOT NULL default '0',
- `dst_ouser` varchar(64) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY `acc_callid` (`callid`)
-) ENGINE=MyISAM AUTO_INCREMENT=8086 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `active_watchers`
---
-
-DROP TABLE IF EXISTS `active_watchers`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `active_watchers` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `presentity_uri` varchar(128) NOT NULL,
- `watcher_username` varchar(64) NOT NULL,
- `watcher_domain` varchar(64) NOT NULL,
- `to_user` varchar(64) NOT NULL,
- `to_domain` varchar(64) NOT NULL,
- `event` varchar(64) NOT NULL default 'presence',
- `event_id` varchar(64) default NULL,
- `to_tag` varchar(64) NOT NULL,
- `from_tag` varchar(64) NOT NULL,
- `callid` varchar(64) NOT NULL,
- `local_cseq` int(11) NOT NULL,
- `remote_cseq` int(11) NOT NULL,
- `contact` varchar(64) NOT NULL,
- `record_route` text,
- `expires` int(11) NOT NULL,
- `status` int(11) NOT NULL default '2',
- `reason` varchar(64) NOT NULL,
- `version` int(11) NOT NULL default '0',
- `socket_info` varchar(64) NOT NULL,
- `local_contact` varchar(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `active_watchers_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `address`
---
-
-DROP TABLE IF EXISTS `address`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `address` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `grp` smallint(5) unsigned NOT NULL default '1',
- `ip_addr` varchar(15) NOT NULL,
- `mask` tinyint(4) NOT NULL default '32',
- `port` smallint(5) unsigned NOT NULL default '0',
- `tag` varchar(64) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `aliases`
---
-
-DROP TABLE IF EXISTS `aliases`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `aliases` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) default NULL,
- `contact` varchar(255) NOT NULL default '',
- `received` varchar(128) default NULL,
- `path` varchar(128) default NULL,
- `expires` datetime NOT NULL default '2020-05-28 21:32:15',
- `q` float(10,2) NOT NULL default '1.00',
- `callid` varchar(255) NOT NULL default 'Default-Call-ID',
- `cseq` int(11) NOT NULL default '13',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- `flags` int(11) NOT NULL default '0',
- `cflags` int(11) NOT NULL default '0',
- `user_agent` varchar(255) NOT NULL default '',
- `socket` varchar(64) default NULL,
- `methods` int(11) default NULL,
- PRIMARY KEY (`id`),
- KEY `alias_idx` (`username`,`domain`,`contact`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `carrier_name`
---
-
-DROP TABLE IF EXISTS `carrier_name`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `carrier_name` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `carrier` varchar(64) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `carrierfailureroute`
---
-
-DROP TABLE IF EXISTS `carrierfailureroute`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `carrierfailureroute` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `carrier` int(10) unsigned NOT NULL default '0',
- `domain` int(10) unsigned NOT NULL default '0',
- `scan_prefix` varchar(64) NOT NULL default '',
- `host_name` varchar(128) NOT NULL default '',
- `reply_code` varchar(3) NOT NULL default '',
- `flags` int(11) unsigned NOT NULL default '0',
- `mask` int(11) unsigned NOT NULL default '0',
- `next_domain` int(10) unsigned NOT NULL default '0',
- `description` varchar(255) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `carrierroute`
---
-
-DROP TABLE IF EXISTS `carrierroute`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `carrierroute` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `carrier` int(10) unsigned NOT NULL default '0',
- `domain` int(10) unsigned NOT NULL default '0',
- `scan_prefix` varchar(64) NOT NULL default '',
- `flags` int(11) unsigned NOT NULL default '0',
- `mask` int(11) unsigned NOT NULL default '0',
- `prob` float NOT NULL default '0',
- `strip` int(11) unsigned NOT NULL default '0',
- `rewrite_host` varchar(128) NOT NULL default '',
- `rewrite_prefix` varchar(64) NOT NULL default '',
- `rewrite_suffix` varchar(64) NOT NULL default '',
- `description` varchar(255) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `cdrs`
---
-
-DROP TABLE IF EXISTS `cdrs`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `cdrs` (
- `cdr_id` bigint(20) NOT NULL auto_increment,
- `src_username` varchar(64) NOT NULL default '',
- `src_domain` varchar(128) NOT NULL default '',
- `dst_username` varchar(64) NOT NULL default '',
- `dst_domain` varchar(128) NOT NULL default '',
- `call_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
- `duration` int(10) unsigned NOT NULL default '0',
- `sip_call_id` varchar(128) NOT NULL default '',
- `sip_from_tag` varchar(128) NOT NULL default '',
- `sip_to_tag` varchar(128) NOT NULL default '',
- `src_ip` varchar(64) NOT NULL default '',
- `cost` int(11) NOT NULL default '0',
- `rated` int(11) NOT NULL default '0',
- `created` datetime NOT NULL,
- PRIMARY KEY (`cdr_id`),
- UNIQUE KEY `uk_cft` (`sip_call_id`,`sip_from_tag`,`sip_to_tag`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `cpl`
---
-
-DROP TABLE IF EXISTS `cpl`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `cpl` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL,
- `domain` varchar(64) NOT NULL default '',
- `cpl_xml` text,
- `cpl_bin` text,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `custom_authorization`
---
-
-DROP TABLE IF EXISTS `custom_authorization`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `custom_authorization` (
- `id` int(11) NOT NULL auto_increment,
- `username` varchar(64) NOT NULL,
- `permitedcalls` smallint(6) NOT NULL default '30',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `dbaliases`
---
-
-DROP TABLE IF EXISTS `dbaliases`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `dbaliases` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `alias_username` varchar(64) NOT NULL default '',
- `alias_domain` varchar(64) NOT NULL default '',
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `alias_idx` (`alias_username`,`alias_domain`),
- KEY `target_idx` (`username`,`domain`)
-) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `dialog`
---
-
-DROP TABLE IF EXISTS `dialog`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `dialog` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `hash_entry` int(10) unsigned NOT NULL,
- `hash_id` int(10) unsigned NOT NULL,
- `callid` varchar(255) NOT NULL,
- `from_uri` varchar(128) NOT NULL,
- `from_tag` varchar(64) NOT NULL,
- `to_uri` varchar(128) NOT NULL,
- `to_tag` varchar(64) NOT NULL,
- `caller_cseq` varchar(7) NOT NULL,
- `callee_cseq` varchar(7) NOT NULL,
- `caller_route_set` varchar(512) default NULL,
- `callee_route_set` varchar(512) default NULL,
- `caller_contact` varchar(128) NOT NULL,
- `callee_contact` varchar(128) NOT NULL,
- `caller_sock` varchar(64) NOT NULL,
- `callee_sock` varchar(64) NOT NULL,
- `state` int(10) unsigned NOT NULL,
- `start_time` int(10) unsigned NOT NULL,
- `timeout` int(10) unsigned NOT NULL default '0',
- `sflags` int(10) unsigned NOT NULL default '0',
- `toroute` int(10) unsigned NOT NULL default '0',
- `toroute_name` varchar(32) default NULL,
- `req_uri` varchar(128) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `hash_idx` (`hash_entry`,`hash_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `dialplan`
---
-
-DROP TABLE IF EXISTS `dialplan`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `dialplan` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `dpid` int(11) NOT NULL,
- `pr` int(11) NOT NULL,
- `match_op` int(11) NOT NULL,
- `match_exp` varchar(64) NOT NULL,
- `match_len` int(11) NOT NULL,
- `subst_exp` varchar(64) NOT NULL,
- `repl_exp` varchar(32) NOT NULL,
- `attrs` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `dispatcher`
---
-
-DROP TABLE IF EXISTS `dispatcher`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `dispatcher` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `setid` int(11) NOT NULL default '0',
- `destination` varchar(192) NOT NULL default '',
- `flags` int(11) NOT NULL default '0',
- `priority` int(11) NOT NULL default '0',
- `attrs` varchar(128) NOT NULL default '',
- `description` varchar(64) NOT NULL default '',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `domain`
---
-
-DROP TABLE IF EXISTS `domain`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `domain` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `domain` varchar(64) NOT NULL default '',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `domain_idx` (`domain`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `domain_name`
---
-
-DROP TABLE IF EXISTS `domain_name`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `domain_name` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `domain` varchar(64) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `domainpolicy`
---
-
-DROP TABLE IF EXISTS `domainpolicy`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `domainpolicy` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `rule` varchar(255) NOT NULL,
- `type` varchar(255) NOT NULL,
- `att` varchar(255) default NULL,
- `val` varchar(128) default NULL,
- `description` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rav_idx` (`rule`,`att`,`val`),
- KEY `rule_idx` (`rule`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `globalblacklist`
---
-
-DROP TABLE IF EXISTS `globalblacklist`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `globalblacklist` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `prefix` varchar(64) NOT NULL default '',
- `whitelist` tinyint(1) NOT NULL default '0',
- `description` varchar(255) default NULL,
- PRIMARY KEY (`id`),
- KEY `globalblacklist_idx` (`prefix`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `grp`
---
-
-DROP TABLE IF EXISTS `grp`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `grp` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `grp` varchar(64) NOT NULL default '',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_group_idx` (`username`,`domain`,`grp`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `htable`
---
-
-DROP TABLE IF EXISTS `htable`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `htable` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `key_name` varchar(64) NOT NULL default '',
- `key_type` int(11) NOT NULL default '0',
- `value_type` int(11) NOT NULL default '0',
- `key_value` varchar(128) NOT NULL default '',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `imc_members`
---
-
-DROP TABLE IF EXISTS `imc_members`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `imc_members` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL,
- `domain` varchar(64) NOT NULL,
- `room` varchar(64) NOT NULL,
- `flag` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_room_idx` (`username`,`domain`,`room`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `imc_rooms`
---
-
-DROP TABLE IF EXISTS `imc_rooms`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `imc_rooms` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(64) NOT NULL,
- `domain` varchar(64) NOT NULL,
- `flag` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name_domain_idx` (`name`,`domain`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `lcr_gw`
---
-
-DROP TABLE IF EXISTS `lcr_gw`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `lcr_gw` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `lcr_id` smallint(5) unsigned NOT NULL,
- `gw_name` varchar(128) default NULL,
- `ip_addr` varchar(15) default NULL,
- `hostname` varchar(64) default NULL,
- `port` smallint(5) unsigned default NULL,
- `params` varchar(64) default NULL,
- `uri_scheme` tinyint(3) unsigned default NULL,
- `transport` tinyint(3) unsigned default NULL,
- `strip` tinyint(3) unsigned default NULL,
- `tag` varchar(16) default NULL,
- `flags` int(10) unsigned NOT NULL default '0',
- `defunct` int(10) unsigned default NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `lcr_id_ip_addr_port_hostname_idx` (`lcr_id`,`ip_addr`,`port`,`hostname`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `lcr_rule`
---
-
-DROP TABLE IF EXISTS `lcr_rule`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `lcr_rule` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `lcr_id` smallint(5) unsigned NOT NULL,
- `prefix` varchar(16) default NULL,
- `from_uri` varchar(64) default NULL,
- `stopper` int(10) unsigned NOT NULL default '0',
- `enabled` int(10) unsigned NOT NULL default '1',
- PRIMARY KEY (`id`),
- UNIQUE KEY `lcr_id_prefix_from_uri_idx` (`lcr_id`,`prefix`,`from_uri`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `lcr_rule_target`
---
-
-DROP TABLE IF EXISTS `lcr_rule_target`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `lcr_rule_target` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `lcr_id` smallint(5) unsigned NOT NULL,
- `rule_id` int(10) unsigned NOT NULL,
- `gw_id` int(10) unsigned NOT NULL,
- `priority` tinyint(3) unsigned NOT NULL,
- `weight` int(10) unsigned NOT NULL default '1',
- PRIMARY KEY (`id`),
- UNIQUE KEY `rule_id_gw_id_idx` (`rule_id`,`gw_id`),
- KEY `lcr_id_idx` (`lcr_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `location`
---
-
-DROP TABLE IF EXISTS `location`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `location` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) default NULL,
- `contact` varchar(255) NOT NULL default '',
- `received` varchar(128) default NULL,
- `path` varchar(128) default NULL,
- `expires` datetime NOT NULL default '2020-05-28 21:32:15',
- `q` float(10,2) NOT NULL default '1.00',
- `callid` varchar(255) NOT NULL default 'Default-Call-ID',
- `cseq` int(11) NOT NULL default '13',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- `flags` int(11) NOT NULL default '0',
- `cflags` int(11) NOT NULL default '0',
- `user_agent` varchar(255) NOT NULL default '',
- `socket` varchar(64) default NULL,
- `methods` int(11) default NULL,
- PRIMARY KEY (`id`),
- KEY `account_contact_idx` (`username`,`domain`,`contact`)
-) ENGINE=MyISAM AUTO_INCREMENT=3088 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `missed_calls`
---
-
-DROP TABLE IF EXISTS `missed_calls`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `missed_calls` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `method` varchar(16) NOT NULL default '',
- `from_tag` varchar(64) NOT NULL default '',
- `to_tag` varchar(64) NOT NULL default '',
- `callid` varchar(128) NOT NULL default '',
- `sip_code` char(3) NOT NULL default '',
- `sip_reason` varchar(32) NOT NULL default '',
- `time` datetime NOT NULL default '0000-00-00 00:00:00',
- `src_ip` varchar(64) NOT NULL default '',
- `dst_user` varchar(64) NOT NULL default '',
- `dst_domain` varchar(128) NOT NULL default '',
- `src_user` varchar(64) NOT NULL default '',
- `src_domain` varchar(128) NOT NULL default '',
- `cdr_id` int(11) NOT NULL default '0',
- `dst_ouser` varchar(64) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY `mc_callid` (`callid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `pdt`
---
-
-DROP TABLE IF EXISTS `pdt`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `pdt` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `sdomain` varchar(128) NOT NULL,
- `prefix` varchar(32) NOT NULL,
- `domain` varchar(128) NOT NULL default '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `sdomain_prefix_idx` (`sdomain`,`prefix`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `presentity`
---
-
-DROP TABLE IF EXISTS `presentity`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `presentity` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL,
- `domain` varchar(64) NOT NULL,
- `event` varchar(64) NOT NULL,
- `etag` varchar(64) NOT NULL,
- `expires` int(11) NOT NULL,
- `received_time` int(11) NOT NULL,
- `body` blob NOT NULL,
- `sender` varchar(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `presentity_idx` (`username`,`domain`,`event`,`etag`)
-) ENGINE=MyISAM AUTO_INCREMENT=1289 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `pua`
---
-
-DROP TABLE IF EXISTS `pua`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `pua` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `pres_uri` varchar(128) NOT NULL,
- `pres_id` varchar(64) NOT NULL,
- `event` int(11) NOT NULL,
- `expires` int(11) NOT NULL,
- `desired_expires` int(11) NOT NULL,
- `flag` int(11) NOT NULL,
- `etag` varchar(64) NOT NULL,
- `tuple_id` varchar(64) default NULL,
- `watcher_uri` varchar(128) NOT NULL,
- `call_id` varchar(64) NOT NULL,
- `to_tag` varchar(64) NOT NULL,
- `from_tag` varchar(64) NOT NULL,
- `cseq` int(11) NOT NULL,
- `record_route` text,
- `contact` varchar(128) NOT NULL,
- `remote_contact` varchar(128) NOT NULL,
- `version` int(11) NOT NULL,
- `extra_headers` text NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `purplemap`
---
-
-DROP TABLE IF EXISTS `purplemap`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `purplemap` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `sip_user` varchar(128) NOT NULL,
- `ext_user` varchar(128) NOT NULL,
- `ext_prot` varchar(16) NOT NULL,
- `ext_pass` varchar(64) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `re_grp`
---
-
-DROP TABLE IF EXISTS `re_grp`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `re_grp` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `reg_exp` varchar(128) NOT NULL default '',
- `group_id` int(11) NOT NULL default '0',
- PRIMARY KEY (`id`),
- KEY `group_idx` (`group_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `rls_presentity`
---
-
-DROP TABLE IF EXISTS `rls_presentity`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `rls_presentity` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `rlsubs_did` varchar(255) NOT NULL,
- `resource_uri` varchar(128) NOT NULL,
- `content_type` varchar(64) NOT NULL,
- `presence_state` blob NOT NULL,
- `expires` int(11) NOT NULL,
- `updated` int(11) NOT NULL,
- `auth_state` int(11) NOT NULL,
- `reason` varchar(64) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rls_presentity_idx` (`rlsubs_did`,`resource_uri`),
- KEY `updated_idx` (`updated`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `rls_watchers`
---
-
-DROP TABLE IF EXISTS `rls_watchers`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `rls_watchers` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `presentity_uri` varchar(128) NOT NULL,
- `to_user` varchar(64) NOT NULL,
- `to_domain` varchar(64) NOT NULL,
- `watcher_username` varchar(64) NOT NULL,
- `watcher_domain` varchar(64) NOT NULL,
- `event` varchar(64) NOT NULL default 'presence',
- `event_id` varchar(64) default NULL,
- `to_tag` varchar(64) NOT NULL,
- `from_tag` varchar(64) NOT NULL,
- `callid` varchar(64) NOT NULL,
- `local_cseq` int(11) NOT NULL,
- `remote_cseq` int(11) NOT NULL,
- `contact` varchar(64) NOT NULL,
- `record_route` text,
- `expires` int(11) NOT NULL,
- `status` int(11) NOT NULL default '2',
- `reason` varchar(64) NOT NULL,
- `version` int(11) NOT NULL default '0',
- `socket_info` varchar(64) NOT NULL,
- `local_contact` varchar(128) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `rls_watcher_idx` (`presentity_uri`,`callid`,`to_tag`,`from_tag`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `silo`
---
-
-DROP TABLE IF EXISTS `silo`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `silo` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `src_addr` varchar(128) NOT NULL default '',
- `dst_addr` varchar(128) NOT NULL default '',
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `inc_time` int(11) NOT NULL default '0',
- `exp_time` int(11) NOT NULL default '0',
- `snd_time` int(11) NOT NULL default '0',
- `ctype` varchar(32) NOT NULL default 'text/plain',
- `body` blob NOT NULL,
- PRIMARY KEY (`id`),
- KEY `account_idx` (`username`,`domain`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `sip_trace`
---
-
-DROP TABLE IF EXISTS `sip_trace`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `sip_trace` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `time_stamp` datetime NOT NULL default '1900-01-01 00:00:01',
- `callid` varchar(255) NOT NULL default '',
- `traced_user` varchar(128) NOT NULL default '',
- `msg` text NOT NULL,
- `method` varchar(50) NOT NULL default '',
- `status` varchar(128) NOT NULL default '',
- `fromip` varchar(50) NOT NULL default '',
- `toip` varchar(50) NOT NULL default '',
- `fromtag` varchar(64) NOT NULL default '',
- `direction` varchar(4) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY `traced_user_idx` (`traced_user`),
- KEY `date_idx` (`time_stamp`),
- KEY `fromip_idx` (`fromip`),
- KEY `callid_idx` (`callid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `speed_dial`
---
-
-DROP TABLE IF EXISTS `speed_dial`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `speed_dial` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `sd_username` varchar(64) NOT NULL default '',
- `sd_domain` varchar(64) NOT NULL default '',
- `new_uri` varchar(128) NOT NULL default '',
- `fname` varchar(64) NOT NULL default '',
- `lname` varchar(64) NOT NULL default '',
- `description` varchar(64) NOT NULL default '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `speed_dial_idx` (`username`,`domain`,`sd_domain`,`sd_username`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `statistics`
---
-
-DROP TABLE IF EXISTS `statistics`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `statistics` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `time_stamp` int(10) unsigned NOT NULL default '0',
- `shm_used_size` int(10) unsigned NOT NULL default '0',
- `shm_real_used_size` int(10) unsigned NOT NULL default '0',
- `shm_max_used_size` int(10) unsigned NOT NULL default '0',
- `shm_free_used_size` int(10) unsigned NOT NULL default '0',
- `ul_users` int(10) unsigned NOT NULL default '0',
- `ul_contacts` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `subscriber`
---
-
-DROP TABLE IF EXISTS `subscriber`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `subscriber` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `password` varchar(25) NOT NULL default '',
- `email_address` varchar(64) NOT NULL default '',
- `ha1` varchar(64) NOT NULL default '',
- `ha1b` varchar(64) NOT NULL default '',
- `rpid` varchar(64) default NULL,
- `permitedcalls` smallint(6) default '14',
- `permittedcalls` smallint(6) default '14',
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`),
- KEY `username_idx` (`username`)
-) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `trusted`
---
-
-DROP TABLE IF EXISTS `trusted`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `trusted` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `src_ip` varchar(50) NOT NULL,
- `proto` varchar(4) NOT NULL,
- `from_pattern` varchar(64) default NULL,
- `tag` varchar(64) default NULL,
- PRIMARY KEY (`id`),
- KEY `peer_idx` (`src_ip`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `uri`
---
-
-DROP TABLE IF EXISTS `uri`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `uri` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `uri_user` varchar(64) NOT NULL default '',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_idx` (`username`,`domain`,`uri_user`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `userblacklist`
---
-
-DROP TABLE IF EXISTS `userblacklist`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `userblacklist` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `domain` varchar(64) NOT NULL default '',
- `prefix` varchar(64) NOT NULL default '',
- `whitelist` tinyint(1) NOT NULL default '0',
- PRIMARY KEY (`id`),
- KEY `userblacklist_idx` (`username`,`domain`,`prefix`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `usr_preferences`
---
-
-DROP TABLE IF EXISTS `usr_preferences`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `usr_preferences` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `uuid` varchar(64) NOT NULL default '',
- `username` varchar(128) NOT NULL default '0',
- `domain` varchar(64) NOT NULL default '',
- `attribute` varchar(32) NOT NULL default '',
- `type` int(11) NOT NULL default '0',
- `value` varchar(128) NOT NULL default '',
- `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
- PRIMARY KEY (`id`),
- KEY `ua_idx` (`uuid`,`attribute`),
- KEY `uda_idx` (`username`,`domain`,`attribute`)
-) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `version`
---
-
-DROP TABLE IF EXISTS `version`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `version` (
- `table_name` varchar(32) NOT NULL,
- `table_version` int(10) unsigned NOT NULL default '0'
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `watchers`
---
-
-DROP TABLE IF EXISTS `watchers`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `watchers` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `presentity_uri` varchar(128) NOT NULL,
- `watcher_username` varchar(64) NOT NULL,
- `watcher_domain` varchar(64) NOT NULL,
- `event` varchar(64) NOT NULL default 'presence',
- `status` int(11) NOT NULL,
- `reason` varchar(64) default NULL,
- `inserted_time` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `watcher_idx` (`presentity_uri`,`watcher_username`,`watcher_domain`,`event`)
-) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `xcap`
---
-
-DROP TABLE IF EXISTS `xcap`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `xcap` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL,
- `domain` varchar(64) NOT NULL,
- `doc` blob NOT NULL,
- `doc_type` int(11) NOT NULL,
- `etag` varchar(64) NOT NULL,
- `source` int(11) NOT NULL,
- `doc_uri` varchar(128) NOT NULL,
- `port` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `account_doc_type_idx` (`username`,`domain`,`doc_type`,`doc_uri`),
- KEY `source_idx` (`source`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Current Database: `hermes`
---
-
-CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hermes` /*!40100 DEFAULT CHARACTER SET latin1 */;
-
-USE `hermes`;
-
---
--- Table structure for table `apikeys`
---
-
-CREATE TABLE IF NOT EXISTS `apikeys` (
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `host` varchar(64) NOT NULL,
- `apikey` varchar(128) NOT NULL,
- PRIMARY KEY (`apikey`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `authorizations`
---
-
-DROP TABLE IF EXISTS `authorizations`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE IF NOT EXISTS `authorizations` (
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `authid` varchar(255) NOT NULL,
- `type` varchar(16) NOT NULL,
- `access_level` int(11) NOT NULL,
- PRIMARY KEY (`authid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `number_pool`
---
-
-DROP TABLE IF EXISTS `number_pool`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `number_pool` (
- `id` int(11) NOT NULL auto_increment,
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `number` varchar(128) character set utf8 NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `phones`
---
-
-DROP TABLE IF EXISTS `phones`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `phones` (
- `id` int(11) NOT NULL auto_increment,
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `mac` varchar(32) character set utf8 NOT NULL,
- `user_rel` int(11) NOT NULL,
- `ua_type` int(11) default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `servers`
---
-
-DROP TABLE IF EXISTS `servers`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `servers` (
- `id` int(11) NOT NULL auto_increment,
- `domain` varchar(255) character set utf8 NOT NULL,
- `registrar` varchar(255) character set utf8 default NULL,
- `r_port` int(11) default NULL,
- `proxy` varchar(255) character set utf8 default NULL,
- `p_port` int(11) default NULL,
- `prov_url` text,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `sessionkeys`
---
-
-DROP TABLE IF EXISTS `sessionkeys`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `sessionkeys` (
- `sessid` varchar(255) NOT NULL,
- `session` varchar(128) NOT NULL,
- `authid` varchar(128) NOT NULL,
- `client` varchar(255) NOT NULL,
- `key` varchar(128) NOT NULL,
- `last` datetime default NULL,
- PRIMARY KEY (`session`,`authid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `users`
---
-
-DROP TABLE IF EXISTS `users`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `users` (
- `id` int(11) NOT NULL auto_increment,
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
- `username` varchar(128) character set utf8 NOT NULL,
- `password` varchar(128) character set utf8 NOT NULL,
- `displayname` varchar(255) character set utf8 NOT NULL,
- `domain` varchar(255) character set utf8 NOT NULL,
- `registrar` varchar(255) character set utf8 default NULL,
- `r_port` int(11) default NULL,
- `proxy` varchar(255) character set utf8 default NULL,
- `p_port` int(11) default NULL,
- `authid` varchar(128) character set utf8 default NULL,
- `dialplan` varchar(255) character set utf8 default NULL,
- `linetext` varchar(64) character set utf8 default NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-/*!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 */;
-
--- Dump completed on 2012-01-17 17:21:39
git.defcon.no / hermes / blobdiff