mysql> CREATE TABLE `sphinx` (
-> `id` int(11) NOT NULL,
-> `weight` int(11) NOT NULL,
-> `query` varchar(255) NOT NULL,
-> `CATALOGID` INT NOT NULL,
-> `EDITUSERID` INT NOT NULL,
-> `HITS` INT NULL,
-> `ADDTIME` INT NOT NULL,
-> KEY `Query` (`Query`)
-> ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:3312/cgfinal';
ERROR 1005 (HY000): Can't create table './test/sphinx: 1st column (docid) MUST be unsigned integer or bigint' (errno: -1)
阅读(1459) | 评论(0) | 转发(0) |
