[sr-dev] git:master: utils/kamctl: rebuilt .sql files to reflect changes to pua, rls , and xcap tables
Daniel-Constantin Mierla
miconda at gmail.com
Tue Mar 20 17:51:37 CET 2012
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 <mailto: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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20120320/2661c35f/attachment.htm>
More information about the sr-dev
mailing list