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@lists.sip-router.org mailto:sr-dev@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev