20 Mar
2012
20 Mar
'12
12:51 p.m.
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:
--
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