[asterisk-bugs] [Asterisk 0018915]: [patch] PATCH: Fixes to MySQL sql files

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18915 
====================================================================== 
Reported By:                Dovid
Assigned To:                russell
====================================================================== 
Project:                    Asterisk
Issue ID:                   18915
Category:                   Resources/res_realtime
Reproducibility:            N/A
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.8.3 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2011-03-03 04:17 CST
Last Modified:              2011-05-05 18:13 CDT
====================================================================== 
Summary:                    [patch] PATCH: Fixes to MySQL sql files
Description: 
Hi,

Both meetme.sql sipfriends.sql have syntax errors (they have a "," in the
wrong place). Also for sipfriends.sql TYPE=MyISAM has been changed to
ENGINE=MYISAM. In the latest versions of MySQL (5.5.9) this wont even
work.

I do not know how to put both patches in to one so I uploading both files
(my first patch so please go easy). 
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
duplicate of        0018537 [patch] MySQL table definitions are bro...
====================================================================== 

---------------------------------------------------------------------- 
 (0134560) svnbot (reporter) - 2011-05-05 18:13
 https://issues.asterisk.org/view.php?id=18915#c134560 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 317485

_U  trunk/
U   trunk/contrib/realtime/mysql/meetme.sql
U   trunk/contrib/realtime/mysql/sipfriends.sql

------------------------------------------------------------------------
r317485 | russell | 2011-05-05 18:13:05 -0500 (Thu, 05 May 2011) | 15
lines

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 https://issues.asterisk.org/view.php?id=18915)
  Reported by: Dovid
  Patches:
        sipfriends.patch uploaded by Dovid (license 652)
        meetme.patch uploaded by Dovid (license 652)
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=317485 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-05-05 18:13 svnbot         Checkin                                      
2011-05-05 18:13 svnbot         Note Added: 0134560                          
======================================================================