From 874dd8d939b4ae61efbb799855c9ddf328722972 Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期三, 25 十二月 2024 18:08:08 +0800 Subject: [PATCH] Merge branch 'master' of http://dlindusit.com:53929/r/iailab-plat --- iailab-module-model/iailab-module-model-biz/db/mysql.sql | 18 +++++++++++++----- 1 files changed, 13 insertions(+), 5 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 59662c5..0d9da47 100644 --- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql +++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql @@ -66,7 +66,7 @@ id varchar(36) not null, modelid varchar(36), `key` varchar(36), - value varchar(256), + value varchar(1000), name varchar(36), valuetype varchar(36), primary key (id), @@ -115,7 +115,7 @@ ( id varchar(36) not null, itemid varchar(36), - expression varchar(255), + expression varchar(1000), num integer, primary key (id), UNIQUE INDEX uk_itemid (itemid) @@ -236,6 +236,7 @@ create table t_mm_predict_alarm_message ( id varchar(36) not null, + config_id varchar(36) COMMENT '配置ID', title varchar(36) COMMENT '消息标题', content varchar(128) COMMENT '消息内容', alarm_obj varchar(36) COMMENT '监控对象', @@ -250,6 +251,7 @@ create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', primary key (id), INDEX idx_item_id (item_id), + INDEX idx_config_id (config_id), INDEX idx_alarm_obj (alarm_obj), INDEX idx_alarm_time (alarm_time) ) engine = innodb @@ -636,7 +638,7 @@ `method_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '方法id', `setting_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数名称', - `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数默认值', + `value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数默认值', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '输入类型', `value_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数类型', `max` int NULL DEFAULT NULL COMMENT '最大值', @@ -707,7 +709,7 @@ `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径', `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本号', `log` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新日志', - `model_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称(“,”分割)', + `model_names` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称(“,”分割)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`, `project_id`) USING BTREE, INDEX `del_package_history`(`project_id` ASC) USING BTREE, @@ -873,4 +875,10 @@ INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1629, 2, 'double[][]', '2', 'model_result_type', 0, '', '', '', '141', '2024-11-11 15:21:17', '141', '2024-11-11 15:21:17', b'0'); -alter table t_mm_item_output add column `result_name` varchar(50) DEFAULT NULL; \ No newline at end of file +alter table t_mm_item_output add column `result_name` varchar(50) DEFAULT NULL; + + +alter table t_st_schedule_scheme add column `mpkprojectid` varchar(36) DEFAULT NULL; + +alter table t_st_schedule_record add column `result_code` varchar(10) DEFAULT NULL; +alter table t_st_schedule_record add column `result_data` varchar(1000) DEFAULT NULL; \ No newline at end of file -- Gitblit v1.9.3