/**
    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 '链接',
        `link_start_with` text COMMENT '链接匹配路径'
    ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='导航翻译表';

    INSERT INTO cms_navigation_i18n(navigation_id, language, navigation_name, link, link_start_with) VALUES
        (1, 'zh', '首页', '/', null),
        (1, 'zh-tw', '首頁', '/', null),
        (1, 'en', 'Home', '/', null),
        (2, 'zh', '关于我们', '/page/about', null),
        (2, 'zh-tw', '關於我們', '/page/about', null),
        (2, 'en', 'About', '/page/about', null),
        (3, 'zh', '资讯中心', '/article/list', '/article'),
        (3, 'zh-tw', '資訊中心', '/article/list', '/article'),
        (3, 'en', 'Article', '/article/list', '/article'),
        (3, 'zh', '联系我们', '/page/contact', null),
        (3, 'zh-tw', '聯絡我們', '/page/contact', null),
        (3, 'en', 'Concat us', '/page/contact', null)
    ;