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(10) AUTO_INCREMENT COMMENT 'ID',
    `navigation_id` BIGINT(10) 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', '手表品牌', '/article?category_id=1'),
        (2, 'zh', '劳力士', '/article?category_id=2'),
        (3, 'zh', '万国', '/article?category_id=3'),
        (4, 'zh', '沛纳海', '/article?category_id=4'),
        (5, 'zh', '爱彼', '/article?category_id=5'),
    (1, 'en', 'Product', '/article?category_id=1'),
        (2, 'en', 'Rolex', '/article?category_id=2'),
        (3, 'en', 'IWC', '/article?category_id=3'),
        (4, 'en', 'Panerai', '/article?category_id=4'),
        (5, 'en', 'Audemars Piguet', '/article?category_id=5'),
    (41, 'zh', '品牌世界', '/page/brand'),
    (41, 'en', 'Brand', '/page/brand'),
    (42, 'zh', '新闻资讯', '/article?category_id=41'),
    (42, 'en', 'New', '/article?category_id=41'),
    (43, 'zh', '客户服务', '/page/service'),
    (43, 'en', 'Service', '/page/service'),
    (44, 'zh', '关于我们', '/page/about'),
    (44, 'en', 'About', '/page/about'),
    (45, 'zh', '联系我们', '/page/contact'),
    (45, 'en', 'Contact', '/page/contact')
;