4dkankan-fusion/doc/update-1.7.4.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_case_overview
-- ----------------------------
DROP TABLE IF EXISTS `t_case_overview`;
CREATE TABLE `t_case_overview`  (
                                    `id` int NOT NULL AUTO_INCREMENT,
                                    `case_id` int NULL DEFAULT NULL,
                                    `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                    `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                    `store` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据',
                                    `viewport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视口',
                                    `type` int NULL DEFAULT 0,
                                    `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                    `tb_status` int NULL DEFAULT 0,
                                    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                    `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                    `high` int NULL DEFAULT NULL,
                                    `width` int NULL DEFAULT NULL,
                                    `list_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 179 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_case_tabulation
-- ----------------------------
DROP TABLE IF EXISTS `t_case_tabulation`;
CREATE TABLE `t_case_tabulation`  (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `case_id` int NULL DEFAULT NULL,
                                      `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                      `store` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据',
                                      `viewport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视口',
                                      `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
                                      `paper_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '纸张',
                                      `is_auto_gen` int NULL DEFAULT NULL,
                                      `tb_status` int NULL DEFAULT 0,
                                      `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                      `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                      `overview_id` int NULL DEFAULT NULL,
                                      `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                      `high` int NULL DEFAULT NULL,
                                      `width` int NULL DEFAULT NULL,
                                      `list_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;




ALTER TABLE `fd_fusion`.`t_case_files`
    ADD COLUMN `overview_id` int NULL DEFAULT NULL AFTER `ogn_files_url`;

ALTER TABLE `fd_fusion`.`t_case_files`
    ADD COLUMN `tabulation_id` int NULL DEFAULT NULL AFTER `overview_id`;