yvjia/db/b2c_good_i18n.sql

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

DROP TABLE IF EXISTS `b2c_good_i18n`;
CREATE TABLE `b2c_good_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `good_id` BIGINT NOT NULL COMMENT '商品ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `good_name` VARCHAR(20) NOT NULL COMMENT '商品名称',
    `good_description` VARCHAR(200) COMMENT '商品描述',
    `good_content` TEXT COMMENT '商品内容',
    `meta_keyword` VARCHAR(100) COMMENT 'SEO-Keyword',
    `meta_description` VARCHAR(200) COMMENT 'SEO-Description',
    INDEX `idx_good_name` (`good_name`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商品表 (翻译)';

INSERT INTO b2c_good_i18n(good_id, language, good_name, good_description, good_content) VALUES
    (1, 'zh', '测试商品-1', '测试商品描述描述-1', '测试商品详情内容内容内容内容-1'),
    (1, 'en', 'Debug Good-1', 'Debug Good description-1', 'Debug Good content-1'),
    (2, 'zh', '测试商品-2', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (2, 'en', 'Debug Good-2', 'Debug Good description', 'Debug Good content'),
    (3, 'zh', '测试商品-3', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (3, 'en', 'Debug Good-3', 'Debug Good description', 'Debug Good content'),
    (4, 'zh', '测试商品-4', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (4, 'en', 'Debug Good-4', 'Debug Good description', 'Debug Good content'),
    (5, 'zh', '测试商品-5', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (5, 'en', 'Debug Good-5', 'Debug Good description', 'Debug Good content'),
    (6, 'zh', '测试商品-6', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (6, 'en', 'Debug Good-6', 'Debug Good description', 'Debug Good content'),
    (7, 'zh', '测试商品-7', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (7, 'en', 'Debug Good-7', 'Debug Good description', 'Debug Good content'),
    (8, 'zh', '测试商品-8', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (8, 'en', 'Debug Good-8', 'Debug Good description', 'Debug Good content'),
    (9, 'zh', '测试商品-9', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (9, 'en', 'Debug Good-9', 'Debug Good description', 'Debug Good content'),
    (10, 'zh', '测试商品-10', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (10, 'en', 'Debug Good-10', 'Debug Good description', 'Debug Good content'),
    (11, 'zh', '测试商品-11', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (11, 'en', 'Debug Good-11', 'Debug Good description', 'Debug Good content'),
    (12, 'zh', '测试商品-12', '测试商品描述描述', '测试商品详情内容内容内容内容'),
    (12, 'en', 'Debug Good-12', 'Debug Good description', 'Debug Good content')
;