[sr-dev] git:master: utils/kamctl: rebuilt .sql files to reflect changes to pua, rls , and xcap tables

[Peter Dunkley]

Hi Juha,

I have pushed a fix for this into git master.  Please let me know if you
have any further trouble.

Thanks,

Peter

On Tue, 2012-03-20 at 09:03 +0200, Juha Heinanen wrote:

> Peter Dunkley writes:
> 
> >  utils/kamctl/mysql/presence-create.sql     |   22
> >  +++++++++++++---------
> 
> peter,
> 
> something went wrong with this commit.  at least mysql version of
> resulting xcap table is now incorrect:
> 
> mysql> CREATE TABLE xcap (
>     ->     id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
>     ->     username VARCHAR(64) NOT NULL,
>     ->     domain VARCHAR(64) NOT NULL,
>     ->     doc MEDIUMBLOB NOT NULL,
>     ->     doc_type INT(11) NOT NULL,
>     ->     etag VARCHAR(64) NOT NULL,
>     ->     source INT(11) NOT NULL,
>     ->     doc_uri VARCHAR(255) PRIMARY KEY NOT NULL,
>     ->     port INT(11) NOT NULL,
>     ->     CONSTRAINT account_doc_type_idx UNIQUE (username, domain, doc_type),
>     ->     CONSTRAINT account_doc_type_uri_idx UNIQUE (username, domain, doc_type, doc_uri),
>     ->     CONSTRAINT account_doc_uri_idx UNIQUE (username, domain, doc_uri)
>     -> ) ENGINE=MyISAM;
> ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
> 
> problem is that id field is auto increment field, but does not anymore
> have a key.
> 
> -- juha
> 
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev


-- 
Peter Dunkley
Technical Director
Crocodile RCS Ltd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20120320/8a51149b/attachment-0001.htm>