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

[Daniel-Constantin Mierla]

Hello,

cannot doc_uri be just unique key? It is how we have the db schema, id 
is primary key and the other constraints are unique keys -- it worked 
very well so far with all db engines.

Cheers,
Daniel

On 3/20/12 11:09 AM, Peter Dunkley wrote:
> Hi,
>
> That's interesting.
>
> I am using PostgreSQL here, and it seems (with PostgreSQL) at least, 
> an auto-increment field doesn't have to be a primary key - which is 
> good as the doc_uri really should be the primary key on this table.
>
> Is there anyone who is more familiar with the Kamailio DB schema and 
> MySQL who can tell me if there is a way to make ID a non-primary key, 
> and whether or not this will allow ID to be auto-increment?
>
> 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/01eddf95/attachment-0001.htm>