/**
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(10) AUTO_INCREMENT COMMENT 'ID',
    `article_category_id` BIGINT(10) 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, 'en', 'Technological Innovation', 'Frontier Technology and Innovation Trends'),
    (2, 'zh', '健康生活', '为你解析情感与人际关系'),
    (2, 'zh', 'Healthy life', 'For you to analyze emotions and relationships'),
    (3, 'zh', '情感关系', '为你解析情感与人际关系'),
    (3, 'en', 'Emotional Relationships', 'Analyze Emotions and Interpersonal Relationships'),
    (4, 'zh', '旅行探索', '探索世界各地的旅行分享'),
    (4, 'en', 'Travel Exploration', 'Discover Travel Experiences from Around the World'),
    (5, 'zh', '美食烹饪', '养眼美食与烹饪技巧'),
    (5, 'en', 'Culinary Delights', 'Eye-pleasing Dishes and Cooking Techniques')
;

