CREATE DATABASE IF NOT EXISTS `file_center` DEFAULT CHARACTER SET = utf8;
|
Use `file_center`;
|
|
-- ----------------------------
|
-- Table structure for file_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `file_info`;
|
CREATE TABLE `file_info` (
|
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件md5',
|
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
`is_img` tinyint(1) NOT NULL,
|
`content_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
`size` int(11) NOT NULL,
|
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物理路径',
|
`url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
`source` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
`create_time` datetime(0) NULL DEFAULT NULL,
|
`update_time` datetime(0) NULL DEFAULT NULL,
|
`tenant_id` varchar(32) DEFAULT '' COMMENT '租户字段',
|
PRIMARY KEY (`id`),
|
KEY `idx_create_time` (`create_time`),
|
KEY `idx_tenant_id` (`tenant_id`)
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of file_info
|
-- ----------------------------
|
INSERT INTO `file_info` VALUES ('2c95b54f4d8356cf8ab40802f496df83', '头像.png', 1, 'image/png', 1290, 'http://kidgrow.com/头像.png', 'http://kidgrow.com/头像.png', 'QINIU', '2019-01-08 17:05:36', '2019-01-08 17:05:36', 'webApp');
|
