From 13e53d2f872a2ad3f119434bd1bc4946a141e224 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期四, 12 九月 2024 14:48:33 +0800
Subject: [PATCH] MDK

---
 iailab-module-model/iailab-module-model-biz/db/mysql.sql |   23 ++++++++++++-----------
 1 files changed, 12 insertions(+), 11 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..e0c8110 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -256,8 +256,8 @@
 create table t_st_schedule_scheme
 (
   `id`                varchar(36) not null COMMENT 'ID',
-  `code`              varchar(20) COMMENT '编号',
-  `name`              varchar(20) COMMENT '名称',
+  `code`              varchar(20) not null COMMENT '编号',
+  `name`              varchar(20) not null COMMENT '名称',
   `trigger_method`    varchar(20) COMMENT '触发方式',
   `trigger_condition` varchar(20) COMMENT '触发条件',
   `schedule_obj`      varchar(20) COMMENT '调整对象',
@@ -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) not null COMMENT '模型编号',
+  `model_name`      varchar(64) not null COMMENT '模型名称',
   `model_type`      varchar(64) COMMENT '模型类型',
   `class_name`      varchar(128) COMMENT '类名',
   `method_name`     varchar(64) COMMENT '方法名',
@@ -295,16 +295,16 @@
   `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
 (
   id                  varchar(36) not null,
-  modelid             varchar(64),
+  modelid             varchar(64) not null,
   modelparamname      varchar(64),
   modelparamid        varchar(64),
   modelparamorder     integer,
@@ -320,18 +320,19 @@
   t_st_schedule_model_setting
 (
   `id`        varchar(36) not null,
-  `modelid`   varchar(64),
+  `modelid`   varchar(64) not null,
   `key`       varchar(64),
   `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