<html>
<head>
    <base href="https://wiki.asterisk.org/wiki">
            <link rel="stylesheet" href="/wiki/s/en/2176/25/9/_/styles/combined.css?spaceKey=AST&amp;forWysiwyg=true" type="text/css">
    </head>
<body style="background: white;" bgcolor="white" class="email-body">
<div id="pageContent">
<div id="notificationFormat">
<div class="wiki-content">
<div class="email">
    <h2><a href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure?focusedCommentId=22773842#comment-22773842">SIP Realtime, MySQL table structure</a></h2>
        <h4>Page
        <b>comment added</b> by              <a href="https://wiki.asterisk.org/wiki/display/~ghepeath">Gheirel Peart</a>
    </h4>
    <br/>
    <div class="notificationGreySide">
       <p>Thank you</p>
    </div>

                <div style="border-bottom: 1px solid #ddd; padding: 10px 20px 7px 20px;">
        <strong>In reply to a comment by <a href="/wiki/display/~v.koqep@gmail.com"
                          class="url fn confluence-userlink" data-username="v.koqep@gmail.com"
                   >Vladimir</a>:</strong><br/>
        <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent">
<script type="syntaxhighlighter" class="theme: Confluence; brush: sql; gutter: false"><![CDATA[CREATE VIEW `sipregs` AS SELECT
    `id`
    ,`name`
    ,`ipaddr`
    ,`port`
    ,`regseconds`
    ,`defaultuser`
    ,`fullcontact`
    ,`regserver`
    ,`useragent`
    ,`lastms`
FROM `sippeers`;]]></script>
</div></div>
        </div>
    
    <div id="commentsSection" class="wiki-content pageSection">
      <div style="float: right;" class="grey">
                        <a href="https://wiki.asterisk.org/wiki/users/removespacenotification.action?spaceKey=AST">Stop watching space</a>
            <span style="padding: 0px 5px;">|</span>
                <a href="https://wiki.asterisk.org/wiki/users/editmyemailsettings.action">Change email notification preferences</a>
</div>
       <a href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure?focusedCommentId=22773842#comment-22773842">View Online</a>
              |
       <a id="reply-22773842" href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure?replyToComment=22773842#comment-22773842">Reply To This</a>
           </div>

</div>
</div>
</div>
</div>
</body>
</html>