diff options
| author | Russell Bryant <russell@russellbryant.com> | 2011-05-05 23:13:04 +0000 |
|---|---|---|
| committer | Russell Bryant <russell@russellbryant.com> | 2011-05-05 23:13:04 +0000 |
| commit | a6a4b811b7dfec36c3f24da0619b899a253082c1 (patch) | |
| tree | 713a86ce844b6197263d2720222f029e1f006358 /contrib/realtime | |
| parent | 695bc7df940c90d87a47e877705b7efa09b6a53d (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: https://origsvn.digium.com/svn/asterisk/trunk@317485 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/realtime')
| -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; |