yvjia/db/cms_article_category.sql

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

DROP TABLE IF EXISTS `cms_article_category`;

CREATE TABLE `cms_article_category` (
    PRIMARY KEY (`id`),
    `id` BIGINT(10) AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT(10) DEFAULT '-1' COMMENT '父ID',
    `category_name` VARCHAR(100) NOT NULL COMMENT '资讯分类名称',
    `category_description` VARCHAR(500) COMMENT '资讯分类描述',
    `sort` BIGINT(10) DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '资讯状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='资讯分类表';

INSERT INTO cms_article_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, 'K5', 'kkkkkkkkk', 10),
        (1, 'K6', 'kkkkkkkkk', 11),
        (1, 'K7', 'kkkkkkkkk', 12),
        (1, 'K8', 'kkkkkkkkk', 13),
        (1, 'K9', 'kkkkkkkkk', 14),
        (1, 'K10', 'kkkkkkkkk', 15),
    (-1, '健康生活', '提升生活质量的健康指南', 4),
        (13, 'J1', 'jjjjjj', 3),
    (-1, '情感关系', '为你解析情感与人际关系', 3),
    (-1, '旅行探索', '探索世界各地的旅行分享', 2),
    (-1, '美食烹饪', '养眼美食与烹饪技巧', 1)
;