- 论坛徽章:
- 0
|
CREATE TABLE lua_posts (
pid int(10) NOT NULL auto_increment,
append_edit tinyint(1) default '0',
edit_time int(10) default NULL,
author_id mediumint( NOT NULL default '0',
author_name varchar(32) default NULL,
use_sig tinyint(1) NOT NULL default '0',
use_emo tinyint(1) NOT NULL default '0',
ip_address varchar(16) NOT NULL default '',
post_date int(10) default NULL,
icon_id smallint(3) default NULL,
post text,
queued tinyint(1) NOT NULL default '0',
topic_id int(10) NOT NULL default '0',
post_title varchar(255) default NULL,
new_topic tinyint(1) default '0',
edit_name varchar(255) default NULL,
post_key varchar(32) NOT NULL default '0',
post_parent int(10) NOT NULL default '0',
post_htmlstate smallint(1) NOT NULL default '0',
PRIMARY KEY (pid),
KEY topic_id (topic_id,queued,pid),
KEY author_id (author_id,topic_id),
KEY post_date (post_date)
);
alter table lua_posts ADD FULLTEXT(post);
The used table type doesn't support FULLTEXT indexes
不能创建索引,这是咋回事啊,请高手指点 |
|