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