/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_file_category`;
CREATE TABLE `sys_file_category` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `category_name` VARCHAR(255) NOT NULL COMMENT '分类名称',
    `suffix` VARCHAR(1000) NOT NULL COMMENT '文件后缀',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '资讯状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统文件分类表';

INSERT INTO sys_file_category(user_id, category_name, suffix, sort) VALUES
    (1, '图片', 'jpg, jpeg, png, gif, bmp, tiff, webp', 3),
    (1, '视频', 'mp4, avi, mov, mkv, wmv, flv, webm', 2),
    (1, '音频', 'mp3, wav, ogg, aac', 1),
    (2, '音频', 'mp3, wav, ogg, aac', 4)
;