From d2cbc715156a231d449108746b36ede97306d9ab Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 13 十二月 2024 20:41:43 +0800
Subject: [PATCH] 1
---
docker-compose/mysql/initdb/se_cloud_20241204.sql | 61 ++++++++++++++++++++++++++++--
1 files changed, 57 insertions(+), 4 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
index 7f2b926..115d76d 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,32 @@
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);
-- ----------------------------
-
+
--
Gitblit v1.9.3