From 5b634f6178976d3add7ea774405d2eac51226dfd Mon Sep 17 00:00:00 2001
From: dongyukun <1208714201@qq.com>
Date: 星期二, 05 十一月 2024 18:33:35 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 29 ++++++++++++++++++++++++++++-
1 files changed, 28 insertions(+), 1 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 7763dd3..05c9225 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -628,4 +628,31 @@
`name` varchar(36) NOT NULL COMMENT '名称',
`sort` integer DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;
\ No newline at end of file
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;
+
+alter table t_mm_predict_model add column `mpkprojectid` varchar(36) DEFAULT NULL;
+
+CREATE TABLE `t_chart` (
+ `id` varchar(36) NOT NULL,
+ `chart_name` varchar(100) DEFAULT NULL COMMENT '图表名称',
+ `chart_code` varchar(100) DEFAULT NULL COMMENT '图表编码',
+ `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
+ `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `uk_chart_code` (`chart_code`),
+ KEY `index_id` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+CREATE TABLE `t_chart_param` (
+ `id` varchar(36) NOT NULL,
+ `chart_id` varchar(36) NOT NULL COMMENT '图表id',
+ `param_name` varchar(255) DEFAULT NULL COMMENT '参数名称',
+ `param_code` varchar(100) DEFAULT NULL COMMENT '参数编码',
+ `param_value` varchar(1000) DEFAULT NULL COMMENT '参数值',
+ `remark` varchar(255) DEFAULT NULL COMMENT '备注',
+ `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
+ `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
+ PRIMARY KEY (`id`,`chart_id`) USING BTREE,
+ KEY `index_chart_id` (`chart_id`),
+ CONSTRAINT `chart_id` FOREIGN KEY (`chart_id`) REFERENCES `t_chart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
\ No newline at end of file
--
Gitblit v1.9.3