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',
    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `category_name` VARCHAR(255) NOT NULL COMMENT '分类名称',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '资讯状态 (-1禁用, 1启用)',
    INDEX `idx_sort` (`sort`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统文件分类表';

INSERT INTO sys_file_category(user_id, category_name, sort) VALUES
    (1, '图片', 3),
    (1, '视频', 2),
    (1, '音频', 1),
    (2, '音频', 4)
;