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

/*
 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`;