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

[Daniel-Constantin Mierla]

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>