diff options
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; |