3 -- Host: localhost Database: kamailio
4 -- ------------------------------------------------------
5 -- Server version 5.0.51a-24+lenny3-log
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Current Database: `kamailio`
22 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kamailio`
/*!40100 DEFAULT CHARACTER SET latin1 */;
27 -- Table structure for table `acc`
30 DROP TABLE IF EXISTS `acc`
;
31 SET @saved_cs_client
= @@character_set_client
;
32 SET character_set_client
= utf8
;
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 '',
50 KEY `acc_callid`
(`callid`
)
51 ) ENGINE
=MyISAM AUTO_INCREMENT
=8086 DEFAULT CHARSET
=latin1
;
52 SET character_set_client
= @saved_cs_client
;
55 -- Table structure for table `active_watchers`
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,
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,
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
;
89 -- Table structure for table `address`
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,
103 ) ENGINE
=MyISAM AUTO_INCREMENT
=11 DEFAULT CHARSET
=latin1
;
104 SET character_set_client
= @saved_cs_client
;
107 -- Table structure for table `aliases`
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,
131 KEY `alias_idx`
(`username`
,`
domain`
,`contact`
)
132 ) ENGINE
=MyISAM AUTO_INCREMENT
=5 DEFAULT CHARSET
=latin1
;
133 SET character_set_client
= @saved_cs_client
;
136 -- Table structure for table `carrier_name`
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,
146 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
147 SET character_set_client
= @saved_cs_client
;
150 -- Table structure for table `carrierfailureroute`
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,
168 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
169 SET character_set_client
= @saved_cs_client
;
172 -- Table structure for table `carrierroute`
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,
192 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
193 SET character_set_client
= @saved_cs_client
;
196 -- Table structure for table `cdrs`
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
;
223 -- Table structure for table `cpl`
226 DROP TABLE IF EXISTS `cpl`
;
227 SET @saved_cs_client
= @@character_set_client
;
228 SET character_set_client
= utf8
;
230 `
id`
int(10) unsigned
NOT NULL auto_increment
,
231 `username`
varchar(64) NOT NULL,
232 `
domain`
varchar(64) NOT NULL default '',
236 UNIQUE KEY `account_idx`
(`username`
,`
domain`
)
237 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
238 SET character_set_client
= @saved_cs_client
;
241 -- Table structure for table `custom_authorization`
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',
252 ) ENGINE
=MyISAM AUTO_INCREMENT
=6 DEFAULT CHARSET
=latin1
;
253 SET character_set_client
= @saved_cs_client
;
256 -- Table structure for table `dbaliases`
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 '',
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
;
275 -- Table structure for table `dialog`
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,
306 KEY `hash_idx`
(`hash_entry`
,`hash_id`
)
307 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
308 SET character_set_client
= @saved_cs_client
;
311 -- Table structure for table `dialplan`
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,
328 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
329 SET character_set_client
= @saved_cs_client
;
332 -- Table structure for table `dispatcher`
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 '',
347 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
348 SET character_set_client
= @saved_cs_client
;
351 -- Table structure for table `domain`
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',
362 UNIQUE KEY `domain_idx`
(`
domain`
)
363 ) ENGINE
=MyISAM AUTO_INCREMENT
=2 DEFAULT CHARSET
=latin1
;
364 SET character_set_client
= @saved_cs_client
;
367 -- Table structure for table `domain_name`
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,
377 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
378 SET character_set_client
= @saved_cs_client
;
381 -- Table structure for table `domainpolicy`
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,
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
;
401 -- Table structure for table `globalblacklist`
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,
413 KEY `globalblacklist_idx`
(`
prefix`
)
414 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
415 SET character_set_client
= @saved_cs_client
;
418 -- Table structure for table `grp`
421 DROP TABLE IF EXISTS `grp`
;
422 SET @saved_cs_client
= @@character_set_client
;
423 SET character_set_client
= utf8
;
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',
431 UNIQUE KEY `account_group_idx`
(`username`
,`
domain`
,`grp`
)
432 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
433 SET character_set_client
= @saved_cs_client
;
436 -- Table structure for table `htable`
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 '',
449 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
450 SET character_set_client
= @saved_cs_client
;
453 -- Table structure for table `imc_members`
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,
466 UNIQUE KEY `account_room_idx`
(`username`
,`
domain`
,`room`
)
467 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
468 SET character_set_client
= @saved_cs_client
;
471 -- Table structure for table `imc_rooms`
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,
483 UNIQUE KEY `name_domain_idx`
(`
name`
,`
domain`
)
484 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
485 SET character_set_client
= @saved_cs_client
;
488 -- Table structure for table `lcr_gw`
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,
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
;
514 -- Table structure for table `lcr_rule`
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',
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
;
533 -- Table structure for table `lcr_rule_target`
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',
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
;
553 -- Table structure for table `location`
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,
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
;
582 -- Table structure for table `missed_calls`
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 '',
605 KEY `mc_callid`
(`callid`
)
606 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
607 SET character_set_client
= @saved_cs_client
;
610 -- Table structure for table `pdt`
613 DROP TABLE IF EXISTS `pdt`
;
614 SET @saved_cs_client
= @@character_set_client
;
615 SET character_set_client
= utf8
;
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 '',
622 UNIQUE KEY `sdomain_prefix_idx`
(`sdomain`
,`
prefix`
)
623 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
624 SET character_set_client
= @saved_cs_client
;
627 -- Table structure for table `presentity`
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,
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
;
649 -- Table structure for table `pua`
652 DROP TABLE IF EXISTS `pua`
;
653 SET @saved_cs_client
= @@character_set_client
;
654 SET character_set_client
= utf8
;
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,
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,
676 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
677 SET character_set_client
= @saved_cs_client
;
680 -- Table structure for table `purplemap`
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,
693 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
694 SET character_set_client
= @saved_cs_client
;
697 -- Table structure for table `re_grp`
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',
708 KEY `group_idx`
(`group_id`
)
709 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
710 SET character_set_client
= @saved_cs_client
;
713 -- Table structure for table `rls_presentity`
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,
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
;
736 -- Table structure for table `rls_watchers`
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,
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,
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
;
770 -- Table structure for table `silo`
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,
788 KEY `account_idx`
(`username`
,`
domain`
)
789 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
790 SET character_set_client
= @saved_cs_client
;
793 -- Table structure for table `sip_trace`
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 '',
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 '',
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
;
820 -- Table structure for table `speed_dial`
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 '',
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
;
842 -- Table structure for table `statistics`
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',
858 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
859 SET character_set_client
= @saved_cs_client
;
862 -- Table structure for table `subscriber`
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',
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
;
886 -- Table structure for table `trusted`
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,
899 KEY `peer_idx`
(`src_ip`
)
900 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
901 SET character_set_client
= @saved_cs_client
;
904 -- Table structure for table `uri`
907 DROP TABLE IF EXISTS `
uri`
;
908 SET @saved_cs_client
= @@character_set_client
;
909 SET character_set_client
= utf8
;
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',
917 UNIQUE KEY `account_idx`
(`username`
,`
domain`
,`uri_user`
)
918 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
919 SET character_set_client
= @saved_cs_client
;
922 -- Table structure for table `userblacklist`
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',
935 KEY `userblacklist_idx`
(`username`
,`
domain`
,`
prefix`
)
936 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
937 SET character_set_client
= @saved_cs_client
;
940 -- Table structure for table `usr_preferences`
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',
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
;
962 -- Table structure for table `version`
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
;
975 -- Table structure for table `watchers`
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,
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
;
996 -- Table structure for table `xcap`
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,
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
;
1019 -- Current Database: `provision`
1022 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `provision`
/*!40100 DEFAULT CHARACTER SET latin1 */;
1027 -- Table structure for table `apikeys`
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
;
1037 -- --------------------------------------------------------
1040 -- Table structure for table `authorizations`
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
;
1056 -- Table structure for table `number_pool`
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,
1067 ) ENGINE
=MyISAM AUTO_INCREMENT
=30 DEFAULT CHARSET
=latin1
;
1068 SET character_set_client
= @saved_cs_client
;
1071 -- Table structure for table `phones`
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,
1084 ) ENGINE
=MyISAM AUTO_INCREMENT
=13 DEFAULT CHARSET
=latin1
;
1085 SET character_set_client
= @saved_cs_client
;
1088 -- Table structure for table `servers`
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,
1103 ) ENGINE
=MyISAM AUTO_INCREMENT
=2 DEFAULT CHARSET
=latin1
;
1104 SET character_set_client
= @saved_cs_client
;
1107 -- Table structure for table `sessionkeys`
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
;
1125 -- Table structure for table `users`
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,
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 */;
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 */;
1158 -- Dump completed on 2012-01-17 17:21:39