cms.sql

/*
 Navicat Premium Data Transfer

 Source Server         : jd-test
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : 47.105.89.238:2290
 Source Schema         : jiedao_cms

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 17/05/2022 17:31:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cms_archives
-- ----------------------------
DROP TABLE IF EXISTS `cms_archives`;
CREATE TABLE `cms_archives`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
  `properties` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'n' COMMENT '自定义属性',
  `image_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩略图',
  `tag` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签',
  `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容摘要',
  `category_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上级栏目',
  `comment` int NULL DEFAULT 1 COMMENT '允许评论',
  `subscribe` int NULL DEFAULT 1 COMMENT '允许订阅',
  `clicks` int NULL DEFAULT 0 COMMENT '浏览量',
  `weight` int NULL DEFAULT 0 COMMENT '权重',
  `status` int NULL DEFAULT 1 COMMENT '状态1:已发布0未发布',
  `category_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目层级',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '档案' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_archives
-- ----------------------------
INSERT INTO `cms_archives` VALUES ('13037ae7e98048708cf9978368eeb820', '产品一', 'n', '', NULL, '', '6498f8307af5475683d4deb7b7b81d31', 1, 1, 0, 0, 1, '.uw6lcqqd', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:08:23', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:31:08');
INSERT INTO `cms_archives` VALUES ('182306d8eab44225a5ce123ad6a01ffd', '温馨家居搭配设计css3网站模板', 'p', '20190815\\2dbcc0552eae41578b03f34235c71db0.jpg', NULL, '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:35:39', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('18f228df7b8443dfa1039fe3c3e53503', 'Dreamer CMS是企业在创立初期很好的技术基础框架', 'p', '20190816\\ecb040a2c77348958e6fd39b1afebe18.jpg', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:21:14', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('31ca333eb9b04c8f8cc6f0f1c1447615', '微软', 'p', '20190816\\b39c908830744191b47830ac5e7d1b72.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:02:00', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('495c981ae1be45fb8d989d76b2d18672', '你好，我们公司想要订购产品？', 'n', '', '', '', '46041acafe0444ac95870f165977b6a0', 0, 0, 5, 0, 1, '.wqz18j7q', NULL, '2020-07-22 07:44:14', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:48:13');
INSERT INTO `cms_archives` VALUES ('4f451c4797c54536869f5cf748944f9e', 'Dreamer CMS 梦想家内容发布系统v1.0.0', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 11, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:20:53', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-08 18:00:21');
INSERT INTO `cms_archives` VALUES ('4f884e12b4be456a89156a51316c3f04', 'iop', 'p', '20190816\\ed8897c2c2ac4e61be5081584cf236ad.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:07:06', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('6a9d2d84c2cf4dae97e06b3af5c05e78', '硬件产品二', 'n', '', NULL, '', '5562f6d3f2e24f9c8be3abe69023cc27', 1, 1, 0, 0, 1, '.uw6lcqqd.l8pzde13', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:10:34', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:30:28');
INSERT INTO `cms_archives` VALUES ('755912b5365540479499a9272157ac3b', '软件产品一', 'n', '', NULL, '', '15445e172d734d0c87f52530549f91de', 1, 1, 0, 0, 1, '.uw6lcqqd.1gi964u0', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:38:50', NULL, '2020-07-07 17:38:53');
INSERT INTO `cms_archives` VALUES ('779bc296ea4a4149bd3c97cdb8cd8593', '个人开发者也可以使用Dreamer CMS承接外包项目', 'p', '20190816\\3f3f65a75df74027b3755d155b0f29b2.png', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:47:51', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('93b0ac1621024e4682442acd646da397', 'kid儿童用品商城shop网站模板', 'p', '20190815\\bbcb488fd42b42b4bd5af53f8c6ebcfe.jpg', NULL, '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:37:07', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('9736f68a332a48419178c5d3fdeb42bd', '我们是做产品直销的？有没有合作的意向？', 'n', '', '', '', '46041acafe0444ac95870f165977b6a0', 0, 0, 0, 0, 1, '.wqz18j7q', NULL, '2020-07-22 07:45:30', NULL, '2020-07-22 15:45:30');
INSERT INTO `cms_archives` VALUES ('ae451258a33642d2b6e57729c83f3eb7', 'Yale', 'p', '20190816\\a04e19bd311c45bebfc7a3dd2695a88c.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:11:22', NULL, '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('cc1b4cc70af54410a9486e7d4babd5a7', '大气css3动画BUSINESS商务展会企业模板', 'p', '20190815\\6fa657689394413d9b724cfa522301e6.jpg', '商务', '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 2, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:38:19', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('d64d167032c84521ad21708cccc1f963', '大气orion渐变绿色css3响应式商业模板', 'p', '20190815\\18c8a53e1b63493b821c9ab865c4b395.jpg', 'css3,html5,bootstrap', '大气orion渐变绿色css3响应式商业模板', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:28:10', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('e738f12d050849fd9998ac01fd0f5ad7', '初学JAVA的同学可以下载源代码来进行学习交流', 'p', '20190816\\da8377d716dc473a8f35d7a1b1a078c4.jpg', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:49:55', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10');
INSERT INTO `cms_archives` VALUES ('edda8fda8cc24a00b82e3f2ccfeb521d', 'Dreamer CMS 梦想家内容发布系统v2.5.1', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 0, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-19 08:36:16', NULL, '2020-06-19 16:36:16');
INSERT INTO `cms_archives` VALUES ('fb7c4cf30dd1456e8b21af621479a2e4', 'Dreamer CMS 梦想家内容发布系统v2.0.0', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 15, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:30:57', NULL, '2021-01-16 12:36:04');

-- ----------------------------
-- Table structure for cms_article
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `html_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_article
-- ----------------------------
INSERT INTO `cms_article` VALUES ('1db4bded81e5487fb977dc08c8c0994d', '4f884e12b4be456a89156a51316c3f04', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:07:06', NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `cms_article` VALUES ('36906ce147a34df8af6d076e3ded98f5', '13037ae7e98048708cf9978368eeb820', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:08:25', NULL, NULL, NULL, NULL, NULL, NULL, '<p>ddd</p>');
INSERT INTO `cms_article` VALUES ('3847200101314c1e98ea78658ac54409', 'ae451258a33642d2b6e57729c83f3eb7', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:11:22', NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `cms_article` VALUES ('431dc64e8d064aba95418674e5b11d7f', '755912b5365540479499a9272157ac3b', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:38:53', NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `cms_article` VALUES ('869c49d8819045d78c1353026c2e6e42', '6a9d2d84c2cf4dae97e06b3af5c05e78', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:10:35', NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `cms_article` VALUES ('8a457c20a8bc4159a728a75f329678da', '31ca333eb9b04c8f8cc6f0f1c1447615', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:02:00', NULL, NULL, NULL, NULL, NULL, NULL, '');

-- ----------------------------
-- Table structure for cms_attachment
-- ----------------------------
DROP TABLE IF EXISTS `cms_attachment`;
CREATE TABLE `cms_attachment`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标识码',
  `filename` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名',
  `filesize` int NULL DEFAULT NULL COMMENT '文件大小',
  `filetype` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `filepath` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_attachment
-- ----------------------------
INSERT INTO `cms_attachment` VALUES ('abd987209da941349001c85ffece6eb1', 'ez159g51', 'java1.8新特性.pptx', 113690, 'application/vnd.openxmlformats-officedocument.presentationml.presentation', '20191225\\acb604753b4c4d9ea281ae977d712f31.pptx', '9f4b807db2e94670bb02cdc212ea7389', '2019-12-25 05:47:34', '9f4b807db2e94670bb02cdc212ea7389', '2019-12-25 05:47:34');

-- ----------------------------
-- Table structure for cms_category
-- ----------------------------
DROP TABLE IF EXISTS `cms_category`;
CREATE TABLE `cms_category`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cnname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '栏目名称',
  `enname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目英文名称',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  `cat_seq` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '层级关系',
  `form_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表单ID',
  `image_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目图片',
  `description` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目描述',
  `link_target` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接目标',
  `page_size` int NULL DEFAULT 20 COMMENT '分页数量',
  `cat_model` int NULL DEFAULT 20 COMMENT '栏目模型（1封面，2列表，3外部链接）',
  `visit_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径',
  `cover_temp` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面模版',
  `list_temp` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列表模版',
  `article_temp` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容页模版',
  `link_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接路径',
  `default_editor` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '默认编辑器',
  `md_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'md内容',
  `html_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'html内容',
  `parent_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上级栏目',
  `is_show` int NULL DEFAULT 1 COMMENT '是否显示1显示0隐藏',
  `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目级别',
  `sort` int NULL DEFAULT 50 COMMENT '排序',
  `is_input` int NULL DEFAULT 0 COMMENT '是否允许投稿',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '栏目' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_category
-- ----------------------------
INSERT INTO `cms_category` VALUES ('0ca9667691d045a098e138fddb644ee0', '分页栏目标签', 'Page Category Label', '2y1e2puq', '.822n58d3.u8xo56nx.2y1e2puq', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 分页栏目标签dreamer-cms:category\r\n### 1.标签说明\r\n这个标签是用于在分页（封面页面和列表页面和文章页面）调用当前栏目信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nfield|typenamecn|字段名\r\n\r\n### 2.返回字段说明\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码（8位唯一）\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小（该属性控制列表页面默认的分页大小）\r\nvisiturl|String|访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）\r\nlinkurl|String|链接URL\r\neditor|String|编辑器（md或ue）\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序（默认为50）\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目（该属性在dreamer-cms:type标签下不可用）\r\n\r\n### 3.示例代码\r\n```html\r\n<section class=\"page-header d-flex align-items-center\">\r\n<div class=\"container-fluid\">\r\n	<div class=\"page-header-content text-center\">\r\n		<div class=\"page-header-tag\">{dreamer-cms:global name=\"title\" /}</div>\r\n		<div class=\"page-header-title\">{dreamer-cms:category field=\"typenamecn\" /}</div>\r\n	</div>\r\n</div>\r\n</section>\r\n```\r\n### 4.效果\r\n![category标签](http://img.075400.cn/20190820100255.png \"category标签\")', '<h1 id=\"h1--dreamer-cms-category\"><a name=\"分页栏目标签dreamer-cms:category\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>分页栏目标签dreamer-cms:category</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>这个标签是用于在分页（封面页面和列表页面和文章页面）调用当前栏目信息。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">field</td>\r\n<td style=\"text-align:center\">typenamecn</td>\r\n<td style=\"text-align:center\">字段名</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">字段类型</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenamecn</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目中文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenameen</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目英文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typecode</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目编码（8位唯一）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeseq</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目的层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeimg</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目图片</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">description</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linktarget</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接目标</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">pagesize</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">分页大小（该属性控制列表页面默认的分页大小）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">visiturl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linkurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">editor</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">编辑器（md或ue）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">mdcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">markdown内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">htmlcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">生成的html内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">parentname</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">上级栏目名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">isshow</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否显示</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">level</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">栏目层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sort</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">排序（默认为50）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">创建人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createtime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">创建时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updateby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">更新人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updatetime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">更新时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext01</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段1</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext02</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段2</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext03</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段3</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext04</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段4</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext05</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段5</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">haschildren</td>\r\n<td style=\"text-align:center\">Boolean</td>\r\n<td style=\"text-align:center\">是否有下级栏目（该属性在dreamer-cms:type标签下不可用）</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;section class=\"page-header d-flex align-items-center\"&gt;\r\n&lt;div class=\"container-fluid\"&gt;\r\n    &lt;div class=\"page-header-content text-center\"&gt;\r\n        &lt;div class=\"page-header-tag\"&gt;{dreamer-cms:global name=\"title\" /}&lt;/div&gt;\r\n        &lt;div class=\"page-header-title\"&gt;{dreamer-cms:category field=\"typenamecn\" /}&lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/section&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://img.075400.cn/20190820100255.png\" alt=\"category标签\" title=\"category标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 9, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:04:05', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('2512e4593b514db2a10841cbc8a63a23', '开发者', 'developer', 'mvpeun1s', '.4ol61bbh.mvpeun1s', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190820\\8ab5d68c3f9e4687816d1cbb083d9f71.jpg', '', '1', 20, 1, 'developer', '/developer.html', '', '', '', 'ue', '', '<p style=\"padding: 0px; margin-top: 0px; margin-bottom: 0px; font-family: &quot;Microsoft YaHei&quot;; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 3em;\"><span style=\"font-size: 18px;\"><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">王俊南(QQ:153095904)；</span><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">个人博客：</span></span><a href=\"http://blog.java1234.com/\" target=\"_blank\" style=\"color: rgb(0, 136, 204); text-decoration: underline; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255); font-size: 18px;\"><span style=\"font-size: 18px;\">http://www.itechyou.cn/</span></a><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"font-size: 18px;\"><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">DreamerCMS创始人；草根站长；</span><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">有10年的JAVA学习工作研究经验，先后参与过国家电网登高项目，企业OA项目；</span><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">多个政府服务平台项目，具有丰富的J2EE开发经验；</span><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">5年多的Java培训指导教育经验，原创教程通俗易懂，深受喜爱；</span><br style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">从事多年IT，拥有较广的人脉；&nbsp;</span></span></p><p style=\"padding: 0px; margin-top: 0px; margin-bottom: 0px; font-family: &quot;Microsoft YaHei&quot;; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 3em;\"><span style=\"font-size: 18px;\">个人名言：我喜欢程序员，他们单纯、固执、容易体会到成就感；面对压力，能够挑灯夜战不眠不休；面对困难，能够迎难而上挑战自我。他们也会感到困惑与傍徨，但每个程序员的心中都有一个比尔盖茨或是乔布斯的梦想“用智慧开创属于自己的事业”。我想说的是，其实我只是一个程序员！</span></p><p style=\"padding: 0px; margin-top: 0px; margin-bottom: 0px; font-family: &quot;Microsoft YaHei&quot;; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 3em;\"><span style=\"font-size: 18px;\"><br/></span></p><p style=\"padding: 0px; margin-top: 0px; margin-bottom: 0px; font-family: &quot;Microsoft YaHei&quot;; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 3em;\"><span style=\"font-size: 18px;\"><br/></span></p><p style=\"text-align: center; line-height: 2em;\"><img src=\"/uploads/20190816/1565949537281001415.jpg\" style=\"width: 228px; height: 228px;\" title=\"1565949537281001415.jpg\" width=\"228\" height=\"228\" border=\"0\" vspace=\"0\" alt=\"1565949537281001415.jpg\"/><span style=\"font-size: 14px;\">&nbsp;</span><img src=\"/uploads/20190816/1565949537316028864.jpg\" title=\"1565949537316028864.jpg\" width=\"228\" height=\"228\" border=\"0\" vspace=\"0\" alt=\"1565949537316028864.jpg\" style=\"width: 228px; height: 228px;\"/></p><p><br/></p>', '4e1c58e65fa9423482cf1a29a6ef629b', 1, '2', 2, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:33:33', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('25b7d2b36ea642d5ab9f39f90e10ae88', '全局标签', 'Global label', 'p78xb262', '.822n58d3.u8xo56nx.p78xb262', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 全局标签dreamer-cms:global\r\n### 1.标签说明\r\n该标签作用是获取后台系统配置中的配置项。该标签属于单标签，也可以写成{dreamer-cms:global name=\"xxx\"}{/dreamer-cms:global}。该标签只有一个属性 name，并适用于所有模版。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nname|website|获取网站地址\r\nname|title|获取网站标题\r\nname|keywords|获取网站关键字\r\nname|describe|获取网站描述\r\nname|icp|获取网站备案号\r\nname|copyright|获取网站版权\r\nname|uploaddir|获取网站上传目录\r\nname|appid|暂无作用\r\nname|appkey|暂无作用\r\n\r\n### 2.示例代码\r\n```html\r\n<!--=== footer ===-->\r\n<footer class=\"footer\">\r\n    <div class=\"container-fluid\">\r\n        <div class=\"row\">\r\n            <div class=\"col-lg-5 col-md-6 col-sm-5 align-self-center\">\r\n            	<div>\r\n            		<p>\r\n            			{dreamer-cms:global name=\"copyright\" /}\r\n            			备案号：{dreamer-cms:global name=\"icp\" /}\r\n            		</p>\r\n            	</div>\r\n\r\n            </div>\r\n            <div class=\"col-lg-7 col-md-6 col-sm-7 align-self-center\">\r\n                <ul class=\"list-inline footer-menu\">\r\n                	{dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n                    <li class=\"list-inline-item\"><a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n                    {/dreamer-cms:channel}\r\n                </ul>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</footer>\r\n```\r\n### 3.效果\r\n![global标签](http://www-x-itechyou-x-cn.img.abc188.com/uploads/allimg/190819/1-1ZQ9160P00-L.png \"global标签\")', '<h1 id=\"h1--dreamer-cms-global\"><a name=\"全局标签dreamer-cms:global\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>全局标签dreamer-cms:global</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签作用是获取后台系统配置中的配置项。该标签属于单标签，也可以写成{dreamer-cms:global name=”xxx”}{/dreamer-cms:global}。该标签只有一个属性 name，并适用于所有模版。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">website</td>\r\n<td style=\"text-align:center\">获取网站地址</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">title</td>\r\n<td style=\"text-align:center\">获取网站标题</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">keywords</td>\r\n<td style=\"text-align:center\">获取网站关键字</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">describe</td>\r\n<td style=\"text-align:center\">获取网站描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">icp</td>\r\n<td style=\"text-align:center\">获取网站备案号</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">copyright</td>\r\n<td style=\"text-align:center\">获取网站版权</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">uploaddir</td>\r\n<td style=\"text-align:center\">获取网站上传目录</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">appid</td>\r\n<td style=\"text-align:center\">暂无作用</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">appkey</td>\r\n<td style=\"text-align:center\">暂无作用</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.示例代码</h3><pre><code class=\"lang-html\">&lt;!--=== footer ===--&gt;\r\n&lt;footer class=\"footer\"&gt;\r\n    &lt;div class=\"container-fluid\"&gt;\r\n        &lt;div class=\"row\"&gt;\r\n            &lt;div class=\"col-lg-5 col-md-6 col-sm-5 align-self-center\"&gt;\r\n                &lt;div&gt;\r\n                    &lt;p&gt;\r\n                        {dreamer-cms:global name=\"copyright\" /}\r\n                        备案号：{dreamer-cms:global name=\"icp\" /}\r\n                    &lt;/p&gt;\r\n                &lt;/div&gt;\r\n\r\n            &lt;/div&gt;\r\n            &lt;div class=\"col-lg-7 col-md-6 col-sm-7 align-self-center\"&gt;\r\n                &lt;ul class=\"list-inline footer-menu\"&gt;\r\n                    {dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n                    &lt;li class=\"list-inline-item\"&gt;&lt;a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\"&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n                    {/dreamer-cms:channel}\r\n                &lt;/ul&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/footer&gt;\r\n</code></pre>\r\n<h3 id=\"h3-3-\"><a name=\"3.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.效果</h3><p><img src=\"http://www-x-itechyou-x-cn.img.abc188.com/uploads/allimg/190819/1-1ZQ9160P00-L.png\" alt=\"global标签\" title=\"global标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 1, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 16:15:10', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('25e7a8290c8a468b90b7453dab8c2b19', '文章列表标签', 'List Label', 'sp7hj754', '.822n58d3.u8xo56nx.sp7hj754', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 文章列表标签dreamer-cms:list\r\n### 1.标签说明\r\n该标签是常用标记，主要用于获取栏目下的文章并适用于所有模版，通常用于网站内容列表等信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目\r\nstart|0|从第几个开始获取\r\nlength|5|获取个数\r\nflag|p|文章属性p图片\r\naddfields|evaluator,content,source|附加字段，多个字段间用英文逗号分隔\r\nformkey|2EFPN7JY|表单模型的编码（可以在后台表单管理列表中获取）\r\nsortWay|asc|排序方式（asc或desc）\r\nsortBy||排序字段\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\nid|String|文章ID\r\ntitle|String|标题\r\nproperties|String|文章属性（头条h加粗b幻灯f图片b）\r\nlitpic|String|缩略图\r\ntag|String|文章标签\r\nremark|String|文章描述\r\ncategoryid|String|栏目ID\r\ncomment|Integer|是否允许评论\r\nsubscribe|Integer|是否允许订阅\r\nclicks|Integer|点击数\r\nweight|Integer|权重（可以利用该字段来排序）\r\nstatus|Integer|状态\r\ncreateby|String|发布人\r\ncreatetime|Date|发布时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\narcurl|String|文章访问URL\r\n\r\n### 3.示例代码\r\n```html\r\n<div class=\"row\">\r\n	<div class=\"col-lg-12 text-center\">\r\n		<div class=\"section-tag\">{dreamer-cms:global name=\"title\" /}</div>\r\n		<div class=\"section-title mb-5\"><h2>模版中心</h2></div>\r\n	</div>\r\n	{dreamer-cms:list typeid=\"A54547W2\" start=\"0\" length=\"8\" flag=\"p\"}\r\n	<div class=\"col-lg-3 col-md-4 col-sm-6\">\r\n		<div class=\"feature-wrap\">\r\n			<div class=\"feature-image\"><img src=\"[field:litpic /]\" class=\"ion ion-ios-cloud-outline\"></i></div>\r\n			<a href=\"[field:arcurl/]\">[field:title /]</a>\r\n			<p></p>\r\n		</div>\r\n	</div>\r\n	{/dreamer-cms:list}\r\n</div>\r\n```\r\n### 4.效果\r\n![list标签](http://img.075400.cn/20190820094908.png \"list标签\")', '<h1 id=\"h1--dreamer-cms-list\"><a name=\"文章列表标签dreamer-cms:list\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>文章列表标签dreamer-cms:list</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签是常用标记，主要用于获取栏目下的文章并适用于所有模版，通常用于网站内容列表等信息。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">4ol61bbh</td>\r\n<td style=\"text-align:center\">后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">start</td>\r\n<td style=\"text-align:center\">0</td>\r\n<td style=\"text-align:center\">从第几个开始获取</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">length</td>\r\n<td style=\"text-align:center\">5</td>\r\n<td style=\"text-align:center\">获取个数</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">flag</td>\r\n<td style=\"text-align:center\">p</td>\r\n<td style=\"text-align:center\">文章属性p图片</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">addfields</td>\r\n<td style=\"text-align:center\">evaluator,content,source</td>\r\n<td style=\"text-align:center\">附加字段，多个字段间用英文逗号分隔</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">formkey</td>\r\n<td style=\"text-align:center\">2EFPN7JY</td>\r\n<td style=\"text-align:center\">表单模型的编码（可以在后台表单管理列表中获取）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sortWay</td>\r\n<td style=\"text-align:center\">asc</td>\r\n<td style=\"text-align:center\">排序方式（asc或desc）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sortBy</td>\r\n<td style=\"text-align:center\"></td>\r\n<td style=\"text-align:center\">排序字段</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">字段类型</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">id</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">title</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">标题</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">properties</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章属性（头条h加粗b幻灯f图片b）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">litpic</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">缩略图</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">tag</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章标签</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">remark</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">categoryid</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">comment</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否允许评论</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">subscribe</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否允许订阅</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">clicks</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">点击数</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">weight</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">权重（可以利用该字段来排序）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">status</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">状态</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">发布人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createtime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">发布时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updateby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">更新人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updatetime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">更新时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">arcurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章访问URL</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;div class=\"row\"&gt;\r\n    &lt;div class=\"col-lg-12 text-center\"&gt;\r\n        &lt;div class=\"section-tag\"&gt;{dreamer-cms:global name=\"title\" /}&lt;/div&gt;\r\n        &lt;div class=\"section-title mb-5\"&gt;&lt;h2&gt;模版中心&lt;/h2&gt;&lt;/div&gt;\r\n    &lt;/div&gt;\r\n    {dreamer-cms:list typeid=\"A54547W2\" start=\"0\" length=\"8\" flag=\"p\"}\r\n    &lt;div class=\"col-lg-3 col-md-4 col-sm-6\"&gt;\r\n        &lt;div class=\"feature-wrap\"&gt;\r\n            &lt;div class=\"feature-image\"&gt;&lt;img src=\"[field:litpic /]\" class=\"ion ion-ios-cloud-outline\"&gt;&lt;/i&gt;&lt;/div&gt;\r\n            &lt;a href=\"[field:arcurl/]\"&gt;[field:title /]&lt;/a&gt;\r\n            &lt;p&gt;&lt;/p&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n    {/dreamer-cms:list}\r\n&lt;/div&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://img.075400.cn/20190820094908.png\" alt=\"list标签\" title=\"list标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 7, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 09:51:26', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('44e864cda6a049349e1516ce40eaa58e', '框架说明', 'Framework', '6rztc072', '.4ol61bbh.6rztc072', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190820\\aad2aaef17ca4cb49b3ffac27c29bb02.png', '', '1', 10, 1, 'framework', '/framework.html', '', '', '', 'ue', '# 梦想家CMS内容管理系统开源版J2EE代码\r\n\r\n当前版本：1.0.1\r\n\r\n梦想家CMS官网：[http://www.itechyou.cn](www.itechyou.cn)\r\n\r\nQQ群交流：\r\n- ①597652651\r\n\r\nDreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统，采用最流行的springboot+thymeleaf框架搭建，灵活小巧，配置简单。\r\n\r\n# 特点\r\n* 免费完整开源：基于MIT协议，源代码完全开源；\r\n* 标签化建站：不需要专业的后台开发技能，只要使用系统提供的标签，就能轻松建设网站；\r\n* 模版开发方便：支持在线上传模版包开发方便快捷；\r\n* 每月更新：每月进行系统升级，分享更多好用的模版与插件；\r\n\r\n# 面向对象\r\n* Dreamer CMS是企业在创立初期很好的技术基础框架，加快公司项目开发进度，当然也可以对现有的系统进行升级；\r\n* 个人开发者也可以使用Dreamer CMS承接外包项目；\r\n* 初学JAVA的同学可以下载源代码来进行学习交流；\r\n\r\n# 技术框架\r\n* 核心框架：Spring Boot 2\r\n* 安全框架：Apache Shiro 1.5\r\n* 视图框架：Spring MVC 4\r\n* 持久层框架：MyBatis 3\r\n* 日志管理：Log4j2\r\n* 模版框架：Thymeleaf\r\n* JS框架：jQuery，Bootstrap\r\n* CSS框架：Bootstrap\r\n* 富文本：Ueditor、editor.md\r\n\r\n# 系统结构\r\n![系统结构](http://itechyou.cn/uploads/allimg/180930/1-1P9301149510-L.jpg \"系统结构\")\r\n\r\n# 开发环境\r\n建议开发者使用以下环境，这样避免版本带来的问题\r\n* IDE：Spring Tool Suite（STS）\r\n* DB：Mysql 5.7\r\n* JDK：jdk8\r\n\r\n# 快速入门\r\n* 克隆项目到本地\r\n* 导入Eclipse或Sts等开发工具\r\n* 项目需要Redis，请自行修改application.yml中Redis配置\r\n* 将项目主页附件标签页里的dreamer-blog.zip附件下载并解压到D盘根目录\r\n* 运行项目DreamerBlogApplication.java\r\n* 项目首页：http://localhost:8888；项目管理后台：http://localhost:8888/admin\r\n* 管理后台用户名：wangjn；密码：123456\r\n\r\n# 系统美图\r\n![后台登录](http://itechyou.cn/uploads/allimg/180930/1-1P9301135560-L.png)\r\n\r\n![系统管理](http://itechyou.cn/uploads/allimg/180930/1-1P9301136210-L.png)\r\n\r\n![发布文章](http://itechyou.cn/uploads/allimg/180930/1-1P9301136400-L.png)\r\n\r\n![前台首页](http://itechyou.cn/uploads/allimg/180930/1-1P930113A10-L.png)', '<section class=\"output_wrapper\" id=\"output_wrapper_id\" style=\"color: rgb(62, 62, 62); line-height: 1.6; letter-spacing: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif;\"><h1 id=\"hcmsj2ee\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">梦想家CMS内容管理系统开源版J2EE代码</span></h1><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">当前版本：2.0.1</p><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">梦想家CMS官网：http://www.itechyou.cn<br/>模版标签开发教程请参考：http://doc.itechyou.cn</p><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">QQ群交流：</p><ul style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">①597652651</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">②623605199</span></p></li></ul><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">DreamerCMS（梦想家CMS内容管理系统）公开解决了快速搭建展示型网站（如：企业官网、技术博客、信息门户等）的框架体系，是电子政务、电信综合门户、企业信息门户、知识管理平台、电子商务平台的基础性软件系统。可以帮助政府、企业或组织灵活、准确、高效、智能地管理信息内容，实现信息的采集、加工、审核、发布、存储、检索、统计、分析、 反馈等整个信息生命周期的管理。采用时下最流行的Springboot+thymeleaf框架搭建，具有灵活小巧，配置简单，标签化模版，快速开发等特点。主要解决公司搭建网站成本高、投入大、周期长等问题，也可作为初创公司很好的基础技术框架。使用过程中不需要专业的后端技术开发技能，只要使用系统提供的模版标签，即可轻轻松松建设网站。</p><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">DreamerCMS从2.0.0版本开始采用了解析式引擎与编译式引擎并存的模式，由于在解析模版时，解析式引擎拥有巨大的优势，但对于动态浏览的互动性质的页面，编译式引擎更实用高效，DreamerCMS采用双引擎并存的模式，在保持标签风格一致性的同时，也保证将来开发更多互动模块时有更好的性能和更好的扩展。</p><h1 id=\"h\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">特点</span></h1><ul style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">免费完整开源：基于APACHE 2.0开源协议，源代码完全开源；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">标签化建站：不需要专业的后台开发技能，只要使用系统提供的标签，就能轻松建设网站；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">模版开发方便：支持在线上传模版包开发方便快捷；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">每月更新：每月进行系统升级，分享更多好用的模版与插件；</span></p></li></ul><h1 id=\"h-1\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">面向对象</span></h1><ul style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">政府：可以使用Dreamer CMS来快速构建政府门户；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">电信：可以使用Dreamer CMS来快速构建电信综合门户；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">企业：可以使用Dreamer CMS构建信息门户，知识管理平台，也可作为基础技术框架，是企业在创立初期很好的技术选型；</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">个人开发者：可以使用Dreamer CMS承接外包项目；</span></p></li></ul><h1 id=\"h-2\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">技术框架</span></h1><ul style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">核心框架：Spring Boot 2</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">安全框架：Apache Shiro 1.5</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">视图框架：Spring MVC 4</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">持久层框架：MyBatis 3</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">日志管理：Log4j2</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">模版框架：Thymeleaf</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">JS框架：jQuery，Bootstrap</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">CSS框架：Bootstrap</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">富文本：Ueditor、editor.md</span></p></li></ul><h1 id=\"h-3\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">系统结构</span></h1><figure style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\"><img src=\"/uploads/20200402/1585800147544079620.jpg\" alt=\"系统结构\" title=\"系统结构\" style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; display: block; margin: 0px auto; max-width: 100%;\"/><figcaption style=\"line-height: inherit; margin: 0px; padding: 0px; margin-top: 10px; text-align: center; color: rgb(153, 153, 153); font-size: 0.7em;\">系统结构</figcaption></figure><h1 id=\"h-4\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">开发环境</span></h1><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">建议开发者使用以下环境，这样避免版本带来的问题</p><ul style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">IDE：Spring Tool Suite 4（STS）</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">DB：Mysql 5.7</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">JDK：jdk8</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">Redis：3.2+</span></p></li></ul><h1 id=\"h-5\" style=\"color: inherit; line-height: inherit; padding: 0px; margin: 1.5em 0px; font-size: 1.6em;\"><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">快速入门</span></h1><p style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px; margin-top: 1.5em; margin-bottom: 1.5em;\">CMS包括两个部分（代码部分、资源部分）代码不多说。资源就是图片、模版等，该目录在application.yml中web.resource-path配置项目中配置。</p><ol style=\"font-size: inherit; color: inherit; line-height: inherit; padding: 0px 0px 0px 32px;\" class=\" list-paddingleft-2\"><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">克隆项目到本地工作空间</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">导入Eclipse或Sts等开发工具（推荐使用Spring Tools Suite 4）（项目中缺少的google/kaptcha.jar在附件中，大家自行下载）</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">项目需要Redis，请自行修改application.yml中Redis配置</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">修改项目资源目录，application.yml文件web.resource-path配置项（如D:/dreamer-cms/）</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">将项目src/main/resources/db/dreamer-cms.zip文件解压，保证解压后的目录路径的名称和资源目录一致</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">运行项目DreamerBlogApplication.java</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">网站首页：http://localhost:8888 项目管理后台：http://localhost:8888/admin</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">管理后台用户名：wangjn；密码：123456</span></p></li><li><p><span style=\"font-size: inherit; color: inherit; line-height: inherit; margin: 0px; padding: 0px;\">模版标签开发教程请参考：http://doc.itechyou.cn&nbsp;</span></p></li></ol></section><p><br/></p>', '4e1c58e65fa9423482cf1a29a6ef629b', 1, '2', 1, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:44:38', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('46041acafe0444ac95870f165977b6a0', '客户留言', '', 'wqz18j7q', '.wqz18j7q', '33a091d40c5e484b880daa744ef4e8aa', '', '', '1', 10, 2, 'message', '', '/list_message.html', '/article_message.html', '', 'md', '', '', '-1', 1, '1', 50, 1, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:18:43', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:23:06', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('47505ff560a3413488ad71f097a04172', '后台使用', 'Background use', '1f5uz4zy', '.822n58d3.1f5uz4zy', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'ue', '建设中...', '<p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">一、开发环境搭建及项目导入</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1G7411m72U/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">二、资源目录和代码之间的关系</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1G7411m7qz/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">三、熟悉管理后台及系统设置功能介绍</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1at4y1m785/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">四、变量管理和附件管理</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1Xc41187Ja/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">五、表单管理功能介绍及演示</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV15g4y1a73s/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">六、标签管理功能介绍</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1hQ4y1M7WR/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">七、栏目管理功能介绍</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1Fa4y1t7H3/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">八、文章管理功能介绍及演示</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1Pg4y1a7pu/</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">九、风格设置功能介绍及演示</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">https://www.bilibili.com/video/BV1fA41187w6/</span></p><p><br/></p>', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 52, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:49:05', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('4b1968cc854745418c4c0d305fbe7e15', '客户评价', 'evaluate', '1hq8501w', '.1hq8501w', '06c540abf3a64d9699762711439c82dd', '', '', '1', 20, 2, '', '', '/list_evaluate.html', '/list_evaluate.html', '', 'md', '', '', '-1', 0, '1', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:06:45', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:56:24', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('4e1c58e65fa9423482cf1a29a6ef629b', '框架简介', 'framework', '4ol61bbh', '.4ol61bbh', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190816\\a04bfda9e80549c28dbd2e6ccc2c7134.png', 'Dreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统，采用最流行的springboot+thymeleaf框架搭建，灵活小巧，配置简单。', '1', 20, 1, 'framework', '/framework.html', '', '', '', 'md', '', '', '-1', 1, '1', 1, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:51:16', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('592ef65f97264ecda6caeb284d9f6355', '更新记录', 'versions', 'he9g4d0j', '.he9g4d0j', '440dc002ad4846018d7a1b9433021b22', '', '', '1', 10, 2, 'versionnotes', '', '/list_version.html', '/article_version.html', '', 'md', '', '', '-1', 1, '1', 2, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:58:41', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('6d1b5b4467cf456693181b697e553d69', '常见问题', 'Common problem', '6o3y4wsk', '.822n58d3.6o3y4wsk', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '', '', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 54, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:49:51', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('7518e8daebfe4a2b9589b88a00f73ea4', '文章分页标签', 'Page Article Label', '4gs4256i', '.822n58d3.u8xo56nx.4gs4256i', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 文章分页标签dreamer-cms:pagelist\r\n### 1.标签说明\r\n这个标签是用于在列表页面调用文章列表并显示分页信息。一般该标签配合{dreamer-cms:pagination /}共同使用。见下方例子。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nformkey|4ol61bbh|表单模型的编码\r\naddfields|versionnum,notes|附加字段（该字段须设置了formkey后生效）\r\nsortWay|asc或desc|排序方式\r\nsortBy||排序字段\r\n\r\n### 2.返回字段说明\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\nid|String|文章ID\r\ntitle|String|标题\r\nproperties|String|文章属性（头条h加粗b幻灯f图片b）\r\nlitpic|String|缩略图\r\ntag|String|文章标签\r\nremark|String|文章描述\r\ncategoryid|String|栏目ID\r\ncomment|Integer|是否允许评论\r\nsubscribe|Integer|是否允许订阅\r\nclicks|Integer|点击数\r\nweight|Integer|权重（可以利用该字段来排序）\r\nstatus|Integer|状态\r\ncreateby|String|发布人\r\ncreatetime|Date|发布时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\narcurl|String|文章访问URL\r\n\r\n### 3.示例代码\r\n```html\r\n<div class=\"row\">\r\n	{dreamer-cms:pagelist pagesize=\"10\" formkey=\"LUVC0AW2\" addfields=\"versionnum,notes\"}\r\n	<div class=\"col-lg-4 col-md-6 col-sm-6\">\r\n		<div class=\"blog-post\">\r\n			<div class=\"blog-details\">\r\n				<ul class=\"list-inline blog-item-links\">\r\n					<li class=\"list-inline-item\"><a href=\"#\"><i class=\"ion ion-calendar\"></i>版本号：[field:versionnum/]</a></li>\r\n					<li class=\"list-inline-item\"><a href=\"#\"><i class=\"ion ion-chatbubbles\"></i>点击：[field:clicks/]</a></li>\r\n				</ul>\r\n				<a href=\"[field:arcurl/]\"><h4 class=\"media-heading\">[field:title/]</h4></a>\r\n				<p class=\"product-para\">版本号：[field:versionnum/]</p>\r\n				<p class=\"product-para\">发布日期：[field:createtime/]</p>\r\n				<a href=\"[field:arcurl/]\" class=\"blog-post-link\">查看详情 <i class=\"fa fa-angle-double-right\"></i></a>\r\n			</div>\r\n		</div>\r\n	</div>\r\n	{/dreamer-cms:pagelist}\r\n</div>\r\n<div class=\"row\">\r\n	<div class=\"col-lg-12 col-md-12 col-sm-12\">\r\n	{dreamer-cms:pagination /}\r\n	</div>\r\n</div>\r\n```\r\n### 4.效果\r\n![pagelist标签](http://img.075400.cn/20190820101533.png \"pagelist标签\")', '<h1 id=\"h1--dreamer-cms-pagelist\"><a name=\"文章分页标签dreamer-cms:pagelist\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>文章分页标签dreamer-cms:pagelist</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>这个标签是用于在列表页面调用文章列表并显示分页信息。一般该标签配合{dreamer-cms:pagination /}共同使用。见下方例子。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">formkey</td>\r\n<td style=\"text-align:center\">4ol61bbh</td>\r\n<td style=\"text-align:center\">表单模型的编码</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">addfields</td>\r\n<td style=\"text-align:center\">versionnum,notes</td>\r\n<td style=\"text-align:center\">附加字段（该字段须设置了formkey后生效）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sortWay</td>\r\n<td style=\"text-align:center\">asc或desc</td>\r\n<td style=\"text-align:center\">排序方式</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sortBy</td>\r\n<td style=\"text-align:center\"></td>\r\n<td style=\"text-align:center\">排序字段</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">字段类型</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">id</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">title</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">标题</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">properties</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章属性（头条h加粗b幻灯f图片b）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">litpic</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">缩略图</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">tag</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章标签</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">remark</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">categoryid</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">comment</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否允许评论</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">subscribe</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否允许订阅</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">clicks</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">点击数</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">weight</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">权重（可以利用该字段来排序）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">status</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">状态</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">发布人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createtime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">发布时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updateby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">更新人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updatetime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">更新时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">arcurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">文章访问URL</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;div class=\"row\"&gt;\r\n    {dreamer-cms:pagelist pagesize=\"10\" formkey=\"LUVC0AW2\" addfields=\"versionnum,notes\"}\r\n    &lt;div class=\"col-lg-4 col-md-6 col-sm-6\"&gt;\r\n        &lt;div class=\"blog-post\"&gt;\r\n            &lt;div class=\"blog-details\"&gt;\r\n                &lt;ul class=\"list-inline blog-item-links\"&gt;\r\n                    &lt;li class=\"list-inline-item\"&gt;&lt;a href=\"#\"&gt;&lt;i class=\"ion ion-calendar\"&gt;&lt;/i&gt;版本号：[field:versionnum/]&lt;/a&gt;&lt;/li&gt;\r\n                    &lt;li class=\"list-inline-item\"&gt;&lt;a href=\"#\"&gt;&lt;i class=\"ion ion-chatbubbles\"&gt;&lt;/i&gt;点击：[field:clicks/]&lt;/a&gt;&lt;/li&gt;\r\n                &lt;/ul&gt;\r\n                &lt;a href=\"[field:arcurl/]\"&gt;&lt;h4 class=\"media-heading\"&gt;[field:title/]&lt;/h4&gt;&lt;/a&gt;\r\n                &lt;p class=\"product-para\"&gt;版本号：[field:versionnum/]&lt;/p&gt;\r\n                &lt;p class=\"product-para\"&gt;发布日期：[field:createtime/]&lt;/p&gt;\r\n                &lt;a href=\"[field:arcurl/]\" class=\"blog-post-link\"&gt;查看详情 &lt;i class=\"fa fa-angle-double-right\"&gt;&lt;/i&gt;&lt;/a&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n    {/dreamer-cms:pagelist}\r\n&lt;/div&gt;\r\n&lt;div class=\"row\"&gt;\r\n    &lt;div class=\"col-lg-12 col-md-12 col-sm-12\"&gt;\r\n    {dreamer-cms:pagination /}\r\n    &lt;/div&gt;\r\n&lt;/div&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://img.075400.cn/20190820101533.png\" alt=\"pagelist标签\" title=\"pagelist标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 10, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:26:12', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('7b773cb86e574302a8878573de87b32a', '文档丰富', 'richdoc', '1ggrj6n9', '.4ol61bbh.tnleskz4.1ggrj6n9', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:49:37', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:32:21', 'fa fa-file-word-o', '', '', '', '');
INSERT INTO `cms_category` VALUES ('7ddb8cde57554702976f01593488d807', '模版化', 'templateing', 'e96c4wkr', '.4ol61bbh.tnleskz4.e96c4wkr', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:48:26', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:35:47', 'fa fa-object-group', '', '', '', '');
INSERT INTO `cms_category` VALUES ('8923a09d403f49a289f3af780dcca0c2', '标签', 'label', 'u8xo56nx', '.822n58d3.u8xo56nx', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'ue', '# 标签\r\n* 标签统一dreamer-cms:打头，花括号包裹，dreamer-cms标签只能用于html模版页面中；\r\n* 标签格式：{ms:标签 属性1=值1 属性2=值2 属性n=值n/}属性值需要用双引号包裹，相邻的两个属性之间也要用空格隔开；\r\n* 模版也是普通的html文件格式，文件后缀为.html；\r\n* 只支持两种默认首页，分别是引导页（default.html）与主页（index.html）；\r\n	* default.html一般是做网站的欢迎引导界面；\r\n	* index.html为网站的主页；\r\n* 模版需要与后台的栏目绑定，通过生成器生成才有效；\r\n* 栏目有两个非常重要的概念，列表与封面；\r\n* 列表：例如产品列表、文章列表，列表会绑定两个模版地址一是列表模版、二是内容模版；\r\n* 封面：例如关于我们、联系方式这些都属于单篇模版；\r\n* 文章是必须发布在最终子栏目；\r\n* 自定义模型，如果文章现有的字段无法满足可以通过自定义模型来满足，通过[field:*/]获取自定义属性。', '<section class=\"output_wrapper\" id=\"output_wrapper_id\" style=\"color: rgb(62, 62, 62); line-height: 1.6; letter-spacing: 0px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif;\">\r\n    <p style=\"font-size: inherit; color: inherit; padding: 0px; margin-bottom: 1.5em; line-height: 2em;\">\r\n        <span style=\"font-size: 16px;\">1、标签统一dreamer-cms:打头，花括号包裹，dreamer-cms标签只能用于html模版页面中；<br/>2、标签格式：{ms:标签 属性1=值1 属性2=值2 属性n=值n/}属性值需要用双引号包裹，相邻的两个属性之间也要用空格隔开；<br/>3、模版也是普通的html文件格式，文件后缀为.html；<br/>4、只支持两种默认首页，分别是引导页（default.html）与主页（index.html）；<br/>&nbsp;&nbsp;&nbsp;&nbsp;a、default.html一般是做网站的欢迎引导界面；<br/>&nbsp;&nbsp;&nbsp;&nbsp;b、index.html为网站的主页；<br/>5、模版需要与后台的栏目绑定，通过生成器生成才有效；<br/>6、栏目有两个非常重要的概念，列表与封面；<br/>7、列表：例如产品列表、文章列表，列表会绑定两个模版地址一是列表模版、二是内容模版；<br/>8、封面：例如关于我们、联系方式这些都属于单篇模版；<br/>9、文章是必须发布在最终子栏目；<br/>10、自定义模型，如果文章现有的字段无法满足可以通过自定义模型来满足，通过[field:*/]获取自定义属性。</span>\r\n    </p>\r\n</section>\r\n<p>\r\n    <br/>\r\n</p>', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 51, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:45:45', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('a74b9beee883448b8f59cad4a8396695', '变量标签', 'Variable label', '40350iuz', '.822n58d3.u8xo56nx.40350iuz', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:variable\r\n### 1.标签说明\r\n该标签作用是获取后台变量管理中的配置项。该标签属于单标签，也可以写成{dreamer-cms:variable name=\"xxx\"}{/dreamer-cms:variable}。该标签只有一个属性 name，并适用于所有模版。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nname|cfg_github_addr|后台变量管理中的变量名\r\n\r\n### 2.示例代码\r\n```html\r\n<section id=\"action\" class=\"call-to-action-2\">\r\n    <div class=\"container-fluid\">\r\n        <div class=\"row\">\r\n            <div class=\"col-12\">\r\n                <div class=\"call-to-action-wrap\">\r\n                    <div class=\"call-to-action-title\">\r\n                        <div class=\"text-center\"><a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\" class=\"btn btn-primary main-btn\">源码下载</a></div>\r\n                        <h3>梦想家CMS内容管理系统支持码云、Github等多种渠道下载。</h3>\r\n                    </div>\r\n                    <div class=\"list-wrap\">\r\n                        <ul class=\"list-inline applications\">\r\n                            <li class=\"list-inline-item\"><a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\"><img src=\"{dreamer-cms:template /}images/app1.png\" alt=\"Application\"></a></li>\r\n                            <li class=\"list-inline-item\"><a href=\"{dreamer-cms:variable name=\'cfg_github_addr\'/}\"><img src=\"{dreamer-cms:template /}images/app2.png\" alt=\"Application\"></a></li>\r\n                        </ul>\r\n                    </div>\r\n                </div>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</section>\r\n```\r\n### 3.效果\r\n![variable标签](http://www.itechyou.cn/uploads/allimg/190819/1-1ZQ91JT40-L.png \"variable标签\")', '<h1 id=\"h1--dreamer-cms-variable\"><a name=\"变量标签dreamer-cms:variable\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>变量标签dreamer-cms:variable</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签作用是获取后台变量管理中的配置项。该标签属于单标签，也可以写成{dreamer-cms:variable name=”xxx”}{/dreamer-cms:variable}。该标签只有一个属性 name，并适用于所有模版。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">name</td>\r\n<td style=\"text-align:center\">cfg_github_addr</td>\r\n<td style=\"text-align:center\">后台变量管理中的变量名</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.示例代码</h3><pre><code class=\"lang-html\">&lt;section id=\"action\" class=\"call-to-action-2\"&gt;\r\n    &lt;div class=\"container-fluid\"&gt;\r\n        &lt;div class=\"row\"&gt;\r\n            &lt;div class=\"col-12\"&gt;\r\n                &lt;div class=\"call-to-action-wrap\"&gt;\r\n                    &lt;div class=\"call-to-action-title\"&gt;\r\n                        &lt;div class=\"text-center\"&gt;&lt;a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\" class=\"btn btn-primary main-btn\"&gt;源码下载&lt;/a&gt;&lt;/div&gt;\r\n                        &lt;h3&gt;梦想家CMS内容管理系统支持码云、Github等多种渠道下载。&lt;/h3&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"list-wrap\"&gt;\r\n                        &lt;ul class=\"list-inline applications\"&gt;\r\n                            &lt;li class=\"list-inline-item\"&gt;&lt;a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\"&gt;&lt;img src=\"{dreamer-cms:template /}images/app1.png\" alt=\"Application\"&gt;&lt;/a&gt;&lt;/li&gt;\r\n                            &lt;li class=\"list-inline-item\"&gt;&lt;a href=\"{dreamer-cms:variable name=\'cfg_github_addr\'/}\"&gt;&lt;img src=\"{dreamer-cms:template /}images/app2.png\" alt=\"Application\"&gt;&lt;/a&gt;&lt;/li&gt;\r\n                        &lt;/ul&gt;\r\n                    &lt;/div&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/section&gt;\r\n</code></pre>\r\n<h3 id=\"h3-3-\"><a name=\"3.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.效果</h3><p><img src=\"http://www.itechyou.cn/uploads/allimg/190819/1-1ZQ91JT40-L.png\" alt=\"variable标签\" title=\"variable标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 2, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:21:18', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b0bb4daa71694c0ebdb59a986d11684f', '合作伙伴', 'partner', '2jk6313y', '.2jk6313y', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 2, '', '', '/list_partner.html', '/list_partner.html', '', 'md', '', '', '-1', 0, '1', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:59:32', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:52:52', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b2cca489d9e14f4e8e291c59308d1ae0', '栏目标签', 'Type Label', '1765m053', '.822n58d3.u8xo56nx.1765m053', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:type\r\n### 1.标签说明\r\n该标签作用是获取指定栏目的内容。该标签只有一个属性typeid，并适用于所有模版。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码（8位唯一）\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小（该属性控制列表页面默认的分页大小）\r\nvisiturl|String|访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）\r\nlinkurl|String|链接URL\r\neditor|String|编辑器（md或ue）\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序（默认为50）\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目（该属性在dreamer-cms:type标签下不可用）\r\n\r\n### 3.示例代码\r\n```html\r\n<div class=\"row\">\r\n	<div class=\"col-12 mt-5\">\r\n		{dreamer-cms:type typeid=\"A54547W2\"}\r\n		<div class=\"text-center\"><a href=\"[field:typeurl/]\" class=\"btn btn-primary main-btn btn-reload\"><i class=\"fa fa-spinner fa-spin\"></i> 查看更多</a></div>\r\n		{/dreamer-cms:type}\r\n	</div>\r\n</div>\r\n```\r\n### 4.效果\r\n![type标签](http://www.itechyou.cn/uploads/allimg/190819/1-1ZQ91P6090-L.png \"type标签\")', '<h1 id=\"h1--dreamer-cms-type\"><a name=\"变量标签dreamer-cms:type\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>变量标签dreamer-cms:type</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签作用是获取指定栏目的内容。该标签只有一个属性typeid，并适用于所有模版。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">4ol61bbh</td>\r\n<td style=\"text-align:center\">后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">字段类型</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenamecn</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目中文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenameen</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目英文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typecode</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目编码（8位唯一）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeseq</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目的层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeimg</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目图片</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">description</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linktarget</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接目标</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">pagesize</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">分页大小（该属性控制列表页面默认的分页大小）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">visiturl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linkurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">editor</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">编辑器（md或ue）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">mdcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">markdown内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">htmlcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">生成的html内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">parentname</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">上级栏目名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">isshow</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否显示</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">level</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">栏目层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sort</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">排序（默认为50）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">创建人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createtime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">创建时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updateby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">更新人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updatetime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">更新时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext01</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段1</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext02</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段2</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext03</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段3</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext04</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段4</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext05</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段5</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">haschildren</td>\r\n<td style=\"text-align:center\">Boolean</td>\r\n<td style=\"text-align:center\">是否有下级栏目（该属性在dreamer-cms:type标签下不可用）</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;div class=\"row\"&gt;\r\n    &lt;div class=\"col-12 mt-5\"&gt;\r\n        {dreamer-cms:type typeid=\"A54547W2\"}\r\n        &lt;div class=\"text-center\"&gt;&lt;a href=\"[field:typeurl/]\" class=\"btn btn-primary main-btn btn-reload\"&gt;&lt;i class=\"fa fa-spinner fa-spin\"&gt;&lt;/i&gt; 查看更多&lt;/a&gt;&lt;/div&gt;\r\n        {/dreamer-cms:type}\r\n    &lt;/div&gt;\r\n&lt;/div&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://www.itechyou.cn/uploads/allimg/190819/1-1ZQ91P6090-L.png\" alt=\"type标签\" title=\"type标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 5, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 18:08:54', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b86a0c79aec447d78afb7d25111eae1a', '模版制作', 'Template making', '24is7n55', '.822n58d3.24is7n55', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '', '', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 53, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:48:31', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('bd2ff1d7e4174078ab573457507f7a08', '栏目内容列表', 'Category Article List', 'h56yw2e9', '.822n58d3.u8xo56nx.h56yw2e9', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 栏目内容列表标签dreamer-cms:categoryartlist\r\n### 1.标签说明\r\n这个标签是系统中唯一的一个支持嵌套的标签，这个标签通常使用在首页（含封面首页），用于输出一组栏目内容列表，主要用于获取下级栏目的内容列表标签并适用于所有模版，通常用于网站内容列表等信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目\r\nlength|5|获取个数\r\n\r\n### 2.返回字段说明\r\n参照channel和list标签返回字段说明\r\n\r\n### 3.示例代码\r\n```html\r\n<ul class=\"nav navbar-nav mr-auto\">\r\n	<li class=\"nav-item active\"><a class=\"nav-link scroll\" href=\"/\">首页</a></li>\r\n	{dreamer-cms:categoryartlist length=\"1\"}\r\n		{dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n		<li class=\"dropdown nav-item\"><a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\">[field:typenamecn /]</a>\r\n			<ul class=\"dropdown-menu\">\r\n				{dreamer-cms:channel}\r\n				<li><a class=\"dropdown-item\" href=\"[field:typeurl/]\"><i class=\"ion ion-chevron-right\"></i>[field:typenamecn /]</a></li>\r\n				{/dreamer-cms:channel}\r\n			</ul>\r\n		</li>\r\n		{/dreamer-cms:if}\r\n		{dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n		<li class=\"nav-item\"><a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n		{/dreamer-cms:if}\r\n	{/dreamer-cms:categoryartlist}\r\n</ul>\r\n```\r\n### 4.效果\r\n![categoryartlist标签](http://img.075400.cn/20190820095818.png \"categoryartlist标签\")', '<h1 id=\"h1--dreamer-cms-categoryartlist\"><a name=\"栏目内容列表标签dreamer-cms:categoryartlist\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>栏目内容列表标签dreamer-cms:categoryartlist</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>这个标签是系统中唯一的一个支持嵌套的标签，这个标签通常使用在首页（含封面首页），用于输出一组栏目内容列表，主要用于获取下级栏目的内容列表标签并适用于所有模版，通常用于网站内容列表等信息。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">4ol61bbh</td>\r\n<td style=\"text-align:center\">后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">length</td>\r\n<td style=\"text-align:center\">5</td>\r\n<td style=\"text-align:center\">获取个数</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><p>参照channel和list标签返回字段说明</p>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;ul class=\"nav navbar-nav mr-auto\"&gt;\r\n    &lt;li class=\"nav-item active\"&gt;&lt;a class=\"nav-link scroll\" href=\"/\"&gt;首页&lt;/a&gt;&lt;/li&gt;\r\n    {dreamer-cms:categoryartlist length=\"1\"}\r\n        {dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n        &lt;li class=\"dropdown nav-item\"&gt;&lt;a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\"&gt;[field:typenamecn /]&lt;/a&gt;\r\n            &lt;ul class=\"dropdown-menu\"&gt;\r\n                {dreamer-cms:channel}\r\n                &lt;li&gt;&lt;a class=\"dropdown-item\" href=\"[field:typeurl/]\"&gt;&lt;i class=\"ion ion-chevron-right\"&gt;&lt;/i&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n                {/dreamer-cms:channel}\r\n            &lt;/ul&gt;\r\n        &lt;/li&gt;\r\n        {/dreamer-cms:if}\r\n        {dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n        &lt;li class=\"nav-item\"&gt;&lt;a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\"&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n        {/dreamer-cms:if}\r\n    {/dreamer-cms:categoryartlist}\r\n&lt;/ul&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://img.075400.cn/20190820095818.png\" alt=\"categoryartlist标签\" title=\"categoryartlist标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 8, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:00:03', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('c057161b83274a708265da8808cb8f87', '概要', 'outline', 'xk315i87', '.822n58d3.xk315i87', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, '', '/document.html', '', '', '', 'ue', '# 梦想家CMS内容管理系统开源版J2EE代码\r\n\r\n当前版本：1.0.1\r\n\r\n梦想家CMS官网：[http://www.itechyou.cn](www.itechyou.cn)\r\n\r\nQQ群交流：\r\n- ①597652651\r\n\r\nDreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统，采用最流行的springboot+thymeleaf框架搭建，灵活小巧，配置简单。\r\n\r\n# 特点\r\n* 免费完整开源：基于MIT协议，源代码完全开源；\r\n* 标签化建站：不需要专业的后台开发技能，只要使用系统提供的标签，就能轻松建设网站；\r\n* 模版开发方便：支持在线上传模版包开发方便快捷；\r\n* 每月更新：每月进行系统升级，分享更多好用的模版与插件；\r\n\r\n# 面向对象\r\n* Dreamer CMS是企业在创立初期很好的技术基础框架，加快公司项目开发进度，当然也可以对现有的系统进行升级；\r\n* 个人开发者也可以使用Dreamer CMS承接外包项目；\r\n* 初学JAVA的同学可以下载源代码来进行学习交流；\r\n\r\n# 技术框架\r\n* 核心框架：Spring Boot 2\r\n* 安全框架：Apache Shiro 1.5\r\n* 视图框架：Spring MVC 4\r\n* 持久层框架：MyBatis 3\r\n* 日志管理：Log4j2\r\n* 模版框架：Thymeleaf\r\n* JS框架：jQuery，Bootstrap\r\n* CSS框架：Bootstrap\r\n* 富文本：Ueditor、editor.md\r\n\r\n# 系统结构\r\n![系统结构](http://itechyou.cn/uploads/allimg/180930/1-1P9301149510-L.jpg \"系统结构\")\r\n\r\n# 开发环境\r\n建议开发者使用以下环境，这样避免版本带来的问题\r\n* IDE：Spring Tool Suite（STS）\r\n* DB：Mysql 5.7\r\n* JDK：jdk8\r\n\r\n# 快速入门\r\n* 克隆项目到本地\r\n* 导入Eclipse或Sts等开发工具\r\n* 项目需要Redis，请自行修改application.yml中Redis配置\r\n* 将项目主页附件标签页里的dreamer-blog.zip附件下载并解压到D盘根目录\r\n* 运行项目DreamerBlogApplication.java\r\n* 项目首页：http://localhost:8888；项目管理后台：http://localhost:8888/admin\r\n* 管理后台用户名：wangjn；密码：123456\r\n\r\n# 系统美图\r\n![后台登录](http://itechyou.cn/uploads/allimg/180930/1-1P9301135560-L.png)\r\n\r\n![系统管理](http://itechyou.cn/uploads/allimg/180930/1-1P9301136210-L.png)\r\n\r\n![发布文章](http://itechyou.cn/uploads/allimg/180930/1-1P9301136400-L.png)\r\n\r\n![前台首页](http://itechyou.cn/uploads/allimg/180930/1-1P930113A10-L.png)', '<p style=\"box-sizing: border-box; margin-bottom: 1.5em; padding: 0px; color: rgb(62, 62, 62); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255); line-height: 2em;\"><span style=\"font-size: 16px;\">DreamerCMS（梦想家CMS内容管理系统）公开解决了快速搭建展示型网站（如：企业官网、技术博客、信息门户等）的框架体系，是电子政务、电信综合门户、企业信息门户、知识管理平台、电子商务平台的基础性软件系统。可以帮助政府、企业或组织灵活、准确、高效、智能地管理信息内容，实现信息的采集、加工、审核、发布、存储、检索、统计、分析、 反馈等整个信息生命周期的管理。采用时下最流行的Springboot+thymeleaf框架搭建，具有灵活小巧，配置简单，标签化模版，快速开发等特点。主要解决公司搭建网站成本高、投入大、周期长等问题，也可作为初创公司很好的基础技术框架。使用过程中不需要专业的后端技术开发技能，只要使用系统提供的模版标签，即可轻轻松松建设网站。</span></p><p style=\"box-sizing: border-box; margin-top: 1.5em; margin-bottom: 1.5em; padding: 0px; color: rgb(62, 62, 62); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255); line-height: 2em;\"><span style=\"font-size: 16px;\">DreamerCMS从2.0.0版本开始采用了解析式引擎与编译式引擎并存的模式，由于在解析模版时，解析式引擎拥有巨大的优势，但对于动态浏览的互动性质的页面，编译式引擎更实用高效，DreamerCMS采用双引擎并存的模式，在保持标签风格一致性的同时，也保证将来开发更多互动模块时有更好的性能和更好的扩展。</span></p><p><br/></p>', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:28:41', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('ce1c25b233c0422bb136c27aca4b38f4', '开发文档', 'document', '822n58d3', '.822n58d3', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190819\\bbe58a0cbf1a473d81d0479aad753e2a.png', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '', '', '-1', 1, '1', 3, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:53:38', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('cea6987366f54fe7b9f0d331aa5e226e', '标签化建站', 'tagging', 'cyp0c2ed', '.4ol61bbh.tnleskz4.cyp0c2ed', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:47:35', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:50:54', 'fa fa-code', '', '', '', '');
INSERT INTO `cms_category` VALUES ('d63c35e50d1f42f49904f263b5571a87', '使用说明', 'quickstart', '76crpo3s', '.76crpo3s', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190819\\7600b31a769b470d87a013254f85dccf.png', '', '1', 10, 1, 'quickstart', '/quickstart.html', '', '', '', 'ue', '####1.克隆项目到本地\r\n####2.导入Eclipse或Sts等开发工具\r\n####3.项目需要Redis，请自行修改application.yml中Redis配置\r\n####4.将项目主页附件标签页里的dreamer-blog.zip附件下载并解压到D盘根目录\r\n####5.运行项目DreamerBlogApplication.java\r\n####6.项目首页：http://localhost:8888\r\n####7.项目管理后台：http://localhost:8888/admin\r\n####8.管理后台用户名：wangjn；密码：123456', '<p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">CMS包括两个部分（代码部分、资源部分）代码不多说。资源就是图片、模版等，该目录在application.yml中web.resource-path配置项目中配置。视频教程：</span></p><p style=\"line-height: 2em;\"><br/></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">链接：https://pan.baidu.com/s/1plsfBl_ds_5TkVa-yRkESQ&nbsp;</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">提取码：2c8i</span></p><p style=\"line-height: 2em;\"><br/></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">1、克隆项目到本地工作空间</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">2、导入Eclipse或Sts等开发工具（推荐使用Spring Tools Suite 4）（项目中缺少的google/kaptcha.jar在附件中，大家自行下载）</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">3、项目需要Redis，请自行修改application.yml中Redis配置</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">4、修改项目资源目录，application.yml文件web.resource-path配置项（如D:/dreamer-cms/）</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">5、将项目src/main/resources/db/dreamer-cms.zip文件解压，保证解压后的目录路径的名称和资源目录一致</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">6、运行项目DreamerCMSApplication.java</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">7、网站首页：http://localhost:8888 项目管理后台：http://localhost:8888/admin</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">8、管理后台用户名：wangjn；密码：123456</span></p><p style=\"line-height: 2em;\"><span style=\"font-size: 16px;\">9、模版标签开发教程请参考：http://doc.itechyou.cn&nbsp;</span></p><p><br/></p>', '-1', 1, '1', 4, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:54:13', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('d90066ad28e04b2bb59ba446246b7191', '引入文件标签', 'Include Label', '8d119618', '.822n58d3.u8xo56nx.8d119618', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:include\r\n### 1.标签说明\r\n该标签作用是引入其它模板的内容，以方便拆分头部、尾部等公共部分。该标签属于单标签，也可以写成{dreamer-cms:include file=\"xxx.html\"}{/dreamer-cms:include}。该标签只有一个file属性，并适用于所有模版，建议使用单标签\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nfile|header.html|引入当前模版同目录下的名为header.html的头部模版\r\n\r\n### 2.示例代码\r\n```html\r\n{dreamer-cms:include file=\'header.html\'/}\r\n```\r\n### 3.效果\r\n![include标签](http://www.itechyou.cn./uploads/allimg/190819/1-1ZQ91KI60-L.png \"include标签\")', '<h1 id=\"h1--dreamer-cms-include\"><a name=\"变量标签dreamer-cms:include\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>变量标签dreamer-cms:include</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签作用是引入其它模板的内容，以方便拆分头部、尾部等公共部分。该标签属于单标签，也可以写成{dreamer-cms:include file=”xxx.html”}{/dreamer-cms:include}。该标签只有一个file属性，并适用于所有模版，建议使用单标签</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">file</td>\r\n<td style=\"text-align:center\">header.html</td>\r\n<td style=\"text-align:center\">引入当前模版同目录下的名为header.html的头部模版</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.示例代码</h3><pre><code class=\"lang-html\">{dreamer-cms:include file=\'header.html\'/}\r\n</code></pre>\r\n<h3 id=\"h3-3-\"><a name=\"3.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.效果</h3><p><img src=\"http://www.itechyou.cn./uploads/allimg/190819/1-1ZQ91KI60-L.png\" alt=\"include标签\" title=\"include标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 4, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:59:27', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('d9c8397d7474485e879b4e5d58992609', '模版路径标签', 'Template Path Label', 'a44xd784', '.822n58d3.u8xo56nx.a44xd784', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:template\r\n### 1.标签说明\r\n该标签作用是获取当前模板的路径，以方便加载静态资源。该标签属于单标签，也可以写成{dreamer-cms:template}{/dreamer-cms:template}。该标签没有属性，并适用于所有模版，建议使用单标签\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\n无|无|无\r\n\r\n### 2.示例代码\r\n```html\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}bootstrap/css/bootstrap.min.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/font-awesome.min.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick-theme.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/app.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/responsive.css\">\r\n<script src=\"{dreamer-cms:template /}js/jquery-3.2.1.slim.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}bootstrap/js/bootstrap.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}js/popper.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}plugins/slick/slick.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}js/app.js\"></script>\r\n```\r\n### 3.效果\r\n无', '<h1 id=\"h1--dreamer-cms-template\"><a name=\"变量标签dreamer-cms:template\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>变量标签dreamer-cms:template</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签作用是获取当前模板的路径，以方便加载静态资源。该标签属于单标签，也可以写成{dreamer-cms:template}{/dreamer-cms:template}。该标签没有属性，并适用于所有模版，建议使用单标签</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">无</td>\r\n<td style=\"text-align:center\">无</td>\r\n<td style=\"text-align:center\">无</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.示例代码</h3><pre><code class=\"lang-html\">&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}bootstrap/css/bootstrap.min.css\"&gt;\r\n&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/font-awesome.min.css\"&gt;\r\n&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick.css\"&gt;\r\n&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick-theme.css\"&gt;\r\n&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/app.css\"&gt;\r\n&lt;link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/responsive.css\"&gt;\r\n&lt;script src=\"{dreamer-cms:template /}js/jquery-3.2.1.slim.min.js\"&gt;&lt;/script&gt;\r\n&lt;script src=\"{dreamer-cms:template /}bootstrap/js/bootstrap.min.js\"&gt;&lt;/script&gt;\r\n&lt;script src=\"{dreamer-cms:template /}js/popper.min.js\"&gt;&lt;/script&gt;\r\n&lt;script src=\"{dreamer-cms:template /}plugins/slick/slick.min.js\"&gt;&lt;/script&gt;\r\n&lt;script src=\"{dreamer-cms:template /}js/app.js\"&gt;&lt;/script&gt;\r\n</code></pre>\r\n<h3 id=\"h3-3-\"><a name=\"3.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.效果</h3><p>无</p>', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 3, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:53:42', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('d9fea2574384477199d038ac66ebd095', '框架特点', 'feature', 'tnleskz4', '.4ol61bbh.tnleskz4', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', '4e1c58e65fa9423482cf1a29a6ef629b', 0, '2', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:33:50', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:51:23', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('dc10045aed08446bb2d0e5c5d5bf1ae7', '频道标签', 'Channel Label', '6y146016', '.822n58d3.u8xo56nx.6y146016', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 频道标签dreamer-cms:channel\r\n### 1.标签说明\r\n该标签是常用标记，主要用于显示页面的栏目分类并适用于所有模版，通常用于网站顶部以获取站点栏目信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目\r\nstart|0|从第几个开始获取\r\nlength|5|获取个数\r\ntype|top或son|显示类型（top为顶级栏目，son在设置typeid时起作用，获取指定栏目的下级栏目）\r\nshowall|true或false|是否显示隐藏栏目\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码（8位唯一）\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小（该属性控制列表页面默认的分页大小）\r\nvisiturl|String|访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）\r\nlinkurl|String|链接URL\r\neditor|String|编辑器（md或ue）\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序（默认为50）\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目（该属性在dreamer-cms:type标签下不可用）\r\n\r\n### 3.示例代码\r\n```html\r\n<div class=\"popup\" id=\"popup\">\r\n    <div class=\"popup-content\"><div class=\"left-slide-sidebar \">\r\n        <div class=\"canvas-title\">DreamerCMS MENUS</div>\r\n        <ul class=\"list-unstyled slide-sidebar\">\r\n            <li><a href=\"#\">首页</a></li>\r\n            {dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n            <li><a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n            {/dreamer-cms:channel}\r\n        </ul>\r\n    </div>\r\n        <a href=\"#close\" class=\"popup-close\">&times;</a>\r\n    </div>\r\n</div>\r\n```\r\n### 4.效果\r\n![channel标签](http://img.075400.cn/20190820092154.png \"channel标签\")', '<h1 id=\"h1--dreamer-cms-channel\"><a name=\"频道标签dreamer-cms:channel\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>频道标签dreamer-cms:channel</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>该标签是常用标记，主要用于显示页面的栏目分类并适用于所有模版，通常用于网站顶部以获取站点栏目信息。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">4ol61bbh</td>\r\n<td style=\"text-align:center\">后台栏目管理列表页面中的编码，通过唯一编码，获取指定栏目</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">start</td>\r\n<td style=\"text-align:center\">0</td>\r\n<td style=\"text-align:center\">从第几个开始获取</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">length</td>\r\n<td style=\"text-align:center\">5</td>\r\n<td style=\"text-align:center\">获取个数</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">type</td>\r\n<td style=\"text-align:center\">top或son</td>\r\n<td style=\"text-align:center\">显示类型（top为顶级栏目，son在设置typeid时起作用，获取指定栏目的下级栏目）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">showall</td>\r\n<td style=\"text-align:center\">true或false</td>\r\n<td style=\"text-align:center\">是否显示隐藏栏目</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">字段类型</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">typeid</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目ID</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenamecn</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目中文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typenameen</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目英文名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typecode</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目编码（8位唯一）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeseq</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目的层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeimg</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目图片</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">description</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目描述</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linktarget</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接目标</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">pagesize</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">分页大小（该属性控制列表页面默认的分页大小）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">visiturl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">访问URL（浏览器地址栏中将以该url显示，如果为空，则为栏目中文名称的拼音）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">linkurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">链接URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">editor</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">编辑器（md或ue）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">mdcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">markdown内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">htmlcontent</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">生成的html内容</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">parentname</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">上级栏目名称</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">isshow</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">是否显示</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">level</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">栏目层级</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">sort</td>\r\n<td style=\"text-align:center\">Integer</td>\r\n<td style=\"text-align:center\">排序（默认为50）</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">创建人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">createtime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">创建时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updateby</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">更新人</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">updatetime</td>\r\n<td style=\"text-align:center\">Date</td>\r\n<td style=\"text-align:center\">更新时间</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">typeurl</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">栏目URL</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext01</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段1</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext02</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段2</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext03</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段3</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext04</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段4</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">ext05</td>\r\n<td style=\"text-align:center\">String</td>\r\n<td style=\"text-align:center\">扩展字段5</td>\r\n</tr>\r\n<tr>\r\n<td style=\"text-align:center\">haschildren</td>\r\n<td style=\"text-align:center\">Boolean</td>\r\n<td style=\"text-align:center\">是否有下级栏目（该属性在dreamer-cms:type标签下不可用）</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">&lt;div class=\"popup\" id=\"popup\"&gt;\r\n    &lt;div class=\"popup-content\"&gt;&lt;div class=\"left-slide-sidebar \"&gt;\r\n        &lt;div class=\"canvas-title\"&gt;DreamerCMS MENUS&lt;/div&gt;\r\n        &lt;ul class=\"list-unstyled slide-sidebar\"&gt;\r\n            &lt;li&gt;&lt;a href=\"#\"&gt;首页&lt;/a&gt;&lt;/li&gt;\r\n            {dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n            &lt;li&gt;&lt;a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\"&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n            {/dreamer-cms:channel}\r\n        &lt;/ul&gt;\r\n    &lt;/div&gt;\r\n        &lt;a href=\"#close\" class=\"popup-close\"&gt;&amp;times;&lt;/a&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p><img src=\"http://img.075400.cn/20190820092154.png\" alt=\"channel标签\" title=\"channel标签\">', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 6, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 09:38:41', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('dfd4ca19e29841d99a33cc4829b7033a', '免费开源', 'opensource', '01k96rfd', '.4ol61bbh.tnleskz4.01k96rfd', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:46:53', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:51:05', 'fa fa-github', '', '', '', '');
INSERT INTO `cms_category` VALUES ('e5297d56df9a4e8ead60c4347e2dd5c4', '开发社区', 'community', '71e2w1xx', '.71e2w1xx', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 3, '', '', '', '', 'http://www.itechyou.cn', 'md', '', '', '-1', 1, '1', 6, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:55:33', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('e65a0268deb14b9fa7cd6c057034e886', '判断标签', 'If Label', 'g4x40i76', '.822n58d3.u8xo56nx.g4x40i76', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 判断标签dreamer-cms:if\r\n### 1.标签说明\r\n这个标签是用于在页面中作简单的判断，目前只支持eq和neq。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntest|(\'true\' eq [field:haschildren/])|表达式（注：一定要用小括号包裹，目前只支持eq和neq。）\r\n\r\n### 2.返回字段说明\r\n无\r\n\r\n### 3.示例代码\r\n```html\r\n{dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n<li class=\"dropdown nav-item\"><a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\">[field:typenamecn /]</a>\r\n	<ul class=\"dropdown-menu\">\r\n		{dreamer-cms:channel}\r\n		<li><a class=\"dropdown-item\" href=\"[field:typeurl/]\"><i class=\"ion ion-chevron-right\"></i>[field:typenamecn /]</a></li>\r\n		{/dreamer-cms:channel}\r\n	</ul>\r\n</li>\r\n{/dreamer-cms:if}\r\n{dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n<li class=\"nav-item\"><a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n{/dreamer-cms:if}\r\n```\r\n### 4.效果\r\n无', '<h1 id=\"h1--dreamer-cms-if\"><a name=\"判断标签dreamer-cms:if\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>判断标签dreamer-cms:if</h1><h3 id=\"h3-1-\"><a name=\"1.标签说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>1.标签说明</h3><p>这个标签是用于在页面中作简单的判断，目前只支持eq和neq。</p>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"text-align:center\">属性名</th>\r\n<th style=\"text-align:center\">取值范围</th>\r\n<th style=\"text-align:center\">描述</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"text-align:center\">test</td>\r\n<td style=\"text-align:center\">(‘true’ eq [field:haschildren/])</td>\r\n<td style=\"text-align:center\">表达式（注：一定要用小括号包裹，目前只支持eq和neq。）</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<h3 id=\"h3-2-\"><a name=\"2.返回字段说明\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>2.返回字段说明</h3><p>无</p>\r\n<h3 id=\"h3-3-\"><a name=\"3.示例代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>3.示例代码</h3><pre><code class=\"lang-html\">{dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n&lt;li class=\"dropdown nav-item\"&gt;&lt;a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\"&gt;[field:typenamecn /]&lt;/a&gt;\r\n    &lt;ul class=\"dropdown-menu\"&gt;\r\n        {dreamer-cms:channel}\r\n        &lt;li&gt;&lt;a class=\"dropdown-item\" href=\"[field:typeurl/]\"&gt;&lt;i class=\"ion ion-chevron-right\"&gt;&lt;/i&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n        {/dreamer-cms:channel}\r\n    &lt;/ul&gt;\r\n&lt;/li&gt;\r\n{/dreamer-cms:if}\r\n{dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n&lt;li class=\"nav-item\"&gt;&lt;a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\"&gt;[field:typenamecn /]&lt;/a&gt;&lt;/li&gt;\r\n{/dreamer-cms:if}\r\n</code></pre>\r\n<h3 id=\"h3-4-\"><a name=\"4.效果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>4.效果</h3><p>无</p>', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:42:23', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('e6cdbf119da14a30a86a0f9f2189b8e5', '模版中心', 'templates', 'a54547w2', '.a54547w2', '9b5112043c2240d8823bd15759c67604', '', '', '1', 10, 2, 'templates', '', '/list_templates.html', '/article_templates.html', '', 'md', '', '', '-1', 1, '1', 5, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:55:05', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');

-- ----------------------------
-- Table structure for cms_evaluate
-- ----------------------------
DROP TABLE IF EXISTS `cms_evaluate`;
CREATE TABLE `cms_evaluate`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `evaluator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_evaluate
-- ----------------------------
INSERT INTO `cms_evaluate` VALUES ('02238eaa19b44f7bbb2203f01a92ee8f', '18f228df7b8443dfa1039fe3c3e53503', NULL, NULL, NULL, NULL, NULL, '程雨', 'www.xinhudong.com.cn', 'Dreamer CMS是企业在创立初期很好的技术基础框架，加快公司项目开发进度，当然也可以对现有的系统进行升级');
INSERT INTO `cms_evaluate` VALUES ('c70f70e7dd5a4cfa87e0d5c89cfb6ff7', '779bc296ea4a4149bd3c97cdb8cd8593', NULL, NULL, NULL, NULL, NULL, '王俊南', 'www.itechyou.cn', '标签化建站：不需要专业的后台开发技能，只要使用系统提供的标签，就能轻松建设网站；模版开发方便：支持在线上传模版包开发方便快捷');
INSERT INTO `cms_evaluate` VALUES ('63aac7b1d6ca4f81ac051b2e8d79198f', 'e738f12d050849fd9998ac01fd0f5ad7', NULL, NULL, NULL, NULL, NULL, '王亚伟', 'www.itechyou.cn', '免费完整开源：基于Apache2.0协议，源代码完全开源；初学JAVA的同学可以下载源代码来进行学习交流');

-- ----------------------------
-- Table structure for cms_fields
-- ----------------------------
DROP TABLE IF EXISTS `cms_fields`;
CREATE TABLE `cms_fields`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `form_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `field_text` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段提示名',
  `field_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名',
  `type` int NULL DEFAULT 1 COMMENT '类型：0系统自动生成表单字段',
  `data_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据类型',
  `default_value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认值',
  `max_length` int NULL DEFAULT NULL COMMENT '最大长度',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字段' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_fields
-- ----------------------------
INSERT INTO `cms_fields` VALUES ('01a3d20d81f24d678d50238fcd5892ca', 'c17ddcad9fb149a6bf90f7bba0e0696b', '文章内容', 'content', 1, 'html', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-21 11:51:24', NULL, '2018-09-21 11:51:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('125fcd235ab5419ca50e513485f359cf', '9b5112043c2240d8823bd15759c67604', '内容', 'body', 1, 'html', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 11:30:53', NULL, '2019-08-20 11:30:53', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('574d8ab867e948a4ab8bed0eb9162bf1', '440dc002ad4846018d7a1b9433021b22', '版本号', 'versionnum', 1, 'varchar', '', 128, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:17:06', NULL, '2019-08-16 10:17:06', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('74e71cc418494c18bd2b2026fa0b21db', '440dc002ad4846018d7a1b9433021b22', '升级说明', 'notes', 1, 'markdown', '', 1024, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:17:51', NULL, '2019-08-16 10:17:51', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('86601971f1bb47bd81e06f2167ba4398', '06c540abf3a64d9699762711439c82dd', '客户来源', 'source', 1, 'varchar', '', 255, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:05:41', NULL, '2019-08-16 09:05:41', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('a2b7dcd22d1042ef929e2d17c97e747c', '02c73a0271644e8c91cf2400d9325e93', '链接地址', 'link_url', 1, 'varchar', '', 256, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-25 14:33:17', NULL, '2018-09-25 14:33:16', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('a7be21842fc14c108fb779dd1826f6b6', '33a091d40c5e484b880daa744ef4e8aa', '电话', 'telephone', 1, 'varchar', '', 32, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:18:20', NULL, '2020-07-22 14:18:20', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('dddaf4417cec46ed86571035a50d17a7', '33a091d40c5e484b880daa744ef4e8aa', '内容', 'content', 1, 'textarea', '', 500, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:24:03', NULL, '2020-07-22 14:24:03', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('e67c80193b63443d8587971590fba810', '33a091d40c5e484b880daa744ef4e8aa', '回复内容', 'reply', 1, 'textarea', '', 500, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 07:46:47', NULL, '2020-07-22 15:46:47', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('e7d3405934a148c19a7fc1327551a146', '06c540abf3a64d9699762711439c82dd', '评价内容', 'content', 1, 'textarea', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:06:19', NULL, '2019-08-16 09:06:19', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_fields` VALUES ('f312ae651c254b0b88bf090ae3db6c3f', '06c540abf3a64d9699762711439c82dd', '评价人', 'evaluator', 1, 'varchar', '', 64, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:05:18', NULL, '2019-08-16 09:05:18', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for cms_forms
-- ----------------------------
DROP TABLE IF EXISTS `cms_forms`;
CREATE TABLE `cms_forms`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `form_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表单名',
  `table_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表名',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码系统自动生成',
  `type` int NULL DEFAULT 1 COMMENT '类型：0系统模型，1自定义模型',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '表单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_forms
-- ----------------------------
INSERT INTO `cms_forms` VALUES ('02c73a0271644e8c91cf2400d9325e93', '友情链接', 'links', '80AZ783M', 1, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-25 14:30:02', NULL, '2018-09-25 14:30:01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_forms` VALUES ('06c540abf3a64d9699762711439c82dd', '客户评价', 'evaluate', '2EFPN7JY', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:04:22', NULL, '2019-08-16 09:04:22', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_forms` VALUES ('33a091d40c5e484b880daa744ef4e8aa', '留言管理', 'message', '8t2lkr8d', 1, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:10:04', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:10:36', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_forms` VALUES ('440dc002ad4846018d7a1b9433021b22', '更新记录', 'versionnotes', 'LUVC0AW2', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:16:31', NULL, '2019-08-16 10:16:31', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_forms` VALUES ('9b5112043c2240d8823bd15759c67604', '模版中心', 'templates', '3NF20KCW', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:26:20', NULL, '2019-08-15 17:26:20', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_forms` VALUES ('c17ddcad9fb149a6bf90f7bba0e0696b', '普通文章', 'article', 'V1WL66A0', 0, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-12 09:59:38', NULL, '2018-09-12 10:26:00', 'selected', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for cms_labels
-- ----------------------------
DROP TABLE IF EXISTS `cms_labels`;
CREATE TABLE `cms_labels`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tag_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签名称',
  `pinyin` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拼音',
  `first_char` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首字母',
  `tag_count` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签使用次数',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '标签' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_labels
-- ----------------------------
INSERT INTO `cms_labels` VALUES ('241d2e14a9764795acc29ff6b4ef0a4a', 'hbase', 'hbase', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08');
INSERT INTO `cms_labels` VALUES ('27ee21fd44ee4b3996d2546e700ca68a', 'css', 'css', 'c', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:09');
INSERT INTO `cms_labels` VALUES ('2df0b5c5dc474fc38969ce4fab5b1ee7', '花开', 'huakai', 'h', '1', NULL, '2018-09-21 13:40:16', NULL, '2018-09-21 13:40:15');
INSERT INTO `cms_labels` VALUES ('30b42859b3b2400396b123947fb4f5b4', '单例', 'danli', 'd', '1', NULL, '2018-09-27 10:54:28', NULL, '2018-09-27 10:54:28');
INSERT INTO `cms_labels` VALUES ('3459b5788ec04732b336c484db6c8806', '大数据', 'dashuju', 'd', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08');
INSERT INTO `cms_labels` VALUES ('3808d4ebd78a4861bc49cf3d653000aa', '职业发展', 'zhiyefazhan', 'z', '1', NULL, '2018-09-21 13:44:36', NULL, '2018-09-21 13:44:35');
INSERT INTO `cms_labels` VALUES ('4ccffe77671a4c3bbbf7854fdc44d0c8', 'css3', 'css3', 'c', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05');
INSERT INTO `cms_labels` VALUES ('5b471f24146144899e5227a5dc4eaadd', '原型', 'yuanxing', 'y', '1', NULL, '2018-09-27 11:19:00', NULL, '2018-09-27 11:18:59');
INSERT INTO `cms_labels` VALUES ('5e7586fcb4d44c15a3d94e93f6281c54', 'eee', 'eee', 'e', '1', NULL, '2019-12-18 02:18:59', NULL, '2019-12-18 10:18:59');
INSERT INTO `cms_labels` VALUES ('77eae8930c30458aac733a4e778ba498', '商务', 'shangwu', 's', '1', NULL, '2019-08-21 16:47:41', NULL, '2019-08-21 16:47:41');
INSERT INTO `cms_labels` VALUES ('8daeee953c764a33ba2c91ae0f3610b7', 'html5', 'html5', 'h', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05');
INSERT INTO `cms_labels` VALUES ('96f315f72dfa498e8e65afe85a22775e', 'hive', 'hive', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08');
INSERT INTO `cms_labels` VALUES ('a49146f9af0b43a592998f6072af08bf', 'html', 'html', 'h', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:08');
INSERT INTO `cms_labels` VALUES ('a8e12dfe133a4bd8808e029f8a8c4a05', 'eeee', 'eeee', 'e', '1', NULL, '2019-12-18 02:21:34', NULL, '2019-12-18 10:21:34');
INSERT INTO `cms_labels` VALUES ('a96f5f9c526d447cbee797b2536af1b3', '要强', 'yaoqiang', 'y', '1', NULL, '2018-09-21 13:42:05', NULL, '2018-09-21 13:42:04');
INSERT INTO `cms_labels` VALUES ('a9d47da353be4e10aac3e1e23338862a', 'js', 'js', 'j', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:08');
INSERT INTO `cms_labels` VALUES ('cd6cd19104ab4bdf86bad96c0c9ac0cf', 'factory', 'factory', 'f', '1', NULL, '2018-09-27 11:16:22', NULL, '2018-09-27 11:16:21');
INSERT INTO `cms_labels` VALUES ('d51ddfca743b47f686120300691cecd0', '工厂模式', 'gongchangmoshi', 'g', '1', NULL, '2018-09-27 11:16:22', NULL, '2018-09-27 11:16:21');
INSERT INTO `cms_labels` VALUES ('e281ef86dfbb4d75b8141f8abfb7291b', '建造者', 'jianzaozhe', 'j', '1', NULL, '2018-09-27 11:19:00', NULL, '2018-09-27 11:18:59');
INSERT INTO `cms_labels` VALUES ('e39a57377c814132b9db8d7c1105a3db', 'qqq', 'qqq', 'q', '1', NULL, '2019-12-18 02:34:41', NULL, '2019-12-18 10:34:41');
INSERT INTO `cms_labels` VALUES ('e4bf078774b840b5a13eafa48c03a3a7', 'singleton', 'singleton', 's', '1', NULL, '2018-09-27 10:54:28', NULL, '2018-09-27 10:54:27');
INSERT INTO `cms_labels` VALUES ('e6d72c095f9c4532a298337e6a612c22', 'script', 'script', 's', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:09');
INSERT INTO `cms_labels` VALUES ('f4d45bfa3b284792b6411390831063d7', 'bootstrap', 'bootstrap', 'b', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05');
INSERT INTO `cms_labels` VALUES ('f55bab7dc7234dfa9883c181e8d29825', 'hadoop', 'hadoop', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08');
INSERT INTO `cms_labels` VALUES ('fdf1a43c32a7454dbfd42626ec4d4263', 'thymeleaf', 'thymeleaf', 't', '1', NULL, '2018-09-28 16:52:32', NULL, '2018-09-28 16:52:31');

-- ----------------------------
-- Table structure for cms_links
-- ----------------------------
DROP TABLE IF EXISTS `cms_links`;
CREATE TABLE `cms_links`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `link_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外链' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_links
-- ----------------------------
INSERT INTO `cms_links` VALUES ('00de5fcc84f44d07ba2fd3b80098dd3a', '47864f1e06334cdc8c87b9419dc63abf', NULL, NULL, NULL, NULL, NULL, 'http://www.itechyou.cn');
INSERT INTO `cms_links` VALUES ('60534518cfa04fb8bc864119035f6970', '598fb8d59fbf4bdca544d71cb64c1ce0', NULL, NULL, NULL, NULL, NULL, 'http://www.baidu.com');

-- ----------------------------
-- Table structure for cms_message
-- ----------------------------
DROP TABLE IF EXISTS `cms_message`;
CREATE TABLE `cms_message`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `telephone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `reply` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_message
-- ----------------------------
INSERT INTO `cms_message` VALUES ('5c41458ebf3849b5befe56a5b0b5d329', '495c981ae1be45fb8d989d76b2d18672', NULL, NULL, NULL, NULL, NULL, '13888888888', '你好，我们公司想要订购产品？请问是怎么个操作流程？', '订购产品加添加官方唯一指定微信：wangjn2015，我们会线上为您解答各种问题。');
INSERT INTO `cms_message` VALUES ('c9fc5f46c24d4619854224da9594b38d', '9736f68a332a48419178c5d3fdeb42bd', NULL, NULL, NULL, NULL, NULL, '13666664444', '我们是做产品直销的？有没有合作的意向？详情请联系QQ153095904', NULL);

-- ----------------------------
-- Table structure for cms_search
-- ----------------------------
DROP TABLE IF EXISTS `cms_search`;
CREATE TABLE `cms_search`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `keywords` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '搜索词' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_search
-- ----------------------------
INSERT INTO `cms_search` VALUES ('0576a469a5d44f5189c15108c7faeab2', '商务展会', '2020-04-02 03:17:33');
INSERT INTO `cms_search` VALUES ('101784639d6f47b481bb60e910e0ff6e', '商务展会', '2020-04-02 03:26:18');
INSERT INTO `cms_search` VALUES ('144d69a4ddbd4a6788bee5d6e5d1f791', '商务展会', '2020-04-02 03:26:57');
INSERT INTO `cms_search` VALUES ('14ed5a98124c4715bc35ff76dc4e7e62', 'ddd', '2020-04-02 02:40:53');
INSERT INTO `cms_search` VALUES ('14fc6be9ee154f1c83601f1601805566', 'orion', '2020-04-02 02:41:44');
INSERT INTO `cms_search` VALUES ('190e8c68f24941cf8ba4717999d90135', 'ddd', '2020-04-02 02:39:04');
INSERT INTO `cms_search` VALUES ('199ed8841e4241cfbfc2f34a54185459', 'ddd', '2020-04-02 02:40:26');
INSERT INTO `cms_search` VALUES ('1fd26fcab46d4cb7bda59fba0b90b712', '商务展会', '2020-04-02 03:29:36');
INSERT INTO `cms_search` VALUES ('243b5395cb374d9d8cde05048fa76d23', 'kid', '2020-04-02 02:52:41');
INSERT INTO `cms_search` VALUES ('2525f2133f494568856f8ad44242bbf9', '商务展会', '2020-04-02 03:14:32');
INSERT INTO `cms_search` VALUES ('27b96c0b2575442cb34d62d1520865f0', '生命', '2018-09-25 16:55:49');
INSERT INTO `cms_search` VALUES ('38f9dd4448864a77b50a2753a01e6566', '123', '2018-09-29 10:13:52');
INSERT INTO `cms_search` VALUES ('3a009f62856e4b59b2bbbe8dc856ebe1', '生命', '2018-09-25 16:55:54');
INSERT INTO `cms_search` VALUES ('536dccc79be54304a0e5da5ab14b6d7e', '商务展会', '2020-04-02 03:26:20');
INSERT INTO `cms_search` VALUES ('549e965be5514399b45823dc45334159', '商务展会', '2020-04-02 03:19:24');
INSERT INTO `cms_search` VALUES ('5e0a340ef72d4a48ab79490da80c9787', 'ddd', '2020-04-02 01:35:31');
INSERT INTO `cms_search` VALUES ('62dd8ec00f014f679bf67971adea862d', '商务展会', '2020-04-02 03:13:45');
INSERT INTO `cms_search` VALUES ('665a4ff7f9274656b84d7591bafa6fa9', '商务展会', '2020-04-02 03:18:59');
INSERT INTO `cms_search` VALUES ('66a2dfda9e474cbeb7ea933611020fce', 'ddd', '2020-04-02 01:35:58');
INSERT INTO `cms_search` VALUES ('6b3c43b6e6434a7c80707318f0a31205', '商务展会', '2020-04-02 03:14:26');
INSERT INTO `cms_search` VALUES ('6fd3f7e5383c43d3a80231e04b274366', '网页', '2018-09-29 13:59:37');
INSERT INTO `cms_search` VALUES ('71378a798659412ba35c5bf4b049d993', '生涯', '2018-09-29 10:18:10');
INSERT INTO `cms_search` VALUES ('78c3ef5c791c41bf98c8f653b424eb3a', '程序员', '2018-09-25 15:17:08');
INSERT INTO `cms_search` VALUES ('7dafe01549344990856819ea0cdd04ba', '商务展会', '2020-04-02 03:10:42');
INSERT INTO `cms_search` VALUES ('7eb0417789c14fae8f81e2cb09cdd960', 'ddd', '2020-04-02 01:35:00');
INSERT INTO `cms_search` VALUES ('8d2758e477934827b8e66e15eb3de577', 'orion', '2020-04-02 02:52:12');
INSERT INTO `cms_search` VALUES ('9481b56b96d64fa89434ac74764c7a23', '商务展会', '2020-04-02 03:28:34');
INSERT INTO `cms_search` VALUES ('97429b54220e4b12a34269cf4c729ae8', 'ddd', '2020-04-02 02:41:22');
INSERT INTO `cms_search` VALUES ('9a022ea5908746c8be4b617dc843bad7', '程序员', '2018-09-25 15:13:43');
INSERT INTO `cms_search` VALUES ('9ae46553ba814124bb77936e37c321ec', '商务展会', '2020-04-02 03:28:59');
INSERT INTO `cms_search` VALUES ('a66efae4d3d54a97904b9aa80e3df11b', '商务展会', '2020-04-02 03:14:20');
INSERT INTO `cms_search` VALUES ('ac19c322c2b04d1fa4f74f9c5f14a9c7', '大气ORION渐变', '2021-04-03 04:10:53');
INSERT INTO `cms_search` VALUES ('b3e145bb35e54356a7f641ddc34da677', '商务展会', '2020-04-02 03:25:25');
INSERT INTO `cms_search` VALUES ('c009c85f6cd2409a81e136a79e8eb424', '商务展会', '2020-04-02 03:09:53');
INSERT INTO `cms_search` VALUES ('ce488145bd9648699955635e947a6dde', '商务展会', '2020-04-02 05:59:17');
INSERT INTO `cms_search` VALUES ('d05cfad7936041a1ae18fbf39b568cc4', '商务展会', '2020-04-02 03:12:19');
INSERT INTO `cms_search` VALUES ('db15a8e41db3459fa9540f5c4a8001fe', '商务展会', '2020-05-15 06:36:20');
INSERT INTO `cms_search` VALUES ('df4816a927d6405a99712b85eb75eae6', '商务展会', '2020-04-02 03:27:32');
INSERT INTO `cms_search` VALUES ('ea72063604a249db8df3cbed171b83f4', '商务展会', '2020-04-02 03:19:50');
INSERT INTO `cms_search` VALUES ('eb01083582c242bc9f915fa671de8314', '商务展会', '2020-04-02 03:28:05');
INSERT INTO `cms_search` VALUES ('f0f604b09dbd4b3783758ad80bea5e9f', 'orion', '2020-04-02 02:49:11');
INSERT INTO `cms_search` VALUES ('f2c798f6baba4963ae23883d2afe41ee', '程序员', '2018-09-25 15:17:53');
INSERT INTO `cms_search` VALUES ('f45e52d31d57470ab0fd0b8987ba29b7', '商务展会', '2020-04-02 03:18:33');
INSERT INTO `cms_search` VALUES ('f4cdbb9d28c24a498fd83652a984cbcf', '商务展会', '2020-04-02 03:25:34');
INSERT INTO `cms_search` VALUES ('f7f3c4a6bcac48ad9663431cb6c3cf10', '商务展会', '2020-04-02 03:09:02');
INSERT INTO `cms_search` VALUES ('fd8c5fa78c164962bdbc92248d0b65df', 'kid', '2020-04-02 03:00:05');

-- ----------------------------
-- Table structure for cms_setting
-- ----------------------------
DROP TABLE IF EXISTS `cms_setting`;
CREATE TABLE `cms_setting`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `website` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '网站地址',
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点标题',
  `keywords` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点关键词',
  `describe` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点描述',
  `icp` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备案号',
  `copyright` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版权',
  `uploaddir` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'uploads/' COMMENT '上传目录',
  `appid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '畅言appid',
  `appkey` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '畅言appkey',
  `staticdir` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'htmls' COMMENT '静态化目录',
  `browse_type` int NULL DEFAULT 1 COMMENT '浏览方式（1：动态2：静态）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_setting
-- ----------------------------
INSERT INTO `cms_setting` VALUES ('1', 'http://localhost:8888/', 'Dreamer CMS 梦想家内容发布系统', 'Dreamer CMS 梦想家内容发布系统', 'Dreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统，采用最流行的springboot+thymeleaf框架搭建，灵活小巧，配置简单。', '冀ICP备19026223号', 'Copyright © 2018 Powered by I Tech You,我教你，Dreamer CMS 梦想家内容发布系统', 'uploads/', 'cytQcJUcb', '2dd87fd430f0509cf00e18de4328e100', 'htmls', 1);

-- ----------------------------
-- Table structure for cms_templates
-- ----------------------------
DROP TABLE IF EXISTS `cms_templates`;
CREATE TABLE `cms_templates`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_templates
-- ----------------------------
INSERT INTO `cms_templates` VALUES ('989bac83b8004120845fb3f8791936e4', 'd64d167032c84521ad21708cccc1f963', NULL, NULL, NULL, NULL, NULL, '<p><strong style=\"white-space: normal; background-color: rgb(255, 255, 255); line-height: 24px; color: rgb(255, 255, 255); font-family: Arial; font-size: 15px; padding: 0px; margin: 0px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">模板名称：</span></strong><br style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 26px;\"/><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\"><strong>财税记账工商注册认证公司类<a href=\"http://www.dede58.com/\" target=\"_blank\" style=\"color: rgb(70, 81, 96); letter-spacing: 1px; text-decoration-line: none;\"><span style=\"text-decoration:underline;\">织梦模板</span></a>(带手机端)+PC+移动端+利于SEO优化</strong></span><br style=\"font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: Tahoma, 宋体, Geneva, sans-serif; line-height: 25.2px;\"/><strong style=\"white-space: normal; background-color: rgb(255, 255, 255); line-height: 24px; color: rgb(255, 255, 255); font-family: Arial; font-size: 15px; padding: 0px; margin: 0px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">模板介绍：</span></strong><br style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 26px;\"/><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255); line-height: 26px;\">织梦最新内核开发的模板，该模板属于财税记账、工商注册类企业使用，</span><br style=\"font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: Tahoma, 宋体, Geneva, sans-serif; line-height: 25.2px;\"/><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255); line-height: 26px;\"><span style=\"color: rgb(255, 0, 0);\">自带最新的手机移动端，同一个后台，数据即时同步，简单适用！</span><br/>原创设计、手工书写DIV+CSS，<br/>完美兼容IE7+、Firefox、Chrome、360浏览器等；主流浏览器；<br/>页面简洁简单，容易管理，DEDE内核都可以使用；附带测试数据！</span><br style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 26px;\"/></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 24px; transition: all 0.2s linear 0s; width: 708px;\"><span style=\"color: rgb(51, 51, 51); font-family: Arial; font-size: 15px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; color: rgb(255, 255, 255);\"><strong style=\"padding: 0px; margin: 0px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">模板特点：</span></strong></span></span></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); line-height: 26px;\">该模板多数为单页面，修改很多需要在代码文件上修改，图片很多也需要通过FTP工具修改，<br/>因为财税类的页面比较多，所以很多都是写在模板文件上的！</p><p><strong style=\"color: rgb(255, 255, 255); padding: 0px; margin: 0px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">&nbsp;使用程序：</span></strong></p><p><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 15px;\">织梦DEDECMS版本都可以使用。</span><br/><strong style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 15px; padding: 0px; margin: 0px;\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; color: rgb(255, 255, 255);\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">&nbsp;</span></span><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; color: rgb(240, 255, 240);\"><span style=\"padding: 0px; margin: 0px; transition: all 0.2s linear 0s; background-color: rgb(0, 128, 0);\">模板页面：</span></span></strong><br/><span style=\"color:#465160;font-family:Microsoft YaHei, Tahoma, Helvetica, Arial, sans-serif;color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif;\">index.htm 首页模板</span><br/><span style=\"color:#465160;font-family:Microsoft YaHei, Tahoma, Helvetica, Arial, sans-serif;color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif;\">head.htm</span><br/><span style=\"color:#465160;font-family:Microsoft YaHei, Tahoma, Helvetica, Arial, sans-serif;color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif;\">footer.htm&nbsp;</span><br/></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif;\">article_article.htm 文章内容</p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px;\"><span style=\"color:#465160;font-family:Microsoft YaHei, Tahoma, Helvetica, Arial, sans-serif;color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif;\">这里不一一列出！</span><br/><span style=\"color: rgb(255, 255, 255); font-family: &quot;Microsoft Yahei&quot;, Tahoma, STHeiti; background-color: rgb(51, 153, 102);\">&nbsp;温馨提示：</span><br/><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 15px;\">按照正常的织梦安装步骤来安装还原就可以用了，从后台重新点击保存下系统基本参数。 系统&gt;系统基本参数&gt; 保存（确定）。</span><br/><span style=\"color: rgb(255, 255, 255); font-family: &quot;Microsoft Yahei&quot;, Tahoma, STHeiti; background-color: rgb(51, 153, 102);\">&nbsp;后期bug修正：</span><br/><span style=\"color:#000000;font-family:Arial\"><span style=\"font-size: 15px;\">暂无</span></span><br/><span style=\"color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 15px;\">PC截图：</span></p><p><img alt=\"\" src=\"/upload/20190820/1566271920231067165.jpg\" style=\"border: none; color: rgb(70, 81, 96); font-family: &quot;Microsoft YaHei&quot;, Tahoma, Helvetica, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\"/></p><p><br/></p>');
INSERT INTO `cms_templates` VALUES ('abdf55c143414c7e9c1f16789805c88e', '182306d8eab44225a5ce123ad6a01ffd', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_templates` VALUES ('5ee77e9a26b449fe9ee300fe1b888c77', '93b0ac1621024e4682442acd646da397', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cms_templates` VALUES ('964090d9b8ae429d9b22d8ba346f2348', 'cc1b4cc70af54410a9486e7d4babd5a7', NULL, NULL, NULL, NULL, NULL, '');

-- ----------------------------
-- Table structure for cms_theme
-- ----------------------------
DROP TABLE IF EXISTS `cms_theme`;
CREATE TABLE `cms_theme`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `theme_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '风格名称',
  `theme_author` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者',
  `theme_img` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '缩略图',
  `theme_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目录名',
  `status` int NULL DEFAULT 0 COMMENT '状态1:启用0:禁用',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_theme
-- ----------------------------
INSERT INTO `cms_theme` VALUES ('782c003ac9024eba94ae3b59dab17b5d', '默认主题', '王俊南', 'http://localhost:8888/uploads\\20190815\\18c8a53e1b63493b821c9ab865c4b395.jpg', 'default', 1, '9f4b807db2e94670bb02cdc212ea7389', '2018-01-01 00:00:00', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-03 17:30:06');

-- ----------------------------
-- Table structure for cms_variable
-- ----------------------------
DROP TABLE IF EXISTS `cms_variable`;
CREATE TABLE `cms_variable`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
  `item_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变量名称',
  `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段类型',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变量值',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00' COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '变量管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_variable
-- ----------------------------
INSERT INTO `cms_variable` VALUES ('2d3add7ac60949cc9035ea0bfd50f113', 'cfg_gitee_addr', '码云下载地址', '', 'https://gitee.com/isoftforce/dreamer_cms', '', '2019-08-16 22:38:59', '', '2019-08-16 22:38:59');
INSERT INTO `cms_variable` VALUES ('383e2a267d0045e5aad93ed20ca1b038', 'cfg_github_addr', 'Github下载地址', '', 'https://github.com/xinhudong/Dreamer_cms', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 22:39:47', '', '2019-08-16 22:39:47');

-- ----------------------------
-- Table structure for cms_versionnotes
-- ----------------------------
DROP TABLE IF EXISTS `cms_versionnotes`;
CREATE TABLE `cms_versionnotes`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID',
  `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `versionnum` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cms_versionnotes
-- ----------------------------
INSERT INTO `cms_versionnotes` VALUES ('c508f9f8fb7a4a99ae09154156d07fb8', '4f451c4797c54536869f5cf748944f9e', NULL, NULL, NULL, NULL, NULL, 'Previous Releases 1.0.1', '* 免费完整开源：基于MIT协议，源代码完全开源；\r\n* 标签化建站：不需要专业的后台开发技能，只要使用系统提供的标签，就能轻松建设网站；\r\n* 模版开发方便：支持在线上传模版包开发方便快捷；\r\n* 每月更新：每月进行系统升级，分享更多好用的模版与插件；');
INSERT INTO `cms_versionnotes` VALUES ('52dfa8ed6c974c9cb397b10efabac57b', 'fb7c4cf30dd1456e8b21af621479a2e4', NULL, NULL, NULL, NULL, NULL, 'Previous Releases 2.0.0', '* 对所有自定义标签进行解析\r\n* 开发标签解析引擎\r\n* 支持扩展标签');
INSERT INTO `cms_versionnotes` VALUES ('efcc109d5a594ccfa99da7700c8b12e5', 'edda8fda8cc24a00b82e3f2ccfeb521d', NULL, NULL, NULL, NULL, NULL, 'Previous Releases 2.5.1', '1、开发搜索结果标签解析\r\n2、优化默认模版页面\r\n3、修改栏目功能bug\r\n4、新增多环境启动功能');

SET FOREIGN_KEY_CHECKS = 1;