20 Mar
2012
20 Mar
'12
6:19 a.m.
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:
--
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
http://www.asipto.com/index.php/kamailio-advanced-training/
Peter Dunkley writes:
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev 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(a)lists.sip-router.org <mailto:sr-dev@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev