yvjia/db/cms_navigation_i18n.sql

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

DROP TABLE IF EXISTS `cms_navigation_i18n`;
CREATE TABLE `cms_navigation_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `navigation_id` BIGINT NOT NULL COMMENT '导航ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `navigation_name` VARCHAR(255) NOT NULL COMMENT '菜单名称',
    `link` VARCHAR(1000) COMMENT '链接'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='导航翻译表';

INSERT INTO cms_navigation_i18n(navigation_id, language, navigation_name, link) VALUES
    (1, 'zh', '首页', '/'),
    (1, 'en', 'Home', '/'),
    (2, 'zh', '关于我们', '/pages/about'),
    (2, 'en', 'About', '/pages/about'),
    (3, 'zh', '资讯中心', '/article/list'),
    (3, 'en', 'Article', '/article/list'),
    (3, 'zh', '联系我们', '/pages/concat'),
    (3, 'en', 'Concat us', '/pages/concat')
;