kgraph_backgrand/sql/update20230602.sql

use kgraph;

DROP TABLE IF EXISTS `t_check_piont`;
CREATE TABLE `t_check_piont`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '序号',
  `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '编码',
  `check_piont` varchar(1023) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '检查点',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '检查点管理' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `t_build_flow`;
CREATE TABLE `t_build_flow`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '序号',
  `sub_task_id` bigint NULL DEFAULT NULL COMMENT '子任务id',
  `error_appearance` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '故障现象',
  `error_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '故障编码',
  `flow_encode` varchar(1023) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '排故流程数据编码',
  `flow_tree_json` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '流程树json',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '构建流程' ROW_FORMAT = Dynamic;