多应用+插件架构,代码干净,二开方便,首家独创一键云编译技术,文档视频完善,免费商用码云13.8K 广告
帮助中心sas网站(可以自动回复,可以生成帮助文档) 1、注册用户 2、编辑导航 3、编辑内容 4、生成帮助中心(自适应手机pc等多端) 5、客服自动回复 sql语句 ``` /* Navicat MySQL Data Transfer Source Server : 47.94.156.208 Source Server Version : 50648 Source Host : 47.94.156.208:3306 Source Database : help_doc Target Server Type : MYSQL Target Server Version : 50648 File Encoding : 65001 Date: 2021-10-06 15:51:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fa_help_category -- ---------------------------- DROP TABLE IF EXISTS `fa_help_category`; CREATE TABLE `fa_help_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '栏目类型', `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nickname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `flag` set('hot','index','recommend') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片', `keywords` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关键字', `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述', `diyname` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '自定义名称', `createtime` int(10) DEFAULT NULL COMMENT '创建时间', `updatetime` int(10) DEFAULT NULL COMMENT '更新时间', `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重', `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '状态', `admin_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `weigh` (`weigh`,`id`) USING BTREE, KEY `pid` (`pid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='帮助文档分类表'; -- ---------------------------- -- Table structure for fa_help_doc -- ---------------------------- DROP TABLE IF EXISTS `fa_help_doc`; CREATE TABLE `fa_help_doc` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `help_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题', `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片', `keywords` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关键字', `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述', `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容', `createtime` int(10) DEFAULT NULL COMMENT '创建时间', `updatetime` int(10) DEFAULT NULL COMMENT '更新时间', `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重', `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '状态', `admin_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `weigh` (`weigh`,`id`) USING BTREE, KEY `pid` (`help_category_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='帮助文档'; ```