[sr-dev] git:master: utils/kamctl: rebuilt .sql files to reflect changes to pua, rls , and xcap tables

[Juha Heinanen]

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