· 6 years ago · Jul 07, 2019, 08:10 AM
1CREATE TABLE `extensions` (
2 `id` int(11) NOT NULL auto_increment,
3 `context` varchar(20) NOT NULL default '',
4 `exten` varchar(20) NOT NULL default '',
5 `priority` tinyint(4) NOT NULL default '0',
6 `app` varchar(20) NOT NULL default '',
7 `appdata` varchar(128) NOT NULL default '',
8 PRIMARY KEY (`context`,`exten`,`priority`),
9 KEY `id` (`id`)
10) ENGINE=MyISAM;
11
12#
13# Table structure for table `sipfriends`
14#
15
16CREATE TABLE IF NOT EXISTS `sipfriends` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `name` varchar(10) NOT NULL,
19 `ipaddr` varchar(15) DEFAULT NULL,
20 `port` int(5) DEFAULT NULL,
21 `regseconds` int(11) DEFAULT NULL,
22 `defaultuser` varchar(10) DEFAULT NULL,
23 `fullcontact` varchar(35) DEFAULT NULL,
24 `regserver` varchar(20) DEFAULT NULL,
25 `useragent` varchar(20) DEFAULT NULL,
26 `lastms` int(11) DEFAULT NULL,
27 `host` varchar(40) DEFAULT NULL,
28 `type` enum('friend','user','peer') DEFAULT NULL,
29 `context` varchar(40) DEFAULT NULL,
30 `permit` varchar(40) DEFAULT NULL,
31 `deny` varchar(40) DEFAULT NULL,
32 `secret` varchar(40) DEFAULT NULL,
33 `md5secret` varchar(40) DEFAULT NULL,
34 `remotesecret` varchar(40) DEFAULT NULL,
35 `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
36 `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
37 `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
38 `nat` enum('yes','no','never','route') DEFAULT NULL,
39 `callgroup` varchar(40) DEFAULT NULL,
40 `pickupgroup` varchar(40) DEFAULT NULL,
41 `language` varchar(40) DEFAULT NULL,
42 `allow` varchar(40) DEFAULT NULL,
43 `disallow` varchar(40) DEFAULT NULL,
44 `insecure` varchar(40) DEFAULT NULL,
45 `trustrpid` enum('yes','no') DEFAULT NULL,
46 `progressinband` enum('yes','no','never') DEFAULT NULL,
47 `promiscredir` enum('yes','no') DEFAULT NULL,
48 `useclientcode` enum('yes','no') DEFAULT NULL,
49 `accountcode` varchar(40) DEFAULT NULL,
50 `setvar` varchar(40) DEFAULT NULL,
51 `callerid` varchar(40) DEFAULT NULL,
52 `amaflags` varchar(40) DEFAULT NULL,
53 `callcounter` enum('yes','no') DEFAULT NULL,
54 `busylevel` int(11) DEFAULT NULL,
55 `allowoverlap` enum('yes','no') DEFAULT NULL,
56 `allowsubscribe` enum('yes','no') DEFAULT NULL,
57 `videosupport` enum('yes','no') DEFAULT NULL,
58 `maxcallbitrate` int(11) DEFAULT NULL,
59 `rfc2833compensate` enum('yes','no') DEFAULT NULL,
60 `mailbox` varchar(40) DEFAULT NULL,
61 `session-timers` enum('accept','refuse','originate') DEFAULT NULL,
62 `session-expires` int(11) DEFAULT NULL,
63 `session-minse` int(11) DEFAULT NULL,
64 `session-refresher` enum('uac','uas') DEFAULT NULL,
65 `t38pt_usertpsource` varchar(40) DEFAULT NULL,
66 `regexten` varchar(40) DEFAULT NULL,
67 `fromdomain` varchar(40) DEFAULT NULL,
68 `fromuser` varchar(40) DEFAULT NULL,
69 `qualify` varchar(40) DEFAULT NULL,
70 `defaultip` varchar(40) DEFAULT NULL,
71 `rtptimeout` int(11) DEFAULT NULL,
72 `rtpholdtimeout` int(11) DEFAULT NULL,
73 `sendrpid` enum('yes','no') DEFAULT NULL,
74 `outboundproxy` varchar(40) DEFAULT NULL,
75 `callbackextension` varchar(40) DEFAULT NULL,
76 `registertrying` enum('yes','no') DEFAULT NULL,
77 `timert1` int(11) DEFAULT NULL,
78 `timerb` int(11) DEFAULT NULL,
79 `qualifyfreq` int(11) DEFAULT NULL,
80 `constantssrc` enum('yes','no') DEFAULT NULL,
81 `contactpermit` varchar(40) DEFAULT NULL,
82 `contactdeny` varchar(40) DEFAULT NULL,
83 `usereqphone` enum('yes','no') DEFAULT NULL,
84 `textsupport` enum('yes','no') DEFAULT NULL,
85 `faxdetect` enum('yes','no') DEFAULT NULL,
86 `buggymwi` enum('yes','no') DEFAULT NULL,
87 `auth` varchar(40) DEFAULT NULL,
88 `fullname` varchar(40) DEFAULT NULL,
89 `trunkname` varchar(40) DEFAULT NULL,
90 `cid_number` varchar(40) DEFAULT NULL,
91 `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
92 `mohinterpret` varchar(40) DEFAULT NULL,
93 `mohsuggest` varchar(40) DEFAULT NULL,
94 `parkinglot` varchar(40) DEFAULT NULL,
95 `hasvoicemail` enum('yes','no') DEFAULT NULL,
96 `subscribemwi` enum('yes','no') DEFAULT NULL,
97 `vmexten` varchar(40) DEFAULT NULL,
98 `autoframing` enum('yes','no') DEFAULT NULL,
99 `rtpkeepalive` int(11) DEFAULT NULL,
100 `call-limit` int(11) DEFAULT NULL,
101 `g726nonstandard` enum('yes','no') DEFAULT NULL,
102 `ignoresdpversion` enum('yes','no') DEFAULT NULL,
103 `allowtransfer` enum('yes','no') DEFAULT NULL,
104 `dynamic` enum('yes','no') DEFAULT NULL,
105 PRIMARY KEY (`id`),
106 UNIQUE KEY `name` (`name`),
107 KEY `ipaddr` (`ipaddr`,`port`),
108 KEY `host` (`host`,`port`)
109) ENGINE=MyISAM;