cVEEsnTs

1Skip to content
2This repository
3Search
4Pull requests
5Issues
6Gist
7 @figueiredo86
8 Unwatch 1
9  Star 0
10 Fork 0 figueiredo86/smartura
11 Code  Issues 0  Pull requests 0  Projects 0  Wiki  Pulse  Graphs  Settings
12Branch: master Find file Copy pathsmartura/banco/scripts/addsip.sql
1399df798  11 days ago
14 root adicao dos scripts de criacao de ramal
150 contributors
16RawBlameHistory     
1747 lines (45 sloc)  1.78 KB
18drop table if exists ramais;
19
20CREATE table if not exists ramais (
21`id` int(11) NOT NULL AUTO_INCREMENT,
22`name` varchar(80) NOT NULL DEFAULT '',
23`context` varchar(80) NOT NULL DEFAULT 'ramais',
24`deny` varchar(95) DEFAULT NULL,
25`permit` varchar(95) DEFAULT NULL,
26`secret` varchar(80) DEFAULT NULL,
27`md5secret` varchar(80) DEFAULT NULL,
28`remotesecret` varchar(250) DEFAULT NULL,
29`transport` enum('tcp','udp','tcp,udp') DEFAULT NULL,
30`host` varchar(31) NOT NULL DEFAULT 'dynamic',
31`nat` varchar(5) NOT NULL DEFAULT 'no',
32`type` enum('user','peer','friend') NOT NULL DEFAULT 'peer',
33`accountcode` varchar(20) DEFAULT NULL,
34`amaflags` varchar(13) DEFAULT NULL,
35`callgroup` varchar(10) DEFAULT NULL,
36`callerid` varchar(80) DEFAULT NULL,
37`defaultip` varchar(15) DEFAULT NULL,
38`dtmfmode` varchar(7) DEFAULT 'rfc2833',
39`fromuser` varchar(80) DEFAULT NULL,
40`fromdomain` varchar(80) DEFAULT NULL,
41`insecure` varchar(20) DEFAULT 'port,invite',
42`language` char(2) DEFAULT NULL,
43`mailbox` varchar(50) DEFAULT NULL,
44`pickupgroup` varchar(10) DEFAULT NULL,
45`qualify` char(3) DEFAULT NULL,
46`disallow` varchar(100) DEFAULT 'all',
47`allow` varchar(100) DEFAULT 'ulaw;alaw;gsm',
48`port` mediumint(5) unsigned NOT NULL DEFAULT '0',
49`ipaddr` varchar(15) not null default '',
50`callbackextension` varchar(100) not null,
51`username` varchar(80) NOT NULL DEFAULT '',
52`defaultuser` varchar(80) NOT NULL DEFAULT '',
53`subscribecontext` varchar(80) DEFAULT NULL,
54`directmedia` enum('yes','no') DEFAULT NULL,
55`callcounter` enum('yes','no') DEFAULT NULL,
56`qualifyfreq` int(5) unsigned DEFAULT '120',
57`useragent` varchar(50) NOT NULL DEFAULT '',
58`empresa_id` int(10) not null,
59PRIMARY KEY (`id`),
60UNIQUE KEY `name` (`name`),
61KEY `name_2` (`name`),
62foreign key (empresa_id) references clientes (id)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
64Contact GitHub API Training Shop Blog About
65© 2016 GitHub, Inc. Terms Privacy Security Status Help