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 |   15 +++++++++++----
 1 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
index 531f55e..115d76d 100644
--- a/docker-compose/mysql/initdb/se_cloud_20241204.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20241204.sql
@@ -13,18 +13,22 @@
 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姝e父 1鍋滅敤锛�',
-  node              varchar(2000)                              comment '鑺傜偣',  
   status            char(1)         default 0                  comment '鐘舵�侊紙0姝e父 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;
@@ -100,5 +104,8 @@
 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