Hello,

you are right, it seems that the sql script was manually edited by Juha, it should be auto-generated via:

make dbschema

to avoid any such typos and generate the sql scripts for all database types.

I pushed the commit on branch 3.3.

Cheers,
Daniel

On 9/14/12 12:38 PM, Andrés Souto Vidal wrote:

Hello,

I think this commit:
Module: sip-router
Branch: 3.3
Commit: 82ca28c8a523c015b69a3c56d02983356faefc54
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=82ca28c8a523c015b69a3c56d02983356faefc54
introduced a bug creating the presence table by kamdbctl.
The problem is the comma in the previous line:

--- a/utils/kamctl/mysql/presence-create.sql

+++ b/utils/kamctl/mysql/presence-create.sql

@@ -103,7 +103,6 @@ CREATE TABLE pua (

     version INT(11) NOT NULL,

     extra_headers TEXT NOT NULL,

     CONSTRAINT pua_idx UNIQUE (etag, tuple_id, call_id, from_tag),

-    CONSTRAINT expires_idx UNIQUE (expires)

) ENGINE=MyISAM;
_______________________________________________
sr-dev mailing list
sr-dev@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
Kamailio Advanced Training, Miami, USA, Nov 12-14, 2012 - http://asipto.com/u/katu