yvjia/db/__sys_file_category.sql

# /**
# 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',
#     `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(category_name, suffix) VALUES
#     ('图片', 'jpg, jpeg, png, gif, bmp, tiff, webp'),
#     ('视频', 'mp4, avi, mov, mkv, wmv, flv, webm'),
#     ('音频', 'mp3, wav, ogg, aac')
# ;