慕婉清6462132
CREATE TABLE `trkr_admin` ( `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员ID编号', `name` CHAR(30) NOT NULL DEFAULT '' COMMENT '管理员账号', `cname` CHAR(30) NOT NULL DEFAULT '' COMMENT '管理员昵称', `password` CHAR(32) NOT NULL DEFAULT '' COMMENT '管理员密码', `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '账号状态 1开启 2关闭',
PRIMARY KEY (`id`), UNIQUE INDEX `name` (`name`), UNIQUE INDEX `cname` (`cname`)
)COLLATE='utf8mb4_general_ci'ENGINE=InnoDB;CREATE TABLE `trkr_article` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章ID编号', `title` CHAR(20) NOT NULL DEFAULT '' COMMENT '文章标题名称', `content` VARCHAR(16000) NOT NULL DEFAULT ' ' COMMENT '文章的内容', `bind_adminname_id` TINYINT(3) UNSIGNED NOT NULL COMMENT '发表文章的作者外键',
PRIMARY KEY (`id`), INDEX `bind_adminname_id` (`bind_adminname_id`), CONSTRAINT `trkr_article_ibfk_1` FOREIGN KEY (`bind_adminname_id`) REFERENCES `trkr_admin` (`id`),
FULLTEXT (title,content) WITH PARSER ngram
)COLLATE='utf8mb4_general_ci'ENGINE=InnoDB;看样子像是子表字段索引没建?或者你那个解析器ngram执行有没问题