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

ALTER TABLE `fd_fusion`.`t_fusion_guide_path`
    ADD COLUMN `play_animation` int NULL AFTER `pano_info`;

CREATE TABLE `t_case_animation` (
                                    `id` int NOT NULL AUTO_INCREMENT,
                                    `case_id` int DEFAULT NULL,
                                    `title` text COLLATE utf8mb4_general_ci,
                                    `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
                                    `show_title` int DEFAULT NULL COMMENT '0否，1是',
                                    `font_size` int DEFAULT NULL,
                                    `global_visibility` int DEFAULT NULL COMMENT '0否，1是',
                                    `visibility_range` int DEFAULT NULL,
                                    `frames` text COLLATE utf8mb4_general_ci,
                                    `actions` text COLLATE utf8mb4_general_ci,
                                    `subtitles` text COLLATE utf8mb4_general_ci,
                                    `paths` text COLLATE utf8mb4_general_ci,
                                    `mat` text COLLATE utf8mb4_general_ci,
                                    `tb_status` int DEFAULT '0',
                                    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                    `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


ALTER TABLE `fd_fusion`.`t_fusion_guide`
    ADD COLUMN `show_taggings` int NULL AFTER `recovery_content`,
ADD COLUMN `show_measure` int NULL AFTER `show_taggings`,
ADD COLUMN `show_monitor` int NULL AFTER `show_measure`,
ADD COLUMN `show_path` int NULL AFTER `show_monitor`;



ALTER TABLE `4dkankan_v4`.`t_dict`
    ADD COLUMN `use_type` varchar(255) NULL DEFAULT 'ordinary' AFTER `parent_id`;

ALTER TABLE `4dkankan_v4`.`t_common_upload`
    ADD COLUMN `use_type` varchar(255) NULL DEFAULT 'ordinary' AFTER `gcj02`;

ALTER TABLE `4dkankan_v4`.`t_dict_file`
    ADD COLUMN `use_type` varchar(255) NULL DEFAULT 'ordinary' AFTER `upload_id`;


ALTER TABLE `fd_fusion`.`t_case_tag_point`
    ADD COLUMN `pose` varchar(255) NULL AFTER `normal`;

ALTER TABLE `fd_fusion`.`t_case_tag_point`
    MODIFY COLUMN `pose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL AFTER `normal`;


CREATE TABLE `jy_user_file` (
                                `id` int NOT NULL AUTO_INCREMENT,
                                `sys_user_id` int DEFAULT NULL,
                                `file_url` varchar(255) DEFAULT NULL,
                                `files_title` varchar(255) DEFAULT NULL,
                                `img_type` int DEFAULT NULL,
                                `content` text,
                                `rec_status` varchar(255) DEFAULT 'A',
                                `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;