1234567891011121314151617181920212223242526272829 |
- CREATE DATABASE IF NOT EXISTS `mics_file_center` DEFAULT CHARACTER SET = utf8;
- Use `mics_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://pkqtmn0p1.bkt.clouddn.com/头像.png', 'http://pkqtmn0p1.bkt.clouddn.com/头像.png', 'QINIU', '2019-01-08 17:05:36', '2019-01-08 17:05:36', 'webApp');
|