执行以下，
CREATE TABLE IF NOT EXISTS sphinxc (
id int(11) NOT NULL,
weight int(11) NOT NULL,
query varchar(255) NOT NULL,
INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:3312/yicike_search_ctitle';
错误如下：
sphinx: 1st column (docid) MUST be unsigned integer or bigint' (errno: -1)

解决如下：

CREATE TABLE IF NOT EXISTS sphinxc (
id int(10) unsigned not null,
weight int(11) NOT NULL,
query varchar(255) NOT NULL,
INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:3312/yicike_search_ctitle';