cms.sql 170 KB
Newer Older
lanbaoming's avatar
lanbaoming committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567
/*
 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;