/* Navicat Premium Data Transfer Source Server : v4-120.25.146.52-fusion-test Source Server Type : MySQL Source Server Version : 50736 Source Host : 120.25.146.52:13306 Source Schema : fd_fusion Target Server Type : MySQL Target Server Version : 50736 File Encoding : 65001 Date: 29/04/2025 15:40:33 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_common_upload -- ---------------------------- DROP TABLE IF EXISTS `t_common_upload`; CREATE TABLE `t_common_upload` ( `id` int(11) NOT NULL AUTO_INCREMENT, `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `new_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `file_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `result_file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` int(11) NULL DEFAULT 0, `unzip_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `file_type` int(11) NULL DEFAULT NULL, `wgs84` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `gcj02` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_common_upload -- ---------------------------- INSERT INTO `t_common_upload` VALUES (1, 'Man', 'https://4dkk.4dage.com/fusion/default/model/glb/man.glb', '3303348', 'Man', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (2, 'Hammer2', 'https://4dkk.4dage.com/fusion/default/model/glb/hammer2.glb', '284844', 'Hammer2', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (3, 'Gun', 'https://4dkk.4dage.com/fusion/default/model/glb/gun.glb', '248080', 'Gun', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (4, 'Kid', 'https://4dkk.4dage.com/fusion/default/model/glb/kid.glb', '2636492', 'Kid', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (5, 'Hammer1', 'https://4dkk.4dage.com/fusion/default/model/glb/hammer1.glb', '2113100', 'Hammer1', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (6, 'Knife', 'https://4dkk.4dage.com/fusion/default/model/glb/knife.glb', '1008742', 'Knife', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (7, 'Machinegun', 'https://4dkk.4dage.com/fusion/default/model/glb/machinegun.glb', '111104', 'Machinegun', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); INSERT INTO `t_common_upload` VALUES (8, 'Baseballbat', 'https://4dkk.4dage.com/fusion/default/model/glb/baseballbat.glb', '259276', 'Baseballbat', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2025-04-29 15:38:51', 1, NULL, 3, NULL, NULL, 'animation'); -- ---------------------------- -- Table structure for t_dict -- ---------------------------- DROP TABLE IF EXISTS `t_dict`; CREATE TABLE `t_dict` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sort` int(11) NULL DEFAULT 1, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sys_user_id` int(11) NULL DEFAULT NULL, `parent_id` int(11) NULL DEFAULT NULL, `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_dict -- ---------------------------- INSERT INTO `t_dict` VALUES (1, '动画模型', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-03-28 10:00:04', 1, NULL, 'animation'); -- ---------------------------- -- Table structure for t_dict_file -- ---------------------------- DROP TABLE IF EXISTS `t_dict_file`; CREATE TABLE `t_dict_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `type_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dict_id` int(11) NULL DEFAULT NULL, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sys_user_id` int(11) NULL DEFAULT NULL, `upload_id` int(11) NULL DEFAULT NULL, `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_dict_file -- ---------------------------- INSERT INTO `t_dict_file` VALUES (1, 'Man', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-03-28 10:00:04', 1, 1, 'animation'); INSERT INTO `t_dict_file` VALUES (2, 'Hammer2', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:48', 1, 2, 'animation'); INSERT INTO `t_dict_file` VALUES (3, 'Gun', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:48', 1, 3, 'animation'); INSERT INTO `t_dict_file` VALUES (4, 'Kid', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:49', 1, 4, 'animation'); INSERT INTO `t_dict_file` VALUES (5, 'Hammer1', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:50', 1, 5, 'animation'); INSERT INTO `t_dict_file` VALUES (6, 'Knife', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:50', 1, 6, 'animation'); INSERT INTO `t_dict_file` VALUES (7, 'Machinegun', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:51', 1, 7, 'animation'); INSERT INTO `t_dict_file` VALUES (8, 'Baseballbat', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-04-11 10:29:51', 1, 8, 'animation'); SET FOREIGN_KEY_CHECKS = 1; ALTER TABLE `fd_fusion`.`t_dict_file` ADD COLUMN `hash_url` varchar(255) NULL AFTER `use_type`, ADD COLUMN `down_url` varchar(255) NULL AFTER `hash_url`;