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=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `t_case_path` (
                               `id` int NOT NULL AUTO_INCREMENT,
                               `case_id` int DEFAULT NULL,
                               `path` 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=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


UPDATE t_case_tag set hot_icon_id = 18 WHERE hot_icon_id = 1;