```[sql] CREATE TABLE IF NOT EXISTS `me_tags` ( `id` bigint(20) NOT NULL COMMENT '标签ID', `name` varchar(100) NOT NULL, `num` int(11) NOT NULL COMMENT '数量', `bgColor` varchar(50) NOT NULL COMMENT '颜色值', `articleTableName` varchar(100) NOT NULL COMMENT '对应文章表名', `create_time` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COMMENT='标签名'; ```  ***** ```[sql] CREATE TABLE IF NOT EXISTS `me_tagmap` ( `id` bigint(20) NOT NULL, `tagid` bigint(20) NOT NULL COMMENT '标签ID', `article_id` bigint(20) NOT NULL COMMENT '文章ID', `articleTableName` varchar(100) NOT NULL COMMENT '表名' ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4; ``` ```[sql] CREATE TABLE IF NOT EXISTS `me_tag_article` ( `id` int(11) NOT NULL, `article_title` varchar(100) NOT NULL COMMENT '文章标题', `article_tags` text NOT NULL COMMENT 'Tags', `create_time` int(11) NOT NULL COMMENT '创建时间' ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='文章标签测试表'; ```