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
| -- DROP DATABASE IF EXISTS `se-cloud`;
|
| CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
| SET NAMES utf8mb4;
| SET FOREIGN_KEY_CHECKS = 0;
|
| USE `se-cloud`;
|
| -- ----------------------------
| -- 01、分系统任务控制表
| -- ----------------------------
| drop table if exists sys_task_ctrl;
| create table sys_task_ctrl (
| task_id bigint(20) not null auto_increment comment '任务ID',
| task_name varchar(200) comment '任务名称',
| prj_id varchar(50) comment '方案ID',
| prj_name varchar(200) comment '方案名称',
| think_id varchar(50) comment '想定ID',
| think_name varchar(200) comment '想定名称',
| begin_time varchar(50) comment '开始时间',
| end_time varchar(50) comment '结束时间',
| calc_node varchar(2000) comment '计算节点',
| is_save char(1) default 0 comment '是否保存（0正常 1停用）',
| status char(1) default 0 comment '状态（0正常 1停用）',
| create_by varchar(64) default '' comment '创建者',
| create_time datetime comment '创建时间',
| update_by varchar(64) default '' comment '更新者',
| update_time datetime comment '更新时间',
| remark varchar(500) default '' comment '备注',
| unique (think_id),
| primary key (task_id)
| ) engine=innodb auto_increment=1 comment = '分系统任务控制表';
| select * from sys_task_ctrl order by task_id;
|
| -- 菜单 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制', '1', '10', 'taskCtrl', 'system/taskCtrl/index', 1, 0, 'C', '0', '0', 'system:taskCtrl:list', '#', 'admin', sysdate(), '', null, '分系统任务控制菜单');
|
| -- 按钮父菜单ID
| SELECT @parentId := LAST_INSERT_ID();
|
| -- 按钮 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制查询', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:query', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制新增', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:add', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制修改', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:edit', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制删除', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:remove', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('分系统任务控制导出', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:taskCtrl:export', '#', 'admin', sysdate(), '', null, '');
|
| update sys_menu set mark = 'sys' where menu_id >= @parentId;
| -- ----------------------------
| -- 02、系统状态监控表
| -- ----------------------------
| drop table if exists sys_status_ctrl;
| create table sys_status_ctrl (
| status_id bigint(20) not null auto_increment comment '状态ID',
| sys_name varchar(200) comment '名称',
| ip varchar(50) comment 'IP',
| url varchar(4000) comment 'URL',
| method varchar(20) comment '请求方法',
| order_num int default 0 comment '显示顺序',
| status char(1) default 0 comment '状态（0正常 1停用）',
| create_by varchar(64) default '' comment '创建者',
| create_time datetime comment '创建时间',
| update_by varchar(64) default '' comment '更新者',
| update_time datetime comment '更新时间',
| remark varchar(500) default '' comment '备注',
| primary key (status_id)
| ) engine=innodb auto_increment=1 comment = '系统状态监控表';
| select * from sys_status_ctrl order by status_id;
|
| insert into sys_status_ctrl (sys_name, ip, url, method, order_num) values ('分系统01', '127.0.0.1', 'http://localhost:8080/system/health', 'GET', 1);
|
| -- 菜单 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控', '1', '9', 'statusCtrl', 'system/statusCtrl/index', 1, 0, 'C', '0', '0', 'system:statusCtrl:list', '#', 'admin', sysdate(), '', null, '系统状态监控菜单');
|
| -- 按钮父菜单ID
| SELECT @parentId := LAST_INSERT_ID();
|
| -- 按钮 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控查询', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:query', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控新增', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:add', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控修改', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:edit', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控删除', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:remove', '#', 'admin', sysdate(), '', null, '');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('系统状态监控导出', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:statusCtrl:export', '#', 'admin', sysdate(), '', null, '');
|
| update sys_menu set mark = 'sys' where menu_id >= @parentId;
|
| insert into sys_status_ctrl (sys_name,ip,url,method,order_num) values ('用户及权限管理','127.0.0.1','http://localhost:8080/system/health', 'GET',1);
| insert into sys_status_ctrl (sys_name,ip,url,method,order_num) values ('数据管理分系统','127.0.0.1','http://localhost:8080/gateway/health','GET',2);
|
| -- ----------------------------
| -- 03、分系统任务控制表
| -- ----------------------------
| drop table if exists sys_app_token;
| create table sys_app_token (
| id bigint(20) not null auto_increment comment 'ID',
| app_name varchar(200) comment '系统名称',
| token varchar(50) comment '令牌',
| expire_time datetime comment '失效时间',
| role_name varchar(20) default 'readonly' comment '角色名称',
| status char(1) default 0 comment '状态（0正常 1停用）',
| create_by varchar(64) default '' comment '创建者',
| create_time datetime comment '创建时间',
| update_by varchar(64) default '' comment '更新者',
| update_time datetime comment '更新时间',
| remark varchar(500) comment '备注',
| primary key (id)
| ) engine=innodb auto_increment=1 comment = '外接应用表';
| select * from sys_app_token order by id; -- select * from sys_role;
|
| insert into sys_app_token (app_name, token, expire_time, role_name, create_by, create_time) values ('综合管理分系统', uuid(), '2027-01-01 00:00:00', 'superuser', 'admin', now()); -- 1801411200000
|
| -- 菜单 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| values('外接应用', '3', '1', 'token', 'system/token/index', 1, 0, 'M', '0', '0', 'system:token:list', '#', 'admin', sysdate(), '', null, '外接应用');
|
| -- 按钮父菜单ID
| SELECT @parentId := LAST_INSERT_ID();
|
| -- 按钮 SQL
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
| values('外接应用查询', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:token:query', '#', 'admin', sysdate(), '', null, '', 'sys');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
| values('外接应用新增', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:token:add', '#', 'admin', sysdate(), '', null, '', 'sys');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
| values('外接应用修改', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:token:edit', '#', 'admin', sysdate(), '', null, '', 'sys');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remar, markk)
| values('外接应用删除', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:token:remove', '#', 'admin', sysdate(), '', null, '', 'sys');
|
| insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
| values('外接应用导出', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:token:export', '#', 'admin', sysdate(), '', null, '', 'sys');
| -- ----------------------------
|
|
