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

[Peter Dunkley]

I noticed it immediately after I did the push.  Fixed it this time.

Peter

On Tue, 2012-03-20 at 17:51 +0100, Daniel-Constantin Mierla wrote:

> Hello,
> 
> I think you forgot to add column reference in the unique key:
> 
> 
> +    CONSTRAINT xcap_doc_uri_idx UNIQUE ()
> 
> 
> Cheers,
> Daniel
> 
> On 3/20/12 5:48 PM, Peter Dunkley wrote: 
> 
> > 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
> > 
> > 
> > 
> > _______________________________________________
> > sr-dev mailing list
> > sr-dev at lists.sip-router.org
> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
> 
> 
> 
> -- 
> Daniel-Constantin Mierla
> Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
> http://www.asipto.com/index.php/kamailio-advanced-training/


-- 
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/e3100cc6/attachment.htm>