yvjia/db/med_material_category.sql

-- /**
-- Source Server Version: 8.0.31
-- Source Database: backendsys
-- Date: 2023/05/23 17:09:22
-- */
--
-- DROP TABLE IF EXISTS `med_material_category`;
-- CREATE TABLE `med_material_category` (
--     PRIMARY KEY (`id`),
--     `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
--     `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
--     `category_name` VARCHAR(100) NOT NULL COMMENT '素材分类名称',
--     `category_description` VARCHAR(500) 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 med_material_category(parent_id, category_name, category_description, sort) VALUES
--     (-1, '推荐', '推荐素材', 5),
--         (1, 'K1', 'kkkkkkkkk', 1),
--             (2, 'K1-1', 'kkkkkkkkk', 1),
--         (1, 'K2', 'kkkkkkkkk', 7),
--         (1, 'K3', 'kkkkkkkkk', 8),
--         (1, 'K4', 'kkkkkkkkk', 9),
--     (-1, '精选', '精选素材', 4),
--         (7, 'J1', 'jjjjjj', 3),
--     (-1, '人气', '人气素材', 3)
-- ;
--