[asterisk-bugs] [Asterisk 0018537]: [patch] MySQL table definitions are broken (wrong commas and a wrong name)

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18537 
====================================================================== 
Reported By:                denzs
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18537
Category:                   Documentation
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.8.1.1 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-12-27 06:21 CST
Last Modified:              2010-12-28 08:15 CST
====================================================================== 
Summary:                    [patch] MySQL table definitions are broken (wrong
commas and a wrong name)
Description: 
In contrib/realtime/mysql/queue_log.sql the column "datetime" is referenced
as index, but the correct name is "time".

In contrib/realtime/mysql/sipfriends.sql
there is a comma in the last line inside of the brackets.

In contrib/realtime/mysql/meetme.sql
there is a comma in the last line inside of the brackets.
====================================================================== 

---------------------------------------------------------------------- 
 (0130003) denzs (reporter) - 2010-12-28 08:15
 https://issues.asterisk.org/view.php?id=18537#c130003 
---------------------------------------------------------------------- 
as far as i can rate, i think the meetme.sql.svndiff and
queue_log.sql.svndiff file should be good.

but iam still unsure about the sipfriends table...
after adding dtmfmode i still miss columns like nat, directmedia

the sip_devices template from
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip
has some other interesting columns too...like

sendrpid
session-expires
session-minse
session-refresher
session-timers
videosupport
permit
deny
...
and some more

i would prefer to have all possible sip.conf-settings in the template

what do you think?!

if desired i will merge the different templates and try to straighten it a
bit ;) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-28 08:15 denzs          Note Added: 0130003                          
======================================================================