<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    you are right, it seems that the sql script was manually edited by
    Juha, it should be auto-generated via:<br>
    <br>
    make dbschema<br>
    <br>
    to avoid any such typos and generate the sql scripts for all
    database types.<br>
    <br>
    I pushed the commit on branch 3.3.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <div class="moz-cite-prefix">On 9/14/12 12:38 PM, Andr&eacute;s Souto Vidal
      wrote:<br>
    </div>
    <blockquote
cite="mid:CANpea9v9pq7R+r2FivVyn8=uz4AnO7tq_gOKcmDN6dvK48ZKxg@mail.gmail.com"
      type="cite">Hello,
      <div><br>
      </div>
      <div>I think this commit:</div>
      <div>
        <pre>Module: sip-router
Branch: 3.3
Commit: 82ca28c8a523c015b69a3c56d02983356faefc54
URL:    <a moz-do-not-send="true" href="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=82ca28c8a523c015b69a3c56d02983356faefc54">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=82ca28c8a523c015b69a3c56d02983356faefc54</a></pre>
        <div>introduced a bug creating the presence table by kamdbctl.</div>
        <div><br>
        </div>
      </div>
      <div>The problem is the comma in the previous line:</div>
      <div>
        <div class="diff from_file"
style="font-family:monospace;white-space:pre;color:rgb(170,0,0);background-color:rgb(255,255,255)">---
          a/<a moz-do-not-send="true" class="path"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=utils/kamctl/mysql/presence-create.sql;h=5584f8e3c54c3dac538bfff5a85ba9ee3d382066;hb=5584f8e3c54c3dac538bfff5a85ba9ee3d382066"
            style="color:rgb(170,0,0)">utils/kamctl/mysql/presence-create.sql</a></div>
        <div class="diff to_file"
style="font-family:monospace;white-space:pre;color:rgb(0,112,0);background-color:rgb(255,255,255)">+++
          b/<a moz-do-not-send="true" class="path"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=utils/kamctl/mysql/presence-create.sql;h=7f68249086de1aac358311fbcd232d3fce8b7681;hb=7f68249086de1aac358311fbcd232d3fce8b7681"
            style="color:rgb(0,112,0);text-decoration:none">utils/kamctl/mysql/presence-create.sql</a></div>
        <div class="diff chunk_header"
          style="font-family:monospace;white-space:pre;color:rgb(153,0,153);border-style:dotted;border-color:rgb(255,224,255);border-width:1px
          0px 0px;margin-top:2px;background-color:rgb(255,255,255)">
          <span class="chunk_info"
            style="background-color:rgb(255,238,255)">@@ <a
              moz-do-not-send="true" class="list"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=utils/kamctl/mysql/presence-create.sql;h=5584f8e3c54c3dac538bfff5a85ba9ee3d382066;hb=5584f8e3c54c3dac538bfff5a85ba9ee3d382066#l103"
              style="color:rgb(153,0,153);text-decoration:none">-103,7</a>
            <a moz-do-not-send="true" class="list"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=blob;f=utils/kamctl/mysql/presence-create.sql;h=7f68249086de1aac358311fbcd232d3fce8b7681;hb=7f68249086de1aac358311fbcd232d3fce8b7681#l103"
              style="color:rgb(153,0,153);text-decoration:none">+103,6</a>
            @@</span><span class="section" style="color:rgb(170,34,170)">&nbsp;CREATE&nbsp;TABLE&nbsp;pua&nbsp;(</span></div>
        <div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;version&nbsp;INT(11)&nbsp;NOT&nbsp;NULL,</div>
        <div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;extra_headers&nbsp;TEXT&nbsp;NOT&nbsp;NULL,</div>
        <div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONSTRAINT&nbsp;pua_idx&nbsp;UNIQUE&nbsp;(etag,&nbsp;tuple_id,&nbsp;call_id,&nbsp;from_tag),</div>
        <div class="diff rem"
style="font-family:monospace;white-space:pre;color:rgb(204,0,0);background-color:rgb(255,255,255)">-&nbsp;&nbsp;&nbsp;&nbsp;CONSTRAINT&nbsp;expires_idx&nbsp;UNIQUE&nbsp;(expires)</div>
        <div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)">&nbsp;)&nbsp;ENGINE=MyISAM;</div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
sr-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a>
Kamailio Advanced Training, Miami, USA, Nov 12-14, 2012 - <a class="moz-txt-link-freetext" href="http://asipto.com/u/katu">http://asipto.com/u/katu</a></pre>
  </body>
</html>