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\"><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</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: "Microsoft YaHei"; 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: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">王俊南(QQ:153095904)；</span><br style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", 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: "Helvetica Neue", 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: "Helvetica Neue", 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: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">DreamerCMS创始人；草根站长；</span><br style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">有10年的JAVA学习工作研究经验，先后参与过国家电网登高项目，企业OA项目；</span><br style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">多个政府服务平台项目，具有丰富的J2EE开发经验；</span><br style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">5年多的Java培训指导教育经验，原创教程通俗易懂，深受喜爱；</span><br style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"/><span style=\"color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);\">从事多年IT，拥有较广的人脉； </span></span></p><p style=\"padding: 0px; margin-top: 0px; margin-bottom: 0px; font-family: "Microsoft YaHei"; 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: "Microsoft YaHei"; 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: "Microsoft YaHei"; 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;\"> </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\"><!--=== 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</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\"><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</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\r\n\r\n\r\n\r\n\r\n\r\n', '<section class=\"output_wrapper\" id=\"output_wrapper_id\" style=\"color: rgb(62, 62, 62); line-height: 1.6; letter-spacing: 0px; font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", 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 </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\"><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</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: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", 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/> a、default.html一般是做网站的欢迎引导界面；<br/> 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\"><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</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\"><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</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\"><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</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\r\n\r\n\r\n\r\n\r\n\r\n', '<p style=\"box-sizing: border-box; margin-bottom: 1.5em; padding: 0px; color: rgb(62, 62, 62); font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", 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: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", 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 </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 </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\"><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</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\">×</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\"><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</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<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</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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", 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);\"> 使用程序：</span></strong></p><p><span style=\"color: rgb(70, 81, 96); font-family: "Microsoft YaHei", 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);\"> </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: "Microsoft YaHei", 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: "Microsoft YaHei", 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: "Microsoft YaHei", Tahoma, Helvetica, Arial, sans-serif;\">footer.htm </span><br/></p><p style=\"margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(70, 81, 96); font-family: "Microsoft YaHei", 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: "Microsoft YaHei", Tahoma, Helvetica, Arial, sans-serif;\">这里不一一列出！</span><br/><span style=\"color: rgb(255, 255, 255); font-family: "Microsoft Yahei", Tahoma, STHeiti; background-color: rgb(51, 153, 102);\"> 温馨提示：</span><br/><span style=\"color: rgb(70, 81, 96); font-family: "Microsoft YaHei", Tahoma, Helvetica, Arial, sans-serif; font-size: 15px;\">按照正常的织梦安装步骤来安装还原就可以用了，从后台重新点击保存下系统基本参数。 系统>系统基本参数> 保存（确定）。</span><br/><span style=\"color: rgb(255, 255, 255); font-family: "Microsoft Yahei", Tahoma, STHeiti; background-color: rgb(51, 153, 102);\"> 后期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: "Microsoft YaHei", 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: "Microsoft YaHei", 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;