forked from KINGGUOKUN/SystemManagement
-
Notifications
You must be signed in to change notification settings - Fork 0
/
SystemManagement.sql
727 lines (684 loc) · 67 KB
/
SystemManagement.sql
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
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
/*
Navicat Premium Data Transfer
Source Server : 192.168.1.100
Source Server Type : MySQL
Source Server Version : 80019
Source Host : 192.168.1.100:3306
Source Schema : SystemManagement
Target Server Type : MySQL
Target Server Version : 80019
File Encoding : 65001
Date: 11/03/2020 21:23:21
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for CMSArticle
-- ----------------------------
DROP TABLE IF EXISTS `CMSArticle`;
CREATE TABLE `CMSArticle` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Author` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
`Content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`IdChannel` bigint(0) NOT NULL COMMENT '栏目id',
`Img` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章题图ID',
`Title` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of CMSArticle
-- ----------------------------
INSERT INTO `CMSArticle` VALUES (1, 1, '2019-03-09 16:24:58', 1, '2019-05-10 13:22:49', 'enilu', '<div id=\"articleContent\" class=\"content\">\n<div class=\"ad-wrap\">\n<p style=\"margin: 0 0 10px 0;\">一般我们都有这样的需求：我需要知道库中的数据是由谁创建，什么时候创建，最后一次修改时间是什么时候，最后一次修改人是谁。web-flash最新代码已经实现该需求，具体实现方式网上有很多资料，这里做会搬运工，将web-flash的实现步骤罗列如下：%%</p>\n</div>\n<p>在Spring jpa中可以通过在实体bean的属性或者方法上添加以下注解来实现上述需求@CreatedDate、@CreatedBy、@LastModifiedDate、@LastModifiedBy。</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>@CreatedDate 表示该字段为创建时间时间字段，在这个实体被insert的时候，会设置值</p>\n</li>\n<li>\n<p>@CreatedBy 表示该字段为创建人，在这个实体被insert的时候，会设置值</p>\n</li>\n<li>\n<p>@LastModifiedDate 最后修改时间 实体被update的时候会设置</p>\n</li>\n<li>\n<p>@LastModifiedBy 最后修改人 实体被update的时候会设置</p>\n</li>\n</ul>\n<h2>使用方式</h2>\n<h3>实体类添加注解</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>首先在实体中对应的字段加上上述4个注解</p>\n</li>\n<li>\n<p>在web-flash中我们提取了一个基础实体类BaseEntity，并将对应的字段添加上述4个注解,所有需要记录维护信息的表对应的实体都集成该类</p>\n</li>\n</ul>\n<pre>import org.springframework.data.annotation.CreatedBy;\nimport org.springframework.data.annotation.CreatedDate;\nimport org.springframework.data.annotation.LastModifiedBy;\nimport org.springframework.data.annotation.LastModifiedDate;\nimport javax.persistence.Column;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.Id;\nimport javax.persistence.MappedSuperclass;\nimport java.io.Serializable;\nimport java.util.Date;\n@MappedSuperclass\n@Data\npublic abstract class BaseEntity implements Serializable {\n @Id\n @GeneratedValue\n private Long id;\n @CreatedDate\n @Column(name = \"create_time\",columnDefinition=\"DATETIME COMMENT \'创建时间/注册时间\'\")\n private Date createTime;\n @Column(name = \"create_by\",columnDefinition=\"bigint COMMENT \'创建人\'\")\n @CreatedBy\n private Long createBy;\n @LastModifiedDate\n @Column(name = \"modify_time\",columnDefinition=\"DATETIME COMMENT \'最后更新时间\'\")\n private Date modifyTime;\n @LastModifiedBy\n @Column(name = \"modify_by\",columnDefinition=\"bigint COMMENT \'最后更新人\'\")\n private Long modifyBy;\n}</pre>\n<h3>实现AuditorAware接口返回操作人员的id</h3>\n<p>配置完上述4个注解后，在jpa.save方法被调用的时候，时间字段会自动设置并插入数据库，但是CreatedBy和LastModifiedBy并没有赋值 这两个信息需要实现AuditorAware接口来返回操作人员的id</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>首先需要在项目启动类添加@EnableJpaAuditing 注解来启用审计功能</p>\n</li>\n</ul>\n<pre>@SpringBootApplication\n@EnableJpaAuditing\npublic class AdminApplication extends WebMvcConfigurerAdapter {\n //省略\n}</pre>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>然后实现AuditorAware接口返回操作人员的id</p>\n</li>\n</ul>\n<pre>@Configuration\npublic class UserIDAuditorConfig implements AuditorAware<Long> {\n @Override\n public Long getCurrentAuditor() {\n ShiroUser shiroUser = ShiroKit.getUser();\n if(shiroUser!=null){\n return shiroUser.getId();\n }\n return null;\n }\n}</pre>\n</div>', 1, '1', 'web-flash 将所有表增加维护人员和维护时间信息');
INSERT INTO `CMSArticle` VALUES (2, 1, '2019-03-09 16:24:58', 1, '2019-03-23 23:12:16', 'enilu.cn', '<div id=\"articleContent\" class=\"content\">\n<div class=\"ad-wrap\">\n<p style=\"margin: 0 0 10px 0;\"><a style=\"color: #a00; font-weight: bold;\" href=\"https://my.oschina.net/u/3985214/blog/3018099?tdsourcetag=s_pcqq_aiomsg\" target=\"_blank\" rel=\"noopener\" data-traceid=\"news_detail_above_text_link_1\" data-tracepid=\"news_detail_above_text_link\">开发十年，就只剩下这套架构体系了！ >>></a> <img style=\"max-height: 32px; max-width: 32px;\" src=\"https://www.oschina.net/img/hot3.png\" align=\"\" /></p>\n</div>\n<h3>国际化</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>web-flash实现国际化了.</p>\n</li>\n<li>\n<p>不了解上面两个的区别的同学可以再回顾下这个<a href=\"http://www.enilu.cn/web-flash/base/web-flash.html\">文档</a></p>\n</li>\n<li>\n<p>web-flash实现国际化的方式参考vue-element-admin的 <a href=\"https://panjiachen.github.io/vue-element-admin-site/zh/guide/advanced/i18n.html\" target=\"_blank\" rel=\"noopener\">官方文档</a>,这里不再赘述,强烈建议你先把文档读了之后再看下面的内容。</p>\n</li>\n</ul>\n<h3>默认约定</h3>\n<p>针对网站资源进行国际园涉及到的国际化资源的管理维护，这里给出一些web-flash的资源分类建议，当然，你也可以根据你的实际情况进行调整。</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>src/lang/为国际化资源目录,目前提供了英文（en.js）和中文(zh.js)的两种语言实现。</p>\n</li>\n<li>\n<p>目前资源语言资源文件中是json配置主要有以下几个节点：</p>\n</li>\n<ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\">\n<li>\n<p>route 左侧菜单资源</p>\n</li>\n<li>\n<p>navbar 顶部导航栏资源</p>\n</li>\n<li>\n<p>button 公共的按钮资源，比如：添加、删除、修改、确定、取消之类等等</p>\n</li>\n<li>\n<p>common 其他公共的资源，比如一些弹出框标题、提示信息、label等等</p>\n</li>\n<li>\n<p>login 登录页面资源</p>\n</li>\n<li>\n<p>config 参数管理界面资源</p>\n</li>\n</ul>\n<li>\n<p>目前针对具体的页面资源只做了登录和参数管理两个页面，其他具体业务界面仅针对公共的按钮做了国际化，你可以参考config页面资源进行配置进行进一步配置：/src/views/cfg/</p>\n</li>\n<li>\n<p>如果你有其他资源在上面对应的节点添加即可，针对每个页面特有的资源以页面名称作为几点进行维护，这样方便记忆和维护，不容易出错。</p>\n</li>\n</ul>\n<h3>添加新的语言支持</h3>\n<p>如果英文和中文两种语言不够，那么你可以通过下面步骤添加语言支持</p>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>在src/lang/目录下新增对应的资源文件</p>\n</li>\n<li>\n<p>在src/lang/index.js中import对应的资源文件</p>\n</li>\n<li>\n<p>在src/lang/index.js中的messages变量中加入新的语言声明</p>\n</li>\n<li>\n<p>在src/components/LangSelect/index.vue的语言下拉框中增加新的语言选项</p>\n</li>\n</ul>\n<h3>演示地址</h3>\n<ul class=\" list-paddingleft-2\">\n<li>\n<p>vue版本后台管理 <a href=\"http://106.75.35.53:8082/vue/#/login\" target=\"_blank\" rel=\"noopener\">http://106.75.35.53:8082/vue/#/login</a></p>\n</li>\n<li>CMS内容管理系统的h5前端demo:<a href=\"http://106.75.35.53:8082/mobile/#/index\" target=\"_blank\" rel=\"noopener\">http://106.75.35.53:8082/mobile/#/index</a></li>\n</ul>\n</div>', 1, '2', 'web-flash1.0.1 发布，增加国际化和定时任务管理功能');
INSERT INTO `CMSArticle` VALUES (3, 1, '2019-03-09 16:24:58', 1, '2019-04-28 17:39:52', 'enilu.cn', '<div class=\"content\" id=\"articleContent\">\r\n <div class=\"ad-wrap\">\r\n <p style=\"margin:0 0 10px 0;\"><a data-traceid=\"news_detail_above_text_link_1\" data-tracepid=\"news_detail_above_text_link\" style=\"color:#A00;font-weight:bold;\" href=\"https://my.oschina.net/u/3985214/blog/3018099?tdsourcetag=s_pcqq_aiomsg\" target=\"_blank\">开发十年，就只剩下这套架构体系了！ >>></a> <img src=\"https://www.oschina.net/img/hot3.png\" align=\"\" style=\"max-height: 32px; max-width: 32px;\"></p>\r\n </div>\r\n <p>web-flash使用的Spring Boot从1.5.1升级到2.1.1</p><p>下面为升级过程</p><ul class=\" list-paddingleft-2\"><li><p>版本升级</p><pre><spring.boot.version>2.1.1.RELEASE</spring.boot.version>\r\n<springframework.version>5.1.3.RELEASE<springframework.version></pre></li><li><p>配置增加</p><pre>spring.main.allow-bean-definition-overriding=true\r\nspring.jpa.hibernate.use-new-id-generator-mappings=false</pre></li></ul><ul class=\" list-paddingleft-2\"><li><p>审计功能调整，调整后代码:</p><pre>@Configuration\r\npublic class UserIDAuditorConfig implements AuditorAware<Long> {\r\n @Override\r\n public Optional<Long> getCurrentAuditor() {\r\n ShiroUser shiroUser = ShiroKit.getUser();\r\n if(shiroUser!=null){\r\n return Optional.of(shiroUser.getId());\r\n }\r\n return null;\r\n }\r\n}</pre></li><li><p>repository调整</p></li><ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\"><li><p>之前的 delete(Long id)方法没有了，替换为：deleteById(Long id)</p></li><li><p>之前的 T findOne(Long id)方法没有了，替换为： </p><pre>Optional<T> optional = ***Repository.findById(id);\r\n if (optional.isPresent()) {\r\n return optional.get();\r\n }\r\n return null;</pre></li></ul><li><p>随着这次Spring Boot的升级也顺便做了一些其他内容的调整和重构</p></li><ul class=\" list-paddingleft-2\" style=\"list-style-type: square;\"><li><p>springframework也从4.3.5.RELEASE升级到5.1.3.RELEASE</p></li><li><p>为减小复杂度service去掉接口和实现类的结构，基础功能的service直接使用实现类；当然具体业务中如果有需求你也可以这没用</p></li><li><p>去掉了一些暂时用不到的maven依赖</p></li><li><p>完善了基础功能的审计功能(之前有介绍审计功能的实现翻番，后续会专门发一篇文档来说明审计功能在系统总的具体用法，当然聪明的你看代码就知道了)</p></li></ul></ul>\r\n </div>', 1, '1', 'web-flash 升级 Spring Boot 到 2.1.1 版本');
INSERT INTO `CMSArticle` VALUES (4, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:34:21', 'enilu.cn', 'H5通用官网系统', 2, '17', 'H5通用官网系统');
INSERT INTO `CMSArticle` VALUES (5, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:34:36', 'enilu.cn', 'H5通用论坛系统', 2, '18', 'H5通用论坛系统');
INSERT INTO `CMSArticle` VALUES (6, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:38:33', 'enilu.cn', '官网建设方案', 3, '19', '官网建设方案');
INSERT INTO `CMSArticle` VALUES (7, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:39:48', 'enilu.cn', '论坛建设方案', 3, '22', '论坛建设方案');
INSERT INTO `CMSArticle` VALUES (8, 1, '2019-03-09 16:24:58', 1, '2019-04-28 17:39:52', 'enilu.cn', '案例1', 4, '3', '案例1');
INSERT INTO `CMSArticle` VALUES (9, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:39:11', 'enilu.cn', '案例2', 4, '20', '案例2');
INSERT INTO `CMSArticle` VALUES (14, 1, '2019-03-09 16:24:58', 1, '2019-04-28 00:39:25', 'test5', '<p>aaaaa<img class=\"wscnph\" src=\"http://127.0.0.1:8082/file/download?idFile=12\" /></p>', 4, '21', 'IDEA的代码生成插件发布啦');
INSERT INTO `CMSArticle` VALUES (15, 1, '2019-04-28 17:39:52', 1, '2019-05-05 15:36:57', 'enilu', '<p><img class=\"wscnph\" src=\"http://127.0.0.1:8082/file/download?idFile=24\" /></p>', 1, '25', '程序员头冷');
-- ----------------------------
-- Table structure for CMSBanner
-- ----------------------------
DROP TABLE IF EXISTS `CMSBanner`;
CREATE TABLE `CMSBanner` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`IdFile` bigint(0) NULL DEFAULT NULL COMMENT 'banner图id',
`Title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`Type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
`Url` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '点击banner跳转到url',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of CMSBanner
-- ----------------------------
INSERT INTO `CMSBanner` VALUES (1, 1, '2019-03-09 16:29:03', NULL, NULL, 1, '不打开链接', 'index', 'javascript:');
INSERT INTO `CMSBanner` VALUES (2, 1, '2019-03-09 16:29:03', NULL, NULL, 2, '打打开站内链接', 'index', '/contact');
INSERT INTO `CMSBanner` VALUES (3, 1, '2019-03-09 16:29:03', NULL, NULL, 6, '打开外部链接', 'index', 'http://www.baidu.com');
INSERT INTO `CMSBanner` VALUES (4, 1, '2019-03-09 16:29:03', NULL, NULL, 1, '不打开链接', 'product', 'javascript:');
INSERT INTO `CMSBanner` VALUES (5, 1, '2019-03-09 16:29:03', NULL, NULL, 2, '打打开站内链接', 'product', '/contact');
INSERT INTO `CMSBanner` VALUES (6, 1, '2019-03-09 16:29:03', NULL, NULL, 6, '打开外部链接', 'product', 'http://www.baidu.com');
INSERT INTO `CMSBanner` VALUES (7, 1, '2019-03-09 16:29:03', NULL, NULL, 1, '不打开链接', 'solution', 'javascript:');
INSERT INTO `CMSBanner` VALUES (8, 1, '2019-03-09 16:29:03', NULL, NULL, 2, '打打开站内链接', 'solution', '/contact');
INSERT INTO `CMSBanner` VALUES (9, 1, '2019-03-09 16:29:03', NULL, NULL, 6, '打开外部链接', 'solution', 'http://www.baidu.com');
INSERT INTO `CMSBanner` VALUES (10, 1, '2019-03-09 16:29:03', NULL, NULL, 1, '不打开链接', 'case', 'javascript:');
INSERT INTO `CMSBanner` VALUES (11, 1, '2019-03-09 16:29:03', NULL, NULL, 2, '打打开站内链接', 'case', '/contact');
INSERT INTO `CMSBanner` VALUES (12, 1, '2019-03-09 16:29:03', NULL, NULL, 6, '打开外部链接', 'case', 'http://www.baidu.com');
INSERT INTO `CMSBanner` VALUES (14, 1, '2019-03-09 16:29:03', NULL, NULL, 1, '不打开链接', 'news', 'javascript:');
INSERT INTO `CMSBanner` VALUES (15, 1, '2019-03-09 16:29:03', NULL, NULL, 2, '打打开站内链接', 'news', '/contact');
INSERT INTO `CMSBanner` VALUES (16, 1, '2019-03-09 16:29:03', NULL, NULL, 6, '打开外部链接', 'news', 'http://www.baidu.com');
-- ----------------------------
-- Table structure for CMSChannel
-- ----------------------------
DROP TABLE IF EXISTS `CMSChannel`;
CREATE TABLE `CMSChannel` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
`Name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章栏目' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of CMSChannel
-- ----------------------------
INSERT INTO `CMSChannel` VALUES (1, NULL, NULL, 1, '2019-03-13 22:52:46', 'news', '动态资讯');
INSERT INTO `CMSChannel` VALUES (2, NULL, NULL, 1, '2019-03-13 22:53:11', 'product', '产品服务');
INSERT INTO `CMSChannel` VALUES (3, NULL, NULL, 1, '2019-03-13 22:53:37', 'solution', '解决方案');
INSERT INTO `CMSChannel` VALUES (4, NULL, NULL, 1, '2019-03-13 22:53:41', 'case', '精选案例');
-- ----------------------------
-- Table structure for CMSContacts
-- ----------------------------
DROP TABLE IF EXISTS `CMSContacts`;
CREATE TABLE `CMSContacts` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Email` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
`Mobile` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`Remark` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`UserName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邀约人名称',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '邀约信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of CMSContacts
-- ----------------------------
INSERT INTO `CMSContacts` VALUES (1, NULL, '2019-07-31 17:44:27', NULL, '2019-07-31 17:44:27', 'test@qq.com', '15011111111', '测试联系，哈哈哈', '张三');
-- ----------------------------
-- Table structure for Message
-- ----------------------------
DROP TABLE IF EXISTS `Message`;
CREATE TABLE `Message` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '消息内容',
`Receiver` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收者',
`State` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型,0:初始,1:成功,2:失败',
`TplCode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板编码',
`Type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '历史消息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of Message
-- ----------------------------
INSERT INTO `Message` VALUES (1, NULL, '2019-06-10 21:20:16', NULL, NULL, '【腾讯云】校验码1032，请于5分钟内完成验证，如非本人操作请忽略本短信。', '15021592814', '2', 'REGISTER_CODE', '0');
-- ----------------------------
-- Table structure for MessageSender
-- ----------------------------
DROP TABLE IF EXISTS `MessageSender`;
CREATE TABLE `MessageSender` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`ClassName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送类',
`Name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`TplCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '短信运营商模板编号',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息发送者' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of MessageSender
-- ----------------------------
INSERT INTO `MessageSender` VALUES (1, NULL, NULL, NULL, NULL, 'tencentSmsSender', ' 腾讯短信服务', NULL);
INSERT INTO `MessageSender` VALUES (2, NULL, NULL, NULL, NULL, 'defaultEmailSender', '默认邮件发送器', NULL);
-- ----------------------------
-- Table structure for MessageTemplate
-- ----------------------------
DROP TABLE IF EXISTS `MessageTemplate`;
CREATE TABLE `MessageTemplate` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
`Cond` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送条件',
`Content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`IDMessageSender` bigint(0) NOT NULL COMMENT '发送者id',
`Title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`Type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型,0:短信,1:邮件',
PRIMARY KEY (`ID`) USING BTREE,
INDEX `FK942sadqk5x9kbrwil0psyek3n`(`IDMessageSender`) USING BTREE,
CONSTRAINT `FK942sadqk5x9kbrwil0psyek3n` FOREIGN KEY (`IDMessageSender`) REFERENCES `MessageSender` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息模板' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of MessageTemplate
-- ----------------------------
INSERT INTO `MessageTemplate` VALUES (1, NULL, NULL, NULL, NULL, 'REGISTER_CODE', '注册页面，点击获取验证码', '【腾讯云】校验码{1}，请于5分钟内完成验证，如非本人操作请忽略本短信。', 1, '注册验证码', '0');
INSERT INTO `MessageTemplate` VALUES (2, NULL, NULL, NULL, NULL, 'EMAIL_TEST', '测试发送', '你好:{1},欢迎使用{2}', 2, '测试邮件', '1');
INSERT INTO `MessageTemplate` VALUES (3, NULL, NULL, NULL, NULL, 'EMAIL_HTML_TEMPLATE_TEST', '测试发送模板邮件', '你好<strong>${userName}</strong>欢迎使用<font color=\"red\">${appName}</font>,这是html模板邮件', 2, '测试发送模板邮件', '1');
-- ----------------------------
-- Table structure for SysCfg
-- ----------------------------
DROP TABLE IF EXISTS `SysCfg`;
CREATE TABLE `SysCfg` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`CfgDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
`CfgName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数名',
`CfgValue` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数值',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统参数' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysCfg
-- ----------------------------
INSERT INTO `SysCfg` VALUES (1, NULL, NULL, 1, '2019-04-15 21:36:07', '应用名称update by 2019-03-27 11:47:04', 'system.app.name', 'web-flash');
INSERT INTO `SysCfg` VALUES (2, NULL, NULL, 1, '2019-04-15 21:36:17', '系统默认上传文件路径', 'system.file.upload.path', '/data/web-flash/runtime/upload');
INSERT INTO `SysCfg` VALUES (3, NULL, NULL, 1, '2019-04-15 21:36:17', '腾讯sms接口appid', 'api.tencent.sms.appid', '1400219425');
INSERT INTO `SysCfg` VALUES (4, NULL, NULL, 1, '2019-04-15 21:36:17', '腾讯sms接口appkey', 'api.tencent.sms.appkey', '5f71ed5325f3b292946530a1773e997a');
INSERT INTO `SysCfg` VALUES (5, NULL, NULL, 1, '2019-04-15 21:36:17', '腾讯sms接口签名参数', 'api.tencent.sms.sign', '需要去申请咯');
-- ----------------------------
-- Table structure for SysDept
-- ----------------------------
DROP TABLE IF EXISTS `SysDept`;
CREATE TABLE `SysDept` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`FullName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Num` int(0) NULL DEFAULT NULL,
`Pid` bigint(0) NULL DEFAULT NULL,
`Pids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SimpleName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Version` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysDept
-- ----------------------------
INSERT INTO `SysDept` VALUES (24, NULL, NULL, NULL, NULL, '总公司', 1, 0, '[0],', '总公司', '', NULL);
INSERT INTO `SysDept` VALUES (25, NULL, NULL, NULL, NULL, '开发部', 2, 24, '[0],[24],', '开发部', '', NULL);
INSERT INTO `SysDept` VALUES (26, NULL, NULL, NULL, NULL, '运营部', 3, 24, '[0],[24],', '运营部', '', NULL);
INSERT INTO `SysDept` VALUES (27, NULL, NULL, NULL, NULL, '战略部', 4, 24, '[0],[24],', '战略部', '', NULL);
-- ----------------------------
-- Table structure for SysDict
-- ----------------------------
DROP TABLE IF EXISTS `SysDict`;
CREATE TABLE `SysDict` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Pid` bigint(0) NULL DEFAULT NULL,
`Tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 70 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysDict
-- ----------------------------
INSERT INTO `SysDict` VALUES (16, NULL, NULL, NULL, NULL, '状态', '0', 0, NULL);
INSERT INTO `SysDict` VALUES (17, NULL, NULL, NULL, NULL, '启用', '1', 16, NULL);
INSERT INTO `SysDict` VALUES (18, NULL, NULL, NULL, NULL, '禁用', '2', 16, NULL);
INSERT INTO `SysDict` VALUES (29, NULL, NULL, NULL, NULL, '性别', '0', 0, NULL);
INSERT INTO `SysDict` VALUES (30, NULL, NULL, NULL, NULL, '男', '1', 29, NULL);
INSERT INTO `SysDict` VALUES (31, NULL, NULL, NULL, NULL, '女', '2', 29, NULL);
INSERT INTO `SysDict` VALUES (35, NULL, NULL, NULL, NULL, '账号状态', '0', 0, NULL);
INSERT INTO `SysDict` VALUES (36, NULL, NULL, NULL, NULL, '启用', '1', 35, NULL);
INSERT INTO `SysDict` VALUES (37, NULL, NULL, NULL, NULL, '冻结', '2', 35, NULL);
INSERT INTO `SysDict` VALUES (38, NULL, NULL, NULL, NULL, '已删除', '3', 35, NULL);
INSERT INTO `SysDict` VALUES (53, NULL, NULL, NULL, NULL, '证件类型', '0', 0, NULL);
INSERT INTO `SysDict` VALUES (54, NULL, NULL, NULL, NULL, '身份证', '1', 53, NULL);
INSERT INTO `SysDict` VALUES (55, NULL, NULL, NULL, NULL, '护照', '2', 53, NULL);
INSERT INTO `SysDict` VALUES (68, 1, '2019-01-13 14:18:21', 1, '2019-01-13 14:18:21', '是否', '0', 0, NULL);
INSERT INTO `SysDict` VALUES (69, 1, '2019-01-13 14:18:21', 1, '2019-01-13 14:18:21', '是', '1', 68, NULL);
INSERT INTO `SysDict` VALUES (70, 1, '2019-01-13 14:18:21', 1, '2019-01-13 14:18:21', '否', '0', 68, NULL);
-- ----------------------------
-- Table structure for SysFileInfo
-- ----------------------------
DROP TABLE IF EXISTS `SysFileInfo`;
CREATE TABLE `SysFileInfo` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`OriginalFileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`RealFileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysFileInfo
-- ----------------------------
INSERT INTO `SysFileInfo` VALUES (1, 1, '2019-03-18 10:34:34', 1, '2019-03-18 10:34:34', 'banner1.png', '7e9ebc08-b194-4f85-8997-d97ccb0d2c2d.png');
INSERT INTO `SysFileInfo` VALUES (2, 1, '2019-03-18 10:54:04', 1, '2019-03-18 10:54:04', 'banner2.png', '756b9ca8-562f-4bf5-a577-190dcdd25c29.png');
INSERT INTO `SysFileInfo` VALUES (3, 1, '2019-03-18 20:09:59', 1, '2019-03-18 20:09:59', 'offcial_site.png', 'b0304e2b-0ee3-4966-ac9f-a075b13d4af6.png');
INSERT INTO `SysFileInfo` VALUES (4, 1, '2019-03-18 20:10:18', 1, '2019-03-18 20:10:18', 'bbs.png', '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png');
INSERT INTO `SysFileInfo` VALUES (5, 1, '2019-03-18 20:20:14', 1, '2019-03-18 20:20:14', 'product.png', '1f2b05e0-403a-41e0-94a2-465f0c986b78.png');
INSERT INTO `SysFileInfo` VALUES (6, 1, '2019-03-18 20:22:09', 1, '2019-03-18 20:22:09', 'profile.jpg', '40ead888-14d1-4e9f-abb3-5bfb056a966a.jpg');
INSERT INTO `SysFileInfo` VALUES (7, 1, '2019-03-20 09:05:54', 1, '2019-03-20 09:05:54', '2303938_1453211.png', '87b037da-b517-4007-a66e-ba7cc8cfd6ea.png');
INSERT INTO `SysFileInfo` VALUES (8, NULL, NULL, NULL, NULL, 'login.png', '26835cc4-059e-4900-aff5-a41f2ea6a61d.png');
INSERT INTO `SysFileInfo` VALUES (9, NULL, NULL, NULL, NULL, 'login.png', '7ec7553b-7c9e-44d9-b9c2-3d89b11cf842.png');
INSERT INTO `SysFileInfo` VALUES (10, NULL, NULL, NULL, NULL, 'login.png', '357c4aad-19fd-4600-9fb6-e62aafa3df25.png');
INSERT INTO `SysFileInfo` VALUES (11, NULL, NULL, NULL, NULL, 'index.png', '55dd582b-033e-440d-8e8d-c8d39d01f1bb.png');
INSERT INTO `SysFileInfo` VALUES (12, NULL, NULL, NULL, NULL, 'login.png', '70507c07-e8bc-492f-9f0a-00bf1c23e329.png');
INSERT INTO `SysFileInfo` VALUES (13, NULL, NULL, NULL, NULL, 'index.png', 'cd539518-d15a-4cda-a19f-251169f5d1a4.png');
INSERT INTO `SysFileInfo` VALUES (14, NULL, NULL, NULL, NULL, 'login.png', '194c8a38-be94-483c-8875-3c62a857ead7.png');
INSERT INTO `SysFileInfo` VALUES (15, NULL, NULL, NULL, NULL, 'index.png', '6a6cb215-d0a7-4574-a45e-5fa04dcfdf90.png');
INSERT INTO `SysFileInfo` VALUES (16, 1, '2019-03-21 19:37:50', NULL, NULL, '测试文档.doc', 'd9d77815-496f-475b-a0f8-1d6dcb86e6ab.doc');
INSERT INTO `SysFileInfo` VALUES (17, 1, '2019-04-28 00:34:09', NULL, NULL, '首页.png', 'd5aba978-f8af-45c5-b079-673decfbdf26.png');
INSERT INTO `SysFileInfo` VALUES (18, 1, '2019-04-28 00:34:34', NULL, NULL, '资讯.png', '7e07520d-5b73-4712-800b-16f88d133db2.png');
INSERT INTO `SysFileInfo` VALUES (19, 1, '2019-04-28 00:38:32', NULL, NULL, '产品服务.png', '99214651-8cb8-4488-b572-12c6aa21f30a.png');
INSERT INTO `SysFileInfo` VALUES (20, 1, '2019-04-28 00:39:09', NULL, NULL, '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png', '31fdc83e-7688-41f5-b153-b6816d5dfb06.png');
INSERT INTO `SysFileInfo` VALUES (21, 1, '2019-04-28 00:39:22', NULL, NULL, '67486aa5-500c-4993-87ad-7e1fbc90ac1a.png', 'ffaf0563-3115-477b-b31d-47a4e80a75eb.png');
INSERT INTO `SysFileInfo` VALUES (22, 1, '2019-04-28 00:39:47', NULL, NULL, '7e07520d-5b73-4712-800b-16f88d133db2.png', '8928e5d4-933a-4953-9507-f60b78e3ccee.png');
INSERT INTO `SysFileInfo` VALUES (23, NULL, '2019-04-28 17:34:31', NULL, NULL, '756b9ca8-562f-4bf5-a577-190dcdd25c29.png', '7d64ba36-adc4-4982-9ec2-8c68db68861b.png');
INSERT INTO `SysFileInfo` VALUES (24, NULL, '2019-04-28 17:39:43', NULL, NULL, 'timg.jpg', '6483eb26-775c-4fe2-81bf-8dd49ac9b6b1.jpg');
INSERT INTO `SysFileInfo` VALUES (25, 1, '2019-05-05 15:36:54', NULL, NULL, 'timg.jpg', '7fe918a2-c59a-4d17-ad77-f65dd4e163bf.jpg');
-- ----------------------------
-- Table structure for SysLoginLog
-- ----------------------------
DROP TABLE IF EXISTS `SysLoginLog`;
CREATE TABLE `SysLoginLog` (
`ID` int(0) NOT NULL AUTO_INCREMENT,
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`IP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`LoginName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`UserId` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysLoginLog
-- ----------------------------
INSERT INTO `SysLoginLog` VALUES (71, '2019-05-10 13:17:43', '127.0.0.1', '登录日志', NULL, '成功', 1);
INSERT INTO `SysLoginLog` VALUES (72, '2019-05-12 13:36:56', '127.0.0.1', '登录日志', NULL, '成功', 1);
-- ----------------------------
-- Table structure for SysMenu
-- ----------------------------
DROP TABLE IF EXISTS `SysMenu`;
CREATE TABLE `SysMenu` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',
`Component` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '組件配置',
`Hidden` bit(1) NULL DEFAULT NULL COMMENT '是否隐藏',
`Icon` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
`IsMenu` bit(1) NOT NULL COMMENT '是否是菜单1:菜单,0:按钮',
`IsOpen` bit(1) NULL DEFAULT NULL COMMENT '是否默认打开1:是,0:否',
`Levels` int(0) NOT NULL COMMENT '级别',
`Name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
`Num` int(0) NOT NULL COMMENT '顺序',
`PCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父菜单编号',
`PCodes` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '递归父级菜单编号',
`Status` bit(1) NOT NULL COMMENT '状态1:启用,0:禁用',
`Tips` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鼠标悬停提示信息',
`Url` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接',
PRIMARY KEY (`ID`) USING BTREE,
UNIQUE INDEX `UK_s37unj3gh67ujhk83lqva8i1t`(`Code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysMenu
-- ----------------------------
INSERT INTO `SysMenu` VALUES (1, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'system', 'layout', b'0', 'system', b'1', b'1', 1, '系统管理', 1, '0', '[0],', b'1', NULL, '/system');
INSERT INTO `SysMenu` VALUES (2, 1, '2019-07-31 22:04:30', 1, '2019-03-11 22:25:38', 'cms', 'layout', b'0', 'documentation', b'1', NULL, 1, 'CMS管理', 3, '0', '[0],', b'1', NULL, '/cms');
INSERT INTO `SysMenu` VALUES (3, 1, '2019-07-31 22:04:30', 1, '2019-06-02 10:09:09', 'operationMgr', 'layout', b'0', 'operation', b'1', NULL, 1, '运维管理', 2, '0', '[0],', b'1', NULL, '/optionMgr');
INSERT INTO `SysMenu` VALUES (4, 1, '2019-07-31 22:04:30', 1, '2019-04-16 18:59:15', 'mgr', 'views/system/user/index', b'0', 'user', b'1', NULL, 2, '用户管理', 1, 'system', '[0],[system],', b'1', NULL, '/mgr');
INSERT INTO `SysMenu` VALUES (5, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrAdd', NULL, b'0', NULL, b'0', NULL, 3, '添加用户', 1, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/add');
INSERT INTO `SysMenu` VALUES (6, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrEdit', NULL, b'0', NULL, b'0', NULL, 3, '修改用户', 2, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/edit');
INSERT INTO `SysMenu` VALUES (7, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrDelete', NULL, b'0', NULL, b'0', b'0', 3, '删除用户', 3, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/delete');
INSERT INTO `SysMenu` VALUES (8, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrReset', NULL, b'0', NULL, b'0', b'0', 3, '重置密码', 4, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/reset');
INSERT INTO `SysMenu` VALUES (9, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrFreeze', NULL, b'0', NULL, b'0', b'0', 3, '冻结用户', 5, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/freeze');
INSERT INTO `SysMenu` VALUES (10, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrUnfreeze', NULL, b'0', NULL, b'0', b'0', 3, '解除冻结用户', 6, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/unfreeze');
INSERT INTO `SysMenu` VALUES (11, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'mgrSetRole', NULL, b'0', NULL, b'0', b'0', 3, '分配角色', 7, 'mgr', '[0],[system],[mgr],', b'1', NULL, '/mgr/setRole');
INSERT INTO `SysMenu` VALUES (12, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'role', 'views/system/role/index', b'0', 'peoples', b'1', b'0', 2, '角色管理', 2, 'system', '[0],[system],', b'1', NULL, '/role');
INSERT INTO `SysMenu` VALUES (13, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'roleAdd', NULL, b'0', NULL, b'0', b'0', 3, '添加角色', 1, 'role', '[0],[system],[role],', b'1', NULL, '/role/add');
INSERT INTO `SysMenu` VALUES (14, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'roleEdit', NULL, b'0', NULL, b'0', b'0', 3, '修改角色', 2, 'role', '[0],[system],[role],', b'1', NULL, '/role/edit');
INSERT INTO `SysMenu` VALUES (15, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'roleDelete', NULL, b'0', NULL, b'0', b'0', 3, '删除角色', 3, 'role', '[0],[system],[role],', b'1', NULL, '/role/remove');
INSERT INTO `SysMenu` VALUES (16, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'roleSetAuthority', NULL, b'0', NULL, b'0', b'0', 3, '配置权限', 4, 'role', '[0],[system],[role],', b'1', NULL, '/role/setAuthority');
INSERT INTO `SysMenu` VALUES (17, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'menu', 'views/system/menu/index', b'0', 'menu', b'1', b'0', 2, '菜单管理', 4, 'system', '[0],[system],', b'1', NULL, '/menu');
INSERT INTO `SysMenu` VALUES (18, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'menuAdd', NULL, b'0', NULL, b'0', b'0', 3, '添加菜单', 1, 'menu', '[0],[system],[menu],', b'1', NULL, '/menu/add');
INSERT INTO `SysMenu` VALUES (19, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'menuEdit', NULL, b'0', NULL, b'0', b'0', 3, '修改菜单', 2, 'menu', '[0],[system],[menu],', b'1', NULL, '/menu/edit');
INSERT INTO `SysMenu` VALUES (20, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'menuDelete', NULL, b'0', NULL, b'0', b'0', 3, '删除菜单', 3, 'menu', '[0],[system],[menu],', b'1', NULL, '/menu/remove');
INSERT INTO `SysMenu` VALUES (21, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dept', 'views/system/dept/index', b'0', 'dept', b'1', NULL, 2, '部门管理', 3, 'system', '[0],[system],', b'1', NULL, '/dept');
INSERT INTO `SysMenu` VALUES (22, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dict', 'views/system/dict/index', b'0', 'dict', b'1', NULL, 2, '字典管理', 4, 'system', '[0],[system],', b'1', NULL, '/dict');
INSERT INTO `SysMenu` VALUES (23, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deptEdit', NULL, b'0', NULL, b'0', NULL, 3, '修改部门', 1, 'dept', '[0],[system],[dept],', b'1', NULL, '/dept/update');
INSERT INTO `SysMenu` VALUES (24, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deptDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除部门', 1, 'dept', '[0],[system],[dept],', b'1', NULL, '/dept/delete');
INSERT INTO `SysMenu` VALUES (25, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dictAdd', NULL, b'0', NULL, b'0', NULL, 3, '添加字典', 1, 'dict', '[0],[system],[dict],', b'1', NULL, '/dict/add');
INSERT INTO `SysMenu` VALUES (26, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dictEdit', NULL, b'0', NULL, b'0', NULL, 3, '修改字典', 1, 'dict', '[0],[system],[dict],', b'1', NULL, '/dict/update');
INSERT INTO `SysMenu` VALUES (27, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dictDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除字典', 1, 'dict', '[0],[system],[dict],', b'1', NULL, '/dict/delete');
INSERT INTO `SysMenu` VALUES (28, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deptList', NULL, b'0', NULL, b'0', NULL, 3, '部门列表', 5, 'dept', '[0],[system],[dept],', b'1', NULL, '/dept/list');
INSERT INTO `SysMenu` VALUES (29, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deptDetail', NULL, b'0', NULL, b'0', NULL, 3, '部门详情', 6, 'dept', '[0],[system],[dept],', b'1', NULL, '/dept/detail');
INSERT INTO `SysMenu` VALUES (30, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dictList', NULL, b'0', NULL, b'0', NULL, 3, '字典列表', 5, 'dict', '[0],[system],[dict],', b'1', NULL, '/dict/list');
INSERT INTO `SysMenu` VALUES (31, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'dictDetail', NULL, b'0', NULL, b'0', NULL, 3, '字典详情', 6, 'dict', '[0],[system],[dict],', b'1', NULL, '/dict/detail');
INSERT INTO `SysMenu` VALUES (32, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deptAdd', NULL, b'0', NULL, b'0', NULL, 3, '添加部门', 1, 'dept', '[0],[system],[dept],', b'1', NULL, '/dept/add');
INSERT INTO `SysMenu` VALUES (33, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'cfg', 'views/system/cfg/index', b'0', 'cfg', b'1', NULL, 2, '参数管理', 10, 'system', '[0],[system],', b'1', NULL, '/cfg');
INSERT INTO `SysMenu` VALUES (34, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'cfgAdd', NULL, b'0', NULL, b'0', NULL, 3, '添加系统参数', 1, 'cfg', '[0],[system],[cfg],', b'1', NULL, '/cfg/add');
INSERT INTO `SysMenu` VALUES (35, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'cfgEdit', NULL, b'0', NULL, b'0', NULL, 3, '修改系统参数', 2, 'cfg', '[0],[system],[cfg],', b'1', NULL, '/cfg/update');
INSERT INTO `SysMenu` VALUES (36, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'cfgDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除系统参数', 3, 'cfg', '[0],[system],[cfg],', b'1', NULL, '/cfg/delete');
INSERT INTO `SysMenu` VALUES (37, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'task', 'views/system/task/index', b'0', 'task', b'1', NULL, 2, '任务管理', 11, 'system', '[0],[system],', b'1', NULL, '/task');
INSERT INTO `SysMenu` VALUES (38, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'taskAdd', NULL, b'0', NULL, b'0', NULL, 3, '添加任务', 1, 'task', '[0],[system],[task],', b'1', NULL, '/task/add');
INSERT INTO `SysMenu` VALUES (39, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'taskEdit', NULL, b'0', NULL, b'0', NULL, 3, '修改任务', 2, 'task', '[0],[system],[task],', b'1', NULL, '/task/update');
INSERT INTO `SysMenu` VALUES (40, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'taskDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除任务', 3, 'task', '[0],[system],[task],', b'1', NULL, '/task/delete');
INSERT INTO `SysMenu` VALUES (41, 1, '2019-03-11 22:29:54', 1, '2019-03-11 22:29:54', 'channel', 'views/cms/channel/index', b'0', 'channel', b'1', NULL, 2, '栏目管理', 1, 'cms', '[0],[cms],', b'1', NULL, '/channel');
INSERT INTO `SysMenu` VALUES (42, 1, '2019-03-11 22:30:17', 1, '2019-03-11 22:30:17', 'article', 'views/cms/article/index', b'0', 'documentation', b'1', NULL, 2, '文章管理', 2, 'cms', '[0],[cms],', b'1', NULL, '/article');
INSERT INTO `SysMenu` VALUES (43, 1, '2019-03-11 22:30:52', 1, '2019-03-11 22:30:52', 'banner', 'views/cms/banner/index', b'0', 'banner', b'1', NULL, 2, 'banner管理', 3, 'cms', '[0],[cms],', b'1', NULL, '/banner');
INSERT INTO `SysMenu` VALUES (44, 1, '2019-03-18 19:45:37', 1, '2019-03-18 19:45:37', 'contacts', 'views/cms/contacts/index', b'0', 'contacts', b'1', NULL, 2, '邀约管理', 4, 'cms', '[0],[cms],', b'1', NULL, '/contacts');
INSERT INTO `SysMenu` VALUES (45, 1, '2019-03-19 10:25:05', 1, '2019-03-19 10:25:05', 'file', 'views/cms/file/index', b'0', 'file', b'1', NULL, 2, '文件管理', 5, 'cms', '[0],[cms],', b'1', NULL, '/fileMgr');
INSERT INTO `SysMenu` VALUES (46, 1, '2019-03-11 22:30:17', 1, '2019-03-11 22:30:17', 'editArticle', 'views/cms/article/edit.vue', b'0', 'articleEdit', b'1', NULL, 2, '新建文章', 1, 'cms', '[0],[cms],', b'1', NULL, '/cms/articleEdit');
INSERT INTO `SysMenu` VALUES (47, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'taskLog', 'views/system/taskLog/index', b'1', 'task', b'1', NULL, 2, '任务日志', 4, 'system', '[0],[system],', b'1', NULL, '/taskLog');
INSERT INTO `SysMenu` VALUES (48, 1, '2019-07-31 22:04:30', 1, '2019-06-02 10:25:31', 'log', 'views/operation/log/index', b'0', 'log', b'1', NULL, 2, '业务日志', 6, 'operationMgr', '[0],[operationMgr],', b'1', NULL, '/log');
INSERT INTO `SysMenu` VALUES (49, 1, '2019-07-31 22:04:30', 1, '2019-06-02 10:25:36', 'loginLog', 'views/operation/loginLog/index', b'0', 'logininfor', b'1', NULL, 2, '登录日志', 6, 'operationMgr', '[0],[operationMgr],', b'1', NULL, '/loginLog');
INSERT INTO `SysMenu` VALUES (50, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'logClear', NULL, b'0', NULL, b'0', NULL, 3, '清空日志', 3, 'log', '[0],[system],[log],', b'1', NULL, '/log/delLog');
INSERT INTO `SysMenu` VALUES (51, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'logDetail', NULL, b'0', NULL, b'0', NULL, 3, '日志详情', 3, 'log', '[0],[system],[log],', b'1', NULL, '/log/detail');
INSERT INTO `SysMenu` VALUES (52, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'loginLogClear', NULL, b'0', NULL, b'0', NULL, 3, '清空登录日志', 1, 'loginLog', '[0],[system],[loginLog],', b'1', NULL, '/loginLog/delLoginLog');
INSERT INTO `SysMenu` VALUES (53, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'loginLogList', NULL, b'0', NULL, b'0', NULL, 3, '登录日志列表', 2, 'loginLog', '[0],[system],[loginLog],', b'1', NULL, '/loginLog/list');
INSERT INTO `SysMenu` VALUES (54, 1, '2019-06-02 10:10:20', 1, '2019-06-02 10:10:20', 'druid', 'views/operation/druid/index', b'0', 'monitor', b'1', NULL, 2, '数据库管理', 1, 'operationMgr', '[0],[operationMgr],', b'1', NULL, '/druid');
INSERT INTO `SysMenu` VALUES (55, 1, '2019-06-02 10:10:20', 1, '2019-06-02 10:10:20', 'swagger', 'views/operation/api/index', b'0', 'swagger', b'1', NULL, 2, '接口文档', 2, 'operationMgr', '[0],[operationMgr],', b'1', NULL, '/swagger');
INSERT INTO `SysMenu` VALUES (56, 1, '2019-06-10 21:26:52', 1, '2019-06-10 21:26:52', 'messageMgr', 'layout', b'0', 'message', b'1', NULL, 1, '消息管理', 4, '0', '[0],', b'1', NULL, '/message');
INSERT INTO `SysMenu` VALUES (57, 1, '2019-06-10 21:27:34', 1, '2019-06-10 21:27:34', 'msg', 'views/message/message/index', b'0', 'message', b'1', NULL, 2, '历史消息', 1, 'messageMgr', '[0],[messageMgr],', b'1', NULL, '/history');
INSERT INTO `SysMenu` VALUES (58, 1, '2019-06-10 21:27:56', 1, '2019-06-10 21:27:56', 'msgTpl', 'views/message/template/index', b'0', 'template', b'1', NULL, 2, '消息模板', 2, 'messageMgr', '[0],[messageMgr],', b'1', NULL, '/template');
INSERT INTO `SysMenu` VALUES (59, 1, '2019-06-10 21:28:21', 1, '2019-06-10 21:28:21', 'msgSender', 'views/message/sender/index', b'0', 'sender', b'1', NULL, 2, '消息发送者', 3, 'messageMgr', '[0],[messageMgr],', b'1', NULL, '/sender');
INSERT INTO `SysMenu` VALUES (60, 1, '2019-06-10 21:28:21', 1, '2019-06-10 21:28:21', 'msgClear', NULL, b'0', NULL, b'1', NULL, 2, '清空历史消息', 3, 'messageMgr', '[0],[messageMgr],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (61, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'msgTplEdit', NULL, b'0', NULL, b'0', NULL, 3, '编辑消息模板', 1, 'msgTpl', '[0],[messageMgr],[msgTpl]', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (62, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'msgTplDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除消息模板', 2, 'msgTpl', '[0],[messageMgr],[msgTpl]', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (63, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'msgSenderEdit', NULL, b'0', NULL, b'0', NULL, 3, '编辑消息发送器', 1, 'msgSender', '[0],[messageMgr],[msgSender]', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (64, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'msgSenderDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除消息发送器', 2, 'msgSender', '[0],[messageMgr],[msgSender]', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (65, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'fileUpload', NULL, b'0', NULL, b'0', NULL, 3, '上传文件', 1, 'file', '[0],[cms],[file],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (66, 1, '2019-07-31 21:51:33', 1, '2019-07-31 21:51:33', 'bannerEdit', NULL, b'0', NULL, b'0', NULL, 3, '编辑banner', 1, 'banner', '[0],[cms],[banner],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (67, 1, '2019-07-31 21:51:33', 1, '2019-07-31 21:51:33', 'bannerDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除banner', 2, 'banner', '[0],[cms],[banner],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (68, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'channelEdit', NULL, b'0', NULL, b'0', NULL, 3, '编辑栏目', 1, 'channel', '[0],[cms],[channel],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (69, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'channelDelete', NULL, b'0', NULL, b'0', NULL, 3, '删除栏目', 2, 'channel', '[0],[cms],[channel],', b'1', NULL, NULL);
INSERT INTO `SysMenu` VALUES (70, 1, '2019-07-31 22:04:30', 1, '2019-07-31 22:04:30', 'deleteArticle', NULL, b'0', NULL, b'0', NULL, 3, '删除文章', 2, 'article', '[0],[cms],[article]', b'1', NULL, NULL);
-- ----------------------------
-- Table structure for SysNotice
-- ----------------------------
DROP TABLE IF EXISTS `SysNotice`;
CREATE TABLE `SysNotice` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL,
`CreateTime` datetime(0) NULL DEFAULT NULL,
`ModifyBy` bigint(0) NULL DEFAULT NULL,
`ModifyTime` datetime(0) NULL DEFAULT NULL,
`Content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Type` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysNotice
-- ----------------------------
INSERT INTO `SysNotice` VALUES (1, 1, '2017-01-11 08:53:20', 1, '2019-01-08 23:30:58', '欢迎使用XXX后台管理系统', '完美世界', 10);
-- ----------------------------
-- Table structure for SysOperationLog
-- ----------------------------
DROP TABLE IF EXISTS `SysOperationLog`;
CREATE TABLE `SysOperationLog` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`ClassName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateTime` datetime(0) NULL DEFAULT NULL,
`LogName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`LogType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详细信息',
`Method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`UserId` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for SysRelation
-- ----------------------------
DROP TABLE IF EXISTS `SysRelation`;
CREATE TABLE `SysRelation` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`MenuId` bigint(0) NULL DEFAULT NULL,
`RoleId` bigint(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 203 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单角色关系' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysRelation
-- ----------------------------
INSERT INTO `SysRelation` VALUES (1, 42, 1);
INSERT INTO `SysRelation` VALUES (2, 70, 1);
INSERT INTO `SysRelation` VALUES (3, 46, 1);
INSERT INTO `SysRelation` VALUES (4, 43, 1);
INSERT INTO `SysRelation` VALUES (5, 67, 1);
INSERT INTO `SysRelation` VALUES (6, 66, 1);
INSERT INTO `SysRelation` VALUES (7, 33, 1);
INSERT INTO `SysRelation` VALUES (8, 34, 1);
INSERT INTO `SysRelation` VALUES (9, 36, 1);
INSERT INTO `SysRelation` VALUES (10, 35, 1);
INSERT INTO `SysRelation` VALUES (11, 41, 1);
INSERT INTO `SysRelation` VALUES (12, 69, 1);
INSERT INTO `SysRelation` VALUES (13, 68, 1);
INSERT INTO `SysRelation` VALUES (14, 2, 1);
INSERT INTO `SysRelation` VALUES (15, 44, 1);
INSERT INTO `SysRelation` VALUES (16, 21, 1);
INSERT INTO `SysRelation` VALUES (17, 32, 1);
INSERT INTO `SysRelation` VALUES (18, 24, 1);
INSERT INTO `SysRelation` VALUES (19, 29, 1);
INSERT INTO `SysRelation` VALUES (20, 23, 1);
INSERT INTO `SysRelation` VALUES (21, 28, 1);
INSERT INTO `SysRelation` VALUES (22, 22, 1);
INSERT INTO `SysRelation` VALUES (23, 25, 1);
INSERT INTO `SysRelation` VALUES (24, 27, 1);
INSERT INTO `SysRelation` VALUES (25, 31, 1);
INSERT INTO `SysRelation` VALUES (26, 26, 1);
INSERT INTO `SysRelation` VALUES (27, 30, 1);
INSERT INTO `SysRelation` VALUES (28, 54, 1);
INSERT INTO `SysRelation` VALUES (29, 45, 1);
INSERT INTO `SysRelation` VALUES (30, 65, 1);
INSERT INTO `SysRelation` VALUES (31, 48, 1);
INSERT INTO `SysRelation` VALUES (32, 50, 1);
INSERT INTO `SysRelation` VALUES (33, 51, 1);
INSERT INTO `SysRelation` VALUES (34, 49, 1);
INSERT INTO `SysRelation` VALUES (35, 52, 1);
INSERT INTO `SysRelation` VALUES (36, 53, 1);
INSERT INTO `SysRelation` VALUES (37, 17, 1);
INSERT INTO `SysRelation` VALUES (38, 18, 1);
INSERT INTO `SysRelation` VALUES (39, 20, 1);
INSERT INTO `SysRelation` VALUES (40, 19, 1);
INSERT INTO `SysRelation` VALUES (41, 56, 1);
INSERT INTO `SysRelation` VALUES (42, 4, 1);
INSERT INTO `SysRelation` VALUES (43, 5, 1);
INSERT INTO `SysRelation` VALUES (44, 7, 1);
INSERT INTO `SysRelation` VALUES (45, 6, 1);
INSERT INTO `SysRelation` VALUES (46, 9, 1);
INSERT INTO `SysRelation` VALUES (47, 8, 1);
INSERT INTO `SysRelation` VALUES (48, 11, 1);
INSERT INTO `SysRelation` VALUES (49, 10, 1);
INSERT INTO `SysRelation` VALUES (50, 57, 1);
INSERT INTO `SysRelation` VALUES (51, 60, 1);
INSERT INTO `SysRelation` VALUES (52, 59, 1);
INSERT INTO `SysRelation` VALUES (53, 64, 1);
INSERT INTO `SysRelation` VALUES (54, 63, 1);
INSERT INTO `SysRelation` VALUES (55, 58, 1);
INSERT INTO `SysRelation` VALUES (56, 62, 1);
INSERT INTO `SysRelation` VALUES (57, 61, 1);
INSERT INTO `SysRelation` VALUES (58, 3, 1);
INSERT INTO `SysRelation` VALUES (59, 12, 1);
INSERT INTO `SysRelation` VALUES (60, 13, 1);
INSERT INTO `SysRelation` VALUES (61, 15, 1);
INSERT INTO `SysRelation` VALUES (62, 14, 1);
INSERT INTO `SysRelation` VALUES (63, 16, 1);
INSERT INTO `SysRelation` VALUES (64, 55, 1);
INSERT INTO `SysRelation` VALUES (65, 1, 1);
INSERT INTO `SysRelation` VALUES (66, 37, 1);
INSERT INTO `SysRelation` VALUES (67, 38, 1);
INSERT INTO `SysRelation` VALUES (68, 40, 1);
INSERT INTO `SysRelation` VALUES (69, 39, 1);
INSERT INTO `SysRelation` VALUES (70, 47, 1);
INSERT INTO `SysRelation` VALUES (166, 2, 3);
INSERT INTO `SysRelation` VALUES (167, 41, 3);
INSERT INTO `SysRelation` VALUES (168, 68, 3);
INSERT INTO `SysRelation` VALUES (169, 69, 3);
INSERT INTO `SysRelation` VALUES (170, 42, 3);
INSERT INTO `SysRelation` VALUES (171, 70, 3);
INSERT INTO `SysRelation` VALUES (172, 43, 3);
INSERT INTO `SysRelation` VALUES (173, 66, 3);
INSERT INTO `SysRelation` VALUES (174, 67, 3);
INSERT INTO `SysRelation` VALUES (175, 44, 3);
INSERT INTO `SysRelation` VALUES (176, 45, 3);
INSERT INTO `SysRelation` VALUES (177, 65, 3);
INSERT INTO `SysRelation` VALUES (178, 46, 3);
INSERT INTO `SysRelation` VALUES (179, 3, 3);
INSERT INTO `SysRelation` VALUES (180, 48, 3);
INSERT INTO `SysRelation` VALUES (181, 50, 3);
INSERT INTO `SysRelation` VALUES (182, 51, 3);
INSERT INTO `SysRelation` VALUES (183, 49, 3);
INSERT INTO `SysRelation` VALUES (184, 52, 3);
INSERT INTO `SysRelation` VALUES (185, 53, 3);
INSERT INTO `SysRelation` VALUES (186, 54, 3);
INSERT INTO `SysRelation` VALUES (187, 55, 3);
INSERT INTO `SysRelation` VALUES (188, 1, 2);
INSERT INTO `SysRelation` VALUES (189, 21, 2);
INSERT INTO `SysRelation` VALUES (190, 28, 2);
INSERT INTO `SysRelation` VALUES (191, 2, 2);
INSERT INTO `SysRelation` VALUES (192, 41, 2);
INSERT INTO `SysRelation` VALUES (193, 68, 2);
INSERT INTO `SysRelation` VALUES (194, 69, 2);
INSERT INTO `SysRelation` VALUES (195, 42, 2);
INSERT INTO `SysRelation` VALUES (196, 70, 2);
INSERT INTO `SysRelation` VALUES (197, 43, 2);
INSERT INTO `SysRelation` VALUES (198, 66, 2);
INSERT INTO `SysRelation` VALUES (199, 67, 2);
INSERT INTO `SysRelation` VALUES (200, 44, 2);
INSERT INTO `SysRelation` VALUES (201, 45, 2);
INSERT INTO `SysRelation` VALUES (202, 65, 2);
INSERT INTO `SysRelation` VALUES (203, 46, 2);
-- ----------------------------
-- Table structure for SysRole
-- ----------------------------
DROP TABLE IF EXISTS `SysRole`;
CREATE TABLE `SysRole` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`DeptId` bigint(0) NULL DEFAULT NULL,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Num` int(0) NULL DEFAULT NULL,
`Pid` bigint(0) NULL DEFAULT NULL,
`Tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Version` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysRole
-- ----------------------------
INSERT INTO `SysRole` VALUES (1, NULL, NULL, NULL, NULL, 24, '超级管理员', 1, 0, 'administrator', 1);
INSERT INTO `SysRole` VALUES (2, NULL, NULL, NULL, NULL, NULL, '网站管理员', 2, NULL, 'developer', NULL);
-- ----------------------------
-- Table structure for SysTask
-- ----------------------------
DROP TABLE IF EXISTS `SysTask`;
CREATE TABLE `SysTask` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Concurrent` bit(1) NULL DEFAULT NULL COMMENT '是否允许并发',
`Cron` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时规则',
`Data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '执行参数',
`Disabled` bit(1) NULL DEFAULT NULL COMMENT '是否禁用',
`ExecAt` datetime(0) NULL DEFAULT NULL COMMENT '执行时间',
`ExecResult` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '执行结果',
`JobClass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行类',
`JobGroup` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务组名',
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名',
`Note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务说明',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysTask
-- ----------------------------
INSERT INTO `SysTask` VALUES (1, 1, '2018-12-28 09:54:00', -1, '2019-03-27 11:47:11', b'0', '0 0/30 * * * ?', '{\n\"appname\": \"web-flash\",\n\"version\":1\n}\n \n \n \n \n \n \n \n \n \n \n \n ', b'0', '2019-03-27 11:47:00', '执行成功', 'cn.enilu.flash.service.task.job.HelloJob', 'default', '测试任务', '测试任务,每30分钟执行一次');
-- ----------------------------
-- Table structure for SysTaskLog
-- ----------------------------
DROP TABLE IF EXISTS `SysTaskLog`;
CREATE TABLE `SysTaskLog` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`ExecAt` datetime(0) NULL DEFAULT NULL COMMENT '执行时间',
`ExecSuccess` bit(1) NULL DEFAULT NULL COMMENT '执行结果（成功:1、失败:0)',
`IdTask` bigint(0) NULL DEFAULT NULL,
`JobException` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抛出异常',
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名',
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务日志' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for SysUser
-- ----------------------------
DROP TABLE IF EXISTS `SysUser`;
CREATE TABLE `SysUser` (
`ID` bigint(0) NOT NULL AUTO_INCREMENT,
`CreateBy` bigint(0) NULL DEFAULT NULL COMMENT '创建人',
`CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间/注册时间',
`ModifyBy` bigint(0) NULL DEFAULT NULL COMMENT '最后更新人',
`ModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '最后更新时间',
`Account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账户',
`Avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Birthday` datetime(0) NULL DEFAULT NULL,
`DeptId` bigint(0) NULL DEFAULT NULL,
`Email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'email',
`Name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`Password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`Phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`RoleId` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id列表，以逗号分隔',
`Salt` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码盐',
`Sex` int(0) NULL DEFAULT NULL,
`Status` int(0) NULL DEFAULT NULL,
`Version` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '账号' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of SysUser
-- ----------------------------
INSERT INTO `SysUser` VALUES (-1, NULL, NULL, NULL, NULL, 'system', NULL, NULL, NULL, NULL, '应用系统', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `SysUser` VALUES (1, NULL, '2016-01-29 08:49:53', 1, '2019-03-20 23:45:24', 'admin', NULL, '2017-05-05 00:00:00', 27, 'eniluzt@qq.com', '管理员', 'FB62D394677DA9592EF3C2BEDE9F1B2D', '15021222222', '1', '8pgby', 2, 1, 25);
INSERT INTO `SysUser` VALUES (2, NULL, '2018-09-13 17:21:02', 1, '2019-01-09 23:05:51', 'developer', NULL, '2017-12-31 00:00:00', 25, 'eniluzt@qq.com', '网站管理员', 'fac36d5616fe9ebd460691264b28ee27', '15022222222', '2,', 'vscp9', 1, 1, NULL);
INSERT INTO `SysUser` VALUES (3, 1, '2020-03-03 21:43:51', 1, '2020-03-07 21:01:08', 'guokun', NULL, NULL, 25, '184494760@qq.com', '郭坤', '9EA2580E4BE4D8D577012AB469C75C82', NULL, '2,', 'vailr', 1, 1, NULL);
INSERT INTO `SysUser` VALUES (4, 1, '2020-03-05 21:12:18', 1, '2020-03-05 21:29:20', 'test', NULL, '2020-03-25 00:00:00', 26, '12321@qq.com', '测试1', '008FB100979084A4EA9436099C38FD08', NULL, '2,3,', 'd6m3r', 1, 3, NULL);
SET FOREIGN_KEY_CHECKS = 1;