summaryrefslogtreecommitdiff
path: root/contrib/realtime
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/realtime')
-rw-r--r--contrib/realtime/mysql/queue_log.sql2
-rw-r--r--contrib/realtime/mysql/sipfriends.sql1
2 files changed, 2 insertions, 1 deletions
diff --git a/contrib/realtime/mysql/queue_log.sql b/contrib/realtime/mysql/queue_log.sql
index 0b74f81a1..bc95e854a 100644
--- a/contrib/realtime/mysql/queue_log.sql
+++ b/contrib/realtime/mysql/queue_log.sql
@@ -20,5 +20,5 @@ CREATE TABLE queue_log (
data4 char(50),
data5 char(50),
index bydate (time),
- index qname (queuename,datetime)
+ index qname (queuename,time)
);
diff --git a/contrib/realtime/mysql/sipfriends.sql b/contrib/realtime/mysql/sipfriends.sql
index 93479a1cb..967cdf7d0 100644
--- a/contrib/realtime/mysql/sipfriends.sql
+++ b/contrib/realtime/mysql/sipfriends.sql
@@ -37,6 +37,7 @@ CREATE TABLE `sipfriends` (
`outboundproxy` varchar(40),
`ipaddr` varchar(40) NOT NULL default '',
`defaultip` varchar(20),
+ `dtmfmode` varchar(7) default NULL,
`port` int(6) NOT NULL default '0',
`fullcontact` varchar(40),
`insecure` varchar(20),