]> git.defcon.no Git - hermes/blob - doc/sql-data/structure.sql
Changed sql_dbquery to return result on zero rows. Resulted in some patchings. Added...
[hermes] / 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: `provision`
1020 --
1021
1022 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `provision` /*!40100 DEFAULT CHARACTER SET latin1 */;
1023
1024 USE `provision`;
1025
1026 --
1027 -- Table structure for table `number_pool`
1028 --
1029
1030 DROP TABLE IF EXISTS `number_pool`;
1031 SET @saved_cs_client = @@character_set_client;
1032 SET character_set_client = utf8;
1033 CREATE TABLE `number_pool` (
1034 `id` int(11) NOT NULL auto_increment,
1035 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1036 `number` varchar(128) character set utf8 NOT NULL,
1037 PRIMARY KEY (`id`)
1038 ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
1039 SET character_set_client = @saved_cs_client;
1040
1041 --
1042 -- Table structure for table `phones`
1043 --
1044
1045 DROP TABLE IF EXISTS `phones`;
1046 SET @saved_cs_client = @@character_set_client;
1047 SET character_set_client = utf8;
1048 CREATE TABLE `phones` (
1049 `id` int(11) NOT NULL auto_increment,
1050 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1051 `mac` varchar(32) character set utf8 NOT NULL,
1052 `user_rel` int(11) NOT NULL,
1053 `ua_type` int(11) default NULL,
1054 PRIMARY KEY (`id`)
1055 ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
1056 SET character_set_client = @saved_cs_client;
1057
1058 --
1059 -- Table structure for table `servers`
1060 --
1061
1062 DROP TABLE IF EXISTS `servers`;
1063 SET @saved_cs_client = @@character_set_client;
1064 SET character_set_client = utf8;
1065 CREATE TABLE `servers` (
1066 `id` int(11) NOT NULL auto_increment,
1067 `domain` varchar(255) character set utf8 NOT NULL,
1068 `registrar` varchar(255) character set utf8 default NULL,
1069 `r_port` int(11) default NULL,
1070 `proxy` varchar(255) character set utf8 default NULL,
1071 `p_port` int(11) default NULL,
1072 PRIMARY KEY (`id`)
1073 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1074 SET character_set_client = @saved_cs_client;
1075
1076 --
1077 -- Table structure for table `users`
1078 --
1079
1080 DROP TABLE IF EXISTS `users`;
1081 SET @saved_cs_client = @@character_set_client;
1082 SET character_set_client = utf8;
1083 CREATE TABLE `users` (
1084 `id` int(11) NOT NULL auto_increment,
1085 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1086 `username` varchar(128) character set utf8 NOT NULL,
1087 `password` varchar(128) character set utf8 NOT NULL,
1088 `displayname` varchar(255) character set utf8 NOT NULL,
1089 `domain` varchar(255) character set utf8 NOT NULL,
1090 `registrar` varchar(255) character set utf8 default NULL,
1091 `r_port` int(11) default NULL,
1092 `proxy` varchar(255) character set utf8 default NULL,
1093 `p_port` int(11) default NULL,
1094 `authid` varchar(128) character set utf8 default NULL,
1095 `dialplan` varchar(255) character set utf8 default NULL,
1096 `linetext` varchar(64) character set utf8 default NULL,
1097 PRIMARY KEY (`id`)
1098 ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
1099 SET character_set_client = @saved_cs_client;
1100 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1101
1102 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1103 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1104 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1105 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1106 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1107 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1108 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1109
1110 -- Dump completed on 2012-01-17 17:21:39