Summary:	ASTERISK-15279: [patch] SIP Realtime SQL Table
Reporter:	Paul Belanger (pabelanger)	Labels:
Date Opened:	2009-12-05 02:25:30.000-0600	Date Closed:	2011-05-06 14:15:47
Priority:	Blocker	Regression?	No
Status:	Closed/Complete	Components:	Documentation
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) sipfriends.sql ( 1) sipfriends.sql.v2 ( 2) sipfriends.sql.v3
Description:	Since I have not been able to locate a properly documented MySQL table for SIP Realtime, I have decided create one from channel_sip.c source.  Please have a look at the attached file and comment on its structure.
Comments:	By: Paul Belanger (pabelanger) 2009-12-05 02:29:07.000-0600 This version _should_ include all variables for a SIP Peer to be configured.  Some of the default settings need to be verified, as well most still need there _type_ setting modified (I need to research what the default variable size). By: Paul Belanger (pabelanger) 2009-12-06 03:32:07.000-0600 Version 2: Updated more default settings, re-include some missing fields. I am also curious if we should check to see if there fields exist in the database using ast_realtime_require_field() function, we currently check some fields when the module loads. By: Paul Belanger (pabelanger) 2009-12-07 14:28:44.000-0600 Version 3: Removed 'DEFAULT' settings, except for name. By: Jonathan Thurman (jthurman) 2011-01-03 18:27:27.000-0600 Maybe remove 'ENGINE=MyISAM' so that the configured default storage engine for MySQL is used.  That way if someone always uses InnoDB, they don't have to edit the file or alter the table. By: Andrew Latham (lathama) 2011-02-06 20:14:01.000-0600 What is the holdup here?  Can this get committed? By: Tilghman Lesher (tilghman) 2011-02-07 01:56:53.000-0600 What's wrong with the table at contrib/realtime/mysql/sipfriends.sql? By: Andrew Latham (lathama) 2011-02-07 06:01:29.000-0600 The patch https://issues.asterisk.org/file_download.php?file_id=24722&type=bug has fields missing in the project version http://svn.asterisk.org/svn/asterisk/trunk/contrib/realtime/mysql/sipfriends.sql By: Digium Subversion (svnbot) 2011-05-06 14:14:40 Repository: asterisk Revision: 317805 U   branches/1.8/contrib/realtime/mysql/sipfriends.sql ------------------------------------------------------------------------ r317805 | russell | 2011-05-06 14:14:40 -0500 (Fri, 06 May 2011) | 7 lines Add a new sipfriends.sql for MySQL that has more fields in it. (closes issue ASTERISK-15279) Reported by: pabelanger Patches:      sipfriends.sql.v3 uploaded by pabelanger (license 224) ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=317805 By: Digium Subversion (svnbot) 2011-05-06 14:15:46 Repository: asterisk Revision: 317807 _U  trunk/ U   trunk/contrib/realtime/mysql/sipfriends.sql ------------------------------------------------------------------------ r317807 | russell | 2011-05-06 14:15:45 -0500 (Fri, 06 May 2011) | 14 lines Merged revisions 317805 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.8 ........  r317805 | russell | 2011-05-06 14:14:39 -0500 (Fri, 06 May 2011) | 7 lines    Add a new sipfriends.sql for MySQL that has more fields in it.    (closes issue ASTERISK-15279)  Reported by: pabelanger  Patches:        sipfriends.sql.v3 uploaded by pabelanger (license 224) ........ ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=317807