From db9f34881bfb372892823fcd403f3d833a4ecdfe Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 14 七月 2025 14:18:13 +0800
Subject: [PATCH] Merge branch 'master' of http://192.168.11.205:9000/r/se-cloud
---
docker-compose/mysql/initdb/se_cloud_20241204.sql | 105 ++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 101 insertions(+), 4 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
index 96764e5..2a23bea 100644
--- a/docker-compose/mysql/initdb/se_cloud_20241204.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20241204.sql
@@ -13,23 +13,50 @@
drop table if exists sys_task_ctrl;
create table sys_task_ctrl (
task_id bigint(20) not null auto_increment comment '浠诲姟ID',
- prj_id varchar(50) comment '浠诲姟ID',
- prj_name varchar(200) comment '浠诲姟鍚嶇О',
+ 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鍋滅敤锛�',
- node varchar(2000) 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 '澶囨敞',
+ 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, '鍒嗙郴缁熶换鍔℃帶鍒惰彍鍗�');
+-- 鎸夐挳鐖惰彍鍗旾D
+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銆佺郴缁熺姸鎬佺洃鎺ц〃
-- ----------------------------
@@ -53,6 +80,76 @@
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, '绯荤粺鐘舵�佺洃鎺ц彍鍗�');
+
+-- 鎸夐挳鐖惰彍鍗旾D
+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, '澶栨帴搴旂敤');
+
+-- 鎸夐挳鐖惰彍鍗旾D
+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');
+-- ----------------------------
--
Gitblit v1.9.3