<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing
        {mso-style-priority:1;
        margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.font
        {mso-style-name:font;}
span.size
        {mso-style-name:size;}
span.colour
        {mso-style-name:colour;}
span.EmailStyle22
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks
</span><span style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">J</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org]
<b>On Behalf Of </b>Michael Avers<br>
<b>Sent:</b> Wednesday, April 11, 2018 3:53 PM<br>
<b>To:</b> freeswitch-users@lists.freeswitch.org<br>
<b>Subject:</b> Re: [Freeswitch-users] database schemas<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Here you go:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><a href="https://github.com/fusionpbx/fusionpbx/blob/master/resources/install/sql/switch.sql">https://github.com/fusionpbx/fusionpbx/blob/master/resources/install/sql/switch.sql</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">On Wed, Apr 11, 2018, at 2:49 PM, Bob McCarthy wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p style="margin:0in;margin-bottom:.0001pt"><span class="colour"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Looking specifically for sip_presence …..</span></span><o:p></o:p></p>
<p style="margin:0in;margin-bottom:.0001pt"><span class="colour"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span></span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in;border-right-width:initial;border-bottom-width:initial;border-left-width:initial;border-right-color:initial;border-bottom-color:initial;border-left-color:initial;border-image-source:initial;border-image-slice:initial;border-image-width:initial;border-image-outset:initial;border-image-repeat:initial">
<p style="margin:0in;margin-bottom:.0001pt"><span class="size"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b></span><span class="size"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> FreeSWITCH-users [<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Bob McCarthy</span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><br>
<span class="size"><b>Sent:</b> Tuesday, April 10, 2018 5:13 AM</span><br>
<span class="size"><b>To:</b> FreeSWITCH Users Help <<a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a>></span><br>
<span class="size"><b>Subject:</b> [Freeswitch-users] database schemas</span></span><o:p></o:p></p>
</div>
</div>
<p style="margin:0in;margin-bottom:.0001pt"><span class="size"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span></span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#910A19;padding:5.25pt 1.5pt 5.25pt 1.5pt;background-image:initial;background-position-x:initial;background-position-y:initial;background-size:initial;background-repeat:initial;background-repeat:initial;background-attachment:initial;background-origin:initial;background-clip:initial">
</td>
<td width="100%" style="width:100.0%;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 11.25pt;background-image:initial;background-position-x:initial;background-position-y:initial;background-size:initial;background-repeat:initial;background-repeat:initial;background-attachment:initial;background-origin:initial;background-clip:initial;word-wrap:break-word">
<div>
<p style="margin:0in;margin-bottom:.0001pt;mso-element:frame;mso-element-frame-hspace:1.5pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span class="size"><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#212121">This sender failed our fraud detection checks and may not be who they appear to be. Learn about <a href="http://aka.ms/LearnAboutSpoofing"><span style="color:#0563C1">spoofing</span></a></span></span><o:p></o:p></p>
</div>
</td>
<td width="56" style="width:56.25pt;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 3.75pt;background-image:initial;background-position-x:initial;background-position-y:initial;background-size:initial;background-repeat:initial;background-repeat:initial;background-attachment:initial;background-origin:initial;background-clip:initial;word-wrap:break-word">
<p style="margin:0in;margin-bottom:.0001pt;mso-element:frame;mso-element-frame-hspace:1.5pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span class="size"><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#212121"><a href="http://aka.ms/SafetyTipsFeedback"><span style="color:#0563C1">Feedback</span></a></span></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div>
<p style="margin:0in;margin-bottom:.0001pt"><span class="size"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Where are the schemas for the freeswitch databases documented ?</span></span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><u>_________________________________________________________________________</u><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Professional FreeSWITCH Consulting Services:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:consulting@freeswitch.org"><span style="color:#0563C1">consulting@freeswitch.org</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.freeswitchsolutions.com"><span style="color:#0563C1">http://www.freeswitchsolutions.com</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Official FreeSWITCH Sites<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.freeswitch.org"><span style="color:#0563C1">http://www.freeswitch.org</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://confluence.freeswitch.org"><span style="color:#0563C1">http://confluence.freeswitch.org</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.cluecon.com"><span style="color:#0563C1">http://www.cluecon.com</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">FreeSWITCH-users mailing list<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:FreeSWITCH-users@lists.freeswitch.org"><span style="color:#0563C1">FreeSWITCH-users@lists.freeswitch.org</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"><span style="color:#0563C1">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.freeswitch.org"><span style="color:#0563C1">http://www.freeswitch.org</span></a><o:p></o:p></p>
</div>
</blockquote>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
</div>
</body>
</html>