From 9cfbabe0cbe096cfd1343d5bd6540bc47e01836a Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期一, 09 九月 2024 15:09:53 +0800
Subject: [PATCH] 修复查询问题

---
 iailab-module-model/iailab-module-model-biz/db/mysql.sql |   15 ++++++++-------
 1 files changed, 8 insertions(+), 7 deletions(-)

diff --git a/iailab-module-model/iailab-module-model-biz/db/mysql.sql b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
index e9e34e7..fd22ec0 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -271,17 +271,17 @@
   `create_time`       datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `updater`           varchar(64) NULL     DEFAULT '' COMMENT '更新者',
   `update_time`       datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
+  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
   primary key (id),
   UNIQUE INDEX `uk_code` (`code` ASC) USING BTREE
 ) engine = innodb
   default character set utf8mb4 COMMENT = '调度方案表';
 
-
 create table t_st_schedule_model
 (
   `id`              varchar(36) not null COMMENT 'ID',
-  `model_code`      varchar(64) COMMENT '编号',
-  `model_name`      varchar(64) COMMENT '名称',
+  `model_code`      varchar(64) COMMENT '模型编号',
+  `model_name`      varchar(64) COMMENT '模型名称',
   `model_type`      varchar(64) COMMENT '模型类型',
   `class_name`      varchar(128) COMMENT '类名',
   `method_name`     varchar(64) COMMENT '方法名',
@@ -295,10 +295,10 @@
   `create_time`     datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `updater`         varchar(64) NULL     DEFAULT '' COMMENT '更新者',
   `update_time`     datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
+  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
   primary key (id),
   UNIQUE INDEX `uk_model_code` (`model_code` ASC) USING BTREE
-) engine = innodb
-  default character set utf8mb4 COMMENT = '调度模型表';
+) engine = innodb default character set utf8mb4 COMMENT = '调度模型表';
 
 create table
   t_st_schedule_model_param
@@ -325,13 +325,14 @@
   `value`     varchar(64),
   `valuetype` varchar(64),
   `name`      varchar(64),
+  `sort`      integer,
   primary key (id),
   key idx_modelid (modelid)
 ) engine = innodb
   default character set utf8mb4 COMMENT = '调度模型设置参数表';
 
 create table
-  t_st_schedule_scheme_suggest
+  t_st_schedule_suggest
 (
   id                varchar(36) not null,
   title             varchar(50) COMMENT '标题',
@@ -372,7 +373,7 @@
   `id`            varchar(36) not null,
   `scheme_id`     varchar(36) COMMENT '方案ID',
   `model_id`      varchar(36) COMMENT '模型ID',
-  `model_name`    varchar(64) COMMENT '名称',
+  `model_name`    varchar(64) COMMENT '模型名称',
   `schedule_time` datetime COMMENT '调度时间',
   `create_time`   datetime default current_timestamp COMMENT '创建时间',
   primary key (id),

--
Gitblit v1.9.3