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