<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é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)"> CREATE TABLE pua (</span></div>
<div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)"> version INT(11) NOT NULL,</div>
<div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)"> extra_headers TEXT NOT NULL,</div>
<div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)"> CONSTRAINT pua_idx UNIQUE (etag, tuple_id, call_id, 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)">- CONSTRAINT expires_idx UNIQUE (expires)</div>
<div class="diff"
style="font-family:monospace;white-space:pre;background-color:rgb(255,255,255)"> ) 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>