CompetitionAPI_dotnet/uplaod_file.sql

37 lines
1.3 KiB
SQL

/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1
Source Server Type : MySQL
Source Server Version : 80011
Source Host : localhost:3306
Source Schema : competition_db
Target Server Type : MySQL
Target Server Version : 80011
File Encoding : 65001
Date: 29/11/2024 15:24:07
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for uplaod_file
-- ----------------------------
DROP TABLE IF EXISTS `uplaod_file`;
CREATE TABLE `uplaod_file` (
`FileId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件Id',
`FileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
`FilePath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径',
PRIMARY KEY (`FileId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of uplaod_file
-- ----------------------------
INSERT INTO `uplaod_file` VALUES ('c07ad05792174b229cf8af1c849b1fdd', '安全合规性照片(全身照)', '~/UploadFile/c07ad05792174b229cf8af1c849b1fdd001.jpg');
SET FOREIGN_KEY_CHECKS = 1;