/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/07/17 10:01:12
*/

DROP TABLE IF EXISTS `b2c_good_brand`;
CREATE TABLE `b2c_good_brand` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    `brand_name` VARCHAR(100) NOT NULL COMMENT '商品品牌名称',
    `brand_name_en` 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_good_brand(parent_id, brand_name, brand_name_en, sort) VALUES
    (-1, '优衣库', 'UNIQLO', 1),
    (-1, 'ZARA', 'ZARA', 2),
    (-1, 'H&M', 'H&M', 3),
    (-1, '耐克', 'Nike', 4),
        (4, 'Air Jordan', 'Air Jordan', 11),       -- 属于 Nike
        (4, 'Nike SB', 'Nike Skateboarding', 12),  -- 属于 Nike
    (-1, '阿迪达斯', 'Adidas', 5),
    (-1, '路易威登', 'Louis Vuitton', 6),
    (-1, '古驰', 'Gucci', 7),
    (-1, '香奈儿', 'Chanel', 8),
    (-1, '彪马', 'Puma', 9),
    (-1, '李宁', 'Li-Ning', 10),
    (-1, '安踏', 'ANTA', 11),
    (-1, '太平鸟', 'PEACEBIRD', 12),
    (-1, '杰克琼斯', 'Jack & Jones', 13),
    (-1, 'Only', 'Only', 14),
    (-1, 'Vero Moda', 'Vero Moda', 15),
    (-1, '森马', 'Semir', 16),
    (-1, '美特斯邦威', 'Meters/bonwe', 17),
    (-1, '海澜之家', 'HLA', 18),
    (-1, '七匹狼', 'Septwolves', 19),
    (-1, '波司登', 'Bosideng', 20)
;
