<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<div><br></div><div>I would like to offer a $500 bounty to have the 'systemname' added to registrations (contacts) stored in the PJSIP realtime.</div><div><br></div><div>The current table structure is as follows:</div><div><br></div><div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div><font size="2">CREATE TABLE `ps_contacts` (</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`id` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`uri` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`expiration_time` VARCHAR(40) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`qualify_frequency` INT(11) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`outbound_proxy` VARCHAR(40) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`path` TEXT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>`user_agent` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>UNIQUE INDEX `id` (`id`),</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span>INDEX `ps_contacts_id` (`id`)</font></div></div><div><div><font size="2">)</font></div></div><div><div><font size="2">COLLATE='latin1_swedish_ci'</font></div></div><div><div><font size="2">ENGINE=InnoDB</font><span style="font-size: 10pt;">;</span></div></div><div><span style="font-size: 10pt;"><br></span></div></blockquote><div><br></div><div>We would like to add an extra column called 'server', which is populated with the 'systemname' asterisk currently has defined. This in effect is re-implementing the 'regserver' column, which was in the SIP channel driver in previous versions.</div><div><br></div><div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div><font size="2">CREATE TABLE `ps_contacts` (</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`id` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`uri` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`expiration_time` VARCHAR(40) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`qualify_frequency` INT(11) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`outbound_proxy` VARCHAR(40) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`path` TEXT NULL,</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>`user_agent` VARCHAR(255) NULL DEFAULT NULL,</font></div></div><div><div><font size="2"> <b>`server` VARCHAR(255) NULL DEFAULT NULL,</b></font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>UNIQUE INDEX `id` (`id`),</font></div></div><div><div><font size="2"><span class="Apple-tab-span" style="white-space: pre;"> </span>INDEX `ps_contacts_id` (`id`)</font></div></div><div><div><font size="2">)</font></div></div><div><div><font size="2">COLLATE='latin1_swedish_ci'</font></div></div><div><div><font size="2">ENGINE=InnoDB</font><span style="font-size: 10pt;">;</span></div></div><div><span style="font-size: 10pt;"><br></span></div><div><span style="font-size: 10pt;"><br></span></div></blockquote>Would anyone like to accept the challenge?<div><br></div><div>If you require any further information, please contact me.<br><div><br></div><div>Regards,</div><div><br>Ross</div></div> </div></body>
</html>