yvjia/db/b2c_good_category_i18n.sql

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

DROP TABLE IF EXISTS `b2c_good_category_i18n`;
CREATE TABLE `b2c_good_category_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `good_category_id` BIGINT NOT NULL COMMENT '分类ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `category_name` VARCHAR(100) NOT NULL COMMENT '商品分类名称',
    `category_description` VARCHAR(500) COMMENT '商品分类描述'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商品分类表';

INSERT INTO b2c_good_category_i18n(good_category_id, language, category_name, category_description) VALUES
    (1, 'zh', '电子产品', '手机、电脑、平板等电子设备'),
    (1, 'en', 'Electronics', 'Mobile phones, computers, tablets and other electronic devices'),
    (2, 'zh', '家具', '床、沙发、餐桌等家居用品'),
    (2, 'en', 'Furniture', 'Beds, sofas, dining tables and other household items'),
    (3, 'zh', '食品', '食品、零食、饮料等食品类产品'),
    (3, 'en', 'Food', 'Food, snacks, beverages and other food products'),
    (4, 'zh', '服装', '包括衣服、鞋子、配饰等服装类产品'),
    (4, 'en', 'Apparel', 'Clothing, shoes, accessories and other apparel products'),
    (5, 'zh', '美容', '化妆品、护肤品、美发用品等美容类产品'),
    (5, 'en', 'Beauty', 'Cosmetics, skincare, hair care products and other beauty items')
;