• Home
• com.github.rexsheng
• springboot-faster-system
• 1.1.6
• source code
• 1.1.5.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.patch.1.1.5.sql Maven / Gradle / Ivy

DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE IF NOT EXISTS `sys_file` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `business_type` varchar(50) DEFAULT NULL COMMENT '业务类型',
    `business_id` varchar(200) DEFAULT NULL COMMENT '业务id',
    `service` varchar(50) DEFAULT NULL COMMENT '文件服务类型',
    `bucket` varchar(50) DEFAULT NULL COMMENT '文件存储桶',
    `key` varchar(500) DEFAULT NULL COMMENT '文件存储key',
    `name` varchar(500) DEFAULT NULL COMMENT '文件名称',
    `original_name` varchar(500) DEFAULT NULL COMMENT '文件原始名称',
    `size` bigint(20) DEFAULT NULL COMMENT '文件大小',
    `is_del` tinyint(1) DEFAULT NULL COMMENT '是否删除(0未删除，1已删除)',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    `update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`),
    KEY `idx_business` (`business_type`,`business_id`,`is_del`) COMMENT '按所属业务查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件表';