asterisk 1.8.15 realtime base
На день сегодняшний базы такие:
в таблице sipfriends поля allow и disallow поменяны местами иначе баг с разрешенными кодаками
#
# Table structure for table `sipfriends`
#
CREATE TABLE IF NOT EXISTS `sipfriends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL,
`ipaddr` varchar(15) DEFAULT NULL,
`port` int(5) DEFAULT NULL,
`regseconds` int(11) DEFAULT NULL,
`defaultuser` varchar(10) DEFAULT NULL,
`fullcontact` varchar(35) DEFAULT NULL,
`regserver` varchar(20) DEFAULT NULL,
`useragent` varchar(20) DEFAULT NULL,
`lastms` int(11) DEFAULT NULL,
`host` varchar(40) DEFAULT NULL,
`type` enum('friend','user','peer') DEFAULT NULL,
`context` varchar(40) DEFAULT NULL,
`permit` varchar(40) DEFAULT NULL,
`deny` varchar(40) DEFAULT NULL,
`secret` varchar(40) DEFAULT NULL,
`md5secret` varchar(40) DEFAULT NULL,
`remotesecret` varchar(40) DEFAULT NULL,
`transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,
`dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
`directmedia` enum('yes','no','nonat','update') DEFAULT NULL,
`nat` enum('yes','no','never','route') DEFAULT NULL,
`callgroup` varchar(40) DEFAULT NULL,
`pickupgroup` varchar(40) DEFAULT NULL,
`language` varchar(40) DEFAULT NULL,
`disallow` varchar(40) DEFAULT NULL,
`allow` varchar(40) DEFAULT NULL,
`insecure` varchar(40) DEFAULT NULL,
`trustrpid` enum('yes','no') DEFAULT NULL,
`progressinband` enum('yes','no','never') DEFAULT NULL,
`promiscredir` enum('yes','no') DEFAULT NULL,
`useclientcode` enum('yes','no') DEFAULT NULL,
`accountcode` varchar(40) DEFAULT NULL,
`setvar` varchar(40) DEFAULT NULL,
`callerid` varchar(40) DEFAULT NULL,
`amaflags` varchar(40) DEFAULT NULL,
`callcounter` enum('yes','no') DEFAULT NULL,
`busylevel` int(11) DEFAULT NULL,
`allowoverlap` enum('yes','no') DEFAULT NULL,
`allowsubscribe` enum('yes','no') DEFAULT NULL,
`videosupport` enum('yes','no') DEFAULT NULL,
`maxcallbitrate` int(11) DEFAULT NULL,
`rfc2833compensate` enum('yes','no') DEFAULT NULL,
`mailbox` varchar(40) DEFAULT NULL,
`session-timers` enum('accept','refuse','originate') DEFAULT NULL,
`session-expires` int(11) DEFAULT NULL,
`session-minse` int(11) DEFAULT NULL,
`session-refresher` enum('uac','uas') DEFAULT NULL,
`t38pt_usertpsource` varchar(40) DEFAULT NULL,
`regexten` varchar(40) DEFAULT NULL,
`fromdomain` varchar(40) DEFAULT NULL,
`fromuser` varchar(40) DEFAULT NULL,
`qualify` varchar(40) DEFAULT NULL,
`defaultip` varchar(40) DEFAULT NULL,
`rtptimeout` int(11) DEFAULT NULL,
`rtpholdtimeout` int(11) DEFAULT NULL,
`sendrpid` enum('yes','no') DEFAULT NULL,
`outboundproxy` varchar(40) DEFAULT NULL,
`callbackextension` varchar(40) DEFAULT NULL,
`registertrying` enum('yes','no') DEFAULT NULL,
`timert1` int(11) DEFAULT NULL,
`timerb` int(11) DEFAULT NULL,
`qualifyfreq` int(11) DEFAULT NULL,
`constantssrc` enum('yes','no') DEFAULT NULL,
`contactpermit` varchar(40) DEFAULT NULL,
`contactdeny` varchar(40) DEFAULT NULL,
`usereqphone` enum('yes','no') DEFAULT NULL,
`textsupport` enum('yes','no') DEFAULT NULL,
`faxdetect` enum('yes','no') DEFAULT NULL,
`buggymwi` enum('yes','no') DEFAULT NULL,
`auth` varchar(40) DEFAULT NULL,
`fullname` varchar(40) DEFAULT NULL,
`trunkname` varchar(40) DEFAULT NULL,
`cid_number` varchar(40) DEFAULT NULL,
`callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
`mohinterpret` varchar(40) DEFAULT NULL,
`mohsuggest` varchar(40) DEFAULT NULL,
`parkinglot` varchar(40) DEFAULT NULL,
`hasvoicemail` enum('yes','no') DEFAULT NULL,
`subscribemwi` enum('yes','no') DEFAULT NULL,
`vmexten` varchar(40) DEFAULT NULL,
`autoframing` enum('yes','no') DEFAULT NULL,
`rtpkeepalive` int(11) DEFAULT NULL,
`call-limit` int(11) DEFAULT NULL,
`g726nonstandard` enum('yes','no') DEFAULT NULL,
`ignoresdpversion` enum('yes','no') DEFAULT NULL,
`allowtransfer` enum('yes','no') DEFAULT NULL,
`dynamic` enum('yes','no') DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `ipaddr` (`ipaddr`,`port`),
KEY `host` (`host`,`port`)
) ENGINE=MyISAM;
CREATE TABLE voicemail (
uniqueid INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
context CHAR(80) NOT NULL DEFAULT 'default',
mailbox CHAR(80) NOT NULL,
password CHAR(80) NOT NULL,
fullname CHAR(80),
email CHAR(80),
pager CHAR(80),
attach CHAR(3),
attachfmt CHAR(10),
serveremail CHAR(80),
language CHAR(20),
tz CHAR(30),
deletevoicemail CHAR(3),
saycid CHAR(3),
sendvoicemail CHAR(3),
review CHAR(3),
tempgreetwarn CHAR(3),
operator CHAR(3),
envelope CHAR(3),
sayduration CHAR(3),
saydurationm INT(3),
forcename CHAR(3),
forcegreetings CHAR(3),
callback CHAR(80),
dialout CHAR(80),
exitcontext CHAR(80),
maxmsg INT(5),
volgain DECIMAL(5,2),
imapuser VARCHAR(80),
imappassword VARCHAR(80),
stamp timestamp
);
CREATE TABLE musiconhold (
name char(80) not null primary key,
mode char(80) null,
directory char(255) null,
application char(255) null,
digit char(1) null,
sort char(10) null,
format char(10) null,
stamp timestamp
);
CREATE TABLE queue_log (
time datetime,
callid char(50),
queuename char(50),
agent char(50),
event char(20),
data1 char(50),
data2 char(50),
data3 char(50),
data4 char(50),
data5 char(50),
index bydate (time),
index qname (queuename,time)
);
CREATE TABLE meetme (
bookid int(11) auto_increment,
confno char(80) DEFAULT '0' NOT NULL,
starttime datetime default '1900-01-01 12:00:00',
endtime datetime default '2038-01-01 12:00:00',
pin char(20) NULL,
adminpin char(20) NULL,
opts char(20) NULL,
adminopts char(20) NULL,
recordingfilename char(80) NULL,
recordingformat char(10) NULL,
maxusers int(11) NULL,
members integer DEFAULT 0 NOT NULL,
index confno (confno,starttime,endtime),
PRIMARY KEY (bookid)
);
CREATE TABLE voicemail_data (
filename CHAR(255) NOT NULL PRIMARY KEY,
origmailbox CHAR(80),
context CHAR(80),
macrocontext CHAR(80),
exten CHAR(80),
priority INT(5),
callerchan CHAR(80),
callerid CHAR(80),
origdate CHAR(30),
origtime INT(11),
category CHAR(30),
duration INT(11)
);
CREATE TABLE voicemail_messages (
dir CHAR(255),
msgnum INT(4),
context CHAR(80),
macrocontext CHAR(80),
callerid CHAR(80),
origtime INT(11),
duration INT(11),
recording BLOB,
flag CHAR(30),
category CHAR(30),
mailboxuser CHAR(30),
mailboxcontext CHAR(30),
PRIMARY KEY (dir, msgnum)
);
UPD
и это не баг!
_________________
Jabber конференция
сервер: conference.jabber.ru
комната: asterisk