mysql5.7外键_mysql5.7 创建表外键失败 求看下！！！！ 折磨我一天了？

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执行有没问题