diff options
author | russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b> | 2011-05-05 23:13:04 +0000 |
---|---|---|
committer | russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b> | 2011-05-05 23:13:04 +0000 |
commit | 7404df0ab3bced5f5774ebc0eb6adf0c79f81e44 (patch) | |
tree | 713a86ce844b6197263d2720222f029e1f006358 /contrib | |
parent | bce37370d3ffad9d0f7ec5c89132370fede02b58 (diff) |
Merged revisions 317484 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.8
........
r317484 | russell | 2011-05-05 18:12:35 -0500 (Thu, 05 May 2011) | 8 lines
Fix some errors in sample MySQL realtime schema files.
(closes issue #18915)
Reported by: Dovid
Patches:
sipfriends.patch uploaded by Dovid (license 652)
meetme.patch uploaded by Dovid (license 652)
........
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@317485 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
-rw-r--r-- | contrib/realtime/mysql/meetme.sql | 4 | ||||
-rw-r--r-- | contrib/realtime/mysql/sipfriends.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/contrib/realtime/mysql/meetme.sql b/contrib/realtime/mysql/meetme.sql index 7e79a8c74..5a1bac4bf 100644 --- a/contrib/realtime/mysql/meetme.sql +++ b/contrib/realtime/mysql/meetme.sql @@ -15,7 +15,7 @@ CREATE TABLE meetme ( recordingformat char(10) NULL, maxusers int(11) NULL, members integer DEFAULT 0 NOT NULL, - index confno (confno,starttime,endtime) - PRIMARY KEY (bookid), + index confno (confno,starttime,endtime), + PRIMARY KEY (bookid) ); diff --git a/contrib/realtime/mysql/sipfriends.sql b/contrib/realtime/mysql/sipfriends.sql index c7f10e934..93479a1cb 100644 --- a/contrib/realtime/mysql/sipfriends.sql +++ b/contrib/realtime/mysql/sipfriends.sql @@ -51,5 +51,5 @@ CREATE TABLE `sipfriends` ( `setvar` varchar(200), PRIMARY KEY (`name`), INDEX host (host, port), - INDEX ipaddr (ipaddr, port), -) TYPE=MyISAM; + INDEX ipaddr (ipaddr, port) +) ENGINE=MyISAM; |