yvjia/db/cms_article_category_i18n.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `cms_article_category_i18n`;
CREATE TABLE `cms_article_category_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `article_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 cms_article_category_i18n (article_category_id, language, category_name, category_description) VALUES
    (1, 'zh', '科技创新', '前沿科技与创新动态'),
    (1, 'zh-tw', '科技創新', '前沿科技與創新動態'),
    (1, 'en', 'Technological Innovation', 'Frontier Technology and Innovation Trends'),
    (2, 'zh', '健康生活', '为你解析情感与人际关系'),
    (2, 'zh-tw', '健康生活', '為你解析情感與人際關係'),
    (2, 'en', 'Healthy life', 'For you to analyze emotions and relationships'),
    (3, 'zh', '情感关系', '为你解析情感与人际关系'),
    (3, 'zh-tw', '情感關係', '為你解析情感與人際關係'),
    (3, 'en', 'Emotional Relationships', 'Analyze Emotions and Interpersonal Relationships'),
    (4, 'zh', '旅行探索', '探索世界各地的旅行分享'),
    (4, 'zh-tw', '旅行探索', '探索世界各地的旅行分享'),
    (4, 'en', 'Travel Exploration', 'Discover Travel Experiences from Around the World'),
    (5, 'zh', '美食烹饪', '养眼美食与烹饪技巧'),
    (5, 'zh-tw', '美食烹飪', '養眼美食與烹飪技巧'),
    (5, 'en', 'Culinary Delights', 'Eye-pleasing Dishes and Cooking Techniques')
;