summaryrefslogtreecommitdiff
path: root/contrib/realtime
diff options
context:
space:
mode:
authorRussell Bryant <russell@russellbryant.com>2011-05-05 23:16:16 +0000
committerRussell Bryant <russell@russellbryant.com>2011-05-05 23:16:16 +0000
commit79b2c65249928f66e7f6d69be79507020d358f54 (patch)
treeec43ff63f5d5e22b11a47cad318d5ff47b0bd503 /contrib/realtime
parenta6a4b811b7dfec36c3f24da0619b899a253082c1 (diff)
Merged revisions 317486 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.8 ........ r317486 | russell | 2011-05-05 18:15:53 -0500 (Thu, 05 May 2011) | 9 lines Fix some more realtime MySQL schema issues. (closes issue #18537) Reported by: denzs Patches: sipfriends.sql.svndiff uploaded by denzs (license 1182) queue_log.sql.svndiff uploaded by denzs (license 1182) meetme.sql.svndiff uploaded by denzs (license 1182) ........ git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@317487 65c4cc65-6c06-0410-ace0-fbb531ad65f3
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),