yvjia/db/b2c_goods_brand.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/08/18 12:51:10
*/

DROP TABLE IF EXISTS `b2c_goods_brand`;
CREATE TABLE `b2c_goods_brand` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT COMMENT '父ID',
    `brand_name` VARCHAR(100) 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 b2c_goods_brand(brand_name, sort) VALUES
    ('小米', 5),
    ('三星', 5),
    ('Nike', 5),
    ('Chanel', 5),
    ('Coca-Cola', 5),
    ('Apple', 5),
    ('Adidas', 5),
    ('Louis Vuitton', 5),
    ('Huawei', 5),
    ('Gucci', 5),
    ('Puma', 5),
    ('Starbucks', 5)
;