yvjia/db/b2c_good_category.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/07/17 10:24:20
*/

DROP TABLE IF EXISTS `b2c_good_category`;
CREATE TABLE `b2c_good_category` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '商品分类状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商品分类表';

INSERT INTO b2c_good_category(parent_id, sort) VALUES
    (-1, 5),
    (-1, 4),
    (-1, 3),
    (-1, 2),
    (-1, 1)
;