4dkankan-fusion/doc/v1.9.0/fusion-1.9.0.sql

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;




CREATE TABLE `t_dict` (
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `dict_name` varchar(255) DEFAULT NULL,
                          `dict_key` varchar(255) DEFAULT NULL,
                          `sort` int(11) DEFAULT '1',
                          `rec_status` varchar(255) DEFAULT 'A',
                          `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                          `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                          `sys_user_id` varchar(255) DEFAULT NULL,
                          `parent_id` int(11) DEFAULT NULL,
                          `use_type` varchar(255) DEFAULT 'ordinary',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;


CREATE TABLE `t_dict_file` (
                               `id` int(11) NOT NULL AUTO_INCREMENT,
                               `name` varchar(255) DEFAULT NULL,
                               `type_key` varchar(255) DEFAULT NULL,
                               `dict_id` int(11) DEFAULT NULL,
                               `rec_status` varchar(255) DEFAULT 'A',
                               `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                               `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                               `sys_user_id` varchar(255) DEFAULT NULL,
                               `upload_id` int(11) DEFAULT NULL,
                               `use_type` varchar(255) DEFAULT 'ordinary',
                               PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;



CREATE TABLE `t_common_upload` (
                                   `id` int(11) NOT NULL AUTO_INCREMENT,
                                   `file_name` varchar(255) DEFAULT NULL,
                                   `file_url` varchar(255) DEFAULT NULL,
                                   `file_size` varchar(255) DEFAULT NULL,
                                   `new_file_name` varchar(255) DEFAULT NULL,
                                   `file_type_str` varchar(255) DEFAULT NULL,
                                   `file_format` varchar(255) DEFAULT NULL,
                                   `result_file_format` varchar(255) DEFAULT NULL,
                                   `rec_status` varchar(255) DEFAULT 'A',
                                   `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                   `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                   `status` int(11) DEFAULT '0',
                                   `unzip_path` varchar(255) DEFAULT NULL,
                                   `file_type` int(11) DEFAULT NULL,
                                   `wgs84` varchar(255) DEFAULT NULL,
                                   `gcj02` varchar(255) DEFAULT NULL,
                                   `use_type` varchar(255) DEFAULT 'ordinary',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;