~~~ CREATE TABLE `sbh_artnews` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `unionid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信ID', `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称', `headurl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像路径', `title` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题', `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型', `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '缩略图', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `isdisplay` int(11) DEFAULT '0' COMMENT '0正在审核1审核通过2审核未通过', `bid` int(20) DEFAULT '0' COMMENT '文章类别：0发布文章1广告文章2置顶文章', `swa` bigint(10) DEFAULT '0' COMMENT '阅读量', `collect` bigint(10) DEFAULT '0' COMMENT '收藏量', `like` bigint(11) DEFAULT '0' COMMENT '点赞量', `company` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司名称', `audit_user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审核专员', `audit_time` datetime DEFAULT NULL COMMENT '审核时间', `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址', PRIMARY KEY (`id`) ) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8mb4 INSERT_METHOD=LAST UNION=(`sbh_artnews0`,`sbh_artnews1`,`sbh_artnews2`,`sbh_artnews3`,`sbh_artnews4`,`sbh_artnews5`,`sbh_artnews6`,`sbh_artnews7`,`sbh_artnews8`,`sbh_artnews9`); ~~~